Level 63
That's strange that you obtain two different results (about the order) with the same controller.
You have necessarily something that reorder your results.
Can you explain and show the differences and in which precise conditions ?
Jul 17, 2022
20
Level 10
I don't want alphabet sorting when retrieving data from ajax
Hi all,
I don't know how to solve this, but in general, I have this chunk of code
$tournaments = Tournament::select('name', 'city', 'date', \DB::raw(sprintf(
'(6371 * acos(cos(radians(%1$.7f)) * cos(radians(latitude)) * cos(radians(longitude) - radians(%2$.7f)) + sin(radians(%1$.7f)) * sin(radians(latitude)))) AS distance',
$latitude,
$longitude
)))
->having('distance', '<', request('distance') ?? self::DEFAULT_DISTANCE)
->orderBy('distance', 'asc')
->get()
->groupBy('city');
return $tournaments;
Which returns grouped cities, but the problem is when I try to get this endpoint directly it gives me sorted data like this
{
"Cakovec": [
{ "distance": 12.906106587461018, },
{ "distance": 12.906106587461018,}
],
"Novi Marof": [
{ "distance": 16.303102724639714,}
],
"Sv Martin": [
{ "distance": 23.9061609409841,}
],
"Split": [
{"distance": 311.2904383884394,}
]
}
Which is fine, because I'm sorting this first by distance and then grouping by city, but the problem is when I try to fetch the data with http request, then 'Split' is not the last result even tough this city should be the last because of distance. Seems like browser/js or something is sorting groupby alphabetically...
Any ideas?
Level 10
@vincent15000 very strange, I have basic http request with angular
getTournaments(radius: number): Observable<Tournament[]> {
const params = new HttpParams()
.set('api_token', this.token)
.set('distance', radius);
return this.http.get<Tournament[]>(this.url, {params})
.pipe(
catchError(this.handleError<Tournament[]>('tournaments', []))
)
}
Check this out, first line (before expanding) is ok, but when I expand sorting is not okay
1 like
Level 63
@sasafister That's effectively very strange. Can you check your query directly in the controller via a web route and display the result of the query with dd() ?
Level 10
I did, that's fine :)
{
"Cakovec": [
{ "distance": 12.906106587461018, },
{ "distance": 12.906106587461018,}
],
"Novi Marof": [
{ "distance": 16.303102724639714,}
],
"Sv Martin": [
{ "distance": 23.9061609409841,}
],
"Split": [
{"distance": 311.2904383884394,}
]
}
1 like
Level 63
@sasafister Here you have the real result that is sent back from the API.
Now you should check what angular is doing with your datas.
Level 10
@vincent15000 Yes, but it's weird, why would this happen :)
1 like
Level 63
@sasafister I don't know angular, perhaps you have, while retrieving the data, an automatic reordering.
Level 10
1 like
Level 63
@sasafister Is your routes inside the web.php file or the api.php file ?
Laravel returns automatically an array if it's an API route.
Level 10
@vincent15000 in api, but if I catch that url, it returns correct order
1 like
Level 63
@sasafister The only place where you don't have the wanted order is in Angular ?
Level 10
@vincent15000 I want it everywhere like the direct api returns, that's why I grouped it in Laravel
1 like
Level 63
@sasafister Yes but you necessarily have something that disturbs the initial order. To find where it occurs, you can add some console.log() at different places in the code.
Level 10
I found a workaround, this is common issue, here how you can keep sorting in Angular
https://github.com/angular/angular/issues/31420#issuecomment-530561112
I just removed asIsOrder props, and index because I don't need it. It seems like working now
1 like
Level 63
@sasafister I told you that it was something to so with angular ;).
Level 10
@vincent15000 yea, I think that this can be solved with arrays and not object, but it's too much workarounds, I found this one very easy to implement.. Thnx for your assistance
1 like
Level 63
@sasafister Are you sure that you have the best answer ? ;)
1 like
Level 10
@vincent15000 it works :)
1 like
Level 63
@sasafister As you want ...
1 like
Level 39
Regarding the Best Answer I invite you to read this link
https://laracasts.com/discuss/channels/general-discussion/guidelines-for-posting-on-laracastscom
Please or to participate in this conversation.