SAMURAI_LIB - Funcion tiene lista. Faltan el resto de las funciones`

[mecon/meconlib.git] / samurai_lib / src / samurai_lib_sql.inc

diff --git a/samurai_lib/src/samurai_lib_sql.inc b/samurai_lib/src/samurai_lib_sql.inc
index 3057deacbee36cff5d50af2f4a22f422be978f64..87b813a472752158dd4b4bade8a9a41104a54089 100644 (file)
--- a/samurai_lib/src/samurai_lib_sql.inc
+++ b/samurai_lib/src/samurai_lib_sql.inc
@@ -1,12 +1,16 @@
 <?php
 <?php

+    
+    // $Id$
+    //
+    // $URL$
+    // $Rev$
+    // $Date$
+    // $Author$
+
+    

     return array(
     return array(

-    'obtener_perfil_usuario'  => 'SELECT psu.login AS login, psu.id_perfil AS id_perfil, psu.id_sistema AS id_sistema
-                                  FROM perfil_sist_usuario AS psu
-                                 WHERE login = ? AND id_sistema = ?
-                                 ORDER BY id_perfil DESC',
-    'obtener_permisos_perfil' => 'SELECT e.desc_permiso AS desc_permiso 
-                                  FROM perm_perfil_sist AS pps, permiso AS e
-                                 WHERE pps.id_perfil = ? AND pps.id_sistema = ? AND pps.id_permiso = e.id_permiso
-                                 ORDER BY e.id_permiso DESC'
+    'obtener_p_p_completo'    => 'SELECT DISTINCT pps.id_permiso AS id_permiso 
+                                  FROM perfil_sist_usuario AS psu , perm_perfil_sist AS pps 
+                                 WHERE psu.id_sistema = ? AND login = ? AND psu.id_perfil = pps.id_perfil'

     );
 ?>
     );
 ?>