Ë
    ‡Œýjì	  ã                   ó|   — d 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
  edd¬«      Z ed	«      Zd
„ Zd„ Zd„ Zd„ Zy)zGShared loan maths used by both dashboards (same rules as Loan Reports).é    )ÚDecimal)ÚDecimalFieldÚSumÚValue)ÚCoalesce)Úloan_positioné   é   )Ú
max_digitsÚdecimal_placesÚ0c                 ój   — | j                  t        t        d«      t        d«      t        ¬«      ¬«      S )NÚpayments__amountr   )Úoutput_field)Úpaid)Úannotater   r   r   ÚMONEY)Úqss    ú=/var/www/html/nexus_chitfund_web/NexusApp/utils/loan_stats.pyÚ	with_paidr      s.   € Ø�;‰;Ü”cÐ,Ó-¬u°Q«xÄeÔLð ó ð ó    c                 ój   — t        | | j                  |«      }|d   |d   |d   dk(  r|d   fS t        fS )zEReturn (status, next_due_date, overdue_amount) for an annotated loan.ÚstatusÚnext_dueÚOverdueÚoverdue)r   r   ÚZERO)ÚloanÚtodayÚposs      r   Úloan_due_stater!      sA   € ä
˜˜dŸi™i¨Ó
/€CØˆx‰=˜#˜j™/¸SÀ¹]ÈiÒ=W¨3¨y©>ÐaÐaÔ]aÐaÐar   c           
      óâ  — dddt         dddt         t         dœ	}t        «       }t        | j                  «       «      D ]Ù  }|dxx   |j                  z  cc<   |dxx   |j
                  xs t         z  cc<   t        ||«      \  }}}|dk(  r|dxx   dz  cc<   Œ\|dxx   dz  cc<   |d	k(  r6|d
xx   dz  cc<   |dxx   |z  cc<   |j                  |j                  «       Œ¤|dk(  r|dxx   dz  cc<   Œ·|sŒº||z
  j                  dk  sŒÍ|dxx   dz  cc<   ŒÛ t        |«      |d<   t        |d   |d   z
  t         «      |d<   |d   dkD  r t        t        |d   dz  |d   z  «      «      nd|d<   |S )z;Counts / amounts for a set of loans (any queryset of Loan).r   )	Úactive_loansÚcompleted_loansÚoverdue_loansÚoverdue_amountÚoverdue_customersÚ	due_todayÚupcoming_duesÚpayabler   r*   r   Ú	Completedr$   é   r#   r   r%   r&   z	Due Todayr(   é   r)   r'   Úpendingéd   Úrecovery_rate)r   Úsetr   Úorder_byÚtotal_payabler   r!   ÚaddÚcustomer_idÚdaysÚlenÚmaxÚintÚround)Úloans_qsr   Úsummaryr'   r   r   r   r&   s           r   Úportfolio_summaryr=      sœ  € ð ¨aØ¬dÈØ¨Ü¤ñ	€Gô ›ÐÜ˜(×+Ñ+Ó-Ö.ˆØ�	Ó˜d×0Ñ0Ñ0ÓØ�‹˜4Ÿ9™9Ò,¬Ñ,‹Ü+9¸$ÀÓ+FÑ(ˆ�˜.Ø�[Ò ØÐ%Ó&¨!Ñ+Ó&ØØ�Ó 1Ñ$ÓØ�YÒØ�OÓ$¨Ñ)Ó$ØÐ$Ó%¨Ñ7Ó%Ø×!Ñ! $×"2Ñ"2Õ3Ø�{Ò"Ø�KÓ  AÑ%Ô Ú˜8 eÑ+×1Ñ1°QÓ6Ø�OÓ$¨Ñ)Ô$ð /ô  $'Ð'8Ó#9€GÐÑ Ü˜W YÑ/°'¸&±/ÑAÄ4ÓH€GˆIÑàBIÈ)ÑBTÐWXÒBXŒŒE�'˜&‘/ CÑ'¨'°)Ñ*<Ñ<Ó=Ô>Ð^_ð ˆOÑð €Nr   c                 ó&  — ddl }t        t        t        | xs d«      «      j	                  t        d«      «      «      }|dk  rdnd}t        t        |«      «      }t        |«      dkD  r%|dd |dd }}|j                  dd	|«      }|d
z   |z   }||z   S )zA12345678.5 -> '1,23,45,679' (Indian digit grouping, no decimals).r   NÚ1Ú-Ú é   éýÿÿÿz(\d)(?=(\d\d)+$)z\1,Ú,)Úrer9   r   ÚstrÚquantizeÚabsr7   Úsub)ÚvaluerE   ÚnÚsignÚsÚheadÚtails          r   ÚinrrP   :   s�   € ãÜŒG”C˜š
 “OÓ$×-Ñ-¬g°c«lÓ;Ó<€AØ�a’%‰3˜R€DÜŒC�‹F‹€AÜ
ˆ1ƒv�‚zØ�s˜�V˜Q˜r˜s˜VˆdˆØ�v‰vÐ)¨6°4Ó8ˆØ�3‰J˜ÑˆØ�!‰8€Or   N)Ú__doc__Údecimalr   Údjango.db.modelsr   r   r   Údjango.db.models.functionsr   ÚNexusApp.utils.loan_scheduler   r   r   r   r!   r=   rP   © r   r   Ú<module>rW      sB   ðÙ MÝ ç 5Ñ 5Ý /å 6á °1Ô5€Ùˆsƒ|€òòbòóB
r   