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': '用户名或密码不正确'}