SQLSTATEMENTS

Some default SQL statements/clauses.

version 1
package wikindx4\core\sql
author Mark Grimshaw

 Methods

SQLSTATEMENTS

__construct() 

Create subquery initial order SELECT statement with minimal fields

createTotalResourceSubqueryList(string $addEditType, string $addEditValue, string $order, boolean $distinct, string $queryString, string $totalSubQuery) 

Parameters

$addEditType

string

$addEditValue

string

$order

string

Default is FALSE

$distinct

boolean

Default is FALSE

$queryString

string

Default is FALSE

$totalSubQuery

string

Default is FALSE

Select front page resources according to $limit resources from last $days

frontSetDays(int $days, int $limit) : string

Parameters

$days

int

$limit

int

Returns

stringSQL statement ready to be executed

Select front page resources according to latest $limit resources

frontSetNumber(int $limit) : string

Parameters

$limit

int

Returns

stringSQL statement ready to be executed

Create LIST statement

listList(string $addEditType, string $addEditValue, string $order) : string

Parameters

$addEditType

string

$addEditValue

string

$order

string

Default is 'creator'

Returns

stringSQL statement ready to be executed

process the conditions and joins for search and select that are defined elsewhere.

executeCondJoin() 

We can precisely control the order of joins here

Order the joins

orderJoins() 

Set SQL conditions for title and creator order when using pagingAlpha

pagingAlphaCondition(string $order) 

Parameters

$order

string

Conditions for quarantined resources

quarantineCond(boolean $front) 

Parameters

$front

boolean

Default is FALSE

 Properties

 

$doneJoins 
 

$execCond 
 

$execCondOneField 
 

$execJoin 
 

$listMethodAscDesc 
 

$listQuarantined 
 

$listType 
 

$metadataPaging 
 

$orderedJoins 
 

$subQueryFields 
 

$unions 
 

$attachmentFields 
 

$categoryFields 
 

$collectionFields 
 

$common 
 

$commonBib 
 

$countAlphaQuery 
 

$countQuery 
 

$db 
 

$keywordFields 
 

$languageFields 
 

$listFields 
 

$metadataSubquery 
 

$musingFields 
 

$pageFields 
 

$publisherFields 
 

$resourceFields 
 

$resourceMiscFields 
 

$session 
 

$stats 
 

$summaryFields 
 

$textFields 
 

$timestampFields 
 

$totalResourceSubquery 
 

$userFields 
 

$yearFields