/**
* 名称: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');
}
