Transaction form - How to deal with the complex forms

jigarshah48

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

allan

Hi Jigs,

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

jigarshah48

Thanks Allan for reply.

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

allan

Ah I see what you mean, so you can effectively submit multiple forms at the same time? Currently no, this is not possible in Editor - it is single form instance only at this time. The plan is around Editor 1.4 to add the ability to nest multiple forms, so it will be possible at that time, but that is likely to be early Q2 2013 before it is fully implemented I'm afraid.

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

jigarshah48

Gr8

Thanks for the Updates. :)