noalyss Version-9
Public Member Functions | Private Attributes
Filter_Data_Currency_Accounting Class Reference

filter data in currency from datase , inherit from Data_Currency_Operation, filter on a range of accounting or only one More...

+ Inheritance diagram for Filter_Data_Currency_Accounting:
+ Collaboration diagram for Filter_Data_Currency_Accounting:

Public Member Functions

 __construct ($cn, $from_date, $to_date, $currency_id, $from_accounting, $to_accounting)
 
 get_data ()
 returns data More...
 
 getFrom_accounting ()
 from_accounting : lowest accounting range More...
 
 getTo_accounting ()
 to_accounting : highest accounting range More...
 
 info ()
 
 setFrom_accounting ($from_accounting)
 from_accounting : lowest accounting range More...
 
 setTo_accounting ($to_accounting)
 to_accounting : highest accounting range More...
 
 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

 $from_accounting
 
 $to_accounting
 

Detailed Description

filter data in currency from datase , inherit from Data_Currency_Operation, filter on a range of accounting or only one

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

Constructor & Destructor Documentation

◆ __construct()

Filter_Data_Currency_Accounting::__construct (   $cn,
  $from_date,
  $to_date,
  $currency_id,
  $from_accounting,
  $to_accounting 
)

Member Function Documentation

◆ get_data()

Filter_Data_Currency_Accounting::get_data ( )

returns data

Returns
array

Reimplemented from Data_Currency_Operation.

Definition at line 98 of file filter_data_currency_accounting.class.php.

99 {
100 $sql=$this->build_SQL();
101 $aArray=$this->getDbconx()->get_array($sql,
102 [$this->getCurrency_id(),
103 $this->getFrom_date(),
104 $this->getTo_date(),
105 $this->getFrom_accounting(),
106 $this->getTo_accounting()]);
107
108 return $aArray;
109 }
build_SQL()
build the SQL to execute
getFrom_accounting()
from_accounting : lowest accounting range
getTo_accounting()
to_accounting : highest accounting range

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

+ Here is the call graph for this function:

◆ getFrom_accounting()

Filter_Data_Currency_Accounting::getFrom_accounting ( )

from_accounting : lowest accounting range

Returns
accounting (string)

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

51 {
53 }

References $from_accounting.

Referenced by get_data(), and info().

◆ getTo_accounting()

Filter_Data_Currency_Accounting::getTo_accounting ( )

to_accounting : highest accounting range

Returns
accounting (string)

Definition at line 59 of file filter_data_currency_accounting.class.php.

60 {
62 }

References $to_accounting.

Referenced by get_data(), and info().

◆ info()

Filter_Data_Currency_Accounting::info ( )

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

111 {
112 return sprintf("currency_id %s from_date %s to_date %s from_accounting %s to_accounting %s",
113 $this->getCurrency_id(),$this->getFrom_date(),$this->getTo_date(),$this->getFrom_accounting(),
114 $this->getTo_accounting());
115 }

References Data_Currency_Operation\getCurrency_id(), getFrom_accounting(), Data_Currency_Operation\getFrom_date(), getTo_accounting(), and Data_Currency_Operation\getTo_date().

+ Here is the call graph for this function:

◆ setFrom_accounting()

Filter_Data_Currency_Accounting::setFrom_accounting (   $from_accounting)

from_accounting : lowest accounting range

Returns
accounting (string)

Definition at line 68 of file filter_data_currency_accounting.class.php.

69 {
70 $this->from_accounting=$from_accounting;
71 return $this;
72 }

References $from_accounting.

◆ setTo_accounting()

Filter_Data_Currency_Accounting::setTo_accounting (   $to_accounting)

to_accounting : highest accounting range

Returns
accounting (string)

Definition at line 78 of file filter_data_currency_accounting.class.php.

79 {
80 $this->to_accounting=$to_accounting;
81 return $this;
82 }

References $to_accounting.

◆ SQL_Condition()

Filter_Data_Currency_Accounting::SQL_Condition ( )

build the SQL condition

Returns
SQL condition

Reimplemented from Data_Currency_Operation.

Definition at line 88 of file filter_data_currency_accounting.class.php.

89 {
90 $sql=parent::SQL_Condition();
91 $sql.=' and j_poste >= $4 and j_poste <= $5';
92 return $sql;
93 }

References $sql.

Field Documentation

◆ $from_accounting

Filter_Data_Currency_Accounting::$from_accounting
private

◆ $to_accounting

Filter_Data_Currency_Accounting::$to_accounting
private

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