Myu

2026年2月27日金曜日

cloudflareのトンネル利用

これまで、cloudflareのプロキシーは利用していたが、グローバルIpアドレスをルータのものをDNSに設定していたので、Ipアドレスが変更になった途端、外部からアクセスできなくなった。自分では、自動更新の設定なっていたつもりだったけど、よく調べたら、なってなかったようで、結局は、トンネルを作らないとだめだったよう。cloudflareとraspiの間で独自プロトコルでトンネルを作り、常時接続状態にする仕組みのよう。早速、AIに聞きながらraspiにツールをいれ、設定変更。これで、Ipアドレス変更を気にしなくてもよくなり、だいぶ管理は楽になる。

※この方式にしたところ、外部からのアクセスログが正しく記録されなくなってしまった。いろいろ、試行錯誤した結果わかったことは。ヘッダー名: Cloudflareの仕様により、元のIPは CF-Connecting-IP という名前で送られてくるので、それを使うようにする設定が必要らしい。

・sudo a2enmod remoteip

・トンネルでlocalhost:8080でbottleを指定したのがよくなかった。apacheのログを取りたい場合はapache経由のためlocalhost:80にする必要あった。

・ログ形式(apache2.conf)で

LogFormat "%v:%p %a %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" vhost_combined
LogFormat "%a %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%a %l %u %t \"%r\" %>s %O" common

内部設定(000-default.conf)で

RemoteIPHeader CF-Connecting-IP
RemoteIPInternalProxy 127.0.0.1

変更が必要。

sudo systemctl restart apache2 で再起動。

2026年2月26日木曜日

bottleのformで文字化け

bottleのformのPostで全角文字が文字化けしてしまい、原因がつかめず苦労しました。結局は、対症療法的ですが、以下のようにして解決。

def schedule_edit_post():

　 schedules = load_schedule()

　 new_schedules = []

　 for i, s in enumerate(schedules):

　　　 start = request.forms.get(f"start{i}")

　　　 end = request.forms.get(f"end{i}")

　　　 #title = request.forms.get(f"title{i}")

　　　 title = request.forms.get(f"title{i}").encode('latin1').decode('utf-8')

　いったん、latin1だったものをutf-8にデコードするという、二段構えで解決。bottleのバージョンが古くなってきたから？

2026年2月22日日曜日

raspiでＰＣのタイマー起動2

複数の予約できるようにアップデートしてみた。

**********bottle******
#PC on off schedule
SCHEDULE_FILE = "/home/pi/schedule.json"
def load_schedule():
    if not os.path.exists(SCHEDULE_FILE):
        return {}
    with open(SCHEDULE_FILE, "r") as f:
        return json.load(f)
def save_schedule(s):
    tmp = SCHEDULE_FILE + ".tmp"
    with open(tmp, "w") as f:
        json.dump(s, f, indent=2)
    os.replace(tmp, SCHEDULE_FILE)
# 現在のschedule取得
@app.get("/py/schedule")
@local_only
def get_schedule():
    response.content_type = "application/json"
    return load_schedule()

@app.get("/py/schedule/edit")
@local_only
def schedule_edit():
    s = load_schedule()
    html = "<html><body><h2>スケジュール設定</h2><form method='post'>"
    for i, sched in enumerate(s):
      start = sched["start"]
      end = sched["end"]
      html += f"""
      <p>スケジュール {i+1}</p>
      開始:<br>
      <input type="datetime-local" name="start{i}" value="{start.replace(' ', 'T') if start else ''}"><br>
      終了:<br>
      <input type="datetime-local" name="end{i}" value="{end.replace(' ', 'T') if end else ''}"><br><br>
      """
    html += """
    <h4>新しいスケジュール</h4>
    開始:<br><input type="datetime-local" name="start_new"><br>
    終了:<br><input type="datetime-local" name="end_new"><br><br>
    <input type="submit" value="保存">
    </form></body></html>
    """
    return html
  
@app.post("/py/schedule/edit")
@local_only
def schedule_edit_post():
    schedules = load_schedule()
    new_schedules = []

# 既存スケジュールの更新
    for i, s in enumerate(schedules):
        start = request.forms.get(f"start{i}")
        end   = request.forms.get(f"end{i}")
        if start and end:
            start = start.replace("T", " ") + ":00"
            end   = end.replace("T", " ") + ":00"
            new_schedules.append({"start": start, "end": end})

# 新しいスケジュールがあれば追加
    start_new = request.forms.get("start_new")
    end_new   = request.forms.get("end_new")
    if start_new and end_new:
        start_new = start_new.replace("T", " ") + ":00"
        end_new   = end_new.replace("T", " ") + ":00"
        new_schedules.append({"start": start_new, "end": end_new})

save_schedule(new_schedules)

return """
    <html><body>
    保存しました<br>
    <a href="/py/schedule/edit">戻る</a>
    </body></html>
    """
*********gpio_control.py***********
import RPi.GPIO as GPIO
import time
import subprocess
import json
from datetime import datetime, timedelta
import os
IN_PIN = 22       # タッチセンサー入力
OUT_PIN = 4       # ON/OFFパルス出力
SCHEDULE_FILE = "/home/pi/schedule.json"  # タイマー用JSON
PC_IP = "192.168.1.21"  # PINGチェックするPC
GPIO.setmode(GPIO.BCM)
GPIO.setup(IN_PIN, GPIO.IN, pull_up_down=GPIO.PUD_DOWN)
GPIO.setup(OUT_PIN, GPIO.OUT, initial=GPIO.LOW)
def trigger(tm):
    GPIO.output(OUT_PIN, GPIO.HIGH)
    time.sleep(tm)
    GPIO.output(OUT_PIN, GPIO.LOW)
    print(f"{datetime.now()} Trigger executed")
def is_pc_on():
    try:
        result = subprocess.run(
            ["ping", "-c", "1", "-W", "1", PC_IP],
            stdout=subprocess.DEVNULL,
            stderr=subprocess.DEVNULL
        )
        return result.returncode == 0
    except:
        return False
def load_schedule():
    if not os.path.exists(SCHEDULE_FILE):
        return []
    with open(SCHEDULE_FILE) as f:
        return json.load(f)
def check_timer(schedules):
    now = datetime.now()
    for sched in schedules:
        start = datetime.strptime(sched["start"], "%Y-%m-%d %H:%M:%S")
        end   = datetime.strptime(sched["end"],   "%Y-%m-%d %H:%M:%S")
        if start <= now <= end:
            return True
    return False
prevflg = False  # 直前のON/OFF状態
try:
    while True:
        schedules = load_schedule()
        timer_flag = check_timer(schedules)
        touch_flag = GPIO.input(IN_PIN) == GPIO.HIGH
        #print(timer_flag)

curflg = timer_flag or touch_flag
        if curflg != prevflg:
          if curflg == False :
             if is_pc_on():
               trigger(1)
          else :
             if is_pc_on()==False:
               trigger(0.1)
          prevflg = curflg
        time.sleep(1)  # 1秒ごとにチェック
finally:
    GPIO.cleanup()

