public function getGraphData()
{
if (Sentry::getUser()) {
$user_id = Sentry::getUser()->id;
$period = Input::get('check_report_period');
$mongo_id = Input::get('report_mongo_id');
$check_id = Input::get('report_check_id');
$mongoAPI = new MongoAPI();
$checkAlertEmail = new CheckAlertEmail();
$data = json_decode($mongoAPI->getServerModelData($mongo_id, $period), true);
$data['alert'] = $checkAlertEmail->getDataByCheckId($check_id);
return Response::json($data);
} else {
try {
$user = Sentry::findUserById(Input::get('user_id'));
$emf_group = Sentry::findGroupByName('EmfUsers');
if ($user->inGroup($emf_group)) {
return $this->get_exired_message(Config::get('kuu.emf_login_page'));
} else {
return $this->get_exired_message(URL::route('login'));
}
} catch (Cartalyst\Sentry\Users\UserNotFoundException $e) {
return $this->get_exired_message(URL::route('login'));
} catch (Cartalyst\Sentry\Groups\GroupNotFoundException $e) {
return $this->get_exired_message(URL::route('login'));
}
}
}
private function user_save_check_alert_emails($check_id = 0)
{
$input = \Input::all();
$input['check_id'] = $check_id;
$alert_email = CheckAlertEmail::user_update_alert_email($input);
return $alert_email->validate_errors;
}
public function update($lang, $check_id, $alert_id)
{
if ($alert_id != intval(Input::get('alert_id'))) {
Session::flash('error_message', trans('kuu-validation.alert_email_was_not_found'));
//return Redirect::to('/admin/alert/'.$check_id);
return Redirect::route('admin.alert', array('lang' => App::getLocale(), 'check_id' => $check_id));
}
if (CheckAlertEmail::where('alert_id', '=', $alert_id)->count() == 1) {
$check_alert_email = CheckAlertEmail::where('alert_id', '=', $alert_id)->first();
if ($check_alert_email->update_alert_email(Input::all())) {
Session::flash('message', trans('kuu-validation.alert_email_was_updated'));
//return Redirect::to('/admin/alert/'.$check_id);
return Redirect::route('admin.alert', array('lang' => App::getLocale(), 'check_id' => $check_id));
} else {
Session::flash('error_message', $check_alert_email->get_error_message());
//return Redirect::to('/admin/alert/'.$check_id);
return Redirect::route('admin.alert', array('lang' => App::getLocale(), 'check_id' => $check_id));
}
} else {
Session::flash('error_message', trans('kuu-validation.alert_email_was_not_found'));
//return Redirect::to('/admin/alert/'.$check_id);
return Redirect::route('admin.alert', array('lang' => App::getLocale(), 'check_id' => $check_id));
}
}
static function get_by_check_id($check_id)
{
$emails = new CheckAlertEmail();
return $emails->where('check_id', '=', $check_id)->get();
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
// How many alerts to request from mongo
$count = Config::get('kuu.cron_batch_size');
// KUU Email Settings
$email_from_address = Config::get('kuu.email_from_address');
$email_from_name = Config::get('kuu.email_from_name');
$email_bcc = Config::get('kuu.email_bcc');
// time in seconds, how often to notify
$alert_interval_24hrs = Config::get('kuu.alert_interval_24hrs');
// 20 mins
$alert_interval_over_24hrs = Config::get('kuu.alert_interval_over_24hrs');
// a day
$http_error_descriptions = Config::get('kuu.http_error_descriptions');
$url = Config::get('kuu.apiurl') . '/rest/popalerts?api_key=' . Config::get('kuu.apikey') . '&count=' . $count;
$browser = new Buzz\Browser();
$response = $browser->get($url);
$response_array = json_decode($response->getContent());
//$checkAlertEmail = new CheckAlertEmail();
if (isset($response_array->Result) && $response_array->Result == 'OK') {
$mail_counter = 0;
foreach ($response_array->Records as $record_id => $record) {
$record->time_formatted = date("m/d H:i:s T", $record->timestamp - $record->downtime);
$record->title = 'Site is ' . Str::title($record->type);
// $this->info('Record '.print_r($record, TRUE));
$alert_emails = CheckAlertEmail::getAlertEmailsByMongoId($record->check_id);
// $alert_emails = CheckAlertEmail::getAlertEmailsByMongoId('5357d420685fabd7490000a4');
// $this->info('Alert Emails '.print_r($alert_emails, TRUE));
//DB::select('SELECT * FROM checks LEFT JOIN checks_alert_email USING (check_id)
// LEFT JOIN users ON checks_alert_email.user_id=users.id WHERE mongo_id = ?',
// array('5322c33f3cdffe9926000099'));
// array($record->check_id));
foreach ($alert_emails as $id => $email) {
// $this->info('Alert email '.print_r($alert_emails, TRUE));
$since_last_time = time() - strtotime($email->last_sent . " GMT");
$times_sent = $email->times_sent;
// $this->info('since_last_time '.$since_last_time.' '.$times_sent.' '.$alert_interval_24hrs.' '.$alert_interval_over_24hrs);
// $this->info('down since '.$record->downtime.' '. (24*60*60) .'seconds in a day ' . $email_from_address.' '.$email_from_name);
$isDown = $record->type == 'down';
$trigger_send = false;
// if total downtime less than a day, use $alert_interval_24hrs, otherwise use
if ($record->downtime < 24 * 60 * 60 && $since_last_time >= $alert_interval_24hrs) {
$trigger_send = true;
} elseif ($record->downtime >= 24 * 60 * 60 && $since_last_time >= $alert_interval_over_24hrs) {
$trigger_send = true;
}
if ($trigger_send || !$isDown) {
//$this->info($email->alert_email.' '.$email->first_name.' '.$email->last_name);
$record->alert_email = $email;
$record->protocol = $email->type;
$record->http_error_descriptions = $http_error_descriptions;
$email->subject = $record->title . " - " . $email->url . " - " . $email->type;
$email->from_address = $email_from_address;
$email->from_name = $email_from_name;
$email->bcc_admin = $email_bcc;
Mail::send('emails.cronalert', (array) $record, function ($message) use($email) {
$message->from($email->from_address, $email->from_name);
// Remove To email name, you can set alerts to go to 3rd parties, name won't be valid
// $message->to($email->alert_email, $email->first_name.' '.$email->last_name)
$message->to($email->alert_email)->subject($email->subject);
foreach ($email->bcc_admin as $e) {
$message->bcc($e);
}
//$message->to('*****@*****.**', 'Andrei Tsygankov')->subject('Alerts');
});
$mail_counter++;
//$this->info($email->alert_id.' '.$record->type.' '.$email->last_name);
if ($isDown) {
CheckAlertEmail::where('alert_id', $email->alert_id)->update(array('last_sent' => gmdate("Y-m-d H:i:s"), 'times_sent' => $times_sent + 1));
} else {
CheckAlertEmail::where('alert_id', $email->alert_id)->update(array('last_sent' => '0000-00-00 00:00:00', 'times_sent' => 0));
}
}
}
// just send to admin
/*
if(!count($alert_emails)) {
Mail::send('emails.cronalert', (array)$record, function($message)
{
$message->from('*****@*****.**', 'KeepUsUp');
$message->to('*****@*****.**', 'Admin')
->subject('Alerts')
//->cc('*****@*****.**')
;
});
$mail_counter++;
}
*/
}
$this->info('Successfully sent ' . $mail_counter . ' emails');
} else {
if (isset($response_array->Result)) {
$this->info('Failed with result=' . $response_array->Result);
} else {
$this->info('Failed with to fetch REST API data');
}
}
}
