Magenaut – Passionate Magento Developer
Write about everything I learned with Magento
1 2 3 4 | SELECT `sales_order`.`customer_id`, `email`, `firstname`, `lastname`, `telephone`, `street`, `city`, `region`, `company`, SUM(subtotal_invoiced) FROM (`sales_order` LEFT JOIN `sales_order_address` ON `sales_order`.`entity_id` = `sales_order_address`.`parent_id` AND `sales_order_address`.`address_type` = "billing") WHERE state = "complete" AND store_id = 1 GROUP BY customer_email ORDER BY SUM(subtotal_invoiced) DESC LIMIT 100 |
Note: If customer_id is NULL so it’s the guest user.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | private static function getIncrementIDfromOrderID($orderID) { $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); // Instance of object manager $resource = $objectManager->get('Magento\Framework\App\ResourceConnection'); $connection = $resource->getConnection(); $tableName = $resource->getTableName('sales_order'); //gives table name with prefix //Select Data from table $result = $connection->fetchAll("SELECT increment_id FROM " . $tableName . " WHERE entity_id = " . $orderID); if (count($result)) { return $result[0]['increment_id']; } return 0; } |
Keep it simple There are a lot of good articles that wrote about this topic. But there are some better and more understandable. I prefer:…
I started to learn how to get an M2 cert. In this post, I will list all the parts of this journey and write about…