<?php
require_once "Database.php";

class Setting extends BD {

	public function sectores() {
		$query = $this->consult("SELECT * FROM sectores");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function rif() {
		$query = $this->consult("SELECT * FROM tipo_rif ORDER BY tipo_rif");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function estados() {
		$query = $this->consult("SELECT * FROM estados ORDER BY estados");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function municipios() {
		$query = $this->consult("SELECT * FROM municipios ORDER BY municipios");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function parroquias() {
		$query = $this->consult("SELECT * FROM parroquias ORDER BY parroquias");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function condicion_unidad() {
		$query = $this->consult("SELECT * FROM condicion_unidad ORDER BY id");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function campos_ensayo() {
		$query = $this->consult("SELECT * FROM campos_ensayo ORDER BY id");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_servicios() {
		$query = $this->consult("SELECT * FROM tipo_servicios ORDER BY id");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_servic() {
		$query = $this->consult("SELECT * FROM tipo_servic ORDER BY id");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function areas_conocimiento() {
		$query = $this->consult("SELECT * FROM areas_conocimiento");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function subareas_conocimiento() {
		$query = $this->consult("SELECT * FROM subareas_conocimiento");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function disciplina() {
		$query = $this->consult("SELECT * FROM disciplina");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function actividad_economica() {
		$query = $this->consult("SELECT * FROM actividad_economica ORDER BY nombre");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function grupo_actividad_economica() {
		$query = $this->consult("SELECT * FROM grupo_actividad_economica");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function clasificacion() {
		$query = $this->consult("SELECT * FROM clasificacion");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}
	
	public function tipo_personal() {
		$query = $this->consult("SELECT * FROM tipo_personal");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function modalidad_contrato() {
		$query = $this->consult("SELECT * FROM modalidad_contrato");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_ente() {
		$query = $this->consult("SELECT * FROM tipo_ente");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function estatus() {
		$query = $this->consult("SELECT * FROM estatus");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_relacion() {
		$query = $this->consult("SELECT * FROM tipo_relacion");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function modalidad() {
		$query = $this->consult("SELECT * FROM modalidad");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function pais() {
		$query = $this->consult("SELECT * FROM pais");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function estatus_derechos() {
		$query = $this->consult("SELECT * FROM estatus_derechos");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function modalidad_derechos() {
		$query = $this->consult("SELECT * FROM modalidad_derechos");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function estado_avance() {
		$query = $this->consult("SELECT * FROM estado_avance");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_cooperacion() {
		$query = $this->consult("SELECT * FROM tipo_cooperacion");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_investigacion() {
		$query = $this->consult("SELECT * FROM tipo_investigacion");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_producto() {
		$query = $this->consult("SELECT * FROM tipo_producto");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_proyecto() {
		$query = $this->consult("SELECT * FROM tipo_proyecto");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_frecuencia() {
		$query = $this->consult("SELECT * FROM tipo_frecuencia");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_publicacion() {
		$query = $this->consult("SELECT * FROM tipo_publicacion");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_producto_divulgativo() {
		$query = $this->consult("SELECT * FROM tipo_producto_divulgativo");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_texto() {
		$query = $this->consult("SELECT * FROM tipo_texto");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_propiedad_intelectual() {
		$query = $this->consult("SELECT * FROM tipo_propiedad_intelectual");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function modalidad_registro() {
		$query = $this->consult("SELECT * FROM modalidad_registro");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function estado_solicitud() {
		$query = $this->consult("SELECT * FROM estado_solicitud");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_financiamiento() {
		$query = $this->consult("SELECT * FROM tipo_financiamiento");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_seriada() {
		$query = $this->consult("SELECT * FROM tipo_seriada");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_noseriada() {
		$query = $this->consult("SELECT * FROM tipo_noseriada");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_empresa() {
		$query = $this->consult("SELECT * FROM tipo_empresa");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_organizacion() {
		$query = $this->consult("SELECT * FROM tipo_organizacion");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_centro_datos() {
		$query = $this->consult("SELECT * FROM tipo_centro_datos");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_antiguedad() {
		$query = $this->consult("SELECT * FROM tipo_antiguedad");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_sistema_operativo() {
		$query = $this->consult("SELECT * FROM tipo_sistema_operativo");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_estacion_trabjo() {
		$query = $this->consult("SELECT * FROM tipo_estacion_trabjo");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_conexion() {
		$query = $this->consult("SELECT * FROM tipo_conexion");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_velocidad() {
		$query = $this->consult("SELECT * FROM tipo_velocidad");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_servicio_unidad() {
		$query = $this->consult("SELECT * FROM tipo_servicio_unidad");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function modalidad_financiamiento() {
		$query = $this->consult("SELECT * FROM modalidad_financiamiento");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function modalidad_financ1() {
		$query = $this->consult("SELECT * FROM modalidad_financ1");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function modalidad_financ2() {
		$query = $this->consult("SELECT * FROM modalidad_financ2");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function patente_opciones() {
		$query = $this->consult("SELECT * FROM patente_opciones");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}

	public function tipo_ubicacion() {
		$query = $this->consult("SELECT * FROM tipo_ubicacion");
		$query->execute();
        return $query->fetchAll(PDO::FETCH_ASSOC);
	}


}