xianglian_test_api/application/api/controller/Secondary.php

<?php


namespace app\api\controller;

use Alipay\EasySDK\Kernel\Util\ResponseChecker;
use app\common\library\AliPay;
use app\common\library\Shande;
use app\common\library\ShandeRapid;
use EasyWeChat\Factory;
use think\cache\driver\Redis;
use think\Db;
use think\Exception;
use function EasyWeChat\Kernel\Support\get_client_ip;
use function Symfony\Component\String\length;


/**
 * @title 二级市场
 * @controller secondary
 * @package app\api\controller
 */
class Secondary extends Base
{

    public function initialize(){
        parent::initialize();
        parent::check_login();
    }

    /**
     * @title 藏品出售
     * @desc  藏品出售
     * @author  Gavin
     * @url /api/Secondary/sell
     * @method POST
     * @header name:Authorization require:1 desc:Token
     *
     * @param name:id type:int require:1 default:1 desc:藏品ID
     * @param name:resale_price type:decimal require:1 default:1 desc:出售价格
     * @param name:second_password type:int require:1 default:-- desc:支付密码
     *
     */
    public function sell(){
        $this->checkSwitch(1);
        $id = input('id');

        //$this->error('暂时关闭');

        $user = getMemberInfoHash($this->uid); //获取用户信息
        if ($user['is_auth']==0) $this->error('请先实名认证!');
        $resale_price = input('resale_price');
        $second_password = input('second_password');
        if (!$id || !$resale_price) $this->error('参数错误');
        //if ($resale_price<'1') $this->error('最低1元');
        if ($resale_price<'0.1') $this->error('最低0.1元');
        if ($resale_price>'99999') $this->error('最高99999元');
        $info = Db::name('store_order_info')
            ->where('mid',$this->uid)
            ->where('id',$id)
            ->find();
        if (!$info || $info['status']==2) $this->error('藏品不存在');
        if ($info['resale_status']!=1) $this->error('挂售状态错误');
        if ($user['second_password']!=md5($second_password)) $this->error('密码错误');
        $update_data = [
            'resale_status'=>2,
            'resale_time'=>date('Y-m-d H:i:s'),
            'resale_price'=>$resale_price
        ];
        if (Db::name('store_order_info')->where('id',$id)->update($update_data)){
            $this->success('成功');
        }
        $this->error('失败');
    }

    /**
     * @title 藏品取消出售
     * @desc  藏品取消出售
     * @author  Gavin
     * @url /api/Secondary/cancel_sell
     * @method POST
     * @header name:Authorization require:1 desc:Token
     *
     * @param name:id type:int require:1 default:1 desc:藏品ID
     */
    public function cancel_sell(){
        $this->checkSwitch(1);
        $id = input('id');
        if (!$id) $this->error('参数错误');
        $info = Db::name('store_order_info')
            ->where('mid',$this->uid)
            ->where('id',$id)
            ->find();
        if (!$info || $info['status']==2) $this->error('藏品不存在');
        if ($info['resale_status']!=2) $this->error('挂售状态错误');
        //判断是否有待支付订单
        $count = Db::name('store_order_info_order')->where('info_id',$id)->where('status',0)->count();
        if ($count) $this->error('支付中，无法取消');

        $update_data = [
            'resale_status'=>1,
        ];
        if (Db::name('store_order_info')->where('id',$id)->update($update_data)){
            $this->success('成功');
        }
        $this->error('失败');
    }


    /**
     * @title 标签列表
     * @desc  标签列表
     * @author  Gavin
     * @url /api/Secondary/label_list
     * @method POST
     * @header name:Authorization require:1 desc:Token
     */
    public function label_list(){
        $list = Db::name('store_collection')->whereNotIn('label','测试,测试勿拍')->group('label')->column('label');
        $list = array_merge(['全部'],$list);
        $this->success('成功',['label_list'=>$list]);
    }


