<?php

namespace app\operations\model\plus\release;

use app\common\model\plus\release\Order as OrderModel;
use app\common\model\plus\release\SupplyUser as SupplyUserModel;
use app\operations\service\order\ExportService;

/**
 * 订单模型
 */
class Order extends OrderModel
{
    // 定义全局的查询范围
    protected $globalScope = ['status'];
    public function scopeStatus($query)
    {
        $shop_supplier_ids = \app\operations\model\supplier\Supplier::getSupplierIdsByUser(session('jjjshop_operations')['user']);
        if (empty($shop_supplier_ids)){
            $query->where($query->getTable() . '.shop_supplier_id', -1);
        }else{
            $query->where($query->getTable() . '.shop_supplier_id', 'in', $shop_supplier_ids);
        }
    }
    /**
     * 获取订单列表
     */
    public function getList($search)
    {
        $model = $this
            ->with(['demanduser','supplyuser',"project"])
            ->order(['create_time' => 'desc']);

        if (!empty($search['supply_user_id'])) {
            $model = $model->where('supply_user_id', '=', $search['supply_user_id']);
        }
        if (!empty($search['demand_user_id'])) {
            $model = $model->where('demand_user_id', '=', $search['demand_user_id']);
        }
        if ($search['pay_status'] > -1) {
            $model = $model->where('pay_status', '=', $search['pay_status']);
        }
        if ($search['order_status'] > -1) {
            $model = $model->where('order_status', '=', $search['order_status']);
        }
        if (!empty($search['pay_type'])) {
            $model = $model->where('pay_type', '=', $search['pay_type']);
        }
        //搜索时间段
        if (isset($search['create_time']) && $search['create_time'] != '') {
            $sta_time = array_shift($search['create_time']);
            $end_time = array_pop($search['create_time']);
            $model = $model->whereBetweenTime('create_time', $sta_time, date('Y-m-d 23:59:59', strtotime($end_time)));
        }
   
        // if (!empty($search['nick_name'])) {
        //     $model = $model->where('user.nickName|order.real_name|order.mobile', 'like', '%' . $search['nick_name'] . '%');
        // }
        // 获取列表数据
        return $model->paginate($search);
    }

    /**
     * 编辑用户
     * @param $data
     * @return bool
     */
    public function edit($data)
    {
        // 开启事务
        $this->startTrans();
        try {
            $this->save($data);
            $this->commit();
            return true;
        } catch (\Exception $e) {
            $this->error = $e->getMessage();
            $this->rollback();
            return false;
        }
    }

    /**
     * 获取微信支付的金额
     */
    public function getTotalPayByDate($day,$user_ids=[],$in='true',$pay_type=10,$shop_supplier_id='')
    {
        if(is_array($day)){
            $start = $day[0];
            $end = $day[1];
        }else{
            $start = strtotime($day);
            $end = strtotime($day) + 86399;
        }
        $model = $this;
        if(!empty($user_ids)){
            if($in){
                $model = $model->where('user_id', 'in', $user_ids);
            }else{
                $model = $model->where('user_id', 'not in', $user_ids);
            }
        }
        $money = $model->where('create_time', 'between', "$start,$end")
            ->where('pay_status', '=', 20)
            ->where('pay_type', '=', $pay_type)
            ->sum("pay_price");

        return $money;
    }

    /**
     * 确认线下已支付
     */
    public function onCash($data)
    {
        if (
            $this['pay_status'] != 10
        ) {
            $this->error = '该订单不满足线下支付条件';
            return false;
        }
        return $this->transaction(function () use ($data) {
            $save_data=[
                'pay_status'=>20,
                'pay_time'=>time(),
                'pay_type'=>40,
            ];
            return $this->where("id","=",$data["id"])->save($save_data);
        });
    }

    /**
     * 确认已完成订单
     */
    public function onFinish($data)
    {
        if (
            $this['pay_status'] != 20
            || $this['order_status'] != 10
        ) {
            $this->error = '该订单不满足完成的条件';
            return false;
        }
        return $this->transaction(function () use ($data) {
            //给供应方发放佣金
            (new SupplyUserModel())->where("user_id","=",$this["supply_user_id"])->inc("money",$this["money"])->update();

            $save_data=[
                'order_status'=>30,
                'finish_time'=>time(),
            ];
            return $this->where("id","=",$data["id"])->save($save_data);
        });
    }

    /**
     * 取消订单
     */
    public function confirmCancel($user)
    {
        if ($this['order_status'] == 30) {
            $this->error = '已完成不可取消';
            return false;
        }
        //订单不能取消
        if($this['order_status'] != 10){
            $this->error = '该订单取消失败';
            return false;
        }

        // 订单取消事件
        return $this->transaction(function () use ($user) {
            // 更新订单状态
            return $this->save(['order_status' => 20]);
        });
    }

}