Get Orders Collection Between a Date Range in Magento 2


Hello Magento Friends,


In today’s Magento 2 tutorial, we will find out How to Get Orders Collection Between a Date Range in Magento 2.


The admin uses order collection to get order details and smoothly fulfill the orders. Sometimes the admin does not want all order collection but needs only specific orders based on filter options.


Suppose you want all orders between a specific date range. You can Get Order Collection Between Specific Date Range in Magento 2 using the below method.


Contents [hide]


1 How to Get Orders Collection Between a Date Range in Magento 2?

2 Conclusion:

How to Get Orders Collection Between a Date Range in Magento 2?

Use the below code in your Root file


<?php

use Magento\Framework\App\Bootstrap;

ini_set('display_errors', TRUE); 

ini_set('display_startup_errors', TRUE);

 

require __DIR__ . '/../app/bootstrap.php';

 

$params = $_SERVER;

 

$bootstrap = Bootstrap::create(BP, $params);

 

$objectManager = $bootstrap->getObjectManager();

 

$state = $objectManager->get('Magento\Framework\App\State');

$state->setAreaCode('frontend');

 

$now = new \DateTime();

 

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();

 

$OrderFactory = $objectManager->create('Magento\Sales\Model\ResourceModel\Order\CollectionFactory');

 

$orderCollection = $OrderFactory->create()->addFieldToSelect(array('*'));

 

$fromdate=$now->format('2020-05-01 H:i:s');

 

$todate=$now->format('2020-06-01 H:i:s');

 

$orderCollection->addFieldToFilter('created_at', ['lteq' => $todate])

 ->addFieldToFilter('created_at', ['gteq' => $fromdate]);

 

echo "<pre>"; 

print_r($orderCollection->getData());

 

?>

Comments

Post a Comment

Popular posts from this blog

Add Admin User name and Action name in Order Comment Section through Action Performed from Sales Order Grid in Magento 2

  Step 1:  First, we need to create an “events.xml“ file inside our extension at the following path app\code\Vendor\Extension\etc\adminhtml\ Then add the code as follows. <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">     <event name="sales_order_save_after">         <observer name="sales_order_save_after_comment_history_add"           instance="\Vendor\Extension\Observer\OrderSaveAfter" />     </event> </config> Step 2:  After that, we need to create an “OrderSaveAfter.php” file inside our extension at the following path app\code\Vendor\Extension\Observer\ And embed the code as given below. <?php  namespace Vendor\Extension\Observer;   use Magento\Framework\Event\ObserverInterface; use Magento\Framework\App\RequestInterface; use Magento\Backen...
Read more

How to Update Product Stock Programmatically in Magento 2

 Steps to Update Product Stock Programmatically in Magento 2: Step 1: We need to create a “Data.php” file inside our extension at the following path app\code\Vendor\Extension\Helper\ Now add the code as follows <?php namespace Vendor\Extension\Helper;   class Data extends \Magento\Framework\App\Helper\AbstractHelper {     protected $_productobj;     protected $_stockRegistry;       public function __construct(         \Magento\Framework\App\Helper\Context $context,         \Magento\Catalog\Model\Product $productobj,         \Magento\CatalogInventory\Api\StockRegistryInterface $stockRegistry,      ) {         $this->_productobj = $productobj;         $this->_stockRegistry = $stockRegistry;         parent::__construct($context);     }       public function updateProductStock($pr...
Read more

How to Set and Get Cookie in Magento 2

 <?php namespace Vendor\Extension\Model; class Customcookie {     private $customCookieManager;     private $customCookieMetadataFactory;     public function __construct(         \Magento\Framework\Stdlib\CookieManagerInterface $customCookieManager,         \Magento\Framework\Stdlib\Cookie\CookieMetadataFactory $customCookieMetadataFactory)    {         $this->customCookieManager = $customCookieManager;         $this->customCookieMetadataFactory = $customCookieMetadataFactory;     }     public function setCookie()     {         $customCookieMetadata = $this->customCookieMetadataFactory->createPublicCookieMetadata();         $customCookieMetadata->setDurationOneYear();         $customCookieMetadata->setPath('/');         $customCookieMe...
Read more