VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Coding Central => Topic started by: AH on November 06, 2013, 19:17:32 PM

Title: Admin Order list details
Post by: AH on November 06, 2013, 19:17:32 PM
When reviewing the order list in admin -  the layout does not make available some details that might improve the usability.

I wanted to be able to show the Customer note, Zip, City a Phone number without bouncing around or opening the print view.  So I added the fields to the model.  I think it would be useful to include this in the future.

/**
* Select the products to list on the product list page
* @param $uid integer Optional user ID to get the orders of a single user
* @param $_ignorePagination boolean If true, ignore the Joomla pagination (for embedded use, default false)
*/
public function getOrdersList($uid = 0, $noLimit = false)
{
// vmdebug('getOrdersList');
$this->_noLimit = $noLimit;
// quorvia added phone, zip, city
        $select = " o.*, CONCAT_WS(' ',u.first_name,u.middle_name,u.last_name) AS order_name "
.',u.email as order_email,pm.payment_name AS payment_method,u.phone_1 AS q_phone, u.zip AS q_zip, u.city AS q_city';
$from = $this->getOrdersListQuery();
/* $_filter = array();
if ($uid > 0) {
$_filter[] = ('u.virtuemart_user_id = ' . (int)$uid);
}*/


It is straight forward then to adjust the default list view or create and template override

Sorting by name takes too long  (as a search is prefferable for us) so we removed the search from the name column same for e-mail
then combined the columns as shown below.





[attachment cleanup by admin]
Title: Re: Admin Order list details
Post by: lindapowers on November 25, 2013, 23:20:44 PM
This looks interesting. I agree that seeing some of that info at order list would save much time. Ideally a popup on mouse over would be great. But well asking is free.
Title: Re: Admin Order list details
Post by: AH on November 26, 2013, 00:57:08 AM
lindapowers

I steered away from mouse over as it is, from our usability perspective, better  to have it displayed

I am glad you found it interesting though  :)
Title: Re: Admin Order list details
Post by: AH on January 06, 2014, 11:23:29 AM
Milbo/Alatak

Can we updtate this is the next release or VM2.1 ??