Hello, Community!
I have tested some jQuery plugins to generate table that support CRUD. Here's my review of them.
Excellent plugin, but has annoying limitations like horizontal scrolling, which does not exist. If you have a table with many fields, the div where the table is created adds scrolling-x, but the table header and footer roll together with the body. It has an auto filter plugin, but not with select boxes. The grid is generated using JSON. This is great because the fields in the form of adding and adding data to the server use the fields returned to generate each input, select, or textarea. As you use jQuery UI, we only need to pass the data types of each field and the formatting is automatic. It is not compatible with Bootstrap. Some points of conflict are the manners and forms, which is serious. You can treat actions independently. For example, I needed to include all fields in a DB, but I could only change a few once included. The plugin allows you to do this and does not disable the fields that can not be edited, preserving them in the inclusion form.
It has great potential, but the documentation is awful, really bad. It is compatible with Bootstrap and jQuery UI (native). It allows actions to be handled independently as well, but it is a bit more complicated, because of the positioning of each item (first it has to be the update, then the insert, then the delete, etc, and then you change the order by carelessness), if at least the documentation helped. You can do everything perfectly, but you do not have the auto filter. On the server side, you just need to generate the same JSON and that's it. Paging and ordering results the client side takes care of. I liked it a lot, but since it is not intuitive and the documentation does not help, it was almost impossible to treat CRUD actions separately. Everything involves functions, so your code gets huge for a table ... I mean, too big for anything, if you need something complete.
Very good too, but everything is server side practically and it is complicated to treat insert and update separately. It has an auto filter mode, but it does involve the server side. I did not like that. The codes for generating the complete table are large, and each step involves a query pretty much, so it gets scalable. It has a lot of server side work, but the result is good. Compatible with Bootstrap and jQuery UI.
Excellent plugin too. I think it should be the best to some extent. It allows inline editing and treats the insert and update separately, but this does not have a "native" insert form, you have to generate it in the same hand. That's the only problem: the form of data inclusion. Otherwise, everything from the client side to the export to Excel can be done from the client side, PDF and image as well. You can do a self filter manually including the forms of the fields that will be searched in the table, but the search is on the client side. Almost perfect!
NOW I CHORUS
I need a plugin that manages the table in an easy way and forms as well, but which allows for independent update and insert handling. I need to include auto filters and subtotal and sum. Does anyone know if this miracle exists? Or how can I use these plugins to generate a full CRUD, but with the specs I've passed?