22 require_once NOALYSS_INCLUDE.
"/lib/class_noalyss_csv.php";
38 $cn=Dossier::connect();
43 $this->date_start=$lim[0]->first_day();
44 $this->date_end=$lim[1]->last_day();
52 $cn=Dossier::connect();
53 $l=
new Acc_Ledger(
$cn, $this->ledger);
54 $select_ledger=$l->select_ledger();
56 $date_start=
new IDate(
"date_start", $this->date_start);
57 $date_end=
new IDate(
"date_end", $this->date_end);
59 require DIR_IMPORT_ACCOUNT.
"/template/export_param.php";
66 $this->ledger=HtmlInput::default_value_request(
"p_jrn", 0);
67 $this->date_start=HtmlInput::default_value_request(
"date_start", 0);
68 $this->date_end=HtmlInput::default_value_request(
"date_end", 0);
75 $cn=Dossier::connect();
77 $cvs=
new Noalyss_Csv(
"ledger".
$ledger->get_name());
104 throw new Exception(_(
"Journal invalide"));
113 $cn=Dossier::connect();
116 to_char(jr_date,'DD.MM.YYYY') as sdate,
118 (select ad_value from fiche_detail where f_id=qs_client and ad_id=23) as qcode,
121 (select ad_value from fiche_detail where f_id=qs_fiche and ad_id=23) as qcode_serv,
125 qs_price+qs_vat as price_tax,
126 to_char(jr_ech,'DD.MM.YYYY') slimit,
127 to_char(jr_date_paid,'DD.MM.YYYY') sdatepaid
129 join jrnx on (j_grpt=jr_grpt_id)
130 join public.quant_sold using (j_id)
132 jr_date <= to_date($1,'DD.MM.YYYY') and
133 jr_date >= to_date($2,'DD.MM.YYYY') and
135 order by jr_date,j_id
138 array($this->date_end, $this->date_start, $this->ledger));
139 $nb=Database::num_row(
$ret);
140 for ($i=0; $i<$nb; $i++)
142 $row=Database::fetch_array(
$ret, $i);
143 $p_csv->add(
$row[
"sdate"]);
144 $p_csv->add(
$row[
"jr_id"]);
145 $p_csv->add(
$row[
"qcode"]);
146 $p_csv->add(
$row[
"jr_pj"]);
147 $p_csv->add(
$row[
"jr_comment"]);
148 $p_csv->add(
$row[
"qcode_serv"]);
149 $p_csv->add(
$row[
"qs_unit"],
"number");
150 $p_csv->add(
$row[
"qs_price"],
"number");
151 $p_csv->add(
$row[
"qs_vat_code"]);
152 $p_csv->add(
$row[
"price_tax"],
"number");
153 $p_csv->add(
$row[
"slimit"]);
154 $p_csv->add(
$row[
"sdatepaid"]);
164 $cn=Dossier::connect();
168 to_char(jr_date,'DD.MM.YYYY') as sdate,
170 (select ad_value from fiche_detail where f_id=qp_supplier and ad_id=23) as qcode,
173 (select ad_value from fiche_detail where f_id=qp_fiche and ad_id=23) as qcode_serv,
177 qp_price+qp_vat as price_tax,
178 to_char(jr_ech,'DD.MM.YYYY') slimit,
179 to_char(jr_date_paid,'DD.MM.YYYY') sdatepaid
181 join jrnx on (j_grpt=jr_grpt_id)
182 join public.quant_purchase using (j_id)
184 jr_date <= to_date($1,'DD.MM.YYYY') and
185 jr_date >= to_date($2,'DD.MM.YYYY') and
187 order by jr_date,j_id
190 array($this->date_end, $this->date_start, $this->ledger));
191 $nb=Database::num_row(
$ret);
192 for ($i=0; $i<$nb; $i++)
194 $row=Database::fetch_array(
$ret, $i);
195 $p_csv->add(
$row[
"sdate"]);
196 $p_csv->add(
$row[
"jr_id"]);
197 $p_csv->add(
$row[
"qcode"]);
198 $p_csv->add(
$row[
"jr_pj"]);
199 $p_csv->add(
$row[
"jr_comment"]);
200 $p_csv->add(
$row[
"qcode_serv"]);
201 $p_csv->add(
$row[
"qp_unit"],
"number");
202 $p_csv->add(
$row[
"qp_price"],
"number");
203 $p_csv->add(
$row[
"qp_vat_code"]);
204 $p_csv->add(
$row[
"price_tax"],
"number");
205 $p_csv->add(
$row[
"slimit"]);
206 $p_csv->add(
$row[
"sdatepaid"]);
216 $cn=Dossier::connect();
220 to_char(jr_date,'DD.MM.YYYY') as sdate,
221 (select ad_value from fiche_detail where f_id=qf_other and ad_id=23) as qcode,
227 join jrn using (jr_id)
229 jr_date <= to_date($1,'DD.MM.YYYY') and
230 jr_date >= to_date($2,'DD.MM.YYYY') and
235 array($this->date_end, $this->date_start, $this->ledger));
236 $nb=Database::num_row(
$ret);
237 for ($i=0; $i<$nb; $i++)
239 $row=Database::fetch_array(
$ret, $i);
240 $p_csv->add(
$row[
"sdate"]);
241 $p_csv->add(
$row[
"jr_id"]);
242 $p_csv->add(
$row[
"qcode"]);
243 $p_csv->add(
$row[
"jr_pj_number"]);
244 $p_csv->add(
$row[
"jr_comment"]);
245 $p_csv->add(
$row[
"qf_amount"]);
255 $cn=Dossier::connect();
258 to_char(jr_date,'DD.MM.YYYY') as sdate,
260 coalesce(j_qcode,j_poste) as qcode,
264 case when j_debit = false then 'C'
269 join jrnx on (jr_grpt_id=j_grpt)
271 jr_date <= to_date($1,'DD.MM.YYYY') and
272 jr_date >= to_date($2,'DD.MM.YYYY') and
276 array($this->date_end, $this->date_start, $this->ledger));
277 $nb=Database::num_row(
$ret);
278 for ($i=0; $i<$nb; $i++)
280 $row=Database::fetch_array(
$ret, $i);
281 $p_csv->add(
$row[
"sdate"]);
282 $p_csv->add(
$row[
"jr_id"]);
283 $p_csv->add(
$row[
"qcode"]);
284 $p_csv->add(
$row[
"jr_pj_number"]);
285 $p_csv->add(
$row[
"jr_comment"]);
286 $p_csv->add(
$row[
"j_montant"],
"number");
287 $p_csv->add(
$row[
"deb"]);
$ledger
Ledger id (jrn_def.jrn_def_id.
export_misc(Noalyss_Csv $p_csv)
Export ODS ledger.
export_sale(Noalyss_Csv $p_csv)
Export a ledger of Sale.
for($i=0;$i< Database::num_row($ret);$i++) $row
$type
Retrouve le type de row si == 3.
input_param()
Show a form to input the parameter , ledger , stard and end date.
export_fin(Noalyss_Csv $p_csv)
Export a financial ledger.
export_purchase(Noalyss_Csv $p_csv)
Export a ledger of Purchase.