xingkong_admin/application/api/controller/Order2.php

<?php
namespace app\api\controller;
use app\common\library\AliPay;
use think\cache\driver\Redis;
use think\Db;
use think\Exception;
use EasyWeChat\Factory;
use think\Session;
use function Sodium\add;

/**
 * @title 订单
 * @controller GoodsOrder
 * @group base
 */
class Order2 extends Base
{
    public function initialize()
    {
        parent::initialize();
        parent::check_login();
    }

    /**
     * @title 生成订单（立即购买 ）
     * @desc  生成订单（立即购买 ）
     * @author  Gavin
     * @url /api/Order/createOrder
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int require:1 default:-- desc:藏品id
     * @param name:num type:int require:1 default:1 desc:数量
     * @param name:pay_type type:string require:1 default:wx desc:wx:微信zfb:支付宝
     * @param name:from type:string require:1 default:wx desc:wx:微信公众号h5:网页
     *
     * @return  name:order_no type:int require:0 default:0 desc:订单号
     * @return  name:pay type:string require:0 default:0 desc:支付信息
     */
    public function createOrder()
    {
        $id = input('id');
        $num = input('num',1);
        $pay_type = input('pay_type','wx');
        $from = input('from','wx');
        if (!$id || !$num) $this->error('参数错误');
        $user = getMemberInfoHash($this->uid); //获取用户信息
        if ($user['is_auth']==0) $this->error('请实名认证后购买!');
        $coll_info = getCollectionInfoHash($id);
        if ($coll_info['is_deleted']==1 || $coll_info['status']==0) $this->error('藏品已下架');

        $inventory = getCollectionInventory($id);
        if ($inventory<1) $this->error('已售罄');

        if ($user['vip']==2){
            $advance_minutes = getAdvanceMinutes(); //获取vip提前抢购分钟
            $sell_time = strtotime($coll_info['sell_time'])-($advance_minutes*60);
        }else{
            $sell_time = strtotime($coll_info['sell_time']);
        }
        //if ($sell_time>time()) $this->error('商品还未开始售卖！请耐心等待');

   //     $snap_card = getMembercard($this->uid);  //获取用户抢购卡数量
//        if ($snap_card<1) $this->error('抢购卡不足，无法抢购');

        //获取用户已经购买数量
        $userByCount = getByCount($this->uid,$id);
       // if ($coll_info['buy_count']<($userByCount+$num)) $this->error('每人限购'.$coll_info['buy_count'].'个');

        //获取是否已经铸造hash
        $hashCount = getLenCollection($id);
        //if (!$hashCount || $hashCount<$num) $this->error('hash未铸造,无法购买');

        if (!$user['openid']) $this->error('微信未授权，无法购买');


        //先减掉库存
        loseCollectionInventory($id,$num);
        //先减掉抢购卡数量
        loseMembercard($this->uid);
        //先增加购买数量
        IncrByCount($this->uid,$id,$num);


        $order_no = get_order_sn();
        $total_fee = bcmul($coll_info['price'],$num,2);

        $redis_data = [
            'c_id'=>$id,
            'm_id'=>$this->uid,
            'order_no'=>$order_no,
            'num'=>$num,
            'pro_info'=>json_encode($coll_info),
            'status'=>0,
            'create_at'=>date('Y-m-d H:i:s'),
            'pay_price'=>$total_fee,
            'pay_type'=>$pay_type
        ];
        $com = true;
        $body = '梵易数藏购买藏品';
        switch ($pay_type){
            case 'wx':
                $config = retrunWxConfig();
                $total_fee = $total_fee * 100;
                $config['notify_url'] = $this->request->root(true).'/api/Pay/WxOrderNotify';
                $app = Factory::payment($config);

                $post_data = [
                    'body' => $body,
                    'out_trade_no' => $order_no,
                    'total_fee' => $total_fee,
                    'attach'=>$this->uid,     //自定义传值
                ];
                //trade_type   SAPI--JSAPI支付（或小程序支付）、NATIVE--Native支付、APP--app支付，MWEB--H5支付
                if ($from=='wx'){
                    $post_data['openid'] = $user['openid'];
                    $post_data['trade_type'] = 'JSAPI';
                }elseif ($from=='h5'){
                    $post_data['trade_type'] = 'MWEB';
                }

                $result = $app->order->unify($post_data);
                if ($result['return_msg']=='OK'){
                    if ($result['result_code']=='FAIL'){
                        $com = false;
                    }else{
                        $order1 = $app->jssdk->bridgeConfig($result['prepay_id']);//执行二次签名返回参数
                        $redis_data['wx_order'] = $order1;
                        $retrun_data['order_no'] = $order_no;
                        $retrun_data['pay'] = json_decode($order1,true);
                    }
                }else{
                    $com = false;
                }
                break;
            case 'zfb':
                $zfb = new AliPay();
                $notify_url = $this->request->root(true).'/api/Pay/alipayOrderNotify?uid='.$this->uid;//回调地址
                $order = $zfb->aliPay($body, $total_fee, $order_no, $notify_url);//调用支付宝支付的方法
                $retrun_data['order_no'] = $order_no;
                $retrun_data['pay'] = $order;
                break;
        }

        if ($com){
            $redis = new Redis();
            $redis->hMSet('order_not_pay_'.$this->uid,[$order_no=>json_encode($redis_data)]); //存入redis
            $this->success('成功',$retrun_data);
        }else{
            //加上库存
            addCollectionInventory($id,$num);
            //加上抢购卡数量
            addMembercard($this->uid);
            //减少用户购买数量
            DecrByCount($this->uid,$id,$num);

            $this->error('服务器繁忙，请稍后重试');
        }

    }



