import pandas as pd
import pymysql

# Excel数据
df = pd.read_excel('扫货成功数据_2026-04-26 (1).xlsx')
row = df.iloc[39]
wear_value = row.iloc[3]  # 0.036458
goods_id = str(row.iloc[1])  # 1133139
deal_price = row.iloc[6]  # NaN

print('Excel数据:')
print(f'  序号: {row.iloc[0]}')
print(f'  饰品ID: {goods_id}')
print(f'  磨损值: {wear_value}')
print(f'  成交价格(人民币): {deal_price}')
print()

# 数据库数据
conn = pymysql.connect(host='125.122.32.114', port=3306, user='root', password='Buff123456', database='buff')
cursor = conn.cursor(pymysql.cursors.DictCursor)
cursor.execute('SELECT * FROM buff_goods_float_price WHERE goods_id = %s', (goods_id,))
rows = cursor.fetchall()
cursor.close()
conn.close()

print('数据库中的区间 (goods_id=1133139):')
for r in rows:
    in_range = r['min_float'] <= wear_value <= r['max_float']
    marker = ' <-- 匹配' if in_range else ''
    print(f"  {r['min_float']:.2f} - {r['max_float']:.2f}: qj_min_price={r['qj_min_price']}{marker}")

print()
print('问题原因: 成交价格(人民币)为空(NaN)，无法计算利润')