V_Currency_Last_Value_SQL Class Reference

class_currency_history_sql.php More...

Inheritance diagram for V_Currency_Last_Value_SQL:

Collaboration diagram for V_Currency_Last_Value_SQL:

Public Member Functions
	__construct (Database $p_cn, $p_id=-1)
	count ($p_where="", $p_array=null)
	delete ()
	exist ()
	Count the number of record with the id ,. More...
	insert ()
	load ()
	Load the current row return false if not found. More...
	seek ($cond='', $p_array=null)
	retrieve array of object thanks a condition More...
	update ()
Public Member Functions inherited from Data_SQL
	__construct (DatabaseCore $p_cn, $p_id=-1)
	__toString ()
	collect_objects ($cond='', $p_array=null)
	return an array of objects. More...
	count ($p_where="", $p_array=null)
	delete ()
	exist ()
	Count the number of record with the id ,. More...
	from_array ($p_array)
	Transform an array into object. More...
	get ($p_string)
	get the value thanks the colum name and not the alias (name). More...
	get_cn ()
	get_info ()
	get_name ()
	get_object ($p_ret, $idx)
	get_pk_value ()
	get_primary_key ()
	get_type ()
	getp ($p_string)
	set the value thanks the alias name instead of the colum name More...
	insert ()
	load ()
	Load the current row return false if not found. More...
	next ($ret, $i)
	get_seek return the next object, the return of the query must have all the column of the object More...
	save ()
	Insert or update : if the row already exists, update otherwise insert. More...
	seek ($cond='', $p_array=null)
	retrieve array of object thanks a condition More...
	set ($p_string, $p_value)
	set the value thanks the colum name and not the alias (name) More...
	set_cn ($cn)
	set_name ($name)
	set_pk_value ($p_value)
	set_primary_key ($primary_key)
	set_type ($type)
	setp ($p_string, $p_value)
	set the value thanks the alias name instead of the colum name More...
	to_array ($prefix="")
	Turn an object (row) into an array, and the key could be prefixed with $prefix. More...
	to_row ($p_array)
	turns a row fetched from the DB into a SQL object in updating all his attribute More...
	update ()
	verify ()

Additional Inherited Members
Data Fields inherited from Data_SQL
	$cn
	$date_format
	Type of the data. More...
	$default
	defaullt date format More...
	$name
	Database connection. More...
	$primary_key
	Array of logical and real name. More...
	$table
	$type
	Column name of the primary key. More...

Detailed Description

class_currency_history_sql.php

abstract of the view public.v_currency_last_value

Examples

test_currency_mtable.php.

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

Constructor & Destructor Documentation

__construct()

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

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

    {
        $this->table="public.v_currency_last_value";
        $this->primary_key="currency_id";
        /*
         * List of columns
         */
        $this->name=array(
            "currency_id"=>"currency_id"
            , "cr_name"=>"cr_name"
            , "cr_code_iso"=>"cr_code_iso"
            , "currency_history_id"=>"currency_history_id"
            , "ch_value"=>"ch_value"
            , "str_from"=>"str_from"
        );
        /*
         * Type of columns
         */
        $this->type=array(
            "currency_id"=>"numeric"
            , "cr_name"=>"text"
            , "cr_code_iso"=>"text"
            , "currency_history_id"=>"numeric"
            , "ch_value"=>"numeric"
            , "str_from"=>"text"
        );
 
 
        $this->default=array(
            "currency_id"=>"auto"
        );
 
        $this->date_format="DD.MM.YYYY";
        parent::__construct($p_cn, $p_id);
    }

References $p_id, name, table, and type.

Member Function Documentation

count()

V_Currency_Last_Value_SQL::count	(		$p_where = "",
			$p_array = null
	)

Reimplemented from Data_SQL.

Definition at line 75 of file v_currency_last_value_sql.class.php.

    {
        $count=$this->cn->get_value("select count(*) from $this->table ".$p_where, $p_array);
        return $count;
    }

