Source of file OrderFiltersUntilDateFilter.php
Size: 0,695 Bytes - Last Modified: 2021-12-23T10:39:35+00:00
/var/www/docs.ssmods.com/process/src/src/Search/Filters/OrderFiltersUntilDateFilter.php
123456789101112131415161718192021222324252627282930313233 | <?php namespace Sunnysideup\Ecommerce\Search\Filters; use SilverStripe\ORM\DataQuery; use SilverStripe\ORM\FieldType\DBDate; use SilverStripe\ORM\Filters\ExactMatchFilter; /** * @authors: Nicolaas [at] Sunny Side Up .co.nz * @package: ecommerce * @sub-package: search */ class OrderFiltersUntilDateFilter extends ExactMatchFilter { /** * @return DataQuery */ public function apply(DataQuery $query) { $value = $this->getValue(); $date = new DBDate(); $date->setValue(strtotime($value)); $formattedDate = $date->format('y-MM-d'); $query->where("\"Order\".\"Created\" <= '{$formattedDate}'"); return $query; } } |