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'];