def shippedOrder(id): id = int(id) db = Pysql() res = db.modify(sql=""" update `order` set status=40, updated_time=now() where id=%s; """, params=(id, )) if res["success"] == True: return jsonify(success=True) else: return jsonify(success=False)
def deleteProduct(id): id = int(id) db = Pysql() res = db.modify(sql=""" update product set status=3 where id=%s; """, params=(id, )) if res["success"] == True: return jsonify(success=True) else: return jsonify(success=False, reason="Internal Wrong!")
def reuseCat(id): id = int(id) uid = int(request.cookies.get("uid")) db = Pysql() res = db.modify(sql=""" update category set status=1, updated_time=now(), updated_user=%s where id=%s; """, params=(uid, id)) if res["success"] == True: return jsonify(success=True) else: return jsonify(success=False, reason="Internal Wrong!")
def inProduct(): id = int(request.form["id"]) in_stock = int(request.form["in_stock"]) uid = int(request.cookies.get("uid")) db = Pysql() res = db.modify(sql=""" update product set stock=stock+%s, updated_time=now(), updated_user=%s where id=%s; """, params=(in_stock, uid, id)) if res["success"] == True: return jsonify(success=True) else: return jsonify(success=False, reason="Internal Wrong!")
def editCat(): id = request.form["id"] name = request.form["name"] status = int(request.form["status"]) uid = int(request.cookies.get("uid")) db = Pysql() res = db.modify(sql=""" update category set name=%s, status=%s, updated_time=now(), updated_user=%s where id=%s; """, params=(name, status, uid, id)) if res["success"] == True: return jsonify(success=True) else: return jsonify(success=False, reason="Internal Wrong!")
def editProduct(): id = int(request.form["id"]) name = request.form["name"] category_id = int(request.form["category_id"]) price = float(request.form["price"]) stock = int(request.form["stock"]) status = int(request.form["status"]) uid = int(request.cookies.get("uid")) db = Pysql() res = db.modify(sql=""" update product set name=%s, category_id=%s, price=%s, stock=%s, status=%s, updated_time=now(), updated_user=%s where id=%s; """, params=(name, category_id, price, stock, status, uid, id)) if res["success"] == True: return jsonify(success=True) else: return jsonify(success=False, reason="Internal Wrong!")