45 $periode_limit=
$g_user->get_limit_current_exercice();
55 $currency_code=$this->dbconx->get_value(
"select cr_code_iso from currency where id=$1",[$this->currency_id]);
56 return $currency_code;
115 coalesce(oc_amount,0) oc_amount,
121 (select cr_code_iso from currency c where c.id=jrn.currency_id) as currency_code_iso,
122 coalesce (currency_rate,1) currency_rate,
123 coalesce (currency_rate_ref,1) currency_rate_ref,
125 (select ad_value from fiche_detail fd1 where fd1.f_id=jrnx.f_id and ad_id=23) as fiche_qcode
127 join jrn on (jr_grpt_id=jrnx.j_grpt)
128 join operation_currency oc using (j_id)
129 join jrn_def on (jr_def_id=jrn_def.jrn_def_id)
133 $sql.=
" order by j_poste,j_date ";
146 return " where jrn.currency_id = $1 and ".$g_user->get_ledger_sql(
'ALL', 3)
147 .
" and jr_date >= to_date($2,'DD.MM.YYYY')"
148 .
" and jr_date <= to_date($3,'DD.MM.YYYY')"
global $g_user
if no group available , then stop
build the SQL and fetch data of data currency operation from database ,
build_SQL()
build the SQL to execute
SQL_Condition()
build the SQL condition
getDbconx()
Database connection.
__construct($cn, $from_date="", $to_date="", $currency_id=0)
to_currency_code()
retrieve the currency code
setCurrency_id($currency_id)
retrieve currency.od
getCurrency_id()
retrieve currency.od