Ë
    ´ k„  ã                   óB  — d Z ddlZddlmZ ddlmZmZ ddlm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 ddlmZ ddlmZmZmZmZmZ ddlmZmZmZm Z m!Z!m"Z"m#Z#m$Z$m%Z%m&Z& ddl'm(Z(  ejR                  e*«      Z+ ed«      Z,d„ Z-d„ Z.d8d„Z/d„ Z0d9d„Z1d:d„Z2d„ Z3d„ Z4d„ Z5d„ Z6d„ Z7d„ Z8ddddd œZ9d!„ Z:d"„ Z;d#„ Z<d$„ Z=d%„ Z>d&„ Z?d;d'„Z@d(„ ZAed)„ «       ZBed*„ «       ZCd+„ ZDd,„ ZEd-„ ZFed.„ «       ZGed/„ «       ZHd0„ ZIed1„ «       ZJed2„ «       ZKed3„ «       ZLd4„ ZMd5„ ZNd6„ ZOd7„ ZPy)<a–  
Monthly Chit Fund screens for both panels.

Admin: full control (chits, months/terms, members, winners, payments).
Staff: chits of their assigned places only; can view and record payments.

Pages
  chit_list        /<panel>/monthlychitfund/
  chit_detail      /<panel>/monthlychitfund/<id>/
  chit_reports     /<panel>/chit_reports/
JSON / actions are listed in NexusApp/urls.py (names start with chit_).
é    N)Údatetime)ÚDecimalÚInvalidOperation)Útransaction)ÚQÚSum)ÚHttp404ÚJsonResponse)Úrender)Úreverse)Útimezone)Úrequire_POST)Ú	ChitGroupÚ
ChitMemberÚChitPaymentÚChitTermÚPlace)
ÚZEROÚ
add_monthsÚauction_splitÚchit_queryset_forÚ
chit_stateÚmember_statusÚmonth_startÚpaid_mapÚ
sync_termsÚterm_summary)Úxlsx_responseÚ999999999999c                 ó@   — | j                   j                  d«      rdS dS )Nz/staff/ÚstaffÚadmin)ÚpathÚ
startswith©Úrequests    ú>/var/www/html/nexus_chitfund_web/controllers/ChitController.pyÚ_panelr(   %   s   € Ø—l‘l×-Ñ-¨iÔ8ˆ7ÐE¸gÐEó    c                 ó   — t        | «      dk(  S )Nr"   )r(   r%   s    r'   Ú	_is_adminr+   )   s   € Ü�'‹?˜gÑ%Ð%r)   c                 ó,   — t        d| |xs i dœ|¬«      S )NÚerror)ÚstatusÚmessageÚerrors)r.   ©r
   )r/   r.   r0   s      r'   Ú_errr2   -   s   € Ü 7°wÈ&Ê,ÐTVÑWÐ`fÔgÐgr)   c                 ó"   — t        d| dœ|¥«      S )NÚsuccess)r.   r/   r1   )r/   Úextras     r'   Ú_okr6   1   s   € Ü 9¸ÑJÀEÐJÓKÐKr)   c                 óþ   — 	 t        t        | «      j                  «       «      }|j                  «       r|dk  s|dk(  r|r	|t        kD  ry ||j                  t        d«      «      k7  ry |S # t        t        f$ r Y y w xY w)Nr   z0.01)r   ÚstrÚstripr   ÚAttributeErrorÚ	is_finiteÚ	MAX_MONEYÚquantize)ÚrawÚ
allow_zeroÚvs      r'   Ú_moneyrA   5   st   € ðÜ”C˜“H—N‘NÓ$Ó%ˆð �;‰;Œ=˜A šE a¨1¢f±ZÀAÌ	ÂMØØˆA�J‰J”w˜v“Ó'Ò'ØØ€Høô œnÐ-ò Ùðús   ‚"A* Á*A<Á;A<c                 ó’   — 	 t        t        | «      j                  «       «      }||cxk  r|k  r|S  d S # t        t        f$ r Y y w xY w©N)Úintr8   r9   Ú	TypeErrorÚ
ValueError)r>   ÚloÚhir@   s       r'   Ú_intrI   A   sN   € ðÜ”�C“—‘Ó Ó!ˆð �a”˜2’ˆ1Ð'� 4Ð'øô ”zÐ"ò Ùðús   ‚"4 ´AÁAc                 óŽ   — 	 t        j                  | xs dj                  «       d«      j                  «       S # t        $ r Y y w xY w)NÚ ú%Y-%m-%d)r   Ústrptimer9   ÚdaterF   )r>   s    r'   Ú_daterO   I   sB   € ðÜ× Ñ  #¢)¨×!2Ñ!2Ó!4°jÓA×FÑFÓHÐHøÜò Ùðús   ‚58 ¸	AÁAc                 óÄ   — | xs dj                  «       } dD ]8  }	 t        j                  | |«      j                  «       j	                  d¬«      c S  y# t
        $ r Y ŒGw xY w)z/'2026-11' or '2026-11-05' -> date(2026, 11, 1).rK   )ú%Y-%mrL   é   )ÚdayN)r9   r   rM   rN   ÚreplacerF   )r>   Úfmts     r'   Ú_monthrV   P   sf   € àŠ9�"×
Ñ
Ó
€CÛ$ˆð	Ü×$Ñ$ S¨#Ó.×3Ñ3Ó5×=Ñ=À!Ð=ÓDÒDð %ð
 øô ò 	Ùð	ús   ›3AÁ	AÁAc                 ór   — t        | «      j                  |¬«      j                  «       }|€t        d«      ‚|S )N©ÚpkúChit not found)r   ÚfilterÚfirstr	   ©r&   Úchit_idÚchits      r'   Ú	_get_chitr`   [   s9   € Ü˜WÓ%×,Ñ,°Ð,Ó8×>Ñ>Ó@€DØ€|ÜÐ&Ó'Ð'Ø€Kr)   c                 ó�   — t        | «      rt        j                  j                  d«      S ddlm}  || «      j                  d«      S )NÚnamer   )Ústaff_places)r+   r   ÚobjectsÚorder_byÚNexusApp.utils.staff_scoperc   )r&   rc   s     r'   Ú_places_forrg   b   s8   € Ü�ÔÜ�}‰}×%Ñ% fÓ-Ð-Ý7Ù˜Ó ×)Ñ)¨&Ó1Ð1r)   c           	      ó€   — t        | «      }g d¢}|dk(  r|g d¢z  }|D �ci c]  }|t        |› d|› �«      “Œ c}S c c}w )N)Ú	chit_listÚchit_list_dataÚchit_list_exportÚchit_detail_dataÚchit_payÚchit_reportsÚchit_reports_dataÚchit_reports_exportr"   )Úchit_newÚ	chit_saveÚchit_deleteÚchit_member_saveÚchit_member_deleteÚchit_term_saveÚchit_payment_deleteÚchit_auction_previewÚ:)r(   r   )r&   ÚnsÚnamesÚns       r'   Ú_urlsr}   i   sW   € Ü	�‹€BòI€Eà	ˆW‚}Øò Sñ 	Sˆá-2Ó3©U¨ˆAŒw˜"˜˜Q˜q˜c�{Ó#Ñ#¨UÑ3Ð3ùÒ3s    ;c                 ób   — t        | «      › d�t        | «      t        | «      t        | «      dœ|¥S )Nzpanel/base.html)Úbase_templateÚis_adminÚpanelÚ	chit_urls)r(   r+   r}   )r&   r5   s     r'   Ú_ctxrƒ   s   s;   € ä" 7›OÐ,¨OÐ<Ü˜gÓ&Ü˜“Ü˜7“^ñ	ð
 ðð r)   ÚUpcomingÚActiveÚ	CompletedÚClosed)ÚupcomingÚactiveÚ	completedÚclosedc                 óN  ‡— t        | |«      \  }}|j                  | j                  g «      }t        ˆfd„|j                  | j                  g «      D «       d «      }	|	rt	        |	|||«      nd }
