Line 198... |
Line 198... |
198 |
$champs_valides = self::sqlSelectFields($params, $champs_valides_non_formattes);
|
198 |
$champs_valides = self::sqlSelectFields($params, $champs_valides_non_formattes);
|
Line 199... |
Line 199... |
199 |
|
199 |
|
200 |
// joins:
|
200 |
// joins:
|
201 |
$other_join = self::sqlAddJoins($params, $champs_valides_non_formattes);
|
201 |
$other_join = self::sqlAddJoins($params, $champs_valides_non_formattes);
|
202 |
$requete_tpl = "SELECT SQL_CALC_FOUND_ROWS %s ".
|
202 |
$requete_tpl = "SELECT SQL_CALC_FOUND_ROWS %s ".
|
203 |
"FROM tb_eflore.coste_v2_00 c ".
|
203 |
"FROM coste_v2_00 c ".
|
204 |
" LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' ".
|
204 |
" LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' ".
|
205 |
" LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y' ".
|
205 |
" LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y' ".
|
206 |
" %s ".
|
206 |
" %s ".
|
207 |
"WHERE %s ORDER BY c.num_nom LIMIT %u, %u -- %s ";
|
207 |
"WHERE %s ORDER BY c.num_nom LIMIT %u, %u -- %s ";
|
Line 345... |
Line 345... |
345 |
$j = '';
|
345 |
$j = '';
|
346 |
// ces tests doivent correspondre aux champs générés par sqlSelectFields()
|
346 |
// ces tests doivent correspondre aux champs générés par sqlSelectFields()
|
347 |
// ou contraintes générées par sqlAddConstraint()
|
347 |
// ou contraintes générées par sqlAddConstraint()
|
348 |
if(array_key_exists('masque.famille', $params) ||
|
348 |
if(array_key_exists('masque.famille', $params) ||
|
349 |
array_key_exists('famille', $champs)) {
|
349 |
array_key_exists('famille', $champs)) {
|
350 |
$j .= 'LEFT JOIN tb_eflore.bdtfx_v2_00 b ON c.flore_bdtfx_nn = b.num_nom';
|
350 |
$j .= 'LEFT JOIN bdtfx_v2_00 b ON c.flore_bdtfx_nn = b.num_nom';
|
351 |
}
|
351 |
}
|
Line 352... |
Line 352... |
352 |
|
352 |
|
353 |
return $j;
|
353 |
return $j;
|