gaoyixia/application/api/controller/Order.php

<?php
namespace app\api\controller;
use app\common\model\BillApply;
use app\common\model\OrderComment;
use app\common\model\OrderLogisticsUrge;
use app\common\model\OrderRefundCase;
use app\common\model\ShoppingTrolley;
use app\common\model\DeliveryAddress;
use app\common\model\StoreGoods;
use app\common\model\StoreGoodsItem;
use app\common\model\GoodsOrder;
use app\common\model\GoodsOrderItem;
use app\common\model\StoreOrderRefund;
use app\common\model\User;
use app\common\model\UserMessage;
use app\common\service\ExpressService;
use app\common\service\UserSynth;
use library\tools\Data;
use think\Db;
use think\Exception;

/**
 * @title 订单
 * @controller Order
 * @group base
 */
class Order extends Base
{
    public $int_rate = 100;
    // 需要登录的
    protected $need_login = [
        'createOrderImmediately',
        'createOrderByTrolley',
        'payOrder',
        'getOrderList',
        'getOrderDetail',
        'getTrolleyFreight',
        'cancelOrder',
        'deleteOrder',
        'changeOrderDelivery',
        'confirmReceipt',
        'orderUrge',
        'getUrgeList',
        'applyBill',
        'addTrolleyFromOrder',
        'cancelApply',
        'refundExpress',
        'orderRefund',
        'createOrderByOrder',
    ];
    public function initialize()
    {
        parent::initialize();
        parent::checkLogin();
    }

    /**
     * @title 订单确认页面（立即购买）
     * @desc  订单确认页面
     * @author qc
     * @url /api/Order/confirmOrderImmediately
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @param name:goods_id type:int require:1  default:0 desc:商品id
     * @param name:spec_id type:int require:1  default:0 desc:商品多规格的规格id
     * @param name:num type:int default:1 desc:数量
     * @return name:name type:string default:-- desc:商品名称
     * @return name:cover type:string default:-- desc:商品封面图
     * @return name:desc type:string default:-- desc:商品简述（副标题）
     * @return name:freight_type type:int default:-- desc:运费类型0固定金额，1运费模板
     * @return name:freight_id type:int default:-- desc:模板id（freight_type=1）
     * @return name:postage type:float default:-- desc:运费（freight_type=0）
     * @return name:total_price type:float default:-- desc:商品金额[不含运费]
     * @return name:freight type:float default:-- desc:运费
     * @return name:freight_code type:int default:1 desc:运费提示编号【1所选地址支持发货，0所选地址不支持发货】
     * @return name:freight_msg type:string default:-- desc:运费提示信息【freight_code=1忽略】
     * @return name:goods_no type:string default:-- desc:规格货号
     * @return name:goods_spec type:string default:-- desc:规格
     * @return name:sell_price type:float default:-- desc:售价
     * @return name:add_info type:array default:-- desc:默认收货地址（设置才有）
     * @return name:add_info.pro_id type:int   default:-- desc:省id
     * @return name:add_info.city_id type:int   default:-- desc:市id
     * @return name:add_info.county_id type:int  default:-- desc:县区id
     * @return name:add_info.pro_name type:string  default:-- desc:省名
     * @return name:add_info.city_name type:string  default:-- desc:市名
     * @return name:add_info.county_name type:string  default:-- desc:县区名
     * @return name:add_info.detail type:string  default:-- desc:详细地址
     * @return name:add_info.phone type:string  default:-- desc:联系电话
     * @return name:add_info.name type:string   default:-- desc:联系人
     * @return name:freight type:float default:-- desc:运费
     * @return name:freight_code type:int default:1 desc:运费提示编号【1所选地址支持发货，0所选地址不支持发货】
     * @return name:freight_msg type:string default:-- desc:运费提示信息【freight_code=1忽略】
     */
    public function confirmOrderImmediately(){
        $goods_id = input('get.goods_id');
        $spec_id = input('get.spec_id');
        $num = input('get.num',1);
        $field = 'id,name,cover,desc,low_price,status,is_deleted,freight_type,postage,freight_id';
        $goods_info = StoreGoods::field($field)->where('id',$goods_id)->find()->toArray();
        $spec_info = StoreGoodsItem::where('id',$spec_id)->find()->toArray();
        $goods_info['total_price']= bcmul($spec_info['sell_price'],$num,2);
        $goods_info['goods_spec']= $spec_info['goods_spec'];
        $goods_info['goods_no']= $spec_info['goods_no'];
        $goods_info['sell_price']= $spec_info['sell_price'];
        $add_info = DeliveryAddress::where(['user_id'=>$this->user_id,'is_mr'=>1])->find();
        $freight = 0;
        if($add_info){
            $goods_freight = ExpressService::getGoodsExpressPrice($goods_info,$add_info->id,$num);
            if($goods_freight['code'] !=200){
                $this->is_commit =  false;
                $this->ret_msg =  $goods_freight['msg'];
            }
           if($goods_freight['code'] == 200) $freight = $goods_freight['freight'];
        }
        $this->success('ok',['goods_info'=>$goods_info,
            'add_info' =>$add_info ? $add_info->toArray():null,
            'freight' =>$freight,
            'freight_msg' => $this->ret_msg,
            'freight_code' => $this->is_commit ? 1 :0
        ]);
    }

