Ticket Queries

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

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

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

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

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

// Fetch tickets for an event
$tickets = \verbb\events\elements\Ticket::find()
    ->event($event)
    ->all();

// Fetch tickets for the event with an ID of 1
$tickets = \verbb\events\elements\Ticket::find()
    ->eventId(1)
    ->all();

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

// Fetch tickets for live conference events
$tickets = \verbb\events\elements\Ticket::find()
    ->hasEvent(['type' => 'conference', 'status' => 'live'])
    ->all();

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

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

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

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

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

// Fetch tickets that cost less than 20
$tickets = \verbb\events\elements\Ticket::find()
    ->price('< 20')
    ->all();

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

// Fetch all tickets that match the search query
$searchQuery = \Craft::$app->getRequest()->getQueryParam('q');

$tickets = \verbb\events\elements\Ticket::find()
    ->search($searchQuery)
    ->all();

// Fetch tickets for a session
$tickets = \verbb\events\elements\Ticket::find()
    ->session($session)
    ->all();

// Fetch tickets for the session with an ID of 1
$tickets = \verbb\events\elements\Ticket::find()
    ->sessionId(1)
    ->all();

// Fetch the ticket with a SKU of CONF-ADULT
$ticket = \verbb\events\elements\Ticket::find()
    ->sku('CONF-ADULT')
    ->one();

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

// Fetch tickets of a ticket type
$tickets = \verbb\events\elements\Ticket::find()
    ->type($ticketType)
    ->all();

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

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

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