Re: Help with Multiple Models + Single View required
Then I would loop over the incoming data inside your controller method, create Jobs models out of them and pass the array of new Jobs models to saveAll() . Never have done this before but this is what I would try :) On Sat, Oct 3, 2009 at 7:57 AM, ashok.b wrote: > > I have a view (Linked to Messages Model, Table 1), which: > 1. Displays a Message (From Table1) > 2. Select a single/multiple Account/es (List generated from Table2) > 3. Select a single/multiple Batch/es (List generated from Table3) > 4. Take input date & time > > My problem is, upon clicking submit, the data should go into another > model, Jobs (Table4) with multiple entries just like how it happens in > an hasAndBelongsToMany relation... > > On Oct 2, 4:21 pm, Bert Van den Brande wrote: > > My idea is ... that's a lot of text ! > > > > Ok j/k, what exactly are you asking for ? > > > > On Thu, Oct 1, 2009 at 9:28 PM, ashok.b wrote: > > > > > Hi everyone, I'm new to this group and to cakephp. I'm enjoying > > > writing code with cakephp, and most of times I'm getting help from the > > > bakery, community and googling. But am at a roadblock now, and seems > > > like I can't find what I am looking for. My problem is as follows: > > > > > Table1: tbl_messages > > > id - integer - Auto Increment Primary Key > > > msg - varchar - A text message > > > > > Table2: tbl_accounts > > > id - integer - Auto Increment Primary Key > > > username - varchar - User Name of the Account > > > userpass - varchar - Password for the Account > > > > > Table3: tbl_batches > > > id - integer - Auto Increment Primary Key > > > bname - varchar - Name of the Batch > > > bdesc - varchar - Description of the Batch > > > > > Table4: tbl_jobs > > > id - integer - Auto Increment Primary Key > > > tbl_messages_id - integer - Foreign key referring to tbl_messages > > > tbl_accounts_id - integer - Foreign key referring to tbl_accounts > > > tbl_batches_id - integer - Foreign key referring to tbl_jobs > > > schedtime - datetime - Date Time when to send the message > > > > > The table4 contains details of jobs which will be executed using cron > > > job. My problem now is to create a single view, which will: > > > > > 1. Display a Message > > > 2. Select a single/multiple Account/es > > > 3. Select a single/multiple Batch/es > > > 4. Take input date & time > > > > > On clicking submit, > > > Multiple entries to be inserted in tbl_jobs, depending on number of > > > items selected in Accounts & Batches (i.e. if 2 accounts, 2 batches > > > are selected, 4 entries to be made into tbl_jobs with values > > > (x,msgid,accid1,batchid1,datetime) > > > (x,msgid,accid1,batchid1,datetime) > > > (x,msgid,accid2,batchid2,datetime) > > > (x,msgid,accid2,batchid2,datetime) > > > > > The view is achieved using the Messages Model. But from there, data > > > from the form should be sent to Job Model which should insert in above > > > format. > > > > > Any ideas please... Thanks for patiently reading the lng post. > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Help with Multiple Models + Single View required
I have a view (Linked to Messages Model, Table 1), which: 1. Displays a Message (From Table1) 2. Select a single/multiple Account/es (List generated from Table2) 3. Select a single/multiple Batch/es (List generated from Table3) 4. Take input date & time My problem is, upon clicking submit, the data should go into another model, Jobs (Table4) with multiple entries just like how it happens in an hasAndBelongsToMany relation... On Oct 2, 4:21 pm, Bert Van den Brande wrote: > My idea is ... that's a lot of text ! > > Ok j/k, what exactly are you asking for ? > > On Thu, Oct 1, 2009 at 9:28 PM, ashok.b wrote: > > > Hi everyone, I'm new to this group and to cakephp. I'm enjoying > > writing code with cakephp, and most of times I'm getting help from the > > bakery, community and googling. But am at a roadblock now, and seems > > like I can't find what I am looking for. My problem is as follows: > > > Table1: tbl_messages > > id - integer - Auto Increment Primary Key > > msg - varchar - A text message > > > Table2: tbl_accounts > > id - integer - Auto Increment Primary Key > > username - varchar - User Name of the Account > > userpass - varchar - Password for the Account > > > Table3: tbl_batches > > id - integer - Auto Increment Primary Key > > bname - varchar - Name of the Batch > > bdesc - varchar - Description of the Batch > > > Table4: tbl_jobs > > id - integer - Auto Increment Primary Key > > tbl_messages_id - integer - Foreign key referring to tbl_messages > > tbl_accounts_id - integer - Foreign key referring to tbl_accounts > > tbl_batches_id - integer - Foreign key referring to tbl_jobs > > schedtime - datetime - Date Time when to send the message > > > The table4 contains details of jobs which will be executed using cron > > job. My problem now is to create a single view, which will: > > > 1. Display a Message > > 2. Select a single/multiple Account/es > > 3. Select a single/multiple Batch/es > > 4. Take input date & time > > > On clicking submit, > > Multiple entries to be inserted in tbl_jobs, depending on number of > > items selected in Accounts & Batches (i.e. if 2 accounts, 2 batches > > are selected, 4 entries to be made into tbl_jobs with values > > (x,msgid,accid1,batchid1,datetime) > > (x,msgid,accid1,batchid1,datetime) > > (x,msgid,accid2,batchid2,datetime) > > (x,msgid,accid2,batchid2,datetime) > > > The view is achieved using the Messages Model. But from there, data > > from the form should be sent to Job Model which should insert in above > > format. > > > Any ideas please... Thanks for patiently reading the lng post. > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Help with Multiple Models + Single View required
My idea is ... that's a lot of text ! Ok j/k, what exactly are you asking for ? On Thu, Oct 1, 2009 at 9:28 PM, ashok.b wrote: > > Hi everyone, I'm new to this group and to cakephp. I'm enjoying > writing code with cakephp, and most of times I'm getting help from the > bakery, community and googling. But am at a roadblock now, and seems > like I can't find what I am looking for. My problem is as follows: > > Table1: tbl_messages > id - integer - Auto Increment Primary Key > msg - varchar - A text message > > Table2: tbl_accounts > id - integer - Auto Increment Primary Key > username - varchar - User Name of the Account > userpass - varchar - Password for the Account > > Table3: tbl_batches > id - integer - Auto Increment Primary Key > bname - varchar - Name of the Batch > bdesc - varchar - Description of the Batch > > Table4: tbl_jobs > id - integer - Auto Increment Primary Key > tbl_messages_id - integer - Foreign key referring to tbl_messages > tbl_accounts_id - integer - Foreign key referring to tbl_accounts > tbl_batches_id - integer - Foreign key referring to tbl_jobs > schedtime - datetime - Date Time when to send the message > > The table4 contains details of jobs which will be executed using cron > job. My problem now is to create a single view, which will: > > 1. Display a Message > 2. Select a single/multiple Account/es > 3. Select a single/multiple Batch/es > 4. Take input date & time > > On clicking submit, > Multiple entries to be inserted in tbl_jobs, depending on number of > items selected in Accounts & Batches (i.e. if 2 accounts, 2 batches > are selected, 4 entries to be made into tbl_jobs with values > (x,msgid,accid1,batchid1,datetime) > (x,msgid,accid1,batchid1,datetime) > (x,msgid,accid2,batchid2,datetime) > (x,msgid,accid2,batchid2,datetime) > > The view is achieved using the Messages Model. But from there, data > from the form should be sent to Job Model which should insert in above > format. > > Any ideas please... Thanks for patiently reading the lng post. > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Help with Multiple Models + Single View required
Hi everyone, I'm new to this group and to cakephp. I'm enjoying writing code with cakephp, and most of times I'm getting help from the bakery, community and googling. But am at a roadblock now, and seems like I can't find what I am looking for. My problem is as follows: Table1: tbl_messages id - integer - Auto Increment Primary Key msg - varchar - A text message Table2: tbl_accounts id - integer - Auto Increment Primary Key username - varchar - User Name of the Account userpass - varchar - Password for the Account Table3: tbl_batches id - integer - Auto Increment Primary Key bname - varchar - Name of the Batch bdesc - varchar - Description of the Batch Table4: tbl_jobs id - integer - Auto Increment Primary Key tbl_messages_id - integer - Foreign key referring to tbl_messages tbl_accounts_id - integer - Foreign key referring to tbl_accounts tbl_batches_id - integer - Foreign key referring to tbl_jobs schedtime - datetime - Date Time when to send the message The table4 contains details of jobs which will be executed using cron job. My problem now is to create a single view, which will: 1. Display a Message 2. Select a single/multiple Account/es 3. Select a single/multiple Batch/es 4. Take input date & time On clicking submit, Multiple entries to be inserted in tbl_jobs, depending on number of items selected in Accounts & Batches (i.e. if 2 accounts, 2 batches are selected, 4 entries to be made into tbl_jobs with values (x,msgid,accid1,batchid1,datetime) (x,msgid,accid1,batchid1,datetime) (x,msgid,accid2,batchid2,datetime) (x,msgid,accid2,batchid2,datetime) The view is achieved using the Messages Model. But from there, data from the form should be sent to Job Model which should insert in above format. Any ideas please... Thanks for patiently reading the lng post. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---