#!/usr/bin/env python3
# -*- coding: utf-8 -*-
import glob
import json
import os

import openpyxl

W = '/Users/liuxinyuan/Desktop/Hermes输出-工作类'
# 1) 活动备份里的艾德
for p in sorted(glob.glob(os.path.join(W, '数据/_bak_dailyact_*.json')) +
                glob.glob(os.path.join(W, '数据/_bak_actfeishu_*.json'))):
    try:
        d = json.load(open(p, encoding='utf-8'))
    except Exception:
        continue
    items = d.get('items') if isinstance(d, dict) else d
    if not isinstance(items, list):
        continue
    hits = [x for x in items if '艾德' in json.dumps(x, ensure_ascii=False) and '艾德范思' not in json.dumps(x, ensure_ascii=False)]
    if hits:
        print('\n== %s ｜%d 条 ==' % (os.path.basename(p), len(hits)))
        for x in hits[:10]:
            print('  %s | %s | %s | %s' % (x.get('date'), x.get('sales'), x.get('atype'), (x.get('type') or '')[:30]))
            print('    ', (x.get('text') or '')[:160].replace('\n', ' '))

# 2) ERP 订单
for p in ['/Users/liuxinyuan/Desktop/hermas输入-工作台数据库/2024和2025历史数据/2025全年订单.xlsx']:
    if not os.path.exists(p):
        print('缺文件', p); continue
    wb = openpyxl.load_workbook(p, read_only=True, data_only=True)
    ws = wb.active
    rows = ws.iter_rows(values_only=True)
    header = next(rows)
    idx = {str(h): i for i, h in enumerate(header) if h}
    print('\n== %s ｜列 ==' % os.path.basename(p), list(header)[:12])
    n = 0
    for r in rows:
        s = ' '.join(str(c) for c in r if c is not None)
        if '艾德' in s and '艾德范思' not in s:
            print('  ', {k: r[i] for k, i in list(idx.items())[:8]})
            n += 1
            if n >= 10:
                break
    print('  命中', n)