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)