Changeset 7393 for branches/2.4


Ignore:
Timestamp:
10/09/12 18:31:51 (11 years ago)
Author:
eduardow
Message:

Ticket #3153 - Inconsistência na matriz de disponibilidade da agenda

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/2.4/prototype/mapDisponibility.php

    r6069 r7393  
    4444                        .' OR (range_start <=  '.$data['startTime'].' AND range_end >= '.$data['endTime'].') )' 
    4545                        .' 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))'; 
    4749 
    4850                        $result = Controller::service('PostgreSQL')->execResultSql($sql); 
Note: See TracChangeset for help on using the changeset viewer.