Session Queries

// Fetch sessions posted this month
$firstDayOfMonth = new \DateTime('first day of this month');

$sessions = \verbb\events\elements\Session::find()
    ->after($firstDayOfMonth)
    ->all();

// Fetch all events, regardless of status
$sessions = \verbb\events\elements\Session::find()
    ->anyStatus()
    ->all();

// Fetch sessions as arrays
$sessions = \verbb\events\elements\Session::find()
    ->asArray()
    ->all();

// Fetch sessions posted before this month
$firstDayOfMonth = new \DateTime('first day of this month');

$sessions = \verbb\events\elements\Session::find()
    ->before($firstDayOfMonth)
    ->all();

// Fetch sessions that have been purchased by a customer
$sessions = \verbb\events\elements\Session::find()
    ->customer($customer)
    ->all();

// Fetch sessions created last month
$start = new \DateTime('first day of next month')->format(\DateTime::ATOM);
$end = new \DateTime('first day of this month')->format(\DateTime::ATOM);

$sessions = \verbb\events\elements\Session::find()
    ->dateCreated(['and', ">= {$start}", "< {$end}"])
    ->all();

// Fetch sessions updated in the last week
$lastWeek = new \DateTime('1 week ago')->format(\DateTime::ATOM);

$sessions = \verbb\events\elements\Session::find()
    ->dateUpdated(">= {$lastWeek}")
    ->all();

// Fetch sessions created last month
$end = new \DateTime('today')->format(\DateTime::ATOM);

$sessions = \verbb\events\elements\Session::find()
    ->endDate(">= {$end}"])
    ->all();

// Fetch sessions expiring this month
$nextMonth = new \DateTime('first day of next month')->format(\DateTime::ATOM);

$sessions = \verbb\events\elements\Session::find()
    ->expiryDate("< {$nextMonth}")
    ->all();

// Fetch sessions in a specific order
$sessions = \verbb\events\elements\Session::find()
    ->id([1, 2, 3, 4, 5])
    ->fixedOrder()
    ->all();

// Fetch the event by its ID
$event = \verbb\events\elements\Session::find()
    ->id(1)
    ->one();

// Fetch sessions in reverse
$sessions = \verbb\events\elements\Session::find()
    ->inReverse()
    ->all();

// Fetch up to 10 events
$sessions = \verbb\events\elements\Session::find()
    ->limit(10)
    ->all();

// Fetch all events except for the first 3
$sessions = \verbb\events\elements\Session::find()
    ->offset(3)
    ->all();

// Fetch all events in order of date created
$sessions = \verbb\events\elements\Session::find()
    ->orderBy('elements.dateCreated asc')
    ->all();

// Fetch sessions posted last month
$start = new \DateTime('first day of next month')->format(\DateTime::ATOM);
$end = new \DateTime('first day of this month')->format(\DateTime::ATOM);

$sessions = \verbb\events\elements\Session::find()
    ->postDate(['and', ">= {$start}", "< {$end}"])
    ->all();

// Fetch all events that are related to $myCategory
$sessions = \verbb\events\elements\Session::find()
    ->relatedTo($myCategory)
    ->all();

// Get the search query from the 'q' query string param
$searchQuery = \Craft::$app->getRequest()->getQueryParam('q');

// Fetch all events that match the search query
$sessions = \verbb\events\elements\Session::find()
    ->search($searchQuery)
    ->all();

// Fetch sessions from the Foo site
$sessions = \verbb\events\elements\Session::find()
    ->site('foo')
    ->all();

// Fetch sessions from the site with an ID of 1
$sessions = \verbb\events\elements\Session::find()
    ->siteId(1)
    ->all();

// Get the requested event slug from the URL
$requestedSlug = \Craft::$app->getRequest()->getSegment(3);

// Fetch the event with that slug
$event = \verbb\events\elements\Session::find()
    ->slug(\craft\helpers\Db::escapeParam($requestedSlug))
    ->one();

// Fetch sessions created last month
$start = new \DateTime('today')->format(\DateTime::ATOM);

$sessions = \verbb\events\elements\Session::find()
    ->startDate(">= {$start}"])
    ->all();

// Fetch disabled events
$sessions = \verbb\events\elements\Session::find()
    ->status('disabled')
    ->all();

// Fetch sessions with a title that contains "Foo"
$sessions = \verbb\events\elements\Session::find()
    ->title('*Foo*')
    ->all();

// Fetch sessions with a Foo event type
$sessions = \verbb\events\elements\Session::find()
    ->type('foo')
    ->all();

// Fetch sessions of the event type with an ID of 1
$sessions = \verbb\events\elements\Session::find()
    ->typeId(1)
    ->all();

// Fetch the event by its UID
$event = \verbb\events\elements\Session::find()
    ->uid('xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx')
    ->one();

// Get the requested URI
$requestedUri = \Craft::$app->getRequest()->getPathInfo();

// Fetch the event with that URI
$event = \verbb\events\elements\Session::find()
    ->uri(\craft\helpers\Db::escapeParam($requestedUri))
    ->one();

// Fetch sessions eager-loaded with the "Related" field’s relations
$sessions = \verbb\events\elements\Session::find()
    ->with(['related'])
    ->all();