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
	build_temp_total_operation ()
	build a temporary table with all operation + dependencies
	export_csv ($p_choice)
	Export to CSV.
	fill_info ()
	retrieve row from JRN
	filter_date ()
	create a string to filter thanks the date
	get ()
	Return an array of the concerned operation.
	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.
	get_data ($p_choice)
	retrieve data
	get_not_reconciled ()
	return array of not-reconciled operation Prepare and put in memory the SQL detail_quant
	get_reconciled ()
	return array of reconciled operation Prepare and put in memory the SQL detail_quant
	get_reconciled_amount ($p_equal=false)
	Prepare and put in memory the SQL detail_quant.
	insert ($jr_id2)
	Insert into jrn_rapt the concerned operations.
	insert_rapt ($jr_id2)
	Insert into jrn_rapt the concerned operations should not be called directly, use insert instead.
	ledger_filter ()
	Create a sql condition to filter by security and by asked ledger based on $this->a_jrn.
	prepare_query_detail_quant ()
	remove ($jr_id2)
	Insert into jrn_rapt the concerned operations.
	set_jr_id ($jr_id)
	show_detail ($p_ret)
	widget ()
	return a widget of type js_concerned

Static Public Member Functions
static	test_me ()

Data Fields
	$a_jrn
	$db
	$end_day
	$jr_id
	$start_day
const	SQL_ALL_OPERATION_RECONCILIED
	query for building the temporary table TEMP_TOTAL_OPERATION
const	SQL_QUERY

Detailed Description

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

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

Constructor & Destructor Documentation

__construct()

Acc_Reconciliation::__construct

(

$cn

)

Definition at line 124 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 232 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().

build_temp_total_operation()

Acc_Reconciliation::build_temp_total_operation

(

)

build a temporary table with all operation + dependencies

Returns

type

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

                                          {
        static $done=false;
        if ( $done  ) {
            return;
        }
        global $g_user;
        $filter_date = str_replace("jr_date", "jr1.jr_date", $this->filter_date());
 
        /* create ledger filters */
        $sql_jrn = $this->ledger_filter();
        $sql_jrn1 = str_replace("jr_def_id", "jr1.jr_def_id", $sql_jrn);
 
        /* security on the ledger */
        $sql = $g_user->get_ledger_sql('ALL', 3);
        $sql_jrn2 = noalyss_str_replace('jrn_def_id', 'jr2.jr_def_id', $sql);
 
        $sql_string = Acc_Reconciliation::SQL_ALL_OPERATION_RECONCILIED;
        $sql_string = str_replace("FILTER_DATE", $filter_date, $sql_string);
        $sql_string = str_replace("LEDGER_FILTER1", $sql_jrn1, $sql_string);
        $sql_string = str_replace("LEDGER_FILTER2", $sql_jrn2, $sql_string);
        try {
            
            $this->db->exec_sql(" create temporary table temp_total_operation as $sql_string");
            $done=true;
        } catch (Exception $exc) {
            echo $exc->getMessage();
            return;
        }
    }

References $g_user, $sql, db, filter_date(), ledger_filter(), noalyss_str_replace(), and SQL_ALL_OPERATION_RECONCILIED.

Referenced by get_not_reconciled(), get_reconciled(), and get_reconciled_amount().

Here is the call graph for this function:

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 566 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++) {
            if ( $i == 0)
            {
                $title[] = _('n°');
                $title[] = _('Date');
                $title[] = _('pièce');
                $title[] = _('internal');
                $title[] = _('Qcode');
                $title[] = _('Nom');
                $title[] = _('libellé');
                $title[] = _('journal');
                $title[] = _('type journal');
                $title[] = _('montant');
                $export->write_header($title);
            }
            $export->add($i, "number");
            $export->add($array[$i]['str_jr1_jr_date']);
            $export->add($array[$i]['jr1_jr_pj_number']);
            $export->add($array[$i]['jr1_jr_internal']);
            $export->add($array[$i]['tiers_qcode']);
            $export->add($array[$i]['tiers_name']);
            $export->add($array[$i]['jr1_jr_comment']);
            $export->add($array[$i]['jrn1_jrn_def_name']);
            $export->add($array[$i]['jrn1_jrn_def_type']);
             $x=($array[$i]['to1_sum_amount']!=0)?$array[$i]['to1_sum_amount']:$array[$i]['jr1_jr_montant'];
            $export->add($x, "number");
            $export->write();
            
             if ( $array[$i]['depend_count']>0) {
                $depend=$this->db->get_array("select * 
                        from temp_total_operation 
                        where 
                            jr1_jr_id=$1 and ra1_jra_concerned != jr1_jr_id"
                            ,[$array[$i]['jr1_jr_id']]);
                $nb_depend = count($depend);
                $totdepend=0;$delta=$x;
                for ($e = 0; $e < $nb_depend ; $e++) {
                    $x=($depend[$e]['to2_sum_amount']!=0)?$depend[$e]['to2_sum_amount']:$depend[$e]['jr2_jr_montant'];
                    $totdepend=bcadd($totdepend,$x,2);
                    $delta=bcsub($delta,$x,2);
                    $export->add($i, "number");
                    $export->add($depend[$e]["str_jr2_jr_date"]);
                    $export->add($depend[$e]["jr2_jr_internal"]);
                    $export->add($array[$i]['tiers_name_2']);
                    $export->add($array[$i]['tiers_qcode_2']);
                    $export->add($depend[$e]["jr2_jr_pj_number"]);
                    $export->add($depend[$e]["jr2_jr_comment"]);
                    $export->add($depend[$e]['jrn2_jrn_def_name']);
                    $export->add($depend[$e]['jrn2_jrn_def_type']);
                    $export->add($x, "number");
                    $export->write();
                }
                $export->add("Total");
                $export->add($totdepend,"number");
                $export->add("Différence");
                $export->add($delta,"number");
                $export->write();
                 
             }
            
            
        }
    }

