function fetchCurrencyRates($dateCur, $cron = false)
 {
     $db = PearDatabase::getInstance();
     $notifyNewRates = false;
     $vtigerCurrencySql = 'SELECT `id`, `currency_code` FROM `vtiger_currency_info` WHERE `currency_status` = ? AND `deleted` = 0 AND `defaultid` != ?;';
     $vtigerCurrencyResult = $db->pquery($vtigerCurrencySql, ['Active', '-11']);
     $numToConvert = $db->num_rows($vtigerCurrencyResult);
     if ($numToConvert >= 1) {
         $selectBankId = $this->getActiveBankId();
         $activeBankName = 'Settings_CurrencyUpdate_models_' . $this->getActiveBankName() . '_BankModel';
         $currIds = [];
         $otherCurrencyCode = [];
         while ($row = $db->fetchByAssoc($vtigerCurrencyResult)) {
             $id = $row['id'];
             $code = $row['currency_code'];
             $currIds[] = $id;
             $otherCurrencyCode[$code] = $id;
         }
         $existSql = 'SELECT COUNT(*) as num FROM `yetiforce_currencyupdate` WHERE `exchange_date` = ? AND `currency_id` IN (' . generateQuestionMarks($currIds) . ') AND `bank_id` = ? LIMIT 1;';
         $params = [$dateCur];
         $params = array_merge($params, $currIds);
         $params[] = $selectBankId;
         $existResult = $db->pquery($existSql, $params);
         $currNum = $db->getSingleValue($existResult);
         // download only if its not in archives
         if ($currNum != $numToConvert && class_exists($activeBankName)) {
             $bank = new $activeBankName();
             $bank->getRates($otherCurrencyCode, $dateCur, false);
             $notifyNewRates = true;
         }
     }
     return $notifyNewRates;
 }

 public function save()
 {
     $db = PearDatabase::getInstance();
     $id = $this->getId();
     $params = array();
     // SalesPlatform.ru begin
     array_push($params, $this->get('server'), $this->get('server_port'), $this->get('server_username'), $this->get('server_password'), $this->get('server_type'), $this->isSmtpAuthEnabled(), $this->get('server_path'), $this->get('from_email_field'), $this->get('server_tls'), $this->get('from_name'), $this->get('use_sendmail'), $this->get('use_mail_account'));
     //array_push($params, $this->get('server'),$this->get('server_port'),$this->get('server_username'),$this->get('server_password'),$this->get('server_type'),
     //$this->isSmtpAuthEnabled(),$this->get('server_path'),$this->get('from_email_field'));
     // SalesPlatform.ru end
     if (empty($id)) {
         $id = $db->getUniqueID(self::tableName);
         //To keep id in the beginning
         array_unshift($params, $id);
         // SalesPlatform.ru begin
         $query = 'INSERT INTO ' . self::tableName . ' VALUES(' . generateQuestionMarks($params) . ')';
         //$query = 'INSERT INTO '.self::tableName.' VALUES(?,?,?,?,?,?,?,?,?)';
         // SalesPlatform.ru end
     } else {
         // SalesPlatform.ru begin
         $query = 'UPDATE ' . self::tableName . ' SET server = ?, server_port= ?, server_username = ?, server_password = ?,
             server_type = ?,  smtp_auth= ?, server_path = ?, from_email_field=?, server_tls=?, from_name=?, use_sendmail=?, use_mail_account=? WHERE id = ?';
         //$query = 'UPDATE '.self::tableName.' SET server = ?, server_port= ?, server_username = ?, server_password = ?,
         //    server_type = ?,  smtp_auth= ?, server_path = ?, from_email_field=? WHERE id = ?';
         // SalesPlatform.ru end
         $params[] = $id;
     }
     $db->pquery($query, $params);
     return $id;
 }

/** Function to  returns the combo field values in array format
 * @param $combofieldNames -- combofieldNames:: Type string array
 * @returns $comboFieldArray -- comboFieldArray:: Type string array
 */
