Adding a new filter to vendor orders

-- HikaMarket version -- : 1.7.0
-- Joomla version -- : 3.5.1

Hi,

I want to setup a filter on the vendor order listing page that lets the vendor filter all of the orders by the city in the shipping address and was hoping for some guidance on how to do it.

I'm working on a layout override for HikaMarket - ordermarket / listing.php by taking the existing filter that's used for filtering the delivery method and changing it to filter the shipping address. The section of code I'm looking at is this:

echo $this->paymentType->display('filter_payment', $this->pageInfo->filter->filter_payment, false);

Hmmm..... you're right that could be quite tricky and I don't think I've got the skill level to pull it off.

Would there be any other way of been able to filter the orders by location? I did try putting some code into the order number format to insert the name of the town from the shipping address but that didn't work.

I've been working on the code and I've almost got it working but I'm having trouble calling up data from a SQL table that is used for a custom field. The field stores data in the address table but so far I can only call upon the tables joined in the $order variable. what would be the best way to call up data from the address table?

this is what I'm trying to do

$info = "SELECT address * WHERE order.order_shipping_address_id = address.address_id"

echo $info->address.address_city;

echo $country['{address_city}'];

Thanks for your help. I've been able to run a second SQL query that works in conjunction with the existing SQL query that uses the HikaShop_user and Hikashop_order tables. I now have the page looking the way I want but not working how I want. I still want to set up some kind of filter function using either the grid.sort, search box, or drop-down select.

I understand that there is a SQL query that pairs the HikaShop_user and Hikashop_order tables embedded in the core files that loads all the data for the vendor listing page and I have no intention of changing any core files. I'm only making changes to the page overrides. With this in mind is there anything I can do to add in a filter function of some kind that uses data from a 3rd SQL table?

Well I'll be honest Jerome,

I've never attempted to make a Joomla plugin before and it's going to be quite the learning curve to attempt it but I've never been one to back down from a challenge and this is something I do want to learn. I do know my way around SQL and converting it into JHTML is trickier than it looks but I am getting the hang of it and you have been a huge help with all of your knowledge and advice so I'll give it a shot. If it's ok with you I'd like it if would continue to give me some guidance while I try to build this plugin. If I do succeed I'd be more than happy for you to have a copy of what I've developed to use as part of HikaShop.

So my best option here is to work on a drop down filter plugin but because the query for the listing page is loaded in Hika's core files. This means my best option is to either create a new query in the plugin that joins the order and user table with the address table or find a way to merge the address table with the order and user table thats loaded from Hika's core.

Here is a copy of what I've done so far but how would I get this to work with HikaShop?

$query->select($db->quoteName(array('address_id', 'address_shipping_route')));
$query->from($db->quoteName('#__hikashop_address'));
$query->where($db->quoteName('address_id') . ' = ' .$order->order_shipping_address_id);

echo "<select address_shipping_route=#__hikashop_address value=''>Shipping Route</option>";  
foreach ($dbo->query($sql) as $row){

echo "<option value=$row[1]>$row[address_shipping_route]</option>"; 

}

 echo "</select>";