t        d„ |j                  | j                  g «      D «       «      }i d| j                  “d| j                  “dt        | j                  «      “d| j                  “dt        |«      “d| j                  “d	t        | j                  «      “d
| j                  “d| j                  r| j                  j                  nd“dt        |   “d|xs d“d| j                  r(t!        t#        |xs ddz  | j                  z  «      «      nd“d|“d|
“d| j$                  j'                  d«      “dd“S )Nc              3   óB   •K  — | ]  }|j                   ‰k(  sŒ|–— Œ y ­wrC   )Úmonth)Ú.0ÚtrŽ   s     €r'   Ú	<genexpr>z_chit_row.<locals>.<genexpr>ƒ   s   øè ø€ ÐOÑ:�q¸a¿g¹gÈÓ>N”Ñ:ùó   ƒ˜c              3   ó:   K  — | ]  }|j                   sŒd –— Œ y­w)rR   N)Ú	winner_id©r�   r�   s     r'   r‘   z_chit_row.<locals>.<genexpr>…   s   è ø€ ÐKÑ;˜¸q¿{»{”!Ñ;ùs   ‚”Úidrb   Ú
chit_valueÚtotal_membersÚmember_countÚtotal_monthsÚmonthly_amountÚdue_dayÚplaceÚ-ÚstateÚcurrent_monthr   Úprogress_pctéd   Úclaimed_countÚ
this_monthÚstart_monthú%b %YÚ
detail_urlrK   )r   Úgetr–   Únextr   Úsumrb   Úfloatr—   r˜   Úlenrš   r›   rœ   r�   ÚSTATE_LABELrD   Úroundr¥   Ústrftime)r_   rŽ   ÚtodayÚmembers_by_chitÚterms_by_chitÚpaidrŸ   ÚcurrentÚmembersÚtermÚsÚclaimeds    `          r'   Ú	_chit_rowr¹   €   sÌ  ø€ Ü  eÓ,�N€Eˆ7Ø×!Ñ! $§'¡'¨2Ó.€GÜÓO˜M×-Ñ-¨d¯g©g°rÔ:ÓOÐQUÓV€DÙ48Œ�T˜7 D¨%Ô0¸d€AÜÑK˜]×.Ñ.¨t¯w©w¸Ô;ÓKÓK€GðØˆd�g‰gðà�—	‘	ðð 	”e˜DŸO™OÓ,ðð 	˜×+Ñ+ð	ð
 	œ˜G›ðð 	˜×)Ñ)ðð 	œ% × 3Ñ 3Ó4ðð 	�4—<‘<ðð 	 D§J¢J�—‘—’°Cðð 	”˜UÑ#ðð 	˜š Aðð 	ÐPT×PaÒPaœœE 7¢<¨a°3Ñ"6¸×9JÑ9JÑ"JÓKÔLÐghðð 	˜ðð 	�aðð 	�t×'Ñ'×0Ñ0°Ó9ðð  	�bð!ð r)   c                 ó.  — | D �cg c]  }|j                   ‘Œ }}i i }}t        j                  j                  |¬«      D ]-  }|j	                  |j
                  g «      j                  |«       Œ/ t        j                  j                  |¬«      j                  d«      D ]-  }|j	                  |j
                  g «      j                  |«       Œ/ t        |j                  «       D ��cg c]  }|D ]  }|j                   ‘Œ Œ c}}«      }|||fS c c}w c c}}w )N)Úchit_id__inÚwinner)r–   r   rd   r[   Ú
setdefaultr^   Úappendr   Úselect_relatedr   Úvalues)	ÚchitsÚcÚidsr±   r²   Úmr�   Útsr³   s	            r'   Ú_loadrÆ   š   sñ   € ÙÓ
™�Aˆ1�4‹4˜€CÐ
Ø%'¨�]€OÜ×Ñ×&Ñ&°3Ð&Ö7ˆØ×"Ñ" 1§9¡9¨bÓ1×8Ñ8¸Õ;ð 8ä×Ñ×$Ñ$°Ð$Ó5×DÑDÀXÖNˆØ× Ñ  §¡¨BÓ/×6Ñ6°qÕ9ð Oä M×$8Ñ$8Ô$:ÔGÑ$:˜bÃB¸q�Q—T“TÀB�TÐ$:ÒGÓH€DØ˜M¨4Ð/Ð/ùò  ùó Hs   …DÃ%D
c           
      ót   — t        | dt        | t        j                  «       j	                  d«      ¬«      «      S )Nzchit/chit_list.htmlrQ   )r¤   )r   rƒ   r   Ú	localdater¯   r%   s    r'   ri   ri   ¦   s7   € Ü�'Ð0´$ØœH×.Ñ.Ó0×9Ñ9¸'ÓBô3Dó Eð Er)   c           	      óž  — t        j                  «       }t        | j                  j	                  d«      «      xs t        |«      }| j                  j	                  dd«      j                  «       }| j                  j	                  dd«      j                  «       j                  «       }t        t        | «      «      }t        |«      \  }}}g }	|D ]J  }
t        |
|||||«      }t        t        | «      › d�|
j                  g¬«      |d<   |	j                  |«       ŒL t!        d„ |	D «       «      t!        d	„ |	D «       «      t!        d
„ |	D «       «      dœ}t#        |d   |d   z
  d«      |d<   |r|	D �cg c]  }|d   |k(  sŒ|‘Œ }	}|r:|	D �cg c]/  }||d   j                  «       v s||d   j                  «       v sŒ.|‘Œ1 }	}||	|fS c c}w c c}w )NrŽ   r.   rK   Úsearchz
:chit_view©Úargsr§   c              3   ó2   K  — | ]  }|d    dk(  sŒd–— Œ y­w)rŸ   r…   rR   N© ©r�   Úrs     r'   r‘   z_list_rows.<locals>.<genexpr>¹   s   è ø€ Ð@¡˜A¨¨7©°xÓ)?”a¡ùs   ‚�c              3   ó8   K  — | ]  }|d    sŒ	|d    d   –— Œ y­w)r¤   Ú	due_totalNrÎ   rÏ   s     r'   r‘   z_list_rows.<locals>.<genexpr>º   s    è ø€ ÐQ¹°AÀÀ<Ã�1�\‘? ;Õ/¹ùó   ‚
�c              3   ó8   K  — | ]  }|d    sŒ	|d    d   –— Œ y­w)r¤   Ú	collectedNrÎ   rÏ   s     r'   r‘   z_list_rows.<locals>.<genexpr>»   s    è ø€ ÐW¹t¸!ÀqÈÃ˜˜<™¨Õ5¹tùrÓ   )r‰   ÚduerÕ   rÖ   rÕ   r   ÚpendingrŸ   rb   r�   )r   rÈ   rV   ÚGETr¨   r   r9   ÚlowerÚlistr   rÆ   r¹   r   r(   r–   r¾   rª   Úmax)r&   r°   rŽ   r.   rÊ   rÁ   r±   r²   r³   Úrowsr_   ÚrowÚcardsrÐ   s                 r'   Ú
_list_rowsrß   «   s®  € Ü×ÑÓ €EÜ�7—;‘;—?‘? 7Ó+Ó,ÒB´¸EÓ0B€EØ�[‰[�_‰_˜X rÓ*×0Ñ0Ó2€FØ�[‰[�_‰_˜X rÓ*×0Ñ0Ó2×8Ñ8Ó:€FäÔ" 7Ó+Ó,€EÜ+0°«<Ñ(€O�] DØ€DÛˆÜ˜˜e U¨O¸]ÈDÓQˆÜ#¤v¨g£Ð&7°zÐ$BÈ$Ï'É'ÈÔSˆˆLÑØ�‰�CÕð ô
 Ñ@¡Ó@Ó@ÜÑQ¹ÓQÓQÜÑW¹tÓWÓWñ€Eô
 ˜5 ™<¨%°Ñ*<Ñ<¸aÓ@€Eˆ)ÑÙÙÓ8™4�a 1 W¡:°Ó#7’˜4ˆÐ8ÙÙÓ_™4�a 6¨Q¨v©Y¯_©_Ó->Ñ#>À&ÈAÈgÉJ×L\ÑL\ÓL^ÒB^’˜4ˆÐ_Ø�$˜ÐÐùò 9ùâ_s   Å0GÅ>GÆ
/G
Æ:G
c                 ó\   — t        | «      \  }}}t        |j                  d«      ||dœ«      S )Nú%B %Y)rŽ   rÞ   Údata)rß   r
   r¯   )r&   rŽ   rÜ   rÞ   s       r'   rj   rj   Å   s/   € Ü# GÓ,Ñ€Eˆ4�Ü %§.¡.°Ó"9ÀEÐSWÑXÓYÐYr)   c                 óî  — t        | «      \  }}}g }t        |d«      D ]Œ  \  }}|d   xs i }|j                  ||d   |d   |d   |d   |d   |d   |d	   › d
|d   › �|j                  dd«      |j                  dd«      |j                  dd«      |j                  dd«      |d   g«       ŒŽ t	        d|j                  d«      › �dg d¢||j                  d«      dddddddd|d   |d   |d   ddg¬«      S )NrR   r¤   rb   r�   r—   r™   rš   r›   r    z of rÒ   r   rÕ   r×   r¼   rK   rŸ   Úmonthly_chits_ú%Y_%mzMonthly Chit Fund)úS.NoÚChitr   z
Chit ValueÚMembersÚMonthszMonthly AmountÚProgresszDue This MonthÚ	CollectedÚPendingÚWinnerÚStatusrá   ÚTotalrÖ   ©ÚsubtitleÚtotals)rß   Ú	enumerater¾   r¨   r   r¯   )r&   rŽ   rÜ   rÞ   ÚoutÚirÐ   Útms           r'   rk   rk   Ê   s;  € Ü# GÓ,Ñ€Eˆ4�Ø
€CÜ˜$ Ö"‰ˆˆ1Øˆ|‰_Ò" ˆØ�
‰
�A�q˜‘y ! G¡*¨a°©o¸qÀÑ?PÐRSÐTbÑRcØÐ&Ñ'¨A¨oÑ,>Ð+?¸tÀAÀnÑDUÐCVÐ)WØ—F‘F˜;¨Ó*¨B¯F©F°;ÀÓ,BÀBÇFÁFÈ9ÐVWÓDXØ—F‘F˜8 RÓ(¨!¨G©*ð6õ 	7ð #ô Ø
˜Ÿ™¨Ó0Ð1Ð2Ð4Gò	Gà�e—n‘n WÓ-Ø�G˜R  R¨¨R°°U¸5±\À5ÈÑCUÐW\Ð]fÑWgÐikÐmoÐpôrð rr)   c                 óD  — |r.t         j                  j                  |¬«      j                  «       nd}|r|€t	        d«      ‚d}|�r®t        t        j                  j                  |¬«      j                  dd¬«      «      }t        t        j                  j                  |d¬	«      j                  d
d¬«      «      }t        t        j                  j                  |¬«      j                  dd¬«      «      }i t        |«      ¥|j                  j                  «       D �cg c]d  }|j                  |j                  |j                  |j                  |j                   |j"                  |j                  |v xs |j                  |v dœ‘Œf c}|j$                  j                  «       D �cg c]E  }|j&                  t)        |j*                  «      t)        |j,                  «      |j                  |v dœ‘ŒG c}dœ¥}t/        | dt1        | ||t3        | «      ¬«      «      S c c}w c c}w )zWFull page: chit details + one row per member + one row per month (due / winner amount).rX   NrZ   ©Ú
term__chitÚ	member_idT©ÚflatF)r_   Úwinner__isnullr”   Úterm_id)r–   Ú	ticket_norb   ÚphoneÚaddressÚaadhaar_numberÚlocked)Úterm_noÚ
due_amountÚprize_amountÚhas_payments)rµ   Útermszchit/chit_form.html)r_   ÚinitialÚplaces)r   rd   r[   r\   r	   Úsetr   Úvalues_listr   Ú
_chit_jsonrµ   Úallr–   rÿ   rb   r   r  r  r  r  r«   r  r  r   rƒ   rg   )	r&   r^   r_   r	  Úpaid_membersÚwonÚ
terms_paidrÄ   r�   s	            r'   Ú	chit_formr  Ü   sî  € á;BŒ9×Ñ×#Ñ# wÐ#Ó/×5Ñ5Ô7È€DÙ�4�<ÜÐ&Ó'Ð'Ø€GÚÜœ;×.Ñ.×5Ñ5ÀÐ5ÓF×RÑRÐS^ÐeiÐRÓjÓkˆÜ”(×"Ñ"×)Ñ)¨tÀEÐ)ÓJ×VÑVÐWbÐimÐVÓnÓoˆÜœ×,Ñ,×3Ñ3¸tÐ3ÓD×PÑPÐQZÐaeÐPÓfÓgˆ
ð	
Ü˜Óð	
ð
 "&§¡×!1Ñ!1Ô!3ó5ñ "4˜Að  !Ÿt™t°!·+±+ÀqÇvÁvÐXY×X_ÑX_Ø$%§I¡IÀ×AQÑAQØ#$§4¡4¨<Ð#7Ò#F¸1¿4¹4À3¸;óHð "4ñ5ð  $Ÿz™zŸ~™~Ô/ó1á/˜!ð #$§)¡)¼5ÀÇÁÓ;NÜ',¨Q¯^©^Ó'<ÈaÏdÉdÐV`ÐN`óbà/ñ1ò	
ˆô �'Ð0´$Ø�d G´KÀÓ4Hô3Jó Kð Kùò5ùò1s   ÄA)HÆ%A
Hc                 ó|   — dd l }	 |j                  | xs d«      }t        |t        «      r|S d S # t        $ r Y y w xY w)Nr   z[])ÚjsonÚloadsrF   Ú
isinstancerÚ   )r>   r  rÜ   s      r'   Ú_parse_rowsr  ô   sF   € ÛðØ�z‰z˜#š+ Ó&ˆô ˜d¤DÔ)ˆ4Ð3¨tÐ3øô ò Ùðús   †/ ¯	;º;c           
      óp  — | j                   }d }|j                  dd«      j                  «       rZt        j                  j                  t        |j                  d«      dd«      xs d¬«      j                  «       }|€t        dd«      S i }d	j                  |j                  d
d«      j                  «       «      }|sd|d
<   nt        |«      dkD  rd|d
<   t        |j                  d«      «      }|€d|d<   t        |j                  d«      dd«      }|€d|d<   t        |j                  d«      dd«      }|€d|d<   t        |j                  d«      «      }|€d|d<   t        |j                  d«      «      }	|	€d|d<   t        |j                  d«      dd«      }
|
€d|d<   t        |j                  dd«      xs dd¬ «      }|�|d!kD  rd"|d<   d }|j                  d#d«      j                  «       rSt        j                  j                  t        |j                  d#«      dd«      xs d¬«      j                  «       }|€d$|d#<   |j                  d%d&«      }|t        t        j                   «      vrd&}t#        |j                  d'«      «      }|€d(|d)<   g }g }t%        |d¬*«      D �]­  \  }}t'        |t        «      sŒd	j                  t)        |j                  d
d«      «      j                  «       «      d d }t)        |j                  d+d«      «      j                  «       }t)        |j                  d,d«      «      j                  «       d d- }t)        |j                  d.d«      «      j                  «       }|j                  d«      rt        |j                  d«      dd«      nd }|s
|s|s|s|s�Œ|s|j+                  d)d/|› d0�«       nq|j-                  «       rt        |«      d1k(  s|j+                  d)d/|› d2|› d3�«       n9|r7|j-                  «       rt        |«      d4k(  s|j+                  d)d/|› d2|› d5�«       |j/                  ||||||d6œ«       �Œ° |�#t        |«      |kD  rd7t        |«      › d8|› d9�|d)<   t#        |j                  d:«      «      }|€d;|d<<   g }i }|D ]ª  }t'        |t        «      sŒt        |j                  d=«      dd«      }|�|r||kD  rŒ:t        |j                  d>«      d¬ «      }t        |j                  d?«      d¬ «      }|€|j+                  d<d@|› dA�«       Œ‹|€|j+                  d<d@|› dB�«       Œ¤||f||<   Œ¬ |r-t        t1        t3        |j5                  «       «      «      |¬C«      S t7        j8                  «       5  |d u }|xs
 t        «       }|||c|_        |_        |_        |||	c|_         |_!        |_"        |
|c|_#        |_$        |||j                  dDd«      j                  «       d dE c|_%        |_&        |_'        |jQ                  «        tS        |«      }|j                  d'«      ��ÜtU        «       }|jV                  jY                  «       D �ci c]  }|jZ                  |“Œ } }|D ]$  }!|!d   sŒ	|!d   | v sŒ|j]                  |!d   «       Œ& | j_                  «       D ]†  \  }"}|"|vsŒ|j`                  jc                  «       s|jd                  jc                  «       r8t7        jf                  d«       t        |j:                  › dF�«      c cd d d «       S |ji                  «        Œˆ |jV                  jY                  «       D ]*  }|xjj                  dGz  c_5        |jQ                  dHg¬I«       Œ, |D ]’  }!|!d   |v r| j                  |!d   «      ntm        |¬J«      }|!dH   |!d
   |!d+   c|_5        |_        |_7        |!d,   |!d.   c|_8        |_9        |jt                  €tw        jx                  «       |_=        |jQ                  «        Œ” |j|                  jY                  «       D �]  }#|#j~                  |vrŒ||#j~                     \  }}||#j€                  k  r‘|#j`                  j5                  dK«      jƒ                  t…        dL«      ¬M«      j                  |¬N«      }$|$jc                  «       r=t7        jf                  d«       t        d@|#j~                  › dO|dP›d9�«      c cd d d «       S |#j€                  |#j†                  f||fk7  sŒã||c|#_@        |#_C        |#jQ                  d>d?g¬I«       �Œ 	 d d d «       rdQndR}%r&|%dSdTj                  t‰        t(        |«      «      › dU�z  }%t‹        |%|jZ                  t�        dV|jZ                  g¬W«      ¬X«      S c c}w # 1 sw Y   ŒjxY w)YNr–   rK   rR   é Êš;r   rX   úChit not found.é”  Ú rb   zChit name is required.é–   zChit name is too long.r—   zEnter the chit value.r˜   éô  z"Members must be between 1 and 500.rš   éð   z!Months must be between 1 and 240.r›   zEnter the monthly amount.r¥   zSelect the start month.rœ   é   zDue day must be 1 to 31.Úcommission_percentÚ0T©r?   r¢   zCommission must be 0 to 100 %.r�   zSelect a valid place.r.   r‰   Úmembers_jsonz!Member details could not be read.rµ   )Ústartr   r  éÿ   r  zMember z: name is required.é
   z (z!): enter a 10-digit phone number.é   z): Aadhaar must be 12 digits.)r–   rÿ   rb   r   r  r  zYou entered z members but the chit has Ú.Ú
