Ë
    1 k‹o  ã                   óF  — 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$m%Z%m&Z&  ejN                  e(«      Z) edd¬«      Z* ed«      Z+d„ Z,d„ Z-d dl.m/Z0m1Z1m2Z3 d@d„Z4d„ Z5d„ d„ d„ d„ d„ d„ dœZ6d„ Z7g d ¢Z8d!„ Z9d"„ Z:ed#„ «       Z;d$„ Z<d%„ Z=d&„ Z>d'„ d(„ d)„ d*„ d+œZ?d,„ Z@g d-¢ZAd.„ ZBd/„ ZCd0„ ZDd1„ ZEd2„ ZFdAd3„ZGd4„ ZHg d5¢ZIdBd6„ZJd7„ ZKd8„ ZLd9„ ZMd:„ ZNd;„ ZOd<„ ZPd=„ ZQd>„ ZRd?„ ZSy)Cé    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Úrange_labelÚxlsx_responseé   é   )Ú
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     úO/var/www/html/nexus_chitfund_web/controllers/Admin/AdminloanreportController.pyÚ_intr)      s*   € ðÜ�5‹zÐøÜ”zÐ"ò ØŠðús   ‚
 �! !c                 óv   — |s|sy| sy| xs | |j                  «       k\  xr | xs | |j                  «       k  S )zOTrue when the ISO date string `iso` is inside [start, end] (open ends allowed).TF)Ú	isoformat)ÚisoÚstartÚends      r(   Ú	_in_ranger/   !   s@   € á‘SØÙØØˆIÒ1˜ §¡Ó 1Ñ1ÒZ¸C¸Ò8YÀ3È#Ï-É-Ë/ÑCYÐZó    )Ú
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   Ústrftimer+   r   r   )	ÚloanÚtodayÚnsrB   rY   Úposr5   r6   r7   s	            r(   Ú
_build_rowrc   0   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ò=ð r0   c                 óº  — | j                   j                  dd«      j                  «       }t        | «      \  }}| j                   j                  dd«      j                  «       j	                  «       }| j                   j                  dd«      j                  «       j	                  «       }| j                   j                  dd«      j                  «       }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  sŒ|‘Œ }
}t%        |
«      }|dv r&|
D �cg c]  }|d   j	                  «       |k(  sŒ|‘Œ }
}|r9|
D �cg c].  }||d   j	                  «       v s||d   j	                  «       v r|‘Œ0 }
}|r|
D �cg c]  }|d   |k(  sŒ|‘Œ }
}|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 )z‚Apply place / search / payment-type / due-date / loan-date range filters.
    Completed loans are excluded from Loan Reports.
    r;   rK   úsearch[value]rP   Údue_dateÚcustomerÚpayments__amountr   ©Úoutput_field©rY   ©Úplace__name__iexactú-idrL   Ú	Completed)ÚdailyÚweeklyÚmonthlyr9   r:   rT   rR   )ÚGETÚgetÚstripr   Úlowerr   ÚobjectsÚselect_relatedÚannotater   r   r   ÚMONEYÚfilterr   Ú	localdateÚorder_byrc   Úlenr/   )Úrequestr;   r-   r.   ÚsearchrP   rf   Úqsr`   r_   ÚrowsÚrowÚtotals                r(   Ú_collect_rowsr…   Z   sB  € ð �K‰K�O‰O˜G RÓ(×.Ñ.Ó0€EÜ˜GÓ$�J€Eˆ3Ø�[‰[�_‰_˜_¨bÓ1×7Ñ7Ó9×?Ñ?ÓA€FØ—;‘;—?‘? >°2Ó6×<Ñ<Ó>×DÑDÓF€LØ�{‰{�‰˜z¨2Ó.×4Ñ4Ó6€Hä	�‰×	$Ñ	$ W¨jÓ	9×	BÑ	BÜ”cÐ,Ó-¬u°Q«xÄeÔLð 
Có 
€Bñ Ø�Y‰Y¨5ˆYÓ1ˆä×ÑÓ €Eð 13·±¸EÔ0BÓCÑ0B¨ŒJ�t˜UÕ#Ð0B€DÐCÙÓ@™4�C 3 x¡=°KÓ#?ŠC˜4€DÐ@ô �‹I€EàÐ5Ñ5Ù#ÓS™t˜ s¨>Ñ':×'@Ñ'@Ó'BÀlÓ'R’˜tˆÐSááó
Ù�CØ˜˜_Ñ-×3Ñ3Ó5Ñ5Ø˜˜^Ñ,×2Ñ2Ó4Ñ4ò ˜4ð 	ð 
ñ Ù#ÓG™t˜ s¨>Ñ':¸hÓ'F’˜tˆÐGá‘Ù#ÓS™t˜¤y°°_Ñ1EÀuÈcÕ'R’˜tˆÐSà�ˆ;Ðùò- DùÚ@ùò Tùò
ùò Hùò Ts<   Å H?Å9IÆIÆ I	Æ<I	Ç3IÈIÈIÈIÈ5Ic                 ó(   — | d   j                  «       S )Nr9   )rv   ©Úrs    r(   Ú<lambda>r‰   ‰   s   € ��?Ñ#×)Ñ)Ô+r0   c                 ó   — | d   S )Nr@   © r‡   s    r(   r‰   r‰   Š   ó
   € �Ð#Ò$r0   c                 ó   — | d   S )Nr=   r‹   r‡   s    r(   r‰   r‰   ‹   s	   € ��=Ò!r0   c                 ó   — | d   S )NrB   r‹   r‡   s    r(   r‰   r‰   Œ   s   € ��<’r0   c                 ó   — | d   xs dS )NrT   z
9999-99-99r‹   r‡   s    r(   r‰   r‰   �   s   € ��>Ñ"Ò2 lÐ2r0   c                 ó   — | d   S )NrL   r‹   r‡   s    r(   r‰   r‰   Ž   s   € ��8’r0   )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admin_loan_reports_data failedzCould not load loan reports.©rž   r«   r¬   r­   r˜   éô  )Úheadersrt   r   r)   rs   Úmaxr…   r~   Ú	SORT_KEYSÚsortÚ	enumerateÚ	ExceptionÚloggerÚ	exception)r   rž   r-   rŸ   r‚   r„   ÚfilteredÚ	order_colÚpageÚirƒ   s              r(   Úadmin_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ô ØØ!Ø'Øñ	
ó ð 	øô ò Ü×ÑÐ9Ô:ÜØ¨!ÀÈ2Ø3ñ
ð ôò 	ðús   ÁDE/ Å/1F#Æ"F#)úS.NoúPaid AmountzBalance AmountzPending DaysúCustomer NameÚPhonezLoan AmountzTotal PayablezNumber of Duesz
Due AmountúPayment Typez	Paid DueszPending DueszNext Due DateÚStatusc                 ó2  — | j                   j                  dd«      j                  «       }t        | «      \  }}t	        |d¬«      D ��cg c]@  \  }}||d   |d   |d   |d   |d	   |d
   |d   |d   |d   |d   |d   |d   |d   |d   g‘ŒB }}}dt        d„ |D «       «      t        d„ |D «       «      dddt        d„ |D «       «      t        d„ |D «       «      g}t        d|xs d› �dt        ||xs d› dt        ||«      › �|r|¬«      S d¬«      S c c}}w )z>Excel of the Loan Reports rows (same columns the old CSV had).r;   rK   rI   r¨   r>   r@   rE   r9   r:   r=   rA   rC   rB   rP   r6   rD   rS   rL   ÚTotalc              3   ó&   K  — | ]	  }|d    –— Œ y­w)r>   Nr‹   ©Ú.0rˆ   s     r(   Ú	<genexpr>z$loan_reports_xlsx.<locals>.<genexpr>É   s   è ø€ Ð:±T°˜1˜]Õ+±Tùó   ‚c              3   ó&   K  — | ]	  }|d    –— Œ y­w)r@   Nr‹   rÆ   s     r(   rÈ   z$loan_reports_xlsx.<locals>.<genexpr>É   s   è ø€ Ð?bÑ]aÐXYÀÐBRÕ@SÑ]aùrÉ   c              3   ó&   K  — | ]	  }|d    –— Œ y­w)r=   Nr‹   rÆ   s     r(   rÈ   z$loan_reports_xlsx.<locals>.<genexpr>Ê   s   è ø€ Ð=¹°1˜a Õ.¹ùrÉ   c              3   ó&   K  — | ]	  }|d    –— Œ y­w)rA   Nr‹   rÆ   s     r(   rÈ   z$loan_reports_xlsx.<locals>.<genexpr>Ê   s   è ø€ ÐBdÑ_cÐZ[À1À_ÕCUÑ_cùrÉ   Úloan_reports_ÚallzLoan Reportsz
All Placesz - Loan date: N©ÚsubtitleÚtotals)	rs   rt   ru   r   r´   Úsumr   ÚLOAN_REPORT_HEADERSr   )	r   r‚   r;   r-   r.   r»   rˆ   ÚbodyrÑ   s	            r(   Úloan_reports_xlsxrÕ   ¿   sk  € à�K‰K�O‰O˜G RÓ(×.Ñ.Ó0€EÜ˜GÓ$�J€Eˆ3ô ˜D¨Õ*ô,ñ
 +‰$ˆ!ˆQð	 	
ˆ1ˆ]Ñ˜QÐ/Ñ0°!°NÑ2CØ	ˆ/Ñ˜A˜nÑ-Ø	ˆ-Ñ˜!˜OÑ,¨aÐ0@Ñ.AÀ1À\Á?ÐTUÐVdÑTeØ	ˆ+‰˜˜.Ñ)¨1¨_Ñ+=¸qÀ¹{ò	ð
 +ð 	ñ ,ð ”sÑ:±TÓ:Ó:¼CÑ?bÑ]aÓ?bÓ<bØ�"�bœ#Ñ=¹Ó=Ó=¼sÑBdÑ_cÓBdÓ?dðf€FäØ
˜š Ð'Ð(¨.Ô:MÈtØÒ)˜\Ð*¨.¼ÀUÈCÓ9PÐ8QÐRÙˆvô)ð )ð $(ô)ð )ùó,s   Á	ADc                 ó6   — t        | «      \  }}t        | |«      S r"   )r…   rÕ   )r   r‚   Ú_s      r(   Úadmin_loan_reports_exportrØ   Ñ   s   € Ü˜GÓ$�G€Dˆ!Ü˜W dÓ+Ð+r0   c           	      ód  — | 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  t2        j4                  j7                  «       j9                  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 |	j@                  jC                  tE        d«      ¬«      d    xs tF        }
|	jH                  |
z
  }||kD  r!t'        dd!|d"›d#�dd$idœd¬«      cddd«       S t         j4                  jK                  |	||d||¬%«       ||z
  }|dk  r"d|	_        ||	_&        |	jO                  g d&¢¬'«       ddd«       tP        jS                  d(	jT                  tW        |«      d)œ¬*«       t'        d+tY        |	|
«      t[        |«      |dk  d,œ«      S # t        $ r	 d|d<   Y �Œˆw xY w# t        $ r	 d|d<   Y �ŒJw xY w# 1 sw Y   ŒˆxY w# t\        $ r( tP        j_                  d-«       t'        dd.dœd/¬«      cY S w xY w)0zFSave 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.ú%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 (â‚¹ú,.2fz).zAmount exceeds pending amount.)r_   rÚ   rä   Úcollected_byrÛ   rÜ   )rL   Úclosed_dateÚ
updated_at)Úupdate_fieldszpayment recorded)r8   rä   )ÚextraÚsuccess)rL   r›   r?   Úloan_completedzadmin_record_payment failedz-Could not save the payment. Please try again.r¯   )0ÚPOSTrt   ru   rv   Úisdigitr   Ústrptimer   r   r|   r%   r   Ú	is_finiteÚquantizer   Údictr   ÚMETHOD_CHOICESÚPAYMENT_STATUS_CHOICESr   ÚnextÚiterÚvaluesr   Úatomicr   rw   Úselect_for_updater{   r#   ÚfirstrL   ÚpaymentsÚ	aggregater   rX   rA   Úcreateré   Ú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(   Úadmin_record_paymentr  ×   s  € ð �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Øñ
ð ô	ð 	ð/Ü×ÑÕ!ä—<‘<×1Ñ1Ó3×:Ñ:¼cÀ'»lÐ:ÓK×QÑQÓSˆ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ñ%ð ô	÷ "Ñ!ô& ×Ñ×&Ñ&ØØ(ØØ!Ø%Ø)ð 'ô ð " FÑ*ˆKØ˜aÒØ)�”Ø#.�Ô Ø—	‘	Ò(O�	ÔP÷A "ôD 	�‰Ð&¸$¿'¹'ÌSÐQWË[Ñ.YˆÔZÜØÜ'¨¨f°kÀ;ÓOÜ# KÓ0Ø)¨QÑ.ñ	
ó ð 	øôA ò 	MØ%LˆF�>Ô"ð	Mûô  ò 	JØ$IˆF�=Ô!ð	Jú÷  "Ð!ûôT ò Ü×ÑÐ6Ô7ÜØÐ+ZÑ[Øôò 	ðúsx   ÄA O ÅAO ÈO> È,AO2Ê	O> ÊO2Ê+	O> Ê5AO2Ì	O> ÌAO2Í+AO> ÏOÏOÏO/Ï.O/Ï2O;Ï7O> Ï>.P/Ð.P/c           
      ó¼   — t        t        j                  j                  dd«      j	                  t        t        d«      t        d«      t        ¬«      ¬«      | ¬«      S )z9The loan plus its total paid so far (annotated as .paid).r;   rg   rh   r   ri   rk   rß   )	r   r   rw   rx   ry   r   r   r   rz   )r8   s    r(   Ú_loan_with_paidr  <  sO   € äÜ�‰×#Ñ# G¨ZÓ8×AÑAÜœ#Ð0Ó1´5¸³8Ì%ÔPð 	Bó 	
ð ô	ð r0   c                 ó¨  — t        | j                  j                  d«      j                  dd«      «      }| j                  xs t
        }| j                  }t        d„ |D «       t
        «      }g t
        }}t        |d¬«      D �]M  \  }}|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(                  dœ
«       �ŒP |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ä   ©rÇ   Úps     r(   rÈ   z _history_rows.<locals>.<genexpr>V  s   è ø€ Ð1© 1�a—h•h©ùó   ‚rI   r¨   r   z%d %B %YrJ   ÚYesÚNo)
ÚsnorÚ   Úpayment_date_isoÚpaid_due_amountrÛ   rè   r?   Úpending_clearedÚextra_amountrN   )Úlistrý   rx   r}   rB   rX   rA   rÒ   r´   rä   r\   r±   ÚappendrÚ   r^   r+   r[   Úget_payment_method_displayrè   rZ   rN   )r_   rý   ÚduerA   Ú
final_paidr‚   Úrunningr»   r  ÚdoneÚtargetÚneedr	  rì   s                 r(   Ú_history_rowsr$  F  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Ø—$‘$ñ
ö 	ð -ð, €Kr0   c           
      ób  — | j                   j                  dd«      j                  «       }|j                  «       st	        d«      ‚t        t        |«      «      }t        |t        j                  «       «      }t        | d|||j                  j                  t        |j                  «      dœ«      S )z+Page: /admin/paid_due_history/?id=<loan id>rN   rK   zLoan not foundz adminpanel/paid_due_history.html)r_   ÚsummaryÚ
place_nameÚtotal_amount)rs   rt   ru   rð   r   r  r#   rc   r   r|   r   r;   rZ   r[   rA   )r   r8   r_   r&  s       r(   Úadmin_paid_due_historyr)  r  s�   € à�k‰k�o‰o˜d BÓ'×-Ñ-Ó/€GØ�?‰?ÔÜÐ&Ó'Ð'äœ3˜w›<Ó(€DÜ˜œx×1Ñ1Ó3Ó4€Gä�'Ð=ØØØ—j‘j—o‘oÜ˜d×0Ñ0Ó1ñ	@ó ð r0   c                 ó   — | d   | d   fS )Nr  rN   r‹   r‡   s    r(   r‰   r‰   „  s   € �!Ð&Ñ'¨¨4©Ñ1r0   c                 ó   — | d   S )Nr  r‹   r‡   s    r(   r‰   r‰   …  s
   € �Ð$Ò%r0   c                 ó   — | d   S )Nr?   r‹   r‡   s    r(   r‰   r‰   †  rŒ   r0   c                 ó   — | d   S )Nr  r‹   r‡   s    r(   r‰   r‰   ‡  s	   € ��>Ò"r0   )rI   r   r‘   r’   c                 ót   — t        | «      \  }}|s|r |D �cg c]  }t        |d   ||«      sŒ|‘Œ }}|S c c}w )z”Keep the payments whose payment_date is inside from_date / to_date.
    The ledger is built on every payment first, so pending / extra stay correct.r  )r   r/   )r   r‚   r-   r.   rˆ   s        r(   Úhistory_in_ranger/  ‹  sG   € ô ˜GÓ$�J€Eˆ3Ù‘ÙÓP™4�a¤9¨QÐ/AÑ-BÀEÈ3Õ#O’˜4ˆÐPØ€Kùò Qs   —5­5)r½   úPayment Dater¾   úPayment MethodúCollected ByzPending AmountzPending ClearedzExtra Amountc                 óH  — t        | «      \  }}|D �cg c]$  }|d   |d   |d   |d   |d   |d   |d   |d   g‘Œ& }}|rd	d
t        d„ |D «       «      gnd }t        d|j                  › �dt        ||j
                  › d|j                  › dt        ||«      › �|¬«      S c c}w )Nr  rÚ   r  rÛ   rè   r?   r  r  rÄ   rK   c              3   ó&   K  — | ]	  }|d    –— Œ y­w)r  Nr‹   rÆ   s     r(   rÈ   zhistory_xlsx.<locals>.<genexpr>ž  s   è ø€ ÐB¹T¸˜qÐ!2Õ3¹TùrÉ   Úpayment_history_loan_zPayment Historyz (Loan #z) - Payment date: rÏ   )r   rÒ   r   rN   ÚHISTORY_HEADERSr9   r   )r   r_   r‚   r-   r.   rˆ   rÔ   rÑ   s           r(   Úhistory_xlsxr7  ˜  sé   € Ü˜GÓ$�J€Eˆ3ñ óñ ˆ!ð 	
ˆ%‰�!�NÑ# QÐ'8Ñ%9¸1Ð=MÑ;NØ	ˆ.Ñ˜1Ð-Ñ.°Ð2CÑ0DÀaÈÑFWòð ð 	ð ñ HLˆg�rœ3ÑB¹TÓBÓBÑCÐQU€FÜØ
 §¡˜yÐ)Ð+<¼oÈtØ×&Ñ&Ð' x°·±¨yÐ8JÌ;ÐW\Ð^aÓKbÐJcÐdØôð ùòs   “)Bc                 ó  — | j                   j                  dd«      j                  «       }|j                  «       sy t	        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   rß   re   rÚ   rÛ   rè   r  )rs   rt   ru   rð   r   r   r#   r/  r$  rv   r  )r   r8   r_   r‚   r€   rˆ   s         r(   Ú_history_filteredr9  ¥  sü   € Ø�k‰k�o‰o˜d BÓ'×-Ñ-Ó/€GØ�?‰?ÔØÜœT¤c¨'£lÔ3€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 |\  }}|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 # 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¡   r¢   r£   r¤   r¥   r¦   r-   r   rŸ   r    rª   rá   râ   z"admin_paid_due_history_data failedzCould not load payment history.r®   r¯   )r°   rt   r   r)   rs   r9  rý   Úcountr~   ÚHISTORY_SORT_KEYSr³   r   r±   r   rµ   r¶   r·   )r   rž   Úresultr_   r‚   r„   r¸   r¹   r-   rŸ   rº   s              r(   Úadmin_paid_due_history_datar?  ¸  sÏ  € Ø‡�×ÑÐ-Ó.Ð2BÒBÜ wÐ;MÑNÐWZÔ[Ð[ä�—‘—‘ Ó'¨Ó+€Dð$Ü" 7Ó+ˆØˆ>Ü¨7Ð?QÑ RÐ[^Ô_Ð_Ø‰
ˆˆdà—‘×#Ñ#Ó%ˆÜ�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Üò Ü×ÑÐ=Ô>ÜØ¨!ÀÈ2Ø6ñ
ð ôò 	ðús   ÁF Á2DF ÆGÆ,0GÇGc                 óZ   — t        | «      }|€t        dd¬«      S |\  }}t        | ||«      S )Nr;  rœ   r�   )r9  r   r7  )r   r>  r_   r‚   s       r(   Úadmin_paid_due_history_exportrA  ä  s7   € Ü˜wÓ'€FØ€~ÜÐ.°sÔ;Ð;Ø�J€Dˆ$Ü˜  tÓ,Ð,r0   c                 ó^  — t        j                  «       }t        | «      \  }}|sS|sQ	 t        j                  | j
                  j                  dd«      j                  «       d«      j                  «       }||fS |r|st        ||«      }|xs |}||k  r||fS ||fS # t        $ r |}Y ||fS w xY w)a)  (start, end) payment dates for the collection pages.

    from_date / to_date pick a range. Only From given = From .. today (or just From
    when it is in the future); only To given = that one day. The old single
    ?date=YYYY-MM-DD still works when no range is given. Default = today only.
    r   rK   rÝ   )r   r|   r   r   rñ   rs   rt   ru   r   r%   r±   )r   r`   r-   r.   Údays        r(   Úcollection_rangerD  í  sº   € ô ×ÑÓ €EÜ˜GÓ$�J€Eˆ3Ù‘Sð	Ü×#Ñ# G§K¡K§O¡O°F¸BÓ$?×$EÑ$EÓ$GÈÓT×YÑYÓ[ˆCð �CˆxˆÙ‘SÜ�%˜ÓˆØŠL�S€EØ  Cš<ˆE�3ˆ<Ð9¨c°5¨\Ð9øô ò 	Ø‰CØ�Cˆxˆð	ús   ¨AB ÂB,Â+B,c                 óÄ  — t        | «      \  }}|€t        j                  j                  «       n|j	                  ||f¬«      j                  ddd«      j                  dd«      }| j                  j                  dd«      j                  «       }|rO|j	                  t        |¬	«      t        |¬
«      z  t        |¬«      z  t        |¬«      z  t        |¬«      z  «      }|D �ch c]  }|j                  ’Œ }}t        t        j                  j	                  |¬«      j                  d«      j                  t        d«      ¬«      j!                  dd«      «      }||fS c c}w )zSPayments inside the collection range (+ optional ?search=) and the paid-so-far map.)Úpayment_date__rangeÚloan__placeÚloan__customerrè   z-payment_datern   r€   rK   )Ú(loan__customer__customer_name__icontains)Ú'loan__customer__phone_number__icontains)Úloan__place__name__icontains)Úcollected_by__name__icontains)Úpayment_method__icontains)Úloan_id__inr8   rä   rå   ræ   )rD  r   rw   rÎ   r{   rx   r}   rs   rt   ru   r
   r8   rô   rù   ry   r   Úvalues_list)	r   Úbase_qsr-   r.   rý   r€   r  Úloan_idsÚpaid_maps	            r(   Úpayments_in_rangerS    s;  € ä! 'Ó*�J€Eˆ3à&- oŒ×	Ñ	×	 Ñ	 Ô	"¸7ß	‰ U¨C LˆÓ	1ß	‰˜Ð'7¸Ó	Hß	‰�/ 5Ó	)ð	 ð �[‰[�_‰_˜X rÓ*×0Ñ0Ó2€FÙØ—?‘?Ü°vÔ>Ü¸Ô?ñ@ä¨VÔ4ñ5ô ¨fÔ5ñ6ô ¨&Ô1ñ	2ó
ˆñ $,Ó,¡8˜a�—	“	 8€HÐ,ÜÜ×Ñ×"Ñ"¨xÐ"Ó8ß	‰�	Ó	Ÿ8™8¤c¨(£m˜8Ó4ß	‰�Y Ó	$ó€Hð
 �XÐÐùò -s   Ã#Ec                 ó   — t        | «      S )zTAll staff collections in the selected range (default today). Admin sees every staff.)rS  )r   s    r(   Ú_payments_for_dayrU    s   € ä˜WÓ%Ð%r0   )r½   r0  r¿   rÀ   ÚPlacer2  rÁ   r1  ÚAmountzPayment StatuszLoan Balancec                 óÒ  — t        | «      \  }}g t        }}t        |d¬«      D �]  \  }}	|	j                  }
||	j                  z  }|j                  ||	j                  j                  d«      |
j                  |
j                  |
j                  j                  |	j                  r|	j                  j                  nd|
j                  «       |	j                  «       |	j                  |	j                  «       t!        |
j"                  |j%                  |
j&                  t        «      z
  t        «      g«       �Œ t)        |dt*        |dt-        ||«      › �|rdddddddd|g	¬	«      S d ¬	«      S )
