Magic Mirror for monitoring temperature, humidity and employee attendance in a factory (with Amazon Alexa)

[Skoo]

Hi everyone,
My name is Sebastian and I would like to present my Magic Mirror project which was used in my dissertation presented at the end of postgraduate course.
I’m a chemist, but I decided that I should move on to another domain so I joined a postgraduate program which initiated me in the IT.
I’m working at a cosmetics producer company and I thought that we should automatize the reading of the temperature and humidity instead of doing that manually. I installed 4 NodeMCU boards coupled with DHT11 and DHT22 sensors along with another NodeMCU board with an RFID sensor.
The boards are sending the measurements with a http request to an Elastic Beanstalk PHP instance (AWS) which is saving the data to MySQL (AWS RDS). The information stored in the cloud can be read via a custom made Alexa skill which is parsing the JSONs generated by the PHP app, also can be checked accessing a webpage which displays the history of the measurements graphically and can be viewed on the Magic Mirror which is using the MMM-MysqlQuery module (cloned for every query)

The employee tracking application was incorporated as proof-of-concept and was made by a third party - to prove that the project can be enlarged by incorporating external projects.

Now, the mirror:
The unfinished mirror was made by carpenter.

To save on the production cost I outsourced the finishing too to a reliable person to make the box looks professional (my 3 years old):

I placed a 20 inch monitor inside the frame and painted the metallic sides with black, because every white or lightly colored item is visible from the outside.

I used black cardboard to cover the bare parts of the glass from inside. The monitor is emitting light which is visible from the outside. The speaker was moved out and I used webcam instead of the microphone.!
2_1569228676000_IMG_20181005_193927.jpg

After that I asked my sister to test the mirror. It works.

Since we are cosmetic company we can place the mirror near the meeting room and it could be an exceptional conversation start or we can use it in the warehouse displaying the temperature and humidity directly and the pending tasks for the warehouse staff.
The temperature sensor are working like a charm.

The temperature data recorded by the DHT22 is comparable to the high end (offline) temperature sensors. I measured the data for 3 days and the measurements were similar.
The DHT11 is not so perfect and I had to change them to DHT22.

You can find the whole sourcecode on my github page.
Thank You for the MM community and the module maintainers for all their great work!
This is me, heavily and poorly photoshopped:

[sdetweil]

very cool… thanks for the great detail!