order

<?php

namespace app\api\controller;

use addons\shopro\model\OrderAction;
use addons\shopro\model\User;
use app\admin\model\Market;
use app\common\controller\Api;
use app\common\model\GoodsComment;
use app\common\model\GoodsLabel;
use app\common\model\ServingCell;
use app\common\model\ShopCategory;
use app\common\model\ShopConfigs;
use app\common\model\ShopCoupons;
use app\common\model\ShopMarket;
use app\common\model\ShopOrder;
use app\common\model\ShopOrderItem;
use app\common\model\ShopServingCell;
use app\common\model\ShopCart;
use app\common\model\Goods;
use app\common\model\ShopUserCoupons;
use app\common\model\ShopUserCouponsLog;
use app\common\model\ShopUserCouponsNum;
use app\common\model\UserServingCell;
use app\common\model\shop\refund\Reason;


use think\Collection;
use think\Db;
use think\Exception;

/**
 * 订单接口
 */
class Order extends Api
{
    protected $noNeedLogin = [''];
    protected $noNeedRight = ['*'];

    /**
     * 用户订单列表
     *
     */
    public function orderList()
    {
        $order_type = $this->request->post("order_type");
        $page = $this->request->post('page',1);
        $limit = $this->request->post('limit',10);

        $user = $this->auth->getUserinfo();
        $param = [
            'user_id'   => $user['id'],
            'order_type'=> $order_type,
        ];
        $result = ShopOrder::getUserOrderList($param,$page,$limit);
        $this->success('成功', $result);
    }

    /**
     * 用户订单商品详情
     *
     */
    public function orderDetails()
    {
        $order_id = $this->request->post("order_id");
        if(!$order_id){
            $this->error('参数错误！');
        }
        $result = ShopOrder::getOrderDetails($order_id);
        $this->success('成功', $result);
    }

    /**
     * 下单前准备购物车信息
     *
     */
    public function beforeOrderCart()
    {
        $shop_id = $this->request->post("shop_id");
        $cart_ids = $this->request->post("cart_ids");
        $platform_coupons = $this->request->post("platform_coupons",''); //平台券
        $shop_coupons = $this->request->post("shop_coupons",'');

        if(!$shop_id){
            $this->error('店铺参数错误！');
        }
        if(!$cart_ids){
            $this->error('购物车参数错误');
        }
        $time = time();
        $user = $this->auth->getUserinfo();
        $cell = UserServingCell::getMyDefServingCell($user['id']);

        $goodsList = ShopCart::getShopCartInfo($cart_ids);
        $cart_price = 0;
        if($goodsList){
            foreach ($goodsList as $value){
                $market = ShopMarket::getMarket($value->market_id);


                if($market){

                    if(strtotime(date("Y-m-d").$market->order_endtime) < $time){
                        $this->error('超出下单时间');
                    }
                }

                //计算订单价格
                $cart_price += bcmul($value['goods_num'],$value['price'],2);
            }

        }
        //优惠总金额
        $coupons_all =0;
        $platform_coupons_price = 0;
        $shop_coupons_price = 0;
        if($platform_coupons!==""){
           //查询一次
            $res = ShopUserCoupons::with(['shopcoupons'])->where(['tcs_shop_user_coupons.id'=>$platform_coupons,'source'=>1])->find()->toArray();
            if(!empty($res)){
                if($res['shopcoupons']['amount']<$cart_price) {
                    $cart_price = bcsub($cart_price, $res['shopcoupons']['amount'], 2);
                    $coupons_all +=$res['shopcoupons']['amount'];
                    $platform_coupons_price = $res['shopcoupons']['amount'];
                }
            }

        }
        if($shop_coupons!==""){
            //查询一次
            $res = ShopUserCoupons::with(['shopcoupons'])->where(['tcs_shop_user_coupons.id'=>$shop_coupons,'source'=>2])->find()->toArray();
            if(!empty($res)){
                if($res['shopcoupons']['amount']<$cart_price) {
                    $cart_price = bcsub($cart_price, $res['shopcoupons']['amount'], 2);
                    $coupons_all +=$res['shopcoupons']['amount'];
                    $shop_coupons_price = $res['shopcoupons']['amount'];
                }
            }
        }

        //查询打包费 添加打包费
        $configs = ShopConfigs::where(['name' => 'order'])->find();
        $configs_value = json_decode($configs['value'], true);

        $cart_price = bcadd($configs_value['packing_charge'],$cart_price,2);


         $Mycoupons = ShopUserCoupons::getMyShopCouponsNum($user['id']);
        $result = [
            'cell_info'     => $cell,
            'goods_info'    => $goodsList,
            'coupons_goods' => $Mycoupons,
            'cart_price'=>$cart_price,
            'coupons_all'=>$coupons_all,
            'platform_coupons_price'=>$platform_coupons_price,
            'shop_coupons_price'=>$shop_coupons_price,
            'packing_charge'=>$configs_value['packing_charge'],
        ];
        $this->success('成功', $result);
    }

