SQLSTATEMENTS
in package
SQLSTATEMENTS
Some default SQL statements/clauses for LIST/SEARCH operations.
Table of Contents
- $browserTabID : mixed
- string
- $common : mixed
- object
- $countQuery : mixed
- string
- $db : mixed
- object
- $listFields : mixed
- array
- $quickListAll : mixed
- booolean
- $session : mixed
- object
- listJoins() : mixed
- Create table joins, orders, groups and fields for outer select statement
- pagingAlphaCondition() : mixed
- Set SQL conditions for title and creator order when using pagingAlpha
Properties
$browserTabID
string
private
mixed
$browserTabID
= FALSE
$common
object
private
mixed
$common
$countQuery
string
private
mixed
$countQuery
= FALSE
$db
object
private
mixed
$db
$listFields
array
private
mixed
$listFields
= ['resourceId', 'creatorSurname', 'resourceType', 'resourceTitle', 'resourceSubtitle', 'resourceShortTitle', 'resourceTransTitle', 'resourceTransSubtitle', 'resourceTransShortTitle', 'resourceField1', 'resourceField2', 'resourceField3', 'resourceField4', 'resourceField5', 'resourceField6', 'resourceField7', 'resourceField8', 'resourceField9', 'resourceNoSort', 'resourceTransNoSort', 'resourceIsbn', 'resourceBibtexKey', 'resourceDoi', 'resourcetextId', 'resourcetextNote', 'resourcetextAbstract', 'resourcetextUrls', 'resourcetextUrlText', 'resourcetextEditUserIdNote', 'resourcetextAddUserIdNote', 'resourcetextEditUserIdAbstract', 'resourcetextAddUserIdAbstract', 'resourceyearId', 'resourceyearYear1', 'resourceyearYear2', 'resourceyearYear3', 'resourceyearYear4', 'resourcepageId', 'resourcepagePageStart', 'resourcepagePageEnd', 'resourcesummaryId', 'resourcesummaryQuotes', 'resourcesummaryParaphrases', 'resourcesummaryMusings', 'resourcetimestampId', 'resourcetimestampTimestamp', 'resourcetimestampTimestampAdd', 'publisherId', 'publisherName', 'publisherLocation', 'publisherType', 'collectionId', 'collectionTitle', 'collectionTitleShort', 'collectionType', 'usersId', 'usersUsername', 'usersFullname', 'resourcemiscId', 'resourcemiscCollection', 'resourcemiscPublisher', 'resourcemiscField1', 'resourcemiscField2', 'resourcemiscField3', 'resourcemiscField4', 'resourcemiscField5', 'resourcemiscField6', 'resourcemiscTag', 'resourcemiscAddUserIdResource', 'resourcemiscEditUserIdResource', 'resourcemiscMaturityIndex', 'resourcemiscPeerReviewed', 'resourcemiscQuarantine', 'resourcecreatorCreatorSurname']
$quickListAll
booolean
private
mixed
$quickListAll
= FALSE
$session
object
private
mixed
$session
Methods
listJoins()
Create table joins, orders, groups and fields for outer select statement
private
listJoins(mixed $order[, mixed $QS = FALSE ]) : mixed
Parameters
- $order : mixed
- $QS : mixed = FALSE
Return values
mixed —pagingAlphaCondition()
Set SQL conditions for title and creator order when using pagingAlpha
private
pagingAlphaCondition(string $order) : mixed
Parameters
- $order : string