References $array, $delta, $depend, $e, $export, $i, $title, $x, _, db, and get_data().

Here is the call graph for this function:

fill_info()

Acc_Reconciliation::fill_info

(

)

retrieve row from JRN

Deprecated

since version 9307

Returns

type

Definition at line 342 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.

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 527 of file acc_reconciliation.class.php.

                           {
        global $g_user;
        $g_user->db=$this->db;
        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 $db, $end, $g_user, $sql, $start, end_day, isDate(), and start_day.

Referenced by build_temp_total_operation(), and get_not_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 317 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, $n, $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 684 of file acc_reconciliation.class.php.

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

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

Here is the call graph for this function:

get_data()

Acc_Reconciliation::get_data

(

$p_choice

)

retrieve data

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 644 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 354 of file acc_reconciliation.class.php.

                                  {
       $this->build_temp_total_operation();
       $filter_date = $this->filter_date();
        /* create ledger filter */
        $sql_jrn = $this->ledger_filter();
 
        $array = $this->db->get_array("
                  with total_operation as (
        select 
                jn2.jr_id,coalesce(sum(qs_price+qs_vat-qs_vat_sided),0)+coalesce(sum(qp_price+qp_vat-qp_vat_sided+qp.qp_nd_tva + qp.qp_nd_tva_recup),0) sum_amount
        from 
                jrnx jx1 
                join jrn jn2 on (jn2.jr_grpt_id =jx1.j_grpt )
                left join quant_sold qs on (jx1.j_id=qs.j_id) 
                left join quant_purchase qp on (qp.j_id =jx1.j_id)
        group by jn2.jr_id)
,tiers as ( 
        select j_id,qf_other tiers_id from quant_fin
        union
        select j_id,qs_client from quant_sold qs 
        union
        select j_id,qp_supplier from quant_purchase
)
            select distinct
    jr1.jr_id jr1_jr_id
    ,null ra1_jra_concerned 
    ,jr1.jr_date jr1_jr_date
    ,to_char(jr1.jr_date,'DD.MM.YY') as str_jr1_jr_date
    ,jr1.jr_comment jr1_jr_comment
    ,jr1.jr_internal jr1_jr_internal
    ,jr1.jr_montant jr1_jr_montant
    ,case when to1.sum_amount=0 then jr1.jr_montant else to1.sum_amount end to1_sum_amount
    ,jr1.jr_pj_number jr1_jr_pj_number
    ,jr1.jr_def_id jr1_jr_def_id
    ,jrn1.jrn_def_name jrn1_jrn_def_name
    ,jrn1.jrn_def_type jrn1_jrn_def_type
    ,null jr2_jr_date
    ,null str_jr2_jr_date
    ,null jr2_jr_comment
    ,null jr2_jr_internal
    ,null jr2_jr_montant
    ,null to2_sum_amount
    ,null jr2_jr_pj_number
    ,null jr2_jr_def_id
    ,null jrn2_jrn_def_name
    ,null jrn2_jrn_def_type
    ,0 depend_count
    ,(select fd1.ad_value from fiche_detail fd1 where fd1.ad_id=1 and fd1.f_id=t3.tiers_id) as tiers_name
    ,(select fd1.ad_value from fiche_detail fd1 where fd1.ad_id=23 and fd1.f_id=t3.tiers_id) as tiers_qcode
from jrn jr1
join total_operation to1 on (to1.jr_id=jr1.jr_id)
join jrn_def jrn1 on (jrn1.jrn_def_id=jr1.jr_def_id)
left join (select t2.tiers_id,j2.j_grpt from tiers t2 join jrnx j2 on (t2.j_id=j2.j_id) ) as t3 on (t3.j_grpt=jr1.jr_grpt_id )
where 
    $filter_date 
    and $sql_jrn 
    and jr1.jr_id not in (select jr_id from jrn_rapt 
                        union select jra_concerned from jrn_rapt) 
    order by jr_date
");
 
 
       return $array;
    }

References $array, build_temp_total_operation(), db, filter_date(), 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 488 of file acc_reconciliation.class.php.

                              {
        $this->build_temp_total_operation();
        $sql_amount = Acc_Reconciliation::SQL_QUERY;
 
        $a_row = $this->db->get_array("$sql_amount order by jr1_jr_date");
        return $a_row;
    }

References $a_row, build_temp_total_operation(), db, and SQL_QUERY.

Referenced by get_data().

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 507 of file acc_reconciliation.class.php.

                                                     {
        // build temporary table temp_total_operation 
        $this->build_temp_total_operation();
        // SQL with different amount 
        $sql_amount = Acc_Reconciliation::SQL_QUERY;
        if ($p_equal) {
            $sql_amount = $sql_amount . " where bs1.depend_sum_amount = to1_sum_amount ";
        } else {
            $sql_amount = $sql_amount . " where bs1.depend_sum_amount != to1_sum_amount";
        }
        $a_row = $this->db->get_array("$sql_amount order by jr1_jr_date");
        return $a_row;
    }

References $a_row, build_temp_total_operation(), db, and SQL_QUERY.

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 155 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 181 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=$1" ,[ $this->jr_id]) == 0)
            return false;
        if ($this->db->count_sql("select jr_id from jrn where jr_id=$1",[$jr_id2]) == 0)
            return false;
 
        // verify if exists
        if ($this->db->count_sql(
                        "select jra_id from jrn_rapt where jra_concerned=$1
                         and jr_id=$2
                    union
                    select jra_id from jrn_rapt where jr_id= $1
                         and jra_concerned=$2 " ,[$this->jr_id,$jr_id2]) == 0) {
            // Ok we can insert
            $Res = $this->db->exec_sql("insert into jrn_rapt(jr_id,jra_concerned) values ($1,$2)",
                    array($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 425 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 build_temp_total_operation(), and get_not_reconciled().

Here is the call graph for this function:

prepare_query_detail_quant()

Acc_Reconciliation::prepare_query_detail_quant

(

)

Definition at line 665 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');
        // $this->db->prepare('detail_depend',' ');
        $seen = 1;
    }

References db.

Referenced by get_amount_noautovat().

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 268 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=$1 and jr_id= $2) or
                (jra_concerned=$2 and jr_id=$1) ",
                    [$jr_id2,$this->jr_id]);
        }
    }

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 130 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

)

