Context Navigation

source: trunk/prototype/modules/calendar/interceptors/DBMapping.php @ 5636

Revision 5636, 39.4 KB checked in by acoutinho, 12 years ago (diff)
Ticket #2434 - Implementacao da funcionalidade de mapa de disponibilidade

Line
1	<?php
2	//Definindo Constantes
3	require_once ROOTPATH.'/modules/calendar/constants.php';
4
5	require_once ROOTPATH.'/modules/calendar/interceptors/Helpers.php';
6
7	class DBMapping extends Helpers {
8
9	public function encodeCreateSchedulable( &$uri , &$params , &$criteria , $original ){
10	$params['type_id'] = EVENT_ID;
11
12
13	if(!is_numeric($params['startTime']) )
14	$params['startTime'] = strtotime( $params['startTime'] . ' ' .$params['timezone']).'000';
15
16	if (!is_numeric($params['endTime'])){
17	$params['endTime'] = strtotime( $params['endTime'] . ' ' .$params['timezone']).'000';
18
19	if($params['allDay'])
20	$params['endTime'] = $params['endTime'] + 86400000;
21	}
22	// if( !isset( $new['repeat'] ))
23	// $new['range_end'] = '7287926400'; // 12/12/2200
24	// else
25	$params['rangeEnd'] = $params['endTime'];
26	$params['rangeStart'] = $params['startTime'];
27
28	///////////////////////////////////////////////////////////////////
29
30	$params['dtstamp'] = (isset($params['dtstamp'])) ? $params['dtstamp'] :time().'000';
31	$params['lastUpdate'] = (isset($params['lastUpdate'])) ? $params['lastUpdate'] :time().'000';
32	$params['type'] = EVENT_ID;
33	$params['uid'] = isset($params['uid']) ? $params['uid'] : $this->_makeUid();
34
35	}
36
37	public function encodeCreateAlarm( &$uri , &$params , &$criteria , $original ){
38
39	if(!isset($params['schedulable']) \|\| !isset($params['rangeStart']) \|\| !isset($params['rangeEnd']) )
40	{
41	$participant = Controller::read( array( 'concept' => 'participant' , 'id' => $params['participant'] ) , array('schedulable') );
42	$schedulable = Controller::read( array( 'concept' => 'schedulable' , 'id' => $participant['schedulable'] ) , array('startTime' , 'endTime' ) );
43
44	$params['schedulable'] = $participant['schedulable'];
45	$params['rangeStart'] = gmdate( 'd-m-Y' , strtotime('- '.$params['time'].' '.self::codeAlarmUnit($params['unit']) , (int)($schedulable['startTime'] / 1000)));
46	$params['rangeEnd'] = gmdate( 'd-m-Y' ,(int)($schedulable['endTime'] / 1000));
47	}
48
49	$params['type'] = self::codeAlarmType($params['type']);
50
51	}
52
53	public function encodeCreateSuggestion( &$uri , &$params , &$criteria , $original ){
54	$params['dtstamp'] = (isset($params['dtstamp'])) ? $params['dtstamp'] :time().'000';
55	}
56
57	public function encodeUpdateAlarm( &$uri , &$params , &$criteria , $original ){
58	if(isset($params['type']))
59	$params['type'] = self::codeAlarmType($params['type']);
60	}
61
62	public function encodeCreateAttachment( &$uri , &$params , &$criteria , $original ){
63
64	if(!isset($params['source'])) return false;
65
66	if(isset($_FILES[$params['source']]))
67	if(isset($params['id']))
68	$params = array_merge($_FILES[$params['source']], array('id' => $params['id']));
69	else
70	$params = $_FILES[$params['source']];
71
72	if(isset($params['owner']))
73	$params['owner'] = Config::me('uidNumber');
74
75	}
76
77	///////////////////////////////////////////////////////////////////////////////////////////////////////////////
78
79	public function encodeSignatureAlarmType( &$uri , &$params , &$criteria , $original ){
80	$params['type'] = self::codeAlarmType($params['type']);
81	}
82
83
84	public function insertOwnerLink (&$uri , &$params , &$criteria , $original ){
85	$params['owner'] = Config::me('uidNumber');
86	}
87
88	public function encodeServiceUser (&$uri , &$params , &$criteria , $original ){
89	if(isset($params['isExternal']) && $params['isExternal'] == '1')
90	$uri['service'] = 'PostgreSQL';
91	}
92
93	public function findSchedulable( &$uri , &$params , &$criteria , $original )
94	{
95	if(isset($criteria['filter'][3][1]) && $criteria['filter'][3][1] == 'calendar')
96	{
97	$select = 'calendar_object.id as id ,calendar_object.cal_uid as "uid" , calendar_object.type_id as "type", calendar_object.dtstart as "startTime", calendar_object.summary as "summary", calendar_object.description as "description", calendar_object.dtend as "endTime" , calendar_object.location as "location", calendar_object.allday as "allDay", calendar_object.transp as "transparent", calendar_object.class_id as "class", calendar_object.repeat as "repeat", calendar_object.range_start as "rangeStart",calendar_object.range_end as "rangeEnd", calendar_object.last_update as "lastUpdate", calendar_object.dtstamp as "dtstamp", calendar_object.sequence as "sequence", calendar_object.tzid as "timezone" ,calendar_to_calendar_object.calendar_id as calendar';
98	$sql = " SELECT $select FROM calendar_to_calendar_object , calendar_object WHERE (range_start >= '".$criteria['filter'][1][2]."' AND range_end <= '".$criteria['filter'][2][2]."' AND calendar_to_calendar_object.calendar_id IN ('". implode('\',\'', $criteria['filter'][3][2])."')) AND calendar_to_calendar_object.calendar_object_id = calendar_object.id";
99	$params = Controller::service('PostgreSQL')->execResultSql($sql);
100	$params = self::deepnessFindEvent( &$uri , &$params , &$criteria , $original);
101	return false;
102	}
103	}
104
105	///////////////////////////////////////////////////////////////////////////////////////////////////////////////
106
107	public function updateCalendar( &$uri , &$params , &$criteria , $original ){
108	if( isset($params['calendar']))
109	{
110	$calendarObjects = self::schedulable2calendarToObject( $uri['id'] );
111	$params2['calendar'] = $params['calendar'];
112
113	foreach ($calendarObjects as $calendarObject)
114	Controller::update( array('concept' => 'calendarToSchedulable' , 'id' => $calendarObject['calendar_to_calendar_object']) , $params2 );
115
116	unset( $params['calendar'] );
117
118	if(count($params) < 1) return false;
119	}
120	}
121
122	//Encode Update
123
124	public function encodeUpdateSchedulable( &$uri , &$params , &$criteria , $original ){
125
126	$event = Controller::find( array( 'concept' => 'schedulable' , array('timezone') ,'id' => $params['id'] ) );
127
128	if(isset($params['startTime'])){
129
130	if(!is_numeric($params['startTime']) )
131	$params['startTime'] = strtotime( $params['startTime'] . ' ' .$event['timezone']).'000';
132	else
133	$params['rangeStart'] = $params['startTime'] ;
134
135	}if(isset($params['endTime'])){
136
137	if (!is_numeric($params['endTime']))
138	$params['endTime'] = strtotime( $params['endTime'] . ' ' .$event['timezone']).'000';
139	else
140	$params['rangeEnd'] = $params['endTime'] ;
141
142	}
143	}
144
145	static function putEvent(&$uri , &$result , &$criteria , $original)
146	{
147	if(Config::module('useCaldav')) //Ignorar Put dos eventos ja vindos do caldav
148	{
149	require_once ROOTPATH.'/modules/calendar/interceptors/DAViCalAdapter.php';
150
151	$eventID = (isset($result['id'])) ? $result['id'] : $uri['id'];
152	$event = Controller::read( array( 'concept' => 'schedulable' , 'id' => $eventID ) );
153
154	$participants = Controller::find( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('=' , 'schedulable' , $eventID) ));
155
156	if(is_array($participants) && count($participants) > 0)
157	foreach ($participants as $ii => $vv)
158	{
159	if($vv['isExternal'] == 1 )
160	$participants[$ii]['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $vv['user'] , 'service' => 'PostgreSQL' ) );
161	else
162	$participants[$ii]['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $vv['user'] ));
163	}
164
165	$event['URI']['concept'] = 'schedulable';
166	$event['participants'] = $participants;
167
168	$ical = Controller::format( array( 'service' => 'iCal' ) , array($event) );
169	$calendars = self::schedulable2calendarToObject($original['properties']['id']); //Busca os calendarios do usuario logado que contenham o evento
170	if( is_array($calendars) )
171	foreach ($calendars as $calendar)
172	DAViCalAdapter::putIcal($ical , array('uid' => $event['uid'] , 'collection' => $calendar['calendar_location'] ));
173	}
174	}
175	///////////////////////////////////////////////////////////////////////////////////////////////////////////////
176
177	public function verifyCalendarLocation( &$uri , &$params , &$criteria , $original ){
178	if(!isset($params['location']))
179	$params['location'] = $params['name'];
180	}
181
182
183	//TODO: Remover apos suporte a ManytoMany na api
184	public function createCalendarToSchedulable( &$uri , &$result , &$criteria , $original ){
185
186	Controller::create(array('concept' => 'calendarToSchedulable'), array('calendar' => $original['properties']['calendar'], 'schedulable' => $result['id'] ));
187
188	}
189
190	public function createCreateSchedulableToAttachment( &$uri , &$params , &$criteria , $original ){
191	if(array_key_exists('attachments', $original['properties']))
192	foreach($original['properties']['attachments'] as $key => $value){
193	if(isset($params['id']))
194	Controller::create(array('concept' => 'schedulableToAttachment'), array('attachment' => $value['attachment'], 'schedulable' => $params['id'] ));
195	}
196	}
197
198	public function deepnessFindCalendarShared( &$uri , &$result , &$criteria , $original ){
199	if(isset($original['criteria']['deepness']) && count($result) > 0){
200	$calendarIds = array();
201	foreach($result as $key => $value)
202	array_push($calendarIds, $value['calendar']);
203
204	$calendar = Controller::find( array( 'concept' => 'calendar' ) , false ,array( 'filter' => array('AND', array('IN','id', $calendarIds), $original['criteria']['filter'])));
205
206	if(!is_array($calendar))
207	$result = '';
208
209	$newResult = array();
210	foreach($calendar as $key => $value){
211	foreach($result as $k => $r){
212
213	if($r['calendar'] == $value['id']){
214	$r['calendar'] = $value;
215	array_push($newResult, $r);
216	}
217	}
218	}
219
220	foreach($newResult as $key => &$value){
221	if($value['user'] != 0)
222	$value['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $value['user'] ));
223	}
224
225
226	$result = $newResult;
227	}
228	}
229
230	//TODO: Remover apos suporte a deepness na api
231	public function deepnessFindEvent( &$uri , &$result , &$criteria , $original ){
232
233	if(isset($original['criteria']['deepness']))
234	{
235
236	$Time = new DateTime( 'now', new DateTimeZone('UTC') );
237	$DayLigth = array();
238	foreach ($result as $i => $v)
239	{
240
241	if(!isset($currentTimezone) \|\| $currentTimezone != $original['criteria']['timezones'][$v['calendar']]){
242	$currentTimezone = $original['criteria']['timezones'][$v['calendar']];
243	$Time->setTimezone(new DateTimeZone($currentTimezone));
244	}
245
246	$Time->setTimestamp( (int)($v['startTime'] / 1000));
247	$DayLigth['calendar']['startTime'] = $Time->format('I') ? 1 : 0;
248
249	$Time->setTimestamp( (int)($v['endTime'] / 1000));
250	$DayLigth['calendar']['endTime'] = $Time->format('I') ? 1 : 0;
251
252	if($currentTimezone != $v['timezone']){
253	$currentTimezone = $v['timezone'];
254	$Time->setTimezone(new DateTimeZone($v['timezone']));
255
256	$Time->setTimestamp( (int)($v['startTime'] / 1000));
257	$DayLigth['event']['startTime'] = $Time->format('I') ? 1 : 0;
258
259	$Time->setTimestamp( (int)($v['endTime'] / 1000));
260	$DayLigth['event']['endTime'] = $Time->format('I') ? 1 : 0;
261	}else
262	$DayLigth['event'] = $DayLigth['calendar'];
263
264
265	$result[$i]['DayLigth'] = $DayLigth;
266
267	if(isset($v['id']))
268	{
269	$participants = Controller::find( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('=', 'schedulable' , $v['id']) ));
270
271	if(is_array($participants) && count($participants) > 0)
272	foreach ($participants as $ii => $vv)
273	{
274	if($vv['isExternal'] == 1 )
275	$participants[$ii]['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $vv['user'] , 'service' => 'PostgreSQL' ) );
276	else
277	$participants[$ii]['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $vv['user'] ));
278
279	if($participants[$ii]['user']['id'] == Config::me('uidNumber'))
280	$participants[$ii]['alarms'] = Controller::find( array( 'concept' => 'alarm' ) , null , array('filter' => array('AND' , array('=', 'participant' ,$vv['id'] ) ,array('=' , 'schedulable', $v['id'])) ) );
281	}
282	$result[$i]['participants'] = $participants;
283
284
285
286	$attachmentRelation = Controller::find( array( 'concept' => 'schedulableToAttachment' ) , false ,array( 'filter' => array('=', 'schedulable' , $v['id']) ));
287	if(is_array($attachmentRelation)){
288	$attachments = array();
289	foreach($attachmentRelation as $key => $value)
290	if(isset($value['attachment']) \|\| !!$value['attachment'])
291	$attachments[$key] = $value['attachment'];
292	//Pega os anexos sem source
293	$result[$i]['attachments'] = Controller::find( array( 'concept' => 'attachment' ) , array('id', 'name', 'type', 'size') ,array( 'filter' => array('IN', 'id' , $attachments) ));
294	}
295
296	}
297
298	}
299	}
300
301	return $result;
302
303	}
304
305	//TODO: Remover apos suporte a deepness na api
306	public function deepnessReadEvent( &$uri , &$result , &$criteria , $original ){
307
308	if(isset($original['criteria']['deepness']))
309	{
310	if(isset($result['id']))
311	{
312	$participants = Controller::find( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('=' , 'schedulable' , $result['id']) ));
313	if(is_array($participants))
314	foreach ($participants as $ii => $vv)
315	{
316	if($vv['isExternal'] == 1 )
317	$participants[$ii]['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $vv['user'] , 'service' => 'PostgreSQL' ) );
318	else
319	$participants[$ii]['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $vv['user'] ));
320
321	if($participants[$ii]['user']['id'] == Config::me('uidNumber'))
322	$participants[$ii]['alarms'] = Controller::find( array( 'concept' => 'alarm' ) , null , array('filter' => array('AND' , array('=', 'participant' ,$vv['id'] ) ,array('=' , 'schedulable', $result['id'])) ) );
323	}
324
325	$result['participants'] = $participants;
326	}
327	}
328	}
329
330	//TODO: Remover apos suporte a deepness na api
331	public function deepnessReadParticipant( &$uri , &$result , &$criteria , $original ){
332
333	if(isset($original['criteria']['deepness']))
334	{
335	if(isset($result['id']))
336	{
337	if($result['isExternal'] == 1 )
338	$result['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $result['user'] , 'service' => 'PostgreSQL' ) );
339	else
340	$result['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $result['user'] ));
341	}
342	}
343
344	}
345
346	//TODO: Remover apos suporte a deepness na api
347	public function deepnessFindParticipant( &$uri , &$result , &$criteria , $original ){
348
349	if(isset($original['criteria']['deepness']))
350	{
351	foreach ($result as $i => $v)
352	{
353	if(isset($v['id']))
354	{
355	if($result[$i]['isExternal'] == 1 )
356	$result[$i]['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $result[$i]['user'] , 'service' => 'PostgreSQL' ) );
357	else
358	$result[$i]['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $result[$i]['user'] ));
359	}
360	}
361	}
362
363	}
364
365	//TODO: Remover apos suporte a deepness na api
366	public function deepnessReadCalendarSignature( &$uri , &$result , &$criteria , $original ){
367
368	if(isset($original['criteria']['deepness']))
369	if(isset($result['calendar'])){
370	$result['calendar'] = Controller::read( array( 'concept' => 'calendar' , 'id' => $result['calendar']));
371	$result['defaultAlarms'] = Controller::find( array( 'concept' => 'calendarSignatureAlarm' ) , false ,array( 'filter' => array('=', 'calendarSignature' , $result['id']) ));
372	}
373
374	}
375
376	//TODO: Remover apos suporte a deepness na api
377	public function deepnessFindCalendarSignature( &$uri , &$result , &$criteria , $original ){
378
379	if(isset($original['criteria']['deepness']))
380	{
381	foreach ($result as $i => $v)
382	{
383	if(isset($v['calendar'])){
384	$result[$i]['calendar'] = Controller::read( array( 'concept' => 'calendar' , 'id' => $v['calendar']));
385	$result[$i]['defaultAlarms'] = Controller::find( array( 'concept' => 'calendarSignatureAlarm' ) , false ,array( 'filter' => array('=', 'calendarSignature' , $v['id']) ));
386	//Caso não seja o dono da agenda retorna o objeto permission com as acls
387	if($result[$i]['isOwner'] == 0){
388	$permission = Controller::find( array( 'concept' => 'calendarToPermission'), false ,array( 'filter' => array('AND', array('=', 'calendar' , $v['calendar']), array('=', 'user', Config::me('uidNumber') ) ) ) );
389
390
391
392
393	if(!is_array($permission) \|\| !$permission ){
394	ob_start();
395	var_dump($permission);
396
397	$output = ob_get_clean();
398	file_put_contents( "/tmp/acoutinho.log", $output , FILE_APPEND);
399	$permission = Controller::find( array( 'concept' => 'calendarToPermission'), false ,array( 'filter' => array('AND', array('=', 'calendar' , $v['calendar']), array('=', 'type', '1' ) ) ) );
400
401	ob_start();
402	var_dump($permission);
403
404	$output = ob_get_clean();
405	file_put_contents( "/tmp/acoutinho.log", $output , FILE_APPEND);
406
407	}
408	$result[$i]['permission'] = $permission[0];
409	}
410	}
411	}
412	}
413
414	}
415	//Decode Find
416	public function decodeFindConcept( &$uri , &$result , &$criteria , $original ){
417	if($result && is_array($result) )
418	{
419	$m = array_flip(self::${$uri['concept'].'Map'});
420	$new = array();
421	foreach ($result as $i => $v)
422	$new[$i] = self::parseConcept( $result[$i] , $m );
423
424
425	$result = $new;
426	}
427	}
428
429	public function decodeFindSchedulable( &$uri , &$result , &$criteria , $original ){
430	if($result && is_array($result) )
431	{
432	$m = array_flip(self::${$uri['concept'].'Map'});
433	$m['calendar_id'] = 'calendar';
434	$new = array();
435	foreach ($result as $i => $v)
436	$new[$i] = self::parseConcept( $result[$i] , $m );
437
438
439	$result = $new;
440	}
441	}
442
443	public function decodeFindAttachment( &$uri , &$result , &$criteria , $original ){
444	if(isset($result))
445	foreach($result as $key => &$value)
446	$value['source'] = base64_decode($value['source']);
447	}
448
449
450	public function decodeSignatureAlarmType( &$uri , &$result , &$criteria , $original ){
451	if( is_array($result) )
452	foreach($result as &$param)
453	if(isset($param['type']))
454	$param['type'] = self::decodeAlarmType($param['type']);
455
456	}
457
458	/////////////////////////////////////////////////////////////////////////
459
460	static function dayAlarm( &$uri , &$params , &$criteria , $original ) {
461	if(isset($criteria['filter'][1]) && $criteria['filter'][1] == 'date')
462	{
463	$filter = array( 'AND',
464	array( '=' , 'sent' , '0') ,
465	array( '=' , 'type' , ALARM_ALERT) ,
466	array( '>=' , 'rangeStart' , $criteria['filter'][2]) ,
467	array( '<=' , 'rangeEnd' , $criteria['filter'][2]) );
468
469	//Busca os Alarmes no Range
470	$al = Controller::find( array('concept' => 'alarm'), false ,array( 'filter' => $filter));
471
472	if(is_array($al))
473	foreach ($al as $i => $v)
474	{
475	$ev = Controller::read( array( 'concept' => 'schedulable' , 'id' => $v['schedulable']) ) ;
476
477	$unit = 0;
478	switch (strtolower($v['unit'])) {
479	case 'm': $unit = 60; break;
480	case 'H': $unit = 3600; break;
481	case 'd': $unit = 216000; break; }
482
483	$al[$i]['sendTime'] = (((int)( $ev['startTime'] / 1000 )) - ( $v['time'] * $unit ));
484	$al[$i]['schedulable'] = $ev;
485
486	}
487
488	$params = $al;
489	return false;
490	}
491	}
492
493	public function deleteSchedulable( &$uri , &$params , &$criteria , $original ){
494
495	if(Config::module('useCaldav'))
496	require_once ROOTPATH.'/modules/calendar/interceptors/DAViCalAdapter.php';
497
498	$calendarsToSchedulable = self::schedulable2calendarToObject($uri['id']);
499	if( !self::ownerSchedulable($uri['id']) )
500	{
501	foreach ($calendarsToSchedulable as $i => $v)
502	{
503	Controller::delete(array('concept' => 'calendarToSchedulable' , 'id' => $v['calendar_to_calendar_object']));
504
505	if(Config::module('useCaldav'))
506	DAViCalAdapter::deleteEvent($uri['id'], array('calendar' => $v['calendar_name']));
507	}
508
509	/* Seta o participante como rejeitado */
510	Controller::update(array('concept' => 'participant'), array('status' => STATUS_CANCELLED) ,
511	array('filter' =>
512	array('AND',
513	array('=' , 'user' ,Config::me('uidNumber') ),
514	array('=' , 'schedulable' , $uri['id'] )
515	)));
516
517	return false; /* Mata o restante da execução */
518	}
519
520	if(Config::module('useCaldav'))
521	foreach ($calendarsToSchedulable as $i => $v)
522	DAViCalAdapter::deleteEvent($uri['id'], array('calendar' => $v['calendar_name']));
523
524	}
525
526	public function deleteCalendarSignatureDependences( &$uri , &$params , &$criteria , $original ){
527	$signature = Controller::read($uri,array('isOwner','calendar'));
528
529	if($signature['isOwner'] == '1')
530	{
531	$calendarToSchedulables = Controller::find(array('concept' => 'calendarToSchedulable') , null , array('filter' => array('=' , 'calendar' , $signature['calendar'] )));
532
533	$schedulables = array();
534	if(is_array($calendarToSchedulables))
535	foreach ($calendarToSchedulables as $key => $calendarToSchedulable)
536	$schedulables[] = $calendarToSchedulable['schedulable'] ;
537
538	if( !empty( $schedulables ) )
539	Controller::deleteALL(array('concept' => 'schedulable'),null , array('filter' => array('IN' , 'id' , $schedulables)));
540
541	Controller::delete(array('concept' => 'calendar', 'id' => $signature['calendar']));
542	}
543
544	}
545
546	public function deleteAttachmentDependences( &$uri , &$params , &$criteria , $original ){
547
548	if(isset($original['URI']['id']))
549	Controller::delete(array('concept' => 'schedulableToAttachment', null , array('filter' => array('=' , 'attachment' , $original['URI']['id']))));
550	}
551
552	public function createDefaultSignature( &$uri , &$result , &$criteria , $original ){
553
554	//Caso uma busca não retorne nenhum resultado e foi buscado pelas assinaturas do usuario logado apenas
555	if(count($result) <= 0 &&
556	( $original['criteria']['filter'][0] == '=' &&
557	$original['criteria']['filter'][1] == 'user' &&
558	$original['criteria']['filter'][2] == $_SESSION['phpgw_session']['account_id']
559	))
560	{
561
562	if( Config::module('useCaldav') )
563	{
564	require_once ROOTPATH.'/modules/calendar/interceptors/DAViCalAdapter.php';
565
566	$calendario = DAViCalAdapter::findCalendars();
567	}
568
569	if( Config::module('useCaldav') && is_array($calendario) && count($calendario) > 0)
570	{
571	foreach ($calendario as $i => $v)
572	{
573
574	$urlA = explode('/', $v->url);
575	$name = isset($v->displayname)? $v->displayname : $urlA[ (count($urlA)-2) ];
576	$cal = array('name' => $name,
577	'description' => isset($v->description)? $v->description : $name,
578	'timezone' => isset($v->timezone) ? $v->timezone : (date_default_timezone_get()) ? date_default_timezone_get() : 'America/Sao_Paulo',
579	'dtstamp' => time().'000',
580	'location' => $urlA[ (count($urlA)-2) ]
581	);
582
583	$calCreated = Controller::create( array('concept' => 'calendar') , $cal );
584
585
586
587	$sig = array( 'user' => $_SESSION['wallet']['user']['uidNumber'],
588	'calendar' => $calCreated['id'],
589	'isOwner' => '1',
590	'dtstamp' => time().'000',
591	'fontColor' => 'FFFFFF',
592	'backgroundColor' => '3366CC',
593	'borderColor' => '3366CC',
594	);
595
596	$sigCreated = Controller::create( array('concept' => 'calendarSignature') , $sig );
597
598
599	DAViCalAdapter::importCollection($v->url , $calCreated['id']);
600
601	}
602	}
603	else
604	{
605	//Criaremos uma agenda parão
606	$cal = array('name' => 'Calendario',
607	'description' => 'Calendario Padrão',
608	'timezone' => (date_default_timezone_get()) ? date_default_timezone_get() : 'America/Sao_Paulo',
609	'dtstamp' => time().'000'
610	);
611
612	$calCreated = Controller::create( array('concept' => 'calendar') , $cal );
613
614	$sig = array( 'user' => $_SESSION['wallet']['user']['uidNumber'],
615	'calendar' => $calCreated['id'],
616	'isOwner' => '1',
617	'dtstamp' => time().'000',
618	'fontColor' => 'FFFFFF',
619	'backgroundColor' => '3366CC',
620	'borderColor' => '3366CC',
621	);
622
623	$sigCreated = Controller::create( array('concept' => 'calendarSignature') , $sig );
624	}
625
626	$result = Controller::find($original['URI'] , $original['properties'] ? $original['properties'] : null , $original['criteria'] );
627	return false;
628	}
629
630	}
631
632	public function findExternalPaticipants( &$uri , &$result , &$criteria , $original ) {
633	if(Config::me('uidNumber'))
634	{
635	$newuri['concept'] = 'user';
636	$newuri['service'] = 'PostgreSQL';
637
638	$newCriteria = $original['criteria'];
639	$valid = true;
640
641	$newCriteria['filter'] = array('AND',$newCriteria['filter'] , array('=' , 'owner', Config::me('uidNumber')) );
642	$externalUsers = Controller::find( $newuri , $original['properties'] ? $original['properties'] : null , $newCriteria );
643
644	if(is_array($externalUsers))
645	{
646	foreach ($externalUsers as $i => $v)
647	$externalUsers[$i]['isExternal'] = '1';
648	}
649	else
650	$externalUsers = array();
651
652	if(!is_array($result))
653	$result = array();
654
655	return array_merge($result, $externalUsers);
656	}
657
658	}
659
660	public function createSchedulableMails( &$uri , &$result , &$criteria , $original ){
661
662	require_once (ROOTPATH.'/plugins/icalcreator/iCalcreator.class.php' );
663	require_once (ROOTPATH.'/api/parseTPL.php' );
664	$schedulable = Controller::read( array( 'concept' => 'schedulable' , 'id' => $result['id'] ));
665	$participants = Controller::find( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('=', 'schedulable' , $result['id']) )) ;
666
667
668	if(is_array($participants) && count($participants) > 0) //Caso exista participants
669	{
670	$att = array();
671	$attList = '<UL> ';
672	$organizer = array();
673	foreach ($participants as $i => $v)
674	{
675	if($part['isExternal'] == 1)
676	$att[$i] = Controller::read( array( 'concept' => 'user' , 'id' => $v['user'] , 'service' => 'PostgreSQL' ) );
677	else
678	$att[$i] = Controller::read( array( 'concept' => 'user' , 'id' => $v['user'] ));
679
680	$attList .= '<LI> '.$att[$i]['name'] .'</LI> ';
681
682	if( isset($v['isOrganizer']) && $v['isOrganizer'] == 1)
683	$organizer = $att[$i];
684
685	}
686	$attList .= '</UL>';
687
688	foreach ($participants as $i => $v)
689	{
690
691	if($v === $organizer) //Organizador ?
692	continue;
693
694	//Criação do ical
695	$ical = null;
696	$ical = new vcalendar();
697	$ical->setProperty( 'method' , 'REQUEST' );
698	$vschedulable = &$ical->newComponent( 'vschedulable' );
699	$vschedulable->setProperty( 'uid' , $schedulable['uid'] );
700	$vschedulable->setProperty( 'dtstart', gmdate( DATE_RFC822 , (int)($schedulable['startTime'] / 1000)));
701	$vschedulable->setProperty( 'dtend', gmdate( DATE_RFC822 , (int)($schedulable['endTime'] / 1000)));
702	$vschedulable->setProperty( 'summary',( $schedulable['summary'] ));
703	$vschedulable->setProperty( 'description', $schedulable['description']);
704	$vschedulable->setProperty( 'location', $schedulable['location']);
705	$params = array();
706	$params['CN'] = $att[$i]['name'];
707	$params['RSVP'] = 'TRUE';
708	$params['ROLE'] = 'REQ-PARTICIPANT';
709	if(isset($att[$i]['mail']))
710	$vschedulable->setProperty( 'attendee', $att[$i]['mail'] , $params);
711
712	$vschedulable->setProperty( 'organizer', $organizer['mail'] , array('CN' => $organizer['name']) );
713	///////////////////////////////////////////////////////////////////////////
714
715	//Criação do E-mail
716	$mail = array();
717	$mail['isHtml'] = true;
718
719	$timzone = new DateTimeZone('UTC');
720	$sTime = new DateTime( '@'.(int)($schedulable['startTime'] / 1000) , $timzone );
721	$eTime = new DateTime( '@'.(int)($schedulable['endTime'] / 1000) , $timzone );
722
723	$mail['body'] = parseTPL::load_tpl(array( 'startDate' => date_format( $sTime , 'd/m/Y') ,
724	'startTime' => date_format( $sTime , 'H:i') ,
725	'endDate' => date_format( $eTime , 'd/m/Y') ,
726	'endTime' => date_format( $eTime , 'H:i') ,
727	'schedulableTitle' => $schedulable['summary'],
728	'schedulableLocation' => $schedulable['location'],
729	'participants' => $attList
730	),ROOTPATH.'/api/templates/notify_create_body.tpl');
731
732	//TODO: Internacionalização do Subject
733	$mail['subject'] = 'Schedulableo do Calendário : '.$schedulable['summary'] .' @ '.date_format( $sTime , 'd/m/Y H:i') . ' - ' . date_format( $eTime , 'd/m/Y H:i');
734	$mail['from'] = $organizer['mail'];
735	$mail['to'] = $att[$i]['mail'];
736	$mail['attachments'][] = array('source' => $ical->createCalendar(), 'type' => 'text/calendar' ,'disposition' => 'inline' ,'name' => 'external.ics');
737	$result['participants'][$i]['sendInvite'] = Controller::create( array( 'service' => 'SMTP' ), $mail );
738
739	}
740	}
741	}
742
743	public function davcalCreateCollection( &$uri , &$params , &$criteria , $original ){
744	if( Config::module('useCaldav') )
745	{
746	require_once ROOTPATH.'/modules/calendar/interceptors/DAViCalAdapter.php';
747	DAViCalAdapter::mkcalendar($params['location'] , $params['name'], isset($params['description']) ? $params['description'] : '' );
748	}
749	}
750
751	public function davcalDeleteCollection( &$uri , &$params , &$criteria , $original ){
752	if( Config::module('useCaldav') && Config::module('onRemoveCascadeCalDav'))
753	{
754	require_once ROOTPATH.'/modules/calendar/interceptors/DAViCalAdapter.php';
755	$calendar = Controller::read($uri);
756	DAViCalAdapter::rmCalendar($calendar['location']);
757	}
758	}
759
760	public function davcalUpdateCollection( &$uri , &$params , &$criteria , $original ){
761	if( Config::module('useCaldav') )
762	{
763	require_once ROOTPATH.'/modules/calendar/interceptors/DAViCalAdapter.php';
764	if(isset($params['location']))
765	{
766	$calendar = Controller::read($uri);
767	if($calendar['location'] !== $params['location'])
768	DAViCalAdapter::mvcalendar($calendar['location'], $params['location']);
769	}
770	}
771	}
772
773	//HELPERS
774	private static function decodeRepeat( $repeat , $start , $end ) {
775	require_once ROOTPATH.'/plugins/when/When.php';
776
777	$r = new When();
778	$r->recur( new DateTime( '@'.$start , new DateTimeZone('UTC') ), $repeat['frequency'] );
779
780	foreach($repeat as $rule => $value)
781	{
782	switch(strtoupper($rule))
783	{
784	case "ENDTIME":
785	$r->until( new DateTime( '@'.$value ) );
786	break;
787	case "COUNT":
788	$r->count( $value );
789	break;
790	case "INTERVAL":
791	$r->interval( $value );
792	break;
793	case "BYDAY":
794	if( !is_array( $value ) )
795	$value = explode( ',' , $value );
796	$r->byday( $value );
797	break;
798	case "BYMONTHDAY":
799	if( !is_array( $value ) )
800	$value = explode(',' , $value );
801	$r->bymonthday($value);
802	break;
803	case "BYYEARDAY":
804	if( !is_array( $value ) )
805	$value = explode(',', $value );
806	$r->byyearday( $value );
807	break;
808	case "BYWEEKNO":
809	if(!is_array( $value ))
810	$value = explode( ',', $value );
811	$r->byweekno( $value );
812	break;
813	case "BYMONTH":
814	if( !is_array( $value ) )
815	$value = explode( ',', $value );
816	$r->bymonth( $value );
817	break;
818	case "BYSETPOS":
819	if( !is_array( $value ) )
820	$value = explode( ',' , $value );
821	$r->bysetpos( $value );
822	break;
823	case "WKST":
824	$r->wkst( $value );
825	break;
826	}
827	}
828
829	$return = array();
830
831	while($result = $r->next())
832	{
833	$u = $result->format('U');
834	if( $u > $end ) //data da repetição atual maior que a data final da busca do usuario ?
835	break;
836
837	$return[] = $u;
838	}
839
840	return $return;
841	}
842	private function _makeUid() {
843
844	$date = date('Ymd\THisT');
845	$unique = substr(microtime(), 2, 4);
846	$base = 'aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPrRsStTuUvVxXuUvVwWzZ1234567890';
847	$start = 0;
848	$end = strlen( $base ) - 1;
849	$length = 6;
850	$str = null;
851	for( $p = 0; $p < $length; $p++ )
852	$unique .= $base{mt_rand( $start, $end )};
853
854	return $date.$unique.'@expresso-calendar';
855	}
856	private function getStatus( $id ){
857	$a = array(
858	STATUS_CONFIRMED => 'CONFIRMED',
859	STATUS_CANCELLED => 'CANCELLED',
860	STATUS_TENATIVE => 'TENATIVE',
861	STATUS_UNANSWERED => 'NEEDS-ACTION',
862	STATUS_DELEGATED => 'DELEGATED'
863	);
864	return $a[ $id ];
865	}
866	private static function decodeAlarmType( $id ){
867	$a = array( ALARM_ALERT => 'alert',
868	ALARM_MAIL => 'mail',
869	ALARM_SMS => 'sms' );
870
871	return $a[ $id ];
872	}
873	private static function codeAlarmType( $type ){
874	$a = array( 'alert' => ALARM_ALERT ,
875	'mail' => ALARM_MAIL ,
876	'sms' => ALARM_SMS );
877
878	return $a[ $type ];
879	}
880	private static function codeAlarmUnit( $u ){
881	if($u === 'd') return 'days';
882	if($u === 'm') return 'minutes';
883	if($u === 'H') return 'hours';
884	}
885
886	private static function ownerSchedulable( $id ){
887
888	$isOwner = Controller::find(array('concept' => 'participant'), array('id') ,
889	array('filter' =>
890	array('AND',
891	array('=' , 'isOrganizer' , '1'),
892	array('=' , 'user' ,$_SESSION['wallet']['user']['uidNumber'] ),
893	array('=' , 'schedulable' ,$id )
894	)));
895
896	return ( isset( $isOwner[0]['id'] ) ) ? true : false;
897	}
898
899	private static function schedulable2calendarToObject($Schedulable)
900	{
901	return Controller::service('PostgreSQL')->execResultSql('SELECT calendar_to_calendar_object.id as calendar_to_calendar_Object , calendar.name as calendar_name ,calendar.location as calendar_location FROM calendar_to_calendar_object , calendar , calendar_signature'
902	.' WHERE calendar_signature.user_uidnumber = '.$_SESSION['wallet']['user']['uidNumber']
903	.' AND calendar_signature.is_owner = 1'
904	.' AND calendar_signature.calendar_id = calendar.id'
905	.' AND calendar_to_calendar_object.calendar_id = calendar.id'
906	.' AND calendar_to_calendar_object.calendar_object_id = '.addslashes($Schedulable));
907	}
908
909	}
910
911	?>

Note: See TracBrowser for help on using the repository browser.

Download in other formats: