37 parent::__construct(
$cn, $pa_ledger, $p_from, $p_to, $p_mode);
38 $this->ledger_type=
'FIN';
46 $this->ma_ledger, $this->m_from, $this->m_to, $this->m_mode);
47 $ledger_history->export_accounting_html();
58 $this->ma_ledger, $this->m_from, $this->m_to, $this->m_mode);
59 $ledger_history->export_accounting_html();
67 switch ($this->m_mode)
94 require_once NOALYSS_TEMPLATE.
'/acc_ledger_history_financial_oneline.php';
103 public function get_row($p_limit=-1, $p_offset=
"")
108 $cond_limite=($p_limit!=-1)?
" limit ".$p_limit.
" offset ".$p_offset:
"";
110 $ledger_list=join(
",", $this->ma_ledger);
113 select x.f_id as f_id,
114 (select ad_value from fiche_detail where ad_id=1 and f_id=x.f_id) as name,
115 (select ad_value from fiche_detail where ad_id=32 and f_id=x.f_id) as first_name,
116 (select ad_value from fiche_detail where ad_id=23 and f_id=x.f_id) as qcode
122 bk.first_name as bk_first_name,
123 bk.qcode as bk_qcode,
124 tiers.f_id as tiers_f_id,
125 tiers.name as tiers_name,
126 tiers.first_name as tiers_first_name,
127 tiers.qcode as tiers_qcode,
130 to_char(jr_date,'DD.MM.YYYY') as str_date,
131 to_char(jr_date_paid,'DD.MM.YYYY') as str_date_paid,
144 join quant_fin using (jr_id)
145 join detail as tiers on (tiers.f_id=qf_other)
146 join detail as bk on (bk.f_id=qf_bank)
147 left join operation_currency using(j_id)
148 join currency on (currency.id=jrn.currency_id)
150 jr_def_id in ({$ledger_list})
153 order by jr_date, substring(jr_pj_number,'[0-9]+$')::numeric ";
154 $this->data=$this->
db->get_array(
$sql);
sql_filter_per($p_cn, $p_from, $p_to, $p_form='p_id', $p_field='jr_tech_per')
Create the condition to filter on the j_tech_per thanks a from and to date.
display financial operations in HTML , PDF or CSV
export_extended_html()
display extended details of operation m_mode=E
export_html()
display in HTML following the mode
export_oneline_html()
display in HTML one operation by line
export_detail_html()
display detail of operations m_mode=D
__construct(Database $cn, $pa_ledger, $p_from, $p_to, $p_mode)
get_row($p_limit=-1, $p_offset="")
Get the rows from jrnx and quant* tables.
export_accounting_html()
display the accounting
manage the list of operation when we need several ledger with a different type or from Misceleaneous ...
Display history of operation.
prepare_reconcile_date()
Prepare the query for fetching the linked operation @staticvar int $prepare.
contains the class for connecting to Noalyss