Amortissement_Detail_Sql Class Reference

Manage the table amortissement.amortissement_detail. More...

Collaboration diagram for Amortissement_Detail_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_detail.

Definition at line 36 of file class_amortissement_detail_sql.php.

Constructor & Destructor Documentation

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

Definition at line 45 of file class_amortissement_detail_sql.php.

References $key, and load().

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

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

    $this->load();
      }
  }

Member Function Documentation

Amortissement_Detail_Sql::delete

(

)

Definition at line 239 of file class_amortissement_detail_sql.php.

References $res, and $sql.

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

Amortissement_Detail_Sql::get_info

(

)

Definition at line 83 of file class_amortissement_detail_sql.php.

  {
    return var_export($this,true);
  }

Amortissement_Detail_Sql::get_parameter

(

$p_string

)

Definition at line 63 of file class_amortissement_detail_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_Detail_Sql::insert

(

)

Definition at line 137 of file class_amortissement_detail_sql.php.

References $sql, a_id, and verify().

Referenced by save().

  {
    if ( $this->verify() != 0 ) return;
    if ( $this->ad_id==-1 )
      {
    /*  please adapt */
    $sql="insert into amortissement.amortissement_detail(ad_percentage
                     ,ad_year
                     ,ad_amount
                     ,a_id
                     ) values ($1
                     ,$2
                     ,$3
                     ,$4
                     ) returning ad_id";

    $this->ad_id=$this->cn->get_value(
                      $sql,
                      array( $this->ad_percentage
                         ,$this->ad_year
                         ,$this->ad_amount
                         ,$this->a_id
                         )
                      );
      }
    else
      {
    $sql="insert into amortissement.amortissement_detail(ad_percentage
                     ,ad_year
                     ,ad_amount
                     ,a_id
                     ,ad_id) values ($1
                     ,$2
                     ,$3
                     ,$4
                     ,$5
                     ) returning ad_id";

    $this->ad_id=$this->cn->get_value(
                      $sql,
                      array( $this->ad_percentage
                         ,$this->ad_year
                         ,$this->ad_amount
                         ,$this->a_id
                         ,$this->ad_id)
                      );

      }

  }

Amortissement_Detail_Sql::load

(

)

load a object

Returns

0 on success -1 the object is not found

Definition at line 211 of file class_amortissement_detail_sql.php.

References $key, $res, and $sql.

Referenced by __construct().

  {

    $sql="select ad_percentage
                 ,ad_year
                 ,ad_amount
                 ,a_id
                 from amortissement.amortissement_detail where ad_id=$1";
    /* please adapt */
    $res=$this->cn->get_array(
                  $sql,
                  array($this->ad_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_Detail_Sql::save

(

)

Definition at line 102 of file class_amortissement_detail_sql.php.

References insert(), and update().

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

Amortissement_Detail_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 118 of file class_amortissement_detail_sql.php.

References $array, and $sql.

  {
    $sql="select * from amortissement.amortissement_detail  $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_Detail_Sql ($this->cn);
    foreach ($array[$i] as $idx=>$value)
      {
        $oobj->$idx=$value;
      }
    $aobj[]=clone $oobj;
      }
    return $aobj;
  }

Amortissement_Detail_Sql::set_parameter	(		$p_string,
			$p_value
	)

Definition at line 73 of file class_amortissement_detail_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_Detail_Sql::test_me ( )

static

Unit test for the class.

Definition at line 247 of file class_amortissement_detail_sql.php.

  {

  }

Amortissement_Detail_Sql::update

(

)

Definition at line 188 of file class_amortissement_detail_sql.php.

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

Referenced by save().

  {
    if ( $this->verify() != 0 ) return;
    /*   please adapt */
    $sql=" update amortissement.amortissement_detail set ad_percentage = $1
                 ,ad_year = $2
                 ,ad_amount = $3
                 ,a_id = $4
                 where ad_id= $5";
    $res=$this->cn->exec_sql(
                 $sql,
                 array($this->ad_percentage
                   ,$this->ad_year
                   ,$this->ad_amount
                   ,$this->a_id
                   ,$this->ad_id)
                 );

  }

Amortissement_Detail_Sql::verify

(

)

Definition at line 87 of file class_amortissement_detail_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->ad_percentage,'float') == false )
      throw new Exception('DATATYPE ad_percentage $this->ad_percentage non numerique');
    if ( settype($this->ad_year,'float') == false )
      throw new Exception('DATATYPE ad_year $this->ad_year non numerique');
    if ( settype($this->ad_amount,'float') == false )
      throw new Exception('DATATYPE ad_amount $this->ad_amount non numerique');
    if ( settype($this->a_id,'float') == false )
      throw new Exception('DATATYPE a_id $this->a_id non numerique');


  }

Field Documentation

Amortissement_Detail_Sql::$variable

protected

Initial value:

=array("ad_id"=>"ad_id","ad_percentage"=>"ad_percentage"
                ,"ad_year"=>"ad_year"
                ,"ad_amount"=>"ad_amount"
                ,"a_id"=>"a_id"
                )

Definition at line 40 of file class_amortissement_detail_sql.php.

---

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

• amortis/include/class_amortissement_detail_sql.php