Line 24... |
Line 24... |
24 |
private $navigation;
|
24 |
private $navigation;
|
25 |
private $bdd;
|
25 |
private $bdd;
|
Line 26... |
Line 26... |
26 |
|
26 |
|
27 |
private $parametres = array();
|
27 |
private $parametres = array();
|
28 |
private $ressources = array();
|
- |
|
29 |
private $date_defaut = '1900-01-01';
|
28 |
private $ressources = array();
|
30 |
private $ordre_defaut = 'asc';
|
29 |
private $ordre_defaut = 'asc';
|
31 |
private $idsObsImg = array();
|
30 |
private $idsObsImg = array();
|
Line 52... |
Line 51... |
52 |
public function consulter($ressources, $parametres) {
|
51 |
public function consulter($ressources, $parametres) {
|
53 |
// initialiserRessourcesEtParametres()
|
52 |
// initialiserRessourcesEtParametres()
|
54 |
$this->ressources = $ressources;
|
53 |
$this->ressources = $ressources;
|
55 |
$this->parametres = $parametres;
|
54 |
$this->parametres = $parametres;
|
Line -... |
Line 55... |
- |
|
55 |
|
- |
|
56 |
if (!isset($parametres['date.debut'])) {
|
- |
|
57 |
$this->parametres['date.debut'] = '1900-01-01';
|
- |
|
58 |
}
|
56 |
|
59 |
|
57 |
if (!isset($parametres['date'])) {
|
60 |
if (!isset($parametres['date.fin'])) {
|
58 |
$this->parametres['date'] = $this->date_defaut;
|
61 |
$this->parametres['date.fin'] = date('Y-m-d');
|
Line 59... |
Line 62... |
59 |
}
|
62 |
}
|
60 |
|
63 |
|
61 |
if (! isset($parametres['ordre'])) {
|
64 |
if (! isset($parametres['ordre'])) {
|
Line 90... |
Line 93... |
90 |
/*-------------------------------------------------------------------------------
|
93 |
/*-------------------------------------------------------------------------------
|
91 |
CHARGEMENT DES IMAGES
|
94 |
CHARGEMENT DES IMAGES
|
92 |
--------------------------------------------------------------------------------*/
|
95 |
--------------------------------------------------------------------------------*/
|
Line 93... |
Line 96... |
93 |
|
96 |
|
94 |
private function getIdsObsImg() {
|
97 |
private function getIdsObsImg() {
|
- |
|
98 |
$date_debut = "'{$this->parametres['date.debut']}'";
|
95 |
$date_debut = "'{$this->parametres['date']}'";
|
99 |
$date_fin = "'{$this->parametres['date.fin']}'";
|
96 |
$limite = @min(intval($this->parametres['navigation.limite']), 1000);
|
100 |
$limite = @min(intval($this->parametres['navigation.limite']), 1000);
|
97 |
$limite = $limite ? $limite : 100; // 0 => 10
|
101 |
$limite = $limite ? $limite : 100; // 0 => 10
|
98 |
$depart = intval(@$this->parametres['navigation.depart']);
|
102 |
$depart = intval(@$this->parametres['navigation.depart']);
|
Line 105... |
Line 109... |
105 |
'modif_date '.
|
109 |
'modif_date '.
|
Line 106... |
Line 110... |
106 |
|
110 |
|
107 |
'FROM del_plantnet AS p '.
|
111 |
'FROM del_plantnet AS p '.
|
108 |
' JOIN del_observation_modif_date '.
|
112 |
' JOIN del_observation_modif_date '.
|
109 |
' ON (p.id_observation = del_observation_modif_date.id_observation '.
|
113 |
' ON (p.id_observation = del_observation_modif_date.id_observation '.
|
- |
|
114 |
' AND modif_date >= '.date('U', strtotime($date_debut)).') '.
|
110 |
' AND modif_date >= '.$date_debut.') '.
|
115 |
' AND modif_date <= '.date('U', strtotime($date_fin)).') '.
|
111 |
' LEFT JOIN del_image_vote AS iv '.
|
116 |
' LEFT JOIN del_image_vote AS iv '.
|
112 |
' ON (id_image = iv.ce_image AND iv.ce_protocole = 3) '.
|
117 |
' ON (id_image = iv.ce_image AND iv.ce_protocole = 3) '.
|
113 |
' LEFT JOIN del_image_tag AS it '.
|
118 |
' LEFT JOIN del_image_tag AS it '.
|
114 |
' ON (id_image = it.ce_image AND it.actif = 1) '.
|
119 |
' ON (id_image = it.ce_image AND it.actif = 1) '.
|
Line 140... |
Line 145... |
140 |
}
|
145 |
}
|
141 |
$idsImgConcat = implode(',', $idsImg);
|
146 |
$idsImgConcat = implode(',', $idsImg);
|
Line 142... |
Line 147... |
142 |
|
147 |
|
143 |
$requete = 'SELECT '.
|
148 |
$requete = 'SELECT '.
|
- |
|
149 |
'p.id_observation, p.id_image, '.
|
144 |
'p.id_observation, p.id_image, '.
|
150 |
'cp.id_plantnet, ' .
|
145 |
'p.nom_sel, '.
|
151 |
'p.nom_sel, '.
|
146 |
'p.nom_referentiel, p.nom_ret, p.famille, '.
|
152 |
'p.nom_referentiel, p.nom_ret, p.famille, '.
|
147 |
'p.zone_geo, p.latitude, p.longitude, '.
|
153 |
'p.zone_geo, p.latitude, p.longitude, '.
|
148 |
'p.date_observation, p.date_creation, p.date_transmission, '.
|
154 |
'p.date_observation, p.date_creation, p.date_transmission, '.
|
149 |
'p.mots_cles_texte, '.
|
155 |
'p.mots_cles_texte, '.
|
150 |
'p.ce_utilisateur, p.prenom_utilisateur, p.nom_utilisateur, '.
|
156 |
'p.ce_utilisateur, p.prenom_utilisateur, p.nom_utilisateur, p.courriel_utilisateur, '.
|
151 |
'p.i_mots_cles_texte AS mots_cles_texte_image, p.nom_original AS nom_image, '.
|
- |
|
152 |
'cp.id_plantnet '.
|
157 |
'p.i_mots_cles_texte AS mots_cles_texte_image, p.nom_original AS nom_image '.
|
153 |
'FROM del_plantnet AS p '.
|
158 |
'FROM del_plantnet AS p '.
|
154 |
'LEFT JOIN tb_cel_test.cel_plantnet AS cp ON p.id_observation = cp.id_observation '.
|
159 |
'LEFT JOIN tb_cel.cel_plantnet AS cp ON p.id_observation = cp.id_observation '.
|
155 |
"WHERE id_image IN ($idsImgConcat) ".
|
160 |
"WHERE id_image IN ($idsImgConcat) ".
|
156 |
' -- '.__FILE__.':'.__LINE__;
|
161 |
' -- '.__FILE__.':'.__LINE__;
|
157 |
// recuperer les donnees
|
162 |
// recuperer les donnees
|
Line 187... |
Line 192... |
187 |
$obs[$idobs]['id_observation'] = $idobs;
|
192 |
$obs[$idobs]['id_observation'] = $idobs;
|
188 |
$obs[$idobs]['id_plantnet'] = $imgdata['id_plantnet'];
|
193 |
$obs[$idobs]['id_plantnet'] = $imgdata['id_plantnet'];
|
189 |
$obs[$idobs]['auteur_id'] = $imgdata['ce_utilisateur'];
|
194 |
$obs[$idobs]['auteur_id'] = $imgdata['ce_utilisateur'];
|
190 |
$obs[$idobs]['auteur_prenom'] = $imgdata['prenom_utilisateur'];
|
195 |
$obs[$idobs]['auteur_prenom'] = $imgdata['prenom_utilisateur'];
|
191 |
$obs[$idobs]['auteur_nom'] = $imgdata['nom_utilisateur'];
|
196 |
$obs[$idobs]['auteur_nom'] = $imgdata['nom_utilisateur'];
|
- |
|
197 |
$obs[$idobs]['auteur_courriel'] = $imgdata['courriel_utilisateur'];
|
Line 192... |
Line 198... |
192 |
|
198 |
|
Line 193... |
Line 199... |
193 |
$obs[$idobs]['mots_cles_obs_cel'] = $this->formaterMotsClesCel($imgdata['mots_cles_texte']);
|
199 |
$obs[$idobs]['mots_cles_obs_cel'] = $this->formaterMotsClesCel($imgdata['mots_cles_texte']);
|
194 |
|
200 |
|