Forecast_Item Class Reference

manage the table forecast_item contains the items, the item are part of category of forecast_cat, which are part of Forecast More...

Collaboration diagram for Forecast_Item:

Public Member Functions
	__construct ($p_init, $p_id=0)
	constructor More...
	delete ()
	get_info ()
	get_parameter ($p_string)
	insert ()
	load ()
	save ()
	set_parameter ($p_string, $p_value)
	update ()
	verify ()

Static Public Member Functions
static	test_me ()
	unit test More...

Private Attributes
	$cn

Static Private Attributes
static	$variable

Detailed Description

manage the table forecast_item contains the items, the item are part of category of forecast_cat, which are part of Forecast

See also

Forecast Forecast_Cat

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

Constructor & Destructor Documentation

__construct()

Forecast_Item::__construct	(		$p_init,
			$p_id = 0
	)

constructor

Parameters

$p_init

Database object

Definition at line 44 of file forecast_item.class.php.

    {
        $this->cn=$p_init;
        $this->fi_id=$p_id;
    }

References $p_id, and cn.

Member Function Documentation

delete()

Forecast_Item::delete

(

)

Definition at line 152 of file forecast_item.class.php.

    {
        $sql="delete from forecast_item where fi_id=$1";
        $res=$this->cn->exec_sql($sql,array($this->fi_id));
    }

References $res, $sql, and cn.

get_info()

Forecast_Item::get_info

(

)

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

    {
        return var_export(self::$variable,true);
    }

get_parameter()

Forecast_Item::get_parameter

(

$p_string

)

Definition at line 49 of file forecast_item.class.php.

    {
        if ( array_key_exists($p_string,self::$variable) )
        {
            $idx=self::$variable[$p_string];
            return $this->$idx;
        }
        else
            throw new Exception("Attribut inexistant $p_string");
    }

References $idx.

Referenced by save().

insert()

Forecast_Item::insert

(

)

Definition at line 91 of file forecast_item.class.php.

    {
        if ( $this->verify() != 0 ) return;
 
        $sql="INSERT INTO forecast_item(
             fi_text, fi_account, fi_card, fi_order, fc_id, fi_amount,
             fi_debit,fi_pid)
             VALUES ($1, $2, $3, $4, $5, $6, $7,$8) returning fi_id;";
        $res=$this->cn->exec_sql(
                 $sql,
                 array($this->fi_text,$this->fi_account,$this->fi_card,$this->fi_order,$this->fc_id,$this->fi_amount,$this->fi_debit,$this->fi_pid)
             );
        $this->fi_id=Database::fetch_result($res,0,0);
    }

References $res, $sql, cn, DatabaseCore\fetch_result(), and verify().

Referenced by save().

Here is the call graph for this function:

load()

Forecast_Item::load

(

)

Definition at line 128 of file forecast_item.class.php.

    {
 
        $sql="SELECT fi_id, fi_text, fi_account, fi_card, fi_order, fc_id, fi_amount,
             fi_debit,fi_pid
             FROM forecast_item where fi_id=$1";
 
        $res=$this->cn->exec_sql(
                 $sql,
                 array($this->fi_id)
             );
 
        if ( Database::num_row($res) == 0 ) return;
        $row=Database::fetch_array($res,0);
        foreach ($row as $idx=>$value)
        {
            $this->$idx=$value;
        }
 
    }

References $idx, $res, $row, $sql, $value, cn, DatabaseCore\fetch_array(), and DatabaseCore\num_row().

Here is the call graph for this function:

save()

Forecast_Item::save

(

)

Definition at line 82 of file forecast_item.class.php.

    {
        /* please adapt */
        if (  $this->get_parameter("id") == 0 )
            $this->insert();
        else
            $this->update();
    }

References get_parameter(), insert(), and update().

Here is the call graph for this function:

set_parameter()

Forecast_Item::set_parameter	(		$p_string,
			$p_value
	)

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

    {
        if ( array_key_exists($p_string,self::$variable) )
        {
            $idx=self::$variable[$p_string];
            $this->$idx=$p_value;
        }
        else
        throw new Exception("Attribut inexistant $p_string");
 
 
    }

References $idx.

test_me()

static Forecast_Item::test_me ( )

static

unit test

Definition at line 160 of file forecast_item.class.php.

    {}

update()

Forecast_Item::update

(

)

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

    {
        if ( $this->verify() != 0 ) return;
 
        $sql="UPDATE forecast_item
             SET  fi_text=$1, fi_account=$2, fi_card=$3, fi_order=$4, fc_id=$5,
             fi_amount=$6, fi_debit=$7,fi_pid=$8
             WHERE fi_id=$9;";
        $res=$this->cn->exec_sql($sql,
                                 array($this->fi_text,
                                       $this->fi_account,
                                       $this->fi_card,
                                       $this->fi_order,
                                       $this->fc_id,
                                       $this->fi_amount,
                                       $this->fi_debit,
                                       $this->fi_pid,
                                       $this->fi_id)
                                );
 
    }

References $res, $sql, cn, and verify().

Referenced by save().

Here is the call graph for this function:

verify()

Forecast_Item::verify

(

)

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

    {
                $this->fi_account=  str_replace(" ", "", $this->fi_account);
        // Verify that the elt we want to add is correct
        // the f_name must be unique (case insensitive)
        return 0;
    }

Referenced by insert(), and update().

Field Documentation

$cn

Forecast_Item::$cn

private

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

$variable

Forecast_Item::$variable

staticprivate

Initial value:

=array ("id"=>"fi_id","text"=>"fi_text","account"=>"fi_account",
                                    "card"=>"fi_card","order"=>"fi_order","cat_id"=>"fc_id","amount"=>"fi_amount","debit"=>"fi_debit","periode"=>"fi_pid")

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

---

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

• include/class/forecast_item.class.php