Kumar A. ADempiere 3.6 Cookbook
Подождите немного. Документ загружается.
ADempiere Customization – Part I
58
There's more...
ADempiere determines the eld data type and validation using the eld Reference. There is
a list of pre-dened Reference lists, which ADempiere provides. Moreover, in case you need,
you can also create a new reference for your application. You may refer to the supported
Reference list at http://en.wikiversity.org/wiki/ADempiere_Application_
Dictionary#Reference.
Creating a window with multiple tabs
It is pretty common to logically relate the information using tabs. This recipe describes the
steps to add multiple tabs in a window. So far, we have our basic MOM window. Now, we will
break it into multiple tabs:
f The Participants detail is moved to a new tab—Participants
f The Discussion detail is rened and we are going to capture the following information
as part of every discussion item:
Item number
Discussion description
Actioned by
Status
This is also moved to a new tab—Discussion Detail
Getting ready
Connect to the database adempiere360 using adempiere as a user using your favorite
PostgreSQL client (for example, phpPgAdmin or pgAdmin III or command based psql).
How to do it...
1. Delete the records from the c_mom table.
2. Delete the menu—Minutes Of Meeting.
3. Related to MOM, delete the following from the Window, Tab, and Field windows,
as per the order mentioned:
Field(s)
Tab
Window
Chapter 2
59
4. Related to MOM, delete the following from the Table and Column windows, as per the
order mentioned:
Columns
Table
5. Drop the adempiere.c_mom table by running the following SQL:
DROP TABLE adempiere.c_mom;
6. Apply the following SQL to your adempiere schema:
CREATE TABLE adempiere.c_mom (
c_mom_id numeric(10,0) NOT NULL,
ad_client_id numeric(10,0) NOT NULL,
ad_org_id numeric(10,0) NOT NULL,
isactive character(1) DEFAULT 'Y'::bpchar NOT NULL,
created timestamp without time zone DEFAULT now() NOT NULL,
createdby numeric(10,0) NOT NULL,
updated timestamp without time zone DEFAULT now() NOT NULL,
updatedby numeric(10,0) NOT NULL,
value character varying(30) NOT NULL,
name character varying(255) NOT NULL,
start_date date NOT NULL,
start_time timestamp without time zone NOT NULL,
end_time timestamp without time zone NOT NULL,
chairperson character varying(80),
agenda character varying(4000),
CONSTRAINT c_mom_pkey PRIMARY KEY (c_mom_id)
);
CREATE TABLE adempiere.c_mom_discussionline (
c_mom_discussionline_id numeric(10,0) NOT NULL,
c_mom_id numeric(10,0) NOT NULL,
ad_client_id numeric(10,0) NOT NULL,
ad_org_id numeric(10,0) NOT NULL,
isactive character(1) DEFAULT 'Y'::bpchar NOT NULL,
created timestamp without time zone DEFAULT now() NOT NULL,
createdby numeric(10,0) NOT NULL,
updated timestamp without time zone DEFAULT now() NOT NULL,
updatedby numeric(10,0) NOT NULL,
item_nbr numeric (10,0) NOT NULL,
discussion_desc character varying(2000),
actionedby character varying(80) NOT NULL,
Down l o a d f r o m Wow ! e B o o k < www. w o w e b o o k . com>
ADempiere Customization – Part I
60
status character varying(80),
CONSTRAINT cmom_cdiscussionline FOREIGN KEY (c_mom_id)
REFERENCES adempiere.c_mom (c_mom_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY
DEFERRED
);
CREATE TABLE adempiere.c_mom_participantsline (
c_mom_participantsline_id numeric(10,0) NOT NULL,
c_mom_id numeric(10,0) NOT NULL,
ad_client_id numeric(10,0) NOT NULL,
ad_org_id numeric(10,0) NOT NULL,
created timestamp without time zone DEFAULT now() NOT NULL,
createdby numeric(10,0) NOT NULL,
updated timestamp without time zone DEFAULT now() NOT NULL,
updatedby numeric(10,0) NOT NULL,
participant character varying(80),
company character varying(80) NOT NULL,
CONSTRAINT cmom_cparticipantsline FOREIGN KEY (c_mom_id)
REFERENCES adempiere.c_mom (c_mom_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY
DEFERRED
);
c_mom: Represents the basic MOM detail
c_mom_discussionline: Represents each MOM discussion detail
c_mom_participantsline: Represents each MOM participant detail
7. Follow the steps mentioned in the Create a new window recipe to create the tables
and their columns. The following screenshot shows the list of tables after the
completion of the steps:
Chapter 2
61
8. Also, create a Minutes Of Meeting window with the MOM tab, as per the steps
mentioned in the Create a new window recipe. Similarly, add the Participants
and Discussion Detail tabs using the c_mom_participantsline and c_mom_
discussionline
tables, respectively, as shown in the following screenshot:
9. The Sequence eld on the Tab screen determines the tab sequence. A tab with the
least value of Sequence appears as the rst tab and the one with the largest value
appears as the last tab.
10. Select the Participants tab and switch to the single row view. The important
elds are:
Table: Select the participants table
Link Column: Select the MOM ID on the c_mom table
Tab Level: 1
ADempiere Customization – Part I
62
ADempiere uses Tab Level to indent the tab on a window and also, internally, uses
it to create SQL joins to fetch the related records. The main tab has the tab level as
0, by default. Moreover, a tab with level 1' becomes the child of the main tab and is
indented accordingly. For example, in the previous image, the tab Access has a tab
level of the main tab—Window. Tabs with the same tab level are siblings or peers. For
example, in the previous image, the Access and Tab tabs are at the same tab level.
11. Review the Field Sequence tab and make the required changes to the sequence, as
shown in the following screenshot:
12. Select the Discussion Detail tab and switch to the single row view. The important
elds are:
Table: Select the discussion line item table
Link Column: Select the MOM ID on the c_mom table
Tab Level: 1
Chapter 2
63
13. Review the Field Sequence tab and make the required changes to the sequence,
as shown in the following screenshot:
ADempiere Customization – Part I
64
14. Follow the steps 18-19, mentioned in the Create a new window recipe, to create a
menu, as shown in the following screenshot:
15. Log out and log in as GardenAdmin/GardenAdmin. You will see the Minutes Of
Meeting menu item, as it appears in the following screenshot:
Chapter 2
65
16. Click on the Minutes Of Meeting menu item. This will bring up the Minutes Of
Meeting window with one tab, MOM. Our MOM window now has three tabs and looks
more organized, as shown here in the following screenshot:
17. Add one or more participants for a MOM:
ADempiere Customization – Part I
66
18. Add one or more discussion items for a MOM:
How it works...
In steps 1-5, we cleaned up the dictionary entries that were created so far, as we have
changed the table structure of the c_mom table in this recipe and also introduced new tables,
namely, c_mom_discussionline and c_mom_participantsline. If we don't do this, the
dictionary entries will exist and may create problems when you try to recreate the dictionary
entries for the modied table. In steps 6-7, we recreated the c_mom table (with a modied set
of columns) and created c_mom_discussionline to save discussion line items for a MOM
and the c_mom_participantsline table to save the list of MOM participants. In steps
9-12, we created the tabs and their elds using each one of these three tables.
There's more...
To delete the records, (Windows, Tabs, Fields, and so on.) use Delete Records or Delete
Selected Items toolbar buttons (
) instead of deleting the records directly from the
database tables using SQL statements. This is important for the proper cleanup of the
records from that database. For example, ADempiere has translation tables (table name
ending with _trl) where the entries get created, internally, by ADempiere. If you directly
try to delete using SQL statements, you may miss these records.
Creating a search widget
On the MOM tab, we have the Chairperson eld where we are entering the username.
Similarly, we have the participant's name on the Participants tab and the Actioned By
person name on the
Discussion Detail tab. ADempiere maintains User/Contact detail.
To provide a better nishing of our MOM window, it would be good if we can connect these
elds with ADempiere's User/Contact so that a user can nd the right User/Contact and
Chapter 2
67
assign them to a MOM. This way, all these elds need to be made like a search widget where
a Search button appears next to these elds. When a user clicks on the Search button, he/
she will be able to nd the User/Contact, and upon selection, the selected User/Contact will
appear in the eld. As part of this recipe, we will follow through the steps required to convert
each of these elds into a search widget.
Getting ready
Drop the adempiere.c_mom_participantsline table by executing the following SQL:
DROP TABLE adempiere.c_mom_participantsline;
Delete the Fields, Tabs, Window, Columns, and Table entries for the c_mom_
participantsline
table.
How to do it...
1. Create the adempiere.c_mom_participantsline table by executing the
following SQL:
CREATE TABLE adempiere.c_mom_participantsline (
c_mom_participantsline_id numeric(10,0) NOT NULL,
c_mom_id numeric(10,0) NOT NULL,
ad_client_id numeric(10,0) NOT NULL,
ad_org_id numeric(10,0) NOT NULL,
created timestamp without time zone DEFAULT now() NOT NULL,
createdby numeric(10,0) NOT NULL,
updated timestamp without time zone DEFAULT now() NOT NULL,
updatedby numeric(10,0) NOT NULL,
ad_user_id numeric(10),
company character varying(80) NOT NULL,
CONSTRAINT cmom_cparticipantsline FOREIGN KEY (c_mom_id)
REFERENCES adempiere.c_mom (c_mom_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY
DEFERRED,
CONSTRAINT cmom_aduser FOREIGN KEY (ad_user_id)
REFERENCES adempiere.ad_user (ad_user_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY
DEFERRED
);