php导出excel、下载图片并压缩成zip实例

<?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);

}