Showing billing address in order listing

-- HikaShop version -- : 4.6.1
-- Joomla version -- : 4.2.3
-- PHP version -- : 8.0.22
-- Browser(s) name and version -- : EDGE
-- Error-message(debug-mod must be tuned on) -- : None

Hello,

So far i have managed to show the billing addresses on the order listing, that was very simple, see added screenshot.
We only need company names and cities. I've used the following to show the billing addresses.
<?php echo $row->address_company; ?> <?php echo $row->address_city; ?>

I've been fighting to show shipping addresses on our order listing, tried a couple of database values that i could find from our sql.
I can't seem to let the shipping addresses to show up.

What am i doing wrong? What did i not see?

Nicolas that is exactly what we needed. I addes address_company to the code

$addressClass = hikashop_get('class.address');
$shippingAddress = $addressClass->get($row->order_shipping_address_id);
echo $shippingAddress->address_city;
echo $shippingAddress->address_company;

We use the webshop for internal use only. Employees order components with us on a cost center(billing address) and we send them to a sattelite company(shipping address).

That is why we need both to be visible.

Only thing is that the filter does not seem to work properly anymore. Not all values will show up when filtered.

Strange. When i try to look up certain words, only a couple of results come up instead of everything with those words.


For example see screenshots.
There are a lot of values with casino.
But when i enter the word in the filter, it will only show a few.

As far as i know there has not been made changes to a filter. As i do not know why i should change the one on the order listing and i neither would know at this moment where i could change that.

Works like a charm. Too bad the search on delivery address is not possible, but this already is a better way to work for us.

Hi Nicolas,

I've encountered another problem. Somehow when a employee selects pickup at office it shows another delivery address, see screenshot.

Somehow it does not change the data on the order listing. It does change the data in the order itself.

Could it be because of the code you have sent me before? Shouldn't there be a "if" somewhere which will show the shop address when pickup is selected? I looked into the employees account and the standard delivery address is choosen on the order listing, even when pickup is selected.

$addressClass = hikashop_get('class.address');
$shippingAddress = $addressClass->get($row->order_shipping_address_id);
echo $shippingAddress->address_city;
echo $shippingAddress->address_company;

This works like a charm. Thank you!
We tweaked hikashop quite a bit to meet to our wishes as its only for internal use.

Employees order products for their service vans and the need cost centers(like billing addresses) but send most products to a sattelite or pick it up at our main office.
The Netherlands is not a huge country, in 3 hours you are able to go from one border to another.

I tweaked your code a little because the complete address came up on the order listing
and when i edited "main office+city" in the override shipping address in the shipping method it would not show up nicely in our invoices.

The code now is

   <?php
                      if(!empty($row->order_shipping_method)) {
			$currentShipping = hikashop_import('hikashopshipping', $row->order_shipping_method);
			if(method_exists($currentShipping, 'getShippingAddress')) {
				$override = $currentShipping->getShippingAddress($row->order_shipping_id, $row);
				if($override !== false) {
					$row->override_shipping_address = $override;
				}
			}
		}
		if(!empty($row->override_shipping_address)) {
			[b]echo 'Company main office City';[/b]
		} else {
			$addressClass = hikashop_get('class.address');
			$shippingAddress = $addressClass->get($row->order_shipping_address_id);
			echo $shippingAddress->address_company;
			echo ' ';
			echo $shippingAddress->address_city;

		}
                      ?>