    /**
     * 下单前准备服务小区信息
     *
     */
    public function beforeOrderCell()
    {
        $cell_id = $this->request->post("cell_id");

        if(!$cell_id){
            $this->error('请选择服务小区！');
        }
        $cell = UserServingCell::getMyServingCellOne($cell_id);
        $this->success('成功', $cell);
    }

    /**
     * 下单前准备集市送达时间
     *
     */
    public function beforeOrderMarket()
    {
        $market_id = $this->request->post("market_id");
        if(!$market_id){
            $this->error('参数错误！');
        }
        $res = ShopMarket::where(['id' => $market_id])->find();
        $this->success('成功', $res);
    }

    /**
     * 获取我的优惠券
     *
     */
    public function myCoupons()
    {
        $shop_id = $this->request->post("shop_id");
        $cart_ids = $this->request->post("cart_ids");
        $source = $this->request->post("source", ""); //优惠券来源：1.平台，2.店铺
        $coupons_type = $this->request->post('type',0);   //类型:1=满减券,2=营销次券 //优惠券类型：1.商品券，2.店铺券
        if($coupons_type == 0){
            $coupons_type = 2;  //优惠券类型：1.商品券，2.店铺券
        }else{
            $coupons_type = 1;
        }
        $where = [];
        if($source==2){
            $where['tcs_shop_coupons.coupons_type'] = ['=', $coupons_type];
        }


        $user = $this->auth->getUserinfo();
        $goodsList = ShopCart::getShopCartInfo($cart_ids);
        if(!$goodsList){
            $this->error('购物车参数有误');
        }
        $goodsList = collection($goodsList)->toArray();
        $price = 0;
        $goods_ids = [];
        foreach ($goodsList as $value){
            array_push($goods_ids, $value['goods_id']);
            $price = $price + $value['price'] * $value['goods_num'];
        }
//        $Mycoupons = ShopUserCoupons::getMyShopCouponsAll($user['id'], $source,$coupons_type);


        $Mycoupons = ShopUserCoupons::with(['shopcoupons'])
            ->where(['user_id'=>$user['id'],'source'=>$source])
            ->where($where)
            ->paginate()->toArray();

        if($Mycoupons['data']){
            //获取今日开始时间戳和结束时间戳
            $today_start = mktime(0,0,0,date('m'),date('d'),date('Y'));
            $today_end = mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1;

            foreach ($Mycoupons['data'] as &$v){
                $coupons_log_num = ShopUserCouponsLog::where([
                    'coupons_id' => $v['coupons_id'],
                    'user_id' => $user['id'],
                    'createtime' => ['between', [$today_start, $today_end]],
                ])->count();

                $v['not_use'] = '';
                if($coupons_log_num >= $v['use_times']){
                    $v['not_use'] = '已达当天使用限制';
                    continue;
                }
                if($v['status'] == 2 && $v['endtime'] < time()){
                    $v['not_use'] = '已过期';
                    continue;
                }
                if($v['shop_id'] != $shop_id && $v['shopcoupons']['source'] == 2){
                    $v['not_use'] = '不是该店铺优惠券';
                    continue;
                }
                if($v['coupon_type'] == 1 && $v['shopcoupons']['enough'] > $price){
                    $v['not_use'] = '不满足金额门槛';
                    continue;
                }
                if($v['shopcoupons']['goods_ids'] == '0'){
                    continue;
                }
                if($goods_ids){
                    $num = 0;
                    foreach ($goods_ids as $item){
                        $goodsInfo = Goods::where(['id' => $item])->find();
                        if(!$goodsInfo){
                            $this->error('商品信息异常');
                        }
                        if(in_array($item, explode(',', $v['shopcoupons']['goods_ids'])) || $v['shopcoupons']['goods_ids'] == 0){
                            $num = $num + 1;
                        }
                        if($goodsInfo->goods_label){
                            $goods_label = json_decode($goodsInfo->goods_label, true);
                            if($goods_label){
                                foreach ($goods_label as $val){
                                    $title = GoodsLabel::where(['id' => $val['id']])->value('name');
                                    if($title == '限量折扣' || $title == '限购产品'){
                                        if($v['coupons_type'] == 1){
                                            $v['not_use'] = '有折扣或限购，该商品券不可用！';
                                            continue;
                                        }
                                    }
                                }
                            }
                        }
                    }
                    if($num < 1){
                        $v['not_use'] = '指定商品可用！';
                    }
                }
            }
        }
        $this->success('成功', $Mycoupons);
    }

