* @copyright Radagast Solutions 2008-2011 * @link http://radagast.biz/ * */ function event_calendar_get_event_for_edit($event_id) { if ($event_id && $event = get_entity($event_id)) { if ($event->canEdit()) { return $event; } else { return false; } } else { return false; } } // returns the event or FALSE function event_calendar_set_event_from_form($event_guid,$group_guid) { $event_calendar_times = elgg_get_plugin_setting('times', 'event_calendar'); $event_calendar_region_display = elgg_get_plugin_setting('region_display', 'event_calendar'); $event_calendar_type_display = elgg_get_plugin_setting('type_display', 'event_calendar'); $event_calendar_spots_display = elgg_get_plugin_setting('spots_display', 'event_calendar'); $event_calendar_hide_end = elgg_get_plugin_setting('hide_end', 'event_calendar'); $event_calendar_more_required = elgg_get_plugin_setting('more_required', 'event_calendar'); $event_calendar_personal_manage = elgg_get_plugin_setting('personal_manage', 'event_calendar'); if ($event_calendar_more_required == 'yes') { $required_fields = array('title','venue','start_date', 'brief_description','fees','contact','organiser', 'tags'); if ($event_calendar_times == 'yes') { $required_fields[] = 'start_time'; if ($event_calendar_hide_end != 'yes') { $required_fields[] = 'end_time'; } } if ($event_calendar_region_display == 'yes') { $required_fields[] = 'region'; } if ($event_calendar_type_display == 'yes') { $required_fields[] = 'event_type'; } if ($event_calendar_spots_display == 'yes') { $required_fields[] = 'spots'; } } else { $required_fields = array('title','venue','start_date'); } if ($event_guid) { $event = get_entity($event_guid); if (!elgg_instanceof($event, 'object', 'event_calendar')) { // do nothing because this is a bad event guid return FALSE; } } else { $user_guid = elgg_get_logged_in_user_guid(); $event = new ElggObject(); $event->subtype = 'event_calendar'; $event->owner_guid = $user_guid; if ($group_guid) { $event->container_guid = $group_guid; } else { $event->container_guid = $event->owner_guid; } } $event->access_id = get_input('access_id'); $event->title = get_input('title'); $event->description = get_input('description'); $event->venue = get_input('venue'); // convert start date from current server time to GMT $start_date = get_input('start_date'); $start_date_text = date("Y-m-d",$start_date); $event->start_date = strtotime($start_date_text." ".date_default_timezone_get()); $event->end_date = get_input('end_date',''); if ($event_calendar_times == 'yes') { $sh = get_input('start_time_h',''); $sm = get_input('start_time_m',''); if (is_numeric($sh) && is_numeric($sm)) { // workaround for pulldown zero value bug $sh--; $sm--; $event->start_time = $sh*60+$sm; } else { $event->start_time = ''; } $eh = get_input('end_time_h',''); $em = get_input('end_time_m',''); if (is_numeric($eh) && is_numeric($em)) { // workaround for pulldown zero value bug $eh--; $em--; $event->end_time = $eh*60+$em; } else { $event->end_time = ''; } if (is_numeric($event->start_time)) { // Set start date to the Unix start time, if set. // This allows sorting by date *and* time. $event->start_date += $event->start_time*60; } } if ($event_calendar_spots_display == 'yes') { $event->spots = trim(get_input('spots')); } if ($event_calendar_region_display == 'yes') { $event->region = get_input('region'); } if ($event_calendar_type_display == 'yes') { $event->event_type = get_input('event_type'); } if ($event_calendar_personal_manage == 'by_event') { $event->personal_manage = get_input('personal_manage'); } $event->fees = get_input('fees'); $event->contact = get_input('contact'); $event->organiser = get_input('organiser'); $event->tags = string_to_tag_array(get_input('tags')); $event->long_description = get_input('long_description'); $event->real_end_time = event_calendar_get_end_time($event); foreach ($required_fields as $fn) { if (!trim($event->$fn)) { return FALSE; break; } } if ($event->save()) { if ($group_guid && (elgg_get_plugin_setting('autogroup', 'event_calendar') == 'yes')) { event_calendar_add_personal_events_from_group($event->guid,$group_guid); } if (elgg_get_plugin_setting('add_users', 'event_calendar') == 'yes') { if (function_exists('autocomplete_member_to_user')) { $addusers = get_input('adduser',array()); foreach($addusers as $adduser) { if ($adduser) { $user = autocomplete_member_to_user($adduser); $user_id = $user->guid; event_calendar_add_personal_event($event->guid,$user_id); if (elgg_get_plugin_setting('add_users_notify', 'event_calendar') == 'yes') { notify_user($user_id, $CONFIG->site->guid, elgg_echo('event_calendar:add_users_notify:subject'), sprintf( elgg_echo('event_calendar:add_users_notify:body'), $user->name, $event->title, $event->getURL() ) ); } } } } } } return $event; } function event_calendar_get_events_between($start_date,$end_date,$is_count,$limit=10,$offset=0,$container_guid=0,$region='-') { if ($is_count) { $count = event_calendar_get_entities_from_metadata_between2('start_date','end_date', $start_date, $end_date, "object", "event_calendar", 0, $container_guid, $limit,$offset,"",0,false,true,$region); return $count; } else { $events = event_calendar_get_entities_from_metadata_between2('start_date','end_date', $start_date, $end_date, "object", "event_calendar", 0, $container_guid, $limit,$offset,"",0,false,false,$region); //return event_calendar_vsort($events,'start_date'); return $events; } } function event_calendar_get_open_events_between($start_date,$end_date, $is_count,$limit=10,$offset=0,$container_guid=0,$region='-', $meta_max = 'spots', $annotation_name = 'personal_event') { if ($is_count) { $count = event_calendar_get_entities_from_metadata_between2('start_date','end_date', $start_date, $end_date, "object", "event_calendar", 0, $container_guid, $limit,$offset,"",0,false,true,$region,$meta_max,$annotation_name); return $count; } else { $events = event_calendar_get_entities_from_metadata_between2('start_date','end_date', $start_date, $end_date, "object", "event_calendar", 0, $container_guid, $limit,$offset,"",0,false,false,$region,$meta_max,$annotation_name); //return event_calendar_vsort($events,'start_date'); return $events; } } function event_calendar_get_events_for_user_between($start_date,$end_date,$is_count,$limit=10,$offset=0,$user_guid,$container_guid=0,$region='-') { if ($is_count) { // old way $count = event_calendar_get_entities_from_metadata_between('start_date','end_date', $start_date, $end_date, "object", "event_calendar", $user_guid, $container_guid, $limit,$offset,"",0,true,true,$region); return $count; } else { $events = event_calendar_get_entities_from_metadata_between('start_date','end_date', $start_date, $end_date, "object", "event_calendar", $user_guid, $container_guid, $limit,$offset,"",0,true,false,$region); //return event_calendar_vsort($events,'start_date'); return $events; } } function event_calendar_get_events_for_user_between2($start_date,$end_date,$is_count,$limit=10,$offset=0,$user_guid,$container_guid=0,$region='-') { $options_new_way = array( 'type' => 'object', 'subtype' => 'event_calendar', 'relationship' => 'personal_event', 'relationship_guid' => $user_guid, 'metadata_name_value_pairs' => array( array( 'name' => 'start_date', 'value' => $start_date, 'operand' => '>='), array( 'name' => 'real_end_time', 'value' => $end_date, 'operand' => '<=') ), ); if ($container_guid) { $options_new_way['container_guid'] = $container_guid; } if ($region && $region != '-') { $options_new_way['metadata_name_value_pairs'][] = array('name'=>'region','value'=>sanitize_string($region)); } if ($is_count) { // old way $count_old_way = event_calendar_get_entities_from_metadata_between('start_date','real_end_time', $start_date, $end_date, "object", "event_calendar", $user_guid, $container_guid, $limit,$offset,"",0,true,true,$region); // new way $options_new_way['count'] = TRUE; $count_new_way = elgg_get_entities_from_relationship($options_new_way); return $count_old_way+$count_new_way; } else { $events_old_way = event_calendar_get_entities_from_metadata_between('start_date','real_end_time', $start_date, $end_date, "object", "event_calendar", $user_guid, $container_guid, $limit,$offset,"",0,true,false,$region); $options_new_way['limit'] = $limit; $options_new_way['offset'] = $offset; $options_new_way['order_by_metadata'] = array(array('name'=>'start_date','direction'=>'ASC','as'=>'integer')); //print_r($options_new_way); $events_new_way = elgg_get_entities_from_relationship($options_new_way); //return event_calendar_vsort($events,'start_date'); if (!$events_old_way) { return $events_new_way; } else if (!$events_new_way) { return $events_old_way; } else { return array_merge($events_old_way,$events_new_way); } } } function event_calendar_get_events_for_friends_between($start_date,$end_date,$is_count,$limit=10,$offset=0,$user_guid,$container_guid=0,$region='-') { if ($user_guid) { $friends = get_user_friends($user_guid,"",5000); if ($friends) { $friend_guids = array(); foreach($friends as $friend) { $friend_guids[] = $friend->getGUID(); } $friend_list = implode(",",$friend_guids); // elgg_get_entities_from_relationship does not take multiple relationship guids, so need some custom joins and wheres $db_prefix = elgg_get_config('dbprefix'); $options_new_way = array( 'type' => 'object', 'subtype' => 'event_calendar', 'metadata_name_value_pairs' => array(array( 'name' => 'start_date', 'value' => $start_date, 'operand' => '>='), array( 'name' => 'real_end_time', 'value' => $end_date, 'operand' => '<=') ), 'joins' => array("JOIN {$db_prefix}entity_relationships r ON (r.guid_two = e.guid)"), 'wheres' => array("r.relationship = 'personal_event'","r.guid_one IN ($friend_list)"), ); if ($container_guid) { $options_new_way['container_guid'] = $container_guid; } if ($region && $region != '-') { $options_new_way['metadata_name_value_pairs'][] = array('name'=>'region','value'=>sanitize_string($region)); } if ($is_count) { $count_old_way = event_calendar_get_entities_from_metadata_between('start_date','end_date', $start_date, $end_date, "object", "event_calendar", $friend_guids, $container_guid, $limit,$offset,"",0,true,true,$region); $options_new_way['count'] = TRUE; $count_new_way = elgg_get_entities_from_metadata($options_new_way); return $count_old_way + $count_new_way; } else { $events_old_way = event_calendar_get_entities_from_metadata_between('start_date','end_date', $start_date, $end_date, "object", "event_calendar", $friend_guids, $container_guid, $limit,$offset,"",0,true,false,$region); //return event_calendar_vsort($events,'start_date'); $options_new_way['limit'] = $limit; $options_new_way['offset'] = $offset; $options_new_way['order_by_metadata'] = array(array('name'=>'start_date','direction'=>'ASC','as'=>'integer')); //print_r($options_new_way); $events_new_way = elgg_get_entities_from_metadata($options_new_way); if (!$events_old_way) { return $events_new_way; } else if (!$events_new_way) { return $events_old_way; } else { return array_merge($events_old_way,$events_new_way); } } } } return array(); } function event_calendar_vsort($original,$field, $descending = false) { if (!$original) { return $original; } $sortArr = array(); foreach ( $original as $key => $item ) { $sortArr[ $key ] = $item->$field; } if ( $descending ) { arsort( $sortArr ); } else { asort( $sortArr ); } $resultArr = array(); foreach ( $sortArr as $key => $value ) { $resultArr[ $key ] = $original[ $key ]; } return $resultArr; } // TODO - replace with Elgg API if possible /** * Return a list of entities based on the given search criteria. * In this case, returns entities with the given metadata between two values inclusive * * @param mixed $meta_start_name * @param mixed $meta_end_name * @param mixed $meta_start_value - start of metadata range, must be numerical value * @param mixed $meta_end_value - end of metadata range, must be numerical value * @param string $entity_type The type of entity to look for, eg 'site' or 'object' * @param string $entity_subtype The subtype of the entity. * @param mixed $owner_guid Either one integer user guid or an array of user guids * @param int $container_guid If supplied, the result is restricted to events associated with a specific container * @param int $limit * @param int $offset * @param string $order_by Optional ordering. * @param int $site_guid The site to get entities for. Leave as 0 (default) for the current site; -1 for all sites. * @param boolean $filter Filter by events in personal calendar if true * @param true|false $count If set to true, returns the total number of entities rather than a list. (Default: false) * * @return int|array A list of entities, or a count if $count is set to true */ function event_calendar_get_entities_from_metadata_between($meta_start_name, $meta_end_name, $meta_start_value, $meta_end_value, $entity_type = "", $entity_subtype = "", $owner_guid = 0, $container_guid = 0, $limit = 10, $offset = 0, $order_by = "", $site_guid = 0, $filter = false, $count = false, $region='-') { global $CONFIG; // This should not be possible, but a sanity check just in case if (!is_numeric($meta_start_value) || !is_numeric($meta_end_value)) { return FALSE; } $meta_start_n = get_metastring_id($meta_start_name); $meta_end_n = get_metastring_id($meta_end_name); if ($region && $region != '-') { $region_n = get_metastring_id('region'); $region_value_n = get_metastring_id($region); if (!$region_n || !$region_value_n) { if ($count) { return 0; } else { return FALSE; } } } $entity_type = sanitise_string($entity_type); $entity_subtype = get_subtype_id($entity_type, $entity_subtype); $limit = (int)$limit; $offset = (int)$offset; //if ($order_by == "") $order_by = "e.time_created desc"; if ($order_by == "") $order_by = "v.string asc"; $order_by = sanitise_string($order_by); $site_guid = (int) $site_guid; if ((is_array($owner_guid) && (count($owner_guid)))) { foreach($owner_guid as $key => $guid) { $owner_guid[$key] = (int) $guid; } } else { $owner_guid = (int) $owner_guid; } if ((is_array($container_guid) && (count($container_guid)))) { foreach($container_guid as $key => $guid) { $container_guid[$key] = (int) $guid; } } else { $container_guid = (int) $container_guid; } if ($site_guid == 0) $site_guid = $CONFIG->site_guid; //$access = get_access_list(); $where = array(); if ($entity_type!="") $where[] = "e.type='$entity_type'"; if ($entity_subtype) $where[] = "e.subtype=$entity_subtype"; $where[] = "m.name_id='$meta_start_n'"; $where[] = "m2.name_id='$meta_end_n'"; $where[] = "((v.string >= $meta_start_value AND v.string <= $meta_end_value) OR ( v2.string >= $meta_start_value AND v2.string <= $meta_end_value) OR (v.string <= $meta_start_value AND v2.string >= $meta_start_value) OR ( v2.string <= $meta_end_value AND v2.string >= $meta_end_value))"; if ($region && $region != '-') { $where[] = "m3.name_id='$region_n'"; $where[] = "m3.value_id='$region_value_n'"; } if ($site_guid > 0) $where[] = "e.site_guid = {$site_guid}"; if ($filter) { if (is_array($owner_guid)) { $where[] = "ms2.string in (".implode(",",$owner_guid).")"; } else if ($owner_guid > 0) { $where[] = "ms2.string = {$owner_guid}"; } $where[] = "ms.string = 'personal_event'"; } else { if (is_array($owner_guid)) { $where[] = "e.owner_guid in (".implode(",",$owner_guid).")"; } else if ($owner_guid > 0) { $where[] = "e.owner_guid = {$owner_guid}"; } } if (is_array($container_guid)) { $where[] = "e.container_guid in (".implode(",",$container_guid).")"; } else if ($container_guid > 0) $where[] = "e.container_guid = {$container_guid}"; if (!$count) { $query = "SELECT distinct e.* "; } else { $query = "SELECT count(distinct e.guid) as total "; } $query .= "from {$CONFIG->dbprefix}entities e JOIN {$CONFIG->dbprefix}metadata m on e.guid = m.entity_guid JOIN {$CONFIG->dbprefix}metadata m2 on e.guid = m2.entity_guid "; if ($filter) { $query .= "JOIN {$CONFIG->dbprefix}annotations a ON (a.entity_guid = e.guid) "; $query .= "JOIN {$CONFIG->dbprefix}metastrings ms ON (a.name_id = ms.id) "; $query .= "JOIN {$CONFIG->dbprefix}metastrings ms2 ON (a.value_id = ms2.id) "; } if ($region && $region != '-') { $query .= "JOIN {$CONFIG->dbprefix}metadata m3 ON (e.guid = m3.entity_guid) "; } $query .= "JOIN {$CONFIG->dbprefix}metastrings v on v.id = m.value_id JOIN {$CONFIG->dbprefix}metastrings v2 on v2.id = m2.value_id where"; foreach ($where as $w) $query .= " $w and "; $query .= get_access_sql_suffix("e"); // Add access controls $query .= ' and ' . get_access_sql_suffix("m"); // Add access controls $query .= ' and ' . get_access_sql_suffix("m2"); // Add access controls if (!$count) { $query .= " order by $order_by limit $offset, $limit"; // Add order and limit $entities = get_data($query, "entity_row_to_elggstar"); if (elgg_get_plugin_setting('add_to_group_calendar', 'event_calendar') == 'yes') { if (get_entity($container_guid) instanceOf ElggGroup) { $entities = event_calendar_get_entities_from_metadata_between_related($meta_start_name, $meta_end_name, $meta_start_value, $meta_end_value, $entity_type, $entity_subtype, $owner_guid, $container_guid, $limit = 10, $offset = 0, $order_by = "", $site_guid = 0, $filter = false, $count = false, $region='-',$entities); } } return $entities; } else { if ($row = get_data_row($query)) return $row->total; } return false; } // adds any related events (has the display_on_group relation) // that meet the appropriate criteria function event_calendar_get_entities_from_metadata_between_related($meta_start_name, $meta_end_name, $meta_start_value, $meta_end_value, $entity_type = "", $entity_subtype = "", $owner_guid = 0, $container_guid = 0, $limit = 10, $offset = 0, $order_by = "", $site_guid = 0, $filter = false, $count = false, $region='-',$main_events) { $main_list = array(); if ($main_events) { foreach ($main_events as $event) { $main_list[$event->guid] = $event; } } $related_list = array(); $related_events = elgg_get_entities_from_relationship(array( 'relationship' => 'display_on_group', 'relationship_guid' => $container_guid, 'inverse_relationship' => TRUE, )); if ($related_events) { foreach ($related_events as $event) { $related_list[$event->guid] = $event; } } // get all the events (across all containers) that meet the criteria $all_events = event_calendar_get_entities_from_metadata_between($meta_start_name, $meta_end_name, $meta_start_value, $meta_end_value, $entity_type, $entity_subtype, $owner_guid, 0, $limit, $offset, $order_by, $site_guid, $filter, $count, $region); if ($all_events) { foreach($all_events as $event) { if (array_key_exists($event->guid,$related_list) && !array_key_exists($event->guid,$main_list)) { // add to main events $main_events[] = $event; } } } return event_calendar_vsort($main_events,$meta_start_name); } // TODO: try to replace this with new Elgg 1.7 API /** * Return a list of entities based on the given search criteria. * In this case, returns entities with the given metadata between two values inclusive * * @param mixed $meta_start_name * @param mixed $meta_end_name * @param mixed $meta_start_value - start of metadata range, must be numerical value * @param mixed $meta_end_value - end of metadata range, must be numerical value * @param string $entity_type The type of entity to look for, eg 'site' or 'object' * @param string $entity_subtype The subtype of the entity. * @param mixed $owner_guid Either one integer user guid or an array of user guids * @param int $container_guid If supplied, the result is restricted to events associated with a specific container * @param int $limit * @param int $offset * @param string $order_by Optional ordering. * @param int $site_guid The site to get entities for. Leave as 0 (default) for the current site; -1 for all sites. * @param boolean $filter Filter by events in personal calendar if true * @param true|false $count If set to true, returns the total number of entities rather than a list. (Default: false) * @param string $meta_max metadata name containing maximum annotation count * @param string $annotation_name annotation name to count * * @return int|array A list of entities, or a count if $count is set to true */ function event_calendar_get_entities_from_metadata_between2 ($meta_start_name, $meta_end_name, $meta_start_value, $meta_end_value, $entity_type = "", $entity_subtype = "", $owner_guid = 0, $container_guid = 0, $limit = 10, $offset = 0, $order_by = "", $site_guid = 0, $filter = false, $count = false, $region='-', $meta_max = '', $annotation_name = '') { global $CONFIG; // This should not be possible, but a sanity check just in case if (!is_numeric($meta_start_value) || !is_numeric($meta_end_value)) { return FALSE; } $meta_start_n = get_metastring_id($meta_start_name); $meta_end_n = get_metastring_id($meta_end_name); if ($region && $region != '-') { $region_n = get_metastring_id('region'); $region_value_n = get_metastring_id($region); if (!$region_n || !$region_value_n) { if ($count) { return 0; } else { return false; } } } $entity_type = sanitise_string($entity_type); $entity_subtype = get_subtype_id($entity_type, $entity_subtype); $limit = (int)$limit; $offset = (int)$offset; //if ($order_by == "") $order_by = "e.time_created desc"; if ($order_by == "") $order_by = "v.string asc"; $order_by = sanitise_string($order_by); $site_guid = (int) $site_guid; if ((is_array($owner_guid) && (count($owner_guid)))) { foreach($owner_guid as $key => $guid) { $owner_guid[$key] = (int) $guid; } } else { $owner_guid = (int) $owner_guid; } if ((is_array($container_guid) && (count($container_guid)))) { foreach($container_guid as $key => $guid) { $container_guid[$key] = (int) $guid; } } else { $container_guid = (int) $container_guid; } if ($site_guid == 0) $site_guid = $CONFIG->site_guid; //$access = get_access_list(); $where = array(); if ($entity_type!="") $where[] = "e.type='$entity_type'"; if ($entity_subtype) $where[] = "e.subtype=$entity_subtype"; $where[] = "m.name_id='$meta_start_n'"; $where[] = "m2.name_id='$meta_end_n'"; $where[] = "((v.string >= $meta_start_value AND v.string <= $meta_end_value) OR ( v2.string >= $meta_start_value AND v2.string <= $meta_end_value) OR (v.string <= $meta_start_value AND v2.string >= $meta_start_value) OR ( v2.string <= $meta_end_value AND v2.string >= $meta_end_value))"; if ($region && $region != '-') { $where[] = "m3.name_id='$region_n'"; $where[] = "m3.value_id='$region_value_n'"; } if ($site_guid > 0) $where[] = "e.site_guid = {$site_guid}"; if ($filter) { if (is_array($owner_guid)) { $where[] = "ms2.string in (".implode(",",$owner_guid).")"; } else if ($owner_guid > 0) { $where[] = "ms2.string = {$owner_guid}"; } $where[] = "ms.string = 'personal_event'"; } else { if (is_array($owner_guid)) { $where[] = "e.owner_guid in (".implode(",",$owner_guid).")"; } else if ($owner_guid > 0) { $where[] = "e.owner_guid = {$owner_guid}"; } } if (is_array($container_guid)) { $where[] = "e.container_guid in (".implode(",",$container_guid).")"; } else if ($container_guid > 0) $where[] = "e.container_guid = {$container_guid}"; if (!$count) { $query = "SELECT distinct e.* "; } else { $query = "SELECT count(distinct e.guid) as total "; } $query .= "FROM {$CONFIG->dbprefix}entities e JOIN {$CONFIG->dbprefix}metadata m on e.guid = m.entity_guid JOIN {$CONFIG->dbprefix}metadata m2 on e.guid = m2.entity_guid "; if ($filter) { $query .= "JOIN {$CONFIG->dbprefix}annotations a ON (a.entity_guid = e.guid) "; $query .= "JOIN {$CONFIG->dbprefix}metastrings ms ON (a.name_id = ms.id) "; $query .= "JOIN {$CONFIG->dbprefix}metastrings ms2 ON (a.value_id = ms2.id) "; } if ($region && $region != '-') { $query .= "JOIN {$CONFIG->dbprefix}metadata m3 ON (e.guid = m3.entity_guid) "; } if ($meta_max && $annotation_name) { // This groups events for which the meta max name is defined // perhaps this should be a left join and accept null values? // so it would return groups with no spots defined as well $meta_max_n = get_metastring_id($meta_max); $ann_n = get_metastring_id($annotation_name); if (!$meta_max_n || !$ann_n) { if ($count) { return 0; } else { return false; } } $query .= " LEFT JOIN {$CONFIG->dbprefix}metadata m4 ON (e.guid = m4.entity_guid AND m4.name_id=$meta_max_n) "; $query .= " LEFT JOIN {$CONFIG->dbprefix}metastrings ms4 ON (m4.value_id = ms4.id) "; $where[] = "((ms4.string is null) OR (ms4.string = \"\") OR (CONVERT(ms4.string,SIGNED) > (SELECT count(id) FROM {$CONFIG->dbprefix}annotations ann WHERE ann.entity_guid = e.guid AND name_id = $ann_n GROUP BY entity_guid)))"; } $query .= "JOIN {$CONFIG->dbprefix}metastrings v on v.id = m.value_id JOIN {$CONFIG->dbprefix}metastrings v2 on v2.id = m2.value_id where"; foreach ($where as $w) $query .= " $w AND "; $query .= get_access_sql_suffix("e"); // Add access controls $query .= ' AND ' . get_access_sql_suffix("m"); // Add access controls $query .= ' AND ' . get_access_sql_suffix("m2"); // Add access controls if (!$count) { $query .= " order by $order_by limit $offset, $limit"; // Add order and limit return get_data($query, "entity_row_to_elggstar"); } else { if ($row = get_data_row($query)) return $row->total; } return false; } function event_calendar_has_personal_event($event_guid,$user_guid) { // check legacy implementation and new one if (check_entity_relationship($user_guid,'personal_event',$event_guid)) { return TRUE; } else { // use old method for now $options = array('guid'=>$event_guid,'annotation_name' => 'personal_event', 'annotation_value' => $user_guid,'count'=>TRUE); //$annotations = get_annotations($event_guid, "object", "event_calendar", "personal_event", (int) $user_guid, $user_guid); if (elgg_get_annotations($options)) { return TRUE; } else { return FALSE; } } } function event_calendar_add_personal_event($event_guid,$user_guid) { if ($event_guid && $user_guid) { if (!event_calendar_has_personal_event($event_guid,$user_guid) && !event_calendar_has_collision($event_guid,$user_guid)) { if (!event_calendar_is_full($event_guid)) { add_entity_relationship($user_guid,'personal_event',$event_guid); return TRUE; } } } return FALSE; } function event_calendar_add_personal_events_from_group($event_guid,$group_guid) { $members = get_group_members($group_guid, 100000); foreach($members as $member) { $member_id = $member->getGUID(); event_calendar_add_personal_event($event_guid,$member_id); } } function event_calendar_remove_personal_event($event_guid,$user_guid) { remove_entity_relationship($user_guid,'personal_event',$event_guid); // also use old method for now $annotations = get_annotations($event_guid, "object", "event_calendar", "personal_event", (int) $user_guid, $user_guid); if ($annotations) { foreach ($annotations as $annotation) { $annotation->delete(); } } } function event_calendar_get_personal_events_for_user($user_guid,$limit) { $events_old_way = elgg_get_entities_from_annotations(array( 'type' => 'object', 'subtype' => 'event_calendar', 'annotation_names' => 'personal_event', 'annotation_value' => $user_guid, 'limit' => 0, )); $events_new_way = elgg_get_entities_from_relationship(array( 'type' => 'object', 'subtype' => 'event_calendar', 'relationship' => 'personal_event', 'relationship_guid' => $user_guid, 'limit' => 0, )); $events = array_merge($events_old_way,$events_new_way); $final_events = array(); if ($events) { $now = time(); $one_day = 60*60*24; // don't show events that have been over for more than a day foreach($events as $event) { if (($event->start_date > $now-$one_day) || ($event->end_date && ($event->end_date > $now-$one_day))) { $final_events[] = $event; } } } $sorted = event_calendar_vsort($final_events,'start_date'); return array_slice($sorted,0,$limit); } // the old way used annotations, and the new Elgg 1.8 way uses relationships // for now this version attempts to bridge the gap by using both methods for older sites function event_calendar_get_users_for_event($event_guid,$limit,$offset,$is_count) { $options = array( 'type' => 'user', 'relationship' => 'personal_event', 'relationship_guid' => $event_guid, 'inverse_relationship' => TRUE, 'limit' => 0, ); if ($is_count) { //$count_old_way = count_annotations($event_guid, "object", "event_calendar", "personal_event"); $count_old_way = elgg_get_annotations(array( 'guid'=>$event_guid, 'type'=>"object", 'subtype'=>"event_calendar", 'annotation_name' => "personal_event", 'count'=>TRUE) ); $options ['count'] = TRUE; $count_new_way = elgg_get_entities_from_relationship($options); return $count_old_way + $count_new_way; } else { $users_old_way = array(); //$annotations = get_annotations($event_id, "object", "event_calendar", "personal_event", "", 0, $limit, $offset); $annotations = elgg_get_annotations(array( 'guid'=>$event_guid, 'type'=>"object", 'subtype'=>"event_calendar", 'annotation_name' => "personal_event", 'limit' => $limit, 'offset' => $offset) ); if ($annotations) { foreach($annotations as $annotation) { if (($user = get_entity($annotation->value)) && ($user instanceOf ElggUser)) { $users_old_way[] = $user; } } } $users_new_way = elgg_get_entities_from_relationship($options); return array_merge($users_old_way,$users_new_way); } } function event_calendar_security_fields() { $ts = time(); $token = generate_action_token($ts); return "__elgg_token=$token&__elgg_ts=$ts"; } function event_calendar_get_events_for_group($group_guid) { $options = array( 'type' => 'object', 'subtype' => 'event_calendar', 'container_guid' => $group_guid, 'limit' => 0, ); return elgg_get_entities($options); } function event_calendar_handle_join($event, $object_type, $object) { $group = $object['group']; $user = $object['user']; $user_guid = $user->getGUID(); $events = event_calendar_get_events_for_group($group->getGUID()); foreach ($events as $event) { $event_id = $event->getGUID(); event_calendar_add_personal_event($event_id,$user_guid); } } function event_calendar_handle_leave($event, $object_type, $object) { $group = $object['group']; $user = $object['user']; $user_guid = $user->getGUID(); $events = event_calendar_get_events_for_group($group->getGUID()); foreach ($events as $event) { $event_id = $event->getGUID(); event_calendar_remove_personal_event($event_id,$user_guid); } } function event_calendar_convert_time($time) { $hour = floor($time/60); $minute = sprintf("%02d",$time-60*$hour); return "$hour:$minute"; } function event_calendar_format_time($date,$time1,$time2='') { if (is_numeric($time1)) { $t = event_calendar_convert_time($time1); if (is_numeric($time2)) { $t .= " - ".event_calendar_convert_time($time2); } return "$t, $date"; } else { return $date; } } function event_calender_get_gmt_from_server_time($server_time) { $gmtime = $server_time - (int)substr(date('O'),0,3)*60*60; } function event_calendar_activated_for_group($group) { $group_calendar = elgg_get_plugin_setting('group_calendar', 'event_calendar'); $group_default = elgg_get_plugin_setting('group_default', 'event_calendar'); if ($group && ($group_calendar != 'no')) { if ( ($group->event_calendar_enable == 'yes') || ((!$group->event_calendar_enable && (!$group_default || $group_default == 'yes')))) { return true; } } return false; } function event_calendar_get_region($event) { $event_calendar_region_list_handles = elgg_get_plugin_setting('region_list_handles', 'event_calendar'); $region = trim($event->region); if ($event_calendar_region_list_handles == 'yes') { $region = elgg_echo('event_calendar:region:'.$region); } return htmlspecialchars($region); } function event_calendar_get_type($event) { $event_calendar_type_list_handles = elgg_get_plugin_setting('type_list_handles', 'event_calendar'); $type = trim($event->event_type); if ($event_calendar_type_list_handles == 'yes') { $type = elgg_echo('event_calendar:type:'.$type); } return htmlspecialchars($type); } function event_calendar_get_formatted_full_items($event) { $time_bit = event_calendar_get_formatted_time($event); $event_calendar_region_display = elgg_get_plugin_setting('region_display', 'event_calendar'); $event_calendar_type_display = elgg_get_plugin_setting('type_display', 'event_calendar'); $event_items = array(); $item = new stdClass(); $item->title = elgg_echo('event_calendar:when_label'); $item->value = $time_bit; $event_items[] = $item; $item = new stdClass(); $item->title = elgg_echo('event_calendar:venue_label'); $item->value = htmlspecialchars($event->venue); $event_items[] = $item; if ($event_calendar_region_display == 'yes') { $item = new stdClass(); $item->title = elgg_echo('event_calendar:region_label'); $item->value = event_calendar_get_region($event); $event_items[] = $item; } if ($event_calendar_type_display == 'yes') { $item = new stdClass(); $item->title = elgg_echo('event_calendar:type_label'); $item->value = event_calendar_get_type($event); $event_items[] = $item; } $item = new stdClass(); $item->title = elgg_echo('event_calendar:fees_label'); $item->value = htmlspecialchars($event->fees); $event_items[] = $item; $item = new stdClass(); $item->title = elgg_echo('event_calendar:organiser_label'); $item->value = htmlspecialchars($event->organiser); $event_items[] = $item; $item = new stdClass(); $item->title = elgg_echo('event_calendar:contact_label'); $item->value = htmlspecialchars($event->contact); $event_items[] = $item; return $event_items; } function event_calendar_get_formatted_time($event) { $date_format = 'j M Y'; $event_calendar_times = elgg_get_plugin_setting('times', 'event_calendar') == 'yes'; $start_date = date($date_format,$event->start_date); if ((!$event->end_date) || ($event->end_date == $event->start_date)) { if ($event_calendar_times) { $start_date = event_calendar_format_time($start_date,$event->start_time,$event->end_time); } $time_bit = $start_date; } else { $end_date = date($date_format,$event->end_date); if ($event_calendar_times) { $start_date = event_calendar_format_time($start_date,$event->start_time); $end_date = event_calendar_format_time($end_date,$event->end_time); } $time_bit = "$start_date - $end_date"; } return $time_bit; } function event_calendar_get_formatted_date($ts) { // TODO: make the date format configurable return date('j/n/Y',$ts); } function event_calendar_is_full($event_id) { $event_calendar_spots_display = elgg_get_plugin_setting('spots_display', 'event_calendar'); if ($event_calendar_spots_display == 'yes') { $count = event_calendar_get_users_for_event($event_id,0,0,TRUE); $event = get_entity($event_id); if ($event) { $spots = $event->spots; if (is_numeric($spots)) { if ($count >= $spots) { return TRUE; } } } } return FALSE; } function event_calendar_has_collision($event_id, $user_id) { $no_collisions = elgg_get_plugin_setting('no_collisions', 'event_calendar'); if ($no_collisions == 'yes') { $event = get_entity($event_id); if ($event) { $start_time = $event->start_date; $end_time = event_calendar_get_end_time($event); // look to see if the user already has events within this period $count = event_calendar_get_events_for_user_between2($start_time,$end_time,TRUE,10,0,$user_id); if ($count > 0) { return TRUE; } else { return FALSE; } } } return FALSE; } // this complicated bit of code determines the event end time function event_calendar_get_end_time($event) { $default_length = elgg_get_plugin_setting('collision_length', 'event_calendar'); $start_time = $event->start_date; $end_time = $event->end_time; $end_date = $event->end_date; if($end_date) { if ($end_time) { $end_time = $end_date+$end_time*60; } else if ($start_time == $end_date) { if (is_numeric($default_length)) { $end_time = $end_date + $default_length; } else { // default to an hour length $end_time = $start_time + 3600; } } else { $end_time = $end_date; } } else { if ($end_time) { if ($event->start_time) { $end_time = $start_time + ($end_time*60 - $event->start_time*60); } else { $end_time = $start_time + $end_time*60; } } else { if (is_numeric($default_length)) { $end_time = $start_time + $default_length; } else { // default to an hour length $end_time = $start_time + 3600; } } } return $end_time; } // a version to allow for some customised options function event_calendar_view_entity_list($entities, $count, $offset, $limit, $fullview = true, $viewtypetoggle = true, $pagination = true) { $count = (int) $count; $limit = (int) $limit; // do not require views to explicitly pass in the offset if (!$offset = (int) $offset) { $offset = sanitise_int(get_input('offset', 0)); } $context = elgg_get_context(); $html = elgg_view('event_calendar/entities/entity_list',array( 'entities' => $entities, 'count' => $count, 'offset' => $offset, 'limit' => $limit, 'baseurl' => $_SERVER['REQUEST_URI'], 'fullview' => $fullview, 'context' => $context, 'viewtypetoggle' => $viewtypetoggle, 'viewtype' => get_input('search_viewtype','list'), 'pagination' => $pagination )); return $html; } // returns open, closed or private for the given event and user function event_calendar_personal_can_manage($event,$user_id) { $status = 'private'; $event_calendar_personal_manage = elgg_get_plugin_setting('personal_manage', 'event_calendar'); if (!$event_calendar_personal_manage || $event_calendar_personal_manage == 'open' || $event_calendar_personal_manage == 'yes' || (($event_calendar_personal_manage == 'by_event' && (!$event->personal_manage || ($event->personal_manage == 'open'))))) { $status = 'open'; } else { // in this case only admins or event owners can manage events on their personal calendars if(elgg_is_admin_logged_in()) { $status = 'open'; } else if ($event && ($event->owner_guid == $user_id)) { $status = 'open'; } else if (($event_calendar_personal_manage == 'closed') || ($event_calendar_personal_manage == 'no') || (($event_calendar_personal_manage == 'by_event') && ($event->personal_manage == 'closed'))) { $status = 'closed'; } } return $status; } function event_calendar_send_event_request($event,$user_guid) { $result = FALSE; if(add_entity_relationship($user_guid, 'event_calendar_request', $event->guid)) { $subject = elgg_echo('event_calendar:request_subject'); $name = get_entity($user_guid)->name; $title = $event->title; $url = $event->getUrl(); $link = elgg_get_site_url().'event_calendar/review_requests/'.$event->guid; $message = sprintf(elgg_echo('event_calendar:request_message'),$name,$title,$url,$link); notify_user($event->owner_guid,elgg_get_site_entity()->guid,$subject,$message); $result = TRUE; } return $result; } // pages function event_calendar_get_page_content_list($page_type,$container_guid,$start_date,$display_mode,$filter,$region='-') { elgg_load_js('elgg.event_calendar'); global $autofeed; $autofeed = true; if ($page_type == 'group') { if (!event_calendar_activated_for_group($container_guid)) { forward(); } elgg_push_breadcrumb(elgg_echo('event_calendar:group_breadcrumb')); elgg_push_context('groups'); elgg_set_page_owner_guid($container_guid); $user_guid = elgg_get_logged_in_user_guid(); $group_calendar = elgg_get_plugin_setting('group_calendar', 'event_calendar'); if (!$group_calendar || $group_calendar == 'members') { if (elgg_get_page_owner_entity()->canWriteToContainer($user_guid)){ elgg_register_menu_item('title', array( 'name' => 'add', 'href' => "event_calendar/add/".$container_guid, 'text' => elgg_echo('event_calendar:add'), 'class' => 'elgg-button elgg-button-action', )); } } else if ($group_calendar == 'admin') { if (elgg_is_admin_logged_in() || ($group->owner_guid == $user_guid)) { elgg_register_menu_item('title', array( 'name' => 'add', 'href' => "event_calendar/add/".$container_guid, 'text' => elgg_echo('event_calendar:add'), 'class' => 'elgg-button elgg-button-action', )); } } } else { elgg_push_breadcrumb(elgg_echo('item:object:event_calendar')); $site_calendar = elgg_get_plugin_setting('site_calendar', 'event_calendar'); if (!$site_calendar || $site_calendar == 'admin') { // only admins can post directly to the site-wide calendar if (elgg_is_admin_logged_in()) { elgg_register_menu_item('title', array( 'name' => 'add', 'href' => "event_calendar/add", 'text' => elgg_echo('event_calendar:add'), 'class' => 'elgg-button elgg-button-action', )); } } else if ($site_calendar == 'loggedin') { // any logged-in user can post to the site calendar if (elgg_is_logged_in()) { elgg_register_menu_item('title', array( 'name' => 'add', 'href' => "event_calendar/add", 'text' => elgg_echo('event_calendar:add'), 'class' => 'elgg-button elgg-button-action', )); } } } $params = event_calendar_generate_listing_params($page_type,$container_guid,$start_date,$display_mode,$filter,$region); $url = full_url(); if (substr_count($url, '?')) { $url .= "&view=ical"; } else { $url .= "?view=ical"; } $url = elgg_format_url($url); $menu_options = array( 'name' => 'ical', 'id' => 'event-calendar-ical-link', 'text' => '', 'href' => $url, 'title' => elgg_echo('feed:ical'), 'priority' => 800, ); $menu_item = ElggMenuItem::factory($menu_options); elgg_register_menu_item('extras', $menu_item); $body = elgg_view_layout("content", $params); return elgg_view_page($title,$body); } function event_calendar_get_page_content_edit($page_type,$guid) { $vars = array(); $vars['id'] = 'event-calendar-edit'; $vars['name'] = 'event_calendar_edit'; // just in case a feature adds an image upload $vars['enctype'] = 'multipart/form-data'; $body_vars = array(); if ($page_type == 'edit') { $title = elgg_echo('event_calendar:manage_event_title'); $event = get_entity((int)$guid); if (elgg_instanceof($event, 'object', 'event_calendar') && $event->canEdit()) { $body_vars['event'] = $event; $body_vars['form_data'] = event_calendar_prepare_edit_form_vars($event); $event_container = get_entity($event->container_guid); if (elgg_instanceof($event_container, 'group')) { elgg_push_breadcrumb(elgg_echo('event_calendar:group_breadcrumb'), 'event_calendar/group/'.$event->container_guid); } else { elgg_push_breadcrumb(elgg_echo('event_calendar:show_events_title'),'event_calendar/list'); } elgg_push_breadcrumb(elgg_echo('event_calendar:manage_event_title')); $content = elgg_view_form('event_calendar/edit', $vars,$body_vars); } else { $content = elgg_echo('event_calendar:error_event_edit'); } } else { $title = elgg_echo('event_calendar:add_event_title'); if ($guid) { // add to group $group = get_entity($guid); if (elgg_instanceof($group, 'group')) { $body_vars['group_guid'] = $guid; elgg_push_breadcrumb(elgg_echo('event_calendar:group_breadcrumb'), 'event_calendar/group/'.$guid); elgg_push_breadcrumb(elgg_echo('event_calendar:add_event_title')); $body_vars['form_data'] = event_calendar_prepare_edit_form_vars(); $content = elgg_view_form('event_calendar/edit', $vars, $body_vars); } else { $content = elgg_echo('event_calendar:no_group'); } } else { elgg_push_breadcrumb(elgg_echo('event_calendar:show_events_title'),'event_calendar/list'); elgg_push_breadcrumb(elgg_echo('event_calendar:add_event_title')); $body_vars['form_data'] = event_calendar_prepare_edit_form_vars(); $content = elgg_view_form('event_calendar/edit', $vars, $body_vars); } } $params = array('title' => $title, 'content' => $content,'filter' => ''); $body = elgg_view_layout("content", $params); return elgg_view_page($title,$body); } /** * Pull together variables for the edit form * * @param ElggObject $event * @return array */ function event_calendar_prepare_edit_form_vars($event = NULL) { // input names => defaults $values = array( 'title' => NULL, 'description' => NULL, 'venue' => NULL, 'start_date' => NULL, 'end_date' => NULL, 'start_time' => NULL, 'end_time' => NULL, 'spots' => NULL, 'region' => '-', 'event_type' => '-', 'fees' => NULL, 'contact' => NULL, 'organiser' => NULL, 'tags' => NULL, 'personal_manage' => NULL, 'long_description' => NULL, 'access_id' => ACCESS_DEFAULT, 'group_guid' => NULL, ); if ($event) { foreach (array_keys($values) as $field) { if (isset($event->$field)) { $values[$field] = $event->$field; } } } if (elgg_is_sticky_form('event_calendar')) { $sticky_values = elgg_get_sticky_values('event_calendar'); foreach ($sticky_values as $key => $value) { $values[$key] = $value; } } elgg_clear_sticky_form('event_calendar'); return $values; } function event_calendar_generate_listing_params($page_type,$container_guid,$original_start_date,$display_mode,$filter,$region='-') { $event_calendar_listing_format = elgg_get_plugin_setting('listing_format', 'event_calendar'); $event_calendar_spots_display = trim(elgg_get_plugin_setting('spots_display', 'event_calendar')); $event_calendar_first_date = trim(elgg_get_plugin_setting('first_date', 'event_calendar')); $event_calendar_last_date = trim(elgg_get_plugin_setting('last_date', 'event_calendar')); if (!$original_start_date) { $original_start_date = date('Y-m-d'); } if ( $event_calendar_first_date && ($original_start_date < $event_calendar_first_date) ) { $original_start_date = $event_calendar_first_date; } if ( $event_calendar_last_date && ($original_start_date > $event_calendar_last_date) ) { $original_start_date = $event_calendar_first_date; } if ($event_calendar_listing_format == 'paged') { $start_ts = strtotime($original_start_date); $start_date = $original_start_date; if ($event_calendar_last_date) { $end_ts = strtotime($event_calendar_last_date); } else { // set to a large number $end_ts = 2000000000; } $mode = 'paged'; } else { // the default interval is one month $day = 60*60*24; $week = 7*$day; $month = 31*$day; $mode = trim($display_mode); if (!$mode) { $mode = 'month'; } if ($mode == "day") { $start_date = $original_start_date; $end_date = $start_date; $start_ts = strtotime($start_date); $end_ts = strtotime($end_date)+$day-1; } else if ($mode == "week") { // need to adjust start_date to be the beginning of the week $start_ts = strtotime($original_start_date); $start_ts -= date("w",$start_ts)*$day; $end_ts = $start_ts + 6*$day; $start_date = date('Y-m-d',$start_ts); $end_date = date('Y-m-d',$end_ts); } else { $start_ts = strtotime($original_start_date); $month = date('m',$start_ts); $year = date('Y',$start_ts); $start_date = $year.'-'.$month.'-1'; $end_date = $year.'-'.$month.'-'.getLastDayOfMonth($month,$year); } if ($event_calendar_first_date && ($start_date < $event_calendar_first_date)) { $start_date = $event_calendar_first_date; } if ($event_calendar_last_date && ($end_date > $event_calendar_last_date)) { $end_date = $event_calendar_last_date; } $start_ts = strtotime($start_date); if ($mode == "day") { $end_ts = strtotime($end_date)+$day-1; $subtitle = elgg_echo('event_calendar:day_label').': '.date('j F Y',strtotime($start_date)); } else if ($mode == "week") { // KJ - fix for end date bug //$end_ts = $start_ts + 6*$day; $end_ts = $start_ts + 7*$day; $subtitle = elgg_echo('event_calendar:week_label').': '.date('j F',$start_ts) . ' - '.date('j F Y',$end_ts); } else { // KJ - fix for end date bug //$end_ts = strtotime($end_date); $end_ts = strtotime($end_date)+24*60*60-1; $subtitle = date('F Y',$start_ts); } } $current_user_guid = elgg_get_logged_in_user_guid(); $access_status = elgg_get_ignore_access(); if ($page_type == 'owner') { $container = get_entity($container_guid); if (elgg_instanceof($container, 'user')) { $auth_token = get_input('auth_token'); if ($auth_token) { $secret_key = event_calendar_get_secret_key(); if ($secret_key && ($auth_token === sha1($container->username . $secret_key))) { elgg_set_ignore_access(TRUE); } } if ($container->canEdit()) { $user_guid = $container_guid; $group_guid = 0; } else { register_error('event_calendar:owner:permissions_error'); forward(); exit; } } else { register_error('event_calendar:owner:permissions_error'); forward(); exit; } } else { $user_guid = $current_user_guid; $group_guid = $container_guid; } $offset = get_input('offset'); $limit = get_input('limit',15); if ($event_calendar_spots_display == 'yes') { if (!$filter) { $filter = 'open'; } } else { if (!$filter) { $filter = 'all'; } } if ($filter == 'all') { $count = event_calendar_get_events_between($start_ts,$end_ts,true,$limit,$offset,$container_guid,$region); $events = event_calendar_get_events_between($start_ts,$end_ts,false,$limit,$offset,$container_guid,$region); } else if ($filter == 'open') { $count = event_calendar_get_open_events_between($start_ts,$end_ts,true,$limit,$offset,$container_guid,$region); $events = event_calendar_get_open_events_between($start_ts,$end_ts,false,$limit,$offset,$container_guid,$region); } else if ($filter == 'friends') { $count = event_calendar_get_events_for_friends_between($start_ts,$end_ts,true,$limit,$offset,$user_guid,$container_guid,$region); $events = event_calendar_get_events_for_friends_between($start_ts,$end_ts,false,$limit,$offset,$user_guid,$container_guid,$region); } else if ($filter == 'mine') { $count = event_calendar_get_events_for_user_between2($start_ts,$end_ts,true,$limit,$offset,$user_guid,$container_guid,$region); $events = event_calendar_get_events_for_user_between2($start_ts,$end_ts,false,$limit,$offset,$user_guid,$container_guid,$region); } $vars = array( 'original_start_date' => $original_start_date, 'start_date' => $start_date, 'end_date' => $end_date, 'first_date' => $event_calendar_first_date, 'last_date' => $event_calendar_last_date, 'mode' => $mode, 'events' => $events, 'count' => $count, 'offset' => $offset, 'limit' => $limit, 'group_guid' => $group_guid, 'filter' => $filter, 'region' => $region, 'listing_format' => $event_calendar_listing_format, ); $content = elgg_view('event_calendar/show_events', $vars); if ($page_type == 'owner') { $filter_override = ''; } else { $filter_override = elgg_view('event_calendar/filter_menu',$vars); } if ($event_calendar_listing_format == 'paged') { $title = elgg_echo('event_calendar:upcoming_events_title'); } else if ($page_type == 'group') { $title = elgg_echo('event_calendar:group'). ' ('.$subtitle.')'; } else { $title = elgg_echo('event_calendar:listing_title:'.$filter). ' ('.$subtitle.')'; } $params = array('title' => $title, 'content' => $content, 'filter_override'=>$filter_override); elgg_set_ignore_access($access_status); return $params; } function event_calendar_get_page_content_view($event_guid) { // add personal calendar button and links elgg_push_context('event_calendar:view'); $event = get_entity($event_guid); if (!elgg_instanceof($event, 'object', 'event_calendar')) { $content = elgg_echo('event_calendar:error_nosuchevent'); $title = elgg_echo('event_calendar:generic_error_title'); } else { $title = htmlspecialchars($event->title); $event_container = get_entity($event->container_guid); if (elgg_instanceof($event_container, 'group')) { if ($event_container->canEdit()) { event_calendar_handle_menu($event_guid); } elgg_push_breadcrumb(elgg_echo('event_calendar:group_breadcrumb'), 'event_calendar/group/'.$event->container_guid); } else { if ($event->canEdit()) { event_calendar_handle_menu($event_guid); } elgg_push_breadcrumb(elgg_echo('event_calendar:show_events_title'),'event_calendar/list'); } elgg_push_breadcrumb($event->title); $content = elgg_view_entity($event, array('full_view' => true)); //check to see if comment are on - TODO - add this feature to all events if ($event->comments_on != 'Off') { $content .= elgg_view_comments($event); } } $params = array('title' => $title, 'content' => $content,'filter' => ''); $body = elgg_view_layout("content", $params); return elgg_view_page($title,$body); } function event_calendar_get_page_content_display_users($event_guid) { elgg_load_js('elgg.event_calendar'); $event = get_entity($event_guid); if (!elgg_instanceof($event, 'object', 'event_calendar')) { $content = elgg_echo('event_calendar:error_nosuchevent'); $title = elgg_echo('event_calendar:generic_error_title'); } else { event_calendar_handle_menu($event_guid); $title = elgg_echo('event_calendar:users_for_event_title',array(htmlspecialchars($event->title))); $event_container = get_entity($event->container_guid); if (elgg_instanceof($event_container, 'group')) { elgg_push_context('groups'); elgg_set_page_owner_guid($event->container_guid); elgg_push_breadcrumb(elgg_echo('event_calendar:group_breadcrumb'), 'event_calendar/group/'.$event->container_guid); } else { elgg_push_breadcrumb(elgg_echo('event_calendar:show_events_title'),'event_calendar/list'); } elgg_push_breadcrumb($event->title,$event->getURL()); elgg_push_breadcrumb(elgg_echo('event_calendar:users_for_event_breadcrumb')); $limit = 12; $offset = get_input('offset', 0); $users = event_calendar_get_users_for_event($event_guid,$limit,$offset,false); $options = array( 'full_view' => FALSE, 'list_type_toggle' => FALSE, 'limit'=>$limit, 'event_calendar_event'=>$event, ); elgg_extend_view('user/default','event_calendar/calendar_toggle'); $content = elgg_view_entity_list($users,$options); } $params = array('title' => $title, 'content' => $content,'filter' => ''); $body = elgg_view_layout("content", $params); return elgg_view_page($title,$body); } // display a list of all the members of the container of $event_guid and allowing // adding or removing them function event_calendar_get_page_content_manage_users($event_guid) { // TODO: make this an optional feature, toggled off elgg_load_js('elgg.event_calendar'); $event = get_entity($event_guid); $limit = 10; $offset = get_input('offset', 0); $event_calendar_add_users = elgg_get_plugin_setting('add_users', 'event_calendar'); if ($event_calendar_add_users != 'yes') { register_error(elgg_echo('event_calendar:feature_not_activated')); forward(); exit; } if (!elgg_instanceof($event, 'object', 'event_calendar')) { $content = elgg_echo('event_calendar:error_nosuchevent'); $title = elgg_echo('event_calendar:generic_error_title'); } else { event_calendar_handle_menu($event_guid); $title = elgg_echo('event_calendar:manage_users:title',array($event->title)); $event_container = get_entity($event->container_guid); if ($event_container->canEdit()) { if (elgg_instanceof($event_container, 'group')) { elgg_push_context('groups'); elgg_set_page_owner_guid($event->container_guid); elgg_push_breadcrumb(elgg_echo('event_calendar:group_breadcrumb'), 'event_calendar/group/'.$event->container_guid); elgg_register_menu_item('title', array( 'name' => 'remove_from_group_members', 'href' => elgg_add_action_tokens_to_url('action/event_calendar/remove_from_group_members?event_guid='.$event_guid), 'text' => elgg_echo('event_calendar:remove_from_group_members:button'), 'class' => 'elgg-button elgg-button-action', )); elgg_register_menu_item('title', array( 'name' => 'add_to_group_members', 'href' => elgg_add_action_tokens_to_url('action/event_calendar/add_to_group_members?event_guid='.$event_guid), 'text' => elgg_echo('event_calendar:add_to_group_members:button'), 'class' => 'elgg-button elgg-button-action', )); $users = $event_container->getMembers($limit,$offset); $count = $event_container->getMembers($limit,$offset,TRUE); elgg_extend_view('user/default','event_calendar/calendar_toggle'); $options = array( 'full_view' => FALSE, 'list_type_toggle' => FALSE, 'limit'=>$limit, 'event_calendar_event'=>$event, 'pagination' => TRUE, 'count'=>$count, ); $content .= elgg_view_entity_list($users,$options,$offset,$limit); } else { elgg_push_breadcrumb(elgg_echo('event_calendar:show_events_title'),'event_calendar/list'); $content = '

