Laravel use function in query

Question

In controller get data from db like this, I want to pass whole of $request to another function in this controller to get price it calculating price based of many things from $request:

$user = Auth::user();
$query = Post::query();

$query
->where('province', '=', $user->province)
->where('city', '=', $user->city);

$customers = $query->get();
$customers['calculator'] = $this->calculator($request); // call function

my problem is it return like this:

{
  "0": {
    "id": 1,
    "hash": "RqH29tkfm1dwGrXp4ZCV",
  },
  "1": {
    "id": 3,
    "hash": "RqH29tkfm1dwGsXp4ZCV",
  },
  "calculator": {
    "price": 1
  }
}

But I need to use that function for each data, and result should be like this:

{
  "0": {
    "id": 1,
    "hash": "RqH29tkfm1dwGrXp4ZCV",
    "calculator": {
      "price": 1
    }
  },
  "1": {
    "id": 3,
    "hash": "RqH29tkfm1dwGsXp4ZCV",
    "calculator": {
      "price": 1
    }
  }
}

If you want calculator assigned to each Customer, you need to use a loop. — Tim Lewis
– Tim Lewis, Commented Dec 12, 2019 at 18:39

Uroš Anđelić · Accepted Answer · 2019-12-12 18:39:13Z

1

What you want is to set a calculator key for each item in the $customers collection. So you need to loop over it:

foreach ($customers as $customer) {
    $customer->calculator = $this->calculator($request);
}

Notice that since the $customer is a Model you should set the calculator as a property. Internally it will be set to the attributes array.

answered Dec 12, 2019 at 18:39

Uroš Anđelić

1,1748 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Laravel use function in query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related