``` 'use client' import { useState } from 'react'; import { parse } from 'csv-parse'; import { Button } from '@/app/(app)/user/components/button'; interface FileInputEvent extends React.ChangeEvent { target: HTMLInputElement & EventTarget; } interface LoanStatus { studentId: string; name: string; hasActiveLoan: boolean; email: string; } export default function Upload() { const [data, setData] = useState([]); const [loanData, setLoanData] = useState([]); function handleUpload(e: FileInputEvent) { const files = e.target.files; if (!files) return; const file = files[0]; const reader = new FileReader(); reader.onload = () => { const csvString = reader.result as string; parse(csvString, { columns: true, skip_empty_lines: true, }, (err, output) => { if (err) { console.error(err); } else { setData(output); setLoanData(output as LoanStatus[]); } }); }; reader.readAsText(file); } const sendData = async () => { const res = await fetch('/api/file2', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify(loanData), }); const jsonData = await res.json(); console.log(jsonData); } const handleLoanReminder = async () => { const response = await fetch('/api/email', { method: 'POST', }); const jsonData = await response.json(); console.log(jsonData); }; return (

Upload a CSV file

Choose a CSV file

{data.map((row, index) => ( ))}

Firstname	Lastname	Email	National ID	Organisation
{row.firstname}	{row.lastname}	{row.email}	{row.nationalId}	{row.company}

Loan Status

{data ? ( {data.map((status) => ( ))}

Student ID	Has Active Loan
{status.studentId}	{status.hasActiveLoan ? 'Yes' : 'No'}

) : (

No loan status to show.

)}

); } *en* ``` **end point** ``` import { NextApiRequest, NextApiResponse } from 'next'; import { PrismaClient } from '@prisma/client'; interface LoanStatus { studentId: number; name: string; nationalId: string; email: string; hasActiveLoan: boolean; message: string; } interface NextApiRequestWithFiles extends NextApiRequest { body: { data: { nationalId: string; }[]; }; } export default async function handler(req: NextApiRequestWithFiles, res: NextApiResponse) { if (req.method !== 'POST') { res.setHeader('Allow', ['POST']); res.status(405).end(`Method ${req.method} Not Allowed`); return; } const { data } = req.body || {}; if (!data) { res.status(400).json([{ studentId: 0, name: '', nationalId: '', email: '', hasActiveLoan: false, message: 'No data provided', }]) return; } const prisma = new PrismaClient(); const studentIds: number[] = []; const loanStatus: LoanStatus[] = []; for (const row of data) { const student = await prisma.student.findFirst({ where: { nationalId: row.nationalId, }, }); if (student) { studentIds.push(student.id); } } const loans = await prisma.loan.findMany({ where: { studentId: { in: studentIds }, status: 'active', }, include: { student: true, }, }); for (const studentId of studentIds) { const student = await prisma.student.findUnique({ where: { id: studentId }, }); if (student) { const hasActiveLoan = loans.some( (loan) => loan.studentId === studentId ); loanStatus.push({ studentId, name: student.username ?? '', nationalId: student.nationalId ?? '', email: student.email ?? '', hasActiveLoan, message: '', }); } } await prisma.$disconnect(); res.status(200).json(loanStatus); } ```

martnta

i have this next 13 page and endpoint and getting a 405 error

Join Our Newsletter. No Spam, Only the good stuff.