Changeset 7393 for branches/2.4
- Timestamp:
- 10/09/12 18:31:51 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.4/prototype/mapDisponibility.php
r6069 r7393 44 44 .' OR (range_start <= '.$data['startTime'].' AND range_end >= '.$data['endTime'].') )' 45 45 .' AND transp = 0 AND id IN ( SELECT calendar_object_id from calendar_to_calendar_object where ' 46 .'calendar_id IN (SELECT calendar_id FROM calendar_signature WHERE (user_uidnumber = '. $value['id'] .' AND is_owner = 1 )) ))'; 46 .'calendar_id IN (SELECT calendar_id FROM calendar_signature WHERE (user_uidnumber = '. $value['id'] .' AND is_owner = 1 )) )' 47 .'AND (calendar_object.id NOT IN (SELECT calendar_object_activity_id FROM calendar_task_to_activity_object)' 48 .'OR calendar_object.type_id = 1))'; 47 49 48 50 $result = Controller::service('PostgreSQL')->execResultSql($sql);
Note: See TracChangeset
for help on using the changeset viewer.