    /**
     * @title 生成订单（立即购买 ）
     * @desc  生成订单（立即购买 ）
     * @author  Gavin
     * @url /api/Order/createOrder
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int require:1 default:-- desc:藏品id
     * @param name:num type:int require:1 default:1 desc:数量
     * @param name:pay_type type:string require:1 default:wx desc:wx:微信zfb:支付宝
     *
     * @return  name:order_no type:int require:0 default:0 desc:订单号
     * @return  name:pay type:string require:0 default:0 desc:支付信息
     */
    public function createOrder2()
    {
        $id = input('id');
        $num = input('num',1);
        $pay_type = input('pay_type','wx');
        if (!$id || !$num) $this->error('参数错误');
        $user = getMemberInfoHash($this->uid); //获取用户信息
        if ($user['is_auth']==0) $this->error('请实名认证后购买!');
        $coll_info = getCollectionInfoHash($id);
        if ($coll_info['is_deleted']==1 || $coll_info['status']==0) $this->error('藏品已下架');

        $inventory = getCollectionInventory($id);
        if ($inventory<1) $this->error('已售罄');

        if ($user['vip']==2){
            $advance_minutes = getAdvanceMinutes(); //获取vip提前抢购分钟
            $sell_time = strtotime($coll_info['sell_time'])-($advance_minutes*60);
        }else{
            $sell_time = strtotime($coll_info['sell_time']);
        }

        //if ($sell_time>time()) $this->error('商品还未开始售卖！请耐心等待');

        //     $snap_card = getMembercard($this->uid);  //获取用户抢购卡数量
//        if ($snap_card<1) $this->error('抢购卡不足，无法抢购');

        //获取用户已经购买数量
        $userByCount = getByCount($this->uid,$id);
        // if ($coll_info['buy_count']<($userByCount+$num)) $this->error('每人限购'.$coll_info['buy_count'].'个');

        //获取是否已经铸造hash
        $hashCount = getLenCollection($id);
        //if (!$hashCount || $hashCount<$num) $this->error('hash未铸造,无法购买');


        //redis加锁判断
        if (redisSetNx($id)){
            //先减掉库存
            loseCollectionInventory($id,$num);
            //先减掉抢购卡数量
            loseMembercard($this->uid);
            //先增加购买数量
            IncrByCount($this->uid,$id,$num);

            $com = true;
            Db::startTrans();
            try {
                $order_no = get_order_sn();
                $total_fee = bcmul($coll_info['price'],$num,2);
                $order_int =[
                    'mid'           => $this->uid,
                    'c_id'          => $id,
                    'inventory'     => $coll_info['inventory'],
                    'order_no'      => $order_no,
                    'num'           => $num,
                    'pro_info'      => json_encode($coll_info),
                    'pay_type'      => $pay_type,
                    'pay_price'     => $total_fee
                ];
                Db::name('store_order')->insert($order_int);
                $retrun_data['order_no'] = $order_no;
                $retrun_data['pay'] = '';
                Db::commit();
//                $body = '象寻购买藏品';
//                switch ($pay_type){
//                    case 'wx':
//                        $config = retrunWxConfig();
//                        $total_fee = $total_fee * 100;
//                        $config['notify_url'] = $this->request->root(true).'/api/Pay/WxOrderNotify';
//                        $app = Factory::payment($config);
//
//                        $result = $app->order->unify([
//                            'body' => $body,
//                            'out_trade_no' => $order_no,
//                            'total_fee' => $total_fee,
//                            'trade_type' => 'JSAPI', // 请对应换成你的支付方式对应的值类型
//                        ]);
//                        if ($result['return_code']=='SUCCESS'){
//                            $jssdk      =   $app->jssdk;
//                            $order1 = $jssdk->appConfig($result['prepay_id']);
//                            //Db::name('store_order')->where('order_no',$order_no)->update(['wx_order'=>json_encode($order1,true)]);
//                            $retrun_data['order_no'] = $order_no;
//                            $retrun_data['pay'] = $order1;
//                            //减少数据库库存
//                            Db::name('store_collection')->where('id',$id)->setDec('now_inventory',$num);
//                            //减少用户抢购卡数量
//                            Db::name('store_member')->where('id',$this->uid)->setDec('snap_card');
//                            Db::commit();
//                        }else{
//                            $com=false;
//                            Db::rollback();
//                        }
//                        break;
//                    case 'zfb':
//                        $zfb = new AliPay();
//                        $notify_url = $this->request->root(true).'/api/Pay/alipayOrderNotify';//回调地址
//                        $order = $zfb->aliPay($body, $total_fee, $order_no, $notify_url);//调用支付宝支付的方法
//                        $retrun_data['order_no'] = $order_no;
//                        $retrun_data['pay'] = $order;
//                        //减少数据库库存
//                        Db::name('store_collection')->where('id',$id)->setDec('now_inventory',$num);
//                        //减少用户抢购卡数量
//                        Db::name('store_member')->where('id',$this->uid)->setDec('snap_card');
//                        Db::commit();
//                        break;
//                }

            }catch (\Exception $e){
                $com=false;
                Db::rollback();
            }
            if ($com){
                DelRedisSetNx($id);  //删除锁
                $this->success('成功',$retrun_data);
            }else{
                //加上库存
                addCollectionInventory($id,$num);
                //加上抢购卡数量
                addMembercard($this->uid);
                //减少用户购买数量
                DecrByCount($this->uid,$id,$num);

                DelRedisSetNx($id);  //删除锁

                $this->error('服务器繁忙，请稍后重试');
            }
        }else{
            $this->error('排队中...');
        }

    }





