Manage the table importbank.format_bank. More...

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

	get_object ($p_ret, $idx)
	get_seek return the next object, the return of the query must have all the column of the object 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 importbank.format_bank.

Definition at line 36 of file class_format_bank_sql.php.

Constructor & Destructor Documentation

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

Definition at line 55 of file class_format_bank_sql.php.

References $key, and load().

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

Member Function Documentation

Format_Bank_sql::delete ( )

Definition at line 362 of file class_format_bank_sql.php.

References $res, and $sql.

             {
             $sql="delete from importbank.format_bank where id=$1";
             $res=$this->cn->exec_sql($sql,array($this->id));
             }

Format_Bank_sql::get_info ( )

Definition at line 93 of file class_format_bank_sql.php.

             {
             return var_export($this,true);
             }

Format_Bank_sql::get_object	(	$p_ret,
		$idx
	)

get_seek return the next object, the return of the query must have all the column of the object

Parameters

$p_ret	is the return value of an exec_sql
$idx	is the index

See Also: seek

Returns: object

Definition at line 146 of file class_format_bank_sql.php.

References $array.

             {
             // map each row in a object
             $oobj=new Format_Bank_sql ($this->cn);
             $array=Database::fetch_array($p_ret,$idx);
             foreach ($array as $idx=>$value)
                 {
                 $oobj->$idx=$value;
                 }
             $aobj[]=clone $oobj;
 
             return $aobj;
             }

Format_Bank_sql::get_parameter ( $p_string )

Definition at line 73 of file class_format_bank_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');
             }

Format_Bank_sql::insert ( )

Definition at line 159 of file class_format_bank_sql.php.

References $sql, update(), and verify().

Referenced by save().

             {
             if ( $this->verify() != 0 ) return;
         if ( strlen(trim($this->format_name))==0)
           {
         $get_id=$this->cn->get_value('select id from importbank.format_bank where format_name=$1',array($this->format_name));
         if ( $this->cn->size() == 1) {
           $this->update();
           return;
         }
         
           }
             if ( $this->id==-1 )
                 {
                 /*  please adapt */
                 $sql="insert into importbank.format_bank(format_name
                      ,jrn_def_id
                      ,pos_lib
                      ,pos_amount
                      ,pos_date
                      ,pos_operation_nb
                      ,pos_third
              ,pos_extra
                      ,sep_decimal
                      ,sep_thousand
                      ,sep_field
                      ,format_date
                      ,nb_col
              ,skip
                      ) values ($1
                      ,$2
                      ,$3
                      ,$4
                      ,$5
                      ,$6
                      ,$7
                      ,$8
                      ,$9
                      ,$10
                      ,$11
              ,$12
              ,$13
              ,$14
                      ) returning id";
 
                 $this->id=$this->cn->get_value(
                               $sql,
                               array( $this->format_name
                                      ,$this->jrn_def_id
                                      ,$this->pos_lib
                                      ,$this->pos_amount
                                      ,$this->pos_date
                                      ,$this->pos_operation_nb
                      ,$this->pos_third
                      ,$this->pos_extra
                                      ,$this->sep_decimal
                                      ,$this->sep_thousand
                                      ,$this->sep_field
                                      ,$this->format_date
                                      ,$this->nb_col
                      ,$this->skip
                                    )
                           );
                 }
             else
                 {
                 $sql="insert into importbank.format_bank(format_name
                      ,jrn_def_id
                      ,pos_lib
                      ,pos_amount
                      ,pos_date
                      ,pos_operation_nb
                      ,pos_third
              ,pos_extra
                      ,sep_decimal
                      ,sep_thousand
                      ,sep_field
                      ,format_date
                      ,nb_col
                      ,id
              ,skip
              ) values ($1
                      ,$2
                      ,$3
                      ,$4
                      ,$5
                      ,$6
                      ,$7
                      ,$8
                      ,$9
                      ,$10
                      ,$11
                      ,$12
              ,$13
              ,$14
              ,$15
                      ) returning id";
 
                 $this->id=$this->cn->get_value(
                               $sql,
                               array( $this->format_name
                                      ,$this->jrn_def_id
                                      ,$this->pos_lib
                                      ,$this->pos_amount
                                      ,$this->pos_date
                                      ,$this->pos_operation_nb
                      ,$this->pos_third
                      ,$this->pos_extra
                                      ,$this->sep_decimal
                                      ,$this->sep_thousand
                                      ,$this->sep_field
                                      ,$this->format_date
                                      ,$this->nb_col
                                      ,$this->id
                      ,$this->skip
                      )
                           );
 
                 }
 
             }

Format_Bank_sql::load ( )

load a object

Returns: 0 on success -1 the object is not found