    /**
     * 下单
     *
     */
    public function addOrder()
    {
        $shop_id = $this->request->post("shop_id");
        $cell_id = $this->request->post("cell_id");
        $coupons_id = $this->request->post("coupons_id");
        $cart_ids = $this->request->post("cart_ids");
        $num_goods_id = $this->request->post("num_goods_id");
        $remark = $this->request->post("remark");
        $platform = $this->request->post("platform", "App");
        $market_id = $this->request->post("market_id");
        $expect_send_time = $this->request->post("expect_send_time");
        $user = $this->auth->getUserinfo();
        if(!$shop_id){
            $this->error('店铺参数错误');
        }
        if(!$cart_ids){
            $this->error('购物车参数错误');
        }
        $cell = UserServingCell::getMyServingCellOne($cell_id);

        $goodsList = ShopCart::getShopCartInfo($cart_ids);

        //追加 折扣价格 优惠价格[1平台优惠 2店铺优惠[1全部优惠2指定商品优惠]]
        $goodsList = array_map(function($item){
            $item['dis_price'] = 0; // 折扣价格
            $item['dis_num']   = 0; // 折扣个数
            $item['cou_price'] = 0; // 优惠价格
            $item['cou_id']    = 0; // 指定商品优惠券id
            return $item;
        }, $goodsList);

        if(!$goodsList){
            $this->error('购物车参数有误');
        }
        $goodsList = collection($goodsList)->toArray();

        $coupons_ids = explode(',', $coupons_id); //我的优惠券iD //查询用户优惠券关联ID
        //查询优惠券总数
        $coupon = ShopCoupons::where('id','in',$coupons_ids)->select();

        $ShopUserCouponsData = [];
        $ShopUserCouponsNum = [];
        $ShopUserCoupons = ShopUserCoupons::where(['user_id' => $user['id'], 'coupons_id' => ['in', $coupons_id]])->select();
        foreach ($ShopUserCoupons as $couponValue){
            if($couponValue->use_num == 0){
                $this->error("可使用次数已用完");
            }
            if($couponValue->use_num == 1){
                $ShopUserCouponsData[]['status'] = 2;
            }
            $ShopUserCouponsData[]['coupons_id'] = $couponValue->coupons_id;
            $ShopUserCouponsData[]['coupon_type'] = $couponValue->coupon_type;
            $ShopUserCouponsData[]['use_num'] = $couponValue->use_num - 1;
            $ShopUserCouponsData[]['used_num'] = $couponValue->used_num + 1;
        }

        if($num_goods_id) {
            $nunCouponsInfo = ShopCoupons::getGoodsCoupons($num_goods_id);
            $ShopUserCouponsNum = ShopUserCoupons::where(['user_id' => $user['id'], 'coupons_id' => $nunCouponsInfo->id])->find();
            if($ShopUserCouponsNum) {
                if ($ShopUserCouponsNum->use_num == 0) {
                    $this->error("次券可使用次数已用完");
                }
            }
        }
        $price = 0;
        $discount_fee = 0; //优惠券优惠价格
        $pay_fee = 0;      //实际支付价格
        $coupon_fee = 0;
        $goods_ids = [];
        $platform_coupon_id = 0;
        $shop_coupon_id = 0;

        $discount_price = [];
        $pay_price = [];
        $goods_amount = 0; //商品总价
        $total_amount = 0; //订单总金额
        $discounted_price = 0;
        $week = date("w");
        if($week == 0){
            $week = 7;
        }

        $time = date('H:i:s',strtotime('now'));
        //获取今日开始时间戳和结束时间戳
        $today_start = mktime(0,0,0,date('m'),date('d'),date('Y'));
        $today_end = mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1;

        $send_endtime = '';
        //查询集市结束时间
        $endtime = ShopMarket::where(['id' =>$market_id])->find();

        if(strtotime(date('Y-m-d'. $endtime->order_endtime)) < strtotime(date('Y-m-d'. $time))){
            $this->error('超出下单时间');
        }

        foreach ($goodsList as &$value){

            $market_id = $value['market_id']; //集市id
            $goodsInfo = Goods::where(['id' => $value['goods_id']])->find(); //根据id获取商品
            $market = ShopMarket::where(['id' => $value['market_id']])->find();

            
            if(!$market){
                $this->error('集市参数错误');
            }
            $send_endtime = $market->send_endtime;

            if($goodsInfo->goods_type == 1){
                if(!$goodsInfo->shop_id){
                    $this->error('门店参数有误');
                }
                $shopInfo = \app\common\model\Shop::where(['id' => $goodsInfo->shop_id])->find();
                if($shopInfo){

                    if($shopInfo->status==2){
                        $this->error('该门店正在休息中');
                    }

                    if(!in_array($week, explode(',', $shopInfo->job_days))){
                        $this->error('该门店不在营业时间');
                    }
                }
            }
            if($goodsInfo->goods_type == 2){
                if(!$goodsInfo->supplier_id){
                    $this->error('供应商参数有误');
                }
                $supplierInfo = \app\common\model\Supplier::where(['id' => $goodsInfo->supplier_id])->find();
                if($supplierInfo){
                    var_dump($week);
                    var_dump($supplierInfo->job_days);
                    if(!in_array($week, explode(',', $supplierInfo->job_days))){
                        $this->error('商品：' . $value['title'] . '已售罄');
                    }
                }
            }

            array_push($goods_ids, $value['goods_id']);
            $goods_amount += bcmul($value['price'], $value['goods_num'],2);

            $price += bcmul($value['price'], $value['goods_num'],2); //20231018 zss


            $discount_price[$value['goods_id']] = 0;
            $pay_price[$value['goods_id']] = $value['price'] * $value['goods_num'];


            if(empty($value['goods_label']) && empty($coupon)){

                $pay_fee = $price; //不适使用优惠券 和则扣  没有使用优惠券走了
            }



            if(!empty($value['goods_label'])){


                $goods_label = json_decode($value['goods_label'], true);


                foreach ($goods_label as $v){

                    if($v['time']){
                        if((time() + $v['time']*60) > strtotime(date('Y-m-d'.$market->send_endtime))){
                            $this->error('商品预制时间超过送达时间，不可购买！');
                        }
                    }

                    if((int)$v['id']!==1) {

                        if ((int)$v['id']== 2 || (int)$v['id']== 3) {
                            if ($v['discount']) {  //限量折扣


                                if ($value['goods_num'] >= $v['quota']) {

                                    if ($value['goods_num'] == $v['quota']) {

                                        $item_discount_fee = bcmul($v['discount'], bcmul($value['price'], $value['goods_num'], 2), 2); //折扣后的价格

                                        $discount_price[$value['goods_id']] = $item_discount_fee;
                                    } else {
                                        //计算出超出价格
                                        $alery_price = bcmul($value['price'], bcsub($value['goods_num'], $v['quota']), 2);
                                        //未超出价格
                                        $nob_price = bcmul($v['discount'], bcmul($value['price'], $v['quota'], 2), 2);

                                        $discount_price[$value['goods_id']] = bcadd($alery_price, $nob_price, 2);
                                    }


                                } else {
                                    $item_discount_fee = bcmul($v['discount'], bcmul($value['price'], $value['goods_num'], 2), 2); //折扣后的价格

                                    $discount_price[$value['goods_id']] = $item_discount_fee;
                                }

                                //折扣价格
                                $discounted_price += bcsub($pay_price[$value['goods_id']], $discount_price[$value['goods_id']], 2);
                                $pay_price[$value['goods_id']] = $discount_price[$value['goods_id']];


                                $value['dis_price'] = $discounted_price; //定义折扣价格
                                $value['dis_num'] = $v['quota'];       //定义折扣个数


                            } else {
                                if ($value['goods_num'] > $v['quota']) {
                                    $this->error('超出商品限购，订单异常！');
                                }
                            }

                        }
                    }


                }

            }



            if($coupon){
                foreach ($coupon as $item){
                    $coupons_log_num = ShopUserCouponsLog::where([
                        'coupons_id' => $item->id,
                        'user_id' => $user['id'],
                        'createtime' => ['between', [$today_start, $today_end]],
                    ])->count();
                    if($coupons_log_num >= $item->use_times){
                        $this->error('优惠券已达当天限制！');
                    }
                    $value['coupons_type'] = $item->source;

                    if($item->source == 1){ //平台券
                        $platform_coupon_id = $item->id;
                        $platform_coupon_amount = $item->amount;
                        $platform_coupon_enough = $item->enough;
                    }else{ //店铺券
                        if($item->coupons_type == 1){ //优惠券类型：1.商品券，2.店铺券
//                            if($title == '限量折扣' || $title == '限购产品'){
//                                $this->error('有折扣或限购时不可使用商品券！');
//                            }
                            if(in_array($value['goods_id'], explode(',', $item->goods_ids)) || $item->goods_ids == '0'){
                                $discount_fee = bcadd($discount_fee, $item->amount, 2);

                                $value['cou_price'] = $discount_fee; //定义指定商品优惠价格
                                $value['cou_id'] = $item->id;       //定义指定商品优惠id

//                                $pay_fee = bcsub($price, $discount_fee, 2);
                                $discount_price[$value['goods_id']] = $item->amount;
                                $pay_price[$value['goods_id']] = bcsub($pay_price[$value['goods_id']], $discount_price[$value['goods_id']], 2);

                            }
                        } else { //店铺券
                            if($platform_coupon_id){
                                $this->error('平台券和店铺通用券不能同时使用');
                            }
                            $shop_coupon_id = $item->id;
                            $shop_coupon_amount = $item->amount;
                            $shop_coupon_enough = $item->enough;
                        }
                    }
                }
            }

        }


//        var_dump($discounted_price.'折扣价格');
//        var_dump($pay_fee.'支付价格');
//        var_dump($price.'计算价格');
//        var_dump($discount_fee.'优惠价格');





        if($platform_coupon_id==0 && $shop_coupon_id==0){
            $pay_fee = bcsub($price, $discount_fee, 2);
        }
        if($platform_coupon_id){  //平台优惠券优惠价格
            if($price >= $platform_coupon_enough){
                $discount_fee = bcadd($discount_fee, $platform_coupon_amount, 2);
                if($pay_fee){
                    $pay_fee = bcsub($pay_fee, $discount_fee, 2);
                } else { //没有折扣 没有券
                    $pay_fee = bcsub($price, $discount_fee, 2);
                }
            }
        }
        if($shop_coupon_id){  //店铺优惠券优惠价格
            if($price >= $shop_coupon_enough){
                $discount_fee = bcadd($discount_fee, $shop_coupon_amount, 2);
                if($pay_fee){
                    $pay_fee = bcsub($pay_fee, $discount_fee, 2);
                } else {  //没有折扣 没有券
                    $pay_fee = bcsub($price, $discount_fee, 2);
                }
            }
        }

//
//        var_dump($pay_fee);
//        var_dump($discounted_price);
            //减去折扣价格
        $pay_fee = bcsub($pay_fee,$discounted_price,2);

//        var_dump($pay_fee.'未加过打包价格');
        //添加打包费
        $configs = ShopConfigs::where(['name' => 'order'])->find();
        $configs_value = json_decode($configs['value'], true);
        $pay_fee = bcadd($pay_fee,$configs_value['packing_charge'],2);

//        var_dump($pay_fee.'加过打包价格');
        $order_data = [
            'shop_id'       =>(int)$shop_id,
            'shoper_id'     => \app\common\model\Shop::where(['id' => $shop_id])->value('shoper_id'),
            'order_sn'      => ShopOrder::getSn($user['id']),
            'user_id'       => $user['id'],
            'cell_id'       => $cell_id,
            'market_id'     => $market_id,
            'phone'         => $cell->take_phone,
            'consignee'     => $cell->take_name,
            'address'       => $cell->name,
            'remark'        => $remark,
            'dispatch_amount'=>0,  //没有运费
            'packing_charge'=> $configs_value['packing_charge'], //打包费
            'goods_amount'  => $goods_amount,                          //商品总价
            'total_amount'  => $price,                          //订单总金额
            'total_fee'     => $pay_fee,                        //支付金额
            'discount_fee'  => $discounted_price,               //折扣总金额
            'coupon_fee'    => $discount_fee,                      //优惠券价格
            'all_coupon_fee'=> bcadd($discount_fee,$discounted_price,2),//优惠券折扣券总金额
            'pay_fee'       => $pay_fee,                        //实际支付价格
            'coupons_id'    => $coupons_id,                     //优惠券id
            'platform'      => $platform,
            'expect_send_time'=> strtotime($send_endtime),
        ];

        if($expect_send_time){
            $order_data['expect_send_time'] = strtotime($expect_send_time);
            $order_data['is_expect'] = 1;
        }

        ShopOrder::startTrans();
        try {
//            var_dump($order_data);
//            exit();
            $order = ShopOrder::create($order_data);

            if($order){
//                var_dump($goodsList);
//                exit();

                foreach ($goodsList as $v){

                    $order_item_data = [
                        'shop_id'               => $shop_id,
                        'order_id'              => $order->id,
                        'user_id'               => $user['id'],
                        'goods_id'              => $v['goods_id'],
                        'coupons_type'          => isset($v['coupons_type'])?$v['coupons_type']:0,
                        'coupons_id'            => $v['cou_id'],
                        'goods_title'           => $v['goods_name'],
                        'goods_image'           => $v['image'],
                        'goods_original_price'  => $v['original_price'],
                        'goods_price'           => $v['price'],
                        'discount_fee'          => $v['dis_price'],//折扣金额
                        'coupons_fee'           => $v['cou_price'],
                        'goods_num'             => $v['goods_num'],
                        'pay_price'             => $pay_price[$v['goods_id']],

                    ];
//var_dump($order_item_data);
                    ShopOrderItem::create($order_item_data);

                }
//                exit();

                //用户使用优惠券记录
                if($ShopUserCouponsData){
                    $ShopUserCouponsData = json_decode(json_encode($ShopUserCoupons),true);
                    foreach ($ShopUserCouponsData as $SUCDvolue) {
                        $coupon_id = $SUCDvolue['coupons_id'];

                        $SUCDvolue['use_order_id'] = $order->id;
                        $SUCDvolue['used_num'] = 1;
                        $SUCDvolue['usetime'] = time();
                        unset($SUCDvolue['coupons_id']);
                        ShopUserCoupons::update($SUCDvolue, ['coupons_id' => $coupon_id]);
                        $logData = [
                            'coupon_type'   => $SUCDvolue['coupon_type'],
                            'shop_id'       => $shop_id,
                            'user_id'       => $user['id'],
                            'coupons_id'    => $coupon_id,
                            'order_id'      => $order->id,
                        ];
                        ShopUserCouponsLog::create($logData);
                    }
                }

                if($num_goods_id){
                    $numGoodsInfo = Goods::get($num_goods_id);
                    $num_order_item_data = [
                        'shop_id'               => $shop_id,
                        'order_id'              => $order->id,
                        'user_id'               => $user['id'],
                        'goods_id'              => $numGoodsInfo->id,
                        'goods_title'           => $numGoodsInfo->title,
                        'goods_image'           => $numGoodsInfo->image,
                        'goods_original_price'  => $numGoodsInfo->original_price,
                        'goods_price'           => $numGoodsInfo->price,
                        'discount_fee'          => $numGoodsInfo->price,
                        'goods_num'             => 1,
                        'pay_price'             => 0,
                    ];
                    ShopOrderItem::create($num_order_item_data);

                    if($ShopUserCouponsNum){
                        if($ShopUserCouponsNum->use_num == 1){
                            $ShopUserCouponsNum->status = 2;
                        }
                        $ShopUserCouponsNum->use_num -= 1;
                        $ShopUserCouponsNum->used_num += 1;
                        $ShopUserCouponsNum->usetime = time();
                        $ShopUserCouponsNum->save();
                    }

                    $shop_user_coupons_num = [
                        'user_id'           => $user['id'],
                        'user_coupons_id'   => $nunCouponsInfo->id,
                        'use_order_id'      => $order->id,
                        'usetime'           => time(),
                    ];
                    ShopUserCouponsNum::create($shop_user_coupons_num);
                }
                ShopCart::delUserShopCart(['user_id' => $user['id'], 'shop_id' => $shop_id]);
            }
            ShopOrder::commit();
        } catch (Exception $e){
            $this->error($e->getMessage());
            ShopOrder::rollback();
        }

        $this->success('下单成功！', $order);
    }

