nextcloud /
circles
| @@ 79-93 (lines=15) @@ | ||
| 76 | /** |
|
| 77 | * @return IQueryBuilder |
|
| 78 | */ |
|
| 79 | protected function getMembersSelectSql() { |
|
| 80 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 81 | ||
| 82 | /** @noinspection PhpMethodParametersCountMismatchInspection */ |
|
| 83 | $qb->select( |
|
| 84 | 'm.user_id', 'm.instance', 'm.user_type', 'm.circle_id', 'm.level', 'm.status', 'm.note', |
|
| 85 | 'm.contact_id', 'm.member_id', 'm.cached_name', 'm.cached_update', 'm.contact_meta', 'm.joined' |
|
| 86 | ) |
|
| 87 | ->from(self::TABLE_MEMBERS, 'm') |
|
| 88 | ->orderBy('m.joined'); |
|
| 89 | ||
| 90 | $this->default_select_alias = 'm'; |
|
| 91 | ||
| 92 | return $qb; |
|
| 93 | } |
|
| 94 | ||
| 95 | ||
| 96 | /** |
|
| @@ 74-86 (lines=13) @@ | ||
| 71 | /** |
|
| 72 | * @return CoreQueryBuilder |
|
| 73 | */ |
|
| 74 | protected function getMemberSelectSql(): CoreQueryBuilder { |
|
| 75 | $qb = $this->getQueryBuilder(); |
|
| 76 | $qb->select( |
|
| 77 | 'm.circle_id', 'm.member_id', 'm.single_id', 'm.user_id', 'm.instance', 'm.user_type', 'm.level', 'm.status', |
|
| 78 | 'm.note', 'm.contact_id', 'm.cached_name', 'm.cached_update', 'm.contact_meta', |
|
| 79 | 'm.joined' |
|
| 80 | ) |
|
| 81 | ->from(self::TABLE_MEMBER, 'm') |
|
| 82 | ->orderBy('m.joined') |
|
| 83 | ->setDefaultSelectAlias('m'); |
|
| 84 | ||
| 85 | return $qb; |
|
| 86 | } |
|
| 87 | ||
| 88 | ||
| 89 | /** |
|
