wenbao-website/server/api/ecms/carousel.ts

import { defineEventHandler, EventHandlerRequest } from 'h3';
import { DB } from '~~/server/db/DB';
import { createErrorResponse, createSuccessResponse, IResponse } from '~~/server/utils/response';

export interface ICarousel {
  id: number;
  name: string;
  status: string;
  type: string;
  title: string;
  image: string;
  url: string;
  weigh: number;
  content: string;
}

export default defineEventHandler<EventHandlerRequest, Promise<IResponse<ICarousel[]>>>(async (event) => {
  try {
    const query = getQuery(event);
    const name = query.name as string || 'banner';
    return createSuccessResponse(await DB.table('pr_cms_block')
            .where('name', name)
            .where('status', 'normal')
            .orderBy('weigh', 'desc')
            .get());
  } catch (error) {
    return createErrorResponse(error);
  }
});