Docs For Class ItemQuery

Class Overview

ItemQuery: help constructing queries on Items

Located in /blogs/inc/MODEL/items/_itemquery.class.php [line 40]

SQL
   |
   --ItemQuery

Properties

Methods

[ Top ]

Inherited Properties, Constants, and Methods

Inherited Properties	Inherited Methods	Inherited Constants
Inherited From SQL SQL::$from SQL::$group_by SQL::$limit SQL::$order_by SQL::$search_field SQL::$search_field_regexp SQL::$select SQL::$where	Inherited From SQL SQL::SQL() Constructor. SQL::add_search_field() create array of search fields SQL::display() Get whole query SQL::FROM() SQL::FROM_add() Extends the FROM clause. SQL::get() Get whole query SQL::get_from() Get FROM clause if there is something inside SQL::get_group_by() Get GROUP BY clause if there is something inside SQL::get_limit() Get LIMIT clause if there is something inside SQL::get_order_by() Get ORDER BY clause if there is something inside SQL::get_select() Get SELECT clause if there is something inside SQL::get_where() Get WHERE clause if there is something inside SQL::GROUP_BY() SQL::LIMIT() SQL::ORDER_BY() SQL::ORDER_BY_prepend() SQL::SELECT() Set SELECT clause SQL::SELECT_add() Extends the SELECT clause. SQL::WHERE() SQL::WHERE_and() Extends the WHERE clause with AND SQL::WHERE_keyword() create the filter whith the search field array SQL::WHERE_or() Extends the WHERE clause with OR SQL::WHERE_regexp() create the filter whith the search field regexp array

Inherited Properties

Inherited Methods

Inherited Constants

Inherited From SQL

SQL::$from

SQL::$group_by

SQL::$limit

SQL::$order_by

SQL::$search_field

SQL::$search_field_regexp

SQL::$select

SQL::$where

Inherited From SQL

SQL::SQL()

Constructor.

SQL::add_search_field()

create array of search fields

SQL::display()

Get whole query

SQL::FROM()

SQL::FROM_add()

Extends the FROM clause.

SQL::get()

Get whole query

SQL::get_from()

Get FROM clause if there is something inside

SQL::get_group_by()

Get GROUP BY clause if there is something inside

SQL::get_limit()

Get LIMIT clause if there is something inside

SQL::get_order_by()

Get ORDER BY clause if there is something inside

SQL::get_select()

Get SELECT clause if there is something inside

SQL::get_where()

Get WHERE clause if there is something inside

SQL::GROUP_BY()

SQL::LIMIT()

SQL::ORDER_BY()

SQL::ORDER_BY_prepend()

SQL::SELECT()

Set SELECT clause

SQL::SELECT_add()

Extends the SELECT clause.

SQL::WHERE()

SQL::WHERE_and()

Extends the WHERE clause with AND

SQL::WHERE_keyword()

create the filter whith the search field array

SQL::WHERE_or()

Extends the WHERE clause with OR

SQL::WHERE_regexp()

create the filter whith the search field regexp array

[ Top ]

Property Summary

mixed	$assignees
mixed	$author
mixed	$blog
mixed	$cat
mixed	$catsel
mixed	$dstart
mixed	$dstop
mixed	$exact
mixed	$keywords
mixed	$p
mixed	$phrase
mixed	$show_statuses
mixed	$statuses
mixed	$timestamp_max
mixed	$timestamp_min
mixed	$title

[ Top ]

Method Summary