    /**
     * @title 我的订单-待支付、已购买
     * @desc  我的订单-待支付、已购买
     * @author  Gavin
     * @url /api/Order/getMyOrderList
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param  name:status type:int  : default:0 desc:0:待支付1：已购买
     * @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:num type:int default:-- desc:数量
     * @return  name:pay_price type:string default:-- desc:订单金额
     * @return  name:status type:int default:-- desc:类型0：待支付1：已支付
     * @return  name:cancel_time type:string default:-- desc:待支付自动取消时间
     * @return  name:pay_type type:string default:-- desc:支付方式wx:微信zfb:支付宝
     * @return  name:create_at type:string default:-- desc:创建时间
     * @return name:pro_info@name type:string default:-- desc:藏品名称
     * @return name:pro_info@cover type:string default:-- desc:藏品图片
     * @return name:pro_info@price type:string default:-- desc:藏品单价
     * @return name:pro_info@auth_img type:string default:-- desc:藏品作者头像
     * @return name:pro_info@auth_name type:string default:-- desc:藏品作者名称
     */
    public function getMyOrderList(){
        $status = input('status',0);
        $where = [
            'is_deleted'=>0,
            'status'=>$status,
            'mid'=>$this->uid
        ];
        $count = Db::name('store_order')->where($where)->count();
        $list = Db::name('store_order')
            ->where($where)
            ->field('id,c_id,order_no,num,pro_info,status,create_at,pay_price,pay_type')
            ->order('id desc')
            ->limit($this->off_set,$this->page_num)
            ->select();
        //自动取消分钟数
        $cancel_time = getCancelTime();
        foreach ($list as &$v){
            $v['pro_info'] = json_decode($v['pro_info'],true);
            if ($v['status']==0){
                $v['cancel_time'] = date('Y-m-d H:i:s',strtotime($v['create_at'])+($cancel_time*60));
            }
        }
        $this->success('成功',compact('count','list'));
    }

