import { Brackets } from "typeorm"; import { fetchMeta } from "../../../../misc/fetch-meta.js"; import { Followings, Notes } from "../../../../models/index.js"; import { activeUsersChart } from "../../../../services/chart/index.js"; import define from "../../define.js"; import { ApiError } from "../../error.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 { generateListQuery } from "../../common/generate-list-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: { stlDisabled: { message: "Hybrid timeline has been disabled.", code: "STL_DISABLED", id: "620763f4-f621-4533-ab33-0577a1a3c342" }, 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)=>{ const m = await fetchMeta(); if (m.disableLocalTimeline && !user.isAdmin && !user.isModerator) { throw new ApiError(meta.errors.stlDisabled); } //#region Construct query const followingQuery = Followings.createQueryBuilder("following").select("following.followeeId").where("following.followerId = :followerId", { followerId: user.id }); const query = makePaginationQuery(Notes.createQueryBuilder("note"), ps.sinceId, ps.untilId, ps.sinceDate, ps.untilDate).andWhere(new Brackets((qb)=>{ qb.where(`((note.userId IN (${followingQuery.getQuery()})) OR (note.userId = :meId))`, { meId: user.id }).orWhere("(note.visibility = 'public') AND (note.userHost IS NULL)"); })).innerJoinAndSelect("note.user", "user").leftJoinAndSelect("note.reply", "reply").leftJoinAndSelect("note.renote", "renote").leftJoinAndSelect("reply.user", "replyUser").leftJoinAndSelect("renote.user", "renoteUser").setParameters(followingQuery.getParameters()); 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); } });