Sedang Disiapkan

CRUD grid with variable number of columns

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.

Kemahiran: AJAX, J2EE, Java, JSP, Ruby on Rails

Lihat lebih lanjut: crud grid, crud jsp, editable grid, jsp crud, jsp crud example, sql variable number columns, crud jsf, number grid columns, ajax jsp crud, display crud jsp, php grid crud, php crud grid, table crud requirements, jsp grid ajax, crud number, crud operations java ajax, crud grid java, jsp grid, crud grid jsp framework, editable grid layout jsp, example jsf grid crud, crud table jsf, jsf table variable columns, jsf crud, variable column number jsf

Tentang Majikan:
( 1 ulasan ) Jacksonville, United States

ID Projek: #270283

Dianugerahkan kepada:

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 Lagi

$250 USD dalam 30 hari
(0 Ulasan)
0.0

5 pekerja bebas membida secara purata $240 untuk pekerjaan ini

Samskriti

I can take this

$250 USD dalam 20 hari
(0 Ulasan)
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 dalam 30 hari
(0 Ulasan)
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 dalam 90 hari
(0 Ulasan)
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 Lagi

$250 USD dalam 45 hari
(0 Ulasan)
0.0