Ë
    4 k–  ã                   óî   — d Z ddlZddlmZmZ ddlmZmZ ddlm	Z	 ddl
mZ ddlmZmZmZmZ  ed«      Z ed	«      Zd
„ Zd„ Zd„ Zd„ Ze	j.                  d„ «       Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zg d¢Z y)a6  
Monthly Chit Fund rules (shared by the admin and staff screens).

Example: Rs 1,00,000 chit, 20 members, Rs 5,000 a month for 20 months.
Every month the pool is collected and one member takes the prize:
  * auction: winner takes chit value - bid discount; the discount minus the
    organiser's commission is shared by all members as a dividend, so that
    month's due for each member is lower
  * lottery / fixed order: winner takes the full chit value, no dividend
Each member can win only once. The admin can override every month's
due amount and prize amount.
é    N)ÚdateÚ	timedelta)ÚROUND_HALF_UPÚDecimal)Útransaction)ÚSum)Ú	ChitGroupÚ
ChitMemberÚChitPaymentÚChitTermÚ0z0.01c                 ó&   — | j                  d¬«      S )Né   ©Úday)Úreplace)Úds    ú?/var/www/html/nexus_chitfund_web/NexusApp/utils/chit_service.pyÚmonth_startr      s   € Ø�9‰9˜ˆ9ÓÐó    c                 ól   — | j                   dz
  |z   }t        | j                  |dz  z   |dz  dz   d«      S )Nr   é   )Úmonthr   Úyear)r   ÚnÚms      r   Ú
add_monthsr      s7   € Ø	�‰�!‰�a‰€AÜ�—‘˜˜b™Ñ  ! b¡&¨1¡*¨aÓ0Ð0r   c           	      óì   — | j                  t        t        |d«      t        j                  | j
                  | j                  «      d   «      ¬«      }|j                  «       dk(  r|t        d¬«      z   S |S )Nr   r   é   )Údays)	r   ÚminÚmaxÚcalendarÚ
