Voucher Queries

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

$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->after($firstDayOfMonth)
    ->all();

// Fetch vouchers as arrays
$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->asArray()
    ->all();

// Fetch vouchers that are available for purchase
$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->availableForPurchase()
    ->all();

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

$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->before($firstDayOfMonth)
    ->all();

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

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

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

$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->dateUpdated(">= {$lastWeek}")
    ->all();

// Fetch vouchers the current user can edit
$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->editable()
    ->all();

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

$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->expiryDate("< {$nextMonth}")
    ->all();

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

// Fetch the voucher by its ID
$voucher = \verbb\giftvoucher\elements\Voucher::find()
    ->id(1)
    ->one();

// Fetch vouchers in reverse
$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->inReverse()
    ->all();

// Fetch up to 10 vouchers
$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->limit(10)
    ->all();

// Fetch all vouchers except for the first 3
$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->offset(3)
    ->all();

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

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

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

// Fetch vouchers that cost 100 or more
$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->price('>= 100')
    ->all();

// Fetch all vouchers that are related to myCategory
$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->relatedTo($myCategory)
    ->all();

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

$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->search($searchQuery)
    ->all();

// Fetch vouchers from the Foo site
$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->site('foo')
    ->all();

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

// Fetch the voucher with a SKU of GIFT-50
$voucher = \verbb\giftvoucher\elements\Voucher::find()
    ->sku('GIFT-50')
    ->one();

// Fetch the voucher with the slug in the URL
$requestedSlug = \Craft::$app->getRequest()->getSegment(3);

$voucher = \verbb\giftvoucher\elements\Voucher::find()
    ->slug(\craft\helpers\Db::escapeParam($requestedSlug))
    ->one();

// Fetch disabled vouchers
$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->status('disabled')
    ->all();

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

// Fetch vouchers with a Gift Cards voucher type
$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->type('giftCards')
    ->all();

// Fetch vouchers of the voucher type with an ID of 1
$vouchers = \verbb\giftvoucher\elements\Voucher::find()
    ->typeId(1)
    ->all();

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

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

$voucher = \verbb\giftvoucher\elements\Voucher::find()
    ->uri(\craft\helpers\Db::escapeParam($requestedUri))
    ->one();

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