Ë
    ØÖûj>3  ã                   ó(  — d dl Z d dlZd dl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 d d
lmZ  e j,                  e«      Z ej2                  d«      Z ej2                  d«      Z eej:                  «      Z eej>                  «      Z  eejB                  «      Z" eejF                  «      Z$ ej2                  d«      Z%dddddœZ&d„ Z'd„ Z(ed„ «       Z)d„ Z*ddddddœZ+d„ Z,ed„ «       Z-ed„ «       Z.d„ Z/ed„ «       Z0y) é    N)Údatetime)ÚDecimalÚInvalidOperation)Útransaction)ÚQ)ÚJsonResponse)Úmessages)ÚredirectÚrender)Úrequire_GETÚrequire_POST)ÚLoanLeadz[6-9][0-9]{9}z[A-Za-z][A-Za-z .'-]*z[0-9]+é–   éÈ   ©ÚnameÚplaceÚsource_detailsÚ
agent_namec                 ój   — 	 t        j                  | d«      j                  «       S # t        $ r Y y w xY w)Nz%Y-%m-%d)r   ÚstrptimeÚdateÚ
ValueError)Úvalues    úH/var/www/html/nexus_chitfund_web/controllers/Admin/LoanleadController.pyÚ_parse_dater   %   s5   € ðÜ× Ñ  ¨
Ó3×8Ñ8Ó:Ð:øÜò Ùðús   ‚#& ¦	2±2c                 ó¨   — t        | dd«      }|�C|j                  r7|j                  «       xs |j                  «       t	        |j
                  «      fS y)zÂ
    Staff details must come from the logged-in user, NOT from request.POST
    (anyone could post another staff's name/id). Adapt this to however your
    JWT/cookie auth exposes the user.
    ÚuserN)Ú r   )ÚgetattrÚis_authenticatedÚget_full_nameÚget_usernameÚstrÚpk)Úrequestr   s     r   Ú_current_staffr'   ,   sM   € ô �7˜F DÓ)€DØÐ˜D×1Ò1Ø×"Ñ"Ó$Ò;¨×(9Ñ(9Ó(;¼cÀ$Ç'Á'»lÐJÐJØó    c                 óü  — 	 | j                   }|j                  dd«      j                  «       }|j                  dd«      j                  «       }dj                  |j                  dd«      j	                  «       «      }|j                  dd«      j                  «       }|j                  dd«      j                  «       }|j                  dd«      j                  «       }|j                  d	d«      j                  «       }|j                  d