    /**
     * @title 二级市场列表
     * @desc  二级市场列表
     * @author  Gavin
     * @url /api/Secondary/sell_list
     * @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:每页数
     *
     * @param name:keyword type:string require:0 default: desc:关键词
     * @param name:label type:string require:0 default: desc:标签
     * @param name:type type:int require:0 default: desc:0全部1普通藏品3盲盒
     * @param name:time_order type:string require:0 default: desc:时间排序（asc：正序desc:倒序）
     * @param name:price_order type:string require:0 default: desc:价格排序（asc：正序desc:倒序）
     *
     * @return  name:name type:string require:0 default:0 desc:藏品名称
     * @return  name:cover type:string require:0 default:0 desc:图片
     * @return  name:member_name type:string require:0 default:0 desc:出售人名称
     * @return  name:member_headimg type:string require:0 default:0 desc:出售人头像
     * @return  name:resale_price type:string require:0 default:0 desc:出售价格
     */
    public function sell_list(){
        $keyword = input('keyword');
        $label = input('label');
        $time_order = input('time_order');
        $price_order = input('price_order');
        $type = input('type',0);
        $count = Db::name('store_order_info')
            ->where('status','neq',2)
            ->where('resale_status',2)
            ->where('is_destruction',1)
            ->when($keyword,function ($query) use ($keyword){
                $query->whereLike('name','%'.$keyword.'%');
            })
            ->when($label,function ($query) use ($label){
                if ($label!='全部'){
                    $ids = Db::name('store_collection')->where('label',$label)->column('id');
                    $query->whereIn('c_id',$ids);
                }
            })->when($type,function ($query)use ($type){
                if($type > 0) $query->where('type',$type);
            })->count();
        $list = Db::name('store_order_info')
            ->where('status','neq',2)
            ->where('resale_status',2)
            ->where('is_destruction',1)
            ->when($keyword,function ($query) use ($keyword){
                $query->whereLike('name','%'.$keyword.'%');
            })
            ->when($label,function ($query) use ($label){
                if ($label!='全部'){
                    $ids = Db::name('store_collection')->where('label',$label)->column('id');
                    $query->whereIn('c_id',$ids);
                }
            })->when($type,function ($query)use ($type){
                if($type > 0) $query->where('type',$type);
            })
            ->when($price_order,function ($query) use ($price_order){
                $query->order('resale_price '.$price_order);
            })
            ->when($time_order,function ($query) use ($time_order){
                $query->order('resale_time '.$time_order);
            })
            ->limit($this->off_set,$this->page_num)
            ->order('id desc')
            ->select();
        $sql = '';
        foreach ($list as &$v){
            $member = getMemberInfoHash($v['mid']); //获取用户信息
            $v['member_name'] = $member['name'];
            $v['member_headimg'] = $member['headimg'];
            $v['pro_info'] = json_decode($v['pro_info'],true);
            $buy_count = Db::name('store_order_info_order')->where('info_id',$v['id'])->where('status',0)->count();
            $v['is_buy'] = $buy_count>0 ? 1 : 0;
        }
        $this->success('成功',compact('count','list','sql'));
    }


    /**
     * @title 二级市场详情
     * @desc  二级市场详情
     * @author  Gavin
     * @url /api/Secondary/sell_list_detail
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param  name:id type:int  : default: desc:id
     * @return  name:id type:int require:0 default:0 desc:藏品ID
     * @return  name:tag type:string require:0 default:0 desc:唯一标签
     * @return  name:collectors_name type:string require:0 default:0 desc:收藏者
     * @return  name:collectors_hash type:string require:0 default:0 desc:收藏者hash
     * @return  name:create_at type:string require:0 default:0 desc:收藏时间
     * @return  name:company type:string require:0 default:0 desc:流转公司
     * @return  name:company_hash type:string require:0 default:0 desc:流转公司hash
     * @return  name:resale_status type:string require:0 default:0 desc:1:未挂售2挂售中3已出售
     * @return  name:resale_price type:float require:0 default:0 desc:二级市场挂售价格
     * @return  name:pro_info@name type:string require:0 default:0 desc:藏品名称
     * @return  name:pro_info@price type:string require:0 default:0 desc:藏品价格
     * @return  name:pro_info@label type:string require:0 default:0 desc:藏品标签
     * @return  name:pro_info@cover type:string require:0 default:0 desc:藏品图片
     * @return  name:pro_info@auth_img type:string require:0 default:0 desc:作者头像
     * @return  name:pro_info@auth_name type:string require:0 default:0 desc:作者姓名
     * @return  name:pro_info@warm_prompt type:string require:0 default:0 desc:温馨提示
     * @return  name:pro_info@share_img type:string require:0 default:0 desc:分享二维码
     * @return  name:member_name type:string require:0 default:0 desc:用户名
     * @return  name:member_headimg type:string require:0 default:0 desc:用户头像
     * @return  name:is_buy type:int require:0 default:0 desc:是否可以购买【1是0否】
     */
    public function sell_list_detail(){
        $id = input('id');
        if (!$id) $this->error('参数错误');
        $info = Db::name('store_order_info')
            ->where('status','neq',2)
            ->where('resale_status',2)
            ->where('is_destruction',1)
            ->where('id',$id)
            ->find();
        if (!$info) $this->error('藏品不存在');
        $member = getMemberInfoHash($info['mid']); //获取用户信息
        $info['member_name'] = $member['name'];
        $info['member_headimg'] = $member['headimg'];
        $info['pro_info'] = json_decode($info['pro_info'],true);
        //判断是否有待支付订单
        $count = Db::name('store_order_info_order')->where('info_id',$id)->where('status',0)->count();
        $info['is_buy'] = $count>0 ? 1 : 0;
        $this->success('成功',$info);
    }



