Acc_Currency Class Reference

display currency , convert to euro , and save them if used. More...

Collaboration diagram for Acc_Currency:

Public Member Functions
	__construct (Database $p_cn, $p_id=-1)
	__toString ()
	get_by_iso ($p_iso)
	Retrieve a V_Currency_Last_Value_SQL thanks its iso_code. More...
	get_code ()
	return the iso code of the currency More...
	get_id ()
	return the id of the currency More...
	get_rate ()
	return the rate of the currency More...
	get_rate_date ($p_date)
	Return the rate used at a certain date or -1 if date if not in the format DD.MM.YYYY or -2 if no value is found. More...
	is_found ()
	Check if the record is found. More...
	select_currency ()
	Create an object iselect to select the currency,. More...
	set_id ($p_id)
	Retrieve a V_Currency_Last_Value_SQL thanks its id. More...
	sum_amount ($p_jr_id)
	Return sum of the w/o VAT and VAT or an operation. More...

Private Attributes
	$cn
	database conx More...
	$currency
	v_currency_last_value_sql More...

Detailed Description

display currency , convert to euro , and save them if used.

The default currency has the id 0 and is normally EUR

Definition at line 33 of file acc_currency.class.php.

Constructor & Destructor Documentation

__construct()

Acc_Currency::__construct	(	Database	$p_cn,
			$p_id = -1
	)

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

    {
        $this->cn=$p_cn;
        $this->currency=new V_Currency_Last_Value_SQL($p_cn, $p_id);
    }

References $p_id, and cn.

Member Function Documentation

__toString()

Acc_Currency::__toString

(

)

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

                                : string
    {
        return "Acc_Currency [".$this->currency->__toString()."]";
    }

get_by_iso()

Acc_Currency::get_by_iso

(

$p_iso

)

Retrieve a V_Currency_Last_Value_SQL thanks its iso_code.

Parameters

string

$p_iso

Definition at line 54 of file acc_currency.class.php.

    {
        $p_iso=trim(strtoupper($p_iso));
        $id=$this->cn->get_value("select currency_id from v_currency_last_value where cr_code_iso=$1", [$p_iso]);
        if ($id!="")
        {
            $this->currency->setp("currency_id", $id);
            $this->currency->load();
        }
    }

References $id, and cn.

get_code()

Acc_Currency::get_code

(

)

return the iso code of the currency

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

    {
        return $this->currency->getp("cr_code_iso");
        
        
    }

get_id()

Acc_Currency::get_id

(

)

return the id of the currency

Definition at line 105 of file acc_currency.class.php.

    {
        return $this->currency->getp("currency_id");
        
    }

Referenced by get_rate_date().

get_rate()

Acc_Currency::get_rate

(

)

return the rate of the currency

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

    {
        return $this->currency->getp("ch_value");
        
    }

get_rate_date()

Acc_Currency::get_rate_date

(

$p_date

)

Return the rate used at a certain date or -1 if date if not in the format DD.MM.YYYY or -2 if no value is found.

Parameters

date

$p_date

Definition at line 146 of file acc_currency.class.php.

    {
        if ( $this->get_id() == 0 ) { return 1;}
        
        if (isDate($p_date) == null ) {
            throw new Exception(_("Date invalide"));
        }
        
        $sql="select ch_value from currency_history 
            where
            ch_from=(select max(ch_from) from currency_history where ch_from <= to_date($1,'DD.MM.YYYY') and currency_id=$2)
            and currency_id=$2";
        $value=$this->cn->get_value($sql,[$p_date,$this->get_id()]);
        if ($value == "") {
            throw new Exception(_("Aucun taux à cette date , aller sur CFGCURRENCY"));
        }
        return $value;
    }

References $p_date, $sql, $value, cn, get_id(), and isDate().

Here is the call graph for this function:

is_found()

Acc_Currency::is_found

(

)

Check if the record is found.

Returns

boolean

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

                        {
        if ($this->currency->currency_id==-1)
        {
            return FALSE;
        }
        return TRUE;
    }

select_currency()

Acc_Currency::select_currency

(

)

Create an object iselect to select the currency,.

Returns

\ISelect

Definition at line 114 of file acc_currency.class.php.

    {
        $select=new ISelect('p_currency_code');
        $a_currency=$this->cn->make_array("select currency_id,cr_code_iso from v_currency_last_value order by cr_code_iso");
        $select->value=$a_currency;
        $select->selected=$this->currency->cr_code_iso;
        
        return $select;
    }

References $select, and cn.

set_id()

Acc_Currency::set_id

(

$p_id

)

Retrieve a V_Currency_Last_Value_SQL thanks its id.

Parameters

number

$p_id

Definition at line 69 of file acc_currency.class.php.

    {
        $this->currency->setp("currency_id", $p_id);
        $this->currency->load();
    }

References $p_id.

sum_amount()

Acc_Currency::sum_amount

(

$p_jr_id

)

Return sum of the w/o VAT and VAT or an operation.

Definition at line 126 of file acc_currency.class.php.

    {
        $sql = " 
            select sum(round(oc_amount,2)) +
                sum(round(oc_vat_amount,2)) 
        from operation_currency 
        where 
            j_id in (
                    select j_id 
                    from jrnx 
                    where 
                    j_grpt in ( select jr_grpt_id from jrn where jr_id=$1))";
        $sum=$this->cn->get_value($sql, [$p_jr_id]);
        return $sum;
 
    }

References $sql, and cn.

Field Documentation

$cn

Acc_Currency::$cn

private

database conx

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

$currency

Acc_Currency::$currency

private

v_currency_last_value_sql

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

---

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

• include/class/acc_currency.class.php