207,6 → 207,11 |
if(!$p['pays']) unset($p['pays']); |
} |
|
if(isset($qs['regions'])) { |
$p['regions'] = array_filter(explode(',', $qs['regions']), create_function('$val', 'return preg_match("/^[A-Z][A-Z]\.\w\w$/", $val);')); |
if(!$p['regions']) unset($p['regions']); |
} |
|
return $p; |
} |
|
266,6 → 271,7 |
} |
|
// par défaut, spécifier un département restreint à la France |
// TODO: INNER JOIN |
if (isset($p['str-d'])) { |
$join[] = 'LEFT JOIN coel_meta_liste_valeur cv ON cv.cmlv_id_valeur = cs_ce_truk_pays'; |
$where[] = 'cv.cmlv_abreviation = "FR"'; |
272,6 → 278,12 |
$where[] = sprintf("cs_code_postal REGEXP '^(%s).*'", implode('|', $p['str-d'])); |
} |
|
// http://download.geonames.org/export/dump/admin1CodesASCII.txt |
if (isset($p['regions'])) { |
$join[] = 'LEFT JOIN coel_meta_liste_valeur cv ON cv.cmlv_id_valeur = cs_ce_truk_region'; |
$where[] = sprintf('cv.cmlv_abreviation IN ("%s")', implode('","', $p['regions'])); |
} |
|
if (isset($p['pays'])) { |
$join[] = 'LEFT JOIN coel_meta_liste_valeur cv ON cv.cmlv_id_valeur = cs_ce_truk_pays'; |
$where[] = sprintf('cv.cmlv_abreviation IN ("%s")', implode('","', $p['pays'])); |