source: sandbox/2.4.2-expresso1/prototype/modules/calendar/interceptors/DBMapping.php @ 6974

Revision 6974, 59.3 KB checked in by acoutinho, 12 years ago (diff)

Ticket #2966 - Correcoes de bugs e melhorias / suporte a historico em atividades
Line 
1<?php
2
3//Definindo Constantes
4require_once ROOTPATH . '/modules/calendar/constants.php';
5
6require_once ROOTPATH . '/modules/calendar/interceptors/Helpers.php';
7
8use prototype\api\Config as Config;
9
10class DBMapping extends Helpers {
11
12    static function encodeCreateSchedulable(&$uri, &$params, &$criteria, $original)
13    {
14
15        if (!is_numeric($params['startTime']))
16            $params['startTime'] = self::parseTimeDate($params['startTime'], $params['timezone']);
17
18        if (!is_numeric($params['endTime'])) {
19            $params['endTime'] = self::parseTimeDate($params['endTime'], $params['timezone']);
20
21            if ($params['allDay'])
22                $params['endTime'] = $params['endTime'] + 86400000;
23        }
24
25        if (isset($params['due']) && $params['due'] != '' && !is_numeric($params['due']))
26            $params['due'] = self::parseTimeDate($params['due'], $params['timezone']);
27
28
29        $params['rangeEnd'] = $params['endTime'];
30        $params['rangeStart'] = $params['startTime'];
31
32        ///////////////////////////////////////////////////////////////////
33
34        $params['dtstamp'] = (isset($params['dtstamp'])) ? $params['dtstamp'] : time() . '000';
35        $params['lastUpdate'] = (isset($params['lastUpdate'])) ? $params['lastUpdate'] : time() . '000';
36        $params['uid'] = isset($params['uid']) ? $params['uid'] : self::_makeUid();
37        }
38
39    static function parseTimeDate($time, $timezone) {
40        return strtotime($time . ' ' . $timezone) . '000';
41    }
42
43     public function encodeCreateAlarm( &$uri , &$params , &$criteria , $original ){
44       
45        if(!isset($params['schedulable']) || !isset($params['rangeStart']) || !isset($params['rangeEnd']) )
46        {
47            $participant = Controller::read( array( 'concept' => 'participant' , 'id' => $params['participant'] ) , array('schedulable')  );
48
49            $params['schedulable'] = $participant['schedulable'];
50
51            $params['type'] = self::codeAlarmType($params['type']);
52
53            $params['offset'] = $params['time'] * 1000;
54
55            switch( strtolower($params['unit']) )
56            {
57                case 'd': $params['offset'] *= 24;
58                case 'h': $params['offset'] *= 60;
59                case 'm': $params['offset'] *= 60;
60            }
61        }
62    }
63
64    public function encodeCreateSuggestion(&$uri, &$params, &$criteria, $original) {
65        $params['dtstamp'] = (isset($params['dtstamp'])) ? $params['dtstamp'] : time() . '000';
66    }
67
68    public function encodeUpdateAlarm(&$uri, &$params, &$criteria, $original) {
69        if (isset($params['type']))
70            $params['type'] = self::codeAlarmType($params['type']);
71        else{
72            $alarm = Controller::read( array('concept' => 'alarm' , 'id' => $params['id'] ));
73
74            $params['unit'] = $alarm['unit'];
75        }
76        $params['offset'] = $params['time'] * 1000;
77
78
79        switch( strtolower($params['unit']) )
80        {
81            case 'd': $params['offset'] *= 24;
82            case 'h': $params['offset'] *= 60;
83            case 'm': $params['offset'] *= 60;
84        }
85       
86    }
87
88    public function encodeCreateAttachment(&$uri, &$params, &$criteria, $original) {
89
90        if (!isset($params['source']))
91            return false;
92
93        if (isset($_FILES[$params['source']]))
94            if (isset($params['id']))
95                $params = array_merge($_FILES[$params['source']], array('id' => $params['id']));
96            else
97                $params = $_FILES[$params['source']];
98
99        if (isset($params['owner']))
100            $params['owner'] = Config::me('uidNumber');
101    }
102
103///////////////////////////////////////////////////////////////////////////////////////////////////////////////
104
105    public function encodeSignatureAlarmType(&$uri, &$params, &$criteria, $original) {
106        $params['type'] = self::codeAlarmType($params['type']);
107    }
108
109    public function insertOwnerLink(&$uri, &$params, &$criteria, $original) {
110        $params['owner'] = Config::me('uidNumber');
111    }
112
113    public function encodeServiceUser(&$uri, &$params, &$criteria, $original) {
114        if (isset($params['isExternal']) && $params['isExternal'] == '1')
115            $uri['service'] = 'PostgreSQL';
116    }
117
118    public function prepareRepeat(&$uri, &$params, &$criteria, $original) {
119        if (isset($params['startTime']) || isset($params['endTime'])) {
120           
121            if(!isset($params['schedulable']))
122                $params = array_merge($params , Controller::read(array('concept' => 'repeat', 'id' => $params['id']), array('schedulable')));
123 
124            $timezone = Controller::read(array('concept' => 'schedulable', 'id' => $params['schedulable']), array('timezone'));
125
126            if (isset($params['startTime']))
127                $params['startTime'] = self::parseTimeDate($params['startTime'], $timezone['timezone']);
128            if (isset($params['endTime']))
129                $params['endTime'] = self::parseTimeDate($params['endTime'], $timezone['timezone']);
130        }
131    }
132
133    public function findSchedulable(&$uri, &$params, &$criteria, $original) {
134        if (isset($criteria['filter'][2][1]) && $criteria['filter'][2][1] == 'calendar') {
135
136            $sql = ' SELECT calendar_object.id as id ,calendar_object.cal_uid as "uid", calendar_object.type_id as "type", '
137                .'calendar_object.dtstart as "startTime", calendar_object.summary as "summary", '
138                .'calendar_object.description as "description", calendar_object.dtend as "endTime" , '
139        .'calendar_object.priority as "priority", calendar_object.due as "due", '
140        .'calendar_object.percentage as "percentage", calendar_object.status as "status", '
141                .'calendar_object.location as "location", calendar_object.allday as "allDay", '
142                .'calendar_object.transp as "transparent", calendar_object.class_id as "class", '
143                .'calendar_object.repeat as "repeat", calendar_object.range_start as "rangeStart", '
144                .'calendar_object.range_end as "rangeEnd", calendar_object.last_update as "lastUpdate", '
145                .'calendar_object.dtstamp as "dtstamp", calendar_object.sequence as "sequence", '
146                .'calendar_object.tzid as "timezone" ,calendar_to_calendar_object.calendar_id as '
147                .'calendar FROM calendar_to_calendar_object , calendar_object '
148                .'WHERE ( calendar_to_calendar_object.calendar_id IN (\'' . implode('\',\'', $criteria['filter'][2][2]) . '\')) '
149                .'AND calendar_to_calendar_object.calendar_object_id = calendar_object.id '
150        .'AND calendar_object.id NOT IN(select calendar_object_task_id from calendar_task_to_activity_object where owner = \'' . Config::me('uidNumber') . '\') ';     
151           
152            if(isset($criteria['searchEvent']) && $criteria['searchEvent']){
153                $where = 'AND (((upper("summary") like upper(\'%'.$criteria['filter'][1][1][2].'%\') OR upper("description") like upper(\'%'.$criteria['filter'][1][2][2].'%\')))) ORDER BY dtstart LIMIT '.$criteria['limit'].'  OFFSET '.$criteria['offset'].' ';
154                $params = Controller::service('PostgreSQL')->execResultSql($sql.$where);
155
156            }else{
157                $start = array( $criteria['filter'][1][1][1][2] , $criteria['filter'][1][2][1][2], $criteria['filter'][1][3][1][2] );
158                $end = array( $criteria['filter'][1][1][2][2] , $criteria['filter'][1][2][2][2], $criteria['filter'][1][3][2][2] );
159
160                $ids = array();
161                $occ = array();
162
163                if ($occurrences = self::checkOccurrences($start[0], $end[0], $criteria['filter'][2][2]))
164                    foreach ($occurrences as $id => $occurrence) {
165                        $ids[] = $id;
166                        $occ[] = $occurrence;
167                    }   
168
169                $where = 'AND ((range_end >= \'' . $start[0] . '\' AND range_end <= \'' . $end[0] . '\') OR '
170                        .'(range_start >= \'' . $start[1] . '\' AND range_start <= \'' . $end[1] . '\') OR '
171                        .'(range_start <= \'' . $start[2] . '\' AND range_end >= \'' . $end[2] . '\')) '
172                .(!empty($ids) ? ' ' .'AND calendar_object.id NOT IN (\'' . implode('\',\'', $ids) . '\') ' : ' ')
173                .'AND calendar_object.dtstart NOT IN (SELECT calendar_repeat_occurrence.occurrence from calendar_repeat_occurrence, '
174                .'calendar_repeat where (calendar_repeat_occurrence.repeat_id = calendar_repeat.id) '
175                .'AND (calendar_repeat.object_id = calendar_object.id))';
176
177                $params = Controller::service('PostgreSQL')->execResultSql($sql.$where);
178                $params = array_merge($params, $occ);           
179            }
180            $params = self::deepnessFindEvent($uri, $params, $criteria, $original);
181            return false;
182        }
183    }
184
185    public function findTask(&$uri, &$params, &$criteria, $original) {
186
187        if (isset($criteria['filterTasks']) && $criteria['filterTasks']) {
188
189            $sql = ' SELECT calendar_object.id as id ,calendar_object.cal_uid as "uid", calendar_object.type_id as "type", '
190            .'calendar_object.dtstart as "startTime", calendar_object.summary as "summary", '
191            .'calendar_object.description as "description", calendar_object.dtend as "endTime" , '
192            .'calendar_object.priority as "priority", calendar_object.due as "due", '
193            .'calendar_object.percentage as "percentage", calendar_object.status as "status", '
194            .'calendar_object.location as "location", calendar_object.allday as "allDay", '
195            .'calendar_object.transp as "transparent", calendar_object.class_id as "class", '
196            .'calendar_object.repeat as "repeat", calendar_object.range_start as "rangeStart", '
197            .'calendar_object.range_end as "rangeEnd", calendar_object.last_update as "lastUpdate", '
198            .'calendar_object.dtstamp as "dtstamp", calendar_object.sequence as "sequence", '
199            .'calendar_object.tzid as "timezone" ,calendar_to_calendar_object.calendar_id as '
200            .'calendar FROM calendar_to_calendar_object , calendar_object '
201            .'WHERE ( calendar_to_calendar_object.calendar_id IN (\'' . implode('\',\'', $criteria['filter'][3][2]) . '\')) '
202            .'AND calendar_to_calendar_object.calendar_object_id = calendar_object.id '
203        .'AND calendar_to_calendar_object.calendar_object_id NOT IN (select calendar_object_activity_id from calendar_task_to_activity_object where owner =  \'' . Config::me("uidNumber") . '\' ) '   
204        .'AND calendar_to_calendar_object.calendar_object_id NOT IN (select calendar_object_task_id from calendar_task_to_activity_object where owner =  \'' . Config::me("uidNumber") . '\' ) ';   
205
206        if(isset($criteria['filter'][4]))
207            $sql .= 'AND (((upper("summary") like upper(\'%'.$criteria['filter'][4][1][2].'%\') OR upper("description") like upper(\'%'.$criteria['filter'][4][1][2].'%\'))))';
208
209            $sql .= 'AND (range_start >= \'' . $criteria['filter'][2][2] . '\' AND type_id <= \'' .  $criteria['filter'][1][2] . '\')';
210
211            $params = Controller::service('PostgreSQL')->execResultSql($sql);
212            $params = self::deepnessFindEvent($uri, $params, $criteria, $original);
213            return false;
214        }
215    }
216
217    public function deepnessFindRepeatOccurrence(&$uri, &$result, &$criteria, $original) {
218
219        if (!isset($criteria['deepness']) || $criteria['deepness'] == 0)
220            return;
221
222        foreach ($result as $i => &$res)
223            if (isset($res['repeat']))
224                $res['repeat'] = Controller::read(array('concept' => 'repeat', 'id' => $res['repeat']), false, array('deepness' => intval($criteria['deepness']) - 1));
225    }
226
227    public function deepnessRepeat(&$uri, &$result, &$criteria, $original) {
228
229        if (!isset($criteria['deepness']) || $criteria['deepness'] == 0)
230            return;
231
232        $result['schedulable'] = Controller::find(array('concept' => 'schedulable'), false, array('filter' => array('=', 'id', $result['schedulable']), 'deepness' => intval($criteria['deepness']) - 1));
233        $result['schedulable'] = $result['schedulable'][0];
234    }
235
236    public function saveOccurrences(&$uri, &$result, &$criteria, $original) {
237        $ranges = Controller::find(array('concept' => 'repeatRange'), array('rangeStart', 'rangeEnd'), array('filter' => array('=', 'user', Config::me("uidNumber"))));
238
239        if (!is_array($ranges) || !isset($ranges[0]['rangeStart']) || !isset($ranges[0]['rangeEnd']))
240            return;
241
242        if (isset($result['id']))
243            $id = $result['id'];
244        else
245            $id = $uri['id'];
246
247        $repeat = Controller::read(array('concept' => 'repeat', 'id' => $id));
248
249        unset($repeat['schedulable']);
250        unset($repeat['id']);
251
252        $exceptions = array();
253
254        if (isset($original['properties']['exceptions'])) {
255            $exceptions = explode(',', $original['properties']['exceptions']);
256            unset($repeat['exceptions']);
257        }
258
259        $lastExceptions = Controller::find(array('concept' => 'repeatOccurrence'), array("occurrence"), array('filter' => array('AND', array('=', 'repeat', $id), array('=', 'exception', 1))));
260
261        //Recurepa as execeções anteriores caso exista
262        if (isset($lastExceptions) && count($lastExceptions) && $lastExceptions)
263            foreach ($lastExceptions as $value)
264                array_push($exceptions, $value['occurrence']);
265
266        $params = array_diff(self::decodeRepeat($repeat, $ranges[0]['rangeStart'], $ranges[0]['rangeEnd']), $exceptions);
267
268        Controller::delete(array('concept' => 'repeatOccurrence'), false, array('filter' => array('=', 'repeat', $id)));
269
270        if (!empty($params))
271            Controller::service('PostgreSQL')->execResultSql("INSERT INTO calendar_repeat_occurrence(repeat_id,exception,occurrence)VALUES('" . $id . "','0','" . implode("'),('" . $id . "','0','", $params) . "')" . ( empty($exceptions) ? "" : ",('" . $id . "','1','" . implode("'),('" . $id . "','1','", $exceptions) . "')" ));
272        else if(!empty($exceptions))
273            Controller::service('PostgreSQL')->execResultSql("INSERT INTO calendar_repeat_occurrence(repeat_id,exception,occurrence)VALUES ('" . $id . "','1','" . implode("'),('" . $id . "','1','", $exceptions) . "')" );
274    }       
275
276    public function checkOccurrences($start, $end, $calendarIds) {
277
278        $ranges = Controller::find(array('concept' => 'repeatRange'), array('rangeStart', 'rangeEnd'), array('filter' => array('=', 'user', Config::me("uidNumber"))));
279        $ranges = $ranges[0];
280
281        $origStart = $start;
282        $origEnd = $end;
283
284        if ($initialized = (isset($ranges['rangeStart']) && isset($ranges['rangeEnd']))) {
285            if ($ranges['rangeStart'] <= $start)
286                $start = false;
287            if ($ranges['rangeEnd'] >= $end)
288                $end = false;
289        }
290
291        $repeats = self::findRepeats($calendarIds);
292        if (!is_array($repeats) || empty($repeats))
293            return( false );
294
295        $result = array();
296        $ids = array();
297
298        foreach ($repeats as $repeat) {
299            $ids[] = $id = $repeat['id'];
300            unset($repeat['id']);
301
302            if (!isset($result[$id]))
303                $result[$id] = !$initialized ? array($repeat['startTime']) : array();
304
305            if (!$initialized)
306                $result[$id] = array_merge($result[$id], self::decodeRepeat($repeat, $start, $end));
307            else {
308                if ($start)
309                    $result[$id] = array_merge($result[$id], self::decodeRepeat($repeat, $start, $ranges['rangeStart']));
310
311                if ($end)
312                    $result[$id] = array_merge($result[$id], self::decodeRepeat($repeat, $ranges['rangeEnd'], $end));
313            }
314
315            if (empty($result[$id]))
316                unset($result[$id]);
317        }
318
319        if ($start || $end) {
320            Controller::begin(array('service' => 'PostgreSQL'));
321
322            foreach ($result as $id => $res){
323               
324                $ocurrences = array_unique($res);
325                Controller::service('PostgreSQL')->execResultSql("INSERT INTO calendar_repeat_occurrence(repeat_id,occurrence)VALUES('" . $id . "','" . implode("'),('" . $id . "', '", $ocurrences) . "')");
326            }
327            $data = array();
328
329            if ($start)
330                $data['rangeStart'] = $start;
331
332            if ($end)
333                $data['rangeEnd'] = $end;
334
335            if (!$initialized)
336                $data['user'] = Config::me('uidNumber');
337
338            Controller::call(( $initialized ? 'replace' : 'create'), array('concept' => 'repeatRange'), $data, array('filter' => array('=', 'user', Config::me('uidNumber'))));
339
340            Controller::commit(array('service' => 'PostgreSQL'));
341        }
342
343//      $return = Controller::find( array( 'concept' => 'repeatOccurrence' ), false, array( 'filter' => array( 'AND', array( '>=', 'occurrence', $origStart ), array( '<=', 'occurrence', $origEnd ), array( 'IN', 'repeat', $ids ) ), 'deepness' => $deep ) );
344
345        $return = Controller::service('PostgreSQL')->execResultSql('SELECT calendar_repeat_occurrence.occurrence as "occurrence", calendar_repeat.object_id as "schedulable" FROM calendar_repeat, calendar_repeat_occurrence WHERE calendar_repeat_occurrence.occurrence >= \'' . $origStart . '\' AND calendar_repeat_occurrence.occurrence <= \'' . $origEnd . '\' AND calendar_repeat_occurrence.repeat_id IN (\'' . implode('\',\'', $ids) . '\') AND calendar_repeat.id = calendar_repeat_occurrence.repeat_id AND calendar_repeat_occurrence.exception != 1');
346
347        if (!is_array($return))
348            return( false );
349
350        $result = array();
351        $params = array();
352
353        foreach ($return as $ret) {
354            $currentId = $ret['schedulable'];
355
356            if (!isset($result[$currentId])) {
357                $result[$currentId] = Controller::read(array('concept' => 'schedulable', 'id' => $currentId));
358                $result[$currentId]['occurrences'] = array();
359
360                $calendarToCalendarObj = self::schedulable2calendarToObject($currentId);
361                $result[$currentId]['calendar'] = $calendarToCalendarObj[0]['calendar_id'];
362            }
363
364            $result[$currentId]['occurrences'][] = $ret['occurrence'];
365        }
366
367        return( $result );
368    }
369
370    public static function findRepeats($ids) {
371        return Controller::service('PostgreSQL')->execResultSql('SELECT calendar_repeat.wkst as "wkst", calendar_repeat.byweekno as "byweekno", calendar_repeat.byminute as "byminute", calendar_repeat.bysecond as "bysecond", calendar_repeat.byyearday as "byyearday", calendar_repeat.bymonthday as "bymonthday", calendar_repeat.bysetpos as "bysetpos", calendar_repeat.byday as "byday", calendar_repeat.byhour as "byhour", calendar_repeat.interval as "interval", calendar_repeat.frequency as "frequency", calendar_repeat.until as "endTime", calendar_repeat.id as "id", calendar_repeat.count as "count", calendar_repeat.dtstart as "startTime" FROM calendar_repeat, calendar_to_calendar_object WHERE calendar_repeat.object_id = calendar_to_calendar_object.calendar_object_id AND calendar_to_calendar_object.calendar_id IN (\'' . implode('\',\'', $ids) . '\')');
372    }
373
374//HELPERS
375    public static function decodeRepeat($repeat, $start, $end) {
376
377        date_default_timezone_set('UTC');
378
379        require_once ROOTPATH . '/plugins/when/When.php';
380
381        $r = new When();
382
383        if ($repeat['frequency'] === 'none')
384            return( array() );
385
386        //Nao deve ser usando o horário da repeticao pois nela contem apenas o dias,
387        //deve se recuperar o horário do evento para um correto calculo.
388        if (max($start, $repeat['startTime']) != $repeat['startTime']) {
389            $time = new DateTime('@' . (int) ( $repeat['startTime'] / 1000 ), new DateTimeZone('UTC'));
390
391            $hoursOcurrence = new DateTime('@' . (int) ( $start / 1000 ), new DateTimeZone('UTC'));
392            $hoursOcurrence = $hoursOcurrence->format('H');
393
394            $diffTime = ((($time->format('H') - $hoursOcurrence) * (3600000)) + ($time->format('i') * (60000)));
395            $start = new DateTime('@' . (int) ( ( $start + $diffTime ) / 1000 ), new DateTimeZone('UTC'));
396        }else
397            $start = new DateTime('@' . (int) ( max($start, $repeat['startTime']) / 1000 ), new DateTimeZone('UTC'));
398
399        foreach ($repeat as $rule => $value) {
400            if (!isset($value) || !$value || $value === "0")
401                continue;
402
403            switch (strtolower($rule)) {
404                case "starttime": break;
405                case "frequency":
406                    $r->recur($start, $value);
407                    break;
408                case "endtime":
409                    $r->until(new DateTime('@' . (int) ( $value / 1000 )));
410                    break;
411                case "count": case "interval": case "wkst":
412                    $r->$rule($value);
413                    break;
414                default :
415                    $r->$rule(!is_array($value) ? explode(',', $value) : $value );
416                    break;
417            }
418        }
419
420        $return = array();
421
422        while ($result = $r->next()) {
423            $u = $result->format('U') * 1000;
424
425            if ($u > $end) //data da repetição atual maior que a data final da busca do usuario ?
426                break;
427
428            $return[] = $u;
429        }
430
431        return( $return );
432    }
433
434///////////////////////////////////////////////////////////////////////////////////////////////////////////////
435
436    public function updateCalendar(&$uri, &$params, &$criteria, $original) {       
437        if (isset($params['calendar'])) {
438            if(isset($params['lastCalendar'])){
439                $calendarObjects = self::referenceCalendarToObject($uri['id'], $params['lastCalendar']);
440                $params2['calendar'] = $params['calendar'];
441            }else{
442                $calendarObjects = self::schedulable2calendarToObject($uri['id']);
443                $params2['calendar'] = $params['calendar'];
444            }
445           
446            foreach ($calendarObjects as $calendarObject)
447                Controller::update(array('concept' => 'calendarToSchedulable', 'id' => $calendarObject['calendar_to_calendar_object']), $params2);
448
449            unset($params['calendar']);
450
451            if (count($params) < 1)
452                return false;
453        }
454    }
455
456//Encode Update
457
458    public function encodeUpdateSchedulable(&$uri, &$params, &$criteria, $original) {
459
460        $event = Controller::read(array('concept' => 'schedulable', 'id' => $params['id']));
461                   
462        if (isset($params['startTime'])) {
463
464            if (!is_numeric($params['startTime']))
465                $params['startTime'] = self::parseTimeDate($params['startTime'], $event['timezone']);
466
467            $params['rangeStart'] = $params['startTime'];
468        }
469
470        if (isset($params['endTime'])) {
471
472            if (!is_numeric($params['endTime'])) {
473                        $params['endTime'] = self::parseTimeDate($params['endTime'], $event['timezone']);
474
475                    if ((isset($params['allDay']) && $params['allDay']) || ( !isset($params['allDay']) && $event['allDay']))
476                        $params['endTime'] = $params['endTime'] + 86400000;
477            }
478            $params['rangeEnd'] = $params['endTime'];
479        }
480
481
482        if (isset($params['due']) && $params['due'] != '' && !is_numeric($params['due']))
483            $params['due'] = self::parseTimeDate($params['due'], $event['timezone']);
484
485
486        if($event['type'] == '2'){
487
488            $criteria['historic'] = $params;
489            $criteria['beforeValue'] = $event;
490
491            if(isset($params['startTime']) && $params['startTime'] == $event['startTime'])
492                unset($criteria['historic']['startTime']);
493
494            if(isset($params['endTime']) && $params['endTime'] == $event['endTime'])
495                unset($criteria['historic']['endTime']);
496
497            if(isset($params['due']) && $params['due'] == $event['due'])
498                unset($criteria['historic']['due']);
499
500            unset($criteria['historic']['rangeEnd']);
501            unset($criteria['historic']['rangeStart']);
502            unset($criteria['historic']['id']);           
503        }
504    }
505
506    static function putEvent(&$uri, &$result, &$criteria, $original) {
507        if (Config::module('useCaldav', 'expressoCalendar')) { //Ignorar Put dos eventos ja vindos do caldav
508            require_once ROOTPATH . '/modules/calendar/interceptors/DAViCalAdapter.php';
509
510            $eventID = (isset($result['id'])) ? $result['id'] : $uri['id'];
511            $event = Controller::read(array('concept' => 'schedulable', 'id' => $eventID));
512
513            $participants = Controller::find(array('concept' => 'participant'), false, array('filter' => array('=', 'schedulable', $eventID)));
514
515            if (is_array($participants) && count($participants) > 0)
516                foreach ($participants as $ii => $vv) {
517                    if ($vv['isExternal'] == 1)
518                        $participants[$ii]['user'] = Controller::read(array('concept' => 'user', 'id' => $vv['user'], 'service' => 'PostgreSQL'));
519                    else
520                        $participants[$ii]['user'] = Controller::read(array('concept' => 'user', 'id' => $vv['user']));
521                }
522
523            $event['URI']['concept'] = 'schedulable';
524            $event['participants'] = $participants;
525
526            $ical = Controller::format(array('service' => 'iCal'), array($event));
527            $calendars = self::schedulable2calendarToObject($original['properties']['id']); //Busca os calendarios do usuario logado que contenham o evento
528            if (is_array($calendars))
529                foreach ($calendars as $calendar)
530                    DAViCalAdapter::putIcal($ical, array('uid' => $event['uid'], 'location' => $calendar['calendar_location']));
531        }
532    }
533
534
535    static function prepareParticipantHistoric(&$uri, &$params, &$criteria, $original){
536       $participant = Controller::read(array('concept' => 'participant', 'id' => $uri['id']));
537       $schedulable = Controller::read(array('concept' => 'schedulable', 'id' => $participant['schedulable']));
538
539
540       if($schedulable['type'] == '2')
541            $criteria['historic']['participant']  = $participant;
542    }
543
544    static function removeParticipantHistoric(&$uri, &$params, &$criteria, $original){
545        if(isset($criteria['historic'])){
546
547            $participant = $criteria['historic']['participant'];
548
549             Controller::create(array('concept' => 'calendarHistoric'),
550                array('schedulable' => $participant['schedulable'],
551                    'user' => Config::me('uidNumber'),
552                    'time' => time() . '000',
553                    'attribute' => 'participant',
554                    'beforeValue' => $participant['user'],
555                    'afterValue' => ''
556                    )
557                );
558
559        }
560
561    }
562
563    static function createParticipantHistoric(&$uri, &$params, &$criteria, $original){
564
565        if(isset($original['properties']) && $original['properties']['isOrganizer'] != '1'){
566            if(!isset($criteria['event'])){
567                $event = Controller::read(array('concept' => 'schedulable', 'id' => $original['properties']['schedulable']));
568                $criteria['event'] = $event;
569            }else
570                $event = $criteria['event'];
571
572            if($event['type'] == '2'){
573                Controller::create(array('concept' => 'calendarHistoric'),
574                    array('schedulable' => $original['properties']['schedulable'],
575                        'user' => Config::me('uidNumber'),
576                        'time' => time() . '000',
577                        'attribute' => 'participant',
578                        'beforeValue' => '',
579                        'afterValue' => $original['properties']['user']
580                        )
581                    );
582            }
583        }
584    }
585
586    static function createHistoric(&$uri, &$result, &$criteria, $original) {
587
588        if(isset($criteria['historic']) && count($criteria['historic'])){
589            $time =  time() . '000';
590
591            foreach($criteria['historic'] as $k => $v){
592                Controller::create(array('concept' => 'calendarHistoric'),
593                    array('schedulable' => $uri['id'],
594                        'user' => Config::me('uidNumber'),
595                        'time' => $time,
596                        'attribute' => $k,
597                        'beforeValue' => $criteria['beforeValue'][$k],
598                        'afterValue' => $v
599                        )
600                    );
601            }
602        }   
603    }
604
605///////////////////////////////////////////////////////////////////////////////////////////////////////////////
606
607    public function verifyCalendarLocation(&$uri, &$params, &$criteria, $original) {
608        if (!isset($params['location']))
609            $params['location'] = Config::me('uid') . '/' . $params['name'];
610    }
611
612    //TODO: Remover apos suporte a ManytoMany na api
613    public function createCalendarToSchedulable(&$uri, &$result, &$criteria, $original) {
614
615        Controller::create(array('concept' => 'calendarToSchedulable'), array('calendar' => $original['properties']['calendar'], 'schedulable' => $result['id']));
616    }
617
618    //TODO: Remover apos suporte a ManytoMany na api
619    public function createTasksToActivity(&$uri, &$result, &$criteria, $original) {
620
621        if(isset($original['properties']['taskToActivity']) && $original['properties']['taskToActivity']){
622
623            foreach($original['properties']['taskToActivity'] as $relational)
624
625                Controller::create(array('concept' => 'taskToActivity'), array('task' => $relational['task'], 'owner' => $relational['owner'], 'activity' => $result['id']));
626
627        }
628    }
629
630    public function removeAttachmentHistoric(&$uri, &$params, &$criteria, $original) {
631
632        if(isset($criteria['historic'])){
633            $attachment = $criteria['historic']['attachment'];
634
635            $attachment['attachment'] = Controller::read(array('concept' => 'attachment', 'id' => $attachment['attachment']), array('name'));
636            Controller::create(array('concept' => 'calendarHistoric'),
637                    array('schedulable' => $attachment['schedulable'],
638                        'user' => Config::me('uidNumber'),
639                        'time' => time() . '000',
640                        'attribute' => 'attachment',
641                        'beforeValue' => $attachment['attachment']['name'],
642                        'afterValue' => ''
643                        )
644                    );
645
646        }
647   
648    }
649
650    public function createAttachmentHistoric(&$uri, &$params, &$criteria, $original) {
651        $event = Controller::read(array('concept' => 'schedulable', 'id' => $original['properties']['schedulable']));
652
653        if($event['type'] == '2'){
654            $attachment = Controller::read(array('concept' => 'attachment', 'id' => $original['properties']['attachment']), array('name'));
655
656            Controller::create(array('concept' => 'calendarHistoric'),
657                array('schedulable' => $original['properties']['schedulable'],
658                    'user' => Config::me('uidNumber'),
659                    'time' => time() . '000',
660                    'attribute' => 'attachment',
661                    'beforeValue' => '',
662                    'afterValue' => $attachment['name']
663                    )
664                );
665
666        }
667    }
668
669    public function deepnessFindCalendarShared(&$uri, &$result, &$criteria, $original) {
670        if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != '0' && count($result) > 0) {
671
672            $calendarIds = array();
673            foreach ($result as $key => $value)
674                array_push($calendarIds, $value['calendar']);
675
676            $calendar = Controller::find(array('concept' => 'calendar'), false, array('filter' => array('AND', array('IN', 'id', $calendarIds), $original['criteria']['filter'])));
677
678            if ($calendar && count($calendar) > 0){
679                $newResult = array();
680                foreach ($calendar as $key => $value) {
681                    foreach ($result as $k => $r) {
682
683                        if ($r['calendar'] == $value['id']) {
684                            $r['calendar'] = $value;
685                            array_push($newResult, $r);
686                        }
687                    }
688                }
689
690                foreach ($newResult as $key => &$value) {
691                    if ($value['user'] != 0) {
692                        $user = $value['user'];
693                        $value['user'] = Controller::read(array('concept' => 'user', 'id' => $user));
694
695                        if (!$value['user'])
696                            $value['user'] = Controller::read(array('concept' => 'group', 'id' => $user));
697                    }
698                }
699
700                $result = $newResult;
701            }else
702                $result = '';
703        }
704    }
705
706    //TODO: Remover apos suporte a deepness na api
707    public function deepnessFindTask(&$uri, &$result, &$criteria, $original) {
708        if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0)
709           foreach($result as &$value)
710                $value['task'] = Controller::read(array('concept' => 'schedulable', 'id' => $value['task']));
711           
712       
713        return $result;
714    }
715
716    //TODO: Remover apos suporte a deepness na api
717    public function deepnessFindHistoric(&$uri, &$result, &$criteria, $original) {
718        if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0) {
719            foreach($result as &$v){
720                $v['user'] = Controller::read(array('concept' => 'user', 'id' => $v['user']));
721
722                if($v['attribute'] == 'participant'){
723                    if($v['beforeValue'] != '')
724                        $v['beforeValue'] = Controller::read(array('concept' => 'user', 'id' => $v['beforeValue']));
725
726                    if($v['afterValue'] != '')
727                        $v['afterValue'] = Controller::read(array('concept' => 'user', 'id' => $v['afterValue']));
728                }
729            }
730        }
731    }
732
733    //TODO: Remover apos suporte a deepness na api
734    public function deepnessFindEvent(&$uri, &$result, &$criteria, $original) {
735        if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0) {
736            $Time = new DateTime('now', new DateTimeZone('UTC'));
737            $DayLigth = array();
738            foreach ($result as $i => $v) {
739
740                if (!isset($currentTimezone) || $currentTimezone != $original['criteria']['timezones'][$v['calendar']]) {
741                    $currentTimezone = isset($original['criteria']['timezones'][$v['calendar']]) ? $original['criteria']['timezones'][$v['calendar']] : $v['timezone'];
742                    $Time->setTimezone(new DateTimeZone($currentTimezone));
743                }
744
745                $Time->setTimestamp((int) ($v['startTime'] / 1000));
746                $DayLigth['calendar']['startTime'] = $Time->format('I') ? 1 : 0;
747
748                $Time->setTimestamp((int) ($v['endTime'] / 1000));
749                $DayLigth['calendar']['endTime'] = $Time->format('I') ? 1 : 0;
750
751                if ($currentTimezone != $v['timezone']) {
752                    $currentTimezone = $v['timezone'];
753                    $Time->setTimezone(new DateTimeZone($v['timezone']));
754
755                    $Time->setTimestamp((int) ($v['startTime'] / 1000));
756                    $DayLigth['event']['startTime'] = $Time->format('I') ? 1 : 0;
757
758                    $Time->setTimestamp((int) ($v['endTime'] / 1000));
759                    $DayLigth['event']['endTime'] = $Time->format('I') ? 1 : 0;
760                }else
761                    $DayLigth['event'] = $DayLigth['calendar'];
762
763
764                $result[$i]['DayLigth'] = $DayLigth;
765
766        if(((int)$v['type']) == 2){
767
768            $taskToActivity = Controller::find(array('concept' => 'taskToActivity'), false, array('filter' => array('AND', array('=', 'activity', $v['id']), array('=','owner', Config::me('uidNumber'))) , 'deepness' => 2));
769
770            if($taskToActivity)
771                $result[$i]['taskToActivity'] = $taskToActivity;
772
773            $result[$i]['historic'] = Controller::find(array('concept' => 'calendarHistoric'), false, array('filter' => array('=', 'schedulable', $v['id']) , 'deepness' => 2));
774
775        }
776
777                if (isset($v['id'])) {
778                    $data = self::decodeParticipantsEvent($uri, $v, $criteria, $original);
779
780                    $result[$i]['statusAttendees'] = isset($data['statusAttendees']) ? $data['statusAttendees'] : false;
781                    $result[$i]['sizeAttendees'] = isset($data['sizeAttendees']) ? $data['sizeAttendees'] : false;
782                    $result[$i]['participants'] = $data['attendees'];
783
784                    $attachmentRelation = Controller::find(array('concept' => 'schedulableToAttachment'), false, array('filter' => array('=', 'schedulable', $v['id'])));
785                    if (is_array($attachmentRelation)) {
786                        $attachments = array();
787                        foreach ($attachmentRelation as $key => $value)
788                            if (isset($value['attachment']) || !!$value['attachment'])
789                                $attachments[$key] = $value['attachment'];
790                        //Pega os anexos sem source
791                        $result[$i]['attachments'] = Controller::find(array('concept' => 'attachment'), array('id', 'name', 'type', 'size'), array('filter' => array('IN', 'id', $attachments)));
792                    }
793
794                    $repeat = Controller::find(array('concept' => 'repeat'), false, array('filter' => array('=', 'schedulable', $v['id'])));
795
796                    unset($result[$i]['repeat']);
797
798                    if (is_array($repeat))
799                        $result[$i]['repeat'] = $repeat[0];
800                }
801            }
802        }
803
804        return $result;
805    }
806   
807
808//TODO: Remover apos suporte a deepness na api
809    public function deepnessReadParticipant( &$uri , &$result , &$criteria , $original ){
810       
811       if(isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0)
812       {
813            if(isset($result['id']) && isset($result['user']))
814            {
815                $result['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $result['user'] , 'service' => ( $result['isExternal'] == 1 ? 'PostgreSQL' : 'OpenLDAP' ) ) );
816
817                if($result['user']['id'] == Config::me('uidNumber'))
818                  $result['alarms'] = Controller::find( array( 'concept' => 'alarm' ) , null , array('filter' => array('=', 'participant' ,$result['id'] ) ) );
819            }
820       }
821       
822     
823       
824   }
825
826    //TODO: Remover apos suporte a deepness na api
827    public function deepnessReadEvent( &$uri , &$result , &$criteria , $original ){             
828   
829       if(isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0)
830       {
831            if(isset($result['id']))
832            {
833                $result['participants'] = Controller::find( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('=' ,  'schedulable' ,  $result['id']), 'deepness' => $original['criteria']['deepness'] - 1) );
834
835                $repeat =  Controller::find( array( 'concept' => 'repeat' ), false, array( 'filter' => array( '=', 'schedulable', $result['id'] ) ) );
836
837                if(is_array($repeat))
838                    $result['repeat'] = $repeat[0];
839            }
840           
841       }
842       
843       if(isset($result['id']) && $result['type'] == '2'){
844           $result['historic'] =  Controller::find( array( 'concept' => 'calendarHistoric' ), false, array( 'filter' => array( '=', 'schedulable', $result['id'] ) ) );
845       }
846   }
847   
848    //TODO: Remover apos suporte a deepness na api
849    public function deepnessFindParticipant( &$uri , &$result , &$criteria , $original ){
850       if(isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0)
851       {
852           foreach ($result as $i => &$v)
853           {
854                self::deepnessReadParticipant( $uri, $v, $criteria, $original );
855           }
856       } 
857       
858   }
859
860    //TODO: Remover apos suporte a deepness na api
861    public function deepnessReadCalendarSignature(&$uri, &$result, &$criteria, $original) {
862
863        if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0)
864            if (isset($result['calendar'])) {
865                $result['calendar'] = Controller::read(array('concept' => 'calendar', 'id' => $result['calendar']));
866                $result['defaultAlarms'] = Controller::find(array('concept' => 'calendarSignatureAlarm'), false, array('filter' => array('=', 'calendarSignature', $result['id'])));
867            }
868    }
869
870    //TODO: Remover apos suporte a deepness na api
871    public function deepnessFindCalendarSignature(&$uri, &$result, &$criteria, $original) {
872
873        if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0) {
874            foreach ($result as $i => $v) {
875                if (isset($v['calendar'])) {
876                    $result[$i]['calendar'] = Controller::read(array('concept' => 'calendar', 'id' => $v['calendar']), false, false);
877                    $result[$i]['defaultAlarms'] = Controller::find(array('concept' => 'calendarSignatureAlarm'), false, array('filter' => array('=', 'calendarSignature', $v['id'])));
878                    //Caso não seja o dono da agenda retorna o objeto permission com as acls
879                    if ($result[$i]['isOwner'] == 0) {
880                        $permission = Controller::find(array('concept' => 'calendarToPermission'), false, array('filter' => array('AND', array('=', 'calendar', $v['calendar']), array('=', 'user', Config::me('uidNumber')))));
881
882                        if (!is_array($permission) || !$permission) {
883
884                            $permission = Controller::find(array('concept' => 'calendarToPermission'), false, array('filter' => array('AND', array('=', 'calendar', $v['calendar']), array('=', 'type', '1'))));
885                        }
886                        $result[$i]['permission'] = $permission[0];
887                    }
888                }
889                //TODO - Padronizar retorno do deepness
890                if (isset($v['user']))
891                    $result[$i]['user'] = Controller::read(array('concept' => 'user', 'id' => $v['user']), false, false);
892            }
893        }
894    }
895
896//Decode Find       
897    public function decodeFindConcept(&$uri, &$result, &$criteria, $original) {
898        if ($result && is_array($result)) {
899            $m = array_flip(self::${$uri['concept'] . 'Map'});
900            $new = array();
901            foreach ($result as $i => $v)
902                $new[$i] = self::parseConcept($result[$i], $m);
903
904
905            $result = $new;
906        }
907    }
908
909    public function decodeFindSchedulable(&$uri, &$result, &$criteria, $original) {
910        if ($result && is_array($result)) {
911            $m = array_flip(self::${$uri['concept'] . 'Map'});
912            $m['calendar_id'] = 'calendar';
913            $new = array();
914            foreach ($result as $i => $v)
915                $new[$i] = self::parseConcept($result[$i], $m);
916
917
918            $result = $new;
919        }
920    }
921
922    public function decodeFindAttachment(&$uri, &$result, &$criteria, $original) {
923        if (isset($result))
924            foreach ($result as $key => &$value)
925                $value['source'] = base64_decode($value['source']);
926    }
927
928    public function decodeSignatureAlarmType(&$uri, &$result, &$criteria, $original) {
929        if (is_array($result))
930            foreach ($result as &$param)
931                if (isset($param['type']))
932                    $param['type'] = self::decodeAlarmType($param['type']);
933    }
934
935/////////////////////////////////////////////////////////////////////////
936
937    static function decodeParticipantsEvent( &$uri, $result, &$criteria, $original) {
938        $participants = Controller::find( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('=', 'schedulable'  ,  $result['id']) ));
939
940        if($participants && ($size = count($participants)) < 100){
941            if(isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0){
942                self::deepnessFindParticipant($uri, $participants, $criteria, $original);
943                 $participants['attendees'] = $participants;
944            }
945           
946        }else if($participants && ($size = count($participants)) > 100){
947            $owner = Controller::read( array( 'concept' => 'calendarSignature' ) , false ,array( 'filter' => array('AND', array('=', 'calendar'  ,  $result['calendar']), array('=', 'isOwner', '1'))));
948            $owner = Controller::read( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('AND', array('=', 'schedulable'  ,  $result['id']), array('=', 'user', $owner[0]['user'])), 'deepness' => 2));
949
950            if(is_array($owner))
951                $owner = $owner[0];
952
953            $reference = array_slice($participants, 0, 100);
954            $organizer = false;
955            $asOwner = false;
956
957            foreach($reference as $r => &$v){
958                if($v['id'] == $owner['id']){
959                    $v = $owner;
960                    $asOwner = true;
961                    continue;
962                }
963
964                self::deepnessReadParticipant($uri, $v, $criteria, $original);
965
966                if($v['isOrganizer'] == "1" )
967                    $organizer = $v;
968            }
969
970            if(!$organizer){
971                $organizer = Controller::find( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('AND', array('=', 'schedulable'  ,  $result['id']), array('=', 'isOrganizer', '1')), 'deepness' => 2));
972
973                array_push($reference, $organizer[0]);
974
975            }else if($organizer && ($organizer['id'] != $owner['id']))
976                array_merge($reference, $organizer);
977
978            if(!$asOwner)
979                array_push($reference, $owner);
980
981            $statusAttendees = array( 'default' => 0, 'accepted' => 0, 'tentative' => 0, 'cancelled' => 0, 'unanswered' => 0, 'delegated' => 0 );
982            $statusLabels = array( 'default', 'accepted', 'tentative', 'cancelled', 'unanswered', 'delegated' );
983
984            foreach($participants as $k => &$p){
985                if(!$organizer && $p['isOrganizer'] == "1"){
986                    self::deepnessReadParticipant($uri, $p, $criteria, $original);
987                    $reference = array_merge($reference, array($p));
988                }
989
990                $statusAttendees[$statusLabels[$p['status']]]++;
991            }
992
993            $participants['statusAttendees'] = $statusAttendees;
994            $participants['sizeAttendees'] = $size;
995            $participants['attendees'] = $reference;
996        }
997       
998        return $participants;
999    }
1000   
1001    static function dayAlarm( &$uri , &$params , &$criteria , $original ) {
1002        if(isset($criteria['filter'][1]) && $criteria['filter'][1] == 'date')
1003        {
1004            $target = $criteria['filter'][2];
1005
1006            $params = array();
1007
1008            $al = Controller::service('PostgreSQL')->execSql("SELECT distinct co.id as \"id\", co.cal_uid as \"uid\", co.type_id as \"type\", co.dtstart as \"startTime\", co.summary as \"summary\", co.description as \"description\", co.dtend as \"endTime\", co.location as \"location\", co.allday as \"allDay\", co.transp as transparent, co.class_id as class, ".
1009                "co.range_start as \"rangeStart\", co.range_end as \"rangeEnd\", co.last_update as \"lastUpdate\", co.dtstamp as \"dtstamp\", co.sequence as \"sequence\", co.tzid as \"timezone\", CASE WHEN rep.object_id = co.id THEN occ.occurrence - al.alarm_offset ELSE co.dtstart - al.alarm_offset END as \"sendTime\", ".
1010                "al.unit as \"unit\", al.time as \"time\" FROM calendar_alarm as al, calendar_object as co, calendar_repeat as rep, calendar_repeat_occurrence as occ, calendar_participant as part WHERE ".
1011                "al.action_id = '".ALARM_ALERT."' AND al.sent = '0' AND ( (al.participant_id = part.id) AND (part.user_info_id = '". Config::me('uidNumber') ."') ) AND part.object_id = co.id AND ".
1012                "CASE WHEN rep.object_id = co.id ".
1013                "THEN rep.id = occ.repeat_id AND occ.occurrence - al.alarm_offset >= '$target' AND occ.occurrence - al.alarm_offset <= '".( $target + 86400000)."' ".
1014                "ELSE (co.range_start - al.alarm_offset) >= '$target' AND (co.range_start - al.alarm_offset) <= '".( $target + 86400000)."' END");
1015           
1016            if(is_array($al))
1017              foreach( $al as $v )
1018                $params[] = array('schedulable' =>  $v);
1019             
1020            else
1021              $params = false;
1022 
1023            return false;
1024        }
1025    }
1026   
1027    static private function countMyCalendarsEvent($id, $owner) {
1028                $sig = Controller::find(array('concept' => 'calendarSignature'), array('user', 'calendar', 'isOwner'), array('filter' => array('AND', array('=', 'isOwner', '1'), array('=', 'user', $owner))));
1029                $calendars = array();
1030                foreach ($sig as $val)
1031                        $calendars[] = $val['calendar'];
1032
1033                $return = Controller::find(array('concept' => 'calendarToSchedulable'), null, array('filter' => array('AND', array('IN', 'calendar', $calendars), array('=', 'schedulable', $id))));
1034
1035                return (isset($return[0])) ? count($return) : 0;
1036    }
1037   
1038    public function deleteSchedulable(&$uri, &$params, &$criteria, $original) {
1039        if (Config::module('useCaldav', 'expressoCalendar'))
1040            require_once ROOTPATH . '/modules/calendar/interceptors/DAViCalAdapter.php';
1041       
1042        if(isset($criteria['filter']) && $criteria['filter'] && isset($criteria['filter'][1][2])){
1043            $idSchedulable = $criteria['filter'][1][2];
1044            $idCalendar = $criteria['filter'][2][2];
1045            $owner = $criteria['filter'][3][2];
1046
1047            $qtdMyCalendars = self::countMyCalendarsEvent($idSchedulable, $owner);
1048
1049            $link = Controller::read(array('concept' => 'calendarToSchedulable'), false, array('filter' => array('AND', array('=','calendar',$idCalendar), array('=','schedulable',$idSchedulable))));
1050            $link = (is_array($link) && isset($link[0])) ? $link[0] : $link;
1051           
1052            $calendar = Controller::read(array('concept' => 'calendar'), false, array('filter' => array('=','id',$idCalendar)));
1053            $calendar = (is_array($calendar) && isset($calendar[0])) ? $calendar[0] : $calendar;
1054
1055            if($isAttende = !self::ownerSchedulable($idSchedulable, $owner)){
1056                Controller::delete(array('concept' => 'calendarToSchedulable', 'id' => $link['id']));
1057               
1058                if($qtdMyCalendars <= 1){
1059
1060                    $participant = Controller::read(array('concept' => 'participant'), array('id'), array('filter' =>
1061                        array('AND',
1062                            array('=', 'user', $owner),
1063                            array('=', 'schedulable', $idSchedulable)
1064                        )));
1065
1066                    Controller::call(('update'), array('concept' => 'participant', 'id' => $participant[0]['id']), array('status' => STATUS_CANCELLED));
1067                }
1068
1069            }else{
1070                if($qtdMyCalendars > 1 )
1071                    Controller::delete(array('concept' => 'calendarToSchedulable', 'id' => $link['id']));
1072            }
1073
1074            if (Config::module('useCaldav', 'expressoCalendar'))
1075                    DAViCalAdapter::deleteEvent($idSchedulable, array('location' => $calendar['location']));
1076
1077            if($isAttende || ($qtdMyCalendars > 1))
1078                return false;
1079
1080            $uri['id'] = $idSchedulable;
1081           
1082            if(isset($criteria['filter']) && isset($criteria['filter'][4]) && isset($criteria['filter'][4][2])){
1083                Controller::deleteALL(array('concept' => 'taskToActivity'), null, array('filter' => array('=', 'activity', $idSchedulable)));
1084            }
1085        }
1086       
1087    }
1088
1089    public function deleteCalendarToPermissionDependences(&$uri, &$params, &$criteria, $original) {
1090        $permission = Controller::read($uri, array('user', 'calendar'));
1091
1092        $calendarSignature = Controller::find(array('concept' => 'calendarSignature'), array('id'), array('filter' => array('AND', array('=', 'calendar', $permission['calendar']), array('=', 'user', $permission['user']), array('=', 'isOwner', '0'))));
1093
1094        if ($calendarSignature)
1095            Controller::delete(array('concept' => 'calendarSignature', 'id' => $calendarSignature[0]['id']));
1096    }
1097
1098    public function deleteCalendarSignatureDependences(&$uri, &$params, &$criteria, $original) {
1099        $signature = Controller::read($uri, array('isOwner', 'calendar'));
1100
1101        if ($signature['isOwner'] == '1') {
1102            $calendarToSchedulables = Controller::find(array('concept' => 'calendarToSchedulable'), null, array('filter' => array('=', 'calendar', $signature['calendar'])));
1103
1104            $schedulables = array();
1105            if (is_array($calendarToSchedulables))
1106                foreach ($calendarToSchedulables as $key => $calendarToSchedulable)
1107                    $schedulables[] = $calendarToSchedulable['schedulable'];
1108
1109            if (!empty($schedulables))
1110                        Controller::deleteALL(array('concept' => 'schedulable'), null, array('filter' => array('IN', 'id', $schedulables)));
1111
1112            Controller::delete(array('concept' => 'calendar', 'id' => $signature['calendar']));
1113               
1114                $permissions = Controller::find(array('concept' => 'calendarToPermission'), array('id'), array('filter' => array('=', 'calendar', $signature['calendar'])));
1115
1116               
1117               
1118                if($permissions && count($permissions) > 0){
1119                        $ids = array();
1120                        foreach($permissions as $key => $value)
1121                                array_push($ids, $value['id']);
1122               
1123                        Controller::deleteALL(array('concept' => 'calendarToPermission'), null, array('filter' => array('IN', 'id', $ids)));
1124                       
1125                }
1126               
1127               
1128        }
1129    }
1130
1131    public function decodeSchedulablettachment(&$uri, &$params, &$criteria, $original) {
1132        if (isset($original['URI']['id'])){
1133            $schedulableAttachment = Controller::read(array('concept' => 'schedulableToAttachment'), false, array('filter' => array( '=', 'attachment' , $original['URI']['id'] )));
1134            $uri['id'] = $schedulableAttachment[0]['id'];
1135
1136            $params = $schedulableAttachment[0];
1137
1138            $event = Controller::read(array('concept' => 'schedulable', 'id' => $params['schedulable']));
1139            if($event['type'] == '2')
1140                $criteria['historic']['attachment'] = $schedulableAttachment[0];
1141
1142        }
1143    }
1144
1145    public function deleteAttachmentDependences(&$uri, &$params, &$criteria, $original) {
1146        Controller::delete(array('concept' => 'attachment', 'id' => (isset($params['attachment']) ? $params['attachment'] : $original['URI']['id'])));
1147    }
1148   
1149    public function decodeDeleteCalendarSignatureAlarm(&$uri, &$params, &$criteria, $original) {
1150                if ($original['URI']['id'] == '' && isset($original['criteria']['filter'])){
1151                        Controller::deleteAll(array('concept' => 'calendarSignatureAlarm'), null,$original['criteria']);
1152                        return false;
1153                }
1154    }
1155
1156
1157     public function createDefaultGroup(&$uri, &$result, &$criteria, $original) {
1158        if( $original['criteria']['filter'][1][0] == '=' &&
1159        $original['criteria']['filter'][1][1] == 'user' &&
1160        $original['criteria']['filter'][1][2] == $_SESSION['phpgw_session']['account_id']){
1161
1162            $existDefaultGroup = false;
1163
1164            foreach($result as $v){
1165                if($v['type'] == 1 && $v['calendar']['type'] == 1)
1166                    $existDefaultGroup = true;
1167            }
1168
1169            if(!$existDefaultGroup){
1170
1171                $cal = array('name' => 'Sem grupo',
1172                    'description' => 'Sem grupo',
1173                    'timezone' => (date_default_timezone_get()) ? date_default_timezone_get() : 'America/Sao_Paulo',
1174                    'dtstamp' => time() . '000',
1175                    'type' => '1'
1176                );
1177
1178                $calCreated = Controller::create(array('concept' => 'calendar'), $cal);
1179
1180                $sig = array('user' => $_SESSION['wallet']['user']['uidNumber'],
1181                    'calendar' => $calCreated['id'],
1182                    'isOwner' => '1',
1183                    'dtstamp' => time() . '000',
1184                    'fontColor' => 'FFFFFF',
1185                    'backgroundColor' => '3366CC',
1186                    'borderColor' => '3366CC',
1187                    'type' => '1'
1188                );
1189
1190                $sigCreated = Controller::create(array('concept' => 'calendarSignature'), $sig);
1191                $sigCreated = Controller::read(array('concept' => 'calendarSignature', 'id' => $sigCreated['id']), false, array('deepness' => 2 ));
1192
1193                array_push($result, $sigCreated);
1194            }
1195
1196        }
1197
1198     }
1199
1200    public function createDefaultSignature(&$uri, &$result, &$criteria, $original) {
1201
1202    if(count($result) == 0 && isset($criteria['filter'][3]) && isset($criteria['filter'][3]['isRecursion'])){
1203        throw new Exception('It was not possible to find to calendar!');
1204        return false;
1205    }
1206
1207        //Caso uma busca não retorne nenhum resultado e foi buscado pelas assinaturas do usuario logado apenas
1208        $isValidSignature = false;
1209
1210        //Veirifica pois o usuário pode ter varias assinaturas mas não ser dona de nenhuma
1211        if (count($result) > 0) {
1212            foreach ($result as $value) {
1213                if (isset($value['isOwner']) && $value['isOwner'] != 0)
1214                    $isValidSignature = true;
1215
1216            }
1217        }
1218
1219        if (!$isValidSignature &&
1220                ( $original['criteria']['filter'][1][0] == '=' &&
1221                $original['criteria']['filter'][1][1] == 'user' &&
1222                $original['criteria']['filter'][1][2] == $_SESSION['phpgw_session']['account_id']
1223                )) {
1224
1225            if (Config::module('useCaldav', 'expressoCalendar')) {
1226                require_once ROOTPATH . '/modules/calendar/interceptors/DAViCalAdapter.php';
1227                $calendario = DAViCalAdapter::findCalendars();
1228            }
1229
1230            if (Config::module('useCaldav', 'expressoCalendar') && is_array($calendario) && count($calendario) > 0) {
1231                foreach ($calendario as $i => $v) {
1232
1233                    $urlA = explode('/', $v->url);
1234                    $name = isset($v->displayname) ? $v->displayname : $urlA[(count($urlA) - 2)];
1235                    $cal = array('name' => $name,
1236                        'description' => isset($v->description) ? $v->description : $name,
1237                        'timezone' => isset($v->timezone) ? $v->timezone : (date_default_timezone_get()) ? date_default_timezone_get() : 'America/Sao_Paulo',
1238                        'dtstamp' => time() . '000',
1239                        'location' => $urlA[(count($urlA) - 3)] . '/' . $urlA[(count($urlA) - 2)]
1240                    );
1241
1242                    $calCreated = Controller::create(array('concept' => 'calendar'), $cal);
1243
1244                if(!$calCreated){
1245                    throw new Exception('Error to create calendar');
1246                    return false;
1247                }
1248
1249                    $sig = array('user' => $_SESSION['wallet']['user']['uidNumber'],
1250                        'calendar' => $calCreated['id'],
1251                        'isOwner' => '1',
1252                        'dtstamp' => time() . '000',
1253                        'fontColor' => 'FFFFFF',
1254                        'backgroundColor' => '3366CC',
1255                        'borderColor' => '3366CC',
1256                    );
1257
1258                    $sigCreated = Controller::create(array('concept' => 'calendarSignature'), $sig);
1259
1260                if(!$sigCreated){
1261                    throw new Exception('Error to create signature');
1262                    return false;
1263                }
1264
1265                    DAViCalAdapter::importCollection($v->url, $calCreated['id']);
1266                }
1267            } else {
1268                //Criaremos uma agenda padrão
1269                $cal = array('name' => 'Calendario',
1270                    'description' => 'Calendario Padrão',
1271                    'timezone' => (date_default_timezone_get()) ? date_default_timezone_get() : 'America/Sao_Paulo',
1272                    'dtstamp' => time() . '000'
1273                );
1274
1275                $calCreated = Controller::create(array('concept' => 'calendar'), $cal);
1276
1277                $sig = array('user' => $_SESSION['wallet']['user']['uidNumber'],
1278                    'calendar' => $calCreated['id'],
1279                    'isOwner' => '1',
1280                    'dtstamp' => time() . '000',
1281                    'fontColor' => 'FFFFFF',
1282                    'backgroundColor' => '3366CC',
1283                    'borderColor' => '3366CC',
1284                );
1285
1286                $sigCreated = Controller::create(array('concept' => 'calendarSignature'), $sig);
1287        }
1288   
1289        $original['criteria']['filter'][] = array('isRecursion' => true);
1290        $result = Controller::find($original['URI'], $original['properties'] ? $original['properties'] : null, $original['criteria']);
1291            return false;
1292        }
1293    }
1294
1295    //TODO - Criar conceito separado para participantes externos e remover o criterio notExternal
1296    public function findExternalPaticipants(&$uri, &$result, &$criteria, $original) {
1297        if (Config::me('uidNumber') && !isset($criteria['notExternal'])) {
1298            $newuri['concept'] = 'user';
1299            $newuri['service'] = 'PostgreSQL';
1300
1301            $newCriteria = $original['criteria'];
1302            $valid = true;
1303
1304            $newCriteria['filter'] = array('AND', $newCriteria['filter'], array('=', 'owner', Config::me('uidNumber')));
1305            $externalUsers = Controller::find($newuri, $original['properties'] ? $original['properties'] : null, $newCriteria);
1306
1307            if (is_array($externalUsers)) {
1308                foreach ($externalUsers as $i => $v)
1309                    $externalUsers[$i]['isExternal'] = '1';
1310            }
1311            else
1312                $externalUsers = array();
1313
1314            if (!is_array($result))
1315                $result = array();
1316
1317            return array_merge($result, $externalUsers);
1318        }
1319    }
1320
1321    public function davcalCreateCollection(&$uri, &$params, &$criteria, $original) {
1322        if (Config::module('useCaldav', 'expressoCalendar')) {
1323            require_once ROOTPATH . '/modules/calendar/interceptors/DAViCalAdapter.php';
1324            DAViCalAdapter::mkcalendar($params['location'], $params['name'], isset($params['description']) ? $params['description'] : '' );
1325           }
1326    }
1327
1328    public function davcalDeleteCollection(&$uri, &$params, &$criteria, $original) {
1329        if (Config::module('useCaldav', 'expressoCalendar') && Config::module('onRemoveCascadeCalDav')) {
1330            require_once ROOTPATH . '/modules/calendar/interceptors/DAViCalAdapter.php';
1331            $calendar = Controller::read($uri);
1332            DAViCalAdapter::rmCalendar($calendar['location']);
1333        }
1334    }
1335
1336    public function davcalUpdateCollection(&$uri, &$params, &$criteria, $original) {
1337        if (Config::module('useCaldav', 'expressoCalendar')) {
1338            require_once ROOTPATH . '/modules/calendar/interceptors/DAViCalAdapter.php';
1339            if (isset($params['location'])) {
1340                $calendar = Controller::read($uri);
1341                if ($calendar['location'] !== $params['location'])
1342                    DAViCalAdapter::mvcalendar($calendar['location'], $params['location']);
1343            }
1344        }
1345    }
1346
1347    private static function _makeUid() {
1348
1349        $date = date('Ymd\THisT');
1350        $unique = substr(microtime(), 2, 4);
1351        $base = 'aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPrRsStTuUvVxXuUvVwWzZ1234567890';
1352        $start = 0;
1353        $end = strlen($base) - 1;
1354        $length = 6;
1355        $str = null;
1356        for ($p = 0; $p < $length; $p++)
1357            $unique .= $base{mt_rand($start, $end)};
1358
1359        return $date . $unique . '@expresso-calendar';
1360    }
1361
1362    private function getStatus($id) {
1363        $a = array(
1364            STATUS_CONFIRMED => 'CONFIRMED',
1365            STATUS_CANCELLED => 'CANCELLED',
1366            STATUS_TENATIVE => 'TENATIVE',
1367            STATUS_UNANSWERED => 'NEEDS-ACTION',
1368            STATUS_DELEGATED => 'DELEGATED'
1369        );
1370        return $a[$id];
1371    }
1372
1373    private static function decodeAlarmType($id) {
1374        $a = array(ALARM_ALERT => 'alert',
1375            ALARM_MAIL => 'mail',
1376            ALARM_SMS => 'sms');
1377
1378        return $a[$id];
1379    }
1380
1381    private static function codeAlarmType($type) {
1382        $a = array('alert' => ALARM_ALERT,
1383            'mail' => ALARM_MAIL,
1384            'sms' => ALARM_SMS);
1385
1386        return $a[$type];
1387    }
1388
1389    private static function codeAlarmUnit($u) {
1390        if ($u === 'd')
1391            return 'days';
1392        if ($u === 'm')
1393            return 'minutes';
1394        if ($u === 'H')
1395            return 'hours';
1396    }
1397
1398    private static function ownerSchedulable($id, $me) {
1399
1400        $isOwner = Controller::find(array('concept' => 'participant'), array('id'), array('filter' =>
1401                    array('AND',
1402                        array('=', 'isOrganizer', '1'),
1403                        array('=', 'user', $me),
1404                        array('=', 'schedulable', $id)
1405                        )));
1406
1407        return ( isset($isOwner[0]['id']) ) ? true : false;
1408    }
1409   
1410   
1411    private static function referenceCalendarToObject($schedulable, $calendar) {
1412        return Controller::service('PostgreSQL')->execResultSql('SELECT calendar_to_calendar_object.id as calendar_to_calendar_Object FROM calendar_to_calendar_object'
1413            . ' WHERE calendar_to_calendar_object.calendar_id = '. $calendar
1414            . ' AND calendar_to_calendar_object.calendar_object_id = ' . addslashes($schedulable));
1415    }
1416   
1417    private static function schedulable2calendarToObject($Schedulable) {
1418        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, calendar.id as calendar_id FROM calendar_to_calendar_object , calendar , calendar_signature'
1419                        . ' WHERE calendar_signature.user_uidnumber = ' . $_SESSION['wallet']['user']['uidNumber']
1420                        //      .' AND calendar_signature.is_owner = 1'
1421                        . ' AND calendar_signature.calendar_id = calendar.id'
1422                        . ' AND calendar_to_calendar_object.calendar_id = calendar.id'
1423                        . ' AND calendar_to_calendar_object.calendar_object_id = ' . addslashes($Schedulable));
1424    }
1425
1426    protected static function isAllowDeleteInCalendar($calendar) {
1427        $f = Controller::find(array('concept' => 'calendarToPermission'), false, array('filter' => array('AND', array('=', 'user', Config::me('uidNumber')), array('=', 'calendar', $calendar))));
1428        return (strpos($f[0]['acl'], CALENDAR_ACL_REMOVE) === false) ? false : true;
1429    }
1430
1431}
1432
1433?>
Note: See TracBrowser for help on using the repository browser.