Changeset 4754

Timestamp:

07/14/11 17:14:49 (13 years ago)

Author:

roberto.santosjunior

Message:

Ticket #1820 - Incluir Contato Compartilhado duplicado. r4599

Location:

trunk/contactcenter/inc

Files:

• class.bo_group.inc.php (modified) (1 diff)
• class.so_group.inc.php (modified) (1 diff)
• class.ui_data.inc.php (modified) (3 diffs)

trunk/contactcenter/inc/class.bo_group.inc.php

@@ -45 +45 @@
                 
                         $result = $this-> so -> verifyContact($email, $name, $phone);
+                        return $result;
+                }
+
+                function verify_shared_contact($owner,$email){
+
+                        $result = $this-> so -> verifySharedContact($owner,$email);
                         return $result;
                 }

trunk/contactcenter/inc/class.so_group.inc.php

@@ -492 +492 @@
                         return $return;
                 }               
-                
+
+                function verifySharedContact($owner,$email)
+                {
+                        $query = 'select A.names_ordered, C.id_connection from phpgw_cc_contact A,'.
+                        'phpgw_cc_contact_conns B, phpgw_cc_connections C where '.
+                        'A.id_contact = B.id_contact and B.id_connection = C.id_connection '.
+                        'and B.id_typeof_contact_connection = 1 and '.
+                        'A.id_owner ='.$owner.' and C.connection_value = \''.$email.'\'';
+
+                        if (!$this->db->query($query))
+                        {
+                                exit ('Query failed! File: '.__FILE__.' on line'.__LINE__);
+                        }
+
+                        $return = false;
+
+                        while($this->db->next_record())
+                        {
+                                $row = $this->db->row();
+                                $return[] =  $row['names_ordered'];
+                                $return[] =  $row['id_connection'];
+                        }
+
+                        return $return;
+                }
+
                 function selectContactsByGroup($idGroup)
                 {

trunk/contactcenter/inc/class.ui_data.inc.php

@@ -2289 +2289 @@
                         foreach($data as $field => $value)
                         {
+                                $dataConn = $data['connections'];
+                                $aa = count($dataConn);
+
+                                for($i = 0; $i < $aa; $i++ )
+                                {
+                                    if($dataConn['connection'.$i]['connection_is_default'] == "TRUE")
+                                    {
+                                        $email = $dataConn['connection'.$i]['connection_value'];
+                                    }
+                                }
+                                // verifica se email já existe!
+                                $boGroup = CreateObject('contactcenter.bo_group');
+                                $contact = $boGroup->verify_contact($email);
+                                if($contact)
+                                {
+                                    $str_contact = "\r\n - ".implode("\r\n - ",$contact);
+                                    echo serialize(array(
+                                    'msg'    => lang('Problems on adding your Contact. The email "%1" already exists in: %2',$tdata[4], $str_contact),
+                                    'status' => 'alreadyExists'
+                                    ));
+                                    return;
+                                }
 
                                 switch($field)
@@ -2578 +2600 @@
                         foreach($data as $field => &$value)
                         {
+
+                                $dataConn = $data['connections'];
+                                $aa = count($dataConn);
+
+                                for($i = 0; $i < $aa; $i++ )
+                                {
+                                    if($dataConn['connection'.$i]['connection_is_default'] == "TRUE")
+                                    {
+                                        $email = $dataConn['connection'.$i]['connection_value'];
+                                    }
+                                }
+                                // verifica se email já existe!
+                                $boGroup = CreateObject('contactcenter.bo_group');
+                                $contact = $boGroup->verify_shared_contact($owner,$email);
+                                if($contact)
+                                {
+                                    $str_contact = "\r\n - ".implode("\r\n - ",$contact);
+                                    echo serialize(array(
+                                    'msg'    => lang('Problems on adding your Contact. The email "%1" already exists in: %2',$tdata[4], $str_contact),
+                                    'status' => 'alreadyExists'
+                                    ));
+                                    return;
+                                }
+
                                 if ($value == '' or is_null($value))
                                 {
@@ -2700 +2746 @@
                                         case 'connections':
                                                 /* Does nothing... */
+                                                $aaaa = 1111;
                                                 break;