Changeset 6945 for sandbox/2.4.2-expresso1/prototype/modules/calendar/interceptors

Timestamp:

08/06/12 10:03:03 (12 years ago)

Author:

acoutinho

Message:

Ticket #2966 - Criacao de atividades com suporte a alarmes e anexos

File:

• sandbox/2.4.2-expresso1/prototype/modules/calendar/interceptors/DBMapping.php (modified) (5 diffs)

sandbox/2.4.2-expresso1/prototype/modules/calendar/interceptors/DBMapping.php

@@ -150 +150 @@
                 .'calendar FROM calendar_to_calendar_object , calendar_object '
                 .'WHERE ( calendar_to_calendar_object.calendar_id IN (\'' . implode('\',\'', $criteria['filter'][2][2]) . '\')) '
-                .'AND calendar_to_calendar_object.calendar_object_id = calendar_object.id ';    
+                .'AND calendar_to_calendar_object.calendar_object_id = calendar_object.id '
+        .'AND calendar_object.id NOT IN(select calendar_object_task_id from calendar_task_to_activity_object where owner = \'' . Config::me('uidNumber') . '\') ';      
             
             if(isset($criteria['searchEvent']) && $criteria['searchEvent']){
@@ -180 +181 @@
                 $params = array_merge($params, $occ);           
             }
+            $params = self::deepnessFindEvent($uri, $params, $criteria, $original);
+            return false;
+        }
+    }
+
+    public function findTask(&$uri, &$params, &$criteria, $original) {
+
+        ob_start();
+        print_r('$uri' . "\n");
+        print_r($uri);
+        print_r('$params' . "\n");
+        print_r($params);
+        print_r('$criteria' . "\n");
+        print_r($criteria);
+        print_r('$original' . "\n");
+        print_r($original);
+        $output = ob_get_clean();
+        file_put_contents( "/tmp/acoutinho.log",  $output , FILE_APPEND);
+        if (isset($criteria['filterTasks']) && $criteria['filterTasks']) {
+
+            $sql = ' SELECT calendar_object.id as id ,calendar_object.cal_uid as "uid", calendar_object.type_id as "type", '
+            .'calendar_object.dtstart as "startTime", calendar_object.summary as "summary", '
+            .'calendar_object.description as "description", calendar_object.dtend as "endTime" , '
+            .'calendar_object.priority as "priority", calendar_object.due as "due", '
+            .'calendar_object.percentage as "percentage", calendar_object.status as "status", '
+            .'calendar_object.location as "location", calendar_object.allday as "allDay", '
+            .'calendar_object.transp as "transparent", calendar_object.class_id as "class", '
+            .'calendar_object.repeat as "repeat", calendar_object.range_start as "rangeStart", '
+            .'calendar_object.range_end as "rangeEnd", calendar_object.last_update as "lastUpdate", '
+            .'calendar_object.dtstamp as "dtstamp", calendar_object.sequence as "sequence", '
+            .'calendar_object.tzid as "timezone" ,calendar_to_calendar_object.calendar_id as '
+            .'calendar FROM calendar_to_calendar_object , calendar_object '
+            .'WHERE ( calendar_to_calendar_object.calendar_id IN (\'' . implode('\',\'', $criteria['filter'][3][2]) . '\')) '
+            .'AND calendar_to_calendar_object.calendar_object_id = calendar_object.id '
+        .'AND calendar_to_calendar_object.calendar_object_id NOT IN (select calendar_object_activity_id from calendar_task_to_activity_object where owner =  \'' . Config::me("uidNumber") . '\' ) '    
+        .'AND calendar_to_calendar_object.calendar_object_id NOT IN (select calendar_object_task_id from calendar_task_to_activity_object where owner =  \'' . Config::me("uidNumber") . '\' ) ';    
+
+        if(isset($criteria['filter'][4]))
+            $sql .= 'AND (((upper("summary") like upper(\'%'.$criteria['filter'][4][1][2].'%\') OR upper("description") like upper(\'%'.$criteria['filter'][4][1][2].'%\'))))';
+
+            $sql .= 'AND (range_start >= \'' . $criteria['filter'][2][2] . '\' AND type_id <= \'' .  $criteria['filter'][1][2] . '\')';
+
+            $params = Controller::service('PostgreSQL')->execResultSql($sql);
             $params = self::deepnessFindEvent($uri, $params, $criteria, $original);
             return false;
@@ -495 +539 @@
     }
 
+    //TODO: Remover apos suporte a ManytoMany na api 
+    public function createTasksToActivity(&$uri, &$result, &$criteria, $original) {
+
+        ob_start();
+        print_r('$uri' . "\n");
+        print_r($uri);
+        print_r('$params' . "\n");
+        print_r($params);
+        print_r('$criteria' . "\n");
+        print_r($criteria);
+        print_r('$original' . "\n");
+        print_r($original);
+        $output = ob_get_clean();
+        file_put_contents( "/tmp/acoutinho.log",  $output , FILE_APPEND);
+
+        if(isset($original['properties']['taskToActivity']) && $original['properties']['taskToActivity']){
+
+            foreach($original['properties']['taskToActivity'] as $relational)
+
+                Controller::create(array('concept' => 'taskToActivity'), array('task' => $relational['task'], 'owner' => $relational['owner'], 'activity' => $result['id']));
+
+        }
+    }
+
     public function createCreateSchedulableToAttachment(&$uri, &$params, &$criteria, $original) {
         if (array_key_exists('attachments', $original['properties']))
@@ -541 +609 @@
 
     //TODO: Remover apos suporte a deepness na api 
+    public function deepnessFindTask(&$uri, &$result, &$criteria, $original) {
+        if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0) 
+           foreach($result as &$value)
+                $value['task'] = Controller::read(array('concept' => 'schedulable', 'id' => $value['task']));
+           
+        
+        return $result;
+    }
+
+
+
+    //TODO: Remover apos suporte a deepness na api 
     public function deepnessFindEvent(&$uri, &$result, &$criteria, $original) {
         if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0) {
@@ -572 +652 @@
 
                 $result[$i]['DayLigth'] = $DayLigth;
+
+        if(((int)$v['type']) == 2){
+
+            $taskToActivity = Controller::find(array('concept' => 'taskToActivity'), false, array('filter' => array('AND', array('=', 'activity', $v['id']), array('=','owner', Config::me('uidNumber'))) , 'deepness' => 2));
+
+            if($taskToActivity)
+                $result[$i]['taskToActivity'] = $taskToActivity;
+
+        }
 
                 if (isset($v['id'])) {