ItemQuery	ItemQuery()	Constructor.
void	where_assignees()	Restrict to specific assignees
void	where_author()	Restrict to specific authors
void	where_author_assignee()	Restrict to specific assignee or author
void	where_chapter()	Restrict to specific collection/chapters (blog/categories)
void	where_chapter2()	Restrict to specific collection/chapters (blog/categories)
void	where_datestart()	Restricts to a specific date range. (despite thje 'start' in the name
void	where_ID()	Restrict to a specific post
void	where_keywords()	Restrict with keywords
void	where_statuses()	Restrict to specific (exetnded) statuses
void	where_visibility()	Restrict to the visibility/sharing statuses we want to show

[ Top ]

Properties

mixed $assignees [line 49]

[ Top ]

mixed $author [line 48]

[ Top ]

mixed $blog [line 44]

[ Top ]

mixed $cat [line 45]

[ Top ]

mixed $catsel [line 46]

[ Top ]

mixed $dstart [line 51]

[ Top ]

mixed $dstop [line 52]

[ Top ]

mixed $exact [line 57]

[ Top ]

mixed $keywords [line 55]

[ Top ]

mixed $p [line 42]

[ Top ]

mixed $phrase [line 56]

[ Top ]

mixed $show_statuses [line 47]

[ Top ]

mixed $statuses [line 50]

[ Top ]

mixed $timestamp_max [line 54]

[ Top ]

mixed $timestamp_min [line 53]

[ Top ]

mixed $title [line 43]

[ Top ]

Methods

Constructor ItemQuery [line 67]

ItemQuery ItemQuery(
string
$dbtablename, [string
$dbprefix = ''], string
$dbIDname 
)

Constructor.

Parameters:

string	$dbtablename:	Name of table in database
string	$dbprefix:	Prefix of fields in the table
string	$dbIDname:	Name of the ID field (including prefix)

[ Top ]

where_assignees [line 253]

void where_assignees(
string
$assignees 
)

Restrict to specific assignees

Parameters:

string

$assignees:

List of assignees to restrict to (must have been previously validated)

[ Top ]

where_author [line 224]

void where_author(
string
$author 
)

Restrict to specific authors

Parameters:

string

$author:

List of authors to restrict to (must have been previously validated)

[ Top ]

where_author_assignee [line 283]

void where_author_assignee(
integer
$author_assignee 
)

Restrict to specific assignee or author

Parameters:

integer

$author_assignee:

assignee or author to restrict to (must have been previously validated)

[ Top ]

where_chapter [line 116]

void where_chapter(
integer
$blog, [string
$cat = ''], [array
$catsel = array()] 
)

Restrict to specific collection/chapters (blog/categories)

Parameters:

integer	$blog:
string	$cat:	List of cats to restrict to
array	$catsel:	Array of cats to restrict to

Information Tags:

Todo:

get rid of blog #1

[ Top ]

where_chapter2 [line 167]

void where_chapter2(
integer
$blog_ID, 
$cat_array, 
$cat_modifier 
)

Restrict to specific collection/chapters (blog/categories)

Parameters:

integer	$blog_ID:
	$cat_array:
	$cat_modifier:

Information Tags:

Todo:

get rid of blog #1

[ Top ]

where_datestart [line 344]

void where_datestart(
[string
$m = ''], [integer
$w = ''], [string
$dstart = ''], [string
$dstop = ''], [mixed
$timestamp_min = ''], [mixed
$timestamp_max = 'now'] 
)

Restricts to a specific date range. (despite thje 'start' in the name

Priorities: -dstart and/or dstop -week + m -m

Parameters:

string	$m:	YYYYMMDDHHMMSS (everything after YYYY is optional) or ''
integer	$w:	week number or ''
string	$dstart:	YYYYMMDDHHMMSS to start at, '' for first available
string	$dstop:	YYYYMMDDHHMMSS to stop at
mixed	$timestamp_min:	Do not show posts before this timestamp, can be 'now'
mixed	$timestamp_max:	Do not show posts after this timestamp, can be 'now'

API Tags:

See:

ItemList2::get_advertised_start_date()

Information Tags:

Todo:

-dstart + x days

[ Top ]

where_ID [line 81]

void where_ID(
[
$p = ''], [
$title = ''] 
)

Restrict to a specific post

Parameters:

	$p:
	$title:

[ Top ]

where_keywords [line 495]

void where_keywords(
string
$keywords, mixed
$phrase, mixed
$exact 
)

Restrict with keywords

Parameters:

string	$keywords:	Keyword search string
mixed	$phrase:	Search for entire phrase or for individual words
mixed	$exact:	Require exact match of title or contents

[ Top ]

where_statuses [line 302]

void where_statuses(
string
$statuses 
)

Restrict to specific (exetnded) statuses

Parameters:

string

$statuses:

List of assignees to restrict to (must have been previously validated)

[ Top ]

where_visibility [line 206]

void where_visibility(
array
$show_statuses 
)

Restrict to the visibility/sharing statuses we want to show

Parameters:

array

$show_statuses:

Restrict to these statuses

[ Top ]

Multilingual multiuser multiblog engine

Class: ItemQuery

Class ItemQuery

Packages

Classes

Files