main.py

import tkinter as tk
import tkinter.ttk
import sqlite3, os
from tkinter import messagebox, ttk,  simpledialog
import configparser
import popup, general, settings
from modules.functions import doSomething, about
from database import open_database_tree
from modules.functions import validate_float_input
from popup import show_frezen_popup, process_hours

def clear_entries():
    if messagebox.askyesno("New", "Do you want to start a new record?"):
        # Clear all entries
        for entry in general_info_entries.values():
            entry.delete(0, tk.END)
        for entry in bewerkingen_entries.values():
            entry.delete(0, tk.END)
        for entry in overige_kosten_entries.values():
            entry.delete(0, tk.END)
    else:
        # User clicked 'No', so do not update
#        messagebox.showinfo("Update", "Update is canceled.")
        print("Nothing.")

def com_price_calc(com_prijs_entry, com_ps_entry, quantity_value):
    quantity_value = int(general_info_entries ["Aantal stuks"].get())
    if com_prijs_entry is not None and com_ps_entry is None:
        com_prijs_entry = float(com_prijs_entry)  # Convert the string to a float
        com_ps_entry = com_prijs_entry / quantity_value
        com_ps_entry = "{:.2f}".format(com_ps_entry)
    elif com_ps_entry is not None and com_prijs_entry is None:
        com_ps_entry = float(com_ps_entry)  # Convert the string to a float
        com_prijs_entry = com_ps_entry * quantity_value
        com_prijs_entry = "{:.2f}".format(com_prijs_entry)
    elif com_ps_entry is not None and com_prijs_entry is not None:
        com_ps_entry = float(com_ps_entry)  # Convert the string to a float
        com_prijs_entry = com_ps_entry * quantity_value
        com_prijs_entry = "{:.2f}".format(com_prijs_entry)

    return com_prijs_entry, com_ps_entry

def update_commercial_prices():
    # Check if the input field for number of pieces contains a valid integer.
    try:
        quantity_value = int(general_info_entries["Aantal stuks"].get())
    except ValueError:
        messagebox.showerror("Fout", "Voer een geldig getal in voor 'Aantal stuks'.")
        return

    # Perform the calculations to update the commercial prices
    resultaat_prijs, resultaat_ps = com_price_calc(com_prijs_entry.get(), com_ps_entry.get(), quantity_value)
    com_prijs_entry.delete(0, tk.END)
    com_prijs_entry.insert(0, resultaat_prijs)
    com_ps_entry.delete(0, tk.END)
    com_ps_entry.insert(0, resultaat_ps)

    calculation()

# Function to update the quantity field and perform the calculations
def update_aantal_stuks(event):
    update_commercial_prices()

# Function to update on tab or enter                
def on_tab_or_enter(event):
    quantity_value = int(general_info_entries ["Aantal stuks"].get())

    if event.widget == com_prijs_entry:
        resultaat_prijs, resultaat_ps = com_price_calc(com_prijs_entry.get(), None, quantity_value)
        com_ps_entry.delete(0, tk.END)
        com_ps_entry.insert(0, resultaat_ps)
    elif event.widget == com_ps_entry:
        resultaat_prijs, resultaat_ps = com_price_calc(None, com_ps_entry.get(), quantity_value)
        com_prijs_entry.delete(0, tk.END)
        com_prijs_entry.insert(0, resultaat_prijs)  
    calculation()

# Function to create or update the settings.ini file
def create_settings_file(machine_tarief, werkplaats_tarief):
    config = configparser.ConfigParser()
    config["Settings"] = {}
    config["Settings"]["Machinetarief"] = str(machine_tarief)
    config["Settings"]["Werkplaatstarief"] = str(werkplaats_tarief)

    with open("settings.ini", "w") as configfile:
        config.write(configfile)

# Check if the settings.ini file exists
if not os.path.exists("settings.ini"):
    root = tk.Tk()
    root.withdraw()  # Hide the main window

    # Create a custom dialog box
    class Tariefdialoog(simpledialog.Dialog):
        def __init__(self, parent):
            super().__init__(parent, title="Settings")        
        def body(self, master):
            tk.Label(master, text="Machine tarief:").grid(row=0, sticky="w")
            tk.Label(master, text="€").grid(row=0, column=1, sticky="w")
            tk.Label(master, text="Werkplaats tarief:").grid(row=1, sticky="w")
            tk.Label(master, text="€").grid(row=1, column=1, sticky="w")

            self.machine_tarief_entry = tk.Entry(master)
            self.werkplaats_tarief_entry = tk.Entry(master)

            self.machine_tarief_entry.grid(row=0, column=2)
            self.werkplaats_tarief_entry.grid(row=1, column=2)

        def apply(self):
            machine_tarief = float(self.machine_tarief_entry.get())
            werkplaats_tarief = float(self.werkplaats_tarief_entry.get())
            create_settings_file(machine_tarief, werkplaats_tarief)

    dialog = Tariefdialoog(root)
    root.mainloop()

