main.py

# Including tkinter header to create and manage ui's
from tkinter import messagebox
from tkinter import *

# Using mysql-connector-python for mysql python connection
import mysql.connector as mc

# Using customtkinter module for modern tkinter button
import customtkinter

# Using Pillow module for the support of jpg images and resizing the images into specified
from PIL import Image, ImageTk

# Using tkcalendar module to get date from leave entry into yyyy-mm-dd format
from tkcalendar import DateEntry

# Using time module to set program delay
import time

# MySQL Objects and connection string
cnx = mc.connect(host="localhost", user="alen",
                 password="alen", database="school")
#Setting buffered to True to get rid of unread results found error
cur = cnx.cursor(buffered=True)
cnx.autocommit = True

"""
Home function is the default home page. It consists of the  login page. It asks the user which group he/she belongs to ie (student, teacher, staff, admin)
"""
def home():
    window = Tk()
    window.title("SCHOOL MANAGEMENT SYSTEM")
    window.geometry("960x606")
    window.resizable(0, 0)
    window.iconbitmap("./ico/school.ico")

    # Creating background image variable
    bg = PhotoImage(file="./img/login.png")

    # Creating the background label
    l1 = Label(window, image=bg)
    l1.place(x=0, y=0)

    # Creating the login text
    l2 = Label(window, text="LOGIN", font=(
        "times new roman", 20, "bold"), bg="#184800", fg="#ff007f")
    l2.place(x=441, y=23)

    # Creating the student button
    l3 = Button(window, text="STUDENT", width=15, font=(
        "times new roman", 10, "bold"), command=lambda: stud_lgn_btn(window))
    l3.place(x=435, y=100)

    # Creating the teacher button
    l4 = Button(window, text="TEACHER", width=15, font=(
        "times new roman", 10, "bold"), command=lambda: teacher_lgn_btn(window))
    l4.place(x=435, y=140)

    # Creating the staff button
    l5 = Button(window, text="STAFF", width=15, font=(
        "times new roman", 10, "bold"), command=lambda: staff_lgn_btn(window))
    l5.place(x=435, y=180)

    window.mainloop()

"""
The stud_lgn_btn() is a function that changes the window from home window to student login widnow.
It accepts the parent window as it's param and destroys the window
This page consists of username and password entry and a submit button
The username and password are passed on to the username_var and password_var text variables respectively
Then the submit button calls on the command stud_lgn()
"""
def stud_lgn_btn(window):
    # Killing the previous window and moving to the student window
    window.destroy()

    # Making the tkinter window global
    global root

    # Creating new window
    root = Tk()

    root.title("STUDENT LOGIN")
    root.geometry("960x600")
    root.resizable(0, 0)
    root.iconbitmap("./ico/student.ico")

    # Creating String Vars
    global username_var
    global passw_var
    username_var = StringVar()
    passw_var = StringVar()

    # Creating the background image variable
    bg = PhotoImage(file="./img/all_lgn.png")

    # Creating the label background
    l1 = Label(root, image=bg)
    l1.place(x=0, y=0)

    # Creating student login text
    l2 = Label(root, text="STUDENT LOGIN", background="#413E91",
               font=("times new roman", 20, "bold"), fg="black")
    l2.place(x=385, y=13)

    # Creating the login username text
    lgnt1 = Label(root, text="USERNAME", font=("times new roman", 10, "bold"))
    lgnt1.place(x=40, y=140)

    # Creating the username login entry form
    global user
    user = Entry(root, textvariable=username_var, width=20)
    user.place(x=140, y=140)

    # Creating the login password text
    lgnt2 = Label(root, text="PASSWORD", font=("times new roman", 10, "bold"))
    lgnt2.place(x=40, y=180)

    # Creating the password entry form
    pswd = Entry(root, textvariable=passw_var, width=20, show="*")
    pswd.place(x=140, y=180)

    # Creating the submit button
    submit = Button(root, text="SUBMIT", command=stud_lgn)
    submit.place(x=130, y=220)

    root.mainloop()