・複数にすることで、複雑度が増して解決が難しかった。そこで、タイマーにしても、タッチセンサーにしても、統一したflagを使うことにして、単純化したらうまくいった。flagがon->offになる場合は、pingでPCをチェックしoffならそのまま、onならoffにするためのHigh信号triggerとし、flagがoff->onになる場合は、pingによりPCチェックをして、onならそのまま、offならonにするためのHigh信号triggerとする。

・offにするためのHigh信号triggerは、長めの1秒にしてやる必要があった。

raspiでPCのタイマー起動

PCをraspiからタイマー起動、Offできるようにしてみた。

*********gpio_control.py
  
import RPi.GPIO as GPIO
import time
import json
from datetime import datetime, timedelta
import subprocess

IN_PIN = 22
OUT_PIN = 4
SCHEDULE_FILE = "/home/pi/schedule.json"

GPIO.setmode(GPIO.BCM)
GPIO.setup(IN_PIN, GPIO.IN, pull_up_down=GPIO.PUD_DOWN)
GPIO.setup(OUT_PIN, GPIO.OUT, initial=GPIO.LOW)

start_done = False
end_done = False
trigger_active_until = None

PC_IP = "192.168.1.21"   # ←PCのIP

def is_pc_on():
    try:
        result = subprocess.run(
            ["ping", "-c", "1", "-W", "1", PC_IP],
            stdout=subprocess.DEVNULL,
            stderr=subprocess.DEVNULL
        )
        return result.returncode == 0
    except:
        return False

def load_schedule():
    try:
        with open(SCHEDULE_FILE) as f:
            s = json.load(f)
        start = datetime.strptime(s["start"], "%Y-%m-%d %H:%M:%S")
        end   = datetime.strptime(s["end"], "%Y-%m-%d %H:%M:%S")
        return start, end
    except:
        return None, None
  
  
def trigger():
    global trigger_active_until
    GPIO.output(OUT_PIN, GPIO.HIGH)
    trigger_active_until = datetime.now() + timedelta(seconds=1)
    print("Trigger executed")

try:
    while True:
        start, end = load_schedule()
        now = datetime.now()

# ★追加：未来スケジュールならリセット
        if start and now < start:
            start_done = False

if end and now < end:
            end_done = False

# 開始トリガー
        if start and not start_done and start <= now <= start + timedelta(seconds=30):
            print("Start trigger")
            trigger()
            start_done = True
        # 終了トリガー
        if end and not end_done and end <= now <= end + timedelta(seconds=30):
            print("End trigger")
            trigger()
            end_done = True
        # trigger期間中は監視をスキップ
        if trigger_active_until and now < trigger_active_until:
            pass
        else:
            if trigger_active_until:
               GPIO.output(OUT_PIN, GPIO.LOW)
               trigger_active_until = None

# 通常監視
            if GPIO.input(IN_PIN) == GPIO.HIGH:
               GPIO.output(OUT_PIN, GPIO.HIGH)
            else:
               GPIO.output(OUT_PIN, GPIO.LOW)

time.sleep(1)

finally:
    GPIO.cleanup()
                                                               
***********gpio_control.service
                                               
Description=GPIO制御スクリプト
After=network.target

[Service]
ExecStart=/usr/bin/python3 /home/gpio_control.py
WorkingDirectory=/home
StandardOutput=inherit
StandardError=inherit
Restart=always
User=root

[Install]
WantedBy=multi-user.target
                                                               
***********bottle
                                                               #PC on off schedule
SCHEDULE_FILE = "/home/pi/schedule.json"
def load_schedule():
    if not os.path.exists(SCHEDULE_FILE):
        return {}
    with open(SCHEDULE_FILE, "r") as f:
        return json.load(f)
def save_schedule(s):
    tmp = SCHEDULE_FILE + ".tmp"
    with open(tmp, "w") as f:
        json.dump(s, f, indent=2)
    os.replace(tmp, SCHEDULE_FILE)
# 現在のschedule取得
@app.get("/py/schedule")
def get_schedule():
    response.content_type = "application/json"
    return load_schedule()
# schedule設定
@app.post("/py/schedule")
def set_schedule():
    data = request.json
    # 形式チェック＆統一
    start = datetime.strptime(data["start"], "%Y-%m-%d %H:%M:%S")
    end   = datetime.strptime(data["end"], "%Y-%m-%d %H:%M:%S")
    schedule = {
        "start": start.strftime("%Y-%m-%d %H:%M:%S"),
        "end":   end.strftime("%Y-%m-%d %H:%M:%S")
    }
    save_schedule(schedule)
    return {"status": "ok", "schedule": schedule}
@app.get("/py/schedule/edit")
def schedule_edit():

s = load_schedule()

start = s.get("start", "")
    end   = s.get("end", "")

return f"""
    <html>
    <body>
    <h2>スケジュール設定</h2>

開始:<br>
      <input type="datetime-local" name="start" value="{start.replace(' ', 'T') if start else ''}">
      <br><br>

終了:<br>
      <input type="datetime-local" name="end" value="{end.replace(' ', 'T') if end else ''}">
      <br><br>

</form>

</body>
    </html>
    """

@app.post("/py/schedule/edit")
def schedule_edit_post():

start = request.forms.get("start")
    end   = request.forms.get("end")

# datetime-local → json形式へ変換
    start = start.replace("T", " ") + ":00"
    end   = end.replace("T", " ") + ":00"

schedule = {
        "start": start,
        "end": end
    }

save_schedule(schedule)

return """
    <html>
    <body>
    保存しました<br>
    <a href="/py/schedule/edit">戻る</a>
    </body>
    </html>
    """

すでに、22番号Pinをタッチセンサで起動させるようにしていたので、それとの絡みで少し複雑になってしまった。raspiからWeb画面で日時を設定できるようにしてみた。複数セットできると便利かもしれない。

2026年2月8日日曜日

esp32温度センサ動作で苦労する

