<?php
namespace app\massage\model;

use app\BaseModel;
use Darabonba\GatewaySpi\Models\InterceptorContext\response;
use think\facade\Db;

class OrderGoods extends BaseModel
{
    //定义表名
    protected $name = 'massage_service_order_goods_list';


    protected $append = [

        'refund_num',

        'service_id'
    ];


    /**
     * @param $value
     * @param $data
     * @功能说明:
     * @author chenniang
     * @DataTime: 2023-02-28 15:21
     */
    public function getServiceIdAttr($value,$data){

        if(isset($data['goods_id'])){

            return $data['goods_id'];
        }


    }


    /**
     * @param $value
     * @param $data
     * @功能说明:获取退款的数量
     * @author chenniang
     * @DataTime: 2021-04-12 10:46
     */
    public function getRefundNumAttr($value,$data){

        if(!empty($data['id'])){

            $refund_model = new RefundOrder();

            $num = $refund_model->refundNum($data['id']);

            return $num;
        }

    }


    /**
     * @author chenniang
     * @DataTime: 2020-09-29 11:04
     * @功能说明:添加
     */
    public function dataAdd($data){

        $res = $this->insert($data);

        return $res;

    }


    /**
     * @author chenniang
     * @DataTime: 2020-09-29 11:05
     * @功能说明:编辑
     */
    public function dataUpdate($dis,$data){

        $res = $this->where($dis)->update($data);

        return $res;

    }


    /**
     * @author chenniang
     * @DataTime: 2020-09-29 11:06
     * @功能说明:列表
     */
    public function dataList($dis,$page){

        $data = $this->where($dis)->order('id desc')->paginate($page)->toArray();

        return $data;

    }

    /**
     * @author chenniang
     * @DataTime: 2020-09-29 11:06
     * @功能说明:列表
     */
    public function dataSelect($dis){

        $data = $this->where($dis)->order('id desc')->select()->toArray();

        return $data;

    }


    /**
     * @author chenniang
     * @DataTime: 2020-09-29 11:43
     * @功能说明:
     */
    public function dataInfo($dis){

        $data = $this->where($dis)->find();

        return !empty($data)?$data->toArray():[];

    }


    /**
     * @author chenniang
     * @DataTime: 2021-03-22 11:12
     * @功能说明:添加商品子订单
     */
    public function orderGoodsAdd($order_goods,$order_id,$cap_id,$user_id){

        $goods_model = new Service();

        $car_model   = new Car();

        foreach ($order_goods as $v){

            $ser_status = $goods_model->where(['id'=>$v['service_id']])->value('status');

            if($ser_status!=1){

                return ['code'=>500,'msg'=>'服务已经下架'];
            }

            $insert = [

                'uniacid'        => $v['uniacid'],

                'order_id'       => $order_id,

                'user_id'        => $user_id,

                'pay_type'       => 1,

                'coach_id'       => $cap_id,

                'goods_name'     => $v['title'],

                'goods_cover'    => $v['cover'],

                'price'          => $v['price'],

                'material_price' => $v['material_price'],

                'true_price'     => round($v['true_price']/$v['num'],5),

                'time_long'      => $v['time_long'],

                'num'            => $v['num'],

                'can_refund_num' => $v['num'],

                'goods_id'       => $v['service_id'],

                'coupon_discount'=> !empty($v['coupon_discount'])?$v['coupon_discount']:0,

            ];

            $res = $this->dataAdd($insert);

            if($res!=1){

                return ['code'=>500,'msg'=>'下单失败'];
            }
            //减少库存 增加销量
            $res = $goods_model->setOrDelStock($v['service_id'],$v['num']);

            if(!empty($res['code'])){

                return $res;
            }

        }
        //删除购物车
        $car_model->where(['user_id'=>$user_id,'coach_id'=>$cap_id,'status'=>1])->delete();

        return true;

    }


