lanjingling/application/api/controller/Pay.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use think\Db;
use addons\epay\library\Service;
use think\Exception;
/**
 * 充值配置与充值订单
 */
class Pay extends Api
{
    protected $noNeedLogin = ['order_notify_base'];
    protected $noNeedRight = ['*'];

    //支付订单
    //微信小程序、微信app下单使用。
    public function pay_order(){
        $pay_type = input('pay_type','wechat');
        $platform = input('platform','miniapp');
        $orderid = input('orderid','0');
        $uid = $this->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 '<pre>';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;
    }

}