#IMPORT MODULES
from tkinter import filedialog
from tkinter import *
import pandas
import os
import csv
from tkinter.ttk import *
from tkinter import ttk

#-------------CHART-------------#
#BT = BUTTONS
#LB = LABELS

#GLOBAL VAR
global count
count = 0

global filepath
filepath=''

global data_frame
data_frame = ''

global data_frame_stock
data_frame_stock = ''

#WINDOW CONFIGURATION
window = Tk()
window.title('Optimisation coupe')
window.geometry('720x720')
window.grid_rowconfigure(0,weight=1)
window.grid_columnconfigure(0,weight=1)

#window.resizable(0,0)

#PROCEDURES
def proc_importbtn():
    
    filepath =  filedialog.askopenfilename(initialdir = '/',title = 'Select file',filetypes = [('Csv files','*.csv')])
    count = func_count_rows(filepath)
    
    if filepath != '':
        LB_path.config(text=filepath)
        data_frame = pandas.read_csv(filepath,sep=';')
        
        scrollbar = Scrollbar(tab1,orient='vertical')
        scrollbar.grid(row=5,column=5,sticky='ns',rowspan=count)
        
        if count > 0:
            rows=[]
            for x in range(0,count):
                cols=[]
                col = x + 5
                for y in range(0,4):
                    loc = data_frame.iloc[x,y]
                    e = Entry(tab1)
                    e.grid(row=col, column=y, sticky=NSEW)
                    e.insert(END,loc)
                    cols.append(e)
                    e.config(state='disabled')
            rows.append(cols)

            BT_calcul_chute = Button(tab1,text='Calculate',command= lambda: proc_calcul_chute(data_frame,data_frame_stock))
            BT_calcul_chute.grid(sticky=NSEW,row=col+1)

#FUNCTIONS
def func_count_rows(filepath):
    line_count=0
    with open(filepath,'r') as csv_file:
        csv_reader = csv.reader(csv_file)
        next(csv_reader)
        for row in csv_reader:
            line_count += 1
    return(line_count)

def func_entry_creation(window, caption, posy, posx, **options):
    entry = Entry(window)
    entry.grid(row=posx,column=posy)
    entry.insert(END,caption)
    entry.config(state='disable')
    return(entry)

def func_LB_creation(name,window,caption,posy,posx,**options):
    name = Label(window,text=caption)
    name.grid(row=posx,column=posy,**options)
    return(name)

def proc_calcul_chute(data_frame,data_frame_stock):
    if data_frame_stock.iloc[0,0] != data_frame.iloc[1,0]:
        print("ok")
    loc2= data_frame_stock.iloc[1,2]
    loc= data_frame.iloc[1,2]

    
#MAIN
    
tab_control = ttk.Notebook(window)
tab1 = ttk.Frame(tab_control)
tab2 = ttk.Frame(tab_control)
tab_control.add(tab1, text='Optimisation')
tab_control.add(tab2, text='Stock')
tab_control.grid(column=0,row=0)

#WINDOW1
LB_description = func_LB_creation('LB_description',tab1,'Current file in use : ',0,1,sticky=W)
LB_path = func_LB_creation('LB_path',tab1,'No file selected',1,1,sticky=W)
LB_profile = func_LB_creation('LB_profile',tab1,'Profil',0,3,sticky=W)
LB_section = func_LB_creation('LB_section',tab1,'Section',1,3,sticky=W)
LB_quantite = func_LB_creation('LB_quantite',tab1,'Quantité',2,3,sticky=W)
LB_longueur = func_LB_creation('LB_longueur',tab1,'Longueur (mm)',3,3,sticky=W)

BT_import = Button(tab1, text='Import .csv file', command=proc_importbtn)
BT_import.grid(column=0, row=2, sticky=W)


#WINDOW2
data_frame_stock = pandas.read_csv('stock.csv',sep=';')
count = func_count_rows('stock.csv')

LB_profile = func_LB_creation('LB_profile',tab2,'Profile',0,0,sticky=W)
LB_section = func_LB_creation('LB_section',tab2,'Section',1,0,sticky=W)
LB_longueur = func_LB_creation('LB_longueur',tab2,'Longueur (mm)',2,0,sticky=W)

rows=[]
for x in range(0,count):
    cols=[]
    col = x + 1
    for y in range(0,3):
        loc = data_frame_stock.iloc[x,y]
        e = Entry(tab2)
        e.grid(row=col, column=y, sticky=NSEW)
        e.insert(END,loc)
        cols.append(e)
        e.config(state='disabled')
    rows.append(cols)

#WINDOW LOOP
window.mainloop()