public function actionUpdate() { $organID = Commonmodel::getOrganID(); $userID = Yii::app()->user->id; $goodsID = $_GET['id']; if ($_POST) { $data['Name'] = trim($_POST['Name']); if (trim($_POST['Pinyin']) == "") { $pinyin = F::Pinyin1($_POST['Name']); // 如果未输入拼音则自动添加拼音 } else { $pinyin = trim($_POST['Pinyin']); } $data['Pinyin'] = $pinyin; $data['GoodsNO'] = trim($_POST['GoodsNO']); if (!empty($_POST['OENOS'][0])) { $data['OENO'] = $_POST['OENOS'][0]; } $data['PartsLevel'] = trim($_POST['PartsLevel']); $data['Memo'] = trim($_POST['Memo']); $data['Price'] = trim($_POST['Price']); $data['Unit'] = trim($_POST['Unit']); $LogisticsPrice = trim($_POST['LogisticsPrice']); if (empty($LogisticsPrice)) { $data['LogisticsPrice'] = 0; } else { $data['LogisticsPrice'] = $LogisticsPrice; } if (empty($_POST['goodsBrand'])) { $data['BrandID'] = trim($_POST['goodsBrand']); // id $data['Brand'] = ''; // 名称 } else { if (!empty($_POST['goodsBrand'])) { $data['BrandID'] = trim($_POST['goodsBrand']); // id $data['Brand'] = trim($_POST['brandID']); // 名称 } } // if (!empty($_POST['leafCategory'])) { // $data['BigParts'] = $_POST['mainCategory']; // 配件大类 // $data['SubParts'] = $_POST['subCategory']; // 配件子类 // $data['CpName'] = $_POST['leafCategory']; // 标准名称 $data['CpNameTxt'] = $_POST['CpNameTxt']; // 标准名称 $goodsspec['JiapartsNO'] = $data['BrandID']; // 加配号 // } // if (!empty($_POST['IsUpSale'])) { $data['IsSale'] = $_POST['IsUpSale']; // } // $model = new DealerGoods(); $model = DealerGoods::model()->findByPk($goodsID); // var_dump($data);exit; $model->attributes = $data; $oenos = $_POST['OENOS'] ? $_POST['OENOS'] : $_POST['OENO']; if ($oenos) { foreach ($oenos as $value) { $oe .= $value; } } else { $oe = ''; } $make_hidden = explode(',', $_POST["make_hidden"]); $make_hidden = array_unique($make_hidden); $make_hidden = array_filter($make_hidden); $make_hidden = implode(',', $make_hidden); $model->Title = $data['Name'] . ' ' . $pinyin . ' ' . $data['Brand'] . ' ' . $oe . ' ' . $make_hidden; // $model->CreateTime = time(); $model->UpdateTime = time(); if ($this->Isexist($data['GoodsNO'], $goodsID)) { // 修改 if ($model->save()) { $make = explode(',', $_POST["make"]); $car = explode(',', $_POST["car"]); $year = explode(',', $_POST["year"]); $model2 = explode(',', $_POST["model"]); $maketext = explode(',', $_POST["maketxt"]); $cartext = explode(',', $_POST["cartxt"]); $modeltext = explode(',', $_POST["modeltxt"]); // 把主营车系添加到商品车系关系表 $vehlegth = count($make); for ($i = 0; $i < $vehlegth; $i++) { if ($make[$i] != 0) { $goodsv = new DealerGoodsVehicleRelation(); // 车型车系 $goodsv->OrganID = $organID; $goodsv->GoodsID = $goodsID; $goodsv->Make = $make[$i]; $goodsv->Car = $car[$i]; $goodsv->Year = $year[$i]; $goodsv->Model = $model2[$i]; $goodsv->Marktxt = $maketext[$i]; $goodsv->Cartxt = $cartext[$i]; $goodsv->Modeltxt = $modeltext[$i]; $goodsv->save(); } } $sql = "update tbl_dealer_goods_vehicle_relation set GoodsID = {$goodsID} where OrganID = {$organID} and GoodsID = 0"; $b = DBUtil::execute($sql); // 把OENO号添加到关系表里 $oenos = $_POST['OENOS']; $oelegth = count($oenos); DealerGoodsOenoRelation::model()->deleteAll("OrganID= '{$organID}' and GoodsID='{$goodsID}'"); for ($i = 0; $i < $oelegth; $i++) { $goodsoeno = new DealerGoodsOenoRelation(); // OE号关系表 $goodsoeno->OrganID = $organID; $goodsoeno->GoodsID = $goodsID; $goodsoeno->OENO = $oenos[$i]; $goodsoeno->save(); } // 添加商品图片 // $goodsImages = $_POST['goodsImages']; // $imglegth = count($goodsImages); // for ($i = 0; $i < $imglegth; $i++) { // $goodsImg = new DealerGoodsImageRelation(); // $goodsImg->GoodsID = $goodsID; // $goodsImg->OrganID = $organID; // $goodsImg->ImageUrl = $goodsImages[$i]; // $goodsImg->save(); // } $urlimg = explode(',', $_POST['urlimg']); //根据逗号拆分,得到图片信息的字符串 $sqlimg = "insert into tbl_dealer_goods_image_relation (OrganID,GoodsID,ImageUrl,CreateTime,ImageName) values"; foreach ($urlimg as $k => $value) { if ($value) { //去掉初始值0 $addimg = explode(';', $value); //根据分号拆分,得到图片的相关信息 if ($k != 1) { $sqlimg .= ","; } $sqlimg .= "("; $sqlimg .= $organID; $sqlimg .= ","; $sqlimg .= $goodsID; //商品ID $sqlimg .= ",'"; $sqlimg .= $addimg[0]; //图片url $sqlimg .= "',"; $sqlimg .= time(); $sqlimg .= ",'"; $sqlimg .= $addimg[1]; //图片原名 $sqlimg .= "')"; } } DBUtil::execute($sqlimg); // 添加商品属性 if ($goodsImages) { $goodsspec['ImageUrl'] = $goodsImages[0]; } if ($_POST['detcImages']) { $goodsspec['DetectionImg'] = $_POST['detcImages']; } // 添加商品属性 $goodsspec['Weight'] = $_POST['Weight']; // 重量 $goodsspec['Length'] = $_POST['Length']; // 长 $goodsspec['Wide'] = $_POST['Wide']; // 宽 $goodsspec['Height'] = $_POST['Height']; // 高 $goodsspec['Volume'] = $_POST['Volume']; //体积 $goodsspec['ValidityType'] = $_POST['ValidityType']; // 保质期类型 $goodsspec['ValidityDate'] = $_POST['ValidityDate']; // 保质期 $goodsspec['BganCompany'] = $_POST['BganCompany']; // 标杆公司 $goodsspec['BganGoodsNO'] = $_POST['BganGoodsNO']; // 标杆商品号 $goodsspec['Specifica'] = $_POST['Specifica']; // 规格 $goodsspec['PartsNO'] = $_POST['PartsNO']; // 配件类别 $goodsspec['Unit'] = trim($_POST['Unit']); $psid = DealerGoodsSpec::model()->find("GoodsID={$goodsID}")->attributes['ID']; $goodssp = DealerGoodsSpec::model()->findByPk($psid); if (empty($psid)) { $goodssp = new DealerGoodsSpec(); } $goodssp->attributes = $goodsspec; $goodssp->GoodsID = $goodsID; $goodssp->save(); // 添加商品包装 $goodspack['MinQuantity'] = $_POST['MinQuantity']; // $goodspack['Weight'] = $_POST['pWeight']; // $goodspack['Volume'] = $_POST['pVolume']; // $pcid = DealerGoodsPack::model()->find("GoodsID={$goodsID}")->attributes['ID']; $goodspc = DealerGoodsPack::model()->findByPk($pcid); if (empty($pcid)) { $goodspc = new DealerGoodsPack(); } $goodspc->attributes = $goodspack; $goodspc->GoodsID = $goodsID; $goodspc->save(); // $bool2 = DealerGoodsPack::model()->updateAll(array( // 'MinQuantity' => $goodspack['MinQuantity'], // 'Weight' => $goodspack['Weight'], // 'Volume' => $goodspack['Volume'], // ), "GoodsID=" . $goodsID); $rs = array('success' => 1, 'errorMsg' => '修改数据成功'); } else { $rs = array('success' => 0, 'errorMsg' => '修改数据失败'); } } else { $rs = array('success' => 0, 'errorMsg' => '商品编号已存在,请修改!'); } } echo json_encode($rs); }
private static function getGoodsImage($goodsID) { $criteria = new CDbCriteria(); $criteria->select = "ImageUrl"; $criteria->condition = "t.GoodsID = " . $goodsID; $model = DealerGoodsSpec::model()->find($criteria); return $model->ImageUrl; }