    /**
     * 计算退款金额接口
     */
    public function countRefundOrder()
    {

        $order_id = $this->request->post('order_id');
        $order_item_ids = $this->request->post('refund_data/a');

        if(empty($order_item_ids)){

            $order_item_ids = null;
        }else{
            $order_item_ids = json_encode($order_item_ids);
        }

        $can_refund_price = 0; //可退金额
        $refund_goods_num = 0;
        $NoCouPrice = 0;//重新计算使用了平台券或者店铺通用券的应付金额
        $goods_all_price  = 0; //商品总价格
        $goods_coupons_fee= 0; //店铺指定商品优惠券
        $coupons_fee  = 0; //平台 or 店铺 优惠券减免 金额
        $discount_fee = 0; //商品折扣价

        $all_refund_goodscount = 0;
            //查询订单详情
            $order = \app\common\model\ShopOrder::where(['id'=>$order_id])->find()->toArray();

            if($order){

                $order['goodsCount'] = ShopOrderItem::where(['order_id' =>$order_id])->count();
                $order['all_goods_num'] = ShopOrderItem::where(['order_id' =>$order_id])->sum('goods_num');
                $order['goods_item'] = ShopOrderItem::alias('soi')
                        ->field("soi.*,g.is_refund")
                        ->join("goods g", "g.id = soi.goods_id", "LEFT")
                        ->where(['soi.order_id' => $order_id])
                        ->select();






                 if(!empty($order['goods_item'])) {

                   if (!empty($order_item_ids)) { //做退款减法运算部分退款  //不为空 退款计算

                       $order_item_ids = json_decode($order_item_ids, true);
                       //查询退款商品个数
                       foreach ($order_item_ids as $k => $v) {
                           $refund_goods_num += $v['count'];
                       }
                       if ((int)$order['all_goods_num'] == $refund_goods_num) {  //全部退款



                           $can_refund_price = $order['pay_fee'];
                           $order['can_refund_price'] = $can_refund_price;






                       }else{   //个别退款计算
$ij=0;

                           foreach ($order['goods_item'] as $k => &$v) {
                               foreach ($order_item_ids as $i => $h) {
                                   if ($h['id'] == $v['id']) {
                                       $v['refund_goods_num'] = $v['goods_num'] - $h['count']; //退钱数量
                                       if ($v['refund_goods_num'] == 0) {   //0全退商品 //部分退款  //未退商品
                                           $v['refund_goods_num'] = $v['goods_num'];
                                       } elseif($v['refund_goods_num']>0){
                                           $v['refund_goods_num'] = $v['refund_goods_num']; //没有退款商品
                                       }else{
                                           $v['refund_goods_num'] == 0;
                                       }

                                   //计算退款
                                   if ($v['refund_goods_num'] !== 0) {
                                       //1.判断是否使用指定商品优惠券
                                       if ($v['coupons_id'] !== 0) {  //当前商品使用指定优惠券
                                           //查询优惠券优惠金额
                                           $Specify_coupon = ShopCoupons::where('id', $v['coupons_id'])->find();
                                           if ($v['goods_num'] == $h['count']) {
                                               $can_refund_price += $v['pay_price'];
                                           } else {
                                               $can_refund_price += bcmul(bcdiv(bcsub(bcmul($v['goods_num'], $v['goods_price'], 2), $Specify_coupon['amount'], 2), $v['goods_num'], 2), $v['refund_goods_num'], 2);
                                           }


                                       } else {  //普通商品支付
//2.平台优惠券 || 店铺优惠券
//查询订单使用优惠券
//（1）使用一张满10减2元的通用满减券，买A+B+C
//需要支付（10+8+5）-2 =21元，
//仅退A时  退21/23*10=9.13
//仅退B时  退21/23*8=7.3
//仅退C时  退21/23*5=4.56
//退A+B时   退21/23*（10+8）=16.43   以此类推
//按照比例退款
                                           foreach ($order['goods_item'] as $n) {
                                               if ($n['coupons_id'] == 0) {
                                                   $NoCouPrice += bcmul($n['goods_num'], $n['goods_price'], 2);
                                               }
                                           }

                                           //查询平台或者店铺通用优惠券
                                           $common_coupon = ShopCoupons::where('id', 'in', explode(',', $order['coupons_id']))->where('coupons_type', 'neq', 1)->find();
                                           //判断是否有折扣商品
                                           if ($v['discount_fee'] !== 0.00) {

                                               $can_refund_price += bcsub(bcmul(bcmul(bcdiv(bcsub($NoCouPrice, $common_coupon['amount'], 2), $NoCouPrice, 2), $v['goods_price'], 2), $v['refund_goods_num'], 2), $v['discount_fee'], 2);

                                               $ij++;
                                           } else {
                                               var_dump(11111);
                                               $can_refund_price += bcmul(bcmul(bcdiv(bcsub($NoCouPrice, $common_coupon['amount'], 2), $NoCouPrice, 2), $v['goods_price'], 2), $v['refund_goods_num'], 2);
                                           }
                                           $NoCouPrice = 0;
//

                                       }


                                   }
                               }
                                   var_dump($can_refund_price);
                                   $order['can_refund_price'] = $can_refund_price;

                                }
                             }
///////////////////////////////////




///////////////////////////////////////////
                      }


                    }

                  }else{
                       $this->error('退款商品不能为空');
                  }




                }



                $this->success('获取成功',$order);
            }





