Sun, 24 Feb 2019 23:26:01 +0100
Added view archives by name
0 | 1 | Centrale daemon 'bmsd' regelt de dagelijkse berichten tussen MQTT en de |
2 | database. Om deze berichten betrouwbaar af te handelen is MQTT er tussen | |
3 | gezet. | |
4 | Alle sensoren en controllers communiceren uitsluitend via MQTT. | |
5 | ||
6 | Sensoren en controllers: | |
7 | ||
8 | 1. Vergisting controllers. | |
9 | 2. Temperatuur loggen. | |
10 | 3. Hergisting drukmeters. (druk + temp). | |
11 | 4. Brouw controllers. | |
12 | 5. Ispindel. | |
13 | ||
14 | ||
15 | Stappen: | |
16 | ||
17 | 1. Importeren oude vergisting en brouw logs. DONE. | |
18 | 2. Thermferm moet DLOG berichten gaan sturen, per wijziging en per 5 minuten. DONE. | |
19 | 3. bmsd moet deze DLOG berichten verwerken. Versie 0.0.2. Bier producten in database. DONE. | |
20 | 4. Versie 0.0.2 handmatig installeren op productie. DONE. | |
21 | 5. Thermferm uitbreiden met vergisting stage. DONE. | |
104 | 22 | 6. Brouw controller uitbreiden met MQTT. Niet, ESP32 wordt onstabiel. |
23 | 7. bmsd uitbreiden met brouw controller berichten. Niet, zie hierboven. | |
24 | 8. bmsd productie platform upgraden, versie 0.0.3 DONE. | |
268 | 25 | 9. bmsd recepten editor implementeren. DONE. |
26 | 10. bmsd uitbreiden met productie (brews) stappen, met hierin recepten. DONE. | |
248
cd98a44a9f1b
Version 0.0.5. Updated design document. More or less in production.
Michiel Broek <mbroek@mbse.eu>
parents:
239
diff
changeset
|
27 | 11. bmsd koppelen logs aan productie. Ferment logs klaar, nog brouwlogs. |
104 | 28 | |
0 | 29 | |
30 | ||
54
294dda7f1779
Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents:
40
diff
changeset
|
31 | Web interface bouwen met jqwidgets. |
0 | 32 | |
33 | ||
195
2ac491548d8d
Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents:
194
diff
changeset
|
34 | Database inventaris: Werking Maten Index/Strings Bool/Ints Utf-8 POST |
2ac491548d8d
Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents:
194
diff
changeset
|
35 | ---------------------------- ------- ------- ------------- --------- ----- ---- |
210 | 36 | inventory_equipments Ok. Ok. Ok. Ok. Ok. Ok. |
196
531d5458782f
Hops database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Removed the useat field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents:
195
diff
changeset
|
37 | inventory_fermentables Ok. Ok. Ok. Ok. Ok. Ok. |
531d5458782f
Hops database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Removed the useat field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents:
195
diff
changeset
|
38 | inventory_hops Ok. Ok. Ok. Ok. Ok. Ok. |
200
7b2f11652d67
Miscs from bool to ints. Miscs database uses POST instead of GET. Dropdowns are unsing indexes. Dynamic edit screen adjust for weight and liter. Edit screen redesigned. Friendly show duration of ingredients.
Michiel Broek <mbroek@mbse.eu>
parents:
198
diff
changeset
|
39 | inventory_miscs Ok. Ok. Ok. Ok. Ok. Ok. |
210 | 40 | inventory_suppliers Ok. Ok. Ok. Ok. Ok. Ok. |
41 | inventory_water Ok. Ok. Ok. Ok. Ok. Ok. | |
198
f0ec83e1e01f
Switches yeasts inventory to indexed names and translations. Database save is using POST instead of GET. Redesigned the web page. Added total cost display which updates on inventory changes.
Michiel Broek <mbroek@mbse.eu>
parents:
196
diff
changeset
|
42 | inventory_yeasts Ok. Ok. Ok. Ok. Ok. Ok. |
217
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
216
diff
changeset
|
43 | profile_fermentation Ok. Ok. Ok. Ok. Ok. Ok. |
216
fda7286871f2
Fixed the utf-8 problems when storing json arrays on the server by using manual encoding. The json-encode function sucks for this project. Added step detail edit screen instead of on grid cell editing. This must go into the product and recipe editors too.
Michiel Broek <mbroek@mbse.eu>
parents:
212
diff
changeset
|
44 | profile_mash Ok. Ok. Ok. Ok. Ok. Ok. |
218
38499e3859fa
Global setup switched to dropdown indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
217
diff
changeset
|
45 | profile_setup Ok. Ok. Ok. Ok. Ok. Ok. |
217
318aab371497
Profile style is using indexes. Profile styles and fermentation switched to POST. Standard edit screens.
Michiel Broek <mbroek@mbse.eu>
parents:
216
diff
changeset
|
46 | profile_styles Ok. Ok. Ok. Ok. Ok. Ok. |
212
adda48f710cd
Water profile uses POST instead of GET. Added tooltips to the editor screen. Updated the editor screen. Total alkalinity and Bicarbonate update each other. More and smaller columns in the listing screen. Rearranged the editor screen.
Michiel Broek <mbroek@mbse.eu>
parents:
210
diff
changeset
|
47 | profile_water Ok. Ok. Ok. Ok. Ok. Ok. |
268 | 48 | recipes Ok. Ok. Ok. Ok. Ok. Ok. |
49 | products Ok. Ok. Ok. Ok. Ok. Ok. | |
200
7b2f11652d67
Miscs from bool to ints. Miscs database uses POST instead of GET. Dropdowns are unsing indexes. Dynamic edit screen adjust for weight and liter. Edit screen redesigned. Friendly show duration of ingredients.
Michiel Broek <mbroek@mbse.eu>
parents:
198
diff
changeset
|
50 | |
21
acb2d8098f19
Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents:
20
diff
changeset
|
51 | |
18
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
0
diff
changeset
|
52 | |
0 | 53 | |
54 | ||
55 | MQTT structuur volgens Sparkplug model. | |
56 | ||
57 | mbv1.0/fermenters/[NBIRTH,DBIRTH]/<hostname>/ | |
58 | mbv1.0/fermenters/DDATA/<hostname>/<unitalias>/ | |
59 | ||
60 | --------------------------------------------------------------------------- | |
61 | ||
62 | namespace/group_id/message_type/edge_node_id/{device_id} | |
63 | ||
64 | namespace is de root, "mbv1.0" | |
65 | ||
66 | group_id oa: fermenters, brewcontrol, env_sensor | |
67 | ||
68 | message_type: NBIRTH - Birth certificate for MQTT EoN nodes. | |
69 | NDEATH - Death certificate for MQTT EoN nodes. | |
70 | NCMD - Node command message. | |
71 | DBIRTH - Birth certificate for devices. | |
72 | DDEATH - Death certificate for devices. | |
73 | NDATA - Node data message. | |
74 | DDATA - Device data message. | |
75 | DLOG - Device data logging. | |
76 | DCMD - Device command message. | |
77 | STATE - Critical application state message. | |
78 | ||
79 | NCMD: reboot (application restart) | |
80 | rebirth | |
81 | ||
82 | DCMD: fermenter state change + temperature settings. | |
83 | fermenter profile install. | |
84 | fermenter load product. | |
85 | fermenter set stage | |
86 | ||
87 | ||
109
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
88 | Product: code, uuid en naam. |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
89 | Stage: Plan Wait Brew Primary Secondary Tertiary Package Carbonation Mature Taste Ready Closed |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
90 | | | | | | | |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
91 | | | | | | +------------- Log/rapport |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
92 | | | | | +------------------------ rapport/etiketten |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
93 | | +-------+---------+--------------------------------- Log/rapport |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
94 | +--------------------------------------------------------- Log/rapport |
0 | 95 | |
174 | 96 | Main table: products. |
97 | In progress: overview. | |
180
a5aa3502310c
Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents:
174
diff
changeset
|
98 | In Progress: view charts. DONE fermenters, todo brewlogs. |
174 | 99 | In Progress: view logs. |
100 | In Progress: update state. | |
101 | In Progress: Tabbed screens. DONE. | |
102 | Start new: some sort of wizzard like a new recipe. DONE. | |
109
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
103 | Archive: select via name/code/date. |
3c334f3ca7f9
Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents:
108
diff
changeset
|
104 | Calendar: shows upcoming events. |
174 | 105 | Recipes can be copied to 'recipes' or 'brews', imported from 'recipes'/'products' or created manual. |
180
a5aa3502310c
Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents:
174
diff
changeset
|
106 | Products recipes Beerxml import. |
a5aa3502310c
Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents:
174
diff
changeset
|
107 | Recipes Beerxml import. |
106
c64d979613ab
Prepare for production brews databases
Michiel Broek <mbroek@mbse.eu>
parents:
104
diff
changeset
|
108 | |
194
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
109 | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
110 | ----------------------------------------------------------------------------- |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
111 | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
112 | Formaat csv vergisting logs. |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
113 | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
114 | Directory: www/logs/fermentation |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
115 | Filenaam: product_code\ product_name.log |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
116 | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
117 | 2014-11-15 18:39,BEER,PRIMARY,20.312,19.750,-1.500,20.5,18.6,18.8,35,12345,0,67890,Whatsup,Fermenter |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
118 | | | | | | | | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
119 | 0 datetime + | | | | | | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
120 | 1 mode --------------+ | | | | | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
121 | 2 stage -------------------+ | | | | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
122 | 3 temp air -----------------------+ | | | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
123 | 4 temp beer -----------------------------+ | | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
124 | 5 temp chiller ---------------------------------+ | | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
125 | 6 temp room -------------------------------------------+ | | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
126 | 7 setpoint low ---------------------------------------------+ | | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
127 | 8 setpoint high -------------------------------------------------+ | | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
128 | 9 heater power ------------------------------------------------------+ | | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
129 | 10 heater usage ----------------------------------------------------------+ | | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
130 | 11 cooler power --------------------------------------------------------------+ | | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
131 | 12 cooler usage ------------------------------------------------------------------+ | | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
132 | 13 event --------------------------------------------------------------------------------+ | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
133 | 14 fermenter uuid --------------------------------------------------------------------------------+ |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
134 | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
135 | De oude logs zijn geimporteerd en geconverteerd. Nieuwe worden geschreven |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
136 | door bmsd welke de log gegevens ontvangt via MQTT DLOG berichten. |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
137 | Vanwege de snelheid van verwerken staan de logs niet in de database. |
239 | 138 | Kunnen we de loggegevens versturen in gzip formaat om bandbreedte te sparen? |
194
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
139 | |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
140 | ----------------------------------------------------------------------------- |
d202777ebae5
Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents:
180
diff
changeset
|
141 | |
290 | 142 | TODO: |
143 | ||
144 | Copieren recepten tussen products en recipes, maar ook dupliceren. Import. | |
145 | Menu voor archive products. | |
146 | Cron uitbreiden met test op nieuw verschenen logfiles. Of nog slimmer, zet de | |
147 | logfile aan zodra een product in een gistkast geladen is. | |
148 | Download gist temperatuur grenzen naar thermferm zodat die opgevraagd kunnen | |
149 | worden door de monitor. Die kan dan de kleuren op de thermometers aanpassen. | |
150 | Download en import brouw logs van de brouwcontroller. | |
151 | Import van ingredienten vanuit xml bestanden zoals die van brouwhulp. | |
152 | Export ingredienten naar xml. | |
153 |