# Context menu
def make_textmenu(root):
	global the_menu
	the_menu = tk.Menu(root, tearoff=0)
	the_menu.add_command(label="Cut")
	the_menu.add_command(label="Copy")
	the_menu.add_command(label="Paste")
	the_menu.add_separator()
	the_menu.add_command(label="Select all")

def callback_select_all(event):
	# select text after 50ms
	root.after(50, lambda:event.widget.select_range(0, 'end'))

def show_textmenu(event):
	e_widget = event.widget
	the_menu.entryconfigure("Cut",command=lambda: e_widget.event_generate("<<Cut>>"))
	the_menu.entryconfigure("Copy",command=lambda: e_widget.event_generate("<<Copy>>"))
	the_menu.entryconfigure("Paste",command=lambda: e_widget.event_generate("<<Paste>>"))
	the_menu.entryconfigure("Select all",command=lambda: e_widget.select_range(0, 'end'))
	the_menu.tk.call("tk_popup", the_menu, event.x_root, event.y_root)

# Save function
def save():
    # Connect to database
    conn = sqlite3.connect('calculatie.db')
    cursor = conn.cursor()
    # Get total costs
    totaal_kosten = totaal_kosten_var.get()
    # Initialize the record_id variable
    record_id = None
    # print("ID:", record_id)
    # print("SID:", selected_record_id)

    if record_id:
        # Voer een SELECT-query uit om het 'ID'-veld op te halen
        cursor.execute("SELECT ID FROM calculatie WHERE id = ?", (record_id),)
        record_id_result = cursor.fetchone()
        record_id = record_id_result[0]
        notes = textbox.get("1.0", "end-1c")
              
        # Update the existing record in the database
        query = """
        UPDATE calculatie
        SET klant = ?, artikelnummer = ?, tekeningnummer = ?, revisie = ?,
            omschrijving = ?, stuks = ?, prijs = ?, code = ?, Zagen = ?, Draaien = ?,
            Frezen = ?, Slijpen_1 = ?, Slijpen_2 = ?, Slijpen_3 = ?, Rondslijpen = ?,
            CO_slijpen = ?, Draadvonken = ?, GM_Engineering = ?, material = ?,
            hardening = ?, treatment = ?, outsource = ?, tool_costs = ?, transport = ?, packaging = ?,
            notes = ?
        WHERE id = ?
        """
        values = (general_info_entries["Klant"].get(), 
                  general_info_entries["Artikelnummer"].get(), 
                  general_info_entries["Tekeningnummer"].get(), 
                  general_info_entries["Revisie"].get(), 
                  general_info_entries["Omschrijving"].get(),
                  general_info_entries["Aantal stuks"].get(),
                  totaal_kosten,
                  code_value,  # Use the retrieved value here
                  bewerkingen_entries["Zagen"].get(),
                  bewerkingen_entries["Draaien"].get(),
                  bewerkingen_entries["Frezen"].get(),
                  bewerkingen_entries["Slijpen 1"].get(),
                  bewerkingen_entries["Slijpen 2"].get(),
                  bewerkingen_entries["Slijpen 3"].get(),
                  bewerkingen_entries["Rondslijpen"].get(),
                  bewerkingen_entries["CO-slijpen"].get(),
                  bewerkingen_entries["Draadvonken"].get(),
                  bewerkingen_entries["GM/Engineering"].get(),
                  overige_kosten_entries["Materiaal p/s"].get(),
                  overige_kosten_entries["Harden Totaal"].get(),
                  overige_kosten_entries["Behandelingen totaal"].get(),
                  overige_kosten_entries["Uitbestedingen totaal"].get(),
                  overige_kosten_entries["Gereedschapskosten"].get(),
                  overige_kosten_entries["Transportkosten"].get(),
                  overige_kosten_entries["Verpakkingskosten"].get(),
                  notes.get(),
                  record_id[0]
        )
        print("ID:", record_id)
        # Ask for confirmation using messagebox.askyesno()
        if messagebox.askyesno("Update", "Do you want to update?"):
            # User clicked 'Yes', so proceed with the update
            cursor.execute(query, values)
            conn.commit()
            messagebox.showinfo("Update", "Record is updated.")
            print("Record is updated.")
        else:
            # User clicked 'No', so do not update
            messagebox.showinfo("Update", "Update is canceled.")
            print("Update is canceled.")
    else:
        notes = textbox.get("1.0", "end-1c")
        code_value = general_info_entries["Code"].get()
 #       print(code_value)
 #       print(general_info_entries["Code"].get())
        # Insert a new record into the database
        query = """        
        INSERT INTO calculatie (klant, artikelnummer, tekeningnummer, revisie,
                                omschrijving, stuks, prijs, code, Zagen, Draaien,
                                Frezen, Slijpen_1, Slijpen_2, Slijpen_3, Rondslijpen,
                                CO_slijpen, Draadvonken, GM_Engineering, material,
                                hardening, treatment, outsource, tool_costs, transport, packaging, notes)
        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        """
        values = (general_info_entries["Klant"].get(), 
                  general_info_entries["Artikelnummer"].get(), 
                  general_info_entries["Tekeningnummer"].get(), 
                  general_info_entries["Revisie"].get(), 
                  general_info_entries["Omschrijving"].get(),
                  general_info_entries["Aantal stuks"].get(),
                  totaal_kosten,
                  code_value,
                  bewerkingen_entries["Zagen"].get(),
                  bewerkingen_entries["Draaien"].get(),
                  bewerkingen_entries["Frezen"].get(),
                  bewerkingen_entries["Slijpen 1"].get(),
                  bewerkingen_entries["Slijpen 2"].get(),
                  bewerkingen_entries["Slijpen 3"].get(),
                  bewerkingen_entries["Rondslijpen"].get(),
                  bewerkingen_entries["CO-slijpen"].get(),
                  bewerkingen_entries["Draadvonken"].get(),
                  bewerkingen_entries["GM/Engineering"].get(),
                  overige_kosten_entries["Materiaal p/s"].get(),
                  overige_kosten_entries["Harden Totaal"].get(),
                  overige_kosten_entries["Behandelingen totaal"].get(),
                  overige_kosten_entries["Uitbestedingen totaal"].get(),
                  overige_kosten_entries["Gereedschapskosten"].get(),
                  overige_kosten_entries["Transportkosten"].get(),
                  overige_kosten_entries["Verpakkingskosten"].get(),
                  notes,
                  )
        if messagebox.askyesno("Save", "Do you want to save?"):
            cursor.execute(query, values)
            conn.commit()
            messagebox.showinfo("Save", "Record succesfully saved!")
            print("Record succesfully saved in database!.")
        else:
            # User clicked 'No', so do not update
            messagebox.showinfo("Save", "Save is canceled.")
            print("Save is canceled.")

    # Close databas connection
    conn.close()

