include "src/classes/Users.class.php";
include "src/classes/UnidadeCons.class.php";
redirectByPermission(0);
// SETAR PERMISSÃO DA PÁGINA
$tpl = new Template('html_libs/ucResumo.html');
if (isset($_GET['chave'])) {
$chave = mysql_real_escape_string($_GET['chave']);
if (strlen($chave) == 40) {
$queryVerif = mysql_query("SELECT id FROM daee_uddc WHERE SHA1(id) = '" . $_GET['chave'] . "'");
if (mysql_num_rows($queryVerif) == 1) {
$id = mysql_fetch_array($queryVerif)['id'];
$uc = new UnidadeConsumidora($id);
/*********************************
MOSTRAR INFORMAÇÕES DO RELATÓRIO
*********************************/
$hasConsumo = $uc->hasConsumo();
if ($hasConsumo) {
$tpl->block('SHOW_HEADER_CONS');
}
$distinct_sql = "SELECT DISTINCT(ano_ref) FROM daee_notas WHERE uc = {$id} ORDER BY ano_ref ASC";
$distinct_query = mysql_query($distinct_sql);
$exArray;
$exArrayIndex = 0;
while ($ano = mysql_fetch_array($distinct_query)) {
$tpl->ANO = $ano = $ano['ano_ref'];
$exercicio = $uc->getExercicioMensal($ano);
$tpl->MESESPG = $meses_count = count($exercicio);
$totCons = $totPago = 0;
foreach ($exercicio as $mes) {
if ($hasConsumo) {
$totCons += $mes['consumo'];
