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

Timestamp:

11/03/11 13:24:28 (12 years ago)

Author:

wmerlotto

Message:

Ticket #2305 - Enviando alteracoes, desenvolvidas internamente na Prognus, do modulo ExpressoMail?.

File:

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

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

@@ -210 +210 @@
         
         function get_dropdown_contacts(){
-                
-                $contacts = $this -> get_cc_contacts();
-                $groups = $this -> get_cc_groups();
+                $contacts = $this->get_cc_contacts();
+                $groups = $this->get_cc_groups();
                 
                 if(($contacts) && ($groups))
@@ -223 +222 @@
                         $stringDropDownContacts = $groups;
                                         
-                if($_SESSION['phpgw_info']['user']['preferences']['expressoMail']['number_of_contacts'] &&
-                        $_SESSION['phpgw_info']['user']['preferences']['expressoMail']['use_dynamic_contacts']) {
+                if($_SESSION['phpgw_info']['user']['preferences']['expressoMail']['use_dynamic_contacts']) {
                         // Free others requests 
                         session_write_close(); 
@@ -270 +268 @@
         {                               
                 // 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__))
+                if(!$this->db->select('phpgw_expressomail_contacts','data','id_owner ='.$this->user_id,__LINE__,__FILE__))
                 {
                 return $this->db->Error;
@@ -295 +291 @@
         function update_contacts($contacts=array())
         {                       
+                
+        
+                if(!$this->db->select('phpgw_expressomail_contacts','data','id_owner ='.$this->user_id,__LINE__,__FILE__))
+        {
+            $result['dberr1'] = $this->db->Error;
+        }
+                $regs = array();
+                while($this->db->next_record())
+        {
+            $regs[] = $this->db->row();
+        }
+                $old_contatacts = array();
+                foreach($regs as $old){
+                        $old_contatacts = unserialize($old['data']);
+                }
+                 
+                foreach($old_contatacts as $i => $v)
+                        foreach($contacts as $ii => $vv)
+                                if(trim($v['email']) == trim($vv['email']))
+                                        unset($old_contatacts[$i]);
+                
+                 
+                 $old_contatacts = array_merge( $old_contatacts , $contacts);           
                 // Atualiza um email nos contatos dinamicos.
-                if(!$this->db->update('phpgw_expressomail_contacts ','data=\''.serialize($contacts).'\'',
-                        'id_owner ='.$this -> user_id,
-                        __LINE__,__FILE__))
+                if(!$this->db->update('phpgw_expressomail_contacts ','data=\''.serialize($old_contatacts).'\'','id_owner ='.$this->user_id,__LINE__,__FILE__))
                 {
                         return $this->db->Error;
@@ -344 +361 @@
                 $msg_part = $params['msg_part'];
                 $msg_folder = $params['msg_folder'];
+            $from_ajax = $params['from_ajax'];
                 $encoding = strtolower($params['encoding']);
                 $fileContent = "";
-
-                if($msg_number && $msg_part && $msg_folder && (intval($idx_file == '0' ? '1' : $idx_file))) {
-                        $mbox_stream = $objImap->open_mbox($msg_folder);        
-                        $fileContent = imap_fetchbody($mbox_stream, $msg_number, $msg_part, FT_UID);
-                        include_once('class.imap_attachment.inc.php');
-                        $imap_attachment = new imap_attachment();
-                        $a = $imap_attachment->download_attachment($mbox_stream, $msg_number);
-                        $filename = $a[$idx_file]['name'];
+            $cirus_delimiter = $params['cirus_delimiter'];
+            $expFolder = explode($cirus_delimiter, $msg_folder);
+
+            if($msg_number != null && $msg_part != null && $msg_folder != null && (intval($idx_file == '0' ? '1' : $idx_file)))
+            {
+                require_once $_SESSION['rootPath'].'/expressoMail1_2/inc/class.attachment.inc.php';
+                $attachmentObj = new attachment();
+                $attachmentObj->setStructureFromMail($msg_folder,$msg_number);
+                $fileContent = $attachmentObj->getAttachment($msg_part);
+                $info = $attachmentObj->getAttachmentInfo($msg_part);
+                $filename = $info['name'];
                 }
                 else
                         $filename = $idx_file;
                                         
-                if($fileContent) {
-                        if($encoding == 'base64')
-                                $calendar = imap_base64($fileContent);
-                        else if($encoding == 'quoted-printable')
-                                $calendar = quoted_printable_decode($fileContent);
-                        else
-                                $calendar = $fileContent;
-                }
                 // It's necessary to access calendar method. 
+            $GLOBALS['phpgw_info']['flags']['noappheader'] = True;
+            $GLOBALS['phpgw_info']['flags']['noappfooter'] = True;
+            $GLOBALS['phpgw_info']['flags']['currentapp'] = 'calendar';
                 include_once(PHPGW_INCLUDE_ROOT.'/header.inc.php'); 
-                        
                 $uiicalendar = CreateObject("calendar.uiicalendar");
-                return $uiicalendar = $uiicalendar->import_from_mail($calendar);
+
+            if(strtoupper($expFolder[0]) == 'USER' && $expFolder[1]) // IF se a conta o ical estiver em uma conta compartilhada
+            {
+                include_once('class.ldap_functions.inc.php');
+                $ldap = new ldap_functions();
+                $account['uid'] = $expFolder[1];
+                $account['uidnumber']  = $ldap->uid2uidnumber($expFolder[1]);
+                $account['mail']  = $ldap->getMailByUid($expFolder[1]);
+
+                return $uiicalendar->import_from_mail($fileContent, $from_ajax,$account);
+            }
+            else
+                return $uiicalendar->import_from_mail($fileContent, $from_ajax);
+            
+            
         }
 
@@ -439 +468 @@
         }
 
+        
+        /**
+     * @abstract Recupera o valor da regra padrão.
+     * @return retorna o valor da regra padrão.
+     */
+        function get_default_max_size_rule()
+        {
+                $query = "SELECT config_value FROM phpgw_config WHERE config_name = 'expressoAdmin_default_max_size'";
+                if(!$this->db->query($query))
+            return false;
+
+        $return = array();
+                        
+                while($this->db->next_record())
+            array_push($return, $this->db->row());
+                        
+                return $return;
+        }
+        
+        /**
+     * @abstract Recupera a regra de um usuário.
+     * @return retorna a regra que o usuário pertence. Caso o usuário não participe de nenhuma regra, retorna false.
+     */
+        function get_rule_by_user($id_user) 
+        {
+                $return = array();      
+                $query = "SELECT email_max_recipient FROM phpgw_expressoadmin_configuration WHERE email_user='$id_user' AND configuration_type='MessageMaxSize'";
+                
+                if(!$this->db->query($query))
+            return false;
+                
+                while($this->db->next_record())
+            array_push($return, $this->db->row());
+                        
+                return $return;
+        }
+        
+        
+        function get_rule_by_user_in_groups($id_group)
+        {
+                $return = array();
+                $query = "SELECT email_max_recipient FROM phpgw_expressoadmin_configuration WHERE configuration_type='MessageMaxSize' AND email_user_type='G' AND email_user='".$id_group."'";
+
+                if(!$this->db->query($query))   
+                        return false;   
+                        
+                while($this->db->next_record())
+                        array_push($return, $this->db->row());
+
+                return $return; 
+        }
+        function getMaximumRecipientsUser($pUserUID)
+        {
+
+           $query = 'SELECT email_max_recipient FROM phpgw_expressoadmin_configuration WHERE email_user = \''.$pUserUID.'\' AND configuration_type = \'LimitRecipient\' AND email_user_type = \'U\' ';
+           $this->db->query($query);
+
+           $return = array();
+
+            while($this->db->next_record())
+              $return =  $this->db->row();
+
+            return $return['email_max_recipient'];
+        }
+
+        function getMaximumRecipientsGroup($pGroupsGuidnumbers)
+        {
+           $groupsGuidNumbers = '';
+
+           foreach ($pGroupsGuidnumbers as $guidNumber => $cn)
+             $groupsGuidNumbers .= $guidNumber.', ';
+
+           $groupsGuidNumbers = substr($groupsGuidNumbers,0,-2);
+
+           $query = 'SELECT email_max_recipient FROM phpgw_expressoadmin_configuration WHERE email_user IN ('.$groupsGuidNumbers.') AND configuration_type = \'LimitRecipient\' AND email_user_type = \'G\' ';
+           $this->db->query($query);
+
+           $return = array();
+
+            while($this->db->next_record())
+              $return[] =  $this->db->row();
+
+            $maxSenderReturn = 0;
+
+            foreach ($return as $maxSender)
+            {
+                if($maxSender['email_max_recipient'] > $maxSenderReturn)
+                    $maxSenderReturn = $maxSender['email_max_recipient'];
+            }
+
+            return $maxSenderReturn;
+        }
+
+        function validadeSharedAccounts($user,$grups,$accountsMails)
+        {
+
+             $arrayMailsBlocked = array();
+
+             $query = 'SELECT * FROM phpgw_expressoadmin_configuration WHERE email_user = \''.$user.'\' AND email_recipient = \'*\'  AND configuration_type = \'InstitutionalAccountException\' AND email_user_type = \'U\' ';
+             $this->db->query($query);
+             $this->db->next_record();
+                 if($this->db->row())
+                   return $arrayMailsBlocked;
+
+            foreach ($grups as $guidNumber => $cn)
+            {
+                 $query = 'SELECT * FROM phpgw_expressoadmin_configuration WHERE email_user = \''.$guidNumber.'\' AND email_recipient = \'*\'  AND configuration_type = \'InstitutionalAccountException\' AND email_user_type = \'G\' ';
+                 $this->db->query($query);
+                 $this->db->next_record();
+                 if($this->db->row())
+                     return $arrayMailsBlocked;
+
+            }
+
+            foreach ($accountsMails as $mail)
+            {
+               
+               $blocked = true;
+
+               $query = 'SELECT * FROM phpgw_expressoadmin_configuration WHERE email_recipient = \''.$mail.'\' AND configuration_type = \'InstitutionalAccountException\' ';
+               $this->db->query($query);
+           
+                while($this->db->next_record())
+                {
+                    $row =  $this->db->row();
+                    
+                    if(($row['email_user'] == '*' ||  $row['email_user'] == $user) && ($row['email_user_type'] == 'T' || $row['email_user_type'] == 'U'))
+                        $blocked = false;
+                    else if(array_key_exists($row['email_user'], $grups) && $row['email_user_type'] == 'G')
+                         $blocked = false; 
+
+                }
+
+                if($blocked == true)
+                    array_push ($arrayMailsBlocked, $mail);
+            }
+
+            return $arrayMailsBlocked;
+        }
+
 }
 ?>