public function actionPartsservice()
{
$ID = $_POST['ID'];
$criteria = new CDbCriteria();
$criteria->addCondition("t.ServiceID = {$ID}", "AND");
$criteria->addCondition("t.Status = 0", "AND");
$criteria->order = "t.UpdateTime DESC,t.ID DESC";
//排序条件:t.UpdateTime,t.ID倒叙
$model = CarServiceParts::model()->findAll($criteria);
foreach ($model as $key => $value) {
$data[$key] = $value->attributes;
if ($value['OperateType'] == '1') {
$data[$key]['Type'] = '更换';
} else {
$data[$key]['Type'] = '维修';
}
$data[$key]['OperateType'] = $value['OperateType'];
$partName = explode(',', $value['PartName']);
$data[$key]['mainCategory'] = $partName[0];
$data[$key]['subCategory'] = $partName[1];
$data[$key]['leafCategory'] = $partName[2];
if (is_numeric($partName[0])) {
$data[$key]['PartName'] = F::msubstr(Commonmodel::getCategory($partName[0]) . "," . Commonmodel::getCategory($partName[1]) . "," . Commonmodel::getCategory($partName[2]));
}
$data[$key]['TechnicianName'] = $value['TechnicianName'];
$data[$key]['RepairCause'] = $value['RepairCause'];
$data[$key]['RevisedNote'] = $value['RevisedNote'];
$data[$key]['UpdateTime'] = F::msubstr(date('Y-m-d', $value['UpdateTime']));
}
$rs = array('rows' => $data ? $data : array());
echo json_encode($rs);
}
/**
* 通过GoodsID查询商品
*/
public static function getGoodsByID($goodsID)
{
$criteria = new CDbCriteria();
$criteria->select = "*";
$criteria->order = 'ID DESC';
$criteria->condition = " IsSale = 1 and ISdelete = 1";
// 上架的和没有删除的商品
$criteria->addCondition("ID = {$goodsID}");
$goodses = DealerGoods::model()->findAll($criteria);
$data = array();
foreach ($goodses as $key => $goods) {
$price = self::getContactprice($goods['OrganID'], '');
$data[$key]['PriceRatio'] = $price['PriceRatio'] ? $price['PriceRatio'] : "100%";
$data[$key]['ID'] = $goods['ID'];
$data[$key]['OrganID'] = $goods['OrganID'];
$organInfo = self::getOrganName($goods['OrganID']);
$data[$key]['OrganName'] = $organInfo['organName'];
$data[$key]['QQ'] = $organInfo['QQ'];
$data[$key]['Phone'] = $organInfo['Phone'];
$data[$key]['ContactPhone'] = $organInfo['ContactPhone'];
$data[$key]['Name'] = $goods['Name'];
$data[$key]['Pinyin'] = $goods['Pinyin'];
$data[$key]['Brand'] = $goods['Brand'];
$data[$key]['goodsBrand'] = $goods['Brand'];
$data[$key]['GoodsNO'] = $goods['GoodsNO'];
$data[$key]['OENO'] = $goods['OENO'];
$data[$key]['PartsLevel'] = $goods['PartsLevel'];
$data[$key]['Memo'] = $goods['Memo'];
$data[$key]['ListPrice'] = $goods['Price'];
//参考价
$data[$key]['Price'] = sprintf("%.2f", $goods['Price'] * $data[$key]['PriceRatio'] / 100);
// 折扣价,小数点后面保留两位
if ($goods['IsPro'] == 1) {
if (empty($goods['ProPrice']) || $goods['ProPrice'] == 0) {
$data[$key]['ProPrice'] = $data[$key]['Price'];
// 促销价
} else {
$data[$key]['ProPrice'] = $goods['ProPrice'];
// 促销价
}
}
$data[$key]['LogisticsPrice'] = $goods['LogisticsPrice'];
// 物流价
$data[$key]['BigParts'] = Commonmodel::getCategory($goods['BigParts']);
$data[$key]['SubParts'] = Commonmodel::getCategory($goods['SubParts']);
$data[$key]['CpName'] = Commonmodel::getCategory($goods['CpName']);
$data[$key]['CpNameTxt'] = $goods['CpNameTxt'];
$vehs = explode('、', self::getVehicleByGoodsID($goods['ID']));
$data[$key]['Vehicle'] = $vehs[0];
$data[$key]['IsSale'] = $goods['IsSale'] == 1 ? '已上架' : '已下架';
// 商品属性
$data[$key]['ID'] = $goods['ID'];
$data[$key]['Weight'] = $goods->goodsspec->Weight;
$data[$key]['Length'] = $goods->goodsspec->Length;
$data[$key]['Wide'] = $goods->goodsspec->Wide;
$data[$key]['Height'] = $goods->goodsspec->Height;
$data[$key]['Volume'] = $goods->goodsspec->Volume;
$data[$key]['ValidityDate'] = $goods->goodsspec->ValidityDate;
$data[$key]['ValidityType'] = $goods->goodsspec->ValidityType;
if ($data[$key]['ValidityType'] == 1) {
$data[$key]['Validity'] = '不保修';
}
if ($data[$key]['ValidityType'] == 2) {
$data[$key]['Validity'] = '保装车';
}
if ($data[$key]['ValidityType'] == 3) {
$data[$key]['Validity'] = $data[$key]['ValidityDate'] . '个月';
}
$data[$key]['Specifica'] = $goods->goodsspec->Specifica;
$data[$key]['Unit'] = $goods->goodsspec->Unit;
$data[$key]['BganCompany'] = $goods->goodsspec->BganCompany;
$data[$key]['BganGoodsNO'] = $goods->goodsspec->BganGoodsNO;
$data[$key]['PartsNO'] = $goods->goodsspec->PartsNO;
$data[$key]['JiapartsNO'] = $goods->goodsspec->JiapartsNO;
// 嘉配号
$data[$key]['ImageUrl'] = $goods->goodsspec->ImageUrl;
// 图像
$data[$key]['DetectionImg'] = $goods->goodsspec->DetectionImg;
// 检测图像
// 商品包装
$data[$key]['pWeight'] = $goods->goodspack->Weight;
$data[$key]['pLength'] = $goods->goodspack->Volume;
$data[$key]['MinQuantity'] = $goods->goodspack->MinQuantity;
// OE号
$data[$key]['OENOS'] = self::getOENOSByGoodsID($goodsID);
// 车型车系
$data[$key]['Vehicles'] = self::getVehicleByGoodsID($goodsID);
// 图片
$data[$key]['Images'] = DealerGoods::getImagesByGoodsID($goodsID);
}
return $data;
}
