Class PublisherItemHandler

Items handler class. This class is responsible for providing data access mechanisms to the data source of Q&A class objects.

Xoops\Core\Kernel\XoopsObjectHandler

Xoops\Core\Kernel\XoopsPersistableObjectHandler

PublisherItemHandler

Package: Publisher
Author: marcan marcan@notrevie.ca
Located at odules/publisher/class/item.php

Methods summary
`public`	# `__construct( Xoops\Core\Database\Connection $db )` Parameters `$db` Overrides `Xoops\Core\Kernel\XoopsPersistableObjectHandler::__construct()`
`public boolean`	# `insert( Xoops\Core\Kernel\XoopsObject $item, boolean $force = true )` insert a new item in the database insert a new item in the database Parameters `$item` reference to the `PublisherItem` object `$force` Returns boolean FALSE if failed, TRUE if already present and unchanged or successful Overrides `Xoops\Core\Kernel\XoopsPersistableObjectHandler::insert()`
`public boolean`	# `delete( Xoops\Core\Kernel\XoopsObject $item, boolean $force = false )` delete an item from the database delete an item from the database Parameters `$item` reference to the ITEM to delete `$force` Returns boolean FALSE if failed. Overrides `Xoops\Core\Kernel\XoopsPersistableObjectHandler::delete()`
`public array`	# `getItemObjects( object $criteria = null, string $id_key = 'none', string $notNullFields = '' )` retrieve items from the database retrieve items from the database Parameters `$criteria` `CriteriaElement` conditions to be met `$id_key` what shall we use as array key ? none, itemid, categoryid `$notNullFields` fields that cannot be null or empty Returns array array of `PublisherItem` objects
`public integer`	# `getItemCount( object $criteria = null, string $notNullFields = '' )` count items matching a condition count items matching a condition Parameters `$criteria` `CriteriaElement` to match `$notNullFields` fields that cannot be null or empty Returns integer count of items
`public integer`	# `getItemsCount( $categoryid = -1, string $status = '', string $notNullFields = '' )` Parameters `$categoryid` `$status` `$notNullFields` Returns integer
`public array`	# `getAllPublished( integer $limit = 0, integer $start = 0, integer $categoryid = -1, string $sort = 'datesub', string $order = 'DESC', string $notNullFields = '', boolean $asobject = true, string $id_key = 'none' )` Parameters `$limit` `$start` `$categoryid` `$sort` `$order` `$notNullFields` `$asobject` `$id_key` Returns array
`public boolean`	# `getPreviousPublished( PublisherItem $obj )` Parameters `$obj` Returns boolean
`public boolean`	# `getNextPublished( PublisherItem $obj )` Parameters `$obj` Returns boolean
`public array`	# `getAllSubmitted( integer $limit = 0, integer $start = 0, integer $categoryid = -1, string $sort = 'datesub', string $order = 'DESC', string $notNullFields = '', boolean $asobject = true, string $id_key = 'none' )` Parameters `$limit` `$start` `$categoryid` `$sort` `$order` `$notNullFields` `$asobject` `$id_key` Returns array
`public array`	# `getAllOffline( integer $limit = 0, integer $start = 0, integer $categoryid = -1, string $sort = 'datesub', string $order = 'DESC', string $notNullFields = '', boolean $asobject = true, string $id_key = 'none' )` Parameters `$limit` `$start` `$categoryid` `$sort` `$order` `$notNullFields` `$asobject` `$id_key` Returns array
`public array`	# `getAllRejected( integer $limit = 0, integer $start = 0, integer $categoryid = -1, string $sort = 'datesub', string $order = 'DESC', string $notNullFields = '', boolean $asobject = true, string $id_key = 'none' )` Parameters `$limit` `$start` `$categoryid` `$sort` `$order` `$notNullFields` `$asobject` `$id_key` Returns array
`public array`	# `getItems( integer $limit = 0, integer $start = 0, string $status = '', integer $categoryid = -1, string $sort = 'datesub', string $order = 'DESC', string $notNullFields = '', boolean $asobject = true, null $otherCriteria = null, string $id_key = 'none' )` Parameters `$limit` `$start` `$status` `$categoryid` `$sort` `$order` `$notNullFields` `$asobject` `$otherCriteria` `$id_key` Returns array
`public boolean`	# `getRandomItem( string $field = '', string $status = '', integer $categoryId = -1 )` Parameters `$field` `$status` `$categoryId` Returns boolean
`public boolean`	# `updateCounter( $itemid )` Parameters `$itemid` Returns boolean
`protected QueryBuilder`	# `addNotNullFieldClause( Xoops\Core\Database\QueryBuilder $qb, string\|array $notNullFields = array(), string $whereMode = '' )` addNotNullFieldClause exclude rows where specified columns are empty or null addNotNullFieldClause exclude rows where specified columns are empty or null Parameters `$qb` QueryBuilder instance `$notNullFields` fields that should not be empty `$whereMode` Initial where method, 'AND' andWhere(), otherwise where() Returns QueryBuilder instance
`public array`	# `getItemsFromSearch( array $queryarray = array(), string $andor = 'AND', integer $limit = 0, integer $offset = 0, integer $userid = 0, array $categories = array(), integer $sortby = 0, string $searchin = "", string $extra = "" )` Parameters `$queryarray` `$andor` `$limit` `$offset` `$userid` `$categories` `$sortby` `$searchin` `$extra` Returns array
`public array`	# `getLastPublishedByCat( array $categoriesObj, array $status = array(_PUBLISHER_STATUS_PUBLISHED) )` Parameters `$categoriesObj` `$status` Returns array
`public integer`	# `countArticlesByCat( integer $parentid, array & $catsCount, string $spaces = '', array $resultCatCounts = array() )` Parameters `$parentid` `$catsCount` `$spaces` `$resultCatCounts` Returns integer
`public array`	# `getCountsByCat( integer $cat_id, array $status, boolean $inSubCat = false )` Parameters `$cat_id` `$status` `$inSubCat` Returns array

Methods inherited from Xoops\Core\Kernel\XoopsPersistableObjectHandler
`__call(), cleanOrphan(), create(), deleteAll(), deleteByLink(), get(), getAll(), getByLink(), getCount(), getCountByLink(), getCounts(), getCountsByLink(), getIds(), getList(), getObjects(), loadHandler(), setHandler(), synchronization(), updateAll(), updateByLink()`

Properties summary
`public Publisher`	`$publisher`	# `null`

Properties inherited from Xoops\Core\Kernel\XoopsPersistableObjectHandler
`$className, $field_link, $field_object, $handler, $identifierName, $keyName, $keyName_link, $table, $table_link`

Properties inherited from Xoops\Core\Kernel\XoopsObjectHandler
`$db2`

Namespaces

Classes

Interfaces

Functions

Class PublisherItemHandler

Parameters

Overrides

Parameters

Returns

Overrides

Parameters

Returns

Overrides

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns