0) { include_once('ajax/geoloc.php'); /* ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL);*/ $useridRD = calculaGeolocalizacao($_POST['cep'], 1, 1); // print_r($useridRD); foreach($useridRD as $idAutobroker){ $idsAb[] = $idAutobroker['id']; } //busca cidade do CEP /* $token = 'c57027b8765eccdacef74ef6da20098f'; $url = 'https://viacep.com.br/ws/'..'/json/'); $ch = curl_init(); //echo $url; curl_setopt($ch, CURLOPT_URL, $url); // curl_setopt($ch, CURLOPT_HTTPHEADER, array('Authorization: Token token="' . $token . '"')); // curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $output = curl_exec($ch); curl_close( $ch ); */ $url = "http://viacep.com.br/ws/".preg_replace("/[^0-9]/", "",$_POST['cep'])."/json/"; // CURL $ch = curl_init(); // Disable SSL verification curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); // Will return the response, if false it print the response curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); // Set the url curl_setopt($ch, CURLOPT_URL, $url); // Execute $result = curl_exec($ch); // Closing curl_close($ch); // return json_decode($result); $result = json_decode($result); //print_r($result); exit; //echo ."CEP"; // if(strlen($result->{"localidade"}) > 1) { if(count($useridRD) > 0) { // $autobrokers = DAOFactory::getAutobrokerDAO()->relTable("SELECT * FROM autobroker where ((LENGTH(datastart) > 0) and (LENGTH(datadistrato) = 0)) and estado = '".$result->{"uf"}."' and REPLACE(cidade,'-',' ') = '".((str_replace('.','',(utf8_encode($result->{"localidade"})))))."' order by rand()"); $ids = implode(',',$idsAb); $autobrokers = DAOFactory::getAutobrokerDAO()->relTable("SELECT * FROM autobroker where (LENGTH(avatar) > 0) and (LENGTH(datastart) > 0) and (LENGTH(dataretorno) = 0) and idAutobroker in (".$ids.") order by rand()"); //echo "SELECT * FROM autobroker where idAutobroker in (".substr($ids, 0, -1).") order by rand()"; //exit; if(count($autobrokers) > 0) { $i = 0; foreach($autobrokers as $autobroker){ $concessionarias[ $i ]['idAutobroker'] = $autobroker->idAutobroker; $concessionarias[ $i ]['nome'] = strtoupper($autobroker->nome); $concessionarias[ $i ]['alias'] = $autobroker->alias; $concessionarias[ $i ]['email'] = $autobroker->responsavelemail; $concessionarias[ $i ]['telefone'] = $autobroker->telbmz; $concessionarias[ $i ]['avatar'] = $autobroker->avatar; $concessionarias[ $i ]['whatsapp'] = $autobroker->telbmz; $concessionarias[ $i ]['instagram'] = $autobroker->instagram; $concessionarias[ $i ]['facebook'] = $autobroker->facebook; $concessionarias[ $i ]['cidade'] = strtoupper($autobroker->cidade); $concessionarias[ $i ]['estado'] = strtoupper($autobroker->estado); $concessionarias[ $i ]['logo'] = $autobroker->logo; $i++; } } } }else{ if(!$_POST['cidade']) { $autobrokers = DAOFactory::getAutobrokerDAO()->relTable("SELECT * FROM autobroker where (LENGTH(avatar) > 0) and ((LENGTH(datastart) > 0) and (LENGTH(datadistrato) = 0) and (LENGTH(dataretorno) = 0)) and estado = '".str_replace('.','',$_POST['uf'])."' order by rand()"); }else { $autobrokers = DAOFactory::getAutobrokerDAO()->relTable("SELECT * FROM autobroker where (LENGTH(avatar) > 0) and ((LENGTH(datastart) > 0) and (LENGTH(datadistrato) = 0) and (LENGTH(dataretorno) = 0)) and estado = '".str_replace('.','',$_POST['uf'])."' and cidade = '".((str_replace('.','',$_POST['cidade'])))."' order by rand()"); //echo "SELECT * FROM autobroker where (LENGTH(avatar) > 0) and ((LENGTH(datastart) > 0) and (LENGTH(datadistrato) = 0) and (LENGTH(dataretorno) = 0)) and estado = '".str_replace('.','',$_POST['uf'])."' and cidade = '".((str_replace('.','',$_POST['cidade'])))."' order by rand()"; } if(count($autobrokers) > 0) { $i = 0; foreach($autobrokers as $autobroker){ $concessionarias[ $i ]['idAutobroker'] = $autobroker->idAutobroker; $concessionarias[ $i ]['nome'] = strtoupper($autobroker->nome); $concessionarias[ $i ]['alias'] = $autobroker->alias; $concessionarias[ $i ]['email'] = $autobroker->responsavelemail; $concessionarias[ $i ]['telefone'] = $autobroker->telbmz; $concessionarias[ $i ]['avatar'] = $autobroker->avatar; $concessionarias[ $i ]['whatsapp'] = $autobroker->telbmz; $concessionarias[ $i ]['instagram'] = $autobroker->instagram; $concessionarias[ $i ]['facebook'] = $autobroker->facebook; $concessionarias[ $i ]['cidade'] = strtoupper($autobroker->cidade); $concessionarias[ $i ]['estado'] = strtoupper($autobroker->estado); $concessionarias[ $i ]['logo'] = $autobroker->logo; $i++; } } } } ?> 0) && (count($concessionarias) == 0)) { // nao encontrou ?>

Aguarde enquanto localizamos as concessionárias próximas ao seu CEP.