<% @srg_adacs_house = SrgAdac.search(@filter_params).where(house_id: current_house.id) %> <% @srg_adacs_people = SrgAdac.search(@filter_params).left_joins(:person).merge(Person.person_economia_di_nucleo) %> <% @srg_adacs = @srg_adacs_house + @srg_adacs_people %> <% @srg_fsns_house = SrgFsn.search(@filter_params).where(house_id: current_house.id) %> <% @srg_fsns_people = SrgFsn.search(@filter_params).filter_by_fornitore_interno(false).left_joins(:person).merge(Person.person_economia_di_nucleo).ordered_by_person_name %> <% @srg_fsns = @srg_fsns_house + @srg_fsns_people %> <% riga_affitto = (@srg_adacs.find {|x| x.srg_adactype.codice == SrgAdactypesHelper::SrgAdactypeAFF_code}) %> <% valore_affitto = riga_affitto ? riga_affitto.importo : 0.0 %> <% riga_affitto_r = (@srg_adacs.find {|x| x.srg_adactype.codice == SrgAdactypesHelper::SrgAdactypeAFR_code}) %> <% valore_affitto_r = riga_affitto_r ? riga_affitto_r.importo : 0.0 %> <% srg_adacs_fixaffitto = @srg_adacs.map do |srg_adac| if srg_adac.srg_adactype.codice == SrgAdactypesHelper::SrgAdactypeAFR_code srg_adac.importo -= valore_affitto srg_adac.descrizione = 'Rettifica affitto' else srg_adac end end %> <%# importo_affitto = current_house.buildings_affitto_rettifica %> <% importo_affitto = SrgQec.collect_affitto(current_house.id, current_competenza) %> <% if importo_affitto.is_not_zero? %> <% myAffitto = [ {nome: SrgQecsHelper::EmissioneLabelAdacDiNucleo, crb: SrgCrbsHelper::SrgCrbPARAFF_code, descrizione: SrgCrb.find_by(cod: SrgCrbsHelper::SrgCrbPARAFF_code).descrizione, rowQec: SrgQec.assegna_importo_by_adactypecode(SrgAdactypesHelper::SrgAdactypeCPA_code, importo_affitto, current_competenza.year, true) } ] %> <% else %> <% myAffitto = [] %> <% end %> <% myAdacs = @srg_adacs.map do |srg_adac| { :nome => srg_adac.nome_categoria, :crb => (srg_adac.srg_crb ? srg_adac.srg_crb.cod : ''), :descrizione => (srg_adac.descrizione_con_rata(srg_adac.srg_crb ? srg_adac.srg_crb.descrizione : '')), :rowQec => (srg_adac.assegna_importo_by_adactypecode(current_competenza.year, true) ) } end %> <% myFsns = @srg_fsns.map do |srg_fsn| { :nome => (srg_fsn.person ? srg_fsn.person.dh_person_name : ""), :crb => (srg_fsn.srg_crb ? srg_fsn.srg_crb.cod : ''), :descrizione => (srg_fsn.descrizione_con_rata(srg_fsn.srg_crb ? srg_fsn.srg_crb.descrizione : '')), :rowQec => srg_fsn.assegna_importo_by_adactypecode(current_competenza.year, true) } end %> <% myRows = myAffitto + myAdacs + myFsns %> <%# myRows.sort {|a1,a2| a1[:nome] <=> a2[:nome]} %> <% myRows = myRows.sort_by {|x| [x[:nome], x[:crb]]} %> <% groupsByName = myRows.group_by {|h| h[:nome]}.values %> <% groupsByName.each do |groupByName| %> <% grouptotals = SrgQec.row_empty %> <% groupcount = 0 %> <% groupByName.each do |item| %> <% row_qec = item[:rowQec] %> <% grouptotals = SrgQec.row_add(grouptotals, row_qec) %> <% groupcount += 1 %> <% end %> <% if groupcount > 1 %> <% end %> <% end %>

<%= current_house.descrizione %>: addebiti e accrediti calcolati in quota				<%= daterange_name(current_competenza) %>
			Rimborsi	Rimborsi	CONTRIBUTO SOCIALE		CONTRIBUTO PATRIMONIALE			Fondi sociali
			MIL	ATENÀ	debito	credito	debito	credito	affitto
<%= groupByName.first[:nome].present? ? groupByName.first[:nome] : SrgQecsHelper::EmissioneLabelAdacDiNucleo %>
	<%= item[:crb] %>	<%= item[:descrizione] %>	<%= money_format row_qec[:milri] %>	<%= money_format row_qec[:atenari] %>	<%= money_format row_qec[:csd] %>	<%= money_format -row_qec[:csc] %>	<%= money_format row_qec[:cpd] %>	<%= money_format -row_qec[:cpc] %>	<%= money_format row_qec[:cpa] %>	<%= money_format(row_qec[:fsd]-row_qec[:fsc]) %>
		TOTALE	<%= money_format grouptotals[:milri] %>	<%= money_format grouptotals[:atenari] %>	<%= money_format grouptotals[:csd] %>	<%= money_format -grouptotals[:csc] %>	<%= money_format grouptotals[:cpd] %>	<%= money_format -grouptotals[:cpc] %>	<%= money_format grouptotals[:cpa] %>	<%= money_format(grouptotals[:fsd]-grouptotals[:fsc]) %>

<% @srg_fsns_interni = SrgFsn.search(@filter_params).filter_by_fornitore_interno(true).left_joins(:person).merge(Person.person_economia_di_nucleo).ordered_by_person_name %> <% if @srg_fsns_interni.present? and (@srg_fsns_interni.length > 0) %> <% @srg_fsns_interni.each do |srg_fsn| %> <% end %>

<%= current_house.descrizione %>: fondi girati direttamente ai fornitori interni (fuori quota)		<%= daterange_name(current_competenza) %>
	CRB	servizio	descrizione	importo
<%= srg_fsn.person.dh_person_name %>	<%= (srg_fsn.srg_crb ? link_to( srg_fsn.srg_crb.cod, srg_crb_path(srg_fsn.srg_crb.id) ) : nil) %>	<%= (srg_fsn.srg_fsntype ? srg_fsn.srg_fsntype.format_for_report : nil) %>	<%= srg_fsn.descrizione_con_rata(srg_fsn.srg_crb ? srg_fsn.srg_crb.descrizione : '') %>	<%= srg_fsn.importo %>

<% end %>