def warehouses_list():
warehouses = Warehouse.select(
Warehouse.location, Warehouse.warehouse_id, Warehouse.store,
fn.COUNT(Product.warehouse_id).alias('count')).join(
Product, JOIN.LEFT_OUTER).group_by(
Warehouse.warehouse_id).order_by(Warehouse.location)
# warehouses = Warehouse.select()
return render_template('warehouses.html', warehouses=warehouses)
def warehouse():
if request.method == 'POST':
store = request.form['store_list']
location = request.form['warehouse_location']
new_warehouse = Warehouse.create(location=location, store=store)
new_warehouse.save()
flash("Warehouse created", "success")
return redirect(url_for('warehouse'))
else:
# result = Store.select(Store.name, fn.COUNT(Warehouse.store.id == Store.id)).join(Warehouse).group_by(Store.name).where(Store.id == Warehouse.store.id)
warehouse_list = Warehouse.select()
store_list = Store.select()
return render_template('warehouse.html', warehouse_list=warehouse_list, store_list=store_list)
def product():
if request.method == 'POST':
name = request.form['product_name']
description = request.form['product_description']
warehouse = request.form['warehouse_list']
color = request.form['product_color']
new_product = Product(name=name, description=description, warehouse=warehouse, color=color)
new_product.save()
flash("Product created", "success")
return redirect(url_for('product'))
else:
product_list = Product.select()
warehouse_list = Warehouse.select()
return render_template('product.html', warehouse_list=warehouse_list, product_list=product_list)
def store_show():
stores = Store.select()
warehouses = Warehouse.select()
return render_template('stores.html', stores=stores, warehouses = warehouses)
def store_select():
stores = Store.select()
warehouse = Warehouse.select()
return render_template('list_stores.html',
stores=stores,
warehouse=warehouse)
def show_stores():
stores = Store.select() #passing stores from the database into
warehouses = Warehouse.select()
return render_template('stores.html', stores=stores, warehouses=warehouses)
def product_new():
warehouses = Warehouse.select()
return render_template('product.html', warehouses=warehouses)
def stores():
return render_template('liststores.html',
stores=Store.select(),
warehouse=Warehouse.select())
def store_show(store_id):
store = Store.get_by_id(request.args.get('store_id', store_id))
store_warehouse = Warehouse.select().where(Warehouse.store == store.id)
return render_template('store_show.html',
store=store,
store_warehouse=store_warehouse)
def warehouse_index():
warehouses = Warehouse.select()
return render_template('warehouse_index.html', warehouses=warehouses)