"""
The stud_lgn() function is used to check for the username and password in the database and make further movements
Tt uses the global username_var and password_var for checking the values
It used .get() method to get the str() return of the entered value from the report
Then that value is used to validate the student using mysql connection

If the entered value is correct then this window proceeds into stud_home()
If not then the window will show an error message stating 'Cannot find such a user with the given username and passweord. Please retry'
"""
def stud_lgn():
    name = username_var.get()
    passw = passw_var.get()

    cur.execute(
        "SELECT * FROM STUDENTS WHERE USERNAME=%s AND PASSWORD=%s", (name, passw))

    a = cur.fetchone()

    global L
    L = []

    if a !=None and len(a) != 0:
        for k in a:
            L.append(k)

        root.destroy()
        stud_home()

    else:
        messagebox.showerror(
            "User nor found", "Cannot find such a user with the given username and password. Please retry")

    username_var.set("")
    passw_var.set("")

"""
This function is the student' home page
This is proceeded from the stud_lgn(), if the entered credentials are correct then the student proceeds into the home page
The home page consists of 4 buttons namely, PROFILE, LEAVE ENTRY, ACADEMICS AND LOGOUT
When the user clicks on the button it proceeds into the next page
"""
def stud_home():
    # Setting window appearance mode
    customtkinter.set_appearance_mode("dark")

    # Setting default color theme
    customtkinter.set_default_color_theme("dark-blue")

    # Creating the student home window
    shw = customtkinter.CTk()

    shw.title("STUDENT HOME")
    shw.geometry("941x619")
    shw.resizable(0, 0)
    shw.iconbitmap("./ico/student.ico")

    # Creating the background variable for the window
    bg = PhotoImage(file="./img/stud_home.png")

    # Setting up the background
    l1 = Label(shw, image=bg)
    l1.place(x=0, y=0)

    # Creating a label for user details
    l2 = Label(shw, text="WELCOME TO STUDENT HOME", font=("Consolas", 20, "bold"), fg="white", bg="black")
    l2.pack()

    # Creating image variable for icon Images
    std_profile = ImageTk.PhotoImage(Image.open("./icons/std_profile.png").resize((20, 20), Image.Resampling.LANCZOS))
    lv_entry = ImageTk.PhotoImage(Image.open("./icons/leave_entry.jpg").resize((20, 20), Image.Resampling.LANCZOS))
    logout = ImageTk.PhotoImage(Image.open("./icons/logout.png").resize((20, 20), Image.Resampling.LANCZOS))

    # Student Profile button
    b1 = customtkinter.CTkButton(master=shw, width=150, height=40, text="PROFILE", image=std_profile, command=lambda: stud_profile(shw, L))
    b1.place(x=775, y=90)

    # Leave Entry Button
    b2 = customtkinter.CTkButton(master=shw, width=150, height=40, text="LEAVE ENTRY", image=lv_entry, command=lambda: stud_leave_entry(shw))
    b2.place(x=775, y=190)

    # Logout Button
    b4 = customtkinter.CTkButton(master=shw, width=150, height=40, text="LOGOUT", image=logout, command=lambda: all_logout(shw))
    b4.place(x=775, y=290)
    shw.mainloop()

"""
This function is the logout function
This function destroys the current window and then moves back to the home page
"""
def all_logout(window):
    window.destroy()
    home()

"""
This is the stud_profile function
It accepts 2 arguments
They accepted positional arguments are parentwindow and the list of the login details of the student
Firstly, the function destroys the parent window and opens up a new window
In the profile window the student is shown the profile icon, name, class and dob
"""
def stud_profile(pw, L):
    # Destroying parent window
    pw.destroy()

    customtkinter.set_appearance_mode("light")
    customtkinter.set_default_color_theme("dark-blue")

    spw = customtkinter.CTk()
    spw.resizable(0,0)

    spw.title("STUDENT PROFILE")
    spw.iconbitmap("./ico/student.ico")

    l1 = customtkinter.CTkLabel(master=spw, text="STUDENT PROFILE", text_font=("Consolas", 20, "italic"))
    l1.pack()

    # Creating the image variable for the profile picture image
    std_profile = ImageTk.PhotoImage(Image.open("./icons/std_profile1.jpg").resize((200, 200), Image.Resampling.LANCZOS))

    # Creating the label icon
    l1 = customtkinter.CTkLabel(master=spw, image=std_profile, bg_color="white")
    l1.place(x=200, y=70)

    # Placing name
    name = "Name: "
    l2 = customtkinter.CTkLabel(master=spw, text=name+L[1])
    l2.place(x=210, y=250)

    # Placing class
    grade = "Class: "
    l3 = customtkinter.CTkLabel(master=spw, text=grade+str(L[4])+' '+L[5])
    l3.place(x=210, y=270)

    # Placing DOB
    dob = "DOB: "
    l4 = customtkinter.CTkLabel(master=spw, text=dob+str(L[7]))
    l4.place(x=210, y=290)

    # Placing go back to student home
    b1 = customtkinter.CTkButton(master=spw, text="GO BACK TO PREVIOUS WINDOW", command=lambda: go_back_to_prev(spw))
    b1.place(x=172, y=330)

    spw.mainloop()

