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 More...

	__toString ()

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

	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. More...

	form_clone_operation ($p_id)
	create a form to recreate the operation and returns it, just like a correct More...

	get ()
	retrieve data from jrnx and jrn More...

	get_amount ()
	return amount of the jr_id More...

	get_currency_amount ()
	retrieve amount in currency for the operation More...

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

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

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

	get_jrnx_detail ()
	retrieve data from jrnx More...

	get_ledger ()
	return the jrn_def_id from jrn More...

	get_quant ()
	retrieve data from the table QUANT_* More...

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

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

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

	insert_related_action ($p_string)

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

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

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

	seek_group ()
	retrieve the grpt_id from jrn for a jr_id More...

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

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

	set_paid ()
	flag the operation as paid More...

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

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

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

static	test_me ()

Data Fields
	$amount

	$currency_id

	$currency_rate

	$currency_rate_ref

	$date

	$date_paid

	$db

	$debit

	$grpt

	$jr_id

	$jr_internal

	$jr_optype

	$jrn

	$jrn_id

	$periode

	$poste

	$qcode
	< Qcode of item More...

	$signature

	$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 More...

	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 More...

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 60 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 75 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 458 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 160 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, just like a correct

Parameters

$p_id string DOMID of the form

Definition at line 880 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();
        // 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</li>",$operation->det->jr_pj_number);
        $r.=sprintf("<li>%s</li>",$operation->det->jr_comment);
        $r.=sprintf("<li>%s</li>",$operation->det->jr_montant);
        $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
        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] = "";
                }
            }
        }
 
        if ( $operation->signature==="ACH" || $operation->signature=="VEN") {
            $idx=0;
            foreach ($operation->det->array as $item) {
                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++;
            }
            if ( DEBUGNOALYSS>1) {
                echo \Noalyss\Dbg::hidden_info("operation->det_array", $operation->det->array);
                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, $g_user, $i, $idx, $nb_array, $operation, $p_id, $r, $select, HtmlInput\button_close(), db, elseif, get_quant(), HtmlInput\hidden(), Dossier\hidden(), Dossier\id(), HtmlInput\simple_array_to_hidden(), and HtmlInput\submit().

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_Misc, Acc_Sold, Acc_Purchase, and Acc_Fin.

Definition at line 635 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 834 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 685 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 566 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 755 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 380 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 406 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 447 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 647 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 244 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 336 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 $desc, $diff, $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 207 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 $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 793 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 431 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 437 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 134 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 111 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 774 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 100 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 394 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 863 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;
    }

◆ set_id()

Acc_Operation::set_id ( $p_id )

set the operation id (jrn.jr_id)

Parameters

type $p_id

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

◆ set_pj()

Acc_Operation::set_pj ( )

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

Note: if the jr_id it fails

Definition at line 265 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;
                }
 
                $seq=$this->db->get_next_seq('s_jrn_pj'.$this->jrn);
                $this->pj=$pref.$seq;
 
                /* 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 $flag, $limit, $seq, $sql, db, jr_id, jrn, and noalyss_strlentrim().

Here is the call graph for this function:

◆ test_me()

static Acc_Operation::test_me ( )

static

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

    {
        $_SESSION[SESSION_KEY.'g_user']=NOALYSS_ADMINISTRATOR;
        $_SESSION[SESSION_KEY.'g_pass']='dany';
        global $g_user;
        $cn=Dossier::connect();
        $g_user=new Noalyss_user($cn);
        $a=new Acc_Operation($cn);
        $a->jr_id=1444;
        $b=$a->get_quant();
        var_dump($b);
    }

References $a, $b, $cn, $g_user, Dossier\connect(), and NOALYSS_ADMINISTRATOR.

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 425 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.

Field Documentation

◆ $amount

Acc_Operation::$amount

amount of the operatoin

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

Referenced by get_amount(), and get_currency_amount().

◆ $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().

◆ $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.

◆ $periode

Acc_Operation::$periode

periode to use

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

◆ $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.

◆ $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()

◆ set_pj()

◆ test_me()

◆ update_comment()

Field Documentation

◆ $amount

◆ $currency_id

◆ $currency_rate

◆ $currency_rate_ref

◆ $date

◆ $date_paid

◆ $db

◆ $debit

◆ $grpt

◆ $jr_id

◆ $jr_internal

◆ $jr_optype

◆ $jrn

◆ $jrn_id

◆ $periode

◆ $poste

◆ $qcode

◆ $signature

◆ $user