1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| <?php
|
| namespace app\branch\model\branch;
|
| use app\common\model\branch\Member as BranchMemberModel;
| /**
| * 分会会员模型
| */
| class Member extends BranchMemberModel
| {
| /**
| * 获取分会的会员
| */
| public function getMemberList($branch_id, $params)
| {
| $model = $this->alias('A')
| ->join('user B', 'B.user_id=A.user_id', 'left')
| ->field(['A.user_id,A.branch_id,B.avatarUrl,B.nickName,B.real_name,B.mobile,B.create_time']);
| if (isset($params['search']) && $params['search'] != '') {
| $model = $model->where('B.nickName|B.mobile,B.real_name', 'like', '%' . trim($params['search']) . '%');
| }
| return $model->where('A.branch_id', '=', $branch_id)->where('A.is_delete', '=', 0)
| ->paginate($params);
| }
| }
|
|
