Ë
    r�ýjr  ã                   ó|   — d Z ddlZddlmZmZ ddlmZ  ed«      ZdZd„ Z	d„ Z
d	„ Zd
„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zy)aK  
Due-date rules shared by every screen (loan reports, overdue, dashboards).

Sundays are holidays: no due ever falls on a Sunday.
  * daily   - dues run Monday..Saturday, Sundays are skipped
  * weekly  - every 7 days from the first due; a Sunday due moves to Monday
  * monthly - same day each month; a Sunday due moves to Monday
é    N)ÚdateÚ	timedelta)ÚDecimalÚ0é   c                 ó0   — | j                  «       t        k(  S ©N)ÚweekdayÚSUNDAY©Úds    ú@/var/www/html/nexus_chitfund_web/NexusApp/utils/loan_schedule.pyÚ	is_sundayr      s   € Ø�9‰9‹;œ&Ñ Ð ó    c                 ó:   — t        | «      r| t        d¬«      z   S | S )Né   ©Údays)r   r   r   s    r   Úskip_sundayr      s   € Ü$-¨a¤Lˆ1Œy˜aÔ Ñ Ð7°aÐ7r   c                 óÊ   — | j                   dz
  |z   }| j                  |dz  z   |dz  dz   }}t        ||t        | j                  t        j                  ||«      d   «      «      S )z:Add whole months to a date; 31 Jan + 1 month -> 28/29 Feb.r   é   )ÚmonthÚyearr   ÚminÚdayÚcalendarÚ
monthrange)r   ÚmonthsÚmr   r   s        r   Ú
add_monthsr       s^   € à	�‰�!‰�fÑ€AØ—&‘&˜1 ™7Ñ" A¨¡F¨Q¡Jˆ%€DÜ��eœS §¡¬×(;Ñ(;¸DÀ%Ó(HÈÑ(KÓLÓMÐMr   c                 óŠ   — t        |d«      \  }}| t        |¬«      z  } |r"| t        d¬«      z  } t        | «      s|dz  }|rŒ"| S )z9Move n working days (Mon-Sat) forward from working day d.r   ©Úweeksr   r   )Údivmodr   r   )r   Únr#   Úrems       r   Úadd_working_daysr'       sN   € ä˜˜1“�J€Eˆ3ØŒ˜Ô	Ñ€AÙ
Ø	ŒY˜AÔÑˆÜ˜Œ|Ø�1‰HˆCò ð €Hr   c                 óš   — |dk(  rt        t        | «      |«      S |dk(  rt        | t        |¬«      z   «      S t        t        | |«      «      S )zGDue date of the (index+1)-th due. index 0 = first due (never a Sunday).ÚdailyÚweeklyr"   )r'   r   r   r    )Ú	first_dueÚpayment_typeÚindexs      r   Únth_due_dater.   +   sK   € à�wÒÜ¤¨IÓ 6¸Ó>Ð>Ø�xÒÜ˜9¤y°uÔ'=Ñ=Ó>Ð>Ü”z )¨UÓ3Ó4Ð4r   c                 óÚ   — || k  ry|| z
  j                   dz   }t        |d«      \  }}|dz  }| t        |¬«      z   }t        |«      D ]!  }t	        |«      s|dz  }|t        d¬«      z  }Œ# |S )z?Number of non-Sunday days in [start, end] (0 when end < start).r   r   é   r   r"   r   )r   r$   r   Úranger   )ÚstartÚendÚtotalr#   r&   Úcountr   Ú_s           r   Úworking_days_betweenr7   4   s|   € à
