EVOLUTION-MANAGER

Edit File: rpt_solicitudes_por_fechas.php

<?php
//=====================================================================================================
//=====>	INICIO_H
	include_once("../core/go.login.inc.php");
	include_once("../core/core.error.inc.php");
	include_once("../core/core.html.inc.php");
	include_once("../core/core.init.inc.php");
	$theFile					= __FILE__;
	$permiso					= getSIPAKALPermissions($theFile);
	if($permiso === false){		header ("location:../404.php?i=999");	}
	$_SESSION["current_file"]	= addslashes( $theFile );
//<=====	FIN_H
	$iduser = $_SESSION["log_id"];
//=====================================================================================================
include_once( "../core/entidad.datos.php");
include_once( "../core/core.deprecated.inc.php");
include_once( "../core/core.fechas.inc.php");
include_once( "../libs/sql.inc.php");
include_once( "../core/core.config.inc.php");

$oficial = elusuario($iduser);

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Reporte de Monto de Solicitudes en un Rango de Fechas</title>
</head>
<link href="../css/reporte.css" rel="stylesheet" type="text/css">
<body onLoad="javascript:window.print();">

<?php
echo getRawHeader();
/**
 * Filtrar si hay Fecha
 */
$fecha_inicial = $_GET["on"];
$fecha_final = $_GET["off"];
$si_es_por_fecha = "";
if ($fecha_inicial && $fecha_final){
	$si_es_por_fecha = " WHERE fecha_solicitud>='$fecha_inicial' AND fecha_solicitud<='$fecha_final' ";
}
$sql = "select convenio, count(solicitud) AS 'numero', FORMAT(SUM(monto_solicitado),2) AS 'total_colocado' FROM solicitudes $si_es_por_fecha AND monto_solicitado>=0.99 GROUP BY convenio";
echo "<p class='midtitle'>Reporte de Monto de Solicitudes en un Rango de Fechas <br />Del $fecha_inicial Al $fecha_final</p>";
sqltabla($sql,"","fieldnames");
echo getRawFooter();
?>
</body>
</html>