29 require_once DIR_IMPORT_ACCOUNT.
"/include/class_impacc_csv.php";
30 require_once DIR_IMPORT_ACCOUNT.
"/include/class_impacc_operation.php";
31 require_once DIR_IMPORT_ACCOUNT.
"/database/class_impacc_import_file_sql.php";
32 require_once DIR_IMPORT_ACCOUNT.
"/database/class_impacc_import_csv_sql.php";
52 if (trim($_FILES[
'file_operation'][
'name'])==
'')
54 alert(_(
'Pas de fichier donné'));
57 $format=HtmlInput::default_value_post(
"format", -1);
59 if (!isset(self::$aformat[
$format]))
61 alert(_(
"Format inconnu"));
64 $this->format=self::$aformat[
$format];
65 $this->filename=tempnam($_ENV[
'TMP'],
'upload_');
66 if (!move_uploaded_file($_FILES[
"file_operation"][
"tmp_name"],
69 throw new Exception(_(
"Fichier non sauvé"), 1);
71 $cn=Dossier::connect();
73 $imp->setp(
'i_tmpname', $this->filename);
74 $imp->setp(
'i_filename', $_FILES[
'file_operation'][
'name']);
75 $imp->setp(
"i_type", self::$aformat[$format]);
77 $cn->exec_sql(
"update impacc.import_file set i_date_transfer=now() where id=$1",
79 $this->import_file=$imp;
80 $this->impid=$imp->getp(
"id");
83 if ($imp->i_type==
"CSV")
88 $csv->set_import($this->impid);
90 $csv->check_setting();
95 error_log($ex->getTraceAsString());
96 echo _(
"Format invalide"),
" : ",$ex->getMessage();
102 $cn=Dossier::connect();
110 $operation->record_file($this);
111 $cn=Dossier::connect();
112 $cn->exec_sql(
"update impacc.import_file set i_date_transfer=now() where id=$1",
113 array($this->import_file->id));
121 $file=
new IFile(
"file_operation");
125 array(
"value"=>0,
"label"=>
"-"),
126 array(
"value"=>1,
"label"=>
"CSV")
128 $format->javascript=
"onchange=\"ctl_display()\"";
129 require_once DIR_IMPORT_ACCOUNT.
"/template/input_file.php";
135 if ($this->import_file->i_type==
'CSV')
138 $operation->check($this);
145 if ($this->import_file->i_type==
'CSV')
148 $operation->result($this);
154 if ($this->import_file->i_type==
'CSV')
157 $operation->load_import($this->impid);
158 $operation->transfer();
165 if ($this->import_file->i_type ==
'CSV')
167 $cn=Dossier::connect();
171 $operation->load_import($this->import_file->id);
173 $ledger=
new Acc_Ledger(
$cn,$operation->detail->jrn_def_id);
175 printf(_(
"Importation dans le journal %s"),
$ledger->get_name());
177 $operation->result($this);
182 $cn=Dossier::connect();
189 to_char(i_date_transfer,'DD.MM.YY HH:MI') as stransfer,
190 to_char(i_date_import,'DD.MM.YY HH:MI') as simport,
191 to_char(i_date_transfer,'YYYYMMDDHHMI') as sorder_transfer
194 order by i_date_transfer desc
197 require_once DIR_IMPORT_ACCOUNT.
"/template/history_file.php";
202 $cn=Dossier::connect();
203 $cn->exec_sql(
"delete from impacc.import_file where id=$1",array(
$id));
result()
Display the rows of the imported file and a status for each row.
check()
Check the rows of the imported file.
$import_file
Impacc_Import_file_SQL $impid.
record()
Load the file in a temporary table.
Used by all Import CSV Operation , contains the setting (delimiter,thousand ...)
if(isset($_POST['remove'])) $array
transfer()
Transfer to accountancy.
input_file()
Display the parameters and the file to upload.
save_file()
Save the uploaded file and CSV setting if it is CSV import.
result_transfer()
Show the result of the file import.
Redirect to CSV or other format.