terms_jsonz Month amounts could not be read.r  r  r  r  úMonth z: enter a valid due amount.z: enter a valid winner amount.©r0   ÚnotesiÐ  z< has payments or has won a month, so they cannot be removed.é'  rÿ   ©Úupdate_fields©r_   rú   Úamount©r·   ©Ús__gtu)   : some members already paid more than â‚¹ú,.2fzChit created.zChit updated.z Months z, z2 were kept because they have payments or a winner.zadmin:chit_viewrË   )r–   r§   )GÚPOSTr¨   r9   r   rd   r[   rI   r\   r2   ÚjoinÚsplitr¬   rA   rV   r   ÚdictÚSTATUS_CHOICESr  ró   r  r8   r½   Úisdigitr¾   r©   ÚiterrÀ   r   Úatomicrb   r—   r˜   rš   r›   r¥   rœ   r!  r�   r.   r-  Úsaver   r  rµ   r  r–   ÚaddÚitemsÚpaymentsÚexistsÚ	won_termsÚset_rollbackÚdeleterÿ   r   r   r  r  rY   r   rÈ   Újoined_dater  r  r  Úannotater   r  Úmapr6   r   )&r&   Úpr_   r0   rb   r—   rµ   ÚmonthsÚmonthlyr%  rœ   Ú
commissionr�   r.   Úmember_rowsÚclean_membersrõ   rÐ   ÚnmÚphÚadÚaaÚridÚ	term_rowsÚclean_termsr|   rÖ   ÚprizeÚcreatedÚblockedÚkeeprÄ   ÚexistingrÝ   Úmidr�   ÚoverÚmsgs&                                         r'   rr   rr   ý   s	  € à�‰€AØ€DØ‡u�uˆT�2ƒ×ÑÔÜ× Ñ ×'Ñ'¬4°·±°d³¸QÀÓ+HÒ+MÈAÐ'ÓN×TÑTÓVˆØˆ<ÜÐ)¨3Ó/Ð/à€FØ�8‰8�A—E‘E˜& "Ó%×+Ñ+Ó-Ó.€DÙØ1ˆˆvŠÜ	ˆT‹�SŠØ1ˆˆv‰Ü˜Ÿ™˜lÓ+Ó,€JØÐØ6ˆˆ|ÑÜ�1—5‘5˜Ó)¨1¨cÓ2€GØ€Ø"FˆˆÑÜ�!—%‘%˜Ó'¨¨CÓ0€FØ€~Ø!Dˆˆ~ÑÜ�Q—U‘UÐ+Ó,Ó-€GØ€Ø#>ˆÐÑ Ü�1—5‘5˜Ó'Ó(€EØ€}Ø 9ˆˆ}ÑÜ�1—5‘5˜Ó# Q¨Ó+€GØ€Ø6ˆˆyÑÜ˜Ÿ™Ð2°CÓ8Ò?¸CÈDÔQ€JØÐ˜Z¨#Ò-Ø'GˆÐ#Ñ$Ø€EØ‡u�uˆW�bÓ×ÑÔ!Ü—‘×$Ñ$¬¨Q¯U©U°7«^¸QÀÓ(HÒ(MÈAÐ$ÓN×TÑTÓVˆØˆ=Ø5ˆF�7‰OØ�U‰U�8˜XÓ&€FØ”Tœ)×2Ñ2Ó3Ñ3Øˆô ˜aŸe™e NÓ3Ó4€KØÐØ?ˆˆyÑØˆØ€MÜ˜+¨Q×/Ð/‰ˆˆ1Ü˜!œTÔ"ØØ�X‰X”c˜!Ÿ%™% ¨Ó+Ó,×2Ñ2Ó4Ó5°d°sÐ;ˆÜ�—‘�w Ó#Ó$×*Ñ*Ó,ˆÜ�—‘�y "Ó%Ó&×,Ñ,Ó.¨t°Ð4ˆÜ�—‘Ð'¨Ó,Ó-×3Ñ3Ó5ˆØ/0¯u©u°T¬{Œd�1—5‘5˜“;  7Ô+ÀˆÙ‘b™B¡"©cÙÙØ×Ñ˜i¨7°1°#Ð5HÐ)IÕJØ—*‘*”,¤3 r£7¨b¢=Ø×Ñ˜i¨7°1°#°R¸°tÐ;\Ð)]Õ^Ù˜Ÿ™œ¬#¨b«'°Rª-Ø×Ñ˜i¨7°1°#°R¸°tÐ;XÐ)YÔZØ×Ñ C°aÀÈbÐ]_Ø02ñ4ö 	5ð! 0ð$ Ðœs =Ó1°GÒ;Ø*¬3¨}Ó+=Ð*>Ð>XÐY`ÐXaÐabÐcˆˆyÑô ˜AŸE™E ,Ó/Ó0€IØÐØ<ˆˆw‰Øˆ	Ø€KÛˆÜ˜!œTÔ"ØÜ�—‘�yÓ! 1 cÓ*ˆØˆ9™ A¨¢JØÜ�Q—U‘U˜<Ó(°TÔ:ˆÜ�q—u‘u˜^Ó,¸Ô>ˆØˆ;Ø×Ñ˜g¨°¨sÐ2MÐ'NÕOØˆ]Ø×Ñ˜g¨°¨sÐ2PÐ'QÕRà! 5˜\ˆK˜ŠNð ñ Ü”Dœ˜fŸm™m›oÓ.Ó/¸Ô?Ð?ä	×	Ñ	Õ	Ø˜$�,ˆØÒ"”y“{ˆØ9=¸zÈ7Ð6ˆŒ	�4”? DÔ$6ØCIÈ7ÐTYÐ@ˆÔ˜4Ô.°Ô0@Ø07¸Ð-ˆŒ�dÔ-Ø.3°V¸Q¿U¹UÀ7ÈBÓ=O×=UÑ=UÓ=WÐX]ÐY]Ð=^Ð+ˆŒ
�D”K ¤Ø�	‰	ŒÜ˜TÓ"ˆð �5‰5�Ó Ñ,Ü“5ˆDØ)-¯©×)9Ñ)9Ô);Ó<Ñ); A˜Ÿ™˜a™Ð);ˆHÐ<Û$�Ø�t“9  T¡¨hÒ!6Ø—H‘H˜S ™YÕ'ð %ð #Ÿ.™.Ö*‘��QØ˜d’?Ø—z‘z×(Ñ(Ô*¨a¯k©k×.@Ñ.@Ô.BÜ#×0Ñ0°Ô6Ü# q§v¡v hÐ.jÐ$kÓlÑl÷+ 
Ñ	ð, —H‘H•Jð +ð —\‘\×%Ñ%Ö'�Ø—’˜uÑ$•Ø—‘ k ]�Õ3ð (ó %�Ø/2°4©y¸DÑ/@�H—L‘L  T¡Ô+ÄjÐVZÔF[�Ø/2°;Ñ/?ÀÀVÁÈcÐRYÉlÐ,�”˜QœV Q¤WØ.1°)©n¸cÐBRÑ>SÐ+�”	˜1Ô+Ø—4‘4�<Ü$,×$6Ñ$6Ó$8�A”MØ—‘•ð %ð —‘—‘×!ˆAØ�y‰y Ñ+ØØ$ Q§Y¡YÑ/‰JˆC�Ø�Q—\‘\Ò!ØŸ
™
×)Ñ)¨+Ó6×?Ñ?Ä#ÀhÃ-Ð?ÓP×WÑWÐ^aÐWÓb�Ø—;‘;”=Ü×,Ñ,¨TÔ2Ü &¨¯©¨Ð3_Ð`cÐdhÐ_iÐijÐ kÓlÑl÷Y 
Ñ	ðZ —‘˜aŸn™nÐ-°#°u°Ó=Ø/2°EÐ,�”˜aœnØ—‘ l°NÐ%C�ÖDñ "÷I 
ñb %‰/¨/€CÙØ�˜$Ÿ)™)¤C¬¨WÓ$5Ó6Ð7Ð7iÐjÑjˆÜˆs�t—w‘w¬7Ð3DÈDÏGÉGÈ9Ô+UÔVÐVùòO =÷ 
Ð	úsE   ÖCf,Ù)f'Ù=f,Ú
f,Ú0f,ÛA"f,Ü/Gf,ã>f,ä&f,æ'f,æ,f5c                 ór  — t         j                  j                  t        | j                  j                  d«      dd«      xs d¬«      j                  «       }|€t        dd«      S t        j                  j                  |¬«      j                  «       rt        d	«      S |j                  «        t        d
«      S )Nr–   rR   r  r   rX   r  r  rø   zNThis chit has payments. Close it instead of deleting (Edit -> Status: Closed).zChit deleted.)r   rd   r[   rI   r7  r¨   r\   r2   r   rC  rF  r6   )r&   r_   s     r'   rs   rs   ”  s•   € ä×Ñ×#Ñ#¤t¨G¯L©L×,<Ñ,<¸TÓ,BÀAÀwÓ'OÒ'TÐSTÐ#ÓU×[Ñ[Ó]€DØ€|ÜÐ% sÓ+Ð+Ü×Ñ×!Ñ!¨TÐ!Ó2×9Ñ9Ô;ÜÐdÓeÐeØ‡K�K„MÜˆÓÐr)   c                 óÊ   — t        | |«      }t        | dt        | |t        j                  «       t        | «      r!t        d|j                  g¬«      ¬«      «      S d¬«      «      S )Nzchit/chit_detail.htmlzadmin:chit_editrË   rK   )r_   r°   Úedit_url)r`   r   rƒ   r   rÈ   r+   r   r–   r]   s      r'   Úchit_detailrb     sg   € Ü�W˜gÓ&€DÜ�'Ð2´DØ�d¤(×"4Ñ"4Ó"6Ü?HÈÔ?Q”Ð*°$·'±'°Ô;ô5[ó \ð \àWYô5[ó \ð \r)   c                 óæ  — | j                   | j                  t        | j                  «      | j                  | j
                  t        | j                  «      | j                  j                  d«      | j                  j                  d«      | j                  t        | j                  «      | j                  xs d| j                  r| j                  j                  nd| j                  | j                  dœS )NrQ   r¦   rK   rž   )r–   rb   r—   r˜   rš   r›   r¥   Ústart_labelrœ   r!  Úplace_idr�   r.   r-  )r–   rb   r«   r—   r˜   rš   r›   r¥   r¯   rœ   r!  re  r�   r.   r-  r1  s    r'   r  r  §  s«   € à�g‰g˜tŸy™y¼¸d¿o¹oÓ8NØ×+Ñ+¸T×=NÑ=NÜ × 3Ñ 3Ó4Ø×'Ñ'×0Ñ0°Ó9Ø×'Ñ'×0Ñ0°Ó9ÀdÇlÁlÜ# D×$;Ñ$;Ó<Ø—M‘MÒ' RÀTÇZÂZ°$·*±*·/²/ÐUXØ—+‘+¨¯
