M2 development with Docker

The story Although I have tried so many docker-compose projects, I didn’t find any project that matches my requirement: Uses only Official Images. Simply enough…

TutorialSeptember 25, 2019

Query to get the top buyers in Magento 2

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

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.

TutorialSeptember 20, 2019

Standalone function get increment_id using order id

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;
}

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;

}

TutorialJune 1, 2019March 25, 2020

Magento 2 Associate Developer Certificate notes

Our target To be able to pass the Magento 2 Certified Associate Developer exam. Requirement Knowledge of Magento installation and usage of Magento storefront/admin. Knowledge…