Ë
    � k�!  ã                   ó  — d Z ddl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 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mZmZmZmZmZmZ  ej@                  e!«      Z"d„ Z#dd„Z$dd„Z%d„ d„ d„ d„ dœZ&d„ Z'g d¢Z(d„ Z)d„ Z*d„ Z+y)až  
controllers/Admin/AdminoverdueController.py

Backend for the two admin pages:

    /admin/overdue_loan/        -> list of every loan whose next due date has passed
    /admin/view_overdue_loan/   -> one overdue loan (?id=<loan id>) + its payment history

A loan is "overdue" when it is not completed and the next unpaid due date is
earlier than today (same rule the Loan Reports page uses for its Overdue badge).
é    N)ÚSumÚValue)ÚCoalesce)ÚHttp404ÚHttpResponseÚJsonResponse)ÚredirectÚrender)Úreverse)Útimezone)ÚLoan)Ú
date_rangeÚrange_labelÚxlsx_responseé   )ÚMONEYÚZEROÚ
_build_rowÚ	_in_rangeÚ_intÚ_loan_with_paidÚ_nth_due_datec                 óŽ  — ddl m} ddlm}m}  || | |d¬«      z
  «      }t        ||d   z
  d«      }t        | j                  xs t        |z  | j                  «      }t        || j                  xs t        z
  t        «      }	d}
|d   r7t        | j                  | j                  |d   «      } || |d¬«      z   |«      }
||	|
fS )zCHow many dues / how much money / how many working days are overdue.r   )Ú	timedelta)Údues_elapsedÚworking_days_betweenr   )ÚdaysÚ	paid_duesÚnext_due_iso)Údatetimer   ÚNexusApp.utils.loan_scheduler   r   ÚmaxÚminÚ
due_amountr   Útotal_payableÚpaidr   Úfirst_due_dateÚpayment_type)ÚloanÚrowÚtodayr   r   r   ÚelapsedÚoverdue_duesÚshould_have_paidÚoverdue_amountÚoverdue_daysÚnext_dues               úL/var/www/html/nexus_chitfund_web/controllers/Admin/AdminoverdueController.pyÚ_overdue_numbersr3   '   sÁ   € å"ßOñ ˜4 ©¸Ô):Ñ!:Ó;€GÜ�w  [Ñ!1Ñ1°1Ó5€LÜ˜DŸO™OÒ3¬t°wÑ>À×@RÑ@RÓSÐÜÐ)¨T¯Y©YÒ->¼$Ñ?ÄÓF€Nà€LØ
ˆ>ÒÜ  ×!4Ñ!4°d×6GÑ6GÈÈ[ÑIYÓZˆÙ+¨H±yÀaÔ7HÑ,HÈ%ÓPˆà˜¨Ð5Ð5ó    c                 óv  — t        | ||j                  d«      d   «      }|d   dk7  ryt        | ||«      \  }}}|j                  | j                  j
                  | j                  j                  d«      | j                  j                  «       |t        |«      |t        |«      › d| j                  › �dœ«       |S )	z8One DataTable row, or None when the loan is not overdue.Ú:r   ÚstatusÚOverdueNz%d/%m/%Yz?id=)ÚplaceÚ	loan_dateÚloan_date_isor-   r/   r0   Úview_url)r   Úsplitr3   Úupdater9   Únamer:   ÚstrftimeÚ	isoformatÚfloatr   Úid)r)   r+   Úview_url_namer*   r-   r/   r0   s          r2   Ú_overdue_rowrE   :   s¯   € ä
�T˜5 -×"5Ñ"5°cÓ":¸1Ñ"=Ó
>€CØ
ˆ8�}˜	Ò!Øä1AÀ$ÈÈUÓ1SÑ.€L�. ,Ø‡J�JØ—‘—‘Ø—^‘^×,Ñ,¨ZÓ8ØŸ™×1Ñ1Ó3Ø$Ü Ó/Ø$Ü˜}Ó-Ð.¨d°4·7±7°)Ð<ñô ð €Jr4   c                 óº  ‡‡— t        | «      \  }}| j                  j                  dd«      j                  «       j	                  «       }| j                  j                  dd«      j                  «       j	                  «       }| j                  j                  dd«      j                  «       }|€t
        j                  j                  «       n|j                  d¬«      j                  dd«      j                  t        t        d«      t        d	«      t        ¬