©
ñ	ð 	r)   c                 ó˜
  ‡‡‡‡— t        | t        | j                  j                  d«      dd«      xs d«      }t	        j
                  «       Št        |j                  j                  «       «      }t        |j                  j                  d«      «      }t        |D �cg c]  }|j                  ‘Œ c}«      Št        |‰«      \  }}|D �cg c]  }t        ||‰‰«      ‘Œ }}t        | j                  j                  d«      dd«      Š‰€$t        t!        |xs dd«      |j"                  «      Št%        ˆfd„|D «       |r|d   nd «      }|D �ci c]  }|j&                  sŒ|j&                  |“Œ }	}g }
|D �]:  Š|	j                  ‰j                  «      }t)        ˆˆfd	„|D «       t*        «      }t)        ˆfd
„|D «       t*        «      }|r,‰j                  |j                  ‰j                  ft*        «      nt*        }|
j-                  i d‰j                  “d‰j.                  “d‰j0                  “d‰j2                  “d‰j4                  “d‰j6                  “d‰j8                  “d‰j:                  r‰j:                  j=                  «       nd“d‰j>                  “dtA        |«      “d|r|jB                  nd “d|r|jD                  jG                  d«      nd“d|rtI        |jJ                  «      nd“dtA        |xr |jL                  «      “dtI        |«      “d|rtI        |jN                  «      nd“d|r"tQ        ||jN                  |jR                  ‰«      nd“tI        t!        |r|jN                  nt*        |z
  t*        «      «      tI        |«      tI        t!        ||z
  t*        «      «      dœ¥«       �Œ= g }|rÝ|jT                  j                  dd «      jW                  d!d"«      D ]®  }|j-                  |j                  d#|jX                  j.                  › d$|jX                  j0                  › �tI        |jZ                  «      |j\                  jG                  d%«      |j_                  «       |j`                  r|j`                  j0                  nd&d'œ«       Œ° tc        te        |«      tf        |   |xs dti        |	«      ti        |«      tI        t)        d(„ |D «       t*        «      «      tI        t)        d)„ |D «       t*        «      «      tI        t)        d*„ |D «       t*        «      «      d+œ||rt        ||‰‰«      nd |
