build the SQL and fetch data of data currency operation from database , More...

Inheritance diagram for Data_Currency_Operation:

Collaboration diagram for Data_Currency_Operation:

Public Member Functions
	__construct ($cn, $from_date="", $to_date="", $currency_id=0)

	build_SQL ()
	build the SQL to execute More...

	get_data ()
	returns data More...

	getCurrency_id ()
	retrieve currency.od More...

	getDbconx ()
	Database connection. More...

	getFrom_date ()

	getTo_date ()

	setCurrency_id ($currency_id)
	retrieve currency.od More...

	setDbconx ($dbconx)

	setFrom_date ($from_date)

	setTo_date ($to_date)

	SQL_Condition ()
	build the SQL condition More...

	to_currency_code ()
	retrieve the currency code More...

Private Attributes
	$currency_id

	$dbconx

	$from_date

	$to_date

Detailed Description

build the SQL and fetch data of data currency operation from database ,

Definition at line 31 of file data_currency_operation.class.php.

Constructor & Destructor Documentation

◆ __construct()

Data_Currency_Operation::__construct	(	$cn,
		$from_date = `""`,
		$to_date = `""`,
		$currency_id = `0`
	)

Definition at line 39 of file data_currency_operation.class.php.

    {
        global $g_user;
        $this->dbconx=$cn;
        $this->currency_id=$currency_id;
 
        $periode_limit=$g_user->get_limit_current_exercice();
        $this->from_date=($from_date=="")?$periode_limit[0]:$from_date;
        $this->to_date=($to_date=="")?$periode_limit[1]:$to_date;
    }

References $cn, $currency_id, $from_date, $g_user, and $to_date.

Member Function Documentation

◆ build_SQL()

Data_Currency_Operation::build_SQL ( )

build the SQL to execute

Definition at line 110 of file data_currency_operation.class.php.

    {
        $sql=" select jr_id,
            j_date,
            j_montant,
            coalesce(oc_amount,0) oc_amount,
            j_poste,
            jr_comment,
            jr_internal,
            jr_pj_number,
            jrn.currency_id,
            (select cr_code_iso from currency c where c.id=jrn.currency_id) as currency_code_iso,
            coalesce (currency_rate,1) currency_rate,
            coalesce (currency_rate_ref,1) currency_rate_ref,
            f_id,
            (select ad_value from fiche_detail fd1 where fd1.f_id=jrnx.f_id and ad_id=23) as fiche_qcode
        from jrnx
            join jrn on (jr_grpt_id=jrnx.j_grpt)
            join operation_currency oc using (j_id)
            join jrn_def on (jr_def_id=jrn_def.jrn_def_id) 
            ";
        $sql.=$this->SQL_Condition();
 
        $sql.="     order by j_poste,j_date  ";
 
        return $sql;
    }

References $sql, and SQL_Condition().

Referenced by get_data(), Filter_Data_Currency_Accounting\get_data(), Filter_Data_Currency_Card\get_data(), and Filter_Data_Currency_Card_Category\get_data().

Here is the call graph for this function:

◆ get_data()

Data_Currency_Operation::get_data ( )

returns data

Returns: array

Reimplemented in Filter_Data_Currency_Accounting, Filter_Data_Currency_Card, and Filter_Data_Currency_Card_Category.

Definition at line 155 of file data_currency_operation.class.php.

    {
        $sql=$this->build_SQL();
        $aArray=$this->dbconx->get_array($sql, [$this->getCurrency_id(), $this->getFrom_date(),$this->getTo_date()]);
 
        return $aArray;
    }

References $sql, build_SQL(), getCurrency_id(), getFrom_date(), and getTo_date().

Here is the call graph for this function:

◆ getCurrency_id()

Data_Currency_Operation::getCurrency_id ( )

retrieve currency.od

Definition at line 61 of file data_currency_operation.class.php.

    {
        return $this->currency_id;
    }

References $currency_id.

Referenced by get_data(), Filter_Data_Currency_Accounting\get_data(), Filter_Data_Currency_Card\get_data(), Filter_Data_Currency_Card_Category\get_data(), and Filter_Data_Currency_Accounting\info().

◆ getDbconx()

Data_Currency_Operation::getDbconx ( )

Database connection.

Definition at line 96 of file data_currency_operation.class.php.

    {
        return $this->dbconx;
    }

References $dbconx.

Referenced by Filter_Data_Currency_Accounting\get_data(), Filter_Data_Currency_Card\get_data(), and Filter_Data_Currency_Card_Category\get_data().

◆ getFrom_date()

Data_Currency_Operation::getFrom_date ( )

Definition at line 66 of file data_currency_operation.class.php.

    {
        return $this->from_date;
    }

References $from_date.

Referenced by get_data(), Filter_Data_Currency_Accounting\get_data(), Filter_Data_Currency_Card\get_data(), Filter_Data_Currency_Card_Category\get_data(), and Filter_Data_Currency_Accounting\info().

◆ getTo_date()

Data_Currency_Operation::getTo_date ( )

Definition at line 71 of file data_currency_operation.class.php.

    {
        return $this->to_date;
    }

References $to_date.

Referenced by get_data(), Filter_Data_Currency_Accounting\get_data(), Filter_Data_Currency_Card\get_data(), Filter_Data_Currency_Card_Category\get_data(), and Filter_Data_Currency_Accounting\info().

◆ setCurrency_id()

Data_Currency_Operation::setCurrency_id ( $currency_id )

retrieve currency.od

Definition at line 89 of file data_currency_operation.class.php.

    {
        $this->currency_id=$currency_id;
    }

References $currency_id.

◆ setDbconx()

Data_Currency_Operation::setDbconx ( $dbconx )

Definition at line 101 of file data_currency_operation.class.php.

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

References $dbconx.

◆ setFrom_date()

Data_Currency_Operation::setFrom_date ( $from_date )

Definition at line 76 of file data_currency_operation.class.php.

    {
        $this->from_date=$from_date;
    }

References $from_date.

◆ setTo_date()

Data_Currency_Operation::setTo_date ( $to_date )

Definition at line 81 of file data_currency_operation.class.php.

    {
        $this->to_date=$to_date;
    }

References $to_date.

◆ SQL_Condition()

Data_Currency_Operation::SQL_Condition ( )

build the SQL condition

Returns: SQL condition

Reimplemented in Filter_Data_Currency_Accounting, Filter_Data_Currency_Card, and Filter_Data_Currency_Card_Category.

Definition at line 142 of file data_currency_operation.class.php.

    {
        global $g_user;
 
        return " where jrn.currency_id = $1 and ".$g_user->get_ledger_sql('ALL', 3)
                ." and jr_date >= to_date($2,'DD.MM.YYYY')"
                ." and jr_date <= to_date($3,'DD.MM.YYYY')"
        ;
    }

References $g_user.

Referenced by build_SQL().

◆ to_currency_code()

Data_Currency_Operation::to_currency_code ( )

retrieve the currency code

Returns: string ISO CODE

Definition at line 53 of file data_currency_operation.class.php.

    {
        $currency_code=$this->dbconx->get_value("select cr_code_iso from currency where id=$1",[$this->currency_id]);
        return $currency_code;
    }