function print_all_reports() { global $lang; global $translate; global $arrsum; global $C_REP; $arrfinal = array(); $output = ""; for ($grup = 1; $grup <= $_POST['grup']; $grup++) { //Valoda if (isset($_POST['valoda' . $grup])) { $lang = $_POST['valoda' . $grup]; } else { $lang = 'LAT'; } $_POST['pavadzime_head'] = $_POST['pavadzime']; set_param('akts_nr', $_POST['akts_nr_head']); 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('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']); $xml_vars['gvalues' . $grup . '1'] = $_POST['gvalues' . $grup . '1']; $xml_vars['gvalues' . $grup . '1_1'] = $_POST['gvalues' . $grup . '1_1']; $xml_vars['gvalues' . $grup . '1_2'] = $_POST['gvalues' . $grup . '1_2']; $xml_vars['gvalues' . $grup . '2'] = $_POST['gvalues' . $grup . '2']; $xml_vars['gvalues' . $grup . '2_1'] = $_POST['gvalues' . $grup . '2_1']; $xml_vars['gvalues' . $grup . '2_2'] = $_POST['gvalues' . $grup . '2_2']; $xml_vars['gvalues' . $grup . '3'] = $_POST['gvalues' . $grup . '3']; $xml_vars['gvalues' . $grup . '3_1'] = $_POST['gvalues' . $grup . '3_1']; $xml_vars['gvalues' . $grup . '3_2'] = $_POST['gvalues' . $grup . '3_2']; $xml_vars['gvalues' . $grup . '4'] = $_POST['gvalues' . $grup . '4']; $xml_vars['gvalues' . $grup . '4_1'] = $_POST['gvalues' . $grup . '4_1']; $xml_vars['gvalues' . $grup . '4_2'] = $_POST['gvalues' . $grup . '4_2']; $xml_vars['virsmeri' . $grup] = $_POST['virsmeri' . $grup]; $xml_vars['virsmeri' . $grup . '_1'] = $_POST['virsmeri' . $grup . '_1']; $xml_vars['virsmeri' . $grup . '_2'] = $_POST['virsmeri' . $grup . '_2']; $xml_vars['koeficients' . $grup] = $_POST['koeficients' . $grup]; $xml_vars['koeficients' . $grup . '_1'] = $_POST['koeficients' . $grup . '_1']; $xml_vars['koeficients' . $grup . '_2'] = $_POST['koeficients' . $grup . '_2']; $xml_vars['raukums' . $grup] = $_POST['raukums' . $grup]; $xml_vars['raukums' . $grup . '_1'] = $_POST['raukums' . $grup . '_1']; $xml_vars['raukums' . $grup . '_2'] = $_POST['raukums' . $grup . '_2']; $xml_vars['pavadzime'] = $_POST['pavadzime']; ///////////////////////////////////////////////////////////////////////// if ($C_REP->ERRORS) { //$output = $output . "<html>"; //$output = $output . "<head>"; $output = $output . "<title>Kļūda!</title>"; $output = $output . "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">"; $output = $output . "</head>"; $output = $output . "<center>"; $output = $output . "<STYLE TYPE=\"text/css\">"; $output = $output . " TD { font-size: 12px; }"; $output = $output . "</STYLE>"; $output = $output . "</style>"; $output = $output . "<body>"; $output = $output . "<p class='pagestart'></p><center><br><br>"; $output = $output . "<b><font color=red>Kļūda!</font></b>"; $output = $output . "<br><br>"; $output = $output . $C_REP->ERRORS; $output = $output . "</center>"; $output = $output . "<br><br>"; $output = $output . "<input type=button value=\"Atkārtot\" onclick=\"history.back(-1)\">"; //$output = $output . "</body>"; //$output = $output . "</html>"; return $output; } if ($grup == 1) { //$output = $output . " <html>"; //$output = $output . " <head>"; $output = $output . "\t\t\t\t\t\t <title>Atskaite " . $lang . "</title>"; $output = $output . "\t\t\t\t\t\t <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">"; $output = $output . "\t\t\t\t\t\t</head>"; $output = $output . "\t\t\t\t\t\t<center>"; $output = $output . "\t<STYLE TYPE=\"text/css\">"; $output = $output . "\t TD { font-size: 12px; }"; $output = $output . "\t</STYLE>"; $output = $output . "\t<table border=0 width=90%>"; $output = $output . "\t<tr>"; $output = $output . "\t<td><img src=\"images/vmf.gif\"></td>"; $output = $output . "\t</tr>"; $output = $output . "\t<tr><td align=center valign='top'>"; $output = $output . "\t<table>"; $output = $output . "\t<tr>"; $output = $output . "\t <td align=center width=50></td>"; $output = $output . "\t <td align=center valign=center><font size=5>" . $translate['virsraksts'][$lang] . get_param('akts_nr') . "</font></td>"; $output = $output . "\t</tr>"; $output = $output . "\t</table>"; $output = $output . "\t<br>"; $output = $output . "\t<table cellspacing=0 cellpadding=0>"; if ($_POST['contract_num']) { $output = $output . "<tr><td align=right>" . $translate['liguma_nr'][$lang] . ": </td><td>" . $_POST['contract_num'] . "</td>"; } if ($_POST['pircejs_head']) { $output = $output . "<tr><td align=right>" . $translate['pircejs'][$lang] . ": </td><td>" . $_POST['pircejs_head'] . "</td>"; } if ($_POST['pardevejs_head']) { $output = $output . "<tr><td align=right>" . $translate['pardevejs'][$lang] . ": </td><td>" . $_POST['pardevejs_head'] . "</td>"; } if ($_POST['datums_head']) { $output = $output . "<tr><td align=right>" . $translate['datums'][$lang] . ": </td><td>" . $_POST['datums_head'] . "</td>"; } if ($_POST['pavadzime_head']) { $output = $output . "<tr><td align=right>" . $translate['pavadzime'][$lang] . ": </td><td>" . $_POST['pavadzime_head'] . "</td>"; } if ($_POST['iecirknis_head']) { $output = $output . "<tr><td align=right>" . $translate['iecirknis'][$lang] . ": </td><td>" . $_POST['iecirknis_head'] . "</td>"; } if ($_POST['auto_head']) { $output = $output . "<tr><td align=right>" . $translate['auto_nr'][$lang] . ": </td><td>" . $_POST['auto_head'] . "</td>"; } if ($_POST['soferis_head']) { $output = $output . "<tr><td align=right>" . $translate['soferis'][$lang] . ": </td><td>" . $_POST['soferis_head'] . "</td>"; } if ($_POST['vieta_head']) { $output = $output . "<tr><td align=right>" . $translate['uzm_vieta'][$lang] . ": </td><td>" . $_POST['vieta_head'] . "</td>"; } if ($_POST['custom12']) { $output = $output . "<tr><td align=right>" . $custom11 . " </td><td>" . $_POST['custom12'] . "</td>"; } if ($_POST['sortiments_head']) { $output = $output . "<tr><td align=right>" . $translate['sortiments'][$lang] . ": </td><td>" . $_POST['sortiments_head'] . "</td>"; } if ($_POST['standarts_head']) { $output = $output . "<tr><td align=right>" . $translate['standarts'][$lang] . ": </td><td>" . $_POST['standarts_head'] . "</td>"; } if ($_POST['metode_head']) { $output = $output . "<tr><td align=right>" . $translate['metode'][$lang] . ": </td><td>" . $_POST['metode_head'] . "</td>"; } if ($_POST['raukums_head']) { $output = $output . "<tr><td align=right>" . $translate['raukums'][$lang] . ": </td><td>" . $_POST['raukums_head'] . "</td>"; } if ($_POST['merinstruments_head']) { $output = $output . "<tr><td align=right>" . $translate['merinst'][$lang] . ": </td><td>" . $_POST['merinstruments_head'] . "</td>"; } if ($_POST['terminsh_head']) { $output = $output . "<tr><td align=right>" . $translate['v_term'][$lang] . ": </td><td>" . $_POST['terminsh_head'] . "</td>"; } $output = $output . "</table>"; $output = $output . "<br><br><br>"; $output = $output . "<table><tr><td>"; $output = $output . "<table border=0 cellspacing=0 cellpadding=0>"; } $DB_CON = new C_DB('localhost', DATABASE, LOGIN, PWD); $C_REP = new C_REPORT($_POST, $DB_CON, false, $grup); if ($grup == 1) { //šī ir pirmā grupēšanas nosacījumu kopa, kopējam summas no $arr $arrsum = $C_REP->arr[count($C_REP->arr) - 1]; if ($_POST['grup'] != 1) { $C_REP->arr[count($C_REP->arr) - 1] = array(); } $arrfinal = $C_REP->arr; } else { //šī nav pirmā grupēšanas nosacījumu kopa, tāpēc pieskaitam doto apakšsummu kopīgajai summai $arrsum[summa]->skaits = $arrsum[summa]->skaits + $C_REP->arr[count($C_REP->arr) - 1][summa]->skaits; $arrsum[summa]->skaits_bad = $arrsum[summa]->skaits_bad + $C_REP->arr[count($C_REP->arr) - 1][summa]->skaits_bad; $arrsum[summa]->bruto = $arrsum[summa]->bruto + $C_REP->arr[count($C_REP->arr) - 1][summa]->bruto; $arrsum[summa]->virsmers = $arrsum[summa]->virsmers + $C_REP->arr[count($C_REP->arr) - 1][summa]->virsmers; $arrsum[summa]->redukcija_d = $arrsum[summa]->redukcija_d + $C_REP->arr[count($C_REP->arr) - 1][summa]->redukcija_d; $arrsum[summa]->redukcija_l = $arrsum[summa]->redukcija_l + $C_REP->arr[count($C_REP->arr) - 1][summa]->redukcija_l; $arrsum[summa]->brakis = $arrsum[summa]->brakis + $C_REP->arr[count($C_REP->arr) - 1][summa]->brakis; $arrsum[summa]->neto = $arrsum[summa]->neto + $C_REP->arr[count($C_REP->arr) - 1][summa]->neto; if ($grup != $_POST['grup']) { $C_REP->arr[count($C_REP->arr) - 1] = array(); //ja nav pēdējā nosacījumu kopa, iztīram kopsummas rindu } else { $C_REP->arr[count($C_REP->arr) - 1] = $arrsum; //ja ir pēdējā nosacījumu kopa, atgriežam kopsummu } //$C_REP->arr[-1] = array(); //virsrakstus nevajag $arrfinal = array_merge($arrfinal, $C_REP->arr); } /* if ($grup < $_POST['grup']) { echo "<p style='page-break-before:always;'>"; } */ } usort($arrfinal, 'CompareArrays'); $arrfinal[-1] = $C_REP->arr[-1]; $C_REP->arr = $arrfinal; $output = $output . $C_REP->GetHTML(); $output = $output . '</table><BR><BR></td></tr>'; if ($_POST['piezimes_head']) { $output = $output . '<tr><td align=left>' . $translate['piezimes'][$lang] . ': ' . $_POST['piezimes_head'] . '</td></tr>'; } $output = $output . "<tr><td height=20></td></tr>"; $output = $output . "<tr><td align=left>" . $translate['atb_persona'][$lang] . " ..................................................." . $_POST['atbildigais_head'] . "</td></tr>"; $output = $output . "<tr><td align=right><br><font size=1>" . $translate['veikts'][$lang] . " SIA VMF LATVIA <br>Reģ.nr.: 40003405130<br>Artilērijas iela 40, korpuss 12, Rīga, LV-1009 <br>" . $translate['talrunis'][$lang] . " +371 29470949 " . $translate['fakss'][$lang] . " + 371 67223718 " . $translate['epasts'][$lang] . " vmflatvia@vmf.lv</td></tr>"; $output = $output . "</table></table>"; echo $output; }
function print_all_reports() { global $atskaite_veids; global $lang; global $translate; global $arrsum; global $C_REP; global $pavadzimes_tabula; global $output_pdf; global $output_xml; global $output_xml_dir; $arrfinal = array(); $output = ""; for ($grup = 1; $grup <= $_POST['grup']; $grup++) { //Valoda if (isset($_POST['valoda' . $grup])) { $lang = $_POST['valoda' . $grup]; } else { $lang = 'LAT'; } // if($_POST['pavadzime']==''){$_POST['pavadzime_head'] = $mpav['pavadzime_head'];} if (trim($_POST['pavadzime']) != '') { $_POST['pavadzime_head'] = $_POST['pavadzime']; } set_param('akts_nr', $_POST['akts_nr_head']); 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']); $xml_vars['gvalues' . $grup . '1'] = $_POST['gvalues' . $grup . '1']; $xml_vars['gvalues' . $grup . '1_1'] = $_POST['gvalues' . $grup . '1_1']; $xml_vars['gvalues' . $grup . '1_2'] = $_POST['gvalues' . $grup . '1_2']; $xml_vars['gvalues' . $grup . '2'] = $_POST['gvalues' . $grup . '2']; $xml_vars['gvalues' . $grup . '2_1'] = $_POST['gvalues' . $grup . '2_1']; $xml_vars['gvalues' . $grup . '2_2'] = $_POST['gvalues' . $grup . '2_2']; $xml_vars['gvalues' . $grup . '3'] = $_POST['gvalues' . $grup . '3']; $xml_vars['gvalues' . $grup . '3_1'] = $_POST['gvalues' . $grup . '3_1']; $xml_vars['gvalues' . $grup . '3_2'] = $_POST['gvalues' . $grup . '3_2']; $xml_vars['gvalues' . $grup . '4'] = $_POST['gvalues' . $grup . '4']; $xml_vars['gvalues' . $grup . '4_1'] = $_POST['gvalues' . $grup . '4_1']; $xml_vars['gvalues' . $grup . '4_2'] = $_POST['gvalues' . $grup . '4_2']; $xml_vars['virsmeri' . $grup] = $_POST['virsmeri' . $grup]; $xml_vars['virsmeri' . $grup . '_1'] = $_POST['virsmeri' . $grup . '_1']; $xml_vars['virsmeri' . $grup . '_2'] = $_POST['virsmeri' . $grup . '_2']; $xml_vars['virsmeri_brakim' . $grup] = $_POST['virsmeri_brakim' . $grup]; $xml_vars['virsmeri_brakim' . $grup . '_1'] = $_POST['virsmeri_brakim' . $grup . '_1']; $xml_vars['virsmeri_brakim' . $grup . '_2'] = $_POST['virsmeri_brakim' . $grup . '_2']; $xml_vars['koeficients' . $grup] = $_POST['koeficients' . $grup]; $xml_vars['koeficients' . $grup . '_1'] = $_POST['koeficients' . $grup . '_1']; $xml_vars['koeficients' . $grup . '_2'] = $_POST['koeficients' . $grup . '_2']; $xml_vars['raukums' . $grup] = $_POST['raukums' . $grup]; $xml_vars['raukums' . $grup . '_1'] = $_POST['raukums' . $grup . '_1']; $xml_vars['raukums' . $grup . '_2'] = $_POST['raukums' . $grup . '_2']; $xml_vars['pavadzime'] = $_POST['pavadzime']; ///////////////////////////////////////////////////////////////////////// if ($grup == 1) { // $output = $output . " <html>"; // $output = $output . " <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 { $output = $output . "\t\t\t\t\t\t <title>Atskaite " . $lang . "</title>"; $output = $output . "\t\t\t\t\t\t <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">"; $output = $output . "\t\t\t\t\t\t</head>"; $output = $output . "\t\t\t\t\t\t<center>"; $output = $output . "\t<STYLE TYPE=\"text/css\">"; $output = $output . "\t TD { font-size: 12px; }"; $output = $output . "\t</STYLE>"; $output = $output . "\t<table border=0 width=90%><td align=center valign='top'>"; $output = $output . "\t<table border=0 width=100%><tr>"; $output = $output . "\t<td width=540><img src=\"images/vmf.gif\"></td>"; $output = $output . " <td align=center>VMF MI P 02.01.02.\n<br />2.variants (12.11.2010.)</td>"; $output = $output . "\t</tr></table></td>"; $output = $output . "\t<tr><td align=center valign='top'>"; $output = $output . "\t<table>"; $output = $output . "\t<tr>"; $output = $output . "\t <td align=center width=50></td>"; $output = $output . "\t <td align=center valign=center><font size=5>" . $translate['virsraksts'][$lang] . get_param('akts_nr') . "</font></td>"; $output = $output . "\t</tr>"; $output = $output . "\t</table>"; $output = $output . "\t<br>"; $output = $output . "\t<table cellspacing=0 cellpadding=0>"; if ($_POST['contract_num']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['liguma_nr'][$lang] . ": </font></td><td><font size=3>" . $_POST['contract_num'] . "</font></td>"; } if ($_POST['pircejs_head']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['pircejs'][$lang] . ": </font></td><td><font size=3>" . $_POST['pircejs_head'] . "</font></td>"; } if ($_POST['pardevejs_head']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['pardevejs'][$lang] . ": </font></td><td><font size=3>" . $_POST['pardevejs_head'] . "</font></td>"; } if ($_POST['datums_head']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['datums'][$lang] . ": </font></td><td><font size=3>" . $_POST['datums_head'] . "</font></td>"; } if ($_POST['pavadzime_head']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['pavadzime'][$lang] . ": </font></td><td><font size=3>" . $_POST['pavadzime_head'] . "</font></td>"; } if ($_POST['iecirknis_head']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['iecirknis'][$lang] . ": </font></td><td><font size=3>" . $_POST['iecirknis_head'] . "</font></td>"; } if ($_POST['auto_head'] && $atskaite_veids != "nelss") { $output = $output . "<tr><td align=right><font size=3>" . $translate['auto_nr'][$lang] . ": </font></td><td><font size=3>" . $_POST['auto_head'] . "</font></td>"; } if (strlen($_POST['soferis_head']) > 1) { $output = $output . "<tr><td align=right><font size=3>" . $translate['soferis'][$lang] . ": </font></td><td><font size=3>" . $_POST['soferis_head'] . "</font></td>"; } if ($_POST['vieta_head']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['uzm_vieta'][$lang] . ": </font></td><td><font size=3>" . $_POST['vieta_head'] . "</font></td>"; } if ($_POST['custom12_head']) { $output = $output . "<tr><td align=right><font size=3>" . $_POST['custom11_head'] . " </font></td><td><font size=3>" . $_POST['custom12_head'] . "</font></td>"; } if ($_POST['sortiments_head']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['sortiments'][$lang] . ": </font></td><td><font size=3>" . $_POST['sortiments_head'] . "</font></td>"; } if ($_POST['standarts_head']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['standarts'][$lang] . ": </font></td><td><font size=3>" . $_POST['standarts_head'] . "</font></td>"; } if ($_POST['metode_head']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['metode'][$lang] . ": </font></td><td><font size=3>" . $_POST['metode_head'] . "</font></td>"; } if ($_POST['raukums_head']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['raukums'][$lang] . ": </font></td><td><font size=3>" . $_POST['raukums_head'] . "</font></td>"; } if ($_POST['merinstruments_head']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['merinst'][$lang] . ": </font></td><td><font size=3>" . $_POST['merinstruments_head'] . "</font></td>"; } if ($_POST['terminsh_head']) { $output = $output . "<tr><td align=right><font size=3>" . $translate['v_term'][$lang] . ": </font></td><td><font size=3>" . $_POST['terminsh_head'] . "</font></td>"; } $output = $output . "</table>"; $output = $output . "<br><br><br>"; $output = $output . "<table><tr><td>"; $output = $output . "<table border=0 cellspacing=0 cellpadding=0>"; } } $DB_CON = new C_DB('localhost', DATABASE, LOGIN, PWD); $C_REP = new C_REPORT($_POST, $DB_CON, $output_xml, $grup); if ($C_REP->ERRORS) { // $output = $output . "<html>"; // $output = $output . "<head>"; $output = $output . "<title>Kļūda!</title>"; $output = $output . "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">"; $output = $output . "</head>"; $output = $output . "<center>"; $output = $output . "<STYLE TYPE=\"text/css\">"; $output = $output . " TD { font-size: 12px; }"; $output = $output . "</STYLE>"; $output = $output . "</style>"; $output = $output . "<body>"; $output = $output . "<p class='pagestart'></p><center><br><br>"; $output = $output . "<b><font color=red>Kļūda!</font></b>"; $output = $output . "<br><br>"; $output = $output . $C_REP->ERRORS; $output = $output . "</center>"; /* $output = $output . "<br><br>"; $output = $output . "<input type=button value=\"Atkārtot\" onclick=\"history.back(-1)\">"; $output = $output . "<br><br>";*/ // $output = $output . "</body>"; // $output = $output . "</html>"; echo $output; return $output; } if ($grup == 1) { //šī ir pirmā grupēšanas nosacījumu kopa, kopējam summas no $arr $arrsum = $C_REP->arr[count($C_REP->arr) - 1]; if ($_POST['grup'] != 1) { $C_REP->arr[count($C_REP->arr) - 1] = array(); } $arrfinal = $C_REP->arr; } else { //šī nav pirmā grupēšanas nosacījumu kopa, tāpēc pieskaitam doto apakšsummu kopīgajai summai $arrsum[summa]->skaits = $arrsum[summa]->skaits + $C_REP->arr[count($C_REP->arr) - 1][summa]->skaits; $arrsum[summa]->skaits_bad = $arrsum[summa]->skaits_bad + $C_REP->arr[count($C_REP->arr) - 1][summa]->skaits_bad; $arrsum[summa]->bruto = $arrsum[summa]->bruto + $C_REP->arr[count($C_REP->arr) - 1][summa]->bruto; $arrsum[summa]->virsmers = $arrsum[summa]->virsmers + $C_REP->arr[count($C_REP->arr) - 1][summa]->virsmers; $arrsum[summa]->redukcija_d = $arrsum[summa]->redukcija_d + $C_REP->arr[count($C_REP->arr) - 1][summa]->redukcija_d; $arrsum[summa]->redukcija_l = $arrsum[summa]->redukcija_l + $C_REP->arr[count($C_REP->arr) - 1][summa]->redukcija_l; $arrsum[summa]->brakis = $arrsum[summa]->brakis + $C_REP->arr[count($C_REP->arr) - 1][summa]->brakis; $arrsum[summa]->neto = $arrsum[summa]->neto + $C_REP->arr[count($C_REP->arr) - 1][summa]->neto; if ($grup != $_POST['grup']) { $C_REP->arr[count($C_REP->arr) - 1] = array(); //ja nav pēdējā nosacījumu kopa, iztīram kopsummas rindu } else { $C_REP->arr[count($C_REP->arr) - 1] = $arrsum; //ja ir pēdējā nosacījumu kopa, atgriežam kopsummu } $arrfinal = array_merge($arrfinal, $C_REP->arr); } } if ($_POST['reg_atsk'] == 'on') { $skaits = $arrsum[summa]->skaits; $skaits_brakis = $arrsum[summa]->skaits_bad; $bruto = $arrsum[summa]->bruto; $virsmers = $arrsum[summa]->virsmers; $redukcija_d = $arrsum[summa]->redukcija_d; $redukcija_l = $arrsum[summa]->redukcija_l; $redukcija_kopa = $redukcija_l + $redukcija_d; $brakis = $arrsum[summa]->brakis; $neto = $arrsum[summa]->neto; $pavadzime = $_POST['pavadzime']; if (trim($_POST['pavadzime']) == '') { $pavadzime = $_POST['pavadzime_head']; } $akta_nr = $_POST['akts_nr_head']; $pircejs = $_POST['pircejs_head']; $dataKey = explode("/", $_POST['akts_nr_head']); $atskaites_veids = get_AtskaitesVeids($dataKey[1]); // set_param('pircejs_regnum',$_POST['pircejs_regnum']); $pardevejs = $_POST['pardevejs_head']; // set_param('pardevejs_regnum',$_POST['pardevejs_regnum']); $liguma_nr = $h; $datums = $_POST['datums_head']; $datums = substr($datums, -5, 4) . "-" . substr($datums, -8, 2) . "-" . substr($datums, 0, 2); $iecirknis = $_POST['iecirknis_head']; $cirsmas_kods = $_POST['cirsmas_kods_head']; // set_param('pavadzime_head',$_POST['pavadzime_head']); // set_param('transport_firm',$_POST['transport_firm']); $auto = $_POST['auto_head']; $soferis = $_POST['soferis_head']; $vieta = AI_returnPlace($_POST['vieta_head']); // set_param('piezimes',$_POST['piezimes_head']); // set_param('atbildigais',$_POST['atbildigais_head']); // set_param('parbaudija',$_POST['parbaudija_head']); $veidoja = $_POST['veidoja_head']; $piegade = $_POST['kods']; // $atskaites_veids = $_GET["veids"]; // set_param('custom11',$_POST['custom11_head']); // set_param('custom12',$_POST['custom12_head']); $sortiments = $_POST['sortiments_head']; // set_param('standarts',$_POST['standarts_head']); $metode = $_POST['metode_head']; // set_param('raukums',$_POST['raukums_head']); // set_param('merinstruments',$_POST['merinstruments_head']); // set_param('terminsh',$_POST['terminsh_head']); $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')"; mysql_query($regSQL); } if (!$_POST['negrupet']) { usort($arrfinal, 'CompareArrays'); } $arrfinal[-1] = $C_REP->arr[-1]; $C_REP->arr = $arrfinal; if (!$output_pdf) { if ($output_xml) { $xml_arr = $C_REP->GetXML($pavadzimes_tabula); $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); } if (file_exists("../batch/xml/" . $output_xml_dir . "/" . $pavXMLNum . ".xml")) { $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>'; $arr_Compare = AI_getcompare($pavXMLNum, 'test'); if ($arr_Compare['skaits_kopa'] != $xml_arr['skaits']) { $starpibaSkaitsBalki = $arr_Compare['skaits_kopa'] - $xml_arr['skaits']; $output .= "<font color=red>Failā esošo baļķu skaits nesakrīt ar reģistrā esošo baļķu skaitu par " . $starpibaSkaitsBalki . "!</font><BR>"; } if ($arr_Compare['akta_nr'] != $xml_arr['akta_nr']) { $starpibaAktaNr = $xml_arr['akta_nr']; $output .= "<font color=red>Failā esošais akta numurs(" . $starpibaAktaNr . ") nesakrīt ar reģistrā esošo akta numuru!</font><BR>"; } if ($arr_Compare['bruto'] != $xml_arr['bruto_kopa']) { $starpibaBrutoBalki = $arr_Compare['bruto'] - $xml_arr['bruto_kopa']; $output .= "<font color=red>Failā esošo baļķu bruto nesakrīt ar reģistrā esošo baļķu bruto par " . $starpibaBrutoBalki . "!</font><BR>"; } file_put_contents("../batch/xml/" . $output_xml_dir . "/" . $pavXMLNum . ".xml", $xml); $output .= "Izveidots fails <br />../batch/xml/" . $output_xml_dir . "/" . $pavXMLNum . ".xml<BR>"; $output .= "Akta numurs failā " . $xml_arr['akta_nr'] . ".<BR>"; $output .= "Baļķu skaits failā " . $xml_arr['skaits'] . ".<BR>"; $output .= "Bruto tilpums failā " . $xml_arr['bruto_kopa'] . " m3.<BR>"; $output = $output . "</table></table>"; } echo $output; } elseif ($output_pdf) { $show_reject_codes = !($atskaite_veids == 'vika' || $atskaite_veids == 'gaujaskoks' || $atskaite_veids == 'smiltene' || $atskaite_veids == 'bsw' || $atskaite_veids == 'vudlande' || $atskaite_veids == 'pata_ab'); $g_atskaite->report_footer_pdf($_POST, $lang, $translate, $show_reject_codes); $location = $g_atskaite->pdf_save($atskaite_veids, $_POST['pavadzime']); echo "<a href='{$location}'>Atskaite PDF formātā</a><br /><br />"; } else { $output = $output . '</table><BR><BR></td></tr>'; if ($_POST['piezimes_head']) { $output = $output . '<tr><td align=left>' . $translate['piezimes'][$lang] . ': ' . $_POST['piezimes_head'] . '</td></tr>'; } /*Atskaite tiek pievienota papildus informācija par brāki, izņemot VIKAWOOD atskaiti*/ if ($atskaite_veids == 'vika' || $atskaite_veids == 'gaujaskoks' || $atskaite_veids == 'smiltene' || $atskaite_veids == 'bsw' || $atskaite_veids == '4plus' || $atskaite_veids == 'vudlande' || $atskaite_veids == 'pata_ab' || $atskaite_veids == 'nelss' || $atskaite_veids == 'piebalgas' || $atskaite_veids == 'latvijas_finieris' || $atskaite_veids == 'stora_enso' || $atskaite_veids == 'osukalni' || $atskaite_veids == 'incukalns') { $output = $output . "<tr><td height=20></td></tr>"; } else { $output = $output . "<tr><td height=1><br><font size=1><b>Brāķa kodu atšifrējums:</b><br/>0 - Par tievu <br/>1 - Par garu <br/>2 - Max resnākā vieta par lielu <br/>3 - Max tievgalis par lielu <br/>4 - Gadskārtas, Meža trupe, saspiesta koksne, gala plaisas <br/>5 - Sausānis, kaltuši, sānu plaisas <br/>6 - Zari <br>7 - Līkumainība <br/>8 - Cits <br/>9 - Par īsu <br/><br/></td></tr>"; } /************************************************************************************/ if ($_POST['parbaudija_head'] == 0) { if ($_POST['parbaudija_un_atbildigais_head'] == 6) { $output = $output . "<tr><td align=left>" . $translate['atb_persona'][$lang] . " ..................................................." . $_POST['atbildigais_head'] . "\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<br><br><br>Sagatavoja " . get_person($_POST['veidoja_head']) . "</td></tr>"; $output = $output . "<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>"; $output = $output . "</table></table>"; // $output = $output . "</body>"; // $output = $output . "</html>"; echo $output; } else { $output = $output . "<tr><td align=left>Pārbaudīja/ atbildīgā persona ..................................................." . get_person($_POST['parbaudija_un_atbildigais_head']) . "\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<br><br><br>Sagatavoja " . get_person($_POST['veidoja_head']) . "</td></tr>"; $output = $output . "<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>"; $output = $output . "</table></table>"; // $output = $output . "</body>"; // $output = $output . "</html>"; echo $output; } } else { $output = $output . "<tr><td align=left>" . $translate['atb_persona'][$lang] . " ..................................................." . $_POST['atbildigais_head'] . "\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t <br><br><br>Pārbaudīja .............................................................." . get_person($_POST['parbaudija_head']) . "\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t <br><br><br>Sagatavoja " . get_person($_POST['veidoja_head']) . "</td></tr>"; $output = $output . "<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>"; $output = $output . "</table></table>"; // $output = $output . "</body>"; // $output = $output . "</html>"; echo $output; } } }
function print_report() { $output = ''; $DB_CON = new C_DB('localhost', DATABASE, LOGIN, PWD); $C_REP = new C_REPORT($_POST, $DB_CON, false); ///////////////////////////////////////////////////////////////////////// $_POST['pavadzime_head'] = $_POST['pavadzime']; set_param('akts_nr', $_POST['akts_nr_head']); 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('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']); $xml_vars['gvalues1'] = $_POST['gvalues1']; $xml_vars['gvalues1_1'] = $_POST['gvalues1_1']; $xml_vars['gvalues1_2'] = $_POST['gvalues1_2']; $xml_vars['gvalues2'] = $_POST['gvalues2']; $xml_vars['gvalues2_1'] = $_POST['gvalues2_1']; $xml_vars['gvalues2_2'] = $_POST['gvalues2_2']; $xml_vars['gvalues3'] = $_POST['gvalues3']; $xml_vars['gvalues3_1'] = $_POST['gvalues3_1']; $xml_vars['gvalues3_2'] = $_POST['gvalues3_2']; $xml_vars['gvalues4'] = $_POST['gvalues4']; $xml_vars['gvalues4_1'] = $_POST['gvalues4_1']; $xml_vars['gvalues4_2'] = $_POST['gvalues4_2']; $xml_vars['virsmeri'] = $_POST['virsmeri']; $xml_vars['virsmeri_1'] = $_POST['virsmeri_1']; $xml_vars['virsmeri_2'] = $_POST['virsmeri_2']; $xml_vars['koeficients'] = $_POST['koeficients']; $xml_vars['koeficients_1'] = $_POST['koeficients_1']; $xml_vars['koeficients_2'] = $_POST['koeficients_2']; $xml_vars['raukums'] = $_POST['raukums']; $xml_vars['raukums_1'] = $_POST['raukums_1']; $xml_vars['raukums_2'] = $_POST['raukums_2']; $xml_vars['pavadzime'] = $_POST['pavadzime']; ///////////////////////////////////////////////////////////////////////// if ($C_REP->ERRORS) { $output = $output . "<html>"; $output = $output . "<head>"; $output = $output . "<title>Kļūda!</title>"; $output = $output . "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">"; $output = $output . "</head>"; $output = $output . "<center>"; $output = $output . "<STYLE TYPE=\"text/css\">"; $output = $output . " TD { font-size: 12px; }"; $output = $output . "</STYLE>"; $output = $output . "</style>"; $output = $output . "<body>"; $output = $output . "<p class='pagestart'></p><center><br><br>"; $output = $output . "<b><font color=red>Kļūda!</font></b>"; $output = $output . "<br><br>"; $output = $output . $C_REP->ERRORS; $output = $output . "</center>"; $output = $output . "<br><br>"; $output = $output . "<input type=button value=\"Atkārtot\" onclick=\"history.back(-1)\">"; $output = $output . "</body>"; $output = $output . "</html>"; return $output; } $output = $output . "\t<html>"; $output = $output . "\t<head>"; $output = $output . "\t\t\t\t\t\t <title>Atskaite</title>"; $output = $output . "\t\t\t\t\t\t <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">"; $output = $output . "\t\t\t\t\t\t</head>"; $output = $output . "\t\t\t\t\t\t<center>"; $output = $output . "\t<STYLE TYPE=\"text/css\">"; $output = $output . "\t TD { font-size: 12px; }"; $output = $output . "\t</STYLE>"; $output = $output . "\t<table border=0 width=90%>"; $output = $output . "\t<tr>"; $output = $output . "\t<td><img src=\"images/vmf.gif\"></td>"; $output = $output . "\t</tr>"; $output = $output . "\t<tr><td align=center>"; $output = $output . "\t<table>"; $output = $output . "\t<tr>"; $output = $output . "\t <td align=center width=50></td>"; $output = $output . "\t <td align=center valign=center><font size=5>Testēšanas pārskats nr. " . get_param('akts_nr') . "</font></td>"; $output = $output . "\t</tr>"; $output = $output . "\t</table>"; $output = $output . "\t<br>"; $output = $output . "\t<table cellspacing=0 cellpadding=0>"; if ($_POST['contract_num']) { $output = $output . "<tr><td align=right>Līguma Nr.: </td><td>" . $_POST['contract_num'] . "</td>"; } if ($_POST['pircejs_head']) { $output = $output . "<tr><td align=right>Pircējs: </td><td>" . $_POST['pircejs_head'] . "</td>"; } if ($_POST['pardevejs_head']) { $output = $output . "<tr><td align=right>Pārdevējs: </td><td>" . $_POST['pardevejs_head'] . "</td>"; } if ($_POST['datums_head']) { $output = $output . "<tr><td align=right>Datums: </td><td>" . $_POST['datums_head'] . "</td>"; } if ($_POST['pavadzime_head']) { $output = $output . "<tr><td align=right>Pavadzīme: </td><td>" . $_POST['pavadzime_head'] . "</td>"; } if ($_POST['iecirknis_head']) { $output = $output . "<tr><td align=right>Iecirknis: </td><td>" . $_POST['iecirknis_head'] . "</td>"; } if ($_POST['auto_head']) { $output = $output . "<tr><td align=right>Automašīnas nr.: </td><td>" . $_POST['auto_head'] . "</td>"; } if ($_POST['soferis_head']) { $output = $output . "<tr><td align=right>Šoferis: </td><td>" . $_POST['soferis_head'] . "</td>"; } if ($_POST['vieta_head']) { $output = $output . "<tr><td align=right>Uzmērīšanas vieta: </td><td>" . $_POST['vieta_head'] . "</td>"; } if ($_POST['custom12']) { $output = $output . "<tr><td align=right>" . $custom11 . " </td><td>" . $_POST['custom12'] . "</td>"; } if ($_POST['sortiments_head']) { $output = $output . "<tr><td align=right>Sortiments: </td><td>" . $_POST['sortiments_head'] . "</td>"; } if ($_POST['standarts_head']) { $output = $output . "<tr><td align=right>Standarts: </td><td>" . $_POST['standarts_head'] . "</td>"; } if ($_POST['metode_head']) { $output = $output . "<tr><td align=right>Metode un paņēmiens: </td><td>" . $_POST['metode_head'] . "</td>"; } if ($_POST['raukums_head']) { $output = $output . "<tr><td align=right>Raukums: </td><td>" . $_POST['raukums_head'] . "</td>"; } if ($_POST['merinstruments_head']) { $output = $output . "<tr><td align=right>Mērinstruments: </td><td>" . $_POST['merinstruments_head'] . "</td>"; } if ($_POST['terminsh_head']) { $output = $output . "<tr><td align=right>Verificēšanas termiņš: </td><td>" . $_POST['terminsh_head'] . "</td>"; } $output = $output . "</table>"; $output = $output . "<br><br><br>"; $output = $output . "<table><tr><td>"; $output = $output . $C_REP->GetHTML(); $output = $output . '<BR><BR></td></tr>'; if ($_POST['piezimes_head']) { $output = $output . '<tr><td align=left>Piezīmes: ' . $_POST['piezimes_head'] . '</td></tr>'; } $output = $output . "<tr><td height=20></td></tr>"; $output = $output . "<tr><td align=left>" . $translate['atb_persona'][$lang] . " ..................................................." . $_POST['atbildigais_head'] . "</td></tr>"; $output = $output . "<tr><td align=right><br><font size=1>" . $translate['veikts'][$lang] . " SIA VMF LATVIA <br>Reģ.nr.: 40003405130<br>Artilērijas iela 40, korpuss 12, Rīga, LV-1009 <br>" . $translate['talrunis'][$lang] . " +371 29470949 " . $translate['fakss'][$lang] . " + 371 67223718 " . $translate['epasts'][$lang] . " vmflatvia@vmf.lv</td></tr>"; $output = $output . "</table></table>"; $output = $output . "</body>"; $output = $output . "</html>"; return $output; }