this instance extends Manage_Table_SQL and aims to manage the Table tmp_pcmn thanks a web interface (add , delete, display...) More...

Inheritance diagram for Acc_Plan_MTable:

Collaboration diagram for Acc_Plan_MTable:

Public Member Functions
	__construct (Acc_Plan_SQL $p_table)

	check ()
	Check that the entered data are valid before recording them into tmp_pcmn, the errors are stored into this->a_error and if someting wrong is found it returns false, if the data can be saved it returns true. More...

	display_row ($p_row)
	Display a row. More...

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

	input_custom ($p_key, $p_value)
	if pcm_val already used then it cannot be modified More...

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

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

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

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

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

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

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

	check ()

	count_error ()
	returns the nb of errors found More...

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

	delete ()
	delete a datarow , the id must be have set before More...

	display_error ()
	Display a list of the error collected. More...

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

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

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

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

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

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

	from_request ()
	get the data from http request strip the not update or not visible data to their initial value. More...

	get_button_add_top ()

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

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

	get_col_type ($p_key)
	return the type of a column More...

	get_current_pos ($p_key)
	get the position of a column More...

	get_current_row ()
	Return the current row printed in display_row. More...

	get_dialog_box ()

	get_dialogbox_style ()
	return the db_style More...

	get_error ($p_col)
	retrieve the error message More...

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

	get_icon_del ()

	get_icon_mod ()

	get_js_variable ()
	Get the object name. More...

	get_json ()

	get_object_name ()

	get_order ()

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

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

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

	get_sort_column ()
	return the column to sort More...

	get_table ()

	getCssClass ()

	getTitle ()

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

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

	insert ()
	insert a new value More...

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

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

	save ()
	save the Data_SQL Object The noalyss_SQL is not empty More...

	send_header ()
	send the XML headers for the ajax call More...

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

	set_button_add_top ($button_add_top)

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

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

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

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

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

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

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

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

	set_dialog_box ($dialog_box)

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

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

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

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

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

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

	set_object_name ($p_object_name)
	Set the object_name. More...

	set_order ($p_order)

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

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

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

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

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

	set_table (Data_SQL $p_noalyss_sql)

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

	set_value ($p_key, $p_value)

	setCssClass ($p_class)

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

	show_error ($p_col)

	update ()

Additional Inherited Members
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 More...

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

	$a_info
	Array with the infotip. More...

	$a_label_displaid
	Label of the col. of the datarow. More...

	$a_order
	order of the col More...

	$a_prop
	property for each col. More...

	$a_select
	Possible value if a_type is a SELECT. More...

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

	$aerror
	Array containing the error of the input data. More...

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

	$callback
	Callback function. More...

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

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

	$current_row
	CSS class for the dialog box. More...

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

	$dialogbox_style
	style of the dialog box More...

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

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

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

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

	$row_append
	Flag to indicate if rows can be added. More...

	$row_delete
	Flag to indicate if rows can be deleted. More...

	$row_update
	Flag to indicate if rows can be updated. More...

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

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

	$table
	Object Data_SQL. More...

	$title

Detailed Description

this instance extends Manage_Table_SQL and aims to manage the Table tmp_pcmn thanks a web interface (add , delete, display...)

See also: Acc_Plan_SQL

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

Constructor & Destructor Documentation

◆ __construct()

Acc_Plan_MTable::__construct ( Acc_Plan_SQL $p_table )

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

    {
        $this->table = $p_table;
        parent::__construct($p_table);
        //--------------------------------------------------------------
        //Set the table header 
        //--------------------------------------------------------------
        $this->set_col_label("pcm_val", _("Poste Comptable"));
        $this->set_col_label("pcm_type", _("Type"));
        $this->set_col_label("pcm_lib", _("Libellé"));
        $this->set_col_label("parent_accounting", _("Dépend"));
        $this->set_col_label("fiche_qcode", _("Fiche"));
        $this->set_col_label("pcm_direct_use", _("Utilisation directe"));
        //--------------------------------------------------------------
        $this->set_property_visible("id", FALSE);
        $this->set_property_updatable("fiche_qcode", FALSE);
        $this->set_col_type("pcm_type", "select", [
            ["label"=>_("Actif"),"value"=>"ACT"],
            ["label"=>_("Actif inversé"),"value"=>"ACTINV"],
            ["label"=>_("Passif"),"value"=>"PAS"],
            ["label"=>_("Passif Inversé"),"value"=>"PASINV"],
            ["label"=>_("Charge"),"value"=>"CHA"],
            ["label"=>_("Charge inversé"),"value"=>"CHAINV"],
            ["label"=>_("Produit"),"value"=>"PRO"],
            ["label"=>_("Produit inversé"),"value"=>"PROINV"],
            ["label"=>_("Contexte"),"value"=>"CON"]
        ]);
        $this->set_col_type("pcm_direct_use", "select",
            array(["label" => _("Oui"), "value" => "Y"], ["label" => "Non", "value" => "N"]));
        $this->set_col_type("pcm_val", "custom");
        $this->a_order = ["pcm_val", "pcm_lib", "parent_accounting", "pcm_direct_use", "pcm_type", "fiche_qcode"];
        $this->set_icon_mod("first");
        $this->set_dialogbox_style(["width"=>"auto"]);
    }

