<?php 
ob_start();
session_start();
require_once("../conn/conn.php");
//include('../utility/chksession.php');
?>
<!DOCTYPE html>
<html lang="en">
	<head>
		<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
		<meta charset="utf-8" />
		<title>Nortern Production - Admin</title>

		<meta name="description" content="" />
		<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" />

		<!-- bootstrap & fontawesome -->
		<link rel="stylesheet" href="../assets/css/bootstrap.min.css" />
		<link rel="stylesheet" href="../assets/font-awesome/4.5.0/css/font-awesome.min.css" />

		<!-- page specific plugin styles -->

		<!-- text fonts -->
		<link rel="stylesheet" href="../assets/css/fonts.googleapis.com.css" />

		<!-- ace styles -->
		<link rel="stylesheet" href="../assets/css/ace.min.css" class="ace-main-stylesheet" id="main-ace-style" />

		<!--[if lte IE 9]>
			<link rel="stylesheet" href="assets/css/ace-part2.min.css" class="ace-main-stylesheet" />
		<![endif]-->
		<link rel="stylesheet" href="../assets/css/ace-skins.min.css" />
		<link rel="stylesheet" href="../assets/css/ace-rtl.min.css" />

		<!--[if lte IE 9]>
		  <link rel="stylesheet" href="assets/css/ace-ie.min.css" />
		<![endif]-->

		<!-- inline styles related to this page -->

		<!-- ace settings handler -->
		<script src="../assets/js/ace-extra.min.js"></script>

		<!-- HTML5shiv and Respond.js for IE8 to support HTML5 elements and media queries -->

		<!--[if lte IE 8]>
		<script src="assets/js/html5shiv.min.js"></script>
		<script src="assets/js/respond.min.js"></script>
		<![endif]-->
	</head>

	<body class="no-skin">
		
		<div class="main-container ace-save-state" id="main-container">
			<script type="text/javascript">
				try{ace.settings.loadState('main-container')}catch(e){}
			</script>


			<div class="main-content">
				<div class="main-content-inner">
					
					<div class="page-content">
						<!-- /.ace-settings-container -->

						<div class="row">
							<div class="col-xs-12">
								<!-- PAGE CONTENT BEGINS -->
								<div class="space-6"></div>

								<div class="row">
									<div class="col-sm-10 col-sm-offset-1">
										<div class="widget-box transparent">
											<div class="widget-header widget-header-large">
												<h3 class="widget-title grey lighter">รายงาน Order</h3>

												<div class="widget-toolbar no-border invoice-info"></div>

											
											</div>

											<div class="widget-body">
											  <?php
											  
											  $Cli_date1 = $_REQUEST['Cli_date1'];
											  $Cli_date2 = $_REQUEST['Cli_date2'];


$strSQL = "SELECT * FROM `pd_po` WHERE `order_date` BETWEEN '$Cli_date1' AND '$Cli_date2'";
$objQuery = mysqli_query($con,$strSQL);  
$i=1;




echo "ข้อมูล วันที่ ";
$aaa = new DateTime($Cli_date1); 
echo $aaa->format('d-m-Y');
echo " - ";
$bbb = new DateTime($Cli_date2); 
echo $bbb->format('d-m-Y');
?>
											  <table width="100%" class="table table-striped table-bordered table-hover" id="dynamic-table">
											    <thead>
					<tr>
					<th width='3%' bgcolor="#E0E0E0" class="center">ลำดับ</th>
					<th width="24%" bgcolor="#E0E0E0" class="center">รายการ Order</th>
					<th width="4%" bgcolor="#E0E0E0" class="center">จำนวน</th>
					<th width="8%" bgcolor="#E0E0E0" class="center">POอ้างอิง</th>
					<th width='8%' bgcolor="#E0E0E0" class="center">วันที่รับPO</th>
					<th width='8%' bgcolor="#E0E0E0" class="center">วันที่คอนเฟิร์มแบบ</th>
					<th width='8%' bgcolor="#E0E0E0" class="center">วันที่กำหนดเสร็จ</th>
					<th width='8%' bgcolor="#E0E0E0" class="center">วันที่ส่ง</th>
					<th width='5%' bgcolor="#E0E0E0" class="center">ส่งบริษัท</th>
					<th width='8%' bgcolor="#E0E0E0" class="center">สถานะ</th>
					<th width='6%' bgcolor="#E0E0E0" class="center">ผู้ตรวจสอบ</th>
					<th width='10%' bgcolor="#E0E0E0" class="center">หมายเหตุ</th>
					</tr>
                   </thead>     				<?php
