Subversion Repositories eFlore/Applications.coel

	const META_LISTE_STOCK_PARAMS = 1020;// Liste des paramètres de contrôle environnemental d'un local

		if ($structures !== false) {

			// Traitement des métadonnées

			$parametres = array(0 => array('nom' => 'Non renseigné', 'abr' => 'NR'));

			foreach ($metadonnees as $meta) {

				$parametres[$meta['cmlv_id_valeur']] = array('nom' => $meta['cmlv_nom'], 'abr' => $meta['cmlv_abreviation']);

			}

			// Traitement du nombre de collection par structure

			$collections_par_structure = array();

			foreach ($collections_nbre as $collection) {

				$nbre = (empty($collection['collection_nbre'])) ? 0 : $collection['collection_nbre'];

				$collections_par_structure[$collection['cs_id_structure']] = $nbre;

			}

			// Traitement final des données concernant les structures 

			foreach ($structures as $structure) {

				// Traitement des paramêtres de stockage

				$truk_stockage_parametres = explode(';;', trim($structure['csc_truk_stockage_parametre'], ' ;'));

				$export_stockage_parametres = array();

				foreach ($truk_stockage_parametres as $param_code) {

					$param_code = preg_replace('/^AUTRE##/', '', trim($param_code));

					$param_txt = preg_match('/^[0-9]+$/', $param_code) ? $parametres[$param_code]['nom'] : $param_code;

					$export_stockage_parametres[] = addcslashes($param_txt, '"');

				}

				$id_structure = $structure['cs_id_structure'];

				$nom = addcslashes($structure['cs_nom'], '"');

				$stockage_params = implode(' ; ', $export_stockage_parametres);

				$stockage_params_nbre = count($export_stockage_parametres);

				$collection_nbre = $collections_par_structure[$structure['cs_id_structure']];

				$collection_nbre = empty($collection_nbre) ? 0 : $collection_nbre;

				$personnel_heure_nbre = empty($structure['personnel_heure_nbre']) ? 0 : $structure['personnel_heure_nbre'];

				$donnees['structures'][$id_structure] = array(

					'nom' => $nom, 

					'stockage_params' => $stockage_params,

					'stockage_params_nbre' => $stockage_params_nbre,

					'collection_nbre' => $collection_nbre,

					'personnel_heure_nbre' => $personnel_heure_nbre);

			}

		}

		// Création du contenu

		$contenu = $this->executerService($donnees);

		return $contenu;

	}

	private function getServiceCollectionExpertise() {

		$donnees = array();

		$projet_id = $this->parametres['projet'];

		// Construction de la requête

		$requete = 'SELECT '.(($this->distinct) ? 'SELECT DISTINCT' : '').' '.

					'	cc_id_collection, '.

					'	cc_nom, cs_nom, cc_ce_specimen_type, cc_description, cc_truk_periode_constitution, '.

					'	cc_truk_couverture_lieu, ccb_truk_etiquette_renseignement, ccb_truk_nature, '.

					'	ccb_truk_unite_base, ccb_ce_etat_general, ccb_truk_etiquette_fixation_support, '.

					'	ccb_truk_etiquette_fixation_specimen, ccb_truk_degradation_presentation, '.

					'	ccb_ce_classement_etat, ccb_ce_inventaire '.

					'FROM coel_collection '. 

		    		'	LEFT JOIN coel_collection_botanique ON (cc_id_collection = ccb_id_collection) '.

					'	LEFT JOIN coel_structure ON (cs_id_structure = cc_ce_structure) '.

					( is_null($projet_id) ? '' : "WHERE cc_ce_projet = $projet_id ").			

					'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'cc_nom ASC').' '.

					((!is_null($this->start) && !is_null($this->limit)) ? "LIMIT $this->start,$this->limit " : '');

		$message_echec = "La requête a retourné aucun résultat.";

		$structures = $this->executerRequete($requete, $message_echec);

		// Récupération des métadonnées nécessaires

		$requete = 	'SELECT cmlv_id_valeur, cmlv_ce_parent, cmlv_nom, cmlv_abreviation '.

					'FROM coel_meta_liste_valeur '.

					'WHERE cmlv_ce_parent IN ('.self::META_LISTES_EXPERTISE_COLLECTION.') ';

		$message_echec = "La requête de recherche des métadonnées a retourné aucun résultat.";

		$metadonnees = $this->executerRequete($requete, $message_echec);

		// Traitement des données