实战案例

学以致用——四个部门的自动化实战，拿来就能用。

案例总览

案例1: HR 入职自动化

"""
HR 入职流程自动化
"""
from dataclasses import dataclass, field
from datetime import datetime
@dataclass
class NewHire:
name: str
department: str
position: str
start_date: str
email: str
@dataclass
class OnboardingBot:
"""入职机器人"""
checklist: list[dict] = field(default_factory=list)
def process(self, hire: NewHire) -> dict:
"""执行入职流程"""
tasks = [
{"任务": "创建企业邮箱", "系统": "Exchange", "耗时": "自动"},
{"任务": "开通 VPN 账号", "系统": "VPN 管理", "耗时": "自动"},
{"任务": "创建 OA 账号", "系统": "OA 系统", "耗时": "自动"},
{"任务": "加入对应部门群", "系统": "企业微信", "耗时": "自动"},
{"任务": "分配工位和设备", "系统": "行政系统", "耗时": "通知行政"},
{"任务": "发送入职指南邮件", "系统": "邮件", "耗时": "自动"},
{"任务": "安排导师对接", "系统": "HR 系统", "耗时": "通知部门"},
{"任务": "添加到考勤组", "系统": "考勤系统", "耗时": "自动"},
]
return {
"新员工": hire.name,
"部门": hire.department,
"入职日": hire.start_date,
"自动完成": sum(1 for t in tasks if t["耗时"] == "自动"),
"需人工": sum(1 for t in tasks if t["耗时"] != "自动"),
"任务清单": tasks,
"节省时间": "从 2 天 → 30 分钟",
}
bot = OnboardingBot()
hire = NewHire("张小明", "研发部", "前端工程师", "2024-04-01", "zhangxm@company.com")
result = bot.process(hire)
print(f"=== 入职: {result['新员工']} ===")
print(f"  自动: {result['自动完成']}项, 人工: {result['需人工']}项")
print(f"  效率: {result['节省时间']}")
for task in result["任务清单"]:
status = "🤖" if task["耗时"] == "自动" else "👤"
print(f"  {status} {task['任务']} [{task['系统']}]")

案例2: 财务对账自动化

"""
银行对账自动化
"""
from dataclasses import dataclass
@dataclass
class ReconciliationEngine:
"""对账引擎"""
@staticmethod
def reconcile(
bank_records: list[dict],
system_records: list[dict],
) -> dict:
"""自动对账"""
bank_set = {
(r["date"], r["amount"], r["ref"]): r
for r in bank_records
}
system_set = {
(r["date"], r["amount"], r["ref"]): r
for r in system_records
}
matched = []
bank_only = []
system_only = []
for key, record in bank_set.items():
if key in system_set:
matched.append(record)
else:
bank_only.append(record)
for key, record in system_set.items():
if key not in bank_set:
system_only.append(record)
return {
"匹配成功": len(matched),
"银行独有": len(bank_only),
"系统独有": len(system_only),
"匹配率": f"{len(matched) / (len(matched) + len(bank_only)) * 100:.1f}%",
"需人工处理": bank_only + system_only,
}
engine = ReconciliationEngine()
bank = [
{"date": "2024-03-01", "amount": 5000, "ref": "TXN001"},
{"date": "2024-03-02", "amount": 3200, "ref": "TXN002"},
{"date": "2024-03-03", "amount": 8800, "ref": "TXN003"},
{"date": "2024-03-04", "amount": 1500, "ref": "TXN004"},
]
system = [
{"date": "2024-03-01", "amount": 5000, "ref": "TXN001"},
{"date": "2024-03-02", "amount": 3200, "ref": "TXN002"},
{"date": "2024-03-03", "amount": 8800, "ref": "TXN003"},
{"date": "2024-03-05", "amount": 2000, "ref": "TXN005"},
]
result = engine.reconcile(bank, system)
print("=== 自动对账结果 ===")
for k, v in result.items():
if k != "需人工处理":
print(f"  {k}: {v}")
print(f"  需人工检查: {len(result['需人工处理'])} 条")

案例3: 销售线索管理

"""
销售线索自动化
"""
LEAD_AUTOMATION = {
"线索来源": ["网页表单", "广告落地页", "邮件咨询", "社交媒体"],
"自动化流程": [
"1. 线索进入 → 自动去重 → CRM 建档",
"2. 线索评分 → 自动分配给对应销售",
"3. 发送欢迎邮件 → 附产品资料",
"4. 3天未跟进 → 提醒销售",
"5. 7天未跟进 → 升级给主管",
"6. 跟进完成 → 更新状态 → 移入后续管道",
],
"评分规则": {
"企业邮箱": 20,
"公司规模>100": 15,
"高价值行业": 15,
"下载白皮书": 10,
"多次访问": 10,
"填写详细信息": 10,
"总分>60": "热线索 → 立即跟进",
},
"效果": {
"线索响应时间": "从 48h → 5min",
"跟进遗漏率": "从 30% → 2%",
"线索转化率": "提升 25%",
},
}
print("=== 销售线索自动化 ===")
print("\n自动化流程:")
for step in LEAD_AUTOMATION["自动化流程"]:
print(f"  {step}")
print("\n效果:")
for k, v in LEAD_AUTOMATION["效果"].items():
print(f"  {k}: {v}")

案例4: IT 运维巡检

"""
IT 运维自动巡检
"""
IT_PATROL = {
"巡检项目": [
{"检查": "服务器 CPU 使用率", "阈值": "> 90%", "动作": "告警 + 扩容工单"},
{"检查": "磁盘使用率", "阈值": "> 85%", "动作": "告警 + 清理通知"},
{"检查": "SSL 证书过期", "阈值": "< 30天", "动作": "自动续期 或 告警"},
{"检查": "备份完整性", "阈值": "失败", "动作": "重试 + 告警"},
{"检查": "异常登录", "阈值": "非常规IP", "动作": "锁定 + 通知管理员"},
],
"调度": "每 5 分钟自动巡检",
"告警渠道": "企业微信 → 邮件 → 电话(紧急)",
}
print("=== IT 自动巡检 ===")
for item in IT_PATROL["巡检项目"]:
print(f"  {item['检查']}: 阈值 {item['阈值']} → {item['动作']}")
print(f"\n调度: {IT_PATROL['调度']}")

全书总结