$arrayMaintenance['Maintenance'][$key]['user'] = $arrayUser[$k]['id'];
}
}
foreach ($arrayProject as $e => $q) {
if ($arrayMaintenance['Maintenance'][$key]['project_type'] == $arrayProject[$e]['project_type']) {
$arrayMaintenance['Maintenance'][$key]['project_type'] = $arrayProject[$e]['id'];
}
}
//echo $databaseWork->checkExistRow($arrayMaintenance['Maintenance'][$key]) . '<br />';
$arrayToSelect['project_no'] = $arrayMaintenance['Maintenance'][$key]['project_no'];
$arrayToSelect['project_type'] = $arrayMaintenance['Maintenance'][$key]['project_type'];
$arrayToSelect['project_name'] = $arrayMaintenance['Maintenance'][$key]['project_name'];
$arrayToSelect['work_date'] = $arrayMaintenance['Maintenance'][$key]['work_date'];
//$arrayToSelect['user'] = $arrayMaintenance['Maintenance'][$key]['user'];
if ($databaseWork->checkExistRow($arrayToSelect) == 1) {
$arrayIdMaintenance = $databaseWork->returnID($arrayToSelect);
if (!empty($arrayIdMaintenance)) {
$databaseWork->update($arrayMaintenance['Maintenance'][$key], array(array('id', $arrayIdMaintenance[0]['id'], null)));
}
} else {
$databaseWork->insert($arrayMaintenance['Maintenance'][$key]);
}
}
}
}
//Import Newton Data
if (!empty($arrayNewton)) {
foreach ($arrayNewton['Newton'] as $key => $value) {
if (empty($arrayNewton['Newton'][$key])) {
unset($arrayNewton['Newton'][$key]);
} else {
$arrayMaintenance['Maintenance'][$key]['user'] = $arrayUser[$k]['id'];
}
}
foreach ($arrayProject as $e => $q) {
if ($arrayMaintenance['Maintenance'][$key]['project_type'] == $arrayProject[$e]['project_type']) {
$arrayMaintenance['Maintenance'][$key]['project_type'] = $arrayProject[$e]['id'];
}
}
//echo $databaseWork->checkExistRow($arrayMaintenance['Maintenance'][$key]) . '<br />';
$arrayToSelect['project_no'] = $arrayMaintenance['Maintenance'][$key]['project_no'];
$arrayToSelect['project_type'] = $arrayMaintenance['Maintenance'][$key]['project_type'];
$arrayToSelect['project_name'] = $arrayMaintenance['Maintenance'][$key]['project_name'];
$arrayToSelect['work_date'] = $arrayMaintenance['Maintenance'][$key]['work_date'];
$arrayToSelect['user'] = $arrayMaintenance['Maintenance'][$key]['user'];
if ($databaseWork->checkExistRow($arrayToSelect) == true) {
$arrayIdMaintenance = $databaseWork->returnID($arrayMaintenance['Maintenance'][$key]);
foreach ($arrayIdMaintenance as $key => $value) {
$arrayMaitenanceWhere[] = array('id', $value['id'], null);
}
$databaseWork->update($arrayMaintenance['Maintenance'][$key], $arrayMaitenanceWhere);
} else {
$databaseWork->insert($arrayMaintenance['Maintenance'][$key]);
}
}
}
//Import Newton Data
foreach ($arrayNewton['Newton'] as $key => $value) {
if (empty($arrayNewton['Newton'][$key])) {
unset($arrayNewton['Newton'][$key]);
} else {
$arrayNewton['Newton'][$key] = array_change_key_case($arrayNewton['Newton'][$key], CASE_LOWER);
