#from PIL import ImageTk, Image
from tkinter import ttk
from tkinter import *

def insertData():
    empID_field.delete(0,END)
    empID_field.insert(END,12345)
    empName_field.delete(0,END)
    empName_field.insert(END,"GirishLukka")
    empSal_field.delete(0,END)
    empSal_field.insert(END,13000)
    empJob_field.insert(END,"UX/UI")
    empImgLoc_field.insert(END,'img/st1.png')
    empStatus_field.insert(END,1)

def clearData():
    empID_field.delete(0,END)
    empName_field.delete(0,END)
    empJob_field.delete(0,END)
    empSal_field.delete(0,END)
    empImgLoc_field.delete(0,END)
    empStatus_field.delete(0,END)

def clearEmp(event):
    empID_field.delete(0,END)
    empName_field.delete(0,END)
    empJob_field.delete(0,END)
    empSal_field.delete(0,END)
    empImgLoc_field.delete(0,END)
    empStatus_field.delete(0,END)

def view():
    records = empDB.view()
    print(records)
    clearTree()
    for row in records:
        tv.insert("", 0, values=row)

def dbAdd():
    name = empName_field.get()
    job = empJob_field.get()
    sal = empSal_field.get()
    img = empImgLoc_field.get()
    print(name,job,sal,img)
    empDB.insert(name,job,sal,img)

def closeWindow():
    win.destroy()

def insertTree():
    for row in list:
        tv.insert("", 0, values=row)
    #tv.insert('',END,values=row)

def clearTree():
    x = tv.get_children()
    print("Tree :", x)
    for item in x:
        tv.delete(item)

def clearTrees(event):
    x = tv.get_children()
    print("Tree :", x)
    for item in x:
        tv.delete(item)

def select_item(event):
    row = tv.item(tv.selection())
    print("row",type(row),row)
    item = tv.selection()[0]
    print ('item clicked ', item)
    print (tv.item(item)['values'][0])
    empID_field.delete(0,END)
    empName_field.delete(0,END)
    empSal_field.delete(0,END)
    empJob_field.delete(0,END)
    empImgLoc_field.delete(0,END)
    empStatus_field.delete(0,END)
    empID_field.insert(END,row['values'][0])
    empName_field.insert(END,row['values'][1])
    empSal_field.insert(END,row['values'][2])
    empJob_field.insert(END,row['values'][3])
    empImgLoc_field.insert(END,row['values'][4])
    empStatus_field.insert(END,row['values'][5])





#creates main window
win = Tk()

win.title("Emplyoee Application")
win.geometry("800x500")
win.configure(bg='#212121')

#creates employee panel
empFrame = LabelFrame(win, text='Employee panel')
empFrame.grid(row=0, column=0, sticky=NSEW, padx=8, pady=8)
empFrame.configure(bg='#424242', fg="#FFFFFF")
empFrame.bind('<Double-Button-1>', clearEmp)

#for child in empFrame.winfo_children():
    #child.grid_configure(padx=5, pady=5, sticky= NW)

#creats label empID and place in employee panel
empID = Label(empFrame, text='EmpID: ')
empID.grid(row=0, column=0)
empName = Label(empFrame, text="Emp name")
empName.grid(row=1, column=0)
empSal = Label(empFrame, text="Emp Salary")
empSal.grid(row=2, column=0)
empJob = Label(empFrame,text="Emp Job")
empJob.grid(row=3, column=0)
empImgLoc = Label(empFrame, text="Emp Img Loc")
empImgLoc.grid(row=4, column=0)
empStatus = Label(empFrame, text="Emp Status")
empStatus.grid(row=5, column=0)

#Declare variables as string
empID_text = StringVar()
empName_text = StringVar()
empSal_text = StringVar()
empJob_text = StringVar()
empImgLoc_text = StringVar()
empStatus_text = StringVar()

#creates empID_field that can hold empID_text / uses entry widget
empID_field = Entry(empFrame, textvariable = empID_text)
empID_field.grid(row=0, column=1)
empName_field = Entry(empFrame, textvariable = empName_text)
empName_field.grid(row=1, column=1)
empSal_field = Entry(empFrame, textvariable = empSal_text)
empSal_field.grid(row=2, column=1)
empJob_field = Entry(empFrame, textvariable = empJob_text)
empJob_field.grid(row=3, column=1)
empImgLoc_field = Entry(empFrame, textvariable = empImgLoc_text)
empImgLoc_field.grid(row=4, column=1)
empStatus_field = Entry(empFrame, textvariable = empStatus_text)
empStatus_field.grid(row=5, column=1)

