Project Detail

Description

SmartClient.com Showcase Application dynamic columns

==========================================



Extend SmartClient.com Office Supply Showcase Application (demoApp) from Isomorphic to make server-side Java calls and at the same time SQL calls for changes performed on the grid.

Location: SmartClient_65_LGPLsmartclientSDKisomorphicsystemreferenceinlineExamplesdemoApp for the LGPL licensed code.

Definitions of Java data structures and SQL database with loaded test data are attached.

1. Changes performed in all three panes create changes in Java vectors content and SQL database tables.
"fetch", "update", "add" and "remove" operations are to be supported in Categories, Items and View/Edit panes.

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


3. 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.



4. 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


5. Find Button needs to operate on all columns currently displayed in the grid (Item listbox is to contain list of columns of the grid).

6. Make Instructions pane to contain exact replica of Categories pane (with two columns) and name it Views. See p.8 for column mappings.
Categories pane and Views pane should display right-hand click menu as in Items pane and support the same
operations on Categories pane and Views pane data.



7. Add Login screen and security code in Java and SQL database as needed for multi-user access.

Help: Use existing SmartClient's Login screens.



Java code description
---------------------
8. Categories Tree pane has to have a second column loaded with first element (same as TYPE in SQL table definition) data from "Name" Vector.
Second element (same as KNAME in SQL table definition) is displayed in first column as the name of the Category.

9. Vector "Name" contains list of names to be displayed in the Categories pane.
Vector "ViewCol" contains list of columns to be displayed in the grid.
Grid column headers values are given in Vector "ViewCol".
Vector "table" contains rows of data to be displayed in the grid.
Vector "View" contains list of names to be displayed in the Views pane.

10. Clicking on a different Category will display a grid with an appropriate (different) number of columns
related to that Category in "Name" Vector.

11. Adding a column to grid will add an editable elements to Vector "table".


SQL code description
--------------------
12. Changes in Vector "Name" are to be stored in server-side database table USER1NAMEL.
Changes in Vector "ViewCol" are to be stored in server-side database table USER1COLL.
Changes in Vector "table" are to be stored in server-side database table USER1VIEWT.
Changes in Vector "View" are to be stored in server-side database table USER1VIEWL.

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


14. 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 field 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 works if the DataSource had not been
dynamically generated. So the code for the Showcase Application would work unchanged with a
dynamically created DataSource.


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



16. Provide setup instructions.



17. Provide deployment instructions.







Additional files submitted:
avector_java.rtf
database_SQL.rtf
screenshot.rtf
SmartClient_com_demoApp_dynamic_columns.rtf