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

Revision 7028, 60.8 KB checked in by acoutinho, 12 years ago (diff)

Ticket #3032 - Nao e enviado email de confirmacao de participacao de participante externo em tarefa

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