score_resumes.py 16.6 KB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413
#!/usr/bin/env python3
"""简历打分脚本 v2 - 按 rubric 规则逐份打分,支持淘汰项

用法:
  python3 score_resumes.py --rubric data/scoring_rubric_v2.json --db data/resumes.db --output data/scoring_result_v2.jsonl
  python3 score_resumes.py --rubric data/scoring_rubric_v2.json --db data/resumes.db --only-unscored
"""
import sqlite3, json, argparse, os, sys
from datetime import datetime

def load_rubric(path):
    with open(path, 'r', encoding='utf-8') as f:
        return json.load(f)

def match_score(value, rules):
    """根据 rules 字典匹配分数,5>4>3>2>1"""
    if not value:
        return 1, "信息不足"
    value_lower = value.lower().strip()
    for score in ['5', '4', '3', '2', '1']:
        keywords = rules.get(score, [])
        for kw in keywords:
            if kw.lower() in value_lower:
                return int(score), f"匹配: {kw}"
    # 默认
    return 2, "未明确匹配"

def compute_grad_year(experiences, resume):
    """估算毕业年份。优先级:workAge 明确工作年限≥value 时用工作年限推算(避免成人教育/第二学历 endDate 误杀);
    否则用教育经历 endDate 最大年份;再 fallback 应届生标记。返回 None 表示无法判断(不淘汰,宁漏勿杀)。"""
    import re
    now_year = datetime.now().year
    wa = str(resume.get('workAge', ''))
    # workAge 明确数字年限(如 "3年"、"8年";"1年以内"/"应届生" 不算)
    m = re.match(r'^(\d+)年$', wa)
    work_years = int(m.group(1)) if m else None
    m4 = re.search(r'(20\d{2})年应届生', wa)
    # 教育经历 endDate 最大年份
    edu = [e for e in experiences if e.get('type') == 2]
    years = []
    for e in edu:
        ed = str(e.get('endDate', '') or '')
        mm = re.search(r'(20\d{2})', ed)
        if mm and '至今' not in ed:
            years.append(int(mm.group(1)))
    grad_edu = max(years) if years else None
    # 规则:workAge ≥2 年 → 信任工作年限(毕业至少 work_years 年前)
    if work_years is not None and work_years >= 2:
        return now_year - work_years
    # 应届生带年份("25年应届生")→ 直接用
    if m4:
        return int(m4.group(1))
    # 无年份应届生 → 视为去年毕业
    if '应届生' in wa:
        return now_year - 1
    # 其他情况用教育 endDate
    return grad_edu

_JOB_PHRASE_RE = None
def clean_chat_text(chat_text):
    """移除候选人复述岗位名/打招呼产生的噪声词("看到贵司招聘AI短剧制作岗位"这类)。
    保留第一人称经验信号(我做过/独立制作/作品集/链接/AI工具名)。"""
    global _JOB_PHRASE_RE
    import re
    if _JOB_PHRASE_RE is None:
        words = ["AI短剧制作", "漫剧制作", "短剧制作", "AI短剧", "短剧", "漫剧",
                 "全流程制作", "全流程", "招聘", "岗位", "职位", "贵司", "贵公司",
                 "贵方", "应聘", "看到", "期待回复", "进一步沟通", "可以聊聊"]
        _JOB_PHRASE_RE = re.compile('|'.join(re.escape(w) for w in words))
    return _JOB_PHRASE_RE.sub(' ', chat_text)

