consultas.php

Ir a la documentación de este archivo.

<?php
// vim: set expandtab tabstop=4 softtabstop=4 shiftwidth=4:
// +----------------------------------------------------------------------+
// | PHP Version 4                                                        |
// +----------------------------------------------------------------------+
// | Copyright (c) 1997-2003 The PHP Group                                |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.02 of the PHP license,      |
// | that is bundled with this package in the file LICENSE, and is        |
// | available at through the world-wide-web at                           |
// | http://www.php.net/license/2_02.txt.                                 |
// | If you did not receive a copy of the PHP license and are unable to   |
// | obtain it through the world-wide-web, please send a note to          |
// | license@php.net so we can mail you a copy immediately.               |
// +----------------------------------------------------------------------+
// | Created: Tue May 27 11:20:04 2003
// | Author:  Martin Marrese - Myrna Degano <mmarre@mecon.gov.ar - mdegan@mecon.gov.ar>
// +----------------------------------------------------------------------+
//
// $Id: consultas.php 26 2003-07-07 22:45:35Z mmarre $
// $Author: mmarre $
// $URL: http://portal.mecon.ar/svn/samurai/tronco/lib/SAMURAI/Sistema/consultas.php $
// $Date: 2003-07-07 19:45:35 -0300 (Mon, 07 Jul 2003) $
// $Rev: 26 $
//
    return array (
        //OBTENER DATOS
        'obtener_datos_sistema'   => 'SELECT id_sistema, nombre_sistema, desc_sistema, fecha_inicio, fecha_fin, fecha_implementacion, contacto,responsable FROM samurai.sistema ',
        'obtener_datos_sistema2'  => ' WHERE id_sistema = ? ',
        'obtener_permisos'        => 'SELECT id_permiso, observaciones FROM samurai.perm_sist WHERE id_sistema = ?',
        'obtener_permisos2'       => ' ORDER BY id_permiso',
        'obtener_permisos3'       => ' AND id_permiso = ?',
        'obtener_permisos4'       => ' AND observaciones = ?',
        'obtener_max_id_sistemas' => 'SELECT IFNULL(max(id_sistema), 1)  as id_sistema FROM samurai.sistema',
        //BORRAR DATOS
        'borrar_permisos'         => 'DELETE FROM samurai.perm_sist WHERE id_sistema = ? ',
        'borrar_permisos2'        => ' AND observaciones = ?',
        'borrar_permisos3'        => ' AND id_permiso = ?',        
    );
?>

---