djalim
9a4c6863d1
- Add stages module with full CRUD API and admin overview island - Add mobility overview island (Liste, Kanban, Detail CRUD views) - Add contract PDF upload/download endpoints for mobilites - Add light/dark theme toggle in header - Add employeeOnly flag to hide entire modules from students (admin, students, stages) - Add read-only GET endpoints for modules/ues/ue-modules in notes module - Add [slug].tsx catch-all routes for direct URL navigation - Replace old mobility table with mobilites + stages schema (migration 0004) - Allow students to create mobilites and upload contracts - Redirect authenticated users from / to /apps catalog
29 lines
890 B
TypeScript
29 lines
890 B
TypeScript
import { Handlers } from "$fresh/server.ts";
|
|
import { db } from "$root/databases/db.ts";
|
|
import { ueModules } from "$root/databases/schema.ts";
|
|
import { and, eq } from "npm:drizzle-orm@0.45.2";
|
|
|
|
export const handler: Handlers = {
|
|
async GET(request) {
|
|
const url = new URL(request.url);
|
|
const idPromo = url.searchParams.get("idPromo");
|
|
const idUEParam = url.searchParams.get("idUE");
|
|
const idUE = idUEParam ? parseInt(idUEParam) : null;
|
|
|
|
if (idUEParam && isNaN(idUE!)) {
|
|
return new Response("Paramètre idUE invalide", { status: 400 });
|
|
}
|
|
|
|
const rows = await db.select().from(ueModules).where(
|
|
and(
|
|
idPromo ? eq(ueModules.idPromo, idPromo) : undefined,
|
|
idUE ? eq(ueModules.idUE, idUE) : undefined,
|
|
),
|
|
);
|
|
|
|
return new Response(JSON.stringify(rows), {
|
|
headers: { "content-type": "application/json" },
|
|
});
|
|
},
|
|
};
|