PHP getSharedCalendarId函数代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中getSharedCalendarId函数的典型用法代码示例。如果您正苦于以下问题：PHP getSharedCalendarId函数的具体用法？PHP getSharedCalendarId怎么用？PHP getSharedCalendarId使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了getSharedCalendarId函数的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: getNonAdminAccessControlQuery

 public function getNonAdminAccessControlQuery($module, $user, $scope = '')
 {
     require 'user_privileges/user_privileges_' . $user->id . '.php';
     require 'user_privileges/sharing_privileges_' . $user->id . '.php';
     $query = ' ';
     $tabId = getTabid($module);
     if ($is_admin == false && $profileGlobalPermission[1] == 1 && $profileGlobalPermission[2] == 1 && $defaultOrgSharingPermission[$tabId] == 3) {
         $tableName = 'vt_tmp_u' . $user->id . '_t' . $tabId;
         $sharingRuleInfoVariable = $module . '_share_read_permission';
         $sharingRuleInfo = ${$sharingRuleInfoVariable};
         $sharedTabId = null;
         $this->setupTemporaryTable($tableName, $sharedTabId, $user, $current_user_parent_role_seq, $current_user_groups);
         $query = " INNER JOIN {$tableName} {$tableName}{$scope} ON ({$tableName}{$scope}.id = " . "vtiger_crmentity{$scope}.smownerid and {$tableName}{$scope}.shared=0) ";
         $sharedIds = getSharedCalendarId($user->id);
         if (!empty($sharedIds)) {
             $query .= "or ({$tableName}{$scope}.id = vtiger_crmentity{$scope}.smownerid AND " . "{$tableName}{$scope}.shared=1 and vtiger_activity.visibility = 'Public') ";
         }
     }
     return $query;
 }

开发者ID:kikojover，项目名称:corebos，代码行数:20，代码来源:Activity.php

示例2: getSecListViewSecurityParameter

