Main.py

from customtkinter import *
from CTkMessagebox import CTkMessagebox
import tkinter as tk
from tkinter import ttk
from time import strftime
from PIL import Image, ImageTk, ImageSequence
import sqlite3
import os
import hashlib
import random


root = CTk()

root.title("Library Management System")
root.wm_state("zoomed")
set_appearance_mode('dark')
root.geometry(f"{1920}x{1080}")
icon = os.getcwd()+'\\Items\\Icon.ico'
root.iconbitmap(icon)

books_txt = 'booksdata2.txt'

student_detail = "studentdetail"
admin_detail = 'admindetail'
books_detail = 'booksdetail'
book_issue_detail = 'bookissuedetail'

admin_filter_allbooks = False
admin_more_allbooks = False

pfp_dir = os.getcwd()+'\\pfp\\'
admpfp_dir  = os.getcwd()+'\\admpfp\\'
about_dir = os.getcwd()+'\\Items\\about.txt'

# Creating Directory for database
path = os.environ["userprofile"]
try:
    os.mkdir(path+"\\Documents\\Library Database")
except FileExistsError:
    pass

con = sqlite3.connect(path+"\\Documents\\Library Database\mydatabase.db")
cur = con.cursor()

###### >>>>>   Creating Tables
# con.execute("DROP TABLE IF EXISTS admindetail")   # Drop the existing table if it exists
# con.execute("DROP TABLE IF EXISTS studentdetail")   # Drop the existing table if it exists
# con.execute("DROP TABLE IF EXISTS booksdetail")   # Drop the existing table if it exists
# con.execute("DROP TABLE IF EXISTS bookissuedetail")   # Drop the existing table if it exists

# admin details
con.execute("""CREATE TABLE IF NOT EXISTS admindetail
            (admname varchar(30) PRIMARY KEY, 
            password varchar(30),
            email varchar(60),
            pfp varchar(10));""")

# student details
con.execute("""CREATE TABLE IF NOT EXISTS studentdetail 
            (username varchar(30) PRIMARY KEY, 
            password varchar(30),
            class varchar(3),
            email varchar(60),
            pfp varchar(10));""")

# books details
con.execute("""CREATE TABLE IF NOT EXISTS booksdetail
            (bid varchar(20) PRIMARY KEY, 
            title varchar(30), 
            subject varchar(30), 
            author varchar(30), 
            status varchar(30) NOT NULL DEFAULT 'Available');""")

# borrow details
con.execute("""CREATE TABLE IF NOT EXISTS bookissuedetail 
            (bid varchar(20),
            username varchar(20),
            PRIMARY KEY (bid, username),
            FOREIGN KEY (bid) REFERENCES booksdetail(bid),
            FOREIGN KEY (username) REFERENCES studentdetail(username));""")

# Open and read the CSV file
current_dir = os.getcwd()+'\\Items\\'
with open(current_dir + books_txt, 'r') as file:
    data = [tuple(line.strip().split(',')) for line in file]

# Insert data into the SQLite table
cur.executemany('INSERT OR IGNORE INTO booksdetail VALUES (?, ?, ?, ?, ?)', data)
con.commit()


#######    Some Functions    ############
def hash_password(password):
    # Hash the password before storing it
    return hashlib.sha256(password.encode()).hexdigest()

def empty_entry_student(event):
    if entry_student_rusername.get().strip()!="" and entry_student_rpassword1.get().strip()!="" and entry_student_rpassword2.get().strip()!="" and entry_student_remail.get().strip()!="":
        button_student_register.configure(state='normal')
    else:
        button_student_register.configure(state='disabled')

def empty_entry_admin(event):
    if entry_admin_rusername.get().strip()!="" and entry_admin_rpassword1.get().strip()!="" and entry_admin_rpassword2.get().strip()!="" and entry_admin_remail.get().strip()!="":
        button_admin_register.configure(state='normal')
    else:
        button_admin_register.configure(state='disabled')

def email_check_student(event):
    check = entry_student_remail.get()
    if '@gmail.com'in check or'@mail.com'in check or'@outlook.com'in check or'@yahoo.com'in check or'@icloud.com'in check or'@fastmail.com'in check:
        entry_student_remail.configure(border_color='#3f60fc')
        label_error_student.configure(text='Valid Email',text_color='#26c115')
    else:
        entry_student_remail.configure(border_color='#f8182f')
        label_error_student.configure(text='Invalid Email',text_color='#f8182f')

def email_check_admin(event):
    check = entry_admin_remail.get()
    if '@gmail.com'in check or'@mail.com'in check or'@outlook.com'in check or'@yahoo.com'in check or'@icloud.com'in check or'@fastmail.com'in check:
        entry_admin_remail.configure(border_color='#f8182f')
        label_error_admin.configure(text='Valid Email',text_color='#26c115')
    else:
        entry_admin_remail.configure(border_color='#3f60fc')
        label_error_admin.configure(text='Invalid Email',text_color='#f8182f')

def pass_switch(to_switch, entry_password):
    on_off = to_switch.get()
    if on_off == 1:
        entry_password.configure(show='')
    elif on_off == 0:
        entry_password.configure(show='*')

def update_daydatetime():
    current_time = strftime('%H:%M:%S %p')
    timelabel.configure(text=current_time)
    current_day = strftime('%A')
    daylabel.configure(text=current_day)
    current_date = strftime('%B %d, %Y')
    datelabel.configure(text=current_date)
    timelabel.after(1000, update_daydatetime)  # Update every 1000 milliseconds (1 second)

def get_treeview_length(treeview):
    count = 0
    # Iterate through all items in the treeview
    for _ in treeview.get_children():
        count += 1
    return count

def help_button():
    CTkMessagebox(title='Help', message="Input this ID : \nLib2024", icon='info', option_1='NO Thanks', option_2='Thanks',
        border_color='#e40b0b', button_color='#f50f0f', button_hover_color='#ff3737',font=('calibri',16,))

def about():
    global toplevel_window
    try:
        toplevel_window.destroy()
    except:
        pass

    toplevel_window = CTkToplevel(root)
    toplevel_window.title('About')
    toplevel_window.geometry(f"{650}x{550}")
    
    textbox = CTkTextbox(toplevel_window, wrap='none', font=('Courier New',12,'bold'), )
    textbox.pack(expand=True, fill="both")
    
    with open(about_dir, "r") as file:
        about_text = file.read()
        textbox.insert("1.0", about_text)
        textbox.configure(state="disabled")


#############   Register and Login functions for Student and Admin   #########
#  >> Student
def student_register():
    # Getting details
    username = entry_student_rusername.get()
    userpassword = hash_password(entry_student_rpassword1.get())
    userclass = entry_student_class.get()
    useremail = entry_student_remail.get()
    
    pfp_files = [f for f in os.listdir(pfp_dir) if f.endswith('.jpg') or f.endswith('.png')]
    selected_pfp = random.choice(pfp_files)

    sql = f"INSERT INTO {student_detail} VALUES (?, ?, ?, ?, ?)"
    data = (username, userpassword, userclass, useremail, selected_pfp)
    try:
        cur.execute(sql, data)
        con.commit()
        CTkMessagebox(title="Success", message="Successfully registered", icon='check', option_1='Thanks')

        entry_student_rusername.delete(0, END)
        entry_student_rpassword1.delete(0, END)
        entry_student_rpassword2.delete(0, END)
        entry_student_class.delete(0, END)
        entry_student_remail.delete(0, END)
    except sqlite3.Error as e:
        CTkMessagebox(title="Error inserting", message=f"Cannot add data to Database \nError: {e}", icon='cancel', option_1='Okay')

    # Print the SQL statement used for table creation
    # cur.execute("SELECT sql FROM sqlite_master WHERE type='table' AND name='studentdetail'")
    # print(cur.fetchone()[0])

def student_login():
    global username
    # Getting details
    username = entry_student_lusername.get()
    userpassword = hash_password(entry_student_lpassword.get())
    sql_usesrname = f"SELECT username FROM {student_detail} WHERE username = ?"
    sqlLoginInfo = f"SELECT password FROM {student_detail} WHERE username = ?"
    try:
        cur.execute(sql_usesrname, (username,))
        user = cur.fetchone()
        if user:
            cur.execute(sqlLoginInfo, (username,))
            # Fetch the first result
            result = cur.fetchone()

            if result and result[0] == userpassword:
                # CTkMessagebox(title="Done", message="Student Logged In!", icon='check', option_1='Nice!')
                student_main_win(username)
            else:
                CTkMessagebox(title="WRONG PASSWORD", message="What? You can't even remember \nyour own ID or password?", icon='warning', option_1='I will try again')
        else:
            CTkMessagebox(title='No User', message=f"NO User with Username '{username}'\nfound in our Database...", icon='cancel', option_1='Okay')
    except sqlite3.Error as e:
        CTkMessagebox(title="FAILED", message=f"Error: {e}", icon='cancel', option_1='Okay')

#  >> Admin
def admin_register():
    # Getting details
    adminname = entry_admin_rusername.get()
    adminpassword = hash_password(entry_admin_rpassword1.get())
    adminemail = entry_admin_remail.get()
    lib_id = entry_lib_id.get()
    if lib_id == 'Lib2024':
        pfp_files = [f for f in os.listdir(admpfp_dir) if f.endswith('.jpg') or f.endswith('.png') or f.endswith('.gif')]
        selected_pfp = random.choice(pfp_files)

        sql = f"INSERT INTO {admin_detail} VALUES (?, ?, ?, ?)"
        data = (adminname, adminpassword, adminemail, selected_pfp)
        try:
            cur.execute(sql, data)
            con.commit()
            CTkMessagebox(title="Success", message="Successfully registered", icon='check', option_1='Thanks')

            entry_admin_rusername.delete(0, END)
            entry_admin_rpassword1.delete(0, END)
            entry_admin_rpassword2.delete(0, END)
            entry_admin_remail.delete(0, END)
        except sqlite3.Error as e:
            CTkMessagebox(title="Error inserting", message=f"Cannot add data to Database \nError: {e}", icon='cancel', option_1='Okay')
    else:
        CTkMessagebox(title="ERROR", message="Library ID is empty or incorrect.", icon='cancel', option_1='Okay',
            border_color='#e40b0b', button_color='#f50f0f', button_hover_color='#ff3737',font=('calibri',16,))

def admin_login():
    global adminname
    # Getting details
    adminname = entry_admin_lusername.get()
    adminpassword = hash_password(entry_admin_lpassword.get())
    sqlLoginInfo = f"SELECT password FROM {admin_detail} WHERE admname = ?"
    sqlpfp = f"SELECT pfp FROM {admin_detail} WHERE admname = ?"
    try:
        cur.execute(sqlLoginInfo, (adminname,))
        result = cur.fetchone()   # Fetch the first result

        if result and result[0] == adminpassword:
            # CTkMessagebox(title="Done", message="Admin Logged In!", icon='check', option_1='Nice!')

            admin_main_win(adminname)

        else:
            CTkMessagebox(title="WRONG PASSWORD", message="What? You can't even remember \nyour own password?", icon='warning', option_1='Okay')
    except sqlite3.Error as e:
        CTkMessagebox(title="FAILED", message=f"Error: {e}", icon='cancel', option_1='Okay')


##############    MAIN  SCREEN    #############
def main_win():
    global button_student, button_admin, main_frame, timelabel, daylabel, datelabel

    button_student = CTkButton(master=root,text='Student',border_width=5,corner_radius=15,border_color='#3333ff',
        fg_color='#3333ff', hover_color='#0000f0',font=('Roboto',22,),command=student_button_click_register)
    button_student.place(relx=0.07,rely=0.3, relwidth=0.1, relheight=0.41)

    main_frame = CTkFrame(root, border_width=5,corner_radius=8,)
    main_frame.place(relx=0.25,rely=0.1,relwidth=0.5,relheight=0.8)

    button_admin = CTkButton(master=root,text='Admin',border_width=5,corner_radius=15,border_color='#ff0000',
        fg_color='#ff3737', hover_color='#d20000',font=('Roboto',22,),command=admin_button_click_login)
    button_admin.place(relx=0.83,rely=0.3, relwidth=0.1, relheight=0.41)
    
    button_about = CTkButton(root, text='?', border_width=1, corner_radius=0, text_color='#000000',
        fg_color='#cecece', hover_color='#e5e5e5', font=('Roboto',22,), command=about)
    button_about.place(relx=0.95, rely=0.93, relwidth=0.03, relheight=0.04)

    datetime_frame = CTkFrame(root, border_width=3, corner_radius=2)
    datetime_frame.place(relx=0.80,rely=0.01, relwidth=0.19, relheight=0.15)

    # Create a timelabel for displaying the time, day and date
    timelabel = CTkLabel(datetime_frame, font=('calibri',40,'bold'))
    timelabel.place(relx=0.01,rely=0.02, relwidth=0.9, relheight=0.38)
    daylabel = CTkLabel(datetime_frame, font=('calibri', 20, 'bold'))
    daylabel.place(relx=0.01, rely=0.40, relwidth=0.9, relheight=0.26)
    datelabel = CTkLabel(datetime_frame, font=('calibri', 20, 'bold'))
    datelabel.place(relx=0.01, rely=0.68, relwidth=0.9, relheight=0.26)

    update_daydatetime()


