Acc_Reconciliation Class Reference

new class for managing the reconciliation it must be used instead of the function InsertRapt, ... More...

Inheritance diagram for Acc_Reconciliation:

Collaboration diagram for Acc_Reconciliation:

Public Member Functions
	__construct ($cn)
	auto_letter ($p_jrid)
	try to letter same card between $p_jrid and $this->jr_id More...
	export_csv ($p_choice)
	Export to CSV. More...
	fill_info ()
	filter_date ()
	create a string to filter thanks the date More...
	get ()
	Return an array of the concerned operation. More...
	get_amount_noautovat ($p_jrn_id, $p_default_amount)
	Retrieve the amount VAT included and autoreversed VAT excluded thanks the view v_quant_detail and return it. More...
	get_data ($p_choice)
	get_not_reconciled ()
	return array of not-reconciled operation Prepare and put in memory the SQL detail_quant More...
	get_reconciled ()
	return array of reconciled operation Prepare and put in memory the SQL detail_quant More...
	get_reconciled_amount ($p_equal=false)
	Prepare and put in memory the SQL detail_quant. More...
	insert ($jr_id2)
	Insert into jrn_rapt the concerned operations. More...
	insert_rapt ($jr_id2)
	Insert into jrn_rapt the concerned operations should not be called directly, use insert instead. More...
	ledger_filter ()
	Create a sql condition to filter by security and by asked ledger based on $this->a_jrn. More...
	prepare_query_detail_quant ()
	remove ($jr_id2)
	Insert into jrn_rapt the concerned operations. More...
	set_jr_id ($jr_id)
	show_detail ($p_ret)
	widget ()
	return a widget of type js_concerned More...

Static Public Member Functions
static	test_me ()

Data Fields
	$a_jrn
	$db
	$end_day
	$jr_id
	$start_day

Detailed Description

new class for managing the reconciliation it must be used instead of the function InsertRapt, ...

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

Constructor & Destructor Documentation

__construct()

Acc_Reconciliation::__construct

(

$cn

)

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

    {
        $this->db=$cn;
        $this->jr_id=0;
        $this->a_jrn=null;
    }

References $cn, a_jrn, db, and jr_id.

Member Function Documentation

auto_letter()

Acc_Reconciliation::auto_letter

(

$p_jrid

)

try to letter same card between $p_jrid and $this->jr_id

Parameters

jrn.jr_id

$p_jrid the operation to reconcile

Reimplemented in Acc_Reconciliation_Lettering.

Definition at line 153 of file acc_reconciliation.class.php.

        {
                // Try to find same card from both operation
                $sql="select j1.f_id as fiche ,coalesce(j1.j_id,-1) as jrnx_id1,coalesce(j2.j_id,-1) as jrnx_id2,
j1.j_poste as poste
                                from jrnx as j1
                                        join jrn as jr1 on (j1.j_grpt=jr1.jr_grpt_id)
                                        join jrnx as j2 on (coalesce(j1.f_id,-1)=coalesce(j2.f_id,-1) and j1.j_poste=j2.j_poste)
                                        join jrn as jr2 on (j2.j_grpt=jr2.jr_grpt_id)
                                where
                                        jr1.jr_id=$1
                                        and
                                        jr2.jr_id= $2";
                $result=$this->db->get_array($sql,array($this->jr_id,$p_jrid));
                if ( count($result) == 0)
                {
                        return;
                }
                for ($i=0;$i<count($result);$i++)
                {
                        if ( $result[$i]['fiche'] != -1)
                        {
                                $letter = new Lettering_Card($this->db);
                                $letter->insert_couple($result[$i]['jrnx_id1'],$result[$i]['jrnx_id2']);
                        }
                        else
                        {
                                $letter = new Lettering_Account($this->db);
                                $letter->insert_couple($result[$i]['jrnx_id1'],$result[$i]['jrnx_id2']);
                        }
                }
 
        }

