Configure the tva : code , rate, label ... When using Manage_Table_SQL. More...

Inheritance diagram for Tva_Rate_MTable:

Collaboration diagram for Tva_Rate_MTable:

Public Member Functions
	__construct (V_Tva_rate_SQL $p_table)

	check ()
	Check data are valid.

	delete ()
	delete if not used anywhere

	from_request ()
	add the TVA_REVERSE_ACCOUNT

	getPreviousId ()

	input ()
	display into a dialog box the datarow in order to be appended or modified.

	save ()
	save the data in TVA_RATE if tva_both_side is 1 and tva_purchase or tva_sale is empty then it is equal to the other value

	setPreviousId ($previous_id)

Public Member Functions inherited from Manage_Table_SQL
	__construct (Data_SQL $p_table)

	add_json_param ($p_attribute, $p_value)
	Add json parameter to the current one.

	ajax_delete ()
	Delete a record and return an XML answer for ajax.

	ajax_input ($p_status="OK")
	send an xml with input of the object, create an xml answer.

	ajax_save ()
	Save the record from Request into the DB and returns an XML to update the Html Element.

	can_append_row ()
	return false if the append of the row is forbidden

	can_delete_row ()
	return false if the delete of the row is forbidden

	can_update_row ()
	return false if the update of the row is forbidden

	count_error ()
	returns the nb of errors found

	create_js_script ()
	we must create first the javascript if we want to update, insert or delete rows.

	display_error ()
	Display a list of the error collected.

	display_icon_custom ($p_row)
	usually contain a link and calls another page, it must be overriden

	display_icon_del ($p_row)

	display_icon_mod ($p_row)

	display_row ($p_row)
	display a data row in the table, with the order defined in a_order and depending of the visibility of the column, all the rows contains the attribute ctl_pk_id , to retrieve in javascript , ie with the function afterSaveFct (see managetable.js)

	display_row_custom ($p_key, $p_value, $p_id=0)
	When displaying a row, if a column has the type "custom" , we can call this function to display properly the value including the tag "<td>".

	display_table ($p_order="", $p_array=NULL)
	display the data of the table

	display_table_header ()
	display the column header excepted the not visible one and in the order defined with $this->a_order

	execute_query ($p_order="", $p_array=NULL)
	execute the query (Data_SQL.seek), called by display_table

	get_button_add_top ()

	get_col_option ($p_key)
	add extra to column, normally class , javascript or style

	get_col_sort ()
	When adding an element , it is column we checked to insert before,.

	get_col_type ($p_key)
	return the type of a column

	get_current_pos ($p_key)
	get the position of a column

	get_current_row ()
	Return the current row printed in display_row.

	get_dialog_box ()

	get_dialogbox_style ()
	return the db_style

	get_error ($p_col)
	retrieve the error message

	get_header_option ($p_key)
	add extra to column Header, normally class , javascript or style

	get_icon_del ()

	get_icon_mod ()

	get_js_variable ()
	Get the object name.

	get_json ()

	get_object_name ()

	get_order ()

	get_property_updatable ($p_key)
	return True if the column is updatable otherwise false

	get_property_visible ($p_key)
	return True if the column is visible otherwise false

	get_search_table ()
	Get if we can search in the table.

	get_sort_column ()
	return the column to sort

	get_table ()

	getCssClass ()

	getTitle ()

	input_custom ($p_key, $p_value)
	this function let you create your own input , for example for a ITEXT , a IRADIO , ... it must be override , there is not default

	insert ()
	insert a new value

	move ($p_key, $p_idx)
	if we change a column order , the order of the other columns is impacted.

	param_set ($p_json)
	Set the parameter of the object (gDossier, ac, plugin_code...) @detail By default , only gDossier will be set .

	send_header ()
	send the XML headers for the ajax call

	set_append_row ($p_value)
	Enable or disable the appending of rows.

	set_button_add_top ($button_add_top)

	set_callback ($p_file)
	set the callback function that is passed to javascript

	set_col_label ($p_key, $p_display)
	set the name to display for a column

	set_col_option ($p_key, $p_value)
	add extra to column, normally class or style

	set_col_sort ($p_num)
	When adding an element ,we place it thanks the DOM Attribute sort_value set it to -1 if you want one to append.

	set_col_tips ($p_key, $p_comment)
	Set the info for a column, use Icon_Action\infobulle the message are in message_javascript.php.

	set_col_type ($p_key, $p_value, $p_array=NULL)
	set the type of a column , it will change in the input db box , the select must supply an array of possible values [val=> , label=>] with the variable $this->key_name->a_value

	set_current_row ($current_row)
	set the current row printed in display_row

	set_delete_row ($p_value)
	Enable or disable the deletion of rows.

	set_dialog_box ($dialog_box)

	set_dialogbox_style ($db_style)
	Dialog box style , by default {position: "fixed", top: '15', width: "auto", "margin-left": "20%"}.

	set_error ($p_col, $p_message)
	set the error message for a wrong input

	set_header_option ($p_key, $p_value)
	add extra to column Header, normally class or style

	set_icon_del ($pString)
	Set the icon to delete at the right or left of the row.

	set_icon_mod ($pString)
	Set the icon to modify at the right ,the first col or left of the row, if the mod if custom , you have to override the function display_icon_custom.

	set_json ($p_json)
	Set the parameter of the object (gDossier, ac, plugin_code...) @detail By default , only gDossier will be set .

	set_object_name ($p_object_name)
	Set the object_name.

	set_order ($p_order)

	set_pk ($p_id)
	set the id value of a data row and load from the db

	set_property_updatable ($p_key, $p_value)
	set a column of the data row updatable or not

	set_property_visible ($p_key, $p_value)
	set a column of the data row visible or not

	set_search_table ($search_table)
	Set the table searchable or not.

	set_sort_column ($p_col)
	set the column to sort by default

	set_table (Data_SQL $p_noalyss_sql)

	set_update_row ($p_value)
	Enable or disable the updating of rows.

	set_value ($p_key, $p_value)

	setCssClass ($p_class)

	setTitle ($p_title)
	Set the title of the diabox , default is Donnée.

	show_error ($p_col)

	update ()

