@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 -~----------~----~----~----~------~----~------~--~---
