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;
""")
