function act_crmSysermList($where = "") { $listArr = CrmSystemModel::crmSysermList($where); if ($listArr) { return $listArr; } else { self::$errCode = CrmSystemModel::$errCode; self::$errMsg = CrmSystemModel::$errMsg; return false; } }
public function view_crmSystemExportExcel() { // echo "<pre>";print_r($_POST);exit; header("Content-type:text/html;charset=utf-8"); //基础代码准备 $CrmSystem = new CrmSystemAct(); $condition = array(); $orderByStr = ""; $keyWordsType = trim($_POST['keyWordsType']); //搜索字段名称 $keyWords = trim($_POST['keyWords']); //搜索填写内容 if (!empty($keyWords)) { $condition[] = "{$keyWordsType} = '{$keyWords}'"; } $salesAccountList = trim($_POST['salesAccountList']); //账号 if (!empty($salesAccountList)) { $condition[] = "salesaccount = '{$salesAccountList}'"; } $platformList = trim($_POST['platformList']); //平台 if (!empty($platformList)) { $condition[] = "platform = '{$platformList}'"; } $sortType = trim($_POST['sortType']); //排序 if (!empty($sortType)) { if ($sortType == 'totalpayDesc') { $orderByStr = " ORDER BY totalpay DESC "; //降序 } if ($sortType == 'totalpayAsc') { $orderByStr = " ORDER BY totalpay ASC "; //升序 } if ($sortType == 'totaltimesDesc') { $orderByStr = " ORDER BY totaltimes DESC "; //降序 } if ($sortType == 'totaltimesAsc') { $orderByStr = " ORDER BY totaltimes ASC "; //升序 } } if (empty($condition)) { $this->where = $orderByStr; } else { $this->where = "WHERE " . implode(" and ", $condition) . $orderByStr; } $crmListArr = $CrmSystem->act_crmSysermList($this->where); //准备导出 require_once '../lib/PHPExcel.php'; $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->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->setActiveSheetIndex(0)->setCellValue('A1', '姓名/客户ID'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B1', '邮件'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('C1', '客户电话'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('D1', '所在国家'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('E1', '总购买金额'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('F1', '总购买次数'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('G1', '销售账号'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('H1', '平台'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('I1', '最新购买时间'); $a = 2; if (!empty($crmListArr)) { //单据信息 foreach ($crmListArr as $key => $crmListExportArr) { $objPHPExcel->setActiveSheetIndex(0)->getCell('A' . $a)->setValueExplicit(@$crmListExportArr['clientname'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('B' . $a)->setValueExplicit(@$crmListExportArr['email'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('C' . $a)->setValueExplicit(@$crmListExportArr['phone'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('D' . $a)->setValueExplicit($crmListExportArr['country'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('E' . $a)->setValueExplicit($crmListExportArr['totalpay'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('F' . $a)->setValueExplicit($crmListExportArr['totaltimes'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('G' . $a)->setValueExplicit($crmListExportArr['salesaccount'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('H' . $a)->setValueExplicit($crmListExportArr['platform'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('I' . $a)->setValueExplicit(date("Y-m-d H:i:s", $crmListExportArr['lastbuytime']), PHPExcel_Cell_DataType::TYPE_STRING); $a++; } } $objPHPExcel->getActiveSheet(0)->getStyle('A1:I1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(15); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(30); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(15); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('D')->setWidth(15); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('E')->setWidth(10); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('F')->setWidth(10); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('G')->setWidth(15); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('H')->setWidth(15); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('I')->setWidth(20); $title = "crmInfo" . date('Y-m-d'); $titlename = "crmInfo" . date('Y-m-d') . ".xls"; $objPHPExcel->getActiveSheet()->setTitle($title); $objPHPExcel->setActiveSheetIndex(0); header('Content-Type: application/vnd.ms-excel'); header("Content-Disposition: attachment;filename={$titlename}"); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); exit; }