| 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/private_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');
$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;
}
}
if(isset($_GET['SSUpdateBusProduct']))
{
//unset(@$_SESSION['SSUpdateBusProduct']);
//@$_SESSION['SSUpdateBusProduct'] = @$_GET['SSUpdateBusProduct'];
@$setpoint = @$_GET['SSUpdateBusProduct'];
}
//@$setpoint = @$_SESSION['SSUpdateBusProduct'];
//unset(@$_SESSION['SSUpdateBusProduct']);
@$getbusxroute = @$db->getOne( "busxroute", "*"," BusXRouteID = '".@$_GET['BusXRouteID']."'","" );
@$getroute = @$db->getOne( "route", "*"," RouteID = '".@$getbusxroute['RouteID']."'","" );
@$getroutepoint = @$db->getAll( "routexpoint", "*"," RouteID = '".@$getroute['RouteID']."'","" );
@$getsequence = @$db->getOne( "routexpoint", "*"," RouteID = '".@$getroute['RouteID']."' and DeliveryPointID = '".@$setpoint."'","" );
@$getbus = @$db->getOne( "bus", "*"," BusID = '".@$getbusxroute['BusID']."'","" );
@$getbustype = @$db->getOne( "bustype", "*"," BusTypeID = '".@$getbus['BusType']."'","" );
@$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']."'","" );
if(!isset($getsumproduct['sum']))
{
@$getsumproduct['sum'] = 0;
}
@$where_lang = "lang_code='".@$lang_code."'";
@$getproduct = @$db->getJoin("*,d.DeliveryPointID as EndPoint","`tasoft_invoicedetail` a
LEFT OUTER JOIN `tasoft_invoice` b ON a.InvoiceID = b.InvoiceID
LEFT OUTER JOIN `tasoft_routexpoint` c ON a.LastPoint = c.DeliveryPointID
LEFT OUTER JOIN `tasoft_routexpoint` d ON b.InvoiceEndPoint = d.DeliveryPointID"," c.RouteID = '".@$getbusxroute['RouteID']."'
AND d.RouteID = '".@$getbusxroute['RouteID']."'
AND c.PointSequence < d.PointSequence
AND d.PointSequence >= '".@$getsequence['PointSequence']."'
AND (a.status = 1 or a.status = 7)
And a.LastPoint = '".@$setpoint."'","");
?>
<!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-->
<div style="width:100%; height:100%">
<div class="content-box-content">
<table width="100%">
<tr>
<td align="center">
<label style="font-size:20px;">รายการของที่สามารถนำขึ้นรถได้</label>
</td>
</tr>
</table>
<p></p>
<table width="100%">
<tr>
<th style="border-top:double;border-bottom:solid;border-bottom-width:thin" width="250px"><?php echo @$lang_set['CodeProduct']; ?></th>
<th style="border-top:double;border-bottom:solid;border-bottom-width:thin"><?php echo @$lang_set['NameProduct']; ?></th>
<th style="border-top:double;border-bottom:solid;border-bottom-width:thin"><?php echo @$lang_set['DetailProduct']; ?></th>
<th style="border-top:double;border-bottom:solid;border-bottom-width:thin"><?php echo @$lang_set['bus_name']; ?></th>
<th style="border-top:double;border-bottom:solid;border-bottom-width:thin"><?php echo @$lang_set['WeightProduct']; ?></th>
<th style="border-top:double;border-bottom:solid;border-bottom-width:thin"><?php echo @$lang_set['SizeProducr']; ?></th>
<th style="border-top:double;border-bottom:solid;border-bottom-width:thin"><?php echo @$lang_set['endpoint']; ?></th>
</tr>
<?PHP
@$i = 1;
if(@$getproduct){
foreach($getproduct as $key => $va){
@$getpoint = @$db->getOne("deliverypoint","*",@$where_lang." and DeliveryPointID='".@$va['EndPoint']."'");
@$getnamesize = @$db->getOne("setupsize","*","SetupSizeID = ".@$va['ProductSize']);
?>
<tr>
<th><img src="barcode1.php?barcode=<?php echo @$va['ProductCode'];?>&width=220&height=50" /></th>
<th><?php echo @$va['ProductName'];?></th>
<th><?php echo @$va['ProductDetail'];?></th>
<th><?php echo "(.........................)";?></th>
<th><?php echo @$va['ProductWeight'];?></th>
<th><?php echo @$getnamesize['SetupSizeSize'];?></th>
<th><?php echo @$getpoint['DeliveryPointName'];?></th>
</tr>
<?php @$i++;}
}else{
?>
<tr>
<th colspan="11" style="text-align:center"><?php echo @$lang_set['not_data']; ?></th>
</tr>
<?php
}
?>
</table>
</div>
</body>
<?PHP echo "<script>t = 3*1000;
window.print();
</script>";?>
<?PHP //setTimeout('window.close()',t); ?>