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)