"""
This function is student leave entry function
This accepts the parent window as its argument
Firsty, this function destroyes the parent window

The new window has two date entry namely startdate and enddate
It also has the reason box where the parent has to enter the reason for the leave
"""
def stud_leave_entry(win):
    win.destroy()

    slew = customtkinter.CTk()
    slew.resizable(0,0)
    slew.iconbitmap("./ico/student.ico")
    slew.title("STUDENT LEAVE ENTRY")

    # Creating start date, end date and reason text variables
    global start_date
    global end_date
    global reason

    start_date = StringVar()
    end_date = StringVar()
    reason = StringVar()

    # Creating the heading
    l1 = customtkinter.CTkLabel(master=slew, text="LEAVE ENTRY", text_font=("times new roman", 21, "bold"))
    l1.pack()

    # Creating the start date text label
    l1 = customtkinter.CTkLabel(master=slew, text="START DATE", text_font=("Consolas", 12, "bold"))
    l1.place(x=30, y=90)

    # Creating start date button
    global b1
    b1 = DateEntry(master=slew, date_pattern="yyyy-mm-dd",textvariable=start_date)
    b1.place(x=250, y=100)

    l2 = customtkinter.CTkLabel(master=slew, text="END DATE", text_font=("Consolas", 12, "bold"))
    l2.place(x=30, y=160)

    global b2
    b2 = DateEntry(master=slew, date_pattern="yyyy-mm-dd", textvariable=end_date)
    b2.place(x=250, y=170)

    l3 = customtkinter.CTkLabel(master=slew, text="REASON", text_font=("Consolas", 12, "bold"))
    l3.place(x=30, y=220)

    global b3
    b3 = customtkinter.CTkEntry(master=slew, textvariable=reason, width=300)
    b3.place(x=190, y=220)

    # Creating the submit button
    submit = customtkinter.CTkButton(master=slew, text="Submit", command=lambda: stud_leave_entry_submit(slew))
    submit.place(x=190, y=270)

    # Creating go back to student home
    b4 = customtkinter.CTkButton(master=slew, text="GO BACK TO PREVIOUS WINDOW", command=lambda: go_back_to_prev(slew))
    b4.place(x=190, y=320)

    slew.mainloop()

"""
This function is called when the submit button in the stud_leave_entry() function is clicked
It then used .get() method to extract the str() values from the input
The inputted values are then passed into mysql and are stored in the stud_leave table
"""
def stud_leave_entry_submit(window):
    sd = start_date.get()
    ed = end_date.get()
    rs = reason.get()

    cur.execute("SELECT * FROM STUD_LEAVE")
    a = cur.rowcount

    cur.execute("INSERT INTO STUD_LEAVE(NAME, CLASS, DIVISION, STARTDATE, ENDDATE, REASON) VALUES (%s, %s, %s, %s, %s, %s)", (L[1], L[4], L[5], sd, ed, rs))

    cur.execute("SELECT * FROM STUD_LEAVE")
    b = cur.rowcount

    if b == a + 1:
        messagebox.showinfo("SUCCESSFUL", "LEAVE ENTRY SUCCESSFULLY INSERTED")

    else:
        print("Some connection with leave entry, Please approach the developer as soon as possible")

    time.sleep(1)

    go_back_to_prev(window)

""""
This function is used to close the current window and go back to the student home window
"""
def go_back_to_prev(pw):
    pw.destroy()
    stud_home()

