Ë
    — k—Y  ã                   ó,  — d dl Z d dlZd dlmZmZmZ d dlmZmZ d dlm	Z	 d dl
mZmZmZmZ d dlmZ d dlmZ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" d dl#m$Z$ d dl%m&Z&m'Z'm(Z( d dl)m*Z*m+Z+m,Z,m-Z-m.Z.m/Z/  ej`                  e1«      Z2 edd¬«      Z3 ed«      Z4d„ Z5d dl6m7Z8m9Z9m:Z; d5d„Z<d„ Z=d„ d„ d„ d„ d„ d„ dœZ>d „ Z?d!„ Z@ed"„ «       ZAd#„ ZBd$„ ZCd%„ ZDd&„ d'„ d(„ d)„ d*œZEd+„ ZFd,„ ZGd-„ ZHd.„ ZId/„ ZJd0„ ZKd1„ ZLd d2l)mMZMmNZNmOZOmPZP d3„ ZQd4„ ZRy)6é    N)ÚdateÚdatetimeÚ	timedelta)ÚDecimalÚInvalidOperation)Útransaction)ÚDecimalFieldÚQÚSumÚValue)ÚCoalesce)ÚHttp404ÚHttpResponseÚJsonResponse)Úget_object_or_404Úrender)Úreverse)Útimezone)Ú	urlencode)Úrequire_POST)ÚLoanÚLoanPayment)Ú
date_range)Úget_staff_loan_or_404Ústaff_loansÚstaff_payments)Ú	_in_rangeÚcollections_xlsxÚhistory_in_rangeÚhistory_xlsxÚloan_reports_xlsxÚpayments_in_rangeé   é   )Ú
max_digitsÚdecimal_placesÚ0c                 óH   — 	 t        | «      S # t        t        f$ r |cY S w xY w©N)ÚintÚ	TypeErrorÚ
ValueError)ÚvalueÚdefaults     úJ/var/www/html/nexus_chitfund_web/controllers/Staff/LoanreportController.pyÚ_intr0      s*   € ðÜ�5‹zÐøÜ”zÐ"ò ØŠðús   ‚
 �! !)Ú
add_monthsÚloan_positionÚnth_due_datec                 ó¢  — | j                   xs t        }| j                  xs t        }t        | ||«      }|d   }|d   }|d   }i d| j                  “d| j
                  “d| j                  “d| j                  j                  “d| j                  “d	t        | j                  «      “d
t        |«      “dt        |«      “dt        |«      “dt        | j                  «      “dt        |«      “d| j                  “d|“d| j                  |z
  “d|d   “dt        |d   «      “dt        |dz   | j                  «      “t        t        ||«      «      | j                  «       | j                   r| j                   j#                  d«      nd| j                   r| j                   j%                  «       nd|r|j#                  d«      nd|r|j%                  «       nd|d   t'        |dz   «      › dt)        | j                  | j                  j                  dœ«      › �t'        |dz   «      › d| j                  › �t'        |dz   «      › d| j                  › �d œ
