Repair some PHP script and write a portal

FreePBX 13

PHP 5.6

Asterisk 13

Repair of small php script and code a new WEB portal to display results from a MySQL table.

I have a small script that collects key input for a post call survey, I can’t get the agi_channel added to the MySQL table. This needs to be fixed.

$agi->request["agi_uniqueid"]."', ".$polite.", ".$knowledgeable.", ".$available.", ".$order.", ".$nps.", ".$agi->request["agi_callerid"].", ".$agi->request["agi_channel"].")");

Need a php portal coded to read the data from MySQL table and present on screen and option to download as a CSV file.

Portal to have Filters for Date, Agent and NPS. CSV download to have all raw data that can be fileted by Date.

Table

Column Type Collation Attributes Null

1 id int(11) No None

2 date datetime Yes NULL

3 uniqueid varchar(100) latin1_swedish_ci

4 polite tinyint(1) Yes NULL

5 knowledgeable tinyint(1) Yes NULL

6 available tinyint(1) Yes NULL

7 order tinyint(1) Yes NULL

8 nps tinyint(1) Yes NULL

9 callerid int(10) Yes NULL

10 agent varchar(9) latin1_swedish_ci

Asterisk PBX PHP

项目ID： #11842477

关于项目