カメラも動作させているためか、FNK0060なるESP32 は、BMP280ライブラリの中の名称のダブりなどでうまくビルドできず、苦労した。google AIからかなりハードよりのコードを出してもらいなんとか解決。　また、I2Cは、２つが限度らしく、リレー動作がひとつあまってしまう。結局、DS18B20(苗床には土にさせるし、3個以上も追加できるのでこちらのほうがいい）、SSRも使用することに。

*********esp32***********
  #include <HTTPClient.h>
#include <Arduino_ESP32_OTA.h>

#include "esp_camera.h"
#include <WiFi.h>
#include <ESPAsyncWebServer.h>
#include "SPIFFS.h"
//for BMP280
#include <Wire.h>
#include <Preferences.h>

//for ds18b20
#include <OneWire.h>
#include <DallasTemperature.h>

struct BME280_Data {
  float temp;
  float pres;
  float builtin;
};

Preferences prefs;

#define ONE_WIRE_BUS 13 // データ(黄)で使用するポート番号
#define SENSER_BIT    9      // 精度の設定bit
OneWire oneWire(ONE_WIRE_BUS);
DallasTemperature sensors(&oneWire);
DeviceAddress tempd1 = { 0x28, 0xBC, 0x04, 0xB4, 0x00, 0x00, 0x00, 0xE4 }; //1つ目のDS18B20のアドレス
DeviceAddress tempd2 = { 0x28, 0x4B, 0x0A, 0xB3, 0x00, 0x00, 0x00, 0x37}; //2つ目のDS18B20のアドレス
DeviceAddress tempd3 = { 0x28, 0x11, 0x26, 0xB3, 0x00, 0x00, 0x00, 0x0F}; //3つ目のDS18B20のアドレス
DeviceAddress tempd4 = { 0x28, 0x25, 0x0D, 0xB4, 0x00, 0x00, 0x00, 0x30}; //4つ目のDS18B20のアドレス

// heaterが使うセンサ
int htr[3] = {3,4,5};

#define BMP_ADDR1 0x76
#define BMP_ADDR2 0x77

// 各センサー用の補正係数構造体
struct BMP280_Trim {
  uint16_t dig_T1, dig_P1;
  int16_t  dig_T2, dig_T3, dig_P2, dig_P3, dig_P4, dig_P5, dig_P6, dig_P7, dig_P8, dig_P9;
  int32_t  t_fine;
} trim1, trim2;

// 書き込み・読み取り関数に「アドレス」を引数で渡せるようにします
void writeReg(uint8_t addr, uint8_t reg, uint8_t data) {
  Wire.beginTransmission(addr);
  Wire.write(reg);
  Wire.write(data);
  Wire.endTransmission();
}

float d1temp=0.0;
float d2temp=0.0;
float d3temp=0.0;
float d4temp=0.0;

BME280_Data getBMPData(uint8_t addr, BMP280_Trim *trim);

float setTempA1 = 25.0;
float setTempA2 = 25.0;
float setTempA3 = 25.0;
float hysteresis = 0.5;

unsigned long lastStatsTime = 0;
unsigned long A1_on_accum_ms = 0;
unsigned long A2_on_accum_ms = 0;
unsigned long A3_on_accum_ms = 0;
uint32_t A1_on_count = 0;
uint32_t A2_on_count = 0;
uint32_t A3_on_count = 0;

unsigned long a1_on_time = 0;  // A1がONになった時刻
unsigned long a2_on_time = 0;  // A1がONになった時刻
unsigned long a3_on_time = 0;  // A1がONになった時刻

int newMinutes = 10;
unsigned long maxonms = newMinutes * 60UL * 1000UL; // 10分

// 補正係数読み取り
void readTrim(uint8_t addr, BMP280_Trim *trim) {
  uint8_t data[24]; // 一時的なバッファ

Wire.beginTransmission(addr);
  Wire.write(0x88); // 補正データ開始レジスタ
  Wire.endTransmission();  
  Wire.requestFrom(addr, (uint8_t)24);
  if (Wire.available() == 24) {
    for(int i = 0; i < 24; i++) {
      data[i] = Wire.read();
    }    
    // 各係数をリトルエンディアンで結合して構造体に格納
trim->dig_T1 = (uint16_t)((data[1] << 8) | data[0]);
trim->dig_T2 = (int16_t)((data[3] << 8) | data[2]);
trim->dig_T3 = (int16_t)((data[5] << 8) | data[4]);
trim->dig_P1 = (uint16_t)((data[7] << 8) | data[6]);
trim->dig_P2 = (int16_t)((data[9] << 8) | data[8]);
trim->dig_P3 = (int16_t)((data[11] << 8) | data[10]);
trim->dig_P4 = (int16_t)((data[13] << 8) | data[12]);
trim->dig_P5 = (int16_t)((data[15] << 8) | data[14]);
trim->dig_P6 = (int16_t)((data[17] << 8) | data[16]);
trim->dig_P7 = (int16_t)((data[19] << 8) | data[18]);
trim->dig_P8 = (int16_t)((data[21] << 8) | data[20]);
trim->dig_P9 = (int16_t)((data[23] << 8) | data[22]);
  }
}

// --- データ取得と計算のメイン関数 ---
BME280_Data getBMPData(uint8_t addr, BMP280_Trim *trim) {
  uint8_t data[6];
  Wire.beginTransmission(addr);
  Wire.write(0xF7); // 気圧(3byte) + 温度(3byte) の開始レジスタ
  Wire.endTransmission();
  Wire.requestFrom(addr, (uint8_t)6);
  for(int i=0; i<6; i++) data[i] = Wire.read();
  int32_t adc_P = ((uint32_t)data[0] << 12) | ((uint32_t)data[1] << 4) | ((data[2] >> 4) & 0x0F);
  int32_t adc_T = ((uint32_t)data[3] << 12) | ((uint32_t)data[4] << 4) | ((data[5] >> 4) & 0x0F);
  // --- 温度計算 ---
  int32_t var1T, var2T;
  var1T = ((((adc_T >> 3) - ((int32_t)trim->dig_T1 << 1))) * ((int32_t)trim->dig_T2)) >> 11;
  var2T = (((((adc_T >> 4) - ((int32_t)trim->dig_T1)) * ((adc_T >> 4) - ((int32_t)trim->dig_T1))) >> 12) * ((int32_t)trim->dig_T3)) >> 14;
  trim->t_fine = var1T + var2T;
  float temp = (trim->t_fine * 5 + 128) >> 8;
  // --- 気圧計算 ---
  int64_t var1P, var2P, p;
  var1P = ((int64_t)trim->t_fine) - 128000;
  var2P = var1P * var1P * (int64_t)trim->dig_P6;
  var2P = var2P + ((var1P * (int64_t)trim->dig_P5) << 17);
  var2P = var2P + (((int64_t)trim->dig_P4) << 35);
  var1P = ((var1P * var1P * (int64_t)trim->dig_P3) >> 8) + ((var1P * (int64_t)trim->dig_P2) << 12);
  var1P = (((((int64_t)1) << 47) + var1P)) * ((int64_t)trim->dig_P1) >> 33;  
  if (var1P == 0) return {0, 0}; // ゼロ除算防止
  p = 1048576 - adc_P;
  p = (((p << 31) - var2P) * 3125) / var1P;
  var1P = (((int64_t)trim->dig_P9) * (p >> 13) * (p >> 13)) >> 25;
  var2P = (((int64_t)trim->dig_P8) * p) >> 19;
  p = ((p + var1P + var2P) >> 8) + (((int64_t)trim->dig_P7) << 4);
   //内蔵温度計
  float builtin = temperatureRead();
  float heater=0.0; //工事中  
  return { temp / 100.0f, (float)p / 25600.0f,builtin};
}

// ===== WiFi設定 =====

struct WifiCred {
  String ssid;
  String pass;
};
// 先に空のStringで宣言
String ssid1, ssid2, password,lineToken;
WifiCred wifiList[2]; // 配列だけ先に作っておく
void loadConfig() {
  if(!SPIFFS.begin(true)) return;
  File file = SPIFFS.open("/config.txt");
  if(!file) return;
  while(file.available()){
    String line = file.readStringUntil('\n');
    line.trim();
    if(line.startsWith("SSID1=")) ssid1 = line.substring(6);
    else if(line.startsWith("SSID2=")) ssid2 = line.substring(6);
    else if(line.startsWith("PASS=")) password = line.substring(5);
    else if(line.startsWith("LINE_TOKEN=")) lineToken = line.substring(11);
  }
  file.close();
  // 読み込んだ後に配列にセット
  wifiList[0] = {ssid1, password};
  wifiList[1] = {ssid2, password};
}
const int WIFI_NUM = 2;
void connectBestWiFi() {
  int n = WiFi.scanNetworks();
  int best = -1;
  int bestRssi = -1000;
  for (int i = 0; i < n; i++) {
    for (int j = 0; j < WIFI_NUM; j++) {
      if (WiFi.SSID(i) == wifiList[j].ssid) {
        int rssi = WiFi.RSSI(i);
        if (rssi > bestRssi) {
          bestRssi = rssi;
          best = j;
        }
      }
    }
  }
  if (best >= 0) {
    WiFi.begin(wifiList[best].ssid, wifiList[best].pass);
  }
}

IPAddress local_IP(192,168,1,30);
IPAddress gateway(192,168,1,1);
IPAddress subnet(255,255,255,0);

AsyncWebServer server(80);

#define A1_PIN 14  // A1 Line
#define A2_PIN 2  // 内蔵LED A2 Line
//#define B_PIN 13  // B Line 使わない  13はDs18b20で使用
#define A3_PIN 15 //SSR

bool BState = false;  // LEDの現在状態
bool A1State = false;
bool A2State = false;
bool A3State = false;

// ===== カメラピン定義（FNK0060 / WROVER-KIT） =====
#define CAMERA_MODEL_WROVER_KIT

#if defined(CAMERA_MODEL_WROVER_KIT)
#define PWDN_GPIO_NUM  -1
#define RESET_GPIO_NUM -1
#define XCLK_GPIO_NUM  21
#define SIOD_GPIO_NUM  26
#define SIOC_GPIO_NUM  27

#define Y9_GPIO_NUM    35
#define Y8_GPIO_NUM    34
#define Y7_GPIO_NUM    39
#define Y6_GPIO_NUM    36
#define Y5_GPIO_NUM    19
#define Y4_GPIO_NUM    18
#define Y3_GPIO_NUM    5
#define Y2_GPIO_NUM    4
#define VSYNC_GPIO_NUM 25
#define HREF_GPIO_NUM  23
#define PCLK_GPIO_NUM  22
#endif

// ===== カメラ初期化 =====
void initCamera() {
  camera_config_t config;
  config.ledc_channel = LEDC_CHANNEL_0;
  config.ledc_timer   = LEDC_TIMER_0;

config.pin_d0 = Y2_GPIO_NUM;
  config.pin_d1 = Y3_GPIO_NUM;
  config.pin_d2 = Y4_GPIO_NUM;
  config.pin_d3 = Y5_GPIO_NUM;
  config.pin_d4 = Y6_GPIO_NUM;
  config.pin_d5 = Y7_GPIO_NUM;
  config.pin_d6 = Y8_GPIO_NUM;
  config.pin_d7 = Y9_GPIO_NUM;

config.pin_xclk     = XCLK_GPIO_NUM;
  config.pin_pclk     = PCLK_GPIO_NUM;
  config.pin_vsync    = VSYNC_GPIO_NUM;
  config.pin_href     = HREF_GPIO_NUM;
  config.pin_sccb_sda = SIOD_GPIO_NUM;
  config.pin_sccb_scl = SIOC_GPIO_NUM;
  config.pin_pwdn     = PWDN_GPIO_NUM;
  config.pin_reset    = RESET_GPIO_NUM;

config.xclk_freq_hz = 20000000;
  config.pixel_format = PIXFORMAT_JPEG;
  config.frame_size   = FRAMESIZE_VGA;
  config.jpeg_quality = 15;
  config.fb_count     = 1; // 最小構成で安定

Serial.println("Camera init start");
  esp_err_t err = esp_camera_init(&config);
  if(err != ESP_OK){
    Serial.printf("Camera init failed: 0x%x\n", err);
  } else {
    Serial.println("Camera init OK");
  }
}

// ===== キャプチャタスク =====
void captureTask(void *pvParameters) {
  while(true){
    camera_fb_t * fb = esp_camera_fb_get();
    if(fb){
      File f = SPIFFS.open("/latest.jpg", FILE_WRITE);
      if(f){
        f.write(fb->buf, fb->len);
        f.close();
        Serial.printf("Saved latest.jpg (%d bytes)\n", fb->len);
      } else {
        Serial.println("SPIFFS open failed");
      }
      esp_camera_fb_return(fb);
    } else {
      Serial.println("Camera capture failed");
    }
    vTaskDelay(pdMS_TO_TICKS(10000)); // 10秒毎
  }
}

void dtemp(){
  sensors.requestTemperatures();              // 温度取得要求 ds18b20
    delay(800);
    d1temp=sensors.getTempC(tempd1);
    delay(200);
    d2temp=sensors.getTempC(tempd2);
    delay(200);
    d3temp=sensors.getTempC(tempd3);
    delay(200);
    d4temp=sensors.getTempC(tempd4);
 
}

// ===== setup =====
void setup() {
  Serial.begin(115200);
  delay(500);
   sensors.setResolution(SENSER_BIT); //ds18b20　精度セット
    delay(1000);

prefs.begin("heater", false);
setTempA1 = prefs.getFloat("setA1", 25.0);
setTempA2 = prefs.getFloat("setA2", 25.0);
hysteresis = prefs.getFloat("hys", 0.5);
newMinutes=prefs.getInt("newMinutes",10);
htr[0]= prefs.getInt("htr1", 3);
htr[1] = prefs.getInt("htr2", 4);
htr[2] = prefs.getInt("htr3", 5);
prefs.end();
     
  Wire.begin(33, 32);
  delay(100);
  
   // センサー1 (0x76) 初期化
  writeReg(BMP_ADDR1, 0xF4, 0x27);
  readTrim(BMP_ADDR1, &trim1); 
  
  // センサー2 (0x77) 初期化
  writeReg(BMP_ADDR2, 0xF4, 0x27);
  readTrim(BMP_ADDR2, &trim2);

Serial.println("Dual BMP280 Init OK");

if(!SPIFFS.begin(true)){
    Serial.println("LittleFS Mount Failed");
    return;
  }
    loadConfig();

initCamera();

WiFi.mode(WIFI_STA);
  WiFi.config(local_IP, gateway, subnet);
  
  //WiFi.begin(ssid, password);  
  connectBestWiFi();
  
  while(WiFi.status() != WL_CONNECTED){
    delay(500);
  }
  Serial.print("WiFi connected: ");
  Serial.println(WiFi.localIP());

// /index.html を返す
  server.on("/", HTTP_GET, [](AsyncWebServerRequest *request){
    request->send(SPIFFS, "/index.html", "text/html");
  });

server.on("/config.html", HTTP_GET, [](AsyncWebServerRequest *request){
  request->send(SPIFFS, "/config.html", "text/html");
});

// /latest.jpg はキャプチャ画像
  server.on("/latest.jpg", HTTP_GET, [](AsyncWebServerRequest *request){
    if(!SPIFFS.exists("/latest.jpg")){
      request->send(503, "text/plain", "Image not ready");
      return;
    }
    request->send(SPIFFS, "/latest.jpg", "image/jpeg");
  });

//pinMode(B_PIN, OUTPUT);
  pinMode(A1_PIN, OUTPUT);
  pinMode(A2_PIN, OUTPUT);
  pinMode(A3_PIN, OUTPUT);
  digitalWrite(A1_PIN,  LOW);
  digitalWrite(A2_PIN,  LOW);
  digitalWrite(A3_PIN,  LOW);
  
server.on("/heatera1", HTTP_GET, [](AsyncWebServerRequest *request){
    if(request->hasParam("toggle")){
        A1State = !A1State;
        digitalWrite(A1_PIN, A1State ? HIGH : LOW);
    }
    String stateStr = A1State ? "on" : "off";
    request->send(200, "text/plain", stateStr);
});

server.on("/heatera2", HTTP_GET, [](AsyncWebServerRequest *request){
    if(request->hasParam("toggle")){
        A2State = !A2State;
        digitalWrite(A2_PIN, A2State ? HIGH : LOW);
    }
    String stateStr = A2State ? "on" : "off";
    request->send(200, "text/plain", stateStr);
});

server.on("/heatera3", HTTP_GET, [](AsyncWebServerRequest *request){
    if(request->hasParam("toggle")){
        A3State = !A3State;
        digitalWrite(A3_PIN, A3State ? HIGH : LOW);
    }
    String stateStr = A3State ? "on" : "off";
    request->send(200, "text/plain", stateStr);
});

// 全ボタンの状態をまとめて返す API
server.on("/allHeaterStatus", HTTP_GET, [](AsyncWebServerRequest *request){
    String json = "{";
   // json += "\"b\":\"" + String(BState ? "on" : "off") + "\",";
    json += "\"a1\":\"" + String(A1State ? "on" : "off") + "\",";
    json += "\"a2\":\"" + String(A2State ? "on" : "off") + "\",";
    json += "\"a3\":\"" + String(A3State ? "on" : "off") + "\"";
    json += "}";
    request->send(200, "application/json", json);
});

server.on("/data", HTTP_GET, [](AsyncWebServerRequest *request){
  BME280_Data s1 = getBMPData(0x76, &trim1);
  BME280_Data s2 = getBMPData(0x77, &trim2);  
   dtemp();

String json = "{";
  json += "\"temp1\":" + String(s1.temp, 2) + ",";
  json += "\"pres1\":" + String(s1.pres, 2) + ",";
  json += "\"temp2\":" + String(s2.temp, 2) + ",";
  json += "\"builtin\":" + String(s1.builtin, 2) + ",";
  json += "\"pres2\":" + String(s2.pres, 2) + ",";
  json += "\"d1\":" + String(d1temp, 1) + ",";
  json += "\"d2\":" + String(d2temp, 1) + ",";
  json += "\"d3\":" + String(d3temp, 1) + ",";
  json += "\"d4\":" + String(d4temp, 1) ;
  json += "}";  
  request->send(200, "application/json", json);
});

server.on("/setConfig", HTTP_GET, [](AsyncWebServerRequest *request){

bool updated = false;

if(request->hasParam("setA1")){
    setTempA1 = request->getParam("setA1")->value().toFloat();
    updated = true;
  }
  if(request->hasParam("setA2")){
    setTempA2 = request->getParam("setA2")->value().toFloat();
    updated = true;
  }
   if(request->hasParam("setA3")){
    setTempA3 = request->getParam("setA3")->value().toFloat();
    updated = true;
  }
  if(request->hasParam("hys")){
    hysteresis = request->getParam("hys")->value().toFloat();
    updated = true;
  }

if(request->hasParam("htr1")){
    htr[0] = request->getParam("htr1")->value().toInt();
    updated = true;
  }

if(request->hasParam("htr2")){
    htr[1] = request->getParam("htr2")->value().toInt();
    updated = true;
  }

if(request->hasParam("htr3")){
    htr[2] = request->getParam("htr3")->value().toInt();
    updated = true;
  }

if(request->hasParam("newMinutes")){
    newMinutes = request->getParam("newMinutes")->value().toInt();
    updated = true;
  }

if(updated){
    prefs.begin("heater", false);
    prefs.putFloat("setA1", setTempA1);
    prefs.putFloat("setA2", setTempA2);
    prefs.putFloat("setA3", setTempA3);
    prefs.putFloat("hys", hysteresis);
    prefs.putInt("newMinutes", newMinutes);
    for(int i=0; i<3; i++){
     prefs.putInt(("htr" + String(i+1)).c_str(), htr[i]);
    }

prefs.end();
  }

request->send(200, "text/plain", "OK");
});

server.on("/getConfig", HTTP_GET, [](AsyncWebServerRequest *request){

String json = "{";
  json += "\"setA1\":" + String(setTempA1, 2) + ",";
  json += "\"setA2\":" + String(setTempA2, 2) + ",";
  json += "\"setA3\":" + String(setTempA3, 2) + ",";
  json += "\"newMinutes\":" + String(newMinutes) + ",";
  for(int i=0; i<3; i++){
   json += "\"htr" + String(i+1) + "\":" + String(htr[i]) + ",";
  }

json += "\"hysteresis\":" + String(hysteresis, 2);
  json += "}";

request->send(200, "application/json", json);
});

server.on("/heaterStats", HTTP_GET, [](AsyncWebServerRequest *request){
  unsigned long now = millis();
  unsigned long dt = now - lastStatsTime;
  lastStatsTime = now;

// 現在の温度もついでに取得
  BME280_Data s1 = getBMPData(BMP_ADDR1, &trim1);
  BME280_Data s2 = getBMPData(BMP_ADDR2, &trim2);
  dtemp();

String json = "{";
  json += "\"dt_ms\":" + String(dt) + ",";
  json += "\"a1_on_time_ms\":" + String(A1_on_accum_ms) + ",";
  json += "\"a2_on_time_ms\":" + String(A2_on_accum_ms) + ",";
  json += "\"a3_on_time_ms\":" + String(A3_on_accum_ms) + ",";
  json += "\"a1_on_count\":" + String(A1_on_count) + ",";
  json += "\"a2_on_count\":" + String(A2_on_count) + ",";
  json += "\"a3_on_count\":" + String(A3_on_count) + ",";
  json += "\"temp1\":" + String(s1.temp, 2) + ",";
  json += "\"temp2\":" + String(s2.temp, 2) + ",";
  json += "\"builtin\":" + String(s2.builtin, 2)+ ",";
  json += "\"d1\":" + String(d1temp, 1) + ",";
  json += "\"d2\":" + String(d2temp, 1) + ",";
  json += "\"d3\":" + String(d3temp, 1) + ",";
  json += "\"d4\":" + String(d4temp, 1) ;
  json += "}";

// ★ リセット（次の区間のため）
  A1_on_accum_ms = 0;
  A2_on_accum_ms = 0;
  A3_on_accum_ms = 0;
  A1_on_count = 0;
  A2_on_count = 0;  
  A3_on_count = 0;

request->send(200, "application/json", json);
});

server.onNotFound([](AsyncWebServerRequest *request){
    request->send(404, "text/plain", "Not found");
  });

server.begin();

// キャプチャタスクを Core 1 で開始
xTaskCreatePinnedToCore(
    captureTask,
    "capture",
    8192,
    NULL,
    1,
    NULL,
    1
  );
}

//temp control
void controlHeaterGeneric(float currentTemp,
                           float setTemp,
                           bool &state,
                           uint8_t pin,
                           unsigned long &on_time
                           )
{

if (currentTemp <= 0.0 || currentTemp > 45.0) {
    state = false;
    digitalWrite(pin, LOW);
    if(currentTemp>45){
      HTTPClient http;
          http.begin("http://192.168.1.103:8080/py/alarm?wav=heaterHot.wav");
          http.GET();
          http.end();
    }
      
    return;  // これで他の制御をスキップ
  }  
  
  bool newState = state;

if (currentTemp < setTemp - hysteresis) {
    newState = true;
  }
  else if (currentTemp > setTemp + hysteresis) {
    newState = false;
  }

// リレーがONになった時刻を記録
  if (!state && newState) on_time = millis();

// 安全対策: 10分以上ONはOFF
  maxonms = newMinutes * 60UL * 1000UL;
  if (state && millis() - on_time > maxonms) {
    newState = false;
    HTTPClient http2;
    http2.begin("http://192.168.1.103:8080/py/alarm?wav=relayOn.wav");
    http2.GET();
    http2.end();
  }

if (newState != state ) {
    state = newState;
    digitalWrite(pin, state ? HIGH : LOW);
    if (pin == A1_PIN) A1_on_count++;
    if (pin == A2_PIN) A2_on_count++;
    if (pin == A3_PIN) A3_on_count++;
  }
  
}

float ctemp(int sensorNo,BME280_Data s1,BME280_Data s2)
{
    if (sensorNo == 0) return -9.99;  // 無効

switch(sensorNo)
    {
        case 1:
            return s1.temp;
        case 2:
            return s2.temp;
        case 3:
            return d1temp;
        case 4:
             return d2temp;
        case 5:
             return d3temp;
        case 6:
            return d4temp;

default:
            return -9.99;  // 範囲外
    }
}

void loop() {
  static unsigned long lastLoop = millis();
  unsigned long now = millis();
  unsigned long dt = now - lastLoop;
  lastLoop = now;

BME280_Data s1 = getBMPData(BMP_ADDR1, &trim1);
  BME280_Data s2 = getBMPData(BMP_ADDR2, &trim2);

// ON時間の積算（RasPiが取りに来るまで）
  if (A1State) A1_on_accum_ms += dt;
  if (A2State) A2_on_accum_ms += dt;
  if (A3State) A3_on_accum_ms += dt;

dtemp(); 
 Serial.printf("d1~4: %.1fC  %.1fC %.1fC %.1fC\n",d1temp,d2temp,d3temp,d4temp); 
 Serial.printf("A1: %.2f C, %.0f hPa　(BltIn %.0fC）\n", s1.temp, s1.pres,s1.builtin);
 Serial.printf("A2: %.2f C, %.0f hPa　 \n", s2.temp, s2.pres);
 Serial.printf("A1State:%s A2State:%s A3State:%s\n",
  A1State ? "ON" : "OFF",
  A2State ? "ON" : "OFF",
  A3State ? "ON" : "OFF"  
);

//引数　(float)現在温度,(float)設定温度,onoff状態(bool),pin,on_time(リレーon時刻保持) 
 controlHeaterGeneric(ctemp(htr[0],s1,s2), setTempA1, A1State, A1_PIN,a1_on_time); 
 controlHeaterGeneric(ctemp(htr[1],s1,s2), setTempA2, A2State, A2_PIN,a2_on_time); 
 controlHeaterGeneric(ctemp(htr[2],s1,s2), setTempA3, A3State, A3_PIN,a3_on_time);

if(WiFi.status() == WL_CONNECTED){
    HTTPClient http3;
    http3.begin("http://192.168.1.103:8080/py/ping"); // 生存確認
    int httpCode = http3.GET();                   // これで送信
    Serial.println(httpCode);        
    http3.end();
  }

delay(9800);
}

*****esp32 index.html******
  <!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="UTF-8">
<title>ESP32 Camera</title>
<style>
  body { margin:0; background:#000; color:#fff; font-family:sans-serif; }
  #camera { display:block; margin:auto; max-width:100%; }
  #timestamp {
    position: fixed;
    left: 10px;
    bottom: 10px;
    background: rgba(0,0,0,0.5);
    padding: 3px 6px;
    border-radius: 4px;
    font-size: 14px;
  }
</style>
</head>
<body>

<td>
<button id="a1Btn">A1</button><span id="htr1"></span>(<span id="setA1"></span>℃)
</td>
<td>
<button id="a2Btn">A2</button><span id="htr2"></span>(<span id="setA2"></span>℃)

</td>
<td>
<button id="a3Btn">A3</button><span id="htr3"></span>(<span id="setA3"></span>℃)
</td>
</tr></table>
<p><span id="temp1">--</span>　<span id="pres1">--</span> 　<span id="temp2">--</span>　<span id="pres2">--</span>　<span id="builtin">--</span>　<span id="d1">--</span>　<span id="d2">--</span>　<span id="d3">--</span>　 <span id="d4">--</span>　hys:<span id="hys"></span></p>
<p id="msg"></p>
<hr>
<h3>ヒーター設定</h3>
<a href="/config.html">設定画面へ</a>
<hr>

const interval = 10000; // ESP32側キャプチャ間隔と同じに
const img = document.getElementById('camera');
const ts = document.getElementById('timestamp');

function updateImage() {
  const t = new Date();
  ts.textContent = t.toLocaleString(); // PC側日時表示
  img.src = '/latest.jpg?t=' + t.getTime(); // キャッシュ回避
  updateSensorData();

loadConfig();
}

function sensStats(num){
 switch (num){
   case 0:
    stats="None";
    break;
   case 1:
    stats=document.getElementById('temp1').textContent;
    break;
   case 2:
    stats=document.getElementById('temp2').textContent;
    break;
   case 3:
    stats=document.getElementById('d1').textContent;
    break;

case 4:
    stats=document.getElementById('d2').textContent;
    break;

case 5:
    stats=document.getElementById('d3').textContent;
    break;

case 6:
    stats=document.getElementById('d4').textContent;
    break;

default:

}
 return stats;
}

const btnMap = {
  a1: document.getElementById('a1Btn'),
  a2: document.getElementById('a2Btn'),
  a3: document.getElementById('a3Btn')
};

const apiMap = {
  a1: '/heatera1',
  a2: '/heatera2',
  a3: '/heatera3',
};

// ボタン押下で toggle & 状態更新
for (const key in btnMap) {
  const btn = btnMap[key];
  const url = apiMap[key];
  btn.addEventListener('click', () => {
    fetch(`${url}?toggle=1`)
      .then(response => response.text())
      .then(() => updateButtons());  // 全ボタン状態を取得して反映
  });
}

// 状態取得・ボタン更新
function updateButtons() {
  fetch('/allHeaterStatus')  // 全部まとめて返すサーバAPI
    .then(response => response.json())
    .then(data => {
      for (const key in btnMap) {
        const btn = btnMap[key];
        if (data[key] === 'on') {
          btn.style.backgroundColor = 'red';
          btn.textContent = `${key.toUpperCase()} On`;
        } else {
          btn.style.backgroundColor = '';
          btn.textContent = `${key.toUpperCase()} OFF`;
        }
      }
    });
}

// ページロード時に初期状態反映
updateButtons();

updateImage();

setInterval(updateImage, interval);

</script>

</body>
</html>

******esp32 config.html********
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Heater Config</title>
<style>
body {
  font-family: Arial, sans-serif;
  margin: 20px;
  background: #f4f4f4;
}
.card {
  background: white;
  padding: 15px;
  border-radius: 8px;
  box-shadow: 0 0 5px rgba(0,0,0,0.1);
  max-width: 420px;
}
h2 {
  margin-top: 0;
}
input {
  width: 80px;
}
.row {
  margin: 8px 0;
}
button {
  margin-top: 10px;
  margin-right: 5px;
}
#msg {
  margin-top: 10px;
  font-size: 0.9em;
}
.nav {
  margin-bottom: 15px;
}
</style>
</head>