Private Attributes
	$a_comment
	Supplemental explanation.

	$previous_id
	< previous tva_id, used to know if we update or insert,

Additional Inherited Members
Static Public Member Functions inherited from Manage_Table_SQL
static	ajax_error ($p_message)
	returns an XML object for error message as unauthorized access.

Data Fields inherited from Manage_Table_SQL
const	UPDATABLE =1

const	VISIBLE =2

Protected Attributes inherited from Manage_Table_SQL
	$a_col_option
	in display_row and display_custom_row, it is the current row which is used

	$a_header_option
	Extra to add to the column Header : CSS Style , CSS class, javascript ,...

	$a_info
	Array with the infotip.

	$a_label_displaid
	Label of the col. of the datarow.

	$a_order
	order of the col

	$a_prop
	property for each col.

	$a_select
	Possible value if a_type is a SELECT.

	$a_type
	Type of the column : date , select ... Only in input.

	$aerror
	Array containing the error of the input data.

	$button_add_top
	place of the button add on the top, by default true

	$callback
	Callback function.

	$col_sort
	when inserting, it is the column to sort,-1 to disable it and append only

	$cssclass
	< give the title of the diabox , default is Data

	$current_row
	CSS class for the dialog box.

	$dialog_box
	ID of the dialog box which display the result of the ajax calls.

	$dialogbox_style
	style of the dialog box

	$icon_del
	place of right or left the icon update or mod, default right, accepted value=left,right

	$icon_mod
	place of right or left the icon update or mod, default right, accepted value=left,right,first,custom column for mod

	$json_parameter
	Default parameter to add (gDossier...), sent to the ajax callback.

	$object_name
	Object_name is used for the javascript , it is the row id to update or delete.

	$row_append
	Flag to indicate if rows can be added.

	$row_delete
	Flag to indicate if rows can be deleted.

	$row_update
	Flag to indicate if rows can be updated.

	$search_table
	boolean , by default true ,it is possible to search in the table,

	$sort_column
	javascript sort on this column , if empty there is no js sort

	$table
	Object Data_SQL.

	$title

Detailed Description

Configure the tva : code , rate, label ... When using Manage_Table_SQL.

Examples: tva_parameter.php.

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

Constructor & Destructor Documentation

◆ __construct()

