<?php

namespace app\operations\model\takeout;

use app\common\model\order\OrderSettled as OrderSettledModel;
use app\common\model\supplier\Cash as CashModel;

/**
 * 订单结算模型
 */
class OrderSettled extends OrderSettledModel
{
    // 定义全局的查询范围
    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 getSettledData($shop_supplier_id)
    {
        $today = date('Y-m-d');
        $yesterday = date('Y-m-d', strtotime('-1 day'));
        $data = [
            // 供应商总金额
            'supplier_money' => [
                'total' => number_format($this->getDatas(null, null, 'supplier_money', $shop_supplier_id), 2),
                'today' => number_format($this->getDatas($today, null, 'supplier_money', $shop_supplier_id), 2),
                'yesterday' => number_format($this->getDatas($yesterday, $yesterday, 'supplier_money', $shop_supplier_id), 2)
            ],
            // 供应商待结算
            'settle_money' => [
                'total' => number_format($this->getDatas(null, null, 'settle_money', $shop_supplier_id), 2),
                'today' => number_format($this->getDatas($today, null, 'settle_money', $shop_supplier_id), 2),
                'yesterday' => number_format($this->getDatas($yesterday, $yesterday, 'settle_money', $shop_supplier_id), 2)
            ],
            // 供应商已结算
            'real_supplier_money' => [
                'total' => number_format($this->getDatas(null, null, 'real_supplier_money', $shop_supplier_id), 2),
                'today' => number_format($this->getDatas($today, null, 'real_supplier_money', $shop_supplier_id), 2),
                'yesterday' => number_format($this->getDatas($yesterday, $yesterday, 'real_supplier_money', $shop_supplier_id), 2)
            ],
            // 退款金额
            'refund_money' => [
                'total' => number_format($this->getDatas(null, null, 'refund_money', $shop_supplier_id), 2),
                'today' => number_format($this->getDatas($today, null, 'refund_money', $shop_supplier_id), 2),
                'yesterday' => number_format($this->getDatas($yesterday, $yesterday, 'refund_money', $shop_supplier_id), 2)
            ],
            // 提现金额
            'cash_money' => [
                'total' => number_format($this->getDatas(null, null, 'cash_money', $shop_supplier_id), 2),
                'today' => number_format($this->getDatas($today, null, 'cash_money', $shop_supplier_id), 2),
                'yesterday' => number_format($this->getDatas($yesterday, $yesterday, 'cash_money', $shop_supplier_id), 2)
            ],
            // 提现金额
            'income' => [
                'total' => number_format($this->getDatas(null, null, 'income', $shop_supplier_id), 2),
                'today' => number_format($this->getDatas($today, null, 'income', $shop_supplier_id), 2),
                'yesterday' => number_format($this->getDatas($yesterday, $yesterday, 'income', $shop_supplier_id), 2)
            ],
        ];
        return $data;
    }

    /**
     * 按日期获取结算数据
     */
    public function getSettledDataByDate($days, $shop_supplier_id)
    {
        $data = [];
        foreach ($days as $day) {
            $data[] = [
                'day' => $day,
                'real_supplier_money' => $this->getDatas($day, $day, 'real_supplier_money', $shop_supplier_id),
                'refund_money' => $this->getDatas($day, $day, 'refund_money', $shop_supplier_id),
                'supplier_money' => $this->getDatas($day, $day, 'supplier_money', $shop_supplier_id),
                'settle_money' => $this->getDatas($day, $day, 'settle_money', $shop_supplier_id),
                'cash_money' => $this->getDatas($day, $day, 'cash_money', $shop_supplier_id),
                'order_count' => $this->getDatas($day, $day, 'order_count', $shop_supplier_id),
            ];
        }
        return $data;
    }

    /**
     * 获取供应商统计数量
     */
    public function getDatas($startDate = null, $endDate = null, $type = 'real_supplier_money', $shop_supplier_id)
    {
        if ($type == "cash_money") {
            $model = new CashModel;
        } else {
            $model = new Order;
            $model = $model->where('pay_status', '=', 20);
        }
        if ($shop_supplier_id) {
            $model = $model->where('shop_supplier_id', '=', $shop_supplier_id);
        }
        if ($startDate && $endDate) {
            $model = $model->where('create_time', 'between', [strtotime($startDate), strtotime($endDate) + 86399]);
        } else if ($startDate) {
            $model = $model->where('create_time', '>', strtotime($startDate));
        }
        if ($type == 'real_supplier_money') {
            return $model->where('order_status', '=', 30)->sum('pay_price');
        } else if ($type == 'refund_money') {
            return $model->where('order_status', 'in', '10,30')->sum('refund_money');
        } else if ($type == 'supplier_money') {
            return $model->where('order_status', 'in', '10,30')->sum('pay_price');
        } else if ($type == 'settle_money') {
            return $model->where('order_status', '=', 10)->sum('pay_price');
        } else if ($type == 'cash_money') {
            return $model->where('apply_status', '=', 40)->sum('money');
        } else if ($type == 'order_count') {
            return $model->where('order_status', 'in', '10,30')->count();
        } else if ($type == 'income') {
            $income = $model->where('order_status', 'in', '10,30')->field("sum(pay_price-refund_money) as income")->find();
            return $income['income'];
        }
        return 0;
    }


    /**
     * 获取售后单列表
     */
    public function getList($params)
    {
        $model = $this;
        // 查询条件：订单号
        if (isset($params['order_no']) && !empty($params['order_no'])) {
            $model = $model->where('order.order_no', 'like', "%{$params['order_no']}%");
        }
        if (isset($params['start_day']) && !empty($params['start_day'])) {
            $model = $model->where('settled.create_time', '>=', strtotime($params['start_day']));
        }
        if (isset($params['end_day']) && !empty($params['end_day'])) {
            $model = $model->where('settled.create_time', '<', strtotime($params['end_day']));
        }
        // 是否结算
        if (isset($params['is_settled']) && $params['is_settled'] > -1) {
            $model = $model->where('settled.is_settled', '=', $params['is_settled']);
        }
        if (isset($params['shop_supplier_id']) && $params['shop_supplier_id']) {
            $model = $model->where('settled.shop_supplier_id', '=', $params['shop_supplier_id']);
        }
        // 获取列表数据
        return $model->alias('settled')->field('settled.*')
            ->with(['orderMaster', 'supplier'])
            ->join('order', 'order.order_id = settled.order_id')
            ->order(['settled.create_time' => 'desc'])
            ->paginate($params, false, [
                'query' => \request()->request()
            ]);
    }
}