Magento2 in, we have collection of order. For some bussiness logic we need filter orders collection in specific date range in magento2.
In this blog, I filter order collection in specific date range.
Here we filter order created_at column in date range.
PHP
<?php
declare(strict_types=1);
namespace MageDad\Module\Model;
use Magento\Sales\Model\ResourceModel\Order\CollectionFactory;
class OrderFilter
{
public function __construct(
private CollectionFactory $orderCollectionFactory
) {}
public function getOrderByDateRange()
{
$orders = $this->orderCollectionFactory->create();
$startDate = date("Y-m-d h:i:s", strtotime('2024-01-01')); // start date
$endDate = date("Y-m-d h:i:s", strtotime('2024-01-31')); // end date
$orders->addAttributeToFilter('created_at', ['from' => $startDate, 'to' => $endDate]);
# echo $orders->getSelect()->__toString(); die();
# SELECT `main_table`.* FROM `sales_order` AS `main_table` WHERE (`created_at` >= '2024-01-01 12:00:00' AND `created_at` <= '2024-01-31 12:00:00')
return $orders;
}
}We created blog for collection filter with different type conditions.
Magento2 addAttributeToFilter and addFieldToFilter Condition Types.
I hope this blog is useful to Get Orders Collection between a Date Range in magento2. In case, I missed anything or need to add some more information, Don’t heisted to leave a comment in this blog, I’ll get back with some positive approach.
Keep loving ❤️ Keep inspiring 🤩 Keep liking 👍 No sharing 😂
7 Comments
rr88r1.com CASINO la mot nha cai co giay phep ca cuoc truc tuyen hop phap do Isle of Man va Khu kinh te Cagayan and Freeport cap.
Your article helped me a lot, is there any more related content? Thanks!
Your point of view caught my eye and was very interesting. Thanks. I have a question for you. https://www.binance.com/id/register?ref=GJY4VW8W
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me. https://accounts.binance.com/bn/register?ref=UM6SMJM3