NrI   r¨   z%d-%m-%YÚAdminÚCollectionszPayment date: rÄ   rK   rÏ   )rD  rX   r´   r_   rä   r  rÚ   r^   r9   r:   r;   rZ   rè   r]   r  Úget_payment_status_displayr±   rA   rt   rN   r   ÚCOLLECTION_HEADERSr   )r   rý   rR  Úfilenamer-   r.   rÔ   r„   r»   r  r_   s              r(   Úcollections_xlsxr^  (  sA  € Ü! 'Ó*�J€Eˆ3Ø”dˆ%€DÜ˜(¨!×,Ð,‰ˆˆ1Ø�v‰vˆØ�—‘ÑˆØ�‰Øˆq�~‰~×&Ñ& zÓ2°D×4FÑ4FÈ×HYÑHYØ�J‰J�O‰O°A·N²N˜QŸ^™^×0Ò0ÈØ×)Ñ)Ó+¨Q×-IÑ-IÓ-KÈQÏXÉXØ×(Ñ(Ó*Ü�×"Ñ" X§\¡\°$·'±'¼4Ó%@Ñ@Ä$ÓGð
ö 	ð -ô Ø�-Ô!3°TØ!¤+¨e°SÓ"9Ð!:Ð;Ù?C�˜˜R  R¨¨R°°UÐ;ôOð Oð JNôOð Or0   c                 ó8   — t        | «      \  }}t        | ||«      S r"   )rS  r^  )r   rý   rR  s      r(   Úadmin_collections_exportr`  ;  s    € Ü*¨7Ó3Ñ€HˆhÜ˜G X¨xÓ8Ð8r0   c                 ó˜  — t        | «      \  }}g }t        x}x}}t        |d¬«      D �]i  \  }}|j                  }	t	        |	j
                  |j                  |	j                  t        «      z
  t        «      }
||j                  z  }|j                  dk(  r||j                  z  }n|j                  dk(  r||j                  z  }|j                  ||	j                  |	j                  |	j                  |	j                  j                  |j                  r|j                  j                  nd|	j!                  «       |j#                  «       |j$                  j'                  «       t)        |j                  «      |j+                  «       t)        |
«      dœ«       �Œl t-        |t)        |«      t)        |«      t)        |«      t/        |«      dœdœ«      S )	NrI   r¨   ÚcashÚupirJ   )r  r8   rg   Úphoner;   ÚstaffrP   rÛ   rÚ   rä   rÜ   Úloan_balance)r„   rb  rc  r<  )r­   r&  )rU  rX   r´   r_   r±   rA   rt   rN   rä   rÛ   r  r9   r:   r;   rZ   rè   r]   r  rÚ   r+   r[   r[  r   r~   )r   rý   rR  r­   r„   rb  rc  r»   r  r_   r5   s              r(   Úadmin_today_collections_datarg  @  sz  € Ü*¨7Ó3Ñ€Hˆhà€DÜÐ€EÐˆD�3Ü˜(¨!×,Ð,‰ˆˆ1Ø�v‰vˆÜ�d×(Ñ(¨8¯<©<¸¿¹ÄÓ+FÑFÌÓMˆØ�—‘ÑˆØ×Ñ˜vÒ%Ø�A—H‘HÑ‰DØ×Ñ Ò&Ø�1—8‘8‰OˆCØ�‰ØØ—w‘wØ×*Ñ*Ø×&Ñ&Ø—Z‘Z—_‘_Ø,-¯NªN�Q—^‘^×(Ò(ÀØ ×9Ñ9Ó;Ø×:Ñ:Ó<ØŸN™N×4Ñ4Ó6Ü˜AŸH™H“oØ×:Ñ:Ó<Ü! '›Nñ
ö 	ð -ô. Øä˜5“\¬5°«;Ü˜“:¬¨D«	ñ
ñó ð r0   c                 ó¸  — t        | «      \  }}g }t        |d¬«      D �]-  \  }}|j                  }t        |j                  |j                  |j                  t        «      z
  t        «      }|j                  ||j                  |j                  |j                  |j                  j                  |j                  r|j                  j                  nd|j                  «       |j                  «       |j                   j#                  «       |j$                  t'        |j(                  «      t'        |«      |j$                  dk(  rdnddddœ«       �Œ0 t+        d	|i«      S )
NrI   r¨   rJ   rã   r  r  r   )r  r8   rg   rd  r;   re  rP   ÚpaymentrÚ   rÜ   rä   r?   r  r  Úextra_clearedr­   )rU  r´   r_   r±   rA   rt   rN   rX   r  r9   r:   r;   rZ   rè   r]   r  rÚ   r+   rÜ   r[   rä   r   )r   rý   rR  r­   r»   r  r_   r5   s           r(   Úadmin_collection_list_datark  e  s  € Ü*¨7Ó3Ñ€Hˆhà€DÜ˜(¨!×,Ð,‰ˆˆ1Ø�v‰vˆÜ�d×(Ñ(¨8¯<©<¸¿¹ÄÓ+FÑFÌÓMˆØ�‰ØØ—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ØØ!ñ
ö 	ð -ô( ˜ ˜Ó'Ð'r0   c                 óÖ   — |dk  ry| j                   xs t        }|dkD  rD||z  }||z
  }||kD  r5||z
  }t        ||z  «      }|rd|› d|dk7  rdnd› d�nd}	d	|d
›d|	› d|d
›d�S d|d
›d�S )zVExplain what the payment did: normal due, extra adjusted to next dues, or loan closed.r   z<Payment saved. Full balance is paid, the loan is now closed.z	 (covers z	 more duerI   ræ   rK   Ú)u   Payment saved. Extra â‚¹rç   z is adjusted to the next duesu   . Balance â‚¹Ú.u   Payment saved. Balance â‚¹)rB   rX   r#   )
r_   rä   Úpaid_beforeÚnew_balancer  r!  r#  rì   ÚcoversÚnotes
             r(   r  r  €  s³   € à�aÒØMØ
�/‰/Ò
!œT€CØ
ˆQ‚wØ˜SÑ ˆØ�T‰zˆØ�DŠ=Ø˜T‘MˆEÜ˜ #™Ó&ˆFÙQW�Y˜v˜h i°vÀ²{±ÈÐ/KÈ1ÑMÐ]_ˆDØ.¨u°T¨lÐ:WÐX\ÐW]ð ^"Ø"-¨dÐ!3°1ð6ð 7à'¨°DÐ'9¸Ð;Ð;r0   c           	      ó,  ‡— t        j                  «       }t        j                  j	                  | ¬«      Šˆfd„} ||«      \  }} ||«      \  }}|j                  «       |j                  d«      |||j                  «       |j                  d«      ||dœS )z7Total collected today and on `day` for the given loans.)Úloan__inc                 óè   •— ‰j                  | ¬«      j                  t        t        d«      t	        d«      t
        ¬«      ¬«      }t        |d   «      ‰j                  | ¬«      j                  «       fS )N)rÚ   rä   r   ri   )Útrv  )r{   rþ   r   r   r   rz   r[   r<  )ÚdÚaggÚpayss     €r(   r„   z collection_totals.<locals>.total—  s_   ø€ Ø�k‰k qˆkÓ)×3Ñ3Ü”s˜8“}¤e¨A£h¼UÔCð 4ó Eˆä�S˜‘X‹ §¡¸ Ó ;× AÑ AÓ CÐCÐCr0   z%d %b %Y)r`   Útoday_labelÚtoday_totalÚtoday_countr   Ú
date_labelÚ
date_totalÚ
date_count)r   r|   r   rw   r{   r+   r^   )	Úloans_qsrC  r`   r„   Út_amountÚt_countÚs_amountÚs_country  s	           @r(   Úcollection_totalsr…  ’  s‹   ø€ ä×ÑÓ €EÜ×Ñ×%Ñ%¨xÐ%Ó8€DôDñ
 ˜e›Ñ€HˆgÙ˜c›
Ñ€Hˆgà—‘Ó"°5·>±>À*Ó3MØ°Ø—‘“¨s¯|©|¸JÓ/GØ¨gñ	ð r0   c                 ó¶   — 	 t        j                  | xs dj                  «       d«      j                  «       S # t        $ r t        j                  «       cY S w xY w)NrK   rÝ   )r   rñ   ru   r   r%   r   r|   )r&   s    r(   Ú
_parse_dayr‡  ¦  sN   € ð$Ü× Ñ  %¢+¨2×!4Ñ!4Ó!6¸
ÓC×HÑHÓJÐJøÜò $Ü×!Ñ!Ó#Ò#ð$ús   ‚58 ¸AÁAc           
      ó(  — t         j                  j                  «       }| j                  j	                  dd«      j                  «       }|r|j                  |¬«      }t        t        |t        | j                  j	                  d«      «      «      «      S )Nr;   rK   rl   r   )
r   rw   rÎ   rs   rt   ru   r{   r   r…  r‡  )r   r�   r;   s      r(   Úadmin_loan_reports_summaryr‰  ­  si   € Ü	�‰×	Ñ	Ó	€BØ�K‰K�O‰O˜G RÓ(×.Ñ.Ó0€EÙØ�Y‰Y¨5ˆYÓ1ˆÜÔ)¨"¬j¸¿¹¿¹ÈÓ9PÓ.QÓRÓSÐSr0   c                 ó´  — ddl m} t        j                  «       }t	        | j
                  j                  dd«      «      }t        d„ |D «       t        «      }|| _	        t        | ||«      }| j                  | j                  | j                  «       t        | j                  «      t        |«      t        |d   «      |d   |d    || ||d	«       || ||d
«      dœ
S )Nr   )Úperiod_reportrÚ   rN   c              3   ó4   K  — | ]  }|j                   –— Œ y ­wr"   r  r  s     r(   rÈ   z(period_report_payload.<locals>.<genexpr>º  s   è ø€ Ð+¡(˜Q�—•¡(ùr  r5   rE   rL   rq   rr   )
r8   r9   rP   rA   r>   r@   rE   rL   rq   rr   )ÚNexusApp.utils.loan_scheduler‹  r   r|   r  rý   r}   rÒ   rX   rY   r2   rN   r9   r]   r[   rA   )r_   r‹  r`   rý   rY   rb   s         r(   Úperiod_report_payloadrŽ  ¶  sÇ   € Ý:Ü×ÑÓ €EÜ�D—M‘M×*Ñ*¨>¸4Ó@ÓA€HÜÑ+¡(Ó+¬TÓ2€DØ€D„IÜ
˜˜d EÓ
*€Cà—7‘7Ø×+Ñ+Ø×5Ñ5Ó7Ü˜t×1Ñ1Ó2Ü˜T“{Ü  I¡Ó/Ø˜NÑ+Ø�h‘-Ù  h°°xÓ@Ù   x°¸	ÓBñð r0   c                 ón  — | j                   j                  dd«      j                  «       }|j                  «       st	        dddœd¬«      S t
        j                  j                  d«      j                  t        |«      ¬	«      j                  «       }|€t	        dd
dœd¬«      S t	        t        |«      «      S )NrN   rK   r˜   r;  rš   rœ   r�   rg   rß   rá   râ   )rs   rt   ru   rð   r   r   rw   rx   r{   r#   rü   rŽ  )r   r8   r_   s      r(   Úadmin_loan_period_reportr�  Ë  s–   € Ø�k‰k�o‰o˜d BÓ'×-Ñ-Ó/€GØ�?‰?ÔÜ wÐ;MÑNÐWZÔ[Ð[Ü�<‰<×&Ñ& zÓ2×9Ñ9¼SÀ»\Ð9ÓJ×PÑPÓR€DØ€|Ü wÐ;LÑMÐVYÔZÐZÜÔ-¨dÓ3Ó4Ð4r0   )Úadminr"   )Úcollections)TÚ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   r   r   Ú	getLoggerÚ__name__r¶   rz   rX   r)   r/   r�  r1   Ú_add_monthsr2   r3   Ú_nth_due_daterc   r…   r²   r¼   rÓ   rÕ   rØ   r  r  r$  r)  r=  r/  r6  r7  r9  r?  rA  rD  rS  rU  r\  r^  r`  rg  rk  r  r…  r‡  r‰  rŽ  r�  r‹   r0   r(   Ú<module>r¥     se  ðÛ Û ß .Ñ .ß -å !ß 8Ó 8Ý /ß ;Ñ ;ß 6Ý Ý !Ý "Ý 5ç -ß GÑ Gà	ˆ×	Ñ	˜8Ó	$€á °1Ô5€Ùˆsƒ|€òò[÷ñ ó
'òT*ñ^ ,Ù$Ù!Ù Ù2Ùñ€	ò#òLÐ ò)ò$,ð ñ`ó ð`òHò)òXñ$ 2Ù%Ù$Ù"ñ	Ð òòX€ò
òò&)òX-ò:ó*ò:&ò
dÐ óOò&9ò
"òJ(ò6<ò$ò($òTòó*5r0   