Ë
    ÛŽýjaE  ã                   ó>  — d dl Z d dlZd dlmZmZ d dl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 d d
lmZmZmZ  e j8                  e«      Zd dlm Z m!Z!m"Z"m#Z#m$Z$m%Z%m&Z&m'Z'  e j8                  e«      Zd„ Z(ed„ «       Z)d„ Z*d„ Z+y)é    N)ÚIntegrityErrorÚtransaction)ÚCountÚMaxÚQ)ÚJsonResponse)Úreverse)Úrequire_POST)ÚrenderÚredirect)Úmessages)ÚCustomerÚLoanÚPlace)Ústaff_customersÚstaff_loansÚstaff_places)Ú	MAX_NOTESÚ	MAX_PLACEÚTOTAL_LIMITÚ_customer_form_dataÚ_json_errorÚ_parse_dateÚ_parse_moneyÚ_validate_customerc                 óf
  — t         j                  dd| j                  i¬«       | j                  dk7  rt        dd«      S t	        | «      }| j
                  j                  d«      }dj                  | j                  j                  d	d
«      j                  «       «      }| j                  j                  dd
«      j                  «       }| j                  j                  dd
«      j                  «       }| j                  j                  dd
«      j                  «       }| j                  j                  dd
«      j                  «       }| j                  j                  dd
«      j                  «       }| j                  j                  dd
«      j                  «       }	| j                  j                  dd
«      j                  «       }
t        ||d¬«      }d }|sd|d	<   nPt        |«      t        kD  rdt        › d�|d	<   n0t        | «      j                  |¬«      j!                  «       }|€d|d	<   d }|sd|d<   nt#        |«      }|sd|d<   d }|sd|d<   nt%        |«      }|€d|d<   t&        j(                  D ��cg c]  \  }}|‘Œ	 }}}|sd|d<   n	||vrd|d<   d }|sd|d<   n8t#        |«      }|sd|d<   n%|r||k  rd |d<   n|j+                  «       d!k(  rd"|d<   d }|sd#|d<   n5t-        j.                  d$|«      rt1        |«      d%k  rd&|d<   nt1        |«      }d }|	sd'|d<   nt%        |	«      }|€d(|d<   d|vrd|vr||z  t2        k\  rd)|d<   |
sd*|d<   nt        |
«      t4        kD  rd+t4        › d�|d<   |r)t         j7                  d,d-|i¬«       t9        d.|d/œd0¬1«      S 	 t;        j<                  «       5  t>        j@                  jC                  «       j                  |d2   ¬3«      j!                  «       }|€t?        |d2   ¬3«      }|d4   |_"        |d5   |_#        |d6   |_$        |d7   |_%        |d8   |_&        |r||_'        |jQ                  «        t&        j@                  jS                  ||tU        | d9d «      |||||||
¬:«
      }d d d «       t         j                  d;d<jV                  i¬«       t9        d=d>tY        d?«      d@œ«      S c c}}w # 1 sw Y   ŒJxY w# tZ        $ r# t         j]                  dA«       t        dB«      cY S t^        $ r$ t         j]                  dC«       t        dDdE«      cY S w xY w)FNzloan creation startedÚmethod©ÚextraÚPOSTúInvalid request method.é•  Úaadhaar_photoÚ ÚplaceÚ Ú	loan_dateÚloan_amountÚpayment_typeÚfirst_due_dateÚnumber_of_duesÚ
