diff options
| author | syuilo <syuilotan@yahoo.co.jp> | 2020-07-28 09:38:41 +0900 |
|---|---|---|
| committer | syuilo <syuilotan@yahoo.co.jp> | 2020-07-28 09:38:41 +0900 |
| commit | 1b9d316e7c2446211f4b5b6ec27dce0d9b4f0968 (patch) | |
| tree | b5f3a09e8c7649b19d9d1394f32a65fa432f92f5 /src/server/api/common/generate-muted-user-query.ts | |
| parent | refactor: Rename function (diff) | |
| download | misskey-1b9d316e7c2446211f4b5b6ec27dce0d9b4f0968.tar.gz misskey-1b9d316e7c2446211f4b5b6ec27dce0d9b4f0968.tar.bz2 misskey-1b9d316e7c2446211f4b5b6ec27dce0d9b4f0968.zip | |
refactor: Rename function
Diffstat (limited to 'src/server/api/common/generate-muted-user-query.ts')
| -rw-r--r-- | src/server/api/common/generate-muted-user-query.ts | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/src/server/api/common/generate-muted-user-query.ts b/src/server/api/common/generate-muted-user-query.ts new file mode 100644 index 0000000000..b346f2f0fb --- /dev/null +++ b/src/server/api/common/generate-muted-user-query.ts @@ -0,0 +1,40 @@ +import { User } from '../../../models/entities/user'; +import { Mutings } from '../../../models'; +import { SelectQueryBuilder, Brackets } from 'typeorm'; + +export function generateMutedUserQuery(q: SelectQueryBuilder<any>, me: User, exclude?: User) { + const mutingQuery = Mutings.createQueryBuilder('muting') + .select('muting.muteeId') + .where('muting.muterId = :muterId', { muterId: me.id }); + + if (exclude) { + mutingQuery.andWhere('muting.muteeId != :excludeId', { excludeId: exclude.id }); + } + + // 投稿の作者をミュートしていない かつ + // 投稿の返信先の作者をミュートしていない かつ + // 投稿の引用元の作者をミュートしていない + q + .andWhere(`note.userId NOT IN (${ mutingQuery.getQuery() })`) + .andWhere(new Brackets(qb => { qb + .where(`note.replyUserId IS NULL`) + .orWhere(`note.replyUserId NOT IN (${ mutingQuery.getQuery() })`); + })) + .andWhere(new Brackets(qb => { qb + .where(`note.renoteUserId IS NULL`) + .orWhere(`note.renoteUserId NOT IN (${ mutingQuery.getQuery() })`); + })); + + q.setParameters(mutingQuery.getParameters()); +} + +export function generateMutedUserQueryForUsers(q: SelectQueryBuilder<any>, me: User) { + const mutingQuery = Mutings.createQueryBuilder('muting') + .select('muting.muteeId') + .where('muting.muterId = :muterId', { muterId: me.id }); + + q + .andWhere(`user.id NOT IN (${ mutingQuery.getQuery() })`); + + q.setParameters(mutingQuery.getParameters()); +} |