References Manage_Table_SQL\set_col_label(), Manage_Table_SQL\set_col_type(), Manage_Table_SQL\set_dialogbox_style(), Manage_Table_SQL\set_icon_mod(), Manage_Table_SQL\set_property_updatable(), Manage_Table_SQL\set_property_visible(), and table.

Here is the call graph for this function:

Member Function Documentation

◆ check()

Acc_Plan_MTable::check ( )

Check that the entered data are valid before recording them into tmp_pcmn, the errors are stored into this->a_error and if someting wrong is found it returns false, if the data can be saved it returns true.

Returns: return false if an error is found,

Check that the parent accounting does exist

check that accounting is not already used

Reimplemented from Manage_Table_SQL.

Definition at line 163 of file acc_plan_mtable.class.php.

    {
        $cn=Dossier::connect();
        $count=$cn->get_value("select count(*) from tmp_pcmn where pcm_val = $1 and id <> $2",
                    array($this->table->pcm_val,$this->table->id));
        if ($count > 0 ) {
            $this->set_error("pcm_val", _("Poste comptable est unique"));
        }
        if ( trim($this->table->pcm_val) == "") {
            $this->set_error("pcm_val", _("Poste comptable ne peut être vide"));
        }
        // Check size
         if ( noalyss_strlentrim($this->table->pcm_val) > 40) {
            $this->set_error("pcm_val", _("Poste comptable trop long"));
        }
        if ( trim($this->table->parent_accounting) == "") {
            $this->set_error("parent_accounting", _("Poste comptable dépendant ne peut pas être vide"));
        }
        /**
         * Check that the parent accounting does exist
         */
        $exist_parent=$cn->get_value("select count(*) from tmp_pcmn where pcm_val = $1 ",
                    array($this->table->parent_accounting));
        if ($exist_parent == 0) {
            $this->set_error("parent_accounting", _("Compte parent n'existe pas"));
        }
        /**
         * check that accounting is not already used
         */
        $old_accounting = $cn->get_value("select pcm_val from tmp_pcmn where id = $1",
            array($this->table->id));
        // it is not a new accounting and is different
        if ($old_accounting != "" && $old_accounting != $this->table->pcm_val) {
            // count it is used
            if ($cn->get_value("select count(*) from jrnx where j_poste=$1",
                    [$old_accounting]) > 0) {
                $this->set_error("pcm_val", _("Poste utilisé"));
            }
        }
        if (count($this->aerror) > 0) return false;
        return true;
    }

References $cn, $count, Dossier\connect(), noalyss_strlentrim(), Manage_Table_SQL\set_error(), and table.

Here is the call graph for this function:

◆ display_row()

Acc_Plan_MTable::display_row ( $p_row )

Display a row.

Parameters

type $p_row array of value key column=>value

Reimplemented from Manage_Table_SQL.

