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)