/** * 名称:act_change_sign * 功能:更改签约状态 * @param str $status * @param arr $idArr * @return void */ public function act_change_sign() { if (empty($_GET['idArr']) || empty($_GET['status'])) { self::$errMsg = "传参非法"; return; } $status = trim($_GET['status']); $idArr = $_GET['idArr']; $ret = PartnerModel::change_sign($status, $idArr); self::$errCode = PartnerModel::$errCode; self::$errMsg = PartnerModel::$errMsg; return $ret; }
/** * 导出供应商信息的函数 * @return void */ public function view_export() { error_reporting(-1); $where = ''; $idStr = $_GET['idArr']; if (!empty($idStr)) { $where .= ' and pp.id in (' . $idStr . ')'; } $field = " pp.id,pp.company_name,ppt.category_name,pp.username,pp.status,pp.tel,pp.phone,pp.fax,pp.QQ,pp.AliIM,pp.e_mail,pp.shoplink,pp.address,pp.city,pp.email_status,pp.sms_status,pu.global_user_name as purchaser,pp.note,pc.company "; $partner = new PartnerAct(); $result = $partner->act_getData($where, $field); if (empty($result)) { echo "无数据"; return false; } //print_r($result);exit; $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', '单位名称'); $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', 'QQ'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('H1', '邮件'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('I1', '阿里旺旺'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('J1', '店铺链接'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('K1', '所属城市'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('L1', '地址'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('M1', '状态'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('N1', '支持短信'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('O1', '支持邮件'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('P1', '采购员'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('Q1', '关联公司'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('R1', '备注'); $a = 2; foreach ($result as $key => $partner) { $status = $partner['status'] == 0 ? '黑名单' : $partner['status'] == 1 ? '正常' : '优质供应商'; $email_status = $partner['email_status'] == 1 ? '是' : '否'; $sms_status = $partner['sms_status'] == 1 ? '是' : '否'; $objPHPExcel->setActiveSheetIndex(0)->getCell('A' . $a)->setValueExplicit($partner['company_name'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('B' . $a)->setValueExplicit($partner['username'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('C' . $a)->setValueExplicit($partner['category_name'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('D' . $a)->setValueExplicit($partner['tel'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('E' . $a)->setValueExplicit($partner['phone'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('F' . $a)->setValueExplicit($partner['fax'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('G' . $a)->setValueExplicit($partner['QQ'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('H' . $a)->setValueExplicit($partner['e_mail'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('I' . $a)->setValueExplicit($partner['AliIM'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('J' . $a)->setValueExplicit($partner['shoplink'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('K' . $a)->setValueExplicit($partner['city'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('L' . $a)->setValueExplicit($partner['address'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('M' . $a)->setValueExplicit($status, PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('N' . $a)->setValueExplicit($email_status, PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('O' . $a)->setValueExplicit($sms_status, PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('P' . $a)->setValueExplicit($partner['purchaser'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('Q' . $a)->setValueExplicit($partner['company'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('R' . $a)->setValueExplicit($partner['note'], PHPExcel_Cell_DataType::TYPE_STRING); $a++; } $objPHPExcel->getActiveSheet(0)->getStyle('A1:R500')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('F')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('E')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('D')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('G')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('H')->setWidth(35); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('I')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('J')->setWidth(50); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('K')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('L')->setWidth(50); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('M')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('N')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('O')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('P')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('Q')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('R')->setWidth(50); $title = "PartnerInfo" . date('Y-m-d'); $titlename = "PartnerInfo" . date('Y-m-d') . ".xls"; $objPHPExcel->getActiveSheet()->setTitle($title); $objPHPExcel->setActiveSheetIndex(0); // Redirect output to a client’s web browser (Excel5) 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'); }