def teacher_lgn_btn(window):
    # Killing the previous window and moving to the student window
    window.destroy()

    # Making the tkinter window global
    global root

    # Creating new window
    root = Tk()

    root.title("TEACHER LOGIN")
    root.geometry("960x600")
    root.resizable(0, 0)
    root.iconbitmap("./ico/teacher.ico")

    # Creating String Vars
    global username_var
    global passw_var
    username_var = StringVar()
    passw_var = StringVar()

    # Creating the background image variable
    bg = PhotoImage(file="./img/all_lgn.png")

    # Creating the label background
    l1 = Label(root, image=bg)
    l1.place(x=0, y=0)

    # Creating student login text
    l2 = Label(root, text="TEACHER LOGIN", background="#413E91",
               font=("times new roman", 20, "bold"), fg="black")
    l2.place(x=385, y=13)

    # Creating the login username text
    lgnt1 = Label(root, text="USERNAME", font=("times new roman", 10, "bold"))
    lgnt1.place(x=40, y=140)

    # Creating the username login entry form
    global user
    user = Entry(root, textvariable=username_var, width=20)
    user.place(x=140, y=140)

    # Creating the login password text
    lgnt2 = Label(root, text="PASSWORD", font=("times new roman", 10, "bold"))
    lgnt2.place(x=40, y=180)

    # Creating the password entry form
    pswd = Entry(root, textvariable=passw_var, width=20, show="*")
    pswd.place(x=140, y=180)

    # Creating the submit button
    submit = Button(root, text="SUBMIT", command=teacher_lgn)
    submit.place(x=130, y=220)

    root.mainloop()


def teacher_lgn():
    name = username_var.get()
    passw = passw_var.get()

    cur.execute(
        "SELECT * FROM TEACHERS WHERE USERNAME=%s AND PASSWORD=%s", (name, passw))

    a = cur.fetchone()

    global L
    L = []

    if a != None and len(a) != 0:
        for k in a:
            L.append(k)

        root.destroy()
        teacher_home()

    else:
        messagebox.showerror(
            "User nor found", "Cannot find such a user with the given username and password. Please retry")

    username_var.set("")
    passw_var.set("")

def teacher_home():
    # Setting window appearance mode
    customtkinter.set_appearance_mode("dark")

    # Setting default color theme
    customtkinter.set_default_color_theme("dark-blue")

    # Creating the student home window
    shw = customtkinter.CTk()

    shw.title("TEACHER HOME")
    shw.geometry("941x619")
    shw.resizable(0, 0)
    shw.iconbitmap("./ico/teacher.ico")

    # Creating the background variable for the window
    bg = ImageTk.PhotoImage(Image.open("./img/teacher_home.jpg").resize((941, 619), Image.Resampling.LANCZOS))

    # Setting up the background
    l1 = Label(shw, image=bg)
    l1.place(x=0, y=0)

    # Creating a label for user details
    l2 = Label(shw, text="WELCOME TO TEACHER HOME", font=("Consolas", 20, "bold"), fg="white", bg="black")
    l2.pack()

    # Creating image variable for icon Images
    std_profile = ImageTk.PhotoImage(Image.open("./icons/std_profile.png").resize((20, 20), Image.Resampling.LANCZOS))
    lv_entry = ImageTk.PhotoImage(Image.open("./icons/leave_entry.jpg").resize((20, 20), Image.Resampling.LANCZOS))
    logout = ImageTk.PhotoImage(Image.open("./icons/logout.png").resize((20, 20), Image.Resampling.LANCZOS))
    search_stud = ImageTk.PhotoImage(Image.open("./icons/search_stud.jpg").resize((20, 20), Image.Resampling.LANCZOS))

    # Teacher Profile button
    b1 = customtkinter.CTkButton(master=shw, width=150, height=40, text="PROFILE", image=std_profile, command=lambda: teacher_profile(shw, L))
    b1.place(x=775, y=90)

    # Leave Entry Button
    b2 = customtkinter.CTkButton(master=shw, width=150, height=40, text="LEAVE ENTRY", image=lv_entry, command=lambda: teacher_leave_entry(shw))
    b2.place(x=775, y=190)

    # Student Search Button
    b3 = customtkinter.CTkButton(master=shw, width=150, height=40, text="SEARCH STUDENT", image=search_stud, command=lambda: search_student(shw))
    b3.place(x=775, y=290)

    # Logout Button
    b4 = customtkinter.CTkButton(master=shw, width=150, height=40, text="LOGOUT", image=logout, command=lambda: all_logout(shw))
    b4.place(x=775, y=390)
    shw.mainloop()

