Skip to content

Instantly share code, notes, and snippets.

@vaseker
Created October 27, 2012 09:52
Show Gist options
  • Save vaseker/3963830 to your computer and use it in GitHub Desktop.
Save vaseker/3963830 to your computer and use it in GitHub Desktop.
Vtiger 5.4.0 Comments show to group's members
/* -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