BugFix.

[mecon/samurai.git] / lib / SAMURAI / Sistema / consultas.ini

diff --git a/lib/SAMURAI/Sistema/consultas.ini b/lib/SAMURAI/Sistema/consultas.ini
index b5ac6f32e3270c4a64a7e0b05463c47e70f74cd4..29869f86b97fbe7f32d07ee956b5bef82c8a4cab 100644 (file)
--- a/lib/SAMURAI/Sistema/consultas.ini
+++ b/lib/SAMURAI/Sistema/consultas.ini
@@ -14,7 +14,7 @@ borrar_permisos         = " DELETE FROM samurai.perm_sist WHERE id_sistema = ? "
 borrar_permisos2        = " AND observaciones = ?"
 borrar_permisos3        = " AND id_permiso = ?"
 
 borrar_permisos2        = " AND observaciones = ?"
 borrar_permisos3        = " AND id_permiso = ?"
 

-sistemas_seleccionar = "SELECT DISTINCT psu.id_sistema AS id_sistema, s.nombre_sistema AS nombre_sistema FROM samurai.perfil_sist_usuario AS psu, samurai.sistema AS s WHERE psu.id_sistema = s.id_sistema AND s.estado = 1 AND psu.login = ? ORDER BY s.nombre_sistema"
+sistemas_seleccionar = "SELECT DISTINCT psu.id_sistema AS id_sistema,s.nombre_sistema AS nombre_sistema FROM samurai.perfil_sist_usuario AS psu, samurai.sistema AS s, samurai.perm_perfil_sist AS pps WHERE psu.id_sistema = s.id_sistema AND psu.id_sistema = pps.id_sistema AND psu.id_perfil = pps.id_perfil AND s.estado = 1 AND psu.login = ? AND pps.id_permiso IN (?,?,?,?,?,?) ORDER BY s.nombre_sistema"

 sistemas_seleccionar2 = "SELECT count(psu.id_sistema) AS cuenta FROM samurai.perfil_sist_usuario AS psu, samurai.perm_perfil_sist AS pps WHERE psu.id_sistema = ? AND login = ? AND psu.id_perfil = pps.id_perfil AND psu.id_sistema = pps.id_sistema AND pps.id_permiso = ?"
 
 ;BORRAR ASOCIACIONES
 sistemas_seleccionar2 = "SELECT count(psu.id_sistema) AS cuenta FROM samurai.perfil_sist_usuario AS psu, samurai.perm_perfil_sist AS pps WHERE psu.id_sistema = ? AND login = ? AND psu.id_perfil = pps.id_perfil AND psu.id_sistema = pps.id_sistema AND pps.id_permiso = ?"
 
 ;BORRAR ASOCIACIONES