Line 199... |
Line 199... |
199 |
$projet_id = $this->parametres['projet'];
|
199 |
$projet_id = $this->parametres['projet'];
|
Line 200... |
Line 200... |
200 |
|
200 |
|
201 |
// Construction de la requête
|
201 |
// Construction de la requête
|
202 |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
|
202 |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
|
203 |
' cc_id_collection, '.
|
203 |
' cc_id_collection, '.
|
204 |
' cc_nom, cs_nom, cc_ce_specimen_type, cc_description, cc_truk_periode_constitution, '.
|
204 |
' cc_nom, cc_cote, cs_nom, cc_ce_specimen_type, cc_description, cc_truk_periode_constitution, '.
|
205 |
' cc_truk_couverture_lieu, ccb_truk_etiquette_renseignement, ccb_truk_nature, '.
|
205 |
' cc_truk_couverture_lieu, ccb_truk_etiquette_renseignement, ccb_truk_nature, '.
|
206 |
' ccb_truk_unite_base, ccb_ce_etat_general, ccb_specimen_fixation_pourcent, '.
|
206 |
' ccb_truk_unite_base, ccb_ce_etat_general, ccb_specimen_fixation_pourcent, '.
|
207 |
' ccb_truk_specimen_fixation_methode, ccb_truk_etiquette_fixation_support, '.
|
207 |
' ccb_truk_specimen_fixation_methode, ccb_truk_etiquette_fixation_support, '.
|
208 |
' ccb_truk_etiquette_fixation_specimen, ccb_truk_degradation_presentation, '.
|
208 |
' ccb_truk_etiquette_fixation_specimen, ccb_truk_degradation_presentation, '.
|
Line 231... |
Line 231... |
231 |
|
231 |
|
232 |
// Traitement final des données concernant les structures
|
232 |
// Traitement final des données concernant les structures
|
233 |
foreach ($collections as $collection) {
|
233 |
foreach ($collections as $collection) {
|
234 |
$id_collection = $collection['cc_id_collection'];
|
234 |
$id_collection = $collection['cc_id_collection'];
|
- |
|
235 |
$nom = $collection['cc_nom'];
|
235 |
$nom = $collection['cc_nom'];
|
236 |
$cote = $collection['cc_cote'];
|
236 |
$nom_structure = $collection['cs_nom'];
|
237 |
$nom_structure = $collection['cs_nom'];
|
237 |
$specimen_type = $utilTruck->construireTxtListeOntologie($collection['cc_ce_specimen_type']);
|
238 |
$specimen_type = $utilTruck->construireTxtListeOntologie($collection['cc_ce_specimen_type']);
|
238 |
$description = $collection['cc_description'];
|
239 |
$description = $collection['cc_description'];
|
239 |
$periode_constitution = $utilTruck->construireTxtListeOntologie($collection['cc_truk_periode_constitution']);
|
240 |
$periode_constitution = $utilTruck->construireTxtListeOntologie($collection['cc_truk_periode_constitution']);
|
Line 250... |
Line 251... |
250 |
$classement_etat = $utilTruck->construireTxtListeOntologie($collection['ccb_ce_classement_etat']);
|
251 |
$classement_etat = $utilTruck->construireTxtListeOntologie($collection['ccb_ce_classement_etat']);
|
251 |
$inventaire = $utilTruck->construireTxtListeOntologie($collection['ccb_ce_inventaire']);
|
252 |
$inventaire = $utilTruck->construireTxtListeOntologie($collection['ccb_ce_inventaire']);
|
Line 252... |
Line 253... |
252 |
|
253 |
|
253 |
$collection_affichage = array(
|
254 |
$collection_affichage = array(
|
- |
|
255 |
'id' => $id_collection,
|
254 |
'id' => $id_collection,
|
256 |
'cote' => $cote,
|
255 |
'nom' => $nom,
|
257 |
'nom' => $nom,
|
256 |
'nom_structure' => $nom_structure,
|
258 |
'nom_structure' => $nom_structure,
|
257 |
'specimen_type' => $specimen_type,
|
259 |
'specimen_type' => $specimen_type,
|
258 |
'description' => $description,
|
260 |
'description' => $description,
|