Ë
    Ü kE&  ã                   ó2  — d Z ddlZddlmZ ddlmZmZmZmZm	Z	m
Z
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  ej:                  e«      Z edd¬«      Z d„ Z!ed„ «       Z"ed„ «       Z#d„ Z$d„ Z%d„ Z&d„ Z'd„ Z(d„ Z)d„ Z*d„ Z+y)z@controllers/Staff/LoanregisterController.py  (replace your file)é    N)Ú	urlencode)ÚCountÚDecimalFieldÚFÚOuterRefÚQÚSubqueryÚSumÚValue)ÚCoalesce)ÚJsonResponse)Úreverse)Úrequire_POST)ÚPlaceÚLoanPayment)ÚLoan)Ú
date_rangeÚrange_labelÚxlsx_responseé   é   )Ú
max_digitsÚdecimal_placesc                 óÖ  — | j                   j                  d«      dk7  rt        dddœd¬«      S 	 t        | j                  j                  dd	«      «      }t        | j                  j                  d
d«      «      }t        | j                  j                  dd«      «      }| j                  j                  dd«      j                  «       }| j                  j                  dd«      }| j                  j                  dd«      }t        j                  j                  t        d«      ¬«      j                  d«      j                  t        d«      ¬«      j                  d«      }t        j                  j                  t        d«      t        dt        d¬«      ¬«      t!        t        d«      t#        d«      t$        ¬«      t!        t        d«      t#        d«      t$        ¬«      t!        t'        |t$        ¬«      t#        d«      t$        ¬«      ¬ «      j                  t)        d!«      t)        d"«      z
  ¬#«      }t        j                  j+                  «       }	|r|j                  |¬$«      }|j+                  «       }
d%d&d'd(œ}||v r&||   }|d)k(  rd*nd}|j-                  |› |› �d+d,«      }n|j-                  d+d,«      }|d-k(  r||d  n||||z    }g }t/        ||d	z   ¬.«      D ]Å  \  }}t1        d/|j2                  i«      }|j5                  ||j6                  |j2                  |j8                  |j:                  t=        |j>                  «      d0|j>                  d1›�d0tA        |jB                  d«      d1›�tE        d2|j6                  g¬3«      tE        d4|j6                  g¬3«      d5œ
«       ŒÇ t        ||	|
|d6œ«      S # tF        $ r+ tH        jK                  d7«       t        d	ddg d8d9œd:¬«      cY S w xY w);Nzx-requested-withÚXMLHttpRequestÚerrorzInvalid request.©ÚstatusÚmessageé�  ©r   Údrawé   Ústartr   Úlengthé
   zsearch[value]Ú zorder[0][column]zorder[0][dir]ÚascÚpk)Úloan__placer*   Úamount©Úsr-   ÚloansÚ	completed)Úloans__status)ÚfilterÚloans__loan_amount©Úoutput_fieldÚloans__total_payable)Útotal_loansÚcompleted_loansÚtotal_amountÚpayableÚpaidr9   r:   )Úpending_amount)Úname__icontainsÚnamer6   r8   )Ú1Ú2Ú3ÚdescÚ-z-created_atú-idéÿÿÿÿ©r$   Úplaceu   â‚¹z,.2fzadmin:loan_reports)Úargszadmin:place_completed_loan)
ÚDT_RowIndexÚplace_idÚ
place_namer6   r7   r8   Útotal_amount_displayÚpending_amount_displayÚ
report_urlÚcompleted_url)r"   ÚrecordsTotalÚrecordsFilteredÚdatazview_loan_request_page failedzCould not load loan registers.)r"   rO   rP   rQ   r   iô  )&ÚheadersÚgetr   ÚintÚGETÚstripr   Úobjectsr1   r   ÚvaluesÚannotater
   r   r   r   r   r   ÚMONEYr	   r   ÚcountÚorder_byÚ	enumerater   r=   ÚappendÚidr6   r7   Úfloatr8   Úmaxr;   r   Ú	ExceptionÚloggerÚ	exception)Úrequestr"   r$   r%   ÚsearchÚ	order_colÚ	order_dirÚpaid_sqÚplacesÚrecords_totalÚrecords_filteredÚ	order_mapÚfieldÚ	directionÚrowsrQ   ÚiÚpÚqs                      úQ/var/www/html/nexus_chitfund_web/controllers/Admin/AdminloanregisterController.pyÚadmin_view_loan_request_pageru      sg  € Ø‡�×ÑÐ-Ó.Ð2BÒBÜ wÐ;MÑNÐWZÔ[Ð[ðBÜ�7—;‘;—?‘? 6¨1Ó-Ó.ˆÜ�G—K‘K—O‘O G¨QÓ/Ó0ˆÜ�W—[‘[—_‘_ X¨rÓ2Ó3ˆØ—‘—‘ °"Ó5×;Ñ;Ó=ˆØ—K‘K—O‘OÐ$6¸Ó;ˆ	Ø—K‘K—O‘O O°UÓ;ˆ	ô ×Ñ×&Ñ&´8¸D³>Ð&ÓBß‰V�MÓ"§8¡8¬c°(«m 8Ó#<¿V¹VÀC»[ð 	ô
 —‘×'Ñ'Ü˜g›Ü! '´!À+Ô2NÔOÜ!¤#Ð&:Ó";¼UÀ1»XÔTYÔZÜœSÐ!7Ó8¼%À»(ÔQVÔWÜœ( 7¼Ô?ÄÀqÃÔX]Ô^ð (ó 
