/** * 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); }