-
Notifications
You must be signed in to change notification settings - Fork 5
/
search_employee.py
116 lines (106 loc) · 4.69 KB
/
search_employee.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
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
import tkinter
from tkinter import *
from tkinter import ttk, messagebox
from PIL import Image, ImageTk
import mysql.connector
root =Tk()
root.title("Search Employee")
root.geometry("900x500+200+100")
root.resizable(False, False)
global root_window
root_window = root
def on_closing():
root_window.destroy()
def on_back():
root_window.destroy()
modulename = 'main'
if modulename not in sys.modules:
import main
else:
importlib.reload(main)
def search():
option = dropdown.get()
search_input = searchInput.get()
db = mysql.connector.connect(host="localhost", user="root", password="", database="nsec_db")
mycursor = db.cursor(buffered = True)
if option == "Name":
mycursor.execute("SELECT * FROM employee_table WHERE name = '" + str(search_input) + "'")
elif option == "UID":
mycursor.execute("SELECT * FROM employee_table WHERE id = '" + str(search_input) + "'")
else:
return
rows = mycursor.fetchone()
if rows == None:
draw_no_result()
return
draw_result()
global result, result_uid, result_name, result_dept, result_desg
result_uid["text"] = rows[0]
result_name["text"] = rows[1]
result_dept["text"] = rows[3]
result_desg["text"] = rows[2]
db.commit()
db.close()
# pass
def draw_result():
#result_frame
global result, result_uid, result_name, result_dept, result_desg
for widget in result.winfo_children():
widget.destroy()
result=Frame(root, bg = "#777", bd=0)
result.place(x=100,y=200,width=700,height=250)
name=Label(result, text = "Name : ", font=("Minion Pro Regular",20), bd = 0, bg = "#777", fg = "#fff")
name.place(x=100, y=60, height = 30)
result_name=Label(result, text = "Souhardhya", font=("Minion Pro Regular",20), bd = 0, bg = "#777", fg = "#fff")
result_name.place(x=270, y=60, height = 30)
uid=Label(result, text = "UID : ", font=("Minion Pro Regular",20), bd = 0, bg = "#777", fg = "#fff")
uid.place(x=100, y=90, height = 30)
result_uid=Label(result, text = "007", font=("Minion Pro Regular",20), bd = 0, bg = "#777", fg = "#fff")
result_uid.place(x=270, y=90, height = 30)
dept=Label(result, text = "Department : ", font=("Minion Pro Regular",20), bd = 0, bg = "#777", fg = "#fff")
dept.place(x=100, y=120, height = 30)
result_dept=Label(result, text = "ECE", font=("Minion Pro Regular",20), bd = 0, bg = "#777", fg = "#fff")
result_dept.place(x=270, y=120, height = 30)
desg=Label(result, text = "Designation : ", font=("Minion Pro Regular", 20), bd = 0, bg = "#777", fg = "#fff")
desg.place(x=100, y=150, height = 30)
result_desg=Label(result, text = "Asst. Prof", font=("Minion Pro Regular",20), bd = 0, bg = "#777", fg = "#fff")
result_desg.place(x=270, y=150, height = 30)
def draw_no_result():
#result_frame
global result
for widget in result.winfo_children():
widget.destroy()
result=Frame(root, bg = "#777", bd=0)
result.place(x=100,y=200,width=700,height=250)
name=Label(result, text = "No record found", font=("Minion Pro Regular",20), bd = 0, bg = "#777", fg = "#fff")
name.place(x=0, y=100, height = 30, width = 700)
#Header
header=Frame(root, bg="brown", bd=0)
header.place(x=0,y=0,width=900,height=75)
#heading label
nsec=Label(header, text="Netaji Subhash Engineering College",font=("Helvetica", 28,"bold"), bg = "brown",fg="#eae2b7")
nsec.place(x=0, y=10, width=900)
#Profile frame
frame2=Frame(root, bg="#fbb1bd")
frame2.place(x=0,y=75,width=900,height=50)
welcome_text = Label(frame2, text = "Search Employee (by Name OR UID)", font=("Minion Pro Regular", 16), bg="#fbb1bd")
welcome_text.place(x=20, y=10)
close = Button(frame2, text = "Close", bd = 0, command = on_closing, font=("Minion Pro Regular", 16), bg="#fff", fg = "#000")
close.place(x=830, y=0, height = 50, width = 70)
#panel
panel=Frame(root, bg="#bbb", bd=0)
panel.place(x=0,y=125,width=900,height=375)
#panel_elements
searchBy=Label(panel,text="Enter Value",font=("Minion Pro Regular",16),bg="#bbb",fg="#222")
searchBy.place(x=100, y=20)
searchInput=Entry(panel,font=("Minion Pro Regular",12), bd = 0)
searchInput.place(x=230, y=20, height = 30, width = 220)
dropdown=ttk.Combobox(panel, width=15, font=("Minion Pro Regular",16), state='readonly')
dropdown['values']=("--search by--", "Name", "UID")
dropdown.current(0)
dropdown.place(x=480, y=20, height = 30)
searchBtn=Button(panel,text="Search", command = search, font=("Minion Pro Regular",16,"bold"), bd = 0)
searchBtn.place(x=700, y=20, height = 30)
result=Frame(root, bd=0)
result.place(x=0,y=0,width=0,height=0)
root.mainloop()