26 require_once DIR_IMPORT_ACCOUNT.
"/include/class_impacc_csv.php";
39 $hFile=fopen($p_file->import_file->i_tmpname,
"r");
41 $cn=Dossier::connect();
42 $delimiter=$aseparator[$p_csv->detail->s_delimiter-1][
'label'];
43 $surround=($p_csv->detail->s_surround==
"")?
'"':$p_csv->detail->s_surround;
45 while (
$row=fgetcsv($hFile, 0, $delimiter, $surround))
48 $insert->import_id=$p_file->import_file->id;
52 $insert->id_status=-1;
53 $insert->id_message=join(
$row,$delimiter);
57 $insert->id_date=
$row[0];
58 $insert->id_code_group=
$row[1];
59 $insert->id_acc=
$row[2];
60 $insert->id_pj=
$row[3];
61 $insert->id_label=
$row[4];
62 $insert->id_amount_novat=
$row[5];
63 $insert->id_debit=
$row[6];
79 $cn=Dossier::connect();
89 (select f_id from fiche_detail where ad_value=id_acc and ad_id=23) as f_id ,
99 and id_code_group=$2";
100 $all_row=
$cn->get_array($sql_row,
101 array($p_row[
'import_id'],$p_row[
'id_code_group']));
104 $g_parameter->MY_ANALYTIC=
"N";
110 $array[
'nb_item']=count($all_row);
111 $array[
'e_comm']=$all_row[0][
'id_label'];
112 $array[
'desc']=$all_row[0][
'id_label'];
113 $array[
'jrn_concerned']=
"";
115 $array[
'e_pj']=$all_row[0][
'id_pj'];
116 $array[
'e_date']=$all_row[0][
'id_date_conv'];
123 $price=$all_row[$i][
'id_amount_novat_conv'];
124 if ( $all_row[$i][
'id_debit'] ==
"D") {
127 if ($all_row[$i][
'f_id']==
"")
129 $array[
"poste".$i]=$all_row[$i][
"id_acc"];
131 $array[
"qc_".$i]=$all_row[$i][
"id_acc"];
133 $array[
"amount".$i]=$price;
134 $array[
"ld".$i]=$all_row[$i][
"id_label"];
141 function insert($a_group, Acc_Ledger $p_ledger)
143 $cn=Dossier::connect();
144 $nb_group=count($a_group);
145 for ( $i=0;$i< $nb_group;$i++)
150 $array[
"p_jrn"]=$p_ledger->id;
153 if (trim(
$array[
'e_pj'])==
"")
$array[
"e_pj"]=$p_ledger->guess_pj();
154 $array[
'e_pj_suggest']=$p_ledger->guess_pj();
161 $cn->exec_sql(
"update impacc.import_detail set jr_id=$1 , id_status=2 where id_code_group=$2",
162 array($p_ledger->jr_id,$a_group[$i][
'id_code_group']));
check(Impacc_Import_detail_SQL $row)
Check if Data are valid for one row.
while(($row=fgetcsv($fbank, 0, $sp))!==false)
for($i=0;$i< Database::num_row($ret);$i++) $row
record(Impacc_Csv $p_csv, Impacc_File $p_file)
insert file into the table import_detail
if(isset($_POST['remove'])) $array
adapt($p_row)
Transform a group of rows to an array and set $jr_date_paid.
insert($a_group, Acc_Ledger $p_ledger)
Transfer operation with the status correct to the accountancy .