$sqlBusca .= ") AND "; } $sqlBusca = substr($sqlBusca, 0, -5); $sqlBusca .= ") AND "; } $sqlBusca .= "`VISIVEL` = 1 ORDER BY "; if (isset($_GET['lat']) && isset($_GET['lon'])) { $sqlBusca .= "DISTANCIA, "; } $sqlBusca .= "m.nome, t.razao_social "; if (isset($_GET['lat']) && isset($_GET['lon'])) { $sqlBusca .= "LIMIT 0, {$ntelec}"; } $resBusca = query($sqlBusca); header("Content-Type: text/x-csv; charset=UTF-8;"); header("Content-Disposition: attachment; filename=\"dados.csv\";"); $CsvBody = '"Razão social";"UF";"Município";"Endereço";"Licença";"Canal";"Frequência";"Indicador";"Latitude";"Longitude"' . "\r\n"; while ($telec = mysql_fetch_array($resBusca)) { $CsvBody .= '"' . limpaString($telec['razao_social']) . '";'; $CsvBody .= '"' . (isset($telec['uf']) ? limpaString($telec['uf']) : '') . '";'; $CsvBody .= '"' . (isset($telec['municipio']) ? limpaString($telec['municipio']) : '') . '";'; $CsvBody .= '"' . (isset($telec['endereco']) ? limpaString($telec['endereco']) : '') . '";'; $CsvBody .= '"' . imprimeLicenca($telec['licenca']) . '";'; $CsvBody .= '"' . (isset($telec['canal']) ? $telec['canal'] : '') . '";'; $CsvBody .= '"' . (isset($telec['frequencia']) ? $telec['frequencia'] : '') . '";'; $CsvBody .= '"' . (isset($telec['indicador']) ? $telec['indicador'] : '') . '";'; $CsvBody .= '"' . (isset($telec['latitude']) ? $telec['latitude'] : '') . '";'; $CsvBody .= '"' . (isset($telec['longitude']) ? $telec['longitude'] : '') . '";'; $CsvBody .= "\r\n"; } echo $CsvBody;
$CsvBody .= limpaString($telec['endereco']) . "<br>"; } if (isset($telec['municipio']) && isset($telec['uf'])) { $CsvBody .= limpaString($telec['municipio']) . ' - ' . $telec['uf'] . "<br>"; } else { if (isset($telec['municipio'])) { $CsvBody .= limpaString($telec['municipio']) . "<br>"; } else { if (isset($telec['uf'])) { $CsvBody .= limpaString($telec['uf']) . "<br>"; } } } $CsvBody .= isset($telec['CEP']) ? $telec['CEP'] : ''; $CsvBody .= "</td></tr>\r"; $CsvBody .= '<tr><td class="nome">Licença:</td><td class="valor">' . imprimeLicenca($telec['licenca']) . "</td></tr>\r"; if (isset($telec['canal'])) { $CsvBody .= '<tr><td class="nome">Canal:</td><td class="valor">' . limpaString($telec['canal']) . "</td></tr>\r"; } if (isset($telec['frequencia'])) { $CsvBody .= '<tr><td class="nome">Frequência:</td><td class="valor">' . limpaString($telec['frequencia']) . "</td></tr>\r"; } if (isset($telec['indicador'])) { $CsvBody .= '<tr><td class="nome">Indicador:</td><td class="valor">' . limpaString($telec['indicador']) . "</td></tr>\r"; } if (isset($telec['latitude'])) { $CsvBody .= '<tr><td class="nome">Latitude:</td><td class="valor">' . $telec['latitude'] . "</td></tr>\r"; } if (isset($telec['longitude'])) { $CsvBody .= '<tr><td class="nome">Longitude:</td><td class="valor">' . $telec['longitude'] . "</td></tr>\r"; }