Files
2026-07-26 18:25:37 +09:00

148 lines
5.2 KiB
JavaScript

import { Brackets } from "typeorm";
import { Notes } from "../../../../models/index.js";
import { activeUsersChart } from "../../../../services/chart/index.js";
import define from "../../define.js";
import { makePaginationQuery } from "../../common/make-pagination-query.js";
import { generateVisibilityQuery } from "../../common/generate-visibility-query.js";
import { generateMutedUserQuery } from "../../common/generate-muted-user-query.js";
import { generateRepliesQuery } from "../../common/generate-replies-query.js";
import { generateChannelQuery } from "../../common/generate-channel-query.js";
import { generateBlockedUserQuery } from "../../common/generate-block-query.js";
import { generateMutedUserRenotesQueryForNotes } from "../../common/generated-muted-renote-query.js";
import { ApiError } from "../../error.js";
import { generateListQuery } from "../../common/generate-list-query.js";
import { generateFollowingQuery } from "../../common/generate-following-query.js";
import { generateExcludeMemorietQuery } from "../../common/generate-exclude-memoriet-query.js";
import { injectPromo } from "../../common/inject-promo.js";
export const meta = {
tags: [
"notes"
],
requireCredential: true,
res: {
type: "array",
optional: false,
nullable: false,
items: {
type: "object",
optional: false,
nullable: false,
ref: "Note"
}
},
errors: {
queryError: {
message: "Please follow more users.",
code: "QUERY_ERROR",
id: "620763f4-f621-4533-ab33-0577a1a3c343"
}
}
};
export const paramDef = {
type: "object",
properties: {
limit: {
type: "integer",
minimum: 1,
maximum: 100,
default: 10
},
sinceId: {
type: "string",
format: "misskey:id"
},
untilId: {
type: "string",
format: "misskey:id"
},
sinceDate: {
type: "integer"
},
untilDate: {
type: "integer"
},
includeMyRenotes: {
type: "boolean",
default: true
},
includeRenotedMyNotes: {
type: "boolean",
default: true
},
includeLocalRenotes: {
type: "boolean",
default: true
},
withFiles: {
type: "boolean",
default: false,
description: "Only show notes that have attached files."
},
withReplies: {
type: "boolean",
default: false,
description: "Show replies in the timeline"
}
},
required: []
};
export default define(meta, paramDef, async (ps, user)=>{
//#region Construct query
const query = makePaginationQuery(Notes.createQueryBuilder("note"), ps.sinceId, ps.untilId, ps.sinceDate, ps.untilDate).innerJoinAndSelect("note.user", "user").leftJoinAndSelect("note.reply", "reply").leftJoinAndSelect("note.renote", "renote").leftJoinAndSelect("reply.user", "replyUser").leftJoinAndSelect("renote.user", "renoteUser");
await generateFollowingQuery(query, user);
generateListQuery(query, user);
generateChannelQuery(query, user);
generateRepliesQuery(query, ps.withReplies, user);
generateVisibilityQuery(query, user);
generateMutedUserQuery(query, user);
generateBlockedUserQuery(query, user);
generateMutedUserRenotesQueryForNotes(query, user);
generateExcludeMemorietQuery(query);
if (ps.includeMyRenotes === false) {
query.andWhere(new Brackets((qb)=>{
qb.orWhere("note.userId != :meId", {
meId: user.id
});
qb.orWhere("note.renoteId IS NULL");
qb.orWhere("note.text IS NOT NULL");
qb.orWhere("note.fileIds != '{}'");
qb.orWhere('0 < (SELECT COUNT(*) FROM poll WHERE poll."noteId" = note.id)');
}));
}
if (ps.includeRenotedMyNotes === false) {
query.andWhere(new Brackets((qb)=>{
qb.orWhere("note.renoteUserId != :meId", {
meId: user.id
});
qb.orWhere("note.renoteId IS NULL");
qb.orWhere("note.text IS NOT NULL");
qb.orWhere("note.fileIds != '{}'");
qb.orWhere('0 < (SELECT COUNT(*) FROM poll WHERE poll."noteId" = note.id)');
}));
}
if (ps.includeLocalRenotes === false) {
query.andWhere(new Brackets((qb)=>{
qb.orWhere("note.renoteUserHost IS NOT NULL");
qb.orWhere("note.renoteId IS NULL");
qb.orWhere("note.text IS NOT NULL");
qb.orWhere("note.fileIds != '{}'");
qb.orWhere('0 < (SELECT COUNT(*) FROM poll WHERE poll."noteId" = note.id)');
}));
}
if (ps.withFiles) {
query.andWhere("note.fileIds != '{}'");
}
query.andWhere("note.visibility != 'hidden'");
//#endregion
process.nextTick(()=>{
activeUsersChart.read(user);
});
try {
const notes = await query.take(ps.limit).getMany();
await injectPromo(notes, user);
return await Notes.packMany(notes, user);
} catch (error) {
throw new ApiError(meta.errors.queryError);
}
});