# Calculation

def calculation():
    global machine_uren, werkplaats_uren, quantity_value, mill_entry, totaal_kosten_value, textbox
    
  # Get the total milling hours
    mill_hours = mill_entry.get()
    if mill_hours:
        mill_hours = float(mill_hours)

    # Add up the total number of working hours.
    bewerkingsuren = {}
    for bewerking, entry in bewerkingen_entries.items():
        operation_hours = entry.get()
        if operation_hours:
            hours = float(operation_hours)
            if bewerking == "Frezen":
                hours += (mill_hours or 0)  # Voeg mill_hours alleen toe aan machine_uren
            bewerkingsuren[bewerking] = hours
    

    # Calculate total hours for machine and workplace 
    machine_uren = sum(bewerkingsuren.get(bewerking, 0) for bewerking in ["Draaien", "Slijpen 1", "Slijpen 2", "Slijpen 3", "Rondslijpen", "CO-slijpen", "Draadvonken"]) + (mill_hours or 0)
    werkplaats_uren = sum(bewerkingsuren.get(bewerking, 0) for bewerking in ["Zagen", "GM/Engineering"])

    # Adding material and treatment costs.
    overige_kosten = {}
    for behandeling, entry in overige_kosten_entries.items():
        value = entry.get()
        if value:
            overige_kosten[behandeling] = float(value) * 1.2

    # Calculate material costs
    quantity_value = int(general_info_entries ["Aantal stuks"].get())
    material_piece_value = float(overige_kosten_entries["Materiaal p/s"].get())
    material_costs = quantity_value * material_piece_value * 1.2

    # calculate total costs and price per piece
    totaal_kosten = (machine_uren * machine_tarief) + (werkplaats_uren * werkplaats_tarief) + sum(
    value for behandeling, value in overige_kosten.items() if behandeling != "Materiaal p/s") + material_costs
    stuksprijs = totaal_kosten / quantity_value

    # Show total costs and price per piece
    totaal_kosten_var.set("{:.2f}".format(totaal_kosten))
    totaal_kosten_var.set("{:.2f}".format(totaal_kosten))
    stuksprijs_var.set("{:.2f}".format(stuksprijs))

    # Needs some checking if this works with sql how it is build now.
    #totaal_kosten_var.set(" €{:.2f} ".format(totaal_kosten))
    #stuksprijs_var.set(" €{:.2f} ".format(stuksprijs))

