Laravel Eloquent SELECT sortBy with limit 150 rows

Question

sorry for newbie question. I want to get from table specific columns, order them by date and extract only 150 rows. I tried a lot of combinations. But i dont get the point how should it work:

public function get()
    {
        Excel::create('Bids-' . date("Y/m/d"), function($excel) {
            $excel->sheet('Favourites', function($sheet) {
                $comments = Comment::select('auction_name','bid','lot_date','company', 'model_name_en', 'body','grade_en', 'mileage_num', 'model_year_en', 'start_price_en')->sortBy("lot_date", 'desc')->take(150)->get();
                $sheet->fromModel($comments);
            });
        })->download('xls');
    }

Please, can some one explain me what im doing wrong, why sortBy dont want to work?

Patrik Fuhrmann · Accepted Answer · 2017-06-15 06:14:07Z

2

$comments = Comment::select('auction_name','bid','lot_date','company', 'model_name_en', 'body','grade_en', 'mileage_num', 'model_year_en', 'start_price_en')->orderBy("lot_date", 'desc')->take(150)->get();

notice usage of orderBy() instead of sortBy().

edited Jun 15, 2017 at 6:14

Patrik Fuhrmann

9771 gold badge12 silver badges21 bronze badges

answered Jun 15, 2017 at 1:24

赵加兴

344 bronze badges

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

2 Comments

Ray Over a year ago

Please provide proper formatting and explain your answer

Dmitry Malys Over a year ago

it did work actually, the problem was in that i need to use orderBy in stead of sortBy

Dmitry Malys · Accepted Answer · 2017-06-15 01:25:02Z

0

Actually i find a solution, but i still hardly get it, why it didn't work in before.

This is the solution:

Excel::create('Bids-' . date("Y/m/d"), function($excel) {
            $excel->sheet('Favourites', function($sheet) {

                $comments = Comment::select('auction_name','bid','lot_date','company', 'model_name_en', 'body','grade_en', 'mileage_num', 'model_year_en', 'start_price_en')->take(150)->get();
                $result = $comments->sortByDesc('lot_date');
                $sheet->fromModel($result);
            });
        })->download('xls');

answered Jun 15, 2017 at 1:25

Dmitry Malys

1,3234 gold badges26 silver badges52 bronze badges

Collectives™ on Stack Overflow

Laravel Eloquent SELECT sortBy with limit 150 rows

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related