function construirListado()
{
$ciiu = array();
$rup = array();
$parametro = "";
foreach ($_REQUEST as $clave => $valor) {
if (substr($clave, 0, 7) == 'rupuact') {
$parametro .= "&{$clave}={$valor}";
$rup[] = $valor;
} elseif (substr($clave, 0, 7) == 'ciiuact') {
$ciiu[] = "'" . $valor . "'";
$parametro .= "&{$clave}={$valor}";
}
}
$ciiu = implode(',', $ciiu);
$rup = implode(',', $rup);
$cadena_sql = "SELECT ";
$cadena_sql .= "id_registro ";
$cadena_sql .= "FROM " . $this->configuracion["prefijo_sys"] . "ciiu_actividad ";
if ($ciiu != "" || strlen($ciiu) != 0) {
$cadena_sql .= "where ";
$cadena_sql .= "actividad in ({$ciiu}) ";
}
$registrosCIIU = $this->ejecutarSQL($this->configuracion, $this->conexion_consulta, $cadena_sql, "busqueda");
$cadena_sql = "SELECT ";
$cadena_sql .= "id_registro ";
$cadena_sql .= "FROM " . $this->configuracion["prefijo_sys"] . "rup_actividad ";
if ($rup != "" || strlen($rup) != 0) {
$cadena_sql .= "where ";
$cadena_sql .= "actividad in ({$rup}) ";
}
$registrosRUP = $this->ejecutarSQL($this->configuracion, $this->conexion_consulta, $cadena_sql, "busqueda");
if (!isset($registrosCIIU) || !isset($registrosRUP)) {
$this->mensaje = "NO EXISTEN DATOS PARA ESTA CONSULTA";
} else {
$crud = new crud($this->configuracion, 'Resultado', 'pgsql', $this->conexion_consulta, $this->usuario);
$crud->setURLConsulta($this->configuracion["host"] . "/" . $this->configuracion["site"] . "/index.php?formulario=" . $this->cripto->codificar_url("opcion=consultaRegistro&pagina=consultaProveedores{$parametro}", $this->configuracion));
//$crud->setdebug(true);
$crud->setTabla($this->configuracion["prefijo_sys"] . 'v_proveedor_data', 'registro');
$crud->setFormulario($this->configuracion["host"] . "/" . $this->configuracion["site"] . "/index.php?formulario=" . $this->cripto->codificar_url("opcion=listar&no_pagina=consultaProveedores{$parametro}", $this->configuracion));
$crud->setCampo(array("etiqueta" => "Nit", "bd" => "NIT", "params" => "width:100,align:'left'"));
$crud->setCampo(array("etiqueta" => "Empresa", "bd" => "EMPRESA", "params" => "width:180,align:'left'"));
$crud->setCampo(array("etiqueta" => "Contacto", "bd" => "(NOMBRE_REP_1||APE_REP_1)", "params" => "width:180,align:'left'"));
$crud->setCampo(array("etiqueta" => "Telefono", "bd" => "TEL_1", "params" => "width:180,align:'left'"));
$crud->setCampo(array("etiqueta" => "Extension", "bd" => "EXT_1", "params" => "width:50,align:'left'"));
//$crud->setFiltro("input_name","nomEmpresa","igual","tabla");
$i = 0;
$regPROV = array();
while (isset($registrosCIIU[$i][0])) {
$regPROV[] = $registrosCIIU[$i][0];
$i++;
}
$j = 0;
while (isset($registrosRUP[$j][0])) {
$regPROV[] = $registrosRUP[$j][0];
$j++;
}
$crud->setFiltro("registro", implode(',', $regPROV), "in", "tabla");
//unset($_REQUEST);
return $crud->armarCrud($this->configuracion, 'false', 'true', 'false', 'false');
}
}
function construirListado()
{
$ciiu = array();
$rup = array();
$parametro = "";
foreach ($_REQUEST as $clave => $valor) {
if (substr($clave, 0, 7) == 'rupuact') {
$parametro .= "&{$clave}={$valor}";
$rup[] = $valor;
} elseif (substr($clave, 0, 7) == 'ciiuact') {
$ciiu[] = "'" . $valor . "'";
$parametro .= "&{$clave}={$valor}";
}
}
$ciiu = implode(',', $ciiu);
$rup = implode(',', $rup);
$cadena_sql = "SELECT ";
$cadena_sql .= "id_registro ";
$cadena_sql .= "FROM prov_ciiu_actividad ";
$cadena_sql .= "where ";
$cadena_sql .= "actividad in ({$ciiu}) ";
$registrosCIIU = $this->ejecutarSQL($this->configuracion, $this->conexion, $cadena_sql, "busqueda");
$cadena_sql = "SELECT ";
$cadena_sql .= "id_registro ";
$cadena_sql .= "FROM prov_rup_actividad ";
$cadena_sql .= "where ";
$cadena_sql .= "actividad in ({$rup}) ";
$registrosRUP = $this->ejecutarSQL($this->configuracion, $this->conexion, $cadena_sql, "busqueda");
$crud = new crud($this->configuracion, 'Resultado', 'pgsql', $this->conexion, $this->usuario);
$crud->setURLConsulta($this->configuracion["host"] . "/" . $this->configuracion["site"] . "/index.php?formulario=" . $this->cripto->codificar_url("opcion=consultaRegistro&pagina=consultaProveedores{$parametro}", $this->configuracion));
//$crud->setdebug(true);
$crud->setTabla($this->configuracion["prefijo"] . 'proveedor_data', 'id_data');
$crud->setFormulario($this->configuracion["host"] . "/" . $this->configuracion["site"] . "/index.php?formulario=" . $this->cripto->codificar_url("opcion=listar&no_pagina=consultaProveedores{$parametro}", $this->configuracion));
$crud->setCampo(array("etiqueta" => "Nit", "bd" => "reg_data", "params" => "width:300,align:'left'"));
$crud->setCampo(array("etiqueta" => "Empresa", "bd" => "input_value", "params" => "width:380,align:'left'"));
$crud->setCampo(array("etiqueta" => "Contacto", "bd" => "input_value", "params" => "width:380,align:'left'"));
$crud->setFiltro("input_name", "nomEmpresa", "igual", $this->configuracion["prefijo"] . "proveedor_data");
$i = 0;
$regPROV = array();
while (isset($registrosCIIU[$i][0])) {
$regPROV[] = $registrosCIIU[$i][0];
$i++;
}
$j = 0;
while (isset($registrosRUP[$j][0])) {
$regPROV[] = $registrosRUP[$j][0];
$j++;
}
$crud->setFiltro("reg_data", implode(',', $regPROV), "in", "prov_proveedor_data");
//unset($_REQUEST);
return $crud->armarCrud($this->configuracion, 'false', 'true', 'false', 'false');
}