 |
| << | February 2010 | >> |
| Su |
Mo |
Tu |
We |
Th |
Fr |
Sa |
| |
1 |
2 |
3 |
4 |
5 |
6 |
| 7 |
8 |
9 |
10 |
11 |
12 |
13 |
| 14 |
15 |
16 |
17 |
18 |
19 |
20 |
| 21 |
22 |
23 |
24 |
25 |
26 |
27 |
| 28 |
|
|
|
|
|
 |
|
|
|
 faton Post subject: Group contacts associate emails
|
Thu Aug 28, 2008 11:37 pm
Posts: 28
|
| |
 |
I have all my contacts assigned to different groups. With the current version of the outlook plugin it is possible to associate emails only to the contacts that are assigned to you (user).
I made a minor change to enable the association of emails to the contacts that are assigned to your group and wanted to share with you.
In Contacts.php, in the function get_searchbyemailid($username,$emailaddress) remove completely this line of code
| Code: | | inner join vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid |
If you also want to get from search only the contacts with the exact name and surname, in the same function change:
| Code: | | $query .= " and ((vtiger_contactdetails.email like '". formatForSqlLike($emailaddress) ."') or vtiger_contactdetails.lastname REGEXP REPLACE('".$emailaddress."',' ','|') or vtiger_contactdetails.firstname REGEXP REPLACE('".$emailaddress."',' ','|')) and vtiger_contactdetails.email != ''"; |
to
| Code: | $query .= " and ((vtiger_contactdetails.email like '". formatForSqlLike($emailaddress) ."') or vtiger_contactdetails.lastname REGEXP REPLACE('".$emailaddress."',' ','|') and vtiger_contactdetails.firstname REGEXP REPLACE('".$emailaddress."',' ','|')) and vtiger_contactdetails.email != ''";
|
I am not an experienced PHP guy so I would be happy to hear your thoughts on the change.
The problem that I face now, is that when I go to the particular contact and click the email that was associated, I see only the To: field but not the cc. Will check it later - suggestions are welcomed.
HTH,
F.
|
|
|
|
|
 |
marica Post subject: Re: Group contacts associate emails
|
Thu Apr 02, 2009 9:41 am
Posts: 10
|
| |
|
| Thanks a lot!
|
|
|
|
|
|
|
|
