Beispiel #1
0
function rrule_endtime($int, $freq, $start, $end)
{
    // if # then we have to add the difference to the start time
    if (preg_match("/^#(.+)\$/i", $end, $M)) {
        $T = $M[1] * $freq;
        $plus_d = $plus_m = $plus_y = '0';
        if ($int == '1') {
            $plus_d = $T;
        } elseif ($int == '2') {
            $plus_d = $T * 7;
        } elseif ($int == '3') {
            $plus_m = $T;
        } elseif ($int == '4') {
            $plus_m = $T;
        } elseif ($int == '5') {
            $plus_y = $T;
        } elseif ($int == '6') {
            $plus_m = $T;
        }
        $endtime = icaldate_to_timestamp($start, $plus_d, $plus_m, $plus_y);
        // if we have the enddate
    } else {
        $endtime = icaldate_to_timestamp($end);
    }
    return $endtime;
}
Beispiel #2
0
function parse_outlookcsv($cal_file)
{
    global $errormsg, $tz;
    $outlookcsv_data = array();
    if (!($fd = @fopen($cal_file, 'r'))) {
        $errormsg .= 'Cannot read temporary file: ' . "{$cal_file}\n";
        exit;
    } else {
        # Burn First Row of Headers
        $data = fgetcsv($fd, @filesize($cal_file), ',');
        while ($data = fgetcsv($fd, @filesize($cal_file))) {
            $subject = addslashes($data[0]);
            $start = icaldate_to_timestamp(date('Ymd\\THis', strtotime($data[1] . ' ' . $data[2])));
            $end = icaldate_to_timestamp(date('Ymd\\THis', strtotime($data[3] . ' ' . $data[4])));
            $all_day_event = (int) toBoolean($data[5]);
            $remind_on_off = (int) toBoolean($data[6]);
            $reminder = icaldate_to_timestamp(date('Ymd\\THis', strtotime($data[7] . ' ' . $data[8])));
            $meeting_organizer = $data[9];
            $required_attendies = $data[10];
            $optional_attendies = $data[11];
            $meeting_resources = $data[12];
            $billing_information = $data[13];
            $categories = addslashes(str_replace(';', ',', $data[14]));
            $description = addslashes($data[15]);
            $location = addslashes($data[16]);
            $mileage = $data[17];
            $priority = $data[18];
            $class = (int) toBoolean($data[19]);
            $sensitivity = $data[20];
            $show_time_as = $data[21];
            /*
             * Start New Section For Outlook CSV
             */
            // $tmp_data['RecordID']  = ;
            $tmp_data['StartTime'] = $start;
            // In seconds since 1970 (Unix Epoch)
            $tmp_data['EndTime'] = $end;
            // In seconds since 1970 (Unix Epoch)
            $tmp_data['Summary'] = $subject;
            // Summary of event (string)
            $tmp_data['Duration'] = dateDifference($start, $end, 1);
            // How long the event lasts (in minutes)
            $tmp_data['Description'] = $description;
            // Full Description (string)
            $tmp_data['Location'] = $location;
            // Location (string)
            $tmp_data['AllDay'] = $all_day_event;
            // 1 = true  0 = false
            $tmp_data['Class'] = $class == 1 ? 'R' : 'P';
            $tmp_data['Categories'] = get_categories_id_byname($categories);
            $tmp_data['AlarmSet'] = $remind_on_off;
            // 1 = true  0 = false
            $tmp_data['ADate'] = $reminder;
            // Date/Time of Alarm
            $tmp_data['AAction'] = 'EMAIL';
            // The default action
            $tmp_data['CalendarType'] = 'VEVENT';
            // The default type
            $outlookcsv_data[] = $tmp_data;
        }
        // End while
        fclose($fd);
    }
    return $outlookcsv_data;
}
Beispiel #3
0
function format_ical($event)
{
    global $login;
    // Set Product ID
    $fevent['Prodid'] = !empty($event['prodid']) ? $event['prodid'] : '';
    // Set Calendar Type for easier processing later
    $fevent['CalendarType'] = $event['state'];
    $fevent['Untimed'] = $fevent['AllDay'] = 0;
    // Categories
    if (isset($event['categories'])) {
        // $fevent['Categories']  will contain an array of cat_id(s) that match the
        // category_names
        $fevent['Categories'] = get_categories_id_byname(utf8_decode($event['categories']));
    }
    // Start and end time
    /* Snippet from RFC2445
      For cases where a "VEVENT" calendar component specifies a "DTSTART"
       property with a DATE data type but no "DTEND" property, the events
       non-inclusive end is the end of the calendar date specified by the
       "DTSTART" property. For cases where a "VEVENT" calendar component
       specifies a "DTSTART" property with a DATE-TIME data type but no
       "DTEND" property, the event ends on the same calendar date and time
       of day specified by the "DTSTART" property. */
    $dtstartTzid = !empty($event['dtstartTzid']) ? $event['dtstartTzid'] : '';
    $fevent['StartTime'] = icaldate_to_timestamp($event['dtstart'], $dtstartTzid);
    if (isset($event['dtend'])) {
        $dtendTzid = !empty($event['dtendTzid']) ? $event['dtendTzid'] : '';
        $fevent['EndTime'] = icaldate_to_timestamp($event['dtend'], $dtendTzid);
        if ($fevent['StartTime'] == $fevent['EndTime']) {
            $fevent['Untimed'] = 1;
            $fevent['Duration'] = 0;
        } else {
            $fevent['Duration'] = ($fevent['EndTime'] - $fevent['StartTime']) / 60;
        }
    } else {
        if (isset($event['duration'])) {
            $fevent['EndTime'] = $fevent['StartTime'] + $event['duration'] * 60;
            $fevent['Duration'] = $event['duration'];
        } else {
            if (isset($event['dtstartDATETIME'])) {
                // Untimed
                $fevent['EndTime'] = $fevent['StartTime'];
                $fevent['Untimed'] = 1;
                $fevent['Duration'] = 0;
            }
        }
    }
    if (isset($event['dtstartDATE']) && !isset($event['dtendDATE'])) {
        // Untimed
        $fevent['StartTime'] = icaldate_to_timestamp($event['dtstart'], 'GMT');
        $fevent['EndTime'] = $fevent['StartTime'];
        $fevent['Untimed'] = 1;
        $fevent['Duration'] = 0;
        //$fevent['EndTime'] = $fevent['StartTime'] + 86400;
        //$fevent['AllDay'] = 1;
        //$fevent['Duration'] = 1440;
    } else {
        if (isset($event['dtstartDATE']) && isset($event['dtendDATE'])) {
            $fevent['StartTime'] = icaldate_to_timestamp($event['dtstart'], 'GMT');
            // This is an untimed event
            if ($event['dtstart'] == $event['dtend']) {
                $fevent['EndTime'] = $fevent['StartTime'];
                $fevent['Untimed'] = 1;
                $fevent['Duration'] = 0;
            } else {
                $fevent['EndTime'] = icaldate_to_timestamp($event['dtend'], 'GMT');
                $fevent['Duration'] = ($fevent['EndTime'] - $fevent['StartTime']) / 60;
                if ($fevent['Duration'] == 1440) {
                    $fevent['AllDay'] = 1;
                }
            }
        }
    }
    // catch 22
    if (!isset($fevent['EndTime'])) {
        $fevent['EndTime'] = $fevent['StartTime'];
    }
    if (!isset($fevent['Duration'])) {
        $fevent['Duration'] = 0;
    }
    if (empty($event['summary'])) {
        $event['summary'] = translate('Unnamed Event');
    }
    $fevent['Summary'] = utf8_decode($event['summary']);
    if (!empty($event['description'])) {
        $fevent['Description'] = utf8_decode($event['description']);
    } else {
        $fevent['Description'] = $fevent['Summary'];
    }
    if (!empty($event['class'])) {
        // Added  Confidential as new CLASS
        if (preg_match('/private/i', $event['class'])) {
            $fevent['Class'] = 'R';
        } elseif (preg_match('/confidential/i', $event['class'])) {
            $fevent['Class'] = 'C';
        } else {
            $fevent['Class'] = 'P';
        }
    }
    $fevent['UID'] = $event['uid'];
    // Process VALARM stuff
    if (!empty($event['alarm_trigger'])) {
        $fevent['AlarmSet'] = 1;
        if (preg_match("/VALUE=DATE-TIME:(.*)\$/i", $event['alarm_trigger'], $match)) {
            $fevent['ADate'] = icaldate_to_timestamp($match[1]);
        } else {
            $duration = parse_ISO8601_duration($event['alarm_trigger']);
            $fevent['AOffset'] = abs($duration);
            $fevent['ABefore'] = $duration < 0 ? 'N' : 'Y';
        }
        if (!empty($event['alarm_action'])) {
            $fevent['AAction'] = $event['alarm_action'];
        }
        if (!empty($event['alarm_repeat'])) {
            $fevent['ARepeat'] = $event['alarm_repeat'];
        }
        if (!empty($event['alarm_duration'])) {
            $fevent['ADuration'] = abs(parse_ISO8601_duration($event['alarm_duration']));
        }
        if (!empty($event['alarm_related'])) {
            $fevent['ARelated'] = $event['alarm_related'] == 'END' ? 'E' : 'S';
        }
    }
    if (!empty($event['status'])) {
        switch ($event['status']) {
            case 'TENTATIVE':
                // case 'NEEDS-ACTION': Sunbird sets this if you touch task without
                // changing anything else. Not sure about other clients yet
                $fevent['Status'] = 'W';
                break;
            case 'CONFIRMED':
            case 'ACCEPTED':
                $fevent['Status'] = 'A';
                break;
            case 'CANCELLED':
                $fevent['Status'] = 'D';
                break;
            case 'DECLINED':
                $fevent['Status'] = 'R';
                break;
            case 'COMPLETED':
                $fevent['Status'] = 'C';
                break;
            case 'IN-PROGRESS':
                $fevent['Status'] = 'P';
                break;
            default:
                $fevent['Status'] = 'A';
                break;
        }
        //end switch
    } else {
        $fevent['Status'] = 'A';
    }
    if (!empty($event['location'])) {
        $fevent['Location'] = utf8_decode($event['location']);
    }
    if (!empty($event['url'])) {
        $fevent['URL'] = utf8_decode($event['url']);
    }
    if (!empty($event['priority'])) {
        $fevent['PRIORITY'] = $event['priority'];
    }
    if (!empty($event['transparency'])) {
        if (preg_match('/TRANSPARENT/i', $event['transparency']) or $event['transparency'] == 1) {
            $fevent['Transparency'] = 1;
        } else {
            $fevent['Transparency'] = 0;
        }
    } else {
        $fevent['Transparency'] = 0;
    }
    // VTODO specific items
    if (!empty($event['due'])) {
        $fevent['Due'] = $event['due'];
    }
    if (!empty($event['completed'])) {
        $fevent['Completed'] = $event['completed'];
    }
    if (!empty($event['percent'])) {
        $fevent['Percent'] = $event['percent'];
    }
    // Repeating exceptions
    $fevent['Repeat']['Exceptions'] = array();
    if (!empty($event['exdate']) && $event['exdate']) {
        $EX = explode(',', $event['exdate']);
        foreach ($EX as $exdate) {
            $fevent['Repeat']['Exceptions'][] = icaldate_to_timestamp($exdate);
        }
        $fevent['Repeat']['Frequency'] = 7;
        //manual, this can be changed later
    }
    // Repeating inclusions
    $fevent['Repeat']['Inclusions'] = array();
    if (!empty($event['rdate']) && $event['rdate']) {
        $R = explode(',', $event['rdate']);
        foreach ($R as $rdate) {
            $fevent['Repeat']['Inclusions'][] = icaldate_to_timestamp($rdate);
        }
        $fevent['Repeat']['Frequency'] = 7;
        //manual, this can be changed later
    }
    /* Repeats
      Snippet from RFC2445
     If multiple BYxxx rule parts are specified, then after evaluating the
       specified FREQ and INTERVAL rule parts, the BYxxx rule parts are
       applied to the current set of evaluated occurrences in the following
       order: BYMONTH, BYWEEKNO, BYYEARDAY, BYMONTHDAY, BYDAY, BYHOUR,
       BYMINUTE, BYSECOND and BYSETPOS; then COUNT and UNTIL are evaluated.
     */
    // Handle RRULE
    if (!empty($event['rrule'])) {
        // default value
        // first remove any UNTIL that may have been calculated above
        unset($fevent['Repeat']['Until']);
        // split into pieces
        // echo "RRULE line: $event[rrule]<br />\n";
        $RR = explode(';', $event['rrule']);
        // create an associative array of key-value pairs in $RR2[]
        $rrcnt = count($RR);
        for ($i = 0; $i < $rrcnt; $i++) {
            $ar = explode('=', $RR[$i]);
            $RR2[$ar[0]] = $ar[1];
        }
        for ($i = 0; $i < $rrcnt; $i++) {
            if (preg_match("/^FREQ=(.+)\$/i", $RR[$i], $match)) {
                if (preg_match("/YEARLY/i", $match[1], $submatch)) {
                    $fevent['Repeat']['Frequency'] = 6;
                } else {
                    if (preg_match("/MONTHLY/i", $match[1], $submatch)) {
                        $fevent['Repeat']['Frequency'] = 3;
                        //MonthByDay
                    } else {
                        if (preg_match("/WEEKLY/i", $match[1], $submatch)) {
                            $fevent['Repeat']['Frequency'] = 2;
                        } else {
                            if (preg_match("/DAILY/i", $match[1], $submatch)) {
                                $fevent['Repeat']['Frequency'] = 1;
                            } else {
                                // not supported :-(
                                // but don't overwrite Manual setting from above
                                if ($fevent['Repeat']['Frequency'] != 7) {
                                    $fevent['Repeat']['Frequency'] = 0;
                                }
                                echo "Unsupported iCal FREQ value \"{$match['1']}\"<br />\n";
                                // Abort this import
                                return;
                            }
                        }
                    }
                }
            } else {
                if (preg_match("/^INTERVAL=(.+)\$/i", $RR[$i], $match)) {
                    $fevent['Repeat']['Interval'] = $match[1];
                } else {
                    if (preg_match("/^UNTIL=(.+)\$/i", $RR[$i], $match)) {
                        // specifies an end date
                        $fevent['Repeat']['Until'] = icaldate_to_timestamp($match[1]);
                    } else {
                        if (preg_match("/^COUNT=(.+)\$/i", $RR[$i], $match)) {
                            // specifies the number of repeats
                            // We convert this to a true UNTIL after we parse exceptions
                            $fevent['Repeat']['Count'] = $match[1];
                        } else {
                            if (preg_match("/^BYSECOND=(.+)\$/i", $RR[$i], $match)) {
                                // NOT YET SUPPORTED -- TODO
                                echo "Unsupported iCal BYSECOND value \"{$RR[$i]}\"<br />\n";
                            } else {
                                if (preg_match("/^BYMINUTE=(.+)\$/i", $RR[$i], $match)) {
                                    // NOT YET SUPPORTED -- TODO
                                    echo "Unsupported iCal BYMINUTE value \"{$RR[$i]}\"<br />\n";
                                } else {
                                    if (preg_match("/^BYHOUR=(.+)\$/i", $RR[$i], $match)) {
                                        // NOT YET SUPPORTED -- TODO
                                        echo "Unsupported iCal BYHOUR value \"{$RR[$i]}\"<br />\n";
                                    } else {
                                        if (preg_match("/^BYMONTH=(.+)\$/i", $RR[$i], $match)) {
                                            // this event repeats during the specified months
                                            $fevent['Repeat']['ByMonth'] = $match[1];
                                        } else {
                                            if (preg_match("/^BYDAY=(.+)\$/i", $RR[$i], $match)) {
                                                // this array contains integer offset (i.e. 1SU,1MO,1TU)
                                                $fevent['Repeat']['ByDay'] = $match[1];
                                            } else {
                                                if (preg_match("/^BYMONTHDAY=(.+)\$/i", $RR[$i], $match)) {
                                                    $fevent['Repeat']['ByMonthDay'] = $match[1];
                                                    // $fevent['Repeat']['Frequency'] = 3; //MonthlyByDay
                                                } else {
                                                    if (preg_match("/^BYSETPOS=(.+)\$/i", $RR[$i], $match)) {
                                                        // if not already Yearly, mark as MonthlyBySetPos
                                                        if ($fevent['Repeat']['Frequency'] != 6) {
                                                            $fevent['Repeat']['Frequency'] = 5;
                                                        }
                                                        $fevent['Repeat']['BySetPos'] = $match[1];
                                                    } else {
                                                        if (preg_match("/^BYWEEKNO=(.+)\$/i", $RR[$i], $match)) {
                                                            $fevent['Repeat']['ByWeekNo'] = $match[1];
                                                        } else {
                                                            if (preg_match("/^BYYEARDAY=(.+)\$/i", $RR[$i], $match)) {
                                                                $fevent['Repeat']['ByYearDay'] = $match[1];
                                                            } else {
                                                                if (preg_match("/^WKST=(.+)\$/i", $RR[$i], $match)) {
                                                                    $fevent['Repeat']['Wkst'] = $match[1];
                                                                }
                                                            }
                                                        }
                                                    }
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
    // end if rrule
    return $fevent;
}