function getComboArray($combofieldNames)
{
    global $log, $mod_strings;
    $log->debug("Entering getComboArray(" . $combofieldNames . ") method ...");
    global $adb, $current_user;
    $roleid = $current_user->roleid;
    $comboFieldArray = array();
    foreach ($combofieldNames as $tableName => $arrayName) {
        $fldArrName = $arrayName;
        $arrayName = array();
        $sql = "select {$tableName} from vtiger_{$tableName}";
        $params = array();
        if (!is_admin($current_user)) {
            $subrole = getRoleSubordinates($roleid);
            if (count($subrole) > 0) {
                $roleids = $subrole;
                array_push($roleids, $roleid);
            } else {
                $roleids = $roleid;
            }
            $sql = "select distinct {$tableName} from vtiger_{$tableName}  inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_{$tableName}.picklist_valueid where roleid in(" . generateQuestionMarks($roleids) . ") order by sortid";
            $params = array($roleids);
        }
        $result = $adb->pquery($sql, $params);
        while ($row = $adb->fetch_array($result)) {
            $val = $row[$tableName];
            $arrayName[$val] = getTranslatedString($val);
        }
        $comboFieldArray[$fldArrName] = $arrayName;
    }
    $log->debug("Exiting getComboArray method ...");
    return $comboFieldArray;
}

 public static function getEntityModulesList()
 {
     $db = PearDatabase::getInstance();
     self::preModuleInitialize2();
     $presence = array(0, 2);
     $restrictedModules = array('Emails', 'Integration', 'Dashboard', 'ModComments', 'PBXManager', 'vtmessages', 'vttwitter');
     $module = array('Potentials', 'Project', 'HelpDesk');
     $query = 'SELECT name FROM vtiger_tab WHERE
                 presence IN (' . generateQuestionMarks($presence) . ')
                 AND isentitytype = ?
                 AND name NOT IN (' . generateQuestionMarks($restrictedModules) . ') AND name IN (' . generateQuestionMarks($module) . ')';
     $result = $db->pquery($query, array($presence, 1, $restrictedModules, $module));
     $numOfRows = $db->num_rows($result);
     $modulesList = array();
     for ($i = 0; $i < $numOfRows; $i++) {
         $moduleName = $db->query_result($result, $i, 'name');
         $modulesList[$moduleName] = $moduleName;
     }
     // If calendar is disabled we should not show events module too
     // in layout editor
     if (!array_key_exists('Calendar', $modulesList)) {
         unset($modulesList['Events']);
     }
     return $modulesList;
 }

 /**
  * Function to get list of record models in this relation
  * @param <Vtiger_Paging_Model> $pagingModel
  * @return <array> List of record models <Vtiger_Record_Model>
  */
 public function getEntries($pagingModel)
 {
     $relationModel = $this->getRelationModel();
     $parentRecordModel = $this->getParentRecordModel();
     $relatedModuleName = $relationModel->getRelationModuleModel()->getName();
     $relatedRecordModelsList = parent::getEntries($pagingModel);
     $emailEnabledModulesInfo = $relationModel->getEmailEnabledModulesInfoForDetailView();
     if (array_key_exists($relatedModuleName, $emailEnabledModulesInfo) && $relatedRecordModelsList) {
         $fieldName = $emailEnabledModulesInfo[$relatedModuleName]['fieldName'];
         $tableName = $emailEnabledModulesInfo[$relatedModuleName]['tableName'];
         $db = PearDatabase::getInstance();
         $relatedRecordIdsList = array_keys($relatedRecordModelsList);
         $query = "SELECT campaignrelstatus, {$fieldName} FROM {$tableName}\n\t\t\t\t\t\tINNER JOIN vtiger_campaignrelstatus ON vtiger_campaignrelstatus.campaignrelstatusid = {$tableName}.campaignrelstatusid\n\t\t\t\t\t\tWHERE {$fieldName} IN (" . generateQuestionMarks($relatedRecordIdsList) . ") AND campaignid = ?";
         array_push($relatedRecordIdsList, $parentRecordModel->getId());
         $result = $db->pquery($query, $relatedRecordIdsList);
         $numOfrows = $db->num_rows($result);
         for ($i = 0; $i < $numOfrows; $i++) {
             $recordId = $db->query_result($result, $i, $fieldName);
             $relatedRecordModel = $relatedRecordModelsList[$recordId];
             $relatedRecordModel->set('status', $db->query_result($result, $i, 'campaignrelstatus'));
             $relatedRecordModelsList[$recordId] = $relatedRecordModel;
         }
     }
     return $relatedRecordModelsList;
 }

 public function deleteRecords(Vtiger_Request $request)
 {
     $searchValue = $request->get('search_value');
     $selectedIds = $request->get('selected_ids');
     $excludedIds = $request->get('excluded_ids');
     $db = PearDatabase::getInstance();
     $query = 'DELETE FROM vtiger_portal';
     $params = array();
     if (!empty($selectedIds) && $selectedIds != 'all' && count($selectedIds) > 0) {
         $query .= " WHERE portalid IN (" . generateQuestionMarks($selectedIds) . ")";
         $params = $selectedIds;
     } else {
         if ($selectedIds == 'all') {
             if (empty($searchValue) && count($excludedIds) > 0) {
                 $query .= " WHERE portalid NOT IN (" . generateQuestionMarks($excludedIds) . ")";
                 $params = $excludedIds;
             } else {
                 if (!empty($searchValue) && count($excludedIds) < 1) {
                     $query .= " WHERE portalname LIKE '%" . $searchValue . "%'";
                 } else {
                     if (!empty($searchValue) && count($excludedIds) > 0) {
                         $query .= " WHERE portalname LIKE '%" . $searchValue . "%' AND portalid NOT IN (" . generateQuestionMarks($excludedIds) . ")";
                         $params = $excludedIds;
                     }
                 }
             }
         }
     }
     $db->pquery($query, $params);
 }

	public static function getSupportedModulesList() {
		$db = PearDatabase::getInstance();

		$presence = array(0, 2);
		$restrictedModules = array('SPSocialConnector', 'SMSNotifier', 'Emails', 'Integration', 'Dashboard', 'ModComments', 'vtmessages', 'vttwitter');

		$query = 'SELECT name FROM vtiger_tab WHERE
						presence IN ('. generateQuestionMarks($presence) .')
						AND isentitytype = ?
						AND name NOT IN ('. generateQuestionMarks($restrictedModules) .')';
		$result = $db->pquery($query, array($presence, 1, $restrictedModules));
		$numOfRows = $db->num_rows($result);

		$modulesList = array();
		for($i=0; $i<$numOfRows; $i++) {
			$moduleName = $db->query_result($result, $i, 'name');
			$modulesList[$moduleName] = vtranslate($moduleName, $moduleName);
		}
		// If calendar is disabled we should not show events module too
		// in layout editor
        if(!array_key_exists('Calendar', $modulesList)) {
            unset($modulesList['Events']);
        }
		return $modulesList;
	}

 function Reports($reportId = "")
 {
     $db = PearDatabase::getInstance();
     $currentUser = Users_Record_Model::getCurrentUserModel();
     $userId = $currentUser->getId();
     $this->initListOfModules();
     if ($reportId != "") {
         // Lookup information in cache first
         $cachedInfo = VTCacheUtils::lookupReport_Info($userId, $reportId);
         $subOrdinateUsers = VTCacheUtils::lookupReport_SubordinateUsers($reportId);
         if ($cachedInfo === false) {
             $ssql = "SELECT vtiger_reportmodules.*, vtiger_report.* FROM vtiger_report\n\t\t\t\t\t\t\tINNER JOIN vtiger_reportmodules ON vtiger_report.reportid = vtiger_reportmodules.reportmodulesid\n\t\t\t\t\t\t\tWHERE vtiger_report.reportid = ?";
             $params = array($reportId);
             require_once 'include/utils/GetUserGroups.php';
             require 'user_privileges/user_privileges_' . $userId . '.php';
             $userGroups = new GetUserGroups();
             $userGroups->getAllUserGroups($userId);
             $userGroupsList = $userGroups->user_groups;
             if (!empty($userGroupsList) && $currentUser->isAdminUser() == false) {
                 $userGroupsQuery = " (shareid IN (" . generateQuestionMarks($userGroupsList) . ") AND setype='groups') OR";
                 array_push($params, $userGroupsList);
             }
             $nonAdminQuery = " vtiger_report.reportid IN (SELECT reportid from vtiger_reportsharing\n\t\t\t\t\t\t\t\t\tWHERE {$userGroupsQuery} (shareid=? AND setype='users'))";
             if ($currentUser->isAdminUser() == false) {
                 $ssql .= " AND (({$nonAdminQuery})\n\t\t\t\t\t\t\t\tOR vtiger_report.sharingtype = 'Public'\n\t\t\t\t\t\t\t\tOR vtiger_report.owner = ? OR vtiger_report.owner IN\n\t\t\t\t\t\t\t\t\t(SELECT vtiger_user2role.userid FROM vtiger_user2role\n\t\t\t\t\t\t\t\t\tINNER JOIN vtiger_users ON vtiger_users.id = vtiger_user2role.userid\n\t\t\t\t\t\t\t\t\tINNER JOIN vtiger_role ON vtiger_role.roleid = vtiger_user2role.roleid\n\t\t\t\t\t\t\t\t\tWHERE vtiger_role.parentrole LIKE '{$current_user_parent_role_seq}::%')\n\t\t\t\t\t\t\t\t)";
                 array_push($params, $userId, $userId);
             }
             $result = $db->pquery($ssql, $params);
             if ($result && $db->num_rows($result)) {
                 $reportModulesRow = $db->fetch_array($result);
                 // Update information in cache now
                 VTCacheUtils::updateReport_Info($userId, $reportId, $reportModulesRow["primarymodule"], $reportModulesRow["secondarymodules"], $reportModulesRow["reporttype"], $reportModulesRow["reportname"], $reportModulesRow["description"], $reportModulesRow["folderid"], $reportModulesRow["owner"]);
             }
             $subOrdinateUsers = array();
             $subResult = $db->pquery("SELECT userid FROM vtiger_user2role\n\t\t\t\t\t\t\t\t\tINNER JOIN vtiger_users ON vtiger_users.id = vtiger_user2role.userid\n\t\t\t\t\t\t\t\t\tINNER JOIN vtiger_role ON vtiger_role.roleid = vtiger_user2role.roleid\n\t\t\t\t\t\t\t\t\tWHERE vtiger_role.parentrole LIKE '{$current_user_parent_role_seq}::%'", array());
             $numOfSubRows = $db->num_rows($subResult);
             for ($i = 0; $i < $numOfSubRows; $i++) {
                 $subOrdinateUsers[] = $db->query_result($subResult, $i, 'userid');
             }
             // Update subordinate user information for re-use
             VTCacheUtils::updateReport_SubordinateUsers($reportId, $subOrdinateUsers);
             // Re-look at cache to maintain code-consistency below
             $cachedInfo = VTCacheUtils::lookupReport_Info($userId, $reportId);
         }
         if ($cachedInfo) {
             $this->primodule = $cachedInfo["primarymodule"];
             $this->secmodule = $cachedInfo["secondarymodules"];
             $this->reporttype = $cachedInfo["reporttype"];
             $this->reportname = decode_html($cachedInfo["reportname"]);
             $this->reportdescription = decode_html($cachedInfo["description"]);
             $this->folderid = $cachedInfo["folderid"];
             if ($currentUser->isAdminUser() == true || in_array($cachedInfo["owner"], $subOrdinateUsers) || $cachedInfo["owner"] == $userId) {
                 $this->is_editable = true;
             } else {
                 $this->is_editable = false;
             }
         }
     }
     return $this;
 }

 /**
  * To update call status from 'ringing' to 'no-response', if status not updated 
  * for more than 5 minutes
  * @param type $recordIds
  */
 public function updateCallStatus($recordIds) {
     $db = PearDatabase::getInstance();
     $query = "UPDATE ".self::moduletableName." SET callstatus='no-response' 
               WHERE pbxmanagerid IN (".generateQuestionMarks($recordIds).") 
               AND callstatus='ringing'";
     $db->pquery($query, $recordIds);
 }

    /**
     * Function to get mapping supported field ids list
     * @return <Array> list of field ids
     */
    public function getMappingSupportedFieldIdsList()
    {
        if (!$this->supportedFieldIdsList) {
            $selectedTabidsList[] = getTabid($this->getName());
            $presense = array(0, 2);
            $restrictedFieldNames = array('campaignrelstatus');
            $restrictedUitypes = array(4, 10, 51, 52, 53, 57, 58, 69, 70);
            $selectedGeneratedTypes = array(1, 2);
            $db = PearDatabase::getInstance();
            $query = 'SELECT fieldid FROM vtiger_field
						WHERE presence IN (' . generateQuestionMarks($presense) . ')
						AND tabid IN (' . generateQuestionMarks($selectedTabidsList) . ')
						AND uitype NOT IN (' . generateQuestionMarks($restrictedUitypes) . ')
						AND fieldname NOT IN (' . generateQuestionMarks($restrictedFieldNames) . ')
						AND generatedtype IN (' . generateQuestionMarks($selectedGeneratedTypes) . ')';
            $params = array_merge($presense, $selectedTabidsList, $restrictedUitypes, $restrictedFieldNames, $selectedGeneratedTypes);
            $result = $db->pquery($query, $params);
            $numOfRows = $db->num_rows($result);
            $fieldIdsList = array();
            for ($i = 0; $i < $numOfRows; $i++) {
                $fieldIdsList[] = $db->query_result($result, $i, 'fieldid');
            }
            $this->supportedFieldIdsList = $fieldIdsList;
        }
        return $this->supportedFieldIdsList;
    }

 public function showEmailsList($srecord, $smodule, $config, $type, $filter = 'All')
 {
     $return = [];
     $adb = PearDatabase::getInstance();
     $widgets = $this->modules_email_actions_widgets;
     $queryParams = [];
     if ($widgets[$smodule]) {
         $ids = [];
         $relatedID = [];
         if ($filter == 'All' || $filter == 'Contacts') {
             $result = $adb->pquery('SELECT vtiger_contactdetails.contactid FROM vtiger_contactdetails ' . 'INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_contactdetails.contactid ' . 'WHERE vtiger_contactdetails.parentid = ? AND vtiger_crmentity.deleted = ?', [$srecord, 0]);
             while ($row = $adb->fetch_array($result)) {
                 $relatedID[] = $row['contactid'];
             }
         }
         if ($filter != 'Contacts') {
             $relatedID[] = $srecord;
         }
         $query = 'SELECT ossmailviewid FROM vtiger_ossmailview_relation WHERE crmid IN(' . implode(',', $relatedID) . ') AND `deleted` = ? ORDER BY `date` DESC';
         if ($config['widget_limit'] != '') {
             $query .= ' LIMIT ' . $config['widget_limit'];
         }
         $result = $adb->pquery($query, [0]);
         while ($row = $adb->fetch_array($result)) {
             $ids[] = $row['ossmailviewid'];
         }
         if (count($ids) == 0) {
             return [];
         }
         $queryParams[] = $ids;
         if ($type != 'All') {
             $ifwhere = ' AND type = ?';
             $queryParams[] = $type;
         }
         $query = 'SELECT vtiger_ossmailview.* FROM vtiger_ossmailview INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_ossmailview.ossmailviewid';
         $query .= ' WHERE ossmailviewid IN (' . generateQuestionMarks($ids) . ')' . $ifwhere;
         $currentUser = Users_Record_Model::getCurrentUserModel();
         $moduleName = 'OSSMailView';
         $instance = CRMEntity::getInstance($moduleName);
         $securityParameter = $instance->getUserAccessConditionsQuerySR($moduleName, $currentUser);
         if ($securityParameter != '') {
             $query .= $securityParameter;
         }
         $query .= ' ORDER BY ossmailviewid DESC';
         if ($config['widget_limit'] != '') {
             $query .= ' LIMIT ' . $config['widget_limit'];
         }
         $result = $adb->pquery($query, $queryParams, true);
         while ($row = $adb->fetch_array($result)) {
             $from = $this->findRecordsById($row['from_id']);
             $from = $from && $from != '' ? $from : $row['from_email'];
             $to = $this->findRecordsById($row['to_id']);
             $to = $to && $to != '' ? $to : $row['to_email'];
             $content = Vtiger_Functions::removeHtmlTags(['link', 'style', 'a', 'img', 'script', 'base'], decode_html($row['content']));
             $return[] = ['id' => $row['ossmailviewid'], 'date' => $row['date'], 'firstLetter' => strtoupper(Vtiger_Functions::textLength(trim(strip_tags($from)), 1, false)), 'subject' => '<a href="index.php?module=OSSMailView&view=preview&record=' . $row['ossmailviewid'] . '" target="' . $config['target'] . '"> ' . $row['subject'] . '</a>', 'attachments' => $row['attachments_exist'], 'from' => $from, 'to' => $to, 'url' => 'index.php?module=OSSMailView&view=preview&record=' . $row['ossmailviewid'], 'type' => $row['type'], 'teaser' => Vtiger_Functions::textLength(trim(preg_replace('/[ \\t]+/', ' ', strip_tags($content))), 100), 'body' => $content];
         }
     }
     return $return;
 }

	/**
	 * Function to delete records
	 * @param <Array> $recordIdsList
	 * @return <Boolean> true/false
	 */
	public static function deleteRecords($recordIdsList = array()) {
		if ($recordIdsList) {
			$db = PearDatabase::getInstance();
			$query = 'DELETE FROM vtiger_sysvars WHERE id IN (' . generateQuestionMarks($recordIdsList). ')';
			$db->pquery($query, $recordIdsList);
			return true;
		}
		return false;
	}

 public function process(Vtiger_Request $request)
 {
     PDFMaker_Debugger_Model::GetInstance()->Init();
     $PDFMaker = new PDFMaker_PDFMaker_Model();
     if ($PDFMaker->CheckPermissions("DELETE") == false) {
         $PDFMaker->DieDuePermission();
     }
     $adb = PearDatabase::getInstance();
     $id_array = array();
     if ($request->has('templateid') && !$request->isEmpty('templateid')) {
         $templateid = $request->get('templateid');
         $checkSql = "select module from vtiger_pdfmaker where templateid=?";
         $checkRes = $adb->pquery($checkSql, array($templateid));
         $checkRow = $adb->fetchByAssoc($checkRes);
         //if we are trying to delete template that is not allowed for current user then die because user should not be able to see the template
         //$PDFMaker->CheckTemplatePermissions($checkRow["module"], $templateid);
         $Template_Permissions_Data = $PDFMaker->returnTemplatePermissionsData($checkRow["module"], $templateid);
         if ($Template_Permissions_Data["delete"] === false) {
             $this->DieDuePermission();
         }
         $sql = "delete from vtiger_pdfmaker where templateid=?";
         $adb->pquery($sql, array($templateid));
         $sql = "delete from vtiger_pdfmaker_settings where templateid=?";
         $adb->pquery($sql, array($templateid));
     } else {
         $idlist = $request->get('idlist');
         $id_array = explode(';', $idlist);
         $checkSql = "select templateid, module from vtiger_pdfmaker where templateid IN (" . generateQuestionMarks($id_array) . ")";
         $checkRes = $adb->pquery($checkSql, $id_array);
         $checkArr = array();
         while ($checkRow = $adb->fetchByAssoc($checkRes)) {
             $checkArr[$checkRow["templateid"]] = $checkRow["module"];
         }
         for ($i = 0; $i < count($id_array) - 1; $i++) {
             //if we are trying to delete template that is not allowed for current user then die because user should not be able to see the template
             //$PDFMaker->CheckTemplatePermissions($checkArr[$id_array[$i]], $id_array[$i]);
             $Template_Permissions_Data = $PDFMaker->returnTemplatePermissionsData($checkArr[$id_array[$i]], $id_array[$i]);
             if ($Template_Permissions_Data["delete"] === false) {
                 $this->DieDuePermission();
             }
             $sql = "delete from vtiger_pdfmaker where templateid=?";
             $adb->pquery($sql, array($id_array[$i]));
             $sql = "delete from vtiger_pdfmaker_settings where templateid=?";
             $adb->pquery($sql, array($id_array[$i]));
         }
     }
     $ajaxDelete = $request->get('ajaxDelete');
     $listViewUrl = "index.php?module=PDFMaker&view=List";
     if ($ajaxDelete) {
         $response = new Vtiger_Response();
         $response->setResult($listViewUrl);
         return $response;
     } else {
         header("Location: {$listViewUrl}");
     }
 }

