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)