    /**
     * @title 购买
     * @desc  购买
     * @author  Gavin
     * @url /api/Secondary/createOrder
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int require:1 default: desc:主键ID
     * @param name:pay_type type:string require:1 default:wx desc:wx:微信,zfb:支付宝,sd:杉德h5,wallet余额,sd_rapid:杉德快捷支付
     * @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(){

        if (redisSetNx('SecondaryCreateOrder'.$this->uid,3)) {

            $this->checkSwitch(1);
            $id = input('id');
            $orderinfoid = input('id');
            //redis原子锁
            if (redisSetNx('SecondaryOrderCid'.$orderinfoid,5)) {
                $pay_type = input('pay_type','wx');
                $this->checkSwitch(2,$pay_type);
                $from = input('from','wx');
                $user = getMemberInfoHash($this->uid); //获取用户信息
                if (!$id) $this->error('参数错误');
                if ($user['is_auth']==0) $this->error('请先实名认证!');
                $info = Db::name('store_order_info')->where('id',$id)->find();
                if (!$info) $this->error('藏品不存在');
                if ($info['resale_status']==3) $this->error('藏品已出售');
                if ($info['resale_status']==1) $this->error('藏品已撤销出售');
                if ($info['mid']==$this->uid) $this->error('不能购买自己出售的藏品');

                //if (isset($user['buy_time']) && $user['buy_time']>date('Y-m-d H:i:s')) $this->error('一小时取消3次以上，24小时内禁止下单');

                //判断是否有未支付订单
                $order_count = Db::name('store_order_info_order')->where('mid',$this->uid)->where('status',0)->count();
                if ($order_count) $this->error('有未支付订单，无法下单');

                //判断是否有待支付订单
                $count = Db::name('store_order_info_order')->where('info_id',$id)->where('status',0)->count();
                if ($count) $this->error('支付中，无法下单');

                $service_fee = getConfigValue('service_fee');
                $royalties = getConfigValue('royalties');
                $com = true;
                $retrun_data = [];
                $error_msg = '失败，请稍后重试';
                Db::startTrans();
                try {
                    $order_no = get_order_sn();
                    //获取价格
                    $price = $info['resale_price'];
                    $num = 1;
                    $discount = getMemberServiceCharge($this->uid);// 折扣
                    $proportion = sprintf("%.2f",$price *($service_fee/100) * $discount);    //四舍五入保留两位小数点
                    $roya = sprintf("%.2f",$price *($royalties/100) * $discount);    //四舍五入保留两位小数点
                    $total_fee = bcmul($price,$num,2);
                    $real_money = $price-$proportion-$roya;
                    if($pay_type == 'wallet' && $user['money'] < $total_fee) throw new Exception('余额不足');
                    $data = [
                        'order_no'=>$order_no,
                        'mid'=>$this->uid,
                        'info_id'=>$id,
                        'num'=>$num,
                        'pro_info'=>json_encode($info,true),
                        'pay_price'=>$total_fee,
                        'service_fee'=>$service_fee,
                        'royalties'=>$royalties,
                        'to_account'=>$real_money,
                        'pay_type'=>$pay_type
                    ];
                    $id = Db::name('store_order_info_order')->insertGetId($data);
                    $body = '象链数藏购买二级市场藏品';
                    switch ($pay_type){
                        case 'wx':
                            $config = retrunWxConfig();
                            $total_fee = $total_fee * 100;
                            $config['notify_url'] = 'https://'.$_SERVER['HTTP_HOST'].'/index.php/api/Pay/SecondaryWxOrderNotify';
                            $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;
                                    Db::rollback();
                                }else{
                                    $order1 = $app->jssdk->bridgeConfig($result['prepay_id']);//执行二次签名返回参数
                                    $retrun_data['order_no'] = $order_no;
                                    $retrun_data['id'] = $id;
                                    $retrun_data['pay'] = json_decode($order1,true);
                                    Db::commit();
                                }
                            }else{
                                $com = false;
                                Db::rollback();
                            }
                            break;
                        case 'zfb':
                            $zfb = new AliPay();
                            $notify_url = 'https://'.$_SERVER['HTTP_HOST'].'/index.php/api/Pay/alipaySecondaryNotify';//回调地址
                            $order = $zfb->ali_pay_pc($body, $total_fee, $order_no, $notify_url,'https://'.$_SERVER['HTTP_HOST'].'/h5/pages/shop/order');//调用支付宝支付的方法
                            $retrun_data['order_no'] = $order_no;
                            $retrun_data['id'] = $id;
                            $retrun_data['pay'] = $order;
                            Db::commit();
                            break;
                        case 'wallet':
                            if($user['money'] < $total_fee) throw new Exception('余额不足');
                            $pay_res = (new Pay())->dealSecondary(['out_trade_no' => $order_no,'attach'=>$this->uid]);
                            if(!$pay_res) throw new Exception('支付失败');
                            memberMoneyChange($total_fee,3,$this->uid,'二级市场余额支付',0,$id,4);
                            setMemberInfoHash($this->uid);
                            $retrun_data = null;
                            Db::commit();
                            break;
                        case 'sd':
                            $client = new Shande();
                            $notify_url = 'https://'.$_SERVER['HTTP_HOST'].'/api/Pay/shandeSecondaryNotify';//回调地址
                            $total_fee = $total_fee*100;
                            $lenth = strlen($total_fee);
                            $total_fee = get0number($lenth).$total_fee;
                            $result = $client->orderPay($order_no,$total_fee,$body,$notify_url,'https://'.$_SERVER['HTTP_HOST'].'/h5/pages/shop/order',$user['bank_num']);
                            $retrun_data['order_no'] = $order_no;
                            $retrun_data['id'] = $id;
                            $retrun_data['pay'] = json_decode($result['data'],true);
                            Db::commit();
                            break;
                        case 'sd_rapid':
                            if(!$user['true_name'] || !$user['id_card']) throw new Exception('请实名认证,在进行订单支付');
                            $rapid = new ShandeRapid();
                            $notify_url = 'https://'.$_SERVER['HTTP_HOST'].'/api/Pay/shandeSecondaryNotify';//回调地址
                            $order_nos = get_order_sn();
                            Db::name('store_order_info_order')->where('order_no',$order_no)->where('mid',$this->uid)->update(['order_no'=>$order_nos]);
                            $return_url ='https://'.$_SERVER['HTTP_HOST']."/h5/pages/mine/mine?id={$id}&orderNo={$order_nos}";//回调地址
                            $pay_extra = json_encode(['userId'=>"$this->uid",'userName'=>$user['true_name'],'idCard'=>$user['id_card']]);
                            $pay_url =  $rapid->payOrder($order_nos,$total_fee,$notify_url,$return_url,$pay_extra,$body);
                            parse_str(parse_url($pay_url)['query'],$pay_query);
                            $retrun_data['parse_url'] = parse_url($pay_url)['query'];
                            $retrun_data['order_no'] = $order_nos;
                            $retrun_data['extend']  = $this->uid;
                            $retrun_data['pay_url'] = $pay_url;
                            $retrun_data['pay_query'] = $pay_query;
                            Db::commit();
                            break;
                        default:
                            throw new Exception('支付方式错误');
                            break;
                    }
                }catch (\Exception $e){
                    $com=false;
                    $error_msg = $e->getMessage();
                    Db::rollback();
                }
                DelRedisSetNx('SecondaryCreateOrder' . $this->uid);
                DelRedisSetNx('SecondaryOrderCid'.$orderinfoid);
                if ($com) $this->success('成功',$retrun_data);
                $this->error($error_msg);
            }else{
                $this->error('服务器繁忙，请稍后重试11');
            }
        }else{
            $this->error('服务器繁忙，请稍后重试');
        }

    }


    /**
     * @title 二级市场我的转售列表
     * @desc  二级市场我的转售列表
     * @author  Gavin
     * @url /api/Secondary/my_sell_list
     * @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:每页数
     *
     * @param name:keyword type:string require:0 default: desc:关键词
     * @param name:time_order type:string require:0 default: desc:时间排序（asc：正序desc:倒序）
     * @param name:price_order type:string require:0 default: desc:价格排序（asc：正序desc:倒序）
     *
     * @return  name:name type:string require:0 default:0 desc:藏品名称
     * @return  name:cover type:string require:0 default:0 desc:图片
     * @return  name:member_name type:string require:0 default:0 desc:出售人名称
     * @return  name:member_headimg type:string require:0 default:0 desc:出售人头像
     * @return  name:resale_price type:string require:0 default:0 desc:出售价格
     */
    public function my_sell_list(){
        $keyword = input('keyword');
        $time_order = input('time_order');
        $price_order = input('price_order');
        $count = Db::name('store_order_info')
            ->where('mid',$this->uid)
            ->where('resale_status','neq',1)
            ->when($keyword,function ($query) use ($keyword){
                $query->whereLike('name','%'.$keyword.'%');
            })
            ->count();
        $list = Db::name('store_order_info')
            ->where('mid',$this->uid)
            ->where('resale_status','neq',1)
            ->when($keyword,function ($query) use ($keyword){
                $query->whereLike('name','%'.$keyword.'%');
            })

            ->when($price_order,function ($query) use ($price_order){
                $query->order('resale_price '.$price_order);
            })
            ->when($time_order,function ($query) use ($time_order){
                $query->order('resale_time '.$time_order);
            })
            ->order('id desc')
            ->limit($this->off_set,$this->page_num)
            ->select();
        foreach ($list as &$v){
            $member = getMemberInfoHash($v['mid']); //获取用户信息
            $v['member_name'] = $member['name'];
            $v['member_headimg'] = $member['headimg'];
            $v['pro_info'] = json_decode($v['pro_info'],true);
        }
        $this->success('成功',compact('count','list'));
    }