Tva_Rate_MTable::__construct ( V_Tva_rate_SQL $p_table )

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

    {
        parent::__construct($p_table);
        $this->icon_mod='left';
        $this->set_col_label("tva_id", _("id"));
        $this->set_col_label("tva_code", _("Code"));
        $this->set_col_label("tva_label", _("label"));
        $this->set_col_label("tva_rate", _("taux"));
        $this->set_col_label("tva_comment", _("Description"));
        $this->set_col_label("tva_both_side", _("Autoliquidation"));
        $this->set_col_label("tva_reverse_account", _('Poste comptable autoliquidation'));
        $this->set_col_label("tva_sale", _("TVA Vente (C)"));
        $this->set_col_label("tva_purchase", _("TVA Achat (D)"));
        $this->set_col_label("tva_peppol_code", _("Code Facture électronique UBL"));
        $this->set_col_label("vx_code", _("Code Exemption TVA (vatex)"));
 
        $this->set_property_visible('tva_reverse_account', false);
        $this->set_property_visible('tva_peppol_code', false);
 
        $this->set_col_type("tva_both_side", "select",
                array(
            ["value"=>0, "label"=>_("Non")],
            ["value"=>1, "label"=>_("Oui")]
        ));
        $this->set_col_type("tva_reverse_account", 'custom');
        $this->set_property_updatable("tva_id", true);
        $this->set_col_label("tva_payment_purchase",_("Exigible achat"));
        $this->set_col_type("tva_payment_purchase","select",
                array(
                    array("value"=>'O',"label"=>"Opération"),
                    array("value"=>'P',"label"=>"Paiement")
                    )
                );
        $this->set_col_label("tva_payment_sale",_("Exigible vente"));
        $this->set_col_type("tva_payment_sale","select",
                array(
                    array("value"=>'O',"label"=>"Opération"),
                    array("value"=>'P',"label"=>"Paiement")
                    )
                );
        $this->a_info=[
            "tva_purchase"=>44,"tva_both_side"=>43,"tva_sale"=>45
            ,"tva_payment_sale"=>74,"tva_payment_purchase"=>74,'tva_reverse_account'=>88];
        $this->previous_id=null;
        $this->a_comment=array(
            'tva_purchase'=>_("Ne donnez pas ce poste comptable si ce code n'est pas utilisé à l'achat"),
            'tva_both_side'=>_("Autoliquidation : Utilisé en même temps au crédit et au débit"),
            'tva_sale'=>_("Ne donnez pas ce poste comptable si ce code n'est pas utilisé  à la vente"),
            'tva_payment_purchase'=>_('TVA due ou récupérable quand l\'opération est payée ou exécutée'),
            'tva_payment_sale'=>_('TVA due ou récupérable quand l\'opération est payée ou exécutée'),
            'tva_reverse_account'=>_("Forcer ce poste comptable pour autoliquidation : par défault, le poste d'autoliquidation est calculé : soit celui qui est en contrepartie, soit le même (voir manuel)"),
            'tva_peppol_code'=>_("Code TVA est utilisé pour les factures électroniques, plus d'information dans le manuel"),
            'vx_code'=>_("Code exemption pour facture PEPPOL (ubl)")
        );
        $this->setTitle(_("Détail TVA"));
    }

References _, Manage_Table_SQL\set_col_label(), Manage_Table_SQL\set_col_type(), Manage_Table_SQL\set_property_updatable(), Manage_Table_SQL\set_property_visible(), and Manage_Table_SQL\setTitle().

Here is the call graph for this function:

Member Function Documentation

◆ check()

Tva_Rate_MTable::check ( )

Check data are valid.

tva_rate between 0 & 1
label is uniq
accounting must exist
Returns
boolean

auto reverse VAT : check that the accounting is used