References $i, $letter, $result, $sql, db, and jr_id.

Referenced by insert_rapt().

export_csv()

Acc_Reconciliation::export_csv

(

$p_choice

)

Export to CSV.

Parameters

type

$p_choice

Note

must be set before calling

• $this->a_jrn array of ledger
• $this->start_day start date
• $this->end_day end date

See also

Acc_Reconciliation::get_data

Definition at line 474 of file acc_reconciliation.class.php.

    {
        $export=new Noalyss_Csv(_('rapprochement'));
        $export->send_header();
 
        $array = $this->get_data($p_choice);
        for ($i = 0; $i < count($array); $i++)
        {
            // ---------------------------------------
            // first index has 2 arrays : first & depend[]
            // ---------------------------------------
 
            $first = $array[$i]['first'];
            $a_depend = array();
            $title=array();
            if (isset($array[$i]['depend']))
            {
                $a_depend = $array[$i]['depend'];
                //----- HEADER ----
                if ($i == 0)
                {
                    $title[]=_('n°');
                    $title[]=_('Date');
                    $title[]=_('internal');
                    $title[]=_('libellé');
                    $title[]=_('pièce');
                    $title[]=_('journal');
                    $title[]=_('type journal');
                    $title[]=_('montant');
                    $title[]=_('<->');
                    $title[]=_('Date');
                    $title[]=_('Interne');
                    $title[]=_('libell');
                    $title[]=_('pièce');
                    $title[]=_('nom journal');
                    $title[]=_('type journal');
                    $title[]=_('montant');
 
                }
            }
            else
            {
                //----- HEADER ----
                if ($i == 0)
                {
                    $title[]=_('n°');
                    $title[]=_('Date');
                    $title[]=_('interne');
                    $title[]=_('libellé');
                    $title[]=_('pièce');
                    $title[]=_('journal');
                    $title[]=_('type journal');
                    $title[]=_('montant');
 
                }
            }
            $export->write_header($title);
            //-----------------------------------------
            //Retrieve amount without autoreversed VAT
            //-----------------------------------------
            $amount=$this->get_amount_noautovat($first['jr_id'],$first['jr_montant']);
            
            // --------------------------
            // Print First
            // --------------------------
            $export->add($i,"number");
            $export->add($first['jr_date']);
            $export->add($first['jr_internal']);
            $export->add($first['jr_comment']);
            $export->add($first['jr_pj_number']);
            $export->add($first['jrn_def_name']);
            $export->add($first['jrn_def_type']);
            $export->add($amount,"number");
            if (count($a_depend) > 0)
            {
                // --------------------------------------
                // Print first depending operation
                // --------------------------------------
                $depend = $a_depend[0];
                $export->add("<->");
                $amount_dep=$this->get_amount_noautovat($depend['jr_id'],$depend['jr_montant']);
                $export->add($depend['jr_date']);
                $export->add($depend['jr_internal']);
                $export->add($depend['jr_comment']);
                $export->add($depend['jr_pj_number']);
                $export->add($depend['jrn_def_name']);
                $export->add($depend['jrn_def_type']);
                $export->add($amount_dep,"number");
                $export->write();
                // --------------------------------------
                // print other depending operation if any
                // --------------------------------------
                for ($e = 1; $e < count($a_depend); $e++)
                {
                    $amount_dep=$this->get_amount_noautovat($depend['jr_id'],$depend['jr_montant']);
                    $depend = $a_depend[$e];
                    $export->add("");
                    $export->add("");
                    $export->add("");
                    $export->add("");
                    $export->add("");
                    $export->add("");
                    $export->add("");
                    $export->add("");
                    $export->add("<->");
                    $export->add($depend['jr_date']);
                    $export->add($depend['jr_internal']);
                    $export->add($depend['jr_comment']);
                    $export->add($depend['jr_pj_number']);
                    $export->add($depend['jrn_def_name']);
                    $export->add($depend['jrn_def_type']);
                    $export->add($amount_dep,"number");
                    $export->write();
                }
            }
            else
            {
                $export->write();
            }
        }
    }

