public static function sendquo($inqid) { $time = $_SERVER['REQUEST_TIME']; //查看询价单是否是客服代发 $inqsql = ' select InquiryID,`State`,OrganID,Payment,AddressID,DealerID from `pap_inquiry` where InquiryID=' . $inqid; $res = Yii::app()->papdb->createCommand($inqsql)->queryRow(); $quoid = self::ifsendquo(array('inqid' => $inqid)); //更新报价单状态 if ($res['State'] == 1) { //生成确认码 $checksn = self::getCheckSn($res['OrganID']); $sql = 'update pap_quotation set Status="1",IfSend="2",CheckSn="' . $checksn . '",UpdateTime=' . $time . ' where QuoID=' . $quoid; } else { $sql = 'update pap_quotation set Status="1",IfSend="2",UpdateTime=' . $time . ' where QuoID=' . $quoid; } $count = Yii::app()->papdb->createCommand($sql)->execute(); //更新询价单状态 $inqsql = 'update pap_inquiry set Status=1,UpdateTime=' . $time . ' where InquiryID=' . $inqid . ' and Status=0'; Yii::app()->papdb->createCommand($inqsql)->execute(); if ($res['State'] == 1 && $count > 0) { //客服代发询价单制作报价单后用短信通知修理厂 $sms = self::remindService(array_merge($res, array('quoID' => $quoid, 'checkSN' => $checksn))); if ($sms['code'] == 0) { $msg = '短信提醒发送失败'; } else { $msg = '短信提醒发送失败!' . $sms['SMS']; } //给修理厂发送提醒 但是不发送短信 $link = Yii::app()->createUrl('pap/inquiryorder/inquirydetail', array('inquiryID' => $inqid)); $params = array('OrganID' => $res['OrganID'], 'OrganType' => 3, 'HandleID' => $quoid, 'link' => $link); $params['type'] = array('name' => 'BJD', 'key' => 3); $r = RemindService::sendRemind($params); } elseif ($count > 0) { //给修理厂发送提醒 $link = Yii::app()->createUrl('pap/inquiryorder/inquirydetail', array('inquiryID' => $inqid)); $params = array('OrganID' => $res['OrganID'], 'OrganType' => 3, 'HandleID' => $quoid, 'link' => $link); $params['type'] = array('name' => 'BJD', 'key' => 3); $r = RemindService::sendRemind($params); } if ($count > 0) { //更改询价单待报价状态为已处理 $organID = Yii::app()->user->getOrganID(); $sql = 'update pap_remind_business set HandleStatus=2 where HandleID=' . $inqid . ' and OrganID=' . $organID; Yii::app()->papdb->createCommand($sql)->execute(); } echo json_encode(array('count' => $count, 'msg' => $msg)); }
/** * 经销商物流退款-已收货 */ public function actionReturnpost() { $this->pageTitle = Yii::app()->name . '-' . "付款"; $returnID = Yii::app()->request->getParam("returnID"); $returninfo = PapReturnOrder::model()->findBypk($returnID); if ($returninfo->Status != 1) { $this->redirect(array('Index')); exit; } //添加收货地址 $addressID = Yii::app()->request->getParam("addressID"); if (!$addressID) { $this->redirect(array('/pap/dealerreturn/index')); } $ship = $this->getShip($addressID); if (!$ship) { $this->redirect(array('/pap/dealerreturn/index')); } OrderreturnService::savereturnaddress($ship); if ($returnID) { PapReturnOrder::model()->updateBypk($returnID, array('Status' => 2, 'PayMethod' => 2)); //更改待审核提醒为已操作 RemindService::updateRemindStatus($returnID, 4, $returninfo['DealerID']); //发送待发货提醒给修理厂 $params = array('OrganID' => $returninfo['ServiceID'], 'OrganType' => 3, 'HandleID' => $returnID); $params['type'] = array('name' => 'THD', 'key' => 5); RemindService::sendRemind($params, $returninfo); $this->redirect(array('Index')); } else { throw new CHttpException(404, '页面不存在'); } }
/** * 响应嘉配订单支付通知 * * @author Garbin * @param int $order_id * @param array $notify_result * @return bool */ public static function respondNotify($order_id, $notify_result) { $where = "ID = {$order_id}"; //$data = array('RefundStatus' => $notify_result['trade_status']); // $orderdata=array('ReturnStatus'=>'1','Status' => $notify_result['target']); switch ($notify_result['target']) { case RORDER_READY: $where .= ' AND Status <= ' . RORDER_PENDING; $data['AlipayTN'] = $notify_result['trade_no']; $data['Status'] = RORDER_READY; break; case RORDER_PENDING: // 付款, 待发货 $where .= ' AND Status <= ' . RORDER_PENDING; $data['AlipayTN'] = $notify_result['trade_no']; $data['Status'] = RORDER_PENDING; $data['CreateTime'] = time(); //更改提醒状态为已操作 $returninfo = PapReturnOrder::model()->findByPk($order_id); RemindService::updateRemindStatus($order_id, 4, $returninfo['DealerID']); //发送待发货提醒给修理厂 $params = array('OrganID' => $returninfo['ServiceID'], 'OrganType' => 3, 'HandleID' => $order_id); $params['type'] = array('name' => 'THD', 'key' => 5); RemindService::sendRemind($params, $returninfo); break; case RORDER_ACCEPTED: // 待收货 $where .= ' AND Status <= ' . RORDER_ACCEPTED; $where .= ' AND Status >= ' . RORDER_PENDING; $data['Status'] = RORDER_ACCEPTED; $data['DeliveryTime'] = time(); break; case RORDER_ABNORMAL: //已收货,完成 $where .= ' AND Status <= ' . RORDER_ABNORMAL; $where .= ' AND Status >= ' . RORDER_ACCEPTED; $data['Status'] = RORDER_ABNORMAL; $return = PapReturnGoods::model()->find('ReturnID=:returnID', array(':returnID' => $order_id)); if ($return) { $orderID = $return['OrderID']; if ($orderID) { $wheres = "ID = {$orderID}"; PapOrder::model()->updateAll(array('ReturnStatus' => 4), $wheres); } } break; // case RORDER_READY_PAYPAL://退款 待付款 // $where .= ' AND Status = ' . RORDER_READY_PAYPA; // $data['Status']=RORDER_READY_PAYPAL; // break; // case RORDER_PAYPAL_FINISHED://退款完成 // $where .= ' AND Status =' .RORDER_PAYPAL_FINISHED; // $data['Status']=RORDER_PAYPAL_FINISHED; // break; } //PapReturnOrder::model()->updateByPk($order_id,$data) //PapReturnOrder::model()->updateAll($data, $where) if (PapReturnOrder::model()->updateAll($data, $where)) { return true; } else { return false; } }
public static function sendOrder($params, $ID, $OrganID) { $sql = "select * from pap_order t where t.SellerID = {$OrganID} and t.IsDelete=0 and Status=2 and t.ID in({$ID})"; $model = Yii::app()->papdb->createCommand($sql)->queryAll(); if (!$model) { return array('error' => 4, 'msg' => '发货失败,请稍后再试!'); } $goodsid = explode(',', $params['goodsid']); $pn = explode('|', $params['PN']); $idarr = explode(',', $ID); if (count($model) != count($idarr)) { return array('error' => 1, 'msg' => '发货失败,请稍后再试!'); } foreach ($model as $v) { // 如果是支付宝订单,则调用确认收货接口 $isAlipay = false; $alipayResult = false; $alipayError = ""; $paymentMethod = $v['Payment']; if ($paymentMethod == '1') { $isAlipay = true; // 订单交易号是否存在 if (!$v['AlipayTN']) { return array('error' => 2, 'msg' => '订单支付信息错误'); Yii::app()->end(); } $payment = Yii::app()->alipay; // 确认收货请求参数 $request = new AlipaySendConfirmRequest(); $request->trade_no = $v['AlipayTN']; if ($params['ShipSn']) { $request->invoice_no = $params['ShipSn']; } $request->logistics_name = $params['ShipLogis']; $request->transport_type = "EXPRESS"; // var_dump($request).'<br>'; //建立请求 $html_text = $payment->buildRequestHttp($request); //解析XML //注意:该功能PHP5环境及以上支持,需开通curl、SSL等PHP配置环境。建议本地调试时使用PHP开发软件 $doc = new DOMDocument(); $doc->loadXML($html_text); if (!empty($doc->getElementsByTagName("alipay")->item(0)->nodeValue)) { $alipay = $doc->getElementsByTagName("alipay")->item(0); //echo $alipay->nodeValue; $is_success = $alipay->getElementsByTagName("is_success")->item(0)->nodeValue; if ($is_success == 'T') { $alipayResult = true; } else { $alipayResult = false; $alipayError = $alipay->getElementsByTagName("error")->item(0)->nodeValue; } } // 记录日志 $userId = Yii::app()->user->id; $payment->put_send_goods_log($v, $request->getParams(), $html_text, $alipayResult, $userId); } // 如果是支付宝,并且支付宝接口返回成功 或者 不是支付宝,保存物流信息 $bool = false; if (!$isAlipay || $isAlipay && $alipayResult) { $bool = PapOrder::model()->updateByPk($v['ID'], array('Status' => 3, 'UpdateTime' => time(), 'DeliveryTime' => time(), 'ShipSn' => $params['ShipSn'], 'ShipLogis' => $params['ShipLogis'], 'PayStatus' => $isAlipay === true ? 'WAIT_BUYER_CONFIRM_GOODS' : '')); if ($bool) { //更新待发货提醒状态 RemindService::updateRemindStatus($v['ID'], 2, $v['SellerID']); //待收货提醒给修理厂 $params = array('OrganID' => $v['BuyerID'], 'OrganType' => 3, 'HandleID' => $v['ID']); $params['type'] = array('name' => 'DD', 'key' => 2); RemindService::sendRemind($params, $v); } } else { return array('error' => 3, 'msg' => '支付宝接口繁忙,请重新发货!'); } } //订单商品 if ($goodsid && $pn) { foreach ($goodsid as $k => $v) { if (preg_match('/^[A-Za-z0-9][A-Za-z0-9,,-]*$/', $pn[$k])) { PapOrderGoods::model()->updateByPk($v, array('PN' => $pn[$k], 'UpdateTime' => time())); } } } return array('success' => 1); //$userid = RemindService::getUserID($model[0]['BuyerID']); // return array('success' => 1, 'userid' => $userid); }
public function actionSaveinquiry() { $type = Yii::app()->request->getParam('Type'); $epc = Yii::app()->request->getParam('epc'); $inquiry = array(); //生成询价单编号 $inquiry['InquirySn'] = RPCClient::call('InquiryorderService_setinquirysn'); $inquiry['Make'] = $epc['make']; $inquiry['Car'] = !empty($epc['series']) ? $epc['series'] : '0'; $inquiry['Year'] = !empty($epc['year']) ? $epc['year'] : '0'; $inquiry['Model'] = !empty($epc['model']) ? $epc['model'] : '0'; if (empty($inquiry['Make'])) { $inquiry['Make'] = '0'; $inquiry['Car'] = '0'; $inquiry['Year'] = '0'; $inquiry['Model'] = '0'; } $vin = Yii::app()->request->getParam('VIN'); $inquiry['VIN'] = $vin == '请输入VIN码' ? '' : $vin; $inquiry['Describe'] = Yii::app()->request->getParam('Describe'); $inquiry['CreateTime'] = time(); $inquiry['DealerID'] = Yii::app()->request->getParam('DealerID'); $inquiry['OrganID'] = Yii::app()->user->getOrganID(); //InquirySn是否存在 $ser = RPCClient::call('InquiryorderService_ifexitinquirysn', $inquiry['InquirySn']); if (!empty($ser)) { echo json_encode(array('success' => false, 'message' => '发送失败')); } else { //保存询价单返回inquiryid $saveinquiry = RPCClient::call('InquiryorderService_saveinquiry', $inquiry); if (!empty($saveinquiry)) { $picfiles = Yii::app()->request->getParam('inquiryImages'); if ($picfiles) { $picfilesname = Yii::app()->request->getParam('inquiryImagesname'); $params = array('inquiryID' => $saveinquiry, 'imgs' => $picfiles, 'imgsname' => $picfilesname); //保存上传图片 RPCClient::call('InquiryorderService_savepic', $params); } $aps = Yii::app()->request->getParam('parts'); if ($aps) { $categorydata = array('part' => $aps, 'inquiryID' => $saveinquiry); //保存配件信息 RPCClient::call('InquiryorderService_newPapInquiryCategory', $categorydata); } //询价单制作成功发送消息通知经销商 $params = array('OrganID' => trim($inquiry['DealerID'], ','), 'OrganType' => 2, 'HandleID' => $saveinquiry); $params['type'] = array('name' => 'XJD', 'key' => 3); RemindService::sendRemind($params); echo json_encode(array('success' => true, 'message' => '发送成功')); } } }
public static function sendquo($params) { $time = $_SERVER['REQUEST_TIME']; $sql = ' select ServiceID,IfSend from pap_quotation where QuoID=' . $params['quoid']; $res = Yii::app()->papdb->createCommand($sql)->queryRow(); $sql = 'update pap_quotation set IfSend="2",ServiceID=' . $params['sid'] . ',Status="1",UpdateTime=' . $time; //发送草稿箱内容 if ($params['draft']) { $sql .= ',CreateTime=' . $time; } $sql .= ' where QuoID=' . $params['quoid']; $count = Yii::app()->papdb->createCommand($sql)->execute(); if ($res['IfSend'] == 2 && $res['ServiceID'] != $params['sid']) { //删除业务提醒数据 $delete = 'delete from pap_remind_business where HandleID=' . $params['quoid'] . ' and OrganID=' . $res['ServiceID']; Yii::app()->papdb->createCommand($delete)->execute(); } if ($count > 0 && ($res['IfSend'] == 2 && $res['ServiceID'] != $params['sid'] || $res['IfSend'] == 1)) { //给修理厂发送提醒 $params = array('OrganID' => $params['sid'], 'OrganType' => 3, 'HandleID' => $params['quoid']); $params['type'] = array('name' => 'BJD', 'key' => 3); $r = RemindService::sendRemind($params); } echo json_encode(array('count' => $count)); }
/** * 响应嘉配订单支付通知 * * @author Garbin * @param int $order_id * @param array $notify_result * @return bool */ public static function respondNotify($order_id, $notify_result) { if ($notify_result['target'] == ORDER_PENDING) { return; } $where = "ID = {$order_id}"; $data = array('Status' => $notify_result['target'], 'PayStatus' => $notify_result['trade_status']); $OrganID = Yii::app()->user->getOrganID(); switch ($notify_result['target']) { case ORDER_ACCEPTED: $where .= ' AND Status=' . ORDER_PENDING; //只有待付款的订单才会被修改为已付款 $data['AlipayTN'] = $notify_result['trade_no']; $data['PayTime'] = time(); //更新待付款提醒状态 RemindService::updateRemindStatus($order_id, 1, $OrganID); $sql = 'select SellerID from pap_order where ID=' . $order_id; $res = Yii::app()->papdb->createCommand($sql)->queryRow(); //发送待发货提醒给经销商 $params = array('OrganID' => $res['SellerID'], 'OrganType' => 2, 'HandleID' => $order_id, 'OrderID' => $order_id, 'TotalAmount' => $res['TotalAmount']); $params['type'] = array('name' => 'DD', 'key' => 2); RemindService::sendRemind($params); //赠送积分 self::saveIntegral($params); break; case ORDER_SHIPPED: $where .= ' AND Status=' . ORDER_ACCEPTED; //只有等待发货的订单才会被修改为已发货 $data['DeliveryTime'] = time(); break; case ORDER_FINISHED: $where .= ' AND Status=' . ORDER_SHIPPED; //只有已发货的订单才会被自动修改为交易完成 $data['ReceiptTime'] = time(); break; case ORDER_CANCLED: //任何情况下都可以关闭 /* 加回商品库存 */ break; } switch ($notify_result['refund']) { case 'WAIT_SELLER_AGREE': //待审核 $data['PayStatus'] = 'WAIT_SELLER_AGREE'; $data['ReturnStatus'] = '1'; //$data['AlipayTN'] = $notify_result['trade_no']; break; case 'WAIT_BUYER_RETURN_GOODS': //等待买家发货 $data['PayStatus'] = 'WAIT_BUYER_RETURN_GOODS'; //只有等待发货的订单才会被修改为已发货 $data['ReturnStatus'] = '2'; break; case 'WAIT_SELLER_CONFIRM_GOODS': //等待卖家收货 $data['PayStatus'] = 'WAIT_SELLER_CONFIRM_GOODS'; $data['ReturnStatus'] = '3'; break; case 'REFUND_SUCCESS': //任何情况下都可以关闭 /* 加回商品库存 */ $where .= ' AND Status=' . ORDER_CANCLED; $data['PayStatus'] = 'REFUND_SUCCESS'; $data['ReturnStatus'] = '4'; break; } return PapOrder::model()->updateAll($data, $where); }
public static function createorder($quoID, $schID, $payment, $address) { $sql_findQuo = 'select * from pap_quotation where QuoID=' . $quoID; $Quoinfo = self::excutesql(array('sql' => $sql_findQuo, 'db' => 'pap')); $Quoinfo = $Quoinfo[0]; //获取方案信息 $sql_findshem = 'select * from pap_quotation_scheme where SchID=' . $schID; $schemeinfo = self::excutesql(array('sql' => $sql_findshem, 'db' => 'pap')); $schemeinfo = $schemeinfo[0]; //获取方案对应的商品 $sql_goods = 'select * from pap_quotation_goods where SchID=' . $schID; $goodsinfo = self::excutesql(array('sql' => $sql_goods, 'db' => 'pap')); //获取商品数量,以便生成均价 $totalnum = 0; //总数量 $lmstotal = 0; //总价 $factdiscount = 100; $discount = PapOrderDiscount::model()->find('OrderType=:OrderType', array(':OrderType' => 2)); if ($discount) { if ($payment == 1) { $factdiscount = $discount['OrderAlipay'] ? $discount['OrderAlipay'] : 100; } else { if ($payment == 2) { $factdiscount = $discount['OrderLogis'] ? $discount['OrderLogis'] : 100; } } } else { $factdiscount = 100; } $totalgoods; foreach ($goodsinfo as $kk => $value) { if (!empty($value['Version'])) { $_sql_find_version = 'select Info from pap_goods_version where GoodsID=' . $value['GoodsID'] . ' and Version=' . $value['Version']; $goods_versi = Yii::app()->papdb->createCommand($_sql_find_version)->queryRow(); $goodsbyid = json_decode($goods_versi['Info'], true); $oes; if ($goodsbyid['oeno']) { if (!is_array($goodsbyid['oeno'][0])) { $oes = implode('、', $goodsbyid['oeno']); } } else { $oes = PapGoods::getOENOSByGoodsID($value['GoodsID']); } } else { $goodsbyid = PapGoods::model()->findByPK($value['GoodsID']); $oes = PapGoods::getOENOSByGoodsID($value['GoodsID']); } if ($goodsbyid) { $lmstotal += round($value['Price'] * $value['Num'] * $factdiscount / 100, 2); $ppprice = $value['Price'] * $factdiscount / 100; $totalnum += $value['Num']; $totalgoods[$kk] = array("GoodsID" => $value['GoodsID'], "GoodsNum" => $goodsbyid['GoodsNO'], "GoodsOE" => $oes ? $oes : '', "GoodsName" => $goodsbyid['Name'], "CpName" => $goodsbyid['StandCode'] ? self::getCpName($goodsbyid['StandCode']) : '', "Brand" => self::getBrand($goodsbyid['BrandID']), "Price" => $goodsbyid['Price'], "ProPrice" => round($ppprice, 2), "Quantity" => $value['Num'], "GoodsAmount" => round($value['Num'] * $ppprice, 2), "CreateTime" => time(), "UpdateTime" => time(), "Version" => $goodsbyid['Version']); } } //获取经销商最小价格 $min_price = PapOrderMinTurnover::model()->find('OrganID=:OrganID', array(':OrganID' => $Quoinfo['DealerID'])); $min_price = $min_price['MinTurnover']; //获取经销商信息 $sql_dealer = 'select * from jpd_organ where ID=' . $Quoinfo['DealerID']; $dealerinfo = self::excutesql(array('sql' => $sql_dealer, 'db' => 'jpd')); $dealerinfo = $dealerinfo[0]; //生成订单编号 $order_sn = self::gen_order_sn(); // 修改询价单状态 $updateinquiry = PapInquiry::model()->updateByPK($Quoinfo['InquiryID'], array('Status' => 2)); //修改别的报价单状态,改为已拒绝 $sql_dppend = 'select * from pap_quotation where InquiryID=' . $Quoinfo['InquiryID']; $dppall = self::excutesql(array('sql' => $sql_dppend, 'db' => 'pap')); foreach ($dppall as $keyy => $valuee) { if ($valuee['QuoID'] != $quoID) { PapQuotation::model()->updateByPK($valuee['QuoID'], array('Status' => 4)); } } if ($updateinquiry != 1) { //确认询价单失败 return array('success' => false, 'msg' => 'check inquiry fail', 'QuoID' => $quoID, 'data' => '确认询价单失败'); exit; } //修改方案状态 $updateschemsql = 'update pap_quotation_scheme set Status="2" where SchID=' . $schID; $updateschem = Yii::app()->papdb->createCommand($updateschemsql)->execute(); if ($updateschem != 1) { //确认报价单方案失败 return array('success' => false, 'msg' => 'check quo scheme fail', 'QuoID' => $quoID, 'data' => '确认报价单方案失败'); exit; } // 修改报价单状态 $discountdesc = self::getpriceratio($Quoinfo['DealerID'], $Quoinfo['ServiceID']); $updateQuo = PapQuotation::model()->updateByPK($quoID, array('Status' => 2, 'Discount' => $discountdesc['type'] . ',' . $discountdesc['discount'])); if ($updateQuo != 1) { //更新报价单状态失败 return array('success' => false, 'msg' => 'update quo status fail', 'QuoID' => $quoID, 'data' => '更新报价单状态失败'); exit; } //生成平摊金额 $amountlist = 0; $minus = 0; if ($min_price && $min_price > $lmstotal) { $minus = round(($min_price - $lmstotal) / $totalnum, 2); $amountlist = $lmstotal + $minus * $totalnum; if ($amountlist < $min_price) { $amountlist = $min_price; } } else { $amountlist += $lmstotal; } $find_lsm_orgname = 'select OrganName from jpd_organ where ID=' . $Quoinfo['ServiceID']; $lms_orgname = Yii::app()->jpdb->createCommand($find_lsm_orgname)->queryRow(); $params = array("OrderSN" => "DD" . $order_sn, "OrderName" => "嘉配订单:DD" . $order_sn, "SellerID" => $dealerinfo["ID"], "OrganID" => $dealerinfo["ID"], "SellerName" => $dealerinfo["OrganName"], "BuyerID" => $Quoinfo['ServiceID'], "BuyerName" => $lms_orgname['OrganName'], "Payment" => $payment, "OrderType" => 2, 'Discount' => $factdiscount, 'GoodsAmount' => $amountlist, 'ShipCost' => $schemeinfo['ShipFee'], 'TotalAmount' => $amountlist + $schemeinfo['ShipFee'], 'RealPrice' => $amountlist + $schemeinfo['ShipFee'], "Status" => $payment == 1 ? 1 : 2, "CreateTime" => time(), "UpdateTime" => time()); $orderID = self::saveorderinfo($params); if (!$orderID) { //创建订单失败 return array('success' => false, 'msg' => 'create order fail', 'QuoID' => $quoID, 'data' => '创建订单失败'); exit; } //保存订单编号到询价单表 PapInquiry::model()->updateByPK($Quoinfo['InquiryID'], array('OrderSn' => "DD" . $order_sn)); //保存订单ID到报价单表 PapQuotation::model()->updateByPK($quoID, array('OrderID' => $orderID)); //保存订单商品 self::saveordergoods($totalgoods, $orderID, $minus); //保存地址 if ($orderID) { $adressinfo = self::getaddressbypk($address); $addr = array('OrderID' => $orderID, 'ShippingName' => $adressinfo['ContactName'], 'ZipCode' => $adressinfo['ZipCode'], 'Mobile' => $adressinfo['Phone'], 'TelePhone' => $adressinfo['TelPhone'], 'Province' => $adressinfo['State'], 'City' => $adressinfo['City'], 'Area' => $adressinfo['District'], 'Address' => $adressinfo['Address'], 'CreateTime' => time()); self::saveinquiryaddress($addr); } //生成订单通知经销商 if ($payment == 1) { //待付款 $params = array('OrganID' => $Quoinfo['DealerID'], 'OrganType' => 2, 'HandleID' => $orderID); $params['type'] = array('name' => 'DD', 'key' => 1); RemindService::sendRemind($params); } elseif ($payment == 2) { //待发货 $params = array('OrganID' => $Quoinfo['DealerID'], 'OrganType' => 2, 'HandleID' => $orderID); $params['type'] = array('name' => 'DD', 'key' => 2); //命令行链接 $params['from'] = 'http://192.168.2.29:8000/pap/sellerorder/detail&ID=' . $orderID; RemindService::sendRemind($params); } //更改报价单待确认状态为已处理 $sql = 'update pap_remind_business set HandleStatus=2 where HandleID=' . $quoID . ' and OrganID=' . $Quoinfo['ServiceID']; Yii::app()->papdb->createCommand($sql)->execute(); //创建订单成功 return array('success' => true, 'msg' => 'carate order success', 'QuoID' => $quoID, 'data' => '创建订单成功', 'orderID' => $orderID, 'ordersn' => $order_sn); }
public function actionAddreturnorder2() { $goodsArr = explode(',', $_POST['Goods']); $sql = 'insert into `pap_return_goods` values'; $idStr = '('; foreach ($goodsArr as $v) { $g = explode('-', $v); $idStr .= $g[0] . ','; if (!$g[6]) { //如果该商品版本就空 $g[6] = 'NULL'; } $sql .= "(NULL,{$g['0']},{$g['1']},'ReturnID',{$g['2']},{$g['3']},{$g['4']},'',{$g['5']},{$g['6']}),"; } $idStr = substr($idStr, 0, -1) . ')'; $c = new CDbCriteria(); $c->addCondition("ID in {$idStr} and ReturnStatus=0", 'AND'); $m = PapOrder::model()->findAll($c); if (!$m) { echo json_encode(array('error' => '提交退款单失败,请先刷新订单列表!')); exit; } $model = new PapReturnOrder(); $model->ReturnNO = 'THD' . ReturnorderService::gen_order_sn(); $model->DealerID = $m[0]['SellerID']; $model->ServiceID = Commonmodel::getOrganID(); $model->Status = 11; //退款待审核 $model->CreateTime = time(); $model->Price = $_POST['Price']; $model->LogtigCompany = '顺丰'; $model->Result = $_POST['Reseaon']; $model->Type = $m[0]['Status'] == 9 ? 2 : 1; $model->ReturnNumber = 11; $model->save(); if (!$model->save()) { echo json_encode(array('error' => '提交退货单失败,请稍后再试!')); exit; } $id = $model->attributes['ID']; $editSql = "update `pap_order` set ReturnStatus=11 where ID in {$idStr}"; $sql = str_replace('ReturnID', $id, substr($sql, 0, -1)); $ins = Yii::app()->papdb->createCommand($sql)->execute(); $edt = Yii::app()->papdb->createCommand($editSql)->execute(); //发送待审核提醒给经销商 $params = array('OrganID' => $model['DealerID'], 'OrganType' => 2, 'HandleID' => $id); $params['type'] = array('name' => 'THD', 'key' => 4); RemindService::sendRemind($params); if ($ins && $edt) { echo json_encode(array('success' => 1)); } }