Ttdfjt

How on earth do I programatically retrieve customers latest order?

Tried a few solutions on the web, but they all get all orders from a customer, not all.

You can try the below code:

$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$order = $objectManager->get('MagentoSalesModelOrder')->getCollection()->addFieldToFilter('customer_id',your-customer-id)->setOrder('entity_id','DESC')->getFirstItem();
echo '<pre>'; print_r($order->getData());

OR

$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$order = $objectManager->get('MagentoSalesModelOrder')->getCollection()->addFieldToFilter('customer_id',your-customer-id)->setOrder('created_at','DESC')->getFirstItem();
echo '<pre>'; print_r($order->getData());

I can suggest you an sql query for it which you can execute in your Magento 2 instance:

SELECT * FROM `sales_order` WHERE customer_id = 'your_customer_id' ORDER BY entity_id DESC LIMIT 1

You can get the latest order of below code

• First Create an order collection.


• The filter that Collection by Customer ID.


• Sort that collection by created_at desc. setOrder('created_at', 'desc')
  


• make the collection page size 0,1 by below code using setPageSize(1),setCurPage(1)
  

`

<?php

namespace NameSpace;

class LastestOrder 

 /**
 * @var MagentoSalesModelResourceModelOrderCollectionFactory
 */
 protected $orderCollectionFactory;

 public function __construct(
 MagentoSalesModelResourceModelOrderCollectionFactory $orderCollectionFactory 
 ) 
 

 $this->orderCollectionFactory = $orderCollectionFactory;
 
 public function getLastestOrder()
 
 /**
 * MagentoSalesModelResourceModelOrderCollectionFactory $this->orderCollectionFactor
 */
 $orders = $this->orderCollectionFactory->create();
 //Add all field to Collection
 $orders->addFieldToSelect('*');
 // Collection filter by Customer Id
 $orders->addFieldToSelect('customer_id',$customerId);
 // sort order by create date descending
 $orders->setOrder('created_at','desc');
 // limit collection to 1
 $orders->setPageSize(1)->setCurPage(1);
 if($orders->count() > 0)
 $lastestOrder = $orders->getFirstItem();
 return $lastestOrder;
 else
 // no order found
 $lastestOrder = false;
 

 

`

Use this code to get customer's last order and then any order info:

use MagentoSalesModelOrderRepository;
use MagentoFrameworkApiFilterBuilder;
use MagentoFrameworkApiSearchCriteriaBuilder;
use MagentoFrameworkApiSortOrderBuilder;

public function __construct(
 OrderRepository $orderRepository,
 SearchCriteriaBuilder $searchCriteriaBuilder,
 FilterBuilder $filterBuilder,
 SortOrderBuilder $sortOrderBuilder
) 
 $this->orderRepository = $orderRepository;
 $this->searchCriteriaBuilder = $searchCriteriaBuilder;
 $this->filterBuilder = $filterBuilder;
 $this->sortOrderBuilder = $sortOrderBuilder;


/**
 * @param int $customerId
 * @return OrderSearchResultInterface
 */
public function getCustomerOrders(int $customerId): OrderSearchResultInterface

 $this->searchCriteriaBuilder->addFilter(OrderInterface::CUSTOMER_ID, $customerId);
 $this->searchCriteriaBuilder->addFilter(OrderInterface::STATUS, ['canceled', 'holded'], 'nin');
 $searchCriteria = $this->searchCriteriaBuilder->create();
 $searchCriteria->setSortOrders(
 [
 $this->sortOrderBuilder
 ->setField(OrderInterface::CREATED_AT)
 ->setDirection(SortOrder::SORT_DESC)
 ->create()
 ]
 );
 $searchResults = $this->orderRepository->getList($searchCriteria);

 return $searchResults;


public function getLastOrder()

 $result = null;
 $searchResults = $this->getCustomerOrders(<customer_id_here>);

 if ($searchResults->getTotalCount() > 0) 
 $orders = $searchResults->getList();
 /** @var MagentoSalesModelOrder $lastOrder */
 $lastOrder = reset($orders);
 $result = $lastOrder;
 
 return $result;