Changeset 503 for trunk/contactcenter/inc/class.so_main.inc.php

Timestamp:

10/01/08 16:46:55 (16 years ago)

Author:

niltonneto

Message:

Implementação para trazer os contatos compartilhados.

File:

• trunk/contactcenter/inc/class.so_main.inc.php (modified) (1 diff)

trunk/contactcenter/inc/class.so_main.inc.php

@@ -205 +205 @@
                                 }
                         }
-
-                        $query = $query_main_select . $query_main_from . $query_main_where;
-
+                        
+                        if($table_main!='') { //Quando faço checkout e não incluo a tabela principal, a função precisa funcionar...
+                                $query = $query_main_select . $query_main_from . $query_main_where;
+        
 //                      echo 'Query in SO_Main CheckOut: "'.$query.'"<br>';
-                        
-                        if (!$this->db->query($query,__LINE__, __FILE__))
-                        {
-                                return false;
-                        }
-                        
-                        if (!$this->db->next_record())
-                        {
-                                return false;
-                        }
-                        
-                        reset($this->db_tables[$table_main]['fields']);
-
-                        while (list(,$field_info) = each($this->db_tables[$table_main]['fields']))
-                        {
-                                $this->db_tables[$table_main]['fields'][$field_info['name']]['value'] = $this->db->f($field_info['name']);
-                                $this->manage_fields($this->db_tables[$table_main]['fields'][$field_info['name']], 'sync');
-                        }
-
+                                
+                                if ($this->db->query($query,__LINE__, __FILE__)) {
+                                        if ($this->db->next_record()) {
+                                                reset($this->db_tables[$table_main]['fields']);
+                        
+                                                while (list(,$field_info) = each($this->db_tables[$table_main]['fields']))
+                                                {
+                                                        $this->db_tables[$table_main]['fields'][$field_info['name']]['value'] = $this->db->f($field_info['name']);
+                                                        $this->manage_fields($this->db_tables[$table_main]['fields'][$field_info['name']], 'sync');
+                                                }
+                                        }
+                                }
+                        }
+                        //echo "\n\n\n".$query_multi_select;
                         foreach($query_multi_select as $table => $query)
                         {
+                                
                                 $query = $query_multi_select[$table] . $query_multi_from[$table] . $query_multi_where[$table];
 
-                                if (!$this->db->query($query, __LINE__, __FILE__))
-                                {
-                                        return false;
-                                }
-                                
-                                $pos = 0;
-                                while($this->db->next_record())
-                                {
-                                        reset($this->db_tables[$table]['fields']);                                      
-                                        while (list(,$field_info) = each($this->db_tables[$table]['fields']))
-                                        {
-                                                $this->db_tables[$table]['fields'][$field_info['name']]['values'][$pos] = $this->db->f($field_info['name']);
-                                                $this->manage_fields($this->db_tables[$table]['fields'][$field_info['name']], 'sync', 'new');
+                                //echo 'Query in SO_Main CheckOut: "'.$query.'"<br>';
+                                if ($this->db->query($query, __LINE__, __FILE__)) {
+                                        $pos = 0;
+                                        while($this->db->next_record())
+                                        {
+                                                reset($this->db_tables[$table]['fields']);                                      
+                                                while (list(,$field_info) = each($this->db_tables[$table]['fields']))
+                                                {
+                                                        $this->db_tables[$table]['fields'][$field_info['name']]['values'][$pos] = $this->db->f($field_info['name']);
+                                                        $this->manage_fields($this->db_tables[$table]['fields'][$field_info['name']], 'sync', 'new');
+                                                }
+                                                $pos++;
                                         }
                                         $pos++;