##### >>>>>   USERS   <<<<< #####
def student_button_click_register():
    global entry_student_rusername, entry_student_rpassword1, entry_student_rpassword2, entry_student_class, entry_student_remail
    global button_student_register, label_error_student, switch_student_rpassword1, switch_student_rpassword2

    button_admin.place(rely=0.3, relheight=0.41)
    button_student.place(rely=0.2, relheight=0.61)

    # Remove all the widgets from the main_frame
    try:
        for widget in main_frame.winfo_children():
            widget.destroy()
    except:
        pass

    # Filler Frame for Login button
    filler_frame = CTkFrame(master=main_frame, border_width=5, fg_color='#3333ff')
    filler_frame.place(relx=0.5, rely=0, relwidth=0.5, relheight=1)

    filler_frame_label = CTkLabel(master=filler_frame, text="Already have an account?",font=('Roboto',26,'bold'))
    filler_frame_label.place(relx=0.05, rely=0.4,)

    button_login = CTkButton(master=filler_frame,text='Login',font=('Roboto',26),border_width=3,corner_radius=15,
    border_color='#ffffff',fg_color='#ffffff',text_color='#3e9eff',hover_color='#d7d7d7',command=student_button_click_login)
    button_login.place(relx=0.3, rely=0.5, relwidth=0.4, relheight=0.1)

    # Register Frame
    label_register = CTkLabel(master=main_frame,text='Register',font=('Roboto',22,))
    label_register.place(relx=0.2, rely=0.05)

    frame_register = CTkFrame(master=main_frame,border_width=4,border_color='#3f60fc')
    frame_register.place(relx=0.02, rely=0.12, relwidth=0.46, relheight=0.84)

    label_username = CTkLabel(master=frame_register,text='Create Username',font=('Roboto',20))
    label_username.place(relx=0.13, rely=0.03)

    entry_student_rusername = CTkEntry(master=frame_register,placeholder_text="    Username",
        border_width=3,corner_radius=10,border_color='#3f60fc',font=('Roboto',15,))
    entry_student_rusername.bind('<KeyRelease>',empty_entry_student)
    entry_student_rusername.place(relx=0.03, rely=0.08, relwidth=0.94, relheight=0.08)

    label_password1 = CTkLabel(master=frame_register,text='Create Password',font=('Roboto',20))
    label_password1.place(relx=0.13, rely=0.19)

    entry_student_rpassword1 = CTkEntry(master=frame_register,placeholder_text="    Password",show='*',
        border_width=3,corner_radius=10,border_color='#3f60fc',font=('Roboto',15,))
    entry_student_rpassword1.bind('<KeyRelease>',empty_entry_student)
    entry_student_rpassword1.place(relx=0.03, rely=0.24, relwidth=0.82, relheight=0.08)

    switch_student_rpassword1 = CTkSwitch(master=frame_register,text='Show',font=('Roboto',12,),switch_height=15,switch_width=30,
        command=lambda:pass_switch(switch_student_rpassword1, entry_student_rpassword1))
    switch_student_rpassword1.place(relx=0.87, rely=0.25, relwidth=0.1, relheight=0.05)

    # label_password2 = CTkLabel(master=frame_register,text='Confirm Password',font=('Roboto',20))
    # label_password2.place(relx=0.13, rely=0.37)

    entry_student_rpassword2 = CTkEntry(master=frame_register,placeholder_text="   Confirm Password",show='*',
        border_width=3,corner_radius=10,border_color='#3f60fc',font=('Roboto',15,))
    entry_student_rpassword2.place(relx=0.03, rely=0.37, relwidth=0.82, relheight=0.08)

    switch_student_rpassword2 = CTkSwitch(master=frame_register,text='Show',font=('Roboto',12,),switch_height=15,switch_width=30,
        command=lambda:pass_switch(switch_student_rpassword2, entry_student_rpassword2))
    switch_student_rpassword2.place(relx=0.87, rely=0.38, relwidth=0.1, relheight=0.05)

    entry_student_class = CTkEntry(frame_register, placeholder_text="    Enter Your Class (Eg: X, Xi, XII)",
        border_width=3,corner_radius=10,border_color='#3f60fc',font=('Roboto',15,),)
    entry_student_class.place(relx=0.03, rely=0.51, relwidth=0.9, relheight=0.08)

    label_email = CTkLabel(master=frame_register,text='Enter Email',font=('Roboto',20))
    label_email.place(relx=0.13, rely=0.61)

    entry_student_remail = CTkEntry(master=frame_register,placeholder_text="    Someone123@gmail.com",
        border_width=3,corner_radius=10,border_color='#3f60fc',font=('Roboto',15,),)
    entry_student_remail.bind('<KeyRelease>',empty_entry_student)
    entry_student_remail.bind('<KeyRelease>',email_check_student)
    entry_student_remail.place(relx=0.03, rely=0.66, relwidth=0.9, relheight=0.08)

    label_error_student = CTkLabel(master=frame_register,text='',font=('Roboto',15))
    label_error_student.place(relx=0.35, rely=0.74)

    button_student_register = CTkButton(master=frame_register,text='Register',border_width=3,corner_radius=15,
        border_color='#3f60fc',command=student_register,state='disabled')
    button_student_register.place(relx=0.35, rely=0.8, relwidth=0.3, relheight=0.1)

def student_button_click_login():
    global entry_student_lusername, entry_student_lpassword

    button_admin.place(rely=0.3, relheight=0.41)
    button_student.place(rely=0.2, relheight=0.61)

    # Remove all the widgets from the main_frame
    try:
        for widget in main_frame.winfo_children():
            widget.destroy()
    except:
        pass

    # Login Frame
    label_login = CTkLabel(master=main_frame,text='Login',font=('Roboto',22,))
    label_login.place(relx=0.7, rely=0.05)

    frame_login = CTkFrame(master=main_frame,border_width=4,border_color='#3f60fc')
    frame_login.place(relx=0.52, rely=0.12, relwidth=0.46, relheight=0.84)

    label_username = CTkLabel(master=frame_login,text='Enter Username',font=('Roboto',20))
    label_username.place(relx=0.13, rely=0.03)

    entry_student_lusername = CTkEntry(master=frame_login,placeholder_text="           Username",
        border_width=3,corner_radius=10,border_color='#3f60fc',font=('Roboto',15,))
    entry_student_lusername.place(relx=0.03, rely=0.08, relwidth=0.94, relheight=0.08)

    label_password = CTkLabel(master=frame_login,text='Enter Password',font=('Roboto',20))
    label_password.place(relx=0.13, rely=0.19)

    entry_student_lpassword = CTkEntry(master=frame_login,placeholder_text="           Password",show='*',
        border_width=3,corner_radius=10,border_color='#3f60fc',font=('Roboto',15,))
    entry_student_lpassword.place(relx=0.03, rely=0.24, relwidth=0.82, relheight=0.08)

    switch_student_lpassword = CTkSwitch(master=frame_login,text='Show',font=('Roboto',12),switch_height=15,switch_width=30,
        command=lambda:pass_switch(switch_student_lpassword, entry_student_lpassword))
    switch_student_lpassword.place(relx=0.87, rely=0.25, relwidth=0.1, relheight=0.05)

    button_student_login = CTkButton(master=frame_login,text='Login',border_width=3,corner_radius=15,border_color='#3f60fc',
        command=student_login)
    button_student_login.place(relx=0.35, rely=0.8, relwidth=0.3, relheight=0.1)
    
    # Filler Frame for Register button
    filler_frame = CTkFrame(master=main_frame, border_width=5, fg_color='#3333ff')
    filler_frame.place(relx=0, rely=0, relwidth=0.5, relheight=1)
    
    filler_frame_label = CTkLabel(master=filler_frame, text="Don't have an account?",font=('Roboto',30,'bold'))
    filler_frame_label.place(relx=0.05, rely=0.4,)

    button_register = CTkButton(master=filler_frame,text='Register',font=('Roboto',24),border_width=3,corner_radius=15,
    border_color='#ffffff',fg_color='#ffffff',text_color='#3e9eff',hover_color='#d7d7d7',command=student_button_click_register)
    button_register.place(relx=0.3, rely=0.5, relwidth=0.4, relheight=0.1)


# >>>> Main Window for Users
def student_main_win(username):
    global main_frame_student_win, profile_button, all_books_button, return_books_button, main_second_frame_student_win

    # Remove all the widgets from the main_win
    try:
        for widget in root.winfo_children():
            widget.destroy()
    except:
        pass
    
    main_frame_student_win = CTkFrame(root, border_width=0, corner_radius=0)
    main_frame_student_win.place(relx=0, rely=0, relwidth=1, relheight=1)
    
    side_frame = CTkFrame(main_frame_student_win, border_width=5,corner_radius=0,)
    side_frame.place(relx=0,rely=0,relwidth=0.15,relheight=1)
    
    profile_button = CTkButton(side_frame,text='Profile',border_width=4,corner_radius=0,border_color='#818181',
        fg_color='#3333ff', hover_color='#0000f0',font=('Roboto',22,),command=student_profile_button_click)
    profile_button.place(relx=0,rely=0, relwidth=1, relheight=0.5)

    all_books_button = CTkButton(side_frame,text='All Books',border_width=4,corner_radius=0,border_color='#818181',
        fg_color='#3333ff', hover_color='#0000f0',font=('Roboto',22,),command=student_all_books_button_click)
    all_books_button.place(relx=0,rely=0.5, relwidth=1, relheight=0.2)

    return_books_button = CTkButton(side_frame,text='Return Books',border_width=4,corner_radius=0,border_color='#818181',
        fg_color='#3333ff', hover_color='#0000f0',font=('Roboto',22,),command=student_return_books_button_click)
    return_books_button.place(relx=0,rely=0.7, relwidth=1, relheight=0.2)
    
    back_button = CTkButton(side_frame,text='Back',border_width=4,corner_radius=0,border_color='#818181',
        fg_color='#3333ff', hover_color='#ff8000',font=('Roboto',22,),command=student_back_button_click)
    back_button.place(relx=0,rely=0.9, relwidth=1, relheight=0.1)

    main_second_frame_student_win = CTkFrame(main_frame_student_win, border_width=0, corner_radius=0)
    main_second_frame_student_win.place(relx=0.15, rely=0, relwidth=0.85, relheight=1)

    student_main_win_profile(username)

#  Side frame button clicks for Users
def student_profile_button_click():
    profile_button.place(relx=0,rely=0, relwidth=1, relheight=0.5)
    all_books_button.place(relx=0,rely=0.5, relwidth=1, relheight=0.2)
    return_books_button.place(relx=0,rely=0.7, relwidth=1, relheight=0.2)
    
    student_main_win_profile(username=username)

def student_all_books_button_click():
    profile_button.place(relx=0,rely=0, relwidth=1, relheight=0.2)
    all_books_button.place(relx=0,rely=0.2, relwidth=1, relheight=0.5)
    return_books_button.place(relx=0,rely=0.7, relwidth=1, relheight=0.2)
    
    student_main_win_allbooks()

def student_return_books_button_click():
    profile_button.place(relx=0,rely=0, relwidth=1, relheight=0.2)
    all_books_button.place(relx=0,rely=0.2, relwidth=1, relheight=0.2)
    return_books_button.place(relx=0,rely=0.4, relwidth=1, relheight=0.5)
    
    student_main_win_return_books()

def student_back_button_click():
    # Remove all the widgets from the main_frame
    try:
        for widget in main_frame_student_win.winfo_children():
            widget.destroy()
    except:
        pass
    
    main_win()


# >>>>>> Profile Window for Users
def student_main_win_profile(username):
    global info_username
     # Remove all the widgets from the main_second_frame_student_win
    try:
        for widget in main_second_frame_student_win.winfo_children():
            widget.destroy()
    except:
        pass
    
    def on_select(event):
        selected_item = tree_student_borrowedbooks.selection()
    
    sql_student_username = f"SELECT username FROM {student_detail} WHERE username = ?"
    cur.execute(sql_student_username, (username,))
    info_username = cur.fetchone()     # Fetch the first result
    info_username = info_username[0]

    sql_student_class = f"SELECT class FROM {student_detail} WHERE username = ?"
    cur.execute(sql_student_class, (username,))
    info_class = cur.fetchone()

    sql_student_email = f"SELECT email FROM {student_detail} WHERE username = ?"
    cur.execute(sql_student_email, (username,))
    info_email = cur.fetchone()

    sql_student_pfp = f"SELECT pfp FROM {student_detail} WHERE username = ?"
    cur.execute(sql_student_pfp, (username,))
    info_pfp = cur.fetchone()
    info_pfp = info_pfp[0]

    # Profile frame
    profile_frame = CTkFrame(main_second_frame_student_win, border_width=0, corner_radius=0)
    profile_frame.place(relx=0, rely=0, relwidth=1, relheight=0.5)
    
    pfp_frame = CTkFrame(profile_frame, border_width=0, corner_radius=0, fg_color="#2b2b2b")
    pfp_frame.place(relx=0.4, rely=0.06, relwidth=0.2, relheight=0.6)

    # Load and display the image
    image_path = os.path.join(pfp_dir, info_pfp)
    image = Image.open(image_path)
    if image:
        pfp_image = CTkImage(dark_image=image, size=(220,220))
        pfp_label = CTkLabel(pfp_frame, text='', image = pfp_image)
    else:
        pfp_label = CTkLabel(pfp_frame, text='\n    No image found...', image = None)

    pfp_label.place(relx=0, rely=-0, relwidth=1, relheight=1)
    # Create a label to display the pfp
    pfp_label = CTkLabel(pfp_frame, text='', image = pfp_image)
    pfp_label.place(relx=0, rely=-0, relwidth=1, relheight=1)

    name_label = CTkLabel(profile_frame,text='Username : ',font=('Roboto',20))
    name_label.place(relx=0.1, rely=0.66)
    name_entry = CTkEntry(profile_frame, border_width=0,corner_radius=0, font=('Roboto',18,),)
    name_entry.place(relx=0.2, rely=0.66, relwidth=0.3, relheight=0.1)
    name_entry.insert(0,info_username)
    name_entry.configure(state="disabled")

    class_label = CTkLabel(profile_frame,text='Class : ',font=('Roboto',20))
    class_label.place(relx=0.6, rely=0.66)
    class_entry = CTkEntry(profile_frame, border_width=0,corner_radius=0,font=('Roboto',18,),)
    class_entry.place(relx=0.67, rely=0.66, relwidth=0.1, relheight=0.1)
    class_entry.insert(0,info_class)
    class_entry.configure(state="disabled")

    email_label = CTkLabel(profile_frame,text='Email : ',font=('Roboto',20))
    email_label.place(relx=0.1, rely=0.8)
    email_entry = CTkEntry(profile_frame, border_width=0,corner_radius=0,font=('Roboto',18,),)
    email_entry.place(relx=0.2, rely=0.8, relwidth=0.4, relheight=0.1)
    email_entry.insert(0,info_email)
    email_entry.configure(state="disabled")

    profile_delete_button = CTkButton(profile_frame,text='Delete Profile',border_width=2,corner_radius=5,border_color='#ff0000',
        fg_color='#ff3737', hover_color='#d20000',font=('Roboto',22,),command=lambda: student_profile_delete(name_entry))
    profile_delete_button.place(relx=0.8,rely=0.85, relwidth=0.15, relheight=0.1)

    text_label = CTkLabel(profile_frame,text='Borrowed Books : ',font=('Roboto',20))
    text_label.place(relx=0.05, rely=0.9)


    # Borrowed Books Frame
    tree_frame_borrowedbooks = CTkFrame(main_second_frame_student_win, border_width=0, corner_radius=0)
    tree_frame_borrowedbooks.place(relx=0, rely=0.5, relwidth=1, relheight=0.5)

    # Create a ttk.Treeview widget inside the tree_frame_borrowedbooks
    scrollbar = CTkScrollbar(tree_frame_borrowedbooks, orientation='vertical')
    tree_student_borrowedbooks = ttk.Treeview(tree_frame_borrowedbooks, show="headings", style="Custom.Treeview", )
    tree_student_borrowedbooks["columns"] = ("bid","title","subject","author",)
    # Define column headings
    tree_student_borrowedbooks.heading("bid", text="BID")
    tree_student_borrowedbooks.heading("title", text="Title")
    tree_student_borrowedbooks.heading("subject", text="Subject")
    tree_student_borrowedbooks.heading("author", text="Author")

    tree_student_borrowedbooks.column("bid", width=50, anchor="center",)
    tree_student_borrowedbooks.column("title", width=250, anchor="w",)
    tree_student_borrowedbooks.column("subject", width=100, anchor="w",)
    tree_student_borrowedbooks.column("author", width=100, anchor="w",)

    #######    Inserting Data into the treeview
    sql_borrowed_books = f"""SELECT {books_detail}.bid, {books_detail}.title, {books_detail}.subject, {books_detail}.author
    FROM {books_detail}
    JOIN {book_issue_detail} ON {books_detail}.bid = {book_issue_detail}.bid
    JOIN {student_detail} ON {book_issue_detail}.username = {student_detail}.username
    WHERE studentdetail.username = ?;"""
    cur.execute(sql_borrowed_books, (username,))
    borrowed_books = cur.fetchall()

    if borrowed_books:
        # Remove existing items in the Treeview
        try:
            for item in tree_student_borrowedbooks.get_children():
                tree_student_borrowedbooks.delete(item)
        except:
            pass
        # Insert data into the Treeview
        for row in borrowed_books:
            tree_student_borrowedbooks.insert("", "end", values=row)
            
        # Filling empty space into the Treeview
        for i in range(20 - get_treeview_length(tree_student_borrowedbooks)):
            tree_student_borrowedbooks.insert("", "end", values=['-','-','-','-'])
    else:
        # Insert data into the Treeview
        for i in range(20):
            tree_student_borrowedbooks.insert("", "end", values=['-','-','-','-'])

    # Defining a custom style
    style = ttk.Style()
    style.configure("Custom.Treeview", foreground="white", font=("Arial", 10))
    # Applying the style to the TreeView
    tree_student_borrowedbooks.tag_configure("Custom.Treeview",)
    # Changing the color of the even rows
    style.configure("evenrow", background="#2b2b2b")
    # Changing the color of the odd rows
    style.configure("oddrow", background="#3a3a3a")
    # Applying tags to all items
    for i in tree_student_borrowedbooks.get_children():
        index = tree_student_borrowedbooks.index(i)
        if index % 2 == 0:
            tree_student_borrowedbooks.tag_configure("evenrow", background="#3a3a3a")
            tree_student_borrowedbooks.item(i, tags=("evenrow",))
        else:
            tree_student_borrowedbooks.tag_configure("oddrow", background="#2b2b2b")
            tree_student_borrowedbooks.item(i, tags=("oddrow",))

    # Changing the color of selected row
    style.map("Treeview",
            foreground=[('selected', 'white')],
            background=[('selected', '#ff3535')])
    # Binding the selection event
    tree_student_borrowedbooks.bind("<ButtonRelease-1>", on_select)

    scrollbar.pack(side='right', fill='y')
    scrollbar.configure(command= tree_student_borrowedbooks.yview)
    tree_student_borrowedbooks.configure(yscrollcommand=scrollbar.set)
    tree_student_borrowedbooks.pack(expand=True, fill="both")

