def Edit(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) tData = AdminToken.Token(token) # 参数 data = self.Post('data') if not data: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) param = Util.JsonDecode(data) # 数据 model = UserInfoM() info = { 'nickname': Util.Trim(param['nickname']), 'name': Util.Trim(param['name']), 'gender': Util.Trim(param['gender']), 'birthday': Util.Strtotime(Util.Trim(param['birthday']), '%Y-%m-%d'), 'position': Util.Trim(param['position']), } model.Set(info) model.Where('uid=%s', tData['uid']) model.Update() # 返回 info['uname'] = tData['uname'] info['img'] = param['img'] info['birthday'] = Util.Date('%Y-%m-%d', info['birthday']) return self.GetJSON({'code': 0, 'msg': '成功', 'uinfo': info})
def List(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 data = self.Post('data') page = self.Post('page') limit = self.Post('limit') if not data or not page or not limit: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) param = Util.JsonDecode(data) name = Util.Trim(param['name']) if 'name' in param.keys() else '' # 统计 m = SysRoleM() m.Columns('count(*) AS num') m.Where('name LIKE %s', '%' + name + '%') total = m.FindFirst() # 查询 m.Columns('id', 'name', 'FROM_UNIXTIME(ctime, %s) as ctime', 'FROM_UNIXTIME(utime, %s) as utime', 'perm') m.Where('name LIKE %s', '%Y-%m-%d %H:%i:%s', '%Y-%m-%d %H:%i:%s', '%' + name + '%') m.Page(int(page), int(limit)) list = m.Find() # 返回 return self.GetJSON({ 'code': 0, 'msg': '成功', 'list': list, 'total': total['num'] })
def Upimg(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 name = self.Post('name') base64 = self.Post('base64') if not base64: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) # 类型 if name != 'logo' and name != 'login_bg': return self.GetJSON({'code': 4000, 'msg': '类型错误!'}) # 上传 img = Upload.Base64({'path': self.ImgDir, 'base64': base64}) if not img: return self.GetJSON({'code': 5000, 'msg': '上传失败!'}) # 数据 m = SysConfigM() m.Columns('val') m.Where('name=%s', name) imgData = m.FindFirst() m.Set({'val': self.ImgDir + img}) m.Where('name=%s', name) if not m.Update(): return self.GetJSON({'code': 5000, 'msg': '上传失败!'}) # 清理 rmImg = imgData['val'] FileEo.RemoveAll(rmImg) # 返回 return self.GetJSON({ 'code': 0, 'msg': '成功', 'img': Data.Img(self.ImgDir + img) })
def PermList(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, '') if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 perm = self.Post('perm') # 全部菜单 self.__menus = {} model = SysMenu() model.Columns('id', 'fid', 'title', 'url', 'ico', 'controller', 'action') model.Order('sort DESC, id') data = model.Find() for val in data: fid = str(val['fid']) if fid in self.__menus: self.__menus[fid] += [val] else: self.__menus[fid] = [val] # 用户权限 self.__permAll = self.__permArr(perm) # 返回 return self.GetJSON({ 'code': 0, 'msg': '成功', 'list': self._getMenu('0') })
def Upimg(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) tData = AdminToken.Token(token) # 参数 base64 = self.Post('base64') if not base64: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) # 上传 img = Upload.Base64({'path': self.ImgDir, 'base64': base64}) if not img: return self.GetJSON({'code': 5000, 'msg': '上传失败!'}) # 数据 model = UserInfoM() model.Columns('img') model.Where('uid=%s', tData['uid']) imgData = model.FindFirst() model.Set({'img': self.ImgDir + img}) model.Where('uid=%s', tData['uid']) if not model.Update(): return self.GetJSON({'code': 5000, 'msg': '上传失败!'}) # 清理 rmImg = imgData['img'] FileEo.RemoveAll(rmImg) # 返回 return self.GetJSON({ 'code': 0, 'msg': '成功', 'img': Data.Img(self.ImgDir + img) })
def Edit(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, '') if msg != '' : return self.GetJSON({'code':4001, 'msg':msg}) # 参数 content = self.Post('content') content = Url.Decode(content) # 图片回收 Upload.HtmlImgClear(content, self.ImgDir) # 返回 return self.GetJSON({'code':0, 'msg':'成功', 'content':Url.Encode(content)})
def UpImg(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, '') if msg != '' : return self.GetJSON({'code':4001, 'msg':msg}) # 参数 base64 = self.Post('base64') if not base64 : return self.GetJSON({'code':4000, 'msg':'参数错误!'}) # 上传 img = Upload.Base64({'path':self.ImgDir, 'base64':base64}) if not img : return self.GetJSON({'code':5000, 'msg':'上传失败!'}) # 返回 return self.GetJSON({'code':0, 'msg':'成功', 'img':Data.Img(self.ImgDir+img)})
def Down(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 path = self.Post('path') filename = self.Post('filename') if not path or not filename: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) # 返回 FileEo.Root = Env.root_dir + self.__dirRoot return FileEo.Bytes(path + filename)
def RoleList(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, '') if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 查询 m = SysRoleM() m.Columns('id', 'name') data = m.Find() lists = [{'label': '无', 'value': 0}] for val in data: lists += [{'label': val['name'], 'value': val['id']}] return self.GetJSON({'code': 0, 'msg': '成功', 'list': lists})
def Upload(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 path = self.Post('path') if not path: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) # 数据 file = request.files['up'] img = Upload.File(file, {'path': self.__dirRoot + path, 'bind': None}) if not img: return self.GetJSON({'code': 5000, 'msg': '上传失败!'}) # 返回 return self.GetJSON({'code': 0, 'msg': '成功'})
def Mkdir(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 path = self.Post('path') name = self.Post('name') if not path or not name: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) # 数据 FileEo.Root = Env.root_dir + self.__dirRoot if not FileEo.Mkdir(path + name): return self.GetJSON({'code': 5000, 'msg': '新建文件夹失败!'}) # 返回 return self.GetJSON({'code': 0, 'msg': '成功'})
def Remove(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 path = self.Post('path') data = self.Post('data') if not path or not data: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) # 数据 FileEo.Root = Env.root_dir + self.__dirRoot files = Util.JsonDecode(data) for val in files: FileEo.RemoveAll(path + val) # 返回 return self.GetJSON({'code': 0, 'msg': '成功'})
def List(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) tData = AdminToken.Token(token) # 查询 model = UserInfoM() model.Columns('nickname', 'name', 'gender', 'FROM_UNIXTIME(birthday, %s) as birthday', 'position', 'img') model.Where('uid=%s', '%Y-%m-%d', str(tData['uid'])) list = model.FindFirst() # 数据 list['img'] = Data.Img(str(list['img'])) # 返回 return self.GetJSON({'code': 0, 'msg': '成功', 'list': list})
def List(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 查询 m = SysConfigM() m.Columns('name', 'val') data = m.Find() # 数据 list = {} for val in data: if val['name'] == 'logo' or val['name'] == 'login_bg': list[val['name']] = Data.Img(val['val']) else: list[val['name']] = val['val'] # 返回 return self.GetJSON({'code': 0, 'msg': '成功', 'list': list})
def Token(self): # 验证 request.path token = self.Post('token') msg = AdminToken.Verify(token, '') if msg != '' : return self.GetJSON({'code':4001, 'msg':msg}) # 参数 uinfo = self.Post('uinfo') tData = AdminToken.Token(token) if uinfo!='1' : return self.GetJSON({'code':0, 'msg':'成功', 'token_time':tData['time']}) # 用户信息 model = UserInfo() model.Columns('nickname','position','name','img') model.Where('uid=%s',tData['uid']) info = model.FindFirst() info['uid'] = str(tData['uid']) info['uname'] = tData['uname'] info['img'] = Data.Img(info['img']) return self.GetJSON({'code':0, 'msg':'成功', 'token_time':tData['time'], 'uinfo':info})
def Edit(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 data = self.Post('data') if not data: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) # 数据 m = SysConfigM() param = Util.JsonDecode(data) for key, val in param.items(): if key == 'logo' or key == 'login_bg': continue m.Set({'val': Util.Trim(val)}) m.Where('name=%s', key) if not m.Update(): return self.GetJSON({'code': 5000, 'msg': '更新失败!'}) return self.GetJSON({'code': 0, 'msg': '成功'})
def Del(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 data = self.Post('data') if not data: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) param = Util.JsonDecode(data) ids = Util.Implode(',', param) # 执行 m = ApiMenu() m.Where('id in(' + ids + ')') if m.Delete(): return self.GetJSON({'code': 0, 'msg': '成功'}) else: return self.GetJSON({'code': 5000, 'msg': '删除失败!'})
def Perm(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 id = self.Post('id') data = self.Post('data') if not id or not data: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) # 执行 m = ApiMenu() m.Set({'action': data}) m.Where('id=%s', id) if m.Update(): return self.GetJSON({'code': 0, 'msg': '成功'}) else: return self.GetJSON({'code': 5000, 'msg': '更新失败!'})
def List(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 path = self.Post('path') if not path: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) # 数据 FileEo.Root = Env.root_dir + self.__dirRoot list = FileEo.List(path) # 返回 return self.GetJSON({ 'code': 0, 'msg': '成功', 'url': Env.base_url + self.__dirRoot, 'data': list })
def Perm(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 id = self.Post('id') perm = self.Post('perm') if not id: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) # 数据 m = SysRoleM() m.Set({'perm': perm, 'utime': Util.Time()}) m.Where('id=%s', id) if m.Update(): return self.GetJSON({'code': 0, 'msg': '成功'}) else: return self.GetJSON({'code': 5000, 'msg': '更新失败!'})
def List(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 data = self.Post('data') page = self.Post('page') limit = self.Post('limit') if not data or not page or not limit: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) param = Util.JsonDecode(data) fid = Util.Trim(param['fid']) if 'fid' in param.keys() else '' title = Util.Trim(param['title']) if 'title' in param.keys() else '' url = Util.Trim(param['url']) if 'url' in param.keys() else '' # 统计 m = ApiMenu() m.Columns('count(*) AS num') m.Where('fid like %s AND title like %s AND url like %s', '%' + fid + '%', '%' + title + '%', '%' + url + '%') total = m.FindFirst() # 查询 m.Columns('id', 'fid', 'title', 'ico', 'FROM_UNIXTIME(ctime, %s) as ctime', 'FROM_UNIXTIME(utime, %s) as utime', 'sort', 'url', 'controller', 'action') m.Where('fid like %s AND title like %s AND url like %s', '%Y-%m-%d %H:%i:%s', '%Y-%m-%d %H:%i:%s', '%' + fid + '%', '%' + title + '%', '%' + url + '%') m.Order('sort DESC', 'fid') m.Page(int(page), int(limit)) list = m.Find() # 数据 for val in list: val['action'] = Util.JsonDecode( val['action']) if str(val['action']) != '' else '' # 返回 return self.GetJSON({ 'code': 0, 'msg': '成功', 'list': list, 'total': total['num'] })
def UserInfo(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, '') if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) tData = AdminToken.Token(token) # 配置 cfg = Tencent.TRTC() userId = str(tData['uid']) userSin = Signature.UserSig(userId) # 数据 uinfo = { 'sdk_app_id': cfg['SDKAppID'], 'user_id': userId, 'user_sig': userSin, 'live_domain_name': cfg['PlayDomain'], } # 返回 return self.GetJSON({'code': 0, 'msg': '成功', 'uinfo': uinfo})
def Add(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 data = self.Post('data') if not data: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) param = Util.JsonDecode(data) name = Util.Trim(param['name']) if 'name' in param.keys() else '' if name == '': return self.GetJSON({'code': 4000, 'msg': '名称不能为空!'}) # 数据 m = SysRoleM() m.Values({'name': name, 'ctime': Util.Time()}) if m.Insert(): return self.GetJSON({'code': 0, 'msg': '成功'}) else: return self.GetJSON({'code': 5000, 'msg': '添加失败!'})
def List(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, '') if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 数据 data = [ { 'id': 1, 'group_id': '@TGS#aRHBAOFHK', 'name': 'xxx直播1' }, { 'id': 2, 'group_id': '@TGS#aRHBAOFHK', 'name': 'xxx直播2' }, ] # 返回 return self.GetJSON({'code': 0, 'msg': '成功', 'list': data})
def Edit(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 id = self.Post('id') data = self.Post('data') if not id or not data: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) param = Util.JsonDecode(data) name = Util.Trim(param['name']) if 'name' in param.keys() else '' if name == '': return self.GetJSON({'code': 4000, 'msg': '名称不能为空!'}) # 数据 m = SysRoleM() m.Set({'name': name, 'utime': Util.Time()}) m.Where('id=%s', id) if m.Update(): return self.GetJSON({'code': 0, 'msg': '成功'}) else: return self.GetJSON({'code': 5000, 'msg': '更新失败!'})
def Edit(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 id = self.Post('id') data = self.Post('data') if not id or not data: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) param = Util.JsonDecode(data) title = Util.Trim(param['title']) if 'title' in param.keys() else '' if title == '': return self.GetJSON({'code': 4000, 'msg': '名称不能为空!'}) # 数据 m = ApiMenu() m.Set({ 'fid': Util.Trim(param['fid']) if 'fid' in param.keys() else 0, 'title': title, 'url': Util.Trim(param['url']) if 'url' in param.keys() else '', 'ico': Util.Trim(param['ico']) if 'ico' in param.keys() else '', 'sort': Util.Trim(param['sort']) if 'sort' in param.keys() else 0, 'controller': Util.Trim(param['controller']) if 'controller' in param.keys() else '', 'utime': Util.Time(), }) m.Where('id=%s', id) if m.Update(): return self.GetJSON({'code': 0, 'msg': '成功'}) else: return self.GetJSON({'code': 5000, 'msg': '更新失败!'})
def Edit(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '' : return self.GetJSON({'code':4001, 'msg':msg}) tData = AdminToken.Token(token) # 参数 passwd = self.Post('passwd') passwdNew = self.Post('passwdNew') if passwd==passwdNew : return self.GetJSON({'code':4000, 'msg':'不能与原密码相同!'}) if not Safety.IsRight('passwd', passwd) or not Safety.IsRight('passwd', passwdNew) : return self.GetJSON({'code':4000, 'msg':'密码为6~16位!'}) # 数据 model = User() model.Columns('id') model.Where('id=%s AND password=%s', str(tData['uid']), Hash.Md5(passwd)) uData = model.FindFirst() if not uData : return self.GetJSON({'code':4000, 'msg':'当前密码错误!'}) model.Set({'password':Hash.Md5(passwdNew)}) model.Where('id=%s', str(tData['uid'])) if not model.Update() : return self.GetJSON({'code':5000, 'msg':'修改失败!'}) # 返回 return self.GetJSON({'code':0, 'msg':'成功'})
def Add(self): # 验证 token = self.Post('token') msg = AdminToken.Verify(token, request.path) if msg != '': return self.GetJSON({'code': 4001, 'msg': msg}) # 参数 data = self.Post('data') if not data: return self.GetJSON({'code': 4000, 'msg': '参数错误!'}) param = Util.JsonDecode(data) title = Util.Trim(param['title']) if 'title' in param.keys() else '' if title == '': return self.GetJSON({'code': 4000, 'msg': '名称不能为空!'}) # 数据 m = ApiMenu() m.Values({ 'fid': Util.Trim(param['fid']) if 'fid' in param.keys() else 0, 'title': title, 'url': Util.Trim(param['url']) if 'url' in param.keys() else '', 'ico': Util.Trim(param['ico']) if 'ico' in param.keys() else '', 'sort': Util.Trim(param['sort']) if 'sort' in param.keys() else 0, 'controller': Util.Trim(param['controller']) if 'controller' in param.keys() else '', 'ctime': Util.Time(), }) if m.Insert(): return self.GetJSON({'code': 0, 'msg': '成功'}) else: return self.GetJSON({'code': 5000, 'msg': '添加失败!'})