    /**
     * @title 生成订单（立即购买）
     * @desc  立即购买场景
     * @author  qc
     * @url /api/Order/createOrderImmediately
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:goods_id type:int require:1  default:0 desc:商品id
     * @param name:spec_id type:int require:1  default:0 desc:商品多规格的规格id
     * @param name:num type:int default:1 desc:数量
     * @param name:add_id type:int default:1 desc:收货地址id
     * @param name:remark type:string default:1 desc:订单备注
     *
     * @param name:bill_info type:string default:-- desc:发票信息--json【不开票可以不传】
     * @param name:bill_info.type type:int default:-- desc:类型id
     * @param name:bill_info.header type:string default:-- desc:抬头名称[公司名称||个人名称]
     * @param name:bill_info.identify_number type:string default:-- desc:纳税人识别号
     * @param name:bill_info.email type:string default:-- desc:邮箱
     * @param name:bill_info.remark type:string default:-- desc:备注
     *
     * @return name:order_id type:int default:1 desc:订单id
     */
    public function createOrderImmediately()
    {
        $goods_id = input('post.goods_id');
        $spec_id = input('post.spec_id');
        $num = input('post.num');
        $add_id = input('post.add_id');
        $remark = input('post.remark');
        $post_bill = input('post.bill_info');
        $bill_info = json_decode(stripslashes($post_bill),true);
        if(!$goods_id || !$spec_id)  $this->error('请选择商品');
        if($num <=0 ) $this->error('数量有误');
        if(!$add_id ) $this->error('请选择收货地址');
        Db::startTrans();
        try {
            $add_info = DeliveryAddress::find($add_id)->toArray();
            $order_insert = [
                'user_id' => $this->user_id,
                'order_no' => get_order_sn(),
                'goods_num' => $num,
                'pro_name' => $add_info['pro_name'],
                'city_name' => $add_info['city_name'],
                'county_name' => $add_info['county_name'],
                'user_name' => $add_info['name'],
                'add_detail' => $add_info['detail'],
                'phone' => $add_info['phone'],
                'remark' => $remark,
                'address_id' => $add_id,
                'int_cash' => 0.00,
                'coupon_cash' => 0.00,
                'blance' => 0.00
            ];
            $goods_info = StoreGoods::with(['itemList'=>function($query)use($spec_id){
                return $query->where('id',$spec_id)->where('is_deleted',0);
            }])->where('id',$goods_id)->where('is_deleted',0)->where('status',1)->find();
            if(!$goods_info) throw new Exception('商品已下架');
            $goods_info = $goods_info->toArray();
            if(empty($goods_info['item_list'])) throw new Exception('该规格已下架');
            if($goods_info['item_list'][0]['stock'] < $num) throw new Exception('库存不足');
            $order_insert['original_price'] = bcmul($num,$goods_info['item_list'][0]['original_price'],2);// 原价
            $true_cost = $goods_info['item_list'][0]['sell_price'];//实际售价
            $spec_info = $goods_info['item_list'][0];
            $price_goods   =  bcmul($num,$true_cost,2); // 需要支付商品价格
            // 获取运费信息
            $exp_data = ExpressService::getGoodsExpressPrice($goods_info,$add_info,$num);
            if($exp_data['code'] != 200 ) throw  new Exception($exp_data['msg']);
            $price_express =  $exp_data['freight']; //  商品运费
            //订单金额 =  商品金额 + 运费
            $order_money = bcadd($price_goods,$price_express ,2);
            if($order_money < 0) $this->exception('订单金额有误');
            $order_insert['price_total'] = $order_money;
            $order_insert['price_goods'] = $price_goods;
            $order_insert['price_express'] = $price_express;
            $order_info = GoodsOrder::create($order_insert);
            $order_item = [
                'user_id' => $this->user_id,
                'order_id' => $order_info->id,
                'goods_id' => $goods_id,
                'goods_no' => $spec_info['goods_no'],
                'goods_spec' => $spec_info['goods_spec'],
                'goods_name' => $goods_info['name'],
                'spec_title' => $spec_info['spec_title'],
                'spec_id' => $spec_info['id'],
                'cover' => $spec_info['spec_cover'],
                'original_price' => $spec_info['original_price'],
                'sell_price' => $true_cost,
                'pay_price' => $order_money,
                'num' => $num,
            ];
            GoodsOrderItem::create($order_item);
            StoreGoods::where('id',$goods_id)->setDec('stock',$num);
            StoreGoodsItem::where('id',$spec_id)->setDec('stock',$num);
            // 申请开票
            if($order_money > 0 && !empty($bill_info)){
                $ret_val  = UserSynth::buildBillApply($this->user_id, $order_info->id,2,$bill_info,0,1,$bill_info['remark'],0);
                if($ret_val['code'] != 200) $this->exception($ret_val['msg']);
            }
            Db::commit();
        }catch (\Exception $e){
            $this->is_commit = false;
            $this->ret_msg = $e->getMessage();
            Db::rollback();
        }
        $this->is_commit ? $this->success('添加成功',['order_id'=>$order_info->id]):$this->error($this->ret_msg);
    }

    /**
     * @title 生成订单（购物车）
     * @desc  购物车场景
     * @author  qc
     * @url /api/Order/createOrderByTrolley
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:ids type:int require:1  default:0 desc:购物车记录id
     * @param name:add_id type:int default:1 desc:收货地址id
     * @param name:remark type:string default:1 desc:订单备注
     *
     * @param name:bill_info type:string default:-- desc:发票信息--json【不开票可以不传】
     * @param name:bill_info.type type:int default:-- desc:类型id
     * @param name:bill_info.header type:string default:-- desc:抬头名称[公司名称||个人名称]
     * @param name:bill_info.identify_number type:string default:-- desc:纳税人识别号
     * @param name:bill_info.email type:string default:-- desc:邮箱
     * @param name:bill_info.remark type:string default:-- desc:备注
     *
     * @return name:order_id type:int default:1 desc:订单id
     */
    public function createOrderByTrolley()
    {
        $ids  = input('post.ids');
        $add_id = input('post.add_id');
        $remark = input('post.remark');
        $post_bill = input('post.bill_info');
        $bill_info = json_decode(stripslashes($post_bill),true);
        if(!$ids) $this->error('请选择商品');
        if(!$add_id ) $this->error('请选择收货地址');
        $ret_data = ['order_id'=>0];
        Db::startTrans();
        try{
            $add_info = DeliveryAddress::where('id',$add_id)->find()->toArray();
            $trolley_list = ShoppingTrolley::with(['goodsSpec','goodsInfo'])->where('id','in',$ids)->select()->toArray();
            if(empty($trolley_list)) $this->exception('购物车记录有误');
            // 计算运费
            $price_express = 0;// 总运费
            $goods_list = ShoppingTrolley::where('id','in',$ids)->field('goods_id,sum(num) as total_num')->group('goods_id')->select()->toArray();
            foreach ($goods_list as $v){
                $goods_info = StoreGoods::field('name,freight_type,freight_id,postage')->where('id',$v['goods_id'])->find()->toArray();
                $freight_data = ExpressService::getGoodsExpressPrice($goods_info,$add_info,$v['total_num']);
                if($freight_data['code'] != 200){
                    $this->exception($goods_info['name'].$freight_data['msg']);
                    break;
                }
                $price_express += $freight_data['freight'];
            }
            // 计算运费 end
            $price_goods =  0; // 商品总金额
            $original_total = 0; // 商品总原价
            $total_num = 0;// 商品总数量
            $order_item = [];// 订单列表
            foreach ($trolley_list as $trolley)
            {
                //验证库存
                if( $trolley['goods_spec']['stock'] < $trolley['num']) $this->exception('商品库存不足');
                // 扣除库存
                StoreGoodsItem::stockChange($trolley['spec_id'],$trolley['goods_id'],$trolley['num'],-1);
                $price_goods += $trolley['num'] * $trolley['goods_spec']['sell_price'];
                $original_total += $trolley['num'] * $trolley['goods_spec']['original_price'];
                $total_num +=$trolley['num'];
                $order_item[] = [
                    'user_id' => $this->user_id,
                    'goods_id' => $trolley['goods_id'],
                    'goods_no' => $trolley['goods_spec']['goods_no'],
                    'goods_name' => $trolley['goods_info']['name'],
                    'goods_spec' => $trolley['goods_spec']['goods_spec'],
                    'spec_title' => $trolley['goods_spec']['spec_title'],
                    'spec_id' => $trolley['spec_id'],
                    'cover' =>  $trolley['goods_spec']['spec_cover'],
                    'original_price' => $trolley['goods_spec']['original_price'],
                    'sell_price' => $trolley['goods_spec']['sell_price'],
                    'num' => $trolley['num'],
                    'trolley_id' => $trolley['id'],
                ];
            }
            $order_insert = [
                'user_id' => $this->user_id,
                'order_no' => get_order_sn(),
                'goods_num' => $total_num,
                'pro_name' => $add_info['pro_name'],
                'city_name' => $add_info['city_name'],
                'county_name' => $add_info['county_name'],
                'user_name' => $add_info['name'],
                'add_detail' => $add_info['detail'],
                'phone' => $add_info['phone'],
                'remark' => $remark,
                'address_id' => $add_id,
                'int_cash' => 0.00,
                'coupon_cash' => 0.00,
                'blance' => 0.00
            ];
            $price_total = bcadd($price_goods ,$price_express,2);
            $order_insert['price_total'] = $price_total;
            $order_insert['price_goods'] = $price_goods ;
            $order_insert['original_total'] = $original_total ;
            $order_insert['price_express'] = $price_express ;
            $order_info = GoodsOrder::create($order_insert);// 生成订单
            array_walk($order_item,function (&$v,$k)use ($order_info){
                $v['order_id'] = $order_info->id;
            });
            (new GoodsOrderItem())->insertAll($order_item);// 生成订单商品详情
            ShoppingTrolley::where('id','in',$ids)->delete();// 删除购物车
            $ret_data['order_id'] =  $order_info->id;
            // 申请开票
            if($price_total > 0 && !empty($bill_info)){
                $ret_val  = UserSynth::buildBillApply($this->user_id, $order_info->id,2,$bill_info,0,1,$bill_info['remark'],0);
                if($ret_val['code'] != 200) $this->exception($ret_val['msg']);
            }
            Db::commit();
        }catch (\Exception $e){
            $this->ret_msg = $e->getMessage();
            $this->is_commit = false;
            Db::rollback();
        }
        $this->transReturn($ret_data);
    }

