/** * 取商品品类第三级标准名称 * @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'); }