function print_all_reports($atskaites_kods, $tmp_returnResult)
{
global $lang;
global $translate;
global $arrsum;
global $C_REP;
global $pavadzimes_tabula;
global $output_pdf;
global $subMakeAll;
global $output_xml;
global $prefix_subname;
global $output_xml_dir;
$arrfinal = array();
$output = "";
$tmp_translation['pavadzime'] = "<b>Pavadzīme</b>";
$tmp_translation['fsc'] = "Sertifikācija";
$tmp_translation['transp_darba_uzd'] = "Transp. darba uzd.";
$tmp_translation['pircejs_regnum'] = "Pircējs Reg. Num.";
$tmp_translation['pardevejs_regnum'] = "Pārdevējs Reg. Num.";
$tmp_translation['transport_firm'] = "Transp. firma";
$tmp_translation['kad_piegad'] = "<b>Pavadzīmes datums</b>";
$tmp_translation['kad_uzmer'] = "Uzm. datums";
$tmp_translation['auto_head'] = "Automašīnas nr.";
$tmp_translation['soferis_head'] = "Šoferis";
$tmp_translation['iecirknis_head'] = "Iecirknis";
$tmp_translation['pircejs_head'] = "Pircējs";
$tmp_translation['pardevejs_head'] = "Pārdevējs";
$tmp_translation['standarts_head'] = "Standarts";
$tmp_translation['metode_head'] = "Metode";
$tmp_translation['cirsma_head'] = "Cirsma";
$tmp_translation['iecirknis_head'] = "Iecirknis";
$tmp_translation['vieta_head'] = "Uzmērīšanas vieta";
$tmp_translation['custom12_head'] = $_POST['custom11_head'];
$tmp_translation['piezimes_head'] = "Piezīmes";
$tmp_translation['sortiments_head'] = "Sortiments";
$tmp_translation['raukums_head'] = "Raukums";
$tmp_translation['merinstruments_head'] = "Mērinstruments";
$tmp_translation['terminsh_head'] = "Pārbaudes termiņš";
$lang = 'LAT';
if (trim($_POST['pavadzime']) != '') {
$_POST['pavadzime_head'] = $_POST['pavadzime'];
}
set_param('akts_nr', $_POST['akts_nr_head']);
set_param('fsc', $_POST['fsc']);
set_param('pircejs_head', $_POST['pircejs_head']);
set_param('pircejs_regnum', $_POST['pircejs_regnum']);
set_param('pardevejs_head', $_POST['pardevejs_head']);
set_param('pardevejs_regnum', $_POST['pardevejs_regnum']);
set_param('pieg_lig_num', $_POST['pieg_lig_num']);
set_param('datums', $_POST['datums_head']);
set_param('iecirknis', $_POST['iecirknis_head']);
set_param('cirsmas_kods', $_POST['cirsmas_kods_head']);
set_param('pavadzime_head', $_POST['pavadzime_head']);
set_param('transport_firm', $_POST['transport_firm']);
set_param('auto', $_POST['auto_head']);
set_param('soferis', $_POST['soferis_head']);
set_param('vieta', $_POST['vieta_head']);
set_param('piezimes', $_POST['piezimes_head']);
set_param('atbildigais', $_POST['atbildigais_head']);
set_param('parbaudija', $_POST['parbaudija_head']);
set_param('veidoja', $_POST['veidoja_head']);
set_param('custom11', $_POST['custom11_head']);
set_param('custom12', $_POST['custom12_head']);
set_param('sortiments', $_POST['sortiments_head']);
set_param('standarts', $_POST['standarts_head']);
set_param('metode', $_POST['metode_head']);
set_param('raukums', $_POST['raukums_head']);
set_param('merinstruments', $_POST['merinstruments_head']);
set_param('terminsh', $_POST['terminsh_head']);
if ($output_pdf) {
require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/g-atskaite.php';
$g_atskaite = new g_atskaite();
$g_atskaite->open_pdf();
$g_atskaite->report_header_pdf($_POST, $lang, $translate);
} else {
$newOutput = $newOutput . "\t\t\t\t\t\t <title>Atskaite " . $lang . "</title>";
$newOutput = $newOutput . "\t\t\t\t\t\t <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">";
$newOutput = $newOutput . "\t\t\t\t\t\t</head>";
$newOutput = $newOutput . "\t\t\t\t\t\t<center>";
$newOutput = $newOutput . "\t<STYLE TYPE=\"text/css\">";
$newOutput = $newOutput . "\t TD { font-size: 12px; }";
$newOutput = $newOutput . "\t</STYLE>";
$newOutput = $newOutput . "\t<table border=0 width=90%><td align=center valign='top'>";
$newOutput = $newOutput . "\t<table border=0 width=100%><tr>";
if (($atskaites_kods == 16 || $subMakeAll) && !$output_pdf) {
$newOutput = $newOutput . "\t<td width=540><img src=\"images/vmf.gif\"></td><td align=center>VMF MI P 02.01.02.\n<br />3. variants (22.02.2011.)</td></tr></table><table><tr><td align=center width=50></td>";
} else {
$newOutput = $newOutput . "\t<td width=540><img src=\"images/vmf.gif\"></td><td align=center>VMF MI P 02.01.04.\n<br />1. variants (12.11.2010.)</td></tr></table><table><tr><td align=center width=50></td>";
}
$newOutput = $newOutput . "\t <td align=center valign=center><font size=5>Testēšanas pārskats nr." . get_param('akts_nr') . "</font></td>";
$newOutput = $newOutput . "\t</tr></table><br><table cellspacing=0 cellpadding=0 style=\"width:850;\">";
foreach ($_POST['head'] as $key => $tmp_item_head) {
$newOutput = $newOutput . "<tr><td align=right><font size=3>" . $tmp_translation[$key] . ": </font></td><td><font size=3>" . $tmp_item_head . "</font></td>";
}
$newOutput = $newOutput . "</table><br>";
}
//Insert Global new
$genGlobal_registrs_id = 0;
if (!$output_xml && !$output_pdf) {
if ($_POST['reg_atsk'] == 'on') {
$pavadzime_tmpIns = $_POST['pavadzime'];
$mysqlGlobal_registrs_insert_txt = "INSERT INTO `g_registrs` (`datums_registrets`,`pavadzime`,`opcija`) values ('" . date("Y-m-d H:i:s") . "','{$pavadzime_tmpIns}','U')";
$mysqlGlobal_registrs_insert = mysql_query($mysqlGlobal_registrs_insert_txt);
$genGlobal_registrs_id = mysql_insert_id();
}
}
$DB_CON = new C_DB('localhost', DATABASE, LOGIN, PWD);
$C_REP = new C_REPORT($_POST, $DB_CON, $output_xml, $prefix_subname, $atskaites_kods, $output_pdf, $subMakeAll, $genGlobal_registrs_id, $pavadzime_tmpIns);
$newOutput .= "<table style=\"border-width:1px;border-style:solid;width:750;\">";
foreach ($C_REP->arrPrintOut as $tmp_item_1) {
if ($tmp_item_1['nosaukums'] == 1) {
$newOutput .= "<tr bgcolor=\"#e1e1e1\" style=\"font-weight:bold;\">";
} else {
$newOutput .= "<tr>";
}
foreach ($tmp_item_1 as $key => $tmp_item_2) {
if (($atskaites_kods == 16 || $atskaites_kods == 666 || $subMakeAll || trim($_POST['pavadzime_head']) == '') && !$output_pdf) {
if ($key != "nosaukums" && $key != "brakis_un_neto" && $key != "redukcija_un_virsmers") {
// if($key != "nosaukums"){
$newOutput .= "<td align=center ><font size=3>";
$newOutput .= $tmp_item_2;
$newOutput .= "</font></td>";
}
} else {
if ($key != "nosaukums" && $key != "garums" && $key != "virsmers" && $key != "redukcija" && $key != "redukcija_un_virsmers") {
// if($key != "nosaukums"){
$newOutput .= "<td align=center ><font size=3>";
$newOutput .= $tmp_item_2;
$newOutput .= "</font></td>";
}
}
}
$newOutput .= "</tr>";
}
$newOutput .= "</table><br /><br /><br /><br />";
if ($_POST['piezimes_head']) {
$newOutput = $newOutput . '<tr><td align=left>' . $tmp_translation['piezimes_head'] . ': ' . $_POST['piezimes_head'] . '<br /><br /><br /><br /><br /></td></tr>';
}
if ($_POST['parbaudija_head'] == 0) {
if ($_POST['parbaudija_un_atbildigais_head'] == 6) {
$newOutput = $newOutput . "<tr><td align=left>" . $translate['atb_persona'][$lang] . " ..................................................." . $_POST['atbildigais_head'] . "\n <br><br><br>Sagatavoja " . get_person($_POST['veidoja_head']) . "</td></tr>";
$newOutput = $newOutput . "<tr><td align=right><br><font size=1>" . $translate['veikts'][$lang] . " SIA VMF LATVIA <br>Reģ.nr.: 40003405130<br>Skaistkalnes iela 1, Rīga, LV-1004 <br>" . $translate['talrunis'][$lang] . " +371 29470949 " . $translate['fakss'][$lang] . " + 371 67223718 " . $translate['epasts'][$lang] . " vmflatvia@vmf.lv</td></tr>";
$newOutput = $newOutput . "</table>";
} else {
$newOutput = $newOutput . "<tr><td align=left>Pārbaudīja/ atbildīgā persona ..................................................." . get_person($_POST['parbaudija_un_atbildigais_head']) . "\n <br><br><br>Sagatavoja " . get_person($_POST['veidoja_head']) . "</td></tr>";
$newOutput = $newOutput . "<tr><td align=right><br><font size=1>" . $translate['veikts'][$lang] . " SIA VMF LATVIA <br>Reģ.nr.: 40003405130<br>Skaistkalnes iela 1, Rīga, LV-1004 <br>" . $translate['talrunis'][$lang] . " +371 29470949 " . $translate['fakss'][$lang] . " + 371 67223718 " . $translate['epasts'][$lang] . " vmflatvia@vmf.lv</td></tr>";
$newOutput = $newOutput . "</table>";
}
} else {
$newOutput = $newOutput . "<tr><td align=left>" . $translate['atb_persona'][$lang] . " ..................................................." . $_POST['atbildigais_head'] . "\n <br><br><br>Pārbaudīja .............................................................." . get_person($_POST['parbaudija_head']) . "\n <br><br><br>Sagatavoja " . get_person($_POST['veidoja_head']) . "</td></tr>";
$newOutput = $newOutput . "<tr><td align=right><br><font size=1>" . $translate['veikts'][$lang] . " SIA VMF LATVIA <br>Reģ.nr.: 40003405130<br>Skaistkalnes iela 1, Rīga, LV-1004 <br>" . $translate['talrunis'][$lang] . " +371 29470949 " . $translate['fakss'][$lang] . " + 371 67223718 " . $translate['epasts'][$lang] . " vmflatvia@vmf.lv</td></tr>";
$newOutput = $newOutput . "</table>";
}
if (!$output_xml && !$output_pdf) {
if ($_POST['reg_atsk'] == 'on') {
$skaits = $C_REP->regSuperSum[skaits];
$skaits_brakis = $C_REP->regSuperSum[skaits_brakis];
$bruto = $C_REP->regSuperSum[bruto];
$virsmers = $C_REP->regSuperSum[virsmers];
$redukcija_kopa = $C_REP->regSuperSum[redukcija];
$brakis = $C_REP->regSuperSum[brakis];
$neto = $C_REP->regSuperSum[neto];
$pavadzime = $_POST['pavadzime'];
if (trim($_POST['pavadzime']) == '') {
$pavadzime = $_POST['pavadzime_head'];
}
$akta_nr = $_POST['akts_nr_head'];
$pircejs = $_POST['head']['pircejs_head'];
$dataKey = explode("/", $_POST['akts_nr_head']);
$atskaites_veids = get_AtskaitesVeids($dataKey[1]);
$pardevejs = $_POST['head']['pardevejs_head'];
$liguma_nr = $h;
$datums = $_POST['head']['kad_uzmer'];
$datums_piegade = $_POST['head']['kad_piegad'];
$temp_datums = $datums;
$temp_datums_arr = explode('.', $temp_datums);
$datums = $temp_datums_arr[2] . '-' . $temp_datums_arr[1] . '-' . $temp_datums_arr[0];
$temp_datums_piegad_arr = explode('.', $datums_piegade);
$datums_piegade = $temp_datums_piegad_arr[2] . '-' . $temp_datums_piegad_arr[1] . '-' . $temp_datums_piegad_arr[0];
if ($_POST['datums_head']) {
$datums = $_POST['datums_head'];
$datums = substr($datums, -5, 4) . "-" . substr($datums, -8, 2) . "-" . substr($datums, 0, 2);
}
$iecirknis = $_POST['iecirknis_head'];
$piegade = $_POST['kods'];
$cirsmas_kods = $_POST['cirsmas_kods_head'];
$auto = $_POST['head']['auto_head'];
$soferis = $_POST['head']['soferis_head'];
$vieta = AI_returnPlace($_POST['vieta_head']);
$veidoja = $_POST['veidoja_head'];
$sortiments = $_POST['head']['sortiments_head'];
$metode = $_POST['head']['metode_head'];
$regSQL_update = "UPDATE `g_registrs` SET `pircejs` = '{$pircejs}', `pardevejs` = '{$pardevejs}', `atskaites_veids` = '{$atskaites_veids}', `piegadatajs` = '{$piegade}', `akta_nr` = '{$akta_nr}', `datums_piegade` = '{$datums_piegade}', `iecirknis` = '{$iecirknis}', `datums_uzmer` = '{$datums}', `vieta` = '{$vieta}', `soferis` = '{$soferis}', `auto_nr` = '{$auto}', `sortiments` = '{$sortiments}', `skaits_kopa` = '{$skaits}', `bruto` = '{$bruto}', `neto` = '{$neto}', `virsmers` = '{$virsmers}', `redukcija` = '{$redukcija_kopa}', `skaits_brakis` = '{$skaits_brakis}', `brakis` = '{$brakis}', `lietotajs_veidoja` = '{$veidoja}', `atskaites_nr` = '{$liguma_nr}', `opcija` = 'A' WHERE `id` = {$genGlobal_registrs_id}";
// $regSQL = "INSERT INTO g_registrs (pircejs,pardevejs,atskaites_veids,piegadatajs,akta_nr,pavadzime,datums_piegade,vieta,soferis,auto_nr,sortiments,skaits_kopa,bruto,neto,virsmers,redukcija,skaits_brakis,brakis,lietotajs_veidoja,atskaites_nr,opcija) VALUES ('$pircejs','$pardevejs','$atskaites_veids','$piegade','$akta_nr','$pavadzime','$datums','$vieta','$soferis','$auto','$sortiments',$skaits,$bruto,$neto,$virsmers,$redukcija_kopa,$skaits_brakis,$brakis,'$veidoja','$liguma_nr','A')";
// echo $regSQL;
mysql_query($regSQL_update);
}
}
if (!$_POST['negrupet']) {
usort($arrfinal, 'CompareArrays');
}
$arrfinal[-1] = $C_REP->arr[-1];
$C_REP->arr = $arrfinal;
if (!$output_pdf) {
if ($output_xml) {
$atskaite_veids = $_GET['veids'];
$xml_arr = $C_REP->GetXML_new($atskaites_kods);
$xml = $xml_arr['file_content'];
} else {
// $output = $output . $C_REP->GetHTML();
}
} else {
// $C_REP->GetHTML($g_atskaite);
}
if (!empty($_POST['pavadzime'])) {
$pavXMLNum = trim($_POST['pavadzime']);
} else {
$pavXMLNum = trim($_POST['pavadzime_head']);
}
if ($output_xml) {
$xml = iconv("UTF-8", "cp1257", $xml);
// if(!file_exists("../batch/xml/".$output_xml_dir) || !is_dir("../batch/xml/".$output_xml_dir)){
// mkdir("../batch/xml/".$output_xml_dir, 0777);
// chmod("../batch/xml/".$output_xml_dir, 0777);
// }
// $returnResult = "../batch/xml/".$output_xml_dir;
$new_xml_data_file = $tmp_returnResult . "/" . $pavXMLNum . ".xml";
if (file_exists($new_xml_data_file)) {
$output = $output . '</table><BR><BR></td></tr>';
file_put_contents("../batch/xml/" . $output_xml_dir . "/" . $pavXMLNum . "_1.xml", $xml);
$output .= "<font color=red>Šāda pavadzīme jau ir veidota! ../batch/xml/" . $output_xml_dir . "/" . $pavXMLNum . ".xml </font><BR>";
$output = $output . "</table></table>";
} else {
// $output = $output . '</table><BR><BR></td></tr>';
$output = $output . "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">";
$arr_Compare = AI_getcompare($pavXMLNum, 'test');
file_put_contents($new_xml_data_file, $xml);
$output .= "<table width='580' style='border-width:1px;border-style:solid;' width=100%>";
$output .= "<thead><td align=center bgcolor=#7EB000><b>*.<i>XML</i> datu faila pārbaude</b><br></td></tr></thead>";
$output .= "<tbody>";
if ($arr_Compare['skaits_kopa'] != $xml_arr['skaits']) {
$starpibaSkaitsBalki = $arr_Compare['skaits_kopa'] - $xml_arr['skaits'];
$output .= "<tr><td collspan='2'><font color=red>Failā esošo baļķu skaits nesakrīt ar reģistrā esošo baļķu skaitu par " . $starpibaSkaitsBalki . "!</font></td></tr>";
}
if ($arr_Compare['akta_nr'] != $xml_arr['akta_nr']) {
$starpibaAktaNr = $xml_arr['akta_nr'];
$output .= "<tr><td collspan='2'><font color=red>Failā esošais akta numurs(" . $starpibaAktaNr . ") nesakrīt ar reģistrā esošo akta numuru!</font></td></tr>";
}
if (round($arr_Compare['neto'], 3) != round($xml_arr['neto_kopa'], 3)) {
$starpibaNetoBalki = $arr_Compare['neto'] - $xml_arr['neto_kopa'];
$output .= "<tr><td collspan='2'><font color=red>Failā esošo baļķu neto nesakrīt ar reģistrā esošo baļķu neto par " . $starpibaNetoBalki . "!</font></td></tr>";
}
if (round($arr_Compare['brakis'], 3) != round($xml_arr['brakis_kopa'], 3)) {
$starpibaBrakisBalki = $arr_Compare['brakis'] - $xml_arr['brakis_kopa'];
$output .= "<tr><td collspan='2'><font color=red>Failā esošo baļķu brāķis nesakrīt ar reģistrā esošo baļķu brāķi par " . $starpibaBrakisBalki . "!</font></td></tr>";
}
if (round($arr_Compare['redukcija'], 3) != round($xml_arr['redukcija_kopa'], 3)) {
$starpibaRedukcijaBalki = $arr_Compare['redukcija'] - $xml_arr['redukcija_kopa'];
$output .= "<tr><td collspan='2'><font color=red>Failā esošo baļķu redukcija nesakrīt ar reģistrā esošo baļķu redukciju par " . $starpibaRedukcijaBalki . "!</font></td></tr>";
}
if (round($arr_Compare['virsmers'], 3) != round($xml_arr['virsmers_kopa'], 3)) {
$starpibaVirsmersBalki = $arr_Compare['virsmers'] - $xml_arr['virsmers_kopa'];
$output .= "<tr><td collspan='2'><font color=red>Failā esošo baļķu virsmērs nesakrīt ar reģistrā esošo baļķu virsmēru par " . $starpibaVirsmersBalki . "!</font></td></tr>";
}
if (round($arr_Compare['bruto'], 3) != round($xml_arr['bruto_kopa'], 3)) {
$starpibaBrutoBalki = $arr_Compare['bruto'] - $xml_arr['bruto_kopa'];
$output .= "<tr><td collspan='2'><font color=red>Failā esošo baļķu bruto nesakrīt ar reģistrā esošo baļķu bruto par " . $starpibaBrutoBalki . "!</font></td></tr>";
}
$output .= "<tr><td collspan=2>Izveidots fails <a href='../batch/xml/" . $output_xml_dir . "/" . $pavXMLNum . ".xml' target='_blank'>{$pavXMLNum}</a></td></tr>";
$output .= "<tr><td>Akta numurs failā " . $xml_arr['akta_nr'] . "</td></tr>";
$output .= "<tr><td>Baļķu skaits failā " . $xml_arr['skaits'] . "</td></tr>";
$output .= "<tr><td>Bruto tilpums failā " . $xml_arr['bruto_kopa'] . " m3</td></tr>";
$output .= "<tr><td>Brāķa tilpums failā " . $xml_arr['brakis_kopa'] . " m3</td></tr>";
$output .= "<tr><td>Neto tilpums failā " . $xml_arr['neto_kopa'] . "m3</td></tr>";
// $output .= "<tr><td>Virsmēra tilpums failā </td><td>".$xml_arr['virsmers_kopa']." m3</td></tr>";
// $output .= "<tr><td>Redukcijas tilpums failā </td><td>".$xml_arr['redukcija_kopa']." m3</td></tr>";
$output = $output . "</tbody></table>";
}
echo $output;
} elseif ($output_pdf) {
$show_reject_codes = false;
$g_atskaite->report_pdf($C_REP->arrPrintOut);
$g_atskaite->report_footer_pdf($_POST, $lang, $translate, $show_reject_codes);
$new_xml_data_file = $tmp_returnResult . "/" . $pavXMLNum . ".pdf";
$location = $g_atskaite->pdf_save($new_xml_data_file, $pavXMLNum);
// echo '<iframe width="50%" style="height: 85em;" src="'.$location.'"></iframe>';
// echo "<a href='$location'>Atskaite PDF formātā</a><br /><br />";
} else {
echo $newOutput;
}
return true;
}
