/**
* Returns an array of all messages matching the passed identifier
*
* @param string $strIdentifier
* @param bool|int $intStart
* @param bool|int $intEnd
*
* @return class_module_messaging_message[]
* @static
*/
public static function getMessagesByIdentifier($strIdentifier, $intStart = null, $intEnd = null)
{
$objOrm = new class_orm_objectlist();
$objOrm->addWhereRestriction(new class_orm_objectlist_property_restriction("strInternalIdentifier", class_orm_comparator_enum::Equal(), $strIdentifier));
$objOrm->addOrderBy(new class_orm_objectlist_orderby("message_read ASC"));
$objOrm->addOrderBy(new class_orm_objectlist_orderby("system_create_date DESC"));
return $objOrm->getObjectList(__CLASS__, $intStart, $intEnd);
}
/**
* Loads all posts belonging to the given systemid (in most cases a guestbook)
*
* @param string $strPrevId
* @param bool $bitJustActive
* @param null $intStart
* @param null $intEnd
*
* @return class_module_guestbook_post[]
* @static
*/
public static function getPosts($strPrevId = "", $bitJustActive = false, $intStart = null, $intEnd = null)
{
$objORM = new class_orm_objectlist();
if ($bitJustActive) {
$objORM->addWhereRestriction(new class_orm_objectlist_systemstatus_restriction(class_orm_comparator_enum::Equal(), 1));
}
$objORM->addOrderBy(new class_orm_objectlist_orderby("guestbook_post_date DESC"));
return $objORM->getObjectList(get_called_class(), $strPrevId, $intStart, $intEnd);
}
/**
* Creates a list of tags matching the passed filter.
*
* @param string $strFilter
* @return class_module_tags_tag[]
*/
public static function getTagsByFilter($strFilter)
{
$objORM = new class_orm_objectlist();
$objORM->addWhereRestriction(new class_orm_objectlist_property_restriction("strName", class_orm_comparator_enum::Like(), trim($strFilter . "%")));
$objORM->addOrderBy(new class_orm_objectlist_orderby("tags_tag_name ASC"));
return $objORM->getObjectList(get_called_class());
}
/**
* Returns a list of events available
*
* @param bool|int $intStart
* @param bool|int $intEnd
* @param class_date $objStartDate
* @param class_Date $objEndDate
* @param bool $bitOnlyActive
* @param int $intOrder
* @param null $intStatusFilter
*
* @return class_module_eventmanager_event[]
*/
public static function getAllEvents($intStart = false, $intEnd = false, class_date $objStartDate = null, class_date $objEndDate = null, $bitOnlyActive = false, $intOrder = 0, $intStatusFilter = null)
{
$objORM = new class_orm_objectlist();
if ($objStartDate != null && $objEndDate != null) {
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND (system_date_start > ? AND system_date_start <= ?", array($objStartDate->getLongTimestamp(), $objEndDate->getLongTimestamp())));
}
if ($intStatusFilter != null) {
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND em_ev_eventstatus = ?", array($intStatusFilter)));
}
if ($bitOnlyActive) {
$objORM->addWhereRestriction(new class_orm_objectlist_systemstatus_restriction(class_orm_comparator_enum::Equal(), 1));
}
$objORM->addOrderBy(new class_orm_objectlist_orderby("system_date_start " . ($intOrder == "1" ? " ASC " : " DESC ")));
$objORM->addOrderBy(new class_orm_objectlist_orderby("em_ev_title ASC "));
return $objORM->getObjectList(get_called_class(), "", $intStart, $intEnd);
}
/**
* Returns a list of all packages available
*
* @param bool $strCategoryFilter
* @param bool $bitActiveOnly
* @param null $intStart
* @param null $intEnd
* @param bool $strNameFilter
*
* @return class_module_mediamanager_file[]
*/
public static function getFlatPackageList($strCategoryFilter = false, $bitActiveOnly = false, $intStart = null, $intEnd = null, $strNameFilter = false)
{
$objORM = new class_orm_objectlist();
if ($bitActiveOnly) {
$objORM->addWhereRestriction(new class_orm_objectlist_restriction(" AND system_status = 1 ", array()));
}
if ($strCategoryFilter !== false) {
$objORM->addWhereRestriction(new class_orm_objectlist_restriction(" AND file_cat = ? ", array($strCategoryFilter)));
}
if ($strNameFilter !== false) {
$arrParams = array();
if (uniStrpos($strNameFilter, ",") !== false) {
$arrWhere = array();
foreach (explode(",", $strNameFilter) as $strOneLike) {
$arrWhere[] = " file_name = ?";
$arrParams[] = trim($strOneLike);
}
$strWhere = "AND ( " . implode(" OR ", $arrWhere) . " )";
} else {
$arrParams[] = $strNameFilter . "%";
$strWhere = "AND file_name LIKE ?";
}
$objORM->addWhereRestriction(new class_orm_objectlist_restriction($strWhere, $arrParams));
}
$objORM->addOrderBy(new class_orm_objectlist_orderby("file_name ASC"));
return $objORM->getObjectList(get_called_class(), "", $intStart, $intEnd);
}
/**
* Loads all pages known by the system
*
* @param int $intStart
* @param int $intEnd
* @param string $strFilter
*
* @return class_module_pages_page[]
* @static
*/
public static function getAllPages($intStart = null, $intEnd = null, $strFilter = "")
{
$objORM = new class_orm_objectlist();
if ($strFilter != "") {
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND page_name LIKE ?", $strFilter . "%"));
}
$objORM->addOrderBy(new class_orm_objectlist_orderby("page_name ASC"));
return $objORM->getObjectList(get_called_class(), "", $intStart, $intEnd);
}
/**
* Returns a list of posts
*
* @param bool $bitJustActive
* @param string $strPagefilter
* @param string $strSystemidfilter false to ignore the filter
* @param string $strLanguagefilter
* @param bool $intStart
* @param bool $intEnd
*
* @return class_module_postacomment_post[]
*/
public static function loadPostList($bitJustActive = true, $strPagefilter = "", $strSystemidfilter = "", $strLanguagefilter = "", $intStart = null, $intEnd = null)
{
$objORM = new class_orm_objectlist();
if ($strPagefilter != "") {
$objORM->addWhereRestriction(new class_orm_objectlist_restriction(" AND postacomment_page = ? ", $strPagefilter));
}
if ($strSystemidfilter != "") {
$objORM->addWhereRestriction(new class_orm_objectlist_restriction(" AND postacomment_systemid = ? ", $strSystemidfilter));
}
if ($strLanguagefilter != "") {
//check against '' to remain backwards-compatible
$objORM->addWhereRestriction(new class_orm_objectlist_restriction(" AND (postacomment_language = ? OR postacomment_language = '')", $strLanguagefilter));
}
if ($bitJustActive) {
$objORM->addWhereRestriction(new class_orm_objectlist_restriction(" AND system_status = ? ", 1));
}
$objORM->addOrderBy(new class_orm_objectlist_orderby("postacomment_page ASC"));
$objORM->addOrderBy(new class_orm_objectlist_orderby("postacomment_language ASC"));
$objORM->addOrderBy(new class_orm_objectlist_orderby("postacomment_date DESC"));
return $objORM->getObjectList(get_called_class(), "", $intStart, $intEnd);
}
/**
* Retrieves the list of workflows available
*
* @param bool|int $intStart
* @param bool|int $intEnd
*
* @return class_module_workflows_workflow[]
*/
public static function getAllworkflows($intStart = null, $intEnd = null)
{
$objOrmMapper = new class_orm_objectlist();
$objOrmMapper->addOrderBy(new class_orm_objectlist_orderby("workflows_state ASC"));
$objOrmMapper->addOrderBy(new class_orm_objectlist_orderby("system_date_start DESC"));
return $objOrmMapper->getObjectList("class_module_workflows_workflow", "", $intStart, $intEnd);
}
