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; }