[3733] | 1 | <?php |
---|
| 2 | /** |
---|
| 3 | * CalDAV Server - handle PUT method |
---|
| 4 | * |
---|
| 5 | * @package davical |
---|
| 6 | * @subpackage caldav |
---|
| 7 | * @author Andrew McMillan <andrew@morphoss.com> |
---|
| 8 | * @copyright Morphoss Ltd - http://www.morphoss.com/ |
---|
| 9 | * @license http://gnu.org/copyleft/gpl.html GNU GPL v2 or later version |
---|
| 10 | */ |
---|
| 11 | |
---|
| 12 | /** |
---|
| 13 | * Check if the user wants to put just one VEVENT/VTODO or a whole calendar |
---|
| 14 | * if the collection = calendar = $request_container doesn't exist then create it |
---|
| 15 | * return true if it's a whole calendar |
---|
| 16 | */ |
---|
| 17 | |
---|
| 18 | require_once('iCalendar.php'); |
---|
| 19 | require_once('DAVResource.php'); |
---|
| 20 | include_once ("drivers_ldap.php"); |
---|
| 21 | $bad_events = null; |
---|
| 22 | |
---|
| 23 | /** |
---|
| 24 | * A regex which will match most reasonable timezones acceptable to PostgreSQL. |
---|
| 25 | */ |
---|
| 26 | $tz_regex = ':^(Africa|America|Antarctica|Arctic|Asia|Atlantic|Australia|Brazil|Canada|Chile|Etc|Europe|Indian|Mexico|Mideast|Pacific|US)/[a-z_]+$:i'; |
---|
| 27 | |
---|
| 28 | /** |
---|
| 29 | * This function launches an error |
---|
| 30 | * @param boolean $caldav_context Whether we are responding via CalDAV or interactively |
---|
| 31 | * @param int $user_no the user who will receive this ics file |
---|
| 32 | * @param string $path the $path where the PUT failed to store such as /user_foo/home/ |
---|
| 33 | * @param string $message An optional error message to return to the client |
---|
| 34 | * @param int $error_no An optional value for the HTTP error code |
---|
| 35 | */ |
---|
| 36 | function rollback_on_error( $caldav_context, $user_no, $path, $message='', $error_no=500 ) { |
---|
| 37 | global $c, $bad_events; |
---|
| 38 | if ( !$message ) $message = translate('Database error'); |
---|
| 39 | $qry = new AwlQuery(); |
---|
| 40 | $qry->Rollback(); |
---|
| 41 | if ( $caldav_context ) { |
---|
| 42 | if ( isset($bad_events) && isset($c->skip_bad_event_on_import) && $c->skip_bad_event_on_import ) { |
---|
| 43 | $bad_events[] = $message; |
---|
| 44 | } |
---|
| 45 | else { |
---|
| 46 | global $request; |
---|
| 47 | $request->DoResponse( $error_no, $message ); |
---|
| 48 | } |
---|
| 49 | // and we don't return from that, ever... |
---|
| 50 | } |
---|
| 51 | |
---|
| 52 | $c->messages[] = sprintf(translate('Status: %d, Message: %s, User: %d, Path: %s'), $error_no, $message, $user_no, $path); |
---|
| 53 | |
---|
| 54 | } |
---|
| 55 | |
---|
| 56 | |
---|
| 57 | |
---|
| 58 | /** |
---|
| 59 | * Work out the location we are doing the PUT to, and check that we have the rights to |
---|
| 60 | * do the needful. |
---|
| 61 | * @param string $username The name of the destination user |
---|
| 62 | * @param int $user_no The user making the change |
---|
| 63 | * @param string $path The DAV path the resource is bing PUT to |
---|
| 64 | * @param boolean $caldav_context Whether we are responding via CalDAV or interactively |
---|
| 65 | * @param boolean $public Whether the collection will be public, should we need to create it |
---|
| 66 | */ |
---|
| 67 | function controlRequestContainer( $username, $user_no, $path, $caldav_context, $public = null ) { |
---|
| 68 | global $c, $bad_events; |
---|
| 69 | |
---|
| 70 | // Check to see if the path is like /foo /foo/bar or /foo/bar/baz etc. (not ending with a '/', but contains at least one) |
---|
| 71 | if ( preg_match( '#^(.*/)([^/]+)$#', $path, $matches ) ) {//( |
---|
| 72 | $request_container = $matches[1]; // get everything up to the last '/' |
---|
| 73 | } |
---|
| 74 | else { |
---|
| 75 | // In this case we must have a URL with a trailing '/', so it must be a collection. |
---|
| 76 | $request_container = $path; |
---|
| 77 | } |
---|
| 78 | |
---|
| 79 | if ( isset($c->skip_bad_event_on_import) && $c->skip_bad_event_on_import ) { |
---|
| 80 | $bad_events = array(); |
---|
| 81 | } |
---|
| 82 | |
---|
| 83 | /** |
---|
| 84 | * Before we write the event, we check the container exists, creating it if it doesn't |
---|
| 85 | */ |
---|
| 86 | if ( $request_container == "/$username/" ) { |
---|
| 87 | /** |
---|
| 88 | * Well, it exists, and we support it, but it is against the CalDAV spec |
---|
| 89 | */ |
---|
| 90 | dbg_error_log( 'WARN', ' Storing events directly in user\'s base folders is not recommended!'); |
---|
| 91 | } |
---|
| 92 | else { |
---|
| 93 | $sql = 'SELECT * FROM collection WHERE dav_name = :dav_name'; |
---|
| 94 | $qry = new AwlQuery( $sql, array( ':dav_name' => $request_container) ); |
---|
| 95 | if ( ! $qry->Exec('PUT',__LINE__,__FILE__) ) { |
---|
| 96 | rollback_on_error( $caldav_context, $user_no, $path ); |
---|
| 97 | } |
---|
| 98 | if ( !isset($c->readonly_webdav_collections) || $c->readonly_webdav_collections == true ) { |
---|
| 99 | if ( $qry->rows() == 0 ) { |
---|
| 100 | $request->DoResponse( 405 ); // Method not allowed |
---|
| 101 | } |
---|
| 102 | return; |
---|
| 103 | } |
---|
| 104 | if ( $qry->rows() == 0 ) { |
---|
| 105 | if ( $public == true ) $public = 't'; else $public = 'f'; |
---|
| 106 | if ( preg_match( '{^(.*/)([^/]+)/$}', $request_container, $matches ) ) { |
---|
| 107 | $parent_container = $matches[1]; |
---|
| 108 | $displayname = $matches[2]; |
---|
| 109 | } |
---|
| 110 | $sql = 'INSERT INTO collection ( user_no, parent_container, dav_name, dav_etag, dav_displayname, is_calendar, created, modified, publicly_readable, resourcetypes ) |
---|
| 111 | VALUES( :user_no, :parent_container, :dav_name, :dav_etag, :dav_displayname, TRUE, current_timestamp, current_timestamp, :is_public::boolean, :resourcetypes )'; |
---|
| 112 | $params = array( |
---|
| 113 | ':user_no' => $user_no, |
---|
| 114 | ':parent_container' => $parent_container, |
---|
| 115 | ':dav_name' => $request_container, |
---|
| 116 | ':dav_etag' => md5($user_no. $request_container), |
---|
| 117 | ':dav_displayname' => $displayname, |
---|
| 118 | ':is_public' => $public, |
---|
| 119 | ':resourcetypes' => '<DAV::collection/><urn:ietf:params:xml:ns:caldav:calendar/>' |
---|
| 120 | ); |
---|
| 121 | $qry->QDo( $sql, $params ); |
---|
| 122 | } |
---|
| 123 | else if ( isset($public) ) { |
---|
| 124 | $collection = $qry->Fetch(); |
---|
| 125 | $sql = 'UPDATE collection SET publicly_readable = :is_public::boolean WHERE collection_id = :collection_id'; |
---|
| 126 | $params = array( ':is_public' => ($public?'t':'f'), ':collection_id' => $collection->collection_id ); |
---|
| 127 | if ( ! $qry->QDo($sql,$params) ) { |
---|
| 128 | rollback_on_error( $caldav_context, $user_no, $path ); |
---|
| 129 | } |
---|
| 130 | } |
---|
| 131 | } |
---|
| 132 | } |
---|
| 133 | |
---|
| 134 | |
---|
| 135 | /** |
---|
| 136 | * Check if this collection should force all events to be PUBLIC. |
---|
| 137 | * @param string $user_no the user that owns the collection |
---|
| 138 | * @param string $dav_name the collection to check |
---|
| 139 | * @return boolean Return true if public events only are allowed. |
---|
| 140 | */ |
---|
| 141 | function public_events_only( $user_no, $dav_name ) { |
---|
| 142 | global $c; |
---|
| 143 | |
---|
| 144 | $sql = 'SELECT public_events_only FROM collection WHERE dav_name = :dav_name'; |
---|
| 145 | |
---|
| 146 | $qry = new AwlQuery($sql, array(':dav_name' => $dav_name) ); |
---|
| 147 | |
---|
| 148 | if( $qry->Exec('PUT',__LINE__,__FILE__) && $qry->rows() == 1 ) { |
---|
| 149 | $collection = $qry->Fetch(); |
---|
| 150 | |
---|
| 151 | if ($collection->public_events_only == 't') { |
---|
| 152 | return true; |
---|
| 153 | } |
---|
| 154 | } |
---|
| 155 | |
---|
| 156 | // Something went wrong, must be false. |
---|
| 157 | return false; |
---|
| 158 | } |
---|
| 159 | |
---|
| 160 | |
---|
| 161 | /** |
---|
| 162 | * Deliver scheduling requests to attendees |
---|
| 163 | * @param iCalComponent $ical the VCALENDAR to deliver |
---|
| 164 | */ |
---|
| 165 | function handle_schedule_request( $ical ) { |
---|
| 166 | global $c, $session, $request; |
---|
| 167 | $resources = $ical->GetComponents('VTIMEZONE',false); |
---|
| 168 | $ic = $resources[0]; |
---|
| 169 | $etag = md5 ( $request->raw_post ); |
---|
| 170 | $reply = new XMLDocument( array("DAV:" => "", "urn:ietf:params:xml:ns:caldav" => "C" ) ); |
---|
| 171 | $responses = array(); |
---|
| 172 | |
---|
| 173 | $attendees = $ic->GetProperties('ATTENDEE'); |
---|
| 174 | $wr_attendees = $ic->GetProperties('X-WR-ATTENDEE'); |
---|
| 175 | if ( count ( $wr_attendees ) > 0 ) { |
---|
| 176 | dbg_error_log( "POST", "Non-compliant iCal request. Using X-WR-ATTENDEE property" ); |
---|
| 177 | foreach( $wr_attendees AS $k => $v ) { |
---|
| 178 | $attendees[] = $v; |
---|
| 179 | } |
---|
| 180 | } |
---|
| 181 | dbg_error_log( "POST", "Attempting to deliver scheduling request for %d attendees", count($attendees) ); |
---|
| 182 | |
---|
| 183 | foreach( $attendees AS $k => $attendee ) { |
---|
| 184 | $attendee_email = preg_replace( '/^mailto:/', '', $attendee->Value() ); |
---|
| 185 | if ( $attendee_email == $request->principal->email ) { |
---|
| 186 | dbg_error_log( "POST", "not delivering to owner" ); |
---|
| 187 | continue; |
---|
| 188 | } |
---|
| 189 | if ( $attendee->GetParameterValue ( 'PARTSTAT' ) != 'NEEDS-ACTION' || preg_match ( '/^[35]\.[3-9]/', $attendee->GetParameterValue ( 'SCHEDULE-STATUS' ) ) ) { |
---|
| 190 | dbg_error_log( "POST", "attendee %s does not need action", $attendee_email ); |
---|
| 191 | continue; |
---|
| 192 | } |
---|
| 193 | |
---|
| 194 | dbg_error_log( "POST", "Delivering to %s", $attendee_email ); |
---|
| 195 | |
---|
| 196 | $attendee_principal = new CalDAVPrincipal ( array ('email'=>$attendee_email, 'options'=> array ( 'allow_by_email' => true ) ) ); |
---|
| 197 | if ( $attendee_principal == false ){ |
---|
| 198 | $attendee->SetParameterValue ('SCHEDULE-STATUS','3.7;Invalid Calendar User'); |
---|
| 199 | continue; |
---|
| 200 | } |
---|
| 201 | $deliver_path = preg_replace ( '/^.*caldav.php/','', $attendee_principal->schedule_inbox_url ); |
---|
| 202 | |
---|
| 203 | $ar = new DAVResource($deliver_path); |
---|
| 204 | $priv = $ar->HavePrivilegeTo('schedule-deliver-invite' ); |
---|
| 205 | if ( ! $ar->HavePrivilegeTo('schedule-deliver-invite' ) ){ |
---|
| 206 | $reply = new XMLDocument( array('DAV:' => '') ); |
---|
| 207 | $privnodes = array( $reply->href(ConstructURL($attendee_principal->schedule_inbox_url)), new XMLElement( 'privilege' ) ); |
---|
| 208 | // RFC3744 specifies that we can only respond with one needed privilege, so we pick the first. |
---|
| 209 | $reply->NSElement( $privnodes[1], 'schedule-deliver-invite' ); |
---|
| 210 | $xml = new XMLElement( 'need-privileges', new XMLElement( 'resource', $privnodes) ); |
---|
| 211 | $xmldoc = $reply->Render('error',$xml); |
---|
| 212 | $request->DoResponse( 403, $xmldoc, 'text/xml; charset="utf-8"'); |
---|
| 213 | } |
---|
| 214 | |
---|
| 215 | |
---|
| 216 | $attendee->SetParameterValue ('SCHEDULE-STATUS','1.2;Scheduling message has been delivered'); |
---|
| 217 | $ncal = new iCalComponent ( ); |
---|
| 218 | $ncal->VCalendar (); |
---|
| 219 | $ncal->AddProperty ( 'METHOD', 'REQUEST' ); |
---|
| 220 | $ncal->AddComponent ( array_merge ( $ical->GetComponents('VEVENT',false) , array ($ic) )); |
---|
| 221 | $content = $ncal->Render(); |
---|
| 222 | $cid = $ar->GetProperty('collection_id'); |
---|
| 223 | dbg_error_log('DELIVER', 'to user: %s, to path: %s, collection: %s, from user: %s, caldata %s', $attendee_principal->user_no, $deliver_path, $cid, $request->user_no, $content ); |
---|
| 224 | write_resource( $attendee_principal->user_no, $deliver_path . $etag . '.ics' , |
---|
| 225 | $content , $ar->GetProperty('collection_id'), $request->user_no, |
---|
| 226 | md5($content), $ncal, $put_action_type='INSERT', $caldav_context=true, $log_action=true, $etag ); |
---|
| 227 | $attendee->SetParameterValue ('SCHEDULE-STATUS','1.2;Scheduling message has been delivered'); |
---|
| 228 | } |
---|
| 229 | // don't write an entry in the out box, ical doesn't delete it or ever read it again |
---|
| 230 | $ncal = new iCalComponent ( ); |
---|
| 231 | $ncal->VCalendar (); |
---|
| 232 | $ncal->AddProperty ( 'METHOD', 'REQUEST' ); |
---|
| 233 | $ncal->AddComponent ( array_merge ( $ical->GetComponents('VEVENT',false) , array ($ic) )); |
---|
| 234 | $content = $ncal->Render(); |
---|
| 235 | $deliver_path = preg_replace ( '/^.*caldav.php/','', $request->principal->schedule_inbox_url ); |
---|
| 236 | $ar = new DAVResource($deliver_path); |
---|
| 237 | write_resource( $request->user_no, $deliver_path . $etag . '.ics' , |
---|
| 238 | $content , $ar->GetProperty('collection_id'), $request->user_no, |
---|
| 239 | md5($content), $ncal, $put_action_type='INSERT', $caldav_context=true, $log_action=true, $etag ); |
---|
| 240 | //$etag = md5($content); |
---|
| 241 | header('ETag: "'. $etag . '"' ); |
---|
| 242 | header('Schedule-Tag: "'.$etag . '"' ); |
---|
| 243 | $request->DoResponse( 201, 'Created' ); |
---|
| 244 | } |
---|
| 245 | |
---|
| 246 | /** |
---|
| 247 | * Deliver scheduling replies to organizer and other attendees |
---|
| 248 | * @param iCalComponent $ical the VCALENDAR to deliver |
---|
| 249 | * @return false on error |
---|
| 250 | */ |
---|
| 251 | function handle_schedule_reply ( $ical ) { |
---|
| 252 | global $c, $session, $request; |
---|
| 253 | $resources = $ical->GetComponents('VTIMEZONE',false); |
---|
| 254 | $ic = $resources[0]; |
---|
| 255 | $etag = md5 ( $request->raw_post ); |
---|
| 256 | $organizer = $ic->GetProperties('ORGANIZER'); |
---|
| 257 | // for now we treat events with out organizers as an error |
---|
| 258 | if ( count ( $organizer ) < 1 ) |
---|
| 259 | return false; |
---|
| 260 | $attendees = array_merge($organizer,$ic->GetProperties('ATTENDEE')); |
---|
| 261 | $wr_attendees = $ic->GetProperties('X-WR-ATTENDEE'); |
---|
| 262 | if ( count ( $wr_attendees ) > 0 ) { |
---|
| 263 | dbg_error_log( "POST", "Non-compliant iCal request. Using X-WR-ATTENDEE property" ); |
---|
| 264 | foreach( $wr_attendees AS $k => $v ) { |
---|
| 265 | $attendees[] = $v; |
---|
| 266 | } |
---|
| 267 | } |
---|
| 268 | dbg_error_log( "POST", "Attempting to deliver scheduling request for %d attendees", count($attendees) ); |
---|
| 269 | |
---|
| 270 | foreach( $attendees AS $k => $attendee ) { |
---|
| 271 | $attendee_email = preg_replace( '/^mailto:/', '', $attendee->Value() ); |
---|
| 272 | dbg_error_log( "POST", "Delivering to %s", $attendee_email ); |
---|
| 273 | $attendee_principal = new CalDAVPrincipal ( array ('email'=>$attendee_email, 'options'=> array ( 'allow_by_email' => true ) ) ); |
---|
| 274 | $deliver_path = preg_replace ( '/^.*caldav.php/','', $attendee_principal->schedule_inbox_url ); |
---|
| 275 | $attendee_email = preg_replace( '/^mailto:/', '', $attendee->Value() ); |
---|
| 276 | if ( $attendee_email == $request->principal->email ) { |
---|
| 277 | dbg_error_log( "POST", "not delivering to owner" ); |
---|
| 278 | continue; |
---|
| 279 | } |
---|
| 280 | $ar = new DAVResource($deliver_path); |
---|
| 281 | if ( ! $ar->HavePrivilegeTo('schedule-deliver-reply' ) ){ |
---|
| 282 | $reply = new XMLDocument( array('DAV:' => '') ); |
---|
| 283 | $privnodes = array( $reply->href(ConstructURL($attendee_principal->schedule_inbox_url)), new XMLElement( 'privilege' ) ); |
---|
| 284 | // RFC3744 specifies that we can only respond with one needed privilege, so we pick the first. |
---|
| 285 | $reply->NSElement( $privnodes[1], 'schedule-deliver-reply' ); |
---|
| 286 | $xml = new XMLElement( 'need-privileges', new XMLElement( 'resource', $privnodes) ); |
---|
| 287 | $xmldoc = $reply->Render('error',$xml); |
---|
| 288 | $request->DoResponse( 403, $xmldoc, 'text/xml; charset="utf-8"' ); |
---|
| 289 | continue; |
---|
| 290 | } |
---|
| 291 | |
---|
| 292 | $ncal = new iCalComponent ( ); |
---|
| 293 | $ncal->VCalendar (); |
---|
| 294 | $ncal->AddProperty ( 'METHOD', 'REPLY' ); |
---|
| 295 | $ncal->AddComponent ( array_merge ( $ical->GetComponents('VEVENT',false) , array ($ic) )); |
---|
| 296 | $content = $ncal->Render(); |
---|
| 297 | write_resource( $attendee_principal->user_no, $deliver_path . $etag . '.ics' , |
---|
| 298 | $content , $ar->GetProperty('collection_id'), $request->user_no, |
---|
| 299 | md5($content), $ncal, $put_action_type='INSERT', $caldav_context=true, $log_action=true, $etag ); |
---|
| 300 | } |
---|
| 301 | $request->DoResponse( 201, 'Created' ); |
---|
| 302 | } |
---|
| 303 | |
---|
| 304 | |
---|
| 305 | |
---|
| 306 | |
---|
| 307 | /** |
---|
| 308 | * Create a scheduling request in the schedule inbox for the |
---|
| 309 | * @param iCalComponent $resource The VEVENT/VTODO/... resource we are scheduling |
---|
| 310 | * @param iCalProp $attendee The attendee we are scheduling |
---|
| 311 | * @return float The result of the scheduling request, per caldav-sched #3.5.4 |
---|
| 312 | */ |
---|
| 313 | function write_scheduling_request( &$resource, $attendee ) { |
---|
| 314 | $response = '5.3;'.translate('No scheduling support for user'); |
---|
| 315 | return '"'.$response.'"'; |
---|
| 316 | } |
---|
| 317 | |
---|
| 318 | /** |
---|
| 319 | * Create scheduling requests in the schedule inbox for the |
---|
| 320 | * @param iCalComponent $resource The VEVENT/VTODO/... resource we are scheduling |
---|
| 321 | */ |
---|
| 322 | function create_scheduling_requests( &$resource ) { |
---|
| 323 | if ( ! is_object($resource) ) { |
---|
| 324 | dbg_error_log( 'PUT', 'create_scheduling_requests called with non-object parameter (%s)', gettype($resource) ); |
---|
| 325 | return; |
---|
| 326 | } |
---|
| 327 | |
---|
| 328 | $attendees = $resource->GetPropertiesByPath('/VCALENDAR/*/ATTENDEE'); |
---|
| 329 | $wr_attendees = $resource->GetPropertiesByPath('/VCALENDAR/*/X-WR-ATTENDEE'); |
---|
| 330 | if ( count ( $wr_attendees ) > 0 ) { |
---|
| 331 | dbg_error_log( 'POST', 'Non-compliant iCal request. Using X-WR-ATTENDEE property' ); |
---|
| 332 | foreach( $wr_attendees AS $k => $v ) { |
---|
| 333 | $attendees[] = $v; |
---|
| 334 | } |
---|
| 335 | } |
---|
| 336 | if ( count($attendees) == 0 ) { |
---|
| 337 | dbg_error_log( 'PUT', 'Event has no attendees - no scheduling required.', count($attendees) ); |
---|
| 338 | return; |
---|
| 339 | } |
---|
| 340 | |
---|
| 341 | dbg_error_log( 'PUT', 'Adding to scheduling inbox %d attendees', count($attendees) ); |
---|
| 342 | foreach( $attendees AS $attendee ) { |
---|
| 343 | $attendee->SetParameterValue( 'SCHEDULE-STATUS', write_scheduling_request( $resource, $attendee->Value() ) ); |
---|
| 344 | } |
---|
| 345 | } |
---|
| 346 | |
---|
| 347 | |
---|
| 348 | /** |
---|
| 349 | * Update scheduling requests in the schedule inbox for the |
---|
| 350 | * @param iCalComponent $resource The VEVENT/VTODO/... resource we are scheduling |
---|
| 351 | */ |
---|
| 352 | function update_scheduling_requests( &$resource ) { |
---|
| 353 | if ( ! is_object($resource) ) { |
---|
| 354 | dbg_error_log( 'PUT', 'update_scheduling_requests called with non-object parameter (%s)', gettype($resource) ); |
---|
| 355 | return; |
---|
| 356 | } |
---|
| 357 | |
---|
| 358 | $attendees = $resource->GetPropertiesByPath('/VCALENDAR/*/ATTENDEE'); |
---|
| 359 | $wr_attendees = $resource->GetPropertiesByPath('/VCALENDAR/*/X-WR-ATTENDEE'); |
---|
| 360 | if ( count ( $wr_attendees ) > 0 ) { |
---|
| 361 | dbg_error_log( 'POST', 'Non-compliant iCal request. Using X-WR-ATTENDEE property' ); |
---|
| 362 | foreach( $wr_attendees AS $k => $v ) { |
---|
| 363 | $attendees[] = $v; |
---|
| 364 | } |
---|
| 365 | } |
---|
| 366 | if ( count($attendees) == 0 ) { |
---|
| 367 | dbg_error_log( 'PUT', 'Event has no attendees - no scheduling required.', count($attendees) ); |
---|
| 368 | return; |
---|
| 369 | } |
---|
| 370 | |
---|
| 371 | dbg_error_log( 'PUT', 'Adding to scheduling inbox %d attendees', count($attendees) ); |
---|
| 372 | foreach( $attendees AS $attendee ) { |
---|
| 373 | $attendee->SetParameterValue( 'SCHEDULE-STATUS', write_scheduling_request( $resource, $attendee->Value() ) ); |
---|
| 374 | } |
---|
| 375 | } |
---|
| 376 | |
---|
| 377 | |
---|
| 378 | /** |
---|
| 379 | * This function will import a whole calendar |
---|
| 380 | * @param string $ics_content the ics file to import |
---|
| 381 | * @param int $user_no the user wich will receive this ics file |
---|
| 382 | * @param string $path the $path where it will be store such as /user_foo/home/ |
---|
| 383 | * @param boolean $caldav_context Whether we are responding via CalDAV or interactively |
---|
| 384 | * |
---|
| 385 | * Any VEVENTs with the same UID will be concatenated together |
---|
| 386 | */ |
---|
| 387 | function import_collection( $ics_content, $user_no, $path, $caldav_context, $appending = false ) { |
---|
| 388 | global $c, $session, $tz_regex; |
---|
| 389 | |
---|
| 390 | if ( ! ini_get('open_basedir') && (isset($c->dbg['ALL']) || isset($c->dbg['put'])) ) { |
---|
| 391 | $fh = fopen('/tmp/PUT-2.txt','w'); |
---|
| 392 | if ( $fh ) { |
---|
| 393 | fwrite($fh,$ics_content); |
---|
| 394 | fclose($fh); |
---|
| 395 | } |
---|
| 396 | } |
---|
| 397 | |
---|
| 398 | $calendar = new iCalComponent($ics_content); |
---|
| 399 | $timezones = $calendar->GetComponents('VTIMEZONE',true); |
---|
| 400 | $components = $calendar->GetComponents('VTIMEZONE',false); |
---|
| 401 | |
---|
| 402 | $displayname = $calendar->GetPValue('X-WR-CALNAME'); |
---|
| 403 | if ( !$appending && isset($displayname) ) { |
---|
| 404 | $sql = 'UPDATE collection SET dav_displayname = :displayname WHERE dav_name = :dav_name'; |
---|
| 405 | $qry = new AwlQuery( $sql, array( ':displayname' => $displayname, ':dav_name' => $path) ); |
---|
| 406 | if ( ! $qry->Exec('PUT',__LINE__,__FILE__) ) rollback_on_error( $caldav_context, $user_no, $path ); |
---|
| 407 | } |
---|
| 408 | |
---|
| 409 | $tz_ids = array(); |
---|
| 410 | foreach( $timezones AS $k => $tz ) { |
---|
| 411 | $tz_ids[$tz->GetPValue('TZID')] = $k; |
---|
| 412 | } |
---|
| 413 | |
---|
| 414 | /** Build an array of resources. Each resource is an array of iCalComponent */ |
---|
| 415 | $resources = array(); |
---|
| 416 | foreach( $components AS $k => $comp ) { |
---|
| 417 | $uid = $comp->GetPValue('UID'); |
---|
| 418 | if ( $uid == null || $uid == '' ) continue; |
---|
| 419 | if ( !isset($resources[$uid]) ) $resources[$uid] = array(); |
---|
| 420 | $resources[$uid][] = $comp; |
---|
| 421 | |
---|
| 422 | /** Ensure we have the timezone component for this in our array as well */ |
---|
| 423 | $tzid = $comp->GetPParamValue('DTSTART', 'TZID'); |
---|
| 424 | if ( !isset($tzid) || $tzid == '' ) $tzid = $comp->GetPParamValue('DUE','TZID'); |
---|
| 425 | if ( !isset($resources[$uid][$tzid]) && isset($tz_ids[$tzid]) ) { |
---|
| 426 | $resources[$uid][$tzid] = $timezones[$tz_ids[$tzid]]; |
---|
| 427 | } |
---|
| 428 | } |
---|
| 429 | |
---|
| 430 | |
---|
| 431 | $sql = 'SELECT * FROM collection WHERE dav_name = :dav_name'; |
---|
| 432 | $qry = new AwlQuery( $sql, array( ':dav_name' => $path) ); |
---|
| 433 | if ( ! $qry->Exec('PUT',__LINE__,__FILE__) ) rollback_on_error( $caldav_context, $user_no, $path ); |
---|
| 434 | if ( ! $qry->rows() == 1 ) { |
---|
| 435 | dbg_error_log( 'ERROR', ' PUT: Collection does not exist at "%s" for user %d', $path, $user_no ); |
---|
| 436 | rollback_on_error( $caldav_context, $user_no, $path ); |
---|
| 437 | } |
---|
| 438 | $collection = $qry->Fetch(); |
---|
| 439 | |
---|
| 440 | if ( !(isset($c->skip_bad_event_on_import) && $c->skip_bad_event_on_import) ) $qry->Begin(); |
---|
| 441 | $base_params = array( ':collection_id' => $collection->collection_id ); |
---|
| 442 | if ( !$appending ) { |
---|
| 443 | if ( !$qry->QDo('DELETE FROM calendar_item WHERE collection_id = :collection_id', $base_params) |
---|
| 444 | || !$qry->QDo('DELETE FROM caldav_data WHERE collection_id = :collection_id', $base_params) ) |
---|
| 445 | rollback_on_error( $caldav_context, $user_no, $collection->collection_id ); |
---|
| 446 | } |
---|
| 447 | |
---|
| 448 | $dav_data_insert = <<<EOSQL |
---|
| 449 | INSERT INTO caldav_data ( user_no, dav_name, dav_etag, caldav_data, caldav_type, logged_user, created, modified, collection_id ) |
---|
| 450 | VALUES( :user_no, :dav_name, :etag, :dav_data, :caldav_type, :session_user, current_timestamp, current_timestamp, :collection_id ) |
---|
| 451 | EOSQL; |
---|
| 452 | |
---|
| 453 | $calitem_insert = <<<EOSQL |
---|
| 454 | INSERT INTO calendar_item (user_no, dav_name, dav_id, dav_etag, uid, dtstamp, dtstart, dtend, summary, location, class, transp, |
---|
| 455 | description, rrule, tz_id, last_modified, url, priority, created, due, percent_complete, status, collection_id ) |
---|
| 456 | VALUES ( :user_no, :dav_name, currval('dav_id_seq'), :etag, :uid, :dtstamp, :dtstart, ##dtend##, :summary, :location, :class, :transp, |
---|
| 457 | :description, :rrule, :tzid, :modified, :url, :priority, :created, :due, :percent_complete, :status, :collection_id) |
---|
| 458 | EOSQL; |
---|
| 459 | |
---|
| 460 | $last_tz_locn = ''; |
---|
| 461 | foreach( $resources AS $uid => $resource ) { |
---|
| 462 | if ( isset($c->skip_bad_event_on_import) && $c->skip_bad_event_on_import ) $qry->Begin(); |
---|
| 463 | |
---|
| 464 | /** Construct the VCALENDAR data */ |
---|
| 465 | $vcal = new iCalComponent(); |
---|
| 466 | $vcal->VCalendar(); |
---|
| 467 | $vcal->SetComponents($resource); |
---|
| 468 | create_scheduling_requests($vcal); |
---|
| 469 | $icalendar = $vcal->Render(); |
---|
| 470 | |
---|
| 471 | /** As ever, we mostly deal with the first resource component */ |
---|
| 472 | $first = $resource[0]; |
---|
| 473 | |
---|
| 474 | $dav_data_params = $base_params; |
---|
| 475 | $dav_data_params[':user_no'] = $user_no; |
---|
| 476 | $dav_data_params[':dav_name'] = sprintf( '%s%s.ics', $path, $uid ); |
---|
| 477 | $dav_data_params[':etag'] = md5($icalendar); |
---|
| 478 | $calitem_params = $dav_data_params; |
---|
| 479 | $dav_data_params[':dav_data'] = $icalendar; |
---|
| 480 | $dav_data_params[':caldav_type'] = $first->GetType(); |
---|
| 481 | $dav_data_params[':session_user'] = $session->user_no; |
---|
| 482 | if ( !$qry->QDo($dav_data_insert,$dav_data_params) ) rollback_on_error( $caldav_context, $user_no, $path ); |
---|
| 483 | |
---|
| 484 | $qry->QDo('SELECT dav_id FROM caldav_data WHERE dav_name = :dav_name ', array(':dav_name' => $dav_data_params[':dav_name'])); |
---|
| 485 | if ( $qry->rows() == 1 && $row = $qry->Fetch() ) { |
---|
| 486 | $dav_id = $row->dav_id; |
---|
| 487 | } |
---|
| 488 | |
---|
| 489 | $dtstart = $first->GetPValue('DTSTART'); |
---|
| 490 | $calitem_params[':dtstart'] = $dtstart; |
---|
| 491 | if ( (!isset($dtstart) || $dtstart == '') && $first->GetPValue('DUE') != '' ) { |
---|
| 492 | $dtstart = $first->GetPValue('DUE'); |
---|
| 493 | } |
---|
| 494 | |
---|
| 495 | $dtend = $first->GetPValue('DTEND'); |
---|
| 496 | if ( isset($dtend) && $dtend != '' ) { |
---|
| 497 | dbg_error_log( 'PUT', ' DTEND: "%s", DTSTART: "%s", DURATION: "%s"', $dtend, $dtstart, $first->GetPValue('DURATION') ); |
---|
| 498 | $calitem_params[':dtend'] = $dtend; |
---|
| 499 | $dtend = ':dtend'; |
---|
| 500 | } |
---|
| 501 | else { |
---|
| 502 | $dtend = 'NULL'; |
---|
| 503 | if ( $first->GetPValue('DURATION') != '' AND $dtstart != '' ) { |
---|
| 504 | $duration = preg_replace( '#[PT]#', ' ', $first->GetPValue('DURATION') ); |
---|
| 505 | $dtend = '(:dtstart::timestamp with time zone + :duration::interval)'; |
---|
| 506 | $calitem_params[':duration'] = $duration; |
---|
| 507 | } |
---|
| 508 | elseif ( $first->GetType() == 'VEVENT' ) { |
---|
| 509 | /** |
---|
| 510 | * From RFC2445 4.6.1: |
---|
| 511 | * For cases where a "VEVENT" calendar component specifies a "DTSTART" |
---|
| 512 | * property with a DATE data type but no "DTEND" property, the events |
---|
| 513 | * non-inclusive end is the end of the calendar date specified by the |
---|
| 514 | * "DTSTART" property. For cases where a "VEVENT" calendar component specifies |
---|
| 515 | * a "DTSTART" property with a DATE-TIME data type but no "DTEND" property, |
---|
| 516 | * the event ends on the same calendar date and time of day specified by the |
---|
| 517 | * "DTSTART" property. |
---|
| 518 | * |
---|
| 519 | * So we're looking for 'VALUE=DATE', to identify the duration, effectively. |
---|
| 520 | * |
---|
| 521 | */ |
---|
| 522 | $value_type = $first->GetPParamValue('DTSTART','VALUE'); |
---|
| 523 | dbg_error_log('PUT','DTSTART without DTEND. DTSTART value type is %s', $value_type ); |
---|
| 524 | if ( isset($value_type) && $value_type == 'DATE' ) |
---|
| 525 | $dtend = '(:dtstart::timestamp with time zone::date + \'1 day\'::interval)'; |
---|
| 526 | else |
---|
| 527 | $dtend = ':dtstart'; |
---|
| 528 | } |
---|
| 529 | } |
---|
| 530 | |
---|
| 531 | $last_modified = $first->GetPValue('LAST-MODIFIED'); |
---|
| 532 | if ( !isset($last_modified) || $last_modified == '' ) $last_modified = gmdate( 'Ymd\THis\Z' ); |
---|
| 533 | $calitem_params[':modified'] = $last_modified; |
---|
| 534 | |
---|
| 535 | $dtstamp = $first->GetPValue('DTSTAMP'); |
---|
| 536 | if ( !isset($dtstamp) || $dtstamp == '' ) $dtstamp = $last_modified; |
---|
| 537 | $calitem_params[':dtstamp'] = $dtstamp; |
---|
| 538 | |
---|
| 539 | /** RFC2445, 4.8.1.3: Default is PUBLIC, or also if overridden by the collection settings */ |
---|
| 540 | $class = ($collection->public_events_only == 't' ? 'PUBLIC' : $first->GetPValue('CLASS') ); |
---|
| 541 | if ( !isset($class) || $class == '' ) $class = 'PUBLIC'; |
---|
| 542 | $calitem_params[':class'] = $class; |
---|
| 543 | |
---|
| 544 | |
---|
| 545 | /** Calculate what timezone to set, first, if possible */ |
---|
| 546 | $tzid = $first->GetPParamValue('DTSTART','TZID'); |
---|
| 547 | if ( !isset($tzid) || $tzid == '' ) $tzid = $first->GetPParamValue('DUE','TZID'); |
---|
| 548 | if ( isset($tzid) && $tzid != '' ) { |
---|
| 549 | if ( isset($resource[$tzid]) ) { |
---|
| 550 | $tz = $resource[$tzid]; |
---|
| 551 | $tz_locn = $tz->GetPValue('X-LIC-LOCATION'); |
---|
| 552 | } |
---|
| 553 | else { |
---|
| 554 | unset($tz); |
---|
| 555 | unset($tz_locn); |
---|
| 556 | } |
---|
| 557 | if ( ! isset($tz_locn) || ! preg_match( $tz_regex, $tz_locn ) ) { |
---|
| 558 | if ( preg_match( '#([^/]+/[^/]+)$#', $tzid, $matches ) ) { |
---|
| 559 | $tz_locn = $matches[1]; |
---|
| 560 | } |
---|
| 561 | } |
---|
| 562 | dbg_error_log( 'PUT', ' Using TZID[%s] and location of [%s]', $tzid, (isset($tz_locn) ? $tz_locn : '') ); |
---|
| 563 | if ( isset($tz_locn) && ($tz_locn != $last_tz_locn) && preg_match( $tz_regex, $tz_locn ) ) { |
---|
| 564 | dbg_error_log( 'PUT', ' Setting timezone to %s', $tz_locn ); |
---|
| 565 | if ( $tz_locn != '' ) { |
---|
| 566 | $qry->QDo('SET TIMEZONE TO \''.$tz_locn."'" ); |
---|
| 567 | } |
---|
| 568 | $last_tz_locn = $tz_locn; |
---|
| 569 | } |
---|
| 570 | $params = array( ':tzid' => $tzid); |
---|
| 571 | $qry = new AwlQuery('SELECT tz_locn FROM time_zone WHERE tz_id = :tzid', $params ); |
---|
| 572 | if ( $qry->Exec('PUT',__LINE__,__FILE__) && $qry->rows() == 0 ) { |
---|
| 573 | $params[':tzlocn'] = $tz_locn; |
---|
| 574 | $params[':tzspec'] = (isset($tz) ? $tz->Render() : null ); |
---|
| 575 | $qry->QDo('INSERT INTO time_zone (tz_id, tz_locn, tz_spec) VALUES(:tzid,:tzlocn,:tzspec)', $params ); |
---|
| 576 | } |
---|
| 577 | if ( !isset($tz_locn) || $tz_locn == '' ) $tz_locn = $tzid; |
---|
| 578 | } |
---|
| 579 | else { |
---|
| 580 | $tzid = null; |
---|
| 581 | } |
---|
| 582 | |
---|
| 583 | $sql = str_replace( '##dtend##', $dtend, $calitem_insert ); |
---|
| 584 | $calitem_params[':tzid'] = $tzid; |
---|
| 585 | $calitem_params[':uid'] = $first->GetPValue('UID'); |
---|
| 586 | $calitem_params[':summary'] = $first->GetPValue('SUMMARY'); |
---|
| 587 | $calitem_params[':location'] = $first->GetPValue('LOCATION'); |
---|
| 588 | $calitem_params[':transp'] = $first->GetPValue('TRANSP'); |
---|
| 589 | $calitem_params[':description'] = $first->GetPValue('DESCRIPTION'); |
---|
| 590 | $calitem_params[':rrule'] = $first->GetPValue('RRULE'); |
---|
| 591 | $calitem_params[':url'] = $first->GetPValue('URL'); |
---|
| 592 | $calitem_params[':priority'] = $first->GetPValue('PRIORITY'); |
---|
| 593 | $calitem_params[':due'] = $first->GetPValue('DUE'); |
---|
| 594 | $calitem_params[':percent_complete'] = $first->GetPValue('PERCENT-COMPLETE'); |
---|
| 595 | $calitem_params[':status'] = $first->GetPValue('STATUS'); |
---|
| 596 | |
---|
| 597 | $created = $first->GetPValue('CREATED'); |
---|
| 598 | if ( $created == '00001231T000000Z' ) $created = '20001231T000000Z'; |
---|
| 599 | $calitem_params[':created'] = $created; |
---|
| 600 | |
---|
| 601 | if ( !$qry->QDo($sql,$calitem_params) ) rollback_on_error( $caldav_context, $user_no, $path); |
---|
| 602 | |
---|
| 603 | write_alarms($dav_id, $first); |
---|
| 604 | write_attendees($dav_id, $first); |
---|
| 605 | |
---|
| 606 | create_scheduling_requests( $vcal ); |
---|
| 607 | if ( isset($c->skip_bad_event_on_import) && $c->skip_bad_event_on_import ) $qry->Commit(); |
---|
| 608 | } |
---|
| 609 | |
---|
| 610 | if ( !(isset($c->skip_bad_event_on_import) && $c->skip_bad_event_on_import) ) { |
---|
| 611 | if ( ! $qry->Commit() ) rollback_on_error( $caldav_context, $user_no, $path); |
---|
| 612 | } |
---|
| 613 | } |
---|
| 614 | |
---|
| 615 | |
---|
| 616 | /** |
---|
| 617 | * Given a dav_id and an original iCalComponent, pull out each of the VALARMs |
---|
| 618 | * and write the values into the calendar_alarm table. |
---|
| 619 | * |
---|
| 620 | * @param int $dav_id The dav_id of the caldav_data we're processing |
---|
| 621 | * @param iCalComponent The VEVENT or VTODO containing the VALARM |
---|
| 622 | * @return null |
---|
| 623 | */ |
---|
| 624 | function write_alarms( $dav_id, $ical ) { |
---|
| 625 | $qry = new AwlQuery('DELETE FROM calendar_alarm WHERE dav_id = '.$dav_id ); |
---|
| 626 | $qry->Exec('PUT',__LINE__,__FILE__); |
---|
| 627 | |
---|
| 628 | $alarms = $ical->GetComponents('VALARM'); |
---|
| 629 | if ( count($alarms) < 1 ) return; |
---|
| 630 | |
---|
| 631 | $qry->SetSql('INSERT INTO calendar_alarm ( dav_id, action, trigger, summary, description, component, next_trigger ) |
---|
| 632 | VALUES( '.$dav_id.', :action, :trigger, :summary, :description, :component, |
---|
| 633 | :related::timestamp with time zone + :related_trigger::interval )' ); |
---|
| 634 | $qry->Prepare(); |
---|
| 635 | foreach( $alarms AS $v ) { |
---|
| 636 | $trigger = array_merge($v->GetProperties('TRIGGER')); |
---|
| 637 | $trigger = $trigger[0]; |
---|
| 638 | $related = null; |
---|
| 639 | $related_trigger = '0M'; |
---|
| 640 | $trigger_type = $trigger->GetParameterValue('VALUE'); |
---|
| 641 | if ( !isset($trigger_type) || $trigger_type == 'DURATION' ) { |
---|
| 642 | switch ( $trigger->GetParameterValue('RELATED') ) { |
---|
| 643 | case 'DTEND': $related = $ical->GetPValue('DTEND'); break; |
---|
| 644 | case 'DUE': $related = $ical->GetPValue('DUE'); break; |
---|
| 645 | default: $related = $ical->GetPValue('DTSTART'); |
---|
| 646 | } |
---|
| 647 | $duration = $trigger->Value(); |
---|
| 648 | $minus = (substr($duration,0,1) == '-'); |
---|
| 649 | $related_trigger = trim(preg_replace( '#[PT-]#', ' ', $duration )); |
---|
| 650 | if ( $minus ) { |
---|
| 651 | $related_trigger = preg_replace( '{(\d+[WDHMS])}', '-$1 ', $related_trigger ); |
---|
| 652 | } |
---|
| 653 | } |
---|
| 654 | $qry->Bind(':action', $v->GetPValue('ACTION')); |
---|
| 655 | $qry->Bind(':trigger', $trigger->Render()); |
---|
| 656 | $qry->Bind(':summary', $v->GetPValue('SUMMARY')); |
---|
| 657 | $qry->Bind(':description', $v->GetPValue('DESCRIPTION')); |
---|
| 658 | $qry->Bind(':component', $v->Render()); |
---|
| 659 | $qry->Bind(':related', $related ); |
---|
| 660 | $qry->Bind(':related_trigger', $related_trigger ); |
---|
| 661 | $qry->Exec('PUT',__LINE__,__FILE__); |
---|
| 662 | } |
---|
| 663 | } |
---|
| 664 | |
---|
| 665 | |
---|
| 666 | /** |
---|
| 667 | * Parse out the attendee property and write a row to the |
---|
| 668 | * calendar_attendee table for each one. |
---|
| 669 | * @param int $dav_id The dav_id of the caldav_data we're processing |
---|
| 670 | * @param iCalComponent The VEVENT or VTODO containing the ATTENDEEs |
---|
| 671 | * @return null |
---|
| 672 | */ |
---|
| 673 | function write_attendees( $dav_id, $ical ) { |
---|
| 674 | $qry = new AwlQuery('DELETE FROM calendar_attendee WHERE dav_id = '.$dav_id ); |
---|
| 675 | $qry->Exec('PUT',__LINE__,__FILE__); |
---|
| 676 | |
---|
| 677 | $attendees = $ical->GetProperties('ATTENDEE'); |
---|
| 678 | if ( count($attendees) < 1 ) return; |
---|
| 679 | |
---|
| 680 | $qry->SetSql('INSERT INTO calendar_attendee ( dav_id, status, partstat, cn, attendee, role, rsvp, property ) |
---|
| 681 | VALUES( '.$dav_id.', :status, :partstat, :cn, :attendee, :role, :rsvp, :property )' ); |
---|
| 682 | $qry->Prepare(); |
---|
| 683 | $processed = array(); |
---|
| 684 | foreach( $attendees AS $v ) { |
---|
| 685 | $attendee = $v->Value(); |
---|
| 686 | if ( isset($processed[$attendee]) ) { |
---|
| 687 | dbg_error_log( 'LOG', 'Duplicate attendee "%s" in resource "%d"', $attendee, $dav_id ); |
---|
| 688 | dbg_error_log( 'LOG', 'Original: "%s"', $processed[$attendee] ); |
---|
| 689 | dbg_error_log( 'LOG', 'Duplicate: "%s"', $v->Render() ); |
---|
| 690 | continue; /** @TODO: work out why we get duplicate ATTENDEE on one VEVENT */ |
---|
| 691 | } |
---|
| 692 | $qry->Bind(':attendee', $attendee ); |
---|
| 693 | $qry->Bind(':status', $v->GetParameterValue('STATUS') ); |
---|
| 694 | $qry->Bind(':partstat', $v->GetParameterValue('PARTSTAT') ); |
---|
| 695 | $qry->Bind(':cn', $v->GetParameterValue('CN') ); |
---|
| 696 | $qry->Bind(':role', $v->GetParameterValue('ROLE') ); |
---|
| 697 | $qry->Bind(':rsvp', $v->GetParameterValue('RSVP') ); |
---|
| 698 | $qry->Bind(':property', $v->Render() ); |
---|
| 699 | $qry->Exec('PUT',__LINE__,__FILE__); |
---|
| 700 | $processed[$attendee] = $v->Render(); |
---|
| 701 | } |
---|
| 702 | } |
---|
| 703 | |
---|
| 704 | |
---|
| 705 | /** |
---|
| 706 | * Actually write the resource to the database. All checking of whether this is reasonable |
---|
| 707 | * should be done before this is called. |
---|
| 708 | * @param int $user_no The user_no owning this resource on the server |
---|
| 709 | * @param string $path The path to the resource being written |
---|
| 710 | * @param string $caldav_data The actual resource to be written |
---|
| 711 | * @param int $collection_id The ID of the collection containing the resource being written |
---|
| 712 | * @param int $author The user_no who wants to put this resource on the server |
---|
| 713 | * @param string $etag An etag unique for this event |
---|
| 714 | * @param object $ic The parsed iCalendar object |
---|
| 715 | * @param string $put_action_type INSERT or UPDATE depending on what we are to do |
---|
| 716 | * @param boolean $caldav_context True, if we are responding via CalDAV, false for other ways of calling this |
---|
| 717 | * @param string Either 'INSERT' or 'UPDATE': the type of action we are doing |
---|
| 718 | * @param boolean $log_action Whether to log the fact that we are writing this into an action log (if configured) |
---|
| 719 | * @param string $weak_etag An etag that is NOT modified on ATTENDEE changes for this event |
---|
| 720 | * @return boolean True for success, false for failure. |
---|
| 721 | */ |
---|
| 722 | function write_resource( $user_no, $path, $caldav_data, $collection_id, $author, $etag, $ic, $put_action_type, $caldav_context, $log_action=true, $weak_etag=null ) { |
---|
| 723 | global $tz_regex; |
---|
| 724 | |
---|
| 725 | $resources = $ic->GetComponents('VTIMEZONE',false); // Not matching VTIMEZONE |
---|
| 726 | if ( !isset($resources[0]) ) { |
---|
| 727 | $resource_type = 'Unknown'; |
---|
| 728 | /** @TODO: Handle writing non-calendar resources, like address book entries or random file data */ |
---|
| 729 | rollback_on_error( $caldav_context, $user_no, $path, translate('No calendar content'), 412 ); |
---|
| 730 | return false; |
---|
| 731 | } |
---|
| 732 | else { |
---|
| 733 | if( count($resources) == 2) |
---|
| 734 | $first = $resources[1]; |
---|
| 735 | else |
---|
| 736 | $first = $resources[0]; |
---|
| 737 | $resource_type = $first->GetType(); |
---|
| 738 | } |
---|
| 739 | |
---|
| 740 | unset($put_action_type); |
---|
| 741 | $nome = substr($user_no, 0, 9); |
---|
| 742 | $UID = $first->GetPValue('UID'); |
---|
| 743 | $CALID = strtok($UID,"@"); |
---|
| 744 | $proprietario = strtok("@"); |
---|
| 745 | $qry = new AwlQuery("SELECT * FROM phpgw_cal_user WHERE cal_login=:nome AND cal_id=:CALID AND cal_status='A' AND cal_type='u' ", array(':nome' => $nome , ':CALID' => $CALID)); |
---|
| 746 | $qry->Exec("PUT"); |
---|
| 747 | if ($qry->rows() < 1) { |
---|
| 748 | $qrycompa = new AwlQuery("SELECT * FROM phpgw_cal WHERE cal_id=:CALID AND owner=:nome ", array(':CALID' => $CALID, ':nome' => $nome)); |
---|
| 749 | $qrycompa->Exec("PUT"); |
---|
| 750 | if ($qrycompa->rows() < 1) { |
---|
| 751 | $put_action_type = 'INSERT'; |
---|
| 752 | } else { |
---|
| 753 | //$put_action_type = 'UPDATE'; |
---|
| 754 | $put_action_type = 'NDA'; |
---|
| 755 | } |
---|
| 756 | } |
---|
| 757 | elseif ($qry->rows() == 1) { |
---|
| 758 | $put_action_type = 'UPDATE'; |
---|
| 759 | } |
---|
| 760 | |
---|
| 761 | $second = $first->GetComponents('VALARM'); |
---|
| 762 | if(count($second) >= 1) |
---|
| 763 | { |
---|
| 764 | $alarme_time = $second[0]->GetPValue('TRIGGER'); |
---|
| 765 | } |
---|
| 766 | $alarme_descarta = $first->GetPValue('X-MOZ-LASTACK'); |
---|
| 767 | $start = $first->GetPValue('DTSTART'); |
---|
| 768 | $dateTime = date_create($start); |
---|
| 769 | $HJ = date("Y-m-d 00:00:00"); |
---|
| 770 | $hoje = date_create($HJ); |
---|
| 771 | $hj_seg = $hoje->format("U"); |
---|
| 772 | //date_format( $dateTime, 2000, 12, 12); |
---|
| 773 | $DT_START = $dateTime->format("U"); |
---|
| 774 | $hora = $dateTime->format("G"); |
---|
| 775 | $horas_seg = $hora * 60 * 60; |
---|
| 776 | $minuto = $dateTime->format("i"); |
---|
| 777 | $min_seg = $minuto * 60; |
---|
| 778 | $total_seg = $horas_seg + $min_seg; |
---|
| 779 | $alarme_data = $total_seg + $hj_seg; |
---|
| 780 | |
---|
| 781 | $end = $first->GetPValue('DTEND'); |
---|
| 782 | $dateTime_end = date_create($end); |
---|
| 783 | ///date_format( $dateTime, 2000, 12, 12); |
---|
| 784 | $DT_END = $dateTime_end->format("U"); |
---|
| 785 | $execao = $first->GetProperties('EXDATE'); |
---|
| 786 | $modify = $first->GetPValue('LAST-MODIFIED'); |
---|
| 787 | $dateTime_mod = date_create($modify); |
---|
| 788 | //date_format( $dateTime, 2000, 12, 12); |
---|
| 789 | $MOD = $dateTime_mod->format("U"); |
---|
| 790 | $seg = $alarme_data * 1000000; |
---|
| 791 | $snooze = "X-MOZ-SNOOZE-TIME"; |
---|
| 792 | //if(count($second) >= 1){ |
---|
| 793 | $adia_alarme = $first->GetPValue("$snooze"); |
---|
| 794 | //dbg_error_log("PUT", "ADIA alarme: '%s' ", $adia_alarme); |
---|
| 795 | //} |
---|
| 796 | $prioridade = $first->GetPValue('PRIORITY'); |
---|
| 797 | if ($prioridade == "") { |
---|
| 798 | $prioridade = 1; |
---|
| 799 | } |
---|
| 800 | $RECUR = $first->GetPValue('RRULE'); |
---|
| 801 | |
---|
| 802 | $categoria_utf8 = $first->GetPValue('CATEGORIES'); |
---|
| 803 | $categoria = utf8_decode($categoria_utf8); |
---|
| 804 | if ($RECUR == null) { |
---|
| 805 | $tipo = E; |
---|
| 806 | } else { |
---|
| 807 | $tipo = M; |
---|
| 808 | } |
---|
| 809 | |
---|
| 810 | // EXDATE:20081126T190000Z |
---|
| 811 | //Adicionado por Umberto |
---|
| 812 | //Permite exclusão de varias recorrencias. |
---|
| 813 | if ( is_array($execao)) { |
---|
| 814 | foreach( $execao AS $k => $v ) { |
---|
| 815 | //$dateTime = date_create($deletarecorrencia); |
---|
| 816 | //$EXEC = $dateTime->format("U"); |
---|
| 817 | $EXEC = dataTzParaSegundos($v->value()); |
---|
| 818 | $TOTAL = "$TOTAL,$EXEC"; |
---|
| 819 | } |
---|
| 820 | $EXEC = trim($TOTAL,","); |
---|
| 821 | |
---|
| 822 | } else { |
---|
| 823 | $EXEC = ""; |
---|
| 824 | } |
---|
| 825 | //Fim da edição por Umberto |
---|
| 826 | $titulo_utf8 = $first->GetPValue('SUMMARY'); |
---|
| 827 | $titulo = utf8_decode($titulo_utf8); |
---|
| 828 | $descricao_utf8 = preg_replace('/\n/', "\r\n", $first->GetPValue('DESCRIPTION')); |
---|
| 829 | $descricao = utf8_decode($descricao_utf8); |
---|
| 830 | $recur_id = $first->GetPValue('RECURRENCE-ID'); |
---|
| 831 | $cidade_utf8 = $first->GetPValue('LOCATION'); |
---|
| 832 | $cidade = utf8_decode($cidade_utf8); |
---|
| 833 | $iporigem = getenv("REMOTE_ADDR"); |
---|
| 834 | $class = $first->GetPValue('CLASS'); |
---|
| 835 | if ($class == 'PRIVATE') { |
---|
| 836 | $public = 0; |
---|
| 837 | } else { |
---|
| 838 | $public = 1; |
---|
| 839 | } |
---|
| 840 | //############## Categoria ################## |
---|
| 841 | if ( $categoria != ""){ |
---|
| 842 | $x= "select * from phpgw_categories WHERE cat_name = :categoria"; |
---|
| 843 | $phpgw_query = new AwlQuery($x,array(':categoria' => $categoria)); |
---|
| 844 | $phpgw_query->Exec(); |
---|
| 845 | if ( $phpgw_query->rows() == 0 ) { |
---|
| 846 | $qry = new AwlQuery("INSERT INTO phpgw_categories (cat_id,cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data,last_mod) VALUES ( default,default,default,default,:nome,'private','calendar',:categoria,'','N;',:mod)", array(':nome' => $nome, ':categoria' => $categoria, ':mod' => $MOD)); |
---|
| 847 | if (!$qry->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 848 | $x= "select * from phpgw_categories WHERE cat_name = '$categoria'"; |
---|
| 849 | $phpgw_query = new AwlQuery($x,array(':categoria' => $categoria)); |
---|
| 850 | $phpgw_query->Exec(); |
---|
| 851 | $categg = $phpgw_query->Fetch(); |
---|
| 852 | $category_id = $categg->cat_id; |
---|
| 853 | } |
---|
| 854 | else |
---|
| 855 | { while ($categgg = $phpgw_query->Fetch()) |
---|
| 856 | { |
---|
| 857 | if ( $categgg->cat_access == 'public' || $categgg->cat_owner == "$nome") |
---|
| 858 | { |
---|
| 859 | $category_id = $categgg->cat_id; |
---|
| 860 | } |
---|
| 861 | else |
---|
| 862 | { $category_id =""; |
---|
| 863 | } |
---|
| 864 | } |
---|
| 865 | } |
---|
| 866 | } |
---|
| 867 | else |
---|
| 868 | { |
---|
| 869 | $category_id =""; |
---|
| 870 | } |
---|
| 871 | |
---|
| 872 | //################# ALARME ################## |
---|
| 873 | |
---|
| 874 | $tipo_data = substr($alarme_time, -1); |
---|
| 875 | switch ($tipo_data) { |
---|
| 876 | case "M": |
---|
| 877 | $valor = 60; |
---|
| 878 | $tamanho = strlen($alarme_time); |
---|
| 879 | if ($tamanho == 6) { |
---|
| 880 | $minutos = substr($alarme_time, 3, 5); |
---|
| 881 | $reducao = $minutos * $valor; |
---|
| 882 | } else { |
---|
| 883 | $minutos = substr($alarme_time, 3, 4); |
---|
| 884 | $reducao = $minutos * $valor; |
---|
| 885 | } |
---|
| 886 | break; |
---|
| 887 | case "H": |
---|
| 888 | $valor = 60; |
---|
| 889 | $tamanho = strlen($alarme_time); |
---|
| 890 | if ($tamanho == 6) { |
---|
| 891 | $horas = substr($alarme_time, 3, 5); |
---|
| 892 | $reducao = $horas * $valor * $valor; |
---|
| 893 | } else { |
---|
| 894 | $horas = substr($alarme_time, 3, 4); |
---|
| 895 | $reducao = $horas * $valor * $valor; |
---|
| 896 | } |
---|
| 897 | break; |
---|
| 898 | case "D": |
---|
| 899 | $valor = 60; |
---|
| 900 | $num_horas = 24; |
---|
| 901 | $tamanho = strlen($alarme_time); |
---|
| 902 | if ($tamanho == 5) { |
---|
| 903 | $dias = substr($alarme_time, 2, 4); |
---|
| 904 | $reducao = $dias * $valor * $valor * $num_horas; |
---|
| 905 | } else { |
---|
| 906 | $dias = substr($alarme_time, 2, 3); |
---|
| 907 | $reducao = $dias * $valor * $valor * $num_horas; |
---|
| 908 | } |
---|
| 909 | break; |
---|
| 910 | case "W": |
---|
| 911 | $valor = 60; |
---|
| 912 | $num_horas = 24; |
---|
| 913 | $num_dias = 7; |
---|
| 914 | $tamanho = strlen($alarme_time); |
---|
| 915 | if ($tamanho == 5) { |
---|
| 916 | $semanas = substr($alarme_time, 2, 4); |
---|
| 917 | $reducao = $semanas * $valor * $valor * $num_horas * $num_dias; |
---|
| 918 | } else { |
---|
| 919 | $semanas = substr($alarme_time, 2, 3); |
---|
| 920 | $reducao = $semanas * $valor * $valor * $num_horas * $num_dias; |
---|
| 921 | } |
---|
| 922 | case "S": |
---|
| 923 | continue; |
---|
| 924 | } |
---|
| 925 | |
---|
| 926 | $alarme = $DT_START - $reducao; |
---|
| 927 | // ########### participantes ###################### |
---|
| 928 | $participantes = $first->GetProperties('ATTENDEE'); |
---|
| 929 | //$test = $ic->component->FirstNonTimezone(); |
---|
| 930 | //$propriedades = $test->GetProperties('PARTSTAT'); |
---|
| 931 | //foreach ($propriedades as $k => $c){ |
---|
| 932 | //} |
---|
| 933 | dbg_log_array( "PUTTTTTT", 'PARTICIPANTES ', $participantes, true ); |
---|
| 934 | $mails = ""; |
---|
| 935 | $part = array(); |
---|
| 936 | $estado = array(); |
---|
| 937 | if (is_array($participantes)) { |
---|
| 938 | $email=$nome; |
---|
| 939 | foreach($participantes AS $k => $v) { |
---|
| 940 | $user = $v->content; |
---|
| 941 | list($aviso, $mail) = split(":", $user, 2); |
---|
| 942 | $filtro = "mail=$mail"; |
---|
| 943 | $email=$email.",".$mail; |
---|
| 944 | $atributos = array("uidNumber"); |
---|
| 945 | //$atrr = new ldapDrivers($c->authenticate_hook['config']); |
---|
| 946 | if (strlen($filtro) > 5){ |
---|
| 947 | $usuario = ldapDrivers::requestAtributo($filtro, $atributos); |
---|
| 948 | if ($usuario != false) { |
---|
| 949 | $part[$k] = $usuario['uidNumber']; |
---|
| 950 | $stat = $v->GetParameterValue('PARTSTAT'); |
---|
| 951 | switch ($stat){ |
---|
| 952 | case "NEEDS-ACTION": $estado[$k] = 'U'; |
---|
| 953 | break; |
---|
| 954 | case "ACCEPTED": $estado[$k] = 'A'; |
---|
| 955 | break; |
---|
| 956 | case "DECLINED": $estado[$k] = 'R'; |
---|
| 957 | break; |
---|
| 958 | case "TENTATIVE": $estado[$k] = 'T'; |
---|
| 959 | break; |
---|
| 960 | } |
---|
| 961 | dbg_error_log("PUT", "usuario participante: '%s' status '%s' e token '%d' ", $part[$k],$stat,$k); |
---|
| 962 | } else { |
---|
| 963 | $mails = $mails . "$mail,"; |
---|
| 964 | } |
---|
| 965 | } |
---|
| 966 | } |
---|
| 967 | } elseif (strlen($participantes) > 1) { |
---|
| 968 | $part = array(); |
---|
| 969 | list($aviso, $mail) = split(":", $participantes, 2); |
---|
| 970 | $filtro = "mail=$mail"; |
---|
| 971 | $email=$email.",".$mail; |
---|
| 972 | $atributos = array("uidNumber"); |
---|
| 973 | if (strlen($filtro) > 5){ |
---|
| 974 | $usuario = ldapDrivers::requestAtributo($filtro, $atributos); |
---|
| 975 | if ($usuario != false) { |
---|
| 976 | $part[0] = $usuario['uidNumber']; |
---|
| 977 | $teste = $first->CollectParameterValues('PARTSTAT'); |
---|
| 978 | foreach( $teste as $k => $v){ |
---|
| 979 | $stat = $k; |
---|
| 980 | } |
---|
| 981 | switch ($stat){ |
---|
| 982 | case "NEEDS-ACTION": $estado[0] = 'U'; |
---|
| 983 | break; |
---|
| 984 | case "ACCEPTED": $estado[0] = 'A'; |
---|
| 985 | break; |
---|
| 986 | case "DECLINED": $estado[0] = 'R'; |
---|
| 987 | break; |
---|
| 988 | case "TENTATIVE": $estado[0] = 'T'; |
---|
| 989 | break; |
---|
| 990 | } |
---|
| 991 | |
---|
| 992 | } else { |
---|
| 993 | $mails = $mail; |
---|
| 994 | } |
---|
| 995 | } |
---|
| 996 | } |
---|
| 997 | |
---|
| 998 | $email = trim($email,','); |
---|
| 999 | if ($nome != $proprietario && strlen($proprietario > 5)){ |
---|
| 1000 | if (is_array($part)) { |
---|
| 1001 | foreach($part AS $k => $v) { |
---|
| 1002 | if (isset($alarme_descarta) && $part[$k] == $nome) { |
---|
| 1003 | $laststack = "X-MOZ-LASTACK-PART-$nome"; |
---|
| 1004 | $qryusr = new AwlQuery("select * from phpgw_cal_extra where cal_id =:cal_id AND cal_extra_name=:cal_extra AND cal_extra_value=:cal_extra_value ",array(':cal_id' => $CALID, ':cal_extra' => $laststack,':cal_extra_value' => $alarme_descarta)); |
---|
| 1005 | if (!$qryusr->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1006 | if ($qryusr->rows() == 0) { |
---|
| 1007 | |
---|
| 1008 | $qryusr = new AwlQuery("INSERT INTO phpgw_cal_extra ( cal_id, cal_extra_name, cal_extra_value) VALUES ( :cal_id,:cal_extra,:cal_extra_value)",array(':cal_id' => $CALID, ':cal_extra' => $laststack,':cal_extra_value' => $alarme_descarta)); |
---|
| 1009 | if (!$qryusr->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1010 | } |
---|
| 1011 | } |
---|
| 1012 | |
---|
| 1013 | $qryuppart = new AwlQuery("DELETE from phpgw_cal_user WHERE cal_id = :cal_id AND cal_login = :part",array(':cal_id' => $CALID, ':part' => $part[$k])); |
---|
| 1014 | if (!$qryuppart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1015 | $qryslt = new AwlQuery("SELECT * FROM phpgw_cal_user WHERE cal_id = :cal_id AND cal_login = :part",array(':cal_id' => $CALID, ':part' => $part[$k])); |
---|
| 1016 | $result=$qryslt->Exec("PUT"); |
---|
| 1017 | if ($result->rows() < 1){ |
---|
| 1018 | $consulta = "INSERT INTO phpgw_cal_user ( cal_id, cal_login, cal_status, cal_type) VALUES ( :cal_id,:part,:estado,'u')"; |
---|
| 1019 | $qrypart = new AwlQuery($consulta,array(':cal_id' => $CALID, ':part' => $part[$k], ':estado' => $estado[$k])); |
---|
| 1020 | if (!$qrypart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1021 | } |
---|
| 1022 | else{ |
---|
| 1023 | $consulta = "UPDATE phpgw_cal_user SET ( cal_id, cal_login, cal_status, cal_type) VALUES ( :cal_id,:part,:estado,'u') WHERE cal_id = $CALID AND cal_login = :par"; |
---|
| 1024 | $qrypart = new AwlQuery($consulta,array(':cal_id' => $CALID, ':part' => $part[$k], ':estado' => $estado[$k],':par' => $part[$k] )); |
---|
| 1025 | |
---|
| 1026 | if (!$qrypart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1027 | } |
---|
| 1028 | } |
---|
| 1029 | } |
---|
| 1030 | |
---|
| 1031 | } |
---|
| 1032 | else{ |
---|
| 1033 | $hostbanco = "-@{$iporigem}"; |
---|
| 1034 | if ($put_action_type == 'INSERT') { |
---|
| 1035 | |
---|
| 1036 | $qry = new AwlQuery("INSERT INTO phpgw_cal ( cal_id, uid, owner, category, datetime, mdatetime, edatetime, |
---|
| 1037 | priority,cal_type,is_public, title, location, description, reference ) VALUES ( DEFAULT,:hostbanco, :nome, :category_id, :DT_START, :MOD, :DT_END, :prioridade, :tipo, :public, :titulo, :cidade, :descricao,0)",array( ':hostbanco' => $hostbanco, ':nome' => $nome, ':category_id' => $category_id, ':DT_START' => $DT_START, ':MOD' => $MOD, ':DT_END' => $DT_END, ':prioridade' => $prioridade, ':tipo' => $tipo, ':public' => $public, ':titulo' => $titulo, ':cidade' => $cidade, ':descricao' => $descricao)); |
---|
| 1038 | |
---|
| 1039 | if (!$qry->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1040 | $qryid = new AwlQuery("SELECT max(cal_id) FROM phpgw_cal WHERE owner = :nome", array(':nome' => $nome)); |
---|
| 1041 | $qryid->Exec("PUT"); |
---|
| 1042 | $cal = $qryid->Fetch(); |
---|
| 1043 | |
---|
| 1044 | |
---|
| 1045 | if ($DT_START != $alarme) { |
---|
| 1046 | $id = "cal:{$cal->max}:0"; |
---|
| 1047 | $next = $alarme; |
---|
| 1048 | $time = "i:{$alarme}"; |
---|
| 1049 | $method = "calendar.bocalendar.send_alarm"; |
---|
| 1050 | $data = "a:5:{s:4:\"time\";{$time};s:6:\"offset\";i:{$reducao};s:5:\"owner\";i:{$nome};s:7:\"enabled\";i:1;s:6:\"cal_id\";s:5:\"{$cal->max}\";}"; |
---|
| 1051 | $account_id = $nome; |
---|
| 1052 | $qry = new AwlQuery("INSERT INTO phpgw_async ( id, next, times, method, data, account_id) VALUES ( :id, :next, :time, :method, :data, :account_id)", array(':id' => $id,':next' => $next, ':time' => $time,':method' => $method, ':data' => $data, ':account_id' => $account_id)); |
---|
| 1053 | if (!$qry->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1054 | if (isset($alarme_descarta)) { |
---|
| 1055 | $qryusr = new AwlQuery("INSERT INTO phpgw_cal_extra ( cal_id, cal_extra_name, cal_extra_value) VALUES ( :cal,'X-MOZ-LASTACK',:alarme)", array(':cal' => $cal->max, ':alarme' => $alarme_descarta)); |
---|
| 1056 | if (!$qryusr->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1057 | } |
---|
| 1058 | |
---|
| 1059 | } |
---|
| 1060 | if ($tipo == 'M') { |
---|
| 1061 | $total = preg_split("[;]", $RECUR, -1, PREG_SPLIT_NO_EMPTY); |
---|
| 1062 | $numero = count($total); |
---|
| 1063 | $recur_enddate = 0; |
---|
| 1064 | $recur_data = 0; |
---|
| 1065 | $intervalo = 1; |
---|
| 1066 | foreach($total as $valor) { |
---|
| 1067 | list($ARG, $val) = split('[=]', $valor); |
---|
| 1068 | switch ($ARG) { |
---|
| 1069 | case "FREQ": |
---|
| 1070 | switch ($val) { |
---|
| 1071 | case "DAILY": |
---|
| 1072 | $tipo = 1; |
---|
| 1073 | break; |
---|
| 1074 | case "WEEKLY": |
---|
| 1075 | $tipo = 2; |
---|
| 1076 | break; |
---|
| 1077 | case "MONTHLY": |
---|
| 1078 | $tipo = 3; |
---|
| 1079 | break; |
---|
| 1080 | case "YEARLY": |
---|
| 1081 | $tipo = 5; |
---|
| 1082 | break; |
---|
| 1083 | } |
---|
| 1084 | break; |
---|
| 1085 | case "UNTIL": |
---|
| 1086 | $dateTime_until = date_create($val); |
---|
| 1087 | $recur_enddate = $dateTime_until->format("U"); |
---|
| 1088 | |
---|
| 1089 | break; |
---|
| 1090 | case "COUNT": |
---|
| 1091 | switch ($tipo) { |
---|
| 1092 | case 1: |
---|
| 1093 | $dias = $intervalo * ($val - 1) * 86400; |
---|
| 1094 | $recur_enddate = $DT_END + $dias; |
---|
| 1095 | break; |
---|
| 1096 | case 2: |
---|
| 1097 | $dias = $intervalo * ($val - 1) * 86400 * 7; |
---|
| 1098 | $recur_enddate = $DT_END + $dias; |
---|
| 1099 | break; |
---|
| 1100 | case 3: |
---|
| 1101 | $dias = $intervalo * ($val - 1) * 86400 * 31; |
---|
| 1102 | $recur_enddate = $DT_END + $dias; |
---|
| 1103 | break; |
---|
| 1104 | case 5: |
---|
| 1105 | $dias = $intervalo * ($val - 1) * 86400 * 365; |
---|
| 1106 | $recur_enddate = $DT_END + $dias; |
---|
| 1107 | break; |
---|
| 1108 | } |
---|
| 1109 | break; |
---|
| 1110 | case "INTERVAL": |
---|
| 1111 | $intervalo = $val; |
---|
| 1112 | break; |
---|
| 1113 | case "BYDAY": |
---|
| 1114 | //$semana = preg_split("[,]", $val, -1, PREG_SPLIT_NO_EMPTY); |
---|
| 1115 | dbg_error_log("PUT", "diaVAL : '%s' ", $val); |
---|
| 1116 | $semana = explode(",",$val); |
---|
| 1117 | if (count($semana , 1) == 1){ |
---|
| 1118 | array_push($semana , strtoupper(substr(date("D",$DT_START) ,0,2))); |
---|
| 1119 | } |
---|
| 1120 | $recur_data = 0; |
---|
| 1121 | foreach($semana as $dia) { |
---|
| 1122 | switch ($dia) { |
---|
| 1123 | case "SU": |
---|
| 1124 | $recur_data = $recur_data + 1; |
---|
| 1125 | break; |
---|
| 1126 | case "MO": |
---|
| 1127 | $recur_data = $recur_data + 2; |
---|
| 1128 | break; |
---|
| 1129 | case "TU": |
---|
| 1130 | $recur_data = $recur_data + 4; |
---|
| 1131 | break; |
---|
| 1132 | case "WE": |
---|
| 1133 | $recur_data = $recur_data + 8; |
---|
| 1134 | break; |
---|
| 1135 | case "TH": |
---|
| 1136 | $recur_data = $recur_data + 16; |
---|
| 1137 | break; |
---|
| 1138 | case "FR": |
---|
| 1139 | $recur_data = $recur_data + 32; |
---|
| 1140 | break; |
---|
| 1141 | case "SA": |
---|
| 1142 | $recur_data = $recur_data + 64; |
---|
| 1143 | break; |
---|
| 1144 | } |
---|
| 1145 | } |
---|
| 1146 | break; |
---|
| 1147 | default: |
---|
| 1148 | continue; |
---|
| 1149 | } |
---|
| 1150 | if ($recur_data == 62) |
---|
| 1151 | $tipo = 2; |
---|
| 1152 | } |
---|
| 1153 | $qryrepet = new AwlQuery("INSERT INTO phpgw_cal_repeats ( cal_id,recur_type, recur_use_end, recur_enddate, recur_interval,recur_data, recur_exception ) VALUES ( :cal,:tipo,0,:recur,:intervalo,:data,:exec)", array( ':cal' => $cal->max,':tipo' => $tipo, ':recur' => $recur_enddate, ':intervalo' => $intervalo, ':data' => $recur_data, ':exec' => $EXEC)); |
---|
| 1154 | if (!$qryrepet->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1155 | } |
---|
| 1156 | $qryusr = new AwlQuery("INSERT INTO phpgw_cal_user ( cal_id, cal_login, cal_status, cal_type) VALUES ( :cal,:nome,'A','u')", array(':cal' => $cal->max, ':nome' => $nome)); |
---|
| 1157 | if (!$qryusr->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1158 | if (is_array($part)) { |
---|
| 1159 | foreach($part AS $k => $v) { |
---|
| 1160 | $qrypart = new AwlQuery("INSERT INTO phpgw_cal_user ( cal_id, cal_login, cal_status, cal_type) VALUES ( :cal,:part,'U','u')", array(':cal' => $cal->max, ':part' => $part[$k])); |
---|
| 1161 | if (!$qrypart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1162 | } |
---|
| 1163 | } |
---|
| 1164 | if (isset($mails)) { |
---|
| 1165 | $qrypart_ex = new AwlQuery("UPDATE phpgw_cal SET ex_participants=:expart WHERE owner=:nome AND cal_id=:cal", array(':expart' => $mails, ':nome' => $nome, ':cal' => $cal->max)); |
---|
| 1166 | if (!$qrypart_ex->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1167 | } |
---|
| 1168 | |
---|
| 1169 | if ( $first->GetPValue('X-MOZ-SEND-INVITATIONS') == 'TRUE' ){ |
---|
| 1170 | $qrypart = new AwlQuery("INSERT INTO phpgw_cal_extra ( cal_id, cal_extra_name, cal_extra_value) VALUES ( :cal,'X-MOZ-SEND-INVITATIONS','true')", array(':cal' => $cal->max)); |
---|
| 1171 | if (!$qrypart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1172 | } |
---|
| 1173 | } elseif ($put_action_type == 'UPDATE') { |
---|
| 1174 | if ( $recur_id != null) { |
---|
| 1175 | $reference = substr( $UID ,0, strpos( $UID ,'@')); |
---|
| 1176 | $tipo = "E"; |
---|
| 1177 | $qry = new AwlQuery("INSERT INTO phpgw_cal |
---|
| 1178 | ( cal_id, uid, owner, category, datetime, mdatetime, edatetime, priority, |
---|
| 1179 | cal_type , is_public , title, location, description, reference ) |
---|
| 1180 | VALUES ( DEFAULT,:hostbanco,:nome,:category_id,:DTSTART,:MOD,:DTEND,:prioridade,:tipo,:public,:titulo,:cidade,:descricao,:ref)",array(':hostbanco' => $hostbanco, ':nome' => $nome,':category_id' => $category_id,':DTSTART' => $DT_START, ':MOD' => $MOD, ':DTEND' => $DT_END, ':prioridade' => $prioridade, ':tipo' => $tipo, ':public' => $public, ':titulo' => $titulo, ':cidade' => $cidade, ':descricao' => $descricao,':ref' => $reference)); |
---|
| 1181 | if (!$qry->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1182 | $qryid = new AwlQuery("SELECT max(cal_id) FROM phpgw_cal WHERE owner = :nome", array(':nome' => $nome)); |
---|
| 1183 | $qryid->Exec("PUT"); |
---|
| 1184 | $call = $qryid->Fetch(); |
---|
| 1185 | $CALID = $call->max; |
---|
| 1186 | $qry = new AwlQuery("INSERT INTO phpgw_cal_user ( cal_id, cal_login, cal_status, cal_type) VALUES ( :cal,:nome,'A','u');",array(':cal' => $call->max,':nome' => $nome)); |
---|
| 1187 | if (!$qry->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1188 | $id_cal = "cal:$reference:0"; |
---|
| 1189 | $qryid = new Awlquery("SELECT * FROM phpgw_async WHERE id = :id_cal", array(':id_cal' => $id_cal)); |
---|
| 1190 | dbg_error_log("PUT", "argumento : '%s' igual '%s' ", $DT_START, $alarme); |
---|
| 1191 | if ( $qryid->Exec("PUT",__LINE__,__FILE__) && $qryid->rows() > 0 && $DT_START != $alarme) |
---|
| 1192 | { $alarmew = $qryid->Fetch(); |
---|
| 1193 | $data_seg = dataTParaSegundos($recur_id["DTSTART"]); |
---|
| 1194 | $tempo_ant = $data_seg - $reducao; |
---|
| 1195 | $id_cal_novo = "cal:$call->max:0"; |
---|
| 1196 | $timess = "i:$tempo_ant"; |
---|
| 1197 | $dados_alarme= "a:5:{s:4:\"time\";i:$tempo_ant;s:6:\"offset\";i:$reducao;s:5:\"owner\";i:$nome;s:7:\"enabled\";i:1;s:6:\"cal_id\";s:5:\"$call->max\";}"; |
---|
| 1198 | $qrysy = new PgQuery("INSERT INTO phpgw_async ( id, next, times, method, data, account_id) VALUES ( :id,:next,:times,'calendar.bocalendar.send_alarm',:data,:account);", array(':id' => $id_cal_novo,':next' => $tempo_ant,':times' => $timess,':data' => $dados_alarme,':account' => $nome)); |
---|
| 1199 | if (!$qrysy->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1200 | |
---|
| 1201 | } |
---|
| 1202 | /* |
---|
| 1203 | if (is_array($part)) { |
---|
| 1204 | foreach($part AS $k => $v) { |
---|
| 1205 | if ($estado[$k] != 'U'){ |
---|
| 1206 | $qryuppart = new AwlQuery("DELETE from phpgw_cal_user WHERE cal_id = :cal_id AND cal_login = :part",array(':cal_id' => $CALID,':part' => $part[$k])); |
---|
| 1207 | if (!$qryuppart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1208 | $qryslt = new AwlQuery("SELECT * FROM phpgw_cal_user WHERE cal_id = :cal_id AND cal_login = :part",array(':cal_id' => $CALID,':part' => $part[$k])); $ |
---|
| 1209 | $result=$qryslt->Exec("PUT"); |
---|
| 1210 | if ($result->rows < 1){ |
---|
| 1211 | $consulta = "INSERT INTO phpgw_cal_user ( cal_id, cal_login, cal_status, cal_type) VALUES ( :cal_id ,:part,:estado,'u')"; |
---|
| 1212 | $qrypart = new AwlQuery($consulta, array(':cal_id' => $CALID,':part' => $part[$k],':estado' => $estado[$k])); $ |
---|
| 1213 | if (!$qrypart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1214 | } |
---|
| 1215 | else{ |
---|
| 1216 | $consulta = "UPDATE phpgw_cal_user SET ( cal_id, cal_login, cal_status, cal_type) VALUES ( :cal_id ,:part,:estado,'u') WHERE cal_id = $CALID AND cal_login = :par"; $ |
---|
| 1217 | $qrypart = new AwlQuery($consulta, array(':cal_id' => $CALID,':part' => $part[$k],':estado' => $estado[$k],':par' => $part[$k])); $ |
---|
| 1218 | if (!$qrypart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1219 | } |
---|
| 1220 | } |
---|
| 1221 | } |
---|
| 1222 | } |
---|
| 1223 | if (isset($mails)) { |
---|
| 1224 | $qrypart_ex = new AwlQuery("UPDATE phpgw_cal SET ex_participants=:expart WHERE owner=:nome AND cal_id=:cal_id", array(':expart' => $mails,':nome' => $nome,':cal_id' => $call->max)); |
---|
| 1225 | if (!$qrypart_ex->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1226 | } |
---|
| 1227 | */ |
---|
| 1228 | } |
---|
| 1229 | else |
---|
| 1230 | { |
---|
| 1231 | //if( isset($alarme_descarta) || isset($adia_alarme)) |
---|
| 1232 | // { } |
---|
| 1233 | // else |
---|
| 1234 | // { |
---|
| 1235 | $qry = new AwlQuery("UPDATE phpgw_cal SET cal_id=:cal ,uid=:hostbanco ,owner=:nome ,category=:category_id , datetime=:DT_START, mdatetime=:MOD, edatetime=:DT_END, priority=:prioridade, cal_type=:tipo, is_public=:public, title=:titulo , description=:descricao, location=:location, ex_participants=:expart WHERE owner=:nome AND cal_id=:cal_id", array( ':cal' => $CALID ,':hostbanco' => $hostbanco, ':nome' => $nome, ':category_id' => $category_id, ':DT_START' => $DT_START, ':MOD' => $MOD, ':DT_END' => $DT_END, ':prioridade' => $prioridade, ':tipo' => $tipo, ':public' => $public, ':titulo' => $titulo,':descricao' => $descricao,':location' => $cidade,':expart' => $mails,':nome' => $nome,':cal_id' => $CALID )); |
---|
| 1236 | if (!$qry->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1237 | // } |
---|
| 1238 | if ($DT_START != $alarme) { |
---|
| 1239 | $id = "cal:$CALID:0"; |
---|
| 1240 | $next = "$alarme"; |
---|
| 1241 | $time = "i:$alarme"; |
---|
| 1242 | $method = "calendar.bocalendar.send_alarm"; |
---|
| 1243 | $data = "a:5:{s:4:\"time\";$time;s:6:\"offset\";i:$reducao;s:5:\"owner\";i:$nome;s:7:\"enabled\";i:1;s:6:\"cal_id\";s:5:\"$CALID\";}"; |
---|
| 1244 | $account_id = "$nome"; |
---|
| 1245 | $qry = new AwlQuery("UPDATE phpgw_async set next=:next, times=:time, data=:data, account_id=:account WHERE id=:id", array(':next' => $next,':time' => $time, ':data' => $data, ':account' => $account_id, ':id' => $id)); |
---|
| 1246 | $qry->Exec("PUT"); |
---|
| 1247 | $qry = new AwlQuery("select * from phpgw_cal_extra WHERE cal_id=:cal_id", array(':cal_id' => $CALID)); |
---|
| 1248 | $qry->Exec("PUT"); |
---|
| 1249 | dbg_error_log("PUT", "argumento : '%s' valor : '%s' ", $alarme_descarta); |
---|
| 1250 | if ($qry->rows() != 0) { |
---|
| 1251 | if (isset($alarme_descarta)) { |
---|
| 1252 | $qryusr = new AwlQuery("UPDATE phpgw_cal_extra set cal_extra_value=:alarme WHERE cal_id=:cal_id AND cal_extra_name = 'X-MOZ-LASTACK'",array(':alarme' => $alarme_descarta, ':cal_id' => $CALID)); |
---|
| 1253 | $qryusr->Exec("PUT"); |
---|
| 1254 | } |
---|
| 1255 | if (isset($adia_alarme)) { |
---|
| 1256 | $qryusr = new AwlQuery("UPDATE phpgw_cal_extra set cal_extra_value=:calextravalue WHERE cal_id=:cal AND cal_extra_name =:cal_extra ", array(':calextravalue' => $adia_alarme ,':cal' => $CALID, ':cal_extra' => $snooze)); |
---|
| 1257 | $qryusr->Exec("PUT"); |
---|
| 1258 | } |
---|
| 1259 | |
---|
| 1260 | } else { |
---|
| 1261 | |
---|
| 1262 | if (isset($alarme_descarta)) { |
---|
| 1263 | $qryusr = new AwlQuery("INSERT INTO phpgw_cal_extra ( cal_id, cal_extra_name, cal_extra_value) VALUES ( :cal,'X-MOZ-LASTACK',:alarme)", array(':cal' => $CALID,':alarme' => $alarme_descarta)); |
---|
| 1264 | if (!$qryusr->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1265 | } |
---|
| 1266 | if (isset($adia_alarme)) { |
---|
| 1267 | $qryusr = new AwlQuery("INSERT INTO phpgw_cal_extra ( cal_id, cal_extra_name, cal_extra_value) VALUES ( :cal,:snooze,:adia)", array(':cal' => $CALID,':snooze' => $snooze, ':adia' => $adia_alarme)); |
---|
| 1268 | if (!$qryusr->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1269 | } |
---|
| 1270 | |
---|
| 1271 | } |
---|
| 1272 | |
---|
| 1273 | $qry = new AwlQuery("select id from phpgw_async WHERE id=:id", array(':id' => $id)); |
---|
| 1274 | $qry->Exec("PUT"); |
---|
| 1275 | if ($qry->rows() == 0) { |
---|
| 1276 | $qry = new AwlQuery("INSERT INTO phpgw_async ( id, next, times, method, data, account_id) VALUES (:id, :next, :time, :method, :data, :account_id)",array(':id' => $id,':next' => $next,':time' => $time,':method' => $method, ':data' => $data, ':account_id' => $account_id)); |
---|
| 1277 | if (!$qry->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1278 | } |
---|
| 1279 | } |
---|
| 1280 | |
---|
| 1281 | if ((strlen($alarme_time) == 0) && ($tipo == 'E')) { |
---|
| 1282 | $id = "cal:$CALID:0"; |
---|
| 1283 | $qry = new AwlQuery("DELETE FROM phpgw_async WHERE id=:id", array(':id' => $id)); |
---|
| 1284 | $qry->Exec("PUT"); |
---|
| 1285 | } |
---|
| 1286 | if ($tipo == 'M') { |
---|
| 1287 | $total = preg_split("[;]", $RECUR, -1, PREG_SPLIT_NO_EMPTY); |
---|
| 1288 | $numero = count($total); |
---|
| 1289 | $recur_enddate = 0; |
---|
| 1290 | $recur_data = 0; |
---|
| 1291 | foreach($total as $valor) { |
---|
| 1292 | list($ARG, $val) = split('[=]', $valor); |
---|
| 1293 | dbg_error_log("PUT", "argumento : '%s' valor : '%s' ", $ARG, $val); |
---|
| 1294 | switch ($ARG) { |
---|
| 1295 | case "FREQ": |
---|
| 1296 | switch ($val) { |
---|
| 1297 | case "DAILY": |
---|
| 1298 | $tipo = 1; |
---|
| 1299 | break; |
---|
| 1300 | case "WEEKLY": |
---|
| 1301 | $tipo = 2; |
---|
| 1302 | break; |
---|
| 1303 | case "MONTHLY": |
---|
| 1304 | $tipo = 3; |
---|
| 1305 | break; |
---|
| 1306 | case "YEARLY": |
---|
| 1307 | $tipo = 5; |
---|
| 1308 | break; |
---|
| 1309 | } |
---|
| 1310 | break; |
---|
| 1311 | case "UNTIL": |
---|
| 1312 | //$recur_enddate = dataTDiaSeguinteSegundos($val ,1); |
---|
| 1313 | $dateTime_until = date_create($val); |
---|
| 1314 | $recur_enddate = $dateTime_until->format("U"); |
---|
| 1315 | break; |
---|
| 1316 | case "COUNT": |
---|
| 1317 | switch ($tipo) { |
---|
| 1318 | case 1: |
---|
| 1319 | $dias = $intervalo * $val * 86400; |
---|
| 1320 | $recur_enddate = $DT_END + $dias; |
---|
| 1321 | break; |
---|
| 1322 | case 2: |
---|
| 1323 | $dias = $intervalo * $val * 86400 * 7; |
---|
| 1324 | $recur_enddate = $DT_END + $dias; |
---|
| 1325 | break; |
---|
| 1326 | case 3: |
---|
| 1327 | $dias = $intervalo * $val * 86400 * 31; |
---|
| 1328 | $recur_enddate = $DT_END + $dias; |
---|
| 1329 | break; |
---|
| 1330 | case 5: |
---|
| 1331 | $dias = $intervalo * $val * 86400 * 365; |
---|
| 1332 | $recur_enddate = $DT_END + $dias; |
---|
| 1333 | break; |
---|
| 1334 | } |
---|
| 1335 | break; |
---|
| 1336 | case "INTERVAL": |
---|
| 1337 | $intervalo = $val; |
---|
| 1338 | case "BYDAY": |
---|
| 1339 | $semana = preg_split("[,]", $val, -1, PREG_SPLIT_NO_EMPTY); |
---|
| 1340 | if (count($semana , 1) == 1){ |
---|
| 1341 | dbg_error_log("PUT", "dia1 : '%s' ", count($semana)); |
---|
| 1342 | array_push($semana , strtoupper(substr(date("D",$DT_START) ,0,2))); |
---|
| 1343 | } |
---|
| 1344 | $recur_data=0; |
---|
| 1345 | foreach($semana as $dia) { |
---|
| 1346 | dbg_error_log("PUT", "dia 2 : '%s' ", $dia); |
---|
| 1347 | switch ($dia) { |
---|
| 1348 | case "SU": |
---|
| 1349 | $recur_data = $recur_data + 1; |
---|
| 1350 | break; |
---|
| 1351 | case "MO": |
---|
| 1352 | $recur_data = $recur_data + 2; |
---|
| 1353 | break; |
---|
| 1354 | case "TU": |
---|
| 1355 | $recur_data = $recur_data + 4; |
---|
| 1356 | break; |
---|
| 1357 | case "WE": |
---|
| 1358 | $recur_data = $recur_data + 8; |
---|
| 1359 | break; |
---|
| 1360 | case "TH": |
---|
| 1361 | $recur_data = $recur_data + 16; |
---|
| 1362 | break; |
---|
| 1363 | case "FR": |
---|
| 1364 | $recur_data = $recur_data + 32; |
---|
| 1365 | break; |
---|
| 1366 | case "SA": |
---|
| 1367 | $recur_data = $recur_data + 64; |
---|
| 1368 | break; |
---|
| 1369 | } |
---|
| 1370 | } |
---|
| 1371 | break; |
---|
| 1372 | default: |
---|
| 1373 | continue; |
---|
| 1374 | } |
---|
| 1375 | if ($recur_data == 62) |
---|
| 1376 | $tipo = 2; |
---|
| 1377 | } |
---|
| 1378 | $qryrepet = new AwlQuery("UPDATE phpgw_cal_repeats set cal_id=:cal,recur_type=:recur , recur_enddate=:data, recur_interval=:intervalo, recur_data=:recurdata , recur_exception=:exception where cal_id = :cal_id", array(':cal' => $CALID,':recur' => $tipo, ':data' => $recur_enddate, ':intervalo' => $intervalo,':recurdata' => $recur_data, ':exception' => $EXEC, ':cal_id' => $CALID)); |
---|
| 1379 | if (!$qryrepet->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1380 | } |
---|
| 1381 | //$qryuppart = new PgQuery("DELETE from phpgw_cal_user WHERE cal_id = ? AND cal_status = 'U' AND cal_login = ?",$CALID,$nome); |
---|
| 1382 | //if (!$qryuppart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1383 | if (is_array($part)) { |
---|
| 1384 | foreach($part AS $k => $v) { |
---|
| 1385 | if ($estado[$k] != 'R'){ |
---|
| 1386 | $qryuppart = new AwlQuery("DELETE from phpgw_cal_user WHERE cal_id = :cal_id AND cal_login = :part",array(':cal_id' => $CALID,':part' => $part[$k])); |
---|
| 1387 | if (!$qryuppart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1388 | $qryslt = new AwlQuery("SELECT * FROM phpgw_cal_user WHERE cal_id = :cal_id AND cal_login = :part",array(':cal_id' => $CALID,':part' => $part[$k])); |
---|
| 1389 | $result=$qryslt->Exec("PUT"); |
---|
| 1390 | if ($result->rows < 1){ |
---|
| 1391 | $consulta = "INSERT INTO phpgw_cal_user ( cal_id, cal_login, cal_status, cal_type) VALUES ( :cal_id ,:part,:estado,'u')"; |
---|
| 1392 | $qrypart = new AwlQuery($consulta, array(':cal_id' => $CALID,':part' => $part[$k],':estado' => $estado[$k])); |
---|
| 1393 | if (!$qrypart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1394 | } |
---|
| 1395 | else{ |
---|
| 1396 | $consulta = "UPDATE phpgw_cal_user SET ( cal_id, cal_login, cal_status, cal_type) VALUES ( :cal_id ,:part,:estado,'u') WHERE cal_id = $CALID AND cal_login = :par"; |
---|
| 1397 | $qrypart = new AwlQuery($consulta, array(':cal_id' => $CALID,':part' => $part[$k],':estado' => $estado[$k],':par' => $part[$k])); |
---|
| 1398 | |
---|
| 1399 | if (!$qrypart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1400 | } |
---|
| 1401 | } |
---|
| 1402 | } |
---|
| 1403 | } |
---|
| 1404 | if (isset($mails)) { |
---|
| 1405 | $qrypart_ex = new AwlQuery("UPDATE phpgw_cal SET ex_participants=:expart WHERE owner=:nome AND cal_id=:cal_id", array(':expart' => $mails,':nome' => $nome,':cal_id' => $CALID)); |
---|
| 1406 | if (!$qrypart_ex->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1407 | } |
---|
| 1408 | if ( $first->GetPValue('X-MOZ-SEND-INVITATIONS') == 'TRUE' ){ |
---|
| 1409 | $qrypart = new AwlQuery("INSERT INTO phpgw_cal_extra ( cal_id, cal_extra_name, cal_extra_value) VALUES ( :cal,'X-MOZ-SEND-INVITATIONS','true')", array(':cal' => $CALID)); |
---|
| 1410 | if (!$qrypart->Exec("PUT")) rollback_on_error($caldav_context, $user_no, $path); |
---|
| 1411 | } |
---|
| 1412 | } |
---|
| 1413 | } |
---|
| 1414 | } |
---|
| 1415 | return true; |
---|
| 1416 | |
---|
| 1417 | } |
---|
| 1418 | function write_resource_old( $user_no, $path, $caldav_data, $collection_id, $author, $etag, $ic, $put_action_type, $caldav_context, $log_action=true, $weak_etag=null ) { |
---|
| 1419 | global $tz_regex; |
---|
| 1420 | |
---|
| 1421 | $resources = $ic->GetComponents('VTIMEZONE',false); // Not matching VTIMEZONE |
---|
| 1422 | if ( !isset($resources[0]) ) { |
---|
| 1423 | $resource_type = 'Unknown'; |
---|
| 1424 | /** @TODO: Handle writing non-calendar resources, like address book entries or random file data */ |
---|
| 1425 | rollback_on_error( $caldav_context, $user_no, $path, translate('No calendar content'), 412 ); |
---|
| 1426 | return false; |
---|
| 1427 | } |
---|
| 1428 | else { |
---|
| 1429 | $first = $resources[0]; |
---|
| 1430 | $resource_type = $first->GetType(); |
---|
| 1431 | } |
---|
| 1432 | dbg_log_array('PUT','VTIMEZONE',$first,true); |
---|
| 1433 | $qry = new AwlQuery(); |
---|
| 1434 | $qry->Begin(); |
---|
| 1435 | $params = array( |
---|
| 1436 | ':dav_name' => $path, |
---|
| 1437 | ':user_no' => $user_no, |
---|
| 1438 | ':etag' => $etag, |
---|
| 1439 | ':dav_data' => $caldav_data, |
---|
| 1440 | ':caldav_type' => $resource_type, |
---|
| 1441 | ':session_user' => $author, |
---|
| 1442 | ':weak_etag' => $weak_etag |
---|
| 1443 | ); |
---|
| 1444 | if ( $put_action_type == 'INSERT' ) { |
---|
| 1445 | create_scheduling_requests($vcal); |
---|
| 1446 | $sql = 'INSERT INTO caldav_data ( user_no, dav_name, dav_etag, caldav_data, caldav_type, logged_user, created, modified, collection_id, weak_etag ) |
---|
| 1447 | VALUES( :user_no, :dav_name, :etag, :dav_data, :caldav_type, :session_user, current_timestamp, current_timestamp, :collection_id, :weak_etag )'; |
---|
| 1448 | $params[':collection_id'] = $collection_id; |
---|
| 1449 | } |
---|
| 1450 | else { |
---|
| 1451 | update_scheduling_requests($vcal); |
---|
| 1452 | $sql = 'UPDATE caldav_data SET caldav_data=:dav_data, dav_etag=:etag, caldav_type=:caldav_type, logged_user=:session_user, |
---|
| 1453 | modified=current_timestamp, weak_etag=:weak_etag WHERE user_no=:user_no AND dav_name=:dav_name'; |
---|
| 1454 | } |
---|
| 1455 | if ( !$qry->QDo($sql,$params) ) { |
---|
| 1456 | rollback_on_error( $caldav_context, $user_no, $path); |
---|
| 1457 | return false; |
---|
| 1458 | } |
---|
| 1459 | |
---|
| 1460 | $qry->QDo('SELECT dav_id FROM caldav_data WHERE dav_name = :dav_name ', array(':dav_name' => $path)); |
---|
| 1461 | if ( $qry->rows() == 1 && $row = $qry->Fetch() ) { |
---|
| 1462 | $dav_id = $row->dav_id; |
---|
| 1463 | } |
---|
| 1464 | |
---|
| 1465 | |
---|
| 1466 | $calitem_params = array( |
---|
| 1467 | ':dav_name' => $path, |
---|
| 1468 | ':user_no' => $user_no, |
---|
| 1469 | ':etag' => $etag |
---|
| 1470 | ); |
---|
| 1471 | $dtstart = $first->GetPValue('DTSTART'); |
---|
| 1472 | $calitem_params[':dtstart'] = $dtstart; |
---|
| 1473 | if ( (!isset($dtstart) || $dtstart == '') && $first->GetPValue('DUE') != '' ) { |
---|
| 1474 | $dtstart = $first->GetPValue('DUE'); |
---|
| 1475 | } |
---|
| 1476 | |
---|
| 1477 | $dtend = $first->GetPValue('DTEND'); |
---|
| 1478 | if ( isset($dtend) && $dtend != '' ) { |
---|
| 1479 | dbg_error_log( 'PUT', ' DTEND: "%s", DTSTART: "%s", DURATION: "%s"', $dtend, $dtstart, $first->GetPValue('DURATION') ); |
---|
| 1480 | $calitem_params[':dtend'] = $dtend; |
---|
| 1481 | $dtend = ':dtend'; |
---|
| 1482 | } |
---|
| 1483 | else { |
---|
| 1484 | $dtend = 'NULL'; |
---|
| 1485 | if ( $first->GetPValue('DURATION') != '' AND $dtstart != '' ) { |
---|
| 1486 | $duration = preg_replace( '#[PT]#', ' ', $first->GetPValue('DURATION') ); |
---|
| 1487 | $dtend = '(:dtstart::timestamp with time zone + :duration::interval)'; |
---|
| 1488 | $calitem_params[':duration'] = $duration; |
---|
| 1489 | } |
---|
| 1490 | elseif ( $first->GetType() == 'VEVENT' ) { |
---|
| 1491 | /** |
---|
| 1492 | * From RFC2445 4.6.1: |
---|
| 1493 | * For cases where a "VEVENT" calendar component specifies a "DTSTART" |
---|
| 1494 | * property with a DATE data type but no "DTEND" property, the events |
---|
| 1495 | * non-inclusive end is the end of the calendar date specified by the |
---|
| 1496 | * "DTSTART" property. For cases where a "VEVENT" calendar component specifies |
---|
| 1497 | * a "DTSTART" property with a DATE-TIME data type but no "DTEND" property, |
---|
| 1498 | * the event ends on the same calendar date and time of day specified by the |
---|
| 1499 | * "DTSTART" property. |
---|
| 1500 | * |
---|
| 1501 | * So we're looking for 'VALUE=DATE', to identify the duration, effectively. |
---|
| 1502 | * |
---|
| 1503 | */ |
---|
| 1504 | |
---|
| 1505 | $value_type = $first->GetPParamValue('DTSTART','VALUE'); |
---|
| 1506 | dbg_error_log('PUT','DTSTART without DTEND. DTSTART value type is %s', $value_type ); |
---|
| 1507 | if ( isset($value_type) && $value_type == 'DATE' ) |
---|
| 1508 | $dtend = '(:dtstart::timestamp with time zone::date + \'1 day\'::interval)'; |
---|
| 1509 | else |
---|
| 1510 | $dtend = ':dtstart'; |
---|
| 1511 | } |
---|
| 1512 | } |
---|
| 1513 | |
---|
| 1514 | $last_modified = $first->GetPValue('LAST-MODIFIED'); |
---|
| 1515 | if ( !isset($last_modified) || $last_modified == '' ) { |
---|
| 1516 | $last_modified = gmdate( 'Ymd\THis\Z' ); |
---|
| 1517 | } |
---|
| 1518 | $calitem_params[':modified'] = $last_modified; |
---|
| 1519 | |
---|
| 1520 | $dtstamp = $first->GetPValue('DTSTAMP'); |
---|
| 1521 | if ( !isset($dtstamp) || $dtstamp == '' ) { |
---|
| 1522 | $dtstamp = $last_modified; |
---|
| 1523 | } |
---|
| 1524 | $calitem_params[':dtstamp'] = $dtstamp; |
---|
| 1525 | |
---|
| 1526 | $class = $first->GetPValue('CLASS'); |
---|
| 1527 | /* Check and see if we should over ride the class. */ |
---|
| 1528 | /** @TODO: is there some way we can move this out of this function? Or at least get rid of the need for the SQL query here. */ |
---|
| 1529 | if ( public_events_only($user_no, $path) ) { |
---|
| 1530 | $class = 'PUBLIC'; |
---|
| 1531 | } |
---|
| 1532 | |
---|
| 1533 | /* |
---|
| 1534 | * It seems that some calendar clients don't set a class... |
---|
| 1535 | * RFC2445, 4.8.1.3: |
---|
| 1536 | * Default is PUBLIC |
---|
| 1537 | */ |
---|
| 1538 | if ( !isset($class) || $class == '' ) { |
---|
| 1539 | $class = 'PUBLIC'; |
---|
| 1540 | } |
---|
| 1541 | $calitem_params[':class'] = $class; |
---|
| 1542 | |
---|
| 1543 | |
---|
| 1544 | /** Calculate what timezone to set, first, if possible */ |
---|
| 1545 | $last_tz_locn = 'Turkmenikikamukau'; // I really hope this location doesn't exist! |
---|
| 1546 | $tzid = $first->GetPParamValue('DTSTART','TZID'); |
---|
| 1547 | if ( !isset($tzid) || $tzid == '' ) $tzid = $first->GetPParamValue('DUE','TZID'); |
---|
| 1548 | $timezones = $ic->GetComponents('VTIMEZONE'); |
---|
| 1549 | foreach( $timezones AS $k => $tz ) { |
---|
| 1550 | if ( $tz->GetPValue('TZID') != $tzid ) { |
---|
| 1551 | /** |
---|
| 1552 | * We'll pretend they didn't forget to give us a TZID and that they |
---|
| 1553 | * really hope the server is running in the timezone they supplied... but be noisy about it. |
---|
| 1554 | */ |
---|
| 1555 | dbg_error_log( 'ERROR', ' Event includes TZID[%s] but uses TZID[%s]!', $tz->GetPValue('TZID'), $tzid ); |
---|
| 1556 | $tzid = $tz->GetPValue('TZID'); |
---|
| 1557 | } |
---|
| 1558 | // This is the one |
---|
| 1559 | $tz_locn = $tz->GetPValue('X-LIC-LOCATION'); |
---|
| 1560 | if ( ! isset($tz_locn) ) { |
---|
| 1561 | if ( preg_match( '#([^/]+/[^/]+)$#', $tzid, $matches ) ) |
---|
| 1562 | $tz_locn = $matches[1]; |
---|
| 1563 | else if ( isset($tzid) && $tzid != '' ) { |
---|
| 1564 | dbg_error_log( 'ERROR', ' Couldn\'t guess Olsen TZ from TZID[%s]. This may end in tears...', $tzid ); |
---|
| 1565 | } |
---|
| 1566 | } |
---|
| 1567 | else { |
---|
| 1568 | if ( ! preg_match( $tz_regex, $tz_locn ) ) { |
---|
| 1569 | if ( preg_match( '#([^/]+/[^/]+)$#', $tzid, $matches ) ) $tz_locn = $matches[1]; |
---|
| 1570 | } |
---|
| 1571 | } |
---|
| 1572 | |
---|
| 1573 | dbg_error_log( 'PUT', ' Using TZID[%s] and location of [%s]', $tzid, (isset($tz_locn) ? $tz_locn : '') ); |
---|
| 1574 | if ( isset($tz_locn) && ($tz_locn != $last_tz_locn) && preg_match( $tz_regex, $tz_locn ) ) { |
---|
| 1575 | dbg_error_log( 'PUT', ' Setting timezone to %s', $tz_locn ); |
---|
| 1576 | if ( $tz_locn != '' ) { |
---|
| 1577 | $qry->QDo('SET TIMEZONE TO \''.$tz_locn."'" ); |
---|
| 1578 | } |
---|
| 1579 | $last_tz_locn = $tz_locn; |
---|
| 1580 | } |
---|
| 1581 | $params = array( ':tzid' => $tzid); |
---|
| 1582 | $qry = new AwlQuery('SELECT tz_locn FROM time_zone WHERE tz_id = :tzid', $params ); |
---|
| 1583 | if ( $qry->Exec('PUT',__LINE__,__FILE__) && $qry->rows() == 0 ) { |
---|
| 1584 | $params[':tzlocn'] = $tz_locn; |
---|
| 1585 | $params[':tzspec'] = (isset($tz) ? $tz->Render() : null ); |
---|
| 1586 | $qry->QDo('INSERT INTO time_zone (tz_id, tz_locn, tz_spec) VALUES(:tzid,:tzlocn,:tzspec)', $params ); |
---|
| 1587 | } |
---|
| 1588 | if ( !isset($tz_locn) || $tz_locn == '' ) $tz_locn = $tzid; |
---|
| 1589 | |
---|
| 1590 | } |
---|
| 1591 | |
---|
| 1592 | $created = $first->GetPValue('CREATED'); |
---|
| 1593 | if ( $created == '00001231T000000Z' ) $created = '20001231T000000Z'; |
---|
| 1594 | $calitem_params[':created'] = $created; |
---|
| 1595 | |
---|
| 1596 | $calitem_params[':tzid'] = $tzid; |
---|
| 1597 | $calitem_params[':uid'] = $first->GetPValue('UID'); |
---|
| 1598 | $calitem_params[':summary'] = $first->GetPValue('SUMMARY'); |
---|
| 1599 | $calitem_params[':location'] = $first->GetPValue('LOCATION'); |
---|
| 1600 | $calitem_params[':transp'] = $first->GetPValue('TRANSP'); |
---|
| 1601 | $calitem_params[':description'] = $first->GetPValue('DESCRIPTION'); |
---|
| 1602 | $calitem_params[':rrule'] = $first->GetPValue('RRULE'); |
---|
| 1603 | $calitem_params[':url'] = $first->GetPValue('URL'); |
---|
| 1604 | $calitem_params[':priority'] = $first->GetPValue('PRIORITY'); |
---|
| 1605 | $calitem_params[':due'] = $first->GetPValue('DUE'); |
---|
| 1606 | $calitem_params[':percent_complete'] = $first->GetPValue('PERCENT-COMPLETE'); |
---|
| 1607 | $calitem_params[':status'] = $first->GetPValue('STATUS'); |
---|
| 1608 | if ( $put_action_type == 'INSERT' ) { |
---|
| 1609 | $sql = <<<EOSQL |
---|
| 1610 | INSERT INTO calendar_item (user_no, dav_name, dav_id, dav_etag, uid, dtstamp, |
---|
| 1611 | dtstart, dtend, summary, location, class, transp, |
---|
| 1612 | description, rrule, tz_id, last_modified, url, priority, |
---|
| 1613 | created, due, percent_complete, status, collection_id ) |
---|
| 1614 | VALUES ( :user_no, :dav_name, currval('dav_id_seq'), :etag, :uid, :dtstamp, |
---|
| 1615 | :dtstart, $dtend, :summary, :location, :class, :transp, |
---|
| 1616 | :description, :rrule, :tzid, :modified, :url, :priority, |
---|
| 1617 | :created, :due, :percent_complete, :status, $collection_id ) |
---|
| 1618 | EOSQL; |
---|
| 1619 | $sync_change = 201; |
---|
| 1620 | } |
---|
| 1621 | else { |
---|
| 1622 | $sql = <<<EOSQL |
---|
| 1623 | UPDATE calendar_item SET dav_etag=:etag, uid=:uid, dtstamp=:dtstamp, |
---|
| 1624 | dtstart=:dtstart, dtend=$dtend, summary=:summary, location=:location, class=:class, transp=:transp, |
---|
| 1625 | description=:description, rrule=:rrule, tz_id=:tzid, last_modified=:modified, url=:url, priority=:priority, |
---|
| 1626 | created=:created, due=:due, percent_complete=:percent_complete, status=:status |
---|
| 1627 | WHERE user_no=:user_no AND dav_name=:dav_name |
---|
| 1628 | EOSQL; |
---|
| 1629 | $sync_change = 200; |
---|
| 1630 | } |
---|
| 1631 | |
---|
| 1632 | write_alarms($dav_id, $first); |
---|
| 1633 | write_attendees($dav_id, $first); |
---|
| 1634 | |
---|
| 1635 | if ( $log_action && function_exists('log_caldav_action') ) { |
---|
| 1636 | log_caldav_action( $put_action_type, $first->GetPValue('UID'), $user_no, $collection_id, $path ); |
---|
| 1637 | } |
---|
| 1638 | else if ( $log_action ) { |
---|
| 1639 | dbg_error_log( 'PUT', 'No log_caldav_action( %s, %s, %s, %s, %s) can be called.', |
---|
| 1640 | $put_action_type, $first->GetPValue('UID'), $user_no, $collection_id, $path ); |
---|
| 1641 | } |
---|
| 1642 | |
---|
| 1643 | $qry = new AwlQuery( $sql, $calitem_params ); |
---|
| 1644 | if ( !$qry->Exec('PUT',__LINE__,__FILE__) ) { |
---|
| 1645 | rollback_on_error( $caldav_context, $user_no, $path); |
---|
| 1646 | return false; |
---|
| 1647 | } |
---|
| 1648 | $qry->QDo("SELECT write_sync_change( $collection_id, $sync_change, :dav_name)", array(':dav_name' => $path ) ); |
---|
| 1649 | $qry->Commit(); |
---|
| 1650 | |
---|
| 1651 | dbg_error_log( 'PUT', 'User: %d, ETag: %s, Path: %s', $author, $etag, $path); |
---|
| 1652 | |
---|
| 1653 | return true; // Success! |
---|
| 1654 | } |
---|
| 1655 | |
---|
| 1656 | |
---|
| 1657 | |
---|
| 1658 | /** |
---|
| 1659 | * A slightly simpler version of write_resource which will make more sense for calling from |
---|
| 1660 | * an external program. This makes assumptions that the collection and user do exist |
---|
| 1661 | * and bypasses all checks for whether it is reasonable to write this here. |
---|
| 1662 | * @param string $path The path to the resource being written |
---|
| 1663 | * @param string $caldav_data The actual resource to be written |
---|
| 1664 | * @param string $put_action_type INSERT or UPDATE depending on what we are to do |
---|
| 1665 | * @return boolean True for success, false for failure. |
---|
| 1666 | */ |
---|
| 1667 | function simple_write_resource( $path, $caldav_data, $put_action_type, $write_action_log = false ) { |
---|
| 1668 | |
---|
| 1669 | $etag = md5($caldav_data); |
---|
| 1670 | $ic = new iCalComponent( $caldav_data ); |
---|
| 1671 | |
---|
| 1672 | /** |
---|
| 1673 | * We pull the user_no & collection_id out of the collection table, based on the resource path |
---|
| 1674 | */ |
---|
| 1675 | $collection_path = preg_replace( '#/[^/]*$#', '/', $path ); |
---|
| 1676 | $qry = new AwlQuery( 'SELECT user_no, collection_id FROM collection WHERE dav_name = :dav_name ', array( ':dav_name' => $collection_path ) ); |
---|
| 1677 | if ( $qry->Exec('PUT',__LINE__,__FILE__) && $qry->rows() == 1 ) { |
---|
| 1678 | $collection = $qry->Fetch(); |
---|
| 1679 | $user_no = $collection->user_no; |
---|
| 1680 | |
---|
| 1681 | return write_resource( $user_no, $path, $caldav_data, $collection->collection_id, $user_no, $etag, $ic, $put_action_type, false, $write_action_log ); |
---|
| 1682 | } |
---|
| 1683 | return false; |
---|
| 1684 | } |
---|
| 1685 | function dataTParaSegundos($datatz){ |
---|
| 1686 | $HorarioTimeZone = new DateTimeZone(date_default_timezone_get()); |
---|
| 1687 | $HorarioTime = new DateTime("now", $HorarioTimeZone); |
---|
| 1688 | return mktime( substr("$datatz", 9,2),//hora |
---|
| 1689 | substr("$datatz", 11,2),//min |
---|
| 1690 | substr("$datatz", 13,2),//segundos |
---|
| 1691 | substr("$datatz", 4,2),//mes |
---|
| 1692 | substr("$datatz", 6,2),//dia |
---|
| 1693 | substr("$datatz", 0,4));//ano |
---|
| 1694 | } |
---|
| 1695 | |
---|
| 1696 | function dataTzParaSegundos($datatz){ |
---|
| 1697 | $HorarioTimeZone = new DateTimeZone(date_default_timezone_get()); |
---|
| 1698 | $HorarioTime = new DateTime("now", $HorarioTimeZone); |
---|
| 1699 | return mktime( substr("$datatz", 9,2),//hora |
---|
| 1700 | substr("$datatz", 11,2),//min |
---|
| 1701 | substr("$datatz", 13,2),//segundos |
---|
| 1702 | substr("$datatz", 4,2),//mes |
---|
| 1703 | substr("$datatz", 6,2),//dia |
---|
| 1704 | substr("$datatz", 0,4)) + $HorarioTimeZone->getoffset($HorarioTime);//ano |
---|
| 1705 | } |
---|
| 1706 | |
---|
| 1707 | function dataSegundosParaTZ($dataseg){ |
---|
| 1708 | $HorarioTimeZone = new DateTimeZone(date_default_timezone_get()); |
---|
| 1709 | $HorarioTime = new DateTime("now", $HorarioTimeZone); |
---|
| 1710 | $teste = getdate($dataseg - $HorarioTimeZone->getoffset($HorarioTime)); |
---|
| 1711 | return date("Ymd\THis\Z",$teste[0]); |
---|
| 1712 | } |
---|
| 1713 | |
---|
| 1714 | function dataTDiaSeguinteSegundos($datatz , $data_inicio){ |
---|
| 1715 | if ((int)substr("$data_inicio", 9,2) < 5){ |
---|
| 1716 | $ajuste_dia=86400; |
---|
| 1717 | } |
---|
| 1718 | elseif((int)substr("$data_inicio", 9,2) > 16){ |
---|
| 1719 | $ajuste_dia=-86400; |
---|
| 1720 | } |
---|
| 1721 | $teste = (int)mktime(0,0,0, |
---|
| 1722 | substr("$datatz", 4,2),//mes |
---|
| 1723 | substr("$datatz", 6,2), |
---|
| 1724 | substr("$datatz", 0,4)) + $ajuste_dia;//ano |
---|
| 1725 | return $teste; |
---|
| 1726 | |
---|
| 1727 | } |
---|
| 1728 | |
---|