¥S )!NÚbalanceÚ	paid_duesÚnext_dueÚloan_idÚcustomer_nameÚphone_numberÚplaceÚplace_idÚloan_amountÚpaid_amountÚpending_amountÚbalance_amountÚtotal_payableÚ
due_amountÚnumber_of_duesÚpending_duesÚpending_daysÚoverdue_amountÚoverdueÚ
due_numberé   z%d/%m/%YÚ-Ú Ústatusz:paid_due_historyÚ?)Úidr;   z:payment_invoicez?id=z:loan_period_report)
Úpayable_nowÚpayment_typeÚ	loan_dateÚloan_date_isoÚnext_due_dateÚnext_due_isorL   Úpaid_history_urlÚinvoice_urlÚperiod_report_url)rB   ÚZEROÚpaidr2   rN   r9   r:   r;   Únamer<   Úfloatr=   rA   rC   ÚminÚget_payment_type_displayrQ   ÚstrftimeÚ	isoformatr   r   )	ÚloanÚtodayÚnsrB   rY   Úposr5   r6   r7   s	            r/   Ú
_build_rowrd   ,   s~  € Ø—‘Ò(¤D€JØ�9‰9Òœ€DÜ
˜˜d EÓ
*€CØ�)‰n€GØ�KÑ €IØ�:‰€HðØ�4—7‘7ðà˜×+Ñ+ðð 	˜×)Ñ)ðð 	�—‘—‘ð	ð
 	�D—M‘Mðð 	”u˜T×-Ñ-Ó.ðð 	”u˜T“{ðð 	œ% ›.ðð 	œ% ›.ðð 	œ˜t×1Ñ1Ó2ðð 	”e˜JÓ'ðð 	˜$×-Ñ-ðð 	�Yðð 	˜×+Ñ+¨iÑ7ðð 	˜˜NÑ+ðð  	œ%  I¡Ó/ð!ð" 	”c˜) a™-¨×)<Ñ)<Ó=ð#ô$ œS ¨WÓ5Ó6Ø×5Ñ5Ó7Ø<@¿NºN�T—^‘^×,Ñ,¨ZÔ8ÐPSØ7;·~²~˜Ÿ™×1Ñ1Ô3È2Ù:B˜×*Ñ*¨:Ô6ÈÙ08˜×*Ñ*Ô,¸bØ�h‘-ä�rÐ/Ñ/Ó0Ð1°Ü §¡°$·*±*·/±/ÑBÓCÐDðFô " "Ð'9Ñ"9Ó:Ð;¸4ÀÇÁ¸yÐIÜ '¨Ð-BÑ(BÓ CÐDÀDÈÏÉÈ	ÐRò=ð ó    c                 óÈ  — | j                   j                  dd«      j                  «       }| j                   j                  dd«      j                  «       j                  «       }| j                   j                  dd«      j                  «       j                  «       }| j                   j                  dd«      j                  «       }t	        | «      \  }}t        | t        j                  j                  dd«      «      j                  t        t        d«      t        d«      t        ¬	«      ¬
«      }|r|j                  |¬«      }t        j                   «       }|j#                  d«      D �	cg c]  }	t%        |	|«      ‘Œ }
}	|
D �cg c]  }|d   dk7  r|‘Œ }
}t'        |
«      }|dv r%|
D �cg c]  }|d   j                  «       |k(  r|‘Œ }
}|r9|
D �cg c].  }||d   j                  «       v s||d   j                  «       v r|‘Œ0 }
}|r|
D �cg c]  }|d   |k(  r|‘Œ }
}|s|r |
D �cg c]  }t)        |d   ||«      sŒ|‘Œ }
}|
|fS c c}	w c c}w c c}w c c}w c c}w c c}w )zpApply place / search / payment-type / due-date filters.
    Completed loans are excluded from Loan Reports.
    r;   rK   úsearch[value]rP   Údue_dateÚcustomerÚpayments__amountr   ©Úoutput_field©rY   ©Úplace__name__iexactz-idrL   Ú	Completed)ÚdailyÚweeklyÚmonthlyr9   r:   rT   rR   )ÚGETÚgetÚstripÚlowerr   r   r   ÚobjectsÚselect_relatedÚannotater   r   r   ÚMONEYÚfilterr   Ú	localdateÚorder_byrd   Úlenr   )Úrequestr;   ÚsearchrP   rh   ÚstartÚendÚqsra   r`   ÚrowsÚrowÚtotals                r/   Ú_collect_rowsrˆ   w   s„  € ð
 �K‰K�O‰O˜G RÓ(×.Ñ.Ó0€EØ�[‰[�_‰_˜_¨bÓ1×7Ñ7Ó9×?Ñ?ÓA€FØ—;‘;—?‘? >°2Ó6×<Ñ<Ó>×DÑDÓF€LØ�{‰{�‰˜z¨2Ó.×4Ñ4Ó6€HÜ˜GÓ$�J€Eˆ3ä	�WœdŸl™l×9Ñ9¸'À:ÓNÓ	O×	XÑ	XÜÜÐ"Ó#Ü�!‹HÜô
ð 
Yó 
€Bñ Ø�Y‰Y¨5ˆYÓ1ˆä×ÑÓ €Eð
 —K‘K Ô&óá&ˆDô 	�4˜ÕØ&ð 	ð ñ óÙ�Øˆx‰=˜KÒ'ò 	�tð 	ð ô �‹I€Eð Ð5Ñ5áó
Ù�CØ�>Ñ"×(Ñ(Ó*¨lÒ:ò ˜4ð 	ð 
ñ áó
Ù�CØ˜˜_Ñ-×3Ñ3Ó5Ñ5Ø˜˜^Ñ,×2Ñ2Ó4Ñ4ò ˜4ð 	ð 
ñ áó
Ù�CØ�>Ñ" hÒ.ò ˜4ð 	ð 
ñ ‘Ù#ÓS™t˜¤y°°_Ñ1EÀuÈcÕ'R’˜tˆÐSà�ˆ;ÐùòQùòùò
ùò
ùò
ùò Ts*   Å*IÆIÆ)IÇ3IÈIÈ&IÈ<Ic                 ó(   — | d   j                  «       S )Nr9   )rw   ©Úrs    r/   Ú<lambda>rŒ   ½   s   € ��?Ñ#×)Ñ)Ô+re   c                 ó   — | d   S )Nr@   © rŠ   s    r/   rŒ   rŒ   ¾   ó
   € �Ð#Ò$re   c                 ó   — | d   S )Nr=   rŽ   rŠ   s    r/   rŒ   rŒ   ¿   s	   € ��=Ò!re   c                 ó   — | d   S )NrB   rŽ   rŠ   s    r/   rŒ   rŒ   À   s   € ��<’re   c                 ó   — | d   xs dS )NrT   z
9999-99-99rŽ   rŠ   s    r/   rŒ   rŒ   Á   s   € ��>Ñ"Ò2 lÐ2re   c                 ó   — | d   S )NrL   rŽ   rŠ   s    r/   rŒ   rŒ   Â   s   € ��8’re   )rI   r$   é   é   é   é   c           	      óL  — | j                   j                  d«      dk7  rt        dddœd¬«      S t        | j                  j                  d«      d	«      }	 t        t        | j                  j                  d
«      d«      d«      }t        | j                  j                  d«      d«      }t        | «      \  }}t        |«      }t        | j                  j                  d«      d«      }|t        v r7|j                  t        |   | j                  j                  dd«      dk(  ¬«       |dk(  r||d  n|||t        |d	«      z    }t        ||d	z   ¬«      D ]
  \  }	}
|	|
d<   Œ t        ||||dœ«      S # t        $ r+ t        j                  d«       t        |ddg ddœd¬«      cY S w xY w)Núx-requested-withÚXMLHttpRequestÚerrorúInvalid request.©rL   Úmessageé�  ©rL   ÚdrawrI   r‚   r   Úlengthé
   úorder[0][column]éÿÿÿÿúorder[0][dir]ÚascÚdesc©Úkeyr   ©r‚   ÚDT_RowIndex©r¡   ÚrecordsTotalÚrecordsFilteredÚdatazloan_reports_data failedzCould not load loan reports.©r¡   r®   r¯   r°   r›   éô  )Úheadersru   r   r0   rt   Úmaxrˆ   r   Ú	SORT_KEYSÚsortÚ	enumerateÚ	ExceptionÚloggerÚ	exception)r€   r¡   r‚   r¢   r…   r‡   ÚfilteredÚ	order_colÚpageÚir†   s              r/   Úloan_reports_datar¿   Æ   s�  € Ø‡�×ÑÐ-Ó.Ð2BÒBÜ wÐ;MÑNÐWZÔ[Ð[ä�—‘—‘ Ó'¨Ó+€DðÜ”D˜Ÿ™Ÿ™¨Ó1°1Ó5°qÓ9ˆÜ�g—k‘k—o‘o hÓ/°Ó4ˆä# GÓ,‰ˆˆeÜ�t“9ˆä˜Ÿ™Ÿ™Ð);Ó<¸bÓAˆ	Øœ	Ñ!Ø�I‰IÜ˜iÑ(ØŸ™Ÿ™¨¸Ó?À6ÑIð ô ð
  &¨š|ˆt�E�F‰|°°e¸EÄCÈÐPQÃNÑ<RÐ1SˆÜ ¨E°A©I×6‰FˆAˆsØ!"ˆC�Òð 7ô ØØ!Ø'Øñ	
ó ð 	øô ò Ü×ÑÐ3Ô4ÜØ¨!ÀÈ2Ø3ñ
ð ôò 	ðús   ÁDE/ Å/1F#Æ"F#c                 ó6   — t        | «      \  }}t        | |«      S )zHExcel of every loan (of the staff member's places) matching the filters.)rˆ   r!   )r€   r…   Ú_s      r/   Úloan_reports_exportrÂ   ì   s   € ä˜GÓ$�G€Dˆ!Ü˜W dÓ+Ð+re   c                 óŽ  — | j                   j                  dd«      j                  «       }| j                   j                  dd«      j                  «       }| j                   j                  dd«      j                  «       }| j                   j                  dd«      j                  «       j                  «       }| j                   j                  dd«      j                  «       j                  «       }i }|j	                  «       sd|d<   d}|sd	|d<   nA	 t        j                  |d
«      j                  «       }|t        j                  «       kD  rd|d<   d}|sd|d<   nI	 t        |«      }|j                  «       r|dk  rd|d<   n"||j                  t        d«      «      k7  rd|d<   |t        t         j"                  «      vrd|d<   |t        t         j$                  «      vrd|d<   |r1t'        dt)        t+        |j-                  «       «      «      |dœd¬«      S 	 t/        j0                  «       5  t3        | t4        j6                  j9                  «       «      j;                  t=        |«      ¬«      j?                  «       }	|	€t'        dddœd¬«      cddd«       S |	j@                  dk(  rt'        dddœd¬«      cddd«       S |	jB                  jE                  tG        d«      ¬«      d    xs tH        }
|	jJ                  |
z
  }||kD  r!t'        dd!|d"›d#�dd$idœd¬«      cddd«       S t         j6                  jM                  |	||tO        | d%d«      ||¬&«       ||z
  }|dk  r"d|	_         ||	_(        |	jS                  g d'¢¬(«       ddd«       tT        jW                  d)	jX                  t[        |«      d*œ¬+«       t'        d,t]        |	|
«      t_        |«      |dk  d-œ«      S # t        $ r	 d|d<   Y �Œ�w xY w# t        $ r	 d|d<   Y �Œ_w xY w# 1 sw Y   ŒˆxY w# t`        $ r( tT        jc                  d.«       t'        dd/dœd0¬«      cY S w xY w)1zFSave one collection (a LoanPayment row) from the Record Payment modal.r8   rK   Úpayment_dater>   Úpayment_methodÚpayment_statusz0Loan is missing. Close the window and try again.NzPayment date is required.z%Y-%m-%dz%Payment date cannot be in the future.z%Invalid date format (use YYYY-MM-DD).zPaid amount is required.r   z#Enter a valid positive paid amount.z0.01z.Paid amount can have at most 2 decimal places.zSelect a payment method.zSelect a payment status.r›   )rL   rž   ÚerrorsrŸ   r    ©ÚpkúLoan not found.r�   é”  Ú	completedzThis loan is already completed.Úamount)ÚsrÎ   u0   Paid amount is more than the pending amount (â‚¹z,.2fz).zAmount exceeds pending amount.Ústaff)r`   rÄ   rÍ   Úcollected_byrÅ   rÆ   )rL   Úclosed_dateÚ
updated_at)Úupdate_fieldszpayment recorded)r8   rÍ   )ÚextraÚsuccess)rL   rž   r?   Úloan_completedzrecord_payment failedz-Could not save the payment. Please try again.r²   )2ÚPOSTru   rv   rw   Úisdigitr   Ústrptimer   r   r}   r,   r   Ú	is_finiteÚquantizer   Údictr   ÚMETHOD_CHOICESÚPAYMENT_STATUS_CHOICESr   ÚnextÚiterÚvaluesr   Úatomicr   r   rx   Úselect_for_updater|   r*   ÚfirstrL   ÚpaymentsÚ	aggregater   rX   rA   ÚcreateÚgetattrrÑ   Úsaver¹   ÚinforN   ÚstrÚ_payment_messager[   r¸   rº   )r€   r8   rÄ   Ú
amount_rawÚmethodÚ
pay_statusrÇ   Úparsed_daterÍ   r`   Úpaid_so_farÚpendingÚnew_pendings                r/   Úrecord_paymentrô   ó   s0  € ð �l‰l×Ñ˜y¨"Ó-×3Ñ3Ó5€GØ—<‘<×#Ñ# N°BÓ7×=Ñ=Ó?€LØ—‘×!Ñ! -°Ó4×:Ñ:Ó<€JØ�\‰\×ÑÐ.°Ó3×9Ñ9Ó;×AÑAÓC€FØ—‘×!Ñ!Ð"2°BÓ7×=Ñ=Ó?×EÑEÓG€Jà€Fà�?‰?ÔØNˆˆyÑà€KÙØ!<ˆˆ~Òð	MÜ"×+Ñ+¨L¸*ÓE×JÑJÓLˆKØœX×/Ñ/Ó1Ò1Ø)P��~Ñ&ð €FÙØ :ˆˆ}Òð	JÜ˜ZÓ(ˆFØ×#Ñ#Ô%¨°1ªØ(M��}Ò%Ø˜6Ÿ?™?¬7°6«?Ó;Ò;Ø(X��}Ñ%ð ”Tœ+×4Ñ4Ó5Ñ5Ø#=ˆÐÑ Øœœk×@Ñ@ÓAÑAØ#=ˆÐÑ áÜØÜœD §¡£Ó1Ó2Øñ
ð ô	ð 	ð.Ü×ÑÕ!ä˜w¬¯©×(FÑ(FÓ(HÓI×PÑPÔTWÐX_ÓT`ÐPÓa×gÑgÓiˆDØˆ|Ü#¨wÐCTÑ$UÐ^aÔb÷	 "Ñ!ð
 �{‰{˜kÒ)Ü#Ø&Ð3TÑUÐ^aôc÷ "Ñ!ð Ÿ-™-×1Ñ1´C¸³MÐ1ÓBÀ3ÑGÒOÌ4ˆKØ×(Ñ(¨;Ñ6ˆGØ˜ÒÜ#Ø%Ø!TÐU\Ð]aÐTbÐbdÐeØ,Ð.NÐOñ%ð ô	÷ "Ñ!ô$ ×Ñ×&Ñ&ØØ(ØÜ$ W¨g°tÓ<Ø%Ø)ð 'ô ð " FÑ*ˆKØ˜aÒØ)�”Ø#.�Ô Ø—	‘	Ò(O�	ÔP÷? "ôB 	�‰Ð&¸$¿'¹'ÌSÐQWË[Ñ.YˆÔZÜØÜ'¨¨f°kÀ;ÓOÜ# KÓ0Ø)¨QÑ.ñ	
ó ð 	øô ò 	MØ%LˆF�>Ô"ð	Mûô  ò 	JØ$IˆF�=Ô!ð	Jú÷  "Ð!ûôR ò Ü×ÑÐ0Ô1ÜØÐ+ZÑ[Øôò 	ðúsx   ÄA O ÅAO2 ÈP È,A!PÊ	P ÊPÊ5	P Ê?APÌ	P Ì$APÎ AP ÏO/Ï.O/Ï2PÐPÐPÐP Ð.QÑQc                 ó¼   — t        | |t        j                  j                  dd«      j	                  t        t        d«      t        d«      t        ¬«      ¬«      «      S )zKThe loan (of the staff member's places) plus its total paid so far (.paid).r;   ri   rj   r   rk   rm   )	r   r   rx   ry   rz   r   r   r   r{   )r€   r8   s     r/   Ú_loan_with_paidrö   V  sP   € ä ØØÜ�‰×#Ñ# G¨ZÓ8×AÑAÜœ#Ð0Ó1´5¸³8Ì%ÔPð 	Bó 	
óð re   c                 óÔ  — t        | j                  j                  d«      j                  dd«      «      }| j                  xs t
        }| j                  }t        d„ |D «       t
        «      }g t
        }}t        |d¬«      D �]c  \  }}|dkD  r||z  nt
        }	|dkD  r||	z
  |z   n||j                  z   }
t        |
|«      }
t        |
|z
  t
        «      }t        ||j                  z
  t
        «      }t        |j                  |z
  t
        «      }||j                  z  }|j                  ||j                  j                  d«      |j                  j                  «       t!        |j                  «      |j#                  «       |j$                  r|j$                  j&                  nd	t!        |«      ||
k\  rd
ndt!        |«      |j(                  |j*                  |j,                  dœ«       �Œf |S )až  
    One row per payment, oldest first, with a running ledger so pending / extra
    can be shown per payment:

      need     = what was still owed on the current due just before this payment
      pending  = need - paid           (paid less than the due)
      extra    = paid - need           (paid ahead, goes to the next dues)

    A pending row shows "Cleared" once later payments have covered that due.
    rÐ   rÄ   rN   c              3   ó4   K  — | ]  }|j                   –— Œ y ­wr)   )rÍ   )Ú.0Úps     r/   Ú	<genexpr>z _history_rows.<locals>.<genexpr>q  s   è ø€ Ð1© 1�a—h•h©ùs   ‚rI   r«   r   z%d %B %YrJ   ÚYesÚNo)ÚsnorÄ   Úpayment_date_isoÚpaid_due_amountrÅ   rÐ   r?   Úpending_clearedÚextra_amountrN   Úcollected_by_idÚpayment_method_code)Úlistrå   ry   r~   rB   rX   rA   Úsumr·   rÍ   r\   r´   ÚappendrÄ   r^   r_   r[   Úget_payment_method_displayrÐ   rZ   rN   r  rÅ   )r`   rå   ÚduerA   Ú
final_paidr…   Úrunningr¾   rú   ÚdoneÚtargetÚneedrò   rÔ   s                 r/   Ú_history_rowsr  a  sš  € ô Ø�‰×$Ñ$ ^Ó4×=Ñ=¸nÈdÓSó€Hð �/‰/Ò
!œT€CØ×&Ñ&€MÜÑ1©Ó1´4Ó8€Jàœˆ'€DÜ˜(¨!×,Ð,‰ˆˆ1Ø"%¨¢'�˜#’¬tˆØ),¨qª�˜4‘ #Ò%°gÀÇÁÑ6HˆÜ�V˜]Ó+ˆÜ�6˜GÑ#¤TÓ*ˆä�d˜QŸX™X‘o¤tÓ,ˆÜ�A—H‘H˜t‘O¤TÓ*ˆØ�1—8‘8Ñˆà�‰ØØŸN™N×3Ñ3°JÓ?Ø !§¡× 8Ñ 8Ó :Ü$ Q§X¡X›Ø×:Ñ:Ó<Ø34·>²>˜AŸN™N×/Ò/ÀsÜ# G›nØ(2°fÒ(<™uÀ$Ü! %›LØ—$‘$Ø ×0Ñ0Ø#$×#3Ñ#3ñ
ö 	ð -ð0 €Kre   c           
      ód  — | j                   j                  dd«      j                  «       }|j                  «       st	        d«      ‚t        | t        |«      «      }t        |t        j                  «       «      }t        | d|||j                  j                  t        |j                  «      dœ«      S )z+Page: /staff/paid_due_history/?id=<loan id>rN   rK   zLoan not foundz staffpanel/paid_due_history.html)r`   ÚsummaryÚ
