Get order collection between a date range magento 2

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;







up vote
2
down vote

favorite












I have code for magento 1 site. Need to run on Magento 2.
I have used this code on outside of magento using this.



use MagentoFrameworkAppBootstrap;
require_once '../app/bootstrap.php';

$bootstrap = Bootstrap::create(BP, $_SERVER);
$obj = $bootstrap->getObjectManager();
$state = $obj->get('MagentoFrameworkAppState');
$state->setAreaCode('frontend');


$fromDate = date('Y-m-d 00:00:00', strtotime($_POST['fromdate1']));
$toDate = date('Y-m-d 23:59:59', strtotime($_POST['todate1']));
$order_status = $_POST['order_status1'];
$orders = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('created_at', array('from'=>$fromDate, 'to'=>$toDate));
 $orders->addFieldToFilter('status', array('in' => array($order_status)));
 //echo $totalOrders = count($orders);





magento2







share|improve this question























  • Can you please mention where you need the order Collection in custom block, helper or somewhere else ?
    – ROBIN
    52 mins ago










  • I need it on out side of magento .
    – Pratik Kamani
    44 mins ago
















up vote
2
down vote

favorite












I have code for magento 1 site. Need to run on Magento 2.
I have used this code on outside of magento using this.



use MagentoFrameworkAppBootstrap;
require_once '../app/bootstrap.php';

$bootstrap = Bootstrap::create(BP, $_SERVER);
$obj = $bootstrap->getObjectManager();
$state = $obj->get('MagentoFrameworkAppState');
$state->setAreaCode('frontend');


$fromDate = date('Y-m-d 00:00:00', strtotime($_POST['fromdate1']));
$toDate = date('Y-m-d 23:59:59', strtotime($_POST['todate1']));
$order_status = $_POST['order_status1'];
$orders = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('created_at', array('from'=>$fromDate, 'to'=>$toDate));
 $orders->addFieldToFilter('status', array('in' => array($order_status)));
 //echo $totalOrders = count($orders);





magento2







share|improve this question























  • Can you please mention where you need the order Collection in custom block, helper or somewhere else ?
    – ROBIN
    52 mins ago










  • I need it on out side of magento .
    – Pratik Kamani
    44 mins ago












up vote
2
down vote

favorite









up vote
2
down vote

favorite











I have code for magento 1 site. Need to run on Magento 2.
I have used this code on outside of magento using this.



use MagentoFrameworkAppBootstrap;
require_once '../app/bootstrap.php';

$bootstrap = Bootstrap::create(BP, $_SERVER);
$obj = $bootstrap->getObjectManager();
$state = $obj->get('MagentoFrameworkAppState');
$state->setAreaCode('frontend');


$fromDate = date('Y-m-d 00:00:00', strtotime($_POST['fromdate1']));
$toDate = date('Y-m-d 23:59:59', strtotime($_POST['todate1']));
$order_status = $_POST['order_status1'];
$orders = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('created_at', array('from'=>$fromDate, 'to'=>$toDate));
 $orders->addFieldToFilter('status', array('in' => array($order_status)));
 //echo $totalOrders = count($orders);





magento2







share|improve this question















I have code for magento 1 site. Need to run on Magento 2.
I have used this code on outside of magento using this.



use MagentoFrameworkAppBootstrap;
require_once '../app/bootstrap.php';

$bootstrap = Bootstrap::create(BP, $_SERVER);
$obj = $bootstrap->getObjectManager();
$state = $obj->get('MagentoFrameworkAppState');
$state->setAreaCode('frontend');


$fromDate = date('Y-m-d 00:00:00', strtotime($_POST['fromdate1']));
$toDate = date('Y-m-d 23:59:59', strtotime($_POST['todate1']));
$order_status = $_POST['order_status1'];
$orders = Mage::getModel('sales/order')->getCollection()->addAttributeToFilter('created_at', array('from'=>$fromDate, 'to'=>$toDate));
 $orders->addFieldToFilter('status', array('in' => array($order_status)));
 //echo $totalOrders = count($orders);





magento2




magento2






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 40 mins ago

























asked 56 mins ago









Pratik Kamani

721415




721415











  • Can you please mention where you need the order Collection in custom block, helper or somewhere else ?
    – ROBIN
    52 mins ago










  • I need it on out side of magento .
    – Pratik Kamani
    44 mins ago
















  • Can you please mention where you need the order Collection in custom block, helper or somewhere else ?
    – ROBIN
    52 mins ago










  • I need it on out side of magento .
    – Pratik Kamani
    44 mins ago















Can you please mention where you need the order Collection in custom block, helper or somewhere else ?
– ROBIN
52 mins ago




