The web tool must allow our agents to insert data and to search for existing records. The home page presents 3 buttons/link:
1) order form
2) receipt form
The order form and the receipt form area pages with data entry forms (data entry text fields and/or dropdown selection menus). Some of those fields might have default entries using simple math formulas (i.e. sum/substraction/moltiplication of two or more fields), while some fields need to be checked for validity.
Data entry might include questions and/or db searches. An example? Is this a new entry? If NO there should be a db call to insert precompiled data.
For each inserted order there should be an editable field (a flag) accessibile only by Admin users (state of delivery check). After data entry is complete emails should be sent to a list of adresses.
The third link (Other), leads to a second menu with all other options:
* Client list (own) -> on click the user accesses all the orders realted to that client
* Orders list (own) -> can be ordered by status, date, client name
* Client status alert (usage, etc.)
Download to excel, too.
The interface page is simple (top to bottom):
- content area --> portlet1, portlet2, etc.
The chosen architecture is Portal type.
The Liferay 5.2.x product seems to us the best open-source tool, being scalable and offering lots of useful functions. A portal allows rapid development and an automatic reuse of authentication, themes and graphics. Portlet development allows the developer to concentrate on the service leaving out all graphical aspects, while the authentication and db connections are managed directly by portal.
Liferay is application server java based, we chose Tomcat 6.0.
The database chosen is MySQL 5.x.
All apps are to be developed as Java/j2ee portlets in JSR268 standard.
We advise the usage of Netbeans 6.7 with portal pack 3.1, and liferay support.
Delivery shall be done on SVN of SMS Italia, more details available at contract sign.
More details via PM.