<?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'];
