464,6 → 464,8 |
$where[] = "cp_nom LIKE {$p['nom-famille']}"; |
} |
if (isset($p['adresse'])) { |
$join[] = 'LEFT JOIN coel_meta_liste_valeur cmlv ON cmlv.cmlv_id_valeur = cp_ce_truk_pays'; |
$join[] = 'LEFT JOIN coel_meta_liste_valeur cmlv2 ON cmlv2.cmlv_id_valeur = cp_ce_truk_region'; |
$where[] = '(' . implode(' OR ', array( |
"cp_adresse_01 LIKE {$p['adresse']}", |
"cp_adresse_02 LIKE {$p['adresse']}", |
470,8 → 472,11 |
"cp_code_postal LIKE {$p['adresse']}", |
"cp_ville LIKE {$p['adresse']}", |
"cp_ce_truk_pays LIKE {$p['adresse']}", |
"cp_ce_truk_region LIKE {$p['adresse']}", |
"cp_naissance_lieu LIKE {$p['adresse']}", |
"cp_deces_lieu LIKE {$p['adresse']}" |
"cp_deces_lieu LIKE {$p['adresse']}", |
"cmlv.cmlv_nom LIKE {$p['adresse']}", |
"cmlv2.cmlv_nom LIKE {$p['adresse']}" |
)) . ')'; |
} |
if (isset($p['date-vivant'])) { |