public function xlsListagemAction()
{
$reuniao = new Reuniao();
$raberta = $reuniao->buscarReuniaoAberta();
$this->view->reuniao = $raberta;
$order = array();
//==== parametro de ordenacao ======//
if ($this->_request->getParam("ordem")) {
$ordem = $this->_request->getParam("ordem");
if ($ordem == "ASC") {
$novaOrdem = "DESC";
} else {
$novaOrdem = "ASC";
}
} else {
$ordem = "ASC";
$novaOrdem = "ASC";
}
//==== campo de ordenacao ======//
if ($this->_request->getParam("campo")) {
$campo = $this->_request->getParam("campo");
$order = array($campo . " " . $ordem);
$ordenacao = "&campo=" . $campo . "&ordem=" . $ordem;
} else {
$campo = null;
$order = array(1);
//idPronac
$ordenacao = null;
}
$where = array();
$where["b.idNrReuniao = ?"] = $raberta->idNrReuniao;
$where["h.stAtivo = ?"] = 1;
$Projetos = new Projetos();
$busca = $Projetos->projetosCnicOpinioes($where, $order);
$html = "<table cellspacing='0' cellpadding='2' border='1' align='center' width='99%'>\n <tr>\n <th align='left'>PRONAC</th>\n <th>Nome do Projeto</th>\n <th>Proponente</th>\n <th>UF</th>\n <th>Município</th>\n <th>Enquadramento</th>\n <th>Área</th>\n <th>Segmento</th>\n <th>Avaliação</th>\n <th>Vl.Solicitado</th>\n <th>Vl.Sugerido</th>\n </tr>";
$TotalSol = 0;
$TotalSug = 0;
foreach ($busca as $d) {
if (!empty($d->vlSolicitado)) {
$vl1 = @number_format($d->vlSolicitado, 2, ",", ".");
} else {
$vl1 = '';
}
if (!empty($d->vlSugerido)) {
$vl2 = @number_format($d->vlSugerido, 2, ",", ".");
} else {
$vl2 = '';
}
$html .= " <tr>\n <td>" . $d->Pronac . "</td>\n <td>" . $d->NomeProjeto . "</td>\n <td>" . $d->Proponente . "</td>\n <td>" . $d->UF . "</td>\n <td>" . $d->Cidade . "</td>\n <td>" . $d->descEnquadramento . "</td>\n <td>" . $d->dsArea . "</td>\n <td>" . $d->dsSegmento . "</td>\n <td>" . $d->descAvaliacao . "</td>\n <td>" . $vl1 . "</td>\n <td>" . $vl2 . "</td>\n </tr>";
$TotalSol = $TotalSol + $d->vlSolicitado;
$TotalSug = $TotalSug + $d->vlSugerido;
}
$html .= "<tr>\n <th colspan='9'>TOTAL</th>\n <th nowrap>" . @number_format($TotalSol, 2, ',', '.') . "</th>\n <th nowrap>" . @number_format($TotalSug, 2, ',', '.') . "</th>\n </tr>\n ";
$html .= "</table>";
$this->view->html = $html;
$this->_helper->layout->disableLayout();
// Desabilita o Zend Layout
}
