Files

43 lines
1.7 KiB
Python
Executable File

# -*- coding: utf-8 -*-
import pandas as pd
db = pd.read_csv('db_bom2.csv', dtype=str)
db['code'] = db['ChildMaterialId'].astype(str).str.strip()
db['parent'] = db['ParentMaterialId'].astype(str).str.strip()
out = []
# 数据库中 9000010400-A01 的63个直接子件,按名称排序,找 LORA 相关
sub = db[db['parent'] == '9000010400-A01'].copy()
out.append(f"数据库 9000010400-A01 直接子件数: {len(sub)}")
lora = sub[sub.apply(lambda r: 'LORA' in str(r['MaterialName']).upper() or '3420' in r['code'], axis=1)]
for _, r in lora.iterrows():
out.append(f" {r['code']} {r['MaterialName']} Level={r['Level']} Usage={r['UsageQty']}")
# 金蝶 1.11.2 直接子件
kd = pd.read_excel('物料清单正查_1.xlsx', sheet_name='树形单据体')
kd = kd[kd['子项物料编码'].notna()].copy()
kd['code'] = kd['子项物料编码'].astype(str).str.strip()
kd['name'] = kd['物料名称'].astype(str).str.strip()
kd['lv'] = kd['BOM层级'].astype(str).str.strip()
d4 = kd[kd['lv'].apply(lambda x: x.startswith('1.11.2.') and len(x.split('.')) == 4)].copy()
d4['seq'] = d4['lv'].apply(lambda x: int(x.split('.')[-1]))
d4 = d4.sort_values('seq')
# 对比两个集合
db_set = set(sub['code'])
kd_set = set(d4['code'])
only_db = sorted(db_set - kd_set)
only_kd = sorted(kd_set - db_set)
out.append(f"\n仅数据库有 ({len(only_db)}):")
for c in only_db:
nm = sub[sub['code'] == c]['MaterialName'].iloc[0]
out.append(f" {c} {nm}")
out.append(f"\n仅金蝶有 ({len(only_kd)}):")
for c in only_kd:
nm = d4[d4['code'] == c]['name'].iloc[0]
out.append(f" {c} {nm}")
with open('cmp_10400.txt', 'w', encoding='utf-8') as f:
f.write('\n'.join(out))
print("done")