企业微信群打卡管理与统计机器人

# pip install requests flask
import requests, sqlite3, datetime
from flask import Flask, request

API_BASE = "https://api.webridge.cn"
GROUP_SECRET = "wb_ss_打卡群send_secret"
GROUP_ID = "R:16888573..."
app = Flask(__name__)

def send(content):
    requests.post(f"{API_BASE}/api/send",
        params={"secret": GROUP_SECRET, "conversation_id": GROUP_ID},
        json={"msgtype": "text", "text": {"content": content}})

def init_db():
    db = sqlite3.connect("checkin.db")
    db.execute("CREATE TABLE IF NOT EXISTS logs("
               "uid TEXT, name TEXT, day TEXT, PRIMARY KEY(uid, day))")
    db.commit(); db.close()

@app.post("/webhook")
def on_message():
    p = request.get_json()
    text = p["text"]["content"]
    if "打卡" in text:
        db = sqlite3.connect("checkin.db")
        db.execute("INSERT OR IGNORE INTO logs VALUES(?,?,?)",
                   (p["sender"]["id"], p["sender"]["name"],
                    datetime.date.today().isoformat()))
        db.commit(); db.close()
        send("✅ 打卡成功！")
    return "ok"

# 定时任务（每天 21:00）：播报今日打卡排行
def report():
    db = sqlite3.connect("checkin.db")
    rows = db.execute(
        "SELECT name, COUNT(*) FROM logs "
        "GROUP BY uid ORDER BY COUNT(*) DESC LIMIT 10").fetchall()
    db.close()
    send("🏆 打卡排行\n" + "\n".join(
        f"{i+1}. {n}：{c} 次" for i, (n, c) in enumerate(rows)))