usage_tracker.py 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692
  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. def _decode_mqtt_mapping(mapping_raw: list | None) -> list[int] | None:
  18. """Decode MQTT mapping field (snow-encoded) to bambuddy global tray IDs.
  19. The printer's MQTT mapping field is an array indexed by slicer filament slot
  20. (0-based). Each value uses snow encoding: ams_hw_id * 256 + local_slot.
  21. 65535 means unmapped.
  22. Returns a list of bambuddy global tray IDs (or -1 for unmapped), or None if
  23. no valid mappings found.
  24. """
  25. if not isinstance(mapping_raw, list) or not mapping_raw:
  26. return None
  27. result = []
  28. for value in mapping_raw:
  29. if not isinstance(value, int) or value >= 65535:
  30. result.append(-1)
  31. continue
  32. ams_hw_id = value >> 8
  33. slot = value & 0xFF
  34. if 0 <= ams_hw_id <= 3:
  35. # Regular AMS: sequential global ID
  36. result.append(ams_hw_id * 4 + (slot & 0x03))
  37. elif 128 <= ams_hw_id <= 135:
  38. # AMS-HT: global ID is the hardware ID (one slot per unit)
  39. result.append(ams_hw_id)
  40. elif ams_hw_id in (254, 255):
  41. # External spool
  42. result.append(254 if slot != 255 else 255)
  43. else:
  44. result.append(-1)
  45. # Only return if at least one valid mapping exists
  46. if all(v < 0 for v in result):
  47. return None
  48. return result
  49. def _match_slots_by_color(
  50. filament_usage: list[dict],
  51. ams_raw: dict | list | None,
  52. ) -> list[int] | None:
  53. """Match 3MF filament slots to AMS trays by color.
  54. Fallback mapping for printers that don't provide the MQTT mapping field
  55. or request topic subscription (e.g. A1, A1 Mini, P1S, P2S).
  56. Compares the 3MF slicer filament color (per slot) against each AMS tray's
  57. color to find a unique match. Only returns a mapping if every used slot
  58. matches exactly one tray (no ambiguity).
  59. Args:
  60. filament_usage: List of 3MF slot dicts with 'slot_id', 'color', 'type'
  61. ams_raw: raw_data["ams"] dict or list from printer state
  62. Returns:
  63. List of global tray IDs indexed by slicer slot (0-based), or None.
  64. """
  65. if not filament_usage or not ams_raw:
  66. return None
  67. ams_data = ams_raw.get("ams", []) if isinstance(ams_raw, dict) else ams_raw if isinstance(ams_raw, list) else []
  68. if not ams_data:
  69. return None
  70. # Build map of normalized color → list of global tray IDs
  71. color_to_trays: dict[str, list[int]] = {}
  72. for ams_unit in ams_data:
  73. ams_id = int(ams_unit.get("id", 0))
  74. for tray in ams_unit.get("tray", []):
  75. tray_id = int(tray.get("id", 0))
  76. tray_color = tray.get("tray_color", "")
  77. tray_type = tray.get("tray_type", "")
  78. if not tray_color or not tray_type:
  79. continue
  80. # Normalize AMS color: strip alpha (last 2 chars), lowercase
  81. norm = tray_color[:6].lower() if len(tray_color) >= 6 else tray_color.lower()
  82. if ams_id >= 128:
  83. global_id = ams_id # AMS-HT
  84. else:
  85. global_id = ams_id * 4 + tray_id
  86. color_to_trays.setdefault(norm, []).append(global_id)
  87. if not color_to_trays:
  88. return None
  89. # Find max slot_id to size the result array
  90. max_slot = max(u.get("slot_id", 0) for u in filament_usage)
  91. if max_slot <= 0:
  92. return None
  93. result = [-1] * max_slot
  94. used_trays: set[int] = set()
  95. for usage in filament_usage:
  96. slot_id = usage.get("slot_id", 0)
  97. if slot_id <= 0:
  98. continue
  99. slot_color = usage.get("color", "").lstrip("#").lower()
  100. if len(slot_color) < 6:
  101. return None # Can't match without a valid color
  102. slot_color = slot_color[:6] # Strip alpha if present
  103. candidates = color_to_trays.get(slot_color, [])
  104. # Filter out trays already claimed by another slot
  105. available = [t for t in candidates if t not in used_trays]
  106. if len(available) != 1:
  107. # Ambiguous (multiple trays with same color) or no match
  108. return None
  109. result[slot_id - 1] = available[0]
  110. used_trays.add(available[0])
  111. # Only return if at least one valid mapping exists
  112. if all(v < 0 for v in result):
  113. return None
  114. logger.info("[UsageTracker] Color-matched slot_to_tray: %s", result)
  115. return result
  116. @dataclass
  117. class PrintSession:
  118. printer_id: int
  119. print_name: str
  120. started_at: datetime
  121. tray_remain_start: dict[tuple[int, int], int] = field(default_factory=dict)
  122. # tray_now at print start (correct value, unlike at completion where it's 255)
  123. tray_now_at_start: int = -1
  124. # Module-level storage, keyed by printer_id
  125. _active_sessions: dict[int, PrintSession] = {}
  126. async def on_print_start(printer_id: int, data: dict, printer_manager) -> None:
  127. """Capture AMS tray remain% at print start."""
  128. state = printer_manager.get_status(printer_id)
  129. if not state or not state.raw_data:
  130. logger.debug("[UsageTracker] No state for printer %d, skipping", printer_id)
  131. return
  132. ams_raw = state.raw_data.get("ams", [])
  133. ams_data = ams_raw.get("ams", []) if isinstance(ams_raw, dict) else ams_raw if isinstance(ams_raw, list) else []
  134. if not ams_data:
  135. logger.debug("[UsageTracker] No AMS data for printer %d, skipping", printer_id)
  136. return
  137. tray_remain_start: dict[tuple[int, int], int] = {}
  138. for ams_unit in ams_data:
  139. ams_id = int(ams_unit.get("id", 0))
  140. for tray in ams_unit.get("tray", []):
  141. tray_id = int(tray.get("id", 0))
  142. remain = tray.get("remain", -1)
  143. if isinstance(remain, int) and 0 <= remain <= 100:
  144. tray_remain_start[(ams_id, tray_id)] = remain
  145. print_name = data.get("subtask_name", "") or data.get("filename", "unknown")
  146. # Capture tray_now at print start (reliable, unlike at completion where it's 255)
  147. tray_now_at_start = state.tray_now if state else -1
  148. # --- Diagnostic logging: dump mapping-related MQTT fields at print start ---
  149. # This helps us understand what each printer model reports for slot-to-tray mapping.
  150. mapping_field = state.raw_data.get("mapping")
  151. logger.info(
  152. "[UsageTracker] PRINT START printer %d: mapping=%s, tray_now=%d, last_loaded_tray=%s",
  153. printer_id,
  154. mapping_field,
  155. tray_now_at_start,
  156. getattr(state, "last_loaded_tray", "N/A"),
  157. )
  158. # Log all raw_data keys containing "map" or "ams" for discovery
  159. map_keys = {k: state.raw_data[k] for k in state.raw_data if "map" in k.lower()}
  160. if map_keys:
  161. logger.info("[UsageTracker] PRINT START printer %d: mapping-related keys: %s", printer_id, map_keys)
  162. # Log per-tray summary: tray_now, tray_tar, tray_type, tray_color for each slot
  163. for ams_unit in ams_data:
  164. ams_id = int(ams_unit.get("id", 0))
  165. tray_summary = []
  166. for tray in ams_unit.get("tray", []):
  167. tray_summary.append(
  168. f"T{tray.get('id', '?')}(type={tray.get('tray_type', '')}, "
  169. f"color={tray.get('tray_color', '')}, "
  170. f"now={ams_raw.get('tray_now', '?') if isinstance(ams_raw, dict) else '?'}, "
  171. f"tar={ams_raw.get('tray_tar', '?') if isinstance(ams_raw, dict) else '?'})"
  172. )
  173. logger.info("[UsageTracker] PRINT START printer %d AMS %d: %s", printer_id, ams_id, ", ".join(tray_summary))
  174. # Always create session (even without valid remain data) so print_name
  175. # is available at completion for 3MF-based tracking
  176. session = PrintSession(
  177. printer_id=printer_id,
  178. print_name=print_name,
  179. started_at=datetime.now(timezone.utc),
  180. tray_remain_start=tray_remain_start,
  181. tray_now_at_start=tray_now_at_start,
  182. )
  183. _active_sessions[printer_id] = session
  184. if tray_remain_start:
  185. logger.info(
  186. "[UsageTracker] Captured start remain%% for printer %d (%d trays): %s",
  187. printer_id,
  188. len(tray_remain_start),
  189. {f"{k[0]}-{k[1]}": v for k, v in tray_remain_start.items()},
  190. )
  191. else:
  192. logger.debug("[UsageTracker] No valid remain%% for printer %d, 3MF fallback available", printer_id)
  193. async def on_print_complete(
  194. printer_id: int,
  195. data: dict,
  196. printer_manager,
  197. db: AsyncSession,
  198. archive_id: int | None = None,
  199. ams_mapping: list[int] | None = None,
  200. ) -> list[dict]:
  201. """Compute consumption deltas and update spool weight_used/last_used.
  202. Uses two tracking strategies in priority order:
  203. 1. 3MF per-filament estimates (primary) — precise slicer data for all spools
  204. 2. AMS remain% delta (fallback) — only for trays not already handled by 3MF
  205. Returns a list of dicts describing what was logged (for WebSocket broadcast).
  206. """
  207. session = _active_sessions.pop(printer_id, None)
  208. status = data.get("status", "completed")
  209. results = []
  210. handled_trays: set[tuple[int, int]] = set()
  211. logger.info(
  212. "[UsageTracker] on_print_complete: printer=%d, archive=%s, session=%s, ams_mapping=%s",
  213. printer_id,
  214. archive_id,
  215. "yes" if session else "no",
  216. ams_mapping,
  217. )
  218. # --- Diagnostic logging: dump mapping-related MQTT fields at print completion ---
  219. state = printer_manager.get_status(printer_id)
  220. if state and state.raw_data:
  221. logger.info(
  222. "[UsageTracker] PRINT COMPLETE printer %d: mapping=%s, tray_now=%s, last_loaded_tray=%s",
  223. printer_id,
  224. state.raw_data.get("mapping"),
  225. state.tray_now,
  226. getattr(state, "last_loaded_tray", "N/A"),
  227. )
  228. # --- Path 1 (PRIMARY): 3MF per-filament estimates ---
  229. if archive_id:
  230. print_name = (
  231. (session.print_name if session else None) or data.get("subtask_name", "") or data.get("filename", "unknown")
  232. )
  233. threemf_results = await _track_from_3mf(
  234. printer_id,
  235. archive_id,
  236. status,
  237. print_name,
  238. handled_trays,
  239. printer_manager,
  240. db,
  241. ams_mapping=ams_mapping,
  242. tray_now_at_start=session.tray_now_at_start if session else -1,
  243. last_progress=data.get("last_progress", 0.0),
  244. last_layer_num=data.get("last_layer_num", 0),
  245. )
  246. results.extend(threemf_results)
  247. # --- Path 2 (FALLBACK): AMS remain% delta (only for trays not handled by 3MF) ---
  248. if session and session.tray_remain_start:
  249. state = printer_manager.get_status(printer_id)
  250. if state and state.raw_data:
  251. ams_raw = state.raw_data.get("ams", [])
  252. ams_data = (
  253. ams_raw.get("ams", []) if isinstance(ams_raw, dict) else ams_raw if isinstance(ams_raw, list) else []
  254. )
  255. for ams_unit in ams_data:
  256. ams_id = int(ams_unit.get("id", 0))
  257. for tray in ams_unit.get("tray", []):
  258. tray_id = int(tray.get("id", 0))
  259. key = (ams_id, tray_id)
  260. if key in handled_trays:
  261. continue # Already tracked via 3MF
  262. if key not in session.tray_remain_start:
  263. continue
  264. current_remain = tray.get("remain", -1)
  265. if not isinstance(current_remain, int) or current_remain < 0 or current_remain > 100:
  266. continue
  267. start_remain = session.tray_remain_start[key]
  268. delta_pct = start_remain - current_remain
  269. if delta_pct <= 0:
  270. continue # No consumption or tray was refilled
  271. # Look up SpoolAssignment for this slot
  272. result = await db.execute(
  273. select(SpoolAssignment).where(
  274. SpoolAssignment.printer_id == printer_id,
  275. SpoolAssignment.ams_id == ams_id,
  276. SpoolAssignment.tray_id == tray_id,
  277. )
  278. )
  279. assignment = result.scalar_one_or_none()
  280. if not assignment:
  281. continue
  282. # Load spool
  283. spool_result = await db.execute(select(Spool).where(Spool.id == assignment.spool_id))
  284. spool = spool_result.scalar_one_or_none()
  285. if not spool:
  286. continue
  287. # Compute weight consumed
  288. weight_grams = (delta_pct / 100.0) * spool.label_weight
  289. # Update spool
  290. spool.weight_used = (spool.weight_used or 0) + weight_grams
  291. spool.last_used = datetime.now(timezone.utc)
  292. # Insert usage history record
  293. history = SpoolUsageHistory(
  294. spool_id=spool.id,
  295. printer_id=printer_id,
  296. print_name=session.print_name,
  297. weight_used=round(weight_grams, 1),
  298. percent_used=delta_pct,
  299. status=status,
  300. )
  301. db.add(history)
  302. handled_trays.add(key)
  303. results.append(
  304. {
  305. "spool_id": spool.id,
  306. "weight_used": round(weight_grams, 1),
  307. "percent_used": delta_pct,
  308. "ams_id": ams_id,
  309. "tray_id": tray_id,
  310. "material": spool.material,
  311. }
  312. )
  313. logger.info(
  314. "[UsageTracker] Spool %d consumed %.1fg (%d%%) on printer %d AMS%d-T%d (AMS fallback, %s)",
  315. spool.id,
  316. weight_grams,
  317. delta_pct,
  318. printer_id,
  319. ams_id,
  320. tray_id,
  321. status,
  322. )
  323. if results:
  324. await db.commit()
  325. return results
  326. async def _track_from_3mf(
  327. printer_id: int,
  328. archive_id: int,
  329. status: str,
  330. print_name: str,
  331. handled_trays: set[tuple[int, int]],
  332. printer_manager,
  333. db: AsyncSession,
  334. ams_mapping: list[int] | None = None,
  335. tray_now_at_start: int = -1,
  336. last_progress: float = 0.0,
  337. last_layer_num: int = 0,
  338. ) -> list[dict]:
  339. """Track usage from 3MF per-filament slicer data (primary path).
  340. Uses slicer-estimated filament weight for all spools (BL and non-BL).
  341. For partial prints (failed/aborted), tries per-layer gcode data first,
  342. then falls back to linear scaling by progress.
  343. Slot-to-tray mapping priority:
  344. 1. Stored ams_mapping from print command (reprints/direct prints)
  345. 2. MQTT mapping field from printer state (universal, all print sources)
  346. 3. Queue item ams_mapping (for queue-initiated prints)
  347. 4. tray_now from printer state (for single-filament non-queue prints)
  348. 5. Default mapping: slot_id - 1 = global_tray_id (last resort)
  349. """
  350. from backend.app.core.config import settings as app_settings
  351. from backend.app.models.archive import PrintArchive
  352. from backend.app.models.print_queue import PrintQueueItem
  353. from backend.app.utils.threemf_tools import extract_filament_usage_from_3mf
  354. result = await db.execute(select(PrintArchive).where(PrintArchive.id == archive_id))
  355. archive = result.scalar_one_or_none()
  356. if not archive or not archive.file_path:
  357. logger.info("[UsageTracker] 3MF: archive %s has no file_path, skipping", archive_id)
  358. return []
  359. file_path = app_settings.base_dir / archive.file_path
  360. if not file_path.exists():
  361. logger.info("[UsageTracker] 3MF: file not found: %s", file_path)
  362. return []
  363. filament_usage = extract_filament_usage_from_3mf(file_path)
  364. if not filament_usage:
  365. logger.info("[UsageTracker] 3MF: no filament usage data in %s", file_path)
  366. return []
  367. logger.info("[UsageTracker] 3MF: archive %s, filament_usage=%s", archive_id, filament_usage)
  368. # --- Resolve slot-to-tray mapping ---
  369. mapping_source = None
  370. # 1. Use stored ams_mapping from the print command (reprints/direct prints)
  371. slot_to_tray = ams_mapping
  372. if slot_to_tray:
  373. mapping_source = "print_cmd"
  374. # 2. Try MQTT mapping field from printer state (universal, all print sources)
  375. if not slot_to_tray:
  376. state = printer_manager.get_status(printer_id)
  377. raw_data = getattr(state, "raw_data", None) if state else None
  378. if raw_data:
  379. mqtt_mapping = raw_data.get("mapping")
  380. decoded = _decode_mqtt_mapping(mqtt_mapping)
  381. if decoded:
  382. slot_to_tray = decoded
  383. mapping_source = "mqtt"
  384. # 3. Try queue item ams_mapping (queue-initiated prints store the exact mapping)
  385. if not slot_to_tray:
  386. queue_result = await db.execute(
  387. select(PrintQueueItem)
  388. .where(PrintQueueItem.archive_id == archive_id)
  389. .where(PrintQueueItem.status.in_(["printing", "completed", "failed"]))
  390. )
  391. queue_item = queue_result.scalar_one_or_none()
  392. if queue_item and queue_item.ams_mapping:
  393. try:
  394. slot_to_tray = json.loads(queue_item.ams_mapping)
  395. mapping_source = "queue"
  396. except (json.JSONDecodeError, TypeError):
  397. pass
  398. # 4. Color-match 3MF filament slots to AMS trays (for printers without mapping field)
  399. if not slot_to_tray:
  400. state = printer_manager.get_status(printer_id)
  401. raw_data = getattr(state, "raw_data", None) if state else None
  402. if raw_data:
  403. matched = _match_slots_by_color(filament_usage, raw_data.get("ams"))
  404. if matched:
  405. slot_to_tray = matched
  406. mapping_source = "color_match"
  407. logger.info(
  408. "[UsageTracker] 3MF: slot_to_tray=%s (source: %s)",
  409. slot_to_tray,
  410. mapping_source or "none",
  411. )
  412. # 5. For single-filament non-queue prints, use tray_now from printer state
  413. # Priority: tray_now_at_start > current tray_now > last_loaded_tray > vt_tray check
  414. nonzero_slots = [u for u in filament_usage if u.get("used_g", 0) > 0]
  415. tray_now_override: int | None = None
  416. if not slot_to_tray and len(nonzero_slots) == 1:
  417. state = printer_manager.get_status(printer_id)
  418. # Try tray_now_at_start first (captured at print start)
  419. if 0 <= tray_now_at_start <= 254:
  420. tray_now_override = tray_now_at_start
  421. logger.info("[UsageTracker] 3MF: using tray_now_at_start=%d (single-filament fallback)", tray_now_at_start)
  422. elif state and 0 <= state.tray_now <= 254:
  423. # Current state is valid (printer didn't retract yet)
  424. tray_now_override = state.tray_now
  425. logger.info("[UsageTracker] 3MF: using current tray_now=%d", state.tray_now)
  426. elif state and 0 <= state.last_loaded_tray <= 253:
  427. # Last valid tray before retract (H2D retracts before completion callback)
  428. tray_now_override = state.last_loaded_tray
  429. logger.info("[UsageTracker] 3MF: using last_loaded_tray=%d (post-retract fallback)", state.last_loaded_tray)
  430. elif state and state.tray_now == 255:
  431. # 255 = "no filament" on legacy printers, but valid 2nd external spool on H2-series
  432. vt_tray = state.raw_data.get("vt_tray") or []
  433. if any(int(vt.get("id", 0)) == 255 for vt in vt_tray if isinstance(vt, dict)):
  434. tray_now_override = state.tray_now
  435. logger.info("[UsageTracker] 3MF: using tray_now=255 (H2-series external spool)")
  436. if tray_now_override is None:
  437. logger.info(
  438. "[UsageTracker] 3MF: no valid tray_now (at_start=%d, current=%s, last_loaded=%s)",
  439. tray_now_at_start,
  440. state.tray_now if state else "N/A",
  441. state.last_loaded_tray if state else "N/A",
  442. )
  443. # Scale factor for partial prints (failed/aborted)
  444. if status == "completed":
  445. scale = 1.0
  446. else:
  447. state = printer_manager.get_status(printer_id)
  448. progress = state.progress if state else 0
  449. # Firmware resets progress to 0 on cancel — use last valid progress captured during print
  450. if progress <= 0 and last_progress > 0:
  451. progress = last_progress
  452. logger.info("[UsageTracker] 3MF: using last_progress=%.1f (firmware reset current to 0)", last_progress)
  453. scale = max(0.0, min(progress / 100.0, 1.0))
  454. # Per-layer gcode accuracy for partial prints
  455. layer_grams: dict[int, float] | None = None
  456. if status != "completed":
  457. state = printer_manager.get_status(printer_id)
  458. current_layer = state.layer_num if state else 0
  459. # Firmware resets layer_num to 0 on cancel — use last valid layer captured during print
  460. if current_layer <= 0 and last_layer_num > 0:
  461. current_layer = last_layer_num
  462. logger.info("[UsageTracker] 3MF: using last_layer_num=%d (firmware reset current to 0)", last_layer_num)
  463. if current_layer > 0:
  464. try:
  465. from backend.app.utils.threemf_tools import (
  466. extract_filament_properties_from_3mf,
  467. extract_layer_filament_usage_from_3mf,
  468. get_cumulative_usage_at_layer,
  469. mm_to_grams,
  470. )
  471. layer_usage = extract_layer_filament_usage_from_3mf(file_path)
  472. if layer_usage:
  473. cumulative_mm = get_cumulative_usage_at_layer(layer_usage, current_layer)
  474. filament_props = extract_filament_properties_from_3mf(file_path)
  475. layer_grams = {}
  476. for filament_id, mm_used in cumulative_mm.items():
  477. slot_id = filament_id + 1 # 0-based to 1-based
  478. props = filament_props.get(slot_id, {})
  479. density = props.get("density", 1.24)
  480. diameter = props.get("diameter", 1.75)
  481. layer_grams[slot_id] = mm_to_grams(mm_used, diameter, density)
  482. except Exception:
  483. pass # Fall back to linear scaling
  484. results = []
  485. for usage in filament_usage:
  486. slot_id = usage.get("slot_id", 0)
  487. used_g = usage.get("used_g", 0)
  488. if used_g <= 0:
  489. continue
  490. # Map 3MF slot_id to physical (ams_id, tray_id) using resolved mapping
  491. if tray_now_override is not None:
  492. # Single-filament non-queue print: use actual tray from printer state
  493. global_tray_id = tray_now_override
  494. else:
  495. # Queue mapping or default: slot_id - 1, overridden by ams_mapping
  496. global_tray_id = slot_id - 1
  497. if slot_to_tray and slot_id <= len(slot_to_tray):
  498. mapped = slot_to_tray[slot_id - 1]
  499. if isinstance(mapped, int) and mapped >= 0:
  500. global_tray_id = mapped
  501. if global_tray_id >= 254:
  502. # External spool: ams_id=255 (sentinel), tray_id=slot index (0 or 1)
  503. ams_id = 255
  504. tray_id = global_tray_id - 254
  505. elif global_tray_id >= 128:
  506. ams_id = global_tray_id
  507. tray_id = 0
  508. else:
  509. ams_id = global_tray_id // 4
  510. tray_id = global_tray_id % 4
  511. logger.info(
  512. "[UsageTracker] 3MF: slot_id=%d -> global_tray=%d -> AMS%d-T%d (used_g=%.1f, tray_now_override=%s)",
  513. slot_id,
  514. global_tray_id,
  515. ams_id,
  516. tray_id,
  517. used_g,
  518. tray_now_override,
  519. )
  520. key = (ams_id, tray_id)
  521. if key in handled_trays:
  522. continue
  523. # Find spool assignment for this tray
  524. assign_result = await db.execute(
  525. select(SpoolAssignment).where(
  526. SpoolAssignment.printer_id == printer_id,
  527. SpoolAssignment.ams_id == ams_id,
  528. SpoolAssignment.tray_id == tray_id,
  529. )
  530. )
  531. assignment = assign_result.scalar_one_or_none()
  532. if not assignment:
  533. logger.info("[UsageTracker] 3MF: no spool assignment at printer %d AMS%d-T%d", printer_id, ams_id, tray_id)
  534. continue
  535. # Load spool
  536. spool_result = await db.execute(select(Spool).where(Spool.id == assignment.spool_id))
  537. spool = spool_result.scalar_one_or_none()
  538. if not spool:
  539. continue
  540. # Use per-layer grams if available, otherwise linear scale
  541. if layer_grams and slot_id in layer_grams:
  542. weight_grams = layer_grams[slot_id]
  543. else:
  544. weight_grams = used_g * scale
  545. if weight_grams <= 0:
  546. continue
  547. # Update spool
  548. spool.weight_used = (spool.weight_used or 0) + weight_grams
  549. spool.last_used = datetime.now(timezone.utc)
  550. percent = round(weight_grams / (spool.label_weight or 1000) * 100)
  551. # Insert usage history record
  552. history = SpoolUsageHistory(
  553. spool_id=spool.id,
  554. printer_id=printer_id,
  555. print_name=print_name,
  556. weight_used=round(weight_grams, 1),
  557. percent_used=percent,
  558. status=status,
  559. )
  560. db.add(history)
  561. handled_trays.add(key)
  562. results.append(
  563. {
  564. "spool_id": spool.id,
  565. "weight_used": round(weight_grams, 1),
  566. "percent_used": percent,
  567. "ams_id": ams_id,
  568. "tray_id": tray_id,
  569. "material": spool.material,
  570. }
  571. )
  572. # Determine mapping source for debug logging
  573. if tray_now_override is not None:
  574. map_src = ", tray_now"
  575. elif mapping_source:
  576. map_src = f", {mapping_source}_map"
  577. else:
  578. map_src = ""
  579. logger.info(
  580. "[UsageTracker] Spool %d consumed %.1fg (3MF%s%s) on printer %d AMS%d-T%d (%s)",
  581. spool.id,
  582. weight_grams,
  583. " per-layer" if (layer_grams and slot_id in layer_grams) else (f" scaled {scale:.0%}" if scale < 1 else ""),
  584. map_src,
  585. printer_id,
  586. ams_id,
  587. tray_id,
  588. status,
  589. )
  590. return results