this file match the tables jrn & jrnx the purpose is to remove or save accountant writing to these table. More...

Inheritance diagram for Acc_Operation:

Collaboration diagram for Acc_Operation:

Public Member Functions
	__construct ($p_cn)
	constructor set automatically the attributes user and periode

	__toString ()

	display_jrnx_detail ($p_table)
	display_jrnx_detail : get the data from get_jrnx_data and return a string with HTML code

	find_tiers ($pn_jrn_id, $pn_jrnx_id, $p_code)
	Find the tiers of an operation , thanks the SQL prepared query prep_tiers and prep_counterpart.

	form_clone_operation ($p_id)
	create a form to recreate the operation and returns it, it works the same as when you want to correct an operation instead of confirming

	get ()
	retrieve data from jrnx and jrn

	get_amount ()
	return amount of the jr_id

	get_currency_amount ()
	retrieve amount in currency for the operation

	get_data ($p_grpt)
	Get data from jrnx where p_grpt=jrnx(j_grpt)

	get_info ()
	retrieve info from the jrn_info, create 2 new arrays obj->info->command and obj->info->other the columns are the idx

	get_internal ()
	Return the internal value, the property jr_id must be set before.

	get_jrnx_detail ()
	retrieve data from jrnx

	get_ledger ()
	return the jrn_def_id from jrn

	get_quant ()
	retrieve data from the table QUANT_*

	get_sum_other_tax ()
	get the sum of other tax linked to this operation

	insert_jrn ()
	Insert into the table Jrn, the amount is computed from jrnx thanks the group id ($p_grpt)

	insert_jrnx ()
	Insert into the table Jrn The needed data are :

	insert_related_action ($p_string)

	operation_update_comment ($p_text)
	add a comment to the operation (jrn.jr_text)

	operation_update_date_limit ($p_text)
	add a limit of payment to the operation (jrn.jr_ech)

	save_info ($p_info, $p_type)
	Save into jrn_info.

	seek_group ()
	retrieve the grpt_id from jrn for a jr_id

	seek_internal ($p_internal)
	search an operation thankx it internal code

	set_id ($p_id)
	set the operation id (jrn.jr_id)

	set_paid ()
	flag the operation as paid

	update_comment ($p_text)
	add a comment to the line (jrnx.j_text)

	update_receipt ()
	set the pj of a operation in jrn. the jr_id must be set

Static Public Member Functions
static	select_operation_type ($p_status)
	Return a select object to choose the type of operation.

static	test_me ()

Data Fields
	$amount

	$currency_id

	$currency_rate

	$currency_rate_ref

	$date

	$date_paid

	$db

	$debit

	$desc

	$echeance

	$f_id

	$grpt

	$jr_id

	$jr_internal

	$jr_optype

	$jrn

	$jrn_id

	$jrnx_id

	$mt

	$periode

	$pj

	$poste

	$qcode
	< Qcode of item

	$signature

	$type

	$user

Private Member Functions
	prepare_sql_counterpart ()
	prepare the query for getting the qcode of the tiers, when executing this SQL , an array of (jrn.jr_id , jrnx.j_id) must be provided

	prepare_sql_tiers ()
	prepare the query for getting the qcode of the tiers, when executing this SQL , an array of (jrn.jr_id , jrnx.j_id) must be provided

Detailed Description

this file match the tables jrn & jrnx the purpose is to remove or save accountant writing to these table.

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

Constructor & Destructor Documentation

◆ __construct()

Acc_Operation::__construct ( $p_cn )

constructor set automatically the attributes user and periode

Parameters

$p_cn the databse connection

Definition at line 67 of file acc_operation.class.php.

    {
        global $g_user;
        $this->db=$p_cn;
        $this->qcode="";
        $this->user=$_SESSION[SESSION_KEY.'g_user'];
        $this->periode=$g_user->get_periode();
        $this->jr_id=0;
        $this->jr_optype="NOR";
        $this->amount=0;
        $this->currency_rate=1;
        $this->currency_rate_ref=1;
        $this->currency_id=NULL;
    }

References $g_user, db, jr_id, and user.

Member Function Documentation

◆ __toString()

Acc_Operation::__toString ( )

Definition at line 82 of file acc_operation.class.php.

                         : string
    {
        $r=<<<EOF
   Acc_Operation Object 
     [   
        db {$this->db} 
        qcode {$this->qcode}
        user {$this->user}
        periode {$this->periode}
        jr_id {$this->jr_id}
        jr_optype {$this->jr_optype}
        amount  {$this->amount}
        currency_rate {$this->amount}
        currency_rate_ref {$this->amount}
        currency_id {$this->amount}
    ]
EOF;
        return $r;
        
    }

References $r, db, jr_id, and user.

◆ display_jrnx_detail()

Acc_Operation::display_jrnx_detail ( $p_table )

display_jrnx_detail : get the data from get_jrnx_data and return a string with HTML code

Parameters

table(=0 no code for table,1 code for table,2 code for CSV)

