Ttdfjt

I'm trying to show product information on Order_View page. I have selected all of the product I have ordered from many orders to show on a page (Order_History). On the Order_History, When you click on Order Detail, it will show the product you have clicked on with information about price, qty...My idea to do that is I want to get the itemId in table sale_order_item, from that, I can get specific the product I want to show on.
Can anyone show me how can we get the itemId?? I refer to this link, But, it did not solve my problem.

<?php
 namespace MagentoHistoryBlock;

 class Display extends MagentoFrameworkViewElementTemplate
 

protected $order;
protected $orderRepository;


public function __construct(

 MagentoSalesApiDataOrderInterface $order,
 MagentoSalesApiOrderRepositoryInterface $orderRepository
) 

 $this->order = $order;
 $this->orderRepository = $orderRepository;


public function yourFunction()

 $order_increment_id = '4';
 $order = $this->order->loadByIncrementId($order_increment_id);
 $orderId = $order->getId();
 $order = $this->orderRepository->get($orderId);
 $item_data = [];
 $count = 0;
 foreach ($order->getAllVisibleItems() as $item) 
 echo $item->getName();
 $item_data[$count]['item_id'] = $item->getItemId();
 $item_data[$count]['product_id'] = $item->getProductId();
 $count++;

 
 return $item_data;

You can use this below code and get order item id using order id :

Method 1 :

protected $orderRepository;

public function __construct(
 ...
 MagentoSalesApiOrderRepositoryInterface $orderRepository,
 ....
) 
 ....
 $this->orderRepository = $orderRepository;
 ....


public function yourFunction()

 $orderId = 105105;
 $order = $this->orderRepository->get($orderId);
 $item_data = [];
 $count = 0;
 foreach ($order->getAllVisibleItems() as $item) 
 //var_dump($item->getData());
 $item_data[$count]['item_id'] = $item->getItemId();
 $item_data[$count]['product_id'] = $item->getProductId(); //for product Id
 $count++;
 
 return $item_data;

Method 2 :

protected $order;
protected $orderRepository;


public function __construct(
 ...
 MagentoSalesApiDataOrderInterface $order,
 MagentoSalesApiOrderRepositoryInterface $orderRepository,
 ...
) 
 $this->order = $order;
 $this->orderRepository = $orderRepository;


public function yourFunction()

 $order_increment_id = '100005363';
 $order = $this->order->loadByIncrementId($order_increment_id);
 $orderId = $order->getId();
 $order = $this->orderRepository->get($orderId);
 $item_data = [];
 $count = 0;
 foreach ($order->getAllVisibleItems() as $item) 
 //var_dump($item->getData());
 $item_data[$count]['item_id'] = $item->getItemId();
 $item_data[$count]['product_id'] = $item->getProductId(); //for product Id
 $count++;

 
 return $item_data;

Method 1 : Get order item id by order id

Method 2 : Get order item id by order increment id

Now, call function $block->yourFunction() in your phtml file.

If you have order id then you can load by this:

//Where $this->orderRepository is the instance of MagentoSalesApiOrderRepositoryInterface
$order = $this->orderRepository->get($id);

If you have order increment id then you can load order by this:

//Where $this->orderInterfaceFactory is the instance of MagentoSalesApiDataOrderInterfaceFactory
$order = $this->orderInterfaceFactory->create()->loadByIncrementId($orderId);

Now get all items

$items = $order->getAllVisibleItems();

The difference between getAllVisibleItems() and getAllItems() is that Visible items will only show items which would visible on frontend, whereas AllItems will send visible as well as associated items.

Now use foreach loop to get item ids

foreach($items as $item)

 echo "Order Item ID :".$item->getItemId();
 echo "Order Product ID : ".$item->getProductId();

$item->getItemId() will return item id which is primary key of sale_order_item table, whereas $item->getProductId() will return product id.