BxDolAclQuery Class Reference

Inheritance diagram for BxDolAclQuery:

Public Member Functions
	__clone ()
	getLevels ($aParams, &$aItems, $bReturnCount=true)
	getActions ($aParams, &$aItems, $bReturnCount=true)
	getLevelCurrent ($iProfileId, $iTime=0)
	getLevelByIdCached ($iLevel)
	getAction ($iMembershipId, $iActionId)
	getActionTrack ($iActionId, $iProfileId)
	insertActionTarck ($iActionId, $iProfileId, $iActionsLeft, $iValidSince)
	updateActionTrack ($iActionId, $iProfileId, $iActionsLeft, $iValidSince=0)
	insertLevelByProfileId ($iProfileId, $iMembershipId, $iDateStarts, $aPeriod, $sTransactionId)
	deleteLevelByProfileId ($iProfileId, $bAll=false)
	deleteLevelBy ($aWhere)
	maintenance ($iDaysToCleanMemLevels=0)
	clearActionsTracksForMember ($iMemberId)
	getContentByLevelAsSQLPart ($sContentTable, $sContentField, $mixedLevelId)
	getContentByActionAsSQLPart ($sContentTable, $sContentField, $mixedActionName, $aParams=[])
	getProfilesByMembership ($mixedLevelId)
	getProfilesByAction ($mixedActionName, $aParams=[])
Public Member Functions inherited from BxDolDb
	setReadOnlyMode ($b)
	connect ()
	disconnect ()
	ping ()
	pdoExec ($sQuery)
	pdoQuery ($sQuery)
	pdoExceptionHandler ($oException)
	getOption ($sName)
	getOne ($oStatement, $aBindings=array(), $iIndex=0)
	getRow ($oStatement, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
	getColumn ($oStatement, $aBindings=array(), $iFetchColumnNumber=0)
	getFirstRow ($oStatement, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
	getNextRow ($iFetchType=PDO::FETCH_ASSOC)
	getAll ($oStatement, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
	fillArray ($oStatement, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
	getAllWithKey ($oStatement, $sFieldKey, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
	getPairs ($oStatement, $sFieldKey, $sFieldValue, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
	getNumRows ($oStatement=null)
	getAffectedRows ($oStatement=null)
	lastId ()
	query ($oStatement, $aBindings=array(), $bVerbose=null)
	res ($oStatement, $aBindings=array(), $bVerbose=null)
	getServerInfo ()
	getVersion ()
	listTables ()
	getFields ($sTable)
	fetchField ($oStatement, $iField, $aBindings=array())
	isTableExists ($sTable)
	isFieldExists ($sTable, $sFieldName)
	isIndexExists ($sTable, $sIndexName)
	error ($aError)
	cacheParams ($bForceCacheInvalidate=false, $bForceCacheInvalidateMixed=false)
	cacheParamsClear ($sCacheName='')
	isParam ($sKey, $bFromCache=true)
	addParam ($sName, $sValue, $iKateg, $sDesc, $sType)
	getParam ($sKey, $bFromCache=true)
	setParam ($sKey, $mixedValue, $iMixId=0)
	getParamsMix ($iId)
	getParamsMixActive ($sType)
	getParamsMixes ($sType, $mixedPublished=false)
	setTimezone ($sTimezone)
	getEncoding ()
	setErrorChecking ($b)
	getDbCacheObject ()
	genDbCacheKey ($sName)
	getCache ($sName, $sFunc)
	setCache ($sName, $mData)
	fromCache ($sName, $sFunc)
	cleanCache ($sName)
&	fromMemory ($sName, $sFunc)
	cleanMemory ($sName)
	cleanMemoryAll ()
	escape ($s)
	implode_escape ($mixed)
	unescape ($mixed)
	prepare ($sQuery)
	prepareAsString ($sQuery)
	arrayToSQL ($a, $sDiv=',', $sOperator='=', $bWildcardSpaceChars=false)
	executeSQL ($sPath, $aReplace=array(), $isBreakOnError=true)

Static Public Member Functions
static	getInstance ()
Static Public Member Functions inherited from BxDolDb
static	getInstanceWithConf ($aDbConf, &$sError)
static	getLink ()

Additional Inherited Members
Protected Member Functions inherited from BxDolDb
	__construct ($aDbConf=false)
	balancer ()
	isParamInCache ($sKey)
	log ($s)
	executeStatement ($oStatement, $aBindings=array(), $bVerbose=null, &$iErrorCode=null)
	executeStatementException ($oStatement, $aBindings=array(), $bVerbose=null)
	executeStatementSilent ($oStatement, $aBindings=array(), $bVerbose=null)
	errorOutput ($aError)
Protected Attributes inherited from BxDolDb
	$_bPdoPersistent
	$_iPdoFetchType
	$_iPdoErrorMode
	$_bErrorChecking
	$_aError
	$_sHost
	$_sPort
	$_sSocket
	$_sDbname
	$_sUser
	$_sPassword
	$_sCharset
	$_sStorageEngine
	$_oStatement = null
	$_oDbCacheObject = null
Static Protected Attributes inherited from BxDolDb
static	$_rLink
static	$_aDbCacheData
static	$_aParams
static	$_sParamsCacheName = 'sys_options'
static	$_sParamsCacheNameMixed = 'sys_options_mixed_'
static	$_sParamsCacheNameMix = 'sys_options_mix_'
static	$_sErrorKey = 'bx_db_error'
static	$_aErrors
static	$_bReadOnlyMode = true
static	$_bMultuServersMode = false

Detailed Description

Database queries for ACL

See also

BxDolAcl

Constructor & Destructor Documentation

__construct()

BxDolAclQuery::__construct ( )

protected

Reimplemented from BxDolFactory.

Member Function Documentation

__clone()

BxDolAclQuery::__clone

(

)

Prevent cloning the instance

Reimplemented from BxDolDb.

getInstance()

static BxDolAclQuery::getInstance ( )

static

Get singleton instance of the class

Reimplemented from BxDolDb.

getLevelCurrent()

BxDolAclQuery::getLevelCurrent	(		$iProfileId,
			$iTime = 0 )

Fetch the last purchased/assigned membership that is still active for the given profile.

NOTE. Don't use cache here, because it's causing an error, if a number of memberrship levels are purchased at the same time. fromMemory returns the same DateExpires because setMembership (old buyMembership) function is called in cycle in the same session.

---

The documentation for this class was generated from the following file:

• inc/classes/BxDolAclQuery.php