def userRoles(request):
accId = request.GET.get('id')
userRole = sqlConn.getObjBywhere(models.UserRole, {'accId': accId})
roleList = []
for obj in userRole:
role = sqlConn.getObjBywhere(models.Role, {'roleId': obj.roleId})[0]
roleList.append(role)
userjoin = ','.join([str(x.__repr__()) for x in roleList])
return HttpResponse('[' + userjoin + ']')
def getRolePerm(request):
roleId = request.GET.get('roleId')
rolePerm = sqlConn.getObjBywhere(models.RolePermission, {
'roleId': roleId
}).all()
list = []
for x in rolePerm:
perm = sqlConn.getObjBywhere(models.Permission, {
'pId': x.pId
}).scalar()
list.append(perm.pCode)
return HttpResponse(json.dumps(list))
def getPermTree(request):
parentId = request.POST.get('id')
if parentId != None:
data = sqlConn.getObjBywhere(models.Permission, {'parentId': parentId})
else:
data = sqlConn.getObjBywhere(models.Permission, {'parentId': '00'})
list = []
for x in data:
ptree = models.PermTree(id=x.pCode,
text=x.pName,
checked='',
children='')
list.append(ptree)
jsonList = ','.join([str(x) for x in list])
return HttpResponse('[' + jsonList + ']')
def allRoles(request):
accId = request.GET.get('accId')
userRoles = sqlConn.getObjBywhere(models.UserRole, {'accId': accId})
roleList = sqlConn.getqueryAll(models.Role).all()
uR = ','.join([str(x) for x in userRoles])
rolejoin = ','.join([str(x) for x in roleList])
return HttpResponse(
json.dumps({
'roles': '[' + rolejoin + ']',
'userRole': '[' + uR + ']'
}))
def saveRole(request):
roleId = request.POST.get('roleId')
roleName = request.POST.get('roleName')
roleDescribe = request.POST.get('roleDescribe')
role = None
if roleId != None:
role = sqlConn.getObjBywhere(models.Role, {'roleId': roleId}).scalar()
if role == None:
role = models.Role(roleId=roleId,
roleName=roleName,
roleDescribe=roleDescribe)
sqlConn.save(role)
return HttpResponse(json.dumps({'status': 'OK', 'msg': '保存成功'}))
else:
return HttpResponse(json.dumps({'status': 'error', 'msg': '已经存在的账号'}))
def rolePermSave(request):
try:
roleId = request.POST.get('roleId')
pCodes = request.POST.get('pCodes')
split = pCodes.split(',')
if roleId:
sqlConn.deletebyWhere(models.RolePermission, {'roleId': roleId})
for pCode in split:
if pCode != '':
perm = sqlConn.getObjBywhere(models.Permission, {
'pCode': pCode
}).scalar()
rp = models.RolePermission(roleId=roleId, pId=perm.pId)
sqlConn.save(rp)
return HttpResponse(json.dumps({'status': 'OK', 'msg': '保存成功~'}))
except:
return HttpResponse(json.dumps({'status': 'error', 'msg': '保存失败~'}))
def saveUser(request):
acct = request.POST.get('acct')
name = request.POST.get('name')
sts = request.POST.get('sts')
user = None
if acct != None:
user = sqlConn.getObjBywhere(models.User, {'acct': acct}).scalar()
if user == None:
user = models.User(id=uuid.uuid1().__str__().replace('-', ''),
name=name,
sts=sts,
acct=acct,
pwd='123456',
ctime=localtime)
sqlConn.save(user)
return HttpResponse(json.dumps({'status': 'OK', 'msg': '保存成功'}))
else:
return HttpResponse(json.dumps({'status': 'error', 'msg': '已经存在的账号'}))
def savePerm(request):
pId = request.POST.get('pId')
pName = request.POST.get('pName')
pCode = request.POST.get('pCode')
parentId = request.POST.get('parentId')
perm = None
if pCode != None:
perm = sqlConn.getObjBywhere(models.Permission, {
'pCode': pCode
}).scalar()
if perm == None:
perm = models.Permission(pId=uuid.uuid1().__str__().replace('-', ''),
pCode=pCode,
pName=pName,
parentId=parentId)
sqlConn.save(perm)
return HttpResponse(json.dumps({'status': 'OK', 'msg': '保存成功'}))
else:
return HttpResponse(json.dumps({'status': 'error', 'msg': '已经存在的账号'}))
def savePermPage(request):
perm = None
pId = request.GET.get('pId')
if pId != None:
perm = sqlConn.getObjBywhere(models.Permission, {'pId': pId}).scalar()
return render(request, 'savePermPage.html', {'perm': perm})
def saveRolePage(request):
role = None
roleId = request.GET.get('roleId')
if roleId != None:
role = sqlConn.getObjBywhere(models.Role, {'roleId': roleId}).scalar()
return render(request, 'saveRolePage.html', {'role': role})
def toSetPermPage(request):
role = None
id = request.GET.get('id')
if id != None:
role = sqlConn.getObjBywhere(models.Role, {'roleId': id})[0]
return render(request, 'setRolePermPage.html', {'role': role})