function C_REPORT(&$My_POST, &$DB, $XML_Variants, $grup) { global $braki; global $VIKA_braki; global $LVM_braki; global $VIKA_LVM_braki; global $sugas; global $lang; global $translate; if ($lang != "RUS") { $lang = "LAT"; } $this->DB = $DB; $this->XML_Variants = $XML_Variants; $this->sugas = $sugas; $this->MyPOST = $My_POST; $this->grup = $grup; if (strrpos($this->MyPOST['pavadzime'], "KRVII") === false) { $this->braki = $braki; $LVM_braki = $VIKA_LVM_braki; } else { $this->braki = $braki; } $this->XMLVARS(); $this->SetParam(); $this->mtipi['auto'] = $translate['auto_nr2'][$lang]; $this->mtipi['brakis'] = $translate['brakis'][$lang]; $this->mtipi['cenu_matrica'] = $translate['cenu_matrica2'][$lang]; $this->mtipi['kad_piegad'] = $translate['datums2'][$lang]; $this->mtipi['mind_pirms_red'] = $translate['diametrs2'][$lang]; $this->mtipi['fsc'] = $translate['fsc2'][$lang]; // $this->mtipi['garums'] = $translate['garums2'][$lang]; $this->mtipi['kravas_id'] = $translate['kravas_id2'][$lang]; $this->mtipi['nelss_pavadzime.pavadzime'] = $translate['pavadzime2'][$lang]; $this->mtipi['piegad_kods'] = $translate['piegadatajs2'][$lang]; $this->mtipi['soferis'] = $translate['soferis2'][$lang]; $this->mtipi['suga'] = $translate['suga2'][$lang]; $this->mtipi['skira'] = $translate['skira2'][$lang]; $this->mtipi['iecirknis'] = $translate['iecirknis2'][$lang]; /* ----------------------------------------------------------------------------------------------- Nepieciešams, lai veidot XML failus! if($_SERVER['REQUEST_METHOD']=='POST' && $this->XML_Variants) { if(trim($this->MyPOST['pieg_lig_num'])=='') $this->ERRORS.= "Nav norādīts PIEGĀDES LĪGUMA numurs!<br><br>"; if(trim($this->MyPOST['pavadzime'])!='') { if (!GetFromPavadzimeAKRS($this->MyPOST['pavadzime'],'pavadzime') ) $this->ERRORS .= "Norādīts NEEKSISTĒJOŠS PAVADZĪMES numurs!<br><br>"; } else $this->ERRORS .= "Nav norādīts PAVADZĪMES numurs!<br><br>"; } */ if ($this->MyPOST[subm] && !$this->ERRORS) { // --------------------cik grup??anas l?me?i izmantoti ---------------------------- $this->lsk = 0; while ($this->MyPOST["gtype" . $this->grup . ($this->lsk + 1)] != '') { $this->lsk++; } // --------------------cik grup??anas l?me?i izmantoti ---------------------------- // Pārbauda vai nav vairāku pavazdīmju ar šādu numuru if ($this->MyPOST['pavadzime'] && !$this->MyPOST[pavadzime_id]) { $pav_test_query = "select count(*) as x from nelss_pavadzime where pavadzime = '" . trim($this->MyPOST['pavadzime']) . "'"; if ($this->MyPOST[datums_no] != '') { $pav_test_query = $pav_test_query . " and kad_piegad >= '" . $this->MyPOST[datums_no] . "' "; } if ($this->MyPOST[datums_lidz] != '') { $pav_test_query = $pav_test_query . " and kad_piegad <= '" . $this->MyPOST[datums_lidz] . "' "; } $r = $this->DB->query($pav_test_query); if ($m = $this->DB->get_row($r)) { if ($m[x] > 1) { $this->ERRORS .= "<font color=red>Eksistē " . $m[x] . " pavadzīmes ar numuru " . $this->MyPOST['pavadzime'] . "!</font><br><br>"; } } } //$query = " from balkis,pavadzime where nelss_balkis.pavadzime = nelss_pavadzime.id "; if ($this->MyPOST[datums_no_diena] != '' || $this->MyPOST[pavadzime_id]) { // $query = " from balkis_temp INNER JOIN nelss_pavadzime ON nelss_balkis_temp.pavadzime = nelss_pavadzime.id WHERE 1=1 "; } else { $query = " from balkis INNER JOIN nelss_pavadzime ON nelss_balkis.pavadzime = nelss_pavadzime.id WHERE 1=1 "; } // nosac?jumi if ($this->MyPOST[datums_no_diena] != '') { $query = $query . " and kad_piegad >= '" . $this->MyPOST[datums_no_gads] . "-" . $this->MyPOST[datums_no_menesis] . "-" . $this->MyPOST[datums_no_diena] . "' "; } if ($this->MyPOST[datums_lidz_diena] != '') { $query = $query . " and kad_piegad <= '" . $this->MyPOST[datums_lidz_gads] . "-" . $this->MyPOST[datums_lidz_menesis] . "-" . $this->MyPOST[datums_lidz_diena] . "' "; } if ($this->MyPOST[piegad_grupa]) { $query = $query . " and nelss_pavadzime.piegad_grupa like '" . $this->MyPOST[piegad_grupa] . "%'"; } if ($this->MyPOST[piegadataju_kods]) { $query = $query . " and nelss_pavadzime.piegadataju_kods = " . $this->MyPOST[piegadataju_kods]; } if ($this->MyPOST[pavadzime]) { $query = $query . " and nelss_pavadzime.pavadzime = '" . $this->MyPOST[pavadzime] . "'"; } if ($this->MyPOST[pavadzime_id]) { $query = $query . " and nelss_pavadzime.id = '" . $this->MyPOST[pavadzime_id] . "'"; } if ($this->MyPOST[suga] != '') { $query = $query . " and suga = '" . $this->MyPOST[suga] . "'"; } if ($this->MyPOST[cirsmas_kods] != '') { $query = $query . " and cirsmas_kods like '" . $this->MyPOST[cirsmas_kods] . "'"; } if ($this->MyPOST[brakis] != '') { $query = $query . " and brakis = '" . $this->MyPOST[brakis] . "'"; } if ($this->MyPOST[fsc] != '') { $query = $query . " and fsc = '" . $this->MyPOST[fsc] . "'"; } if ($this->MyPOST[kravas_id]) { $query = $query . " and kravas_id = '" . $this->MyPOST[kravas_id] . "'"; } if ($this->MyPOST[auto]) { $query = $query . " and auto = '" . $this->MyPOST[auto] . "'"; } if ($this->MyPOST[soferis]) { $query = $query . " and soferis = '" . $this->MyPOST[soferis] . "'"; } if ($this->MyPOST[cenu_matrica]) { $query = $query . " and cenu_matrica = '" . $this->MyPOST[cenu_matrica] . "'"; } if ($this->MyPOST[skira]) { $query = $query . " and skira = '" . $this->MyPOST[skira] . "'"; } if (trim($this->MyPOST['batch_fails']) != '') { $query = $query . " and batch_fails in(" . $this->MyPOST[batch_fails] . ")"; } if (trim($this->MyPOST['iecirknis_pieg']) != '') { $query = $query . " and LOWER(iecirknis_pieg)=LOWER('" . trim($this->MyPOST['iecirknis_pieg']) . "')"; } $query2 = str_replace("nelss_balkis_temp", "balkis", $query); if ($this->MyPOST[datums_no_diena] != '') { $this->DB->query("DELETE FROM nelss_balkis_temp"); $this->DB->query("INSERT INTO nelss_balkis_temp (SELECT nelss_balkis.* " . $query2 . ")"); $query = " from nelss_balkis_temp INNER JOIN nelss_pavadzime ON nelss_balkis_temp.pavadzime = nelss_pavadzime.id WHERE 1=1 "; } if ($this->MyPOST[pavadzime]) { $this->DB->query("DELETE FROM balkis_temp"); $this->DB->query("INSERT INTO balkis_temp (SELECT nelss_balkis.* " . $query2 . ")"); //Pievienoju pārbaudi uz baļķu esamību pavadzīmē 2010-03-09, Ervīns if (mysql_affected_rows() == 0) { $this->ERRORS .= "<font color=red>Pavadzīmē " . $this->MyPOST['pavadzime'] . " nav neviens baļķis!</font><br><br>"; return false; } $query = " from nelss_balkis_temp INNER JOIN nelss_pavadzime ON nelss_balkis_temp.pavadzime = nelss_pavadzime.id WHERE 1=1 "; } $rtest = $this->DB->query("select count(*) as x " . $query); if ($m = $this->DB->get_row($rtest)) { if ($m[x] > 1) { $correct_count = $m[x]; } else { $correct_count = 0; } } $this->arr[-1] = array(); // izejas masīva headeri if ($this->XML_Variants) { $diam__ = false; // p?rbaudei vai vajadz?g?s grup??anas XML atskaitei iesl?gtas $gar__ = false; } // pirmās kolonnas atskaitei ko izvēlējies lietotājs //var_dump($this->MyPOST); //print_r($this->MyPOST); for ($i = 0; $i < $this->lsk; $i++) { $this->arr[-1][$i] = $this->mtipi[$this->MyPOST["gtype" . $this->grup . ($i + 1)]]; if ($this->XML_Variants) { //echo "<br>gtype".($i+1)." gvalues".($i+1)." gvalues".($i+1)."_1"." gvalues".($i+1)."_2"; $this->arr[-1][$i] = $this->MyPOST["gtype" . $this->grup . ($i + 1)]; if ($this->MyPOST["gtype" . $this->grup . ($i + 1)] == 'mind_pirms_red') { //echo '****************mind_pirms_red*************'; $this->MyPOST["gvalues" . $this->grup . ($i + 1)] = LVM_distribution($this->MyPOST["gvalues" . $this->grup . ($i + 1)]); $this->MyPOST["gvalues" . $this->grup . ($i + 1) . "_1"] = LVM_distribution($this->MyPOST["gvalues" . $this->grup . ($i + 1) . "_1"]); $this->MyPOST["gvalues" . $this->grup . ($i + 1) . "_2"] = LVM_distribution($this->MyPOST["gvalues" . $this->grup . ($i + 1) . "_2"]); //echo "<br> IN mind_pirms_red "."gtype".($i+1)."invalue [".(($this->MyPOST["gvalues".($i+1)]) || ($this->MyPOST["gvalues".($i+1)."_1"]) || ($this->MyPOST["gvalues".($i+1)."_2]"]))."]"; if ($this->MyPOST["gvalues" . $this->grup . ($i + 1)] || $this->MyPOST["gvalues" . $this->grup . ($i + 1) . "_1"] || $this->MyPOST["gvalues" . $this->grup . ($i + 1) . "_2"]) { //echo "<br> IN "."gvalues".($i+1); $diam__ = true; } } if ($this->MyPOST["gtype" . $this->grup . ($i + 1)] == 'garums') { $gar__ = true; } if ($this->MyPOST["gtype" . $this->grup . ($i + 1)] == 'brakis') { $brak__ = true; } } else { if ($this->MyPOST["gtype" . $this->grup . ($i + 1)] == "nelss_pavadzime.pavadzime") { $this->arr[-1][$i] = $this->mtipi['nelss_pavadzime.pavadzime']; } //kaut k?ds exception } } //print_r($this->MyPOST); // pēdējās kolonnas kas visām atskaitēm vienādas $this->arr[-1][$i] = $translate['skaits'][$lang]; $i++; $this->arr[-1][$i] = $translate['bruto'][$lang] . " m3"; $i++; // $this->arr[-1][$i]= $translate['virsmers'][$lang]." m3"; // $i++; // $this->arr[-1][$i]= $translate['redukcija'][$lang]." m3"; // $i++; $this->arr[-1][$i] = $translate['brakis'][$lang] . " m3"; $i++; $this->arr[-1][$i] = $translate['neto'][$lang] . " m3"; $i++; // $i - tagad kolonnu skaits // //$this->arr[-1] - kolonnu nosaukumi un izvad?m? inform?cija atskait? v?l?k. $this->arr[-1][$i] = "Kopsumma m3"; $i++; // $i - tagad kolonnu skaits // $this->rowclosed = true; $summa = new CSumma(); $this->arr_index = 0; // $query - satur nosac?jumus,kas jaliek gala katram selektam, nosacijumi izveidoti no formas Nosacijumiem if (!$this->ERRORS) { // rekurs?v?s funkcijas izsaukums $this->print_level(1, $query, $summa, false, 0, ''); } // echo $query; // kopsumma ++$this->arr_index; $this->arr[$this->arr_index] = array(); $this->arr[$this->arr_index][-1] = $translate['v_kopa'][$lang]; $this->arr[$this->arr_index][summa] = $summa; if ($this->XML_Variants) { if (!$gar__) { $this->ERRORS .= "Kļūda! Netiek izmantota grupēšana pēc GARUMA!<br><br>"; } if (!$diam__) { $this->ERRORS .= "Kļūda! Netiek izmantota grupēšana pēc DIAMETRA vai arī garuma intervālu robežas neatbilst standartam!<br><br>"; } if (!$brak__) { $this->ERRORS .= "Kļūda! Netiek izmantota grupēšana pēc BRĀĶA!<br><br>"; } //labots sakarā ar vairākām grupēšanām XML atskaitē $this->arr[$this->arr_index][correct_count] = $correct_count; //if ($correct_count != $summa->skaits) $this->ERRORS.= "Kļūda grupēšanā! Sagrupēti ".(int)$summa->skaits." baļķi no $correct_count.<br><br>"; } } //$this->ErrorCheck(); // if ($this->ERRORS) { return false; } }
function C_REPORT(&$My_POST, &$DB, $XML_Variants) { global $braki; global $sugas; global $VIKA_braki; global $LVM_braki; global $VIKA_LVM_braki; $this->DB = $DB; $this->XML_Variants = $XML_Variants; $this->sugas = $sugas; $this->MyPOST = $My_POST; if (strrpos($this->MyPOST['pavadzime'], "KRVII") === false) { $this->braki = $VIKA_braki; $LVM_braki = $VIKA_LVM_braki; } else { $this->braki = $braki; } $this->XMLVARS(); $this->SetParam(); $this->mtipi['auto'] = "Auto nr"; $this->mtipi['brakis'] = "Brāķis"; $this->mtipi['cenu_matrica'] = "Cenu matrica"; $this->mtipi['kad_piegad'] = "Datums"; $this->mtipi['mind_pirms_red'] = "Diametrs"; $this->mtipi['fsc'] = "FSC"; $this->mtipi['garums'] = "Garums"; $this->mtipi['kravas_id'] = "Kravas ID"; $this->mtipi['pavadzime.pavadzime'] = "Pavadzīme"; $this->mtipi['piegad_kods'] = "Piegādātājs"; $this->mtipi['soferis'] = "Šoferis"; $this->mtipi['suga'] = "Suga"; $this->mtipi['skira'] = "Šķira"; $this->mtipi['iecirknis'] = "Iecirknis"; if ($_SERVER['REQUEST_METHOD'] == 'POST' && $this->XML_Variants) { if (trim($this->MyPOST['pieg_lig_num']) == '') { $this->ERRORS .= "Nav norādīts PIEGĀDES LĪGUMA numurs!<br><br>"; } if (trim($this->MyPOST['pavadzime']) != '') { if (!GetFromPavadzime($this->MyPOST['pavadzime'], 'pavadzime')) { $this->ERRORS .= "Norādīts NEEKSISTĒJOŠS PAVADZĪMES numurs!<br><br>"; } } else { $this->ERRORS .= "Nav norādīts PAVADZĪMES numurs!<br><br>"; } } if ($this->MyPOST[subm] && !$this->ERRORS) { // --------------------cik grup??anas l?me?i izmantoti ---------------------------- $this->lsk = 0; while ($this->MyPOST["gtype" . ($this->lsk + 1)] != '') { $this->lsk++; } // --------------------cik grup??anas l?me?i izmantoti ---------------------------- // Pārbauda vai nav vairāku pavazdīmju ar šādu numuru if ($this->MyPOST['pavadzime'] && !$this->MyPOST[pavadzime_id]) { $pav_test_query = "select count(*) as x from pavadzime where pavadzime = '" . trim($this->MyPOST['pavadzime']) . "'"; if ($this->MyPOST[datums_no] != '') { $pav_test_query = $pav_test_query . " and kad_piegad >= '" . $this->MyPOST[datums_no] . "' "; } if ($this->MyPOST[datums_lidz] != '') { $pav_test_query = $pav_test_query . " and kad_piegad <= '" . $this->MyPOST[datums_lidz] . "' "; } $r = $this->DB->query($pav_test_query); if ($m = $this->DB->get_row($r)) { if ($m[x] > 1) { $this->ERRORS .= "<font color=red>Eksistē " . $m[x] . " pavadzīmes ar numuru " . $this->MyPOST['pavadzime'] . "!</font><br><br>"; } } } $query = " from balkis,pavadzime where balkis.pavadzime = pavadzime.id "; // nosac?jumi if ($this->MyPOST[datums_no_diena] != '') { $query = $query . " and kad_piegad >= '" . $this->MyPOST[datums_no_gads] . "-" . $this->MyPOST[datums_no_menesis] . "-" . $this->MyPOST[datums_no_diena] . "' "; } if ($this->MyPOST[datums_lidz_diena] != '') { $query = $query . " and kad_piegad <= '" . $this->MyPOST[datums_lidz_gads] . "-" . $this->MyPOST[datums_lidz_menesis] . "-" . $this->MyPOST[datums_lidz_diena] . "' "; } if ($this->MyPOST[piegad_grupa]) { $query = $query . " and pavadzime.piegad_grupa like '" . $this->MyPOST[piegad_grupa] . "%'"; } if ($this->MyPOST[pavadzime]) { $query = $query . " and pavadzime.pavadzime = '" . $this->MyPOST[pavadzime] . "'"; } if ($this->MyPOST[pavadzime_id]) { $query = $query . " and pavadzime.id = '" . $this->MyPOST[pavadzime_id] . "'"; } if ($this->MyPOST[suga] != '') { $query = $query . " and suga = '" . $this->MyPOST[suga] . "'"; } if ($this->MyPOST[cirsmas_kods] != '') { $query = $query . " and cirsmas_kods like '" . $this->MyPOST[cirsmas_kods] . "'"; } if ($this->MyPOST[brakis] != '') { $query = $query . " and brakis = '" . $this->MyPOST[brakis] . "'"; } if ($this->MyPOST[fsc] != '') { $query = $query . " and fsc = '" . $this->MyPOST[fsc] . "'"; } if ($this->MyPOST[kravas_id]) { $query = $query . " and kravas_id = '" . $this->MyPOST[kravas_id] . "'"; } if ($this->MyPOST[auto]) { $query = $query . " and auto = '" . $this->MyPOST[auto] . "'"; } if ($this->MyPOST[soferis]) { $query = $query . " and soferis = '" . $this->MyPOST[soferis] . "'"; } if ($this->MyPOST[cenu_matrica]) { $query = $query . " and cenu_matrica = '" . $this->MyPOST[cenu_matrica] . "'"; } if ($this->MyPOST[skira]) { $query = $query . " and skira = '" . $this->MyPOST[skira] . "'"; } if (trim($this->MyPOST['batch_fails']) != '') { $query = $query . " and batch_fails in(" . $this->MyPOST[batch_fails] . ")"; } if (trim($this->MyPOST['iecirknis_pieg']) != '') { $query = $query . " and LOWER(iecirknis_pieg)=LOWER('" . trim($this->MyPOST['iecirknis_pieg']) . "')"; } $rtest = $this->DB->query("select count(*) as x " . $query); if ($m = $this->DB->get_row($rtest)) { if ($m[x] > 1) { $correct_count = $m[x]; } else { $correct_count = 0; } } $this->arr[-1] = array(); // izejas masīva headeri if ($this->XML_Variants) { $diam__ = false; // p?rbaudei vai vajadz?g?s grup??anas XML atskaitei iesl?gtas $gar__ = false; } // pirmās kolonnas atskaitei ko izvēlējies lietotājs for ($i = 0; $i < $this->lsk; $i++) { $this->arr[-1][$i] = $this->mtipi[$this->MyPOST["gtype" . ($i + 1)]]; if ($this->XML_Variants) { $this->arr[-1][$i] = $this->MyPOST["gtype" . ($i + 1)]; if ($this->MyPOST["gtype" . ($i + 1)] == 'mind_pirms_red') { $this->MyPOST["gvalues" . ($i + 1)] = LVM_distribution($this->MyPOST["gvalues" . ($i + 1)]); $this->MyPOST["gvalues" . ($i + 1) . "_1"] = LVM_distribution($this->MyPOST["gvalues" . ($i + 1) . "_1"]); $this->MyPOST["gvalues" . ($i + 1) . "_2"] = LVM_distribution($this->MyPOST["gvalues" . ($i + 1) . "_2"]); if ($this->MyPOST["gvalues" . ($i + 1)] || $this->MyPOST["gvalues" . ($i + 1) . "_1"] || $this->MyPOST["gvalues" . ($i + 1) . "_2]"]) { $diam__ = true; } } if ($this->MyPOST["gtype" . ($i + 1)] == 'garums') { $gar__ = true; } if ($this->MyPOST["gtype" . ($i + 1)] == 'brakis') { $brak__ = true; } } else { if ($this->MyPOST["gtype" . ($i + 1)] == "pavadzime.pavadzime") { $this->arr[-1][$i] = $this->mtipi['pavadzime.pavadzime']; } //kaut k?ds exception } } // pēdējās kolonnas kas visām atskaitēm vienādas $this->arr[-1][$i] = "Skaits"; $i++; $this->arr[-1][$i] = "Bruto m3"; $i++; //$this->arr[-1][$i]="Virsmērs m3"; //$i++; //$this->arr[-1][$i]="Redukcija m3"; //$i++; //$this->arr[-1][$i]="Brāķis m3"; //$i++; //$this->arr[-1][$i]="Neto m3"; //$i++; // $i - tagad kolonnu skaits // //$this->arr[-1] - kolonnu nosaukumi un izvad?m? inform?cija atskait? v?l?k. $this->rowclosed = true; $summa = new CSumma(); $this->arr_index = 0; // $query - satur nosac?jumus,kas jaliek gala katram selektam, nosacijumi izveidoti no formas Nosacijumiem if (!$this->ERRORS) { // rekurs?v?s funkcijas izsaukums $this->print_level(1, $query, $summa, false, 0); } // kopsumma ++$this->arr_index; $this->arr[$this->arr_index] = array(); $this->arr[$this->arr_index][-1] = "Viss kopā"; $this->arr[$this->arr_index][summa] = $summa; if ($this->XML_Variants) { if (!$gar__) { $this->ERRORS .= "Kļūda! Netiek izmantota grupēšana pēc GARUMA!<br><br>"; } if (!$diam__) { $this->ERRORS .= "Kļūda! Netiek izmantota grupēšana pēc DIAMETRA vai arī garuma intervālu robežas neatbilst standartam!<br><br>"; } if (!$brak__) { $this->ERRORS .= "Kļūda! Netiek izmantota grupēšana pēc BRĀĶA!<br><br>"; } if ($correct_count != $summa->skaits) { $this->ERRORS .= "Kļūda grupēšanā! Sagrupēti " . (int) $summa->skaits . " baļķi no {$correct_count}.<br><br>"; } } } //$this->ErrorCheck(); // if ($this->ERRORS) { return false; } }