Magento 2 – How to Get Data from sales_order_item Table

magento2sales-order

I am new to Magento 2 and
I want to get all data from sales_order_item table in Magento 2.

How to get that can anyone answer?

Best Answer

Try this,

DI Method :

Inject sales order item class in your constructor

 protected $itemFactory;
 public function __construct(
   ....
   \Magento\Sales\Model\Order\ItemFactory $itemFactory,
   ....
 ) {
    ....
    $this->itemFactory = $itemFactory;
    ....
 }

then in your function add the below code to get values from it

 try {    
    $order = $this->itemFactory->create()->getCollection();
    foreach ($order as $items) {
        $items->getItemId();  // similarly you can get all the values from slaes_order_item table
    }
} catch (\Exception $e) {
    error_log($e->getMessage());
}

For more information Follow this answer

Hope this helps.

Related Solutions

Magento 2 – How to Retrieve Custom Table Data

1) I Assume you have created Model and Collection file associated with that tables.

2) In a Block PHP file constructor add one argument (Dependency Injection) like below and store it in a class member variable.

 public function __construct(
    Context $context,
    \Namespace\Modulename\Model\ModelNameFactory $modelNameFactory,

    array $data = array()
) {
    $this->_modelFactory = $modelFactory;
    parent::__construct($context, $data);
}

3) Prepare a public method in your block to access collection like below.

public function getCollection(){

    return $this->_modelFactory->create()->getCollection();

}

4) Loop through each of the collection result.

Hope, this will help you.

Magento2 Sales Order – Get Product Options Value

Based on your json, you cannot get the delivery dates by options key, you have to use info_buyRequest, Try this

foreach ($this->order->getAllVisibleItems() as $orderItem) {
     $options = $orderItem->getProductOptions(); 
        if(!empty($options['info_buyRequest'])) {
            if(!empty($options['info_buyRequest']["deliverydates"])) {
                $deliverydates = $options['info_buyRequest']["deliverydates"];
             }
        }
}

Best Answer

Related Solutions

Magento 2 – How to Retrieve Custom Table Data

Magento2 Sales Order – Get Product Options Value

Related Topic