<?php

namespace app\api\model\plus\vip;

use app\common\model\plus\vip\Order as VipOrderModel;

/**
 * VIP专区订单API模型
 */
class Order extends VipOrderModel
{
    /**
     * 隐藏属性
     * @var array
     */
    protected $hidden = [
        'app_id',
        'update_time'
    ];

    /**
     * 获取订单列表
     * @param $vip_user_id
     * @param int $type
     * @param array $query
     * @return \think\Paginator
     * @throws \think\exception\DbException
     */
    public function getList($vip_user_id, $type = -1, $query = [])
    {
        $model = $this->where('vip_area_user_id', '=', $vip_user_id);

        if ($type > -1) {
            $model = $model->where('vip_area_type', '=', $type);
        }
        if (isset($query['is_settled']) && $query['is_settled']>=0) {
            $model = $model->where('is_settled', '=', $query['is_settled']);
        }

        return $model->with(['user', 'vipUser', 'referee','orderMaster'=>['product'=>['image']]])
            ->where('is_invalid', '=', 0)
            ->order(['create_time' => 'desc'])
            ->paginate($query);
    }

    /**
     * 获取订单统计数据
     * @param $vip_user_id
     * @return array
     */
    public static function getStatistics($vip_user_id)
    {
        // 总订单数
        $totalCount = self::where('vip_area_user_id', '=', $vip_user_id)->count();
        
        // 推广订单数
        $promoteCount = self::where('vip_area_user_id', '=', $vip_user_id)
            ->where('vip_area_type', '=', 10)
            ->count();
            
        // 推广复购订单数
        $reorderCount = self::where('vip_area_user_id', '=', $vip_user_id)
            ->where('vip_area_type', '=', 20)
            ->count();
            
        // 已结算佣金
        $settledMoney = self::where('vip_area_user_id', '=', $vip_user_id)
            ->where('is_settled', '=', 1)
            ->sum('vip_area_money');
            
        // 待结算佣金
        $unsettledMoney = self::where('vip_area_user_id', '=', $vip_user_id)
            ->where('is_settled', '=', 0)
            ->sum('vip_area_money');

        return [
            'total_count' => $totalCount,
            'promote_count' => $promoteCount,
            'reorder_count' => $reorderCount,
            'settled_money' => $settledMoney,
            'unsettled_money' => $unsettledMoney,
        ];
    }
}