    /**
     * @title 订单支付
     * @desc  订单支付
     * @author  qc
     * @url /api/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移动支付（微信），4移动支付（支付宝）,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:随机字符串（小程序支付&&APP支付）
     * @return name:config.timestamp type:string default:-- desc:时间戳小程序支付&&APP支付）
     * @return name:config.partnerid type:string default:-- desc:商户号（App支付）
     * @return name:config.prepayid type:string default:-- desc:唯一支付号（App支付）
     * @return name:config.package type:string default:-- desc:package（App支付）
     * @return name:config.sign type:string default:-- desc:签名（App支付）
     * @return name:code_url type:string default:-- desc:付款码url
     */
    public function payOrder()
    {
        $order_id = input('post.order_id');
        $pay_type = input('post.pay_type');
        $order_info = GoodsOrder::with('orderItem')->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('订单金额错误');
        $pay_no  = $order_info['pay_no'] ? $order_info['pay_no'] : get_order_sn();// 支付单号
        if(!$order_info['pay_no']) GoodsOrder::where('id',$order_id)->update(['pay_no'=>$pay_no]);
        $user_info = User::with('wallet')->where('id',$this->user_id)->find()->toArray();
        if(in_array($order_info['pay_type'],[1,3,5]) && in_array($pay_type,[1,3,5]) && $pay_type != $order_info['pay_type'] )$this->error('微信支付冲突，请选择支付宝支付');
        $ret_data = ['pay_status'=>0,'config'=>[],'code_url'=>''];
        Db::startTrans();
        GoodsOrder::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/goodsOrderNotify';
                    $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/goodsOrderNotify';
                    $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/goodsOrderNotify';
                    $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/goodsOrderNotify';
                    $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/goodsOrderNotify';
                    $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;
                case 6:
                    $notify_url = $this->request->root(true) . '/api/we_chat_pay/goodsOrderNotify';
                    $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/goodsOrderNotify';
                    $return_url ='https://'.$_SERVER['HTTP_HOST']."/pc";
                    $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/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:每页数
     * @param  name:search_key type:string default:20 desc:关键字搜索[订单号]
     * @param  name:status type:int default:-1  desc:订单状态（0待支付,1已支付（待发货）,2已发货（待收货）,3已收货（已完成）,8已退款,9取消）
     * @param  name:pay_state type:int default:-1  desc:支付状态（-1全部，0未支付，1已支付）
     * @param  name:cancel_state type:int default:-1  desc:取消状态（-1全部，0未取消，1已取消）
     * @param  name:apply_refund type:int default:-1  desc:申请退款状态（-1全部，0未申请||已取消，1已申请）
     * @return name:id type:int default:--  desc:订单id
     * @return name:id type:int default:--  desc:订单id
     * @return name:auto_time type:int default:--  desc:自动取消时间单位秒
     * @return name:expire_time type:string default:--  desc:支付到期时间
     * @return name:order_no type:string default:--  desc:订单号
     * @return name:price_total type:float default:--  desc:待支付金额（商品价格+运费）
     * @return name:price_goods type:float default:--  desc:商品金额
     * @return name:price_express 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移动支付（微信），4移动支付（支付宝）,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:refund_state type:int default:--  desc:退款状态(0未申请1待审核,2审核拒绝,3审核通过)
     * @return name:express_state type:int default:--  desc:发货状态(0未发货,1已发货,2已签收)
     * @return name:express_company_title type:string default:--  desc:发货快递公司名称
     * @return name:express_send_no type:string default:--  desc:物流单号
     * @return name:express_send_at type:string default:--  desc:发货时间
     * @return name:status type:int default:--  desc:订单状态（0待支付,1已支付（待发货）,2已发货（待收货）,3已收货（已完成）,8已退款,9取消）
     * @return name:create_at type:string default:--  desc:下单时间
     * @return name:remark type:string default:--  desc:订单备注
     * @return name:goods_num type:int default:--  desc:订单商品总数量
     * @return name:pro_name type:string default:--  desc:省名称（收货地址）
     * @return name:city_name type:string default:--  desc:市名称（收货地址）
     * @return name:county_name type:string default:--  desc:县区名称（收货地址）
     * @return name:add_detail type:string default:--  desc:详细地址（收货地址）
     * @return name:user_name type:string default:--  desc:收货人
     * @return name:phone type:string default:--  desc:收货人联系电话
     * @return name:take_time  type:string default:--  desc:收货时间
     * @return name:order_item type:array default:--  desc:订单商品列表
     * @return name:order_item.name type:float default:--  desc:商品名
     * @return name:order_item.spec_cover type:float default:--  desc:商品图
     * @return name:order_item.sell_price type:float default:--  desc:购买价格
     * @return name:order_item.goods_spec type:float default:--  desc:规格
     * @return name:order_item.num type:int default:--  desc:数量
     *
     * @return name:bill_info type:array default:-- desc:发票申请信息
     * @return name:bill_info.header type:string default:0 desc:抬头
     * @return name:bill_info.type type:int default:0 desc:发票类型
     * @return name:bill_info.email type:string default:0 desc:邮箱
     * @return name:bill_info.phone type:string default:0 desc:电话
     * @return name:bill_info.bank type:string default:0 desc:开户行
     * @return name:bill_info.card_no type:string default:0 desc:银行账号
     * @return name:bill_info.identify_number type:string default:0 desc:纳税人识别号
     * @return name:bill_info.bill_img type:string default:0 desc:点子发票url
     * @return name:bill_info.remark type:string default:0 desc:备注
     *
     * @return name:order_refund type:array default:-- desc:申请售后信息[为空未申请]
     * @return name:order_refund.status type:int default:-- desc:0待审核1审核同意2审核拒绝3通过且退款4退款异常5取消申请
     * @return name:order_refund.audit_desc type:string default:-- desc:审核描述
     * @return name:order_refund.refund_type type:int default:-- desc:1退款2退货退款
     * @return name:order_refund.refund_money type:int default:-- desc:退款金额
     * @return name:order_refund.apply_case type:string default:-- desc:申请原因
     * @return name:order_refund.apply_remark type:string default:-- desc:描述
     * @return name:order_refund.express_no type:string default:-- desc:退货单号
     * @return name:order_refund.express_company type:string default:-- desc:快递公司
     * @return name:order_refund.consignee_add type:string default:-- desc:收货地址
     * @return name:order_refund.consignee_name type:string default:-- desc:收货人
     * @return name:order_refund.consignee_tel type:string default:-- desc:收货人电话
     */
    public function getOrderList()
    {
        $status = input('get.status',-1);
        $pay_state = input('get.pay_state',-1);
        $cancel_state = input('get.cancel_state',-1);
        $refund_state = input('get.apply_refund',-1);
        $search_key = input('get.search_key');
        $where = [];
        $where[] = ['user_id','=',$this->user_id];
        $where[] = ['is_deleted','=',0];
        if($status > -1) $where[] = ['status','=',$status];
        if($pay_state > -1) $where[] = ['pay_state','=',$pay_state];
        if($cancel_state > -1) $where[] = ['cancel_state','=',$cancel_state];
        if($refund_state == 0) $where[] = ['refund_state','=',$refund_state];
        if($refund_state == 1) $where[] = ['refund_state','in','1,2,3,4'];
        if($search_key) $where[] = ['order_no','like','%'.$search_key.'%'];
        $field = 'id,order_no,price_total,take_time,price_goods,price_express,create_at,pay_at,status,pay_type,goods_num,remark,pro_name,city_name,county_name,add_detail,pay_state,user_name,phone,remark,cancel_state,cancel_at,refund_state,express_state,express_company_title,express_send_no,express_send_at';
        $list = GoodsOrder::with(['orderItem','orderRefund'])->field($field)->where($where)->order('id desc ')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$info) {
            $auto_time = 86400 - (time() - strtotime($info['create_at'])) ;
            $info['auto_time'] = $auto_time  > 0  && $info['status'] == 0 ? $auto_time :0;
            $info['expire_time'] = date('Y-m-d H:i:s',strtotime($info['create_at'])+ 86400);
            $bill_info = BillApply::field('id,header,type,phone,email,bank,card_no,identify_number,bill_img,remark')->where(['order_type'=>2,'order_id'=>$info['id']])->find();
            $info['bill_info'] = !empty($bill_info) ? $bill_info->toArray() : null;
            foreach ($info['order_item'] as &$v) {
                $v['goods_spec'] = str_replace(['::',';;'],[':',';'],$v['goods_spec']);
            }
           if(isset($info['order_refund']) )$info['order_refund']['case_title'] = OrderRefundCase::getCaseTitle($info['order_refund']['apply_case']);
        }
        $total_num =  GoodsOrder::where($where)->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }

