function Search_show()
{
global $db;
global $styles;
global $sForm;
$sFormTitle = "Búsqueda";
$sActionFileName = "busqueda2.php";
$ss_desde_RADI_FECH_RADIDisplayValue = "";
$ss_hasta_RADI_FECH_RADIDisplayValue = "";
$ss_TDOC_CODIDisplayValue = "";
$ss_RADI_DEPE_ACTUDisplayValue = "";
//-------------------------------
// Search Open Event begin
// Search Open Event end
//-------------------------------
//-------------------------------
// Set variables with search parameters
//-------------------------------
$flds_RADI_NUME_RADI = strip(get_param("s_RADI_NUME_RADI"));
$flds_RADI_NOMB = strip(get_param("s_RADI_NOMB"));
$krd = strip(get_param("krd"));
$flds_ciudadano = strip(get_param("s_ciudadano"));
$flds_empresaESP = strip(get_param("s_empresaESP"));
$flds_oEmpresa = strip(get_param("s_oEmpresa"));
$flds_entrada = strip(get_param("s_entrada"));
$flds_salida = strip(get_param("s_salida"));
$flds_solo_nomb = strip(get_param("s_solo_nomb"));
$flds_desde_dia = strip(get_param("s_desde_dia"));
$flds_hasta_dia = strip(get_param("s_hasta_dia"));
$flds_desde_mes = strip(get_param("s_desde_mes"));
$flds_hasta_mes = strip(get_param("s_hasta_mes"));
$flds_desde_ano = strip(get_param("s_desde_ano"));
$flds_hasta_ano = strip(get_param("s_hasta_ano"));
$flds_TDOC_CODI = strip(get_param("s_TDOC_CODI"));
$flds_RADI_DEPE_ACTU = strip(get_param("s_RADI_DEPE_ACTU"));
if (strlen($flds_desde_dia) && strlen($flds_hasta_dia) && strlen($flds_desde_mes) && strlen($flds_hasta_mes) && strlen($flds_desde_ano) && strlen($flds_hasta_ano)) {
$desdeTimestamp = mktime(0, 0, 0, $flds_desde_mes, $flds_desde_dia, $flds_desde_ano);
$hastaTimestamp = mktime(0, 0, 0, $flds_hasta_mes, $flds_hasta_dia, $flds_hasta_ano);
$flds_desde_dia = Date('d', $desdeTimestamp);
$flds_hasta_dia = Date('d', $hastaTimestamp);
$flds_desde_mes = Date('m', $desdeTimestamp);
$flds_hasta_mes = Date('m', $hastaTimestamp);
$flds_desde_ano = Date('Y', $desdeTimestamp);
$flds_hasta_ano = Date('Y', $hastaTimestamp);
} else {
/*DESDE HACE UN MES HASTA HOY */
$desdeTimestamp = mktime(0, 0, 0, Date('m') - 1, Date('d'), Date('Y'));
$flds_desde_dia = Date('d', $desdeTimestamp);
$flds_hasta_dia = Date('d');
$flds_desde_mes = Date('m', $desdeTimestamp);
$flds_hasta_mes = Date('m');
$flds_desde_ano = Date('Y', $desdeTimestamp);
$flds_hasta_ano = Date('Y');
}
//-------------------------------
// Search Show begin
//-------------------------------
//-------------------------------
// Search Show Event begin
// Search Show Event end
//-------------------------------
?>
<form method="post" action="<?php
echo $sActionFileName;
?>
?<?php
echo session_name() . "=" . session_id();
?>
&dependencia=<?php
echo $dependencia;
?>
&krd=<?php
echo $krd;
?>
" name="Search">
<input type="hidden" name=<?php
echo session_name();
?>
value=<?php
echo session_id();
?>
>
<input type="hidden" name=krd value=<?php
echo $krd;
?>
>
<input type="hidden" name="FormName" value="Search"><input type="hidden" name="FormAction" value="search">
<table class="FormTABLE">
<tr>
<td class="FormHeaderTD" colspan="13"><a name="Search"><font class="FormHeaderFONT"><?php
echo $sFormTitle;
?>
</font></a></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Radicado</font></td>
<td class="DataTD"><input class="DataFONT" type="text" name="s_RADI_NUME_RADI" maxlength="" value="<?php
echo tohtml($flds_RADI_NUME_RADI);
?>
" size="" ></td>
</tr>
<tr>
<td class="FieldCaptionTD">
<font class="FieldCaptionFONT">
<INPUT type="radio" NAME="s_solo_nomb" value="All" CHECKED
<?php
if ($flds_solo_nomb == "All") {
echo "CHECKED";
}
?>
>Todas las palabras (y)<br>
<INPUT type="radio" NAME="s_solo_nomb" value="Any"
<?php
if ($flds_solo_nomb == "Any") {
echo "CHECKED";
}
?>
>Cualquier Palabra (o)<br>
</font></td>
<td class="DataTD"><input class="DataFONT" type="text" name="s_RADI_NOMB" maxlength="70" value="<?php
echo tohtml($flds_RADI_NOMB);
?>
" size="70" ></td>
</tr>
<tr>
<td colspan="2" class="FieldCaptionTD"><table><tr>
<td><font class="FieldCaptionFONT">
<INPUT type="checkbox" NAME="s_ciudadano" value="CIU"
<?php
if ($flds_ciudadano == "CIU" || !strlen($flds_ciudadano) && !strlen($flds_empresaESP) && !strlen($flds_oEmpresa)) {
echo "CHECKED";
}
?>
>Buscar en Ciudadanos</font></td>
<td><font class="FieldCaptionFONT">
<INPUT type="checkbox" NAME="s_empresaESP" value="ESP"
<?php
if ($flds_empresaESP == "ESP" || !strlen($flds_ciudadano) && !strlen($flds_empresaESP) && !strlen($flds_oEmpresa)) {
echo "CHECKED";
}
?>
>Buscar en Empresas ESP</font></td>
<td><font class="FieldCaptionFONT">
<INPUT type="checkbox" NAME="s_oEmpresa" value="OEM"
<?php
if ($flds_oEmpresa == "OEM" || !strlen($flds_ciudadano) && !strlen($flds_empresaESP) && !strlen($flds_oEmpresa)) {
echo "CHECKED";
}
?>
>Buscar en otras empresas</font></td>
</tr></table></td>
</tr>
<tr>
<td colspan="2" class="FieldCaptionTD">
<table><tr>
<td><font class="FieldCaptionFONT">
<INPUT type="checkbox" NAME="s_entrada" value="ENT"
<?php
if ($flds_entrada == "ENT" || !strlen($flds_entrada) && !strlen($flds_salida)) {
echo "CHECKED";
}
?>
>Radicados de Entrada</font></td>
<td><font class="FieldCaptionFONT">
<INPUT type="checkbox" NAME="s_salida" value="SAL"
<?php
if ($flds_salida == "SAL" || !strlen($flds_entrada) && !strlen($flds_salida)) {
echo "CHECKED";
}
?>
>Radicados de Salida</font></td>
</tr>
</table></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Desde Fecha (dd/mm/yyyy)</font></td>
<td class="DataTD">
<select class="DataFONT" name="s_desde_dia">
<?php
for ($i = 1; $i <= 31; $i++) {
if ($i == $flds_desde_dia) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
<select class="DataFONT" name="s_desde_mes">
<?php
for ($i = 1; $i <= 12; $i++) {
if ($i == $flds_desde_mes) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
<select class="DataFONT" name="s_desde_ano">
<?php
$agnoactual = Date('Y');
for ($i = 2003; $i <= $agnoactual; $i++) {
if ($i == $flds_desde_ano) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Hasta Fecha (dd/mm/yyyy)</font></td>
<td class="DataTD"><select class="DataFONT" name="s_hasta_dia">
<?php
for ($i = 1; $i <= 31; $i++) {
if ($i == $flds_hasta_dia) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
<select class="DataFONT" name="s_hasta_mes">
<?php
for ($i = 1; $i <= 12; $i++) {
if ($i == $flds_hasta_mes) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
<select class="DataFONT" name="s_hasta_ano">
<?php
for ($i = 2003; $i <= $agnoactual; $i++) {
if ($i == $flds_hasta_ano) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Tipo de Documento</font></td>
<td class="DataTD"><select class="DataFONT" name="s_TDOC_CODI">
<?php
if ($flds_TDOC_CODI == 0) {
$flds_TDOC_CODI = "9999";
}
echo "<option value=\"9999\">" . $ss_TDOC_CODIDisplayValue . "</option>";
$lookup_s_TDOC_CODI = db_fill_array("select SGD_TPR_CODIGO, SGD_TPR_DESCRIP from SGD_TPR_TPDCUMENTO order by SGD_TPR_DESCRIP");
if (is_array($lookup_s_TDOC_CODI)) {
reset($lookup_s_TDOC_CODI);
while (list($key, $value) = each($lookup_s_TDOC_CODI)) {
if ($key == $flds_TDOC_CODI) {
$option = "<option SELECTED value=\"{$key}\">{$value}";
} else {
$option = "<option value=\"{$key}\">{$value}";
}
echo $option;
}
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Dependencia Actual</font></td>
<td class="DataTD"><select class="DataFONT" name="s_RADI_DEPE_ACTU">
<?php
echo "<option value=\"\">" . $ss_RADI_DEPE_ACTUDisplayValue . "</option>";
$lookup_s_RADI_DEPE_ACTU = db_fill_array("select DEPE_CODI, DEPE_NOMB from DEPENDENCIA order by 2");
if (is_array($lookup_s_RADI_DEPE_ACTU)) {
reset($lookup_s_RADI_DEPE_ACTU);
while (list($key, $value) = each($lookup_s_RADI_DEPE_ACTU)) {
if ($key == $flds_RADI_DEPE_ACTU) {
$option = "<option SELECTED value=\"{$key}\">{$value}";
} else {
$option = "<option value=\"{$key}\">{$value}";
}
echo $option;
}
}
?>
</select></td>
</tr>
<tr>
<td align="right" colspan="3"><input class="DataFONT" type="submit" value="Búsqueda"></td>
</tr>
</table>
</form>
<?php
//-------------------------------
// Search Show end
//-------------------------------
//===============================
}
function Search_show()
{
global $db;
global $styles;
global $db2;
global $db3;
global $sForm;
$sFormTitle = "Búsqueda Clásica";
$sActionFileName = "busquedaPiloto.php";
$ss_desde_RADI_FECH_RADIDisplayValue = "";
$ss_hasta_RADI_FECH_RADIDisplayValue = "";
$ss_TDOC_CODIDisplayValue = "Todos los tipos";
$ss_TRAD_CODIDisplayValue = "Todos los tipos (-1,-2,-3,-5, . . .)";
$ss_RADI_DEPE_ACTUDisplayValue = "Todas las dependencias";
//Con esta variable se determina si la busqueda corresponde a vinculacion documentos
$indiVinculo = get_param("indiVinculo");
$verrad = get_param("verrad");
$carpeAnt = get_param("carpeAnt");
$nomcarpeta = get_param("nomcarpeta");
//
if ($indiVinculo == 1) {
$sFormTitle = $sFormTitle . " Anexo al Vuelo ";
}
if ($indiVinculo == 2) {
$sFormTitle = $sFormTitle . " Incluir Expediente ";
}
//-------------------------------
// Search Open Event begin
// Search Open Event end
//-------------------------------
//-------------------------------
// Set variables with search parameters
//-------------------------------
$flds_RADI_NUME_RADI = strip(get_param("s_RADI_NUME_RADI"));
$flds_DOCTO = strip(get_param("s_DOCTO"));
$flds_RADI_NOMB = strip(get_param("s_RADI_NOMB"));
$flds_METADATO = strip(get_param("s_METADATO"));
//Modificacion de Busqueda por Metadato para OPAIN S.A.
$krd = get_param("krd");
$flds_ciudadano = strip(get_param("s_ciudadano"));
if ($flds_ciudadano) {
$checkCIU = "checked";
}
$flds_empresaESP = strip(get_param("s_empresaESP"));
if ($flds_empresaESP) {
$checkESP = "checked";
}
$flds_oEmpresa = strip(get_param("s_oEmpresa"));
if ($flds_oEmpresa) {
$checkOEM = "checked";
}
$flds_FUNCIONARIO = strip(get_param("s_FUNCIONARIO"));
if ($flds_FUNCIONARIO) {
$checkFUN = "checked";
}
$flds_entrada = strip(get_param("s_entrada"));
$flds_salida = strip(get_param("s_salida"));
$flds_solo_nomb = strip(get_param("s_solo_nomb"));
$Busqueda = strip(get_param("Busqueda"));
$flds_desde_dia = strip(get_param("s_desde_dia"));
$flds_hasta_dia = strip(get_param("s_hasta_dia"));
$flds_desde_mes = strip(get_param("s_desde_mes"));
$flds_hasta_mes = strip(get_param("s_hasta_mes"));
$flds_desde_ano = strip(get_param("s_desde_ano"));
$flds_hasta_ano = strip(get_param("s_hasta_ano"));
$flds_TDOC_CODI = strip(get_param("s_TDOC_CODI"));
$s_Listado = strip(get_param("s_Listado"));
$flds_RADI_DEPE_ACTU = strip(get_param("s_RADI_DEPE_ACTU"));
/**
* B�squeda por expediente
* Fecha de modificaci�n: 30-Junio-2006
* Modificador: Supersolidaria
*/
$flds_SGD_EXP_SUBEXPEDIENTE = strip(get_param("s_SGD_EXP_SUBEXPEDIENTE"));
if (strlen($flds_desde_dia) && strlen($flds_hasta_dia) && strlen($flds_desde_mes) && strlen($flds_hasta_mes) && strlen($flds_desde_ano) && strlen($flds_hasta_ano)) {
$desdeTimestamp = mktime(0, 0, 0, $flds_desde_mes, $flds_desde_dia, $flds_desde_ano);
$hastaTimestamp = mktime(0, 0, 0, $flds_hasta_mes, $flds_hasta_dia, $flds_hasta_ano);
$flds_desde_dia = Date('d', $desdeTimestamp);
$flds_hasta_dia = Date('d', $hastaTimestamp);
$flds_desde_mes = Date('m', $desdeTimestamp);
$flds_hasta_mes = Date('m', $hastaTimestamp);
$flds_desde_ano = Date('Y', $desdeTimestamp);
$flds_hasta_ano = Date('Y', $hastaTimestamp);
} else {
/* DESDE HACE UN MES HASTA HOY */
$desdeTimestamp = mktime(0, 0, 0, Date('m') - 1, Date('d'), Date('Y'));
$flds_desde_dia = Date('d', $desdeTimestamp);
$flds_hasta_dia = Date('d');
$flds_desde_mes = Date('m', $desdeTimestamp);
$flds_hasta_mes = Date('m');
$flds_desde_ano = Date('Y', $desdeTimestamp);
$flds_hasta_ano = Date('Y');
}
//-------------------------------
// Search Show begin
//-------------------------------
//-------------------------------
// Search Show Event begin
// Search Show Event end
//-------------------------------
?>
<form method="post" action="<?php
echo $sActionFileName;
?>
?<?php
echo session_name() . "=" . session_id();
?>
&indiVinculo=<?php
echo $indiVinculo;
?>
&verrad=<?php
echo $verrad;
?>
&carpeAnt=<?php
echo $carpeAnt;
?>
&nomcarpeta=<?php
echo $nomcarpeta;
?>
&dependencia=<?php
echo $dependencia;
?>
&krd=<?php
echo $krd;
?>
" name="Search">
<input type="hidden" name=<?php
echo session_name();
?>
value=<?php
echo session_id();
?>
>
<input type="hidden" name=krd value=<?php
echo $krd;
?>
>
<input type="hidden" name="FormName" value="Search"><input type="hidden" name="FormAction" value="search">
<table border=0 cellpadding=0 cellspacing=2 class='borde_tab'>
<?php
if (!$indiVinculo) {
?>
<tr>
<td class="titulos4" colspan="13"><a name="Search">BÚSQUEDAS POR:</td>
</tr>
<tr>
<td colspan="3" class="titulos5">
<table border=0 width=69% cellpadding="0" cellspacing="0">
<tr>
<td width="13%" valign="bottom" class="" ><a class="vinculos" href="../busqueda/busquedaPiloto.php?<?php
echo $phpsession;
?>
&krd=<?php
echo $krd;
?>
&<?php
echo "&fechah={$fechah}&primera=1&ent=2&s_Listado=VerListado";
?>
"><img src='../imagenes/general_R.gif' alt='' border=0 width="110" height="25" ></a></td>
<td width="13%" valign="bottom" class="" ><a class="vinculos" href="../busqueda/busquedaHist.php?<?php
echo session_name() . "=" . session_id() . "&fechah={$fechah}&krd={$krd}";
?>
"><img src='../imagenes/historico.gif' alt='' border=0 width="110" height="25" ></a></td>
<!--<td width="13%" valign="bottom" class="" ><a class="vinculos" href="../busqueda/busquedaUsuActu.php?<?php
echo session_name() . "=" . session_id() . "&fechah={$fechah}&krd={$krd}";
?>
"><img src='../imagenes/usuarios.gif' alt='' border=0 width="110" height="25" ></a></td>-->
<td width="13%" valign="bottom" class="" ><a class="vinculos" href="../busqueda/busquedaExp.php?<?php
echo $phpsession;
?>
&krd=<?php
echo $krd;
?>
&<?php
echo "&fechah={$fechah}&primera=1&ent=2";
?>
"><img src='../imagenes/expediente.gif' alt='' border=0 width="110" height="25" ></a></td>
<td width="13%" valign="bottom" class="" ><a class="vinculos" href="../expediente/consultaTransferenciaExp.php?<?php
echo $phpsession;
?>
&krd=<?php
echo $krd;
?>
&<?php
echo "&fechah={$fechah}&primera=1&ent=2";
?>
"><img src='../imagenes/transferencia.gif' alt='' border=0 width="110" height="25" ></a></td>
<td width="13%" valign="bottom" class="" ><a class="vinculos" href="../busqueda/busquedaMetaDato.php?<?php
echo $phpsession;
?>
&krd=<?php
echo $krd;
?>
&<?php
echo "&fechah={$fechah}&primera=1&ent=2";
?>
"><img src='../imagenes/metadato.gif' alt='' border=0 width="110" height="25" ></a></td>
<td width="35%" valign="bottom" class="" > </td>
</tr>
</table>
</td>
</tr>
<?php
} else {
?>
<tr>
<td class="titulos4" colspan="13"><a name="Search">BÚSQUEDA VINCULACIÓN</td>
</tr>
<?php
}
?>
<tr>
<td><table width="100%" class='borde_tab' align='center' cellpadding='0' cellspacing='0'>
<td class="titulos5">Radicado</td>
<td class="listado5">
<input class="tex_area" type="text" name="s_RADI_NUME_RADI" maxlength="" value="<?php
echo tohtml($flds_RADI_NUME_RADI);
?>
" size="" id="cajarad">
</td>
</tr>
<tr>
<td class="titulos5">Identificación (T.I.,C.C.,Nit) *</td>
<td class="listado5">
<input class="tex_area" type="text" name="s_DOCTO" maxlength="" value="<?php
echo tohtml($flds_DOCTO);
?>
" size="" >
</td>
</tr>
<!--
/**
* B�squeda por expediente
* Fecha de modificaci�n: 30-Junio-2006
* Modificador: Supersolidaria
*/
-->
<tr>
<td class="titulos5">Expediente</td>
<td class="listado5">
<input class="tex_area" type="text" name="s_SGD_EXP_SUBEXPEDIENTE" maxlength="" value="<?php
echo tohtml($flds_SGD_EXP_SUBEXPEDIENTE);
?>
" size="" >
</td>
</tr>
<tr>
<td class="titulos5">Buscar por</td>
<td class="listado5">
<input class="tex_area" type="text" name="s_RADI_NOMB" maxlength="70" value="<?php
echo tohtml($flds_RADI_NOMB);
?>
" size="70" >
</td>
</tr>
<!--
*Busqueda por Metadato
*Modificador Grupo Iyunxi ltda.
-->
<tr>
<td class="titulos5">Metadato</td>
<td class="titulos5">
<input class="tex_area" type="text" name="s_METADATO" maxlength="70" value="<?php
echo tohtml($flds_METADATO);
?>
" size="70" >
</td>
</tr>
<tr>
<td colspan="2" class="FieldCaptionTD">
<table>
<tr >
<td class="titulos5" width="15%">
<?php
if ($s_Listado == "VerListado") {
$listadoView = " checked=checked";
}
?>
<INPUT type="checkbox" NAME="s_Listado" value="VerListado" <?php
echo $listadoView;
?>
onClick="delTodas();document.Search.elements['s_Listado'].checked=true;">
Ver en listado </td>
<td class="titulos5" width="15%">
<INPUT type="checkbox" NAME="s_ciudadano" value="CIU" onClick="delTodas();document.Search.elements['s_ciudadano'].checked=true;" <?php
echo $checkCIU;
?>
>Buscar ciudadanos</td>
</td>
<td class="titulos5" width="20%">
<INPUT type="checkbox" NAME="s_empresaESP" value="ESP" onClick="delTodas();document.Search.elements['s_empresaESP'].checked= true;" <?php
echo $checkESP;
?>
>
Buscar en entidad</td>
<td class="titulos5" width="20%">
<INPUT type="checkbox" NAME="s_oEmpresa" value="OEM" onClick="delTodas();document.Search.elements['s_oEmpresa'].checked=true;" <?php
echo $checkOEM;
?>
>
Buscar en empresas</td>
<td width="20%" class="titulos5">
<INPUT type="checkbox" NAME="s_FUNCIONARIO" value="FUN" onClick="delTodas();document.Search.elements['s_FUNCIONARIO'].checked=true;" <?php
echo $checkFUN;
?>
>
Buscar funcionarios</td>
</tr>
<td colspan="5" class="titulos5"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="titulos5"> Buscar en radicados
de </td>
<td class="listado5">
<select class="select" name="s_entrada" >
<?php
if (!$s_Listado) {
$s_Listado = "VerListado";
}
if ($flds_entrada == 0) {
$flds_entrada = "9999";
}
echo "<option value=\"9999\">" . $ss_TRAD_CODIDisplayValue . "</option>";
$lookup_s_entrada = db_fill_array("select SGD_TRAD_CODIGO, SGD_TRAD_DESCR from SGD_TRAD_TIPORAD order by 2");
if (is_array($lookup_s_entrada)) {
reset($lookup_s_entrada);
while (list($key, $value) = each($lookup_s_entrada)) {
if ($key == $flds_entrada) {
$option = "<option SELECTED value=\"{$key}\">{$value}</option>";
} else {
$option = "<option value=\"{$key}\">{$value}</option>";
}
echo $option;
}
}
?>
</select>
</td>
</tr>
<tr>
<td class="titulos5">Desde fecha (dd/mm/yyyy)</td>
<td class="listado5">
<select class="select" name="s_desde_dia">
<?php
for ($i = 1; $i <= 31; $i++) {
if ($i == $flds_desde_dia) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
<select class="select" name="s_desde_mes">
<?php
for ($i = 1; $i <= 12; $i++) {
if ($i == $flds_desde_mes) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
<select class="select" name="s_desde_ano">
<?php
$agnoactual = Date('Y');
for ($i = 1990; $i <= $agnoactual; $i++) {
if ($i == $flds_desde_ano) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
</td>
</tr>
<tr>
<td class="titulos5">Hasta fecha (dd/mm/yyyy)</td>
<td class="listado5">
<select class="select" name="s_hasta_dia">
<?php
for ($i = 1; $i <= 31; $i++) {
if ($i == $flds_hasta_dia) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
<select class="select" name="s_hasta_mes">
<?php
for ($i = 1; $i <= 12; $i++) {
if ($i == $flds_hasta_mes) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
<select class="select" name="s_hasta_ano">
<?php
for ($i = 1990; $i <= $agnoactual; $i++) {
if ($i == $flds_hasta_ano) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
</td>
</tr>
<td class="titulos5"><font class="FieldCaptionFONT">Tipo de documento</td>
<td class="listado5">
<select class="select" name="s_TDOC_CODI">
<?php
if ($flds_TDOC_CODI == 0) {
$flds_TDOC_CODI = "9999";
}
echo "<option value=\"9999\">" . $ss_TDOC_CODIDisplayValue . "</option>";
$lookup_s_TDOC_CODI = db_fill_array("select SGD_TPR_CODIGO, SGD_TPR_DESCRIP from SGD_TPR_TPDCUMENTO order by 2");
if (is_array($lookup_s_TDOC_CODI)) {
reset($lookup_s_TDOC_CODI);
while (list($key, $value) = each($lookup_s_TDOC_CODI)) {
if ($key == $flds_TDOC_CODI) {
$option = "<option SELECTED value=\"{$key}\">{$value}</option>";
} else {
$option = "<option value=\"{$key}\">{$value}</option>";
}
echo $option;
}
}
?>
</select>
</td>
</tr>
<tr>
<td class="titulos5">Dependencia actual</td>
<td class="listado5">
<select class="select" name="s_RADI_DEPE_ACTU">
<?php
$l = strlen($flds_RADI_DEPE_ACTU);
if ($l == 0) {
echo "<option value=\"\" SELECTED>" . $ss_RADI_DEPE_ACTUDisplayValue . "</option>";
} else {
echo "<option value=\"\">" . $ss_RADI_DEPE_ACTUDisplayValue . "</option>";
}
$lookup_s_RADI_DEPE_ACTU = db_fill_array("select DEPE_CODI, DEPE_NOMB from DEPENDENCIA where depe_estado=1 order by 2");
if (is_array($lookup_s_RADI_DEPE_ACTU)) {
reset($lookup_s_RADI_DEPE_ACTU);
while (list($key, $value) = each($lookup_s_RADI_DEPE_ACTU)) {
if ($l > 0 && $key == $flds_RADI_DEPE_ACTU) {
$option = "<option SELECTED value=\"{$key}\">{$value}</option>";
} else {
$option = "<option value=\"{$key}\">{$value}</option>";
}
echo $option;
}
}
?>
</select>
</td>
</tr>
<tr>
<td align="right" colspan="3" class="titulos5">
<input class="botones" type="button" value="Limpiar" onclick="limpiar();">
<input class="botones" type="submit" name=Busqueda value="Búsqueda">
</td>
</tr>
<table>
<td></td>
</table>
</form>
<?php
//-------------------------------
// Search Show end
//-------------------------------
//===============================
}
function Search_show()
{
global $styles;
global $sForm;
$sFormTitle = "Búsqueda";
$sActionFileName = "pedidos.php";
$ss_DEPE_CODIDisplayValue = "";
//-------------------------------
// Search Open Event begin
// Search Open Event end
//-------------------------------
//-------------------------------
// Set variables with search parameters
//-------------------------------
$flds_RADI_NUME_RADI = strip(get_param("s_RADI_NUME_RADI"));
$flds_USUA_LOGIN_ACTU = strip(get_param("s_USUA_LOGIN_ACTU"));
$flds_DEPE_CODI = strip(get_param("s_DEPE_CODI"));
//-------------------------------
// Search Show begin
//-------------------------------
//-------------------------------
// Search Show Event begin
// Search Show Event end
//-------------------------------
?>
<form method="GET" action="<?php
echo $sActionFileName;
?>
" name="Search">
<input type="hidden" name="FormName" value="Search"><input type="hidden" name="FormAction" value="search">
<table class="FormTABLE">
<tr>
<td class="FormHeaderTD" colspan="7"><a name="Search"><font class="FormHeaderFONT"><?php
echo $sFormTitle;
?>
</font></a></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Radicado</font></td>
<td class="DataTD"><input type="text" name="s_RADI_NUME_RADI" maxlength="" value="<?php
echo tohtml($flds_RADI_NUME_RADI);
?>
" size="" ></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Login Usuario</font></td>
<td class="DataTD"><input type="text" name="s_USUA_LOGIN_ACTU" maxlength="15" value="<?php
echo tohtml($flds_USUA_LOGIN_ACTU);
?>
" size="15" ></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Dependencia</font></td>
<td class="DataTD"><select name="s_DEPE_CODI">
<?php
echo "<option value=\"\">" . $ss_DEPE_CODIDisplayValue . "</option>";
$lookup_s_DEPE_CODI = db_fill_array("select DEPE_CODI, DEPE_NOMB from DEPENDENCIA order by 2");
if (is_array($lookup_s_DEPE_CODI)) {
reset($lookup_s_DEPE_CODI);
while (list($key, $value) = each($lookup_s_DEPE_CODI)) {
if ($key == $flds_DEPE_CODI) {
$option = "<option SELECTED value=\"{$key}\">{$value}";
} else {
$option = "<option value=\"{$key}\">{$value}";
}
echo $option;
}
}
?>
</select></td>
</tr>
<tr>
<td align="right" colspan="3"><input type="submit" value="Búsqueda"></td>
</tr>
</table>
</form>
<?php
//-------------------------------
// Search Show end
//-------------------------------
//-------------------------------
// Search Close Event begin
// Search Close Event end
//-------------------------------
//===============================
}
function Search_show()
{
global $db;
global $styles;
global $sForm;
$sFormTitle = "Búsqueda";
$sActionFileName = "busqueda.php";
$ss_desde_RADI_FECH_RADIDisplayValue = "";
$ss_hasta_RADI_FECH_RADIDisplayValue = "";
$ss_TDOC_CODIDisplayValue = "";
$ss_RADI_DEPE_ACTUDisplayValue = "";
//-------------------------------
// Search Open Event begin
// Search Open Event end
//-------------------------------
//-------------------------------
// Set variables with search parameters
//-------------------------------
$flds_RADI_NUME_RADI = strip(get_param("s_RADI_NUME_RADI"));
$flds_RADI_NOMB = strip(get_param("s_RADI_NOMB"));
$flds_solo_nomb = strip(get_param("s_solo_nomb"));
$flds_desde_dia = strip(get_param("s_desde_dia"));
$flds_hasta_dia = strip(get_param("s_hasta_dia"));
$flds_desde_mes = strip(get_param("s_desde_mes"));
$flds_hasta_mes = strip(get_param("s_hasta_mes"));
$flds_desde_ano = strip(get_param("s_desde_ano"));
$flds_hasta_ano = strip(get_param("s_hasta_ano"));
$flds_TDOC_CODI = strip(get_param("s_TDOC_CODI"));
$flds_RADI_DEPE_ACTU = strip(get_param("s_RADI_DEPE_ACTU"));
if (strlen($flds_desde_dia) && strlen($flds_hasta_dia) && strlen($flds_desde_mes) && strlen($flds_hasta_mes) && strlen($flds_desde_ano) && strlen($flds_hasta_ano)) {
$desdeTimestamp = mktime(0, 0, 0, $flds_desde_mes, $flds_desde_dia, $fld_desde_ano);
$hastaTimestamp = mktime(0, 0, 0, $flds_hasta_mes, $flds_hasta_dia, $fld_hasta_ano);
$flds_desde_dia = Date('d', $desdeTimestamp);
$flds_hasta_dia = Date('d', $hastaTimestamp);
$flds_desde_mes = Date('m', $desdeTimestamp);
$flds_hasta_mes = Date('m', $hastaTimestamp);
$flds_desde_ano = Date('Y', $desdeTimestamp);
$flds_hasta_ano = Date('Y', $hastaTimestamp);
} else {
$flds_desde_dia = Date('d') - 1;
$flds_hasta_dia = Date('d');
$flds_desde_mes = Date('m') - 1;
$flds_hasta_mes = Date('m');
$flds_desde_ano = 2003;
$flds_hasta_ano = Date('Y');
}
//-------------------------------
// Search Show begin
//-------------------------------
//-------------------------------
// Search Show Event begin
// Search Show Event end
//-------------------------------
?>
<form method="POST" action="<?php
echo $sActionFileName;
?>
?<?php
echo session_name() . "=" . session_id();
?>
&dependencia=<?php
echo $dependencia;
?>
" name="Search">
<input type="hidden" name="FormName" value="Search"><input type="hidden" name="FormAction" value="search">
<table class="FormTABLE">
<tr>
<td class="FormHeaderTD" colspan="13"><a name="Search"><font class="FormHeaderFONT"><?php
echo $sFormTitle;
?>
</font></a></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Radicado</font></td>
<td class="DataTD"><input class="DataFONT" type="text" name="s_RADI_NUME_RADI" maxlength="" value="<?php
echo tohtml($flds_RADI_NUME_RADI);
?>
" size="" ></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Texto
<INPUT type="radio" NAME="s_solo_nomb" value="Texto" <?php
if ($flds_solo_nomb == "Texto") {
echo "CHECKED";
}
?>
>
Solo Nombre
<INPUT type="radio" NAME="s_solo_nomb" value="Nombre" <?php
if ($flds_solo_nomb == "Nombre") {
echo "CHECKED";
}
?>
>
</font></td>
<td class="DataTD"><input class="DataFONT" type="text" name="s_RADI_NOMB" maxlength="70" value="<?php
echo tohtml($flds_RADI_NOMB);
?>
" size="70" ></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Desde Fecha (dd/mm/yyyy)</font></td>
<td class="DataTD"><select class="DataFONT" name="s_desde_dia">
<?php
for ($i = 1; $i <= 31; $i++) {
if ($i == $flds_desde_dia) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select><select class="DataFONT" name="s_desde_mes">
<?php
for ($i = 1; $i <= 12; $i++) {
if ($i == $flds_desde_mes) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select><select class="DataFONT" name="s_desde_ano">
<?php
$agnoactual = Date('Y');
for ($i = 2003; $i <= $agnoactual; $i++) {
if ($i == $flds_desde_ano) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Hasta Fecha (dd/mm/yyyy)</font></td>
<td class="DataTD"><select class="DataFONT" name="s_hasta_dia">
<?php
for ($i = 1; $i <= 31; $i++) {
if ($i == $flds_hasta_dia) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select><select class="DataFONT" name="s_hasta_mes">
<?php
for ($i = 1; $i <= 12; $i++) {
if ($i == $flds_hasta_mes) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select><select class="DataFONT" name="s_hasta_ano">
<?php
for ($i = 2003; $i <= $agnoactual; $i++) {
if ($i == $flds_hasta_ano) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Tipo de Documento</font></td>
<td class="DataTD"><select class="DataFONT" name="s_TDOC_CODI">
<?php
if ($flds_TDOC_CODI == 0) {
$flds_TDOC_CODI = "9999";
}
echo "<option value=\"9999\">" . $ss_TDOC_CODIDisplayValue . "</option>";
$lookup_s_TDOC_CODI = db_fill_array("select SGD_TPR_CODIGO, SGD_TPR_DESCRIP from SGD_TPR_TPDCUMENTO order by SGD_TPR_DESCRIP");
if (is_array($lookup_s_TDOC_CODI)) {
reset($lookup_s_TDOC_CODI);
while (list($key, $value) = each($lookup_s_TDOC_CODI)) {
if ($key == $flds_TDOC_CODI) {
$option = "<option SELECTED value=\"{$key}\">{$value}";
} else {
$option = "<option value=\"{$key}\">{$value}";
}
echo $option;
}
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Dependencia Actual</font></td>
<td class="DataTD"><select class="DataFONT" name="s_RADI_DEPE_ACTU">
<?php
echo "<option value=\"\">" . $ss_RADI_DEPE_ACTUDisplayValue . "</option>";
$lookup_s_RADI_DEPE_ACTU = db_fill_array("select DEPE_CODI, DEPE_NOMB from DEPENDENCIA order by 2");
if (is_array($lookup_s_RADI_DEPE_ACTU)) {
reset($lookup_s_RADI_DEPE_ACTU);
while (list($key, $value) = each($lookup_s_RADI_DEPE_ACTU)) {
if ($key == $flds_RADI_DEPE_ACTU) {
$option = "<option SELECTED value=\"{$key}\">{$value}";
} else {
$option = "<option value=\"{$key}\">{$value}";
}
echo $option;
}
}
?>
</select></td>
</tr>
<tr>
<td align="right" colspan="3"><input class="DataFONT" type="submit" value="Búsqueda"></td>
</tr>
</table>
</form>
<?php
//-------------------------------
// Search Show end
//-------------------------------
//-------------------------------
// Search Close Event begin
// Search Close Event end
//-------------------------------
//===============================
}
function Search_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;
// Valores
global $fechaFinal;
global $fechaInicial;
// Inicializaci�n de la fecha a partir de la cual se cancelan las solicitudes
if ($fechaInicial == "") {
$hastaXDias = strtotime("-30 day");
$fechaInicial = date("Y-m-d", $hastaXDias);
}
if ($fechaFinal == "") {
if ($opcionMenu == 3) {
$query = "select PARAM_VALOR,PARAM_NOMB from SGD_PARAMETRO where PARAM_NOMB='PRESTAMO_DIAS_CANC'";
$rs = $db->conn->query($query);
if (!$rs->EOF) {
$x = $rs->fields("PARAM_VALOR");
// d�as por defecto
$haceXDias = strtotime("-" . $x . " day");
$fechaFinal = date("Y-m-d", $haceXDias);
}
if ($pageAnt != $sFileName) {
// inicializaci�n del tiempo
$v_hora_limite = date("h");
$v_minuto_limite = date("i");
$v_meridiano = date("A");
}
} else {
$fechaFinal = date("Y-m-d");
}
}
// Set variables with search parameters
$flds_PRES_ESTADO = strip(get_param("s_PRES_ESTADO"));
$flds_RADI_NUME_RADI = strip(get_param("s_RADI_NUME_RADI"));
$flds_USUA_LOGIN = strip(get_param("s_USUA_LOGIN"));
if ($opcionMenu == 4) {
$flds_USUA_LOGIN = $krd;
}
// Inicializa el usuario para el caso en que el ingresa por la opci�n de SOLICITADOS
$flds_DEPE_NOMB = strip(get_param("s_DEPE_NOMB"));
$flds_USUA_NOMB = strip(get_param("s_USUA_NOMB"));
$flds_PRES_REQUERIMIENTO = strip(get_param("s_PRES_REQUERIMIENTO"));
if ($v_hora_limite == "") {
$v_hora_limite = strip(get_param("s_hora_limite"));
}
if ($v_minuto_limite == "") {
$v_minuto_limite = strip(get_param("s_minuto_limite"));
}
if ($v_meridiano == "") {
$v_meridiano = strip(get_param("s_meridiano"));
}
// Inicializa el titulo y la visibilidad de los criterios de b�squeda
include_once "inicializarForm.inc";
// Form display
?>
<form method="post" action="prestamo.php" name="busqueda">
<!-- de sesi�n !-->
<input type="hidden" value='<?php
echo $krd;
?>
' name="krd">
<input type="hidden" value=" " name="radicado">
<input type="hidden" value="" name="s_sql">
<!-- control de visualizaci�n !-->
<input type="hidden" name="opcionMenu" value="<?php
echo $opcionMenu;
?>
">
<input type="hidden" name="sFileName" value="">
<!-- orden de presentaci�n del resultado !-->
<input type="hidden" name="FormPedidos_Sorting" value="1">
<input type="hidden" name="FormPedidos_Sorted" value="0">
<input type="hidden" name="s_Direction" value=" DESC ">
<!-- control de paginaci�n !-->
<input type="hidden" name="FormPedidos_Page" value="1">
<input type="hidden" name="FormStarPage" value="1">
<input type="hidden" name="FormSiguiente" value="0">
<script>
//Inicializa el formulario
function limpiar() {
document.busqueda.action="menu_prestamo.php";
document.busqueda.submit();
}
//Presenta los usuarios segun la dependencia seleccionada
var codUsuaSel="<?php
echo $flds_USUA_NOMB;
?>
";
</script>
<!--Calendario-->
<script language="JavaScript" src="<?php
echo $ruta_raiz;
?>
/js/spiffyCal/spiffyCal_v2_1.js"></script>
<script language="javascript">
setRutaRaiz ('<?php
echo $ruta_raiz;
?>
');
</script>
<table border=0 cellpadding=0 cellspacing=2 class='borde_tab'>
<tr>
<td class="titulos4" colspan="2"><a name="Search"><?php
echo $sFormTitle[$opcionMenu];
?>
</a></td>
</tr>
<tr id="b0" style="display:<?php
echo $tipoBusqueda[$opcionMenu][0];
?>
">
<td class="titulos3"><p align="left">Radicado</p></td>
<td class="listado5"><input type="text" name="s_RADI_NUME_RADI" maxlength="15" value="<?php
echo $flds_RADI_NUME_RADI;
?>
" size="25" class="tex_area"></td>
</tr>
<tr id="b1" style="display:<?php
echo $tipoBusqueda[$opcionMenu][1];
?>
">
<td class="titulos3"><p align="left">Login de Usuario</p></td>
<td class="listado5"><input type="text" name="s_USUA_LOGIN" maxlength="15" value="<?php
echo $flds_USUA_LOGIN;
?>
" size="25" class="tex_area"></td>
</tr>
<tr id="b2" style="display:<?php
echo $tipoBusqueda[$opcionMenu][2];
?>
">
<td class="titulos3"><p align="left">Dependencia</p></td>
<td class="listado5"><select name="s_DEPE_NOMB" class="select" onChange=" document.busqueda.s_sql.value='no'; document.busqueda.submit(); ">
<option value="">- TODAS LAS DEPENDENCIAS -</option>
<?php
$lookup_s = db_fill_array("select DEPE_CODI,DEPE_NOMB from DEPENDENCIA order by 2");
if (is_array($lookup_s)) {
reset($lookup_s);
while (list($key, $value) = each($lookup_s)) {
if ($key == $flds_DEPE_NOMB) {
$option = "SELECTED";
} else {
$option = "";
}
echo "<option {$option} value=\"{$key}\">" . strtoupper($value) . "</option>";
}
}
?>
</select></td>
</tr>
<tr id="b3" style="display:<?php
echo $tipoBusqueda[$opcionMenu][3];
?>
">
<td class="titulos3"><p align="left">Usuario</p></td>
<td class="listado5"><select name="s_USUA_NOMB" class=select>
<option value="">- TODOS LOS USUARIOS -</option>
<?php
$validUsuaActiv = "";
if ($opcionMenu == 1) {
$validUsuaActiv = " USUA_ESTA='1' ";
} else {
$validUsuaActiv = " USUA_LOGIN IS NOT NULL ";
}
//Verifica que el usuario se encuentre activo para hacer el pr�stamo
if ($flds_DEPE_NOMB != "") {
$tmp = " AND DEPE_CODI= " . $flds_DEPE_NOMB;
} else {
$tmp = "";
}
$lookup_s = db_fill_array("select USUA_LOGIN,USUA_NOMB from USUARIO where " . $validUsuaActiv . $tmp);
if (is_array($lookup_s)) {
reset($lookup_s);
while (list($key, $value) = each($lookup_s)) {
if ($key == $flds_USUA_NOMB) {
$option = "SELECTED";
} else {
$option = "";
}
echo "<option {$option} value=\"{$key}\">" . strtoupper($value) . "</option>";
}
}
?>
</select></td>
</tr>
<tr id="b4" style="display:<?php
echo $tipoBusqueda[$opcionMenu][4];
?>
">
<td class="titulos3"><p align="left">Requerimiento</p></td>
<td class="listado5"><select name="s_PRES_REQUERIMIENTO" class=select>
<option value="">- TODOS LOS TIPOS -</option>
<?php
$lookup_s = db_fill_array("select PARAM_CODI,PARAM_VALOR from SGD_PARAMETRO where PARAM_NOMB='PRESTAMO_REQUERIMIENTO' order by PARAM_VALOR desc");
if (is_array($lookup_s)) {
reset($lookup_s);
while (list($key, $value) = each($lookup_s)) {
if ($key == $flds_PRES_REQUERIMIENTO) {
$option = "<option SELECTED value=\"{$key}\">" . strtoupper($value) . "</option>";
} else {
$option = "<option value=\"{$key}\">" . strtoupper($value) . "</option>";
}
echo $option;
}
}
?>
</select></td>
</tr>
<tr id="b5" style="display:<?php
echo $tipoBusqueda[$opcionMenu][5];
?>
">
<td class="titulos3"><p align="left">Estado</p></td>
<td class="listado5"><select name="s_PRES_ESTADO" class=select>
<option value="">- TODOS LOS ESTADOS -</option>
<?php
$lookup_s = db_fill_array("select PARAM_CODI,PARAM_VALOR from SGD_PARAMETRO where PARAM_NOMB='PRESTAMO_ESTADO' order by PARAM_VALOR");
if (is_array($lookup_s)) {
reset($lookup_s);
while (list($key, $value) = each($lookup_s)) {
if ($key == $flds_PRES_ESTADO) {
$option = "SELECTED";
} else {
$option = "";
}
echo "<option {$option} value=\"{$key}\">" . strtoupper($value) . "</option>";
}
}
if ($flds_PRES_ESTADO == -1) {
$option = "SELECTED";
} else {
$option = "";
}
echo "<option {$option} value=\"-1\">VENCIDO</option>";
?>
</select></td>
</tr>
<tr id="b6" style="display:<?php
echo $tipoBusqueda[$opcionMenu][6];
?>
">
<td class="titulos3"><p align="left">Fecha inicial<br> (aaaa-mm-dd)</p></td>
<td class="listado5"><script language="javascript">
var dateAvailable1 = new ctlSpiffyCalendarBox("dateAvailable1", "busqueda","fechaInicial","btnDate1","<?php
echo $fechaInicial;
?>
",scBTNMODE_CUSTOMBLUE);
dateAvailable1.writeControl();
dateAvailable1.dateFormat="yyyy-MM-dd";
</script></td>
</tr>
<tr id="b7" style="display:<?php
echo $tipoBusqueda[$opcionMenu][7];
?>
">
<td class="titulos3"><p align="left">Fecha final<br> (aaaa-mm-dd)</p></td>
<td class="listado5"><script language="javascript">
var dateAvailable2 = new ctlSpiffyCalendarBox("dateAvailable2", "busqueda","fechaFinal","btnDate2","<?php
echo $fechaFinal;
?>
",scBTNMODE_CUSTOMBLUE);
dateAvailable2.writeControl();
dateAvailable2.dateFormat="yyyy-MM-dd";
</script>
</td>
</tr>
<tr id="b8" style="display:<?php
echo $tipoBusqueda[$opcionMenu][8];
?>
">
<td class="titulos3"><p align="left">Hora límite<br> (hh:mm m)</p></td>
<td class="listado5"><select name="s_hora_limite" class=select>
<?php
for ($i = 1; $i <= 12; $i++) {
if ($i <= 9) {
$h = "0" . $i;
} else {
$h = "" . $i;
}
$seleccion = "";
if ($h == $v_hora_limite) {
$seleccion = "SELECTED";
}
?>
<option <?php
echo $seleccion;
?>
value="<?php
echo $h;
?>
"><?php
echo $h;
?>
</option>
<?php
}
?>
</select> :
<select name="s_minuto_limite" class=select>
<?php
for ($i = 0; $i <= 59; $i++) {
if ($i <= 9) {
$h = "0" . $i;
} else {
$h = "" . $i;
}
$seleccion = "";
if ($h == $v_minuto_limite) {
$seleccion = "SELECTED";
}
?>
<option <?php
echo $seleccion;
?>
value="<?php
echo $h;
?>
"> <?php
echo $h;
?>
</option>
<?php
}
?>
</select> :
<select name="s_meridiano" class=select>
<?php
if ($v_meridiano == "AM") {
?>
<option value="AM" selected>am</option>
<option value="PM">pm</option>
<?php
} else {
?>
<option value="AM">am</option>
<option value="PM" selected>pm</option>
<?php
}
?>
</select>
</tr>
<tr>
<td class="titulos3" colspan="2">
<?php
if ($opcionMenu == 0 || $opcionMenu == 4) {
?>
<input type="reset" class='botones' value="Limpiar" onClick="javascript: limpiar();">
<input type="submit" class='botones' value="Generar">
<?php
} else {
?>
<input type="submit" class='botones' value="Buscar">
<?php
}
?>
</td>
</tr>
</table>
</form>
<?php
}
function Search_show()
{
global $db;
global $styles;
global $db2;
global $db3;
global $sForm;
$sFormTitle = "Búsqueda Clásica";
$sActionFileName = "busquedaPiloto.php";
$ss_desde_RADI_FECH_RADIDisplayValue = "";
$ss_hasta_RADI_FECH_RADIDisplayValue = "";
$ss_TDOC_CODIDisplayValue = "Todos los Tipos";
$ss_TRAD_CODIDisplayValue = "Todos los Tipos (-1,-2,-3,-5, . . .)";
$ss_RADI_DEPE_ACTUDisplayValue = "Todas las Dependencias";
//Con esta variable se determina si la busqueda corresponde a vinculacion documentos
$indiVinculo = $_GET["indiVinculo"];
$verrad = $_GET["verrad"];
$carpeAnt = $_GET["carpeAnt"];
$nomcarpeta = $_GET["nomcarpeta"];
$krd = $_SESSION["krd"];
$dependencia = $_SESSION["dependencia"];
$usua_doc = $_SESSION["usua_doc"];
$codusuario = $_SESSION["codusuario"];
$nivelus = $_SESSION["nivelus"];
if ($_REQUEST["flds_TDOC_CODI"]) {
$flds_TDOC_CODI = $_REQUEST["flds_TDOC_CODI"];
}
foreach ($_GET as $key => $valor) {
${$key} = $valor;
}
foreach ($_POST as $key => $valor) {
${$key} = $valor;
}
if ($indiVinculo == 1) {
$sFormTitle = $sFormTitle . ' Anexo al Vuelo ';
}
if ($indiVinculo == 2) {
$sFormTitle = $sFormTitle . ' Incluir Expediente ';
}
$flds_DOCTO = $_GET["s_DOCTO"];
$flds_RADI_NOMB = $_GET["s_RADI_NOMB"];
$flds_ciudadano = $_GET["s_ciudadano"];
$flds_empresaESP = $_GET["s_empresaESP"];
$flds_oEmpresa = $_GET["s_oEmpresa"];
$flds_entrada = $_GET["s_entrada"];
$flds_salida = $_GET["s_salida"];
$flds_solo_nomb = $_GET["s_solo_nomb"];
$Busqueda = $_GET["Busqueda"];
$flds_desde_dia = $_GET["s_desde_dia"];
$flds_hasta_dia = $_GET["s_hasta_dia"];
$flds_desde_mes = $_GET["s_desde_mes"];
$flds_hasta_mes = $_GET["s_hasta_mes"];
$flds_desde_ano = $_GET["s_desde_ano"];
$flds_hasta_ano = $_GET["s_hasta_ano"];
$flds_TDOC_CODI = $_GET["s_TDOC_CODI"];
$s_Listado = $_GET["s_Listado"];
$flds_FUNCIONARIO = $_GET["s_FUNCIONARIO"];
$flds_RADI_NUME_RADI = $_GET["s_RADI_NUME_RADI"];
$flds_RADI_DEPE_ACTU = $_GET["s_RADI_DEPE_ACTU"];
if ($flds_ciudadano) {
$checkCIU = "checked";
}
if ($flds_empresaESP) {
$checkESP = "checked";
}
if ($flds_oEmpresa) {
$checkOEM = "checked";
}
if ($flds_FUNCIONARIO) {
$checkFUN = "checked";
}
/**
* Busqueda por expediente
* Fecha de modificacion: 30-Junio-2006
* Modificador: Supersolidaria
*/
$flds_SGD_EXP_SUBEXPEDIENTE = $_GET["s_SGD_EXP_SUBEXPEDIENTE"];
if (strlen($flds_desde_dia) && strlen($flds_hasta_dia) && strlen($flds_desde_mes) && strlen($flds_hasta_mes) && strlen($flds_desde_ano) && strlen($flds_hasta_ano)) {
$desdeTimestamp = mktime(0, 0, 0, $flds_desde_mes, $flds_desde_dia, $flds_desde_ano);
$hastaTimestamp = mktime(0, 0, 0, $flds_hasta_mes, $flds_hasta_dia, $flds_hasta_ano);
$flds_desde_dia = Date('d', $desdeTimestamp);
$flds_hasta_dia = Date('d', $hastaTimestamp);
$flds_desde_mes = Date('m', $desdeTimestamp);
$flds_hasta_mes = Date('m', $hastaTimestamp);
$flds_desde_ano = Date('Y', $desdeTimestamp);
$flds_hasta_ano = Date('Y', $hastaTimestamp);
} else {
// DESDE HACE UN MES HASTA HOY
$desdeTimestamp = mktime(0, 0, 0, Date('m') - 1, Date('d'), Date('Y'));
$flds_desde_dia = Date('d', $desdeTimestamp);
$flds_hasta_dia = Date('d');
$flds_desde_mes = Date('m', $desdeTimestamp);
$flds_hasta_mes = Date('m');
$flds_desde_ano = Date('Y', $desdeTimestamp);
$flds_hasta_ano = Date('Y');
}
$varibles_busqueda = session_name() . '=' . session_id() . '&indiVinculo=' . $indiVinculo . '&verrad=' . $verrad . '&carpeAnt=' . $carpeAnt . '&nomcarpeta=' . $nomcarpeta;
?>
<form method="get" action="busquedaPiloto.php?<?php
echo $varibles_busqueda;
?>
" name="Search">
<input type='hidden' name='<?php
echo session_name();
?>
' value='<?php
echo session_id();
?>
'>
<input type="hidden" name="FormName" value="Search"><input type="hidden" name="FormAction" value="search">
<table border=0 cellpadding=0 cellspacing=2 class='borde_tab'>
<tr>
<td class="titulos4" colspan="13"><a name="Search">
<?php
echo $sFormTitle;
?>
</td>
</tr>
<tr>
<td class="titulos5">Radicado</td>
<td class="listado5">
<input class="tex_area" type="text" name="s_RADI_NUME_RADI" maxlength="" value="<?php
echo tohtml($flds_RADI_NUME_RADI);
?>
" size="" id="cajarad">
</td>
</tr>
<tr>
<td class="titulos5">Identificación (T.I.,C.C.,Nit) *</td>
<td class="listado5">
<input class="tex_area" type="text" name="s_DOCTO" maxlength="" value="<?php
echo tohtml($flds_DOCTO);
?>
" size="" >
</td>
</tr>
<!--
/**
* Busqueda por expediente
* Fecha de modificaci�n: 30-Junio-2006
* Modificador: Supersolidaria
*/
-->
<tr>
<td class="titulos5">Expediente</td>
<td class="listado5">
<input class="tex_area" type="text" name="s_SGD_EXP_SUBEXPEDIENTE" maxlength="" value="<?php
echo tohtml($flds_SGD_EXP_SUBEXPEDIENTE);
?>
" size="" >
</td>
</tr>
<tr>
<td class="titulos5">
<input type="radio" NAME="s_solo_nomb" value="All" CHECKED
<?php
if ($flds_solo_nomb == "All") {
echo "CHECKED";
}
?>
>
Buscar Por<br>
<!--<INPUT type="radio" NAME="s_solo_nomb" value="Any"
<?php
if ($flds_solo_nomb == "Any") {
echo "CHECKED";
}
?>
>Cualquier Palabra (o)<br>-->
</td>
<td class="listado5">
<input class="tex_area" type="text" name="s_RADI_NOMB" maxlength="70" value="<?php
echo tohtml($flds_RADI_NOMB);
?>
" size="70" >
</td>
</tr>
<tr>
<td colspan="2" class="FieldCaptionTD">
<table>
<tr >
<td class="titulos5" width="15%">
<?php
if ($s_Listado == "VerListado") {
$listadoView = " checked=checked";
}
?>
<input type="checkbox" NAME="s_Listado" value="VerListado" <?php
echo $listadoView;
?>
onClick="delTodas();document.Search.elements['s_Listado'].checked=true;">
Ver en Listado
</td>
<td class="titulos5" width="15%">
<input type="checkbox" NAME="s_ciudadano" value="CIU" onClick="delTodas();document.Search.elements['s_ciudadano'].checked=true;" <?php
echo $checkCIU;
?>
>
Buscar Ciudadanos
</td>
</td>
<td class="titulos5" width="20%">
<INPUT type="checkbox" NAME="s_empresaESP" value="ESP" onClick="delTodas();document.Search.elements['s_empresaESP'].checked= true;" <?php
echo $checkESP;
?>
>
Buscar en Entidad</td>
<td class="titulos5" width="20%">
<INPUT type="checkbox" NAME="s_oEmpresa" value="OEM" onClick="delTodas();document.Search.elements['s_oEmpresa'].checked=true;" <?php
echo $checkOEM;
?>
>
Buscar en Empresas</td>
<td width="20%" class="titulos5">
<INPUT type="checkbox" NAME="s_FUNCIONARIO" value="FUN" onClick="delTodas();document.Search.elements['s_FUNCIONARIO'].checked=true;" <?php
echo $checkFUN;
?>
>
Buscar Funcionarios</td>
</tr>
<td colspan="5" class="titulos5"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="titulos5"> Buscar en Radicados de</td>
<td class="listado5">
<select class="select" name="s_entrada">
<?php
if (!$s_Listado) {
$s_Listado = "VerListado";
}
if ($flds_entrada == 0) {
$flds_entrada = "9999";
}
echo "<option value=\"9999\">" . $ss_TRAD_CODIDisplayValue . "</option>";
$lookup_s_entrada = db_fill_array("select SGD_TRAD_CODIGO, SGD_TRAD_DESCR from SGD_TRAD_TIPORAD order by 2");
if (is_array($lookup_s_entrada)) {
reset($lookup_s_entrada);
while (list($key, $value) = each($lookup_s_entrada)) {
if ($key == $flds_entrada) {
$option = "<option SELECTED value=\"{$key}\">{$value}</option>";
} else {
$option = "<option value=\"{$key}\">{$value}</option>";
}
echo $option;
}
}
?>
</select>
</td>
</tr>
<tr>
<td class="titulos5">Desde Fecha (dd/mm/yyyy)</td>
<td class="listado5">
<select class="select" name="s_desde_dia">
<?php
for ($i = 1; $i <= 31; $i++) {
if ($i == $flds_desde_dia) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
<select class="select" name="s_desde_mes">
<?php
for ($i = 1; $i <= 12; $i++) {
if ($i == $flds_desde_mes) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
<select class="select" name="s_desde_ano">
<?php
$agnoactual = Date('Y');
for ($i = 1990; $i <= $agnoactual; $i++) {
if ($i == $flds_desde_ano) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
</td>
</tr>
<tr>
<td class="titulos5">Hasta Fecha (dd/mm/yyyy)</td>
<td class="listado5">
<select class="select" name="s_hasta_dia">
<?php
for ($i = 1; $i <= 31; $i++) {
if ($i == $flds_hasta_dia) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
<select class="select" name="s_hasta_mes">
<?php
for ($i = 1; $i <= 12; $i++) {
if ($i == $flds_hasta_mes) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
<select class="select" name="s_hasta_ano">
<?php
for ($i = 1990; $i <= $agnoactual; $i++) {
if ($i == $flds_hasta_ano) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select>
</td>
</tr>
<tr>
<td class="titulos5"><font class="FieldCaptionFONT">Tipo de Documento</td>
<td class="listado5">
<select class="select" name="s_TDOC_CODI">
<?php
if ($flds_TDOC_CODI == 0) {
$flds_TDOC_CODI = "9999";
}
echo "<option value=\"9999\">" . $ss_TDOC_CODIDisplayValue . "</option>";
$lookup_s_TDOC_CODI = db_fill_array("select SGD_TPR_CODIGO, SGD_TPR_DESCRIP from SGD_TPR_TPDCUMENTO order by 2");
if (is_array($lookup_s_TDOC_CODI)) {
reset($lookup_s_TDOC_CODI);
while (list($key, $value) = each($lookup_s_TDOC_CODI)) {
if ($key == $flds_TDOC_CODI) {
$option = "<option SELECTED value=\"{$key}\">{$value}</option>";
} else {
$option = "<option value=\"{$key}\">{$value}</option>";
}
echo $option;
}
}
?>
</select>
</td>
</tr>
<tr>
<td class="titulos5">Dependencia Actual</td>
<td class="listado5">
<select class="select" name="s_RADI_DEPE_ACTU">
<?php
$l = strlen($flds_RADI_DEPE_ACTU);
if ($l == 0) {
echo "<option value=\"\" SELECTED>" . $ss_RADI_DEPE_ACTUDisplayValue . "</option>";
} else {
echo "<option value=\"\">" . $ss_RADI_DEPE_ACTUDisplayValue . "</option>";
}
$lookup_s_RADI_DEPE_ACTU = db_fill_array("select DEPE_CODI, DEPE_NOMB from DEPENDENCIA where depe_estado=1 order by 2");
if (is_array($lookup_s_RADI_DEPE_ACTU)) {
reset($lookup_s_RADI_DEPE_ACTU);
while (list($key, $value) = each($lookup_s_RADI_DEPE_ACTU)) {
if ($l > 0 && $key == $flds_RADI_DEPE_ACTU) {
$option = "<option SELECTED value=\"{$key}\">{$value}</option>";
} else {
$option = "<option value=\"{$key}\">{$value}</option>";
}
echo $option;
}
}
?>
</select>
</td>
</tr>
<tr>
<td align="left" colspan="3" class="titulos5">
<input class="botones" type="button" value="Limpiar" onclick="limpiar();">
<input class="botones" type="submit" name=Busqueda value="Búsqueda">
</td>
</tr>
</table>
</form>
<?php
}
function PRESTAMO_show()
{
global $db;
global $sFileName;
global $krd;
//usuario actual
global $dependencia;
//dependencia del usuario actual
global $sPRESTAMOErr;
$sFormTitle = "Reservar";
$fldradicado = get_param("radicado");
$historicos = 999;
if ($sPRESTAMOErr == "") {
// SQL que verifica la existencia de anexos para el radicado
$sSQL1 = "select \n R.RADI_DESC_ANEX as ANEXO, \n\t\t R.RADI_DEPE_ACTU as DEPE_RADICADO, \n\t\t\t\t U.USUA_LOGIN as USUARIO_RADICADO \n \t\t\tfrom \n\t\t\t RADICADO R, \n\t\t\t\t USUARIO U \n\t\t\t where \n\t\t\t R.RADI_NUME_RADI={$fldradicado} and \n\t\t\t U.USUA_CODI=R.RADI_USUA_ACTU and \n\t\t\t\t U.DEPE_CODI=R.RADI_DEPE_ACTU";
$db->conn->SetFetchMode(ADODB_FETCH_ASSOC);
$rs1 = $db->conn->query($sSQL1);
// Inicializaci�n de la variable que indica si el usuario puede o no hacer solicitudes
if (!$rs1->EOF) {
$fldANEXO = $rs1->fields["ANEXO"];
//campo que indica la existencia de anexos para el radicado
$fldUSUARIO_RADICADO = $rs1->fields["USUARIO_RADICADO"];
$fldDEPE_RADICADO = $rs1->fields["DEPE_RADICADO"];
if ($fldDEPE_RADICADO != $historicos && $fldUSUARIO_RADICADO != $krd) {
$sPRESTAMOErr = " solo puede ser solicitado y prestado al usuario {$fldUSUARIO_RADICADO}";
}
}
// SQL con los tipos de requerimientos que se pueden realizar
$sSQL = "select \n P.PRES_REQUERIMIENTO as REQUERIMIENTO\n from \n\t\t\t PRESTAMO P\n where \n\t\t\t P.RADI_NUME_RADI={$fldradicado} and \n P.PRES_ESTADO in (1,2,5) ";
$db->conn->SetFetchMode(ADODB_FETCH_ASSOC);
$rs = $db->query($sSQL);
//$db->conn->SetFetchMode(ADODB_FETCH_NUM);
$iCounter = 0;
while ($rs && !$rs->EOF) {
$i[$iCounter] = $rs->fields["REQUERIMIENTO"];
$iCounter++;
$rs->MoveNext();
}
$reqPrestados = 0;
for ($j = 0; $j < $iCounter; $j++) {
$reqPrestados = $reqPrestados + $i[$j];
}
$sqlReq = "";
if ($iCounter == 0) {
if (strlen(trim($fldANEXO)) == 0) {
$sqlReq = " =1 ";
} else {
$sqlReq = " in (1,2,3) ";
}
} else {
if ($iCounter == 1 && $reqPrestados < 3 && $reqPrestados > 0) {
if (strlen(trim($fldANEXO)) != 0) {
$sqlReq = " =" . (3 - $reqPrestados);
}
}
}
if (strlen($sqlReq) != 0) {
$sqlReq = "select PARAM_CODI,PARAM_VALOR from SGD_PARAMETRO where PARAM_NOMB='PRESTAMO_REQUERIMIENTO' and PARAM_CODI" . $sqlReq . " order by PARAM_VALOR desc";
// Show form field
?>
<script>
/*Adecua el formulario para que la p�gina regrese a la anterior*/
function regresar() {
document.Prestamo.FormAction.value="cancelar";
document.Prestamo.submit();
}
</script>
<form method="POST" action="<?php
echo $sFileName;
?>
" name="Prestamo">
<input type="hidden" value="<?php
echo $krd;
?>
" name="krd">
<input type="hidden" value="insert" name="FormAction">
<input type="hidden" value="<?php
echo $dependencia;
?>
" name="dependencia">
<input type="hidden" name="radicado" value="<?php
echo tohtml($fldradicado);
?>
">
<?php
// Usuario que no puede solicitar
if ($sPRESTAMOErr != "") {
$lookup_s = db_fill_array($sqlReq);
$s = "";
if (is_array($lookup_s)) {
reset($lookup_s);
while (list($key, $value) = each($lookup_s)) {
$s = ucfirst(strtolower($value));
if ($key == 3) {
$sPRESTAMOErr = " solo pueden ser solicitados y prestados al usuario {$fldUSUARIO_RADICADO}<br><br>";
break;
}
}
}
$sPRESTAMOErr = "El " . $s . $sPRESTAMOErr;
?>
<p align="center"><font class="titulosError2"><?php
echo $sPRESTAMOErr;
?>
</font><br>
<input type="submit" class="botones" value="Regresar" onClick="javascript: regresar();"></p>
</form>
<?php
} else {
?>
<table class="borde_tab" align="center">
<tr>
<td class="titulos2" colspan="2"><center><?php
echo $sFormTitle;
?>
</center></td>
</tr>
<tr>
<td class='titulos2' width="100">Radicado</td>
<td class='listado2' width="150"><?php
echo $fldradicado;
?>
</td>
</tr>
<tr>
<td class='titulos2'>Login</td>
<td class='listado2'><?php
echo $krd;
?>
</td>
</tr>
<tr>
<td class='titulos2'>Dependencia</td>
<td class='listado2'><?php
echo $dependencia;
?>
</td>
</tr>
<tr>
<td class='titulos2'>Fecha Pedido</td>
<td class='listado2'><?php
echo Date("d-m-Y");
?>
</td>
</tr>
<tr>
<td class='titulos2'>Accion</td>
<td class='listado2'>Solicitar</td>
</tr>
<tr>
<td class='titulos2'>Requiere</td>
<td class="listado5">
<select name="s_PRES_REQUERIMIENTO" class=select>
<?php
$lookup_s = db_fill_array($sqlReq);
if (is_array($lookup_s)) {
reset($lookup_s);
while (list($key, $value) = each($lookup_s)) {
echo "<option value=\"{$key}\">" . ucfirst(strtolower($value)) . "</option>";
}
}
?>
</select></td>
</tr>
<tr>
<td class='titulos2'></td>
<td class="listado5"><input type="submit" class="botones" value="Solicitar">
<input type="submit" class="botones" value="Regresar" onClick="javascript: regresar();"></td>
</tr>
</table>
</form> <?php
}
}
}
}
function Search_show()
{
global $db;
global $styles;
global $sForm;
$sFormTitle = "Búsqueda";
$sActionFileName = "reporte.php";
$ss_desde_RADI_FECH_RADIDisplayValue = "";
$ss_hora_inicialDisplayValue = "";
$ss_hora_finalDisplayValue = "";
//-------------------------------
// Search Open Event begin
$cadena = "";
for ($hace = 60; $hace >= 0; $hace--) {
$timestamp = mktime(0, 0, 0, date("m"), date("d") - $hace, date("Y"));
$mes = Date('d/m/Y', $timestamp);
$valormes = Date("M d Y", $timestamp);
$cadena .= $mes . ";" . $valormes . ";";
}
$cadena2 = "";
for ($hace = 0; $hace <= 24; $hace++) {
$cadena2 .= $hace . ";" . $hace . ";";
}
$cadena3 = "";
for ($hace = 0; $hace <= 24; $hace++) {
$cadena3 .= $hace . ";" . $hace;
if ($hace != 24) {
$cadena3 .= ";";
}
}
// Search Open Event end
//-------------------------------
//-------------------------------
// Set variables with search parameters
//-------------------------------
$flds_RADI_DEPE_RADI = strip(get_param("s_RADI_DEPE_RADI"));
$flds_desde_RADI_FECH_RADI = strip(get_param("s_desde_RADI_FECH_RADI"));
$flds_hora_inicial = strip(get_param("s_hora_inicial"));
$flds_hora_final = strip(get_param("s_hora_final"));
//-------------------------------
// Search Show begin
//-------------------------------
//-------------------------------
// Search Show Event begin
// Search Show Event end
//-------------------------------
?>
<form method="GET" action="<?php
echo $sActionFileName;
?>
" name="Search">
<input type="hidden" name="FormName" value="Search"><input type="hidden" name="FormAction" value="search">
<table class="FormTABLE" width="722">
<tr>
<td class="FormHeaderTD" colspan="7"><a name="Search"><font class="FormHeaderFONT"><?php
echo $sFormTitle;
?>
Busqueda</font></a></td>
</tr>
<tr>
<td class="FieldCaptionTD" width="154" align="right" height="25"><font class="FieldCaptionFONT">DEPENDENCIA</font></td>
<td class="DataTD" width="594" height="25">
<select name="s_RADI_DEPE_RADI">
<?php
$lookup_s_RADI_DEPE_RADI = db_fill_array("select UBIC_DEPE_RADI, UBIC_DEPE_RADI from UBICACION_FISICA order by 2");
if (is_array($lookup_s_RADI_DEPE_RADI)) {
reset($lookup_s_RADI_DEPE_RADI);
while (list($key, $value) = each($lookup_s_RADI_DEPE_RADI)) {
if ($key == $flds_RADI_DEPE_RADI) {
$option = "<option SELECTED value=\"{$key}\">{$value}";
} else {
$option = "<option value=\"{$key}\">{$value}";
}
echo $option;
}
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD" width="154" align="right" height="25"><font class="FieldCaptionFONT">FECHA</font></td>
<td class="DataTD" width="594" height="25">
<select name="s_desde_RADI_FECH_RADI">
<?php
echo "<option value=\"\">" . $ss_desde_RADI_FECH_RADIDisplayValue . "</option>";
$LOV = split(";", "{$cadena};");
if (sizeof($LOV) % 2 != 0) {
$array_length = sizeof($LOV) - 1;
} else {
$array_length = sizeof($LOV);
}
for ($i = 0; $i < $array_length; $i = $i + 2) {
if ($LOV[$i] == $flds_desde_RADI_FECH_RADI) {
$option = "<option SELECTED value=\"" . $LOV[$i] . "\">" . $LOV[$i + 1];
} else {
$option = "<option value=\"" . $LOV[$i] . "\">" . $LOV[$i + 1];
}
echo $option;
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD" width="154" align="right" height="25"><font class="FieldCaptionFONT">HORA
INICIO</font></td>
<td class="DataTD" width="594" height="25">
<select name="s_hora_inicial">
<?php
echo "<option value=\"\">" . $ss_hora_inicialDisplayValue . "</option>";
$LOV = split(";", "{$cadena3};");
if (sizeof($LOV) % 2 != 0) {
$array_length = sizeof($LOV) - 1;
} else {
$array_length = sizeof($LOV);
}
for ($i = 0; $i < $array_length; $i = $i + 2) {
if ($LOV[$i] == $flds_hora_inicial || $ss_hora_inicialDisplayValue == "" && $i == 0 && $flds_hora_inicial == "") {
$option = "<option SELECTED value=\"" . $LOV[$i] . "\">" . $LOV[$i + 1] . "</option>";
} else {
$option = "<option value=\"" . $LOV[$i] . "\">" . $LOV[$i + 1] . "</option>";
}
echo $option;
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD" width="154" align="right" height="25"><font class="FieldCaptionFONT">HORA
FINAL</font></td>
<td class="DataTD" width="594" height="25">
<select name="s_hora_final">
<?php
echo "<option value=\"\">" . $ss_hora_finalDisplayValue . "</option>";
$LOV = split(";", "{$cadena2};");
if (sizeof($LOV) % 2 != 0) {
$array_length = sizeof($LOV) - 1;
} else {
$array_length = sizeof($LOV);
}
for ($i = 0; $i < $array_length; $i = $i + 2) {
if ($LOV[$i] == $flds_hora_final) {
$option = "<option SELECTED value=\"" . $LOV[$i] . "\">" . $LOV[$i + 1];
} else {
$option = "<option value=\"" . $LOV[$i] . "\">" . $LOV[$i + 1];
}
echo $option;
}
?>
</select></td>
</tr>
<tr align="center">
<td colspan="3">
<input type="submit" value="BUSCAR">
</td>
</tr>
</table>
</form>
<?php
//-------------------------------
// Search Show end
//-------------------------------
//-------------------------------
// Search Close Event begin
// Search Close Event end
//-------------------------------
//===============================
}
function Search_show()
{
global $db;
global $styles;
global $sForm;
$sFormTitle = "Busquedas";
$sActionFileName = "busquedas.php";
$ss_DEPE_CODIDisplayValue = "";
$ss_PRES_ESTADODisplayValue = "";
$ss_PRES_REQUERIMIENTODisplayValue = "";
//-------------------------------
// Search Open Event begin
// Search Open Event end
//-------------------------------
//-------------------------------
// Set variables with search parameters
//-------------------------------
$flds_RADI_NUME_RADI = strip(get_param("s_RADI_NUME_RADI"));
$flds_USUA_LOGIN_ACTU = strip(get_param("s_USUA_LOGIN_ACTU"));
$flds_DEPE_CODI = strip(get_param("s_DEPE_CODI"));
$flds_PRES_ESTADO = strip(get_param("s_PRES_ESTADO"));
$flds_PRES_REQUERIMIENTO = strip(get_param("s_PRES_REQUERIMIENTO"));
$flds_desde_dia = strip(get_param("s_desde_dia"));
$flds_hasta_dia = strip(get_param("s_hasta_dia"));
$flds_desde_mes = strip(get_param("s_desde_mes"));
$flds_hasta_mes = strip(get_param("s_hasta_mes"));
$flds_desde_ano = strip(get_param("s_desde_ano"));
$flds_hasta_ano = strip(get_param("s_hasta_ano"));
if (strlen($flds_desde_dia) && strlen($flds_hasta_dia) && strlen($flds_desde_mes) && strlen($flds_hasta_mes) && strlen($flds_desde_ano) && strlen($flds_hasta_ano)) {
$desdeTimestamp = mktime(0, 0, 0, $flds_desde_mes, $flds_desde_dia, $fld_desde_ano);
$hastaTimestamp = mktime(0, 0, 0, $flds_hasta_mes, $flds_hasta_dia, $flds_hasta_ano);
$flds_desde_dia = Date('d', $desdeTimestamp);
$flds_hasta_dia = Date('d', $hastaTimestamp);
$flds_desde_mes = Date('m', $desdeTimestamp);
$flds_hasta_mes = Date('m', $hastaTimestamp);
$flds_desde_ano = Date('Y', $desdeTimestamp);
$flds_hasta_ano = Date('Y', $hastaTimestamp);
} else {
$flds_desde_dia = Date('d');
$flds_hasta_dia = Date('d');
$flds_desde_mes = Date('m') - 1;
$flds_hasta_mes = Date('m');
$flds_desde_ano = 2003;
$flds_hasta_ano = Date('Y');
}
$flds_USUA_LOGIN_PRES = strip(get_param("s_USUA_LOGIN_PRES"));
//-------------------------------
// Search Show begin
//-------------------------------
//-------------------------------
// Search Show Event begin
// Search Show Event end
//-------------------------------
?>
<form method="GET" action="<?php
echo $sActionFileName;
?>
" name="Search">
<input type="hidden" name="FormName" value="Search"><input type="hidden" name="FormAction" value="search">
<table class="FormTABLE">
<tr>
<td class="FormHeaderTD" colspan="11"><a name="Search"><font class="FormHeaderFONT"><?php
echo $sFormTitle;
?>
</font></a></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Radicado</font></td>
<td class="DataTD"><input type="text" name="s_RADI_NUME_RADI" maxlength="" value="<?php
echo tohtml($flds_RADI_NUME_RADI);
?>
" size="" ></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Usuario</font></td>
<td class="DataTD"><input type="text" name="s_USUA_LOGIN_ACTU" maxlength="15" value="<?php
echo tohtml($flds_USUA_LOGIN_ACTU);
?>
" size="15" ></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Dependencia</font></td>
<td class="DataTD"><select name="s_DEPE_CODI">
<?php
echo "<option value=\"\">" . $ss_DEPE_CODIDisplayValue . "</option>";
$lookup_s_DEPE_CODI = db_fill_array("select DEPE_CODI, DEPE_NOMB from DEPENDENCIA order by 2");
if (is_array($lookup_s_DEPE_CODI)) {
reset($lookup_s_DEPE_CODI);
while (list($key, $value) = each($lookup_s_DEPE_CODI)) {
if ($key == $flds_DEPE_CODI) {
$option = "<option SELECTED value=\"{$key}\">{$value}";
} else {
$option = "<option value=\"{$key}\">{$value}";
}
echo $option;
}
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Estado</font></td>
<td class="DataTD"><select name="s_PRES_ESTADO">
<?php
echo "<option value=\"\">" . $ss_PRES_ESTADODisplayValue . "</option>";
$LOV = split(";", "1;Solicitado;2;Prestado;3;Devuelto;4;Cancelado;5;Prestamo Indefinido");
if (sizeof($LOV) % 2 != 0) {
$array_length = sizeof($LOV) - 1;
} else {
$array_length = sizeof($LOV);
}
for ($i = 0; $i < $array_length; $i = $i + 2) {
if ($LOV[$i] == $flds_PRES_ESTADO) {
$option = "<option SELECTED value=\"" . $LOV[$i] . "\">" . $LOV[$i + 1];
} else {
$option = "<option value=\"" . $LOV[$i] . "\">" . $LOV[$i + 1];
}
echo $option;
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Requerimiento</font></td>
<td class="DataTD"><select name="s_PRES_REQUERIMIENTO">
<?php
echo "<option value=\"\">" . $ss_PRES_REQUERIMIENTODisplayValue . "</option>";
$LOV = split(";", "1;Documento;2;Anexo");
if (sizeof($LOV) % 2 != 0) {
$array_length = sizeof($LOV) - 1;
} else {
$array_length = sizeof($LOV);
}
for ($i = 0; $i < $array_length; $i = $i + 2) {
if ($LOV[$i] == $flds_PRES_REQUERIMIENTO) {
$option = "<option SELECTED value=\"" . $LOV[$i] . "\">" . $LOV[$i + 1];
} else {
$option = "<option value=\"" . $LOV[$i] . "\">" . $LOV[$i + 1];
}
echo $option;
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Desde Fecha (dd/mm/yyyy)</font></td>
<td class="DataTD"><select class="DataFONT" name="s_desde_dia">
<?php
for ($i = 1; $i <= 31; $i++) {
if ($i == $flds_desde_dia) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select><select class="DataFONT" name="s_desde_mes">
<?php
for ($i = 1; $i <= 12; $i++) {
if ($i == $flds_desde_mes) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select><select class="DataFONT" name="s_desde_ano">
<?php
$agnoactual = Date('Y');
for ($i = 2003; $i <= $agnoactual; $i++) {
if ($i == $flds_desde_ano) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Hasta Fecha (dd/mm/yyyy)</font></td>
<td class="DataTD"><select class="DataFONT" name="s_hasta_dia">
<?php
for ($i = 1; $i <= 31; $i++) {
if ($i == $flds_hasta_dia) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select><select class="DataFONT" name="s_hasta_mes">
<?php
for ($i = 1; $i <= 12; $i++) {
if ($i == $flds_hasta_mes) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select><select class="DataFONT" name="s_hasta_ano">
<?php
for ($i = 2003; $i <= $agnoactual; $i++) {
if ($i == $flds_hasta_ano) {
$option = "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
} else {
$option = "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo $option;
}
?>
</select></td>
</tr>
<tr>
<td class="FieldCaptionTD"><font class="FieldCaptionFONT">Funcionario Archivo</font></td>
<td class="DataTD"><input type="text" name="s_USUA_LOGIN_PRES" maxlength="15" value="<?php
echo tohtml($flds_USUA_LOGIN_PRES);
?>
" size="15" ></td>
</tr>
<tr>
<td align="right" colspan="3"><input type="submit" value="Búsqueda"></td>
</tr>
</table>
</form>
<?php
//-------------------------------
// Search Show end
//-------------------------------
//-------------------------------
// Search Close Event begin
// Search Close Event end
//-------------------------------
//===============================
}
