auth->id; $orderinfo = Db::name('order')->where('id',$orderid)->where('user_id',$uid)->find(); //创建订单 $data['user_id'] = $uid; $data['out_trade_no'] = createUniqueNo('P',$uid); // 数据库订单号加密 $data['order_amount'] = $orderinfo['pay_fee']; $data['createtime'] = time(); $data['pay_type'] = $pay_type; $data['order_status'] = 0; $data['table_name'] = 'order'; $data['table_id'] = $orderid; $orderid = Db::name('pay_order')->insertGetId($data); $openid = $this->auth->mini_openid; //下单 $params = [ 'type' => $pay_type, 'orderid' => $data['out_trade_no'], 'title' => '支付订单', 'amount' => $data['order_amount'], 'method' => $platform, 'openid' => $openid, 'notifyurl' => config('pay_notify_url').'/api/pay/order_notify_base/paytype/'.$pay_type, 'returnurl' => '', ]; $res = Service::submitOrder($params); if($pay_type == 'wechat'){ $this->success('success',json_decode($res,true)); }else{ $this->success('success',$res); } } //异步回调对外方法 public function order_notify_base(){ //验签 $paytype = input('paytype','wechat'); $func = input('func','order_notify_do'); $out_trade_no = 'O230606102813244205462'; $rs = $this->$func($out_trade_no);echo '
';var_dump($rs);exit; $notify_file = $this->notify_log_start($paytype); $pay = Service::checkNotify($paytype); if (!$pay) { echo '签名错误'; exit; } //验证,拿订单号等信息 $data = $pay->verify(); $out_trade_no = $data['out_trade_no']; //订单查询 $info = Db::name('pay_order')->where('out_trade_no',$out_trade_no)->find(); if(empty($info)){ return $pay->success()->send(); exit; } if($info['order_status'] != 0) { return $pay->success()->send(); exit; } //你可以在此编写订单逻辑 $rs = $this->$func($out_trade_no); if($rs === false){ //不论结果都应返回success return $pay->success()->send(); exit; }else{ //不论结果都应返回success return $pay->success()->send(); exit; } //默认 return $pay->success()->send(); exit; } //异步逻辑 private function order_notify_do($out_trade_no){ Db::startTrans(); $orderInfo = Db::name('pay_order')->where(['out_trade_no' => $out_trade_no])->lock(true)->find(); if (empty($orderInfo)) { Db::rollback(); return false; } if($orderInfo['order_status'] != 0){ Db::rollback(); return false; } //逻辑开始 $update = [ 'status'=>10, 'paytime'=>time(), 'pay_type'=>$orderInfo['pay_type'], 'pay_out_trade_no'=>$out_trade_no, ]; $rs_order = Db::name('order')->where('id',$orderInfo['table_id'])->update($update); if($rs_order === false){ Db::rollback(); return false; } //逻辑结束 //状态 $ros = Db::name('pay_order')->where(['out_trade_no' => $out_trade_no])->update(['order_status'=>1,'notifytime'=>time()]); if($ros === false) { Db::rollback(); return false; } //默认提交 Db::commit(); return true; } //异步日志 private function notify_log_start($paytype = 'wechat'){ //记录支付回调数据 ignore_user_abort(); // run script in background set_time_limit(30); // 日志文件 start $log_base_dir = '../paylog/'.$paytype.'/'; if (!is_dir($log_base_dir)) { mkdir($log_base_dir, 0770, true); @chmod($log_base_dir, 0770); } $notify_file = $log_base_dir.'notify.txt'; if(!file_exists($notify_file)) { @touch($notify_file); @chmod($notify_file, 0770); } if(filesize($notify_file)>5242880)//大于5M自动切换 { rename($notify_file, $log_base_dir.'notify_'.date('Y_m_d_H_i_s').'.txt'); } if(!file_exists($notify_file)) { @touch($notify_file); @chmod($notify_file, 0770); } // 日志文件 end //开始写入 $_REQUEST = isset($_REQUEST) ? $_REQUEST : array(); if($_REQUEST && $paytype == 'alipay') { file_put_contents($notify_file, "\r\n\r\n".date('Y-m-d H:i:s')." [notify][入口接收request]".json_encode($_REQUEST), FILE_APPEND); } else { $xml = file_get_contents("php://input"); file_put_contents($notify_file, "\r\n\r\n".date('Y-m-d H:i:s')." [notify][入口接收php://input流原始数据] \n".$xml, FILE_APPEND); $xmlObj = simplexml_load_string($xml, 'SimpleXMLElement', LIBXML_NOCDATA); file_put_contents($notify_file, "\r\n\r\n".date('Y-m-d H:i:s')." [notify][入口接收php://input流] ".json_encode($xmlObj), FILE_APPEND); } ini_set('display_errors','On'); return $notify_file; } ////////////// //微信小程序充值 public function pay_recharge() { Db::startTrans(); try { $pay_type = input('pay_type','wechat'); $platform = input('platform','miniapp'); $id = input('id','0'); $amounts = input('amounts','0.00'); $uid = $this->auth->id; $companyId = $this->auth->company_id; if (empty($id) && empty($amounts)) { throw new Exception('参数错误'); } $gift_amount = 0.00; if (!empty($id)) {//验证充值配置 $where['status'] = 1;//上架 $orderinfo = Db::name('recharge_config')->where('id',$id)->where($where)->find(); if (empty($orderinfo)) { throw new Exception('未获取到充值套餐信息'); } $order_amount = $orderinfo['price']; $gift_amount = $orderinfo['giftprice']; } else { $isInt = is_int($amounts); if (!$isInt) { throw new Exception('请输入整数'); } if ($amounts < 1) { throw new Exception('充值金额有误'); } $order_amount = $amounts; } //创建订单 $data['company_id'] = $companyId; $data['user_id'] = $uid; $data['out_trade_no'] = createUniqueNo('R',$uid); // 数据库订单号加密 $data['order_amount'] = $order_amount; $data['gift_amount'] = $gift_amount; $data['createtime'] = time(); $data['pay_type'] = $pay_type; $data['order_status'] = 0; $data['table_name'] = 'recharge_config'; $data['table_id'] = $id; $orderid = Db::name('pay_order')->insertGetId($data); $openid = $this->auth->mini_openid; $httpStr = $_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['HTTP_HOST']; //下单 $params = [ 'type' => $pay_type, 'orderid' => $data['out_trade_no'], 'title' => '余额充值', 'amount' => $data['order_amount'], 'method' => $platform, 'openid' => $openid, 'notifyurl' => $httpStr.'/api/pay/order_notify_base/paytype/'.$pay_type.'/func/recharge', 'returnurl' => '', ]; $res = Service::submitOrder($params); Db::commit(); if($pay_type == 'wechat'){ $this->success('success',json_decode($res,true)); }else{ $this->success('success',$res); } } catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } } /** * 充值到账 * @param $out_trade_no * @return bool */ private function recharge($out_trade_no) { Db::startTrans(); $orderInfo = Db::name('pay_order')->where(['out_trade_no' => $out_trade_no])->lock(true)->find(); if (empty($orderInfo)) { Db::rollback(); return false; } if($orderInfo['order_status'] != 0){ Db::rollback(); return false; } //赠送优惠券 $rg = 'recharge_gift'; $c = 'coupons'; $field = $rg.'.*,'.$c.'.name,'.$c.'.info,'.$c.'.days'; $rechargeGiftWhere['config_id'] = $orderInfo['table_id']; $rechargeGiftWhere[$c.'.status'] = 1; $rechargeGift = Db::name($rg)->alias($rg)->field($field) ->join($c,$c.'.id = '.$rg.'.coupon_id','LEFT')->where($rechargeGiftWhere)->select(); if (!empty($rechargeGift)) { $time = time(); foreach ($rechargeGift as $key => $value) { $endtime = $time + 86400 * $value['days']; $userCouponsData[] = [ 'user_id' => $orderInfo['user_id'], 'company_id' => $orderInfo['company_id'], 'coupons_id' => $value['coupon_id'], 'coupon_name' => $value['name'], 'coupon_info' => $value['info'], 'createtime' => $time, 'endtime' => $endtime, 'number' => $value['number'], 'remain' => $value['number'], 'payorder_id' => $orderInfo['id'], 'getfrom' => '充值赠送', ]; } $userCouponsRes = Db::name('user_coupons')->insertAll($userCouponsData); if (!$userCouponsRes) { throw new Exception('赠送优惠失败'); } } $userWalletWhere['user_id'] = $orderInfo['user_id']; $userWalletWhere['company_id'] = $orderInfo['company_id']; $userWalletData = Db::name('user_wallet')->where($userWalletWhere)->find(); $before = isset($userWalletData['money']) ? $userWalletData['money'] : 0.00; $changeValue = bcadd($orderInfo['order_amount'],$orderInfo['gift_amount'],2); $remain = bcadd($before,$changeValue,2); $time = time(); //逻辑开始 记录充值明细 $userMoneyLogData = [ 'user_id' => $orderInfo['user_id'], 'company_id' => $orderInfo['company_id'], 'log_type' => 104, //日志类型 104 'before' => $before, //之前余额 'change_value' => $changeValue, //变动金额 'remain' => $remain, //剩余金额 'table' => 'pay_order', //数据来源 'table_id' => $orderInfo['id'], //数据来源ID 'remark' => '余额充值', //remark 'createtime' => $time, ]; $userMoneyLogRes = Db::name('user_money_log')->insertGetId($userMoneyLogData); if (!$userMoneyLogRes) { throw new Exception('充值记录失败'); } //更新钱包余额 $update = [ 'money' => $remain, 'updatetime' => $time, ]; $rs_order = Db::name('user_wallet')->where($userWalletWhere)->update($update); if(!$rs_order){ Db::rollback(); return false; } //逻辑结束 //状态 $ros = Db::name('pay_order')->where(['out_trade_no' => $out_trade_no])->update(['order_status'=>1,'notifytime'=>time()]); if($ros === false) { Db::rollback(); return false; } //默认提交 Db::commit(); return true; } /** * 购买套餐 * @return void * @throws \Exception */ public function package() { Db::startTrans(); try { $pay_type = input('pay_type','wechat');//支付类型:wallet=余额,wechat=微信 $platform = input('platform','miniapp'); $id = input('package_id','0'); $carId = input('car_id','0'); $uid = $this->auth->id; $companyId = $this->auth->company_id; $time = time(); if (empty($id)) { throw new Exception('请选择套餐'); } if (empty($carId)) { throw new Exception('请选择车辆'); } $userCarWhere['user_id'] = $uid; $userCarWhere['id'] = $carId; $userCar = Db::name('user_car')->where($userCarWhere)->find(); if (empty($userCar)) { throw new Exception('未找到车辆信息'); } $packageWhere['id'] = $id; $packageWhere['status'] = 1; $package = Db::name('package')->where($packageWhere)->find(); if (empty($package)) { throw new Exception('未找到套餐信息'); } if ($package['company_id'] != $companyId) { throw new Exception('您绑定的门店和购买套餐门店不一致'); } if ($pay_type == 'wallet') {//验证余额 $userWalletWhere['user_id'] = $uid; $userWalletWhere['company_id'] = $companyId; $userWallet = Db::name('user_wallet')->where($userWalletWhere)->find(); if (empty($userWallet)) { throw new Exception('钱包异常'); } if ($userWallet['money'] < $package['price']) { throw new Exception('您的余额不足,请充值。'); } } $gift_amount = 0.00; $order_amount = $package['price']; $extData = ['car_id'=>$carId]; //创建订单 $data['company_id'] = $companyId; $data['user_id'] = $uid; $data['out_trade_no'] = createUniqueNo('O',$uid); // 数据库订单号加密 $data['order_amount'] = $order_amount; $data['gift_amount'] = $gift_amount; $data['createtime'] = time(); $data['pay_type'] = $pay_type; $data['order_status'] = 0; $data['table_name'] = 'package'; $data['table_id'] = $id; $data['ext_data'] = json_encode($extData); $orderid = Db::name('pay_order')->insertGetId($data); if ($pay_type == 'wechat') {//微信支付 $openid = $this->auth->mini_openid; $httpStr = $_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['HTTP_HOST']; //下单 $params = [ 'type' => $pay_type, 'orderid' => $data['out_trade_no'], 'title' => '购买套餐', 'amount' => $data['order_amount'], 'method' => $platform, 'openid' => $openid, 'notifyurl' => $httpStr.'/api/pay/order_notify_base/paytype/'.$pay_type.'/func/package_do', 'returnurl' => '', ]; $res = Service::submitOrder($params); } else {//余额支付 //扣除钱包 $oldMoney = $userWallet['money']; $newMoney = bcsub($oldMoney,$package['price'],2); $userWalletData['money'] = $newMoney; $userWalletData['updatetime'] = $time; $userWalletWhere['user_id'] = $uid; $userWalletWhere['company_id'] = $companyId; $userWalletRes = Db::name('user_wallet')->where($userWalletWhere)->update($userWalletData); if (!$userWalletRes) { throw new Exception('支付失败'); } //余额明细记录 $userMoneyLogData = [ 'company_id' => $companyId, 'user_id' => $uid, 'log_type' => 103,//购买套餐 'before' => $oldMoney, 'change_value' => $package['price'], 'remain' => $newMoney, 'table' => 'pay_order', 'table_id' => $orderid, 'remark' => '订单消费', 'createtime' => $time, ]; $userMoneyLogRes = Db::name('user_money_log')->insertGetId($userMoneyLogData); if (!$userMoneyLogRes) { throw new Exception('余额明细记录失败'); } //生成订单 $time = time(); $packageWhere['id'] = $id; $package = Db::name('package')->where($packageWhere)->find(); $days = isset($package['days']) ? $package['days'] : 0; $packageEndtime = $time + 86400 * $days; $userId = $uid; $userWhere['id'] = $userId; $user = Db::name('user')->where($userWhere)->find(); $userCarWhere['id'] = $carId; $userCar = Db::name('user_car')->where($userCarWhere)->find(); //生成订单 $orderData = [ 'orderno' => createUniqueNo('O', $userId),//订单号 'ordertype' => 3,//类型:1=预约下单,2=在线下单,3=套餐订单 'company_id' => $companyId,//门店ID 'user_id' => $userId,//用户ID 'user_name' => isset($user['nickname']) ? $user['nickname'] : '',//用户姓名 'user_car_id' => isset($userCar['id']) ? $userCar['id'] : 0,//车辆ID 'user_car_number' => isset($userCar['car_number']) ? $userCar['car_number'] : '',//用户车牌 'user_mobile' => isset($user['mobile']) ? $user['mobile'] : '',//用户手机 'pre_order_id' => 0,//预约单ID 'package_id' => isset($package['id']) ? $package['id'] : 0,//套餐ID 'server_info' => isset($package['info']) ? $package['info'] : '',//套餐内容 'server_images' => isset($package['images']) ? $package['images'] : '',//套餐图片 'pay_fee' => isset($package['price']) ? $package['price'] : 0,//套餐价格 'package_endtime' => $packageEndtime,//套餐到期时间 'status' => 2,//状态:1=待支付,2=待处理,3=已完成,4=已取消 'pay_time' => $time, 'paytype' => 2,//支付方式:1=线下,2=余额,3=微信 'pay_fee' => $order_amount,//支付总额 'createtime' => $time,//下单时间 'pay_order_id' => $orderid,//支付ID ]; $orderRes = Db::name('order')->insertGetId($orderData); $payOrderData['order_status'] = 1; $payOrderWhere['id'] = $orderid; $payOrderRes = Db::name('pay_order')->where($payOrderWhere)->update($payOrderData); if (!$payOrderRes) { throw new Exception('支付失败'); } } $res['order_id'] = isset($orderRes) ? $orderRes : 0; $res['pay_order_id'] = $orderid; Db::commit(); if($pay_type == 'wechat'){ $this->success('操作成功',json_decode($res,true)); }else{ $this->success('操作成功',$res); } } catch (Exception $e) { Db::rollback(); $this->error($e->getMessage()); } } /** * 购买套餐回调 * @param $out_trade_no * @return bool */ private function package_do($out_trade_no) { Db::startTrans(); $orderInfo = Db::name('pay_order')->where(['out_trade_no' => $out_trade_no])->lock(true)->find(); if (empty($orderInfo)) { Db::rollback(); return false; } if($orderInfo['order_status'] != 0){ Db::rollback(); return false; } $time = time(); $packageWhere['id'] = $orderInfo['table_id']; $package = Db::name('package')->where($packageWhere)->find(); $days = isset($package['days']) ? $package['days'] : 0; $packageEndtime = $time + 86400 * $days; $userId = $orderInfo['user_id']; $userWhere['id'] = $userId; $user = Db::name('user')->where($userWhere)->find(); $extData = json_decode($orderInfo['ext_data'], true); $userCarWhere['id'] = isset($extData['car_id']) ? $extData['car_id'] : 0; $userCar = Db::name('user_car')->where($userCarWhere)->find(); //生成订单 $orderData = [ 'orderno' => createUniqueNo('O', $userId),//订单号 'ordertype' => 3,//类型:1=预约下单,2=在线下单,3=套餐订单 'company_id' => $orderInfo['company_id'],//门店ID 'user_id' => $userId,//用户ID 'user_name' => isset($user['nickname']) ? $user['nickname'] : '',//用户姓名 'user_car_id' => isset($userCar['id']) ? $userCar['id'] : 0,//车辆ID 'user_car_number' => isset($userCar['car_number']) ? $userCar['car_number'] : '',//用户车牌 'user_mobile' => isset($user['mobile']) ? $user['mobile'] : '',//用户手机 'pre_order_id' => 0,//预约单ID 'package_id' => isset($package['id']) ? $package['id'] : 0,//套餐ID 'server_info' => isset($package['info']) ? $package['info'] : '',//套餐内容 'server_images' => isset($package['images']) ? $package['images'] : '',//套餐图片 'pay_fee' => isset($package['price']) ? $package['price'] : 0,//套餐价格 'package_endtime' => $packageEndtime,//套餐到期时间 'status' => 2,//状态:1=待支付,2=待处理,3=已完成,4=已取消 'pay_time' => $time, 'paytype' => 3,//支付方式:1=线下,2=余额,3=微信 'pay_fee' => $orderInfo['order_amount'],//支付总额 'createtime' => $time,//下单时间 'pay_order_id' => $orderInfo['id'],//支付ID ]; $orderRes = Db::name('order')->insertGetId($orderData); if (!$orderRes) { Db::rollback(); return false; } //状态 $ros = Db::name('pay_order')->where(['out_trade_no' => $out_trade_no])->update(['order_status'=>1,'notifytime'=>time()]); if($ros === false) { Db::rollback(); return false; } //默认提交 Db::commit(); return true; } }