Ticket Type Queries

// Fetch ticket types as arrays
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->asArray()
    ->all();

// Fetch ticket types with a capacity of 50 or more
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->capacity('>= 50')
    ->all();

// Fetch ticket types 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);

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

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

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

// Fetch ticket types for an event
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->event($event)
    ->all();

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

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

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

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

// Fetch ticket types in reverse
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->inReverse()
    ->all();

// Fetch up to 10 ticket types
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->limit(10)
    ->all();

// Fetch all ticket types except for the first 3
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->offset(3)
    ->all();

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

// Fetch ticket types owned by an event
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->owner($event)
    ->all();

// Fetch ticket types owned by the event with an ID of 1
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->ownerId(1)
    ->all();

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

// Fetch ticket types created on an event
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->primaryOwner($event)
    ->all();

// Fetch ticket types created on the event with an ID of 1
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->primaryOwnerId(1)
    ->all();

// Fetch all ticket types that are related to myCategory
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->relatedTo($myCategory)
    ->all();

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

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

// Fetch ticket types from the Foo site
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->site('foo')
    ->all();

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

// Fetch disabled ticket types
$ticketTypes = \verbb\events\elements\TicketType::find()
    ->status('disabled')
    ->all();

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

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

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