Line 29... |
Line 29... |
29 |
$info = array();
|
29 |
$info = array();
|
30 |
$contenu = '';
|
30 |
$contenu = '';
|
Line 31... |
Line 31... |
31 |
|
31 |
|
32 |
// Pré traitement des paramêtres
|
32 |
// Pré traitement des paramêtres
|
33 |
$pour_bdd = false;
|
33 |
$pour_bdd = false;
|
Line 34... |
Line 34... |
34 |
$this->parametres = $this->traiterParametresUrl(array('service', 'format', 'projet'), $params, $pour_bdd);
|
34 |
$this->parametres = $this->traiterParametresUrl(array('service', 'format'), $params, $pour_bdd);
|
35 |
|
35 |
|
36 |
// Chargement du bon type de service demandé
|
36 |
// Chargement du bon type de service demandé
|
Line 115... |
Line 115... |
115 |
}
|
115 |
}
|
Line 116... |
Line 116... |
116 |
|
116 |
|
117 |
|
117 |
|
118 |
private function getServiceStructureExpertise() {
|
- |
|
Line 119... |
Line 118... |
119 |
$donnees = array();
|
118 |
private function getServiceStructureExpertise() {
|
120 |
$projet_id = $this->parametres['projet'];
|
119 |
$donnees = array();
|
121 |
|
120 |
|
122 |
// Construction de la requête
|
121 |
// Construction de la requête
|
123 |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
|
122 |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
|
124 |
' cs_id_structure, '.
|
123 |
' cs_id_structure, '.
|
125 |
' SUM(csap_bota_travail_hebdo_tps) AS personnel_heure_nbre, '.
|
124 |
' SUM(csap_bota_travail_hebdo_tps) AS personnel_heure_nbre, '.
|
126 |
' cs_nom, csc_truk_stockage_parametre, csv_mark_visite_avec_motif '.
|
125 |
' cs_nom, csc_truk_stockage_parametre, csv_mark_visite_avec_motif '.
|
127 |
'FROM coel_structure '.
|
126 |
'FROM coel_structure '.
|
128 |
' LEFT JOIN coel_structure_a_personne ON (cs_id_structure = csap_id_structure) '.
|
- |
|
129 |
' LEFT JOIN coel_structure_conservation ON (cs_id_structure = csc_id_structure) '.
|
127 |
' LEFT JOIN coel_structure_a_personne ON (cs_id_structure = csap_id_structure) '.
|
130 |
' LEFT JOIN coel_structure_valorisation ON (cs_id_structure = csv_id_structure) '.
|
128 |
' LEFT JOIN coel_structure_conservation ON (cs_id_structure = csc_id_structure) '.
|
131 |
( is_null($projet_id) ? '' : "WHERE cs_ce_projet = $projet_id ").
|
129 |
' LEFT JOIN coel_structure_valorisation ON (cs_id_structure = csv_id_structure) '.
|
132 |
'GROUP BY cs_id_structure '.
|
130 |
'GROUP BY cs_id_structure '.
|
Line 138... |
Line 136... |
138 |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
|
136 |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
|
139 |
' cs_id_structure, '.
|
137 |
' cs_id_structure, '.
|
140 |
' COUNT(cc_id_collection) AS collection_nbre '.
|
138 |
' COUNT(cc_id_collection) AS collection_nbre '.
|
141 |
'FROM coel_structure '.
|
139 |
'FROM coel_structure '.
|
142 |
' LEFT JOIN coel_collection ON (cs_id_structure = cc_ce_structure) '.
|
140 |
' LEFT JOIN coel_collection ON (cs_id_structure = cc_ce_structure) '.
|
143 |
( is_null($projet_id) ? '' : "WHERE cs_ce_projet = $projet_id ").
|
- |
|
144 |
'GROUP BY cs_id_structure ';
|
141 |
'GROUP BY cs_id_structure ';
|
145 |
$message_echec = "La requête comptant le nombre de collection a retourné aucun résultat.";
|
142 |
$message_echec = "La requête comptant le nombre de collection a retourné aucun résultat.";
|
146 |
$collections_nbre = $this->executerRequete($requete, $message_echec);
|
143 |
$collections_nbre = $this->executerRequete($requete, $message_echec);
|
Line 147... |
Line 144... |
147 |
|
144 |
|
Line 194... |
Line 191... |
194 |
$contenu = $this->executerService($donnees);
|
191 |
$contenu = $this->executerService($donnees);
|
195 |
return $contenu;
|
192 |
return $contenu;
|
196 |
}
|
193 |
}
|
Line 197... |
Line 194... |
197 |
|
194 |
|
198 |
private function getServiceCollectionExpertise() {
|
- |
|
Line 199... |
Line 195... |
199 |
$projet_id = $this->parametres['projet'];
|
195 |
private function getServiceCollectionExpertise() {
|
200 |
|
196 |
|
201 |
// Construction de la requête
|
197 |
// Construction de la requête
|
202 |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
|
198 |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
|
Line 208... |
Line 204... |
208 |
' ccb_truk_etiquette_fixation_specimen, ccb_truk_degradation_presentation, '.
|
204 |
' ccb_truk_etiquette_fixation_specimen, ccb_truk_degradation_presentation, '.
|
209 |
' ccb_ce_classement_etat, ccb_ce_inventaire '.
|
205 |
' ccb_ce_classement_etat, ccb_ce_inventaire '.
|
210 |
'FROM coel_collection '.
|
206 |
'FROM coel_collection '.
|
211 |
' LEFT JOIN coel_collection_botanique ON (cc_id_collection = ccb_id_collection) '.
|
207 |
' LEFT JOIN coel_collection_botanique ON (cc_id_collection = ccb_id_collection) '.
|
212 |
' LEFT JOIN coel_structure ON (cs_id_structure = cc_ce_structure) '.
|
208 |
' LEFT JOIN coel_structure ON (cs_id_structure = cc_ce_structure) '.
|
213 |
( is_null($projet_id) ? '' : "WHERE cc_ce_projet = $projet_id ").
|
- |
|
214 |
'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'cc_nom ASC').' ';
|
209 |
'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'cc_nom ASC').' ';
|
215 |
$message_echec = "La requête a retourné aucun résultat.";
|
210 |
$message_echec = "La requête a retourné aucun résultat.";
|
216 |
$collections = $this->executerRequete($requete, $message_echec);
|
211 |
$collections = $this->executerRequete($requete, $message_echec);
|
Line 217... |
Line 212... |
217 |
|
212 |
|