public function actionViewquo() { $quoID = Yii::app()->request->getParam('quoID'); $result = QuotationService::getschemelists(array('quoid' => $quoID, 'type' => 2)); $schinfo = $result['schinfo']; $quoinfo = $result['quoinfo']; $organparams['organID'] = $quoinfo['ServiceID']; $organparams['identity'] = 3; $organparams['quoid'] = $quoID; $service = QuotationService::getorganinfo($organparams); $organparams['organID'] = $quoinfo['DealerID']; $organparams['identity'] = 2; $dealer = QuotationService::getorganinfo($organparams); $this->render('quodetails', array('service' => $service, 'schinfo' => $schinfo, 'dealer' => $dealer, 'quoinfo' => $quoinfo)); }
public static function remindService($params) { $service = ' select OrganName,Phone from jpd_organ where ID=' . $params['OrganID']; $serviceres = Yii::app()->jpdb->createCommand($service)->queryRow(); $scheme = 'SELECT SchID FROM `pap_quotation_scheme` where QuoID=' . $params['quoID']; $schemeres = Yii::app()->papdb->createCommand($scheme)->queryRow(); //获取支付方式折扣率 $discount = PapOrderDiscount::model()->find('OrderType=:OrderType', array(':OrderType' => 2)); if ($discount) { if ($params['Payment'] == 1) { $factdiscount = $discount['OrderAlipay'] ? $discount['OrderAlipay'] : 100; } else { if ($params['Payment'] == 2) { $factdiscount = $discount['OrderLogis'] ? $discount['OrderLogis'] : 100; } } } else { $factdiscount = 100; } $totalprices = self::Getsumprices($schemeres['SchID'], $factdiscount, trim($params['DealerID'], ',')); $msg = '尊敬的' . $serviceres['OrganName'] . '客户,您的报价单方案已生成,总计' . $totalprices . '元。回复 ' . $params['checkSN'] . 'Y 确认、' . $params['checkSN'] . 'N 拒绝。详情:'; $dealerinfo = QuotationService::getorganinfo(array('organID' => trim($params['DealerID'], ','), 'identity' => 2)); //收货地址 $addressql = ' select ContactName,State,City,District,Address from jpd_receive_address where ID=' . $params['AddressID']; $address = Yii::app()->jpdb->createCommand($addressql)->queryRow(); $address['site'] = Area::getaddress($address['State'], $address['City'], $address['District']) . $address['Address']; //获取报价单商品 $goodssql = ' SELECT GoodsID,Num from pap_quotation_goods where SchID=' . $schemeres['SchID']; $goodses = Yii::app()->papdb->createCommand($goodssql)->queryAll(); foreach ($goodses as $g) { $sql = ' select Name from pap_goods where ID=' . $g['GoodsID']; $gres = Yii::app()->papdb->createCommand($sql)->queryRow(); $msg .= $gres['Name'] . ',' . $g['Num'] . '个;'; } $msg .= '收货地址:' . $address['site'] . ';收货人:' . $address['ContactName'] . '。若有疑问请联系经销商:' . $dealerinfo['OrganName'] . ',电话:' . $dealerinfo['Phone'] . '。'; $res = F::sendSMS(array('msg' => $msg, 'phone' => $serviceres['Phone'])); if ($res['code'] == 0) { //发送成功,添加报价单短信确认数据 $time = $_SERVER['REQUEST_TIME']; $insertsql = ' insert into pap_quotation_confirm (QuoID,DealerID,ServiceID,CreateTime) values(' . $params['quoID'] . $params['DealerID'] . $params['OrganID'] . ',' . $time . ')'; $count = Yii::app()->papdb->createCommand($insertsql)->execute(); } return $res; }
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)); } }