Changeset 413 for trunk/expressoMail1_2/inc/class.db_functions.inc.php

Timestamp:

09/11/08 16:42:44 (16 years ago)

Author:

rafaelraymundo

Message:

Melhoria implementada, relativo a ocorrencia #314 da comunidade.
Contatos dinamicos no envio de emails de forma configuravel.

File:

• trunk/expressoMail1_2/inc/class.db_functions.inc.php (modified) (4 diffs)

trunk/expressoMail1_2/inc/class.db_functions.inc.php

@@ -3 +3 @@
 define('PHPGW_API_INC','../phpgwapi/inc');      
 include_once(PHPGW_API_INC.'/class.db.inc.php');
-        
+include_once('class.dynamic_contacts.inc.php');
+
 class db_functions
 {       
@@ -142 +143 @@
         }
 
-        function get_dropdown_contacts(){
+        function get_dropdown_contacts()
+        {
+                $dynamic_contact = new dynamic_contacts();
                 
                 $contacts = $this -> get_cc_contacts();
                 $groups = $this -> get_cc_groups();
+                $dynamic = $dynamic_contact->dynamic_contact_toString();
                 
                 if(($contacts) && ($groups))
@@ -155 +159 @@
                 elseif ((!$contacts) && ($groups))
                         $stringDropDownContacts = $groups;
-                                        
+                if (($dynamic) && (($groups) || ($contacts)))
+                        $stringDropDownContacts .= ',' . $dynamic;
+                else 
+                        if ($dynamic)
+                                $stringDropDownContacts = $dynamic;
+                                
                 return $stringDropDownContacts; 
         }
@@ -257 +266 @@
                 return $result;
         }
+        
+        function get_dynamic_contacts()
+        {                               
+                // Pesquisa os emails e ultima inserção nos contatos dinamicos.
+                if(!$this->db->select('phpgw_expressomail_contacts','data',
+                                                  'id_owner ='.$this -> user_id,
+                                                  __LINE__,__FILE__))
+                {
+                return $this->db->Error;
+        }
+                while($this->db->next_record())
+                {
+                        $result[] = $this->db->row();
+                }
+                foreach($result as $item) 
+                {
+                        $contacts = unserialize($item['data']);
+                }
+                if (count($contacts) == 0)
+                {                       
+                        return null;
+                }       
+                return $contacts;
+        }
+        
+        function update_contacts($contacts=array())
+        {                       
+                // Atualiza um email nos contatos dinamicos.
+                if(!$this->db->update('phpgw_expressomail_contacts ','data=\''.serialize($contacts).'\'',
+                                                          'id_owner ='.$this -> user_id,
+                                                          __LINE__,__FILE__))
+                {
+                        return $this->db->Error;
+                }
+        return $contacts;
+        }       
+        
+        function insert_contact($contact)       
+        {
+                $contacts[] = array( 'timestamp'        => time(),
+                                                                'email'         => $contact );
+
+                // Insere um email nos contatos dinamicos.      
+                $query = 'INSERT INTO phpgw_expressomail_contacts (data, id_owner)  ' .
+                                        'values ( \''.serialize($contacts).'\', '.$this->user_id.')';
+                
+                if(!$this->db->query($query,__LINE__,__FILE__))
+                return $this->db->Error;
+        return $contacts;
+        }
+        
+        function remove_dynamic_contact($user_id,$line,$file)
+        {
+                $where = $user_id.' = id_owner';
+                $this->db->delete('phpgw_expressomail_contacts',$where,$line,$file);    
+        }
 }
 ?>