Project Detail

Description

SmartClient.com demoApp changes – AJAX, Aptana, Java
------------------------------------------------------------------------------
Extend or change SmartClient.com Office Supply Showcase Application (demoApp) from Isomorphic to make SQL calls for changes performed on the grids by substituting dynamic data source.
Definition of SQL database with test data is attached.
Location:
Download from smartclient.com contains SmartClient_65_LGPLsmartclientSDKisomorphicsystemreferenceinlineExamplesdemoApp for the LGPL licensed code. Aptana Studio from aptana.com is recommended for development environment.

1. Changes performed in all four panes create changes in SQL database tables.
"fetch", "update", "add" and "remove" operations are to be supported in Categories (table USER1NAMEL), Items (table USER1VIEWT) and View/Edit (row in table USER1VIEWT) panes.

2. Adding a column to Items grid will add an editable column in table USER1VIEWT.

3. Adding a column to Items grid will add an editable element in the grid and editable field in Edit pane.

4. Grid cells may have list of values - there may be multiple values in one cell. They can be presented on separate lines or any other way.
Editor for such cell should allow edit of all values, including "update" of each, "add" new value and "remove" the whole value.
Help: listGridField.formatCellValue() is one place to define a formatter that combines multiple values from a record.

5. Rows of data may have different heights set by auto-sizing, so all multiple values in cells are displayed.
Help: fixedRecordHeights:false plus wrapCells:false enables auto-sizing to content
6. Find Button needs to operate on all columns currently displayed in the grid. Item listbox is to contain list of columns of the grid (table USER1COLL).

7. Make Categories pane to contain a tree with two columns (loaded by table USER1NAMEL). Make Instructions pane to contain exact replica of Categories pane and name it Views (loaded by table USER1VIEWL).
Categories pane and Views pane should display right-hand click menu as in Items pane and support the same update operations on Categories pane and Views pane data.
Categories tree pane has to have a first column loaded with column KNAME in table USER1NAMEL definition.
Categories tree pane has to have a second column loaded with column TYPE in table USER1NAMEL definition.

8. Clicking on a different Category will display a grid with an appropriate (different) number of columns related to that Category from table USER1VIEWT in pane Items.

9. Add Login screen and security code in Java and SQL database as needed for multi-user access.
Help: Use existing SmartClient's Login screens.

10. For delivery, zip the whole development directory(ies), so once unzipped, all functions work on development server.

11. Provide full development environment setup instructions.

12. Provide full deployment instructions.


The main objective of this project is to have Items pane display different number of editable columns depending on chosen Category. If you need different or additional tables, please feel free to make appropriate changes.
Overall help from Isomorphic regarding dynamic columns creation:
DataSources can be dynamically generated.

http://www.smartclient.com/docs/6.5/a/b/c/go.html#group..dataSourceDeclaration

You can use a DataSource whose records are DataSource fields to get the fields dynamically, similar to the last example from DataSource.fetchData() which shows generating a DynamicForm from DataSource records:

http://www.smartclient.com/docs/6.5/a/b/c/go.html#method..DataSource.fetchData

isc.DataSource.get("myFormFields").fetchData(null,
"isc.DynamicForm.create({ items:data })"
)

From then on, everything works identically to how things work if the DataSource had not been dynamically generated. So the code for the Showcase Application would work unchanged with a dynamically created DataSource.


----------------------------------------------------------
-----------Second part of the project---------------------
----------------------------------------------------------
Once the above defined code is tested and working, provide a separate, second version of the project additionally making server-side Java calls. This modification should be just insertion of additional Java calls in existing code base defined above, so the changes performed in all four panes create changes in Java vectors content. If this part of the project is too hard to achieve, please provide technical reasons.
Definition of Java data structures with loaded test data is attached.
Vector "Name" contains list of names to be displayed in the Categories pane.
Vector "View" contains list of names to be displayed in the Views pane.
Vector "ViewCol" contains list of columns to be displayed in the Items grid (grid column headers values are given in Vector "ViewCol").
Vector "table" contains data to be displayed in the Items grid.

Clicking on a different Category will display a grid with an appropriate (different) number of columns related to that Category from Vector "table" in Items pane. Adding a column to Items grid will add editable elements to Vector "table".






Additional files submitted:
SmartClient.com demoApp changes – AJAX, Aptana, Java.rtf
smartclient.pdf
avector_java.rtf
database_SQL.rtf