# -*- coding: utf-8 -*-
import io,json,re
d=json.load(io.open('build/_chk/pbdata.json',encoding='utf-8'))
orgs=d['orgs']
raw=io.open(r'C:\Users\15186\Desktop\排班任务_下周.xls',encoding='utf-8-sig').read()
rows=re.findall(r'<tr>(.*?)</tr>', raw, re.S)
def match(kw):
    out=[]
    for k in re.split(r'[、,，/]+', kw):
        k=k.strip()
        if not k: continue
        hit=[o for o in orgs if o['n']==k or o['c']==k]
        if not hit: hit=[o for o in orgs if k in o['n']]
        out.append((k, hit[0]['n'] if hit else None))
    return out
n=0
for r in rows:
    cells=[re.sub(r'<[^>]+>','',c) for c in re.findall(r'<td>(.*?)</td>', r, re.S)]
    if len(cells)<7 or cells[0]=='说明': continue
    n+=1
    print(n, cells[0], '->', match(cells[0]), '| 周几:', cells[1], '| 人:', cells[3], '| 弹性:', cells[5])
print('总行数', n)