Line 195... |
Line 195... |
195 |
private function getServiceCollectionExpertise() {
|
195 |
private function getServiceCollectionExpertise() {
|
Line 196... |
Line 196... |
196 |
|
196 |
|
197 |
// Construction de la requête
|
197 |
// Construction de la requête
|
198 |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
|
198 |
$requete = 'SELECT '.(($this->distinct) ? 'DISTINCT' : '').' '.
|
- |
|
199 |
' cc_id_collection, '.
|
199 |
' cc_id_collection, '.
|
200 |
' cc_ce_structure, '.
|
200 |
' cc_nom, cc_cote, cs_nom, cc_ce_specimen_type, cc_description, cc_truk_periode_constitution, '.
|
201 |
' cc_nom, cc_cote, cs_nom, cc_ce_specimen_type, cc_description, cc_truk_periode_constitution, '.
|
201 |
' cc_truk_couverture_lieu, ccb_truk_etiquette_renseignement, ccb_truk_nature, '.
|
202 |
' cc_truk_couverture_lieu, ccb_truk_etiquette_renseignement, ccb_truk_nature, '.
|
202 |
' ccb_truk_unite_base, ccb_ce_etat_general, ccb_specimen_fixation_pourcent, '.
|
203 |
' ccb_truk_unite_base, ccb_ce_etat_general, ccb_specimen_fixation_pourcent, '.
|
203 |
' ccb_truk_specimen_fixation_methode, ccb_truk_etiquette_fixation_support, '.
|
204 |
' ccb_truk_specimen_fixation_methode, ccb_truk_etiquette_fixation_support, '.
|
Line 227... |
Line 228... |
227 |
// Traitement final des données concernant les structures
|
228 |
// Traitement final des données concernant les structures
|
228 |
foreach ($collections as $collection) {
|
229 |
foreach ($collections as $collection) {
|
229 |
$id_collection = $collection['cc_id_collection'];
|
230 |
$id_collection = $collection['cc_id_collection'];
|
230 |
$nom = $collection['cc_nom'];
|
231 |
$nom = $collection['cc_nom'];
|
231 |
$cote = $collection['cc_cote'];
|
232 |
$cote = $collection['cc_cote'];
|
- |
|
233 |
$id_structure = $collection['cc_ce_structure'];
|
232 |
$nom_structure = $collection['cs_nom'];
|
234 |
$nom_structure = $collection['cs_nom'];
|
233 |
$specimen_type = $utilTruck->construireTxtListeOntologie($collection['cc_ce_specimen_type']);
|
235 |
$specimen_type = $utilTruck->construireTxtListeOntologie($collection['cc_ce_specimen_type']);
|
234 |
$description = $collection['cc_description'];
|
236 |
$description = $collection['cc_description'];
|
235 |
$periode_constitution = $utilTruck->construireTxtListeOntologie($collection['cc_truk_periode_constitution']);
|
237 |
$periode_constitution = $utilTruck->construireTxtListeOntologie($collection['cc_truk_periode_constitution']);
|
236 |
$couverture_lieu = $utilTruck->construireTxtListeOntologie($collection['cc_truk_couverture_lieu']);
|
238 |
$couverture_lieu = $utilTruck->construireTxtListeOntologie($collection['cc_truk_couverture_lieu']);
|
Line 249... |
Line 251... |
249 |
$collection_affichage = array(
|
251 |
$collection_affichage = array(
|
250 |
'id' => $id_collection,
|
252 |
'id' => $id_collection,
|
251 |
'cote' => $cote,
|
253 |
'cote' => $cote,
|
252 |
'nom' => $nom,
|
254 |
'nom' => $nom,
|
253 |
'nom_structure' => $nom_structure,
|
255 |
'nom_structure' => $nom_structure,
|
- |
|
256 |
'id_structure' => $id_structure,
|
254 |
'specimen_type' => $specimen_type,
|
257 |
'specimen_type' => $specimen_type,
|
255 |
'description' => $description,
|
258 |
'description' => $description,
|
256 |
'periode_constitution' => $periode_constitution,
|
259 |
'periode_constitution' => $periode_constitution,
|
257 |
'couverture_lieu' => $couverture_lieu,
|
260 |
'couverture_lieu' => $couverture_lieu,
|
258 |
'etiquette_renseignement' => $etiquette_renseignement,
|
261 |
'etiquette_renseignement' => $etiquette_renseignement,
|