#creates action panel and button
btnFrame = LabelFrame(win, text='Action panel:')
btnFrame.grid(row=0, column=3, sticky=E, padx=8, pady=8)
btnFrame.configure(bg='#424242', fg='#FFFFFF')
b1=Button(btnFrame, text="View all", width=12, command=view) #command=viewALL
b1.grid(row=0, column=0)
b2=Button(btnFrame, text="Add New", width=12)
b2.grid(row=1, column=0)
b3=Button(btnFrame, text="Delete", width=12)
b3.grid(row=2, column=0)
b4=Button(btnFrame, text="Amend", width=12)
b4.grid(row=3, column=0)
b5=Button(btnFrame, text="Search", width=12)
b5.grid(row=4, column=0)
b6=Button(btnFrame, text="Clear Display", width=12, command=clearData)
b6.grid(row=5, column=0)
b7=Button(btnFrame, text="Quit", width=12, command=closeWindow)
b7.grid(row=6, column=0)
b8=Button(btnFrame, text="Insert", width=12, command=insertData)
b8.grid(row=6, column=1)
b9=Button(btnFrame, text="Insert Tree", width=12, command=insertTree)
b9.grid(row=5, column=1)
b10=Button(btnFrame, text="Clear Tree", width=12, command=clearTree)
b10.grid(row=4, column=1)

#creates new panel and Table
dispFrame = LabelFrame(win, text='Displaypanel:')
dispFrame.configure(background='#424242', fg='#FFFFFF')
dispFrame.grid(row=1, column=0, sticky=N, padx=8, pady=8)

tv = ttk.Treeview(dispFrame, height=10, columns=3)
tv.grid(row=1, column=1, columnspan=2)
tv["columns"] = ["Emp ID", "Emp Name", "Job title", "Salary", "Image Location", "Status"]
tv["show"] = "headings"
tv.heading("Emp ID", text="Emp ID")
tv.column("Emp ID", anchor='center', width=70)
tv.heading("Emp Name", text="Emp Name")
tv.column("Emp Name", anchor='center', width=100)
tv.heading("Job title", text="Job title")
tv.column("Job title", anchor='center', width=100)
tv.heading("Salary", text="Salary")
tv.column("Salary", anchor='center', width=70)
tv.heading("Image Location", text="Image Location")
tv.column("Image Location", anchor='center', width=100)
tv.heading("Status", text="Status")
tv.column("Status", anchor='center', width=70)
tv.bind('<Double-Button-1>', clearTrees)
tv.bind('<ButtonRelease-1>', select_item)

#creates Scrollbar
sb1 = Scrollbar(dispFrame,command=tv.yview,
orient=VERTICAL)
sb1.grid(row=0,column=7,rowspan=2,sticky='ns')
tv.configure(yscrollcommand=sb1.set)


list=[
(21, 'Any and All', 'analyst',18000,'img/st2.png',1),
(22, 'Any and All', 'analyst',18000,'img/st2.png'),
(23, 'Any and All', 'analyst',18000,'img/st2.png'),
(24, 'Any and All', 'analyst',18000,'img/st2.png'),
(25, 'Any and All', 'analyst',18000,'img/st2.png'),
(26, 'Any and All', 'analyst',18000,'img/st2.png'),
(27, 'Any and All', 'analyst',18000,'img/st2.png'),
(21, 'Any and All', 'analyst',18000,'img/st2.png'),
(22, 'Any and All', 'analyst',18000,'img/st2.png'),
(23, 'Any and All', 'analyst',18000,'img/st2.png'),
(24, 'Any and All', 'analyst',18000,'img/st2.png'),
(25, 'Any and All', 'analyst',18000,'img/st2.png'),
(26, 'Any and All', 'analyst',18000,'img/st2.png'),
(27, 'Any and All', 'analyst',18000,'img/st2.png')
]

#creates a message panel
msgFrame = LabelFrame(win, text = 'Message panel: ')
msgFrame.configure(bg = '#424242', fg="#FFFFFF")
msgFrame.grid(row = 1, column = 3, sticky = NSEW, padx = 8, pady = 8)
msg = Label(msgFrame, text = 'Msg Display to alert \nwhat button is activated\nand any other info', fg ="black")
msg.grid(row = 0, column = 0, padx = 8, pady = 8)

#keep window alive and respond to any events until it is closed
win.mainloop()