public function resultadoExtratoPautaReuniaoCnicAction()
{
header("Content-Type: text/html; charset=ISO-8859-1");
$this->_helper->layout->disableLayout();
$post = Zend_Registry::get('post');
$arrBusca = array("Mecanismo = ?" => 1);
if (!empty($post->banco)) {
$arrBusca["c.Banco = ?"] = $post->banco;
}
if (!empty($post->nrReuniao)) {
$arrBusca["pa.NumeroReuniao = ?"] = $post->nrReuniao;
}
if (!empty($post->orgao)) {
$arrBusca["o.Codigo = ?"] = $post->orgao;
}
if (!empty($post->tipoParecer)) {
$arrBusca["pa.TipoParecer = ?"] = $post->tipoParecer;
}
if (!empty($post->area)) {
$arrBusca["a.Codigo = ?"] = $post->area;
}
if (!empty($post->situacao)) {
$arrBusca["s.Codigo = ?"] = $post->situacao;
}
//xd($arrBusca);
foreach ($_POST["visaoAgente"] as $campo) {
$arrCampos = explode("_", $campo);
if ($arrCampos[0] == "cmpsOrd") {
if (substr($arrCampos[1], 0, 1) != "#") {
$campos[] = $arrCampos[1];
}
}
}
//xd($campos);
// foreach($_POST["visaoAgente"] as $campo){
// $arrCampos = explode("_", $campo);
// if($arrCampos[0] == "cmpsOrd"){
// if(substr($arrCampos[1], 0, 1) != "#"){
// $campos[] = $arrCampos[1];
// }
// }
// }
//$campos = implode(", ", $campos);
//xd($campos);
//xd($_POST);
$tbl = new Projetos();
if ($post->tipo == 'xls' || $post->tipo == 'pdf') {
//buscando os registros no banco de dados
$tamanho = -1;
$inicio = -1;
$pag = 0;
$totalPag = 0;
$total = 0;
$fim = 0;
$rs = $tbl->buscarProjetosPautaReuniao($arrBusca, array(new Zend_Db_expr("Area ASC")), $tamanho, $inicio);
$this->_forward('preparar-xls-pdf', null, null, array('dados' => $rs, 'view' => 'operacional/preparar-xls-pdf-extrato-pauta-reuniao-cnic.phtml', 'tipo' => $post->tipo));
} else {
$pag = 1;
//$get = Zend_Registry::get('get');
if (isset($post->pag)) {
$pag = $post->pag;
}
if (isset($post->tamPag)) {
$this->intTamPag = $post->tamPag;
}
$inicio = $pag > 1 ? ($pag - 1) * $this->intTamPag : 0;
$fim = $inicio + $this->intTamPag;
$total = $tbl->pegaTotalProjetosPautaReuniao($arrBusca);
$total = $total["total"];
//xd($total);
$totalPag = (int) ($total % $this->intTamPag == 0 ? $total / $this->intTamPag : $total / $this->intTamPag + 1);
$tamanho = $fim > $total ? $total - $inicio : $this->intTamPag;
if ($fim > $total) {
$fim = $total;
}
$rs = $tbl->buscarProjetosPautaReuniao($arrBusca, array(new Zend_Db_expr("Area ASC")), $tamanho, $inicio);
//xd($rs);
}
$this->view->projetos = $rs;
$this->view->pag = $pag;
$this->view->total = $total;
$this->view->inicio = $inicio + 1;
$this->view->fim = $fim;
$this->view->totalPag = $totalPag;
$this->view->parametrosBusca = $_POST;
}
