I need a system that have the capacity to do the following.
1. Receive Messages sent from users to a central Specified Number.
2. Save the messages in a database.
3. Filter the messages according to Keywords which maps to County departments. E.g Water, Sanitary, Roads, Security etc
4. After grouping the messages into those department, the departmental help desk logs in and assigns the messages as aticket to the person and/or engineer who is to resolve and a message is sent back to the sender that the issue is being looked into.
5. After the department resolves the issue and is closed all those who sent an issue with the same problem gets a notification that its now resolved.