place_nameÚtotal_amount)rt   ru   rv   rØ   r   rö   r*   rd   r   r}   r   r;   rZ   r[   rA   )r€   r8   r`   r  s       r/   Úpaid_due_historyr  �  s‘   € à�k‰k�o‰o˜d BÓ'×-Ñ-Ó/€GØ�?‰?ÔÜÐ&Ó'Ð'ä˜7¤C¨£LÓ1€DÜ˜œx×1Ñ1Ó3Ó4€Gä�'Ð=ØØØ—j‘j—o‘oÜ˜d×0Ñ0Ó1ñ	@ó ð re   c                 ó   — | d   | d   fS )Nrÿ   rN   rŽ   rŠ   s    r/   rŒ   rŒ   ¡  s   € �!Ð&Ñ'¨¨4©Ñ1re   c                 ó   — | d   S )Nr   rŽ   rŠ   s    r/   rŒ   rŒ   ¢  s
   € �Ð$Ò%re   c                 ó   — | d   S )Nr?   rŽ   rŠ   s    r/   rŒ   rŒ   £  r�   re   c                 ó   — | d   S )Nr  rŽ   rŠ   s    r/   rŒ   rŒ   ¤  s	   € ��>Ò"re   )rI   r$   r”   r•   c                 ó  — | j                   j                  dd«      j                  «       }|j                  «       sy t	        | t        |«      «      }t        | t        |«      «      }| j                   j                  dd«      j                  «       j                  «       }|r^|D �cg c]S  }||d   j                  «       v s:||d   j                  «       v s%||d   j                  «       v s|t        |d   «      v r|‘ŒU }}||fS c c}w )NrN   rK   rg   rÄ   rÅ   rÐ   r   )
rt   ru   rv   rØ   r   r*   r   r  rw   rë   )r€   r8   r`   r…   r�   r‹   s         r/   Ú_history_filteredr  ¨  sü   € Ø�k‰k�o‰o˜d BÓ'×-Ñ-Ó/€GØ�?‰?ÔØÜ  ¬#¨g«,Ó7€DÜ˜G¤]°4Ó%8Ó9€Dà�[‰[�_‰_˜_¨bÓ1×7Ñ7Ó9×?Ñ?ÓA€FÙáó
Ù�!Ø˜˜>Ñ*×0Ñ0Ó2Ñ2Ø˜Ð+Ñ,×2Ñ2Ó4Ñ4Ø˜˜>Ñ*×0Ñ0Ó2Ñ2Øœ˜QÐ0Ñ1Ó2Ñ2ò	 �tð 	ð 
ð �ˆ:Ðùò
s   Â$ADc           	      ó¤  — | j                   j                  d«      dk7  rt        dddœd¬«      S t        | j                  j                  d«      d	«      }	 t        | «      }|€t        dd
dœd¬«      S |\  }}ddlm}  ||D �cg c]  }|d   ‘Œ	 c}«      }t        t        | dd «      dd «      }|D ]/  }|j                  |d   d«      |d<   |d   |k(  xr |d   dk7  |d<   Œ1 |j                  j                  «       }	t        |«      }
t        | j                  j                  d«      d«      }|t        v r8|j                  t        |   | j                  j                  dd«      dk(  ¬«       n|j                  «        t        t        | j                  j                  d«      d«      d«      }t        | j                  j                  d«      d«      }|dk(  r||d  n|||t        |d	«      z    }t        ||	|
|dœ«      S c c}w # t         $ r t        dddœd ¬«      cY S t"        $ r+ t$        j'                  d!«       t        |ddg d"d#œd$¬«      cY S w xY w)%Nr™   rš   r›   rœ   r�   rŸ   r    r¡   rI   úLoan is missing.r   )Úpending_edit_maprN   rÏ   rÉ   rK   Úedit_statusr  rò   Úcan_editr¤   r¥   r¦   r§   r¨   r©   r‚   r¢   r£   r­   rÊ   rË   zpaid_due_history_data failedzCould not load payment history.r±   r²   )r³   ru   r   r0   rt   r  Ú!controllers.PaymentEditControllerr  rè   rå   Úcountr   ÚHISTORY_SORT_KEYSr¶   r   r´   r   r¸   r¹   rº   )r€   r¡   Úresultr`   r…   r  r‹   Úedit_mapÚmer‡   r»   r¼   r‚   r¢   r½   s                  r/   Úpaid_due_history_datar&  »  sV  € Ø‡�×ÑÐ-Ó.Ð2BÒBÜ wÐ;MÑNÐWZÔ[Ð[ä�—‘—‘ Ó'¨Ó+€Dð,Ü" 7Ó+ˆØˆ>Ü¨7Ð?QÑ RÐ[^Ô_Ð_Ø‰
ˆˆdõ 	GÙ#±dÓ$;±d° Q t£W°dÑ$;Ó<ˆÜ”W˜W g¨tÓ4°d¸DÓAˆÛˆAØ'Ÿ|™|¨A¨d©G°RÓ8ˆAˆmÑØÐ/Ñ0°BÑ6ÒX¸1¸]Ñ;KÈyÑ;XˆAˆjŠMð ð —‘×#Ñ#Ó%ˆÜ�t“9ˆä˜Ÿ™Ÿ™Ð);Ó<¸bÓAˆ	ØÔ)Ñ)Ø�I‰IÜ% iÑ0ØŸ™Ÿ™¨¸Ó?À6ÑIð õ ð
 �L‰LŒNä”D˜Ÿ™Ÿ™¨Ó1°1Ó5°qÓ9ˆÜ�g—k‘k—o‘o hÓ/°Ó4ˆØ%¨š|ˆt�E�F‰|°°e¸EÄCÈÐPQÃNÑ<RÐ1SˆäØØ!Ø'Øñ	
