Subversion Repositories eFlore/Applications.coel

Rev

Rev 1586 | Rev 1829 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1586 Rev 1765
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