def searchAct(self,req):
result = []
for col in self.session.query(UserGroupInfo).\
filter(UserGroupInfo.userGroupType!=GLBConfig.GTYPE_ADMINISTRATOR).\
filter(UserGroupInfo.userGroupName!='administrator').\
all():
row = {}
row = SysUtil.schema2Json(col)
result.append(row)
return result
def searchAct(self, req):
result = []
for user, operator in self.session.query(User, OperatorInfo).\
filter(User.userID==OperatorInfo.userID).\
filter(User.accountType==GLBConfig.ATYPE_OPERATOR).\
filter(User.dataStatus==GLBConfig.ENABLE).\
order_by(User.makeTime.desc()).all():
row = {}
row = SysUtil.schema2Json(operator)
row['userName'] = user.userName
result.append(row)
return result
def addAct(self,req):
doc = req.context['doc']
rtn = {}
userGroup = self.session.query(UserGroupInfo).filter_by(userGroupName=doc['userGroupName']).first()
if userGroup is not None:
self.errorReturn(GLBConfig.API_ERROR, '用户组已经存在')
else:
try:
userGroup = UserGroupInfo(userGroupType = GLBConfig.GTYPE_OPERATORGROUP,
userGroupName = doc['userGroupName'],
userGroupStatus = GLBConfig.ENABLE)
self.session.add(userGroup)
self.session.commit()
rtn = SysUtil.schema2Json(userGroup)
except Exception as ex:
self.logger.error(ex)
self.session.rollback()
self.errorReturn(GLBConfig.SYSTEM_ERROR, '系统错误')
return rtn