1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139:
<?php
require_once("iCalendar.php");
require_once("DAVResource.php");
function obfuscated_event( $icalendar ) {
$confidential = new iCalComponent();
$confidential->SetType($icalendar->GetType());
$confidential->AddProperty( 'SUMMARY', translate('Busy') );
$confidential->AddProperty( 'CLASS', 'CONFIDENTIAL' );
$confidential->SetProperties( $icalendar->GetProperties('DTSTART'), 'DTSTART' );
$confidential->SetProperties( $icalendar->GetProperties('RRULE'), 'RRULE' );
$confidential->SetProperties( $icalendar->GetProperties('DURATION'), 'DURATION' );
$confidential->SetProperties( $icalendar->GetProperties('DTEND'), 'DTEND' );
$confidential->SetProperties( $icalendar->GetProperties('UID'), 'UID' );
$confidential->SetProperties( $icalendar->GetProperties('CREATED'), 'CREATED' );
return $confidential;
}
function export_iCalendar( DAVResource $dav_resource ) {
global $session, $c, $request;
if ( ! $dav_resource->IsCalendar() && !(isset($c->get_includes_subcollections) && $c->get_includes_subcollections) ) {
header("Allow: PROPFIND,PROPPATCH,OPTIONS,MKCOL,REPORT,DELETE");
$request->DoResponse( 405, translate("GET requests on collections are only supported for calendars.") );
}
if ( isset($c->get_includes_subcollections) && $c->get_includes_subcollections ) {
$where = 'caldav_data.collection_id IN ';
$where .= '(SELECT bound_source_id FROM dav_binding WHERE dav_binding.dav_name ~ :path_match ';
$where .= 'UNION ';
$where .= 'SELECT collection_id FROM collection WHERE collection.dav_name ~ :path_match) ';
$params = array( ':path_match' => '^'.$dav_resource->dav_name() );
$distinct = 'DISTINCT ON (calendar_item.uid) ';
}
else {
$where = 'caldav_data.collection_id = :collection_id ';
$params = array( ':collection_id' => $dav_resource->resource_id() );
$distinct = '';
}
$sql = 'SELECT '.$distinct.' caldav_data, class, caldav_type, calendar_item.user_no, logged_user ';
$sql .= 'FROM collection INNER JOIN caldav_data USING(collection_id) ';
$sql .= 'INNER JOIN calendar_item USING ( dav_id ) WHERE '.$where;
if ( isset($c->strict_result_ordering) && $c->strict_result_ordering ) $sql .= ' ORDER BY calendar_item.uid, calendar_item.dav_id';
$qry = new AwlQuery( $sql, $params );
if ( !$qry->Exec("GET",__LINE__,__FILE__) ) {
$request->DoResponse( 500, translate("Database Error") );
}
$vcal = new iCalComponent();
$vcal->VCalendar();
$displayname = $dav_resource->GetProperty('displayname');
if ( isset($displayname) ) {
$vcal->AddProperty("X-WR-CALNAME", $displayname);
}
if ( !empty($c->auto_refresh_duration) ) {
$vcal->AddProperty("X-APPLE-AUTO-REFRESH-INTERVAL", $c->auto_refresh_duration);
$vcal->AddProperty("AUTO-REFRESH", $c->auto_refresh_duration);
$vcal->AddProperty("X-PUBLISHED-TTL", $c->auto_refresh_duration);
}
$need_zones = array();
$timezones = array();
while( $event = $qry->Fetch() ) {
$ical = new iCalComponent( $event->caldav_data );
$event_zones = $ical->GetComponents('VTIMEZONE',true);
foreach( $event_zones AS $k => $tz ) {
$tzid = $tz->GetPValue('TZID');
if ( !isset($tzid) ) continue ;
if ( $tzid != '' && !isset($timezones[$tzid]) ) {
$timezones[$tzid] = $tz;
}
}
$comps = $ical->GetComponents('VTIMEZONE',false);
foreach( $comps AS $k => $comp ) {
$tzid = $comp->GetPParamValue('DTSTART', 'TZID'); if ( isset($tzid) && !isset($need_zones[$tzid]) ) $need_zones[$tzid] = 1;
$tzid = $comp->GetPParamValue('DUE', 'TZID'); if ( isset($tzid) && !isset($need_zones[$tzid]) ) $need_zones[$tzid] = 1;
$tzid = $comp->GetPParamValue('DTEND', 'TZID'); if ( isset($tzid) && !isset($need_zones[$tzid]) ) $need_zones[$tzid] = 1;
if ( $dav_resource->HavePrivilegeTo('all',false) || $session->user_no == $event->user_no || $session->user_no == $event->logged_user
|| ( isset($session->email) && $c->allow_get_email_visibility && $comp->IsAttendee($session->email) ) ) {
$vcal->AddComponent($comp);
continue;
}
if ( $event->class == 'PRIVATE' ) continue;
if ( ! $dav_resource->HavePrivilegeTo('DAV::read') || $event->class == 'CONFIDENTIAL' ) {
$vcal->AddComponent(obfuscated_event($comp));
}
elseif ( isset($c->hide_alarm) && $c->hide_alarm ) {
$comp->ClearComponents('VALARM');
$vcal->AddComponent($comp);
}
else {
$vcal->AddComponent($comp);
}
}
}
foreach( $need_zones AS $tzid => $v ) {
if ( isset($timezones[$tzid]) ) $vcal->AddComponent($timezones[$tzid]);
}
return $vcal->Render();
}