function vtGetModules($adb)
{
    $modules_not_supported = array('Documents', 'Calendar', 'Emails', 'Faq', 'Events', 'PBXManager', 'Users');
    $sql = "select distinct vtiger_field.tabid, name\n\t\t\tfrom vtiger_field \n\t\t\tinner join vtiger_tab \n\t\t\t\ton vtiger_field.tabid=vtiger_tab.tabid \n\t\t\twhere vtiger_tab.name not in(" . generateQuestionMarks($modules_not_supported) . ") and vtiger_tab.isentitytype=1 and vtiger_tab.presence = 0 ";
    $it = new SqlResultIterator($adb, $adb->pquery($sql, array($modules_not_supported)));
    $modules = array();
    foreach ($it as $row) {
        $modules[] = $row->name;
    }
    return $modules;
}

 /** to get all the parent vtiger_groups of the specified group
  * @params $groupId --> Group Id :: Type Integer
  * @returns updates the parent group in the varibale $parent_groups of the class
  */
 function getAllUserGroups($userid)
 {
     $adb = PearDatabase::getInstance();
     $log = vglobal('log');
     $log->debug("Entering getAllUserGroups(" . $userid . ") method...");
     //Retreiving from the user2grouptable
     $query = "select * from vtiger_users2group where userid=?";
     $result = $adb->pquery($query, array($userid));
     $num_rows = $adb->num_rows($result);
     for ($i = 0; $i < $num_rows; $i++) {
         $now_group_id = $adb->query_result($result, $i, 'groupid');
         if (!in_array($now_group_id, $this->user_groups)) {
             $this->user_groups[] = $now_group_id;
         }
     }
     //Setting the User Role
     $userRole = fetchUserRole($userid);
     //Retreiving from the vtiger_user2role
     $query = "select * from vtiger_group2role where roleid=?";
     $result = $adb->pquery($query, array($userRole));
     $num_rows = $adb->num_rows($result);
     for ($i = 0; $i < $num_rows; $i++) {
         $now_group_id = $adb->query_result($result, $i, 'groupid');
         if (!in_array($now_group_id, $this->user_groups)) {
             $this->user_groups[] = $now_group_id;
         }
     }
     //Retreiving from the user2rs
     $parentRoles = getParentRole($userRole);
     $parentRolelist = array();
     foreach ($parentRoles as $par_rol_id) {
         array_push($parentRolelist, $par_rol_id);
     }
     array_push($parentRolelist, $userRole);
     $query = "select * from vtiger_group2rs where roleandsubid in (" . generateQuestionMarks($parentRolelist) . ")";
     $result = $adb->pquery($query, array($parentRolelist));
     $num_rows = $adb->num_rows($result);
     for ($i = 0; $i < $num_rows; $i++) {
         $now_group_id = $adb->query_result($result, $i, 'groupid');
         if (!in_array($now_group_id, $this->user_groups)) {
             $this->user_groups[] = $now_group_id;
         }
     }
     foreach ($this->user_groups as $grp_id) {
         $focus = new GetParentGroups();
         $focus->getAllParentGroups($grp_id);
         foreach ($focus->parent_groups as $par_grp_id) {
             if (!in_array($par_grp_id, $this->user_groups)) {
                 $this->user_groups[] = $par_grp_id;
             }
         }
     }
     $log->debug("Exiting getAllUserGroups method...");
 }

 public function save()
 {
     $db = PearDatabase::getInstance();
     $map = $this->getAllValues();
     $map['content'] = "" . $db->getEmptyBlob() . "";
     $columnNames = array_keys($map);
     $columnValues = array_values($map);
     if (count($map) > 0) {
         $db->pquery('INSERT INTO ' . self::$tableName . ' (' . implode(',', $columnNames) . ') VALUES (' . generateQuestionMarks($columnValues) . ')', array($columnValues));
         $db->updateBlob(self::$tableName, "content", "name='" . $db->sql_escape_string($this->getValue('name')) . "' AND module='" . $db->sql_escape_string($this->getValue('module')) . "'", $this->getStringifiedContent());
     }
 }

 public function __create($elementType, $element)
 {
     require_once 'include/utils/utils.php';
     $db = PearDatabase::getInstance();
     $this->id = $this->getNextId($elementType, $element);
     $element[$this->meta->getObectIndexColumn()] = $this->id;
     //Insert into group vtiger_table
     $query = "insert into {$this->entityTableName}(" . implode(',', array_keys($element)) . ") values(" . generateQuestionMarks(array_keys($element)) . ")";
     $result = null;
     $transactionSuccessful = vtws_runQueryAsTransaction($query, array_values($element), $result);
     return $transactionSuccessful;
 }

 function save()
 {
     $adb = PearDatabase::getInstance();
     if (count($this->fieldData) == 0) {
         return;
     }
     if (!Vtiger_Utils::CheckTable($this->tableName)) {
         Vtiger_Utils::CreateTable($this->tableName, "(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\n\t\t\t\t\tuserid INT NOT NULL,\n\t\t\t\t\tentitytype VARCHAR(200) NOT NULL,\n\t\t\t\t\tcrmid INT NOT NULL)", true);
     }
     $fieldNames = array_keys($this->fieldData);
     $fieldValues = array_values($this->fieldData);
     $adb->pquery('INSERT INTO ' . $this->tableName . '(' . implode(',', $fieldNames) . ') VALUES (' . generateQuestionMarks($fieldValues) . ')', array($fieldValues));
 }

	public function getModulesList()
	{
		$adb = PearDatabase::getInstance();
		$restrictedModules = array('Emails', 'Integration', 'Dashboard', 'ModComments', 'SMSNotifier');
		$sql = 'SELECT * FROM vtiger_tab WHERE isentitytype = ? AND name NOT IN (' . generateQuestionMarks($restrictedModules) . ')';
		$params = array(1, $restrictedModules);
		$result = $adb->pquery($sql, $params);
		$modules = array();
		while ($row = $adb->fetch_array($result)) {
			$modules[$row['tabid']] = $row;
		}
		return $modules;
	}

