SQLSTATEMENTS
in package
SQLSTATEMENTS
Some default SQL statements/clauses for LIST/SEARCH operations.
Table of Contents
Properties
- $browserTabID : mixed
- string
- $countQuery : string|false
- string
- $db : SQL
- object
- $listFields : array<string|int, mixed>
- array
- $quickListAll : bool
- bool
- $session : SESSION
- object
- $ua : mixed
- object
- $userId : mixed
- int
Methods
- useBib() : void
- Set SQL condition and join clauses if we are browsing a user bibliography to ensure that listed or searched resources come only from that user bibliography.
Properties
$browserTabID
string
private
mixed
$browserTabID
= \FALSE
$countQuery
string
private
string|false
$countQuery
= \FALSE
$db
object
private
SQL
$db
$listFields
array
private
array<string|int, 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', 'resourcetextEditUserIdNote', 'resourcetextAddUserIdNote', 'resourcetextEditUserIdAbstract', 'resourcetextAddUserIdAbstract', 'resourceyearId', 'resourceyearYear1', 'resourceyearYear2', 'resourceyearYear3', 'resourceyearYear4', 'resourcepageId', 'resourcepagePageStart', 'resourcepagePageEnd', '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', 'resourcemiscMetadata', 'resourcecreatorCreatorSurname']
$quickListAll
bool
private
bool
$quickListAll
= \FALSE
$session
object
private
SESSION
$session
$ua
object
private
mixed
$ua
$userId
int
private
mixed
$userId
Methods
useBib()
Set SQL condition and join clauses if we are browsing a user bibliography to ensure that listed or searched resources come only from that user bibliography.
private
useBib(mixed $bibId) : void
Parameters
- $bibId : mixed