SmartClient.com demoApp changes with AJAX, Aptana, Java

Extend or change [login to view URL] Office Supply Showcase Application (demoApp) from Isomorphic to make SQL calls for changes performed on the grids by substituting dynamic data source. The objective of the project is to create one page editor for multiple tables. Each table has different (number of) columns. Charles Kendrick, Isomorphic Director, Technical Sales says it can be rather easily done with dynamic datasources in [login to view URL] showcase application. Definition of SQL database with test data is attached. Recommended is MySQL for database. Location: Download from [login to view URL] contains SmartClient_65_LGPL\smartclientSDK\isomorphic\system\reference\inlineExamples\demoApp for the LGPL licensed code. Aptana Studio from [login to view URL] is recommended for development environment. ## Deliverables [login to view URL] demoApp changes with AJAX, Aptana, Java ---------------------------------------------------------------------------------- Extend or change [login to view URL] Office Supply Showcase Application (demoApp) from Isomorphic to make SQL calls for changes performed on the grids by substituting dynamic data source. The objective of the project is to create one page editor for multiple tables. Each table has different (number of) columns. Charles Kendrick, Isomorphic Director, Technical Sales says it can be rather easily done with dynamic datasources in [login to view URL] showcase application. Definition of SQL database with test data is attached. Recommended is MySQL for database. Location: Download from [login to view URL] contains SmartClient_65_LGPL\smartclientSDK\isomorphic\system\reference\inlineExamples\demoApp for the LGPL licensed code. Aptana Studio from [login to view URL] 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: [login to view URL]() 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. ? ? ? [[login to view URL]][1] You can use a DataSource whose records are DataSource fields to get the fields dynamically, similar to the last example from [login to view URL]() which shows generating a DynamicForm from DataSource records: ? ? ? [[login to view URL]][2] ? ? ? ? ? [login to view URL]("myFormFields").fetchData(null, ? ? ? ? ? ? ? "[login to view URL]({ 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". ? ? ? * * *This broadcast message was sent to all bidders on Sunday Jan 25, 2009 6:57:47 PM: Hi: Please send me some details. Be specific, especially about smartclient.com. I will make my choice on February 1, 2009. Thank you, Alex