<%= HouseQec.label(1) %> per <%= HouseCrb.label(1) %>
<% house = House.find(@house_id) %> <%= house.descrizione %>
Competenza <%= daterange_name(@filterdate) %>
<% membri = Person.where(house_id: house.id, attivo: true, economia_separata: false).ordered_in_nucleo %> <% house_qec = HouseQec.search({filterhouse_id: house.id, filterdate: @filterdate}) %> <% house_crbs = HouseCrb.all %> <%# non sono riuscito a formulare una query evoluta, con join(house_crbs).having(count > 0) %> <%# User.select('users.*').joins(:payments).group('users.id').having('count(payments.id) > 4') https://github.com/rails/rails/issues/1515 %> <% house_crb_groups = [] %> <% house_pn_groups = HousePn.all.where(house_id: house.id, competenza: @filterdate).group(:house_crb_id).count %> <% house_pn_groups.each do |group, count| %> <% if count > 0 %> <% house_crb_id = group[0] %> <% house_crb = HouseCrb.find(house_crb_id) %> <% importo = HousePn.all.where(house_id: house.id, competenza: @filterdate, house_crb_id: house_crb.id).sum(:importo) %> <% house_crb_groups << { house_account_id: house_crb.house_account_id, house_crb_id: house_crb.id, house_crb_descr: house_crb.descrizione, count: count, importo: importo} %> <% end %> <% end %> <% house_crbs_grouped = house_crb_groups.group_by {|h| h[:house_account_id]} %> <%# house_pns_existing = house_pns_all.each{|k,_| house_pns_all.delete(k) if k > 3} %> <% house_crbs_grouped.each do |house_account_id, values| %> <% end %> <% house_crbs_grouped.each do |house_account_id, values| %> <% values.each do |value| %> <% end %> <% end %> <% membri.each do |membro| %> <% house_crbs_grouped.each do |house_account_id, values| %> <% values.each do |value| %> <% end %> <% end %> <% end %>

	<%= HouseAccount.find(house_account_id).descrizione %>
	<%= value[:house_crb_descr] %>
<%= membro.dh_person_name %>	<%= value[:importo] %>