| Line 216... |
Line 216... |
| 216 |
|
216 |
|
| 217 |
// Construction de la requête
|
217 |
// Construction de la requête
|
| 218 |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
|
218 |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
|
| 219 |
' cc_id_collection, '.
|
219 |
' cc_id_collection, '.
|
| 220 |
' cc_ce_structure, '.
|
220 |
' cc_ce_structure, '.
|
| 221 |
' cc_nom, cc_cote, cs_nom, cc_ce_specimen_type, cc_description, cc_truk_periode_constitution, '.
|
221 |
' cc_nom, cc_cote, cs_nom, cc_ce_specimen_type, cc_description, cc_periode_constitution_debut, cc_periode_constitution_fin, '.
|
| 222 |
' cc_truk_couverture_lieu, ccb_truk_etiquette_renseignement, ccb_truk_nature, '.
|
222 |
' cc_truk_couverture_lieu, ccb_truk_etiquette_renseignement, ccb_truk_nature, '.
|
| 223 |
' ccb_truk_unite_base, ccb_ce_etat_general, ccb_specimen_fixation_pourcent, '.
|
223 |
' ccb_nb_planches_herbiers, ccb_nb_especes, ccb_ce_etat_general, ccb_specimen_fixation_pourcent, '.
|
| 224 |
' ccb_truk_specimen_fixation_methode, ccb_truk_etiquette_fixation_support, '.
|
224 |
' ccb_truk_specimen_fixation_methode, ccb_truk_etiquette_fixation_support, '.
|
| 225 |
' ccb_truk_etiquette_fixation_specimen, ccb_truk_degradation_presentation, '.
|
225 |
' ccb_truk_etiquette_fixation_specimen, ccb_truk_degradation_presentation, '.
|
| 226 |
' ccb_ce_classement_etat, ccb_ce_inventaire '.
|
226 |
' ccb_ce_classement_etat, ccb_ce_inventaire '.
|
| 227 |
'FROM coel_collection '.
|
227 |
'FROM coel_collection '.
|
| Line 242... |
Line 242... |
| 242 |
$donnees = array();
|
242 |
$donnees = array();
|
| 243 |
if ($collections !== false) {
|
243 |
if ($collections !== false) {
|
| 244 |
// Instanciation des objets nécessaires aux traitements
|
244 |
// Instanciation des objets nécessaires aux traitements
|
| 245 |
$ontologie = new Ontologie($metadonnees);
|
245 |
$ontologie = new Ontologie($metadonnees);
|
| 246 |
$utilTruck = new UtilTruck($ontologie);
|
246 |
$utilTruck = new UtilTruck($ontologie);
|
| - |
|
247 |
$etat_ontologie = array("" =>"", "0" => "", "1" => "Très mauvais état", "2" => "Mauvais état", "3" => "État moyen",
|
| - |
|
248 |
"4" => "Bon état", "5" => "Très bon état");
|
| Line 247... |
Line 249... |
| 247 |
|
249 |
|
| 248 |
// Traitement final des données concernant les structures
|
250 |
// Traitement final des données concernant les structures
|
| 249 |
foreach ($collections as $collection) {
|
251 |
foreach ($collections as $collection) {
|
| 250 |
$id_collection = $collection['cc_id_collection'];
|
252 |
$id_collection = $collection['cc_id_collection'];
|
| 251 |
$nom = $collection['cc_nom'];
|
253 |
$nom = $collection['cc_nom'];
|
| 252 |
$cote = $collection['cc_cote'];
|
254 |
$cote = $collection['cc_cote'];
|
| 253 |
$id_structure = $collection['cc_ce_structure'];
|
255 |
$id_structure = $collection['cc_ce_structure'];
|
| 254 |
$nom_structure = $collection['cs_nom'];
|
256 |
$nom_structure = $collection['cs_nom'];
|
| 255 |
$specimen_type = $utilTruck->construireTxtListeOntologie($collection['cc_ce_specimen_type']);
|
257 |
$specimen_type = $utilTruck->construireTxtListeOntologie($collection['cc_ce_specimen_type']);
|
| 256 |
$description = $collection['cc_description'];
|
- |
|
| 257 |
$periode_constitution = $utilTruck->construireTxtListeOntologie($collection['cc_truk_periode_constitution']);
|
258 |
$description = $collection['cc_description'];
|
| 258 |
$couverture_lieu = $utilTruck->construireTxtListeOntologie($collection['cc_truk_couverture_lieu']);
|
259 |
$couverture_lieu = $utilTruck->construireTxtListeOntologie($collection['cc_truk_couverture_lieu']);
|
| 259 |
$specimen_fixation_pourcent = $collection['ccb_specimen_fixation_pourcent'];
|
260 |
$specimen_fixation_pourcent = $collection['ccb_specimen_fixation_pourcent'];
|
| 260 |
$specimen_fixation_methode = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_specimen_fixation_methode']);
|
261 |
$specimen_fixation_methode = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_specimen_fixation_methode']);
|
| 261 |
$etiquette_renseignement = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_etiquette_renseignement']);
|
262 |
$etiquette_renseignement = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_etiquette_renseignement']);
|
| 262 |
$nature = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_nature']);
|
- |
|
| 263 |
$parts_total = UtilTruck::extraireNbrePart($collection['ccb_truk_unite_base']);
|
263 |
$nature = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_nature']);
|
| 264 |
$etat_general = $utilTruck->construireTxtListeOntologie($collection['ccb_ce_etat_general']);
|
264 |
$etat_general = $etat_ontologie[$collection['ccb_ce_etat_general']];
|
| 265 |
$etiquette_fixation_support = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_etiquette_fixation_support']);
|
265 |
$etiquette_fixation_support = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_etiquette_fixation_support']);
|
| 266 |
$etiquette_fixation_specimen = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_etiquette_fixation_specimen']);
|
266 |
$etiquette_fixation_specimen = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_etiquette_fixation_specimen']);
|
| 267 |
$degradation_presentation = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_degradation_presentation'], false, true, true);
|
267 |
$degradation_presentation = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_degradation_presentation'], false, true, true);
|
| 268 |
$classement_etat = $utilTruck->construireTxtListeOntologie($collection['ccb_ce_classement_etat']);
|
268 |
$classement_etat = $etat_ontologie[$collection['ccb_ce_classement_etat']];
|
| Line 269... |
Line 269... |
| 269 |
$inventaire = $utilTruck->construireTxtListeOntologie($collection['ccb_ce_inventaire']);
|
269 |
$inventaire = $utilTruck->construireTxtListeOntologie($collection['ccb_ce_inventaire']);
|
| 270 |
|
270 |
|
| 271 |
$collection_affichage = array(
|
271 |
$collection_affichage = array(
|
| 272 |
'id' => $id_collection,
|
272 |
'id' => $id_collection,
|
| 273 |
'cote' => $cote,
|
273 |
'cote' => $cote,
|
| 274 |
'nom' => $nom,
|
274 |
'nom' => $nom,
|
| 275 |
'nom_structure' => $nom_structure,
|
275 |
'nom_structure' => $nom_structure,
|
| 276 |
'id_structure' => $id_structure,
|
276 |
'id_structure' => $id_structure,
|
| - |
|
277 |
'specimen_type' => $specimen_type,
|
| 277 |
'specimen_type' => $specimen_type,
|
278 |
'description' => $description,
|
| 278 |
'description' => $description,
|
279 |
'periode_constitution_debut' => $collection['cc_periode_constitution_debut'],
|
| 279 |
'periode_constitution' => $periode_constitution,
|
280 |
'periode_constitution_fin' => $collection['cc_periode_constitution_fin'],
|
| 280 |
'couverture_lieu' => $couverture_lieu,
|
281 |
'couverture_lieu' => $couverture_lieu,
|
| 281 |
'etiquette_renseignement' => $etiquette_renseignement,
|
282 |
'etiquette_renseignement' => $etiquette_renseignement,
|
| 282 |
'nature' => $nature,
|
283 |
'nature' => $nature,
|
| 283 |
'parts_total' => $parts_total,
|
284 |
'nombre_planches_herbier' => $collection['ccb_nb_planches_herbiers'],
|
| 284 |
'etat_general' => $etat_general,
|
285 |
'etat_general' => $etat_general,
|
| 285 |
'etiquette_fixation_support' => $etiquette_fixation_support,
|
286 |
'etiquette_fixation_support' => $etiquette_fixation_support,
|
| 286 |
'etiquette_fixation_specimen' => $etiquette_fixation_specimen,
|
287 |
'etiquette_fixation_specimen' => $etiquette_fixation_specimen,
|