Changeset 7978 for branches/2.5/prototype/modules/calendar/interceptors/DBMapping.php

Timestamp:

03/07/13 09:51:27 (11 years ago)

Author:

douglas

Message:

Ticket #3371 - Corrigido query de busca de evento para melhor atender a agendas compartilhadas

File:

• branches/2.5/prototype/modules/calendar/interceptors/DBMapping.php (modified) (1 diff)

branches/2.5/prototype/modules/calendar/interceptors/DBMapping.php

@@ -943 +943 @@
                 .'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)';
+                .'WHERE ( calendar_object.id = '. $criteria['schedulable'] .' AND calendar_to_calendar_object.calendar_object_id = calendar_object.id' 
+                .' AND calendar_to_calendar_object.calendar_id IN (select calendar_id from calendar_signature where calendar_signature.user_uidnumber = '. Config::me('uidNumber') .' )         )'; 
 
             $params = Controller::service('PostgreSQL')->execResultSql($sql);