$customers_to_update = DB\Customer::where('postcode', $customer->postcode);
// Make API request
Log::msg('Making API request for postcode: "' . $customer->postcode . '"');
$geocode->makeRequest($customer->postcode);
// Get the address from the call
$customer_address = $geocode->getAddressInfo();
// Proceed only if the customer_address is true
if ($customer_address) {
// Update Lat/Long for all the customers where postcode = $customer->postcode
Log::msg('Updating all customers latitude/longitude where postcode: ' . $customer->postcode);
$customers_to_update->update(['latitude' => $customer_address['latitude'], 'longitude' => $customer_address['longitude']]);
// Get the customer distance to all depots
$distances = [];
$sort_distance = [];
foreach (DB\Depot::all() as $depot) {
$d = Helper::getDistanceBetweenCordinates($customer_address['latitude'], $customer_address['longitude'], $depot->latitude, $depot->longitude);
$distances[$depot->id] = ['depot_id' => $depot->id, 'depot' => $depot->depot, 'depot_postcode' => $depot->postcode, 'distance_meters' => $d];
// Create sort array for array_multisort
$sort_distance[$depot->id] = $d;
}
// Sort the distances by shortest distance first
array_multisort($sort_distance, SORT_ASC, $distances);
// Update customer.depot and depot_distance
if ($distances && isset($distances[0])) {
Log::msg('Closest three depots to the customer are: ' . print_r(array_slice($distances, 0, 3), 1));
// Update depot and depot distance for all the customers with the postcode
Log::msg('Updating customers depot to "' . $distances[0]['depot_id'] . '"');
$customers_to_update->update(['depot' => $distances[0]['depot_id'], 'depot_distance' => $distances[0]['distance_meters'], 'no_results' => 0]);
} else {
Log::msg('Invalid $distances array: ' . print_r($distances, 1));
}
