PHP Vtiger_Cache::getInstance方法代码示例

 /**
  * Get instance of block
  * @param mixed block id or block label
  * @param Vtiger_Module Instance of the module if block label is passed
  */
 static function getInstance($value, $moduleInstance = false)
 {
     global $adb;
     $cache = Vtiger_Cache::getInstance();
     if ($moduleInstance && $cache->getBlockInstance($value, $moduleInstance->id)) {
         return $cache->getBlockInstance($value, $moduleInstance->id);
     } else {
         $instance = false;
         $query = false;
         $queryParams = false;
         if (Vtiger_Utils::isNumber($value)) {
             $query = "SELECT * FROM vtiger_blocks WHERE blockid=?";
             $queryParams = array($value);
         } else {
             $query = "SELECT * FROM vtiger_blocks WHERE blocklabel=? AND tabid=?";
             $queryParams = array($value, $moduleInstance->id);
         }
         $result = $adb->pquery($query, $queryParams);
         if ($adb->num_rows($result)) {
             $instance = new self();
             $instance->initialize($adb->fetch_array($result), $moduleInstance);
         }
         $cache->setBlockInstance($value, $instance->module->id, $instance);
         return $instance;
     }
 }

 /**
  * Function to get the user if of the active admin user.
  * @return Integer - Active Admin User ID
  */
 public static function getActiveAdminId()
 {
     $adb = PearDatabase::getInstance();
     $cache = Vtiger_Cache::getInstance();
     if ($cache->getAdminUserId()) {
         return $cache->getAdminUserId();
     } else {
         $sql = "SELECT id FROM vtiger_users WHERE is_admin = 'on' AND status = 'Active' limit 1";
         $result = $adb->pquery($sql, array());
         $adminId = 1;
         $it = new SqlResultIterator($adb, $result);
         foreach ($it as $row) {
             $adminId = $row->id;
         }
         $cache->setAdminUserId($adminId);
         return $adminId;
     }
 }

function getUserId_Ol($username)
{
    global $log;
    $log->debug("Entering getUserId_Ol(" . $username . ") method ...");
    $log->info("in getUserId_Ol " . $username);
    $cache = Vtiger_Cache::getInstance();
    if ($cache->getUserId($username) || $cache->getUserId($username) === 0) {
        return $cache->getUserId($username);
    } else {
        global $adb;
        $sql = "select id from vtiger_users where user_name=?";
        $result = $adb->pquery($sql, array($username));
        $num_rows = $adb->num_rows($result);
        if ($num_rows > 0) {
            $user_id = $adb->query_result($result, 0, "id");
        } else {
            $user_id = 0;
        }
        $log->debug("Exiting getUserId_Ol method ...");
        $cache->setUserId($username, $user_id);
        return $user_id;
    }
}

 /**
  * Get Vtiger_Field instances related to block
  * @param Vtiger_Block Instnace of block to use
  * @param Vtiger_Module Instance of module to which block is associated
  */
 static function getAllForBlock($blockInstance, $moduleInstance = false)
 {
     $cache = Vtiger_Cache::getInstance();
     if ($cache->getBlockFields($blockInstance->id, $moduleInstance->id)) {
         return $cache->getBlockFields($blockInstance->id, $moduleInstance->id);
     } else {
         global $adb;
         $instances = false;
         $query = false;
         $queryParams = false;
         if ($moduleInstance) {
             $query = "SELECT * FROM vtiger_field WHERE block=? AND tabid=? ORDER BY sequence";
             $queryParams = array($blockInstance->id, $moduleInstance->id);
         } else {
             $query = "SELECT * FROM vtiger_field WHERE block=? ORDER BY sequence";
             $queryParams = array($blockInstance->id);
         }
         $result = $adb->pquery($query, $queryParams);
         for ($index = 0; $index < $adb->num_rows($result); ++$index) {
             $instance = new self();
             $instance->initialize($adb->fetch_array($result), $moduleInstance, $blockInstance);
             $instances[] = $instance;
         }
         $cache->setBlockFields($blockInstance->id, $moduleInstance->id, $instances);
         return $instances;
     }
 }

 public static function getAssignedToGroupList($module)
 {
     $cache = Vtiger_Cache::getInstance();
     if ($cache->getGroupList($module, $current_user->id)) {
         return $cache->getGroupList($module, $current_user->id);
     } else {
         $groupList = get_group_array(FALSE, "Active", $current_user->id);
         $cache->setGroupList($module, $groupList, $current_user->id);
         return $groupList;
     }
 }

/**
	 * Function to get Creator of this record
	 * @param <Integer> $recordId
	 * @return <Integer>
	 */
	public static function getCreator($recordId) {
		$cache = Vtiger_Cache::getInstance();
		if ($cache->hasCreator($recordId)) {
			return $cache->getCreator($recordId);
		}

		$db = PearDatabase::getInstance();
		$result = $db->pquery('SELECT smcreatorid FROM vtiger_crmentity WHERE crmid = ?', array($recordId));
		$creatorId = $db->query_result($result, 0, 'smcreatorid');

		if ($creatorId) {
			$cache->setCreator($recordId, $creatorId);
		}
		return $creatorId;
	}

/**
 * this function returns all the assigned picklist values for the given tablename for the given roleid
 * @param string $tableName - the picklist tablename
 * @param integer $roleid - the roleid of the role for which you want data
 * @param object $adb - the peardatabase object
 * @return array $val - the assigned picklist values in array format
 */
function getAssignedPicklistValues($tableName, $roleid, $adb, $lang = array())
{
    $cache = Vtiger_Cache::getInstance();
    if ($cache->hasAssignedPicklistValues($tableName, $roleid)) {
        return $cache->getAssignedPicklistValues($tableName, $roleid);
    } else {
        $arr = array();
        $sql = "select picklistid from vtiger_picklist where name = ?";
        $result = $adb->pquery($sql, array($tableName));
        if ($adb->num_rows($result)) {
            $picklistid = $adb->query_result($result, 0, "picklistid");
            $sub = getSubordinateRoleAndUsers($roleid);
            $subRoles = array($roleid);
            $subRoles = array_merge($subRoles, array_keys($sub));
            $roleids = array();
            foreach ($subRoles as $role) {
                $roleids[] = $role;
            }
            $sql = "SELECT distinct " . $adb->sql_escape_string($tableName) . " FROM " . $adb->sql_escape_string("vtiger_{$tableName}") . " inner join vtiger_role2picklist on " . $adb->sql_escape_string("vtiger_{$tableName}") . ".picklist_valueid=vtiger_role2picklist.picklistvalueid" . " and roleid in (" . generateQuestionMarks($roleids) . ") order by sortid";
            $result = $adb->pquery($sql, $roleids);
            $count = $adb->num_rows($result);
            if ($count) {
                while ($resultrow = $adb->fetch_array($result)) {
                    $pick_val = decode_html($resultrow[$tableName]);
                    if ($lang[$pick_val] != '') {
                        $arr[$pick_val] = $lang[$pick_val];
                    } else {
                        $arr[$pick_val] = $pick_val;
                    }
                }
            }
        }
        // END
        $cache->setAssignedPicklistValues($tableName, $roleid, $arr);
        return $arr;
    }
}

 function getPicklistDetails()
 {
     $cache = Vtiger_Cache::getInstance();
     if ($cache->getPicklistDetails($this->getTabId(), $this->getFieldName())) {
         return $cache->getPicklistDetails($this->getTabId(), $this->getFieldName());
     } else {
         $hardCodedPickListNames = array("hdntaxtype", "email_flag");
         $hardCodedPickListValues = array("hdntaxtype" => array(array("label" => "Individual", "value" => "individual"), array("label" => "Group", "value" => "group")), "email_flag" => array(array('label' => 'SAVED', 'value' => 'SAVED'), array('label' => 'SENT', 'value' => 'SENT'), array('label' => 'MAILSCANNER', 'value' => 'MAILSCANNER')));
         if (in_array(strtolower($this->getFieldName()), $hardCodedPickListNames)) {
             return $hardCodedPickListValues[strtolower($this->getFieldName())];
         }
         $picklistDetails = $this->getPickListOptions($this->getFieldName());
         $cache->setPicklistDetails($this->getTabId(), $this->getFieldName(), $picklistDetails);
         return $picklistDetails;
     }
 }

 /**
  * Function which will give the non editable picklist values for a field
  * @param type $fieldName -- string
  * @return type -- array of values
  */
 public static function getNonEditablePicklistValues($fieldName)
 {
     $cache = Vtiger_Cache::getInstance();
     $NonEditablePicklistValues = $cache->get('NonEditablePicklistValues', $fieldName);
     if ($NonEditablePicklistValues) {
         return $NonEditablePicklistValues;
     }
     $db = PearDatabase::getInstance();
     $query = "select {$fieldName} from vtiger_{$fieldName} where presence=0";
     $values = array();
     $result = $db->pquery($query, array());
     $num_rows = $db->num_rows($result);
     for ($i = 0; $i < $num_rows; $i++) {
         //Need to decode the picklist values twice which are saved from old ui
         $values[] = decode_html(decode_html($db->query_result($result, $i, $fieldName)));
     }
     $cache->set('NonEditablePicklistValues', $fieldName, $values);
     return $values;
 }

 /**
  * Function to get Creator of this record
  * @param <Integer> $recordId
  * @return <Integer>
  */
 public static function getCreator($recordId)
 {
     global $log;
     $log->debug("Entering ./helpers/Util.php::staticgetCreator");
     $cache = Vtiger_Cache::getInstance();
     if ($cache->hasCreator($recordId)) {
         $log->debug("Exiting ./helpers/Util.php::staticgetCreator");
         return $cache->getCreator($recordId);
     }
     $db = PearDatabase::getInstance();
     $result = $db->pquery('SELECT smcreatorid FROM vtiger_crmentity WHERE crmid = ?', array($recordId));
     $creatorId = $db->query_result($result, 0, 'smcreatorid');
     if ($creatorId) {
         $cache->setCreator($recordId, $creatorId);
     }
     $log->debug("Exiting ./helpers/Util.php::staticgetCreator");
     return $creatorId;
 }

