Attendance-system-by-python/o_python.py at main · charendra910/Attendance-system-by-python · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
import calendar
import tkinter
import mysql.connector
from tkinter import *
from subprocess import call
from tkinter import ttk
from tkcalendar import DateEntry
from PIL import ImageTk, Image
from tkinter import messagebox
from tkinter import font


root = Tk()
root.title("O (Python)")
root.geometry('550x600')
root.iconbitmap("OIP.jpeg")

#Define fontStyles
fontStyle_h = "arial 15 bold underline"
fontStyle_p = "arial 14 bold"
fontStyle_d = "arial 13"
fontStyle_t = "arial 13 bold"
fontStyle_p1 = "arial 10"

#Attached image
img_s = Image.open("OIP.jpeg")
img_s = img_s.resize((180,100))
img = ImageTk.PhotoImage(img_s)
lable = Label(image = img).grid(column=1,row=0)

#label header
l1 = Label(root, text="CLASS ATTENDANCE", font=fontStyle_h).grid(column=1, row=1)
blank = Label(root, text="").grid(column=1, row=2)

#function for go home
def home():
    root.destroy()
    call(["python", "attendance.py"])
#Go back home screen button
home = Button(root, text="Home Page", command=home)
home.configure(font=('arial', 11, 'bold'), bg='yellow', fg='black')
home.grid(row=3, column=1)

#blank row
blank = Label(root, text="").grid(column=0, row=4)

#Label for date
date = Label(root, text="Select Date: ", font=fontStyle_p)
date.grid(column=0, row=5)

#Entry of date
e_date = DateEntry(root, width=12, background='darkblue', foreground='white', borderwidth=2, font=fontStyle_d)
e_date.grid(column=1, row=5)

#blank row
blank = Label(root, text="").grid(column=3, row=6)

#ttk labels for student attendance table header
ttk.Label(root, text="Enrollment No. ", background="green", foreground="white", font=fontStyle_t).grid(row=7, column=0, sticky="nsew")
ttk.Label(root, text="Name", background="green", foreground="white", font=fontStyle_t).grid(row=7, column=1, sticky="nsew")
ttk.Label(root, text="Roll No.", background="green", foreground="white", font=fontStyle_t).grid(row=7, column=2, sticky="nsew")
ttk.Label(root, text="Status", background="green", foreground="white", font=fontStyle_t).grid(row=7, column=3, sticky="nsew")
ttk.Label(root, text="", background="green", foreground="white").grid(row=7, column=4, sticky="nsew")

#connect database to fetch record
mydb = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="",
    database="attendance"
    )
mycursor = mydb.cursor()
query = "SELECT * FROM mTech_o"
mycursor.execute(query)
records = mycursor.fetchall()
var = []
for i, attendance in enumerate(records):
    sEnroll, sName, sRoll = attendance
    var.append(StringVar())
    var[i].set('Present')
    ttk.Label(root, text=sEnroll, font=fontStyle_p1).grid(row=i+8, column=0, sticky="nsew")
    ttk.Label(root, text=sName, font=fontStyle_p1).grid(row=i+8, column=1, sticky="nsew")
    ttk.Label(root, text=sRoll, font=fontStyle_p1).grid(row=i+8, column=2, sticky="nsew")
    present = ttk.Radiobutton(root, text="Present", variable=var[i], value="Present")
    present.grid(row=i+8, column=3, sticky="nsew")
    absent = ttk.Radiobutton(root, text="Absent", variable=var[i], value="Absent")
    absent.grid(row=i+8, column=4, sticky="nsew")


#function for the submit button to save records in the database
def submit_attendance():
    mydb = mysql.connector.connect(
        host="localhost",
        user="root",
        passwd="",
        database="attendance")
    mycursor = mydb.cursor()
    for i, attendance in enumerate(records):
        sEnroll, sName, sRoll = attendance
        query = "INSERT INTO o_python (date, sEnroll, sName, sRoll, status) VALUES (%s, %s, %s, %s, %s)"
        values = (e_date.get(), sEnroll, sName, sRoll, var[i].get())
        mycursor.execute(query, values)
        mydb.commit()

    messagebox.showinfo("Success", "Attendance Submitted Successfully")
    root.destroy()
    call(["python", "attendance.py"])

#Submit attendance data button
submit = Button(root, text="Submit Attendance", command=submit_attendance)
submit.configure(font=('arial', 14, 'bold'), bg='blue', fg='white')
submit.grid(row=60, column=1)

#blank row
blank = Label(root, text="").grid(column=0, row=61)


#function of add new student
def add_student():
    root.destroy()
    call(["python", "add_o.py"])

#add new student button
insert = Button(root, text="Add Student", command=add_student)
insert.configure(font=('arial', 13, 'bold'), bg='green', fg='white')
insert.grid(row=62, column=1)


#function of remove existing student
def remove_student():
    call(["python", "rm_o.py"])

#remove existing button
remove = Button(root, text="Remove Student", command=remove_student)
remove.configure(font=('arial', 13, 'bold'), bg='red', fg='white')
remove.grid(row=62, column=0)

#run code in GUI
root.mainloop()