質問編集履歴

3

タイポだったので削除

2022/01/18 14:46

投稿

morioka1206
morioka1206

スコア33

test CHANGED
File without changes
test CHANGED
@@ -92,8 +92,5 @@
92
92
  end
93
93
  ```
94
94
 
95
- これもなぜかSELECT *に
96
- ```ruby
97
- <div class="navi-column"><%= link_to "30人未満 当選", search_prizes_path(@q, :'q[number_of_win_gteq' => '1', :'q[number_of_win_lteq' => '2') %><span class="navi-number-winners">00</span></div>
98
- ```
99
95
 
96
+

2

リンク追加

2022/01/18 11:09

投稿

morioka1206
morioka1206

スコア33

test CHANGED
File without changes
test CHANGED
@@ -92,3 +92,8 @@
92
92
  end
93
93
  ```
94
94
 
95
+ これもなぜかSELECT *に
96
+ ```ruby
97
+ <div class="navi-column"><%= link_to "30人未満 当選", search_prizes_path(@q, :'q[number_of_win_gteq' => '1', :'q[number_of_win_lteq' => '2') %><span class="navi-number-winners">00</span></div>
98
+ ```
99
+

1

コントローラー情報追記

2022/01/18 10:43

投稿

morioka1206
morioka1206

スコア33

test CHANGED
File without changes
test CHANGED
@@ -35,4 +35,60 @@
35
35
  <%= link_to "31日以内", search_prizes_path(@q, :'q[:one_month]') %>
36
36
  ```
37
37
 
38
+ コントローラー
39
+ ```ruby
40
+ class PrizesController < ApplicationController
41
+ before_action :set_q, only: [:index, :search]
38
42
 
43
+ def index
44
+ @prizes = @q.result(distinct: true)
45
+ end
46
+
47
+ def show
48
+ @prize = Prize.find(params[:id])
49
+ end
50
+
51
+ def new
52
+ @categories = Category.all
53
+ @prize_sellers = PrizeSeller.all
54
+ @prize = Prize.new
55
+ end
56
+
57
+ def create
58
+ @prize = Prize.new(prize_params)
59
+ @prize.save
60
+ end
61
+
62
+ def edit
63
+ @prize = Prize.find(params[:id])
64
+ end
65
+
66
+ def update
67
+ @prize = Prize.find(params[:id])
68
+ end
69
+
70
+ def search
71
+
72
+ @results = @q.result
73
+ end
74
+
75
+ def destroy
76
+ prize = Prize.find(params[:id])
77
+ prize.destroy!
78
+ end
79
+
80
+
81
+
82
+ private
83
+ def prize_params
84
+ params.require(:prize).permit(:name, :name_kana, :introduction, :caution, :image, :prefecture_id, :number_of_winner,
85
+ :start_date, :deadline, :category_id, :prize_seller_id)
86
+ end
87
+
88
+ def set_q
89
+ @q = Prize.ransack(params[:q])
90
+
91
+ end
92
+ end
93
+ ```
94
+