65 $prepare=$this->
db->is_prepare(
"reconcile_date");
68 $this->
db->prepare(
'reconcile_date',
70 , (select ad_value from fiche_detail where ad_id=23 and f_id=jrn_def.jrn_def_bank ) as qcode_bank
71 , (select ad_value from fiche_detail where ad_id=1 and f_id=jrn_def.jrn_def_bank ) as qcode_name
74 join jrn_def on (jrn.jr_def_id=jrn_def.jrn_def_id)
86 where jra_concerned=$1)');
94 $prepare=$this->
db->is_prepare(
"amount_cur");
98 $this->
db->prepare(
"amount_cur",
100 sum(coalesce(oc_amount,0)) as sum_ocamount
101 from operation_currency
102 join jrnx using (j_id)
103 join jrn as jrn2 on (j_grpt=jrn2.jr_grpt_Id)
105 j_id in (select j_id from jrnx where j_grpt=jrn2.jr_grpt_id )
contains the class for connecting to Noalyss
contains prepared query used in different classes of the application
__construct(Database $cn)
prepare_reconcile_date()
Prepare the query for fetching the linked operation.
prepare_currency()
Prepare the query for find the amount in currency.