import { NextResponse } from "next/server";
import { connectToDb } from '@/utils/db'
import { redirect } from 'next/navigation'
const bcrypt = require('bcrypt')

export async function POST(req: Request): Promise<NextResponse> {
    console.log('eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee')
    const res = await req.formData()
    let enrno: string = String(res.get("enrno"));
    let password: string = String(res.get("password"));
    let con = connectToDb("rcampus")
    let _status = 0
    con.connect((err: any) => {
        if (err) throw err;

        var sql = "SELECT * FROM users WHERE enrno=? ";
        con.query(sql, [enrno], (err: any, result: any) => {
            if (err) {
                console.error("Error executing query:", err);
            } else {
                if (bcrypt.compare(password, result[0]['password'])) {
                    console.log("in"+_status)
                    _status = 200
                } else {
                    _status = 403
                }
            }
        });
    });
    console.log(_status)
    return NextResponse.json({
        message: "Incorrect enrollment number or password" //this message will only be used if the status is 403
    }, {
        status: _status,
    })
}