<?php
include
'
global
.php';
$ids
=
$_GET
['ids'];
$sql
=
"select * from crm_cost_end where id in ( {$ids} )"
;
$result
=
$db
->findAll(
$sql
);
$objPHPExcel
=
new
PHPExcel();
$objPHPExcel
->getProperties()->setCreator(
"ctos"
)
->setLastModifiedBy(
"ctos"
)
->setTitle(
"Office 2007 XLSX Test Document"
)
->setSubject(
"Office 2007 XLSX Test Document"
)
->setDescription(
"Test document for Office 2007 XLSX, generated using PHP classes."
)
->setKeywords(
"office 2007 openxml php"
)
->setCategory(
"Test result file"
);
$objPHPExcel
->getActiveSheet()->getColumnDimension('A')->setWidth(8);
$objPHPExcel
->getActiveSheet()->getColumnDimension('B')->setWidth(10);
$objPHPExcel
->getActiveSheet()->getColumnDimension('C')->setWidth(25);
$objPHPExcel
->getActiveSheet()->getColumnDimension('D')->setWidth(12);
$objPHPExcel
->getActiveSheet()->getColumnDimension('E')->setWidth(50);
$objPHPExcel
->getActiveSheet()->getColumnDimension('F')->setWidth(10);
$objPHPExcel
->getActiveSheet()->getColumnDimension('G')->setWidth(12);
$objPHPExcel
->getActiveSheet()->getColumnDimension('H')->setWidth(12);
$objPHPExcel
->getActiveSheet()->getColumnDimension('I')->setWidth(12);
$objPHPExcel
->getActiveSheet()->getColumnDimension('J')->setWidth(30);
$objPHPExcel
->getActiveSheet()->getRowDimension('1')->setRowHeight(22);
$objPHPExcel
->getActiveSheet()->getRowDimension('2')->setRowHeight(20);
$objPHPExcel
->getActiveSheet()->getDefaultStyle()->getFont()->setSize(10);
$objPHPExcel
->getActiveSheet()->getStyle('A2:J2')->getFont()->setBold(true);
$objPHPExcel
->getActiveSheet()->getStyle('A2:J2')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel
->getActiveSheet()->getStyle('A2:J2')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel
->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel
->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->getActiveSheet()->getStyle('H')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->getActiveSheet()->getStyle('I')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->getActiveSheet()->mergeCells('A1:J1');
$objPHPExcel
->setActiveSheetIndex(0)
->setCellValue('A1', '订单数据汇总 时间:' .
date
('Y-m-d H:i:s'))
->setCellValue('A2', '订单ID')
->setCellValue('B2', '下单人')
->setCellValue('C2', '客户名称')
->setCellValue('D2', '下单时间')
->setCellValue('E2', '需求机型')
->setCellValue('F2', '需求数量')
->setCellValue('G2', '需求交期')
->setCellValue('H2', '确认BOM料号')
->setCellValue('I2', 'PMC确认交期')
->setCellValue('J2', 'PMC交货备注');
for
(
$i
= 0;
$i
<
count
(
$result
) - 1;
$i
++) {
$objPHPExcel
->getActiveSheet(0)->setCellValue('A' . (
$i
+ 3),
$result
[
$i
]['id']);
$objPHPExcel
->getActiveSheet(0)->setCellValue('B' . (
$i
+ 3),
$result
[
$i
]['realname']);
$objPHPExcel
->getActiveSheet(0)->setCellValue('C' . (
$i
+ 3),
$result
[
$i
]['customer_name']);
$objPHPExcel
->getActiveSheet(0)->setCellValue('D' . (
$i
+ 3),
$OrdersData
[
$i
]['create_time']);
$objPHPExcel
->getActiveSheet(0)->setCellValue('E' . (
$i
+ 3),
$result
[
$i
]['require_product']);
$objPHPExcel
->getActiveSheet(0)->setCellValue('F' . (
$i
+ 3),
$result
[
$i
]['require_count']);
$objPHPExcel
->getActiveSheet(0)->setCellValue('G' . (
$i
+ 3),
$result
[
$i
]['require_time']);
$objPHPExcel
->getActiveSheet(0)->setCellValue('H' . (
$i
+ 3),
$result
[
$i
]['product_bom_encoding']);
$objPHPExcel
->getActiveSheet(0)->setCellValue('I' . (
$i
+ 3),
$result
[
$i
]['delivery_time']);
$objPHPExcel
->getActiveSheet(0)->setCellValue('J' . (
$i
+ 3),
$result
[
$i
]['delivery_memo']);
$objPHPExcel
->getActiveSheet()->getStyle('A' . (
$i
+ 3) . ':J' . (
$i
+ 3))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel
->getActiveSheet()->getStyle('A' . (
$i
+ 3) . ':J' . (
$i
+ 3))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel
->getActiveSheet()->getRowDimension(
$i
+ 3)->setRowHeight(16);
}
$objPHPExcel
->getActiveSheet()->setTitle('订单汇总表');
$objPHPExcel
->setActiveSheetIndex(0);
<span style=
"color:#ff0000;"
>ob_end_clean();
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename=
"订单汇总表(' . date('Ymd-His') . ').xls"
');
header('Cache-Control: max-age=0');
$objWriter
= PHPExcel_IOFactory::createWriter(
$objPHPExcel
, 'Excel5');
$objWriter
->save('php:
?>