public function indexAction()
{
$this->forceInsecure();
// Pull podcasts.
$podcasts = Podcast::fetchLatest();
$this->view->podcasts = $podcasts;
// Pull large photos and news for rotator.
$network_news = NetworkNews::fetchFeatured();
$this->view->network_news = $network_news;
// Pull stations and calendar events.
$this->_initStations();
$this->_initEvents();
// Pull conventions.
$conventions = Convention::getAllConventions();
$this->view->conventions_upcoming = $conventions['upcoming'];
$this->view->conventions_archived = $conventions['archived'];
/*
// Pull rotators.
$rotators = Rotator::fetch();
$this->view->rotators = $rotators;
*/
// Special event flagging and special formatting.
$special_event = \PVL\Utilities::showSpecialEventsMode();
$this->view->special_event = $special_event;
if ($special_event) {
$autoplay_station = Settings::getSetting('special_event_station_id', 0);
if ($autoplay_station != 0) {
$this->view->station_id = $autoplay_station;
$this->view->autoplay = true;
}
$this->view->special_event_embed = trim(Settings::getSetting('special_event_embed_code'));
$this->view->special_chat_embed = trim(Settings::getSetting('special_event_chat_code'));
}
$this->view->autoplay = (bool) $this->getParam('autoplay', true);
}
public static function showSpecialEventsMode()
{
if (Settings::getSetting('special_event', 0) == 1) {
return true;
} elseif (Settings::getSetting('special_event_if_stream_active', 0) == 1) {
$stream = Station::getRepository()->findOneBy(array('name' => 'PVL Special Events'));
if ($stream instanceof Station) {
return $stream->isPlaying();
} else {
return false;
}
} else {
return false;
}
}
public function indexAction()
{
$form = new \DF\Form($this->current_module_config->forms->settings->form);
$existing_settings = Settings::fetchArray(FALSE);
$form->setDefaults($existing_settings);
if (!empty($_POST) && $form->isValid($_POST)) {
$data = $form->getValues();
foreach ($data as $key => $value) {
Settings::setSetting($key, $value);
}
Settings::clearCache();
$this->alert('Settings updated!');
return $this->redirectHere();
}
$this->renderForm($form, 'edit', 'Site Settings');
}
public static function getSyncTimes()
{
Settings::clearCache();
$syncs = array('nowplaying' => array('name' => 'Now Playing Data', 'latest' => Settings::getSetting('nowplaying_last_run', 0), 'contents' => array('Now Playing Data')), 'short' => array('name' => '1-Minute Sync', 'latest' => Settings::getSetting('sync_fast_last_run', 0), 'contents' => array('Schedule Notifications')), 'medium' => array('name' => '5-Minute Sync', 'latest' => Settings::getSetting('sync_last_run', 0), 'contents' => array('Homepage Tumblr Rotator', 'Station Schedules', 'Podcast Episodes', 'CentovaCast Metadata', 'Slim Player Cache')), 'long' => array('name' => '1-Hour Sync', 'latest' => Settings::getSetting('sync_slow_last_run', 0), 'contents' => array('Analytics and Statistics', 'Convention Archives', 'API Call Cleanup', 'Song History Cleanup', 'BronyTunes Sync', 'Pony.fm Sync', 'EqBeats Sync')));
foreach ($syncs as $sync_key => $sync_info) {
$sync_latest = $sync_info['latest'];
$syncs[$sync_key]['diff'] = time() - $sync_latest;
$syncs[$sync_key]['diff_text'] = \DF\Utilities::timeDifferenceText($sync_latest, time());
}
return $syncs;
}
public static function run($force_run = false)
{
$di = \Phalcon\Di::getDefault();
$em = $di->get('em');
$config = $di->get('config');
// Set up Google Client.
$gclient_api_key = $config->apis->google_apis_key;
$gclient_app_name = $config->application->name;
if (empty($gclient_api_key)) {
return null;
}
$gclient = new \Google_Client();
$gclient->setApplicationName($gclient_app_name);
$gclient->setDeveloperKey($gclient_api_key);
$gcal = new \Google_Service_Calendar($gclient);
// Prevent running repeatedly in too short of a time (avoid API limits).
$last_run = Settings::getSetting('schedule_manager_last_run', 0);
if ($last_run > time() - 60 && !$force_run) {
return null;
}
$schedule_items = array();
$schedule_records = array();
$stations = $em->createQuery('SELECT s FROM Entity\\Station s WHERE (s.gcal_url IS NOT NULL AND s.gcal_url != \'\') AND s.is_active = 1')->getArrayResult();
$active_stations = Utilities::ipull($stations, 'id');
// Clear all invalid station records.
$em->createQuery('DELETE FROM Entity\\Schedule s WHERE (s.station_id IS NOT NULL) AND (s.station_id NOT IN (:station_ids))')->setParameter('station_ids', $active_stations)->execute();
foreach ($stations as $station) {
if ($station['gcal_url']) {
$schedule_items[] = array('name' => $station['name'], 'url' => $station['gcal_url'], 'type' => 'station', 'station_id' => $station['id'], 'image_url' => \DF\Url::content($station['image_url']));
}
}
Debug::startTimer('Get Calendar Records');
// Time boundaries for calendar entries.
$threshold_start = date(\DateTime::RFC3339, strtotime('-1 week'));
$threshold_end = date(\DateTime::RFC3339, strtotime('+1 year'));
foreach ($schedule_items as $item) {
// Get the "calendar_id" from the URL provided by the user.
$orig_url_parts = parse_url($item['url']);
$url_path_parts = explode('/', $orig_url_parts['path']);
$calendar_id = urldecode($url_path_parts[3]);
if (empty($calendar_id)) {
continue;
}
// Call the external Google Calendar client.
try {
$all_events = $gcal->events->listEvents($calendar_id, array('timeMin' => $threshold_start, 'timeMax' => $threshold_end, 'singleEvents' => 'true', 'orderBy' => 'startTime', 'maxResults' => '300'));
} catch (\Exception $e) {
continue;
}
// Process each individual event.
foreach ($all_events as $event_orig) {
$title = $event_orig->summary;
$body = $event_orig->description;
$location = $event_orig->location;
$web_url = $event_orig->htmlLink;
$banner_url = null;
$is_all_day = false;
$start_time_obj = $event_orig->start;
if ($start_time_obj->date) {
$is_all_day = true;
$start_time = strtotime($start_time_obj->date . ' 00:00:00');
} else {
$start_time = strtotime($start_time_obj->dateTime);
}
$end_time_obj = $event_orig->end;
if ($end_time_obj->date) {
$is_all_day = true;
$end_time = strtotime($end_time_obj->date . ' 00:00:00');
} elseif ($end_time_obj) {
$end_time = strtotime($end_time_obj->dateTime);
} else {
$end_time = $start_time;
}
// Detect URLs for link.
if ($body && !$web_url) {
preg_match('@((https?://)?([-\\w]+\\.[-\\w\\.]+)+\\w(:\\d+)?(/([-\\w/_\\.]*(\\?\\S+)?)?)*)@', $body, $urls);
if (count($urls) > 0) {
$web_url = $urls[0];
}
}
// Detect URLs for photo.
if ($location) {
preg_match('@((https?://)?([-\\w]+\\.[-\\w\\.]+)+\\w(:\\d+)?(/([-\\w/_\\.]*(\\?\\S+)?)?)*)@', $location, $urls);
if (count($urls) > 0) {
$banner_url = $urls[0];
}
}
$guid = md5(implode('|', array($event_orig->id, $start_time, $end_time, $title, $location)));
$schedule_record = array('guid' => $guid, 'type' => $item['type'], 'start_time' => $start_time, 'end_time' => $end_time, 'is_all_day' => $is_all_day, 'title' => $title, 'location' => $location, 'body' => \DF\Utilities::truncateText(strip_tags($body), 300), 'banner_url' => $banner_url, 'web_url' => $web_url);
\PVL\Debug::print_r($schedule_record);
$schedule_records[$item['station_id']][$guid] = $schedule_record;
}
}
Debug::endTimer('Get Calendar Records');
if (count($schedule_records) == 0) {
Debug::log('Error: No calendar records loaded');
return;
}
// Add/Remove all differential records.
Debug::startTimer('Sync DB Records');
foreach ($schedule_records as $station_id => $station_records) {
$station = Station::find($station_id);
if ($station_id == 0) {
$existing_guids_raw = $em->createQuery('SELECT s.guid FROM Entity\\Schedule s WHERE s.station_id IS NULL')->getArrayResult();
} else {
$existing_guids_raw = $em->createQuery('SELECT s.guid FROM Entity\\Schedule s WHERE s.station_id = :sid')->setParameter('sid', $station_id)->getArrayResult();
}
$existing_guids = array();
foreach ($existing_guids_raw as $i) {
$existing_guids[] = $i['guid'];
}
$new_guids = array_keys($station_records);
$guids_to_delete = array_diff($existing_guids, $new_guids);
if ($guids_to_delete) {
$em->createQuery('DELETE FROM Entity\\Schedule s WHERE s.guid IN (:guids)')->setParameter('guids', $guids_to_delete)->execute();
}
$guids_to_add = array_diff($new_guids, $existing_guids);
if ($guids_to_add) {
foreach ($guids_to_add as $guid) {
$schedule_record = $station_records[$guid];
$record = new Schedule();
$record->station = $station;
$record->fromArray($schedule_record);
$em->persist($record);
}
}
$em->flush();
$em->clear();
}
Debug::endTimer('Sync DB Records');
Settings::setSetting('schedule_manager_last_run', time());
}
