44 lines
2.0 KiB
JavaScript
44 lines
2.0 KiB
JavaScript
import { Followings } from "../../../models/index.js";
|
|
import { Brackets } from "typeorm";
|
|
import { generateMinorBadgeNoteVisibilityQuery } from "./generate-minor-badge-visibility-query.js";
|
|
export function generateVisibilityQuery(q, me, options) {
|
|
// This code must always be synchronized with the checks in Notes.isVisibleForMe.
|
|
if (me == null) {
|
|
q.andWhere(new Brackets((qb)=>{
|
|
qb.where(`note.visibility = 'public'`).orWhere(`note.visibility = 'home'`);
|
|
})).andWhere('note.localOnly = FALSE');
|
|
} else {
|
|
const followingQuery = Followings.createQueryBuilder("following").select("following.followeeId").where("following.followerId = :meId");
|
|
q.andWhere(new Brackets((qb)=>{
|
|
qb// 公開投稿である
|
|
.where(new Brackets((qb)=>{
|
|
qb.where(`note.visibility = 'public'`).orWhere(`note.visibility = 'home'`);
|
|
}))// または 自分自身
|
|
.orWhere("note.userId = :meId")// または 自分宛て
|
|
.orWhere(":meId = ANY(note.visibleUserIds)").orWhere(":meId = ANY(note.mentions)").orWhere(new Brackets((qb)=>{
|
|
qb// または フォロワー宛ての投稿であり、
|
|
.where(`note.visibility = 'followers'`).andWhere(new Brackets((qb)=>{
|
|
qb// 自分がフォロワーである
|
|
.where(`note.userId IN (${followingQuery.getQuery()})`)// または 自分の投稿へのリプライ
|
|
.orWhere("note.replyUserId = :meId");
|
|
}));
|
|
}));
|
|
}));
|
|
q.andWhere(new Brackets((qb)=>{
|
|
qb.where(`note.visibility != 'hidden'`).orWhere(`note.userId = :meId`);
|
|
}));
|
|
q.setParameters({
|
|
meId: me.id
|
|
});
|
|
}
|
|
if (!options?.allowAdservice) {
|
|
q.andWhere(new Brackets((qb)=>{
|
|
qb.where(`NOT ('adservice' = ANY(note.tags))`);
|
|
if (me) {
|
|
qb.orWhere("note.userId = :meId");
|
|
}
|
|
}));
|
|
}
|
|
generateMinorBadgeNoteVisibilityQuery(q, me);
|
|
}
|