Two common options are.
A)
1. Create a notification table
2. Create afterinsert,afterupdate and afterdelete mysql triggers for all the tables you need notification for.
3. Those triggers will insert rows to notifications table.
4. Show notification table in admin dashboard.
Not all host services support mysql triggers, consider using aftersave and afterdelete callbacks.
B)Create a union view in mysql using modified value to get the recent changes, show the view in admin dashboard.
In this case you need extra steps to mark notifications the admin already read.
Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.A)
1. Create a notification table
2. Create afterinsert,afterupdate and afterdelete mysql triggers for all the tables you need notification for.
3. Those triggers will insert rows to notifications table.
4. Show notification table in admin dashboard.
Not all host services support mysql triggers, consider using aftersave and afterdelete callbacks.
B)Create a union view in mysql using modified value to get the recent changes, show the view in admin dashboard.
In this case you need extra steps to mark notifications the admin already read.
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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
No comments:
Post a Comment