ˆU‚{ØØ�5‰[×Ñ Ñ"€EÜ˜˜qÓ!�J€Eˆ3Ø�A‰I€EØ”	 Ô&Ñ&€AÜ�3ŽZˆÜ˜Œ|Ø�Q‰JˆEØ	ŒY˜AÔÑ‰ð ð €Lr   c                 óâ   — d}|| j                   k  r]t        | j                  | j                  |«      |k  r9|dz  }|| j                   k  r%t        | j                  | j                  |«      |k  rŒ9|S )z3How many dues have fallen due on or before `today`.r   r   )Únumber_of_duesr.   Úfirst_due_dater,   )ÚloanÚtodayr%   s      r   Údues_elapsedr=   C   sm   € à	€AØ
ˆd×!Ñ!Ò
!Ü˜×,Ñ,¨d×.?Ñ.?ÀÓCÀuÒLØ	ˆQ‰ˆð ˆd×!Ñ!Ò
!Ü˜×,Ñ,¨d×.?Ñ.?ÀÓCÀuÓLà€Hr   c                 ór   — t        | j                  | j                  t        | j                  dz
  d«      «      S )Nr   r   )r.   r:   r,   Úmaxr9   )r;   s    r   Úlast_due_dater@   L   s1   € Ü˜×+Ñ+¨T×->Ñ->ÄÀD×DWÑDWÐZ[ÑD[Ð]^Ó@_Ó`Ð`r   c                 óŽ  — | j                   xs t        }|xs t        }t        | j                  |z
  t        «      }| j                  dk(  xs |dk  }|dkD  r"t        t        ||z  «      | j                  «      nd}|r*dd|dk  r| j                  n|d|dt        t        | |«      dœS t        | j                  | j                  |«      }t        | |«      }t        |t        | |t        d¬«      z
  «      z  | j                  «      }	t        |	|z
  t        «      }
||k  rd	}n
||k(  rd
}nd}||k  rt        ||«      nd}d||||||
|dœS )aÖ  
    Everything the reports need about where a loan stands today.

      paid_dues     dues fully covered by the money paid so far
      next_due      first due that is not fully covered (None when completed)
      balance       total payable - paid
      pending_days  working days (no Sundays) from the first unpaid due up to
                    today, i.e. days the customer has not paid
      overdue       amount that should have been paid by today but was not
    Ú	completedr   TÚ	CompletedN)rB   ÚstatusÚ	paid_duesÚnext_dueÚbalanceÚpending_daysÚoverdueÚelapsedr   r   ÚOverduez	Due TodayzIn-TimeF)Ú
due_amountÚZEROr?   Útotal_payablerD   r   Úintr9   r=   r.   r:   r,   r   r7   )r;   Úpaidr<   ÚduerG   rB   rE   rF   rJ   Úshould_have_paidrI   rD   rH   s                r   Úloan_positionrS   P   sc  € ð �/‰/Ò
!œT€CØŠ<”4€DÜ�$×$Ñ$ tÑ+¬TÓ2€GØ—‘˜{Ñ*Ò:¨g¸©l€Ià>AÀAºg””C˜ ™Ó$ d×&9Ñ&9Ô:È1€IÙà¨Ø˜!Š|ð DH×CVÒCVØ!*¸ÈØ¬$¼<ÈÈeÓ;Tñ
ð 	
ô ˜D×/Ñ/°×1BÑ1BÀIÓN€HÜ˜4 Ó'€Gä˜3¤¨d°E¼IÈ1Ô<MÑ4MÓ!NÑNÐPT×PbÑPbÓcÐÜÐ" TÑ)¬4Ó0€Gà�%ÒØ‰Ø	�UÒ	Ø‰àˆð =EÈÒ<MÔ'¨°%Ô8ÐST€Lð  f¸9Ø¨À,Ø wñð r   c                 óD  ‡‡‡‡— | j                   xs t        }ˆfd„}ˆfd„}t        | j                  «      D �cg c]#  }t	        | j
                  | j                  |«      ‘Œ% }}t        | j
                  g|D �	cg c]  }	|	j                  ‘Œ c}	z   «      }
 ||
«      Št        t        ‰t        | «      «      g|D �	cg c]  }	|	j                  ‘Œ c}	z   «      }g t        t        }}}‰|k  �r– |‰«      }|t        d¬«      z
  Št        ˆˆˆfd„|D «       «      }t        ||z  t        | j                  |z
  t        «      «      }t        ˆˆfd„|D «       t        «      }||kD  }||z  }||z  }t        ||z
  t        «      }|s|s|ŠŒ |dkD  r||k\  rdn|dkD  rd	nd
}n|rdnd}‰dk(  r3‰j                  d«      › d‰t        d¬«      z   j                  d«      › �}n‰j                  d«      }|j                  ||t!        |«      t!        |«      t!        t        ||z
  t        «      «      t!        t        ||z
  t        «      «      t!        |«      t!        t        | j                  |z
  t        «      «      |dœ	«       |Š‰|k  r�Œ–|j#                  «        |S c c}w c c}	w c c}	w )z“
    Week-by-week (Mon-Sat) or month-by-month view of one loan:
    what fell due in the period, what was paid in it, and the running balance.
    c                 ól   •— ‰dk(  r| t        | j                  «       ¬«      z
  S | j                  d¬«      S )Nr*   r   r   )r   )r   r
   Úreplace)r   Úperiods    €r   Úperiod_startz#period_report.<locals>.period_start†   s2   ø€ Ø�XÒØ”y a§i¡i£kÔ2Ñ2Ð2Ø�y‰y˜QˆyÓÐr   c                 óD   •— ‰dk(  r| t        d¬«      z   S t        | d«      S )Nr*   r   r"   )r   r    )ÚsrW   s    €r   Ú
