package server import ( "context" "database/sql" "encoding/base64" "errors" "fmt" "strings" "time" "pageswiki/internal/store" ) func sendTaskDigestSMTP(ctx context.Context, config store.AuthProviderConfig, recipient, day, body string) error { // Reuse envelope validation and bounded TLS-aware SMTP transport, without // exposing SMTP credentials, recipient or task content to job logs. host, from, to, _, err := smtpMessage(config, recipient, "https://pages.invalid/") if err != nil { return err } sender, _ := smtpMailbox(config.SMTPFrom) addressee, _ := smtpMailbox(recipient) if len(body) > 128<<10 || len(day) != 10 || strings.ContainsAny(day, "\r\n\x00") { return store.ErrTaskInvalid } encoded := base64.StdEncoding.EncodeToString([]byte(body)) var lines strings.Builder for len(encoded) > 76 { lines.WriteString(encoded[:76] + "\r\n") encoded = encoded[76:] } lines.WriteString(encoded + "\r\n") message := []byte(fmt.Sprintf("To: %s\r\nFrom: %s\r\nSubject: PagesWiki tasks %s\r\nDate: %s\r\nMIME-Version: 1.0\r\nContent-Type: text/plain; charset=UTF-8\r\nContent-Transfer-Encoding: base64\r\n\r\n%s", addressee.String(), sender.String(), day, time.Now().Format(time.RFC1123Z), lines.String())) return deliverSMTPMessage(ctx, config, host, from, to, message, nil) } func (s *Server) deliverTaskDigests(ctx context.Context, job *store.EventJob) error { ctx, cancel := context.WithTimeout(ctx, 30*time.Second) defer cancel() if _, err := s.store.MaintainTaskDigests(ctx, time.Now()); err != nil { return err } queued, err := s.store.QueuedTaskDigests(ctx) if err != nil { return err } due, err := s.store.DueTaskDigests(ctx, time.Now()) if err != nil { return err } sent, uncertain, checked := 0, 0, 0 deliver := func(claim store.TaskDigestClaim) error { state, reason := s.deliverTaskDigest(ctx, claim) if state == "sent" { sent++ } if state == "uncertain" { uncertain++ } checked++ finish, stop := context.WithTimeout(context.Background(), 2*time.Second) defer stop() err := s.store.FinishTaskDigestReason(finish, claim, state, reason, time.Now()) // A reclaimed generation cannot complete a newer attempt. if errors.Is(err, store.ErrTaskConflict) { return nil } return err } // Alternate automatic delivery and manual retries within the shared time // budget, so a retry backlog cannot monopolize scheduled deliveries. for i := 0; i < max(len(due), len(queued)); i++ { for _, manual := range []bool{false, true} { if ctx.Err() != nil { break } var claim store.TaskDigestClaim var e error if manual { if i >= len(queued) { continue } claim, e = s.store.ClaimQueuedTaskDigest(ctx, queued[i], time.Now()) } else { if i >= len(due) { continue } claim, e = s.store.ClaimTaskDigest(ctx, due[i], time.Now()) } if errors.Is(e, sql.ErrNoRows) { continue } if e != nil { return e } if e = deliver(claim); e != nil { return e } } if ctx.Err() != nil { break } } if checked > 0 { s.addEventProgressLog(ctx, job, fmt.Sprintf("task digest checked=%d sent=%d uncertain=%d", checked, sent, uncertain)) } return nil } func (s *Server) deliverTaskDigest(ctx context.Context, claim store.TaskDigestClaim) (string, string) { if !s.systemExtensionEnabled(claim.Domain, "organizer.tasks") { return "cancelled", "extension_disabled" } config, err := s.store.AuthProviderConfig(claim.Domain, "smtp") if err != nil || !config.Enabled { return "cancelled", "smtp_unavailable" } items, next, err := s.store.ListTasks(ctx, claim.Domain, claim.Owner, store.TaskQuery{Kind: "task", View: "today", Today: claim.Day, Limit: 100}) if err != nil { return "cancelled", "tasks_unavailable" } var body strings.Builder host, _ := s.store.GetDomainEffectiveHost(claim.Domain) base := "" if host != "" && !strings.ContainsAny(host, "/\\\r\n\t @") { base = "https://" + host } fmt.Fprintf(&body, "Tasks / やることリスト — %s (%s)\n\n", claim.Day, claim.Timezone) if len(items) == 0 { body.WriteString("No tasks due or planned today. / 今日の対象タスクはありません。\n") } for _, item := range items { fmt.Fprintf(&body, "- %s\n due/期限: %s | planned/予定: %s | estimate/見積: %d min\n %s/v/plan/task/%s\n", item.Title, item.DueOn, item.PlannedOn, item.Estimate, base, item.UUID) } if next != "" { body.WriteString("\nFirst 100 items only. / 最初の100件です。続きはタスク画面で確認してください。\n") } recipient, err := s.store.TaskDigestRecipient(ctx, claim) if err != nil { return "cancelled", "consent_changed" } if err = sendTaskDigestSMTP(ctx, config, recipient, claim.Day, body.String()); err != nil { return "uncertain", "transport_uncertain" } return "sent", "" }