    /**
     * @title 待支付、已购买订单详情
     * @desc  待支付、已购买订单详情
     * @author  Gavin
     * @url /api/Order/MyOrderListDetail
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param  name:order_id type:int  : default:0 desc:订单ID
     *
     * @return  name:order_no type:string default:-- desc:订单号
     * @return  name:num type:int default:-- desc:数量
     * @return  name:pay_price type:string default:-- desc:订单金额
     * @return  name:status type:int default:-- desc:类型0：待支付1：已支付
     * @return  name:cancel_time type:string default:-- desc:待支付自动取消时间
     * @return  name:create_at type:string default:-- desc:创建时间
     * @return  name:pay_at type:string default:-- desc:支付时间
     * @return  name:pay_type type:string default:-- desc:支付方式wx:微信zfb:支付宝
     * @return name:pro_info@name type:string default:-- desc:藏品名称
     * @return name:pro_info@cover type:string default:-- desc:藏品图片
     * @return name:pro_info@price type:string default:-- desc:藏品单价
     * @return name:pro_info@auth_img type:string default:-- desc:藏品作者头像
     * @return name:pro_info@auth_name type:string default:-- desc:藏品作者名称
     */
    public function MyOrderListDetail(){
        $order_id = input('order_id');
        if (!$order_id) $this->error('参数错误');
        $order = Db::name('store_order')
            ->where('id',$order_id)
            ->where('mid',$this->uid)
            ->where('is_deleted',0)
            ->find();
        if (!$order) $this->error('订单不存在');
        //自动取消分钟数
        $cancel_time = getCancelTime();
        $order['pro_info'] = json_decode($order['pro_info'],true);
        if ($order['status']==0){
            $order['cancel_time'] = date('Y-m-d H:i:s',strtotime($order['create_at'])+($cancel_time*60));
        }
        $this->success('成功',$order);
    }


