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 get_modify_products(): if request.method == 'GET': products = CRUD.leer_productos() return render_template("admin-panel-products-edit.html", products=products, product="") else: product = CRUD.buscar_un_producto(request.form['product_name'], "") return render_template("admin-panel-products-edit.html", products="", product=product)