class Normas{ var $tema=""; var $numero; var $fechaPublicacion; } class Decretos extends Normas{ var $codOrgOrigen; var $descripOrgOrigen; var $anio; var $numExpe; } class DB{ var $host; var $port; var $dbname; var $user; var $password; var $conexion; function DB($p_host,$p_port,$p_dbname,$p_user,$p_password){ $this->host=$p_host; $this->port=$p_port; $this->dbname=$p_dbname; $this->user=$p_user; $this->password=$p_password; $this->conectar(); } function conectar(){ $cadena="host='" . $this->host . "' port='" . $this->port . "' dbname='" . $this->dbname . "' user='" . $this->user . "' password='" . $this->password . "'"; $this->conexion=@pg_connect($cadena); if (!$this->conexion) { echo "Volver a la Página de Inicio
"; exit ("Se Produjo un Error en la Conexión con la Base de Datos - Por favor, espere un momento e intente nuevamente.-"); } } } class DBLyD extends DB{ function getAllReparticiones(){ $cadsql="select num_organo_origen, sub_num_organo_origen, reparticion from organo_origen "; $cadsql.="group by num_organo_origen, sub_num_organo_origen, reparticion "; $cadsql.="order by 1 "; return @pg_query($this->conexion,$cadsql); } function getAllTipoNormas(){ $cadsql="select * from tipo_norma"; return @pg_query($this->conexion,$cadsql); } function getLetras($codOrgano){ $cadsql="select id_organo, cod_letras "; $cadsql.="from organo_origen "; $cadsql.="where sub_num_organo_origen=". $codOrgano;// . " and sub_num_organo_origen=". $sub_num_organo_origen; $cadsql.=" order by 2 "; return @pg_query($this->conexion,$cadsql); } } //$num_legajo=sha1(generar89); $lyd=new DBLyD("yastay.rig.gov.ar","5432","dbleyesdecretos","dbleyesdecretos_webapp",'l3y3s2022'); ?>