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