ó ð 	ùò- %<øô: ò [Ü wÐ;LÑMÐVYÔZÒZÜò Ü×ÑÐ7Ô8ÜØ¨!ÀÈ2Ø6ñ
ð ôò 	ðús1   ÁH Á2H ÂG<ÂE,H Ç<H ÈIÈ0IÉIc                 óZ   — t        | «      }|€t        dd¬«      S |\  }}t        | ||«      S )Nr  rŸ   r    )r  r   r    )r€   r#  r`   r…   s       r/   Úpaid_due_history_exportr(  ï  s7   € Ü˜wÓ'€FØ€~ÜÐ.°sÔ;Ð;Ø�J€Dˆ$Ü˜  tÓ,Ð,re   c           	      óÈ   — t        | dd«      }|€ t        j                  j                  «       i fS t	        | t        | t        j                  j                  |¬«      «      «      S )zLThis staff member's own collections (of their places) inside the date range.rÏ   N)rÐ   )rè   r   rx   Únoner"   r   r|   )r€   rÏ   s     r/   Ú_my_paymentsr+  ø  s_   € ä�G˜W dÓ+€EØ€}Ü×"Ñ"×'Ñ'Ó)¨2Ð-Ð-ÜØ” ¬×)<Ñ)<×)CÑ)CÐQVÐ)CÓ)WÓXóZð Zre   c                 ó<   — t        | «      \  }}t        | ||d¬«      S )zKExcel of the staff member's collections in the selected payment-date range.Úmy_collections)Úfilename)r+  r   )r€   rå   Úpaid_maps      r/   Úcollections_exportr0    s#   € ä% gÓ.Ñ€HˆhÜ˜G X¨xÐBRÔSÐSre   c                 ó:  — t        | «      \  }}g }dx}x}}t        |d¬«      D �]>  \  }}|j                  }	t        |	j                  |j                  |	j                  d«      z
  d«      }
