| 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/.trash/files/fulltion.co.th/public_html/parcel/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');
$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( "invoicedetail", "count(*) as max"," BusXRouteID = '".$_GET['BusXRouteID']."'","" );
$getsumproduct = $db->getOne( "invoicedetail", "sum(ProductWeight) as sum"," BusXRouteID = '".$_GET['BusXRouteID']."'","" );
$getbusxemp = $db->getAll( "busxemp", "*"," BusID = '".$getbusid."'","" );
$getroutename = $db->getOne("route","*"," RouteID='".$getrouteid."'");
$getbusname = $db->getOne("bus","*"," BusID='".$getbusid."'");
$getPage = $db->gettest2("select * from ".DB_PREFIX."invoicedetail a left outer join ".DB_PREFIX."invoice b on a.InvoiceID = b.InvoiceID where BusXRouteID = '".$_GET['BusXRouteID']."' and LastPoint = '".$setpoint."' and InvoiceEndPoint ='".$_GET['EndPoint']."'");
?>
<div style="width:100%; height:100%">
<table width="100%">
<tr>
<td colspan="5">
<font style=" font:bold; font-size:20px;">บริษัท ทดสอบ จำกัด </font><br />
<font style="font-size:14px;">99/25 อาคารซอฟต์แวร์ พาร์ค ถนนแจ้งวัฒนะ คลองเกลือ ปากเกร็ด นนทบุรี</font>
</td>
<td width="104" style="text-align:left">
<?PHP echo @$objMaster->getdbdateformat(date("Y-m-d"));?>
</td>
</tr>
<tr>
<td width="220">
<label style="font-size:20px;">รายละเอียด</label>
</td>
<td width="249">
<label style="font-size:20px;"></label>
</td>
<td width="142">
<label style="font-size:20px;">รายการพัสดุในรถ</label>
</td>
</tr>
<tr>
<td>ส่งถึงสาขา :</td>
<td colspan="5" style="text-align:left;"><?PHP echo $getendname['DeliveryPointName'];?></td>
</tr>
<tr>
<td>
<label><?php echo $lang_set['route_code']; ?>:</label>
<?php echo $getroute['RouteCode']; ?>
</td>
<td colspan="2">
<label><?php echo $lang_set['route_name']; ?>:</label>
<?php echo $getroute['RouteName']; ?>
</td>
<td colspan="2"><label><?php echo $lang_set['planbuspoint_stopdate']; ?>:</label>
<?php echo $objMaster->getdbdateformat($getstopsuccess[0]); ?>
</td>
<td><label><?php echo $lang_set['planbuspoint_stoptime']; ?>:</label>
<?php echo $getstopsuccess[1]; ?>
</td>
<tr>
<tr>
<td>
<label><?php echo $lang_set['bus_plate']; ?>:</label>
<?php echo $getbus['BusPlate']; ?>
</td>
<td colspan="2">
<label><?php echo $lang_set['bus_name']; ?>:</label>
<?php echo $getbus['BusName']; ?>
</td>
<td colspan="2">
<label><?php echo $lang_set['bus_type']; ?>:</label>
<?php echo $getbustype['BusTypeName']; ?>
</td>
<td>
<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>
<!-- //-------------------------------ของ------------------------------------//-------->
<tr>
<td colspan="6">
<label style="font-size:20px;">รายการพัสดุ</label>
</td>
</tr>
<tr>
<th align="center" style="border-top:solid; border-bottom:double;">รหัสพัสดุ</th>
<th width="249" align="center" style="border-top:solid; border-bottom:double;">ชื่อผู้รับ</th>
<th align="center" style="border-top:solid; border-bottom:double;">ต้นทาง</th>
<th width="108" align="center" style="border-top:solid; border-bottom:double;">ประเภทพัสดุ</th>
<th width="132" align="center" style="border-top:solid; border-bottom:double;">หมายเหตุ</th>
<th width="104" align="center" style="border-top:solid; border-bottom:double; width:60px;">ขนาด</th>
<th width="140" align="center" style="border-top:solid; border-bottom:double;">น้ำหนัก(กก.)</th>
</tr>
<?PHP if($getPage){
foreach($getPage as $key => $va){
$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']."'");
$getnamereceive = $db->getOne("customer","*","CustomerID = '".$getinvoice['InvoiceReceiveID']."'");
?>
<tr>
<td style="width:220px;"><img src="barcode1.php?barcode=<?php echo @$va['ProductCode'];?>&width=250&height=50" /></td>
<td align="left" width="249"><?PHP echo $getnamereceive['CustomerName']." ".$getnamereceive['CustomerSurName'];?></td>
<td align="center"><?php echo $getstartname['DeliveryPointName'];?></td>
<td><?PHP echo $va['ProductName'];?></td>
<td style="text-align:left"><?PHP echo $va['ProductDetail'];?></td>
<td align="right"><?PHP echo $getnamesize['SetupSizeSize'];?></td>
<td align="right"><?PHP echo $va['ProductWeight'];?></td>
</tr>
<?PHP }
}?>
<tr>
<td style="border-bottom:double;" colspan="7"> </td>
</tr>
<tr>
<td colspan="7"> </td>
</tr>
<tr>
<td colspan="5"style="width:220px;">
ลงชื่อ.............................................พนักงาน<br />
<span style="width:220px; margin-left:70px;">(พนักงานพัสดุ)</span></td>
<td colspan="2" style="float:right"><p>
<span style="width:220px;">
ลงชื่อ.............................................พนักงาน </span><br />
<span style="width:220px; margin-left:70px;">(พนักงานบริกร)</span></p></td>
</tr>
</table>
</div>
</body>
<?PHP echo "<script>t = 3*1000;
window.print();
</script>";?>
<?PHP //setTimeout('window.close()',t); ?>