«      ¬«      }|r|j                  |¬«      }t!        j"                  «       Šˆˆfd„|j%                  d«      D «       D �	cg c]  }	|	sŒ|	‘Œ	 }
}	t'        |
«      }|dv r&|
D �	cg c]  }	|	d   j	                  «       |k(  sŒ|	‘Œ }
}	|rx|
D �	cg c]m  }	||	d   j	                  «       v sT||	d   j	                  «       v s?||	d   j	                  «       v s*||	d   j	                  «       v s||	d   j	                  «       v r|	‘Œo }
}	|s|r |
D �	cg c]  }	t)        |	d   ||«      sŒ|	‘Œ }
}	|
|fS c c}	w c c}	w c c}	w c c}	w )zSEvery overdue loan, then the search box / payment-type / place / loan-date filters.zsearch[value]Ú r(   r9   Ú	completed©r7   ÚcustomerÚpayments__amountr   )Úoutput_field)r&   )Úplace__name__iexactc              3   ó8   •K  — | ]  }t        |‰‰«      –— Œ y ­w©N)rE   )Ú.0r)   r+   rD   s     €€r2   Ú	<genexpr>z _collect_rows.<locals>.<genexpr>^   s   øè ø€ Ð`ÑM_ÀTœ T¨5°-×@ÑM_ùs   ƒz-id)ÚdailyÚweeklyÚmonthlyÚcustomer_nameÚphone_numberr:   r;   )r   ÚGETÚgetÚstripÚlowerr   ÚobjectsÚallÚexcludeÚselect_relatedÚannotater   r   r   r   Úfilterr   Ú	localdateÚorder_byÚlenr   )ÚrequestÚbase_qsrD   ÚstartÚendÚsearchr(   r9   ÚqsÚrÚrowsÚtotalr+   s     `         @r2   Ú_collect_rowsrm   M   s/  ù€ ä˜GÓ$�J€Eˆ3Ø�[‰[�_‰_˜_¨bÓ1×7Ñ7Ó9×?Ñ?ÓA€FØ—;‘;—?‘? >°2Ó6×<Ñ<Ó>×DÑDÓF€LØ�K‰K�O‰O˜G RÓ(×.Ñ.Ó0€Eð  '˜Œ�‰×	Ñ	Ô	°Gß	‰˜ˆÓ	$ß	‰˜ Ó	,ß	‰”x¤Ð$6Ó 7¼¸q»ÔPUÔVˆÓ	Wð	 ñ Ø�Y‰Y¨5ˆYÓ1ˆä×ÑÓ €EÜ`ÈRÏ[É[ÐY^ÔM_Ô`ÓfÑ`�!ÒdeŠAÐ`€DÐfä�‹I€EàÐ5Ñ5ÙÓM™4�a 1 ^Ñ#4×#:Ñ#:Ó#<ÀÓ#L’˜4ˆÐMááó
Ù�!Ø˜˜?Ñ+×1Ñ1Ó3Ñ3Ø˜˜>Ñ*×0Ñ0Ó2Ñ2Ø˜˜7™×)Ñ)Ó+Ñ+Ø˜˜>Ñ*×0Ñ0Ó2Ñ2Ø˜˜;™×-Ñ-Ó/Ñ/ò �tð 	ð 
ñ ‘ÙÓM™4�a¤9¨Q¨Ñ-?ÀÈÕ#L’˜4ˆÐMØ�ˆ;Ðùò' gùò
 Nùò
ùò Ns+   Å$I	Å,I	ÆIÆ!IÆ-A2IÈ)IÈ?Ic                 ó   — | d   S )Nr;   © ©rj   s    r2   Ú<lambda>rq   v   s	   € ��?Ò#r4   c                 ó(   — | d   j                  «       S )NrU   )rZ   rp   s    r2   rq   rq   w   s   € ��?Ñ#×)Ñ)Ô+r4   c                 ó   — | d   S )NÚloan_amountro   rp   s    r2   rq   rq   x   s	   € ��=Ò!r4   c                 ó   — | d   S ©Nr0   ro   rp   s    r2   rq   rq   y   s	   € ��>Ò"r4   )r   é   é   é   c           	      óv  — | 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 r8|j                  t        |   | j                  j                  dd«      dk(  ¬«       n|j                  d„ d¬«       |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)z<DataTables server-side endpoint for the Overdue Loans table.zx-requested-withÚXMLHttpRequestÚerrorzInvalid request.)r7   Úmessagei�  rI   Údrawr   rf   r   Úlengthé
   zorder[0][column]éÿÿÿÿzorder[0][dir]ÚascÚdesc©Úkeyr   c                 ó   — | d   S rv   ro   rp   s    r2   rq   z)admin_overdue_loan_data.<locals>.<lambda>‘   s	   €  A nÒ$5r4   TN©rf   ÚDT_RowIndex)r~   ÚrecordsTotalÚrecordsFilteredÚdatazadmin_overdue_loan_data failedzCould not load overdue loans.)r~   r‰   rŠ   r‹   r|   iô  )ÚheadersrX   r   r   rW   r"   rm   rc   Ú	SORT_KEYSÚsortÚ	enumerateÚ	ExceptionÚloggerÚ	exception)rd   r~   rf   r   rk   rl   ÚfilteredÚ	order_colÚpageÚir*   s              r2   Úadmin_overdue_loan_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ð õ ð
 �I‰IÑ5¸tˆIÔDà%¨š|ˆt�E�F‰|°°e¸EÄCÈÐPQÃNÑ<RÐ1SˆÜ ¨E°A©I×6‰FˆAˆsØ!"ˆC�Òð 7ô ØØ!Ø'Øñ	