    /**
     * @author chenniang
     * @DataTime: 2021-03-22 11:12
     * @功能说明:升级订单添加商品子订单
     */
    public function upOrderGoodsAdd($order_goods,$order_id,$cap_id,$user_id){

        foreach ($order_goods as $v){

            $dis = [

                'goods_name'   => $v['title'],

                'goods_cover'  => $v['cover'],

                'price'        => $v['price'],

                'true_price'   => $v['true_price'],

                'time_long'    => $v['time_long'],

                'material_price'=> $v['material_price'],

                'order_id'     => $order_id,

            ];

            $find = $this->dataInfo($dis);

            $coupon_discount = !empty($v['coupon_discount'])?$v['coupon_discount']:0;

            if(empty($find)){

                $insert = [

                    'uniacid'        => $v['uniacid'],

                    'order_id'       => $order_id,

                    'user_id'        => $user_id,

                    'pay_type'       => 1,

                    'coach_id'       => $cap_id,

                    'goods_name'     => $v['title'],

                    'goods_cover'    => $v['cover'],

                    'price'          => $v['price'],

                    'true_price'     => $v['true_price'],

                    'time_long'      => $v['time_long'],

                    'num'            => $v['num'],

                    'can_refund_num' => $v['num'],

                    'goods_id'       => $v['service_id'],

                    'material_price' => $v['material_price'],

                    'coupon_discount'=> $coupon_discount,

                ];

                $res = $this->dataAdd($insert);

            }else{

                $res = $this->dataUpdate(['id'=>$find['id']],['num'=>$find['num']+$v['num'],'coupon_discount'=>$find['coupon_discount']+$coupon_discount]);
            }

        }

        return $res;

    }
    /**
     * @author chenniang
     * @DataTime: 2022-12-13 11:17
     * @功能说明:获取升级的价格
     */
    public function getUpGoodsData($order_goods_list,$coupon_id,$order_id){

        $service_model = new Service();

        $order_goods_model = new OrderGoods();

        $coupon_model = new Coupon();

        foreach ($order_goods_list as &$v){
            //原项目信息
            $order_goods = $order_goods_model->dataInfo(['id'=>$v['order_goods_id']]);

            if(empty($order_goods)){

                return ['code'=>500,'msg'=>'升级商品错误'];
            }
            //新项目
            $service = $service_model->serviceInfo(['id'=>$v['service_id']]);

            $v = array_merge($service,$v);

            $num[$v['order_goods_id']] = !empty($num[$v['order_goods_id']])?$num[$v['order_goods_id']]+$v['num']:$v['num'];
            //校验数量
            if($num[$v['order_goods_id']]>$order_goods['num']){

                return ['code'=>500,'msg'=>'升级商品数量错误错误'];

            }
            //校验价格
            if($v['price']<$order_goods['true_price']){

                return ['code'=>500,'msg'=>'只能选择价格更高的服务，请刷新重新选择'];

            }
            //校验项目
            if($order_goods['goods_id']==$v['service_id']){

                return ['code'=>500,'msg'=>'不能升级本来项目'];

            }
            //项目价格
            $v['true_price'] = $v['price']*$v['num'];

            $v['all_price']  = $v['true_price'];
            //支付价格(差价 含物料差价)
            $v['pay_price']  = round(($v['price']+$v['material_price'] - $order_goods['true_price']-$order_goods['material_price'])*$v['num'],2);
            //总时长
            $v['total_time_long'] = $v['time_long']*$v['num'];
            //相差时长
            $v['del_time_long'] = ($v['time_long'] - $order_goods['time_long'])*$v['num'];
            //原价
            $goods_price        = $v['num']*$order_goods['price'];

            $true_goods_price   = $v['num']*$order_goods['true_price'];
            //物料费
            $material_price     = $v['num']+$order_goods['material_price'];
            //相差的服务价格
            $v['service_price'] = round($v['true_price'] - $goods_price,2);
            //相差的物料费
            $v['material_price']= round($v['material_price']*$v['num'] - $material_price,2);

            $v['true_service_price'] = round($v['true_price'] - $true_goods_price,2);
            //原服务的时长
            $v['old_time_long'] = $order_goods['time_long']*$v['num'];
            //原项目的折扣
            $v['old_discount']  = ($order_goods['price'] - $order_goods['true_price'])*$v['num'];

        }

        $order_goods_id = array_column($order_goods_list,'order_goods_id');

        $old_discount = $this->where(['status'=>1,'order_id'=>$order_id])->where('id','not in',$order_goods_id)->sum('coupon_discount');

        $arr['list'] = $order_goods_list;

        $res = $coupon_model->orderCouponData($arr,$coupon_id,$old_discount,2);

        $coupon_discount = !empty($res['total_discount'])?$res['total_discount']:0;

        $order_goods_list = $res['list'];

        $data['order_goods']     = $order_goods_list;

        $data['order_price']     = round(array_sum(array_column($order_goods_list,'true_price')),2);

        $data['service_price']   = round(array_sum(array_column($order_goods_list,'service_price')),2);

        $data['material_price']  = round(array_sum(array_column($order_goods_list,'material_price')),2);

        $data['true_service_price']   = round(array_sum(array_column($order_goods_list,'true_service_price'))-$coupon_discount,2);

        $data['pay_price']       = round(array_sum(array_column($order_goods_list,'pay_price'))-$coupon_discount,2);

        $data['total_time_long'] = array_sum(array_column($order_goods_list,'total_time_long'));
        //相差时长
        $data['time_long']       = array_sum(array_column($order_goods_list,'del_time_long'));

        $data['old_time_long']   = array_sum(array_column($order_goods_list,'old_time_long'));

        $data['discount']        = array_sum(array_column($order_goods_list,'old_discount'));

        $data['coupon_discount'] = $coupon_discount;

        return $data;
    }


}