root = tk.Tk()
root.title("Calculatieprogramma PSS")
root.geometry("1650x768")
root.minsize(width=1024, height=768)
#root.grid_rowconfigure(0, weight=1)
#root.grid_columnconfigure(0, weight=1)
root.iconbitmap(r"images/pss.ico")
menubar = tk.Menu(root)

# Key bindings for context menu
root.bind_class("Entry", "<Button-3><ButtonRelease-3>", show_textmenu)
root.bind_class("Entry", "<Control-a>", callback_select_all)
make_textmenu(root)

totaal_kosten_var = tk.StringVar()
totaal_kosten_var.set("")
stuksprijs_var = tk.StringVar()
stuksprijs_var.set("")

# Make File-menu
file_menu = tk.Menu(menubar, tearoff=0)
file_menu.add_command(label="New", command=clear_entries)
file_menu.add_command(label="Open", command=lambda: open_database_tree(general_info_entries, bewerkingen_entries, overige_kosten_entries, mill_entry, totaal_kosten_value, textbox, stuksprijs_value,com_ps_entry, com_prijs_entry))
file_menu.add_command(label="Save", command=doSomething)
file_menu.add_command(label="Settings", command=settings.open_settings)
file_menu.add_command(label="Search")
file_menu.add_command(label="Database",command=lambda: open_database_tree(general_info_entries, bewerkingen_entries, overige_kosten_entries, mill_entry, totaal_kosten_value, textbox, stuksprijs_value,com_ps_entry, com_prijs_entry))
file_menu.add_separator()
file_menu.add_command(label="Exit", command=root.quit)
menubar.add_cascade(label="File", menu=file_menu)

# Make Edit-menu
edit_menu = tk.Menu(menubar, tearoff=0)
edit_menu.add_command(label="Cut", command=doSomething)
edit_menu.add_command(label="Copy", command=doSomething)
edit_menu.add_command(label="Paste", command=doSomething)
menubar.add_cascade(label="Edit", menu=edit_menu)

# Make Help-menu
help_menu = tk.Menu(menubar, tearoff=0)
help_menu.add_command(label="About", command=about)
menubar.add_cascade(label="Help", menu=help_menu)

# Insert menu in root window
root.config(menu=menubar)

# Settings file
config = configparser.ConfigParser()
config.read("settings.ini")
machine_tarief = float(config.get("Settings", "Machinetarief"))
werkplaats_tarief = float(config.get("Settings", "Werkplaatstarief"))



# Header frame
header_frame = tk.Frame(root, relief="ridge", borderwidth=5)
header_frame.grid(row=0, column=0, columnspan=2, sticky="ew")
header_frame.columnconfigure(0, weight=1) # Configure column to expand and center

# frame for general info
gen_info_frame = tk.Frame(header_frame, bd=1, relief="solid")
gen_info_frame.grid(padx=0, pady=10, sticky="nw")

# Call the function create_general_info_frame to make the general info frame.
general_info_entries, general_info_frame = general.create_general_info_frame(gen_info_frame)

bewerkingen_entries = {}
bewerkingen = [
    ("Zagen", "zagen"),
    ("Draaien", "draaien"),
    ("Frezen", "frezen"), 
    #("Frezen", lambda: show_frezen_popup(root)),
    ("Slijpen 1", "slijpen1"),
    ("Slijpen 2", "slijpen2"),
    ("Slijpen 3", "slijpen3"),
    ("Rondslijpen", "rondslijpen"),
    ("CO-slijpen", "coslijpen"),
    ("Draadvonken", "draadvonken"),
    ("GM/Engineering", "gm_eng")
]

