Ë
    Ü k²"  ã                   ó$  — 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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)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)Ústaff_can_access_placeÚstaff_loansÚstaff_place_idsÚstaff_placesé   é   )Ú
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                  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+                  «       }	|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›�d0|j@                  d1›�tC        d2|j6                  g¬3«      tC        d4|j6                  g¬3«      d5œ
«       Œ½ t        ||	|
|d6œ«      S # tD        $ r+ tF        jI                  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Úpaidr:   r;   )Úpending_amount)Úname__icontainsÚnamer7   r9   )Ú1Ú2Ú3ÚdescÚ-z-created_atú-idéÿÿÿÿ©r%   Úplaceu   â‚¹z,.2fzstaff:loan_reports)Úargszstaff:place_completed_loan)
ÚDT_RowIndexÚplace_idÚ
place_namer7   r8   r9   Ú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#   rP   rQ   rR   r   iô  )%ÚheadersÚgetr   ÚintÚGETÚstripr   Úobjectsr2   r   ÚvaluesÚannotater
   r   r   r   r   r   ÚMONEYr	   r   ÚcountÚorder_byÚ	enumerater   r>   ÚappendÚidr7   r8   Úfloatr9   r<   r   Ú	ExceptionÚloggerÚ	exception)Úrequestr#   r%   r&   ÚsearchÚ	order_colÚ	order_dirÚpaid_sqÚplacesÚrecords_totalÚrecords_filteredÚ	order_mapÚfieldÚ	directionÚrowsrR   ÚiÚpÚqs                      úL/var/www/html/nexus_chitfund_web/controllers/Staff/LoanregisterController.pyÚview_loan_request_pageru      sg  € Ø‡�×ÑÐ-Ó.Ð2BÒBÜ wÐ;MÑNÐWZÔ[Ð[ðFÜ�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Ó&×/Ñ/Ü˜g›Ü! '´!À+Ô2NÔOÜ!¤#Ð&:Ó";¼UÀ1»XÔTYÔZÜœSÐ!7Ó8¼%À»(ÔQVÔWÜœ( 7¼Ô?ÄÀqÃÔX]Ô^ð 0ó 
