|
Server : Apache/2 System : Linux server1.tkcorporation.co.th 2.6.32-042stab145.3 #1 SMP Thu Jun 11 14:05:04 MSK 2020 i686 User : ifixit ( 537) PHP Version : 5.3.29 Disable Function : exec,system,passthru,shell_exec,escapeshellarg,escapeshellcmd,proc_close,proc_open,dl,popen,show_source Directory : /home/ifixit/public_html/assets/pdf/ |
<?php ob_start();session_start();
function remain_pay(){
include '../lib.php';conf();
require_once dirname(__FILE__) . '/PHPExcel.php';
date_default_timezone_set('Asia/Bangkok');
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set document properties
$objPHPExcel->getProperties()->setCreator("T-MAX DESIGN")
->setLastModifiedBy("Thanawat K.")
->setTitle("Remaining payment")
->setSubject("Remaining payment")
->setDescription("Remaining payment")
->setKeywords("Remaining payment")
->setCategory("Result file");
// Create a first sheet, representing sales data
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'ข้อมูลยอดขายประจำวัน');
$objPHPExcel->getActiveSheet()->setCellValue('A2', '#');
$objPHPExcel->getActiveSheet()->setCellValue('B2', 'BRANCH');
$objPHPExcel->getActiveSheet()->setCellValue('C2', 'ORDER ID');
$objPHPExcel->getActiveSheet()->setCellValue('D2', 'ประเภทงาน');
$objPHPExcel->getActiveSheet()->setCellValue('E2', 'ยอดขาย');
$objPHPExcel->getActiveSheet()->setCellValue('F2', 'ประเภทงาน');
$objPHPExcel->getActiveSheet()->setCellValue('G2', 'เก็บเงินแล้ว');
$objPHPExcel->getActiveSheet()->setCellValue('H2', 'ค้างชำระ');
$objPHPExcel->getActiveSheet()->setCellValue('I2', 'ตรม VN');
$objPHPExcel->getActiveSheet()->setCellValue('J2', 'ตรม STK');
$objPHPExcel->getActiveSheet()->setCellValue('K2', 'ชิ้น SIGN');
$objPHPExcel->getActiveSheet()->setCellValue('L2', 'แผ่น DP');
$objPHPExcel->getActiveSheet()->setCellValue('M2', 'ชิ้น(งานอื่นๆ)');
$objPHPExcel->getActiveSheet()->setCellValue('N2', 'ชื่อลูกค้า');
$objPHPExcel->getActiveSheet()->setCellValue('O2', 'เบอร์โทรลูกค้า');
//$objPHPExcel->getActiveSheet()->setCellValue('D1', PHPExcel_Shared_Date::PHPToExcel( gmmktime(0,0,0,date('m'),date('d'),date('Y')) ));
$objPHPExcel->getActiveSheet()->mergeCells('A1:O1');
$objPHPExcel->getActiveSheet()->getStyle('A1:O1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A1:O1')->getFill()->getStartColor()->setARGB('fff176');
$objPHPExcel->getActiveSheet()->getStyle('A2:O2')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A2:O2')->getFill()->getStartColor()->setARGB('ffb74d');
$styleThinBlackBorderOutline = array(
'borders' => array(
'allborders' => array(
'style' => PHPExcel_Style_Border::BORDER_THIN,
'color' => array('argb' => 'FF000000'),
),
),
);
$job_type = array();
$i=3;
if(isset($_REQUEST['br_id'])){
if($_REQUEST['br_id']>0 && $_REQUEST['br_id']!=999){
$branch = " and order_list.br_id = '".$_REQUEST['br_id']."'";
}else{
$branch = '';
}
}else{
if($_SESSION['br']>0 && $_SESSION['br']!=999){
$branch = " and order_list.br_id = '".$_SESSION['br']."'";
}else{
$branch = '';
}
}
//echo $_SESSION['br'];
if($_REQUEST['q']==1){
$filename = date('Ymd')."_".$_SESSION['br'];
$s="select * from order_temp
inner join order_type on order_temp.order_type_id = order_type.order_type_id
inner join order_list on order_temp.order_id = order_list.order_id
inner join acc_list on order_list.acc_id = acc_list.acc_id
inner join g_br on order_list.br_id = g_br.br_id
inner join job_main on order_temp.job_id = job_main.job_id
inner join order_status on order_list.order_status_id = order_status.order_status_id
where order_list.order_date like '".date('Y-m-d')."%' ".$branch."
order by order_list.order_id asc";
$s2="SELECT SUM(pay_total) AS total_pay,order_pay.pay_type_id,g_pay_type.pay_type_name FROM order_pay
INNER JOIN g_pay_type ON order_pay.pay_type_id = g_pay_type.pay_type_id
INNER JOIN order_list ON order_pay.order_id = order_list.order_id
WHERE pay_date LIKE '".date('Y-m-d')."%' ".$branch."
GROUP BY g_pay_type.pay_type_id";
}else if($_REQUEST['q']==2){
$time = strtotime(date('Y-m-d'));
$final = date("Ymd", strtotime("-1 month", $time));
$filename = $final."_".$_SESSION['br'];
$s="select * from order_temp
inner join order_type on order_temp.order_type_id = order_type.order_type_id
inner join order_list on order_temp.order_id = order_list.order_id
inner join acc_list on order_list.acc_id = acc_list.acc_id
inner join g_br on order_list.br_id = g_br.br_id
inner join job_main on order_temp.job_id = job_main.job_id
inner join order_status on order_list.order_status_id = order_status.order_status_id
where order_list.order_date > DATE_SUB(CURDATE(), INTERVAL 1 MONTH) ".$branch."
order by order_list.order_id asc";
$s2="SELECT SUM(pay_total) AS total_pay,order_pay.pay_type_id,g_pay_type.pay_type_name FROM order_pay
INNER JOIN g_pay_type ON order_pay.pay_type_id = g_pay_type.pay_type_id
INNER JOIN order_list ON order_pay.order_id = order_list.order_id
where order_pay.pay_date > DATE_SUB(CURDATE(), INTERVAL 1 MONTH) ".$branch."
GROUP BY g_pay_type.pay_type_id";
}else if($_REQUEST['q']==3){
$time = strtotime(date('Y-m-d'));
$final = date("Ymd", strtotime("-2 month", $time));
$filename = $final."_".$_SESSION['br'];
$s="select * from order_temp
inner join order_type on order_temp.order_type_id = order_type.order_type_id
inner join order_list on order_temp.order_id = order_list.order_id
inner join acc_list on order_list.acc_id = acc_list.acc_id
inner join g_br on order_list.br_id = g_br.br_id
inner join job_main on order_temp.job_id = job_main.job_id
inner join order_status on order_list.order_status_id = order_status.order_status_id
where order_list.order_date > DATE_SUB(CURDATE(), INTERVAL 2 MONTH) ".$branch."
order by order_list.order_id asc";
$s2="SELECT SUM(pay_total) AS total_pay,order_pay.pay_type_id,g_pay_type.pay_type_name FROM order_pay
INNER JOIN g_pay_type ON order_pay.pay_type_id = g_pay_type.pay_type_id
INNER JOIN order_list ON order_pay.order_id = order_list.order_id
where order_pay.pay_date > DATE_SUB(CURDATE(), INTERVAL 2 MONTH) ".$branch."
GROUP BY g_pay_type.pay_type_id";
}else if($_REQUEST['q']==4){
$time = strtotime(date('Y-m-d'));
$final = date("Ymd", strtotime("-12 month", $time));
$filename = $final."_".$_SESSION['br'];
$s="select * from order_temp
inner join order_type on order_temp.order_type_id = order_type.order_type_id
inner join order_list on order_temp.order_id = order_list.order_id
inner join acc_list on order_list.acc_id = acc_list.acc_id
inner join g_br on order_list.br_id = g_br.br_id
inner join job_main on order_temp.job_id = job_main.job_id
inner join order_status on order_list.order_status_id = order_status.order_status_id
where order_list.order_date > DATE_SUB(CURDATE(), INTERVAL 12 MONTH) ".$branch."
order by order_list.order_id asc";
$s2="SELECT SUM(pay_total) AS total_pay,order_pay.pay_type_id,g_pay_type.pay_type_name FROM order_pay
INNER JOIN g_pay_type ON order_pay.pay_type_id = g_pay_type.pay_type_id
INNER JOIN order_list ON order_pay.order_id = order_list.order_id
where order_pay.pay_date > DATE_SUB(CURDATE(), INTERVAL 12 MONTH) ".$branch."
GROUP BY g_pay_type.pay_type_id";
}else if($_REQUEST['q']==5){
$filename = str_replace("-","",$_REQUEST['st_date'])."_".$_SESSION['br'];
$s="select * from order_temp
inner join order_type on order_temp.order_type_id = order_type.order_type_id
inner join order_list on order_temp.order_id = order_list.order_id
inner join acc_list on order_list.acc_id = acc_list.acc_id
inner join g_br on order_list.br_id = g_br.br_id
inner join job_main on order_temp.job_id = job_main.job_id
inner join order_status on order_list.order_status_id = order_status.order_status_id
where (order_list.order_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59') ".$branch."
order by order_list.order_id asc";
$s2="SELECT SUM(pay_total) AS total_pay,order_pay.pay_type_id,g_pay_type.pay_type_name FROM order_pay
INNER JOIN g_pay_type ON order_pay.pay_type_id = g_pay_type.pay_type_id
INNER JOIN order_list ON order_pay.order_id = order_list.order_id
where (order_pay.pay_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59') ".$branch."
GROUP BY g_pay_type.pay_type_id";
}else if($_REQUEST['q']==6){
$filename = date('Ymd')."_REPORT";
$s="select * from order_temp
inner join order_type on order_temp.order_type_id = order_type.order_type_id
inner join order_list on order_temp.order_id = order_list.order_id
inner join acc_list on order_list.acc_id = acc_list.acc_id
inner join g_br on order_list.br_id = g_br.br_id
inner join job_main on order_temp.job_id = job_main.job_id
inner join order_status on order_list.order_status_id = order_status.order_status_id".$branch."
where order_list.order_date like '".date('Y-m-d')."%'
order by order_list.order_id asc";
$s2="SELECT SUM(pay_total) AS total_pay,order_pay.pay_type_id,g_pay_type.pay_type_name FROM order_pay
INNER JOIN g_pay_type ON order_pay.pay_type_id = g_pay_type.pay_type_id
INNER JOIN order_list ON order_pay.order_id = order_list.order_id
where order_pay.pay_date like '".date('Y-m-d')."%'
GROUP BY g_pay_type.pay_type_id";
}else if($_REQUEST['q']==7){
$filename = str_replace("-","",$_REQUEST['st_date'])."_REPORT";
$s="select * from order_temp
inner join order_type on order_temp.order_type_id = order_type.order_type_id
inner join order_list on order_temp.order_id = order_list.order_id
inner join acc_list on order_list.acc_id = acc_list.acc_id
inner join g_br on order_list.br_id = g_br.br_id
inner join job_main on order_temp.job_id = job_main.job_id
inner join order_status on order_list.order_status_id = order_status.order_status_id".$branch."
where (order_list.order_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59')
order by order_list.order_id asc";
$s2="SELECT SUM(pay_total) AS total_pay,order_pay.pay_type_id,g_pay_type.pay_type_name FROM order_pay
INNER JOIN g_pay_type ON order_pay.pay_type_id = g_pay_type.pay_type_id
INNER JOIN order_list ON order_pay.order_id = order_list.order_id
where (order_pay.pay_date BETWEEN '".$_REQUEST['st_date']." 00:00:00' AND '".$_REQUEST['fn_date']." 23:59:59') ".$branch."
GROUP BY g_pay_type.pay_type_id";
}
$pay_id = array();
$q2=mysql_query($s2);
while($f2=mysql_fetch_array($q2)){
$pay_id[$f2['pay_type_id']]=$f2['total_pay'];
$pay_id[0] += $pay_id[$f2['pay_type_id']];
}
$q=mysql_query($s);
while($f=mysql_fetch_array($q)){
$s1="select sum(pay_total) as total_pay from order_pay where order_id = '".$f['order_id']."'";
$q1=mysql_query($s1);
if($f1=mysql_fetch_array($q1)){
$pay_total = $f1['total_pay'];
}
$j=$i-2;
$remain = $f['p3']-$pay_total;
if($f['job_id']== 1){//VN
$area = $f['h']*$f['w']*$f['qty'];
$area_stk = '';
$item = '';
$item_dp = '';
$item_other = '';
}else if($f['job_id']== 3){//VN STK
$area = '';
$area_stk = $f['h']*$f['w']*$f['qty'];
$item = '';
$item_dp = '';
$item_other = '';
}else if($f['job_id']== 2 || $f['job_id']== 6 || $f['job_id']== 7 || $f['job_id']== 8 || $f['job_id']== 9 || $f['job_id']== 10 || $f['job_id']== 11 || $f['job_id']== 12){//SIGN
$area = '';
$area_stk = '';
$item = $f['qty'];
$item_dp = '';
$item_other = '';
}else if($f['job_id']== 4 || $f['job_id']== 5){//DP
$area = '';
$area_stk = '';
$item = '';
$item_dp = $f['qty'];
$item_other = '';
}else{ // Other 13>N
$area = '';
$area_stk = '';
$item = '';
$item_dp = '';
$item_other = $f['qty'];
$f['job_name'] = $f['job_name']." - ".$f['rmark'];
}
if($f['order_type_id']>1){
$f['price_total'] = '';
}
$job_type['J'.$f['job_id']]['job']++;
$job_type['J'.$f['job_id']]['rev']+=$f['price_total'];
$job_type['J'.$f['job_id']]['area']+=$area;
$job_type['J'.$f['job_id']]['area_stk']+=$area_stk;
$job_type['J'.$f['job_id']]['item']+=$item;
$job_type['J'.$f['job_id']]['item_dp']+=$item_dp;
$job_type['J'.$f['job_id']]['item_other']+=$item_other;
$job_type['all']['rev']+=$f['price_total'];
$job_type['all']['area']+=$area;
$job_type['all']['area_stk']+=$area_stk;
$job_type['all']['item']+=$item;
$job_type['all']['item_dp']+=$item_dp;
$job_type['all']['item_other']+=$item_other;
$t_start = strtotime($f['order_date']);
$t_end = strtotime($f['order_dlv_r']);
$diff = $t_end - $t_start;
$hours = floor($diff / (60 * 60));
$minutes = $diff - $hours * (60 * 60);
if($hours >0){
$job_type['J'.$f['job_id']]['job_late']++;
}
if($order_id == $f['order_id']){
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $j);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $f['br_name']);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, '');
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $f['order_type_name']);
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $f['price_total']);
$objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $f['job_name']);
$objPHPExcel->getActiveSheet()->setCellValue('G'.$i, '');
$objPHPExcel->getActiveSheet()->setCellValue('H'.$i, '');
$objPHPExcel->getActiveSheet()->setCellValue('I'.$i, $area);
$objPHPExcel->getActiveSheet()->setCellValue('J'.$i, $area_stk);
$objPHPExcel->getActiveSheet()->setCellValue('K'.$i, $item);
$objPHPExcel->getActiveSheet()->setCellValue('L'.$i, $item_dp);
$objPHPExcel->getActiveSheet()->setCellValue('M'.$i, $item_other);
$objPHPExcel->getActiveSheet()->setCellValue('N'.$i, '');
$objPHPExcel->getActiveSheet()->setCellValue('O'.$i, '');
}else{
$job_type['J'.$f['job_id']]['rev_pay']+=$pay_total;
$job_type['J'.$f['job_id']]['remain_pay']+=$remain;
$job_type['all']['rev_pay']+=$pay_total;
$job_type['all']['remain_pay']+=$remain;
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $j);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $f['br_name']);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $f['order_id']);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $f['order_type_name']);
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $f['price_total']);
$objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $f['job_name']);
$objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $pay_total);
$objPHPExcel->getActiveSheet()->setCellValue('H'.$i, $remain);
$objPHPExcel->getActiveSheet()->setCellValue('I'.$i, $area);
$objPHPExcel->getActiveSheet()->setCellValue('J'.$i, $area_stk);
$objPHPExcel->getActiveSheet()->setCellValue('K'.$i, $item);
$objPHPExcel->getActiveSheet()->setCellValue('L'.$i, $item_dp);
$objPHPExcel->getActiveSheet()->setCellValue('M'.$i, $item_other);
$objPHPExcel->getActiveSheet()->setCellValue('N'.$i, $f['acc_name']);
$objPHPExcel->getActiveSheet()->setCellValue('O'.$i, $f['acc_tel']);
}
$order_id = $f['order_id'];
$i++;
}
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, 'ยอดรวม');
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, '');
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, '');
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, '');
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $job_type['all']['rev']);
$objPHPExcel->getActiveSheet()->setCellValue('F'.$i, '');
$objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $job_type['all']['rev_pay']);
$objPHPExcel->getActiveSheet()->setCellValue('H'.$i, $job_type['all']['remain_pay']);
$objPHPExcel->getActiveSheet()->setCellValue('I'.$i, $job_type['all']['area']);
$objPHPExcel->getActiveSheet()->setCellValue('J'.$i, $job_type['all']['area_stk']);
$objPHPExcel->getActiveSheet()->setCellValue('K'.$i, $job_type['all']['item']);
$objPHPExcel->getActiveSheet()->setCellValue('L'.$i, $job_type['all']['item_dp']);
$objPHPExcel->getActiveSheet()->setCellValue('M'.$i, $job_type['all']['item_other']);
$objPHPExcel->getActiveSheet()->setCellValue('N'.$i, '');
$objPHPExcel->getActiveSheet()->setCellValue('O'.$i, '');
$objPHPExcel->getActiveSheet()->getStyle('A1:O'.$i)->applyFromArray($styleThinBlackBorderOutline);
$objPHPExcel->getActiveSheet()->getStyle('A'.$i.':O'.$i)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A'.$i.':O'.$i)->getFill()->getStartColor()->setARGB('d50000');
$objPHPExcel->getActiveSheet()->getStyle('A'.$i.':O'.$i)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->mergeCells('A'.$i.':D'.$i);
$objPHPExcel->getActiveSheet()->getStyle('E3:M'.$i)->getNumberFormat()->setFormatCode('#,##0.00');
$i+=3;
$start = $i;
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, '#');
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, 'ประเภทงาน');
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, 'งานทั้งหมด');
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, 'ยอดขาย บาท');
$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, 'ค้างชำระ บาท');
$objPHPExcel->getActiveSheet()->setCellValue('F'.$i, 'ตรม VN');
$objPHPExcel->getActiveSheet()->setCellValue('G'.$i, 'ตรม STK');
$objPHPExcel->getActiveSheet()->setCellValue('H'.$i, 'ชิ้น SIGN');
$objPHPExcel->getActiveSheet()->setCellValue('I'.$i, 'แผ่น DP');
$objPHPExcel->getActiveSheet()->setCellValue('J'.$i, 'ชิ้น (อื่นๆ)');
$objPHPExcel->getActiveSheet()->setCellValue('K'.$i, 'ค่าเฉลี่ย');
$objPHPExcel->getActiveSheet()->setCellValue('L'.$i, 'ส่งงานช้า');
$objPHPExcel->getActiveSheet()->getStyle('A'.$i.':L'.$i)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A'.$i.':L'.$i)->getFill()->getStartColor()->setARGB('42a5f5');
$x=$i;
$objPHPExcel->getActiveSheet()->setCellValue('N'.$x, 'ยอดเก็บเงินวันนี้');
$x++;
$objPHPExcel->getActiveSheet()->setCellValue('N'.$x, 'เงินสด');
$objPHPExcel->getActiveSheet()->setCellValue('O'.$x, $pay_id[1]);
$x++;
$objPHPExcel->getActiveSheet()->setCellValue('N'.$x, 'โอนเงิน');
$objPHPExcel->getActiveSheet()->setCellValue('O'.$x, $pay_id[2]);
$x++;
$objPHPExcel->getActiveSheet()->setCellValue('N'.$x, 'เช็ค');
$objPHPExcel->getActiveSheet()->setCellValue('O'.$x, $pay_id[3]);
$x++;
$objPHPExcel->getActiveSheet()->setCellValue('N'.$x, 'รวม');
$objPHPExcel->getActiveSheet()->setCellValue('O'.$x, $pay_id[0]);
$objPHPExcel->getActiveSheet()->getStyle('N'.$i.':N'.$x)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('N'.$i.':N'.$x)->getFill()->getStartColor()->setARGB('c8e6c9');
$objPHPExcel->getActiveSheet()->getStyle('N'.$i.':O'.$x)->applyFromArray($styleThinBlackBorderOutline);
$objPHPExcel->getActiveSheet()->getStyle('O'.$i.':O'.$x)->getNumberFormat()->setFormatCode('#,##0.00');
$i++;
$j=1;
$s="select * from job_main order by job_id asc";
$q=mysql_query($s);
while($f=mysql_fetch_array($q)){
if($job_type['J'.$f['job_id']]['area']>0){
$avg = $job_type['J'.$f['job_id']]['rev']/$job_type['J'.$f['job_id']]['area'];
}else if($job_type['J'.$f['job_id']]['area_stk']>0){
$avg = $job_type['J'.$f['job_id']]['rev']/$job_type['J'.$f['job_id']]['area_stk'];
}else if($job_type['J'.$f['job_id']]['item']>0){
$avg = $job_type['J'.$f['job_id']]['rev']/$job_type['J'.$f['job_id']]['item'];
}else if($job_type['J'.$f['job_id']]['item_dp']>0){
$avg = $job_type['J'.$f['job_id']]['rev']/$job_type['J'.$f['job_id']]['item_dp'];
}else if($job_type['J'.$f['job_id']]['item_other']>0){
$avg = $job_type['J'.$f['job_id']]['rev']/$job_type['J'.$f['job_id']]['item_other'];
}else{
$avg = '';
}
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $j);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $f['job_name']);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $job_type['J'.$f['job_id']]['job']);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $job_type['J'.$f['job_id']]['rev']);
$objPHPExcel->getActiveSheet()->setCellValue('e'.$i, $job_type['J'.$f['job_id']]['remain_pay']);
$objPHPExcel->getActiveSheet()->setCellValue('f'.$i, $job_type['J'.$f['job_id']]['area']);
$objPHPExcel->getActiveSheet()->setCellValue('g'.$i, $job_type['J'.$f['job_id']]['area_stk']);
$objPHPExcel->getActiveSheet()->setCellValue('h'.$i, $job_type['J'.$f['job_id']]['item']);
$objPHPExcel->getActiveSheet()->setCellValue('i'.$i, $job_type['J'.$f['job_id']]['item_dp']);
$objPHPExcel->getActiveSheet()->setCellValue('j'.$i, $job_type['J'.$f['job_id']]['item_other']);
$objPHPExcel->getActiveSheet()->setCellValue('k'.$i, $avg);
$objPHPExcel->getActiveSheet()->setCellValue('l'.$i, $job_type['J'.$f['job_id']]['job_late']);
$objPHPExcel->getActiveSheet()->getStyle('A'.$i.':l'.$i)->getNumberFormat()->setFormatCode('#,##0.00');
$i++;
$j++;
}
$i--;
$objPHPExcel->getActiveSheet()->getStyle('A'.$start.':B'.$i)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A'.$start.':B'.$i)->getFill()->getStartColor()->setARGB('81d4fa');
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setName('Browallia New');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(18);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLACK);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A'.$start.':l'.$i)->applyFromArray($styleThinBlackBorderOutline);
require_once dirname(__FILE__) . '/PHPExcel/IOFactory.php';
$callStartTime = microtime(true);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
//$objWriter->save(str_replace('.php', '.xlsx', __FILE__));
$objWriter->save("output/".$filename.'.xlsx');
$callEndTime = microtime(true);
$callTime = $callEndTime - $callStartTime;
$filepath = "output/".$filename.'.xlsx';
if(file_exists($filepath)) {
header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename="'.basename($filepath).'"');
header('Content-Transfer-Encoding: binary');
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
header('Content-Length: ' . filesize($filepath));
ob_clean();
flush(); // Flush system output buffer
readfile($filepath);
exit;
}else{
echo 'b';
}
}
remain_pay();
?>