SmartFridge

Did you ever have the problem, that you didn't really know what was left in your fridge? Or did you ever take something out of your fridge and forgot to close it? Well I most certainly did. That's why i created this project.

This SmartFridge notifies you with a beeping sound if you left the door open, and remembers which products are inside of your fridge and the amount of them.

The things you will need for this project:

• Raspberry Pi 3 model B https://www.banggood.com
• Raspberry PI T-cobbler https://www.adafruit.com
• Barcode Reader/Scanner Module https://www.sossolutions.nl
• Dallas (waterproof) https://www.antratek.be
• LCD display for raspberry Pi https://www.amazon.de
• Wires https://www.digikey.be
• LDR https://benl.rs-online.com
• MCP3008 https://www.conrad.be
• Speaker https://benl.rs-online.com

all of these parts will cost you around €146

First you'll need to put the circuit together, I provided a Fritzing schema to do this.
If you will use my code I provided at the step read sensor data Its important you wire te sensors and LED to the same GPIO pins, You could also just change the pins in the code.

Don't forget to connect the barcode scanner to 1 of the USB ports of the pi

• Download the raspbian image from this website: https://www.raspberrypi.org
• Choose the Raspbian Stretch with desktop and recommended software option.
• Install Balena Etcher: https://www.balena.io/etcher/
• Plug-in your micro SD cart to your computer
• Open Etcher & select the iso file you just downloaded from raspberrypi.org
• Select your micro SD cart
• Click Flash! & wait a minute

When booted in raspbian you schould change some settings:

• First connect to your wifi network
• Open a terminal window and type:
  sudo raspi-config
• Go to boot options > Desktop / CLI
  Choose Console
• Press enter
• Go to interfacing options
  Turn on Serial and 1-wire
• Press finish and let the pi reboot

After the reboot type in the console:

• sudo apt-get update
• sudo apt-get upgrade
• y

You will use the programming language Python to read data from the sensors & send data to the LCD display.

You can find all of my code on github: https://github.com

You will see I use different classes to read the data from my sensors.

• The barcode scanner is connected to the pi via USB and uses the serial interface, As standard the scanner has been setup as a keyboard. So we will have to change this:
  Use this manual and scan these codes:
  - USB COM Port Emulation
  - None (page 12 of the manual)
  - EnableEAN-8* (page 24)
  - EnableEAN-13* (page 25)
• The analog values from the LDR are converted using the MCP3008, then transformed from a value to a percentage.

If you want to use more then 1 while True loop you will need to import threading (this is already done in the provided code)

We will store our products in the fridge and temperature in our database.
To mange the database i'm using mySQLworkbench, In mysqlworkbench you will need to setup a connection with your raspberry pi. But for this to work we'll need to install mariaDB on our raspberry pi.

Here is how you do it:

sudo apt-get install mariadb-server

Then setup mariaDB with:

sudo mysql_secure_installation<br>Enter current password for root (enter for none): root
Change the root password? [Y/n] Y
New password: root123
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] y
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y

Connect with mysqlworkbench to the mariaDB server with the user root and the password you chose above on your pi's ip address.

You can find your pi's ip address by typing the following in the terminal:

ip a

Look at the ip address under wlan0 it will probably look somewhat like 192.168.X.X

Now we will go ahead and install the apcahe webserver by typing the following in the terminal:

sudo apt-get install apache2
sudo reboot

Now copy the files from the directory below to the folder /var/www/html via SFTP using a program like Cyberduck or Filezilla on the ip address from the step before

Also using cyberduck or filezilla you will need to upload the python code to your pi under /home/user_name
The files are provided below or on my github

Then run the script using this command:

python /home/<em>user_name</em>/back/app.py

Check if everything is working by typing in your raspberry pi's ip address in your browser.
You should see a webpage with the temperature and an empty table

Now your smartfridge should be working perfectly and we can go ahead and make it "pretty"

Note: change user_name above always with the name of the user you created on your pi or just use the user pi

The housing that i've made is made of a plastic box you can close with clips, but you can make it in any way you want. Just don't forget to make sure the light sensor can actually see the light.

• spray paint the box white
• Drill 2 holes of 8mm diameter at the back, one for the temperature sensor and 1 for the barcode scanner
• Drill 1 hole on the left side of the box for the powercable of your pi
• Make a rectangle hole in the front of the box for the LCD display (Don't use a knife I already tried it and cut myself)
• Use some double sided tape to make sure your breadboard stays where it is.

Place your box inside de fridge

• Drill a hole through the bottom of your fridge for an extension cable.
• Fill the hole back up with some styrofoam
• Use silicon to fill the rest of the gap
• Make it smooth with a spoon with some soap on the back (so your fingers aren't sticky)
• Use some cable trucking to hide the extension cable

Now you can power your raspberry pi inside the fridge

• Use 1 of those plastic shelves from the fridge door to attach your barcode scanner to
• Make sure it doesn't move with some double sided tape
• Use some cable trucking to hide the cable

If you want to use the website to check what's inside your fridge from outside your house you will need to forward your ports in the router.

You can do this by surfing to your routers ip address in your browser, find the port forwarding page, setup a rule for your raspberry pi's ip address open port 80 to 80 and 5000 to 5000 with the TCP protocol and save the settings.

Note: To figure out your router's ip on windows, type cmd in the search bar, open the commandprompt ant type: ipconfig. The default gateway will be your router ip.

On mac you go to the apple menu/System preferences/Network/advanced/TCPIP, your router ip will be router