def teacher_profile(pw, L):
    # Destroying parent window
    pw.destroy()

    customtkinter.set_appearance_mode("light")
    customtkinter.set_default_color_theme("dark-blue")

    spw = customtkinter.CTk()
    spw.resizable(0,0)

    spw.title("TEACHER PROFILE")
    spw.iconbitmap("./ico/teacher.ico")

    l1 = customtkinter.CTkLabel(master=spw, text="TEACHER PROFILE", text_font=("Consolas", 20, "italic"))
    l1.pack()

    # Creating the image variable for the profile picture image
    tch_profile = ImageTk.PhotoImage(Image.open("./icons/std_profile1.jpg").resize((200, 200), Image.Resampling.LANCZOS))

    # Creating the label icon
    l1 = customtkinter.CTkLabel(master=spw, image=tch_profile, bg_color="white")
    l1.place(x=200, y=70)

    # Placing name
    name = "Name: "
    l2 = customtkinter.CTkLabel(master=spw, text=name+L[1])
    l2.place(x=210, y=250)

    # Placing class
    grade = "Subject: "
    l3 = customtkinter.CTkLabel(master=spw, text=grade+str(L[4]))
    l3.place(x=210, y=270)

    # Placing DOB
    dob = "DOB: "
    l4 = customtkinter.CTkLabel(master=spw, text=dob+str(L[5]))
    l4.place(x=210, y=290)

    # Placing go back to student home
    b1 = customtkinter.CTkButton(master=spw, text="GO BACK TO PREVIOUS WINDOW", command=lambda: teacher_go_back_to_prev(spw))
    b1.place(x=172, y=330)

    spw.mainloop()

def teacher_go_back_to_prev(cw):
    cw.destroy()
    teacher_home()

def teacher_leave_entry(win):
    win.destroy()

    slew = customtkinter.CTk()
    slew.resizable(0,0)
    slew.iconbitmap("./ico/student.ico")
    slew.title("TEACHER LEAVE ENTRY")

    # Creating start date, end date and reason text variables
    global start_date
    global end_date
    global reason

    start_date = StringVar()
    end_date = StringVar()
    reason = StringVar()

    # Creating the heading
    l1 = customtkinter.CTkLabel(master=slew, text="LEAVE ENTRY", text_font=("times new roman", 21, "bold"))
    l1.pack()

    # Creating the start date text label
    l1 = customtkinter.CTkLabel(master=slew, text="START DATE", text_font=("Consolas", 12, "bold"))
    l1.place(x=30, y=90)

    # Creating start date button
    global b1
    b1 = DateEntry(master=slew, date_pattern="yyyy-mm-dd",textvariable=start_date)
    b1.place(x=250, y=100)

    l2 = customtkinter.CTkLabel(master=slew, text="END DATE", text_font=("Consolas", 12, "bold"))
    l2.place(x=30, y=160)

    global b2
    b2 = DateEntry(master=slew, date_pattern="yyyy-mm-dd", textvariable=end_date)
    b2.place(x=250, y=170)

    l3 = customtkinter.CTkLabel(master=slew, text="REASON", text_font=("Consolas", 12, "bold"))
    l3.place(x=30, y=220)

    global b3
    b3 = customtkinter.CTkEntry(master=slew, textvariable=reason, width=300)
    b3.place(x=190, y=220)

    # Creating the submit button
    submit = customtkinter.CTkButton(master=slew, text="Submit", command=lambda: teacher_leave_entry_submit(slew))
    submit.place(x=190, y=270)

    # Creating go back to student home
    b4 = customtkinter.CTkButton(master=slew, text="GO BACK TO PREVIOUS WINDOW", command=lambda: go_back_to_prev(slew))
    b4.place(x=190, y=320)

    slew.mainloop()

def teacher_leave_entry_submit(window):
    sd = start_date.get()
    ed = end_date.get()
    rs = reason.get()

    cur.execute("SELECT * FROM TEACHER_LEAVE")
    a = cur.rowcount

    cur.execute("INSERT INTO TEACHER_LEAVE(NAME, STARTDATE, ENDDATE, REASON) VALUES (%s, %s, %s, %s)", (L[1], sd, ed, rs))

    cur.execute("SELECT * FROM TEACHER_LEAVE")
    b = cur.rowcount

    if b == a + 1:
        messagebox.showinfo("SUCCESSFUL", "LEAVE ENTRY SUCCESSFULLY INSERTED")

    else:
        print("Some connection with leave entry, Please approach the developer as soon as possible")

    time.sleep(1)

    teacher_go_back_to_prev(window)