÷ ‰(¤! I£,´°6³Ñ":ˆ(Ó
;ð 	ô Ÿ™×+Ñ+Ó-ˆÙØ—]‘]°6�]Ó:ˆFØ!Ÿ<™<›>Ðà  }¸>ÑJˆ	Ø˜	Ñ!Ø˜iÑ(ˆEØ(¨FÒ2™¸ˆIØ—_‘_¨	 {°5°'Ð%:¸MÈ5ÓQ‰Fð —_‘_ ]°EÓ:ˆFà!'¨2¢ˆv�e�f‰~°6¸%ÀÈÁÐ3OˆàˆÜ˜d¨%°!©)×4‰DˆAˆqÜ˜7 A§F¡FÐ+Ó,ˆAØ�K‰KØ ØŸD™DØŸf™fØ Ÿ}™}Ø#$×#4Ñ#4Ü % a§n¡nÓ 5Ø*-¨a¯n©n¸TÐ-BÐ(CØ,/´°A×4DÑ4DÀaÓ0HÈÐ/NÐ*OÜ%Ð&:À!Ç$Á$ÀÔHÜ!(Ð)EÈQÏTÉTÈFÔ!Sñõ ð 5ô ØØ)Ø/Øñ	
ó ð 	øô ò Ü×ÑÐ8Ô9ÜØ q¸QÈØ5ñ
ð ôò 	ðús   °NN4 Î41O(Ï'O(c                 óR  — | j                   j                  dd«      j                  «       }|st        dddœd¬«      S t	        |«      dkD  rt        dd	dœd¬«      S t
        j                  j                  |¬
«      \  }}|st        dddœd¬«      S t        dd|j                  dœ«      S )NrJ   r'   r   úPlace name is required.r   r    r!   é–   zMax 150 characters.)r=   úPlace already exists.ÚsuccesszPlace added.)r   r   r_   )	ÚPOSTrS   rV   r   Úlenr   rW   Úget_or_creater_   )re   r=   rF   Úcreateds       rt   Úadmin_add_placer   ]   sŸ   € à�<‰<×Ñ˜L¨"Ó-×3Ñ3Ó5€DÙÜ wÐ;TÑUÐ^aÔbÐbÜ
ˆ4ƒy�3‚Ü wÐ;PÑQÐZ]Ô^Ð^Ü—]‘]×0Ñ0°dÐ0Ó;�N€Eˆ7ÙÜ wÐ;RÑSÐ\_Ô`Ð`Ü 9¸ÈuÏxÉxÑXÓYÐYó    c                 óP  — | j                   j                  d«      }| j                   j                  dd«      j                  «       }|st        dddœd¬«      S 	 t        j
                  j                  |¬	«      }t        j
                  j                  |j                  ¬	«      j                  |¬«      j                  «       rt        dddœd¬«      S ||_        |j                  dg¬«       t        dddœ«      S # t        j                  t        f$ r t        dd
