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;
}