    /**
     * 订单退款
     */
    public function refundOrder()
    {
        $order_id = $this->request->post("order_id");
        $order_item_ids = $this->request->post("order_item_ids");
        $refund_data = $this->request->post('refund_data/a');
        $refund_reason_id = $this->request->post("refund_reason_id"); //退款原因
        $refund_images = $this->request->post("images"); //图片
        $remark = $this->request->post("remark"); //退款备注
        if(!$order_id){
            $this->error('参数错误！');
        }
        if($order_item_ids){
            $order_item_ids = explode(',', $order_item_ids);
        }

        $result = ShopOrder::refundOrder($order_id, $order_item_ids,$refund_data,$refund_reason_id,$refund_images, $remark);
        if(!$result){
            $this->error('失败！');
        }
        if($result['code'] == 0){
            $this->error($result['msg']);
        }
        $this->success('成功！');
    }

    /**
     * 查询退款原因
     */
    public function getRefundReason()
    {
        if(request()->Ispost()){
           $res = Reason::where('status',1)->select();
           $this->success('获取成功',$res);
        }
    }

    public function doCancel()
    {
        if(request()->isPost()) {
            $order_id = $this->request->post('order_id');
            $type = 'user';
            $userInfo = $this->auth->getUserinfo();
            $order = \addons\shopro\model\Order::with('item')->where('user_id', $userInfo['id'])->where('id', $order_id)->nopay()->find();

            if (!$order) {
                new \addons\shopro\exception\Exception('订单不存在或已取消');
            }
            $user = User::info();
            $order = Db::transaction(function () use ($order, $user, $type) {
                $data = ['order' => $order];
                \think\Hook::listen('order_cancel_before', $data);

                $order->status = \addons\shopro\model\Order::STATUS_CANCEL;        // 取消订单
                $order->ext = json_encode($order->setExt($order, ['cancel_time' => time()]));      // 取消时间
                $order->save();

                OrderAction::operAdd($order, null, $user, $type, ($type == 'user' ? '用户' : '管理员') . '取消订单');

                // 订单取消，退回库存，退回优惠券积分，等
                $data = ['order' => $order];
                \think\Hook::listen('order_cancel_after', $data);

            });
            $this->success('取消订单成功');

        }

    }




