1
2
3
4
5
6
7
8
9
10
11
| import json,csv
| from read_links import P
| s=json.loads((P/'snapshot.json').read_text(encoding='utf8'))
| p=json.loads((P/'plan.json').read_text(encoding='utf8'))
| qc={r['id']:r for r in s['tables']['mes_qc_oqc']['rows']}
| items={r['id']:r for r in s['tables']['mes_md_item']['rows']}
| with (P/'待确认客户的出货检验单.csv').open('w',encoding='utf-8-sig',newline='') as f:
| w=csv.writer(f);w.writerow(['检验单ID','检验单号','检验单名称','产品名称','检验日期','批次号','待确认原因'])
| for x in p['unresolved']:
| r=qc[x['id']];item=items.get(r['item_id'],{})
| w.writerow([r['id'],r['code'],r['name'],item.get('name',''),r['inspect_date'],r['batch_code'],x['reason']])
|
|
