<?php include 'db.inc.php'; include "../check_login.php"; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/static/db_batch_func.php'; if ($mlietotajs['g_report'] != 'Y') { return; } $h = $_GET['h']; $batch_query_pavadzime = getCorrectBatch($h, "table_pavadzime"); // saglabājam datums $id = $_GET['id']; $r = mysql_query("select * from " . $batch_query_pavadzime . " where id = {$id}"); $m = mysql_fetch_array($r); if ($_POST['poga']) { if (!$iecikrnis) { $iecirknis = "NULL"; } if (!$kravas_id) { $kravas_id = "NULL"; } if (!$attalums) { $attalums = "0"; } $pavadzime = $_POST['pavadzime']; $piegad_grupa = $_POST['piegad_grupa']; $kad_piegad = $_POST['kad_piegad']; $iecirknis = $_POST['iecirknis']; $cirsmas_kods = $_POST['cirsmas_kods']; $fsc = $_POST['fsc']; $piegad_kods = $_POST['piegad_kods'];
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/static/db_batch_func.php'; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/libs/firebug/fb.php'; include 'db.inc.php'; include "../check_login.php"; if ($mlietotajs['g_report'] != 'Y') { return; } ob_start(); menu($_GET['h']); $h = $_GET['h']; $batch_query_count = getCorrectBatch($h, "batch_count"); $batch_query_select = getCorrectBatch($h, "batch"); $pavadzimes_tabula = getCorrectBatch($h, "table_pavadzime"); $nosaukums = getCorrectBatch($h, "nosaukums"); $nosaukums_dir = "batch_" . $nosaukums; //fb($_POST,'POST'); if ($_POST['komanda'] == 'update') { $id = $_POST['ident']; $qry_UpdateDel = "UPDATE `{$pavadzimes_tabula}` SET `opcija` = 'D' WHERE `batch_fails` = {$ident}"; // echo $qry_UpdateDel; mysql_query($qry_UpdateDel); } ?> <center> <?php //echo $batch_query_count; $rc = mysql_query($batch_query_count); $mc = mysql_fetch_array($rc); ?>
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/static/db_batch_func.php'; include 'db.inc.php'; include "../check_login.php"; if ($mlietotajs['g_report'] != 'Y') { return; } $id = $_GET['id']; $h = $_GET['h']; $batch_query_pavadzime = getCorrectBatch($h, "table_pavadzime"); $batch_query_select_balkis = getCorrectBatch($h, "table_balkis"); $batch_query_batch = getCorrectBatch($h, "table_batch"); //$rp = mysql_query("select id from ".$batch_query_pavadzime." where batch_fails = $id"); //while ($mp = mysql_fetch_array($rp)) // mysql_query("delete from ".$batch_query_select_balkis." where pavadzime = ".$mp[id]); mysql_query("UPDATE " . $batch_query_pavadzime . " SET opcija = 'D' where batch_fails = {$id}"); //mysql_query("delete from ".$batch_query_batch." where id = $id"); menu(0); ?> <br><br> Fails izdzēsts.
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/static/db_batch_func.php'; include 'db.inc.php'; include "../check_login.php"; if ($mlietotajs['g_report'] != 'Y') { return; } menu($_GET['h']); $pavadzime = $_GET['pavadzime']; $h = $_GET['h']; $skaits_Balki = 0; $batch_query_select_balkis = getCorrectBatch($h, "table_balkis"); list($ColumnNames, $ColumnValues, $ColumnData, $skaits_Balki) = returnColData($batch_query_select_balkis, $pavadzime); ?> <center>Ielasīto saraksts skaits: <?php echo $skaits_Balki; if (!$skaits_Balki) { die('Šai pavadzīmei netika atrasts neviens baļķis!'); } ?> <table border=1 cellspacing=0 cellpadding=2> <tr bgcolor=#7EBF7E><?php foreach ($ColumnNames as $Col_var) { ?> <th><?php echo $Col_var; ?> </th><?php }
<?php include 'db.inc.php'; include "../check_login.php"; require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/static/func_pavadzime.php'; if ($mlietotajs['g_report'] != 'Y') { return; } // die('Uz doto brīdi datus labot nevar!'); $h = $_GET['h']; $report_id = $_GET['report_id']; $batch_query_pavadzime = getCorrectBatch($report_id); $id = $_GET['id']; $r = mysql_query("select * from " . $batch_query_pavadzime . "pavadzime where id = {$id}"); $m = mysql_fetch_array($r); $batch_fails = $_POST['root_datFile']; if ($_POST['poga']) { updCorrectWaybill($h, $id, $batch_query_pavadzime, $_POST); header("location: http://www.vmf.lv/zb2/pavadzime_list.php?fails={$batch_fails}&h={$h}&report_id={$report_id}"); return; } menu($_GET['h']); ?> <center> <font size=5>Pavadzime labošana</font> <form name=form1 method=POST> <table> <tr> <td>Pavadzime numurs</td> <td><input name=pavadzime value="<?php echo $m['pavadzime'];