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)