
    c
h6                     &   S SK r S SKJrJrJr  S SKJr  S SKJr  S SK	J
r
  S SKJr  \" 5       r\" 5         \ R                  " SS5      r\R!                  S	5      \" \5      4S
\4S jj5       r\R'                  S5      \" \5      4S\S
\4S jj5       rg)    N)	APIRouterDependsHTTPException)"disable_installed_extensions_check)Certificate)Registration)check_token_validityFILE_STORAGE_PATHfilesz/users/me/certificatesdependenciesc                    U u  pUR                  [        5      R                  [        R                  UR                  :H  [        R
                  S :g  5      R                  5       nU Vs/ s H_  nUR                  c  M  UR                  R                  UR                  R                  UR                  R                  UR                  S.PMa     nnSU0$ s  snf )N)idtitleissued_date
program_idcertificates)queryr   filteruser_idr   certificate_idallcertificater   r   r   )r   dbuserregistrations_with_certregr   s         HD:\kofCorporation\kof-academy-backend\app\routers\students\certificat.pyget_user_certificatesr      s     HB 		$$/1L1LPT1T	U	  +	 +C??	
//$$__**??66..		
 +  	 L))	s   (C=ACz#/certificates/{certificate_id}/sendr   c                 F   Uu  p#UR                  [        5      R                  [        R                  UR                  :H  [        R
                  U :H  5      R                  5       nU(       a  UR                  (       d
  [        SSS9eUR                  nSSUR                   30$ )Ni  zCertificat introuvable)status_codedetailmessageu#   Certificat envoyé avec succès à )
r   r   r   r   r   r   firstr   r   email)r   r   r   r   registrationr   s         r   send_certificater&   2   s    
 HB 		$$/1L1LP^1^	_	  |774LMM**K
 <TZZLIJJ    )osfastapir   r   r   fastapi_pagination.utilsr   app.models.certificater   app.models.registrationr   app.utils.authentificationr	   routergetenvr
   gettupler   postintr&    r'   r   <module>r5      s    	 6 5 G . 0 ;
 
 " $II17;  $%!"67** &*4 23 ""67KKK 4Kr'   