||j                  z  }|j                  dk(  r||j                  z  }n|j                  dk(  r||j                  z  }|j                  ||	j                  |	j                  |	j                  |	j                  j                  |	j                  «       |j                  «       |j                   j#                  «       t%        |j                  «      |j'                  «       t%        |
«      dœ«       �ŒA t)        |t%        |«      t%        |«      t%        |«      t+        |«      dœdœ«      S )	Nr   rI   r«   ÚcashÚupi)rþ   r8   ri   Úphoner;   rP   rÅ   rÄ   rÍ   rÆ   Úloan_balance)r‡   r2  r3  r!  )r°   r  )r+  r·   r`   r´   rA   ru   rN   rÍ   rÅ   r  r9   r:   r;   rZ   r]   r  rÄ   r_   r[   Úget_payment_status_displayr   r   )r€   rå   r/  r°   r‡   r2  r3  r¾   rú   r`   r5   s              r/   Útoday_collections_datar7    se  € ä% gÓ.Ñ€Hˆhà€DØÐ€EÐˆD�3Ü˜(¨!×,Ð,‰ˆˆ1Ø�v‰vˆÜ�d×(Ñ(¨8¯<©<¸¿¹ÀÓ+CÑCÀQÓGˆØ�—‘ÑˆØ×Ñ˜vÒ%Ø�A—H‘HÑ‰DØ×Ñ Ò&Ø�1—8‘8‰OˆCØ�‰ØØ—w‘wØ×*Ñ*Ø×&Ñ&Ø—Z‘Z—_‘_Ø ×9Ñ9Ó;Ø×:Ñ:Ó<ØŸN™N×4Ñ4Ó6Ü˜AŸH™H“oØ×:Ñ:Ó<Ü! '›Nñ
ö 	ð -ô, Øä˜5“\¬5°«;Ü˜“:¬¨D«	ñ
ñó ð re   c                 ó’  — t        | «      \  }}g }t        |d¬«      D �]  \  }}|j                  }t        |j                  |j                  |j                  d«      z
  d«      }|j                  ||j                  |j                  |j                  |j                  j                  |j                  r|j                  j                  nd|j                  «       |j                  «       |j                  j!                  «       t#        |j$                  «      t#        |«      |j&                  dk(  rdnddddœ«       �Œ t)        d	|i«      S )
