Notification to the specific user feature

[Nilesh_2]

Hello there,
For my project, I want to add notification feature where one user can send request for something and other user views by clicking button or something like that as a notification/alert similar to friend request in facebook. I dont know how to implement this feature.
Thanks in advance.

[diafol]

Is this like a Private Message (PM) system?

[Nilesh_2]

Not sure but may be yes,
Like one user send request to other(not to all) user. Other user receive that request as a notification.
Thanks

[JorgeM]

So yes it does sound like you are asking about some type of private messaging systems.

You indicated "I dont know how to implement this feature.". What help are you looking for? What have you tried?

[Nilesh_2]

I am looking for the suggestion that how to implement this feature.
Any hint or code that can help me prepare this feature.?

[diafol]

THe first thing to get right is the DB table(s). I'll give you my ideas...

PM

pm_id [PK]
sender_id [FK]
receiver_id [FK]
root_id [self-relating] - parent pm_id - so you can create "threads"
reply_to [self-relating] - pm_id being replied to so can be ordered other than by senttime alone
senttime
sender_status [FK integers for read | unread | deleted]
receiver_status [FK integers for read | unread | deleted]

PM_STATUS

status_id
pm_status

That should get you started. The rest is just simple DB calls, create a couple of forms and some views (list and message).