    /**
     * @title 待支付订单支付
     * @desc  待支付订单支付
     * @author  Gavin
     * @url /api/Order/payOrder
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:order_id type:int require:1 default:-- desc:订单id
     *
     * @return  name:order_no type:int require:0 default:0 desc:订单号
     * @return  name:pay type:string require:0 default:0 desc:支付信息
     */
    public function payOrder(){
        $order_id = input('order_id');   //订单id
        if (!$order_id) $this->error('参数错误');
        $order = Db::name('store_order')->where('id',$order_id)->where('is_deleted',0)->find();
        if (!$order) $this->error('订单不存在');
        if ($order['status']!=0) $this->error('订单已支付或已取消');
        $order_no = $order['order_no'];
        $total_fee = $order['pay_price'];
        $pay_type = $order['pay_type'];
        $body = '象寻购买藏品';
        switch ($pay_type){
            case 'wx':

                $config = retrunWxConfig();
                $total_fee = $total_fee * 100;
                $config['notify_url'] = $this->request->root(true).'/api/Pay/WxOrderNotify';
                $app = Factory::payment($config);

                $result = $app->order->unify([
                    'body' => $body,
                    'out_trade_no' => $order_no,
                    'total_fee' => $total_fee,
                    'trade_type' => 'APP', // 请对应换成你的支付方式对应的值类型
                ]);
                if ($result['return_code']=='SUCCESS') {
                    $jssdk = $app->jssdk;
                    $order1 = $jssdk->appConfig($result['prepay_id']);
                    Db::name('store_order')->where('order_no', $order_no)->update(['wx_order' => json_encode($order1, true)]);
                    $retrun_data['order_no'] = $order_no;
                    $retrun_data['pay'] = $order1;
                    $this->success('成功',$retrun_data);
                }else{
                    $this->error('调起支付失败，请稍后重试');
                }

                break;
            case 'zfb':
                $zfb = new AliPay();
                $notify_url = $this->request->root(true).'/api/Pay/alipayOrderNotify';//回调地址
                $order1 = $zfb->aliPay($body, $total_fee, $order_no, $notify_url);//调用支付宝支付的方法
                $retrun_data['order_no'] = $order_no;
                $retrun_data['pay'] = $order1;
                $this->success('成功',$retrun_data);
                break;
        }
    }


    /**
     * @title 取消订单
     * @desc  取消订单
     * @author  Gavin
     * @url /api/Order/cancelOrder
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:order_id type:int require:1 default:-- desc:订单id
     */
    public function cancelOrder(){
        $order_id = input('order_id');   //订单id
        if (!$order_id) $this->error('参数错误');
        $order = Db::name('store_order')->where('id',$order_id)->where('is_deleted',0)->find();
        if (!$order) $this->error('订单不存在');
        if ($order['status']!=0) $this->error('订单已支付或已取消');
        $com = true;
        Db::startTrans();
        try {
            //修改订单状态
            Db::name('store_order')->where('id',$order_id)->update(['status'=>2,'cancel_at'=>date('Y-m-d H:i:s'),'cancel_state'=>2]);
            //增加数据库库存
            Db::name('store_collection')->where('id',$order['c_id'])->setInc('now_inventory',$order['num']);
            //增加用户抢购卡数量
            Db::name('store_member')->where('id',$order['mid'])->setInc('snap_card');

            Db::commit();
        }catch (\Exception $e){
            $com=false;
            Db::rollback();
        }
        if ($com){
            //加上库存
            addCollectionInventory($order['c_id'],$order['num']);
            //加上抢购卡数量
            addMembercard($this->uid);
            //减少用户购买数量
            DecrByCount($this->uid,$order['c_id'],$order['num']);

            $this->success('取消成功');
        }else{
            $this->error('取消失败，请稍后重试');
        }
    }



