Language: PHP
Database: MySQL
Framework: Not required
Web Page: Required
Time: 2015/08/07
Plan A: Send customer feedback investigation message by SMS, 1 way
Need implement a PHP interface by HTTP (POST or REST), to trigger the process to send customer feedback investigation by bulk SMS, one time invoke may be trigger to send to one user.
SMS Provider: https://www.twilio.com/docs/quickstart/php/sms
The SMS message includes a URL, to tell user complete the investigation in a website by browser.
The URL should be unique, and once user submit the investigation form then the URL become invalid.
All the investigate result should be saved in MySQL database:
User Table:
1. ID
2. Unique URL (UUID)
3. Status (New, Done)
4. User Phone ID (provided by HTTP invoke)
5. MSG ID (for SMS tracking, depending on SMS provider)
6. Investigation Form Revision (e.g., v1, v2, v3, v4)
7. Investigation ID: (e.g, v2-136476, means form v2 table, ID: 136476)
8. Country (from the Phone Number rule, e.g., 91 means india)
9. Service Recorder (provided by HTTP invoke)
10. Create Time (the record created when HTTP invoked)
11. Feedback Time (user submit the investigate form)
Form Table (multiple: v1, v2, v3, v4)
1. ID
2. Answer for #1 question: A1
3. Answer for #2 question: A2
4. .....
Web Pages:
List all the investigation result with filter (only one form revision select)
-------
List the investigate question of the form revision
-------
Filter: Phone Number, Service Order|
|ID|Phone Number|Status|Update Time|A1|A2|A3|A4|A5|...|
Plan B:
Based on Plan A, but 2 way SMS, it means get customer's feedback by SMS instead of Web form.