InventoryManager/main.py at master · nathanlytang/InventoryManager · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
'''
Inventory Manager
Nathan Tang
19/05/16
'''

import tkinter as tk
from tkinter import ttk
from tkinter import filedialog
import os
import sys
import csv
import functions
import sqlalchemy

root = tk.Tk()
root.wm_title("Inventory Manager")

filename = '%s\\inventory.db' % os.getcwd()

engine, connection, metadata, inventory, query, resultProxy, resultSet = functions.openSQL(filename)

def openKey(event):
    engine, connection, metadata, inventory, query, resultProxy, resultSet, filename = openFileTree(tree)
    return engine, connection, metadata, inventory, query, resultProxy, resultSet, filename


def newKey(event):
    engine, connection, metadata, inventory, query, resultProxy, resultSet, filename = newFileTree(tree)
    return engine, connection, metadata, inventory, query, resultProxy, resultSet, filename

def openFileTree(tree):
    global engine, connection, metadata, inventory, query, resultProxy, resultSet, filename
    engine.dispose()
    filename = functions.openFile(tree)
    engine, connection, metadata, inventory, query, resultProxy, resultSet = functions.openSQL(filename)
    return engine, connection, metadata, inventory, query, resultProxy, resultSet, filename

def newFileTree(tree):
    global engine, connection, metadata, inventory, query, resultProxy, resultSet, filename
    engine.dispose()
    filename = functions.newFile(tree)
    engine, connection, metadata, inventory, query, resultProxy, resultSet = functions.openSQL(filename)
    return engine, connection, metadata, inventory, query, resultProxy, resultSet, filename


# File Menu

file_menu = tk.Menu(root)
file_submenu = tk.Menu(file_menu, tearoff=False)
file_submenu.add_command(label = 'New         Ctrl+N', command=lambda: newFileTree(tree))
file_submenu.add_command(label = 'Open        Ctrl+O', command=lambda: openFileTree(tree))
file_submenu.add_separator()
file_submenu.add_command(label = 'Exit', command=lambda: root.quit())
file_menu.add_cascade(label = 'File', menu = file_submenu)

openFile = root.bind("<Control-o>", openKey)
directory = root.bind("<Control-n>", newKey)
root.config(menu=file_menu)

# Buttons
buttons = tk.Frame(bg='white')
buttons.pack(fill=tk.BOTH)

addButton = tk.Button(root, text='Add', relief=tk.FLAT, bg='white', command=lambda: functions.addMenu(tree, filename))
editButton = tk.Button(root, text='Edit', relief=tk.FLAT, bg='white', command=lambda: functions.editMenu(tree, filename))
delButton = tk.Button(root, text='Delete', relief=tk.FLAT, bg='white', command=lambda: functions.delItem(tree, filename))
checkOutButton = tk.Button(root, text='Check Out', relief=tk.FLAT, bg='white', command=lambda: functions.checkOut(tree, filename))
checkInButton = tk.Button(root, text='Check In', relief = tk.FLAT, bg='white', command=lambda: functions.checkIn(tree, filename))

addButton.pack(side=tk.LEFT, ipadx=5, ipady=5, in_=buttons)
editButton.pack(side=tk.LEFT, ipadx=5, ipady=5, in_=buttons)
delButton.pack(side=tk.LEFT, ipadx=5, ipady=5, in_=buttons)
checkOutButton.pack(side=tk.LEFT, ipadx=5, ipady=5, in_=buttons)
checkInButton.pack(side=tk.LEFT, ipadx=5, ipady=5, in_=buttons)

buttons.grid_columnconfigure(0, weight=1)
buttons.grid_rowconfigure(0, weight=1)


# Treeview
container = ttk.Frame()
container.pack(fill='both', expand=True)

treeColumns = ("Item","ID","Price","Available","Checked out","Description")
tree = ttk.Treeview(columns=treeColumns, show="headings")

for column in treeColumns:
    tree.heading(column, text=column, command=lambda c=column: functions.sort(tree, c, 0))

for i in treeColumns:
    tree.column(i, width=130, minwidth=30)

vsb = ttk.Scrollbar(orient="vertical", command=tree.yview) # Vertical scroll bar
hsb = ttk.Scrollbar(orient="horizontal", command=tree.xview) # Horizontal scroll bar

tree.configure(yscrollcommand=vsb.set, xscrollcommand=hsb.set)

vsb.grid(column=1, row=0, sticky='ns', in_=container)
hsb.grid(column=0, row=1, sticky='ew', in_=container)
tree.grid(column=0, row=0, sticky='nsew', in_=container)

container.grid_columnconfigure(0, weight=1)
container.grid_rowconfigure(0, weight=1)


functions.printTreeview(tree, filename)

root.mainloop()