CRUD grid with variable number of columns

進行中 投稿 Jun 7, 2008 着払い
進行中 着払い

CRUD grid with variable number of columns

It has to be a web based application delivering results to web browser.

It is simple editable (CRUD) grid or spreadsheet interface for displaying text (or hyperlink) table content.

Input may be an SQL table(s) or code has to have link to Java object with vectors for main table, headers vector and so on.

Every page request or just partial (AJAX is OK, but may be optional) refresh from same user will return a page with:

1. **Most important** with a number of columns different than the previous page

2. fully editable table with CRUD operations

3. preferably: editing of dates (with popup calendar), text, and/or other types of columns

4. pageable

5. cacheable

6. sortable columns

7. filter for each column values

8. cells may have list of values - multiple values in one cell - there can be multiple entries of values in single cell. In one cell you may have multiple entries, Something similar to Excel's multi-line cell. For example:

Porter,

Maxim,

Barb,

Joe,

Ryan.

These entries are usually presented in a vertical layout, but it is up to implementation how they may be presented. Some grids implement it as entries visually separated in one or multiple lines.

9. main table column headers values will be given as another table

10. remembers resizing, sort and so on, of rows/columns

11. user will sign on and will have different data displayed

12. there can be multiple entries of values in single cell

The server may be implemented as connecting to a single database. In real system each user will have access to his/her own table(s). My plan is to have one database per user to enforce security.

Currently there is no requirement for blobs. But if you can handle them - better for you (and me).

Sample database data for Pointbase is enclosed in the zip file submitted with the original request. The script is in SQL, can be easily reformatted to any other database system.

The requirements are in priority sequence.

Working demo is preferable for evaluation. What programming IDE would have to be used for debugging?

Please look into attached zip file:

A. Folder “avisual” contains further guidance in form of [url removed, login to view] files and:

1. sample application setup for Java object to be CRUD (folder “avector”) or

2. existing open source code from Sun that does CRUD, but for fixed number of columns. The closest working code was in [url removed, login to view] from Sun in JSF (folder “create signon1 database” with table create statements for the test setup in subfolders for “derby” database and “pointbase” database)

B. File “Pictures of possible [url removed, login to view]” contains screenshots of the old application that can perform CRUD only on the local computer. Your task is to perform what the old application could do, but in the browser, on-line, at the remote server.

I have seen something similar in openrecord.org. [url removed, login to view] should be able to do it. Ruby on Rails is interesting. Django is OK. AJAX is desirable. It can be simple JSP with Spring MVC or Echo3 or ZK framework. Other possibilities: BigTable, GFS or many others.

Recommended:

• Java

• Javascript

• JScript

• Java Server Pages (JSP)

• Ruby

• XML / XHTML

• XML/XSL

Supports:

• IE 7.0

• Firefox 2.0-2.x

Please review more precise descriptions, especially the attached ZIP file with further, hopefully better, descriptions.

I'm totally open to any solution as long as the code is in Java, JSF, JSP or similar. I do not accept PHP, ASP nor .Net solutions. The solution that I came across is shown in attached [url removed, login to view] from Sun in JSF. The strongest additional requirement is variable number of columns for each page refresh. The best way to start further conversation is to show me screenshots of solution or website with working solution.

Additional information:

1. Derby does not support Java code in triggers. Can Firebird call Java code in trigger? My internal database is proprietary, so when a table column value changes in the grid, another Java routine has to be called to perform an update on my proprietary database.

Otherwise, your code must provide me with some exit (place to call my code) for each Insert, Update, Delete of a value in a grid's cell.

2. I would be interested in activescaffold only if it can provide a generic solution – my problem is that on every page request there is a different number of columns to be displayed and their names are different from previous request. Hardcoding is impossible.

3. If you can display another table rows in the drop-down – I will take it. All rows of the main table are to display the same drop-down content, since that content is related to the column header, not the row. The ideal solution would be to be able display this drop-down with multi-columns. So, basically, the drop-down should visually display another grid, which content can be assigned from another table.

4. It is to be about one web page coding.

I would pay for all solutions that are acceptable. There are possible multiple solutions that have enough merit to be a basis for further development. If I accept your solution, by requesting the source code, I will pay for it. It is not the bid amount, but value of the code that will decide.

I estimate one to two months for completion.

We need milestones, though. Please let me know at least the toolset and expected screen design as soon as possible.

AJAX J2EE Java JSP Ruby on Rails

プロジェクトID: #270283

プロジェクトについて

5個の提案 リモートプロジェクト アクティブ Jun 14, 2008

アワード:

oddaniel

I am a J2EE Developer with experience designing and implementing applications using AJAX, HTML, Jsps, Servlets, Spring framework, Struts2.0, EJB3, Hibernate etc. I am interested in providing the required service for th もっと

$250 USD 30日以内
(0レビュー)
0.0

5人のフリーランサーが、平均$240 で、この仕事に入札しています。

Samskriti

I can take this

$250 USD 20日以内
(0件のレビュー)
0.0
smartcomponents

I have developed an AJAX/Java framework during the last 6 months to develop CRUD/web-based applications. I think it fits very nicely with your requirement.

$250 USD 30日以内
(0件のレビュー)
0.0
adept123

i found this task very interesting i have enough experience with JSF,Ajax for Jsf and JPA let me do some home work and will get back to you with demo then we can proceed further.

$200 USD 90日以内
(0件のレビュー)
0.0
fljasp

The application's objective is data mgmt or perhaps for data entry I suppose. If im correct this application has to provide its user a hassle free and an easy way to manage and work on large amt of data. I belive i ca もっと

$250 USD 45日以内
(0件のレビュー)
0.0