user_id)->field('id,group_id,is_first,account_type')->find(); if($user_info['account_type'] == 1 && $user_info['is_first'] == 0) $this->error('请联系公司管理员进行会员开通'); $user_vip = UserLevelRank::getUserVipInfo($this->user_id); if(!empty($user_vip) && $user_vip['level_id'] > 1) $this->error('已是会员,请联系平台'); if(!empty($user_vip) && $user_vip['user_id'] != $this->user_id) $this->error('请联系已绑定企业账号'); $level_set = UserLevel::where('id', $level_id)->find()->toArray(); if (!$level_set['price']) $this->error('会员价格设置有误'); $level_price = json_decode($level_set['price'], true); if (!isset($level_price[$level_key])) $this->error('会员价格设置有误.'); $is_renew = \app\common\model\LevelOrder::where('user_id',$this->user_id)->where('status',1)->where('pay_state',1)->count(); if(!empty($user_vip)) { $cal_time = strtotime('+'.$level_price[$level_key]['time'] .' month',$user_vip['end_time']); if($cal_time > strtotime('+3 years')) $this->error('会员续费期限最多3年'); } // $price_total = $is_renew && $level_price[$level_key]['renew'] > 0 && $level_price[$level_key]['renew'] ? bcmul( $level_price[$level_key]['price'], $level_price[$level_key]['renew']/100,2) : $level_price[$level_key]['price']; $order_insert = [ 'user_id' => $this->user_id, 'order_no' => get_order_sn(), 'level_id' => $level_id, 'level_key' => $level_key, 'month' => $level_price[$level_key]['time'], 'level_title' => $level_price[$level_key]['title'], 'price_total' =>$is_renew ? $level_price[$level_key]['renew'] : $level_price[$level_key]['price'], ]; $order_info = LOM::create($order_insert); $this->success('ok', ['order_id' => $order_info->id]); } /** * @title 获取订单详情 * @desc 获取订单详情 * @author qc * @method GET * @url /api/Level_order/getOrderDetail * @header name:Authorization require:1 desc:Token * @param name:order_id type:int default:-- desc:订单id * @return name:id type:int default:-- desc:订单id * @return name:order_no type:string default:-- desc:订单号 * @return name:price_total type:float default:-- desc:待支付金额 * @return name:level_id type:float default:-- desc:等级id * @return name:level_name type:float default:-- desc:等级名称 * @return name:month type:float default:-- desc:时长(月) * @return name:pay_state type:int default:-- desc:支付状态(0未支付1已支付) * @return name:pay_type type:int default:-- desc:支付方式(1.h5微信,2.h5支付宝,3.app微信,4.app支付宝,5.h5微信内支付) * @return name:pay_no type:string default:-- desc:支付号 * @return name:pay_at type:string default:-- desc:支付时间 * @return name:cancel_state type:int default:-- desc:取消状态(0未取消1已取消) * @return name:cancel_at type:string default:-- desc:取消时间 * @return name:cancel_desc type:string default:-- desc:取消原因 * @return name:cancel_desc type:string default:-- desc:取消原因 * @return name:level_set type:array default:-- desc:购买会员设置 * @return name:level_set.title type:string default:-- desc:标题 * @return name:level_set.price type:float default:-- desc:价格 * @return name:level_set.time type:int default:-- desc:时间(月) */ public function getOrderDetail() { $order_id = input('get.order_id'); $detail = LOM::where('id',$order_id)->find()->toArray(); $level_set = UserLevel::where('id', $detail['level_id'])->find()->toArray(); $detail['level_name'] = $level_set['name']; $detail['level_set'] = json_decode($level_set['price'],true)[$detail['level_key']]; $this->success('',['detail'=>$detail]); } /** * @title 订单支付 * @desc 订单支付 * @author qc * @url /api/Level_order/payOrder * @method POST * @header name:Authorization require:1 desc:Token * @param name:order_id type:int require:1 default:0 desc:订单id * @param name:pay_type type:int require:1 default:0 desc:支付方式(1.h5微信,2.h5支付宝,3.app微信,4.app支付宝) * @return name:config type:array default:0 desc:小程序支付配置 * @return name:config.signType type:string default:-- desc:签名类型 * @return name:config.appId type:string default:-- desc:appId【h5】 * @return name:config.paySign type:string default:-- desc:签名【h5】 * @return name:config.nonceStr type:string default:-- desc:随机字符串【h5】 * @return name:config.timeStamp type:string default:-- desc:时间戳【h5】 * @return name:config.appid type:string default:-- desc:appid【微信APP】 * @return name:config.sign type:string default:-- desc:签名【微信APP】 * @return name:config.noncestr type:string default:-- desc:随机字符串【微信APP】 * @return name:config.timestamp type:string default:-- desc:时间戳【微信APP】 * @return name:config.partnerid type:string default:-- desc:商户号 * @return name:config.prepayid type:string default:-- desc:唯一支付号 * @return name:config.package type:string default:-- desc:package * @return name:config.mch_id type:string default:-- desc:商户号(H5) * @return name:config.pay_no type:string default:-- desc:订单支付号(H5) * @return name:config.notify_url type:string default:-- desc:回调地址(H5) * @return name:config.total_fee type:int default:-- desc:支付金额(分!!!) * @return name:code_url type:string default:-- desc:付款码url * @return name:openid type:string default:-- desc:openid */ public function payOrder() { $order_id = input('post.order_id'); $pay_type = input('post.pay_type',1); $order_info = LOM::where('id',$order_id)->find()->toArray(); if($order_info['status'] != 0) $this->error('订单状态错误'); if($order_info['cancel_state'] != 0 || $order_info['is_deleted'] != 0) $this->error('订单异常'); if($order_info['price_total'] <= 0) $this->error('订单金额错误'); $user_vip = UserLevelRank::getUserVipInfo($this->user_id); if(!empty($user_vip)) { $cal_time = strtotime('+'.$order_info['month'] .' month',$user_vip['end_time']); if($cal_time > strtotime('+3 years')) $this->error('会员续费期限最多3年'); } if(!empty($user_vip) && $user_vip['user_id'] != $this->user_id) $this->error('请联系已绑定企业账号'); $pay_no = $order_info['pay_no'] ? $order_info['pay_no'] : get_order_sn();// 支付单号 if(!$order_info['pay_no']) LOM::where('id',$order_id)->update(['pay_no'=>$pay_no]); $user_info = User::where('id',$this->user_id)->find()->toArray(); $ret_data = ['pay_status'=>0,'config'=>[],'code_url'=>'','openid'=>$user_info['openid']]; Db::startTrans(); LOM::where('id',$order_id)->update(['pay_type'=>$pay_type]); try { switch ($pay_type){ case 1://微信 $notify_url = $this->request->root(true) . '/api/we_chat_pay/LevelOrderNotify'; // $notify_url = 'https://gaoyixia.hdlkeji.com/api/we_chat_pay/LevelOrderNotify'; $pay_config = WeChatPay::wxPay('订单支付',$pay_no,$order_info['price_total'],$notify_url,'MWEB'); if($pay_config['code'] != 200) $this->exception($pay_config['msg']); $pay_config['config']['mch_id'] = config('app.wx_pay')['mch_id']; $pay_config['config']['pay_no'] = $pay_no; $pay_config['config']['notify_url'] = $notify_url; $pay_config['config']['mweb_url'] = $pay_config['mweb_url']; $pay_config['config']['total_fee'] = $order_info['price_total'] * 100; $ret_data['config'] = $pay_config['config']; break; case 2 : $notify_url = $this->request->root(true) . '/api/Alipay/LevelOrderNotify'; $return_url ='https://'.$_SERVER['HTTP_HOST']."/dist/#/my"; $config = Alipay::ali_pay_h5('订单支付',$pay_no,$order_info['price_total'],$notify_url,$return_url); $ret_data['config']['ali_url'] = $config; $ret_data['ali_url'] = $config; break; case 3: $notify_url = $this->request->root(true) . '/api/we_chat_pay/LevelOrderNotify'; $pay_config = WeChatPay::wxPay('订单支付',$pay_no,$order_info['price_total'],$notify_url,'APP'); if($pay_config['code'] != 200) $this->exception($pay_config['msg']); $ret_data['config'] = $pay_config['config']; break; case 4: $notify_url = $this->request->root(true) . '/api/Alipay/LevelOrderNotify'; $config = Alipay::ali_pay('订单支付',$pay_no,$order_info['price_total'],$notify_url); $ret_data['config']['ali_url'] = $config; $ret_data['ali_url'] = $config; break; case 5 : if(!$user_info['openid']) $this->exception('请绑定openid'); $notify_url = $this->request->root(true) . '/api/we_chat_pay/LevelOrderNotify'; $pay_config = WeChatPay::wxPay('订单支付',$pay_no,$order_info['price_total'],$notify_url,'JSAPI',$user_info['openid']); if($pay_config['code'] != 200) $this->exception($pay_config['msg']); $ret_data['config'] = $pay_config['config']; break; } Db::commit(); }catch (\Exception $e){ $this->is_commit = false; $this->ret_msg = $e->getMessage(); Db::rollback(); } $this->transReturn($ret_data); } /** * @title 开通会员 * @desc 开通会员 * @author qc * @url /api/Level_order/payOrderNew * @method POST * @header name:Authorization require:1 desc:Token * @param name:level_id type:int require:1 default:0 desc:会员等级 * @param name:level_key type:int require:1 default:0 desc:等级价格的key值 * @param name:pay_type type:int require:1 default:0 desc:支付方式(1.h5微信,2.h5支付宝,3.app微信,4.app支付宝,5.h5微信内支付,6微信pc,7pc支付宝) * @return name:config type:array default:0 desc:支付配置 * @return name:config.appId type:string default:-- desc:公众账号ID * @return name:config.signType type:string default:-- desc:签名类型 * @return name:config.paySign type:string default:-- desc:签名 * @return name:config.nonceStr type:string default:-- desc:随机字符串 * @return name:config.timestamp type:string default:-- desc:时间戳 * @return name:config.partnerid type:string default:-- desc:商户号 * @return name:config.prepayid type:string default:-- desc:唯一支付号 * @return name:config.package type:string default:-- desc:package * @return name:config.mch_id type:string default:-- desc:商户号(H5) * @return name:config.pay_no type:string default:-- desc:订单支付号(H5) * @return name:config.notify_url type:string default:-- desc:回调地址(H5) * @return name:config.total_fee type:int default:-- desc:支付金额(分!!!) * @return name:config.ali_url type:int default:-- desc:支付宝支付链接 * @return name:code_url type:string default:-- desc:付款码url * @return name:openid type:string default:-- desc:openid */ public function payOrderNew() { $level_id = input('post.level_id'); $level_key = input('post.level_key'); $pay_type = input('post.pay_type',1); $user_info = User::where('id',$this->user_id)->find(); if($user_info['account_type'] == 1 && $user_info['is_first'] == 0) $this->error('请联系公司管理员进行会员开通'); $is_renew = \app\common\model\LevelOrder::where('user_id',$this->user_id)->where('status',1)->where('pay_state',1)->count(); $level_set = UserLevel::where('id', $level_id)->find()->toArray(); if (!$level_set['price']) $this->error('会员价格设置有误'); $level_price = json_decode($level_set['price'], true); if (!isset($level_price[$level_key])) $this->error('会员价格设置有误.'); //$price_total = $is_renew && $level_price[$level_key]['renew'] > 0 && $level_price[$level_key]['renew'] ? bcmul( $level_price[$level_key]['price'], $level_price[$level_key]['renew']/100,2) : $level_price[$level_key]['price']; $order_insert = [ 'user_id' => $this->user_id, 'order_no' => get_order_sn(), 'level_id' => $level_id, 'level_key' => $level_key, 'pay_type' => $pay_type, 'month' => $level_price[$level_key]['time'], 'level_title' => $level_price[$level_key]['title'], 'price_total' =>$is_renew ? $level_price[$level_key]['renew'] : $level_price[$level_key]['price'], 'pay_no' =>get_order_sn() ]; $user_vip = UserLevelRank::getUserVipInfo($this->user_id); if(!empty($user_vip) && $user_vip['level_id'] > 1) $this->error('已是会员,请联系平台'); if(!empty($user_vip) && $user_vip['user_id'] != $this->user_id) $this->error('请联系已绑定企业账号'); if(!empty($user_vip)) { $cal_time = strtotime('+'.$order_insert['month'] .' month',$user_vip['end_time']); if($cal_time > strtotime('+3 years')) $this->error('会员续费期限最多3年'); } $order_info = LOM::create($order_insert); $order_info = $order_info->toArray(); $pay_no = $order_info['pay_no']; $ret_data = ['pay_status'=>0,'config'=>[],'code_url'=>'','openid'=>$user_info['openid'],'order_id'=>$order_info['id']]; Db::startTrans(); try { switch ($pay_type){ case 1://微信 $notify_url = $this->request->root(true) . '/api/we_chat_pay/LevelOrderNotify'; $pay_config = WeChatPay::wxPay('订单支付',$pay_no,$order_info['price_total'],$notify_url,'MWEB'); if($pay_config['code'] != 200) $this->exception($pay_config['msg']); $pay_config['config']['mch_id'] = config('app.wx_pay')['mch_id']; $pay_config['config']['pay_no'] = $pay_no; $pay_config['config']['notify_url'] = $notify_url; $pay_config['config']['mweb_url'] = $pay_config['mweb_url']; $pay_config['config']['total_fee'] = $order_info['price_total'] * 100; $ret_data['config'] = $pay_config['config']; break; case 2 : $notify_url = $this->request->root(true) . '/api/Alipay/LevelOrderNotify'; $return_url ='https://'.$_SERVER['HTTP_HOST']."/dist/#/my"; $config = Alipay::ali_pay_h5('订单支付',$pay_no,$order_info['price_total'],$notify_url,$return_url); $ret_data['config']['ali_url'] = $config; $ret_data['ali_url'] = $config; break; case 3: $notify_url = $this->request->root(true) . '/api/we_chat_pay/LevelOrderNotify'; $pay_config = WeChatPay::wxPay('订单支付',$pay_no,$order_info['price_total'],$notify_url,'APP'); if($pay_config['code'] != 200) $this->exception($pay_config['msg']); $ret_data['config'] = $pay_config['config']; break; case 4: $notify_url = $this->request->root(true) . '/api/Alipay/LevelOrderNotify'; $config = Alipay::ali_pay('订单支付',$pay_no,$order_info['price_total'],$notify_url); $ret_data['config']['ali_url'] = $config; $ret_data['ali_url'] = $config; break; case 5 : if(!$user_info['openid']) $this->exception('请绑定openid'); $notify_url = $this->request->root(true) . '/api/we_chat_pay/LevelOrderNotify'; $pay_config = WeChatPay::wxPay('订单支付',$pay_no,$order_info['price_total'],$notify_url,'NATIVE',$user_info['openid']); if($pay_config['code'] != 200) $this->exception($pay_config['msg']); $ret_data['config'] = $pay_config['config']; break; case 6: $notify_url = $this->request->root(true) . '/api/we_chat_pay/LevelOrderNotify'; $pay_config = WeChatPay::wxPay('订单支付',$pay_no,$order_info['price_total'] ,$notify_url,'NATIVE'); $ret_data['config'] = $pay_config['config']; $ret_data['code_url'] = $pay_config['pc_pay_url']; break; case 7: $notify_url = $this->request->root(true) . '/api/Alipay/LevelOrderNotify'; $return_url ='https://'.$_SERVER['HTTP_HOST']."/pc/#/vip-member"; $config = Alipay::ali_pay_pc('订单支付',$pay_no,$order_info['price_total'],$notify_url,$return_url); $ret_data['config']['ali_url'] = $config; $ret_data['ali_url'] = $config; break; } Db::commit(); }catch (\Exception $e){ $this->is_commit = false; $this->ret_msg = $e->getMessage(); Db::rollback(); } $this->transReturn($ret_data); } /** * @title 获取订单列表 * @desc 获取订单列表 * @author qc * @method GET * @url /api/Level_order/getOrderList * @header name:Authorization require:1 desc:Token * @param name:page type:int default:1 desc:页数 * @param name:page_num type:int default:20 desc:每页数 * @return name:order_no type:string default:-- desc:订单号 * @return name:price_total type:float default:-- desc:待支付金额 * @return name:level_id type:float default:-- desc:等级id * @return name:level_name type:float default:-- desc:等级名称 * @return name:level_title type:float default:-- desc:等级标题 * @return name:month type:float default:-- desc:时长(月) * @return name:pay_state type:int default:-- desc:支付状态(0未支付1已支付) * @return name:bill_apply type:int default:-- desc:是否申请发票【0否1是】 * @return name:create_at type:string default:-- desc:时间 * @return name:level_logo type:string default:-- desc:等级LOGO * @return name:pay_type type:int default:-- desc:支付方式(1.h5微信,2.h5支付宝,3.app微信,4.app支付宝,5.h5微信内支付,6微信pc) * @return name:bill_info type:array default:-- desc:发票详情 */ public function getOrderList() { $field = 'id,level_id,level_key,month,price_total,pay_type,order_no,create_at,level_title'; $list = \app\common\model\LevelOrder::field($field)->where(['user_id'=>$this->user_id,'pay_state'=>1]) ->order('id desc ')->limit($this->off_set,$this->page_num)->select()->toArray(); array_walk($list,function (&$v){ $v['bill_apply'] = BillApply::checkBillApply($v['id'],1) ? 1 : 0; $level_info = UserLevel::where('id',$v['level_id'])->find()->toArray(); $v['level_name'] =$level_info['name']; $v['level_logo'] =$level_info['logo']; $bill_info = BillApply::where(['order_type'=>1,'order_id'=>$v['id']]) ->alias('b')->field('b.id,b.type,b.header,b.status,b.email,b.phone,b.bill_img,b.bill_time,b.remark,identify_number,b.create_at,t.title type_title,a.price_total money') ->leftJoin('BillType t','t.id = b.type') ->leftJoin('LevelOrder a','a.id = b.order_id') ->find(); if($bill_info) $bill_info = $bill_info->toArray(); $v['bill_info'] = $bill_info; }); $total_num = \app\common\model\LevelOrder::field($field)->where(['user_id'=>$this->user_id,'pay_state'=>1])->count(); $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * * @title 申请开票 * @desc 申请开票 * @author qc * @method POST * @url /api/Level_order/applyBill * @header name:Authorization require:1 desc:Token * @param name:order_id type:string default:1 desc:订单id * @param name:type type:int default:-- desc:类型id * @param name:header type:string default:-- desc:抬头名称[公司名称||个人名称] * @param name:identify_number type:string default:-- desc:纳税人识别号 * @param name:email type:string default:-- desc:邮箱 * @param name:remark type:string default:-- desc:备注 */ public function applyBill() { $order_id = input('post.order_id'); /* $type = input('post.type'); $header = input('post.header'); $identify_number = input('post.identify_number'); $address = input('post.address'); $bank = input('post.bank'); $card_no = input('post.card_no'); $remark = input('post.remark'); $phone = input('post.phone'); $email = input('post.email');*/ $post = input('post.'); if(!isset($post['remark'])){ $post['remark'] = ""; } $order_info = \app\common\model\LevelOrder::where('id',$order_id)->find()->toArray(); if(!$order_info['pay_state'])$this->error('订单未支付'); if(BillApply::checkBillApply($order_id,1)) $this->error('已申请开票'); // return json($post); $ret_val = UserSynth::buildBillApply($this->user_id, $order_id, 1,$post,0,1,$post['remark']); if($ret_val['code'] != 200) $this->error($ret_val['msg']); $this->success('申请成功'); } /** * @title 获取发票详情 * @desc 获取发票详情 * @author qc * @url /api/Level_order/getBillInfo * @method GET * @param name:id type:int require default:-- desc:订单id * @return name:id type:array default:-- desc:票详情id * @return name:header type:string default:0 desc:抬头 * @return name:type_title type_title:int default:0 desc:发票类型 * @return name:email type:string default:0 desc:邮箱 * @return name:create_at type:string default:0 desc:申请时间 * @return name:phone type:string default:0 desc:电话 * @return name:status type:int default:0 desc:状态(0申请中1已开票2已完成) * @return name:identify_number type:string default:0 desc:纳税人识别号 * @return name:send_type type:string default:1 desc:1点子发票2纸质发票 * @return name:remark type:string default:0 desc:备注 * @return name:bill_img type:string default:0 desc:点子发票【图片】 * @return name:bill_time type:string default:0 desc:开票时间 * */ public function getBillInfo() { $info = BillApply::where(['order_type'=>1,'order_id'=>input('get.id')]) ->alias('b')->field('b.id,b.type,b.header,b.status,b.email,b.phone,b.bill_img,b.bill_time,b.remark,identify_number,b.create_at,t.title type_title,a.price_total money') ->leftJoin('BillType t','t.id = b.type') ->leftJoin('LevelOrder a','a.id = b.order_id') ->find(); if(empty($info)) $this->error('该订单未申请发票'); $info = $info->toArray(); $this->success('ok',['detail'=>$info]); } }