# # -*- coding: utf-8 -*-
import mysql.connector as mysql
try:
    from tkinter import *
except ImportError:
    from Tkinter import *

### GUI section ###

root = Tk()
root.title('HOSPITAL APP')
root.geometry("1030x600")
canvas = Canvas(width=900, height=800, bg="#FFE5CC")
canvas.pack(fill="both", expand=True)

name = StringVar()
phone = StringVar()
email = StringVar()
reason = StringVar()
times = StringVar()
doctor = StringVar()
department = StringVar()

# def name_entry(your_name):
#     name.set(name.get() + your_name)
label = Label(canvas, text="Patient's Name", bg="#FFE5CC", anchor=N)
label.grid(row=1, column=0, padx=30)

txt_display = Entry(canvas, textvariable=name, width=23, bg='light blue', font=('arial', 12, 'bold'))
txt_display.grid(columnspan=200, row=2, column=0, padx=40)
name_string = txt_display.get()
name.set(name_string)

# def phone_entry(your_phone_nbr):
#     phone.set(phone.get() + your_phone_nbr)
label1 = Label(canvas, text="Phone number", bg="#FFE5CC", anchor=N)
label1.grid(row=3, column=0, padx=40)

txt_display1 = Entry(canvas, textvariable=phone, width=23, bg='light blue', font=('arial', 12, 'bold'))
txt_display1.grid(columnspan=2000, row=4, column=0, padx=40)
phone_string = txt_display1.get()
phone.set(phone_string)

# def email_entry(your_email):
#     email.set(email.get() + your_email)
label2 = Label(canvas, text="Email", bg="#FFE5CC", anchor=N)
label2.grid(row=5, column=0, padx=40)

txt_display2 = Entry(canvas, textvariable=email, width=23, bg='light blue', font=('arial', 12, 'bold'))
txt_display2.grid(columnspan=2000, row=6, column=0, padx=40)
email_string = txt_display2.get()
email.set(email_string)

# def reason_entry(your_reason):
#     reason.set(reason.get() + your_reason)
label3 = Label(canvas, text="Reason for Appointment", bg="#FFE5CC", anchor=N)
label3.grid(row=7, column=0, padx=40)

txt_display3 = Entry(canvas, textvariable=reason, width=23, bg='light blue', font=('arial', 12, 'bold'))
txt_display3.grid(columnspan=2000, row=8, column=0, padx=40)
reason_string = txt_display3.get()
reason = StringVar()
reason.set(reason_string)

# def time_entry(your_time):
#     time.set(times.get() + your_time)
label4 = Label(canvas, text="At What Time?", bg="#FFE5CC", anchor=N)
label4.grid(row=9, column=0, padx=40)

txt_display4 = Entry(canvas, textvariable=times, width=23, bg='light blue', font=('arial', 12, 'bold'))
txt_display4.grid(columnspan=2000, row=10, column=0, padx=40)
time_string = txt_display4.get()
times.set(time_string)

# def doctor_entry(your_doctor):
#     doctor.set(doctor.get() + your_doctor)
label5 = Label(canvas, text="Who's your Doctor?", bg="#FFE5CC", anchor=N)
label5.grid(row=11, column=0, padx=40)

txt_display5 = Entry(canvas, textvariable=doctor, width=23, bg='light blue', font=('arial', 12, 'bold'))
txt_display5.grid(columnspan=2000, row=12, column=0, padx=40)
doctor_string = txt_display5.get()
doctor.set(doctor_string)

# def department_entry(department):
#     department.set(department)
label6 = Label(canvas, text="Which Department?", bg="#FFE5CC", anchor=N)
label6.grid(row=13, column=0, padx=40)
# drop_down = OptionMenu(canvas, "Cardiology", "Child Hospital", "Dentistry", "Opticianry", "Physical Therapy")
# drop_down.grid(row=14, column=0, padx=40)

txt_display6 = Entry(canvas, width=23, textvariable=department, bg='light blue', font=('arial', 12, 'bold'))
txt_display6.grid(columnspan=2000, row=15, column=0, padx=40)
department_string = txt_display6.get()
department.set(department_string)

list_box = Listbox(canvas, width=40, height=20)
list_box.place(relx = 0.5, x =-2, y = 2, anchor=NE)
def list_entry():
    list_box.insert(END, name.get())
    list_box.insert(END, phone.get())
    list_box.insert(END, email.get())
    list_box.insert(END, reason.get())
    list_box.insert(END, times.get())
    list_box.insert(END, doctor.get())
    list_box.insert(END, department.get())
    def clear_txt():
        txt_display.delete(0, 'end')
        txt_display1.delete(0, 'end')
        txt_display2.delete(0, 'end')
        txt_display3.delete(0, 'end')
        txt_display4.delete(0, 'end')
        txt_display5.delete(0, 'end')
        txt_display6.delete(0, 'end')
    # clear_txt()

preview_bttn = Button(canvas, text="Preview", bg="white", width=9, command=list_entry)
preview_bttn.place(relx=0.59, x=-2, y=2, anchor=NE)


### Databse section ###

db = mysql.connect(host = "localhost", user = "root", passwd = "Amakuru17.", port = "3306", database = "appointments")
run = db.cursor()
querry = ("insert into appoint_tbl(patient_name, phone, email, reason, time_of_visit, doctor, department) values('%s', '%s', '%s', '%s', '%s', '%s', '%s')")
val = (name.get(), phone.get(), email.get(), reason.get(), times.get(), doctor.get(), department.get())

def data_submit():
    # list_box.delete(0, 'end')
    run.execute(querry, val)
    db.commit()
    print("data inserted")


submit_bttn = Button(canvas, text="Submit", bg="white", width=9, command=data_submit)
submit_bttn.place(relx=0.59, x=-2, y=80, anchor=NE)

root.mainloop()