References $amount, $array, $e, $export, $i, $title, get_amount_noautovat(), and get_data().

Here is the call graph for this function:

fill_info()

Acc_Reconciliation::fill_info

(

)

Definition at line 264 of file acc_reconciliation.class.php.

    {
        $sql="select jr_id,jr_date,jr_comment,jr_internal,jr_montant,jr_pj_number,jr_def_id,jrn_def_name,jrn_def_type
             from jrn join jrn_def on (jrn_def_id=jr_def_id)
             where jr_id=$1";
        $a=$this->db->get_array($sql,array($this->jr_id));
        return $a[0];
    }

References $a, $sql, db, and jr_id.

Referenced by get_not_reconciled(), and get_reconciled().

filter_date()

Acc_Reconciliation::filter_date

(

)

create a string to filter thanks the date

Returns

a sql string like jr_date > ... and jr_date < ....

Note

use the data member start_day and end_day

See also

get_reconciled get_not_reconciled

Definition at line 434 of file acc_reconciliation.class.php.

    {
      global $g_user;
      list($start,$end)=$g_user->get_limit_current_exercice();
 
      if (isDate($this->start_day) ==null)
        {
          $this->start_day=$start;
        }
      if ( isDate($this->end_day) == null)
        {
          $this->end_day=$end;
        }
      $sql=" (jr_date >= to_date('".$this->start_day."','DD.MM.YYYY')
                and jr_date <= to_date('".$this->end_day."','DD.MM.YYYY'))";
      return $sql;
 
    }

References $end, $g_user, $sql, $start, end_day, isDate(), and start_day.

Referenced by get_not_reconciled(), and get_reconciled().

Here is the call graph for this function:

get()

Acc_Reconciliation::get

(

)

Return an array of the concerned operation.

Parameters

database

connection

Returns

array if something is found or null

Definition at line 244 of file acc_reconciliation.class.php.

    {
        $sql=" select jr_id as cn from jrn_rapt where jra_concerned=$1
              union 
              select jra_concerned as cn from jrn_rapt where jr_id=$2";
        $Res=$this->db->exec_sql($sql,array($this->jr_id,$this->jr_id));
 
        // If nothing is found return null
        $n=Database::num_row($Res);
 
        if ($n ==0 ) return [];
 
        // put everything in an array
        for ($i=0;$i<$n;$i++)
        {
            $l=Database::fetch_array($Res,$i);
            $r[$i]=$l['cn'];
        }
        return $r;
    }

References $i, $l, $r, $Res, $sql, db, DatabaseCore\fetch_array(), jr_id, and DatabaseCore\num_row().

Here is the call graph for this function:

get_amount_noautovat()

Acc_Reconciliation::get_amount_noautovat	(		$p_jrn_id,
			$p_default_amount
	)

Retrieve the amount VAT included and autoreversed VAT excluded thanks the view v_quant_detail and return it.

If the operation is not a sale or a purchase , it doesn't exist in the view then the function just returns the default amount

Parameters

type	$p_jrn_id	jrn.jr_id
type	$p_default_amount	amount to return if not found in the view v_quant_detail

Returns

number

Definition at line 644 of file acc_reconciliation.class.php.

                                                               {
        static $p=0;
        if ( $p==0) {
            $this->prepare_query_detail_quant();
            $p=1;
        }
        
        $retdb=$this->db->execute("detail_quant",array($p_jrn_id));
        if ( Database::num_row($retdb) != 0)
        {
            // then second_amount takes in account the vat_sided
            $row=Database::fetch_array($retdb, 0);
            $total_price=bcadd($row['price'],$row['vat_amount']);
            $total_price=bcsub($total_price,$row['vat_sided']);
            $first_amount=$total_price;
 
        } else {
            // else take the amount from jrn
            $first_amount=$p_default_amount;
        }
        return $first_amount;
        
    }

