Amortissement_Histo_Sql Class Reference

Manage the table amortissement.amortissement_histo. More...

Collaboration diagram for Amortissement_Histo_Sql:

Public Member Functions
	__construct (&$p_cn, $p_id=-1)
	get_parameter ($p_string)
	set_parameter ($p_string, $p_value)
	get_info ()
	verify ()
	save ()
	seek ($cond='', $p_array=null)
	retrieve array of object thanks a condition More...
	insert ()
	update ()
	load ()
	load a object More...
	delete ()

Static Public Member Functions
static	test_me ()
	Unit test for the class. More...

Protected Attributes
	$variable

Detailed Description

Manage the table amortissement.amortissement_histo.

Definition at line 38 of file class_amortissement_histo_sql.php.

Constructor & Destructor Documentation

Amortissement_Histo_Sql::__construct	(	&	$p_cn,
			$p_id = -1
	)

Definition at line 48 of file class_amortissement_histo_sql.php.

References $key, ha_id, and load().

  {
    $this->cn=$p_cn;
    $this->ha_id=$p_id;

    if ( $p_id == -1 )
      {
    /* Initialize an empty object */
    foreach ($this->variable as $key=>$value) $this->$value='';
    $this->ha_id=$p_id;
      }
    else
      {
    /* load it */

    $this->load();
      }
  }

Member Function Documentation

Amortissement_Histo_Sql::delete

(

)

Definition at line 249 of file class_amortissement_histo_sql.php.

References $res, $sql, and ha_id.

  {
    $sql="delete from amortissement.amortissement_histo where ha_id=$1";
    $res=$this->cn->exec_sql($sql,array($this->ha_id));
  }

Amortissement_Histo_Sql::get_info

(

)

Definition at line 86 of file class_amortissement_histo_sql.php.

  {
    return var_export($this,true);
  }

Amortissement_Histo_Sql::get_parameter

(

$p_string

)

Definition at line 66 of file class_amortissement_histo_sql.php.

  {
    if ( array_key_exists($p_string,$this->variable) )
      {
    $idx=$this->variable[$p_string];
    return $this->$idx;
      }
    else
      throw new Exception (__FILE__.":".__LINE__.$p_string.'Erreur attribut inexistant');
  }

Amortissement_Histo_Sql::insert

(

)

Definition at line 138 of file class_amortissement_histo_sql.php.

References $sql, a_id, h_pj, ha_id, jr_internal, and verify().

Referenced by save().

  {
    if ( $this->verify() != 0 ) return;
    if ( $this->ha_id==-1 )
      {
    /*  please adapt */
    $sql="insert into amortissement.amortissement_histo(a_id
                     ,h_amount
                     ,jr_internal
                     ,h_year
                     ,h_pj
                     ) values ($1
                     ,$2
                     ,$3
                     ,$4
                     ,$5
                     ) returning ha_id";

    $this->ha_id=$this->cn->get_value(
                      $sql,
                      array( $this->a_id
                         ,$this->h_amount
                         ,$this->jr_internal
                         ,$this->h_year
                         ,$this->h_pj
                         )
                      );
      }
    else
      {
    $sql="insert into amortissement.amortissement_histo(a_id
                     ,h_amount
                     ,jr_internal
                     ,h_year
                     ,h_pj
                     ,ha_id) values ($1
                     ,$2
                     ,$3
                     ,$4
                     ,$5
                     ,$6
                     ) returning ha_id";

    $this->ha_id=$this->cn->get_value(
                      $sql,
                      array( $this->a_id
                         ,$this->h_amount
                         ,$this->jr_internal
                         ,$this->h_year
                         ,$this->h_pj
                         ,$this->ha_id)
                      );

      }

  }

Amortissement_Histo_Sql::load

(

)

load a object

Returns

0 on success -1 the object is not found

Definition at line 220 of file class_amortissement_histo_sql.php.

References $key, $res, $sql, and ha_id.

