public function getListagem($arrData = array(), $intPage = 1, $intQtdPage = 10)
{
$queryBuilder = $this->_em->createQueryBuilder();
$queryBuilder->select('PessoaFisica')->addSelect('Login.dsLogin')->from('Application\\Entity\\PessoaFisica', 'PessoaFisica')->innerJoin('Application\\Entity\\Login', 'Login', 'with', 'Login.idPessoaFisica = PessoaFisica.idPessoaFisica')->setMaxResults($intQtdPage)->setFirstResult($intPage * ($intPage - 1))->orderBy('PessoaFisica.dsNome', 'asc');
# bind nome
if ($arrData['dsNome']) {
$queryBuilder->andWhere($queryBuilder->expr()->like('PessoaFisica.dsNome', ':dsNome'))->setParameter('dsNome', '%' . $arrData['dsNome'] . '%');
}
# bind cpf
if ($arrData['dsCpf']) {
$queryBuilder->andWhere('PessoaFisica.dsCpf = :dsCpf')->setParameter('dsCpf', Format::clearCpfCnpj($arrData['dsCpf']));
}
# bind dsEmail
if ($arrData['dsEmail']) {
$queryBuilder->andWhere('PessoaFisica.dsEmail = :dsEmail')->setParameter('dsEmail', $arrData['dsEmail']);
}
# bind dsLogin
if ($arrData['dsLogin']) {
$queryBuilder->andWhere('Login.dsLogin = :dsLogin')->setParameter('dsLogin', $arrData['dsLogin']);
}
$query = $queryBuilder->getQuery();
$registerPaginator = new Paginator($query);
$registerPaginator->setUseOutputWalkers(false);
$intCountResult = $registerPaginator->count();
$arrDadosPaginator = array('qtdRegister' => $intCountResult, 'qtdPages' => ceil($intCountResult / $intQtdPage), 'pageActual' => $intPage, 'maxResult' => $intQtdPage, 'register' => $registerPaginator);
return $arrDadosPaginator;
}
public function pesquisar($strCEP)
{
$adapter = $this->getAdapter();
$arrResult = $adapter->pesquisaCep(Format::clearMask($strCEP));
if (!$arrResult['status']) {
throw new \Exception($arrResult['message']);
}
$arrResult = $this->makeResult($arrResult);
// if (array_key_exists('idMunicipio', $arrResult)) {
// # operacao de cadastro
// }
return $arrResult;
}
public function ajaxCheckInformationAction()
{
$request = $this->getRequest();
$booValidate = false;
if ($request->isPost()) {
$arrData = $request->getPost()->toArray();
if (array_key_exists('dsCpf', $arrData)) {
$arrData['dsCpf'] = Format::clearCpfCnpj($arrData['dsCpf']);
}
$booValidate = $this->getService()->validateInformacao($arrData);
}
return new JsonModel(['status' => $booValidate]);
}
public function save($arrData)
{
try {
if ($arrData['idEmpreendimento']) {
$empreendimento = $this->find($arrData['idEmpreendimento']);
} else {
$empreendimento = new EmpreendimentoEntity();
}
$empreendimento->setCoCep(Format::clearMask($arrData['coCep']))->setDsBairro($arrData['dsBairro'])->setDsComplemento($arrData['dsComplemento'])->setDsEmpreendimento($arrData['dsEmpreendimento'])->setDsLogradouro($arrData['dsLogradouro'])->setIdMunicipio($this->getReferenceEntity($arrData['coMunicipio'], 'Application\\Entity\\Municipio'))->setInSituacao(EmpreendimentoEntity::co_situacao_ativo);
$this->getEntityManager()->persist($empreendimento);
$this->getEntityManager()->flush();
} catch (\Exception $exception) {
throw new \Exception($exception->getMessage());
}
}