PHP Users::retrieve_user_id方法代码示例

function vtws_login($username, $pwd)
{
    $user = new Users();
    $userId = $user->retrieve_user_id($username);
    if (empty($userId)) {
        throw new WebServiceException(WebServiceErrorCode::$AUTHREQUIRED, 'Given user cannot be found');
    }
    $token = vtws_getActiveToken($userId);
    if ($token == null) {
        throw new WebServiceException(WebServiceErrorCode::$INVALIDTOKEN, "Specified token is invalid or expired");
    }
    $accessKey = vtws_getUserAccessKey($userId);
    if ($accessKey == null) {
        throw new WebServiceException(WebServiceErrorCode::$ACCESSKEYUNDEFINED, "Access key for the user is undefined");
    }
    $accessCrypt = md5($token . $accessKey);
    if (strcmp($accessCrypt, $pwd) !== 0) {
        throw new WebServiceException(WebServiceErrorCode::$INVALIDUSERPWD, "Invalid username or password");
    }
    $user = $user->retrieveCurrentUserInfoFromFile($userId);
    if ($user->status != 'Inactive') {
        return $user;
    }
    throw new WebServiceException(WebServiceErrorCode::$AUTHREQUIRED, 'Given user is inactive');
}

function vtws_getchallenge($username)
{
    $adb = PearDatabase::getInstance();
    $user = new Users();
    $userid = $user->retrieve_user_id($username);
    $authToken = uniqid();
    $servertime = time();
    $expireTime = time() + 60 * 5;
    $sql = "delete from vtiger_ws_userauthtoken where userid=?";
    $adb->pquery($sql, array($userid));
    $sql = "insert into vtiger_ws_userauthtoken(userid,token,expireTime) values (?,?,?)";
    $adb->pquery($sql, array($userid, $authToken, $expireTime));
    return array("token" => $authToken, "serverTime" => $servertime, "expireTime" => $expireTime);
}

function vtws_getchallenge($username)
{
    global $adb;
    $user = new Users();
    $userid = $user->retrieve_user_id($username);
    if (empty($userid)) {
        throw new WebServiceException(WebServiceErrorCode::$AUTHREQUIRED, 'Given user cannot be found');
    }
    $authToken = uniqid();
    $servertime = time();
    $expireTime = time() + 60 * 5;
    $sql = "delete from vtiger_ws_userauthtoken where userid=?";
    $adb->pquery($sql, array($userid));
    $sql = "insert into vtiger_ws_userauthtoken(userid,token,expireTime) values (?,?,?)";
    $adb->pquery($sql, array($userid, $authToken, $expireTime));
    return array("token" => $authToken, "serverTime" => $servertime, "expireTime" => $expireTime);
}