References $count, $p_array, and cn.

delete()

V_Currency_Last_Value_SQL::delete

(

)

Reimplemented from Data_SQL.

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

    {
        /* check if currency is used */
        $is_used = $this->cn->get_value("select count(*) from jrn where currency_id=$1",[$this->currency_id]);
        
        /* if not used , we can delete it */
        if ( $is_used <> 0 ) {     throw new Exception (_("Devise utilisée"));  }
        
        // We cannot delete EUR
        if ( $this->currency_id == -1 ) {
            throw new Exception(_("EUR ne peut pas être effacé"));
        }
        $this->cn->exec_sql("delete from currency_history where currency_id=$1",[$this->currency_id]);
        $this->cn->exec_sql("delete from currency where id=$1",[$this->currency_id]);
        
    }

References cn.

exist()

V_Currency_Last_Value_SQL::exist

(

)

Count the number of record with the id ,.

Returns

integer 0 doesn't exist , 1 exists

Reimplemented from Data_SQL.

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

    {
        $pk=$this->primary_key;
        $count=$this->cn->get_value("select count(*) from ".$this->table." where ".$this->primary_key."=$1",
                array($this->$pk));
        return $count;
    }

References $count, Data_SQL\$primary_key, cn, and table.

insert()

V_Currency_Last_Value_SQL::insert

(

)

Reimplemented from Data_SQL.

Definition at line 106 of file v_currency_last_value_sql.class.php.

    {
        
    }

load()

V_Currency_Last_Value_SQL::load

(

)

Load the current row return false if not found.

$pk=$this->primary_key;
if ( $this->get_limit_fiche_qcode() != 0 )
{
    $sql=sprintf($this->sql," limit ".$this->get_limit_fiche_qcode());
} else
{
    $sql=sprintf($this->sql,"  ");
}
$result=$this->cn->get_array($sql. " where id=$1",array ($this->$pk));
if ($this->cn->count()==0)
{
    $this->$pk=-1;
    return false;
}
 
foreach ($result[0] as $key=> $value)
{
    $this->$key=$value;
}
return true;

Returns

bool

Reimplemented from Data_SQL.

Definition at line 111 of file v_currency_last_value_sql.class.php.

                          :bool
    {
        $sql=" select ";
        $sep="";
        foreach ($this->name as $key)
        {
            switch ($this->type[$key])
            {
                case "date":
                    $sql.=$sep.'to_char('.$key.",'".$this->date_format."') as ".$key;
                    break;
                default:
                    $sql.=$sep.$key;
            }
            $sep=",";
        }
        $pk=$this->primary_key;
        $sql.=" from ".$this->table;
 
        $sql.=" where ".$this->primary_key." = $1";
 
        $result=$this->cn->get_array($sql, array($this->$pk));
        if ($this->cn->count()==0)
        {
            $this->$pk=-1;
            return false;
        }
 
        foreach ($result[0] as $key=> $value)
        {
            $this->$key=$value;
        }
        return true;
    }

References Data_SQL\$primary_key, $result, $sep, $sql, $value, cn, name, and type.

seek()

V_Currency_Last_Value_SQL::seek	(		$cond = '',
			$p_array = null
	)

retrieve array of object thanks a condition

Parameters

$cond	condition (where clause) (optional by default all the rows are fetched) you can use this parameter for the order or subselect
$p_array	array for the SQL stmt

See also

Database::exec_sql get_object Database::num_row

Returns

the return value of exec_sql

Reimplemented from Data_SQL.

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

    {
        $sql="select * from ".$this->table."  $cond";
        $ret=$this->cn->exec_sql($sql, $p_array);
        return $ret;
    }

References $p_array, $ret, $sql, and cn.

update()

V_Currency_Last_Value_SQL::update

(

)

Reimplemented from Data_SQL.

Definition at line 153 of file v_currency_last_value_sql.class.php.

    {
        
    }

---

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

• include/database/v_currency_last_value_sql.class.php