Changeset 5737 for trunk/prototype/modules/calendar/interceptors/DBMapping.php

Timestamp:

03/15/12 16:41:03 (12 years ago)

Author:

natan

Message:

Ticket #2434 - Supressao da primeira ocorrencia de uma repeticao quando seu evento base se enquadra na mesma

File:

• trunk/prototype/modules/calendar/interceptors/DBMapping.php (modified) (2 diffs)

trunk/prototype/modules/calendar/interceptors/DBMapping.php

@@ -107 +107 @@
           $end = $criteria['filter'][2][2];
 
-         $sql = ' SELECT calendar_object.id as id ,calendar_object.cal_uid as "uid", calendar_object.type_id as "type", calendar_object.dtstart as "startTime", calendar_object.summary as "summary", calendar_object.description as "description", calendar_object.dtend as "endTime" , calendar_object.location as "location", calendar_object.allday as "allDay", calendar_object.transp as "transparent", calendar_object.class_id as "class", calendar_object.repeat as "repeat", calendar_object.range_start as "rangeStart",calendar_object.range_end as "rangeEnd", calendar_object.last_update as "lastUpdate", calendar_object.dtstamp as "dtstamp", calendar_object.sequence as "sequence",  calendar_object.tzid as "timezone" ,calendar_to_calendar_object.calendar_id as calendar FROM calendar_to_calendar_object , calendar_object WHERE (range_start >= \''.$start.'\' AND range_end <= \''.$end.'\' AND calendar_to_calendar_object.calendar_id IN (\''.  implode('\',\'', $criteria['filter'][3][2]).'\')) AND calendar_to_calendar_object.calendar_object_id = calendar_object.id';
-         
+          $ids = array();
+          $occ = array();
+
+          if( $occurrences = self::checkOccurrences( $start, $end, intval($criteria['deepness']) + 1 ) )
+              foreach( $occurrences as $id => $occurrence )
+              {
+                  $ids[] = $id;
+                  $occ[] = $occurrence;
+              }
+
+         $sql = ' SELECT calendar_object.id as id ,calendar_object.cal_uid as "uid", calendar_object.type_id as "type", calendar_object.dtstart as "startTime", calendar_object.summary as "summary", calendar_object.description as "description", calendar_object.dtend as "endTime" , calendar_object.location as "location", calendar_object.allday as "allDay", calendar_object.transp as "transparent", calendar_object.class_id as "class", calendar_object.repeat as "repeat", calendar_object.range_start as "rangeStart",calendar_object.range_end as "rangeEnd", calendar_object.last_update as "lastUpdate", calendar_object.dtstamp as "dtstamp", calendar_object.sequence as "sequence",  calendar_object.tzid as "timezone" ,calendar_to_calendar_object.calendar_id as calendar FROM calendar_to_calendar_object , calendar_object WHERE (range_start >= \''.$start.'\' AND range_end <= \''.$end.'\' AND calendar_to_calendar_object.calendar_id IN (\''.  implode('\',\'', $criteria['filter'][3][2]).'\')) AND calendar_to_calendar_object.calendar_object_id = calendar_object.id'.( !empty($ids) ? ' AND calendar_object.id NOT IN (\'' .implode( '\',\'', $ids ). '\')' : '');
+
          $params = Controller::service('PostgreSQL')->execResultSql($sql);
          $params = self::deepnessFindEvent( &$uri , &$params , &$criteria , $original);
-
-         $occ = self::checkOccurrences( $criteria['filter'][1][2], $criteria['filter'][2][2], intval($criteria['deepness']) + 1 );
-
-         if( $occ )
-            $params = array_merge( $params, $occ );
+ 
+         $params = array_merge( $params, $occ );
 
          return false;
@@ -252 +259 @@
               {
                     $result[ $currentId ] = $ret['repeat']['schedulable'];
+                    $result[ $currentId ]['repeat']['schedulable'] = $currentId;
+
                     $result[ $currentId ][ 'occurrences' ] = array();
-  
+
                     $calendarToCalendarObj = self::schedulable2calendarToObject( $currentId );
 
-                    $result[ $currentId ]['calendar'] = $calendarToCalendarObj[0]['calendar_id'];
-
-                    unset( $result[ $currentId ]['repeat'] );
+                    $result[ $currentId ]['calendar'] = $calendarToCalendarObj[0]['calendar_id'];  
               }
       
               $result[ $currentId  ][ 'occurrences' ][] = $ret['occurrence'];
-
         }
 
-        foreach( $result as $id => $res )
-            $params[] = $res;
-
-        return( $params );
+        return( $result );
     }