Exemplo n.º 1
0
function ieraksts_skatits_zagbalki($skatits_id)
{
    $tmpSQL_txt = "SELECT * FROM `zagbalki` WHERE `id` = {$skatits_id}";
    $tmpSQL = mysql_query($tmpSQL_txt);
    while ($tmpSQL_arr = mysql_fetch_assoc($tmpSQL)) {
        $tmp_kontrolmernieks = $tmpSQL_arr['kontrolmernieks'];
        $tmp_datums_sakums = dateFormatChange($tmpSQL_arr['started']);
        $tmp_pasutitajs = changeReciever($tmpSQL_arr['pasutitajs'], $tmpSQL_arr['viet_kods']);
        $tmp_piegadatajs = $tmpSQL_arr['piegadatajs'];
        $tmp_uzm_vieta = $tmpSQL_arr['viet_kods'];
        $tmp_pasut_nr = $tmpSQL_arr['pasnr'];
        $tmpSQL_data_txt = "SELECT * FROM `zagbalki_merijumi` WHERE `zagbalki_id` = {$skatits_id}";
        $tmpSQL_data = mysql_query($tmpSQL_data_txt);
        while ($tmpSQL_data_arr = mysql_fetch_assoc($tmpSQL_data)) {
            $rowIsTrue = true;
            $tmp_mernieks = $tmpSQL_data_arr['pg'];
            $tmp_balka_nr = $tmpSQL_data_arr['nr'];
            $tmp_suga = $tmpSQL_data_arr['sg'];
            $tmp_skira = $tmpSQL_data_arr['sk'];
            $tmp_miza = $tmpSQL_data_arr['mt'];
            $tmp_diam_tievgalis = $tmpSQL_data_arr['tc'];
            $tmp_diam_vidus = $tmpSQL_data_arr['vc'];
            $tmp_diam_resgalis = $tmpSQL_data_arr['rcc'];
            $tmp_garums = $tmpSQL_data_arr['gr'];
            $tmp_redukcija_diam = $tmpSQL_data_arr['rg'];
            $tmp_redukcija_gar = $tmpSQL_data_arr['rc'];
            $tmp_brakis = $tmpSQL_data_arr['im'];
            $tmp_kb_numurs = $tmpSQL_data_arr['kb'];
            $tmp_ts = dateFormatChange($tmpSQL_data_arr['ts']);
            $tmp_te = dateFormatChange($tmpSQL_data_arr['te']);
            if ($tmpSQL_arr['pasutitajs'] == '42') {
                $tmp_diam_resgalis = 0;
            }
            if ($tmpSQL_arr['pasutitajs'] == '25') {
                $tmp_diam_resgalis = 0;
            }
            if ($tmp_brakis === 'NULL') {
                $tmp_brakis = "";
            }
            if ($tmp_kb_numurs === 'NULL') {
                $tmp_kb_numurs = "";
            }
            if ($tmp_diam_vidus < 1 && $tmp_diam_tievgalis < 1 && $tmp_diam_resgalis < 1 && $tmp_mernieks < 1) {
                $rowIsTrue = false;
            }
            $tmpSQL_insert_txt = "INSERT INTO `kontrol_zagbalki` (`datums_sakums`, `kontrolmernieks`, `mernieks`, `pasutitajs`, `piegadatajs`, \n                            `uzm_vieta`, `pasut_nr`, `balka_nr`, `suga`, `skira`, `miza`, `diam_tievgalis`, `diam_vidus`, `diam_resgalis`, \n                            `garums`, `redukcija_diam`, `redukcija_gar`, `brakis`, `kb_numurs`,`ts`,`te`) \n                            VALUES ('{$tmp_datums_sakums}','{$tmp_kontrolmernieks}','{$tmp_mernieks}','{$tmp_pasutitajs}','{$tmp_piegadatajs}','{$tmp_uzm_vieta}',\n                            '{$tmp_pasut_nr}','{$tmp_balka_nr}','{$tmp_suga}','{$tmp_skira}','{$tmp_miza}','{$tmp_diam_tievgalis}','{$tmp_diam_vidus}','{$tmp_diam_resgalis}',\n                            '{$tmp_garums}','{$tmp_redukcija_diam}','{$tmp_redukcija_gar}','{$tmp_brakis}','{$tmp_kb_numurs}','{$tmp_ts}','{$tmp_te}')";
            //echo $tmpSQL_insert_txt;
            if ($rowIsTrue) {
                if (!mysql_query($tmpSQL_insert_txt)) {
                    $tmp_SendMySQLError = 'Kļūda DB izpildē: [#7000001][' . mysql_errno() . '] 
            ' . mysql_error() . '
            DB Query: ' . $tmpSQL_insert_txt;
                    snd_GlobalMailErr($tmp_SendMySQLError);
                    return false;
                }
            }
        }
    }
    $result = mysql_query("UPDATE `zagbalki` SET skatits=1 WHERE id=" . $skatits_id . "") or die(mysql_error());
    return true;
}
Exemplo n.º 2
0
     $_POST['head']['auto_head'] = $mpav['auto'];
 }
 if ($mpav['soferis']) {
     $_POST['head']['soferis_head'] = $mpav['soferis'];
 }
 if ($mpav['transport_firm']) {
     $_POST['head']['transport_firm'] = $mpav['transport_firm'];
 }
 if (trim($mpav['fsc']) != '') {
     $_POST['head']['fsc'] = $mpav['fsc'];
 }
 if ($mpav['kad_uzmer']) {
     $_POST['head']['kad_uzmer'] = dateFormatChange(substr($mpav['kad_uzmer'], 0, 10));
 }
 if ($mpav['kad_piegad']) {
     $_POST['head']['kad_piegad'] = dateFormatChange(substr($mpav['kad_piegad'], 0, 10));
 }
 if ($mpav['transp_darba_uzd']) {
     $_POST['head']['transp_darba_uzd'] = $mpav['transp_darba_uzd'];
 }
 if ($mpav['cirsmas_kods']) {
     $_POST['head']['cirsma_head'] = $mpav['cirsmas_kods'];
 }
 if ($mpav['iecirknis_pieg']) {
     $_POST['head']['iecirknis_head'] = $mpav['iecirknis_pieg'];
 }
 if ($_POST['vieta_head']) {
     $_POST['head']['vieta_head'] = $_POST['vieta_head'];
 }
 if ($_POST['custom12_head']) {
     $_POST['head']['custom12_head'] = $_POST['custom12_head'];