Acc_Account Class Reference

Manage the account from the table tmp_pcmn. More...

Collaboration diagram for Acc_Account:

Public Member Functions
	__construct (Database $p_cn, $pcm_val="")
	count ($p_value)
	delete ()
	find_by_value ($p_pcm_val)
	find_parent ()
	Find the parent of an account.
	get_lib ()
	Return the name of a account it doesn't change any data member.
	get_parameter ($p_string)
	insert ()
	load ()
	Get all the value for this object from the database the data member are set.
	save ()
	searchValue ($p_value)
	set_parameter ($p_string, $p_value)
	update ()
	verify ()
	Check before inserting or updating.

Data Fields
	$db

Static Public Attributes
static	$type

Private Attributes
	$data_sql

Detailed Description

Manage the account from the table tmp_pcmn.

Definition at line 28 of file acc_account.class.php.

Constructor & Destructor Documentation

__construct()

Acc_Account::__construct	(	Database	$p_cn,
			$pcm_val = "" )

Parameters

type	$p_cn	Database connection
type	$pcm_val	Accounting tmp_pcmn.pcm_val

Definition at line 48 of file acc_account.class.php.

    {
        $this->db=$p_cn;
        $id=-1;
        if ( trim($pcm_val)  != "" ) {
            $pcm_val=mb_strtoupper($pcm_val);
            $pcm_val=$this->db->get_value("select format_account($1)",
                                        array($pcm_val));
            $id=$p_cn->get_value("select id from tmp_pcmn where pcm_val=$1",[$pcm_val]);
        }
        if ( $id == "") { $id=-1;}
        $this->data_sql=new Tmp_Pcmn_SQL($p_cn, $id);
        $this->data_sql->pcm_val=$pcm_val;
 
    }

References $id, db, and DatabaseCore\get_value().

Here is the call graph for this function:

Member Function Documentation

count()

Acc_Account::count

(

$p_value

)

Definition at line 102 of file acc_account.class.php.

    {
        $sql="select count(*) from tmp_pcmn where pcm_val=$1";
        return $this->db->get_value($sql,array($p_value));
    }

References $sql, and db.

delete()

Acc_Account::delete

(

)

Definition at line 174 of file acc_account.class.php.

                      {
        // if already use cannot be deleted
        if ( $this->data_sql->count("where pcm_val in (select j_poste from jrnx where j_poste=$1) or pcm_val_parent=$1", 
                [$this->data_sql->pcm_val]) > 0)
        {
            throw new Exception(_("Poste utilisé : effacement interdit"),EXC_PARAM_VALUE);
        }
        $this->data_sql->delete();
 
    }

References _, and EXC_PARAM_VALUE.

find_by_value()

Acc_Account::find_by_value

(

$p_pcm_val

)

Definition at line 184 of file acc_account.class.php.

    {
        $id=$this->db->get_value("select id from tmp_pcmn where pcm_val=$1",[$p_pcm_val]);
        $this->data_sql->setp("id",$id);
        $this->data_sql->load();
    }

References $id, and db.

find_parent()

Acc_Account::find_parent

(

)

Find the parent of an account.

Returns

string (pcm_val)

Definition at line 111 of file acc_account.class.php.

                           {
        $name=$this->data_sql->pcm_val;
        $length_name=strlen($name);
        $parent="";
        for ($i = 1;$i <$length_name;$i++) {
            $parent=mb_substr($name, 0, $length_name-$i);
            $exist=$this->db->get_value("select count(*) from tmp_pcmn where pcm_val=$1",[$parent]);
            if ( $exist == 1) return $parent;
        }
        
        return $parent;
    }

References $i, $name, and db.

Referenced by verify().

get_lib()

Acc_Account::get_lib

(

)

Return the name of a account it doesn't change any data member.

Returns

string with the pcm_lib

Definition at line 77 of file acc_account.class.php.

    {
        $ret=$this->data_sql->getp('pcm_lib');
        if ( $ret !="")
        {
            return $ret;
        }
        else
        {
            return _("Poste inconnu");
        }
    }

References $ret, and _.

get_parameter()

Acc_Account::get_parameter

(

$p_string

)

Definition at line 63 of file acc_account.class.php.

    {
       return $this->data_sql->getp($p_string);
    }

insert()

Acc_Account::insert

(

)

Definition at line 169 of file acc_account.class.php.

                      {
        // check for Duplicate key, parent ... see Acc_Plan_MTable
        $this->verify();
        $this->data_sql->insert();
    }

