function save_project($forms) { global $DB, $AUTH; $obj = new xajaxResponse(); $blad = false; $form = $forms['projectdata']; $obj->script("removeClassId('id_division','alerts');"); $obj->assign("warn_division", "innerHTML", ""); $obj->script("removeClassId('id_states','alerts');"); $obj->assign("warn_states", "innerHTML", ""); $obj->script("removeClassId('id_program','alerts');"); $obj->assign("warn_program", "innerHTML", ""); $obj->script("removeClassId('id_action','alerts');"); $obj->assign("warn_action", "innerHTML", ""); $obj->script("removeClassId('id_contractdate','alerts');"); $obj->assign("warn_contractdate", "innerHTML", ""); $obj->script("removeClassId('id_fromdate','alerts');"); $obj->assign("warn_fromdate", "innerHTML", ""); $obj->script("removeClassId('id_todate','alerts');"); $obj->assign("warn_todate", "innerHTML", ""); $obj->script("removeClassId('id_value','alerts');"); $obj->assign("warn_value", "innerHTML", ""); $obj->script("removeClassId('id_ownvalue','alerts');"); $obj->assign("warn_ownvalue", "innerHTML", ""); $obj->script("removeClassId('id_status','alerts');"); $obj->assign("warn_status", "innerHTML", ""); $obj->script("removeClassId('id_number','alerts');"); $obj->assign("warn_number", "innerHTML", ""); $obj->script("removeClassId('id_contract','alerts');"); $obj->assign("warn_contract", "innerHTML", ""); $obj->script("removeClassId('id_name','alerts');"); $obj->assign("warn_name", "innerHTML", ""); $obj->script("removeClassId('id_title','alerts');"); $obj->assign("warn_title", "innerHTML", ""); $obj->script("removeClassId('id_scope','alerts');"); $obj->assign("warn_scope", "innerHTML", ""); if (empty($form['division'])) { $blad = true; $obj->script("addClassId('id_division','alerts');"); $obj->assign("warn_division", "innerHTML", trans("Dane wymagane")); } if (empty($form['states'])) { $blad = true; $obj->script("addClassId('id_states','alerts');"); $obj->assign("warn_states", "innerHTML", trans("Dane wymagane")); } if ($form['eu'] == 1) { if ($form['program'] == '-1') { $blad = true; $obj->script("addClassId('id_program','alerts');"); $obj->assign("warn_program", "innerHTML", "Dane wymagane"); } if ($form['action'] == '-1') { $blad = true; $obj->script("addClassId('id_action','alerts');"); $obj->assign("warn_action", "innerHTML", "Dane wymagane"); } if (empty($form['contractdate'])) { $blad = true; $obj->script("addClassId('id_contractdate','alerts');"); $obj->assign("warn_contractdate", "innerHTML", "Data wymagana"); } elseif (!check_date($form['contractdate'])) { $blad = true; $obj->script("addClassId('id_contractdate','alerts');"); $obj->assign("warn_contractdate", "innerHTML", "Błędnie podana data"); } else { $form['contractdate'] = str_replace('-', '/', $form['contractdate']); } if (empty($form['todate'])) { $blad = true; $obj->script("addClassId('id_todate','alerts');"); $obj->assign("warn_todate", "innerHTML", "Data wymagana"); } elseif (!check_date($form['todate'])) { $blad = true; $obj->script("addClassId('id_todate','alerts');"); $obj->assign("warn_todate", "innerHTML", "Błędnie podana data"); } else { $form['todate'] = str_replace('-', '/', $form['todate']); } if (empty($form['contract'])) { $blad = true; $obj->script("addClassId('id_contract','alerts');"); $obj->assign("warn_contract", "innerHTML", "Dane wymagane"); } else { if ($form['id']) { $isset = $DB->getOne('SELECT 1 FROM invprojects WHERE UPPER(contract) = ? AND id != ? ' . $DB->Limit(1) . ';', array(strtoupper($form['contract']), intval($form['id']))); } else { $isset = $DB->getOne('SELECT 1 FROM invprojects WHERE UPPER(contract) = ? ' . $DB->Limit(1) . ';', array(strtoupper($form['contract']))); } if ($isset) { $blad = true; $obj->script("addClassId('id_contract','alerts');"); $obj->assign("warn_contract", "innerHTML", "Podany numer umowy już istnieje"); } } if (empty($form['title'])) { $blad = true; $obj->script("addClassId('id_title','alerts');"); $obj->assign("warn_title", "innerHTML", "Dane wymagane"); } if (empty($form['scope'])) { $blad = true; $obj->script("addClassId('id_scope','alerts');"); $obj->assign("warn_scope", "innerHTML", "Dane wymagane"); } } else { // eu if (!empty($form['todate']) && !check_date($form['todate'])) { $blad = true; $obj->script("addClassId('id_todate','alerts');"); $obj->assign("warn_todate", "innerHTML", "Błędnie podana data"); } else { $form['todate'] = str_replace('-', '/', $form['todate']); } } if (!empty($form['fromdate']) && !check_date($form['fromdate'])) { $blad = true; $obj->script("addClassId('id_fromdate','alerts');"); $obj->assign("warn_fromdate", "innerHTML", "Błędnie podana data"); } else { $form['fromdate'] = str_replace('-', '/', $form['fromdate']); } $form['value'] = str_replace(',', '.', $form['value']); $form['ownvalue'] = str_replace(',', '.', $form['ownvalue']); if (!empty($form['value']) && !check_natural($form['value'])) { $blad = true; $obj->script("addClassId('id_value','alerts');"); $obj->assign("warn_value", "innerHTML", "Błędnie podana wartość"); } elseif (!empty($form['value']) && check_natural($form['value'])) { $obj->assign("id_value", "value", $form['value']); } if (!empty($form['ownvalue']) && !check_natural($form['ownvalue'])) { $blad = true; $obj->script("addClassId('id_ownvalue','alerts');"); $obj->assign("warn_ownvalue", "innerHTML", "Błędnie podana wartość"); } elseif (!empty($form['ownvalue']) && check_natural($form['ownvalue'])) { $obj->assign("id_ownvalue", "value", $form['ownvalue']); } if ($form['status'] == '-1') { $blad = true; $obj->script("addClassId('id_status','alerts');"); $obj->assign("warn_status", "innerHTML", "Wybierz status"); } if (empty($form['number'])) { $blad = true; $obj->script("addClassId('id_number','alerts');"); $obj->assign("warn_number", "innerHTML", "Numer jest wymagany"); } else { if ($form['id']) { $isset = $DB->getOne('SELECT 1 FROM invprojects WHERE UPPER(number) = ? AND id != ? ' . $DB->Limit(1) . ';', array(strtoupper($form['number']), intval($form['id']))); } else { $isset = $DB->getOne('SELECT 1 FROM invprojects WHERE UPPER(number) = ? ' . $DB->Limit(1) . ';', array(strtoupper($form['number']))); } if ($isset) { $blad = true; $obj->script("addClassId('id_number','alerts');"); $obj->assign("warn_number", "innerHTML", "Numer już istnieje"); } } if (empty($form['name'])) { $blad = true; $obj->script("addClassId('id_name','alerts');"); $obj->assign("warn_name", "innerHTML", "Nazwa projektu jest wymagana"); } else { if ($form['id']) { $isset = $DB->getOne('SELECT 1 FROM invprojects WHERE UPPER(name) = ? AND id != ? ' . $DB->limit(1) . ';', array(strtoupper($form['name']), intval($form['id']))); } else { $isset = $DB->getOne('SELECT 1 FROM invprojects WHERE UPPER(name) = ? ' . $DB->limit(1) . ';', array(strtoupper($form['name']))); } if ($isset) { $blad = true; $obj->script("addClassId('id_name','alerts');"); $obj->assign("warn_name", "innerHTML", "Podana nazwa już istnieje"); } } if (!$blad) { if (empty($form['contractdate'])) { $contractdate = 0; } else { $contractdate = strtotime($form['contractdate'] . ' 00:00:00'); } if (empty($form['fromdate'])) { $fromdate = 0; } else { $fromdate = strtotime($form['fromdate'] . ' 00:00:00'); } if (empty($form['todate'])) { $todate = 0; } else { $todate = strtotime($form['todate'] . ' 23:59:29'); } $title = str_replace("\n", " ", $form['title']); $scope = str_replace("\n", " ", $form['scope']); if (!$form['eu']) { $form['program'] = $form['action'] = $contractdate = 0; } if ($form['id']) { $DB->Execute('UPDATE invprojects SET name=?, number=?, contract=?, title=?, program=?, action=?, division=?, contractdate=?, fromdate=?, todate=?, states=?, scope=?, value=?, ownvalue=?, status=?, eu=?, description=?, siis=?, mdate=?, muser=? WHERE id = ?;', array($form['name'] ? $form['name'] : '', $form['number'] ? $form['number'] : '', $form['contract'] ? $form['contract'] : '', $title ? $title : '', $form['program'] ? $form['program'] : 0, $form['action'] ? $form['action'] : 0, $form['division'] ? $form['division'] : '', $contractdate ? $contractdate : 0, $fromdate ? $fromdate : 0, $todate ? $todate : 0, $form['states'] ? $form['states'] : '', $scope ? $scope : '', $form['value'] ? str_replace(',', '.', $form['value']) : '0.00', $form['ownvalue'] ? str_replace(',', '.', $form['ownvalue']) : '0.00', $form['status'] ? $form['status'] : 0, $form['eu'] ? 1 : 0, $form['description'] ? $form['description'] : '', $form['siis'] ? 1 : 0, time(), $AUTH->id, $form['id'])); } else { $DB->Execute('INSERT INTO invprojects (name, type, number, contract, title, program, action, division, contractdate, fromdate, todate, states, scope, value, ownvalue, status, eu, description, siis, cdate, mdate, cuser, muser) VALUES (?, 0, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, ?, 0) ;', array($form['name'] ? $form['name'] : '', $form['number'] ? $form['number'] : '', $form['contract'] ? $form['contract'] : '', $title ? $title : '', $form['program'] ? $form['program'] : 0, $form['action'] ? $form['action'] : 0, $form['division'] ? $form['division'] : '', $contractdate ? $contractdate : 0, $fromdate ? $fromdate : 0, $todate ? $todate : 0, $form['states'] ? $form['states'] : '', $scope ? $scope : '', $form['value'] ? str_replace(',', '.', $form['value']) : '0.00', $form['ownvalue'] ? str_replace(',', '.', $form['ownvalue']) : '0.00', $form['status'] ? $form['status'] : 0, $form['eu'] ? 1 : 0, $form['description'] ? $form['description'] : '', $form['siis'] ? 1 : 0, time(), $AUTH->id)); $form['id'] = $DB->getLastInsertId('invprojects'); } $obj->script("self.location.href='?m=projectinfo&id=" . $form['id'] . "';"); } return $obj; }
function saveevent($forms) { global $DB, $RE; $blad = false; $obj = new xajaxResponse(); $form = $forms['eventedit']; $obj->script("removeClassId('id_datazdarzenia','alerts');"); $obj->script("removeClassId('id_name','alerts');"); $obj->script("removeClassId('id_koszt','alerts');"); $obj->script("removeClassId('id_stanlicznika','alerts');"); $obj->script("removeClassId('id_litrow','alerts');"); $obj->assign("id_datazdarzenia_alerts", "innerHTML", ""); $obj->assign("id_name_alerts", "innerHTML", ""); $obj->assign("id_koszt_alerts", "innerHTML", ""); $obj->assign("id_stanlicznika_alerts", "innerHTML", ""); $obj->assign("id_litrow_alerts", "innerHTML", ""); if (empty($form['datazdarzenia'])) { $obj->script("addClassId('id_datazdarzenia','alerts');"); $obj->assign("id_datazdarzenia_alerts", "innerHTML", "Proszę podać datę"); $blad = true; } else { $form['datazdarzenia'] = str_replace('-', '/', $form['datazdarzenia']); $form['datazdarzenia'] = str_replace('.', '/', $form['datazdarzenia']); $form['datazdarzenia'] = str_replace(',', '/', $form['datazdarzenia']); $form['datazdarzenia'] = str_replace(' ', '/', $form['datazdarzenia']); $obj->assign("id_datazdarzenia", "value", $form['datazdarzenia']); if (!check_date($form['datazdarzenia'])) { $obj->script("addClassId('id_datazdarzenia','alerts');"); $obj->assign("id_datazdarzenia_alerts", "innerHTML", "Błędnie podano datę"); $blad = true; } } if (empty($form['name'])) { $obj->script("addClassId('id_name','alerts');"); if (get_conf('registryequipment.car_eventdic', 0)) { $obj->assign("id_name_alerts", "innerHTML", "Proszę wybrać zdarzenie z listy"); } else { $obj->assign("id_name_alerts", "innerHTML", "Proszę podać nazwę zdarzenia"); } $blad = true; } if ($form['eventid']) { $eid = $form['eventid']; $mus = $DB->GetRow('SELECT licznik, koszt, paliwo FROM re_dictionary_event WHERE id = ? LIMIT 1;', array($eid)); } else { $mus['licznik'] = $mus['koszt'] = $mus['paliwo'] = FALSE; } $form['koszt'] = str_replace(',', '.', $form['koszt']); if ($mus['koszt'] && (empty($form['koszt']) || !check_natural($form['koszt'])) || !empty($form['koszt']) && !check_natural($form['koszt'])) { $blad = true; $obj->script("addClassId('id_koszt','alerts');"); $obj->assign("id_koszt_alerts", "innerHTML", "Brak lub błędnie podano Koszt"); } else { $obj->assign("id_koszt", "value", $form['koszt']); } if ($mus['licznik'] && (empty($form['stanlicznika']) || !intval($form['stanlicznika'])) || !empty($form['licznik']) && !intval($form['licznik'])) { $blad = true; $obj->script("addClassId('id_stanlicznika','alerts');"); $obj->assign("id_stanlicznika_alerts", "innerHTML", "Brak lub błędnie podano stan licznika"); } if (!empty($form['litrow'])) { $form['litrow'] = str_replace(',', '.', $form['litrow']); } if ($mus['paliwo'] && (empty($form['litrow']) || !check_natural($form['litrow'])) || !empty($form['litrow']) && !check_natural($form['litrow'])) { $blad = true; $obj->script("addClassId('id_litrow','alerts');"); $obj->assign("id_litrow_alerts", "innerHTML", "Brak lub błędnie podano ilość paliwa"); } else { $obj->assign("id_litrow", "value", $form['litrow']); } if (!$blad) { if ($form['id']) { $RE->UpdateEvent($form); } else { $RE->AddEvent($form); } $obj->script("self.location.href='?m=re_carinfo&tuck=event&idc=" . $form['idc'] . "';"); } return $obj; }