very helpful geoff, as you can see this is clearly not the case as i have tried to do this myself and have spent alot of time trying to figure it out, all i need is to know the way that i should do this in cake, at least i will know in theory what i need to do and then just try to implement it. if you dont want to help in this way i wonder what you are doing here
On Aug 2, 1:12 pm, Geoff Ford <[EMAIL PROTECTED]> wrote: > @francky I know what he is trying to achieve - rtanz is trying to get > us poor helpful bakers to write his entire application for him. :-P > > Geoff Ford > --http://lemoncake.wordpress.com > > On Aug 2, 7:58 pm, rtanz <[EMAIL PROTECTED]> wrote: > > > hi franck tnx what i am trying to achieve is that when a new > > membership record is created a new tasklist record must be created. > > That is why i used the aftersave, but as you pointed out this will run > > after an update too, so its not really ideal, how should i do this > > instead? handling the membership_id in the function where i save is a > > good idea but this ties in with the previous point i.e. im not sure > > how i should go about implementing this functionality. any futher help > > would be appreciated thnx > > > On Aug 2, 6:21 am, francky06l <[EMAIL PROTECTED]> wrote: > > > > well, I am a bit lost. I do not know what you want to achieve. Just > > > few comments : > > > > - in your finddata() you should try to use the Cake convention with > > > findAll > > > - afterSave() will be called also when you update data, it does not > > > seems to be the right place to handle the inserted Id. > > > - Why not handling the membership_id in the function where you > > > actually call save() ? > > > > Again, I do not know what you want to achieve, but the overall > > > approach seems weird regarding the code posted here. > > > > On Aug 2, 12:16 am, rtanz <[EMAIL PROTECTED]> wrote: > > > > > thanks so i reviewed my code, the remaining problems are: > > > > 1. $membership_id is not being passed correctly > > > > 2. im not sure how to save the returned arrays into tasklist records > > > > any help on this? thanks > > > > > <?php > > > > > class Membership extends AppModel > > > > { > > > > var $name = 'Membership'; > > > > var $belongsTo = array('Module','Role','User'); > > > > > function afterSave() { > > > > $membership_id = $this->getLastInsertId(); > > > > //$membership_id = 1; //getlastid > > > > $this->requestAction('tasklists/add/$membership_id'); > > > > return true; > > > > } > > > > > } > > > > > ?> > > > > > Tasklist controller: > > > > > function add($membership_id) { > > > > $tasklists = $this->Tasklist->finddata($membership_id); > > > > $this->set('tasklists',$tasklists); > > > > > } > > > > > class Tasklist extends AppModel > > > > { > > > > var $name = 'Tasklist'; > > > > var $belongsTo = array('Module','Task','User'); > > > > > function finddata($membership_id) { > > > > > return $this->query("SELECT > > > > `memberships`.`module_id`,`memberships`.`user_id`, `tasks`.`id`as > > > > task_id > > > > FROM > > > > `memberships` , `tasks` > > > > WHERE > > > > `tasks`.`role_id` = `memberships`.`role_id` AND > > > > `memberships`.`id`=$membership_id"); > > > > // debug($ret); > > > > > return $ret; > > > > } > > > > > } > > > > > ?> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
