Hello magento friends today's i'm share wioth you to How to filter category product collection by special price and date in Magento
.png "How to filter category product collection by special price and date in Magento")
👉 You can add this is any phtml files :
<?php
$currentCatId = Mage::registry('current_category')->getParentCategory()->getId();
$_productCollection = Mage::getModel('catalog/category')->load($currentCatId)
->getProductCollection()
->addAttributeToSelect('*') // add all attributes - optional
->addAttributeToFilter('status', 1) // enabled
->addAttributeToFilter('visibility', 4) //visibility in catalog,search
->addAttributeToFilter('special_from_date',
array('date' => true, 'to' => $todayDate))
->addAttributeToFilter('special_to_date',
array('or'=> array(
0 => array('date' => true, 'from' => $tomorrowDate),
1 => array('is' => new Zend_Db_Expr('null')))
), 'left');
?>
👉 in this bellow code i'm get special price product collection Magento 2 :
👉 create your own block file and get collection below way.
in this bellow code i'm get to special product price and collection like name , image, small image, thumbnail , etc
<?php
namespace VendorName\SaleProducts\Block\Home;
use Magento\Catalog\Api\CategoryRepositoryInterface;
class SaleList extends \Magento\Catalog\Block\Product\ListProduct
{
protected $_collection;
protected $categoryRepository;
protected $_resource;
public function __construct(
\Magento\Catalog\Block\Product\Context $context,
\Magento\Framework\Data\Helper\PostHelper $postDataHelper,
\Magento\Catalog\Model\Layer\Resolver $layerResolver,
CategoryRepositoryInterface $categoryRepository,
\Magento\Framework\Url\Helper\Data $urlHelper,
\Magento\Catalog\Model\ResourceModel\Product\Collection $collection,
\Magento\Framework\App\ResourceConnection $resource,
array $data = []
) {
$this->categoryRepository = $categoryRepository;
$this->_collection = $collection;
$this->_resource = $resource;
parent::__construct(
$context,
$postDataHelper,
$layerResolver,
$categoryRepository,
$urlHelper,
$data
);
}
public function getProducts()
{
$count = $this->getProductCount();
$category_id = $this->getData("category_id");
$collection = clone $this->_collection;
$collection
->clear()
->getSelect()
->reset(\Magento\Framework\DB\Select::WHERE)
->reset(\Magento\Framework\DB\Select::ORDER)
->reset(\Magento\Framework\DB\Select::LIMIT_COUNT)
->reset(\Magento\Framework\DB\Select::LIMIT_OFFSET)
->reset(\Magento\Framework\DB\Select::GROUP);
if (!$category_id) {
$category_id = $this->_storeManager
->getStore()
->getRootCategoryId();
}
$category = $this->categoryRepository->get($category_id);
$now = date("Y-m-d");
if (isset($category) && $category) {
$collection
->addMinimalPrice()
->addFinalPrice()
->addTaxPercents()
->addAttributeToSelect("name")
->addAttributeToSelect("image")
->addAttributeToSelect("small_image")
->addAttributeToSelect("thumbnail")
->addAttributeToSelect("special_from_date")
->addAttributeToSelect("special_to_date")
->addAttributeToFilter("special_price", ["neq" => ""])
->addAttributeToFilter([
[
"attribute" => "special_from_date",
"lteq" => date("Y-m-d G:i:s", strtotime($now)),
"date" => true,
],
[
"attribute" => "special_to_date",
"gteq" => date("Y-m-d G:i:s", strtotime($now)),
"date" => true,
],
])
->addAttributeToFilter("is_saleable", 1, "left");
} else {
$collection
->addMinimalPrice()
->addFinalPrice()
->addTaxPercents()
->addAttributeToSelect("name")
->addAttributeToSelect("image")
->addAttributeToSelect("small_image")
->addAttributeToSelect("thumbnail")
->addAttributeToFilter("special_price", ["neq" => ""])
->addAttributeToSelect("special_from_date")
->addAttributeToSelect("special_to_date")
->addAttributeToFilter([
[
"attribute" => "special_from_date",
"lteq" => date("Y-m-d G:i:s", strtotime($now)),
"date" => true,
],
[
"attribute" => "special_to_date",
"gteq" => date("Y-m-d G:i:s", strtotime($now)),
"date" => true,
],
])
->addAttributeToFilter("is_saleable", 1, "left");
}
$collection->getSelect()->limit($count);
return $collection;
}
public function getLoadedProductCollection()
{
return $this->getProducts();
}
public function getProductCount()
{
$limit = $this->getData("product_count");
if (!$limit) {
$limit = 10;
}
return $limit;
}
}
After than you can use in the template file this: to get output :
<?php foreach ($block->getLoadedProductCollection() as $product) : ?>
<!-- do something with $product -->
<?php endforeach;?>