d«      j                  «       }	|j                  dd«      j                  «       }
|j                  dd«      j                  «       }|j                  dd«      j                  «       }|j                  dd«      j                  «       }|j                  dd«      j                  «       }|j                  dd«      j                  «       }i }t        |«      }t        |«      }|sd|d<   |sd|d<   |r|r
||k  rd|d<   |sd|d<   |sd|d	<   n	 t        |«      }|dk  rd|d	<   |sd|d<   n.t        |«      dk  rd|d<   nt        j                  |«      sd|d<   t        j                  |«      sd|d<   |t        vrd|d<   d }|rc	 t        |«      }|j                  «       st        ‚|dk  rd|d	<   n6|j                  «       j                  dk  rd |d	<   n|t        d!«      k\  rd"|d	<   |	r|	t         vrd#|d
<   |
t"        vrd$|d<   n|
d%v r|sd&|d<   |rt        j                  |«      sd'|d<   |r|sd(|d<   ||||d)œ}t$        j'                  «       D ]%  \  }}t        ||   «      |kD  sŒ||vsŒd*|› d+�||<   Œ' |rt)        d,|d-œd.¬/«      S t+        | «      \  }}t-        j.                  «       5  t0        j2                  j5                  ||||||||	xs d |
|d0||||||¬1«      }d d d «       t)        d2d3j6                  d4œ«      S # t        $ r	 d|d	<   Y �Œïw xY w# t        $ r	 d|d	<   Y �Œ@w xY w# 1 sw Y   ŒLxY w# t8        $ r( t:        j=                  d5«       t)        d,d6d7œd8¬/«      cY S w xY w)9NÚ	lead_dater   Úfollowup_dateÚ r   r   ÚphoneÚ	loan_typeÚloan_amountÚpayment_typeÚsourcer   r   Úagent_mobileÚpurposeÚremarkszEnter a valid lead date.zEnter a valid follow-up date.z.Follow-up date cannot be before the lead date.zPlace is required.zLoan amount is required.r   z&Loan amount must be greater than zero.zEnter a valid loan amount.zCustomer name is required.é   z#Name must be at least 3 characters.z/Name can contain only letters, spaces and . ' -z%Enter a valid 10-digit mobile number.zSelect a valid loan type.éþÿÿÿz.Loan amount can have at most 2 decimal places.Ú10000000000zLoan amount is too large.zSelect a valid payment type.zSelect a valid source.)Ú	referenceÚsocial_mediaÚadvertisementzPlease enter source details.z"Enter a valid agent mobile number.z,Enter the agent name for this mobile number.r   zMaximum z characters allowed.Úerror)ÚstatusÚerrorsi¦  ©r<   Úactive)r*   r+   r   r   r-   r.   r/   r0   r1   r   r<   Ú
staff_nameÚstaff_idr   r2   r3   r4   ÚsuccesszLead added successfully.)r<   ÚmessageÚlead_idzError while storing leadz/Something went wrong while saving lead details.©r<   rC   éô  )ÚPOSTÚgetÚstripÚjoinÚsplitr   r   r   ÚlenÚNAME_REÚ	fullmatchÚ	MOBILE_REÚ
LOAN_TYPESÚ	is_finiteÚas_tupleÚexponentÚPAYMENT_TYPESÚSOURCESÚMAX_LENÚitemsr   r'   r   Úatomicr   ÚobjectsÚcreateÚidÚ	ExceptionÚloggerÚ	exception)r&   ÚpostÚlead_date_rawÚfollowup_rawr   r   r-   r.   r/   r0   r1   r   r   r2   r3   r4   r=   r*   r+   ÚamountÚvaluesÚfieldÚlimitr@   rA   Úleads                             r   Ústore_leadsrg   9   s½  € ðDØ�|‰|ˆØŸ™ ¨bÓ1×7Ñ7Ó9ˆØ—x‘x °Ó4×:Ñ:Ó<ˆØ�x‰x˜Ÿ™ ¨Ó,×2Ñ2Ó4Ó5ˆØ—‘˜ "Ó%×+Ñ+Ó-ˆØ—‘˜ "Ó%×+Ñ+Ó-ˆØ—H‘H˜[¨"Ó-×3Ñ3Ó5ˆ	Ø—h‘h˜}¨bÓ1×7Ñ7Ó9ˆØ—x‘x °Ó3×9Ñ9Ó;ˆØ—‘˜( BÓ'×-Ñ-Ó/ˆØŸ™Ð"2°BÓ7×=Ñ=Ó?ˆØ—X‘X˜l¨BÓ/×5Ñ5Ó7ˆ
Ø—x‘x °Ó3×9Ñ9Ó;ˆØ—(‘(˜9 bÓ)×/Ñ/Ó1ˆØ—(‘(˜9 bÓ)×/Ñ/Ó1ˆàˆô   Ó.ˆ	Ü# LÓ1ˆÙØ"<ˆF�;ÑÙØ&EˆF�?Ñ#Ù™¨=¸9Ò+DØ&VˆF�?Ñ#áØ2ˆF�7‰OáØ$>ˆF�=Ò!ðEÜ  Ó-�Ø˜Q’;Ø,T�F˜=Ñ)ñ
 Ø9ˆF�6ŠNÜ�‹Y˜Š]ØBˆF�6ŠNÜ×"Ñ" 4Ô(ØNˆF�6‰Nô ×"Ñ" 5Ô)ØEˆF�7‰Oð œJÑ&Ø"=ˆF�;ÑàˆÙðEÜ  Ó-�Ø×'Ñ'Ô)Ü*Ð*Ø˜Q’;Ø,T�F˜=Ò)Ø—_‘_Ó&×/Ñ/°"Ò4Ø,\�F˜=Ò)Øœw }Ó5Ò5Ø,G�F˜=Ñ)ñ ˜L´Ñ=Ø%CˆF�>Ñ"ð œÑ Ø7ˆF�8ÒØÐEÑEÉnØ'EˆFÐ#Ñ$ñ ¤	× 3Ñ 3°LÔ AØ%IˆF�>Ñ"Ù¡
