Get value with max amount in Laravel

Question

I'm using laravel-page-view-counter to count visits of my products and it's working just fine, what i need to do is to get list of top 10 products by their visits (get 10 products which has largest number of visits).

Here is what I have:

$visits = Product::join('page-visits', function ($join) {
  $join->on('products.id', '=', 'page-visits.visitable_id');
})->get();
$sorted = $visits->sortBy(function ($product, $key) {
  return count($product['visits']);
});

But It return from lowest product visits to highest one (it shows product with 0 visit till product with 100 visits) I need reverse method of that to show (product with 100 visits first).

It's quit difficult to understand, if you use simple raw query it will be easier — Sagar Gautam
– Sagar Gautam, Commented Dec 20, 2017 at 4:16
@SagarGautam $visits I get my products with their visits in ` page-visits` table. $sorted I sorted my $visits query. is it difficult? — mafortis
– mafortis, Commented Dec 20, 2017 at 4:18
Okay, I've added my answer take a moment to try it if any problem feel free to ask :) — Sagar Gautam
– Sagar Gautam, Commented Dec 20, 2017 at 4:26

Sagar Gautam · Accepted Answer · 2017-12-20 04:25:35Z

3

You can do it easily with query builder and some raw queries like this:

$visits = DB::table('products')
            ->join('page-visits','products.id','=','page-visits.visitable_id')
            ->select(DB::raw('count(visitable_id) as count'),'products.*')
            ->groupBy('id')
            ->orderBy('count','desc')
            ->take(10)
            ->get();

I hope you will understand.

answered Dec 20, 2017 at 4:25

Sagar Gautam

9,4099 gold badges62 silver badges95 bronze badges

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

7 Comments

mafortis Over a year ago

Ok its seems working but now i'm not able to get number of visits for each product it give me error of Undefined property: stdClass::$page_visits_formatted before i could get visits like {{$visit->page_visits_formatted}}

Sagar Gautam Over a year ago

you should use {{$visit->count}} instead of {{$visit->page_visits_formatted}} for that since count contains total no of visits in the query i've added above

mafortis Over a year ago

and this count will be formatted or no? formatted is like 1.000 if not is like 1000

Sagar Gautam Over a year ago

@mafortis pardon me, I don't understand what you are saying about formatting :)

mafortis Over a year ago

Bro formatted count will return numbers with . (dot) if number is bigger than 3 digit example 1.000.000 as you see after each 3 digit has one dot.

|

Collectives™ on Stack Overflow

Get value with max amount in Laravel

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related