wenbao-website/server/api/article/recommend.ts

import { defineEventHandler, EventHandlerRequest } from 'h3';
import { DB } from '~~/server/db/DB';
import { createErrorResponse, createSuccessResponse, IResponse } from '~~/server/utils/response';
import { CommonPageResult } from '~~/server/db/CommonModel';
import type { IArticle } from './[id]';

export default defineEventHandler<EventHandlerRequest, Promise<IResponse<IArticle[]>>>(async (event) => {
  try {  
    const query = getQuery(event);
    const pageSize = query.pageSize as string;

     // 从pr_cms_archives表中查询flag包含recommend的文章
    // 先按weigh降序排序，再按publishtime降序排序
    const articles = await DB.table('pr_cms_archives')
        .where('status', 'normal')
        .where('flag', 'like', '%recommend%')
        .orderBy('weigh','desc')
        .orderBy('publishtime','desc')
        .orderBy('createtime','desc')
        .limit(0, Number(pageSize))
        .get();

    return createSuccessResponse(articles);
  } catch (error) {
    return createErrorResponse(error);
  }
});