def student_profile_delete(name_entry):
    name_entry.configure(state="normal")
    user = name_entry.get()
    name_entry.configure(state="disabled")
    
    confirm = CTkMessagebox(title="Confirmation", message=f"All Books will be returned\nand your account will be DELETED\nAre You sure about this?", icon='info', option_1='No', option_2='Yes', font=("Arial", 15))
    if confirm.get() == 'Yes':
        ### Return Borrowed Books
        sql_return_allbooks = f"""SELECT bid FROM {book_issue_detail} WHERE username = ?;"""
        cur.execute(sql_return_allbooks, (info_username, ))
        return_books = cur.fetchall()
        
        if return_books:
            for bid_value in return_books:
                sql_update_books = f"""UPDATE {books_detail} SET status = 'Available' WHERE bid = ? AND status = 'Unavailable';"""
                cur.execute(sql_update_books, (bid_value[0],))

            sql_delete_borrowed = f"""DELETE FROM {book_issue_detail} WHERE bid = ? AND username = ?;"""
            cur.executemany(sql_delete_borrowed, [(bid[0], info_username) for bid in return_books])
            con.commit()
        
        ### Delete Username
        sql_student_username = f"DELETE FROM {student_detail} WHERE username = ?"
        cur.execute(sql_student_username, (user,))
        
        # Remove all the widgets from the main_win
        try:
            for widget in root.winfo_children():
                widget.destroy()
        except:
            pass

        main_win()


# >>>>>> All Books Window for Users
def student_main_win_allbooks():
    global tree_student_allbooks
    # Remove all the widgets from the main_second_frame_student_win
    try:
        for widget in main_second_frame_student_win.winfo_children():
            widget.destroy()
    except:
        pass

    def on_select(event):
        selected_item = tree_student_allbooks.selection()

    student_tree_frame_allbooks = CTkFrame(main_second_frame_student_win, border_width=0, corner_radius=0)
    student_tree_frame_allbooks.place(relx=0, rely=0.04, relwidth=1, relheight=0.86)

    # Create a ttk.Treeview widget inside the CTkFrame with a CTkScrollbar
    scrollbar = CTkScrollbar(student_tree_frame_allbooks, orientation='vertical')
    tree_student_allbooks = ttk.Treeview(student_tree_frame_allbooks, show="headings", style="Custom.Treeview", )
    tree_student_allbooks["columns"] = ("bid","title","subject","author","status")
    # Define column headings
    tree_student_allbooks.heading("bid", text="BID")
    tree_student_allbooks.heading("title", text="Title")
    tree_student_allbooks.heading("subject", text="Subject")
    tree_student_allbooks.heading("author", text="Author")
    tree_student_allbooks.heading("status", text="Status")

    tree_student_allbooks.column("bid", width=50, anchor="center",)
    tree_student_allbooks.column("title", width=250, anchor="w",)
    tree_student_allbooks.column("subject", width=100, anchor="w",)
    tree_student_allbooks.column("author", width=100, anchor="w",)
    tree_student_allbooks.column("status", width=50, anchor="center",)

    #######    Inserting Data into the treeview
    cur.execute(f"SELECT * FROM {books_detail}")
    data = cur.fetchall()
    # Remove existing items in the Treeview
    try:
        for item in tree_student_allbooks.get_children():
            tree_student_allbooks.delete(item)
    except:
        pass
    # Insert data into the Treeview
    for row in data:
        tree_student_allbooks.insert("", "end", values=row)

    # Defining a custom style
    style = ttk.Style()
    style.configure("Custom.Treeview", foreground="white", font=("Arial", 10))
    # Applying the style to the TreeView
    tree_student_allbooks.tag_configure("Custom.Treeview",)
    # Changing the color of the even rows
    style.configure("evenrow", background="#2b2b2b")
    # Changing the color of the odd rows
    style.configure("oddrow", background="#3a3a3a")
    # Applying tags to all items
    for i in tree_student_allbooks.get_children():
        index = tree_student_allbooks.index(i)
        if index % 2 == 0:
            tree_student_allbooks.tag_configure("evenrow", background="#3a3a3a")
            tree_student_allbooks.item(i, tags=("evenrow",))
        else:
            tree_student_allbooks.tag_configure("oddrow", background="#2b2b2b")
            tree_student_allbooks.item(i, tags=("oddrow",))

    # Changing the color of selected row
    style.map("Treeview",
            foreground=[('selected', 'white')],
            background=[('selected', '#ff3535')])
    # Binding the selection event
    tree_student_allbooks.bind("<ButtonRelease-1>", on_select)

    scrollbar.pack(side='right', fill='y')
    scrollbar.configure(command= tree_student_allbooks.yview)
    tree_student_allbooks.configure(yscrollcommand=scrollbar.set)
    # tree_student_allbooks.place(relx=0, rely=0, relwidth=0.9, relheight=1)
    tree_student_allbooks.pack(expand=True, fill="both")

    ###   Filter Frame   ###
    filter_frame = CTkFrame(main_second_frame_student_win, border_width=0, corner_radius=0)
    filter_frame.place(relx=0, rely=0, relwidth=1, relheight=0.04)
    
    button_filter_frame_down = CTkButton(filter_frame, text='⬇ Filter ⬇',border_width=4,corner_radius=0,border_color='#818181',
        fg_color='#5353ff', hover_color='#0000f0',font=('Roboto',22,),command=lambda: student_filter_down_allbooks(student_tree_frame_allbooks, filter_frame))
    button_filter_frame_down.place(relx=0, rely=0, relwidth=1, relheight=1)

    ###   Borrow Frame   ###
    borrow_frame = CTkFrame(main_second_frame_student_win, border_width=0, corner_radius=0)
    borrow_frame.place(relx=0, rely=0.9, relwidth=1, relheight=0.1)

    label_borrow = CTkLabel(borrow_frame,text='Borrow Book : ',font=('Roboto',20))
    label_borrow.place(relx=0.1, rely=0.3)

    entry_borrow_bid = CTkEntry(borrow_frame, placeholder_text=' '*3+'Enter BID', border_width=2,corner_radius=0, font=('Roboto',18,),)
    entry_borrow_bid.place(relx=0.23, rely=0.3, relwidth=0.2, relheight=0.5)

    button_borrow_bid = CTkButton(borrow_frame, text='Borrow',border_width=1,corner_radius=4,border_color='#818181',
        fg_color='#3333ff', hover_color='#0000f0',font=('Roboto',22,),command=lambda: student_borrow_books(entry_borrow_bid))
    button_borrow_bid.place(relx=0.5, rely=0.3, relwidth=0.1, relheight=0.5)

def student_filter_down_allbooks(tree_frame, filter_frame):
    tree_frame.place(relx=0, rely=0.2, relwidth=1, relheight=0.7)
    filter_frame.place(relx=0, rely=0, relwidth=1, relheight=0.2)
    try:
        for widget in filter_frame.winfo_children():
            widget.destroy()
    except:
        pass

    def filter_optionmenu(choice):
        asc_desc = radio_var_1.get()
        available_unavailable = radio_var_2.get()
        # Modify the SQL query based on the selected status
        if available_unavailable == 'Both':
            sql_filter_books = f"""SELECT * FROM {books_detail} ORDER BY {choice} {asc_desc};"""
        else:
            sql_filter_books = f"""SELECT * FROM {books_detail} WHERE status = ? ORDER BY {choice} {asc_desc};"""

        # Remove existing items in the Treeview
        try:
            for item in tree_student_allbooks.get_children():
                tree_student_allbooks.delete(item)
        except Exception as e:
            pass

        if available_unavailable == 'Both':
            cur.execute(sql_filter_books)
        else:
            cur.execute(sql_filter_books, (available_unavailable,))

        filtered_books = cur.fetchall()

        if filtered_books:
            # Insert data into the Treeview
            for row in filtered_books:
                tree_student_allbooks.insert("", "end", values=row)
                # Filling empty space into the Treeview
            for i in range(30 - get_treeview_length(tree_student_allbooks)):
                tree_student_allbooks.insert("", "end", values=['-','-','-','-','-'])

        else:
            # Insert data into the Treeview
            for i in range(30):
                tree_student_allbooks.insert("", "end", values=['-','-','-','-','-'])

        # Applying row colours
        for i in tree_student_allbooks.get_children():
            index = tree_student_allbooks.index(i)
            if index % 2 == 0:
                tree_student_allbooks.tag_configure("evenrow", background="#3a3a3a")
                tree_student_allbooks.item(i, tags=("evenrow",))
            else:
                tree_student_allbooks.tag_configure("oddrow", background="#2b2b2b")
                tree_student_allbooks.item(i, tags=("oddrow",))
        
    def filter_radiobutton():
        heading_filter_option = heading_filter.get()
        asc_desc = radio_var_1.get()
        available_unavailable = radio_var_2.get()
        # Modify the SQL query based on the selected status
        if available_unavailable == 'Both':
            sql_filter_books = f"""SELECT * FROM {books_detail} ORDER BY {heading_filter_option} {asc_desc};"""
        else:
            sql_filter_books = f"""SELECT * FROM {books_detail} WHERE status = ? ORDER BY {heading_filter_option} {asc_desc};"""

        # Remove existing items in the Treeview
        try:
            for item in tree_student_allbooks.get_children():
                tree_student_allbooks.delete(item)
        except Exception as e:
            pass

        if available_unavailable == 'Both':
            cur.execute(sql_filter_books)
        else:
            cur.execute(sql_filter_books, (available_unavailable,))

        filtered_books = cur.fetchall()

        if filtered_books:
            # Insert data into the Treeview
            for row in filtered_books:
                tree_student_allbooks.insert("", "end", values=row)
                # Filling empty space into the Treeview
            for i in range(30 - get_treeview_length(tree_student_allbooks)):
                tree_student_allbooks.insert("", "end", values=['-','-','-','-','-'])

        else:
            # Insert data into the Treeview
            for i in range(30):
                tree_student_allbooks.insert("", "end", values=['-','-','-','-','-'])

        # Applying row colours
        for i in tree_student_allbooks.get_children():
            index = tree_student_allbooks.index(i)
            if index % 2 == 0:
                tree_student_allbooks.tag_configure("evenrow", background="#3a3a3a")
                tree_student_allbooks.item(i, tags=("evenrow",))
            else:
                tree_student_allbooks.tag_configure("oddrow", background="#2b2b2b")
                tree_student_allbooks.item(i, tags=("oddrow",))

    def search_bookname(event):
        by = search_heading_filter.get()
        letters = entry_search_bookname.get()
        heading_filter_option = heading_filter.get()
        asc_desc = radio_var_1.get()
        available_unavailable = radio_var_2.get()
        # Modify the SQL query based on the selected status
        if available_unavailable == 'Both':
            sql_filter_books = f"""SELECT * FROM {books_detail} WHERE {by} LIKE ? ORDER BY {heading_filter_option} {asc_desc};"""
        else:
            sql_filter_books = f"""SELECT * FROM {books_detail} WHERE status = ? AND {by} LIKE ? ORDER BY {heading_filter_option} {asc_desc};"""

        # Remove existing items in the Treeview
        try:
            for item in tree_student_allbooks.get_children():
                tree_student_allbooks.delete(item)
        except Exception as e:
            pass

        if available_unavailable == 'Both':
            cur.execute(sql_filter_books, ('%' + letters + '%',))
        else:
            cur.execute(sql_filter_books, (available_unavailable, '%' + letters + '%'))

        filtered_books = cur.fetchall()

        if filtered_books:
            # Insert data into the Treeview
            for row in filtered_books:
                tree_student_allbooks.insert("", "end", values=row)
                # Filling empty space into the Treeview
            for i in range(30 - get_treeview_length(tree_student_allbooks)):
                tree_student_allbooks.insert("", "end", values=['-','-','-','-','-'])

        else:
            # Insert data into the Treeview
            for i in range(30):
                tree_student_allbooks.insert("", "end", values=['-','-','-','-','-'])

        # Applying row colours
        for i in tree_student_allbooks.get_children():
            index = tree_student_allbooks.index(i)
            if index % 2 == 0:
                tree_student_allbooks.tag_configure("evenrow", background="#3a3a3a")
                tree_student_allbooks.item(i, tags=("evenrow",))
            else:
                tree_student_allbooks.tag_configure("oddrow", background="#2b2b2b")
                tree_student_allbooks.item(i, tags=("oddrow",))


    button_filter_frame_up_button = CTkButton(filter_frame, text='⬆ Filter ⬆',border_width=4,corner_radius=0,border_color='#818181',
        fg_color='#5353ff', hover_color='#0000f0',font=('Roboto',22,),command=lambda: student_filter_up_allbooks(tree_frame, filter_frame))
    button_filter_frame_up_button.place(relx=0, rely=0.8, relwidth=1, relheight=0.2)

    ###   Filter Keys   ###
    filter_label = CTkLabel(filter_frame,text='Filter : ',font=('Roboto',20))
    filter_label.place(relx=0.01, rely=0.05)

    heading_filter = CTkOptionMenu(filter_frame, values=['bid','title','subject','author', 'status'], command=filter_optionmenu)
    heading_filter.place(relx=0.1, rely=0.1, relwidth=0.1, relheight=0.2)

    radio_var_1 = tk.StringVar(filter_frame, value='ASC')
    radio_button_1 = CTkRadioButton(filter_frame, variable=radio_var_1, value='ASC', text='Ascending',
        font=('Roboto',16,), command=filter_radiobutton)
    radio_button_1.place(relx=0.1, rely=0.4, relwidth=0.1, relheight=0.15)
    radio_button_2 = CTkRadioButton(filter_frame, variable=radio_var_1, value='DESC', text='Descending',
        font=('Roboto',16,), command=filter_radiobutton)
    radio_button_2.place(relx=0.1, rely=0.6, relwidth=0.1, relheight=0.15)

    status_label = CTkLabel(filter_frame,text='Status : ',font=('Roboto',18))
    status_label.place(relx=0.25, rely=0.03)

    radio_var_2 = tk.StringVar(filter_frame, value="Both")
    radio_button_3 = CTkRadioButton(filter_frame, variable=radio_var_2, value="Both", text='Both',
        font=('Roboto',16,), command=filter_radiobutton)
    radio_button_3.place(relx=0.25, rely=0.23, relwidth=0.1, relheight=0.15)
    radio_button_4 = CTkRadioButton(filter_frame, variable=radio_var_2, value='Available', text='Available',
        font=('Roboto',16,), command=filter_radiobutton)
    radio_button_4.place(relx=0.25, rely=0.43, relwidth=0.1, relheight=0.15)
    radio_button_5 = CTkRadioButton(filter_frame, variable=radio_var_2, value='Unavailable', text='Unavailable',
        font=('Roboto',16,), command=filter_radiobutton)
    radio_button_5.place(relx=0.25, rely=0.63, relwidth=0.1, relheight=0.15)

    ####   Search Frame   ####
    search_frame = CTkFrame(filter_frame, border_width=4, corner_radius=0, fg_color='#2b2b2b')
    search_frame.place(relx=0.5, rely=0, relwidth=0.51, relheight=0.8)

    label_search = CTkLabel(search_frame,text='Search Book : ',font=('Roboto',20))
    label_search.place(relx=0.05, rely=0.05)
    
    search_heading_filter = CTkOptionMenu(search_frame, values=['title','subject','author','bid'], )
    search_heading_filter.place(relx=0.05, rely=0.4, relwidth=0.2, relheight=0.3)

    entry_search_bookname = CTkEntry(search_frame, placeholder_text=' '*3+'Enter Book Name', border_width=2,corner_radius=0, font=('Roboto',18,),)
    entry_search_bookname.bind('<KeyRelease>',search_bookname)
    entry_search_bookname.bind('<KeyRelease>',search_bookname)
    entry_search_bookname.place(relx=0.3, rely=0.4, relwidth=0.5, relheight=0.3)