def search_student(window):
    window.destroy()

    # Setting window appearance mode
    customtkinter.set_appearance_mode("dark")

    # Setting default color theme
    customtkinter.set_default_color_theme("dark-blue")

    ssw = customtkinter.CTk()
    ssw.resizable(0,0)
    ssw.title("SEARCH STUDENT")

    global stud_name_var

    stud_name_var = customtkinter.StringVar()

    l1 = customtkinter.CTkLabel(master=ssw, text="STUDENT LIST", text_font=("Consolas", 21, "bold"))
    l1.pack()

    l2 = customtkinter.CTkLabel(master=ssw, text="STUDENT NAME: ")
    l2.place(x=40, y=40)

    e1 = customtkinter.CTkEntry(master=ssw, width=200, textvariable=stud_name_var)
    e1.place(x=200, y=40)

    submit = customtkinter.CTkButton(master=ssw, text="SUBMIT", command=lambda: search_student_name())
    submit.place(x=150, y=80)

    ssw.mainloop()

def search_student_name():
    name = stud_name_var.get()

    cur.execute("SELECT * FROM STUDENTS WHERE NAME=%s", (name,))

    global A
    a = cur.fetchone()

    A = []

    if a != None:
        for k in a:
            A.append(k)

    display_stud_details()

def display_stud_details():
    snw = customtkinter.CTk()
    snw.title("STUDENT DATA")

    i = 0

    for k in range(len(A)):
        e = customtkinter.CTkLabel(master=snw, width=10, text=A[k], borderwidth=2, relief="ridge", anchor="w")
        e.grid(row=i, column=k)

    snw.mainloop()

def search_teachers(window):
    window.destroy()

    # Setting window appearance mode
    customtkinter.set_appearance_mode("dark")

    # Setting default color theme
    customtkinter.set_default_color_theme("dark-blue")

    ssw = customtkinter.CTk()
    ssw.resizable(0,0)
    ssw.title("SEARCH TEACHER")

    global tch_name_var

    tch_name_var = customtkinter.StringVar()

    l1 = customtkinter.CTkLabel(master=ssw, text="TEACHER LIST", text_font=("Consolas", 21, "bold"))
    l1.pack()

    l2 = customtkinter.CTkLabel(master=ssw, text="STUDENT NAME: ")
    l2.place(x=40, y=40)

    e1 = customtkinter.CTkEntry(master=ssw, width=200, textvariable=tch_name_var)
    e1.place(x=200, y=40)

    submit = customtkinter.CTkButton(master=ssw, text="SUBMIT", command=lambda: search_teacher_name())
    submit.place(x=150, y=80)

    ssw.mainloop()

def search_teacher_name():
    name = tch_name_var.get()

    cur.execute("SELECT * FROM TEACHERS WHERE NAME=%s", (name,))

    global A
    a = cur.fetchone()

    A = []

    if a != None:
        for k in a:
            A.append(k)

    display_teacher_details()

def display_teacher_details():
    snw = customtkinter.CTk()
    snw.title("TEACHER DATA")

    i = 0

    for k in range(len(A)):
        e = customtkinter.CTkLabel(master=snw, width=10, text=A[k], borderwidth=2, relief="ridge", anchor="w")
        e.grid(row=i, column=k)

    snw.mainloop()


