README.design

Sat, 08 Dec 2018 15:20:03 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Sat, 08 Dec 2018 15:20:03 +0100
changeset 130
601920b902e5
parent 114
4935e86b2775
child 174
12aacf0da982
permissions
-rw-r--r--

Load a single recipe from the database instead of client side select.

0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
1 Centrale daemon 'bmsd' regelt de dagelijkse berichten tussen MQTT en de
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
2 database. Om deze berichten betrouwbaar af te handelen is MQTT er tussen
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3 gezet.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
4 Alle sensoren en controllers communiceren uitsluitend via MQTT.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
5
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
6 Sensoren en controllers:
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
7
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
8 1. Vergisting controllers.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
9 2. Temperatuur loggen.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
10 3. Hergisting drukmeters. (druk + temp).
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
11 4. Brouw controllers.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
12 5. Ispindel.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
13
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
14
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
15 Stappen:
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
16
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
17 1. Importeren oude vergisting en brouw logs. DONE.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
18 2. Thermferm moet DLOG berichten gaan sturen, per wijziging en per 5 minuten. DONE.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
19 3. bmsd moet deze DLOG berichten verwerken. Versie 0.0.2. Bier producten in database. DONE.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
20 4. Versie 0.0.2 handmatig installeren op productie. DONE.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
21 5. Thermferm uitbreiden met vergisting stage. DONE.
104
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
22 6. Brouw controller uitbreiden met MQTT. Niet, ESP32 wordt onstabiel.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
23 7. bmsd uitbreiden met brouw controller berichten. Niet, zie hierboven.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
24 8. bmsd productie platform upgraden, versie 0.0.3 DONE.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
25 9. bmsd recepten editor implementeren, geschikt voor enkel recepten en productie.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
26 10. bmsd uitbreiden met productie stappen, met hieraan productie recepten.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
27 11. bmsd koppelen logs aan productie.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
28
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
29
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
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
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
32
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
33
21
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
34 Database inventaris: Werking Maten
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
35 ---------------------------- ------- -------
29
a12d0a4d621e Some final patches
Michiel Broek <mbroek@mbse.eu>
parents: 27
diff changeset
36 inventory_equipments Ok. Ok.
30
f5ab22446aa5 Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents: 29
diff changeset
37 inventory_fermentables Ok. Ok.
f5ab22446aa5 Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents: 29
diff changeset
38 inventory_hops Ok. Ok.
54
294dda7f1779 Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents: 40
diff changeset
39 profile_mash Ok. Ok.
21
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
40 inventory_miscs Ok.
54
294dda7f1779 Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents: 40
diff changeset
41 profile_styles Ok. Ok.
34
a720353fada9 Formatting and measurements
Michiel Broek <mbroek@mbse.eu>
parents: 30
diff changeset
42 inventory_suppliers Ok. Ok.
54
294dda7f1779 Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents: 40
diff changeset
43 profile_water Ok. Ok.
294dda7f1779 Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents: 40
diff changeset
44 inventory_water Ok. Ok.
34
a720353fada9 Formatting and measurements
Michiel Broek <mbroek@mbse.eu>
parents: 30
diff changeset
45 inventory_yeasts Ok. Ok.
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 0
diff changeset
46
21
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
47 Handelsmaten (een zooitje ongeregeld):
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
48 vergistbare ingredienten: Prijs per kilo, hoeveelheid in gram.
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
49 hoppen Prijs per ons, hoeveelheid in gram.
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
50 Kruiden Prijs per gram, hoeveelheden in gram.
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
51 Additieven Prijs per 100 ml, hoeveeheid in ml.
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
52 Water Prijs per liter of kuub, hoveelheden in liters.
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
53 Gist Prijs per gram / ml. hoeveelheden in gram/ml.
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
54
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
55 Alles naar standaard maten in de database en presentatie naar behoefte?
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
56 Opslag kilos, liter en Euros met veel cijfers achter de comma.
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 0
diff changeset
57
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
58 Database:
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
59
104
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
60 1. Recepten opslaan standaard maar ingredienten in json formaat omdat dit flexibel is.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
61 2. Productie Brouwsels bevatten ook logs, en linken naar een extra recepten database (brews).
63
1d1e3002f26b Design update
Michiel Broek <mbroek@mbse.eu>
parents: 54
diff changeset
62 3. Inventaris ingredienten in MySQL. Voorraad historie is extra arrays.
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
63 4. Export naar beerxml.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
64 5. Import van brouwhulp xml met sync vanuit backup locatie.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
65 6. Brouwerij configuratie voornamelijk in json.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
66
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
67
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
68 MQTT structuur volgens Sparkplug model.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
69
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
70 mbv1.0/fermenters/[NBIRTH,DBIRTH]/<hostname>/
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
71 mbv1.0/fermenters/DDATA/<hostname>/<unitalias>/
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
72
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
73 ---------------------------------------------------------------------------
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
74
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
75 namespace/group_id/message_type/edge_node_id/{device_id}
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
76
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
77 namespace is de root, "mbv1.0"
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
78
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
79 group_id oa: fermenters, brewcontrol, env_sensor
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
80
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
81 message_type: NBIRTH - Birth certificate for MQTT EoN nodes.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
82 NDEATH - Death certificate for MQTT EoN nodes.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
83 NCMD - Node command message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
84 DBIRTH - Birth certificate for devices.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
85 DDEATH - Death certificate for devices.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
86 NDATA - Node data message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
87 DDATA - Device data message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
88 DLOG - Device data logging.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
89 DCMD - Device command message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
90 STATE - Critical application state message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
91
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
92 NCMD: reboot (application restart)
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
93 rebirth
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
94
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
95 DCMD: fermenter state change + temperature settings.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
96 fermenter profile install.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
97 fermenter load product.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
98 fermenter set stage
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
99
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
100
109
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
101 Product: code, uuid en naam.
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
102 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
103 | | | | | |
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
104 | | | | | +------------- Log/rapport
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
105 | | | | +------------------------ rapport/etiketten
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
106 | +-------+---------+--------------------------------- Log/rapport
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
107 +--------------------------------------------------------- Log/rapport
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
108
109
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
109 Main table: prod_main.
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
110 In progress: overview, view graphs, view logs, update state. Enter recipe editor. Tabbed screens.
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
111 Start new: some sort of wizzard like a new recipe.
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
112 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
113 Calendar: shows upcoming events.
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
114 Recipes are linked to prod_recipes.
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
115 Recipes can be copied to 'recipes', imported from 'recipes'/'prod_recipes' or created manual.
106
c64d979613ab Prepare for production brews databases
Michiel Broek <mbroek@mbse.eu>
parents: 104
diff changeset
116
114
4935e86b2775 Small fixes for prject import from Brouwhulp. Fixes for poduct database read/write. New menu entries. Equipment select in product editor. Started brewday editor. Added conditions on some buttons and edit fields. Screen layout changes.
Michiel Broek <mbroek@mbse.eu>
parents: 109
diff changeset
117 Een cronjob om de Stage bij te werken in geval van Package .. Taste.

mercurial