Display a table and allow to change the predefined operation, insert or delete. Used the class Manage_Table_SQL and the SQL Object for the tables op_predef and op_predef_detail. More...

Inheritance diagram for Operation_Predef_MTable:

Collaboration diagram for Operation_Predef_MTable:

Public Member Functions
	__construct (Op_Predef_SQL $p_table)

	display_button_add ()
	Display a button to choose a type of operation and call a dialog box for adding. More...

	from_request ()
	Get values from the request. More...

	get_force_ledger_type ()

	input ()
	Display the form. More...

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

	set_force_ledger_type ($force_ledger_type)
	When adding the ledger_type must be set if p_id == -2 then type ACH , 3 for VEN and 4 for ODS. 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 ()

Private Attributes
	$force_ledger_type
	When adding , the ledger must be set. More...

	$pre_operation

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

Display a table and allow to change the predefined operation, insert or delete. Used the class Manage_Table_SQL and the SQL Object for the tables op_predef and op_predef_detail.

See also: include/preod.inc.php; include/ajax/ajax_save_predf_op.php

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

Constructor & Destructor Documentation

◆ __construct()

Operation_Predef_MTable::__construct ( Op_Predef_SQL $p_table )

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

    {
        parent::__construct($p_table);
 
        $this->set_property_visible("od_id",false);
        $this->set_property_visible("od_direct",false);
        $this->set_property_visible("od_item",false);
        $this->set_col_label("jrn_def_id",_("Journal"));
        $this->set_col_label("od_name",_("Nom"));
        $this->set_col_label("od_jrn_type",_("Type de journal"));
        $this->set_col_label("od_description",_("Description"));
 
        $aLedger=$p_table->cn->make_array("select jrn_def_id,jrn_def_name from jrn_def order by jrn_def_name asc");
 
        $this->set_sort_column("od_name");
        $this->set_col_sort(1);
        $this->set_order(array("jrn_def_id","od_name","od_description","od_jrn_type"));
        $this->set_col_type("jrn_def_id","select",$aLedger);
 
        $this->set_callback("ajax_misc.php");
        $this->set_property_updatable("jrn_def_id",false);
        $this->set_property_updatable("od_jrn_type",false);
        $this->pre_operation=null;
        // create our own "Append button"
        $this->set_append_row(false);
        $this->set_dialog_box("prdfop");
    }

References Manage_Table_SQL\set_append_row(), Manage_Table_SQL\set_callback(), Manage_Table_SQL\set_col_label(), Manage_Table_SQL\set_col_sort(), Manage_Table_SQL\set_col_type(), Manage_Table_SQL\set_dialog_box(), Manage_Table_SQL\set_order(), Manage_Table_SQL\set_property_updatable(), Manage_Table_SQL\set_property_visible(), and Manage_Table_SQL\set_sort_column().

Here is the call graph for this function:

Member Function Documentation

◆ display_button_add()

Operation_Predef_MTable::display_button_add ( )

Display a button to choose a type of operation and call a dialog box for adding.

Definition at line 164 of file operation_predef_mtable.class.php.

    {
        $select=new Select_Box(uniqid(),_("Ajout"));
        $select->set_position('in-absolute');
        $select->add_javascript(_("Achat"),sprintf("%s.input('-2','%s')",
            $this->get_object_name(),
            $this->get_object_name(), "xx", "smallbutton", BUTTONADD));
 
        $select->add_javascript(_("Vente"),sprintf("%s.input('-3','%s')",
            $this->get_object_name(),
            $this->get_object_name(), "xx", "smallbutton", BUTTONADD));
 
          $select->add_javascript(_("Opérations Diverses"),sprintf("%s.input('-4','%s')",
              $this->get_object_name(),
              $this->get_object_name(), "xx", "smallbutton", BUTTONADD));
        echo $select->input();
    }

References $select, BUTTONADD, and Manage_Table_SQL\get_object_name().

Here is the call graph for this function:

◆ from_request()

Operation_Predef_MTable::from_request ( )

Get values from the request.

table is the sql table
ctl_id is the dialog box id
p_id = predef_op.od_id

json = {"table":"public.op_predef",
         "ctl_id":"dtr",
         "ac":"COMPTA/ADV/PREDOP",
         "op":"save_predf",
         "gDossier":["28", "28"],
         "p_id":"15",
         "action":"save",
         "ctl":"tbl5f6a1d09035f2",
         "nb_item":"10",
         "e_client":"",
         "p_jrn":"2",
         "e_march0":"MARCHA",
         "e_march0_price":"102.0000",
         "e_quant0":"1.0000",
         "htva_march0":"0",
         "e_march0_tva_id":"4",
         "bt_e_march0_tva_id":"+TVA+",
         "e_march0_tva_amount":"0.0000",
         "tva_march0":"0","tvac_march0":"0",
         "jrn_type":"VEN",
         "5f6a1d0b23242_ledger":"O","
         5f6a1d0b23242":"1",
         "update":"OK",
         "5f6a1d5b70997_ledger":"O",
         "5f6a1d5b70997":"1"}

Reimplemented from Manage_Table_SQL.

Definition at line 146 of file operation_predef_mtable.class.php.

    {
        $http=new HttpInput();
        $obj=$this->get_table();
        $this->pre_operation=new Pre_operation($obj->cn);
        $this->pre_operation->get_post();
        $this->pre_operation->set_od_id($http->post("p_id","number"));
    }

References $http, $obj, and Manage_Table_SQL\get_table().

Here is the call graph for this function:

◆ get_force_ledger_type()

Operation_Predef_MTable::get_force_ledger_type ( )

Returns: mixed

Definition at line 72 of file operation_predef_mtable.class.php.

    {
        return $this->force_ledger_type;
    }

References $force_ledger_type.

Referenced by input().

◆ input()

Operation_Predef_MTable::input ( )

Display the form.

Exceptions

Exception

Reimplemented from Manage_Table_SQL.

Definition at line 93 of file operation_predef_mtable.class.php.

    {
        $obj=$this->get_table();
        $od_id=$obj->get("od_id");
        if ($od_id > 0 ) {
            $this->pre_operation = new Pre_operation($obj->cn);
            $this->pre_operation->set_od_id($obj->get("od_id"));
            $this->pre_operation->display();
        } else  {
            // display blanck operation type ledger = ACH
            $this->pre_operation = new Pre_operation($obj->cn);
            // new operation od_id = -1
            $this->pre_operation->set_od_id(-1);
            $this->pre_operation->set_jrn_type($this->get_force_ledger_type());
            $this->pre_operation->display();
 
        }
    }

References $obj, get_force_ledger_type(), and Manage_Table_SQL\get_table().

Here is the call graph for this function:

◆ save()

Operation_Predef_MTable::save ( )

save the Data_SQL Object The noalyss_SQL is not empty

See also: from_request

Reimplemented from Manage_Table_SQL.

Definition at line 155 of file operation_predef_mtable.class.php.

    {
       $this->pre_operation->save();
       $this->set_pk($this->pre_operation->get_od_id());
    }

References Manage_Table_SQL\set_pk().

Here is the call graph for this function:

◆ set_force_ledger_type()

Operation_Predef_MTable::set_force_ledger_type ( $force_ledger_type )

When adding the ledger_type must be set if p_id == -2 then type ACH , 3 for VEN and 4 for ODS.

Parameters

mixed $force_ledger_type

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

    {
        $aLedger=array(-2=>'ACH',-3=>'VEN',-4=>'ODS');
        $this->force_ledger_type = $aLedger[$force_ledger_type];
        return $this;
    }