#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""FB + LinkedIn kandidat hc62 (trace sukses saja)."""
import json, re

docs = json.load(open("/tmp/repliz_dump_hc62.json"))
ACC_FB = "6a334952c5ff4ce3a3225941"
UP = ("pending", "scheduled", "draft")
URLRE = re.compile(r"https?://[^\s\"'<>)\]]*studiosoft\.id/[^\s\"'<>)\]]*")


def slug_of(u):
    return u.split("?")[0].split("#")[0].rstrip("/").split("/")[-1].lower()


def art_slugs(d):
    out = set()
    for m in (d.get("medias") or []):
        for u in URLRE.findall(m.get("url") or ""):
            if "openclaw-img" not in u:
                out.add(slug_of(u))
    for f in ("description", "title", "topic"):
        for u in URLRE.findall(d.get(f) or ""):
            if "openclaw-img" not in u:
                out.add(slug_of(u))
    return out


lastsucc, upc = {}, {}
for d in docs:
    if d.get("accountId") != ACC_FB:
        continue
    st = (d.get("status") or "").lower()
    when = d.get("scheduleAt") or ""
    for s in art_slugs(d):
        if st == "success" and when > lastsucc.get(s, ""):
            lastsucc[s] = when
        if st in UP and (s not in upc or when < upc[s]):
            upc[s] = when

HC = ["7-strategi-digital-marketing-rumah-sakit-untuk-menambah-pasien-setiap-bulan",
      "10-channel-digital-marketing-rumah-sakit-yang-wajib-dikelola-di-era-online",
      "strategi-seo-terbaik-untuk-klinik-kecantikan-di-surabaya-tingkatkan-pasien-lewat-google",
      "tips-seo-digital-marketing-surabaya-optimasi-local-untuk-klinik-dan-bengkel-lokal",
      "7-aplikasi-mental-health-anak-usia-4-10-tahun-yang-harus-dicoba-orang-tua",
      "pembuatan-website-rumah-sakit", "jasa-digital-marketing-klinik", "seo-rumah-sakit",
      "digital-marketing-rumah-sakit-indikator", "panduan-seo-klinik-rumah-sakit",
      "rs-klinik-digital-marketing-2026", "google-business-profile-klinik",
      "9-contoh-konten-digital-marketing-rumah-sakit-yang-edukatif-dan-tetap-etis",
      "cara-klinik-kecantikan-di-surabaya-bisa-ditemukan-lebih-cepat-di-google"]
print("== FB trace sukses (naik = paling tua) ==")
for s in sorted(HC, key=lambda s: lastsucc.get(s, "")):
    print("  succ=%-25s up=%s  %s" % (lastsucc.get(s, "BELUM PERNAH"), upc.get(s, "-"), s))

print("\n== cek strategi-pemasaran-properti di SEMUA jadwal ==")
hit = [d for d in docs if "strategi-pemasaran-properti" in json.dumps(d, ensure_ascii=False)]
print("  hit:", len(hit))
for d in hit[:10]:
    print("   ", d.get("accountId"), d.get("scheduleAt"), d.get("status"), (d.get("title") or "")[:40])