Created
October 27, 2012 09:52
-
-
Save vaseker/3963830 to your computer and use it in GitHub Desktop.
Vtiger 5.4.0 Comments show to group's members
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* -ComGroup- */ | |
$rec=intval($_REQUEST['record']); | |
if($rec>0){ | |
$owner=$this->db->query("select smownerid from vtiger_crmentity where crmid=$rec"); | |
$owner=$this->db->query_result($owner, 0, 0); | |
$sec_query .= " (vtiger_crmentity.smownerid IN ( | |
select vtiger_user2role.userid from vtiger_user2role where vtiger_user2role.roleid IN | |
(select vtiger_group2role.roleid | |
from vtiger_group2role | |
where | |
vtiger_group2role.groupid=$owner | |
AND | |
vtiger_group2role.groupid IN ( | |
select vtiger_group2role.groupid | |
from vtiger_group2role | |
where vtiger_group2role.roleid IN ( | |
select vtiger_user2role.roleid | |
from vtiger_user2role | |
where vtiger_user2role.userid=".$current_user->id." | |
) | |
) | |
) | |
)) OR "; | |
} | |
/* ! -ComGroup- */ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment