Given a MaxRadiusInKm, filter the reference of a model and get All records in the request radius by longitude and latitude.

findKmInRadiusWithAtk4.php

                        $radiusMaxInKm = (int) $filterRequest['km'][0] ?? $filterRequest['km'] ?? 0;

                        $IDCitta = (int) $value;
                        $mCitta = new Citta($this->app->db);
                        $mCitta->tryLoad($IDCitta);

                        $earthRadiusKilometers = 6378.140;
                        $latitude = $mCitta->get('Latitude');
                        $longitude = $mCitta->get('Longitude');

                        $refFieldLatitude = $modelGridCandidati->refLink('domicilio_citta')->action('field',['Latitude']);
                        $refFieldLongitude = $modelGridCandidati->refLink('domicilio_citta')->action('field',['Longitude']);

                        $modelGridCandidati->addCondition(
                            new Expression(
                            '
                                [earthradius]
                                *
                                acos(
                                    cos(
                                        radians(
                                            [rqst_latitude]
                                        )
                                    )
                                    *
                                    cos(
                                        radians(
                                            [ref_latitude]
                                        )
                                    )
                                    *
                                    cos(
                                        radians(
                                            [ref_longitude]
                                        )
                                        - radians(
                                            [rqst_longitude]
                                        )
                                    )
                                    +
                                    sin(
                                        radians(
                                            [rqst_latitude]
                                        )
                                    )
                                    *
                                    sin(
                                        radians(
                                            [ref_latitude]
                                        )
                                    )
                                )',[
                                'earthradius' => $earthRadiusKilometers,
                                'rqst_latitude' => $latitude,
                                'rqst_longitude' => $longitude,
                                'ref_latitude' => $refFieldLatitude,
                                'ref_longitude'=> $refFieldLongitude

                            ]),'<=',$radiusMaxInKm);