Hi,
Trying to work out the correct way of doing this.
My database has an Events table, and several other tables for different
event types (Event_Transactions, Event_Comments etc).
The basic idea is that everything is an event, and the type of event
dictates the table it joins to.
As such, Event hasOne Event* (joined on the fly depending on usage).
I want to be able to save multiple events on one form... in this case,
multiple transactions...
So, I have laid out my form as such:
echo $this->Form->create('Event', array('url' => array('controller' =>
'transactions', 'action' => 'deposit')));
echo $this->Form->hidden('Event.0.event_type_id', array('value' => 2));
echo $this->Form->Select('EventTransaction.0.inventory_type_id',
$InventoryTypes);
echo $this->Form->Input('EventTransaction.0.amount');
echo $this->Form->end('Submit');
Javascript will be employed to add more fields, but you get the idea (second
transaction will be Event.1.event_type_id and so forth)
If i do a saveAll($this->data['event']); the resulting SQL is
10START TRANSACTION
0
0 11INSERT INTO `events` (`event_type_id`, `created`) VALUES (2, '2011-08-21
01:23:14')
1
0 12SELECT LAST_INSERT_ID() AS insertID
110 13COMMIT
No mention of the EventTransaction. Same happens with plain old
saveAll($this->data);
If i remove the multi-row save stuff, and submit the form, the correct
related information is saved.
Have I missed something here? is my form structure right?
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
