public function checkMessage()
{
require './database/Database.php';
require './gcm/Gcm.php';
$db = new Database();
$dateTime = new DateTime('now', new DateTimeZone('Asia/Calcutta'));
$queryTime = $dateTime->format('Y-m-d H:i:s');
$queryString = "SELECT * FROM `message` WHERE `sent` = 0 AND `datetime` <= '{$queryTime}' ";
if ($query = $db->queryDb($queryString)) {
$gcm = new Gcm();
$data = array();
foreach ($query as $row) {
switch ($row['update_type']) {
case 0:
$data['type'] = 0;
$data['message'] = $row['description'];
break;
case 1:
$data['type'] = 1;
$data['name'] = $row['name'];
$data['location'] = $row['location'];
$data['desc'] = $row['description'];
$data['long'] = $row['longitude'];
$data['lat'] = $row['latitude'];
break;
case 2:
$data['type'] = 2;
$data['url'] = 'http://10.42.0.1/gcm/images/' . $row['pick'];
$data['desc'] = $row['description'];
break;
default:
throw new Exception('Unsupported operation');
}
if ($gcm_response = $gcm->sendNotifcation(json_encode($data))) {
$jsonResponse = json_decode($gcm_response, TRUE);
$message_id = $jsonResponse['message_id'];
$this->setSent($db, $message_id, $row['message_id']);
}
sleep(1);
}
}
}
$server_response = '';
if (isset($_POST['submit'])) {
$alert_body = addslashes($_POST['alert-description']);
$postDateTime = $_POST['alert-date'] . ' ' . $_POST['alert-time'];
$datetime = DateTime::createFromFormat('Y-m-d H:i', $postDateTime, new DateTimeZone('UTC'));
$alert_datetime = $datetime->format('Y-m-d H:i:s');
$updateQuery = "UPDATE `message` SET `datetime`= '{$alert_datetime}', `description`= '{$alert_body}' WHERE `message_id` = '{$_GET['id']}'";
if ($db->queryUpdateDb($updateQuery)) {
$server_response = '<div class="alert alert-success" role="alert">Alert has been <strong>successfully</strong> updated</div>';
} else {
$server_response = '<div class="alert alert-danger" role="alert">Something went wrong!!! Thats all we know</div>';
}
}
if (isset($_GET['id'])) {
$sqlQuery = "SELECT `datetime`, `update_type`, `description` FROM `message` WHERE `message_id` = '{$_GET['id']}'";
if ($query = $db->queryDb($sqlQuery)) {
$row = $query[0];
if ($row['update_type'] == 0) {
$datetime = DateTime::createFromFormat('Y-m-d H:i:s', $row['datetime'], new DateTimeZone('UTC'));
$alert_date = $datetime->format('Y-m-d');
$alert_time = $datetime->format('H:i');
$alert_description = $row['description'];
} else {
die('<div class="container text-center"><h1>Invalid alert id.</h1></div>');
}
}
require './views/components/navigation.php';
require './views/edit_alert.php';
} else {
die('<div class="container text-center"><h1>Invalid alert id.</h1></div>');
}