<body>

<div class="card">
<h2>ヒーター設定</h2>

<div class="row">
  A1 設定温度:
  <input id="setA1" type="number" step="0.1"> ℃
  　使用センサ：<select id="htr1">
    <option value="0">None</option>
    <option value="1">BMP1</option>
    <option value="2">BMP2</option>
    <option value="3">D1</option>
    <option value="4">D2</option>
    <option value="5">D3</option>
    <option value="6">D4</option>
  </select>
</div>

<div class="row">
  A2 設定温度:
  <input id="setA2" type="number" step="0.1"> ℃
　使用センサ：<select id="htr2">
    <option value="0">None</option>
    <option value="1">BMP1</option>
    <option value="2">BMP2</option>
    <option value="3">D1</option>
    <option value="4">D2</option>
    <option value="5">D3</option>
    <option value="6">D4</option>
  </select>
</div>

<div class="row">
  A3 設定温度:
  <input id="setA3" type="number" step="0.1"> ℃
　使用センサ：<select id="htr3">
    <option value="0">None</option>
    <option value="1">BMP1</option>
    <option value="2">BMP2</option>
    <option value="3">D1</option>
    <option value="4">D2</option>
    <option value="5">D3</option>
    <option value="6">D4</option>
  </select>
</div>

<div class="row">
  ヒステリシス:
  <input id="hys" type="number" step="0.1"> ℃