ó ð 	øô ò Ü×ÑÐ9Ô:ÜØ¨!ÀÈ2Ø4ñ
ð ôò 	ðús   ÁD.F Æ1F8Æ7F8)zS.Noz	Loan DatezCustomer NameÚPhoneÚPlacezLoan AmountzPayment TypezNumber of Duesz
Due AmountzOverdue DueszOverdue AmountzOverdue DayszNext Due Datec                 ó˜  — |j                  d„ d¬«       t        | «      \  }}t        |d¬«      D ��cg c]8  \  }}||d   |d   |d   |d	   |d
   |d   |d   |d   |d   |d   |d   |d   g‘Œ: }}}|r-dddddt        d„ |D «       «      ddddt        d„ |D «       «      gnd}t	        ddt
        |dt        ||«      › �|¬«      S c c}}w )zBExcel of every overdue loan matching the current search / filters.c                 ó   — | d   S rv   ro   rp   s    r2   rq   zoverdue_xlsx.<locals>.<lambda>¯   s	   € ˜A˜nÒ-r4   Tr„   r   r‡   r:   rU   rV   r9   rt   r(   Únumber_of_duesr$   r-   r/   r0   Únext_due_dateÚTotalrG   c              3   ó&   K  — | ]	  }|d    –— Œ y­w)rt   Nro   ©rP   rj   s     r2   rQ   zoverdue_xlsx.<locals>.<genexpr>¶   s   è ø€ Ð+KÁdÀ¨A¨mÕ,<Ádùó   ‚c              3   ó&   K  — | ]	  }|d    –— Œ y­w)r/   Nro   r    s     r2   rQ   zoverdue_xlsx.<locals>.<genexpr>·   s   è ø€ Ð5±¨1�1Ð%Õ&±ùr¡   NÚoverdue_loanszOverdue LoanszLoan date: )ÚsubtitleÚtotals)rŽ   r   r�   Úsumr   ÚOVERDUE_HEADERSr   )rd   rk   rf   rg   r–   rj   Úbodyr¥   s           r2   Úoverdue_xlsxr©   ­   s#  € à‡I�IÑ-°t€IÔ<Ü˜GÓ$�J€Eˆ3ô
 ˜D¨Õ*ô	,ñ +‰$ˆ!ˆQð 	