function getSecListViewSecurityParameter($module)
{
    global $log;
    $log->debug("Entering getListViewSecurityParameter(" . $module . ") method ...");
    global $adb;
    global $current_user;
    $tabid = getTabid($module);
    global $current_user;
    if ($current_user) {
        require 'user_privileges/user_privileges_' . $current_user->id . '.php';
        require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
    }
    if ($module == 'Leads') {
        $sec_query .= " and (vtiger_crmentity{$module}.smownerid in({$current_user->id}) or vtiger_crmentity{$module}.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') or vtiger_crmentity{$module}.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ") or (";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups{$module}.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups{$module}.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . "))) ";
    } elseif ($module == 'Accounts') {
        $sec_query .= " and (vtiger_crmentity{$module}.smownerid in({$current_user->id}) or vtiger_crmentity.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') or vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ") or (";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups{$module}.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups{$module}.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . "))) ";
    } elseif ($module == 'Contacts') {
        $sec_query .= " and (vtiger_crmentity{$module}.smownerid in({$current_user->id}) or vtiger_crmentity{$module}.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') or vtiger_crmentity{$module}.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ") or (";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups{$module}.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups{$module}.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . "))) ";
    } elseif ($module == 'Potentials') {
        $sec_query .= " and (vtiger_crmentity{$module}.smownerid in({$current_user->id}) or vtiger_crmentity{$module}.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') or vtiger_crmentity{$module}.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ") or vtiger_potential.related_to in (select crmid from vtiger_crmentity where setype in ('Accounts', 'Contacts') and vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_rel_sharing_per where userid=" . $current_user->id . " and tabid in (" . getTabid('Accounts') . ", " . getTabid('Contacts') . ") and relatedtabid=" . $tabid . ")) ";
        if (vtlib_isModuleActive("Accounts")) {
            "or vtiger_potential.related_to in (select crmid from vtiger_crmentity inner join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid where setype='Accounts' and vtiger_groups.groupid in (select vtiger_tmp_read_group_rel_sharing_per.sharedgroupid from vtiger_tmp_read_group_rel_sharing_per where userid=" . $current_user->id . " and tabid=" . getTabid('Accounts') . " and relatedtabid=" . $tabid . ")) ";
        }
        if (vtlib_isModuleActive("Contacts")) {
            "or vtiger_potential.related_to in (select crmid from vtiger_crmentity inner join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid where setype='Contacts' and vtiger_groups.groupid in (select vtiger_tmp_read_group_rel_sharing_per.sharedgroupid from vtiger_tmp_read_group_rel_sharing_per where userid=" . $current_user->id . " and tabid=" . getTabid('Contacts') . " and relatedtabid=" . $tabid . ")) ";
        }
        $sec_query .= " or (";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups{$module}.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups{$module}.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . "))) ";
    } elseif ($module == 'HelpDesk') {
        $sec_query .= " and (vtiger_crmentity{$module}.smownerid in({$current_user->id}) or vtiger_crmentity{$module}.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') or vtiger_crmentity{$module}.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ") ";
        if (vtlib_isModuleActive("Accounts")) {
            "or vtiger_troubletickets.parent_id in (select crmid from vtiger_crmentity where setype='Accounts' and vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_rel_sharing_per where userid=" . $current_user->id . " and tabid=" . getTabid('Accounts') . " and relatedtabid=" . $tabid . ")) or vtiger_troubletickets.parent_id in (select crmid from vtiger_crmentity inner join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid where setype='Accounts' and vtiger_groups.groupid in(select vtiger_tmp_read_group_rel_sharing_per.sharedgroupid from vtiger_tmp_read_group_rel_sharing_per where userid=" . $current_user->id . " and tabid=" . getTabid('Accounts') . " and relatedtabid=" . $tabid . ")) ";
        }
        $sec_query .= " or (";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups{$module}.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups{$module}.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . "))) ";
    } elseif ($module == 'Calendar') {
        require_once 'modules/Calendar/CalendarCommon.php';
        $shared_ids = getSharedCalendarId($current_user->id);
        if (isset($shared_ids) && $shared_ids != '') {
            $condition = " or (vtiger_crmentity{$module}.smownerid in({$shared_ids}) and vtiger_activity.visibility = 'Public')";
        } else {
            $condition = null;
        }
        $sec_query .= " and (vtiger_crmentity{$module}.smownerid in({$current_user->id}) {$condition} or vtiger_crmentity{$module}.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%')";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " or ((vtiger_groups{$module}.groupid in (" . implode(",", $current_user_groups) . ")))";
        }
        $sec_query .= ")";
    } elseif ($module == 'Quotes') {
        $sec_query .= " and (vtiger_crmentity{$module}.smownerid in({$current_user->id}) or vtiger_crmentity{$module}.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') or vtiger_crmentity{$module}.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ")";
        //Adding crterial for vtiger_account related vtiger_quotes sharing
        if (vtlib_isModuleActive("Accounts")) {
            $sec_query .= " or vtiger_quotes.accountid in (select crmid from vtiger_crmentity where setype='Accounts' and vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_rel_sharing_per where userid=" . $current_user->id . " and tabid=" . getTabid('Accounts') . " and relatedtabid=" . $tabid . ")) or vtiger_quotes.accountid in (select crmid from vtiger_crmentity inner join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid where setype='Accounts' and vtiger_groups.groupid in(select vtiger_tmp_read_group_rel_sharing_per.sharedgroupid from vtiger_tmp_read_group_rel_sharing_per where userid=" . $current_user->id . " and tabid=" . getTabid('Accounts') . " and relatedtabid=" . $tabid . "))";
        }
        //Adding crterial for vtiger_potential related vtiger_quotes sharing
        if (vtlib_isModuleActive("Potentials")) {
            $sec_query .= " or vtiger_quotes.potentialid in (select crmid from vtiger_crmentity where setype='Potentials' and vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_rel_sharing_per where userid=" . $current_user->id . " and tabid=" . getTabid('Potentials') . " and relatedtabid=" . $tabid . ")) or vtiger_quotes.potentialid in (select crmid from vtiger_crmentity inner join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid where setype='Potentials' and vtiger_groups.groupid in(select vtiger_tmp_read_group_rel_sharing_per.sharedgroupid from vtiger_tmp_read_group_rel_sharing_per where userid=" . $current_user->id . " and tabid=" . getTabid('Potentials') . " and relatedtabid=" . $tabid . "))";
        }
        //Adding crteria for group sharing
        $sec_query .= " or ((";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups{$module}.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups{$module}.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ")))) ";
    } elseif ($module == 'PurchaseOrder') {
        $sec_query .= " and (vtiger_crmentity{$module}.smownerid in({$current_user->id}) or vtiger_crmentity{$module}.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') or vtiger_crmentity{$module}.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ") or (";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups{$module}.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups{$module}.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . "))) ";
    } elseif ($module == 'SalesOrder') {
        $sec_query .= " and (vtiger_crmentity{$module}.smownerid in({$current_user->id}) or vtiger_crmentity{$module}.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') or vtiger_crmentity{$module}.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ")";
        //Adding crterial for vtiger_account related so sharing
        if (vtlib_isModuleActive("Accounts")) {
            $sec_query .= " or vtiger_salesorder.accountid in (select crmid from vtiger_crmentity where setype='Accounts' and vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_rel_sharing_per where userid=" . $current_user->id . " and tabid=" . getTabid('Accounts') . " and relatedtabid=" . $tabid . ")) or vtiger_salesorder.accountid in (select crmid from vtiger_crmentity inner join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid where setype='Accounts' and vtiger_groups.groupid in(select vtiger_tmp_read_group_rel_sharing_per.sharedgroupid from vtiger_tmp_read_group_rel_sharing_per where userid=" . $current_user->id . " and tabid=" . getTabid('Accounts') . " and relatedtabid=" . $tabid . "))";
        }
        //Adding crterial for vtiger_potential related so sharing
        if (vtlib_isModuleActive("Potentials")) {
            $sec_query .= " or vtiger_salesorder.potentialid in (select crmid from vtiger_crmentity where setype='Potentials' and vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_rel_sharing_per where userid=" . $current_user->id . " and tabid=" . getTabid('Potentials') . " and relatedtabid=" . $tabid . ")) or vtiger_salesorder.potentialid in (select crmid from vtiger_crmentity inner join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid where setype='Potentials' and vtiger_groups.groupid in(select vtiger_tmp_read_group_rel_sharing_per.sharedgroupid from vtiger_tmp_read_group_rel_sharing_per where userid=" . $current_user->id . " and tabid=" . getTabid('Potentials') . " and relatedtabid=" . $tabid . "))";
        }
        //Adding crterial for vtiger_quotes related so sharing
        if (vtlib_isModuleActive("Quotes")) {
//.........这里部分代码省略.........

开发者ID:jaimeaga84，项目名称:corebos，代码行数:101，代码来源:UserInfoUtil.php

示例3: getListViewSecurityParameter

function getListViewSecurityParameter($module)
{
    $log = vglobal('log');
    $log->debug("Entering getListViewSecurityParameter(" . $module . ") method ...");
    $adb = PearDatabase::getInstance();
    $tabid = getTabid($module);
    $current_user = vglobal('current_user');
    if ($current_user) {
        require 'user_privileges/user_privileges_' . $current_user->id . '.php';
        require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
    }
    if ($module == 'Leads') {
        $sec_query .= " and (\n\t\t\t\t\t\tvtiger_crmentity.smownerid in({$current_user->id})\n\t\t\t\t\t\tor vtiger_crmentity.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%')\n\t\t\t\t\t\tor vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ")\n\t\t\t\t\t\tor (";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . "))) ";
    } elseif ($module == 'Accounts') {
        $sec_query .= " and (vtiger_crmentity.smownerid in({$current_user->id}) " . "or vtiger_crmentity.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') " . "or vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ") or (";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . "))) ";
    } elseif ($module == 'Contacts') {
        $sec_query .= " and (vtiger_crmentity.smownerid in({$current_user->id}) " . "or vtiger_crmentity.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') " . "or vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ") or (";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . "))) ";
    } elseif ($module == 'HelpDesk') {
        $sec_query .= " and (vtiger_crmentity.smownerid in({$current_user->id}) or vtiger_crmentity.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') or vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ") ";
        $sec_query .= " or (";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . "))) ";
    } elseif ($module == 'Emails') {
        $sec_query .= " and vtiger_crmentity.smownerid=" . $current_user->id . " ";
    } elseif ($module == 'Calendar') {
        require_once 'modules/Calendar/CalendarCommon.php';
        $shared_ids = getSharedCalendarId($current_user->id);
        if (isset($shared_ids) && $shared_ids != '') {
            $condition = " or (vtiger_crmentity.smownerid in({$shared_ids}) and vtiger_activity.visibility = 'Public')";
        } else {
            $condition = null;
        }
        $sec_query .= " and (vtiger_crmentity.smownerid in({$current_user->id}) {$condition} or vtiger_crmentity.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%')";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " or ((vtiger_groups.groupid in (" . implode(",", $current_user_groups) . ")))";
        }
        $sec_query .= ")";
    } elseif ($module == 'Campaigns') {
        $sec_query .= " and (vtiger_crmentity.smownerid in({$current_user->id}) or vtiger_crmentity.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') or vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ") or ((";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ")))) ";
    } elseif ($module == 'Documents') {
        $sec_query .= " and (vtiger_crmentity.smownerid in({$current_user->id}) or vtiger_crmentity.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') or vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ") or ((";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ")))) ";
    } elseif ($module == 'Products') {
        $sec_query .= " and (vtiger_crmentity.smownerid in({$current_user->id}) " . "or vtiger_crmentity.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%') " . "or vtiger_crmentity.smownerid in(select shareduserid from vtiger_tmp_read_user_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . ")";
        $sec_query .= " or (";
        if (sizeof($current_user_groups) > 0) {
            $sec_query .= " vtiger_groups.groupid in (" . implode(",", $current_user_groups) . ") or ";
        }
        $sec_query .= " vtiger_groups.groupid in(select vtiger_tmp_read_group_sharing_per.sharedgroupid from vtiger_tmp_read_group_sharing_per where userid=" . $current_user->id . " and tabid=" . $tabid . "))) ";
    } else {
        $modObj = CRMEntity::getInstance($module);
        $sec_query = $modObj->getListViewSecurityParameter($module);
    }
    $log->debug("Exiting getListViewSecurityParameter method ...");
    return $sec_query;
}

