Line 201... |
Line 201... |
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, 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_truk_etiquette_fixation_support, '.
|
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_etiquette_fixation_specimen, ccb_truk_degradation_presentation, '.
|
208 |
' ccb_truk_etiquette_fixation_specimen, ccb_truk_degradation_presentation, '.
|
208 |
' ccb_ce_classement_etat, ccb_ce_inventaire '.
|
209 |
' ccb_ce_classement_etat, ccb_ce_inventaire '.
|
209 |
'FROM coel_collection '.
|
210 |
'FROM coel_collection '.
|
210 |
' LEFT JOIN coel_collection_botanique ON (cc_id_collection = ccb_id_collection) '.
|
211 |
' LEFT JOIN coel_collection_botanique ON (cc_id_collection = ccb_id_collection) '.
|
211 |
' LEFT JOIN coel_structure ON (cs_id_structure = cc_ce_structure) '.
|
212 |
' LEFT JOIN coel_structure ON (cs_id_structure = cc_ce_structure) '.
|
Line 235... |
Line 236... |
235 |
$nom_structure = $collection['cs_nom'];
|
236 |
$nom_structure = $collection['cs_nom'];
|
236 |
$specimen_type = $utilTruck->construireTxtListeOntologie($collection['cc_ce_specimen_type']);
|
237 |
$specimen_type = $utilTruck->construireTxtListeOntologie($collection['cc_ce_specimen_type']);
|
237 |
$description = $collection['cc_description'];
|
238 |
$description = $collection['cc_description'];
|
238 |
$periode_constitution = $utilTruck->construireTxtListeOntologie($collection['cc_truk_periode_constitution']);
|
239 |
$periode_constitution = $utilTruck->construireTxtListeOntologie($collection['cc_truk_periode_constitution']);
|
239 |
$couverture_lieu = $utilTruck->construireTxtListeOntologie($collection['cc_truk_couverture_lieu']);
|
240 |
$couverture_lieu = $utilTruck->construireTxtListeOntologie($collection['cc_truk_couverture_lieu']);
|
- |
|
241 |
$specimen_fixation_pourcent = $collection['ccb_specimen_fixation_pourcent'];
|
- |
|
242 |
$specimen_fixation_methode = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_specimen_fixation_methode']);
|
240 |
$etiquette_renseignement = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_etiquette_renseignement']);
|
243 |
$etiquette_renseignement = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_etiquette_renseignement']);
|
241 |
$nature = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_nature']);
|
244 |
$nature = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_nature']);
|
242 |
$parts_total = UtilTruck::extraireNbrePart($collection['ccb_truk_unite_base']);
|
245 |
$parts_total = UtilTruck::extraireNbrePart($collection['ccb_truk_unite_base']);
|
243 |
$etat_general = $utilTruck->construireTxtListeOntologie($collection['ccb_ce_etat_general']);
|
246 |
$etat_general = $utilTruck->construireTxtListeOntologie($collection['ccb_ce_etat_general']);
|
244 |
$etiquette_fixation_support = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_etiquette_fixation_support']);
|
247 |
$etiquette_fixation_support = $utilTruck->construireTxtListeOntologie($collection['ccb_truk_etiquette_fixation_support']);
|
Line 259... |
Line 262... |
259 |
'nature' => $nature,
|
262 |
'nature' => $nature,
|
260 |
'parts_total' => $parts_total,
|
263 |
'parts_total' => $parts_total,
|
261 |
'etat_general' => $etat_general,
|
264 |
'etat_general' => $etat_general,
|
262 |
'etiquette_fixation_support' => $etiquette_fixation_support,
|
265 |
'etiquette_fixation_support' => $etiquette_fixation_support,
|
263 |
'etiquette_fixation_specimen' => $etiquette_fixation_specimen,
|
266 |
'etiquette_fixation_specimen' => $etiquette_fixation_specimen,
|
- |
|
267 |
'specimen_fixation_pourcent' => $specimen_fixation_pourcent,
|
- |
|
268 |
'specimen_fixation_methode' => $specimen_fixation_methode,
|
264 |
'degradation_presentation' => $degradation_presentation,
|
269 |
'degradation_presentation' => $degradation_presentation,
|
265 |
'classement_etat' => $classement_etat,
|
270 |
'classement_etat' => $classement_etat,
|
266 |
'inventaire' => $inventaire);
|
271 |
'inventaire' => $inventaire);
|
267 |
$collection_affichage = $this->nettoyerTableau($collection_affichage);
|
272 |
$collection_affichage = $this->nettoyerTableau($collection_affichage);
|