コード例 #1
0
 function print_level($level, $query, &$summa_p, $irbrakis_p, $suga, $id)
 {
     global $lang;
     global $translate;
     // tekošā grupēšanas līmeņa lauks
     $lauks = $this->MyPOST["gtype" . $this->grup . $level];
     ////////////////////////////////////////////////////////////////// JA IR DAL?JUMS PA SUG?M //////////////////
     if ($lauks == 'garums' || $lauks == 'mind_pirms_red' || $lauks == 'skira') {
         if ($this->MyPOST["dalit" . $this->grup . $level] && $suga) {
             // ja ir sadalījums pa sugām ņemam attiecīgo lauku
             $gvalues = "gvalues" . $this->grup . $level . "_" . $suga;
         } else {
             // ja nav tad ņemam kopīgo
             $gvalues = "gvalues" . $this->grup . $level;
         }
         // sadalam nepieciešamās vērtības
         //echo $this->MyPOST[$gvalues];
         $a = explode(',', $this->MyPOST[$gvalues]);
         $a = str_replace(' ', '', $a);
         // brāķis
         $abr = array();
         for ($i = 0; $i < count($a); $i++) {
             if (substr($a[$i], 0, 1) == 'b' || substr($a[$i], 0, 1) == 'B') {
                 $abr[$i] = '1';
                 //kursh masiva elements apzime braki
                 $a[$i] = substr($a[$i], 1);
                 //masiva elements bez B prieksa
             }
         }
     }
     ////////////////////////////////////////////////////////////////// JA IR DAL?JUMS PA SUG?M //////////////////
     if ($lauks == 'fsc') {
         $a = array();
         $a[0] = '0';
         $a[1] = '1';
         $typ = 'string';
     }
     if ($lauks == 'kad_piegad' || $lauks == 'auto' || $lauks == 'brakis' || $lauks == 'cenu_matrica' || $lauks == 'cirsmas_kods' || $lauks == 'kad_piegad' || $lauks == 'kravas_id' || $lauks == 'pavadzime.pavadzime' || $lauks == 'piegad_kods' || $lauks == 'soferis' || $lauks == 'suga' || $lauks == 'iecirknis' || $lauks == 'skira' && $a[0] == '' && sizeof($abr) == 0) {
         //no visiem atlas?tajiem ba??iem pavadz?m? atlasa attiec?g? lauka atrodam?s v?rt?bas (pa vienai)
         $a = array();
         $query__ = "select DISTINCT {$lauks} as lauks " . $query . " order by {$lauks} ";
         $r = $this->DB->query($query__);
         $ii = 0;
         while ($m = $this->DB->get_row($r)) {
             $a[$ii] = $m['lauks'];
             $ii++;
         }
         if ($lauks == 'brakis') {
             if ($a[count($a) - 1] == '255') {
                 for ($j = count($a) - 1; $j > 0; $j--) {
                     $a[$j] = $a[$j - 1];
                 }
                 $a[0] = '255';
             }
         }
         $typ = 'string';
     }
     $row = 0;
     $summa_p->init();
     $myid = 0;
     while (list($key, $val) = each($a)) {
         $myid++;
         if ($lauks == 'suga') {
             $suga = $val;
         }
         // virsm?ru sadal?jums
         if ($suga && $this->MyPOST['dalit_virsmeri' . $this->grup]) {
             if ($this->MyPOST['virsmeri' . $this->grup . '_' . $suga] != '') {
                 $virsmeri = explode(',', $this->MyPOST['virsmeri' . $this->grup . '_' . $suga]);
                 for ($i = 0; $i < count($virsmeri); $i++) {
                     $virsmeri[$i] = $virsmeri[$i] / 100;
                 }
             }
         } else {
             if ($this->MyPOST['virsmeri' . $this->grup] != '') {
                 $virsmeri = explode(',', $this->MyPOST['virsmeri' . $this->grup]);
                 for ($i = 0; $i < count($virsmeri); $i++) {
                     $virsmeri[$i] = $virsmeri[$i] / 100;
                 }
             }
         }
         if ($suga && $this->MyPOST['dalit_raukums' . $this->grup]) {
             $raukums = raukums_2_array($this->MyPOST['raukums' . $this->grup . '_' . $suga]);
         } else {
             $raukums = raukums_2_array($this->MyPOST['raukums' . $this->grup]);
         }
         if ($suga && $this->MyPOST['dalit_koeficients' . $this->grup]) {
             $koeficients = $this->MyPOST['koeficients' . $this->grup . '_' . $suga];
         } else {
             $koeficients = $this->MyPOST['koeficients' . $this->grup];
         }
         if ($typ != 'string') {
             $mbounds = explode('-', $a[$row]);
         }
         if (count($mbounds) > 1) {
             $low_range_brakis = 0;
             $high_range_brakis = 0;
             if ($mbounds[0] > 5) {
                 $low_range_brakis = $mbounds[0];
             } else {
                 $low_range_brakis = $mbounds[0];
             }
             if ($mbounds[1] < 994) {
                 $high_range_brakis = $mbounds[1];
             } else {
                 $high_range_brakis = $mbounds[1];
             }
             //pievienots 17.07.2007
             if ($this->MyPOST["gtype" . $this->grup . $level] == 'mind_pirms_red') {
                 $myquery = $query . " and  ((" . $this->MyPOST["gtype" . $this->grup . $level] . ">=" . $mbounds[0] . " and " . $this->MyPOST["gtype" . $this->grup . $level] . "<=" . $mbounds[1] . " AND balkis_temp.import_type <> 'zbm') or (" . $this->MyPOST["gtype" . $this->grup . $level] . ">=" . $low_range_brakis . " and " . $this->MyPOST["gtype" . $this->grup . $level] . "<=" . $high_range_brakis . " AND balkis_temp.import_type = 'zbm'))";
             } else {
                 $myquery = $query . " and  (" . $this->MyPOST["gtype" . $this->grup . $level] . ">=" . $mbounds[0] . " and " . $this->MyPOST["gtype" . $this->grup . $level] . "<=" . $mbounds[1] . ")";
             }
             //echo 'adding to query = ' . $query . " and  (". $this->MyPOST["gtype".$this->grup.$level] . ">=" . $mbounds[0] ." and " . $this->MyPOST["gtype".$this->grup.$level] . "<=" . $mbounds[1] . ")" . '<br />';
             //echo '$myquery = ' . $myquery . '<br />';
             //$myquery = $query . " and  (". $this->MyPOST["gtype".$this->grup.$level] . ">=" . $mbounds[0] ." and " . $this->MyPOST["gtype".$this->grup.$level] . "<=" . $mbounds[1] . ")";
         } else {
             if ($typ == 'string') {
                 $myquery = $query . " and  " . $this->MyPOST["gtype" . $this->grup . $level] . "='" . $a[$row] . "'";
             } else {
                 $myquery = $query . " and  " . $this->MyPOST["gtype" . $this->grup . $level] . "=" . $a[$row];
             }
         }
         $row = $row + 1;
         if ($this->rowclosed == true) {
             $this->rowclosed = false;
             $this->arr_index++;
             $this->arr[$this->arr_index] = array();
         }
         if ($level == 1) {
             $this->arr[$this->arr_index][0] = "";
         } else {
             if ($row > 1) {
                 for ($i = 1; $i < $level + 1; $i++) {
                     $this->arr[$this->arr_index][$i - 1] = "";
                 }
             }
         }
         $irbrakis = false;
         if ($irbrakis_p == true) {
             $irbrakis = true;
         }
         // Ja ir v?l dzi??ki l?me?i
         if ($level < $this->lsk) {
             if (!$val || $val == '') {
                 $this->arr[$this->arr_index][$level - 1] = "nav";
             } else {
                 $this->arr[$this->arr_index][$level - 1] = $this->kodi($this->MyPOST['gtype' . $this->grup . $level], $val);
             }
             $sum = new CSumma();
             if (strlen($abr[$key]) == 1) {
                 $irbrakis = true;
                 $brkods = $abr[$key];
             }
             //$rrow = mysql_query("select * from gatskaite where rowid = '".dig3($id).dig3($myid)."'");
             //if ($mrow = mysql_fetch_array($rrow))
             //{
             //	$saved = 1;
             //	$x = unserialize($mrow['data']);
             //	$sum = $x[summa];
             //}
             //else
             //{
             //}
             $this->print_level($level + 1, $myquery, $sum, $irbrakis, $suga, $id . $myid);
             /* Testa nolūkiem */
             // Te saskaita kop? par l?meni summu - XML varianta tas nav jadara
             if (!$this->XML_Variants) {
                 $this->arr_index++;
                 $this->arr[$this->arr_index] = array();
                 if ($sum->bruto) {
                     $this->arr[$this->arr_index][-1] = $translate['kopa'][$lang];
                     for ($i = 0; $i < $this->lsk; $i++) {
                         if ($level == $i + 1) {
                             $this->arr[$this->arr_index][$i] = $this->kodi($this->MyPOST['gtype' . $this->grup . $level], $val);
                         } else {
                             $this->arr[$this->arr_index][$i] = "";
                         }
                     }
                     if (!$this->MyPOST['negrupet']) {
                         $this->arr[$this->arr_index][summa] = $sum;
                     }
                     //echo "<tr><td height=1 colspan=".(7+$this->lsk)."><hr></tr>";
                 }
             }
             $this->rowclosed = true;
             if (!$this->MyPOST['negrupet']) {
                 $summa_p->add_skaits($sum->skaits);
                 $summa_p->add_skaits_bad($sum->skaits_bad);
                 $summa_p->add_virsmers($sum->virsmers);
                 $summa_p->add_redukcija_d($sum->redukcija_d);
                 $summa_p->add_redukcija_l($sum->redukcija_l);
                 $summa_p->add_brakis($sum->brakis);
                 $summa_p->add_neto($sum->neto);
                 $summa_p->add_bruto($sum->bruto);
                 //print_r($summa_p);
                 $this->lasttype = 'sum';
             }
             //$this->arr[$this->arr_index]['type']='sum';
             //$this->arr[$this->arr_index]['level']=$level;
             //$st = serialize($this->arr[$this->arr_index]);
             //if ($level==1)
             //	mysql_query("insert into gatskaite (rowid,data) values ('".dig3($myid)."','$st')");
             //else
             //	mysql_query("insert into gatskaite (rowid,data) values ('".dig3($id).dig3($myid)."','$st')");
         } else {
             $this->lasttype = 'data';
             ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////Saakums////////////////////////////////////////////////////////////////////////////////////
             if ($this->MyPOST['metode'] == '1') {
                 /*Query izvilksana*/
                 $query__ = "select balkis_temp.id as Ident, mind_pirms_red as DBruto, garums as LBruto, mind_pec_red as DPecReduc, gar_pec_red as LPecReduc, brakis, pavadzime.cenu_matrica as cm " . $myquery;
                 //      echo $query__.'<br /><br />';
                 $r = $this->DB->query($query__);
                 /*NULL vertibu ievietosana*/
                 $SVBruto = 0;
                 $SVReducD = 0;
                 $SVReducL = 0;
                 $SVVirsm = 0;
                 $SVNeto = 0;
                 $SVBrakis = 0;
                 $SSkaits = 0;
                 $SSkaitsBad = 0;
                 $gostu_tabula = $this->MyPOST['gostu_tabula' . $this->grup];
                 /*
                 */
                 while ($m = $this->DB->get_row($r)) {
                     $SSkaits++;
                     /*Vai ir Vika Wood*/
                     if ($suga && $this->MyPOST['dalit_virsmers' . $this->grup]) {
                         $min_virsmers = $this->MyPOST['virsmers' . $this->grup . '_' . $suga] / 100;
                     } else {
                         $min_virsmers = $this->MyPOST['virsmers' . $this->grup] / 100;
                     }
                     $Ident = $m['Ident'];
                     //        $LBruto = $m['LBruto'] / 100;
                     $DBruto = $m['DBruto'] / 1000;
                     /*Noapalosana Test*/
                     if ($this->MyPOST['noapalot_garumu'] == '1') {
                         $LBruto = floor($m['LBruto'] / 10) / 10;
                         //					echo "Bruto noapaļots = ".$DBrutoNoap.'<br>';
                     } elseif ($this->MyPOST['noapalot_garumu'] == '2') {
                         $LBruto = (floor($m['LBruto'] / 10) + 0.5) / 10;
                         //					echo "Bruto noapaļots = ".$DBrutoNoap.'<br>';
                     } elseif ($this->MyPOST['noapalot_garumu'] == '3') {
                         $LBruto = $m['LBruto'] / 100;
                         //					echo "Bruto noapaļots = ".$DBrutoNoap.'<br>';
                     } else {
                         $LBruto = $m['LBruto'] / 100;
                     }
                     $rauk_koef = get_raukums_no_diam($raukums, $DBruto * 1000);
                     $DPecReduc = $m['DPecReduc'] / 1000;
                     $DReduc = $DBruto - $DPecReduc;
                     $VBruto = f2($DBruto, $LBruto, $rauk_koef, $koeficients, $gostu_tabula);
                     /*
                             echo "DBruto = ".$DBruto.'<br/>';
                             echo "LBruto= ".$LBruto.'<br/>';
                             echo "rauk_koef= ".$rauk_koef.'<br/>';
                             echo "koeficients = ".$koeficients.'<br/>';
                             echo "gostu_tabula = ".$gostu_tabula.'<br/>','<br/>','<br/>';
                     */
                     //echo $rauk_koef . '; ' . $koeficients . '; ' . $VBruto . '<br />';
                     $VBezReducD = f2($DPecReduc, $LBruto, $rauk_koef, $koeficients, $gostu_tabula);
                     //        $VReducD = $VBruto-$VBezReducD;
                     //        echo "VReducD => ".$VReducD." = ".$VBruto." - ".$VBezReducD.'<br/>','<br/>','<br/>';
                     /*Noapalosana*/
                     if ($this->MyPOST['noapalot_diametru'] == 'on') {
                         $DBrutoNoap = (floor($m['DBruto'] / 10) + 0.5) / 100;
                     } else {
                         $DBrutoNoap = $m['DBruto'] / 1000;
                     }
                     if ($m[brakis] != '255') {
                         $irbrakis = true;
                         $brkods = 'standart';
                     }
                     //print_r($this->MyPOST);
                     //echo '<<<<<<<<<<<<<<<<<<<<' . $this->MyPOST['piegad_grupa'];
                     //        if (strtoupper($this->MyPOST['pieg_lig_num'])=='VIKA WOOD') {
                     if ($this->MyPOST['is_vika'] == 'on') {
                         $LNeto = $m['LPecReduc'] / 100;
                         $LNom = nom($LBruto, $virsmeri, $min_virsmers);
                         $LPecVirsm = $LNom;
                         $LReduc = round($LPecVirsm - $LNeto, 3);
                         $LVirsm = round($LBruto - $LPecVirsm, 3);
                         $VBezVirsm = f2($DPecReduc, $LBruto - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezVirsmNeredD = f2($DBruto, $LBruto - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         if (!$irbrakis) {
                             $VVirsm = $VBezReducD - $VBezVirsm;
                         } else {
                             $VVirsm = $VBruto - $VBezVirsmNeredD;
                             //				$VVirsm = $VBezReducD-$VBezVirsm;
                         }
                         $VBezReducL = f2($DPecReduc, $LPecVirsm - $LReduc, $rauk_koef, $koeficients, $gostu_tabula);
                         $VReducL = $VBezVirsm - $VBezReducL;
                     } else {
                         if ($this->MyPOST['noapalot_garumu'] == '1') {
                             $LPecReduc = floor($m['LPecReduc'] / 10) / 10;
                             $LNeap = $m['LPecReduc'] / 100;
                         } else {
                             $LPecReduc = $m['LPecReduc'] / 100;
                         }
                         $LNom = nom($LNeap, $virsmeri, $min_virsmers);
                         $LNeto = $LNom;
                         $LVirsm = round($LPecReduc - $LNeto, 3);
                         $LReduc = round($LBruto - $LPecReduc, 3);
                         $VBruto_redukcija = f2($DBruto, $LNom, $rauk_koef, $koeficients, $gostu_tabula);
                         //echo $rauk_koef . '; ' . $koeficients . '; ' . $VBruto . '<br />';
                         $VBezReducD_redukcija = f2($DPecReduc, $LNom, $rauk_koef, $koeficients, $gostu_tabula);
                         $VReducD = $VBruto_redukcija - $VBezReducD_redukcija;
                         $VBezReducL = f2($DBrutoNoap, $LBruto - $LReduc, $rauk_koef, $koeficients, $gostu_tabula);
                         $VReducL = $VBruto - $VBezReducL;
                         $VBezReduc = f2($DPecReduc, $LPecReduc, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezVirsm = f2($DPecReduc, $LPecReduc - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezVirsmNeredD = f2($DBruto, $LPecReduc - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         if (!$irbrakis) {
                             $VVirsm = $VBruto - $VBezVirsmNeredD;
                         } else {
                             $VVirsm = $VBruto - $VBezVirsmNeredD;
                         }
                         /*      
                               if($Ident == 12774972) {
                         //                $VBruto = f2($DBruto,$LBruto,$rauk_koef,$koeficients,$gostu_tabula);
                                 $Neto = $VBruto - $VReducL - $VReducD - $VVirsm;
                                 echo "Bruto tilp.= ".$VBruto.'<br />'."Diametrs = ".$DBruto.'<br />'."Neto = ".$Neto.'<br />'."Diametrs (Tīrais) = ".$m['DBruto'].'<br />'."Garums = ".$LBruto.'<br />'."Garums (Tīrais) = ".$m['LBruto'].'<br />'."Raukums = ".$rauk_koef.'<br />'."Koeficents = ".$koeficients.'<br />';
                               }
                         */
                     }
                     $SVBruto += $VBruto;
                     /*
                     Parveidosana uz mazakam mervienibam
                     				$DBruto = $DBruto/1000;				
                     				$DPecReduc = $DPecReduc/1000;
                     				$LBruto = $LBruto/100;
                     				$LPecReduc = $LPecReduc/100;
                     */
                     /*        $DReduc = round($DBruto - $DPecReduc,3);
                     */
                     /*				
                     				echo '<br />','$ID = ' . $r_id . '<br />';
                     				echo '$LPecReduc = ' . $LPecReduc . '<br />';
                     				echo '$LBruto = ' . $LBruto . '<br />';
                     				echo '$DBruto = ' . $DBruto . '<br />';
                     				echo '$DPecReduc = ' . $DPecReduc . '<br />';
                     				echo '$DReduc = ' . $DReduc . '<br />';
                     				echo '$LNeto = ' . $LNeto . '<br />';
                     				echo '$LVirsm = ' . $LVirsm . '<br />';
                     				echo '$LPecVirsm = ' . $LPecVirsm . '<br />';
                     				echo '$LNom = ' . $LNom . '<br />';
                     				echo '$LReduc = ' . $LReduc . '<br />';
                     				
                     				echo '$VBruto = ' . $VBruto . '<br />';
                     				
                     				echo '$SVBruto = ' . $SVBruto . '<br />';
                     				echo '$SVNeto = ' . $SVNeto . '<br />';
                     				
                     				echo '$VReducD = ' . $VReducD . '<br />';
                     				
                     				echo '$VBezReducL = ' . $VBezReducL . '<br />';
                     				echo '$VBezReducD = ' . $VBezReducD . '<br />';
                     				echo '$VBezVirsm = ' . $VBezVirsm . '<br />';
                     				echo '$VReducL = ' . $VReducL . '<br />';
                     				
                     				echo '$SVReducD = ' . $SVReducD . '<br />';
                     				
                     				echo '$SVReducL = ' . $SVReducL . '<br />';
                     				
                     				echo '$VBezReduc = ' . $VBezReduc . '<br />';
                     				
                     				echo '$VVirsm = ' . $VVirsm . '<br />';
                     				echo '$min_virsmers = ' . $min_virsmers . '<br />';
                     				
                     				echo '<br /><br /><br />';
                     */
                     /*
                     $bruto_temp = f2($DBruto,$LBruto,$rauk_koef,$koeficients,$gostu_tabula);
                     $bruto_temp_red = f2($DNoapReduc,$LBruto,$rauk_koef,$koeficients,$gostu_tabula);
                     $DReduc = f2($DPecReduc,$LBruto,$rauk_koef,$koeficients,$gostu_tabula);
                     $LReduc = f2($DNoapReduc,$LPecReduc,$rauk_koef,$koeficients,$gostu_tabula);
                     $Reduc   = f2($DPecReduc,$LPecReduc,$rauk_koef,$koeficients,$gostu_tabula);
                     $virsm = f2($DPecReduc,$l3,$rauk_koef,$koeficients,$gostu_tabula);
                     $virsm_nered = f2($DBruto,$l3,$rauk_koef,$koeficients,$gostu_tabula);        
                     */
                     /*
                     */
                     if ($gostu_tabula) {
                         if ($VBruto == -1 || $VReducD == -1 || $VReducL == -1 || $VVirsm == -1) {
                             $SSkaitsBad++;
                         }
                         if ($VBruto == -1) {
                             $VBruto = 0;
                         }
                         if ($VReducD == -1) {
                             $VReducD = 0;
                         }
                         if ($VReducL == -1) {
                             $VReducL = 0;
                         }
                         if ($VVirsm == -1) {
                             $VVirsm = 0;
                         }
                     }
                     //				echo '$irbrakis = ' . $irbrakis . '<br />';
                     /*Vai nav brakis?*/
                     /*
                     				if (!$irbrakis)
                     				{
                     					$DRed_temp = round($LBruto-$DRed,3);
                     					$LRed_temp = round($DBruto-$LRed,3);
                     					$VDRed = round($VDRed + $DRed_temp,3);
                     					$VLRed = round($VLRed + $LRed_temp,3);
                     				}
                     */
                     $VBrakis = 0;
                     if (strlen($abr[$key]) == 1) {
                         $irbrakis = true;
                         $brkods = $abr[$key];
                     }
                     //				echo '$irbrakis2 = ' . $irbrakis . '<br />';
                     //                    echo "VReducD = ".$VReducD.'<br/>';
                     if (!$irbrakis) {
                         /*Vai ir brakis?*/
                         if ($LNom != 0) {
                             $SVVirsm += $VVirsm;
                             //$SVNeto += f2($DPecReduc,$LNeto,$rauk_koef,$koeficients,$gostu_tabula);
                             $SVNeto += $VBruto - $VReducL - $VReducD - $VVirsm;
                             $SVReducD += $VReducD;
                             $SVReducL += $VReducL;
                         } else {
                             $SVBrakis += $VBruto;
                         }
                     } else {
                         if ($LNom != 0) {
                             if ($this->MyPOST['braka_virsmers'] == 'on') {
                                 $SVVirsm += $VVirsm;
                                 $VBrakis = $VBruto - $VVirsm;
                             } else {
                                 $VBrakis = $VBruto;
                             }
                             $SVBrakis += $VBrakis;
                         } else {
                             $VBrakis = $VBruto;
                             $SVBrakis += $VBrakis;
                         }
                     }
                 }
                 //-------------------------------------------TEST-Line->
             } elseif ($this->MyPOST['metode'] == '2') {
                 $query__ = "select mind_pirms_red as DBruto, garums as LBruto, mind_pec_red as DPecReduc, gar_pec_red as LPecReduc, brakis, pavadzime.cenu_matrica as cm, balkis_temp.id as r_id" . $myquery;
                 $r = $this->DB->query($query__);
                 /*NULL vertibu ievietosana*/
                 $SVBruto = 0;
                 $SVReducD = 0;
                 $SVReducL = 0;
                 $SVVirsm = 0;
                 $SVNeto = 0;
                 $SVBrakis = 0;
                 $SSkaits = 0;
                 $SSkaitsBad = 0;
                 $gostu_tabula = $this->MyPOST['gostu_tabula' . $this->grup];
                 /*
                 */
                 while ($m = $this->DB->get_row($r)) {
                     $SSkaits++;
                     /*Vai ir Vika Wood*/
                     if ($suga && $this->MyPOST['dalit_virsmers' . $this->grup]) {
                         $min_virsmers = $this->MyPOST['virsmers' . $this->grup . '_' . $suga] / 100;
                     } else {
                         $min_virsmers = $this->MyPOST['virsmers' . $this->grup] / 100;
                     }
                     $r_id = $m['r_id'];
                     //        $LBruto = $m['LBruto'] / 100;
                     $DBruto = $m['DBruto'] / 1000;
                     /*Noapalosana Test*/
                     if ($this->MyPOST['noapalot_garumu'] == '1') {
                         $LBruto = floor($m['LBruto'] / 10) / 10;
                         //					echo "Bruto noapaļots = ".$DBrutoNoap.'<br>';
                     } elseif ($this->MyPOST['noapalot_garumu'] == '2') {
                         $LBruto = (floor($m['LBruto'] / 10) + 0.5) / 10;
                         //					echo "Bruto noapaļots = ".$DBrutoNoap.'<br>';
                     } elseif ($this->MyPOST['noapalot_garumu'] == '3') {
                         $LBruto = $m['LBruto'] / 100;
                         //					echo "Bruto noapaļots = ".$DBrutoNoap.'<br>';
                     } else {
                         $LBruto = $m['LBruto'] / 100;
                     }
                     $rauk_koef = get_raukums_no_diam($raukums, $DBruto * 1000);
                     $DPecReduc = $m['DPecReduc'] / 1000;
                     $DReduc = $DBruto - $DPecReduc;
                     $VBruto = f2_mod($DBruto, $LBruto, $rauk_koef, $koeficients, $gostu_tabula);
                     /*
                             echo "DBruto = ".$DBruto.'<br/>';
                             echo "LBruto= ".$LBruto.'<br/>';
                             echo "rauk_koef= ".$rauk_koef.'<br/>';
                             echo "koeficients = ".$koeficients.'<br/>';
                             echo "gostu_tabula = ".$gostu_tabula.'<br/>','<br/>','<br/>';
                     */
                     //echo $rauk_koef . '; ' . $koeficients . '; ' . $VBruto . '<br />';
                     $VBezReducD = f2_mod($DPecReduc, $LBruto, $rauk_koef, $koeficients, $gostu_tabula);
                     //        $VReducD = $VBruto-$VBezReducD;
                     //        echo "VReducD => ".$VReducD." = ".$VBruto." - ".$VBezReducD.'<br/>','<br/>','<br/>';
                     /*Noapalosana*/
                     if ($this->MyPOST['noapalot_diametru'] == 'on') {
                         $DBrutoNoap = (floor($m['DBruto'] / 10) + 0.5) / 100;
                     } else {
                         $DBrutoNoap = $m['DBruto'] / 1000;
                     }
                     if ($m[brakis] != '255') {
                         $irbrakis = true;
                         $brkods = 'standart';
                     }
                     //print_r($this->MyPOST);
                     //echo '<<<<<<<<<<<<<<<<<<<<' . $this->MyPOST['piegad_grupa'];
                     //        if (strtoupper($this->MyPOST['pieg_lig_num'])=='VIKA WOOD') {
                     if ($this->MyPOST['is_vika'] == 'on') {
                         $LNeto = $m['LPecReduc'] / 100;
                         $LNom = nom($LBruto, $virsmeri, $min_virsmers);
                         $LPecVirsm = $LNom;
                         $LReduc = round($LPecVirsm - $LNeto, 3);
                         $LVirsm = round($LBruto - $LPecVirsm, 3);
                         $VBezVirsm = f2_mod($DPecReduc, $LBruto - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezVirsmNeredD = f2_mod($DBruto, $LBruto - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         if (!$irbrakis) {
                             $VVirsm = $VBezReducD - $VBezVirsm;
                         } else {
                             $VVirsm = $VBruto - $VBezVirsmNeredD;
                             //				$VVirsm = $VBezReducD-$VBezVirsm;
                         }
                         $VBezReducL = f2_mod($DPecReduc, $LPecVirsm - $LReduc, $rauk_koef, $koeficients, $gostu_tabula);
                         $VReducL = $VBezVirsm - $VBezReducL;
                     } else {
                         if ($this->MyPOST['noapalot_garumu'] == '1') {
                             $LPecReduc = floor($m['LPecReduc'] / 10) / 10;
                             $LNeap = $m['LPecReduc'] / 100;
                         } else {
                             $LPecReduc = $m['LPecReduc'] / 100;
                         }
                         $LNom = nom($LNeap, $virsmeri, $min_virsmers);
                         $LNeto = $LNom;
                         $LVirsm = round($LPecReduc - $LNeto, 3);
                         $LReduc = round($LBruto - $LPecReduc, 3);
                         $VBruto_redukcija = f2_mod($DBruto, $LNom, $rauk_koef, $koeficients, $gostu_tabula);
                         //echo $rauk_koef . '; ' . $koeficients . '; ' . $VBruto . '<br />';
                         $VBezReducD_redukcija = f2_mod($DPecReduc, $LNom, $rauk_koef, $koeficients, $gostu_tabula);
                         $VReducD = $VBruto_redukcija - $VBezReducD_redukcija;
                         $VBezReducL = f2_mod($DBrutoNoap, $LBruto - $LReduc, $rauk_koef, $koeficients, $gostu_tabula);
                         $VReducL = $VBruto - $VBezReducL;
                         $VBezReduc = f2_mod($DPecReduc, $LPecReduc, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezVirsm = f2_mod($DPecReduc, $LPecReduc - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezVirsmNeredD = f2_mod($DBruto, $LPecReduc - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         if (!$irbrakis) {
                             $VVirsm = $VBruto - $VBezVirsmNeredD;
                         } else {
                             $VVirsm = $VBruto - $VBezVirsmNeredD;
                         }
                     }
                     $SVBruto += $VBruto;
                     /*
                     */
                     /*
                     Parveidosana uz mazakam mervienibam
                     				$DBruto = $DBruto/1000;				
                     				$DPecReduc = $DPecReduc/1000;
                     				$LBruto = $LBruto/100;
                     				$LPecReduc = $LPecReduc/100;
                     */
                     /*        $DReduc = round($DBruto - $DPecReduc,3);
                     */
                     /*
                     
                     echo '<br />','$ID = ' . $r_id . '<br />';
                     echo '$LPecReduc = ' . $LPecReduc . '<br />';
                     echo '$LBruto = ' . $LBruto . '<br />';
                     echo '$DBruto = ' . $DBruto . '<br />';
                     echo '$DPecReduc = ' . $DPecReduc . '<br />';
                     echo '$DReduc = ' . $DReduc . '<br />';
                     echo '$LNeto = ' . $LNeto . '<br />';
                     echo '$LVirsm = ' . $LVirsm . '<br />';
                     echo '$LPecVirsm = ' . $LPecVirsm . '<br />';
                     echo '$LNom = ' . $LNom . '<br />';
                     echo '$LReduc = ' . $LReduc . '<br />';
                     
                     echo '$VBruto = ' . $VBruto . '<br />';
                     
                     echo '$SVBruto = ' . $SVBruto . '<br />';
                     echo '$SVNeto = ' . $SVNeto . '<br />';
                     
                     echo '$VReducD = ' . $VReducD . '<br />';
                     
                     echo '$VBezReducL = ' . $VBezReducL . '<br />';
                     echo '$VBezReducD = ' . $VBezReducD . '<br />';
                     echo '$VBezVirsm = ' . $VBezVirsm . '<br />';
                     echo '$VReducL = ' . $VReducL . '<br />';
                     
                     echo '$SVReducD = ' . $SVReducD . '<br />';
                     
                     echo '$SVReducL = ' . $SVReducL . '<br />';
                     
                     echo '$VBezReduc = ' . $VBezReduc . '<br />';
                     
                     echo '$VVirsm = ' . $VVirsm . '<br />';
                     echo '$min_virsmers = ' . $min_virsmers . '<br />';
                     
                     echo '<br /><br /><br />';
                     /*
                     
                     
                     /*
                     $bruto_temp = f2($DBruto,$LBruto,$rauk_koef,$koeficients,$gostu_tabula);
                     $bruto_temp_red = f2($DNoapReduc,$LBruto,$rauk_koef,$koeficients,$gostu_tabula);
                     $DReduc = f2($DPecReduc,$LBruto,$rauk_koef,$koeficients,$gostu_tabula);
                     $LReduc = f2($DNoapReduc,$LPecReduc,$rauk_koef,$koeficients,$gostu_tabula);
                     $Reduc   = f2($DPecReduc,$LPecReduc,$rauk_koef,$koeficients,$gostu_tabula);
                     $virsm = f2($DPecReduc,$l3,$rauk_koef,$koeficients,$gostu_tabula);
                     $virsm_nered = f2($DBruto,$l3,$rauk_koef,$koeficients,$gostu_tabula);        
                     */
                     /*
                     */
                     if ($gostu_tabula) {
                         if ($VBruto == -1 || $VReducD == -1 || $VReducL == -1 || $VVirsm == -1) {
                             $SSkaitsBad++;
                         }
                         if ($VBruto == -1) {
                             $VBruto = 0;
                         }
                         if ($VReducD == -1) {
                             $VReducD = 0;
                         }
                         if ($VReducL == -1) {
                             $VReducL = 0;
                         }
                         if ($VVirsm == -1) {
                             $VVirsm = 0;
                         }
                     }
                     //				echo '$irbrakis = ' . $irbrakis . '<br />';
                     /*Vai nav brakis?*/
                     /*
                     				if (!$irbrakis)
                     				{
                     					$DRed_temp = round($LBruto-$DRed,3);
                     					$LRed_temp = round($DBruto-$LRed,3);
                     					$VDRed = round($VDRed + $DRed_temp,3);
                     					$VLRed = round($VLRed + $LRed_temp,3);
                     				}
                     */
                     $VBrakis = 0;
                     if (strlen($abr[$key]) == 1) {
                         $irbrakis = true;
                         $brkods = $abr[$key];
                     }
                     //				echo '$irbrakis2 = ' . $irbrakis . '<br />';
                     //                    echo "VReducD = ".$VReducD.'<br/>';
                     if (!$irbrakis) {
                         /*Vai ir brakis?*/
                         if ($LNom != 0) {
                             $SVVirsm += $VVirsm;
                             //$SVNeto += f2($DPecReduc,$LNeto,$rauk_koef,$koeficients,$gostu_tabula);
                             $SVNeto += $VBruto - $VReducL - $VReducD - $VVirsm;
                             $SVReducD += $VReducD;
                             $SVReducL += $VReducL;
                         } else {
                             $SVBrakis += $VBruto;
                         }
                     } else {
                         if ($LNom != 0) {
                             if ($this->MyPOST['braka_virsmers'] == 'on') {
                                 $SVVirsm += $VVirsm;
                                 $VBrakis = $VBruto - $VVirsm;
                             } else {
                                 $VBrakis = $VBruto;
                             }
                             $SVBrakis += $VBrakis;
                         } else {
                             $VBrakis = $VBruto;
                             $SVBrakis += $VBrakis;
                         }
                     }
                 }
                 //-------------------------------------------TEST-Line->
             } elseif ($this->MyPOST['metode'] == '3') {
                 /*3.metode<------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
                 /*Query izvilksana*/
                 $query__ = "select mind_pirms_red as tievgalis_pirms_redukcijas,maxd_miza as resgalis_pirms_redukcijas, garums as LBruto,balkis_temp.id as bb_id,mind_pirms_red as DPirmsReduc, mind_pec_red as DPecReduc, gar_pec_red as LPecReduc, brakis, pavadzime.cenu_matrica as cm" . $myquery;
                 $r = $this->DB->query($query__);
                 $SVBruto = 0;
                 $SVReducD = 0;
                 $SVReducL = 0;
                 $SVVirsm = 0;
                 $SVNeto = 0;
                 $SVBrakis = 0;
                 $SSkaits = 0;
                 $SSkaitsBad = 0;
                 $gostu_tabula = $this->MyPOST['gostu_tabula' . $this->grup];
                 while ($m = $this->DB->get_row($r)) {
                     /* Testēšanas nolūkiem */
                     if ($this->MyPOST['negrupet']) {
                         $SVBruto = 0;
                         $SVReducD = 0;
                         $SVReducL = 0;
                         $SVVirsm = 0;
                         $SVNeto = 0;
                         $SVBrakis = 0;
                         $SSkaits = 0;
                         $SSkaitsBad = 0;
                     }
                     $SSkaits++;
                     /*Vai ir Vika Wood*/
                     $idents = $m['bb_id'];
                     if ($suga && $this->MyPOST['dalit_virsmers' . $this->grup]) {
                         $min_virsmers = $this->MyPOST['virsmers' . $this->grup . '_' . $suga] / 100;
                     } else {
                         $min_virsmers = $this->MyPOST['virsmers' . $this->grup] / 100;
                     }
                     $r_id = $m['r_id'];
                     $DBruto = $m['tievgalis_pirms_redukcijas'] / 1000;
                     $Diametra_starpiba = $m['DPirmsReduc'] - $m['DPecReduc'];
                     $balkis_id = $m['balkis_id'];
                     /*Noapalosana Test*/
                     if ($this->MyPOST['noapalot_garumu'] == '1') {
                         $LBruto = floor($m['LBruto'] / 10) / 10;
                     } elseif ($this->MyPOST['noapalot_garumu'] == '2') {
                         $LBruto = (floor($m['LBruto'] / 10) + 0.5) / 10;
                     } elseif ($this->MyPOST['noapalot_garumu'] == '3') {
                         $LBruto = $m['LBruto'] / 100;
                     } else {
                         $LBruto = $m['LBruto'] / 100;
                     }
                     $rauk_koef = get_raukums_no_diam($raukums, $DBruto * 1000);
                     $DPecReduc = $m['DPecReduc'] / 1000;
                     $DPecReducResg = ($m['resgalis_pirms_redukcijas'] - $Diametra_starpiba) / 1000;
                     $DReduc = $DBruto - $DPecReduc;
                     if ($this->MyPOST['noapalot_diametru'] == 'on') {
                         $DBrutoNoap = (floor($m['tievgalis_pirms_redukcijas'] / 10) + 0.5) / 100;
                         $DBrutoResg = (floor($m['resgalis_pirms_redukcijas'] / 10) + 0.5) / 100;
                     } else {
                         $DBrutoNoap = $m['tievgalis_pirms_redukcijas'] / 1000;
                         $DBrutoResg = $m['resgalis_pirms_redukcijas'] / 1000;
                     }
                     if ($m[brakis] != '255') {
                         $irbrakis = true;
                         $brkods = 'standart';
                     }
                     /*
                             echo "Tievgalis = ".$DBrutoNoap.'<br />';
                             echo "Tievgalis pec redukcijas = ".$DPecReduc.'<br />';
                             echo "Resgalis = ".$DBrutoResg.'<br />';
                             echo "Resgalis pec redukcijas = ".$DPecReducResg.'<br />'.'<br />';
                     */
                     if ($this->MyPOST['is_vika'] == 'on') {
                         if ($this->MyPOST['noapalot_garumu'] == '1') {
                             $LPecReduc = floor($m['LPecReduc'] / 10) / 10;
                         } else {
                             $LPecReduc = $m['LPecReduc'] / 100;
                         }
                         $LNomBruto = nom_3($m['LBruto'], $virsmeri, $min_virsmers) / 100;
                         $LnomNeto = $m['LPecReduc'] / 100;
                         $tilpums_bruto = f2_mod_3($DBrutoNoap, $DBrutoResg, $LBruto, $rauk_koef, $koeficients, $gostu_tabula);
                         $tilpums_neto = f2_mod_3($DPecReduc, $DPecReducResg, $LnomNeto, $rauk_koef, $koeficients, $gostu_tabula);
                         $tilpums_bruto_virsmeram = f2_mod_3($DBrutoNoap, $DBrutoResg, $LNomBruto, $rauk_koef, $koeficients, $gostu_tabula);
                         $tilpums_garuma_redukcijai = f2_mod_3($DBrutoNoap, $DBrutoResg, $LnomNeto, $rauk_koef, $koeficients, $gostu_tabula);
                         $tilpums_diametra_redukcijai_neto = f2_mod_3($DPecReduc, $DPecReducResg, $LnomNeto, $rauk_koef, $koeficients, $gostu_tabula);
                         $tilpums_virsmers = $tilpums_bruto - $tilpums_bruto_virsmeram;
                         $tilpums_kopejai_redukcijai = $tilpums_bruto_virsmeram - $tilpums_diametra_redukcijai_neto;
                         $tilpums_garuma_redukcija = $tilpums_kopejai_redukcijai;
                         $tilpums_diametrs_redukcija = 0;
                     } else {
                         if ($this->MyPOST['noapalot_garumu'] == '1') {
                             $LPecReduc = floor($m['LPecReduc'] / 10) / 10;
                         } else {
                             $LPecReduc = $m['LPecReduc'] / 100;
                         }
                         $LNomBruto = nom_3($m['LBruto'], $virsmeri, $min_virsmers) / 100;
                         $LnomNeto = nom_3($m['LPecReduc'], $virsmeri, $min_virsmers) / 100;
                         $tilpums_bruto = f2_mod_3($DBrutoNoap, $DBrutoResg, $LBruto, $rauk_koef, $koeficients, $gostu_tabula);
                         $tilpums_neto = f2_mod_3($DPecReduc, $DPecReducResg, $LnomNeto, $rauk_koef, $koeficients, $gostu_tabula);
                         $tilpums_bruto_virsmeram = f2_mod_3($DBrutoNoap, $DBrutoResg, $LNomBruto, $rauk_koef, $koeficients, $gostu_tabula);
                         $tilpums_garuma_redukcijai = f2_mod_3($DBrutoNoap, $DBrutoResg, $LnomNeto, $rauk_koef, $koeficients, $gostu_tabula);
                         $tilpums_virsmers = $tilpums_bruto - $tilpums_bruto_virsmeram;
                         $tilpums_kopejai_redukcijai = $tilpums_bruto_virsmeram - $tilpums_neto;
                         $tilpums_garuma_redukcija = $tilpums_kopejai_redukcijai;
                         $tilpums_diametrs_redukcija = 0;
                     }
                     $SVBruto += $tilpums_bruto;
                     if ($gostu_tabula) {
                         if ($VBruto == -1 || $VReducD == -1 || $VReducL == -1 || $VVirsm == -1) {
                             $SSkaitsBad++;
                             //            echo "Skaits = ".$SSkaitsBad.'<br />';
                         }
                         if ($VBruto == -1) {
                             $VBruto = 0;
                         }
                         if ($VReducD == -1) {
                             $VReducD = 0;
                         }
                         if ($VReducL == -1) {
                             $VReducL = 0;
                         }
                         if ($VVirsm == -1) {
                             $VVirsm = 0;
                         }
                     }
                     $VBrakis = 0;
                     if (strlen($abr[$key]) == 1) {
                         $irbrakis = true;
                         $brkods = $abr[$key];
                     }
                     if (!$irbrakis) {
                         if ($LnomNeto != 0) {
                             $SVVirsm += $tilpums_virsmers;
                             $SVNeto += $tilpums_neto;
                         } else {
                             $tilpums_diametrs_redukcija = 0;
                             $tilpums_garuma_redukcija = 0;
                             $VBrakis = $tilpums_bruto;
                             $SVBrakis += $tilpums_bruto;
                         }
                         $SVReducD += $tilpums_diametrs_redukcija;
                         $SVReducL += $tilpums_garuma_redukcija;
                     } else {
                         if ($LnomNeto != 0) {
                             if ($this->MyPOST['braka_virsmers'] == 'on') {
                                 $SVVirsm += $tilpums_virsmers;
                                 $VBrakis = $tilpums_bruto - $tilpums_virsmers;
                             } else {
                                 $VBrakis = $tilpums_bruto;
                             }
                             $SVBrakis += $VBrakis;
                         } else {
                             $VBrakis = $tilpums_bruto;
                             $SVBrakis += $VBrakis;
                         }
                     }
                     /* Testēšanas nolūkiem */
                     if ($this->MyPOST['negrupet']) {
                         $this->arr[$this->arr_index][$level - 1] = $this->kodi($this->MyPOST['gtype' . $this->grup . $this->lsk], $val);
                         //Pievienoju pārbaudi uz redukcijas negatīvu lielumu 2010-03-09, Ervīns
                         if ($SVReducD + $SVReducL < 0) {
                             $this->ERRORS .= "<font color=red>Pavadzīmē " . $this->MyPOST['pavadzime'] . " izveidojās negatīvs redukcijas lielums!</font><br><br>";
                             return false;
                         }
                         $this->arr[$this->arr_index][2] = $m['tievgalis_pirms_redukcijas'];
                         $this->arr[$this->arr_index][3] = $m['LBruto'];
                         $sm = new CSumma();
                         $sm->skaits = $SSkaits;
                         $sm->skaits_bad = $SSkaitsBad;
                         $sm->virsmers = $SVVirsm;
                         $sm->redukcija_d = $SVReducD;
                         $sm->redukcija_l = $SVReducL;
                         $sm->brakis = $SVBrakis;
                         $sm->neto = $SVNeto;
                         $sm->bruto = $SVBruto;
                         $this->arr[$this->arr_index][summa] = $sm;
                         $this->rowclosed = true;
                         $summa_p->add_skaits($SSkaits);
                         $summa_p->add_skaits_bad($SSkaitsBad);
                         $summa_p->add_virsmers($SVVirsm);
                         $summa_p->add_redukcija_d($SVReducD);
                         $summa_p->add_redukcija_l($SVReducL);
                         $summa_p->add_brakis($SVBrakis);
                         $summa_p->add_neto($SVNeto);
                         $summa_p->add_bruto($SVBruto);
                         $this->arr_index++;
                     }
                 }
                 /*------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
             } else {
                 /*4.metode<------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
                 /*Query izvilksana*/
                 $query__ = "select mind_pirms_red as DBruto, garums as LBruto, mind_pec_red as DPecReduc, gar_pec_red as LPecReduc, brakis, pavadzime.cenu_matrica as cm" . $myquery;
                 //			echo $query__.'<br />';
                 $r = $this->DB->query($query__);
                 /*NULL vertibu ievietosana*/
                 $SVBruto = 0;
                 $SVReducD = 0;
                 $SVReducL = 0;
                 $SVVirsm = 0;
                 $SVNeto = 0;
                 $SVBrakis = 0;
                 $SSkaits = 0;
                 $SSkaitsBad = 0;
                 $gostu_tabula = $this->MyPOST['gostu_tabula' . $this->grup];
                 /**/
                 while ($m = $this->DB->get_row($r)) {
                     $SSkaits++;
                     /*Vai ir Vika Wood*/
                     if ($suga && $this->MyPOST['dalit_virsmers' . $this->grup]) {
                         $min_virsmers = $this->MyPOST['virsmers' . $this->grup . '_' . $suga] / 100;
                     } else {
                         $min_virsmers = $this->MyPOST['virsmers' . $this->grup] / 100;
                     }
                     //        $LBruto = $m['LBruto'] / 100;
                     $DBruto = $m['DBruto'] / 1000;
                     /*Noapalosana Test*/
                     if ($this->MyPOST['noapalot_garumu'] == '1') {
                         $LBruto = floor($m['LBruto'] / 10) / 10;
                         //					echo "Bruto noapaļots = ".$DBrutoNoap.'<br>';
                     } elseif ($this->MyPOST['noapalot_garumu'] == '2') {
                         $LBruto = (floor($m['LBruto'] / 10) + 0.5) / 10;
                         //					echo "Bruto noapaļots = ".$DBrutoNoap.'<br>';
                     } elseif ($this->MyPOST['noapalot_garumu'] == '3') {
                         $LBruto = $m['LBruto'] / 100;
                         //					echo "Bruto noapaļots = ".$DBrutoNoap.'<br>';
                     } else {
                         $LBruto = $m['LBruto'] / 100;
                     }
                     $rauk_koef = get_raukums_no_diam($raukums, $DBruto * 1000);
                     $DPecReduc = $m['DPecReduc'] / 1000;
                     $DReduc = $DBruto - $DPecReduc;
                     $VBruto = f2($DBruto, $LBruto, $rauk_koef, $koeficients, $gostu_tabula);
                     //        echo $rauk_koef . '; ' . $koeficients . '; ' . $VBruto . '<br />';
                     $VBezReducD = f2($DPecReduc, $LBruto, $rauk_koef, $koeficients, $gostu_tabula);
                     $VReducD = $VBruto - $VBezReducD;
                     /*Noapalosana*/
                     if ($this->MyPOST['noapalot_diametru'] == 'on') {
                         $DBrutoNoap = (floor($m['DBruto'] / 10) + 0.5) / 100;
                     } else {
                         $DBrutoNoap = $m['DBruto'] / 1000;
                     }
                     if ($m[brakis] != '255') {
                         $irbrakis = true;
                         $brkods = 'standart';
                     }
                     //print_r($this->MyPOST);
                     //echo '<<<<<<<<<<<<<<<<<<<<' . $this->MyPOST['piegad_grupa'];
                     //        if (strtoupper($this->MyPOST['pieg_lig_num'])=='VIKA WOOD') {
                     if ($this->MyPOST['is_vika'] == 'on') {
                         $LNeto = $m['LPecReduc'] / 100;
                         $LNom = nom($LBruto, $virsmeri, $min_virsmers);
                         $LPecVirsm = $LNom;
                         $LReduc = round($LPecVirsm - $LNeto, 3);
                         $LVirsm = round($LBruto - $LPecVirsm, 3);
                         $VBezVirsm = f2($DPecReduc, $LBruto - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezVirsmNeredD = f2($DBruto, $LBruto - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         if (!$irbrakis) {
                             $VVirsm = $VBezReducD - $VBezVirsm;
                         } else {
                             $VVirsm = $VBezReducD - $VBezVirsm;
                             //            $VVirsm = $VBruto-$VBezVirsmNeredD;
                         }
                         //          $VVirsm = $VBezReducD-$VBezVirsm;
                         $VBezReducL = f2($DPecReduc, $LPecVirsm - $LReduc, $rauk_koef, $koeficients, $gostu_tabula);
                         $VReducL = $VBezVirsm - $VBezReducL;
                     } else {
                         if ($this->MyPOST['noapalot_garumu'] == '1') {
                             $LPecReduc = floor($m['LPecReduc'] / 10) / 10;
                         } else {
                             $LPecReduc = $m['LPecReduc'] / 100;
                         }
                         $LNom = nom($LPecReduc, $virsmeri, $min_virsmers);
                         $LNeto = $LNom;
                         $LVirsm = round($LPecReduc - $LNeto, 3);
                         $LReduc = round($LBruto - $LPecReduc, 3);
                         $VBezReducL = f2($DBrutoNoap, $LBruto - $LReduc, $rauk_koef, $koeficients, $gostu_tabula);
                         $VReducL = $VBruto - $VBezReducL;
                         $VBezReduc = f2($DPecReduc, $LPecReduc, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezVirsm = f2($DPecReduc, $LPecReduc - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezVirsmNeredD = f2($DBruto, $LPecReduc - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         if (!$irbrakis) {
                             $VVirsm = $VBezReduc - $VBezVirsm;
                         } else {
                             $VVirsm = $VBezReduc - $VBezVirsm;
                             //            $VVirsm = $VBruto-$VBezVirsmNeredD;
                         }
                     }
                     $SVBruto += $VBruto;
                     if ($gostu_tabula) {
                         if ($VBruto == -1 || $VReducD == -1 || $VReducL == -1 || $VVirsm == -1) {
                             $SSkaitsBad++;
                         }
                         if ($VBruto == -1) {
                             $VBruto = 0;
                         }
                         if ($VReducD == -1) {
                             $VReducD = 0;
                         }
                         if ($VReducL == -1) {
                             $VReducL = 0;
                         }
                         if ($VVirsm == -1) {
                             $VVirsm = 0;
                         }
                     }
                     /*Vai nav brakis?*/
                     /*
                     				if (!$irbrakis)
                     				{
                     					$DRed_temp = round($LBruto-$DRed,3);
                     					$LRed_temp = round($DBruto-$LRed,3);
                     					$VDRed = round($VDRed + $DRed_temp,3);
                     					$VLRed = round($VLRed + $LRed_temp,3);
                     				}
                     */
                     $VBrakis = 0;
                     if (strlen($abr[$key]) == 1) {
                         $irbrakis = true;
                         $brkods = $abr[$key];
                     }
                     if (!$irbrakis) {
                         /*Vai ir brakis?*/
                         $SVReducD += $VReducD;
                         $SVReducL += $VReducL;
                         if ($LNom != 0) {
                             $SVVirsm += $VVirsm;
                             //$SVNeto += f2($DPecReduc,$LNeto,$rauk_koef,$koeficients,$gostu_tabula);
                             $SVNeto += $VBruto - $VReducL - $VReducD - $VVirsm;
                         } else {
                             $SVBrakis += $VBezReduc;
                         }
                     } else {
                         if ($LNom != 0) {
                             if ($this->MyPOST['braka_virsmers'] == 'on') {
                                 $SVVirsm += $VVirsm;
                                 $VBrakis = $VBruto - $VVirsm;
                             } else {
                                 $VBrakis = $VBruto;
                             }
                             $SVBrakis += $VBrakis;
                         } else {
                             $VBrakis = $VBruto;
                             $SVBrakis += $VBrakis;
                         }
                     }
                 }
                 /*------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
             }
             //				echo '$brakis = ' . $SVBrakis . '<br />';
             //				echo '<br /><br /><br />';
             /*Ievietosana*/
             /* Testēšanas nolūkiem */
             if (!$this->MyPOST['negrupet']) {
                 $this->arr[$this->arr_index][$level - 1] = $this->kodi($this->MyPOST['gtype' . $this->grup . $this->lsk], $val);
                 $sm = new CSumma();
                 $sm->skaits = $SSkaits;
                 $sm->skaits_bad = $SSkaitsBad;
                 $sm->virsmers = $SVVirsm;
                 $sm->redukcija_d = $SVReducD;
                 $sm->redukcija_l = $SVReducL;
                 $sm->brakis = $SVBrakis;
                 $sm->neto = $SVNeto;
                 $sm->bruto = $SVBruto;
                 $this->arr[$this->arr_index][summa] = $sm;
                 $this->rowclosed = true;
                 $summa_p->add_skaits($SSkaits);
                 $summa_p->add_skaits_bad($SSkaitsBad);
                 $summa_p->add_virsmers($SVVirsm);
                 $summa_p->add_redukcija_d($SVReducD);
                 $summa_p->add_redukcija_l($SVReducL);
                 $summa_p->add_brakis($SVBrakis);
                 $summa_p->add_neto($SVNeto);
                 $summa_p->add_bruto($SVBruto);
             }
         }
     }
     /*
     */
     /////////////////////////////////////////////////////////////////////////////////////////////////////////////////Beigas/////////////////////////////////////////////
     // "<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>";
     // Aizpild?m tuk?umus
     // "<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>";
     if ($this->lsk > 1) {
         for ($j = $this->lsk - 2; $j >= 0; $j--) {
             $v = $this->arr[0][$j];
             for ($i = 0; $i < count($this->arr); $i++) {
                 // iekop?jam ja tuk?s
                 if ($this->arr[$i][$j] == "" && $this->arr[$i][$j + 1] != "") {
                     $this->arr[$i][$j] = $v;
                 }
                 // ja nav tuk?s pa?em v?rt?bu
                 if ($this->arr[$i][$j] != "") {
                     $v = $this->arr[$i][$j];
                 }
             }
         }
     }
 }
コード例 #2
0
 function print_level($level, $query, &$summa_p, $irbrakis_p, $suga, $id)
 {
     global $lang;
     global $translate;
     // tekošā grupēšanas līmeņa lauks
     $lauks = $this->MyPOST["gtype" . $this->grup . $level];
     ////////////////////////////////////////////////////////////////// JA IR DAL?JUMS PA SUG?M //////////////////
     if ($lauks == 'garums' || $lauks == 'mind_pirms_red' || $lauks == 'skira') {
         if ($this->MyPOST["dalit" . $this->grup . $level] && $suga) {
             // ja ir sadalījums pa sugām ņemam attiecīgo lauku
             $gvalues = "gvalues" . $this->grup . $level . "_" . $suga;
         } else {
             // ja nav tad ņemam kopīgo
             $gvalues = "gvalues" . $this->grup . $level;
         }
         // sadalam nepieciešamās vērtības
         //echo $this->MyPOST[$gvalues];
         $a = explode(',', $this->MyPOST[$gvalues]);
         $a = str_replace(' ', '', $a);
         // brāķis
         $abr = array();
         for ($i = 0; $i < count($a); $i++) {
             if (substr($a[$i], 0, 1) == 'b' || substr($a[$i], 0, 1) == 'B') {
                 $abr[$i] = '1';
                 //kursh masiva elements apzime braki
                 $a[$i] = substr($a[$i], 1);
                 //masiva elements bez B prieksa
             }
         }
     }
     ////////////////////////////////////////////////////////////////// JA IR DAL?JUMS PA SUG?M //////////////////
     if ($lauks == 'fsc') {
         $a = array();
         $a[0] = '0';
         $a[1] = '1';
         $typ = 'string';
     }
     if ($lauks == 'kad_piegad' || $lauks == 'auto' || $lauks == 'brakis' || $lauks == 'cenu_matrica' || $lauks == 'cirsmas_kods' || $lauks == 'kad_piegad' || $lauks == 'kravas_id' || $lauks == 'nelss_pavadzime.pavadzime' || $lauks == 'piegad_kods' || $lauks == 'soferis' || $lauks == 'suga' || $lauks == 'iecirknis' || $lauks == 'skira' && $a[0] == '' && sizeof($abr) == 0) {
         //no visiem atlas?tajiem ba??iem pavadz?m? atlasa attiec?g? lauka atrodam?s v?rt?bas (pa vienai)
         $a = array();
         $query__ = "select DISTINCT {$lauks} as lauks " . $query . " order by {$lauks} ";
         $r = $this->DB->query($query__);
         $ii = 0;
         while ($m = $this->DB->get_row($r)) {
             $a[$ii] = $m['lauks'];
             $ii++;
         }
         if ($lauks == 'brakis') {
             if ($a[count($a) - 1] == '255') {
                 for ($j = count($a) - 1; $j > 0; $j--) {
                     $a[$j] = $a[$j - 1];
                 }
                 $a[0] = '255';
             }
         }
         $typ = 'string';
     }
     $row = 0;
     $summa_p->init();
     $myid = 0;
     while (list($key, $val) = each($a)) {
         $myid++;
         if ($lauks == 'suga') {
             $suga = $val;
         }
         // virsm?ru sadal?jums
         if ($suga && $this->MyPOST['dalit_virsmeri' . $this->grup]) {
             if ($this->MyPOST['virsmeri' . $this->grup . '_' . $suga] != '') {
                 $virsmeri = explode(',', $this->MyPOST['virsmeri' . $this->grup . '_' . $suga]);
                 for ($i = 0; $i < count($virsmeri); $i++) {
                     $virsmeri[$i] = $virsmeri[$i] / 100;
                 }
             }
         } else {
             if ($this->MyPOST['virsmeri' . $this->grup] != '') {
                 $virsmeri = explode(',', $this->MyPOST['virsmeri' . $this->grup]);
                 for ($i = 0; $i < count($virsmeri); $i++) {
                     $virsmeri[$i] = $virsmeri[$i] / 100;
                 }
             }
         }
         if ($suga && $this->MyPOST['dalit_raukums' . $this->grup]) {
             $raukums = raukums_2_array($this->MyPOST['raukums' . $this->grup . '_' . $suga]);
         } else {
             $raukums = raukums_2_array($this->MyPOST['raukums' . $this->grup]);
         }
         if ($suga && $this->MyPOST['dalit_koeficients' . $this->grup]) {
             $koeficients = $this->MyPOST['koeficients' . $this->grup . '_' . $suga];
         } else {
             $koeficients = $this->MyPOST['koeficients' . $this->grup];
         }
         if ($typ != 'string') {
             $mbounds = explode('-', $a[$row]);
         }
         if (count($mbounds) > 1) {
             $low_range_brakis = 0;
             $high_range_brakis = 0;
             if ($mbounds[0] > 5) {
                 $low_range_brakis = $mbounds[0];
             } else {
                 $low_range_brakis = $mbounds[0];
             }
             if ($mbounds[1] < 994) {
                 $high_range_brakis = $mbounds[1];
             } else {
                 $high_range_brakis = $mbounds[1];
             }
             //pievienots 17.07.2007
             if ($this->MyPOST["gtype" . $this->grup . $level] == 'mind_pirms_red') {
                 $myquery = $query . " and  ((" . $this->MyPOST["gtype" . $this->grup . $level] . ">=" . $mbounds[0] . " and " . $this->MyPOST["gtype" . $this->grup . $level] . "<=" . $mbounds[1] . " AND nelss_balkis_temp.import_type <> 'zbm') or (" . $this->MyPOST["gtype" . $this->grup . $level] . ">=" . $low_range_brakis . " and " . $this->MyPOST["gtype" . $this->grup . $level] . "<=" . $high_range_brakis . " AND nelss_balkis_temp.import_type = 'zbm'))";
             } else {
                 $myquery = $query . " and  (" . $this->MyPOST["gtype" . $this->grup . $level] . ">=" . $mbounds[0] . " and " . $this->MyPOST["gtype" . $this->grup . $level] . "<=" . $mbounds[1] . ")";
             }
             //echo 'adding to query = ' . $query . " and  (". $this->MyPOST["gtype".$this->grup.$level] . ">=" . $mbounds[0] ." and " . $this->MyPOST["gtype".$this->grup.$level] . "<=" . $mbounds[1] . ")" . '<br />';
             //echo '$myquery = ' . $myquery . '<br />';
             //$myquery = $query . " and  (". $this->MyPOST["gtype".$this->grup.$level] . ">=" . $mbounds[0] ." and " . $this->MyPOST["gtype".$this->grup.$level] . "<=" . $mbounds[1] . ")";
         } else {
             if ($typ == 'string') {
                 $myquery = $query . " and  " . $this->MyPOST["gtype" . $this->grup . $level] . "='" . $a[$row] . "'";
             } else {
                 $myquery = $query . " and  " . $this->MyPOST["gtype" . $this->grup . $level] . "=" . $a[$row];
             }
         }
         $row = $row + 1;
         if ($this->rowclosed == true) {
             $this->rowclosed = false;
             $this->arr_index++;
             $this->arr[$this->arr_index] = array();
         }
         if ($level == 1) {
             $this->arr[$this->arr_index][0] = "";
         } else {
             if ($row > 1) {
                 for ($i = 1; $i < $level + 1; $i++) {
                     $this->arr[$this->arr_index][$i - 1] = "";
                 }
             }
         }
         $irbrakis = false;
         if ($irbrakis_p == true) {
             $irbrakis = true;
         }
         // Ja ir v?l dzi??ki l?me?i
         if ($level < $this->lsk) {
             if (!$val || $val == '') {
                 $this->arr[$this->arr_index][$level - 1] = "nav";
             } else {
                 $this->arr[$this->arr_index][$level - 1] = $this->kodi($this->MyPOST['gtype' . $this->grup . $level], $val);
             }
             $sum = new CSumma();
             if (strlen($abr[$key]) == 1) {
                 $irbrakis = true;
                 $brkods = $abr[$key];
             }
             //$rrow = mysql_query("select * from gatskaite where rowid = '".dig3($id).dig3($myid)."'");
             //if ($mrow = mysql_fetch_array($rrow))
             //{
             //	$saved = 1;
             //	$x = unserialize($mrow['data']);
             //	$sum = $x[summa];
             //}
             //else
             //{
             //}
             $this->print_level($level + 1, $myquery, $sum, $irbrakis, $suga, $id . $myid);
             /* Testa nolūkiem */
             // Te saskaita kop? par l?meni summu - XML varianta tas nav jadara
             if (!$this->XML_Variants) {
                 $this->arr_index++;
                 $this->arr[$this->arr_index] = array();
                 if ($sum->bruto) {
                     $this->arr[$this->arr_index][-1] = $translate['kopa'][$lang];
                     for ($i = 0; $i < $this->lsk; $i++) {
                         if ($level == $i + 1) {
                             $this->arr[$this->arr_index][$i] = $this->kodi($this->MyPOST['gtype' . $this->grup . $level], $val);
                         } else {
                             $this->arr[$this->arr_index][$i] = "";
                         }
                     }
                     if (!$this->MyPOST['negrupet']) {
                         $this->arr[$this->arr_index][summa] = $sum;
                     }
                     //echo "<tr><td height=1 colspan=".(7+$this->lsk)."><hr></tr>";
                 }
             }
             $this->rowclosed = true;
             if (!$this->MyPOST['negrupet']) {
                 $summa_p->add_skaits($sum->skaits);
                 $summa_p->add_skaits_bad($sum->skaits_bad);
                 $summa_p->add_virsmers($sum->virsmers);
                 $summa_p->add_redukcija_d($sum->redukcija_d);
                 $summa_p->add_redukcija_l($sum->redukcija_l);
                 $summa_p->add_brakis($sum->brakis);
                 $summa_p->add_neto($sum->neto);
                 $summa_p->add_bruto($sum->bruto);
                 //print_r($summa_p);
                 $this->lasttype = 'sum';
             }
         } else {
             $this->lasttype = 'data';
             ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////Saakums////////////////////////////////////////////////////////////////////////////////////
             if ($this->MyPOST['metode'] == '1') {
                 /*Query izvilksana*/
                 $tbl_field_identity = "";
                 $tbl_field_mind_pirms_red = "";
                 $tbl_field_garums = "";
                 $tbl_field_mind_pec_red = "";
                 $tbl_field_gar_pec_red = "";
                 $tbl_field_brakis = "";
                 $tbl_field_cenu_matrica = "";
                 $query__ = "select nelss_balkis_temp.id as Ident, mind_pirms_red as DBruto, garums as LBruto, mind_pec_red as DPecReduc, gar_pec_red as LPecReduc, brakis, nelss_pavadzime.cenu_matrica as cm " . $myquery;
                 $r = $this->DB->query($query__);
                 $SVBruto = 0;
                 $SVReducD = 0;
                 $SVReducL = 0;
                 $SVVirsm = 0;
                 $SVNeto = 0;
                 $SVBrakis = 0;
                 $SSkaits = 0;
                 $SSkaitsBad = 0;
                 $gostu_tabula = $this->MyPOST['gostu_tabula' . $this->grup];
                 while ($m = $this->DB->get_row($r)) {
                     $SSkaits++;
                     /*Vai ir Vika Wood*/
                     $min_virsmers = $this->MyPOST['virsmers' . $this->grup] / 100;
                     if ($suga && $this->MyPOST['dalit_virsmers' . $this->grup]) {
                         $min_virsmers = $this->MyPOST['virsmers' . $this->grup . '_' . $suga] / 100;
                     }
                     $DBruto = $m['DBruto'] / 1000;
                     /*Noapalosana Test*/
                     if ($this->MyPOST['noapalot_garumu'] == '1') {
                         $LBruto = floor($m['LBruto'] / 10) / 10;
                     } elseif ($this->MyPOST['noapalot_garumu'] == '2') {
                         $LBruto = (floor($m['LBruto'] / 10) + 0.5) / 10;
                     } else {
                         $LBruto = $m['LBruto'] / 100;
                     }
                     $rauk_koef = get_raukums_no_diam($raukums, $DBruto * 1000);
                     $DPecReduc = $m['DPecReduc'] / 1000;
                     $DReduc = $DBruto - $DPecReduc;
                     $VBruto = f2($DBruto, $LBruto, $rauk_koef, $koeficients, $gostu_tabula);
                     $VBezReducD = f2($DPecReduc, $LBruto, $rauk_koef, $koeficients, $gostu_tabula);
                     $DBrutoNoap = $m['DBruto'] / 1000;
                     if ($this->MyPOST['noapalot_diametru'] == 'on') {
                         $DBrutoNoap = (floor($m['DBruto'] / 10) + 0.5) / 100;
                     }
                     if ($m[brakis] != '255') {
                         $irbrakis = true;
                         $brkods = 'standart';
                     }
                     if ($this->MyPOST['is_vika'] == 'on') {
                         $LNeto = $m['LPecReduc'] / 100;
                         $LNom = nom($LBruto, $virsmeri, $min_virsmers);
                         $LPecVirsm = $LNom;
                         $LReduc = round($LPecVirsm - $LNeto, 3);
                         $LVirsm = round($LBruto - $LPecVirsm, 3);
                         $VBezVirsm = f2($DPecReduc, $LBruto - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezVirsmNeredD = f2($DBruto, $LBruto - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         if (!$irbrakis) {
                             $VVirsm = $VBezReducD - $VBezVirsm;
                         } else {
                             $VVirsm = $VBruto - $VBezVirsmNeredD;
                             //				$VVirsm = $VBezReducD-$VBezVirsm;
                         }
                         $VBezReducL = f2($DPecReduc, $LPecVirsm - $LReduc, $rauk_koef, $koeficients, $gostu_tabula);
                         $VReducL = $VBezVirsm - $VBezReducL;
                     } else {
                         $LPecReduc = $m['LPecReduc'] / 100;
                         if ($this->MyPOST['noapalot_garumu'] == '1') {
                             $LPecReduc = floor($m['LPecReduc'] / 10) / 10;
                             $LNeap = $m['LPecReduc'] / 100;
                         }
                         $LNom = nom($LNeap, $virsmeri, $min_virsmers);
                         $LNeto = $LNom;
                         $LVirsm = round($LPecReduc - $LNeto, 3);
                         $LReduc = round($LBruto - $LPecReduc, 3);
                         $VBruto_redukcija = f2($DBruto, $LNom, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezReducD_redukcija = f2($DPecReduc, $LNom, $rauk_koef, $koeficients, $gostu_tabula);
                         $VReducD = $VBruto_redukcija - $VBezReducD_redukcija;
                         $VBezReducL = f2($DBrutoNoap, $LBruto - $LReduc, $rauk_koef, $koeficients, $gostu_tabula);
                         $VReducL = $VBruto - $VBezReducL;
                         $VBezReduc = f2($DPecReduc, $LPecReduc, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezVirsm = f2($DPecReduc, $LPecReduc - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         $VBezVirsmNeredD = f2($DBruto, $LPecReduc - $LVirsm, $rauk_koef, $koeficients, $gostu_tabula);
                         $VVirsm = $VBruto - $VBezVirsmNeredD;
                     }
                     $SVBruto += $VBruto;
                     if ($gostu_tabula) {
                         if ($VBruto == -1 || $VReducD == -1 || $VReducL == -1 || $VVirsm == -1) {
                             $SSkaitsBad++;
                         }
                         if ($VBruto == -1) {
                             $VBruto = 0;
                         }
                         if ($VReducD == -1) {
                             $VReducD = 0;
                         }
                         if ($VReducL == -1) {
                             $VReducL = 0;
                         }
                         if ($VVirsm == -1) {
                             $VVirsm = 0;
                         }
                     }
                     $VBrakis = 0;
                     if (strlen($abr[$key]) == 1) {
                         $irbrakis = true;
                         $brkods = $abr[$key];
                     }
                     if (!$irbrakis) {
                         /*Vai ir brakis?*/
                         if ($LNom != 0) {
                             $SVVirsm += $VVirsm;
                             //$SVNeto += f2($DPecReduc,$LNeto,$rauk_koef,$koeficients,$gostu_tabula);
                             $SVNeto += $VBruto - $VReducL - $VReducD - $VVirsm;
                             $SVReducD += $VReducD;
                             $SVReducL += $VReducL;
                         } else {
                             $SVBrakis += $VBruto;
                         }
                     } else {
                         if ($LNom != 0) {
                             if ($this->MyPOST['braka_virsmers'] == 'on') {
                                 $SVVirsm += $VVirsm;
                                 $VBrakis = $VBruto - $VVirsm;
                             } else {
                                 $VBrakis = $VBruto;
                             }
                             $SVBrakis += $VBrakis;
                         } else {
                             $VBrakis = $VBruto;
                             $SVBrakis += $VBrakis;
                         }
                     }
                 }
                 //-------------------------------------------TEST-Line->
             } elseif ($this->MyPOST['metode'] == '2') {
             } elseif ($this->MyPOST['metode'] == '3') {
             } else {
             }
             //				$this->arr[$this->arr_index][$level-3] = $this->kodi($this->MyPOST['gtype'.$this->grup.$this->lsk],$val);
             //        echo $this->arr[$this->arr_index][$level];
             /* Testēšanas nolūkiem */
             if (!$this->MyPOST['negrupet']) {
                 $this->arr[$this->arr_index][b_kods] = $this->kodi($this->MyPOST['gtype' . $this->grup . $this->lsk], $val);
                 $sm = new CSumma();
                 $sm->skaits = $SSkaits;
                 $sm->skaits_bad = $SSkaitsBad;
                 $sm->virsmers = $SVVirsm;
                 $sm->redukcija_d = $SVReducD;
                 $sm->redukcija_l = $SVReducL;
                 $sm->brakis = $SVBrakis;
                 $sm->neto = $SVNeto;
                 $sm->bruto = $SVBruto;
                 $this->arr[$this->arr_index][summa] = $sm;
                 $this->rowclosed = true;
                 $summa_p->add_skaits($SSkaits);
                 $summa_p->add_skaits_bad($SSkaitsBad);
                 $summa_p->add_virsmers($SVVirsm);
                 $summa_p->add_redukcija_d($SVReducD);
                 $summa_p->add_redukcija_l($SVReducL);
                 $summa_p->add_brakis($SVBrakis);
                 $summa_p->add_neto($SVNeto);
                 $summa_p->add_bruto($SVBruto);
             }
         }
     }
     /*
     */
     /////////////////////////////////////////////////////////////////////////////////////////////////////////////////Beigas/////////////////////////////////////////////
     // "<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>";
     // Aizpild?m tuk?umus
     // "<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>";
     if ($this->lsk > 1) {
         for ($j = $this->lsk - 2; $j >= 0; $j--) {
             $v = $this->arr[0][$j];
             for ($i = 0; $i < count($this->arr); $i++) {
                 // iekop?jam ja tuk?s
                 if ($this->arr[$i][$j] == "" && $this->arr[$i][$j + 1] != "") {
                     $this->arr[$i][$j] = $v;
                 }
                 // ja nav tuk?s pa?em v?rt?bu
                 if ($this->arr[$i][$j] != "") {
                     $v = $this->arr[$i][$j];
                 }
             }
         }
     }
 }
コード例 #3
0
 function constrByMask($pvdzID)
 {
     $tmp_rowCount = 1;
     $tilpums_bruto_KOPA = 0;
     $tilpums_virsmers_KOPA = 0;
     $tilpums_redukcija_KOPA = 0;
     $tilpums_neto_KOPA = 0;
     $tilpums_brakis_KOPA = 0;
     $tmp_balkuSkaits = 0;
     $tilpums_skaits_brakis_KOPA = 0;
     $bbq_temp = false;
     $tmp_arrCollName['nosaukums'] = 1;
     $tmp_arrCollName['suga'] = "Suga";
     $tmp_arrCollName['skira'] = "Šķira";
     $tmp_arrCollName['diametrs'] = "Diametrs";
     $tmp_arrCollName['garums'] = "Garums";
     $tmp_arrCollName['brakis_kods'] = "Brāķa iemesls";
     $tmp_arrCollName['skaits'] = "Skaits";
     $tmp_arrCollName['bruto'] = "Bruto";
     $tmp_arrCollName['virsmers'] = "Virsmērs";
     $tmp_arrCollName['redukcija'] = "Redukcija";
     $tmp_arrCollName['redukcija_un_virsmers'] = "Red. un virsm.";
     $tmp_arrCollName['brakis'] = "Brāķis";
     $tmp_arrCollName['neto'] = "Neto";
     $tmp_arrCollName['brakis_un_neto'] = "Brāķis un Neto";
     $tmp_getDataQuery_txt = "SELECT * FROM " . $this->tblName . "balkis_temp WHERE pavadzime = " . $pvdzID . " ORDER BY mind_pirms_red";
     if (!$pvdzID) {
         $tmp_getDataQuery_txt = "SELECT * FROM " . $this->tblName . "balkis_temp ORDER BY mind_pirms_red";
         $bbq_temp = true;
     }
     $tmp_getDataQuery_query = mysql_query($tmp_getDataQuery_txt);
     /*  
       While($tmp_getDataQuery_arr_tmp = mysql_fetch_assoc($tmp_getDataQuery_query)){
         $tmp_getDataQuery_arr_tmp_first[] = $tmp_getDataQuery_arr_tmp;
         $tmp_getDataQuery_arr_tmp_second[] = $tmp_getDataQuery_arr_tmp;
       }
       
       $tmp_getDataQuery_arr_tmp_third = array_chunk($tmp_getDataQuery_arr_tmp_second,500);
       foreach($tmp_getDataQuery_arr_tmp_third as $item_ttt){
            
       foreach($item_ttt as $tmp_getDataQuery_arr){
     */
     /*
       $part_count = 0;
       $tmp_getDataQuery_txt_temp = run_mysql_by_partitions($part_count,$tmp_getDataQuery_txt);
       $tmp_getDataQuery_query = mysql_query($tmp_getDataQuery_txt_temp);
     
       while(mysql_num_rows($tmp_getDataQuery_query) > 1){
       $tmp_getDataQuery_txt_temp = run_mysql_by_partitions($part_count,$tmp_getDataQuery_txt);
       $tmp_getDataQuery_query = mysql_query($tmp_getDataQuery_txt_temp);
       
         $part_count++;
     */
     while ($tmp_getDataQuery_arr = mysql_fetch_assoc($tmp_getDataQuery_query)) {
         $tilpums_bruto = 0;
         $tilpums_virsmers = 0;
         $tilpums_redukcija = 0;
         $tilpums_neto = 0;
         $tilpums_brakis = 0;
         $isBrakaVirsmOn = $this->MyPOST['braka_virsmers'];
         if ($tmp_getDataQuery_arr['pavadzime'] == 76806 && $this->firmCode == 2) {
             $isBrakaVirsmOn = 'off';
         }
         //-#001-FUNC-START--Nepieciešamo datu kolekcionēšana no datubāzes------------------------------------------------------------------------------------
         $tmp_ident_balkis = $tmp_getDataQuery_arr['id'];
         $var_Suga = $tmp_getDataQuery_arr['suga'];
         $tmp_tilpumsBruto = $tmp_getDataQuery_arr['tilpums'];
         $tmp_tilpumsNeto = $tmp_getDataQuery_arr['tilpums_scan'];
         $tmp_garums_pirms_red = $tmp_getDataQuery_arr['garums'];
         $tmp_garums_pec_red = $tmp_getDataQuery_arr['gar_pec_red'];
         $tmp_tievgalis_pirms_red = $tmp_getDataQuery_arr['mind_pirms_red'];
         $tmp_tievgalis_pec_red = $tmp_getDataQuery_arr['mind_pec_red'];
         $tmp_vidusdiametrs_pirms_red = $tmp_getDataQuery_arr['mind_miza'];
         $tmp_vidusdiametrs_pec_red = $tmp_getDataQuery_arr['mind_miza'] - ($tmp_getDataQuery_arr['mind_pirms_red'] - $tmp_getDataQuery_arr['mind_pec_red']);
         $tmp_resgalis_pirms_red = $tmp_getDataQuery_arr['maxd_miza'];
         $tmp_resgalis_pec_red = $tmp_getDataQuery_arr['maxd_miza'] - ($tmp_getDataQuery_arr['mind_pirms_red'] - $tmp_getDataQuery_arr['mind_pec_red']);
         //-#001-FUNC-END------------------------------------------------------------------------------------------------------------------------------------
         //-#002-FUNC-START--Nepieciešamās grupas atrašana---------------------------------------------------------------------------------------------------
         $igc = 1;
         // Grupu skaits
         $init_Group = false;
         while ($igc < 9 && $init_Group == false) {
             $tmp_igcCheck = 0;
             for ($igo = 1; $igo < 6; $igo++) {
                 //Grupēšanas nosacījumus cikls
                 for ($subcount = 0; $subcount < 3; $subcount++) {
                     if ($this->tmpAllGroup[$igc][$this->GroupOrder[$igo]][$subcount]) {
                         $tmp_SubResult = $this->tmpAllGroup[$igc][$this->GroupOrder[$igo]][$subcount];
                         if (!$this->tmpAllGroup[$igc][$this->GroupOrder[$igo]][0]) {
                             $tmp_SubResult = $this->tmpAllGroup[$igc][$this->GroupOrder[$igo]][$var_Suga];
                         }
                         $tmp_ALLbResult = $this->getMaskGroup($tmp_SubResult, $tmp_getDataQuery_arr[$this->GroupOrder[$igo]], $this->GroupOrder[$igo]);
                         $tmp_inputArrVal[$this->GroupOrder[$igo]] = $tmp_ALLbResult;
                         if ($tmp_ALLbResult != '') {
                             $tmp_igcCheck = $tmp_igcCheck + 1;
                         }
                     } else {
                         $tmp_igcCheck = $tmp_igcCheck + 1;
                     }
                 }
                 if ($igo == 5 && $tmp_igcCheck == 15) {
                     // Grupas noteikšana līdz pirmajiem sakritības rezultātiem (rekursija ar limitētu ciklu skaitu)
                     $init_Group = true;
                     $globalGroupIdent = $igc;
                 }
             }
             $igc++;
         }
         //-#002-FUNC-END-------------------------------------------------------------------------------------------------------------------------------------
         //-#003-FUNC-START--Tilpuma aprēķināšana-------------------------------------------------------------------------------------------------------------
         $prnt_Nosaukums = 0;
         $prnt_Suga = $this->sugas[$var_Suga]['LAT'];
         $prnt_Skira = $tmp_getDataQuery_arr['skira'];
         $prnt_Brakis = $this->braki[$tmp_getDataQuery_arr['brakis']]['LAT'];
         $prnt_Diametrs = $tmp_inputArrVal['mind_pirms_red'];
         $prnt_Garums = $tmp_inputArrVal['garums'];
         //---------------------------------------------------------------------------------------------------------------------------------------------------
         if ($this->firmCode == 35 && $prnt_Skira == 3) {
             $prnt_Skira = 9;
             $prnt_Brakis = $this->braki['010']['LAT'];
         }
         //---------------------------------------------------------------------------------------------------------------------------------------------------
         if ($this->MyPOST['noapalot_garumu'] == '1') {
             $tmp_garums_pirms_red = floor($tmp_garums_pirms_red / 10) * 10;
         } elseif ($this->MyPOST['noapalot_garumu'] == '2') {
             $tmp_garums_pirms_red = (floor($tmp_garums_pirms_red / 10) + 0.5) * 10;
         }
         $tmp_raukumaRinda = $this->tmpRaukGroup[$globalGroupIdent][0];
         if (!$tmp_raukumaRinda) {
             $tmp_raukumaRinda = $this->tmpRaukGroup[$globalGroupIdent][$var_Suga];
         }
         $raukums = raukums_2_array($tmp_raukumaRinda);
         $rauk_koef = get_raukums_no_diam($raukums, $tmp_tievgalis_pirms_red);
         $tmp_DiamRedukcija = $tmp_tievgalis_pirms_red - $tmp_tievgalis_pec_red;
         $tilpums_bruto = $this->calc_Volume($tmp_tievgalis_pirms_red, $tmp_vidusdiametrs_pirms_red, $tmp_resgalis_pirms_red, $tmp_garums_pirms_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
         if ($this->MyPOST['noapalot_diametru'] == 'on') {
             $tmp_tievgalis_pec_red = (floor($tmp_tievgalis_pec_red / 10) + 0.5) * 100;
         }
         $tmp_virsmeraRinda = $this->tmpNomGarGroup[$globalGroupIdent][0];
         if (!$tmp_virsmeraRinda) {
             $tmp_virsmeraRinda = $this->tmpNomGarGroup[$globalGroupIdent][$var_Suga];
         }
         $tmp_virsmeraRindaBrakis = $this->tmpNomGarBrakGroup[$globalGroupIdent][0];
         if (!$tmp_virsmeraRindaBrakis) {
             $tmp_virsmeraRindaBrakis = $this->tmpNomGarBrakGroup[$globalGroupIdent][$var_Suga];
         }
         if ($tmp_virsmeraRindaBrakis) {
             $virsmeri_brakim = explode(',', $tmp_virsmeraRindaBrakis);
             for ($i = 0; $i < count($virsmeri_brakim); $i++) {
                 $virsmeri_brakim[$i] = $virsmeri_brakim[$i];
             }
         }
         $virsmeri = explode(',', $tmp_virsmeraRinda);
         for ($i = 0; $i < count($virsmeri); $i++) {
             $virsmeri[$i] = $virsmeri[$i];
         }
         $tmp_mini_virsmeraRinda = $this->tmpVirsmGroup[$globalGroupIdent][0];
         if (!$tmp_mini_virsmeraRinda) {
             $tmp_mini_virsmeraRinda = $this->tmpVirsmGroup[$globalGroupIdent][$var_Suga];
         }
         $tmp_nom_garums_pirms_red = nominalGarums($tmp_getDataQuery_arr['garums'], $virsmeri, $tmp_mini_virsmeraRinda);
         $tmp_nom_garums_pec_red = nominalGarums($tmp_garums_pec_red, $virsmeri, $tmp_mini_virsmeraRinda);
         if ($this->MyPOST['is_vika'] == 'on') {
             $tmp_garums_pec_red = $tmp_garums_pec_red + $tmp_mini_virsmeraRinda;
             $tmp_nom_garums_pec_red = nominalGarums($tmp_garums_pec_red, $virsmeri, $tmp_mini_virsmeraRinda);
             $tilpums_neto = $this->calc_Volume($tmp_tievgalis_pec_red, $tmp_vidusdiametrs_pec_red, $tmp_resgalis_pec_red, $tmp_nom_garums_pec_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
             $tilpums_bruto_virsmeram = $this->calc_Volume($tmp_tievgalis_pirms_red, $tmp_vidusdiametrs_pirms_red, $tmp_resgalis_pirms_red, $tmp_nom_garums_pirms_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
             $tilpums_virsmers = ROUND($tilpums_bruto - $tilpums_bruto_virsmeram, 3);
             $tilpums_redukcija = $tilpums_bruto_virsmeram - $tilpums_neto;
         } else {
             $tilpums_neto = $this->calc_Volume($tmp_tievgalis_pec_red, $tmp_vidusdiametrs_pec_red, $tmp_resgalis_pec_red, $tmp_nom_garums_pec_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
             $tilpums_bruto_virsmeram = $this->calc_Volume($tmp_tievgalis_pirms_red, $tmp_vidusdiametrs_pirms_red, $tmp_resgalis_pirms_red, $tmp_nom_garums_pirms_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
             $tilpums_virsmers = ROUND($tilpums_bruto - $tilpums_bruto_virsmeram, 3);
             $tilpums_redukcija = $tilpums_bruto_virsmeram - $tilpums_neto;
         }
         if ($this->MyPOST['metode'] == 4) {
             if ($this->firmCode == 27) {
                 $tilpums_bruto = floor($tmp_tilpumsBruto / 10) / 1000;
                 $tilpums_neto = floor($tmp_tilpumsNeto / 10) / 1000;
                 $tilpums_bruto_virsmeram = floor($tmp_tilpumsNeto / 10) / 1000;
                 $tilpums_virsmers = $tilpums_bruto - $tilpums_bruto_virsmeram;
                 $tilpums_redukcija = 0;
             } else {
                 $tilpums_bruto = $tmp_tilpumsBruto;
                 $tilpums_neto = $tmp_tilpumsNeto;
                 $tilpums_bruto_virsmeram = $tmp_tilpumsNeto;
                 $tilpums_virsmers = $tilpums_bruto - $tilpums_bruto_virsmeram;
                 $tilpums_redukcija = 0;
             }
         }
         if ($tilpums_virsmers < 0) {
             $tilpums_virsmers = 0;
         }
         if ($tilpums_bruto_virsmeram == 0) {
             $tilpums_virsmers = 0;
         }
         if ($tilpums_redukcija < 0) {
             $tilpums_redukcija = 0;
         }
         //-#003-FUNC-END--------------------------------------------------------------------------------------------------------------------------------------
         //-#004-FUNC-START--Papildus dimensijas brāķa priešķiršana--------------------------------------------------------------------------------------------
         $takeReCallOn4 = false;
         if ($tmp_nom_garums_pec_red < 1 && !$prnt_Brakis) {
             $prnt_Skira = 9;
             $prnt_Brakis = $this->braki['899']['LAT'];
             $takeReCallOn4 = true;
         }
         if (substr($prnt_Diametrs, 0, 1) == 'b' && !$prnt_Brakis) {
             $prnt_Skira = 9;
             $prnt_Brakis = $this->braki['899']['LAT'];
             $prnt_Diametrs = str_replace('b', '', $prnt_Diametrs);
             $takeReCallOn4 = true;
         }
         if (substr($prnt_Garums, 0, 1) == 'b' && !$prnt_Brakis) {
             $prnt_Skira = 9;
             $prnt_Brakis = $this->braki['899']['LAT'];
             $prnt_Garums = str_replace('b', '', $prnt_Garums);
             $takeReCallOn4 = true;
         }
         if ($prnt_Brakis == 'D') {
             // XML nobrāķēšana ar 4 kodu
             $takeReCallOn4 = true;
         }
         if ($takeReCallOn4) {
             $tmp_is4 = mod_ResignLVMRejectCode($this->firmCode, $tmp_getDataQuery_arr['garums'], $tmp_getDataQuery_arr['mind_pirms_red'], $tmp_getDataQuery_arr['suga'], $tmp_getDataQuery_arr['skira']);
             if ($tmp_is4) {
                 $prnt_Brakis = $this->braki['856']['LAT'];
             }
         }
         //-#004-FUNC-END-----------------------------------------------------------------------------------------------------
         //-#005-FUNC-START--Brāķa tilpuma aprēķināšana---------------------------------------------------------------------------------------------------
         if ($prnt_Brakis) {
             $tilpums_neto = 0;
             $tilpums_redukcija = 0;
             if ($isBrakaVirsmOn == 'on') {
                 if ($virsmeri_brakim) {
                     $tmp_nom_garums_pirms_red_brakim = nominalGarums($tmp_getDataQuery_arr['garums'], $virsmeri_brakim, $tmp_mini_virsmeraRinda);
                     $tilpums_bruto_virsmeram = $this->calc_Volume($tmp_tievgalis_pirms_red, $tmp_vidusdiametrs_pirms_red, $tmp_resgalis_pirms_red, $tmp_nom_garums_pirms_red_brakim, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
                     if ($tilpums_bruto_virsmeram > 0) {
                         $tilpums_virsmers = $tilpums_bruto - $tilpums_bruto_virsmeram;
                         $tilpums_brakis = $tilpums_bruto_virsmeram;
                     } else {
                         $tilpums_virsmers = 0;
                         $tilpums_brakis = $tilpums_bruto;
                     }
                 } else {
                     if ($tilpums_bruto_virsmeram > 0) {
                         $tilpums_brakis = $tilpums_bruto_virsmeram;
                     } else {
                         $tilpums_virsmers = 0;
                         $tilpums_brakis = $tilpums_bruto;
                     }
                 }
             } else {
                 $tilpums_virsmers = 0;
                 $tilpums_brakis = $tilpums_bruto;
             }
         }
         $tmp_inputArrVal['mind_pirms_red'] = str_replace('b', '', $tmp_inputArrVal['mind_pirms_red']);
         $prnt_Diametrs = str_replace('b', '', $prnt_Diametrs);
         $tmp_inputArrVal['garums'] = str_replace('b', '', $tmp_inputArrVal['garums']);
         $prnt_Garums = str_replace('b', '', $prnt_Garums);
         //-#005-FUNC-END-----------------------------------------------------------------------------------------------------
         //-#006-FUNC-START--Vienādo grupēšanu pāskats---------------------------------------------------------------------------------------------------
         $pilnaGrupesana = false;
         if ($this->report_XML) {
             $pilnaGrupesana = true;
         }
         if (($this->firmCode == 16 || $this->firmCode == 18 || $this->isAllReport) && !$this->report_PDF) {
             $pilnaGrupesana = true;
         }
         $rowExist = 0;
         if (!$pilnaGrupesana) {
             for ($protoKey = $tmp_rowCount - 1; $protoKey > 0; $protoKey--) {
                 if ($this->arrPrintOut[$protoKey]['suga'] == $prnt_Suga) {
                     if ($this->arrPrintOut[$protoKey]['skira'] == $prnt_Skira) {
                         if ($this->arrPrintOut[$protoKey]['diametrs'] == $prnt_Diametrs) {
                             if ($this->arrPrintOut[$protoKey]['brakis_kods'] == $prnt_Brakis) {
                                 $rowExist = $protoKey;
                             }
                         }
                     }
                 }
             }
         } else {
             for ($protoKey = $tmp_rowCount - 1; $protoKey > 0; $protoKey--) {
                 if ($this->arrPrintOut[$protoKey]['suga'] == $prnt_Suga) {
                     if ($this->arrPrintOut[$protoKey]['skira'] == $prnt_Skira) {
                         if ($this->arrPrintOut[$protoKey]['diametrs'] == $prnt_Diametrs) {
                             if ($this->arrPrintOut[$protoKey]['garums'] == $prnt_Garums) {
                                 if ($this->arrPrintOut[$protoKey]['brakis_kods'] == $prnt_Brakis) {
                                     $rowExist = $protoKey;
                                 }
                             }
                         }
                     }
                 }
             }
         }
         //-#006-FUNC-END-----------------------------------------------------------------------------------------------------
         //-#007-FUNC-START--Statisko vērtību ievietošana---------------------------------------------------------------------------------------------------
         $insertRow = $tmp_rowCount;
         if ($rowExist != 0) {
             $insertRow = $rowExist;
         }
         $this->arrPrintOut[$insertRow]['nosaukums'] = 0;
         $this->arrPrintOut[$insertRow]['suga'] = $prnt_Suga;
         $this->arrPrintOut[$insertRow]['skira'] = $prnt_Skira;
         $this->arrPrintOut[$insertRow]['diametrs'] = $prnt_Diametrs;
         $this->arrPrintOut[$insertRow]['garums'] = $prnt_Garums;
         $this->arrPrintOut[$insertRow]['brakis_kods'] = $prnt_Brakis;
         if ($this->report_XML) {
             $this->arrPrintOut[$insertRow]['diametrs_tmp'] = $tmp_getDataQuery_arr['mind_pirms_red'];
             $this->arrPrintOut[$insertRow]['garums_tmp'] = $tmp_getDataQuery_arr['garums'];
         }
         $this->arrPrintOut[$insertRow]['skaits'] += 1;
         if ($this->arrPrintOut[$insertRow]['brakis_kods'] != '') {
             $tilpums_skaits_brakis_KOPA += 1;
         }
         //-#007-FUNC-END-----------------------------------------------------------------------------------------------------
         //-#008-FUNC-START--Dinamisko vērtību piešķiršana---------------------------------------------------------------------------------------------------
         $this->arrPrintOut[$insertRow]['bruto'] += $tilpums_bruto;
         $this->arrPrintOut[$insertRow]['virsmers'] += $tilpums_virsmers;
         $this->arrPrintOut[$insertRow]['redukcija'] += $tilpums_redukcija;
         $this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] += $tilpums_bruto - $tilpums_neto;
         $this->arrPrintOut[$insertRow]['brakis'] += $tilpums_brakis;
         $this->arrPrintOut[$insertRow]['neto'] += $tilpums_neto;
         $this->arrPrintOut[$insertRow]['brakis_un_neto'] += $tilpums_neto + $tilpums_brakis;
         //------------------------------------------------------------------------------------------------------
         if ($this->arrPrintOut[$insertRow]['bruto'] != '') {
             $this->arrPrintOut[$insertRow]['bruto'] = number_format($this->arrPrintOut[$insertRow]['bruto'], 3, '.', '');
         } else {
             $this->arrPrintOut[$insertRow]['bruto'] = '';
         }
         if ($this->arrPrintOut[$insertRow]['virsmers'] != '') {
             $this->arrPrintOut[$insertRow]['virsmers'] = number_format($this->arrPrintOut[$insertRow]['virsmers'], 3, '.', '');
         } else {
             $this->arrPrintOut[$insertRow]['virsmers'] = '';
         }
         if ($this->arrPrintOut[$insertRow]['redukcija'] != '') {
             $this->arrPrintOut[$insertRow]['redukcija'] = number_format($this->arrPrintOut[$insertRow]['redukcija'], 3, '.', '');
         } else {
             $this->arrPrintOut[$insertRow]['redukcija'] = '';
         }
         if ($this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] != '') {
             $this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] = number_format($this->arrPrintOut[$insertRow]['redukcija_un_virsmers'], 3, '.', '');
         } else {
             $this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] = '';
         }
         if ($this->arrPrintOut[$insertRow]['brakis'] != '') {
             $this->arrPrintOut[$insertRow]['brakis'] = number_format($this->arrPrintOut[$insertRow]['brakis'], 3, '.', '');
         } else {
             $this->arrPrintOut[$insertRow]['brakis'] = '';
         }
         if ($this->arrPrintOut[$insertRow]['neto'] != '') {
             $this->arrPrintOut[$insertRow]['neto'] = number_format($this->arrPrintOut[$insertRow]['neto'], 3, '.', '');
         } else {
             $this->arrPrintOut[$insertRow]['neto'] = '';
         }
         if ($this->arrPrintOut[$insertRow]['brakis_un_neto'] != '') {
             $this->arrPrintOut[$insertRow]['brakis_un_neto'] = number_format($this->arrPrintOut[$insertRow]['brakis_un_neto'], 3, '.', '');
         } else {
             $this->arrPrintOut[$insertRow]['brakis_un_neto'] = '';
         }
         //------------------------------------------------------------------------------------------------------
         $tilpums_bruto_KOPA = $tilpums_bruto_KOPA + $tilpums_bruto;
         $tilpums_virsmers_KOPA = $tilpums_virsmers_KOPA + $tilpums_virsmers;
         $tilpums_redukcija_KOPA = $tilpums_redukcija_KOPA + $tilpums_redukcija;
         $tilpums_neto_KOPA = $tilpums_neto_KOPA + $tilpums_neto;
         $tilpums_brakis_KOPA = $tilpums_brakis_KOPA + $tilpums_brakis;
         $tmp_balkuSkaits++;
         $tmp_rowCount++;
     }
     //  }
     //-#008-FUNC-END-----------------------------------------------------------------------------------------------------
     //-#009-FUNC-START--Rindu pārgrupēšana masīvā---------------------------------------------------------------------------------------------------
     if (($this->firmCode == 16 || $this->firmCode == 20 || $this->isAllReport) && !$this->report_PDF && !$this->report_XML) {
         $this->arrPrintOut = array_orderby($this->arrPrintOut, 'suga', SORT_ASC, 'skira', SORT_ASC, 'diametrs', SORT_ASC, 'garums', SORT_ASC, 'brakis_kods', SORT_ASC);
     } else {
         $this->arrPrintOut = array_orderby($this->arrPrintOut, 'suga', SORT_ASC, 'skira', SORT_ASC, 'diametrs', SORT_ASC, 'brakis_kods', SORT_ASC);
     }
     array_unshift($this->arrPrintOut, $tmp_arrCollName);
     //-#009-FUNC-END-----------------------------------------------------------------------------------------------------
     //-#010-FUNC-START--Kopsummas rindas pievienošana---------------------------------------------------------------------------------------------------
     $this->arrPrintOut[$tmp_rowCount]['nosaukums'] = 1;
     $this->arrPrintOut[$tmp_rowCount]['suga'] = "";
     $this->arrPrintOut[$tmp_rowCount]['skira'] = "";
     $this->arrPrintOut[$tmp_rowCount]['diametrs'] = "";
     $this->arrPrintOut[$tmp_rowCount]['garums'] = "";
     $this->arrPrintOut[$tmp_rowCount]['brakis_kods'] = "";
     $this->arrPrintOut[$tmp_rowCount]['skaits'] = $tmp_balkuSkaits;
     $this->arrPrintOut[$tmp_rowCount]['bruto'] = number_format($tilpums_bruto_KOPA, 3, '.', '') . "*";
     $this->arrPrintOut[$tmp_rowCount]['virsmers'] = number_format($tilpums_virsmers_KOPA, 3, '.', '') . "*";
     $this->arrPrintOut[$tmp_rowCount]['redukcija'] = number_format($tilpums_redukcija_KOPA, 3, '.', '') . "*";
     $this->arrPrintOut[$tmp_rowCount]['redukcija_un_virsmers'] = number_format($tilpums_bruto_KOPA - $tilpums_neto_KOPA, 3, '.', '') . "*";
     $this->arrPrintOut[$tmp_rowCount]['brakis'] = number_format($tilpums_brakis_KOPA, 3, '.', '') . "*";
     $this->arrPrintOut[$tmp_rowCount]['neto'] = number_format($tilpums_neto_KOPA, 3, '.', '') . "*";
     $this->arrPrintOut[$tmp_rowCount]['brakis_un_neto'] = number_format($tilpums_brakis_KOPA + $tilpums_neto_KOPA, 3, '.', '') . "*";
     $this->regSuperSum['bruto'] = $tilpums_bruto_KOPA;
     $this->regSuperSum['virsmers'] = $tilpums_virsmers_KOPA;
     $this->regSuperSum['redukcija'] = $tilpums_redukcija_KOPA;
     $this->regSuperSum['brakis'] = $tilpums_brakis_KOPA;
     $this->regSuperSum['neto'] = $tilpums_neto_KOPA;
     $this->regSuperSum['skaits'] = $tmp_balkuSkaits;
     $this->regSuperSum['skaits_brakis'] = $tilpums_skaits_brakis_KOPA;
     //-#010-FUNC-END-----------------------------------------------------------------------------------------------------
     //-#011-FUNC-START-END-Rezultāts---------------------------------------------------------------------------------------------------
     //    fb($this->arrPrintOut,'arrPrintOut');
     //  break;
     return true;
 }
コード例 #4
0
 function print_level($level, $query, &$summa_p, $irbrakis_p, $suga)
 {
     $lauks = $this->MyPOST["gtype" . $level];
     ////////////////////////////////////////////////////////////////// JA IR DAL?JUMS PA SUG?M //////////////////
     if ($lauks == 'garums' || $lauks == 'mind_pirms_red') {
         // ja ir sadal?jums pa sug?m
         if ($this->MyPOST["dalit" . $level] && $suga) {
             $gvalues = "gvalues" . $level . "_" . $suga;
         } else {
             $gvalues = "gvalues" . $level;
         }
         $a = explode(',', $this->MyPOST[$gvalues]);
         $a = str_replace(' ', '', $a);
         // brāķis
         $abr = array();
         for ($i = 0; $i < count($a); $i++) {
             if (substr($a[$i], 0, 1) == 'b' || substr($a[$i], 0, 1) == 'B') {
                 $abr[$i] = '1';
                 //kursh masiva elements apzime braki
                 $a[$i] = substr($a[$i], 1);
                 //masiva elements bez B prieksa
             }
         }
     }
     ////////////////////////////////////////////////////////////////// JA IR DAL?JUMS PA SUG?M //////////////////
     if ($lauks == 'fsc') {
         $a = array();
         $a[0] = '0';
         $a[1] = '1';
         $typ = 'string';
     }
     if ($lauks == 'kad_piegad' || $lauks == 'auto' || $lauks == 'brakis' || $lauks == 'cenu_matrica' || $lauks == 'cirsmas_kods' || $lauks == 'kad_piegad' || $lauks == 'kravas_id' || $lauks == 'pavadzime.pavadzime' || $lauks == 'piegad_kods' || $lauks == 'soferis' || $lauks == 'skira' || $lauks == 'suga' || $lauks == 'iecirknis') {
         //no visiem atlas?tajiem ba??iem pavadz?m? atlasa attiec?g? lauka atrodam?s v?rt?bas (pa vienai)
         $a = array();
         $query__ = "select DISTINCT {$lauks} as lauks " . $query . " order by {$lauks} ";
         $r = $this->DB->query($query__);
         $ii = 0;
         while ($m = $this->DB->get_row($r)) {
             $a[$ii] = $m['lauks'];
             $ii++;
         }
         if ($lauks == 'brakis') {
             if ($a[count($a) - 1] == '255') {
                 for ($j = count($a) - 1; $j > 0; $j--) {
                     $a[$j] = $a[$j - 1];
                 }
                 $a[0] = '255';
             }
         }
         $typ = 'string';
     }
     $row = 0;
     $summa_p->init();
     while (list($key, $val) = each($a)) {
         if ($lauks == 'suga') {
             $suga = $val;
         }
         // virsm?ru sadal?jums
         if ($suga && $this->MyPOST['dalit_virsmeri']) {
             if ($this->MyPOST['virsmeri_' . $suga] != '') {
                 $virsmeri = explode(',', $this->MyPOST['virsmeri_' . $suga]);
                 for ($i = 0; $i < count($virsmeri); $i++) {
                     $virsmeri[$i] = $virsmeri[$i] / 100;
                 }
             }
         } else {
             if ($this->MyPOST['virsmeri'] != '') {
                 $virsmeri = explode(',', $this->MyPOST['virsmeri']);
                 for ($i = 0; $i < count($virsmeri); $i++) {
                     $virsmeri[$i] = $virsmeri[$i] / 100;
                 }
             }
         }
         if ($suga && $_POST[dalit_raukums]) {
             $raukums = raukums_2_array($_POST['raukums_' . $suga]);
         } else {
             $raukums = raukums_2_array($_POST['raukums']);
         }
         if ($suga && $this->MyPOST[dalit_koeficients]) {
             $koeficients = $this->MyPOST['koeficients_' . $suga];
         } else {
             $koeficients = $this->MyPOST['koeficients'];
         }
         if ($typ != 'string') {
             $mbounds = explode('-', $a[$row]);
         }
         if (count($mbounds) > 1) {
             $myquery = $query . " and  (" . $this->MyPOST["gtype" . $level] . ">=" . $mbounds[0] . " and " . $this->MyPOST["gtype" . $level] . "<=" . $mbounds[1] . ")";
         } else {
             if ($typ == 'string') {
                 $myquery = $query . " and  " . $this->MyPOST["gtype" . $level] . "='" . $a[$row] . "'";
             } else {
                 $myquery = $query . " and  " . $this->MyPOST["gtype" . $level] . "=" . $a[$row];
             }
         }
         $row = $row + 1;
         if ($this->rowclosed == true) {
             $this->rowclosed = false;
             $this->arr_index++;
             $this->arr[$this->arr_index] = array();
         }
         if ($level == 1) {
             $this->arr[$this->arr_index][0] = "";
         } else {
             if ($row > 1) {
                 for ($i = 1; $i < $level + 1; $i++) {
                     $this->arr[$this->arr_index][$i - 1] = "";
                 }
             }
         }
         $irbrakis = false;
         if ($irbrakis_p == true) {
             $irbrakis = true;
         }
         // Ja ir v?l dzi??ki l?me?i
         if ($level < $this->lsk) {
             if (!$val || $val == '') {
                 $this->arr[$this->arr_index][$level - 1] = "nav";
             } else {
                 $this->arr[$this->arr_index][$level - 1] = $this->kodi($this->MyPOST['gtype' . $level], $val);
             }
             $sum = new CSumma();
             if (strlen($abr[$key]) == 1) {
                 $irbrakis = true;
                 $brkods = $abr[$key];
             }
             $this->print_level($level + 1, $myquery, $sum, $irbrakis, $suga);
             // Te saskaita kop? par l?meni summu - XML varianta tas nav jadara
             if (!$this->XML_Variants) {
                 $this->arr_index++;
                 $this->arr[$this->arr_index] = array();
                 if ($sum->bruto) {
                     $this->arr[$this->arr_index][-1] = "Kopā";
                     for ($i = 0; $i < $this->lsk; $i++) {
                         if ($level == $i + 1) {
                             $this->arr[$this->arr_index][$i] = $this->kodi($this->MyPOST['gtype' . $level], $val);
                         } else {
                             $this->arr[$this->arr_index][$i] = "";
                         }
                     }
                     $this->arr[$this->arr_index][summa] = $sum;
                     //echo "<tr><td height=1 colspan=".(7+$this->lsk)."><hr></tr>";
                 }
             }
             $this->rowclosed = true;
             $summa_p->add_skaits($sum->skaits);
             //$summa_p->add_virsmers($sum->virsmers);
             //$summa_p->add_redukcija_d($sum->redukcija_d);
             //$summa_p->add_redukcija_l($sum->redukcija_l);
             //$summa_p->add_brakis($sum->brakis);
             //$summa_p->add_neto($sum->neto);
             $summa_p->add_bruto($sum->bruto);
             $this->lasttype = 'sum';
         } else {
             $this->lasttype = 'data';
             // ja nav dzi??k, tad apr??ina summu
             $query__ = "select mind_pirms_red as d1, garums as l1, mind_pec_red as d2, gar_pec_red as l2, brakis, pavadzime.cenu_matrica as cm  " . $myquery;
             $r = $this->DB->query($query__);
             $bruto = 0;
             $virsmers = 0;
             $redukcija_d = 0;
             $redukcija_l = 0;
             $brakis = 0;
             $neto = 0;
             $skaits = 0;
             while ($m = $this->DB->get_row($r)) {
                 $skaits++;
                 $d1 = $m[d1] / 1000;
                 $d2 = $m[d2] / 1000;
                 $l1 = $m[l1] / 100;
                 $l2 = $m[l2] / 100;
                 if (count($virsmeri) > 0) {
                     $l3 = 0;
                     for ($i = 0; $i < count($virsmeri); $i++) {
                         if ($virsmeri[$i] <= $l2) {
                             $l3 = $virsmeri[$i];
                         }
                     }
                 } else {
                     $l3 = $l2;
                 }
                 $rauk_koef = get_raukums_no_diam($raukums, $m[d1]);
                 $bruto_temp = f($d1, $l1, $rauk_koef, $koeficients);
                 $bruto = $bruto + $bruto_temp;
                 if ($m[brakis] != '255') {
                     $irbrakis = true;
                     $brkods = 'standart';
                 }
                 if (!$irbrakis) {
                     $redukcija_d_temp = round(f($d1, $l1, $rauk_koef, $koeficients) - f($d2, $l1, $rauk_koef, $koeficients), 3);
                     $redukcija_l_temp = round(f($d1, $l1, $rauk_koef, $koeficients) - f($d1, $l2, $rauk_koef, $koeficients), 3);
                     $redukcija_d = round($redukcija_d + $redukcija_d_temp, 3);
                     $redukcija_l = round($redukcija_l + $redukcija_l_temp, 3);
                 }
                 $b = 0;
                 if (strlen($abr[$key]) == 1) {
                     $irbrakis = true;
                     $brkods = $abr[$key];
                 }
                 // ja nav br??is
                 if (!$irbrakis) {
                     $virsmers_temp = f($d2, $l2, $rauk_koef, $koeficients) - f($d2, $l3, $rauk_koef, $koeficients);
                     $virsmers = $virsmers + $virsmers_temp;
                     $neto = $neto + ($bruto_temp - $redukcija_d_temp - $redukcija_l_temp - $virsmers_temp);
                 } else {
                     $b = f($d1, $l1, $rauk_koef, $koeficients);
                     $brakis = $brakis + $b;
                 }
             }
             //izdruk? p?d?jo rindas elementu no grup??anas nosac?jumiem
             $this->arr[$this->arr_index][$level - 1] = $this->kodi($this->MyPOST['gtype' . $this->lsk], $val);
             $sm = new CSumma();
             $sm->skaits = $skaits;
             //$sm->virsmers = $virsmers;
             //$sm->redukcija_d = $redukcija_d;
             //$sm->redukcija_l = $redukcija_l;
             //$sm->brakis = $brakis;
             //$sm->neto = $neto;
             $sm->bruto = $bruto;
             $this->arr[$this->arr_index][summa] = $sm;
             $this->rowclosed = true;
             $summa_p->add_skaits($skaits);
             //$summa_p->add_virsmers($virsmers);
             //$summa_p->add_redukcija_d($redukcija_d);
             //$summa_p->add_redukcija_l($redukcija_l);
             //$summa_p->add_brakis($brakis);
             //$summa_p->add_neto($neto);
             $summa_p->add_bruto($bruto);
         }
     }
     // "<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>";
     // Aizpild?m tuk?umus
     // "<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>";
     if ($this->lsk > 1) {
         for ($j = $this->lsk - 2; $j >= 0; $j--) {
             $v = $this->arr[0][$j];
             for ($i = 0; $i < count($this->arr); $i++) {
                 // iekop?jam ja tuk?s
                 if ($this->arr[$i][$j] == "" && $this->arr[$i][$j + 1] != "") {
                     $this->arr[$i][$j] = $v;
                 }
                 // ja nav tuk?s pa?em v?rt?bu
                 if ($this->arr[$i][$j] != "") {
                     $v = $this->arr[$i][$j];
                 }
             }
         }
     }
 }
コード例 #5
0
ファイル: GenCLS_report.php プロジェクト: EdijsMuiznieks/Test
 function constrByMask($pvdzID)
 {
     $tmp_rowCount = 1;
     $tilpums_bruto_KOPA = 0;
     $tilpums_virsmers_KOPA = 0;
     $tilpums_redukcija_KOPA = 0;
     $tilpums_neto_KOPA = 0;
     $tilpums_brakis_KOPA = 0;
     $tmp_balkuSkaits = 0;
     $tilpums_skaits_brakis_KOPA = 0;
     $bbq_temp = false;
     $liguma_matrica = '';
     $tmp_arrCollName['nosaukums'] = 1;
     $tmp_arrCollName['suga'] = "Suga";
     $tmp_arrCollName['skira'] = "Šķira";
     $tmp_arrCollName['diametrs'] = "Diametrs";
     $tmp_arrCollName['garums'] = "Garums";
     $tmp_arrCollName['brakis_kods'] = "Brāķa iemesls";
     $tmp_arrCollName['skaits'] = "Skaits";
     $tmp_arrCollName['bruto'] = "Bruto";
     $tmp_arrCollName['virsmers'] = "Virsmērs";
     $tmp_arrCollName['redukcija'] = "Redukcija";
     $tmp_arrCollName['redukcija_un_virsmers'] = "Red. un virsm.";
     $tmp_arrCollName['brakis'] = "Brāķis";
     $tmp_arrCollName['neto'] = "Neto";
     $tmp_arrCollName['brakis_un_neto'] = "Brāķis un Neto";
     $tmp_lig_matrica_txt = "SELECT `cenu_matrica` FROM " . $this->tblName . "pavadzime WHERE `id` = {$pvdzID}";
     $tmp_lig_matrica_mysql = mysql_query($tmp_lig_matrica_txt);
     while ($tmp_lig_matrica_arr = mysql_fetch_assoc($tmp_lig_matrica_mysql)) {
         $liguma_matrica = trim($tmp_lig_matrica_arr['cenu_matrica']);
     }
     $tmp_getDataQuery_txt = "SELECT * FROM " . $this->tblName . "balkis_temp WHERE pavadzime = " . $pvdzID . " ORDER BY mind_pirms_red";
     if (!$pvdzID) {
         $tmp_getDataQuery_txt = "SELECT * FROM " . $this->tblName . "balkis_temp ORDER BY mind_pirms_red";
         $bbq_temp = true;
         $trunc_SQL = "DELETE FROM `global_kops_atsk`";
         mysql_query($trunc_SQL);
     }
     $tmp_getDataQuery_query = mysql_query($tmp_getDataQuery_txt);
     if ($bbq_temp == false) {
         while ($tmp_getDataQuery_arr = mysql_fetch_assoc($tmp_getDataQuery_query)) {
             $tilpums_bruto = 0;
             $tilpums_virsmers = 0;
             $tilpums_redukcija = 0;
             $tilpums_neto = 0;
             $tilpums_brakis = 0;
             $apmaksas_garums = 0;
             $isBrakaVirsmOn = $this->MyPOST['braka_virsmers'];
             if ($tmp_getDataQuery_arr['pavadzime'] == 76806 && $this->firmCode == 2) {
                 $isBrakaVirsmOn = 'off';
             }
             //-#001-FUNC-START--Nepieciešamo datu kolekcionēšana no datubāzes------------------------------------------------------------------------------------
             $tmp_ident_balkis = $tmp_getDataQuery_arr['id'];
             $var_Suga = (string) $tmp_getDataQuery_arr['suga'];
             //      if($var_Suga == 0){$var_Suga = '0';}
             //      die('test');
             $varDateTime = $tmp_getDataQuery_arr['datums_laiks'];
             $tmp_tilpumsBruto = $tmp_getDataQuery_arr['tilpums'];
             $tmp_tilpumsNeto = $tmp_getDataQuery_arr['tilpums_scan'];
             $tmp_garums_pirms_red = $tmp_getDataQuery_arr['garums'];
             $tmp_garums_pec_red = $tmp_getDataQuery_arr['gar_pec_red'];
             $tmp_tievgalis_pirms_red = $tmp_getDataQuery_arr['mind_pirms_red'];
             $tmp_tievgalis_pec_red = $tmp_getDataQuery_arr['mind_pec_red'];
             $tmp_vidusdiametrs_pirms_red = $tmp_getDataQuery_arr['mind_miza'];
             $tmp_vidusdiametrs_pec_red = $tmp_getDataQuery_arr['mind_miza'] - ($tmp_getDataQuery_arr['mind_pirms_red'] - $tmp_getDataQuery_arr['mind_pec_red']);
             $tmp_resgalis_pirms_red = $tmp_getDataQuery_arr['maxd_miza'];
             $tmp_resgalis_pec_red = $tmp_getDataQuery_arr['maxd_miza'] - ($tmp_getDataQuery_arr['mind_pirms_red'] - $tmp_getDataQuery_arr['mind_pec_red']);
             //-#001-FUNC-END------------------------------------------------------------------------------------------------------------------------------------
             if ($this->firmCode == 26 && $liguma_matrica == 'AC' && $tmp_getDataQuery_arr['skira'] == 'E' && $tmp_getDataQuery_arr['mind_pirms_red'] > 130 && $tmp_getDataQuery_arr['mind_pirms_red'] < 180) {
                 $tmp_getDataQuery_arr['skira'] = 'B';
             }
             //  fb($this->GroupOrder,'GroupOrder');
             //-#002-FUNC-START--Nepieciešamās grupas atrašana---------------------------------------------------------------------------------------------------
             $igc = 1;
             // Grupu skaits
             $init_Group = false;
             while ($igc < 9 && $init_Group == false) {
                 $tmp_igcCheck = 0;
                 for ($igo = 1; $igo < 6; $igo++) {
                     //Grupēšanas nosacījumus cikls
                     for ($subcount = 0; $subcount < 3; $subcount++) {
                         if ($this->tmpAllGroup[$igc][$this->GroupOrder[$igo]][$subcount]) {
                             $tmp_SubResult = $this->tmpAllGroup[$igc][$this->GroupOrder[$igo]][$subcount];
                             if (!$this->tmpAllGroup[$igc][$this->GroupOrder[$igo]][0]) {
                                 $tmp_SubResult = $this->tmpAllGroup[$igc][$this->GroupOrder[$igo]][$var_Suga];
                             }
                             //              echo $this->GroupOrder[$igo].'<br />';
                             $tmp_ALLbResult = $this->getMaskGroup($tmp_SubResult, $tmp_getDataQuery_arr[$this->GroupOrder[$igo]], $this->GroupOrder[$igo]);
                             $tmp_inputArrVal[$this->GroupOrder[$igo]] = $tmp_ALLbResult;
                             if ($tmp_ALLbResult != '') {
                                 $tmp_igcCheck = $tmp_igcCheck + 1;
                             }
                         } else {
                             $tmp_igcCheck = $tmp_igcCheck + 1;
                         }
                     }
                     if ($igo == 5 && $tmp_igcCheck == 15) {
                         // Grupas noteikšana līdz pirmajiem sakritības rezultātiem (rekursija ar limitētu ciklu skaitu)
                         $init_Group = true;
                         $globalGroupIdent = $igc;
                     }
                 }
                 $igc++;
             }
             //      echo $globalGroupIdent.'<br/>';
             //-#002-FUNC-END-------------------------------------------------------------------------------------------------------------------------------------
             //-#003-FUNC-START--Tilpuma aprēķināšana-------------------------------------------------------------------------------------------------------------
             $prnt_Nosaukums = 0;
             $prnt_Suga = $this->sugas[$var_Suga]['LAT'];
             $prnt_Skira = $tmp_getDataQuery_arr['skira'];
             $prnt_Brakis = $this->braki[$tmp_getDataQuery_arr['brakis']]['LAT'];
             $prnt_Diametrs = $tmp_inputArrVal['mind_pirms_red'];
             $prnt_Garums = $tmp_inputArrVal[$this->garGrupa];
             //      echo $prnt_Garums.'<br/>';
             //      echo $this->garGrupa;
             //      $prnt_Garums = $tmp_inputArrVal['garums'];
             //---------------------------------------------------------------------------------------------------------------------------------------------------
             if ($this->firmCode == 35 && $prnt_Skira == 3) {
                 $prnt_Skira = 9;
                 $prnt_Brakis = $this->braki['010']['LAT'];
             }
             if ($this->firmCode == 37 && $prnt_Skira == 3) {
                 $prnt_Skira = 9;
                 $prnt_Brakis = $this->braki['011']['LAT'];
             }
             //---------------------------------------------------------------------------------------------------------------------------------------------------
             if ($this->MyPOST['noapalot_garumu'] == '1') {
                 $tmp_garums_pirms_red = floor($tmp_garums_pirms_red / 10) * 10;
             } elseif ($this->MyPOST['noapalot_garumu'] == '2') {
                 $tmp_garums_pirms_red = (floor($tmp_garums_pirms_red / 10) + 0.5) * 10;
             }
             $tmp_raukumaRinda = $this->tmpRaukGroup[$globalGroupIdent][0];
             if (!$tmp_raukumaRinda) {
                 $tmp_raukumaRinda = $this->tmpRaukGroup[$globalGroupIdent][$var_Suga];
             }
             $raukums = raukums_2_array($tmp_raukumaRinda);
             $rauk_koef = get_raukums_no_diam($raukums, $tmp_tievgalis_pirms_red);
             $tmp_DiamRedukcija = $tmp_tievgalis_pirms_red - $tmp_tievgalis_pec_red;
             $tilpums_bruto = $this->calc_Volume($tmp_tievgalis_pirms_red, $tmp_vidusdiametrs_pirms_red, $tmp_resgalis_pirms_red, $tmp_garums_pirms_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
             if ($this->MyPOST['noapalot_diametru'] == 'on') {
                 $tmp_tievgalis_pec_red = (floor($tmp_tievgalis_pec_red / 10) + 0.5) * 100;
             }
             $tmp_virsmeraRinda = $this->tmpNomGarGroup[$globalGroupIdent][0];
             if (!$tmp_virsmeraRinda) {
                 $tmp_virsmeraRinda = $this->tmpNomGarGroup[$globalGroupIdent][$var_Suga];
             }
             $tmp_virsmeraRindaBrakis = $this->tmpNomGarBrakGroup[$globalGroupIdent][0];
             if (!$tmp_virsmeraRindaBrakis) {
                 $tmp_virsmeraRindaBrakis = $this->tmpNomGarBrakGroup[$globalGroupIdent][$var_Suga];
             }
             if ($tmp_virsmeraRindaBrakis) {
                 $virsmeri_brakim = explode(',', $tmp_virsmeraRindaBrakis);
                 for ($i = 0; $i < count($virsmeri_brakim); $i++) {
                     $virsmeri_brakim[$i] = $virsmeri_brakim[$i];
                 }
             }
             $virsmeri = explode(',', $tmp_virsmeraRinda);
             for ($i = 0; $i < count($virsmeri); $i++) {
                 $virsmeri[$i] = $virsmeri[$i];
             }
             $tmp_mini_virsmeraRinda = $this->tmpVirsmGroup[$globalGroupIdent][0];
             if (!$tmp_mini_virsmeraRinda) {
                 $tmp_mini_virsmeraRinda = $this->tmpVirsmGroup[$globalGroupIdent][$var_Suga];
             }
             $tmp_nom_garums_pirms_red = nominalGarums($tmp_getDataQuery_arr['garums'], $virsmeri, $tmp_mini_virsmeraRinda);
             $tmp_nom_garums_pec_red = nominalGarums($tmp_garums_pec_red, $virsmeri, $tmp_mini_virsmeraRinda);
             if ($this->MyPOST['is_vika'] == 'on') {
                 $tmp_garums_pec_red = $tmp_garums_pec_red + $tmp_mini_virsmeraRinda;
                 $tmp_nom_garums_pec_red = nominalGarums($tmp_garums_pec_red, $virsmeri, $tmp_mini_virsmeraRinda);
                 $tilpums_neto = $this->calc_Volume($tmp_tievgalis_pec_red, $tmp_vidusdiametrs_pec_red, $tmp_resgalis_pec_red, $tmp_nom_garums_pec_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
                 $tilpums_bruto_virsmeram = $this->calc_Volume($tmp_tievgalis_pirms_red, $tmp_vidusdiametrs_pirms_red, $tmp_resgalis_pirms_red, $tmp_nom_garums_pirms_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
                 $tilpums_virsmers = ROUND($tilpums_bruto - $tilpums_bruto_virsmeram, 3);
                 $tilpums_redukcija = $tilpums_bruto_virsmeram - $tilpums_neto;
             } else {
                 $tilpums_neto = $this->calc_Volume($tmp_tievgalis_pec_red, $tmp_vidusdiametrs_pec_red, $tmp_resgalis_pec_red, $tmp_nom_garums_pec_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
                 $tilpums_bruto_virsmeram = $this->calc_Volume($tmp_tievgalis_pirms_red, $tmp_vidusdiametrs_pirms_red, $tmp_resgalis_pirms_red, $tmp_nom_garums_pirms_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
                 $tilpums_virsmers = ROUND($tilpums_bruto - $tilpums_bruto_virsmeram, 3);
                 $tilpums_redukcija = $tilpums_bruto_virsmeram - $tilpums_neto;
             }
             if ($this->MyPOST['metode'] == 4) {
                 if ($this->firmCode == 27) {
                     $tilpums_bruto = floor($tmp_tilpumsBruto / 10) / 1000;
                     $tilpums_neto = floor($tmp_tilpumsNeto / 10) / 1000;
                     $tilpums_bruto_virsmeram = floor($tmp_tilpumsNeto / 10) / 1000;
                     $tilpums_virsmers = $tilpums_bruto - $tilpums_bruto_virsmeram;
                     $tilpums_redukcija = 0;
                 } else {
                     $tilpums_bruto = $tmp_tilpumsBruto;
                     $tilpums_neto = $tmp_tilpumsNeto;
                     $tilpums_bruto_virsmeram = $tmp_tilpumsNeto;
                     $tilpums_virsmers = $tilpums_bruto - $tilpums_bruto_virsmeram;
                     if ($this->firmCode == 26) {
                     }
                     $tilpums_redukcija = 0;
                 }
             }
             $apmaksas_garums = $tmp_nom_garums_pec_red;
             if ($tilpums_virsmers < 0) {
                 $tilpums_virsmers = 0;
             }
             if ($tilpums_bruto_virsmeram == 0) {
                 $tilpums_virsmers = 0;
             }
             if ($tilpums_redukcija < 0) {
                 $tilpums_redukcija = 0;
             }
             //-#003-FUNC-END--------------------------------------------------------------------------------------------------------------------------------------
             //-#004-FUNC-START--Papildus dimensijas brāķa piešķiršana--------------------------------------------------------------------------------------------
             $takeReCallOn4 = false;
             if ($tmp_nom_garums_pec_red < 1 && !$prnt_Brakis) {
                 $prnt_Skira = 9;
                 $prnt_Brakis = $this->braki['899']['LAT'];
                 $takeReCallOn4 = true;
             }
             if (substr($prnt_Diametrs, 0, 1) == 'b' && !$prnt_Brakis) {
                 $prnt_Skira = 9;
                 $prnt_Brakis = $this->braki['899']['LAT'];
                 $prnt_Diametrs = str_replace('b', '', $prnt_Diametrs);
                 $takeReCallOn4 = true;
             }
             if (substr($prnt_Garums, 0, 1) == 'b' && !$prnt_Brakis) {
                 $prnt_Skira = 9;
                 $prnt_Brakis = $this->braki['899']['LAT'];
                 $prnt_Garums = str_replace('b', '', $prnt_Garums);
                 $takeReCallOn4 = true;
             }
             if ($prnt_Brakis == 'D') {
                 // XML nobrāķēšana ar 4 kodu
                 $takeReCallOn4 = true;
             }
             if ($this->firmCode == 26 && $tmp_getDataQuery_arr['brakis'] == '017' && $liguma_matrica == 'AC') {
                 $tmp_is4 = mod_ResignLVMRejectCode($this->firmCode, $liguma_matrica, $tmp_getDataQuery_arr['garums'], $tmp_getDataQuery_arr['mind_pirms_red'], $tmp_getDataQuery_arr['suga'], $tmp_getDataQuery_arr['skira'], $tmp_getDataQuery_arr['brakis']);
                 if ($tmp_is4) {
                     $prnt_Brakis = $this->braki['702']['LAT'];
                 }
             }
             if ($takeReCallOn4) {
                 $tmp_is4 = mod_ResignLVMRejectCode($this->firmCode, $liguma_matrica, $tmp_getDataQuery_arr['garums'], $tmp_getDataQuery_arr['mind_pirms_red'], $tmp_getDataQuery_arr['suga'], $tmp_getDataQuery_arr['skira'], $tmp_getDataQuery_arr['brakis']);
                 if ($tmp_is4) {
                     $prnt_Brakis = $this->braki['856']['LAT'];
                 }
             }
             if ($this->firmCode == 25) {
                 if ($tmp_getDataQuery_arr['brakis'] == '003') {
                     $prnt_Brakis = $this->braki['003']['LAT'];
                 }
             }
             //-#004-FUNC-END-----------------------------------------------------------------------------------------------------
             //-#005-FUNC-START--Brāķa tilpuma aprēķināšana---------------------------------------------------------------------------------------------------
             if ($prnt_Brakis) {
                 $tilpums_neto = 0;
                 $tilpums_redukcija = 0;
                 if ($isBrakaVirsmOn == 'on') {
                     if ($virsmeri_brakim) {
                         $tmp_nom_garums_pirms_red_brakim = nominalGarums($tmp_getDataQuery_arr['garums'], $virsmeri_brakim, $tmp_mini_virsmeraRinda);
                         $tilpums_bruto_virsmeram = $this->calc_Volume($tmp_tievgalis_pirms_red, $tmp_vidusdiametrs_pirms_red, $tmp_resgalis_pirms_red, $tmp_nom_garums_pirms_red_brakim, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
                         $apmaksas_garums = $tmp_nom_garums_pirms_red_brakim;
                         if ($tilpums_bruto_virsmeram > 0) {
                             $tilpums_virsmers = $tilpums_bruto - $tilpums_bruto_virsmeram;
                             $tilpums_brakis = $tilpums_bruto_virsmeram;
                             $apmaksas_garums = $tmp_garums_pirms_red;
                         } else {
                             $tilpums_virsmers = 0;
                             $tilpums_brakis = $tilpums_bruto;
                             $apmaksas_garums = $tmp_garums_pirms_red;
                         }
                     } else {
                         if ($tilpums_bruto_virsmeram > 0) {
                             $tilpums_brakis = $tilpums_bruto_virsmeram;
                             $apmaksas_garums = $tmp_nom_garums_pirms_red;
                         } else {
                             $tilpums_virsmers = 0;
                             $tilpums_brakis = $tilpums_bruto;
                             $apmaksas_garums = $tmp_garums_pirms_red;
                         }
                     }
                 } else {
                     $tilpums_virsmers = 0;
                     $tilpums_brakis = $tilpums_bruto;
                     $apmaksas_garums = $tmp_garums_pirms_red;
                 }
             }
             $tmp_inputArrVal['mind_pirms_red'] = str_replace('b', '', $tmp_inputArrVal['mind_pirms_red']);
             $prnt_Diametrs = str_replace('b', '', $prnt_Diametrs);
             $tmp_inputArrVal['garums'] = str_replace('b', '', $tmp_inputArrVal['garums']);
             $prnt_Garums = str_replace('b', '', $prnt_Garums);
             //-#005-FUNC-END-----------------------------------------------------------------------------------------------------
             if ($this->genGlobalRegister_id > 0) {
                 $datumsRegNow = date("Y-m-d H:i:s");
                 $subInsertRegisterBool = $this->regSubGlobalRegisters($datumsRegNow, $varDateTime, $this->genGlobalRegister_id, $this->tmp_pavadzimeInsert, $prnt_Suga, $prnt_Skira, $tmp_getDataQuery_arr['mind_pirms_red'], $prnt_Diametrs, $tmp_getDataQuery_arr['garums'], $prnt_Garums, $prnt_Brakis, $tilpums_bruto, $tilpums_brakis, $tilpums_neto);
             }
             //-#006-FUNC-START--Vienādo grupēšanu pāskats---------------------------------------------------------------------------------------------------
             $pilnaGrupesana = false;
             if ($this->report_XML) {
                 $pilnaGrupesana = true;
             }
             if (($this->firmCode == 16 || $this->firmCode == 666 || $this->isAllReport) && !$this->report_PDF) {
                 $pilnaGrupesana = true;
             }
             $rowExist = 0;
             if (!$pilnaGrupesana) {
                 for ($protoKey = $tmp_rowCount - 1; $protoKey > 0; $protoKey--) {
                     if ($this->arrPrintOut[$protoKey]['suga'] == $prnt_Suga) {
                         if ($this->arrPrintOut[$protoKey]['skira'] == $prnt_Skira) {
                             if ($this->arrPrintOut[$protoKey]['diametrs'] == $prnt_Diametrs) {
                                 if ($this->arrPrintOut[$protoKey]['brakis_kods'] == $prnt_Brakis) {
                                     $rowExist = $protoKey;
                                 }
                             }
                         }
                     }
                 }
             } else {
                 for ($protoKey = $tmp_rowCount - 1; $protoKey > 0; $protoKey--) {
                     if ($this->arrPrintOut[$protoKey]['suga'] == $prnt_Suga) {
                         if ($this->arrPrintOut[$protoKey]['skira'] == $prnt_Skira) {
                             if ($this->arrPrintOut[$protoKey]['diametrs'] == $prnt_Diametrs) {
                                 if ($this->arrPrintOut[$protoKey]['garums'] == $prnt_Garums) {
                                     if ($this->arrPrintOut[$protoKey]['brakis_kods'] == $prnt_Brakis) {
                                         $rowExist = $protoKey;
                                     }
                                 }
                             }
                         }
                     }
                 }
             }
             //-#006-FUNC-END-----------------------------------------------------------------------------------------------------
             //-#007-FUNC-START--Statisko vērtību ievietošana---------------------------------------------------------------------------------------------------
             $insertRow = $tmp_rowCount;
             if ($rowExist != 0) {
                 $insertRow = $rowExist;
             }
             $this->arrPrintOut[$insertRow]['nosaukums'] = 0;
             $this->arrPrintOut[$insertRow]['suga'] = $prnt_Suga;
             $this->arrPrintOut[$insertRow]['skira'] = $prnt_Skira;
             $this->arrPrintOut[$insertRow]['diametrs'] = $prnt_Diametrs;
             $this->arrPrintOut[$insertRow]['garums'] = $prnt_Garums;
             $this->arrPrintOut[$insertRow]['brakis_kods'] = $prnt_Brakis;
             if ($this->report_XML) {
                 $this->arrPrintOut[$insertRow]['diametrs_tmp'] = $tmp_getDataQuery_arr['mind_pirms_red'];
                 //        $this->arrPrintOut[$insertRow]['garums_tmp'] = $tmp_getDataQuery_arr['garums'];
                 $this->arrPrintOut[$insertRow]['garums_tmp'] = $apmaksas_garums;
             }
             $this->arrPrintOut[$insertRow]['skaits'] += 1;
             if ($this->arrPrintOut[$insertRow]['brakis_kods'] != '') {
                 $tilpums_skaits_brakis_KOPA += 1;
             }
             //-#007-FUNC-END-----------------------------------------------------------------------------------------------------
             //-#008-FUNC-START--Dinamisko vērtību piešķiršana---------------------------------------------------------------------------------------------------
             $this->arrPrintOut[$insertRow]['bruto'] += $tilpums_bruto;
             $this->arrPrintOut[$insertRow]['virsmers'] += $tilpums_virsmers;
             $this->arrPrintOut[$insertRow]['redukcija'] += $tilpums_redukcija;
             $this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] += $tilpums_bruto - $tilpums_neto;
             $this->arrPrintOut[$insertRow]['brakis'] += $tilpums_brakis;
             $this->arrPrintOut[$insertRow]['neto'] += $tilpums_neto;
             $this->arrPrintOut[$insertRow]['brakis_un_neto'] += $tilpums_neto + $tilpums_brakis;
             //------------------------------------------------------------------------------------------------------
             if ($this->arrPrintOut[$insertRow]['bruto'] != '') {
                 $this->arrPrintOut[$insertRow]['bruto'] = number_format($this->arrPrintOut[$insertRow]['bruto'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['bruto'] = '';
             }
             if ($this->arrPrintOut[$insertRow]['virsmers'] != '') {
                 $this->arrPrintOut[$insertRow]['virsmers'] = number_format($this->arrPrintOut[$insertRow]['virsmers'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['virsmers'] = '';
             }
             if ($this->arrPrintOut[$insertRow]['redukcija'] != '') {
                 $this->arrPrintOut[$insertRow]['redukcija'] = number_format($this->arrPrintOut[$insertRow]['redukcija'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['redukcija'] = '';
             }
             if ($this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] != '') {
                 $this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] = number_format($this->arrPrintOut[$insertRow]['redukcija_un_virsmers'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] = '';
             }
             if ($this->arrPrintOut[$insertRow]['brakis'] != '') {
                 $this->arrPrintOut[$insertRow]['brakis'] = number_format($this->arrPrintOut[$insertRow]['brakis'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['brakis'] = '';
             }
             if ($this->arrPrintOut[$insertRow]['neto'] != '') {
                 $this->arrPrintOut[$insertRow]['neto'] = number_format($this->arrPrintOut[$insertRow]['neto'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['neto'] = '';
             }
             if ($this->arrPrintOut[$insertRow]['brakis_un_neto'] != '') {
                 $this->arrPrintOut[$insertRow]['brakis_un_neto'] = number_format($this->arrPrintOut[$insertRow]['brakis_un_neto'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['brakis_un_neto'] = '';
             }
             //------------------------------------------------------------------------------------------------------
             $tilpums_bruto_KOPA = $tilpums_bruto_KOPA + $tilpums_bruto;
             $tilpums_virsmers_KOPA = $tilpums_virsmers_KOPA + $tilpums_virsmers;
             $tilpums_redukcija_KOPA = $tilpums_redukcija_KOPA + $tilpums_redukcija;
             $tilpums_neto_KOPA = $tilpums_neto_KOPA + $tilpums_neto;
             $tilpums_brakis_KOPA = $tilpums_brakis_KOPA + $tilpums_brakis;
             $tmp_balkuSkaits++;
             $tmp_rowCount++;
         }
     } else {
         while ($tmp_getDataQuery_arr = mysql_fetch_assoc($tmp_getDataQuery_query)) {
             $tilpums_bruto = 0;
             $tilpums_virsmers = 0;
             $tilpums_redukcija = 0;
             $tilpums_neto = 0;
             $tilpums_brakis = 0;
             $isBrakaVirsmOn = $this->MyPOST['braka_virsmers'];
             if ($tmp_getDataQuery_arr['pavadzime'] == 76806 && $this->firmCode == 2) {
                 $isBrakaVirsmOn = 'off';
             }
             //-#001-FUNC-START--Nepieciešamo datu kolekcionēšana no datubāzes------------------------------------------------------------------------------------
             $tmp_ident_balkis = $tmp_getDataQuery_arr['id'];
             $var_Suga = $tmp_getDataQuery_arr['suga'];
             $tmp_tilpumsBruto = $tmp_getDataQuery_arr['tilpums'];
             $tmp_tilpumsNeto = $tmp_getDataQuery_arr['tilpums_scan'];
             $tmp_garums_pirms_red = $tmp_getDataQuery_arr['garums'];
             $tmp_garums_pec_red = $tmp_getDataQuery_arr['gar_pec_red'];
             $tmp_tievgalis_pirms_red = $tmp_getDataQuery_arr['mind_pirms_red'];
             $tmp_tievgalis_pec_red = $tmp_getDataQuery_arr['mind_pec_red'];
             $tmp_vidusdiametrs_pirms_red = $tmp_getDataQuery_arr['mind_miza'];
             $tmp_vidusdiametrs_pec_red = $tmp_getDataQuery_arr['mind_miza'] - ($tmp_getDataQuery_arr['mind_pirms_red'] - $tmp_getDataQuery_arr['mind_pec_red']);
             $tmp_resgalis_pirms_red = $tmp_getDataQuery_arr['maxd_miza'];
             $tmp_resgalis_pec_red = $tmp_getDataQuery_arr['maxd_miza'] - ($tmp_getDataQuery_arr['mind_pirms_red'] - $tmp_getDataQuery_arr['mind_pec_red']);
             //-#001-FUNC-END------------------------------------------------------------------------------------------------------------------------------------
             //-#002-FUNC-START--Nepieciešamās grupas atrašana---------------------------------------------------------------------------------------------------
             $igc = 1;
             // Grupu skaits
             $init_Group = false;
             while ($igc < 9 && $init_Group == false) {
                 $tmp_igcCheck = 0;
                 for ($igo = 1; $igo < 6; $igo++) {
                     //Grupēšanas nosacījumus cikls
                     for ($subcount = 0; $subcount < 3; $subcount++) {
                         if ($this->tmpAllGroup[$igc][$this->GroupOrder[$igo]][$subcount]) {
                             $tmp_SubResult = $this->tmpAllGroup[$igc][$this->GroupOrder[$igo]][$subcount];
                             if (!$this->tmpAllGroup[$igc][$this->GroupOrder[$igo]][0]) {
                                 $tmp_SubResult = $this->tmpAllGroup[$igc][$this->GroupOrder[$igo]][$var_Suga];
                             }
                             $tmp_ALLbResult = $this->getMaskGroup($tmp_SubResult, $tmp_getDataQuery_arr[$this->GroupOrder[$igo]], $this->GroupOrder[$igo]);
                             $tmp_inputArrVal[$this->GroupOrder[$igo]] = $tmp_ALLbResult;
                             if ($tmp_ALLbResult != '') {
                                 $tmp_igcCheck = $tmp_igcCheck + 1;
                             }
                         } else {
                             $tmp_igcCheck = $tmp_igcCheck + 1;
                         }
                     }
                     if ($igo == 5 && $tmp_igcCheck == 15) {
                         // Grupas noteikšana līdz pirmajiem sakritības rezultātiem (rekursija ar limitētu ciklu skaitu)
                         $init_Group = true;
                         $globalGroupIdent = $igc;
                     }
                 }
                 $igc++;
             }
             //-#002-FUNC-END-------------------------------------------------------------------------------------------------------------------------------------
             //-#003-FUNC-START--Tilpuma aprēķināšana-------------------------------------------------------------------------------------------------------------
             $prnt_Nosaukums = 0;
             $prnt_Suga = $this->sugas[$var_Suga]['LAT'];
             $prnt_Skira = $tmp_getDataQuery_arr['skira'];
             $prnt_Brakis = $this->braki[$tmp_getDataQuery_arr['brakis']]['LAT'];
             $prnt_Diametrs = $tmp_inputArrVal['mind_pirms_red'];
             $prnt_Garums = $tmp_inputArrVal['garums'];
             //---------------------------------------------------------------------------------------------------------------------------------------------------
             if ($this->firmCode == 35 && $prnt_Skira == 3) {
                 $prnt_Skira = 9;
                 $prnt_Brakis = $this->braki['010']['LAT'];
             }
             if ($this->firmCode == 37 && $prnt_Skira == 3) {
                 $prnt_Skira = 9;
                 $prnt_Brakis = $this->braki['011']['LAT'];
             }
             //---------------------------------------------------------------------------------------------------------------------------------------------------
             if ($this->MyPOST['noapalot_garumu'] == '1') {
                 $tmp_garums_pirms_red = floor($tmp_garums_pirms_red / 10) * 10;
             } elseif ($this->MyPOST['noapalot_garumu'] == '2') {
                 $tmp_garums_pirms_red = (floor($tmp_garums_pirms_red / 10) + 0.5) * 10;
             }
             $tmp_raukumaRinda = $this->tmpRaukGroup[$globalGroupIdent][0];
             if (!$tmp_raukumaRinda) {
                 $tmp_raukumaRinda = $this->tmpRaukGroup[$globalGroupIdent][$var_Suga];
             }
             $raukums = raukums_2_array($tmp_raukumaRinda);
             $rauk_koef = get_raukums_no_diam($raukums, $tmp_tievgalis_pirms_red);
             $tmp_DiamRedukcija = $tmp_tievgalis_pirms_red - $tmp_tievgalis_pec_red;
             $tilpums_bruto = $this->calc_Volume($tmp_tievgalis_pirms_red, $tmp_vidusdiametrs_pirms_red, $tmp_resgalis_pirms_red, $tmp_garums_pirms_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
             if ($this->MyPOST['noapalot_diametru'] == 'on') {
                 $tmp_tievgalis_pec_red = (floor($tmp_tievgalis_pec_red / 10) + 0.5) * 100;
             }
             $tmp_virsmeraRinda = $this->tmpNomGarGroup[$globalGroupIdent][0];
             if (!$tmp_virsmeraRinda) {
                 $tmp_virsmeraRinda = $this->tmpNomGarGroup[$globalGroupIdent][$var_Suga];
             }
             $tmp_virsmeraRindaBrakis = $this->tmpNomGarBrakGroup[$globalGroupIdent][0];
             if (!$tmp_virsmeraRindaBrakis) {
                 $tmp_virsmeraRindaBrakis = $this->tmpNomGarBrakGroup[$globalGroupIdent][$var_Suga];
             }
             if ($tmp_virsmeraRindaBrakis) {
                 $virsmeri_brakim = explode(',', $tmp_virsmeraRindaBrakis);
                 for ($i = 0; $i < count($virsmeri_brakim); $i++) {
                     $virsmeri_brakim[$i] = $virsmeri_brakim[$i];
                 }
             }
             $virsmeri = explode(',', $tmp_virsmeraRinda);
             for ($i = 0; $i < count($virsmeri); $i++) {
                 $virsmeri[$i] = $virsmeri[$i];
             }
             $tmp_mini_virsmeraRinda = $this->tmpVirsmGroup[$globalGroupIdent][0];
             if (!$tmp_mini_virsmeraRinda) {
                 $tmp_mini_virsmeraRinda = $this->tmpVirsmGroup[$globalGroupIdent][$var_Suga];
             }
             $tmp_nom_garums_pirms_red = nominalGarums($tmp_getDataQuery_arr['garums'], $virsmeri, $tmp_mini_virsmeraRinda);
             $tmp_nom_garums_pec_red = nominalGarums($tmp_garums_pec_red, $virsmeri, $tmp_mini_virsmeraRinda);
             if ($this->MyPOST['is_vika'] == 'on') {
                 $tmp_garums_pec_red = $tmp_garums_pec_red + $tmp_mini_virsmeraRinda;
                 $tmp_nom_garums_pec_red = nominalGarums($tmp_garums_pec_red, $virsmeri, $tmp_mini_virsmeraRinda);
                 $tilpums_neto = $this->calc_Volume($tmp_tievgalis_pec_red, $tmp_vidusdiametrs_pec_red, $tmp_resgalis_pec_red, $tmp_nom_garums_pec_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
                 $tilpums_bruto_virsmeram = $this->calc_Volume($tmp_tievgalis_pirms_red, $tmp_vidusdiametrs_pirms_red, $tmp_resgalis_pirms_red, $tmp_nom_garums_pirms_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
                 $tilpums_virsmers = ROUND($tilpums_bruto - $tilpums_bruto_virsmeram, 3);
                 $tilpums_redukcija = $tilpums_bruto_virsmeram - $tilpums_neto;
             } else {
                 $tilpums_neto = $this->calc_Volume($tmp_tievgalis_pec_red, $tmp_vidusdiametrs_pec_red, $tmp_resgalis_pec_red, $tmp_nom_garums_pec_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
                 $tilpums_bruto_virsmeram = $this->calc_Volume($tmp_tievgalis_pirms_red, $tmp_vidusdiametrs_pirms_red, $tmp_resgalis_pirms_red, $tmp_nom_garums_pirms_red, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
                 $tilpums_virsmers = ROUND($tilpums_bruto - $tilpums_bruto_virsmeram, 3);
                 $tilpums_redukcija = $tilpums_bruto_virsmeram - $tilpums_neto;
             }
             if ($this->MyPOST['metode'] == 4) {
                 if ($this->firmCode == 27) {
                     $tilpums_bruto = floor($tmp_tilpumsBruto / 10) / 1000;
                     $tilpums_neto = floor($tmp_tilpumsNeto / 10) / 1000;
                     $tilpums_bruto_virsmeram = floor($tmp_tilpumsNeto / 10) / 1000;
                     $tilpums_virsmers = $tilpums_bruto - $tilpums_bruto_virsmeram;
                     $tilpums_redukcija = 0;
                 } else {
                     $tilpums_bruto = $tmp_tilpumsBruto;
                     $tilpums_neto = $tmp_tilpumsNeto;
                     $tilpums_bruto_virsmeram = $tmp_tilpumsNeto;
                     $tilpums_virsmers = $tilpums_bruto - $tilpums_bruto_virsmeram;
                     $tilpums_redukcija = 0;
                 }
             }
             if ($tilpums_virsmers < 0) {
                 $tilpums_virsmers = 0;
             }
             if ($tilpums_bruto_virsmeram == 0) {
                 $tilpums_virsmers = 0;
             }
             if ($tilpums_redukcija < 0) {
                 $tilpums_redukcija = 0;
             }
             //-#003-FUNC-END--------------------------------------------------------------------------------------------------------------------------------------
             //-#004-FUNC-START--Papildus dimensijas brāķa priešķiršana--------------------------------------------------------------------------------------------
             $takeReCallOn4 = false;
             if ($tmp_nom_garums_pec_red < 1 && !$prnt_Brakis) {
                 $prnt_Skira = 9;
                 $prnt_Brakis = $this->braki['899']['LAT'];
                 $takeReCallOn4 = true;
             }
             if (substr($prnt_Diametrs, 0, 1) == 'b' && !$prnt_Brakis) {
                 $prnt_Skira = 9;
                 $prnt_Brakis = $this->braki['899']['LAT'];
                 $prnt_Diametrs = str_replace('b', '', $prnt_Diametrs);
                 $takeReCallOn4 = true;
             }
             if (substr($prnt_Garums, 0, 1) == 'b' && !$prnt_Brakis) {
                 $prnt_Skira = 9;
                 $prnt_Brakis = $this->braki['899']['LAT'];
                 $prnt_Garums = str_replace('b', '', $prnt_Garums);
                 $takeReCallOn4 = true;
             }
             if ($this->firmCode == 26 && $tmp_getDataQuery_arr['brakis'] == '017' && $liguma_matrica == 'AC') {
                 $tmp_is4 = mod_ResignLVMRejectCode($this->firmCode, $liguma_matrica, $tmp_getDataQuery_arr['garums'], $tmp_getDataQuery_arr['mind_pirms_red'], $tmp_getDataQuery_arr['suga'], $tmp_getDataQuery_arr['skira'], $tmp_getDataQuery_arr['brakis']);
                 if ($tmp_is4) {
                     $prnt_Brakis = $this->braki['702']['LAT'];
                 }
             }
             if ($prnt_Brakis == 'D') {
                 // XML nobrāķēšana ar 4 kodu
                 $takeReCallOn4 = true;
             }
             if ($takeReCallOn4) {
                 $tmp_is4 = mod_ResignLVMRejectCode($this->firmCode, $liguma_matrica, $tmp_getDataQuery_arr['garums'], $tmp_getDataQuery_arr['mind_pirms_red'], $tmp_getDataQuery_arr['suga'], $tmp_getDataQuery_arr['skira'], $tmp_getDataQuery_arr['brakis']);
                 if ($tmp_is4) {
                     $prnt_Brakis = $this->braki['856']['LAT'];
                 }
             }
             //-#004-FUNC-END-----------------------------------------------------------------------------------------------------
             //-#005-FUNC-START--Brāķa tilpuma aprēķināšana---------------------------------------------------------------------------------------------------
             if ($prnt_Brakis) {
                 $tilpums_neto = 0;
                 $tilpums_redukcija = 0;
                 if ($isBrakaVirsmOn == 'on') {
                     if ($virsmeri_brakim) {
                         $tmp_nom_garums_pirms_red_brakim = nominalGarums($tmp_getDataQuery_arr['garums'], $virsmeri_brakim, $tmp_mini_virsmeraRinda);
                         $tilpums_bruto_virsmeram = $this->calc_Volume($tmp_tievgalis_pirms_red, $tmp_vidusdiametrs_pirms_red, $tmp_resgalis_pirms_red, $tmp_nom_garums_pirms_red_brakim, $rauk_koef, $koeficients, $gostu_tabula, $this->MyPOST['metode']);
                         if ($tilpums_bruto_virsmeram > 0) {
                             $tilpums_virsmers = $tilpums_bruto - $tilpums_bruto_virsmeram;
                             $tilpums_brakis = $tilpums_bruto_virsmeram;
                         } else {
                             $tilpums_virsmers = 0;
                             $tilpums_brakis = $tilpums_bruto;
                         }
                     } else {
                         if ($tilpums_bruto_virsmeram > 0) {
                             $tilpums_brakis = $tilpums_bruto_virsmeram;
                         } else {
                             $tilpums_virsmers = 0;
                             $tilpums_brakis = $tilpums_bruto;
                         }
                     }
                 } else {
                     $tilpums_virsmers = 0;
                     $tilpums_brakis = $tilpums_bruto;
                 }
             }
             $tmp_inputArrVal['mind_pirms_red'] = str_replace('b', '', $tmp_inputArrVal['mind_pirms_red']);
             $prnt_Diametrs = str_replace('b', '', $prnt_Diametrs);
             $tmp_inputArrVal['garums'] = str_replace('b', '', $tmp_inputArrVal['garums']);
             $prnt_Garums = str_replace('b', '', $prnt_Garums);
             //-#005-FUNC-END-----------------------------------------------------------------------------------------------------
             //-#006-FUNC-START--Vienādo grupēšanu pāskats---------------------------------------------------------------------------------------------------
             $pilnaGrupesana = false;
             if ($this->report_XML) {
                 $pilnaGrupesana = true;
             }
             if (($this->firmCode == 16 || $this->firmCode == 666 || $this->isAllReport) && !$this->report_PDF) {
                 $pilnaGrupesana = true;
             }
             //-#006-FUNC-END-----------------------------------------------------------------------------------------------------
             //-#007-FUNC-START--Statisko vērtību ievietošana---------------------------------------------------------------------------------------------------
             /*
                   $insertRow = $tmp_rowCount;
                   if($rowExist != 0){$insertRow = $rowExist;}
             
                   $this->arrPrintOut[$insertRow]['nosaukums'] = 0;
                   $this->arrPrintOut[$insertRow]['suga'] = $prnt_Suga;
                   $this->arrPrintOut[$insertRow]['skira'] = $prnt_Skira;
                   $this->arrPrintOut[$insertRow]['diametrs'] = $prnt_Diametrs;
                   $this->arrPrintOut[$insertRow]['garums'] = $prnt_Garums;
                   $this->arrPrintOut[$insertRow]['brakis_kods'] = $prnt_Brakis;
                   if($this->report_XML){
                     $this->arrPrintOut[$insertRow]['diametrs_tmp'] = $tmp_getDataQuery_arr['mind_pirms_red'];
                     $this->arrPrintOut[$insertRow]['garums_tmp'] = $tmp_getDataQuery_arr['garums'];
                   }
                   $this->arrPrintOut[$insertRow]['skaits'] += 1;
             
                   if($this->arrPrintOut[$insertRow]['brakis_kods'] != ''){
                     $tilpums_skaits_brakis_KOPA += 1;
                   }
             */
             $tmp_skaits = 1;
             $querySub_text = "INSERT INTO `global_kops_atsk` (`group_suga`,`group_skira`,`group_diametrs`,`group_garums`,`group_brakis`,`group_tilp_neto`,`group_tilp_bruto`,`group_tilp_brakis`,`group_tilp_neto_un_brakis`,`group_tilp_redukcija`,`group_tilp_virsmers`,`group_skaits`) VALUES ('{$prnt_Suga}','{$prnt_Skira}','{$prnt_Diametrs}','{$prnt_Garums}','{$prnt_Brakis}',{$tilpums_neto},{$tilpums_bruto},{$tilpums_brakis},{$tilpums_neto} + {$tilpums_brakis},{$tilpums_redukcija},{$tilpums_virsmers},{$tmp_skaits})";
             mysql_query($querySub_text);
             //-#007-FUNC-END-----------------------------------------------------------------------------------------------------
             /*
              //-#008-FUNC-START--Dinamisko vērtību piešķiršana---------------------------------------------------------------------------------------------------    
                  $this->arrPrintOut[$insertRow]['bruto'] += $tilpums_bruto;
                  $this->arrPrintOut[$insertRow]['virsmers'] += $tilpums_virsmers;
                  $this->arrPrintOut[$insertRow]['redukcija'] += $tilpums_redukcija;
                  $this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] += $tilpums_bruto - $tilpums_neto;
                  $this->arrPrintOut[$insertRow]['brakis'] += $tilpums_brakis;
                  $this->arrPrintOut[$insertRow]['neto'] += $tilpums_neto;
                  $this->arrPrintOut[$insertRow]['brakis_un_neto'] += $tilpums_neto + $tilpums_brakis;
              //------------------------------------------------------------------------------------------------------
                  if($this->arrPrintOut[$insertRow]['bruto'] != ''){$this->arrPrintOut[$insertRow]['bruto'] = number_format($this->arrPrintOut[$insertRow]['bruto'], 3, '.', '');}else{$this->arrPrintOut[$insertRow]['bruto'] = '';}
                  if($this->arrPrintOut[$insertRow]['virsmers'] != ''){$this->arrPrintOut[$insertRow]['virsmers'] = number_format($this->arrPrintOut[$insertRow]['virsmers'], 3, '.', '');}else{$this->arrPrintOut[$insertRow]['virsmers'] = '';}
                  if($this->arrPrintOut[$insertRow]['redukcija'] != ''){$this->arrPrintOut[$insertRow]['redukcija'] = number_format($this->arrPrintOut[$insertRow]['redukcija'], 3, '.', '');}else{$this->arrPrintOut[$insertRow]['redukcija'] = '';}
                  if($this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] != ''){$this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] = number_format($this->arrPrintOut[$insertRow]['redukcija_un_virsmers'], 3, '.', '');}else{$this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] = '';}
                  if($this->arrPrintOut[$insertRow]['brakis'] != ''){$this->arrPrintOut[$insertRow]['brakis'] = number_format($this->arrPrintOut[$insertRow]['brakis'], 3, '.', '');}else{$this->arrPrintOut[$insertRow]['brakis'] = '';}
                  if($this->arrPrintOut[$insertRow]['neto'] != ''){$this->arrPrintOut[$insertRow]['neto'] = number_format($this->arrPrintOut[$insertRow]['neto'], 3, '.', '');}else{$this->arrPrintOut[$insertRow]['neto'] = '';}
                  if($this->arrPrintOut[$insertRow]['brakis_un_neto'] != ''){$this->arrPrintOut[$insertRow]['brakis_un_neto'] = number_format($this->arrPrintOut[$insertRow]['brakis_un_neto'], 3, '.', '');}else{$this->arrPrintOut[$insertRow]['brakis_un_neto'] = '';}
              //------------------------------------------------------------------------------------------------------
             
                  $tilpums_bruto_KOPA = $tilpums_bruto_KOPA + $tilpums_bruto;
                  $tilpums_virsmers_KOPA = $tilpums_virsmers_KOPA + $tilpums_virsmers;
                  $tilpums_redukcija_KOPA = $tilpums_redukcija_KOPA + $tilpums_redukcija;
                  $tilpums_neto_KOPA = $tilpums_neto_KOPA + $tilpums_neto;
                  $tilpums_brakis_KOPA = $tilpums_brakis_KOPA + $tilpums_brakis;
             
                  $tmp_balkuSkaits++;
                  $tmp_rowCount++;
             */
         }
         $mysqlGlobalSelect_text = "SELECT `group_suga`, `group_skira`, `group_diametrs`, `group_garums`, `group_brakis`, SUM(`group_skaits`) as skaits, SUM(`group_tilp_bruto`) as bruto, SUM(`group_tilp_virsmers`) as virsmers, SUM(`group_tilp_redukcija`) as redukcija, SUM(`group_tilp_brakis`) as brakis_tilp, SUM(`group_tilp_neto`) as neto FROM `global_kops_atsk` GROUP BY `group_suga`, `group_skira`, `group_diametrs`, `group_garums`, `group_brakis` ORDER BY `group_suga`, `group_skira`, `group_diametrs`, `group_garums`, `group_brakis`";
         //    echo $mysqlGlobalSelect_text.'<br />';
         $mysqlGlobalSelect = mysql_query($mysqlGlobalSelect_text);
         $insertRow = $tmp_rowCount;
         while ($mysqlGlobalSelect_arr = mysql_fetch_assoc($mysqlGlobalSelect)) {
             $this->arrPrintOut[$insertRow]['nosaukums'] = 0;
             $this->arrPrintOut[$insertRow]['suga'] = $mysqlGlobalSelect_arr['group_suga'];
             $this->arrPrintOut[$insertRow]['skira'] = $mysqlGlobalSelect_arr['group_skira'];
             $this->arrPrintOut[$insertRow]['diametrs'] = $mysqlGlobalSelect_arr['group_diametrs'];
             $this->arrPrintOut[$insertRow]['garums'] = $mysqlGlobalSelect_arr['group_garums'];
             $this->arrPrintOut[$insertRow]['brakis_kods'] = $mysqlGlobalSelect_arr['group_brakis'];
             $this->arrPrintOut[$insertRow]['skaits'] = $mysqlGlobalSelect_arr['skaits'];
             $this->arrPrintOut[$insertRow]['bruto'] = $mysqlGlobalSelect_arr['bruto'];
             $this->arrPrintOut[$insertRow]['virsmers'] = $mysqlGlobalSelect_arr['virsmers'];
             $this->arrPrintOut[$insertRow]['redukcija'] = $mysqlGlobalSelect_arr['redukcija'];
             $this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] = $mysqlGlobalSelect_arr['redukcija'] + $mysqlGlobalSelect_arr['virsmers'];
             $this->arrPrintOut[$insertRow]['brakis'] = $mysqlGlobalSelect_arr['brakis_tilp'];
             $this->arrPrintOut[$insertRow]['neto'] = $mysqlGlobalSelect_arr['neto'];
             $this->arrPrintOut[$insertRow]['brakis_un_neto'] = $mysqlGlobalSelect_arr['brakis'] + $mysqlGlobalSelect_arr['neto'];
             if ($this->arrPrintOut[$insertRow]['bruto'] != '' && $this->arrPrintOut[$insertRow]['bruto'] != 0) {
                 $this->arrPrintOut[$insertRow]['bruto'] = number_format($this->arrPrintOut[$insertRow]['bruto'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['bruto'] = '';
             }
             if ($this->arrPrintOut[$insertRow]['virsmers'] != '' && $this->arrPrintOut[$insertRow]['virsmers'] != 0) {
                 $this->arrPrintOut[$insertRow]['virsmers'] = number_format($this->arrPrintOut[$insertRow]['virsmers'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['virsmers'] = '';
             }
             if ($this->arrPrintOut[$insertRow]['redukcija'] != '' && $this->arrPrintOut[$insertRow]['redukcija'] != 0) {
                 $this->arrPrintOut[$insertRow]['redukcija'] = number_format($this->arrPrintOut[$insertRow]['redukcija'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['redukcija'] = '';
             }
             if ($this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] != '' && $this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] != 0) {
                 $this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] = number_format($this->arrPrintOut[$insertRow]['redukcija_un_virsmers'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['redukcija_un_virsmers'] = '';
             }
             if ($this->arrPrintOut[$insertRow]['brakis'] != '' && $this->arrPrintOut[$insertRow]['brakis'] != 0) {
                 $this->arrPrintOut[$insertRow]['brakis'] = number_format($this->arrPrintOut[$insertRow]['brakis'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['brakis'] = '';
             }
             if ($this->arrPrintOut[$insertRow]['neto'] != '' && $this->arrPrintOut[$insertRow]['neto'] != 0) {
                 $this->arrPrintOut[$insertRow]['neto'] = number_format($this->arrPrintOut[$insertRow]['neto'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['neto'] = '';
             }
             if ($this->arrPrintOut[$insertRow]['brakis_un_neto'] != '' && $this->arrPrintOut[$insertRow]['brakis_un_neto'] != 0) {
                 $this->arrPrintOut[$insertRow]['brakis_un_neto'] = number_format($this->arrPrintOut[$insertRow]['brakis_un_neto'], 3, '.', '');
             } else {
                 $this->arrPrintOut[$insertRow]['brakis_un_neto'] = '';
             }
             $tilpums_bruto_KOPA = $tilpums_bruto_KOPA + $mysqlGlobalSelect_arr['bruto'];
             $tilpums_virsmers_KOPA = $tilpums_virsmers_KOPA + $mysqlGlobalSelect_arr['virsmers'];
             $tilpums_redukcija_KOPA = $tilpums_redukcija_KOPA + $mysqlGlobalSelect_arr['redukcija'];
             $tilpums_neto_KOPA = $tilpums_neto_KOPA + $mysqlGlobalSelect_arr['neto'];
             $tilpums_brakis_KOPA = $tilpums_brakis_KOPA + $mysqlGlobalSelect_arr['brakis_tilp'];
             $tmp_balkuSkaits = $tmp_balkuSkaits + $mysqlGlobalSelect_arr['skaits'];
             $tmp_rowCount++;
             $insertRow++;
         }
     }
     //  }
     //-#008-FUNC-END-----------------------------------------------------------------------------------------------------
     //-#009-FUNC-START--Rindu pārgrupēšana masīvā---------------------------------------------------------------------------------------------------
     if (($this->firmCode == 16 || $this->firmCode == 20 || $bbq_temp == true || $this->isAllReport) && !$this->report_PDF && !$this->report_XML) {
         $this->arrPrintOut = array_orderby($this->arrPrintOut, 'suga', SORT_ASC, 'skira', SORT_ASC, 'diametrs', SORT_ASC, 'garums', SORT_ASC, 'brakis_kods', SORT_ASC);
     } else {
         $this->arrPrintOut = array_orderby($this->arrPrintOut, 'suga', SORT_ASC, 'skira', SORT_ASC, 'diametrs', SORT_ASC, 'brakis_kods', SORT_ASC);
     }
     array_unshift($this->arrPrintOut, $tmp_arrCollName);
     //-#009-FUNC-END-----------------------------------------------------------------------------------------------------
     //-#010-FUNC-START--Kopsummas rindas pievienošana---------------------------------------------------------------------------------------------------
     $this->arrPrintOut[$tmp_rowCount]['nosaukums'] = 1;
     $this->arrPrintOut[$tmp_rowCount]['suga'] = "";
     $this->arrPrintOut[$tmp_rowCount]['skira'] = "";
     $this->arrPrintOut[$tmp_rowCount]['diametrs'] = "";
     $this->arrPrintOut[$tmp_rowCount]['garums'] = "";
     $this->arrPrintOut[$tmp_rowCount]['brakis_kods'] = "";
     $this->arrPrintOut[$tmp_rowCount]['skaits'] = $tmp_balkuSkaits;
     $this->arrPrintOut[$tmp_rowCount]['bruto'] = number_format($tilpums_bruto_KOPA, 3, '.', '') . "*";
     $this->arrPrintOut[$tmp_rowCount]['virsmers'] = number_format($tilpums_virsmers_KOPA, 3, '.', '') . "*";
     $this->arrPrintOut[$tmp_rowCount]['redukcija'] = number_format($tilpums_redukcija_KOPA, 3, '.', '') . "*";
     $this->arrPrintOut[$tmp_rowCount]['redukcija_un_virsmers'] = number_format($tilpums_bruto_KOPA - $tilpums_neto_KOPA, 3, '.', '') . "*";
     $this->arrPrintOut[$tmp_rowCount]['brakis'] = number_format($tilpums_brakis_KOPA, 3, '.', '') . "*";
     $this->arrPrintOut[$tmp_rowCount]['neto'] = number_format($tilpums_neto_KOPA, 3, '.', '') . "*";
     $this->arrPrintOut[$tmp_rowCount]['brakis_un_neto'] = number_format($tilpums_brakis_KOPA + $tilpums_neto_KOPA, 3, '.', '') . "*";
     $this->regSuperSum['bruto'] = $tilpums_bruto_KOPA;
     $this->regSuperSum['virsmers'] = $tilpums_virsmers_KOPA;
     $this->regSuperSum['redukcija'] = $tilpums_redukcija_KOPA;
     $this->regSuperSum['brakis'] = $tilpums_brakis_KOPA;
     $this->regSuperSum['neto'] = $tilpums_neto_KOPA;
     $this->regSuperSum['skaits'] = $tmp_balkuSkaits;
     $this->regSuperSum['skaits_brakis'] = $tilpums_skaits_brakis_KOPA;
     //-#010-FUNC-END-----------------------------------------------------------------------------------------------------
     //-#011-FUNC-START-END-Rezultāts---------------------------------------------------------------------------------------------------
     //    fb($this->arrPrintOut,'arrPrintOut');
     //  break;
     return true;
 }
コード例 #6
0
 function print_level($query, &$summa_p, $irbrakis_p, $suga, $id)
 {
     global $lang;
     global $translate;
     $select = "";
     $orderby = "ORDER BY ";
     $criteria = array();
     for ($level = 1; $level <= $this->lsk; $level++) {
         // tekošā grupēšanas līmeņa lauks
         $lauks = $this->MyPOST["gtype" . $this->grup . $level];
         if ($lauks == 'garums' || $lauks == 'mind_pirms_red') {
             $this->build_value_ranges($level, $suga);
             if ($lauks == 'garums') {
                 $this->gar_allowed_values = $this->allowed_values;
             } elseif ($lauks == 'mind_pirms_red') {
                 $this->diam_allowed_values = $this->allowed_values;
             }
         }
         if ($lauks == 'fsc') {
             $this->allowed_values = array();
             $this->allowed_values[0] = '0';
             $this->allowed_values[1] = '1';
             $typ = 'string';
         }
         if ($lauks == 'kad_piegad' || $lauks == 'auto' || $lauks == 'brakis' || $lauks == 'cenu_matrica' || $lauks == 'cirsmas_kods' || $lauks == 'kad_piegad' || $lauks == 'kravas_id' || $lauks == 'pavadzime.pavadzime' || $lauks == 'piegad_kods' || $lauks == 'soferis' || $lauks == 'skira' || $lauks == 'suga' || $lauks == 'iecirknis') {
             //no visiem atlas?tajiem ba??iem pavadz?m? atlasa attiec?g? lauka atrodam?s v?rt?bas (pa vienai)
             $this->build_single_values($lauks, $query);
         }
         $row = 0;
         $summa_p->init();
         $myid = 0;
         while (list($key, $val) = each($this->allowed_values)) {
             $myid++;
             if ($lauks == 'suga') {
                 $suga = $val;
             }
             // virsm?ru sadal?jums
             if ($suga && $this->MyPOST['dalit_virsmeri' . $this->grup]) {
                 if ($this->MyPOST['virsmeri' . $this->grup . '_' . $suga] != '') {
                     $virsmeri = explode(',', $this->MyPOST['virsmeri' . $this->grup . '_' . $suga]);
                     for ($i = 0; $i < count($virsmeri); $i++) {
                         $virsmeri[$i] = $virsmeri[$i] / 100;
                     }
                 }
             } else {
                 if ($this->MyPOST['virsmeri' . $this->grup] != '') {
                     $virsmeri = explode(',', $this->MyPOST['virsmeri' . $this->grup]);
                     for ($i = 0; $i < count($virsmeri); $i++) {
                         $virsmeri[$i] = $virsmeri[$i] / 100;
                     }
                 }
             }
             if ($suga && $this->MyPOST['dalit_raukums' . $this->grup]) {
                 $raukums = raukums_2_array($this->MyPOST['raukums' . $this->grup . '_' . $suga]);
             } else {
                 $raukums = raukums_2_array($this->MyPOST['raukums' . $this->grup]);
             }
             if ($suga && $this->MyPOST['dalit_koeficients' . $this->grup]) {
                 $koeficients = $this->MyPOST['koeficients' . $this->grup . '_' . $suga];
             } else {
                 $koeficients = $this->MyPOST['koeficients' . $this->grup];
             }
             if ($typ != 'string') {
                 $mbounds = explode('-', $this->allowed_values[$key]);
             }
             if (count($mbounds) > 1) {
                 $low_range_brakis = 0;
                 $high_range_brakis = 0;
                 if ($mbounds[0] > 5) {
                     $low_range_brakis = $mbounds[0] + 5;
                 } else {
                     $low_range_brakis = $mbounds[0];
                 }
                 if ($mbounds[1] < 994) {
                     $high_range_brakis = $mbounds[1] + 5;
                 } else {
                     $high_range_brakis = $mbounds[1];
                 }
                 //pievienots 17.07.2007
                 if ($myid == 1) {
                     $select .= ", CASE \n";
                 }
                 if ($this->MyPOST["gtype" . $this->grup . $level] == 'mind_pirms_red') {
                     $select .= "WHEN ((balkis_temp.import_type <> 'zbm' AND mind_pirms_red BETWEEN {$mbounds['0']} AND {$mbounds['1']}) OR (balkis_temp.import_type = 'zbm' AND mind_pirms_red BETWEEN {$low_range_brakis} AND {$high_range_brakis})) THEN {$myid} \n";
                     if ($myid == sizeof($this->allowed_values)) {
                         $select .= "END AS diam_group";
                         $orderby .= "diam_group";
                         $criteria[] = "diam_group";
                         //
                     }
                     //$myquery = $query . " and  ((". $this->MyPOST["gtype".$this->grup.$level] . ">=" . $mbounds[0] ." and " . $this->MyPOST["gtype".$this->grup.$level] . "<=" . $mbounds[1] . " AND balkis_temp.import_type <> 'zbm') or (". $this->MyPOST["gtype".$this->grup.$level] . ">=" . $low_range_brakis ." and " . $this->MyPOST["gtype".$this->grup.$level] . "<=" . $high_range_brakis . " AND balkis_temp.import_type = 'zbm'))";
                 } else {
                     $select .= "WHEN (garums BETWEEN {$mbounds['0']} AND {$mbounds['1']}) THEN {$myid} \n";
                     if ($myid == sizeof($this->allowed_values)) {
                         $select .= "END AS gar_group";
                         $orderby .= "gar_group";
                         $criteria[] = "gar_group";
                         //$this->gar_allowed_values = $this->allowed_values;
                     }
                     //$myquery = $query . " and  (". $this->MyPOST["gtype".$this->grup.$level] . ">=" . $mbounds[0] ." and " . $this->MyPOST["gtype".$this->grup.$level] . "<=" . $mbounds[1] . ")";
                 }
             } else {
                 if ($myid == sizeof($this->allowed_values)) {
                     $orderby .= $this->MyPOST["gtype" . $this->grup . $level];
                     $criteria[] = $this->MyPOST["gtype" . $this->grup . $level];
                 }
             }
             if ($myid == sizeof($this->allowed_values) && $level < $this->lsk) {
                 $orderby .= ",";
             }
         }
     }
     $query__ = "select mind_pirms_red as DBruto, garums as LBruto, mind_pec_red as DPecReduc, gar_pec_red as LPecReduc, brakis, suga, pavadzime.cenu_matrica as cm" . $select . $query . $orderby;
     $r = mysql_query($query__);
     $same_group = false;
     $gostu_tabula = $this->MyPOST['gostu_tabula' . $this->grup];
     while ($m = mysql_fetch_array($r)) {
         $last = $m;
         $same_group = true;
         $criteria_changed = 6;
         for ($ci = $this->lsk - 1; $ci >= 0; $ci--) {
             $value = $criteria[$ci];
             if ($old_values[$value] != $m[$value]) {
                 $criteria_changed = $ci;
             }
             if ($old_values[$value] != $m[$value]) {
                 if ($same_group) {
                     $old_bak = $old_values;
                 }
                 $same_group = false;
                 $old_values[$value] = $m[$value];
             }
         }
         if (!$same_group && $old_bak) {
             for ($ci = $this->lsk - 2; $ci >= 0; $ci--) {
                 if (!$summa[$ci + 1]) {
                     $summa[$ci + 1] = new CSumma();
                 }
                 $summa[$ci + 1]->add_skaits($SSkaits);
                 $summa[$ci + 1]->add_skaits_bad($SSkaitsBad);
                 $summa[$ci + 1]->add_virsmers($SVVirsm);
                 $summa[$ci + 1]->add_redukcija_d($SVReducD);
                 $summa[$ci + 1]->add_redukcija_l($SVReducL);
                 $summa[$ci + 1]->add_brakis($SVBrakis);
                 $summa[$ci + 1]->add_neto($SVNeto);
                 $summa[$ci + 1]->add_bruto($SVBruto);
                 if ($criteria_changed <= $ci && !$this->XML_Variants) {
                     //fb($summa,'Summa');
                     $this->AddSumRowAtLevel($ci, $criteria, $summa, $old_bak);
                 }
             }
             $this->arr_index++;
             $this->arr[$this->arr_index] = array();
             foreach ($criteria as $key => $value) {
                 $this->arr[$this->arr_index][$key] = $this->kodi($value, $old_bak[$value]);
             }
             $sm = new CSumma();
             $sm->skaits = $SSkaits;
             $sm->skaits_bad = $SSkaitsBad;
             $sm->virsmers = $SVVirsm;
             $sm->redukcija_d = $SVReducD;
             $sm->redukcija_l = $SVReducL;
             $sm->brakis = $SVBrakis;
             $sm->neto = $SVNeto;
             $sm->bruto = $SVBruto;
             //fb($sm,'Sm');
             $this->arr[$this->arr_index][summa] = $sm;
             //echo $m['brakis'];
             $summa_p->add_skaits($SSkaits);
             $summa_p->add_skaits_bad($SSkaitsBad);
             $summa_p->add_virsmers($SVVirsm);
             $summa_p->add_redukcija_d($SVReducD);
             $summa_p->add_redukcija_l($SVReducL);
             $summa_p->add_brakis($SVBrakis);
             $summa_p->add_neto($SVNeto);
             $summa_p->add_bruto($SVBruto);
             /*NULL vertibu ievietosana*/
             $SVBruto = 0;
             $SVReducD = 0;
             $SVReducL = 0;
             $SVVirsm = 0;
             $SVNeto = 0;
             $SVBrakis = 0;
             $SSkaits = 0;
             $SSkaitsBad = 0;
         }
         $SSkaits++;
         /*Vai ir Vika Wood*/
         //		$min_virsmers = 0;
         if ($suga && $this->MyPOST['dalit_virsmers' . $this->grup]) {
             $min_virsmers = $this->MyPOST['virsmers' . $this->grup . '_' . $suga] / 100;
         } else {
             $min_virsmers = $this->MyPOST['virsmers' . $this->grup] / 100;
         }
         if ($this->MyPOST['metode'] == '1') {
         } else {
             if ($this->MyPOST['metode'] == '2') {
             } else {
                 if ($this->MyPOST['metode'] == '3') {
                 } else {
                     if ($this->MyPOST['metode'] == '4') {
                     } else {
                     }
                 }
             }
         }
         $tilp_Metode = $this->MyPOST['metode'];
         $gar_PirmsRed = 0;
         $gar_PecRed = 0;
         $diam_TievPirmsRed = 0;
         $diam_TievPecRed = 0;
         $diam_VidusPirmsRed = 0;
         $diam_VidusPecRed = 0;
         $diam_ResPirmsRed = 0;
         $diam_ResPecRed = 0;
         //---Tiek veikta pārbaude, pēc kādiem nosacījumiem noapaļot garumu pirms redukcijas, no kura tiek rēķināts Bruto tilpums!-------------------------------------------------------------------------
         $gar_PirmsRed = $m['LBruto'] / 100;
         if ($this->MyPOST['noapalot_garumu'] == '1') {
             $gar_PirmsRed = floor($m['LBruto'] / 10) / 10;
         } elseif ($this->MyPOST['noapalot_garumu'] == '2') {
             $gar_PirmsRed = (floor($m['LBruto'] / 10) + 0.5) / 10;
         }
         //---Tiek pārbaudīts, vai garums tiek ņemts kā nominālais garums, vai notiek nominālā garuma aprēķināšana, no kura tiks rēķināts Neto tilpums!-------------------------------------------------------------------------
         $gar_PecRed = gAtskaite::nom($gar_PirmsRed, $virsmeri, $min_virsmers);
         if ($this->MyPOST['is_vika'] == 'on') {
             $gar_PecRed = $m['LPecReduc'] / 100;
         }
         //---Tiek aprēķināts nominālais garums pirms pirms redukcijas, lai varētu aprēķināt tilpumu bez virsmēra!-------------------------------------------------------------------------
         $gar_NomPirsmRed = gAtskaite::nom($gar_PirmsRed, $virsmeri, $min_virsmers);
         //----------------------------------------------------------------------------
         $diam_TievPirmsRed = $m['DBruto'] / 1000;
         $diam_VidusPirmsRed = $m['DBruto'] / 1000;
         $diam_ResPirmsRed = $m['DBruto'] / 1000;
         $rauk_koef = get_raukums_no_diam($raukums, $diam_TievPirmsRed * 1000);
         if ($this->MyPOST['noapalot_diametru'] == 'on') {
             $diam_TievPirmsRed = (floor($m['DBruto'] / 10) + 0.5) / 100;
             $diam_VidusPirmsRed = (floor($m['DBruto'] / 10) + 0.5) / 100;
             $diam_ResPirmsRed = (floor($m['DBruto'] / 10) + 0.5) / 100;
         }
         //----------------------------------------------------------------------------
         if ($this->MyPOST['braka_virsmers'] == 'on') {
         } else {
         }
         $DPecReduc = $m['DPecReduc'] / 1000;
         $DReduc = $DBruto - $DPecReduc;
         if ($m[brakis] != '255') {
             $irbrakis = true;
             $brkods = 'standart';
         }
         $tilpums_bruto = f2($diam_TievPirmsRed, $gar_PirmsRed, $rauk_koef, $koeficients, $gostu_tabula);
         $tilpums_neto = f2($DPecReduc, $gar_PecRed, $rauk_koef, $koeficients, $gostu_tabula);
         $tilpums_bruto_bez_virsmera = f2($diam_TievPirmsRed, $gar_NomPirsmRed, $rauk_koef, $koeficients, $gostu_tabula);
         $tilpums_virsmers = $tilpums_bruto - $tilpums_bruto_bez_virsmera;
         $tilpums_garuma_redukcija = $tilpums_bruto_bez_virsmera - $tilpums_neto;
         $tilpums_diametrs_redukcija = 0;
         //----------
         $SVBruto += $tilpums_bruto;
         if ($gostu_tabula) {
             if ($VBruto == -1 || $VReducD == -1 || $VReducL == -1 || $VVirsm == -1) {
                 $SSkaitsBad++;
             }
             if ($VBruto == -1) {
                 $VBruto = 0;
             }
             if ($VReducD == -1) {
                 $VReducD = 0;
             }
             if ($VReducL == -1) {
                 $VReducL = 0;
             }
             if ($VVirsm == -1) {
                 $VVirsm = 0;
             }
         }
         $VBrakis = 0;
         if (strlen($this->rejected_values[$key]) == 1) {
             $irbrakis = true;
             $brkods = $this->rejected_values[$key];
         }
         if (!$irbrakis) {
             /*Vai ir brakis?*/
             $SVReducD += $tilpums_diametrs_redukcija;
             $SVReducL += $tilpums_garuma_redukcija;
             if ($gar_PecRed != 0) {
                 $SVVirsm += $tilpums_virsmers;
                 $SVNeto += $tilpums_neto;
             } else {
                 $SVBrakis += $SVBruto;
             }
         } else {
             if ($gar_PecRed != 0) {
                 $SVVirsm += $tilpums_virsmers;
                 $VBrakis = $tilpums_bruto - $tilpums_virsmers;
                 $SVBrakis += $VBrakis;
             } else {
                 $VBrakis = $tilpums_bruto;
                 $SVBrakis += $VBrakis;
             }
         }
     }
     /*Ievietosana*/
     //$this->arr[$this->arr_index][$level-1] = $this->kodi($this->MyPOST['gtype'.$this->grup.$this->lsk],$val);
     /* Vienu reizi pašās beigās papildina ar pēdējo ierakstu */
     $this->arr_index++;
     $this->arr[$this->arr_index] = array();
     foreach ($criteria as $key => $value) {
         //fb($m['value']);
         $this->arr[$this->arr_index][$key] = $this->kodi($value, $last[$value]);
     }
     $sm = new CSumma();
     $sm->skaits = $SSkaits;
     $sm->skaits_bad = $SSkaitsBad;
     $sm->virsmers = $SVVirsm;
     $sm->redukcija_d = $SVReducD;
     $sm->redukcija_l = $SVReducL;
     $sm->brakis = $SVBrakis;
     $sm->neto = $SVNeto;
     $sm->bruto = $SVBruto;
     $this->arr[$this->arr_index][summa] = $sm;
     for ($ci = $this->lsk - 2; $ci >= 0; $ci--) {
         if (!$summa[$ci + 1]) {
             $summa[$ci + 1] = new CSumma();
         }
         $summa[$ci + 1]->add_skaits($SSkaits);
         $summa[$ci + 1]->add_skaits_bad($SSkaitsBad);
         $summa[$ci + 1]->add_virsmers($SVVirsm);
         $summa[$ci + 1]->add_redukcija_d($SVReducD);
         $summa[$ci + 1]->add_redukcija_l($SVReducL);
         $summa[$ci + 1]->add_brakis($SVBrakis);
         $summa[$ci + 1]->add_neto($SVNeto);
         $summa[$ci + 1]->add_bruto($SVBruto);
         if (!$this->XML_Variants) {
             $this->AddSumRowAtLevel($ci, $criteria, $summa, $last);
         }
     }
     $summa_p->add_skaits($SSkaits);
     $summa_p->add_skaits_bad($SSkaitsBad);
     $summa_p->add_virsmers($SVVirsm);
     $summa_p->add_redukcija_d($SVReducD);
     $summa_p->add_redukcija_l($SVReducL);
     $summa_p->add_brakis($SVBrakis);
     $summa_p->add_neto($SVNeto);
     $summa_p->add_bruto($SVBruto);
 }