/** * 获取OE号 */ public static function getOENOSByGoodsID($goodsID) { $key = 'oenu_' . $goodsID; $OENOS = Yii::app()->cache->get($key); if (!$OENOS) { $goodsOES = PapGoodsOeRelation::model()->findAll("GoodsID={$goodsID}"); $data = array(); $OENOS = ''; foreach ($goodsOES as $key => $value) { $data[$key]['ID'] = $value['ID']; $data[$key]['OENO'] = $value['OENO']; if ($key == 0) { $OENOS .= $value['OENO']; } else { $OENOS .= '、' . $value['OENO']; } } Yii::app()->cache->set($key, $OENOS); } return $OENOS; }
/** * 获取OE号 */ public static function getOENOSByGoodsID($goodsID) { $goodsOES = PapGoodsOeRelation::model()->findAll("GoodsID={$goodsID}"); $data = array(); $OENOS = ''; foreach ($goodsOES as $key => $value) { $data[$key]['ID'] = $value['ID']; $data[$key]['OENO'] = $value['OENO']; if ($key == 0) { $OENOS .= $value['OENO']; } else { $OENOS .= '、' . $value['OENO']; } } // return $data; return $OENOS; }
public static function newgoodsxinfo($GoodsID) { $PartsLevel = array('A' => '原厂', 'B' => '高端品牌', 'C' => '经济实用', 'D' => '下线', 'E' => '拆车'); $Goods = PapGoods::model()->findBypk($GoodsID); if ($Goods) { $arr = $Goods->attributes; $arr['Brand'] = self::idgetjpbrand($Goods->attributes['BrandID'], 'BrandName'); //机构名称 $arr['OrganName'] = self::getnamebyorganid($Goods->attributes['OrganID']); //获得配件档次名称 $arr['PartsLevelName'] = $PartsLevel[$Goods->attributes['PartsLevel']]; //获得标准名称 $arr['StandCodeName'] = DealergoodsService::StandCodegetcpname($Goods->attributes['StandCode'], 'Name'); //商品-OE号 $oeno = PapGoodsOeRelation::model()->findAll('GoodsID=:GoodsID', array(':GoodsID' => $GoodsID)); foreach ($oeno as $value) { $arr['oeno'][] = $value->attributes['OENO']; } $gcategory = MallService::getCategory($Goods->attributes['StandCode']); // $version['gcategory'] = $gcategory->attributes; $redis['gcategory']['BigParts'] = $gcategory['BigPartsID']; $redis['gcategory']['SubParts'] = $gcategory['SubPartsID']; $redis['gcategory']['BigName'] = $gcategory['BigParts']; $redis['gcategory']['SubName'] = $gcategory['SubParts']; //商品-图片 $img = PapGoodsImageRelation::model()->findAll('GoodsID=:GoodsID', array(':GoodsID' => $GoodsID)); foreach ($img as $key => $value) { $arr['img'][$key]['ImageUrl'] = $value->attributes['ImageUrl']; $arr['img'][$key]['ImageName'] = $value->attributes['ImageName']; $arr['img'][$key]['BigImage'] = $value->attributes['BigImage']; $arr['img'][$key]['MallImage'] = $value->attributes['MallImage']; } //商品-属性 $spec = PapGoodsSpec::model()->find('GoodsID=:GoodsID', array(':GoodsID' => $GoodsID)); $arr['spec']['ValidityType'] = $spec->attributes['ValidityType']; $arr['spec']['ValidityDate'] = $spec->attributes['ValidityDate']; $arr['spec']['Unit'] = $spec->attributes['Unit']; $arr['spec']['BganCompany'] = $spec->attributes['BganCompany']; $arr['spec']['BganGoodsNO'] = $spec->attributes['BganGoodsNO']; //商品-包装 $pack = PapGoodsPack::model()->find('GoodsID=:GoodsID', array(':GoodsID' => $GoodsID)); $arr['pack']['MinQuantity'] = $pack->attributes['MinQuantity']; } return $arr; }