def student_filter_up_allbooks(tree_frame, filter_frame):
    tree_frame.place(relx=0, rely=0.04, relwidth=1, relheight=0.86)
    filter_frame.place(relx=0, rely=0, relwidth=1, relheight=0.04)
    try:
        for widget in filter_frame.winfo_children():
            widget.destroy()
    except:
        pass
    button_filter_frame_down = CTkButton(filter_frame, text='⬇ Filter ⬇',border_width=4,corner_radius=0,border_color='#818181',
        fg_color='#5353ff', hover_color='#0000f0',font=('Roboto',22,),command=lambda: student_filter_down_allbooks(tree_frame, filter_frame))
    button_filter_frame_down.place(relx=0, rely=0, relwidth=1, relheight=1)

def student_borrow_books(entry_bid):
    bid = entry_bid.get()
    cur.execute(f"SELECT * FROM {books_detail} WHERE bid=?", (bid,))
    result = cur.fetchone()
    if result:
        cur.execute(f"SELECT status FROM {books_detail} WHERE bid=?", (bid,))
        bid_result = cur.fetchone()
        
        cur.execute(f"SELECT bid, title, subject, author FROM {books_detail} WHERE bid=?", (bid,))
        book_result = cur.fetchone()
        bid, title, subject, author = book_result
        
        if bid_result and bid_result[0] == "Available":
            cur.execute(f"INSERT INTO {book_issue_detail} (bid, username) VALUES (?, ?)", [bid, info_username])
            con.commit()
            cur.execute(f"UPDATE {books_detail} SET status = 'Unavailable' WHERE bid = ?", [bid,])
            con.commit()
            CTkMessagebox(title="Success!", message=f"You Borrowed a Book...\nBID : {bid}\nTitle : {title}\nSubject : {subject}\nAuthor : {author}", icon='check', option_1='Okay', font=("Arial", 15))
        else:
           CTkMessagebox(title="Not Available", message=f"The Book\nBID : {bid}\nTitle : {title}\nSubject : {subject}\nAuthor : {author}\nis UNAVAILABLE at the moment.\nPlease try later", icon="warning", option_1="Cancel", font=("Arial", 15)) 
    else:
        CTkMessagebox(title="No Book", message=f"No Book with BID '{bid}' found \nin our Database..", icon='cancel', option_1='Okay', font=("Arial", 15))


# >>>>>> Return Books Window for Users
def student_main_win_return_books():
    # Remove all the widgets from the main_second_frame_student_win
    try:
        for widget in main_second_frame_student_win.winfo_children():
            widget.destroy()
    except:
        pass
    
    def on_select(event):
        selected_item = tree_student_returnbooks.selection()

    student_tree_frame_returnbooks = CTkFrame(main_second_frame_student_win, border_width=0, corner_radius=0)
    student_tree_frame_returnbooks.place(relx=0, rely=0, relwidth=1, relheight=0.9)

    # Create a ttk.Treeview widget inside the CTkFrame with a CTkScrollbar
    scrollbar = CTkScrollbar(student_tree_frame_returnbooks, orientation='vertical')
    tree_student_returnbooks = ttk.Treeview(student_tree_frame_returnbooks, show="headings", style="Custom.Treeview", )
    tree_student_returnbooks["columns"] = ("bid","title","subject","author","status")
    # Define column headings
    tree_student_returnbooks.heading("bid", text="BID")
    tree_student_returnbooks.heading("title", text="Title")
    tree_student_returnbooks.heading("subject", text="Subject")
    tree_student_returnbooks.heading("author", text="Author")

    tree_student_returnbooks.column("bid", width=50, anchor="center",)
    tree_student_returnbooks.column("title", width=250, anchor="w",)
    tree_student_returnbooks.column("subject", width=150, anchor="w",)
    tree_student_returnbooks.column("author", width=100, anchor="w",)

    #######    Inserting Data into the treeview
    sql_borrowed_books = f"""SELECT {books_detail}.bid, {books_detail}.title, {books_detail}.subject, {books_detail}.author
    FROM {books_detail}
    JOIN {book_issue_detail} ON {books_detail}.bid = {book_issue_detail}.bid
    JOIN {student_detail} ON {book_issue_detail}.username = {student_detail}.username
    WHERE studentdetail.username = ?;"""
    cur.execute(sql_borrowed_books, (username,))
    borrowed_books = cur.fetchall()

    if borrowed_books:
        # Remove existing items in the Treeview
        try:
            for item in tree_student_returnbooks.get_children():
                tree_student_returnbooks.delete(item)
        except:
            pass
        # Insert data into the Treeview
        for row in borrowed_books:
            tree_student_returnbooks.insert("", "end", values=row)

        # Filling empty space into the Treeview
        for i in range(40 - get_treeview_length(tree_student_returnbooks)):
            tree_student_returnbooks.insert("", "end", values=['-','-','-','-'])
    else:
        # Insert data into the Treeview
        for i in range(40):
            tree_student_returnbooks.insert("", "end", values=['-','-','-','-'])

    # Defining a custom style
    style = ttk.Style()
    style.configure("Custom.Treeview", foreground="white", font=("Arial", 10))
    # Applying the style to the TreeView
    tree_student_returnbooks.tag_configure("Custom.Treeview",)
    # Changing the color of the even rows
    style.configure("evenrow", background="#2b2b2b")
    # Changing the color of the odd rows
    style.configure("oddrow", background="#3a3a3a")
    # Applying tags to all items
    for i in tree_student_returnbooks.get_children():
        index = tree_student_returnbooks.index(i)
        if index % 2 == 0:
            tree_student_returnbooks.tag_configure("evenrow", background="#3a3a3a")
            tree_student_returnbooks.item(i, tags=("evenrow",))
        else:
            tree_student_returnbooks.tag_configure("oddrow", background="#2b2b2b")
            tree_student_returnbooks.item(i, tags=("oddrow",))

    # Changing the color of selected row
    style.map("Treeview",
            foreground=[('selected', 'white')],
            background=[('selected', '#ff3535')])
    # Binding the selection event
    tree_student_returnbooks.bind("<ButtonRelease-1>", on_select)

    scrollbar.pack(side='right', fill='y')
    scrollbar.configure(command= tree_student_returnbooks.yview)
    tree_student_returnbooks.configure(yscrollcommand=scrollbar.set)
    tree_student_returnbooks.pack(expand=True, fill="both")
    
    
    ###   Return Frame   ###
    return_frame = CTkFrame(main_second_frame_student_win, border_width=0, corner_radius=0)
    return_frame.place(relx=0, rely=0.9, relwidth=1, relheight=0.1)

    label_return = CTkLabel(return_frame,text='Return Book : ',font=('Roboto',20))
    label_return.place(relx=0.1, rely=0.3)

    entry_return_bid = CTkEntry(return_frame, placeholder_text=' '*3+'Enter BID', border_width=2,corner_radius=0, font=('Roboto',18,),)
    entry_return_bid.place(relx=0.23, rely=0.3, relwidth=0.2, relheight=0.5)

    button_return_bid = CTkButton(return_frame, text='Return',border_width=1,corner_radius=4,border_color='#818181',
        fg_color='#3333ff', hover_color='#0000f0',font=('Roboto',22,),command=lambda: student_return_books(entry_return_bid))
    button_return_bid.place(relx=0.5, rely=0.3, relwidth=0.1, relheight=0.5)
    
    button_returnall = CTkButton(return_frame, text='Return All',border_width=1,corner_radius=4,border_color='#818181',
        fg_color='#3333ff', hover_color='#0000f0',font=('Roboto',22,),command=lambda: student_returnall_books())
    button_returnall.place(relx=0.7, rely=0.3, relwidth=0.1, relheight=0.5)

def student_return_books(entry_bid):
    bid_val = entry_bid.get()
    sql_return_books = f"""SELECT bid FROM {book_issue_detail} WHERE bid = ? AND username = ?;"""
    cur.execute(sql_return_books, (bid_val, info_username))
    return_books = cur.fetchall()

    if return_books:
        for bid_value in return_books:
            sql_update_books = f"""UPDATE {books_detail} SET status = 'Available' WHERE bid = ? AND status = 'Unavailable';"""
            cur.execute(sql_update_books, (bid_value[0],))

        sql_delete_borrowed = f"""DELETE FROM {book_issue_detail} WHERE bid = ? AND username = ?;"""
        cur.executemany(sql_delete_borrowed, [(bid[0], info_username) for bid in return_books])
        con.commit()
        
        CTkMessagebox(title="Success!", message=f"Book '{bid_val}' returned\nSuccessfully!", icon='check', option_1='Okay', font=("Arial", 15))

    else:
        CTkMessagebox(title="No Book", message=f"No Book with BID '{bid_value}' found \nin your Borrowed Books Database..", icon='cancel', option_1='Okay', font=("Arial", 15))

def student_returnall_books():
    sql_return_allbooks = f"""SELECT bid FROM {book_issue_detail} WHERE username = ?;"""
    cur.execute(sql_return_allbooks, (info_username, ))
    return_books = cur.fetchall()
    
    if return_books:
        for bid_value in return_books:
            sql_update_books = f"""UPDATE {books_detail} SET status = 'Available' WHERE bid = ? AND status = 'Unavailable';"""
            cur.execute(sql_update_books, (bid_value[0],))

        sql_delete_borrowed = f"""DELETE FROM {book_issue_detail} WHERE bid = ? AND username = ?;"""
        cur.executemany(sql_delete_borrowed, [(bid[0], info_username) for bid in return_books])
        con.commit()

        CTkMessagebox(title="Success!", message=f"All Books returned\nSuccessfully!", icon='check', option_1='Okay', font=("Arial", 15))

    else:
        CTkMessagebox(title="No Book", message=f"No Book found \nin your Borrowed Books Database..", icon='cancel', option_1='Okay', font=("Arial", 15))


