Custom Query Builder Laravel

Question

Is it possible to create a custom query builder inside a model and return the query? Not a stressing issue but would be helpful.

/* Controller */

public function getOrders() 
{
   $orders = \App\Order::where('is_new', 1)->getFromUserStore();
}

/* Order Model */

public function getFromUserStore() 
{
  if(\Auth::user()->store->id == 1)
  {
      return $this->get();
  }
  else
  {
      return $this->where('status_id', 1)->get();
  }
}

Thanks

It's part of your question per se but I suggest you use the use operator for your namespace to avoid using the backslash all the time. For your controller, your should use App\Order; and for your model use Illuminate\Support\Facades\Auth; — Wistar
– Wistar, Commented May 4, 2016 at 19:35
@Wistar, I typically use use.. is there a performance issue with using the backslash? Thanks for the input. — Bri
– Bri, Commented May 4, 2016 at 20:09
I dont know about performance issue. Also, is the answer working? — Wistar
– Wistar, Commented May 4, 2016 at 20:21

Wistar · Accepted Answer · 2016-05-04 19:30:17Z

4

I believe you are looking for Query Scope

Scopes allow you to define common sets of constraints that you may easily re-use throughout your application.

/* Controller */  
public function getOrders() 
{
   $orders = \App\Order::where('is_new', 1)->getFromUserStore()->get();
}


/* Order Model */
public function scopeGetFromUserStore($query) 
{
  if(\Auth::user()->store->id == 1)
  {
      return $query;
  }
  else
  {
      return $query->where('status_id', 1);
  }
}

answered May 4, 2016 at 19:30

Wistar

3,8005 gold badges48 silver badges71 bronze badges

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

1 Comment

Bri Over a year ago

Exactly what I'm looking for. Thank you.

Collectives™ on Stack Overflow

Custom Query Builder Laravel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related