Changeset 7869 for sandbox/2.5.1-expresso2/prototype/modules/calendar/interceptors/DBMapping.php

Timestamp:

02/06/13 16:33:31 (11 years ago)

Author:

eduardow

Message:

Ticket #3341 - Implementacao da DFD0151 - Nova funcionalidade ao alterar o grupo de uma atividade

File:

• sandbox/2.5.1-expresso2/prototype/modules/calendar/interceptors/DBMapping.php (modified) (5 diffs)

sandbox/2.5.1-expresso2/prototype/modules/calendar/interceptors/DBMapping.php

@@ -599 +599 @@
                     $isAllDay = 1;
 
+                    $taskToActivity = Controller::find(array('concept' => 'taskToActivity'), false, array('filter' => array('AND', array('=', 'activity', $taskToActivity[0]['activity']), array('=', 'owner', Config::me('uidNumber'))), 'deepness' => 2));
+
                     if(!empty($activity)){
                         $start = $params['startTime'];
                         $end = $params['endTime'];
                         foreach($taskToActivity as $t){
-                         if($t['task']['id'] != $params['id']){
-                            $start = $t['task']['startTime'] < $start ? $t['task']['startTime'] : $start;
-                            $end = $t['task']['endTime'] > $end ? $t['task']['endTime'] : $end;
-                            $isAllDay = (($isAllDay == 1) && ($t['task']['allDay'] == '1')) ? 1 : 0;
+                         if($t['task']['id'] != $params['id']){ 
+                             $start = $t['task']['startTime'] < $start ? $t['task']['startTime'] : $start; 
+                             $end = $t['task']['endTime'] > $end ? $t['task']['endTime'] : $end; 
+                             $isAllDay = (($isAllDay == 1) && ($t['task']['allDay'] == '1')) ? 1 : 0; 
                          }
                         }
@@ -841 +843 @@
     }
 
+    //Função que traz o 'calendar'(grupo) das tarefas.
+    public function getCalendarTask( $task ){
+
+        $sql = 'select co.calendar_id as "calendar" from calendar_to_calendar_object as "co", calendar_signature as "cs" where cs.user_uidnumber = '. Config::me('uidNumber') 
+        .' AND cs.is_owner = 1 AND cs.calendar_id = co.calendar_id AND co.calendar_object_id = '. $task;
+
+
+        $returns = Controller::service('PostgreSQL')->execResultSql($sql);
+
+        return $returns[0]['calendar'];
+
+    }
+
     //TODO: Remover apos suporte a deepness na api 
     public function deepnessFindTask(&$uri, &$result, &$criteria, $original) {
-        if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0) 
-           foreach($result as &$value)
+
+        if (isset($criteria['deepness']) && $criteria['deepness'] != 0){ 
+              foreach($result as &$value){
                 $value['task'] = Controller::read(array('concept' => 'schedulable', 'id' => $value['task']));
-           
+                $value['task']['calendar'] = self::getCalendarTask( $value['task']['id'] );    
+
+            }
         
         return $result;
     }
+    }
 
     //TODO: Remover apos suporte a deepness na api 
     public function deepnessFindHistoric(&$uri, &$result, &$criteria, $original) {
-        if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0) {
+        if (isset($criteria['deepness']) && $criteria['deepness'] != 0) {
             foreach($result as &$v){
                 $v['user'] = Controller::read(array('concept' => 'user', 'id' => $v['user']));
@@ -883 +902 @@
                 .'calendar_object.range_end as "rangeEnd", calendar_object.last_update as "lastUpdate", '
                 .'calendar_object.dtstamp as "dtstamp", calendar_object.sequence as "sequence", '
-                .'calendar_object.tzid as "timezone" '
-                .'FROM calendar_object '
-                .'WHERE ( calendar_object.id = '. $criteria['schedulable'] .')';
+                .'calendar_object.tzid as "timezone", calendar_to_calendar_object.calendar_id as "calendar" ' 
+                .'FROM calendar_object, calendar_to_calendar_object ' 
+                .'WHERE ( calendar_object.id = '. $criteria['schedulable'] .' AND calendar_to_calendar_object.calendar_object_id = calendar_object.id)';
+
 
             $params = Controller::service('PostgreSQL')->execResultSql($sql);
+
+            foreach( $params as &$event ){ 
+                if(isset( $event['repeat'] ) && isset( $event['repeat']['id'] ) ){ 
+                    $occurrences = Controller::service('PostgreSQL')->execResultSql('SELECT DISTINCT occurrence FROM calendar_object as "c", calendar_repeat_occurrence as "o", calendar_repeat as "r" WHERE r.object_id = '. $event['id'] .' AND o.repeat_id = r.id ' ); 
+   
+                    if($occurrences){ 
+                        $event['occurrences'] = array(); 
+
+                        foreach($occurrences as $o) 
+                            $event['occurrences'][] = $o['occurrence']; 
+                    }else 
+                        unset( $event['occurrences'] ); 
+                } 
+            }
 
             $params = self::deepnessFindEvent($uri, $params, $criteria, $original);
@@ -899 +933 @@
     //TODO: Remover apos suporte a deepness na api 
     public function deepnessFindEvent(&$uri, &$result, &$criteria, $original) {
-        if ((isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0) ) {
+        if ((isset($criteria['deepness']) && $criteria['deepness'] != 0) ) {
 
             $date = new DateTime('now', new DateTimeZone('UTC'));
@@ -988 +1022 @@
     public static function deepnessReadParticipant( &$uri , &$result , &$criteria , $original ){
         
-       if(isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0)
+       if(isset($criteria['deepness']) && $criteria['deepness'] != 0)
        {
             if(isset($result['id']) && isset($result['user']))