function prenom_nom($texte)
{
if (strstr(preg_replace("(@-|@-|@ |@)", "", $texte), "*")) {
if (prenom($texte) && nom($texte)) {
return prenom($texte) . " " . nom($texte);
} else {
return prenom($texte) . nom($texte);
}
} else {
return $texte;
}
}
function prenom_nom($texte)
{
if (strstr($texte, "*")) {
$prenom = prenom($texte);
$nom = nom($texte);
if ($prenom && $nom) {
return $prenom . ' ' . $nom;
} else {
$prenom . $nom;
}
} else {
return $texte;
}
}
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];
}
}
}
}
}
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];
}
}
}
}
}
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') {
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 == 'latvijas_finieris_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();
$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 latvijas_finieris_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 latvijas_finieris_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] . ")";
}
//$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];
}
}
// echo $myquery.'<br />';
$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;
}
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];
}
$this->print_level($level + 1, $myquery, $sum, $irbrakis, $suga, $id . $myid);
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] = "";
}
}
$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_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);
$this->lasttype = 'sum';
} else {
$this->lasttype = 'data';
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////Saakums////////////////////////////////////////////////////////////////////////////////////
$query__ = "select 1_cilindra_tilpums as 1_cil_tilp,\n 2_cilindra_tilpums as 2_cil_tilp,\n 3_cilindra_tilpums as 3_cil_tilp,\n 4_cilindra_tilpums as 4_cil_tilp,\n virsmera_tilpums as virsm_tilp,\n garums as pilnais_garums,\n 1_cilindra_garums as 1_cil_gar,\n 2_cilindra_garums as 2_cil_gar,\n 3_cilindra_garums as 3_cil_gar,\n 4_cilindra_garums as 4_cil_gar,\n brakis as 1_cil_brakis,\n brakis2 as 2_cil_brakis,\n brakis3 as 3_cil_brakis,\n brakis4 as 4_cil_brakis,\n mind_pirms_red as 1_cil_diam,\n mind_pec_red as 2_cil_diam,\n mind_miza as 3_cil_diam,\n maxd_miza as 4_cil_diam,\n latvijas_finieris_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++;
$tilpums_neto_temp = 0;
if ($this->MyPOST['is_vika'] == 'on') {
$isVikaWood = 1;
} else {
$isVikaWood = 0;
}
$LnomNeto = nom($m['pilnais_garums']);
$tilpums_all = ($m['1_cil_tilp'] + $m['2_cil_tilp'] + $m['3_cil_tilp'] + $m['4_cil_tilp']) / 1000;
$tilpums_neto = 0;
$tilpums_virsmers = $m['virsm_tilp'] / 1000;
$tilpums_bruto = $tilpums_all + $tilpums_virsmers;
$SVBruto += $tilpums_bruto;
$VBrakis = 0;
if ($LnomNeto != 0) {
$SVVirsm += $tilpums_virsmers;
$SVNeto += $tilpums_neto;
///////////////////////////
if ($m['1_cil_brakis'] != '255' && $m['1_cil_brakis'] != '256') {
$irbrakis = true;
$brkods = 'standart';
$VBrakis += $m['1_cil_tilp'] / 1000;
} else {
$tilpums_neto_temp += $m['1_cil_tilp'] / 1000;
}
if ($m['2_cil_brakis'] != '255' && $m['2_cil_brakis'] != '256' && $m['2_cil_tilp'] != 0) {
$irbrakis_2 = true;
$brkods = 'standart';
$VBrakis += $m['2_cil_tilp'] / 1000;
} else {
$tilpums_neto_temp += $m['2_cil_tilp'] / 1000;
}
if ($m['3_cil_brakis'] != '255' && $m['3_cil_brakis'] != '256' && $m['3_cil_tilp'] != 0) {
$irbrakis_3 = true;
$brkods = 'standart';
$VBrakis += $m['3_cil_tilp'] / 1000;
} else {
$tilpums_neto_temp += $m['3_cil_tilp'] / 1000;
}
if ($m['4_cil_brakis'] != '255' && $m['4_cil_brakis'] != '256' && $m['4_cil_tilp'] != 0) {
$irbrakis_4 = true;
$brkods = 'standart';
$VBrakis += $m['4_cil_tilp'] / 1000;
} else {
$tilpums_neto_temp += $m['4_cil_tilp'] / 1000;
}
////////////////////////
} else {
$VBrakis = ($m['1_cil_tilp'] + $m['2_cil_tilp'] + $m['3_cil_tilp'] + $m['4_cil_tilp']) / 1000;
}
$SVBrakis += $VBrakis;
$SVNeto += $tilpums_neto_temp;
if (strlen($abr[$key]) == 1) {
$irbrakis = true;
$brkods = $abr[$key];
}
//-------------------
/*
if (!$irbrakis) {
$tilpums_neto_temp = ($m['1_cil_tilp'] + $m['2_cil_tilp'] + $m['3_cil_tilp'] + $m['4_cil_tilp']) / 1000;
$LnomNeto = nom($m['pilnais_garums']);
if ($LnomNeto!=0)
{
$SVVirsm += $tilpums_virsmers;
$SVNeto += $tilpums_neto;
}
else
{
$tilpums_diametrs_redukcija = 0;
$tilpums_garuma_redukcija = 0;
if ($this->MyPOST['braka_virsmers'] == 'on') {
$SVVirsm += $tilpums_virsmers;
$VBrakis = $tilpums_neto;
}else{
$VBrakis = $tilpums_neto + $tilpums_virsmers;
}
$SVBrakis += $VBrakis;
}
$SVReducD += $tilpums_diametrs_redukcija;
$SVReducL += $tilpums_garuma_redukcija;
}else{
if ($this->MyPOST['braka_virsmers'] == 'on') {
$SVVirsm += $tilpums_virsmers;
$VBrakis = $tilpums_neto;
}else{
$VBrakis = $tilpums_neto + $tilpums_virsmers;
}
$SVBrakis += $VBrakis;
}
*/
//------------------------
}
$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;
}
$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/////////////////////////////////////////////
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];
}
}
}
}
}
<?php include "funcion.php"; $j = $_POST["j"]; nom($j);
<?php
function prenom_nom($texte) {
if(strstr(ereg_replace("(@-|@-|@ |@|#-|#_|# |#)","",$texte),"*")) {
if(prenom($texte) && nom($texte))
return prenom($texte)." ".majuscules(nom($texte));
else
return prenom($texte).nom($texte);
}
else
return $texte;
}