ˆ1ˆ[‰>˜1˜_Ñ-¨q°Ñ/@À!ÀGÁ*ÈaÐP]ÑN^Ø	ˆ.Ñ˜1Ð-Ñ.°°,±ÀÀ>ÑARØ	Ð
Ñ˜Q˜~Ñ.°°/Ñ0Bòð +ð	 	ñ ,ñ ;?ð ˜˜B  B¬Ñ+KÁdÓ+KÓ(KÈRÐQSÐUWÐY[ÜÑ5±Ó5Ó5ñ7ØDHð ä˜¨/¼?ÈDØ$/´¸EÀ3Ó0GÐ/HÐ"IÐRXôZð Zùó,s   ³=Cc                 ó6   — t        | «      \  }}t        | |«      S rO   )rm   r©   )rd   rk   Ú_s      r2   Úadmin_overdue_loan_exportr¬   ¼   s   € Ü˜GÓ$�G€Dˆ!Ü˜ Ó&Ð&r4   c                 ó$  — | j                   j                  dd«      j                  «       }|j                  «       st	        d«      S t
        j                  j                  t        |«      ¬«      j                  «       st	        d«      S t        t        |«      «      }t        j                  «       }t        ||«      }t        |||«      \  }}}t        | d|||j                   j"                  t%        |j&                  «      t%        |«      ||dœ«      S )zÃPage: /admin/view_overdue_loan/?id=<loan id>

    The payment table on this page is filled by the existing
    admin:paid_due_history_data endpoint, so only the summary cards are built here.
    rC   rG   zadmin:overdue_loan)Úpkz!adminpanel/view_overdue_loan.html)r)   ÚsummaryÚ
place_nameÚtotal_amountr/   r-   r0   )rW   rX   rY   Úisdigitr	   r   r[   r`   ÚintÚexistsr   r   ra   r   r3   r
   r9   r?   rB   r%   )rd   Úloan_idr)   r+   r¯   r-   r/   r0   s           r2   Úadmin_view_overdue_loanr¶   Â   sè   € ð �k‰k�o‰o˜d BÓ'×-Ñ-Ó/€GØ�?‰?ÔÜÐ,Ó-Ð-ä�<‰<×Ñ¤# g£,ÐÓ/×6Ñ6Ô8ÜÐ,Ó-Ð-äœ3˜w›<Ó(€DÜ×ÑÓ €Eä˜˜uÓ%€GÜ1AÀ$ÈÐQVÓ1WÑ.€L�. ,ä�'Ð>ØØØ—j‘j—o‘oÜ˜d×0Ñ0Ó1Ü Ó/Ø$Ø$ñAó ð r4   )úadmin:view_overdue_loan)Nr·   ),Ú__doc__ÚloggingÚdjango.db.modelsr   r   Údjango.db.models.functionsr   Údjango.httpr   r   r   Údjango.shortcutsr	   r
   Údjango.urlsr   Údjango.utilsr   ÚNexusApp.modelsr   ÚNexusApp.utils.excelr   r   r   ÚAdminloanreportControllerr   r   r   r   r   r   r   Ú	getLoggerÚ__name__r‘   r3   rE   rm   r�   r—   r§   r©   r¬   r¶   ro   r4   r2   Ú<module>rÅ      s’   ðñ
ó ç 'Ý /ß ;Ñ ;ß ,Ý Ý !å  ß GÑ G÷÷ ñ ð 
ˆ×	Ñ	˜8Ó	$€ò6ó&ó&$ñR $Ù+Ù!Ù"ñ	€	ò&òR€òZò'ór4   