Ë
    í k  ã                   óÀ   — d Z ddlmZ ddlmZ ddl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  ed
d¬«      Z edd¬«      Zd„ Zd„ Zdd„Zd„ Zdd„Zd„ Zy)aL  
Excel (.xlsx) downloads for every report page.

    return xlsx_response('loan_reports', 'Loan Reports', headers, rows,
                         subtitle='From 01 Nov 2026 to 20 Nov 2026')

`rows` is a list of lists (numbers stay numbers so Excel can add them up).
Also has the shared date-range parser used by the report filters.
é    )Údatetime)ÚDecimal)ÚBytesIO)ÚHttpResponse)Útimezone)ÚWorkbook)Ú	AlignmentÚFontÚPatternFill)Úget_column_letterÚsolidÚ0B2447)ÚfgColorTÚFFFFFF)ÚboldÚcolorc                 óŠ   — t        | t        «      rt        | «      S t        | t        «      r| d d dv rt	        | «      sd| z   S | S )Né   )Ú=Ú+Ú-Ú@Ú')Ú
isinstancer   ÚfloatÚstrÚ
_is_number©Úvalues    ú8/var/www/html/nexus_chitfund_web/NexusApp/utils/excel.pyÚ_cleanr!      sE   € Ü�%œÔ!Ü�U‹|ÐÜ�%œÔ %¨¨ )Ð/CÑ"CÌJÐW\ÔL]Ø�U‰{ÐØ€Ló    c                 ó:   — 	 t        | «       y# t        $ r Y yw xY w)NTF)r   Ú
ValueError)Útexts    r    r   r       s#   € ðÜˆdŒØøÜò Ùðús   ‚ Ž	™Nc                 ó2  — t        «       }|j                  }|xs ddd |_        |j                  |g«       t	        dd¬«      |d   _        |j                  |xs& dt        j                  «       j                  d	«      › �g«       |j                  g «       |j                  t        |«      «       |j                  }||   D ]*  }	t        t        c|	_        |	_        t        d
¬«      |	_        Œ, |D ]*  }
|j                  |
D �cg c]  }t!        |«      ‘Œ c}«       Œ, |rM|j                  |D �cg c]  }t!        |«      ‘Œ c}«       ||j                     D ]  }	t	        d¬«      |	_        Œ t#        |d¬«      D ]•  \  }}t%        t'        t)        |«      «      g|dd D �cg c].  }|dz
  t'        |«      k  sŒt'        t)        ||dz
     «      «      ‘Œ0 c}z   «      }t+        t%        |dz   d«      d«      |j,                  t/        |«         _        Œ— |j3                  |dz   d¬«      |_        t7        «       }|j9                  |«       dj;                  d„ | D «       «      xs d}t=        |j?                  «       d¬«      }d|› d�|d<   |S c c}w c c}w c c}w )z7Build a one-sheet workbook and return it as a download.ÚReportNé   Té   )r   ÚsizeÚA1z