'.elgg_echo('event_calendar:manage_users:description').'

'; $content .= elgg_view_form('event_calendar/manage_subscribers',array(),array('event'=>$event)); } elgg_push_breadcrumb($event->title,$event->getURL()); elgg_push_breadcrumb(elgg_echo('event_calendar:manage_users:breadcrumb')); } else { $content = elgg_echo('event_calendar:manage_users:unauthorized'); } } $params = array('title' => $title, 'content' => $content,'filter' => ''); $body = elgg_view_layout("content", $params); return elgg_view_page($title,$body); } function event_calendar_get_page_content_review_requests($event_guid) { $event = get_entity($event_guid); if (!elgg_instanceof($event, 'object', 'event_calendar')) { $content = elgg_echo('event_calendar:error_nosuchevent'); $title = elgg_echo('event_calendar:generic_error_title'); } else { event_calendar_handle_menu($event_guid); $title = elgg_echo('event_calendar:review_requests_title',array(htmlspecialchars($event->title))); $event_container = get_entity($event->container_guid); if (elgg_instanceof($event_container, 'group')) { elgg_push_context('groups'); elgg_set_page_owner_guid($event->container_guid); elgg_push_breadcrumb(elgg_echo('event_calendar:group_breadcrumb'), 'event_calendar/group/'.$event->container_guid); } else { elgg_push_breadcrumb(elgg_echo('event_calendar:show_events_title'),'event_calendar/list'); } elgg_push_breadcrumb($event->title,$event->getURL()); elgg_push_breadcrumb(elgg_echo('event_calendar:review_requests_menu_title')); if ($event->canEdit()) { $requests = elgg_get_entities_from_relationship( array( 'relationship' => 'event_calendar_request', 'relationship_guid' => $event_guid, 'inverse_relationship' => TRUE, 'limit' => 0) ); if ($requests) { $content = elgg_view('event_calendar/review_requests',array('requests' => $requests, 'entity' => $event)); } else { $content = elgg_echo('event_calendar:review_requests_request_none'); } } else { $content = elgg_echo('event_calendar:review_requests_error'); } } $params = array('title' => $title, 'content' => $content,'filter' => ''); $body = elgg_view_layout("content", $params); return elgg_view_page($title,$body); } function event_calendar_handle_menu($event_guid) { $event = get_entity($event_guid); $event_calendar_personal_manage = elgg_get_plugin_setting('personal_manage', 'event_calendar'); if ((($event_calendar_personal_manage == 'by_event') && ($event->personal_manage == 'closed')) || (($event_calendar_personal_manage == 'closed') || ($event_calendar_personal_manage == 'no'))) { $url = "event_calendar/review_requests/$event_guid"; $item = new ElggMenuItem('event-calendar-0review_requests', elgg_echo('event_calendar:review_requests_menu_title'), $url); $item->setSection('event_calendar'); elgg_register_menu_item('page', $item); //add_submenu_item(elgg_echo('event_calendar:review_requests_title'), $CONFIG->wwwroot . "pg/event_calendar/review_requests/".$event_id, '0eventcalendaradmin'); } $event_calendar_add_users = elgg_get_plugin_setting('add_users', 'event_calendar'); if ($event_calendar_add_users == 'yes') { $url = "event_calendar/manage_users/$event_guid"; $item = new ElggMenuItem('event-calendar-1manage_users', elgg_echo('event_calendar:manage_users:breadcrumb'), $url); $item->setSection('event_calendar'); elgg_register_menu_item('page', $item); } } function event_calendar_get_secret_key() { $key_file_name = elgg_get_plugin_setting('ical_auth_file_name','event_calendar'); if ($key_file_name && file_exists($key_file_name)) { $key = (require($key_file_name)); return $key['tokenSecretKey']; } else { return FALSE; } } function getLastDayOfMonth($month,$year) { return idate('d', mktime(0, 0, 0, ($month + 1), 0, $year)); }