    /**
     * @title 获取订单详情
     * @desc 获取订单详情
     * @author qc
     * @method GET
     * @url /api/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:price_goods type:float default:--  desc:商品金额
     * @return name:price_express 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移动支付（微信），4移动支付（支付宝）,5.h5微信内支付）
     * @return name:pay_no type:string default:--  desc:支付号
     * @return name:pay_at type:string default:--  desc:支付时间
     * @return name:cancel_at type:string default:--  desc:取消时间
     * @return name:refund_state type:int default:--  desc:退款状态(0未申请1待审核,2审核拒绝,3审核通过)
     * @return name:express_state type:int default:--  desc:发货状态(0未发货,1已发货,2已签收)
     * @return name:express_company_title type:string default:--  desc:发货快递公司名称
     * @return name:express_send_no type:string default:--  desc:物流单号
     * @return name:express_send_at type:string default:--  desc:发货时间
     * @return name:status type:int default:--  desc:订单状态（0待支付,1已支付（待发货）,2已发货（待收货）,3已收货（已完成）,8已退款,9取消）
     * @return name:create_at type:string default:--  desc:下单时间
     * @return name:remark type:string default:--  desc:订单备注
     * @return name:auto_time type:int default:--  desc:自动取消时间单位秒
     * @return name:goods_num type:int default:--  desc:订单商品总数量
     * @return name:pro_name type:string default:--  desc:省名称（收货地址）
     * @return name:city_name type:string default:--  desc:市名称（收货地址）
     * @return name:county_name type:string default:--  desc:县区名称（收货地址）
     * @return name:add_detail type:string default:--  desc:详细地址（收货地址）
     * @return name:user_name type:string default:--  desc:收货人
     * @return name:take_time  type:string default:--  desc:收货时间
     * @return name:phone type:string default:--  desc:收货人联系电话
     * @return name:order_item type:array default:--  desc:订单商品列表(按商品id分组)
     * @return name:order_item.name type:float default:--  desc:商品名
     * @return name:order_item.spec_cover type:float default:--  desc:商品图
     * @return name:order_item.sell_price type:float default:--  desc:购买价格
     * @return name:order_item.goods_spec type:float default:--  desc:规格
     * @return name:order_item.num type:int default:--  desc:数量
     *
     * @return name:bill_info type:array default:-- desc:发票申请信息
     * @return name:bill_info.header type:string default:0 desc:抬头
     * @return name:bill_info.type type:int default:0 desc:发票类型
     * @return name:bill_info.email type:string default:0 desc:邮箱
     * @return name:bill_info.phone type:string default:0 desc:电话
     * @return name:bill_info.bank type:string default:0 desc:开户行
     * @return name:bill_info.card_no type:string default:0 desc:银行账号
     * @return name:bill_info.identify_number type:string default:0 desc:纳税人识别号
     * @return name:bill_info.bill_img type:string default:0 desc:点子发票url
     * @return name:bill_info.remark type:string default:0 desc:备注
     *
     * @return name:order_refund type:array default:-- desc:申请售后信息[为空未申请]
     * @return name:order_refund.status type:int default:-- desc:0待审核1审核同意2审核拒绝3通过且退款4退款异常5取消申请
     * @return name:order_refund.audit_desc type:string default:-- desc:审核描述
     * @return name:order_refund.refund_type type:int default:-- desc:1退款2退货退款
     * @return name:order_refund.refund_money type:int default:-- desc:退款金额
     * @return name:order_refund.apply_case type:string default:-- desc:申请原因
     * @return name:order_refund.refund_time type:string default:-- desc:退款时间
     * @return name:order_refund.apply_remark type:string default:-- desc:申请描述
     * @return name:order_refund.refund_no type:string default:-- desc:退款编号
     * @return name:order_refund.express_no type:string default:-- desc:退货单号
     * @return name:order_refund.express_company type:string default:-- desc:快递公司
     * @return name:order_refund.consignee_add type:string default:-- desc:收货地址
     * @return name:order_refund.consignee_name type:string default:-- desc:收货人
     * @return name:order_refund.consignee_tel type:string default:-- desc:收货人电话
     *
     */
    public function getOrderDetail()
    {
        $order_id = input('get.order_id');
        $field = 'id,order_no,price_total,price_goods,status,price_express,take_time ,create_at,pay_at,pay_type,goods_num,remark,pro_name,city_name,county_name,add_detail,pay_state,user_name,phone,remark,cancel_state,cancel_at,refund_state,express_state,express_company_title,express_send_no,express_send_at';
        $detail = GoodsOrder::with('orderRefund')->where('id',$order_id)->field($field)->find()->toArray();
       // if(isset($detail['order_refund']['express_info']) && $detail['order_refund']['express_info'])$info['order_refund']['express_info'] = json_decode($detail['order_refund']['express_info'],true);
        if(isset($detail['order_refund']) )$detail['order_refund']['case_title'] = OrderRefundCase::getCaseTitle($detail['order_refund']['apply_case']);

        $auto_time = 86400 - (time() - strtotime($detail['create_at'])) ;
        $detail['auto_time'] = $auto_time  > 0  && $detail['status'] == 0 ? $auto_time :0;
        $detail['order_item']  = (new GoodsOrderItem())->getOrderItem($order_id);
        foreach ($detail['order_item'] as &$v) {
            $v['goods_spec'] = str_replace(['::',';;'],[':',';'],$v['goods_spec']);
        }
        $bill_info = BillApply::field('id,header,type,phone,email,bank,card_no,identify_number,bill_img,remark')->where(['order_type'=>2,'order_id'=>$detail['id']])->find();
        $detail['bill_info'] = !empty($bill_info) ? $bill_info->toArray() : null;
        $this->success('ok',['detail'=>$detail]);
    }

