← Retour au dashboard
"""
# ── Flask App ──────────────────────────────────────────────────
app = Flask(__name__)
@app.route('/')
def index():
return render_template_string(HTML)
@app.route('/api/data')
def api_data():
return jsonify(data)
@app.route('/api/history')
def api_history():
return jsonify({k: list(v) for k, v in history.items()})
_last_reco_nom = {"nom": None} # Évite de logguer la même personne en boucle
@app.route('/api/person')
def api_person():
try:
url = 'http://192.168.68.123:8080/api/person'
with urllib.request.urlopen(url, timeout=2) as r:
p = json.loads(r.read().decode())
# Sauvegarde en base seulement si le nom change
nom = p.get("nom", "")
if nom and nom != _last_reco_nom["nom"] and nom not in ("Camera indisponible", "Inconnu", ""):
db_save_reconnaissance(nom, p.get("nb_visages", 0), p.get("alerte", False))
_last_reco_nom["nom"] = nom
return jsonify(p)
except:
return jsonify({"nom": "Camera indisponible", "alerte": False, "nb_visages": 0, "timestamp": ""})
@app.route('/capture')
def capture_page():
return render_template_string(CAPTURE_HTML)
@app.route('/upload_photo', methods=['POST'])
def upload_photo():
if 'photo' not in request.files:
return jsonify({"success": False, "message": "Pas de photo recue"})
file = request.files['photo']
nom = request.form.get('nom', '').strip().lower()
if not nom:
return jsonify({"success": False, "message": "Nom vide"})
filename = nom + '.jpg'
image_data = file.read()
if upload_ftp(filename, image_data):
return jsonify({"success": True, "message": "Photo de " + nom + " envoyee ! Le systeme va la reconnaitre dans quelques secondes."})
else:
return jsonify({"success": False, "message": "Erreur FTP - verifier la connexion avec Pi 2"})
@app.route('/api/historique')
def api_historique():
periode = request.args.get('periode', '24h')
mapping = {'1h': 1, '6h': 6, '24h': 24, '7j': 168}
heures = mapping.get(periode, 24)
try:
conn = sqlite3.connect(DB_PATH)
conn.row_factory = sqlite3.Row
rows = conn.execute("""
SELECT timestamp, heart_rate, breath_rate, bpm_optique, spo2
FROM mesures
WHERE timestamp >= datetime('now','localtime', ? || ' hours')
ORDER BY timestamp ASC
""", (f"-{heures}",)).fetchall()
conn.close()
return jsonify({
"timestamps": [r["timestamp"][-8:] for r in rows],
"heart_rate": [r["heart_rate"] for r in rows],
"breath_rate": [r["breath_rate"] for r in rows],
"bpm_optique": [r["bpm_optique"] for r in rows],
"spo2": [r["spo2"] for r in rows],
})
except Exception as e:
return jsonify({"error": str(e)}), 500
@app.route('/api/alertes')
def api_alertes():
limite = int(request.args.get('limite', 50))
try:
conn = sqlite3.connect(DB_PATH)
conn.row_factory = sqlite3.Row
rows = conn.execute("""
SELECT timestamp, type, parametre, valeur, message
FROM alertes ORDER BY id DESC LIMIT ?
""", (limite,)).fetchall()
conn.close()
return jsonify([dict(r) for r in rows])
except Exception as e:
return jsonify({"error": str(e)}), 500
@app.route('/api/reconnaissances')
def api_reconnaissances():
limite = int(request.args.get('limite', 30))
try:
conn = sqlite3.connect(DB_PATH)
conn.row_factory = sqlite3.Row
rows = conn.execute("""
SELECT timestamp, nom, nb_visages, alerte
FROM reconnaissances ORDER BY id DESC LIMIT ?
""", (limite,)).fetchall()
conn.close()
return jsonify([dict(r) for r in rows])
except Exception as e:
return jsonify({"error": str(e)}), 500
@app.route('/api/stats')
def api_stats():
try:
conn = sqlite3.connect(DB_PATH)
c = conn.cursor()
total_mesures = c.execute("SELECT COUNT(*) FROM mesures").fetchone()[0]
total_alertes = c.execute("SELECT COUNT(*) FROM alertes").fetchone()[0]
alertes_crit = c.execute("SELECT COUNT(*) FROM alertes WHERE type='critique'").fetchone()[0]
alertes_warn = c.execute("SELECT COUNT(*) FROM alertes WHERE type='warning'").fetchone()[0]
spo2_moy = c.execute("SELECT AVG(spo2) FROM mesures WHERE spo2 > 0").fetchone()[0]
bpm_moy = c.execute("SELECT AVG(heart_rate) FROM mesures WHERE heart_rate > 0").fetchone()[0]
premiere = c.execute("SELECT MIN(timestamp) FROM mesures").fetchone()[0]
conn.close()
return jsonify({
"total_mesures": total_mesures,
"total_alertes": total_alertes,
"alertes_critique": alertes_crit,
"alertes_warning": alertes_warn,
"spo2_moyenne": round(spo2_moy, 1) if spo2_moy else 0,
"bpm_moyen": round(bpm_moy, 1) if bpm_moy else 0,
"premiere_mesure": premiere or "--"
})
except Exception as e:
return jsonify({"error": str(e)}), 500
# ── Page Historique long terme ─────────────────────────────────────
HISTORIQUE_HTML = """
Historique - Creche Lyra