;;~ title    "Shipping template audit"
;;~ author   "lacuna"
;;~ version  1
;;~ mode     analysis
;;~ flavor   white
;;~ id       shipping-template-audit
;;~ trigger  cron:weekly
;;~ touches  ()
;;~ summary  "Weekly: listings whose category or weight no longer matches their assigned shipping template."

;; Pure-data audit. Pulls listings + their shipping templates, applies
;; a deterministic mismatch check (template region vs declared origin,
;; weight bracket vs actual weight), renders the gaps as a table.

(cart 'shipping-template-audit
  '((author    . "lacuna")
    (version   . 1)
    (read-only . #t)))

(define (start ctx)
  (let ((connected (ctx-get 'shop-connected ctx)))
    (cond
      ((not connected) (escalate 'shop-not-connected null))
      (else            (next 'fetch ctx)))))

(define (fetch ctx)
  (act 'etsy/listings (list 'active 'with-shipping) 'render))

(define (render ctx)
  (let ((rows (ctx-result ctx)))
    (cond
      ((null? rows)              (escalate 'no-data null))
      ((eq? rows 'rate-limited)  (after 30 'fetch ctx))
      (else                      (begin
                                   (table rows '(listing-id title template-id mismatch))
                                   (done))))))