def staff_lgn_btn(window):
    # Killing the previous window and moving to the student window
    window.destroy()

    # Making the tkinter window global
    global root

    # Creating new window
    root = Tk()

    root.title("STAFF LOGIN")
    root.geometry("960x600")
    root.resizable(0, 0)
    root.iconbitmap("./ico/staff.ico")

    # Creating String Vars
    global username_var
    global passw_var
    username_var = StringVar()
    passw_var = StringVar()

    # Creating the background image variable
    bg = PhotoImage(file="./img/all_lgn.png")

    # Creating the label background
    l1 = Label(root, image=bg)
    l1.place(x=0, y=0)

    # Creating student login text
    l2 = Label(root, text="STAFF LOGIN", background="#413E91",
               font=("times new roman", 20, "bold"), fg="black")
    l2.place(x=385, y=13)

    # Creating the login username text
    lgnt1 = Label(root, text="USERNAME", font=("times new roman", 10, "bold"))
    lgnt1.place(x=40, y=140)

    # Creating the username login entry form
    global user
    user = Entry(root, textvariable=username_var, width=20)
    user.place(x=140, y=140)

    # Creating the login password text
    lgnt2 = Label(root, text="PASSWORD", font=("times new roman", 10, "bold"))
    lgnt2.place(x=40, y=180)

    # Creating the password entry form
    pswd = Entry(root, textvariable=passw_var, width=20, show="*")
    pswd.place(x=140, y=180)

    # Creating the submit button
    submit = Button(root, text="SUBMIT", command=staff_lgn)
    submit.place(x=130, y=220)

    root.mainloop()


def staff_lgn():
    name = username_var.get()
    passw = passw_var.get()

    cur.execute(
        "SELECT * FROM STAFF WHERE USERNAME=%s AND PASSWORD=%s", (name, passw))

    a = cur.fetchone()

    global L
    L = []

    if a !=None and len(a) != 0:
        for k in a:
            L.append(k)

        root.destroy()
        staff_home()

    else:
        messagebox.showerror(
            "User nor found", "Cannot find such a user with the given username and password. Please retry")

    username_var.set("")
    passw_var.set("")

def staff_home():
    # Setting window appearance mode
    customtkinter.set_appearance_mode("dark")

    # Setting default color theme
    customtkinter.set_default_color_theme("dark-blue")

    # Creating the student home window
    shw = customtkinter.CTk()

    shw.title("TEACHER HOME")
    shw.geometry("941x619")
    shw.resizable(0, 0)
    shw.iconbitmap("./ico/teacher.ico")

    # Creating the background variable for the window
    bg = ImageTk.PhotoImage(Image.open("./img/teacher_home.jpg").resize((941, 619), Image.Resampling.LANCZOS))

    # Setting up the background
    l1 = Label(shw, image=bg)
    l1.place(x=0, y=0)

    # Creating a label for user details
    l2 = Label(shw, text="WELCOME TO STAFF HOME", font=("Consolas", 20, "bold"), fg="white", bg="black")
    l2.pack()

    # Creating image variable for icon Images
    std_profile = ImageTk.PhotoImage(Image.open("./icons/std_profile.png").resize((20, 20), Image.Resampling.LANCZOS))
    lv_entry = ImageTk.PhotoImage(Image.open("./icons/leave_entry.jpg").resize((20, 20), Image.Resampling.LANCZOS))
    logout = ImageTk.PhotoImage(Image.open("./icons/logout.png").resize((20, 20), Image.Resampling.LANCZOS))
    search = ImageTk.PhotoImage(Image.open("./icons/search_stud.jpg").resize((20, 20), Image.Resampling.LANCZOS))

    # Staff Profile button
    b1 = customtkinter.CTkButton(master=shw, width=150, height=40, text="PROFILE", image=std_profile, command=lambda: staff_profile(shw, L))
    b1.place(x=775, y=90)

    # Leave Entry Button
    b2 = customtkinter.CTkButton(master=shw, width=150, height=40, text="LEAVE ENTRY", image=lv_entry, command=lambda: staff_leave_entry(shw))
    b2.place(x=775, y=190)

    # Student Name Checkup
    b3 = customtkinter.CTkButton(master=shw, width=150, height=40, text="STUDENT SEARCH", image=search, command=lambda: search_student(shw))
    b3.place(x=775, y=290)

    # Teacher Name Checkup
    b5 = customtkinter.CTkButton(master=shw, width=150, height=40, text="TEACHER SEARCH", image=search, command=lambda: search_teachers(shw))
    b5.place(x=775, y=390)

    # Logout Button
    b5 = customtkinter.CTkButton(master=shw, width=150, height=40, text="LOGOUT", image=logout, command=lambda: all_logout(shw))
    b5.place(x=775, y=490)
    shw.mainloop()