monthranger   r   Úweekdayr   )r   Údue_dayr   s      r   Úterm_due_dater'   #   s\   € Ø�‰œ#œc '¨1›o¬x×/BÑ/BÀ5Ç:Á:ÈuÏ{É{Ó/[Ð\]Ñ/^Ó_ˆÓ`€AØ$%§I¡I£K°1Ò$4ˆ1Œy˜aÔ Ñ Ð;¸!Ð;r   c                 óÒ  — t        t        |xs d«      t        «      }| j                  | j                  z  dz  j                  t        t        «      }|dk  r"| j                  t        t        | j                  fS t        ||«      }t        | j                  d«      }||z
  |z  j                  t        t        «      }| j                  |z
  ||t        | j                  |z
  t        «      fS )zL(prize, commission, dividend_per_member, due_per_member) for a bid discount.r   éd   r   )r"   r   ÚZEROÚ
chit_valueÚcommission_percentÚquantizeÚTWOr   Úmonthly_amountr!   Útotal_members)ÚchitÚdiscountÚ
commissionÚmembersÚdividends        r   Úauction_splitr6   (   sÄ   € ä”7˜8š= qÓ)¬4Ó0€HØ—/‘/ D×$;Ñ$;Ñ;¸cÑA×KÑKÌCÔQ^Ó_€JØ�1‚}Ø�‰¤¤d¨D×,?Ñ,?Ð?Ð?Ü�Z Ó*€JÜ�$×$Ñ$ aÓ(€GØ˜JÑ&¨'Ñ1×;Ñ;¼CÄÓO€HØ�?‰?˜XÑ% z°8¼SÀ×ATÑATÐW_ÑA_ÔaeÓ=fÐfÐfr   c           
      ór  — t        | j                  «      }| j                  j                  «       D �ci c]  }|j                  |“Œ }}t        d| j                  dz   «      D ]Ü  }t        ||dz
  «      }|j                  |«      }|€Nt        j                  j                  | ||t        || j                  «      | j                  | j                  ¬«       Œs|j                   |k7  s$|j"                  t        || j                  «      k7  sŒ¦|t        || j                  «      c|_        |_        |j%                  ddg¬«       ŒÞ g }|j'                  «       D ]]  \  }}|| j                  kD  sŒ|j(                  j+                  «       s|j,                  r|j/                  |«       ŒN|j1                  «        Œ_ |S c c}w )a"  
    Make sure the chit has exactly total_months terms with the right months.
    Months / due dates follow start_month + due_day. Amounts the admin already
    set are kept; new terms get the chit's default amounts. Extra terms are
    removed only if nothing was paid or won in them.
    r   )r1   Úterm_nor   Údue_dateÚ
due_amountÚprize_amountr   r9   )Úupdate_fields)r   Ústart_monthÚtermsÚallr8   ÚrangeÚtotal_monthsr   Úgetr   ÚobjectsÚcreater'   r&   r/   r+   r   r9   ÚsaveÚitemsÚpaymentsÚexistsÚ	winner_idÚappendÚdelete)r1   ÚstartÚtÚexistingr   r   Úblockeds          r   Ú
sync_termsrP   4   sn  € ô ˜×(Ñ(Ó)€EØ&*§j¡j§n¡nÔ&6Ó7Ñ&6 �—	‘	˜1‘Ð&6€HÐ7Ü�1�d×'Ñ'¨!Ñ+Ö,ˆÜ˜5 ! a¡%Ó(ˆØ�L‰L˜‹OˆØˆ9Ü×Ñ×#Ñ#Ø 1¨E¼MÈ%ÐQU×Q]ÑQ]Ó<^Ø×.Ñ.¸T¿_¹_ð $õ Nð �W‰W˜Ò §¡¬}¸UÀDÇLÁLÓ/QÓ!QØ"'¬°u¸d¿l¹lÓ)KÐˆAŒG�Q”ZØ�F‰F '¨:Ð!6ˆFÕ7ð -ð €GØ—‘Ö ‰ˆˆ1Øˆt× Ñ Ó Ø�z‰z× Ñ Ô" a§k¢kØ—‘˜qÕ!à—‘•
ð !ð €Nùò% 8s   ²F4c                 ó"  — | j                   dk(  ryt        | j                  «      }t        |«      }||k  ry|j                  |j                  z
  dz  |j                  z   |j                  z
  dz   }|| j
                  kD  rd| j
                  fS d|fS )zL'upcoming' | 'active' | 'completed' | 'closed' and the current month number.Úclosed)rR   N)Úupcomingr   r   r   Ú	completedÚactive)Ústatusr   r=   r   r   rA   )r1   ÚtodayrL   Únowr   s        r   Ú
chit_staterY   R   sŒ   € à‡{�{�hÒØÜ˜×(Ñ(Ó)€EÜ
�eÓ
€CØ
ˆU‚{ØØ	�‰�E—J‘JÑ	 "Ñ$ s§y¡yÑ0°5·;±;Ñ>ÀÑB€AØˆ4×ÑÒØ˜D×-Ñ-Ð-Ð-Ø�Qˆ;Ðr   c                 ó6   — |dkD  r| |k\  ry| dkD  ry||k  rdS dS )Nr   ÚPaidzPartly paidÚOverduezNot paid© )ÚpaidÚduer9   rW   s       r   Úmember_statusr`   `   s.   € Ø
ˆQ‚w�4˜3’;ØØˆa‚xØØ  5Ò(ˆ9Ð8¨jÐ8r   c                 óÖ   — t         j                  j                  | ¬«      j                  dd«      j	                  t        d«      ¬«      }|D �ci c]  }|d   |d   f|d   “Œ c}S c c}w )z$(term_id, member_id) -> amount paid.)Úterm_id__inÚterm_idÚ	member_idÚamount)Úsrf   )r   rC   ÚfilterÚvaluesÚannotater   )Úterm_idsÚrowsÚrs      r   Úpaid_maprm   h   sg   € ä×Ñ×&Ñ&°8Ð&Ó<ß‰V�I˜{Ó+¯H©H´s¸8³}¨HÓ,Eð 	á<@ÓA¹D°qˆQˆy‰\˜1˜[™>Ð*¨A¨c©FÑ2¸DÑAÐAùÒAs   ÁA&c           
      ó²  ‡ ‡— t        |«      }‰ j                  |z  }t        ˆˆ fd„|D «       t        «      }t        ˆˆ fd„|D «       «      }i d‰ j                  “d‰ j
                  “d‰ j                  j                  d«      “d‰ j                  j                  «       “d‰ j                  j                  d	«      “d
‰ j                  j                  «       “dt        ‰ j                  «      “dt        ‰ j                  «      “dt        ‰ j                  «      “dt        ‰ j                  «      “dt        ‰ j                  «      “dt        |«      “dt        |«      “dt        t        ||z
  t        «      «      “d|“d||z
  “d‰ j                   “‰ j"                  r0d‰ j"                  j$                  › d‰ j"                  j&                  › �nd‰ j(                  ‰ j*                  r‰ j*                  j                  «       nd‰ j*                  r‰ j*                  j                  d	«      nd‰ j,                  ‰ j                  |k  t/        |«      ‰ j                  k(  dœ¥S )Nc              3   óv   •K  — | ]0  }‰j                  ‰j                  |j                  ft        «      –— Œ2 y ­w)N)rB   Úidr*   ©Ú.0r   Úpaid_lookupÚterms     €€r   Ú	<genexpr>zterm_summary.<locals>.<genexpr>r   s)   øè ø€ ÐMÁWÀ�[—_‘_ d§g¡g¨q¯t©t _´d×;ÁWùs   ƒ69c              3   ó¨   •K  — | ]I  }‰j                  ‰j                  |j                  ft        «      ‰j                  cxk\  rd kD  sŒCn nd–— ŒK y­w)r   r   N)rB   rp   r*   r:   rq   s     €€r   ru   zterm_summary.<locals>.<genexpr>s   s=   øè ø€ Ðk¡'˜Q¨[¯_©_¸d¿g¹gÀqÇtÁt¸_ÌdÓ-SÐW[×WfÑWfÔ-jÐijÖ-j”q¡'ùs   ƒAAÁ
Arc   r8   r   z%b %YÚ	month_isor9   z%d %b %YÚdue_date_isor:   r;   Úbid_discountÚcommission_amountÚdividend_per_memberÚ	due_totalÚ	collectedÚpendingÚpaid_membersÚunpaid_membersrI   Ú#Ú Ú )ÚwinnerÚclaimedÚclaimed_dateÚclaimed_labelÚnotesÚis_pastÚ
is_current)Úlenr:   Úsumr*   rp   r8   r   ÚstrftimeÚ	isoformatr9   Úfloatr;   ry   rz   r{   r"   rI   r„   Ú	ticket_noÚnamer…   r†   rˆ   r   )rt   r4   rs   rW   Úmember_countr|   r}   r   s   ` `     r   Úterm_summaryr“   o   sF  ù€ Ü�w“<€LØ—‘ ,Ñ.€IÜÔMÁWÓMÌtÓT€IÜÔk¡'ÓkÓk€LðØ�4—7‘7ðà�4—<‘<ðð 	�—‘×$Ñ$ WÓ-ðð 	�T—Z‘Z×)Ñ)Ó+ð	ð
 	�D—M‘M×*Ñ*¨:Ó6ðð 	˜Ÿ™×/Ñ/Ó1ðð 	”e˜DŸO™OÓ,ðð 	œ˜d×/Ñ/Ó0ðð 	œ˜d×/Ñ/Ó0ðð 	œU 4×#9Ñ#9Ó:ðð 	œu T×%=Ñ%=Ó>ðð 	”U˜9Ó%ðð 	”U˜9Ó%ðð 	”5œ˜Y¨Ñ2´DÓ9Ó:ðð 	˜ðð  	˜,¨Ñ5ð!ð" 	�T—^‘^ð#ð$ EIÇKÂK�A�d—k‘k×+Ñ+Ð,¨A¨d¯k©k×.>Ñ.>Ð-?Ñ@ÐUWØ—<‘<Ø9=×9JÒ9J˜×)Ñ)×3Ñ3Ô5ÐPRØCG×CTÒCT˜×*Ñ*×3Ñ3°JÔ?ÐZ\Ø—‘Ø—=‘= 5Ñ(Ü! %Ó(¨D¯J©JÑ6ò1ð r   c           
      ó˜  — | j                   j                  |¬«      j                  «       }t        | j                  j                  «       «      }|€dt        t        t        dœS t        ||t        |j                  g«      |«      }||t        t        |d   «      «      t        t        |d   «      «      t        t        |d   «      «      dœS )z?Cards / list numbers for one chit in a given month (first day).)r   N)rt   r_   r}   r~   r|   r}   r~   )rt   Úsummaryr_   r}   r~   )r>   rg   ÚfirstÚlistr4   r?   r*   r“   rm   rp   r   Ústr)r1   r   rW   rt   r4   rf   s         r   Úchit_month_numbersr™   �   s«   € à�:‰:×Ñ 5ÐÓ)×/Ñ/Ó1€DÜ�4—<‘<×#Ñ#Ó%Ó&€GØ€|Ø¤T¼ÌÑNÐNÜ�T˜7¤H¨d¯g©g¨YÓ$7¸Ó?€AØ Q¬w´s¸1¸[¹>Ó7JÓ/KÜ ¤ Q {¡^Ó!4Ó5Ä'Ì#ÈaÐPYÉlÓJ[ÓB\ñ^ð ^r   c                 ó    — t        | xs d«      S )Nr   )r�   )Úvs    r   Úmoneyrœ   ›   s   € Ü�’�a‹=Ðr   c           	      óÌ   — t         j                  j                  d«      }| j                  j	                  d«      r)ddlm} |j                   |t        | dd«      «      ¬«      }|S )zAAdmin sees every chit; staff only chits of their assigned places.Úplacez/staff/r   )Ústaff_place_idsÚstaffN)Úplace_id__in)	r	   rC   Úselect_relatedÚpathÚ
startswithÚNexusApp.utils.staff_scoperŸ   rg   Úgetattr)ÚrequestÚqsrŸ   s      r   Úchit_queryset_forr©   Ÿ   sP   € ä	×	Ñ	×	)Ñ	)¨'Ó	2€BØ‡|�|×Ñ˜yÔ)Ý>Ø�Y‰Y¡O´G¸GÀWÈdÓ4SÓ$TˆYÓUˆØ€Ir   )r	   r
   r   r   r6   rP   rY   r`   rm   r“   r™   r   r   rœ   r©   )!Ú__doc__r#   Údatetimer   r   Údecimalr   r   Ú	django.dbr   Údjango.db.modelsr   ÚNexusApp.modelsr	   r
   r   r   r*   r.   r   r   r'   r6   ÚatomicrP   rY   r`   rm   r“   r™   rœ   r©   Ú__all__r]   r   r   Ú<module>r²      s�   ðñó ß $ß *å !Ý  ç HÓ Háˆsƒ|€Ùˆfƒo€òò1ò
<ò
	gð ×Ññó ðò:ò9òBòòB^òòò�r   