<?php

namespace app\common\model\branch;

use app\common\model\BaseModel;
use app\common\service\order\OrderService;

/**
 * 用户模型
 */

class ActivityUser extends BaseModel
{
    protected $name = 'branch_activity_user';
    protected $pk = 'order_id';

    /**
     * 追加字段
     * @var string[]
     */
    protected $append = [
        'pay_status_text',
        'pay_type_text',
        'status_text',
    ];

    /**
     * 关联会员记录表
     * @return \think\model\relation\BelongsTo
     */

    public function user()
    {
        return $this->belongsTo('app\\common\\model\\user\\User');
    }

    /**
     * 关联活动记录表
     * @return \think\model\relation\BelongsTo
     */

    public function activity()
    {
        return $this->belongsTo('app\\common\\model\\branch\\Activity', 'activity_id', 'activity_id');
    }
    public function branch()
    {
        return $this->belongsTo('app\\common\\model\\branch\\Branch', 'branch_id', 'branch_id');
    }

    /**
     * 支付状态
     */
    public function getPayStatusTextAttr($value, $data)
    {
        if($data["pay_status"] == 20){
            $pay_status = "已支付";
        }else{
            $pay_status = "未支付";
        }
        return $pay_status;
    }
    /**
     * 支付方式
     */
    public function getPayTypeTextAttr($value, $data)
    {
        $pay_type="";
        if($data["pay_type"] == 20){
            $pay_type = "微信支付";
        }elseif($data["pay_type"] == 10){
            $pay_type = "余额支付";
        }
        return $pay_type;
    }
    /**
     * 报名状态
     */
    public function getStatusTextAttr($value, $data)
    {
        $status = '报名失败';
        if ($data["status"] == 1) {
            $status = "报名成功";
        } else {
            if ($data['pay_price'] && $data['pay_status'] == 10) {
                $status = "待支付活动费用";
            }
        }
        return $status;
    }

    /**
     * 详情
     */
    public static function detail($where, $with = ['user'])
    {
        !is_array($where) && $where = ['order_id' => (int)$where];
        return (new static())->where(array_merge(['is_delete' => 0, 'status' => 1], $where))->with($with)->find();
    }

    /**
     * 待支付详情
     */
    public static function getPayDetail($orderNo)
    {
        $model = new static();
        return $model->where(['order_no' => $orderNo, 'pay_status' => 10])->with(['user'])->find();
    }

    /**
     * 新增用户记录
     * @param $user_id
     * @param $data
     * @return bool
     */
    public static function add($data)
    {
        $model = new static;
        $model->save(array_merge([
            'is_delete' => 0,
            'app_id' => $model::$app_id
        ], $data));
        return $model['order_id'];
    }
    /**
     * 获取报名数量
     */
    public static function getRegNum($activity_id)
    {
        return (new static())->where('activity_id', '=', $activity_id)
            ->where('status', '=', 1)
            ->where('is_delete', '=', 0)
            ->count();
    }

    /**
     * 获取签到数量
     */
    public static function getVerifyNum($activity_id)
    {
        return (new static())->where('activity_id', '=', $activity_id)
            ->where('is_verify', '=', 1)
            ->where('is_delete', '=', 0)
            ->count();
    }

    /**
     * 生成订单号
     */
    public function orderNo()
    {
        return OrderService::createOrderNo();
    }

    /**
     * 获取报名总数 (可指定某天)
     */
    public function getUserData($startDate = null, $endDate = null, $type, $branch_id = 0)
    {
        $model = $this->alias('u')
                ->join('branch_member', 'u.user_id = branch_member.user_id', 'left');

        !is_null($startDate) && $model = $model->where('pay_time', '>=', strtotime($startDate));

        if (is_null($endDate)) {
            !is_null($startDate) && $model = $model->where('pay_time', '<', strtotime($startDate) + 86400);
        } else {
            $model = $model->where('pay_time', '<', strtotime($endDate) + 86400);
        }

        if ($branch_id > 0) {
            $model = $model->where('branch_member.branch_id', '=', $branch_id);
        }

        $model = $model->where('u.is_delete', '=', 0)
            ->where('pay_status', '=', 20);

        if ($type == 'user_total') {
            // 订单数量
            return $model->count();
        } else if ($type == 'total_price') {
            // 订单总金额
            return $model->sum('pay_price');
        }
        return 0;
    }

    //判断用户是否报名
    public static function isReg($user_id, $activity_id)
    {
        return !!(new static())->where('user_id', '=', $user_id)
            ->where('status', '=', 1)
            ->where('user_id <> reg_user_id')
            ->where('activity_id', '=', $activity_id)
            ->count();
    }

    //判断帮报的用户是否报名
    public static function isRegByFriend($mobile, $activity_id)
    {
        return !!(new static())->where('mobile', '=', $mobile)
            ->where('status', '=', 1)
            ->where('is_friend', '=', 1)
            ->where('activity_id', '=', $activity_id)
            ->count();
    }

    //判断用户是否签到
    public static function isVerify($user_id, $activity_id)
    {
        return !!(new static())->where('user_id', '=', $user_id)
            ->where('is_verify', '=', 1)
            ->where('activity_id', '=', $activity_id)
            ->count();
    }

    /**
     * 获取某天的总报名费
     * 结束时间不传则查一天
     */
    public function getTotalPrice($startDate = null, $endDate = null, $branch_id)
    {
        $model = $this->alias('u')
                ->join('branch_member', 'u.user_id = branch_member.user_id', 'left');

        !is_null($startDate) && $model = $model->where('pay_time', '>=', strtotime($startDate));

        if (is_null($endDate)) {
            !is_null($startDate) && $model = $model->where('pay_time', '<', strtotime($startDate) + 86400);
        } else {
            $model = $model->where('pay_time', '<', strtotime($endDate) + 86400);
        }

        return $model->where('pay_status', '=', 20)
            ->where('branch_member.branch_id', '=', $branch_id)
            ->where('u.is_delete', '=', 0)
            ->sum('pay_price');
    }

    /**
     * 会员排行榜（报名活跃度）
     */
    public function getUserRankList($date, $branch_id, $limit = 7)
    {
        return $this->alias('A')
            ->join('branch_member B', 'A.user_id=B.user_id')
            ->join('user C', 'C.user_id=A.user_id')
            ->field('count(A.order_id) as total,C.nickName,C.avatarUrl,A.*')
            ->when($date, function ($query, $date) {
                getModelTime($query, $date, 'A.create_time');
            })
            ->where('B.branch_id', '=', $branch_id)
            ->where('A.is_delete', '=', 0)
            ->group('A.user_id')
            ->order('total DESC')
            ->limit($limit)
            ->select();
    }
}