</div>

<div class="row">
  ヒータ継続制限時間:
  <input id="newMinutes" type="number" step="1">分
</div>

// ===== 設定を読み込む =====
function loadConfig(){
  document.getElementById("msg").textContent = "読み込み中...";

fetch("/getConfig")
    .then(res => res.json())
    .then(data => {
      document.getElementById("setA1").value = data.setA1;
      document.getElementById("setA2").value = data.setA2;
      document.getElementById("setA3").value = data.setA3;
      document.getElementById("newMinutes").value = data.newMinutes;
      document.getElementById("htr1").value = data.htr1;
      document.getElementById("htr2").value = data.htr2;
      document.getElementById("htr3").value = data.htr3;
      document.getElementById("hys").value = data.hysteresis;
      document.getElementById("msg").textContent = "読み込みOK";
    })
    .catch(err => {
      document.getElementById("msg").textContent = "エラー: " + err;
    });
}

// ===== 設定を保存する =====
function saveConfig(){
  const a1 = document.getElementById("setA1").value;
  const a2 = document.getElementById("setA2").value;
  const a3 = document.getElementById("setA3").value;
  const h  = document.getElementById("hys").value;
  const newMinutes  = document.getElementById("newMinutes").value;
  const htr1 = document.getElementById("htr1").value;
  const htr2 = document.getElementById("htr2").value;
  const htr3 = document.getElementById("htr3").value;

document.getElementById("msg").textContent = "送信中...";

const url = `/setConfig?setA1=${a1}&setA2=${a2}&setA3=${a3}&hys=${h}&newMinutes=${newMinutes}&htr1=${htr1}&htr2=${htr2}&htr3=${htr3}`;

fetch(url)
    .then(() => {
      document.getElementById("msg").textContent = "保存しました";
    })
    .catch(err => {
      document.getElementById("msg").textContent = "保存エラー: " + err;
    });
}

