X-Git-Url: https://git.llucax.com/mecon/samurai.git/blobdiff_plain/d0ae155a8be2168110755cce58865068b34bfe91..4a91ae5069fc847c7f27e84a8449fbbd0742e2b2:/lib/SAMURAI/Permiso/consultas.ini

diff --git a/lib/SAMURAI/Permiso/consultas.ini b/lib/SAMURAI/Permiso/consultas.ini
index 5000ab2..b0f53ec 100644
--- a/lib/SAMURAI/Permiso/consultas.ini
+++ b/lib/SAMURAI/Permiso/consultas.ini
@@ -1,8 +1,13 @@
 ; Configuración de la base de datos.
 ; $Id$
 
-obtener_datos_permiso   = "SELECT id_permiso, desc_permiso, responsable FROM permiso " 
-obtener_datos_permiso2  = "WHERE id_permiso = ? "
-borrar_permiso          = "DELETE FROM permiso "
-verificar_asociaciones1 = "SELECT IF(0,0,count(*)) as cuenta FROM perm_sist "
-verificar_asociaciones2 = "SELECT IF(0,0,count(*)) as cuenta FROM perm_perfil_sist "
+
+
+obtener_datos_permiso   = "SELECT p.id_permiso, p.desc_permiso, p.responsable FROM samurai.permiso as p " 
+obtener_datos_permiso2  = "WHERE p.id_permiso = ? "
+obtener_datos_permiso3  = ",samurai.perm_sist as ps WHERE ps.id_sistema = ? AND ps.id_permiso = p.id_permiso "
+obtener_datos_permiso4  = ",samurai.perm_sist as ps WHERE ps.id_permiso = p.id_permiso "
+borrar_permiso          = "DELETE FROM samurai.permiso WHERE id_permiso = ?"
+verificar_asociaciones1 = "SELECT IF(0,0,count(*)) as cuenta FROM samurai.perm_sist as p "
+verificar_asociaciones2 = "SELECT IF(0,0,count(*)) as cuenta FROM samurai.perm_perfil_sist as p "
+