'use server' import type { MediaListParams, MediaListResult } from '@admin/types' import { clampMediaPage } from '@admin/actions/media/clamp-media-page' import { clampMediaPageSize } from '@admin/actions/media/clamp-media-page-size' import { mediaCacheTags } from '@admin/actions/media/types' import db from '@admin/db' import { adminMedia } from '@admin/db/schema' import { mapMediaRow } from '@admin/utils/media/map-media-row' import { selectMedia } from '@admin/utils/media/select-media' import { and, desc, ilike, sql } from 'drizzle-orm' import { cacheLife, cacheTag } from 'next/cache' type GetMediaParams = MediaListParams type GetMediaResult = MediaListResult export async function getMedia(params: GetMediaParams = {}) { 'use cache' cacheLife('max') cacheTag(mediaCacheTags.all) const { search, contentType } = params const page = clampMediaPage(params.page) const pageSize = clampMediaPageSize(params.pageSize) const offset = (page - 1) * pageSize const conditions = [] if (search) { conditions.push(ilike(adminMedia.filename, `%${search}%`)) } if (contentType) { conditions.push(ilike(adminMedia.contentType, `${contentType}%`)) } const where = conditions.length > 0 ? and(...conditions) : undefined const itemsQuery = selectMedia() .where(where) .orderBy(desc(adminMedia.createdAt)) .limit(pageSize) .offset(offset) const [items, countResult] = await Promise.all([ itemsQuery, db .select({ count: sql`count(*)` }) .from(adminMedia) .where(where) ]) const result: GetMediaResult = { media: items.map(mapMediaRow), total: Number(countResult[0]?.count ?? 0), page, pageSize } return result }