public function exibealteradosAction()
{
//ACTION QUE EXIBE OS DADOS DO USUARIO
$user = Zend_Registry::get('zend_auth_user');
if ($user == null or @$user->contrato == null) {
exit;
}
$pegaUser = $this->getRequest();
$idBeneficiario = $pegaUser->getParam('id');
$this->verificaId($pegaUser->getParam('id'));
$beneficiario = new Application_Model_DbTable_Beneficiario();
$telefone = new Application_Model_DbTable_Telefone();
$endereco = new Application_Model_DbTable_Endereco();
$email = new Application_Model_DbTable_Email();
$modulo = new Application_Model_DbTable_Modulo();
$local = new Application_Model_DbTable_LocalAtendimento();
$lotacao = new Application_Model_DbTable_Lotacao();
$registro = new Application_Model_DbTable_Registro();
$this->view->dados = $this->carregaBenef($pegaUser->getParam('id'));
$this->view->id = $pegaUser->getParam('id');
/* BENEFICIARIO */
$select = $beneficiario->select();
$select->setIntegrityCheck(false);
$select->from(array('b' => 'beneficiario'), array('*'))->where('b.idBeneficiario = ?', $idBeneficiario);
$this->view->dados = $beneficiario->fetchAll($select)->current();
$this->verificaContrato($this->view->dados, $user->contrato);
/* DEPENDENTES */
$select = $beneficiario->select();
$select->setIntegrityCheck(false);
$select->from(array('b' => 'beneficiario'), array('*'))->where('b.contrato = ?', $user->contrato)->where('b.familia = ?', $this->view->dados['Familia'])->where('b.idbeneficiario != ?', $idBeneficiario);
$this->view->dadosDependente = $beneficiario->fetchAll($select);
/* REGISTRO */
$select = $registro->select();
$select->setIntegrityCheck(false);
$select->where('idBeneficiario = ?', $idBeneficiario);
$this->view->dadosRegistro = $registro->fetchAll($select)->current();
/* MODULO */
$select = $modulo->select();
$select->setIntegrityCheck(false);
$select->from(array('m' => 'modulo'), array('Codigo', 'Nome', 'InicioVigencia'))->where('m.idBeneficiario = ?', $idBeneficiario)->where('m.fimVigencia is null');
$this->view->dadosModulo = $modulo->fetchAll($select)->current();
/* LOCAL */
$select = $local->select();
$select->setIntegrityCheck(false);
$select->from(array('m' => 'localatendimento'), array('Codigo', 'Nome', 'InicioVigencia'))->where('m.idBeneficiario = ?', $idBeneficiario)->where('m.fimVigencia is null');
$this->view->dadosLocal = $local->fetchAll($select)->current();
/* LOTACAO */
$select = $lotacao->select();
$select->setIntegrityCheck(false);
$select->from(array('m' => 'lotacao'), array('Codigo', 'Nome', 'InicioVigencia'))->where('m.idBeneficiario = ?', $idBeneficiario)->where('m.fimVigencia is null');
$this->view->dadosLotacao = $lotacao->fetchAll($select)->current();
/* ENDERECO */
$select = $endereco->select();
$select->setIntegrityCheck(false);
$select->from(array('e' => 'endereco'), array('*'))->where('e.idBeneficiario = ?', $idBeneficiario)->where('e.FimVigencia is null');
$this->view->dadosEndereco = $endereco->fetchAll($select);
/* EMAIL */
$select = $email->select();
$select->setIntegrityCheck(false);
$select->from(array('e' => 'email'), array('*'))->where('e.idBeneficiario = ?', $idBeneficiario);
$this->view->dadosEmail = $email->fetchAll($select)->current();
/* TELEFONE */
$select = $telefone->select();
$select->setIntegrityCheck(false);
$select->from(array('t' => 'telefone'), array('*'))->where('t.idBeneficiario = ?', $idBeneficiario);
$this->view->dadosTelefone = $telefone->fetchAll($select)->current();
$this->view->rdp = $this->vRdp;
}
