budget_stats.rake

namespace :budgets do
  namespace :stats do

    desc "Calculate current balloting stats"
    task balloting: :environment do
      Budget.where(phase: ["balloting", "reviewing_ballots", "finished"]).each do |budget|
        namespace = "budget_#{budget.id}_balloting_stats"
        city_heading = budget.city_heading
        city_heading_id = city_heading.present? ? city_heading.id : nil

        Stat.named(namespace, "stats", "user_count").set_value budget.ballots.select {|ballot| ballot.lines.any? }.count
        Stat.named(namespace, "stats", "vote_count").set_value budget.lines.count
        Stat.named(namespace, "stats", "user_count_in_city").set_value(budget.ballots.select {|ballot| ballot.lines.where(heading_id: city_heading_id).exists?}.count)
        Stat.named(namespace, "stats", "user_count_in_district").set_value(budget.ballots.select {|ballot| ballot.lines.where(heading_id: (budget.heading_ids - [city_heading_id])).exists?}.count)
        Stat.named(namespace, "stats", "user_count_in_city_and_district").set_value((budget.ballots.select {|ballot| ballot.lines.where(heading_id: city_heading_id).exists?}.map(&:id) & budget.ballots.select {|ballot| ballot.lines.where(heading_id: (budget.heading_ids - [city_heading_id])).exists?}.map(&:id)).count)

        budget_lines = budget.lines.joins("INNER JOIN budget_investments on budget_investments.id = budget_ballot_lines.investment_id").where("budget_investments.feasibility = 'feasible'")
        vote_count_by_heading = budget_lines.where("budget_investments.selected = true").group("budget_ballot_lines.heading_id").count
        user_count_by_district =  budget_lines.group("budget_ballot_lines.heading_id").count("DISTINCT budget_ballots.user_id")

        budget.headings.each do |heading|
          Stat.named(namespace, "vote_count_by_heading", heading.name).set_value vote_count_by_heading[heading.id]
          if heading.id != city_heading_id
            Stat.named(namespace, "user_count_by_district", heading.name).set_value user_count_by_district[heading.id]
          end
        end
      end
    end

    desc "Calcular resultados de votaciones para proyectos de gasto seleccionados"
    task balloting_selected_investments: :environment do
      Budget.last.investments.where(selected: true).each do |inv|
        if Budget::Investment::StatsVote.find_by(budget_investment_id: inv.id).blank?
          puts "Grabamos proyecto de gasto con id #{inv.id}"
          stats = Budget::Investment::StatsVote.new
          stats.budget_investment = inv
          stats.title = inv.try(:title)
          stats.description = inv.try(:description)
          stats.ambit = inv.try(:heading).try(:name)
          stats.gender= User.find(inv.author_id).gender.blank? ? "Sexo no definido" : (User.find(inv.author_id).gender.downcase == 'female' ?  'Femenino' : 'Masculino')
          stats.url_proyect = "#{Setting["url"]}/presupuestos/#{inv.budget.slug}/proyecto/#{inv.id}"
          stats.investment_location = inv.location.blank? ? "" : inv.location
          stats.latitude = MapLocation.find_by(investment_id: inv.id).try(:latitude)
          stats.longitude = MapLocation.find_by(investment_id: inv.id).try(:longitude)
          stats.supports = inv.total_votes
          stats.presentation_at = inv.created_at
          stats.url_image_web = inv.image.blank? ? "" : "#{Setting["url"]}#{inv.image.try(:attachment).try(:url)}"
        else
          stats = Budget::Investment::StatsVote.find_by(budget_investment_id: inv.id)
        end
        stats.down_votes_count = inv.ballot_lines_down_votes
        stats.up_votes_count = inv.ballot_lines_up_votes
        stats.total_votes = inv.ballot_lines_total_votes
        stats.save
        puts "Proyecto de gasto con id #{inv.id} grabado correctamente"
      end
    end

    desc "Calcular ballot_lines_count"
    task ballot_lines_count: :environment do
      Budget.find(5).ballots.each do |b|
        b.ballot_lines_count = b.lines.blank? ? 0 : b.lines.count
        b.save(validate: false)
      end
    end

    desc "Calculate stats for budget investments"
    task stats_budget: :environment do
      Budget.all.each do |budget|
        stats = Budget::Stats.new(budget)
        puts "---PARTICIPANTES"
        #Participants
        budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: 'total_participants')
        if budget_stats_exist.blank?
          budget_stats = Budget::Investment::Stat.new
          budget_stats.value = stats.total_participants.to_i
          budget_stats.name = 'total_participants'
          budget_stats.budget = budget
          budget_stats.save
          puts "OK - #{budget_stats.name} - #{budget.id}"
        end
        puts "---PARTICIPANTES POR GENERO"
        #participantes por genero
        total_exist = Budget::Investment::Stat.where(budget_id: budget.id, name: ['gender_men_total','gender_women_total','gender_other_total','percentage_mens','percentage_womens','percentage_other']).count
        if total_exist < 6
          genders = stats.try(:total_gender_participant)
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: 'gender_men_total')
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            if !genders.blank?
              budget_stats.value = genders[0].to_i
              budget_stats.name = 'gender_men_total'
              budget_stats.budget = budget
              budget_stats.save
              puts "OK - #{budget_stats.name} - #{budget.id}"
            end
          end
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: 'gender_women_total')
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            if !genders.blank?
              budget_stats.value = genders[1].to_i
              budget_stats.name = 'gender_women_total'
              budget_stats.budget = budget
              budget_stats.save
              puts "OK - #{budget_stats.name} - #{budget.id}"
            end
          end
          budget_stats = Budget::Investment::Stat.find_by(budget_id: budget.id, name: 'gender_other_total')
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            if !genders.blank?
              budget_stats.value = genders[2].to_i
              budget_stats.name = 'gender_other_total'
              budget_stats.budget = budget
              budget_stats.save
              puts "OK - #{budget_stats.name} - #{budget.id}"
            end
          end

          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: 'percentage_mens')
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            if !genders.blank?
              budget_stats.value = genders[0].to_f/(genders[0].to_i+genders[1].to_i+genders[2].to_i).to_f*100
              budget_stats.name = 'percentage_mens'
              budget_stats.budget = budget
              budget_stats.save
              puts "OK - #{budget_stats.name} - #{budget.id}"
            end
          end

          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: 'percentage_womens')
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = genders[1].to_f/(genders[0].to_i+genders[1].to_i+genders[2].to_i).to_f*100
            budget_stats.name = 'percentage_womens'
            budget_stats.budget = budget
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: 'percentage_other')
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = genders[2].to_f/(genders[0].to_i+genders[1].to_i+genders[2].to_i).to_f*100
            budget_stats.name = 'percentage_other'
            budget_stats.budget = budget
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
        end

        puts "---PARTICIPANTES POR GRUPOS DE EDAD"
        #participantes por grupos de edad
        stats.participants_by_age.each do |group|
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "#{group[1].blank? ? group[:range] : group[1][:range]}_male" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = group[1].blank? ? group[:male].to_i : group[1][:male].to_i
            budget_stats.name = "#{group[1].blank? ? group[:range] : group[1][:range]}_male"
            budget_stats.budget = budget
            budget_stats.subname = "age"
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end

          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "#{group[1].blank? ? group[:range] : group[1][:range]}_female" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = group[1].blank? ? group[:female].to_i : group[1][:female].to_i
            budget_stats.name = "#{group[1].blank? ? group[:range] : group[1][:range]}_female"
            budget_stats.budget = budget
            budget_stats.subname = "age"
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end

          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "#{group[1].blank? ? group[:range] : group[1][:range]}_other" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = group[1].blank? ? group[:other].to_i : group[1][:other].to_i
            budget_stats.name = "#{group[1].blank? ? group[:range] : group[1][:range]}_other"
            budget_stats.budget = budget
            budget_stats.subname = "age"
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end

          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "#{group[1].blank? ? group[:range] : group[1][:range]}_total" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = group[1].blank? ? group[:count].to_i : group[1][:count].to_i
            budget_stats.name = "#{group[1].blank? ? group[:range] : group[1][:range]}_total"
            budget_stats.budget = budget
            budget_stats.subname = "age"
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end

          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "#{group[1].blank? ? group[:range] : group[1][:range]}_percentage" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = group[1].blank? ? group[:percentage] : group[1][:percentage]
            budget_stats.name = "#{group[1].blank? ? group[:range] : group[1][:range]}_percentage"
            budget_stats.budget = budget
            budget_stats.subname = "age"
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
        end

        puts "---PARTICIPANTES POR GEOZONAS"
        stats.participants_by_geozone.each do |geozone|
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "#{geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]}_male" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = geozone[1].blank? ? "#{geozone[:male]}".to_i : "#{geozone[1][:male]}".to_i
            budget_stats.name = "#{geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]}_male"
            budget_stats.budget = budget
            budget_stats.subname = "geozone"
            budget_stats.type_stat = geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end

          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "#{geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]}_female" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = geozone[1].blank? ? "#{geozone[:female]}".to_i : "#{geozone[1][:female]}".to_i
            budget_stats.name = "#{geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]}_female"
            budget_stats.budget = budget
            budget_stats.subname = "geozone"
            budget_stats.type_stat = geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "#{geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]}_other" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = geozone[1].blank? ? "#{geozone[:other]}".to_i : "#{geozone[1][:other]}".to_i
            budget_stats.name = "#{geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]}_other"
            budget_stats.budget = budget
            budget_stats.type_stat = geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]
            budget_stats.subname = "geozone"
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "#{geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]}_count" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = geozone[1].blank? ? "#{geozone[:count]}".to_i : "#{geozone[1][:count]}".to_i
            budget_stats.name = "#{geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]}_count"
            budget_stats.budget = budget
            budget_stats.type_stat = geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]
            budget_stats.subname = "geozone"
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "#{geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]}_percentage" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = geozone[1].blank? ? "#{geozone[:percentage]}".to_f : "#{geozone[1][:percentage]}".to_f
            budget_stats.name = "#{geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]}_percentage"
            budget_stats.budget = budget
            budget_stats.type_stat = geozone[0].blank? ? geozone[:geozone].blank? ? "Sin distrito" : geozone[:geozone] : geozone[0].blank? ? "Sin distrito" : geozone[0]
            budget_stats.subname = "geozone"
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
        end

        puts "***ESTADÍSTICAS AVANZADAS"
        #Estadísticas avanzadas
        #Total proyectos de gasto
        puts "---TOTAL PROYECTOS DE GASTO"
        budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "total_budget_investments" )
        if budget_stats_exist.blank?
          budget_stats = Budget::Investment::Stat.new
          budget_stats.value = stats.total_budget_investments
          budget_stats.name = "total_budget_investments"
          budget_stats.budget = budget
          budget_stats.save
          puts "OK - #{budget_stats.name} - #{budget.id}"
        end
        puts "---PROYECTOS INVIABLES"
        #proyectos inviables
        budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "total_unfeasible_investments" )
        if budget_stats_exist.blank?
          budget_stats = Budget::Investment::Stat.new
          if budget.id == 5
            budget_stats.value = 265
          else
            budget_stats.value = stats.total_unfeasible_investments
          end
          budget_stats.name = "total_unfeasible_investments"
          budget_stats.budget = budget
          budget_stats.save
          puts "OK - #{budget_stats.name} - #{budget.id}"
        end
        puts "---PROYECTOS EN LA FASE FINAL"
        #proyectos en la fase final
        budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "total_selected_investments" )
        if budget_stats_exist.blank?
          budget_stats = Budget::Investment::Stat.new
          budget_stats.value = stats.total_selected_investments
          budget_stats.name = "total_selected_investments"
          budget_stats.budget = budget
          budget_stats.save
          puts "OK - #{budget_stats.name} - #{budget.id}"
        end
        puts "---PARTICIPANTES POR FASES Y GENEROS"
        #participantes por fases y generos
        stats.phases.each do |phase|
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "participants_#{phase}_phase_general" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = stats.send("total_participants_#{phase}_phase").to_i
            budget_stats.name = "participants_#{phase}_phase_general"
            budget_stats.budget = budget
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "total_participants_#{phase}_male_general" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = stats.send("total_participants_#{phase}_gender")[0]
            budget_stats.name = "total_participants_#{phase}_male_general"
            budget_stats.budget = budget
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "total_participants_#{phase}_female_general" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = stats.send("total_participants_#{phase}_gender")[1].to_i
            budget_stats.name = "total_participants_#{phase}_female_general"
            budget_stats.budget = budget
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "total_participants_#{phase}_other_general" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = stats.send("total_participants_#{phase}_gender")[2].to_i
            budget_stats.name = "total_participants_#{phase}_other_general"
            budget_stats.budget = budget
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "percentage_participants_#{phase}_male" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = stats.send("total_participants_#{phase}_gender")[0].to_f/stats.send("total_participants_#{phase}_phase").to_f*100
            budget_stats.name = "percentage_participants_#{phase}_male"
            budget_stats.budget = budget
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "percentage_participants_#{phase}_female" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = stats.send("total_participants_#{phase}_gender")[1].to_f/stats.send("total_participants_#{phase}_phase").to_f*100
            budget_stats.name = "percentage_participants_#{phase}_female"
            budget_stats.budget = budget
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
          budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, name: "percentage_participants_#{phase}_other" )
          if budget_stats_exist.blank?
            budget_stats = Budget::Investment::Stat.new
            budget_stats.value = stats.send("total_participants_#{phase}_gender")[2].to_f/stats.send("total_participants_#{phase}_phase").to_f*100
            budget_stats.name = "percentage_participants_#{phase}_other"
            budget_stats.budget = budget
            budget_stats.save
            puts "OK - #{budget_stats.name} - #{budget.id}"
          end
        end

        puts "---PARTICIPANTES POR DISTRITOS Y FASES"
        #participantes por distritos y fases
        headings = budget.headings.sort_by_name
        headings.each do |heading|
            puts "Heading: #{heading.id}"
            stats_headings = nil
          ['total_investments_count', 'total_investments_male_count', 'total_investments_female_count',
            'total_investments_other_count'].each do |name|
              puts name
              budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, budget_heading_id: heading.id, name: name.to_s)
              if budget_stats_exist.blank?
                stats_headings = stats.headings if stats_headings.blank?
                budget_stats = Budget::Investment::Stat.new
                budget_stats.budget = budget
                budget_stats.heading = heading
                budget_stats.name = name
                budget_stats.value = stats_headings[heading.id][name.to_sym]
                budget_stats.save
                puts "OK - #{budget_stats.name} - #{budget.id}"
              end
          end

          stats.all_phases.each do |phase|
            puts "Phase: #{phase}"
            budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, budget_heading_id: heading.id, name: "total_participants_#{phase}_male")
            budget_stats = Budget::Investment::Stat.new if budget_stats_exist.blank?
            if budget_stats_exist.blank?
                budget_stats.budget = budget
                budget_stats.heading = heading
                budget_stats.name = "total_participants_#{phase}_male"
                budget_stats.value = stats.headings[heading.id]["total_participants_#{phase}_male".to_sym]
                budget_stats.save
                puts "OK - #{budget_stats.name} - #{budget.id}"
            end
            budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, budget_heading_id: heading.id, name: "total_participants_#{phase}_female")
            budget_stats = Budget::Investment::Stat.new if budget_stats_exist.blank?
            if budget_stats_exist.blank?
              budget_stats.budget = budget
              budget_stats.heading = heading
              budget_stats.name = "total_participants_#{phase}_female"
              budget_stats.value = stats.headings[heading.id]["total_participants_#{phase}_female".to_sym]
              budget_stats.save
              puts "OK - #{budget_stats.name} - #{budget.id}"
            end
            budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, budget_heading_id: heading.id, name: "total_participants_#{phase}_other")
            budget_stats = Budget::Investment::Stat.new if budget_stats_exist.blank?
            if budget_stats_exist.blank?
              budget_stats.budget = budget
              budget_stats.heading = heading
              budget_stats.name = "total_participants_#{phase}_other"
              budget_stats.value = stats.headings[heading.id]["total_participants_#{phase}_other".to_sym]
              budget_stats.save
              puts "OK - #{budget_stats.name} - #{budget.id}"
            end
            budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, budget_heading_id: heading.id, name: "percentage_participants_#{phase}_phase")
            budget_stats = Budget::Investment::Stat.new if budget_stats_exist.blank?
            if budget_stats_exist.blank?
              budget_stats.budget = budget
              budget_stats.heading = heading
              budget_stats.name = "percentage_participants_#{phase}_phase"
              budget_stats.value = stats.headings[heading.id]["percentage_participants_#{phase}_phase".to_sym]
              budget_stats.save
              puts "OK - #{budget_stats.name} - #{budget.id}"
            end
            budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, budget_heading_id: heading.id, name: "percentage_district_population_#{phase}_phase")
            budget_stats = Budget::Investment::Stat.new if budget_stats_exist.blank?
            if budget_stats_exist.blank?
              budget_stats.budget = budget
              budget_stats.heading = heading
              budget_stats.name = "percentage_district_population_#{phase}_phase"
              budget_stats.value = stats.headings[heading.id]["percentage_district_population_#{phase}_phase".to_sym]
              budget_stats.save
              puts "OK - #{budget_stats.name} - #{budget.id}"
            end
            budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, budget_heading_id: heading.id, name: "total_participants_#{phase}_phase")
            stats_headings = nil
            if budget_stats_exist.blank?
              budget_stats = Budget::Investment::Stat.new
              stats_headings = stats.headings if stats_headings.blank?
              if budget_stats.value != stats_headings[heading.id]["total_participants_#{phase}_phase".to_sym]
                budget_stats.budget = budget
                budget_stats.heading = heading
                budget_stats.name = "total_participants_#{phase}_phase"
                budget_stats.value = stats_headings[heading.id]["total_participants_#{phase}_phase".to_sym]
                budget_stats.save
                puts "OK - #{budget_stats.name} - #{budget.id}"
              end
            end
            budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, budget_heading_id: heading.id, name: "total_participants_#{phase}_male")
            if budget_stats_exist.blank?
              stats_headings = stats.headings if stats_headings.blank?
              budget_stats = Budget::Investment::Stat.new
              if budget_stats.value != stats_headings[heading.id]["total_participants_#{phase}_male".to_sym]
                budget_stats.budget = budget
                budget_stats.heading = heading
                budget_stats.name = "total_participants_#{phase}_male"
                budget_stats.value = stats_headings[heading.id]["total_participants_#{phase}_male".to_sym]
                budget_stats.save
                puts "OK - #{budget_stats.name} - #{budget.id}"
              end
            end
            budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, budget_heading_id: heading.id, name: "total_participants_#{phase}_female")
            if budget_stats_exist.blank?
              stats_headings = stats.headings if stats_headings.blank?
              budget_stats = Budget::Investment::Stat.new
              if budget_stats.value != stats_headings[heading.id]["total_participants_#{phase}_female".to_sym]
                budget_stats.budget = budget
                budget_stats.heading = heading
                budget_stats.name = "total_participants_#{phase}_female"
                budget_stats.value = stats_headings[heading.id]["total_participants_#{phase}_female".to_sym]
                budget_stats.save
                puts "OK - #{budget_stats.name} - #{budget.id}"
              end
            end
            budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, budget_heading_id: heading.id, name: "total_participants_#{phase}_other")
            if budget_stats_exist.blank?
              stats_headings = stats.headings if stats_headings.blank?
              budget_stats = Budget::Investment::Stat.new
              if budget_stats.value != stats_headings[heading.id]["total_participants_#{phase}_other".to_sym]
                budget_stats.budget = budget
                budget_stats.heading = heading
                budget_stats.name = "total_participants_#{phase}_other"
                budget_stats.value = stats_headings[heading.id]["total_participants_#{phase}_other".to_sym]
                budget_stats.save
                puts "OK - #{budget_stats.name} - #{budget.id}"
              end
            end
            budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, budget_heading_id: heading.id, name: "percentage_participants_#{phase}_phase")
            if budget_stats_exist.blank?
              stats_headings = stats.headings if stats_headings.blank?
              budget_stats = Budget::Investment::Stat.new
              if budget_stats.value != stats_headings[heading.id]["percentage_participants_#{phase}_phase".to_sym]
                budget_stats.budget = budget
                budget_stats.heading = heading
                budget_stats.name = "percentage_participants_#{phase}_phase"
                budget_stats.value = stats_headings[heading.id]["percentage_participants_#{phase}_phase".to_sym]
                budget_stats.save
                puts "OK - #{budget_stats.name} - #{budget.id}"
              end
            end
            budget_stats_exist = Budget::Investment::Stat.find_by(budget_id: budget.id, budget_heading_id: heading.id, name: "percentage_district_population_#{phase}_phase")
            if budget_stats_exist.blank?
              stats_headings = stats.headings if stats_headings.blank?
              budget_stats = Budget::Investment::Stat.new
              if budget_stats.value != stats_headings[heading.id]["percentage_district_population_#{phase}_phase".to_sym]
                budget_stats.budget = budget
                budget_stats.heading = heading
                budget_stats.name = "percentage_district_population_#{phase}_phase"
                budget_stats.value = stats_headings[heading.id]["percentage_district_population_#{phase}_phase".to_sym]
                budget_stats.save
                puts "OK - #{budget_stats.name} - #{budget.id}"
              end
            end
          end
        end
      end
    end


  end

end