I have upgraded my magento website from 1.7 to 1.9 and now on dashboard page i don't see name of customers in last 5 orders section, how ever i have tried one fix , which on use shows the customer name but the link on the orders change and it leads to an order that does not exists ..
below is the fix that i tried
but it changes the link too which does not work..
below is the solution that i tried
I have coded for this
In Mage/Adminhtml/Block/Dashboard/Orders/Grid.php about line '51' replace "->joinCustomerName('customer')" with ->joinCustomerBName('customer')
and in Mage/Reports/Model/Resource/Order/Collection.php
add a function
public function joinCustomerBName($alias = 'name')
{
$fields = array('t2.firstname', 't2.lastname');
$fieldConcat = $this->getConnection()->getConcatSql($fields, ' ');
$this->getSelect()
->join(array('t2' => 'sales_flat_order_address'),'main_table.billing_address_id = t2.entity_id')->columns(array($alias => $fieldConcat));
return $this;
}
Now i need a solution which does not changes the link and only displays the name for guest customers too, any help would be appreciated.