def staff_profile(pw, L):
    # Destroying parent window
    pw.destroy()

    customtkinter.set_appearance_mode("light")
    customtkinter.set_default_color_theme("dark-blue")

    spw = customtkinter.CTk()
    spw.resizable(0,0)

    spw.title("STAFF PROFILE")
    spw.iconbitmap("./ico/staff.ico")

    l1 = customtkinter.CTkLabel(master=spw, text="STAFF PROFILE", text_font=("Consolas", 20, "italic"))
    l1.pack()

    # Creating the image variable for the profile picture image
    stf_profile = ImageTk.PhotoImage(Image.open("./icons/std_profile1.jpg").resize((200, 200), Image.Resampling.LANCZOS))

    # Creating the label icon
    l1 = customtkinter.CTkLabel(master=spw, image=stf_profile, bg_color="white")
    l1.place(x=200, y=70)

    # Placing name
    name = "Name: "
    l2 = customtkinter.CTkLabel(master=spw, text=name+L[1])
    l2.place(x=210, y=250)

    # Placing work
    grade = "Work: "
    l3 = customtkinter.CTkLabel(master=spw, text=grade+str(L[4]))
    l3.place(x=210, y=270)

    # Placing DOB
    dob = "DOB: "
    l4 = customtkinter.CTkLabel(master=spw, text=dob+str(L[5]))
    l4.place(x=210, y=290)

    # Placing go back to student home
    b1 = customtkinter.CTkButton(master=spw, text="GO BACK TO PREVIOUS WINDOW", command=lambda: staff_go_back_to_prev(spw))
    b1.place(x=172, y=330)

    spw.mainloop()

def staff_go_back_to_prev(cw):
    cw.destroy()
    staff_home()

def staff_leave_entry(win):
    win.destroy()

    slew = customtkinter.CTk()
    slew.resizable(0,0)
    slew.iconbitmap("./ico/student.ico")
    slew.title("STAFF LEAVE ENTRY")

    # Creating start date, end date and reason text variables
    global start_date
    global end_date
    global reason

    start_date = StringVar()
    end_date = StringVar()
    reason = StringVar()

    # Creating the heading
    l1 = customtkinter.CTkLabel(master=slew, text="LEAVE ENTRY", text_font=("times new roman", 21, "bold"))
    l1.pack()

    # Creating the start date text label
    l1 = customtkinter.CTkLabel(master=slew, text="START DATE", text_font=("Consolas", 12, "bold"))
    l1.place(x=30, y=90)

    # Creating start date button
    global b1
    b1 = DateEntry(master=slew, date_pattern="yyyy-mm-dd",textvariable=start_date)
    b1.place(x=250, y=100)

    l2 = customtkinter.CTkLabel(master=slew, text="END DATE", text_font=("Consolas", 12, "bold"))
    l2.place(x=30, y=160)

    global b2
    b2 = DateEntry(master=slew, date_pattern="yyyy-mm-dd", textvariable=end_date)
    b2.place(x=250, y=170)

    l3 = customtkinter.CTkLabel(master=slew, text="REASON", text_font=("Consolas", 12, "bold"))
    l3.place(x=30, y=220)

    global b3
    b3 = customtkinter.CTkEntry(master=slew, textvariable=reason, width=300)
    b3.place(x=190, y=220)

    # Creating the submit button
    submit = customtkinter.CTkButton(master=slew, text="Submit", command=lambda: staff_leave_entry_submit(slew))
    submit.place(x=190, y=270)

    # Creating go back to student home
    b4 = customtkinter.CTkButton(master=slew, text="GO BACK TO PREVIOUS WINDOW", command=lambda: staff_go_back_to_prev(slew))
    b4.place(x=190, y=320)

    slew.mainloop()

def staff_leave_entry_submit(window):
    sd = start_date.get()
    ed = end_date.get()
    rs = reason.get()

    cur.execute("SELECT * FROM STAFF_LEAVE")
    a = cur.rowcount

    cur.execute("INSERT INTO STAFF_LEAVE(NAME, STARTDATE, ENDDATE, REASON) VALUES (%s, %s, %s, %s)", (L[1], sd, ed, rs))

    cur.execute("SELECT * FROM STAFF_LEAVE")
    b = cur.rowcount

    if b == a + 1:
        messagebox.showinfo("SUCCESSFUL", "LEAVE ENTRY SUCCESSFULLY INSERTED")

    else:
        print("Some connection error with leave entry, Please approach the developer as soon as possible")

    time.sleep(1)

    staff_go_back_to_prev(window)

if __name__ == "__main__":
    home()