369,13 → 369,17 |
$where[] = "ccb_ce_truk_type IN ({$p['bot']})"; |
} |
if (isset($p['lieu-stockage'])) { |
$join[] = 'LEFT JOIN coel_meta_liste_valeur cmlv ON cmlv.cmlv_id_valeur = cs_ce_truk_pays'; |
$join[] = 'LEFT JOIN coel_meta_liste_valeur cmlv2 ON cmlv2.cmlv_id_valeur = cs_ce_truk_region'; |
$where[] = '(' . implode(' OR ', array( |
"cs_adresse_01 LIKE {$p['lieu-stockage']}", |
"cs_adresse_02 LIKE {$p['lieu-stockage']}", |
"cs_code_postal LIKE {$p['lieu-stockage']}", |
"cs_ville LIKE {$p['lieu-stockage']}", |
"cs_ce_truk_region LIKE {$p['lieu-stockage']}", // @TODO joindre la table meta |
"cs_ce_truk_pays LIKE {$p['lieu-stockage']}" |
"cs_ce_truk_region LIKE {$p['lieu-stockage']}", |
"cs_ce_truk_pays LIKE {$p['lieu-stockage']}", |
"cmlv.cmlv_nom LIKE {$p['lieu-stockage']}", |
"cmlv2.cmlv_nom LIKE {$p['lieu-stockage']}" |
)) . ')'; |
} |
if (isset($p['zg'])) { |