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 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 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 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 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 createCat(): hier = request.form["hier"] parent_id = request.form["parent_id"] name = request.form["name"] status = int(request.form["status"]) uid = int(request.cookies.get("uid")) db = Pysql() res = db.insert(sql=""" insert into category (parent_id,name,status,created_time,created_user,updated_time,updated_user) values (%s,%s,%s,now(),%s,now(),%s); """, params=(parent_id, name, status, uid, uid)) if res["success"] == True: return jsonify(success=True) else: return jsonify(success=False, reason="Internal Wrong!")
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 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!")
def createProduct(): 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.insert(sql=""" insert into product (category_id,name,price,stock,status,created_time,created_user,updated_time,updated_user) values (%s,%s,%s,%s,%s,now(),%s,now(),%s); """, params=(category_id, name, price, stock, status, uid, uid)) if res["success"] == True: return jsonify(success=True) 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!")
# -*- coding: utf-8 -*- from dbaseop import Pysql if __name__ == "__main__": db = Pysql() db.query(sql=""" create table if not exists `user` ( `id` int(11) not null auto_increment, `username` varchar(50) not null, `password` varchar(50) not null, `role` int(4) not null, primary key (`id`), unique key `user_name_unique`(`username`) using btree ); """) db.query(sql=""" create table if not exists `category` ( `id` int(11) not null auto_increment, `parent_id` int(11) default null, `name` varchar(50) default null, `status` tinyint(1) default '1', `created_time` datetime default null, `created_user` int(11) default null, `updated_time` datetime default null, `updated_user` int(11) default null, primary key (`id`) ) engine=InnoDB default charset=utf8; """)