def movement():
prods = []
locs = []
db = get_db()
products = db.execute('SELECT * FROM product ORDER BY id ASC')
location = db.execute('SELECT * FROM location ORDER BY id ASC')
movements = db.execute('SELECT * FROM product_movement ORDER BY id DESC')
for i in products:
prods.append(i)
for j in location:
locs.append(j)
if request.method == 'POST':
products_to = request.form['to']
products_from = request.form['from']
products_to_move = request.form['products']
qty = request.form['quantity']
if products_to and products_from and products_to_move and qty:
db = get_db()
db.execute(
'INSERT INTO product_movement (prod_id, from_loc, to_loc, quantity) VALUES (?, ?, ?, ?)',
(products_to_move, products_from, products_to, qty))
db.commit()
return redirect(url_for('movement.movement'))
return render_template('movement/movement.html',
products=prods,
location=locs,
movements=movements)
def warehouse():
db = get_db()
all = db.execute('SELECT * FROM location ORDER BY loc_name')
if request.method == 'POST':
ware_house = request.form['warehouse']
print(ware_house)
if ware_house:
db = get_db()
db.execute('INSERT INTO location (loc_name) VALUES (?)',
(ware_house, ))
db.commit()
return redirect(url_for('location.warehouse'))
return render_template('location/warehouse.html', all=all)
def main():
with get_db() as conn:
with open('sqlite-schema.sql') as f:
conn.executescript(f.read())
conn.commit()
with open('test-data.sql') as f:
conn.executescript(f.read())
conn.commit()
def _addItem():
with get_db() as conn:
success = addItemToInventory(conn)
rows = items(conn)
return render_template("itemsPageAfterAdd.html",
name="items",
rows=rows,
success=success)
def _getHistory():
with get_db() as conn:
if getTotalPrice(conn) != []:
totalPriceInfo = getTotalPrice(conn)[0]['totalPrice']
else:
totalPriceInfo = 0
staffInfo = getStaffInfo(conn)[0]
rows = getHistory(conn)
return render_template("staffHistory.html", name="history", rows=rows, staffID=staffInfo['staffID'], staffName=staffInfo['name'], department=staffInfo['department'], totalPriceInfo = totalPriceInfo)
def add():
db = get_db()
products = db.execute('SELECT * FROM product ORDER BY id DESC')
if request.method == 'POST':
name = request.form['product']
qty = request.form['quantity']
error = None
if not name and qty:
error = 'You possibly forget to add product name and quantity....'
if error is not None:
flash(error)
else:
db = get_db()
db.execute(
'INSERT INTO product (product_name, product_quantity) VALUES (?, ?)',
(name, qty))
db.commit()
return redirect(url_for('product.add'))
return render_template('product/add.html', products=products)
def get_movement(id):
product = get_db().execute(
'SELECT id, prod_id, from_loc, to_loc , quantity FROM product_movement WHERE id = ?',
(id, )).fetchone()
if product is None:
abort(
404,
"Product Movement with id {} is not added in database. Goto home and add one"
.format(id))
else:
pass
return product
def get_location(id):
product = get_db().execute('SELECT loc_name FROM location WHERE id = ?',
(id, )).fetchone()
if product is None:
abort(
404,
"Location with id {} is not added in database. Goto home and add one"
.format(id))
else:
pass
return product
def get_product(id):
product = get_db().execute(
'SELECT product_name, product_quantity FROM product WHERE id = ?',
(id, )).fetchone()
if product is None:
abort(
404,
"Product with id {} is not added in database. Goto home and add one"
.format(id))
else:
pass
return product
def _report():
with get_db() as conn:
rows = itemsReport(conn)
itemInfo = getItemInformation(conn)[0]
return render_template("reportPage.html",
type="report",
rows=rows,
itemType=itemInfo['type'],
id=itemInfo['itemID'],
manu=itemInfo['manufacturer'],
stockN=itemInfo['stockNum'],
borrowedN=itemInfo['borrowedNum'],
price=itemInfo['price'],
totalP=itemInfo['totalPrice'])
def _raiseStockCount():
with get_db() as conn:
success = increaseCount(conn)
rows = itemsReport(conn)
itemInfo = getItemInformation(conn)[0]
return render_template("reportPageAfterRaise.html",
name="items",
rows=rows,
success=success,
itemType=itemInfo['type'],
id=itemInfo['itemID'],
manu=itemInfo['manufacturer'],
stockN=itemInfo['stockNum'],
borrowedN=itemInfo['borrowedNum'],
price=itemInfo['price'],
totalP=itemInfo['totalPrice'])
def edit_warehouse(id):
location = get_location(id)
if request.method == 'POST':
name = request.form['warehouse']
error = None
if not name:
error = 'You removed all details of product'
if error is not None:
flash(error)
else:
db = get_db()
db.execute('UPDATE location SET loc_name = ? WHERE id = ?',
(name, id))
db.commit()
return redirect(url_for('location.warehouse'))
return render_template('location/edit-warehouse.html', location=location)
def edit_movement(id):
lists = []
movement = get_movement(id)
for i in movement:
lists.append(i)
if request.method == 'POST':
products_to_move = request.form['products']
qty = request.form['quantity']
error = None
if products_to_move and qty:
db = get_db()
db.execute(
'UPDATE product_movement SET prod_id = ?, quantity = ? WHERE id = ?',
(products_to_move, qty, id))
db.commit()
return redirect(url_for('movement.movement'))
return render_template('movement/edit-movement.html', lists=lists)
def edit(id):
product = get_product(id)
if request.method == 'POST':
name = request.form['product']
qty = request.form['quantity']
error = None
if not name and qty:
error = 'You removed all details of product'
if error is not None:
flash(error)
else:
db = get_db()
db.execute(
'UPDATE product SET product_name = ?, product_quantity = ? WHERE id = ?',
(name, qty, id))
db.commit()
return redirect(url_for('product.index'))
return render_template('product/edit.html', product=product)
def _showOldestUses():
with get_db() as conn:
rows = getOldestUses(conn)
return render_template("usesHistory.html",
name="showOldestUsed",
rows=rows)
def _returnU():
with get_db() as conn:
returnItem(conn)
rows = uses(conn)
return render_template("usesPage.html", type="report", rows=rows)
def _staff():
with get_db() as conn:
rows = staff(conn)
return render_template("staffPage.html", name="staff", rows=rows)
def index():
db = get_db()
all_data = db.execute(
'SELECT prod_id, to_loc, quantity from product_movement ORDER BY to_loc'
)
return render_template('index.html', all_data=all_data)
def _showOldestCount():
with get_db() as conn:
rows = getOldestCount(conn)
return render_template("usesCount.html",
name="showOldestCount",
rows=rows)
def _borrowItem():
with get_db() as conn:
success = borrowItemToday(conn)
return render_template("afterIndex.html",
name="index",
success=success)
def _items():
with get_db() as conn:
rows = items(conn)
return render_template("itemsPage.html", name="items", rows=rows)
def _uses():
with get_db() as conn:
rows = uses(conn)
return render_template("usesPage.html", name="uses", rows=rows)
