Rule Based System to Send SMS
The complicated part is not sending the SMS as most gateways actually have a SMTP Interface to do that
We currenlty work with Clickatell and they have quite an easy way to send SMS, we can forward you all the integration documents that is no problem
The requirement is mainly how to put together the list of clients that we need to send and SMS to and how to have a rule based system that will fire the SMS when the time is right or when the event takes place or simply on demand.
1-If a clients balance reaches 45 days of age, we want to automatically SMS the client telling him Dear Mr X we would like to remind you that you have reached your maximum age, please settle your balance soon. You balance is $450. Thank you THE COMPANY
2-If a clients has an appointment with us tomorrow, then we want to SMS him today saying: Dear Mr X, We would like to confirm the meeting tomorrow at 10:00 am with our representative Hassan. Thank you THE COMPANY
So basically what is needed is a system where we can compile various rules and have the system run on a daily or hourly schedule and fire the SMS accordingly
Below are some of the rules required that I can think of now, maybe they will help in setting the structure of the system. However it has to be built in a way that adding more rules is quite easy. I have no problem in getting any required information from the SQL Database, so that part is not be considered as a difficulty:
[url removed, login to view] client reaches credit limit
[url removed, login to view] client reaches maximum account age
[url removed, login to view] client reaches maximum number of unpaid invoices
[url removed, login to view] certain products are created
[url removed, login to view] certain products reach certain levels or inventory
[url removed, login to view] an order is placed
[url removed, login to view] a competition is over and the winner is announced
[url removed, login to view] on demand meaning I want to tell those people this information (those people is based on a query, this means all the clients that have not made any transaction the past month)
So on, there could be many examples, the system should be able to define a rule, expect and input from it and a set of destination numbers
I am not looking for just a bid, I am looking for someone who fully understands the task and can finish it and give fresh ideas as well because as you can see the requirement is a bit vague and there are many ways to complete the job,
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).