o ‰¬‹ißã@s’ddlZddlZddlZddlmZmZmZddlmZe d¡Z dZ dddd d d d œZ d Z dd„Z dd„Zdd„Zdd„Zdd„Zddd„ZdS)éN)ÚdatetimeÚtimezoneÚ timedelta)ÚurlopenÚGEBotz¤https://docs.google.com/spreadsheets/d/e/2PACX-1vTKwg06Ld5j5gT66m7iVU7pHm3KTM0HShnORH_pIfrbaBecXZe_LiXSOcoVHcToPMqxlC4FLtHlgBma/pub?gid={gid}&single=true&output=csvé=u`iÆÏãigtiźqi0=ç9ißk69)z2026-02z2026-01z2025-12z2025-11z2025-10z2025-09iÉcCsV|sdS| dd¡ dd¡ dd¡ ¡}|r|dvrdSztt|ƒdƒWSYdS)Nrú$Úú,ú")z#DIV/0!z#REF!z#N/Aé)ÚreplaceÚstripÚroundÚfloat©Úval©rú'/var/www/html/bot-teams/sheet_reader.pyÚ parse_moneys   rcCs<|sdS| dd¡ dd¡ ¡}ztt|ƒƒWSYdS)Nrr r r )r rÚintrrrrrÚ parse_ints rcCs0|sdS| dd¡ ¡}d|vsd|vrdS|S)Nz0%r r z#DIVz#REFzN/A)r rrrrrÚ parse_pct src Csrzttj|ddd}tt t | ¡  d¡¡¡ƒWSt y8}zt   d|›d|›¡WYd}~dSd}~ww)N)Úgidé)Útimeoutzutf-8zSheet fetch error gid=z: ) rÚBASE_PUBÚformatÚlistÚcsvÚreaderÚioÚStringIOÚreadÚdecodeÚ ExceptionÚlogÚerror)rÚrespÚerrrÚ fetch_csv&s €þr*c Cs(|sdSi}t|ƒdkrt|dƒdkrt|ddƒ|d<d}t|ƒD]\}}t|ƒdkr/q$|d ¡}|d ¡}|dkrCt|ƒ}q$|durM||d<n| dd¡|d<|D]õ}t|ƒdkr`qW|d ¡}|d ¡}|dkrwt|ƒ|d <qW|d kr‚t|ƒ|d <qW|d krt|ƒ|d <qW|dkrœd|vrœt|ƒ|d<qW|dkr§t|ƒ|d<qW|dkr²t|ƒ|d<qW|dkr½t|ƒ|d<qW|dkrÈt|ƒ|d<qW|dkrÓt|ƒ|d<qW|dkrÞt|ƒ|d<qW|dkrét|ƒ|d<qW|dkrôt|ƒ|d<qW|d krd!|vrt|ƒ|d!<qW|d"krt|ƒ|d#<qW|d$krt|ƒ|d%<qW|d&kr)t|ƒ|d'<qW|d(kr5t|ƒ|d)<qW|d*krAt|ƒ|d+<qW|d,vrLt|ƒ|d-<qWt|ƒD]Z\}}t|ƒd.kr^qQ|dri|d ¡nd/}|drv|d ¡nd/}d0t|ƒd1kr„|d1nd/vr‰ d2t|ƒd1kr•|d1nd/vs©d3t|ƒd1kr¥|d1nd/vrª qQt|dd4…ƒD]’\}}t|ƒd.krÁq´|d1rÌ|d1 ¡nd/} |dkrù|d.krùd2| vrùd3| vrù|  d5¡sî|  d6¡rùd7|vrùt| ƒ|d7<d8| vr |dt|ƒkrt||dƒd1krt||dd1ƒ|d9<q´d:| vrE|dt|ƒkrEt||dƒd1krEt||dd1ƒ|d;<q´d7|vr‹tdd<ƒD]9}|t|ƒkr‰t||ƒd1kr‰||d1 ¡}|r‰| d5¡sz| d6¡r‰t|ƒdkr‰t|ƒ|d7<nqQd9|vr”d|d9<d;|vrd|d;<d7|vr¦d|d7<g} |dd=…D]C}t|ƒd>kr¹q®|d?rÄ|d? ¡nd/} | rÓd@| vsÓdA| vrÕq®|   | t|dBƒt|d<ƒt|dCƒt|dDƒdEœ¡q®t | dFdG„dHdI|dJ<t|dƒd1kr|dd1 ¡nd/|dK<|S)LauParse monthly D/W sheet. Structure varies by month: Feb 2026: Row1=Deposit Gross, Row7=Deposit Net Jan 2026: Row1=Deposit Net(actually gross), Row7=Deposit Net(real) Dec/Nov 2025: Row1=Total Gross Deposit, Row3=Deposit Net Strategy: find ALL rows with key fields, use LAST Deposit Net as real net. Row 1 col B is always Gross (regardless of label). NréÚ deposit_grossr z Deposit NetÚ deposit_netzUS grossÚus_grosszUK grossÚuk_grosszAmount RefundedÚrefundedzUS NetÚus_netzUK NetÚuk_netz US money outÚ us_money_outz UK money outÚ uk_money_outzRET Deposit CountÚ ret_depositszCONV Deposit CountÚ conv_depositsz FTDs receivedÚftdszUS leadsÚus_leadszUK leadsÚuk_leadsÚPLVÚplvÚRunrateÚrunrateÚTARGETÚtargetz Upsell CountÚ upsell_countzUpsell From CONVÚ upsell_pctz Conv rate %Ú conv_rate)z % REFUND NETz% WD/refunds NETz% WD NETÚ refund_pctér z Total dailyéz Daily Netz Daily Grossrrz-$Ú daily_totalz US Daily NetÚ us_daily_netz UK Daily NetÚ uk_daily_netééé éÚAgentÚTotalséé é )ÚusÚcountÚdepositÚrefundÚnetcSs|dS)NrVr)ÚxrrrÚžsz%parse_monthly_sheet..T)ÚkeyÚreverseÚagentsÚdate) ÚlenrÚ enumeraterÚgetrrÚ startswithÚrangeÚappendÚsorted) ÚrowsÚdataÚ last_dep_netÚiÚrrYrÚc_valÚd_labelÚd_valr[Úus_namerrrÚparse_monthly_sheet.s¶  €   "  € @€   (€ (€  , €     û*rmÚmonthcCs>ttddƒ}t |¡}| d¡}t |d¡}t|ƒ}t|ƒS)Nr )Úhoursz%Y-%mr) rrrÚnowÚstrftimeÚMONTHLY_SHEETSr_r*rm)ÚperiodÚeetrprYrrdrrrÚfetch_sheet_data¢s    ru)rn)rr!ÚloggingrrrÚurllib.requestrÚ getLoggerr&rrrÚ DAILY_GIDrrrr*rmrurrrrÚs&  út