|d,œ
«      S c c}w c c}w c c}w )-Nr–   rR   r  r   r¼   r¶   i@B c              3   óB   •K  — | ]  }|j                   ‰k(  sŒ|–— Œ y ­wrC   )r  )r�   r�   Úsels     €r'   r‘   z#chit_detail_data.<locals>.<genexpr>À  s   øè ø€ Ð6™E�q Q§Y¡Y°#Ó%5”™Eùr’   c              3   óv   •K  — | ]0  }‰j                  |j                  ‰j                  ft        «      –— Œ2 y ­wrC   )r¨   r–   r   )r�   r�   rÄ   r³   s     €€r'   r‘   z#chit_detail_data.<locals>.<genexpr>Æ  s)   øè ø€ ÐFÁ¸1˜$Ÿ(™( A§D¡D¨!¯$©$ <´×6Áùs   ƒ69c              3   óV   •K  — | ]   }|j                   ‰k  sŒ|j                  –— Œ" y ­wrC   )Údue_dater  )r�   r�   r°   s     €r'   r‘   z#chit_detail_data.<locals>.<genexpr>Ç  s!   øè ø€ ÐL©u¨!¸¿
¹
ÀeÓ8K˜Ÿ�©uùs   ƒ)˜)rÿ   rb   r   r  r  ÚnomineerG  rK   r-  r¸   Úclaimed_termÚclaimed_monthr¦   Úclaimed_amountÚprize_receivedÚ	term_paidÚterm_dueÚterm_statusrž   )Úterm_balanceÚ
total_paidÚtotal_pendingÚmemberÚcollected_byz
-paid_datez-idÚ#r  z%d %b %YÚAdmin)r–   rw  r2  rN   Úmethodrx  c              3   óJ   K  — | ]  }t        t        |d    «      «      –— Œ y­w)rÕ   N©r   r8   r•   s     r'   r‘   z#chit_detail_data.<locals>.<genexpr>é  s   è ø€ Ð#TÉ)ÀQ¤G¬C°°+±Ó,?×$@É)ùs   ‚!#c              3   ó`   K  — | ]&  }|d    s|d   sŒt        t        |d   «      «      –— Œ( y­w)Úis_pastÚ
is_currentrÒ   Nr}  r•   s     r'   r‘   z#chit_detail_data.<locals>.<genexpr>ê  s1   è ø€ Ð$xÉ9ÀaÐXYÐZcÒXdÐhiÐjvÓhw¤W¬S°°;±Ó-@×%AÉ9ùs   ‚.’.c              3   óN   K  — | ]  }|j                   sŒ|j                  –— Œ y ­wrC   )r¸   r  r•   s     r'   r‘   z#chit_detail_data.<locals>.<genexpr>ë  s   è ø€ Ð$P¹U¸ÀaÇiÃi Q§^¥^¹Uùs   ‚%”%)rÕ   Ú
due_so_farÚ
prize_paid)
r_   rŸ   r    r£   r™   rò   r  Úselected_termrµ   rB  )5r`   rI   rØ   r¨   r   rÈ   rÚ   rµ   r  r  r¿   r   r–   r   r   ÚminrÛ   rš   r©   r”   rª   r   r¾   rÿ   rb   r   r  r  rl  rG  Ú	isoformatr-  Úboolr  rŽ   r¯   r«   r  r¸   r  r   rk  rB  re   rw  r2  Ú	paid_dateÚget_method_displayrx  r
   r  r­   r¬   )r&   r_   rµ   r  r�   rŸ   r´   rU  r¶   r  rN  Úwru  Ú	total_duerJ  rB  ÚpayrÄ   r³   rh  r°   s                    @@@@r'   rl   rl   ´  s¤  û€ Ü�Wœd 7§;¡;§?¡?°4Ó#8¸!¸WÓEÒJÈÓK€DÜ×ÑÓ €EÜ�4—<‘<×#Ñ#Ó%Ó&€GÜ�—‘×*Ñ*¨8Ó4Ó5€EÜ¡5Ó)¡5˜a�Q—T“T 5Ñ)Ó*€DÜ  eÓ,�N€Eˆ7á@EÓFÁ¸1”˜a ¨$°Õ6À€IÐFÜ
ˆw�{‰{�‰˜vÓ&¨¨7Ó
3€CØ
€{Ü”#�g’l  AÓ&¨×(9Ñ(9Ó:ˆÜÓ6™EÓ6ÁE¸¸aºÈtÓT€Dá#(Ó
8¡5˜a¨A¯K«Kˆ1�;‰;˜‰> 5€CÐ
8Ø€KÜˆØ�G‰G�A—D‘D‹MˆÜÔFÁÓFÌÓMˆ
ÜÓL©uÓLÌdÓSˆ	Ù/3ˆD�H‰H�d—g‘g˜qŸt™t�_¤dÔ+¼ˆØ×Ñð 
Ø�!—$‘$ð
Ø# Q§[¡[ð
Ø28¸!¿&¹&ð
ØBIÈ1Ï7É7ð
à�q—y‘yð
à"2°A×4DÑ4Dð
àFOÐQR×QZÑQZð
ð ¸¿º˜1Ÿ=™=×2Ñ2Ô4È2ð
ð PWÐXY×X_ÑX_ð
ð ”t˜A“wð	
ð
 ©˜AŸIšI°ð
ð ¹!˜QŸW™W×-Ñ-¨gÔ6Àð
ð ±qœe A§N¡NÔ3¸að
ð œd 1¢?¨¯©Ó3ð
ð œ˜q›ð
ð ±$œ˜dŸo™oÔ.¸Að
ð ÑVZœ=¨¨D¯O©O¸T¿]¹]ÈEÔRÐ`cð
ô "¤#¹$ t§¢ÄDÈAÑ&MÌtÓ"TÓUÜ 
Ó+Ü"¤3 y°:Ñ'=¼tÓ#DÓEò
ö 	ð ð, €HÙØ—=‘=×/Ñ/°¸.ÓI×RÑRÐS_ÐafÖgˆCØ�O‰OØ—f‘f¨!¨C¯J©J×,@Ñ,@Ð+AÀÀ3Ç:Á:Ç?Á?ÐBSÐ(TÜ §
¡
Ó+°S·]±]×5KÑ5KÈJÓ5WØ×0Ñ0Ó2Ø9<×9IÒ9I × 0Ñ 0× 5Ò 5Èwñ	õ ð hô Ü˜4Ó Ü˜UÑ#°g²lÀÜ˜S›´3°w³<äœsÑ#TÉ)Ó#TÔVZÓ[Ó\Ü¤Ñ$xÉ9Ó$xÔz~Ó ó  AÜ¤Ñ$P¹UÓ$PÔRVÓ WÓXñ
ð
 ÙEIœ d¨G°T¸5ÔAÈtØØñó ð ùòW *ùò Gùò 9s   ÂT=Ã
