public function actionImportIcs($params) { $response = array('success' => true); $count = 0; $failed = array(); if (!file_exists($_FILES['ical_file']['tmp_name'][0])) { throw new \Exception($lang['common']['noFileUploaded']); } else { $file = new \GO\Base\Fs\File($_FILES['ical_file']['tmp_name'][0]); $file->convertToUtf8(); $contents = $file->getContents(); $vcal = \GO\Base\VObject\Reader::read($contents); \GO\Base\VObject\Reader::convertVCalendarToICalendar($vcal); foreach ($vcal->vtodo as $vtask) { $event = new \GO\Tasks\Model\Task(); try { $event->importVObject($vtask, array('tasklist_id' => $params['tasklist_id'])); $count++; } catch (\Exception $e) { $failed[] = $e->getMessage(); } } } $response['feedback'] = sprintf(\GO::t('import_success', 'tasks'), $count); if (count($failed)) { $response['feedback'] .= "\n\n" . count($failed) . " tasks failed: " . implode('\\n', $failed); } return $response; }
public function next() { // \GO::debug("next"); $data = $this->getNextData(); // \GO::debug($data); $this->current = false; if (empty($data)) { return false; } $vcal = \GO\Base\VObject\Reader::read($data); $vevents = $vcal->select($this->type); // \GO::debug("Found: ".count($vevents)); $vevent = array_shift($vevents); if ($vevent) { // \GO::debug("Found event"); $this->current = $vevent; $this->key++; return $this->current; } else { return false; } }
/** * Import a task from a VObject * * @param Sabre\VObject\Component $vobject * @param array $attributes Extra attributes to apply to the task. Raw values should be past. No input formatting is applied. * @return Task */ public function importVObject(Sabre\VObject\Component $vobject, $attributes = array()) { //$event = new \GO\Calendar\Model\Event(); $this->uuid = (string) $vobject->uid; $this->name = (string) $vobject->summary; $this->description = (string) $vobject->description; if (!empty($vobject->dtstart)) { $this->start_time = $vobject->dtstart->getDateTime()->format('U'); } if (!empty($vobject->dtend)) { $this->due_time = $vobject->dtend->getDateTime()->format('U'); if (empty($vobject->dtstart)) { $this->start_time = $this->due_time; } } if (!empty($vobject->due)) { $this->due_time = $vobject->due->getDateTime()->format('U'); } if (empty($vobject->dtstart)) { $this->start_time = 0; } if ($vobject->dtstamp) { $this->mtime = $vobject->dtstamp->getDateTime()->format('U'); } if (empty($this->due_time)) { $this->due_time = time(); } if ($vobject->rrule) { $rrule = new \GO\Base\Util\Icalendar\Rrule(); $rrule->readIcalendarRruleString($this->start_time, (string) $vobject->rrule); $rrule->shiftDays(false); $this->rrule = $rrule->createRrule(); if (isset($rrule->until)) { $this->repeat_end_time = $rrule->until; } } //var_dump($vobject->status); if ($vobject->status) { $this->status = (string) $vobject->status; } if ($vobject->duration) { $duration = \GO\Base\VObject\Reader::parseDuration($vobject->duration); $this->end_time = $this->start_time + $duration; } if (!empty($vobject->priority)) { if ((string) $vobject->priority > 5) { $this->priority = self::PRIORITY_LOW; } elseif ((string) $vobject->priority < 3) { $this->priority = self::PRIORITY_HIGH; } else { $this->priority = self::PRIORITY_NORMAL; } } if ((string) $vobject->completed != '') { $this->completion_time = $vobject->completed->getDateTime()->format('U'); $this->status = 'COMPLETED'; } else { $this->completion_time = 0; } if (!empty($vobject->{"percent-complete"})) { $this->percentage_complete = (string) $vobject->{"percent-complete"}; } if ($this->status == 'COMPLETED' && empty($this->completion_time)) { $this->completion_time = time(); } $this->reminder = 0; if ($vobject->valarm && $vobject->valarm->trigger) { $date = $vobject->valarm->getEffectiveTriggerTime(); if ($date) { $this->reminder = $date->format('U'); } } $this->setAttributes($attributes, false); $this->cutAttributeLengths(); if ($this->due_time < $this->start_time) { $this->due_time = $this->start_time; } $this->save(); return $this; }
public function actionIcs() { $data = 'BEGIN:VCALENDAR CALSCALE:GREGORIAN PRODID:-//Apple Inc.//iOS 7.0//EN VERSION:2.0 BEGIN:VTIMEZONE TZID:Europe/Amsterdam BEGIN:DAYLIGHT DTSTART:19810329T020000 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU TZNAME:CEST TZOFFSETFROM:+0100 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD DTSTART:19961027T030000 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU TZNAME:CET TZOFFSETFROM:+0200 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20140120T131840Z DTEND;TZID=Europe/Amsterdam:20140120T160000 DTSTAMP:20140120T131925Z DTSTART;TZID=Europe/Amsterdam:20140120T141500 LAST-MODIFIED:20140120T131840Z RRULE:FREQ=WEEKLY;INTERVAL=2;UNTIL=20140120T131500Z;BYDAY=MO,WE SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Weekly1 TRANSP:OPAQUE UID:26ae3ffb-546c-5a32-b87e-49306b68de91 X-GO-REMINDER-TIME:20140120T140500 BEGIN:VALARM ACTION:DISPLAY DESCRIPTION:Alarm TRIGGER:-PT10M UID:A1AA22FB-D65D-438F-A03E-D93DC744B7EF X-WR-ALARMUID:A1AA22FB-D65D-438F-A03E-D93DC744B7EF END:VALARM END:VEVENT END:VCALENDAR'; $vcalendar = \GO\Base\VObject\Reader::read($data); echo (string) $vcalendar->vevent[0]->rrule; }
/** * Get the VCALENDAR object as SabreDav vobject component * * @return Sabre\VObject\Component */ public function getInvitationVcalendar() { $attachments = $this->getAttachments(); foreach ($attachments as $attachment) { if ($attachment->isVcalendar()) { $data = $this->getImapConnection()->get_message_part_decoded($this->uid, $attachment->number, $attachment->encoding); $vcalendar = \GO\Base\VObject\Reader::read($data); if ($vcalendar && isset($vcalendar->vevent[0])) { return $vcalendar; } } } return false; }
/** * Import an event from a VObject * * @param Sabre\VObject\Component $vobject * @param array $attributes Extra attributes to apply to the event. Raw values should be past. No input formatting is applied. * @param boolean $dontSave. Don't save the event. WARNING. Event can't be fully imported this way because participants and exceptions need an ID. This option is useful if you want to display info about an ICS file. * @param boolean $importExternal This should be switched on if importing happens from external ICS calendar. * @return Event */ public function importVObject(Sabre\VObject\Component $vobject, $attributes = array(), $dontSave = false, $makeSureUserParticipantExists = false, $importExternal = false) { $uid = (string) $vobject->uid; if (!empty($uid)) { $this->uuid = $uid; } $this->name = (string) $vobject->summary; if (empty($this->name)) { $this->name = \GO::t('unnamed'); } $dtstart = $vobject->dtstart ? $vobject->dtstart->getDateTime() : new \DateTime(); $dtend = $vobject->dtend ? $vobject->dtend->getDateTime() : new \DateTime(); $substractOnEnd = 0; //funambol sends this special parameter // if((string) $vobject->{"X-FUNAMBOL-ALLDAY"}=="1"){ // $this->all_day_event=1; // }else // { $this->all_day_event = isset($vobject->dtstart['VALUE']) && $vobject->dtstart['VALUE'] == 'DATE' ? 1 : 0; //ios sends start and end date at 00:00 hour //DTEND;TZID=Europe/Amsterdam:20140121T000000 //DTSTART;TZID=Europe/Amsterdam:20140120T000000 if ($dtstart->format('Hi') == "0000" && $dtend->format('Hi') == "0000") { $this->all_day_event = true; $substractOnEnd = 60; } // } if ($this->all_day_event) { if ($dtstart->getTimezone()->getName() == 'UTC') { $this->_utcToLocal($dtstart); } if ($dtend->getTimezone()->getName() == 'UTC') { $this->_utcToLocal($dtend); } } $this->start_time = intval($dtstart->format('U')); $this->end_time = intval($dtend->format('U')) - $substractOnEnd; if ($vobject->duration) { $duration = \GO\Base\VObject\Reader::parseDuration($vobject->duration); $this->end_time = $this->start_time + $duration; } if ($this->end_time <= $this->start_time) { $this->end_time = $this->start_time + 3600; } if ($vobject->description) { $this->description = (string) $vobject->description; } if ((string) $vobject->rrule != "") { $rrule = new \GO\Base\Util\Icalendar\Rrule(); $rrule->readIcalendarRruleString($this->start_time, (string) $vobject->rrule); $rrule->shiftDays(true); $this->rrule = $rrule->createRrule(); $this->repeat_end_time = $rrule->until; } else { $this->rrule = ""; $this->repeat_end_time = 0; } if ($vobject->{"last-modified"}) { $this->mtime = intval($vobject->{"last-modified"}->getDateTime()->format('U')); } if ($vobject->location) { $this->location = (string) $vobject->location; } //var_dump($vobject->status); if ($vobject->status) { $status = (string) $vobject->status; if ($this->isValidStatus($status)) { $this->status = $status; } } if (isset($vobject->class)) { $this->private = strtoupper($vobject->class) != 'PUBLIC'; } $this->reminder = 0; // if($vobject->valarm && $vobject->valarm->trigger){ // // $type = (string) $vobject->valarm->trigger["value"]; // // // if($type == "DURATION") { // $duration = \GO\Base\VObject\Reader::parseDuration($vobject->valarm->trigger); // if($duration>0){ // $this->reminder = $duration*-1; // } // }else // { // \GO::debug("WARNING: Ignoring unsupported reminder value of type: ".$type); // } // if ($vobject->valarm && $vobject->valarm->trigger) { $date = $vobject->valarm->getEffectiveTriggerTime(); if ($date) { if ($this->all_day_event) { $this->_utcToLocal($date); } $this->reminder = $this->start_time - $date->format('U'); } } elseif ($vobject->aalarm) { //funambol sends old vcalendar 1.0 format $aalarm = explode(';', (string) $vobject->aalarm); if (!empty($aalarm[0])) { $p = Sabre\VObject\DateTimeParser::parse($aalarm[0]); $this->reminder = $this->start_time - $p->format('U'); } } $this->setAttributes($attributes, false); $recurrenceIds = $vobject->select('recurrence-id'); if (count($recurrenceIds)) { //this is a single instance of a recurring series. //attempt to find the exception of the recurring series event by uuid //and recurrence time so we can set the relation cal_exceptions.exception_event_id=cal_events.id $firstMatch = array_shift($recurrenceIds); $recurrenceTime = $firstMatch->getDateTime()->format('U'); $whereCriteria = \GO\Base\Db\FindCriteria::newInstance()->addCondition('calendar_id', $this->calendar_id, '=', 'ev')->addCondition('uuid', $this->uuid, '=', 'ev')->addCondition('time', $recurrenceTime, '=', 't'); $joinCriteria = \GO\Base\Db\FindCriteria::newInstance()->addCondition('event_id', 'ev.id', '=', 't', true, true); $findParams = \GO\Base\Db\FindParams::newInstance()->single()->criteria($whereCriteria)->join(Event::model()->tableName(), $joinCriteria, 'ev'); $exception = Exception::model()->find($findParams); if ($exception) { $this->exception_for_event_id = $exception->event_id; if (empty($this->name) || $this->name == \GO::t('unnamed')) { $this->name = $exception->mainevent->name; } } else { //exception was not found for this recurrence. Find the recurring series and add the exception. $recurringEvent = Event::model()->findByUuid($this->uuid, 0, $this->calendar_id); if ($recurringEvent) { \GO::debug("Creating MISSING exception for " . date('c', $recurrenceTime)); //aftersave will create Exception $this->exception_for_event_id = $recurringEvent->id; //will be saved later $exception = new Exception(); $exception->time = $recurrenceTime; $exception->event_id = $recurringEvent->id; if (empty($this->name) || $this->name == \GO::t('unnamed')) { $this->name = $exception->mainevent->name; } } else { //ignore this because the invited participant might not be invited to the series //throw new \Exception("Could not find master event!"); //hack to make it be seen as an exception $this->exception_for_event_id = -1; } } } if ($vobject->valarm && $vobject->valarm->trigger) { $reminderTime = $vobject->valarm->getEffectiveTriggerTime(); //echo $reminderTime->format('c'); if ($this->all_day_event) { $this->_utcToLocal($reminderTime); } $seconds = $reminderTime->format('U'); $this->reminder = $this->start_time - $seconds; if ($this->reminder < 0) { $this->reminder = 0; } } $cats = (string) $vobject->categories; if (!empty($cats)) { //Group-Office only supports a single category. $cats = explode(',', $cats); $categoryName = array_shift($cats); $category = Category::model()->findByName($this->calendar_id, $categoryName); if (!$category && !$dontSave && $this->calendar_id) { $category = new Category(); $category->name = $categoryName; $category->calendar_id = $this->calendar_id; $category->save(true); } if ($category) { $this->category_id = $category->id; $this->background = $category->color; } } //set is_organizer flag if ($vobject->organizer && $this->calendar) { $organizerEmail = str_replace('mailto:', '', strtolower((string) $vobject->organizer)); $this->is_organizer = $organizerEmail == $this->calendar->user->email; } if (!$dontSave) { $this->cutAttributeLengths(); // try { $this->_isImport = true; if (!$importExternal) { $this->setValidationRule('uuid', 'unique', array('calendar_id', 'start_time', 'exception_for_event_id')); } // //make sure no duplicates are imported // if(!is_array($previouslyImportedEventsArray)){ // // We do not take events from previous import iterations into account, and we will do a validation check. // $this->setValidationRule('uuid', 'unique', array('calendar_id','start_time')); // }else // { // // // We take into account the history if imported items to better handle recurring events, exceptions and rescheduled events. // // if (!empty($this->rrule)) { // // \GO::debug('=== ['.\GO\Base\Util\Date::get_timestamp($this->start_time).'] '.$this->name.' (with rrule)'); // // // Handle imported recurring event. // // $existingEventModel = Event::model()->find( // \GO\Base\Db\FindParams::newInstance() // ->single() // ->criteria(\GO\Base\Db\FindCriteria::newInstance() // ->addCondition('calendar_id',$this->calendar_id) // ->addCondition('uuid',$this->uuid) // ->addCondition('rrule','','!=') // ) // ); // // if (!empty($existingEventModel)) { // // Update the existing recurring event in the calendar. // $this->id = $existingEventModel->id; // $this->setIsNew(false); // } // // } else { // // \GO::debug('=== ['.\GO\Base\Util\Date::get_timestamp($this->start_time).'] '.$this->name); // // // Handle imported non-recurring event or exception event. // // $existingEventsStmt = Event::model()->find( // \GO\Base\Db\FindParams::newInstance() // ->criteria(\GO\Base\Db\FindCriteria::newInstance() // ->addCondition('calendar_id',$this->calendar_id) // ->addCondition('uuid',$this->uuid) // ->addCondition('rrule','','=') // ) // ); // // foreach ($existingEventsStmt as $existingEventModel) { // if ($existingEventModel && !self::eventIsFromCurrentImport($existingEventModel,$previouslyImportedEventsArray)) { // // The existing event model in the database was previously imported during the current import process. // // // We rightfully assume here that the latest version of this event will be saved in Group-Office as a new event later in this function. // $existingEventModel->delete(); // } // } // // } // } if (!$this->save()) { if ($importExternal) { $installationName = !empty(\GO::config()->title) ? \GO::config()->title : 'Group-Office'; $validationErrStr = implode("\n", $this->getValidationErrors()) . "\n"; $mailSubject = str_replace(array('%cal', '%event'), array($this->calendar->name, $this->name), \GO::t('eventNotSavedSubject', 'calendar')); $body = \GO::t('eventNotSavedBody', 'calendar'); $body = str_replace(array('%goname', '%event', '%starttime', '%cal', '%errormessage'), array($installationName, $this->name, \GO\Base\Util\Date::get_timestamp($this->start_time), $this->calendar->name, $validationErrStr), $body); $message = \GO\Base\Mail\Message::newInstance($mailSubject)->setFrom(\GO::config()->webmaster_email, \GO::config()->title)->addTo($this->calendar->user->email); $message->setHtmlAlternateBody(nl2br($body)); if (\GO\Base\Mail\Mailer::newGoInstance()->send($message)) { throw new \GO\Base\Exception\Validation('DUE TO ERROR, CRON SENT MAIL TO: ' . $this->calendar->user->email . '. THIS IS THE EMAIL MESSAGE:' . "\r\n" . $body); } else { throw new \GO\Base\Exception\Validation('CRON COULD NOT SEND EMAIL WITH ERROR MESSAGE TO: ' . $this->calendar->user->email . '. THIS IS THE EMAIL MESSAGE:' . "\r\n" . $body); } } else { throw new \GO\Base\Exception\Validation(implode("\n", $this->getValidationErrors()) . "\n"); } } $this->_isImport = false; // } catch (\Exception $e) { // throw new \Exception($this->name.' ['.\GO\Base\Util\Date::get_timestamp($this->start_time).' - '.\GO\Base\Util\Date::get_timestamp($this->end_time).'] '.$e->getMessage()); // } if (!empty($exception)) { //save the exception we found by recurrence-id $exception->exception_event_id = $this->id; $exception->save(); \GO::debug("saved exception"); } // $test = (bool) $vobject->organizer; // var_dump($test); // exit(); // if ($vobject->organizer) { $p = $this->importVObjectAttendee($this, $vobject->organizer, true); } else { $p = false; } $calendarParticipantFound = !empty($p) && $p->user_id == $this->calendar->user_id; $attendees = $vobject->select('attendee'); foreach ($attendees as $attendee) { $p = $this->importVObjectAttendee($this, $attendee, false); if ($p->user_id == $this->calendar->user_id) { $calendarParticipantFound = true; } } //if the calendar owner is not in the participants then we should chnage the is_organizer flag because otherwise the event can't be opened or accepted. if (!$calendarParticipantFound) { if ($makeSureUserParticipantExists) { $participant = \GO\Calendar\Model\Participant::model()->findSingleByAttributes(array('event_id' => $this->id, 'email' => $this->calendar->user->email)); if (!$participant) { //this is a bad situation. The import thould have detected a user for one of the participants. //It uses the E-mail account aliases to determine a user. See GO_Calendar_Model_Event::importVObject $participant = new \GO\Calendar\Model\Participant(); $participant->event_id = $this->id; $participant->user_id = $this->calendar->user_id; $participant->email = $this->calendar->user->email; } else { $participant->user_id = $this->calendar->user_id; } $participant->save(); } else { $this->is_organizer = true; $this->save(); } } //Add exception dates to Event foreach ($vobject->select('EXDATE') as $i => $exdate) { try { $dts = $exdate->getDateTimes(); if ($dts === null) { continue; } foreach ($dts as $dt) { $this->addException($dt->format('U')); } } catch (Exception $e) { trigger_error($e->getMessage(), E_USER_NOTICE); } } if ($importExternal && $this->isRecurring()) { $exceptionEventsStmt = Event::model()->find(\GO\Base\Db\FindParams::newInstance()->criteria(\GO\Base\Db\FindCriteria::newInstance()->addCondition('calendar_id', $this->calendar_id)->addCondition('uuid', $this->uuid)->addCondition('rrule', '', '='))); foreach ($exceptionEventsStmt as $exceptionEventModel) { $exceptionEventModel->exception_for_event_id = $this->id; $exceptionEventModel->save(); //TODO: This method only works when an exception takes place on the same day as the original occurence. //We should store the RECURRENCE-ID value so we can find it later. $this->addException($exceptionEventModel->start_time, $exceptionEventModel->id); // \GO::debug('=== EXCEPTION EVENT === ['.\GO\Base\Util\Date::get_timestamp($exceptionEventModel->start_time).'] '.$exceptionEventModel->name.' (\Exception for event: '.$exceptionEventModel->exception_for_event_id.')'); } } } return $this; }
protected function actionImportVCard($params) { $summaryLog = new \GO\Base\Component\SummaryLog(); $readOnly = !empty($params['readOnly']); if (isset($_FILES['files']['tmp_name'][0])) { $params['file'] = $_FILES['files']['tmp_name'][0]; } if (!empty($params['importBaseParams'])) { $importBaseParams = json_decode($params['importBaseParams'], true); $params['addressbook_id'] = $importBaseParams['addressbook_id']; } $file = new \GO\Base\Fs\File($params['file']); $file->convertToUtf8(); $options = \Sabre\VObject\Reader::OPTION_FORGIVING + \Sabre\VObject\Reader::OPTION_IGNORE_INVALID_LINES; $vcards = new \Sabre\VObject\Splitter\VCard(fopen($file->path(), 'r+'), $options); unset($params['file']); $nr = 0; if ($readOnly) { $contactsAttr = array(); } while ($vObject = $vcards->getNext()) { $nr++; \GO\Base\VObject\Reader::convertVCard21ToVCard30($vObject); $contact = new \GO\Addressbook\Model\Contact(); try { if ($contact->importVObject($vObject, $params, !$readOnly)) { $summaryLog->addSuccessful(); } if ($readOnly) { $contactsAttr[] = $contact->getAttributes('formatted'); } } catch (\Exception $e) { $summaryLog->addError($nr, $e->getMessage()); } } $response = $summaryLog->getErrorsJson(); if ($readOnly) { $response['contacts'] = $contactsAttr; } $response['successCount'] = $summaryLog->getTotalSuccessful(); $response['totalCount'] = $summaryLog->getTotal(); $response['success'] = true; return $response; }
protected function actionImportIcs($params) { $file = new \GO\Base\Fs\File($params['file']); $data = $file->getContents(); $vcalendar = \GO\Base\VObject\Reader::read($data); \GO\Base\VObject\Reader::convertVCalendarToICalendar($vcalendar); foreach ($vcalendar->vtodo as $vtodo) { $task = new \GO\Tasks\Model\Task(); $task->importVObject($vtodo); } }
private function _importSmarterMailXml($params, File $file) { $sXml = new SimpleXMLElement($file->getContents()); $count = 0; $failed = array(); foreach ($sXml->children() as $obj) { if ($obj->getName() == 'Event') { $event = new Event(); try { $data = (string) $obj->Data; // \GO::debug($data); $vObject = \GO\Base\VObject\Reader::read($data); $event->importVObject($vObject->vevent[0], array('calendar_id' => $params['calendar_id'])); $count++; // break; } catch (\Exception $e) { $failed[] = $e->getMessage(); } } } $response['feedback'] = sprintf(\GO::t('import_success', 'calendar'), $count); if (count($failed)) { $response['feedback'] .= "\n\n" . count($failed) . " events failed: " . implode("\n", $failed); } return $response; }