public function index()
{
$db = new Database();
$incidents = $db->query("SELECT incident.id, incident_title, \n\t\t\t\t\t\t\t\t incident_description, incident_verified, \n\t\t\t\t\t\t\t\t location.latitude, location.longitude, alert_sent.incident_id\n\t\t\t\t\t\t\t\t FROM incident INNER JOIN location ON incident.location_id = location.id\n\t\t\t\t\t\t\t\t LEFT OUTER JOIN alert_sent ON incident.id = alert_sent.incident_id");
$config = kohana::config('alerts');
$sms_from = NULL;
$settings = ORM::factory('settings', 1);
if ($settings->loaded == true) {
// Get SMS Numbers
if (!empty($settings->sms_no3)) {
$sms_from = $settings->sms_no3;
} elseif (!empty($settings->sms_no2)) {
$sms_from = $settings->sms_no2;
} elseif (!empty($settings->sms_no1)) {
$sms_from = $settings->sms_no1;
} else {
$sms_from = "000";
}
// User needs to set up an SMS number
}
foreach ($incidents as $incident) {
if ($incident->incident_id != NULL) {
continue;
}
$verified = (int) $incident->incident_verified;
if ($verified) {
$latitude = (double) $incident->latitude;
$longitude = (double) $incident->longitude;
$proximity = new Proximity($latitude, $longitude);
$alertees = $this->_get_alertees($proximity);
foreach ($alertees as $alertee) {
$alert_type = (int) $alertee->alert_type;
if ($alert_type == 1) {
$sms = new Eflyer();
$sms->user = $settings->eflyer_username;
$sms->password = $settings->eflyer_password;
$sms->use_ssl = false;
$sms->sms();
$message = $incident->incident_description;
if ($sms->send($alertee->alert_recipient, $message) == "OK") {
$db->insert('alert_sent', array('alert_id' => $alertee->id, 'incident_id' => $incident->id, 'alert_date' => date("Y-m-d H:i:s")));
$db->clear_cache(true);
}
} elseif ($alert_type == 2) {
$to = $alertee->alert_recipient;
$from = $config['alerts_email'];
$subject = $incident->incident_title;
$message = $incident->incident_description;
if (email::send($to, $from, $subject, $message, TRUE) == 1) {
$db->insert('alert_sent', array('alert_id' => $alertee->id, 'incident_id' => $incident->id, 'alert_date' => date("Y-m-d H:i:s")));
$db->clear_cache(true);
}
}
}
}
}
}
/**
* Proxy method to Database field_data.
*
* @chainable
* @param string $sql SQL query to clear
* @return ORM
*/
public function clear_cache($sql = NULL)
{
// Proxy to database
$this->_db->clear_cache($sql);
ORM::$_column_cache = array();
return $this;
}