    /**
     * @title 计算商品运费（一个商品）
     * @desc  计算商品运费（一个商品）
     * @author qc
     * @url /api/Order/getGoodsFreight
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @param  name:goods_id type:int require:1  default:0 desc:商品id
     * @param  name:num type:int require:1  default:0 desc:商品数量
     * @param  name:add_id type:int require:1  default:0 desc:收货地址id
     * @return name:freight type:float require:0 default:0 desc运费金额
     */
    public function getGoodsFreight()
    {
        $goods_id = input('get.goods_id');
        $num = input('get.num');
        $add_id = input('get.add_id');
        $goods_info = StoreGoods::where('id',$goods_id)->find()->toArray();
        $add_info = DeliveryAddress::where('id',$add_id)->find()->toArray();
        $freight_data = ExpressService::getGoodsExpressPrice($goods_info,$add_info,$num);
        if($freight_data['code'] != 200 ) $this->error($freight_data['msg']);
        $this->success('ok',['freight'=>$freight_data['freight']]);
    }

    /**
     * @title 计算购物车商品运费
     * @desc  计算购物车商品运费
     * @author qc
     * @url /api/Order/getTrolleyFreight
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @param  name:ids type:int require:1  default:0 desc:购物车商品id串（逗号隔开）
     * @param  name:add_id type:int require:1  default:0 desc:收货地址id
     * @return name:freight type:float require:0 default:0 desc运费金额
     */
    public function getTrolleyFreight()
    {
        $trolley_ids = input('get.ids');
        $add_id = input('get.add_id');
        $goods_list = ShoppingTrolley::where('id','in',$trolley_ids)
            ->field('goods_id,sum(num) as total_num')
            ->group('goods_id')
            ->select()->toArray();
        $total_price = 0;
        $add_info = DeliveryAddress::where('id',$add_id)->find()->toArray();
        foreach ($goods_list as $v){
            $goods_info = StoreGoods::field('name,freight_type,freight_id,postage')->where('id',$v['goods_id'])->find()->toArray();
            $freight_data = ExpressService::getGoodsExpressPrice($goods_info,$add_info,$v['total_num']);
            if($freight_data['code'] != 200){
                $this->error($goods_info['name'].$freight_data['msg']);
                break;
            }
            $total_price += $freight_data['freight'];
        }
        $this->success('ok',['freight'=>$total_price]);
    }

    /**
     * @title 取消订单
     * @desc  取消订单
     * @author  qc
     * @url /api/Order/cancelOrder
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param  name:order_id type:int require:1  default:0 desc:订单id
     */
    public function cancelOrder()
    {
        $order_id = input('post.order_id');
        Db::startTrans();
        try {
            $detail = GoodsOrder::with('orderItem')->where('id',$order_id)->find()->toArray();
            if($detail['status'] != 0) $this->exception('订单状态有误');
            // 取消订单状态
            GoodsOrder::update(['status'=>9,'cancel_state'=>1],['id'=>$order_id]);
            // 订单处理
            foreach ($detail['order_item'] as $item_info) {
                //  更改订单详情状态
                GoodsOrderItem::update(['status'=>9],['id'=>$item_info['id']]);
                StoreGoodsItem::stockChange($item_info['spec_id'],$item_info['goods_id'],$item_info['num']);
            }
            Db::commit();
        }catch (\Exception $e){
            $this->ret_msg = $e->getMessage();
            $this->is_commit = false;
            Db::rollback();
        }
        $this->is_commit ? $this->success('取消成功') : $this->error($this->ret_msg);
    }

    /**
     * @title 删除订单
     * @desc  删除订单
     * @author  qc
     * @url /api/Order/deleteOrder
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param  name:order_id type:int require:1  default:0 desc:订单id
     */
    public function deleteOrder()
    {
        $order_id = input('post.order_id');
        $detail = GoodsOrder::with('orderItem')->where('id',$order_id)->find()->toArray();
        if($detail['status'] == 0) $this->error('请先取消订单');
        GoodsOrder::update(['is_deleted'=>1],['id'=>$order_id]);
        $this->success('删除成功');
    }


    /**
     * @title 更换订单收货地址
     * @desc  更换订单收货地址（仅待支付订单可以修改地址）
     * @author  qc
     * @url /api/Order/changeOrderDelivery
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param  name:order_id type:int require:1  default:0 desc:订单id
     * @param  name:add_id type:int require:1  default:0 desc:收货地址id
     */
    public function changeOrderDelivery()
    {
        $order_id = input('post.order_id');
        $add_id = input('post.add_id');
        $detail = GoodsOrder::where('id',$order_id)->find()->toArray();
        if($detail['status'] != 0) $this->error('操作错误');
        $add_info = DeliveryAddress::where('id',$add_id)->find()->toArray();
        $order_update =[
            'pro_name' => $add_info['pro_name'],
            'city_name' => $add_info['city_name'],
            'county_name' => $add_info['county_name'],
            'add_detail' => $add_info['detail'],
            'user_name' => $add_info['name'],
            'phone' => $add_info['phone'],
        ];
        GoodsOrder::update($order_update,['id'=>$order_id]);
        $this->success('修改成功');

    }

    /**
     * @title 确认收货
     * @desc  确认收货
     * @author  qc
     * @url /api/Order/confirmReceipt
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param  name:order_id type:int require:1  default:0 desc:订单id
     */
    public function confirmReceipt()
    {
        $order_id = input('post.order_id');
        $detail = GoodsOrder::with('orderItem')->where('id',$order_id)->find()->toArray();
        if($detail['status'] == 0) $this->error('订单未支付');
        if($detail['status'] == 1) $this->error('订单未发货');
        if($detail['status'] == 3) $this->error('订单已收货');
        GoodsOrder::update(['status'=>3,'express_state'=>2],['id'=>$order_id]);
        GoodsOrderItem::update(['status'=>3,'express_state'=>2],['order_id'=>$order_id]);
        UserMessage::create(['user_id'=>$this->user_id,'type_id'=>3,'relation_id'=>$order_id,'content'=>'订单收货成功']);
        $this->success('已确认收货');
    }



