//TODO: fix file paths to current structure
//Includes - config
include "config/config.inc.php";
//Master generic class
include "classes/vyda.generic.class.php";
//Includes - classes
include "classes/vyda.mysql.php";
include "classes/vyda.webrequest.php";
include "classes/vyda.twilio.php";
//Includes - MultiPING stuff
include "classes/multiping.people.php";
include "classes/multiping.events.php";
include "classes/multiping.messages.php";
include "classes/multiping.communication.php";
//Instantiate the MySQL
$MySQL_Control = new VYDA_MySQL($wpi_db_host, $wpi_db_name, $wpi_db_user, $wpi_db_pass);
//Instantiate the Twilio Object
$Twilio_Control = new VYDA_Twilio($MySQL_Control);
//Instantiate the MultiPING People Class
$MultiPING_People = new MultiPing_People($MySQL_Control);
//Instantiate the MultiPING Event Class
$MultiPING_Events = new MultiPING_Events($MySQL_Control);
//Instantiate the MultiPING Messages Class
$MultiPING_Messages = new MultiPING_Messages($MySQL_Control);
//Instantiate the MultiPING_Communication
$MultiPING_Communication = new MultiPING_Communication($MySQL_Control);
//Define the requested funcitonality
$get_func = $_GET['func'];
//Database test
$full_users = $MySQL_Control->FullAssocReturn("SELECT * FROM `people`");
//Array of files
<html>
<head></head>
<body>
<?php
//Includes - config
include "../config/config.inc.php";
//Master generic class
include "../classes/vyda.generic.class.php";
//Includes - classes
include "../classes/vyda.mysql.php";
//Instantiate the MySQL
$MySQL_Control = new VYDA_MySQL($wpi_db_host, $wpi_db_name, $wpi_db_user, $wpi_db_pass);
/*
* Display All twilio_text_responses as RESPONSES
*/
echo "<span class='form_header'>Messages</span>\n\t\t<br/>\n\t\t<br/>";
//List of all responses
$sql_field_selection = "`twilio_text_responses`.`id` AS `id`, `twilio_text_responses`.`Body` AS `Body`, `twilio_text_responses`.`From` AS `From`, `people`.`firstname` AS `person_firstname`, `people`.`lastname` AS `person_lastname`";
$response_list = $MySQL_Control->FullAssocReturn("SELECT {$sql_field_selection} FROM `twilio_text_responses` LEFT JOIN `people` ON (`twilio_text_responses`.`person_id` = `people`.`id`) WHERE status='0';");
if ($response_list) {
echo "<table class='data_table'>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>id</th>\n\t\t\t\t\t<th>body</th>\n\t\t\t\t\t<th>person</th>\n\t\t\t\t\t<th>Phone number</th>\n\t\t\t\t</tr>";
foreach ($response_list as $random => $response) {
echo "<tr>\n\t\t\t\t\t<td>{$response['id']}</td>\n\t\t\t\t\t<td>{$response['Body']}</td>\n\t\t\t\t\t<td>{$response['person_firstname']} {$response['person_lastname']}</td>\n\t\t\t\t\t<td>{$response['From']}</td>\n\t\t\t\t</tr>";
}
echo "</table>";
} else {
echo "no responses yet.";
}
?>
</body>
</html>