Ø#QˆF�<Ñ ð ¨Ø$2À*ñNˆä#ŸM™MžO‰LˆE�5Ü�6˜%‘=Ó! EÓ)¨e¸6Ò.AØ"*¨5¨'Ð1EÐ F��u’ð ,ñ Ü¨7¸fÑ EÈcÔRÐRä-¨gÓ6Ñˆ
�Hä×ÑÕ!Ü×#Ñ#×*Ñ*Ø#Ø+ØØØØ#Ø"Ø)Ò1¨TØØ-ØØ%Ø!Ø%Ø)ØØð# +ó ˆD÷ "ô* ØØ1Ø—w‘wñ
ó ð 	øôe $ò EØ(D��}Ô%ðEûô> $ò EØ(D��}Ô%ðEú÷< "Ð!ûô6 ò Ü×ÑÐ3Ô4ÜØØHñ
ð ôò 	ðús‡   ‚HQ
 È!P È6A!Q
 ÊA"P) Ë:A?Q
 Í:Q
 Í?Q
 Î"Q
 Î>5P>Ï3 Q
 ÐP&Ð"Q
 Ð%P&Ð&Q
 Ð)P;Ð7Q
 Ð:P;Ð;Q
 Ð>QÑQ
 Ñ
.Q;Ñ:Q;c                 ó   — t        | d«      S )Nzadminpanel/loan_request.html)r   ©r&   s    r   Úloan_requestrj   Ã   s   € Ü�'Ð9Ó:Ð:r(   r*   r   r@   r/   r<   )r*   ÚcustomerÚstaffÚloanr<   c                 ó~   — |j                  «       }| D ��cg c]  \  }}||j                  «       v sŒ|‘Œ c}}S c c}}w )zeChoice keys whose label contains the search term (so 'active' / 'daily' / 'personal' are searchable).)Úlower)ÚchoicesÚtermÚkeyÚlabels       r   Ú_label_keysrt   Ò   s6   € à�:‰:‹<€DÙ")ÔC¡'‘J�C˜¨T°U·[±[³]Ò-BŠC 'ÒCÐCùÓCs   –9±9c                 óx  — | j                   j                  d«      dk7  rt        dddœd¬«      S 	 | j                  }	 t	        |j                  dd	«      «      }t        t	        |j                  d
d«      «      d«      }t	        |j                  dd«      «      }|d	k  s|dkD  rdn|}t        j                  j                  «       }|j                  «       }|j                  dd«      j                  «       }|rÆt        |¬«      t        |¬«      z  t        |¬«      z  t        |¬«      z  t        |¬«      z  }|t        t        t        j                  |«      ¬«      z  }|t        t        t        j                  |«      ¬«      z  }|t        t        t        j                   |«      ¬«      z  }|j#                  |«      }|j                  «       }	dg}
	 t	        |j                  dd«      «      }t$        j                  |j                  d|› d�d«      «      }|r|j                  d«      dk(  rd nd}||z   dg}
 |j&                  |
Ž }g }||||z    D ]ò  }|j)                  |j*                  |j,                  r|j,                  j/                  d!«      nd|j0                  |j2                  |j4                  xs d|j6                  xs d|j8                  xs d|j:                  �t=        |j:                  «      nd |j>                  r|jA                  «       nd|jC                  «       |jE                  «       |jF                  d"œ«       Œô t        |||	|d#œ«      S # t        $ r t        dddœd¬«      cY S w xY w# t        $ r d }Y �Œlw xY w# tH        $ r, tJ        jM                  d$«       t        dddg dd%d&œd'¬«      cY S w xY w)(Nzx-requested-withÚXMLHttpRequestr;   zInvalid request.rE   é�  r>   Údrawé   Ústartr   Úlengthé
   éd   zsearch[value]r   )Úname__icontains)Úphone__icontains)Úplace__icontains)Ústaff_name__icontains)Ústaff_id__icontains)Úloan_type__in)Úpayment_type__in)Ú
