一人公司的合规日程：认缴出资到期提醒与合同台账脚本

"""认缴出资到期日计算：自公司成立之日起五年，按剩余天数分级提醒。"""
from datetime import date


def add_years(d: date, years: int) -> date:
    try:
        return d.replace(year=d.year + years)
    except ValueError:  # 处理 2 月 29 日
        return d.replace(year=d.year + years, day=28)


def check_deadline(founded: str, today: date | None = None) -> str:
    start = date.fromisoformat(founded)
    deadline = add_years(start, 5)
    today = today or date.today()
    left = (deadline - today).days
    if left < 0:
        return f"已逾期 {-left} 天，请尽快处理并咨询专业机构"
    if left <= 180:
        return f"距缴足期限 {deadline} 仅剩 {left} 天，建议尽快安排"
    return f"缴足期限 {deadline}，剩余 {left} 天"


if __name__ == "__main__":
    print(check_deadline("2025-03-15"))  # 换成你的公司成立日期

CREATE TABLE IF NOT EXISTS contracts (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    party TEXT NOT NULL,              -- 对方主体
    subject TEXT NOT NULL,            -- 合同标的
    signed_at TEXT NOT NULL,          -- 签订日期
    expires_at TEXT,                  -- 到期日期
    amount REAL,                      -- 金额
    file_path TEXT,                   -- 扫描件存放路径
    note TEXT
);

-- 查询 30 天内到期的合同
SELECT party, subject, expires_at
FROM contracts
WHERE expires_at BETWEEN DATE('now') AND DATE('now', '+30 days')
ORDER BY expires_at;