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' => '导入商品数据失败')); } }