Context Navigation

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

Revision 5641, 39.1 KB checked in by acoutinho, 12 years ago (diff)
Ticket #2434 - Correcao de bugs e melhorias no modulo expressoCalendar

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
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
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']), false, false);
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	if(!is_array($permission) \|\| !$permission ){
391
392	$permission = Controller::find( array( 'concept' => 'calendarToPermission'), false ,array( 'filter' => array('AND', array('=', 'calendar' , $v['calendar']), array('=', 'type', '1' ) ) ) );
393
394	}
395	$result[$i]['permission'] = $permission[0];
396	}
397	}
398	}
399	}
400	}
401	//Decode Find
402	public function decodeFindConcept( &$uri , &$result , &$criteria , $original ){
403	if($result && is_array($result) )
404	{
405	$m = array_flip(self::${$uri['concept'].'Map'});
406	$new = array();
407	foreach ($result as $i => $v)
408	$new[$i] = self::parseConcept( $result[$i] , $m );
409
410
411	$result = $new;
412	}
413	}
414
415	public function decodeFindSchedulable( &$uri , &$result , &$criteria , $original ){
416	if($result && is_array($result) )
417	{
418	$m = array_flip(self::${$uri['concept'].'Map'});
419	$m['calendar_id'] = 'calendar';
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 decodeFindAttachment( &$uri , &$result , &$criteria , $original ){
430	if(isset($result))
431	foreach($result as $key => &$value)
432	$value['source'] = base64_decode($value['source']);
433	}
434
435
436	public function decodeSignatureAlarmType( &$uri , &$result , &$criteria , $original ){
437	if( is_array($result) )
438	foreach($result as &$param)
439	if(isset($param['type']))
440	$param['type'] = self::decodeAlarmType($param['type']);
441
442	}
443
444	/////////////////////////////////////////////////////////////////////////
445
446	static function dayAlarm( &$uri , &$params , &$criteria , $original ) {
447	if(isset($criteria['filter'][1]) && $criteria['filter'][1] == 'date')
448	{
449	$filter = array( 'AND',
450	array( '=' , 'sent' , '0') ,
451	array( '=' , 'type' , ALARM_ALERT) ,
452	array( '>=' , 'rangeStart' , $criteria['filter'][2]) ,
453	array( '<=' , 'rangeEnd' , $criteria['filter'][2]) );
454
455	//Busca os Alarmes no Range
456	$al = Controller::find( array('concept' => 'alarm'), false ,array( 'filter' => $filter));
457
458	if(is_array($al))
459	foreach ($al as $i => $v)
460	{
461	$ev = Controller::read( array( 'concept' => 'schedulable' , 'id' => $v['schedulable']) ) ;
462
463	$unit = 0;
464	switch (strtolower($v['unit'])) {
465	case 'm': $unit = 60; break;
466	case 'H': $unit = 3600; break;
467	case 'd': $unit = 216000; break; }
468
469	$al[$i]['sendTime'] = (((int)( $ev['startTime'] / 1000 )) - ( $v['time'] * $unit ));
470	$al[$i]['schedulable'] = $ev;
471
472	}
473
474	$params = $al;
475	return false;
476	}
477	}
478
479	public function deleteSchedulable( &$uri , &$params , &$criteria , $original ){
480
481	if(Config::module('useCaldav'))
482	require_once ROOTPATH.'/modules/calendar/interceptors/DAViCalAdapter.php';
483
484	$calendarsToSchedulable = self::schedulable2calendarToObject($uri['id']);
485	if( !self::ownerSchedulable($uri['id']) )
486	{
487	foreach ($calendarsToSchedulable as $i => $v)
488	{
489	Controller::delete(array('concept' => 'calendarToSchedulable' , 'id' => $v['calendar_to_calendar_object']));
490
491	if(Config::module('useCaldav'))
492	DAViCalAdapter::deleteEvent($uri['id'], array('calendar' => $v['calendar_name']));
493	}
494
495	/* Seta o participante como rejeitado */
496	Controller::update(array('concept' => 'participant'), array('status' => STATUS_CANCELLED) ,
497	array('filter' =>
498	array('AND',
499	array('=' , 'user' ,Config::me('uidNumber') ),
500	array('=' , 'schedulable' , $uri['id'] )
501	)));
502
503	return false; /* Mata o restante da execução */
504	}
505
506	if(Config::module('useCaldav'))
507	foreach ($calendarsToSchedulable as $i => $v)
508	DAViCalAdapter::deleteEvent($uri['id'], array('calendar' => $v['calendar_name']));
509
510	}
511
512	public function deleteCalendarSignatureDependences( &$uri , &$params , &$criteria , $original ){
513	$signature = Controller::read($uri,array('isOwner','calendar'));
514
515	if($signature['isOwner'] == '1')
516	{
517	$calendarToSchedulables = Controller::find(array('concept' => 'calendarToSchedulable') , null , array('filter' => array('=' , 'calendar' , $signature['calendar'] )));
518
519	$schedulables = array();
520	if(is_array($calendarToSchedulables))
521	foreach ($calendarToSchedulables as $key => $calendarToSchedulable)
522	$schedulables[] = $calendarToSchedulable['schedulable'] ;
523
524	if( !empty( $schedulables ) )
525	Controller::deleteALL(array('concept' => 'schedulable'),null , array('filter' => array('IN' , 'id' , $schedulables)));
526
527	Controller::delete(array('concept' => 'calendar', 'id' => $signature['calendar']));
528	}
529
530	}
531
532	public function deleteAttachmentDependences( &$uri , &$params , &$criteria , $original ){
533
534	if(isset($original['URI']['id']))
535	Controller::delete(array('concept' => 'schedulableToAttachment', null , array('filter' => array('=' , 'attachment' , $original['URI']['id']))));
536	}
537
538	public function createDefaultSignature( &$uri , &$result , &$criteria , $original ){
539
540	//Caso uma busca não retorne nenhum resultado e foi buscado pelas assinaturas do usuario logado apenas
541	if(count($result) <= 0 &&
542	( $original['criteria']['filter'][0] == '=' &&
543	$original['criteria']['filter'][1] == 'user' &&
544	$original['criteria']['filter'][2] == $_SESSION['phpgw_session']['account_id']
545	))
546	{
547
548	if( Config::module('useCaldav') )
549	{
550	require_once ROOTPATH.'/modules/calendar/interceptors/DAViCalAdapter.php';
551
552	$calendario = DAViCalAdapter::findCalendars();
553	}
554
555	if( Config::module('useCaldav') && is_array($calendario) && count($calendario) > 0)
556	{
557	foreach ($calendario as $i => $v)
558	{
559
560	$urlA = explode('/', $v->url);
561	$name = isset($v->displayname)? $v->displayname : $urlA[ (count($urlA)-2) ];
562	$cal = array('name' => $name,
563	'description' => isset($v->description)? $v->description : $name,
564	'timezone' => isset($v->timezone) ? $v->timezone : (date_default_timezone_get()) ? date_default_timezone_get() : 'America/Sao_Paulo',
565	'dtstamp' => time().'000',
566	'location' => $urlA[ (count($urlA)-2) ]
567	);
568
569	$calCreated = Controller::create( array('concept' => 'calendar') , $cal );
570
571
572
573	$sig = array( 'user' => $_SESSION['wallet']['user']['uidNumber'],
574	'calendar' => $calCreated['id'],
575	'isOwner' => '1',
576	'dtstamp' => time().'000',
577	'fontColor' => 'FFFFFF',
578	'backgroundColor' => '3366CC',
579	'borderColor' => '3366CC',
580	);
581
582	$sigCreated = Controller::create( array('concept' => 'calendarSignature') , $sig );
583
584
585	DAViCalAdapter::importCollection($v->url , $calCreated['id']);
586
587	}
588	}
589	else
590	{
591	//Criaremos uma agenda parão
592	$cal = array('name' => 'Calendario',
593	'description' => 'Calendario Padrão',
594	'timezone' => (date_default_timezone_get()) ? date_default_timezone_get() : 'America/Sao_Paulo',
595	'dtstamp' => time().'000'
596	);
597
598	$calCreated = Controller::create( array('concept' => 'calendar') , $cal );
599
600	$sig = array( 'user' => $_SESSION['wallet']['user']['uidNumber'],
601	'calendar' => $calCreated['id'],
602	'isOwner' => '1',
603	'dtstamp' => time().'000',
604	'fontColor' => 'FFFFFF',
605	'backgroundColor' => '3366CC',
606	'borderColor' => '3366CC',
607	);
608
609	$sigCreated = Controller::create( array('concept' => 'calendarSignature') , $sig );
610	}
611
612	$result = Controller::find($original['URI'] , $original['properties'] ? $original['properties'] : null , $original['criteria'] );
613	return false;
614	}
615
616	}
617
618	public function findExternalPaticipants( &$uri , &$result , &$criteria , $original ) {
619	if(Config::me('uidNumber'))
620	{
621	$newuri['concept'] = 'user';
622	$newuri['service'] = 'PostgreSQL';
623
624	$newCriteria = $original['criteria'];
625	$valid = true;
626
627	$newCriteria['filter'] = array('AND',$newCriteria['filter'] , array('=' , 'owner', Config::me('uidNumber')) );
628	$externalUsers = Controller::find( $newuri , $original['properties'] ? $original['properties'] : null , $newCriteria );
629
630	if(is_array($externalUsers))
631	{
632	foreach ($externalUsers as $i => $v)
633	$externalUsers[$i]['isExternal'] = '1';
634	}
635	else
636	$externalUsers = array();
637
638	if(!is_array($result))
639	$result = array();
640
641	return array_merge($result, $externalUsers);
642	}
643
644	}
645
646	public function createSchedulableMails( &$uri , &$result , &$criteria , $original ){
647
648	require_once (ROOTPATH.'/plugins/icalcreator/iCalcreator.class.php' );
649	require_once (ROOTPATH.'/api/parseTPL.php' );
650	$schedulable = Controller::read( array( 'concept' => 'schedulable' , 'id' => $result['id'] ));
651	$participants = Controller::find( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('=', 'schedulable' , $result['id']) )) ;
652
653
654	if(is_array($participants) && count($participants) > 0) //Caso exista participants
655	{
656	$att = array();
657	$attList = '<UL> ';
658	$organizer = array();
659	foreach ($participants as $i => $v)
660	{
661	if($part['isExternal'] == 1)
662	$att[$i] = Controller::read( array( 'concept' => 'user' , 'id' => $v['user'] , 'service' => 'PostgreSQL' ) );
663	else
664	$att[$i] = Controller::read( array( 'concept' => 'user' , 'id' => $v['user'] ));
665
666	$attList .= '<LI> '.$att[$i]['name'] .'</LI> ';
667
668	if( isset($v['isOrganizer']) && $v['isOrganizer'] == 1)
669	$organizer = $att[$i];
670
671	}
672	$attList .= '</UL>';
673
674	foreach ($participants as $i => $v)
675	{
676
677	if($v === $organizer) //Organizador ?
678	continue;
679
680	//Criação do ical
681	$ical = null;
682	$ical = new vcalendar();
683	$ical->setProperty( 'method' , 'REQUEST' );
684	$vschedulable = &$ical->newComponent( 'vschedulable' );
685	$vschedulable->setProperty( 'uid' , $schedulable['uid'] );
686	$vschedulable->setProperty( 'dtstart', gmdate( DATE_RFC822 , (int)($schedulable['startTime'] / 1000)));
687	$vschedulable->setProperty( 'dtend', gmdate( DATE_RFC822 , (int)($schedulable['endTime'] / 1000)));
688	$vschedulable->setProperty( 'summary',( $schedulable['summary'] ));
689	$vschedulable->setProperty( 'description', $schedulable['description']);
690	$vschedulable->setProperty( 'location', $schedulable['location']);
691	$params = array();
692	$params['CN'] = $att[$i]['name'];
693	$params['RSVP'] = 'TRUE';
694	$params['ROLE'] = 'REQ-PARTICIPANT';
695	if(isset($att[$i]['mail']))
696	$vschedulable->setProperty( 'attendee', $att[$i]['mail'] , $params);
697
698	$vschedulable->setProperty( 'organizer', $organizer['mail'] , array('CN' => $organizer['name']) );
699	///////////////////////////////////////////////////////////////////////////
700
701	//Criação do E-mail
702	$mail = array();
703	$mail['isHtml'] = true;
704
705	$timzone = new DateTimeZone('UTC');
706	$sTime = new DateTime( '@'.(int)($schedulable['startTime'] / 1000) , $timzone );
707	$eTime = new DateTime( '@'.(int)($schedulable['endTime'] / 1000) , $timzone );
708
709	$mail['body'] = parseTPL::load_tpl(array( 'startDate' => date_format( $sTime , 'd/m/Y') ,
710	'startTime' => date_format( $sTime , 'H:i') ,
711	'endDate' => date_format( $eTime , 'd/m/Y') ,
712	'endTime' => date_format( $eTime , 'H:i') ,
713	'schedulableTitle' => $schedulable['summary'],
714	'schedulableLocation' => $schedulable['location'],
715	'participants' => $attList
716	),ROOTPATH.'/api/templates/notify_create_body.tpl');
717
718	//TODO: Internacionalização do Subject
719	$mail['subject'] = 'Schedulableo do Calendário : '.$schedulable['summary'] .' @ '.date_format( $sTime , 'd/m/Y H:i') . ' - ' . date_format( $eTime , 'd/m/Y H:i');
720	$mail['from'] = $organizer['mail'];
721	$mail['to'] = $att[$i]['mail'];
722	$mail['attachments'][] = array('source' => $ical->createCalendar(), 'type' => 'text/calendar' ,'disposition' => 'inline' ,'name' => 'external.ics');
723	$result['participants'][$i]['sendInvite'] = Controller::create( array( 'service' => 'SMTP' ), $mail );
724
725	}
726	}
727	}
728
729	public function davcalCreateCollection( &$uri , &$params , &$criteria , $original ){
730	if( Config::module('useCaldav') )
731	{
732	require_once ROOTPATH.'/modules/calendar/interceptors/DAViCalAdapter.php';
733	DAViCalAdapter::mkcalendar($params['location'] , $params['name'], isset($params['description']) ? $params['description'] : '' );
734	}
735	}
736
737	public function davcalDeleteCollection( &$uri , &$params , &$criteria , $original ){
738	if( Config::module('useCaldav') && Config::module('onRemoveCascadeCalDav'))
739	{
740	require_once ROOTPATH.'/modules/calendar/interceptors/DAViCalAdapter.php';
741	$calendar = Controller::read($uri);
742	DAViCalAdapter::rmCalendar($calendar['location']);
743	}
744	}
745
746	public function davcalUpdateCollection( &$uri , &$params , &$criteria , $original ){
747	if( Config::module('useCaldav') )
748	{
749	require_once ROOTPATH.'/modules/calendar/interceptors/DAViCalAdapter.php';
750	if(isset($params['location']))
751	{
752	$calendar = Controller::read($uri);
753	if($calendar['location'] !== $params['location'])
754	DAViCalAdapter::mvcalendar($calendar['location'], $params['location']);
755	}
756	}
757	}
758
759	//HELPERS
760	private static function decodeRepeat( $repeat , $start , $end ) {
761	require_once ROOTPATH.'/plugins/when/When.php';
762
763	$r = new When();
764	$r->recur( new DateTime( '@'.$start , new DateTimeZone('UTC') ), $repeat['frequency'] );
765
766	foreach($repeat as $rule => $value)
767	{
768	switch(strtoupper($rule))
769	{
770	case "ENDTIME":
771	$r->until( new DateTime( '@'.$value ) );
772	break;
773	case "COUNT":
774	$r->count( $value );
775	break;
776	case "INTERVAL":
777	$r->interval( $value );
778	break;
779	case "BYDAY":
780	if( !is_array( $value ) )
781	$value = explode( ',' , $value );
782	$r->byday( $value );
783	break;
784	case "BYMONTHDAY":
785	if( !is_array( $value ) )
786	$value = explode(',' , $value );
787	$r->bymonthday($value);
788	break;
789	case "BYYEARDAY":
790	if( !is_array( $value ) )
791	$value = explode(',', $value );
792	$r->byyearday( $value );
793	break;
794	case "BYWEEKNO":
795	if(!is_array( $value ))
796	$value = explode( ',', $value );
797	$r->byweekno( $value );
798	break;
799	case "BYMONTH":
800	if( !is_array( $value ) )
801	$value = explode( ',', $value );
802	$r->bymonth( $value );
803	break;
804	case "BYSETPOS":
805	if( !is_array( $value ) )
806	$value = explode( ',' , $value );
807	$r->bysetpos( $value );
808	break;
809	case "WKST":
810	$r->wkst( $value );
811	break;
812	}
813	}
814
815	$return = array();
816
817	while($result = $r->next())
818	{
819	$u = $result->format('U');
820	if( $u > $end ) //data da repetição atual maior que a data final da busca do usuario ?
821	break;
822
823	$return[] = $u;
824	}
825
826	return $return;
827	}
828	private function _makeUid() {
829
830	$date = date('Ymd\THisT');
831	$unique = substr(microtime(), 2, 4);
832	$base = 'aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPrRsStTuUvVxXuUvVwWzZ1234567890';
833	$start = 0;
834	$end = strlen( $base ) - 1;
835	$length = 6;
836	$str = null;
837	for( $p = 0; $p < $length; $p++ )
838	$unique .= $base{mt_rand( $start, $end )};
839
840	return $date.$unique.'@expresso-calendar';
841	}
842	private function getStatus( $id ){
843	$a = array(
844	STATUS_CONFIRMED => 'CONFIRMED',
845	STATUS_CANCELLED => 'CANCELLED',
846	STATUS_TENATIVE => 'TENATIVE',
847	STATUS_UNANSWERED => 'NEEDS-ACTION',
848	STATUS_DELEGATED => 'DELEGATED'
849	);
850	return $a[ $id ];
851	}
852	private static function decodeAlarmType( $id ){
853	$a = array( ALARM_ALERT => 'alert',
854	ALARM_MAIL => 'mail',
855	ALARM_SMS => 'sms' );
856
857	return $a[ $id ];
858	}
859	private static function codeAlarmType( $type ){
860	$a = array( 'alert' => ALARM_ALERT ,
861	'mail' => ALARM_MAIL ,
862	'sms' => ALARM_SMS );
863
864	return $a[ $type ];
865	}
866	private static function codeAlarmUnit( $u ){
867	if($u === 'd') return 'days';
868	if($u === 'm') return 'minutes';
869	if($u === 'H') return 'hours';
870	}
871
872	private static function ownerSchedulable( $id ){
873
874	$isOwner = Controller::find(array('concept' => 'participant'), array('id') ,
875	array('filter' =>
876	array('AND',
877	array('=' , 'isOrganizer' , '1'),
878	array('=' , 'user' ,$_SESSION['wallet']['user']['uidNumber'] ),
879	array('=' , 'schedulable' ,$id )
880	)));
881
882	return ( isset( $isOwner[0]['id'] ) ) ? true : false;
883	}
884
885	private static function schedulable2calendarToObject($Schedulable)
886	{
887	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'
888	.' WHERE calendar_signature.user_uidnumber = '.$_SESSION['wallet']['user']['uidNumber']
889	.' AND calendar_signature.is_owner = 1'
890	.' AND calendar_signature.calendar_id = calendar.id'
891	.' AND calendar_to_calendar_object.calendar_id = calendar.id'
892	.' AND calendar_to_calendar_object.calendar_object_id = '.addslashes($Schedulable));
893	}
894
895	}
896
897	?>

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

Download in other formats: