- List of Vtiger Module Model or sub class instances */ public static function getAll() { return parent::getAll(array(0,1), self::getNonVisibleModulesList()); } /** * Function which will get count of modules * @param $onlyActive - if true get count of only active modules else all the modules * @return number of modules */ public static function getModulesCount($onlyActive = false) { $db = PearDatabase::getInstance(); $query = 'SELECT * FROM vtiger_tab'; $params = array(); if($onlyActive) { $presence = array(0); $nonVisibleModules = self::getNonVisibleModulesList(); $query .= ' WHERE presence IN ('. generateQuestionMarks($presence) .')'; $query .= ' AND name NOT IN ('.generateQuestionMarks($nonVisibleModules).')'; array_push($params, $presence,$nonVisibleModules); } $result = $db->pquery($query, $params); return $db->num_rows($result); } /** * Function that returns all those modules that support Module Sequence Numbering * @global PearDatabase $db - database connector * @return */ public static function getModulesSupportingSequenceNumbering() { $db = PearDatabase::getInstance(); $sql="SELECT tabid, name FROM vtiger_tab WHERE isentitytype = 1 AND presence = 0 AND tabid IN (SELECT DISTINCT tabid FROM vtiger_field WHERE uitype = '4')"; $result = $db->pquery($sql, array()); $moduleModels = array(); for($i=0; $i<$db->num_rows($result); ++$i) { $row = $db->query_result_rowdata($result, $i); $moduleModels[$row['name']] = self::getInstanceFromArray($row); } return $moduleModels; } /** * Function to get restricted modules list * @return List module names */ public static function getActionsRestrictedModulesList() { return array('Home', 'Emails', 'Webmails'); } }