';
$reader = new Xlsx();
$workbook = $reader->load($_FILES['plantilla']["tmp_name"]);
$rowcount = $workbook->getActiveSheet()->getHighestDataRow();
// print 'rowcount::'.$rowcount.'::
';
$workbook->getActiveSheet()->getStyle('A1')
->getNumberFormat()
->setFormatCode(
\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DATETIME
);
$datos = array();
$xlsx = new Xlsx();
$info = $xlsx->listWorksheetinfo($_FILES['plantilla']["tmp_name"]);
$countcolumns = $info[0]['totalColumns'];
for($row = 2; $row <= $rowcount; $row++){
for($col = 1; $col <= $countcolumns; $col++) {
$val = $workbook->getActiveSheet()->getCellByColumnAndRow($col, $row)->getValue();
// if($col == 1 && $row > 2){
// // Funciona
// $date = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToTimestamp($val);
// $val = dol_print_date($date, "%Y-%m-%d %H:%M:%S");
// }
if(empty($val) && $val == "" && $col == 1){
break;
}
$datos[$row][$col] = $val;
}
}
if(is_array($datos) && count($datos) > 0){
print '
';
print '';
print '| ';
print $config->cargamasiva_catalogossat[$catalogo];
print ' | ';
print '
';
foreach ($datos as $key => $value) {
$codigo = $value[1];
$etiqueta = $value[2];
$estatus = $value[6];
$extrafields1 = '';
$extrafields2 = '';
$extrafields3 = '';
if(in_array($catalogo, $config->cargamasiva_table_extrafields1)){
$extrafields1 = $value[3];
}
if($catalogo == 'c_cfdimx_config_autotransporte'){
$extrafields2 = $value[4];
$extrafields3 = $value[5];
}
$config->createClaveDiccionario($catalogo, $codigo, $etiqueta, $estatus, $extrafields1, $extrafields2, $extrafields3);
}
print '';
print '| ';
print 'Proceso Terminado';
print ' | ';
print '
';
print '
';
if(count($config->cargamasiva_validaciones) > 0){
print '
';
print 'Detalle del Proceso de las Claves. ('.count($config->cargamasiva_validaciones).')
';
print implode("
", $config->cargamasiva_validaciones);
print '
';
}
}
print '