| 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'])); |