Prepared_Query Class Reference

contains prepared query used in different classes of the application More...

Collaboration diagram for Prepared_Query:

Public Member Functions
	__construct (Database $cn)
	get_db ()
	prepare_currency ()
	Prepare the query for find the amount in currency. More...
	prepare_reconcile_date ()
	Prepare the query for fetching the linked operation. More...
	set_db ($db)

Private Attributes
	$db
	Database connection. More...

Detailed Description

contains prepared query used in different classes of the application

Definition at line 35 of file prepared_query.class.php.

Constructor & Destructor Documentation

__construct()

Prepared_Query::__construct

(

Database

$cn

)

Definition at line 38 of file prepared_query.class.php.

    {
        $this->db=$cn;
    }

References $cn, and db.

Member Function Documentation

get_db()

Prepared_Query::get_db

(

)

Definition at line 43 of file prepared_query.class.php.

    {
        return $this->db;
    }

References $db.

prepare_currency()

Prepared_Query::prepare_currency

(

)

Prepare the query for find the amount in currency.

Definition at line 92 of file prepared_query.class.php.

    {
        $prepare=$this->db->is_prepare("amount_cur");
        if ($prepare==FALSE)
        {
 
            $this->db->prepare("amount_cur",
                    "select jrn2.jr_id , 
                    sum(coalesce(oc_amount,0)) as sum_ocamount
                from operation_currency
                    join jrnx using (j_id)
                    join jrn as jrn2 on (j_grpt=jrn2.jr_grpt_Id) 
                where 
                    j_id in (select j_id from jrnx where j_grpt=jrn2.jr_grpt_id )
                    and  jr_id=$1
                    group by jr_id"
            );
        }
    }

References db.

prepare_reconcile_date()

Prepared_Query::prepare_reconcile_date

(

)

Prepare the query for fetching the linked operation.

ONE paramete is needed : jrn.jr_id , returns all columns from the table PUBLIC.JRN, column qcode_bank (default card for fin ledger) of the operation concerning to the payment

See also

export_ledger_pdf.php

Acc_Ledger_History

Definition at line 63 of file prepared_query.class.php.

    {
        $prepare=$this->db->is_prepare("reconcile_date");
        if ($prepare==FALSE)
        {
            $this->db->prepare('reconcile_date',
                    'select  * 
                        , (select ad_value from fiche_detail where ad_id=23 and f_id=jrn_def.jrn_def_bank ) as qcode_bank
                        , (select ad_value from fiche_detail where ad_id=1 and f_id=jrn_def.jrn_def_bank ) as qcode_name
                         from 
                           jrn 
                           join jrn_def on (jrn.jr_def_id=jrn_def.jrn_def_id)
                         where 
                           jr_id in 
                               (select 
                                   jra_concerned 
                                   from 
                                   jrn_rapt 
                                   where jr_id = $1 
                                union all 
                                select 
                                jr_id 
                                from jrn_rapt 
                                where jra_concerned=$1)');
        }
    }

References db.

set_db()

Prepared_Query::set_db

(

$db

)

Definition at line 48 of file prepared_query.class.php.

    {
        $this->db=$db;
        return $this;
    }

References $db, and db.

Field Documentation

$db

Prepared_Query::$db

private

Database connection.

Definition at line 36 of file prepared_query.class.php.

Referenced by get_db(), and set_db().

---

The documentation for this class was generated from the following file:

• include/class/prepared_query.class.php