NrI   r«   r   rJ   rÌ   rü   rý   )rþ   r8   ri   r4  r;   rÏ   rP   ÚpaymentrÄ   rÍ   r?   r  r  Úextra_clearedr°   )r+  r·   r`   r´   rA   ru   rN   r  r9   r:   r;   rZ   rÐ   r]   r  rÄ   r_   r[   rÍ   rÆ   r   )r€   rå   r/  r°   r¾   rú   r`   r5   s           r/   Úcollection_list_datar;  ,  s  € ä% gÓ.Ñ€Hˆhà€DÜ˜(¨!×,Ð,‰ˆˆ1Ø�v‰vˆÜ�d×(Ñ(¨8¯<©<¸¿¹ÀÓ+CÑCÀQÓGˆØ�‰ØØ—w‘wØ×*Ñ*Ø×&Ñ&Ø—Z‘Z—_‘_Ø,-¯NªN�Q—^‘^×(Ò(ÀØ ×9Ñ9Ó;Ø×3Ñ3Ó5ØŸN™N×4Ñ4Ó6Ü˜AŸH™H“oÜ# G›nØ()×(8Ñ(8¸KÒ(G™uÈTØØ!ñ
ö 	ð -ô& ˜ ˜Ó'Ð're   )Ú
_parse_dayrì   Úcollection_totalsÚperiod_report_payloadc           
      ó<  — t        | t        j                  j                  «       «      }| j                  j                  dd«      j                  «       }|r|j                  |¬«      }t        t        |t        | j                  j                  d«      «      «      «      S )zECollection cards on Loan Reports - only the staff member's locations.r;   rK   rn   r   )r   r   rx   Úallrt   ru   rv   r|   r   r=  r<  )r€   r„   r;   s      r/   Úloan_reports_summaryrA  L  sp   € ä	�WœdŸl™l×.Ñ.Ó0Ó	1€BØ�K‰K�O‰O˜G RÓ(×.Ñ.Ó0€EÙØ�Y‰Y¨5ˆYÓ1ˆÜÔ)¨"¬j¸¿¹¿¹ÈÓ9PÓ.QÓRÓSÐSre   c                 ó‚  — | j                   j                  dd«      j                  «       }|j                  «       st	        dddœd¬«      S t        | t        j                  j                  d«      «      j                  t        |«      ¬	«      j                  «       }|€t	        dd