    /**
     * @title 二级市场订单【列表】
     * @desc  二级市场订单
     * @author  Gavin
     * @url /api/Secondary/secondaryOrderList
     * @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:每页数
     * @param name:status type:int require:0 default:0 desc:0:待支付1：已购买2：转售中3：已转售
     *
     * @return  name:name type:string require:0 default:0 desc:藏品名称
     * @return  name:cover type:string require:0 default:0 desc:图片
     * @return  name:status type:int require:0 default:0 desc:[订单状态：0待支付,1已支付,2取消],
     * @return  name:resale_status type:int require:0 default:0 desc:[寄售状态：1:未挂售 2：挂售中 3：已出售]
     * @return  name:member_name type:string require:0 default:0 desc:出售人名称
     * @return  name:member_headimg type:string require:0 default:0 desc:出售人头像
     * @return  name:pay_price type:string require:0 default:0 desc:出售价格（已购买、待支付使用）
     * @return  name:resale_price type:string require:0 default:0 desc:出售价格（转售中、已转售使用）
     * @return  name:cancel_time type:string require:0 default:0 desc:取消时间【status=0有用】
     * @return name:pro_info@name type:string default:-- desc:藏品名称
     * @return name:pro_info@price type:string default:-- desc:藏品价格
     * @return name:pro_info@cover 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 secondaryOrderList(){
        $status = input('status',0);
        switch ($status){
            case 0:case 1:
            $count =  Db::name('store_order_info_order')
                ->where('mid',$this->uid)
                ->where('status',$status)
                ->count();
            $list = Db::name('store_order_info_order')
                ->where('mid',$this->uid)
                ->where('status',$status)
                ->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);
                $member = getMemberInfoHash($v['mid']); //获取用户信息
                $v['member_name'] = $member['name'];
                $v['member_headimg'] = $member['headimg'];
                if ($v['status']==0){
                    $v['cancel_time'] = date('Y-m-d H:i:s',strtotime($v['create_at'])+($cancel_time*60));
                }
            }
            break;
            case 2:case 3:
            $count = Db::name('store_order_info')
                ->where('mid',$this->uid)
                ->where('resale_status',$status)
                ->where('is_destruction',1)
                ->count();
            $list = Db::name('store_order_info')
                ->where('mid',$this->uid)
                ->where('resale_status',$status)
                ->where('is_destruction',1)
                ->order('id desc')
                ->limit($this->off_set,$this->page_num)
                ->select();
            foreach ($list as &$v){
                $v['pro_info'] = json_decode($v['pro_info'],true);
                $member = getMemberInfoHash($v['mid']); //获取用户信息
                $v['member_name'] = $member['name'];
                $v['member_headimg'] = $member['headimg'];
            }
            break;
            default:
                $count =  Db::name('store_order_info_order')
                    ->where('mid',$this->uid)
                    ->count();
                $list = Db::name('store_order_info_order')
                    ->where('mid',$this->uid)
                    ->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);
                    $member = getMemberInfoHash($v['mid']); //获取用户信息
                    $v['member_name'] = $member['name'];
                    $v['member_headimg'] = $member['headimg'];
                    if ($v['status']==0) $v['cancel_time'] = date('Y-m-d H:i:s',strtotime($v['create_at'])+($cancel_time*60));
                }
                break;
        }
        $this->success('成功',compact('count','list'));
    }


    /**
     * @title 二级市场订单【详情】
     * @desc  二级市场订单
     * @author  Qc
     * @url /api/Secondary/secondaryOrderDetail
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int require:0 default:-- desc:二级市场订单id
     * @return  name:name type:string require:0 default:0 desc:藏品名称
     * @return  name:cover type:string require:0 default:0 desc:图片
     * @return  name:status type:int require:0 default:0 desc:0待支付,1已支付,2取消
     * @return  name:pay_type type:string require:0 default:0 desc:支付方式：wx:微信zfb:支付宝wallet:余额
     * @return  name:order_no type:string require:0 default:0 desc:单号
     * @return  name:create_at type:string require:0 default:0 desc:下单时间
     *
     * @return  name:pay_at type:string require:0 default:0 desc:支付时间
     * @return  name:user_name type:string require:0 default:0 desc:售卖人名称
     * @return  name:member_name type:string require:0 default:0 desc:买方名称
     * @return  name:member_headimg type:string require:0 default:0 desc:买方头像
     * @return  name:pay_price type:string require:0 default:0 desc:出售价格（已购买、待支付使用）
     * @return  name:resale_price type:string require:0 default:0 desc:出售价格（转售中、已转售使用）
     * @return  name:cancel_time type:string require:0 default:0 desc:取消时间【status=0有用】
     * @return name:pro_info@name type:string default:-- desc:藏品名称
     * @return name:pro_info@price type:string default:-- desc:藏品价格
     * @return name:pro_info@cover 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 secondaryOrderDetail()
    {
        $detail = Db::name('store_order_info_order')->where('mid',$this->uid)->where('id',input('id'))->find();
        if(empty($detail)) $this->error('订单不存在');
        $member = getMemberInfoHash($detail['mid']); //获取用户信息
        $cancel_time = getCancelTime();
        $detail['member_name'] = $member['name'];
        $detail['member_headimg'] = $member['headimg'];
        if ($detail['status']==0) $detail['cancel_time'] = date('Y-m-d H:i:s',strtotime($detail['create_at'])+($cancel_time*60));
        $detail['pro_info'] = json_decode($detail['pro_info'],true);
        $sell_info = Db::name('store_order_info')->alias('o')
            ->field('o.*,m.name user_name,m.headimg')
            ->where('o.id',$detail['info_id'])
            ->leftJoin('store_member m','m.id = o.mid')
            ->find();
        $detail['user_name'] = $sell_info['user_name'];
        $this->success('ok',$detail);
    }

    /**
     * @title 根据藏品id获取二级市场订单【流转订单：已转售转售订单】
     * @desc  二级市场订单
     * @author  Qc
     * @url /api/Secondary/getSecondaryOrderDetailByCollect
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int require:0 default:-- desc:已转售记录id
     * @return  name:name type:string require:0 default:0 desc:藏品名称
     * @return  name:cover type:string require:0 default:0 desc:图片
     * @return  name:status type:int require:0 default:0 desc:0待支付,1已支付,2取消
     * @return  name:pay_type type:string require:0 default:0 desc:支付方式：wx:微信zfb:支付宝wallet:余额，sd:杉德h5,sd_rapid:杉德快捷充值
     * @return  name:order_no type:string require:0 default:0 desc:单号
     * @return  name:create_at type:string require:0 default:0 desc:下单时间
     * @return  name:pay_at type:string require:0 default:0 desc:支付时间
     * @return  name:member_name type:string require:0 default:0 desc:买方名称
     * @return  name:member_headimg type:string require:0 default:0 desc:买方头像
     * @return  name:pay_price type:string require:0 default:0 desc:出售价格（已购买、待支付使用）
     * @return  name:resale_price type:string require:0 default:0 desc:出售价格（转售中、已转售使用）
     * @return  name:cancel_time type:string require:0 default:0 desc:取消时间
     * @return name:pro_info@name type:string default:-- desc:藏品名称
     * @return name:pro_info@price type:string default:-- desc:藏品价格
     * @return name:pro_info@cover 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 getSecondaryOrderDetailByCollect()
    {
        $collect_id = input('id');
        $collect_info =  Db::name('store_order_info')->where('mid',$this->uid)
            ->where('id',$collect_id)->where('resale_status',3)->find();
        if(!$collect_info ) $this->error('藏品记录有误');
        $order_info = Db::name('store_order_info_order')
            ->where('info_id',$collect_id)->where('status',1)->find();
        if(!$order_info) $this->error('订单不存在');
        $member = getMemberInfoHash($order_info['mid']); //获取用户信息
        $order_info['member_name'] = $member['name'];
        $order_info['member_headimg'] = $member['headimg'];
        $order_info['pro_info'] = json_decode($order_info['pro_info'],true);
        $pro_info =  json_decode($order_info['pro_info']['pro_info'],true);
        $order_info['pro_info']['cover']  =$pro_info['cover'];
        $order_info['pro_info']['name']  =$pro_info['name'];
        $this->success('ok',$order_info);
    }

    /**
     * @title 取消订单
     * @desc  取消订单
     * @author  Gavin
     * @url /api/Secondary/cancelOrder
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:order_no type:string require:1 default:-- desc:订单号
     */
    public function cancelOrder(){
        $order_no = input('order_no');
        if (!$order_no) $this->error('参数错误');
        $order = Db::name('store_order_info_order')
            ->where('order_no',$order_no)
            ->where('mid',$this->uid)
            ->find();
        if (!$order) $this->error('订单不存在');
        if ($order['status']!=0) $this->error('订单已支付或已取消');
        $com = true;
        Db::startTrans();
        try {
            $up_data = [
                'status'=>2,
                'cancel_at'=>date('Y-m-d H:i:s'),
                'cancel_state'=>2
            ];
            Db::name('store_order_info_order')->where('order_no',$order_no)->update($up_data);

            $cancle = [
                'mid'=>$this->uid,
                'order_id'=>$order['id']
            ];
            Db::name('store_order_info_cancel_log')->insert($cancle);

            $time = date('Y-m-d H:i:s',time()-(60*60));
            $count = Db::name('store_order_info_cancel_log')->where('mid',$this->uid)->where('create_at','gt',$time)->count();
            if ($count>2){
                $buy_time = date('Y-m-d H:i:s',time()+(24*60*60));
                Db::name('store_member')->where('id',$this->uid)->update(['buy_time'=>$buy_time]);
            }

            Db::commit();
        }catch (\Exception $e){
            $com=false;
            Db::rollback();
        }
        if ($com){
            setMemberInfoHash($this->uid);
            $this->success('取消成功');
        }else{
            $this->error('取消失败，请稍后重试');
        }
    }