def check_elimination(resume, rubric):
    """检查淘汰规则,返回 (eliminated: bool, reason: str)"""
    elim_rules = rubric.get('elimination_rules', [])
    if not elim_rules:
        return False, None

    # 准备各字段值
    gender = resume.get('gender', '')
    experiences = json.loads(resume['experiences']) if isinstance(resume.get('experiences', ''), str) else resume.get('experiences', [])
    edu_exps = [e for e in experiences if e.get('type') == 2]
    edu_occups = [e.get('occupation', '') for e in edu_exps if e.get('occupation')]
    edu_occup_str = ' '.join(edu_occups)
    second_text = resume.get('secondText', '')
    # 专业字段 = 教育经历occupation + secondText
    major_text = edu_occup_str + ' ' + second_text

    for rule in elim_rules:
        name = rule.get('name', '')
        field = rule.get('field', '')
        rule_type = rule.get('rule', '')
        value = rule.get('value', '')
        keywords = rule.get('keywords', [])
        reason = rule.get('reason', '')
        field_value = ''

        if field == 'gender':
            field_value = gender or ''
        elif field == 'experiences_education_occupation':
            field_value = major_text or ''
        elif field == 'graduation':
            # 毕业年限淘汰: rule='within_years', value=N → 毕业不足 N 年淘汰
            grad_year = compute_grad_year(experiences, resume)
            if grad_year is None:
                continue  # 无法判断 → 不淘汰
            try:
                limit = datetime.now().year - int(value)
            except (TypeError, ValueError):
                continue
            if grad_year > limit:
                return True, reason
            continue
        else:
            # 通用字段读取
            field_value = str(resume.get(field, ''))

        if rule_type == 'equals':
            if field_value == value:
                return True, reason
        elif rule_type == 'not_contains_any':
            # field_value 里不包含任何一个 keyword → 淘汰
            field_lower = field_value.lower()
            found = False
            for kw in keywords:
                if kw.lower() in field_lower:
                    found = True
                    break
            if not found:
                return True, reason
        elif rule_type == 'contains_any':
            field_lower = field_value.lower()
            for kw in keywords:
                if kw.lower() in field_lower:
                    return True, reason

    return False, None

def score_resume(resume, rubric):
    """对一份简历打分"""
    experiences = json.loads(resume['experiences']) if isinstance(resume['experiences'], str) else resume['experiences']

    # 教育经历
    edu_exps = [e for e in experiences if e.get('type') == 2]
    work_exps = [e for e in experiences if e.get('type') == 1]

    # 专业:取教育经历中的 occupation
    edu_occups = [e.get('occupation', '') for e in edu_exps if e.get('occupation')]
    edu_occup_str = ' '.join(edu_occups)

    # 学校:取教育经历中的 organization
    edu_orgs = [e.get('organization', '') for e in edu_exps if e.get('organization')]
    edu_org_str = ' '.join(edu_orgs)

    # 工作经历 occupation
    work_occups = [e.get('occupation', '') for e in work_exps if e.get('occupation')]
    work_ocup_str = ' '.join(work_occups)

    # 也看 secondText 里的专业和学校信息
    second_text = resume.get('secondText', '')

    # 聊天文本(候选人主动发的作品链接/作品描述等,BOSS 简历 BLOB 里没有)
    chat_text = clean_chat_text(resume.get('chat_text', '') or '')

    dimension_scores = {}
    total_weighted = 0
    total_weight = 0

    for criterion in rubric.get('criteria', []):
        name = criterion['name']
        weight = criterion['weight']
        rules = criterion.get('rules', {})

        if name == '专业匹配度':
            score, reason = match_score(edu_occup_str + ' ' + second_text, rules)
        elif name == '学校层次':
            score, reason = match_score(edu_org_str + ' ' + second_text, rules)
        elif name == '写作创作经验':
            # 工作 occupation + 聊天文本(聊天里常有"独立制作/导演/剪辑"等自述)
            score, reason = match_score(work_ocup_str + ' ' + chat_text, rules) if (work_ocup_str or chat_text) else (1, "无工作经历")
        elif name == '到岗状态':
            apply_status = resume.get('applyStatus', '')
            score, reason = match_score(apply_status, rules)
        elif name == 'AI相关经验':
            ai_text = work_ocup_str + ' ' + edu_occup_str + ' ' + chat_text
            score, reason = match_score(ai_text, rules)
        elif name == '作品与市场验证':
            # 聊天文本 + 工作 occupation:作品链接/独立制作/全流程/市场验证
            src = chat_text + ' ' + work_ocup_str
            score, reason = match_score(src, rules) if src.strip() else (1, "无作品信息")
        elif name == '美术功底':
            # 专业 + 聊天文本:美术/绘画/手绘/插画/设计等
            src = edu_occup_str + ' ' + second_text + ' ' + chat_text
            score, reason = match_score(src, rules)
        elif name == '毕业年限':
            # 加分项:毕业≥2年5分,1-2年3分,应届1分(数值逻辑,不走关键词)
            gy = compute_grad_year(experiences, resume)
            if gy is None:
                score, reason = 3, "毕业年限无法判断"
            else:
                yrs = datetime.now().year - gy
                if yrs >= 2:
                    score, reason = 5, f"毕业{yrs}年"
                elif yrs >= 1:
                    score, reason = 3, f"毕业{yrs}年"
                else:
                    score, reason = 1, f"毕业{yrs}年(应届)"
        else:
            score, reason = 1, "未知维度"

        dimension_scores[name] = {"score": score, "reason": reason, "weight": weight}
        total_weighted += score * weight
        total_weight += weight

    raw_score = total_weighted / total_weight if total_weight > 0 else 1
    # 1-5 映射到 0-100: (score - 1) / 4 * 100
    total_score = round((raw_score - 1) / 4 * 100)

    # 分档
    thresholds = rubric.get('tier_thresholds', {"recommend": 75, "backup": 55})
    if total_score >= thresholds['recommend']:
        tier = "推荐面试"
    elif total_score >= thresholds['backup']:
        tier = "可备选"
    else:
        tier = "暂不考虑"

    # 生成摘要
    edu_summary = second_text.replace('毕业于 ', '') if second_text else '未知'
    work_summary = work_occups[0] if work_occups else '无工作经历'

    result = {
        "friendId": str(resume['friendId']),
        "name": resume['name'],
        "total_score": total_score,
        "tier": tier,
        "eliminated": 0,
        "eliminated_reason": None,
        "dimension_scores": dimension_scores,
        "education": resume.get('education', ''),
        "gender": resume.get('gender', ''),
        "applyStatus": resume.get('applyStatus', ''),
        "city": resume.get('city', ''),
        "age": resume.get('age', ''),
        "workAge": resume.get('workAge', ''),
        "secondText": second_text,
        "work_summary": work_summary,
        "edu_summary": edu_summary,
        "rubric_version": rubric.get('version', 1),
        "scored_at": datetime.now().strftime('%Y-%m-%d %H:%M:%S')
    }

    return result

