summaryrefslogtreecommitdiff
path: root/src/server/api/common/generate-muted-user-query.ts
diff options
context:
space:
mode:
authorsyuilo <syuilotan@yahoo.co.jp>2020-07-28 09:38:41 +0900
committersyuilo <syuilotan@yahoo.co.jp>2020-07-28 09:38:41 +0900
commit1b9d316e7c2446211f4b5b6ec27dce0d9b4f0968 (patch)
treeb5f3a09e8c7649b19d9d1394f32a65fa432f92f5 /src/server/api/common/generate-muted-user-query.ts
parentrefactor: Rename function (diff)
downloadmisskey-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.ts40
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());
+}