Need Latitude and Longitude on Order Page

FezanAsif

Hi,

I am trying to see customer Latitude and Longitude on the admin order page to see customer location on a google map with one click.
For that purpose I am going add below code:
https://www.google.com/maps/search/?api=1&query=31.00000,74.00000

in this code, I need the customer's Lat and Lng from the order table.
When I try to retrieve it from $order->location -> lat it gives me execption.

Where I am wrong and how I could retrieve my desire values?

FezanAsif

The location is saved in json format that is why I am unable to get this in model format. How can I serialize it?

FezanAsif

Issue resolved need to use json_decode($order->location);
thanks.

NikhilJain

FezanAsif Can you help with the code I want to implement the same

JusanSG

Useful for delivery manager to check if customer declared exactly or just typing something wrong in their address.

FezanAsif

JusanSG Also this will help the delivery manager that which rider is suitable for this delivery.

FezanAsif

Sure.

open this file:
app/Http/Controllers/Datatables/OrdersDatatable.php
add this code right before you want to show your location button:
$location = json_decode($order->location);

then add this code where you want to show your location button:
<a target="_blank" href= "https://www.google.com/maps/search/?api=1&query=' . $location -> lat .','. $location -> lng .'"> - Location</a>

NikhilJain

FezanAsif Thank you so much

FezanAsif

NikhilJain Love from Pakistan 😄

NikhilJain

FezanAsif Love from India 😀

NikhilJain

Add in viewOrder blade

<a target="_blank" href= "https://www.google.com/maps/search/?api=1&query={{json_decode($order->location)->lat}},{{json_decode($order->location)->lng}}" class="btn btn-sm btn-success my-2 mx-2" style="color: #fff; border: 1px solid #ccc; float: right;border-radius: 8px; "><i class="icon-location3"></i> Location</a>

Before Print Bill button and you are good to go