References $p, $row, db, DatabaseCore\fetch_array(), DatabaseCore\num_row(), and prepare_query_detail_quant().

Referenced by export_csv().

Here is the call graph for this function:

get_data()

Acc_Reconciliation::get_data

(

$p_choice

)

Parameters

type

$p_choice

0 : operation reconcilied 1 : reconcilied with different amount 2 : reconcilied with same amount 3 : not reconcilied

Returns

$array

Definition at line 605 of file acc_reconciliation.class.php.

    {
        switch ($p_choice)
        {
            case 0:
                $array = $this->get_reconciled();
                break;
            case 1:
                $array = $this->get_reconciled_amount(false);
                break;
            case 2:
                $array = $this->get_reconciled_amount(true);
                break;
            case 3:
                $array = $this->get_not_reconciled();
                break;
            default:
                echo "Choix invalid";
                throw new Exception("invalide");
        }
        return $array;
    }

References $array, get_not_reconciled(), get_reconciled(), and get_reconciled_amount().

Referenced by export_csv().

Here is the call graph for this function:

get_not_reconciled()

Acc_Reconciliation::get_not_reconciled

(

)

return array of not-reconciled operation Prepare and put in memory the SQL detail_quant

Definition at line 276 of file acc_reconciliation.class.php.

    {
      $filter_date=$this->filter_date();
      /* create ledger filter */
      $sql_jrn=$this->ledger_filter();
 
        $array=$this->db->get_array("select distinct jr_id,jr_date from jrn where $filter_date and $sql_jrn and jr_id not in (select jr_id from jrn_rapt union select jra_concerned from jrn_rapt) order by jr_date");
        $ret=array();
        for ($i=0;$i<count($array);$i++)
        {
            $this->jr_id=$array[$i]['jr_id'];
            $ret[$i]['first']=$this->fill_info();
        }
        return $ret;
    }

References $array, $i, $ret, db, fill_info(), filter_date(), jr_id, and ledger_filter().

Referenced by get_data().

Here is the call graph for this function:

get_reconciled()

Acc_Reconciliation::get_reconciled

(

)

return array of reconciled operation Prepare and put in memory the SQL detail_quant

Returns

Note

See also

Definition at line 328 of file acc_reconciliation.class.php.

    {
      $filter_date=$this->filter_date();
 
 
        /* create ledger filter */
        $sql_jrn=$this->ledger_filter();
 
        $array=$this->db->get_array("select distinct jr_id,jr_date from jrn where $filter_date and $sql_jrn and jr_id  in (select jr_id from jrn_rapt union select jra_concerned from jrn_rapt) order by jr_date");
        $ret=array();
        for ($i=0;$i<count($array);$i++)
        {
            $this->jr_id=$array[$i]['jr_id'];
            $ret[$i]['first']=$this->fill_info();
            $atmp=$this->get();
            for ( $e=0;$e<count($atmp);$e++)
            {
                $this->jr_id=$atmp[$e];
                $ret[$i]['depend'][$e]=$this->fill_info();
            }
        }
        
        return $ret;
    }

References $array, $e, $i, $ret, db, fill_info(), filter_date(), jr_id, and ledger_filter().

Referenced by get_data(), and get_reconciled_amount().

Here is the call graph for this function:

get_reconciled_amount()

Acc_Reconciliation::get_reconciled_amount

(

$p_equal = false

)

Prepare and put in memory the SQL detail_quant.

Parameters

return

Note

See also

