private function __construct()
{
$this->eventDao = EVENTX_BOL_EventDao::getInstance();
$this->eventUserDao = EVENTX_BOL_EventUserDao::getInstance();
$this->eventInviteDao = EVENTX_BOL_EventInviteDao::getInstance();
$this->categoryDao = EVENTX_BOL_CategoryDao::getInstance();
$this->eventCategoryDao = EVENTX_BOL_EventCategoryDao::getInstance();
$this->configs[self::CONF_EVENTX_USERS_COUNT] = 10;
$this->configs[self::CONF_EVENTS_COUNT_ON_PAGE] = 15;
$this->configs[self::CONF_DASH_WIDGET_EVENTS_COUNT] = 3;
$this->configs[self::CONF_WIDGET_EVENTS_COUNT] = 3;
$this->configs[self::CONF_EVENTX_USERS_COUNT_ON_PAGE] = OW::getConfig()->getValue('eventx', 'resultsPerPage');
$this->configs[self::CONF_WIDGET_EVENTS_COUNT_OPTION_LIST] = array(3 => 3, 5 => 5, 10 => 10, 15 => 15, 20 => 20);
}
public function hideInvitationByUserId($userId)
{
$query = "UPDATE `" . EVENTX_BOL_EventInviteDao::getInstance()->getTableName() . "` SET `displayInvitation` = false \n WHERE `" . EVENTX_BOL_EventInviteDao::USER_ID . "` = :userId AND `displayInvitation` = true ";
return $this->dbo->update($query, array('userId' => (int) $userId));
}
public function findDispaledUserInvitationCount($userId)
{
$query = "SELECT COUNT(*) AS `count` FROM `" . $this->getTableName() . "` AS `e`\n INNER JOIN `" . EVENTX_BOL_EventInviteDao::getInstance()->getTableName() . "` AS `ei` ON ( `e`.`id` = `ei`.`" . EVENTX_BOL_EventInviteDao::EVENTX_ID . "` )\n WHERE `ei`.`" . EVENTX_BOL_EventInviteDao::USER_ID . "` = :userId AND `ei`.`displayInvitation` = true AND " . $this->getTimeClause(false, 'e') . " GROUP BY `e`.`id`";
return $this->dbo->queryForColumn($query, array('userId' => (int) $userId, 'startTime' => time(), 'endTime' => time()));
}
