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)