I am building a 'work_order' table that I need to convert to an invoice once it's been flagged as 'completed'. I need to save all the related models' information also when converting so that I can go back and look at an invoice and see all the related data too, even if the original related data to the 'work_order' table has been changed or deleted.
I'll use the standard blog schema to make it easy. I have a Post model that hasMany Comments, HABTM Tags, and belongsTo User. In the Post table there is a boolean column for 'published'. When the Post is flagged as 'published' I'd like to copy over the data from the Post into a new table for archiving purposes but I also need to copy the Users, Comments and Tags data that are related to that Post to their respective 'archived' tables so that if a User gets changed (i.e. address or phone changes) or deleted from the User table the row of user information is still in the archived table as it was originally. Is there an easy or good way to convert the data to a new table for archives? Going back to the real project tables of using a work_order and invoice: Once a work_order has been flagged as 'completed' on the afterSave maybe create an array with all the related data 'belonging' to Invoice and save it all? If you did it that way how would you save the Invoice from the WorkOrder model since they're not really related? Does anyone have a good practice or suggestions on how it should be done? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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