def score_resume_with_elimination(resume, rubric):
    """先检查淘汰,再打分"""
    eliminated, reason = check_elimination(resume, rubric)
    if eliminated:
        # 淘汰:0分,直接标记
        return {
            "friendId": str(resume['friendId']),
            "name": resume['name'],
            "total_score": 0,
            "tier": "已淘汰",
            "eliminated": 1,
            "eliminated_reason": reason,
            "dimension_scores": {},
            "education": resume.get('education', ''),
            "gender": resume.get('gender', ''),
            "applyStatus": resume.get('applyStatus', ''),
            "city": resume.get('city', ''),
            "age": resume.get('age', ''),
            "workAge": resume.get('workAge', ''),
            "secondText": resume.get('secondText', ''),
            "work_summary": "",
            "edu_summary": resume.get('secondText', '').replace('毕业于 ', '') if resume.get('secondText') else '未知',
            "rubric_version": rubric.get('version', 1),
            "scored_at": datetime.now().strftime('%Y-%m-%d %H:%M:%S')
        }
    return score_resume(resume, rubric)

def save_to_db(db, result, resume_id):
    """把打分结果写入 scores 表"""
    dim_json = json.dumps(result.get('dimension_scores', {}), ensure_ascii=False)
    version = result.get('rubric_version', 1)
    # 先删除旧版本记录(如果存在)
    db.execute("DELETE FROM scores WHERE resume_id=? AND rubric_version=?", (resume_id, version))
    sql = "INSERT INTO scores (resume_id, friendId, rubric_version, total_score, tier, dimension_scores, scored_at, eliminated, eliminated_reason) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
    vals = [
        resume_id,
        result['friendId'],
        version,
        result['total_score'],
        result['tier'],
        dim_json,
        result['scored_at'],
        result.get('eliminated', 0),
        result.get('eliminated_reason'),
    ]
    assert sql.count('?') == len(vals), f"placeholder mismatch: {sql.count('?')} vs {len(vals)}"
    db.execute(sql, vals)

