Transaction form - How to deal with the complex forms
Transaction form - How to deal with the complex forms

Does anybody worked out in transaction form?
Like Invoice, where we have some information have static and we can add multiple products to the form, and save/update will submit information into multiple table?
Can you please guide me how can I make it possible? or else if is there any example I am having?
Please Advise.
Thanks
Jigs
Like Invoice, where we have some information have static and we can add multiple products to the form, and save/update will submit information into multiple table?
Can you please guide me how can I make it possible? or else if is there any example I am having?
Please Advise.
Thanks
Jigs
This discussion has been closed.
Replies
Is it that a single Ajax request will effect multiple database tables, or that there are multiple ajax requests you want to make with a lock in-between them?
On the former, the DB library layer in the Editor PHP classes does have transaction support, but it is used by the Editor class to create a transaction in whatever action it takes. So it might be that you want to remove the transaction from there ( `$this->_db->transaction();` and the commit at the end ) in the `process()` method and move it into a higher level function.
Regards,
Allan
My Question is regarding the GUI.
I mean is there anybody developed that kind of User Interface ? coding is something we can always handle, but User Interface is requiring the support of adding items (like the products to be invoiced).
or is it something I need not to worry about ?
Thanks
Jigs
Until then, it needs to be single form submission only. Thinking about it possible to group multiple requests using the API - just capture the data to be submitted and batch submit, but I suspect that will be really rather messy!
Regards,
Allan
Thanks for the Updates. :)