Student Management Systems.py

import sys
import os
from dotenv import load_dotenv
import mysql.connector
import customtkinter as ctk

load_dotenv()

# ─── COLORS ───────────────────────────────────────────────────────
BG       = "#f5e2de"   # soft pink background
SIDEBAR  = "#dfccc5"   # deep purple
SIDEBAR_TEXT = "#3f122f"  # dark navy text
BTN      = "#1d3a4d"   # dark navy button
BTN_HVR  = "#162939"   # darker navy hover
TEXT     = "#3f122f"   # general text

# ─── DB CONNECTION ────────────────────────────────────────────────
mydb = mysql.connector.connect(
    host='localhost',
    user='root',
    passwd=os.getenv('DB_PASSWORD')
)
crsr = mydb.cursor()
crsr.execute("CREATE DATABASE IF NOT EXISTS School_mgmt_system")
crsr.execute("USE School_mgmt_system")
crsr.execute("""
CREATE TABLE IF NOT EXISTS Student (
    rollno INTEGER PRIMARY KEY,
    name VARCHAR(25),
    age INTEGER,
    class VARCHAR(10),
    city VARCHAR(20)
)
""")
crsr.execute("""
CREATE TABLE IF NOT EXISTS Fees (
    rollno INTEGER,
    feedeposit INTEGER,
    term VARCHAR(3)
)
""")

# ─── THEME ────────────────────────────────────────────────────────
ctk.set_appearance_mode("light")
ctk.set_default_color_theme("blue")


# ─── HELPERS ──────────────────────────────────────────────────────
def labeled_entry(parent, label, row, placeholder=""):
    ctk.CTkLabel(
        parent, text=label,
        font=ctk.CTkFont(size=13),
        text_color=TEXT
    ).grid(row=row, column=0, padx=20, pady=8, sticky="w")
    entry = ctk.CTkEntry(parent, placeholder_text=placeholder, width=280)
    entry.grid(row=row, column=1, padx=20, pady=8, sticky="w")
    return entry


def page_title(parent, text):
    ctk.CTkLabel(
        parent, text=text,
        font=ctk.CTkFont(size=20, weight="bold"),
        text_color=SIDEBAR_TEXT
    ).grid(row=0, column=0, columnspan=2, padx=20, pady=(20, 10), sticky="w")


def action_button(parent, text, command, row, danger=False):
    color = "#c0392b" if danger else BTN
    hover = "#922b21" if danger else BTN_HVR
    ctk.CTkButton(
        parent, text=text,
        fg_color=color, hover_color=hover,
        text_color="white",
        command=command
    ).grid(row=row, column=0, columnspan=2, pady=20)


# ─── PAGES ────────────────────────────────────────────────────────
class AddStudent(ctk.CTkFrame):
    def __init__(self, parent, controller):
        super().__init__(parent, fg_color=BG)
        self.grid_columnconfigure(1, weight=1)

        page_title(self, "Add Student")
        self.roll = labeled_entry(self, "Roll No", 1, "e.g. 101")
        self.name = labeled_entry(self, "Name",    2, "e.g. Hariharan")
        self.age  = labeled_entry(self, "Age",     3, "e.g. 16")
        self.cls  = labeled_entry(self, "Class",   4, "e.g. 12A")
        self.city = labeled_entry(self, "City",    5, "e.g. Trichy")
        action_button(self, "Add Student", self.add, 6)

        self.status = ctk.CTkLabel(self, text="", font=ctk.CTkFont(size=12))
        self.status.grid(row=7, column=0, columnspan=2)

    def add(self):
        try:
            roll = int(self.roll.get())
            name = self.name.get()
            age  = int(self.age.get())
            cls  = self.cls.get()
            city = self.city.get()

            if not all([name, cls, city]):
                self.status.configure(text="⚠ Fill all fields!", text_color="orange")
                return

            crsr.execute(
                "INSERT INTO Student (rollno, name, age, class, city) VALUES (%s,%s,%s,%s,%s)",
                (roll, name, age, cls, city)
            )
            mydb.commit()
            self.status.configure(text=f"✅ Student '{name}' added!", text_color="green")
            for e in [self.roll, self.name, self.age, self.cls, self.city]:
                e.delete(0, "end")

        except ValueError:
            self.status.configure(text="⚠ Roll No and Age must be numbers!", text_color="red")
        except mysql.connector.Error as e:
            self.status.configure(text=f"❌ {e.msg}", text_color="red")


