Changeset 7804 for trunk

Timestamp:

01/30/13 10:26:33 (11 years ago)

Author:

cristiano

Message:

Ticket #3328 - Lista de eventos e tarefas do ExpressoCalendar? não está ordenada adequadamente

File:

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

trunk/prototype/modules/calendar/schedules.php

@@ -18 +18 @@
 class Schedule{
 
-    function findEventsRange( $start, $end, $calendars, $timezones ){
+    function findEventsRange( $start, $end, $calendars, $timezones  ){
 
         $sql =
@@ -57 +57 @@
                 .'AND calendar_object.dtstart NOT IN (SELECT calendar_repeat_occurrence.occurrence from calendar_repeat_occurrence, '
                 .'calendar_repeat where (calendar_repeat_occurrence.repeat_id = calendar_repeat.id) '
-                .'AND (calendar_repeat.object_id = calendar_object.id)) group by calendar_object.id, calendar_to_calendar_object.calendar_id';
+                .'AND (calendar_repeat.object_id = calendar_object.id)) group by calendar_object.id, calendar_to_calendar_object.calendar_id ORDER BY calendar_object.dtstart';
 
         $params = Controller::service('PostgreSQL')->execResultSql($sql.$where);