#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
东乡区人民政府 - 环境保护 (www.jxfzdx.gov.cn/col/col21311/index.html)
CMS: 汉网 hanweb / TRS 系 (jpage datastore + xxgk/search.jsp 动态列表)
列表: JS 渲染 loadDynamic('/module/xxgk/search.jsp', 'div7299', ...) — 必须 POST
      POST /module/xxgk/search.jsp
      query: texttype=&fbtime=&vc_all=&vc_filenumber=&vc_title=&vc_number=&currpage=N&sortfield=&fields=&fieldConfigId=&hasNoPages=&infoCount=
      body:  infotypeId=L00004L00004L00010&jdid=59&area=&divid=div7299&vc_title=&vc_number=&currpage=N&vc_filenumber=&vc_all=&texttype=&fbtime=
      18条/页, 共536条/30页. 返回 <li><a href="/art/YYYY/M/D/art_21311_ID.html" title="完整标题">标题</a><b>YYYY-MM-DD</b></li>
      (GET 返回 18 空行 + "请传入正确参数" — 必须 POST)
详情: meta ArticleTitle/PubDate(YYYY-MM-DD HH:MM:SS 取前10)/ColumnName=环境保护
      正文 div#zoom (Word 转换 p>span 逐段 + table 保留 + ContentStart 标记)
      无独立附件区 (环评公示纯文本, 链接全是导航)
"""
import sys
import os
import re
import time
import html as html_lib
import urllib.parse
import sqlite3

try:
    from bs4 import BeautifulSoup
except ImportError:
    BeautifulSoup = None

# ---------------- config ----------------
BASE_URL = "https://www.jxfzdx.gov.cn"
LIST_PATH = "/col/col21311/index.html?number=L00004L00004L00010"
LIST_URL = BASE_URL + LIST_PATH
SEARCH_API = BASE_URL + "/module/xxgk/search.jsp"
SITE_NAME = "东乡区-环境保护"
GROUP_NAME = "江西"
SCRIPT_NAME = "crawl_jxfzdx_hjbh.py"
DB_PATH = "/mnt/data/search.db"

HEADERS = {
    "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0 Safari/537.36",
    "Accept": "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8",
    "Accept-Language": "zh-CN,zh;q=0.9",
    "Referer": LIST_URL,
}

# default: daily incremental = 1 page
_MAX_PAGES = 1
for i, a in enumerate(sys.argv):
    if a.startswith("--pages="):
        try:
            _MAX_PAGES = int(a.split("=", 1)[1])
        except ValueError:
            pass
    elif a == "--pages" and i + 1 < len(sys.argv):
        try:
            _MAX_PAGES = int(sys.argv[i + 1])
        except ValueError:
            pass

_PAGES = _MAX_PAGES if _MAX_PAGES >= 1 else 1

INFOTYPE_ID = "L00004L00004L00010"


# ---------------- helpers ----------------
def clean_title(t):
    """unescape entities + strip zero-width + collapse whitespace."""
    if not t:
        return ""
    t = html_lib.unescape(t)
    t = t.replace("\u200b", "").replace("\u200c", "").replace("\u200d", "").replace("\ufeff", "")
    t = re.sub(r"\s+", " ", t)
    return t.strip()


def fetch(url, session=None, timeout=30, retries=3):
    import requests
    last = None
    for i in range(retries):
        try:
            r = (session or requests).get(url, headers=HEADERS, timeout=timeout)
            if r.status_code == 200:
                r.encoding = r.apparent_encoding or "utf-8"
                return r
            last = r
        except Exception as e:
            last = e
        time.sleep(1.5 * (i + 1))
    if isinstance(last, Exception):
        raise last
    return last


def fetch_list(session, page):
    """POST search.jsp for a given page. Returns (html, total_count, total_pages).
    ⚠️ requests 传字符串 body 不自动设 Content-Type — 必须显式
    application/x-www-form-urlencoded，否则服务器返回「请传入正确参数！」(curl -d 自动带所以 curl 可用)
    """
    q = (f"texttype=&fbtime=&vc_all=&vc_filenumber=&vc_title=&vc_number="
         f"&currpage={page}&sortfield=&fields=&fieldConfigId=&hasNoPages=&infoCount=")
    body = (f"infotypeId={INFOTYPE_ID}&jdid=59&area=&divid=div7299&vc_title=&vc_number="
            f"&currpage={page}&vc_filenumber=&vc_all=&texttype=&fbtime=")
    h = dict(HEADERS)
    h["Content-Type"] = "application/x-www-form-urlencoded"
    r = session.post(SEARCH_API + "?" + q, data=body, headers=h, timeout=30)
    r.encoding = r.apparent_encoding or "utf-8"
    text = r.text
    m = re.search(r"共(\d+)条记录", text)
    total = int(m.group(1)) if m else 0
    m = re.search(r"共\s*(\d+)\s*页", text)
    total_pages = int(m.group(1)) if m else 0
    return text, total, total_pages


def html_to_text(content, page_url):
    """Convert article-body inner HTML to stored format:
    - keep <table> HTML intact
    - \n\n between <p> blocks
    - attachment <a> links embedded with absolute URL
    - strip <script>/<style>/noise + style attrs via BS4
    """
    if not content:
        return "", 0, []
    content = re.sub(r"<!--.*?-->", "", content, flags=re.S)
    content = re.sub(r"<script[^>]*>.*?</script>", "", content, flags=re.S | re.I)
    content = re.sub(r"<style[^>]*>.*?</style>", "", content, flags=re.S | re.I)
    # strip style/class attributes via BS4 BEFORE paragraph splitting (合浦 hepu 教训)
    if BeautifulSoup:
        try:
            _soup = BeautifulSoup(content, "html.parser")
            for tag in _soup.find_all(True):
                for attr in ("style", "class", "lang", "dir", "align", "valign", "width", "height", "border", "cellpadding", "cellspacing"):
                    tag.attrs.pop(attr, None)
            content = str(_soup)
        except Exception:
            pass

    # 1) FIRST protect attachment <a> links (before table protection, so table
    #    regex can't swallow links that sit right after a <table> close tag)
    content2 = content
    content2 = re.sub(
        r'<img[^>]*src="[^"]*fileTypeImages/icon_[a-z]+\.gif"[^>]*/?>', "", content2,
        flags=re.I,
    )
    attachments = []
    link_protect = {}
    def _link_repl(m):
        href = m.group(1)
        inner = m.group(2)
        txt = re.sub(r"<[^>]+>", "", inner)
        txt = html_lib.unescape(txt).strip()
        txt = re.sub(r"^附件[:：]\s*", "", txt).strip()
        if not txt:
            txt = os.path.basename(href.split("?")[0]) or "附件"
        abs_url = urllib.parse.urljoin(page_url, href)
        attachments.append((abs_url, txt))
        key = f"__LINK__{len(link_protect)}__"
        link_protect[key] = f'<a href="{abs_url}" target="_blank">{txt}</a>'
        return key
    content2 = re.sub(r'<a\s[^>]*href="([^"]+)"[^>]*>(.*?)</a>', _link_repl, content2, flags=re.S | re.I)

    # 2) THEN protect tables
    table_protect = []
    def _tbl_repl(m):
        table_protect.append(m.group(0))
        return f"__TBL__{len(table_protect)-1}__"
    content2 = re.sub(r"<table[^>]*>.*?</table>", _tbl_repl, content2, flags=re.S | re.I)
    has_table = 1 if re.search(r"<table[^>]*>", content, re.I) else 0

    content2 = re.sub(r"</p>", "</p>\n\n", content2, flags=re.I)
    content2 = re.sub(r"<br\s*/?>", "\n", content2, flags=re.I)
    content2 = re.sub(r"</?(?:span|font|o:p|st1?:[a-z]+)\b[^>]*>", "", content2, flags=re.I)

    parts = []
    for block in content2.split("\n\n"):
        b = block.strip()
        if not b:
            continue
        plain = re.sub(r"<[^>]+>", "", b)
        plain = html_lib.unescape(plain)
        plain = plain.replace("\xa0", " ").replace("&nbsp;", " ")
        plain = re.sub(r"[\s\u200b\u200c\u200d\ufeff]+", "", plain)
        if not plain:
            continue
        for k, v in link_protect.items():
            b = b.replace(k, v)
        for i, tbl in enumerate(table_protect):
            b = b.replace(f"__TBL__{i}__", tbl)
        parts.append(b.strip())

    out = "\n\n".join(parts)
    for k, v in link_protect.items():
        out = out.replace(k, v)
    for i, tbl in enumerate(table_protect):
        out = out.replace(f"__TBL__{i}__", tbl)

    out = re.sub(r"__LINK__\d+__", "", out)
    out = re.sub(r"__TBL__\d+__", "", out)

    out = html_lib.unescape(out)
    out = re.sub(r"[ \t]+\n", "\n", out)
    out = re.sub(r"\n{3,}", "\n\n", out)
    out = re.sub(r"[ \t]{2,}", " ", out)

    # dedupe paragraphs
    seen = set()
    final = []
    for p in out.split("\n\n"):
        key = re.sub(r"\s+", "", re.sub(r"<[^>]+>", "", p))
        if not key:
            continue
        if key in seen:
            continue
        seen.add(key)
        final.append(p)
    out = "\n\n".join(final).strip()

    return out, has_table, attachments


def parse_list(html_text):
    """Extract (url, title, date) from search.jsp POST response.
    <li><a target="_blank" href="/art/2026/7/30/art_21311_4465839.html" title="完整标题">标题</a><b>2026-07-30</b></li>
    """
    items = []
    if BeautifulSoup:
        soup = BeautifulSoup(html_text, "html.parser")
        for li in soup.find_all("li"):
            a = li.find("a", href=True)
            if not a:
                continue
            href = a.get("href", "").strip()
            if not re.search(r"/art/\d{4}/\d+/\d+/art_21311_\d+\.html$", href):
                continue
            abs_url = urllib.parse.urljoin(BASE_URL, href)
            title = clean_title(a.get("title", "") or a.get_text(" ", strip=True))
            date = ""
            b = li.find("b")
            if b:
                date = clean_title(b.get_text(" ", strip=True))
            if not re.match(r"^20\d{2}-\d{2}-\d{2}$", date):
                date = ""
            items.append((abs_url, title, date))
    if not items:
        # regex fallback
        for m in re.finditer(
            r'<a[^>]+href="(/art/\d{4}/\d+/\d+/art_21311_\d+\.html)"[^>]*title="([^"]*)"[^>]*>(.*?)</a>\s*<b[^>]*>([^<]*)</b>',
            html_text, re.S,
        ):
            abs_url = urllib.parse.urljoin(BASE_URL, m.group(1))
            items.append((abs_url, clean_title(m.group(2)), m.group(4).strip()))
    return items


def parse_detail(html_text, page_url):
    """Extract title, date, content from detail page."""
    title = ""
    date = ""
    content_html = ""
    if BeautifulSoup:
        soup = BeautifulSoup(html_text, "html.parser")
        mt = soup.find("meta", attrs={"name": re.compile(r"ArticleTitle", re.I)})
        if mt and mt.get("content"):
            title = clean_title(mt["content"])
        md = soup.find("meta", attrs={"name": re.compile(r"PubDate", re.I)})
        if md and md.get("content"):
            d = md["content"].strip()
            dm = re.match(r"(\d{4})-(\d{2})-(\d{2})", d)
            if dm:
                date = dm.group(0)
        zoom = soup.find("div", id=re.compile(r"zoom", re.I))
        if zoom:
            content_html = str(zoom)
    if not title or not content_html:
        m = re.search(r'<meta\s+name="\s*ArticleTitle\s*"\s+content="([^"]*)"', html_text, re.I)
        if m:
            title = clean_title(m.group(1))
        m = re.search(r'<meta\s+name="\s*PubDate\s*"\s+content="(\d{4}-\d{2}-\d{2})', html_text, re.I)
        if m:
            date = m.group(1)
        m = re.search(r'<div[^>]*id="zoom"[^>]*>(.*?)</div>', html_text, re.S)
        if m:
            content_html = m.group(0)
    return title, date, content_html


def store_record(conn, url, title, content, date, has_table):
    cur = conn.execute(
        "SELECT id FROM gov_raw WHERE page_url=?",
        (url,),
    )
    if cur.fetchone():
        return False
    try:
        industry = "other"
        try:
            from crawler_lib import classify_industry
            industry = classify_industry(title)
        except Exception:
            pass
        cur = conn.execute(
            "INSERT OR IGNORE INTO gov_raw "
            "(page_url, source_url, title, content, publish_date, site_name, group_name, script_name, has_table, industry) "
            "VALUES (?,?,?,?,?,?,?,?,?,?)",
            (url, url, title, content, date, SITE_NAME, GROUP_NAME, SCRIPT_NAME, has_table, industry),
        )
        if cur.rowcount > 0:
            summary = re.sub(r"<[^>]+>", "", content)
            summary = html_lib.unescape(summary)
            summary = re.sub(r"\s+", " ", summary).strip()[:200]
            conn.execute(
                "INSERT OR IGNORE INTO gov_search (rowid, title, site_name, summary) VALUES (?,?,?,?)",
                (cur.lastrowid, title, SITE_NAME, summary),
            )
            return True
        return False
    except sqlite3.OperationalError as e:
        if "locked" in str(e):
            time.sleep(3)
            return store_record(conn, url, title, content, date, has_table)
        raise


def main():
    import requests
    s = requests.Session()
    s.headers.update(HEADERS)
    conn = sqlite3.connect(DB_PATH, timeout=60)
    conn.execute("PRAGMA busy_timeout=60000")
    conn.execute("PRAGMA journal_mode=WAL")

    new_count = 0
    skip_count = 0
    seen_urls = set()

    for page in range(1, _PAGES + 1):
        try:
            html_text, total, total_pages = fetch_list(s, page)
        except Exception as e:
            print(f"Page {page} fetch error: {e}", flush=True)
            break
        items = parse_list(html_text)
        print(f"Page {page}: found {len(items)} items (total={total}, pages={total_pages})", flush=True)
        if not items and page > 1:
            print("Empty page, stop pagination", flush=True)
            break
        for abs_url, title, date in items:
            if abs_url in seen_urls:
                continue
            seen_urls.add(abs_url)
            try:
                r = fetch(abs_url, session=s)
                dhtml = r.content.decode("utf-8", errors="replace")
            except Exception as e:
                print(f"  detail error {abs_url}: {e}", flush=True)
                skip_count += 1
                continue
            dtitle, ddate, content_html = parse_detail(dhtml, abs_url)
            if not dtitle:
                dtitle = title
            if not ddate:
                ddate = date
            content, has_table, _ = html_to_text(content_html, abs_url)
            plain_len = len(re.sub(r"<[^>]+>", "", content).strip())
            if plain_len < 10:
                print(f"  skip empty: {dtitle[:30]}", flush=True)
                skip_count += 1
                continue
            ok = store_record(conn, abs_url, dtitle, content, ddate, has_table)
            if ok:
                new_count += 1
                print(f"  + {dtitle[:40]} ({ddate})", flush=True)
            else:
                skip_count += 1
            time.sleep(0.3)
        time.sleep(0.5)

    conn.commit()
    conn.close()
    print(f"新增: {new_count}", flush=True)
    print(f"跳过: {skip_count}", flush=True)
    print(f"=== {SITE_NAME} done ===", flush=True)


if __name__ == "__main__":
    main()
