class Snippets
  def self.goal_categories_with_two_non_english_translations
    results = []
    non_english_langs = Localization.sys_langs - ['en']

    GoalCategory.all.each do |gc|
      hits = 0
      langs = []
      non_english_langs.each do |lang|
        if gc.send("name_#{lang}") != "" and gc.questions.any? {|q| q.send("body_#{lang}") != "" }
          hits += 1
          langs << lang
        end
      end
      results << {:client_name => gc.program.client.name,
                  :program_name => gc.program.name,
                  :goal_category_name => gc.name_en,
                  :translated_languages => langs} if hits > 1
    end
    results
  end
end