回答編集履歴
2
あ
test
CHANGED
|
@@ -12,7 +12,7 @@
|
|
|
12
12
|
|
|
13
13
|
@q.game_date_lteq = Time.now.strftime("%Y-12-31") if @q.game_date_lteq.nil?
|
|
14
14
|
|
|
15
|
-
@games = @q.result(distinct: true).group(:
|
|
15
|
+
@games = @q.result(distinct: true).group(:member_id).pluck("members.name,count(games.member_id)")#SQLの段階で集計しときます。
|
|
16
16
|
|
|
17
17
|
@games_hash=Hash[*@games.flatten]#hash化
|
|
18
18
|
|
1
a
test
CHANGED
|
@@ -6,13 +6,13 @@
|
|
|
6
6
|
|
|
7
7
|
#ransackで日付の期間で抽出
|
|
8
8
|
|
|
9
|
-
@q = Game.ransack(params[:q])
|
|
9
|
+
@q = Game.joins(:member).references(:member).ransack(params[:q])
|
|
10
10
|
|
|
11
11
|
@q.game_date_gteq = Time.now.strftime("%Y-01-01") if @q.game_date_gteq.nil?
|
|
12
12
|
|
|
13
13
|
@q.game_date_lteq = Time.now.strftime("%Y-12-31") if @q.game_date_lteq.nil?
|
|
14
14
|
|
|
15
|
-
@games = @q.result(distinct: true).group(:参加者).pluck("
|
|
15
|
+
@games = @q.result(distinct: true).group(:参加者).pluck("members.name,sum(games.参加人数)")#SQLの段階で集計しときます。
|
|
16
16
|
|
|
17
17
|
@games_hash=Hash[*@games.flatten]#hash化
|
|
18
18
|
|