Subversion Repositories Applications.referentiel

Rev

Rev 341 | Rev 349 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 341 Rev 342
Line 206... Line 206...
206 
		if(!is_dir($dossier)){
 206 
		if(!is_dir($dossier)){
207 
			mkdir($dossier);
 207 
			mkdir($dossier);
208 
			chmod($dossier, 0777);
 208 
			chmod($dossier, 0777);
209 
		}
 209 
		}
210 
		$fichier = $dossier.$ref."_".time().'.csv';
210 
		$fichier = $dossier.$ref."_".time().'.csv';
- 
 
 211 
		if (isset($p['champs'])) {
211 
		$champs = $this->formaterColonnes($p['champs'], $ref);
 212 
			$champs = $this->formaterColonnes($p['champs'], $ref);
212 
		$requete = 'SELECT "'.implode('","', $champs['titre']).'" UNION (SELECT '.implode(', ',$champs['select']).
 213 
			$requete = 'SELECT "'.implode('","', $champs['titre']).'" UNION (SELECT '.implode(', ',$champs['select']).
213 
			" INTO OUTFILE '".$fichier."' CHARACTER SET utf8 FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' ".
214 
				" INTO OUTFILE '".$fichier."' CHARACTER SET utf8 FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' ".
214 
		" FROM $ref a left join $ref b on b.num_nom=a.num_nom_retenu";
 215 
			" FROM $ref a left join $ref b on b.num_nom=a.num_nom_retenu";
Line 234... Line 235...
234 
				$info = $donnees;
 235 
					$info = $donnees;
235 
			}
 236 
				}
236 
		} catch (PDOException $e) {
 237 
			} catch (PDOException $e) {
237 
			$this->messages[] = sprintf($this->getTxt('sql_erreur'), $e->getFile(), $e->getLine(), $e->getMessage()).$requete;
 238 
				$this->messages[] = sprintf($this->getTxt('sql_erreur'), $e->getFile(), $e->getLine(), $e->getMessage()).$requete;
238 
		}
 239 
			}
- 
 
 240 
		}
Line 239... Line 241...
239
241
240 
		return $fichier;
 242 
		return $fichier;
Line 241... Line 243...
241 
	}
 243 
	}