/**
 * this function returns all the assigned picklist values for the given tablename for the given roleid
 * @param string $tableName - the picklist tablename
 * @param integer $roleid - the roleid of the role for which you want data
 * @param object $adb - the peardatabase object
 * @return array $val - the assigned picklist values in array format
 */
function getAssignedPicklistValues($tableName, $roleid, $adb, $lang = array())
{
    $cache = Vtiger_Cache::getInstance();
    if ($cache->hasAssignedPicklistValues($tableName, $roleid)) {
        return $cache->getAssignedPicklistValues($tableName, $roleid);
    } else {
        $arr = array();
        $sql = "select picklistid from vtiger_picklist where name = ?";
        $result = $adb->pquery($sql, array($tableName));
        if ($adb->num_rows($result)) {
            $picklistid = $adb->query_result($result, 0, "picklistid");
            $sub = getSubordinateRoleAndUsers($roleid);
            $subRoles = array($roleid);
            $subRoles = array_merge($subRoles, array_keys($sub));
            $roleids = array();
            foreach ($subRoles as $role) {
                $roleids[] = $role;
            }
            $sql = 'SELECT distinct ' . $adb->sql_escape_string($tableName, true) . ' FROM ' . $adb->sql_escape_string("vtiger_{$tableName}", true) . ' inner join vtiger_role2picklist on ' . $adb->sql_escape_string("vtiger_{$tableName}", true) . '.picklist_valueid=vtiger_role2picklist.picklistvalueid' . ' and roleid in (' . $adb->generateQuestionMarks($roleids) . ') order by sortid';
            $result = $adb->pquery($sql, $roleids);
            $count = $adb->num_rows($result);
            if ($count) {
                while ($resultrow = $adb->fetch_array($result)) {
                    /** Earlier we used to save picklist values by encoding it. Now, we are directly saving those(getRaw()).
                     *  If value in DB is like "test1 & test2" then $abd->fetch_array() is giving it as
                     *  "test1 &$amp; test2" which we should decode two time to get result
                     */
                    $pick_val = decode_html(decode_html($resultrow[$tableName]));
                    if ($lang[$pick_val] != '') {
                        $arr[$pick_val] = $lang[$pick_val];
                    } else {
                        $arr[$pick_val] = $pick_val;
                    }
                }
            }
        }
        // END
        $cache->setAssignedPicklistValues($tableName, $roleid, $arr);
        return $arr;
    }
}

 /**
  * Function which will give the non editable picklist values for a field
  * @param type $fieldName -- string
  * @return type -- array of values
  */
 public static function getNonEditablePicklistValues($fieldName)
 {
     $cache = Vtiger_Cache::getInstance();
     $NonEditablePicklistValues = $cache->get('NonEditablePicklistValues', $fieldName);
     if ($NonEditablePicklistValues) {
         return $NonEditablePicklistValues;
     }
     $db = PearDatabase::getInstance();
     //SalesPlatform.ru begin fix picklist value unique id cretation
     $primaryKey = Vtiger_Util_Helper::getPickListId($fieldName);
     $query = "select {$primaryKey} ,{$fieldName} from vtiger_{$fieldName} where presence=0";
     //$query = "select $fieldName from vtiger_$fieldName where presence=0";
     //SalesPlatform.ru end
     $values = array();
     $result = $db->pquery($query, array());
     $num_rows = $db->num_rows($result);
     for ($i = 0; $i < $num_rows; $i++) {
         //Need to decode the picklist values twice which are saved from old ui
         //SalesPlatform.ru begin fix picklist value unique id cretation
         $values[$db->query_result($result, $i, $primaryKey)] = decode_html(decode_html($db->query_result($result, $i, $fieldName)));
         //$values[] = decode_html(decode_html($db->query_result($result,$i,$fieldName)));
         //SalesPlatform.ru end
     }
     $cache->set('NonEditablePicklistValues', $fieldName, $values);
     return $values;
 }