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, 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 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})
# 参数
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 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 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 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 Login(self):
uname = self.Post('uname')
passwd = self.Post('passwd')
# 验证用户名
if not Safety.IsRight('uname',uname) and not Safety.IsRight('tel',uname) and not Safety.IsRight('email',uname):
return self.GetJSON({'code':4000, 'msg':'请输入用户名/手机/邮箱'})
# 密码长度
if not Safety.IsRight('passwd',passwd) :
return self.GetJSON({'code':4000, 'msg':'请输入6~16位密码'})
# 查询
model = UserM()
model.Table('user AS a')
model.LeftJoin('user_info AS b', 'a.id=b.uid')
model.LeftJoin('sys_perm AS c', 'a.id=c.uid')
model.LeftJoin('sys_role AS d', 'c.role=d.id')
model.Where(
'(a.uname=%s OR a.tel=%s OR a.email=%s) AND a.password=%s',
uname, uname, uname, Hash.Md5(passwd)
)
model.Columns('a.id', 'a.state', 'b.position', 'b.nickname', 'b.name', 'b.gender', 'b.birthday', 'b.img', 'c.perm', 'd.perm as role_perm')
data = model.FindFirst()
# 是否存在
if not data : return self.GetJSON({'code':4000, 'msg':'帐号或密码错误!'})
# 是否禁用
if data['state']!='1' : return self.GetJSON({'code':4000, 'msg':'该用户已被禁用!'})
# 权限
perm = data['role_perm']
if data['perm'] : perm=data['perm']
if not perm : return self.GetJSON({'code':4000, 'msg':'该用户不允许登录!'})
redis = Redis()
key = Env.admin_token_prefix+'_perm_'+str(data['id'])
redis.Set(key, perm)
redis.Expire(key, Env.admin_token_time)
redis.Close()
# 登录时间
model.Table('user')
model.Set({'ltime': Util.Time()})
model.Where('id=%s', data['id'])
model.Update()
# 返回
return self.GetJSON({
'code': 0,
'msg': '成功',
'token': AdminToken.Create({'uid':str(data['id']), 'uname':uname}),
'uinfo': {
'uid': data['id'],
'uname': uname,
'position': data['position'],
'nickname': data['nickname'],
'name': data['name'],
'gender': data['gender'],
'img': Env.base_url+data['img'] if data['img']!='' else '',
}
})
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 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 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 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 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 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 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 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 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 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 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})
# 参数
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 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 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 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 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': '添加失败!'})
