function GetImage($file, $width = -1, $maxWidth = -1, $maxHeight = -1) {
header("Expires: Mon, 20 Dec 1998 01:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
ini_set("memory_limit", "-1");
$ext = StringToUpper(substr($file, strrpos($file, "."), 20));
if (($ext == ".JPG") or ($ext == ".JPEG"))
GetImageJpg($file, $width, $maxWidth, $maxHeight);
if ($ext == ".GIF")
GetImageGif($file, $width, $maxWidth, $maxHeight);
if ($ext == ".PNG")
GetImagePng($file, $width, $maxWidth, $maxHeight);
}
public function setSql($value) {
$this->sql = StringToUpper($value);
$this->getRecordCount();
}
function GetWindowsLoginName($upper = false) {
$cred = explode("\\", $_SERVER["REMOTE_USER"]);
if (count($cred) == 1)
array_unshift($cred, "No hay información disponible sobre el dominio donde Ud. está logueado.");
list($domain, $user) = $cred;
if ($upper)
return StringToUpper($user);
else
return $user;
}
$params[":vigenciadesde"] = $_REQUEST["fechaVigenciaDesde"];
$where2.= " AND co_vigenciadesde >= TO_DATE(:vigenciadesde, 'dd/mm/yyyy')";
}
if ($_REQUEST["sector"] == "pr") {
$filtros.= "<tr><td>- Sector: <b>Privado</b></td></tr>";
$where2.= " AND em_sector = 4";
}
if ($_REQUEST["sector"] == "pu") {
$filtros.= "<tr><td>- Sector: <b>Público</b></td></tr>";
$where2.= " AND em_sector IN (1, 2, 3, 5)";
}
if ($_REQUEST["holding"] != "") {
$filtros.= "<tr><td>- Holding: <b>".$_REQUEST["holding"]."</b></td></tr>";
$params[":holding"] = StringToUpper($_REQUEST["holding"])."%";
$where2.= " AND ge_descripcion LIKE :holding";
}
if (isset($_REQUEST["carteraMorosa"])) {
$filtros.= "<tr><td>- Cartera Morosa: <b>Sí.</b></td></tr>";
$where2.= " AND art.deuda.get_deudatotalconsolidada(co_contrato) > 0";
}
if (isset($_REQUEST["solicitudTraspaso"])) {
$filtros.= "<tr><td>- Con Solicitud de Traspaso (últimos 3 meses): <b>Sí.</b></td></tr>";
$where2.= " AND EXISTS (SELECT 1
FROM ate_traspasoegreso
WHERE te_codigo = '001'
AND te_fechabaja IS NULL
AND te_fecha > SYSDATE - 90
<?
$params = array(":id" => $_REQUEST["id"]);
$sql =
"SELECT bn_html, bn_nombre
FROM rrhh.rbn_beneficios
WHERE bn_fechabaja IS NULL
AND bn_idmenu = :id";
$stmt = DBExecSql($conn, $sql, $params);
if (DBGetRecordCount($stmt) == 0) {
echo '<h2 id="divError">Este beneficio no está disponible.</h2>';
return;
}
$row = DBGetQuery($stmt);
?>
<div style="margin-right:24px;"><?php
echo preg_replace("/[\n|\r|\n\r]/i", "", $row["BN_HTML"]->load());
?>
</div>
<script type="text/javascript">
document.getElementById('divTituloSeccion').innerText = 'BENEFICIOS - <?php
echo StringToUpper($row["BN_NOMBRE"]);
?>
';
</script>
