prepare( "INSERT INTO participants_list (
name,
document_id,
age,
email,
gender,
phone,
estate,
etnia,
date_activity,
disability_type,
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
if (isset($_FILES['info_process'])) {
$name_os = $_POST['os'];
if ( $xlsx = SimpleXLSX::parse( $_FILES['info_process']['tmp_name'] ) ) {
$array_fields_name = array();
foreach ($xlsx->rows() as $k => $fields){
if ($k == 0){
$array_fields_name = $fields;
continue; // skip first row
}
// param where | ID
$param = ( isset($fields[1]) ? $fields[1] : '' );
$dim = $xlsx->dimension();
$cols = $dim[0];
$array_fields = array();
$total_xlsx = $dim[1]-1;
// echo $param;
// return;
if( !empty($param) ){
$r = ParticipantsData::getRepeated($param);
if(isset($r)!=1){
// for ($i = 0; $i < $cols-1; $i ++) {
// $array_fields[] = ( isset($fields[ $i ]) ? $fields[ $i ] : '' );
// // echo ($i)."-- ".$array_fields[$i]." --".$array_fields[0]."
";
// // return;
// }
// $user_f_nacimiento = date("Y-m-d", strtotime($array_fields[11]));
// $user_fecha_servicio = date("Y-m-d", strtotime($array_fields[21]));
// $stmt_insert->bindParam(1, $array_fields[1]);
// $stmt_insert->bindParam(2, $array_fields[2]);
// $stmt_insert->bindParam(3, $array_fields[3]);
// $stmt_insert->bindParam(4, $array_fields[4]);
// $stmt_insert->bindParam(5, $array_fields[5]);
// $stmt_insert->bindParam(6, $array_fields[6]);
// $stmt_insert->bindParam(7, $array_fields[7]);
// $stmt_insert->bindParam(8, $array_fields[8]);
// $stmt_insert->bindParam(9, $array_fields[9]);
// $stmt_insert->bindParam(10, $array_fields[10]);
// $stmt_insert->bindParam(11, $user_f_nacimiento);
// $stmt_insert->bindParam(12, $array_fields[12]);
// $stmt_insert->bindParam(13, $array_fields[13]);
// $stmt_insert->bindParam(14, $array_fields[14]);
// $stmt_insert->bindParam(15, $array_fields[15]);
// $stmt_insert->bindParam(16, $array_fields[16]);
// $stmt_insert->bindParam(17, $array_fields[17]);
// $stmt_insert->bindParam(18, $array_fields[18]);
// $stmt_insert->bindParam(19, $array_fields[19]);
// $stmt_insert->bindParam(20, $array_fields[20]);
// $stmt_insert->bindParam(21, $user_fecha_servicio);
// $stmt_insert->bindParam(22, $name_os);
// $stmt_insert->execute();
// echo "Nuevo: DNI: ".$array_fields[5]." - ".$array_fields[3]."
";
echo "";
} else{
for ($i = 0; $i < $cols-1; $i ++) {
$array_fields[] = ( isset($fields[ $i+1 ]) ? $fields[ $i+1 ] : "" );
$val_field = ( isset($fields[ $i+1 ]) ? $fields[ $i+1 ] : "" );
$val_field = str_replace("'","",$val_field);
$data_field = $array_fields_name[$i+1];
// if ( $data_field == "user_f_nacimiento"){
// $val_field = date("Y-m-d", strtotime($val_field));
// }
// if ( $data_field == "user_fecha_servicio"){
// // forma de convertir string a date
// // $date = date_create($val_field);
// // $user_fecha_servicio = $date->format('Y-m-d');
// // Otra forma de convertir string a date
// $val_field = date("Y-m-d", strtotime($val_field));
// }
if ( $data_field != "id" && $data_field != "date_pub" ){
// echo "Actualizando: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";
// if ($data_field == "id_activity"){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
// if ($data_field == "line_action"){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
// if ($data_field == "report_type"){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "name_activity" && $val_field != $r->$data_field){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
// if ($data_field == "date_activity"){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
// if ($data_field == "estate"){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
// if ($data_field == "code_info"){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "name" && $val_field != $r->$data_field){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "lastname" && $val_field != $r->$data_field){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "document_id" && $val_field != $r->$data_field){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "age" && $val_field != $r->$data_field){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "gender" && $val_field != $r->$data_field){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "phone" && $val_field != $r->$data_field){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "email" && $val_field != $r->$data_field){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "etnia" && $val_field != $r->$data_field){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "disability_type" && $val_field != $r->$data_field){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "user_nationality" && $val_field != $r->$data_field){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "user_has_document" && $val_field != $r->$data_field){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
if ($data_field == "user_f_nacimiento" && $val_field != $r->$data_field." 00:00:00"){echo "Actualizado: $param > $data_field : ".$r->$data_field." -|POR|- $val_field
";$r->$data_field=$val_field;}
}
}
$r->update();
// echo "Update - ".$array_fields[2]."
";
echo "";
}
}
}
} else {
echo SimpleXLSX::parseError();
}
}
?>