# -*- coding:utf-8 -*-
# !/usr/bin/env python
"""
Date: 2025/9/13 16:00
Desc: 深圳证券交易所-期权子网-行情数据-当日合约
"""
from io import BytesIO

import pandas as pd
import requests


def option_current_day_szse() -> pd.DataFrame:
    """
    深圳证券交易所-期权子网-行情数据-当日合约
    https://www.sse.org.cn/option/quotation/contract/daycontract/index.html
    :return: 深圳期权当日合约
    :rtype: pandas.DataFrame
    """
    import warnings
    warnings.filterwarnings(action='ignore', message="Workbook contains no default style")
    url = "https://www.sse.org.cn/api/report/ShowReport"
    params = {
        "SHOWTYPE": "xlsx",
        "CATALOGID": "option_drhy",
        "TABKEY": "tab1",
    }
    r = requests.get(url, params=params)
    temp_df = pd.read_excel(BytesIO(r.content))
    temp_df['序号'] = pd.to_numeric(temp_df['序号'], errors='coerce')
    temp_df['行权价'] = pd.to_numeric(temp_df['行权价'], errors='coerce')
    temp_df['合约单位'] = pd.to_numeric(temp_df['合约单位'], errors='coerce')
    temp_df['涨停价格'] = pd.to_numeric(temp_df['涨停价格'], errors='coerce')
    temp_df['跌停价格'] = pd.to_numeric(temp_df['跌停价格'], errors='coerce')
    temp_df['前结算价'] = pd.to_numeric(temp_df['前结算价'], errors='coerce')
    temp_df['合约总持仓'] = pd.to_numeric(temp_df['合约总持仓'], errors='coerce')
    temp_df['原行权价格'] = pd.to_numeric(temp_df['原行权价格'], errors='coerce')
    temp_df['原合约单位'] = pd.to_numeric(temp_df['原合约单位'], errors='coerce')
    temp_df['合约到期剩余交易天数'] = pd.to_numeric(temp_df['合约到期剩余交易天数'], errors='coerce')
    temp_df['合约到期剩余自然天数'] = pd.to_numeric(temp_df['合约到期剩余自然天数'], errors='coerce')
    temp_df['下次合约调整剩余交易天数'] = pd.to_numeric(temp_df['下次合约调整剩余交易天数'], errors='coerce')
    temp_df['下次合约调整剩余自然天数'] = pd.to_numeric(temp_df['下次合约调整剩余自然天数'], errors='coerce')
    temp_df['交易日期'] = pd.to_datetime(temp_df['交易日期'], errors='coerce').dt.date
    temp_df['最后交易日'] = pd.to_datetime(temp_df['最后交易日'], errors='coerce').dt.date
    temp_df['行权日'] = pd.to_datetime(temp_df['行权日'], errors='coerce').dt.date
    temp_df['到期日'] = pd.to_datetime(temp_df['到期日'], errors='coerce').dt.date
    temp_df['交收日'] = pd.to_datetime(temp_df['交收日'], errors='coerce').dt.date
    temp_df = temp_df[[
        '序号',
        '合约编码',
        '合约代码',
        '合约简称',
        '标的证券简称(代码)',
        '合约类型',
        '行权价',
        '合约单位',
        '最后交易日',
        '行权日',
        '到期日',
        '交收日',
        '新挂',
        '涨停价格',
        '跌停价格',
        '前结算价',
        '合约调整',
        '停牌',
        '合约总持仓',
        '挂牌原因',
        '原合约代码',
        '原合约简称',
        '原行权价格',
        '原合约单位',
        '合约到期剩余交易天数',
        '合约到期剩余自然天数',
        '下次合约调整剩余交易天数',
        '下次合约调整剩余自然天数',
        '交易日期',
    ]]
    return temp_df


if __name__ == "__main__":
    option_current_day_szse_df = option_current_day_szse()
    print(option_current_day_szse_df)