/**
* 获取参数名称列名
* @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");
}
}