Reimplemented from Manage_Table_SQL.

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

    {
        global $g_parameter;
        $cn=Dossier::connect();
        if ( $this->previous_id === null ) {
            throw new \Exception ("TVA184: no previous TVA id");
        }
        // both accounting can not be empty
        if (trim($this->table->tva_purchase??"")==""&&trim($this->table->tva_sale??"")=="")
        {
            $this->set_error("tva_purchase",
                    _("Les 2 postes comptables ne peuvent être nuls"));
            $this->set_error("tva_sale",
                    _("Les 2 postes comptables ne peuvent être nuls"));
        }
 
        // Check the tva rate
        if (trim($this->table->tva_rate??"")==""||isNumber($this->table->tva_rate)==0||$this->table->tva_rate>1)
        {
            $this->set_error("tva_rate", _("Taux de TVA invalide"));
        }
 
        //Check the label must be unique
        $count=$cn->get_value("select count(*) from tva_rate where tva_id<>$1 and lower(tva_label)=lower($2)",
                [$this->getPreviousId(), $this->table->tva_label]);
        if ($count>0)
        {
            $this->set_error("tva_label", _("Ce nom est déjà utilisé"));
        }
 
        // Check accounting exists for purchase
        if (trim($this->table->tva_purchase??"")!=""&&$this->table->tva_purchase!="#")
        {
            $count=$cn->get_value("select count(*) from tmp_pcmn where pcm_val = $1",
                    [$this->table->tva_purchase]);
            if ($count==0)
            {
                $this->set_error("tva_purchase", _("Poste comptable inexistant"));
            }
        }
        // Check accounting exists for sale
        if (trim($this->table->tva_sale??"")!=""&&$this->table->tva_sale!="#")
        {
            $count=$cn->get_value("select count(*) from tmp_pcmn where pcm_val = $1",
                    [$this->table->tva_sale]);
            if ($count==0)
            {
                $this->set_error("tva_sale", _("Poste comptable inexistant"));
            }
        }
 
        // check if tva_both_side is valid
        if ($this->table->tva_both_side!=0&&$this->table->tva_both_side!=1)
        {
            $this->set_error("tva_both_side", _("Choix incorrect"));
        }
        $flag = true;
        // Check that tva_id is a integer not a float (TVA_ID is an integer)
        if ( isNumber($this->table->tva_id) == 0 || $this->table->tva_id != round($this->table->tva_id) )
        {
            $this->set_error("tva_id",_("Valeur invalide"));
            $flag=false;
        }
        // Check if old tva_id was not overwritting something
        if ( $flag && $this->previous_id != $this->table->tva_id && $cn->get_value("select count(*) from tva_rate where tva_id=$1",[$this->table->tva_id]) > 0)
        {
            $this->set_error("tva_id",_("Code TVA déjà utilisé"));
        }
        // Check that tva code is unique and remove not letter
        $this->table->tva_code=strtoupper(trim( $this->table->tva_code));
        $tva_code=$this->table->tva_code;
 
        $tva_code=strtoupper($tva_code);
        $tva_code=preg_replace("/[A-Z]/", "", $tva_code);
        $tva_code=preg_replace("/[0-9]/", "", $tva_code);
 
        if (strlen($tva_code)>0){
            $this->set_error("tva_code", _("code tva : Uniquement des chiffres et des lettres"));
        }
 
        if (strlen($this->table->tva_code)>5){
            $this->set_error("tva_code", _("code tva : Maximum 5 caractères"));
        }
        if (isNumber($this->table->tva_code) == 1){
            $this->set_error("tva_code", _("code tva : doit aussi contenir des lettres"));
        }
        /**
         * auto reverse VAT : check that the accounting is used
         */
        if ( $this->table->tva_both_side==0 && trim($this->table->tva_reverse_account??"") != "")
        {
            $this->set_error("tva_reverse_account", _("Pas d'autoliquidation demandé"));
        }
        if ( $this->table->tva_both_side==1 && trim($this->table->tva_reverse_account??"") != "")
        {
            $count=$cn->get_value("select count(*) from tmp_pcmn where pcm_val = $1",
                [$this->table->tva_reverse_account]);
            if ($count==0)
            {
                $this->set_error("tva_reverse_account", _("Poste comptable inexistant"));
            }
        }
        // label cannot be empty
        if ( trim($this->table->tva_label??"")=="") {
            $this->set_error("tva_label", _('Le label ne peut être vide'));
        }
        
        // if vatex is set then code invoice must be different from S and Z
        if ( $g_parameter->MY_INVOICE_FORMAT == 'UBL21BE'  && trim($this->table->vx_code??"") != "" && in_array($this->table->tva_peppol_code,['S','Z'] ))
        {
            $this->set_error("vx_code",_("Le code d'exemption TVA ne peut être utilisé avec ce  code Facture électronique UBL "));
        }
        // if vatex is set then code invoice must be different from S and Z
        if ( $g_parameter->MY_INVOICE_FORMAT == 'UBL21BE'  && trim($this->table->vx_code??"") != "" && $this->table->tva_peppol_code=="")
        {
            $this->set_error("vx_code",_("Le code d'exemption TVA n' pas de sens sans code Facture électronique"));
        }
        // if tva_peppol_code is not S or Z then a VATEX code must be supplied
        if ( $g_parameter->MY_INVOICE_FORMAT == 'UBL21BE' 
                && ! in_array($this->table->tva_peppol_code??"",["Z","S"]) 
                && trim($this->table->vx_code??"" ) =="")
        {
            $this->set_error("vx_code",_("Un code d'exemption de TVA doit être fourni, voyez le manuel"));
            
        }
        if ($this->count_error()!=0)
            return false;
        return true;
    }