    /**
     * @title 我的订单-转赠
     * @desc  我的订单-转赠
     * @author  Gavin
     * @url /api/Order/getMySendList
     * @method POST
     * @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:over_time type:string default:-- desc:转赠时间
     * @return name:status type:int default:-- desc:类型2：赠出3：获赠
     * @return name:send_name type:string default:-- desc:转赠者/受赠者
     * @return name:collectors_hash type:string default:-- desc:hash
     * @return name:pro_info@name type:string default:-- desc:藏品名称
     * @return name:pro_info@price type:string default:-- desc:藏品价格
     * @return name:pro_info@price type:string default:-- desc:藏品单价
     * @return name:pro_info@auth_img type:string default:-- desc:藏品作者头像
     * @return name:pro_info@auth_name type:string default:-- desc:藏品作者名称
     */
    public function getMySendList(){
        $where = [
            'mid'=>$this->uid,
        ];
        $count = Db::name('store_order_info')->where($where)->whereIn('status','2,3')->count();
        $list = Db::name('store_order_info')
            ->where($where)
            ->whereIn('status','2,3')
            ->field('id,order_no,pro_info,over_time,create_at,status,to_mid,collectors_hash')
            ->order('id desc')
            ->limit($this->off_set,$this->page_num)
            ->select();
        foreach ($list as &$v){
            $v['pro_info'] = json_decode($v['pro_info'],true);
            $v['send_name'] = Db::name('store_member')->where('id',$v['to_mid'])->value('name');
        }
        $this->success('成功',compact('count','list'));
    }


    /**
     * @title 转赠订单详情
     * @desc  转赠订单详情
     * @author  Gavin
     * @url /api/Order/getMySendListDetail
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param  name:order_id type:int  : default:1 desc:订单ID
     *
     * @return  name:order_no type:string default:-- desc:订单号
     * @return name:over_time type:string default:-- desc:转赠时间
     * @return name:status type:int default:-- desc:类型2：赠出3：获赠
     * @return name:send_name type:string default:-- desc:转赠者/受赠者
     * @return name:collectors_hash type:string default:-- desc:hash
     * @return name:pro_info@name type:string default:-- desc:藏品名称
     * @return name:pro_info@price type:string default:-- desc:藏品价格
     * @return name:pro_info@price type:string default:-- desc:藏品单价
     * @return name:pro_info@auth_img type:string default:-- desc:藏品作者头像
     * @return name:pro_info@auth_name type:string default:-- desc:藏品作者名称
     */
    public function getMySendListDetail(){
        $order_id = input('order_id');   //订单id
        if (!$order_id) $this->error('参数错误');
        $order = Db::name('store_order_info')
            ->where('id',$order_id)
            ->where('mid',$this->uid)
            ->find();
        if (!$order) $this->error('订单不存在');
        $order['pro_info'] = json_decode($order['pro_info'],true);
        $order['send_name'] = Db::name('store_member')->where('id',$order['to_mid'])->value('name');
        $this->success('成功',$order);
    }










    function savetest($order_no){

        $result['out_trade_no'] = $order_no;
        $order = Db::name('store_order')->where('order_no',$result['out_trade_no'])->find();
        if ($order['status']==0){
            Db::startTrans();
            try {
                Db::name('store_order')
                    ->where('order_no',$result['out_trade_no'])
                    ->update(['status'=>1,'pay_at'=>date('Y-m-d H:i:s'),'return_success_info'=>json_encode($result,true)]);

                $array = [];
                for ($i=0;$i<$order['num'];$i++){
                    //获取排名
                    $rank = getRanking($order['c_id'])+1;
                    $tag = getTag($order['c_id'],$rank,$order['inventory']);
                    saveRanking($order['c_id']);
                    $company = '象寻数字科技（上海）有限公司';
                    $company_hash = '';
                    $company_hash_time = '';
                    $collectors_hash = '';
                    $date = [
                        'order_id'=>$order['id'],
                        'order_no'=>get_order_sn(),
                        'tag'=>$tag,
                        'mid'=>$order['mid'],
                        'pro_info'=>$order['pro_info'],
                        'company'=>$company,
                        'company_hash'=>$company_hash,
                        'company_hash_time'=>$company_hash_time,
                        'collectors_hash'=>$collectors_hash,
                        'collectors_hash_time'=>date('Y-m-d H:i:s')
                    ];
                    $array[] = $date;
                }
                Db::name('store_order_info')->insertAll($array);
                Db::commit();
                // return true;
            } catch (\Exception $e){
                Db::rollback();
                //return false;
            }
        }
    }



}