def admin_list(page=None): sql = ''' SELECT admin.id,admin.create_time,admin.username,admin.is_super,role.name as role_name, CASE admin.is_super WHEN 1 THEN '超级管理员' ELSE '普通管理员' END as admin_type FROM admin LEFT JOIN role on admin.role_id = role.id WHERE admin.is_del = 0 ORDER BY admin.create_time ASC ''' data = Crud.auto_select(sql) role_data = Crud.get_data(Role, 'create_time') return render_template("admin/admin/admin_list.html", admin_data=data.fetchall(), role_data=role_data)