# Frame for operations
operations_frame = tk.Frame(header_frame, bd=1, relief="solid")
operations_frame.grid(row=0, column=1, padx=(20, 0), pady=10, sticky="nw")


def update_mill_time(result):
    mill_entry.delete(0, tk.END)
    mill_entry.insert(0, result)

# Milling time from pop-up
# mill_time = popup.freesuren_var.get

row = 2
column = 0
for i, (bewerking, command) in enumerate(bewerkingen):
    if bewerking == "Frezen":
        label = tk.Button(operations_frame, text=bewerking, width=15, command=popup.show_frezen_popup)
    else:
        label = tk.Button(operations_frame, text=bewerking, width=15, command=doSomething)
    
    label.grid(row=row, column=column, sticky="ew", padx=5, pady=1)

    if bewerking == "Frezen":
        mill_entry = tk.Entry(operations_frame, width=10, validate="key")
        mill_entry.grid(row=row, column=column+1)
        mill_entry.config(validatecommand=(entry.register(validate_float_input), "%P"))
    else:
        entry = tk.Entry(operations_frame, width=10, validate="key")
        entry.grid(row=row, column=column+1)
        entry.config(validatecommand=(entry.register(validate_float_input), "%P"))    

    bewerkingen_entries[bewerking] = entry

    row += 1

    if (i + 1) % 5 == 0:
        row = 2
        column += 2

overige_kosten_entries = {}
overige_kosten = [
    ("Materiaal p/s", "material"),
    ("Harden Totaal", "hardening"),
    ("Behandelingen totaal", "treatment"),
    ("Uitbestedingen totaal", "outsource"),
    ("Gereedschapskosten", "tool_costs"),
    ("Transportkosten", "tansport"),
    ("Verpakkingskosten", "packaging"),
]

# Vertical separator
separator = tk.ttk.Separator(header_frame, orient='vertical')
separator.grid(row=0, column=2, padx=(10,0), pady=10, sticky='ns')

# Frame for other costs
overige_kosten_frame = tk.Frame(header_frame, bd=1, relief="solid")
overige_kosten_frame.grid(row=0, column=3, pady=10, padx=10, sticky="nw")

overige_kosten_frame.grid_rowconfigure(0, pad=10)
overige_kosten_frame.grid_rowconfigure(len(overige_kosten) + 1, pad=10)
overige_kosten_frame.grid_columnconfigure(0, minsize=10)
overige_kosten_frame.grid_columnconfigure(1, minsize=10)

row = 1
column = 0

for i, (behandeling, command) in enumerate(overige_kosten):
        label = tk.Label(overige_kosten_frame, text=behandeling, width=17, anchor="w")
        label.grid(row=row, column=column, sticky="nsew", padx=5)

        entry = tk.Entry(overige_kosten_frame, width=10, validate="key")
        entry.grid(row=row, column=column + 1, sticky="nsew", padx=5)
        entry.insert(0, "0")
        entry.config(validatecommand=(entry.register(validate_float_input), "%P")) 
        overige_kosten_entries[behandeling] = entry

        row += 1
        if (i + 1) % 7 == 0:
            row = 1
            column += 3


# Frame for textbox
textbox_frame = tk.Frame(header_frame, bd=1, relief="solid")
textbox_frame.grid(row=0, column=5, pady=10, padx=10, sticky="nw")
textbox = tk.Text(textbox_frame, height=9, width=50)
textbox.grid(row=0)

# Frame for the buttons
button_frame = tk.Frame(header_frame)
button_frame.grid(row=1, column=0, padx=10, sticky="w")

calculate_button = tk.Button(button_frame, text="Calculate", command=calculation)
calculate_button.grid(row=0, column=0)
save_button = tk.Button(button_frame, text="Save", command=save)
save_button.grid(row=0, column=1, padx=5)
# update_button = tk.Button(button_frame, text="Update")
# update_button.grid(row=0, column=2, sticky="w", padx=5)

# Frame for total costs and commercial costs
costs_frame = tk.Frame(header_frame, bd=1, relief="groove", padx=5, pady=5)
costs_frame.grid(row=0, column=6, pady=10, padx=20, sticky="nw")

