Overview

Packages

  • awl
    • caldav-client-v2
    • RRule
  • davical
    • authentication
      • drivers
    • caldav
    • DAViCalSession
    • DAVTicket
    • external-bind
    • feed
    • HTTPAuthSession
    • iSchedule
    • iSchedule-POST
    • logging
    • metrics
    • Principal
    • propfind
    • PublicSession
    • Request
    • Resource
    • tzservice
  • None
  • PHP

Classes

  • CalDAVClient
  • CheckResult
  • setupFakeSession
  • VCard
  • VTimezone

Functions

  • access_ticket_browser
  • binding_row_editor
  • bindings_to_other_browser
  • bindings_to_us_browser
  • build_dependencies_table
  • build_privileges_html
  • build_site_statistics
  • BuildSqlFilter
  • calquery_apply_filter
  • cardquery_apply_filter
  • catch_setup_errors
  • check_awl_version
  • check_calendar
  • check_curl
  • check_database_connection
  • check_datetime
  • check_davical_version
  • check_gettext
  • check_iconv
  • check_ldap
  • check_magic_quotes_gpc
  • check_magic_quotes_runtime
  • check_pdo
  • check_pdo_pgsql
  • check_pgsql
  • check_real_php
  • check_schema_version
  • check_string
  • check_suhosin_server_strip
  • check_xml
  • collection_privilege_format_function
  • confirm_delete_bind_in
  • confirm_delete_binding
  • confirm_delete_collection
  • confirm_delete_principal
  • confirm_delete_ticket
  • do_error
  • edit_binding_row
  • edit_grant_row_collection
  • edit_grant_row_principal
  • edit_group_row
  • edit_ticket_row
  • errorResponse
  • expand_properties
  • fetch_external
  • get_address_properties
  • get_freebusy
  • get_href_containers
  • get_phpinfo
  • grant_row_editor
  • group_members_browser
  • group_memberships_browser
  • group_row_editor
  • handle_subaction
  • i18n
  • ischedule_get
  • log_setup_error
  • make_help_link
  • principal_collection_browser
  • principal_editor
  • principal_grants_browser
  • principal_privilege_format_function
  • send_page_header
  • SqlFilterCardDAV
  • SqlFilterFragment
  • ticket_row_editor
  • unicodeToUtf8
  • update_external
  • utf8ToUnicode
  • Overview
  • Package
  • Function
  • Tree
  • Deprecated
  • Todo
 1: <?php
 2: 
 3: /**
 4:  * Function to include which handles building a free/busy response to
 5:  * be used in either the REPORT, response to a POST, or response to a
 6:  * a freebusy GET request.
 7:  */
 8: 
 9: include_once('vCalendar.php');
