<?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';
R::fancyDebug(FALSE);
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
set_time_limit(5000);

$inputFileType = 'Xlsx';
$inputFileName = 'hospitales.xlsx';

$hosp_arr = array();

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

$sheet = $spreadsheet->getActiveSheet();

foreach ($sheet->getRowIterator(3) 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){

        $esp_x =  explode("- ",$test_array[2]);
        unset($esp_x[0]);
        $hosp_arr[] = [$test_array[0],$test_array[1],$esp_x];

    }
}

foreach ($hosp_arr as $hospital){
   $hosp_bean = R::findOrCreate( 'hospital', ['name' => $hospital[0]]);
   $area_bean = R::findOrCreate( 'area', ['name' => $hospital[1],'hospital'=>$hosp_bean]);

   foreach ($hospital[2] as $posicion){
       $especialidad_bean = R::findOrCreate( 'position', ['name' => $posicion,'area'=>$area_bean]);
   }
}

echo "Todo listo";