* @link http://www.orfeolibre.org * @version SVN: $Id$ * @since */ /*---------------------------------------------------------+ | INCLUDES | +---------------------------------------------------------*/ /*---------------------------------------------------------+ | DEFINICIONES | +---------------------------------------------------------*/ /*---------------------------------------------------------+ | MAIN | +---------------------------------------------------------*/ /********************************************************************************* * Filename: devolucion.php * Generated with CodeCharge 2.0.5 * PHP 4.0 build 11/30/2001 *********************************************************************************/ //------------------------------- // devolucion CustomIncludes begin session_start(); include_once ("./common.php"); include_once ("./encabezado.php"); // devolucion CustomIncludes end //------------------------------- //$db->conn->debug=true; //=============================== // Save Page and File Name available into variables //------------------------------- $sFileName = "devolucion.php"; //=============================== //=============================== // devolucion PageSecurity begin check_security(); // devolucion PageSecurity end //=============================== //=============================== // devolucion Open Event begin // devolucion Open Event end //=============================== //=============================== // devolucion OpenAnyPage Event start // devolucion OpenAnyPage Event end //=============================== //=============================== //Save the name of the form and type of action into the variables //------------------------------- $sAction = get_param("FormAction"); $sForm = get_param("FormName"); //=============================== // devolucion Show begin //=============================== // Display page //=============================== // HTML Page layout //------------------------------- ?>
Radicado
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) { ?>
Radicado Solicitó Dependencia Prestó Descripción Solicitado el Prestado el Vence Requerimiento Renovar
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_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 //------------------------------- ?>                   Renovar  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 .= "" . $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 Siguiente Ultimo Siguiente Ultimo