next_startz!period_report.<locals>.next_start‹   s&   ø€ Ø)/°8Ò);ˆq”9 1Ô%Ñ%ÐQÄÈAÈqÓAQÐQr   r   r   c              3   óL   •K  — | ]  }‰|cxk  r‰k  sŒn n
|‰k  sŒd –— Œ y­w)r   N© )Ú.0r   Ú
period_endr2   r<   s     €€€r   Ú	<genexpr>z period_report.<locals>.<genexpr>™   s%   øè ø€ ÐV¡˜A¨e°qÔ.F¸JÖ.FÈ1ÐPUË:”a¡ùs   ƒ$”$�$c              3   óh   •K  — | ])  }‰|j                   cxk  r‰k  sŒn n|j                  –— Œ+ y ­wr	   )Úpayment_dateÚamount)r^   Úpr_   r2   s     €€r   r`   z period_report.<locals>.<genexpr>›   s&   øè ø€ ÐX¡h °%¸1¿>¹>Ô2WÈZÖ2W�A—H•H¡hùs   ƒ2ž2r   ÚPaidzPartly paidzNot paidzArrears paidÚAdvancer*   z%d %bz - é   z%d %b %Yz%B %Y)	rW   ÚduesÚexpectedrP   ÚpendingÚextraÚ	shortfallrG   rD   )rL   rM   r1   r9   r.   r:   r,   r   rb   r?   r@   r   ÚsumrN   ÚstrftimeÚappendÚfloatÚreverse)r;   Úpaymentsr<   rW   rQ   rX   r[   ÚiÚ	due_datesrd   ÚfirstÚstopÚrowsÚexpected_totalÚ
paid_totalÚnxtÚdues_inri   rP   Úbehind_beforerl   rD   Úlabelr_   r2   s     ``                   @@r   Úperiod_reportr~      sƒ  û€ ð
 �/‰/Ò
!œT€Cô ô
Rô   × 3Ñ 3Ô4ó6Ù4�Qô ˜d×1Ñ1°4×3DÑ3DÀaÕHØ4ð ð 6ä�×$Ñ$Ð%ÁÓ(JÁ¸A¨¯«ÀÑ(JÑJÓK€EÙ˜Ó€Eä”�Eœ=¨Ó.Ó/Ð0ÉHÓ3UÉHÀq°A·N³NÈHÑ3UÑUÓV€Dà')¬4´˜*ˆ.€DØ
�4‹-Ù˜ÓˆØœ9¨!Ô,Ñ,ˆ
ÜÕV¡ÓVÓVˆÜ�s˜W‘}¤c¨$×*<Ñ*<¸~Ñ*MÌtÓ&TÓUˆÜÔX¡hÓXÔZ^Ó_ˆØ&¨Ñ3ˆØ˜(Ñ"ˆØ�dÑˆ
Ü˜¨Ñ3´TÓ:ˆ	Ù™tØˆEØØ�aŠ<Ø# xÒ/‘VÀtÈaÂx±mÐU_‰Fá'4‘^¸)ˆFØ�XÒØ—~‘~ gÓ.Ð/¨s°E¼IÈ1Ô<MÑ4M×3WÑ3WÐXbÓ3cÐ2dÐe‰Eà—N‘N 7Ó+ˆEØ�‰ØØÜ˜h›Ü˜$“KÜœS ¨D¡´$Ó7Ó8Üœ3˜t h™´Ó5Ó6Ü˜yÓ)ÜœS ×!3Ñ!3°jÑ!@Ä$ÓGÓHØñ

ô 
	ð ˆðA �4Œ-ðB 	‡L�L„NØ€KùòU6ùâ(Jùò 4Vs   º(JÁ9J
Â;J
)Ú__doc__r   Údatetimer   r   Údecimalr   rM   r   r   r   r    r'   r.   r7   r=   r@   rS   r~   r]   r   r   Ú<module>r‚      sX   ðñó ß $Ý áˆsƒ|€Ø	
€ò!ò8òNòò5òòòaò,ó^9r   