Context Navigation

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

Revision 5376, 45.1 KB checked in by acoutinho, 12 years ago (diff)
Ticket #2434 - Estabilizacao da nova api, correcoes de bug e melhorias na nova agenda

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

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

Download in other formats: