-
Notifications
You must be signed in to change notification settings - Fork 0
/
individual.py
67 lines (54 loc) · 1.6 KB
/
individual.py
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
# individual person reports
import mysql.connector
from tkinter import *
import tkinter as tk
from PIL import Image
from PIL import ImageTk
import os
import threading
root = Tk()
root.geometry("500x400")
root.title("Individual Attendance")
p1 = PhotoImage(file='appicon.png')
root.iconphoto(False, p1)
bgi = Image.open("Capture1.png")
bgi.image = bgi
bgi1 = bgi.resize((500, 400), Image.ANTIALIAS)
bgi2 = ImageTk.PhotoImage(bgi1)
canvas1 = Canvas(root, width=500, height=400)
canvas1.pack(fill="both", expand=True)
canvas1.create_image(0, 0, image=bgi2, anchor="nw")
def check_quarry_thread():
os.system('python Get_Individual_Quarry.py')
my_str = tk.StringVar()
l1 = tk.Label(root, textvariable=my_str, width=10).place()
def show_lan(my_language):
my_str.set(my_language)
t2 = threading.Thread(target=check_quarry_thread)
t2.start()
mydb = mysql.connector.connect(
host="localhost",
user="root",
password="",
database="faceapp"
)
names =[]
#get count of No. of students in DB
mycursor = mydb.cursor()
mycursor.execute("select DISTINCT COUNT(name) FROM attendance GROUP BY dyString")
ButtonCount = mycursor.fetchall()
for y in ButtonCount:
print(y[0])
#get student names from DB
mycursor.execute("select DISTINCT name FROM attendance")
names = mycursor.fetchall()
i = 0
a = 0
for x in names:
print(x[0])
mybutton = Button(root, text="{}".format(x[0]), width=10, bg='#2CFF34', command=lambda lan=x[0]: show_lan(lan))
button1_canvas = canvas1.create_window((210, 70 + a), anchor="nw", window=mybutton)
# mybutton.place(x=210, y=70+a)
i = i + 1
a = a + 50
root.mainloop()