% @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 %>
<%= HouseAccount.label(1) %> |
<%= HouseCrb.label(1) %> |
<%= HousePn.label(1) %> |
<%= HouseAdac.label(1) %> |
<% 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_account.format_name %> |
<%= house_crb.format_name %> |
<%= money_format(house_pns_totale_mese) %> |
<%= money_format(house_adacs_totale_mese) %> |
<% house_pns_totale_anno += house_pns_totale_mese %>
<% house_adacs_totale_anno += house_adacs_totale_mese %>
<% end %>
<% end %>
<% end %>
totali: |
<%= money_format(house_pns_totale_anno) %> |
<%= money_format(house_adacs_totale_anno) %> |