X-Git-Url: https://git.llucax.com/mecon/samurai.git/blobdiff_plain/22d1ae1aa6bfee6df20dfa9544e14feaecc9fbf4..49a7c37c3efc3120d5a40d23d4541c75109136af:/lib/SAMURAI/Perfil/consultas.ini

diff --git a/lib/SAMURAI/Perfil/consultas.ini b/lib/SAMURAI/Perfil/consultas.ini
index 7a3dda6..7e28e3a 100644
--- a/lib/SAMURAI/Perfil/consultas.ini
+++ b/lib/SAMURAI/Perfil/consultas.ini
@@ -7,6 +7,7 @@ obtener_datos_perfil3  = " WHERE p.desc_perfil = ?"
 obtener_id_perfiles    = " SELECT ps.id_perfil FROM samurai.perfil_sist as ps, samurai.perfil as p WHERE ps.id_perfil = p.id_perfil "
 obtener_id_perfiles3   = " AND ps.id_sistema = ? "
 obtener_id_perfiles2   = " AND p.desc_perfil like '%##FILTRO##%'"
+obtener_id_perfiles4   = " ORDER BY p.desc_perfil" 
 borrar_perfil          = " DELETE FROM samurai.perfil as p "
 obtener_permisos       = " SELECT id_permiso, observaciones FROM samurai.perm_perfil_sist WHERE id_perfil = ? AND id_sistema = ?"
 
@@ -15,7 +16,7 @@ borrar_perfil_sist     = " DELETE FROM samurai.perfil_sist WHERE id_perfil = ? A
 borrar_perfil          = " DELETE FROM samurai.perfil WHERE id_perfil = ?"
 
 ;VERIFICACIONES
-verificar_asociacion   = " SELECT ps.id_perfil, ps.tipo_perfil FROM samurai.perfil_sist as ps WHERE ps.id_perfil = ? AND ps.id_sistema = ?"
+verificar_asociacion   = " SELECT ps.id_perfil FROM samurai.perfil_sist as ps WHERE ps.id_perfil = ? AND ps.id_sistema = ?"
 verif_perfil_sist_usuario = "SELECT IF(0,0,count(*)) as cuenta FROM samurai.perfil_sist_usuario WHERE id_perfil = ? AND id_sistema = ? "
 verif_perfil_sist      = "SELECT IF(0,0,count(*)) as cuenta FROM samurai.perfil_sist WHERE id_perfil = ? "