Get Orders Collection Between a Date Range in Magento2

 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