2187 |
LEFT JOIN ".DB_PREFIXE."division |
LEFT JOIN ".DB_PREFIXE."division |
2188 |
ON dossier.division=division.division |
ON dossier.division=division.division |
2189 |
%s |
%s |
|
%s |
|
2190 |
"; |
"; |
2191 |
|
|
2192 |
|
|
2205 |
"; |
"; |
2206 |
} |
} |
2207 |
|
|
2208 |
$query_ct_from = sprintf($query_ct_from, $query_ct_where_collectivite_filter, $join_enjeux_dossier); |
$query_ct_from = sprintf($query_ct_from, $query_ct_where_collectivite_filter); |
2209 |
// WHERE - COMMON |
// WHERE - COMMON |
2210 |
$query_ct_where_common = " |
$query_ct_where_common = " |
2211 |
groupe.code != 'CTX' |
groupe.code != 'CTX' |
10808 |
return $sqlFilter; |
return $sqlFilter; |
10809 |
} |
} |
10810 |
|
|
10811 |
protected function add_filter_division_to_query(string $query) { |
public function add_filter_division_to_query(string $query) { |
10812 |
$sqlFilter = array( |
$sqlFilter = array( |
10813 |
'FROM' => '', |
'FROM' => '', |
10814 |
'WHERE' => '' |
'WHERE' => '' |