Definition at line 363 of file acc_reconciliation.class.php.

    {
        $array=$this->get_reconciled();
        $ret=array();
        bcscale(2);
        $this->prepare_query_detail_quant();
        for ($i=0;$i<count($array);$i++)
        {
            
             $retdb=$this->db->execute("detail_quant",array($array[$i]['first']['jr_id']));
            if ( Database::num_row($retdb) != 0)
            {
                  // then second_amount takes in account the vat_sided
                $a_row=Database::fetch_all($retdb);
                $total_price=0;
                foreach ($a_row as $row) {
                    $total_price=bcadd($total_price,$row['price']);
                    $total_price=bcadd($total_price,$row['vat_amount']);
                    $total_price=bcsub($total_price,$row['vat_sided']);
                    $total_price=bcadd($total_price,$row['nd_amount']);
                    $total_price=bcadd($total_price,$row['nd_tva_recup']);
                    
                }
                $first_amount=$total_price;
 
            } else {
                // else take the amount from jrn
                $first_amount=$array[$i]['first']['jr_montant'];
            }
            $second_amount=0;
            for ($e=0;$e<count($array[$i]['depend']);$e++)
            {
                $retdb=$this->db->execute("detail_quant",array($array[$i]['depend'][$e]['jr_id']));
                // if exist in v_quant_detail
                if ( Database::num_row($retdb) != 0)
                {
                    // then second_amount takes in account the vat_sided
                   $a_row=Database::fetch_all($retdb);
                    $total_price=0;
                    foreach ($a_row as $row) {
                        $total_price=bcadd($total_price,$row['price']);
                        $total_price=bcadd($total_price,$row['vat_amount']);
                        $total_price=bcsub($total_price,$row['vat_sided']);
                        $total_price=bcadd($total_price,$row['nd_amount']);
                        $total_price=bcadd($total_price,$row['nd_tva_recup']);
                    
                     }
                    $second_amount=bcadd($second_amount,$total_price);
                    
                } else {
                // else take the amount from jrn
                  $second_amount=bcadd($second_amount,$array[$i]['depend'][$e]['jr_montant']);
                }
            }
            if ( $p_equal &&  $first_amount==$second_amount)
            {
                $ret[]=$array[$i];
            }
            if ( ! $p_equal &&  $first_amount != $second_amount)
            {
                $ret[]=$array[$i];
            }
        }
        return $ret;
    }

References $a_row, $array, $e, $i, $ret, $row, db, DatabaseCore\fetch_all(), get_reconciled(), DatabaseCore\num_row(), and prepare_query_detail_quant().

Referenced by get_data().

Here is the call graph for this function:

insert()

Acc_Reconciliation::insert

(

$jr_id2

)

Insert into jrn_rapt the concerned operations.

Parameters

$jr_id2

(jrn.jr_id) => jrn_rapt.jra_concerned or a string like "jr_id2,jr_id3,jr_id4..."

Returns

none

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

    {
        if ( trim($jr_id2) == "" )
            return;
        if ( strpos($jr_id2,',') !== 0 )
        {
            $aRapt=explode(',',$jr_id2);
            foreach ($aRapt as $rRapt)
            {
                if ( isNumber($rRapt) == 1 )
                {
                    $this->insert_rapt($rRapt);
                }
            }
        }
        else
            if ( isNumber($jr_id2) == 1 )
            {
                $this->insert_rapt($jr_id2);
            }
    }

References insert_rapt(), and isNumber().

Here is the call graph for this function:

insert_rapt()

Acc_Reconciliation::insert_rapt

(

$jr_id2

)

Insert into jrn_rapt the concerned operations should not be called directly, use insert instead.

Parameters

$jr_id2

(jrn.jr_id) => jrn_rapt.jra_concerned

Returns

none

