News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Admin Order list details

Started by AH, November 06, 2013, 19:17:32 PM

Previous topic - Next topic

AH

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]
Regards
A

Joomla 4.4.5
php 8.1

lindapowers

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.

AH

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  :)
Regards
A

Joomla 4.4.5
php 8.1

AH

Milbo/Alatak

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

Joomla 4.4.5
php 8.1