Laravel query by custom attribute

Question

I have a question pertaining querying an eloquent model using a custom attribute.

I have a class/model Item and i have created an attribute:

  function getWeeklySalesCountAttribute()
  {
     return rand(3, 1000); //real logic is in db
  }

So in my controller I want to pick items that have the highest weekly sales first and paginate them

    $items = Item::where(function($item){
        //find the items with highest weekly sales
    })->paginate(10);

How do i achieve that given I manage to pull the $item->weekly_sales_count attribute

I am not sure though. but so far I guess, is class 'item' your eloquent class or normal classs? — Atik Hashmee
– Atik Hashmee, Commented Apr 8, 2019 at 9:10

Manuel Robles · Accepted Answer · 2019-04-08 09:25:36Z

2

You can't use Eloquent, you need use a filter.

 $result = Model::get()->filter(function($item) {
    return $item->weekly_sales_count > 3;
 });

answered Apr 8, 2019 at 9:25

Manuel Robles

1216 bronze badges

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

1 Comment

Flash Over a year ago

thanks, let me try it but the mission is to filter the ones with the highest sales and paginate them, so whats the proper way of using filter. If you can link me to where filter is explained i will be so happy

Collectives™ on Stack Overflow

Laravel query by custom attribute

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related