    /**
     * @title 获取物流详情
     * @desc 获取物流详情
     * @author qc
     * @url /api/Order/deliveryDetails
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @param name:order_id type:string require:1 default:-- desc:订单id
     * @return name:number type:string default:-- desc:单号
     * @return name:type type:string default:-- desc:快递类型
     * @return name:list type:array default:-- desc:数据列表
     * @return name:list.time type:string default:-- desc:时间
     * @return name:list.status type:string default:-- desc:内容
     * @return name:deliverystatus type:int default:-- desc:0：快递收件(揽件)1.在途中2.正在派件3.已签收4.派送失败5.疑难件6.退件签收
     * @return name:issign type:int default:-- desc:是否签收（1.是否签收）
     * @return name:expName type:string default:-- desc:快递公司名称
     * @return name:expSite type:string default:-- desc:快递公司官网
     * @return name:expPhone type:string default:-- desc:快递公司电话
     * @return name:courier type:string default:-- desc:快递员 或 快递站(没有则为空)
     * @return name:courierPhone type:string default:-- desc:快递员电话 (没有则为空)
     * @return name:updateTime type:string default:-- desc:快递轨迹信息最新时间
     * @return name:takeTime type:string default:-- desc:发货到收货消耗时长 (截止最新轨迹)
     * @return name:logo type:string default:-- desc:快递公司LOGO
     */
    public function deliveryDetails(){
        $send_no = GoodsOrder::where('id',input('get.order_id'))->value('express_send_no');
        if(!$send_no) $this->error('订单没有发货');
        $data = get_delivery($send_no);
        if($data['issign'] == 1){
            $express_send_date = end($data['list']);
            $express_send_date = $express_send_date['time'];
            if($express_send_date < date('Y-m-d H:i:s',strtotime('-2 days'))){
                try {
                    $detail = GoodsOrder::where('id',input('get.order_id'))->find()->toArray();
                    $order_id = $detail['id'];
//            $detail = GoodsOrder::where('id',$order_id)->find()->toArray();
                    if($detail['status'] == 0) $this->error('订单未支付');
                    if($detail['status'] == 1) $this->error('订单未发货');
                    if($detail['status'] == 3) $this->error('订单已收货');
                    GoodsOrder::update(['status'=>3,'express_state'=>2],['id'=>$order_id]);
                    GoodsOrderItem::update(['status'=>3,'express_state'=>2],['order_id'=>$order_id]);
                    UserMessage::create(['user_id'=>$detail['user_id'],'type_id'=>3,'relation_id'=>$order_id,'content'=>'订单收货成功']);
                    Db::commit();
                }catch (\Exception $e) {
                    Db::rollback();
                }
            }
        }
        $this->success('ok',$data);
    }


    /**
     * @title 发货提醒
     * @desc 发货提醒
     * @author qc
     * @url /api/Order/orderUrge
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:order_id type:string require:1 default:-- desc:订单id
     */
    public function orderUrge()
    {
        $order_id = input('post.order_id');
        $order_info = GoodsOrder::where('id',$order_id)->find();
        if(!$order_info ) $this->error('订单错误');
        if($order_info->pay_state != 1 ) $this->error('订单未支付');
        if($order_info->express_send_no != '' ) $this->error('订单已发货');
        $urge_ret = ExpressService::orderUrge($order_id,$this->user_id);
        $urge_ret['code'] == 200 ? $this->success($urge_ret['msg']) : $this->error($urge_ret['msg']);

    }

    /**
     * @title 获取订单催发记录
     * @desc 获取订单催发记录
     * @author qc
     * @url /api/Order/getUrgeList
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @param name:order_id type:string require:1 default:-- desc:订单id
     */
    public function getUrgeList()
    {
        $order_id = input('get.order_id');
        $list = OrderLogisticsUrge::where(['order_id'=>$order_id,'table_name'=>'dd_store_order'])->order('id desc')->select()->toArray();
        $this->success('ok',['list'=>$list]);
    }


    /**
     *
     * @title 申请开票
     * @desc 申请开票
     * @author qc
     * @method POST
     * @url /api/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');
        $post = input('post.');
        $order_info = GoodsOrder::where('id',$order_id)->find()->toArray();
        if(!$order_info['pay_state'])$this->error('订单未支付');
        if(BillApply::checkBillApply($order_id,2)) $this->error('已申请开票');
        $ret_val = UserSynth::buildBillApply($this->user_id, $order_id, 2,$post,0,1,$post['remark']);
        if($ret_val['code'] != 200) $this->error($ret_val['msg']);
        $this->success('申请成功');
    }

    /**
     *
     * @title 订单商品添加购物车
     * @desc 订单商品添加购物车
     * @author qc
     * @method POST
     * @url /api/Order/addTrolleyFromOrder
     * @header name:Authorization require:1 desc:Token
     * @param name:order_id type:string default:1 desc:订单id
     */
    public function addTrolleyFromOrder(){
        $order_id = input('post.order_id');
        Db::startTrans();
        try {
            $detail = GoodsOrder::with('orderItem')->where('id',$order_id)->find()->toArray();
            foreach ($detail['order_item'] as $item_info) {
                $goods_info = StoreGoods::getGoodsSpec($item_info['goods_id'],$item_info['spec_id']);
                if(!$goods_info) $this->exception('商品已下架');
                if(empty($goods_info['item_list'])) $this->exception('商品规格已下架');
                if($goods_info['item_list'][0]['stock'] < $item_info['num'])$this->exception('库存不足');
                //某商品某规格是否已经添加购物车
                $trolley_id = ShoppingTrolley::checkTrolley($this->user_id,$item_info['goods_id'],$item_info['spec_id']);
                // 添加到购物车
                if($trolley_id) {
                    ShoppingTrolley::where('id',$trolley_id)->setInc('num',$item_info['num']);
                }else{
                    $trolley_info = [
                        'user_id' => $this->user_id,
                        'goods_id' => $item_info['goods_id'],
                        'spec_id' => $item_info['spec_id'],
                        'goods_no' => $goods_info['item_list'][0]['goods_no'],
                        'num' => $item_info['num'],
                    ];
                    ShoppingTrolley::create($trolley_info);
                }
            }
            Db::commit();
        }catch (\Exception $e){
            $this->ret_msg = $e->getMessage();
            $this->is_commit = false;
            Db::rollback();
        }
        $this->is_commit ? $this->success('添加成功') : $this->error($this->ret_msg);
    }


    /**
     * @title 获取退款理由
     * @desc  获取退款理由
     * @author  qc
     * @url /api/Order/getRefundCase
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @param  name:id type:string default:0 desc:id
     * @param  name:title type:string default:0 desc:标题
     */
    public function getRefundCase()
    {
        $list= OrderRefundCase::where('is_deleted',0)->order('sort desc ,id desc')->select();
        $this->success('ok',['list'=>$list]);
    }




