<?php
class ControllerFormForm{
//导出excel
public function export(){
require_once '../phpexcel/PHPExcel.php';
$this->load->model('form/form');
$export_date = $this->request->get['export_date_added'];
if($export_date){
$lists = $this->model_form_form->getFormByDate($export_date);
// 创建Excel文件对象
$objPHPExcel = new PHPExcel();
//根据excel坐标，添加数据
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', 'Globalcash Card No. 全球付卡號')
->setCellValue('B1', "Cardholder's English Name 持卡人英文姓名/拼音")
->setCellValue('C1', "Cardholder's Chinese Name 持卡人中文姓名")
->setCellValue('D1', "Tel. Country code电话國家區號")
->setCellValue('E1', "Mobile No.手提電話號碼")
->setCellValue('F1', "Address 地址")
->setCellValue('G1', "Type of the certificate 證件類型")
->setCellValue('H1', "Certificate No. 證件號碼")
->setCellValue('I1', "Date of Issue 證件有效期起")
->setCellValue('J1', "Date of expiry 證件有效期止")
->setCellValue('K1', "Referrer 推薦人")
->setCellValue('L1', "Nationality 國籍")
->setCellValue('M1', "CDD Caegory 實名狀態")
->setCellValue('N1', "Notes 備註")
->setCellValue('O1', "Date of birth 出生日期");
//设置保存版本格式
if($excel2007){
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$filename = $export_date.'export.xlsx';
}else{
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
$filename = $export_date.'export.xls';
}
//接下来就是写数据到表格里面去
$objActSheet = $objPHPExcel->getActiveSheet();
foreach ($lists as $key=>$value) {
$key = $key+2;
$objActSheet->setCellValue('A'.$key,$value['card_number']);
$objActSheet->setCellValue('B'.$key,$value['english_name']);
$objActSheet->setCellValue('C'.$key,$value['chinese_name']);
$objActSheet->setCellValue('D'.$key,$value['tel_code']);
$objActSheet->setCellValue('E'.$key,$value['telephone']);
$objActSheet->setCellValue('F'.$key,$value['address']);
$objActSheet->setCellValue('G'.$key,$value['certificate_type']);
$objActSheet->setCellValue('H'.$key,$value['certificate_number']);
$objActSheet->setCellValue('I'.$key,$value['certificate_start_date']);
$objActSheet->setCellValue('J'.$key,$value['certificate_end_date']);
$objActSheet->setCellValue('K'.$key,$value['referrer']);
$objActSheet->setCellValue('L'.$key,$value['country']);
$objActSheet->setCellValue('M'.$key,$value['name_status']);
$objActSheet->setCellValue('N'.$key,$value['notes']);
$objActSheet->setCellValue('O'.$key,$value['birth_date']);
}
// 下载这个表格，在浏览器输出
header("Pragma: public");
header("Expires: 0");
header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");;
header('Content-Disposition:attachment;filename='.$filename.'');
header("Content-Transfer-Encoding:binary");
$objWriter->save('php://output');
}
}
//批量下载图片zip
public function picDownload($images,$date){
$filename = "../image/submission_report/".$data."/".date ('Ymd').".zip";
// 生成文件
$zip = new \ZipArchive ();
// 使用本类，linux需开启zlib，windows需取消php_zip.dll前的注释
if ($zip->open ($filename ,\ZipArchive::OVERWRITE) !== true) {
//OVERWRITE 参数会覆写压缩包的文件 文件必须已经存在
if($zip->open ($filename ,\ZipArchive::CREATE) !== true){
// 文件不存在则生成一个新的文件 用CREATE打开文件会追加内容至zip
exit ('无法打开文件，或者文件创建失败');
}
}
foreach($images as $key => $v){
$arr1=explode('/', $v['file1']);
$arr2=explode('/', $v['file2']);
$arr3=explode('/', $v['file3']);
$arr4=explode('/', $v['file4']);
$arr5=explode('/', $v['file5']);
$arr6=explode('/', $v['file6']);
$arr7=explode('/', $v['file7']);
$arr8=explode('/', $v['file8']);
if(file_exists($v['file1'])){
$zip->addFile($v['file1'],basename($arr1['4']));
}
if(file_exists($v['file2'])){
$zip->addFile($v['file2'],basename($arr2['4']));
}
if(file_exists($v['file3'])){
$zip->addFile($v['file3'],basename($arr3['4']));
}
if(file_exists($v['file4'])){
$zip->addFile($v['file4'],basename($arr4['4']));
}
if(file_exists($v['file5'])){
$zip->addFile($v['file5'],basename($arr5['4']));
}
if(file_exists($v['file6'])){
$zip->addFile($v['file6'],basename($arr6['4']));
}
if(file_exists($v['file7'])){
$zip->addFile($v['file7'],basename($arr7['4']));
}
if(file_exists($v['file8'])){
$zip->addFile($v['file8'],basename($arr8['4']));
}
}
// 关闭
$zip->close ();
//下面是输出下载;
header ( "Cache-Control: max-age=0" );
header ( "Content-Description: File Transfer" );
header ( 'Content-disposition: attachment; filename='.basename($filename));
header ( "Content-Type: application/zip" ); // zip格式的
header ( "Content-Transfer-Encoding: binary" ); // 告诉浏览器，这是二进制文件
header ( 'Content-Length: '.filesize($filename)); // 告诉浏览器，文件大小
@readfile ( $filename );//输出文件;
@unlink($filename);
}
}
网友评论