| 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;
|