Anc_Account Class Reference

Analytic account ; get the balance. More...

Collaboration diagram for Anc_Account:

Public Member Functions
	__construct ($p_cn, $p_id=-1)
	get_balance ($p_cond_sql)
	Get the balance of an Analytic account. More...
	get_poste_analytique_sql ()
	load_by_code ($p_code)
	retrieve the Analytic account thanks its code More...
	set_poste_analytique_sql ($poste_analytique_sql)

Private Attributes
	$poste_analytique_sql

Detailed Description

Analytic account ; get the balance.

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

Constructor & Destructor Documentation

__construct()

Anc_Account::__construct	(		$p_cn,
			$p_id = -1
	)

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

    {
        $this->poste_analytique_sql=new Poste_analytique_SQL($p_cn, $p_id);
    }

References $p_id.

Member Function Documentation

get_balance()

Anc_Account::get_balance

(

$p_cond_sql

)

Get the balance of an Analytic account.

Parameters

string

$p_cond_sql

SQL condition to filter , usually the period

See also

Impress::compute_amount

Returns

array key = credit , debit , solde

Definition at line 55 of file anc_account.class.php.

    {
        if ( DEBUGNOALYSS > 1) 
          {
              tracedebug("impress.debug.log", "$p_cond_sql", 'Anc_Account->get_balance \$p_cond_sql');
          }
        $cn=$this->poste_analytique_sql->cn;
        $detail=$cn->get_row("
              select  ( select coalesce (sum(oa1.oa_amount),0) 
              from operation_analytique oa1  
              where oa1.po_id=$1 
                and oa1.oa_debit='t' 
                $p_cond_sql 
                    )  as debit,
                ( select coalesce (sum(oa2.oa_amount),0)  
                from operation_analytique oa2  
                    where oa2.po_id=$1 
                    and oa2.oa_debit='f'
                    $p_cond_sql 
                 ) as credit
                 ",[$this->poste_analytique_sql->getp("po_id")]);
         if ( DEBUGNOALYSS > 1) 
          {
              tracedebug("impress.debug.log", $cn->sql, 'Anc_Account->get_balance SQL executed');
          }
        $tdetail['credit']=$detail['credit'];
        $tdetail['debit']=$detail['debit'];
        $tdetail['solde']=abs(bcsub($detail['debit'],$detail['credit']));
        return $tdetail;
        
        
    }

References $cn, and $detail.

get_poste_analytique_sql()

Anc_Account::get_poste_analytique_sql

(

)

Definition at line 40 of file anc_account.class.php.

    {
        return $this->poste_analytique_sql;
    }

References $poste_analytique_sql.

load_by_code()

Anc_Account::load_by_code

(

$p_code

)

retrieve the Analytic account thanks its code

Parameters

type

$p_code

Returns

type

Definition at line 92 of file anc_account.class.php.

    {
        $cn=$this->poste_analytique_sql->cn;
        $p_id= $cn->get_value("select po_id from poste_analytique where po_name=$1",
                [ trim(strtoupper($p_code))]);
        $p_id=(empty($p_id))?-1:$p_id;
        $this->poste_analytique_sql->setp('po_id',$p_id);
        $this->poste_analytique_sql->load();
        return $this->poste_analytique_sql;
    }

References $cn, $p_id, and $poste_analytique_sql.

set_poste_analytique_sql()

Anc_Account::set_poste_analytique_sql

(

$poste_analytique_sql

)

Definition at line 45 of file anc_account.class.php.

                                                                   : void
    {
        $this->poste_analytique_sql=$poste_analytique_sql;
    }

References $poste_analytique_sql.

Field Documentation

$poste_analytique_sql

Anc_Account::$poste_analytique_sql

private

Definition at line 33 of file anc_account.class.php.

Referenced by get_poste_analytique_sql(), load_by_code(), and set_poste_analytique_sql().

---

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

• include/class/anc_account.class.php