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 <[email protected]> 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 loooong post. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
