auth.js

import React from 'react';
import Credentials from "next-auth/providers/credentials";
import NextAuth from 'next-auth';
import mysql from 'mysql2/promise';
import { GetDBSettings } from '@/sharedCode/common';
import { toast } from '@/hooks/use-toast';
import bcrypt from 'bcryptjs'; 

let connectionparams = GetDBSettings();

export const { handlers, signIn, signOut, auth } = NextAuth({
  providers: [
    Credentials({
      credentials: {
        email: { label: "Email", type: "email", placeholder: "Email" },
        password: { label: "Password", type: "password", placeholder: "Password" },
      },
      async authorize(credentials) {
        let currentuser = null;
        const connection = await mysql.createConnection(connectionparams);

        
          const [rows] = await connection.execute(
            'CALL GetUserByEmail(?)',
            [credentials.email])
          
        connection.end();
        

        currentuser = rows[0][0];
        console.log("current user",rows)
        if (!currentuser) {
          console.log("This Email is Already Exists");
          toast({
            title: "You submitted the following values:",
            description: (
              <pre className="mt-2 w-[340px] rounded-md bg-slate-950 p-4 text-white">
                <p> User Credentials Invalid</p>
              </pre>
            ),
          });
          return null;
        }
        const isPasswordValid = await bcrypt.compare(credentials.password, currentuser.password);
        if (!isPasswordValid) {
          console.log("Invalid credentials - Incorrect password");
          toast({
            title: "You submitted the following values:",
            description: (
              <pre className="mt-2 w-[340px] rounded-md bg-slate-950 p-4 text-white">
                <p>Invalid password</p>
              </pre>
            ),
          });
          return null;
        }

        // Return the user object, mapping `userid` to `id`
        console.log("current:    ",currentuser)
        return {
          id: currentuser.userId,
          email: currentuser.email,
          name: currentuser.name,
        };
      }
    })
  ],

  callbacks: {
    async jwt({ token, user }) {
      if (user) {
        token.id = user.id; // Assign the user id (userid)
        token.email = user.email;
        token.name = user.name;
      }
      return token;
    },
    async session({ session, token }) {
      session.user.id = token.id; // Pass the user id (userid) in the session
      session.user.email = token.email;
      session.user.name = token.name;
      return session;
    }
  },

  pages: {
    signIn: '/auth/signin',
  },
});