10: include_once('RRule.php');
11: 
12: 
13: function get_freebusy( $path_match, $range_start, $range_end, $bin_privs = null ) {
14:   global $request, $c;
15:   dbg_error_log( 'freebusy', ' Getting freebusy for path %s from %s to %s', $path_match, $range_start, $range_end);
16: 
17:   if ( !isset($bin_privs) ) $bin_privs = $request->Privileges();
18:   if ( !isset($range_start) || !isset($range_end) ) {
19:     $request->DoResponse( 400, 'All valid freebusy requests MUST contain a time-range filter' );
20:   }
21:   $params = array( ':path_match' => $path_match, ':start' => $range_start->UTC(), ':end' => $range_end->UTC() );
22:   $where = ' WHERE caldav_data.dav_name ~ :path_match ';
23:   $where .= 'AND rrule_event_overlaps( dtstart, dtend, rrule, :start, :end) ';
24:   $where .= "AND caldav_data.caldav_type IN ( 'VEVENT', 'VTODO' ) ";
25:   $where .= "AND (calendar_item.transp != 'TRANSPARENT' OR calendar_item.transp IS NULL) ";
26:   $where .= "AND (calendar_item.status != 'CANCELLED' OR calendar_item.status IS NULL) ";
27:   $where .= "AND collection.is_calendar AND collection.schedule_transp = 'opaque' ";
28: 
29:   if ( $bin_privs != privilege_to_bits('all') ) {
30:     $where .= "AND (calendar_item.class != 'PRIVATE' OR calendar_item.class IS NULL) ";
31:   }
32: 
33:   $fbtimes = array();
34:   $sql = 'SELECT caldav_data.caldav_data, calendar_item.rrule, calendar_item.transp, calendar_item.status, ';
35:   $sql .= "to_char(calendar_item.dtstart at time zone 'GMT',".AWLDatabase::SqlUTCFormat.') AS start, ';
36:   $sql .= "to_char(calendar_item.dtend at time zone 'GMT',".AWLDatabase::SqlUTCFormat.') AS finish, ';
37:   $sql .= "calendar_item.class, calendar_item.dav_id ";
38:   $sql .= 'FROM caldav_data INNER JOIN calendar_item USING(dav_id,user_no,dav_name,collection_id) ';
39:   $sql .= 'INNER JOIN collection USING(collection_id)';
40:   $sql .= $where;
41:   if ( isset($c->strict_result_ordering) && $c->strict_result_ordering ) $sql .= ' ORDER BY dav_id';
42:   $qry = new AwlQuery( $sql, $params );
43:   if ( $qry->Exec("REPORT",__LINE__,__FILE__) && $qry->rows() > 0 ) {
44:     while( $calendar_object = $qry->Fetch() ) {
45:       $extra = '';
46:       if ( $calendar_object->status == 'TENTATIVE' ) {
47:         $extra = ';BUSY-TENTATIVE';
48:       }
49:       else if ( isset($c->_workaround_client_freebusy_bug) && $c->_workaround_client_freebusy_bug ) {
50:         $extra = ';BUSY';
51:       }
52:       //$extra = ';'.$calendar_object->dav_id;
53:       $ics = new vComponent($calendar_object->caldav_data);
54:       $expanded = expand_event_instances($ics, $range_start, $range_end);
55:       $expansion = $expanded->GetComponents( array('VEVENT'=>true,'VTODO'=>true,'VJOURNAL'=>true) );
56:       dbg_error_log( "freebusy", "===================   $calendar_object->dav_id   ======================== %s -> %s, %s %s", $calendar_object->start, $calendar_object->finish, $calendar_object->class, $extra );
57:       $dtstart_type = 'DTSTART';
58:       foreach( $expansion AS $k => $v ) {
59:         dbg_error_log( "freebusy", " %s: %s", $k, $v->Render() );
60:         $start_date = $v->GetProperty($dtstart_type);
61:         if ( !isset($start_date) && $v->GetType() != 'VTODO' ) {
62:             $dtstart_type = 'DUE';
63:             $start_date = $v->GetProperty($dtstart_type);
64:         }
65:         $start_date = new RepeatRuleDateTime($start_date);
66:         $duration = $v->GetProperty('DURATION');
67:         $duration = ( !isset($duration) ? 'P1D' : $duration->Value());
68:         $end_date = clone($start_date);
69:         $end_date->modify( $duration );
70:         if ( $end_date == $start_date || $end_date < $range_start || $start_date > $range_end ) {
71:           dbg_error_log( "freebusy", "-----------------------------------------------------" );
72:           continue;
73:         }
74:         $thisfb = $start_date->UTC() .'/'. $end_date->UTC() . $extra;
75:         array_push( $fbtimes, $thisfb );
76:       }
77:     }
78:   }
79: 
80:   $freebusy = new vComponent();
81:   $freebusy->setType('VFREEBUSY');
82:   $freebusy->AddProperty('DTSTAMP', date('Ymd\THis\Z'));
83:   $freebusy->AddProperty('DTSTART', $range_start->UTC());
84:   $freebusy->AddProperty('DTEND', $range_end->UTC());
85: 
86:   sort( $fbtimes );
87:   foreach( $fbtimes AS $k => $v ) {
88:     $text = explode(';',$v,2);
89:     $freebusy->AddProperty( 'FREEBUSY', $text[0], (isset($text[1]) ? array('FBTYPE' => $text[1]) : null) );
90:   }
91: 
92:   return $freebusy;
93: }
94: 
95: 
DAViCal API documentation generated by ApiGen 2.8.0