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