Tree in Compiere

The tree information in compiere242 (Version: d) is extracted from the corresponding database table. Table functions are divided into the following three types:
1. tables that store tree information
This type of table records the overall description of the tree. The related tables are as follows:
Table Name field meaning

Ad_tree
Name of the name tree
Description: Description of the tree.
Treetype Tree Type
Note:
1. In this table, treetype (tree type) Stores
Value. In compiere242 (version), eleven values are preset for the treetype (tree type) as shown in the following table:
Meanings of Values
MM indicates menu information EV indicates account elementvalue Information
PR indicates the product information. BP indicates the businesspartner information.
OO indicates organization information PJ indicates project information
PC indicates the product catalog information. BB indicates the BOM information.
Sr indicates sales region information. Mc indicates camoaign information.
Ay indicates activity information
2. treetype (tree type) determines the tables in the database from which the relevant node logical structure information and each node are extracted during tree loading.
. Currently, three types of "mm", "BP", and "PR" are implemented in compiere242 (version ).
The logical structure information of the node. The detailed information of each node has been implemented;
3. treetype (tree type) indicates the type of tree display information. Therefore, if you need to display
Compiere242 (Version: d) information other than the preset type, you need to add a new type in the ad_ref_list table
And add a new record to the ad_tree table (the treetype value of the new record is the new value set in the ad_ref_list table );
4. This type of table is called in the loadtree () function in vtree. Java;
1. 2. tables that store the logical structure information of each node in the tree
This type of table records the logical relationship information of each node in the tree. The related tables are as follows:
Table Name field meaning

Ad_treenode node_id ID of the Tree node
Parent node of the parent_id Tree node
Sequence Number of the seqno Tree node in the tree

Ad_treenodebp node_id ID of the Tree node
Parent node of the parent_id Tree node
Sequence Number of the seqno Tree node in the tree

Ad_treenodepr node_id ID of the Tree node
Parent node of the parent_id Tree node
Sequence Number of the seqno Tree node in the tree
Note:
1. This type table corresponds to the tree type one by one. Currently Code Has been implemented in
See the following table:
Tree Type logical structure information table tree type logical structure information table
MM ad_treenode EV ad_treenodebp
PR ad_treenodepr
If you need to implement a new logical structure, you must modify it in the code. Functions of this part of code in vtree. Java
Loadnotes;
2. The structure of this type of table is completely consistent. You can consider merging these tables in the future;
. Table storing the shortcut information of each node in the tree
This type of table records node shortcuts in the tree. The related tables are as follows:
Table Name field meaning
Whether the shortcut of the ad_treebar isactive Tree node is displayed
Note: 1. This type of table is used in the loadnotes () function of vtree. java;
. Tables that store the information of each node
This type mainly records the detailed information of each node in the tree. The related tables are as follows:
Table Name field meaning

Name of the ad_menu Name node displayed in the tree
Description Description of the node
Issummary is used to determine whether a node has subnodes.
Action indicates the operation performed when double-clicking the node.
Ad_menu_trl name: name of a node that can be displayed in multiple languages

Name of the ad_org Name node displayed in the tree
Description Description of the node
Issummary is used to determine whether a node has subnodes.
M_product is the same as above.
M_product_category is the same as above.
M_bom is the same as above.
C_elementvalue is the same as above.
C_bpartner is the same as above.
C_campaign is the same as above.
C_project is the same as above.
C_activity is the same as above.
C_salesregion is the same as above.
Note:
1. The getnodedetail (INT node_id, int parent_id, int seqno,
Boolean onbar) is called;
2. The multi-language display of nodes in compiere242 (version) is only implemented by ad_menu, but not by other tables. For example
To enable other tables to support multiple languages, you must add the structure such as ad_menu_trl to each table in the database.
Table, and the code should be modified accordingly. This part of code is in the vtree. Java function preparenodedetail ().
3. In the existing database of compiere242 (version), if the following table is implemented: m_bom, c_campaign