| 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/modules/manu_supply/ |
Upload File : |
<?php
@$linkSupplytobus = "index.php?name=manu_supply&file=supplytobus";
@$link1 = "index.php?name=manu_supply&file=supplyinbus";
@$link2 = "index.php?name=manu_supply&file=supplyupdate";
if(isset($fullsc)){
@$linkSupplytobus .= "&fullsc=fullsc";
@$link1 .= "&fullsc=fullsc";
@$link2 .= "&fullsc=fullsc";
}
@$where_lang = " lang_code = '".@$lang_code."'";
if(@$_POST['keyword']){@$search = @$_POST['keyword']; }
if(@$_GET['keyword']){@$search = @$_GET['keyword']; }
if(@$_POST['DeliveryPointID']){@$setpoint = @$_POST['DeliveryPointID']; }
if(@$_GET['DeliveryPointID']){@$setpoint = @$_GET['DeliveryPointID']; }
if(@$search){
@$search = str_replace("'", "\'", @$search);
if(@$where_f){
@$where_f .= " and b.SetDate = '".@$objMaster->getdateformat(@$search)."' and a.DeliveryPointID = '".@$setpoint."'";
}else{
@$where_f = " b.SetDate = '".@$objMaster->getdateformat(@$search)."' and a.DeliveryPointID = '".@$setpoint."'";
}
@$setpoint = @$setpoint;
}else{
@$setpoint = @$_SESSION['member']['point'];
@$where_f = " b.SetDate = '".date("Y-m-d")."' and a.DeliveryPointID = '".@$_SESSION['member']['point']."'";
}
@$page = @$_GET['page'] ? @$_GET['page'] : 1;
@$arrpageP = @$db->getJoin("a.*,b.BusXRouteID,b.SetDate,b.SetTime,b.BusID","better_routexpoint a
LEFT OUTER JOIN better_busxroute b ON a.RouteID = b.RouteID ",@$where_f,"","");
@$arrPage = @$objMaster->viewPages(@$page, @$arrpageP, "50");
@$getPage = @$db->getJoin("a.*,b.BusXRouteID,b.SetDate,b.SetTime,b.BusID","better_routexpoint a
LEFT OUTER JOIN better_busxroute b ON a.RouteID = b.RouteID",@$where_f,"",@$arrPage["offset"]);
if(@$getPage){
foreach(@$getPage as $key => $val){
@$arrCunt = @$db->getOne( "invoicedetail", "count(*) as total"," BusXRouteID = '".@$val['BusXRouteID']."'","" );
$getPage[$key]['total'] = @$arrCunt['total'];
}
}
//echo "<pre>"; print_r(@$getPage);
@$getPoint = @$db->getAll( "deliverypoint", "*",@$where_lang." and DeliveryPointStatus = '1'","" );
//echo "<pre>==>"; print_r(@$getPage);
@$getreport = @$db->getJoin("InvoiceEndPoint , count(InvoiceEndPoint) as countpro"," better_invoicedetail a left outer join
better_invoice b on a.InvoiceID = b.InvoiceID "
," a.LastPoint = '".@$setpoint."' and (a.status = '1' or a.status = '7' or a.status = '5')"," group by InvoiceEndPoint");
$linkUrl = "index.php?name=manu_supply&file=supplytobus&keyword=".@$search."&DeliveryPointID=".@$setpoint;
?>
<!-- Start Content Box -->
<div class="content-box">
<!-- Start Content Box Header-->
<div class="content-box-header">
<?PHP if(isset($fullsc)){ ?>
<label><a href="index.php?name=manu_main&hk=login"><img src="resources/images/home.png" alt="Edit" /></a></label>
<?PHP }?>
<h3><?php echo @$lang_set['busout_title']; ?></h3>
<ul class="content-box-tabs">
<li><a href="#list" <?php echo (@$_GET['act']=="" ? 'class="default-tab"' : '');?>><?php echo @$lang_set['list_busout']; ?></a></li> <!-- href must be unique and match the id of target div -->
</ul>
<div class="clear"></div>
</div>
<!-- End Content Box Header-->
<!-- Start Content Box Content-->
<div class="content-box-content">
<?php if(@$res){?>
<div class="notification success png_bg">
<a href="#" class="close"><img src="resources/images/icons/cross_grey_small.png" title="Close this notification" alt="close" /></a>
<div>
<?php echo @$msg;?>
</div>
</div>
<meta http-equiv="refresh" content="1;URL=<?PHP echo @$linkSupplytobus;?>">
<?php }?>
<!-- Start Tab Content id="list"-->
<div class="tab-content <?php echo (@$_GET['act']=="" ? 'default-tab' : '');?>" id="list">
<form action="<?PHP echo @$linkSupplytobus;?>" method="post" name="form_search">
<?php echo @$lang_set['input_search'];?> :
<?php if(@$_SESSION['member']['permistion'] == "4"){?>
<select name="DeliveryPointID" id="DeliveryPointID" onchange="SelectSS();">
<?php
if(@$getPoint){foreach($getPoint as $key => $val){
?>
<option value="<?php echo @$val['DeliveryPointID'];?>" <?php echo (@$val['DeliveryPointID']=='' || @$val['DeliveryPointID']==@$setpoint ? "selected" : "")?>><?php echo @$val['DeliveryPointName'];?></option>
<?php }
}
?>
</select>
<?PHP }else{
@$getpointname = @$db->getOne("deliverypoint","*",@$where_lang." and DeliveryPointID='".@$setpoint."'");
?>
<a><?PHP echo @$getpointname['DeliveryPointName']?></a>
<input type="hidden" name="DeliveryPointID" value="<?PHP echo @$setpoint;?>" />
<?PHP }?>
<input type="text" class="text date_picker" name="keyword" value="<?php echo @$search == ''? @$objMaster->getdbdateformat(date("Y-m-d")) : @$search ;?>"/>
<input type="submit" class="button" value="ค้นหา"/>
</form>
<form action="<?PHP echo $linkUrl;?>&act=deleteAll" method="post">
<table cellpadding="0" cellspacing="0" width="100%">
<thead>
<tr>
<th style="text-align:left;"><?php echo @$lang_set['route_code']; ?></th>
<th style="text-align:left;"><?php echo @$lang_set['route_name']; ?></th>
<th style="text-align:left;"><?php echo @$lang_set['deliverypoint_name']; ?></th>
<th style="text-align:left;"><?php echo @$lang_set['bus_name']; ?></th>
<th style="text-align:left;"><?php echo @$lang_set['bustype_name']; ?></th>
<th style="text-align:left;"><?php echo @$lang_set['planbuspoint_stopdate']; ?></th>
<th style="text-align:left;"><?php echo @$lang_set['planbuspoint_stoptime']; ?></th>
<th style="text-align:center;"></th>
</tr>
</thead>
<?php
@$checkmax = 0;
@$check = 0;
//echo '<pre>';print_r(@$getPage);
if(@$getPage){
foreach($getPage as $key => $val){
@$getpoint = @$db->getOne("deliverypoint","*",@$where_lang." and DeliveryPointID='".@$val['DeliveryPointID']."'");
@$getroute = @$db->getOne("route","*",@$where_lang." and RouteID='".@$val['RouteID']."'");
@$getbus = @$db->getOne("bus","*",@$where_lang." and BusID='".@$val['BusID']."'");
@$getbustype = @$db->getOne("bustype","*",@$where_lang." and BusTypeID='".@$getbus['BusType']."'");
//echo "<pre>"; print_r(@$val);
@$getstop = @$db->gettest("SELECT ADDTIME( ADDTIME( '".@$val['SetDate']." ".@$val['SetTime']."', '".@$val['PointTime']."' ) , '".@$val['PointStop']."' ) AS PointTime");
//echo "<pre>"; print_r(@$getstop);
@$getstopsuccess = explode(" ",@$getstop['PointTime']);
@$getmax = @$db->getOne("routexpoint","max(PointSequence) as max"," RouteID='".@$val['RouteID']."'");
if(@$getmax['max'] != @$val['PointSequence']){
?>
<tr>
<th><?php echo @$getroute['RouteCode'];?></th>
<th><?php echo @$getroute['RouteName'];?></th>
<th><?php echo @$getpoint['DeliveryPointName'];?></th>
<th><?php echo @$getbus['BusName'];?></th>
<th><?php echo @$getbustype['BusTypeName'];?></th>
<th><?php echo @$objMaster->getdbdateformat(@$val['SetDate']);?></th>
<th><?php echo @$val['SetTime'];?></th>
<th style="text-align:center;">
<?php //echo "==>".date('H:i:s');?>
<?php if($val['total']>0){?>
<a href="<?PHP echo @$link1;?>&BusXRouteID=<?php echo @$val['BusXRouteID'];?>&SSUpdateBusProduct=<?php echo @$setpoint;?>" title="ดูพัสดุในรถ"><img src="resources/images/icons/Find.png" alt="PlanBusPoint" /></a> | <?php }?> <?php if(@$val['SetTime'] >= date('H:i:s') && @$val['SetDate'] >= date("Y-m-d")){?>
<a href="<?PHP echo @$link2;?>&BusXRouteID=<?php echo @$val['BusXRouteID']?>&SSUpdateBusProduct=<?php echo @$setpoint;?>" title="จัดของขึ้นรถ"><img src="resources/images/icons/Input.png" alt="PlanBusPoint" /></a> |<?php }?>
<?php if($val['total']>0){?>
<a href="coreprintpreview.php?BusXRouteID=<?php echo @$val['BusXRouteID'];?>&SSUpdateBusProduct=<?php echo @$setpoint;?>&type=new" target="_blank" title="ปริ้นพัสดุในรถ"><img src="resources/images/printer-icon.png" alt="Print" width="20px" height="20px" /></a>|
<?php }?>
<a href="previewproducttobus.php?BusXRouteID=<?php echo @$val['BusXRouteID'];?>&SSUpdateBusProduct=<?php echo @$setpoint;?>" target="_blank" title="ปริ้นใบจัดของขึ้นรถ"><img src="resources/images/printer-icon.png" alt="Print" width="20px" height="20px" /></a>
</th>
</tr>
<?php
}else{@$checkmax++;}
@$check++;
}
?>
<?PHP if(@$check == @$checkmax){?>
<tr>
<th colspan="11" style="text-align:center"><?php echo @$lang_set['not_data']; ?></th>
</tr>
<?PHP }?>
<?PHP
}else{
?>
<tr>
<th colspan="11" style="text-align:center"><?php echo @$lang_set['not_data']; ?></th>
</tr>
<?php
}
?>
<tfoot>
<tr>
<td colspan="11">
<!-- Start .pagination -->
<div class="pagination">
<?php if($arrPage['allpage']>1){?>
<a href="<?php echo $linkUrl;?>&page=1" title="หน้าแรก">« หน้าแรก</a><a href="<?php echo $linkUrl;?>&page=<?php echo (1==$page ? $page : @$page-1);?>" title="ก่อนหน้า">« ก่อนหน้า</a>
<?php if( @$arrPage["startPage"]!="" && @$arrPage["endPage"] !="" ){?>
<?php
for($i = @$arrPage["startPage"]; $i <= @$arrPage["endPage"]; ++$i) {
echo'<a href="'.$linkUrl.'&page='.@$i.'" '.(@$page == @$i ? 'class="number current"' : '').'>'.(@$i).'</a>';
}?>
<?php }?>
<a href="<?php echo $linkUrl;?>&page=<?php echo ($page==$arrPage["allpage"] ? $page : $page+1);?>" title="ถัดไป">ถัดไป »</a><a href="<?php echo $linkUrl;?>&page=<?php echo @$arrPage["allpage"];?>" title="หน้าสุดท้าย">หน้าสุดท้าย »</a>
<?php }?>
</div>
<!-- End .pagination -->
<div class="clear"></div>
</td>
</tr>
</tfoot>
</table>
</form>
</div>
<!-- End Tab Content id="list"-->
<div class="content-box" style="width:50%">
<div class="content-box-header">
<h3><?php echo @$lang_set['product_latetoday']; ?></h3>
<div class="clear"></div>
</div>
<div class="content-box-content">
<table cellpadding="0" cellspacing="0" width="100%">
<thead>
<tr>
<th width="50%" align="left"><?php echo @$lang_set['endpoint']; ?></th>
<th width="50%" align="left"><?php echo @$lang_set['count_product']; ?></th>
</tr>
</thead>
<?PHP if(@$getreport){
foreach($getreport as $key => $val){
@$getend = @$db->getOne( "deliverypoint", "*",@$where_lang." and DeliveryPointID = '".@$val['InvoiceEndPoint']."'");
?>
<tr>
<th width="50%" align="left"><?php echo @$getend['DeliveryPointName']; ?></th>
<th width="50%" align="left"><?php echo @$val['countpro']; ?></th>
</tr>
<?PHP }
}else{
?>
<tr>
<th colspan="11" style="text-align:center"><?php echo @$lang_set['not_data']; ?></th>
</tr>
<?php
}
?>
</table>
</div>
</div>
</div>