function Contacts_createPortalLoginDetails($entityData)
{
    vimport('modules.Settings.CustomerPortal.helpers.CustomerPortalPassword');
    $encodePass = vglobal('encode_customer_portal_passwords');
    $adb = PearDatabase::getInstance();
    $wsId = $entityData->getId();
    $parts = explode('x', $wsId);
    $entityId = $parts[1];
    $email = $entityData->get('email');
    if (($entityData->get('portal') == 'on' || $entityData->get('portal') == '1') && $entityData->get('contactstatus') != 'Inactive') {
        $sql = "SELECT id, user_name, user_password, isactive FROM vtiger_portalinfo WHERE id=?";
        $result = $adb->pquery($sql, array($entityId));
        $insert = false;
        if ($adb->num_rows($result) == 0) {
            $insert = true;
        } else {
            $dbusername = $adb->query_result($result, 0, 'user_name');
            $isactive = $adb->query_result($result, 0, 'isactive');
            if ($email == $dbusername && $isactive == 1 && !$entityData->isNew()) {
                $update = false;
            } else {
                if ($entityData->get('portal') == 'on' || $entityData->get('portal') == '1') {
                    $sql = "UPDATE vtiger_portalinfo SET user_name=?, isactive=1 WHERE id=?";
                    $adb->pquery($sql, array($email, $entityId));
                    $password = $adb->query_result($result, 0, 'user_password');
                    $update = true;
                } else {
                    $sql = "UPDATE vtiger_portalinfo SET user_name=?, isactive=? WHERE id=?";
                    $adb->pquery($sql, array($email, 0, $entityId));
                    $update = false;
                }
            }
        }
        if ($insert == true) {
            $password = makeRandomPassword();
            $truePassword = $password;
            if ($encodePass) {
                $password = CustomerPortalPassword::encryptPassword($password, $email);
                $params = array($entityId, $email, $password, 'C', 1, CustomerPortalPassword::getCryptType(), $truePassword);
                $sql = "INSERT INTO vtiger_portalinfo(`id`, `user_name`, `user_password`, `type`, `isactive`, `crypt_type`, `password_sent`) VALUES(" . generateQuestionMarks($params) . ")";
            } else {
                $params = array($entityId, $email, $password, 'C', 1, $truePassword);
                $sql = "INSERT INTO vtiger_portalinfo(`id`, `user_name`, `user_password`, `type`, `isactive`, `password_sent`) VALUES(" . generateQuestionMarks($params) . ")";
            }
            $adb->pquery($sql, $params);
        }
    } else {
        $sql = "UPDATE vtiger_portalinfo SET user_name=?,isactive=0 WHERE id=?";
        $adb->pquery($sql, array($email, $entityId));
    }
}