<?php 
@$where_lang = " lang_code = '".@$lang_code."'";

if(@$_POST['Fromdate']){@$fromdate = @$_POST['Fromdate'];}
if(@$_POST['DeliveryPointID']){@$setpoint = @$_POST['DeliveryPointID'];}

//$r = @$objMaster->getdateformat(@$fromdate);

/**nui เพิ่ม  **/
	@$setpoint = str_replace("'", "\'", @$setpoint); 
	@$where_f = "  a.LastPoint = '".@$setpoint."' ";
/**nui เพิ่ม  **/
/* ของเก่า 
@$getreport = @$db->getAll("hist","*"," LastPoint = '".@$setpoint."' and status = '9' and HistDatetime >='".@$objMaster->getdateformat(@$fromdate)." 00:00:00' and HistDatetime <= '".@$objMaster->getdateformat(@$fromdate)." 23:59:59'","");
*/

@$getreport = @$db->getJoin("*","`better_invoicedetail` a
LEFT OUTER JOIN `better_invoice` b ON a.InvoiceID = b.InvoiceID",@$where_f." And (a.status = 1 or a.status = 7) And b.InvoiceDate = 
'".@$objMaster->getdateformat(@$fromdate)."' ","order by InvoiceDetailID");


@$getpointname = @$db->getOne("deliverypoint","*","DeliveryPointID = '".@$setpoint."'");


date_default_timezone_set('Asia/Bangkok');

/** PHPExcel_IOFactory */
require_once 'textexcel/Classes/PHPExcel/IOFactory.php';
 

//echo date('H:i:s') . " Load from Excel5 template\n";
@$objReader = PHPExcel_IOFactory::createReader('Excel5'); 
@$objPHPExcel = @$objReader->load("textexcel/templates/report_late.xls");

@$objPHPExcel->getActiveSheet()->setCellValue('H1', @$objMaster->getdbdateformat(date("Y-m-d")));
@$objPHPExcel->getActiveSheet()->setCellValue('D5', @$getpointname['DeliveryPointName']);
@$objPHPExcel->getActiveSheet()->setCellValue('F5', @$fromdate);

@$i = 1;
@$baserow = 8;

if(@$getreport){
	

foreach(@$getreport as $key => $va){
	// เพิ่มการคิวรี่  by nui
			@$getlastpoint = @$db->getOne("deliverypoint","*",@$where_lang." and DeliveryPointID='".@$va['LastPoint']."'");
			@$getendpoint = @$db->getOne("deliverypoint","*",@$where_lang." and DeliveryPointID='".@$va['InvoiceEndPoint']."'");
			@$getstatus = @$db->getOne("invoidestatus","*"," statusid='".@$va['status']."'");
	
@$getinvoice= @$db->getOne("invoice","*","InvoiceID = '".@$va['InvoiceID']."'");
//@$getemp= @$db->getOne("admin","*","EmpID = '".@$getinvoice['InvoiceEmpID']."'");
@$getemp= @$db->getOne("admin","*","EmpID = '".@$va['InvoiceEmpID']."'");
//@$getendpoint = @$db->getOne("deliverypoint","*","DeliveryPointID = '".@$getinvoice['InvoiceSetEndPoint']."'");
@$objPHPExcel->getActiveSheet()->insertNewRowBefore((@$baserow+1),1); 
//@$objPHPExcel->getActiveSheet()->mergeCells('A'.@$baserow.':B'.@$baserow.'');
@$objPHPExcel->getActiveSheet()->setCellValue('A'.@$baserow, @$i);
//@$objPHPExcel->getActiveSheet()->mergeCells('B'.@$baserow.':C'.@$baserow.'');
@$objPHPExcel->getActiveSheet()->setCellValue('B'.@$baserow, @$va['ProductCode']);
//@$objPHPExcel->getActiveSheet()->setCellValue('B'.@$baserow, @$getproduct['ProductCode']);
@$objPHPExcel->getActiveSheet()->setCellValue('C'.@$baserow, @$va['ProductDetail']);
//ของเก่า@$objPHPExcel->getActiveSheet()->setCellValue('C'.@$baserow, @$getproduct['ProductName']);
//@$objPHPExcel->getActiveSheet()->setCellValue('D'.@$baserow, @$getinvoice['InvoiceCode']);
@$objPHPExcel->getActiveSheet()->setCellValue('D'.@$baserow, @$va['InvoiceCode']);
//ของเก่า @$objPHPExcel->getActiveSheet()->setCellValue('D'.@$baserow, @$getinvoice['InvoiceCode']);
@$objPHPExcel->getActiveSheet()->setCellValue('E'.@$baserow, @$getendpoint['DeliveryPointName']);
//@$objPHPExcel->getActiveSheet()->setCellValue('F'.@$baserow, @$va['InvoiceDate']);
@$objPHPExcel->getActiveSheet()->setCellValue('F'.@$baserow, @$objMaster->getdbdateformat_barcode(@$va['InvoiceDate']));
@$objPHPExcel->getActiveSheet()->setCellValue('G'.@$baserow, @$va['InvoiceTime']);
//ของเก่า@$objPHPExcel->getActiveSheet()->setCellValue('F'.@$baserow, @$getinvoice['InvoiceTime']);
@$objPHPExcel->getActiveSheet()->setCellValue('H'.@$baserow, @$getstatus['statusdesc']);
@$objPHPExcel->getActiveSheet()->setCellValue('I'.@$baserow, @$getemp['EmpCode']);

@$baserow++;
@$i++;
}
}
@$objPHPExcel->getActiveSheet()->removeRow(@$baserow,1); 

@$objWriter = PHPExcel_IOFactory::createWriter(@$objPHPExcel, 'Excel5');
@$objWriter->save("reportFile/report_late.xls");

?>
<meta http-equiv="refresh" content="0;URL=<?php echo  URL;?>administrator/reportFile/report_late.xls">
<?PHP echo "<script>t = 3*1000;
			setTimeout('window.close()',t); 
			</script>";?>