    /**
     * @title 取消退款申请
     * @desc  取消退款申请
     * @author qc
     * @url /api/Order/cancelApply
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param  name:order_id type:int require:1  default:0 desc:订单id
     */
    public function cancelApply()
    {
        $order_id = input('post.order_id');
        $field = 'id,order_no,price_total,price_goods,price_express,create_at,pay_at,pay_type,goods_num,remark,pro_name,city_name,county_name,add_detail,pay_state,user_name,phone,remark,cancel_state,cancel_at,refund_state,express_state,express_company_title,express_send_no,express_send_at';
        $order_info = GoodsOrder::with('orderRefund')->where('id',$order_id)->field($field)->find()->toArray();
        //express_on express_company
        if(!$order_info['order_refund']) $this->error('该订单未申请退款');

//        if($order_info['order_refund']['status'] != 0 ) $this->error('订单已审核完成');
        if($order_info['order_refund']['status'] == 3 ){
            $this->error('订单已退款');
        }

        if($order_info['order_refund']['express_no'] != null ){
            $this->error('订单已审核完成');
        }
        Db::startTrans();
        try {
            StoreOrderRefund::where('id',$order_info['order_refund']['id'])->update(['status'=>5,'is_deleted'=>1]);
            GoodsOrder::where('id',$order_id)->update(['refund_state'=>0]);
            Db::commit();
        }catch (\Exception $e) {
            Db::rollback();
        }
        $this->success('取消成功！');
    }




    /**
     * @title 完善售后物流
     * @desc  完善退款物流
     * @author  qc
     * @url /api/Order/refundExpress
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param  name:id type:int require:1  default:0 desc:退款记录id
     * @param  name:express_company type:string default:0 desc:0 desc:物流公司名称
     * @param  name:express_no type:string default:0 desc:快递号
     */
    public function refundExpress()
    {
        $id = input('post.id');
        $express_company = input('post.express_company');
        $express_no = input('post.express_no');
        $info = StoreOrderRefund::where('id',$id)->find()->toArray();
        if(!$info['consignee_add']) $this->error('请等待后台审核');
        $exp_info = [
            'express_company'=>$express_company,
            'express_no'=>$express_no,
            'express_time'=>date("Y-m-d H:i:s"),
        ];
        StoreOrderRefund::where('id',$id)->update($exp_info);
        $this->success('物流信息完善成功');
    }


    /**
     * @title 订单申请退款(重新退款||退款编辑)
     * @desc  订单申请退款
     * @author  qc
     * @url /api/Order/orderRefund
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param  name:order_id type:int require:1  default:0 desc:订单id
     * @param  name:apply_case type:string default:0 desc:退款原因id(多个逗号隔开)
     * @param  name:refund_type type:int default:0 desc:售后类型【1退款2退款退货】
     * @param  name:apply_remark type:string default:0 desc:描述
     * @param  name:images type:string default:0 desc:图片(多张|隔开)
     */
    public function orderRefund()
    {
        $order_id = input('post.order_id');
        $images = input('post.images');
        $apply_case = input('post.apply_case');
        $refund_type = input('post.refund_type');
        $apply_remark = input('post.apply_remark');
         $order_info = GoodsOrder::with('orderRefund')->where('id',$order_id)->find()->toArray();
        if($refund_type == 1 && $order_info['express_state'] != 0) $this->error('订单已发货');
        if($refund_type == 2 && $order_info['express_state'] != 2) $this->error('订单未收货');
        if($order_info['status'] == 0) $this->error('订单未支付');
        if($order_info['refund_state'] == 1) $this->error('订单已申请，等待审核');
        if($order_info['refund_state'] == 2) $this->error('已通过审核');
        $refund_info = [
            'user_id' => $this->user_id ,
            'order_id' => $order_id ,
            'num' => $order_info['goods_num'],
            'apply_case' => $apply_case,
            'images' => $images,
            'is_deleted'=> 0,
            'order_type'=> 2,
            'status'=>0,
            'refund_money'=> $order_info['price_total'],
            'sell_price'=> $order_info['price_goods'],
            'apply_remark'=> $apply_remark,
            'refund_type'=>  $order_info['express_state'] == 0 ?  1:2,
            'create_at'=> date('Y-m-d H:i:s'),
            'refund_no'=> 'R'.$order_info['order_no'],
        ];
        Data::save('StoreOrderRefund',$refund_info,'order_id',['order_id'=>$order_id]);
        GoodsOrder::where(['id'=>$order_id])->update(['refund_state'=>1]);
        $this->success('申请成功等待审核');

    }




    /**
     * @title 获取发票详情
     * @desc 获取发票详情
     * @author qc
     * @url /api/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'=>2,'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('StoreOrder a','a.id = b.order_id')
            ->find();
        if(empty($info)) $this->error('该订单未申请发票');
        $info = $info->toArray();
        $this->success('ok',['detail'=>$info]);
    }



    /**
     * @title 订单再次购买--确认订单页面
     * @desc 订单再次购买
     * @author qc
     * @url /api/Order/getOrderItem
     * @method GET
     * @param name:order_id type:int require default:-- desc:订单id
     * @return name:id type:int require default:-- desc:订单id
     * @return name:pro_name type:string default:--  desc:省名称（收货地址）
     * @return name:city_name type:string default:--  desc:市名称（收货地址）
     * @return name:county_name type:string default:--  desc:县区名称（收货地址）
     * @return name:add_detail type:string default:--  desc:详细地址（收货地址）
     * @return name:user_name type:string default:--  desc:收货人
     * @return name:phone type:string default:--  desc:收货人联系电话
     * @return name:remark type:string require default:-- desc:备注
     * @return name:address_id type:string require default:-- desc:收货地址id
     * @return name:add_info type:array require default:-- desc:收货地址详情
     * @return name:order_item type:array default:--  desc:订单商品列表(按商品id分组)
     * @return name:order_item.name type:float default:--  desc:商品名
     * @return name:order_item.spec_cover type:float default:--  desc:商品图
     * @return name:order_item.sell_price type:float default:--  desc:价格
     * @return name:order_item.goods_spec type:float default:--  desc:规格
     * @return name:order_item.num type:int default:--  desc:数量
     * @return name:order_item.stock type:int default:--  desc:剩余库存
     * @return name:order_item.is_normal type:int default:--  desc:商品状态（0无法正常售卖1正常）
     * @return name:order_item.msg type:int default:--  desc:商品状态描述
     * @return name:bill_info type:array default:-- desc:发票申请信息
     * @return name:bill_info.header type:string default:0 desc:抬头
     * @return name:bill_info.type type:int default:0 desc:发票类型
     * @return name:bill_info.email type:string default:0 desc:邮箱
     * @return name:bill_info.phone type:string default:0 desc:电话
     * @return name:bill_info.bank type:string default:0 desc:开户行
     * @return name:bill_info.card_no type:string default:0 desc:银行账号
     * @return name:bill_info.identify_number type:string default:0 desc:纳税人识别号
     * @return name:bill_info.bill_img type:string default:0 desc:点子发票url
     * @return name:bill_info.remark type:string default:0 desc:备注

     */
    public function getOrderItem()
    {
        $order_id = input('get.order_id');
        $field = 'id,remark,address_id,pro_name,city_name,county_name,add_detail,user_name,phone';
        $detail = GoodsOrder::where('id',$order_id)->field($field)->find()->toArray();
        $detail['order_item']  = GoodsOrderItem::getGoodsInfo($order_id);
        foreach ($detail['order_item'] as &$v) {
            $v['goods_spec'] = str_replace(['::',';;'],[':',';'],$v['goods_spec']);
        }
        $bill_info = BillApply::field('id,header,type,phone,email,bank,card_no,identify_number,bill_img,remark')->where(['order_type'=>2,'order_id'=>$detail['id']])->find();
        $detail['bill_info'] = !empty($bill_info) ? $bill_info->toArray() : null;
        $add_info = DeliveryAddress::where(['user_id'=>$this->user_id,'id'=>$detail['address_id'],'is_deleted'=>0])->find();
        $detail['add_info'] = $add_info ? $add_info->toArray() : null;
        $this->success('ok',['detail'=>$detail]);
    }

