回答編集履歴
3
追記
test
CHANGED
|
@@ -29,3 +29,11 @@
|
|
|
29
29
|
}
|
|
30
30
|
|
|
31
31
|
```
|
|
32
|
+
|
|
33
|
+
|
|
34
|
+
|
|
35
|
+
`->where('category_id', '=', $request->category_list)` このクエリ条件が正しいなら、`category_list` という命名はまずいと思います。
|
|
36
|
+
|
|
37
|
+
本当にLIST（配列）なら、
|
|
38
|
+
|
|
39
|
+
`->whereIn('category_id', $request->category_list)` であるはず。
|
2
refactor
test
CHANGED
|
@@ -12,7 +12,7 @@
|
|
|
12
12
|
|
|
13
13
|
$records = Record::with('category')
|
|
14
14
|
|
|
15
|
-
->when($request->category_list, function($query) {
|
|
15
|
+
->when($request->category_list, function($query) use ($request) {
|
|
16
16
|
|
|
17
17
|
$query->where('category_id', '=', $request->category_list);
|
|
18
18
|
|
1
refactor
test
CHANGED
|
@@ -14,7 +14,7 @@
|
|
|
14
14
|
|
|
15
15
|
->when($request->category_list, function($query) {
|
|
16
16
|
|
|
17
|
-
$query->where('category_id', '=', $category_list);
|
|
17
|
+
$query->where('category_id', '=', $request->category_list);
|
|
18
18
|
|
|
19
19
|
})
|
|
20
20
|
|
|
@@ -24,13 +24,7 @@
|
|
|
24
24
|
|
|
25
25
|
|
|
26
26
|
|
|
27
|
-
return view('records.index',
|
|
27
|
+
return view('records.index', compact('categories', 'records'));
|
|
28
|
-
|
|
29
|
-
'categories' => $categories,
|
|
30
|
-
|
|
31
|
-
'records' => $records
|
|
32
|
-
|
|
33
|
-
]);
|
|
34
28
|
|
|
35
29
|
}
|
|
36
30
|
|