/**
* 取商品品类第三级标准名称
* @return array
*/
public function getLeafCategorys()
{
if ($this->subCategory) {
$cri = new CDbCriteria(array('condition' => 'ParentID = ' . $this->subCategory . ' and IsShow=1', 'order' => 'SortOrder asc'));
}
$categorys = Gcategory::model()->findAll($cri);
return $categorys;
}
public static function getGoodsData($params)
{
$sql = self::getGoodsSql($params);
if ($params['SellerID'] && $params['IsSale'] == 0) {
$sql["countSql"] = str_replace('dg.IsSale=1', 'dg.IsSale=0', $sql["countSql"]);
$sql["sql"] = str_replace('dg.IsSale=1', 'dg.IsSale=0', $sql["sql"]);
}
$res = Yii::app()->papdb->createCommand($sql["countSql"])->queryAll();
$count = $res[0]['count'];
$dataProvider = new CSqlDataProvider($sql["sql"], array('db' => Yii::app()->papdb, 'totalItemCount' => $count, 'pagination' => array('pageSize' => $params['rows'] ? $params['rows'] : 10)));
$goods = $dataProvider->getData();
foreach ($goods as $k => $v) {
$image = self::getOneGoodsImage($v['ID']);
if (!$image) {
$goods[$k]['image'] = F::baseUrl() . '/upload/' . 'dealer/default-goods.png';
} else {
$goods[$k]['image'] = F::baseUrl() . '/upload/' . $image;
}
//获取标准名称
if ($v['StandCode']) {
$goods[$k]['cpname'] = Gcategory::model()->find(array('select' => 'Name', 'condition' => "Code = '{$v['StandCode']}'"))->attributes['Name'];
}
//卖家信息
$goods[$k]['dealername'] = Organ::model()->findByPk($v['OrganID'], array('select' => 'OrganName'))->attributes['OrganName'];
if (!$params["resource"] || $params["resource"] != "mall") {
//OE号
$goods[$k]['OENOS'] = self::getOENOSByGoodsID($v['ID']);
// 车型车系
//$carmodel = explode('、', self::getVehicleByGoodsID($v['ID']));
//$goods[$k]['vehicle'] = $carmodel[0];
//$goods[$k]['vehicle'] = self::getOneVehicleByGoodsID($v['ID']);
}
}
$dataProvider->setData($goods);
return array('dataProvider' => $dataProvider, 'count' => $count);
}
public function actionServedetail()
{
$id = Yii::app()->request->getParam("id");
$model = ServiceParts::model()->findByPK($id);
$data = array();
$data = $model->attributes;
$part = explode(",", $data['PartName']);
$data['PartName'] = '';
foreach ($part as $v) {
$name = Gcategory::model()->find(array('select' => 'Name', 'condition' => 'ID= :ID', 'params' => array(':ID' => $v)));
$data['PartName'] .= $name['Name'] . ",";
}
$data['PartName'] = substr($data['PartName'], 0, strlen($data['PartName']) - 1);
if ($data['OperateType'] == 2) {
$data['OperateType'] = "维修";
} else {
$data['OperateType'] = "更换";
}
$this->render("servedetail", array('data' => $data));
}
?>
</b></a></div>
<div style="">订单编号：<?php
echo OrderreturnService::orderIDgetorder($value['OrderID'], 'OrderSN');
?>
</div>
<div style="clear:both;height:0px"></div>
<p class="">商品编号：<span class="zwq_color"><?php
echo $goods['GoodsInfo']['GoodsNO'];
?>
</span> | 品牌：<span><?php
echo $goods['GoodsInfo']['Brand'];
?>
</span></p>
<p class="">标准名称：<span><?php
echo $goods ? Gcategory::model()->find(array('select' => 'Name', 'condition' => "Code='{$goods['GoodsInfo']['StandCode']}'"))->attributes['Name'] : ReturnorderService::idgetgoodsinfo($value['OrderID'], $value['GoodsID'], 'CpName');
?>
</span> | 拼音代码：<span><?php
echo $goods['GoodsInfo']['Pinyin'];
?>
</span>
<p>配件档次：<span><?php
echo $goods['GoodsInfo']['PartsLevelName'];
?>
</span></p>
<?php
$orderGoods = PapOrderGoods::model()->find("OrderID=:OrderID and GoodsID=:GoodsID", array(":OrderID" => $value['OrderID'], ":GoodsID" => $goods['GoodsInfo']['ID']));
?>
<p>定位车型：<span><?php
echo MallService::getCarmodeltxt(array('make' => $orderGoods['MakeID'], 'series' => $orderGoods['CarID'], 'year' => $orderGoods['Year'], 'model' => $orderGoods['ModelID']));
private static function getVersionGoods($v)
{
$res = DealergoodsService::getmongoversion($v['GoodsID'], $v['Version']);
$goods = $res['GoodsInfo'];
// if (is_array($goods) && !empty($goods)) {
//商品图片
if (is_array($goods['img']) && !empty($goods['img'])) {
if (!$goods['img'][0]['ImageUrl']) {
$v['ImageUrl'] = $goods['img'][0]['MallImage'];
} else {
$v['ImageUrl'] = $goods['img'][0]['ImageUrl'];
}
} else {
$v['ImageUrl'] = '';
}
//商品oe号
if (is_array($goods['oeno']) && !empty($goods['oeno'])) {
$oe = '';
foreach ($goods['oeno'] as $ov) {
if ($ov) {
$oe .= $ov . ',';
}
}
$v['GoodsOE'] = substr($oe, 0, -1);
} else {
$v['GoodsOE'] = '';
}
$v['GoodsName'] = $goods['Name'];
$v['GoodsNum'] = $goods['GoodsNO'];
$v['Brand'] = $goods['Brand'];
$v['PartsLevelName'] = $goods['PartsLevelName'];
$v['CpName'] = Gcategory::model()->find(array('select' => 'Name', 'condition' => "Code='{$goods['StandCode']}'"))->attributes['Name'];
$v['Carmodeltxt'] = MallService::getCarmodeltxt(array('make' => $v['MakeID'], 'series' => $v['CarID'], 'year' => $v['Year'], 'model' => $v['ModelID']));
return $v;
}
protected function findsub($rows)
{
foreach ($rows as $k => $v) {
$childs[$k] = $v->attributes;
$cri = new CDbCriteria(array('condition' => 'ParentID =' . $v[BigpartsID] . ' and IsShow=1', 'order' => 'SortOrder asc'));
$sub = Gcategory::model()->findAll($cri);
$childs[$k]['children'] = $sub;
}
return $childs;
}
?>
<ul class="splb_order float_l tb_head m_left5">
<?php
foreach ($data->goods as $v) {
?>
<?php
$goods = DealergoodsService::getmongoversion($v['GoodsID'], $v['Version']);
if ($goods) {
$v['GoodsName'] = $goods['GoodsInfo']['Name'];
if (is_array($goods['GoodsInfo']['img']) && !empty($goods['GoodsInfo']['img'])) {
$v['ImageUrl'] = $goods['GoodsInfo']['img'][0]['ImageUrl'];
}
$v['GoodsNum'] = $goods['GoodsInfo']['GoodsNO'];
$v['Brand'] = $goods['GoodsInfo']['Brand'];
$v['PartsLevelName'] = $goods['GoodsInfo']['PartsLevelName'];
$v['CpName'] = Gcategory::model()->find(array('select' => 'Name', 'condition' => "Code='{$goods['GoodsInfo']['StandCode']}'"))->attributes['Name'];
if (is_array($goods['GoodsInfo']['oeno']) && !empty($goods['GoodsInfo']['oeno'])) {
$oe = '';
foreach ($goods['GoodsInfo']['oeno'] as $vv) {
if ($vv) {
$oe .= $vv . ',';
}
}
$v['GoodsOE'] = substr($oe, 0, -1);
}
}
?>
<li>
<div class="div_img float_l m-top">
<a class="order_goods" title="<?php
echo ReturnorderService::idgetgoodsinfo($v['OrderID'], $v['GoodsID'], 'GoodsName');
/**
* 生产商最新版本的所有产品
* @param unknown $manufacturer_ID
* @return unknown
* @params goodsprice 商品价格
* @params marketprice 市场指导价
*/
public static function getGoodsByMDID($manufacturer_ID, $userID, $params, $page, $limit)
{
//授权品牌
$organID = Commonmodel::getOrganID();
$identity = Commonmodel::getIdentity(Yii::app()->user->id);
$brands = MakePromitBrand::model()->find('DealerID=' . $organID . ' and OrganID=' . $manufacturer_ID);
//查询销售价格
$criteria = new CDbCriteria();
//找到授权经销商的客户类别
//折扣率
// $priceratio= MakePromitPrice::model()->find('OrganID='.$manufacturer_ID);
// $ratio=isset($priceratio['Level'.$brands['Level']])?$priceratio['Level'.$brands['Level']].'%':'100%';
// $sql2='select distinct a.id as goodsID,b.goods_oe as OE,b.goods_brand as brandid,b.version_name as verion_name,b.goods_no as goodsno,b.goods_name as goodsname,'
// .' b.goods_category as categoryid,b.standard_id'
// . " from tbl_make_goods a ,tbl_make_goods_version b,tbl_make_goods_vehicle c"
// . ' where a.id=b.goods_id and a.NewVersion=b.version_name'
// . " and a.ISdelete='0' and b.ISdelete=0"
// . " and a.organID='$manufacturer_ID' ";
$sql2 = "select distinct a.id as goodsID ,b.goods_category as category_id,b.goods_oe as OE,b.goods_brand as brand,b.organID,\n a.NewVersion as version_name,b.goods_no as goodsno,b.goods_name as goodsname,\n b.benchmarking_brand,b.benchmarking_sn,a.create_time,";
if ($identity['identity'] == 2) {
$sql2 .= 'd.Price,';
}
$sql2 .= " b.inventory as inventory,b.senddays,b.description,a.IsSale,b.standard_id" . " from tbl_make_goods a ,tbl_make_goods_version b ";
if (!empty($params['goodsvehicle'])) {
$sql2 .= ",tbl_make_goods_vehicle c";
}
if ($identity['identity'] == 2) {
$sql2 .= ',tbl_make_price_relation d';
}
$sql2 .= ' where a.id=b.goods_id and a.NewVersion=b.version_name' . " and a.ISdelete='0' and b.ISdelete=0" . " and a.organID='{$manufacturer_ID}' ";
if ($identity['identity'] == 2 && $brands['CustomerType']) {
$sql2 .= "and d.TypeID= {$brands['CustomerType']} and d.GoodsID=a.id and d.Price is not null";
$sql2 .= " and a.IsSale=0";
}
if ($params && is_array($params)) {
if ($brands['BrandName']) {
$sql2 .= " and b.goods_brand in (0" . $brands['BrandName'] . "0)";
}
//商品类别搜索
if (!empty($params['goodscategory'])) {
$sql2 .= ' and b.goods_category=' . $params['goodscategory'];
}
//商品名称搜索
if (!empty($params['goodsname'])) {
$sql2 .= " and b.goods_name like '%{$params['goodsname']}%'";
}
//商品编号搜索
if (!empty($params['goodsno'])) {
$sql2 .= " and b.goods_no like '%{$params['goodsno']}%'";
}
//商品OE号搜索
if (!empty($params['oe'])) {
$sql2 .= " and b.goods_oe like '%{$params['oe']}%'";
}
//商品品牌搜索
if (!empty($params['goodsbrand'])) {
$sql2 .= " and b.goods_brand ='{$params['goodsbrand']}'";
}
//适用车型搜索
if (!empty($params['goodsvehicle'])) {
$sql2 .= " and c.Name like '%{$params['goodsvehicle']}%' and a.id=c.GoodsID and a.NewVersion=c.VersionName";
}
// //是否上架查询
if (is_numeric($params['issale'])) {
$sql2 .= " && a.IsSale='{$params['issale']}'";
}
//配件品类
if (!empty($params['standardid'])) {
$sql2 .= ' and b.standard_id=' . $params['standardid'];
} else {
//经营品类
$standmodel = DealerCpname::model()->findAll("OrganID=:organID", array(':organID' => $manufacturer_ID));
$standids = '';
$standarr = array();
foreach ($standmodel as $m) {
$standarr[] = $m['CpNameID'];
}
$standids = implode(',', $standarr);
if (!$standids) {
$standids = '0';
}
$sql2 .= ' and b.standard_id in (' . $standids . ')';
}
//高级筛选
//此处 key : 查询属性 between,normall; $val['name']: 模板名称；$val["value"]：值 eg:value / value,value2
if (is_array($params["more"])) {
foreach ($params["more"] as $key => $val) {
$sql2 .= " and exists(\n\t \t\t \t\tSELECT DISTINCT(f.goods_id) FROM `tbl_make_goods_values` f,`tbl_make_goods_template` g where\n\t \t\t \t\tg.id=f.template_id and a.id=f.goods_id\n\t \t\t \t\tand g.organID='{$manufacturer_ID}' and g.standard_id='{$params['standardid']}'";
//判断查询属性
if ($val["type"] == "between") {
//区间查询方式： $val["value"] = value,value2;
$valArr = explode(',', $val["value"]);
$sql2 .= "and (g.name='" . $val["name"] . "' and f.value between {$valArr['0']} and {$valArr['1']})) ";
} else {
if ($val["type"] == "normall") {
$sql2 .= "and (g.name='" . $val["name"] . "' and f.value= '" . $val["value"] . "')) ";
}
}
}
}
}
//把make_goods里面上架的查询出来(0/1/上架/下架) 不写则全部查询
$sql2 .= " group by a.id order by a.id desc";
$result = Yii::app()->db->createCommand($sql2)->queryAll();
if ($page && $limit) {
$count = count($result);
$pages = new CPagination($count);
//设置分页页数
$pages->setPageSize($limit);
$pages->applyLimit($criteria);
$result = Yii::app()->db->createCommand($sql2 . " LIMIT :offset,:limit");
//绑定分页参数
$offset = $pages->currentPage * $pages->pageSize;
$size = $pages->pageSize;
$result->bindValue(':offset', $pages->currentPage * $pages->pageSize);
$result->bindValue(':limit', (int) $limit);
$result = $result->queryAll();
}
$res = array();
foreach ($result as $key => $val) {
$res[$key] = $val;
$OEArr = explode(',', $val['OE']);
$res[$key]["car"] = self::getVehicleByOEArr($OEArr);
//查询品牌名称
$brandmodel = MakeGoodsBrand::model()->findByPK($val['brand']);
// $res[$key]['brand']=$brandmodel['BrandName'];
$res[$key]['brandname'] = $brandmodel['BrandName'];
//查询类别名称
$categorymodel = MakeGoodsCategory::model()->findByPk($val['category_id']);
$res[$key]['category'] = $categorymodel['name'];
//查询标准名称
$standardmodel = Gcategory::model()->findByPk($val['standard_id']);
$res[$key]['cp_name'] = $standardmodel['name'];
//查询车型
$cmodel = MakeGoodsVehicle::model()->find('GoodsID=' . $val['goodsID'] . ' and VersionName="' . $val['version_name'] . '"');
if ($cmodel) {
$res[$key]['carmodel'] = $cmodel->Name;
}
if ($val['Price']) {
$res[$key]['marketprice'] = $val['Price'];
}
//根据客户类别获取商品价格
// if($brands['CustomerType'])
// {
// $sql_price="select * from tbl_make_price_relation where TypeID= {$brands['CustomerType']} and GoodsID= $val[goodsID]";
// $price=DBUtil::query($sql_price);
// $res[$key]['marketprice']=$price['Price'];
// }
//查询标准名称对应的参数名称
// $temname= MakeGoodsTemplate::model()->findAll("organID=:organID and standard_id=:stand and ISdelete='N'",array(
// ':organID'=>$manufacturer_ID,':stand'=>$val['standard_id']));
//查询商品品与标准名称参数名称对应的参数值
$paramssql = 'SELECT a.id,a.name,b.value FROM `tbl_make_goods_template` a,`tbl_make_goods_values` b where a.id=b.template_id and b.goods_id=' . $val['goodsID'] . ' and b.version_name="' . $val['version_name'] . '"';
$paramsvalue = Yii::app()->db->createCommand($paramssql)->queryAll();
$res[$key]['params'] = '';
foreach ($paramsvalue as $p) {
$res[$key]['params'] .= $p['name'] . ':' . $p['value'] . ';';
}
$res[$key]['OE'] = $val['OE'];
$res[$key]['Brand'] = $val['brand'];
$res[$key]['version_name'] = $val['version_name'];
$res[$key]['GoodsNo'] = $val['goodsno'];
$res[$key]['GoodsName'] = $val['goodsname'];
$res[$key]['BenchBrand'] = $val['benchmarking_brand'];
$res[$key]['BenchNo'] = $val['benchmarking_sn'];
$res[$key]['benchmarking_brand'] = $val['benchmarking_brand'];
$res[$key]['benchmarking_sn'] = $val['benchmarking_sn'];
$res[$key]['GoodsBrand'] = $val['brand'];
$res[$key]['BrandName'] = $val['brandname'];
$res[$key]['GoodsCategory'] = $val['category_id'];
// $datas[$key]['CategoryName']=$val['category'];
$res[$key]['inventory'] = $val['inventory'];
$res[$key]['Days'] = $val['senddays'];
$res[$key]['Desc'] = $val['description'];
//b.maincategory,b.subcategory,b.standard_id
$res[$key]['standard_id'] = $val['standard_id'];
$res[$key]['create_time'] = date('Y-m-d H:i:s', $val['create_time']);
//获取标准名称参数值
if (!empty($val['standard_id'])) {
$params = MakeGoodsValues::model()->findAll('standard_id=' . $val['standard_id'] . ' and goods_id=' . $val['goodsID'] . ' and version_name="' . $val['version_name'] . '"');
$value = array();
foreach ($params as $param) {
$k = $param['template_id'];
$value[$k] = $param['value'];
$res[$key][$k] = $param['value'];
}
$res[$key]['paramsvalue'] = $value;
}
if ($val['IsSale'] == 0) {
$res[$key]['IsSale'] = '已上架';
} else {
$res[$key]['IsSale'] = '已下架';
}
}
if ($page && $count) {
return array('rows' => $res, 'total' => $count);
}
return $res;
}
/**
* 获取商品标准名称 ,不联动
*/
public function actionDynamicLeafcates2()
{
$data = Gcategory::model()->findAll('ParentID=:parent_id', array(':parent_id' => (int) $_POST['subCategory']));
$data = CHtml::listData($data, 'ID', 'Name');
echo CHtml::tag("option", array("value" => ''), '请选择标准名称', true);
foreach ($data as $value => $name) {
echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true);
}
}
static function getMainCategorys($parentID)
{
$cri = new CDbCriteria(array('condition' => 'ParentID =' . $parentID . ' or ParentID <=> NULL and IsShow=1', 'order' => 'SortOrder asc'));
$categorys = Gcategory::model()->findAll($cri);
return $categorys;
}
public function Getmaincate($organID)
{
$big = JpdOrganCpname::model()->findAll('OrganID=:org', array(':org' => $organID));
foreach ($big as $k => $v) {
$childs[$k] = $v->attributes;
$cri = new CDbCriteria(array('condition' => 'ParentID =' . $v[BigpartsID] . ' and IsShow=1', 'order' => 'SortOrder asc'));
$sub = Gcategory::model()->findAll($cri);
$childs[$k]['children'] = $sub;
}
return $childs;
}
public function actionDownload()
{
$organID = Commonmodel::getOrganID();
$standardid = intval($_GET['standardid']);
//标准名称
$standarddata = Gcategory::model()->findByPk($standardid);
//查询标准名称参数名
$datas = MakeGoodsTemplate::model()->findAll('organID=' . $organID . ' and ISdelete="N" and standard_id=' . $standardid);
$paramsname = array();
$list = array();
//其他数据
$columnnames = array();
if ($datas) {
$columnnames = array('商品ID', '商品编号（必填）', '商品名称（必填）', '商品品牌', '标准名称', 'OE号', '标杆品牌', '标杆商品号', '市场指导价', '销售价', '优惠价', '库存（有/无）', '发货天数', '备注', '上下架', '适用车系', '商品版本号');
}
foreach ($datas as $data) {
$columnnames[] = $data['name'];
}
//导出excel表格
$objPHPExcel = new PHPExcel();
// 操作第一个工作表(默认是操作第一个)
$objPHPExcel->setActiveSheetIndex(0);
//得到当前活动sheet(默认是第一个sheet)
$objActSheet = $objPHPExcel->getActiveSheet();
// 设置当前活动sheet的名称
$objActSheet->setTitle($standarddata['name'] . '-模板表');
//设置B1的值为 '标准名称参数模板'
$objActSheet->setCellValue('B1', '标准名称参数模板');
//设置颜色
//$objActSheet->getStyle('A3')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED);
$num = 1;
foreach ($columnnames as $k => $v) {
$cell = PHPExcel_Cell::stringFromColumnIndex($k);
$objActSheet->getColumnDimension($cell)->setWidth(20);
$excelstyle = $objActSheet->getStyle($cell . $num);
$excelstyle->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED);
$excelstyle->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$excelstyle->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objActSheet->setCellValue($cell . $num, $v);
}
//设置填充的样式和背景色
//$objActSheet->getStyle('A1:'.$cell.'1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
//$objActSheet->getStyle('A1:'.$cell.'1')->getFill()->getStartColor()->setARGB(PHPExcel_Style_Color::COLOR_RED);
//输出
header('Content-Type : application/vnd.ms-excel');
header('Content-Disposition:attachment;filename="' . '标准名称参数模板表-' . $standarddata['name'] . '-' . date("Y-m-d") . '.xls"');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
}
public static function getCategory($code)
{
$cp = Gcategory::model()->find(array('select' => 'Name,ParentID', 'condition' => "Code='{$code}'"))->attributes;
$sub = Gcategory::model()->findByPk($cp['ParentID'], array('select' => 'ID,Name,ParentID'))->attributes;
$big = Gcategory::model()->findByPk($sub['ParentID'], array('select' => 'Name,ParentID'))->attributes;
return array('CpName' => $cp['Name'], 'SubParts' => $sub['Name'], 'BigParts' => $big['Name'], 'sub' => $sub['ID']);
}
public function actionExportprice()
{
$type = $this->getCustomtype();
$get = $this->getPriceresult();
$result = $get['result'];
//客户类别搜索
foreach ($type as $v) {
$atype[$v['TypeID']] = $v;
}
if (!empty($_GET['ctype'])) {
$type = array();
$temp = explode(',', $_GET['ctype']);
foreach ($atype as $k => $v) {
if (in_array($k, $temp)) {
$type[$k]['TypeID'] = $k;
$type[$k]['TypeName'] = $atype[$k]['TypeName'];
}
}
}
//导出
$objectPHPExcel = new PHPExcel();
$objectPHPExcel->setActiveSheetIndex(0);
$objectPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
$objectPHPExcel->setActiveSheetIndex(0)->setCellValue('A3', '商品编号(必填)');
$objectPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objectPHPExcel->setActiveSheetIndex(0)->setCellValue('B3', '商品品牌');
$objectPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$objectPHPExcel->setActiveSheetIndex(0)->setCellValue('C3', '标准名称');
$cell = 'C';
foreach ($type as $k => $v) {
$cell++;
$objectPHPExcel->getActiveSheet()->getColumnDimension($cell)->setWidth(20);
$objectPHPExcel->setActiveSheetIndex(0)->setCellValue($cell . '3', $v['TypeName']);
}
//报表头的输出
$objectPHPExcel->getActiveSheet()->mergeCells('A1:' . $cell . '1');
$objectPHPExcel->getActiveSheet()->setCellValue('A1', '客户价格表');
$objectPHPExcel->setActiveSheetIndex(0)->getStyle('A1')->getFont()->setSize(24);
$objectPHPExcel->setActiveSheetIndex(0)->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objectPHPExcel->getActiveSheet()->mergeCells('A2:' . $cell . '2');
$objectPHPExcel->getActiveSheet()->setCellValue('A2', '*注：请勿更改表头字段，防止改价失败!可按要求添加或删除商品数据。');
//设置行高
$objectPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(25);
$objectPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(40);
$objectPHPExcel->getActiveSheet()->getRowDimension('2')->setRowHeight(22);
$objectPHPExcel->getActiveSheet()->getRowDimension('3')->setRowHeight(30);
$objectPHPExcel->getActiveSheet()->getStyle('A3:' . $cell . '3')->getFont()->setBold(true);
//设置居中
$objectPHPExcel->getActiveSheet()->getStyle('A3:' . $cell . '3')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objectPHPExcel->getActiveSheet()->getStyle('A3:' . $cell . '3')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$n = 0;
foreach ($result as $val) {
// $objectPHPExcel->getActiveSheet()->setCellValue('A'.($n+4) ,($n+1));
$objectPHPExcel->getActiveSheet()->setCellValue('A' . ($n + 4), $val['goodsno']);
//查询商品类别
$val['brandname'] = '';
if (!empty($val['brand'])) {
$brand = MakeGoodsBrand::model()->findByPK($val['brand']);
$val['brandname'] = $brand['BrandName'];
}
$objectPHPExcel->getActiveSheet()->setCellValue('B' . ($n + 4), $val['brandname']);
//查询标准名称
$val['cp_name'] = '';
if (!empty($val['standard_id'])) {
$stand = Gcategory::model()->findByPk($val['standard_id']);
$val['cp_name'] = $stand['name'];
}
$objectPHPExcel->getActiveSheet()->setCellValue('C' . ($n + 4), $val['cp_name']);
$sql2 = "select Price,TypeID from tbl_make_price_relation where GoodsID={$val['goodsID']}";
$price = DBUtil::queryAll($sql2);
$pArr = array();
if (!empty($price)) {
foreach ($price as $v1) {
$pArr[$v1['TypeID']] = $v1['Price'];
}
}
$cel = 'C';
foreach ($type as $k => $v2) {
$cel++;
if (array_key_exists($v2['TypeID'], $pArr)) {
$objectPHPExcel->getActiveSheet()->setCellValue($cel . ($n + 4), $pArr[$v2['TypeID']]);
} else {
$objectPHPExcel->getActiveSheet()->setCellValue($cel . ($n + 4), '');
}
}
//设置边框
$currentRowNum = $n + 4;
$objectPHPExcel->getActiveSheet()->getStyle('A' . ($n + 4) . ':' . $cel . $currentRowNum)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objectPHPExcel->getActiveSheet()->getStyle('A' . ($n + 4) . ':' . $cel . $currentRowNum)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$n++;
}
//导出为excel表格
$objectPHPExcel->getActiveSheet()->getPageSetup()->setHorizontalCentered(true);
$objectPHPExcel->getActiveSheet()->getPageSetup()->setVerticalCentered(false);
ob_end_clean();
ob_start();
header('Content-Type : application/vnd.ms-excel');
header('Content-Disposition:attachment;filename="' . iconv("utf-8", "gb2312", "客户价格表") . '.xls"');
$objWriter = PHPExcel_IOFactory::createWriter($objectPHPExcel, 'Excel5');
$objWriter->save('php://output');
}