function vtws_loginportal($username, $password)
{
    $uname = 'portal';
    $user = new Users();
    $userId = $user->retrieve_user_id($uname);
    if (empty($userId)) {
        throw new WebServiceException(WebServiceErrorCode::$INVALIDUSERPWD, "User {$uname} does not exist");
    }
    global $adb, $log;
    $log->debug('Entering LoginPortal function with parameter username: ' . $username);
    $ctors = $adb->pquery('select id
			from vtiger_portalinfo
			inner join vtiger_customerdetails on vtiger_portalinfo.id=vtiger_customerdetails.customerid
			inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_portalinfo.id
			where vtiger_crmentity.deleted=0 and user_name=? and user_password=?
			  and isactive=1 and vtiger_customerdetails.portal=1', array($username, $password));
    if ($ctors and $adb->num_rows($ctors) == 1) {
        $user = $user->retrieveCurrentUserInfoFromFile($userId);
        if ($user->status != 'Inactive') {
            $result = $adb->query("SELECT id FROM vtiger_ws_entity WHERE name = 'Users'");
            $wsid = $adb->query_result($result, 0, 'id');
            $accessinfo = vtws_getchallenge($uname);
            $sessionManager = new SessionManager();
            $sid = $sessionManager->startSession(null, false);
            if (!$sid) {
                throw new WebServiceException(WebServiceErrorCode::$SESSIONIDINVALID, 'Could not create session');
            }
            $sessionManager->set("authenticatedUserId", $userId);
            $accessinfo['sessionName'] = $sessionManager->getSessionId();
            $accessinfo['user'] = array('id' => $wsid . 'x' . $userId, 'user_name' => $user->column_fields['user_name'], 'accesskey' => $user->column_fields['accesskey']);
            return $accessinfo;
        } else {
            throw new WebServiceException(WebServiceErrorCode::$AUTHREQUIRED, 'Given user is inactive');
        }
    }
    throw new WebServiceException(WebServiceErrorCode::$AUTHREQUIRED, "Given contact is inactive");
}

function CheckLeadViewPerm($user_name)
{
    global $current_user, $log;
    require_once 'modules/Users/Users.php';
    $seed_user = new Users();
    $user_id = $seed_user->retrieve_user_id($user_name);
    $current_user = $seed_user;
    $current_user->retrieve_entity_info($user_id, "Users");
    if (isPermitted("Leads", "EditView") == "yes") {
        return "allowed";
    } else {
        return "denied";
    }
}

 /**
  * Function to get calendar query for outlookplugin
  * @param   string    $username     -  User name
  * @return  string    $query        -  sql query
  */
 function get_calendarsforol($user_name)
 {
     global $log, $adb, $current_user;
     $log->debug("Entering get_calendarsforol(" . $user_name . ") method ...");
     require_once "modules/Users/Users.php";
     $seed_user = new Users();
     $user_id = $seed_user->retrieve_user_id($user_name);
     $current_user = $seed_user;
     $current_user->retrieve_entity_info($user_id, 'Users');
     require 'user_privileges/user_privileges_' . $current_user->id . '.php';
     require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
     if ($is_admin == true || $profileGlobalPermission[1] == 0 || $profileGlobalPermission[2] == 0) {
         $sql1 = "select tablename,columnname from vtiger_field where tabid=9 and tablename <> 'vtiger_recurringevents' and tablename <> 'vtiger_activity_reminder' and vtiger_field.presence in (0,2)";
         $params1 = array();
     } else {
         $profileList = getCurrentUserProfileList();
         $sql1 = "select tablename,columnname from vtiger_field inner join vtiger_profile2field on vtiger_profile2field.fieldid=vtiger_field.fieldid inner join vtiger_def_org_field on vtiger_def_org_field.fieldid=vtiger_field.fieldid where vtiger_field.tabid=9 and tablename <> 'vtiger_recurringevents' and tablename <> 'vtiger_activity_reminder' and vtiger_field.displaytype in (1,2,4,3) and vtiger_profile2field.visible=0 and vtiger_def_org_field.visible=0 and vtiger_field.presence in (0,2)";
         $params1 = array();
         if (count($profileList) > 0) {
             $sql1 .= " and vtiger_profile2field.profileid in (" . generateQuestionMarks($profileList) . ")";
             array_push($params1, $profileList);
         }
     }
     $result1 = $adb->pquery($sql1, $params1);
     for ($i = 0; $i < $adb->num_rows($result1); $i++) {
         $permitted_lists[] = $adb->query_result($result1, $i, 'tablename');
         $permitted_lists[] = $adb->query_result($result1, $i, 'columnname');
         if ($adb->query_result($result1, $i, 'columnname') == "date_start") {
             $permitted_lists[] = 'vtiger_activity';
             $permitted_lists[] = 'time_start';
         }
         if ($adb->query_result($result1, $i, 'columnname') == "due_date") {
             $permitted_lists[] = 'vtiger_activity';
             $permitted_lists[] = 'time_end';
         }
     }
     $permitted_lists = array_chunk($permitted_lists, 2);
     $column_table_lists = array();
     for ($i = 0; $i < count($permitted_lists); $i++) {
         $column_table_lists[] = implode(".", $permitted_lists[$i]);
     }
     $query = "select vtiger_activity.activityid as clndrid, " . implode(',', $column_table_lists) . " from vtiger_activity\n\t\t\tinner join vtiger_salesmanactivityrel on vtiger_salesmanactivityrel.activityid=vtiger_activity.activityid\n\t\t\tinner join vtiger_users on vtiger_users.id=vtiger_salesmanactivityrel.smid\n\t\t\tleft join vtiger_cntactivityrel on vtiger_cntactivityrel.activityid=vtiger_activity.activityid\n\t\t\tleft join vtiger_contactdetails on vtiger_contactdetails.contactid=vtiger_cntactivityrel.contactid\n\t\t\tleft join vtiger_seactivityrel on vtiger_seactivityrel.activityid = vtiger_activity.activityid\n\t\t\tinner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_activity.activityid\n\t\t\twhere vtiger_users.user_name='" . $user_name . "' and vtiger_crmentity.deleted=0 and vtiger_activity.activitytype='Meeting'";
     $log->debug("Exiting get_calendarsforol method ...");
     return $query;
 }

function validateSession($username, $sessionid)
{
    global $adb, $current_user;
    $adb->println("Inside function validateSession({$username}, {$sessionid})");
    require_once "modules/Users/Users.php";
    $seed_user = new Users();
    $id = $seed_user->retrieve_user_id($username);
    $server_sessionid = getServerSessionId($id);
    $adb->println("Checking Server session id and customer input session id ==> {$server_sessionid} == {$sessionid}");
    if ($server_sessionid == $sessionid) {
        $adb->println("Session id match. Authenticated to do the current operation.");
        return true;
    } else {
        $adb->println("Session id does not match. Not authenticated to do the current operation.");
        return false;
    }
}

 /** Function to get the Contacts associated with the particular User Name.
 *  @param varchar $user_name - User Name
 *  Returns query
 */
 function get_contactsforol($user_name)
 {
     global $log, $adb, $current_user;
     require_once "modules/Users/Users.php";
     $seed_user = new Users();
     $user_id = $seed_user->retrieve_user_id($user_name);
     $current_user = $seed_user;
     $current_user->retrieve_entity_info($user_id, 'Users');
     require 'user_privileges/user_privileges_' . $current_user->id . '.php';
     require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
     if ($is_admin == true || $profileGlobalPermission[1] == 0 || $profileGlobalPermission[2] == 0) {
         $sql1 = "select tablename,columnname from vtiger_field where tabid=4 and vtiger_field.presence in (0,2)";
         $params1 = array();
     } else {
         $profileList = getCurrentUserProfileList();
         $sql1 = "select tablename,columnname from vtiger_field inner join vtiger_profile2field on vtiger_profile2field.fieldid=vtiger_field.fieldid inner join vtiger_def_org_field on vtiger_def_org_field.fieldid=vtiger_field.fieldid where vtiger_field.tabid=4 and vtiger_field.displaytype in (1,2,4,3) and vtiger_profile2field.visible=0 and vtiger_def_org_field.visible=0 and vtiger_field.presence in (0,2)";
         $params1 = array();
         if (count($profileList) > 0) {
             $sql1 .= " and vtiger_profile2field.profileid in (" . generateQuestionMarks($profileList) . ")";
             array_push($params1, $profileList);
         }
     }
     $result1 = $adb->pquery($sql1, $params1);
     for ($i = 0; $i < $adb->num_rows($result1); $i++) {
         $permitted_lists[] = $adb->query_result($result1, $i, 'tablename');
         $permitted_lists[] = $adb->query_result($result1, $i, 'columnname');
         if ($adb->query_result($result1, $i, 'columnname') == "accountid") {
             $permitted_lists[] = 'vtiger_account';
             $permitted_lists[] = 'accountname';
         }
     }
     $permitted_lists = array_chunk($permitted_lists, 2);
     $column_table_lists = array();
     for ($i = 0; $i < count($permitted_lists); $i++) {
         $column_table_lists[] = implode(".", $permitted_lists[$i]);
     }
     $log->debug("Entering get_contactsforol(" . $user_name . ") method ...");
     $query = "select vtiger_contactdetails.contactid as id, " . implode(',', $column_table_lists) . " from vtiger_contactdetails\n\t\tinner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_contactdetails.contactid\n\t\tinner join vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid\n\t\tleft join vtiger_customerdetails on vtiger_customerdetails.customerid=vtiger_contactdetails.contactid\n\t\tleft join vtiger_account on vtiger_account.accountid=vtiger_contactdetails.accountid\n\t\tleft join vtiger_contactaddress on vtiger_contactaddress.contactaddressid=vtiger_contactdetails.contactid\n\t\tleft join vtiger_contactsubdetails on vtiger_contactsubdetails.contactsubscriptionid = vtiger_contactdetails.contactid\n\t\tleft join vtiger_contactscf on vtiger_contactscf.contactid = vtiger_contactdetails.contactid\n\t\tleft join vtiger_campaigncontrel on vtiger_contactdetails.contactid = vtiger_campaigncontrel.contactid\n\t\tleft join vtiger_campaignrelstatus on vtiger_campaignrelstatus.campaignrelstatusid = vtiger_campaigncontrel.campaignrelstatusid\n\t\tLEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid\n\t\twhere vtiger_crmentity.deleted=0 and vtiger_users.user_name='" . $user_name . "'";
     $log->debug("Exiting get_contactsforol method ...");
     return $query;
 }

function webforms_init()
{
    global $defaultUserName, $defaultUserAccessKey, $defaultOwner, $adb, $enableAppKeyValidation, $application_unique_key;
    try {
        $active = vtlib_isModuleActive('Webforms');
        if ($active === false) {
            webforms_returnError(array('code' => "WEBFORMS_DISABLED", 'message' => 'Webforms module is disabled'), 'Webforms');
        }
        if ($enableAppKeyValidation == true) {
            if ($application_unique_key !== $_REQUEST['appKey']) {
                webforms_returnError(array('code' => "WEBFORMS_INVALID_APPKEY", 'message' => 'AppKey provided is invalid'), null);
                return;
            }
        }
        $module = $_REQUEST['moduleName'];
        $challengeResult = vtws_getchallenge($defaultUserName);
        $challengeToken = $challengeResult['token'];
        $user = vtws_login($defaultUserName, md5($challengeToken . $defaultUserAccessKey));
        $describeResult = vtws_describe($module, $user);
        $fields = $describeResult['fields'];
        $assignedUser = new Users();
        $ownerId = $assignedUser->retrieve_user_id($defaultOwner);
        $userData = webforms_getUserData(vtws_getId(VtigerWebserviceObject::fromName($adb, "Users")->getEntityId(), $ownerId), $fields, $_REQUEST);
        if ($userData === null) {
            webforms_returnError(array('code' => "WEBFORMS_INVALID_DATA", 'message' => 'data provided is invalid'), $module);
            return;
        }
        if (sizeof($userData) < 1) {
            webforms_returnError(array('code' => "WEBFORMS_INVALID_DATA", 'message' => 'data provided is invalid'), $module);
            return;
        }
        $createResult = vtws_create($module, $userData, $user);
        webforms_returnSuccess($createResult, $module);
    } catch (WebServiceException $e) {
        webforms_returnError($e, $module);
    }
}

 function get_searchbyemailid($username, $emailaddress)
 {
     //crm-now added $adb to provide db access
     global $log, $adb;
     global $current_user;
     require_once "modules/Users/Users.php";
     $seed_user = new Users();
     $user_id = $seed_user->retrieve_user_id($username);
     $current_user = $seed_user;
     $current_user->retrieve_entity_info($user_id, 'Users');
     require 'user_privileges/user_privileges_' . $current_user->id . '.php';
     require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
     $log->debug("Entering get_searchbyemailid(" . $username . "," . $emailaddress . ") Leads method ...");
     //get users group ID's
     $gquery = 'SELECT groupid FROM vtiger_users2group WHERE userid=?';
     $gresult = $adb->pquery($gquery, array($user_id));
     for ($j = 0; $j < $adb->num_rows($gresult); $j++) {
         $groupidlist .= "," . $adb->query_result($gresult, $j, 'groupid');
     }
     //crm-now changed query to search in groups too and make only owned contacts available
     $query = "SELECT vtiger_leaddetails.lastname,\n\t\t\t\t\t\tvtiger_leaddetails.firstname,\n\t\t\t\t\t\tvtiger_leaddetails.leadid, \n\t\t\t\t\t\tvtiger_leaddetails.email, \n\t\t\t\t\t\tvtiger_leaddetails.company \n\t\t\t\t\tFROM vtiger_leaddetails \n\t\t\t\t\tINNER JOIN vtiger_crmentity on vtiger_crmentity.crmid=vtiger_leaddetails.leadid \n\t\t\t\t\tLEFT JOIN vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid  \n\t\t\t\t\tLEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid\n\t\t\t\t\tWHERE vtiger_crmentity.deleted=0 AND vtiger_leaddetails.converted=0";
     if (trim($emailaddress) != '') {
         $query .= " AND ((vtiger_leaddetails.email like '" . formatForSqlLike($emailaddress) . "') or vtiger_leaddetails.lastname REGEXP REPLACE('" . $emailaddress . "',' ','|') or vtiger_leaddetails.firstname REGEXP REPLACE('" . $emailaddress . "',' ','|'))  and vtiger_leaddetails.email != ''";
     } else {
         $query .= " AND (vtiger_leaddetails.email like '" . formatForSqlLike($emailaddress) . "' and vtiger_leaddetails.email != '')";
     }
     if (isset($groupidlist)) {
         $query .= " AND (vtiger_users.user_name='" . $username . "' OR vtiger_crmentity.smownerid IN (" . substr($groupidlist, 1) . "))";
     } else {
         $query .= " AND vtiger_users.user_name='" . $username . "'";
     }
     $tab_id = getTabid("Leads");
     if ($is_admin == false && $profileGlobalPermission[1] == 1 && $profileGlobalPermission[2] == 1 && $defaultOrgSharingPermission[$tab_id] == 3) {
         $sec_parameter = getListViewSecurityParameter("Leads");
         $query .= $sec_parameter;
     }
     $log->debug("Exiting get_searchbyemailid method ...");
     return $this->plugin_process_list_query($query);
 }

$account_ids = array();
$opportunity_ids = array();
$vendor_ids = array();
$contact_ids = array();
$product_ids = array();
$pricebook_ids = array();
$quote_ids = array();
$salesorder_ids = array();
$purchaseorder_ids = array();
$invoice_ids = array();
$email_ids = array();
// Assigned user for all demo data.
$assigned_user_name = "admin";
// Look up the user id for the assigned user
$seed_user = new Users();
$assigned_user_id = $seed_user->retrieve_user_id($assigned_user_name);
global $current_user;
$current_user = new Users();
$result = $current_user->retrieve_entity_info($assigned_user_id, 'Users');
$tagkey = 1;
// Get _dom arrays
$comboFieldNames = array('leadsource' => 'leadsource_dom', 'leadstatus' => 'lead_status_dom', 'industry' => 'industry_dom', 'rating' => 'rating_dom', 'opportunity_type' => 'opportunity_type_dom', 'sales_stage' => 'sales_stage_dom');
$comboFieldArray = getComboArray($comboFieldNames);
$adb->println("company_name_array");
$adb->println($company_name_array);
$cloudtag = array('SO_vendtl', 'X-CEED', 'X-CEED', 'vtiger_50usr');
for ($i = 0; $i < $company_name_count; $i++) {
    $account_name = $company_name_array[$i];
    // Create new accounts.
    $account = new Accounts();
    $account->column_fields["accountname"] = $account_name;

/**	function used to get the Quotes/Invoice pdf
 *	@param int $id - id -id
 *	return string $output - pd link value
 */
function get_pdf($id, $block, $customerid, $sessionid)
{
    global $adb;
    global $current_user, $log, $default_language;
    global $currentModule, $mod_strings, $app_strings, $app_list_strings;
    $log->debug("Entering customer portal function get_pdf");
    $isPermitted = check_permission($customerid, $block, $id);
    if ($isPermitted == false) {
        return array("#NOT AUTHORIZED#");
    }
    if (!validateSession($customerid, $sessionid)) {
        return null;
    }
    require_once "modules/Users/Users.php";
    require_once "config.inc.php";
    $seed_user = new Users();
    $user_id = $seed_user->retrieve_user_id('admin');
    $current_user = $seed_user;
    $current_user->retrieveCurrentUserInfoFromFile($user_id);
    $currentModule = $block;
    $current_language = $default_language;
    $app_strings = return_application_language($current_language);
    $app_list_strings = return_app_list_strings_language($current_language);
    $mod_strings = return_module_language($current_language, $currentModule);
    $_REQUEST['record'] = $id;
    $_REQUEST['savemode'] = 'file';
    $filenamewithpath = 'test/product/' . $id . '_' . $block . '.pdf';
    if (file_exists($filenamewithpath) && filesize($filenamewithpath) != 0) {
        unlink($filenamewithpath);
    }
    checkFileAccess("modules/{$block}/CreatePDF.php");
    include "modules/{$block}/CreatePDF.php";
    if (file_exists($filenamewithpath) && filesize($filenamewithpath) != 0) {
        //we have to pass the file content
        $filecontents[] = base64_encode(file_get_contents($filenamewithpath));
        unlink($filenamewithpath);
        // TODO: Delete the file to avoid public access.
    } else {
        $filecontents = "failure";
    }
    $log->debug("Exiting customer portal function get_pdf");
    return $filecontents;
}

 /**
  * Function to get calendar query for outlookplugin
  * @param   string    $username     -  User name
  * @return  string    $query        -  sql query
  */
 function get_calendarsforol($user_name)
 {
     global $log, $adb, $current_user;
     $log->debug("Entering get_calendarsforol(" . $user_name . ") method ...");
     require_once "modules/Users/Users.php";
     $seed_user = new Users();
     $user_id = $seed_user->retrieve_user_id($user_name);
     $current_user = $seed_user;
     $current_user->retrieve_entity_info($user_id, 'Users');
     require 'user_privileges/user_privileges_' . $current_user->id . '.php';
     require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
     //get users group ID's
     $gquery = 'SELECT groupid FROM vtiger_users2group WHERE userid=?';
     $gresult = $adb->pquery($gquery, array($user_id));
     for ($j = 0; $j < $adb->num_rows($gresult); $j++) {
         $groupidlist .= "," . $adb->query_result($gresult, $j, 'groupid');
     }
     if ($is_admin == true || $profileGlobalPermission[1] == 0 || $profileGlobalPermission[2] == 0) {
         $sql1 = "select tablename,columnname from vtiger_field where tabid=9 and tablename <> 'vtiger_recurringevents' and tablename <> 'vtiger_activity_reminder' and vtiger_field.presence in (0,2)";
         $params1 = array();
     } else {
         $profileList = getCurrentUserProfileList();
         $sql1 = "select tablename,columnname from vtiger_field inner join vtiger_profile2field on vtiger_profile2field.fieldid=vtiger_field.fieldid inner join vtiger_def_org_field on vtiger_def_org_field.fieldid=vtiger_field.fieldid where vtiger_field.tabid=9 and tablename <> 'vtiger_recurringevents' and tablename <> 'vtiger_activity_reminder' and vtiger_field.displaytype in (1,2,4,3) and vtiger_profile2field.visible=0 and vtiger_def_org_field.visible=0 and vtiger_field.presence in (0,2)";
         $params1 = array();
         if (count($profileList) > 0) {
             $sql1 .= " and vtiger_profile2field.profileid in (" . generateQuestionMarks($profileList) . ")";
             array_push($params1, $profileList);
         }
     }
     $result1 = $adb->pquery($sql1, $params1);
     for ($i = 0; $i < $adb->num_rows($result1); $i++) {
         $permitted_lists[] = $adb->query_result($result1, $i, 'tablename');
         $permitted_lists[] = $adb->query_result($result1, $i, 'columnname');
         if ($adb->query_result($result1, $i, 'columnname') == "date_start") {
             $permitted_lists[] = 'vtiger_activity';
             $permitted_lists[] = 'time_start';
         }
         if ($adb->query_result($result1, $i, 'columnname') == "due_date") {
             $permitted_lists[] = 'vtiger_activity';
             $permitted_lists[] = 'time_end';
         }
     }
     $permitted_lists = array_chunk($permitted_lists, 2);
     $column_table_lists = array();
     for ($i = 0; $i < count($permitted_lists); $i++) {
         if ($permitted_lists[$i][0] != 'vtiger_activitycf') {
             $column_table_lists[] = implode(".", $permitted_lists[$i]);
         }
     }
     $query = "SELECT vtiger_activity.activityid AS clndrid, " . implode(',', $column_table_lists) . " FROM vtiger_activity \n\t\t\t\tINNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_activity.activityid \n\t\t\t\tLEFT JOIN vtiger_salesmanactivityrel ON vtiger_salesmanactivityrel.activityid=vtiger_activity.activityid \n\t\t\t\tLEFT JOIN vtiger_users ON vtiger_users.id=vtiger_salesmanactivityrel.smid \n\t\t\t\tLEFT JOIN vtiger_cntactivityrel ON vtiger_cntactivityrel.activityid=vtiger_activity.activityid \n\t\t\t\tLEFT JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid=vtiger_cntactivityrel.contactid \n\t\t\t\tLEFT JOIN vtiger_seactivityrel ON vtiger_seactivityrel.activityid = vtiger_activity.activityid \n\t\t\t\tLEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid \n\t\t\t\tWHERE vtiger_crmentity.deleted=0 AND vtiger_activity.activitytype='Meeting' ";
     if (isset($groupidlist)) {
         $query .= " AND (vtiger_users.user_name='" . $user_name . "' OR vtiger_crmentity.smownerid IN (" . substr($groupidlist, 1) . "))";
     } else {
         $query .= " AND vtiger_users.user_name='" . $user_name . "'";
     }
     //crm-now added GROUP BY to prevent the same entry to appear multiple times if assigned to multiple contacts during synchronization with Outlook
     $query .= " GROUP BY clndrid";
     $log->debug("Exiting get_calendarsforol method ...");
     return $query;
 }