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()