Acc_Ledger_Info Class Reference

Manage the additionnal info for operation (from jrn), when an invoice is generated, the order or other info are going to be stored and used in the detail. this class maps the table jrn_info. More...

Collaboration diagram for Acc_Ledger_Info:

Public Member Functions
	__construct ($p_cn, $p_ji_id=0)
	count ()
	from_array ($p_array)
	insert ()
	load ()
	load the todo_list row thanks it's ID
	load_all ()
	load all the jrn_info thanks the jr_id
	save_extra ($p_jr_id, $p_array)
	save all extra information in once, called by compta_ven and compta_ach
	search_id_internal ($p_internal)
	set_id ($p_ji_id)
	set_jrn_id ($p_id)
	set_type ($p_id)
	set_value ($p_id)
	update ()

Data Fields
	$cn
	$id_type
	$ji_id
	$ji_value
	$jr_id

Detailed Description

Manage the additionnal info for operation (from jrn), when an invoice is generated, the order or other info are going to be stored and used in the detail. this class maps the table jrn_info.

Definition at line 32 of file acc_ledger_info.class.php.

Constructor & Destructor Documentation

__construct()

Acc_Ledger_Info::__construct	(		$p_cn,
			$p_ji_id = 0 )

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

    {
        $this->cn=$p_cn;
        $this->ji_id=$p_ji_id;
    }

References cn.

Member Function Documentation

count()

Acc_Ledger_Info::count

(

)

Definition at line 161 of file acc_ledger_info.class.php.

    {
        $sql="select ji_id from jrn_info where jr_id=".$this->jr_id;
        return $this->cn->count_sql($sql);
    }

References $sql, and cn.

from_array()

Acc_Ledger_Info::from_array

(

$p_array

)

Definition at line 112 of file acc_ledger_info.class.php.

    {
        foreach (array("jr_id","id_type","ji_value") as $col)
        {
            $this->$col=$p_array[$col];
        }
    }

References $p_array.

Referenced by load().

insert()

Acc_Ledger_Info::insert

(

)

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

    {
        if ( ! isset ($this->jr_id) ||
                ! isset ($this->ji_value) ||
                ! isset ($this->id_type ) )
        {
            echo 'Appel incorrecte '.__FILE__.__LINE__;
            var_dump($this);
            throw new Exception(_('appel incorrect'));
        }
        try
        {
            $sql=$this->cn->exec_sql('insert into jrn_info(jr_id,id_type,ji_value) values ($1,$2,$3)'.
                                     ' returning ji_id ',
                                     array ($this->jr_id,$this->id_type,$this->ji_value)
                                    );
            $this->ji_id=Database::fetch_result($sql,0,0);
        }
        catch (Exception $e)
        {
              record_log($e);
            echo "Echec sauvegarde info additionnelles";
            throw $e;
        }
    }

References $e, $sql, _, cn, DatabaseCore\fetch_result(), jr_id, and record_log().

Referenced by save_extra().

Here is the call graph for this function:

load()

Acc_Ledger_Info::load

(

)

load the todo_list row thanks it's ID

Returns

boolean true if found else false

Definition at line 97 of file acc_ledger_info.class.php.

                   :bool
    {
        $sql="select jr_id,id_type,ji_value from jrn_info where ji_id=$1";
        $r=$this->cn->exec_sql($sql,[$this->ji_id]);
        if (Database::num_row ($r) > 0 )
        {
            $this->from_array(Database::fetch_array($r,0));
            return true;
        }
        else
        {
            return false;
        }
 
    }

References $r, $sql, cn, DatabaseCore\fetch_array(), from_array(), and DatabaseCore\num_row().

Here is the call graph for this function:

load_all()

Acc_Ledger_Info::load_all

(

)

load all the jrn_info thanks the jr_id

Returns

an array of object

Definition at line 138 of file acc_ledger_info.class.php.

    {
        if ( ! isset ($this->jr_id) )
        {
            echo "jr_id is not set ".__FILE__.__LINE__;
            throw new Exception('Error : jr_id not set');
        }
 
        $sql="select ji_id from jrn_info where jr_id=".$this->jr_id;
        $r=$this->cn->exec_sql($sql);
        if (Database::num_row($r) == 0 )
            return array();
        $array=Database::fetch_all($r);
        $ret=array();
        foreach ($array as $row)
        {
            $o=new Acc_Ledger_Info($this->cn,$row['ji_id']);
            $o->load();
            $ret[]=clone $o;
        }
        return $ret;
 
    }

