public function actionSavescheme() { $params['quoname'] = Yii::app()->request->getParam('quoname'); $params['quosn'] = Yii::app()->request->getParam('quosn'); $params['totalprices'] = Yii::app()->request->getParam('totalprices'); $params['shipprices'] = 0; $params['quoprices'] = $params['totalprices']; $params['filename'] = Yii::app()->request->getParam('filename'); $params['fileurl'] = Yii::app()->request->getParam('fileurl'); $params['quoids'] = Yii::app()->request->getParam('quoids'); $params['quoprice'] = Yii::app()->request->getParam('quoprice'); $params['quonum'] = Yii::app()->request->getParam('quonum'); $params['sid'] = Yii::app()->request->getParam('sid'); $params['quoid'] = Yii::app()->request->getParam('quoid'); $params['schid'] = Yii::app()->request->getParam('schid'); if (!$params['schid']) { if ($params['quoid']) { QuotationService::getschemecount(array('type' => 1, 'quoid' => $params['quoid'])); } QuotationService::newscheme($params); } else { //编辑报价单方案 QuotationService::editscheme($params); } }
public static function newscheme($params) { $organID = Yii::app()->user->getOrganID(); $time = $_SERVER['REQUEST_TIME']; //查询是否已根据询价单建立了报价单 $quoID = self::ifsendquo(array('inqid' => $params['inqid'])); $params['sid'] = self::getinq_sid($params['inqid']); if (!$quoID) { //新建报价单 $quodatas['InquiryID'] = $params['inqid']; $quodatas['DealerID'] = $organID; $quodatas['ServiceID'] = $params['sid']; $quodatas['SorceID'] = $params['sid']; $quodatas['Status'] = '1'; $quodatas['CreateTime'] = $time; $quodatas['UpdateTime'] = $time; $quodatas['QuoSn'] = $params['quosn']; $quodatas['Title'] = $params['quoname']; $result = Yii::app()->papdb->createCommand()->insert('pap_quotation', $quodatas); $quoID = Yii::app()->papdb->getLastInsertID(); } else { $p['type'] = 1; $p['quoid'] = $quoID; QuotationService::getschemecount($p); $quodatas['UpdateTime'] = $time; $quodatas['Title'] = $params['quoname']; $result = Yii::app()->papdb->createCommand()->update('pap_quotation', $quodatas, 'QuoID=' . $quoID); } //新建报价单方案 $datas['QuoID'] = $quoID; $datas['TotalFee'] = $params['quoprices']; $datas['GoodFee'] = $params['totalprices']; $datas['ShipFee'] = $params['shipprices']; $datas['Status'] = '1'; $datas['CreateTime'] = $time; $datas['UpdateTime'] = $time; //保存附件 if ($params['fileurl']) { $datas['FileName'] = $params['filename']; $datas['FileUrl'] = $params['fileurl']; } $result = Yii::app()->papdb->createCommand()->insert('pap_quotation_scheme', $datas); $SchID = Yii::app()->papdb->getLastInsertID(); //获取商品信息 $goodsinfo = array(); $goodsids = explode(',', $params['quoids']); $goodsnum = explode(',', $params['quonum']); $goodsprice = explode(',', $params['quoprice']); //插入报价单商品 $sql = 'INSERT INTO `pap`.`pap_quotation_goods` (`SchID`, `GoodsID`, `Num`, `Price`,`Version`) VALUES'; foreach ($goodsids as $key => $v) { if ($v) { $version = QuotationService::getgoodsversion($goodsids[$key]); $version = $version ? $version : 0; $sql .= "({$SchID},{$goodsids[$key]},{$goodsnum[$key]},{$goodsprice[$key]},{$version}),"; } } $sql = rtrim($sql, ',') . ';'; $res = Yii::app()->papdb->createCommand($sql)->execute(); echo json_encode(array('quoid' => $quoID, 'count' => $res, 'schid' => $SchID, 'success' => true)); }
public function actionMakescheme() { $inqid = Yii::app()->request->getParam('inqid'); //获取询价单发送方id $params['sid'] = InquiryService::getinq_sid($inqid); $edit = 0; if (Yii::app()->request->isAjaxRequest) { $buy = InquiryService::getnulllists(); $params['searchtype'] = Yii::app()->request->getParam('searchtype'); $params['keyword'] = Yii::app()->request->getParam('keyword'); $params['standcode'] = Yii::app()->request->getParam('standcode'); $params['Make'] = Yii::app()->request->getParam('make'); $params['Car'] = Yii::app()->request->getParam('car'); $params['Year'] = Yii::app()->request->getParam('year'); $params['Model'] = Yii::app()->request->getParam('model'); $params['page'] = Yii::app()->request->getParam('page'); if ($params['Make'] && $params['standcode']) { $params['rows'] = 5; } $params['partslevel'] = Yii::app()->request->getParam('partslevel'); } else { $this->pageTitle = Yii::app()->name . ' - 报价单 -选择商品'; $inqres = InquiryService::getinqinfo($inqid); if ($inqres['baseinfo']['Make']) { $params['Make'] = $inqres['baseinfo']['Make']; $params['Car'] = $inqres['baseinfo']['Car']; $params['Year'] = $inqres['baseinfo']['Year']; $params['Model'] = $inqres['baseinfo']['Model']; } //获取经销商信息 $organID = Yii::app()->user->getOrganID(); $organparams['organID'] = $organID; $organparams['identity'] = 2; $dealer = QuotationService::getorganinfo($organparams); //是否编辑 $editparams['schid'] = Yii::app()->request->getParam('schid'); $getquoid['type'] = 2; $getquoid['inqid'] = $inqid; $editparams['quoid'] = InquiryService::ifsendquo($getquoid); if ($editparams['schid']) { //获取方案信息 $schres = QuotationService::getschemedetails($editparams); $buy = $schres['buylist']; $edit = 1; } else { if ($editparams['schid'] == null && $editparams['quoid']) { //查看已添加方案个数 $quo = QuotationService::getschemecount(array('quoid' => $editparams['quoid'])); $dealer['Title'] = $quo['Title']; $dealer['QuoSn'] = $quo['QuoSn']; $edit = 2; } $buy = InquiryService::getnulllists(); } } //获取商品列表 $goodslist = QuotationService::getgoods($params); if (Yii::app()->request->isAjaxRequest) { $this->render('makescheme', array('goodslist' => $goodslist, 'buy' => $buy)); } else { //获取经销商最小交易金额 $minturnover = QuotationService::getminturnover($organID); $this->render('makescheme', array('service' => $service, 'goodslist' => $goodslist, 'buy' => $buy, 'dealer' => $dealer, 'edit' => $edit, 'schinfo' => $schres['schinfo'], 'inqres' => $inqres, 'minturnover' => $minturnover)); } }