Laravel, How to get array of session in controller and compare with model

Question

I have session Array of two variables, id and distance, I want to show all stores from DB where ids in session equal to ids in stores also I want to show the distance of every store with store details, please note that Im new to laravel, Thank you

dd(session('storeinfo'));

 array:252 [▼
    0 => array:2 [▼
      "id" => 76
     "distance" => "3.23"
          ]
    1 => array:2 [▼
    "id" => 77
    "distance" => "7.09"
]

Store in DB:

 $stores = Storeinfo::all();

In order to get a good answer to your question, please include something you've already tried even if it was completely off. — jimboweb
– jimboweb, Commented Jul 30, 2019 at 16:17

N69S · Accepted Answer · 2019-07-31 10:25:03Z

1

$stores = [];
$storeInfos = session('storeinfo');
usort($storeInfos, function($a, $b) {
    if (!isset($a['distance'])) {return -1;}
    if (!isset($b['distance'])) {return 1;}
    if ($a['distance'] == $b['distance']) {
        return 0;
    }
    return ($a['distance'] < $b['distance']) ? -1 : 1;
});
foreach ($storeInfos as $storeInfo) {
    $store = Store::find($storeInfo['id']);
    if ($store) {
        $store->distance = $storeInfo['distance'];
        $stores[] = $store;
    }
}
return $stores;

edited Jul 31, 2019 at 10:25

answered Jul 30, 2019 at 15:31

N69S

17.3k4 gold badges26 silver badges41 bronze badges

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

3 Comments

user11656854 Over a year ago

this is great, but How can I sort the result by distance?

user11656854 Over a year ago

Thank you very much, please help me how to sort by distance and make results in pagination

N69S Over a year ago

@AsH i've edited my answer to add a sorting by distance

Tharaka Dilshan · Accepted Answer · 2019-07-30 18:25:42Z

0

You can use whereIn() function in query builder to filter using arrray of data.

$stores = StoreInfo::whereIn(
              'id', 
              collect(session('storeinfo'))->map->id->toArray()
          )
          ->get()
          ->map(function($storeDetail) {
              //find the matching storeinfo from session.
              $storeInfo = collect(session('storeinfo'))
                               ->firstWhere('id', $storeDetail->id);
              // set distance
              return $storeDetail->distance = $storeInfo['distance'];
          });

edited Jul 30, 2019 at 18:25

answered Jul 30, 2019 at 15:42

Tharaka Dilshan

4,4993 gold badges17 silver badges29 bronze badges

1 Comment

user11656854 Over a year ago

Argument 1 passed to Illuminate\Support\Collection::map() must be callable, string given, called in

Collectives™ on Stack Overflow

Laravel, How to get array of session in controller and compare with model

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related