Changeset 6437 for sandbox/2.4.1-3/prototype/modules/catalog/interceptors/DBMapping.php

Timestamp:

06/06/12 15:15:49 (12 years ago)

Author:

gustavo

Message:

Ticket #2766 - Ajustado padrao das hipermedias e reajuste de recursos

File:

• sandbox/2.4.1-3/prototype/modules/catalog/interceptors/DBMapping.php (modified) (2 diffs)

sandbox/2.4.1-3/prototype/modules/catalog/interceptors/DBMapping.php

@@ -1 @@
-<?php
+ <?php
 
 //Definindo Constantes
@@ -13 +13 @@
     public function findConnections(&$uri, &$params, &$criteria, $original) {
 
-        if(count($params)>0 && isset($params[0]['id'])){
-                for($i=0; $i < count($params); $i++){
-                        //Retorna o telefone e o e-mail padrao de um determinado contato
-                        $sql = ' SELECT phpgw_cc_contact_conns.id_typeof_contact_connection as type, phpgw_cc_connections.connection_value as value '
-                                .'FROM phpgw_cc_contact_conns '
-                                .'JOIN phpgw_cc_connections '
-                                .'ON (phpgw_cc_connections.id_connection = phpgw_cc_contact_conns.id_connection) '
-                                .'WHERE phpgw_cc_contact_conns.id_contact = ' . $params[$i]['id'] . ' AND '
-                                .'phpgw_cc_connections.connection_is_default = TRUE ';
+                if(count($params)>0 && isset($params[0]['id'])){
+                        for($i=0; $i < count($params); $i++){
+                                //Retorna o telefone e o e-mail padrao de um determinado contato
+                                $sql = ' SELECT phpgw_cc_contact_conns.id_typeof_contact_connection as type, phpgw_cc_connections.connection_value as value '
+                                        .'FROM phpgw_cc_contact_conns '
+                                        .'JOIN phpgw_cc_connections '
+                                        .'ON (phpgw_cc_connections.id_connection = phpgw_cc_contact_conns.id_connection) '
+                                        .'WHERE phpgw_cc_contact_conns.id_contact = ' . $params[$i]['id'] . ' AND '
+                                        .'phpgw_cc_connections.connection_is_default = TRUE ';
 
-                        $array = Controller::service('PostgreSQL')->execResultSql($sql);
-                        if(count($array)>0){
-                                foreach($array as $connection){
-                                        switch($connection['type']){
-                                                case TYPE_EMAIL         : $params[$i][INDEX_EMAIL]      = $connection['value']; break;
-                                                case TYPE_TELEPHONE     : $params[$i][INDEX_TELEPHONE]  = $connection['value']; break;
-                                        
-                                                default                 : $params[$i][INDEX_EMAIL] = $params[$i][INDEX_TELEPHONE] = '';
+                                $array = Controller::service('PostgreSQL')->execResultSql($sql);
+                                if(count($array)>0){
+                                        foreach($array as $connection){
+                                                switch($connection['type']){
+                                                        case TYPE_EMAIL         : $params[$i][INDEX_EMAIL]      = $connection['value']; break;
+                                                        case TYPE_TELEPHONE     : $params[$i][INDEX_TELEPHONE]  = $connection['value']; break;
+                                                        default                 : $params[$i][INDEX_EMAIL] = $params[$i][INDEX_TELEPHONE] = '';
+                                                }
+
                                         }
-
+                                }
+                                else{
+                                        $params[$i][INDEX_EMAIL] = $params[$i][INDEX_TELEPHONE] = '';
                                 }
                         }
-                        else{
-                                $params[$i][INDEX_EMAIL] = $params[$i][INDEX_TELEPHONE] = '';
+                }
+    }
+
+        public function findGroupConnections(&$uri, &$params, &$criteria, $original) {
+
+                if(count($params)>0 && isset($params[0]['id'])){
+                $z = 0;
+                $count = count($params);
+                for($i=0; $i < $count; $i++){
+                                //Retorna o telefone e o e-mail padrao de um determinado contato
+                                $sql = 'SELECT contato.names_ordered as name, contato.id_contact as id, conexao.connection_value as value '
+                                        .'FROM phpgw_cc_groups grupo '
+                                        .'JOIN phpgw_cc_contact_grps grupo_contato '
+                                        .'ON (grupo.id_group = grupo_contato.id_group) '
+                                        .'JOIN phpgw_cc_connections conexao '
+                                        .'ON (grupo_contato.id_connection = conexao.id_connection) '
+                                        .'JOIN phpgw_cc_contact_conns conexaoCon '
+                                        .'ON (conexao.id_connection = conexaoCon.id_connection) '
+                                        .'JOIN phpgw_cc_contact contato '
+                                        .'ON (contato.id_contact = conexaoCon.id_contact) '
+                                        .'WHERE grupo.id_group = ' . $params[$i]['id'] . ' AND '
+                                        .'conexao.connection_is_default = TRUE';
+
+                                $array = Controller::service('PostgreSQL')->execResultSql($sql);
+
+                                if(count($array)>0){
+                                        $params[$i]['contacts'][$z] = array();
+                                        foreach($array as $connection){
+                                                $params[$i]['contacts'][$z]['id'] = $connection['id'];          
+                                                $params[$i]['contacts'][$z]['name'] = $connection['name'];                                                      
+                                                $params[$i]['contacts'][$z][INDEX_EMAIL] = $connection['value'];                                                        
+                                                $z++;
+                                        }
+                                }
+                                else{
+                                        $params[$i][INDEX_EMAIL] = '';
+                                }
                         }
                 }
-        }
-        return false;
     }
-
+        
 }