def main():
    parser = argparse.ArgumentParser(description='简历打分 v2')
    parser.add_argument('--rubric', required=True, help='rubric JSON 文件路径')
    parser.add_argument('--db', default='/sdcard/bosszhipin/data/resumes.db', help='简历数据库路径')
    parser.add_argument('--output', default=None, help='输出 JSONL 路径')
    parser.add_argument('--only-unscored', action='store_true', help='只打分未打分的简历')
    parser.add_argument('--job-id', default=None, help='只打分指定 jobId 的岗位简历(不传则全库)')
    args = parser.parse_args()

    rubric = load_rubric(args.rubric)

    # 默认输出路径
    if not args.output:
        version = rubric.get('version', 1)
        args.output = f'/sdcard/bosszhipin/data/scoring_result_v{version}.jsonl'

    db = sqlite3.connect(args.db)
    db.row_factory = sqlite3.Row

    # 取简历:only-unscored 模式下只取未打分的
    if args.only_unscored:
        rubric_version = rubric.get('version', 1)
        if args.job_id:
            rows = db.execute('''
                SELECT r.* FROM resumes r
                LEFT JOIN scores s ON r.id = s.resume_id AND s.rubric_version = ?
                WHERE s.resume_id IS NULL AND r.jobId = ?
            ''', (rubric_version, args.job_id)).fetchall()
        else:
            rows = db.execute('''
                SELECT r.* FROM resumes r
                LEFT JOIN scores s ON r.id = s.resume_id AND s.rubric_version = ?
                WHERE s.resume_id IS NULL
            ''', (rubric_version,)).fetchall()
        print(f'--only-unscored: {len(rows)} 份新简历待打分(rubric v{rubric_version}'
              + (f',jobId={args.job_id}' if args.job_id else ',全库') + ')')
    else:
        if args.job_id:
            rows = db.execute('SELECT * FROM resumes WHERE jobId = ?', (args.job_id,)).fetchall()
        else:
            rows = db.execute('SELECT * FROM resumes').fetchall()

    if not rows:
        print('没有待打分的简历,跳过')
        db.close()
        return

    results = []
    count = 0
    eliminated_count = 0
    for row in rows:
        resume = dict(row)
        result = score_resume_with_elimination(resume, rubric)
        if result['eliminated']:
            eliminated_count += 1
        results.append(result)
        count += 1
        # 写入 scores 表
        save_to_db(db, result, row['id'])

    db.commit()

    # 排序:非淘汰在前(按分数降序),淘汰在后
    results.sort(key=lambda x: (x['eliminated'], -x['total_score']))

    # 写入 JSONL
    with open(args.output, 'w', encoding='utf-8') as f:
        for r in results:
            f.write(json.dumps(r, ensure_ascii=False) + '\n')

    # 统计
    print(f'打分完成: {count} 份 (其中淘汰 {eliminated_count} 份)')
    print(f'输出: {args.output}')
    print()

    tiers = {}
    for r in results:
        tier = r['tier']
        tiers[tier] = tiers.get(tier, 0) + 1

    print('=== 分档统计 ===')
    for tier in ['已淘汰', '推荐面试', '可备选', '暂不考虑']:
        print(f'  {tier}: {tiers.get(tier, 0)}人')

    # 淘汰原因分布
    if eliminated_count > 0:
        print()
        print('=== 淘汰原因分布 ===')
        reasons = {}
        for r in results:
            if r['eliminated']:
                reason = r['eliminated_reason'] or '未知'
                reasons[reason] = reasons.get(reason, 0) + 1
        for reason, cnt in sorted(reasons.items(), key=lambda x: -x[1]):
            print(f'  {reason}: {cnt}人')

    print()
    print('=== Top 10 (非淘汰) ===')
    non_elim = [r for r in results if not r['eliminated']]
    for i, r in enumerate(non_elim[:10]):
        print(f'  #{i+1} | {r["total_score"]}分 | {r["name"]} | {r["gender"]} | {r["tier"]} | {r["edu_summary"]} | {r["work_summary"]}')

    print()
    print('=== 淘汰样本 (前5) ===')
    elim = [r for r in results if r['eliminated']]
    for r in elim[:5]:
        print(f'  {r["total_score"]}分 | {r["name"]} | {r["gender"]} | 淘汰原因: {r["eliminated_reason"]} | {r["edu_summary"]}')

    db.close()

if __name__ == '__main__':
    main()