    /**
     * 订单评价
     *
     */
    public function commentOrder()
    {
        $order_id = $this->request->post("order_id");
        $level = $this->request->post("level", 5);
        $goods_level = $this->request->post("goods_level", 5);
        $delivery_level = $this->request->post("delivery_level", 5);
        $content = $this->request->post("content");
        $images = $this->request->post("images");
        if(!$order_id || !$level || !$goods_level || !$delivery_level){
            $this->error('参数错误！');
        }
        $userInfo = $this->auth->getUserinfo();
        $orderInfo = ShopOrder::getUserOrderOne($order_id);
        if(!$orderInfo){
            $this->error("订单参数异常！");
        }
        if($orderInfo->status != 2){
            $this->error("该订单未完成，不可评价！");
        }
        if($orderInfo->comment_status == 1){
            $this->error("该订单已评价过！");
        }
        $orderItem = ShopOrderItem::getOrderItem($order_id);
        if(!$orderItem){
            $this->error("订单详情参数异常！");
        }
        $data = [];
        $itemData = [];
        foreach ($orderItem as $value){
            if($value->comment_status == 0){
                $itemData[] = [
                    'id'            => $value->id,
                    'comment_status'=> 1,
                ];
                $data[] = [
                    'shop_id'       => $value->shop_id,
                    'goods_id'      => $value->goods_id,
                    'order_id'      => $order_id,
                    'order_item_id' => $value->id,
                    'user_id'       => $userInfo['id'],
                    'level'         => $level,
                    'goods_level'   => $goods_level,
                    'delivery_level'=> $delivery_level,
                    'content'       => $content,
                    'images'        => $images,
                ];
            }
        }
        $GoodsComment = new GoodsComment();
        $res = $GoodsComment->saveAll($data);
        if($res){
            ShopOrder::update(['comment_status' => 1], ['id' => $order_id]);
            $ShopOrderItem = new ShopOrderItem();
            $ShopOrderItem->saveAll($itemData);
        }

        $this->success('成功！');
    }
}