def get(self, *args, **kwargs):
key = self.get_argument('key', default=None, strip=True)
value = self.get_argument('value', default=None, strip=True)
page_size = self.get_argument('page', default=1, strip=True)
limit = self.get_argument('limit', default=30, strip=True)
limit_start = (int(page_size) - 1) * int(limit)
user_list = []
with DBContext('r') as session:
if key and value:
count = session.query(Users).filter(
Users.status != '10').filter_by(**{
key: value
}).count()
user_info = session.query(Users).filter(
Users.status != '10').filter_by(**{
key: value
}).order_by(Users.user_id).offset(limit_start).limit(
int(limit))
else:
count = session.query(Users).filter(
Users.status != '10').count()
user_info = session.query(Users).filter(
Users.status != '10').order_by(
Users.user_id).offset(limit_start).limit(int(limit))
all_user = session.query(Users).filter(Users.status != '10').all()
if int(limit) > 200:
user_info = all_user
for msg in user_info:
data_dict = model_to_dict(msg)
data_dict.pop('password')
data_dict.pop('google_key')
data_dict['last_login'] = str(data_dict['last_login'])
data_dict['ctime'] = str(data_dict['ctime'])
user_list.append(data_dict)
redis_conn = cache_conn()
redis_conn.delete(const.USERS_INFO) ### 清空集合数据
with redis_conn.pipeline(transaction=False) as p:
for msg in all_user:
data_dict = model_to_dict(msg)
data_dict.pop('password')
data_dict.pop('google_key')
data_dict['last_login'] = str(data_dict['last_login'])
data_dict['ctime'] = str(data_dict['ctime'])
nickname_key = bytes(data_dict['nickname'] + '__contact',
encoding='utf-8')
p.hmset(nickname_key, {
"tel": data_dict["tel"],
"email": data_dict["email"]
})
p.sadd(const.USERS_INFO, json.dumps(data_dict))
p.execute()
self.write(dict(code=0, msg='获取用户成功', count=count, data=user_list))
def get(self, *args, **kwargs):
key = self.get_argument('key', default=None, strip=True)
value = self.get_argument('value', default=None, strip=True)
menu_list = []
with DBContext('r') as session:
if key and value:
count = session.query(Menus).filter(
Menus.status != '10').filter_by(**{
key: value
}).count()
menu_info = session.query(Menus).filter(
Menus.status != '10').filter_by(**{
key: value
}).order_by(Menus.menu_id).all()
else:
count = session.query(Menus).filter(
Menus.status != '10').count()
menu_info = session.query(Menus).filter(
Menus.status != '10').order_by(Menus.menu_id).all()
for msg in menu_info:
data_dict = model_to_dict(msg)
menu_list.append(data_dict)
return self.write(dict(code=0, msg='获取成功', data=menu_list,
count=count))
def get(self, *args, **kwargs):
key = self.get_argument('key', default=None, strip=True)
value = self.get_argument('value', default=None, strip=True)
page_size = self.get_argument('page', default=1, strip=True)
limit = self.get_argument('limit', default=2000, strip=True)
limit_start = (int(page_size) - 1) * int(limit)
func_list = []
with DBContext('r') as session:
if key and value:
count = session.query(Functions).filter(
Functions.status != '10').filter_by(**{
key: value
}).count()
func_info = session.query(Functions).filter(
Functions.status != '10').filter_by(**{
key: value
}).order_by(Functions.func_id).offset(limit_start).limit(
int(limit))
else:
count = session.query(Functions).filter(
Functions.status != '10').count()
func_info = session.query(Functions).filter(
Functions.status != '10').order_by(
Functions.func_id).offset(limit_start).limit(
int(limit))
for msg in func_info:
data_dict = model_to_dict(msg)
data_dict['ctime'] = str(data_dict['ctime'])
data_dict['utime'] = str(data_dict['utime'])
func_list.append(data_dict)
return self.write(dict(code=0, msg='获取成功', data=func_list,
count=count))
def get(self, *args, **kwargs):
user_list = []
with DBContext('r') as session:
user_info = session.query(Users).filter(Users.status == '0').all()
for msg in user_info:
data_dict = model_to_dict(msg)
user_list.append(data_dict)
_tree = [{"label": "all", "children": []}]
if user_list:
tmp_tree = {"department": {}, "nickname": {}}
for t in user_list:
department, nickname, user_id = t["department"], t['nickname'], t['user_id']
# 因为是第一层所以没有parent
tmp_tree["department"][department] = {"label": department, "parent": "all", "children": [],
"id": shortuuid.uuid()}
tmp_tree["nickname"][department + "|" + nickname] = {
"label": nickname, "parent": department, "department": department, "id": nickname
}
for tmp_group in tmp_tree["nickname"].values():
tmp_tree["department"][tmp_group["parent"]]["children"].append(tmp_group)
for tmp_git in tmp_tree["department"].values():
_tree[0]["children"].append(tmp_git)
return self.write(dict(code=0, msg='获取用户Tree成功', data=_tree[0]["children"]))
else:
return self.write(dict(code=0, msg='获取用户Tree失败', data=_tree[0]["children"]))
def get(self, *args, **kwargs):
key = self.get_argument('key', default=None, strip=True)
value = self.get_argument('value', default=None, strip=True)
page_size = self.get_argument('page', default=1, strip=True)
limit = self.get_argument('limit', default=10, strip=True)
limit_start = (int(page_size) - 1) * int(limit)
user_list = []
with DBContext('r') as session:
if key and value:
count = session.query(Users).filter(Users.status != '10').filter_by(**{key: value}).count()
user_info = session.query(Users).filter(Users.status != '10').filter_by(**{key: value}).order_by(
Users.user_id).offset(limit_start).limit(int(limit))
else:
count = session.query(Users).filter(Users.status != '10').count()
user_info = session.query(Users).filter(Users.status != '10').order_by(Users.user_id).offset(
limit_start).limit(int(limit))
for msg in user_info:
data_dict = model_to_dict(msg)
data_dict.pop('password')
data_dict.pop('google_key')
data_dict['last_login'] = str(data_dict['last_login'])
data_dict['ctime'] = str(data_dict['ctime'])
user_list.append(data_dict)
self.write(dict(code=0, msg='获取用户成功', count=count, data=user_list))
def get(self, *args, **kwargs):
page_size = self.get_argument('page', default=1, strip=True)
limit = self.get_argument('limit', default=10, strip=True)
key = self.get_argument('key', default=None, strip=True)
value = self.get_argument('value', default=None, strip=True)
start_date = self.get_argument('start_date', default=None, strip=True)
end_date = self.get_argument('end_date', default=None, strip=True)
limit_start = (int(page_size) - 1) * int(limit)
if not start_date:
start_date = datetime.date.today() - relativedelta(months=+1)
if not end_date:
end_date = datetime.date.today() + datetime.timedelta(days=1)
start_time_tuple = time.strptime(str(start_date), '%Y-%m-%d')
end_time_tuple = time.strptime(str(end_date), '%Y-%m-%d')
log_list = []
with DBContext('r') as session:
if key and value:
count = session.query(OperationRecord).filter(
OperationRecord.ctime > start_time_tuple,
OperationRecord.ctime < end_time_tuple).filter_by(
**{
key: value
}).count()
log_info = session.query(OperationRecord).filter(
OperationRecord.ctime > start_time_tuple,
OperationRecord.ctime < end_time_tuple).filter_by(
**{
key: value
}).order_by(-OperationRecord.ctime)
else:
count = session.query(OperationRecord).filter(
OperationRecord.ctime > start_time_tuple,
OperationRecord.ctime < end_time_tuple).count()
log_info = session.query(OperationRecord).filter(
OperationRecord.ctime > start_time_tuple,
OperationRecord.ctime < end_time_tuple).order_by(
-OperationRecord.ctime).offset(limit_start).limit(
int(limit))
for msg in log_info:
data_dict = model_to_dict(msg)
data_dict['ctime'] = str(data_dict['ctime'])
log_list.append(data_dict)
return self.write(
dict(code=0, msg='获取日志成功', count=count, data=log_list))
def get(self, *args, **kwargs):
role_id = self.get_argument('role_id', default=1, strip=True)
data_list = []
if not role_id:
return self.write(dict(code=-1, msg='角色不能为空'))
with DBContext('r') as session:
role_menu = session.query(Menus).outerjoin(
RoleMenus, Menus.menu_id == RoleMenus.menu_id).filter(
RoleMenus.role_id == role_id, RoleMenus.status == '0',
Menus.status == '0').all()
for msg in role_menu:
menu_dict = {}
data_dict = model_to_dict(msg)
menu_dict["menu_name"] = data_dict["menu_name"]
menu_dict["menu_id"] = data_dict["menu_id"]
data_list.append(menu_dict)
return self.write(dict(code=0, msg='获取成功', data=data_list))
def get(self, *args, **kwargs):
role_id = self.get_argument('role_id', default=None, strip=True)
data_list = []
if not role_id: return self.write(dict(code=-1, msg='角色不能为空'))
with DBContext('r') as session:
role_func = session.query(Functions).outerjoin(
RoleFunctions,
Functions.func_id == RoleFunctions.func_id).filter(
RoleFunctions.role_id == role_id,
RoleFunctions.status == '0').all()
for msg in role_func:
menu_dict = {}
data_dict = model_to_dict(msg)
menu_dict["func_id"] = data_dict["func_id"]
menu_dict["func_name"] = data_dict["func_name"]
menu_dict["method_type"] = data_dict["method_type"]
menu_dict["uri"] = data_dict["uri"]
data_list.append(menu_dict)
return self.write(dict(code=0, msg='获取成功', data=data_list))
def get(self, *args, **kwargs):
role_id = self.get_argument('role_id', default=None, strip=True)
data_list = []
if not role_id:
return self.write(dict(code=-1, msg='角色不能为空'))
with DBContext('r') as session:
comp_info = session.query(Components).outerjoin(
RolesComponents,
Components.comp_id == RolesComponents.comp_id).filter(
RolesComponents.role_id == role_id,
RolesComponents.status == '0',
Components.status == '0').all()
for msg in comp_info:
comp_dict = {}
data_dict = model_to_dict(msg)
comp_dict["comp_id"] = data_dict["comp_id"]
comp_dict["component_name"] = data_dict["component_name"]
data_list.append(comp_dict)
return self.write(dict(code=0, msg='获取成功', data=data_list))
