=========================================== VERIFICACIΓ“N SISTEMA DE PERMISOS - AAT =========================================== πŸ‘₯ ROLES EN EL SISTEMA ---------------------------------------- Total: 34 roles Super_Admin β†’ 163 permisos Admin β†’ 163 permisos AdminEcommer β†’ 0 permisos Ecommer β†’ 0 permisos AdminCPA β†’ 0 permisos CPA β†’ 0 permisos Admin_Formularios β†’ 19 permisos form-manager β†’ 19 permisos form-creator β†’ 7 permisos form-viewer β†’ 5 permisos form-responder β†’ 3 permisos Admin_Capacitaciones β†’ 1 permisos Admin_RRHH β†’ 0 permisos Admin_Inventario β†’ 0 permisos Admin_Mantenimiento β†’ 0 permisos Admin_Seguridad β†’ 0 permisos Admin_Sistema β†’ 0 permisos Director_HSEQ β†’ 24 permisos Responsable_ORAC β†’ 0 permisos Supervisor_RRHH β†’ 0 permisos Operador_Inventario β†’ 0 permisos Tecnico_Mantenimiento β†’ 0 permisos Instructor β†’ 0 permisos Vigilante β†’ 0 permisos Usuario_PQRSD β†’ 0 permisos Empleado β†’ 4 permisos AdminSGI β†’ 62 permisos Auditor_Interno β†’ 7 permisos Responsable_Proceso β†’ 17 permisos Invitado β†’ 1 permisos inspector β†’ 0 permisos Admin_Blog β†’ 163 permisos Admin_Compras β†’ 0 permisos Operador_Compras β†’ 0 permisos πŸ“ PERMISOS EN EL SISTEMA ---------------------------------------- Total: 163 permisos Por mΓ³dulo (primeros 10): β€’ dashboard : 2 permisos β€’ offsprings : 4 permisos β€’ categories : 4 permisos β€’ subcategories : 4 permisos β€’ products : 4 permisos β€’ index : 12 permisos β€’ create : 11 permisos β€’ edit : 11 permisos β€’ approve : 3 permisos β€’ close : 1 permisos ... y 30 mΓ³dulos mΓ‘s πŸ‘€ USUARIOS CON ROLES ASIGNADOS ---------------------------------------- βœ… nesfab2007@gmail.com β†’ Roles: Super_Admin, Admin, Admin_Capacitaciones, Director_HSEQ, Admin_Blog, Admin_Compras βœ… cuellaryinapaola@gmail.com β†’ Roles: Super_Admin, Director_HSEQ βœ… test1772996923@example.com β†’ Roles: Empleado βœ… nestorfabianmejia56@gmail.com β†’ Roles: Empleado πŸ‘€ USUARIOS SIN ROLES (sin acceso admin) ---------------------------------------- βœ… Todos los usuarios tienen roles asignados =========================================== πŸ“Š ESTADO DEL SISTEMA =========================================== AAT
Internal Server Error
Error
Call to a member function count() on string
verificar_sistema_permisos.php :119
Request
GET /
Headers
host
faleyi.com.co
user-agent
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
accept
*/*
accept-language
en-us,en;q=0.5
accept-charset
ISO-8859-1,utf-8;q=0.7,*;q=0.7
x-forwarded-host
faleyi.com.co
x-forwarded-port
443
x-forwarded-proto
https
x-forwarded-server
faleyi.com.co
x-real-ip
216.73.216.28
x-https
1
Body
No body data
Application
Routing
No routing data
Database Queries
mysql
select * from `roles`
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 1
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 2
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 3
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 4
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 5
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 6
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 7
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 8
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 9
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 10
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 11
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 12
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 13
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 14
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 15
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 16
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 17
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 18
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 19
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 20
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 21
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 22
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 23
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 24
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 25
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 26
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 27
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 28
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 29
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 30
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 31
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 32
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 33
mysql
select count(*) as aggregate from `permissions` inner join `role_has_permissions` on `permissions`.`id` = `role_has_permissions`.`permission_id` where `role_has_permissions`.`role_id` = 34
mysql
select * from `permissions`
mysql
select * from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User')
mysql
select `roles`.*, `model_has_roles`.`model_id` as `pivot_model_id`, `model_has_roles`.`role_id` as `pivot_role_id`, `model_has_roles`.`model_type` as `pivot_model_type` from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `model_has_roles`.`model_id` in (1, 2, 3, 4) and `model_has_roles`.`model_type` = 'App\Models\User'
mysql
select * from `users` where not exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User')