Rails erb循环外无法访问变量，如何计算总收益列总计？

我来给你几个实用的解决方案，帮你搞定「Total Earned」列的总计计算问题：

方案1：把计算逻辑移到控制器，提前准备好数据和总计 #

这是最符合Rails MVC原则的做法，把所有计算逻辑放在控制器里，模板只负责渲染数据。

在你的控制器动作里，遍历affiliate_sales时，为每个销售记录计算出需要的数值，同时累加得到总计值，最后把这些数据存到实例变量中：

def your_action_name
  @affiliate_sales = AffiliateSale.all # 替换成你实际的查询逻辑
  @sales_with_totals = []
  @total_earned = 0

  @affiliate_sales.each do |sale|
    # 这里替换成你实际的active_payments计算逻辑
    active_payments = sale.subscriptions.active.sum(&:amount)
    # 替换成你实际的canceled_payments计算逻辑
    canceled_payments = sale.subscriptions.canceled.sum(&:amount)
    # 每行的总收益，按你的规则计算
    row_total = active_payments + canceled_payments

    @total_earned += row_total
    @sales_with_totals << {
      sale: sale,
      active_payments: active_payments,
      canceled_payments: canceled_payments,
      row_total: row_total
    }
  end
end

然后在ERB模板里，直接使用这些准备好的变量：

<table>
  <thead>
    <tr>
      <th>订阅信息</th>
      <th>Active Payments</th>
      <th>Canceled Payments</th>
      <th>Total Earned</th>
    </tr>
  </thead>
  <tbody>
    <% @sales_with_totals.each do |item| %>
      <tr>
        <td><%= item[:sale].subscription.name %></td>
        <td><%= number_to_currency(item[:active_payments]) %></td>
        <td><%= number_to_currency(item[:canceled_payments]) %></td>
        <td><%= number_to_currency(item[:row_total]) %></td>
      </tr>
    <% end %>
  </tbody>
  <tfoot>
    <tr>
      <td colspan="3"><strong>总计</strong></td>
      <td><strong><%= number_to_currency(@total_earned) %></strong></td>
    </tr>
  </tfoot>
</table>

方案2：在ERB模板中用实例变量直接累加 #

如果不想改动太多控制器代码，也可以在模板里初始化一个实例变量，循环时累加每行的总收益：

<% @total_earned = 0 %>
<table>
  <!-- 表头部分 -->
  <thead>
    <tr>
      <th>订阅信息</th>
      <th>Active Payments</th>
      <th>Canceled Payments</th>
      <th>Total Earned</th>
    </tr>
  </thead>
  <tbody>
    <% @affiliate_sales.each do |sale| %>
      <% active_payments = sale.subscriptions.active.sum(&:amount) %>
      <% canceled_payments = sale.subscriptions.canceled.sum(&:amount) %>
      <% row_total = active_payments + canceled_payments %>
      <% @total_earned += row_total %> <!-- 累加每行的总收益 -->

      <tr>
        <td><%= sale.subscription.name %></td>
        <td><%= number_to_currency(active_payments) %></td>
        <td><%= number_to_currency(canceled_payments) %></td>
        <td><%= number_to_currency(row_total) %></td>
      </tr>
    <% end %>
  </tbody>
  <tfoot>
    <tr>
      <td colspan="3"><strong>总计</strong></td>
      <td><strong><%= number_to_currency(@total_earned) %></strong></td>
    </tr>
  </tfoot>
</table>

⚠️ 注意：这种方法虽然简单，但把计算逻辑放在了视图层，违反了MVC的职责分离原则，适合逻辑简单的场景，复杂项目不推荐。

方案3：用Presenter模式封装计算逻辑 #

如果你的计算逻辑比较复杂，或者需要复用，推荐使用Presenter模式来封装这些逻辑，让控制器和视图更干净。

首先创建一个Presenter类：

# app/presenters/affiliate_sale_presenter.rb
class AffiliateSalePresenter
  attr_reader :sale

  def initialize(sale)
    @sale = sale
  end

  # 计算active payments
  def active_payments
    @active_payments ||= sale.subscriptions.active.sum(&:amount)
  end

  # 计算canceled payments
  def canceled_payments
    @canceled_payments ||= sale.subscriptions.canceled.sum(&:amount)
  end

  # 计算该行的总收益
  def row_total
    active_payments + canceled_payments
  end

  # 类方法：计算所有销售记录的总收益
  def self.grand_total(sales)
    sales.sum { |sale| new(sale).row_total }
  end
end

然后在控制器里初始化Presenter实例和总计值：

def your_action_name
  @affiliate_sales = AffiliateSale.all
  @sale_presenters = @affiliate_sales.map { |sale| AffiliateSalePresenter.new(sale) }
  @total_earned = AffiliateSalePresenter.grand_total(@affiliate_sales)
end

最后在模板里使用Presenter：

<table>
  <!-- 表头 -->
  <thead>
    <tr>
      <th>订阅信息</th>
      <th>Active Payments</th>
      <th>Canceled Payments</th>
      <th>Total Earned</th>
    </tr>
  </thead>
  <tbody>
    <% @sale_presenters.each do |presenter| %>
      <tr>
        <td><%= presenter.sale.subscription.name %></td>
        <td><%= number_to_currency(presenter.active_payments) %></td>
        <td><%= number_to_currency(presenter.canceled_payments) %></td>
        <td><%= number_to_currency(presenter.row_total) %></td>
      </tr>
    <% end %>
  </tbody>
  <tfoot>
    <tr>
      <td colspan="3"><strong>总计</strong></td>
      <td><strong><%= number_to_currency(@total_earned) %></strong></td>
    </tr>
  </tfoot>
</table>

这种方法的优势是逻辑封装在Presenter里，便于测试和复用，也符合MVC的设计理念。

内容的提问来源于stack exchange，提问作者Mark Rybarczyk