Ë
    ú�ýj-#  ã                   ó  — 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	 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j0                  e«      Z ed«      Zdd„Zd„ Zed„ «       Zd„ Zd„ Z d„ Z!d„ Z"d„ Z#ed„ «       Z$y)a~  
Collection corrections with admin approval.

  staff  POST /staff/request_payment_edit/      -> creates a PaymentEditRequest (payment unchanged)
  admin  GET  /admin/payment_edit_requests/      -> page listing requests
  admin  GET  /admin/payment_edit_requests_data/ -> JSON for the table
  admin  POST /admin/review_payment_edit/        -> approve (applies the change) or reject
é    N)Údatetime)ÚDecimalÚInvalidOperation)Útransaction)ÚSum©ÚJsonResponse©Úrender)Útimezone)Úrequire_POST)ÚLoanÚLoanPaymentÚPaymentEditRequest)Ústaff_paymentsÚ0c                 ó&   — t        d| dœ|¥|¬«      S )NÚerror©ÚstatusÚmessage©r   r   )r   r   Úextras      úE/var/www/html/nexus_chitfund_web/controllers/PaymentEditController.pyÚ_errr      s   € Ü 7°wÑHÀ%ÐHÐQWÔXÐXó    c                 óV  — | j                   j                  t        d«      ¬«      d   xs t        }|| j                  k\  rG| j                   j                  d«      j                  «       }d|r|j                  ndc| _        | _	        nd\  | _        | _	        | j                  g d¢¬	«       y)
zLFully paid -> completed (closed on the last payment date), otherwise active.Úamount©Úsr    z-payment_dateÚ	completedN)ÚactiveN)r   Úclosed_dateÚ
updated_at©Úupdate_fields)ÚpaymentsÚ	aggregater   ÚZEROÚtotal_payableÚorder_byÚfirstÚpayment_dater   r#   Úsave)ÚloanÚpaidÚlasts      r   Ú_sync_loan_statusr2      sŒ   € à�=‰=×"Ñ"¤S¨£]Ð"Ó3°CÑ8Ò@¼D€DØˆt×!Ñ!Ò!Ø�}‰}×%Ñ% oÓ6×<Ñ<Ó>ˆØ(3É$°T×5FÒ5FÐTXÐ%ˆŒ�TÕ%à(6Ñ%ˆŒ�TÔ%Ø‡I�IÒC€IÕDr   c                 óp  — t        | dd «      }| j                  j                  dd«      j                  «       }|j	                  «       st        d«      S t        | t        j                  j                  d«      «      j                  t        |«      ¬«      j                  «       }|€t        dd«      S |j                  t        |d	d «      k7  rt        d
d«      S |j                  j                  d¬«      j                  «       rt        dd«      S i }	 t!        j"                  | j                  j                  dd«      j                  «       d«      j%                  «       }|t'        j(                  «       kD  rd|d<   	 t-        | j                  j                  dd«      j                  «       «      }|j/                  «       r"|dk  s||j1                  t-        d«      «      k7  rt2        ‚	 | j                  j                  dd«      j                  «       j5                  «       }|t7        t        j8                  «      vrd|d<   dj;                  | j                  j                  dd«      j=                  «       «      }t?        |«      dk  rd|d<   nt?        |«      dkD  rd|d<   |s2||j@                  k(  r#||jB                  k(  r||jD                  k(  rd |d<   |s‘|jF                  jH                  jK                  |jL                  ¬«      jO                  tQ        d«      ¬!«      d"   xs tR        }	|	|z   |jF                  jT                  kD  r!d#|jF                  jT                  |	z
  d$›d%�|d<   |r-t        tW        tY        |j[                  «       «      «      |¬&«      S t\        j                  j_                  |||j@                  |jB                  |jD                  ||||¬'«	       t`        jc                  d(d|jL                  i¬)«       te        d*d+d,œ«      S # t*        $ r d }d|d<   Y �Œ¥w xY w# t2        $ r d }d|d<   Y �ŒOw xY w)-NÚstaffÚ
payment_idÚ zPayment is missing.r/   ©ÚpkzPayment not found.é”  r8   z-You can only correct collections you entered.i“  Úpendingr   zDA correction for this payment is already waiting for admin approval.é™  r-   z%Y-%m-%dz%Payment date cannot be in the future.zEnter a valid payment date.r   r   z0.01z/Enter a valid positive amount (max 2 decimals).Úpayment_methodzSelect a payment method.Ú Úreasoné   z<Enter the reason for the correction (at least 5 characters).éÿ   z$Reason cannot exceed 255 characters.zNothing changed.r   r    u3   Amount is too high. Maximum for this payment is â‚¹ú,.2fÚ.)Úerrors)	ÚpaymentÚrequested_byÚold_payment_dateÚ
old_amountÚold_payment_methodÚnew_payment_dateÚ
new_amountÚnew_payment_methodr>   zpayment edit requested©r   Úsuccessz8Correction sent to admin. It will update after approval.r   )3ÚgetattrÚPOSTÚgetÚstripÚisdigitr   r   r   ÚobjectsÚselect_relatedÚfilterÚintr,   Úcollected_by_idÚedit_requestsÚexistsr   ÚstrptimeÚdater   Ú	localdateÚ
ValueErrorr   Ú	is_finiteÚquantizer   ÚlowerÚdictÚMETHOD_CHOICESÚjoinÚsplitÚlenr-   r   r<   r/   r'   Úexcluder8   r(   r   r)   r*   ÚnextÚiterÚvaluesr   ÚcreateÚloggerÚinfor	   )
Úrequestr4   r5   rD   rC   Únew_daterJ   Úmethodr>   Úotherss
             r   Úrequest_payment_editrq   +   sÖ  € ä�G˜W dÓ+€EØ—‘×!Ñ! ,°Ó3×9Ñ9Ó;€JØ×ÑÔÜÐ)Ó*Ð*ä˜W¤k×&9Ñ&9×&HÑ&HÈÓ&PÓQ×XÑXÜˆz‹?ð Yó ß!™E›Gð à€ÜÐ(¨#Ó.Ð.Ø×Ñ¤'¨%°°tÓ"<Ò<ÜÐCÀSÓIÐIØ×Ñ×#Ñ#¨9Ð#Ó5×<Ñ<Ô>ÜÐZÐ\_Ó`Ð`à€Fð?Ü×$Ñ$ W§\¡\×%5Ñ%5°nÀbÓ%I×%OÑ%OÓ%QÐS]Ó^×cÑcÓeˆØ”h×(Ñ(Ó*Ò*Ø%LˆF�>Ñ"ð
MÜ˜WŸ\™\×-Ñ-¨h¸Ó;×AÑAÓCÓDˆ
Ø×#Ñ#Ô%¨°qª¸JÈ*×J]ÑJ]Ô^eÐflÓ^mÓJnÒ<nÜ"Ð"ð =oð �\‰\×ÑÐ.°Ó3×9Ñ9Ó;×AÑAÓC€FØ”Tœ+×4Ñ4Ó5Ñ5Ø#=ˆÐÑ à�X‰X�g—l‘l×&Ñ& x°Ó4×:Ñ:Ó<Ó=€FÜ
ˆ6ƒ{�Q‚ØYˆˆxÒÜ	ˆV‹�sÒ	ØAˆˆxÑá�h '×"6Ñ"6Ò6¸:ÈÏÉÒ;WØ˜'×0Ñ0Ò0Ø-ˆˆxÑáØ—‘×&Ñ&×.Ñ.°'·*±*Ð.Ó=×GÑGÌ#ÈhË-ÐGÓXÐY\Ñ]ÒeÔaeˆØ�JÑ §¡×!;Ñ!;Ò;ð#&Ø&-§l¡l×&@Ñ&@À6Ñ&IÈ$Ð%OÈqð!RˆF�8Ññ Ü”Dœ˜fŸm™m›oÓ.Ó/¸Ô?Ð?ä×Ñ×%Ñ%Ø eØ ×-Ñ-¸'¿.¹.Ø"×1Ñ1Ø!¨jÈVØð &ô ô ‡K�KÐ(°¸w¿z¹zÐ0J€KÔKÜ 9Ø$^ñ`ó að aøôW ò ?ØˆØ!>ˆˆ~Ôð?ûô ò MØˆ
ØLˆˆxÔðMús&   ÄA(P
 Å9A+P! Ð
PÐPÐ!P5Ð4P5c                 ó¤   — i }t         j                  j                  | ¬«      j                  d«      D ]  }|j                  ||j
                  <   Œ |S )zDpayment id -> latest request status, for the payment history tables.)Úpayment_id__inÚ
