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})
