<?php

header('Access-Control-Allow-Origin: *');
header('Content-Type: application/json,application/x-www-form-urlencoded,multipart/form-data');
header('Access-Control-Allow-Headers: Content-Type');
require 'lib/rb_conf.php';
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$inputFileType = 'Xlsx';
$inputFileName = 'product.template.xlsx';

$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
/** Load $inputFileName to a Spreadsheet Object  **/
$spreadsheet = $reader->load($inputFileName);

$sheet = $spreadsheet->getActiveSheet();

$hosp1 = R::load('hospital',1);

$hosp2 = R::load('hospital',2);

$hombre = R::load('gender',1);

$mujer = R::load('gender',2);

$white = R::load('color',1);

$black = R::load('color',2);


foreach ($sheet->getRowIterator(2) as $fila){
    $test_array = array();
    foreach ($fila->getCellIterator() as $celda){

        $valor = $celda->getValue();
        if($valor != null){
            array_push($test_array,$valor);
        }

    }
    if(count($test_array)  == 3){
        $m0107X = R::dispense('model');
        $m0107X->name = $test_array[1];
        $v = explode(" ", $test_array[1]);

        if(sizeof($v) == 5){
            $m0107X->type = $v[1];
            $m0107X->style = $test_array[2];
            if($v[2] == "CABA"){
                $m0107X->gender = $hombre;
            }
            elseif($v[2] == "DAMA"){
                $m0107X->gender = $mujer;
            }
            $brand = R::findOrCreate( 'brand', [
                'name' => $v[3]." ".$v[4]]);
            $m0107X->brand = $brand;
            $m0107X->secuencia = $test_array[0];
            $m0107X->sharedHospitalList = [$hosp1,$hosp2];
            $m0107X->sharedColorList = [$white,$black];
            R::store($m0107X);
        }
        elseif(sizeof($v) == 6){
            $m0107X->type = $v[1]." ".$v[2];
            $m0107X->style = $test_array[2];
            if($v[3] == "CABA"){
                $m0107X->gender = $hombre;
            }
            elseif($v[3] == "DAMA"){
                $m0107X->gender = $mujer;
            }
            $brand = R::findOrCreate( 'brand', [
                'name' => $v[4]." ".$v[5]]);
            $m0107X->brand = $brand;
            $m0107X->secuencia = $test_array[0];
            $m0107X->sharedHospitalList = [$hosp1,$hosp2];
            $m0107X->sharedColorList = [$white,$black];
            R::store($m0107X);
        }

    }
}

echo "Todo listo";