Ttdfjt

What happened after the end of the Truman Show?

TechSupport Issue ID#812

Unbiased estimator of exponential of measure of a set?

IV curve on this solar panel datasheet

How to decide whether an eshop is safe or compromised

How can I pack my food so it doesn't smell?

Count the frequency of items in an array

Does git delete empty folders?

Why should I pay for an SSL certificate?

Can others monetize my project with GPLv3?

Does the Green Flame-Blade cantrip work with the Zephyr Strike spell?

Would it be illegal for Facebook to actively promote a political agenda?

E: Sub-process /usr/bin/dpkg returned an error code (1) - but how do I find the meaningful error messages in APT's output?

Using は before 欲しい instead が

How to detect a failed AES256 decryption programmatically?

Earliest evidence of objects intended for future archaeologists?

Is there such a thing as too inconvenient?

What animal has fat with the highest energy density?

Multicolumn in table not centered

Arduino- Duty Cycle Changing When Frequency Is Increasing

Why didn’t Doctor Strange stay in the original winning timeline?

How to think about joining a company whose business I do not understand?

Why doesn't mathematics collapse down, even though humans quite often make mistakes in their proofs?

Do predators tend to have vertical slit pupils versus horizontal for prey animals?

Magento 2 help validate function to count bundle product child items of an order

Get ordered product count in magentoOverride getValueHtml in MagentoBundleBlockSalesOrderItemsRenderermagento 2 get product sale count using custom moduleHow to get Product Cost from Order ItemsMagento Sale order create items gridMagento2 layered navigation product count for bundle itemsMagento 2 - MagentoSalesModelOrder trying to fetch items in an order is not workingHow to get child simple Product Obj from configurable Sales Order ItemsHow to add new item (product) into existing order programmatically in Magento 2Add bundle product in Wishlist with child product which selected

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

0

I'm trying to write a function that takes an order object, and returns an array of sku => qty (key-value) showing how many of each sku was sold/shipped.

The tricky part is, magento formats line items differently on configurable and bundle products.

Example:

Line1: name shirt-X2, type bundle, ordered 2, shipped 2.
Line2: name shirt, type simple, ordered 4, shipped 0. // <-- my problem

I've written this code:

/**
 * @param MagentoSalesModelOrder $order
 * @return array
 */
public function getOrderData($order)

 $result = [];
 foreach ($order->getAllItems() as $item) 
 if ($item->getProductType() != 'simple') 
 continue;
 
 $sku = $item->getSku();
 $orderedReal = $item->getQtyOrdered();
 $orderedB = $item->getQtyOrdered() - $item->getQtyRefunded() - $item->getQtyCanceled();
 $orderedB = max(round($orderedB, 8), 0);
 $invoicedB = $item->getQtyOrdered() - $item->getQtyInvoiced() - $item->getQtyCanceled();
 $invoicedB = max(round($invoicedB, 8), 0);
 $shippedReal = 0;
 $isShipped = false;
 if ($item->getParentItem()) 
 $parent = $item->getParentItem();
 if ($parent->getQtyOrdered() > 0 && $parent->getQtyOrdered() == $parent->getQtyShipped()) 
 $isShipped = true;
 
 else 
 if ($item->getQtyOrdered() > 0 && $item->getQtyOrdered() == $item->getQtyShipped()) 
 $isShipped = true;
 
 
 if ($isShipped) 
 $shippedReal = $orderedReal;
 
 $result[] = [
 'sku' => $sku,
 'invoiced' => $invoicedB,
 'ordered' => $orderedB,
 'shipped' => $shippedReal
 ];
 
 return $result;

Is this function valid, or could it be improved ?
Any help is appreciated.

Thanks

magento2 sales-order order-items custom-reports

share|improve this question

asked Aug 7 at 16:21

Mac A.Mac A.

571111 bronze badges

add a comment | 

0

I'm trying to write a function that takes an order object, and returns an array of sku => qty (key-value) showing how many of each sku was sold/shipped.

The tricky part is, magento formats line items differently on configurable and bundle products.

Example:

Line1: name shirt-X2, type bundle, ordered 2, shipped 2.
Line2: name shirt, type simple, ordered 4, shipped 0. // <-- my problem

I've written this code:

/**
 * @param MagentoSalesModelOrder $order
 * @return array
 */
