给定一个返回 [1, 1] [2, 3], [5,1] 的查询，如何使用该结果？

Question

给定：

class ThreadParticipations
  scope :unread, lambda{ |user| where(:user_id => user.id, :read => false) }
end

ThreadParticipations
  .unread(current_user)
  .includes(:thread => :project)
  .group('projects.id')
  .count('threads.id')

哪些输出：

 => { 1 => 15, 3 => 10 }

我如何使用该结果来更新我的列表。给出结果集1& 3 是project_ids，我如何迭代该结果来更新列表，例如：

# iterates over @projects
<div>
 <li>Project_id 1, unread count = 15</li>
 <li>Project_id 2, unread count = 0</li>
 <li>Project_id 3, unread count = 10</li>
 <li>Project_id 4, unread count = 0</li>
 <li>Project_id 5, unread count = 0</li>
</div>

谢谢

Answer 1

不确定我是否理解，您只是想迭代哈希来输出 html？

<ul>
    <% { 1 => 15, 3 => 10 }.each_pair do |k,v| %>
        <li>Project_id <%= k %>, unread count = <%= v%></li>
    <% end %>
</ul>

编辑：就这样？

<ul>
    <% [[1,1], [2, 3], [3, 15]].each do |project_id, unread_count| %>
        <li>Project_id <%= project_id %>, unread count = <%= unread_count %></li>
    <% end %>
</ul>

Answer 2

首先：您的 HTML 无效。 li 元素位于 ul 或 ol 内部，而不是 div 内部。您要查找的代码是：

<ul>
  <% hash.each do |project_id, unread_count| %>
    <li>Project_id <%= project_id %>, unread count = <%= unread_count %></li>
  <% end %>
</ul>