274,7 → 274,7 |
// 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"'; |
$where[] = "cv.cmlv_abreviation IN ('FR', 'RE', 'YT', 'GP', 'MQ', 'GF', 'NC')"; |
$where[] = sprintf("cs_code_postal REGEXP '^(%s).*'", implode('|', $p['str-d'])); |
} |
|
285,6 → 285,7 |
} |
|
if (isset($p['pays'])) { |
if(array_search('FR', $p['pays']) !== FALSE) $p['pays'] = array_merge($p['pays'], array('RE','YT','GP','MQ','GF','NC')); |
$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'])); |
} |