<% if srg_qecs_nucleogroup %> <% if @filterdate.fase_storica == CoreExtensions::Date::FASESTORICA2017 %> <%= "RIEPILOGO MIL APS DI #{daterange_name(@filterdate)}" %> <% qec_rows_nucleogroup = (srg_qecs_nucleogroup.to_a).sort_by!{ |r| House.find_by(id: r.house_id).descrizione } %> <% totale_mil = 0 %> <% totale_milfs = 0 %> <% totale_pn_mil = 0 %> <% totale_mila = 0 %> <% totale_milafs = 0 %> <% totale_pn_mila = 0%> <% totale_milu = 0 %> <% totale_milufs = 0 %> <% totale_pn_milu = 0 %> <% qec_rows_nucleogroup.each do |nucleo_qecs| %> <% house = House.find_by(id: nucleo_qecs[:house_id]) %> <% if not house.attivo %> <% next %> <% end %> <% srg_qec_row = SrgQec.aggrega_debito_credito(nucleo_qecs.to_row, @filterdate) %> <% qec_totals = SrgQec.calc_total(srg_qec_row, @filterdate) %> <% monthlyPns = SrgPn.collect_sums_and_map_to_rowQec(competenza: @filterdate, house_id: house.id) %> <% pn_totals = SrgQec.calc_total(monthlyPns, @filterdate) %> <% nucleo_pns_mil = monthlyPns[:mil] %> <% nucleo_pns_mila = monthlyPns[:mila] %> <% nucleo_pns_milu = monthlyPns[:milu] %> <% totale_mil = totale_mil + nucleo_qecs.mil %> <% totale_milfs = totale_milfs + nucleo_qecs.milfs %> <% totale_pn_mil = totale_pn_mil + nucleo_pns_mil %> <% totale_mila = totale_mila + nucleo_qecs.mila %> <% totale_milafs = totale_milafs + nucleo_qecs.milafs %> <% totale_pn_mila = totale_pn_mila + nucleo_pns_mila %> <% totale_milu = totale_milu + nucleo_qecs.milu %> <% totale_milufs = totale_milufs + nucleo_qecs.milufs %> <% totale_pn_milu = totale_pn_milu + nucleo_pns_milu %> <% end %>

	MIL					MIL affitti					MIL utenze
	quota	F.S.	totale	incasso	da incassare	quota	F.S.	totale	incasso	da incassare	quota	F.S.	totale	incasso	da incassare
<%= house.descrizione %>	<%= money_format( nucleo_qecs.mil) %>	<%= money_format( nucleo_qecs.milfs) %>	<%= money_format( nucleo_qecs.mil - nucleo_qecs.milfs) %>	<%= money_format( nucleo_pns_mil) %>	<%= money_format( nucleo_qecs.mil - nucleo_qecs.milfs - nucleo_pns_mil) %>	<%= money_format( nucleo_qecs.mila) %>	<%= money_format( nucleo_qecs.milafs) %>	<%= money_format( nucleo_qecs.mila - nucleo_qecs.milafs) %>	<%= money_format( nucleo_pns_mila) %>	<%= money_format( nucleo_qecs.mila - nucleo_qecs.milafs - nucleo_pns_mila) %>	<%= money_format( nucleo_qecs.milu) %>	<%= money_format( nucleo_qecs.milufs) %>	<%= money_format( nucleo_qecs.milu - nucleo_qecs.milufs) %>	<%= money_format( nucleo_pns_milu) %>	<%= money_format( nucleo_qecs.milu - nucleo_qecs.milufs - nucleo_pns_milu) %>
totali:	<%= money_format( totale_mil ) %>	<%= money_format( totale_milfs ) %>	<%= money_format( totale_mil - totale_milfs ) %>	<%= money_format( totale_pn_mil ) %>	<%= money_format( totale_mil - totale_milfs - totale_pn_mil ) %>	<%= money_format( totale_mila ) %>	<%= money_format( totale_milafs ) %>	<%= money_format( totale_mila - totale_milafs ) %>	<%= money_format( totale_pn_mila ) %>	<%= money_format( totale_mila - totale_milafs - totale_pn_mila ) %>	<%= money_format( totale_milu ) %>	<%= money_format( totale_milufs) %>	<%= money_format( totale_milu - totale_milufs ) %>	<%= money_format( totale_pn_milu ) %>	<%= money_format( totale_milu - totale_milufs - totale_pn_milu ) %>