References $cn, $count, $flag, $g_parameter, _, Manage_Table_SQL\count_error(), getPreviousId(), isNumber(), Manage_Table_SQL\set_error(), and table.

Here is the call graph for this function:

◆ delete()

Tva_Rate_MTable::delete ( )

delete if not used anywhere

Reimplemented from Manage_Table_SQL.

Definition at line 481 of file tva_rate_mtable.class.php.

    {
        $cn=Dossier::connect();
        $count_purchase=$cn->get_value("select count(*) from quant_purchase where qp_vat_code = $1",[$this->table->tva_id]);
        $count_sale=$cn->get_value("select count(*) from quant_sold where qs_vat_code = $1",[$this->table->tva_id]);
        if ( $count_purchase > 0 || $count_sale > 0) {
            throw new Exception(_("Effacement interdit : TVA utilisée"));
        }
        
        // Forbid to remove all tva 
        $count=$cn->get_value("select count(*) from tva_rate");
        if ( $count < 2) {
            throw new Exception(_("Vous ne pouvez pas effacer tous les taux. Si votre société n'utilise pas la TVA, changer dans le menu société"));
        }
        $cn->exec_sql("delete from tva_rate where tva_id=$1", [$this->table->tva_id]);
    }

References $cn, $count, _, and table.

◆ from_request()

Tva_Rate_MTable::from_request ( )

add the TVA_REVERSE_ACCOUNT

Returns: void

Reimplemented from Manage_Table_SQL.

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

    {
        parent::from_request();
        $http=new \HttpInput();
        $this->table->tva_reverse_account=$http->request('tva_reverse_account');
        $this->table->tva_peppol_code=$http->request('tva_peppol_code');
        $this->table->vx_code=$http->request('vx_code');
    }

References $http, and table.

◆ getPreviousId()

Tva_Rate_MTable::getPreviousId ( )

Returns: int or null

Definition at line 106 of file tva_rate_mtable.class.php.

    {
        return $this->previous_id;
    }

References $previous_id.

Referenced by check().

◆ input()

Tva_Rate_MTable::input ( )

display into a dialog box the datarow in order to be appended or modified.

Can be override if you need a more complex form

Reimplemented from Manage_Table_SQL.

