a =(\a&@sddlZddlZddlmZmZddlmZddlmZddlmZddl Z ddl Z ddl Z ddl mZddlZddlmZddlZddlZdZd Zd Zd Zd Ze jjd ddddZddZddZddZddZddZddZ ddZ!d d!Z"e#d"kre"ej$d#ddS)$N)urlparseparse_qs) BeautifulSoup)urljoin)pprint) IMAPClientpolicyzhttps://sso.golf.co.nz/zPhttps://sso.golf.co.nz/login?v=http%3a%2f%2fedge.live.golf.co.nz%2fvalidate.aspxz9https://edge.live.golf.co.nz/Controls/CalendarHelper.ashxzIhttps://edge.live.golf.co.nz/Shared/Tournaments/Setup/Competition_ng.aspxzWhttps://edge.live.golf.co.nz/Shared/api/MemberQuickSearchService.aspx/SearchClubMembersz feeminder.nztaranakicowsandsheepeating django_pairs)hostuserpassworddatabasecCs||dD]}|D] }d|_qq|dD]}|D] }d|_q.q&|dD]}|D] }d|_qLqD|dD]}|D] }d|_qjqbdS)NzA2:E61zG2:H61zJ2:L61zN2:O61)value)sheetrowcellr1/var/www/taranaki_pairs/entries/taranaki_pairs.py ClearDatas       rcCs\d}t|}|d}t|t}d}|||}d}|D]}|j|dtt |dd|j|d|dd|j|d |dd|j|d |dd|j|d |d d|j|d |d d|j|d |d d|j|d|dd|j|d|d d|j|d|d d|j|d|dd|j|d|dd|d7}qD|j |ddS)NzTaranaki Pairs Master.xlsxZ2021zSELECT id, p1_surname, p1_firstname, p1_id, p1_gender, p1_index, p2_surname, p2_firstname, p2_id, p2_gender, p2_index, paid FROM entries_players WHERE 1 )rcolumnrr   )filename) openpyxlZ load_workbookrmydbcursorexecutefetchallrnextitersave)r(wbrmycursorsqlrowsZ row_indexrrrr FillSheet+s0    r5cCsFdddddd|d}ddi}|jtt||d}|}|dd S) Nfalsertrue)ZexcludeHomeClubMembersZfilterByClubIdZincludeAffiliatedMembersZincludeCasualGolfersZincludeResignedMembersZincludeSocialMembersZ searchTextz Content-Typezapplication/json)dataheadersdZResults)post member_datajsondumps)sidpayloadr9resresultrrrget_member_dataIs rDcCsdS)Nrrrrr UpdateScores]srEcCs<|dkr"t|dddddSt|dddd dS) NMg@Y@g@\@gQ@gP@rgY@DgP@)round)indexZgenderrrr GetHandicap`srJc Cstdd}|}|||}|D]x}t|d|d}t|d|d}t||dkrl||}nt||dd}|d}d}||||||d fq*|td dS) Nz%Calculating Player and Team HandicapszPSELECT id, p1_index, p1_gender, p2_index, p2_gender FROM entries_players WHERE 1rrrrr!zNUPDATE entries_players SET p1_hcap = %s, p2_hcap = %s, hcap = %s WHERE id = %srzDone with calculations)printr+r,r-rJabsmincommit)r*r3r+r4rp1_hcapp2_hcaphcaprrrUpdateHandicapses   rRcCstdtdddd}|dd|dtd |gd }td ||gd }td t}|D]P\}}t j |dt j d}| d}|drvi}|d} | D]x} d} t| dd} | D]X} | d}t|dkr|d}|d}|dr,| r(|d7}d} |||<qqtd|d|dd|dd|dd |d!d"|d!d#|d$d|d%d|d&d'}t||||d|dfqvttd(Wdn1s0YdS))NzProcessing Emailzchristini.co.nzF)r portsslZjohnZdogma02zTaranaki Pairs.2021z Logged in)NOTZDELETEDrVZSEENzFetching messages)FLAGSz RFC822.SIZEZRFC822z BODY[TEXT]z Done fetchingsRFC822rSubjectzTaranaki Pairs Entryrz  :rrzClub ID2TzProcessing {}/{}z Team Captainz Second PlayerzINSERT INTO entries_players ( year , p1_name, p1_id_reg, p1_id, p2_name, p2_id_reg, p2_id, address, phone, email) VALUES ( '2021', %s, 'z', 'z', %s, 'zClub ID2z$', 'z','zContact AddressZPhoneEmailz!') ON DUPLICATE KEY UPDATE id=id zDone with Email)rKrloginZ select_foldersearchZfetchr*r+itemsemailmessage_from_bytesr defaultget startswith get_payloadwalkstrsplitlenstripformatr,rN)clientmessagesresponser2 message_idr8 email_messagesubjectrecordZpbifoundlineslinevalskeyrr3rrr ProcessMailxs~            ryc Cs t|dkr&|ddkr&tttt|dkrJ|ddkrJtttt}t|dkr|ddkrtdd}||t ddd }t  }td d |j d <| t}t|jd }dd|dD}|d|d<|d|d<|jt|d}t|jd }d}|||} td| D]d} td| d| dt|| d} t|| d} t| dkst| dkrt| dkrtd| dt| dkrtd| dn| d} | d} d| dd| d d!t| d"d#| d$d%| dd&| d d't| d"d(| d$d)t| d}z||| d*| d*fWntyttYn0td+q4t td,ttWdn1s0Yt|dkr|dd-krtd.ttd/dS)0NrZ handicapsZscoresresetzReseting ScoreszCUPDATE entries_players SET p1_index = null, p2_index = null WHERE 1Z 203remotecZ21Remote)rpasszConnecting to DotGolfzfMozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.104 Safari/537.36z User-Agentz html.parsercSsi|]}|d|ddqS)namerr)rc).0rsrrr zmain..z input[name]rzSSOLogin.Usernamer{zSSOLogin.Password)r8zWSELECT id, p1_id, p2_id FROM entries_players WHERE p1_index is NULL or p2_index is NULLzProcessing playerszFetching DotGolf Data for {}/{}rrzPlayer 1 ID {} is InvalidzPlayer 2 ID {} is Invalidz;UPDATE entries_players SET p1_surname = %s, p1_firstname ='Z FirstNamez', p1_gender = 'ZGenderz', p1_index = Z HandicapIndexz , p1_club = 'Z HomeClubNamezL', p2_surname = %s, p2_firstname ='z', p2_gender = 'z', p2_index = z , p2_club = 'z!' WHERE id=ZLastNameg?zDone with DotGolf processingrzUpdating SpreadsheetzAll done)rirRr*quitrEryr+rKr,rNrequestsSessionr9rclinkrtextselectr;urlr-rkrDrg Exceptiontimesleepr5) argvr2r3configr?rZsouprArBr4rp1p2rrrmains           6  (r__main__r)%rer urllib.parserrZbs4rrrr=rZmysql.connectormysqlZ imapclientrr`r sysr)rrZ competitionsZ comp_datar< connectorconnectr*rr5rDrErJrRryr__name__rrrrrsD     4G