public function getCalendarStructure()
{
$end_date = clone $this->config->getStartDate();
$end_date->add($this->config->getInterval());
$period = new \DatePeriod($this->config->getStartDate(), new \DateInterval('P1D'), $end_date);
$cal = array();
foreach ($period as $date) {
$year = $date->format('Y');
$month = $date->format('n');
$day = $date->format('j');
$quarter = (int) ceil($month / 3);
$week = $date->format('W');
$week_day = $date->format('w');
if (!array_key_exists($year, $cal)) {
$cal[$year] = array('type' => 'year', 'value' => $year, 'data' => $this->setDataInElement($date, 'year_callback'), 'elements' => array());
}
if (!array_key_exists($quarter, $cal[$year]['elements'])) {
$cal[$year]['elements'][$quarter] = array('type' => 'quarter', 'value' => $quarter, 'data' => $this->setDataInElement($date, 'quarter_callback'), 'elements' => array());
}
if (!array_key_exists($month, $cal[$year]['elements'][$quarter]['elements'])) {
$cal[$year]['elements'][$quarter]['elements'][$month] = array('type' => 'month', 'value' => $month, 'data' => $this->setDataInElement($date, 'month_callback'), 'elements' => array());
}
if (!array_key_exists($week, $cal[$year]['elements'][$quarter]['elements'][$month]['elements'])) {
$cal[$year]['elements'][$quarter]['elements'][$month]['elements'][$week] = array('type' => 'week', 'value' => $week, 'data' => $this->setDataInElement($date, 'week_callback'), 'elements' => array());
}
if (!array_key_exists($day, $cal[$year]['elements'][$quarter]['elements'][$month]['elements'][$week]['elements'])) {
$cal[$year]['elements'][$quarter]['elements'][$month]['elements'][$week]['elements'][$day] = array('type' => 'day', 'value' => $day, 'data' => $this->setDataInElement($date, 'day_callback'), 'weekday' => $week_day);
}
}
$cal = $this->config->getFormatter()->setFormat($cal);
return $cal;
}
/**
* Contructor
* @param type $controller
* @param type $name
*/
function __construct($controller, $name)
{
//Administering calendars
if (CalendarConfig::subpackage_enabled('calendars')) {
//Configuration for calendar grid field
$gridCalendarConfig = GridFieldConfig_RecordEditor::create();
$gridCalendarConfig->removeComponentsByType('GridFieldDataColumns');
$gridCalendarConfig->addComponent($dataColumns = new GridFieldDataColumns(), 'GridFieldEditButton');
$c = singleton('Calendar');
$summaryFields = $c->summaryFields();
//$summaryFields = array(
// 'Title' => 'Title',
// //'SubscriptionOptIn' => 'Opt In',
// //'Shaded' => 'Shaded'
//);
$s = CalendarConfig::subpackage_settings('calendars');
//show shading info in the gridfield
if ($s['shading']) {
$summaryFields['Shaded'] = 'Shaded';
}
$dataColumns->setDisplayFields($summaryFields);
//settings for the case that colors are enabled
if ($s['colors']) {
$dataColumns->setFieldFormatting(array("Title" => '<div style=\\"height:20px;width:20px;display:inline-block;vertical-align:middle;margin-right:6px;background:$Color\\"></div> $Title'));
}
$GridFieldCalendars = new GridField('Calendars', '', PublicCalendar::get(), $gridCalendarConfig);
$fields = new FieldList($GridFieldCalendars);
$actions = new FieldList();
$this->addExtraClass('CalendarsForm');
parent::__construct($controller, $name, $fields, $actions);
}
}
/**
* Getting a color palette
* For now we only have a hsv palette, could be extended with more options
*
* Potential options:
* Standard CKEditor color palette
* http://stackoverflow.com/questions/13455922/display-only-few-desired-colors-in-a-ckeditor-palette
* 000,800000,8B4513,2F4F4F,008080,000080,4B0082,696969,B22222,A52A2A,DAA520,006400,40E0D0,0000CD,800080,808080,F00,FF8C00,FFD700,008000,0FF,00F,EE82EE,A9A9A9,FFA07A,FFA500,FFFF00,00FF00,AFEEEE,ADD8E6,DDA0DD,D3D3D3,FFF0F5,FAEBD7,FFFFE0,F0FFF0,F0FFFF,F0F8FF,E6E6FA,FFF
*
* Consider adding color names like this:
* http://stackoverflow.com/questions/2993970/function-that-converts-hex-color-values-to-an-approximate-color-name
*
* Color variation:
* http://stackoverflow.com/questions/1177826/simple-color-variation
*
* @param int $numColors Number of colors - default: 30
* @return null
*/
public static function get_palette($numColors = 50, $type = 'hsv')
{
//overwriting with the palette from the calendar settings
$s = CalendarConfig::subpackage_settings('colors');
$arr = $s['basepalette'];
return $arr;
if ($type == 'hsv') {
$s = 1;
$v = 1;
$arr = array();
for ($i = 0; $i <= $numColors; $i++) {
$c = new Color();
$h = $i / $numColors;
$hex = $c->fromHSV($h, $s, $v)->toHexString();
$arr[$hex] = $hex;
}
return $arr;
} elseif ($type == 'websafe') {
//websafe colors
$cs = array('00', '33', '66', '99', 'CC', 'FF');
$arr = array();
for ($i = 0; $i < 6; $i++) {
for ($j = 0; $j < 6; $j++) {
for ($k = 0; $k < 6; $k++) {
$c = $cs[$i] . $cs[$j] . $cs[$k];
$arr["{$c}"] = "#{$c}";
}
}
}
return $arr;
}
}
/**
* Config setter & getter
* This serves as a settings setter and getter at the same time
*/
public static function settings($settings = NULL)
{
if ($settings) {
//set mode
self::$settings = self::mergeSettings(self::$settings, $settings);
} else {
//get mode
}
//always return settings
return self::$settings;
}
/**
* Contructor
* @param type $controller
* @param type $name
*/
public function __construct($controller, $name)
{
//Administering categories
if (CalendarConfig::subpackage_enabled('categories')) {
$gridCategoryConfig = GridFieldConfig_RecordEditor::create();
$GridFieldCategories = new GridField('Categories', '', PublicEventCategory::get(), $gridCategoryConfig);
$fields = new FieldList($GridFieldCategories);
$actions = new FieldList();
$this->addExtraClass('CategoriesForm');
parent::__construct($controller, $name, $fields, $actions);
}
}
private function build_view(HTTPRequestCustom $request)
{
$db_querier = PersistenceContext::get_querier();
$date_lang = LangLoader::get('date-common');
$events_list = $participants = array();
$config = CalendarConfig::load();
$year = $this->year ? $this->year : $request->get_int('calendar_ajax_year', date('Y'));
$month = $this->month ? $this->month : $request->get_int('calendar_ajax_month', date('n'));
$day = $this->day ? $this->day : $request->get_int('calendar_ajax_day', 1);
$array_l_month = array($date_lang['january'], $date_lang['february'], $date_lang['march'], $date_lang['april'], $date_lang['may'], $date_lang['june'], $date_lang['july'], $date_lang['august'], $date_lang['september'], $date_lang['october'], $date_lang['november'], $date_lang['december']);
$result = $db_querier->select("SELECT *\n\t\tFROM " . CalendarSetup::$calendar_events_table . " event\n\t\tLEFT JOIN " . CalendarSetup::$calendar_events_content_table . " event_content ON event_content.id = event.content_id\n\t\tLEFT JOIN " . DB_TABLE_MEMBER . " member ON member.user_id = event_content.author_id\n\t\tLEFT JOIN " . DB_TABLE_COMMENTS_TOPIC . " com ON com.id_in_module = event.id_event AND com.module_id = 'calendar'\n\t\tWHERE approved = 1\n\t\tAND ((start_date BETWEEN :first_day_hour AND :last_day_hour) OR (end_date BETWEEN :first_day_hour AND :last_day_hour) OR (:first_day_hour BETWEEN start_date AND end_date))\n\t\tORDER BY start_date ASC", array('first_day_hour' => mktime(0, 0, 0, $month, $day, $year), 'last_day_hour' => mktime(23, 59, 59, $month, $day, $year)));
while ($row = $result->fetch()) {
$event = new CalendarEvent();
$event->set_properties($row);
$events_list[$event->get_id()] = $event;
}
$result->dispose();
$events_number = $result->get_rows_count();
$this->view->put_all(array('C_COMMENTS_ENABLED' => $config->are_comments_enabled(), 'C_EVENTS' => $events_number > 0, 'DATE' => $day . ' ' . $array_l_month[$month - 1] . ' ' . $year, 'L_EVENTS_NUMBER' => $events_number > 1 ? StringVars::replace_vars($this->lang['calendar.labels.events_number'], array('events_number' => $events_number)) : $this->lang['calendar.labels.one_event']));
if (!empty($events_list)) {
$result = $db_querier->select('SELECT event_id, member.user_id, display_name, level, groups
FROM ' . CalendarSetup::$calendar_users_relation_table . ' participants
LEFT JOIN ' . DB_TABLE_MEMBER . ' member ON member.user_id = participants.user_id
WHERE event_id IN :events_list', array('events_list' => array_keys($events_list)));
while ($row = $result->fetch()) {
if (!empty($row['display_name'])) {
$participant = new CalendarEventParticipant();
$participant->set_properties($row);
$participants[$row['event_id']][$participant->get_user_id()] = $participant;
}
}
$result->dispose();
foreach ($events_list as $event) {
if (isset($participants[$event->get_id()])) {
$event->set_participants($participants[$event->get_id()]);
}
$this->view->assign_block_vars('event', $event->get_array_tpl_vars());
$participants_number = count($event->get_participants());
$i = 0;
foreach ($event->get_participants() as $participant) {
$i++;
$this->view->assign_block_vars('event.participant', array_merge($participant->get_array_tpl_vars(), array('C_LAST_PARTICIPANT' => $i == $participants_number)));
}
}
}
}
private function build_view()
{
$event = $this->get_event();
$category = $event->get_content()->get_category();
$this->tpl->put_all(array_merge($event->get_array_tpl_vars(), array('NOT_VISIBLE_MESSAGE' => MessageHelper::display(LangLoader::get_message('element.not_visible', 'status-messages-common'), MessageHelper::WARNING))));
$participants_number = count($event->get_participants());
$i = 0;
foreach ($event->get_participants() as $participant) {
$i++;
$this->tpl->assign_block_vars('participant', array_merge($participant->get_array_tpl_vars(), array('C_LAST_PARTICIPANT' => $i == $participants_number)));
}
if (CalendarConfig::load()->are_comments_enabled()) {
$comments_topic = new CalendarCommentsTopic($event);
$comments_topic->set_id_in_module($event->get_id());
$comments_topic->set_url(CalendarUrlBuilder::display_event($category->get_id(), $category->get_rewrited_name(), $event->get_id(), $event->get_content()->get_rewrited_title()));
$this->tpl->put_all(array('C_COMMENTS_ENABLED' => true, 'COMMENTS' => $comments_topic->display()));
}
}
private function save()
{
$this->config->set_items_number_per_page($this->form->get_value('items_number_per_page'));
if ($this->form->get_value('comments_enabled')) {
$this->config->enable_comments();
} else {
$this->config->disable_comments();
}
$this->config->set_event_color($this->form->get_value('event_color'));
if ($this->form->get_value('members_birthday_enabled')) {
$this->config->enable_members_birthday();
$this->config->set_birthday_color($this->form->get_value('birthday_color'));
} else {
$this->config->disable_members_birthday();
}
$this->config->set_authorizations($this->form->get_value('authorizations')->build_auth_array());
CalendarConfig::save();
CalendarService::get_categories_manager()->regenerate_cache();
CalendarCurrentMonthEventsCache::invalidate();
}
public static function eventConfig()
{
$gridEventConfig = GridFieldConfig_RecordEditor::create();
//Custom detail form
$gridEventConfig->removeComponentsByType('GridFieldDetailForm');
$gridEventConfig->addComponent(new CalendarEventGridFieldDetailForm());
//Custom columns
$gridEventConfig->removeComponentsByType('GridFieldDataColumns');
$dataColumns = new GridFieldDataColumns();
$summaryFields = Event::$summary_fields;
//Show the page if the event is connected to an event page
if (CalendarConfig::subpackage_setting('pagetypes', 'enable_eventpage')) {
$summaryFields['getEventPageCalendarTitle'] = 'Page';
}
//event classname - we might not always want it here - but here it is - for now
$summaryFields['i18n_singular_name'] = 'Type';
$dataColumns->setDisplayFields($summaryFields);
$gridEventConfig->addComponent($dataColumns, 'GridFieldEditButton');
return $gridEventConfig;
}
/**
* Handles returning the JSON events data for a time range.
*
* @param SS_HTTPRequest $request
* @return SS_HTTPResponse
*/
public function publicevents($request, $json = true, $calendars = null, $offset = 30)
{
$calendarsSupplied = false;
if ($calendars) {
$calendarsSupplied = true;
}
$events = PublicEvent::get()->filter(array('StartDateTime:GreaterThan' => $this->eventlistOffsetDate('start', $request->postVar('start'), $offset), 'EndDateTime:LessThan' => $this->eventlistOffsetDate('end', $request->postVar('end'), $offset)));
//If shaded events are enabled we need to filter shaded calendars out
//note that this only takes effect when no calendars have been supplied
//if calendars are supplied, this needs to be taken care of from that method
$sC = CalendarConfig::subpackage_settings('calendars');
if ($sC['shading']) {
if (!$calendars) {
$calendars = PublicCalendar::get();
$calendars = $calendars->filter(array('shaded' => false));
}
}
if ($calendars) {
$calIDList = $calendars->getIdList();
//adding in 0 to allow for showing events without a calendar
if (!$calendarsSupplied) {
$calIDList[0] = 0;
}
//Debug::dump($calIDList);
$events = $events->filter('CalendarID', $calIDList);
}
$result = array();
if ($events) {
foreach ($events as $event) {
$calendar = $event->Calendar();
$bgColor = '#999';
//default
$textColor = '#FFF';
//default
$borderColor = '#555';
if ($calendar->exists()) {
$bgColor = $calendar->getColorWithHash();
$textColor = '#FFF';
$borderColor = $calendar->getColorWithHash();
}
$resultArr = self::format_event_for_fullcalendar($event);
$resultArr = array_merge($resultArr, array('backgroundColor' => $bgColor, 'textColor' => '#FFF', 'borderColor' => $borderColor));
$result[] = $resultArr;
}
}
if ($json) {
$response = new SS_HTTPResponse(Convert::array2json($result));
$response->addHeader('Content-Type', 'application/json');
return $response;
} else {
return $result;
}
}
public function CalendarViewLink()
{
$s = CalendarConfig::subpackage_settings('pagetypes');
$indexSetting = $s['calendarpage']['index'];
$link = $this->Link();
if ($indexSetting == 'eventlist') {
return $link . 'calendarview/';
} elseif ($indexSetting == 'calendarview') {
return $link;
}
}
public function get_root_category()
{
$root = new RootCategory();
$root->set_authorizations(CalendarConfig::load()->get_authorizations());
return $root;
}
/**
* Frontend fields
* Simple list of the basic fields - how they're intended to be edited
*/
function getFrontEndFields($params = null)
{
//parent::getFrontEndFields($params);
$timeFrameHeaderText = 'Time Frame';
if (!CalendarConfig::subpackage_setting('events', 'force_end')) {
$timeFrameHeaderText = 'End Date / Time (optional)';
}
$fields = FieldList::create(TextField::create('Title')->setAttribute('placeholder', 'Enter a title'), CheckboxField::create('AllDay', 'All-day'), $startDateTime = DatetimeField::create('StartDateTime', 'Start'), CheckboxField::create('NoEnd', 'Open End'), HeaderField::create('TimeFrameHeader', $timeFrameHeaderText, 5), SelectionGroup::create('TimeFrameType', array("Duration//Duration" => TimeField::create('Duration', '')->setRightTitle('up to 24h')->setAttribute('placeholder', 'Enter duration'), "DateTime//Date/Time" => $endDateTime = DateTimeField::create('EndDateTime', ''))), LiteralField::create('Clear', '<div class="clear"></div>'));
//Date field settings
$timeExpl = 'Time, e.g. 11:15am or 15:30';
//$startDateTime->setConfig('datavalueformat', 'YYYY-MM-dd HH:mm');
//$endDateTime->setConfig('datavalueformat', 'YYYY-MM-dd HH:mm');
$startDateTime->getDateField()->setConfig('showcalendar', 1)->setAttribute('placeholder', 'Enter date')->setAttribute('readonly', 'true');
//we only want input through the datepicker
$startDateTime->getTimeField()->setConfig('timeformat', 'HH:mm')->setAttribute('placeholder', 'Enter time');
$endDateTime->getDateField()->setConfig('showcalendar', 1)->setAttribute('placeholder', 'Enter date')->setAttribute('readonly', 'true');
//we only want input through the datepicker
$endDateTime->getTimeField()->setConfig('timeformat', 'HH:mm')->setAttribute('placeholder', 'Enter time');
//removing AllDay checkbox if allday events are disabled
if (!CalendarConfig::subpackage_setting('events', 'enable_allday_events')) {
$fields->removeByName('AllDay');
}
//removing NoEnd checkbox if end dates are enforced
if (CalendarConfig::subpackage_setting('events', 'force_end')) {
$fields->removeByName('NoEnd');
} else {
//we don't want the NoEnd checkbox when creating new events
if (!$this->ID) {
//$fields->removeByName('NoEnd');
}
}
$this->extend('updateFrontEndFields', $fields);
return $fields;
}
private function build_view(HTTPRequestCustom $request)
{
$config = CalendarConfig::load();
$categories = CalendarService::get_categories_manager()->get_categories_cache()->get_categories();
$year = $this->year ? $this->year : min($request->get_int('calendar_ajax_year', date('Y')), 2037);
$month = $this->month ? $this->month : min($request->get_int('calendar_ajax_month', date('n')), 12);
$bissextile = date("L", mktime(0, 0, 0, 1, 1, $year)) == 1 ? 29 : 28;
$array_month = array(31, $bissextile, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);
$array_l_month = array($this->lang['january'], $this->lang['february'], $this->lang['march'], $this->lang['april'], $this->lang['may'], $this->lang['june'], $this->lang['july'], $this->lang['august'], $this->lang['september'], $this->lang['october'], $this->lang['november'], $this->lang['december']);
$month_days = $array_month[$month - 1];
$previous_month = $month == 1 ? 12 : $month - 1;
$previous_year = $month == 1 ? $year - 1 : $year;
$next_month = $month == 12 ? 1 : $month + 1;
$next_year = $month == 12 ? $year + 1 : $year;
//Months
for ($i = 1; $i <= 12; $i++) {
$this->view->assign_block_vars('months', array('VALUE' => $i, 'NAME' => $array_l_month[$i - 1], 'SELECTED' => $month == $i));
}
//Years
for ($i = 1970; $i <= 2037; $i++) {
$this->view->assign_block_vars('years', array('VALUE' => $i, 'NAME' => $i, 'SELECTED' => $year == $i));
}
//Retrieve all the events of the selected month
$events = $month == date('n') && $year == date('Y') ? CalendarCurrentMonthEventsCache::load()->get_events() : CalendarService::get_all_current_month_events($month, $year, $month_days);
$events_legends_list = array();
foreach ($events as $event) {
$start_date = new Date($event['start_date'], Timezone::SERVER_TIMEZONE);
$end_date = new Date($event['end_date'], Timezone::SERVER_TIMEZONE);
if (($end_date->get_month() > $start_date->get_month() || $end_date->get_year() > $start_date->get_year()) && $month == $start_date->get_month()) {
$first_event_day = $start_date->get_day();
$last_event_day = $array_month[$month - 1];
} else {
if (($end_date->get_month() > $start_date->get_month() || $end_date->get_year() > $start_date->get_year()) && $month == $end_date->get_month()) {
$first_event_day = 1;
$last_event_day = $end_date->get_day();
} else {
if (($end_date->get_month() > $start_date->get_month() || $end_date->get_year() > $start_date->get_year()) && $month > $start_date->get_month() && $month < $end_date->get_month()) {
$first_event_day = 1;
$last_event_day = $array_month[$month - 1];
} else {
$first_event_day = $start_date->get_day();
$last_event_day = $end_date->get_day();
}
}
}
for ($j = $first_event_day; $j <= $last_event_day; $j++) {
if ($event['type'] == 'EVENT' || $event['type'] == 'BIRTHDAY') {
$title = isset($array_events[$j]['title']) ? $array_events[$j]['title'] : '';
$array_events[$j] = array('title' => $title . (!empty($title) ? '
' : '') . ($event['type'] != 'BIRTHDAY' ? $j == $start_date->get_day() && $month == $start_date->get_month() && $year == $start_date->get_year() ? $start_date->get_hours() . 'h' . $start_date->get_minutes() . ' : ' : '' : LangLoader::get_message('calendar.labels.birthday_title', 'common', 'calendar') . ' ') . $event['title'], 'type' => $event['type'], 'color' => $event['type'] == 'BIRTHDAY' ? $config->get_birthday_color() : ($event['id_category'] != Category::ROOT_CATEGORY && $categories[$event['id_category']]->get_color() ? $categories[$event['id_category']]->get_color() : $config->get_event_color()), 'id_category' => $event['id_category']);
if ($event['type'] == 'BIRTHDAY') {
$events_legends_list[$j] = array('name' => LangLoader::get_message('calendar.labels.birthday', 'common', 'calendar'), 'color' => $config->get_birthday_color());
} else {
if ($event['type'] == 'EVENT' && $event['id_category'] == Category::ROOT_CATEGORY) {
$events_legends_list[$j] = array('name' => LangLoader::get_message('calendar.titles.event', 'common', 'calendar'), 'color' => $config->get_event_color());
} else {
if (!isset($events_legends_list[$event['id_category']])) {
$events_legends_list[$j] = array('name' => $categories[$event['id_category']]->get_name(), 'color' => $categories[$event['id_category']]->get_color());
}
}
}
}
}
}
$this->view->put_all(array('C_MINI_MODULE' => $this->is_mini_calendar(), 'C_DISPLAY_LEGEND' => !empty($events_legends_list) && !$this->is_mini_calendar(), 'DATE' => $array_l_month[$month - 1] . ' ' . $year, 'MINI_MODULE' => (int) $this->is_mini_calendar(), 'PREVIOUS_MONTH_TITLE' => $month == 1 ? $array_l_month[11] . ' ' . ($year - 1) : $array_l_month[$month - 2] . ' ' . $year, 'PREVIOUS_YEAR' => $previous_year, 'PREVIOUS_MONTH' => $previous_month, 'NEXT_MONTH_TITLE' => $month == 12 ? $array_l_month[0] . ' ' . ($year + 1) : $array_l_month[$month] . ' ' . $year, 'NEXT_YEAR' => $next_year, 'NEXT_MONTH' => $next_month, 'LEGEND' => self::build_legend($events_legends_list), 'U_AJAX_CALENDAR' => CalendarUrlBuilder::ajax_month_calendar()->rel(), 'U_AJAX_EVENTS' => CalendarUrlBuilder::ajax_month_events()->rel()));
//First day of the month
$first_day = date('w', @mktime(1, 0, 0, $month, 1, $year));
if ($first_day == 0) {
$first_day = 7;
}
//Calendar generation
$day = 1;
$last_day = $month_days + $first_day;
for ($i = 1; $i <= 56; $i++) {
$birthday_day = $color = false;
if ($i % 8 == 1 && $i < $last_day) {
$content = date('W', mktime(0, 0, 0, $month, $day, $year));
$class = 'calendar-week';
$last_day++;
} else {
if ($i >= $first_day + 1 && $i < $last_day) {
if ($day == date("j") && $month == date("m") && $year == date("Y")) {
$class = 'calendar-today';
} else {
if (!empty($array_events[$day])) {
$birthday_day = $array_events[$day]['type'] == 'BIRTHDAY';
$color = $array_events[$day]['color'];
$class = '';
} else {
if ($i % 8 == 7 || $i % 8 == 0) {
$class = 'calendar-weekend';
} else {
$class = 'calendar-other';
}
}
}
$content = $day;
$day++;
} else {
if (($i % 8 == 7 || $i % 8 == 0) && $i > $first_day && $day <= $month_days) {
$class = 'calendar-weekend';
} else {
$class = 'calendar-none';
}
}
}
if ($day > $month_days && $i % 8 == 0) {
$i = 56;
}
$today = $day - 1;
$this->view->assign_block_vars('day', array('C_MONTH_DAY' => $i % 8 != 1 && $class != 'calendar-none', 'C_COLOR' => $color || $birthday_day, 'C_WEEK_LABEL' => $i % 8 == 1, 'DAY' => $content, 'TITLE' => !empty($array_events[$today]) ? $array_events[$today]['title'] : '', 'COLOR' => $color, 'CLASS' => $class, 'CHANGE_LINE' => $i % 8 == 0 && $i != 56, 'U_DAY_EVENTS' => CalendarUrlBuilder::home($year, $month, $today, true)->rel()));
}
}
private function get_pagination($condition, $parameters, $page)
{
$row = PersistenceContext::get_querier()->select_single_row_query('SELECT COUNT(*) AS events_number
FROM ' . CalendarSetup::$calendar_events_table . ' event
LEFT JOIN ' . CalendarSetup::$calendar_events_content_table . ' event_content ON event_content.id = event.content_id
' . $condition, $parameters);
$pagination = new ModulePagination($page, $row['events_number'], (int) CalendarConfig::load()->get_items_number_per_page());
$pagination->set_url(CalendarUrlBuilder::display_pending_events('%d'));
if ($pagination->current_page_is_empty() && $page > 1) {
$error_controller = PHPBoostErrors::unexisting_page();
DispatchManager::redirect($error_controller);
}
return $pagination;
}
public function CategoriesEnabled()
{
return CalendarConfig::subpackage_enabled('categories');
}
<?php
global $project;
$project = 'mysite';
global $database;
// find the database name from the environment file
if (defined('SS_DATABASE_NAME') && SS_DATABASE_NAME) {
$database = SS_DATABASE_NAME;
} else {
$database = 'SS_nzlarps';
}
require_once 'conf/ConfigureFromEnv.php';
// Set the site locale
i18n::set_locale('en_US');
CalendarConfig::init(array('categories' => array('enabled' => false)));
$standardsEditor = HtmlEditorConfig::get('standards');
$standardsEditor->setOptions(array('theme_advanced_buttons3' => 'pagebreak', 'pagebreak_separator' => '<span class="break"><!--break--></span>'));
$standardsEditor->enablePlugins('pagebreak');
$standardsEditor->insertButtonsAfter('separator', 'pagebreak');
/**
* @desc Return all the events of the requested month.
* @param int $month Month of the request
* @param int $year Year of the request
* @param int $month_days Number of days in the requested month
*/
public static function get_all_current_month_events($month, $year, $month_days, $id_category = Category::ROOT_CATEGORY)
{
$authorized_categories = CalendarService::get_authorized_categories($id_category);
return self::$db_querier->select((CalendarConfig::load()->is_members_birthday_enabled() ? "\r\n\t\t(SELECT member_extended_fields.user_born AS start_date, member_extended_fields.user_born AS end_date, display_name AS title, 'BIRTHDAY' AS type, 0 AS id_category, '" . CalendarEventContent::YEARLY . "' AS repeat_type, 100 AS repeat_number\r\n\t\tFROM " . DB_TABLE_MEMBER . " member\r\n\t\tLEFT JOIN " . DB_TABLE_MEMBER_EXTENDED_FIELDS . " member_extended_fields ON member_extended_fields.user_id = member.user_id\r\n\t\tWHERE member_extended_fields.user_born <> '' AND MONTH(FROM_UNIXTIME(member_extended_fields.user_born)) = :month AND :year > YEAR(FROM_UNIXTIME(member_extended_fields.user_born)))\r\n\t\tUNION\r\n\t\t" : "") . "(SELECT start_date, end_date, title, 'EVENT' AS type, id_category, repeat_type, repeat_number\r\n\t\tFROM " . CalendarSetup::$calendar_events_table . " event\r\n\t\tLEFT JOIN " . CalendarSetup::$calendar_events_content_table . " event_content ON event_content.id = event.content_id\r\n\t\tWHERE approved = 1\r\n\t\tAND ((start_date BETWEEN :first_month_day AND :last_month_day) OR (end_date BETWEEN :first_month_day AND :last_month_day) OR (:first_month_day BETWEEN start_date AND end_date)) \r\n\t\tAND id_category IN :authorized_categories)\r\n\t\tORDER BY start_date ASC", array('month' => $month, 'year' => $year, 'first_month_day' => mktime(0, 0, 0, $month, 1, $year), 'last_month_day' => mktime(23, 59, 59, $month, $month_days, $year), 'authorized_categories' => $authorized_categories));
}