dœd¬«      cY S w xY w)NrI   rJ   r'   r   rw   r   r    r!   )r)   zPlace not found.i”  )Úname__iexactry   r=   )Úupdate_fieldsrz   zPlace updated.)r{   rS   rV   r   r   rW   ÚDoesNotExistÚ
ValueErrorÚexcluder)   r1   Úexistsr=   Úsave)re   rI   r=   rF   s       rt   Úadmin_update_placer‰   j   s	  € à�|‰|×Ñ 
Ó+€HØ�<‰<×Ñ˜L¨"Ó-×3Ñ3Ó5€DÙÜ wÐ;TÑUÐ^aÔbÐbð\Ü—‘×!Ñ! XÐ!Ó.ˆô ‡}�}×Ñ §¡ÐÓ)×0Ñ0¸dÐ0ÓC×JÑJÔLÜ wÐ;RÑSÐ\_Ô`Ð`Ø€E„JØ	‡J�J˜f˜X€JÔ&Ü 9Ð9IÑJÓKÐKøô ×Ñ¤
Ð+ò \Ü wÐ;MÑNÐWZÔ[Ò[ð\ús   Á C9 Ã9)D%Ä$D%c                 óH  — | j                   j                  d«      }t        j                  j	                  |d¬«      j                  d«      j                  dd«      }g }t        |d¬«      D ]©  \  }}|j                  |j                  ||j                  |j                  |j                  j                  d	«      t        |j                  «      |j!                  «       |j"                  |j$                  r|j$                  j                  d	«      nd
dœ	«       Œ« t'        d|i«      S )NrI   r/   )rI   r   Úcustomerú-closed_daterC   r#   rE   ú%Y-%m-%drB   )	r_   ÚsnoÚcustomer_nameÚphone_numberÚ	loan_dateÚloan_amountÚpayment_typeÚnumber_of_duesÚclosed_daterQ   )rU   rS   r   rW   r1   Úselect_relatedr\   r]   r^   r_   r�   r�   r‘   Ústrftimer`   r’   Úget_payment_type_displayr”   r•   r   )re   rI   r.   rQ   rq   Úls         rt   Úadmin_place_completed_loan_datarš   }   sê   € Ø�{‰{�‰˜zÓ*€HÜ�L‰L×Ñ¨¸+ÐÓFß#‘^ JÓ/ß‘X˜n¨eÓ4ð 
ð €DÜ˜% q×)‰ˆˆ1Ø�‰Ø—$‘$ØØŸ_™_ØŸN™NØŸ™×-Ñ-¨jÓ9Ü  §¡Ó/Ø×6Ñ6Ó8Ø×.Ñ.ØABÇÂ˜1Ÿ=™=×1Ñ1°*Ô=ÐTWñ

õ 
	ð *ô ˜ ˜Ó'Ð'r€   c                 óv  — t         j                  j                  t        d«      ¬«      j	                  d«      j                  t        d«      ¬«      j	                  d«      }t        j                  j                  dd«      j                  t        t        |t        ¬	«      t        d
«      t        ¬	«      ¬«      j                  d«      }g }t        |d¬«      D ]Ô  \  }}t        |j                   |j"                  z
  d
