--- /dev/null
+<?php
+
+/**
+ * Calendar plugin for Roundcube webmail
+ *
+ * @version @package_version@
+ * @author Lazlo Westerhof <hello@lazlo.me>
+ * @author Thomas Bruederli <bruederli@kolabsys.com>
+ *
+ * Copyright (C) 2010, Lazlo Westerhof <hello@lazlo.me>
+ * Copyright (C) 2012, Kolab Systems AG <contact@kolabsys.com>
+ *
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Affero General Public License as
+ * published by the Free Software Foundation, either version 3 of the
+ * License, or (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Affero General Public License for more details.
+ *
+ * You should have received a copy of the GNU Affero General Public License
+ * along with this program. If not, see <http://www.gnu.org/licenses/>.
+ */
+
+class calendar extends rcube_plugin
+{
+ const FREEBUSY_UNKNOWN = 0;
+ const FREEBUSY_FREE = 1;
+ const FREEBUSY_BUSY = 2;
+ const FREEBUSY_TENTATIVE = 3;
+ const FREEBUSY_OOF = 4;
+
+ const SESSION_KEY = 'calendar_temp';
+
+ public $task = '?(?!logout).*';
+ public $rc;
+ public $lib;
+ public $driver;
+ public $home; // declare public to be used in other classes
+ public $urlbase;
+ public $timezone;
+ public $timezone_offset;
+ public $gmt_offset;
+
+ public $ical;
+ public $ui;
+
+ public $defaults = array(
+ 'calendar_default_view' => "agendaWeek",
+ 'calendar_timeslots' => 2,
+ 'calendar_work_start' => 6,
+ 'calendar_work_end' => 18,
+ 'calendar_agenda_range' => 60,
+ 'calendar_agenda_sections' => 'smart',
+ 'calendar_event_coloring' => 0,
+ 'calendar_time_indicator' => true,
+ 'calendar_allow_invite_shared' => false,
+ );
+
+ private $ics_parts = array();
+
+
+ /**
+ * Plugin initialization.
+ */
+ function init()
+ {
+ $this->require_plugin('libcalendaring');
+
+ $this->rc = rcube::get_instance();
+ $this->lib = libcalendaring::get_instance();
+
+ $this->register_task('calendar', 'calendar');
+
+ // load calendar configuration
+ $this->load_config();
+
+ // load localizations
+ $this->add_texts('localization/', $this->rc->task == 'calendar' && (!$this->rc->action || $this->rc->action == 'print'));
+
+ $this->timezone = $this->lib->timezone;
+ $this->gmt_offset = $this->lib->gmt_offset;
+ $this->dst_active = $this->lib->dst_active;
+ $this->timezone_offset = $this->gmt_offset / 3600 - $this->dst_active;
+
+ require($this->home . '/lib/calendar_ui.php');
+ $this->ui = new calendar_ui($this);
+
+ // catch iTIP confirmation requests that don're require a valid session
+ if ($this->rc->action == 'attend' && !empty($_REQUEST['_t'])) {
+ $this->add_hook('startup', array($this, 'itip_attend_response'));
+ }
+ else if ($this->rc->action == 'feed' && !empty($_REQUEST['_cal'])) {
+ $this->add_hook('startup', array($this, 'ical_feed_export'));
+ }
+ else {
+ // default startup routine
+ $this->add_hook('startup', array($this, 'startup'));
+ }
+ }
+
+ /**
+ * Startup hook
+ */
+ public function startup($args)
+ {
+ // the calendar module can be enabled/disabled by the kolab_auth plugin
+ if ($this->rc->config->get('calendar_disabled', false) || !$this->rc->config->get('calendar_enabled', true))
+ return;
+
+ // load Calendar user interface
+ if (!$this->rc->output->ajax_call && !$this->rc->output->env['framed']) {
+ $this->ui->init();
+
+ // settings are required in (almost) every GUI step
+ if ($args['action'] != 'attend')
+ $this->rc->output->set_env('calendar_settings', $this->load_settings());
+ }
+
+ if ($args['task'] == 'calendar' && $args['action'] != 'save-pref') {
+ if ($args['action'] != 'upload') {
+ $this->load_driver();
+ }
+
+ // register calendar actions
+ $this->register_action('index', array($this, 'calendar_view'));
+ $this->register_action('event', array($this, 'event_action'));
+ $this->register_action('calendar', array($this, 'calendar_action'));
+ $this->register_action('load_events', array($this, 'load_events'));
+ $this->register_action('export_events', array($this, 'export_events'));
+ $this->register_action('import_events', array($this, 'import_events'));
+ $this->register_action('upload', array($this, 'attachment_upload'));
+ $this->register_action('get-attachment', array($this, 'attachment_get'));
+ $this->register_action('freebusy-status', array($this, 'freebusy_status'));
+ $this->register_action('freebusy-times', array($this, 'freebusy_times'));
+ $this->register_action('randomdata', array($this, 'generate_randomdata'));
+ $this->register_action('print', array($this,'print_view'));
+ $this->register_action('mailimportevent', array($this, 'mail_import_event'));
+ $this->register_action('mailtoevent', array($this, 'mail_message2event'));
+ $this->register_action('inlineui', array($this, 'get_inline_ui'));
+ $this->register_action('check-recent', array($this, 'check_recent'));
+ $this->add_hook('refresh', array($this, 'refresh'));
+
+ // remove undo information...
+ if ($undo = $_SESSION['calendar_event_undo']) {
+ // ...after timeout
+ $undo_time = $this->rc->config->get('undo_timeout', 0);
+ if ($undo['ts'] < time() - $undo_time) {
+ $this->rc->session->remove('calendar_event_undo');
+ // @TODO: do EXPUNGE on kolab objects?
+ }
+ }
+ }
+ else if ($args['task'] == 'settings') {
+ // add hooks for Calendar settings
+ $this->add_hook('preferences_sections_list', array($this, 'preferences_sections_list'));
+ $this->add_hook('preferences_list', array($this, 'preferences_list'));
+ $this->add_hook('preferences_save', array($this, 'preferences_save'));
+ }
+ else if ($args['task'] == 'mail') {
+ // hooks to catch event invitations on incoming mails
+ if ($args['action'] == 'show' || $args['action'] == 'preview') {
+ $this->add_hook('message_load', array($this, 'mail_message_load'));
+ $this->add_hook('template_object_messagebody', array($this, 'mail_messagebody_html'));
+ }
+
+ // add 'Create event' item to message menu
+ if ($this->api->output->type == 'html') {
+ $this->api->add_content(html::tag('li', null,
+ $this->api->output->button(array(
+ 'command' => 'calendar-create-from-mail',
+ 'label' => 'calendar.createfrommail',
+ 'type' => 'link',
+ 'classact' => 'icon calendarlink active',
+ 'class' => 'icon calendarlink',
+ 'innerclass' => 'icon calendar',
+ ))),
+ 'messagemenu');
+
+ $this->api->output->add_label('calendar.createfrommail');
+ }
+ }
+
+ // add hooks to display alarms
+ $this->add_hook('pending_alarms', array($this, 'pending_alarms'));
+ $this->add_hook('dismiss_alarms', array($this, 'dismiss_alarms'));
+ }
+
+ /**
+ * Helper method to load the backend driver according to local config
+ */
+ private function load_driver()
+ {
+ if (is_object($this->driver))
+ return;
+
+ $driver_name = $this->rc->config->get('calendar_driver', 'database');
+ $driver_class = $driver_name . '_driver';
+
+ require_once($this->home . '/drivers/calendar_driver.php');
+ require_once($this->home . '/drivers/' . $driver_name . '/' . $driver_class . '.php');
+
+ switch ($driver_name) {
+ case "kolab":
+ $this->require_plugin('libkolab');
+ default:
+ $this->driver = new $driver_class($this);
+ break;
+ }
+
+ if ($this->driver->undelete)
+ $this->driver->undelete = $this->rc->config->get('undo_timeout', 0) > 0;
+ }
+
+ /**
+ * Load iTIP functions
+ */
+ private function load_itip()
+ {
+ if (!$this->itip) {
+ require_once($this->home . '/lib/calendar_itip.php');
+
+ $plugin = $this->rc->plugins->exec_hook('calendar_load_itip',
+ array('identity' => null));
+
+ $this->itip = new calendar_itip($this, $plugin['identity']);
+ }
+
+ return $this->itip;
+ }
+
+ /**
+ * Load iCalendar functions
+ */
+ public function get_ical()
+ {
+ if (!$this->ical) {
+ $this->ical = libcalendaring::get_ical();
+ }
+
+ return $this->ical;
+ }
+
+ /**
+ * Get properties of the calendar this user has specified as default
+ */
+ public function get_default_calendar($writeable = false)
+ {
+ $default_id = $this->rc->config->get('calendar_default_calendar');
+ $calendars = $this->driver->list_calendars(false, true);
+ $calendar = $calendars[$default_id] ?: null;
+ if (!$calendar || ($writeable && $calendar['readonly'])) {
+ foreach ($calendars as $cal) {
+ if ($cal['default']) {
+ $calendar = $cal;
+ break;
+ }
+ if (!$writeable || !$cal['readonly']) {
+ $first = $cal;
+ }
+ }
+ }
+
+ return $calendar ?: $first;
+ }
+
+
+ /**
+ * Render the main calendar view from skin template
+ */
+ function calendar_view()
+ {
+ $this->rc->output->set_pagetitle($this->gettext('calendar'));
+
+ // Add CSS stylesheets to the page header
+ $this->ui->addCSS();
+
+ // Add JS files to the page header
+ $this->ui->addJS();
+
+ $this->ui->init_templates();
+ $this->rc->output->add_label('lowest','low','normal','high','highest','delete','cancel','uploading','noemailwarning');
+
+ // initialize attendees autocompletion
+ rcube_autocomplete_init();
+
+ $this->rc->output->set_env('timezone', $this->timezone->getName());
+ $this->rc->output->set_env('calendar_driver', $this->rc->config->get('calendar_driver'), false);
+ $this->rc->output->set_env('mscolors', $this->driver->get_color_values());
+ $this->rc->output->set_env('identities-selector', $this->ui->identity_select(array('id' => 'edit-identities-list')));
+
+ $view = get_input_value('view', RCUBE_INPUT_GPC);
+ if (in_array($view, array('agendaWeek', 'agendaDay', 'month', 'table')))
+ $this->rc->output->set_env('view', $view);
+
+ if ($date = get_input_value('date', RCUBE_INPUT_GPC))
+ $this->rc->output->set_env('date', $date);
+
+ $this->rc->output->send("calendar.calendar");
+ }
+
+ /**
+ * Handler for preferences_sections_list hook.
+ * Adds Calendar settings sections into preferences sections list.
+ *
+ * @param array Original parameters
+ * @return array Modified parameters
+ */
+ function preferences_sections_list($p)
+ {
+ $p['list']['calendar'] = array(
+ 'id' => 'calendar', 'section' => $this->gettext('calendar'),
+ );
+
+ return $p;
+ }
+
+ /**
+ * Handler for preferences_list hook.
+ * Adds options blocks into Calendar settings sections in Preferences.
+ *
+ * @param array Original parameters
+ * @return array Modified parameters
+ */
+ function preferences_list($p)
+ {
+ if ($p['section'] != 'calendar') {
+ return $p;
+ }
+
+ $no_override = array_flip((array)$this->rc->config->get('dont_override'));
+
+ $p['blocks']['view']['name'] = $this->gettext('mainoptions');
+
+ if (!isset($no_override['calendar_default_view'])) {
+ if (!$p['current']) {
+ $p['blocks']['view']['content'] = true;
+ return $p;
+ }
+
+ $field_id = 'rcmfd_default_view';
+ $select = new html_select(array('name' => '_default_view', 'id' => $field_id));
+ $select->add($this->gettext('day'), "agendaDay");
+ $select->add($this->gettext('week'), "agendaWeek");
+ $select->add($this->gettext('month'), "month");
+ $select->add($this->gettext('agenda'), "table");
+ $p['blocks']['view']['options']['default_view'] = array(
+ 'title' => html::label($field_id, Q($this->gettext('default_view'))),
+ 'content' => $select->show($this->rc->config->get('calendar_default_view', $this->defaults['calendar_default_view'])),
+ );
+ }
+
+ if (!isset($no_override['calendar_timeslots'])) {
+ if (!$p['current']) {
+ $p['blocks']['view']['content'] = true;
+ return $p;
+ }
+
+ $field_id = 'rcmfd_timeslot';
+ $choices = array('1', '2', '3', '4', '6');
+ $select = new html_select(array('name' => '_timeslots', 'id' => $field_id));
+ $select->add($choices);
+ $p['blocks']['view']['options']['timeslots'] = array(
+ 'title' => html::label($field_id, Q($this->gettext('timeslots'))),
+ 'content' => $select->show(strval($this->rc->config->get('calendar_timeslots', $this->defaults['calendar_timeslots']))),
+ );
+ }
+
+ if (!isset($no_override['calendar_first_day'])) {
+ if (!$p['current']) {
+ $p['blocks']['view']['content'] = true;
+ return $p;
+ }
+
+ $field_id = 'rcmfd_firstday';
+ $select = new html_select(array('name' => '_first_day', 'id' => $field_id));
+ $select->add(rcube_label('sunday'), '0');
+ $select->add(rcube_label('monday'), '1');
+ $select->add(rcube_label('tuesday'), '2');
+ $select->add(rcube_label('wednesday'), '3');
+ $select->add(rcube_label('thursday'), '4');
+ $select->add(rcube_label('friday'), '5');
+ $select->add(rcube_label('saturday'), '6');
+ $p['blocks']['view']['options']['first_day'] = array(
+ 'title' => html::label($field_id, Q($this->gettext('first_day'))),
+ 'content' => $select->show(strval($this->rc->config->get('calendar_first_day', $this->defaults['calendar_first_day']))),
+ );
+ }
+
+ if (!isset($no_override['calendar_first_hour'])) {
+ if (!$p['current']) {
+ $p['blocks']['view']['content'] = true;
+ return $p;
+ }
+
+ $time_format = $this->rc->config->get('time_format', libcalendaring::to_php_date_format($this->rc->config->get('calendar_time_format', $this->defaults['calendar_time_format'])));
+ $select_hours = new html_select();
+ for ($h = 0; $h < 24; $h++)
+ $select_hours->add(date($time_format, mktime($h, 0, 0)), $h);
+
+ $field_id = 'rcmfd_firsthour';
+ $p['blocks']['view']['options']['first_hour'] = array(
+ 'title' => html::label($field_id, Q($this->gettext('first_hour'))),
+ 'content' => $select_hours->show($this->rc->config->get('calendar_first_hour', $this->defaults['calendar_first_hour']), array('name' => '_first_hour', 'id' => $field_id)),
+ );
+ }
+
+ if (!isset($no_override['calendar_work_start'])) {
+ if (!$p['current']) {
+ $p['blocks']['view']['content'] = true;
+ return $p;
+ }
+
+ $field_id = 'rcmfd_workstart';
+ $p['blocks']['view']['options']['workinghours'] = array(
+ 'title' => html::label($field_id, Q($this->gettext('workinghours'))),
+ 'content' => $select_hours->show($this->rc->config->get('calendar_work_start', $this->defaults['calendar_work_start']), array('name' => '_work_start', 'id' => $field_id)) .
+ ' — ' . $select_hours->show($this->rc->config->get('calendar_work_end', $this->defaults['calendar_work_end']), array('name' => '_work_end', 'id' => $field_id)),
+ );
+ }
+
+ if (!isset($no_override['calendar_event_coloring'])) {
+ if (!$p['current']) {
+ $p['blocks']['view']['content'] = true;
+ return $p;
+ }
+
+ $field_id = 'rcmfd_coloring';
+ $select_colors = new html_select(array('name' => '_event_coloring', 'id' => $field_id));
+ $select_colors->add($this->gettext('coloringmode0'), 0);
+ $select_colors->add($this->gettext('coloringmode1'), 1);
+ $select_colors->add($this->gettext('coloringmode2'), 2);
+ $select_colors->add($this->gettext('coloringmode3'), 3);
+
+ $p['blocks']['view']['options']['eventcolors'] = array(
+ 'title' => html::label($field_id . 'value', Q($this->gettext('eventcoloring'))),
+ 'content' => $select_colors->show($this->rc->config->get('calendar_event_coloring', $this->defaults['calendar_event_coloring'])),
+ );
+ }
+
+ // loading driver is expensive, don't do it if not needed
+ $this->load_driver();
+
+ if (!isset($no_override['calendar_default_alarm_type'])) {
+ if (!$p['current']) {
+ $p['blocks']['view']['content'] = true;
+ return $p;
+ }
+
+ $field_id = 'rcmfd_alarm';
+ $select_type = new html_select(array('name' => '_alarm_type', 'id' => $field_id));
+ $select_type->add($this->gettext('none'), '');
+ foreach ($this->driver->alarm_types as $type)
+ $select_type->add(rcube_label(strtolower("alarm{$type}option"), 'libcalendaring'), $type);
+
+ $p['blocks']['view']['options']['alarmtype'] = array(
+ 'title' => html::label($field_id, Q($this->gettext('defaultalarmtype'))),
+ 'content' => $select_type->show($this->rc->config->get('calendar_default_alarm_type', '')),
+ );
+ }
+
+ if (!isset($no_override['calendar_default_alarm_offset'])) {
+ if (!$p['current']) {
+ $p['blocks']['view']['content'] = true;
+ return $p;
+ }
+
+ $field_id = 'rcmfd_alarm';
+ $input_value = new html_inputfield(array('name' => '_alarm_value', 'id' => $field_id . 'value', 'size' => 3));
+ $select_offset = new html_select(array('name' => '_alarm_offset', 'id' => $field_id . 'offset'));
+ foreach (array('-M','-H','-D','+M','+H','+D') as $trigger)
+ $select_offset->add(rcube_label('trigger' . $trigger, 'libcalendaring'), $trigger);
+
+ $preset = libcalendaring::parse_alaram_value($this->rc->config->get('calendar_default_alarm_offset', '-15M'));
+ $p['blocks']['view']['options']['alarmoffset'] = array(
+ 'title' => html::label($field_id . 'value', Q($this->gettext('defaultalarmoffset'))),
+ 'content' => $input_value->show($preset[0]) . ' ' . $select_offset->show($preset[1]),
+ );
+ }
+
+ if (!isset($no_override['calendar_default_calendar'])) {
+ if (!$p['current']) {
+ $p['blocks']['view']['content'] = true;
+ return $p;
+ }
+ // default calendar selection
+ $field_id = 'rcmfd_default_calendar';
+ $select_cal = new html_select(array('name' => '_default_calendar', 'id' => $field_id, 'is_escaped' => true));
+ foreach ((array)$this->driver->list_calendars(false, true) as $id => $prop) {
+ $select_cal->add($prop['name'], strval($id));
+ if ($prop['default'])
+ $default_calendar = $id;
+ }
+ $p['blocks']['view']['options']['defaultcalendar'] = array(
+ 'title' => html::label($field_id . 'value', Q($this->gettext('defaultcalendar'))),
+ 'content' => $select_cal->show($this->rc->config->get('calendar_default_calendar', $default_calendar)),
+ );
+ }
+
+ // category definitions
+ if (!$this->driver->nocategories && !isset($no_override['calendar_categories'])) {
+ $p['blocks']['categories']['name'] = $this->gettext('categories');
+
+ if (!$p['current']) {
+ $p['blocks']['categories']['content'] = true;
+ return $p;
+ }
+
+ $categories = (array) $this->driver->list_categories();
+ $categories_list = '';
+ foreach ($categories as $name => $color) {
+ $key = md5($name);
+ $field_class = 'rcmfd_category_' . str_replace(' ', '_', $name);
+ $category_remove = new html_inputfield(array('type' => 'button', 'value' => 'X', 'class' => 'button', 'onclick' => '$(this).parent().remove()', 'title' => $this->gettext('remove_category')));
+ $category_name = new html_inputfield(array('name' => "_categories[$key]", 'class' => $field_class, 'size' => 30, 'disabled' => $this->driver->categoriesimmutable));
+ $category_color = new html_inputfield(array('name' => "_colors[$key]", 'class' => "$field_class colors", 'size' => 6));
+ $hidden = $this->driver->categoriesimmutable ? html::tag('input', array('type' => 'hidden', 'name' => "_categories[$key]", 'value' => $name)) : '';
+ $categories_list .= html::div(null, $hidden . $category_name->show($name) . ' ' . $category_color->show($color) . ' ' . $category_remove->show());
+ }
+
+ $p['blocks']['categories']['options']['category_' . $name] = array(
+ 'content' => html::div(array('id' => 'calendarcategories'), $categories_list),
+ );
+
+ $field_id = 'rcmfd_new_category';
+ $new_category = new html_inputfield(array('name' => '_new_category', 'id' => $field_id, 'size' => 30));
+ $add_category = new html_inputfield(array('type' => 'button', 'class' => 'button', 'value' => $this->gettext('add_category'), 'onclick' => "rcube_calendar_add_category()"));
+ $p['blocks']['categories']['options']['categories'] = array(
+ 'content' => $new_category->show('') . ' ' . $add_category->show(),
+ );
+
+ $this->rc->output->add_script('function rcube_calendar_add_category(){
+ var name = $("#rcmfd_new_category").val();
+ if (name.length) {
+ var input = $("<input>").attr("type", "text").attr("name", "_categories[]").attr("size", 30).val(name);
+ var color = $("<input>").attr("type", "text").attr("name", "_colors[]").attr("size", 6).addClass("colors").val("000000");
+ var button = $("<input>").attr("type", "button").attr("value", "X").addClass("button").click(function(){ $(this).parent().remove() });
+ $("<div>").append(input).append(" ").append(color).append(" ").append(button).appendTo("#calendarcategories");
+ color.miniColors({ colorValues:(rcmail.env.mscolors || []) });
+ $("#rcmfd_new_category").val("");
+ }
+ }');
+
+ $this->rc->output->add_script('$("#rcmfd_new_category").keypress(function(event){
+ if (event.which == 13) {
+ rcube_calendar_add_category();
+ event.preventDefault();
+ }
+ });
+ ', 'docready');
+
+ // include color picker
+ $this->include_script('lib/js/jquery.miniColors.min.js');
+ $this->include_stylesheet($this->local_skin_path() . '/jquery.miniColors.css');
+ $this->rc->output->set_env('mscolors', $this->driver->get_color_values());
+ $this->rc->output->add_script('$("input.colors").miniColors({ colorValues:rcmail.env.mscolors })', 'docready');
+ }
+
+ return $p;
+ }
+
+ /**
+ * Handler for preferences_save hook.
+ * Executed on Calendar settings form submit.
+ *
+ * @param array Original parameters
+ * @return array Modified parameters
+ */
+ function preferences_save($p)
+ {
+ if ($p['section'] == 'calendar') {
+ $this->load_driver();
+
+ // compose default alarm preset value
+ $alarm_offset = get_input_value('_alarm_offset', RCUBE_INPUT_POST);
+ $default_alarm = $alarm_offset[0] . intval(get_input_value('_alarm_value', RCUBE_INPUT_POST)) . $alarm_offset[1];
+
+ $p['prefs'] = array(
+ 'calendar_default_view' => get_input_value('_default_view', RCUBE_INPUT_POST),
+ 'calendar_timeslots' => intval(get_input_value('_timeslots', RCUBE_INPUT_POST)),
+ 'calendar_first_day' => intval(get_input_value('_first_day', RCUBE_INPUT_POST)),
+ 'calendar_first_hour' => intval(get_input_value('_first_hour', RCUBE_INPUT_POST)),
+ 'calendar_work_start' => intval(get_input_value('_work_start', RCUBE_INPUT_POST)),
+ 'calendar_work_end' => intval(get_input_value('_work_end', RCUBE_INPUT_POST)),
+ 'calendar_event_coloring' => intval(get_input_value('_event_coloring', RCUBE_INPUT_POST)),
+ 'calendar_default_alarm_type' => get_input_value('_alarm_type', RCUBE_INPUT_POST),
+ 'calendar_default_alarm_offset' => $default_alarm,
+ 'calendar_default_calendar' => get_input_value('_default_calendar', RCUBE_INPUT_POST),
+ 'calendar_date_format' => null, // clear previously saved values
+ 'calendar_time_format' => null,
+ );
+
+ // categories
+ if (!$this->driver->nocategories) {
+ $old_categories = $new_categories = array();
+ foreach ($this->driver->list_categories() as $name => $color) {
+ $old_categories[md5($name)] = $name;
+ }
+
+ $categories = (array) get_input_value('_categories', RCUBE_INPUT_POST);
+ $colors = (array) get_input_value('_colors', RCUBE_INPUT_POST);
+
+ foreach ($categories as $key => $name) {
+ $color = preg_replace('/^#/', '', strval($colors[$key]));
+
+ // rename categories in existing events -> driver's job
+ if ($oldname = $old_categories[$key]) {
+ $this->driver->replace_category($oldname, $name, $color);
+ unset($old_categories[$key]);
+ }
+ else
+ $this->driver->add_category($name, $color);
+
+ $new_categories[$name] = $color;
+ }
+
+ // these old categories have been removed, alter events accordingly -> driver's job
+ foreach ((array)$old_categories[$key] as $key => $name) {
+ $this->driver->remove_category($name);
+ }
+
+ $p['prefs']['calendar_categories'] = $new_categories;
+ }
+ }
+
+ return $p;
+ }
+
+ /**
+ * Dispatcher for calendar actions initiated by the client
+ */
+ function calendar_action()
+ {
+ $action = get_input_value('action', RCUBE_INPUT_GPC);
+ $cal = get_input_value('c', RCUBE_INPUT_GPC);
+ $success = $reload = false;
+
+ if (isset($cal['showalarms']))
+ $cal['showalarms'] = intval($cal['showalarms']);
+
+ switch ($action) {
+ case "form-new":
+ case "form-edit":
+ echo $this->ui->calendar_editform($action, $cal);
+ exit;
+ case "new":
+ $success = $this->driver->create_calendar($cal);
+ $reload = true;
+ break;
+ case "edit":
+ $success = $this->driver->edit_calendar($cal);
+ $reload = true;
+ break;
+ case "remove":
+ if ($success = $this->driver->remove_calendar($cal))
+ $this->rc->output->command('plugin.destroy_source', array('id' => $cal['id']));
+ break;
+ case "subscribe":
+ if (!$this->driver->subscribe_calendar($cal))
+ $this->rc->output->show_message($this->gettext('errorsaving'), 'error');
+ return;
+ }
+
+ if ($success)
+ $this->rc->output->show_message('successfullysaved', 'confirmation');
+ else {
+ $error_msg = $this->gettext('errorsaving') . ($this->driver->last_error ? ': ' . $this->driver->last_error :'');
+ $this->rc->output->show_message($error_msg, 'error');
+ }
+
+ $this->rc->output->command('plugin.unlock_saving');
+
+ // TODO: keep view and date selection
+ if ($success && $reload)
+ $this->rc->output->redirect('');
+ }
+
+
+ /**
+ * Dispatcher for event actions initiated by the client
+ */
+ function event_action()
+ {
+ $action = get_input_value('action', RCUBE_INPUT_GPC);
+ $event = get_input_value('e', RCUBE_INPUT_POST, true);
+ $success = $reload = $got_msg = false;
+
+ // don't notify if modifying a recurring instance (really?)
+ if ($event['_savemode'] && $event['_savemode'] != 'all' && $event['_notify'])
+ unset($event['_notify']);
+
+ // read old event data in order to find changes
+ if (($event['_notify'] || $event['decline']) && $action != 'new')
+ $old = $this->driver->get_event($event);
+
+ switch ($action) {
+ case "new":
+ // create UID for new event
+ $event['uid'] = $this->generate_uid();
+ $this->prepare_event($event, $action);
+ if ($success = $this->driver->new_event($event)) {
+ $event['id'] = $event['uid'];
+ $this->cleanup_event($event);
+ }
+ $reload = $success && $event['recurrence'] ? 2 : 1;
+ break;
+
+ case "edit":
+ $this->prepare_event($event, $action);
+ if ($success = $this->driver->edit_event($event))
+ $this->cleanup_event($event);
+ $reload = $success && ($event['recurrence'] || $event['_savemode'] || $event['_fromcalendar']) ? 2 : 1;
+ break;
+
+ case "resize":
+ $this->prepare_event($event, $action);
+ $success = $this->driver->resize_event($event);
+ $reload = $event['_savemode'] ? 2 : 1;
+ break;
+
+ case "move":
+ $this->prepare_event($event, $action);
+ $success = $this->driver->move_event($event);
+ $reload = $success && $event['_savemode'] ? 2 : 1;
+ break;
+
+ case "remove":
+ // remove previous deletes
+ $undo_time = $this->driver->undelete ? $this->rc->config->get('undo_timeout', 0) : 0;
+ $this->rc->session->remove('calendar_event_undo');
+
+ // search for event if only UID is given
+ if (!isset($event['calendar']) && $event['uid']) {
+ if (!($event = $this->driver->get_event($event, true))) {
+ break;
+ }
+ $undo_time = 0;
+ }
+
+ $success = $this->driver->remove_event($event, $undo_time < 1);
+ $reload = (!$success || $event['_savemode']) ? 2 : 1;
+
+ if ($undo_time > 0 && $success) {
+ $_SESSION['calendar_event_undo'] = array('ts' => time(), 'data' => $event);
+ // display message with Undo link.
+ $msg = html::span(null, $this->gettext('successremoval'))
+ . ' ' . html::a(array('onclick' => sprintf("%s.http_request('event', 'action=undo', %s.display_message('', 'loading'))",
+ JS_OBJECT_NAME, JS_OBJECT_NAME)), rcube_label('undo'));
+ $this->rc->output->show_message($msg, 'confirmation', null, true, $undo_time);
+ $got_msg = true;
+ }
+ else if ($success) {
+ $this->rc->output->show_message('calendar.successremoval', 'confirmation');
+ $got_msg = true;
+ }
+
+ // send iTIP reply that participant has declined the event
+ if ($success && $event['decline']) {
+ $emails = $this->get_user_emails();
+ foreach ($old['attendees'] as $i => $attendee) {
+ if ($attendee['role'] == 'ORGANIZER')
+ $organizer = $attendee;
+ else if ($attendee['email'] && in_array(strtolower($attendee['email']), $emails)) {
+ $old['attendees'][$i]['status'] = 'DECLINED';
+ $reply_sender = $attendee['email'];
+ }
+ }
+
+ $itip = $this->load_itip();
+ $itip->set_sender_email($reply_sender);
+ if ($organizer && $itip->send_itip_message($old, 'REPLY', $organizer, 'itipsubjectdeclined', 'itipmailbodydeclined'))
+ $this->rc->output->command('display_message', $this->gettext(array('name' => 'sentresponseto', 'vars' => array('mailto' => $organizer['name'] ? $organizer['name'] : $organizer['email']))), 'confirmation');
+ else
+ $this->rc->output->command('display_message', $this->gettext('itipresponseerror'), 'error');
+ }
+ break;
+
+ case "undo":
+ // Restore deleted event
+ $event = $_SESSION['calendar_event_undo']['data'];
+
+ if ($event)
+ $success = $this->driver->restore_event($event);
+
+ if ($success) {
+ $this->rc->session->remove('calendar_event_undo');
+ $this->rc->output->show_message('calendar.successrestore', 'confirmation');
+ $got_msg = true;
+ $reload = 2;
+ }
+
+ break;
+
+ case "rsvp-status":
+ $action = 'rsvp';
+ $status = $event['fallback'];
+ $latest = false;
+ $html = html::div('rsvp-status', $status != 'CANCELLED' ? $this->gettext('acceptinvitation') : '');
+ if (is_numeric($event['changed']))
+ $event['changed'] = new DateTime('@'.$event['changed']);
+ $this->load_driver();
+ if ($existing = $this->driver->get_event($event, true, false, true)) {
+ $latest = ($event['sequence'] && $existing['sequence'] == $event['sequence']) || (!$event['sequence'] && $existing['changed'] && $existing['changed'] >= $event['changed']);
+ $emails = $this->get_user_emails();
+ foreach ($existing['attendees'] as $i => $attendee) {
+ if ($attendee['email'] && in_array(strtolower($attendee['email']), $emails)) {
+ $status = $attendee['status'];
+ break;
+ }
+ }
+ }
+ else {
+ // get a list of writeable calendars
+ $calendars = $this->driver->list_calendars(false, true);
+ $calendar_select = new html_select(array('name' => 'calendar', 'id' => 'calendar-saveto', 'is_escaped' => true));
+ $numcals = 0;
+ foreach ($calendars as $calendar) {
+ if (!$calendar['readonly']) {
+ $calendar_select->add($calendar['name'], $calendar['id']);
+ $numcals++;
+ }
+ }
+ if ($numcals <= 1)
+ $calendar_select = null;
+ }
+
+ if ($status == 'unknown') {
+ $html = html::div('rsvp-status', $this->gettext('notanattendee'));
+ $action = 'import';
+ }
+ else if (in_array($status, array('ACCEPTED','TENTATIVE','DECLINED'))) {
+ $html = html::div('rsvp-status ' . strtolower($status), $this->gettext('youhave'.strtolower($status)));
+ if ($existing['sequence'] > $event['sequence'] || (!$event['sequence'] && $existing['changed'] && $existing['changed'] > $event['changed'])) {
+ $action = ''; // nothing to do here, outdated invitation
+ }
+ }
+
+ $default_calendar = $calendar_select ? $this->get_default_calendar(true) : null;
+ $this->rc->output->command('plugin.update_event_rsvp_status', array(
+ 'uid' => $event['uid'],
+ 'id' => asciiwords($event['uid'], true),
+ 'saved' => $existing ? true : false,
+ 'latest' => $latest,
+ 'status' => $status,
+ 'action' => $action,
+ 'html' => $html,
+ 'select' => $calendar_select ? html::span('calendar-select', $this->gettext('saveincalendar') . ' ' . $calendar_select->show($this->rc->config->get('calendar_default_calendar', $default_calendar['id']))) : '',
+ ));
+ return;
+
+ case "rsvp":
+ $ev = $this->driver->get_event($event);
+ $ev['attendees'] = $event['attendees'];
+ $event = $ev;
+
+ if ($success = $this->driver->edit_event($event)) {
+ $status = get_input_value('status', RCUBE_INPUT_GPC);
+ $organizer = null;
+ foreach ($event['attendees'] as $i => $attendee) {
+ if ($attendee['role'] == 'ORGANIZER') {
+ $organizer = $attendee;
+ break;
+ }
+ }
+ $itip = $this->load_itip();
+ if ($organizer && $itip->send_itip_message($event, 'REPLY', $organizer, 'itipsubject' . $status, 'itipmailbody' . $status))
+ $this->rc->output->command('display_message', $this->gettext(array('name' => 'sentresponseto', 'vars' => array('mailto' => $organizer['name'] ? $organizer['name'] : $organizer['email']))), 'confirmation');
+ else
+ $this->rc->output->command('display_message', $this->gettext('itipresponseerror'), 'error');
+ }
+ break;
+
+ case "dismiss":
+ $event['ids'] = explode(',', $event['id']);
+ $plugin = $this->rc->plugins->exec_hook('dismiss_alarms', $event);
+ $success = $plugin['success'];
+ foreach ($event['ids'] as $id) {
+ if (strpos($id, 'cal:') === 0)
+ $success |= $this->driver->dismiss_alarm(substr($id, 4), $event['snooze']);
+ }
+ break;
+ }
+
+ // show confirmation/error message
+ if (!$got_msg) {
+ if ($success)
+ $this->rc->output->show_message('successfullysaved', 'confirmation');
+ else
+ $this->rc->output->show_message('calendar.errorsaving', 'error');
+ }
+
+ // send out notifications
+ if ($success && $event['_notify'] && ($event['attendees'] || $old['attendees'])) {
+ // make sure we have the complete record
+ $event = $action == 'remove' ? $old : $this->driver->get_event($event);
+
+ // only notify if data really changed (TODO: do diff check on client already)
+ if (!$old || $action == 'remove' || self::event_diff($event, $old)) {
+ $sent = $this->notify_attendees($event, $old, $action);
+ if ($sent > 0)
+ $this->rc->output->show_message('calendar.itipsendsuccess', 'confirmation');
+ else if ($sent < 0)
+ $this->rc->output->show_message('calendar.errornotifying', 'error');
+ }
+ }
+
+ // unlock client
+ $this->rc->output->command('plugin.unlock_saving');
+
+ // update event object on the client or trigger a complete refretch if too complicated
+ if ($reload) {
+ $args = array('source' => $event['calendar']);
+ if ($reload > 1)
+ $args['refetch'] = true;
+ else if ($success && $action != 'remove')
+ $args['update'] = $this->_client_event($this->driver->get_event($event));
+ $this->rc->output->command('plugin.refresh_calendar', $args);
+ }
+ }
+
+ /**
+ * Handler for load-requests from fullcalendar
+ * This will return pure JSON formatted output
+ */
+ function load_events()
+ {
+ $events = $this->driver->load_events(
+ get_input_value('start', RCUBE_INPUT_GET),
+ get_input_value('end', RCUBE_INPUT_GET),
+ ($query = get_input_value('q', RCUBE_INPUT_GET)),
+ get_input_value('source', RCUBE_INPUT_GET)
+ );
+ echo $this->encode($events, !empty($query));
+ exit;
+ }
+
+ /**
+ * Handler for keep-alive requests
+ * This will check for updated data in active calendars and sync them to the client
+ */
+ public function refresh($attr)
+ {
+ // refresh the entire calendar every 10th time to also sync deleted events
+ if (rand(0,10) == 10) {
+ $this->rc->output->command('plugin.refresh_calendar', array('refetch' => true));
+ return;
+ }
+
+ foreach ($this->driver->list_calendars(true) as $cal) {
+ $events = $this->driver->load_events(
+ get_input_value('start', RCUBE_INPUT_GET),
+ get_input_value('end', RCUBE_INPUT_GET),
+ get_input_value('q', RCUBE_INPUT_GET),
+ $cal['id'],
+ 1,
+ $attr['last']
+ );
+
+ foreach ($events as $event) {
+ $this->rc->output->command('plugin.refresh_calendar',
+ array('source' => $cal['id'], 'update' => $this->_client_event($event)));
+ }
+ }
+ }
+
+ /**
+ * Handler for pending_alarms plugin hook triggered by the calendar module on keep-alive requests.
+ * This will check for pending notifications and pass them to the client
+ */
+ public function pending_alarms($p)
+ {
+ $this->load_driver();
+ if ($alarms = $this->driver->pending_alarms($p['time'] ?: time())) {
+ foreach ($alarms as $alarm) {
+ $alarm['id'] = 'cal:' . $alarm['id']; // prefix ID with cal:
+ $p['alarms'][] = $alarm;
+ }
+ }
+
+ return $p;
+ }
+
+ /**
+ * Handler for alarm dismiss hook triggered by libcalendaring
+ */
+ public function dismiss_alarms($p)
+ {
+ $this->load_driver();
+ foreach ((array)$p['ids'] as $id) {
+ if (strpos($id, 'cal:') === 0)
+ $p['success'] |= $this->driver->dismiss_alarm(substr($id, 4), $p['snooze']);
+ }
+
+ return $p;
+ }
+
+ /**
+ * Handler for check-recent requests which are accidentally sent to calendar taks
+ */
+ function check_recent()
+ {
+ // NOP
+ $this->rc->output->send();
+ }
+
+ /**
+ *
+ */
+ function import_events()
+ {
+ // Upload progress update
+ if (!empty($_GET['_progress'])) {
+ rcube_upload_progress();
+ }
+
+ @set_time_limit(0);
+
+ // process uploaded file if there is no error
+ $err = $_FILES['_data']['error'];
+
+ if (!$err && $_FILES['_data']['tmp_name']) {
+ $calendar = get_input_value('calendar', RCUBE_INPUT_GPC);
+ $rangestart = $_REQUEST['_range'] ? date_create("now -" . intval($_REQUEST['_range']) . " months") : 0;
+ $user_email = $this->rc->user->get_username();
+
+ $ical = $this->get_ical();
+ $errors = !$ical->fopen($_FILES['_data']['tmp_name']);
+ $count = $i = 0;
+ foreach ($ical as $event) {
+ // keep the browser connection alive on long import jobs
+ if (++$i > 100 && $i % 100 == 0) {
+ echo "<!-- -->";
+ ob_flush();
+ }
+
+ // TODO: correctly handle recurring events which start before $rangestart
+ if ($event['end'] < $rangestart && (!$event['recurrence'] || ($event['recurrence']['until'] && $event['recurrence']['until'] < $rangestart)))
+ continue;
+
+ $event['_owner'] = $user_email;
+ $event['calendar'] = $calendar;
+ if ($this->driver->new_event($event)) {
+ $count++;
+ }
+ else
+ $errors++;
+ }
+
+ if ($count) {
+ $this->rc->output->command('display_message', $this->gettext(array('name' => 'importsuccess', 'vars' => array('nr' => $count))), 'confirmation');
+ $this->rc->output->command('plugin.import_success', array('source' => $calendar, 'refetch' => true));
+ }
+ else if (!$errors) {
+ $this->rc->output->command('display_message', $this->gettext('importnone'), 'notice');
+ $this->rc->output->command('plugin.import_success', array('source' => $calendar));
+ }
+ else {
+ $this->rc->output->command('plugin.import_error', array('message' => $this->gettext('importerror') . ($msg ? ': ' . $msg : '')));
+ }
+ }
+ else {
+ if ($err == UPLOAD_ERR_INI_SIZE || $err == UPLOAD_ERR_FORM_SIZE) {
+ $msg = rcube_label(array('name' => 'filesizeerror', 'vars' => array(
+ 'size' => show_bytes(parse_bytes(ini_get('upload_max_filesize'))))));
+ }
+ else {
+ $msg = rcube_label('fileuploaderror');
+ }
+
+ $this->rc->output->command('plugin.import_error', array('message' => $msg));
+ $this->rc->output->command('plugin.unlock_saving', false);
+ }
+
+ $this->rc->output->send('iframe');
+ }
+
+ /**
+ * Construct the ics file for exporting events to iCalendar format;
+ */
+ function export_events($terminate = true)
+ {
+ $start = get_input_value('start', RCUBE_INPUT_GET);
+ $end = get_input_value('end', RCUBE_INPUT_GET);
+ if (!$start) $start = mktime(0, 0, 0, 1, date('n'), date('Y')-1);
+ if (!$end) $end = mktime(0, 0, 0, 31, 12, date('Y')+10);
+ $calid = $calname = get_input_value('source', RCUBE_INPUT_GET);
+ $calendars = $this->driver->list_calendars(true);
+
+ if ($calendars[$calid]) {
+ $calname = $calendars[$calid]['name'] ? $calendars[$calid]['name'] : $calid;
+ $calname = preg_replace('/[^a-z0-9_.-]/i', '', html_entity_decode($calname)); // to 7bit ascii
+ if (empty($calname)) $calname = $calid;
+ $events = $this->driver->load_events($start, $end, null, $calid, 0);
+ }
+ else
+ $events = array();
+
+ header("Content-Type: text/calendar");
+ header("Content-Disposition: inline; filename=".$calname.'.ics');
+
+ $this->get_ical()->export($events, '', true, array($this->driver, 'get_attachment_body'));
+
+ if ($terminate)
+ exit;
+ }
+
+
+ /**
+ * Handler for iCal feed requests
+ */
+ function ical_feed_export()
+ {
+ // process HTTP auth info
+ if (!empty($_SERVER['PHP_AUTH_USER']) && isset($_SERVER['PHP_AUTH_PW'])) {
+ $_POST['_user'] = $_SERVER['PHP_AUTH_USER']; // used for rcmail::autoselect_host()
+ $auth = $this->rc->plugins->exec_hook('authenticate', array(
+ 'host' => $this->rc->autoselect_host(),
+ 'user' => trim($_SERVER['PHP_AUTH_USER']),
+ 'pass' => $_SERVER['PHP_AUTH_PW'],
+ 'cookiecheck' => true,
+ 'valid' => true,
+ ));
+ if ($auth['valid'] && !$auth['abort'])
+ $this->rc->login($auth['user'], $auth['pass'], $auth['host']);
+ }
+
+ // require HTTP auth
+ if (empty($_SESSION['user_id'])) {
+ header('WWW-Authenticate: Basic realm="Roundcube Calendar"');
+ header('HTTP/1.0 401 Unauthorized');
+ exit;
+ }
+
+ // decode calendar feed hash
+ $format = 'ics';
+ $calhash = get_input_value('_cal', RCUBE_INPUT_GET);
+ if (preg_match(($suff_regex = '/\.([a-z0-9]{3,5})$/i'), $calhash, $m)) {
+ $format = strtolower($m[1]);
+ $calhash = preg_replace($suff_regex, '', $calhash);
+ }
+
+ if (!strpos($calhash, ':'))
+ $calhash = base64_decode($calhash);
+
+ list($user, $_GET['source']) = explode(':', $calhash, 2);
+
+ // sanity check user
+ if ($this->rc->user->get_username() == $user) {
+ $this->load_driver();
+ $this->export_events(false);
+ }
+ else {
+ header('HTTP/1.0 404 Not Found');
+ }
+
+ // don't save session data
+ session_destroy();
+ exit;
+ }
+
+
+ /**
+ *
+ */
+ function load_settings()
+ {
+ $this->lib->load_settings();
+ $this->defaults += $this->lib->defaults;
+
+ $settings = array();
+
+ // configuration
+ $settings['default_calendar'] = $this->rc->config->get('calendar_default_calendar');
+ $settings['default_view'] = (string)$this->rc->config->get('calendar_default_view', $this->defaults['calendar_default_view']);
+ $settings['date_agenda'] = (string)$this->rc->config->get('calendar_date_agenda', $this->defaults['calendar_date_agenda']);
+
+ $settings['timeslots'] = (int)$this->rc->config->get('calendar_timeslots', $this->defaults['calendar_timeslots']);
+ $settings['first_day'] = (int)$this->rc->config->get('calendar_first_day', $this->defaults['calendar_first_day']);
+ $settings['first_hour'] = (int)$this->rc->config->get('calendar_first_hour', $this->defaults['calendar_first_hour']);
+ $settings['work_start'] = (int)$this->rc->config->get('calendar_work_start', $this->defaults['calendar_work_start']);
+ $settings['work_end'] = (int)$this->rc->config->get('calendar_work_end', $this->defaults['calendar_work_end']);
+ $settings['agenda_range'] = (int)$this->rc->config->get('calendar_agenda_range', $this->defaults['calendar_agenda_range']);
+ $settings['agenda_sections'] = $this->rc->config->get('calendar_agenda_sections', $this->defaults['calendar_agenda_sections']);
+ $settings['event_coloring'] = (int)$this->rc->config->get('calendar_event_coloring', $this->defaults['calendar_event_coloring']);
+ $settings['time_indicator'] = (int)$this->rc->config->get('calendar_time_indicator', $this->defaults['calendar_time_indicator']);
+ $settings['invite_shared'] = (int)$this->rc->config->get('calendar_allow_invite_shared', $this->defaults['calendar_allow_invite_shared']);
+
+ // get user identity to create default attendee
+ if ($this->ui->screen == 'calendar') {
+ foreach ($this->rc->user->list_identities() as $rec) {
+ if (!$identity)
+ $identity = $rec;
+ $identity['emails'][] = $rec['email'];
+ $settings['identities'][$rec['identity_id']] = $rec['email'];
+ }
+ $identity['emails'][] = $this->rc->user->get_username();
+ $settings['identity'] = array('name' => $identity['name'], 'email' => strtolower($identity['email']), 'emails' => ';' . strtolower(join(';', $identity['emails'])));
+ }
+
+ return $settings;
+ }
+
+ /**
+ * Encode events as JSON
+ *
+ * @param array Events as array
+ * @param boolean Add CSS class names according to calendar and categories
+ * @return string JSON encoded events
+ */
+ function encode($events, $addcss = false)
+ {
+ $json = array();
+ foreach ($events as $event) {
+ $json[] = $this->_client_event($event, $addcss);
+ }
+ return json_encode($json);
+ }
+
+ /**
+ * Convert an event object to be used on the client
+ */
+ private function _client_event($event, $addcss = false)
+ {
+ // compose a human readable strings for alarms_text and recurrence_text
+ if ($event['alarms'])
+ $event['alarms_text'] = libcalendaring::alarms_text($event['alarms']);
+ if ($event['recurrence']) {
+ $event['recurrence_text'] = $this->_recurrence_text($event['recurrence']);
+ if ($event['recurrence']['UNTIL'])
+ $event['recurrence']['UNTIL'] = $this->lib->adjust_timezone($event['recurrence']['UNTIL'], $event['allday'])->format('c');
+ unset($event['recurrence']['EXCEPTIONS']);
+ }
+
+ foreach ((array)$event['attachments'] as $k => $attachment) {
+ $event['attachments'][$k]['classname'] = rcube_utils::file2class($attachment['mimetype'], $attachment['name']);
+ }
+
+ // check for organizer in attendees list
+ $organizer = null;
+ foreach ((array)$event['attendees'] as $i => $attendee) {
+ if ($attendee['role'] == 'ORGANIZER') {
+ $organizer = $attendee;
+ break;
+ }
+ }
+
+ if ($organizer === null && !empty($event['organizer'])) {
+ $organizer = $event['organizer'];
+ $organizer['role'] = 'ORGANIZER';
+ if (!is_array($event['attendees']))
+ $event['attendees'] = array();
+ array_unshift($event['attendees'], $organizer);
+ }
+
+ // mapping url => vurl because of the fullcalendar client script
+ $event['vurl'] = $event['url'];
+ unset($event['url']);
+
+ return array(
+ '_id' => $event['calendar'] . ':' . $event['id'], // unique identifier for fullcalendar
+ 'start' => $this->lib->adjust_timezone($event['start'], $event['allday'])->format('c'),
+ 'end' => $this->lib->adjust_timezone($event['end'], $event['allday'])->format('c'),
+ // 'changed' might be empty for event recurrences (Bug #2185)
+ 'changed' => $event['changed'] ? $this->lib->adjust_timezone($event['changed'])->format('c') : null,
+ 'title' => strval($event['title']),
+ 'description' => strval($event['description']),
+ 'location' => strval($event['location']),
+ 'className' => ($addcss ? 'fc-event-cal-'.asciiwords($event['calendar'], true).' ' : '') . 'fc-event-cat-' . asciiwords(strtolower(join('-', (array)$event['categories'])), true),
+ 'allDay' => ($event['allday'] == 1),
+ ) + $event;
+ }
+
+
+ /**
+ * Render localized text describing the recurrence rule of an event
+ */
+ private function _recurrence_text($rrule)
+ {
+ // TODO: finish this
+ $freq = sprintf('%s %d ', $this->gettext('every'), $rrule['INTERVAL']);
+ $details = '';
+ switch ($rrule['FREQ']) {
+ case 'DAILY':
+ $freq .= $this->gettext('days');
+ break;
+ case 'WEEKLY':
+ $freq .= $this->gettext('weeks');
+ break;
+ case 'MONTHLY':
+ $freq .= $this->gettext('months');
+ break;
+ case 'YEARLY':
+ $freq .= $this->gettext('years');
+ break;
+ }
+
+ if ($rrule['INTERVAL'] <= 1)
+ $freq = $this->gettext(strtolower($rrule['FREQ']));
+
+ if ($rrule['COUNT'])
+ $until = $this->gettext(array('name' => 'forntimes', 'vars' => array('nr' => $rrule['COUNT'])));
+ else if ($rrule['UNTIL'])
+ $until = $this->gettext('recurrencend') . ' ' . format_date($rrule['UNTIL'], libcalendaring::to_php_date_format($this->rc->config->get('calendar_date_format', $this->defaults['calendar_date_format'])));
+ else
+ $until = $this->gettext('forever');
+
+ return rtrim($freq . $details . ', ' . $until);
+ }
+
+ /**
+ * Generate a unique identifier for an event
+ */
+ public function generate_uid()
+ {
+ return strtoupper(md5(time() . uniqid(rand())) . '-' . substr(md5($this->rc->user->get_username()), 0, 16));
+ }
+
+
+ /**
+ * TEMPORARY: generate random event data for testing
+ * Create events by opening http://<roundcubeurl>/?_task=calendar&_action=randomdata&_num=500
+ */
+ public function generate_randomdata()
+ {
+ $num = $_REQUEST['_num'] ? intval($_REQUEST['_num']) : 100;
+ $cats = array_keys($this->driver->list_categories());
+ $cals = $this->driver->list_calendars(true);
+ $count = 0;
+
+ while ($count++ < $num) {
+ $start = round((time() + rand(-2600, 2600) * 1000) / 300) * 300;
+ $duration = round(rand(30, 360) / 30) * 30 * 60;
+ $allday = rand(0,20) > 18;
+ $alarm = rand(-30,12) * 5;
+ $fb = rand(0,2);
+
+ if (date('G', $start) > 23)
+ $start -= 3600;
+
+ if ($allday) {
+ $start = strtotime(date('Y-m-d 00:00:00', $start));
+ $duration = 86399;
+ }
+
+ $title = '';
+ $len = rand(2, 12);
+ $words = explode(" ", "The Hough transform is named after Paul Hough who patented the method in 1962. It is a technique which can be used to isolate features of a particular shape within an image. Because it requires that the desired features be specified in some parametric form, the classical Hough transform is most commonly used for the de- tection of regular curves such as lines, circles, ellipses, etc. A generalized Hough transform can be employed in applications where a simple analytic description of a feature(s) is not possible. Due to the computational complexity of the generalized Hough algorithm, we restrict the main focus of this discussion to the classical Hough transform. Despite its domain restrictions, the classical Hough transform (hereafter referred to without the classical prefix ) retains many applications, as most manufac- tured parts (and many anatomical parts investigated in medical imagery) contain feature boundaries which can be described by regular curves. The main advantage of the Hough transform technique is that it is tolerant of gaps in feature boundary descriptions and is relatively unaffected by image noise.");
+// $chars = "!# abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ 1234567890";
+ for ($i = 0; $i < $len; $i++)
+ $title .= $words[rand(0,count($words)-1)] . " ";
+
+ $this->driver->new_event(array(
+ 'uid' => $this->generate_uid(),
+ 'start' => new DateTime('@'.$start),
+ 'end' => new DateTime('@'.($start + $duration)),
+ 'allday' => $allday,
+ 'title' => rtrim($title),
+ 'free_busy' => $fb == 2 ? 'outofoffice' : ($fb ? 'busy' : 'free'),
+ 'categories' => $cats[array_rand($cats)],
+ 'calendar' => array_rand($cals),
+ 'alarms' => $alarm > 0 ? "-{$alarm}M:DISPLAY" : '',
+ 'priority' => rand(0,9),
+ ));
+ }
+
+ $this->rc->output->redirect('');
+ }
+
+ /**
+ * Handler for attachments upload
+ */
+ public function attachment_upload()
+ {
+ $this->lib->attachment_upload(self::SESSION_KEY, 'cal:');
+ }
+
+ /**
+ * Handler for attachments download/displaying
+ */
+ public function attachment_get()
+ {
+ // show loading page
+ if (!empty($_GET['_preload'])) {
+ return $this->lib->attachment_loading_page();
+ }
+
+ $event_id = get_input_value('_event', RCUBE_INPUT_GPC);
+ $calendar = get_input_value('_cal', RCUBE_INPUT_GPC);
+ $id = get_input_value('_id', RCUBE_INPUT_GPC);
+
+ $event = array('id' => $event_id, 'calendar' => $calendar);
+ $attachment = $this->driver->get_attachment($id, $event);
+
+ // show part page
+ if (!empty($_GET['_frame'])) {
+ $this->lib->attachment = $attachment;
+ $this->register_handler('plugin.attachmentframe', array($this->lib, 'attachment_frame'));
+ $this->register_handler('plugin.attachmentcontrols', array($this->lib, 'attachment_header'));
+ $this->rc->output->send('calendar.attachment');
+ }
+ // deliver attachment content
+ else if ($attachment) {
+ $attachment['body'] = $this->driver->get_attachment_body($id, $event);
+ $this->lib->attachment_get($attachment);
+ }
+
+ // if we arrive here, the requested part was not found
+ header('HTTP/1.1 404 Not Found');
+ exit;
+ }
+
+
+ /**
+ * Prepares new/edited event properties before save
+ */
+ private function prepare_event(&$event, $action)
+ {
+ // convert dates into DateTime objects in user's current timezone
+ $event['start'] = new DateTime($event['start'], $this->timezone);
+ $event['end'] = new DateTime($event['end'], $this->timezone);
+
+ // start/end is all we need for 'move' action (#1480)
+ if ($action == 'move') {
+ return;
+ }
+
+ if (is_array($event['recurrence']) && !empty($event['recurrence']['UNTIL']))
+ $event['recurrence']['UNTIL'] = new DateTime($event['recurrence']['UNTIL'], $this->timezone);
+
+ $attachments = array();
+ $eventid = 'cal:'.$event['id'];
+ if (is_array($_SESSION[self::SESSION_KEY]) && $_SESSION[self::SESSION_KEY]['id'] == $eventid) {
+ if (!empty($_SESSION[self::SESSION_KEY]['attachments'])) {
+ foreach ($_SESSION[self::SESSION_KEY]['attachments'] as $id => $attachment) {
+ if (is_array($event['attachments']) && in_array($id, $event['attachments'])) {
+ $attachments[$id] = $this->rc->plugins->exec_hook('attachment_get', $attachment);
+ }
+ }
+ }
+ }
+
+ $event['attachments'] = $attachments;
+
+ // check for organizer in attendees
+ if ($action == 'new' || $action == 'edit') {
+ if (!$event['attendees'])
+ $event['attendees'] = array();
+
+ $emails = $this->get_user_emails();
+ $organizer = $owner = false;
+ foreach ((array)$event['attendees'] as $i => $attendee) {
+ if ($attendee['role'] == 'ORGANIZER')
+ $organizer = $i;
+ if ($attendee['email'] == in_array(strtolower($attendee['email']), $emails))
+ $owner = $i;
+ else if (!isset($attendee['rsvp']))
+ $event['attendees'][$i]['rsvp'] = true;
+ }
+
+ // set new organizer identity
+ if ($organizer !== false && !empty($event['_identity']) && ($identity = $this->rc->user->get_identity($event['_identity']))) {
+ $event['attendees'][$organizer]['name'] = $identity['name'];
+ $event['attendees'][$organizer]['email'] = $identity['email'];
+ }
+
+ // set owner as organizer if yet missing
+ if ($organizer === false && $owner !== false) {
+ $event['attendees'][$owner]['role'] = 'ORGANIZER';
+ unset($event['attendees'][$owner]['rsvp']);
+ }
+ else if ($organizer === false && $action == 'new' && ($identity = $this->rc->user->get_identity($event['_identity'])) && $identity['email']) {
+ array_unshift($event['attendees'], array('role' => 'ORGANIZER', 'name' => $identity['name'], 'email' => $identity['email'], 'status' => 'ACCEPTED'));
+ }
+ }
+
+ // mapping url => vurl because of the fullcalendar client script
+ $event['url'] = $event['vurl'];
+ unset($event['vurl']);
+ }
+
+ /**
+ * Releases some resources after successful event save
+ */
+ private function cleanup_event(&$event)
+ {
+ // remove temp. attachment files
+ if (!empty($_SESSION[self::SESSION_KEY]) && ($eventid = $_SESSION[self::SESSION_KEY]['id'])) {
+ $this->rc->plugins->exec_hook('attachments_cleanup', array('group' => $eventid));
+ $this->rc->session->remove(self::SESSION_KEY);
+ }
+ }
+
+ /**
+ * Send out an invitation/notification to all event attendees
+ */
+ private function notify_attendees($event, $old, $action = 'edit')
+ {
+ if ($action == 'remove') {
+ $event['cancelled'] = true;
+ $is_cancelled = true;
+ }
+
+ $itip = $this->load_itip();
+ $emails = $this->get_user_emails();
+
+ // compose multipart message using PEAR:Mail_Mime
+ $method = $action == 'remove' ? 'CANCEL' : 'REQUEST';
+ $message = $itip->compose_itip_message($event, $method);
+
+ // list existing attendees from $old event
+ $old_attendees = array();
+ foreach ((array)$old['attendees'] as $attendee) {
+ $old_attendees[] = $attendee['email'];
+ }
+
+ // send to every attendee
+ $sent = 0;
+ foreach ((array)$event['attendees'] as $attendee) {
+ // skip myself for obvious reasons
+ if (!$attendee['email'] || in_array(strtolower($attendee['email']), $emails))
+ continue;
+
+ // which template to use for mail text
+ $is_new = !in_array($attendee['email'], $old_attendees);
+ $bodytext = $is_cancelled ? 'eventcancelmailbody' : ($is_new ? 'invitationmailbody' : 'eventupdatemailbody');
+ $subject = $is_cancelled ? 'eventcancelsubject' : ($is_new ? 'invitationsubject' : ($event['title'] ? 'eventupdatesubject':'eventupdatesubjectempty'));
+
+ // finally send the message
+ if ($itip->send_itip_message($event, $method, $attendee, $subject, $bodytext, $message))
+ $sent++;
+ else
+ $sent = -100;
+ }
+
+ return $sent;
+ }
+
+ /**
+ * Echo simple free/busy status text for the given user and time range
+ */
+ public function freebusy_status()
+ {
+ $email = get_input_value('email', RCUBE_INPUT_GPC);
+ $start = get_input_value('start', RCUBE_INPUT_GPC);
+ $end = get_input_value('end', RCUBE_INPUT_GPC);
+
+ // convert dates into unix timestamps
+ if (!empty($start) && !is_numeric($start)) {
+ $dts = new DateTime($start, $this->timezone);
+ $start = $dts->format('U');
+ }
+ if (!empty($end) && !is_numeric($end)) {
+ $dte = new DateTime($end, $this->timezone);
+ $end = $dte->format('U');
+ }
+
+ if (!$start) $start = time();
+ if (!$end) $end = $start + 3600;
+
+ $fbtypemap = array(calendar::FREEBUSY_UNKNOWN => 'UNKNOWN', calendar::FREEBUSY_FREE => 'FREE', calendar::FREEBUSY_BUSY => 'BUSY', calendar::FREEBUSY_TENTATIVE => 'TENTATIVE', calendar::FREEBUSY_OOF => 'OUT-OF-OFFICE');
+ $status = 'UNKNOWN';
+
+ // if the backend has free-busy information
+ $fblist = $this->driver->get_freebusy_list($email, $start, $end);
+ if (is_array($fblist)) {
+ $status = 'FREE';
+
+ foreach ($fblist as $slot) {
+ list($from, $to, $type) = $slot;
+ if ($from < $end && $to > $start) {
+ $status = isset($type) && $fbtypemap[$type] ? $fbtypemap[$type] : 'BUSY';
+ break;
+ }
+ }
+ }
+
+ // let this information be cached for 5min
+ send_future_expire_header(300);
+
+ echo $status;
+ exit;
+ }
+
+ /**
+ * Return a list of free/busy time slots within the given period
+ * Echo data in JSON encoding
+ */
+ public function freebusy_times()
+ {
+ $email = get_input_value('email', RCUBE_INPUT_GPC);
+ $start = get_input_value('start', RCUBE_INPUT_GPC);
+ $end = get_input_value('end', RCUBE_INPUT_GPC);
+ $interval = intval(get_input_value('interval', RCUBE_INPUT_GPC));
+ $strformat = $interval > 60 ? 'Ymd' : 'YmdHis';
+
+ // convert dates into unix timestamps
+ if (!empty($start) && !is_numeric($start)) {
+ $dts = new DateTime($start, $this->timezone);
+ $start = $dts->format('U');
+ }
+ if (!empty($end) && !is_numeric($end)) {
+ $dte = new DateTime($end, $this->timezone);
+ $end = $dte->format('U');
+ }
+
+ if (!$start) $start = time();
+ if (!$end) $end = $start + 86400 * 30;
+ if (!$interval) $interval = 60; // 1 hour
+
+ if (!$dte) {
+ $dts = new DateTime('@'.$start);
+ $dts->setTimezone($this->timezone);
+ }
+
+ $fblist = $this->driver->get_freebusy_list($email, $start, $end);
+ $slots = array();
+
+ // build a list from $start till $end with blocks representing the fb-status
+ for ($s = 0, $t = $start; $t <= $end; $s++) {
+ $status = self::FREEBUSY_UNKNOWN;
+ $t_end = $t + $interval * 60;
+ $dt = new DateTime('@'.$t);
+ $dt->setTimezone($this->timezone);
+
+ // determine attendee's status
+ if (is_array($fblist)) {
+ $status = self::FREEBUSY_FREE;
+ foreach ($fblist as $slot) {
+ list($from, $to, $type) = $slot;
+ if ($from < $t_end && $to > $t) {
+ $status = isset($type) ? $type : self::FREEBUSY_BUSY;
+ if ($status == self::FREEBUSY_BUSY) // can't get any worse :-)
+ break;
+ }
+ }
+ }
+
+ $slots[$s] = $status;
+ $times[$s] = intval($dt->format($strformat));
+ $t = $t_end;
+ }
+
+ $dte = new DateTime('@'.$t_end);
+ $dte->setTimezone($this->timezone);
+
+ // let this information be cached for 5min
+ send_future_expire_header(300);
+
+ echo json_encode(array(
+ 'email' => $email,
+ 'start' => $dts->format('c'),
+ 'end' => $dte->format('c'),
+ 'interval' => $interval,
+ 'slots' => $slots,
+ 'times' => $times,
+ ));
+ exit;
+ }
+
+ /**
+ * Handler for printing calendars
+ */
+ public function print_view()
+ {
+ $title = $this->gettext('print');
+
+ $view = get_input_value('view', RCUBE_INPUT_GPC);
+ if (!in_array($view, array('agendaWeek', 'agendaDay', 'month', 'table')))
+ $view = 'agendaDay';
+
+ $this->rc->output->set_env('view',$view);
+
+ if ($date = get_input_value('date', RCUBE_INPUT_GPC))
+ $this->rc->output->set_env('date', $date);
+
+ if ($range = get_input_value('range', RCUBE_INPUT_GPC))
+ $this->rc->output->set_env('listRange', intval($range));
+
+ if (isset($_REQUEST['sections']))
+ $this->rc->output->set_env('listSections', get_input_value('sections', RCUBE_INPUT_GPC));
+
+ if ($search = get_input_value('search', RCUBE_INPUT_GPC)) {
+ $this->rc->output->set_env('search', $search);
+ $title .= ' "' . $search . '"';
+ }
+
+ // Add CSS stylesheets to the page header
+ $skin_path = $this->local_skin_path();
+ $this->include_stylesheet($skin_path . '/fullcalendar.css');
+ $this->include_stylesheet($skin_path . '/print.css');
+
+ // Add JS files to the page header
+ $this->include_script('print.js');
+ $this->include_script('lib/js/fullcalendar.js');
+
+ $this->register_handler('plugin.calendar_css', array($this->ui, 'calendar_css'));
+ $this->register_handler('plugin.calendar_list', array($this->ui, 'calendar_list'));
+
+ $this->rc->output->set_pagetitle($title);
+ $this->rc->output->send("calendar.print");
+ }
+
+ /**
+ *
+ */
+ public function get_inline_ui()
+ {
+ foreach (array('save','cancel','savingdata') as $label)
+ $texts['calendar.'.$label] = $this->gettext($label);
+
+ $texts['calendar.new_event'] = $this->gettext('createfrommail');
+
+ $this->ui->init_templates();
+ $this->ui->calendar_list(); # set env['calendars']
+ echo $this->api->output->parse('calendar.eventedit', false, false);
+ echo html::tag('script', array('type' => 'text/javascript'),
+ "rcmail.set_env('calendars', " . json_encode($this->api->output->env['calendars']) . ");\n".
+ "rcmail.set_env('deleteicon', '" . $this->api->output->env['deleteicon'] . "');\n".
+ "rcmail.set_env('cancelicon', '" . $this->api->output->env['cancelicon'] . "');\n".
+ "rcmail.set_env('loadingicon', '" . $this->api->output->env['loadingicon'] . "');\n".
+ "rcmail.gui_object('attachmentlist', '" . $this->ui->attachmentlist_id . "');\n".
+ "rcmail.add_label(" . json_encode($texts) . ");\n"
+ );
+ exit;
+ }
+
+ /**
+ * Compare two event objects and return differing properties
+ *
+ * @param array Event A
+ * @param array Event B
+ * @return array List of differing event properties
+ */
+ public static function event_diff($a, $b)
+ {
+ $diff = array();
+ $ignore = array('changed' => 1, 'attachments' => 1);
+ foreach (array_unique(array_merge(array_keys($a), array_keys($b))) as $key) {
+ if (!$ignore[$key] && $a[$key] != $b[$key])
+ $diff[] = $key;
+ }
+
+ // only compare number of attachments
+ if (count($a['attachments']) != count($b['attachments']))
+ $diff[] = 'attachments';
+
+ return $diff;
+ }
+
+
+ /**** Event invitation plugin hooks ****/
+
+ /**
+ * Handler for URLs that allow an invitee to respond on his invitation mail
+ */
+ public function itip_attend_response($p)
+ {
+ if ($p['action'] == 'attend') {
+ $this->rc->output->set_env('task', 'calendar'); // override some env vars
+ $this->rc->output->set_env('refresh_interval', 0);
+ $this->rc->output->set_pagetitle($this->gettext('calendar'));
+
+ $itip = $this->load_itip();
+ $token = get_input_value('_t', RCUBE_INPUT_GPC);
+
+ // read event info stored under the given token
+ if ($invitation = $itip->get_invitation($token)) {
+ $this->token = $token;
+ $this->event = $invitation['event'];
+
+ // show message about cancellation
+ if ($invitation['cancelled']) {
+ $this->invitestatus = html::div('rsvp-status declined', $this->gettext('eventcancelled'));
+ }
+ // save submitted RSVP status
+ else if (!empty($_POST['rsvp'])) {
+ $status = null;
+ foreach (array('accepted','tentative','declined') as $method) {
+ if ($_POST['rsvp'] == $this->gettext('itip' . $method)) {
+ $status = $method;
+ break;
+ }
+ }
+
+ // send itip reply to organizer
+ if ($status && $itip->update_invitation($invitation, $invitation['attendee'], strtoupper($status))) {
+ $this->invitestatus = html::div('rsvp-status ' . strtolower($status), $this->gettext('youhave'.strtolower($status)));
+ }
+ else
+ $this->rc->output->command('display_message', $this->gettext('errorsaving'), 'error', -1);
+
+ // if user is logged in...
+ if ($this->rc->user->ID) {
+ $this->load_driver();
+ $invitation = $itip->get_invitation($token);
+
+ // save the event to his/her default calendar if not yet present
+ if (!$this->driver->get_event($this->event) && ($calendar = $this->get_default_calendar(true))) {
+ $invitation['event']['calendar'] = $calendar['id'];
+ if ($this->driver->new_event($invitation['event']))
+ $this->rc->output->command('display_message', $this->gettext(array('name' => 'importedsuccessfully', 'vars' => array('calendar' => $calendar['name']))), 'confirmation');
+ }
+ }
+ }
+
+ $this->register_handler('plugin.event_inviteform', array($this, 'itip_event_inviteform'));
+ $this->register_handler('plugin.event_invitebox', array($this->ui, 'event_invitebox'));
+
+ if (!$this->invitestatus)
+ $this->register_handler('plugin.event_rsvp_buttons', array($this->ui, 'event_rsvp_buttons'));
+
+ $this->rc->output->set_pagetitle($this->gettext('itipinvitation') . ' ' . $this->event['title']);
+ }
+ else
+ $this->rc->output->command('display_message', $this->gettext('itipinvalidrequest'), 'error', -1);
+
+ $this->rc->output->send('calendar.itipattend');
+ }
+ }
+
+ /**
+ *
+ */
+ public function itip_event_inviteform($attrib)
+ {
+ $hidden = new html_hiddenfield(array('name' => "_t", 'value' => $this->token));
+ return html::tag('form', array('action' => $this->rc->url(array('task' => 'calendar', 'action' => 'attend')), 'method' => 'post', 'noclose' => true) + $attrib) . $hidden->show();
+ }
+
+ /**
+ * Check mail message structure of there are .ics files attached
+ */
+ public function mail_message_load($p)
+ {
+ $this->message = $p['object'];
+ $itip_part = null;
+
+ // check all message parts for .ics files
+ foreach ((array)$this->message->mime_parts as $part) {
+ if ($this->is_vcalendar($part)) {
+ if ($part->ctype_parameters['method'])
+ $itip_part = $part->mime_id;
+ else
+ $this->ics_parts[] = $part->mime_id;
+ }
+ }
+
+ // priorize part with method parameter
+ if ($itip_part)
+ $this->ics_parts = array($itip_part);
+ }
+
+ /**
+ * Add UI element to copy event invitations or updates to the calendar
+ */
+ public function mail_messagebody_html($p)
+ {
+ // load iCalendar functions (if necessary)
+ if (!empty($this->ics_parts)) {
+ $this->get_ical();
+ }
+
+ $html = '';
+ foreach ($this->ics_parts as $mime_id) {
+ $part = $this->message->mime_parts[$mime_id];
+ $charset = $part->ctype_parameters['charset'] ? $part->ctype_parameters['charset'] : RCMAIL_CHARSET;
+ $events = $this->ical->import($this->message->get_part_content($mime_id), $charset);
+ $title = $this->gettext('title');
+ $date = rcube_utils::anytodatetime($this->message->headers->date);
+
+ // successfully parsed events?
+ if (empty($events))
+ continue;
+
+ // show a box for every event in the file
+ foreach ($events as $idx => $event) {
+ // define buttons according to method
+ if ($this->ical->method == 'REPLY') {
+ $title = $this->gettext('itipreply');
+ $buttons = html::tag('input', array(
+ 'type' => 'button',
+ 'class' => 'button',
+ 'onclick' => "rcube_calendar.add_event_from_mail('" . JQ($mime_id.':'.$idx) . "')",
+ 'value' => $this->gettext('updateattendeestatus'),
+ ));
+ }
+ else if ($this->ical->method == 'REQUEST') {
+ $emails = $this->get_user_emails();
+ $title = $event['sequence'] > 0 ? $this->gettext('itipupdate') : $this->gettext('itipinvitation');
+
+ // add (hidden) buttons and activate them from asyncronous request
+ foreach (array('accepted','tentative','declined') as $method) {
+ $rsvp_buttons .= html::tag('input', array(
+ 'type' => 'button',
+ 'class' => "button $method",
+ 'onclick' => "rcube_calendar.add_event_from_mail('" . JQ($mime_id.':'.$idx) . "', '$method')",
+ 'value' => $this->gettext('itip' . $method),
+ ));
+ }
+ $import_button = html::tag('input', array(
+ 'type' => 'button',
+ 'class' => 'button',
+ 'onclick' => "rcube_calendar.add_event_from_mail('" . JQ($mime_id.':'.$idx) . "')",
+ 'value' => $this->gettext('importtocalendar'),
+ ));
+
+ // check my status
+ $status = 'unknown';
+ foreach ($event['attendees'] as $attendee) {
+ if ($attendee['email'] && in_array(strtolower($attendee['email']), $emails)) {
+ $status = strtoupper($attendee['status']);
+ break;
+ }
+ }
+
+ $dom_id = asciiwords($event['uid'], true);
+ $buttons = html::div(array('id' => 'rsvp-'.$dom_id, 'style' => 'display:none'), $rsvp_buttons);
+ $buttons .= html::div(array('id' => 'import-'.$dom_id, 'style' => 'display:none'), $import_button);
+ $buttons_pre = html::div(array('id' => 'loading-'.$dom_id, 'class' => 'rsvp-status loading'), $this->gettext('loading'));
+ $changed = is_object($event['changed']) ? $event['changed'] : $date;
+
+ $script = json_serialize(array(
+ 'uid' => $event['uid'],
+ 'changed' => $changed ? $changed->format('U') : 0,
+ 'sequence' => intval($event['sequence']),
+ 'fallback' => $status,
+ ));
+
+ $this->rc->output->add_script("rcube_calendar.fetch_event_rsvp_status($script)", 'docready');
+ }
+ else if ($this->ical->method == 'CANCEL') {
+ $title = $this->gettext('itipcancellation');
+
+ // create buttons to be activated from async request checking existence of this event in local calendars
+ $button_import = html::tag('input', array(
+ 'type' => 'button',
+ 'class' => 'button',
+ 'onclick' => "rcube_calendar.add_event_from_mail('" . JQ($mime_id.':'.$idx) . "')",
+ 'value' => $this->gettext('importtocalendar'),
+ ));
+ $button_remove = html::tag('input', array(
+ 'type' => 'button',
+ 'class' => 'button',
+ 'onclick' => "rcube_calendar.remove_event_from_mail('" . JQ($event['uid']) . "', '" . JQ($event['title']) . "')",
+ 'value' => $this->gettext('removefromcalendar'),
+ ));
+
+ $dom_id = asciiwords($event['uid'], true);
+ $buttons = html::div(array('id' => 'rsvp-'.$dom_id, 'style' => 'display:none'), $button_remove);
+ $buttons .= html::div(array('id' => 'import-'.$dom_id, 'style' => 'display:none'), $button_import);
+ $buttons_pre = html::div(array('id' => 'loading-'.$dom_id, 'class' => 'rsvp-status loading'), $this->gettext('loading'));
+ $changed = is_object($event['changed']) ? $event['changed'] : $date;
+
+ $script = json_serialize(array(
+ 'uid' => $event['uid'],
+ 'changed' => $changed ? $changed->format('U') : 0,
+ 'sequence' => intval($event['sequence']),
+ 'fallback' => 'CANCELLED',
+ ));
+
+ $this->rc->output->add_script("rcube_calendar.fetch_event_rsvp_status($script)", 'docready');
+ }
+ else {
+ $buttons = html::tag('input', array(
+ 'type' => 'button',
+ 'class' => 'button',
+ 'onclick' => "rcube_calendar.add_event_from_mail('" . JQ($mime_id.':'.$idx) . "')",
+ 'value' => $this->gettext('importtocalendar'),
+ ));
+ }
+
+ // show event details with buttons
+ $html .= html::div('calendar-invitebox', $this->ui->event_details_table($event, $title) . $buttons_pre . html::div('rsvp-buttons', $buttons));
+
+ // limit listing
+ if ($idx >= 3)
+ break;
+ }
+ }
+
+ // prepend event boxes to message body
+ if ($html) {
+ $this->ui->init();
+ $p['content'] = $html . $p['content'];
+ $this->rc->output->add_label('calendar.savingdata','calendar.deleteventconfirm','calendar.declinedeleteconfirm');
+ }
+
+ return $p;
+ }
+
+
+ /**
+ * Handler for POST request to import an event attached to a mail message
+ */
+ public function mail_import_event()
+ {
+ $uid = get_input_value('_uid', RCUBE_INPUT_POST);
+ $mbox = get_input_value('_mbox', RCUBE_INPUT_POST);
+ $mime_id = get_input_value('_part', RCUBE_INPUT_POST);
+ $status = get_input_value('_status', RCUBE_INPUT_POST);
+ $delete = intval(get_input_value('_del', RCUBE_INPUT_POST));
+ $charset = RCMAIL_CHARSET;
+
+ // establish imap connection
+ $imap = $this->rc->get_storage();
+ $imap->set_mailbox($mbox);
+
+ if ($uid && $mime_id) {
+ list($mime_id, $index) = explode(':', $mime_id);
+ $part = $imap->get_message_part($uid, $mime_id);
+ if ($part->ctype_parameters['charset'])
+ $charset = $part->ctype_parameters['charset'];
+ $headers = $imap->get_message_headers($uid);
+ }
+
+ $events = $this->get_ical()->import($part, $charset);
+
+ $error_msg = $this->gettext('errorimportingevent');
+ $success = false;
+
+ // successfully parsed events?
+ if (!empty($events) && ($event = $events[$index])) {
+ // find writeable calendar to store event
+ $cal_id = !empty($_REQUEST['_calendar']) ? get_input_value('_calendar', RCUBE_INPUT_POST) : null;
+ $calendars = $this->driver->list_calendars(false, true);
+ $calendar = $calendars[$cal_id] ?: $this->get_default_calendar(true);
+
+ // update my attendee status according to submitted method
+ if (!empty($status)) {
+ $organizer = null;
+ $emails = $this->get_user_emails();
+ foreach ($event['attendees'] as $i => $attendee) {
+ if ($attendee['role'] == 'ORGANIZER') {
+ $organizer = $attendee;
+ }
+ else if ($attendee['email'] && in_array(strtolower($attendee['email']), $emails)) {
+ $event['attendees'][$i]['status'] = strtoupper($status);
+ $reply_sender = $attendee['email'];
+ }
+ }
+ }
+
+ // save to calendar
+ if ($calendar && !$calendar['readonly']) {
+ $event['calendar'] = $calendar['id'];
+
+ // check for existing event with the same UID
+ $existing = $this->driver->get_event($event['uid'], true, false, true);
+
+ if ($existing) {
+ // only update attendee status
+ if ($this->ical->method == 'REPLY') {
+ // try to identify the attendee using the email sender address
+ $sender = preg_match('/([a-z0-9][a-z0-9\-\.\+\_]*@[^&@"\'.][^@&"\']*\\.([^\\x00-\\x40\\x5b-\\x60\\x7b-\\x7f]{2,}|xn--[a-z0-9]{2,}))/', $headers->from, $m) ? $m[1] : '';
+ $sender_utf = rcube_idn_to_utf8($sender);
+
+ $existing_attendee = -1;
+ foreach ($existing['attendees'] as $i => $attendee) {
+ if ($sender && ($attendee['email'] == $sender || $attendee['email'] == $sender_utf)) {
+ $existing_attendee = $i;
+ break;
+ }
+ }
+ $event_attendee = null;
+ foreach ($event['attendees'] as $attendee) {
+ if ($sender && ($attendee['email'] == $sender || $attendee['email'] == $sender_utf)) {
+ $event_attendee = $attendee;
+ break;
+ }
+ }
+
+ // found matching attendee entry in both existing and new events
+ if ($existing_attendee >= 0 && $event_attendee) {
+ $existing['attendees'][$existing_attendee] = $event_attendee;
+ $success = $this->driver->edit_event($existing);
+ }
+ // update the entire attendees block
+ else if ($event['changed'] >= $existing['changed'] && $event['attendees']) {
+ $existing['attendees'] = $event['attendees'];
+ $success = $this->driver->edit_event($existing);
+ }
+ else {
+ $error_msg = $this->gettext('newerversionexists');
+ }
+ }
+ // delete the event when declined (#1670)
+ else if ($status == 'declined' && $delete) {
+ $deleted = $this->driver->remove_event($existing, true);
+ $success = true;
+ }
+ // import the (newer) event
+ else if ($event['sequence'] >= $existing['sequence'] || $event['changed'] >= $existing['changed']) {
+ $event['id'] = $existing['id'];
+ $event['calendar'] = $existing['calendar'];
+ if ($status == 'declined') // show me as free when declined (#1670)
+ $event['free_busy'] = 'free';
+ $success = $this->driver->edit_event($event);
+ }
+ else if (!empty($status)) {
+ $existing['attendees'] = $event['attendees'];
+ if ($status == 'declined') // show me as free when declined (#1670)
+ $existing['free_busy'] = 'free';
+ $success = $this->driver->edit_event($existing);
+ }
+ else
+ $error_msg = $this->gettext('newerversionexists');
+ }
+ else if (!$existing && $status != 'declined') {
+ $success = $this->driver->new_event($event);
+ }
+ else if ($status == 'declined')
+ $error_msg = null;
+ }
+ else if ($status == 'declined')
+ $error_msg = null;
+ else
+ $error_msg = $this->gettext('nowritecalendarfound');
+ }
+
+ if ($success) {
+ $message = $this->ical->method == 'REPLY' ? 'attendeupdateesuccess' : ($deleted ? 'successremoval' : 'importedsuccessfully');
+ $this->rc->output->command('display_message', $this->gettext(array('name' => $message, 'vars' => array('calendar' => $calendar['name']))), 'confirmation');
+ $this->rc->output->command('plugin.fetch_event_rsvp_status', array('uid' => $event['uid'], 'changed' => $event['changed']->format('U'), 'sequence' => intval($event['sequence']), 'fallback' => strtoupper($status)));
+ $error_msg = null;
+ }
+ else if ($error_msg)
+ $this->rc->output->command('display_message', $error_msg, 'error');
+
+
+ // send iTip reply
+ if ($this->ical->method == 'REQUEST' && $organizer && !in_array(strtolower($organizer['email']), $emails) && !$error_msg) {
+ $itip = $this->load_itip();
+ $itip->set_sender_email($reply_sender);
+ if ($itip->send_itip_message($event, 'REPLY', $organizer, 'itipsubject' . $status, 'itipmailbody' . $status))
+ $this->rc->output->command('display_message', $this->gettext(array('name' => 'sentresponseto', 'vars' => array('mailto' => $organizer['name'] ? $organizer['name'] : $organizer['email']))), 'confirmation');
+ else
+ $this->rc->output->command('display_message', $this->gettext('itipresponseerror'), 'error');
+ }
+
+ $this->rc->output->send();
+ }
+
+
+ /**
+ * Read email message and return contents for a new event based on that message
+ */
+ public function mail_message2event()
+ {
+ $uid = get_input_value('_uid', RCUBE_INPUT_POST);
+ $mbox = get_input_value('_mbox', RCUBE_INPUT_POST);
+ $event = array();
+
+ // establish imap connection
+ $imap = $this->rc->get_storage();
+ $imap->set_mailbox($mbox);
+ $message = new rcube_message($uid);
+
+ if ($message->headers) {
+ $event['title'] = trim($message->subject);
+ $event['description'] = trim($message->first_text_part());
+
+ // copy mail attachments to event
+ if ($message->attachments) {
+ $eventid = 'cal:';
+ if (!is_array($_SESSION[self::SESSION_KEY]) || $_SESSION[self::SESSION_KEY]['id'] != $eventid) {
+ $_SESSION[self::SESSION_KEY] = array();
+ $_SESSION[self::SESSION_KEY]['id'] = $eventid;
+ $_SESSION[self::SESSION_KEY]['attachments'] = array();
+ }
+
+ foreach ((array)$message->attachments as $part) {
+ $attachment = array(
+ 'data' => $imap->get_message_part($uid, $part->mime_id, $part),
+ 'size' => $part->size,
+ 'name' => $part->filename,
+ 'mimetype' => $part->mimetype,
+ 'group' => $eventid,
+ );
+
+ $attachment = $this->rc->plugins->exec_hook('attachment_save', $attachment);
+
+ if ($attachment['status'] && !$attachment['abort']) {
+ $id = $attachment['id'];
+ $attachment['classname'] = rcube_utils::file2class($attachment['mimetype'], $attachment['name']);
+
+ // store new attachment in session
+ unset($attachment['status'], $attachment['abort'], $attachment['data']);
+ $_SESSION[self::SESSION_KEY]['attachments'][$id] = $attachment;
+
+ $attachment['id'] = 'rcmfile' . $attachment['id']; // add prefix to consider it 'new'
+ $event['attachments'][] = $attachment;
+ }
+ }
+ }
+
+ $this->rc->output->command('plugin.mail2event_dialog', $event);
+ }
+ else {
+ $this->rc->output->command('display_message', $this->gettext('messageopenerror'), 'error');
+ }
+
+ $this->rc->output->send();
+ }
+
+
+ /**
+ * Checks if specified message part is a vcalendar data
+ *
+ * @param rcube_message_part Part object
+ * @return boolean True if part is of type vcard
+ */
+ private function is_vcalendar($part)
+ {
+ return (
+ in_array($part->mimetype, array('text/calendar', 'text/x-vcalendar', 'application/ics')) ||
+ // Apple sends files as application/x-any (!?)
+ ($part->mimetype == 'application/x-any' && $part->filename && preg_match('/\.ics$/i', $part->filename))
+ );
+ }
+
+
+ /**
+ * Get a list of email addresses of the current user (from login and identities)
+ */
+ private function get_user_emails()
+ {
+ $emails = array();
+ $plugin = $this->rc->plugins->exec_hook('calendar_user_emails', array('emails' => $emails));
+ $emails = array_map('strtolower', $plugin['emails']);
+
+ if ($plugin['abort']) {
+ return $emails;
+ }
+
+ $emails[] = $this->rc->user->get_username();
+ foreach ($this->rc->user->list_identities() as $identity)
+ $emails[] = strtolower($identity['email']);
+
+ return array_unique($emails);
+ }
+
+
+ /**
+ * Build an absolute URL with the given parameters
+ */
+ public function get_url($param = array())
+ {
+ $param += array('task' => 'calendar');
+
+ $schema = 'http';
+ $default_port = 80;
+ if (rcube_https_check()) {
+ $schema = 'https';
+ $default_port = 443;
+ }
+ $url = $schema . '://' . preg_replace('/:\d+$/', '', $_SERVER['HTTP_HOST']);
+ if ($_SERVER['SERVER_PORT'] != $default_port)
+ $url .= ':' . $_SERVER['SERVER_PORT'];
+ if (dirname($_SERVER['SCRIPT_NAME']) != '/')
+ $url .= dirname($_SERVER['SCRIPT_NAME']);
+ $url .= preg_replace('!^\./!', '/', $this->rc->url($param));
+
+ return $url;
+ }
+
+
+ public function ical_feed_hash($source)
+ {
+ return base64_encode($this->rc->user->get_username() . ':' . $source);
+ }
+
+}
+
--- /dev/null
+<?php
+
+/**
+ * Database driver for the Calendar plugin
+ *
+ * @version @package_version@
+ * @author Lazlo Westerhof <hello@lazlo.me>
+ * @author Thomas Bruederli <bruederli@kolabsys.com>
+ *
+ * Copyright (C) 2010, Lazlo Westerhof <hello@lazlo.me>
+ * Copyright (C) 2012, Kolab Systems AG <contact@kolabsys.com>
+ *
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Affero General Public License as
+ * published by the Free Software Foundation, either version 3 of the
+ * License, or (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Affero General Public License for more details.
+ *
+ * You should have received a copy of the GNU Affero General Public License
+ * along with this program. If not, see <http://www.gnu.org/licenses/>.
+ */
+
+
+class database_driver extends calendar_driver
+{
+ const DB_DATE_FORMAT = 'Y-m-d H:i:s';
+
+ // features this backend supports
+ public $alarms = true;
+ public $attendees = true;
+ public $freebusy = false;
+ public $attachments = true;
+ public $alarm_types = array('DISPLAY');
+
+ private $rc;
+ private $cal;
+ private $cache = array();
+ private $calendars = array();
+ private $calendar_ids = '';
+ private $free_busy_map = array('free' => 0, 'busy' => 1, 'out-of-office' => 2, 'outofoffice' => 2, 'tentative' => 3);
+ private $sensitivity_map = array('public' => 0, 'private' => 1, 'confidential' => 2);
+ private $server_timezone;
+
+ private $db_events = 'events';
+ private $db_calendars = 'calendars';
+ private $db_attachments = 'attachments';
+
+
+ /**
+ * Default constructor
+ */
+ public function __construct($cal)
+ {
+ $this->cal = $cal;
+ $this->rc = $cal->rc;
+ $this->server_timezone = new DateTimeZone(date_default_timezone_get());
+
+ // load library classes
+ require_once($this->cal->home . '/lib/Horde_Date_Recurrence.php');
+
+ // read database config
+ $db = $this->rc->get_dbh();
+ $this->db_events = $this->rc->config->get('db_table_events', $db->table_name($this->db_events));
+ $this->db_calendars = $this->rc->config->get('db_table_calendars', $db->table_name($this->db_calendars));
+ $this->db_attachments = $this->rc->config->get('db_table_attachments', $db->table_name($this->db_attachments));
+
+ $this->_read_calendars();
+ }
+
+ /**
+ * Read available calendars for the current user and store them internally
+ */
+ private function _read_calendars()
+ {
+ $hidden = array_filter(explode(',', $this->rc->config->get('hidden_calendars', '')));
+
+ if (!empty($this->rc->user->ID)) {
+ $calendar_ids = array();
+ $result = $this->rc->db->query(
+ "SELECT *, calendar_id AS id FROM " . $this->db_calendars . "
+ WHERE user_id=?
+ ORDER BY name",
+ $this->rc->user->ID
+ );
+ while ($result && ($arr = $this->rc->db->fetch_assoc($result))) {
+ $arr['showalarms'] = intval($arr['showalarms']);
+ $arr['active'] = !in_array($arr['id'], $hidden);
+ $arr['name'] = html::quote($arr['name']);
+ $arr['listname'] = html::quote($arr['name']);
+ $this->calendars[$arr['calendar_id']] = $arr;
+ $calendar_ids[] = $this->rc->db->quote($arr['calendar_id']);
+ }
+ $this->calendar_ids = join(',', $calendar_ids);
+ }
+ }
+
+ /**
+ * Get a list of available calendars from this source
+ *
+ * @param bool $active Return only active calendars
+ * @param bool $personal Return only personal calendars
+ *
+ * @return array List of calendars
+ */
+ public function list_calendars($active = false, $personal = false)
+ {
+ // attempt to create a default calendar for this user
+ if (empty($this->calendars)) {
+ if ($this->create_calendar(array('name' => 'Default', 'color' => 'cc0000')))
+ $this->_read_calendars();
+ }
+
+ $calendars = $this->calendars;
+
+ // filter active calendars
+ if ($active) {
+ foreach ($calendars as $idx => $cal) {
+ if (!$cal['active']) {
+ unset($calendars[$idx]);
+ }
+ }
+ }
+
+ // 'personal' is unsupported in this driver
+
+ return $calendars;
+ }
+
+ /**
+ * Create a new calendar assigned to the current user
+ *
+ * @param array Hash array with calendar properties
+ * name: Calendar name
+ * color: The color of the calendar
+ * @return mixed ID of the calendar on success, False on error
+ */
+ public function create_calendar($prop)
+ {
+ $result = $this->rc->db->query(
+ "INSERT INTO " . $this->db_calendars . "
+ (user_id, name, color, showalarms)
+ VALUES (?, ?, ?, ?)",
+ $this->rc->user->ID,
+ $prop['name'],
+ $prop['color'],
+ $prop['showalarms']?1:0
+ );
+
+ if ($result)
+ return $this->rc->db->insert_id($this->db_calendars);
+
+ return false;
+ }
+
+ /**
+ * Update properties of an existing calendar
+ *
+ * @see calendar_driver::edit_calendar()
+ */
+ public function edit_calendar($prop)
+ {
+ $query = $this->rc->db->query(
+ "UPDATE " . $this->db_calendars . "
+ SET name=?, color=?, showalarms=?
+ WHERE calendar_id=?
+ AND user_id=?",
+ $prop['name'],
+ $prop['color'],
+ $prop['showalarms']?1:0,
+ $prop['id'],
+ $this->rc->user->ID
+ );
+
+ return $this->rc->db->affected_rows($query);
+ }
+
+ /**
+ * Set active/subscribed state of a calendar
+ * Save a list of hidden calendars in user prefs
+ *
+ * @see calendar_driver::subscribe_calendar()
+ */
+ public function subscribe_calendar($prop)
+ {
+ $hidden = array_flip(explode(',', $this->rc->config->get('hidden_calendars', '')));
+
+ if ($prop['active'])
+ unset($hidden[$prop['id']]);
+ else
+ $hidden[$prop['id']] = 1;
+
+ return $this->rc->user->save_prefs(array('hidden_calendars' => join(',', array_keys($hidden))));
+ }
+
+ /**
+ * Delete the given calendar with all its contents
+ *
+ * @see calendar_driver::remove_calendar()
+ */
+ public function remove_calendar($prop)
+ {
+ if (!$this->calendars[$prop['id']])
+ return false;
+
+ // events and attachments will be deleted by foreign key cascade
+
+ $query = $this->rc->db->query(
+ "DELETE FROM " . $this->db_calendars . "
+ WHERE calendar_id=?",
+ $prop['id']
+ );
+
+ return $this->rc->db->affected_rows($query);
+ }
+
+ /**
+ * Add a single event to the database
+ *
+ * @param array Hash array with event properties
+ * @see calendar_driver::new_event()
+ */
+ public function new_event($event)
+ {
+ if (!$this->validate($event))
+ return false;
+
+ if (!empty($this->calendars)) {
+ if ($event['calendar'] && !$this->calendars[$event['calendar']])
+ return false;
+ if (!$event['calendar'])
+ $event['calendar'] = reset(array_keys($this->calendars));
+
+ $event = $this->_save_preprocess($event);
+
+ $this->rc->db->query(sprintf(
+ "INSERT INTO " . $this->db_events . "
+ (calendar_id, created, changed, uid, %s, %s, all_day, recurrence, title, description, location, categories, url, free_busy, priority, sensitivity, attendees, alarms, notifyat)
+ VALUES (?, %s, %s, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
+ $this->rc->db->quote_identifier('start'),
+ $this->rc->db->quote_identifier('end'),
+ $this->rc->db->now(),
+ $this->rc->db->now()
+ ),
+ $event['calendar'],
+ strval($event['uid']),
+ $event['start']->format(self::DB_DATE_FORMAT),
+ $event['end']->format(self::DB_DATE_FORMAT),
+ intval($event['all_day']),
+ $event['_recurrence'],
+ strval($event['title']),
+ strval($event['description']),
+ strval($event['location']),
+ strval($event['categories']),
+ strval($event['url']),
+ intval($event['free_busy']),
+ intval($event['priority']),
+ intval($event['sensitivity']),
+ $event['attendees'],
+ $event['alarms'],
+ $event['notifyat']
+ );
+
+ $event_id = $this->rc->db->insert_id($this->db_events);
+
+ if ($event_id) {
+ $event['id'] = $event_id;
+
+ // add attachments
+ if (!empty($event['attachments'])) {
+ foreach ($event['attachments'] as $attachment) {
+ $this->add_attachment($attachment, $event_id);
+ unset($attachment);
+ }
+ }
+
+ $this->_update_recurring($event);
+ }
+
+ return $event_id;
+ }
+
+ return false;
+ }
+
+ /**
+ * Update an event entry with the given data
+ *
+ * @param array Hash array with event properties
+ * @see calendar_driver::edit_event()
+ */
+ public function edit_event($event)
+ {
+ if (!empty($this->calendars)) {
+ $update_master = false;
+ $update_recurring = true;
+ $old = $this->get_event($event);
+
+ // increment sequence number
+ if ($old['sequence'] && empty($event['sequence']))
+ $event['sequence'] = max($event['sequence'], $old['sequence']+1);
+
+ // modify a recurring event, check submitted savemode to do the right things
+ if ($old['recurrence'] || $old['recurrence_id']) {
+ $master = $old['recurrence_id'] ? $this->get_event(array('id' => $old['recurrence_id'])) : $old;
+
+ // keep saved exceptions (not submitted by the client)
+ if ($old['recurrence']['EXDATE'])
+ $event['recurrence']['EXDATE'] = $old['recurrence']['EXDATE'];
+
+ switch ($event['_savemode']) {
+ case 'new':
+ $event['uid'] = $this->cal->generate_uid();
+ return $this->new_event($event);
+
+ case 'current':
+ // add exception to master event
+ $master['recurrence']['EXDATE'][] = $old['start'];
+ $update_master = true;
+
+ // just update this occurence (decouple from master)
+ $update_recurring = false;
+ $event['recurrence_id'] = 0;
+ $event['recurrence'] = array();
+ break;
+
+ case 'future':
+ if ($master['id'] != $event['id']) {
+ // set until-date on master event, then save this instance as new recurring event
+ $master['recurrence']['UNTIL'] = clone $event['start'];
+ $master['recurrence']['UNTIL']->sub(new DateInterval('P1D'));
+ unset($master['recurrence']['COUNT']);
+ $update_master = true;
+
+ // if recurrence COUNT, update value to the correct number of future occurences
+ if ($event['recurrence']['COUNT']) {
+ $fromdate = clone $event['start'];
+ $fromdate->setTimezone($this->server_timezone);
+ $sqlresult = $this->rc->db->query(sprintf(
+ "SELECT event_id FROM " . $this->db_events . "
+ WHERE calendar_id IN (%s)
+ AND %s >= ?
+ AND recurrence_id=?",
+ $this->calendar_ids,
+ $this->rc->db->quote_identifier('start')
+ ),
+ $fromdate->format(self::DB_DATE_FORMAT),
+ $master['id']);
+ if ($count = $this->rc->db->num_rows($sqlresult))
+ $event['recurrence']['COUNT'] = $count;
+ }
+
+ $update_recurring = true;
+ $event['recurrence_id'] = 0;
+ break;
+ }
+ // else: 'future' == 'all' if modifying the master event
+
+ default: // 'all' is default
+ $event['id'] = $master['id'];
+ $event['recurrence_id'] = 0;
+
+ // use start date from master but try to be smart on time or duration changes
+ $old_start_date = $old['start']->format('Y-m-d');
+ $old_start_time = $old['allday'] ? '' : $old['start']->format('H:i');
+ $old_duration = $old['end']->format('U') - $old['start']->format('U');
+
+ $new_start_date = $event['start']->format('Y-m-d');
+ $new_start_time = $event['allday'] ? '' : $event['start']->format('H:i');
+ $new_duration = $event['end']->format('U') - $event['start']->format('U');
+
+ $diff = $old_start_date != $new_start_date || $old_start_time != $new_start_time || $old_duration != $new_duration;
+
+ // shifted or resized
+ if ($diff && ($old_start_date == $new_start_date || $old_duration == $new_duration)) {
+ $event['start'] = $master['start']->add($old['start']->diff($event['start']));
+ $event['end'] = clone $event['start'];
+ $event['end']->add(new DateInterval('PT'.$new_duration.'S'));
+ }
+ break;
+ }
+ }
+
+ $success = $this->_update_event($event, $update_recurring);
+ if ($success && $update_master)
+ $this->_update_event($master, true);
+
+ return $success;
+ }
+
+ return false;
+ }
+
+ /**
+ * Convert save data to be used in SQL statements
+ */
+ private function _save_preprocess($event)
+ {
+ // shift dates to server's timezone
+ $event['start'] = clone $event['start'];
+ $event['start']->setTimezone($this->server_timezone);
+ $event['end'] = clone $event['end'];
+ $event['end']->setTimezone($this->server_timezone);
+
+ // compose vcalendar-style recurrencue rule from structured data
+ $rrule = $event['recurrence'] ? libcalendaring::to_rrule($event['recurrence']) : '';
+ $event['_recurrence'] = rtrim($rrule, ';');
+ $event['free_busy'] = intval($this->free_busy_map[strtolower($event['free_busy'])]);
+ $event['sensitivity'] = intval($this->sensitivity_map[strtolower($event['sensitivity'])]);
+
+ if (isset($event['allday'])) {
+ $event['all_day'] = $event['allday'] ? 1 : 0;
+ }
+
+ // compute absolute time to notify the user
+ $event['notifyat'] = $this->_get_notification($event);
+
+ // process event attendees
+ $_attendees = '';
+ foreach ((array)$event['attendees'] as $attendee) {
+ if (!$attendee['name'] && !$attendee['email'])
+ continue;
+ $_attendees .= 'NAME="'.addcslashes($attendee['name'], '"') . '"' .
+ ';STATUS=' . $attendee['status'].
+ ';ROLE=' . $attendee['role'] .
+ ';EMAIL=' . $attendee['email'] .
+ "\n";
+ }
+ $event['attendees'] = rtrim($_attendees);
+
+ return $event;
+ }
+
+ /**
+ * Compute absolute time to notify the user
+ */
+ private function _get_notification($event)
+ {
+ if ($event['alarms'] && $event['start'] > new DateTime()) {
+ $alarm = libcalendaring::get_next_alarm($event);
+
+ if ($alarm['time'] && $alarm['action'] == 'DISPLAY')
+ return date('Y-m-d H:i:s', $alarm['time']);
+ }
+
+ return null;
+ }
+
+ /**
+ * Save the given event record to database
+ *
+ * @param array Event data, already passed through self::_save_preprocess()
+ * @param boolean True if recurring events instances should be updated, too
+ */
+ private function _update_event($event, $update_recurring = true)
+ {
+ $event = $this->_save_preprocess($event);
+ $sql_set = array();
+ $set_cols = array('start', 'end', 'all_day', 'recurrence_id', 'sequence', 'title', 'description', 'location', 'categories', 'url', 'free_busy', 'priority', 'sensitivity', 'attendees', 'alarms', 'notifyat');
+ foreach ($set_cols as $col) {
+ if (is_object($event[$col]) && is_a($event[$col], 'DateTime'))
+ $sql_set[] = $this->rc->db->quote_identifier($col) . '=' . $this->rc->db->quote($event[$col]->format(self::DB_DATE_FORMAT));
+ else if (isset($event[$col]))
+ $sql_set[] = $this->rc->db->quote_identifier($col) . '=' . $this->rc->db->quote($event[$col]);
+ }
+
+ if ($event['_recurrence'])
+ $sql_set[] = $this->rc->db->quote_identifier('recurrence') . '=' . $this->rc->db->quote($event['_recurrence']);
+
+ if ($event['_fromcalendar'] && $event['_fromcalendar'] != $event['calendar'])
+ $sql_set[] = 'calendar_id=' . $this->rc->db->quote($event['calendar']);
+
+ $query = $this->rc->db->query(sprintf(
+ "UPDATE " . $this->db_events . "
+ SET changed=%s %s
+ WHERE event_id=?
+ AND calendar_id IN (" . $this->calendar_ids . ")",
+ $this->rc->db->now(),
+ ($sql_set ? ', ' . join(', ', $sql_set) : '')
+ ),
+ $event['id']
+ );
+
+ $success = $this->rc->db->affected_rows($query);
+
+ // add attachments
+ if ($success && !empty($event['attachments'])) {
+ foreach ($event['attachments'] as $attachment) {
+ $this->add_attachment($attachment, $event['id']);
+ unset($attachment);
+ }
+ }
+
+ // remove attachments
+ if ($success && !empty($event['deleted_attachments'])) {
+ foreach ($event['deleted_attachments'] as $attachment) {
+ $this->remove_attachment($attachment, $event['id']);
+ }
+ }
+
+ if ($success) {
+ unset($this->cache[$event['id']]);
+ if ($update_recurring)
+ $this->_update_recurring($event);
+ }
+
+ return $success;
+ }
+
+ /**
+ * Insert "fake" entries for recurring occurences of this event
+ */
+ private function _update_recurring($event)
+ {
+ if (empty($this->calendars))
+ return;
+
+ // clear existing recurrence copies
+ $this->rc->db->query(
+ "DELETE FROM " . $this->db_events . "
+ WHERE recurrence_id=?
+ AND calendar_id IN (" . $this->calendar_ids . ")",
+ $event['id']
+ );
+
+ // create new fake entries
+ if ($event['recurrence']) {
+ // include library class
+ require_once($this->cal->home . '/lib/calendar_recurrence.php');
+
+ $recurrence = new calendar_recurrence($this->cal, $event);
+
+ $count = 0;
+ $duration = $event['start']->diff($event['end']);
+ while ($next_start = $recurrence->next_start()) {
+ $next_start->setTimezone($this->server_timezone);
+ $next_end = clone $next_start;
+ $next_end->add($duration);
+ $notify_at = $this->_get_notification(array('alarms' => $event['alarms'], 'start' => $next_start, 'end' => $next_end));
+ $query = $this->rc->db->query(sprintf(
+ "INSERT INTO " . $this->db_events . "
+ (calendar_id, recurrence_id, created, changed, uid, %s, %s, all_day, recurrence, title, description, location, categories, url, free_busy, priority, sensitivity, alarms, notifyat)
+ SELECT calendar_id, ?, %s, %s, uid, ?, ?, all_day, recurrence, title, description, location, categories, url, free_busy, priority, sensitivity, alarms, ?
+ FROM " . $this->db_events . " WHERE event_id=? AND calendar_id IN (" . $this->calendar_ids . ")",
+ $this->rc->db->quote_identifier('start'),
+ $this->rc->db->quote_identifier('end'),
+ $this->rc->db->now(),
+ $this->rc->db->now()
+ ),
+ $event['id'],
+ $next_start->format(self::DB_DATE_FORMAT),
+ $next_end->format(self::DB_DATE_FORMAT),
+ $notify_at,
+ $event['id']
+ );
+
+ if (!$this->rc->db->affected_rows($query))
+ break;
+
+ // stop adding events for inifinite recurrence after 20 years
+ if (++$count > 999 || (!$recurrence->recurEnd && !$recurrence->recurCount && $next_start->format('Y') > date('Y') + 20))
+ break;
+ }
+ }
+ }
+
+ /**
+ * Move a single event
+ *
+ * @param array Hash array with event properties
+ * @see calendar_driver::move_event()
+ */
+ public function move_event($event)
+ {
+ // let edit_event() do all the magic
+ return $this->edit_event($event + (array)$this->get_event($event));
+ }
+
+ /**
+ * Resize a single event
+ *
+ * @param array Hash array with event properties
+ * @see calendar_driver::resize_event()
+ */
+ public function resize_event($event)
+ {
+ // let edit_event() do all the magic
+ return $this->edit_event($event + (array)$this->get_event($event));
+ }
+
+ /**
+ * Remove a single event from the database
+ *
+ * @param array Hash array with event properties
+ * @param boolean Remove record irreversible (@TODO)
+ *
+ * @see calendar_driver::remove_event()
+ */
+ public function remove_event($event, $force = true)
+ {
+ if (!empty($this->calendars)) {
+ $event += (array)$this->get_event($event);
+ $master = $event;
+ $update_master = false;
+ $savemode = 'all';
+
+ // read master if deleting a recurring event
+ if ($event['recurrence'] || $event['recurrence_id']) {
+ $master = $event['recurrence_id'] ? $this->get_event(array('id' => $event['recurrence_id'])) : $event;
+ $savemode = $event['_savemode'];
+ }
+
+ switch ($savemode) {
+ case 'current':
+ // add exception to master event
+ $master['recurrence']['EXDATE'][] = $event['start'];
+ $update_master = true;
+
+ // just delete this single occurence
+ $query = $this->rc->db->query(
+ "DELETE FROM " . $this->db_events . "
+ WHERE calendar_id IN (" . $this->calendar_ids . ")
+ AND event_id=?",
+ $event['id']
+ );
+ break;
+
+ case 'future':
+ if ($master['id'] != $event['id']) {
+ // set until-date on master event
+ $master['recurrence']['UNTIL'] = clone $event['start'];
+ $master['recurrence']['UNTIL']->sub(new DateInterval('P1D'));
+ unset($master['recurrence']['COUNT']);
+ $update_master = true;
+
+ // delete this and all future instances
+ $fromdate = clone $event['start'];
+ $fromdate->setTimezone($this->server_timezone);
+ $query = $this->rc->db->query(
+ "DELETE FROM " . $this->db_events . "
+ WHERE calendar_id IN (" . $this->calendar_ids . ")
+ AND " . $this->rc->db->quote_identifier('start') . " >= ?
+ AND recurrence_id=?",
+ $fromdate->format(self::DB_DATE_FORMAT),
+ $master['id']
+ );
+ break;
+ }
+ // else: future == all if modifying the master event
+
+ default: // 'all' is default
+ $query = $this->rc->db->query(
+ "DELETE FROM " . $this->db_events . "
+ WHERE (event_id=? OR recurrence_id=?)
+ AND calendar_id IN (" . $this->calendar_ids . ")",
+ $master['id'],
+ $master['id']
+ );
+ break;
+ }
+
+ $success = $this->rc->db->affected_rows($query);
+ if ($success && $update_master)
+ $this->_update_event($master, true);
+
+ return $success;
+ }
+
+ return false;
+ }
+
+ /**
+ * Return data of a specific event
+ * @param mixed Hash array with event properties or event UID
+ * @param boolean Only search in writeable calendars (ignored)
+ * @param boolean Only search in active calendars
+ * @param boolean Only search in personal calendars (ignored)
+ * @return array Hash array with event properties
+ */
+ public function get_event($event, $writeable = false, $active = false, $personal = false)
+ {
+ $id = is_array($event) ? ($event['id'] ? $event['id'] : $event['uid']) : $event;
+ $col = is_array($event) && is_numeric($id) ? 'event_id' : 'uid';
+
+ if ($this->cache[$id])
+ return $this->cache[$id];
+
+ if ($active) {
+ $calendars = $this->calendars;
+ foreach ($calendars as $idx => $cal) {
+ if (!$cal['active']) {
+ unset($calendars[$idx]);
+ }
+ }
+ $cals = join(',', $calendars);
+ }
+ else {
+ $cals = $this->calendar_ids;
+ }
+
+ $result = $this->rc->db->query(sprintf(
+ "SELECT e.*, (SELECT COUNT(attachment_id) FROM " . $this->db_attachments . "
+ WHERE event_id = e.event_id OR event_id = e.recurrence_id) AS _attachments
+ FROM " . $this->db_events . " AS e
+ WHERE e.calendar_id IN (%s)
+ AND e.$col=?",
+ $cals
+ ),
+ $id);
+
+ if ($result && ($event = $this->rc->db->fetch_assoc($result)) && $event['event_id']) {
+ $this->cache[$id] = $this->_read_postprocess($event);
+ return $this->cache[$id];
+ }
+
+ return false;
+ }
+
+ /**
+ * Get event data
+ *
+ * @see calendar_driver::load_events()
+ */
+ public function load_events($start, $end, $query = null, $calendars = null, $virtual = 1, $modifiedsince = null)
+ {
+ if (empty($calendars))
+ $calendars = array_keys($this->calendars);
+ else if (is_string($calendars))
+ $calendars = explode(',', $calendars);
+
+ // only allow to select from calendars of this use
+ $calendar_ids = array_map(array($this->rc->db, 'quote'), array_intersect($calendars, array_keys($this->calendars)));
+
+ // compose (slow) SQL query for searching
+ // FIXME: improve searching using a dedicated col and normalized values
+ if ($query) {
+ foreach (array('title','location','description','categories','attendees') as $col)
+ $sql_query[] = $this->rc->db->ilike($col, '%'.$query.'%');
+ $sql_add = 'AND (' . join(' OR ', $sql_query) . ')';
+ }
+
+ if (!$virtual)
+ $sql_arr .= ' AND e.recurrence_id = 0';
+
+ if ($modifiedsince)
+ $sql_add .= ' AND e.changed >= ' . $this->rc->db->quote(date('Y-m-d H:i:s', $modifiedsince));
+
+ $events = array();
+ if (!empty($calendar_ids)) {
+ $result = $this->rc->db->query(sprintf(
+ "SELECT e.*, (SELECT COUNT(attachment_id) FROM " . $this->db_attachments . "
+ WHERE event_id = e.event_id OR event_id = e.recurrence_id) AS _attachments
+ FROM " . $this->db_events . " AS e
+ WHERE e.calendar_id IN (%s)
+ AND e.start <= %s AND e.end >= %s
+ %s
+ GROUP BY e.event_id",
+ join(',', $calendar_ids),
+ $this->rc->db->fromunixtime($end),
+ $this->rc->db->fromunixtime($start),
+ $sql_add
+ ));
+
+ while ($result && ($event = $this->rc->db->fetch_assoc($result))) {
+ $events[] = $this->_read_postprocess($event);
+ }
+ }
+
+ return $events;
+ }
+
+ /**
+ * Convert sql record into a rcube style event object
+ */
+ private function _read_postprocess($event)
+ {
+ $free_busy_map = array_flip($this->free_busy_map);
+ $sensitivity_map = array_flip($this->sensitivity_map);
+
+ $event['id'] = $event['event_id'];
+ $event['start'] = new DateTime($event['start']);
+ $event['end'] = new DateTime($event['end']);
+ $event['allday'] = intval($event['all_day']);
+ $event['created'] = new DateTime($event['created']);
+ $event['changed'] = new DateTime($event['changed']);
+ $event['free_busy'] = $free_busy_map[$event['free_busy']];
+ $event['sensitivity'] = $sensitivity_map[$event['sensitivity']];
+ $event['calendar'] = $event['calendar_id'];
+ $event['recurrence_id'] = intval($event['recurrence_id']);
+
+ // parse recurrence rule
+ if ($event['recurrence'] && preg_match_all('/([A-Z]+)=([^;]+);?/', $event['recurrence'], $m, PREG_SET_ORDER)) {
+ $event['recurrence'] = array();
+ foreach ($m as $rr) {
+ if (is_numeric($rr[2]))
+ $rr[2] = intval($rr[2]);
+ else if ($rr[1] == 'UNTIL')
+ $rr[2] = date_create($rr[2]);
+ else if ($rr[1] == 'EXDATE')
+ $rr[2] = array_map('date_create', explode(',', $rr[2]));
+ $event['recurrence'][$rr[1]] = $rr[2];
+ }
+ }
+
+ if ($event['_attachments'] > 0)
+ $event['attachments'] = (array)$this->list_attachments($event);
+
+ // decode serialized event attendees
+ if ($event['attendees']) {
+ $attendees = array();
+ foreach (explode("\n", $event['attendees']) as $line) {
+ $att = array();
+ foreach (rcube_utils::explode_quoted_string(';', $line) as $prop) {
+ list($key, $value) = explode("=", $prop);
+ $att[strtolower($key)] = stripslashes(trim($value, '""'));
+ }
+ $attendees[] = $att;
+ }
+ $event['attendees'] = $attendees;
+ }
+
+ unset($event['event_id'], $event['calendar_id'], $event['notifyat'], $event['all_day'], $event['_attachments']);
+ return $event;
+ }
+
+ /**
+ * Get a list of pending alarms to be displayed to the user
+ *
+ * @see calendar_driver::pending_alarms()
+ */
+ public function pending_alarms($time, $calendars = null)
+ {
+ if (empty($calendars))
+ $calendars = array_keys($this->calendars);
+ else if (is_string($calendars))
+ $calendars = explode(',', $calendars);
+
+ // only allow to select from calendars with activated alarms
+ $calendar_ids = array();
+ foreach ($calendars as $cid) {
+ if ($this->calendars[$cid] && $this->calendars[$cid]['showalarms'])
+ $calendar_ids[] = $cid;
+ }
+ $calendar_ids = array_map(array($this->rc->db, 'quote'), $calendar_ids);
+
+ $alarms = array();
+ if (!empty($calendar_ids)) {
+ $result = $this->rc->db->query(sprintf(
+ "SELECT * FROM " . $this->db_events . "
+ WHERE calendar_id IN (%s)
+ AND notifyat <= %s AND %s > %s",
+ join(',', $calendar_ids),
+ $this->rc->db->fromunixtime($time),
+ $this->rc->db->quote_identifier('end'),
+ $this->rc->db->fromunixtime($time)
+ ));
+
+ while ($result && ($event = $this->rc->db->fetch_assoc($result)))
+ $alarms[] = $this->_read_postprocess($event);
+ }
+
+ return $alarms;
+ }
+
+ /**
+ * Feedback after showing/sending an alarm notification
+ *
+ * @see calendar_driver::dismiss_alarm()
+ */
+ public function dismiss_alarm($event_id, $snooze = 0)
+ {
+ // set new notifyat time or unset if not snoozed
+ $notify_at = $snooze > 0 ? date(self::DB_DATE_FORMAT, time() + $snooze) : null;
+
+ $query = $this->rc->db->query(sprintf(
+ "UPDATE " . $this->db_events . "
+ SET changed=%s, notifyat=?
+ WHERE event_id=?
+ AND calendar_id IN (" . $this->calendar_ids . ")",
+ $this->rc->db->now()),
+ $notify_at,
+ $event_id
+ );
+
+ return $this->rc->db->affected_rows($query);
+ }
+
+ /**
+ * Save an attachment related to the given event
+ */
+ private function add_attachment($attachment, $event_id)
+ {
+ $data = $attachment['data'] ? $attachment['data'] : file_get_contents($attachment['path']);
+
+ $query = $this->rc->db->query(
+ "INSERT INTO " . $this->db_attachments .
+ " (event_id, filename, mimetype, size, data)" .
+ " VALUES (?, ?, ?, ?, ?)",
+ $event_id,
+ $attachment['name'],
+ $attachment['mimetype'],
+ strlen($data),
+ base64_encode($data)
+ );
+
+ return $this->rc->db->affected_rows($query);
+ }
+
+ /**
+ * Remove a specific attachment from the given event
+ */
+ private function remove_attachment($attachment_id, $event_id)
+ {
+ $query = $this->rc->db->query(
+ "DELETE FROM " . $this->db_attachments .
+ " WHERE attachment_id = ?" .
+ " AND event_id IN (SELECT event_id FROM " . $this->db_events .
+ " WHERE event_id = ?" .
+ " AND calendar_id IN (" . $this->calendar_ids . "))",
+ $attachment_id,
+ $event_id
+ );
+
+ return $this->rc->db->affected_rows($query);
+ }
+
+ /**
+ * List attachments of specified event
+ */
+ public function list_attachments($event)
+ {
+ $attachments = array();
+
+ if (!empty($this->calendar_ids)) {
+ $result = $this->rc->db->query(
+ "SELECT attachment_id AS id, filename AS name, mimetype, size " .
+ " FROM " . $this->db_attachments .
+ " WHERE event_id IN (SELECT event_id FROM " . $this->db_events .
+ " WHERE event_id=?" .
+ " AND calendar_id IN (" . $this->calendar_ids . "))".
+ " ORDER BY filename",
+ $event['recurrence_id'] ? $event['recurrence_id'] : $event['event_id']
+ );
+
+ while ($result && ($arr = $this->rc->db->fetch_assoc($result))) {
+ $attachments[] = $arr;
+ }
+ }
+
+ return $attachments;
+ }
+
+ /**
+ * Get attachment properties
+ */
+ public function get_attachment($id, $event)
+ {
+ if (!empty($this->calendar_ids)) {
+ $result = $this->rc->db->query(
+ "SELECT attachment_id AS id, filename AS name, mimetype, size " .
+ " FROM " . $this->db_attachments .
+ " WHERE attachment_id=?".
+ " AND event_id=?",
+ $id,
+ $event['recurrence_id'] ? $event['recurrence_id'] : $event['id']
+ );
+
+ if ($result && ($arr = $this->rc->db->fetch_assoc($result))) {
+ return $arr;
+ }
+ }
+
+ return null;
+ }
+
+ /**
+ * Get attachment body
+ */
+ public function get_attachment_body($id, $event)
+ {
+ if (!empty($this->calendar_ids)) {
+ $result = $this->rc->db->query(
+ "SELECT data " .
+ " FROM " . $this->db_attachments .
+ " WHERE attachment_id=?".
+ " AND event_id=?",
+ $id,
+ $event['id']
+ );
+
+ if ($result && ($arr = $this->rc->db->fetch_assoc($result))) {
+ return base64_decode($arr['data']);
+ }
+ }
+
+ return null;
+ }
+
+ /**
+ * Remove the given category
+ */
+ public function remove_category($name)
+ {
+ $query = $this->rc->db->query(
+ "UPDATE " . $this->db_events . "
+ SET categories=''
+ WHERE categories=?
+ AND calendar_id IN (" . $this->calendar_ids . ")",
+ $name
+ );
+
+ return $this->rc->db->affected_rows($query);
+ }
+
+ /**
+ * Update/replace a category
+ */
+ public function replace_category($oldname, $name, $color)
+ {
+ $query = $this->rc->db->query(
+ "UPDATE " . $this->db_events . "
+ SET categories=?
+ WHERE categories=?
+ AND calendar_id IN (" . $this->calendar_ids . ")",
+ $name,
+ $oldname
+ );
+
+ return $this->rc->db->affected_rows($query);
+ }
+
+}
+
projects / caldav_driver.git / commitdiff