
    qiu                        d dl mZmZmZmZ d dlmZ d dlmZ d dl	m
Z
 d dlmZmZmZ d dlmZ d dlmZ d dlmZ  ed	d
g          Z ed          Z e e                      Z eeddge          e                    d	e           edd           ee
           ee          fdedefd                        ZdS )    )	APIRouterRequestDependsQuery)HTMLResponse)Jinja2Templates)get_current_user)get_pingconf_varsget_mysql_creds
open_mysql)	xor_bytes)nav_context)add_dual_routez	/mailreadmailread)prefixtags	templates)	directory GET)methodsresponse_class)r   .zPrivate Mail Number)descriptionrequestPMNc           	         |sddiS d }t          t                    5 }|                    d          }d}|                    |||d         f           |                                }|+t
                              d| |dd          cd d d            S |d	         }	|	d
         dk    r4d}
|                    |
||d         f           |                                 |	d         pd}t          |          	                    dd          }|	d         |	d         |	d         |	d         r*t          |	d                   	                    dd          nd|	d         r*t          |	d                   	                    dd          nd|d}d d d            n# 1 swxY w Y   t
                              d| ||d|          S )NerrorzNot authenticatedT)
dictionarya  
            SELECT p.PMailNum, p.FromHandleID, h.Handle AS FromName, p.ToLine,
                   p.PostDate, p.Subject, p.MailBodyBlob, pp.ToHandleID, pp.Folder, pp.MailStatus
            FROM PrivateMail p
            JOIN PrivateMailPing pp ON pp.PMailNum = p.PMailNum
            JOIN Handles h ON h.HandleID = p.FromHandleID
            WHERE p.PMailNum = %s AND pp.ToHandleID = %s
        idzmailread.html)r   userunauthorizedr   
MailStatusNz
                UPDATE PrivateMailPing
                SET MailStatus = 'R'
                WHERE PMailNum = %s AND ToHandleID = %s AND MailStatus= "N"
            MailBodyBlob    zutf-8replace)errorsPMailNumPostDateFromNameToLiner   Subject)r(   r)   r*   ToNamesr,   MailBody)r   r    message)
r   mysql_credscursorexecutefetchallr   TemplateResponsecommitr   decode)r   r   r    navr/   connr1   sqlrowsrow
update_sql
body_bytes	body_texts                ./wd/v2025.libertysflame.com/routes/mailread.pymailread_pager@      sS     .,--G	K	 	  ,
D-- 	sS$t*-...  <--#T4HH !,
 ,
 ,
 ,
 ,
 ,
 ,
 ,
( 1g |##J
 NN:T$Z'8999KKMMM (/C
j))000KK	 JJJUXYaUbjyX//66wy6QQQhjVYZcVdlyY0077	7RRRjl!
 
K,
 ,
 ,
 ,
 ,
 ,
 ,
 ,
 ,
 ,
 ,
 ,
 ,
 ,
 ,
\ %%TgEEE  s   A+FC5FFFN)fastapir   r   r   r   fastapi.responsesr   fastapi.templatingr   
utils.authr	   utils.pingdatar
   r   r   	utils.xorr   	utils.navr   utils.routesr   routerr   r0   getintr@    r%   r?   <module>rM      s   6 6 6 6 6 6 6 6 6 6 6 6 * * * * * * . . . . . . ' ' ' ' ' ' I I I I I I I I I I       ! ! ! ! ! ! ' ' ' ' ' '	+ZL	9	9	9Ok222	o//1122 UGLIIIK55uS&;<<<	!	"	"; ;7 ;	; ; ; 65 JI; ; ;r%   