Deprecated

since version 9307

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

                                 {
        if (Database::num_row($p_ret) > 0) {
            echo '<tr >';
            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 711 of file acc_reconciliation.class.php.

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

References $cn, and $rap.

widget()

Acc_Reconciliation::widget

(

)

return a widget of type js_concerned

Definition at line 138 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

$a_jrn array of ledgers id (JRN_DEF.JRN_DEF_ID)

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

$db

Acc_Reconciliation::$db

database connection

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

Referenced by filter_date().

$end_day

Acc_Reconciliation::$end_day

$end_day (text DD.MM.YYYY) last day

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

$jr_id

Acc_Reconciliation::$jr_id

jr_id

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

Referenced by set_jr_id().

$start_day

Acc_Reconciliation::$start_day

$start_day (text DD.MM.YYYY) first day

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

SQL_ALL_OPERATION_RECONCILIED

const Acc_Reconciliation::SQL_ALL_OPERATION_RECONCILIED

query for building the temporary table TEMP_TOTAL_OPERATION

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

Referenced by build_temp_total_operation().

SQL_QUERY

const Acc_Reconciliation::SQL_QUERY

Initial value:

= "
with base_op as (select *
    from temp_total_operation tm1
    where tm1.jr1_jr_id = tm1.ra1_jra_concerned )
, depend_op as (select jr1_jr_id
    , sum(case when to2_sum_amount != 0 then to2_sum_amount else jr2_jr_montant end) depend_sum_amount
    ,count(*) depend_count
    from temp_total_operation tm1
    where tm1.jr1_jr_id != tm1.ra1_jra_concerned
    group by jr1_jr_id )
select *
from base_op bo1
join depend_op bs1 on (bo1.jr1_jr_id = bs1.jr1_jr_id)
"

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

Referenced by get_reconciled(), and get_reconciled_amount().

---

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

• include/class/acc_reconciliation.class.php