def login(): if request.method == 'POST': # get authetication username = request.form['username'] password = request.form['password'] # print(username, password) db = Pysql() # 0 - Admin res = db.selectAll(sql=""" select * from user where username=%s and role=0; """, params=(username, )) if res["success"] == True: if res["count"] == 0: return jsonify(success=False, reason="Wrong password/username!") else: d = res["data"][0] if password != d["password"]: return jsonify(success=False, reason="Wrong password/username!") else: return jsonify(success=True, data=d) else: return jsonify(success=False, reason="Internal wrong!") elif request.method == 'GET': # return login page return render_template('login.html')
def getUserName(id): # get user name by id db = Pysql() res = db.selectAll(sql=""" select username from user where id=%s; """, params=(id, )) if res["success"] == True and res["count"] > 0: return res["data"][0]["username"] else: return ""
def getAllProducts(): db = Pysql() res = db.selectAll(sql=""" select * from product; """) if res["success"] == True: return jsonify(success=True, html=render_template("producttable.html", products=res["data"])) else: return jsonify(success=False, reason="Internal Wrong!")
def getFirstCats(): db = Pysql() res = db.selectAll(sql=""" select * from category where parent_id=0; """) if res["success"] == True: return jsonify(success=True, html=render_template("typecontainer.html", hier=0, catCount=res["count"], cats=res["data"], parent_id=0)) else: return jsonify(success=False, reason="Internal Wrong!")
def getCatName(id): # get category name by id db = Pysql() if int(id) == 0: return "根节点" res = db.selectAll(sql=""" select name from category where id=%s; """, params=(id, )) if res["success"] == True and res["count"] > 0: return res["data"][0]["name"] else: return False
def orderlist(): if authenticationCheck(request.cookies) == True: username = request.cookies.get("username") db = Pysql() res = db.selectAll(sql=""" select * from `order`; """) if res["success"] == True: return render_template('orderlist.html', username=username, orders=res["data"]) else: return jsonify(success=False, reason="Internal Wrong!") else: return redirect(url_for("login"))
def getFollowingCats(hier, id): parent_id = int(id) curHier = int(hier) + 1 db = Pysql() res = db.selectAll(sql=""" select * from category where parent_id=%s; """, params=(parent_id, )) if res["success"] == True: return jsonify(success=True, html=render_template("typecontainer.html", hier=curHier, catCount=res["count"], cats=res["data"], parent_id=parent_id)) else: return jsonify(success=False, reason="internal Wrong!")
def getCatDetail(id): id = int(id) db = Pysql() res = db.selectAll(sql=""" select * from category where id=%s; """, params=(id, )) parent_id = res["data"][0]["parent_id"] created_uid = res["data"][0]["created_user"] updated_uid = res["data"][0]["updated_user"] if res["success"] == True: return jsonify(success=True, html=render_template( "typedetailcontainer.html", item=res["data"][0], parent_name=getCatName(parent_id), created_user=getUserName(created_uid), updated_user=getUserName(updated_uid))) else: return jsonify(success=False, reason="Internal Wrong!")