search

Ecoxl / celero

Updating Celero
4 stars 1 forks source link

New "NACE Code rev2" selector #5

Closed Ocimum-basilicum closed 6 years ago

Ocimum-basilicum commented 7 years ago

I updated/enhanced the NACE code selector, its is now possible to select a NACE Code rev2 in a miller column selector on the newcompany and update_company page.

The NACE codes now match the revision 2 in the format:

Level 1: 21 sections identified by alphabetical letters A to U; Level 2: 88 divisions identified by two-digit numerical codes (01 to 99); Level 3: 272 groups identified by three-digit numerical codes (01.1 to 99.0); Level 4: 615 classes identified by four-digit numerical codes (01.11 to 99.00). info on wikipedia NACE Code rev2 Classification on eurostat

I needed to add a new table in the database. Its named t_nace_code_rev2 which is very similar to the old one. I created a .sql file which is attached (renamed to .txt because git doesn't support .sql here), it contains the commands to create the table and the NACE codes data itself. We need to get this new table in the database for first tests on the celero.unil.ch instance.

SQL file: nace_codes_for_db.txt

The miller column works on a Jquery plugin called miller.js which got added under assets/js and its css miller.css under assets/css. Furthermore it requires a .json file (miller-NACE-codes.json) which provides the NACE code data, this is located under assets/js too.

tcgumus commented 7 years ago

Thanks for the db code. I thought I lost some of the objects from db.