Definition at line 324 of file class_format_bank_sql.php.

References $key, $res, and $sql.

Referenced by __construct().

             {
 
             $sql="select format_name
                  ,jrn_def_id
                  ,pos_lib
                  ,pos_amount
                  ,pos_date
                  ,pos_operation_nb
          ,pos_third
          ,pos_extra
                  ,sep_decimal
                  ,sep_thousand
                  ,sep_field
                  ,format_date
                  ,nb_col
          ,skip
                  from importbank.format_bank where id=$1";
             /* please adapt */
             $res=$this->cn->get_array(
                      $sql,
                      array($this->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;
             }

Format_Bank_sql::save ( )

Definition at line 115 of file class_format_bank_sql.php.

References insert(), and update().

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

Format_Bank_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

Definition at line 131 of file class_format_bank_sql.php.

References $ret, and $sql.

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

Format_Bank_sql::set_parameter	(	$p_string,
		$p_value
	)

Definition at line 83 of file class_format_bank_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 Format_Bank_sql::test_me ( )

static

Unit test for the class.

Definition at line 370 of file class_format_bank_sql.php.

             {
 
             }

Format_Bank_sql::update ( )

Definition at line 281 of file class_format_bank_sql.php.

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

Referenced by insert(), and save().

             {
             if ( $this->verify() != 0 ) return;
             /*   please adapt */
             $sql=" update importbank.format_bank set format_name = $1
                  ,jrn_def_id = $2
                  ,pos_lib = $3
                  ,pos_amount = $4
                  ,pos_date = $5
                  ,pos_operation_nb = $6
          ,pos_third = $7
          ,pos_extra=$8
                  ,sep_decimal = $9
                  ,sep_thousand = $10
                  ,sep_field = $11
                  ,format_date = $12
                  ,nb_col = $13
          ,skip=$14
                  where id= $15";
             $res=$this->cn->exec_sql(
                      $sql,
                      array($this->format_name
                            ,$this->jrn_def_id
                            ,$this->pos_lib
                            ,$this->pos_amount
                            ,$this->pos_date
                            ,$this->pos_operation_nb
                ,$this->pos_third
                ,$this->pos_extra
                            ,$this->sep_decimal
                            ,$this->sep_thousand
                            ,$this->sep_field
                            ,$this->format_date
                            ,$this->nb_col
                ,$this->skip
                            ,$this->id)
                  );
 
             }

Format_Bank_sql::verify ( )

Definition at line 97 of file class_format_bank_sql.php.

Referenced by insert(), and update().

             {
             // Verify that the elt we want to add is correct
             /* verify only the datatype */
           if ( $this->jrn_def_id !==null && settype($this->jrn_def_id,'float') == false )
                 throw new Exception('DATATYPE jrn_def_id $this->jrn_def_id non numerique');
           if ( $this->pos_lib !== null && settype($this->pos_lib,'float') == false )
                 throw new Exception('DATATYPE pos_lib $this->pos_lib non numerique');
             if ( $this->pos_amount !== null && settype($this->pos_amount,'float') == false )
                 throw new Exception('DATATYPE pos_amount $this->pos_amount non numerique');
             if ( $this->pos_date !== null && settype($this->pos_date,'float') == false )
                 throw new Exception('DATATYPE pos_date $this->pos_date non numerique');
             if ( $this->pos_operation_nb !== null && settype($this->pos_operation_nb,'float') == false )
                 throw new Exception('DATATYPE pos_operation_nb $this->pos_operation_nb non numerique');
             if ($this->nb_col !== null &&  settype($this->nb_col,'float') == false )
                 throw new Exception('DATATYPE nb_col $this->nb_col non numerique');
 
             }

Field Documentation

Format_Bank_sql::$variable

protected

Initial value:

=array("id"=>"id","format_name"=>"format_name"
                                  ,"jrn_def_id"=>"jrn_def_id"
                  ,"pos_lib"=>"pos_lib"
                  ,"pos_amount"=>"pos_amount"
                  ,"pos_date"=>"pos_date"
                  ,"pos_operation_nb"=>"pos_operation_nb"
                  ,"pos_third"=>"pos_third"
                  ,"pos_extra"=>"pos_extra"
                  ,"sep_decimal"=>"sep_decimal"
                  ,"sep_thousand"=>"sep_thousand"
                  ,"sep_field"=>"sep_field"
                  ,"format_date"=>"format_date"
                  ,"nb_col"=>"nb_col"
                  ,"skip"=>"skip"
                                 )

Definition at line 40 of file class_format_bank_sql.php.

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

importbank/include/class_format_bank_sql.php

Public Member Functions

Static Public Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Field Documentation