The purpose of this project is to reduce the amount of paper needed to manage and record the employee's card. Another purpose is to reduce the time that the quality office's staff spend updating and organizing the data of employees and courses.

In general, this project is intended as a tool to manage employees data and formation courses, related to ISO 9001:2015.

These instructions will get you a copy of the project up and running on your local machine / local server.

NOTE: This project it's still under development. I created a dedicated branch for CouchDB (named couchDB, so much creativity) so use that, for now. Now that the project it's almost ready (it needs some minor adjustments), refer to master branch for latest updates

You need a local machine or server, with a web-server and an instance of CouchDB up and running.

You can choose what solution you prefer. For development purpose I installed http-server.

For global installation:

npm install http-server -g

Usage:

cd project path/
http-server

In the server I installed Apache, for more information about the installation, refer to the server OS and corresponding Apache version.

I worked with the NoSQL database Apache CouchDB, but the next step will be to create a version based on MongoDB. CouchDB it's really easy to install and configure.

I'm running it on a MacBook Air (Mid 2012 with macOS 10.12.3), as development machine, and on a Raspberry Pi 2 as server.

For the macOS, you need to download the zip from: http:https://couchdb.apache.org/#download. Here there are the Mac version and Windows version.

For the Raspberry Pi, it was a little trickier, but I found a valid guide here: https://cwiki.apache.org/confluence/display/COUCHDB/Raspbian. Remeber to change the first line of the guide's code

echo deb http:https://packages.erlang-solutions.com/debian wheezy contrib >> /etc/apt/sources.list

to

echo deb http:https://packages.erlang-solutions.com/debian  your_distro contrib >> /etc/apt/sources.list

If you are not sure about the available / supported distros, have a look here http:https://packages.erlang-solutions.com/debian/dists/

When you have Apache and CouchDB running, you need to clone or download the repository (more info here on how to clone with different platforms):

MacOS

Open terminal and type:

git clone https://github.com/guglio/ISO_staff.git

After downloading the repository, you need to create the database inside CouchDB.

In my project, I called 'ciam'. Create your database, with the name of your choice.

I structured the data for the employees with these scheme:

{
  "_id": "Auto-generated",
  "_rev": "Auto-generated and auto-updated",
  "nome_completo": "Full name",
  "cognome": "Surname",
  "nome": "Name",
  "cod_fiscale": "Tax code",
  "cantiere": "Site",
  "qualifica": "Qualification",
  "cod_dipendente": "Employee internal ID",
  "data_assunzione": "Hire date",
  "cod_contratto": "Contract code",
  "contratto_tempo": "Position type",
  "data_nascita": "Birthday",
  "comune_nascita": "Birthplace",
  "indirizzo": "Address",
  "cap": "ZIP",
  "comune": "City of residence",
  "provincia": "Province of residence",
  "staff": "true | false",
  "tutor": "true | false",
  "corsi":[
    {
      "id":"Course's _id"
    }
  ]
}

The structure for the courses are the following:

{
  "_id": "Auto-generated",
  "_rev": "Auto-generated and auto-updated",
  "num_addestramento": "Number of the course (xx/2017)",
  "data": "Date of the course",
  "data_inizio": "Begin date of the course",
  "data_fine": "Finish date of the course",
  "documentazione": "Type of documentation used during the course",
  "oggetto": "Purpose of the course",
  "argomenti": "Topics covered",
  "metodo_verifica": "Verification method",
  "partecipanti": [
    {
      "nome": "Employee's name",
      "cognome": "Employee's surname",
      "mansione": "Qualification",
      "risultato": "Result - positive | negative",
      "data": "Date of the course",
      "id": "Employee's _id"
    }
  ],
  "docenti": [
    {
      "nome": "Tutor's name",
      "cognome": "Tutor's surname",
      "id": "Tutor's _id"
    }
  ],
  "course": true
}

You need to link the project to the database. Open the file js/app.js and change the var urlDB, adding your database url.

Mine looks like this: var urlDB = "http:https://localhost:5984/ciam";. This var is used in every $http request.

Ok, now you have the project up and running!

I added lots of commentes (almost every line of code) inside js/app.js, to help understand better the approach I used for this project.

• AngularJS 1.6 - framework to handle the data
• Bootstrap - framework to render the data
• Node.js - to install development modules
• http-server - web-server for development
• Apache CouchDB - NoSQL database
• Apache server - web server for server
• Compass - CSS framework
• Sass - awesome stylesheets
• Atom - text editor

I use git for versioning.

Guglielmo Turco