Currently, when we login to magento admin, it shows the order amount from last 24 hours by default. Is there a way to show Current Date (today) order amount as default?
A detailed solution will be much appreciated.
Asked
Active
Viewed 1,669 times
0
-
What is the difference between last 24 hs and current date for you? – mbalparda Aug 17 '14 at 15:15
-
Have edit the question. Todays sales are not equal for sales from last 24 hours – Amasty Aug 17 '14 at 15:26
1 Answers
0
Copy app/code/core/Mage/Adminhtml/Block/Dashboard/Orders/Grid.php
to
app/code/local/Mage/Adminhtml/Block/Dashboard/Orders/Grid.php
goto Mage_Adminhtml_Block_Dashboard_Orders_Grid and goto _prepareCollection...
change: from
$collection = Mage::getResourceModel('reports/order_collection')
->addItemCountExpr()
->joinCustomerName('customer')
->orderByCreatedAt();
to
$collection = Mage::getResourceModel('reports/order_collection')
->addItemCountExpr()
->joinCustomerName('customer');
$todayStartOfDayDate = Mage::app()->getLocale()->date()
->setTime('00:00:00')
->toString(Varien_Date::DATETIME_INTERNAL_FORMAT);
$todayEndOfDayDate = Mage::app()->getLocale()->date()
->setTime('23:59:59')
->toString(Varien_Date::DATETIME_INTERNAL_FORMAT);
$collection->addAttributeToFilter('created_at', array(
'from' => $todayStartOfDayDate,
'to' => $todayEndOfDayDate,
));
Amit Bera
- 77,456
- 20
- 123
- 237
-
Hi Amit Bera, i tried your solution but still does not work. do you know any reason? i flushed cache as well. – Jason Aug 17 '14 at 18:19
-
-
^ No one changed core code here. It was copied to the local namespace. Please pay attention. – Si Griffiths Aug 17 '14 at 20:15
-
-
i am sorry but the solution is NOT working. Can someone else provide an solution? – Jason Aug 18 '14 at 01:03
-
Have a look at the duplicate: https://magento.stackexchange.com/questions/31023/magento-dashboard-graph – Simon Aug 18 '14 at 06:07