Can you please mention where you need the order Collection in custom block, helper or somewhere else ?
– ROBIN
52 mins ago












I need it on out side of magento .
– Pratik Kamani
44 mins ago




I need it on out side of magento .
– Pratik Kamani
44 mins ago










2 Answers
2






active

oldest

votes

















up vote
1
down vote



accepted










Use Below code in your Root file.



 <?php
use MagentoFrameworkAppBootstrap;

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

$params = $_SERVER;

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

$objectManager = $bootstrap->getObjectManager();

$state = $objectManager->get('MagentoFrameworkAppState');
$state->setAreaCode('frontend');


$now = new DateTime();
$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$OrderFactory = $objectManager->create('MagentoSalesModelResourceModelOrderCollectionFactory');
$orderCollection = $OrderFactory->create()->addFieldToSelect(array('*'));
$orderCollection->addFieldToFilter('created_at', ['lteq' => $now->format('Y-m-d H:i:s')])->addFieldToFilter('created_at', ['gteq' => $now->format('2018-05-01 H:i:s')]);
echo "<pre>"; print_r($orderCollection->getData());
?>





share|improve this answer



























    up vote
    1
    down vote













    Try below code from any class within Magento. You need to change namespace, class name and function name as per your requirement:



    <?php
    namespace 'NAME_SPACEOFYOURCLASS';

    class YOURCALSS extends MagentoFrameworkAppActionAction


     protected $_orderCollectionFactory;

     public function __construct(
     MagentoFrameworkAppActionContext $context,
     MagentoSalesModelResourceModelOrderCollectionFactory $orderCollectionFactory 
     ) 
     $this->_orderCollectionFactory = $orderCollectionFactory;
     parent::__construct($context);

     

     
     public function YOURFUNCTION()
     
     $collection = $this->_orderCollectionFactory->create()->addAttributeToSelect('*');

     // You Can filter collection as 
     $this->orderCollectionFactory
     ->addFieldToFilter('created_at', array('gteq' => $fromDate))
     ->addFieldToFilter('created_at', array('lteq' => $toDate));
     


     } 
    }





    share|improve this answer




















      Your Answer







      StackExchange.ready(function()
      var channelOptions =
      tags: "".split(" "),
      id: "479"
      ;
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function()
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled)
      StackExchange.using("snippets", function()
      createEditor();
      );

      else
      createEditor();

      );

      function createEditor()
      StackExchange.prepareEditor(
      heartbeatType: 'answer',
      convertImagesToLinks: false,
      noModals: false,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: null,
      bindNavPrevention: true,
      postfix: "",
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      );



      );













       

      draft saved


      draft discarded


















      StackExchange.ready(
      function ()
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f242695%2fget-order-collection-between-a-date-range-magento-2%23new-answer', 'question_page');

      );

      Post as a guest

















      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes








      up vote
      1
      down vote



      accepted










      Use Below code in your Root file.



       <?php
      use MagentoFrameworkAppBootstrap;

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

      $params = $_SERVER;

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

      $objectManager = $bootstrap->getObjectManager();

      $state = $objectManager->get('MagentoFrameworkAppState');
      $state->setAreaCode('frontend');


      $now = new DateTime();
      $objectManager = MagentoFrameworkAppObjectManager::getInstance();
      $OrderFactory = $objectManager->create('MagentoSalesModelResourceModelOrderCollectionFactory');
      $orderCollection = $OrderFactory->create()->addFieldToSelect(array('*'));
      $orderCollection->addFieldToFilter('created_at', ['lteq' => $now->format('Y-m-d H:i:s')])->addFieldToFilter('created_at', ['gteq' => $now->format('2018-05-01 H:i:s')]);
      echo "<pre>"; print_r($orderCollection->getData());
      ?>





      share|improve this answer
























        up vote
        1
        down vote



        accepted










        Use Below code in your Root file.



         <?php
        use MagentoFrameworkAppBootstrap;

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

        $params = $_SERVER;

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

        $objectManager = $bootstrap->getObjectManager();

        $state = $objectManager->get('MagentoFrameworkAppState');
        $state->setAreaCode('frontend');


        $now = new DateTime();
        $objectManager = MagentoFrameworkAppObjectManager::getInstance();
        $OrderFactory = $objectManager->create('MagentoSalesModelResourceModelOrderCollectionFactory');
        $orderCollection = $OrderFactory->create()->addFieldToSelect(array('*'));
        $orderCollection->addFieldToFilter('created_at', ['lteq' => $now->format('Y-m-d H:i:s')])->addFieldToFilter('created_at', ['gteq' => $now->format('2018-05-01 H:i:s')]);
        echo "<pre>"; print_r($orderCollection->getData());
        ?>





        share|improve this answer






















          up vote
          1
          down vote



          accepted







          up vote
          1
          down vote



          accepted






          Use Below code in your Root file.



           <?php
          use MagentoFrameworkAppBootstrap;

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

          $params = $_SERVER;

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

          $objectManager = $bootstrap->getObjectManager();

          $state = $objectManager->get('MagentoFrameworkAppState');
          $state->setAreaCode('frontend');


          $now = new DateTime();
          $objectManager = MagentoFrameworkAppObjectManager::getInstance();
          $OrderFactory = $objectManager->create('MagentoSalesModelResourceModelOrderCollectionFactory');
          $orderCollection = $OrderFactory->create()->addFieldToSelect(array('*'));
          $orderCollection->addFieldToFilter('created_at', ['lteq' => $now->format('Y-m-d H:i:s')])->addFieldToFilter('created_at', ['gteq' => $now->format('2018-05-01 H:i:s')]);
          echo "<pre>"; print_r($orderCollection->getData());
          ?>





          share|improve this answer












          Use Below code in your Root file.



           <?php
          use MagentoFrameworkAppBootstrap;

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

          $params = $_SERVER;

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

          $objectManager = $bootstrap->getObjectManager();

          $state = $objectManager->get('MagentoFrameworkAppState');
          $state->setAreaCode('frontend');


          $now = new DateTime();
          $objectManager = MagentoFrameworkAppObjectManager::getInstance();
          $OrderFactory = $objectManager->create('MagentoSalesModelResourceModelOrderCollectionFactory');
          $orderCollection = $OrderFactory->create()->addFieldToSelect(array('*'));
          $orderCollection->addFieldToFilter('created_at', ['lteq' => $now->format('Y-m-d H:i:s')])->addFieldToFilter('created_at', ['gteq' => $now->format('2018-05-01 H:i:s')]);
          echo "<pre>"; print_r($orderCollection->getData());
          ?>






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 29 mins ago









          Ansar Husain

          1,236217




          1,236217






















              up vote
              1
              down vote













              Try below code from any class within Magento. You need to change namespace, class name and function name as per your requirement:



              <?php
              namespace 'NAME_SPACEOFYOURCLASS';

              class YOURCALSS extends MagentoFrameworkAppActionAction


               protected $_orderCollectionFactory;

               public function __construct(
               MagentoFrameworkAppActionContext $context,
               MagentoSalesModelResourceModelOrderCollectionFactory $orderCollectionFactory 
               ) 
               $this->_orderCollectionFactory = $orderCollectionFactory;
               parent::__construct($context);

               

               
               public function YOURFUNCTION()
               
               $collection = $this->_orderCollectionFactory->create()->addAttributeToSelect('*');

               // You Can filter collection as 
               $this->orderCollectionFactory
               ->addFieldToFilter('created_at', array('gteq' => $fromDate))
               ->addFieldToFilter('created_at', array('lteq' => $toDate));
               


               } 
              }





              share|improve this answer
























                up vote
                1
                down vote













                Try below code from any class within Magento. You need to change namespace, class name and function name as per your requirement:



                <?php
                namespace 'NAME_SPACEOFYOURCLASS';

                class YOURCALSS extends MagentoFrameworkAppActionAction


                 protected $_orderCollectionFactory;

                 public function __construct(
                 MagentoFrameworkAppActionContext $context,
                 MagentoSalesModelResourceModelOrderCollectionFactory $orderCollectionFactory 
                 ) 
                 $this->_orderCollectionFactory = $orderCollectionFactory;
                 parent::__construct($context);

                 

                 
                 public function YOURFUNCTION()
                 
                 $collection = $this->_orderCollectionFactory->create()->addAttributeToSelect('*');

                 // You Can filter collection as 
                 $this->orderCollectionFactory
                 ->addFieldToFilter('created_at', array('gteq' => $fromDate))
                 ->addFieldToFilter('created_at', array('lteq' => $toDate));
                 


                 } 
                }





                share|improve this answer






















                  up vote
                  1
                  down vote










                  up vote
                  1
                  down vote









                  Try below code from any class within Magento. You need to change namespace, class name and function name as per your requirement:



                  <?php
                  namespace 'NAME_SPACEOFYOURCLASS';

                  class YOURCALSS extends MagentoFrameworkAppActionAction


                   protected $_orderCollectionFactory;

                   public function __construct(
                   MagentoFrameworkAppActionContext $context,
                   MagentoSalesModelResourceModelOrderCollectionFactory $orderCollectionFactory 
                   ) 
                   $this->_orderCollectionFactory = $orderCollectionFactory;
                   parent::__construct($context);

                   

                   
                   public function YOURFUNCTION()
                   
                   $collection = $this->_orderCollectionFactory->create()->addAttributeToSelect('*');

                   // You Can filter collection as 
                   $this->orderCollectionFactory
                   ->addFieldToFilter('created_at', array('gteq' => $fromDate))
                   ->addFieldToFilter('created_at', array('lteq' => $toDate));
                   


                   } 
                  }





                  share|improve this answer












                  Try below code from any class within Magento. You need to change namespace, class name and function name as per your requirement:



                  <?php
                  namespace 'NAME_SPACEOFYOURCLASS';

                  class YOURCALSS extends MagentoFrameworkAppActionAction


                   protected $_orderCollectionFactory;

                   public function __construct(
                   MagentoFrameworkAppActionContext $context,
                   MagentoSalesModelResourceModelOrderCollectionFactory $orderCollectionFactory 
                   ) 
                   $this->_orderCollectionFactory = $orderCollectionFactory;
                   parent::__construct($context);

                   

                   
                   public function YOURFUNCTION()
                   
                   $collection = $this->_orderCollectionFactory->create()->addAttributeToSelect('*');

                   // You Can filter collection as 
                   $this->orderCollectionFactory
                   ->addFieldToFilter('created_at', array('gteq' => $fromDate))
                   ->addFieldToFilter('created_at', array('lteq' => $toDate));
                   


                   } 
                  }






                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 20 mins ago









                  Mohit Kumar Arora

                  5,37041332




                  5,37041332



























                       

                      draft saved


                      draft discarded















































                       


                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function ()
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f242695%2fget-order-collection-between-a-date-range-magento-2%23new-answer', 'question_page');

                      );

                      Post as a guest
































































                      Comments

                      Post a Comment

                      Popular posts from this blog

                      White Anglo-Saxon Protestant

                      Image
                      White Anglo-Saxon Protestants ( WASPs ) are a social group of wealthy and well-connected white Americans, of Protestant and predominantly British ancestry, who trace their ancestry to the American colonial period. Until at least the 1960s, this group has dominated American society and culture and dominated in the leadership of the Whig and Republican parties. They usually are very well placed in major financial, business, legal and academic institutions and had close to a monopoly of elite society due to intermarriage and nepotism. [1] During the latter half of the twentieth century, outsider ethnic and racial groups grew in influence and WASP dominance weakened. Americans are increasingly criticizing the WASP hegemony and disparaging WASPs as the epitome of "the Establishment". The Random House Unabridged Dictionary (1998) says the term is "Sometimes Disparaging and Offensive". [2] [3] The term WASP is often used as a pejorative to classify their historical dom...
                      Read more

                      Is the Concept of Multiple Fantasy Races Scientifically Flawed? [closed]

                      Image
                      Clash Royale CLAN TAG #URR8PPP up vote 2 down vote favorite Many fantasy worlds have multiple humanoid species (elves, orcs, humans, etc) living in the same world, in addition to that, they often have the ability to interbreed. And I can't help but question their believability... fantasy-races reproduction interspecies-relations share | improve this question edited Aug 9 at 14:46 Michael Kjörling ♦ 21.1k 10 85 161 asked Aug 9 at 13:13 Chlodio 118 6 closed as unclear what you're asking by MichaelK, Gryphon, John, Vincent, Frostfyre Aug 9 at 15:25 Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question. ...
                      Read more

                      One-line joke

                      A one-liner is a joke that is delivered in a single line. A good one-liner is said to be pithy - concise and meaningful. [1] Comedians and actors use this comedic method as part of their act, e.g. Jimmy Carr, Tommy Cooper, Rodney Dangerfield, Norm Macdonald, Ken Dodd, Stewart Francis, Zach Galifianakis, Mitch Hedberg, Anthony Jeselnik, Milton Jones, Shappi Khorsandi, Jay London, Mark Linn-Baker, Demetri Martin, Groucho Marx, Dan Mintz, Emo Philips, Tim Vine, Steven Wright and Henny Youngman and Arnold Schwarzenegger. [ citation needed ] Many fictional characters are also known to deliver one-liners, including James Bond, who usually includes pithy and laconic quips after disposing of a villain. [ citation needed ] Examples "A baby seal walks into a club." "A dyslexic man walks into a bra." (Anonymous) "There are three types of people, those who can count and those who can't." "Venison's dear, isn't it?" (Jimmy Carr) "An escala...
                      Read more