class ViewStudent(ctk.CTkFrame):
    def __init__(self, parent, controller):
        super().__init__(parent, fg_color=BG)
        self.grid_columnconfigure(0, weight=1)
        self.grid_rowconfigure(2, weight=1)

        page_title(self, "👁 View Students")

        filter_frame = ctk.CTkFrame(self, fg_color="transparent")
        filter_frame.grid(row=1, column=0, padx=20, pady=5, sticky="w")

        self.search_var = ctk.StringVar(value="All")
        ctk.CTkLabel(filter_frame, text="Search by:", text_color=TEXT).grid(row=0, column=0, padx=5)
        ctk.CTkOptionMenu(
            filter_frame,
            values=["All", "Roll No", "Name", "Age", "City"],
            variable=self.search_var,
            fg_color=BTN, button_color=BTN_HVR, text_color="white"
        ).grid(row=0, column=1, padx=5)
        self.search_entry = ctk.CTkEntry(filter_frame, placeholder_text="Value...", width=160)
        self.search_entry.grid(row=0, column=2, padx=5)
        ctk.CTkButton(
            filter_frame, text="Search",
            fg_color=BTN, hover_color=BTN_HVR, text_color="white",
            command=self.view
        ).grid(row=0, column=3, padx=5)

        self.result = ctk.CTkTextbox(self, font=ctk.CTkFont(family="Courier", size=12))
        self.result.grid(row=2, column=0, padx=20, pady=10, sticky="nsew")

    def view(self):
        criteria = self.search_var.get()
        val = self.search_entry.get()
        try:
            if criteria == "All":
                crsr.execute("SELECT * FROM Student")
            elif criteria == "Roll No":
                crsr.execute("SELECT * FROM Student WHERE rollno = %s", (int(val),))
            elif criteria == "Name":
                crsr.execute("SELECT * FROM Student WHERE name = %s", (val,))
            elif criteria == "Age":
                crsr.execute("SELECT * FROM Student WHERE age = %s", (int(val),))
            elif criteria == "City":
                crsr.execute("SELECT * FROM Student WHERE city = %s", (val,))

            rows = crsr.fetchall()
            self.result.delete("1.0", "end")
            self.result.insert("end", f"{'Roll':<8}{'Name':<20}{'Age':<6}{'Class':<10}{'City'}\n")
            self.result.insert("end", "-" * 55 + "\n")
            for r in rows:
                self.result.insert("end", f"{r[0]:<8}{r[1]:<20}{r[2]:<6}{r[3]:<10}{r[4]}\n")
            if not rows:
                self.result.insert("end", "No records found.")
        except Exception as e:
            self.result.delete("1.0", "end")
            self.result.insert("end", f"Error: {e}")


class DepositFee(ctk.CTkFrame):
    def __init__(self, parent, controller):
        super().__init__(parent, fg_color=BG)
        self.grid_columnconfigure(1, weight=1)

        page_title(self, "💰 Deposit Fee")
        self.roll = labeled_entry(self, "Roll No", 1, "e.g. 101")
        self.fee  = labeled_entry(self, "Amount",  2, "e.g. 5000")
        self.term = labeled_entry(self, "Term",    3, "e.g. T1")
        action_button(self, "Deposit", self.deposit, 4)

        self.status = ctk.CTkLabel(self, text="", font=ctk.CTkFont(size=12))
        self.status.grid(row=5, column=0, columnspan=2)

    def deposit(self):
        try:
            roll = int(self.roll.get())
            fee  = int(self.fee.get())
            term = self.term.get()
            crsr.execute(
                "INSERT INTO Fees (rollno, feedeposit, term) VALUES (%s,%s,%s)",
                (roll, fee, term)
            )
            mydb.commit()
            self.status.configure(text="✅ Fee deposited successfully!", text_color="green")
            for e in [self.roll, self.fee, self.term]:
                e.delete(0, "end")
        except Exception as e:
            self.status.configure(text=f"❌ {e}", text_color="red")


class ViewFee(ctk.CTkFrame):
    def __init__(self, parent, controller):
        super().__init__(parent, fg_color=BG)
        self.grid_columnconfigure(0, weight=1)
        self.grid_rowconfigure(2, weight=1)

        page_title(self, "📋 View Fee")

        search_frame = ctk.CTkFrame(self, fg_color="transparent")
        search_frame.grid(row=1, column=0, padx=20, pady=5, sticky="w")

        self.roll = ctk.CTkEntry(search_frame, placeholder_text="Enter Roll No", width=200)
        self.roll.grid(row=0, column=0, padx=5)
        ctk.CTkButton(
            search_frame, text="View",
            fg_color=BTN, hover_color=BTN_HVR, text_color="white",
            command=self.view
        ).grid(row=0, column=1, padx=5)

        self.result = ctk.CTkTextbox(self, font=ctk.CTkFont(family="Courier", size=12))
        self.result.grid(row=2, column=0, padx=20, pady=10, sticky="nsew")

    def view(self):
        try:
            roll = int(self.roll.get())
            sql = """
                SELECT Student.rollno, Student.name, Student.class,
                       SUM(Fees.feedeposit), Fees.term
                FROM Student
                INNER JOIN Fees ON Student.rollno = Fees.rollno
                WHERE Fees.rollno = %s
                GROUP BY Student.rollno, Student.name, Student.class, Fees.term
            """
            crsr.execute(sql, (roll,))
            rows = crsr.fetchall()
            self.result.delete("1.0", "end")
            self.result.insert("end", f"{'Roll':<8}{'Name':<20}{'Class':<10}{'Total Fee':<12}{'Term'}\n")
            self.result.insert("end", "-" * 58 + "\n")
            for r in rows:
                self.result.insert("end", f"{r[0]:<8}{r[1]:<20}{r[2]:<10}{r[3]:<12}{r[4]}\n")
            if not rows:
                self.result.insert("end", "No fee records found.")
        except Exception as e:
            self.result.delete("1.0", "end")
            self.result.insert("end", f"Error: {e}")


