/**
* Triggered as soon as a record is updated
*
* @param string $strEventName
* @param array $arrArguments
*
* @return bool
*/
public function handleEvent($strEventName, array $arrArguments)
{
$objRecord = $arrArguments[0];
if ($objRecord instanceof class_module_packagemanager_template) {
if ($objRecord->getIntRecordStatus() == 1) {
$objOrm = new class_orm_objectlist();
$objOrm->addWhereRestriction(new class_orm_objectlist_systemstatus_restriction(class_orm_comparator_enum::Equal(), 1));
$arrPacks = $objOrm->getObjectList("class_module_packagemanager_template");
foreach ($arrPacks as $objPack) {
if ($objPack->getSystemid() != $objRecord->getSystemid()) {
$objPack->setIntRecordStatus(0);
$objPack->updateObjectToDb();
}
}
//update the active-pack constant
$objSetting = class_module_system_setting::getConfigByName("_packagemanager_defaulttemplate_");
if ($objSetting !== null) {
$objSetting->setStrValue($objRecord->getStrName());
$objSetting->updateObjectToDb();
}
class_cache::flushCache("class_element_portal");
}
}
return true;
}
/**
* Implementing callback to react on user-delete events
*
* Called whenever a record was deleted using the common methods.
* Implement this method to be notified when a record is deleted, e.g. to to additional cleanups afterwards.
* There's no need to register the listener, this is done automatically.
*
* Make sure to return a matching boolean-value, otherwise the transaction may be rolled back.
*
* @param string $strEventName
* @param array $arrArguments
*
* @return bool
*/
public function handleEvent($strEventName, array $arrArguments)
{
//unwrap arguments
list($strSystemid, $strSourceClass) = $arrArguments;
if ($strSourceClass == "class_module_user_user" && validateSystemid($strSystemid)) {
$objORM = new class_orm_objectlist();
$objORM->addWhereRestriction(new class_orm_objectlist_property_restriction("strUser", class_orm_comparator_enum::Equal(), $strSystemid));
$objORM->setObjHandleLogicalDeleted(class_orm_deletedhandling_enum::INCLUDED());
$arrWidgets = $objORM->getObjectList("class_module_dashboard_widget");
foreach ($arrWidgets as $objWidget) {
$objWidget->deleteObjectFromDatabase();
}
}
return true;
}
/**
* Searches for ratings belonging to the systemid
* to be deleted.
*
* @param string $strEventName
* @param array $arrArguments
*
* @return bool
*/
public function handleEvent($strEventName, array $arrArguments)
{
//unwrap arguments
list($strSystemid, $strSourceClass) = $arrArguments;
$bitReturn = true;
//ratings installed as a module?
if ($strSourceClass == "class_module_rating_rate") {
//delete history entries of the current rating
return class_carrier::getInstance()->getObjDB()->_pQuery("DELETE FROM " . _dbprefix_ . "rating_history" . " WHERE rating_history_rating=? ", array($strSystemid));
}
//if another record was deleted, remove the ratings alltogether
$objOrmList = new class_orm_objectlist();
$objOrmList->addWhereRestriction(new class_orm_objectlist_property_restriction("strRatingSystemid", class_orm_comparator_enum::Equal(), $strSystemid));
$arrRatings = $objOrmList->getObjectList("class_module_rating_rate");
foreach ($arrRatings as $objRating) {
$bitReturn = $bitReturn && $objRating->deleteObjectFromDatabase();
}
return $bitReturn;
}
/**
* Called whenever a records was deleted using the common methods.
* Implement this method to be notified when a record is deleted, e.g. to to additional cleanups afterwards.
* There's no need to register the listener, this is done automatically.
*
* Make sure to return a matching boolean-value, otherwise the transaction may be rolled back.
*
* @param string $strEventName
* @param array $arrArguments
*
* @return bool
*/
public function handleEvent($strEventName, array $arrArguments)
{
//unwrap arguments
list($strSystemid, $strSourceClass) = $arrArguments;
$bitReturn = true;
//module installed?
if ($strSourceClass == "class_module_postacomment_post" || class_module_system_module::getModuleByName("postacomment") == null) {
return true;
}
$objOrm = new class_orm_objectlist();
$objOrm->setObjHandleLogicalDeleted(class_orm_deletedhandling_enum::INCLUDED());
$objOrm->addWhereRestriction(new class_orm_objectlist_restriction(" AND (postacomment_page = ? OR postacomment_systemid = ? ) ", array($strSystemid, $strSystemid)));
$arrComments = $objOrm->getObjectList("class_module_postacomment_post");
foreach ($arrComments as $objPost) {
if ($strEventName == class_system_eventidentifier::EVENT_SYSTEM_RECORDDELETED_LOGICALLY) {
$objPost->deleteObject();
}
if ($strEventName == class_system_eventidentifier::EVENT_SYSTEM_RECORDDELETED) {
$objPost->deleteObjectFromDatabase();
}
}
return $bitReturn;
}
/**
* Searches for workflows assigned to the systemid to be deleted.
*
* @param string $strEventName
* @param array $arrArguments
*
* @return bool
*/
public function handleEvent($strEventName, array $arrArguments)
{
//unwrap arguments
list($strSystemid, $strSourceClass) = $arrArguments;
$bitReturn = true;
$objORM = new class_orm_objectlist();
$objORM->setObjHandleLogicalDeleted(class_orm_deletedhandling_enum::INCLUDED());
$objORM->addWhereRestriction(new class_orm_objectlist_restriction(" AND workflows_systemid = ?", $strSystemid));
if ($objORM->getObjectCount("class_module_workflows_workflow") == 0) {
return true;
}
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::INCLUDED());
$arrWorkflows = class_module_workflows_workflow::getWorkflowsForSystemid($strSystemid, false);
foreach ($arrWorkflows as $objOneWorkflow) {
if ($strEventName == class_system_eventidentifier::EVENT_SYSTEM_RECORDDELETED_LOGICALLY) {
$bitReturn = $bitReturn && $objOneWorkflow->deleteObject();
}
if ($strEventName == class_system_eventidentifier::EVENT_SYSTEM_RECORDDELETED) {
$bitReturn = $bitReturn && $objOneWorkflow->deleteObjectFromDatabase();
}
}
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUDED());
return $bitReturn;
}
/**
* Tries to find a single mediamanager file identified by its path.
* Pass the systemid of the matching repo/parent-id in order to find the correct file (e.g. if the file
* is saved in multiple repos).
*
* @param string $strRepoId
* @param string $strPath
*
* @return class_module_mediamanager_file|null
*/
public static function getFileForPath($strRepoId, $strPath)
{
$objORM = new class_orm_objectlist();
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND file_filename = ?", array($strPath)));
$arrFiles = $objORM->getObjectList(get_called_class());
foreach ($arrFiles as $objFile) {
$objTemp = class_objectfactory::getInstance()->getObject($objFile->getStrPrevId());
while (validateSystemid($objTemp->getSystemid())) {
if ($objTemp->getSystemid() == $strRepoId) {
return $objFile;
}
$objTemp = class_objectfactory::getInstance()->getObject($objTemp->getStrPrevId());
}
}
return null;
}
/**
* Returns the element using the given element-name
*
* @param string $strName
*
* @return class_module_pages_element
*/
public static function getElement($strName)
{
$objORM = new class_orm_objectlist();
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND element_name = ?", array($strName)));
return $objORM->getSingleObject(get_called_class());
}
/**
* Loads all workflows for a given user
* By default limited to those with a exceeded trigger-date, so valid to be run
*
* @param array $arrUserids
* @param bool|int $intStart
* @param bool|int $intEnd
* @return class_module_workflows_workflow[]
*/
public static function getPendingWorkflowsForUser($arrUserids, $intStart = false, $intEnd = false)
{
$objOrmMapper = new class_orm_objectlist();
$objOrmMapper->addWhereRestriction(new class_orm_objectlist_property_restriction("intState", class_orm_comparator_enum::Equal(), (int) self::$INT_STATE_SCHEDULED));
$objOrmMapper->addWhereRestriction(self::getUserWhereStatement($arrUserids));
$objOrmMapper->addOrderBy(new class_orm_objectlist_orderby("system_date_start DESC"));
$objOrmMapper->addOrderBy(new class_orm_objectlist_orderby("system_sort DESC"));
return $objOrmMapper->getObjectList("class_module_workflows_workflow", "", $intStart, $intEnd);
}
/**
* Counts the answers related to the current question
*
* @param bool $bitOnlyActive
*
* @return int
*/
public function getAllAnswersCount($bitOnlyActive = false)
{
$objOrm = new class_orm_objectlist();
if ($bitOnlyActive) {
$objOrm->addWhereRestriction(new class_orm_objectlist_systemstatus_restriction(class_orm_comparator_enum::NotEqual(), 0));
}
return $objOrm->getObjectCount(__CLASS__);
}
/**
* Loads all navigation-points linking on the passed page
*
* @param string $strPagename
*
* @static
* @return class_module_navigation_point[]
*/
public static function loadPagePoint($strPagename)
{
$objOrm = new class_orm_objectlist();
$objOrm->addWhereRestriction(new class_orm_objectlist_restriction(" AND system_status = 1 ", array()));
$objOrm->addWhereRestriction(new class_orm_objectlist_restriction(" AND navigation_page_i = ? ", array($strPagename)));
return $objOrm->getObjectList(get_called_class());
}
/**
* 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());
}
/**
* Looks up the widgets placed in a given column and
* returns a list of instances, reduced for the current user
*
* @param string $strColumn
* @param string $strAspectFilter
* @param string $strUserId
*
* @return array of class_module_dashboard_widget
*/
public function getWidgetsForColumn($strColumn, $strAspectFilter = "", $strUserId = "")
{
if ($strUserId == "") {
$strUserId = $this->objSession->getUserID();
}
$objORM = new class_orm_objectlist();
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND dashboard_user = ?", array($strUserId)));
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND dashboard_column = ?", array($strColumn)));
return $objORM->getObjectList(get_called_class(), self::getWidgetsRootNodeForUser($strUserId, $strAspectFilter));
}
/**
* @param string $strEventId
*
* @return int
*/
public static function getActiveParticipantsCount($strEventId)
{
$objOrm = new class_orm_objectlist();
$objOrm->addWhereRestriction(new class_orm_objectlist_restriction("AND em_pt_status != 2", array()));
return $objOrm->getObjectCount(get_called_class(), $strEventId);
}
/**
* 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);
}
/**
* Load a newsfeed using a urltitle
*
* @param string $strFeedTitle
*
* @return class_module_news_feed
* @static
*/
public static function getFeedByUrlName($strFeedTitle)
{
$objORM = new class_orm_objectlist();
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND news_feed_urltitle = ? ", array($strFeedTitle)));
return $objORM->getSingleObject(get_called_class());
}
/**
* Counts the number of posts currently in the database
*
* @param bool $bitJustActive
* @param string $strPageid
* @param bool|string $strSystemidfilter false to ignore the filter
* @param string $strLanguagefilter
*
* @return int
*/
public static function getNumberOfPostsAvailable($bitJustActive = true, $strPageid = "", $strSystemidfilter = "", $strLanguagefilter = "")
{
$objORM = new class_orm_objectlist();
if ($strPageid != "") {
$objORM->addWhereRestriction(new class_orm_objectlist_restriction(" AND postacomment_page = ? ", $strPageid));
}
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));
}
return $objORM->getObjectCount(get_called_class());
}
/**
* Looks up a navigation by its name
*
* @param string $strName
*
* @return class_module_navigation_tree
* @static
*/
public static function getNavigationByName($strName)
{
$objOrm = new class_orm_objectlist();
$objOrm->addWhereRestriction(new class_orm_objectlist_property_restriction("strName", class_orm_comparator_enum::Equal(), $strName));
$arrRows = $objOrm->getObjectList("class_module_navigation_tree", class_module_system_module::getModuleIdByNr(_navigation_modul_id_));
if (count($arrRows) == 1) {
return $arrRows[0];
}
return null;
}
/**
* Looks up the posts available
*
* @param string $strPrevID
* @param bool $bitJustActive
*
* @return int
* @static
*/
public static function getPostsCount($strPrevID = "", $bitJustActive = false)
{
$objORM = new class_orm_objectlist();
if ($bitJustActive) {
$objORM->addWhereRestriction(new class_orm_objectlist_systemstatus_restriction(class_orm_comparator_enum::Equal(), 1));
}
return $objORM->getObjectCount(get_called_class(), $strPrevID);
}
/**
* Generates a pagename not yet existing.
* Tries to detect if the new name is the name of the current page. If given, the same name
* is being returned. Can be suppressed.
*
* @param string $strName
* @param bool $bitAvoidSelfchek
*
* @return string
*/
public function generateNonexistingPagename($strName, $bitAvoidSelfchek = true)
{
//Filter blanks out of pagename
$strName = str_replace(" ", "_", $strName);
$objORM = new class_orm_objectlist();
$objORM->addWhereRestriction(new class_orm_objectlist_restriction(" AND page_name = ?", $strName));
$objPage = $objORM->getSingleObject(get_called_class());
if ($objPage !== null && !($bitAvoidSelfchek && $objPage->getSystemid() == $this->getSystemid())) {
$intCount = 1;
$strTemp = "";
if ($objPage !== null && !($bitAvoidSelfchek && $objPage->getSystemid() == $this->getSystemid())) {
$strTemp = $strName . "_" . $intCount;
$objORM = new class_orm_objectlist();
$objORM->addWhereRestriction(new class_orm_objectlist_restriction(" AND page_name = ?", $strName));
$objPage = $objORM->getSingleObject(get_called_class());
$intCount++;
}
$strName = $strTemp;
}
return $strName;
}
/**
* Loads a single rating for a given systemid, if needed concreted by a checksum.
* If no rating is found, null is being returned.
*
* @param string $strSystemid
* @param string $strChecksum
*
* @static
* @return class_module_rating_rate
*/
public static function getRating($strSystemid, $strChecksum = "")
{
$objORM = new class_orm_objectlist();
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND rating_systemid = ?", $strSystemid));
if ($strChecksum != "") {
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND rating_checksum = ?"), $strChecksum);
}
return $objORM->getSingleObject(get_called_class());
}
/**
* Returns the configuration of a single provider for a user.
*
* @param string $strUserid
* @param \interface_messageprovider|string $objProvider
*
* @return class_module_messaging_config
* @static
*/
public static function getConfigForUserAndProvider($strUserid, interface_messageprovider $objProvider)
{
$objORM = new class_orm_objectlist();
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND config_user = ?", $strUserid));
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND config_provider = ?", get_class($objProvider)));
$objConfig = $objORM->getSingleObject(get_called_class());
if ($objConfig === null) {
$objConfig = new class_module_messaging_config();
$objConfig->setStrUser($strUserid);
$objConfig->setStrMessageprovider(get_class($objProvider));
}
return $objConfig;
}
/**
* Returns the number of messages for a single user - ignoring the messages states.
*
* @param string $strUserid
* @param bool $bitOnlyUnread
*
* @return int
*/
public static function getNumberOfMessagesForUser($strUserid, $bitOnlyUnread = false)
{
$objOrm = new class_orm_objectlist();
$objOrm->addWhereRestriction(new class_orm_objectlist_property_restriction("strUser", class_orm_comparator_enum::Equal(), $strUserid));
if ($bitOnlyUnread) {
$objOrm->addWhereRestriction(new class_orm_objectlist_restriction("AND (message_read IS NULL OR message_read = 0 )"));
}
return $objOrm->getObjectCount(__CLASS__);
}
/**
* Returns the default language, defined in the admin.
*
* @return class_module_languages_language
*/
public static function getDefaultLanguage()
{
$objORM = new class_orm_objectlist();
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND system_status = 1", array()));
$objORM->addWhereRestriction(new class_orm_objectlist_restriction("AND language_default = 1", array()));
/** @var class_module_languages_language $objLang */
return $objORM->getSingleObject(get_called_class());
}
