def find_data_all():
if 'whereStr' in req.args:
str_where = req.args['whereStr']
else:
str_where = ''
# 获取表头数据
list_head = mysqldb.get_head(str_where)
if list_head and len(list_head) >= 0:
name = 'dataList'
name_ch = '数据列表'
field_ch = '模块ID;数据表名称;数据表中文名;中文字段集合;英文字段集合;字段数据类型集合;字段列宽集合;字段排序集合'
field_en = 'id;name;name_ch;field_ch;field_en;data_type;field_width;field_sort'
data_type = 'int(6);text;text;text;text;int;int'
field_width = '100;100;150;200;200;200;200;200'
field_sort = '1;2;3;4;5;6;7;8'
dict_json = {
'code': 0,
'msg': '',
'count': len(list_head),
'prePageNum': 100000,
'currPage': 1,
'name': name,
'name_ch': name_ch,
'field_ch': field_ch,
'field_en': field_en,
'data_type': data_type,
'field_width': field_width,
'field_sort': field_sort,
'rows': list_head
}
return make_response(json.dumps(dict_json, ensure_ascii=False))
else:
return make_response('操作失败')
def find_data(self):
if 'whereStr' in self.req.args:
str_where = self.req.args['whereStr']
else:
str_where = ''
if 'fieldStr' in self.req.args:
str_field = self.req.args['fieldStr']
else:
str_field = ''
if 'sortStr' in self.req.args:
str_sort = self.req.args['sortStr']
else:
str_sort = ''
if 'prePageNum' in self.req.args:
pre_page_num = int(self.req.args['prePageNum'])
else:
pre_page_num = 0
if 'currPage' in self.req.args:
curr_page = int(self.req.args['currPage'])
else:
curr_page = 0
args = {'pre_page_num': pre_page_num, 'curr_page': curr_page, 'sort': str_sort}
result = mysqldb.find_data(self.table_name, str_where, str_field, args)
# print(result)
if result:
# 获取表头数据
list_head = mysqldb.get_head('name="' + self.table_name + '"')
if list_head and len(list_head) > 0:
dict_json = {'code': 0, 'msg': '', 'count': result['count'], 'prePageNum': pre_page_num,
'currPage': curr_page, 'name': list_head[0]['name'], 'name_ch': list_head[0]['name_ch'],
'field_ch': list_head[0]['field_ch'], 'field_en': list_head[0]['field_en'],
'data_type': list_head[0]['data_type'], 'field_width': list_head[0]['field_width'],
'field_sort': list_head[0]['field_sort'], 'rows': result['rows']}
else:
dict_json = {'code': 0, 'msg': '', 'count': result['count'], 'prePageNum': pre_page_num,
'currPage': curr_page, 'name': '', 'name_ch': '', 'field_ch': '', 'field_en': '',
'data_type': '', 'field_width': '', 'field_sort': '', 'rows': result['rows']}
return make_response(json.dumps(dict_json, ensure_ascii=False))
else:
return make_response('操作失败')
def find_data(self):
if 'whereStr' in self.req.args:
str_where = self.req.args['whereStr']
else:
str_where = ''
if 'sortStr' in self.req.args:
str_sort = self.req.args['sortStr']
else:
str_sort = ''
if 'prePageNum' in self.req.args:
pre_page_num = int(self.req.args['prePageNum'])
else:
pre_page_num = 0
if 'currPage' in self.req.args:
curr_page = int(self.req.args['currPage'])
else:
curr_page = 0
str_field = 'user_list.id, user_list.username, user_list.password, user_list.name, user_list.email, user_list.phone, user_list.sex, user_list.age, user_list.create_name, user_list.create_time, user_list.update_name, user_list.update_time, user_list.roleId, role_class.class_name as roleName'
args = {'pre_page_num': pre_page_num, 'curr_page': curr_page, 'sort': str_sort}
sql_lookup = 'user_list LEFT JOIN role_class ON user_list.roleId = role_class.id'
result = mysqldb.find_data(sql_lookup, str_where, str_field, args)
# print(result)
if result:
# 获取表头数据
list_head = mysqldb.get_head('name="' + self.table_name + '"')
if list_head and len(list_head) > 0:
dict_json = {'code': 0, 'msg': '', 'count': result['count'], 'prePageNum': pre_page_num,
'currPage': curr_page, 'name': list_head[0]['name'], 'name_ch': list_head[0]['name_ch'],
'field_ch': list_head[0]['field_ch'], 'field_en': list_head[0]['field_en'],
'data_type': list_head[0]['data_type'], 'field_width': list_head[0]['field_width'],
'field_sort': list_head[0]['field_sort'], 'rows': result['rows']}
else:
dict_json = {'code': 0, 'msg': '', 'count': result['count'], 'prePageNum': pre_page_num,
'currPage': curr_page, 'name': '', 'name_ch': '', 'field_ch': '', 'field_en': '',
'data_type': '', 'field_width': '', 'field_sort': '', 'rows': result['rows']}
return make_response(json.dumps(dict_json, ensure_ascii=False))
else:
return make_response('操作失败')
