zaepho / raspberrypints Goto Github PK

use HTML dialog box for Beer Deletion Confirmation instead of an ugly javascript dialog

Add handling for Table name Prefix to allow for co-existence with other apps in the same DB.

Fix New Keg (Tap_list) function (PDO Migration)

Reproduce: Tap keg, specify starting volume as less than the full potential volume of the keg.
Expected result.
UI Shows 0oz Poured
UI shows partially empty keg (CurrentOz/FullOz)
UI Shows current oz left in keg

ogEst. fgEst, srmEst all must be validated (out of bounds results in no error message at save/add)

Create Admin page for managing beer styles

Fix Tap a Keg function (PDO migration)

Fix Add Keg (PDO Migration) on keg_list.php

Allow for stats on how many pours and how much volume has been poured for each keg and each beer.

Ensure this does not interfere with current volume calculation and allows for on-demand recalculation of keg volume using pour data.

Fix Background Image (PDO Mirgation)

Combine Logo/Image update scripts into single codebase

Re-build Standard Drinks Calcs & Display in Default Skin
Reimplement to match 2.0.1 display

Data model should support kegging a beer, putting it on tap, taking it off tap, putting it back on tap while maintaining state of the beer in the keg.

Develop and implement a flexible model.

Build a backup process than can be executed from cron to backup the DB and(?) the app code.

Fix Delete Beer function in Beer_List.php

Create a system for creating a forum signature image for what's On Tap (include volume info?)

Fix TapList Logo (PDO Migration)

Ghost Pours can occur for various reasons in a flow meter setup. This should be detected and if possible prevented.

See:
https://www.homebrewtalk.com/forum/threads/version-2-release-raspberrypints-digital-taplist-solution.487694/page-87#post-8266777
https://www.homebrewtalk.com/forum/threads/version-2-release-raspberrypints-digital-taplist-solution.487694/page-35#post-7127260

Update all SQL Calls to use PDO Prepared Statements with Params. This should prevent all trivial SQL injection scenarios.

Implement Log Grooming

Add logging of events to the DB so they can be displayed in the Admin section. Audit Logs (config Changes, user logins, etc) are the most important in this case.

Especially LastModified/Created Date fields. AS much as possible DB Schema should provide sane defaults.

Currently generates a permission denied error.

Fix Delete Keg (PDO Migration) on keg_list.php

fix Add Beer functionality on beer_list.php for PDO mirgation

Fix Edit Keg (PDO Migration) on keg_list.php

Fix Column Personalization (PDO Migration)

Change Pour handling to use a per-tap Pulses Per Ounce calculation

Consider a single "upload"/Webserver directory for Compiled Templatres, Logs and Uploaded files.

Edit Beer functionality (PDO migration) on beer_list.php

Replace User Front End with Smarty Templates to make it easily modifiable without altering the backend code.

Use ajax type data refresh on user frontend for tap information. allows for high speed, seamless refresh of data without using a meta refresh (less/no page flicker). This should also resolve issues for remote displays.

Installer should be templated (separate code and UI).
Needs to take in initial admin username/password/email
Ask for Initial Tap Count
Ask for initial Keg Count

Fix KegList page (PDO Migration)

Glass Graphic should change based on Pour Size
Keg should optionally show Total Pours and Pours left
Still track volume as standard volume measurements

Fix Update Tap Info Function (PDO migration)

Fix Admin Logo (PDO Migration)

Create dbconfig.php
Import initial Schema
Initial configuration of:

• Tap Count
• Starting Kegs
• Initial Admin User

Fix Taplist Admin (PDO Migration)

Build an API for allowing a device to submit temperature information. More than 1 thermometer should be supported, should store temp entries for pretty graphs.

Build a process to import/update the BJCP Styles from official XML file/files.

Change volume handling to be stored as Ounce based vs Gallon based