<% end %> <% if @filterdate.fase_storica == CoreExtensions::Date::FASESTORICA2018 %> <%= "RIEPILOGO MIL ASS DI #{daterange_name(@filterdate)}" %> <% qec_rows_nucleogroup = (srg_qecs_nucleogroup.to_a).sort_by!{ |r| House.find_by(id: r.house_id).descrizione } %> <% totale_milq = 0 %> <% totale_pn_milq = 0 %> <% totale_milri = 0 %> <% totale_pn_milri = 0%> <% qec_rows_nucleogroup.each do |nucleo_qecs| %> <% house = House.find_by(id: nucleo_qecs[:house_id]) %> <% if not house.attivo %> <% next %> <% end %> <% srg_qec_row = SrgQec.aggrega_debito_credito(nucleo_qecs.to_row, @filterdate) %> <% qec_totals = SrgQec.calc_total(srg_qec_row, @filterdate) %> <% monthlyPns = SrgPn.collect_sums_and_map_to_rowQec(competenza: @filterdate, house_id: house.id) %> <% pn_totals = SrgQec.calc_total(monthlyPns, @filterdate) %> <% nucleo_pns_milq = monthlyPns[:milq] %> <% nucleo_pns_milri = monthlyPns[:milri] %> <% totale_milq = totale_milq + nucleo_qecs.milq %> <% totale_pn_milq = totale_pn_milq + nucleo_pns_milq %> <% totale_milri = totale_milri + nucleo_qecs.milri %> <% totale_pn_milri = totale_pn_milri + nucleo_pns_milri %> <% end %>

	MIL quote			MIL rimborsi
	quota	incasso	da incassare	rimborso	incasso	da incassare
<%= house.descrizione %>	<%= money_format( nucleo_qecs.milq) %>	<%= money_format( nucleo_pns_milq) %>	<%= money_format( nucleo_qecs.milq - nucleo_pns_milq) %>	<%= money_format( nucleo_qecs.milri) %>	<%= money_format( nucleo_pns_milri) %>	<%= money_format( nucleo_qecs.milri - nucleo_pns_milri) %>
totali:	<%= money_format( totale_milq ) %>	<%= money_format( totale_pn_milq ) %>	<%= money_format( totale_milq - totale_pn_milq ) %>	<%= money_format( totale_milri ) %>	<%= money_format( totale_pn_milri ) %>	<%= money_format( totale_milri - totale_pn_milri ) %>

<% end %> <% if @filterdate.fase_storica == CoreExtensions::Date::FASESTORICA2019 %> <%= "RIEPILOGO MIL ASS DI #{daterange_name(@filterdate)}" %> <% qec_rows_nucleogroup = (srg_qecs_nucleogroup.to_a).sort_by!{ |r| House.find_by(id: r.house_id).descrizione } %> <% totale_milq = 0 %> <% totale_pn_milq = 0 %> <% totale_milri = 0 %> <% totale_pn_milri = 0%> <% qec_rows_nucleogroup.each do |nucleo_qecs| %> <% house = House.find_by(id: nucleo_qecs[:house_id]) %> <% if not house.attivo %> <% next %> <% end %> <% srg_qec_row = SrgQec.aggrega_debito_credito(nucleo_qecs.to_row, @filterdate) %> <% qec_totals = SrgQec.calc_total(srg_qec_row, @filterdate) %> <% monthlyPns = SrgPn.collect_sums_and_map_to_rowQec(competenza: @filterdate, house_id: house.id) %> <% pn_totals = SrgQec.calc_total(monthlyPns, @filterdate) %> <% nucleo_pns_milq = monthlyPns[:milq] %> <% nucleo_pns_milri = monthlyPns[:milri] %> <% totale_milq = totale_milq + nucleo_qecs.milq %> <% totale_pn_milq = totale_pn_milq + nucleo_pns_milq %> <% totale_milri = totale_milri + nucleo_qecs.milri %> <% totale_pn_milri = totale_pn_milri + nucleo_pns_milri %> <% end %>

	MIL quote			MIL rimborsi
	quota	incasso	da incassare	rimborso	incasso	da incassare
