public function testacpfAction() { $user = Zend_Registry::get('zend_auth_user'); if ($user == null or @$user->contrato == null) { exit; } $request = $this->getRequest(); $beneficiario = new Application_Model_DbTable_Beneficiario(); $pessoa = new Application_Model_DbTable_Unipessoa(); $cnp = $this->removePonto($request->getParam('Cnp')); $contrato = $user->contrato; /*NOSSO BANCO*/ $select = $beneficiario->select(); $select->where('Cnp = ?', $cnp)->where('Contrato = ?', $contrato); $resultado = $beneficiario->fetchAll($select); /*BANCO UNIMED*/ $select = $pessoa->select(); $select->setIntegrityCheck(false); $select->from(array('p' => 'Pessoa'), array())->join(array('b' => 'Beneficiario'), 'b.pessoa = p.autoid', array('*'))->where('Cnp = ?', $cnp)->where('Contrato = ?', $contrato); $resultadoUni = $pessoa->fetchAll($select); if ($resultado->count() > 0 or $resultadoUni->count() > 0) { } else { echo '1'; } exit; }
public function indexAction() { $user = Zend_Registry::get('zend_auth_user'); $noticia = new Application_Model_DbTable_Noticias(); $beneficiario = new Application_Model_DbTable_Beneficiario(); $select = $noticia->select(); $select->order('idNoticias desc')->limit(15); $this->view->teste = $noticia->fetchall($select); $dbCardio = Zend_Registry::get('dbcardio'); $select_tit = $dbCardio->select(); $select_tit->from(array('b' => 'Beneficiario'), array('b.AutoId'))->where('b.contrato = ? and b.RDP=0', $user->contrato)->where('not exists( select 1 from suspensaovinculo sv where sv.vinculorescindido=1 and sv.Beneficiario=b.AutoId)'); $tab_tit = $dbCardio->fetchAll($select_tit); $tab_tit = count($tab_tit); $this->view->tab_tit = $tab_tit; $select_dep = $dbCardio->select(); $select_dep->from(array('b' => 'Beneficiario'), array('b.AutoId'))->where('b.contrato = ? and b.RDP<>0', $user->contrato)->where('not exists( select 1 from suspensaovinculo sv where sv.vinculorescindido=1 and sv.Beneficiario=b.AutoId)'); $tab_dep = $dbCardio->fetchAll($select_dep); $tab_dep = count($tab_dep); $this->view->tab_dep = $tab_dep; $select_inat = $dbCardio->select(); $select_inat->from(array('b' => 'Beneficiario'), array('b.AutoId'))->where('b.contrato = ?', $user->contrato)->where('exists( select 1 from suspensaovinculo sv where sv.vinculorescindido=1 and sv.Beneficiario=b.AutoId)'); $tab_inat = $dbCardio->fetchAll($select_inat); $tab_inat = count($tab_inat); $this->view->tab_inat = $tab_inat; $select = $beneficiario->select(); $select->where('contrato = ?', $user->contrato)->where('status is not null')->order('idBeneficiario desc')->limit(15); $this->view->ultima = $beneficiario->fetchAll($select); /* $unicontrato = new Application_Model_DbTable_Unicontrato(); $reg = $unicontrato->find(6); $reg=$reg->current(); $this->view->contrato =$reg ; $this->view->benefs = $reg->findDependentRowset('Application_Model_DbTable_Unibeneficiario'); */ }
public function dependentesAction() { $beneficiarioCardio = new Application_Model_DbTable_Unibeneficiario(); $beneficiario = new Application_Model_DbTable_Beneficiario(); $endereco = new Application_Model_DbTable_Endereco(); $lotacao = new Application_Model_DbTable_Lotacao(); $telefone = new Application_Model_DbTable_Telefone(); $user = Zend_Registry::get('zend_auth_user'); if ($user == null or @$user->contrato == null) { exit; } $pegaUser = $this->getRequest(); $userId = $pegaUser->getParam('id'); $this->view->id = $this->getRequest()->getParam('id'); $this->view->familia = $this->getRequest()->getParam('familia'); $this->view->nome = $this->getRequest()->getParam('nome'); $contrato = $user->contrato; $select = $telefone->select(); $select->where('idBeneficiario = ?', $userId)->order('idTelefone desc')->limit(1); $this->view->dadosTel = $telefone->fetchAll($select); //EXIBE OS DADOS DO BENEFICIARIO, PESSOA E ENDERECOPESSOA DIRETO DA UNIMED $select = $endereco->select(); $select->where('idBeneficiario = ?', $userId); $resultado = $endereco->fetchAll($select); /* SE NAO RETONAR NADA DO ENDERECO NO NOSSO BANCO, PEGA NO BANCO DA UNIMED */ if ($resultado->count() > 0) { $this->view->dadosEndereco = $resultado; } else { $this->view->dadosEndereco = $this->carregaEnderecoBenef($userId); } /* SELECT PARA PEGAR A LOTACAO DO TITULAR */ $select = $beneficiarioCardio->select(); $select->where('familia = ?', $this->getRequest()->getParam('familia'))->where('contrato = ?', $contrato)->where('RDP = 0'); $lotacaoDepe = $beneficiarioCardio->fetchAll($select)->current(); /* SE NAO ACHAR NO BANCO DA UNIMED PROCURA NO DA SEASON */ if ($lotacaoDepe['AutoId'] != null) { $tab = new Application_Model_DbTable_Unibeneficiario(); $select = $tab->select(); $select->setIntegrityCheck(false); $select->from(array('l' => 'LotacaoBeneficiario'), array('InicioVigencia', 'FimVigencia', 'AutoId'))->joinLeft(array('c' => 'LotacaoContrato'), 'l.Lotacao = c.AutoId', array('Nome', 'Codigo'))->where('l.beneficiario = ?', $lotacaoDepe['AutoId']); $this->view->dadosLotacao = $tab->fetchAll($select)->current(); } else { $select = $beneficiario->select(); $select->setIntegrityCheck(false); $select->from(array('b' => 'beneficiario'), array())->join(array('l' => 'lotacao'), 'b.idbeneficiario=l.idbeneficiario', array('*'))->where('familia = ?', $this->getRequest()->getParam('familia'))->where('contrato = ?', $contrato)->where('RDP = 0'); $this->view->dadosLotacao = $beneficiario->fetchAll($select)->current(); } $this->view->rdp = $this->vRdp; //$this->carregaLotacaoContrato($user->contrato); $this->carregaLocalAtendimentoContrato($user->contrato); $this->view->dadosModulo = $this->carregaModuloContrato($user->contrato); $this->view->dadosLocalAtendimento = $this->carregaLocalAtendimentoContrato($user->contrato); }