Subversion Repositories Applications.referentiel

	}

	public function getElementExport($param) {

		// Initialisation des variables

		$info = array();

		$champs = array("titre", "code", "version", "domaine_taxo", "domaine_geo", "domaine_nom", "classification", "coordinateur", "auteur", "contributeur", "date_production", "source", "contact", "editeur", "droit", "licence", "referencement");

		$p = $this->traiterParametresUrl(array("ref","version"), $param, false);

		$fichier = '/home/delphine/tmp/'.date('Y_m_d')."/meta_".$p['version']."_".time().'.csv';

		$requete = "SELECT '".implode("', '", $champs)."' UNION ( SELECT ".implode(", ", $champs).

				" INTO OUTFILE '".

			$fichier."' CHARACTER SET utf8 FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' ". 

			" FROM ".$p['ref']."_meta WHERE version = '".str_replace("_", ".", $p['version'])."')";

		// Récupération des résultats

		try {

			$donnees = $this->bdd->query($requete);

			if ($donnees === false) {

				$this->messages[] = "La requête a retourné aucun résultat : $requete";

			} else {

				$info = $donnees;

			}

		} catch (PDOException $e) {

			$this->messages[] = sprintf($this->getTxt('sql_erreur'), $e->getFile(), $e->getLine(), $e->getMessage()).$requete;

		}

		return $fichier;