    /**
     * @title 获取订单运费
     * @desc 获取订单运费
     * @author qc
     * @url /api/Order/getOrderExpress
     * @method GET
     * @param name:id type:int require default:-- desc:订单id
     * @param name:add_id type:int require default:-- desc:收货地址id
     */
    public function getOrderExpress()
    {
        $order_id = input('get.order_id');
        $add_id  = input('get.add_id');
        // 计算运费
        $add_info = DeliveryAddress::where('id',$add_id)->find()->toArray();
        $goods_list = GoodsOrderItem::where('order_id',$order_id)->field('goods_id,sum(num) as total_num')->group('goods_id')->select()->toArray();
        $total_price = 0;
        foreach ($goods_list as $v){
            $goods_info = StoreGoods::field('name,freight_type,freight_id,postage')->where('id',$v['goods_id'])->find()->toArray();
            $freight_data = ExpressService::getGoodsExpressPrice($goods_info,$add_info,$v['total_num']);
            if($freight_data['code'] != 200){
                $this->error($goods_info['name'].$freight_data['msg']);
                break;
            }
            $total_price += $freight_data['freight'];
        }
        $this->success('ok',['freight'=>$total_price]);
    }


    /**
     * @title 订单再次购买
     * @desc 订单再次购买
     * @author qc
     * @url /api/Order/createOrderByOrder
     * @method POST
     * @param name:order_id type:int require default:-- desc:订单id
     * @param name:add_id type:int require default:-- desc:收货地址id
     * @param name:remark type:string require default:-- desc:备注
     *
     * @param name:bill_info type:string default:-- desc:发票信息--json【不开票可以不传】
     * @param name:bill_info.type type:int default:-- desc:类型id
     * @param name:bill_info.header type:string default:-- desc:抬头名称[公司名称||个人名称]
     * @param name:bill_info.identify_number type:string default:-- desc:纳税人识别号
     * @param name:bill_info.email type:string default:-- desc:邮箱
     * @param name:bill_info.remark type:string default:-- desc:备注
     */
    public function createOrderByOrder()
    {
        $order_id = input('post.order_id');
        $add_id = input('post.add_id');
        $remark = input('post.remark');
        $post_bill = input('post.bill_info');
        $bill_info = json_decode(stripslashes($post_bill),true);
        $order_info = GoodsOrder::where('id',$order_id)->where('user_id',$this->user_id)->find()->toArray();
        $item_list =  GoodsOrderItem::where('order_id',$order_id)->select()->toArray();
        if(!$add_id ) $this->error('请选择收货地址');
        Db::startTrans();
        try {
            $add_info = DeliveryAddress::where('id',$add_id)->find()->toArray();
            $goods_list = GoodsOrderItem::where('order_id',$order_id)->field('goods_id,sum(num) as total_num')->group('goods_id')->select()->toArray();
            $price_express = 0;
            foreach ($goods_list as $v){
                $goods_info = StoreGoods::field('name,freight_type,freight_id,postage')->where('id',$v['goods_id'])->find()->toArray();
                $freight_data = ExpressService::getGoodsExpressPrice($goods_info,$add_info,$v['total_num']);
                if($freight_data['code'] != 200){
                    $this->exception($goods_info['name'].$freight_data['msg']);
                    break;
                }
                $price_express += $freight_data['freight'];
            }
            $order_insert = [
                'user_id' => $order_info['user_id'],
                'order_no' => get_order_sn(),
                'goods_num' => $order_info['goods_num'],
                'pro_name' => $add_info['pro_name'],
                'city_name' => $add_info['city_name'],
                'county_name' => $add_info['county_name'],
                'user_name' => $add_info['name'],
                'add_detail' => $add_info['detail'],
                'phone' => $add_info['phone'],
                'remark' => $remark,
                'address_id' => $add_id,
            ];
            $price_goods =  0; // 商品总金额
            $original_total = 0; // 商品总原价
            $total_num = 0;// 商品总数量
            $order_item = [];// 订单列表
            foreach ($item_list as $v) {
                $goods_info = StoreGoods::with(['itemList'=>function($query)use($v){
                    return $query->where('id',$v['spec_id'])->where('is_deleted',0);
                }])->where('id',$v['goods_id'])->where('is_deleted',0)->where('status',1)->find();

                if(!$goods_info) throw new Exception('商品已下架');
                $goods_info = $goods_info->toArray();
                if(empty($goods_info['item_list'])) throw new Exception('该规格已下架');
                //验证库存
                if($goods_info['item_list'][0]['stock'] < $v['num']) throw new Exception('库存不足');
                // 扣除库存
                StoreGoodsItem::stockChange($v['spec_id'],$v['goods_id'],$v['num'],-1);
                $price_goods += $v['num'] * $goods_info['item_list'][0]['sell_price'];
                $original_total += $v['num'] * $goods_info['item_list'][0]['original_price'];
                $total_num +=$v['num'];
                $order_item[] = [
                    'user_id' => $this->user_id,
                    'goods_id' => $v['goods_id'],
                    'goods_no' => $goods_info['item_list'][0]['goods_no'],
                    'goods_name' => $goods_info['name'],
                    'goods_spec' => $goods_info['item_list'][0]['goods_spec'],
                    'spec_title' =>  $goods_info['item_list'][0]['spec_title'],
                    'spec_id'   => $goods_info['item_list'][0]['id'],
                    'cover' =>  $goods_info['item_list'][0]['spec_cover'],
                    'original_price' => $goods_info['item_list'][0]['original_price'],
                    'sell_price' => $goods_info['item_list'][0]['sell_price'],
                    'num' => $v['num'],
                ];
            }
            //订单金额 =  商品金额 + 运费
            $order_money = bcadd($price_goods,$price_express ,2);
            if($order_money < 0) $this->exception('订单金额有误');
            $order_insert['price_total'] = $order_money;
            $order_insert['price_goods'] = $price_goods;
            $order_insert['price_express'] = $price_express;
            $order_insert['original_total'] = $original_total ;
            $order_insert['source'] = 3 ;
            $order_info = GoodsOrder::create($order_insert);// 生成订单
            array_walk($order_item,function (&$v,$k)use ($order_info){
                $v['order_id'] = $order_info->id;
            });
            (new GoodsOrderItem())->insertAll($order_item);// 生成订单商品详情
            // 申请开票
            if($order_money > 0 && !empty($bill_info)){
                $ret_val  = UserSynth::buildBillApply($this->user_id, $order_info->id,2,$bill_info,0,1,$bill_info['remark'],0);
                if($ret_val['code'] != 200) $this->exception($ret_val['msg']);
            }
            Db::commit();
        }catch (\Exception $e) {
            $this->is_commit = false;
            $this->ret_msg = $e->getMessage();
            Db::rollback();
        }
        $this->is_commit ? $this->success('添加成功',['order_id'=>$order_info->id]):$this->error($this->ret_msg);
    }




}