«      }|j%                  |j&                  ||j(                  |j*                  |j,                  j.                  t1        |j2                  «      t1        |j"                  «      t1        |«      t1        |j4                  «      |j6                  |j8                  dk(  rdnddœ«       ŒÖ t;        d|i«      S )Nr)   )Úloanrœ   r+   r,   r-   rF   r‹   r3   r   )r:   rC   r#   rE   r/   Ú	CompletedÚPending)r_   rŽ   r�   r�   rF   r’   Úpaid_amountr;   Ú
due_amountr”   r   rQ   )r   rW   r1   r   rX   rY   r
   r   r–   r   r	   rZ   r   r\   r]   ra   Útotal_payabler:   r^   r_   r�   r�   rF   r=   r`   r’   r    r”   r   r   )re   ri   r.   rQ   rq   r™   Úpendings          rt   Úadmin_loan_entries_datar£   ’   sH  € ä×Ñ×"Ñ"¬°«Ð"Ó7ß	‰�‹Ÿ™¤3 x£=˜Ó1·&±&¸³+ð ô
 	�‰×#Ñ# G¨ZÓ8ß	‰”x¤¨¼uÔ EÜ % a£´uô>ˆó 
?ç	‰�%‹ð	 
ð €DÜ˜% q×)‰ˆˆ1Ü�a—o‘o¨¯©Ñ.°Ó2ˆØ�‰Ø—$‘$ØØŸ_™_ØŸN™NØ—W‘W—\‘\Ü  §¡Ó/Ü  §¡›=Ü# G›nÜ §¡Ó-Ø×.Ñ.Ø%&§X¡X°Ò%<‘kÀ)ñ
õ 	ð *ô ˜ ˜Ó'Ð'r€   c                 óN  — t        | «      \  }}|r|j                  |¬«      }|r|j                  |¬«      }| j                  j                  dd«      j	                  «       }|rB|j                  t        |¬«      t        |¬«      z  t        |¬«      z  t        |¬«      z  «      }|S )	zSCompleted loans closed inside from_date / to_date, plus the optional ?search= text.)Úclosed_date__gte)Úclosed_date__lterf   r'   )Ú"customer__customer_name__icontains)Ú!customer__phone_number__icontains)Úplace__name__icontains)Úpayment_type__icontains)r   r1   rU   rS   rV   r   )re   Úqsr$   Úendrf   s        rt   Úcompleted_loans_filteredr­   ²   sœ   € ä˜GÓ$�J€Eˆ3ÙØ�Y‰Y¨ˆYÓ.ˆÙ
Ø�Y‰Y¨ˆYÓ,ˆØ�[‰[�_‰_˜X rÓ*×0Ñ0Ó2€FÙØ�Y‰YÜ°Ô8Ü°&Ô9ñ:ä vÔ.ñ/ô ¨Ô/ñ0ó
ˆð €Ir€   c                 óž  — t        | d¬«      D ��cg c]¯  \  }}|j                  ||j                  |j                  |j                  j
                  |j                  j                  d«      t        |j                  «      |j                  «       |j                  |j                  r|j                  j                  d«      nddœ
‘Œ± c}}S c c}}w )Nr#   rE   r�   rB   )
r_   rŽ   r�   r�   rF   r‘   r’   r“   r”   r•   )r]   r_   r�   r�   rF   r=   r‘   r—   r`   r’   r˜   r”   r•   )r.   rq   r™   s      rt   Úcompleted_loan_rowsr¯   Ä   s«   € ô ˜E¨Õ+ô-ñ ,‰$ˆ!ˆQð �d‰dØØŸ™ØŸ™Ø—‘—‘Ø—[‘[×)Ñ)¨*Ó5Ü˜QŸ]™]Ó+Ø×2Ñ2Ó4Ø×*Ñ*Ø=>¿]º]�q—}‘}×-Ñ-¨jÔ9ÐPSóð ,ò-ð -ùó -s   ‘B4C	c                 ó  — t        | «      \  }}|D �cg c](  }|d   |d   |d   |d   |d   |d   |d   |d   |d	   g	‘Œ* }}t        d
dg d¢|dt        ||«      › �|rdddddt        d„ |D «       «      g¬«      S d ¬«      S c c}w )NrŽ   r�   r�   rF   r‘   r’   r“   r”   r•   r7   zCompleted Loans)	zS.NozCustomer NameÚPhoner   z	Loan DatezLoan AmountzPayment TypezNumber of DueszClosed DatezClosed date: ÚTotalr'   c              3   ó&   K  — | ]	  }|d    –— Œ y­w)r’   N© )Ú.0Úrs     rt   Ú	<genexpr>z'completed_loans_xlsx.<locals>.<genexpr>Ý   s   è ø€ Ð,LÁtÀ!¨Q¨}Õ-=Átùs   ‚)ÚsubtitleÚtotals)r   r   r   Úsum)re   rp   r$   r¬   r¶   Úbodys         rt   Úcompleted_loans_xlsxr¼   Ó   sÙ   € Ü˜GÓ$�J€Eˆ3ñ óá�ð ˆu‰X�q˜Ñ)¨1¨^Ñ+<¸aÀ¹jÈ!ÈKÉ.Øˆ}Ñ˜q Ñ0°!Ð4DÑ2EÀqÈÑGWòYàð 	ð ô ØÐ,ò	:à˜¤{°5¸#Ó'>Ð&?Ð@ÙQU�˜˜R  R¬Ñ,LÁtÓ,LÓ)LÐMôað að
 \`ôað aùòs   “-Bc                 ó–   — t        | t        j                  j                  d¬«      j	                  dd«      j                  dd«      «      S )Nr/   r!   rF   r‹   rŒ   rC   )r­   r   rW   r1   r–   r\   ©re   s    rt   Ú_admin_completed_loansr¿   à   s?   € Ü#ØÜ�‰×Ñ ;ÐÓ/ß	‰˜ Ó	,ß	‰�. %Ó	(ó	ð r€   c                 ó@   — t        dt        t        | «      «      i«      S )NrQ   )r   r¯   r¿   r¾   s    rt   Úadmin_completed_loan_datarÁ   é   s   € Ü˜Ô!4Ô5KÈGÓ5TÓ!UÐVÓWÐWr€   c                 ó>   — t        | t        t        | «      «      «      S )N)r¼   r¯   r¿   r¾   s    rt   Úadmin_completed_loan_exportrÃ   í   s   € Ü Ô)<Ô=SÐT[Ó=\Ó)]Ó^Ð^r€   ),Ú__doc__ÚloggingÚurllib.parser   Údjango.db.modelsr   r   r   r   r   r	   r
   r   Údjango.db.models.functionsr   Údjango.httpr   Údjango.urlsr   Údjango.views.decorators.httpr   ÚNexusApp.modelsr   r   r   ÚNexusApp.utils.excelr   r   r   Ú	getLoggerÚ__name__rc   rZ   ru   r   r‰   rš   r£   r­   r¯   r¼   r¿   rÁ   rÃ   r´   r€   rt   Ú<module>rÐ      s´   ðÙ FÛ Ý "÷÷ ó õ 0Ý $Ý Ý 5ç .Ý  ß GÑ Gà	ˆ×	Ñ	˜8Ó	$€Ù °1Ô5€òFðP ñ	Zó ð	Zð ñLó ðLò$(ò*(ò@ò$-ò
aòòXó_r€   