Referenced by __construct().

  {

    $sql="select a_id
                 ,h_amount
                 ,jr_internal
                 ,h_year
                 ,h_pj
                 from amortissement.amortissement_histo where ha_id=$1";
    /* please adapt */
    $res=$this->cn->get_array(
                  $sql,
                  array($this->ha_id)
                  );

    if ( count($res) == 0 )
      {
    /* Initialize an empty object */
    foreach ($this->variable as $key=>$value) $this->$key='';

    return -1;
      }
    foreach ($res[0] as $idx=>$value)
      {
    $this->$idx=$value;
      }
    return 0;
  }

Amortissement_Histo_Sql::save

(

)

Definition at line 103 of file class_amortissement_histo_sql.php.

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

  {
    /* please adapt */
    if (  $this->ha_id == -1 )
      $this->insert();
    else
      $this->update();
  }

Amortissement_Histo_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::get_array

Returns

an empty array if nothing is found

Definition at line 119 of file class_amortissement_histo_sql.php.

References $array, and $sql.

  {
    $sql="select * from amortissement.amortissement_histo  $cond";
    $aobj=array();
    $array= $this->cn->get_array($sql,$p_array);
    // map each row in a object
    $size=$this->cn->count();
    if ( $size == 0 ) return $aobj;
    for ($i=0; $i<$size; $i++)
      {
    $oobj=new Amortissement_Histo_Sql ($this->cn);
    foreach ($array[$i] as $idx=>$value)
      {
        $oobj->$idx=$value;
      }
    $aobj[]=clone $oobj;
      }
    return $aobj;
  }

Amortissement_Histo_Sql::set_parameter	(		$p_string,
			$p_value
	)

Definition at line 76 of file class_amortissement_histo_sql.php.

  {
    if ( array_key_exists($p_string,$this->variable) )
      {
    $idx=$this->variable[$p_string];
    $this->$idx=$p_value;
      }
    else
      throw new Exception (__FILE__.":".__LINE__.$p_string.'Erreur attribut inexistant');
  }

static Amortissement_Histo_Sql::test_me ( )

static

Unit test for the class.

Definition at line 257 of file class_amortissement_histo_sql.php.

  {

  }

Amortissement_Histo_Sql::update

(

)

Definition at line 195 of file class_amortissement_histo_sql.php.

References $res, $sql, a_id, h_pj, ha_id, jr_internal, and verify().

Referenced by save().

  {
    if ( $this->verify() != 0 ) return;
    /*   please adapt */
    $sql=" update amortissement.amortissement_histo set a_id = $1
                 ,h_amount = $2
                 ,jr_internal = $3
                 ,h_year = $4
                 ,h_pj = $5
                 where ha_id= $6";
    $res=$this->cn->exec_sql(
                 $sql,
                 array($this->a_id
                   ,$this->h_amount
                   ,$this->jr_internal
                   ,$this->h_year
                   ,$this->h_pj
                   ,$this->ha_id)
                 );

  }

Amortissement_Histo_Sql::verify

(

)

Definition at line 90 of file class_amortissement_histo_sql.php.

References a_id.

Referenced by insert(), and update().

  {
    // Verify that the elt we want to add is correct
    /* verify only the datatype */
    if ( settype($this->a_id,'float') == false )
      throw new Exception('DATATYPE a_id $this->a_id non numerique');
    if ( settype($this->h_amount,'float') == false )
      throw new Exception('DATATYPE h_amount $this->h_amount non numerique');
    if ( settype($this->h_year,'float') == false )
      throw new Exception('DATATYPE h_year $this->h_year non numerique');


  }

Field Documentation

Amortissement_Histo_Sql::$variable

protected

Initial value:

=array("ha_id"=>"ha_id","a_id"=>"a_id"
                ,"h_amount"=>"h_amount"
                ,"jr_internal"=>"jr_internal"
                ,"h_year"=>"h_year"
                ,"h_pj"=>"h_pj"
                )

Definition at line 42 of file class_amortissement_histo_sql.php.

---

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

• amortis/include/class_amortissement_histo_sql.php