| Server IP : 27.254.152.13 / Your IP : 216.73.217.38 Web Server : Apache/2 System : Linux ns1-252017.dragonhispeed.com 5.2.0 #1 SMP Fri Mar 29 22:50:14 MSK 2024 x86_64 User : coloflew ( 1072) PHP Version : 5.6.40 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/coloflew/domains/fulltion.com/public_html/administrator/ |
Upload File : |
<?php
require_once('../lib/sys_config.php');
require_once('../lib/class/SC_Query.php');
require_once('../lib/class/SC_Mysql.php');
require_once('../lib/class/SC_Master.php');
require_once('../lib/class/SC_Email.php');
require_once('../lib/class/SC_Function.php');
//echo "pre";
$db = new SC_Query();
$objMaster = new SC_Master();
$objFun = new SC_Function();
if(isset($_SESSION['lang_code']) && @$_GET['lang']){
//$la = $_GET['lang'] ? $_GET['lang'] : "En";
$_SESSION['lang_code'] = $_GET['lang'];
$lang_code = $_SESSION['lang_code'];
}elseif(isset($_SESSION['lang_code'])){
$lang_code = $_SESSION['lang_code'];
}else{
$lang_code = "En";
$_SESSION['lang_code'] = $lang_code;
}
$lang_value = $db->getAll('language_value','*',"lang_code='".$lang_code."'");
//echo "<pre>"; print_r($lang_value);
if($lang_value){
$lang_set = array();
foreach($lang_value as $ke => $va){
$lang_set[$va['name']] = $va['value'];
//echo $lang_set[$va['name']];
//$lang = $lang_f;
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<!-- Scrip Java-->
<?PHP
$setpoint = $_GET['SSUpdateBusProduct'];
$getstartname = $db->getOne("deliverypoint","*","DeliveryPointID = '".$setpoint."'");
$getendname = $db->getOne("deliverypoint","*","DeliveryPointID = '".$_GET['EndPoint']."'");
$getcode = $db->getOne("busxroute","*"," BusXRouteID='".$_GET['BusXRouteID']."'");
$getbusxroute = $db->getOne( "busxroute", "*"," BusXRouteID = '".$_GET['BusXRouteID']."'","" );
$getroute = $db->getOne( "route", "*"," RouteID = '".$getcode['RouteID']."'","" );
$getbus = $db->getOne( "bus", "*"," BusID = '".$getbusxroute['BusID']."'","" );
$getbustype = $db->getOne( "bustype", "*"," BusTypeID = '".$getbus['BusType']."'","" );
$getrouteid = $getcode['RouteID'];
$getbusid = $getcode['BusID'];
$gettime = $db->getJoin("a.*,b.BusXRouteID,b.SetDate,b.SetTime,b.BusID","tasoft_routexpoint a
LEFT OUTER JOIN tasoft_busxroute b ON a.RouteID = b.RouteID"," b.BusXRouteID = '".$getbusxroute['BusXRouteID']."' and a.DeliveryPointID = '".$setpoint."'","","");
if($gettime){
foreach($gettime as $key => $val){
$getstop = $db->gettest("SELECT ADDTIME( ADDTIME( '".$val['SetDate']." ".$val['SetTime']."', '".$val['PointTime']."' ) , '".$val['PointStop']."' ) AS PointTime");
$getstopsuccess = explode(" ",$getstop['PointTime']);
}
}
$getcountproduct = $db->getOne( "hist", "count(*) as max"," BusXRouteID = '".$_GET['BusXRouteID']."' and status = '2' and HistDatetime between '".$getbusxroute['SetDate']." 00:00:00'and '".$getbusxroute['SetDate']." 23:59:59'","" );
//$getcountproduct = $db->getOne( "hist", "count(*) as max"," BusXRouteID = '".$_GET['BusXRouteID']."' and status = '2' and HistDatetime between '".$getbusxroute['SetDate']." 00:00:00'and '".$getbusxroute['SetDate']." 23:59:59'","" );
$getsumproduct = $db->getOne( "hist a inner join ".DB_PREFIX."invoicedetail b on a.invoicedetailID = b.invoicedetailID", "sum(ProductWeight) as sum"," a.BusXRouteID = '".$_GET['BusXRouteID']."' and a.status = '2' and a.HistDatetime between '".$getbusxroute['SetDate']." 00:00:00'and '".$getbusxroute['SetDate']." 23:59:59'","" );
/*
$getsumproduct = $db->getOne( "hist a inner join ".DB_PREFIX."invoicedetail b on a.invoicedetailID = b.invoicedetailID", "sum(ProductWeight) as sum"," a.BusXRouteID = '".$_GET['BusXRouteID']."' and a.status = '2' and a.HistDatetime between '".$getbusxroute['SetDate']." 00:00:00'and '".$getbusxroute['SetDate']." 23:59:59'","" ); */
$getbusemp = $db->getOne( "hist", "*"," BusXRouteID = '".$_GET['BusXRouteID']."' and status = '2' and HistDatetime between '".$getbusxroute['SetDate']." 00:00:00'and '".$getbusxroute['SetDate']." 23:59:59'","" );
/*$getbusemp = $db->getOne( "hist", "*"," BusXRouteID = '".$_GET['BusXRouteID']."' and status = '2' and HistDatetime between '".$getbusxroute['SetDate']." 00:00:00'and '".$getbusxroute['SetDate']." 23:59:59'","" );*/
$getbusempname = json_decode($getbusemp['Detaillog'],true);
$getroutename = $db->getOne("route","*"," RouteID='".$getrouteid."'");
$getbusname = $db->getOne("bus","*"," BusID='".$getbusid."'");
$where_f = " a.BusXRouteID = '".$_GET['BusXRouteID']."' and a.status = '2' and a.HistDatetime between '".$getbusxroute['SetDate']." 00:00:00'and '".$getbusxroute['SetDate']." 23:59:59'";
/*
$where_f = " a.BusXRouteID = '".$_GET['BusXRouteID']."' and a.status = '2' and a.HistDatetime between '".$getbusxroute['SetDate']." 00:00:00'and '".$getbusxroute['SetDate']." 23:59:59'";
*/
$page = @$_GET['page'] ? @$_GET['page'] : 1;
$arrpageP = $db->getAll( "hist a inner join ".DB_PREFIX."invoicedetail b on a.invoicedetailID = b.invoicedetailID", "Distinct b.*",$where_f,"" );
$arrPage = $objMaster->viewPages($page, $arrpageP, "15");
$getPage = $db->getAll("hist a inner join ".DB_PREFIX."invoicedetail b on a.invoicedetailID = b.invoicedetailID","Distinct b.*",$where_f,"",$arrPage["offset"]);
$getPage = $db->gettest2("select * from ".DB_PREFIX."hist a inner join ".DB_PREFIX."invoicedetail b on a.invoicedetailID = b.invoicedetailID where a.BusXRouteID = '".$_GET['BusXRouteID']."' and a.status = '2' and EndPoint = '".$_GET['EndPoint']."'");
/*$getPage = $db->gettest2("select * from ".DB_PREFIX."hist a inner join ".DB_PREFIX."invoicedetail b on a.invoicedetailID = b.invoicedetailID where a.BusXRouteID = '".$_GET['BusXRouteID']."' and a.status = '9' and EndPoint = '".$_GET['EndPoint']."'");*/
?>
<div style="width:100%; height:100%">
<table width="100%">
<tr>
<td>
<font style=" font:bold; font-size:20px;">บริษัท ทดสอบ จำกัด</font><br />
<font style="font-size:14px;">99/25 อาคารซอฟต์แวร์ พาร์ค ถนนแจ้งวัฒนะ คลองเกลือ ปากเกร็ด นนทบุรี</font>
</td>
<td width="150px" >
<?PHP echo @$objMaster->getdbdateformat(date("Y-m-d"));?>
</td>
</tr>
<tr>
<td align="center">
<font style=" font:bold; font-size:20px;">รายการส่งของย้อนหลัง</font><br />
</td>
<td width="150px" >
</td>
</tr>
</table>
<table width="100%">
<tr>
<td>
<label style="font-size:20px;">รายละเอียด</label>
</td>
</tr>
</table>
<table width="100%"><tr><th width="20%" align="left">ส่งถึงสาขา :</th><th width="80%" align="left"><?PHP echo $getendname['DeliveryPointName'];?></th></tr></table>
<table width="100%">
<tr>
<td width="20%">
<label><?php echo $lang_set['route_code']; ?>:</label>
<?php echo $getroute['RouteCode']; ?>
</td>
<td width="30%">
<label><?php echo $lang_set['route_name']; ?>:</label>
<?php echo $getroute['RouteName']; ?>
</td>
<td width="30%">
<label><?php echo $lang_set['planbuspoint_stopdate']; ?>:</label>
<?php echo $objMaster->getdbdateformat($getstopsuccess[0]); ?>
</td>
<td width="20%">
<label><?php echo $lang_set['planbuspoint_stoptime']; ?>:</label>
<?php echo $getstopsuccess[1]; ?>
</td>
<tr>
</table>
<table width="100%">
<tr>
<td width="20%">
<label><?php echo $lang_set['bus_plate']; ?>:</label>
<?php echo $getbus['BusPlate']; ?>
</td>
<td width="30%">
<label><?php echo $lang_set['bus_name']; ?>:</label>
<?php echo $getbus['BusName']; ?>
</td>
<td width="30%">
<label><?php echo $lang_set['bus_type']; ?>:</label>
<?php echo $getbustype['BusTypeName']; ?>
</td>
<td width="20%">
<label><?php echo $lang_set['count_product']; ?>:</label>
<span id="countproduct"><?php echo count($getPage)."/".$getcountproduct['max']; ?></span>
<input type="hidden" id="hdcountproduct" value="<?php echo $getcountproduct['max']; ?>" >
</td>
<tr>
</table>
<!-- //-------------------------------ของ------------------------------------//-------->
<table width="100%">
<tr>
<td>
<label style="font-size:20px;">รายการพัสดุ</label>
</td>
</tr>
</table>
<table width="80%">
<tr>
<th align="center" style="border-top:solid; border-bottom:double;">รหัสพัสดุ</th>
<th align="center" style="border-top:solid; border-bottom:double;">ต้นทาง</th>
<th align="center" style="border-top:solid; border-bottom:double;">ประเภทพัสดุ</th>
<th align="center" style="border-top:solid; border-bottom:double;">หมายเหตุ</th>
<th align="center" style="border-top:solid; border-bottom:double;">ขนาด</th>
<th align="center" style="border-top:solid; border-bottom:double;">น้ำหนัก(กก.)</th>
</tr>
<?PHP //if($getPage){
//foreach($getPage as $key => $va){
if($getPage){
//$getPage1 = array();
foreach($getPage as $cey => $wa){
@$getPage1 = $db->getOne("hist a inner join ".DB_PREFIX."invoicedetail b on a.invoicedetailID = b.invoicedetailID","DISTINCT b.*"," a.InvoiceDetailID = '".$wa['InvoiceDetailID']."' and a.InvoiceID = '".$wa['InvoiceID']."' and a.status = '9' ");
/*
$getPage1 = $db->getAll("hist a inner join ".DB_PREFIX."invoicedetail b on a.invoicedetailID = b.invoicedetailID","DISTINCT a.InvoiceDetailID,a.InvoiceID,a.StartPoint,a.EndPoint,a.status,a.LastPoint,a.BusXRouteID,a.EmpSendID, a.EmpReviceID,a.CustomerReceiveID,b.*"," a.InvoiceDetailID = '".$wa['InvoiceDetailID']."' and a.InvoiceID = '".$wa['InvoiceID']."' and a.status = '9' ");
*/
if(@getPage1){
//echo "<pre>";
//print_r($getPage1);
/*foreach(getPage1 as $ey => $rt){ */
@$getinvoice = $db->getOne( "invoice", "*"," InvoiceID = '".@$getPage1['InvoiceID']."'","" );
@$getendname = $db->getOne("deliverypoint","*","DeliveryPointID = '".@$getinvoice['InvoiceEndPoint']."'");
@$getstartname = $db->getOne("deliverypoint","*","DeliveryPointID = '".@$getinvoice['InvoiceStartPoint'].
"'");
?>
<tr>
<td align="center"><?php if(@$getPage1['ProductCode']!=""){
?>
<img src="barcode1.php?barcode=<?php echo @$getPage1['ProductCode'];?>&width=220&height=50" />
<?php
}?>
</td>
<td align="center"><?php echo @$getstartname['DeliveryPointName'];?></td>
<td><?PHP echo @$getPage1['ProductName'];?></td>
<td><?PHP echo @$getPage1['ProductDetail'];?></td>
<td align="right"><?PHP echo @$getPage1['SetupSizeSize'];?></td>
<td align="right"><?PHP echo @$getPage1['ProductWeight'];?></td>
</tr>
<?php
//}// foreach*/
} //if
//$getnamesize = $db->getOne("setupsize","*","SetupSizeID = '".$wa['ProductSize']."'","");
/*$getinvoice = $db->getOne( "invoice", "*"," InvoiceID = '".$wa['InvoiceID']."'","" );
$getendname = $db->getOne("deliverypoint","*","DeliveryPointID = '".$getinvoice['InvoiceEndPoint']."'");
$getstartname = $db->getOne("deliverypoint","*","DeliveryPointID = '".$getinvoice['InvoiceStartPoint']."'"); */ /*
$getnamesize = $db->getOne("setupsize","*","SetupSizeID = '".$va['ProductSize']."'","");
$getinvoice = $db->getOne( "invoice", "*"," InvoiceID = '".$va['InvoiceID']."'","" );
$getendname = $db->getOne("deliverypoint","*","DeliveryPointID = '".$getinvoice['InvoiceEndPoint']."'");
$getstartname = $db->getOne("deliverypoint","*","DeliveryPointID = '".$getinvoice['InvoiceStartPoint']."'");?>
*/ ?>
<?PHP }
}?>
</table>
</div>
</body>
<?PHP echo "<script>t = 3*1000;
window.print();
</script>";?>
<?PHP //setTimeout('window.close()',t); ?>