created_at)r   rS   rU   r+   r   r5   )Úpayment_idsÚoutÚrs      r   Úpending_edit_maprx   o   sI   € à
€CÜ×'Ñ'×.Ñ.¸kÐ.ÓJ×SÑSÐT`ÖaˆØŸH™HˆˆA�L‰LÒð bà€Jr   c                 ó   — t        | d«      S )Nz%adminpanel/payment_edit_requests.htmlr
   ©rm   s    r   Úpayment_edit_requestsr{   x   s   € Ü�'ÐBÓCÐCr   c                 óT   — t        t        j                  «      j                  | | «      S )N)ra   r   rb   rP   )Úcodes    r   Ú_fmt_methodr~   |   s    € Ü”×*Ñ*Ó+×/Ñ/°°dÓ;Ð;r   c           
      ób  — | j                   j                  dd«      j                  «       }t        j                  j                  ddd«      }|t        t        j                  «      v r|j                  |¬«      }g }t        |d¬«      D �]ë  \  }}|j                  j                  }|j                  i d	|“d
|j                  “d|j                  “d|j                  j                  “d|j                  j                   “d|j"                  j$                  “d|j&                  r|j&                  j$                  nd“d|j(                  j+                  d«      “d|j,                  j+                  d«      “dt/        |j0                  «      “dt/        |j2                  «      “dt5        |j6                  «      “dt5        |j8                  «      “d|j:                  “d|j=                  «       “d|j>                  “dtA        jB                  |jD                  «      j+                  d«      “d|jF                  r=|jH                  › dtA        jB                  |jF                  «      j+                  d«      › �ndi¥«       �Œî tK        |t        j                  j                  d¬«      jM                  «       dœ«      S ) Nr   r:   Úpayment__loan__customerÚpayment__loan__placerE   r   é   )ÚstartÚsnoÚidÚloan_idÚcustomerÚphoneÚplacer4   Ú-Úold_datez%d %b %Yrn   rG   rJ   Ú
old_methodÚ
new_methodr>   Ú
admin_noteÚrequested_atz%d %b %Y %I:%M %pÚreviewedu    Â· r6   )ÚdataÚpending_count)'ÚGETrP   rQ   r   rS   rT   ra   ÚSTATUS_CHOICESrU   Ú	enumeraterD   r/   Úappendr8   r‡   Úcustomer_nameÚphone_numberr‰   ÚnamerE   rF   ÚstrftimerI   ÚfloatrG   rJ   r~   rH   rK   r>   Úget_status_displayrŽ   r   Ú	localtimert   Úreviewed_atÚreviewed_byr	   Úcount)rm   r   Úqsr‘   Úirw   r/   s          r   Úpayment_edit_requests_datar£   €   s�  € Ø�[‰[�_‰_˜X yÓ1×7Ñ7Ó9€FÜ	×	#Ñ	#×	2Ñ	2Ø!Ð#9¸>ó
K€Bà”Ô(×7Ñ7Ó8Ñ8Ø�Y‰Y˜fˆYÓ%ˆØ€DÜ˜" A×&Ð&‰ˆˆ1Ø�y‰y�~‰~ˆØ�‰ð 
Ø�1ð
à�!—$‘$ð
ð �t—w‘wð
ð ˜Ÿ™×3Ñ3ð	
ð
 �T—]‘]×/Ñ/ð
ð �T—Z‘Z—_‘_ð
ð ¨A¯NªN�Q—^‘^×(Ò(Àð
ð ˜×*Ñ*×3Ñ3°JÓ?ð
ð ˜×*Ñ*×3Ñ3°JÓ?ð
ð œ% §¡Ó-ð
ð œ% §¡Ó-ð
ð œ+ a×&:Ñ&:Ó;ð
ð œ+ a×&:Ñ&:Ó;ð
ð �a—h‘hð
ð �a×*Ñ*Ó,ð
ð  ˜!Ÿ,™,ð!
ð" œH×.Ñ.¨q¯|©|Ó<×EÑEÐFYÓZð#
ð$ ØŸMšMð ŸM™M˜?¨$¬x×/AÑ/AÀ!Ç-Á-Ó/P×/YÑ/YÐZmÓ/nÐ.oÑpØ/1ñ'
ö 	ð 'ô.  Ü*<×*DÑ*D×*KÑ*KÐS\Ð*KÓ*]×*cÑ*cÓ*eñgó hð hr   c                 ót   — t        dt        j                  j                  d¬«      j	                  «       i«      S )Nr    r:   r   )r	   r   rS   rU   r    rz   s    r   Úpayment_edit_requests_countr¥   ¢   s0   € Ü˜Ô"4×"<Ñ"<×"CÑ"CÈ9Ð"CÓ"U×"[Ñ"[Ó"]Ð^Ó_Ð_r   c                 óæ  — | j                   j                  dd«      j                  «       }| j                   j                  dd«      j                  «       }dj                  | j                   j                  dd«      j	                  «       «      d d }|j                  «       r|dvrt        d«      S t        | j                  d	d«      xs t        | j                  d
d«      xs d}t        j                  «       5  t        j                  j                  «       j                  t        |«      ¬«      j!                  «       }|€t        dd«      cd d d «       S |j"                  dk7  rt        dd«      cd d d «       S |dk(  �rKt$        j                  j                  «       j                  |j&                  ¬«      }t(        j                  j                  «       j                  |j*                  ¬«      }|j,                  j/                  |j0                  ¬«      j3                  t5        d«      ¬«      d   xs t6        }||j8                  z   |j:                  kD  r#t        d|j:                  d›d�«      cd d d «       S |j<                  |_        |j8                  |_         |jB                  |_"        |jG                  g d¢¬«       tI        |«       |dk(  rdnd|_        ||_%        |d d |_&        tO        jP                  «       |_)        |jG                  g d¢¬«       d d d «       tT        jW                  dj"                  d|j0                  i¬ «       tY        d!|dk(  rd"d$œ«      S d#d$œ«      S # 1 sw Y   ŒRxY w)%NÚ
request_idr6   Úactionr=   rŽ   r@   )ÚapproveÚrejectzInvalid request.Úemailr™   Úadminr7   zRequest not found.r9   r:   z"This request was already reviewed.r;   r©   r   r   r    uD   Cannot approve: total paid would be more than the total payable (â‚¹rA   z).)r-   r   r<   r%   ÚapprovedÚrejectedé–   )r   rŽ   rŸ   rž   zpayment edit %srL   rM   z/Correction approved and the payment is updated.zCorrection rejected.r   )-rO   rP   rQ   rc   rd   rR   r   rN   Úuserr   Úatomicr   rS   Úselect_for_updaterU   rV   r,   r   r   r5   r   r†   r'   rf   r8   r(   r   r)   rJ   r*   rI   r-   r   rK   r<   r.   r2   rŽ   rŸ   r   Únowrž   rk   rl   r	   )	rm   Úreq_idr¨   ÚnoteÚreviewerrw   rD   r/   rp   s	            r   Úreview_payment_editr·   ¦   så  € à�\‰\×Ñ˜l¨BÓ/×5Ñ5Ó7€FØ�\‰\×Ñ˜h¨Ó+×1Ñ1Ó3€FØ�8‰8�G—L‘L×$Ñ$ \°2Ó6×<Ñ<Ó>Ó?ÀÀÐE€DØ�>‰>Ô˜vÐ-BÑBÜÐ&Ó'Ð'ä�w—|‘| W¨bÓ1Òa´W¸W¿\¹\È6ÐSUÓ5VÒaÐZa€HÜ	×	Ñ	Õ	Ü×&Ñ&×8Ñ8Ó:×AÑAÄSÈÃ[ÐAÓQ×WÑWÓYˆØˆ9ÜÐ,¨cÓ2÷ 
Ñ	ð �8‰8�yÒ ÜÐ<¸cÓB÷ 
Ñ	ð �YÓÜ!×)Ñ)×;Ñ;Ó=×AÑAÀQÇ\Á\ÐAÓRˆGÜ—<‘<×1Ñ1Ó3×7Ñ7¸7¿?¹?Ð7ÓKˆDØ—]‘]×*Ñ*¨g¯j©jÐ*Ó9×CÑCÄcÈ(ÃmÐCÓTÐUXÑYÒaÔ]aˆFØ˜Ÿ™Ñ$ t×'9Ñ'9Ò9Üð #Ø#'×#5Ñ#5°dÐ";¸2ð?ó @÷ 
Ñ	ð $%×#5Ñ#5ˆGÔ ØŸ\™\ˆGŒNØ%&×%9Ñ%9ˆGÔ"Ø�L‰LÒ'SˆLÔTÜ˜dÔ#à!'¨9Ò!4‘:¸*ˆŒØˆŒØ   #˜ˆŒÜ Ÿ™›ˆŒØ	�‰ÒSˆÔT÷1 
ô4 ‡K�KÐ! 1§8¡8°LÀ!Ç$Á$Ð3G€KÔHÜ 9à" iÒ/ð %VñMó Nð Nà5KñMó Nð N÷7 
Ð	ús!   Ã8AM'ÅM'Å9C5M'É8BM'Í'M0)i�  )%Ú__doc__Úloggingr   Údecimalr   r   Ú	django.dbr   Údjango.db.modelsr   Údjango.httpr	   Údjango.shortcutsr   Údjango.utilsr   Údjango.views.decorators.httpr   ÚNexusApp.modelsr   r   r   ÚNexusApp.utils.staff_scoper   Ú	getLoggerÚ__name__rk   r)   r   r2   rq   rx   r{   r~   r£   r¥   r·   © r   r   Ú<module>rÆ      s£   ðñó Ý ß -å !Ý  Ý $Ý #Ý !Ý 5ç AÑ AÝ 5à	ˆ×	Ñ	˜8Ó	$€Ùˆsƒ|€óYòEð ñ@aó ð@aòFòDò<òhòD`ð ñ%Nó ñ%Nr   