* @link http://www.orfeolibre.org * @version SVN: $Id$ * @since */ /*---------------------------------------------------------+ | INCLUDES | +---------------------------------------------------------*/ /*---------------------------------------------------------+ | DEFINICIONES | +---------------------------------------------------------*/ /*---------------------------------------------------------+ | MAIN | +---------------------------------------------------------*/ /********************************************************************************* * Filename: busquedas.php * Generated with CodeCharge 2.0.5 * PHP 4.0 build 11/30/2001 *********************************************************************************/ //------------------------------- // busquedas CustomIncludes begin session_start(); include_once ("./common.php"); include_once ("./encabezado.php"); //$db->conn->debug=true; // busquedas CustomIncludes end //------------------------------- //=============================== // Save Page and File Name available into variables //------------------------------- $sFileName = "busquedas.php"; //=============================== //=============================== // busquedas PageSecurity begin check_security(); // busquedas PageSecurity end //=============================== //=============================== // busquedas Open Event begin // busquedas Open Event end //=============================== //=============================== // busquedas OpenAnyPage Event start // busquedas OpenAnyPage Event end //=============================== //=============================== //Save the name of the form and type of action into the variables //------------------------------- $sAction = get_param("FormAction"); $sForm = get_param("FormName"); //=============================== // busquedas Show begin //=============================== // Display page //=============================== // HTML Page layout //------------------------------- ?>
Fecha Inicial (dia/mes/año)
Fecha final (dia/mes/año)
Funcionario Archivo
=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; //tosql($ps_RADI_NUME_RADI, "Number"); 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 )) { ?>
Radicado Usuario Dependencia Fecha de Solicitud Requerimiento Fecha de Préstamo Descripción Fecha de Devolución Usuario Archivo/C.Docum Estado
No hay Registros
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 //------------------------------- ?>                     $iCounter"); //------------------------------- // Grid. The insert link and record navigator. //------------------------------- ?> 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 .= "" . $iPageCount . " "; $iDisplayPages++; } $sPages .= "" . $iPage . " "; $iDisplayPages++; $iPageCount = $iPage + 1; while ($iDisplayPages < $iNumberOfPages && $iStartPage + $iDisplayPages < $iHasPages) { $sPages .= "" . $iPageCount . " "; $iDisplayPages++; $iPageCount++; } if ($iPage == 1) { ?> Primero Anterior Primero Anterior EOF ) { ?> Siguiente Ultimo Siguiente Ultimo