Definition at line 126 of file tva_rate_mtable.class.php.

    {
        $nb_order=count($this->a_order);
        $this->set_property_visible('tva_reverse_account', true);
        $this->set_property_visible('tva_peppol_code', true);
        echo "<table>";
        for ($i=0; $i<$nb_order; $i++)
        {
            echo "<tr>";
            $key=$this->a_order[$i];
            $label=$this->a_label_displaid[$key];
            $value=$this->table->get($key);
            $error=$this->get_error($key);
            $error=($error=="")?"":HtmlInput::errorbulle($error);
 
            if ($this->get_property_visible($key)===TRUE)
            {
                $info="";
                if ( isset($this->a_info[$key])) {
                    $info=Icon_Action::infobulle($this->a_info[$key]);
                }
                // Label
                echo "<td> {$label} {$info} {$error}</td>";
 
                if ($this->get_property_updatable($key)==TRUE)
                {
                    echo "<td>";
                    if ($this->a_type[$key]=="select")
                    {
                        $select=new ISelect($key);
                        $select->value=$this->a_select[$key];
                        $select->selected=$value;
                        echo $select->input();
                    }
                    elseif ($key=="tva_rate")
                    {
                        $text=new INum($key);
                        $text->value=$value;
                        $text->prec=4;
                        $min_size=(strlen($value??"")<10)?10:strlen($value)+1;
                        $text->size=$min_size;
                        echo $text->input();
                    }
                    elseif ($key=='tva_purchase')
                    {
                        $text=new IPoste("tva_purchase");
                        $text->value=$value;
                        $min_size=10;
                        $text->size=$min_size;
                        $text->set_attribute('gDossier', Dossier::id());
                        $text->set_attribute('jrn', 0);
                        $text->set_attribute('account', 'tva_purchase');
                        echo $text->input();
                        $url="do.php?".http_build_query(array("gDossier"=>Dossier::id(),"ac"=>'C0PCMN','p_start'=>4));
                        echo HtmlInput::anchor(_("Configuration poste comptable"),$url,"",'target="_blank"');
                    }
                    elseif ($key=='tva_sale')
                    {
                        $text=new IPoste("tva_sale");
                        $text->value=$value;
                        $min_size=10;
                        $text->set_attribute('gDossier', Dossier::id());
                        $text->set_attribute('jrn', 0);
                        $text->set_attribute('account', 'tva_sale');
                        $text->size=$min_size;
                        echo $text->input();
                    }elseif ($key=='tva_peppol_code') {
                        $text=new ISelect('tva_peppol_code');
                        $text->selected=$value;
                        $text->transform(array(
                            null=>_('-')
                            ,"S"=>_('S Taux standard')
                            ,'AE'=>_('AE Autoliquidate mais pas INTRACOMM.')
                            ,'Z'=>_("Z TVA à 0%")
                            ,'K'=>_('K Autoliquidation INTRACOMM.')
                            ,'G'=>_('G TVA exempt pour export hors Europe')
                            ,'O'=>_('O TVA Hors périmètre application')
                            ,'E'=>_('E Exempté de TVA')
                        ));
                        echo $text->input();
                    } elseif ($key == 'vx_code')
                    {
                        $text=\HtmlInput::hidden("vx_code",$value);
                        echo $text;
                        if ( $value !="") {
                            $value= \Icon_Action::trash(uniqid(),"vat_code.select_value('xx')").$value;
                        }
                        echo span($value,'id="vx_value"');
                        $js=sprintf("vat_code.list_vatex()");
                        echo \Icon_Action::icon_magnifier(uniqid(),$js );
                        
                    }
                    elseif ($key == "tva_id") {
                        $inum=new INum($key,$value);
                        echo $inum->input();
                        echo \HtmlInput::hidden("old_tva_id",$value);
 
                    } elseif ($key=='tva_reverse_account')
                    {
                        $text=new IPoste("tva_reverse_account");
                        $text->value=$value;
                        $min_size=10;
                        $text->set_attribute('gDossier', Dossier::id());
                        $text->set_attribute('jrn', 0);
                        $text->set_attribute('account', 'tva_reverse_account');
                        $text->size=$min_size;
                        echo $text->input();
                    }elseif ($this->a_type[$key]=="text")
                    {
                        $text=new IText($key);
                        $text->value=$value;
                        $min_size=(strlen($value??"")<30)?30:strlen($value)+5;
                        $text->size=$min_size;
                        echo $text->input();
                    }
                    echo "</td>";
                }
                else
                {
                    printf('<td>%s %s</td>', h($value),
                            HtmlInput::hidden($key, $value)
                    );
                }
                echo '<td >';
                if (isset ($this->a_comment[$key])) {
                    print '<p class="text-muted">';
                    echo $this->a_comment[$key];
                    print '</p>';
                }
                if( $key == 'vx_code') {
                    echo '<span id="vx_code_description">';
                       $row=$this->table->cn->get_row("select vx_code,vx_code_name,vx_description,vx_remark  from vatex_code  where vx_code=$1",
                           [$value]);
                       if ( ! empty ($row)) {
                            echo $row['vx_description'].span($row['vx_remark'],' class="text-muted" ');
                           
                       }
                    echo '</span>';
                }
                echo '</td>';
            }
            echo "</tr>";
        }
        echo "</table>";
    }

