/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$client = new Client();
$end_point = 'http://api.serviceu.com/rest/events/occurrences?orgKey=b96cd642-acbb-4eb7-95a2-f18c0f01d5b1&format=json';
$response = $client->get($end_point);
$data = json_decode($response->getBody(true));
$active_records = [];
CalendarEvent::unguard();
foreach ($data as $event) {
array_push($active_records, $event->OccurrenceId);
$record = CalendarEvent::withPast()->where('id', '=', $event->OccurrenceId)->first() ?: new CalendarEvent();
$record->{'id'} = $event->OccurrenceId;
$record->{'event_number'} = $event->EventId;
$record->{'title'} = $event->Name;
$record->{'starts_at'} = Carbon::createFromFormat('m/d/Y h:i:s A', $event->OccurrenceStartTime);
$record->{'ends_at'} = Carbon::createFromFormat('m/d/Y h:i:s A', $event->OccurrenceEndTime);
$record->{'location'} = $event->LocationName;
$record->{'address'} = $event->LocationAddress;
$record->{'address2'} = $event->LocationAddress2;
$record->{'city'} = $event->LocationCity;
$record->{'state'} = $event->LocationState;
$record->{'zip'} = $event->LocationZip;
$record->{'description'} = $event->Description;
$record->{'contact'} = $event->ContactName;
$record->{'contact_email'} = $event->ContactEmail;
$record->{'contact_phone'} = $event->ContactPhone;
$record->{'department'} = $event->DepartmentName;
$record->save();
}
CalendarEvent::reguard();
// Remove non-existing events
CalendarEvent::withPast()->whereNotIn('id', $active_records)->delete();
// Purge old events
CalendarEvent::where('ends_at', '<', Carbon::now()->subMonth(2))->delete();
}
