notification_service.py 55 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396
  1. """Notification service for sending push notifications via various providers."""
  2. import asyncio
  3. import json
  4. import logging
  5. import re
  6. import smtplib
  7. from datetime import datetime, timedelta, timezone
  8. from email.mime.multipart import MIMEMultipart
  9. from email.mime.text import MIMEText
  10. from typing import Any
  11. from urllib.parse import quote
  12. import httpx
  13. from sqlalchemy import select
  14. from sqlalchemy.ext.asyncio import AsyncSession
  15. from backend.app.models.notification import NotificationDigestQueue, NotificationLog, NotificationProvider
  16. from backend.app.models.notification_template import NotificationTemplate
  17. logger = logging.getLogger(__name__)
  18. class NotificationService:
  19. """Service for sending notifications through various providers."""
  20. def __init__(self):
  21. self._http_client: httpx.AsyncClient | None = None
  22. self._template_cache: dict[str, NotificationTemplate] = {}
  23. self._digest_scheduler_task: asyncio.Task | None = None
  24. self._last_digest_check: str = "" # "HH:MM" to avoid duplicate checks
  25. async def _get_client(self) -> httpx.AsyncClient:
  26. """Get or create HTTP client."""
  27. if self._http_client is None or self._http_client.is_closed:
  28. self._http_client = httpx.AsyncClient(timeout=30.0)
  29. return self._http_client
  30. async def close(self):
  31. """Close HTTP client."""
  32. if self._http_client and not self._http_client.is_closed:
  33. await self._http_client.aclose()
  34. def _is_in_quiet_hours(self, provider: NotificationProvider) -> bool:
  35. """Check if current time is within provider's quiet hours."""
  36. if not provider.quiet_hours_enabled:
  37. return False
  38. if not provider.quiet_hours_start or not provider.quiet_hours_end:
  39. return False
  40. try:
  41. now = datetime.now()
  42. current_time = now.hour * 60 + now.minute
  43. start_parts = provider.quiet_hours_start.split(":")
  44. end_parts = provider.quiet_hours_end.split(":")
  45. start_minutes = int(start_parts[0]) * 60 + int(start_parts[1])
  46. end_minutes = int(end_parts[0]) * 60 + int(end_parts[1])
  47. # Handle overnight quiet hours (e.g., 22:00 to 07:00)
  48. if start_minutes > end_minutes:
  49. # Quiet hours span midnight
  50. return current_time >= start_minutes or current_time < end_minutes
  51. else:
  52. # Same day quiet hours
  53. return start_minutes <= current_time < end_minutes
  54. except (ValueError, TypeError, AttributeError):
  55. logger.warning("Invalid quiet hours format for provider %s", provider.name)
  56. return False
  57. async def _get_template(self, db: AsyncSession, event_type: str) -> NotificationTemplate | None:
  58. """Get a notification template by event type."""
  59. # Check cache first
  60. if event_type in self._template_cache:
  61. return self._template_cache[event_type]
  62. result = await db.execute(select(NotificationTemplate).where(NotificationTemplate.event_type == event_type))
  63. template = result.scalar_one_or_none()
  64. if template:
  65. self._template_cache[event_type] = template
  66. return template
  67. def _render_template(self, template_str: str, variables: dict[str, Any]) -> str:
  68. """Render a template string with variables. Missing variables become empty."""
  69. result = template_str
  70. for key, value in variables.items():
  71. result = result.replace("{" + key + "}", str(value) if value is not None else "")
  72. # Remove any remaining unreplaced placeholders
  73. result = re.sub(r"\{[a-z_]+\}", "", result)
  74. return result
  75. async def _format_eta(self, seconds: int | None, db: AsyncSession) -> str:
  76. """Format ETA as wall-clock time, respecting user's time_format setting."""
  77. if not seconds or seconds <= 0:
  78. return "Unknown"
  79. from backend.app.api.routes.settings import get_setting
  80. eta_time = datetime.now() + timedelta(seconds=seconds)
  81. time_format = await get_setting(db, "time_format")
  82. if time_format == "12h":
  83. return eta_time.strftime("%I:%M %p").lstrip("0")
  84. # Default to 24h for "24h", "system", or unset
  85. return eta_time.strftime("%H:%M")
  86. def _format_duration(self, seconds: int | None) -> str:
  87. """Format duration in seconds to human-readable string."""
  88. if seconds is None:
  89. return "Unknown"
  90. hours = seconds // 3600
  91. minutes = (seconds % 3600) // 60
  92. if hours > 0:
  93. return f"{hours}h {minutes}m"
  94. return f"{minutes}m"
  95. def _clean_filename(self, filename: str) -> str:
  96. """Extract filename and remove file extensions."""
  97. import os
  98. # Strip path prefix (e.g., /data/Metadata/plate_5.gcode -> plate_5.gcode)
  99. filename = os.path.basename(filename)
  100. # Remove common extensions
  101. if filename.endswith(".gcode.3mf"):
  102. return filename[:-10]
  103. elif filename.endswith(".gcode"):
  104. return filename[:-6]
  105. elif filename.endswith(".3mf"):
  106. return filename[:-4]
  107. return filename
  108. async def _build_message_from_template(
  109. self, db: AsyncSession, event_type: str, variables: dict[str, Any]
  110. ) -> tuple[str, str]:
  111. """Build notification title and body from template."""
  112. # Add common variables
  113. variables["timestamp"] = datetime.now().strftime("%Y-%m-%d %H:%M")
  114. variables["app_name"] = "Bambuddy"
  115. template = await self._get_template(db, event_type)
  116. if not template:
  117. # Fallback to simple message
  118. logger.warning("Template not found for event type: %s", event_type)
  119. return event_type.replace("_", " ").title(), str(variables)
  120. title = self._render_template(template.title_template, variables)
  121. body = self._render_template(template.body_template, variables)
  122. return title, body
  123. async def send_test_notification(
  124. self, provider_type: str, config: dict[str, Any], db: AsyncSession | None = None
  125. ) -> tuple[bool, str]:
  126. """Send a test notification to verify configuration."""
  127. if db:
  128. title, message = await self._build_message_from_template(db, "test", {})
  129. else:
  130. title = "Bambuddy Test"
  131. message = "This is a test notification. If you see this, notifications are working!"
  132. try:
  133. if provider_type == "callmebot":
  134. return await self._send_callmebot(config, f"{title}\n{message}")
  135. elif provider_type == "ntfy":
  136. return await self._send_ntfy(config, title, message)
  137. elif provider_type == "pushover":
  138. return await self._send_pushover(config, title, message)
  139. elif provider_type == "telegram":
  140. return await self._send_telegram(config, f"*{title}*\n{message}")
  141. elif provider_type == "email":
  142. return await self._send_email(config, title, message)
  143. elif provider_type == "discord":
  144. return await self._send_discord(config, title, message)
  145. elif provider_type == "webhook":
  146. return await self._send_webhook(config, title, message)
  147. else:
  148. return False, f"Unknown provider type: {provider_type}"
  149. except Exception as e:
  150. logger.exception("Error sending test notification via %s", provider_type)
  151. return False, str(e)
  152. async def _send_callmebot(self, config: dict, message: str) -> tuple[bool, str]:
  153. """Send notification via CallMeBot (WhatsApp)."""
  154. phone = config.get("phone", "").strip()
  155. apikey = config.get("apikey", "").strip()
  156. if not phone or not apikey:
  157. return False, "Phone number and API key are required"
  158. # URL encode the message
  159. encoded_message = quote(message)
  160. url = f"https://api.callmebot.com/whatsapp.php?phone={phone}&text={encoded_message}&apikey={apikey}"
  161. client = await self._get_client()
  162. response = await client.get(url)
  163. if response.status_code == 200:
  164. return True, "Message sent successfully"
  165. else:
  166. return False, f"HTTP {response.status_code}: {response.text[:200]}"
  167. async def _send_ntfy(
  168. self, config: dict, title: str, message: str, image_data: bytes | None = None
  169. ) -> tuple[bool, str]:
  170. """Send notification via ntfy."""
  171. server = config.get("server", "https://ntfy.sh").rstrip("/")
  172. topic = config.get("topic", "").strip()
  173. auth_token = config.get("auth_token", "").strip()
  174. if not topic:
  175. return False, "Topic is required"
  176. url = f"{server}/{topic}"
  177. headers = {"Title": title}
  178. if auth_token:
  179. headers["Authorization"] = f"Bearer {auth_token}"
  180. client = await self._get_client()
  181. if image_data:
  182. # ntfy supports image attachments via multipart form-data.
  183. # HTTP headers cannot contain newlines, but ntfy interprets
  184. # literal \n (backslash-n) as newlines in the Message header.
  185. headers["Filename"] = "photo.jpg"
  186. headers["Message"] = message.replace("\n", "\\n")
  187. response = await client.put(url, content=image_data, headers=headers)
  188. if response.status_code == 400 and "attachments not allowed" in response.text:
  189. # Server has attachments disabled — retry without the image
  190. headers.pop("Filename", None)
  191. headers.pop("Message", None)
  192. response = await client.post(url, content=message, headers=headers)
  193. else:
  194. response = await client.post(url, content=message, headers=headers)
  195. if response.status_code in (200, 204):
  196. return True, "Message sent successfully"
  197. else:
  198. return False, f"HTTP {response.status_code}: {response.text[:200]}"
  199. async def _send_pushover(
  200. self, config: dict, title: str, message: str, image_data: bytes | None = None
  201. ) -> tuple[bool, str]:
  202. """Send notification via Pushover.
  203. Args:
  204. config: Provider configuration with user_key, app_token, priority
  205. title: Notification title
  206. message: Notification body
  207. image_data: Optional JPEG image bytes to attach (max 2.5MB)
  208. """
  209. user_key = config.get("user_key", "").strip()
  210. app_token = config.get("app_token", "").strip()
  211. priority = config.get("priority", 0)
  212. if not user_key or not app_token:
  213. return False, "User key and app token are required"
  214. url = "https://api.pushover.net/1/messages.json"
  215. data = {
  216. "token": app_token,
  217. "user": user_key,
  218. "title": title,
  219. "message": message,
  220. "priority": priority,
  221. }
  222. client = await self._get_client()
  223. if image_data:
  224. # Pushover supports image attachments via multipart form-data
  225. files = {"attachment": ("photo.jpg", image_data, "image/jpeg")}
  226. response = await client.post(url, data=data, files=files)
  227. else:
  228. response = await client.post(url, data=data)
  229. if response.status_code == 200:
  230. return True, "Message sent successfully"
  231. else:
  232. try:
  233. error_data = response.json()
  234. errors = error_data.get("errors", [])
  235. return False, f"Pushover error: {', '.join(errors)}"
  236. except Exception:
  237. return False, f"HTTP {response.status_code}: {response.text[:200]}"
  238. async def _send_telegram(self, config: dict, message: str, image_data: bytes | None = None) -> tuple[bool, str]:
  239. """Send notification via Telegram bot."""
  240. bot_token = config.get("bot_token", "").strip()
  241. chat_id = config.get("chat_id", "").strip()
  242. if not bot_token or not chat_id:
  243. return False, "Bot token and chat ID are required"
  244. # Escape underscores in the message body so Telegram Markdown
  245. # parsing doesn't break on job names like "A1_plate_8" or error
  246. # codes like "0300_0001". The title is already wrapped in *bold*
  247. # markers, so only escape after the first newline.
  248. if "\n" in message:
  249. title_part, body_part = message.split("\n", 1)
  250. body_part = body_part.replace("_", "\\_")
  251. message = f"{title_part}\n{body_part}"
  252. client = await self._get_client()
  253. if image_data:
  254. # Use sendPhoto to attach the thumbnail with the caption
  255. url = f"https://api.telegram.org/bot{bot_token}/sendPhoto"
  256. response = await client.post(
  257. url,
  258. data={"chat_id": chat_id, "caption": message, "parse_mode": "Markdown"},
  259. files={"photo": ("photo.jpg", image_data, "image/jpeg")},
  260. )
  261. else:
  262. url = f"https://api.telegram.org/bot{bot_token}/sendMessage"
  263. data = {
  264. "chat_id": chat_id,
  265. "text": message,
  266. "parse_mode": "Markdown",
  267. }
  268. response = await client.post(url, json=data)
  269. if response.status_code == 200:
  270. result = response.json()
  271. if result.get("ok"):
  272. return True, "Message sent successfully"
  273. else:
  274. return False, f"Telegram error: {result.get('description', 'Unknown error')}"
  275. else:
  276. return False, f"HTTP {response.status_code}: {response.text[:200]}"
  277. async def _send_email(self, config: dict, subject: str, body: str) -> tuple[bool, str]:
  278. """Send notification via email (SMTP)."""
  279. smtp_server = config.get("smtp_server", "").strip()
  280. smtp_port = int(config.get("smtp_port", 587))
  281. username = config.get("username", "").strip()
  282. password = config.get("password", "").strip()
  283. from_email = config.get("from_email", "").strip()
  284. to_email = config.get("to_email", "").strip()
  285. # Security: "starttls" (port 587), "ssl" (port 465), "none" (port 25)
  286. security = config.get("security", "starttls")
  287. # Authentication: "true" or "false"
  288. auth_enabled = config.get("auth_enabled", "true").lower() == "true"
  289. if not all([smtp_server, from_email, to_email]):
  290. return False, "SMTP server, from email, and to email are required"
  291. if auth_enabled and not all([username, password]):
  292. return False, "Username and password are required when authentication is enabled"
  293. try:
  294. msg = MIMEMultipart()
  295. msg["From"] = from_email
  296. msg["To"] = to_email
  297. msg["Subject"] = f"[Bambuddy] {subject}"
  298. msg.attach(MIMEText(body, "plain"))
  299. if security == "ssl":
  300. # Direct SSL connection (typically port 465)
  301. server = smtplib.SMTP_SSL(smtp_server, smtp_port)
  302. elif security == "starttls":
  303. # STARTTLS upgrade (typically port 587)
  304. server = smtplib.SMTP(smtp_server, smtp_port)
  305. server.starttls()
  306. else:
  307. # No encryption (typically port 25) - use with caution
  308. server = smtplib.SMTP(smtp_server, smtp_port)
  309. if auth_enabled:
  310. server.login(username, password)
  311. server.sendmail(from_email, to_email, msg.as_string())
  312. server.quit()
  313. return True, "Email sent successfully"
  314. except smtplib.SMTPAuthenticationError:
  315. return False, "SMTP authentication failed - check username/password"
  316. except smtplib.SMTPException as e:
  317. return False, f"SMTP error: {str(e)}"
  318. except Exception as e:
  319. return False, f"Email error: {str(e)}"
  320. async def _send_discord(
  321. self, config: dict, title: str, message: str, image_data: bytes | None = None
  322. ) -> tuple[bool, str]:
  323. """Send notification via Discord webhook."""
  324. webhook_url = config.get("webhook_url", "").strip()
  325. if not webhook_url:
  326. return False, "Webhook URL is required"
  327. if not webhook_url.startswith("https://discord.com/api/webhooks/"):
  328. return False, "Invalid Discord webhook URL"
  329. # Discord embed format for nicer messages
  330. embed = {
  331. "title": title,
  332. "description": message,
  333. "color": 0x00AE42, # Bambu green
  334. }
  335. client = await self._get_client()
  336. if image_data:
  337. # Attach image via multipart form-data and reference in embed
  338. embed["image"] = {"url": "attachment://photo.jpg"}
  339. payload = {"embeds": [embed]}
  340. response = await client.post(
  341. webhook_url,
  342. data={"payload_json": json.dumps(payload)},
  343. files={"files[0]": ("photo.jpg", image_data, "image/jpeg")},
  344. )
  345. else:
  346. response = await client.post(webhook_url, json={"embeds": [embed]})
  347. if response.status_code in (200, 204):
  348. return True, "Message sent successfully"
  349. else:
  350. return False, f"HTTP {response.status_code}: {response.text[:200]}"
  351. async def _send_webhook(self, config: dict, title: str, message: str) -> tuple[bool, str]:
  352. """Send notification via generic webhook (POST JSON).
  353. Supports two payload formats:
  354. - generic: Custom field names with timestamp/source metadata
  355. - slack: Slack/Mattermost compatible format (just {"text": "..."})
  356. """
  357. webhook_url = config.get("webhook_url", "").strip()
  358. auth_header = config.get("auth_header", "").strip()
  359. payload_format = config.get("payload_format", "generic").strip()
  360. if not webhook_url:
  361. return False, "Webhook URL is required"
  362. # Build payload based on format
  363. if payload_format == "slack":
  364. # Slack/Mattermost format - just text field
  365. data = {"text": f"*{title}*\n{message}"}
  366. else:
  367. # Generic format with custom field names
  368. custom_field_title = config.get("field_title", "title").strip() or "title"
  369. custom_field_message = config.get("field_message", "message").strip() or "message"
  370. data = {
  371. custom_field_title: title,
  372. custom_field_message: message,
  373. "timestamp": datetime.now().isoformat(),
  374. "source": "Bambuddy",
  375. }
  376. headers = {"Content-Type": "application/json"}
  377. if auth_header:
  378. # Support "Bearer token" or just "token" format
  379. if " " in auth_header:
  380. headers["Authorization"] = auth_header
  381. else:
  382. headers["Authorization"] = f"Bearer {auth_header}"
  383. client = await self._get_client()
  384. try:
  385. response = await client.post(webhook_url, json=data, headers=headers)
  386. if response.status_code in (200, 201, 202, 204):
  387. return True, "Webhook delivered successfully"
  388. else:
  389. return False, f"HTTP {response.status_code}: {response.text[:200]}"
  390. except Exception as e:
  391. return False, f"Webhook error: {str(e)}"
  392. async def _send_to_provider(
  393. self,
  394. provider: NotificationProvider,
  395. title: str,
  396. message: str,
  397. db: AsyncSession | None = None,
  398. image_data: bytes | None = None,
  399. ) -> tuple[bool, str]:
  400. """Send notification to a specific provider."""
  401. # Check quiet hours
  402. if self._is_in_quiet_hours(provider):
  403. logger.info("Skipping notification to %s - quiet hours active", provider.name)
  404. return True, "Skipped - quiet hours"
  405. config = json.loads(provider.config) if isinstance(provider.config, str) else provider.config
  406. try:
  407. if provider.provider_type == "callmebot":
  408. return await self._send_callmebot(config, f"{title}\n{message}")
  409. elif provider.provider_type == "ntfy":
  410. return await self._send_ntfy(config, title, message, image_data=image_data)
  411. elif provider.provider_type == "pushover":
  412. return await self._send_pushover(config, title, message, image_data=image_data)
  413. elif provider.provider_type == "telegram":
  414. return await self._send_telegram(config, f"*{title}*\n{message}", image_data=image_data)
  415. elif provider.provider_type == "email":
  416. return await self._send_email(config, title, message)
  417. elif provider.provider_type == "discord":
  418. return await self._send_discord(config, title, message, image_data=image_data)
  419. elif provider.provider_type == "webhook":
  420. return await self._send_webhook(config, title, message)
  421. else:
  422. return False, f"Unknown provider type: {provider.provider_type}"
  423. except Exception as e:
  424. logger.exception("Error sending notification via %s", provider.provider_type)
  425. return False, str(e)
  426. async def _update_provider_status(
  427. self, db: AsyncSession, provider_id: int, success: bool, error: str | None = None
  428. ):
  429. """Update provider status after sending notification."""
  430. result = await db.execute(select(NotificationProvider).where(NotificationProvider.id == provider_id))
  431. provider = result.scalar_one_or_none()
  432. if provider:
  433. if success:
  434. provider.last_success = datetime.now(timezone.utc)
  435. else:
  436. provider.last_error = error
  437. provider.last_error_at = datetime.now(timezone.utc)
  438. await db.commit()
  439. async def _get_providers_for_event(
  440. self,
  441. db: AsyncSession,
  442. event_field: str,
  443. printer_id: int | None = None,
  444. ) -> list[NotificationProvider]:
  445. """Get all enabled providers that want a specific event type."""
  446. # Build the query dynamically based on event field
  447. query = select(NotificationProvider).where(
  448. NotificationProvider.enabled.is_(True),
  449. getattr(NotificationProvider, event_field).is_(True),
  450. )
  451. if printer_id is not None:
  452. query = query.where(
  453. (NotificationProvider.printer_id.is_(None)) | (NotificationProvider.printer_id == printer_id)
  454. )
  455. result = await db.execute(query)
  456. return list(result.scalars().all())
  457. async def _log_notification(
  458. self,
  459. db: AsyncSession,
  460. provider_id: int,
  461. event_type: str,
  462. title: str,
  463. message: str,
  464. success: bool,
  465. error_message: str | None = None,
  466. printer_id: int | None = None,
  467. printer_name: str | None = None,
  468. ):
  469. """Create a log entry for a sent notification."""
  470. try:
  471. log = NotificationLog(
  472. provider_id=provider_id,
  473. event_type=event_type,
  474. title=title,
  475. message=message,
  476. success=success,
  477. error_message=error_message,
  478. printer_id=printer_id,
  479. printer_name=printer_name,
  480. )
  481. db.add(log)
  482. await db.commit()
  483. except Exception as e:
  484. logger.warning("Failed to log notification: %s", e)
  485. # Don't fail the notification just because logging failed
  486. async def _send_to_providers(
  487. self,
  488. providers: list[NotificationProvider],
  489. title: str,
  490. message: str,
  491. db: AsyncSession,
  492. event_type: str = "unknown",
  493. printer_id: int | None = None,
  494. printer_name: str | None = None,
  495. force_immediate: bool = False,
  496. image_data: bytes | None = None,
  497. ):
  498. """Send notification to multiple providers and log the results.
  499. All notifications are always sent immediately. If digest mode is enabled,
  500. the notification is ALSO queued for the daily digest summary.
  501. """
  502. for provider in providers:
  503. try:
  504. # Always send notification immediately
  505. success, error = await self._send_to_provider(provider, title, message, db, image_data=image_data)
  506. # Also queue for digest if enabled (digest is a summary, not a queue)
  507. if provider.daily_digest_enabled and provider.daily_digest_time:
  508. await self._queue_for_digest(
  509. provider=provider,
  510. event_type=event_type,
  511. title=title,
  512. message=message,
  513. db=db,
  514. printer_id=printer_id,
  515. printer_name=printer_name,
  516. )
  517. await self._update_provider_status(db, provider.id, success, error if not success else None)
  518. await self._log_notification(
  519. db=db,
  520. provider_id=provider.id,
  521. event_type=event_type,
  522. title=title,
  523. message=message,
  524. success=success,
  525. error_message=error if not success else None,
  526. printer_id=printer_id,
  527. printer_name=printer_name,
  528. )
  529. if success:
  530. logger.info("Sent notification via %s", provider.name)
  531. else:
  532. logger.warning("Failed to send notification via %s: %s", provider.name, error)
  533. except Exception as e:
  534. logger.exception("Error sending notification via %s", provider.name)
  535. await self._update_provider_status(db, provider.id, False, str(e))
  536. await self._log_notification(
  537. db=db,
  538. provider_id=provider.id,
  539. event_type=event_type,
  540. title=title,
  541. message=message,
  542. success=False,
  543. error_message=str(e),
  544. printer_id=printer_id,
  545. printer_name=printer_name,
  546. )
  547. async def on_print_start(
  548. self,
  549. printer_id: int,
  550. printer_name: str,
  551. data: dict,
  552. db: AsyncSession,
  553. archive_data: dict | None = None,
  554. ):
  555. """Handle print start event - send notifications to relevant providers.
  556. Args:
  557. printer_id: The printer ID
  558. printer_name: The printer name
  559. data: MQTT event data with filename, subtask_name, remaining_time, raw_data
  560. db: Database session
  561. archive_data: Optional archive data with print_time_seconds from 3MF parsing
  562. """
  563. logger.info("on_print_start called for printer %s (%s)", printer_id, printer_name)
  564. providers = await self._get_providers_for_event(db, "on_print_start", printer_id)
  565. if not providers:
  566. logger.info("No notification providers configured for print_start event on printer %s", printer_id)
  567. return
  568. # Use subtask_name (project name) if available, otherwise use filename
  569. subtask_name = data.get("subtask_name")
  570. if subtask_name:
  571. # Replace underscores with spaces for readability
  572. filename = subtask_name.replace("_", " ")
  573. else:
  574. filename = self._clean_filename(data.get("filename", "Unknown"))
  575. # Priority for estimated_time:
  576. # 1. Archive's print_time_seconds from 3MF parsing (most reliable)
  577. # 2. MQTT remaining_time (may be 0 at print start)
  578. # 3. raw_data mc_remaining_time
  579. estimated_time = None
  580. # Try archive data first (from 3MF parsing - most reliable)
  581. if archive_data and archive_data.get("print_time_seconds"):
  582. estimated_time = archive_data["print_time_seconds"]
  583. logger.debug("Using print_time_seconds from archive: %s", estimated_time)
  584. # Fall back to MQTT remaining_time
  585. if estimated_time is None:
  586. estimated_time = data.get("remaining_time")
  587. if estimated_time:
  588. logger.debug("Using remaining_time from MQTT: %s", estimated_time)
  589. # Last resort: raw_data mc_remaining_time (in minutes, convert to seconds)
  590. if estimated_time is None:
  591. raw_time = data.get("raw_data", {}).get("mc_remaining_time")
  592. if raw_time:
  593. estimated_time = raw_time * 60
  594. logger.debug("Using mc_remaining_time from raw_data: %s", estimated_time)
  595. time_str = self._format_duration(estimated_time)
  596. eta_str = await self._format_eta(estimated_time, db)
  597. variables = {
  598. "printer": printer_name,
  599. "filename": filename,
  600. "estimated_time": time_str,
  601. "eta": eta_str,
  602. }
  603. # Extract image data for providers that support attachments (e.g. Pushover)
  604. image_data = None
  605. if archive_data:
  606. image_data = archive_data.get("image_data")
  607. logger.info("Found %s providers for print_start: %s", len(providers), [p.name for p in providers])
  608. title, message = await self._build_message_from_template(db, "print_start", variables)
  609. await self._send_to_providers(
  610. providers, title, message, db, "print_start", printer_id, printer_name, image_data=image_data
  611. )
  612. async def on_print_complete(
  613. self,
  614. printer_id: int,
  615. printer_name: str,
  616. status: str,
  617. data: dict,
  618. db: AsyncSession,
  619. archive_data: dict | None = None,
  620. ):
  621. """Handle print complete event - send notifications to relevant providers."""
  622. logger.info("on_print_complete called for printer %s (%s), status=%s", printer_id, printer_name, status)
  623. # Determine event type based on status
  624. if status == "completed":
  625. event_field = "on_print_complete"
  626. event_type = "print_complete"
  627. elif status in ("failed",):
  628. event_field = "on_print_failed"
  629. event_type = "print_failed"
  630. elif status in ("aborted", "stopped", "cancelled"):
  631. event_field = "on_print_stopped"
  632. event_type = "print_stopped"
  633. else:
  634. logger.warning("Unknown print status '%s', defaulting to on_print_complete", status)
  635. event_field = "on_print_complete"
  636. event_type = "print_complete"
  637. providers = await self._get_providers_for_event(db, event_field, printer_id)
  638. if not providers:
  639. logger.info("No notification providers configured for %s event on printer %s", event_field, printer_id)
  640. return
  641. # Use subtask_name (project name) if available, otherwise use filename
  642. subtask_name = data.get("subtask_name")
  643. if subtask_name:
  644. filename = subtask_name.replace("_", " ")
  645. else:
  646. filename = self._clean_filename(data.get("filename", "Unknown"))
  647. variables = {
  648. "printer": printer_name,
  649. "filename": filename,
  650. "duration": "Unknown",
  651. "filament_grams": "Unknown",
  652. "reason": "Unknown",
  653. }
  654. if archive_data:
  655. if archive_data.get("print_time_seconds"):
  656. variables["duration"] = self._format_duration(archive_data["print_time_seconds"])
  657. if archive_data.get("actual_filament_grams"):
  658. variables["filament_grams"] = f"{archive_data['actual_filament_grams']:.1f}"
  659. if status == "failed" and archive_data.get("failure_reason"):
  660. variables["reason"] = archive_data["failure_reason"]
  661. if archive_data.get("finish_photo_url"):
  662. variables["finish_photo_url"] = archive_data["finish_photo_url"]
  663. # Build per-slot breakdown string with AMS info when available
  664. if archive_data.get("usage_results"):
  665. parts = []
  666. for u in archive_data["usage_results"]:
  667. ams_id = u.get("ams_id", 0)
  668. tray_id = u.get("tray_id", 0)
  669. material = u.get("material", "Unknown") or "Unknown"
  670. used = u.get("weight_used", 0)
  671. if ams_id >= 128:
  672. slot_label = "Ext"
  673. else:
  674. slot_label = f"AMS-{chr(65 + ams_id)} T{tray_id + 1}"
  675. parts.append(f"{slot_label} {material}: {used:.1f}g")
  676. variables["filament_details"] = " | ".join(parts)
  677. elif archive_data.get("filament_slots"):
  678. parts = []
  679. for slot in archive_data["filament_slots"]:
  680. ftype = slot.get("type", "Unknown") or "Unknown"
  681. used = slot.get("used_g", 0)
  682. parts.append(f"{ftype}: {used:.1f}g")
  683. variables["filament_details"] = " | ".join(parts)
  684. # Add progress for partial prints
  685. if archive_data.get("progress") is not None:
  686. variables["progress"] = str(archive_data["progress"])
  687. # Extract image data for providers that support attachments (e.g. Pushover)
  688. image_data = None
  689. if archive_data:
  690. image_data = archive_data.get("image_data")
  691. logger.info("Found %s providers for %s: %s", len(providers), event_field, [p.name for p in providers])
  692. title, message = await self._build_message_from_template(db, event_type, variables)
  693. await self._send_to_providers(
  694. providers, title, message, db, event_type, printer_id, printer_name, image_data=image_data
  695. )
  696. async def on_print_progress(
  697. self,
  698. printer_id: int,
  699. printer_name: str,
  700. filename: str,
  701. progress: int,
  702. db: AsyncSession,
  703. remaining_time: int | None = None,
  704. image_data: bytes | None = None,
  705. ):
  706. """Handle print progress milestone (25%, 50%, 75%)."""
  707. providers = await self._get_providers_for_event(db, "on_print_progress", printer_id)
  708. if not providers:
  709. return
  710. eta_str = await self._format_eta(remaining_time, db)
  711. variables = {
  712. "printer": printer_name,
  713. "filename": self._clean_filename(filename),
  714. "progress": str(progress),
  715. "remaining_time": self._format_duration(remaining_time) if remaining_time else "Unknown",
  716. "eta": eta_str,
  717. }
  718. title, message = await self._build_message_from_template(db, "print_progress", variables)
  719. await self._send_to_providers(
  720. providers, title, message, db, "print_progress", printer_id, printer_name, image_data=image_data
  721. )
  722. async def on_printer_offline(self, printer_id: int, printer_name: str, db: AsyncSession):
  723. """Handle printer offline event."""
  724. providers = await self._get_providers_for_event(db, "on_printer_offline", printer_id)
  725. if not providers:
  726. return
  727. variables = {"printer": printer_name}
  728. title, message = await self._build_message_from_template(db, "printer_offline", variables)
  729. await self._send_to_providers(providers, title, message, db, "printer_offline", printer_id, printer_name)
  730. async def on_printer_error(
  731. self,
  732. printer_id: int,
  733. printer_name: str,
  734. error_type: str,
  735. db: AsyncSession,
  736. error_detail: str | None = None,
  737. image_data: bytes | None = None,
  738. ):
  739. """Handle printer error event (AMS issues, etc.)."""
  740. providers = await self._get_providers_for_event(db, "on_printer_error", printer_id)
  741. if not providers:
  742. return
  743. variables = {
  744. "printer": printer_name,
  745. "error_type": error_type,
  746. "error_detail": error_detail or "No details available",
  747. }
  748. title, message = await self._build_message_from_template(db, "printer_error", variables)
  749. await self._send_to_providers(
  750. providers, title, message, db, "printer_error", printer_id, printer_name, image_data=image_data
  751. )
  752. async def on_plate_not_empty(
  753. self,
  754. printer_id: int,
  755. printer_name: str,
  756. db: AsyncSession,
  757. difference_percent: float | None = None,
  758. ):
  759. """Handle plate not empty event - objects detected on build plate before print."""
  760. providers = await self._get_providers_for_event(db, "on_plate_not_empty", printer_id)
  761. if not providers:
  762. return
  763. variables = {
  764. "printer": printer_name,
  765. "difference_percent": f"{difference_percent:.1f}" if difference_percent else "N/A",
  766. }
  767. title, message = await self._build_message_from_template(db, "plate_not_empty", variables)
  768. await self._send_to_providers(
  769. providers, title, message, db, "plate_not_empty", printer_id, printer_name, force_immediate=True
  770. )
  771. async def on_filament_low(
  772. self,
  773. printer_id: int,
  774. printer_name: str,
  775. slot: int,
  776. remaining_percent: int,
  777. db: AsyncSession,
  778. color: str | None = None,
  779. ):
  780. """Handle low filament event."""
  781. providers = await self._get_providers_for_event(db, "on_filament_low", printer_id)
  782. if not providers:
  783. return
  784. variables = {
  785. "printer": printer_name,
  786. "slot": str(slot),
  787. "remaining_percent": str(remaining_percent),
  788. "color": color or "",
  789. }
  790. title, message = await self._build_message_from_template(db, "filament_low", variables)
  791. await self._send_to_providers(providers, title, message, db, "filament_low", printer_id, printer_name)
  792. async def on_maintenance_due(
  793. self,
  794. printer_id: int,
  795. printer_name: str,
  796. maintenance_items: list[dict],
  797. db: AsyncSession,
  798. ):
  799. """Handle maintenance due event - sends notification when maintenance is due or warning."""
  800. if not maintenance_items:
  801. return
  802. providers = await self._get_providers_for_event(db, "on_maintenance_due", printer_id)
  803. if not providers:
  804. logger.info("No notification providers configured for maintenance_due event on printer %s", printer_id)
  805. return
  806. # Format maintenance items list
  807. items_list = []
  808. for item in maintenance_items:
  809. status = "OVERDUE" if item.get("is_due") else "Soon"
  810. items_list.append(f"- {item['name']} ({status})")
  811. items_str = "\n".join(items_list)
  812. variables = {
  813. "printer": printer_name,
  814. "items": items_str,
  815. }
  816. logger.info("Found %s providers for maintenance_due: %s", len(providers), [p.name for p in providers])
  817. title, message = await self._build_message_from_template(db, "maintenance_due", variables)
  818. await self._send_to_providers(providers, title, message, db, "maintenance_due", printer_id, printer_name)
  819. async def on_ams_humidity_high(
  820. self,
  821. printer_id: int,
  822. printer_name: str,
  823. ams_label: str,
  824. humidity: float,
  825. threshold: float,
  826. db: AsyncSession,
  827. ):
  828. """Handle AMS high humidity alarm event. Always sends immediately (bypasses digest)."""
  829. providers = await self._get_providers_for_event(db, "on_ams_humidity_high", printer_id)
  830. if not providers:
  831. return
  832. variables = {
  833. "printer": printer_name,
  834. "ams_label": ams_label,
  835. "humidity": f"{humidity:.0f}",
  836. "threshold": f"{threshold:.0f}",
  837. }
  838. title, message = await self._build_message_from_template(db, "ams_humidity_high", variables)
  839. # Alarms always send immediately, bypassing digest mode
  840. await self._send_to_providers(
  841. providers, title, message, db, "ams_humidity_high", printer_id, printer_name, force_immediate=True
  842. )
  843. async def on_ams_temperature_high(
  844. self,
  845. printer_id: int,
  846. printer_name: str,
  847. ams_label: str,
  848. temperature: float,
  849. threshold: float,
  850. db: AsyncSession,
  851. ):
  852. """Handle AMS high temperature alarm event. Always sends immediately (bypasses digest)."""
  853. providers = await self._get_providers_for_event(db, "on_ams_temperature_high", printer_id)
  854. if not providers:
  855. return
  856. variables = {
  857. "printer": printer_name,
  858. "ams_label": ams_label,
  859. "temperature": f"{temperature:.1f}",
  860. "threshold": f"{threshold:.1f}",
  861. }
  862. title, message = await self._build_message_from_template(db, "ams_temperature_high", variables)
  863. # Alarms always send immediately, bypassing digest mode
  864. await self._send_to_providers(
  865. providers, title, message, db, "ams_temperature_high", printer_id, printer_name, force_immediate=True
  866. )
  867. async def on_ams_ht_humidity_high(
  868. self,
  869. printer_id: int,
  870. printer_name: str,
  871. ams_label: str,
  872. humidity: float,
  873. threshold: float,
  874. db: AsyncSession,
  875. ):
  876. """Handle AMS-HT high humidity alarm event. Always sends immediately (bypasses digest)."""
  877. providers = await self._get_providers_for_event(db, "on_ams_ht_humidity_high", printer_id)
  878. if not providers:
  879. return
  880. variables = {
  881. "printer": printer_name,
  882. "ams_label": ams_label,
  883. "humidity": f"{humidity:.0f}",
  884. "threshold": f"{threshold:.0f}",
  885. }
  886. # Use the same template as regular AMS (can create separate templates later if needed)
  887. title, message = await self._build_message_from_template(db, "ams_humidity_high", variables)
  888. # Alarms always send immediately, bypassing digest mode
  889. await self._send_to_providers(
  890. providers, title, message, db, "ams_ht_humidity_high", printer_id, printer_name, force_immediate=True
  891. )
  892. async def on_ams_ht_temperature_high(
  893. self,
  894. printer_id: int,
  895. printer_name: str,
  896. ams_label: str,
  897. temperature: float,
  898. threshold: float,
  899. db: AsyncSession,
  900. ):
  901. """Handle AMS-HT high temperature alarm event. Always sends immediately (bypasses digest)."""
  902. providers = await self._get_providers_for_event(db, "on_ams_ht_temperature_high", printer_id)
  903. if not providers:
  904. return
  905. variables = {
  906. "printer": printer_name,
  907. "ams_label": ams_label,
  908. "temperature": f"{temperature:.1f}",
  909. "threshold": f"{threshold:.1f}",
  910. }
  911. # Use the same template as regular AMS (can create separate templates later if needed)
  912. title, message = await self._build_message_from_template(db, "ams_temperature_high", variables)
  913. # Alarms always send immediately, bypassing digest mode
  914. await self._send_to_providers(
  915. providers, title, message, db, "ams_ht_temperature_high", printer_id, printer_name, force_immediate=True
  916. )
  917. async def on_bed_cooled(
  918. self,
  919. printer_id: int,
  920. printer_name: str,
  921. bed_temp: float,
  922. threshold: float,
  923. filename: str,
  924. db: AsyncSession,
  925. ):
  926. """Handle bed cooled event - bed temperature dropped below threshold after print."""
  927. providers = await self._get_providers_for_event(db, "on_bed_cooled", printer_id)
  928. if not providers:
  929. return
  930. variables = {
  931. "printer": printer_name,
  932. "bed_temp": f"{bed_temp:.0f}",
  933. "threshold": f"{threshold:.0f}",
  934. "filename": self._clean_filename(filename) if filename else "Unknown",
  935. }
  936. title, message = await self._build_message_from_template(db, "bed_cooled", variables)
  937. await self._send_to_providers(providers, title, message, db, "bed_cooled", printer_id, printer_name)
  938. def clear_template_cache(self):
  939. """Clear the template cache. Call this when templates are updated."""
  940. self._template_cache.clear()
  941. # ==================== Queue Notifications ====================
  942. async def on_queue_job_added(
  943. self,
  944. job_name: str,
  945. target: str,
  946. db: AsyncSession,
  947. printer_id: int | None = None,
  948. printer_name: str | None = None,
  949. ):
  950. """Handle queue job added event."""
  951. providers = await self._get_providers_for_event(db, "on_queue_job_added", printer_id)
  952. if not providers:
  953. return
  954. variables = {
  955. "job_name": job_name,
  956. "target": target, # e.g., "Printer1" or "Any X1C"
  957. "printer": printer_name or target,
  958. }
  959. title, message = await self._build_message_from_template(db, "queue_job_added", variables)
  960. await self._send_to_providers(providers, title, message, db, "queue_job_added", printer_id, printer_name)
  961. async def on_queue_job_assigned(
  962. self,
  963. job_name: str,
  964. printer_id: int,
  965. printer_name: str,
  966. target_model: str,
  967. db: AsyncSession,
  968. ):
  969. """Handle model-based job assigned to printer event."""
  970. providers = await self._get_providers_for_event(db, "on_queue_job_assigned", printer_id)
  971. if not providers:
  972. return
  973. variables = {
  974. "job_name": job_name,
  975. "printer": printer_name,
  976. "target_model": target_model,
  977. }
  978. title, message = await self._build_message_from_template(db, "queue_job_assigned", variables)
  979. await self._send_to_providers(providers, title, message, db, "queue_job_assigned", printer_id, printer_name)
  980. async def on_queue_job_started(
  981. self,
  982. job_name: str,
  983. printer_id: int,
  984. printer_name: str,
  985. db: AsyncSession,
  986. estimated_time: int | None = None,
  987. ):
  988. """Handle queue job started printing event."""
  989. providers = await self._get_providers_for_event(db, "on_queue_job_started", printer_id)
  990. if not providers:
  991. return
  992. eta_str = await self._format_eta(estimated_time, db)
  993. variables = {
  994. "job_name": job_name,
  995. "printer": printer_name,
  996. "estimated_time": self._format_duration(estimated_time),
  997. "eta": eta_str,
  998. }
  999. title, message = await self._build_message_from_template(db, "queue_job_started", variables)
  1000. await self._send_to_providers(providers, title, message, db, "queue_job_started", printer_id, printer_name)
  1001. async def on_queue_job_waiting(
  1002. self,
  1003. job_name: str,
  1004. target_model: str,
  1005. waiting_reason: str,
  1006. db: AsyncSession,
  1007. ):
  1008. """Handle job waiting for filament event."""
  1009. providers = await self._get_providers_for_event(db, "on_queue_job_waiting", None)
  1010. if not providers:
  1011. return
  1012. variables = {
  1013. "job_name": job_name,
  1014. "target_model": target_model,
  1015. "waiting_reason": waiting_reason,
  1016. }
  1017. title, message = await self._build_message_from_template(db, "queue_job_waiting", variables)
  1018. await self._send_to_providers(providers, title, message, db, "queue_job_waiting")
  1019. async def on_queue_job_skipped(
  1020. self,
  1021. job_name: str,
  1022. printer_id: int,
  1023. printer_name: str,
  1024. reason: str,
  1025. db: AsyncSession,
  1026. ):
  1027. """Handle job skipped event (e.g., previous print failed)."""
  1028. providers = await self._get_providers_for_event(db, "on_queue_job_skipped", printer_id)
  1029. if not providers:
  1030. return
  1031. variables = {
  1032. "job_name": job_name,
  1033. "printer": printer_name,
  1034. "reason": reason,
  1035. }
  1036. title, message = await self._build_message_from_template(db, "queue_job_skipped", variables)
  1037. await self._send_to_providers(providers, title, message, db, "queue_job_skipped", printer_id, printer_name)
  1038. async def on_queue_job_failed(
  1039. self,
  1040. job_name: str,
  1041. printer_id: int | None,
  1042. printer_name: str | None,
  1043. reason: str,
  1044. db: AsyncSession,
  1045. ):
  1046. """Handle job failed to start event (upload error, etc.)."""
  1047. providers = await self._get_providers_for_event(db, "on_queue_job_failed", printer_id)
  1048. if not providers:
  1049. return
  1050. variables = {
  1051. "job_name": job_name,
  1052. "printer": printer_name or "Unknown",
  1053. "reason": reason,
  1054. }
  1055. title, message = await self._build_message_from_template(db, "queue_job_failed", variables)
  1056. await self._send_to_providers(providers, title, message, db, "queue_job_failed", printer_id, printer_name)
  1057. async def on_queue_completed(
  1058. self,
  1059. completed_count: int,
  1060. db: AsyncSession,
  1061. ):
  1062. """Handle all queue jobs completed event."""
  1063. providers = await self._get_providers_for_event(db, "on_queue_completed", None)
  1064. if not providers:
  1065. return
  1066. variables = {
  1067. "completed_count": str(completed_count),
  1068. }
  1069. title, message = await self._build_message_from_template(db, "queue_completed", variables)
  1070. await self._send_to_providers(providers, title, message, db, "queue_completed")
  1071. async def _queue_for_digest(
  1072. self,
  1073. provider: NotificationProvider,
  1074. event_type: str,
  1075. title: str,
  1076. message: str,
  1077. db: AsyncSession,
  1078. printer_id: int | None = None,
  1079. printer_name: str | None = None,
  1080. ):
  1081. """Queue a notification for later delivery in the daily digest."""
  1082. try:
  1083. queue_entry = NotificationDigestQueue(
  1084. provider_id=provider.id,
  1085. event_type=event_type,
  1086. title=title,
  1087. message=message,
  1088. printer_id=printer_id,
  1089. printer_name=printer_name,
  1090. )
  1091. db.add(queue_entry)
  1092. await db.commit()
  1093. logger.info("Queued notification for digest: %s for provider %s", event_type, provider.name)
  1094. except Exception as e:
  1095. logger.warning("Failed to queue notification for digest: %s", e)
  1096. async def send_digest(self, provider_id: int):
  1097. """Send all queued notifications as a single digest for a provider."""
  1098. from backend.app.core.database import async_session
  1099. async with async_session() as db:
  1100. # Get the provider
  1101. result = await db.execute(select(NotificationProvider).where(NotificationProvider.id == provider_id))
  1102. provider = result.scalar_one_or_none()
  1103. if not provider or not provider.enabled:
  1104. return
  1105. # Get all queued notifications for this provider
  1106. result = await db.execute(
  1107. select(NotificationDigestQueue)
  1108. .where(NotificationDigestQueue.provider_id == provider_id)
  1109. .order_by(NotificationDigestQueue.created_at)
  1110. )
  1111. queue_entries = list(result.scalars().all())
  1112. if not queue_entries:
  1113. logger.debug("No queued notifications for provider %s", provider.name)
  1114. return
  1115. # Build digest message
  1116. title = f"Daily Digest - {len(queue_entries)} Events"
  1117. # Group by event type
  1118. events_by_type: dict[str, list] = {}
  1119. for entry in queue_entries:
  1120. if entry.event_type not in events_by_type:
  1121. events_by_type[entry.event_type] = []
  1122. events_by_type[entry.event_type].append(entry)
  1123. # Format the digest body
  1124. body_parts = []
  1125. for event_type, entries in events_by_type.items():
  1126. event_label = event_type.replace("_", " ").title()
  1127. body_parts.append(f"== {event_label} ({len(entries)}) ==")
  1128. for entry in entries:
  1129. time_str = entry.created_at.strftime("%H:%M")
  1130. printer_info = f"[{entry.printer_name}] " if entry.printer_name else ""
  1131. body_parts.append(f" {time_str} {printer_info}{entry.title}")
  1132. body_parts.append("")
  1133. body = "\n".join(body_parts)
  1134. # Send the digest
  1135. success, error = await self._send_to_provider(provider, title, body, db)
  1136. # Log the digest
  1137. await self._log_notification(
  1138. db=db,
  1139. provider_id=provider.id,
  1140. event_type="daily_digest",
  1141. title=title,
  1142. message=body,
  1143. success=success,
  1144. error_message=error if not success else None,
  1145. )
  1146. # Clear the queue
  1147. for entry in queue_entries:
  1148. await db.delete(entry)
  1149. await db.commit()
  1150. if success:
  1151. logger.info("Sent daily digest with %s events to %s", len(queue_entries), provider.name)
  1152. else:
  1153. logger.warning("Failed to send daily digest to %s: %s", provider.name, error)
  1154. async def check_and_send_digests(self):
  1155. """Check all providers and send digests if it's their scheduled time."""
  1156. from backend.app.core.database import async_session
  1157. current_time = datetime.now().strftime("%H:%M")
  1158. # Avoid duplicate checks within the same minute
  1159. if current_time == self._last_digest_check:
  1160. return
  1161. self._last_digest_check = current_time
  1162. async with async_session() as db:
  1163. # Find all providers with digest enabled at this time
  1164. result = await db.execute(
  1165. select(NotificationProvider).where(
  1166. NotificationProvider.enabled.is_(True),
  1167. NotificationProvider.daily_digest_enabled.is_(True),
  1168. NotificationProvider.daily_digest_time == current_time,
  1169. )
  1170. )
  1171. providers = result.scalars().all()
  1172. for provider in providers:
  1173. try:
  1174. await self.send_digest(provider.id)
  1175. except Exception as e:
  1176. logger.error("Error sending digest for provider %s: %s", provider.id, e)
  1177. def start_digest_scheduler(self):
  1178. """Start the background scheduler for daily digest notifications."""
  1179. if self._digest_scheduler_task is None:
  1180. self._digest_scheduler_task = asyncio.create_task(self._digest_scheduler_loop())
  1181. logger.info("Notification digest scheduler started")
  1182. def stop_digest_scheduler(self):
  1183. """Stop the background scheduler for daily digests."""
  1184. if self._digest_scheduler_task:
  1185. self._digest_scheduler_task.cancel()
  1186. self._digest_scheduler_task = None
  1187. logger.info("Notification digest scheduler stopped")
  1188. async def _digest_scheduler_loop(self):
  1189. """Background loop that checks for scheduled digests every minute."""
  1190. while True:
  1191. try:
  1192. await self.check_and_send_digests()
  1193. except Exception as e:
  1194. logger.error("Error in digest scheduler: %s", e)
  1195. # Wait until the next minute
  1196. await asyncio.sleep(60)
  1197. # Global instance
  1198. notification_service = NotificationService()