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;
}