dœd¬«      S t	        t        |«      «      S )NrN   rK   r›   r  r�   rŸ   r    ri   rÈ   rÊ   rË   )rt   ru   rv   rØ   r   r   r   rx   ry   r|   r*   rä   r>  )r€   r8   r`   s      r/   Úloan_period_reportrC  U  s    € Ø�k‰k�o‰o˜d BÓ'×-Ñ-Ó/€GØ�?‰?ÔÜ wÐ;MÑNÐWZÔ[Ð[Ü�w¤§¡× ;Ñ ;¸JÓ GÓH×OÑOÔSVÐW^ÓS_ÐOÓ`×fÑfÓh€DØ€|Ü wÐ;LÑMÐVYÔZÐZÜÔ-¨dÓ3Ó4Ð4re   )rÏ   )SÚcalendarÚloggingr   r   r   Údecimalr   r   Ú	django.dbr   Údjango.db.modelsr	   r
   r   r   Údjango.db.models.functionsr   Údjango.httpr   r   r   Údjango.shortcutsr   r   Údjango.urlsr   Údjango.utilsr   Úurllib.parser   Údjango.views.decorators.httpr   ÚNexusApp.modelsr   r   ÚNexusApp.utils.excelr   ÚNexusApp.utils.staff_scoper   r   r   Ú+controllers.Admin.AdminloanreportControllerr   r   r   r    r!   r"   Ú	getLoggerÚ__name__r¹   r{   rX   r0   ÚNexusApp.utils.loan_scheduler1   Ú_add_monthsr2   r3   Ú_nth_due_daterd   rˆ   rµ   r¿   rÂ   rô   rö   r  r  r"  r  r&  r(  r+  r0  r7  r;  r<  rì   r=  r>  rA  rC  rŽ   re   r/   Ú<module>rY     s/  ðÛ Û ß .Ñ .ß -å !ß 8Ó 8Ý /ß ;Ñ ;ß 6Ý Ý !Ý "Ý 5ç -Ý +ß YÑ Y÷÷ ð
 
ˆ×	Ñ	˜8Ó	$€á °1Ô5€Ùˆsƒ|€ò÷ñ ó
'òVAñL ,Ù$Ù!Ù Ù2Ùñ€	ò#òL,ð ñ_ó ð_òDò+ò\ñ$ 2Ù%Ù$Ù"ñ	Ð òò&1òh-òZòTò"òJ(÷6ó ò
Tó5re   