due_amountÚnotesT©Úreferral_requiredzSelect a place.zPlace cannot exceed z characters.)Úname__iexactz3You can only add loans for your assigned locations.zLoan date is required.z%Invalid date format (use YYYY-MM-DD).zLoan amount is required.z4Enter a valid positive loan amount (max 2 decimals).zPayment type is required.zSelect a valid payment type.zFirst due date is required.z.First due date cannot be before the loan date.é   z7First due date cannot be a Sunday (no dues on Sundays).zNumber of dues is required.z
[0-9]{1,9}r   zEnter a valid number of dues.zDue amount is required.z"Enter a valid positive due amount.z4Total payable is too large for the given due amount.zNotes are required.zNotes cannot exceed z.loan creation failed due to validation errors.ÚerrorsÚerror)Ústatusr2   é�  ©r4   Úaadhaar_number©r7   Úcustomer_nameÚphone_numberÚaddressÚreferral_nameÚreferral_phoneÚstaff)
Úcustomerr%   r>   r'   r(   r)   r*   r+   r,   r-   zloan created successfullyÚloan_idÚsuccesszLoan added successfully.zstaff:loan_registers©r4   ÚmessageÚredirect_urlz7loan creation failed due to a database integrity error.z9Loan could not be saved because of a database constraint.zloan creation failed.z*Loan could not be added. Please try again.éô  )0ÚloggerÚinfor   r   r   ÚFILESÚgetÚjoinr    ÚsplitÚstripr   Úlenr   r   ÚfilterÚfirstr   r   r   ÚPAYMENT_TYPE_CHOICESÚweekdayÚreÚ	fullmatchÚintr   r   Úwarningr   r   Úatomicr   ÚobjectsÚselect_for_updater9   r:   r;   r<   r=   r#   ÚsaveÚcreateÚgetattrÚidr	   r   Ú	exceptionÚ	Exception)ÚrequestÚcustomer_datar#   r%   r'   r(   r)   r*   r+   r,   r-   r2   Ú	place_objÚparsed_loan_dateÚamountÚvalueÚ_Úvalid_payment_typesÚparsed_first_dueÚduesÚper_duer?   Úloans                          úM/var/www/html/nexus_chitfund_web/controllers/Staff/Staff_addloanController.pyÚstaff_addloanrl   !   sO  € Ü
‡K�KÐ'°¸'¿.¹.Ð/I€KÔJà‡~�~˜ÒÜÐ4°cÓ:Ð:ä'¨Ó0€MØ—M‘M×%Ñ% oÓ6€Mà�H‰H�W—\‘\×%Ñ% g¨rÓ2×8Ñ8Ó:Ó;€Eà—‘× Ñ  ¨bÓ1×7Ñ7Ó9€IØ—,‘,×"Ñ" =°"Ó5×;Ñ;Ó=€KØ—<‘<×#Ñ# N°BÓ7×=Ñ=Ó?€LØ—\‘\×%Ñ%Ð&6¸Ó;×AÑAÓC€NØ—\‘\×%Ñ%Ð&6¸Ó;×AÑAÓC€NØ—‘×!Ñ! ,°Ó3×9Ñ9Ó;€JØ�L‰L×Ñ˜W bÓ)×/Ñ/Ó1€Eä ¨}ÐPTÔU€Fà€IÙØ+ˆˆwŠÜ	ˆU‹”iÒ	Ø0´°¸<ÐHˆˆwŠô ! Ó)×0Ñ0¸eÐ0ÓD×JÑJÓLˆ	ØÐØSˆF�7‰OàÐÙØ6ˆˆ{Òä& yÓ1ÐÙØ"IˆF�;Ñà€FÙØ :ˆˆ}Òä˜kÓ*ˆØˆ>Ø$ZˆF�=Ñ!ä15×1JÒ1JÔKÑ1J¡X U¨Aš5Ð1JÐÑKÙØ!<ˆˆ~ÒØ	Ð0Ñ	0Ø!?ˆˆ~ÑàÐÙØ#@ˆÐÒ ä& ~Ó6ÐÙØ'NˆFÐ#Ò$ÙÐ"2Ð5EÒ"EØ'WˆFÐ#Ò$Ø×%Ñ%Ó'¨1Ò,Ø'`ˆFÐ#Ñ$à€DÙØ#@ˆÐÒ Ü�\‰\˜-¨Ô8¼CÀÓ<OÐSTÒ<TØ#BˆÐÒ ä�>Ó"ˆà€GÙØ8ˆˆ|Òä˜zÓ*ˆØˆ?Ø#GˆF�<Ñ à˜6Ñ!Ð&6¸fÑ&DØ�T‰>œ[Ò(Ø']ˆFÐ#Ñ$áØ/ˆˆwŠÜ	ˆU‹”iÒ	Ø0´°¸<ÐHˆˆw‰áÜ�‰ÐGØ&¨Ð/ð 	ô 	1ä w¸&ÑAÈ#ÔNÐNð,NÜ×ÑÕ!ô  ×'Ñ'×9Ñ9Ó;×BÑBØ,Ð-=Ñ>ð Có ç‰e‹gð ð ÐÜ#°=ÐAQÑ3RÔS�à%2°?Ñ%CˆHÔ"Ø$1°.Ñ$AˆHÔ!Ø,¨YÑ7ˆHÔØ%2°?Ñ%CˆHÔ"Ø&3Ð4DÑ&EˆHÔ#ÙØ)6�Ô&Ø�M‰MŒOä—<‘<×&Ñ&Ø!ØÜ˜g w°Ó5Ø*Ø"Ø)Ø/Ø#Ø"Øð 'ó ˆD÷% "ô> 	�‰Ð/¸	À4Ç7Á7Ð7KˆÔLÜØØ1Ü#Ð$:Ó;ñ
ó ð 	ùóc L÷b "Ð!ûôL ò XÜ×ÑÐRÔSÜÐVÓWÒWÜò NÜ×ÑÐ0Ô1ÜÐGÈÓMÒMðNús8   É7SÎ S Î4CSÒAS ÓSÓS Ó)T0Ô)T0Ô/T0c                 ó~  — | j                   j                  dd«      j                  «       }t        j                  d|«      st        d«      S t        j                  j                  |¬«      j                  «       }|st        dddœd	¬
«      S |j                  j                  d«      j                  «       }t        d|j                  |r|j                  j                  nd|j                   |j"                  |j$                  xs d|j&                  xs d|j(                  r|j(                  j*                  nddœdœ«      S )Nr7   r&   z	[0-9]{12}z&Enter a valid 12-digit Aadhaar number.r8   Ú	not_foundzNo existing customer found.)r4   rC   é”  r6   r%   rA   )r:   r%   r9   r;   r<   r=   r#   )r4   Údata)r    rI   rL   rR   rS   r   r   rW   rN   rO   r   ÚloansÚselect_relatedr:   r%   Únamer9   r;   r<   r=   r#   Úurl)r_   r7   r?   Ú	last_loans       rk   Ústaff_get_loan_customer_detailsrv   ±   s  € à—\‘\×%Ñ%Ð&6¸Ó;×AÑAÓC€Nä�<‰<˜ nÔ5ÜÐCÓDÐDä×Ñ×&Ñ&°nÐ&ÓE×KÑKÓM€HÙÜØ!Ø4ñ
ð ôð 	ð
 —‘×-Ñ-¨gÓ6×<Ñ<Ó>€IäØà$×1Ñ1Ù-6�Y—_‘_×)Ò)¸BØ%×3Ñ3Ø×'Ñ'Ø%×3Ñ3Ò9°rØ&×5Ñ5Ò;¸Ø;C×;QÒ;Q˜X×3Ñ3×7Ò7ÐWYñ
