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

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



@$getreport = @$db->getJoin("*","better_hist a left outer join better_invoice b on a.InvoiceID = b.InvoiceID "
," a.status = '7' And b.InvoiceCreatePoint = '".@$setpoint."' and HistDatetime between '".@$objMaster->getdateformat(@$fromdate)." 00:00:00'and '".@$objMaster->getdateformat(@$fromdate)." 23:59:59'");

@$getpointname = @$db->getOne("deliverypoint","*","DeliveryPointID = '".@$setpoint."'");
//@$getData = @$getPage[0];
//echo "<pre>"; print_r(@$getreport);
//exit;
/** Error reporting */
//error_reporting(E_ALL);

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_miss.xls");

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

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

if(@$getreport){
foreach($getreport as $key => $va){
	
@$getproduct = @$db->getOne("invoicedetail","*","InvoiceDetailID = '".@$va['InvoiceDetailID']."'");
@$getstatus = @$db->getOne("invoidestatus","*","statusid = '".@$getproduct['status']."'");
@$getinvoice= @$db->getOne("invoice","*","InvoiceID = '".@$va['InvoiceID']."'");
@$getemp= @$db->getOne("admin","*","EmpID = '".@$getinvoice['InvoiceEmpID']."'");

@$getendpoint = @$db->getOne("deliverypoint","*","DeliveryPointID = '".@$getinvoice['InvoiceSetEndPoint']."'");
@$getmisspoint = @$db->getOne("deliverypoint","*","DeliveryPointID = '".@$va['LastPoint']."'");

@$getbusxroute = @$db->getOne("busxroute","*","BusXRouteID = '".@$va['BusXRouteID']."'");
@$getbusname = @$db->getOne("bus","*","BusID = '".@$getbusxroute['BusID']."'");
@$getroutexpoint = @$db->getOne("routexpoint","*","RouteID = '".@$getbusxroute['RouteID']."' and DeliveryPointID = '".@$setpoint."'");
@$gettime = @$db->gettest("SELECT ADDTIME( '".@$getbusxroute['SetDate']." ".@$getbusxroute['SetTime']."', '".@$getroutexpoint['PointTime']."' ) AS PointTime");	


if(@$getproduct['status'] == '4'){

@$getcomplatedate = @$db->getOne("hist","*","InvoiceDetailID = '".@$getproduct['InvoiceDetailID']."' And status = '4'");
@$time=dateDiv(@$getcomplatedate['HistDatetime'],@$gettime['PointTime']);
}else{
@$time=dateDiv(date("Y-m-d",time()),@$gettime['PointTime']);
}

@$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, @$getproduct['ProductCode']);
@$objPHPExcel->getActiveSheet()->setCellValue('C'.@$baserow, @$getproduct['ProductName']);
@$objPHPExcel->getActiveSheet()->setCellValue('D'.@$baserow, @$getbusname['BusName']);
@$objPHPExcel->getActiveSheet()->setCellValue('E'.@$baserow, @$getinvoice['InvoiceCode']);
@$objPHPExcel->getActiveSheet()->setCellValue('F'.@$baserow, @$getendpoint['DeliveryPointName']);
@$objPHPExcel->getActiveSheet()->setCellValue('G'.@$baserow, @$getmisspoint['DeliveryPointName']);
@$objPHPExcel->getActiveSheet()->setCellValue('H'.@$baserow, @$getstatus['statusdesc']);
@$objPHPExcel->getActiveSheet()->setCellValue('I'.@$baserow, @$time['D']." ".@$lang_set['day']." ".@$time['H']." ".@$lang_set['hour']);
@$objPHPExcel->getActiveSheet()->setCellValue('J'.@$baserow, @$getemp['EmpCode']);

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

//Set Color
//@$objPHPExcel->getActiveSheet()->getStyle('E'.(@$baserow+1))->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
//@$objPHPExcel->getActiveSheet()->getStyle('E'.(@$baserow+1))->getFill()->getStartColor()->setARGB('5c5cb3fc');

//@$objPHPExcel->getActiveSheet()->setCellValue('G'.(@$baserow+1), @$sumcount." ".@$lang_set['countnum']);

//@$objPHPExcel->getActiveSheet()->mergeCells('I'.(@$baserow+1).':J'.(@$baserow+1).'');
//@$objPHPExcel->getActiveSheet()->setCellValue('I'.(@$baserow+1), @$lang_set['sum_price']);
//@$objPHPExcel->getActiveSheet()->setCellValue('K'.(@$baserow+1), @$summoney." ".@$lang_set['bath']);
//echo date('H:i:s') . " Write to Excel5 format\n";
@$objWriter = PHPExcel_IOFactory::createWriter(@$objPHPExcel, 'Excel5');
@$objWriter->save("reportFile/report_miss.xls");
 
// Echo memory peak usage
//echo date('H:i:s') . " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB\r\n";

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