sfp_api_laravel_diarista/app/Services/DistanceService.php

<?php

namespace App\Services;

use Illuminate\Contracts\Database\Query\Expression;
use Illuminate\Support\Facades\DB;

class DistanceService
{
    private const EARTH_RADIUS_KM = 6371;

    public static function calculate(?float $lat1, ?float $lng1, ?float $lat2, ?float $lng2): ?float
    {
        if ($lat1 === null || $lng1 === null || $lat2 === null || $lng2 === null) {
            return null;
        }

        $lat1Rad = deg2rad($lat1);
        $lat2Rad = deg2rad($lat2);
        $lng1Rad = deg2rad($lng1);
        $lng2Rad = deg2rad($lng2);

        $cosValue = cos($lat1Rad) * cos($lat2Rad) * cos($lng2Rad - $lng1Rad)
            + sin($lat1Rad) * sin($lat2Rad);

        $cosValue = min(1.0, max(-1.0, $cosValue));

        return round(self::EARTH_RADIUS_KM * acos($cosValue), 1);
    }

    public static function sqlExpression(
        ?float $clientLatitude,
        ?float $clientLongitude,
        string $targetLatCol = 'provider_address.latitude',
        string $targetLngCol = 'provider_address.longitude',
        string $alias        = 'distance_km'
    ): Expression {
        if ($clientLatitude === null || $clientLongitude === null) {
            return DB::raw("NULL as {$alias}");
        }

        $formula = self::distanceFormula($clientLatitude, $clientLongitude, $targetLatCol, $targetLngCol);

        return DB::raw("
            CASE
                WHEN {$targetLatCol} IS NOT NULL
                AND {$targetLngCol} IS NOT NULL
                THEN ROUND(({$formula})::numeric, 1)
                ELSE NULL
            END AS {$alias}
        ");
    }

    public static function withinRadiusSqlCondition(
        float $clientLatitude,
        float $clientLongitude,
        float $radiusKm,
        string $targetLatCol = 'provider_address.latitude',
        string $targetLngCol = 'provider_address.longitude',
    ): string {
        $formula = self::distanceFormula($clientLatitude, $clientLongitude, $targetLatCol, $targetLngCol);

        return "
            (
                {$targetLatCol} IS NOT NULL
                AND {$targetLngCol} IS NOT NULL
                AND ROUND(({$formula})::numeric, 1) <= {$radiusKm}
            )
        ";
    }

    private static function distanceFormula(
        float $clientLatitude,
        float $clientLongitude,
        string $targetLatCol,
        string $targetLngCol,
    ): string {
        return "
            " . self::EARTH_RADIUS_KM . " * ACOS(
                LEAST(
                    1,
                    GREATEST(
                        -1,
                        COS(RADIANS({$clientLatitude}))
                            * COS(RADIANS({$targetLatCol}))
                            * COS(
                                RADIANS({$targetLngCol})
                                - RADIANS({$clientLongitude})
                            )
                            + SIN(RADIANS({$clientLatitude}))
                            * SIN(RADIANS({$targetLatCol}))
                    )
                )
            )
        ";
    }
}