<%= house.descrizione %>	<%= money_format( nucleo_qecs.milq) %>	<%= money_format( nucleo_pns_milq) %>	<%= money_format( nucleo_qecs.milq - nucleo_pns_milq) %>	<%= money_format( nucleo_qecs.milri) %>	<%= money_format( nucleo_pns_milri) %>	<%= money_format( nucleo_qecs.milri - nucleo_pns_milri) %>
totali:	<%= money_format( totale_milq ) %>	<%= money_format( totale_pn_milq ) %>	<%= money_format( totale_milq - totale_pn_milq ) %>	<%= money_format( totale_milri ) %>	<%= money_format( totale_pn_milri ) %>	<%= money_format( totale_milri - totale_pn_milri ) %>

<% end %> <% if @filterdate.fase_storica == CoreExtensions::Date::FASESTORICA2020 %> <%= "RIEPILOGO MIL ASS DI #{daterange_name(@filterdate)}" %> <% qec_rows_nucleogroup = (srg_qecs_nucleogroup.to_a).sort_by!{ |r| House.find_by(id: r.house_id).descrizione } %> <% totale_milq = 0 %> <% totale_pn_milq = 0 %> <% totale_milri = 0 %> <% totale_pn_milri = 0%> <% qec_rows_nucleogroup.each do |nucleo_qecs| %> <% house = House.find_by(id: nucleo_qecs[:house_id]) %> <% if not house.attivo %> <% next %> <% end %> <% srg_qec_row = SrgQec.aggrega_debito_credito(nucleo_qecs.to_row, @filterdate) %> <% qec_totals = SrgQec.calc_total(srg_qec_row, @filterdate) %> <% monthlyPns = SrgPn.collect_sums_and_map_to_rowQec(competenza: @filterdate, house_id: house.id) %> <% pn_totals = SrgQec.calc_total(monthlyPns, @filterdate) %> <% nucleo_pns_milq = monthlyPns[:milq] %> <% nucleo_pns_milri = monthlyPns[:milri] %> <% totale_milq = totale_milq + nucleo_qecs.milq %> <% totale_pn_milq = totale_pn_milq + nucleo_pns_milq %> <% totale_milri = totale_milri + nucleo_qecs.milri %> <% totale_pn_milri = totale_pn_milri + nucleo_pns_milri %> <% end %>

	MIL quote			MIL rimborsi
	quota	incasso	da incassare	rimborso	incasso	da incassare
<%= house.descrizione %>	<%= money_format( nucleo_qecs.milq) %>	<%= money_format( nucleo_pns_milq) %>	<%= money_format( nucleo_qecs.milq - nucleo_pns_milq) %>	<%= money_format( nucleo_qecs.milri) %>	<%= money_format( nucleo_pns_milri) %>	<%= money_format( nucleo_qecs.milri - nucleo_pns_milri) %>
totali:	<%= money_format( totale_milq ) %>	<%= money_format( totale_pn_milq ) %>	<%= money_format( totale_milq - totale_pn_milq ) %>	<%= money_format( totale_milri ) %>	<%= money_format( totale_pn_milri ) %>	<%= money_format( totale_milri - totale_pn_milri ) %>

<% end %> <% end %>