÷ ‰(¤! I£,´°6³Ñ":ˆ(Ó
;ð 	ô % WÓ-×3Ñ3Ó5ˆÙØ—]‘]°6�]Ó:ˆFØ!Ÿ<™<›>Ðà  }¸>ÑJˆ	Ø˜	Ñ!Ø˜iÑ(ˆEØ(¨FÒ2™¸ˆIØ—_‘_Ø�+˜e˜WÐ%ØØó‰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Ø,/°×0@Ñ0@ÀÐ/FÐ*GÜ%Ð&:À!Ç$Á$ÀÔHÜ!(Ð)EÈQÏTÉTÈFÔ!Sñõ ð 5ô ØØ)Ø/Øñ	
ó ð 	øô ò Ü×ÑÐ8Ô9ÜØ q¸QÈØ5ñ
ð ôò 	ðús   °M/N  Î 1OÏOc                 ó,  — | j                   j                  dd«      j                  «       }|st        dddœd¬«      S t	        |«      dkD  rt        dd	dœd¬«      S d
j                  |j                  «       «      }t        j                  j                  |¬«      j                  «       rt        dddœd¬«      S t        j                  j                  |¬«      }| j                  j                  j                  |«       t        dd|j                  dœ«      S )NrK   r(   r   úPlace name is required.r   r!   r"   é–   úMax 150 characters.Ú ©Úname__iexactúPlace already exists.)r>   ÚsuccesszPlace added.)r   r    r`   )ÚPOSTrT   rW   r   ÚlenÚjoinÚsplitr   rX   r2   ÚexistsÚcreateÚstaffrj   Úaddr`   )re   r>   rG   s      rt   Ú	add_placer‡   g   sâ   € à�<‰<×Ñ˜L¨"Ó-×3Ñ3Ó5€DÙÜ wÐ;TÑUÐ^aÔbÐbÜ
ˆ4ƒy�3‚Ü wÐ;PÑQÐZ]Ô^Ð^Ø�8‰8�D—J‘J“LÓ!€DÜ‡}�}×Ñ¨ÐÓ.×5Ñ5Ô7Ü wÐ;RÑSÐ\_Ô`Ð`Ü�M‰M× Ñ  dÐ Ó+€Eà‡M�M×Ñ×Ñ˜UÔ#Ü 9¸ÈuÏxÉxÑXÓYÐYó    c                 óâ  — | j                   j                  d«      }dj                  | j                   j                  dd«      j                  «       «      }|st	        dddœd¬	«      S t        |«      d
kD  rt	        dddœd¬	«      S 	 t        | |«      st        j                  ‚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)NrJ   rz   rK   r(   r   rw   r   r!   r"   rx   ry   )r*   zPlace not found.i”  r{   r}   r>   )Úupdate_fieldsr~   zPlace updated.)r   rT   r�   r‚   r   r€   r   r   ÚDoesNotExistrX   Ú
ValueErrorÚexcluder*   r2   rƒ   r>   Úsave)re   rJ   r>   rG   s       rt   Úupdate_placer�   w   sG  € à�|‰|×Ñ 
Ó+€HØ�8‰8�G—L‘L×$Ñ$ \°2Ó6×<Ñ<Ó>Ó?€DÙÜ wÐ;TÑUÐ^aÔbÐbÜ
ˆ4ƒy�3‚Ü wÐ;PÑQÐZ]Ô^Ð^ð\Ü% g¨xÔ8Ü×$Ñ$Ð$Ü—‘×!Ñ! 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   Â<E Å)E.Å-E.c                 óz  — | j                   j                  d«      }t        | |«      st        dg i«      S 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 )NrJ   rR   Úcustomerr0   )rJ   r   ú-closed_daterD   r$   rF   z%Y-%m-%drC   )	r`   ÚsnoÚcustomer_nameÚphone_numberÚ	loan_dateÚloan_amountÚpayment_typeÚnumber_of_duesÚclosed_date)rV   rT   r   r   r   rX   Úselect_relatedr2   r]   r^   r_   r`   r”   r•   r–   Ústrftimera   r—   Úget_payment_type_displayr™   rš   )re   rJ   r/   rR   rq   Úls         rt   Úplace_completed_loan_datarŸ   Ž   s  € Ø�{‰{�‰˜zÓ*€HÜ! '¨8Ô4Ü˜V R˜LÓ)Ð)Ü�L‰L×'Ñ'¨
Ó3×:Ñ:ÀHÐU`Ð:Óaß‘X˜n¨eÓ4ð 
à€DÜ˜% q×)‰ˆˆ1Ø�‰Ø—$‘$ØØŸ_™_ØŸN™NØŸ™×-Ñ-¨jÓ9Ü  §¡Ó/Ø×6Ñ6Ó8Ø×.Ñ.ØABÇÂ˜1Ÿ=™=×1Ñ1°*Ô=ÐTWñ

õ 
	ð *ô ˜ ˜Ó'Ð'rˆ   c                 óŠ  — t         j                  j                  t        d«      ¬«      j	                  d«      j                  t        d«      ¬«      j	                  d«      }t        | 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.                  j0                  t3        |j4                  «      t3        |j$                  «      t3        |«      t3        |j6                  «      |j8                  |j:                  dk(  rdnddœ«       ŒÖ t=        d|i«      S )Nr*   )Úloanr¡   r,   r-   r.   rG   r‘   r4   r   )r;   rD   r$   rF   r0   Ú	CompletedÚPending)r`   r“   r”   r•   rG   r—   Úpaid_amountr<   Ú
due_amountr™   r   rR   )r   rX   r2   r   rY   rZ   r
   r   r   r›   r   r	   r[   r   r]   r^   ÚmaxÚtotal_payabler;   r_   r`   r”   r•   rG   r>   ra   r—   r¥   r™   r   r   )re   ri   r/   rR   rq   rž   Úpendings          rt   Úloan_entries_datar©   ¤   sO  € ä×Ñ×"Ñ"¬°«Ð"Ó7ß	‰�‹Ÿ™¤3 x£=˜Ó1·&±&¸³+ð ô
 	�GœTŸ\™\×8Ñ8¸À*ÓMÓNß	‰”x¤¨¼uÔ EÜ % a£´uô>ˆó 
?ç	‰�%‹ð	 
ð €DÜ˜% q×)‰ˆˆ1Ü�a—o‘o¨¯©Ñ.°Ó2ˆØ�‰Ø—$‘$ØØŸ_™_ØŸN™NØ—W‘W—\‘\Ü  §¡Ó/Ü  §¡›=Ü# G›nÜ §¡Ó-Ø×.Ñ.Ø%&§X¡X°Ò%<‘kÀ)ñ
õ 	ð *ô ˜ ˜Ó'Ð'rˆ   c           	      ó°   — ddl m}  || t        | t        j                  j                  d¬«      «      j                  dd«      j                  dd«      «      S )	Nr   )Úcompleted_loans_filteredr0   r"   rG   r‘   r’   rD   )Ú-controllers.Admin.AdminloanregisterControllerr«   r   r   rX   r2   r›   r]   )re   r«   s     rt   Ú_my_completed_loansr­   Ä   sI   € ÝVÙ#ØÜ�GœTŸ\™\×0Ñ0¸Ð0ÓDÓEß	‰˜ Ó	,ß	‰�. %Ó	(ó	ð rˆ   c                 óF   — ddl m} t        d |t        | «      «      i«      S )Nr   )Úcompleted_loan_rowsrR   )r¬   r¯   r   r­   )re   r¯   s     rt   Úcompleted_loan_datar°   Î   s!   € ÝQÜ˜Ñ!4Ô5HÈÓ5QÓ!RÐSÓTÐTrˆ   c                 óB   — ddl m}m}  ||  |t        | «      «      «      S )zIExcel of the staff member's completed loans (closed-date range + search).r   )r¯   Úcompleted_loans_xlsx)r¬   r¯   r²   r­   )re   r¯   r²   s      rt   Úcompleted_loan_exportr³   Ó   s#   € ÷ñ   Ñ)<Ô=PÐQXÓ=YÓ)ZÓ[Ð[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.staff_scoper   r   r   r   Ú	getLoggerÚ__name__rc   r[   ru   r‡   r�   rŸ   r©   r­   r°   r³   © rˆ   rt   Ú<module>rÁ      sª   ðÙ FÛ Ý "÷÷ ó õ 0Ý $Ý Ý 5ç .Ý  ÷ó ð 
ˆ×	Ñ	˜8Ó	$€Ù °1Ô5€òJð` ñZó ðZð ñLó ðLò,(ò,(ò@òUó
\rˆ   