
    h                        d dl 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
 d dlmZ  e       Z e         e j                  dd      Zej!                  d	       ee      fd
efd       Zej'                  d       ee      fded
efd       Zy)    N)	APIRouterDependsHTTPException)"disable_installed_extensions_check)Certificate)Registration)check_token_validityFILE_STORAGE_PATHfilesz/users/me/certificatesdependenciesc                    | \  }}|j                  t              j                  t        j                  |j                  k(  t        j
                  d k7        j                         }|D cg c][  }|j                  M|j                  j                  |j                  j                  |j                  j                  |j                  d] }}d|iS c c}w )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         f/Users/theessential/Documents/Github/KofAcademy/kof-academy-backend/app/routers/students/certificat.pyget_user_certificatesr      s     HB 		$$/1L1LPT1T	U	  +	 ??& //$$__**??66..		
	L 	 L))	s   )A Cz#/certificates/{certificate_id}/sendr   c                 :   |\  }}|j                  t              j                  t        j                  |j                  k(  t        j
                  | k(        j                         }|r|j                  st        dd      |j                  }dd|j                   iS )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 ;
 
 " $BII17;  $%!"67** &*4 23 ""67KKK 4Kr'   