ñó ð ó    c                 óÐ  — | j                   j                  d«      dk7  rt        d«      S d}	 t        | j                  j                  dd«      «      }t        t        | j                  j                  dd«      «      d«      }t        | j                  j                  dd	«      «      }| j                  j                  d
d«      j                  «       }| j                  j                  dd«      }| j                  j                  dd«      }t        | «      }|j                  «       }|rj|j                  t        |¬«      t        |¬«      z  t        |¬«      z  t        t        | «      j                  |¬«      j                  d«      ¬«      z  «      }|j                  «       }	t        t        | «      j                  dd¬«      «      }
|j!                  t#        dt        |
¬«      ¬«      t%        dt        |
¬«      ¬«      ¬«      }ddd œ}||v r"||   }|d!k(  rd"|z   }|j'                  |d#«      }n|j'                  d#«      }t        |d$k(  r||d  n||||z    «      }|D �cg c]  }|j(                  sŒ|j(                  ‘Œ }}t*        j,                  j                  |¬«      j/                  d%«      D �ci c]#  }|j0                  |j2                  j4                  “Œ% }}g }t7        ||dz   ¬&«      D ]©  \  }}t9        d'|j0                  g¬(«      }|j(                  rt9        d)«      › d*|j(                  › �nd}|j;                  ||j0                  |j<                  xs d"|j>                  xs d"|j                  |j(                  d"«      |j@                  ||d+œ«       Œ« tC        |||	|d,œ«      S c c}w c c}w # tD        $ r+ tF        jI                  d-«       tC        |ddg d.d/œd0¬1«      cY S w xY w)2Nzx-requested-withÚXMLHttpRequestzInvalid request.é   ÚdrawÚstartr   Úlengthé
   zsearch[value]r&   zorder[0][column]Ú1zorder[0][dir]Úasc)Úcustomer_name__icontains)Úphone_number__icontains)Úaadhaar_number__icontains)Úplace__name__icontainsÚcustomer_id)Úid__inr\   T)Úflatrq   )Úloans__place_id__in)rN   Ú	loans__id)Útotal_chitsÚlatest_loan_idr9   rŠ   )r   Ú2ÚdescÚ-z-idéÿÿÿÿr%   )r|   zstaff:edit_customer)Úargszstaff:view_customer_detailsz?id=)ÚDT_RowIndexr\   r9   r:   r%   rŠ   Úedit_urlÚview_url)r{   ÚrecordsTotalÚrecordsFilteredrp   zstaff_view_all_customer failedzCould not load customers.)r{   r”   r•   rp   r3   rE   r6   )%ÚheadersrI   r   rT   ÚGETÚmaxrL   r   ÚcountrN   r   r   ÚvaluesÚlistr   Úvalues_listÚannotater   r   Úorder_byr‹   r   rW   rr   r\   r%   rs   Ú	enumerater	   Úappendr9   r:   rŠ   r   r^   rF   r]   )r_   r{   r|   r}   ÚsearchÚ	order_colÚ	order_dirÚ	customersÚrecords_totalÚrecords_filteredÚmy_place_idsÚ	order_mapÚfieldÚrowsÚcÚ
