Færdiggjort

Customer feedback investigation by SMSBuild a Website

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: [url removed, login to view]

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.

This is additional inform to help freelancer to understand the requirement more clearly.

Actually, this requirement is a part for a large project, a CRM/SCM system. I want this requirement to be an independent module of the project. So in other module (e.g., a routine process) will invoke the PHP interface (URL) with the necessary parameters (e.g., phone number, msg body, schedule, form reversion, etc). So no need to think when to invoke the interface to send the SMS.

Emphasis: SMS Provider is specified: https://www.twilio.com/docs/quickstart/php/sms

About the customer feedback investigation form: the content of the feedback investigation is not fixed. So my idea is to add an additional web page: to create more than one feedback form, e.g., form_v1, form_v2, form_v3, When I invoke the PHP interface I can specify the feedback form version.

Another goal is to avoid the abuse of the URL in the SMS because it might make the investigate result not real. So my idea is that every customer get the SMS, and it includes a unique URL(UUID). After user complete the investigate form and click the submit button, the URL can't be reopen again, a warning message "Invalid URL" pop up.

List the interfaces and examples:

1. Function: send SMS message
Example: http://mydomain.com/sendSMS?phonenum=91238433766&ServiceRecordID=2348473663923&sendSchedule=LocalTime&FeedbackForm=v2
Return: 0 Success or 1 Fail with the failure message

This interface is to send a SMS message to the PhoneNumber. The SMS message include a unique URL generated automatically, all the info save into the database "User Table". Please note : when end user get the SMS and click the URL, the corresponding feedback form (v2 for the example above) show to user. The unique URL became invalid when when complete the feedback form and click the "submit" button.

2. Function: List the existing Feedback form
Example: http://mydomain.com/listFeedbackForm

This interface is to list all the feedback form available. A "New Form" button is used to add new form.

3. Function: Add new Feedback from

Example: http://mydomain.com/addNewFeedbackForm

|ID|Question|

4. Function: List all the items in the "User Table"

Example: http://mydomain.com/listUserFeedback

|ID|UUID|Status|PhoneNumber|ServiceOrder|SMS-MSG-ID|FeedbackFormVersion|InvestResult(hyperlink)|Country|CreateTime|FeedbackTime|

Need add filters drop-boxes to filter the result by "Status", "FeedbackFormVersion", "CreateTime" (start - end), "FeedbackTime" (start-end)

5. Function: Show the feedback result:

Example: http://mydomain.com/showFeebackResult?UUID=1089712304710293749127401923740912734017234

|ID|Question|Answer|
|1|Q1|A1|
|2|Q2|A2|
....








Evner: MySQL, PHP

Se mere: table customer, rule of graphic design, question of web and graphic design, graphic design time tracking, graphic design time of india, graphic design india 5, graphic design customer service, customer table, create website in india, bulk submit url, bulk message service, all feedback, website project investigation, good feedback customer support agent, feedback customer sales manager, design website private investigation, sample feedback customer survey coffee shops, feedback form analysis done friends, website promotion posting feedback, create customer login database website

Om arbejdsgiveren:
( 2 bedømmelser ) Shanghai, China

Projekt ID: #8147893

Tildelt til:

developerhunk

Hello sir,, i have read the project carefully and i understood the work but sir i have few things that i want to ask you related to the project .please talk to me and give me a chance. thanks.

$300 USD in 15 dage
(36 bedømmelser)
6.5

9 freelancere byder i gennemsnit $250 på dette job

scriptphp87

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [login to view URL] Flere

$210 USD in 7 dage
(183 bedømmelser)
7.6
itcslive

Dear sir, At first we like to say that we are a very experienced in programming languages ( php & mysql, ajax, JS, curl ) and expert in making custom cms with php script and can customize all major CMS like(joomla,word Flere

$368 USD in 7 dage
(143 bedømmelser)
7.6
samitalways4u

hello, I have experience in twilio sms services, I have integrated this API earlier, so i can easily do this job for you, but I have some confusion on the overall features of the project. Please reply me so that we can Flere

$250 USD in 10 dage
(54 bedømmelser)
6.5
SSYES

Hi I have reviewed the requirements. I would like to suggest for the option1. My bid involves the implementaion of the sms send , webform to catch the response and the reports of investigations. Apart from this Flere

$500 USD in 15 dage
(11 bedømmelser)
4.7
saraca29n0v

A proposal has not yet been provided

$142 USD in 25 dage
(4 bedømmelser)
3.2
phparchana

Dear sir, I am starting my new company. I am having 7+ years of experience in web development. It will be good for both end, and you will get reliable developer. I am looking you as my permanent client. my mot Flere

$133 USD in 3 dage
(5 bedømmelser)
2.4
alpeshvaghela

Hello Client I have check your post regarding customer feedback process We have expertise on following technologies, CMS & frameworks, PHP, Yii, Zend, Codeigniter Cakephp, Wordpress, Opencart , Android, HTML Re Flere

$155 USD in 3 dage
(0 bedømmelser)
0.0
paldeepak2011

i have working idea for online store and i can build the online store which has content rich with slider and product description with clear description of product details and prices i am working on this type of online Flere

$244 USD in 15 dage
(0 bedømmelser)
0.0
bharat022

A proposal has not yet been provided

$161 USD in 3 dage
(4 bedømmelser)
0.0