    /**
     * @title 待支付订单支付
     * @desc  待支付订单支付
     * @author  Gavin
     * @url /api/Secondary/payOrder
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:string require:1 default:-- desc:订单id
     * @param name:order_no type:string require:1 default:-- desc:订单号
     * @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:支付信息
     * @return name:order_no type:string default:0 desc:支付单号（sd）
     * @return name:extend type:int default:0 desc:用户id（sd）
     * @return name:pay type:array default:0 desc:支付信息（sd）
     * @return name:pay.body type:array default:0 desc:支付信息（sd）
     * @return name:pay.totalAmount type:string default:0 desc:支付金额【000000010000是100元】（sd）
     * @return name:pay.orderCode type:string default:0 desc:支付单号（sd）
     * @return name:pay.credential type:string default:0 desc:正书（sd）
     */
    public function payOrder(){
        $this->checkSwitch(1);
        $user = getMemberInfoHash($this->uid); //获取用户信息
        $order_no = input('order_no');   //订单号
        $id = input('id');
        $from = input('from','wx');
        if (!$order_no) $this->error('参数错误');
        if (!$id) $this->error('参数错误');
        $order = Db::name('store_order_info_order')
            // ->where('order_no',$order_no)
            ->where('id',$id)
            ->where('mid',$this->uid)
            ->find();
        if (!$order) $this->error('订单不存在');
        $order_no = $order['order_no'];
        $pay_type = $order['pay_type'];
        $this->checkSwitch(2,$pay_type);
        if ($order['status']!=0) $this->error('订单已支付或已取消');
        $CancelTime = getCancelTime();
        if (strtotime($order['create_at']) + $CancelTime * 60 < time()) $this->error('订单超时');
        $info = Db::name('store_order_info')->where('id',$order['info_id'])->find();
        if ($info['resale_status']!=2) $this->error('藏品已出售或已撤销出售');
        $com = true;
        $retrun_data=[];
        $retrun_data['user_id'] = $this->uid;
        $error_msg = '失败，请稍后重试';
        Db::startTrans();
        try {
            //获取价格
            $total_fee = $order['pay_price'];
            $body = '象链数藏购买二级市场藏品';
            switch ($pay_type){
                case 'wx':
                    $config = retrunWxConfig();
                    $total_fee = $total_fee * 100;
                    $config['notify_url'] = 'https://'.$_SERVER['HTTP_HOST'].'/api/Pay/SecondaryWxOrderNotify';
                    $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;
                            Db::rollback();
                        }else{
                            $order1 = $app->jssdk->bridgeConfig($result['prepay_id']);//执行二次签名返回参数
                            $retrun_data['order_no'] = $order_no;
                            $retrun_data['id'] = $order['id'];
                            $retrun_data['pay'] = json_decode($order1,true);
                            Db::commit();
                        }
                    }else{
                        $com = false;
                        Db::rollback();
                    }
                    break;
                case 'zfb':
                    $zfb = new AliPay();
                    $notify_url = 'https://'.$_SERVER['HTTP_HOST'].'/api/Pay/alipaySecondaryNotify';//回调地址
                    $order = $zfb->ali_pay_pc($body, $total_fee, $order_no, $notify_url,'https://'.$_SERVER['HTTP_HOST'].'/h5/pages/shop/order');//调用支付宝支付的方法
                    $retrun_data['order_no'] = $order_no;
                    $retrun_data['id'] = $order['id'];
                    $retrun_data['pay'] = $order;
                    Db::commit();
                    break;
                case 'sd':
                    $client = new Shande();
                    $notify_url = 'https://'.$_SERVER['HTTP_HOST'].'/api/Pay/shandeSecondaryNotify';//回调地址
                    $total_fee = $total_fee*100;
                    $lenth = strlen($total_fee);
                    $total_fee = get0number($lenth).$total_fee;
                    $order_nos = get_order_sn();
                    if (Db::name('store_order_info_order')
                        ->where('order_no',$order_no)
                        ->where('mid',$this->uid)
                        ->update(['order_no'=>$order_nos])){
                        $result = $client->orderPay($order_nos,$total_fee,$body,$notify_url,'https://'.$_SERVER['HTTP_HOST'].'/h5/pages/mine/mine',$user['bank_num']);
                        $retrun_data['order_no'] = $order_nos;
                        $retrun_data['id'] = $order['id'];
                        $retrun_data['pay'] = json_decode($result['data'],true);
                        if( $retrun_data['pay']['head']['respCode'] != '00000') throw new Exception($retrun_data['pay']['head']['respMsg'].'请重新下单');
                        Db::commit();
                    }else{
                        $com=false;
                        Db::rollback();
                    }
                    break;
                case 'wallet':
                    if($user['money'] < $total_fee) throw new Exception('余额不足');
                    $pay_res = (new Pay())->dealSecondary(['out_trade_no' => $order_no,'attach'=>$this->uid]);
                    if(!$pay_res) throw new Exception('支付失败');
                    memberMoneyChange($total_fee,3,$this->uid,'二级市场余额支付',0,$order['id'],4);
                    setMemberInfoHash($this->uid);
                    $retrun_data = null;
                    Db::commit();
                    break;
                case 'sd_rapid' :
                    if(!$user['true_name'] || !$user['id_card']) throw new Exception('请实名认证,在进行订单支付');
                    $rapid = new ShandeRapid();
                    $notify_url = 'https://'.$_SERVER['HTTP_HOST'].'/api/Pay/shandeSecondaryNotify';//回调地址
                    $order_nos = get_order_sn();
                    Db::name('store_order_info_order')->where('order_no',$order_no)->where('mid',$this->uid)->update(['order_no'=>$order_nos]);
                    $return_url ='https://'.$_SERVER['HTTP_HOST']."/h5/pages/mine/mine?id={$order['id']}&orderNo={$order_nos}";//回调地址
                    $pay_extra = json_encode(['userId'=>"$this->uid",'userName'=>$user['true_name'],'idCard'=>$user['id_card']]);
                    $pay_url =  $rapid->payOrder($order_nos,$total_fee,$notify_url,$return_url,$pay_extra,$body);
                    parse_str(parse_url($pay_url)['query'],$pay_query);
                    $retrun_data['parse_url'] = parse_url($pay_url)['query'];
                    $retrun_data['order_no'] = $order_nos;
                    $retrun_data['extend']  = $this->uid;
                    $retrun_data['pay_url'] = $pay_url;
                    $retrun_data['pay_query'] = $pay_query;
                    Db::commit();
                    break;
            }
        }catch (\Exception $e){
            $com=false;
            $error_msg= $e->getMessage();
            Db::rollback();
        }
        if ($com){
            $this->success('成功',$retrun_data);
        }
        $this->error($error_msg);
    }


    /**
     * @param 判断开关
     * @param string $pay_type
     * @return bool
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function checkSwitch($type,$pay_type=''){
        if ($type==1){
            $v = getConfigValue('secondary_sell_switch');
            if (!$v) $this->error('维护中，暂时关闭');
        }elseif ($type==2){
            $nameArray = ['secondary_wx_switch','secondary_zfb_switch','secondary_sd_switch'];
            $values = getConfig($nameArray);
            if ($pay_type=='wx'){
                if (!$values['secondary_wx_switch']) $this->error('微信支付暂时关闭');
            }elseif ($pay_type=='zfb'){
                if (!$values['secondary_zfb_switch']) $this->error('支付宝支付暂时关闭');
            }elseif ($pay_type=='sd'){
                if (!$values['secondary_sd_switch']) $this->error('杉德支付暂时关闭');
            }
        }
        return true;
    }





}