def add(self): # 参数 req = self.request() data = Inc.json_decode(req.get('data')) if not data or type(data)!=dict or not data.get('tel') : return self.getJSON({'code':4000,'msg':'参数错误!'}) tel = data['tel'].strip() passwd = Inc.md5(data['passwd']) if data['passwd']!='' else Inc.md5('123456') # 验证手机 res = Safety.isRight('tel',tel) if not Safety.isRight('tel',tel) : return self.getJSON({'code':4000,'msg':'手机号码有误!'}) # 是否存在 res = User().findFirst({'where':'tel=:tel:','bind':{'tel':tel}}) if res : return self.getJSON({'code':4000,'msg':'该用户已存在!'}) # 保存 params = { 'id': Data.getId(), 'tel': tel, 'password': passwd, 'rtime': Inc.date('%Y%m%d%H%M%S'), } # 结果 if User().insert(params) == 0 : return self.getJSON({'code':0,'msg':'成功'}) else : return self.getJSON({'code':5000,'msg':'添加失败!'})
def list(self): req = self.request() # 搜索 data = Inc.json_decode(req.get('data')) role = data['role'].strip() if 'role' in data.keys() else '' where = 'role LIKE \"%:role:%\"' bind = {'role': role} # 查询 model = UserRole() model.where(where, bind) # 统计 total = model.count() # 分页 page = req.get('page') limit = req.get('limit') start = (int(page) - 1) * int(limit) model.limit(str(start) + ',' + limit) # 数据 list = model.find() # 状态 for val in list: val['ctime'] = str(val['ctime']) if val['ctime'] else '' val['utime'] = str(val['utime']) if val['utime'] else '' return self.getJSON({ 'code': 0, 'msg': '成功', 'list': list, 'total': total })
def edit(self): # 参数 req = self.request() data = Inc.json_decode(req.get('data')) if not data or type(data)!=dict or not data.get('tel') : return self.getJSON({'code':4000,'msg':'参数错误!'}) uid = req.get('uid').strip() tel = data['tel'].strip() passwd = Inc.md5(data['passwd']) if data['passwd']!='' else '' # 验证手机 res = Safety.isRight('tel',tel) if not Safety.isRight('tel',tel) : return self.getJSON({'code':4000,'msg':'手机号码有误!'}) # 是否存在 res = User().findFirst({'where':'tel=:tel:','bind':{'tel':tel}}) if res : if passwd != '' : params = {'data': {'password':passwd}, 'where':'id=:uid:', 'bind':{'uid':uid}} if User().update(params) : return self.getJSON({'code':0,'msg':'成功'}) else : return self.getJSON({'code':5000,'msg':'更新密码失败!'}) else : return self.getJSON({'code':4000,'msg':'密码为6-16位字符!'}) # 修改手机 uData = {'tel':tel} if passwd != '' : uData['password']=passwd params = {'data': uData, 'where':'id=:uid:', 'bind':{'uid':uid}} if User().update(params) : return self.getJSON({'code':0,'msg':'成功'}) else : return self.getJSON({'code':5000,'msg':'编辑失败!'})
def info(self): # 参数 req = self.request() data = Inc.json_decode(req.get('data')) if not data or type(data)!=dict : return self.getJSON({'code':4000,'msg':'参数错误!'}) uid = req.get('uid').strip() # 管理员 if self.tokenData['uid']!='1' and uid=='1' : return self.getJSON({'code':4000,'msg':'非系统管理员!'}) # 查询 info = UserInfo().findFirst({'where':'uid=:uid:','bind':{'uid':uid}}) # 数据 uData = {} arr = ['uid'] keys = data.keys() for key in keys : if key in arr : continue uData[key] = data[key].strip() uData['birthday'] = uData['birthday'] if uData['birthday']!='' else 'null' # 是否存在 if not info : uData['uid'] = uid UserInfo().insert(uData) else : params = {'data':uData,'where':'uid=:uid:','bind':{'uid':uid}} UserInfo().update(params) # 结果 return self.getJSON({'code':0,'msg':'成功'})
def list(self): # 验证 AdminToken().urlVerify('SysMenusAction') # 搜索 req = self.request() data = Inc.json_decode(req.get('data')) name = data['name'].strip() if 'name' in data.keys() else '' action = data['action'].strip() if 'action' in data.keys() else '' where = 'name LIKE "%:name:%" AND action LIKE "%:action:%"' bind = {'name': name, 'action': action} # 查询 model = SysMenuAction() model.where(where, bind) # 统计 total = model.count() # 分页 page = req.get('page') limit = req.get('limit') start = (int(page) - 1) * int(limit) model.limit(str(start) + ',' + limit) # 数据 list = model.find() print(model.getSql()) # 返回 return self.getJSON({ 'code': 0, 'msg': '成功', 'list': list, 'total': total })
def edit(self): # 验证 AdminToken().urlVerify('SysMenus') # 参数 req = self.request() data = Inc.json_decode(req.get('data')) if not data or type(data) != dict: return self.getJSON({'code': 4000, 'msg': '参数错误!'}) id = req.get('id') # 数据 model = SysMenu() model.fid = data['fid'] if 'fid' in data.keys() else '0' model.title = data['title'].strip() if 'title' in data.keys() else '' model.url = data['url'].strip() if 'url' in data.keys() else '' model.perm = data['perm'] if 'perm' in data.keys() else '0' model.ico = data['ico'].strip() if 'ico' in data.keys() else '' model.sort = data['sort'] if 'sort' in data.keys() else '0' model.remark = data['remark'].strip() if 'remark' in data.keys( ) else '' model.where('id=:id:', {'id': id}) # 结果 if model.update(): return self.getJSON({'code': 0, 'msg': '成功'}) else: return self.getJSON({'code': 5000, 'msg': '编辑失败!'})
def list(self): # 验证 AdminToken().urlVerify('SysMenus') # 搜索 req = self.request() data = Inc.json_decode(req.get('data')) fid = data['fid'].strip() if 'fid' in data.keys() else '' title = data['title'].strip() if 'title' in data.keys() else '' url = data['url'].strip() if 'url' in data.keys() else '' where = 'fid LIKE "%:fid:%" AND title LIKE "%:title:%" AND url LIKE "%:url:%"' bind = {'fid': fid, 'title': title, 'url': url} # 查询 model = SysMenu() model.where(where, bind) model.order('sort DESC, fid') # 统计 total = model.count() # 分页 page = req.get('page') limit = req.get('limit') start = (int(page) - 1) * int(limit) model.limit(str(start) + ',' + limit) # 数据 list = model.find() # 状态 for val in list: val['ctime'] = str(val['ctime']) if val['ctime'] else '' val['utime'] = str(val['utime']) if val['utime'] else '' return self.getJSON({ 'code': 0, 'msg': '成功', 'list': list, 'total': total })
async def router(self,fds,socket,msg,token) : # 参数 self.__fds = fds self.__token = token # 数据 data = Inc.json_decode(msg) if not data : await socket.send(self.getJSON({'code':4000,'msg':'格式错误!'})) # 消息 elif data['type']=='msg' : await self.msg(socket,data) # 心跳 else : await socket.send(self.getJSON({'code':0,'msg':'成功'}))
def rmFile(self): # 参数 req = self.request() path = req.get('path').strip() data = Inc.json_decode(req.get('data').strip()) if not path or not data: return self.getJSON({'code': 4000, 'msg': '参数错误!'}) # 执行 for val in data: Files().delAll(path + str(val)) return self.getJSON({'code': 0, 'msg': '成功'})
def add(self): # 参数 req = self.request() data = Inc.json_decode(req.get('data')) if not data or type(data) != dict: return self.getJSON({'code': 4000, 'msg': '参数错误!'}) # 数据 model = UserRole() model.role = data['role'].strip() if 'role' in data.keys() else '' # 结果 if model.create(): return self.getJSON({'code': 0, 'msg': '成功'}) else: return self.getJSON({'code': 5000, 'msg': '添加失败!'})
def delete(self): # 参数 req = self.request() data = Inc.json_decode(req.get('data')) if not data: return self.getJSON({'code': 4000, 'msg': '参数错误!'}) # ID ids = Inc.implode(',', data) model = UserRole() model.where('id in(:ids:)', {'ids': ids}) # 结果 if model.delete(): return self.getJSON({'code': 0, 'msg': '成功'}) else: return self.getJSON({'code': 5000, 'msg': '删除失败!'})
def edit(self): # 参数 req = self.request() data = Inc.json_decode(req.get('data')) if not data or type(data) != dict: return self.getJSON({'code': 4000, 'msg': '参数错误!'}) id = req.get('id').strip() # 数据 model = UserRole() model.role = data['role'].strip() if 'role' in data.keys() else '' model.where('id=:id:', {'id': id}) # 结果 if model.update(): return self.getJSON({'code': 0, 'msg': '成功'}) else: return self.getJSON({'code': 5000, 'msg': '编辑失败!'})
def delete(self): # 验证 AdminToken().urlVerify('SysMenusAction') # 参数 req = self.request() data = Inc.json_decode(req.get('data')) if not data: return self.getJSON({'code': 4000, 'msg': '参数错误!'}) # ID ids = Inc.implode(',', data) model = SysMenuAction() model.where('id in(:ids:)', {'ids': ids}) # 结果 if model.delete(): return self.getJSON({'code': 0, 'msg': '成功'}) else: return self.getJSON({'code': 5000, 'msg': '删除失败!'})
def delete(self): # 参数 req = self.request() data = Inc.json_decode(req.get('data')) if not data : return self.getJSON({'code':4000,'msg':'参数错误!'}) # 管理员 if '1' in data or 1 in data : return self.getJSON({'code':4000,'msg':'无法删除系统管理员!'}) # ID ids = Inc.implode(',',data) user = {'where':'id in(:uid:)','bind':{'uid':ids}} uinfo = {'where':'uid in(:uid:)','bind':{'uid':ids}} # 结果 if User().delete(user) and UserInfo().delete(uinfo) : return self.getJSON({'code':0,'msg':'成功'}) else : return self.getJSON({'code':5000,'msg':'删除失败!'})
def add(self): # 验证 AdminToken().urlVerify('SysMenusAction') # 参数 req = self.request() data = Inc.json_decode(req.get('data')) if not data or type(data) != dict: return self.getJSON({'code': 4000, 'msg': '参数错误!'}) # 数据 model = SysMenuAction() model.name = data['name'].strip() if 'name' in data.keys() else '' model.action = data['action'].strip() if 'action' in data.keys( ) else '' model.perm = data['perm'].strip() if 'perm' in data.keys() else '2' model.ico = data['ico'].strip() if 'ico' in data.keys() else '' # 结果 if model.create(): return self.getJSON({'code': 0, 'msg': '成功'}) else: return self.getJSON({'code': 5000, 'msg': '添加失败!'})
def list(self): req = self.request() # 搜索 data = Inc.json_decode(req.get('data')) uname = data['uname'] where = 'a.uname LIKE \"%:uname:%\" OR a.tel LIKE \"%:uname:%\" OR a.email LIKE \"%:uname:%\"' bind = {'uname':uname} # 查询 params = { 'table': 'user as a LEFT JOIN user_info as b ON a.id=b.uid', 'columns': 'a.id as uid,a.uname as uname,a.email as email,a.tel as tel,a.state as state,'+ 'a.rtime as rtime,a.ltime as ltime,a.utime as utime,'+ 'b.nickname as nickname,b.position as position,b.name as name,b.gender as gender,b.birthday as birthday,b.img as img', 'order': 'a.id DESC', 'where': where, 'bind': bind, } # 统计 total = User().count(params) # 分页 page = req.get('page') limit = req.get('limit') start = (int(page)-1)*int(limit) params['limit'] = str(start)+','+limit # 数据 list = User().find(params) # 状态 for val in list : val['state'] = True if val['state']=='1' else False val['uid'] = str(val['uid']) val['img'] = Env.base_url+str(val['img']) if val['img'] else '' val['birthday'] = str(val['birthday']) if val['birthday'] else '' val['rtime'] = str(val['rtime']) if val['rtime'] else '' val['ltime'] = str(val['ltime']) if val['ltime'] else '' val['utime'] = str(val['utime']) if val['utime'] else '' return self.getJSON({'code':0,'msg':'成功','list':list,'total':total})