Definition at line 473 of file acc_operation.class.php.

    {
        $show=$this->get_jrnx_detail();
 
        $r='';
        $r_notable='';
        $csv="";
        foreach ($show as $l)
        {
            $border="";
            if ( $l['j_poste'] == $this->poste || ($l['j_qcode']==$this->qcode && trim($this->qcode) != ''))
                $border=' class="highlight"';
            $r.='<tr '.$border.'>';
            $r.='<td>';
            $a=$l['j_qcode'];
            
            $r_notable.=$a;
            $r.=$a;
            $csv.='"'.$a.'";';
            $r.='</td>';
 
            $r.='<td  '.$border.'>';
            $a=$l['j_poste'];
            $r_notable.=$a;
            $r.=$a;
            $csv.='"'.$a.'";';
            $r.='</td>';
 
            $r.='<td  '.$border.'>';
            //       $a=($l['vw_name']=="")?$l['j_qcode']:$l['pcm_lib'];
            $a=(noalyss_strlentrim($l['j_qcode'])==0)?$l['pcm_lib']:$l['vw_name'];
            $r_notable.=$a;
            $r.=h($a);
            $csv.='"'.$a.'";';
            $r.='</td>';
 
            $r.='<td  '.$border.'>';
            $a=$l['j_montant'];
            $r_notable.=$a;
            $r.=$a;
            $csv.=$a.';';
            $r.='</td>';
 
            $r.='<td  '.$border.'>';
            $a=$l['debit'];
            $r_notable.=$a;
            $r.=$a;
            $csv.='"'.$a.'"';
 
            $csv.="\r\n";
            $r.='</td>';
            $r.='<td  '.$border.'>';
            $a=($l['letter']!=-1)?$l['letter']:'';
            $r_notable.=$a;
            $r.=$a;
            $csv.='"'.$a.'"';
 
            $csv.="\r\n";
            $r.='</td>';
 
 
            $r.='</tr>';
        }
        switch ($p_table)
        {
        case 1:
            return $r;
            break;
        case 0:
            return $r_notable;
            break;
        case 2:
            return $csv;
        }
        return "ERROR PARAMETRE";
    }

References $a, $csv, $l, $r, $show, get_jrnx_detail(), h, and noalyss_strlentrim().

Here is the call graph for this function:

◆ find_tiers()

Acc_Operation::find_tiers	(	$pn_jrn_id,
		$pn_jrnx_id,
		$p_code )

Find the tiers of an operation , thanks the SQL prepared query prep_tiers and prep_counterpart.

Return a string with the quick_code

Parameters

type	$pn_jrn_id	pk of the table jrn (jrn.jr_id)
type	$pn_jrnx_id	pk of the table jrnx (jrnx.jr_id)
type	$p_code	quickcode

Returns: string

Definition at line 167 of file acc_operation.class.php.

    {
        static $p=0;
        if ( $p == 0 ){
            $this->prepare_sql_counterpart();
            $this->prepare_sql_tiers();
            $p=1;
        }
        $tiers="";
         $res_tiers=$this->db->execute('prep_tiers',
                 array($pn_jrn_id,$pn_jrnx_id));
         if ( Database::num_row($res_tiers) > 0) {
                $atiers=Database::fetch_array($res_tiers);
                $tiers=$atiers['ad_value'];
                // If the found tiers has the same quickcode than the current
                // card, it means it is a card of supplier or customer,
                //  so we must look for the countercard
                if ($tiers == $p_code)  {
                    $res_counterpart=$this->db->execute('prep_counterpart',
                            array($pn_jrn_id,$pn_jrnx_id));
                    $tiers="";
                    if ( Database::num_row($res_counterpart) > 0) {
                        $atiers=Database::fetch_array($res_counterpart);
                        $tiers=$atiers['ad_value'];
                    }
                }
            }
            return $tiers;
    }

References $p, $tiers, db, DatabaseCore\fetch_array(), DatabaseCore\num_row(), prepare_sql_counterpart(), and prepare_sql_tiers().

Here is the call graph for this function:

◆ form_clone_operation()

Acc_Operation::form_clone_operation ( $p_id )

create a form to recreate the operation and returns it, it works the same as when you want to correct an operation instead of confirming

See also: compta_ach.inc.php; compta_ven.inc.php

Parameters

$p_id string DOMID of the form

