Thu, 12 Oct 2023 14:19:46 +0200
Version 0.3.44. Moved iSpindel Plato calculation from the php script to bmsd. This uses calibration data in the mon_ispindels table. Setup of this data will be done by the bmsapp applications. Default settings are stored in MySQL. From now on you don't need to store calibration data in the iSpindel.
172 | 1 | <?php |
2 | ||
3 | require_once('config.php'); | |
4 | ||
5 | if (isset($_GET["code"])) | |
836
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
6 | $code = $_GET["code"]; |
172 | 7 | else |
836
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
8 | $code = "TB0015"; |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
9 | |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
10 | $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
11 | if (! $connect) { |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
12 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
13 | } |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
14 | mysqli_set_charset($connect, "utf8" ); |
172 | 15 | |
836
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
16 | $query = "SELECT * FROM log_fermenter WHERE code='".$code."' ORDER BY datetime;"; |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
17 | $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
18 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
19 | |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
20 | $logs[] = array( |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
21 | 'date' => substr($row['datetime'],0,16), |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
22 | 'air' => $row['temp_air'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
23 | 'beer' => $row['temp_beer'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
24 | 'chiller' => $row['temp_chiller'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
25 | 'room' => $row['temp_room'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
26 | 'tlo' => $row['sp_low'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
27 | 'thi' => $row['sp_high'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
28 | 'heater' => $row['heater_power'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
29 | 'cooler' => $row['cooler_power'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
30 | 'event' => $row['event'] |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
31 | ); |
601
112c278be803
All graph displays now check if the log excists.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
32 | } |
112c278be803
All graph displays now check if the log excists.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
33 | |
296
69fadd1aded2
Updated design document. Add content header application/json to all scripts that produce json output. Chart prints show the beer code and name in the header. Charts don't display the menu anymore.
Michiel Broek <mbroek@mbse.eu>
parents:
194
diff
changeset
|
34 | header("Content-type: application/json"); |
172 | 35 | echo json_encode($logs); |