References $error, $i, $js, $label, $row, $select, $text, $url, $value, _, elseif, Manage_Table_SQL\get_error(), Manage_Table_SQL\get_property_updatable(), Manage_Table_SQL\get_property_visible(), h, Icon_Action\infobulle(), print, Manage_Table_SQL\set_property_visible(), span(), table, and Icon_Action\trash().

Here is the call graph for this function:

◆ save()

Tva_Rate_MTable::save ( )

save the data in TVA_RATE if tva_both_side is 1 and tva_purchase or tva_sale is empty then it is equal to the other value

Reimplemented from Manage_Table_SQL.

Definition at line 291 of file tva_rate_mtable.class.php.

    {
        if ( $this->previous_id === null ) {
            throw new \Exception ("TVA184: no previous TVA id");
        }
        $cn=Dossier::connect();
        // if tva_both_side is 1 and tva_purchase or tva_sale is empty then
        // it is equal to the other value
        if ($this->table->tva_both_side==1)
        {
            if ($this->table->tva_purchase=="#"||trim($this->table->tva_purchase)
                    =="#")
            {
                $this->table->tva_purchase=$this->table->tva_sale;
            }
            if ($this->table->tva_sale=="#"||trim($this->table->tva_sale)=="#")
            {
                $this->table->tva_sale=$this->table->tva_purchase;
            }
        }
        $new_tva_id=$this->table->tva_id;
        $tva_rate=new Tva_rate_SQL($cn);
        $tva_rate->setp("tva_id",$new_tva_id);
        $tva_rate->setp("tva_rate", $this->table->tva_rate);
        $tva_rate->setp("tva_code", $this->table->tva_code);
        $tva_rate->setp("tva_label", $this->table->tva_label);
        $tva_rate->setp("tva_comment", $this->table->tva_comment);
        $tva_rate->setp("tva_both_side", $this->table->tva_both_side);
        $tva_rate->setp("tva_reverse_account", $this->table->tva_reverse_account);
        $tva_rate->setp("tva_peppol_code", $this->table->tva_peppol_code);
        $tva_rate->setp("vx_code", $this->table->vx_code);
 
        // TVA accounting must be joined and separated with a comma
        $tva_purchase=(trim($this->table->tva_purchase)=="")?"#":$this->table->tva_purchase;
        $tva_sale=(trim($this->table->tva_sale)=="")?"#":$this->table->tva_sale;
        $tva_rate->setp("tva_poste", $tva_purchase.",".$tva_sale);
        $tva_rate->setp("tva_payment_sale", $this->table->tva_payment_sale);
        $tva_rate->setp("tva_payment_purchase", $this->table->tva_payment_purchase);
        if ( $this->previous_id == -1 ) {
            $tva_rate->insert();
        } else {
            $tva_rate->update();
        }
        if ( $this->previous_id != - 1 && $this->previous_id != $new_tva_id) {
            $cn->exec_sql("update tva_rate set tva_id = $1 where tva_id = $2",[$new_tva_id,$this->previous_id]);
            $this->table->setp("tva_id",$new_tva_id);
        }else     {
            $this->table->setp("tva_id",$tva_rate->getp("tva_id"));
        }
 
    }

References $cn, $tva_rate, and table.

◆ setPreviousId()

Tva_Rate_MTable::setPreviousId ( $previous_id )

Parameters

int $previous_id

Definition at line 115 of file tva_rate_mtable.class.php.

                                               : Tva_Rate_MTable
    {
        $this->previous_id = $previous_id;
        return $this;
    }

References $previous_id.

Field Documentation

◆ $a_comment

Tva_Rate_MTable::$a_comment

private

Supplemental explanation.

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

◆ $previous_id

Tva_Rate_MTable::$previous_id

private

< previous tva_id, used to know if we update or insert,

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

Referenced by getPreviousId(), and setPreviousId().

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

include/class/tva_rate_mtable.class.php

Public Member Functions

Private Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ check()

◆ delete()

◆ from_request()

◆ getPreviousId()

◆ input()

◆ save()

◆ setPreviousId()

Field Documentation

◆ $a_comment

◆ $previous_id