开发者ID:nikdejan，项目名称:YetiForceCRM，代码行数:77，代码来源:UserInfoUtil.php

示例4: getCalendarViewSecurityParameter

/**
 * Function returns the list of privileges and permissions of the events that the current user can view the details of.
 * return string - query that is used as secondary parameter to fetch the events that the user can view and the schedule of the users
 */
function getCalendarViewSecurityParameter()
{
    global $current_user;
    require 'user_privileges/user_privileges_' . $current_user->id . '.php';
    require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
    require_once 'modules/Calendar/CalendarCommon.php';
    $shared_ids = getSharedCalendarId($current_user->id);
    if (isset($shared_ids) && $shared_ids != '') {
        $condition = " or (vtiger_crmentity.smownerid in({$shared_ids})) or (vtiger_crmentity.smownerid NOT LIKE ({$current_user->id}))";
    } else {
        $condition = "or (vtiger_crmentity.smownerid NOT LIKE ({$current_user->id}))";
    }
    $sec_query .= " and (vtiger_crmentity.smownerid in({$current_user->id}) {$condition} or vtiger_crmentity.smownerid in(select vtiger_user2role.userid from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid where vtiger_role.parentrole like '" . $current_user_parent_role_seq . "::%')";
    if (sizeof($current_user_groups) > 0) {
        $sec_query .= " or (vtiger_groups.groupid in (" . implode(",", $current_user_groups) . "))";
    }
    $sec_query .= ")";
    return $sec_query;
}

