* @link http://www.orfeolibre.org
* @version SVN: $Id$
* @since
*/
/*---------------------------------------------------------+
| INCLUDES |
+---------------------------------------------------------*/
/*---------------------------------------------------------+
| DEFINICIONES |
+---------------------------------------------------------*/
/*---------------------------------------------------------+
| MAIN |
+---------------------------------------------------------*/
/*********************************************************************************
* Filename: devolucionMasivo.php
* Generated with CodeCharge 2.0.5
* PHP 4.0 build 11/30/2001
*********************************************************************************/
//-------------------------------
// devolucionMasivo CustomIncludes begin
session_start();
include ("./common.php");
include ("./encabezado.php");
//$db->conn->debug=true;
// devolucionMasivo CustomIncludes end
//-------------------------------
//===============================
// Save Page and File Name available into variables
//-------------------------------
$sFileName = "devolucionMasivo.php";
//===============================
//===============================
// devolucionMasivo PageSecurity begin
check_security();
// devolucionMasivo PageSecurity end
//===============================
//===============================
// devolucionMasivo Open Event begin
// devolucionMasivo Open Event end
//===============================
//===============================
// devolucionMasivo OpenAnyPage Event start
// devolucionMasivo OpenAnyPage Event end
//===============================
//===============================
//Save the name of the form and type of action into the variables
//-------------------------------
$sAction = get_param("FormAction");
$sForm = get_param("FormName");
//===============================
// devolucionMasivo Show begin
//===============================
// Perform the form's action
//-------------------------------
// Initialize error variables
//-------------------------------
$sPRESTAMOErr = "";
$login_err="";
//-------------------------------
// Select the FormAction
//-------------------------------
switch ($sForm) {
case "DEVOLVER":
DMR_PRESTAMO_action($sAction);
break;
}
//===============================
//===============================
// Display page
//===============================
// HTML Page layout
//-------------------------------
?>
";
//-------------------------------
// PRESTAMO Check Event begin
// PRESTAMO Check Event end
//-------------------------------
if(strlen($sPRESTAMOErr)) return;
}
//-------------------------------
//-------------------------------
// Create SQL statement
//-------------------------------
switch(strtolower($sAction))
{
case "update":
//-------------------------------
// PRESTAMO Update Event begin
$fldPRES_FECH_DEVO = "to_date('" .$fldPRES_FECH_DEVO . "','dd/mm/yyyy HH:MI')";
// PRESTAMO Update Event end
//-------------------------------
$sSQL = "update PRESTAMO set " .
"PRES_FECH_DEVO=" . $fldPRES_FECH_DEVO .
",PRES_DESC=" . tosql($fldPRES_DESC, "Text") .
",PRES_ESTADO=" . tosql($fldPRES_ESTADO, "Number");
$sSQL .= " where " . $sWhere;
break;
}
//-------------------------------
//-------------------------------
// PRESTAMO BeforeExecute Event begin
// PRESTAMO BeforeExecute Event end
//-------------------------------
//-------------------------------
// Execute SQL statement
//-------------------------------
if(strlen($sPRESTAMOErr)) return;
if(strlen($login_err)) return;
if($bExecSQL && $fldPRES_ESTADO != 2)
$db->query($sSQL);
}
$mensaje="Operación completada con éxito";
include_once($sActionFileName);
//-------------------------------
// PRESTAMO Action end
//-------------------------------
}
//===============================
// Display Record Form
//-------------------------------
function DMR_DM_PRESTAMO_show()
{
global $db;
global $sAction;
global $sForm;
global $sFileName;
global $sPRESTAMOErr;
global $styles;
global $login_err;
$fldPRES_ID = "";
$fldRADI_NUME_RADI = "";
$fldUSUA_LOGIN_ACTU = "";
$fldDEPE_CODI = "";
$fldPRES_FECH_PEDI = "";
$fldPRES_REQUERIMIENTO = "";
$fldUSUA_LOGIN_PRES = "";
$fldPRES_FECH_PRES = "";
$fldPRES_DESC = "";
$fldPRES_ESTADO = "";
//-------------------------------
// PRESTAMO Show begin
//-------------------------------
$sFormTitle = "Devolución Masiva";
$sWhere = "";
$bPK = true;
$fldPRES_FECH_DEVO = Date('d/m/Y h:i');
?>