while($objResult = mysqli_fetch_array($objQuery)){
    
   
?>
	<tbody>	
					<tr>
					  <td align="center"><?=$i++; ?></td>
					  <td ><?=$objResult['remark']; ?></td>
					  <td align="center"><?=$objResult['qty']." ".$objResult['unit'];; ?></td>
					  <td align="center"><?=$objResult['no_po']; ?></td>
					  <td align="center"><?php  $order_date = new DateTime($objResult['order_date']); 
     echo $order_date->format('d-m-Y'); ?></td>
					  <td align="center"><?php  
					  
					  if($objResult['comfirm_date']=='0000-00-00'){
						  echo "";
					  }else{
						  
						 $order_date = new DateTime($objResult['comfirm_date']); 
     					echo $order_date->format('d-m-Y');  
					  }
					  
					  ?></td>
					  <td align="center"><?php  
					  
					  
					  if($objResult['complete_date']=='0000-00-00'){
						  echo "";
					  }else{
						  
						 	$order_date = new DateTime($objResult['complete_date']); 
    						echo $order_date->format('d-m-Y');  
					  }
					  
					   ?></td>
					  <td align="center"><?php $delivery_date = new DateTime($objResult['delivery_date']); 
     echo $delivery_date->format('d-m-Y'); ?></td>
					  <td align="center"><?=$objResult['id_name']; ?></td>

					  <td align="center"><?php 
					  if($objResult['po_status']=='ดำเนินการเรียบร้อย'){
						  echo $objResult['po_status'];
					  }else{
						 ?><font color="#FF0000"><?php echo $objResult['po_status'];?></font><?php
						  
					  }
					  
					   ?></td>
					  <td ><?=$objResult['po_checker']; ?></td>
					  <td ><?=$objResult['po_comment']; ?></td>
					  </tr>
				
			   <?
			   
}?>
				
				</tbody>
			   
			</table>
														
										  </div>
									  </div>
											</div>
										</div>
									</div>
								</div>

								<!-- PAGE CONTENT ENDS -->
							</div><!-- /.col -->
						</div><!-- /.row -->
					</div><!-- /.page-content -->
				</div>
			</div><!-- /.main-content -->


			<a href="#" id="btn-scroll-up" class="btn-scroll-up btn btn-sm btn-inverse">
				<i class="ace-icon fa fa-angle-double-up icon-only bigger-110"></i>
			</a>
		</div><!-- /.main-container -->

		<!-- basic scripts -->

		<!--[if !IE]> -->
		<script src="../assets/js/jquery-2.1.4.min.js"></script>

		<!-- <![endif]-->

		<!--[if IE]>
<script src="assets/js/jquery-1.11.3.min.js"></script>
<![endif]-->
		<script type="text/javascript">
			if('ontouchstart' in document.documentElement) document.write("<script src='assets/js/jquery.mobile.custom.min.js'>"+"<"+"/script>");
		</script>
		<script src="../assets/js/bootstrap.min.js"></script>

		<!-- page specific plugin scripts -->

		<!-- ace scripts -->
		<script src="../assets/js/ace-elements.min.js"></script>
		<script src="../assets/js/ace.min.js"></script>

		<!-- inline scripts related to this page -->
	</body>
</html>
