def addProductToOrder(product_id):
if (request.method == 'POST'):
currentOrder = CRUD.buscar_orden(session.get('user_id'))
# buscar si el usuario tiene alguna orden disponible
if len(currentOrder) == 0:
now = datetime.datetime.now()
CRUD.create_order(session.get('user_id'), now, 0)
currentOrder = CRUD.buscar_orden(session.get('user_id'))
order_id = currentOrder[0][0]
#buscar si el producto ya existe en la orden
product_in_order = CRUD.buscar_producto_en_orden(product_id, order_id)
#buscar información del producto
product_info = CRUD.buscar_un_producto(None, product_id)
product_price = product_info[2]
#agregar productos a tabla detalles o modificarlos
if product_in_order is None:
CRUD.add_product_to_order(product_id, order_id, 1, product_price)
else:
CRUD.update_product_in_order(product_id, order_id)
update_order_total(order_id)
# return jsonify({"order_id": currentOrder[0][0], "user_id": currentOrder[0][1], "payment_method_id": currentOrder[0][2], "order_date": currentOrder[0][3], "order_total":currentOrder[0][4], "order_open": currentOrder[0][5]})
products_in_order = CRUD.get_order_complete_info(order_id)
return jsonify(products_in_order)
def getOrdersInfo():
currentOrder = CRUD.buscar_orden(session.get('user_id'))
if not currentOrder:
return {}
order_id = currentOrder[0][0]
products_in_order = CRUD.get_order_complete_info(order_id)
return jsonify(products_in_order)
def orderCheckout():
currentOrder = CRUD.buscar_orden(session.get('user_id'))
if not currentOrder:
return {}
order_id = currentOrder[0][0]
now = datetime.datetime.now()
CRUD.order_checkout(order_id, now)
return {}
def emptyCart():
currentOrder = CRUD.buscar_orden(session.get('user_id'))
if not currentOrder:
return {}
order_id = currentOrder[0][0]
CRUD.delete_cart_items(order_id)
now = datetime.datetime.now()
CRUD.update_order_total(order_id, 0, now)
return {}
def subProductFromOrder(product_id):
if (request.method == 'POST'):
currentOrder = CRUD.buscar_orden(session.get('user_id'))
order_id = currentOrder[0][0]
product_in_order = CRUD.buscar_producto_en_orden(product_id, order_id)
if (product_in_order[4] > 1):
CRUD.substract_product_qty_in_order(product_id, order_id)
else:
CRUD.delete_product_from_order(product_id, order_id)
update_order_total(order_id)
products_in_order = CRUD.get_order_complete_info(order_id)
return jsonify(products_in_order)