public function getOrderData($order)

 $result = [];
 foreach ($order->getAllItems() as $item) 
 if ($item->getProductType() != 'simple') 
 continue;
 
 $sku = $item->getSku();
 $orderedReal = $item->getQtyOrdered();
 $orderedB = $item->getQtyOrdered() - $item->getQtyRefunded() - $item->getQtyCanceled();
 $orderedB = max(round($orderedB, 8), 0);
 $invoicedB = $item->getQtyOrdered() - $item->getQtyInvoiced() - $item->getQtyCanceled();
 $invoicedB = max(round($invoicedB, 8), 0);
 $shippedReal = 0;
 $isShipped = false;
 if ($item->getParentItem()) 
 $parent = $item->getParentItem();
 if ($parent->getQtyOrdered() > 0 && $parent->getQtyOrdered() == $parent->getQtyShipped()) 
 $isShipped = true;
 
 else 
 if ($item->getQtyOrdered() > 0 && $item->getQtyOrdered() == $item->getQtyShipped()) 
 $isShipped = true;
 
 
 if ($isShipped) 
 $shippedReal = $orderedReal;
 
 $result[] = [
 'sku' => $sku,
 'invoiced' => $invoicedB,
 'ordered' => $orderedB,
 'shipped' => $shippedReal
 ];
 
 return $result;

Is this function valid, or could it be improved ?
Any help is appreciated.

Thanks

magento2 sales-order order-items custom-reports

share|improve this question

asked Aug 7 at 16:21

Mac A.Mac A.

571111 bronze badges

add a comment | 

I'm trying to write a function that takes an order object, and returns an array of sku => qty (key-value) showing how many of each sku was sold/shipped.

The tricky part is, magento formats line items differently on configurable and bundle products.

Example:

Line1: name shirt-X2, type bundle, ordered 2, shipped 2.
Line2: name shirt, type simple, ordered 4, shipped 0. // <-- my problem

I've written this code:

/**
 * @param MagentoSalesModelOrder $order
 * @return array
 */
public function getOrderData($order)

 $result = [];
 foreach ($order->getAllItems() as $item) 
 if ($item->getProductType() != 'simple') 
 continue;
 
 $sku = $item->getSku();
 $orderedReal = $item->getQtyOrdered();
 $orderedB = $item->getQtyOrdered() - $item->getQtyRefunded() - $item->getQtyCanceled();
 $orderedB = max(round($orderedB, 8), 0);
 $invoicedB = $item->getQtyOrdered() - $item->getQtyInvoiced() - $item->getQtyCanceled();
 $invoicedB = max(round($invoicedB, 8), 0);
 $shippedReal = 0;
 $isShipped = false;
 if ($item->getParentItem()) 
 $parent = $item->getParentItem();
 if ($parent->getQtyOrdered() > 0 && $parent->getQtyOrdered() == $parent->getQtyShipped()) 
 $isShipped = true;
 
 else 
 if ($item->getQtyOrdered() > 0 && $item->getQtyOrdered() == $item->getQtyShipped()) 
 $isShipped = true;
 
 
 if ($isShipped) 
 $shippedReal = $orderedReal;
 
 $result[] = [
 'sku' => $sku,
 'invoiced' => $invoicedB,
 'ordered' => $orderedB,
 'shipped' => $shippedReal
 ];
 
 return $result;

Is this function valid, or could it be improved ?
Any help is appreciated.

Thanks

magento2 sales-order order-items custom-reports

share|improve this question

asked Aug 7 at 16:21

Mac A.Mac A.

571111 bronze badges

Line1: name shirt-X2, type bundle, ordered 2, shipped 2.
Line2: name shirt, type simple, ordered 4, shipped 0. // <-- my problem

/**
 * @param MagentoSalesModelOrder $order
 * @return array
 */
public function getOrderData($order)

 $result = [];
 foreach ($order->getAllItems() as $item) 
 if ($item->getProductType() != 'simple') 
 continue;
 
 $sku = $item->getSku();
 $orderedReal = $item->getQtyOrdered();
 $orderedB = $item->getQtyOrdered() - $item->getQtyRefunded() - $item->getQtyCanceled();
 $orderedB = max(round($orderedB, 8), 0);
 $invoicedB = $item->getQtyOrdered() - $item->getQtyInvoiced() - $item->getQtyCanceled();
 $invoicedB = max(round($invoicedB, 8), 0);
 $shippedReal = 0;
 $isShipped = false;
 if ($item->getParentItem()) 
 $parent = $item->getParentItem();
 if ($parent->getQtyOrdered() > 0 && $parent->getQtyOrdered() == $parent->getQtyShipped()) 
 $isShipped = true;
 
 else 
 if ($item->getQtyOrdered() > 0 && $item->getQtyOrdered() == $item->getQtyShipped()) 
 $isShipped = true;
 
 
 if ($isShipped) 
 $shippedReal = $orderedReal;
 
 $result[] = [
 'sku' => $sku,
 'invoiced' => $invoicedB,
 'ordered' => $orderedB,
 'shipped' => $shippedReal
 ];
 
 return $result;

share|improve this question

asked Aug 7 at 16:21

Mac A.Mac A.

571111 bronze badges

share|improve this question

asked Aug 7 at 16:21

Mac A.Mac A.

571111 bronze badges

asked Aug 7 at 16:21

Mac A.Mac A.

571111 bronze badges

asked Aug 7 at 16:21

Mac A.Mac A.

571111 bronze badges