##### >>>>>   ADMINS   <<<<< #####
def admin_button_click_register():
    global entry_admin_rusername, entry_admin_rpassword1, entry_admin_rpassword2, entry_admin_remail, entry_lib_id
    global button_admin_register, label_error_admin, switch_admin_rpassword1, switch_admin_rpassword2

    button_student.place(rely=0.3, relheight=0.41)
    button_admin.place(rely=0.2, relheight=0.61)

    # Remove all the widgets from the main_frame
    try:
        for widget in main_frame.winfo_children():
            widget.destroy()
    except:
        pass

    # Filler Frame for Register button
    filler_frame = CTkFrame(master=main_frame, border_width=5, corner_radius=0, fg_color='#ff0000')
    filler_frame.place(relx=0.5, rely=0, relwidth=0.5, relheight=1)

    filler_frame_label = CTkLabel(master=filler_frame, text=" "*8+"Already an Admin?",font=('Roboto',26,'bold'))
    filler_frame_label.place(relx=0.05, rely=0.4,)

    button_login = CTkButton(master=filler_frame,text='Login',font=('Roboto',26),border_width=3,corner_radius=15,
    border_color='#ffffff',fg_color='#ffffff',text_color='#ff0000',hover_color='#d7d7d7',command=admin_button_click_login)
    button_login.place(relx=0.3, rely=0.5, relwidth=0.4, relheight=0.1)

    # Login Frame
    label_register = CTkLabel(master=main_frame,text='Register',font=('Roboto',22,))
    label_register.place(relx=0.2, rely=0.05)

    frame_register = CTkFrame(master=main_frame,border_width=4,border_color='#ff0000')
    frame_register.place(relx=0.02, rely=0.12, relwidth=0.46, relheight=0.84)

    label_username = CTkLabel(master=frame_register,text='Create Username',font=('Roboto',20))
    label_username.place(relx=0.13, rely=0.03)

    entry_admin_rusername = CTkEntry(master=frame_register,placeholder_text="    Username",
        border_width=3,corner_radius=10,border_color='#ff0000',font=('Roboto',15,))
    entry_admin_rusername.bind('<KeyRelease>',empty_entry_admin)
    entry_admin_rusername.place(relx=0.03, rely=0.08, relwidth=0.94, relheight=0.08)

    label_password1 = CTkLabel(master=frame_register,text='Create Password',font=('Roboto',20))
    label_password1.place(relx=0.13, rely=0.18)

    entry_admin_rpassword1 = CTkEntry(master=frame_register,placeholder_text="    Password",show='*',
        border_width=3,corner_radius=10,border_color='#ff0000',font=('Roboto',15,))
    entry_admin_rpassword1.bind('<KeyRelease>',empty_entry_admin)
    entry_admin_rpassword1.place(relx=0.03, rely=0.23, relwidth=0.82, relheight=0.08)

    switch_admin_rpassword1 = CTkSwitch(master=frame_register,text='Show',font=('Roboto',12,),switch_height=15,switch_width=30,
        progress_color='#ff0000', command=lambda:pass_switch(switch_admin_rpassword1, entry_admin_rpassword1))
    switch_admin_rpassword1.place(relx=0.87, rely=0.24, relwidth=0.1, relheight=0.05)

    label_password2 = CTkLabel(master=frame_register,text='Confirm Password',font=('Roboto',20))
    label_password2.place(relx=0.13, rely=0.31)

    entry_admin_rpassword2 = CTkEntry(master=frame_register,placeholder_text="   Confirm Password",show='*',
        border_width=3, corner_radius=10,border_color='#ff0000',font=('Roboto',15,))
    entry_admin_rpassword2.place(relx=0.03, rely=0.36, relwidth=0.82, relheight=0.08)

    switch_admin_rpassword2 = CTkSwitch(master=frame_register,text='Show',font=('Roboto',12,),switch_height=15,switch_width=30,
        progress_color='#ff0000', command=lambda:pass_switch(switch_admin_rpassword2, entry_admin_rpassword2))
    switch_admin_rpassword2.place(relx=0.87, rely=0.37, relwidth=0.1, relheight=0.05)

    label_lib_id = CTkLabel(master=frame_register,text='Library ID',font=('Roboto',20))
    label_lib_id.place(relx=0.13, rely=0.46)

    entry_lib_id = CTkEntry(master=frame_register,placeholder_text="   Confirm Password",show='*',
        border_width=3, corner_radius=10,border_color='#ff0000',font=('Roboto',15,))
    entry_lib_id.place(relx=0.03, rely=0.51, relwidth=0.82, relheight=0.08)
    
    button_help = CTkButton(master=frame_register,text='?',border_width=1,corner_radius=5,
        border_color='#ff0000',fg_color='#ff0000', hover_color='#d20000',command=lambda: help_button())
    button_help.place(relx=0.86, rely=0.53, relwidth=0.1, relheight=0.05)

    label_gmail = CTkLabel(master=frame_register,text='Enter Email',font=('Roboto',20))
    label_gmail.place(relx=0.13, rely=0.61)

    entry_admin_remail = CTkEntry(master=frame_register,placeholder_text="    Someone123@gmail.com",
        border_width=3,corner_radius=10,border_color='#ff0000',font=('Roboto',15,),)
    entry_admin_remail.bind('<KeyRelease>',empty_entry_admin)
    entry_admin_remail.bind('<KeyRelease>',email_check_admin)
    entry_admin_remail.place(relx=0.03, rely=0.66, relwidth=0.9, relheight=0.08)

    label_error_admin = CTkLabel(master=frame_register,text='',font=('Roboto',15))
    label_error_admin.place(relx=0.35, rely=0.76)

    button_admin_register = CTkButton(master=frame_register,text='Register',border_width=3,corner_radius=15,
        border_color='#ff0000',fg_color='#ff0000', hover_color='#d20000',command=admin_register,state='disabled')
    button_admin_register.place(relx=0.35, rely=0.8, relwidth=0.3, relheight=0.1)

def admin_button_click_login():
    global entry_admin_lusername, entry_admin_lpassword

    button_student.place(rely=0.3, relheight=0.41)
    button_admin.place(rely=0.2, relheight=0.61)

    # Remove all the widgets from the main_frame
    try:
        for widget in main_frame.winfo_children():
            widget.destroy()
    except:
        pass

    # Login Frame
    label_login = CTkLabel(master=main_frame,text='Login',font=('Roboto',22,))
    label_login.place(relx=0.7, rely=0.05)

    frame_login = CTkFrame(master=main_frame,border_width=4,border_color='#ff0000')
    frame_login.place(relx=0.52, rely=0.12, relwidth=0.46, relheight=0.84)

    label_username = CTkLabel(master=frame_login,text='Enter Username',font=('Roboto',20))
    label_username.place(relx=0.13, rely=0.03)

    entry_admin_lusername = CTkEntry(master=frame_login,placeholder_text="           Username",
        border_width=3,corner_radius=10,border_color='#ff0000',font=('Roboto',15,))
    entry_admin_lusername.place(relx=0.03, rely=0.08, relwidth=0.94, relheight=0.08)

    label_password = CTkLabel(master=frame_login,text='Enter Password',font=('Roboto',20))
    label_password.place(relx=0.13, rely=0.19)

    entry_admin_lpassword = CTkEntry(master=frame_login,placeholder_text="           Password",show='*',
        border_width=3,corner_radius=10,border_color='#ff0000',font=('Roboto',15,))
    entry_admin_lpassword.place(relx=0.03, rely=0.24, relwidth=0.82, relheight=0.08)

    switch_admin_lpassword = CTkSwitch(master=frame_login,text='Show',font=('Roboto',12),switch_height=15,switch_width=30,
        progress_color='#ff0000', command=lambda:pass_switch(switch_admin_lpassword, entry_admin_lpassword))
    switch_admin_lpassword.place(relx=0.87, rely=0.25, relwidth=0.1, relheight=0.05)

    button_admin_login = CTkButton(master=frame_login,text='Login',border_width=3,corner_radius=15,border_color='#ff0000',
        fg_color='#ff0000', hover_color='#d20000', command=admin_login)
    button_admin_login.place(relx=0.35, rely=0.8, relwidth=0.3, relheight=0.1)

    # Filler Frame for Register button
    filler_frame = CTkFrame(master=main_frame, border_width=5, corner_radius=0, fg_color='#ff0000')
    filler_frame.place(relx=0, rely=0, relwidth=0.5, relheight=1)

    filler_frame_label = CTkLabel(master=filler_frame, text=" "*10+"New Admin?",font=('Roboto',30,'bold'))
    filler_frame_label.place(relx=0.05, rely=0.4,)

    button_register = CTkButton(master=filler_frame,text='Register',font=('Roboto',24),border_width=3,corner_radius=15,
    border_color='#ffffff',fg_color='#ffffff',text_color='#ff0000',hover_color='#d7d7d7',command=admin_button_click_register)
    button_register.place(relx=0.3, rely=0.5, relwidth=0.4, relheight=0.1)


