def reptile_list():
request_id = request.args.get('request_id')
if request_id:
request_id = int(request_id)
if request.args.get('page'):
page = int(request.args.get('page'))
else:
page = 1
request_data = Crud.get_data(ReptileRequest,
ReptileRequest.create_time.desc())
if request_id:
page_data = Crud.search_data_paginate(
ReptileList, ReptileList.request_id == request_id,
ReptileList.create_time.desc(), page, 20)
else:
page_data = Crud.get_data_paginate(ReptileList,
ReptileList.create_time.desc(),
page, 20)
category_data = Crud.get_data(Category, Category.sort.desc())
category_tree = build_tree(category_data, 0, 0)
return render_template("admin/reptile/reptile_list.html",
request_data=request_data,
page_data=page_data,
category_tree=category_tree,
request_id=request_id)
def role_list(page=None):
sql = '''
SELECT menu.name as menu_name,auth.id,auth.name
FROM auth LEFT JOIN menu ON auth.menu_id = menu.id
WHERE auth.is_del = 0
ORDER BY menu.sort DESC;
'''
data = Crud.auto_select(sql)
menu_auths = rows_by_date(data.fetchall(),'menu_name')
page_data = Crud.get_data_paginate(Role, Role.create_time.asc(), page, 10)
return render_template("admin/role/role_list.html",page_data = page_data,menu_auths = menu_auths)
def message(page=None):
page_data = Crud.get_data_paginate(Message, Message.create_time.desc(),
page, 10)
return render_template("admin/message/message.html", page_data=page_data)
def reptile_request(page=None):
page_data = Crud.get_data_paginate(ReptileRequest,
ReptileRequest.create_time.desc(), page,
10)
return render_template("admin/reptile/reptile_request.html",
page_data=page_data)
def tag_list(page=None):
page_data = Crud.get_data_paginate(Tag, Tag.sort.desc(), page, 10)
return render_template("admin/tag/tag_list.html", page_data=page_data)
def conf_list(page=None):
page_data = Crud.get_data_paginate(Conf, Conf.sort.desc(), page, 10)
return render_template("admin/conf/conf_list.html", page_data=page_data)
