usage_tracker.py 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493
  1. """Automatic filament consumption tracking.
  2. Captures AMS tray remain% at print start, then computes consumption
  3. deltas at print complete to update spool weight_used and last_used.
  4. Primary tracking uses 3MF slicer estimates (precise per-filament data).
  5. AMS remain% delta is the fallback for trays not covered by 3MF data.
  6. """
  7. import json
  8. import logging
  9. from dataclasses import dataclass, field
  10. from datetime import datetime, timezone
  11. from sqlalchemy import select
  12. from sqlalchemy.ext.asyncio import AsyncSession
  13. from backend.app.models.spool import Spool
  14. from backend.app.models.spool_assignment import SpoolAssignment
  15. from backend.app.models.spool_usage_history import SpoolUsageHistory
  16. logger = logging.getLogger(__name__)
  17. @dataclass
  18. class PrintSession:
  19. printer_id: int
  20. print_name: str
  21. started_at: datetime
  22. tray_remain_start: dict[tuple[int, int], int] = field(default_factory=dict)
  23. # tray_now at print start (correct value, unlike at completion where it's 255)
  24. tray_now_at_start: int = -1
  25. # Module-level storage, keyed by printer_id
  26. _active_sessions: dict[int, PrintSession] = {}
  27. async def on_print_start(printer_id: int, data: dict, printer_manager) -> None:
  28. """Capture AMS tray remain% at print start."""
  29. state = printer_manager.get_status(printer_id)
  30. if not state or not state.raw_data:
  31. logger.debug("[UsageTracker] No state for printer %d, skipping", printer_id)
  32. return
  33. ams_raw = state.raw_data.get("ams", [])
  34. ams_data = ams_raw.get("ams", []) if isinstance(ams_raw, dict) else ams_raw if isinstance(ams_raw, list) else []
  35. if not ams_data:
  36. logger.debug("[UsageTracker] No AMS data for printer %d, skipping", printer_id)
  37. return
  38. tray_remain_start: dict[tuple[int, int], int] = {}
  39. for ams_unit in ams_data:
  40. ams_id = int(ams_unit.get("id", 0))
  41. for tray in ams_unit.get("tray", []):
  42. tray_id = int(tray.get("id", 0))
  43. remain = tray.get("remain", -1)
  44. if isinstance(remain, int) and 0 <= remain <= 100:
  45. tray_remain_start[(ams_id, tray_id)] = remain
  46. print_name = data.get("subtask_name", "") or data.get("filename", "unknown")
  47. # Capture tray_now at print start (reliable, unlike at completion where it's 255)
  48. tray_now_at_start = state.tray_now if state else -1
  49. # Always create session (even without valid remain data) so print_name
  50. # is available at completion for 3MF-based tracking
  51. session = PrintSession(
  52. printer_id=printer_id,
  53. print_name=print_name,
  54. started_at=datetime.now(timezone.utc),
  55. tray_remain_start=tray_remain_start,
  56. tray_now_at_start=tray_now_at_start,
  57. )
  58. _active_sessions[printer_id] = session
  59. logger.info("[UsageTracker] Captured tray_now=%d at print start for printer %d", tray_now_at_start, printer_id)
  60. if tray_remain_start:
  61. logger.info(
  62. "[UsageTracker] Captured start remain%% for printer %d (%d trays): %s",
  63. printer_id,
  64. len(tray_remain_start),
  65. {f"{k[0]}-{k[1]}": v for k, v in tray_remain_start.items()},
  66. )
  67. else:
  68. logger.debug("[UsageTracker] No valid remain%% for printer %d, 3MF fallback available", printer_id)
  69. async def on_print_complete(
  70. printer_id: int,
  71. data: dict,
  72. printer_manager,
  73. db: AsyncSession,
  74. archive_id: int | None = None,
  75. ams_mapping: list[int] | None = None,
  76. ) -> list[dict]:
  77. """Compute consumption deltas and update spool weight_used/last_used.
  78. Uses two tracking strategies in priority order:
  79. 1. 3MF per-filament estimates (primary) — precise slicer data for all spools
  80. 2. AMS remain% delta (fallback) — only for trays not already handled by 3MF
  81. Returns a list of dicts describing what was logged (for WebSocket broadcast).
  82. """
  83. session = _active_sessions.pop(printer_id, None)
  84. status = data.get("status", "completed")
  85. results = []
  86. handled_trays: set[tuple[int, int]] = set()
  87. logger.info(
  88. "[UsageTracker] on_print_complete: printer=%d, archive=%s, session=%s, ams_mapping=%s",
  89. printer_id,
  90. archive_id,
  91. "yes" if session else "no",
  92. ams_mapping,
  93. )
  94. # --- Path 1 (PRIMARY): 3MF per-filament estimates ---
  95. if archive_id:
  96. print_name = (
  97. (session.print_name if session else None) or data.get("subtask_name", "") or data.get("filename", "unknown")
  98. )
  99. threemf_results = await _track_from_3mf(
  100. printer_id,
  101. archive_id,
  102. status,
  103. print_name,
  104. handled_trays,
  105. printer_manager,
  106. db,
  107. ams_mapping=ams_mapping,
  108. tray_now_at_start=session.tray_now_at_start if session else -1,
  109. )
  110. results.extend(threemf_results)
  111. # --- Path 2 (FALLBACK): AMS remain% delta (only for trays not handled by 3MF) ---
  112. if session and session.tray_remain_start:
  113. state = printer_manager.get_status(printer_id)
  114. if state and state.raw_data:
  115. ams_raw = state.raw_data.get("ams", [])
  116. ams_data = (
  117. ams_raw.get("ams", []) if isinstance(ams_raw, dict) else ams_raw if isinstance(ams_raw, list) else []
  118. )
  119. for ams_unit in ams_data:
  120. ams_id = int(ams_unit.get("id", 0))
  121. for tray in ams_unit.get("tray", []):
  122. tray_id = int(tray.get("id", 0))
  123. key = (ams_id, tray_id)
  124. if key in handled_trays:
  125. continue # Already tracked via 3MF
  126. if key not in session.tray_remain_start:
  127. continue
  128. current_remain = tray.get("remain", -1)
  129. if not isinstance(current_remain, int) or current_remain < 0 or current_remain > 100:
  130. continue
  131. start_remain = session.tray_remain_start[key]
  132. delta_pct = start_remain - current_remain
  133. if delta_pct <= 0:
  134. continue # No consumption or tray was refilled
  135. # Look up SpoolAssignment for this slot
  136. result = await db.execute(
  137. select(SpoolAssignment).where(
  138. SpoolAssignment.printer_id == printer_id,
  139. SpoolAssignment.ams_id == ams_id,
  140. SpoolAssignment.tray_id == tray_id,
  141. )
  142. )
  143. assignment = result.scalar_one_or_none()
  144. if not assignment:
  145. continue
  146. # Load spool
  147. spool_result = await db.execute(select(Spool).where(Spool.id == assignment.spool_id))
  148. spool = spool_result.scalar_one_or_none()
  149. if not spool:
  150. continue
  151. # Compute weight consumed
  152. weight_grams = (delta_pct / 100.0) * spool.label_weight
  153. # Update spool
  154. spool.weight_used = (spool.weight_used or 0) + weight_grams
  155. spool.last_used = datetime.now(timezone.utc)
  156. # Insert usage history record
  157. history = SpoolUsageHistory(
  158. spool_id=spool.id,
  159. printer_id=printer_id,
  160. print_name=session.print_name,
  161. weight_used=round(weight_grams, 1),
  162. percent_used=delta_pct,
  163. status=status,
  164. )
  165. db.add(history)
  166. handled_trays.add(key)
  167. results.append(
  168. {
  169. "spool_id": spool.id,
  170. "weight_used": round(weight_grams, 1),
  171. "percent_used": delta_pct,
  172. "ams_id": ams_id,
  173. "tray_id": tray_id,
  174. "material": spool.material,
  175. }
  176. )
  177. logger.info(
  178. "[UsageTracker] Spool %d consumed %.1fg (%d%%) on printer %d AMS%d-T%d (AMS fallback, %s)",
  179. spool.id,
  180. weight_grams,
  181. delta_pct,
  182. printer_id,
  183. ams_id,
  184. tray_id,
  185. status,
  186. )
  187. if results:
  188. await db.commit()
  189. return results
  190. async def _track_from_3mf(
  191. printer_id: int,
  192. archive_id: int,
  193. status: str,
  194. print_name: str,
  195. handled_trays: set[tuple[int, int]],
  196. printer_manager,
  197. db: AsyncSession,
  198. ams_mapping: list[int] | None = None,
  199. tray_now_at_start: int = -1,
  200. ) -> list[dict]:
  201. """Track usage from 3MF per-filament slicer data (primary path).
  202. Uses slicer-estimated filament weight for all spools (BL and non-BL).
  203. For partial prints (failed/aborted), tries per-layer gcode data first,
  204. then falls back to linear scaling by progress.
  205. Slot-to-tray mapping priority:
  206. 1. Stored ams_mapping from print command (reprints/direct prints)
  207. 2. Queue item ams_mapping (for queue-initiated prints)
  208. 3. tray_now from printer state (for single-filament non-queue prints)
  209. 4. Default mapping: slot_id - 1 = global_tray_id (last resort)
  210. """
  211. from backend.app.core.config import settings as app_settings
  212. from backend.app.models.archive import PrintArchive
  213. from backend.app.models.print_queue import PrintQueueItem
  214. from backend.app.utils.threemf_tools import extract_filament_usage_from_3mf
  215. result = await db.execute(select(PrintArchive).where(PrintArchive.id == archive_id))
  216. archive = result.scalar_one_or_none()
  217. if not archive or not archive.file_path:
  218. logger.info("[UsageTracker] 3MF: archive %s has no file_path, skipping", archive_id)
  219. return []
  220. file_path = app_settings.base_dir / archive.file_path
  221. if not file_path.exists():
  222. logger.info("[UsageTracker] 3MF: file not found: %s", file_path)
  223. return []
  224. filament_usage = extract_filament_usage_from_3mf(file_path)
  225. if not filament_usage:
  226. logger.info("[UsageTracker] 3MF: no filament usage data in %s", file_path)
  227. return []
  228. logger.info("[UsageTracker] 3MF: archive %s, filament_usage=%s", archive_id, filament_usage)
  229. # --- Resolve slot-to-tray mapping ---
  230. # 1. Use stored ams_mapping from the print command (reprints/direct prints)
  231. slot_to_tray = ams_mapping
  232. # 2. Try queue item ams_mapping (queue-initiated prints store the exact mapping)
  233. if not slot_to_tray:
  234. queue_result = await db.execute(
  235. select(PrintQueueItem)
  236. .where(PrintQueueItem.archive_id == archive_id)
  237. .where(PrintQueueItem.status.in_(["printing", "completed", "failed"]))
  238. )
  239. queue_item = queue_result.scalar_one_or_none()
  240. if queue_item and queue_item.ams_mapping:
  241. try:
  242. slot_to_tray = json.loads(queue_item.ams_mapping)
  243. except (json.JSONDecodeError, TypeError):
  244. pass
  245. logger.info(
  246. "[UsageTracker] 3MF: slot_to_tray=%s (source: %s)",
  247. slot_to_tray,
  248. "print_cmd" if ams_mapping else ("queue" if slot_to_tray else "none"),
  249. )
  250. # 3. For single-filament non-queue prints, use tray_now from printer state
  251. # Priority: tray_now_at_start > current tray_now > last_loaded_tray > vt_tray check
  252. nonzero_slots = [u for u in filament_usage if u.get("used_g", 0) > 0]
  253. tray_now_override: int | None = None
  254. if not slot_to_tray and len(nonzero_slots) == 1:
  255. state = printer_manager.get_status(printer_id)
  256. # Try tray_now_at_start first (captured at print start)
  257. if 0 <= tray_now_at_start <= 254:
  258. tray_now_override = tray_now_at_start
  259. logger.info("[UsageTracker] 3MF: using tray_now_at_start=%d (single-filament fallback)", tray_now_at_start)
  260. elif state and 0 <= state.tray_now <= 254:
  261. # Current state is valid (printer didn't retract yet)
  262. tray_now_override = state.tray_now
  263. logger.info("[UsageTracker] 3MF: using current tray_now=%d", state.tray_now)
  264. elif state and 0 <= state.last_loaded_tray <= 253:
  265. # Last valid tray before retract (H2D retracts before completion callback)
  266. tray_now_override = state.last_loaded_tray
  267. logger.info("[UsageTracker] 3MF: using last_loaded_tray=%d (post-retract fallback)", state.last_loaded_tray)
  268. elif state and state.tray_now == 255:
  269. # 255 = "no filament" on legacy printers, but valid 2nd external spool on H2-series
  270. vt_tray = state.raw_data.get("vt_tray") or []
  271. if any(int(vt.get("id", 0)) == 255 for vt in vt_tray if isinstance(vt, dict)):
  272. tray_now_override = state.tray_now
  273. logger.info("[UsageTracker] 3MF: using tray_now=255 (H2-series external spool)")
  274. if tray_now_override is None:
  275. logger.info(
  276. "[UsageTracker] 3MF: no valid tray_now (at_start=%d, current=%s, last_loaded=%s)",
  277. tray_now_at_start,
  278. state.tray_now if state else "N/A",
  279. state.last_loaded_tray if state else "N/A",
  280. )
  281. # Scale factor for partial prints (failed/aborted)
  282. if status == "completed":
  283. scale = 1.0
  284. else:
  285. state = printer_manager.get_status(printer_id)
  286. progress = state.progress if state else 0
  287. scale = max(0.0, min(progress / 100.0, 1.0))
  288. # Per-layer gcode accuracy for partial prints
  289. layer_grams: dict[int, float] | None = None
  290. if status != "completed":
  291. state = printer_manager.get_status(printer_id)
  292. current_layer = state.layer_num if state else 0
  293. if current_layer > 0:
  294. try:
  295. from backend.app.utils.threemf_tools import (
  296. extract_filament_properties_from_3mf,
  297. extract_layer_filament_usage_from_3mf,
  298. get_cumulative_usage_at_layer,
  299. mm_to_grams,
  300. )
  301. layer_usage = extract_layer_filament_usage_from_3mf(file_path)
  302. if layer_usage:
  303. cumulative_mm = get_cumulative_usage_at_layer(layer_usage, current_layer)
  304. filament_props = extract_filament_properties_from_3mf(file_path)
  305. layer_grams = {}
  306. for filament_id, mm_used in cumulative_mm.items():
  307. slot_id = filament_id + 1 # 0-based to 1-based
  308. props = filament_props.get(slot_id, {})
  309. density = props.get("density", 1.24)
  310. diameter = props.get("diameter", 1.75)
  311. layer_grams[slot_id] = mm_to_grams(mm_used, diameter, density)
  312. except Exception:
  313. pass # Fall back to linear scaling
  314. results = []
  315. for usage in filament_usage:
  316. slot_id = usage.get("slot_id", 0)
  317. used_g = usage.get("used_g", 0)
  318. if used_g <= 0:
  319. continue
  320. # Map 3MF slot_id to physical (ams_id, tray_id) using resolved mapping
  321. if tray_now_override is not None:
  322. # Single-filament non-queue print: use actual tray from printer state
  323. global_tray_id = tray_now_override
  324. else:
  325. # Queue mapping or default: slot_id - 1, overridden by ams_mapping
  326. global_tray_id = slot_id - 1
  327. if slot_to_tray and slot_id <= len(slot_to_tray):
  328. mapped = slot_to_tray[slot_id - 1]
  329. if isinstance(mapped, int) and mapped >= 0:
  330. global_tray_id = mapped
  331. if global_tray_id >= 254:
  332. # External spool: ams_id=255 (sentinel), tray_id=slot index (0 or 1)
  333. ams_id = 255
  334. tray_id = global_tray_id - 254
  335. elif global_tray_id >= 128:
  336. ams_id = global_tray_id
  337. tray_id = 0
  338. else:
  339. ams_id = global_tray_id // 4
  340. tray_id = global_tray_id % 4
  341. logger.info(
  342. "[UsageTracker] 3MF: slot_id=%d -> global_tray=%d -> AMS%d-T%d (used_g=%.1f, tray_now_override=%s)",
  343. slot_id,
  344. global_tray_id,
  345. ams_id,
  346. tray_id,
  347. used_g,
  348. tray_now_override,
  349. )
  350. key = (ams_id, tray_id)
  351. if key in handled_trays:
  352. continue
  353. # Find spool assignment for this tray
  354. assign_result = await db.execute(
  355. select(SpoolAssignment).where(
  356. SpoolAssignment.printer_id == printer_id,
  357. SpoolAssignment.ams_id == ams_id,
  358. SpoolAssignment.tray_id == tray_id,
  359. )
  360. )
  361. assignment = assign_result.scalar_one_or_none()
  362. if not assignment:
  363. logger.info("[UsageTracker] 3MF: no spool assignment at printer %d AMS%d-T%d", printer_id, ams_id, tray_id)
  364. continue
  365. # Load spool
  366. spool_result = await db.execute(select(Spool).where(Spool.id == assignment.spool_id))
  367. spool = spool_result.scalar_one_or_none()
  368. if not spool:
  369. continue
  370. # Use per-layer grams if available, otherwise linear scale
  371. if layer_grams and slot_id in layer_grams:
  372. weight_grams = layer_grams[slot_id]
  373. else:
  374. weight_grams = used_g * scale
  375. if weight_grams <= 0:
  376. continue
  377. # Update spool
  378. spool.weight_used = (spool.weight_used or 0) + weight_grams
  379. spool.last_used = datetime.now(timezone.utc)
  380. percent = round(weight_grams / (spool.label_weight or 1000) * 100)
  381. # Insert usage history record
  382. history = SpoolUsageHistory(
  383. spool_id=spool.id,
  384. printer_id=printer_id,
  385. print_name=print_name,
  386. weight_used=round(weight_grams, 1),
  387. percent_used=percent,
  388. status=status,
  389. )
  390. db.add(history)
  391. handled_trays.add(key)
  392. results.append(
  393. {
  394. "spool_id": spool.id,
  395. "weight_used": round(weight_grams, 1),
  396. "percent_used": percent,
  397. "ams_id": ams_id,
  398. "tray_id": tray_id,
  399. "material": spool.material,
  400. }
  401. )
  402. # Determine mapping source for debug logging
  403. if tray_now_override is not None:
  404. map_src = ", tray_now"
  405. elif slot_to_tray and ams_mapping:
  406. map_src = ", print_cmd_map"
  407. elif slot_to_tray:
  408. map_src = ", queue_map"
  409. else:
  410. map_src = ""
  411. logger.info(
  412. "[UsageTracker] Spool %d consumed %.1fg (3MF%s%s) on printer %d AMS%d-T%d (%s)",
  413. spool.id,
  414. weight_grams,
  415. " per-layer" if (layer_grams and slot_id in layer_grams) else (f" scaled {scale:.0%}" if scale < 1 else ""),
  416. map_src,
  417. printer_id,
  418. ams_id,
  419. tray_id,
  420. status,
  421. )
  422. return results