Generated z%d %b %Y %I:%M %pÚcenter)Úvertical)r   r   )Ústartiô  é   é
   é-   )ÚrowÚcolumnÚ c              3   óJ   K  — | ]  }|j                  «       s|d v sŒ|–— Œ y­w)z-_N)Úisalnum)Ú.0Úcs     r    Ú	<genexpr>z xlsx_response.<locals>.<genexpr>F   s   è ø€ ÐC™h˜¨!¯)©)¬+¸¸dº”1™hùs   ‚#œ#ÚreportzAapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet)Úcontent_typezattachment; filename="z.xlsx"zContent-Disposition) r   ÚactiveÚtitleÚappendr
   Úfontr   Ú	localtimeÚstrftimeÚlistÚmax_rowÚHEADER_FILLÚHEADER_FONTÚfillr	   Ú	alignmentr!   Ú	enumerateÚmaxÚlenr   ÚminÚcolumn_dimensionsr   ÚwidthÚcellÚfreeze_panesr   ÚsaveÚjoinr   Úgetvalue)Úfilenamer=   ÚheadersÚrowsÚsubtitleÚtotalsÚwbÚwsÚhead_rowrN   r2   ÚvÚiÚhÚrrM   ÚbufÚsafeÚresps                      r    Úxlsx_responserb   (   sG  € ä	‹€BØ	�‰€BØÒ!˜ 3 BÐ'€B„Hà‡I�IˆuˆgÔÜ˜d¨Ô,€B€t�H„MØ‡I�IˆxÒ\˜Z¬×(:Ñ(:Ó(<×(EÑ(EÐFYÓ(ZÐ'[Ð\Ð]Ô^Ø‡I�Iˆb„MØ‡I�IŒd�7‹mÔØ�z‰z€HØ�8”ˆÜ*¬KÐˆŒ	�4”9Ü"¨HÔ5ˆ�ð ó ˆØ
�	‰	¡cÓ*¡c ”6˜!•9 cÑ*Õ+ð áØ
�	‰	¡fÓ-¡f ”6˜!•9 fÑ-Ô.Ø�r—z‘z”NˆDÜ $œˆD�Ið #ô ˜'¨×+‰ˆˆ1Ü”Sœ˜Q›“[�MÀÀdÀsÁÓ$^Á¸AÈqÐSTÉuÔWZÐ[\ÓW]Ë~¤S¬¨Q¨q°1©u©X«Õ%7ÀÑ$^Ñ^Ó_ˆÜ;>¼sÀ5È1Á9ÈbÓ?QÐSUÓ;Vˆ×ÑÔ.¨qÓ1Ñ2Õ8ð ,ð —g‘g (¨Q¡,°q�gÓ9€B„Oä
‹)€CØ‡G�GˆC„LØ�7‰7ÑC™hÓCÓCÒOÀx€DÜØ�‰‹ØXôZ€Dð %;¸4¸&ÀÐ"G€DÐ	ÑØ€Kùò% +ùâ-ùò
 %_s   ÄJ

Ä/JÆ JÆ7Jc                 óŽ   — 	 t        j                  | xs dj                  «       d«      j                  «       S # t        $ r Y y w xY w)Nr4   z%Y-%m-%d)r   ÚstrptimeÚstripÚdater$   r   s    r    Ú
parse_daterg   N   sB   € ðÜ× Ñ  %¢+¨2×!4Ñ!4Ó!6¸
ÓC×HÑHÓJÐJøÜò Ùðús   ‚58 ¸	AÁAc                 ó´   — t        | j                  j                  |«      «      t        | j                  j                  |«      «      }}|r|r	||kD  r||}}||fS )zP(from, to) dates from the query string; either may be None. Swapped if reversed.)rg   ÚGETÚget)ÚrequestÚfrom_keyÚto_keyr.   Úends        r    Ú
date_rangero   U   sN   € ä˜GŸK™KŸO™O¨HÓ5Ó6¼
À7Ç;Á;Ç?Á?ÐSYÓCZÓ8[ˆ3€EÙ‘˜ šØ˜%ˆsˆØ�#ˆ:Ðr"   c                 ó´   — d}| r(|r&d| j                  |«      › d|j                  |«      › �S | rd| j                  |«      › �S |rd|j                  |«      › �S y)Nz%d %b %YzFrom z to zUp to z	All dates)rA   )r.   rn   Úfmts      r    Úrange_labelrr   ]   sj   € Ø
€CÙ‘Ø�u—~‘~ cÓ*Ð+¨4°·±¸SÓ0AÐ/BÐCÐCÙØ�u—~‘~ cÓ*Ð+Ð,Ð,Ù
Ø˜Ÿ™ SÓ)Ð*Ð+Ð+Ør"   )r4   N)Ú	from_dateÚto_date)Ú__doc__r   Údecimalr   Úior   Údjango.httpr   Údjango.utilsr   Úopenpyxlr   Úopenpyxl.stylesr	   r
   r   Úopenpyxl.utilsr   rD   rE   r!   r   rb   rg   ro   rr   © r"   r    Ú<module>r~      s^   ðñõ Ý Ý å $Ý !Ý ß 8Ñ 8Ý ,á˜'¨8Ô4€Ù˜ HÔ-€òòó#òLóór"   