<?php 
if(@$_GET['act']=="search"){
	if(strlen($_POST['InvoiceCode']) < 10){
		$getproduct = $db->getJoin("ind.*,CONCAT(CustomerName,' ',CustomersurName) as detailName ,(select CONCAT(CustomerName,' ',CustomerSurName) as Name from ".DB_PREFIX."customer where CustomerID=inv.InvoiceReceiveID ) as DetailNameRe",DB_PREFIX."invoicedetail ind inner join ".DB_PREFIX."invoice inv on inv.InvoiceID=ind.InvoiceID inner join ".DB_PREFIX."customer cus on cus.CustomerID=inv.InvoiceSendID","inv.InvoiceCode = '".$_POST['InvoiceCode']."'");
	$type = "InvoiceCode";
	}else{
		$getproduct = $db->getJoin('hist.*,sta.statusdesc,CONCAT(CustomerName," ",CustomerSurName) as detailName,(select CONCAT(CustomerName," ",CustomerSurName) as Name from '.DB_PREFIX.'customer where CustomerID=inv.InvoiceReceiveID ) as DetailNameRe',DB_PREFIX.'hist hist inner join '.DB_PREFIX.'invoidestatus sta on sta.statusid=hist.status inner join '.DB_PREFIX.'invoicedetail ind on ind.InvoiceDetailID=hist.InvoiceDetailID inner join '.DB_PREFIX.'invoice inv on inv.InvoiceID=ind.InvoiceID inner join '.DB_PREFIX.'customer cus on cus.CustomerID=inv.InvoiceSendID'," ind.ProductCode = '".$_POST['InvoiceCode']."'","order by hist.HistDatetime asc" );
	$type = "ProductCode";
	}
}
$where_lang = "lang_code='".$lang_code."'";

//echo "<pre>"; print_r($getPage);
?>

<!-- Start Content Box -->
<div class="content-box">
	<!-- Start Content Box Header-->
	<div class="content-box-header">
					
			<h3><?php echo "ติดตามรายการพัสดุ"; ?></h3>
					
			<div class="clear"></div>	
	</div>		
    <!-- End Content Box Header-->
    
    <!-- Start Content Box Content-->
    <div class="content-box-content">
   
   		<!-- Start Tab Content id="list"-->
        <div class="tab-content default-tab">
        	<?PHP  ?>
     		<form action="index.php?act=search" method="post" enctype="multipart/form-data" ><!--onsubmit="return checkdelivery();"-->
            	<fieldset>
                    <p>
                      <strong><?php echo "รหัสใบกำกับสินค้า / รหัสพัสดุ" ?>:</strong>
                      <input type="text" class="text-input small-input" name="InvoiceCode" id="InvoiceCode" value="" />
                   	  <input type="submit" class="button" value="Submit" />
                    </p>
   
        		</fieldset>
        	</form>			
            
            <form action="index.php?&act=search" method="post">
            <?PHP  if(@$type == "InvoiceCode"){?>	
                	<table>
                    	<thead>
                        	<tr>
                        	<th style="text-align:left"><?php echo $lang_set['CodeProduct']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['DetailNameCus']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['DetailNameCusRe']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['NameProduct']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['lastpoint']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['ProductWeight']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['ProductSize']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['totalmoney']; ?></th>
                            <th><?php echo $lang_set['invoice_status']; ?></th>
                            <th><?php echo $lang_set['comment']; ?></th>
                            </tr>
                        </thead>
                        <?PHP 
						if(@$getproduct){
                			foreach(@$getproduct as $key => $va){
							$getstatusproduct = $db->getOne("invoidestatus","*"," statusid='".$va['status']."'");
							$getpoint = $db->getOne("deliverypoint","*",$where_lang." and DeliveryPointID='".$va['LastPoint']."'");
							$color = @$color=="#fff" ? "#E8E8E8" : "#fff";
						?>
                        <tr style="background:<?php echo $color;?>">
                            <td><?php echo $va['ProductCode'];?></td>
                            <td><?php echo $va['detailName'];?></td>
                            <td><?php echo $va['DetailNameRe'];?></td>
                            <td><?php echo $va['ProductName'];?></td>
                             <td><?php echo $getpoint['DeliveryPointName'];?></td>
                            <td><?php echo $va['ProductWeight'];?></td>
                            <td><?php echo $va['ProductSize'];?></td>
                            <td><?php echo $va['totalmoney'];?></td>
                            <td><?php echo $getstatusproduct['statusdesc'];?></td>
                            <td><?php echo $va['comment'];?></a></td>
                        <tr>
                        <?php }
						}else{
						?>
						<tr>
							<th colspan="11" style="text-align:center"><?php echo $lang_set['not_data']; ?></th>
						<tr>
						<?php 
						}
						?>
                    </table>
            <?PHP  }else{?>
            		<table>
                    <thead>
                        	<tr>
                        	<th style="text-align:left"><?php echo $lang_set['CodeProduct']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['DetailNameCus']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['DetailNameCusRe']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['NameProduct']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['DetailProduct']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['startpoint']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['endpoint']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['lastpoint']; ?></th>
                            <th style="text-align:left"><?php echo $lang_set['bus_name']; ?></th>
                            <th><?php echo $lang_set['invoice_status']; ?></th>
                           <!-- <th><?php echo $lang_set['comment']; ?></th>-->
                            </tr>
                       </thead>
                        <?PHP 
						if(@$getproduct){
                			foreach(@$getproduct as $key => $va){
							
							$getbusxroute = $db->getOne( "busxroute", "*"," BusXRouteID = '".$va['BusXRouteID']."'","" );
							$getbus = $db->getOne( "bus", "*"," BusID= '".$getbusxroute['BusID']."'","" );
							
							$getDetail = $db->getOne( "invoicedetail", "*"," InvoiceDetailID = '".$va['InvoiceDetailID']."'","" );
							$getstatusproduct = $db->getOne("invoidestatus","*"," statusid='".$va['status']."'");
							$getstart = $db->getOne("deliverypoint","*",$where_lang." and DeliveryPointID='".$va['StartPoint']."'");
							$getend = $db->getOne("deliverypoint","*",$where_lang." and DeliveryPointID='".$va['EndPoint']."'");
							$getpoint = $db->getOne("deliverypoint","*",$where_lang." and DeliveryPointID='".$va['LastPoint']."'");
							$color = @$color=="#fff" ? "#E8E8E8" : "#fff";
						?>
                        <tr style="background:<?php echo $color;?>">
                            <td><?php echo $getDetail['ProductCode'];?></td>
                            <td><?php echo $va['detailName'];?></td>
                            <td><?php echo $va['DetailNameRe'];?></td>
                            <td><?php echo $getDetail['ProductName'];?></td>
                            <td><?php echo $getDetail['ProductDetail'];?></td>
                            <td><?php echo $getstart['DeliveryPointName'];?></td>
                            <td><?php echo $getend['DeliveryPointName'];?></td>
                            <td><?php echo $getpoint['DeliveryPointName'];?></td>
                            <td><?php echo $getbus['BusName'];?></td>
                            <td><?php echo $getstatusproduct['statusdesc'];?></td>
                            <!--<th><?php echo $va['comment'];?></a></th>-->
                        <tr>
                        <?php }
						}else{
						?>
						<tr>
							<th colspan="11" style="text-align:center"><?php echo $lang_set['not_data']; ?></th>
						<tr>
						<?php 
						}
						?>
                    </table>
            <?PHP }?>        
            </form>
            
        </div>
        <!-- End Tab Content id="add"-->
</div>