WZ2008 Categories of sectors

Categories issued by German statistical department as a ActiveRecord tree structure (German) with German and English classification names. https://www.destatis.de/DE/Methoden/Klassifikationen/GueterWirtschaftklassifikationen/Content75/KlassifikationWZ08.html

(International Standard Industrial Classification of all Economic Activities) See also: ISIC -> http://unstats.un.org/unsd/cr/registry/regcst.asp?Cl=27

Installation: add to Gemfile + bundle

rake wz2008:install:migrations
rake db:migrate
rails r "require 'wz2008/import'; Wz2008::Import.run()"

Afterwards, you have a filled database with about 1800 categories ordered in a structure via Ancestry Gem.

e.g.:

Wz2008::Category.roots.map do |root|
  [ root.description, root.children.map(&:description_en) ]
end

See documentation of Ancestry for usage.

Extra features:

Wz2008::Category.isic # only Categories with ISIC classification

Wz2008::Category.group(:hierarchy).count # Hierarchy levels of the WZ2008

Example Usage - Simple Form

• Create a Has And Belongs To Many relationship to one of your models (e.g. organisation/user/company).
• Then create a Grouped-Select with SimpleForm and select2

- roots = Wz2008::Category.roots.order('wz_code')
= f.association :wz2008_categories, as: :grouped_select, collection: roots,
  label_method: :description_de,
  group_method: :children,
  group_label_method: :description_de,
  include_blank: false,
  input_html: { multiple: true },
  multiple: true

javascript:
  $('select[multiple]').select2()