UÅUÅUc                 óJ  ‡
— | j                   }t        j                  j                  t	        |j                  d«      dd«      xs d¬«      j                  «       }|€t        dd«      S d }|j                  dd	«      j                  «       rV|j                  j                  t	        |j                  d«      dd«      xs d¬«      j                  «       }|€t        d
d«      S i }dj                  |j                  dd	«      j                  «       «      }|sd|d<   |j                  dd	«      j                  «       }|j                  «       rt        |«      dk7  rd|d<   |j                  dd	«      j                  «       }|r#|j                  «       rt        |«      dk7  rd|d<   |j                  dd	«      j                  «       rt	        |j                  d«      dd«      nd }|j                  dd	«      j                  «       r|€d|d<   |€:|j                  j                  «       |j                  k\  rd|j                  › d�|d<   |€Et!        |j                  j#                  dd¬«      «      Š
t%        ˆ
fd„t'        dd«      D «       «      }nN|j                  j                  |¬«      j)                  t+        |dd «      ¬«      j-                  «       r	d|› d �|d<   |j                  d!d	«      j                  «       rt/        |j                  d!«      «      nd }	|r-t        t%        t1        |j3                  «       «      «      |¬"«      S |xs t5        |¬#«      }|||c|_        |_        |_        |j                  d$d	«      j                  «       d d% |_        |dj                  |j                  d&d	«      j                  «       «      d d' c|_        |_         |	|j                  d(d	«      j                  «       d d% c|_!        |_"        |jG                  «        tI        d)|jJ                  ¬*«      S )+Nr^   rR   r  r   rX   r  r  r–   rK   úMember not found.r  rb   zMember name is required.r   r'  zEnter a 10-digit phone number.r  r(  zAadhaar must be 12 digits.rÿ   r  zTicket number must be 1 to 500.zThis chit is full (z) members). Increase members in Edit Chit.Trû   c              3   ó,   •K  — | ]  }|‰vsŒ|–— Œ y ­wrC   rÎ   )r�   r|   Úuseds     €r'   r‘   z#chit_member_save.<locals>.<genexpr>  s   øè ø€ ÐDÑ!2˜A°a¸t²m”aÑ!2ùs   ƒ	�r.  )rÿ   rY   zTicket z is already taken.rG  r,  r1  r  r&  rl  r  r-  zMember saved.)r–   )&r7  r   rd   r[   rI   r¨   r\   r2   r9   rµ   r8  r9  r<  r¬   Úcountr˜   r  r  r©   ÚrangeÚexcludeÚgetattrrC  rO   r=  rÀ   r   rÿ   rb   r   r  r  rl  rG  r-  r?  r6   r–   )r&   rJ  r_   rw  r0   rb   r   ÚaadhaarÚticketÚjoinedr�  s             @r'   rt   rt   õ  s„  ø€ à�‰€AÜ×Ñ×#Ñ#¤t¨A¯E©E°)Ó,<¸aÀÓ'IÒ'NÈQÐ#ÓO×UÑUÓW€DØ€|ÜÐ% sÓ+Ð+Ø€FØ‡u�uˆT�2ƒ×ÑÔØ—‘×$Ñ$¬¨Q¯U©U°4«[¸!¸WÓ(EÒ(JÈÐ$ÓK×QÑQÓSˆØˆ>ÜÐ+¨SÓ1Ð1à€FØ�8‰8�A—E‘E˜& "Ó%×+Ñ+Ó-Ó.€DÙØ3ˆˆv‰Ø�E‰E�'˜2Ó×$Ñ$Ó&€EØ�=‰=Œ?œc %›j¨BÒ.Ø:ˆˆw‰Ø�e‰eÐ$ bÓ)×/Ñ/Ó1€GÙ˜Ÿ™Ô)¬S°«\¸RÒ-?Ø#?ˆÐÑ Ø12·±°{ÀBÓ1G×1MÑ1MÔ1OŒT�!—%‘%˜Ó$ a¨Ô-ÐUY€FØ‡u�uˆ[˜"Ó×#Ñ#Ô%¨&¨.Ø?ˆˆ{ÑØ€~˜$Ÿ,™,×,Ñ,Ó.°$×2DÑ2DÒDØ.¨t×/AÑ/AÐ.BÐBkÐlˆˆv‰Ø€~Ü�4—<‘<×+Ñ+¨K¸dÐ+ÓCÓDˆÜÓD¤ q¨'Ô!2ÓDÓD‰Ø	�‰×	Ñ	 vÐ	Ó	.×	6Ñ	6¼'À&È$ÐPTÓ:UÐ	6Ó	V×	]Ñ	]Ô	_Ø '¨ xÐ/AÐBˆˆ{ÑØ,-¯E©E°-ÀÓ,D×,JÑ,JÔ,LŒU�1—5‘5˜Ó'Ô(ÐRV€FÙÜ”Dœ˜fŸm™m›oÓ.Ó/¸Ô?Ð?àÒ,”z tÔ,€FØ28¸$ÀÐ/€FÔ�f”k 6¤<Ø—U‘U˜9 bÓ)×/Ñ/Ó1°$°3Ð7€F„NØ,3°S·X±X¸a¿e¹eÀIÈrÓ>R×>XÑ>XÓ>ZÓ5[Ð\`Ð]`Ð5aÐ)€FÔ˜6œ>Ø'-¨q¯u©u°W¸bÓ/A×/GÑ/GÓ/IÈ$È3Ð/OÐ$€FÔ˜œØ
‡K�K„MÜˆ 6§9¡9Ô-Ð-r)   c                 ó~  — t         j                  j                  t        | j                  j                  d«      dd«      xs d¬«      j                  «       }|€t        dd«      S |j                  j                  «       s|j                  j                  «       rt        d«      S |j                  «        t        d	«      S )
Nr–   rR   r  r   rX   rŽ  r  zGThis member has payments or has won a month, so they cannot be removed.zMember removed.)r   rd   r[   rI   r7  r¨   r\   r2   rB  rC  rD  rF  r6   )r&   rÄ   s     r'   ru   ru   "  s•   € ä×Ñ×!Ñ!¤T¨'¯,©,×*:Ñ*:¸4Ó*@À!ÀWÓ%MÒ%RÐQRÐ!ÓS×YÑYÓ[€AØ€yÜÐ'¨Ó-Ð-Ø‡z�z×ÑÔ˜aŸk™k×0Ñ0Ô2ÜÐ]Ó^Ð^Ø‡H�H„JÜÐ Ó!Ð!r)   c                 óÊ  — t         j                  j                  t        | j                  j                  d«      dd«      xs d¬«      j                  «       }t        | j                  j                  dd«      xs dd¬	«      }|�|�||j                  kD  rt        d
«      S t        ||«      \  }}}}t        t        |«      t        |«      t        |«      t        |«      dœ«      S )Nr^   rR   r  r   rX   Údiscountr"  Tr#  zEnter a valid discount.)r  Úcommission_amountÚdividend_per_memberr  )r   rd   r[   rI   rØ   r¨   r\   rA   r—   r2   r   r
   r«   )r&   r_   rš  rW  rM  ÚdividendrÖ   s          r'   rx   rx   .  sÇ   € Ü×Ñ×#Ñ#¤t¨G¯K©K¯O©O¸IÓ,FÈÈ7Ó'SÒ'XÐWXÐ#ÓY×_Ñ_Óa€DÜ�g—k‘k—o‘o j°#Ó6Ò=¸#È$ÔO€HØ€|�xÐ'¨8°d·o±oÒ+EÜÐ-Ó.Ð.Ü'4°T¸8Ó'DÑ$€Eˆ:�x Ü¬¨u«ÌEÐR\ÓL]Ü05°h³ÌuÐUXËzñ[ó \ð \r)   c                 óÐ  — | j                   }t        j                  j                  d«      j	                  t        |j                  d«      dd«      xs d¬«      j                  «       }|€t        dd«      S |j                  }i }t        |j                  d	«      d
