
    eiE                     B    d dl mZ d dlZd dlZ G d de      Zd Zd Zy)    )FPDFNc                       e Zd Zd Zd Zy)	PDFReportc                 x    | j                  ddd       | j                  dddddd       | j                  d	       y )
NArialB   r   
   u   Relatório Executivo - GLPI   C   )set_fontcelllnselfs    //var/www/html/glpi_dashboard/modules/reports.pyheaderzPDFReport.header   s4    gsB'		!R61cB
    c                     | j                  d       | j                  ddd       | j                  ddd| j                          ddd       y )	Nir   I   r   r
   u   Página r   )set_yr   r   page_nor   s    r   footerzPDFReport.footer   sA    

3gsA&		!R8DLLN#34aC@r   N)__name__
__module____qualname__r   r    r   r   r   r      s    
Ar   r   c           	      z   t               }|j                          |j                  ddd       |j                  ddd       |j                  ddddd	       |j                  ddd       |j                  ddd
|d    dd	       |j                  ddd|d    dd	       |j                  ddd|d    dd	       |j                  ddd|d   dddd	       |j	                  d       |j                  ddd       |j                  ddddd	       |j                  ddd       |j                  dddd	       |j                  dddd	       |j                  dddd	       |j	                          |j                  ddd       | j                  d      j                         D ]x  \  }}|j                  ddt        |d         d	       |j                  ddt        |d         d d d	       |j                  ddt        |d         d	       |j	                          z |j                  d !      j                  d"      S )#Nr       r      r   r
   zResumo Executivor   zTotal de Chamados: totalzChamados Solucionados: solvedzChamados em Aberto: openzTaxa de Sucesso: success_ratez.1f%zChamados Recentes   IDd   u   Título(   Statusr	   idname2   statusS)destzlatin-1)
r   add_pager   r   r   headiterrowsstroutputencode)dfkpispdfindexrows        r   generate_pdfr?      s   
+CLLNLL"b! LL#r"HHQ&1-LL"b!HHQ)$w-91a@HHQ-d8n-=>1EHHQ*4<.91a@HHQ'^(<S'ACQJFF2J LL#r"HHQ'A.LL#r" HHRT1HHS"i#HHRXq!FFH LL"b!ggbk**, 
sRSY+b#c&k*3B/3RS]+Q/	 ::3:&&y11r   c                 D    | j                  d      j                  d      S )NF)r=   zutf-8)to_csvr9   )r:   s    r   convert_df_to_csvrB   5   s    9959!((11r   )fpdfr   pandaspdbase64r   r?   rB   r   r   r   <module>rG      s'      	A 	A#2J2r   