Magento – How to get order Grand Total from information about order’s items (products)

databasegrand-totalmagento-1sales-ordersql

I'm building a custom report on the basis of database.

I need to know how to get 'Grand Total' that is in 'sales/order' (in other words sales_flat_order) table by order items (from 'sales/order_item', sales_flat_order_item table).

I need a formula to get this value using the database and not using Magento methods.

I am building MySQL query

Am I right when I say that

base_grand_total =  (IFNULL(base_total_canceled,0)) +  (IFNULL(base_hidden_tax_amount,0) - IFNULL(base_hidden_tax_refunded,0)) + IFNULL(base_total_offline_refunded,0) + IFNULL(base_total_online_refunded,0) +  ( IFNULL(base_subtotal,0) - IFNULL(base_subtotal_canceled,0) - IFNULL(base_subtotal_refunded,0)) + (IFNULL(base_tax_amount,0) - IFNULL(base_tax_canceled,0) - IFNULL(base_tax_refunded,0)) + (IFNULL(base_shipping_amount,0) - IFNULL(base_shipping_canceled,0) - IFNULL(base_shipping_refunded,0)) + (IFNULL(base_discount_amount,0) - IFNULL(base_discount_canceled,0) - IFNULL(base_discount_refunded,0)) ?

Best Answer

You can pass the order_entity_id and get the grand total value

function get_order_details($order_entity_id)
{
$getsales = mysql_query("SELECT grand_total FROM `sales_flat_order` WHERE `entity_id`='$order_entity_id'");
if(mysql_num_rows($getsales) == 1)
{
return mysql_fetch_object($getsales);
}
elseif(mysql_num_rows($getsales) > 1)
{
return $getsales;
}
else
return FALSE;
}

Related Solutions

Magento – Calculate grand total on order

To calculate and process the grand total you need to follow these

$quote = Mage::getSingleton('checkout/session')->getQuote();
    $address = Mage::getSingleton('checkout/session')->getQuote()->getShippingAddress();
    $address = Mage::getSingleton('checkout/session')->getQuote()->getBillingAddress();
    $quote = $address->getQuote();
    $session= Mage::getSingleton('checkout/session');    
                $items = $session->getQuote()->getAllItems();
        //$items = $quote->getAddressItems($items);
    //echo '<pre>'; print_r($items);

    if(Excellence_Fee_Model_Fee::canApply($address)){
                 //$exist_amount = $quote->getFeeAmount();
                    // $fee = 1000;
                        //$fees = $fee * $result;
                    $balance = 1000;
                        //          $balance = $fee;

                        //$this->_setAmount($balance);
                        //$this->_setBaseAmount($balance);
                        $address->setGrandTotal($balance);

                        $address->setFeeAmount($balance);

                        $address->setBaseFeeAmount($balance);
                        $quote->setGrandTotal($balance);
                        $quote->setBaseGrandTotal($balance);
                        //echo '<pre>'; print_r($quote);
                        $quote->setFeeAmount($balance);
                        //echo '<pre>'; print_r($quote);

                        $address->setGrandTotal($address->getGrandTotal() + $address->getFeeAmount());
                        //echo '<pre>'; print_r($address);
                        $address->setBaseGrandTotal($address->getBaseGrandTotal() + $address->getBaseFeeAmount());
                        //$address->getGrandTotal();
                    //echo '<pre>'; print_r($address);
                    echo  Mage::getSingleton('checkout/cart')->getQuote()->getGrandTotal();

This is working on checkout and cart page to update the grandtotal. Hope this will help you and you find a correct solution.

Magento – Custom sales order report NOT matching Magento’s sales order report

I believe you're not getting the same number of results returned because you're adjusting your time ($from_date, $to_date) to GMT.

As far as I can tell, Magento does not adjust the "from" and "to" dates to GMT when it queries the database for the reports. It really should, but sometimes Magento just lacks consistency. See Mage_Adminhtml_Block_Report_Grid_Abstract. I've inspected the collection's query, and it literally uses the inputs given.

i.e. WHERE (period >= '2014-02-01') AND (period <= '2016-03-26') (period is constructed somewhere in the process, but dates are not converted to GMT).

Correct me I'm wrong, of course!

Best Answer

Related Solutions

Magento – Calculate grand total on order

Magento – Custom sales order report NOT matching Magento’s sales order report

Related Topic