Rule based system to send SMS

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. Example: 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: [login to view URL] client reaches credit limit [login to view URL] client reaches maximum account age [login to view URL] client reaches maximum number of unpaid invoices [login to view URL] certain products are created [login to view URL] certain products reach certain levels or inventory [login to view URL] an order is placed [login to view URL] a competition is over and the winner is announced [login to view URL] 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, Smiles Tony ## Deliverables 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). ## Platform Windows