<?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();
|
}
|
|
}
|
