/** * 获取参数名称列名 * @param type $cp_name 标准名称 */ private function getParamName($cp_name) { $standardid = $this->cpnameID($cp_name); $organID = Commonmodel::getOrganID(); $datas = MakeGoodsTemplate::model()->findAll('organID=' . $organID . ' and ISdelete="N" and standard_id=' . $standardid); $paramsname = array(); // 参数名称 if ($datas) { foreach ($datas as $data) { $paramsname['_' . $data['id']] = $data['name']; } } return $paramsname; }
public function actionDowngoodstemp() { // 模版字段 // 商品编号、商品名称、商品品牌、配件品类(选择标准名称)、标杆品牌、 // 标杆商品号、市场指导价、销售价、优惠价、现有库存、发货天数、配送说明、 // 备注、参数名称1、参数名称2、参数名称3、参数名称4、参数名称5… // 模版基础字段 $basis = array('goods_no' => '商品编号(必填)', 'goods_name' => '商品名称(必填)', 'brand' => '品牌', 'goods_oe' => 'OE号(必填,多个OE号以逗号隔开)', 'carmodel' => '适用车型', 'benchmarking_brand' => '标杆品牌', 'benchmarking_sn' => '标杆商品号', 'inventory' => '库存(有/无)', 'senddays' => '发货天数', 'description' => '备注'); // 嘉配样式数据 $jiapartsdatas = array('goods_no' => 'JP00001', 'goods_name' => '嘉配样品', 'brand' => '奇瑞', 'goods_oe' => 'OE001,OE002', 'carmodel' => 'ST1', 'benchmarking_brand' => '奇瑞', 'benchmarking_sn' => 'QR00001', 'inventory' => '有', 'senddays' => '2', 'description' => '批量导入时请删掉 嘉配样品 数据'); $organID = Commonmodel::getOrganID(); // $standardid = intval($_GET['standardid']); $standardid = Yii::app()->request->getParam('standardid'); $name = Yii::app()->request->getParam('name'); // $standardid = 1201221; $datas = MakeGoodsTemplate::model()->findAll('organID=' . $organID . ' and ISdelete="N" and standard_id=' . $standardid); $paramsname = array(); // 参数名称 if ($datas) { foreach ($datas as $data) { $paramsname['_' . $data['id']] = $data['name']; } } // var_dump($paramsname); $goodstemps = array_merge($basis, $paramsname); // $goodstemps = array_merge($basis); $jiapartsdataseg = array_merge($jiapartsdatas, $paramsname); // $jiapartsdataseg = array_merge($jiapartsdatas); // var_dump($goodstemps); exit; //导出excel表格 $objPHPExcel = new PHPExcel(); // 操作第一个工作表(默认是操作第一个) $objPHPExcel->setActiveSheetIndex(0); //得到当前活动sheet(默认是第一个sheet) $objActSheet = $objPHPExcel->getActiveSheet(); // 设置当前活动sheet的名称 $objActSheet->setTitle('标准名称参数模板'); $cell = 'A'; foreach ($goodstemps as $k => $value) { //$num=4; //设置单元格宽度 $objActSheet->getColumnDimension($cell)->setWidth(15); $objActSheet->setCellValue($cell . '1', $value); //设置边框 //设置边框 $objActSheet->getStyle($cell . '1')->getFont()->setBold(true); $objActSheet->getStyle($cell . '1')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objActSheet->getStyle($cell . '1')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objActSheet->getStyle($cell . '1')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objActSheet->getStyle($cell . '1')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objActSheet->getStyle($cell . '1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objActSheet->getStyle($cell . '1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $cell++; } $cell = 'A'; foreach ($jiapartsdataseg as $k => $value) { //$num=4; //设置单元格宽度 $objActSheet->getColumnDimension($cell)->setWidth(15); $objActSheet->setCellValue($cell . '2', $value); $cell++; } $cell = ord($cell); $cell--; $cell = chr($cell); //设置行高 $objActSheet->getDefaultRowDimension()->setRowHeight(25); // 字体加粗 $objActSheet->getStyle('A1:' . $cell . '1')->getFont()->setBold(true); //设置居中 $objActSheet->getStyle('A1:' . $cell . '1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objActSheet->getStyle('A1:' . $cell . '1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); // 设置字体颜色 $objActSheet->getStyle('A1:' . $cell . '1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED); //设置填充的样式和背景色 // $objActSheet->getStyle('A1:' . $cell . '1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID); // $objActSheet->getStyle('A1:' . $cell . '1')->getFill()->getStartColor()->setARGB('FF66CCCC'); ob_end_clean(); ob_start(); header('Content-Type : application/vnd.ms-excel'); $name = '商品-' . $name . '模版-' . date("Y-m-d"); $name = iconv('utf-8', 'gbk', $name); header('Content-Disposition:attachment;filename="' . $name . '.xls"'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); }
/** * 标准名称不同生成不同的模版头部 * @param type $standid */ private function goodshead($standard_id) { $goodshead = array('goods_id' => '商品ID', 'goods_no' => '商品编号', 'goods_name' => '商品名称', 'brand' => '商品品牌', 'cate' => '商品类别', 'category' => '标准名称', 'OENO' => 'OE号', 'cars' => '适用车型', 'benchmarking_brand' => '标杆品牌', 'benchmarking_sn' => '标杆商品号', 'inventory' => '库存', 'senddays' => '发货天数', 'description' => '备注', 'IsSale' => '上/下架', 'NewVersion' => '商品版本号'); $organID = Commonmodel::getOrganID(); $datas = MakeGoodsTemplate::model()->findAll('organID=' . $organID . ' and ISdelete="N" and standard_id=' . $this->cpnameID($standard_id)); $paramsname = array(); // 参数名称 if ($datas) { foreach ($datas as $data) { $paramsname['s' . $data['id']] = $data['name']; } } $head = array_merge($goodshead, $paramsname); return $head; }
public function actionCheckdel() { $cateid = $_GET['cateid']; $organID = Commonmodel::getOrganID(); $Cpid = DealerCpname::model()->findByPk($cateid); if (!empty($Cpid->CpNameID)) { $template = MakeGoodsTemplate::model()->find("organID=:organID and standard_id=:cpid and ISdelete='N'", array(":organID" => $organID, ":cpid" => $Cpid->CpNameID)); if (!empty($template)) { echo json_encode("此品类中已有参数模版,不可删除!"); } else { $goods = MakeGoodsVersion::model()->findAll("organID=:organID and goods_category=:cpid and ISdelete=0", array(":organID" => $organID, ":cpid" => $Cpid->CpNameID)); if (!empty($goods)) { echo json_encode("此品类中已有商品,不可删除!"); } else { echo json_encode("OK"); } } } else { echo json_encode("false"); } }