199,7 → 199,7 |
public function getElementExport($param) { |
// Initialisation des variables |
$info = array(); |
$p = $this->traiterParametresUrl(array("ref","version","champs","filtre"), $param, false); |
$p = $this->traiterParametresUrl(array("ref","version","champs","filtre", "encodage"), $param, false); |
$ref = $p['ref'].'_v'.$p['version']; |
$racine_tmp = $this->config['chemins']['chemin_tmp']; |
$dossier = $racine_tmp.date('Y_m_d').'/'; |
211,9 → 211,10 |
if (isset($p['champs'])) { |
$champs = $this->formaterColonnes($p['champs'], $ref); |
$requete = 'SELECT "'.implode('","', $champs['titre']).'" UNION (SELECT '.implode(', ',$champs['select']). |
" INTO OUTFILE '".$fichier."' CHARACTER SET utf8 FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' ". |
" INTO OUTFILE '".$fichier."' CHARACTER SET ".$p['encodage']." FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' ". |
" FROM $ref a left join $ref b on b.num_nom=a.num_nom_retenu"; |
|
|
if (isset($p['filtre']) && $p['filtre'] != "*") { |
$param_filtres = explode(",",$p["filtre"]); |
$dernier_filtre = array_pop($param_filtres); |