References $array, $r, $ret, $row, $sql, cn, DatabaseCore\fetch_all(), jr_id, and DatabaseCore\num_row().

Here is the call graph for this function:

save_extra()

Acc_Ledger_Info::save_extra	(		$p_jr_id,
			$p_array )

save all extra information in once, called by compta_ven and compta_ach

Parameters

$p_jr_id	is the jrn.jr_id concerned,
$p_array	is the array with the data usually it is $_POST

Note

will change this->jr_id

See also

compta_ven.inc.php compta_ach.inc.php

Definition at line 188 of file acc_ledger_info.class.php.

    {
        $this->jr_id=$p_jr_id;
        if (noalyss_strlentrim($p_array['bon_comm'] ) != 0 )
        {
            $this->set_type('BON_COMMANDE');
            $this->set_value($p_array['bon_comm']);
            $this->insert();
        }
        if (noalyss_strlentrim($p_array['other_info'] ) != 0 )
        {
            $this->set_type('OTHER');
            $this->set_value($p_array['other_info']);
            $this->insert();
        }
    }

References $p_array, insert(), jr_id, noalyss_strlentrim(), set_type(), and set_value().

Here is the call graph for this function:

search_id_internal()

Acc_Ledger_Info::search_id_internal

(

$p_internal

)

Definition at line 166 of file acc_ledger_info.class.php.

    {
        $sql="select jr_id from jrn where jr_internal='$p_internal'";
        $r=$this->cn->exec_sql($sql);
        if (Database::num_row($r) > 0 )
        {
            $this->jr_id=Database::fetch_result($r,0,0);
            return $this->jr_id;
        }
        else
        {
            $this->jr_id=-1;
            return $this->jr_id;
        }
    }

References $jr_id, $r, $sql, cn, DatabaseCore\fetch_result(), jr_id, and DatabaseCore\num_row().

Here is the call graph for this function:

set_id()

Acc_Ledger_Info::set_id

(

$p_ji_id

)

Definition at line 119 of file acc_ledger_info.class.php.

    {
        $this->$ji_id=$p_ji_id;
    }

set_jrn_id()

Acc_Ledger_Info::set_jrn_id

(

$p_id

)

Definition at line 123 of file acc_ledger_info.class.php.

    {
        $this->jr_id=$p_id;
    }

References $p_id, and jr_id.

set_type()

Acc_Ledger_Info::set_type

(

$p_id

)

Definition at line 127 of file acc_ledger_info.class.php.

    {
        $this->id_type=$p_id;
    }

References $p_id.

Referenced by save_extra().

set_value()

Acc_Ledger_Info::set_value

(

$p_id

)

Definition at line 131 of file acc_ledger_info.class.php.

    {
        $this->ji_value=$p_id;
    }

References $p_id.

Referenced by save_extra().

update()

Acc_Ledger_Info::update

(

)

Definition at line 69 of file acc_ledger_info.class.php.

    {
        if ( ! isset ($this->jr_id) ||
                ! isset ($this->ji_value) ||
                ! isset ($this->jr_id ) )
        {
            echo 'Appel incorrecte '.__FILE__.__LINE__;
            var_dump($this);
            throw  new Exception('appel incorrect');
        }
        try
        {
            $sql=$this->exec_sql('update jrn_info set jr_id=$1 ,id_type=$2,ji_value=$3 where ji_id=$4)'.
                                 array ($this->jr_id,$this->id_type,$this->ji_value,$this->ji_id)
                                );
        }
        catch (Exception $e)
        {
              record_log($e);
            $this->cn->rollback();
            echo "Echec sauvegarde info additionnelles";
            throw $e;
        }
    }

References $e, $sql, cn, jr_id, and record_log().

Here is the call graph for this function:

Field Documentation

$cn

Acc_Ledger_Info::$cn

connection

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

$id_type

Acc_Ledger_Info::$id_type

type id

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

$ji_id

Acc_Ledger_Info::$ji_id

primary key

Definition at line 35 of file acc_ledger_info.class.php.

$ji_value

Acc_Ledger_Info::$ji_value

value for this

Definition at line 38 of file acc_ledger_info.class.php.

$jr_id

Acc_Ledger_Info::$jr_id

primary key of the table jrn

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

Referenced by search_id_internal().

---

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

• include/class/acc_ledger_info.class.php