UNA
Loading...
Searching...
No Matches
BxJobsDb Class Reference
Inheritance diagram for BxJobsDb:
BxBaseModGroupsDb BxBaseModProfileDb BxBaseModGeneralDb BxDolModuleDb BxDolModuleQuery BxDolDb iBxDolSingleton BxDolFactory iBxDolSingleton

Public Member Functions

 __construct (&$oConfig)
 
- Public Member Functions inherited from BxBaseModGroupsDb
 updateAuthorById ($iContentId, $iProfileId)
 
 toAdmins ($iGroupProfileId, $mixedFansIds)
 
 fromAdmins ($iGroupProfileId, $mixedFansIds)
 
 deleteAdminsByGroupId ($iGroupProfileId, $iProfileId=0)
 
 deleteAdminsByProfileId ($iProfileId)
 
 isAdmin ($iGroupProfileId, $iFanId, $aDataEntry=array())
 
 getAdmin ($iGroupProfileId, $iProfileId, $bRoleOnly=false)
 
 getAdmins ($iGroupProfileId, $iStart=0, $iLimit=0)
 
 getRole ($iGroupProfileId, $iProfileId)
 
 getRoles ($aParams)
 
 updateRoles ($aSet, $aWhere)
 
 deleteRoles ($aWhere)
 
 setRole ($iGroupProfileId, $iProfileId, $mixedRole, $mixedPeriod=false, $sOrder='')
 
 unsetRole ($iGroupProfileId, $iProfileId)
 
 getPrices ($aParams)
 
 getPriceOrderMax ($iRoleId)
 
 deletePrices ($aWhere)
 
 insertInvite ($sKey, $sGroupProfileId, $iAuthorProfileId, $iInvitedProfileId)
 
 getInviteByKey ($sKey, $iGroupProfileId)
 
 getInviteByInvited ($iInvitedProfileId, $iGroupProfileId)
 
 isInviteByInvited ($iInvitedProfileId, $iGroupProfileId)
 
 updateInviteByKey ($sKey, $iGroupProfileId, $sColumn, $sValue)
 
 deleteInviteByKey ($sKey, $iGroupProfileId)
 
 deleteInvite ($iId)
 
 getQuestions ($aParams=[])
 
 hasQuestions ($iContentId)
 
 areQuestionsAnswered ($iContentId, $iProfileId)
 
 getQuestionOrderMax ($iContentId)
 
 insertAnswer ($iQuestionId, $iProfileId, $sAnswer)
 
 deleteAnswersProfileId ($iContentId, $iProfileId)
 
 deleteQuestionnaires ($iContentId)
 
- Public Member Functions inherited from BxBaseModProfileDb
 getContentInfoById ($iContentId)
 
 getContentInfoByProfileId ($iProfileId)
 
 resetContentPictureByFileId ($iFileId, $sFieldPicture)
 
 updateContentPictureById ($iContentId, $iProfileId, $iPictureId, $sFieldPicture)
 
 searchByTerm ($sTerm, $iLimit)
 
 getEntriesNumByParams ($aParams=[])
 
- Public Member Functions inherited from BxBaseModGeneralDb
 getEntriesBy ($aParams=array())
 
 getEntriesNumByContext ($iProfileId)
 
 getEntriesByAuthor ($iProfileId)
 
 getEntriesNumByAuthor ($iProfileId)
 
 updateEntriesBy ($aParamsSet, $aParamsWhere)
 
 updateStatusAdmin ($iContentId, $isActive)
 
 publishEntries ()
 
 alterFulltextIndex ()
 
 deleteNestedById ($iNestedId, $sTableKey, $sTableName)
 
 getNestedBy ($aParams, $sTableName)
 
 getStatByProfile ($iAuthorId)
 
- Public Member Functions inherited from BxDolModuleDb
 __construct ($oConfig)
 
 getPrefix ()
 
- Public Member Functions inherited from BxDolModuleQuery
 __clone ()
 
 getModuleById ($iId, $bFromCache=true)
 
 getModuleByName ($sName, $bFromCache=true)
 
 getModuleByUri ($sUri, $bFromCache=true)
 
 enableModuleByUri ($sUri)
 
 disableModuleByUri ($sUri)
 
 setModulePendingUninstall ($sUri, $bPendingUninstall)
 
 isModule ($sUri)
 
 isModuleByName ($sName)
 
 isModuleParamsUsed ($sName, $sUri, $sPath, $sPrefixDb, $sPrefixClass)
 
 isEnabled ($sUri)
 
 isEnabledByName ($sName)
 
 getModules ()
 
 getModulesBy ($aParams=array(), $bFromCache=true)
 
 isModuleContent ($sName)
 
 isModuleContext ($sName)
 
 isModuleProfile ($sName)
 
 getModulesUri ()
 
 getDependent ($sName, $sUri)
 
 updateModule ($aParamsSet, $aParamsWhere=array())
 
 checkModulesSubtypes ()
 
- 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)
 

Additional Inherited Members

- Static Public Member Functions inherited from BxDolModuleQuery
static getInstance ()
 
- Static Public Member Functions inherited from BxDolDb
static getInstanceWithConf ($aDbConf, &$sError)
 
static getLink ()
 
- Protected Member Functions inherited from BxBaseModGroupsDb
 _getEntriesBySearchIds ($aParams, &$aMethod, &$sSelectClause, &$sJoinClause, &$sWhereClause, &$sOrderClause, &$sLimitClause)
 
- Protected Member Functions inherited from BxBaseModGeneralDb
 _addCustomConditions ($aParams, &$aMethod, &$sSelectClause, &$sJoinClause, &$sWhereClause, &$sOrderClause, &$sLimitClause)
 
 _addConditionsForAuthorStatus ($aParams, &$aMethod, &$sSelectClause, &$sJoinClause, &$sWhereClause, &$sOrderClause, &$sLimitClause)
 
 _addConditionsForCf ($aParams, &$aMethod, &$sSelectClause, &$sJoinClause, &$sWhereClause, &$sOrderClause, &$sLimitClause)
 
 _getEntriesBySearchIdsOrder ($aParams, &$sOrderClause)
 
 _getEbsiLike ($sValue)
 
- Protected Member Functions inherited from BxDolDb
 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 BxBaseModGeneralDb
 $_oConfig
 
- Protected Attributes inherited from BxDolModuleDb
 $_sPrefix
 
- 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

Jobs module database queries

Constructor & Destructor Documentation

◆ __construct()

BxJobsDb::__construct ( & $oConfig)

Reimplemented from BxBaseModGroupsDb.


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