We are looking for a provider to develop a highly flexible and configurable appointment reminder system based on Asterisk IP-PBX. We want design, code and testing of application from the provider for this project.

We would like to run the application in existing system running Asterisk 1.4.24 with FreePBX 2.5.1, CentOS 5.3 and MySQL 5.0.45.

Here are application details;

1. The application would be launched from crontab entry

2. The application would call out using the parameters fetched from database (destination number, message to play and the date and of the appointment)

3. Calls can be made between start time and end time entries in the DB.

4. The start time and end time is based on the Time zone entry in the DB.

5. Before dialing out it should check the channel status, if available then dial if not wait then dial again. Maximum retries and wait time should be configurable in a config file.

6. After call is answered check the answer status, answering machine/voice mail, answered by a person, fax, busy, etc.

7. If answering machine /voice mail leave message with appointment details and call back number

8. If answered by a person, then play the appointment details and provide menu option. There could be 0 to 4 configurable menu options
 a. The menu options will collected from the database including the digit to press, message to play and action to take.
 b. There could be 0 to 5 different available actions.
  i. Send email (email address collected from the DB)
  ii. Transfer the call (destination number collected from the DB)
  iii. Send report end of the day
  iv. Run a script (script info would be collected from the DB)
  v. Play a message (if available in the DB)
 
 c. If fax, hang up
 d. If busy try again, see #4.
 
9. Create a database table everyday with the calls made and the status of the calls. The call log database table should have following;
 a. Date and time
 b. customer id from existing customer table
 c. Number called
 d. Answer status
 e. option chosen (there would be option label in the DB for each option)
 
10. Send a report to each customer based after the last call for the customer is completed.

11. There should be a web based provisioning/GUI with PHP to add, delete and update customer and upload sound files for each customer in the database.

12. Database fields for customer table will be provided.

13. Database fields for the calls will be provided.

14. We are open to suggestions

15. The code should have details comments about each function, variables, parameters, etc. We should be able understand the code.

16. The application need not be integrated with FreePBX.

17. Our system can be used for development and testing. SSH, SFTP access will be provided.
Deliverables:

1. Solution/Design including description and diagrams. Expected after 1 week of assignment.
2. A Test Document to test each functionality and the error/exception conditions. Test Cases should include, preparation required to run the test, how to do the test and expected results. Expected after 1 week of Solution/Design document acceptance
3. Scripts and software to run the application fully tested. Expected after 2 weeks of the acceptance of the Test Document
4. README file with installation details. Along with #3.


Payment Schedule

1. After the acceptance of the Solution/Design Document 20% of total project cost
2. After the acceptance of the Test Document additional 20% of total project cost
3. After the acceptance of the application additional 50% of total project cost
4. Rest 10% would be paid after 1 week of the acceptance of application after bug fixes if any bugs detected in that week.

Please include a brief one paragraph description of the solution you would provide along with the bid. Be specific about the request mentioned above.