def bikes_by_manufacturer(id):
manufacturer = manufacturer_repository.select(id)
bikes = manufacturer_repository.bikes(manufacturer)
return render_template("manufacturers/bikes.html",
manufacturer=manufacturer,
all_bikes=bikes,
title="Mikes Bikes - Bikes By Manufacturer")
def select(id):
sql = "SELECT * FROM products WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
manufacturer = manufacturer_repository.select(result['manufacturer_id'])
product = Product(result["model"], result["description"], result["colour"],
result["buy_price"], result["sell_price"],
result["quantity"], manufacturer, result["id"])
return product
def create_bike():
manufacturer = manufacturer_repository.select(request.form['manufacturer_id'])
model = request.form['model']
description = request.form['description']
buy_cost = request.form['buy_cost']
sell_price = request.form['sell_price']
stock_level = request.form['stock_level']
bike = Bike(manufacturer, model, description, buy_cost, sell_price, stock_level)
bike_repository.save(bike)
return redirect('/bikes')
def select(id):
product = None
sql = "SELECT * FROM products WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
manufacturer = manufacturer_repository.select(result['manufacturer_id'])
product = Product(result['name'], result ['description'], result['stock_quantity'], result['buying_cost'], result['selling_price'], result['category'], manufacturer, result['id'])
return product
def select(id):
stock = None
sql = "SELECT * FROM stock WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
manufacturer = manufacturer_repository.select(result['manufacturer_id'])
stock = Stock(result['name'], result['description'], manufacturer, result['cost'] ,result['price'], result['in_stock'], result['id'])
return stock
def select_all():
products = []
sql = "SELECT * FROM products"
results = run_sql(sql)
for row in results:
manufacturer = manufacturer_repository.select(row['manufacturer_id'])
product = Product(row['name'], row['description'], row['stock_quantity'], row['buying_cost'], row['selling_price'], row['category'], manufacturer, row['id'])
products.append(product)
return products
def select(id):
sql = "SELECT * FROM items WHERE id = %s"
values = [id]
result = run_sql(sql, values)
# pdb.set_trace()
manufacturer = manufacturer_repository.select(result[0][6])
item = Item(result[0][1], result[0][2], result[0][3], result[0][4],
result[0][5], manufacturer, result[0][7], result[0][8],
result[0][9], result[0][0])
item.stock_checks()
return item
def sell_stock(id):
stock_item = stock_repository.select(id)
name = stock_item.name
description = stock_item.description
price = stock_item.price
cost = stock_item.cost
in_stock = False
manufacturer = manufacturer_repository.select(stock_item.manufacturer.id)
stock = Stock(name, description, manufacturer, cost, price, in_stock, id)
stock_repository.update(stock)
return redirect('/stock')
def update_bike(id):
manufacturer = manufacturer_repository.select(request.form['manufacturer_id'])
model = request.form['model']
description = request.form['description']
buy_cost = request.form['buy_cost']
sell_price = request.form['sell_price']
stock_level = request.form['stock_level']
update_mark_up = round((((float(sell_price) - float(buy_cost)) / float(buy_cost)) * 100), 2)
bike = Bike(manufacturer, model, description, buy_cost, sell_price, stock_level, update_mark_up, id)
bike_repository.update(bike)
return redirect('/bikes')
def update_stock(id):
name = request.form['name']
description = request.form['description']
price = int(request.form['price'])
cost = int(request.form['cost'])
in_stock = request.form['in_stock']
manufacturer = manufacturer_repository.select(
request.form['manufacturer_id'])
stock = Stock(name, description, manufacturer, cost, price, in_stock, id)
stock_repository.update(stock)
return redirect('/stock')
def create_stock():
name = request.form['name']
description = request.form['description']
manufacturer = request.form['manufacturer']
cost = request.form['cost']
price = request.form['price']
manufacturer = manufacturer_repository.select(
request.form['manufacturer_id'])
stock = stock(name, description, price, id)
stock_repository.save(stock)
return redirect('/stock')
def select_all():
stock = []
sql = "SELECT * FROM stock"
results = run_sql(sql)
for row in results:
manufacturer = manufacturer_repository.select(row['manufacturer_id'])
new_stock = Stock(row['name'], row['description'], manufacturer, row['cost'], row['price'], row['in_stock'],row['id'])
stock.append(new_stock)
return stock
def create_product():
name = request.form['name']
description = request.form['description']
stock_quantity = request.form['stock_quantity']
buying_cost = request.form['buying_cost']
selling_price = request.form['selling_cost']
manufacturer_id = request.form["manufacturer_id"]
manufacturer = manufacturer_repository.select(manufacturer_id)
product = Product(name, description, stock_quantity, buying_cost, selling_price, manufacturer)
product_repository.save(product)
return redirect('/products')
def update_product(id):
name = request.form['name']
description = request.form['description']
stock_quantity = request.form['stock_quantity']
buying_cost = request.form['buying_cost']
selling_price = request.form['selling_price']
manufacturer = manufacturer_repository.select(request.form['manufacturer_id'])
print(manufacturer.id)
product = Product(name, description, stock_quantity, buying_cost, selling_price, manufacturer, id)
product_repository.update(product)
return redirect('/products')
def select_all():
products = []
sql = "SELECT * FROM products"
results = run_sql(sql)
for row in results:
manufacturer = manufacturer_repository.select(row[6])
print(manufacturer)
product = Product(row[1], row[2], row[3], row[4], row[5], manufacturer,
row[0])
products.append(product)
print(products)
return products
def list_products_by_manufacturer(id):
products = []
sql = "SELECT * FROM products WHERE manufacturer_id = %s"
values = [id]
results = run_sql(sql, values)
for row in results:
manufacturer = manufacturer_repository.select(row["manufacturer_id"])
product = Product(row["name"], row["description"], row["stock_quantity"], row["buying_cost"], row["selling_price"], row["category"], manufacturer, row["id"])
products.append(product)
return products
def select_all():
bikes = []
sql = "SELECT * FROM bikes"
results = run_sql(sql)
for row in results:
manufacturer = manufacturer_repository.select(row['manufacturer_id'])
bike = Bike(manufacturer, row['model'], row['description'],
row['buy_cost'], row['sell_price'], row['stock_level'],
row['mark_up'], row['id'])
bikes.append(bike)
return bikes
def select_all():
products = []
sql = "SELECT * FROM products ORDER BY manufacturer_id"
results = run_sql(sql)
for result in results:
manufacturer = manufacturer_repository.select(
result['manufacturer_id'])
product = Product(result["model"], result["description"],
result["colour"], result["buy_price"],
result["sell_price"], result["quantity"],
manufacturer, result["id"])
products.append(product)
return products
def select(id):
bike = None
sql = "SELECT * FROM bikes WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
manufacturer = manufacturer_repository.select(
result['manufacturer_id'])
bike = Bike(manufacturer, result['model'], result['description'],
result['buy_cost'], result['sell_price'],
result['stock_level'], result['mark_up'], result['id'])
return bike
def update_product(id):
name = request.form['name']
description = request.form['description']
stock = request.form['stock']
buy_price = request.form['buy_price']
sell_price = request.form['sell_price']
manufacturer = manufacturer_repository.select(
request.form['manufacturer_id'])
product = Product(name, description, stock, buy_price, sell_price,
manufacturer, id)
print(product.manufacturer.name)
product_repository.update(product)
return redirect('/products')
def create_product():
name = request.form['name']
description = request.form['description']
stock = request.form['stock']
buy_price = request.form['buy_price']
sell_price = request.form['sell_price']
manufacturer = manufacturer_repository.select(
request.form['manufacturer_id'])
product = Product(name, description, stock, buy_price, sell_price,
manufacturer)
# print("marco 34hy5")
product_repository.save(product)
return redirect('/products')
def update_product(id):
name = request.form["name"]
description = request.form["description"]
stock_quantity = request.form["stock_quantity"]
buying_cost = request.form["buying_cost"]
selling_price = request.form["selling_price"]
category = request.form["category"]
manufacturer_id = request.form["manufacturer_id"]
manufacturer = manufacturer_repository.select(manufacturer_id)
product = Product(name, description, stock_quantity, buying_cost,
selling_price, category, manufacturer, id)
product_repository.update(product)
return redirect('/products')
def select_all():
items = []
sql = "SELECT * FROM items"
results = run_sql(sql)
for result in results:
manufacturer = manufacturer_repository.select(
result["manufacturer_id"])
item = Item(result["name"], result["description"], result["category"],
result["buy_cost"], result["sell_price"], manufacturer,
result["stock"], result["sold_out"], result["low_stock"],
result["id"])
item.stock_checks()
items.append(item)
return items
def get_by_category(selected_filter):
items = []
sql = "SELECT * FROM items WHERE category = %s"
values = [selected_filter]
results = run_sql(sql, values)
for result in results:
manufacturer = manufacturer_repository.select(
result["manufacturer_id"])
item = Item(result["name"], result["description"], result["category"],
result["buy_cost"], result["sell_price"], manufacturer,
result["stock"], result["sold_out"], result["low_stock"],
result["id"])
item.stock_checks()
items.append(item)
return items
def show_manufacturer(id):
manufacturer = manufacturer_repository.select(id)
return render_template('manufacturers/show.html',
manufacturer=manufacturer)
def show(id):
manufacturer = manufacturer_repository.select(id)
return render_template("manufacturers/show.html", manufacturer=manufacturer)
def edit_product(id):
manufacturers = manufacturer_repository.select(id)
products = product_repository.select_all()
return render_template("manufacturers/edit.html", products=products, manufacturer=manufacturers)
def show_manufacturer(id):
manufacturer = manufacturer_repository.select(id)
return render_template('manufacturers/show.html',
manufacturer=manufacturer,
title="Mikes Bikes - Selected Manufacturer")
def edit_manufacturers(id):
manufacturer = manufacturer_repository.select(id)
return render_template('manufacturers/edit.html',
manufacturer=manufacturer,
title="Mikes Bikes - Edit Manufacturer")
def edit_manufacturer(id):
manufacturer = manufacturer_repository.select(id)
return render_template('manufacturers/edit.html',
manufacturer=manufacturer)
