def post(self):
try:
attr_dynamic = request.form.get('attr_dynamic')
attr_static = request.form.get('attr_static')
cid_one = request.form.get('cid_one')
cid_two = request.form.get('cid_two')
cid_three = request.form.get('cid_three')
introduce = request.form.get('introduce')
name = request.form.get('name')
number = request.form.get('number')
price = request.form.get('price')
pics = request.form.get('pics')
weight = request.form.get('weight')
goods = models.Goods(name=name, number=number, price=price, weight=weight, introduce=introduce,
cid_one=int(cid_one), cid_two=int(cid_two), cid_three=int(cid_three))
db.session.add(goods)
db.session.commit()
for p in eval(pics):
tp = models.Picture(gid=goods.id, path=p)
db.session.add(tp)
for d in eval(attr_dynamic):
temp_d = models.GoodsAttr(gid=goods.id, aid=d.get('id'), val=d.get('val'), _type='dynamic')
db.session.add(temp_d)
for s in eval(attr_static):
temp_s = models.GoodsAttr(gid=goods.id, aid=s.get('id'), val=s.get('val'), _type='static')
db.session.add(temp_d)
db.session.commit()
return to_dict_msg(200,msg="增加商品成功")
except Exception as e:
return to_dict_msg(20000)
def get(self):
role.list = []
try:
roles = models.Role.query.all()
role.list = [r.to_dict() for r in roles]
return to_dict_msg(200, role.list, '获取角色列表成功')
except Exception as e:
return to_dict_msg(20000)
def get_express():
oid = request.args.get('oid')
if oid:
exps = models.Express.query.filter(models.Express.oid == oid).order_by(
models.Express.update_time.desc())
return to_dict_msg(200, [e.to_dict() for e in exps])
else:
return to_dict_msg(10000)
def delete(self):
id = request.json.get('id')
goods = models.Goods.query.get(id)
if goods:
db.session.delete(goods)
db.session.commit()
return to_dict_msg(200,msg='删除商品成功')
else:
return to_dict_msg(10022)
def get(self):
try:
cid = request.args.get('cid')
c = models.Category.query.get(cid)
if c:
return to_dict_msg(200,c.to_dict(),"获取商品分类成功!!")
else:
return to_dict_msg(10022)
except Exception as e:
return to_dict_msg(20000)
def get(self):
try:
id = request.args.get('id')
attr = models.Attribute.query.get(id)
if attr:
return to_dict_msg(200,msg="获取分类参数成功")
else:
return to_dict_msg(10022)
except Exception as e:
return to_dict_msg(20000)
def get(self):
try:
id = int(request.args.get('id').strip())
usr = models.User.query.filter_by(id=id).first()
if usr:
return to_dict_msg(200, usr.to_dict(), '获取用户成功')
else:
return to_dict_msg(200, [], '没有此用户')
except Exception:
return to_dict_msg(10000, '用户数据不完整')
def delete(self):
try:
cid = request.form.get('cid')
c = models.Category.query.get(cid)
if c:
db.session.delete(c)
db.session.commit()
return to_dict_msg(200,msg='删除商品分类成功')
return to_dict_msg(10022)
except Exception as e:
return to_dict_msg(20000)
def put(self):
try:
cid = request.form.get('cid')
name = request.form.get('name')
c = models.Category.query.get(cid)
if c:
c.name = name
return to_dict_msg(200,msg="修改成功")
return to_dict_msg(20000)
except Exception as e:
return to_dict_msg(20000)
def delete(self):
try:
id = int(request.form.get('id'))
r = models.Role.query.get(id)
if r:
db.session.delete(r)
db.session.commit()
return to_dict_msg(200, msg='删除用户成功')
return to_dict_msg(10000)
except Exception:
return to_dict_msg(20000)
def delete(self):
try:
id = request.form.get('id')
attr = models.Attribute.query.get(id)
if attr:
db.delete(attr)
db.commit()
return to_dict_msg(200,msg='删除分类参数成功')
else:
return to_dict_msg(10022)
except Exception as e:
return to_dict_msg(20000)
def delete(self):
try:
id = request.json.get('id')
usr = models.User.query.get(id)
if usr:
db.session.delete(usr)
db.session.commit()
return to_dict_msg(200, '删除成功')
else:
return to_dict_msg(10019)
except Exception:
return to_dict_msg(2000)
def verify_token(*arg, **kwargs):
try:
token = request.headers['token'] #获得前端请求头【headers】中的token
except Exception:
return to_dict_msg(10016)
#创建解密对象
s = Serializer(current_app.config['SECRET_KEY'])
try:
data = s.loads(token)
except Exception:
return to_dict_msg(10017)
return view_func(*arg, **kwargs)
def post(self):
name = request.args.get('name')
desc = request.args.get('desc')
try:
if name:
role = models.Role(name=name, desc=desc)
db.session.add(role)
db.session.commit()
return to_dict_msg(200, msg='增加角色成功!!')
return to_dict_msg(10000)
except Exception as e:
return to_dict_msg(20000)
def order_list():
try:
id = request.args.get('id')
if id:
order = models.Order.query.get(id)
if order:
return to_dict_msg(200, order.to_dict(), '获取订单成功')
else:
return to_dict_msg(10022)
orders = models.Order.query.all()
return to_dict_msg(200, [o.to_dict() for o in orders], '获取订单列表成功')
except Exception as e:
print(e)
return to_dict_msg(20000)
def reset():
try:
id = int(request.args.get('id'))
usr = models.User.query.get(id)
usr.password = '******'
db.session.commit()
return to_dict_msg(200, msg='重置密码成功')
except Exception as e:
return to_dict_msg(20000)
# @user.route('/test')
# @login_required
# def test_login_req():
# return to_dict_msg(200)
def upload_img():
img_file = request.files.get('file')
if not img_file:
return to_dict_msg(10023)
if allowed_img(img_file.filename):
floder = current_app.config.get('SERVER_IMG_UPLOADS')
end_prefix = img_file.filename.rsplit('.',1)[1]
file_name = md5_file()
img_file.save(f'{floder}/{file_name}.{end_prefix}')
data = {
'path': f'/static/img/{file_name}.{end_prefix}',
'url':f'http://127.0.0.1:5000/static/img/{file_name}.{end_prefix}'
}
return to_dict_msg(200,data,'上传图片成功!!!')
else:
return to_dict_msg(10024)
def get_attr_list():
cid = request.args.get('cid')
_type = request.args.get('_type')
if all([cid,_type]):
cate = models.Category.query.get(cid)
attr_list = []
if cate:
if 'static' == _type:
attr_list = [a.to_dict() for a in cate.attr if a._type == 'static']
else:
attr_list = [a.to_dict() for a in cate.attr if a._type == 'dynamic']
return to_dict_msg(200,attr_list,msg='获取分类属性列表成功')
else:
return to_dict_msg(10022)
else:
return to_dict_msg(10000)
def get(self):
type_ = request.args.get('type')
menu_list = []
#获取数据并将数据填冲到menu——list中
if type_ == 'list':
#获取数据并将数据填冲到menu——list中
mu = models.Menu.query.filter(models.Menu.level != 0).all()
for m in mu:
print(type(m))
menu_list.append(m.to_dict())
else:
mu = models.Menu.query.filter(models.Menu.level == 1).all()
for m in mu:
#获取一级菜单转成json
first_mu = m.to_dict()
#给二级菜单创建保存容器
first_mu['children'] = []
for sm in m.children:
#获取2级菜单转成接送
secd_dict = sm.to_dict()
#给2级菜单创建保存容器，并把3级菜单数据加进来
secd_dict['children'] = sm.get_children_list()
#把二级菜单加到一级的children列表中
first_mu['children'].append(secd_dict)
#把一级菜单加到根列表中
menu_list.append(first_mu)
return to_dict_msg(200, data=menu_list)
def post(self):
try:
name = request.form.get('name') if request.form.get('name') else ''
level = int(request.form.get('level')) if request.form.get('level') else None
pid = int(request.form.get('pid')) if request.form.get('pid') else 0
if all(['name',level]):
if pid:
c = models.Category(name = name, level = level, pid = pid)
else:
c = models.Category(name = name, level = level)
db.session.add(c)
db.session.commit()
return to_dict_msg(200,"增加商品分类成功")
return to_dict_msg(10000)
except Exception as e:
return to_dict_msg(20000)
def set_menu(rid):
try:
role = models.Role.query.get(rid)
mids = request.form.get('mids')
if role:
role.menus = []
for m in mids.split(','):
if m:
tem_menu = models.Menu.query.get(int(m))
if tem_menu:
role.menus.append(tem_menu)
db.session.commit()
return to_dict_msg(200, msg='分配权限成功!!!')
return to_dict_msg(10020)
except Exception as e:
print(e)
return to_dict_msg(20000)
def get_goods_list():
name = request.args.get('name')
if name:
goods = models.Goods.query.filter(models.Goods.name.like(f'%{name}%')).all()
else:
goods = models.Goods.query.all()
goods_list = [gds.to_dict() for gds in goods]
return to_dict_msg(200,goods_list,'获取商品列表成功')
def del_menu(rid, mid):
try:
r = models.Role.query.get(rid)
m = models.Menu.query.get(mid)
if all([r, m]):
if m in r.menus:
r.menus.remove(m)
if m.level == 1:
for temp_m in m.children: #获取删除当前根节点的所有子节点
if temp_m in r.menus: #判断当前子节点是否在当前权限
r.menus.remove(temp_m)
db.session.commit()
return to_dict_msg(200, data=r.get_menu_dict(), msg="删除权限成功")
return to_dict_msg(10021)
return to_dict_msg(10000)
except Exception as e:
return to_dict_msg(20000)
def put(self):
try:
id = int(request.form.get('id'))
name = request.form.get('name').strip() if request.form.get(
'name') else ''
desc = request.form.get('desc').strip() if request.form.get(
'desc') else ''
if name:
r = models.Role.query.get('id')
if r:
r.name = name
r.desc = desc
db.commit()
return to_dict_msg(200, msg='修改用户信息成功')
return to_dict_msg(10020)
return to_dict_msg(10000)
except Exception:
return to_dict_msg(20000)
def get_cate_group_by_level():
# group_data =models.Category.query.group_by(models.Category.level).having(models.Category.level > 0).all()
group_data = db.session.query(models.Category.level,func.count(1).label('count')).group_by(models.Category.level).having(models.Category.level >0).all()
data={
'name':'数量',
'xAxis':[f'{g[0]}级分类' for g in group_data],
'series_data':[g[1] for g in group_data]
}
return to_dict_msg(200,data,'获取统计数据成功！！')
def post(self):
try:
name = request.form.get('name')
cid = request.form.get('cid')
_type = request.form.get('_type')
val = request.form.get('val')
if all([name,cid,_type]):
if val:
attr = models.Attribute(name=name,cid=int(cid),_type=_type,val=val)
else:
attr = models.Attribute(name=name,cid=int(cid),_type=_type)
db.session.add(attr)
db.session.commit()
return to_dict_msg(200,msg="增加分类参数成功!!!")
else:
return to_dict_msg(10000)
except Exception as e:
print(e)
return to_dict_msg(20000)
def put(self):
try:
id = request.form.get('id')
name = request.form.get('name')
val = request.form.get('val')
cid = int(request.form.get('cid')) if request.form.get('cid') else 0
if all([id,cid,name]):
attr = models.Attribute.query.get(id)
if attr:
attr.name = name
attr.val = val
attr.cid = cid
db.session.commit()
return to_dict_msg(200,msg='更新数据成功!!!')
else:
return to_dict_msg(10022)
else:
return to_dict_msg(10000)
except Exception as e:
return to_dict_msg(20000)
def put(self):
try:
id = int(request.form.get('id').strip()) #strip方法用来去除空格
email = request.form.get('email').strip() if request.form.get(
'email') else ''
phone = request.form.get('phone').strip() if request.form.get(
'phone') else ''
rid = int(request.form.get('role_name')) if request.form.get(
'role_name') else 0
usr = models.User.query.get(id)
if usr:
usr.email = email
usr.phone = phone
usr.rid = rid
db.session.commit()
return to_dict_msg(200, msg='修改数据成功！')
else:
return to_dict_msg(10018)
except Exception as e:
print(e)
return to_dict_msg(10000)
def post(self):
name = request.form.get('name')
pwd = request.form.get('pwd')
real_pwd = request.form.get('real_pwd')
nick_name = request.form.get('nick_name')
phone = request.form.get('phone')
email = request.form.get('email')
if not all([name, pwd, real_pwd]):
return to_dict_msg(10000)
if len(name) < 2:
return to_dict_msg(10011)
if len(pwd) < 2:
return to_dict_msg(10012)
if pwd != real_pwd:
return to_dict_msg(10013)
if not re.match(r'1[345678]\d{9}', phone):
return to_dict_msg(10014)
if not re.match(r'^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$',
email):
return to_dict_msg(10015)
try:
rid = int(request.form.get('role_name')) if request.form.get(
'role_name') else 0
usr = models.User(name=name,
password=pwd,
nick_name=nick_name,
phone=phone,
email=email,
rid=rid)
db.session.add(usr)
db.session.commit()
return {'status': 200, 'msg': '注册成功'}
except Exception:
return {'status': 2000, 'msg': '异常错误'}
def login():
name = request.form.get('name')
pwd = request.form.get('pwd')
if not all([name, pwd]):
return {'status': 10000, 'msg': '数据不完整'}
if len(name) > 1:
usr = models.User.query.filter_by(name=name).first()
if usr:
if usr.check_password(pwd):
token = generate_auth_token(usr.id, 1000)
return to_dict_msg(200, data={'token': token})
return {'status': 10001, 'msg': '用户名或密码不正确'}
