<% @house = @fp_valueHouse %> <% @competenza = @fp_valueDate%> <% if defined? daterange %> <% else %> <% daterange = 'month' %> <% end %> <% @house_accounts = HouseAccount.all.ordered_by_name %> Piano dei conti <%= Date.today.year %>
<%= @house.descrizione %>
<% if @fp_nilDate or (daterange == 'year') %> Al <%= Date.today.to_dmy %> <% base_house_pn_query = HousePn.where(house_id: @house.id) %> <% base_house_adac_query = HouseAdac.where(house_id: @house.id) %> <% else %> Di <%= daterange_name(@competenza) %> <% base_house_pn_query = HousePn.where(house_id: @house.id, competenza: @competenza) %> <% base_house_adac_query = HouseAdac.where(house_id: @house.id, competenza: @competenza) %> <% end %> <% house_pns_totale_anno = 0.0 %> <% house_adacs_totale_anno = 0.0 %> <% @house_accounts.each do |house_account| %> <% @house_crbs = HouseCrb.where(house_account_id: house_account.id).ordered_by_name %> <% @house_crbs.each do |house_crb| %> <% house_pns_totale_mese = base_house_pn_query.where(house_crb_id: house_crb.id).sum(:importo) %> <% house_adacs_totale_mese = base_house_adac_query.where(house_crb_id: house_crb.id).sum(:importo) %> <% if house_pns_totale_mese.is_not_zero? or house_adacs_totale_mese.is_not_zero? %> <% house_pns_totale_anno += house_pns_totale_mese %> <% house_adacs_totale_anno += house_adacs_totale_mese %> <% end %> <% end %> <% end %>

<%= HouseAccount.label(1) %>	<%= HouseCrb.label(1) %>	<%= HousePn.label(1) %>	<%= HouseAdac.label(1) %>
<%= house_account.format_name %>	<%= house_crb.format_name %>	<%= money_format(house_pns_totale_mese) %>	<%= money_format(house_adacs_totale_mese) %>
totali:		<%= money_format(house_pns_totale_anno) %>	<%= money_format(house_adacs_totale_anno) %>