Definition at line 76 of file acc_plan_mtable.class.php.

    {
         printf('<tr  id="%s_%s">',
                 $this->object_name,
                $p_row[$this->table->primary_key])
        ;
 
        $dossier_id=Dossier::id();
        $nb_order=count($this->a_order);
        for ($i=0; $i<$nb_order; $i++)
        {
            $v=$this->a_order[$i];
            $nb=0;
            $cn=Dossier::connect();
            $nb_used=$cn->get_value("select count(*) from jrnx where j_poste=$1",[$p_row['pcm_val']]);
            $nb_plan=$cn->get_value("select count(*) from tmp_pcmn where pcm_val_parent=$1",[$p_row['pcm_val']]);
            $nb=$nb_used+$nb_plan;
            if ($v=="pcm_val")
            {
                $js=sprintf("onclick=\"%s.input('%s','%s');\"", $this->object_name,
                        $p_row[$this->table->primary_key], $this->object_name);
                echo sprintf('<td sort_type="text" sort_value="X%s">%s',
                        htmlspecialchars($p_row[$v]),
                        HtmlInput::anchor($p_row[$v], "", $js)).
                        '</td>';
            }
            elseif ($v == "fiche_qcode") {
                $count=$this->table->cn->get_value("select count(*) from fiche_detail where ad_id=5 and ad_value=$1"
                    ,array($p_row['pcm_val']));
               if ($count ==  0) echo td("");
               elseif ($count == 1 ) {
                   echo '<td>';
                   echo HtmlInput::card_detail($p_row[$v]) ;
                   echo '</td>';
 
               }
               elseif ($count > 1) {
                   echo '<td>';
                   $a_code=explode(",",$p_row[$v]);
                   $nb_code=count($a_code);
                   for ($xx = 0;$xx < $nb_code;$xx++)
                   {
                       echo HtmlInput::card_detail($a_code[$xx],'','style="display:inline"')."," ;
                   }
                   echo  " ($count) ";
                   echo Icon_Action::more(uniqid(), sprintf("display_all_card('%s','%s')",
                       $dossier_id,$p_row["pcm_val"]));
                   echo '</td>';
 
               }
            }
            elseif ($v=="pcm_lib")
            {
 
                if ( $nb >0){
                    echo "<td>";
                    if ($nb_used > 0) {
                        $used=sprintf (' (%s)',$nb_used);
                        echo HtmlInput::history_account($p_row['pcm_val'],h($p_row["pcm_lib"].$used));
                    } else {
                        echo h($p_row["pcm_lib"]);
                    }
                    echo "</td>";
                } else {
                    echo td($p_row[$v]);
                }
 
            }
            else
            {
                if ( ! $this->get_property_visible($v)) continue;
                echo td($p_row[$v]);
            }
        }
        if ( $nb == 0 ) $this->display_icon_del($p_row);
        else echo td("&nbsp;");
 
 
        echo '</tr>';
    }

References $cn, $count, $dossier_id, $i, $js, $nb, $nb_plan, HtmlInput\anchor(), HtmlInput\card_detail(), Dossier\connect(), Manage_Table_SQL\display_icon_del(), elseif, Manage_Table_SQL\get_property_visible(), h, HtmlInput\history_account(), Dossier\id(), Icon_Action\more(), table, and td().

Here is the call graph for this function:

◆ input()

Acc_Plan_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 211 of file acc_plan_mtable.class.php.

    {
        parent::input();
        $dossier_id=Dossier::id();
        echo HtmlInput::button_action(_("Toutes les fiches") , sprintf("display_all_card('%s','%s')",$dossier_id,$this->table->pcm_val));
    }

References $dossier_id, HtmlInput\button_action(), Dossier\id(), and table.

Here is the call graph for this function:

◆ input_custom()

Acc_Plan_MTable::input_custom	(	$p_key,
		$p_value
	)

if pcm_val already used then it cannot be modified

Parameters

$p_key	always pcm_val
$p_value	current value of pcm_val

Returns: nothing|void

Reimplemented from Manage_Table_SQL.

Definition at line 225 of file acc_plan_mtable.class.php.

    {
        $readonly=true;
        $cn=Dossier::connect();
        if (
             $p_value == "" ||
            ($p_value !="" && $cn->get_value("select count(*) from jrnx where j_poste=$1",[$p_value]) == 0  )
            )
        {
            $readonly=false;
        }
        $text=new IText($p_key);
        $text->setReadOnly($readonly);
        $text->value=$p_value;
        $min_size=(strlen($p_value)<30)?30:strlen($p_value)+5;
        $text->size=$min_size;
        echo $text->input();
    }

References $cn, $readonly, $text, and Dossier\connect().

Here is the call graph for this function:

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

include/class/acc_plan_mtable.class.php

Public Member Functions

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ check()

◆ display_row()

◆ input()

◆ input_custom()