SQLSTATEMENTS
Some default SQL statements/clauses.
version | 1 |
---|---|
package | wikindx4\core\sql |
author | Mark Grimshaw |
__construct()
createTotalResourceSubqueryList(string $addEditType, string $addEditValue, string $order, boolean $distinct, string $queryString, string $totalSubQuery)
string
string
string
Default is FALSE
boolean
Default is FALSE
string
Default is FALSE
string
Default is FALSE
frontSetDays(int $days, int $limit) : string
int
int
string
SQL statement ready to be executedfrontSetNumber(int $limit) : string
int
string
SQL statement ready to be executedlistList(string $addEditType, string $addEditValue, string $order) : string
string
string
string
Default is 'creator'
string
SQL statement ready to be executedexecuteCondJoin()
We can precisely control the order of joins here
orderJoins()
pagingAlphaCondition(string $order)
string
quarantineCond(boolean $front)
boolean
Default is FALSE
$doneJoins
$execCond
$execCondOneField
$execJoin
$listMethodAscDesc
$listQuarantined
$listType
$orderedJoins
$subQueryFields
$unions
$categoryFields
$collectionFields
$common
$commonBib
$countAlphaQuery
$countQuery
$db
$keywordFields
$languageFields
$listFields
$musingFields
$pageFields
$publisherFields
$resourceFields
$resourceMiscFields
$session
$stats
$summaryFields
$textFields
$totalResourceSubquery
$userFields
$yearFields