public function actionImportgoods()
{
$userID = Yii::app()->user->id;
$organID = Commonmodel::getOrganID();
$sql = "select * from tbl_make_goods_temp where OrganID = " . $organID . ' and UserID = ' . $userID;
$datas = DBUtil::queryAll($sql);
$bool = false;
foreach ($datas as $value) {
if (!empty($value['goods_no'])) {
$res = MakeGoodsVersion::model()->findAll('goods_no=:goodsno and organID=:organID', array(':goodsno' => $value['goods_no'], ':organID' => $organID));
if (count($res) > 0) {
echo json_encode(array('errMsg' => '商品编号重复,请重新填写', 'success' => false));
Yii::app()->end();
}
}
$makegoods = new MakeGoods();
$makegoods->NewVersion = '001';
$makegoods->organID = $organID;
$makegoods->userID = $userID;
$makegoods->create_time = time();
$makegoods->IsSale = 0;
$makegoods->ISdelete = 0;
if ($makegoods->save()) {
$bool = true;
$lastGoodsID = Yii::app()->db->getLastInsertID();
$makegoodsvesion = new MakeGoodsVersion();
$makegoodsvesion->version_name = '001';
$makegoodsvesion->organID = $organID;
$makegoodsvesion->userID = $userID;
$makegoodsvesion->goods_id = $lastGoodsID;
$makegoodsvesion->goods_brand = $this->getBrandID($value['brand']);
//$value['brand'];
$makegoodsvesion->goods_no = $value['goods_no'];
$makegoodsvesion->goods_name = $value['goods_name'];
$makegoodsvesion->benchmarking_brand = $value['benchmarking_brand'];
$makegoodsvesion->benchmarking_sn = $value['benchmarking_sn'];
$makegoodsvesion->standard_id = $this->cpnameID($value['category']);
//$value['category'];
$makegoodsvesion->marketprice = $value['marketprice'];
$makegoodsvesion->salesprice = $value['salesprice'];
$makegoodsvesion->discountprice = $value['discountprice'];
$makegoodsvesion->inventory = $value['inventory'];
$makegoodsvesion->senddays = $value['senddays'];
$makegoodsvesion->description = $value['description'];
$makegoodsvesion->ISdelete = 0;
if ($makegoodsvesion->save()) {
MakeGoodsTemp::model()->deleteByPk($value['id']);
}
}
}
if ($bool) {
echo json_encode(array('success' => $bool, 'errMsg' => '导入商品数据成功'));
} else {
echo json_encode(array('success' => $bool, 'errMsg' => '导入商品数据失败'));
}
}