¬«      }|€d|d	<   t        |j                  d«      d
¬«      }|€d|d<   t        |j                  dd«      xs dd
¬«      }t        |j                  dd«      xs dd
¬«      }t        |j                  dd«      xs dd
¬«      }	d |||	fv rd|d<   t        |j                  d«      «      xs |j                  }
d }|j                  dd«      j                  «       r×|j                  j	                  t        |j                  d«      dd«      xs d¬«      j                  «       }|€d|d<   n‡|j                  j!                  |j"                  ¬«      j%                  «       rS|j                  j!                  |j"                  ¬«      j                  «       }|j&                  › d|j(                  › d�|d<   |j                  d«      dv }|rt        |j                  d«      «      nd }|r|€d|d<   |r|€t+        j,                  «       }|�|||j.                  k  rmt0        j                  j	                  |¬«      j3                  d«      j5                  t7        d «      ¬!«      j	                  |¬"«      }|j%                  «       rd#|d	<   |r-t        t9        t;        |j3                  «       «      «      |¬$«      S |||
c|_        |_        |_        |||	c|_        |_         |_!        |||c|_"        |_#        |_$        |j                  d%d«      j                  «       d d& |_%        |jM                  «        |j                  d'«      d(v ri|jN                  j	                  |j(                  ¬)«      D ]@  }|jP                  j%                  «       rŒ||c|_        |_        |jM                  d	dg¬*«       ŒB tS        d+|j(                  › d,�«      S )-Nr_   rþ   rR   r  r   rX   úMonth not found.r  r  Tr#  z-Enter the amount each member pays this month.r  z&Enter the amount the winner can claim.Úbid_discountr"  r›  rœ  z8Discount, commission and dividend must be valid amounts.rk  r”   rK   zSelect a member of this chit.z already won month z . Each member can win only once.r¸   )Ú1ÚtrueÚonÚyesÚclaimed_datez6Select the winner before marking the prize as claimed.)r¶   rú   r2  r3  r4  z>Some members already paid more than this amount for the month.r,  r-  r&  Úapply_forward)r¡  r¢  r£  )Úterm_no__gtr/  r+  z saved.)*r7  r   rd   r¿   r[   rI   r¨   r\   r2   r_   rA   rO   rk  r9   rµ   rD  r“  rY   rC  rb   r  r   rÈ   r  r   rÀ   rH  r   r©   r=  r  r   r›  rœ  r¼   r¸   r¥  r-  r?  r  rB  r6   )r&   rJ  r¶   r_   r0   rÖ   rW  rš  rM  r�  rk  r¼   Úotherr¸   r¥  r]  r�   s                    r'   rv   rv   8  sà  € à�‰€AÜ×Ñ×*Ñ*¨6Ó2×9Ñ9¼TÀ!Ç%Á%È	ÓBRÐTUÐW^Ó=_Ò=dÐcdÐ9Óe×kÑkÓm€DØ€|ÜÐ&¨Ó,Ð,Ø�9‰9€DØ€FÜ
�—‘�|Ó$°Ô
6€CØ
€{ØNˆˆ|ÑÜ�1—5‘5˜Ó(°TÔ:€EØ€}Ø!Iˆˆ~ÑÜ�a—e‘e˜N¨CÓ0Ò7°CÀDÔI€HÜ˜Ÿ™Ð1°3Ó7Ò>¸3È4ÔP€JÜ�a—e‘eÐ1°3Ó7Ò>¸3È4ÔP€HØ�˜* hÐ/Ñ/Ø![ˆˆ~ÑÜ�Q—U‘U˜:Ó&Ó'Ò8¨4¯=©=€Hà€FØ‡u�uˆ[˜"Ó×#Ñ#Ô%Ø—‘×$Ñ$¬¨Q¯U©U°;Ó-?ÀÀGÓ(LÒ(QÐPQÐ$ÓR×XÑXÓZˆØˆ>Ø"AˆF�;ÒØ×Ñ×%Ñ%¨¯©Ð%Ó1×8Ñ8Ô:Ø×$Ñ$×,Ñ,°·±Ð,Ó8×>Ñ>Ó@ˆEØ%+§[¡[ MÐ1DÀUÇ]Á]ÀOÐSsÐ"tˆF�;ÑØ�e‰e�IÓÐ"<Ð<€GÙ3:”5˜Ÿ™˜~Ó.Ô/À€LÙ�6�>ØTˆˆyÑÙ�<Ð'Ü×)Ñ)Ó+ˆØ
€˜3 §¡Ò0Ü×#Ñ#×*Ñ*°Ð*Ó5×<Ñ<¸[ÓIß‘œC ›M�Ó*¯6©6¸¨6Ó+<ð 	à�;‰;Œ=Ø#cˆF�<Ñ ÙÜ”Dœ˜fŸm™m›oÓ.Ó/¸Ô?Ð?à8;¸UÀHÐ5€D„O�TÔ&¨¬ØJRÐT^Ð`hÐG€DÔ�tÔ-¨tÔ/GØ39¸7ÀLÐ0€D„K�”˜tÔ0Ø—‘�w Ó#×)Ñ)Ó+¨D¨SÐ1€D„JØ‡I�I„Kð 	‡u�uˆ_ÓÐ!4Ñ4Ø—‘×"Ñ"¨t¯|©|Ð"Ö<ˆAØ—:‘:×$Ñ$Õ&Ø/2°EÐ,�”˜aœnØ—‘ l°NÐ%C�ÕDð =ô �˜Ÿ™�~ WÐ-Ó.Ð.r)   c                 ó¸  — | j                   }t        j                  j                  d«      j	                  t        |j                  d«      dd«      xs d¬«      j                  «       }|�3t        | «      j	                  |j                  ¬«      j                  «       st        dd«      S |j                  j                  j	                  t        |j                  d	«      dd«      xs d¬«      j                  «       }|€t        d
d«      S t        |j                  d«      «      }|€t        dddi¬«      S t        |j                  d«      «      xs t!        j"                  «       }|t!        j"                  «       kD  rt        dddi¬«      S |j                  dd«      j%                  «       }|t'        t(        j*                  «      vrt        d«      S t-        j.                  «       5  t        j                  j1                  «       j                  |j2                  ¬«       |j4                  j	                  |¬«      j7                  t9        d«      ¬«      d   xs t:        }|j<                  |z
  }|dk  r.t        |j>                  › d|j@                  › d�«      cd d d «       S ||kD  rt        d|d›d�ddi¬«      cd d d «       S t(        j                  jC                  |||||tE        | «      dk(  rtG        | dd «      nd |j                  dd«      jI                  «       d d  ¬!«       d d d «       |z
  }	tK        d"|	dkD  rd#|	d›d�z   «      S d$z   «      S # 1 sw Y   Œ.xY w)%Nr_   rþ   rR   r  r   rX   rŸ  r  rú   rŽ  r2  zEnter a valid amount.r,  rˆ  z%Payment date cannot be in the future.zFuture date.r{  ÚcashzSelect a payment method.)rw  r3  r·   z has already paid month r)  u3   Amount is more than the balance for this month (â‚¹r6  z).z	Too much.r!   r-  rK   r&  )r¶   rw  r2  rˆ  r{  rx  r-  zPayment saved.u    Balance for this month â‚¹z Month fully paid.)&r7  r   rd   r¿   r[   rI   r¨   r\   r   r^   rC  r2   r_   rµ   rA   rO   r   rÈ   rÙ   r:  r   ÚMETHOD_CHOICESr   r>  Úselect_for_updaterY   rB  Ú	aggregater   r   r  rb   r  Úcreater(   r”  r9   r6   )
r&   rJ  r¶   rw  r2  rˆ  r{  r³   ÚbalanceÚlefts
             r'   rm   rm   s  s
  € à�‰€AÜ×Ñ×*Ñ*¨6Ó2×9Ñ9¼TÀ!Ç%Á%È	ÓBRÐTUÐW^Ó=_Ò=dÐcdÐ9Óe×kÑkÓm€DØ€|Ô,¨WÓ5×<Ñ<ÀÇÁÐ<ÓM×TÑTÔVÜÐ&¨Ó,Ð,Ø�Y‰Y×Ñ×%Ñ%¬¨a¯e©e°KÓ.@À!ÀWÓ)MÒ)RÐQRÐ%ÓS×YÑYÓ[€FØ€~ÜÐ'¨Ó-Ð-Ü�A—E‘E˜(“OÓ$€FØ€~ÜÐ+°XÐ?VÐ4WÔXÐXÜ�a—e‘e˜KÓ(Ó)ÒA¬X×-?Ñ-?Ó-A€IØ”8×%Ñ%Ó'Ò'ÜÐ;À[ÐR`ÐDaÔbÐbØ�U‰U�8˜VÓ$×*Ñ*Ó,€FØ”Tœ+×4Ñ4Ó5Ñ5ÜÐ.Ó/Ð/ä	×	Ñ	Õ	Ü×Ñ×*Ñ*Ó,×0Ñ0°D·G±GÐ0Ô<Ø�}‰}×#Ñ#¨6Ð#Ó2×<Ñ<¼sÀ8»}Ð<ÓMÈcÑRÒZÔVZˆØ—/‘/ DÑ(ˆØ�aŠ<Ü˜6Ÿ;™;˜-Ð'?ÀÇÁ¸~ÈQÐOÓP÷ 
Ñ	ð �GÒÜÐMÈgÐVZÈ^Ð[]Ð^Ø (¨+Ð6ô8÷ 
Ñ	ô 	×Ñ×"Ñ"Ø˜f¨V¸yÐQWÜ<BÀ7»OÈwÒ<Vœ ¨'°4Ô8Ð\`Ø—%‘%˜ Ó$×*Ñ*Ó,¨T¨cÐ2ð 	#ô 	4÷ 
ð �VÑ€DÜÐÐQUÐXYÒQYÐ%@ÀÀdÀÈ1Ð#Mñ :ó ;ð ;Ø$8ñ:ó ;ð ;÷ 
Ð	ús   Ç$B1MÊMËA"MÍMc                 ó   — t         j                  j                  t        | j                  j                  d«      dd«      xs d¬«      j                  «       }|€t        dd«      S |j                  «        t        d«      S )	Nr–   rR   r  r   rX   zPayment not found.r  zPayment removed.)
r   rd   r[   rI   r7  r¨   r\   r2   rF  r6   )r&   rŒ  s     r'   rw   rw   ˜  sj   € ä
×
Ñ
×
$Ñ
$¬¨W¯\©\×-=Ñ-=¸dÓ-CÀQÈÓ(PÒ(UÐTUÐ
$Ó
V×
\Ñ
\Ó
^€CØ
€{ÜÐ(¨#Ó.Ð.Ø‡J�J„LÜÐ!Ó"Ð"r)   c                 ó  — t        j                  «       }t        | dt        | t	        | «      j                  d«      t        t        |«      d«      j                  d«      t        |«      j                  d«      ¬«      «      S )Nzchit/chit_reports.htmlrb   éûÿÿÿrQ   )rÁ   Údefault_fromÚ
default_to)	r   rÈ   r   rƒ   r   re   r   r   r¯   )r&   r°   s     r'   rn   rn   ¢  sl   € Ü×ÑÓ €EÜ�'Ð3´TØÔ(¨Ó1×:Ñ:¸6ÓBÜ¤¨EÓ 2°BÓ7×@Ñ@ÀÓIÜ˜uÓ%×.Ñ.¨wÓ7ô69ó :ð :r)   c                 ó–  ‡— t        j                  «       }t        | j                  j	                  d«      «      xs t        t        |«      d«      }t        | j                  j	                  d«      «      xs t        |«      }||kD  r||}}t        | «      }t        | j                  j	                  d«      dd«      }|r|j                  |¬«      }t        |«      }t        |«      \  }}}g }	|D ]¿  }
|j	                  |
j                  g «      }|j	                  |
j                  g «      D ]‚  }||j                  cxk  r|k  sn Œt        ||||«      }|	j                  |
j                   |
j                  |
j"                  r|
j"                  j                   ndd	œ|¥d
t%        |«      i¥«       Œ„ ŒÁ |	j'                  d„ ¬«       i }|	D ]£  }|j)                  |d   |d   |d   ddddddddœ	«      }|dxx   dz  cc<   |dxx   |d   z  cc<   |dxx   |d   z  cc<   |dxx   |d   z  cc<   |dxx   |d   r|d   ndz  cc<   |dxx   |d   rdndz  cc<   |dxx   |d   rdndz  cc<   Œ¥ dD �‡ci c]  Š‰t+        ˆfd„|	D «       «      “Œ }}t+        d„ |	D «       «      |d<   |||	t-        |j/                  «       d„ ¬«      |fS c c}w )NÚ
from_monthr³  Úto_monthr_   rR   r  rX   rž   )r_   r^   r�   r™   c                 ó   — | d   | d   fS )NÚ	month_isor_   rÎ   )rÐ   s    r'   Ú<lambda>z_report_rows.<locals>.<lambda>¿  s   € ˜Q˜{™^¨Q¨v©YÑ7r)   )Úkeyrº  rŽ   r   )	rŽ   rº  rÁ   rÒ   rÕ   r×   rW  r¸   ÚwinnersrÁ   rÒ   rÕ   r×   rW  r¼   r  r½  r¸   )rÒ   rÕ   r×   c              3   ó(   •K  — | ]	  }|‰   –— Œ y ­wrC   rÎ   )r�   rÐ   Úks     €r'   r‘   z_report_rows.<locals>.<genexpr>Í  s   øè ø€ Ð(¡4˜a�Q�q•T¡4ùs   ƒc              3   ó2   K  — | ]  }|d    sŒ	|d   –— Œ y­w)r¸   r  NrÎ   rÏ   s     r'   r‘   z_report_rows.<locals>.<genexpr>Î  s   è ø€ Ð!R¹T¸ÀQÀyÃ\ ! NÕ"3¹Tùs   ‚
�
Úprize_claimedc                 ó   — | d   S )Nrº  rÎ   )rÄ   s    r'   r»  z_report_rows.<locals>.<lambda>Ï  s   € ÀQÀ{Â^r)   )r   rÈ   rV   rØ   r¨   r   r   r   rI   r[   rÚ   rÆ   r–   rŽ   r   r¾   rb   r�   r¬   Úsortr½   rª   ÚsortedrÀ   )r&   r°   r%  ÚendrÁ   r^   r±   r²   r³   rÜ   r_   rµ   r�   r·   Úby_monthrÐ   rÄ   r¿  rò   s                    ` r'   Ú_report_rowsrÇ  ª  s¹  ø€ Ü×ÑÓ €EÜ�7—;‘;—?‘? <Ó0Ó1ÒW´ZÄÈEÓ@RÐTVÓ5W€EÜ
�—‘—‘ Ó,Ó
-Ò
C´¸UÓ1C€CØˆs‚{Ø˜%ˆsˆÜ˜gÓ&€EÜ�7—;‘;—?‘? 6Ó*¨A¨wÓ7€GÙØ—‘ �Ó(ˆÜ�‹K€EÜ+0°«<Ñ(€O�] DØ€DÛˆØ!×%Ñ% d§g¡g¨rÓ2ˆØ×"Ñ" 4§7¡7¨BÖ/ˆAØ˜QŸW™WÔ+¨Ô+ØÜ˜Q ¨¨uÓ5ˆAØ�K‰K §¡°t·w±wÐ\`×\fÒ\fÈÏÉÏÊÐloñ <Øð<Ø,¬c°'«lñ<õ =ñ	 0ð ð 	‡I�IÑ7€IÔ8à€HÛˆØ×Ñ  +¡¸!¸G¹*ÐSTÐU`ÑSaÐlmØ>?ÈaÐ\]Ø:;ÈÐVWñ1Yó Zˆð 	
ˆ'‹
�a‰‹
Ø	ˆ+‹˜!˜K™.Ñ(‹Ø	ˆ+‹˜!˜K™.Ñ(‹Ø	ˆ)‹˜˜)™Ñ$‹Ø	ˆ'‹
¨1¨Xª;�a˜Ò'¸AÑ=‹
Ø	ˆ)‹˜Q˜xš[™¨aÑ/‹Ø	ˆ)‹˜Q˜yš\™¨qÑ0Œð ñ 3XÔXÑ2W¨Qˆa”Ó(¡4Ó(Ó(Ñ(Ð2W€FÐXÜ!Ñ!R¹TÓ!RÓR€Fˆ?ÑØ�#�tœV H§O¡OÓ$5Ñ;SÔTÐV\Ð\Ð\ùò Ys   É2Kc                 ó‚   — t        | «      \  }}}}}t        |j                  d«      |j                  d«      |||dœ«      S )Nr¦   )ÚfromÚtorÜ   rK  rò   )rÇ  r
   r¯   )r&   r%  rÅ  rÜ   rK  rò   s         r'   ro   ro   Ò  sI   € Ü'3°GÓ'<Ñ$€Eˆ3��f˜fÜ §¡°Ó!8ÀÇÁÈWÓ@UØ!%°À6ñKó Lð Lr)   c                 óÒ  — t        | «      \  }}}}}t        |d«      D ��cg c]H  \  }}||d   |d   |d   |d   |d   |d   |d   |d	   |d
   |d   |d   |d   xs d|d   |d   rdndg‘ŒJ }}}t        d|j                  d«      › d|j                  d«      › �dg d¢||j                  d«      › d|j                  d«      › �ddddddd|d   |d	   |d
   dddddg¬«      S c c}}w )NrR   r_   r�   rŽ   r  r  r™   rÒ   rÕ   r×   r  Úunpaid_membersr¼   rž   r  r¸   ÚYesÚNoÚchit_report_rå   Ú_zChit Fund Report)ræ   rç   r   ÚMonthzMonth NozDue / Memberrè   z	Due Totalrë   rì   zPaid MemberszUnpaid Membersrí   zPrize AmountzPrize Claimedr¦   z to rK   rï   rð   )rÇ  ró   r   r¯   )	r&   r%  rÅ  rÜ   rK  rò   rõ   rÐ   rô   s	            r'   rp   rp   Ø  sO  € Ü'3°GÓ'<Ñ$€Eˆ3��f˜fô !  qÔ)ô+ñ *‰tˆq�!ð ˆq�‰y˜!˜G™* a¨¡j°!°I±,ÀÀ,ÁÐQRÐSaÑQbØˆk‰N˜A˜k™N¨A¨i©L¸!¸NÑ:KÈQÐO_ÑM`Øˆh‰KÒ˜3  .Ñ 1¸A¸iºL±5ÈdòTð *ð ñ +ô Ø
