';
$bounding_distance = 0.3;
$sqlSimilar = "
SELECT similar_cat
FROM categories_google_maps
WHERE id_cat = $id_cat
LIMIT 1";
$resSimilar = mysqli_query($c1, $sqlSimilar);
$rowSimilar = mysqli_fetch_assoc($resSimilar);
$similarCatStr = (string) ($rowSimilar['similar_cat'] ?? '');
$similarCats = array_filter(array_map('intval', explode(',', $similarCatStr)));
if (!in_array($id_cat, $similarCats)) {
array_unshift($similarCats, $id_cat);
}
if (empty($similarCats)) {
$similarCats = [$id_cat];
}
$whereCat = "AND (" . implode(' OR ', array_map(function ($cat) {
return "FIND_IN_SET(" . intval($cat) . ", id_cat_all)";
}, $similarCats)) . ")";
$query_suggestions_similaires = "
SELECT *,
FLOOR(
(
ACOS(
SIN($Lat * PI() / 180) * SIN(truncated_lat * PI() / 180) +
COS($Lat * PI() / 180) * COS(truncated_lat * PI() / 180) *
COS(($Lng - truncated_lng) * PI() / 180)
) * 180 / PI()
) * 60 * 1.1515
) AS distance_in_miles_floored,
(
ACOS(
SIN($Lat * PI() / 180) * SIN(truncated_lat * PI() / 180) +
COS($Lat * PI() / 180) * COS(truncated_lat * PI() / 180) *
COS(($Lng - truncated_lng) * PI() / 180)
) * 180 / PI()
) * 60 * 1.1515 AS distance_in_miles
FROM (
SELECT *
FROM `$places_table`
WHERE
truncated_lat BETWEEN ($Lat - $bounding_distance) AND ($Lat + $bounding_distance)
AND truncated_lng BETWEEN ($Lng - $bounding_distance) AND ($Lng + $bounding_distance)
AND Reviews >= 20
AND unique_id != '$p'
AND Name != '$escapedName'
$whereCat
) AS filtered_places
GROUP BY Name
ORDER BY distance_in_miles_floored ASC, Reviews DESC
LIMIT 5;
";
//echo '
'.$query_suggestions_similaires.'
';
$result_suggestions_similaires = mysqli_query($c1, $query_suggestions_similaires);
$i = 0;
while ($row_suggestions_similaires = mysqli_fetch_array($result_suggestions_similaires)) {
$lat_suggestions_similaires = $row_suggestions_similaires['Lat'] ?? $row_suggestions_similaires['Latitude'] ?? null;
$lng_suggestions_similaires = $row_suggestions_similaires['Lng'] ?? $row_suggestions_similaires['Longitude'] ?? null;
/*$lat_suggestions_similaires = $row_suggestions_similaires['Lat'];
$lng_suggestions_similaires = $row_suggestions_similaires['Lng'];*/
$lat_key = number_format(floor((float)$lat_suggestions_similaires * 10000) / 10000, 4, '.', '');
$lng_key = number_format(floor((float)$lng_suggestions_similaires * 10000) / 10000, 4, '.', '');
if (isset($seen_lats[$lat_key]) || isset($seen_lngs[$lng_key])) {
if ($test == 1) echo "
Ignoré (doublon lat/lng) : $lat_key / $lng_key
";
continue;
}
$seen_lats[$lat_key] = true;
$seen_lngs[$lng_key] = true;
$sug_id_cat_all = $row_suggestions_similaires['id_cat_all'];
$sug_id_cat = explode(',', $sug_id_cat_all);
$sug_id_cat = reset($sug_id_cat);
$sug_Category_all = idCatAllToTexte($sug_id_cat_all, 'fr');
$sugcategoriesArray = explode(',', $sug_Category_all);
$sugpremiereCategorie = reset($sugcategoriesArray);
$sugpremiereCategorie = mb_strtoupper(mb_substr($sugpremiereCategorie, 0, 1)) . mb_substr($sugpremiereCategorie, 1);
$sug_Name = @$row_suggestions_similaires['Name'];
$sug_Name = corrigerCaracteresLatin($sug_Name);
$country_code = @$row_suggestions_similaires['Country_Code'];
$sug_unique_id = $row_suggestions_similaires['unique_id'];
$sug_image_top = 'cache/places/top_images_webp/' . unique_id_to_imagepath($sug_unique_id) . '.webp';
$exists = is_file($sug_image_top) || is_file('../../' . $sug_image_top);
if(!$exists) {
//if (file_exists($sug_image_top) === false) {
$sug_image_top = no_preview($sug_id_cat);
$sug_image_top = 'images/no-preview/svg/' . $sug_image_top;
}
/*
if (file_exists('../' . $sug_image_top) === false) {
if (file_exists($sug_image_top) === false) {
$sug_image_top = no_preview($sug_id_cat);
$sug_image_top = 'images/no-preview/svg/' . $sug_image_top;
}
}
*/
if (isset($row_suggestions_similaires['Hours'])) {
$sug_Hours = hours_encodeRawHoursToHex(@$row_suggestions_similaires['Hours']);
}
else $sug_Hours = '';
/*
$json_path = 'cache/places/content/' . unique_id_to_jsonpath($sug_unique_id);
$sug_Hours = '';
$rond_open_closed = "rond_grey";
if (@file_exists($json_path) === true && filesize($json_path) > 0) {
$json_content = file_get_contents($json_path);
$row_suggestions_json = json_decode($json_content, true);
if (isset($row_suggestions_json['Hours'])) {
$sug_Hours = hours_encodeRawHoursToHex($row_suggestions_json['Hours']);
}
}
*/
if ($sug_Hours != '') {
$sug_open_closed = hours_isOpenNowMinimalist($sug_Hours['hex']);
} else {
$sug_open_closed = '';
}
if (strpos($sug_open_closed, "Ouvert") !== false) {
$sug_css_open_close = 'rond_green';
$sug_css_open_close_title = 'Ouvert';
} elseif (strpos($sug_open_closed, "Fermé") !== false) {
$sug_css_open_close = 'rond_grey';
$sug_css_open_close_title = 'Fermé';
} else {
$sug_css_open_close = 'rond_grey opacity_10';
$sug_css_open_close_title = 'Horaires non disponibles';
}
if (strlen($sug_Name) >= 60) $sug_Name_display = cutSentence($sug_Name, 30);
else $sug_Name_display = $sug_Name;
$distance_in_miles_floored = $row_suggestions_similaires['distance_in_miles_floored'];
if ($distance_in_miles_floored == 0) $display_a_n_km = ' < à 1 km';
else $display_a_n_km = 'à ' . $distance_in_miles_floored . ' km';
$display_suggestions_similaires .= '
' . $display_a_n_km . '
' . $sug_Name_display . '
' . $sugpremiereCategorie . '
';
$i++;
if ($i >= 4) break;
}
$display_suggestions_similaires .= '
'.$place_home_title.'';
$nameDisplay = $Name;
$content .= '