Simple Pints - A Digital Taplist

I had been using Raspberry Pints ported over to my windows server for a while. Getting it installed was a hack job and the database calls never worked right. After upgrading my database and PHP, my Raspberry Pints install stopped working and a reinstall didn't work either (I was hoping that my upgrades eliminated the need for my hacks, but no luck). Raspberry Pints hasn't been updated in a few years so rather than figuring out how to do another hack install, I started searching for other options. I came across Kegerface which looked nice and rather than using database is just reads simple csv file. This worked out of the box, but I kind of liked the Raspberry Pints display better. This inspired me to mix the simplicity of Kegerface with the display of Raspberry Pints. I started with the raspberry pints code base. Then I cut out the database calls and added in a file read scheme. With a few more tweaks the first working version is online. There is more to do. The code is still messy with old code commented out and random test lines also commented out. Also, I'd like to change up the style.css a bit, but I'm also happy with what is working now. I've named it Simple Pints and posted to github.com to share just in case there is someone else who might find it useful. Here is my running version.





(originally posted on my own site): https://bt.beerprojects.com/wordpress/?p=2167

 

version 02.0
- Added logos
- added examples folder and setup instructions in readme
- added better beer color function (lookup vs algorithm)

 

Clicking the link and I get the following. Doesn't provide a "warm and fuzzy feeling".

Warning: Potential Security Risk Ahead

Firefox detected an issue and did not continue to bt.beerprojects.com. The website is either misconfigured or your computer clock is set to the wrong time.

It’s likely the website’s certificate is expired, which prevents Firefox from connecting securely. If you visit this site, attackers could try to steal information like your passwords, emails, or credit card details.

What can you do about it?

Your computer clock is set to 1/7/2020. Make sure your computer is set to the correct date, time, and time zone in your system settings, and then refresh bt.beerprojects.com.

If your clock is already set to the right time, the website is likely misconfigured, and there is nothing you can do to resolve the issue. You can notify the website’s administrator about the problem.

 

ah, my cert had just expired and the updated cert wasn't loaded since I hadn't restarted my apache service. should be good to go now. just in case i attached a photo of my display today.

 

I didn't review the code. Was the code modified from Raspberry Pints? If so, might have caused a lot of work for yourself as php can read/write to csv. Would have been a simple matter of modifying the existing code to use the csv files instead of mySQL/MariaDB.

 

yeah it is modified raspberry Pints code. i mostly removed the database calls with cvs reads.

 

This is exactly what I'm looking for, I downloaded the files and put them on my pi, installed Apache, but not sure we're the 'usr' folder you mention is, should the example go in the /var/www/html folder?

 

Your the first user that i know of and i have an odd windows configuration so this might take some trials to get right. What i think you need to do is place the whole SimplePints folder in the DocumentRoot folder which is most likely your www/html folder. then within the SimplePints folder there should be a usr folder where you place the configuration files.

 

Alright great I will try to make that directory and load it up.

I wrote a small program that displays a list of my 3 taps on a small lcd, and lets me manually log how much has been poured with a game controller.

I'm thinking it might be possible to load that screen with the same beers.csv file and use a separate pours.csv using the beer_id and display the keg level. Not as cool and automatic as flow meters, but a lot less overhead.

 

Got it up and running on my pi3 (running Buster), needed to run sudo apt-get install php7.3-xml to get the php simplexml code to work, but its up!

 

Nice work, bro. Do you know if is it easy to modify to metric system?