邊緣感測 AI 異常預警與雙向雲端監控系統(Edge-to-Cloud AI Telemetry & Anomaly Alert System) 使用LLM
將原本基於固定規則或傳統機器學習(LightGBM)的架構,升級為由 LLM(大型語言模型,例如 Google Gemini API)擔任「AI 設備診斷顧問」,核心價值在於:系統不再只輸出冰冷的「異常機率數字」,而是能結合近期時序變化趨勢與設備運行上下文,自動生成人類可讀的故障原因推測、潛在風險等級與現場處置建議,並即時推播至 Telegram。
以下為您重新架構的完整系統,包含 Wokwi ESP32 韌體 與 Python Tkinter + LLM(Gemini)雙向戰情室程式。
系統升級亮點(LLM 賦能架構)
Wokwi ESP32 端(
diagram.json+sketch.ino):維持輕量採集(DHT22 溫濕度 + 電位器 0~30A 電流),並新增 MQTT 遠端指令訂閱(雙向控制),當 LLM 判定為高風險異常時,可透過 MQTT 自動或手動觸發 ESP32 繼電器啟動散熱風扇/警報。Python Tkinter + LLM 閘道器(
llm_iot_gateway.py):採用 滑動視窗觸發機制:每收到一筆數據先做基礎安全閾值預篩(
溫度 > 48°C或電流 > 18A或單次溫升 > 2.5°C),一旦觸發疑似異常,立即打包最近 10 筆時序紀錄送交 Gemini LLM 進行深度診斷(避免每 5 秒無差別呼叫 API 造成費用與延遲浪費)。Structured Outputs(結構化 JSON 回應):強制 LLM 回傳
risk_level(正常/注意/危險)、diagnosis(診斷摘要)、action(建議處置)與auto_relay(是否建議開啟散熱風扇)。Telegram 雙向互動:主動推送「LLM 診斷報告 + 近 15 筆三軸趨勢圖」,並支援手機傳送
/status、/ask <問題>(直接針對目前設備數據向 LLM 提問)與/relay_on、/relay_off。
一、 Wokwi ESP32 電路與韌體(支援雙向 MQTT 繼電器控制)
1. Wokwi 電路定義檔 (diagram.json)
包含 ESP32、DHT22 溫濕度感測器(GPIO 15)、電位器模擬電流(GPIO 34)與繼電器模組(GPIO 26):
{
"version": 1,
"author": "Sentinel-LLM IoT",
"editor": "wokwi",
"parts": [
{ "type": "board-esp32-devkit-c-v4", "id": "esp", "top": 0, "left": 0, "attrs": {} },
{ "type": "wokwi-dht22", "id": "dht1", "top": -120, "left": -80, "attrs": { "temperature": "40.2", "humidity": "55" } },
{ "type": "wokwi-potentiometer", "id": "pot1", "top": -110, "left": 80, "attrs": { "value": "350" } },
{ "type": "wokwi-relay-module", "id": "relay1", "top": 80, "left": 160, "attrs": {} }
],
"connections": [
[ "esp:TX", "$serialMonitor:RX", "", [] ],
[ "esp:RX", "$serialMonitor:TX", "", [] ],
[ "dht1:VCC", "esp:3V3", "red", [ "v0" ] ],
[ "dht1:GND", "esp:GND.1", "black", [ "v0" ] ],
[ "dht1:SDA", "esp:15", "green", [ "v0" ] ],
[ "pot1:VCC", "esp:3V3", "red", [ "v0" ] ],
[ "pot1:GND", "esp:GND.1", "black", [ "v0" ] ],
[ "pot1:SIG", "esp:34", "orange", [ "v0" ] ],
[ "relay1:VCC", "esp:5V", "red", [ "v0" ] ],
[ "relay1:GND", "esp:GND.2", "black", [ "v0" ] ],
[ "relay1:IN", "esp:26", "purple", [ "v0" ] ]
],
"dependencies": {}
}
2. ESP32 Arduino 程式碼 (sketch.ino)
請在 Wokwi 的 Library Manager 中加入
PubSubClient、DHT sensor library與ArduinoJson。
#include <WiFi.h>
#include <PubSubClient.h>
#include <DHT.h>
#include <ArduinoJson.h>
// ==========================================
// 1. Wi-Fi 與 MQTT Broker 設定
// ==========================================
const char* WIFI_SSID = "Wokwi-GUEST";
const char* WIFI_PASSWORD = "";
const char* MQTT_BROKER = "broker.emqx.io";
const int MQTT_PORT = 1883;
const char* TOPIC_PUB = "taiwan/station/sensor/telemetry";
const char* TOPIC_SUB = "taiwan/station/sensor/control";
const char* DEVICE_ID = "ESP32_TX_01";
// ==========================================
// 2. 硬體腳位定義
// ==========================================
#define DHTPIN 15
#define DHTTYPE DHT22
#define CURRENT_PIN 34 // ADC1_CH6 (0~4095)
#define RELAY_PIN 26 // 散熱風扇 / 警報繼電器
DHT dht(DHTPIN, DHTTYPE);
WiFiClient espClient;
PubSubClient mqttClient(espClient);
bool relayState = false;
unsigned long lastPublishMs = 0;
const unsigned long PUBLISH_INTERVAL_MS = 5000;
void mqttCallback(char* topic, byte* payload, unsigned int length) {
String msg;
for (unsigned int i = 0; i < length; i++) {
msg += (char)payload[i];
}
Serial.println("[收到控制指令] " + msg);
JsonDocument doc;
if (deserializeJson(doc, msg) == DeserializationError::Ok) {
const char* target = doc["device_id"] | "";
if (String(target) == DEVICE_ID || String(target) == "ALL") {
if (doc.containsKey("relay")) {
relayState = doc["relay"].as<bool>();
digitalWrite(RELAY_PIN, relayState ? HIGH : LOW);
Serial.println(relayState ? ">>> 繼電器已開啟 (散熱/警報啟動)" : ">>> 繼電器已關閉");
}
}
}
}
void connectWiFi() {
Serial.print("連線至 Wi-Fi");
WiFi.begin(WIFI_SSID, WIFI_PASSWORD);
while (WiFi.status() != WL_CONNECTED) {
delay(400);
Serial.print(".");
}
Serial.println("\nWi-Fi 已連線! IP: " + WiFi.localIP().toString());
}
void reconnectMQTT() {
while (!mqttClient.connected()) {
String clientId = String(DEVICE_ID) + "_" + String(random(0xffff), HEX);
Serial.print("連線至 MQTT Broker... ");
if (mqttClient.connect(clientId.c_str())) {
Serial.println("成功!");
mqttClient.subscribe(TOPIC_SUB);
} else {
Serial.print("失敗, rc=");
Serial.print(mqttClient.state());
Serial.println(",3 秒後重試...");
delay(3000);
}
}
}
void setup() {
Serial.begin(115200);
pinMode(RELAY_PIN, OUTPUT);
digitalWrite(RELAY_PIN, LOW);
analogReadResolution(12);
dht.begin();
connectWiFi();
mqttClient.setServer(MQTT_BROKER, MQTT_PORT);
mqttClient.setCallback(mqttCallback);
}
void loop() {
if (!mqttClient.connected()) {
reconnectMQTT();
}
mqttClient.loop();
unsigned long now = millis();
if (now - lastPublishMs >= PUBLISH_INTERVAL_MS) {
lastPublishMs = now;
float temp = dht.readTemperature();
float humidity = dht.readHumidity();
if (isnan(temp) || isnan(humidity)) {
Serial.println("[錯誤] DHT22 讀取失敗");
return;
}
// 連續採樣 10 次平均,消除類比雜訊
long adcSum = 0;
for (int i = 0; i < 10; i++) {
adcSum += analogRead(CURRENT_PIN);
delay(2);
}
float current = ((adcSum / 10.0) / 4095.0) * 30.0;
JsonDocument doc;
doc["device_id"] = DEVICE_ID;
doc["temp"] = round(temp * 10.0) / 10.0;
doc["current"] = round(current * 10.0) / 10.0;
doc["humidity"] = round(humidity * 10.0) / 10.0;
doc["relay"] = relayState;
char jsonBuffer[192];
serializeJson(doc, jsonBuffer);
if (mqttClient.publish(TOPIC_PUB, jsonBuffer)) {
Serial.print("[發佈] ");
Serial.println(jsonBuffer);
}
}
}
二、 Python Tkinter + Gemini LLM 診斷戰情室 (llm_iot_gateway.py)
安裝必要套件
pip install paho-mqtt requests pandas numpy matplotlib
(本程式直接使用標準 requests 呼叫 Gemini REST API,免除額外 SDK 版本相容性問題,且已內建您的 Telegram Token 與 Chat ID,並相容 Thonny 與 VS Code 執行。)
完整程式碼 (llm_iot_gateway.py)
import io
import os
import html
import json
import time
import queue
import sqlite3
import threading
from datetime import datetime
import requests
import numpy as np
import pandas as pd
import paho.mqtt.client as mqtt
import tkinter as tk
from tkinter import ttk, scrolledtext
import matplotlib
matplotlib.use("Agg")
import matplotlib.pyplot as plt
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg
plt.rcParams["font.sans-serif"] = ["Microsoft JhengHei", "SimHei", "DejaVu Sans"]
plt.rcParams["axes.unicode_minus"] = False
# ==============================================================================
# 1. 系統與 API 內定參數設定
# ==============================================================================
BASE_DIR = os.path.dirname(os.path.abspath(__file__)) if "__file__" in globals() else os.getcwd()
DB_PATH = os.path.join(BASE_DIR, "sensor_llm_telemetry.db")
MQTT_BROKER = "broker.emqx.io"
MQTT_PORT = 1883
MQTT_TOPIC_SUB = "taiwan/station/sensor/telemetry"
MQTT_TOPIC_PUB = "taiwan/station/sensor/control"
MQTT_CLIENT_ID = f"llm_iot_gateway_{int(time.time())}"
GEMINI_API_KEY = "YOUR_GEMINI_API_KEY"
GEMINI_MODEL = "gemini-2.5-flash"
TELEGRAM_BOT_TOKEN = "9258205490:AAF4HajQxQbJdA-q-0i2A110RofQNjQYUFQ"
TELEGRAM_CHAT_ID = "7965218469"
LLM_COOLDOWN_SEC = 60
ALERT_COOLDOWN_SEC = 1800
HISTORY_WINDOW = 15
# ==============================================================================
# 2. SQLite 資料庫操作
# ==============================================================================
def init_database(db_path: str):
conn = sqlite3.connect(db_path)
cursor = conn.cursor()
cursor.execute("""
CREATE TABLE IF NOT EXISTS sensor_logs (
id INTEGER PRIMARY KEY AUTOINCREMENT,
device_id TEXT DEFAULT 'ESP32_TX_01',
timestamp TEXT NOT NULL,
temp REAL NOT NULL,
current REAL NOT NULL,
humidity REAL NOT NULL,
relay_state INTEGER DEFAULT 0,
risk_level TEXT DEFAULT '正常',
llm_summary TEXT DEFAULT ''
)
""")
cursor.execute("CREATE INDEX IF NOT EXISTS idx_dev_id ON sensor_logs(device_id, id)")
conn.commit()
conn.close()
def insert_sensor_record(db_path: str, device_id: str, ts_str: str, temp: float, current: float, humidity: float, relay: int) -> int:
conn = sqlite3.connect(db_path)
cursor = conn.cursor()
cursor.execute(
"INSERT INTO sensor_logs (device_id, timestamp, temp, current, humidity, relay_state) VALUES (?, ?, ?, ?, ?, ?)",
(device_id, ts_str, temp, current, humidity, relay)
)
row_id = cursor.lastrowid
conn.commit()
conn.close()
return row_id
def update_llm_diagnosis(db_path: str, row_id: int, risk_level: str, summary: str):
conn = sqlite3.connect(db_path)
cursor = conn.cursor()
cursor.execute(
"UPDATE sensor_logs SET risk_level = ?, llm_summary = ? WHERE id = ?",
(risk_level, summary, row_id)
)
conn.commit()
conn.close()
def fetch_distinct_devices(db_path: str) -> list[str]:
conn = sqlite3.connect(db_path)
cursor = conn.cursor()
cursor.execute("SELECT DISTINCT device_id FROM sensor_logs ORDER BY device_id ASC")
rows = [r[0] for r in cursor.fetchall() if r[0]]
conn.close()
return rows if rows else ["ESP32_TX_01"]
def fetch_latest_records(db_path: str, device_id: str, limit: int = 15) -> pd.DataFrame:
conn = sqlite3.connect(db_path)
query = """
SELECT id, device_id, timestamp, temp, current, humidity, relay_state, risk_level, llm_summary
FROM sensor_logs
WHERE device_id = ?
ORDER BY id DESC
LIMIT ?
"""
df = pd.read_sql_query(query, conn, params=(device_id, limit))
conn.close()
return df.iloc[::-1].reset_index(drop=True)
# ==============================================================================
# 3. Google Gemini LLM 結構化診斷與自由問答引擎
# ==============================================================================
def analyze_telemetry_with_llm(api_key: str, device_id: str, df_recent: pd.DataFrame, user_question: str = "") -> dict:
latest = df_recent.iloc[-1]
history_lines = [
f"- {str(r['timestamp'])[-8:]} | 溫度:{r['temp']:.1f}°C | 濕度:{r['humidity']:.1f}% | 電流:{r['current']:.1f}A | 繼電器:{'ON' if r['relay_state'] else 'OFF'}"
for _, r in df_recent.tail(10).iterrows()
]
history_text = "\n".join(history_lines)
if not api_key or api_key == "YOUR_GEMINI_API_KEY":
is_high = latest["temp"] >= 48.0 or latest["current"] >= 18.0
return {
"risk_level": "危險" if is_high else "正常",
"diagnosis": (
f"[本機備援規則] 目前溫度 {latest['temp']:.1f}°C、電流 {latest['current']:.1f}A,已超過安全基準。"
if is_high else
f"[本機備援規則] 設備溫度 {latest['temp']:.1f}°C、電流 {latest['current']:.1f}A 均在正常區間。"
),
"action": "建議開啟散熱風扇繼電器並檢查通風。" if is_high else "維持常態監控即可。",
"auto_relay": bool(is_high)
}
system_prompt = (
"你是一位資深的工業物聯網與電力機房設備診斷工程師。請根據感測器最近 10 筆時序數據(溫度 °C、濕度 %、負載電流 A),"
"評估設備是否存在過熱、電流突波、潮濕結露或漸進式故障徵兆。\n"
"一般設備正常基準:溫度 30~46°C、濕度 35~75%、電流 1~16A。\n"
"請務必以繁體中文輸出純 JSON 格式,包含四個欄位:\n"
'1. "risk_level": 只能是 "正常"、"注意" 或 "危險"\n'
'2. "diagnosis": 50字以內的精準故障趨勢分析\n'
'3. "action": 40字以內的具體現場維運處置建議\n'
'4. "auto_relay": 布林值 true 或 false(當溫度 >= 48°C 或判定為危險時為 true)'
)
user_prompt = f"設備編號:{device_id}\n最近時序紀錄:\n{history_text}"
if user_question:
user_prompt += f"\n\n維運人員特別提問:{user_question}"
url = f"https://generativelanguage.googleapis.com/v1beta/models/{GEMINI_MODEL}:generateContent?key={api_key}"
payload = {
"systemInstruction": {"parts": [{"text": system_prompt}]},
"contents": [{"parts": [{"text": user_prompt}]}],
"generationConfig": {"temperature": 0.2, "responseMimeType": "application/json"}
}
resp = requests.post(url, json=payload, timeout=20)
resp.raise_for_status()
raw_text = resp.json()["candidates"][0]["content"]["parts"][0]["text"]
result = json.loads(raw_text)
return {
"risk_level": result.get("risk_level", "注意"),
"diagnosis": result.get("diagnosis", "已完成趨勢分析"),
"action": result.get("action", "請持續觀察數值變化"),
"auto_relay": bool(result.get("auto_relay", False))
}
# ==============================================================================
# 4. 繪製最近 15 筆三軸趨勢圖與 Telegram API 發送工具
# ==============================================================================
def render_trend_chart_bytes(df_recent: pd.DataFrame, device_id: str, risk_level: str) -> io.BytesIO:
fig = Figure(figsize=(8.0, 6.2), dpi=130)
axes = fig.subplots(3, 1, sharex=True)
x_labels = [str(ts)[-8:] for ts in df_recent["timestamp"]]
x_idx = np.arange(len(df_recent))
alert_mask = df_recent["risk_level"].isin(["注意", "危險"]).to_numpy()
series_specs = [
("temp", "設備溫度 (°C)", "#D62728", "溫度"),
("humidity", "環境濕度 (%)", "#1F77B4", "濕度"),
("current", "負載電流 (A)", "#2CA02C", "電流"),
]
for ax, (col, ylabel, color, label_name) in zip(axes, series_specs):
vals = df_recent[col].to_numpy()
ax.plot(x_idx, vals, color=color, marker="o", markersize=4, linewidth=1.6, label=label_name)
if np.any(alert_mask):
ax.scatter(x_idx[alert_mask], vals[alert_mask], color="#FF0000", edgecolors="black", s=65, zorder=5, label="LLM 警示點")
ax.annotate(f"{vals[-1]:.1f}", xy=(x_idx[-1], vals[-1]), xytext=(4, 2), textcoords="offset points", fontsize=9, fontweight="bold", color=color)
ax.set_ylabel(ylabel, fontsize=10)
ax.grid(True, linestyle="--", alpha=0.45)
ax.legend(loc="upper left", fontsize=8.5)
axes[0].set_title(f"[{device_id}] 近 {len(df_recent)} 筆感測趨勢(評估等級:{risk_level})", fontsize=11, fontweight="bold")
axes[2].set_xticks(x_idx)
axes[2].set_xticklabels(x_labels, rotation=30, ha="right", fontsize=8.5)
axes[2].set_xlabel("紀錄時間 (HH:MM:SS)", fontsize=10)
fig.tight_layout()
buf = io.BytesIO()
fig.savefig(buf, format="png")
buf.seek(0)
return buf
def send_telegram_photo_async(token: str, chat_id: str, caption: str, img_buf: io.BytesIO, log_callback):
def _worker():
if not token or not chat_id:
log_callback("❌ [Telegram] Token 或 Chat ID 為空!")
return
url = f"https://api.telegram.org/bot{token}/sendPhoto"
files = {"photo": ("sensor_trend.png", img_buf, "image/png")}
data = {"chat_id": str(chat_id).strip(), "caption": caption[:1024], "parse_mode": "HTML"}
try:
resp = requests.post(url, data=data, files=files, timeout=15)
if not resp.ok:
log_callback(f"❌ [Telegram sendPhoto 失敗 {resp.status_code}] {resp.text}")
else:
log_callback(f"✅ [Telegram] 已成功發送趨勢圖報表至 Chat ID: {chat_id}")
except requests.RequestException as exc:
log_callback(f"❌ [Telegram] 網路連線例外:{exc}")
threading.Thread(target=_worker, daemon=True).start()
def send_telegram_text_async(token: str, chat_id: str, text: str, log_callback):
def _worker():
if not token or not chat_id:
log_callback("❌ [Telegram] Token 或 Chat ID 為空!")
return
url = f"https://api.telegram.org/bot{token}/sendMessage"
payload = {"chat_id": str(chat_id).strip(), "text": text, "parse_mode": "HTML"}
try:
resp = requests.post(url, json=payload, timeout=10)
if not resp.ok:
log_callback(f"❌ [Telegram sendMessage 失敗 {resp.status_code}] {resp.text}")
else:
log_callback(f"✅ [Telegram] 已發送文字訊息至 Chat ID: {chat_id}")
except requests.RequestException as exc:
log_callback(f"❌ [Telegram] 網路連線例外:{exc}")
threading.Thread(target=_worker, daemon=True).start()
# ==============================================================================
# 5. Tkinter + LLM 雙向監控主應用程式
# ==============================================================================
class LLMSensorMonitorApp:
def __init__(self, root: tk.Tk):
self.root = root
self.root.title("Sentinel-LLM 工業感測器 AI 語意診斷與 Telegram 雙向戰情室")
self.root.geometry("1180x830")
self.root.minsize(1040, 700)
init_database(DB_PATH)
self.known_devices = fetch_distinct_devices(DB_PATH)
self.selected_device = self.known_devices[0]
self.active_gemini_key = GEMINI_API_KEY
self.active_tg_token = TELEGRAM_BOT_TOKEN
self.active_tg_chat = TELEGRAM_CHAT_ID
self.ui_queue = queue.Queue()
self.device_states: dict[str, dict] = {}
self.mqtt_client = None
self.is_running = False
self.tg_poll_running = True
self.tg_last_update_id = 0
self._build_ui()
self._load_device_view(self.selected_device)
self._start_telegram_command_poller()
self._poll_ui_queue()
def _build_ui(self):
# --- 1. 頂部設定與控制列 ---
top_frame = ttk.LabelFrame(self.root, text="MQTT 連線、Gemini LLM 金鑰與 Telegram Bot 設定", padding=(12, 8))
top_frame.pack(fill=tk.X, padx=14, pady=(10, 6))
ttk.Label(top_frame, text="Broker:").grid(row=0, column=0, padx=3, sticky=tk.W)
self.broker_var = tk.StringVar(value=MQTT_BROKER)
ttk.Entry(top_frame, textvariable=self.broker_var, width=15).grid(row=0, column=1, padx=4)
ttk.Label(top_frame, text="Gemini Key:").grid(row=0, column=2, padx=3, sticky=tk.E)
self.gemini_key_var = tk.StringVar(value=GEMINI_API_KEY)
gem_entry = ttk.Entry(top_frame, textvariable=self.gemini_key_var, width=25, show="*")
gem_entry.grid(row=0, column=3, padx=4)
gem_entry.bind("<FocusOut>", lambda e: self._sync_runtime_settings())
self.auto_relay_var = tk.BooleanVar(value=True)
ttk.Checkbutton(top_frame, text="危險時自動開風扇", variable=self.auto_relay_var).grid(
row=0, column=4, columnspan=2, padx=4, sticky=tk.W
)
self.conn_btn = ttk.Button(top_frame, text="▶ 啟動 MQTT 監控", command=self.toggle_mqtt)
self.conn_btn.grid(row=0, column=6, padx=3, ipadx=5, ipady=2)
self.ask_llm_btn = ttk.Button(top_frame, text="🧠 執行 LLM 診斷並推播", command=self.manual_llm_diagnosis)
self.ask_llm_btn.grid(row=0, column=7, padx=3, ipadx=5, ipady=2)
self.test_tg_btn = ttk.Button(top_frame, text="📤 測試發送趨勢圖", command=self.manual_send_test_chart)
self.test_tg_btn.grid(row=0, column=8, padx=3, ipadx=5, ipady=2)
# 第二列:設備切換 + Telegram 設定 + 手動繼電器控制
ttk.Label(top_frame, text="監控設備:", font=("Microsoft JhengHei", 9, "bold"), foreground="#0052CC").grid(
row=1, column=0, padx=3, pady=(6, 0), sticky=tk.W
)
self.device_var = tk.StringVar(value=self.selected_device)
self.device_combo = ttk.Combobox(
top_frame, textvariable=self.device_var, values=self.known_devices, state="readonly", width=14
)
self.device_combo.grid(row=1, column=1, padx=4, pady=(6, 0), sticky=tk.W)
self.device_combo.bind("<<ComboboxSelected>>", self.on_device_changed)
ttk.Label(top_frame, text="TG Token:").grid(row=1, column=2, padx=3, pady=(6, 0), sticky=tk.E)
self.tg_token_var = tk.StringVar(value=TELEGRAM_BOT_TOKEN)
ttk.Entry(top_frame, textvariable=self.tg_token_var, width=25, show="*").grid(row=1, column=3, padx=4, pady=(6, 0))
ttk.Label(top_frame, text="Chat ID:").grid(row=1, column=4, padx=3, pady=(6, 0), sticky=tk.E)
self.tg_chat_var = tk.StringVar(value=TELEGRAM_CHAT_ID)
ttk.Entry(top_frame, textvariable=self.tg_chat_var, width=12).grid(row=1, column=5, padx=4, pady=(6, 0))
self.relay_on_btn = ttk.Button(top_frame, text="🌀 開啟繼電器", command=lambda: self.publish_relay_command(self.selected_device, True))
self.relay_on_btn.grid(row=1, column=6, padx=3, pady=(6, 0))
self.relay_off_btn = ttk.Button(top_frame, text="🛑 關閉繼電器", command=lambda: self.publish_relay_command(self.selected_device, False))
self.relay_off_btn.grid(row=1, column=7, padx=3, pady=(6, 0))
# --- 2. 即時感測器 KPI 卡片列 ---
kpi_frame = ttk.Frame(self.root, padding=(14, 4))
kpi_frame.pack(fill=tk.X)
self.kpi_vars = {
"device": tk.StringVar(value=f"{self.selected_device} (等待數據)"),
"temp": tk.StringVar(value="--.- °C"),
"humidity": tk.StringVar(value="--.- %"),
"current": tk.StringVar(value="--.- A"),
"risk": tk.StringVar(value="正常 (待診斷)"),
}
cards_info = [
("目前檢視設備 / 時間", "device", "#F4F6F8", "#172B4D"),
("即時設備溫度", "temp", "#FFF0F0", "#C92A2A"),
("即時環境濕度", "humidity", "#EDF2FF", "#1864AB"),
("即時負載電流", "current", "#EBFBEE", "#2B8A3E"),
("LLM 健康度評估", "risk", "#EBFBEE", "#2B8A3E"),
]
for idx, (title, key, bg_color, fg_color) in enumerate(cards_info):
card = tk.Frame(kpi_frame, bg=bg_color, bd=1, relief=tk.SOLID, padx=12, pady=8)
card.pack(side=tk.LEFT, fill=tk.BOTH, expand=True, padx=(0 if idx == 0 else 6, 0))
tk.Label(card, text=title, bg=bg_color, fg="#555555", font=("Microsoft JhengHei", 9)).pack(anchor=tk.W)
lbl = tk.Label(card, textvariable=self.kpi_vars[key], bg=bg_color, fg=fg_color, font=("Microsoft JhengHei", 13, "bold"))
lbl.pack(anchor=tk.W, pady=(3, 0))
if key == "risk":
self.risk_card = card
self.risk_lbl = lbl
# --- 3. LLM 語意診斷報告橫幅 ---
llm_box = ttk.LabelFrame(self.root, text="🧠 Gemini LLM 設備即時語意診斷與維運建議", padding=(12, 6))
llm_box.pack(fill=tk.X, padx=14, pady=(4, 4))
self.llm_report_var = tk.StringVar(value="點擊「🧠 執行 LLM 診斷並推播」或「📤 測試發送趨勢圖」,也可在 Telegram 傳送 /status 或 /ask 查詢。")
tk.Label(
llm_box, textvariable=self.llm_report_var, justify=tk.LEFT, wraplength=1080,
font=("Microsoft JhengHei", 10), fg="#1E293B"
).pack(anchor=tk.W)
# --- 4. 主顯示分頁區 ---
self.notebook = ttk.Notebook(self.root)
self.notebook.pack(fill=tk.BOTH, expand=True, padx=14, pady=(4, 12))
chart_tab = ttk.Frame(self.notebook, padding=6)
self.notebook.add(chart_tab, text=" 📈 近 15 筆溫度 / 濕度 / 電流趨勢 ")
self.fig = Figure(figsize=(9.0, 4.2), dpi=100)
self.canvas = FigureCanvasTkAgg(self.fig, master=chart_tab)
self.canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
data_tab = ttk.Frame(self.notebook, padding=6)
self.notebook.add(data_tab, text=" 🗄️ SQLite 紀錄與系統運行日誌 ")
paned = ttk.PanedWindow(data_tab, orient=tk.VERTICAL)
paned.pack(fill=tk.BOTH, expand=True)
tree_frame = ttk.Frame(paned)
paned.add(tree_frame, weight=3)
cols = ("id", "device_id", "timestamp", "temp", "humidity", "current", "relay", "risk")
self.tree = ttk.Treeview(tree_frame, columns=cols, show="headings", height=7)
headers = {
"id": ("ID", 50), "device_id": ("設備編號", 110), "timestamp": ("接收時間", 150),
"temp": ("溫度 (°C)", 85), "humidity": ("濕度 (%)", 85), "current": ("電流 (A)", 85),
"relay": ("繼電器", 75), "risk": ("LLM 評估", 90)
}
for col, (text, width) in headers.items():
self.tree.heading(col, text=text)
self.tree.column(col, width=width, anchor=tk.CENTER)
vsb = ttk.Scrollbar(tree_frame, orient="vertical", command=self.tree.yview)
self.tree.configure(yscrollcommand=vsb.set)
self.tree.pack(side=tk.LEFT, fill=tk.BOTH, expand=True)
vsb.pack(side=tk.RIGHT, fill=tk.Y)
log_frame = ttk.LabelFrame(paned, text="系統日誌(支援 Telegram 指令:/status、/ask <問題>、/relay_on、/relay_off)", padding=4)
paned.add(log_frame, weight=2)
self.log_text = scrolledtext.ScrolledText(
log_frame, wrap=tk.WORD, font=("Consolas", 10), bg="#1E1E1E", fg="#DCDCDC", height=6
)
self.log_text.pack(fill=tk.BOTH, expand=True)
def _sync_runtime_settings(self):
self.active_gemini_key = self.gemini_key_var.get().strip()
self.active_tg_token = self.tg_token_var.get().strip()
self.active_tg_chat = self.tg_chat_var.get().strip()
def _enqueue_log(self, msg: str):
ts = datetime.now().strftime("%H:%M:%S")
self.ui_queue.put(("log", f"[{ts}] {msg}"))
def on_device_changed(self, event=None):
new_dev = self.device_var.get().strip()
if new_dev:
self.selected_device = new_dev
self._load_device_view(new_dev)
def _load_device_view(self, device_id: str):
df_dev = fetch_latest_records(DB_PATH, device_id=device_id, limit=HISTORY_WINDOW)
if not df_dev.empty:
self._refresh_dashboard(df_dev)
# ==========================================================================
# MQTT 雙向通訊
# ==========================================================================
def toggle_mqtt(self):
self._sync_runtime_settings()
if not self.is_running:
broker = self.broker_var.get().strip()
self.mqtt_client = mqtt.Client(
callback_api_version=mqtt.CallbackAPIVersion.VERSION2,
client_id=MQTT_CLIENT_ID
)
self.mqtt_client.on_connect = self._on_mqtt_connect
self.mqtt_client.on_message = self._on_mqtt_message
try:
self.mqtt_client.connect_async(broker, MQTT_PORT, keepalive=60)
self.mqtt_client.loop_start()
self.is_running = True
self.conn_btn.config(text="⏹ 停止 MQTT 監控")
self._enqueue_log(f"正在連線至 {broker}:{MQTT_PORT}...")
except Exception as exc:
self._enqueue_log(f"❌ MQTT 啟動失敗:{exc}")
else:
if self.mqtt_client:
self.mqtt_client.loop_stop()
self.mqtt_client.disconnect()
self.is_running = False
self.conn_btn.config(text="▶ 啟動 MQTT 監控")
self._enqueue_log("已停止 MQTT 監控服務。")
def publish_relay_command(self, device_id: str, turn_on: bool):
if not self.is_running or not self.mqtt_client:
self._enqueue_log("⚠️ 請先啟動 MQTT 監控再發送繼電器控制指令。")
return
payload = json.dumps({"device_id": device_id, "relay": turn_on})
self.mqtt_client.publish(MQTT_TOPIC_PUB, payload, qos=1)
self._enqueue_log(f"📤 已向 [{device_id}] 發送繼電器指令:{'開啟 (ON)' if turn_on else '關閉 (OFF)'}")
def _on_mqtt_connect(self, client, userdata, flags, reason_code, properties):
if reason_code == 0:
client.subscribe(MQTT_TOPIC_SUB, qos=1)
self._enqueue_log(f"✅ MQTT 連線成功!已訂閱:{MQTT_TOPIC_SUB}")
def _on_mqtt_message(self, client, userdata, msg):
raw = msg.payload.decode("utf-8", errors="replace")
try:
data = json.loads(raw)
device_id = str(data.get("device_id", "ESP32_TX_01")).strip()
temp = float(data["temp"])
current = float(data["current"])
humidity = float(data["humidity"])
relay = 1 if data.get("relay", False) else 0
ts_str = str(data.get("timestamp", datetime.now().strftime("%Y-%m-%d %H:%M:%S")))
except Exception as exc:
self._enqueue_log(f"⚠️ 無效封包:{raw} ({exc})")
return
if device_id not in self.known_devices:
self.known_devices.append(device_id)
self.known_devices.sort()
self.ui_queue.put(("new_device", list(self.known_devices)))
row_id = insert_sensor_record(DB_PATH, device_id, ts_str, temp, current, humidity, relay)
df_recent = fetch_latest_records(DB_PATH, device_id=device_id, limit=HISTORY_WINDOW)
temp_jump = (temp - float(df_recent["temp"].iloc[-2])) if len(df_recent) >= 2 else 0.0
suspect_anomaly = (temp >= 48.0) or (current >= 18.0) or (temp_jump >= 2.5)
state = self.device_states.setdefault(device_id, {"last_llm_ts": 0.0, "last_alert_ts": 0.0, "in_alert": False})
now_ts = time.time()
if suspect_anomaly and (now_ts - state["last_llm_ts"] >= LLM_COOLDOWN_SEC):
state["last_llm_ts"] = now_ts
threading.Thread(
target=self._run_llm_pipeline,
args=(device_id, row_id, df_recent.copy(), True),
daemon=True
).start()
else:
self._enqueue_log(f"[{device_id} | ID:{row_id}] 溫度:{temp:.1f}°C 濕度:{humidity:.1f}% 電流:{current:.1f}A")
if device_id == self.selected_device:
self.ui_queue.put(("refresh", df_recent))
def manual_llm_diagnosis(self):
self._sync_runtime_settings()
target_dev = self.selected_device
df_recent = fetch_latest_records(DB_PATH, device_id=target_dev, limit=HISTORY_WINDOW)
if df_recent.empty:
self._enqueue_log(f"⚠️ 設備 [{target_dev}] 尚無數據可供診斷,請先啟動 MQTT 接收至少 1 筆資料。")
return
row_id = int(df_recent.iloc[-1]["id"])
self._enqueue_log(f"🧠 正在執行 [{target_dev}] 診斷並同步推播至 Telegram...")
threading.Thread(
target=self._run_llm_pipeline,
args=(target_dev, row_id, df_recent, False),
daemon=True
).start()
def manual_send_test_chart(self):
"""手動立即發送目前設備的趨勢圖與數據至 Telegram(不論正常或異常)"""
self._sync_runtime_settings()
target_dev = self.selected_device
df_recent = fetch_latest_records(DB_PATH, device_id=target_dev, limit=HISTORY_WINDOW)
if df_recent.empty:
self._enqueue_log(f"⚠️ 設備 [{target_dev}] 尚無數據,請先啟動 MQTT 接收資料後再測試發送。")
return
latest = df_recent.iloc[-1]
risk = str(latest["risk_level"] or "正常")
caption = (
f"📊 <b>【Sentinel-LLM 手動測試趨勢報告】</b>\n"
f"📟 <b>設備:</b><code>{html.escape(target_dev)}</code> | {html.escape(str(latest['timestamp']))}\n"
f"🌡️ 溫度:{latest['temp']:.1f}°C | 💧 濕度:{latest['humidity']:.1f}% | ⚡ 電流:{latest['current']:.1f}A\n"
f"🛡️ <b>評估狀態:</b>{html.escape(risk)}"
)
img_buf = render_trend_chart_bytes(df_recent, target_dev, risk)
send_telegram_photo_async(self.active_tg_token, self.active_tg_chat, caption, img_buf, self._enqueue_log)
def _run_llm_pipeline(self, device_id: str, row_id: int, df_recent: pd.DataFrame, is_auto_trigger: bool):
self._sync_runtime_settings()
try:
res = analyze_telemetry_with_llm(self.active_gemini_key, device_id, df_recent)
risk = res["risk_level"]
diag = res["diagnosis"]
action = res["action"]
summary_full = f"【風險等級:{risk}】{diag} | 建議處置:{action}"
update_llm_diagnosis(DB_PATH, row_id, risk, summary_full)
df_recent.loc[df_recent.index[-1], "risk_level"] = risk
df_recent.loc[df_recent.index[-1], "llm_summary"] = summary_full
self._enqueue_log(f"🧠 [{device_id} 診斷結果] {summary_full}")
self.ui_queue.put(("llm_banner", summary_full))
if device_id == self.selected_device:
self.ui_queue.put(("refresh", df_recent))
if is_auto_trigger and self.auto_relay_var.get() and res["auto_relay"]:
self.publish_relay_command(device_id, True)
# 手動點擊診斷按鈕時強制推播;自動觸發時則在「注意」或「危險」且超過冷卻時間才推播
state = self.device_states.setdefault(device_id, {"last_llm_ts": 0.0, "last_alert_ts": 0.0, "in_alert": False})
now_ts = time.time()
should_push = (not is_auto_trigger) or (risk in ("注意", "危險") and (now_ts - state["last_alert_ts"] >= ALERT_COOLDOWN_SEC))
if should_push:
latest = df_recent.iloc[-1]
badge = "🚨" if risk in ("注意", "危險") else "📋"
caption = (
f"{badge} <b>【Sentinel-LLM 設備語意診斷報告】</b>\n"
f"━━━━━━━━━━━━━━━━━━\n"
f"📟 <b>設備編號:</b><code>{html.escape(device_id)}</code>\n"
f"⚠️ <b>風險等級:</b><b>{html.escape(risk)}</b>\n"
f"🌡️ <b>即時數據:</b>{latest['temp']:.1f}°C | {latest['humidity']:.1f}% | {latest['current']:.1f}A\n"
f"🧠 <b>AI 診斷分析:</b>{html.escape(diag)}\n"
f"🛠️ <b>建議處置:</b>{html.escape(action)}\n"
f"━━━━━━━━━━━━━━━━━━\n"
f"支援指令:<code>/status</code>、<code>/ask 問題</code>、<code>/relay_on</code>"
)
img_buf = render_trend_chart_bytes(df_recent, device_id, risk)
send_telegram_photo_async(self.active_tg_token, self.active_tg_chat, caption, img_buf, self._enqueue_log)
if is_auto_trigger:
state["last_alert_ts"] = now_ts
except Exception as exc:
self._enqueue_log(f"❌ LLM 推論失敗:{exc}")
# ==========================================================================
# Telegram Bot 雙向指令輪詢 (/status, /ask, /relay_on, /relay_off)
# ==========================================================================
def _start_telegram_command_poller(self):
threading.Thread(target=self._telegram_polling_loop, daemon=True).start()
def _telegram_polling_loop(self):
self._enqueue_log("🤖 Telegram Bot 指令監聽已啟動(支援 /status、/ask、/relay_on、/relay_off)。")
while self.tg_poll_running:
token = self.active_tg_token
if not token:
time.sleep(2.0)
continue
try:
resp = requests.get(
f"https://api.telegram.org/bot{token}/getUpdates",
params={"offset": self.tg_last_update_id + 1, "timeout": 20},
timeout=25
)
if not resp.ok:
self._enqueue_log(f"⚠️ Telegram 輪詢警告 ({resp.status_code}):{resp.text}")
time.sleep(5.0)
continue
for update in resp.json().get("result", []):
self.tg_last_update_id = max(self.tg_last_update_id, update["update_id"])
msg = update.get("message")
if msg and "text" in msg:
self._handle_telegram_command(token, str(msg["chat"]["id"]), msg["text"].strip())
except Exception as exc:
self._enqueue_log(f"⚠️ Telegram 輪詢連線重試中:{exc}")
time.sleep(4.0)
def _handle_telegram_command(self, token: str, chat_id: str, text: str):
self._enqueue_log(f"📩 收到 Telegram 指令:{text} (Chat ID: {chat_id})")
parts = text.split(maxsplit=1)
cmd = parts[0].lower().split("@")[0]
arg = parts[1].strip() if len(parts) > 1 else ""
target_dev = self.selected_device
if cmd == "/relay_on":
self.publish_relay_command(arg or target_dev, True)
send_telegram_text_async(token, chat_id, f"🌀 已發送指令開啟 <code>{html.escape(arg or target_dev)}</code> 散熱風扇繼電器。", self._enqueue_log)
return
if cmd == "/relay_off":
self.publish_relay_command(arg or target_dev, False)
send_telegram_text_async(token, chat_id, f"🛑 已發送指令關閉 <code>{html.escape(arg or target_dev)}</code> 散熱風扇繼電器。", self._enqueue_log)
return
if cmd in ("/status", "/ask", "/start", "/help"):
df_recent = fetch_latest_records(DB_PATH, device_id=target_dev, limit=HISTORY_WINDOW)
if df_recent.empty:
send_telegram_text_async(token, chat_id, f"⚠️ 設備 <code>{html.escape(target_dev)}</code> 尚無數據,請先在電腦端啟動 MQTT 監控接收資料。", self._enqueue_log)
return
self._sync_runtime_settings()
question = arg if cmd == "/ask" else "請簡述目前設備運行狀態與趨勢是否正常。"
res = analyze_telemetry_with_llm(self.active_gemini_key, target_dev, df_recent, user_question=question)
latest = df_recent.iloc[-1]
caption = (
f"📊 <b>【Sentinel-LLM 即時巡檢報告】</b>\n"
f"📟 <b>設備:</b><code>{html.escape(target_dev)}</code>({html.escape(str(latest['timestamp']))})\n"
f"🌡️ {latest['temp']:.1f}°C | 💧 {latest['humidity']:.1f}% | ⚡ {latest['current']:.1f}A\n"
f"🧠 <b>AI 評估 ({html.escape(res['risk_level'])}):</b>{html.escape(res['diagnosis'])}\n"
f"🛠️ <b>建議:</b>{html.escape(res['action'])}"
)
img_buf = render_trend_chart_bytes(df_recent, target_dev, res["risk_level"])
send_telegram_photo_async(token, chat_id, caption, img_buf, self._enqueue_log)
# ==========================================================================
# UI 佇列刷新與圖表更新
# ==========================================================================
def _poll_ui_queue(self):
try:
while True:
event_type, payload = self.ui_queue.get_nowait()
if event_type == "log":
self.log_text.insert(tk.END, payload + "\n")
self.log_text.see(tk.END)
elif event_type == "llm_banner":
self.llm_report_var.set(payload)
elif event_type == "new_device":
self.device_combo["values"] = payload
elif event_type == "refresh":
if not payload.empty and payload.iloc[-1]["device_id"] == self.selected_device:
self._refresh_dashboard(payload)
except queue.Empty:
pass
self.root.after(200, self._poll_ui_queue)
def _refresh_dashboard(self, df_recent: pd.DataFrame):
latest = df_recent.iloc[-1]
dev_name = str(latest["device_id"])
self.kpi_vars["device"].set(f"{dev_name} ({str(latest['timestamp'])[-8:]})")
self.kpi_vars["temp"].set(f"{latest['temp']:.1f} °C")
self.kpi_vars["humidity"].set(f"{latest['humidity']:.1f} %")
self.kpi_vars["current"].set(f"{latest['current']:.1f} A")
risk = str(latest["risk_level"] or "正常")
self.kpi_vars["risk"].set(risk)
if risk == "危險":
self.risk_card.config(bg="#FFCDD2")
self.risk_lbl.config(bg="#FFCDD2", fg="#B71C1C")
elif risk == "注意":
self.risk_card.config(bg="#FFF9DB")
self.risk_lbl.config(bg="#FFF9DB", fg="#E67700")
else:
self.risk_card.config(bg="#EBFBEE")
self.risk_lbl.config(bg="#EBFBEE", fg="#2B8A3E")
self.tree.delete(*self.tree.get_children())
for _, row in df_recent.iloc[::-1].iterrows():
self.tree.insert("", tk.END, values=(
int(row["id"]), row["device_id"], row["timestamp"],
f"{row['temp']:.1f}", f"{row['humidity']:.1f}", f"{row['current']:.1f}",
"ON" if row["relay_state"] else "OFF", row["risk_level"]
))
self.fig.clear()
axes = self.fig.subplots(3, 1, sharex=True)
x_labels = [str(ts)[-8:] for ts in df_recent["timestamp"]]
x_idx = np.arange(len(df_recent))
for ax, (col, ylabel, color) in zip(axes, [("temp", "溫度 (°C)", "#D62728"), ("humidity", "濕度 (%)", "#1F77B4"), ("current", "電流 (A)", "#2CA02C")]):
ax.plot(x_idx, df_recent[col].to_numpy(), color=color, marker="o", markersize=4, linewidth=1.5)
ax.set_ylabel(ylabel, fontsize=9.5)
ax.grid(True, linestyle="--", alpha=0.4)
axes[0].set_title(f"[{dev_name}] 近 {len(df_recent)} 筆感測趨勢", fontsize=10.5, fontweight="bold")
axes[2].set_xticks(x_idx)
axes[2].set_xticklabels(x_labels, rotation=25, ha="right", fontsize=8.5)
self.fig.tight_layout()
self.canvas.draw()
if __name__ == "__main__":
root = tk.Tk()
app = LLMSensorMonitorApp(root)
root.mainloop()
快速測試步驟
執行
llm_iot_gateway.py。點擊 「▶ 啟動 MQTT 監控」 收到 Wokwi 傳來的至少 1 筆數據後,點擊 「📤 測試發送趨勢圖」 或 「🧠 執行 LLM 診斷並推播」,Telegram 就會立刻收到附帶三軸趨勢圖的報告;若有任何網路或 Token 衝突,下方黑色日誌視窗也會明確印出原因。




沒有留言:
張貼留言