status__inz-idzorder[0][column]éÿÿÿÿzcolumns[z][name]zorder[0][dir]ÚdescÚ-z%d-%m-%Y)r[   Úrequest_dateÚcustomer_nameÚmobile_numberr   r@   rA   r/   r0   r.   r<   Ú
status_key)rx   ÚrecordsTotalÚrecordsFilteredÚdataz"Error while fetching loan requestszUnable to load loan requests.)rx   r�   rŽ   r�   r<   rC   rF   )'ÚheadersrH   r   ÚGETÚintÚmaxr   r   rY   ÚallÚcountrI   r   rt   ÚLOAN_TYPE_CHOICESÚPAYMENT_TYPE_CHOICESÚSTATUS_CHOICESÚfilterÚ	ORDERABLEÚorder_byÚappendr[   r*   Ústrftimer   r-   r   r@   rA   r/   Úfloatr0   Úget_payment_type_displayÚget_loan_type_displayÚget_status_displayr<   r\   r]   r^   )r&   rH   rx   rz   r{   ÚqsÚtotalÚsearchÚqÚfilteredr›   Úcol_idxrd   Úprefixr�   rf   s                   r   Úget_loan_requestsr©   Ø   sz  € à‡�×ÑÐ-Ó.Ð2BÒBÜ wÐ;MÑNÐWZÔ[Ð[ðDØ�k‰kˆð	`Ü�s—w‘w˜v qÓ)Ó*ˆDÜœ˜CŸG™G G¨QÓ/Ó0°!Ó4ˆEÜ˜Ÿ™ ¨2Ó.Ó/ˆFð  š
 f¨s¢l‘¸ˆä×Ñ×!Ñ!Ó#ˆØ—‘“
