Laravel how to return a whole item data with the highest value

Question

How can I return the whole item data, I've used max to get the hieghest value but it only returns the value of the field not the whole item

public static function getTeamLeaders($competitionId, $teamId) {
        if($teamId){
            $ppg = self::where('competitionId', $competitionId)
                    ->where('teamId', $teamId)
                    ->get()
                    ->max('Points');

            $apg = self::where('competitionId', $competitionId)
                    ->where('teamId', $teamId)
                    ->get()
                    ->max('Assists');

            $fgpg = self::where('competitionId', $competitionId)
                    ->where('teamId', $teamId)
                    ->get()
                    ->max('FieldGoals');

            $data = ['ppg' => $ppg, 'apg' => $apg, 'fgpg' => $fgpg];
            return $data;
        }
    }

Result:

array:3 [▼
  "ppg" => 15.18
  "apg" => 3.76
  "fgpg" => 12.04
]

Teun · Accepted Answer · 2017-06-14 06:59:34Z

4

You can use orderBy to sort on the field that you want the max of, and then select the first result.

docs: https://laravel.com/docs/5.4/queries#ordering-grouping-limit-and-offset https://laravel.com/docs/5.4/queries#retrieving-results

$ppg = self::where('competitionId', $competitionId)
                ->where('teamId', $teamId)
                ->orderBy('Points', 'desc')
                ->first();

answered Jun 14, 2017 at 6:59

Teun

9366 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rahul · Accepted Answer · 2017-06-14 07:01:57Z

1

Instead of using max use orderBy

self::where('competitionId', $competitionId)
                    ->where('teamId', $teamId)
                    ->orderBy('Points', 'desc')
                    ->first();

answered Jun 14, 2017 at 7:01

Rahul

2,4802 gold badges12 silver badges17 bronze badges

Comments

AddWeb Solution Pvt Ltd · Accepted Answer · 2017-06-14 07:02:58Z

I think you should update your code like :

public static function getTeamLeaders($competitionId, $teamId) {
        if($teamId){
            $ppg = self::where('competitionId', $competitionId)
                    ->whereRaw('Points = (select max(`Points`) from table_name)')
                    ->where('teamId', $teamId)
                    ->get();


            $apg = self::where('competitionId', $competitionId)
                    ->whereRaw('Assists = (select max(`Assists`) from table_name)')
                    ->where('teamId', $teamId)
                    ->get());

            $fgpg = self::where('competitionId', $competitionId)
                    ->whereRaw('FieldGoals = (select max(`FieldGoals`) from table_name)')
                    ->where('teamId', $teamId)
                    ->get();

            $data = ['ppg' => $ppg, 'apg' => $apg, 'fgpg' => $fgpg];
            return $data;
        }
    }

Hope this work for you!

Sibasankar Bhoi · Accepted Answer · 2017-06-14 11:02:10Z

0

Only change 'max' to 'orderBy'.

$something= self::where('competitionId', $competitionId)
            ->where('teamId', $teamId)
            ->orderBy('Points', 'desc')
            ->first();

answered Jun 14, 2017 at 11:02

Sibasankar Bhoi

5894 silver badges15 bronze badges

Collectives™ on Stack Overflow

Laravel how to return a whole item data with the highest value

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related