a ž"¾hèã@sìddlmZmZmZmZddlmZddlmZddl m Z m Z m Z ddl mZddlmZddlmZddlZeƒZed d Ze e ƒƒZe d ¡ed ƒed ƒed ƒeeƒfeeeedœdd„ƒZe d ¡deeƒfeeedœdd„ƒZdS)é)Ú APIRouterÚRequestÚDependsÚForm)ÚJinja2Templates)ÚRedirectResponse)Ú open_mysqlÚget_mysql_credsÚget_pingconf_vars)Úget_current_user)Ú xor_bytes)ÚHTTP_303_SEE_OTHERNz"/wd/v2025.freedom4um.com/templates)Ú directoryz /mailcompose.Ú)Úto_listÚsubjectÚCommentÚ current_usercCs8|s ddiS|d}dd„| d¡Dƒ}t| d¡ƒ}t| d¡ƒ}ttƒÊ}|jdd } |r¤d d gt|ƒ¡} |  d | ›d |¡|   ¡} d d d„| Dƒ¡} nd} d} |  | || ||f¡|  ¡| j }d}|  |||df¡|D]}|  |||df¡qè|  ¡Wdƒn1s0Yd}t |t dS)NÚerrorÚ UnauthorizedÚHandleIDcSs g|]}| ¡ ¡rt|ƒ‘qS©)ÚstripÚisdigitÚint)Ú.0Úxrrú./wd/v2025.freedom4um.com/routes/mailcompose.pyÚ óz$mailcompose_post..ú,úutf-8T©Ú dictionaryú%sz.SELECT Handle FROM Handles WHERE HandleID IN (ú)cSsg|] }|d‘qS)ÚHandler)rÚrrrrr%rrz INSERT INTO PrivateMail (FromHandleID, ToLine, PostDate, Subject, MailBodyBlob) VALUES (%s, %s, NOW(), %s, %s) z INSERT INTO PrivateMailPing (PMailNum, ToHandleID, MailStatus, Folder) VALUES (%s, %s, 'N', %s) ÚSÚIz/maillist?folder=S)ÚurlÚ status_code)Úsplitr ÚencoderÚ mysql_credsÚcursorÚjoinÚlenÚexecuteÚfetchallÚcommitÚ lastrowidrr )rrrrZ sender_idÚto_idsÚ encoded_bodyZencoded_subjectÚconnr/Ú placeholdersÚ recipientsZto_lineZsql_mailZ new_pmail_numZsql_pingÚto_idÚ redirect_urlrrrÚmailcompose_posts2  (r=)ÚrequestÚPMNrc CsÚ|s tdƒSd}g}|rÂttƒŒ}|jdd}| d|f¡| ¡}|r¢| d|f¡dd„| ¡Dƒ}|d|vr |d|d kr tdƒWdƒS|rÞd  d gt|ƒ¡} | d | ›d |¡dd„| ¡Dƒ}t |dpêdƒj ddd} t j | gd¢dd|d<| d|d f¡| ¡} | r8| dnd|d<t |  d¡ƒpRd} | j ddd} |  d¡svd| } t j | gd¢dd|d<d|d<|}t|ƒWdƒn1s¸0Yt d |||||d!œ¡S)"Nz/signinTr"z© SELECT PMailNum, FromHandleID, ToLine, PostDate, Subject, MailBodyBlob FROM PrivateMail WHERE PMailNum = %s zCSELECT DISTINCT ToHandleID FROM PrivateMailPing WHERE PMailNum = %scSsg|] }|d‘qS)Z ToHandleIDr©rÚrowrrrr[rz#mailcompose_get..rZ FromHandleIDr r$z8SELECT HandleID, Handle FROM Handles WHERE HandleID IN (r%cSsg|]}|d|ddœ‘qS)rr&)rÚNamerr@rrrrdrZ MailBodyBlobrr!Úreplace)Úerrors)ÚbÚiÚuÚbrÚp)Útagsrz6SELECT Handle AS Name FROM Handles WHERE HandleID = %srBÚUnknownÚFromNameÚSubjectzRe:zRe: )rErFrGZ private_mailÚtypezmailcompose.html)r>rÚ context_itemZ pmail_numÚto_users)rrr.r/r2Úfetchoner3r0r1r ÚdecodeÚbleachÚcleanÚgetÚ startswithÚprintÚ templatesÚTemplateResponse)r>r?rrOrPr8r/Úmailr6r9Z body_textZfrom_rowZ subject_bytesZ subject_textrrrÚmailcompose_getDsT  ü (ûþr[)ÚfastapirrrrÚfastapi.templatingrÚfastapi.responsesrÚutils.pingdatarr r Ú utils.authr Z utils.xorr Zstarlette.statusr rSÚrouterrXr.ÚpostÚstrÚdictr=rUrr[rrrrÚs.       üü5