| | |
| | | select to_char(optime,'yyyy-mm-dd') as optime,count(*) from lf.sys_login where optime between (select optime - interval '30 day') |
| | | and optime group by to_char(optime, 'yyyy-mm-dd') order by to_char(optime, 'yyyy-mm-dd') asc; |
| | | |
| | | |
| | | |
| | | select * from lf.sys_user; |
| | | select * from lf.sys_menu order by id; |
| | | |
| | | |
| | | |
| | |
| | | 29,23,权限管理,Permission Management,authorityManage,/auth,1,,3,29,1,1,,,, |
| | | 30,22,授权管理,Authorization Management,,,1,,2,30,1,1,,,, |
| | | 31,30,用户角色授权,User Role Authorization,userRoleAuthorization,/roleUser,1,,3,31,1,1,,,, |
| | | 32,30,角色菜单授权,Role Menu Authorization,roleMenuAuthorization,/roleMenuAuth,1,,3,32,1,1,,,, |
| | | 33,30,菜单权限授权,Menu Permission Authorization,menuRoleAuthorization,/menuAuth,1,,3,33,1,1,,,, |
| | | 32,30,菜单权限授权,Menu Permission Authorization,menuRoleAuthorization,/menuAuth,1,,3,32,1,1,,,, |
| | | 33,30,角色菜单授权,Role Menu Authorization,roleMenuAuthorization,/roleMenuAuth,1,,3,33,1,1,,,, |
| | | 34,30,角色资源授权,Role Resource Authorization,roleResAuthorization,/roleRes,1,,3,34,0,1,,,, |
| | | 35,22,运维监控,Operation And Monitoring,,/ctrl,1,,2,35,1,1,,,, |
| | | 36,35,登录日志,Login Log,logLog,/login,1,,3,36,1,1,,,, |