def __init__(self):
self.tk = Tk()
height = self.tk.winfo_screenheight()
width = self.tk.winfo_screenwidth()
y = (height - 650) // 2
x = (width - 650) // 2
self.tk.geometry('650x650+' + str(x) + '+' + str(y))
self.tk.resizable(height=False, width=False)
'''self.can=Canvas(self.tk,height="650",width="650")
self.can.pack()
self.img=PhotoImage(file="./image/img21.gif")
self.can.create_image(0,0,image=self.img,anchor=NW)'''
self.f = Frame(self.tk, height="100", width="700", bg="#070719")
self.f.place(x=0, y=0)
self.l = Label(self.f,
text="Manage Appointment",
fg="powder blue",
font=('cooper black', 30),
bg="#070719")
self.l.place(x=120, y=20)
self.f1 = Frame(self.tk, height="650", width="650", bg="#C2DFFF")
self.f1.place(x=0, y=100)
self.fr = Frame(self.f1, height="10", width="700", bg="#070719")
self.fr.place(x=0, y=10)
self.fr1 = Frame(self.f1, height="70", width="700", bg="#070719")
self.fr1.place(x=0, y=500)
self.table = Treeview(self.f1,
column=("#0", "#1", "#2", "#3", "#4", "#5"))
style = ttk.Style()
style.theme_use("alt")
ttk.Style().configure("Treeview.heading", font=('', 15))
self.table.heading("#0", text="Sno.")
self.table.column("#0", width="40")
self.table.heading("#1", text="P_name")
self.table.column("#1", width="60")
self.table.heading("#2", text="Timing")
self.table.column("#2", width="70")
self.table.heading("#3", text="Date")
self.table.column("#3", width="70")
self.table.heading("#4", text="Description")
self.table.column("#4", width="70")
r = database_queries.database()
res = r.view_appoint()
print(res)
for i in res:
self.table.insert('',
'end',
text=i[0],
value=(i[2], i[3], i[4], i[5]))
self.table.place(x=100, y=150)
def update(self):
data = [
self.e1.get(),
self.e2.get(),
self.e3.get(),
self.e4.get(),
]
r = database_queries.database()
r.update_profile(data)
def change(self):
data=(self.e1.get(), self.e2.get())
if (self.e1.get!="" and self.e2.get()!=""):
x=database_queries.database()
r=x.login(data)
if r is not None:
y=navigation1.Main()
else:
print("Please login first")
def insert(self):
data = (self.e1.get(), self.var.get(), self.e3.get(), self.e4.get(),
self.e5.get(), self.e6.get())
if (self.e1.get() != "" and self.var.get() != ""
and self.e3.get() != "" and self.e4.get() != ""
and self.e5.get() != "" and self.e6.get() != ""):
x = database_queries.database()
x.add_receptionist(data)
else:
print("please enter all fields!")
def update(self):
data = [
self.e1.get(),
self.e2.get(),
self.dob.get(),
self.des.get(), self.n
]
t = database_queries.database()
t.update_appoint(data)
def trigger(self, e):
row = self.table.focus()
t = (self.table.item(row))
col = self.table.identify_column(e.x)
if col == "#6":
y = edit_receptionist.window(t["text"])
print("edit")
elif (col == "#7"):
o = database_queries.database()
o.delete(t["text"])
def update(self):
data = [
self.e1.get(),
self.gen.get(),
self.e2.get(),
self.e3.get(),
self.e4.get(),
self.e5.get(), self.id
]
r = database_queries.database()
r.update(data)
def update(self):
data = [
self.e1.get(),
self.g.get(),
self.e3.get(),
self.e4.get(),
self.e5.get(),
self.e6.get(), self.id
]
o = database_queries.database()
o.update_patient(data)
def login(self):
data = (self.e.get(), self.e1.get())
if (self.e.get() != "" and self.e1.get() != ""):
y = database_queries.database()
res = y.fetch(data)
if res is not None:
x = navigation.window()
else:
print("something is wrong")
else:
print("empty field")
def submit(self):
x = (self.e1.get(), self.var.get(), self.e3.get(), self.e4.get(),
self.e5.get(), self.e6.get())
if (self.e1.get() != "" and self.var.get != 0 and self.e3.get() != 0
and self.e4.get() != 0 and self.e5.get() != 0
and self.e6.get() != 0):
y = database_queries.database()
y.add_patient(x)
else:
print("Please enter all fields")
def add(self):
data = (
self.e1.get(),
self.e2.get(),
self.dob.get(),
self.e4.get(),
)
if (self.e1.get() != "" and self.e1.get() != 0 and self.e2.get() != 0
and self.dob.get() != 0 and self.e4.get() != 0):
y = database_queries.database()
y.add_appoint(data)
else:
print("Please enter all fields")
def __init__(self):
self.win = Tk()
height = self.win.winfo_screenheight()
width = self.win.winfo_screenwidth()
x = (width - 700) // 2
y = (height - 700) // 2
self.win.geometry('700x700+{}+{}'.format(str(x), str(y)))
self.win.resizable(width=False, height=False)
self.frame = Frame(self.win, height=700, width=700, bg="#a3c2c2")
self.frame.place(x=0, y=0)
self.frame1 = Frame(self.frame, bg="#e0ebeb", height=700, width=2)
self.frame1.place(x=30, y=0)
self.frame1 = Frame(self.frame, bg="#75a3a3", height=700, width=4)
self.frame1.place(x=20, y=0)
self.frame1 = Frame(self.frame, bg="#476b6b", height=700, width=6)
self.frame1.place(x=10, y=0)
self.frame1 = Frame(self.frame, bg="#e0ebeb", height=2, width=700)
self.frame1.place(x=0, y=30)
self.frame1 = Frame(self.frame, bg="#75a3a3", height=4, width=700)
self.frame1.place(x=0, y=20)
self.frame1 = Frame(self.frame, bg="#476b6b", height=6, width=700)
self.frame1.place(x=0, y=10)
self.table = Treeview(self.frame,
column=("#0", "#1", "#2", "#3", "#4", "#5", "#6",
"#7"))
style = ttk.Style()
style.theme_use("alt")
ttk.Style().configure("Treeview.Heading", font=('', 14, "bold"))
self.table.column("#0", width=80)
self.table.column("#1", width=80)
self.table.column("#2", width=80)
self.table.column("#3", width=80)
self.table.column("#4", width=80)
self.table.column("#5", width=80)
self.table.column("#6", width=80)
self.table.column("#7", width=80)
self.table.heading("#0", text="Sr.")
self.table.heading("#1", text="Name")
self.table.heading("#2", text="Gender")
self.table.heading("#3", text="Email")
self.table.heading("#4", text="Contact")
self.table.heading("#5", text="Address")
self.table.heading("#6", text="Edit")
self.table.heading("#7", text="Delete")
x = database_queries.database()
res = x.view_receptionist()
#print(res)
for i in res:
self.table.insert('',
'end',
text=i[0],
value=(i[1], i[2], i[3], i[5], i[6], "edit",
"delete"))
self.table.bind("<Double Button-1>", self.trigger)
self.table.place(x=40, y=50, width=640)
self.win.mainloop()
def update(self):
print("update")
w=database_queries.database()
w.update_password()
def __init__(self):
self.tk = Toplevel()
height = self.tk.winfo_screenheight()
width = self.tk.winfo_screenwidth()
y = (height - 650) // 2
x = (width - 650) // 2
self.tk.geometry('650x650+' + str(x) + '+' + str(y))
self.tk.resizable(height=False, width=False)
self.tk.title("manage patient")
self.f = Frame(self.tk, height="650", width="650", bg="#CEE3F6")
self.f.place(x=0, y=0)
self.f1 = Frame(self.f, height="100", width="650", bg="#070719")
self.f1.place(x=0, y=0)
self.l = Label(self.f1,
text="Manage Patient",
font=('cooper black', 35),
fg="#CEE3F6",
bg="#070719")
self.l.place(x=150, y=20)
self.fr = Frame(self.f, height="70", width="650", bg="#070719")
self.fr.place(x=0, y=580)
self.fr1 = Frame(self.f, height="10", width="650", bg="#070719")
self.fr1.place(x=0, y=560)
self.table = Treeview(self.f,
column=("#0", "#1", "#2", "#3", "#4", "#5", "#6",
"#7", "#8", "#9"))
style = ttk.Style()
style.theme_use("alt")
ttk.Style().configure("Treeview.heading", font=('', 30))
self.table.heading("#0", text="sno")
self.table.column("#0", width="30")
self.table.heading("#1", text="Name")
self.table.column("#1", width="60")
self.table.heading("#2", text="Gender")
self.table.column("#2", width="60")
self.table.heading("#3", text="Age")
self.table.column("#3", width="60")
self.table.heading("#4", text="contact")
self.table.column("#4", width="70")
self.table.heading("#5", text="Address")
self.table.column("#5", width="70")
self.table.heading("#6", text="Email")
self.table.column("#6", width="90")
self.table.heading("#7", text="History")
self.table.column("#7", width="70")
self.table.heading("#8", text="Edit")
self.table.column("#8", width="70")
self.table.heading("#9", text="Delete")
self.table.column("#9", width="70")
self.table.place(x=0, y=200)
s = database_queries.database()
res = s.view_patient()
print(res)
for i in res:
self.table.insert('',
'end',
text=i[0],
value=(i[1], i[2], i[3], i[4], i[5], i[6],
"History", "Edit", "Delete"))
self.table.bind("<Double Button>", self.trigger)
self.table.place()
self.tk.mainloop()
def __init__(self, id_):
self.id = id_
print(id_)
obj = database_queries.database()
recep = obj.get_reception_byid(id_)
print(recep)
self.win = Toplevel()
height = self.win.winfo_screenheight()
width = self.win.winfo_screenwidth()
x = (width - 600) // 2
y = (height - 600) // 2
self.win.geometry('600x600+{}+{}'.format(str(x), str(y)))
self.frame = Frame(self.win, height=45, width=600, bg="black")
self.frame.place(x=0, y=0)
self.frame2 = Frame(self.win, height=550, width=600, bg="#a3c2c2")
self.frame2.place(x=0, y=45)
self.frame3 = Frame(self.frame2, height=5, width=600, bg="black")
self.frame3.place(x=0, y=5)
self.rname = StringVar(self.win)
self.rname.set(recep[1])
self.name = Label(self.frame2,
text="Name",
bg="#a3c2c2",
font=('cooper black', 15))
self.name.place(x=140, y=70)
self.e1 = Entry(self.frame2,
font=('cooper black', 15),
textvariable=self.rname)
self.e1.place(x=260, y=70)
self.gen = StringVar(self.win, recep[2])
self.gender = Label(self.frame2,
text="Gender",
bg="#a3c2c2",
font=('cooper black', 15))
self.gender.place(x=140, y=110)
self.g = Radiobutton(self.frame2,
text="Male",
value="Male",
bg="#a3c2c2",
font=('cooper black', 15),
variable=self.gen)
self.g.place(x=260, y=110)
self.g = Radiobutton(self.frame2,
text="Female",
value="Female",
bg="#a3c2c2",
font=('cooper black', 15),
variable=self.gen)
self.g.place(x=360, y=110)
self.em = StringVar(self.win)
self.em.set(recep[3])
self.email = Label(self.frame2,
text="Email",
bg="#a3c2c2",
font=('cooper black', 15))
self.email.place(x=140, y=170)
self.e2 = Entry(self.frame2,
font=('cooper black', 15),
textvariable=self.em)
self.e2.place(x=260, y=170)
self.passw = StringVar(self.win)
self.passw.set(recep[4])
self.password = Label(self.frame2,
text="Password",
bg="#a3c2c2",
font=('cooper black', 15))
self.password.place(x=140, y=220)
self.e3 = Entry(self.frame2,
font=('cooper black', 15),
show="*",
textvariable=self.passw)
self.e3.place(x=260, y=220)
self.con = StringVar(self.win)
self.con.set(recep[5])
self.contact = Label(self.frame2,
text="Contact",
bg="#a3c2c2",
font=('cooper black', 15))
self.contact.place(x=140, y=270)
self.e4 = Entry(self.frame2,
font=('cooper black', 15),
textvariable=self.con)
self.e4.place(x=260, y=270)
self.add = StringVar(self.win)
self.add.set(recep[6])
self.address = Label(self.frame2,
text="Address",
bg="#a3c2c2",
font=('cooper black', 15))
self.address.place(x=140, y=320)
self.e5 = Entry(self.frame2,
font=('cooper black', 15),
textvariable=self.add)
self.e5.place(x=260, y=320)
self.frame1 = Frame(self.win, height=5, width=600, bg="black")
self.frame1.place(x=0, y=545)
self.frame4 = Frame(self.win, height=45, width=600, bg="black")
self.frame4.place(x=0, y=555)
self.btn = Button(self.frame2,
text="Update",
bd=10,
activeforeground="black",
command=self.update,
bg="black",
fg="#a3c2c2",
font=('cooper black', 15))
self.btn.place(x=290, y=380)
self.win.mainloop()
def update(self):
data = (self.e1.get(), self.e2.get())
x = database_queries.database()
x.up(data)
def __init__(self, id_):
print(id_)
self.id = id_
obj = database_queries.database()
recep = obj.get_patient_byid(id_)
print(recep)
self.tk = Toplevel()
self.frame = Frame(self.tk, height=700, width=700)
self.frame.place(x=0, y=0)
height = self.tk.winfo_screenheight()
width = self.tk.winfo_screenwidth()
y = (height - 700) // 2
x = (width - 700) // 2
self.tk.geometry('700x700+' + str(x) + '+' + str(y))
self.tk.resizable(height=False, width=False)
self.can = Canvas(self.frame, height="700", width="700")
self.can.pack()
self.img = PhotoImage(file="./images/img2.gif")
self.can.create_image(0, 0, image=self.img, anchor=NW)
self.can.create_text(360,
100,
text="Edit Patient",
fill="#F1948A",
font=('Cooper Black', 35))
self.name = StringVar(self.tk)
self.name.set(recep[1])
self.can.create_text(175,
220,
text="Name",
fill="white",
font=('Cooper Black', 25))
self.e1 = Entry(self.frame,
font=('Cooper Black', 18),
borderwidth="2",
textvariable=self.name)
self.e1.place(x=310, y=210)
self.g = StringVar(self.tk, recep[2])
self.can.create_text(175,
270,
text="Gender",
fill="white",
font=('Cooper Black', 25))
self.r = Radiobutton(self.frame,
text="Male",
padx=10,
value="M",
fg="black",
font=('Cooper Black', 15),
variable=self.g)
self.r.place(x=310, y=260)
self.r = Radiobutton(self.frame,
text="Female",
padx=10,
value="F",
fg="black",
font=('Cooper Black', 15),
variable=self.g)
self.r.place(x=450, y=260)
self.a = StringVar(self.tk)
self.a.set(recep[3])
self.can.create_text(175,
320,
text="Age",
fill="white",
font=('Cooper Black', 25))
self.e3 = Entry(self.frame,
font=('Cooper Black', 18),
borderwidth="2",
textvariable=self.a)
self.e3.place(x=310, y=310)
self.c = StringVar(self.tk)
self.c.set(recep[4])
self.can.create_text(175,
370,
text="Contact",
fill="white",
font=('Cooper Black', 25))
self.e4 = Entry(self.frame,
font=('Cooper Black', 18),
borderwidth="2",
textvariable=self.c)
self.e4.place(x=310, y=360)
self.add = StringVar(self.tk)
self.add.set(recep[5])
self.can.create_text(175,
420,
text="Address",
fill="white",
font=('Cooper Black', 25))
self.e5 = Entry(self.frame,
font=('Cooper Black', 18),
borderwidth="2",
textvariable=self.add)
self.e5.place(x=310, y=410)
self.e = StringVar(self.tk)
self.e.set(recep[6])
self.can.create_text(175,
470,
text="Email",
fill="white",
font=('Cooper Black', 25))
self.e6 = Entry(self.frame,
font=('Cooper Black', 18),
borderwidth="2",
textvariable=self.e)
self.e6.place(x=310, y=460)
self.btn = Button(self.frame,
text="Update",
fg="#000080",
bg="#F1948A",
command=self.update,
font=('Cooper Black', 22))
self.btn.place(x=310, y=550)
self.tk.mainloop()
def __init__(self, n_):
print(n_)
self.n = n_
ob = database_queries.database()
re = ob.get_appoint_byn(n_)
print(re)
self.tk = Toplevel()
self.frame = Frame(self.tk, height=700, width=700)
self.frame.place(x=0, y=0)
height = self.tk.winfo_screenheight()
width = self.tk.winfo_screenwidth()
y = (height - 700) // 2
x = (width - 700) // 2
self.tk.geometry('700x700+' + str(x) + '+' + str(y))
self.tk.resizable(height=False, width=False)
self.can = Canvas(self.frame, height="700", width="700")
self.can.pack()
self.img = PhotoImage(file="./images/img2.gif")
self.can.create_image(0, 0, image=self.img, anchor=NW)
self.can.create_text(360,
100,
text="Edit appointment ",
fill="powder blue",
font=('Cooper Black', 35))
self.pn = StringVar(self.tk)
self.pn.set(re[2])
self.can.create_text(175,
220,
text="Patient Name",
fill="sandybrown",
font=('Cooper Black', 25))
self.e1 = Entry(self.frame,
font=('Cooper Black', 18),
borderwidth="2",
textvariable=self.pn)
self.e1.place(x=310, y=210)
self.t = StringVar(self.tk)
self.t.set(re[3])
self.can.create_text(175,
280,
text="Timing",
fill="sandybrown",
font=('Cooper Black', 25))
self.e2 = Entry(self.frame,
font=('Cooper Black', 18),
borderwidth="2",
textvariable=self.t)
self.e2.place(x=310, y=260)
self.date = StringVar(self.tk)
self.date.set(re[4])
self.can.create_text(175,
330,
text="Date",
fill="sandybrown",
font=('Cooper Black', 25))
self.dob = DateEntry(self.can,
font=('cooper balck', 12),
bg='darkblue',
fg='white',
borderwidth="2",
textvariable=self.date)
self.dob.place(x=310, y=310)
self.dob.config(width=30)
self.des = StringVar(self.tk)
self.des.set(re[5])
self.can.create_text(175,
380,
text="Description",
fill="sandybrown",
font=('Cooper Black', 25))
self.e4 = Entry(self.frame,
font=('Cooper Black', 18),
borderwidth="2",
textvariable=self.des)
self.e4.place(x=310, y=360)
self.btn = Button(self.frame,
text="Update",
fg="powder blue",
bg="black",
font=('Cooper Black', 22),
command=self.update)
self.btn.place(x=310, y=450)
self.tk.mainloop()
def trigger5(self):
t = database_queries.database()
t.logout()
