
    fi                         d Z ddlZddlmZ ddlmZ ddlZddlZddlm	Z	  ed          dej
        fd	            Zddedej
        fdZedk    r ed
          Z ee           dS dS )uZ   
Date: 2025/11/25 18:00
Desc: 99 期货网-大宗商品库存数据
https://www.99qh.com/
    N)datetime)	lru_cache)BeautifulSoup    )maxsizereturnc                     ddl } |                     d           d}t          j        |d          }t	          |j        d          }|                    d	d
i          j        }t          j        |          }g }t          |d         d         d         d                   D ]R\  }}t          j        |d         d         d         d         |         d                   }	|                    |	           St          j        |d          }
|
S )u   
    99 期货网-品种代码对照表
    https://www.99qh.com/data/stockIn?productId=12
    :return: 品种代码对照表
    :rtype: pandas.DataFrame
    r   Nignorez!https://www.99qh.com/data/stockInF)verifylxml)featuresid__NEXT_DATA__)attrsprops	pagePropsdatavarietyListDataproductListT)ignore_index)warningsfilterwarningsrequestsgetr   textfindjsonloads	enumeratepd	DataFrameappendconcat)r   urlrsoupraw_data	data_jsondf_listiitemtemp_dfbig_dfs              O/usr/local/lib/python3.11/dist-packages/akshare/futures/futures_inventory_99.py__get_99_symbol_mapr/      s    OOOH%%%
-CS'''A&111Dyyo6y77<H
8$$IG';'/0AB     4 ,g{+F34EFqI-X
 
 	wYwT222FM       豆一symbolc                    ddl }|                    d           t                      }t          t	          |d         |d                             }t          t	          |d         |d                             }| |v r	||          }n | |v r	||          }nt          d|  d          d	}d
ddddd}|ddddt          j                                                    	                                 dd}t          j        |||d          }	|	                                }
t          j        |
d         d                   }g d|_        |                    dgdd           t          j        |d         d          j        j        |d<   t          j        |d         d          |d<   t          j        |d         d          |d<   |S ) u  
    99 期货网-大宗商品库存数据
    https://www.99qh.com/data/stockIn?productId=12
    :param symbol: 交易所对应的具体品种; 如：大连商品交易所的 豆一
    :type symbol: str
    :return: 大宗商品库存数据
    :rtype: pandas.DataFrame
    r   Nr
   name	productIdcodeu   未找到品种 u    对应的编号z5https://centerapi.fx168api.com/app/qh/api/stock/trendzapplication/json;charset=UTF-8zEsaNkne9QG4I9UVJ7SWrJg2qdijCOn5B9HYFtyP0ybvBJxY4rhONnGQLU4QwEICzum+cJJR2/iQXfDOrqvK3JYgLxJ5bchYkyUU8qRQ3mwcpA/kyYUSioAs4gd+9s1xPhWF7YOp8bAlEGumxbGCziTq2A8up6sdOYV+hnU/b1iM=zrMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.3zhttps://www.99qh.com)zContent-Type_pccz
user-agentrefererorigin15000 web)r5   typepageNopageSize	startDateendDateappCategoryF)headersr   r   list)   日期	   收盘价   库存rF   T)byr   inplacecoerce)errorsrG   rH   )r   r   r/   dictzip
ValueErrorr   nowdate	isoformatr   r   r   r    r!   columnssort_valuesto_datetimedt
to_numeric)r2   r   r,   symbol_name_mapsymbol_code_map
product_idr$   rD   paramsr%   r(   s              r.   futures_inventory_99r\   .   s    OOOH%%%!##G3wv0DEEFFO3wv0DEEFFO  $V,

	?	"	"$V,

DFDDDEEE
AC8r:)( G  lnn))++55779 F 	S&'%@@@AIl9V,V455G777GOH:D$GGGwx'8JJJMRGH=)=hOOOGKgh&7IIIGHNr0   __main__)r2   )r1   )__doc__r   r   	functoolsr   pandasr    r   bs4r   r!   r/   strr\   __name__futures_inventory_99_dfprint r0   r.   <module>rg      s                            2R\    60 0 0BL 0 0 0 0f z22(CCC	E
!""""" r0   