def refresh():
    global connected
    if connected == True:
        table_data = connectTools.query("inventory", "*")
    else:
        connected = connectTools.connect()
        table_data = connectTools.query("inventory", "*")
def generateDailyReport():
    global connected
    if connected == False:
        connected = connectTools.connect()
        connectTools.generateDailyReport()
        connectTools.disconnect()
    else:
        connectTools.generateDailyReport()
def createWindow():
    global inventory
    global root
    global main
    global button_panel
    global table_data
    global connected
    if connected == True:
        table_data = connectTools.query("inventory", "*")
    else:
        connected = connectTools.connect()
        table_data = connectTools.query("inventory", "*")
    columns = ("item_id", "quantity", "category", "price", "cost",
                            "desired_quantity", "sale", "sale_start", "sale_end",
                            "sale_price" , "supplier")
    proper_columns = ("Item ID", "Quantity", "Category", "Price", "Cost",
                      "Desired Quantity", "Sale?", "Sale Start Date", "Sale End Date",
                      "Sale Price", "Supplier")
    proper_widths = (85, 55, 80, 60, 60, 100, 40, 100, 100, 60, 80)
    
    root = tk.Tk()
    root.wm_title("Modify Inventory")
    root.resizable(width=FALSE, height=FALSE)
    root.geometry('{}x{}'.format(950,600))#Size of the window
    main = tk.Frame(root)
    main.grid(sticky="nesw")
    main.columnconfigure(0,weight=1)
    main.rowconfigure(0,weight=1)
    button_panel = tk.Frame(root)
    button_panel.grid(row=0, column=1)
    inventory = ttk.Treeview(main, columns=(columns), show="headings")
    inventory["columns"] = columns
    for headings in range(0,len(proper_columns)):
        inventory.heading(headings, text=proper_columns[headings])
        inventory.column(columns[headings], width=proper_widths[headings])
    for row in range(0, len(table_data)):
        inventory.insert("", row, values=table_data[row])
    ##xsb = ttk.Scrollbar(inventory, orient='horizontal', command=inventory.xview)
    ##xsb.grid(row=1, column=1, sticky='ew')
    inventory.grid(row=0, column=0, sticky='ns')
    ##ysb = ttk.Scrollbar(inventory, orient='vertical', command=inventory.yview)
    add = tk.Button(button_panel, text="Add", command=addItem, width=17, height=10)
    add.grid(row=0, column=0, columnspan=1, rowspan=1)
    modify = tk.Button(button_panel, text="Modify", command=modifyItem, width=17, height=10)
    modify.grid(row=1, column=0, columnspan=1, rowspan=1)
    close = tk.Button(button_panel, text="Exit", command=root.destroy, width=17, height=10)
    close.grid(row=2, column=0, columnspan=1, rowspan=1)
    ##inventory.bind('<ButtonRelease-1>', selectItem)
    ##root.grid(10, 10, 5, 5)
    root.mainloop()