def update_order_product(order_id, product_id, dimension_id, new_quantity, new_price):
number_of_items = Dimension.get_dimension(dimension_id).number
product_price_per_line = number_of_items*new_quantity*new_price
order_product_up = OrderProduct.get_order_product(order_id, product_id, dimension_id)
order_product_up.quantity = new_quantity
order_product_up.price = new_price
order_product_up.product_price_per_line = product_price_per_line
db_session.commit()
def stockList(id):
productStock = ProductStock.getStockByProduct(id)
productStockList = []
for i in productStock:
productStockList.append({'dimension': Dimension.get_dimension(i.dimension_id).name, 'quantity': i.quantity,
'dimension_id': i.dimension_id})
product = ({"name": Product.get_product(id).name, "description": Product.get_product(id).description,
"price": str(Product.get_product(id).price)})
return make_response(jsonify(productStock=productStockList, product=product), 200)
def add_order_product(order_id, product_id, dimension_id, quantity, price=0):
number_of_items = Dimension.get_dimension(dimension_id).number
product_price_per_line = int(number_of_items)*int(quantity)*float(price)
order_product = OrderProduct(order_id, product_id, dimension_id, quantity, price, product_price_per_line)
db_session.add(order_product)
db_session.commit()
def get_dimension_by_id(id):
validate_dimension_id(id)
dimension_by_id = Dimension.get_dimension(id)
return dimension_by_id
def validate_dimension_id(id):
if id is None:
raise ValidationException("Dimension is required field")
if not Dimension.get_dimension(id):
raise NotFoundException("Unable to find dimension with given id")
