def admin_appointments_details(root, frame):
frame.destroy()
frame = Frame(root, width=2000, height=1500)
frame.pack()
img = ImageTk.PhotoImage(Image.open('hospital images\HOSP63.png'))
L = Label(frame, image=img)
L.place(x=0, y=0)
L10 = Label(frame,
text='HOSPITAL MANAGEMENT SYSTEM',
font=('arial', 40),
fg='white',
bg='deep sky blue',
width=50)
L10.place(x=0, y=50)
name = StringVar
scrolling_area = Scrolling_Area(frame, height=400)
scrolling_area.place(x=0, y=120)
table = Table(
scrolling_area.innerframe,
[
"DATE", "TIME", "PID", "NAME", "PROBLEM", "MOBILE_NO",
"DOCTOR_NAME", "DOCTOR_ID"
], #DATE,TIME,PID,PNAME,DISEASE,MOBILE_NO,DOCTAR_NAME,DOCTAR_ID
column_minwidths=[150, 100, 100, 205, 250, 200, 200, 110],
height=600)
table.pack(expand=True, fill=X)
table.on_change_data(scrolling_area.update_viewport)
conn = sqlite3.connect("myproject_5.db")
cur = conn.cursor()
cur.execute(
"select DATE,TIME,PID,PNAME,DISEASE,MOBILE_NO,DOCTAR_NAME,DOCTAR_ID from PATIENTS"
)
data = []
for row in cur:
column = []
data.append(column)
for r in row:
column.append(r)
table.set_data(data)
conn.commit()
B1 = Button(frame,
text='BACK',
font=('arial', 20),
fg='deep sky blue',
bg='white',
width=12,
bd=15,
command=lambda: after_adminsuccess(root, frame))
B1.place(x=900, y=575)
frame.mainloop()
def doc_details(root, frame):
frame.destroy()
frame = Frame(root, width=1366, height=768)
frame.place(x=0, y=0)
img = ImageTk.PhotoImage(Image.open('hospital images\hosp60.jpg'))
L = Label(frame, image=img)
L.place(x=0, y=0)
L10 = Label(frame,
text='HOSPITAL MANAGEMENT SYSTEM',
font=('arial', 40),
fg='white',
bg='deep sky blue',
width=50)
L10.place(x=0, y=50)
name = StringVar
scrolling_area = Scrolling_Area(frame, height=400)
scrolling_area.place(x=0, y=120)
table = Table(
scrolling_area.innerframe,
["ID", "NAME", "DESIGNATION", "SPECIALISATION", "MOBILE_NO", "EMAIL"],
column_minwidths=[50, 250, 250, 250, 250, 250],
height=650)
table.pack(expand=True, fill=X)
table.on_change_data(scrolling_area.update_viewport)
conn = sqlite3.connect("myproject_1.db")
cur = conn.cursor()
cur.execute(
"select ID,NAME,DESIGNATION,SPECIALISATION,MOBILE_NO,EMAIL from DOCTORS "
)
data = []
for row in cur:
column = []
data.append(column)
for r in row:
column.append(r)
table.set_data(data)
conn.commit()
B1 = Button(frame,
text='BACK',
font=('arial', 20),
fg='deep sky blue',
bg='white',
width=12,
bd=15,
command=lambda: after_receptionsuccess(root, frame))
B1.place(x=900, y=575)
frame.mainloop()
def view_faculty(root, frame):
frame.destroy()
frame = Frame(root, width=1920, height=1080, background='pink')
frame.place(x=0, y=0)
conn = sqlite3.connect('Project.db')
cursor = conn.execute('select * from projectdata')
scrolling_area = Scrolling_Area(frame, height=700)
scrolling_area.place(x=0, y=10)
table = Table(
scrolling_area.innerframe,
["Name", "Email", "Password", "Address", "Branch", "Mobile_No"],
column_minwidths=[250, 250, 250, 250, 240, 250],
height=900)
table.pack(expand=True, fill=X)
table.on_change_data(scrolling_area.update_viewport)
conn = sqlite3.connect("Project.db")
cur = conn.cursor()
cur.execute("SELECT * from projectdata")
data = []
for row in cur:
column = []
data.append(column)
for r in row:
column.append(r)
table.set_data(data)
conn.commit()
B02 = Button(frame,
text='Back',
font=('courier', 12, 'bold'),
bg='grey',
fg='white',
width=15,
bd=15,
command=lambda: view(root, frame))
B02.place(x=720, y=660)
conn.close()