class RemoveStudent(ctk.CTkFrame):
    def __init__(self, parent, controller):
        super().__init__(parent, fg_color=BG)
        self.grid_columnconfigure(1, weight=1)

        page_title(self, "🗑 Remove Student")
        self.roll = labeled_entry(self, "Roll No", 1, "e.g. 101")
        action_button(self, "Remove Student", self.remove, 2, danger=True)

        self.status = ctk.CTkLabel(self, text="", font=ctk.CTkFont(size=12))
        self.status.grid(row=3, column=0, columnspan=2)

    def remove(self):
        try:
            roll = int(self.roll.get())
            crsr.execute("DELETE FROM Fees WHERE rollno = %s", (roll,))
            crsr.execute("DELETE FROM Student WHERE rollno = %s", (roll,))
            mydb.commit()
            self.status.configure(text=f"✅ Student {roll} removed!", text_color="green")
            self.roll.delete(0, "end")
        except Exception as e:
            self.status.configure(text=f"❌ {e}", text_color="red")


# ─── MAIN APP ─────────────────────────────────────────────────────
class App(ctk.CTk):
    def __init__(self):
        super().__init__()
        self.title("School Management System")
        self.geometry("820x520")
        self.resizable(False, False)

        self.grid_columnconfigure(1, weight=1)
        self.grid_rowconfigure(0, weight=1)

        # ── Sidebar ──
        sidebar = ctk.CTkFrame(self, width=200, corner_radius=0, fg_color=SIDEBAR)
        sidebar.grid(row=0, column=0, sticky="nsew")
        sidebar.grid_rowconfigure(10, weight=1)

        ctk.CTkLabel(
            sidebar, text="🏫 SMS",
            font=ctk.CTkFont(size=24, weight="bold"),
            text_color=SIDEBAR_TEXT
        ).grid(row=0, column=0, padx=20, pady=(30, 5))

        ctk.CTkLabel(
            sidebar, text="School Management\nSystem",
            font=ctk.CTkFont(size=11),
            text_color=SIDEBAR_TEXT
        ).grid(row=1, column=0, padx=20, pady=(0, 25))

        nav_buttons = [
            ("➕  Add Student",    "AddStudent"),
            ("👁  View Student",   "ViewStudent"),
            ("💰  Deposit Fee",    "DepositFee"),
            ("📋  View Fee",       "ViewFee"),
            ("🗑  Remove Student", "RemoveStudent"),
        ]

        for i, (label, frame_name) in enumerate(nav_buttons):
            ctk.CTkButton(
                sidebar, text=label, anchor="w",
                fg_color="transparent",
                text_color=SIDEBAR_TEXT,
                hover_color="#FFB5E1",
                font=ctk.CTkFont(size=13),
                command=lambda f=frame_name: self.show_frame(f)
            ).grid(row=i+2, column=0, padx=10, pady=4, sticky="ew")

        ctk.CTkButton(
            sidebar, text="🚪  Exit", anchor="w",
            fg_color="transparent",
            text_color="#ffaaaa",
            hover_color="#4e1840",
            font=ctk.CTkFont(size=13),
            command=self.quit
        ).grid(row=11, column=0, padx=10, pady=20, sticky="ew")

        # ── Main area ──
        self.main_area = ctk.CTkFrame(self, fg_color=BG)
        self.main_area.grid(row=0, column=1, sticky="nsew")
        self.main_area.grid_columnconfigure(0, weight=1)
        self.main_area.grid_rowconfigure(0, weight=1)

        self.frames = {}
        for F in (AddStudent, ViewStudent, DepositFee, ViewFee, RemoveStudent):
            frame = F(self.main_area, self)
            self.frames[F.__name__] = frame
            frame.grid(row=0, column=0, sticky="nsew")

        self.show_frame("AddStudent")

    def show_frame(self, name):
        self.frames[name].tkraise()


if __name__ == "__main__":
    app = App()
    app.mainloop()