# >>>> Main Window for Admins
def admin_main_win(adminname):
    global main_frame_admin_win, profile_button, all_books_button, manage_user_button, main_second_frame_admin_win

    # Remove all the widgets from the main_win
    try:
        for widget in root.winfo_children():
            widget.destroy()
    except:
        pass

    main_frame_admin_win = CTkFrame(root, border_width=0, corner_radius=0)
    main_frame_admin_win.place(relx=0, rely=0, relwidth=1, relheight=1)
    
    side_frame = CTkFrame(main_frame_admin_win, border_width=5,corner_radius=0,)
    side_frame.place(relx=0,rely=0,relwidth=0.15,relheight=1)
    
    profile_button = CTkButton(side_frame,text='Profile',border_width=4,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=admin_profile_button_click)
    profile_button.place(relx=0,rely=0, relwidth=1, relheight=0.5)

    all_books_button = CTkButton(side_frame,text='All Books',border_width=4,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=admin_all_books_button_click)
    all_books_button.place(relx=0,rely=0.5, relwidth=1, relheight=0.2)

    manage_user_button = CTkButton(side_frame,text='Manage Users',border_width=4,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=admin_return_books_button_click)
    manage_user_button.place(relx=0,rely=0.7, relwidth=1, relheight=0.2)
    
    back_button = CTkButton(side_frame,text='Back',border_width=4,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff8000',font=('Roboto',22,),command=admin_back_button_click)
    back_button.place(relx=0,rely=0.9, relwidth=1, relheight=0.1)

    main_second_frame_admin_win = CTkFrame(main_frame_admin_win, border_width=0, corner_radius=0)
    main_second_frame_admin_win.place(relx=0.15, rely=0, relwidth=0.85, relheight=1)

    admin_main_win_profile(adminname)

#  Side frame button clicks for Admins
def admin_profile_button_click():
    profile_button.place(relx=0,rely=0, relwidth=1, relheight=0.5)
    all_books_button.place(relx=0,rely=0.5, relwidth=1, relheight=0.2)
    manage_user_button.place(relx=0,rely=0.7, relwidth=1, relheight=0.2)
    
    admin_main_win_profile(adminname=adminname)

def admin_all_books_button_click():
    profile_button.place(relx=0,rely=0, relwidth=1, relheight=0.2)
    all_books_button.place(relx=0,rely=0.2, relwidth=1, relheight=0.5)
    manage_user_button.place(relx=0,rely=0.7, relwidth=1, relheight=0.2)
    
    admin_main_win_allbooks()

def admin_return_books_button_click():
    profile_button.place(relx=0,rely=0, relwidth=1, relheight=0.2)
    all_books_button.place(relx=0,rely=0.2, relwidth=1, relheight=0.2)
    manage_user_button.place(relx=0,rely=0.4, relwidth=1, relheight=0.5)
    
    admin_manage_users()

def admin_back_button_click():
    # Remove all the widgets from the main_frame
    try:
        for widget in main_frame_admin_win.winfo_children():
            widget.destroy()
    except:
        pass
    
    main_win()


# >>>>>> Profile Window for Admins
def admin_main_win_profile(adminname):
    global info_adminname
     # Remove all the widgets from the main_second_frame_admin_win
    try:
        for widget in main_second_frame_admin_win.winfo_children():
            widget.destroy()
    except:
        pass
    def on_select(event):
        selected_item = tree_student_data.selection()
    
    def animate_gif(gif_label, gif_frames, frame_index):
        global animating
        frame = gif_frames[frame_index]
        pfp_label.configure(image=frame)
        if frame_index < len(gif_frames) - 1:
            pfp_frame.after(50, animate_gif, gif_label, gif_frames, frame_index + 1)
            animating = True
        else:
            animating = False

    def start_animation(event, gif_label, gif_frames):
        global animating
        if not animating:
            # Start the animation with a delay
            pfp_frame.after(50, animate_gif, gif_label, gif_frames, 0)
        else:
            pass

    sql_admin_adminname = f"SELECT admname FROM {admin_detail} WHERE admname = ?"
    cur.execute(sql_admin_adminname, (adminname,))
    info_adminname = cur.fetchone()     # Fetch the first result
    info_adminname = info_adminname[0]

    sql_admin_email = f"SELECT email FROM {admin_detail} WHERE admname = ?"
    cur.execute(sql_admin_email, (adminname,))
    info_email = cur.fetchone()

    sqlpfp = f"SELECT pfp FROM {admin_detail} WHERE admname = ?"
    cur.execute(sqlpfp, (adminname,))
    result_pfp = cur.fetchone()
    selected_image = result_pfp[0]

    # Profile frame
    profile_frame = CTkFrame(main_second_frame_admin_win, border_width=0, corner_radius=0)
    profile_frame.place(relx=0, rely=0, relwidth=1, relheight=0.5)
    
    pfp_frame = CTkFrame(profile_frame, border_width=0, corner_radius=0, fg_color="#2b2b2b")
    pfp_frame.place(relx=0.4, rely=0.06, relwidth=0.2, relheight=0.6)
    
    # Create a label to display the pfp
    pfp_image = os.path.join(admpfp_dir, selected_image)
    gif_pfp = Image.open(pfp_image)
    if gif_pfp:
        gif_frames = [ImageTk.PhotoImage(frame.resize((220, 220),)) for frame in ImageSequence.Iterator(gif_pfp)]
        pfp_label = CTkLabel(pfp_frame, text='', )
        pfp_label.place(relx=0, rely=-0, relwidth=1, relheight=1)
        # Bind the animation to the Enter event (mouse hover)
        pfp_label.bind("<Enter>", lambda event: start_animation(event, pfp_label, gif_frames))
        animate_gif(pfp_label, gif_frames, 0)      # Start the animation
        animating = True
    else:
        pfp_label = CTkLabel(pfp_frame, text='\n   No pfp found...', image=None)
        pfp_label.place(relx=0, rely=-0, relwidth=1, relheight=1)

    name_label = CTkLabel(profile_frame,text='Admin Name : ',font=('Roboto',20))
    name_label.place(relx=0.1, rely=0.7)
    name_entry = CTkEntry(profile_frame, border_width=0,corner_radius=0, font=('Roboto',18,),)
    name_entry.place(relx=0.24, rely=0.7, relwidth=0.3, relheight=0.1)
    name_entry.insert(0,info_adminname)
    name_entry.configure(state="disabled")

    email_label = CTkLabel(profile_frame,text='Email : ',font=('Roboto',20))
    email_label.place(relx=0.1, rely=0.84)
    email_entry = CTkEntry(profile_frame, border_width=0,corner_radius=0,font=('Roboto',18,),)
    email_entry.place(relx=0.24, rely=0.84, relwidth=0.4, relheight=0.1)
    email_entry.insert(0,info_email)
    email_entry.configure(state="disabled")
    
    profile_delete_button = CTkButton(profile_frame,text='Delete Profile',border_width=2,corner_radius=5,border_color='#ff0000',
        fg_color='#ff3737', hover_color='#d20000',font=('Roboto',22,),command=lambda: admin_profile_delete(name_entry))
    profile_delete_button.place(relx=0.8,rely=0.85, relwidth=0.15, relheight=0.1)
    
    # text_label = CTkLabel(profile_frame,text='Statistics : ',font=('Roboto',20))
    # text_label.place(relx=0.05, rely=0.9)

    # Stastistics Frame
    statistics_frame = CTkFrame(main_second_frame_admin_win, border_width=4, corner_radius=0)
    statistics_frame.place(relx=0, rely=0.5, relwidth=1, relheight=0.5)

    # Statistics label
    sql_total_books = f"""SELECT COUNT(*) AS total_books FROM {books_detail};"""
    cur.execute(sql_total_books)
    total_books = cur.fetchone()[0]
    
    totalbooks_label = CTkLabel(statistics_frame,text='Total Books : ',font=('Roboto',20))
    totalbooks_label.place(relx=0.05, rely=0.05)
    totalbooks_entry = CTkEntry(statistics_frame, border_width=0,corner_radius=0,font=('Roboto',18,),)
    totalbooks_entry.place(relx=0.2, rely=0.05, relwidth=0.08, relheight=0.1)
    totalbooks_entry.insert(0,total_books)
    totalbooks_entry.configure(state="disabled")

    sql_available_books = f"""SELECT COUNT(*) AS available_books_count FROM {books_detail}
                          WHERE status = 'Available';"""
    cur.execute(sql_available_books)
    available_books_count = cur.fetchone()[0]

    availablebooks_label = CTkLabel(statistics_frame,text='Available : ',font=('Roboto',20))
    availablebooks_label.place(relx=0.4, rely=0.05)
    availablebooks_entry = CTkEntry(statistics_frame, border_width=0,corner_radius=0,font=('Roboto',18,),)
    availablebooks_entry.place(relx=0.55, rely=0.05, relwidth=0.08, relheight=0.1)
    availablebooks_entry.insert(0,available_books_count)
    availablebooks_entry.configure(state="disabled")

    sql_unavailable_books = f"""SELECT COUNT(*) AS available_books_count FROM {books_detail}
                          WHERE status = 'Unavailable';"""
    cur.execute(sql_unavailable_books)
    unavailable_books_count = cur.fetchone()[0]

    unavailablebooks_label = CTkLabel(statistics_frame,text='Borrowed : ',font=('Roboto',20))
    unavailablebooks_label.place(relx=0.75, rely=0.05)
    unavailablebooks_entry = CTkEntry(statistics_frame, border_width=0,corner_radius=0,font=('Roboto',18,),)
    unavailablebooks_entry.place(relx=0.9, rely=0.05, relwidth=0.08, relheight=0.1)
    unavailablebooks_entry.insert(0,unavailable_books_count)
    unavailablebooks_entry.configure(state="disabled")

    sql_totaluser = f"""SELECT COUNT(*) AS user_count FROM {student_detail};"""
    cur.execute(sql_totaluser)
    totaluser_count = cur.fetchone()[0]

    totalusers_label = CTkLabel(statistics_frame,text='Total Users : ',font=('Roboto',20))
    totalusers_label.place(relx=0.05, rely=0.2)
    totalusers_entry = CTkEntry(statistics_frame, border_width=0,corner_radius=0,font=('Roboto',18,),)
    totalusers_entry.place(relx=0.2, rely=0.2, relwidth=0.08, relheight=0.1)
    totalusers_entry.insert(0,totaluser_count)
    totalusers_entry.configure(state="disabled")

    ## Tree View for Students Statistics
    treeframe_statistics = CTkFrame(statistics_frame, border_width=0, corner_radius=0)
    treeframe_statistics.place(relx=0, rely=0.3, relwidth=1, relheight=0.7)

    # Create a ttk.Treeview widget inside the treeframe_statistics
    scrollbar = CTkScrollbar(treeframe_statistics, orientation='vertical')
    tree_student_data = ttk.Treeview(treeframe_statistics, show="headings", style="Custom.Treeview", )
    tree_student_data["columns"] = ("username", "count",)
    # Define column headings
    tree_student_data.heading("username", text="Username")
    tree_student_data.heading("count", text="No. Of Borrowed Books")
    

    tree_student_data.column("username", width=100, anchor="center",)
    tree_student_data.column("count", width=250, anchor="center",)

    #######    Inserting Data into the treeview
    sql_studbooks_books = f"""SELECT username, COUNT(username) AS total_count
                                FROM {book_issue_detail} GROUP BY username;"""
    cur.execute(sql_studbooks_books,)
    student_books = cur.fetchall()

    if student_books:
        # Remove existing items in the Treeview
        try:
            for item in tree_student_data.get_children():
                tree_student_data.delete(item)
        except:
            pass
        # Insert data into the Treeview
        for row in student_books:
            tree_student_data.insert("", "end", values=row)

        # Filling empty space into the Treeview
        for i in range(20 - get_treeview_length(tree_student_data)):
            tree_student_data.insert("", "end", values=['-','-','-','-'])
    else:
        # Insert data into the Treeview
        for i in range(20):
            tree_student_data.insert("", "end", values=['-','-','-','-'])
    
    # Defining a custom style
    style = ttk.Style()
    style.configure("Custom.Treeview", foreground="white", font=("Arial", 10))
    # Applying the style to the TreeView
    tree_student_data.tag_configure("Custom.Treeview",)
    # Changing the color of the even rows
    style.configure("evenrow", background="#2b2b2b")
    # Changing the color of the odd rows
    style.configure("oddrow", background="#3a3a3a")
    # Applying tags to all items
    for i in tree_student_data.get_children():
        index = tree_student_data.index(i)
        if index % 2 == 0:
            tree_student_data.tag_configure("evenrow", background="#3a3a3a")
            tree_student_data.item(i, tags=("evenrow",))
        else:
            tree_student_data.tag_configure("oddrow", background="#2b2b2b")
            tree_student_data.item(i, tags=("oddrow",))

    # Changing the color of selected row
    style.map("Treeview",
            foreground=[('selected', 'white')],
            background=[('selected', '#ff3535')])
    # Binding the selection event
    tree_student_data.bind("<ButtonRelease-1>", on_select)

    scrollbar.pack(side='right', fill='y')
    scrollbar.configure(command= tree_student_data.yview)
    tree_student_data.configure(yscrollcommand=scrollbar.set)
    tree_student_data.pack(expand=True, fill="both")

def admin_profile_delete(name_entry):
    name_entry.configure(state="normal")
    admin = name_entry.get()
    name_entry.configure(state="disabled")
    
    confirm = CTkMessagebox(title="Confirmation", message=f"Your account will be DELETED\nAre You sure about this?", icon='info', option_1='No', option_2='Yes', font=("Arial", 15))
    if confirm.get() == 'Yes':
        ### Delete Username
        sql_admin_username = f"DELETE FROM {admin_detail} WHERE admname = ?"
        cur.execute(sql_admin_username, (admin,))
        
        # Remove all the widgets from the main_win
        try:
            for widget in root.winfo_children():
                widget.destroy()
        except:
            pass

        main_win()


# >>>>>> All Books Window for Admin
def admin_main_win_allbooks():
    global tree_admin_allbooks
    # Remove all the widgets from the main_second_frame_student_win
    try:
        for widget in main_second_frame_admin_win.winfo_children():
            widget.destroy()
    except:
        pass

    def on_select(event):
        selected_item = tree_admin_allbooks.selection()

    admin_tree_frame_allbooks = CTkFrame(main_second_frame_admin_win, border_width=0, corner_radius=0)
    admin_tree_frame_allbooks.place(relx=0, rely=0.04, relwidth=1, relheight=0.8)

    # Create a ttk.Treeview widget inside the CTkFrame with a CTkScrollbar
    scrollbar = CTkScrollbar(admin_tree_frame_allbooks, orientation='vertical')
    tree_admin_allbooks = ttk.Treeview(admin_tree_frame_allbooks, show="headings", style="Custom.Treeview", )
    tree_admin_allbooks["columns"] = ("bid","title","subject","author","status")
    # Define column headings
    tree_admin_allbooks.heading("bid", text="BID")
    tree_admin_allbooks.heading("title", text="Title")
    tree_admin_allbooks.heading("subject", text="Subject")
    tree_admin_allbooks.heading("author", text="Author")
    tree_admin_allbooks.heading("status", text="Status")

    tree_admin_allbooks.column("bid", width=50, anchor="center",)
    tree_admin_allbooks.column("title", width=250, anchor="w",)
    tree_admin_allbooks.column("subject", width=100, anchor="w",)
    tree_admin_allbooks.column("author", width=100, anchor="w",)
    tree_admin_allbooks.column("status", width=50, anchor="center",)

    #######    Inserting Data into the treeview
    cur.execute(f"SELECT * FROM {books_detail}")
    data = cur.fetchall()
    # Remove existing items in the Treeview
    try:
        for item in tree_admin_allbooks.get_children():
            tree_admin_allbooks.delete(item)
    except:
        pass
    # Insert data into the Treeview
    for row in data:
        tree_admin_allbooks.insert("", "end", values=row)

    # Defining a custom style
    style = ttk.Style()
    style.configure("Custom.Treeview", foreground="white", font=("Arial", 10))
    # Applying the style to the TreeView
    tree_admin_allbooks.tag_configure("Custom.Treeview",)
    # Changing the color of the even rows
    style.configure("evenrow", background="#2b2b2b")
    # Changing the color of the odd rows
    style.configure("oddrow", background="#3a3a3a")
    # Applying tags to all items
    for i in tree_admin_allbooks.get_children():
        index = tree_admin_allbooks.index(i)
        if index % 2 == 0:
            tree_admin_allbooks.tag_configure("evenrow", background="#3a3a3a")
            tree_admin_allbooks.item(i, tags=("evenrow",))
        else:
            tree_admin_allbooks.tag_configure("oddrow", background="#2b2b2b")
            tree_admin_allbooks.item(i, tags=("oddrow",))

    # Changing the color of selected row
    style.map("Treeview",
            foreground=[('selected', 'white')],
            background=[('selected', '#ff3535')])
    # Binding the selection event
    tree_admin_allbooks.bind("<ButtonRelease-1>", on_select)

    scrollbar.pack(side='right', fill='y')
    scrollbar.configure(command= tree_admin_allbooks.yview)
    tree_admin_allbooks.configure(yscrollcommand=scrollbar.set)
    # tree_admin_allbooks.place(relx=0, rely=0, relwidth=0.9, relheight=1)
    tree_admin_allbooks.pack(expand=True, fill="both")

    ###   Filter Frame   ###
    filter_frame = CTkFrame(main_second_frame_admin_win, border_width=0, corner_radius=0)
    filter_frame.place(relx=0, rely=0, relwidth=1, relheight=0.04)
    
    button_filter_frame_down = CTkButton(filter_frame, text='⬇ Filter ⬇',border_width=4,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_filter_down_allbooks(admin_tree_frame_allbooks, filter_frame))
    button_filter_frame_down.place(relx=0, rely=0, relwidth=1, relheight=1)

    ###   Books Operation Frame   ###
    remove_books_frame = CTkFrame(main_second_frame_admin_win, border_width=0, corner_radius=0)
    remove_books_frame.place(relx=0, rely=0.84, relwidth=1, relheight=0.16)

    button_more_up = CTkButton(remove_books_frame, text='More',border_width=4,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_more_up_allbooks(admin_tree_frame_allbooks, remove_books_frame))#lambda: admin_borrow_books(entry_borrow_bid))
    button_more_up.place(relx=0, rely=0, relwidth=1, relheight=0.25)

    label_remove_books = CTkLabel(remove_books_frame,text='Remove Book : ',font=('Roboto',20))
    label_remove_books.place(relx=0.1, rely=0.4)

    entry_remove_books_bid = CTkEntry(remove_books_frame, placeholder_text=' '*3+'Enter BID', border_width=2,corner_radius=0, font=('Roboto',18,),)
    entry_remove_books_bid.place(relx=0.23, rely=0.4, relwidth=0.2, relheight=0.3)
    
    button_remove_book_bid = CTkButton(remove_books_frame, text='Remove',border_width=2,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_remove_books(entry_remove_books_bid))
    button_remove_book_bid.place(relx=0.5, rely=0.4, relwidth=0.15, relheight=0.3)
    
    button_remove_allbook = CTkButton(remove_books_frame, text='Remove ALL',border_width=2,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_remove_allbooks())
    button_remove_allbook.place(relx=0.7, rely=0.4, relwidth=0.2, relheight=0.3)

def admin_filter_down_allbooks(tree_frame, filter_frame):
    global admin_filter_allbooks
    admin_filter_allbooks = True
    if admin_more_allbooks == False and admin_filter_allbooks == False:
        tree_frame.place(relx=0, rely=0.04, relwidth=1, relheight=0.8)
    elif admin_more_allbooks == False and admin_filter_allbooks == True:
        tree_frame.place(relx=0, rely=0.2, relwidth=1, relheight=0.64)
    elif admin_more_allbooks == True and admin_filter_allbooks == False:
        tree_frame.place(relx=0, rely=0.04, relwidth=1, relheight=0.61)
    elif admin_more_allbooks == True and admin_filter_allbooks == True:
        tree_frame.place(relx=0, rely=0.2, relwidth=1, relheight=0.45)
        
    filter_frame.place(relx=0, rely=0, relwidth=1, relheight=0.2)
    try:
        for widget in filter_frame.winfo_children():
            widget.destroy()
    except:
        pass

    def filter_optionmenu(choice):
        asc_desc = radio_var_1.get()
        available_unavailable = radio_var_2.get()
        # Modify the SQL query based on the selected status
        if available_unavailable == 'Both':
            sql_filter_books = f"""SELECT * FROM {books_detail} ORDER BY {choice} {asc_desc};"""
        else:
            sql_filter_books = f"""SELECT * FROM {books_detail} WHERE status = ? ORDER BY {choice} {asc_desc};"""

        # Remove existing items in the Treeview
        try:
            for item in tree_admin_allbooks.get_children():
                tree_admin_allbooks.delete(item)
        except Exception as e:
            pass

        if available_unavailable == 'Both':
            cur.execute(sql_filter_books)
        else:
            cur.execute(sql_filter_books, (available_unavailable,))

        filtered_books = cur.fetchall()

        if filtered_books:
            # Insert data into the Treeview
            for row in filtered_books:
                tree_admin_allbooks.insert("", "end", values=row)
                # Filling empty space into the Treeview
            for i in range(40 - get_treeview_length(tree_admin_allbooks)):
                tree_admin_allbooks.insert("", "end", values=['-','-','-','-','-'])

        else:
            # Insert data into the Treeview
            for i in range(40):
                tree_admin_allbooks.insert("", "end", values=['-','-','-','-','-'])

        # Applying row colours
        for i in tree_admin_allbooks.get_children():
            index = tree_admin_allbooks.index(i)
            if index % 2 == 0:
                tree_admin_allbooks.tag_configure("evenrow", background="#3a3a3a")
                tree_admin_allbooks.item(i, tags=("evenrow",))
            else:
                tree_admin_allbooks.tag_configure("oddrow", background="#2b2b2b")
                tree_admin_allbooks.item(i, tags=("oddrow",))
        
    def filter_radiobutton():
        heading_filter_option = heading_filter.get()
        asc_desc = radio_var_1.get()
        available_unavailable = radio_var_2.get()
        # Modify the SQL query based on the selected status
        if available_unavailable == 'Both':
            sql_filter_books = f"""SELECT * FROM {books_detail} ORDER BY {heading_filter_option} {asc_desc};"""
        else:
            sql_filter_books = f"""SELECT * FROM {books_detail} WHERE status = ? ORDER BY {heading_filter_option} {asc_desc};"""

        # Remove existing items in the Treeview
        try:
            for item in tree_admin_allbooks.get_children():
                tree_admin_allbooks.delete(item)
        except Exception as e:
            pass

        if available_unavailable == 'Both':
            cur.execute(sql_filter_books)
        else:
            cur.execute(sql_filter_books, (available_unavailable,))

        filtered_books = cur.fetchall()

        if filtered_books:
            # Insert data into the Treeview
            for row in filtered_books:
                tree_admin_allbooks.insert("", "end", values=row)
                # Filling empty space into the Treeview
            for i in range(40 - get_treeview_length(tree_admin_allbooks)):
                tree_admin_allbooks.insert("", "end", values=['-','-','-','-','-'])

        else:
            # Insert data into the Treeview
            for i in range(40):
                tree_admin_allbooks.insert("", "end", values=['-','-','-','-','-'])

        # Applying row colours
        for i in tree_admin_allbooks.get_children():
            index = tree_admin_allbooks.index(i)
            if index % 2 == 0:
                tree_admin_allbooks.tag_configure("evenrow", background="#3a3a3a")
                tree_admin_allbooks.item(i, tags=("evenrow",))
            else:
                tree_admin_allbooks.tag_configure("oddrow", background="#2b2b2b")
                tree_admin_allbooks.item(i, tags=("oddrow",))

    def search_bookname(event):
        by = search_heading_filter.get()
        letters = entry_search_bookname.get()
        heading_filter_option = heading_filter.get()
        asc_desc = radio_var_1.get()
        available_unavailable = radio_var_2.get()
        # Modify the SQL query based on the selected status
        if available_unavailable == 'Both':
            sql_filter_books = f"""SELECT * FROM {books_detail} WHERE {by} LIKE ? ORDER BY {heading_filter_option} {asc_desc};"""
        else:
            sql_filter_books = f"""SELECT * FROM {books_detail} WHERE status = ? AND {by} LIKE ? ORDER BY {heading_filter_option} {asc_desc};"""

        # Remove existing items in the Treeview
        try:
            for item in tree_admin_allbooks.get_children():
                tree_admin_allbooks.delete(item)
        except Exception as e:
            pass

        if available_unavailable == 'Both':
            cur.execute(sql_filter_books, ('%' + letters + '%',))
        else:
            cur.execute(sql_filter_books, (available_unavailable, '%' + letters + '%'))

        filtered_books = cur.fetchall()

        if filtered_books:
            # Insert data into the Treeview
            for row in filtered_books:
                tree_admin_allbooks.insert("", "end", values=row)
                # Filling empty space into the Treeview
            for i in range(40 - get_treeview_length(tree_admin_allbooks)):
                tree_admin_allbooks.insert("", "end", values=['-','-','-','-','-'])

        else:
            # Insert data into the Treeview
            for i in range(40):
                tree_admin_allbooks.insert("", "end", values=['-','-','-','-','-'])

        # Applying row colours
        for i in tree_admin_allbooks.get_children():
            index = tree_admin_allbooks.index(i)
            if index % 2 == 0:
                tree_admin_allbooks.tag_configure("evenrow", background="#3a3a3a")
                tree_admin_allbooks.item(i, tags=("evenrow",))
            else:
                tree_admin_allbooks.tag_configure("oddrow", background="#2b2b2b")
                tree_admin_allbooks.item(i, tags=("oddrow",))


    button_filter_frame_up_button = CTkButton(filter_frame, text='⬆ Filter ⬆',border_width=4,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_filter_up_allbooks(tree_frame, filter_frame))
    button_filter_frame_up_button.place(relx=0, rely=0.8, relwidth=1, relheight=0.2)

    ###   Filter Keys   ###
    filter_label = CTkLabel(filter_frame,text='Filter : ',font=('Roboto',20))
    filter_label.place(relx=0.01, rely=0.05)

    heading_filter = CTkOptionMenu(filter_frame, values=['bid','title','subject','author', 'status'], button_color='#e40b0b',
        dropdown_fg_color='#ff3737', dropdown_hover_color='#f50f0f', fg_color='#f50f0f', command=filter_optionmenu)
    heading_filter.place(relx=0.1, rely=0.1, relwidth=0.1, relheight=0.2)

    radio_var_1 = tk.StringVar(filter_frame, value='ASC')
    radio_button_1 = CTkRadioButton(filter_frame, variable=radio_var_1, value='ASC', text='Ascending',
        font=('Roboto',16,), fg_color='#f50f0f', hover_color='#ff3737', command=filter_radiobutton)
    radio_button_1.place(relx=0.1, rely=0.4, relwidth=0.1, relheight=0.15)
    radio_button_2 = CTkRadioButton(filter_frame, variable=radio_var_1, value='DESC', text='Descending',
        font=('Roboto',16,), fg_color='#f50f0f', hover_color='#ff3737', command=filter_radiobutton)
    radio_button_2.place(relx=0.1, rely=0.6, relwidth=0.1, relheight=0.15)

    status_label = CTkLabel(filter_frame,text='Status : ',font=('Roboto',18))
    status_label.place(relx=0.25, rely=0.03)

    radio_var_2 = tk.StringVar(filter_frame, value="Both")
    radio_button_3 = CTkRadioButton(filter_frame, variable=radio_var_2, value="Both", text='Both',
        font=('Roboto',16,), fg_color='#f50f0f', hover_color='#ff3737', command=filter_radiobutton)
    radio_button_3.place(relx=0.25, rely=0.23, relwidth=0.1, relheight=0.15)
    radio_button_4 = CTkRadioButton(filter_frame, variable=radio_var_2, value='Available', text='Available',
        font=('Roboto',16,), fg_color='#f50f0f', hover_color='#ff3737', command=filter_radiobutton)
    radio_button_4.place(relx=0.25, rely=0.43, relwidth=0.1, relheight=0.15)
    radio_button_5 = CTkRadioButton(filter_frame, variable=radio_var_2, value='Unavailable', text='Unavailable',
        font=('Roboto',16,), fg_color='#f50f0f', hover_color='#ff3737', command=filter_radiobutton)
    radio_button_5.place(relx=0.25, rely=0.63, relwidth=0.1, relheight=0.15)

    ####   Search Frame   ####
    search_frame = CTkFrame(filter_frame, border_width=4, corner_radius=0, fg_color='#2b2b2b')
    search_frame.place(relx=0.5, rely=0, relwidth=0.51, relheight=0.8)

    label_search = CTkLabel(search_frame,text='Search Book : ',font=('Roboto',20))
    label_search.place(relx=0.05, rely=0.05)
    
    search_heading_filter = CTkOptionMenu(search_frame, values=['title','subject','author','bid'], button_color='#e40b0b',
        dropdown_fg_color='#ff3737', dropdown_hover_color='#f50f0f', fg_color='#f50f0f')
    search_heading_filter.place(relx=0.05, rely=0.4, relwidth=0.2, relheight=0.3)

    entry_search_bookname = CTkEntry(search_frame, placeholder_text=' '*3+'Enter Book Name', border_width=2,corner_radius=0, font=('Roboto',18,),)
    entry_search_bookname.bind('<KeyRelease>',search_bookname)
    entry_search_bookname.bind('<KeyRelease>',search_bookname)
    entry_search_bookname.place(relx=0.3, rely=0.4, relwidth=0.5, relheight=0.3)

def admin_filter_up_allbooks(tree_frame, filter_frame):
    global admin_filter_allbooks
    admin_filter_allbooks = False
    if admin_more_allbooks == False and admin_filter_allbooks == False:
        tree_frame.place(relx=0, rely=0.04, relwidth=1, relheight=0.8)
    elif admin_more_allbooks == False and admin_filter_allbooks == True:
        tree_frame.place(relx=0, rely=0.2, relwidth=1, relheight=0.64)
    elif admin_more_allbooks == True and admin_filter_allbooks == False:
        tree_frame.place(relx=0, rely=0.04, relwidth=1, relheight=0.61)
    elif admin_more_allbooks == True and admin_filter_allbooks == True:
        tree_frame.place(relx=0, rely=0.2, relwidth=1, relheight=0.45)
        
    # tree_frame.place(relx=0, rely=0.04, relwidth=1, relheight=0.86)
    filter_frame.place(relx=0, rely=0, relwidth=1, relheight=0.04)
    try:
        for widget in filter_frame.winfo_children():
            widget.destroy()
    except:
        pass
    button_filter_frame_down = CTkButton(filter_frame, text='⬇ Filter ⬇',border_width=4,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_filter_down_allbooks(tree_frame, filter_frame))
    button_filter_frame_down.place(relx=0, rely=0, relwidth=1, relheight=1)

def admin_remove_books(entry_bid):
    bid = entry_bid.get()
    cur.execute(f"SELECT * FROM {books_detail} WHERE bid=?", (bid,))
    result = cur.fetchone()
    if result:
        cur.execute(f"SELECT status FROM {books_detail} WHERE bid=?", (bid,))
        bid_result = cur.fetchone()
        
        cur.execute(f"SELECT bid, title, subject, author FROM {books_detail} WHERE bid=?", (bid,))
        book_result = cur.fetchone()
        bid, title, subject, author = book_result
        
        if bid_result and bid_result[0] == "Available":
            cur.execute(f"DELETE FROM {books_detail} WHERE bid = ?", (bid, ))
            
            CTkMessagebox(title="Deleted!", message=f"You Deleted a Book...\nBID : {bid}\nTitle : {title}\nSubject : {subject}\nAuthor : {author}", icon='check', option_1='Okay', font=("Arial", 15))
        else:
           CTkMessagebox(title="Can't Delete", message=f"The Book\nBID : {bid}\nTitle : {title}\nSubject : {subject}\nAuthor : {author}\nYou want to Delete is Borrowed at the moment.\nPlease try later", icon="warning", option_1="Cancel", font=("Arial", 15)) 
    else:
        CTkMessagebox(title="No Book", message=f"No Book with BID '{bid}' found \nin our Database..", icon='cancel', option_1='Okay', font=("Arial", 15))

def admin_remove_allbooks():
    sql_remove_allbooks = f"""SELECT bid FROM {books_detail};"""
    cur.execute(sql_remove_allbooks,)
    remove_books = cur.fetchall()
    
    if remove_books:
        confirm = CTkMessagebox(title="Confirmation", message=f"Are you Sure You want to\nDELETE ALL Books?!\nNo Book will be left in the database...", icon='info', option_1="NO, I Don't", option_2="Yes, I want to")
        if confirm.get() == "Yes, I want to":
            confirm2 = CTkMessagebox(title="Confirmation", message=f"Are you REALLY, REALLY Sure You want to\nDELETE ALL Books?!", icon='info', option_1="NO, I changed my mind", option_2="Yes, Totally")
            if confirm2.get() == "Yes, Totally":
                for bid_value in remove_books:
                    sql_remove_books = f"""DELETE FROM {books_detail} WHERE bid = ? WHERE status = 'Unavailable';"""
                    cur.execute(sql_remove_books, (bid_value[0],))

                CTkMessagebox(title="Deleted!", message=f"All Books Deleted\nSuccessfully!", icon='check', option_1='Okay', font=("Arial", 15))
    else:
        CTkMessagebox(title="No Book", message=f"No Book found \nin Books Database..", icon='cancel', option_1='Okay', font=("Arial", 15))

def admin_more_up_allbooks(tree_frame, remove_books_frame):
    global admin_more_allbooks
    admin_more_allbooks = True
    if admin_more_allbooks == False and admin_filter_allbooks == False:
        tree_frame.place(relx=0, rely=0.04, relwidth=1, relheight=0.8)
    elif admin_more_allbooks == False and admin_filter_allbooks == True:
        tree_frame.place(relx=0, rely=0.2, relwidth=1, relheight=0.64)
    elif admin_more_allbooks == True and admin_filter_allbooks == False:
        tree_frame.place(relx=0, rely=0.04, relwidth=1, relheight=0.61)
    elif admin_more_allbooks == True and admin_filter_allbooks == True:
        tree_frame.place(relx=0, rely=0.2, relwidth=1, relheight=0.45)
        
    remove_books_frame.place(relx=0, rely=0.65, relwidth=1, relheight=0.35)

    try:
        for widget in remove_books_frame.winfo_children():
            widget.destroy()
    except:
        pass
    
    button_more_down = CTkButton(remove_books_frame, text='Less',border_width=4,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_more_down_allbooks(tree_frame, remove_books_frame))
    button_more_down.place(relx=0, rely=0, relwidth=1, relheight=0.1)

    label_remove_books = CTkLabel(remove_books_frame,text='Remove Book : ',font=('Roboto',20))
    label_remove_books.place(relx=0.1, rely=0.19)

    entry_remove_books_bid = CTkEntry(remove_books_frame, placeholder_text=' '*3+'Enter BID', border_width=2,corner_radius=0, font=('Roboto',18,),)
    entry_remove_books_bid.place(relx=0.23, rely=0.19, relwidth=0.2, relheight=0.14)
    
    button_remove_book_bid = CTkButton(remove_books_frame, text='Remove',border_width=2,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_remove_books(entry_remove_books_bid))
    button_remove_book_bid.place(relx=0.5, rely=0.19, relwidth=0.15, relheight=0.14)
    
    button_remove_allbook = CTkButton(remove_books_frame, text='Remove ALL',border_width=2,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_remove_allbooks())
    button_remove_allbook.place(relx=0.7, rely=0.19, relwidth=0.2, relheight=0.14)

    ### ADD BOOKS
    label_add_books = CTkLabel(remove_books_frame,text='ADD Book : ',font=('Roboto',24))
    label_add_books.place(relx=0.04, rely=0.38)

    sql_total_books = f"""SELECT COUNT(*) AS total_books FROM {books_detail};"""
    cur.execute(sql_total_books)
    total_books = cur.fetchone()[0]

    label_bid = CTkLabel(remove_books_frame,text='BID : ',font=('Roboto',20))
    label_bid.place(relx=0.1, rely=0.5)
    entry_bid = CTkEntry(remove_books_frame, border_width=2,corner_radius=0,font=('Roboto',18,),)
    entry_bid.place(relx=0.1, rely=0.61, relwidth=0.07, relheight=0.14)
    entry_bid.insert(0,'B'+str(total_books+1))
    entry_bid.configure(state="disabled")
    
    label_title = CTkLabel(remove_books_frame,text='Title : ',font=('Roboto',20))
    label_title.place(relx=0.2, rely=0.5)
    entry_title = CTkEntry(remove_books_frame, placeholder_text='Title of the book', border_width=2,corner_radius=0,font=('Roboto',18,),)
    entry_title.place(relx=0.2, rely=0.61, relwidth=0.24, relheight=0.14)
    
    label_subject = CTkLabel(remove_books_frame,text='Subject : ',font=('Roboto',20))
    label_subject.place(relx=0.48, rely=0.5)
    entry_subject = CTkEntry(remove_books_frame, placeholder_text='Subject of the book', border_width=2,corner_radius=0,font=('Roboto',18,),)
    entry_subject.place(relx=0.48, rely=0.61, relwidth=0.24, relheight=0.14)
    
    label_author = CTkLabel(remove_books_frame,text='Author : ',font=('Roboto',20))
    label_author.place(relx=0.76, rely=0.5)
    entry_author = CTkEntry(remove_books_frame, placeholder_text='Name of the Author', border_width=2,corner_radius=0,font=('Roboto',18,),)
    entry_author.place(relx=0.76, rely=0.61, relwidth=0.22, relheight=0.14)
    
    button_add_book = CTkButton(remove_books_frame, text='Add Book',border_width=2,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_add_book(entry_bid, entry_title, entry_subject, entry_author))
    button_add_book.place(relx=0.4, rely=0.82, relwidth=0.2, relheight=0.14)

def admin_add_book(entry_bid, entry_title, entry_subject, entry_author):
    entry_bid.configure(state='normal')
    bid = entry_bid.get()
    entry_bid.configure(state="disabled")
    title = entry_title.get()
    subject = entry_subject.get()
    author = entry_author.get()
    status = 'Available'
    
    values = (bid, title, subject, author, status)
    sql_add = f"INSERT OR IGNORE INTO {books_detail} Values (?, ?, ?, ?, ?)"
    try:
        cur.execute(sql_add, values,)
        CTkMessagebox(title="Success!", message=f"The Book...\nBID : {bid}\nTitle : {title}\nSubject : {subject}\nAuthor : {author}\n has been Added", icon='check', option_1='Okay', font=("Arial", 17))
    except Exception as e:
        CTkMessagebox(title="Error!", message=f"The Book...\nBID : {bid}\nCAN'T be Added\n{e}", icon='cancel', option_1='Okay', font=("Arial", 17))

def admin_more_down_allbooks(tree_frame, remove_books_frame):
    global admin_more_allbooks
    admin_more_allbooks = False
    if admin_more_allbooks == False and admin_filter_allbooks == False:
        tree_frame.place(relx=0, rely=0.04, relwidth=1, relheight=0.8)
    elif admin_more_allbooks == False and admin_filter_allbooks == True:
        tree_frame.place(relx=0, rely=0.2, relwidth=1, relheight=0.64)
    elif admin_more_allbooks == True and admin_filter_allbooks == False:
        tree_frame.place(relx=0, rely=0.04, relwidth=1, relheight=0.61)
    elif admin_more_allbooks == True and admin_filter_allbooks == True:
        tree_frame.place(relx=0, rely=0.2, relwidth=1, relheight=0.45)
    
    # tree_frame.place(relx=0, rely=0.04, relwidth=1, relheight=0.8)
    remove_books_frame.place(relx=0, rely=0.84, relwidth=1, relheight=0.16)

    try:
        for widget in remove_books_frame.winfo_children():
            widget.destroy()
    except:
        pass
    button_more_up = CTkButton(remove_books_frame, text='More',border_width=4,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_more_up_allbooks(tree_frame, remove_books_frame))#lambda: admin_borrow_books(entry_borrow_bid))
    button_more_up.place(relx=0, rely=0, relwidth=1, relheight=0.25)

    label_remove_books = CTkLabel(remove_books_frame,text='Remove Book : ',font=('Roboto',20))
    label_remove_books.place(relx=0.1, rely=0.4)

    entry_remove_books_bid = CTkEntry(remove_books_frame, placeholder_text=' '*3+'Enter BID', border_width=2,corner_radius=0, font=('Roboto',18,),)
    entry_remove_books_bid.place(relx=0.23, rely=0.4, relwidth=0.2, relheight=0.3)
    
    button_remove_book_bid = CTkButton(remove_books_frame, text='Remove',border_width=2,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_remove_books(entry_remove_books_bid))
    button_remove_book_bid.place(relx=0.5, rely=0.4, relwidth=0.15, relheight=0.3)
    
    button_remove_allbook = CTkButton(remove_books_frame, text='Remove ALL',border_width=2,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_remove_allbooks())
    button_remove_allbook.place(relx=0.7, rely=0.4, relwidth=0.2, relheight=0.3)


# >>>>>> Manage Users Window for Admin
def admin_manage_users():
    # Remove all the widgets from the main_second_frame_admin_win
    try:
        for widget in main_second_frame_admin_win.winfo_children():
            widget.destroy()
    except:
        pass
    def on_select(event):
        selected_item = tree_student_data.selection()
    
    # student_count frame
    student_count_frame = CTkFrame(main_second_frame_admin_win, border_width=0, corner_radius=0)
    student_count_frame.place(relx=0, rely=0, relwidth=1, relheight=0.9)
    
    ## Tree View for Students Statistics
    treeframe_statistics = CTkFrame(student_count_frame, border_width=0, corner_radius=0)
    treeframe_statistics.place(relx=0, rely=0, relwidth=1, relheight=1)

    # Create a ttk.Treeview widget inside the treeframe_statistics
    scrollbar = CTkScrollbar(treeframe_statistics, orientation='vertical')
    tree_student_data = ttk.Treeview(treeframe_statistics, show="headings", style="Custom.Treeview", )
    tree_student_data["columns"] = ("username", "count",)
    # Define column headings
    tree_student_data.heading("username", text="Username")
    tree_student_data.heading("count", text="No. Of Borrowed Books")

    tree_student_data.column("username", width=100, anchor="center",)
    tree_student_data.column("count", width=250, anchor="center",)

    #######    Inserting Data into the treeview
    sql_studbooks_books = f"""SELECT username, COUNT(username) AS total_count
                                FROM {book_issue_detail} GROUP BY username;"""
    cur.execute(sql_studbooks_books,)
    student_books = cur.fetchall()

    if student_books:
        # Remove existing items in the Treeview
        try:
            for item in tree_student_data.get_children():
                tree_student_data.delete(item)
        except:
            pass
        # Insert data into the Treeview
        for row in student_books:
            tree_student_data.insert("", "end", values=row)

        # Filling empty space into the Treeview
        for i in range(40 - get_treeview_length(tree_student_data)):
            tree_student_data.insert("", "end", values=['-','-','-','-'])
    else:
        # Insert data into the Treeview
        for i in range(40):
            tree_student_data.insert("", "end", values=['-','-','-','-'])
    
    # Defining a custom style
    style = ttk.Style()
    style.configure("Custom.Treeview", foreground="white", font=("Arial", 10))
    # Applying the style to the TreeView
    tree_student_data.tag_configure("Custom.Treeview",)
    # Changing the color of the even rows
    style.configure("evenrow", background="#2b2b2b")
    # Changing the color of the odd rows
    style.configure("oddrow", background="#3a3a3a")
    # Applying tags to all items
    for i in tree_student_data.get_children():
        index = tree_student_data.index(i)
        if index % 2 == 0:
            tree_student_data.tag_configure("evenrow", background="#3a3a3a")
            tree_student_data.item(i, tags=("evenrow",))
        else:
            tree_student_data.tag_configure("oddrow", background="#2b2b2b")
            tree_student_data.item(i, tags=("oddrow",))

    # Changing the color of selected row
    style.map("Treeview",
            foreground=[('selected', 'white')],
            background=[('selected', '#ff3535')])
    # Binding the selection event
    tree_student_data.bind("<ButtonRelease-1>", on_select)

    scrollbar.pack(side='right', fill='y')
    scrollbar.configure(command= tree_student_data.yview)
    tree_student_data.configure(yscrollcommand=scrollbar.set)
    tree_student_data.pack(expand=True, fill="both")


    # student_search frame
    student_search_frame = CTkFrame(main_second_frame_admin_win, border_width=0, corner_radius=0)
    student_search_frame.place(relx=0, rely=0.9, relwidth=1, relheight=0.1)

    label_search_student = CTkLabel(student_search_frame,text='Search User : ',font=('Roboto',20))
    label_search_student.place(relx=0.3, rely=0.25)

    entry_search_student_id = CTkEntry(student_search_frame, placeholder_text=' '*3+'Enter Username', border_width=2,corner_radius=0, font=('Roboto',18,),)
    entry_search_student_id.place(relx=0.43, rely=0.25, relwidth=0.2, relheight=0.5)
    
    button_search_student_id = CTkButton(student_search_frame, text='Search',border_width=2,corner_radius=0,border_color='#e40b0b',
        fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_searched_user(entry_search_student_id))
    button_search_student_id.place(relx=0.7, rely=0.25, relwidth=0.15, relheight=0.5)

def admin_searched_user(username_entry):
    username = username_entry.get()
    
    sql_student_username = f"SELECT username FROM {student_detail} WHERE username = ?"
    cur.execute(sql_student_username, (username,))
    info_username = cur.fetchone()     # Fetch the first result
    
    if info_username:
        # Remove all the widgets from the main_second_frame_admin_win
        try:
            for widget in main_second_frame_admin_win.winfo_children():
                widget.destroy()
        except:
            pass
        
        def on_select(event):
            selected_item = tree_student_borrowedbooks.selection()

        sql_student_class = f"SELECT class FROM {student_detail} WHERE username = ?"
        cur.execute(sql_student_class, (username,))
        info_class = cur.fetchone()

        sql_student_email = f"SELECT email FROM {student_detail} WHERE username = ?"
        cur.execute(sql_student_email, (username,))
        info_email = cur.fetchone()
        
        sql_student_pfp = f"SELECT pfp FROM {student_detail} WHERE username = ?"
        cur.execute(sql_student_pfp, (username,))
        info_pfp = cur.fetchone()
        info_pfp = info_pfp[0]

        # Profile frame
        profile_frame = CTkFrame(main_second_frame_admin_win, border_width=0, corner_radius=0)
        profile_frame.place(relx=0, rely=0, relwidth=1, relheight=0.5)
        
        pfp_frame = CTkFrame(profile_frame, border_width=0, corner_radius=0, fg_color="#2b2b2b")
        pfp_frame.place(relx=0.4, rely=0.06, relwidth=0.2, relheight=0.6)
        
        # Load and display the image
        image_path = os.path.join(pfp_dir, info_pfp)
        image = Image.open(image_path)
        if image:
            pfp_image = CTkImage(dark_image=image, size=(220,220))
            pfp_label = CTkLabel(pfp_frame, text='', image = pfp_image)
        else:
            pfp_label = CTkLabel(pfp_frame, text='\n    No image found...', image = None)
        pfp_label.place(relx=0, rely=-0, relwidth=1, relheight=1)

        name_label = CTkLabel(profile_frame,text='Username : ',font=('Roboto',20))
        name_label.place(relx=0.1, rely=0.66)
        name_entry = CTkEntry(profile_frame, border_width=0,corner_radius=0, font=('Roboto',18,),)
        name_entry.place(relx=0.2, rely=0.66, relwidth=0.3, relheight=0.1)
        name_entry.insert(0,info_username)
        name_entry.configure(state="disabled")

        class_label = CTkLabel(profile_frame,text='Class : ',font=('Roboto',20))
        class_label.place(relx=0.6, rely=0.66)
        class_entry = CTkEntry(profile_frame, border_width=0,corner_radius=0,font=('Roboto',18,),)
        class_entry.place(relx=0.67, rely=0.66, relwidth=0.1, relheight=0.1)
        class_entry.insert(0,info_class)
        class_entry.configure(state="disabled")

        email_label = CTkLabel(profile_frame,text='Email : ',font=('Roboto',20))
        email_label.place(relx=0.1, rely=0.8)
        email_entry = CTkEntry(profile_frame, border_width=0,corner_radius=0,font=('Roboto',18,),)
        email_entry.place(relx=0.2, rely=0.8, relwidth=0.4, relheight=0.1)
        email_entry.insert(0,info_email)
        email_entry.configure(state="disabled")
        
        text_label = CTkLabel(profile_frame,text='Borrowed Books : ',font=('Roboto',20))
        text_label.place(relx=0.05, rely=0.9)


        # Borrowed Books Frame
        tree_frame_borrowedbooks = CTkFrame(main_second_frame_admin_win, border_width=0, corner_radius=0)
        tree_frame_borrowedbooks.place(relx=0, rely=0.5, relwidth=1, relheight=0.4)

        # Create a ttk.Treeview widget inside the tree_frame_borrowedbooks
        scrollbar = CTkScrollbar(tree_frame_borrowedbooks, orientation='vertical')
        tree_student_borrowedbooks = ttk.Treeview(tree_frame_borrowedbooks, show="headings", style="Custom.Treeview", )
        tree_student_borrowedbooks["columns"] = ("bid","title","subject","author",)
        # Define column headings
        tree_student_borrowedbooks.heading("bid", text="BID")
        tree_student_borrowedbooks.heading("title", text="Title")
        tree_student_borrowedbooks.heading("subject", text="Subject")
        tree_student_borrowedbooks.heading("author", text="Author")

        tree_student_borrowedbooks.column("bid", width=50, anchor="center",)
        tree_student_borrowedbooks.column("title", width=250, anchor="w",)
        tree_student_borrowedbooks.column("subject", width=100, anchor="w",)
        tree_student_borrowedbooks.column("author", width=100, anchor="w",)

        #######    Inserting Data into the treeview
        sql_borrowed_books = f"""SELECT {books_detail}.bid, {books_detail}.title, {books_detail}.subject, {books_detail}.author
        FROM {books_detail}
        JOIN {book_issue_detail} ON {books_detail}.bid = {book_issue_detail}.bid
        JOIN {student_detail} ON {book_issue_detail}.username = {student_detail}.username
        WHERE {student_detail}.username = ?;"""
        cur.execute(sql_borrowed_books, (username,))
        borrowed_books = cur.fetchall()

        if borrowed_books:
            # Remove existing items in the Treeview
            try:
                for item in tree_student_borrowedbooks.get_children():
                    tree_student_borrowedbooks.delete(item)
            except:
                pass
            # Insert data into the Treeview
            for row in borrowed_books:
                tree_student_borrowedbooks.insert("", "end", values=row)
                
            # Filling empty space into the Treeview
            for i in range(20 - get_treeview_length(tree_student_borrowedbooks)):
                tree_student_borrowedbooks.insert("", "end", values=['-','-','-','-'])
        else:
            # Insert data into the Treeview
            for i in range(20):
                tree_student_borrowedbooks.insert("", "end", values=['-','-','-','-'])
        
        # Defining a custom style
        style = ttk.Style()
        style.configure("Custom.Treeview", foreground="white", font=("Arial", 10))
        # Applying the style to the TreeView
        tree_student_borrowedbooks.tag_configure("Custom.Treeview",)
        # Changing the color of the even rows
        style.configure("evenrow", background="#2b2b2b")
        # Changing the color of the odd rows
        style.configure("oddrow", background="#3a3a3a")
        # Applying tags to all items
        for i in tree_student_borrowedbooks.get_children():
            index = tree_student_borrowedbooks.index(i)
            if index % 2 == 0:
                tree_student_borrowedbooks.tag_configure("evenrow", background="#3a3a3a")
                tree_student_borrowedbooks.item(i, tags=("evenrow",))
            else:
                tree_student_borrowedbooks.tag_configure("oddrow", background="#2b2b2b")
                tree_student_borrowedbooks.item(i, tags=("oddrow",))

        # Changing the color of selected row
        style.map("Treeview",
                foreground=[('selected', 'white')],
                background=[('selected', '#ff3535')])
        # Binding the selection event
        tree_student_borrowedbooks.bind("<ButtonRelease-1>", on_select)

        scrollbar.pack(side='right', fill='y')
        scrollbar.configure(command= tree_student_borrowedbooks.yview)
        tree_student_borrowedbooks.configure(yscrollcommand=scrollbar.set)
        tree_student_borrowedbooks.pack(expand=True, fill="both")
    
        # student_search frame
        student_search_frame = CTkFrame(main_second_frame_admin_win, border_width=0, corner_radius=0)
        student_search_frame.place(relx=0, rely=0.9, relwidth=1, relheight=0.1)

        button_back_student_id = CTkButton(student_search_frame, text='Back',border_width=2,corner_radius=0,border_color='#e40b0b',
            fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: back_button_admin())
        button_back_student_id.place(relx=0.05, rely=0.25, relwidth=0.15, relheight=0.5)

        label_search_student = CTkLabel(student_search_frame,text='Search User : ',font=('Roboto',20))
        label_search_student.place(relx=0.3, rely=0.25)

        entry_search_student_id = CTkEntry(student_search_frame, placeholder_text=' '*3+'Enter Username', border_width=2,corner_radius=0, font=('Roboto',18,),)
        entry_search_student_id.place(relx=0.43, rely=0.25, relwidth=0.2, relheight=0.5)
        
        button_search_student_id = CTkButton(student_search_frame, text='Search',border_width=2,corner_radius=0,border_color='#e40b0b',
            fg_color='#f50f0f', hover_color='#ff3737',font=('Roboto',22,),command=lambda: admin_searched_user(entry_search_student_id))
        button_search_student_id.place(relx=0.7, rely=0.25, relwidth=0.15, relheight=0.5)
    
    else:
        CTkMessagebox(title='No User', message=f"NO User with Username '{username}'\nfound in the Database...", icon='calcel', option_1='Okay')

def back_button_admin():
    admin_manage_users()

main_win()
# student_main_win()

root.mainloop()