filter data in currency froqm datase , inherit from Data_Currency_Operation, filter on a specific card More...

Inheritance diagram for Filter_Data_Currency_Card:

Collaboration diagram for Filter_Data_Currency_Card:

Public Member Functions
	__construct ($cn, $from_date, $to_date, $currency_id, $card)

	get_data ()
	returns data More...

	getCard ()

	setCard ($card)

	SQL_Condition ()
	build the SQL condition More...

Public Member Functions inherited from Data_Currency_Operation
	__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
	$card
	qcode of a card More...

Detailed Description

filter data in currency froqm datase , inherit from Data_Currency_Operation, filter on a specific card

Definition at line 34 of file filter_data_currency_card.class.php.

Constructor & Destructor Documentation

◆ __construct()

Filter_Data_Currency_Card::__construct	(	$cn,
		$from_date,
		$to_date,
		$currency_id,
		$card
	)

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

    {
        parent::__construct($cn, $from_date, $to_date, $currency_id);
        $this->card=$card;
    }

References $card, $cn, Data_Currency_Operation\$currency_id, Data_Currency_Operation\$from_date, and Data_Currency_Operation\$to_date.

Member Function Documentation

◆ get_data()

Filter_Data_Currency_Card::get_data ( )

returns data

Returns: array

Reimplemented from Data_Currency_Operation.

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

    {
        $sql=$this->build_SQL();
        $card_id=$this->getDbconx()->get_value("select f_id from fiche_detail where ad_id=23 and ad_value=$1",
                [trim(strtoupper($this->card))]);
        if (empty($card_id))
        {
            throw new Exception(_("Fiche non trouvée"));
        }
        $aArray=$this->getDbconx()->get_array($sql,
                [$this->getCurrency_id(),
                    $this->getFrom_date(),
                    $this->getTo_date(),
                    $card_id]);
 
        return $aArray;
    }

References $card_id, $sql, Data_Currency_Operation\build_SQL(), Data_Currency_Operation\getCurrency_id(), Data_Currency_Operation\getDbconx(), Data_Currency_Operation\getFrom_date(), and Data_Currency_Operation\getTo_date().

Here is the call graph for this function:

◆ getCard()

Filter_Data_Currency_Card::getCard ( )

Definition at line 45 of file filter_data_currency_card.class.php.

    {
        return $this->card;
    }

References $card.

◆ setCard()

Filter_Data_Currency_Card::setCard ( $card )

Definition at line 50 of file filter_data_currency_card.class.php.

    {
        $this->card=$card;
    }

References $card.

◆ SQL_Condition()

Filter_Data_Currency_Card::SQL_Condition ( )

build the SQL condition

Returns: SQL condition

Reimplemented from Data_Currency_Operation.

Definition at line 60 of file filter_data_currency_card.class.php.

    {
        $sql=parent::SQL_Condition();
        $sql.=" and f_id=$4";
        return $sql;
    }

References $sql.

Field Documentation

◆ $card

Filter_Data_Currency_Card::$card

private

qcode of a card

Definition at line 37 of file filter_data_currency_card.class.php.

Referenced by __construct(), getCard(), and setCard().

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

include/class/filter_data_currency_card.class.php

Public Member Functions

Private Attributes