/** * 模糊循环匹配配件信息(配件查询会用到) */ public static function getGoodsByPartsOENO($oe) { $sql = "select * from `pap_goods` where IsSale = 1 and ISdelete = 1"; if (!empty($oe) && is_array($oe)) { // OE号不为空,并且是数组 $oearr = array_unique($oe); $oesql = 'select DISTINCT GoodsID from pap_goods_oe_relation where '; foreach ($oearr as $v) { $oesql .= 'OENO = "' . $v . '" or '; } $oesql = rtrim($oesql, 'or '); } elseif (!empty($oe) && !is_array($oe)) { // OE号不为空,并且不是数组 $oesql = 'select DISTINCT GoodsID from pap_goods_oe_relation where OENO = "' . $oe . '"'; } $oedatas = Yii::app()->papdb->createCommand($oesql)->queryAll(); $ids = array(); foreach ($oedatas as $v) { $ids[] = $v['GoodsID']; } $idstr = implode(',', $ids); if ($idstr) { $where .= ' and ID in (' . $idstr . ')'; } else { $where .= ' and ID in (0)'; } $sql .= $where . ' order by ID desc limit 3'; $goodses = Yii::app()->papdb->createCommand($sql)->queryAll(); $data = array(); //判断当前登录角色(修理厂/经销商) $Identity = Yii::app()->user->getIdentity(); if ($Identity == 'servicer') { $Identity = 3; } else { $Identity = 2; } $OrganID = Yii::app()->user->getOrganID(); foreach ($goodses as $key => $goods) { $data[$key]['ImageUrl'] = self::getGoodsImage($goods['ID']); $data[$key]['ID'] = $goods['ID']; $data[$key]['OENO'] = QuotationService::getoebygoodsid($goods['ID']); $data[$key]['OrganID'] = $goods['OrganID']; $data[$key]['Name'] = $goods['Name']; $data[$key]['OrganName'] = self::getnamebyorganid($goods['OrganID']); $data[$key]['ListPrice'] = $goods['Price']; $data[$key]['Identity'] = $Identity; //当前登录用户觉角色 //折扣率 if ($Identity == 3) { //修理厂 $discount = QuotationService::getpriceratio($goods['OrganID'], $OrganID); $data[$key]['PriceRatio'] = $discount['discount'] ? $discount['discount'] . '%' : "100%"; $DisPrice = sprintf("%.2f", $goods['Price'] * $data[$key]['PriceRatio'] / 100); // 折扣价,小数点后面保留两位 if ($goods['IsPro'] == 1) { //促销商品 $ProPrice = empty($goods['ProPrice']) || $goods['ProPrice'] == 0 ? $DisPrice : $goods['ProPrice']; // 促销价 $data[$key]['Price'] = $ProPrice < $DisPrice ? $ProPrice : $DisPrice; } else { //非促销商品 $data[$key]['Price'] = $DisPrice; //折扣价 } } elseif ($Identity == 2) { //经销商 $data[$key]['Price'] = $goods['Price']; //参考价 } } return $data; }