Definition at line 100 of file acc_reconciliation.class.php.

    {
        if ( isNumber($this->jr_id)  == 0 ||  isNumber($jr_id2) == 0 )
        {
            return false;
        }
        if ( $this->jr_id==$jr_id2)
            return true;
 
                if ( $this->db->count_sql("select jr_id from jrn where jr_id=".$this->jr_id)==0 )
                                return false;
                if ( $this->db->count_sql("select jr_id from jrn where jr_id=".$jr_id2)==0 )
                                return false;
 
        // verify if exists
        if ( $this->db->count_sql(
                    "select jra_id from jrn_rapt where jra_concerned=".$this->jr_id.
                    " and jr_id=$jr_id2
                    union
                    select jra_id from jrn_rapt where jr_id=".$this->jr_id.
                    " and jra_concerned=$jr_id2 ")
                ==0)
        {
            // Ok we can insert
            $Res=$this->db->exec_sql("insert into jrn_rapt(jr_id,jra_concerned) values ".
                                    "(".$this->jr_id.",$jr_id2)");
            // try to letter automatically same account from both operation
            $this->auto_letter($jr_id2);
            
            // update date of paiement -----------------------------------------------------------------------
            $source_type=$this->db->get_value("select substr(jr_internal,1,1) from jrn where jr_id=$1",array($this->jr_id));
            $dest_type=$this->db->get_value("select substr(jr_internal,1,1) from jrn where jr_id=$1",array($jr_id2));
            if (($source_type =='A' || $source_type=='V') && ($dest_type != 'A' && $dest_type != 'V'))
            {
                // set the date on source
                $date=$this->db->get_value('select jr_date from jrn where jr_id=$1',array($jr_id2));
                if ( trim ($date) == '') $date=null;
                $this->db->exec_sql('update jrn set jr_date_paid=$1 where jr_id=$2 and jr_date_paid is null ',array($date,$this->jr_id));
            }
            if (($source_type !='A' && $source_type !='V') && ($dest_type == 'A' || $dest_type == 'V'))
            {
                // set the date on dest
                $date=$this->db->get_value('select jr_date from jrn where jr_id=$1',array($this->jr_id));
                if (trim($date) == '') $date=null;
                $this->db->exec_sql('update jrn set jr_date_paid=$1 where jr_id=$2 and jr_date_paid is null ',array($date,$jr_id2));
            }
        }
        return true;
    }

References $date, $Res, auto_letter(), db, isNumber(), and jr_id.

Referenced by insert(), and Acc_Reconciliation_Lettering\insert_reconcilied().

Here is the call graph for this function:

ledger_filter()

Acc_Reconciliation::ledger_filter

(

)

Create a sql condition to filter by security and by asked ledger based on $this->a_jrn.

Returns

a valid sql stmt to include

See also

get_not_reconciled get_reconciled

Definition at line 297 of file acc_reconciliation.class.php.

    {
        global $g_user;
        /* get the available ledgers for current user */
        $sql=$g_user->get_ledger_sql('ALL',3);
        $sql=noalyss_str_replace('jrn_def_id','jr_def_id',$sql);
        $r='';
        /* filter by this->r_jrn */
        if ( ! empty ($this->a_jrn ) && is_array($this->a_jrn))
        {
            $sep='';
            $r='and jr_def_id in (';
            foreach( $this->a_jrn as $key=>$value)
            {
                $r.=$sep.$value;
                $sep=',';
            }
            $r.=')';
        }
        return $sql.'  '.$r;
    }

References $g_user, $r, $sep, $sql, $value, a_jrn, and noalyss_str_replace().

Referenced by get_not_reconciled(), and get_reconciled().

Here is the call graph for this function:

prepare_query_detail_quant()

Acc_Reconciliation::prepare_query_detail_quant

(

)

Definition at line 627 of file acc_reconciliation.class.php.

    {
        static $seen=0;
        if ( $seen == 1) return;
        $this->db->prepare('detail_quant','select * from v_quant_detail where jr_id=$1');
        $seen=1;
    }

References db.

Referenced by get_amount_noautovat(), and get_reconciled_amount().

remove()

Acc_Reconciliation::remove

(

$jr_id2

)

Insert into jrn_rapt the concerned operations.

Parameters