References verify().

Here is the call graph for this function:

load()

Acc_Account::load

(

)

Get all the value for this object from the database the data member are set.

Returns

false if this account doesn't exist otherwise true

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

                   :bool
    {
      return $this->data_sql->load();
    }

save()

Acc_Account::save

(

)

Definition at line 190 of file acc_account.class.php.

                    {
        try {
            $this->verify();
            $this->data_sql->save();
        } catch (Exception $e) {
            throw $e;
        }
    }

References $e, and verify().

Here is the call graph for this function:

searchValue()

Acc_Account::searchValue

(

$p_value

)

Definition at line 89 of file acc_account.class.php.

                                   {
        
        
    }

set_parameter()

Acc_Account::set_parameter	(		$p_string,
			$p_value )

Definition at line 68 of file acc_account.class.php.

    {
       return $this->data_sql->setp($p_string,$p_value);
 
    }

update()

Acc_Account::update

(

)

Definition at line 164 of file acc_account.class.php.

                      {
        // check for Duplicate key, parent ... see Acc_Plan_MTable
        $this->verify();
        $this->data_sql->update();
    }

References verify().

Here is the call graph for this function:

verify()

Acc_Account::verify

(

)

Check before inserting or updating.

Definition at line 126 of file acc_account.class.php.

                      {
        // check for Duplicate key, parent ... see Acc_Plan_MTable
        $count=$this->data_sql->count(" where pcm_val =$1 and id <> $2",
                           [mb_strtoupper($this->data_sql->pcm_val),$this->data_sql->id]);
        if ( $count > 0)
            throw new Exception (_("Poste en double"),EXC_DUPLICATE);
        
        if (noalyss_trim($this->data_sql->pcm_lib)=="")
            throw new Exception (_("Libellé vide"),EXC_PARAM_VALUE);
        
        // can not depend of itself
        if ( $this->data_sql->pcm_val_parent == $this->data_sql->pcm_val)
            throw new Exception (_("Poste parent incorrect"),EXC_PARAM_VALUE);
        
        if ( $this->data_sql->pcm_val_parent == "") {
            $account=$this->find_parent();
            $this->data_sql->pcm_val_parent=$account;
            if ($account == "") 
                throw new Exception (_("Poste Parent n'existe pas"),EXC_PARAM_VALUE);
        }
        
        // purpose not clear
        if ( $this->data_sql->count(" where pcm_val = $1 and pcm_val <> $2",
                [$this->data_sql->pcm_val_parent,$this->data_sql->pcm_val])  == 0)
            throw new Exception (_("Poste Parent n'existe pas"),EXC_PARAM_VALUE);
        
     
        if ( $this->data_sql->pcm_direct_use != 'N' && $this->data_sql->pcm_direct_use != 'Y') 
            throw new Exception (_("Paramètre incorrect"),EXC_PARAM_VALUE);
        
        if ( trim($this->data_sql->pcm_val)==""||trim($this->data_sql->pcm_val_parent)=="")
            throw new Exception (_("Paramètre incorrect"),EXC_PARAM_VALUE);
        
        if ( strlen($this->data_sql->pcm_val)>40) {
            throw new Exception (_("Poste comptable doit être de 40 caractères maximum"),EXC_PARAM_VALUE);
        }
                
    }

References $account, $count, _, EXC_DUPLICATE, EXC_PARAM_VALUE, find_parent(), and noalyss_trim().

Referenced by insert(), save(), and update().

Here is the call graph for this function:

Field Documentation

$data_sql

Acc_Account::$data_sql

private

Definition at line 31 of file acc_account.class.php.

$db

Acc_Account::$db

$db database connection

Definition at line 30 of file acc_account.class.php.

$type

Acc_Account::$type

static

Initial value:

=array(
                            array('label'=>'Actif','value'=>'ACT'),
                            array('label'=>'Passif','value'=>'PAS'),
                            array('label'=>'Actif c. inverse','value'=>'ACTINV'),
                            array('label'=>'Passif c.inverse','value'=>'PASINV'),
                            array('label'=>'Produit','value'=>'PRO'),
                            array('label'=>'Produit Inverse','value'=>'PROINV'),
                            array('label'=>'Charge','value'=>'CHA'),
                            array('label'=>'Charge Inverse','value'=>'CHAINV'),
                            array('label'=>'Contexte','value'=>'CON')
                        )

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

---

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

• include/class/acc_account.class.php