a eh@sddlmZmZmZmZmZddlmZddlm Z ddl m Z m Z m Z ddlmZddlmZeZeddZe e Zed d eefeeed d d Zed edededeefeeeeedddZdS)) APIRouterRequestFormDepends HTTPException)Jinja2Templates)RedirectResponse) open_mysqlget_mysql_credsget_pingconf_vars)get_current_user) xor_bytes templates) directoryz /maillistI)requestfolder current_userc Cs|s tdS|d}g}ttz}|jdd}|dkrN|d|f|}n>|dkrn|d|f|}n|d kr|d |f|}Wdn1s0Ytt}|jdd}|D]r}t|d d d |d<|dd}|r.t|} z| d |d<Wnt y*d|d<Yn0qd|d<qWdn1sN0Ydddd|d} t d|||t ||| dS)Nz/signinHandleIDT) dictionaryra SELECT p.PMailNum, p.FromHandleID, h.Handle AS FromName, p.Subject, p.PostDate, pp.MailStatus, p.ToLine FROM PrivateMail p JOIN PrivateMailPing pp ON pp.PMailNum = p.PMailNum JOIN Handles h ON p.FromHandleID = h.HandleID WHERE pp.ToHandleID = %s AND pp.Folder = 'I' ORDER BY p.PMailNum DESC Sa SELECT p.PMailNum, p.FromHandleID, h.Handle AS FromName, p.Subject, p.PostDate, p.ToLine FROM PrivateMail p JOIN PrivateMailPing pp ON pp.PMailNum = p.PMailNum JOIN Handles h ON p.FromHandleID = h.HandleID WHERE pp.ToHandleID = %s AND pp.Folder = 'S' ORDER BY p.PMailNum DESC Aa SELECT p.PMailNum, p.FromHandleID, h.Handle AS FromName, p.Subject, p.PostDate, MailStatus, p.ToLine FROM PrivateMail p JOIN PrivateMailPing pp ON pp.PMailNum = p.PMailNum JOIN Handles h ON p.FromHandleID = h.HandleID WHERE pp.ToHandleID = %s AND pp.Folder = 'A' ORDER BY p.PMailNum DESC ZToLinezutf-8ZToNamesSubjectz(Unreadable Subject)z (No Subject)ZInboxz Sent MailZArchive)rrrz maillist.html)rrmessagesZ message_countZ folder_code folder_title) rr mysql_credscursorexecutefetchallr getdecodeUnicodeDecodeErrorrTemplateResponselen) rrrZ handle_idrconnrmsgencoded_subjectZ decoded_bytesrr)+/wd/v2025.freedom4um.com/routes/maillist.pymaillistsX     &   * r+.)rractionselected_messagesc s:|stdddtt}|}ddgt|}d|d}||g||dRd d |D} t| | std d d|d krd|d} || g||d|Rn@|dkrd|d} || g||d|Rn tddd| Wdn1s0Yd|} t | ddS)NizNot authenticated) status_codedetail,z%szQ SELECT PMailNum FROM PrivateMailPing WHERE PMailNum IN (z) AND ToHandleID = %s idcSsh|] }|dqS)rr)).0rowr)r)r* |rz&handle_mail_actions..izForbidden: Invalid message IDsarchivezl UPDATE PrivateMailPing SET Folder = 'A' WHERE PMailNum IN (z1) AND ToHandleID = %s AND Folder= %s deletezP DELETE FROM PrivateMailPing WHERE PMailNum IN (izInvalid actionz/maillist?folder=i/)urlr.) rr rrjoinr%rr setissubsetcommitr) rrr,r-userr&r placeholderssqlZ valid_msgs update_sqlZ delete_sql redirect_urlr)r)r*handle_mail_actionsgs4      ( rAN)fastapirrrrrfastapi.templatingrfastapi.responsesrutils.pingdatar r r utils.authr utils.xorr routerrrr!strdictr+postlistintrAr)r)r)r*s*      X