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 }