Definition at line 901 of file acc_operation.class.php.

                                         {
        // retrieve all info about operation
        $operation = $this->get_quant();
        $array=$operation->compute_array();
 
        global $g_user;
        $a_code=$this->db->get_array("select code from v_menu_dependency vmd  where me_code=$1 and p_id=$2",
                array( $operation->signature,$g_user->get_profile()));
        if ( empty ($a_code)) {
            $r=_("Menu invalide");
            return $r;
        }
       
        // Prepare the form
        // select the menu where the operation will be duplicated
        $r=sprintf('<form id="%s" method="POST" ACTION="%s">',$p_id,NOALYSS_URL."/do.php?".http_build_query([
                "ac"=>$a_code[0]['code'],"gDossier"=>Dossier::id()
        ]));
        $r.=Dossier::hidden();
        $default_currency=new Acc_Currency($this->db,0);
        // select the menu where the operation will be duplicated
 
        $r.="<p>";
        $r.="<ul style=\"margin-left:2rem;padding-left:0;list-style:none;\">";
        $r.=sprintf("<li>%s %s</li>",_("Date"),$operation->det->jr_pj_number);
        $r.=sprintf("<li>%s %s</li>",_("Libellé"),$operation->det->jr_comment);
        $r.=sprintf("<li>%s %s %s</li>",_("Montant "),nbm($operation->det->jr_montant),$default_currency->get_code());
        // Add info if the operation using a currency
        if ( $operation->det->currency_id != 0 ) {
            $currency=$this->db->get_value("select cr_code_iso from currency where id=$1",[$operation->det->currency_id]);
            $r.=sprintf("<li>%s %s</li>",_('Devise'),$currency);
            $r.=sprintf("<li>%s %s</li>",_("Taux"),$operation->det->currency_rate);
            $array['p_currency_code']=$operation->det->currency_id;
            $array['p_currency_rate']=$operation->det->currency_rate;
        }
        $r.="</ul>";
        $r.="</p>";
        if (count($a_code) == 1 ) {
            $r.=HtmlInput::hidden("ac",$a_code[0]['code']);
            $r.=sprintf(_("Voulez-vous aller à %s pour dupliquer cette opération ?"),$a_code[0]['code']);
            
        } else {
            $select=new ISelect("ac");
            $select->value=array();
            $nb_code=count($a_code);
            
            for ($i=0;$i<$nb_code;$i++) {
                $select->value[]=array("label"=>$a_code[$i]['code'],"value"=>$a_code[$i]['code']);
            }
            $r.=sprintf(_("Voulez-vous aller à %s pour dupliquer cette opération ?"),$select->input());
                       
        }
       
        $r.="</p>";
      
        // For Misc Operation , if a card is given then there is no accounting
        // modify amount with currency if not in default currency
        if ( $operation->signature==="ODS") {
            $nb_array = count($array);
            for ($i = 0; $i < $nb_array; $i++) {
                if (isset ($array["qc_" . $i]) && $array["qc_" . $i] != "") {
                    $array["poste" . $i] = "";
                }
 
            }
            $idx=0;
            foreach ($operation->det->array as $item) {
                if ($operation->det->currency_id != 0) {
                    $array['amount'. $idx] = $item['oc_amount'];
                    $idx++;
                }
            }
 
        }elseif ( $operation->signature==="ACH" || $operation->signature=="VEN") {
            $idx=0;
            foreach ($operation->det->array as $item) {
 
                // currency replace amount
                if ($operation->det->currency_id != 0 ) {
                    $array['e_march'.$idx.'_tva_amount']=$item['oc_vat_amount'];
                    $array['e_march'.$idx.'_tva_amount']=$item['oc_amount'];
                    $array['e_march'.$idx.'_price']=$item['oc_price_unit'];
                }
 
                if ( isset ($item['qs_vat_sided']) && $item['qs_vat_sided'] != 0 ) {
                    $array['e_march'.$idx.'_tva_amount']=0;
                }elseif (isset ($item['qp_vat_sided']) && $item['qp_vat_sided'] != 0 ){
                    $array['e_march'.$idx.'_tva_amount']=0;
                }
 
                $idx++;
            }
        }elseif ($operation->signature=='FIN') {
            $idx=0;
            foreach ($operation->det->array as $item) {
                if ($operation->det->currency_id != 0) {
                    $array['e_other' . $idx . '_amount'] = $item['oc_amount'];
                    $idx++;
                }
            }
        }
 
        if ( DEBUGNOALYSS>1) {
            echo \Noalyss\Dbg::hidden_info("operation->det_array", $operation->det->array);
            echo \Noalyss\Dbg::hidden_info("operation->det", $operation->det);
            echo \Noalyss\Dbg::hidden_info("array", $array);
        }
        // transform the operation into hidden element
        $r.=HtmlInput::simple_array_to_hidden($array);
        $r.=HtmlInput::hidden("e_comm",$operation->det->jr_comment);
        $r.=HtmlInput::submit(uniqid(), _("Dupliquer"));
        $r.=HtmlInput::button_close("duplicate_operation_div");
        $r.='</form>';
        
        
        // return the form as a string 
        return $r;
    }

References $array, $currency, $default_currency, $g_user, $i, $idx, $nb_array, $operation, $p_id, $r, $select, _, db, elseif, get_quant(), and nbm().

Here is the call graph for this function:

◆ get()

Acc_Operation::get ( )

retrieve data from jrnx and jrn

Returns: return an object

Note

See also

Reimplemented in Acc_Detail, Acc_Fin, Acc_Misc, Acc_Purchase, and Acc_Sold.

Definition at line 650 of file acc_operation.class.php.

    {
        $ret=new Acc_Misc($this->db,$this->jr_id);
        $ret->get();
        return $ret;
    }

References $ret, db, and jr_id.

◆ get_amount()

Acc_Operation::get_amount ( )

return amount of the jr_id

Definition at line 849 of file acc_operation.class.php.

    {
        if ( $this->jr_id == 0 )            
            throw new Exception(_('Object invalide, id incorrect'));
        $amount=$this->db->get_value('select jr_montant from jrn where jr_id=$1',
                array($this->jr_id));
        return $amount;
    }

References $amount, _, db, and jr_id.

◆ get_currency_amount()

Acc_Operation::get_currency_amount ( )

retrieve amount in currency for the operation

Returns: amount in currency or 0 if this operation doesn't use currency

See also: Acc_Sold Acc_Purchase Acc_Fin Acc_Detail Acc_Misc

Definition at line 700 of file acc_operation.class.php.

    {
        if ( $this->det->currency_id == 0 ) {
            return 0;
        }
        $ledger_id=$this->get_ledger();
        if ( $ledger_id=='') throw new Exception(_('Journal non trouvé'));
        $oledger=new Acc_Ledger($this->db,$ledger_id);
 
        // retrieve info from jrn_info
       
 
        switch($oledger->get_type())
        {
        case 'VEN':
            $sql_amount="
                select 
                sum(oc_amount)+sum(oc_vat_amount ) 
                from operation_currency oc 
                join quant_sold qs using(j_id) 
                where 
                oc.j_id in (select j_id 
                    from jrnx join jrn on (jr_grpt_id=j_grpt) 
                    where jr_id=$1);
                ";
            break;
        case 'ACH':
             $sql_amount="
                select 
                sum(oc_amount)+sum(oc_vat_amount ) 
                from operation_currency oc 
                join quant_purchase qs using(j_id) 
                where 
                oc.j_id in (select j_id 
                    from jrnx join jrn on (jr_grpt_id=j_grpt) 
                    where jr_id=$1);
                ";
            break;
        case 'FIN':
             $sql_amount="
                select 
                sum(oc_amount)+sum(oc_vat_amount ) 
                from operation_currency oc 
                join quant_fin qs using(j_id) 
                where 
                oc.j_id in (select j_id 
                    from jrnx join jrn on (jr_grpt_id=j_grpt) 
                    where jr_id=$1);
                ";
            break;
        default:
             $sql_amount="
                select 
                sum(oc_amount)+sum(oc_vat_amount ) 
                from operation_currency oc 
                join jrnx using(j_id) 
                join jrn on (jr_grpt_id=j_grpt) 
                where 
                jr_id=$1 and j_debit='t';
                ";
            break;
        }
        $amount=$this->db->get_value($sql_amount,[$this->jr_id]);
        return $amount;
    }

