/**
* @param int $days
* @param int $batch_size
* @return IFoundationMemberRevocationNotification[]
*/
public function getNotificationsSentXDaysAgo($days, $batch_size)
{
$query = new QueryObject(new FoundationMemberRevocationNotification());
$query->addAndCondition(QueryCriteria::equal('Action', 'None'));
$today = new DateTime('now', new DateTimeZone("UTC"));
$query->addAndCondition(QueryCriteria::lowerOrEqual('ADDDATE(SentDate, INTERVAL ' . $days . ' DAY)', $today->format('Y-m-d H:i:s'), false));
list($res, $size) = $this->getAll($query, 0, $batch_size);
return $res;
}
/**
* @param mixed|null $day
* @param int|null $location
* @return SummitEvent[]
* @throws Exception
*/
public function getSchedule($day = null, $location = null)
{
$query = new QueryObject();
$query->addAndCondition(QueryCriteria::equal('Published', 1));
if (!is_null($day)) {
if (!$day instanceof DateTime) {
$day = new DateTime($day);
}
$start = $day->setTime(0, 0, 0)->format("Y-m-d H:i:s");
$end = $day->add(new DateInterval('PT23H59M59S'))->format("Y-m-d H:i:s");
$query->addAndCondition(QueryCriteria::greaterOrEqual('StartDate', $this->convertDateFromTimeZone2UTC($start)));
$query->addAndCondition(QueryCriteria::lowerOrEqual('EndDate', $this->convertDateFromTimeZone2UTC($end)));
}
if (!is_null($location)) {
$query->addAndCondition(QueryCriteria::equal('LocationID', intval($location)));
}
$query->addOrder(QueryOrder::asc('StartDate'))->addOrder(QueryOrder::asc('EndDate'))->addOrder(QueryOrder::asc('Title'));
return new ArrayList(AssociationFactory::getInstance()->getOne2ManyAssociation($this, 'Events', $query)->toArray());
}
/**
* @param mixed|null $day
* @return SummitEvent[]
* @throws Exception
*/
public function getSchedule($day = null)
{
$query = new QueryObject();
$query->addAndCondition(QueryCriteria::equal('Published', 1));
if (!is_null($day)) {
if (!$day instanceof DateTime) {
$day = new DateTime($day);
}
$day->setTime(0, 0, 0);
$query->addAndCondition(QueryCriteria::greaterOrEqual('StartDate', $day->format('Y-m-d H:i:s')));
$query->addAndCondition(QueryCriteria::lowerOrEqual('EndDate', $day->add(new DateInterval('PT23H59M59S'))->format('Y-m-d H:i:s')));
}
$query->addOrder(QueryOrder::asc('StartDate'));
return AssociationFactory::getInstance()->getOne2ManyAssociation($this, 'Events', $query)->toArray();
}
public function getArticlesToSort($article_id, $new_rank, $old_rank, $is_new, $is_remove, $type)
{
$slider = $featured = $approved = 0;
if ($type == 'slider') {
$slider = 1;
$approved = 1;
} elseif ($type == 'featured') {
$featured = 1;
$approved = 1;
} elseif ($type == 'recent') {
$approved = 1;
}
$query = new QueryObject(new News());
$query->addAndCondition(QueryCriteria::notEqual('ID', $article_id));
$query->addAndCondition(QueryCriteria::equal('Slider', $slider));
$query->addAndCondition(QueryCriteria::equal('Featured', $featured));
$query->addAndCondition(QueryCriteria::equal('Approved', $approved));
if ($is_new) {
$query->addAndCondition(QueryCriteria::greaterOrEqual('Rank', $new_rank));
$rank_delta = 1;
} elseif ($is_remove) {
$query->addAndCondition(QueryCriteria::greaterOrEqual('Rank', $old_rank));
$rank_delta = -1;
} else {
if ($old_rank < $new_rank) {
$query->addAndCondition(QueryCriteria::greaterOrEqual('Rank', $old_rank));
$query->addAndCondition(QueryCriteria::lowerOrEqual('Rank', $new_rank));
$rank_delta = -1;
} else {
$query->addAndCondition(QueryCriteria::greaterOrEqual('Rank', $new_rank));
$query->addAndCondition(QueryCriteria::lowerOrEqual('Rank', $old_rank));
$rank_delta = 1;
}
}
list($other_articles, $count) = $this->getAll($query);
$return_array = array($other_articles, $rank_delta);
return $return_array;
}
/**
* @return ISurveyTemplate
*/
public function getCurrentSurveyTemplate()
{
$query = new QueryObject();
$now = new \DateTime('now', new DateTimeZone('UTC'));
$query->addAndCondition(QueryCriteria::lowerOrEqual('StartDate', $now->format('Y-m-d H:i:s')));
$query->addAndCondition(QueryCriteria::greaterOrEqual('EndDate', $now->format('Y-m-d H:i:s')));
$query->addAndCondition(QueryCriteria::equal('Enabled', 1));
return $this->template_repository->getBy($query);
}