// ページ表示時に自動読み込み
window.onload = loadConfig;
</script>

</body>
</html>

// ===== 設定を読み込む =====
function loadConfig(){
  document.getElementById("msg").textContent = "読み込み中...";

fetch("/getConfig")
    .then(res => res.json())
    .then(data => {
      document.getElementById("setA1").value = data.setA1;
      document.getElementById("setA2").value = data.setA2;
      document.getElementById("setA3").value = data.setA3;
      document.getElementById("htr1").value = data.htr1;
      document.getElementById("htr2").value = data.htr2;
      document.getElementById("htr3").value = data.htr3;
      document.getElementById("hys").value = data.hysteresis;
      document.getElementById("msg").textContent = "読み込みOK";
    })
    .catch(err => {
      document.getElementById("msg").textContent = "エラー: " + err;
    });
}

// ===== 設定を保存する =====
function saveConfig(){
  const a1 = document.getElementById("setA1").value;
  const a2 = document.getElementById("setA2").value;
  const a3 = document.getElementById("setA3").value;
  const h  = document.getElementById("hys").value;
  const htr1 = document.getElementById("htr1").value;
  const htr2 = document.getElementById("htr2").value;
  const htr3 = document.getElementById("htr3").value;

document.getElementById("msg").textContent = "送信中...";

const url = `/setConfig?setA1=${a1}&setA2=${a2}&setA3=${a3}&hys=${h}&htr1=${htr1}&htr2=${htr2}&htr3=${htr3}`;

// ページ表示時に自動読み込み
window.onload = loadConfig;
</script>

</body>
</html>
 
  
  *****esp32 config.txt******
  
  SSID1=*****
SSID2=****
PASS=****  
  
  ********bottle*********
#他にも下記コードに応じて適宜import必要
import RPi.GPIO as GPIO

#for alarm speaker relay
GPIO.setmode(GPIO.BCM)      # GPIO番号方式
GPIO.setwarnings(False)
RELAY_PIN = 27
GPIO.setup(RELAY_PIN, GPIO.OUT)
GPIO.output(RELAY_PIN, GPIO.LOW)   # 初期状態：OFF
  
  
  ESP32 = "http://192.168.*.*"

CSV_FILE = "heater_log.csv"

MAX_LINES = 432   # ← 最大行数 ３日分

@app.route('/py/collect')
def collect():
    ts = time.strftime("%Y-%m-%d %H:%M:%S")
    rstatus="ok"
    try:
        r = requests.get(f"{ESP32}/heaterStats", timeout=5)
        r.raise_for_status()   # 200以外なら例外
        data = r.json()
        a1_ratio = 100*data["a1_on_time_ms"] / data["dt_ms"] if data["dt_ms"] > 0 else 0
        a2_ratio = 100*data["a2_on_time_ms"] / data["dt_ms"] if data["dt_ms"] > 0 else 0
        a3_ratio = 100*data["a3_on_time_ms"] / data["dt_ms"] if data["dt_ms"] > 0 else 0
        row = [
         ts,
         data["dt_ms"],
         data["temp1"],
         data["temp2"],
         data["a1_on_time_ms"],
         data["a2_on_time_ms"],
         data["a3_on_time_ms"],
         data["a1_on_count"],
         data["a2_on_count"],
         data["a3_on_count"],
         round(a1_ratio, 1),
         round(a2_ratio, 1),
         round(a3_ratio, 1),
         data["builtin"],
         data["d1"],
         data["d2"],
         data["d3"],
         data["d4"]

]
    except Exception as e:
        # 失敗時のログだけ残して、サーバは止めない
        print(f"[WARN] ESP32 unreachable: {e}")
        row = [
         ts,
         0,
         -9.99,   # temp1（欠測の目印）
         -9.99,   # temp2
         0, 0, 0, 0, 0, 0,
         0.0, 0.0, 0.0,
         0.0, 0.0, 0.0, 0.0, 0.0
         ]
        rstatus="ng"
        #return {"status": "ng", "error": "esp32 unreachable"}

# ① まず「追記」
    with open(CSV_FILE, "a", newline="") as f:
        writer = csv.writer(f)
        writer.writerow(row)

# ② 行数を制限（超えたら古い行を削除）
    with open(CSV_FILE, "r") as f:
        lines = f.readlines()

if len(lines) > MAX_LINES:
        lines = lines[-MAX_LINES:]   # ← 最新200行だけ残す

with open(CSV_FILE, "w", newline="") as f:
            f.writelines(lines)

return {"status": rstatus, "saved": row, "lines": min(len(lines), MAX_LINES)}

@app.get("/py/heaterStats")
def heater_stats():
    LOG_FILE = "/home/pi/heater_log.csv"
    n = 100  # 最新100件とか、必要に応じて可変
    lines = read_file(LOG_FILE)
    start = max(0, len(lines) - n)
    latest_lines = lines[start:]
    
    response.content_type = 'application/json'
    result = []
    for line in latest_lines:
        # CSVの列に合わせて分割
        dt_str, dt_ms , tempA1 , tempA2 , a1_ms ,a2_ms ,a3_ms, a1_count , a2_count,a3_count , on_percent_a1 , on_percent_a2,on_percent_a3,builtin,d1,d2,d3,d4 = line.strip().split(',', 17)
        result.append({
            "datetime": dt_str,
            "dt_ms":int(dt_ms),
            "tempA1": float(tempA1),
            "tempA2": float(tempA2),
            "a1_ms":int(a1_ms),
            "a2_ms":int(a2_ms),
            "a3_ms":int(a3_ms),
            "a1_count": int(a1_count),
            "a2_count": int(a2_count),
            "a3_count": int(a3_count),
            "on_percent_a1": float(on_percent_a1),
            "on_percent_a2": float(on_percent_a2),
            "on_percent_a3": float(on_percent_a3),
            "builtin": float(builtin),
            "d1": float(d1),
            "d2": float(d2),
            "d3": float(d3),
            "d4": float(d4)
        })
    return json.dumps(result)

@app.get("/py/alarm")
@local_only
def alarm():
    # wavファイル名取得
    wav_file = request.query.wav
    file_path = os.path.join("/home/pi", wav_file)

if not os.path.isfile(file_path):
        return f"File not found: {wav_file}"

try:
        # リレーON（speaker ON）
        GPIO.output(RELAY_PIN, GPIO.HIGH)

# アンプ安定待ち
        time.sleep(0.2)

# wav再生
        proc = subprocess.Popen(["aplay", file_path])
        proc.wait()

GPIO.output(RELAY_PIN, GPIO.LOW)

return f"Played {wav_file}"

except Exception as e:
        GPIO.output(RELAY_PIN, GPIO.LOW)
        return f"Error: {e}"

last_ping = None       # 最後のping時刻
ALARM_THRESHOLD = 30   # 秒（例: 60秒）

# ESPからのGET受信
@app.route('/py/ping')
def ping():
    global last_ping
    last_ping = time.time()
    #log.debug(f"ESP ping at {time.strftime('%X')}")
    return "OK"

# 監視スレッド
def monitor():
    global last_ping
    alarm_on = False
    while True:
        time.sleep(5)  # 5秒ごとチェック
        if last_ping is None:
            # まだESPから来ていない場合は何もしない
            alarm_on = False
            continue

elapsed = time.time() - last_ping
        if elapsed > ALARM_THRESHOLD:
            if not alarm_on:
                print("ESP途切れ! アラーム鳴動")
                #ここで、GPIO27でアンプ電源On
                os.system("aplay /home/pi/espStop.wav &")
                alarm_on = True
        else:
            alarm_on = False

# 監視をバックグラウンドで開始
threading.Thread(target=monitor, daemon=True).start()

*****heater_graph.html******
  ESP32 = "http://192.168.1.30"

CSV_FILE = "heater_log.csv"

MAX_LINES = 432   # ← 最大行数 ３日分

# ① まず「追記」
    with open(CSV_FILE, "a", newline="") as f:
        writer = csv.writer(f)
        writer.writerow(row)

# ② 行数を制限（超えたら古い行を削除）
    with open(CSV_FILE, "r") as f:
        lines = f.readlines()

if len(lines) > MAX_LINES:
        lines = lines[-MAX_LINES:]   # ← 最新200行だけ残す

with open(CSV_FILE, "w", newline="") as f:
            f.writelines(lines)

return {"status": rstatus, "saved": row, "lines": min(len(lines), MAX_LINES)}

@app.get("/py/alarm")
@local_only
def alarm():
    #GPIO27でアンプ電源on
    wav_file = request.query.wav  # URLの ?wav=ファイル名
    # ファイルパスを作成
    file_path = os.path.join("/home/pi", wav_file)
    
    # ファイル存在確認
    if not os.path.isfile(file_path):
        return f"File not found: {wav_file}"
    
    # aplayで再生（非同期で鳴らす場合は Popen）
    try:
        subprocess.Popen(["aplay", file_path])
        return f"Playing {wav_file}"
    except Exception as e:
        return f"Error: {e}"

last_ping = None       # 最後のping時刻
ALARM_THRESHOLD = 30   # 秒（例: 60秒）

# ESPからのGET受信
@app.route('/py/ping')
def ping():
    global last_ping
    last_ping = time.time()
    #log.debug(f"ESP ping at {time.strftime('%X')}")
    return "OK"

# 監視をバックグラウンドで開始
threading.Thread(target=monitor, daemon=True).start()

********heater_stats.html**********
ESP32 = "http://192.168.1.30"