<?php

namespace app\common\model\branch;

use app\common\model\BaseModel;
use app\common\model\user\User as UserModel;
use app\common\model\branch\Branch as BranchModel;

/**
 * 连盟成员模型
 */
class Member extends BaseModel
{
    protected $name = 'branch_member';
    protected $pk = 'user_id';
	
	/**
	 * 关联所属分会表
	 */
	public function branch()
	{
	    return $this->belongsTo('app\\common\\model\\branch\\Branch', 'branch_id', 'branch_id');
	}

    /**
	 * 关联所属分会表
	 */
	public function supplier()
	{
	    return $this->belongsTo('app\\common\\model\\supplier\\Supplier', 'shop_supplier_id', 'shop_supplier_id');
	}
	
    /**
     * 关联会员记录表
     * @return \think\model\relation\BelongsTo
     */
    public function user()
    {
        return $this->belongsTo('app\\common\\model\\user\\User');
    }

    /**
     * 详情
     */
    public static function detail($user_id, $with = ['user'])
    {
        return (new static())->with($with)->find($user_id);
    }

    /**
     * 是否已经是分会成员
     */
    public static function isMember($user_id)
    {
        $member = self::detail($user_id);
        return !!$member && !$member['is_delete'];
    }

    /**
     * 统计成员数量
     */
    public static function memberCount($branch_id = 0)
    {
        $model = new static();
        if($branch_id > 0) {
            $model->where('branch_id', '=', $branch_id);
        }
        return $model->where('is_delete', '=', 0)
        ->count();
    }

    /**
     * 新增记录
     */
    public function add($data)
    {
        $data['app_id'] = self::$app_id;
        $this->save($data);
        // 更新分会人数
        BranchModel::incTotal($data['branch_id']);
        // 检查真实姓名和电话有没有更改
        $user = UserModel::detail($data['user_id']);
        $userData = [];
        if ($user['real_name'] != $data['real_name']) {
            $userData['real_name'] = $data['real_name'];
        }
        if ($user['mobile'] != $data['mobile']) {
            $userData['mobile'] = $data['mobile'];
        }
        if ($userData) {
            $user->save($userData);
        }
        return true;
    }

    /**
     * 获取会员数据 (可指定某天)
     */
    public function getMemberTotal($startDate = null, $endDate = null, $branch_id = 0)
    {
        $model = $this;

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

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

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

        $model = $model->where('is_delete', '=', 0);
        return $model->count();
    }

    public function memberGroupNum($date, $branch_id)
    {
        $field = 'count(*) as total,from_unixtime(create_time,\'%m-%d\') as `day`';
        if ($date == 'year') {
            $field = 'count(*) as total,from_unixtime(create_time,\'%m\') as `day`';
        }
        $model = $this->field($field)
            ->where('is_delete', '=', 0)
            ->when($date, function ($query, $date) {
                getModelTime($query, $date, 'create_time');
            })->when($branch_id, function ($query, $branch_id) {
                $query->where('branch_id', $branch_id);
            });
        return $model->order('create_time ASC')->group('day')->select();
    }

}