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