Changeset 7804 for trunk/prototype/modules/calendar/schedules.php
- Timestamp:
- 01/30/13 10:26:33 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/prototype/modules/calendar/schedules.php
r7789 r7804 18 18 class Schedule{ 19 19 20 function findEventsRange( $start, $end, $calendars, $timezones ){20 function findEventsRange( $start, $end, $calendars, $timezones ){ 21 21 22 22 $sql = … … 57 57 .'AND calendar_object.dtstart NOT IN (SELECT calendar_repeat_occurrence.occurrence from calendar_repeat_occurrence, ' 58 58 .'calendar_repeat where (calendar_repeat_occurrence.repeat_id = calendar_repeat.id) ' 59 .'AND (calendar_repeat.object_id = calendar_object.id)) group by calendar_object.id, calendar_to_calendar_object.calendar_id ';59 .'AND (calendar_repeat.object_id = calendar_object.id)) group by calendar_object.id, calendar_to_calendar_object.calendar_id ORDER BY calendar_object.dtstart'; 60 60 61 61 $params = Controller::service('PostgreSQL')->execResultSql($sql.$where);
Note: See TracChangeset
for help on using the changeset viewer.