ˆð —‘˜¨"Ó-×3Ñ3Ó5ˆÙÜ 6Ô*¬QÀÔ-GÑGÜ FÔ+ñ,Ü./ÀfÔ.MñNä vÔ.ñ/ˆAð ”¤¬X×-GÑ-GÈÓ!PÔQÑQˆAØ”¤K´×0MÑ0MÈvÓ$VÔWÑWˆAØ”œk¬(×*AÑ*AÀ6ÓJÔKÑKˆAØ—‘˜1“ˆBØ—8‘8“:ˆð �7ˆð	Ü˜#Ÿ'™'Ð"4°bÓ9Ó:ˆGÜ—M‘M #§'¡'¨H°W°I¸WÐ*EÀrÓ"JÓKˆEñ ØŸG™G OÓ4¸Ò>‘SÀBˆFØ ™¨Ð.ˆHØˆR�[‰[˜(Ð#ˆàˆØ�u˜U V™^Ó,ˆDØ�K‰KØ—g‘gØGKÇ~Â~ §¡× 7Ñ 7¸
Ô CÐ[]Ø!%§¡Ø!%§¡ØŸ™Ò) rØ"Ÿo™oÒ3°Ø ŸM™MÒ/¨Rà:>×:JÑ:JÐ:Vœu T×%5Ñ%5Ô6Ð\`ØCG×CTÒCT × =Ñ =Ô ?ÐZ\Ø!×7Ñ7Ó9Ø×1Ñ1Ó3Ø"Ÿk™kñõ ð -ô" ØØ!Ø'Øñ	
ó ð 	øôc ò 	`Ü¨7Ð?QÑ RÐ[^Ô_Ò_ð	`ûô0 ò 	Ø‹Eð	ûô@ ò Ü×ÑÐ=Ô>ÜØ q¸QÈØØ6ñ
ð ô	ò 	ðús\   °N ½AM ÂD7N ÇAM2 ÈD>N ÍM/Í,N Í.M/Í/N Í2NÍ=N Î NÎN Î2N9Î8N9c                 ó´  — | j                   j                  dd«      j                  «       }t        j	                  |«      st        dddœd¬«      S 	 t        j                  «       5  t        j                  j                  «       j                  t        |«      ¬«      }|j                  d	k(  rt        dd
dœd¬«      cd d d «       S d	|_        |j                  ddg¬«       d d d «       t        dddœ«      S # 1 sw Y   ŒxY w# t        j                  $ r t        dddœd¬«      cY S t        $ r( t         j#                  d«       t        dddœd¬«      cY S w xY w)Nr[   r   r;   zInvalid lead.rE   rw   r>   ©r%   Ú	confirmedzThis lead is already confirmed.i™  r<   Ú
updated_at)Úupdate_fieldsrB   zLead confirmed successfully.úLead not found.i”  zError while confirming leadz/Something went wrong while confirming the lead.rF   )rG   rH   rI   ÚID_RErN   r   r   rX   r   rY   Úselect_for_updater’   r<   ÚsaveÚDoesNotExistr\   r]   r^   ©r&   rD   rf   s      r   Úconfirm_leadrµ   %  s?  € à�l‰l×Ñ˜t RÓ(×.Ñ.Ó0€GÜ�?‰?˜7Ô#Ü w¸?ÑKÐTWÔXÐXðÜ×ÑÕ!ä×#Ñ#×5Ñ5Ó7×;Ñ;¼sÀ7»|Ð;ÓLˆDà�{‰{˜kÒ)Ü#Ø%Ø@ñ%ð ô÷ "Ñ!ð &ˆDŒKØ�I‰I X¨|Ð$<ˆIÔ=÷ "ô  yÐ=[Ñ\Ó]Ð]÷ "Ð!ûô × Ñ ò [Ü wÐ;LÑMÐVYÔZÒZÜò Ü×ÑÐ6Ô7ÜØØHñ
ð ôò 	ðús=   ÁD Á%AC6Â;	D ÃC6Ã D Ã6C?Ã;D Ä#EÄ'-EÅEc                 óÖ   — 	 t         j                  j                  |¬«      }t        | dd|i«      S # t         j                  $ r$ t	        j
                  | d«       t        d«      cY S w xY w)Nr«   r¯   zadmin:loan_requestz!adminpanel/view_loan_request.htmlrf   )r   rY   rH   r³   r	   r;   r
   r   r´   s      r   Úview_loan_requestr·   F  sh   € ð.Ü×Ñ×#Ñ# wÐ#Ó/ˆô �'Ð>ÀÈÀÓOÐOøô × Ñ ò .Ü�‰�wÐ 1Ô2ÜÐ,Ó-Ò-ð.ús   ‚ 1 ±4A(Á'A(c                 óv   — t        dt        j                  j                  d¬«      j	                  «       dœ«      S )NrB   r?   r>   )r<   r•   )r   r   rY   r™   r•   ri   s    r   Úloan_request_countr¹   P  s7   € äØÜ×!Ñ!×(Ñ(°Ð(Ó9×?Ñ?ÓAñó ð r(   )1ÚloggingÚrer   Údecimalr   r   Ú	django.dbr   Údjango.db.modelsr   Údjango.httpr   Údjango.contribr	   Údjango.shortcutsr
   r   Údjango.views.decorators.httpr   r   ÚNexusApp.modelsr   Ú	getLoggerÚ__name__r]   ÚcompilerO   rM   Údictr–   rP   ÚSOURCE_CHOICESrU   r˜   ÚSTATUSESr—   rT   r°   rV   r   r'   rg   rj   rš   rt   r©   rµ   r·   r¹   © r(   r   Ú<module>rË      sK  ðÛ Û 	å ß -å !Ý Ý $Ý #ß -ß Bå $à	ˆ×	Ñ	˜8Ó	$€ð ˆB�J‰JÐ'Ó(€	Ø
ˆ"�*‰*Ð-Ó
.€á�(×,Ñ,Ó-€
Ù
ˆx×&Ñ&Ó
'€Ù�×'Ñ'Ó(€Ù�X×2Ñ2Ó3€àˆ�
‰
�9Ó€ð ØØØñ	€òò	ð ñEó ðEòR;ð ØØØØñ€	òDð ñHó ðHðX ñó ðò@Pð ñó ñr(   