Example #1
0
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;
}
Example #2
0
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;
}