latest_idsrj   Úplace_by_loanÚresultÚindexr?   r’   r“   s                          rk   Ústaff_view_all_customerr°   Ð   sÉ  € Ø‡�×ÑÐ-Ó.Ð2BÒBÜÐ-Ó.Ð.à€DðNÜ�7—;‘;—?‘? 6¨1Ó-Ó.ˆÜ”C˜Ÿ™Ÿ™¨°Ó3Ó4°aÓ8ˆÜ�W—[‘[—_‘_ X¨rÓ2Ó3ˆØ—‘—‘ °"Ó5×;Ñ;Ó=ˆØ—K‘K—O‘OÐ$6¸Ó<ˆ	Ø—K‘K—O‘O O°UÓ;ˆ	ä# GÓ,ˆ	Ø!Ÿ™Ó)ˆáØ!×(Ñ(Ü¨6Ô2Ü¨&Ô1ñ2ä¨FÔ3ñ4ô œ WÓ-×4Ñ4Ø+1ð 5ó 3ß39±6¸-Ó3HôJñJóˆIð %Ÿ?™?Ó,ÐäœL¨Ó1×=Ñ=¸dÈÐ=ÓNÓOˆØ×&Ñ&Ü˜g¬aÀLÔ.QÔRÜ˜{´1ÈÔ3VÔWð 'ó 
ˆ	ð
 *°Ñ>ˆ	Ø˜	Ñ!Ø˜iÑ(ˆEØ˜FÒ"Ø˜e™�Ø!×*Ñ*¨5°%Ó8‰Ià!×*Ñ*¨5Ó1ˆIä¨°2ª�I˜e˜fÑ%¸9ÀUÈ5ÐSYÉ>Ð;ZÓ[ˆñ 15ÓI±¨1¸×8HÓ8H�a×&Ó&°ˆ
ÐIô Ÿ™×+Ñ+°:Ð+Ó>×MÑMÈgÔVó
áV�ð �G‰G�T—Z‘Z—_‘_Ñ$ØVð 	ð 
ð
 ˆÜ(¨°U¸Q±Y×?‰OˆE�8ÜÐ4¸H¿K¹K¸=ÔIˆHð ×*Ò*ô Ð8Ó9Ð:¸$¸x×?VÑ?VÐ>WÑXØ02ð ð �M‰MØ$Ø—k‘kØ!)×!7Ñ!7Ò!>¸3Ø (× 5Ñ 5Ò <¸Ø&×*Ñ*¨8×+BÑ+BÀCÓHØ'×3Ñ3Ø$Ø$ñ	õ 	ð  @ô" ØØ)Ø/Øñ	
ó ð 	ùò1 Jùò
øô< ò Ü×ÑÐ9Ô:ÜØØØ ØØ0ñ
ð ôò 	ðús7   ­H/N1 ÉN'É.N'É<3N1 Ê/(N,ËCN1 Î'
N1 Î11O%Ï$O%c                 óL  — t         j                  d| j                  |dœ¬«       	 t        | «      j	                  |¬«      }| j                  dk(  rt        | dd|i«      S | j                  dk7  r0t         j                  d|| j                  dœ¬«       t        dd«      S 	 t        | «      }| j                   j	                  d«      }t#        ||d¬«      }|r+t         j                  d||dœ¬«       t%        dd|dœd¬«      S t'        j(                  «       5  t
        j*                  j-                  «       j	                  |¬«      }t
        j*                  j/                  |d   ¬ «      j1                  |j2                  ¬!«      j5                  «       }|r5t         j                  d"d|i¬«       t%        dd#dd#idœd¬«      cd d d «       S |d$   |_        |d%   |_        |d&   |_        |d   |_        |d'   xs d |_        |d(   xs d |_         |r||_!        |jE                  «        d d d «       t         j                  d)d|jF                  i¬«       t%        d*d+tI        d
«      d,œ«      S # t
        j                  $ rZ t         j                  dd|i¬«       | j                  dk(  rt        dd	«      cY S t        j                  | d«       t        d
«      cY S t        $ rZ t         j                  dd|i¬«       | j                  dk(  rt        dd«      cY S t        j                  | d«       t        d
«      cY S w xY w# 1 sw Y   �ŒxY w# tJ        $ r( t         j                  d-d|i¬«       t        d.d«      cY S t        $ r( t         j                  d/d|i¬«       t        d0d«      cY S w xY w)1NzCustomer update started)r   r…   r   )r\   zCustomer not foundr…   r    zCustomer record not found.ro   zstaff:customer_managementzError while fetching customerz!Unable to fetch customer details.rE   r—   zstaffpanel/edit_customer.htmlr?   z&Invalid customer update request method)r…   r   r!   r"   r#   Fr.   z!Customer update validation failed)r…   r2   r3   z%Please correct the validation errors.)r4   rC   r2   r5   r6   r7   r8   )Úpkz/Duplicate Aadhaar number during customer updatez0This Aadhaar number belongs to another customer.r9   r:   r;   r<   r=   zCustomer updated successfullyrA   z&Customer details updated successfully.rB   z(Customer update database integrity errorz;Customer could not be updated due to a database constraint.zCustomer update failedz0Customer could not be updated. Please try again.)&rF   rG   r   r   rI   r   ÚDoesNotExistrU   r   r   r3   r   r^   r]   r   r   rH   r   r   r   rV   rW   rX   rN   Úexcluder²   Úexistsr9   r:   r;   r7   r<   r=   r#   rY   r\   r	   r   )r_   r…   r?   rp   r#   r2   Úaadhaar_existss          rk   Ústaff_update_customerr·   '  s  € Ü
‡K�KØ!à—n‘nØ&ñ
ð ô ð5Ü" 7Ó+×/Ñ/°;Ð/Ó?ˆð: ‡~�~˜ÒÜØØ+Ø˜Ð"ó
ð 	
ð ‡~�~˜ÒÜ�‰Ø4à*Ø!Ÿ.™.ñð 	ô 	
ô Ð4°cÓ:Ð:ð
o
Ü" 7Ó+ˆØŸ™×)Ñ)¨/Ó:ˆä#ØØØ#ô
ˆñ Ü�N‰NØ3à#.Ø$ñð ô ô  Ø!ØBØ ñ!ð ô	ð ô ×ÑÕ!ô  ×'Ñ'×9Ñ9Ó;×?Ñ?Øð @ó ˆHô
 &×-Ñ-×4Ñ4Ø#Ð$4Ñ5ð 5ó ç‰gØ—;‘;ð ó ç‰f‹hð	 ñ Ü—‘ØEØ(¨+Ð6ð ô ô
 $Ø%ØQà(Ð*\ðñ%ð ô÷) "Ñ!ð: &*¨/Ñ%:ˆHÔ"Ø$(¨Ñ$8ˆHÔ!Ø# I™ˆHÔØ&*Ð+;Ñ&<ˆHÔ#Ø%)¨/Ñ%:Ò%B¸dˆHÔ"Ø&*Ð+;Ñ&<Ò&DÀˆHÔ#ñ Ø)6�Ô&à�M‰MŒO÷Q "ôZ 	�‰Ø+Ø  (§+¡+Ð.ð 	ô 	
ô
 ØØ?Ü#Ð$?Ó@ñ
ó ð 	øô × Ñ ò 
5Ü�‰Ø Ø  +Ð.ð 	ô 	
ð
 �>‰>˜VÒ#ÜÐ;¸SÓAÒAä�‰�wÐ <Ô=ÜÐ3Ó4Ò4äò 
5Ü×ÑØ+Ø  +Ð.ð 	ô 	
ð
 �>‰>˜VÒ#ÜÐBÀCÓHÒHä�‰�wÐ CÔDÜÐ3Ó4Ò4ð
5ú÷B "Ñ!ûôv ò 

ä×ÑØ6Ø  +Ð.ð 	ô 	
ô
 ØIØó
ò 	
ô ò 

ä×ÑØ$Ø  +Ð.ð 	ô 	
ô
 Ø>Øó
ò 	
ð

úsj   ¦I% ÂA M Ä M ÄB'L6Æ;	M ÇAL6È"AM É%AL3Ê.!L3Ë<L3Ì!L3Ì2L3Ì6M Ì;M Í.N#Í3-N#Î"N#),ÚloggingrR   Ú	django.dbr   r   Údjango.db.modelsr   r   r   Údjango.httpr   Údjango.urlsr	   Údjango.views.decorators.httpr
   Údjango.shortcutsr   r   Údjango.contribr   ÚNexusApp.modelsr   r   r   ÚNexusApp.utils.staff_scoper   r   r   Ú	getLoggerÚ__name__rF   Ú#controllers.Admin.AddLoanControllerr   r   r   r   r   r   r   r   rl   rv   r°   r·   © rw   rk   Ú<module>rÆ      s�   ðÛ Û 	ç 1ß *Ñ *Ý $Ý Ý 5Ý $ß -Ý #ß 1Ñ 1ß QÑ Qà	ˆ×	Ñ	˜8Ó	$€÷	÷ 	ó 	ð 
ˆ×	Ñ	˜8Ó	$€òLNð` ñó ðò<Sónp
rw   