function export($parameters, $arg1 = '', $arg2 = '', $arg3 = '') { if ($arg1 or $arg2 or $arg3) { $sql = $arg1; $type = $arg2 ? $arg2 : "csv"; } else { if (is_array($parameters)) { $sql = array_key_exists("sql", $parameters) ? $parameters['sql'] : NULL; $type = array_key_exists("type", $parameters) ? $parameters['type'] : "csv"; } } if ($type == "csv") { require_once "../zig-api/plugins/adodb/toexport.inc.php"; $files_path = zig("config", "files path"); $temp_path = "{$files_path}blank.csv"; //if(file_exists($temp_path)) if (zig("cache", "file_exists", $temp_path)) { $time = time(); $function = "export"; $file_name = $time . $function . "." . $type; copy($temp_path, $temp_path . $file_name); $result = $GLOBALS['zig']['adodb']->Execute($sql); if ($result != "") { $result->MoveFirst(); $fp = fopen($temp_path . $file_name, "w"); if ($fp) { rs2csvfile($result, $fp); fclose($fp); } $buffer = "\n end of file -- file export success"; $location = "{$temp_path}{$file_name}"; header('Content-type: application/csv'); header("Content-Disposition: attachment; filename={$file_name}"); readfile("{$temp_path}{$file_name}"); $zig_result['buffer'] = $buffer; print $buffer; zig("cache", "unlink", $location); zig("cache", "unlink", $temp_path); //unlink($location); //unlink($temp_path); } else { $zig_result['error'] = $GLOBALS['zig']['obj']['error']->error(106); } } else { $zig_result['error'] = $GLOBALS['zig']['obj']['error']->error(102); } } else { $zig_result['error'] = $GLOBALS['zig']['obj']['error']->error(103); } $zig_result['gui_buffer'] = 0; return $zig_result; }
function CSV_export($table, $file, $db) { $rs = $db->Execute('select * from ' . $table); if (!$rs) { echo $db->ErrorMsg(); } $f = fopen($file, 'w'); rs2csvfile($rs, $f); fclose($f); $result['result'] = 2; //success return $result; }
function Ciudadano_show($nivelus, $tpRemDes, $whereFlds) { //------------------------------- // Initialize variables //------------------------------- global $db2; global $db3; global $sRADICADOErr; global $sFileName; global $styles; global $ruta_raiz; $sWhere = ""; $sOrder = ""; $sSQL = ""; $db = new ConnectionHandler($ruta_raiz); if ($tpRemDes == 1) { $tpRemDesNombre = "Por Ciudadano"; } if ($tpRemDes == 2) { $tpRemDesNombre = "Por Otras Empresas"; } if ($tpRemDes == 3) { $tpRemDesNombre = "Por Entidad"; } if ($tpRemDes == 4) { $tpRemDesNombre = "Por Funcionario"; } if ($tpRemDes == 9) { $tpRemDesNombre = ""; $whereTrd = " "; } else { $whereTrd = " and dir.sgd_trd_codigo = {$whereFlds} "; } if ($indiVinculo == 2) { $sFormTitle = "Expedientes encontrados {$tpRemDesNombre}"; } else { $sFormTitle = "Radicados encontrados {$tpRemDesNombre}"; } $HasParam = false; $iRecordsPerPage = 25; $iCounter = 0; $iPage = 0; $bEof = false; $iSort = ""; $iSorted = ""; $sDirection = ""; $sSortParams = ""; $iTmpI = 0; $iTmpJ = 0; $sCountSQL = ""; $transit_params = ""; //Proceso de Vinculacion documentos $indiVinculo = get_param("indiVinculo"); $verrad = get_param("verrad"); $carpeAnt = get_param("carpeAnt"); $nomcarpeta = get_param("nomcarpeta"); // //$db->conn->debug=true; //------------------------------- // Build ORDER BY statement //------------------------------- //$sOrder = " order by r.RADI_NUME_RADI "; $sOrder = " order by r.radi_fech_radi "; $iSort = get_param("FormCIUDADANO_Sorting"); $iSorted = get_param("FormCIUDADANO_Sorted"); $krd = get_param("krd"); $form_params = trim(session_name()) . "=" . trim(session_id()) . "&krd={$krd}&verrad={$verrad}&indiVinculo={$indiVinculo}&carpeAnt={$carpeAnt}&nomcarpeta={$nomcarpeta}&s_RADI_DEPE_ACTU=" . tourl(get_param("s_RADI_DEPE_ACTU")) . "&s_RADI_NOMB=" . tourl(get_param("s_RADI_NOMB")) . "&s_RADI_NUME_RADI=" . tourl(get_param("s_RADI_NUME_RADI")) . "&s_TDOC_CODI=" . tourl(get_param("s_TDOC_CODI")) . "&s_desde_dia=" . tourl(get_param("s_desde_dia")) . "&s_desde_mes=" . tourl(get_param("s_desde_mes")) . "&s_desde_ano=" . tourl(get_param("s_desde_ano")) . "&s_hasta_dia=" . tourl(get_param("s_hasta_dia")) . "&s_hasta_mes=" . tourl(get_param("s_hasta_mes")) . "&s_hasta_ano=" . tourl(get_param("s_hasta_ano")) . "&s_solo_nomb=" . tourl(get_param("s_solo_nomb")) . "&s_ciudadano=" . tourl(get_param("s_ciudadano")) . "&s_empresaESP=" . tourl(get_param("s_empresaESP")) . "&s_oEmpresa=" . tourl(get_param("s_oEmpresa")) . "&s_FUNCIONARIO=" . tourl(get_param("s_FUNCIONARIO")) . "&s_entrada=" . tourl(get_param("s_entrada")) . "&s_salida=" . tourl(get_param("s_salida")) . "&nivelus={$nivelus}&s_Listado=" . get_param("s_Listado") . "&s_SGD_EXP_SUBEXPEDIENTE=" . get_param("s_SGD_EXP_SUBEXPEDIENTE") . "&"; // s_Listado s_ciudadano s_empresaESP s_FUNCIONARIO if (!$iSort) { $form_sorting = ""; } else { if ($iSort == $iSorted) { $form_sorting = ""; $sDirection = " DESC "; $sSortParams = "FormCIUDADANO_Sorting=" . $iSort . "&FormCIUDADANO_Sorted=" . $iSort . "&"; } else { $form_sorting = $iSort; $sDirection = " "; $sSortParams = "FormCIUDADANO_Sorting=" . $iSort . "&FormCIUDADANO_Sorted=" . "&"; } switch ($iSort) { case 1: $sOrder = " order by r.radi_nume_radi" . $sDirection; break; case 2: $sOrder = " order by r.radi_fech_radi" . $sDirection; break; case 3: $sOrder = " order by r.ra_asun" . $sDirection; break; case 4: $sOrder = " order by td.sgd_tpr_descrip" . $sDirection; break; case 5: $sOrder = " order by r.radi_nume_hoja" . $sDirection; break; case 6: $sOrder = " order by dir.sgd_dir_direccion" . $sDirection; break; case 7: $sOrder = " order by dir.sgd_dir_telefono" . $sDirection; break; case 8: $sOrder = " order by dir.sgd_dir_mail" . $sDirection; break; case 9: $sOrder = " order by dir.sgd_dir_nombre" . $sDirection; break; case 12: $sOrder = " order by dir.sgd_dir_telefono" . $sDirection; break; case 13: $sOrder = " order by dir.sgd_dir_direccion" . $sDirection; break; case 14: $sOrder = " order by dir.sgd_dir_doc" . $sDirection; break; case 17: $sOrder = " order by r.radi_usu_ante" . $sDirection; break; case 20: $sOrder = " order by r.radi_pais" . $sDirection; break; case 21: $sOrder = " order by diasr" . $sDirection; break; case 22: $sOrder = " order by dir.sgd_dir_nombre" . $sDirection; break; case 23: $sOrder = " order by dir.sgd_dir_nombre" . $sDirection; break; case 24: $sOrder = " order by dir.sgd_dir_nombre" . $sDirection; break; } } //------------------------------- // Encabezados HTML de las Columnas //------------------------------- if ($indiVinculo != 2) { ?> <table width="2000" border=0 cellpadding=0 cellspacing=0 class='borde_tab'> <?php } else { ?> <table width="200" border=0 cellpadding=0 cellspacing=0 class='borde_tab'> <?php } ?> <tr> <td class="titulos4" colspan="20"><a name="RADICADO"><?php echo $sFormTitle; ?> </a></td> </tr> <tr> <?php if ($indiVinculo >= 1) { ?> <td class="titulos5"><font class="ColumnFONT"> </td> <?php } if ($indiVinculo != 2) { ?> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=1&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Radicado</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=2&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Fecha radicación</a></td> <td class="titulos5"><font class="ColumnFONT">Expediente</td> <?php } else { ?> <td class="titulos5"><font class="ColumnFONT">Expediente</td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=1&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Radicado vinculado al expediente</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=2&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Fecha Radicacion</a></td> <?php } ?> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=3&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Asunto</a></td> <td class="titulos5"><span class="vinculos">Cuenta I.</span></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=4&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Tipo de documento</a></td> <td class="titulos5"><font class="ColumnFONT">Tipo</td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=5&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Número de hojas</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=6&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Dirección contacto</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=7&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Teléfono contacto</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=8&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Mail contacto</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=23&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Dignatario</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=9&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Nombre </a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=14&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Documento</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=15&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Usuario actual</a></td> <td class="titulos5"><font class="ColumnFONT">Dependencia actual</td> <td class="titulos5"><font class="ColumnFONT">Usuario anterior</td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=20&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">País</a></td> <td class="titulos5"><a class="vinculos" href="<?php echo $sFileName; ?> ?<?php echo $form_params; ?> FormCIUDADANO_Sorting=21&FormCIUDADANO_Sorted=<?php echo $form_sorting; ?> &">Días Restantes</a></td> </tr> <?php //--------------------------------------------------------------- // Build WHERE statement //------------------------------- // Se crea la $ps_desde_RADI_FECH_RADI con los datos ingresados. //--------------------------------------------------------------- $ps_desde_RADI_FECH_RADI = mktime(0, 0, 0, get_param("s_desde_mes"), get_param("s_desde_dia"), get_param("s_desde_ano")); $ps_hasta_RADI_FECH_RADI = mktime(23, 59, 59, get_param("s_hasta_mes"), get_param("s_hasta_dia"), get_param("s_hasta_ano")); if (strlen($ps_desde_RADI_FECH_RADI) && strlen($ps_hasta_RADI_FECH_RADI)) { $HasParam = true; $sWhere = $sWhere . $db->conn->SQLDate('Y-m-d', 'r.radi_fech_radi') . " >= " . $db->conn->DBDate($ps_desde_RADI_FECH_RADI); //$sWhere = $sWhere . "r.radi_fech_radi>=".$db->conn->DBTimeStamp($ps_desde_RADI_FECH_RADI) ; //by HLP. $sWhere .= " and "; $sWhere = $sWhere . $db->conn->SQLDate('Y-m-d', 'r.radi_fech_radi') . " <= " . $db->conn->DBDate($ps_hasta_RADI_FECH_RADI); //$sWhere = $sWhere . "r.radi_fech_radi<=".$db->conn->DBTimeStamp($ps_hasta_RADI_FECH_RADI); //by HLP. } /* Se recibe la dependencia actual para bsqueda */ $ps_RADI_DEPE_ACTU = get_param("s_RADI_DEPE_ACTU"); if (is_number($ps_RADI_DEPE_ACTU) && strlen($ps_RADI_DEPE_ACTU)) { $ps_RADI_DEPE_ACTU = tosql($ps_RADI_DEPE_ACTU, "Number"); } else { $ps_RADI_DEPE_ACTU = ""; } if (strlen($ps_RADI_DEPE_ACTU)) { if ($sWhere != "") { $sWhere .= " and "; } $HasParam = true; $sWhere = $sWhere . "r.radi_depe_actu=" . $ps_RADI_DEPE_ACTU; } /* Se recibe el nmero del radicado para bsqueda */ require_once "../include/query/busqueda/busquedaPiloto1.php"; $ps_RADI_NUME_RADI = get_param("s_RADI_NUME_RADI"); $ps_DOCTO = get_param("s_DOCTO"); if (strlen($ps_RADI_NUME_RADI)) { if ($sWhere != "") { $sWhere .= " and "; } $HasParam = true; $sWhere = $sWhere . "{$radi_nume_radi} like " . tosql("%" . trim($ps_RADI_NUME_RADI) . "%", "Text"); } if (strlen($ps_DOCTO)) { if ($sWhere != "") { $sWhere .= " and "; } $HasParam = true; $sWhere = $sWhere . " dir.SGD_DIR_DOC = '{$ps_DOCTO}' "; } /** * Se recibe el n�mero del expediente para b�squeda * Fecha de modificaci�n: 30-Junio-2006 * Modificador: Supersolidaria */ $ps_SGD_EXP_SUBEXPEDIENTE = get_param("s_SGD_EXP_SUBEXPEDIENTE"); if (strlen($ps_SGD_EXP_SUBEXPEDIENTE) != 0) { if ($sWhere != "") { $sWhere .= " and "; } $HasParam = true; $sWhere = $sWhere . " R.RADI_NUME_RADI = EXP.RADI_NUME_RADI"; $sWhere = $sWhere . " AND EXP.SGD_EXP_NUMERO = SEXP.SGD_EXP_NUMERO"; /** * No se tienen en cuenta los radicados que han sido excluidos de un expediente. * Fecha de modificaci�n: 12-Septiembre-2006 * Modificador: Supersolidaria */ $sWhere = $sWhere . " AND EXP.SGD_EXP_ESTADO <> 2"; $sWhere = $sWhere . " AND ( EXP.SGD_EXP_NUMERO LIKE '%" . str_replace('\'', '', tosql(trim($ps_SGD_EXP_SUBEXPEDIENTE), "Text")) . "%'"; $sWhere = $sWhere . " OR SEXP.SGD_SEXP_PAREXP1 LIKE UPPER( '%" . str_replace('\'', '', tosql(trim($ps_SGD_EXP_SUBEXPEDIENTE), "Text")) . "%' )"; $sWhere = $sWhere . " OR SEXP.SGD_SEXP_PAREXP2 LIKE UPPER( '%" . str_replace('\'', '', tosql(trim($ps_SGD_EXP_SUBEXPEDIENTE), "Text")) . "%' )"; $sWhere = $sWhere . " OR SEXP.SGD_SEXP_PAREXP3 LIKE UPPER( '%" . str_replace('\'', '', tosql(trim($ps_SGD_EXP_SUBEXPEDIENTE), "Text")) . "%' )"; $sWhere = $sWhere . " OR SEXP.SGD_SEXP_PAREXP4 LIKE UPPER( '%" . str_replace('\'', '', tosql(trim($ps_SGD_EXP_SUBEXPEDIENTE), "Text")) . "%' )"; $sWhere = $sWhere . " OR SEXP.SGD_SEXP_PAREXP5 LIKE UPPER( '%" . str_replace('\'', '', tosql(trim($ps_SGD_EXP_SUBEXPEDIENTE), "Text")) . "%' )"; $sWhere = $sWhere . " )"; } /* Se decide si busca en radicado de entrada o de salida o ambos */ $ps_entrada = strip(get_param("s_entrada")); $eLen = strlen($ps_entrada); $ps_salida = strip(get_param("s_salida")); $sLen = strlen($ps_salida); if ($ps_entrada != "9999") { if ($sWhere != "") { $sWhere .= " and "; } $HasParam = true; $sWhere = $sWhere . "({$radi_nume_radi} like " . tosql("%" . trim($ps_entrada), "Text") . ")"; } /* Se recibe el tipo de documento para la busqueda */ $ps_TDOC_CODI = get_param("s_TDOC_CODI"); if (is_number($ps_TDOC_CODI) && strlen($ps_TDOC_CODI) && $ps_TDOC_CODI != "9999") { $ps_TDOC_CODI = tosql($ps_TDOC_CODI, "Number"); } else { $ps_TDOC_CODI = ""; } if (strlen($ps_TDOC_CODI)) { if ($sWhere != "") { $sWhere .= " and "; } $HasParam = true; $sWhere = $sWhere . "r.tdoc_codi=" . $ps_TDOC_CODI; } /* * *************************************************************** * Se recibe la cadena del metadato para la busqueda. * Implemnetacion para OPAIN S.A. * por Grupo Iyunxi Ltda. */ $ps_METADATO = strip(get_param("s_METADATO")); $yaentro = false; if (strlen($ps_METADATO)) { if ($sWhere != "") { $sWhere .= " and MM.SGD_MMR_DATO LIKE '%{$ps_METADATO}%'"; } $HasParam = true; $sWhere .= " "; } //**************************************************************** /* Se recibe la caadena a buscar y el tipo de busqueda (All) (Any) */ $ps_RADI_NOMB = trim(strip(get_param("s_RADI_NOMB"))); $ps_RADI_NOMB = mb_strtoupper(trim($ps_RADI_NOMB), ini_get('default_charset')); $ps_solo_nomb = get_param("s_solo_nomb"); $yaentro = false; if (trim($ps_RADI_NOMB)) { $inTD = ",2"; } if (strlen($ps_RADI_NOMB)) { //&& $ps_solo_nomb == "Any") if ($sWhere != "") { $sWhere .= " and ("; } $HasParam = true; $sWhere .= " "; $ps_RADI_NOMB = strtoupper($ps_RADI_NOMB); $tok = strtok($ps_RADI_NOMB, " "); $sWhere .= "("; while ($tok) { $sWhere .= ""; if ($yaentro == true) { $sWhere .= " and "; } $sWhere .= "UPPER(dir.sgd_dir_nomremdes) LIKE '%" . $tok . "%' "; $tok = strtok(" "); $yaentro = true; } $sWhere .= ") or ("; $tok = strtok($ps_RADI_NOMB, " "); $yaentro = false; while ($tok) { $sWhere .= ""; if ($yaentro == true) { $sWhere .= " and "; } $sWhere .= "UPPER(dir.sgd_dir_nombre) LIKE '%" . $tok . "%' "; $tok = strtok(" "); $yaentro = true; } $sWhere .= ") or ("; $yaentro = false; $tok = strtok($ps_RADI_NOMB, " "); if ($yaentro == true) { $sWhere .= " and ("; } $sWhere .= "UPPER(" . $db->conn->Concat("r.ra_asun", "r.radi_cuentai", "dir.sgd_dir_telefono", "dir.sgd_dir_direccion") . ") LIKE '%" . $ps_RADI_NOMB . "%' "; $tok = strtok(" "); if ($yaentro == true) { $sWhere .= ")"; } $yaentro = true; $sWhere .= "))"; } if (strlen($ps_RADI_NOMB) && $ps_solo_nomb == "AllTTT") { if ($sWhere != "") { $sWhere .= " AND ("; } $HasParam = true; $sWhere .= " "; $ps_RADI_NOMB = strtoupper($ps_RADI_NOMB); $tok = strtok($ps_RADI_NOMB, " "); $sWhere .= "("; $sWhere .= ""; if ($yaentro == true) { $sWhere .= " AND "; } $sWhere .= "UPPER(dir.sgd_dir_nomremdes) LIKE '%" . $ps_RADI_NOMB . "%' "; $tok = strtok(" "); $yaentro = true; $sWhere .= ") OR ("; $tok = strtok($ps_RADI_NOMB, " "); $yaentro = false; $sWhere .= ""; if ($yaentro == true) { $sWhere .= " AND "; } $sWhere .= "UPPER(dir.sgd_dir_nombre) LIKE '%" . $ps_RADI_NOMB . "%' "; $tok = strtok(" "); $yaentro = true; $sWhere .= ") OR ("; $yaentro = false; $tok = strtok($ps_RADI_NOMB, " "); if ($yaentro == true) { $sWhere .= " AND ("; } $sWhere .= "UPPER(" . $db->conn->Concat("r.ra_asun", "r.radi_cuentai", "dir.sgd_dir_telefono", "dir.sgd_dir_direccion") . ") LIKE '%" . $ps_RADI_NOMB . "%' "; $tok = strtok(" "); if ($yaentro == true) { $sWhere .= ")"; } $yaentro = true; $sWhere .= "))"; } if ($HasParam) { $sWhere = " AND (" . $sWhere . ") "; } //------------------------------- // Build base SQL statement //------------------------------- require_once "../include/query/busqueda/busquedaPiloto1.php"; $sSQL = "SELECT " . $radi_nume_radi . " AS RADI_NUME_RADI," . $db->conn->SQLDate('Y-m-d H:i:s', 'R.RADI_FECH_RADI') . " AS RADI_FECH_RADI,\n\t\t\tr.RA_ASUN, \n\t\t\tr.RADI_CUENTAI AS CUENTAI,\n\t\t\ttd.sgd_tpr_descrip, " . $redondeo . " as diasr,\n\t\t\tr.RADI_NUME_HOJA, \n\t\t\tr.RADI_PATH, \n\t\t\tdir.SGD_DIR_DIRECCION, \n\t\t\tdir.SGD_DIR_MAIL,\n\t\t\tdir.SGD_DIR_NOMREMDES, \n\t\t\tdir.SGD_DIR_TELEFONO, \n\t\t\tdir.SGD_DIR_DIRECCION,\n dir.SGD_DIR_DOC, \n\t\t\tr.RADI_USU_ANTE, \n\t\t\tr.RADI_PAIS,\n\t\t\tdir.SGD_DIR_NOMBRE,\n dir.SGD_TRD_CODIGO, \n\t\t\tr.RADI_DEPE_ACTU, \n\t\t\tr.RADI_USUA_ACTU, \n\t\t\tr.CODI_NIVEL, \n\t\t\tr.SGD_SPUB_CODIGO"; /* * ****************************************************************** /** * B�squeda por par�meto del expediente * Fecha de modificacion: 11-Agosto-2006 * Modificador: Supersolidaria */ if (strlen($ps_SGD_EXP_SUBEXPEDIENTE) != 0) { $sSQL .= " ,EXP.SGD_EXP_NUMERO"; } /** * B�squeda por expediente * Fecha de modificaci�n: 30-Junio-2006 * Modificador: Supersolidaria */ //Modificacion de la conslta para trabajar con la mejora de la busqueda por metadato - Grupo Iyunxi Ltda. if (strlen($ps_SGD_EXP_SUBEXPEDIENTE) != 0) { $sSQL .= " FROM SGD_EXP_EXPEDIENTE EXP, SGD_SEXP_SECEXPEDIENTES SEXP, RADICADO as R\n INNER JOIN SGD_DIR_DRECCIONES DIR ON R.RADI_NUME_RADI=DIR.RADI_NUME_RADI \n\t INNER JOIN SGD_TPR_TPDCUMENTO TD ON R.TDOC_CODI=TD.SGD_TPR_CODIGO"; } else { $sSQL .= " FROM RADICADO R \n INNER JOIN SGD_DIR_DRECCIONES DIR ON R.RADI_NUME_RADI=DIR.RADI_NUME_RADI \n\t INNER JOIN SGD_TPR_TPDCUMENTO TD ON R.TDOC_CODI=TD.SGD_TPR_CODIGO"; } /* * ************************************************************************************** * Busqueda por Metadato * Fecha de implemnetacion 11/Julio/2011 * Para: OPAIN S.A. * Por: Grupo Iyunxi Ltda */ if (strlen($ps_METADATO) != 0) { $sSQL .= " LEFT JOIN SGD_MMR_MATRIMETARADI MM ON R.RADI_NUME_RADI = MM.RADI_NUME_RADI"; } /* * ************************************************************************************** */ $sSQL .= " WHERE dir.sgd_dir_tipo in (1{$inTD})"; // $sSQL .= " WHERE dir.RADI_NUME_RADI=r.RADI_NUME_RADI AND r.TDOC_CODI=td.SGD_TPR_CODIGO "; //-------------------------------//SE QUITA " AND r.CODI_NIVEL <=$nivelus " //--------------------------------- // Assemble full SQL statement //------------------------------- $sSQL .= $sWhere . $whereTrd . $sOrder; // echo "<!-- $sSQL -->"; // $db->conn->debug=true; //------------------------------- // Execute SQL statement //------------------------------- $db->conn->SetFetchMode(ADODB_FETCH_ASSOC); // print $sSQL; $rs = $db->query($sSQL); $rsaux = $db->query($sSQL); $db->conn->SetFetchMode(ADODB_FETCH_NUM); //echo "<hr>$sSQL<hr>"; //------------------------------- // Process empty recordset //------------------------------- if ($rs->EOF || !$rs) { ?> <tr> <td colspan="20" class="alarmas">No hay resultados</td> </tr> <?php //------------------------------- // The insert link. //------------------------------- ?> <tr> <td colspan="20" class="ColumnTD"><font class="ColumnFONT"> <?php ?> </table> <?php return; } /* else{ if (!isset($carpetaBodega)) { include "$ruta_raiz/config.php"; } include_once("$ruta_raiz/adodb/toexport.inc.php"); $ruta = "$ruta_raiz/".$carpetaBodega."tmp/Busqclasic".date('Y_m_d_H_i_s').".csv"; $f = fopen($ruta, 'w'); if ($f) { rs2csvfile($rsaux, $f); $linkcsv= "<a href='$ruta' target='_blank'><img style='border:0px' src='".$ruta_raiz."imagenes/csv.png' alt='Archivo CSV'/></a>"; } } */ //------------------------------- ?> <!--tr> <td colspan="10" class="DataTD"><b>Total Registros Encontrados: <?php echo $fldTotal; ?> </b></td> </tr--> <?php //------------------------------- // Initialize page counter and records per page //------------------------------- $iCounter = 0; //------------------------------- //------------------------------- // Process page scroller //------------------------------- $iPage = get_param("FormCIUDADANO_Page"); //print ("<BR>($iPage)($iRecordsPerPage)"); if (strlen(trim($iPage)) == 0) { $iPage = 1; } else { if ($iPage == "last") { $db_count = get_db_value($sCountSQL); $dResult = intval($db_count) / $iRecordsPerPage; $iPage = intval($dResult); if ($iPage < $dResult) { $iPage++; } } else { $iPage = intval($iPage); } } if (($iPage - 1) * $iRecordsPerPage != 0) { //print ("<BR>($iPage)($iRecordsPerPage)"); do { $iCounter++; $rs->MoveNext(); //print("Entra......"); } while ($iCounter < ($iPage - 1) * $iRecordsPerPage && (!$rs->EOF && $rs)); } $iCounter = 0; //------------------------------- //$ruta_raiz =".."; //include "../config.php"; //include "../jh_class/funciones_sgd.php"; //------------------------------- // Display grid based on recordset //-------------------------------. $i = 1; while (!$rs->EOF && $rs && $iCounter < $iRecordsPerPage) { //------------------------------- // Create field variables based on database fields //------------------------------- $fldRADI_NUME_RADI = $rs->fields['RADI_NUME_RADI']; $fldRADI_FECH_RADI = $rs->fields['RADI_FECH_RADI']; /** * B�squeda por expediente * Fecha de modificaci�n: 11-Agosto-2006 * Modificador: Supersolidaria */ $fldsSGD_EXP_SUBEXPEDIENTE = $rs->fields['SGD_EXP_NUMERO']; $fldCUENTAI = $rs->fields['CUENTAI']; $fldASUNTO = $rs->fields['RA_ASUN']; $fldTIPO_DOC = $rs->fields['SGD_TPR_DESCRIP']; $fldNUME_HOJAS = $rs->fields['RADI_NUME_HOJA']; $fldRADI_PATH = $rs->fields['RADI_PATH']; $fldDIRECCION_C = $rs->fields['SGD_DIR_DIRECCION']; $fldDIGNATARIO = $rs->fields['SGD_DIR_NOMBRE']; $fldTELEFONO_C = $rs->fields['SGD_DIR_TELEFONO']; $fldMAIL_C = $rs->fields['SGD_DIR_MAIL']; $fldNOMBRE = $rs->fields['SGD_DIR_NOMREMDES']; $fldCEDULA = $rs->fields['SGD_DIR_DOC']; //$fldUSUA_ACTU = $rs->fields['NOMB_ACTU") . " - (" . $rs->fields['LOGIN_ACTU").")"; $aRADI_DEPE_ACTU = $rs->fields['RADI_DEPE_ACTU']; $aRADI_USUA_ACTU = $rs->fields['RADI_USUA_ACTU']; $fldUSUA_ANTE = $rs->fields['RADI_USU_ANTE']; $fldPAIS = $rs->fields['RADI_PAIS']; $fldDIASR = $rs->fields['DIASR']; $tipoReg = $rs->fields['SGD_TRD_CODIGO']; $nivelRadicado = $rs->fields['CODI_NIVEL']; $seguridadRadicado = $rs->fields['SGD_SPUB_CODIGO']; $fldMETADATO = $rs->fields['SGD_MMR_DATO']; // Busqueda por Metadato - Grupo Iyunxi Ltda if ($tipoReg == 1) { $tipoRegDesc = "Ciudadano"; } if ($tipoReg == 2) { $tipoRegDesc = "Empresa"; } if ($tipoReg == 3) { $tipoRegDesc = "Entidad"; } if ($tipoReg == 4) { $tipoRegDesc = "Funcionario"; } $fldNOMBRE = str_replace($ps_RADI_NOMB, "<font color=green><b>{$ps_RADI_NOMB}</b>", tohtml($fldNOMBRE)); $fldASUNTO = str_replace($ps_RADI_NOMB, "<font color=green><b>{$ps_RADI_NOMB}</b>", tohtml($fldASUNTO)); //------------------------------- // Busquedas Anidadas //------------------------------- $queryDep = "select DEPE_NOMB from dependencia where DEPE_CODI={$aRADI_DEPE_ACTU}"; $db->conn->SetFetchMode(ADODB_FETCH_ASSOC); $rs2 = $db->query($queryDep); $fldDEPE_ACTU = $rs2->fields['DEPE_NOMB']; $queryUs = "select USUA_NOMB from USUARIO where DEPE_CODI={$aRADI_DEPE_ACTU} and USUA_CODI={$aRADI_USUA_ACTU} "; $rs3 = $db->query($queryUs); $fldUSUA_ACTU = $rs3->fields['USUA_NOMB']; $db->conn->SetFetchMode(ADODB_FETCH_NUM); $linkDocto = "<a class='vinculos' href='javascript:noPermiso(0)' > "; $linkInfGeneral = "<a class='vinculos' href='javascript:noPermiso(0)' > "; if (strlen($fldRADI_PATH)) { $linkDoctoImg = "<a class='vinculos' href='../seguridadImagen.php?fec=" . base64_encode($fldRADI_PATH) . "' target='Imagen{$iii}'>"; } $linkInfGeneralRad = "<a class='vinculos' href='../verradicado.php?verrad={$fldRADI_NUME_RADI}&" . session_name() . "=" . session_id() . "&krd={$krd}&carpeta=8&nomcarpeta=Busquedas&tipo_carp=0'>"; if ($nivelRadicado <= $nivelus) { if ($seguridadRadicado == 1) { if ($aRADI_USUA_ACTU == $_SESSION['codusuario'] && $aRADI_DEPE_ACTU == $_SESSION['dependencia']) { $linkDocto = $linkDoctoImg; $linkInfGeneral = $linkInfGeneralRad; } else { $linkDocto = "<a class='vinculos' href='javascript:noPermiso(1)' > "; $linkInfGeneral = $linkInfGeneralRad; } } else { $linkDocto = $linkDoctoImg; $linkInfGeneral = $linkInfGeneralRad; } } if ($seguridadRadicado == 2) { if ($aRADI_DEPE_ACTU == $_SESSION['dependencia']) { $linkDocto = $linkDoctoImg; $linkInfGeneral = $linkInfGeneralRad; } else { $variable_inventada = $_SESSION['dependencia']; $linkDocto = "<a class='vinculos' href='javascript:noPermiso(1)' > "; $linkInfGeneral = $linkInfGeneralRad; } } if ($seguridadRadicado == 3) { $sql = "select * from sgd_matriz_nivelrad where radi_nume_radi={$fldRADI_NUME_RADI} and usua_login='******'krd'] . "'"; $rsVerif = $db->conn->Execute($sql); if ($rsVerif && !$rsVerif->EOF or $aRADI_USUA_ACTU == $_SESSION['codusuario'] && $aRADI_DEPE_ACTU == $_SESSION['dependencia']) { $linkDocto = $linkDoctoImg; $linkInfGeneral = $linkInfGeneralRad; } else { $linkDocto = "<a class='vinculos' href='javascript:noPermiso(1)' > "; $linkInfGeneral = $linkInfGeneralRad; } } if ($_SESSION['usua_super_perm'] != 0) { //$UsrSecAux->UsrPerm $UsrSecAux = new SecSuperClass($db); $UsrSecAux->SecSuperFill($_SESSION['usua_doc']); if ($UsrSecAux->SecureCheck($fldRADI_NUME_RADI) == false) { $linkDocto = "<a class='vinculos' href='javascript:noPermiso(2)' > "; $linkInfGeneral = "<a class='vinculos' href='javascript:noPermiso(2)' > "; } } //$verImg= $verImg && !($fila['SGD_SPUB_CODIGO']==1); //$linkInfGeneralVin = "<a class='vinculos' href='../vinculacion/mod_vinculacion.php?numRadi=$fldRADI_NUME_RADI&carpeta=$carpeAnt&nomcarpeta=$nomcarpeta&verrad=$verrad&".session_name()."=".session_id()."&krd=$krd&carpeta=$carpeAnt&nomcarpeta=$nomcarpeta&tipo_carp=0' >"; if (strlen($ps_SGD_EXP_SUBEXPEDIENTE) == 0) { $consultaExpediente = "SELECT SGD_EXP_NUMERO FROM SGD_EXP_EXPEDIENTE\n\t\t\t\tWHERE radi_nume_radi= {$fldRADI_NUME_RADI} AND sgd_exp_fech=(SELECT MIN(SGD_EXP_FECH) as minFech from sgd_exp_expediente where radi_nume_radi= {$fldRADI_NUME_RADI})"; $rsE = $db->query($consultaExpediente); $fldsSGD_EXP_SUBEXPEDIENTE = $rsE->fields[0]; } //$linkInfGeneral = //------------------------------- // Process the HTML controls //------------------------------- if ($i == 1) { $formato = "listado1"; $i = 2; } else { $formato = "listado2"; $i = 1; } ?> <tr class="<?php echo $formato; ?> "> <?php if ($indiVinculo == 1) { ?> <td class="leidos" align="center" width="70"> <A href="javascript:pasar_datos('<?php echo $fldRADI_NUME_RADI; ?> ');" > Vincular </td> <?php } if ($indiVinculo == 2) { ?> <td class="leidos" align="center" width="70"> <A href="javascript:pasar_datos('<?php echo $fldsSGD_EXP_SUBEXPEDIENTE; ?> ',2);" > Vincular </td> <?php } ?> <td class="leidos"> <?php if (strlen($fldRADI_PATH)) { $iii = $iii + 1; ?> <?php echo $linkDocto; } ?> <?php echo $fldRADI_NUME_RADI; ?> <?php if (strlen($fldRADI_PATH)) { ?> </a><?php } ?> </td> <td class="leidos"><?php echo $linkInfGeneral; ?> <?php echo tohtml($fldRADI_FECH_RADI); ?> </a></td> <!-- B�squeda por expediente Fecha de modificaci�n: 11-Agosto-2006 Modificador: Supersolidaria --> <td class="leidos"> <?php echo $fldsSGD_EXP_SUBEXPEDIENTE; ?> </td> <td class="leidos"> <?php echo $fldASUNTO; ?> </td> <td class="leidos"> <?php echo $fldCUENTAI; ?> </td> <td class="leidos"> <?php echo tohtml($fldTIPO_DOC); ?> </td> <td class="leidos"> <?php echo $tipoRegDesc; ?> </td> <td class="leidos"> <?php echo tohtml($fldNUME_HOJAS); ?> </td> <td class="leidos"> <?php echo tohtml($fldDIRECCION_C); ?> </td> <td class="leidos"> <?php echo tohtml($fldTELEFONO_C); ?> </td> <td class="leidos"> <?php echo tohtml($fldMAIL_C); ?> </td> <td class="leidos"> <?php echo tohtml($fldDIGNATARIO); ?> </td> <td class="leidos"> <?php echo $fldNOMBRE; ?> </td> <td class="leidos"> <?php echo tohtml($fldCEDULA); ?> </td> <td class="leidos"> <?php echo tohtml($fldUSUA_ACTU); ?> </td> <td class="leidos"> <?php echo tohtml($fldDEPE_ACTU); ?> </td> <td class="leidos"> <?php echo tohtml($fldUSUA_ANTE); ?> </td> <td class="leidos"> <?php echo tohtml($fldPAIS); ?> </td> <td class="leidos"> <?php if ($fldRADI_DEPE_ACTU != 999) { echo tohtml($fldDIASR); } else { echo "Sal"; } ?> </td> </tr> <?php $iCounter++; $rs->MoveNext(); } //------------------------------- // Record navigator. //------------------------------- ?> <tr> <td colspan="20" class="ColumnTD"><font class="ColumnFONT"> <?php // Navigation begin $bEof = $rs; if ($bEof && !$bEof->EOF || $iPage != 1) { $iCounter = 1; $iHasPages = $iPage; $sPages = ""; $iDisplayPages = 0; $iNumberOfPages = 30; /* El nmero de p�inas que aparecer� en el navegador al pie de la p�ina */ while (!$rs->EOF && $rs && $iHasPages < $iPage + $iNumberOfPages) { if ($iCounter == $iRecordsPerPage) { $iCounter = 0; $iHasPages = $iHasPages + 1; } $iCounter++; $rs->MoveNext(); } if (($rs->EOF || !$rs) && $iCounter > 1) { $iHasPages++; } if ($iHasPages - $iPage < intval($iNumberOfPages / 2)) { $iStartPage = $iHasPages - $iNumberOfPages; } else { $iStartPage = $iPage - $iNumberOfPages + intval($iNumberOfPages / 2); } if ($iStartPage < 0) { $iStartPage = 0; } for ($iPageCount = $iPageCount + 1; $iPageCount <= $iPage - 1; $iPageCount++) { $sPages .= "<a href=" . $sFileName . "?" . $form_params . $sSortParams . "FormCIUDADANO_Page=" . $iPageCount . "#RADICADO\"><font " . "class=\"ColumnFONT\"" . ">" . $iPageCount . "</a> "; $iDisplayPages++; } $sPages .= "<font " . "class=\"paginacion\"" . "><b>" . $iPage . "</b> "; $iDisplayPages++; $iPageCount = $iPage + 1; while ($iDisplayPages < $iNumberOfPages && $iStartPage + $iDisplayPages < $iHasPages) { $sPages .= "<a href=\"" . $sFileName . "?" . $form_params . $sSortParams . "FormCIUDADANO_Page=" . $iPageCount . "#RADICADO\"><font " . "class=\"ColumnFONT\"" . ">" . $iPageCount . "</a> "; $iDisplayPages++; $iPageCount++; } if ($iPage == 1) { ?> <font class="paginacion">Primero <font class="paginacion">Anterior <?php } else { ?> <a href="<?php echo $sFileName; ?> ?<?php echo $form_params; echo $sSortParams; ?> FormCIUDADANO_Page=1#RADICADO"><font class="paginacion">Primero</a> <a href="<?php echo $sFileName; ?> ?<?php echo $form_params; echo $sSortParams; ?> FormCIUDADANO_Page=<?php echo $iPage - 1; ?> #RADICADO"><font class="paginacion">Anterior</a> <?php } echo " [ " . $sPages . "] "; if ($rs->EOF) { ?> <font class="ColumnFONT">Siguiente <font class="ColumnFONT">Ultimo <?php } else { ?> <a href="<?php echo $sFileName; ?> ?<?php echo $form_params; echo $sSortParams; ?> FormCIUDADANO_Page=<?php echo $iPage + 1; ?> #RADICADO"><font class="ColumnFONT">Siguiente</a> <?php } } ?> </td></tr> </table> <?php if ($rsaux->EOF || !$rsaux) { } else { if (!isset($carpetaBodega)) { include "{$ruta_raiz}/config.php"; } include_once "{$ruta_raiz}/adodb/toexport.inc.php"; $ruta = "{$ruta_raiz}/" . $carpetaBodega . "tmp/Busqclasic" . date('Y_m_d_H_i_s') . ".csv"; $f = fopen($ruta, 'w'); if ($f) { rs2csvfile($rsaux, $f); echo "<a href='{$ruta}' target='_blank'><img style='border:0px' width='20' height='20' src='" . $ruta_raiz . "/imagenes/csv.png' alt='Archivo CSV'/>Archivo CSV</a>"; } } }
<?php require_once "../boot.php"; global $db; $supporter_keys = mysql_real_escape_string(implode(",", $_REQUEST['supporters'])); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header('Content-Description: File Transfer'); header("Content-type: text/csv"); header("Content-Disposition: attachment; filename=supporters.csv"); header("Expires: 0"); header("Pragma: public"); $rs = $db->Execute('select * from supporter where supporter_KEY in (' . $supporter_keys . ')'); $fp = @fopen('php://output', 'w'); rs2csvfile($rs, $fp); fclose($fp); exit;
</center> </td> </tr> <?php if ($msg) { echo $msg; } echo $resultado; ?> </table> <?php if ($pager) { $pager->Render($rows_per_page = 20, $linkPagina, $checkbox = chkAnulados); } if ($rscsv->EOF || !$rscsv) { } else { if (!isset($carpetaBodega)) { include "{$ruta_raiz}/config.php"; } include_once "{$ruta_raiz}/adodb/toexport.inc.php"; $ruta = "{$ruta_raiz}/" . $carpetaBodega . "tmp/Busqtransferencia" . date('Y_m_d_H_i_s') . ".csv"; $f = fopen($ruta, 'w'); if ($f) { rs2csvfile($rscsv, $f); echo "<a href='{$ruta}' target='_blank'><img style='border:0px' width='20' height='20' src='" . $ruta_raiz . "/imagenes/csv.png' alt='Archivo CSV'/>Archivo CSV</a>"; } } ?> </form> </body> </html>
break; case 'save': $db->Execute("UPDATE " . $owpDBTable['countries'] . " \n\t SET countries_name = " . $db->qstr($countries_name) . ", \n countries_iso_code_2 = " . $db->qstr($countries_iso_code_2) . ", \n countries_iso_code_3 = " . $db->qstr($countries_iso_code_3) . ",\n address_format_id = " . $db->qstr($address_format_id) . " \n WHERE countries_id = '" . $_GET['cID'] . "'"); owpRedirect(owpLink($owpFilename['countries'], 'page=' . $_GET['page'] . '&cID=' . $_GET['cID'])); break; case 'deleteconfirm': $db->Execute("DELETE FROM " . $owpDBTable['countries'] . " \n WHERE countries_id = '" . $_GET['cID'] . "'"); owpRedirect(owpLink($owpFilename['countries'], 'page=' . $_GET['page'])); break; case 'download': $db_table_file = 'db_' . $owpDBTable['countries'] . '-' . date('YmdHis') . '.csv'; $file = fopen(OWP_CSV_TEMP . $db_table_file, "a+"); $sql = "SELECT countries_id, countries_name, countries_iso_code_2, \n countries_iso_code_3, address_format_id \n FROM " . $owpDBTable['countries'] . " \n ORDER BY countries_name"; $rs = $db->Execute($sql); $rs->MoveFirst(); rs2csvfile($rs, $file); fclose($file); if (CVS_SEND_MAIL == 'true') { $sql = "SELECT admin_gender, admin_firstname, admin_lastname, admin_email_address \n FROM " . $owpDBTable['administrators'] . " \n WHERE admin_id = '" . owpDBInput($_SESSION['user_id']) . "'"; $mail_query = $db->Execute($sql); $mail_send_to = $mail_query->fields; // Let's build a message object using the email class $send_mail = new phpmailer(); $send_mail->From = OWP_OWNER_EMAIL_ADDRESS; $send_mail->FromName = OWP_NAME; $send_mail->Subject = EMAIL_COUNTRIES_CVS . strftime(DATE_FORMAT_LONG); if ($mail_send_to['admin_gender'] == 'm') { $body = EMAIL_GREET_MR . $mail_send_to['admin_lastname'] . ',' . "\n\n"; } else { $body = EMAIL_GREET_MS . $mail_send_to['admin_lastname'] . ',' . "\n\n"; }
include_once "{$ruta_raiz}/adodb/toexport.inc.php"; $ruta = "{$ruta_raiz}/" . $carpetaBodega . "tmp/Busqhist_actual" . date('Y_m_d_H_i_s') . ".csv"; $f = fopen($ruta, 'w'); if ($f) { rs2csvfile($csvpager1, $f); echo "<a href='{$ruta}' target='_blank'><img style='border:0px' width='20' height='20' src='" . $ruta_raiz . "/imagenes/csv.png' alt='Archivo CSV'/>Archivo CSV</a>"; } } echo "<table width=100%><tr><td class='titulos5'>Radicados en los que aparezco como histórico.</td></tr>"; echo "<tr><td class='info'>Total registros encontrados: " . $fldTota2 . ".</td></tr><tr><td>"; $pager2->Render($rows_per_page = 10, $linkPagina, $checkbox = chkAnulados); echo "</td></tr></table>"; if ($csvpager2->EOF || !$csvpager2) { } else { if (!isset($carpetaBodega)) { include "{$ruta_raiz}/config.php"; } include_once "{$ruta_raiz}/adodb/toexport.inc.php"; $ruta = "{$ruta_raiz}/" . $carpetaBodega . "tmp/Busqhist_historico" . date('Y_m_d_H_i_s') . ".csv"; $f = fopen($ruta, 'w'); if ($f) { rs2csvfile($csvpager2, $f); echo "<a href='{$ruta}' target='_blank'><img style='border:0px' src='" . $ruta_raiz . "/imagenes/csv.png' alt='Archivo CSV'/></a>"; } } } ?> </form> </body> </HTML>
// Generamos enlace a archivo XML if ($genDetalle == 1 || $genTodosDetalle == 1) { if ($tipoEstadistica) { //==9 if (!isset($carpetaBodega)) { include "{$ruta_raiz}/config.php"; } include_once "{$ruta_raiz}/adodb/toexport.inc.php"; /** require "$ruta_raiz/include/class/RecordSetToXml.class.php"; $objXml = new RecodSetToXml($rsE); if ($objXml) { $ruta = "$ruta_raiz/$carpetaBodega/tmp/Est".date('Y_m_d_H_i_s').".xml"; $f = fopen($ruta, 'w'); if ($f) { fwrite($f,$objXml->creaXml()); fclose($f); echo "<br/><a href='$ruta' target='_blank'><img style='border:0px' src='$ruta_raiz/imagenes/xml.png' alt='Archivo xml'/></a>"; } } */ $ruta = "{$ruta_raiz}/{$carpetaBodega}/tmp/Est" . date('Y_m_d_H_i_s') . ".csv"; $f = fopen($ruta, 'w'); if ($f) { unset($rsE->fields['USUA_NIVEL']); unset($rsE->fields['SGD_SPUB_CODIGO']); rs2csvfile($rsE, $f); //echo "<a href='$ruta' target='_blank'><img style='border:0px' width='20' height='20' src='$ruta_raiz/imagenes/csv.png' alt='Archivo CSV'/>Archivo CSV</a>"; } } }