from __future__ import annotations from datetime import timedelta, timezone from zoneinfo import ZoneInfo, ZoneInfoNotFoundError from sqlalchemy import func, select from sqlalchemy.orm import Session from sakura_cloud.models.follow import UpdateAlert from sakura_cloud.models.mixins import utc_now from sakura_cloud.models.user import User from sakura_cloud.services.push import send_update_alert_push DEFAULT_REMINDER_TIMEZONE = "Asia/Shanghai" DIGEST_PLATFORM = "system" DIGEST_CREATOR_ID = "daily-reminder" def _resolve_timezone(name: str | None) -> ZoneInfo: try: return ZoneInfo(name or DEFAULT_REMINDER_TIMEZONE) except ZoneInfoNotFoundError: return ZoneInfo(DEFAULT_REMINDER_TIMEZONE) def _display_platform(platform: str) -> str: if platform.lower() == "pixiv": return "Pixiv" if platform.lower() == "x": return "X" return platform def run_daily_reminder_digest(db: Session) -> int: now_utc = utc_now() users = db.scalars(select(User).where(User.reminder_enabled.is_(True))).all() reminders_created = 0 for user in users: zone = _resolve_timezone(user.reminder_timezone) local_now = now_utc.astimezone(zone) scheduled_today = local_now.replace( hour=user.reminder_hour, minute=user.reminder_minute, second=0, microsecond=0, ) if local_now < scheduled_today: continue if user.last_reminder_sent_at is not None: last_sent_local = user.last_reminder_sent_at.astimezone(zone) if last_sent_local.date() == local_now.date(): continue window_start = ( user.last_reminder_sent_at if user.last_reminder_sent_at is not None else (scheduled_today - timedelta(days=1)).astimezone(timezone.utc) ) new_alert_count = db.scalar( select(func.count(UpdateAlert.id)).where( UpdateAlert.user_id == user.id, UpdateAlert.platform != DIGEST_PLATFORM, UpdateAlert.created_at > window_start, ) ) or 0 recent_alerts = db.scalars( select(UpdateAlert) .where( UpdateAlert.user_id == user.id, UpdateAlert.platform != DIGEST_PLATFORM, UpdateAlert.created_at > window_start, ) .order_by(UpdateAlert.created_at.desc()) .limit(5) ).all() creator_names: list[str] = [] platforms: list[str] = [] for alert in recent_alerts: platform = _display_platform(alert.platform) if platform not in platforms: platforms.append(platform) candidate = ( alert.payload_json.get("creator_name") or alert.payload_json.get("creator_handle") or alert.payload_json.get("author") or alert.creator_id ) if candidate and candidate not in creator_names: creator_names.append(str(candidate)) date_text = f"{local_now.month}月{local_now.day}日" platforms_text = " / ".join(platforms) if platforms else "Pixiv / X" creators_text = ", ".join(creator_names[:3]) title = f"{date_text},未更新" if not new_alert_count else f"{date_text},更新 {new_alert_count} 条记录" if not new_alert_count: body = f"{date_text} 暂未发现关注作者的新内容。云端会在明天 {user.reminder_hour:02d}:{user.reminder_minute:02d} 继续检查。" elif creators_text: body = ( f"{date_text},{creators_text} 等作者带来了 {new_alert_count} " f"条新动态,来自 {platforms_text}。" ) else: body = f"{date_text},你关注的作者有 {new_alert_count} 条新动态,来自 {platforms_text}。" digest_alert = UpdateAlert( user_id=user.id, follow_id=None, platform=DIGEST_PLATFORM, creator_id=DIGEST_CREATOR_ID, title=title, body=body, content_type="digest", payload_json={ "kind": "daily_digest", "window_start": window_start.isoformat(), "new_alert_count": int(new_alert_count), "platforms": platforms, "creators": creator_names[:5], "date": local_now.date().isoformat(), "status": "updated" if new_alert_count else "not_updated", }, ) db.add(digest_alert) user.last_reminder_sent_at = now_utc db.commit() db.refresh(digest_alert) send_update_alert_push(db, digest_alert) reminders_created += 1 return reminders_created