<?php

namespace app\supplier\model\order;

use app\common\model\order\OrderSettled as OrderSettledModel;

/**
 * 售后管理模型
 */
class OrderSettled extends OrderSettledModel
{
    /**
     * 获取售后单列表
     */
    public function getList($shop_supplier_id, $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']);
        }
		
        // 获取列表数据
        return $model->alias('settled')->field('settled.*')
            ->with(['orderMaster'])
            ->join('order', 'order.order_id = settled.order_id')
            ->where('settled.shop_supplier_id', '=', $shop_supplier_id)
            ->order(['settled.create_time' => 'desc'])
            ->paginate($params);
    }
    /**
     * 获取支出分销佣金
     */
    public function getAgentMoney($shop_supplier_id)
    {
        // 退款金额
        return $this->where('shop_supplier_id', '=', $shop_supplier_id)
            ->sum('agent_money');
    }
    /**
     * 获取支出团队分红
     */
    public function getTeamMoney($shop_supplier_id)
    {
        // 退款金额
        return $this->where('shop_supplier_id', '=', $shop_supplier_id)
            ->sum('team_money');
    }
    /**
     * 获取支出区域佣金
     */
    public function getRegionMoney($shop_supplier_id)
    {
        // 退款金额
        return $this->where('shop_supplier_id', '=', $shop_supplier_id)
            ->sum('region_money');
    }
    /**
     * 获取支出区域佣金
     */
    public function getShareholderMoney($shop_supplier_id)
    {
        // 退款金额
        return $this->where('shop_supplier_id', '=', $shop_supplier_id)
            ->sum('shareholder_money');
    }
}