�u—~‘~ gÓ.Ð/¨q°·±¸gÓ1FÐ0GÐHÐJ\ò	nà˜Ÿ™¨Ó0Ð1°°c·l±lÀ7Ó6KÐ5LÐMØ�G˜R  R¨¨R°¸Ñ1DÀfÈ[ÑFYÐ[aÐbkÑ[lØ�B˜˜B ð$ô%ð %ùó	+s   ¡AC#)i�  N)F)rR   iè  rC   )QÚ__doc__Úloggingr   Údecimalr   r   Ú	django.dbr   Údjango.db.modelsr   r   Údjango.httpr	   r
   Údjango.shortcutsr   Údjango.urlsr   Údjango.utilsr   Údjango.views.decorators.httpr   ÚNexusApp.modelsr   r   r   r   r   ÚNexusApp.utils.chit_servicer   r   r   r   r   r   r   r   r   r   ÚNexusApp.utils.excelr   Ú	getLoggerÚ__name__Úloggerr<   r(   r+   r2   r6   rA   rI   rO   rV   r`   rg   r}   rƒ   r­   r¹   rÆ   ri   rß   rj   rk   r  r  rr   rs   rb  r  rl   rt   ru   rx   rv   rm   rw   rn   rÇ  ro   rp   rÎ   r)   r'   Ú<module>râ     sž  ðñó Ý ß -å !ß #ß -Ý #Ý Ý !Ý 5ç OÕ O÷÷ ÷ õ /à	ˆ×	Ñ	˜8Ó	$€Ù�NÓ#€	òFò&óhòLó	ó(òòòò2ò4òð &°ÈÐ_gÑh€òò40òEò
ò4Zò
ró$Kò04ð ñSWó ðSWðl ñ ó ð ò\ò
ò=ðB ñ).ó ð).ðX ñ"ó ð"ò\ð ñ6/ó ð6/ðt ñ!;ó ð!;ðH ñ#ó ð#ò:ò%]òPLó%r)   