Author Topic: Admin Order list details  (Read 2553 times)

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3172
  • VirtueMart Version: 3.8.2
Admin Order list details
« 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.

Code: [Select]
/**
* 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 3.9.18
php 7.3

lindapowers

  • Full Member
  • ***
  • Posts: 1335
  • If you're going through hell, keep going.
    • Los Angeles immigration lawyers
  • Skype Name: manu.gonzalez91
  • VirtueMart Version: Latest avi
Re: Admin Order list details
« Reply #1 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.

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3172
  • VirtueMart Version: 3.8.2
Re: Admin Order list details
« Reply #2 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  :)
regards
A

Joomla 3.9.18
php 7.3

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3172
  • VirtueMart Version: 3.8.2
Re: Admin Order list details
« Reply #3 on: January 06, 2014, 11:23:29 am »
Milbo/Alatak

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

Joomla 3.9.18
php 7.3