# Total price entry
totaal_kosten_label = tk.Label(costs_frame, text="Prijs totaal", width=14, anchor="w", font=("Segoe UI", 10, "bold"))
totaal_kosten_label.grid(row=row, column=0, sticky="w")
euro_label = tk.Label(costs_frame, width=1, text="€", anchor="w", font=("Segoe UI", 10, "bold"))
euro_label.grid(row=row, column=1, sticky="w")
totaal_kosten_value = tk.Entry(costs_frame, textvariable=totaal_kosten_var, width=13, state='readonly', font=("Segoe UI", 10, "bold"))
totaal_kosten_value.grid(row=row, column=2, padx=5, sticky="w")

# Price per piece entry
stuksprijs_label = tk.Label(costs_frame, text="Prijs per stuk", width=14, anchor="w", font=("Segoe UI", 10, "bold"))
stuksprijs_label.grid(row=row +1, column=0, sticky="w")
euro_label = tk.Label(costs_frame, width=1, text="€", anchor="w", font=("Segoe UI", 10, "bold"))
euro_label.grid(row=row +1, column=1, sticky="w")
stuksprijs_value = tk.Entry(costs_frame, text= "€", textvariable=stuksprijs_var, width=13, state='readonly', font=("Segoe UI", 10, "bold"))
stuksprijs_value.grid(row=row +1, column=2, padx=5, sticky="w")


# Commercial price per piece
prijs_com_label = tk.Label(costs_frame, text="Commercieel p/s", width=14, anchor="w", font=("Segoe UI", 10, "bold"))
prijs_com_label.grid(row=row +2, column=0, sticky="w")
euro_label = tk.Label(costs_frame, width=1, text="€", anchor="w", font=("Segoe UI", 10, "bold"))
euro_label.grid(row=row +2, column=1, sticky="w")
com_ps_entry = tk.Entry(costs_frame, width=13, font=("Segoe UI", 10, "bold"))
com_ps_entry.grid(row=row +2, column=2, sticky="w", padx=5)

# Commercial price total
prijs_com_label = tk.Label(costs_frame, text="Commercieel totaal", width=15, anchor="w", font=("Segoe UI", 10, "bold"))
prijs_com_label.grid(row=row +3, column=0, sticky="w")
euro_label = tk.Label(costs_frame, width=1, text="€", anchor="w", font=("Segoe UI", 10, "bold"))
euro_label.grid(row=row +3, column=1, sticky="w")
com_prijs_entry = tk.Entry(costs_frame, width=13, font=("Segoe UI", 10, "bold"))
com_prijs_entry.grid(row=row +3, column=2, sticky="w", padx=5)

# Frame for tabs
tab_frame = tk.Frame(root, padx=50, pady=50)
tab_frame.grid(row=3, column=0, sticky="nw")
button = tk.Button(tab_frame, text="Don't click me")
button.grid

# Update on enter or tab
for entry in general_info_entries.values():
    entry.bind("<Tab>", on_tab_or_enter)
    entry.bind("<Return>", on_tab_or_enter)
#    entry.bind("<Key>", on_tab_or_enter)
for entry in bewerkingen_entries.values():
    entry.bind("<Tab>", on_tab_or_enter)
    entry.bind("<Return>", on_tab_or_enter)
#    entry.bind("<Key>", on_tab_or_enter)
    mill_entry.bind("<Tab>", on_tab_or_enter)
    mill_entry.bind("<Return>", on_tab_or_enter)
#    mill_entry.bind("<Key>", on_tab_or_enter)
for entry in overige_kosten_entries.values():
    entry.bind("<Tab>", on_tab_or_enter)
    entry.bind("<Return>", on_tab_or_enter)
#    entry.bind("<Key>", on_tab_or_enter)
com_prijs_entry.bind("<Tab>", on_tab_or_enter)
com_prijs_entry.bind("<Return>", on_tab_or_enter)
com_ps_entry.bind("<Tab>", on_tab_or_enter)  
com_ps_entry.bind("<Return>", on_tab_or_enter)

#  Bind the new function 'update_aantal_stuks' to the input field for number of pieces
def update_aantal_stuks(event):
    update_commercial_prices()

# Bind the new function 'update_aantal_stuks' to the input field for the number of pieces
general_info_entries["Aantal stuks"].bind("<FocusOut>", update_aantal_stuks)
general_info_entries["Aantal stuks"].bind("<Return>", update_aantal_stuks)

process_hours.result_callback = update_mill_time  # Stel de callbackfunctie in

root.mainloop()