References $amount, $ledger_id, _, db, get_ledger(), and jr_id.

Here is the call graph for this function:

◆ get_data()

Acc_Operation::get_data ( $p_grpt )

Get data from jrnx where p_grpt=jrnx(j_grpt)

Parameters

connection

Returns

array of 3 elements

First Element is an array

Array
(
    [op_date] => 01.12.2009
    [class_cred0] => 7000008
    [mont_cred0] => 8880.0000
    [op_cred0] => 754
    [text_cred0] =>
    [jr_internal] => 23VEN-01-302
    [comment] =>
    [ech] =>
    [jr_id] => 302
    [jr_def_id] => 2
    [class_deb0] => 4000005
    [mont_deb0] => 10744.8000
    [text_deb0] =>
    [op_deb0] => 755
    [class_cred1] => 4511
    [mont_cred1] => 1864.8000
    [op_cred1] => 756
    [text_cred1] =>
)

Second : number of line with debit
Third : number of line with credit

Definition at line 581 of file acc_operation.class.php.

    {
        $Res=$this->db->exec_sql("select
                                 to_char(j_date,'DD.MM.YYYY') as j_date,
                                 j_text,
                                 j_debit,
                                 j_poste,
                                 coalesce(j_qcode,'-') as qcode,
                                 j_montant,
                                 j_id,
                                 jr_comment,
                                 to_char(jr_ech,'DD.MM.YYYY') as jr_ech,
                                 to_char(jr_date,'DD.MM.YYYY') as jr_date,
                                 jr_id,jr_internal,jr_def_id,jr_pj
                                 from jrnx inner join jrn on j_grpt=jr_grpt_id where j_grpt=$1",array($p_grpt));
        $MaxLine=Database::num_row($Res);
        if ( $MaxLine == 0 ) return null;
        $deb=0;
        $cred=0;
        for ( $i=0; $i < $MaxLine; $i++)
        {
 
            $l_line=Database::fetch_array($Res,$i);
            $l_array['op_date']=$l_line['j_date'];
            if ( $l_line['j_debit'] == 't' )
            {
                $l_class=sprintf("class_deb%d",$deb);
                $l_montant=sprintf("mont_deb%d",$deb);
                $l_text=sprintf("text_deb%d",$deb);
                $l_qcode=sprintf("qcode_deb%d",$deb);
                $l_array[$l_class]=$l_line['j_poste'];
                $l_array[$l_montant]=$l_line['j_montant'];
                $l_array[$l_text]=$l_line['j_text'];
                $l_array[$l_qcode]=$l_line['qcode'];
                $l_id=sprintf("op_deb%d",$deb);
                $l_array[$l_id]=$l_line['j_id'];
                $deb++;
            }
            if ( $l_line['j_debit'] == 'f' )
            {
                $l_class=sprintf("class_cred%d",$cred);
                $l_montant=sprintf("mont_cred%d",$cred);
                $l_array[$l_class]=$l_line['j_poste'];
                $l_array[$l_montant]=$l_line['j_montant'];
                $l_id=sprintf("op_cred%d",$cred);
                $l_array[$l_id]=$l_line['j_id'];
                $l_text=sprintf("text_cred%d",$cred);
                $l_array[$l_text]=$l_line['j_text'];
                $l_qcode=sprintf("qcode_cred%d",$cred);
                $l_array[$l_qcode]=$l_line['qcode'];
                $cred++;
            }
            $l_array['jr_internal']=$l_line['jr_internal'];
            $l_array['comment']=$l_line['jr_comment'];
            $l_array['ech']=$l_line['jr_ech'];
            $l_array['jr_id']=$l_line['jr_id'];
            $l_array['jr_def_id']=$l_line['jr_def_id'];
        }
        return array($l_array,$deb,$cred);
    }

References $cred, $deb, $i, $Res, db, DatabaseCore\fetch_array(), and DatabaseCore\num_row().

Here is the call graph for this function:

◆ get_info()

Acc_Operation::get_info ( )

retrieve info from the jrn_info, create 2 new arrays obj->info->command and obj->info->other the columns are the idx

Definition at line 770 of file acc_operation.class.php.

    {
        $this->info=new stdClass();
        // other info
        $array=$this->db->get_value("select ji_value from jrn_info where
            jr_id=$1 and id_type=$2",array($this->jr_id,'OTHER'));
        $this->info->other= $array;
 
        // Bon de commande
        $array=$this->db->get_value("select ji_value from jrn_info where
            jr_id=$1 and id_type=$2",array($this->jr_id,'BON_COMMANDE'));
        $this->info->command=  $array;
 
    }

References $array, db, and jr_id.

◆ get_internal()

Acc_Operation::get_internal ( )

Return the internal value, the property jr_id must be set before.

Returns: null si aucune valeur de trouv

Definition at line 393 of file acc_operation.class.php.

    {
        if ( ! isset($this->jr_id) )
            throw new Exception('jr_id is not set',1);
        $Res=$this->db->exec_sql("select jr_internal from jrn where jr_id=".$this->jr_id);
        if ( Database::num_row($Res) == 0 ) return null;
        $l_line=Database::fetch_array($Res);
        $this->jr_internal= $l_line['jr_internal'];
        return $this->jr_internal;
    }

References $jr_internal, $Res, db, DatabaseCore\fetch_array(), jr_id, and DatabaseCore\num_row().

Here is the call graph for this function:

◆ get_jrnx_detail()

Acc_Operation::get_jrnx_detail ( )

retrieve data from jrnx

Note: the data are filtered by the access of the current user

Returns: an array or FALSE if nothing found

Definition at line 421 of file acc_operation.class.php.

    {
        global $g_user;
        $filter_sql=$g_user->get_ledger_sql('ALL',3);
        $filter_sql=noalyss_str_replace('jrn_def_id','jr_def_id',$filter_sql);
        if ( $this->jr_id==0 ) return;
        $sql=" select  jr_id,j_id,jr_date,j_qcode,j_poste,j_montant,jr_internal,case when j_debit = 'f' then 'C' else 'D' end as debit,jr_comment as description,
             vw_name,pcm_lib,j_debit,coalesce(comptaproc.get_letter_jnt(j_id),-1) as letter,jr_def_id ".
             " from jrnx join jrn on (jr_grpt_id=j_grpt)
             join tmp_pcmn on (j_poste=pcm_val)
             left join vw_fiche_attr on (j_qcode=quick_code)
             where
             jr_id=$1 and $filter_sql order by j_debit desc";
        $res=$this->db->exec_sql($sql,array($this->jr_id));
        if ( Database::num_row ($res) == 0 ) return array();
        $all=Database::fetch_all($res);
        return $all;
    }

References $all, $g_user, $res, $sql, db, DatabaseCore\fetch_all(), jr_id, noalyss_str_replace(), and DatabaseCore\num_row().

Referenced by display_jrnx_detail().

Here is the call graph for this function:

◆ get_ledger()

Acc_Operation::get_ledger ( )

return the jrn_def_id from jrn

Definition at line 462 of file acc_operation.class.php.

    {
        $sql="select jr_def_id from jrn where jr_id=$1";
        $row=$this->db->get_value($sql,array($this->jr_id));
        return $row;
    }

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

Referenced by get_currency_amount(), and get_quant().

◆ get_quant()

Acc_Operation::get_quant ( )

retrieve data from the table QUANT_*

Returns: return an object or null if there is no data from the QUANT table

See also: Acc_Sold Acc_Purchase Acc_Fin Acc_Detail Acc_Misc

Definition at line 662 of file acc_operation.class.php.

    {
        $ledger_id=$this->get_ledger();
        if ( $ledger_id=='') throw new Exception(_('Journal non trouvé'));
        $oledger=new Acc_Ledger($this->db,$ledger_id);
 
        // retrieve info from jrn_info
 
 
        switch($oledger->get_type())
        {
        case 'VEN':
            $ret=new Acc_Sold($this->db,$this->jr_id);
            break;
        case 'ACH':
            $ret=new Acc_Purchase($this->db,$this->jr_id);
            break;
        case 'FIN':
            $ret=new Acc_Fin($this->db,$this->jr_id);
            break;
        default:
            $ret=new Acc_Misc($this->db,$this->jr_id);
            break;
        }
        $ret->get();
        if ( empty($ret->det->array))
        {
            $ret=new Acc_Misc($this->db,$this->jr_id);
            $ret->get();
        }
        $ret->get_info();
        return $ret;
    }

References $ledger_id, $ret, _, db, get_ledger(), and jr_id.

Referenced by form_clone_operation().

Here is the call graph for this function:

◆ get_sum_other_tax()

Acc_Operation::get_sum_other_tax ( )

get the sum of other tax linked to this operation

Definition at line 251 of file acc_operation.class.php.

                                 {
        if ( $this->jr_id == 0 ) {return 0;}
        $sum=$this->db->get_value("select 
       sum(case when j_debit is false and jrn_def.jrn_def_type='ACH' 
           then 0-j_montant when j_debit is true and jrn_def.jrn_def_type='VEN' 
               then 0-j_montant 
           else j_montant end) sum_tax
         from 
            jrn_tax join jrnx j1 using (j_id)  
            join jrn on (jr_grpt_id=j1.j_grpt) 
            join jrn_def on (jrn.jr_def_id=jrn_def.jrn_def_id)
         where 
         jrn.jr_id=$1",[$this->jr_id]);
        ;
        if ( $this->db->count()==0) {return 0;}
        return $sum;
    }

References db, and jr_id.

◆ insert_jrn()

Acc_Operation::insert_jrn ( )

Insert into the table Jrn, the amount is computed from jrnx thanks the group id ($p_grpt)

Returns: sequence of jr_id

Definition at line 349 of file acc_operation.class.php.

    {
        $p_comment=$this->desc;
        if ( DEBUGNOALYSS > 1 ) {
             echo "insert_jrn = {$this->amount}  <br>";
        }
        $diff=$this->db->get_value("select check_balance ($1)",array($this->grpt));
        if ( $diff != 0 )
        {
 
            printf (_("Erreur : balance incorrecte :diff = %s"),$diff);
            return false;
        }
 
        $echeance=( isset( $this->echeance) && noalyss_strlentrim($this->echeance) != 0)?$this->echeance:null;
        if ( ! isset($this->mt) )
        {
            $this->mt=microtime(true);
        }
        
        // if amount == -1then the triggers will throw an error
        //
        $this->amount=(trim($this->amount)==''||$this->amount==NULL)?0:$this->amount;
        $Res=$this->db->exec_sql("insert into jrn (jr_def_id,jr_montant,jr_comment,".
                                 "jr_date,jr_ech,jr_grpt_id,jr_tech_per,jr_mt,jr_optype,currency_id,currency_rate,currency_rate_ref)   values (".
                                 "$1,$2,$3,".
                                 "to_date($4,'DD.MM.YYYY'),to_date($5,'DD.MM.YYYY'),$6,$7,$8,$9,$10,$11,$12)",
                                 array ($this->jrn, $this->amount,$p_comment,
                                        $this->date,$echeance,$this->grpt,$this->periode,$this->mt,$this->jr_optype,
                                        $this->currency_id,$this->currency_rate,$this->currency_rate_ref)
                                );
        if ($Res==FALSE)
        {
            return FALSE;
        }
        $this->jr_id=$this->db->get_current_seq('s_jrn');
        return $this->jr_id;
    }

References $amount, $desc, $diff, $echeance, $jr_id, $Res, _, db, jr_id, jrn, and noalyss_strlentrim().

Here is the call graph for this function:

◆ insert_jrnx()

Acc_Operation::insert_jrnx ( )

Insert into the table Jrn The needed data are :

this->date
this->amount
this->poste
this->grpt
this->jrn
this->type ( debit or credit)
this->user
this->periode
this->qcode
this->desc optional
Note
if the amount is less than 0 then side changes, for example debit becomes a credit and vice versa

Returns
jrnx.j_id

Definition at line 214 of file acc_operation.class.php.

    {
      if ( $this->poste == "") { throw new  Exception (__FILE__.':'.__LINE__.' Poste comptable vide');return false; }
        /* for negative amount the operation is reversed */
        if ( $this->amount < 0 )
        {
            $this->type=($this->type=='d')?'c':'d';
        }
        if ( DEBUGNOALYSS > 1 ) {
            echo "insert_jrnx = [{ $this->poste}]  {$this->amount}  rounded ".round($this->amount,2)." type {$this->type}<br>";
        }
        $this->amount=abs($this->amount);
        $debit=($this->type=='c')?'false':'true';
        $this->desc=(isset($this->desc))?$this->desc:'';
        $this->amount=(trim($this->amount)==''||$this->amount==NULL)?0:$this->amount;
        $Res=$this->db->exec_sql("select insert_jrnx
                                 ($1::text,abs($2)::numeric,$3::account_type,$4::integer,$5::integer,$6::bool,$7::text,$8::integer,upper($9),$10::text)",
                                 array(
                                     $this->date, //$1
                                     round($this->amount,2), //$2
                                     $this->poste, //$3
                                     $this->grpt, //$4
                                     $this->jrn, //$5
                                     $debit, //$6
                                     $this->user, //$7
                                     $this->periode, //$8
                                     $this->qcode, // $9
                                     $this->desc)); //$10
        if ( $Res===FALSE) return FALSE;
        $this->jrnx_id=$this->db->get_current_seq('s_jrn_op');
        return $this->jrnx_id;
 
    }

References $amount, $debit, $jrnx_id, $Res, db, jrn, type, and user.

Referenced by Acc_Ledger_Purchase\insert_no_deductible().

◆ insert_related_action()

Acc_Operation::insert_related_action ( $p_string )

Definition at line 808 of file acc_operation.class.php.

    {
        if ($p_string == "") return;
        $a_action=explode(',',$p_string);
        for ($i=0;$i<count($a_action);$i++)
        {
            $action = new Follow_Up($this->db,$a_action[$i]);
            $action->operation=$this->jr_id;
            $action->insert_operation();
        }
    }

References $action, $i, $jr_id, and db.

◆ operation_update_comment()

Acc_Operation::operation_update_comment ( $p_text )

add a comment to the operation (jrn.jr_text)

Definition at line 446 of file acc_operation.class.php.

    {
        $sql="update jrn set jr_comment=$1 where jr_id=$2";
        $this->db->exec_sql($sql,array($p_text,$this->jr_id));
    }

References $sql, db, and jr_id.

◆ operation_update_date_limit()

Acc_Operation::operation_update_date_limit ( $p_text )

add a limit of payment to the operation (jrn.jr_ech)

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

    {
        if ( isDate($p_text) == null )
        {
            $p_text=null;
        }
        $sql="update jrn set jr_ech=to_date($1,'DD.MM.YYYY') where jr_id=$2";
        $this->db->exec_sql($sql,array($p_text,$this->jr_id));
    }

References $sql, db, isDate(), and jr_id.

Here is the call graph for this function:

◆ prepare_sql_counterpart()

Acc_Operation::prepare_sql_counterpart ( )

private

prepare the query for getting the qcode of the tiers, when executing this SQL , an array of (jrn.jr_id , jrnx.j_id) must be provided

Definition at line 141 of file acc_operation.class.php.

    {
         // prepare for getting the tiers
        $this->db->prepare('prep_counterpart',"select fiche_detail.f_id,ad_value from 
                                        fiche_detail 
                                         join (select qf_bank as f_id 
                                          from quant_fin
                                          where 
                                          quant_fin.jr_id = $1
                                        union all 
                                        select qp_fiche as f_id 
                                        from quant_purchase
                                        where quant_purchase.j_id=$2
                                        union all 
                                        select qs_fiche as f_id 
                                        from quant_sold                 
                                        where quant_sold.j_id=$2 ) as v_fiche on (fiche_detail.f_id=v_fiche.f_id) where ad_id=23 ");
    }

References db.

Referenced by find_tiers().

◆ prepare_sql_tiers()

Acc_Operation::prepare_sql_tiers ( )

private

prepare the query for getting the qcode of the tiers, when executing this SQL , an array of (jrn.jr_id , jrnx.j_id) must be provided

Definition at line 118 of file acc_operation.class.php.

    {
         // prepare for getting the tiers
        $this->db->prepare('prep_tiers',"select fiche_detail.f_id,ad_value from 
                                        fiche_detail 
                                         join (select qf_other as f_id 
                                          from quant_fin
                                          where 
                                          quant_fin.jr_id = $1
                                        union all 
                                        select qp_supplier as f_id 
                                        from quant_purchase
                                        where quant_purchase.j_id=$2
                                        union all 
                                        select qs_client as f_id 
                                        from quant_sold                 
                                        where quant_sold.j_id=$2 ) as v_fiche on (fiche_detail.f_id=v_fiche.f_id) where ad_id=23 ");
    }

References db.

Referenced by find_tiers().

◆ save_info()

Acc_Operation::save_info	(		$p_info,
			$p_type )

Save into jrn_info.

Parameters

$p_info	msg to save
$p_type	is OTHER or BON_COMMAND

Definition at line 789 of file acc_operation.class.php.

    {
        if ( ! in_array($p_type,array('OTHER','BON_COMMANDE'))) return;
        if (trim($p_info)=="") {
            $this->db->exec_sql('delete from jrn_info where jr_id=$1 and id_type=$2',array($this->jr_id,$p_type));
            return;
        }
        $exist=$this->db->get_value('select count(ji_id) from jrn_info where jr_id=$1 and id_type=$2',array($this->jr_id,$p_type));
        if ( $exist == "0" ) {
            //insert into jrn_info
            $this->db->exec_sql('insert into jrn_info(jr_id,id_type,ji_value) values ($1,$2,$3)',
                    array($this->jr_id,$p_type,$p_info));
        } elseif ( $exist == 1) {
            //update
            $this->db->exec_sql('update jrn_info set ji_value=$3 where jr_id=$1 and id_type=$2',
                    array($this->jr_id,$p_type,$p_info));
        }
    }

References $p_type, db, elseif, and jr_id.

◆ seek_group()

Acc_Operation::seek_group ( )

retrieve the grpt_id from jrn for a jr_id

Returns: jrn.jr_grpt_id or an empty string if not found

Definition at line 107 of file acc_operation.class.php.

    {
        $ret=$this->db->get_value('select jr_grpt_id from jrn where jr_id=$1',
                                  array($this->jr_id));
        return $ret;
    }

References $ret, db, and jr_id.

◆ seek_internal()

Acc_Operation::seek_internal ( $p_internal )

search an operation thankx it internal code

Parameters

internal code

Returns: 0 ok -1 nok

Definition at line 408 of file acc_operation.class.php.

    {
        $res=$this->db->exec_sql('select jr_id from jrn where jr_internal=$1',
                                 array($p_internal));
        if ( Database::num_row($res) == 0 ) return -1;
        $this->jr_id=Database::fetch_result($res,0,0);
        return 0;
    }

References $res, db, DatabaseCore\fetch_result(), jr_id, and DatabaseCore\num_row().

Here is the call graph for this function:

◆ select_operation_type()

static Acc_Operation::select_operation_type ( $p_status )

static

Return a select object to choose the type of operation.

NOR normal
EXT reverse operation
CLO closing periode
OPE opening periode
Parameters

string $p_status

Returns
\ISelect

Definition at line 879 of file acc_operation.class.php.

    {
        $type_operation=new ISelect("jr_optype");
        $type_operation->value=array(
            array(("label")=>_("Normal"), "value"=>"NOR"),
            array(("label")=>_("Ouverture"), "value"=>"OPE"),
            array(("label")=>_("Fermeture"), "value"=>"CLO"),
            array(("label")=>_("Extourne"), "value"=>"EXT")
        );
 
        $type_operation->selected=$p_status;
        return $type_operation;
    }

References _.

◆ set_id()

Acc_Operation::set_id ( $p_id )

set the operation id (jrn.jr_id)

Parameters

type $p_id

Definition at line 823 of file acc_operation.class.php.

    {
        if (isNumber($p_id)==0) {
            throw new Exception(_('Acc_Operation::set_id , id invalide '));
        }
        $this->jr_id=$p_id;
    }

References $p_id, _, isNumber(), and jr_id.

Here is the call graph for this function:

◆ set_paid()

Acc_Operation::set_paid ( )

flag the operation as paid

Definition at line 833 of file acc_operation.class.php.

    {
        // Operation 
        if ( $this->jr_id == 0 )            
            throw new Exception(_('Object invalide, id incorrect'));
        if ( 
                $this->db->get_value('select count(*) from jrn where jr_id=$1',
                        array($this->jr_id)) == 0 )
            throw new Exception(_('Object invalide, id incorrect'));
        
        $this->db->exec_sql("update jrn set jr_rapt = 'paid' where jr_id = $1",
                array($this->jr_id));
    }

References _, db, and jr_id.

◆ test_me()

static Acc_Operation::test_me ( )

static

Definition at line 857 of file acc_operation.class.php.

    {
        global $g_user;
        $cn=Dossier::connect();
        $g_user=new Noalyss_user($cn);
        $a=new Acc_Operation($cn);
        $a->jr_id=993;
        $b=$a->get_quant();
        echo h1('contain of get_quant() ');
        var_dump($b);
        echo h1('contain of get_jrnx_detail()');
        var_dump($a->get_jrnx_detail());
    }

References $a, $b, $cn, $g_user, and h1().

Here is the call graph for this function:

◆ update_comment()

Acc_Operation::update_comment ( $p_text )

add a comment to the line (jrnx.j_text)

Definition at line 440 of file acc_operation.class.php.

    {
        $sql="update jrnx set j_text=$1 where j_id=$2";
        $this->db->exec_sql($sql,array($p_text,$this->jrnx_id));
    }

References $sql, and db.

◆ update_receipt()

Acc_Operation::update_receipt ( )

set the pj of a operation in jrn. the jr_id must be set

Note: if the jr_id it fails

Definition at line 273 of file acc_operation.class.php.

    {
        if ( noalyss_strlentrim($this->pj) == 0 )
        {
           // echo __LINE__."debug {$this->pj} est vide";
            $sql="update jrn set jr_pj_number=$1 where jr_id=$2";
            $this->db->exec_sql($sql,array(null,$this->jr_id));
            return '';
        }
        /* is pj uniq ? */
        if ( $this->db->count_sql("select jr_id from jrn
             where jr_pj_number=$1 and jr_def_id=$2
                and jr_id !=$3",
                                  array($this->pj,$this->jrn,$this->jr_id)
                                 ) == 0 )
        {
 
            $sql="update jrn set jr_pj_number=$1 where jr_id=$2";
            $this->db->exec_sql($sql,array($this->pj,$this->jr_id));
        }
        else
        {
            /* get pref */
            $pref=$this->db->get_value("select jrn_def_pj_pref from jrn_def where jrn_def_id=$1",
                                       array($this->jrn));
            /*  try another seq */
            $flag=0;
            $limit=100;
            while ( $flag == 0 )
            {
                /*  limit the search to $limit */
                if ( $limit < 1 )
                {
                    $this->pj='';
                    $flag=2;
                    break;
                }
                /* get padding */
                $padding=$this->db->get_value("select jrn_def_pj_padding from jrn_def where jrn_def_id=$1",
                    array($this->jrn));
 
                $seq=$this->db->get_next_seq('s_jrn_pj'.$this->jrn);
 
                // see Acc_Ledger::guess_pj
                $this->pj=$pref.str_pad($seq,$padding??0,'0',STR_PAD_LEFT);
 
                /* check if the new pj numb exist */
                $c=$this->db->count_sql("select jr_id from jrn where jr_pj_number=$1 and jr_def_id=$2
                                            and jr_id !=$3",
                                        array($this->pj,$this->jrn,$this->jr_id)
                                       );
                if ( $c == 0 )
                {
                    $flag=1;
                    break;
                }
                $limit--;
            }
            /* a pj numb is found */
            if ( $flag == 1 )
            {
                $sql="update jrn set jr_pj_number=$1 where jr_id=$2";
                $this->db->exec_sql($sql,array($this->pj,$this->jr_id));
            }
        }
        return $this->pj;
    }

References $c, $flag, $limit, $pj, $seq, $sql, db, jr_id, jrn, and noalyss_strlentrim().

Here is the call graph for this function:

Field Documentation

◆ $amount

Acc_Operation::$amount

amount of the operatoin

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

Referenced by get_amount(), get_currency_amount(), insert_jrn(), and insert_jrnx().

◆ $currency_id

Acc_Operation::$currency_id

Definition at line 49 of file acc_operation.class.php.

◆ $currency_rate

Acc_Operation::$currency_rate

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

◆ $currency_rate_ref

Acc_Operation::$currency_rate_ref

Definition at line 50 of file acc_operation.class.php.

◆ $date

Acc_Operation::$date

the date

Definition at line 42 of file acc_operation.class.php.

◆ $date_paid

Acc_Operation::$date_paid

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

◆ $db

Acc_Operation::$db

database connx

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

◆ $debit

Acc_Operation::$debit

debit or credit

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

Referenced by insert_jrnx().

◆ $desc

Acc_Operation::$desc

Definition at line 56 of file acc_operation.class.php.

Referenced by insert_jrn().

◆ $echeance

Acc_Operation::$echeance

Definition at line 59 of file acc_operation.class.php.

Referenced by insert_jrn().

◆ $f_id

Acc_Operation::$f_id

Definition at line 62 of file acc_operation.class.php.

◆ $grpt

Acc_Operation::$grpt

the group id

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

◆ $jr_id

Acc_Operation::$jr_id

pk of jrn

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

Referenced by insert_jrn(), and insert_related_action().

◆ $jr_internal

Acc_Operation::$jr_internal

Definition at line 54 of file acc_operation.class.php.

Referenced by get_internal().

◆ $jr_optype

Acc_Operation::$jr_optype

type of operation :NOR,CLO,EXT,OPE

Definition at line 47 of file acc_operation.class.php.

◆ $jrn

Acc_Operation::$jrn

the ledger to use

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

◆ $jrn_id

Acc_Operation::$jrn_id

jrn_def_id

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

◆ $jrnx_id

Acc_Operation::$jrnx_id

Definition at line 58 of file acc_operation.class.php.

Referenced by insert_jrnx().

◆ $mt

Acc_Operation::$mt

Definition at line 61 of file acc_operation.class.php.

◆ $periode

Acc_Operation::$periode

periode to use

Definition at line 43 of file acc_operation.class.php.

◆ $pj

Acc_Operation::$pj

Definition at line 60 of file acc_operation.class.php.

Referenced by update_receipt().

◆ $poste

Acc_Operation::$poste

account

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

◆ $qcode

Acc_Operation::$qcode

< Qcode of item

internal code from jrn

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

◆ $signature

Acc_Operation::$signature

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

◆ $type

Acc_Operation::$type

Definition at line 57 of file acc_operation.class.php.

◆ $user

Acc_Operation::$user

current user

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

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

include/class/acc_operation.class.php

Public Member Functions

Static Public Member Functions

Data Fields

Private Member Functions

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ __toString()

◆ display_jrnx_detail()

◆ find_tiers()

◆ form_clone_operation()

◆ get()

◆ get_amount()

◆ get_currency_amount()

◆ get_data()

◆ get_info()

◆ get_internal()

◆ get_jrnx_detail()

◆ get_ledger()

◆ get_quant()

◆ get_sum_other_tax()

◆ insert_jrn()

◆ insert_jrnx()

◆ insert_related_action()

◆ operation_update_comment()

◆ operation_update_date_limit()

◆ prepare_sql_counterpart()

◆ prepare_sql_tiers()

◆ save_info()

◆ seek_group()

◆ seek_internal()

◆ select_operation_type()

◆ set_id()

◆ set_paid()

◆ test_me()

◆ update_comment()

◆ update_receipt()

Field Documentation

◆ $amount

◆ $currency_id

◆ $currency_rate

◆ $currency_rate_ref

◆ $date

◆ $date_paid

◆ $db

◆ $debit

◆ $desc

◆ $echeance

◆ $f_id

◆ $grpt

◆ $jr_id

◆ $jr_internal

◆ $jr_optype

◆ $jrn

◆ $jrn_id

◆ $jrnx_id

◆ $mt

◆ $periode

◆ $pj

◆ $poste

◆ $qcode

◆ $signature

◆ $type

◆ $user