开发者ID:p6，项目名称:VF，代码行数:23，代码来源:calendarLayout.php

注：本文中的getSharedCalendarId函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP getSharingModuleList函数代码示例发布时间：2022-05-15

PHP getSeverityStyle函数代码示例发布时间：2022-05-15

theindianappguy/machine_learning_flutter

1 Ubuntu14.04下安装matlab2014a

1. 首先现在matlab2014a，http://pan.baidu.com/s/1pJGF5ov [Matlab2014a（密码：en52

阅读：547|2022-07-18

2 bradtraversy/iweather: Ionic 3 mobile we

bradtraversy/iweather: Ionic 3 mobile weather app

阅读：1650|2022-08-30

3 CVE-2020-27732

** REJECT ** DO NOT USE THIS CANDIDATE NUMBER. ConsultIDs: none. Reason: This ca

阅读：1573|2022-07-08

4 joaomh/curso-de-matlab

joaomh/curso-de-matlab

阅读：1211|2022-08-17

5 断牙刷新位置时间（断牙属性及刷新位置介绍

魔兽世界怀旧服已经开启两个多月了，但作为一个猎人玩家，抓到“断牙”，已经成为了一

阅读：1066|2022-11-06

6 rugk/mastodon-simplified-federation: Sim

rugk/mastodon-simplified-federation: Simplifies following and interacting with r

阅读：1134|2022-08-17

7 Tangshitao/Dense-Scene-Matching: Learnin

Tangshitao/Dense-Scene-Matching: Learning Camera Localization via Dense Scene Ma

阅读：821|2022-08-16

8 天的笔顺,讲述天的笔画,解说天的部首

天字笔顺怎么写?天字笔顺笔画顺序是什么?讲述天字的笔画顺序怎么写了解到好多的写字朋

阅读：467|2022-07-30

9 Respring是什么意思?没有越狱设备如何 Resp

相信不少果粉在对自己的设备进行某些操作时，都会碰到Respring，但这个 Respring 到底

阅读：388|2022-11-06

10 ccyrowski/cm-kernel: CyanogenMod Linux K

ccyrowski/cm-kernel: CyanogenMod Linux Kernel

阅读：746|2022-08-15

客服电话

电子邮件

PHP getSharedCalendarId函数代码示例

示例1: getNonAdminAccessControlQuery

示例2: getSecListViewSecurityParameter

示例3: getListViewSecurityParameter

示例4: getCalendarViewSecurityParameter

请发表评论

全部评论

上一篇：

下一篇：

Ubuntu14.04下安装matlab2014a

CVE-2020-27732

librespeed/speedtest: Self-hosted Speedt

avehtari/BDA_m_demos: Bayesian Data Anal

四维彩超怎么看性别？四维看男孩女孩诀窍

theindianappguy/machine_learning_flutter

切微信小程序前端制作-设备管理主界面

samaxes/minify-maven-plugin: Combine and

挨打的读音是什么？是āi dǎ还是ái dǎ？

nacika-ins/nanachibot: nanachibot is Rus

satoru-takeuchi/linux-in-practice

关于我们

产品与服务

解决方案

139-2527-9053