#!/usr/bin/env python3
import json, os, collections
docs = json.load(open('/tmp/tsc_sched_all.json'))
WIB_TSC = {"6a86a7e062caae1e04ff8244": "ig", "6a4bbc5920e4f4f195e52960": "threads",
           "6a3b41ddc5ff4ce3a327542c": "fb", "6a4da7f520e4f4f195e796e1": "li"}
IMG = os.path.join(os.path.dirname(os.path.abspath(__file__)), "openclaw-img")
nama = collections.Counter()
ada_lokal = collections.Counter()
for d in docs:
    a = WIB_TSC.get(d.get("accountId"))
    if not a:
        continue
    for m in d.get("medias") or []:
        u = m.get("url") or ""
        b = os.path.basename(u.split("?")[0])
        nama[b] += 1
        if os.path.exists(os.path.join(IMG, b)):
            ada_lokal[b] += 1
print("file media dipakai di jadwal TSC:", len(nama), "| ada lokal:", len(ada_lokal))
# kelompokkan prefix
grup = collections.Counter()
for b, c in nama.items():
    if b.startswith("tsc_car3_"):
        p = "tsc_car3"
    elif b.startswith("tsc_design_"):
        p = "tsc_design"
    elif b.startswith("tsc_ig_page"):
        p = "tsc_ig_page"
    elif b.startswith("tsc_ig_baru"):
        p = "tsc_ig_baru"
    elif b.startswith("tsc_carousel_new"):
        p = "tsc_carousel_new"
    else:
        p = b.rsplit("_", 1)[0]
    grup[p] += 1
for p, c in grup.most_common():
    print(" ", p, c)