$this->jr_id	(jrn.jr_id) => jrn_rapt.jr_id
$jr_id2	(jrn.jr_id) => jrn_rapt.jra_concerned

Returns

none

remove also lettering between both operation

Definition at line 195 of file acc_reconciliation.class.php.

    {
        if ( isNumber($this->jr_id)  == 0 or
                isNumber($jr_id2) == 0 )
        {
            return;
        }
        // verify if exists
        if ( $this->db->count_sql("select jra_id from jrn_rapt where ".
                                  " jra_concerned=".$this->jr_id."  and jr_id=$jr_id2
                                  union
                                  select jra_id from jrn_rapt where jra_concerned=$jr_id2 ".
                                  " and jr_id=".$this->jr_id) !=0)
        {
                        /**
                         * remove also lettering between both operation
                         */
                        $sql = " delete from
                                        jnt_letter
                                        where jl_id in ( select jl_id from jnt_letter
                                                                                join letter_cred as lc using(jl_id)
                                                                                join letter_deb as ld using (jl_id)
                                                                        where
                                                                                lc.j_id in (select j_id
                                                                                                        from jrnx join jrn on (j_grpt=jr_grpt_id)
                                                                                                        where jr_id in ($1,$2))
                                                                                or
                                                                                ld.j_id in (select j_id
                                                                                                        from jrnx join jrn on (j_grpt=jr_grpt_id)
                                                                                                        where jr_id in ($1,$2))
 
 
 
                                                        )";
                        $this->db->exec_sql($sql, array($jr_id2, $this->jr_id));
                        // Ok we can delete
                        $Res=$this->db->exec_sql("delete from jrn_rapt where ".
                                     "(jra_concerned=$jr_id2 and jr_id=".$this->jr_id.") or
                                     (jra_concerned=".$this->jr_id." and jr_id=$jr_id2) ");
        }
    }

References $Res, $sql, db, isNumber(), and jr_id.

Here is the call graph for this function:

set_jr_id()

Acc_Reconciliation::set_jr_id

(

$jr_id

)

Definition at line 46 of file acc_reconciliation.class.php.

    {
        $this->jr_id=$jr_id;
    }

References $jr_id, and jr_id.

Referenced by Acc_Reconciliation_Lettering\insert_reconcilied().

show_detail()

Acc_Reconciliation::show_detail

(

$p_ret

)

Definition at line 452 of file acc_reconciliation.class.php.

    {
        if (Database::num_row($p_ret)> 0)
        {
            echo '<tr class="odd">';
            echo '<td></td>';
            echo '<td colspan="5" style="border:1px solid black;width:auto">';
            include NOALYSS_TEMPLATE.'/impress_reconciliation_detail.php';
            echo '</td>';
            echo '</tr>';
        }
    }

References DatabaseCore\num_row().

Here is the call graph for this function:

test_me()

static Acc_Reconciliation::test_me ( )

static

Definition at line 667 of file acc_reconciliation.class.php.

    {
        $cn=Dossier::connect();
        $rap=new Acc_Reconciliation($cn);
        var_dump($rap->get_reconciled_amount('',false));
    }

References $cn, $rap, and Dossier\connect().

Here is the call graph for this function:

widget()

Acc_Reconciliation::widget

(

)

return a widget of type js_concerned

Definition at line 52 of file acc_reconciliation.class.php.

    {
        $wConcerned=new IConcerned();
        $wConcerned->extra=0; // with 0 javascript search from e_amount... field (see javascript)
 
        return $wConcerned;
 
    }

Field Documentation

$a_jrn

Acc_Reconciliation::$a_jrn

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

$db

Acc_Reconciliation::$db

database connection

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

$end_day

Acc_Reconciliation::$end_day

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

$jr_id

Acc_Reconciliation::$jr_id

jr_id

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

Referenced by set_jr_id().

$start_day

Acc_Reconciliation::$start_day

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

---

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

• include/class/acc_reconciliation.class.php