Ë
    É”ýj.  ã                   ó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
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mZ d dlmZ d dlmZ d dlmZmZ d„ Zd„ Zd„ Zd„ Zd„ Z d„ Z!d„ Z"d„ Z#d„ Z$d„ Z%d„ Z&d„ Z'd„ Z(d„ Z)d„ Z*d„ Z+d„ Z,d„ Z-d „ Z.d!„ Z/d"„ Z0d#„ Z1d$„ Z2d%„ Z3d&„ Z4d'„ Z5d(„ Z6y))*é    ©Úrender)Úreverse)ÚPlace)ÚLoanÚCustomer)ÚSumÚValueÚDecimalField)ÚCoalesce)ÚLoanPayment)ÚDecimal)ÚAttendanceMaster)Úget_object_or_404Úredirectr   )Útimezone)ÚStaffCheckIn)Úget_staff_loan_or_404Úget_staff_place_or_404c                 ó   — t        | d«      S )Nzstaffpanel/login.htmlr   ©Úrequests    ú>/var/www/html/nexus_chitfund_web/NexusApp/views/staff_views.pyÚloginr      s   € Ü�'Ð2Ó3Ð3ó    c                 ó   — t        | d«      S )Nzstaffpanel/forgot_password.htmlr   r   s    r   Úforgot_passwordr      ó   € Ü�'Ð<Ó=Ð=r   c                 ó   — t        | d«      S )Nzstaffpanel/new_password.htmlr   r   s    r   Únew_passwordr       ó   € Ü�'Ð9Ó:Ð:r   c                 ó   — t        | d«      S )Nzstaffpanel/reset_password.htmlr   r   s    r   Úreset_passwordr#      ó   € Ü�'Ð;Ó<Ð<r   c                 óÐ  — ddl m}m} ddlm}m}m} t        j                  «       }| j                  }t        dd¬«      }t        j                  j                  ||¬«      j                  «       }	|	d u}
t        j                  j                  d¬	«      j                  «       } | || «      |«      } || «      j!                  «       } || «      j                  d
 || «      ¬«      j#                  «       j!                  «       }t$        j                  j                  |¬«      }t'        t)        d«      «      }|j+                  t-        t/        d«      ||¬«      ¬«      d   }|j                  |¬«      }|j+                  t-        t/        d«      ||¬«      ¬«      d   }|j                  |j0                  |j2                  ¬«      j+                  t-        t/        d«      ||¬«      ¬«      d   }|j5                  d«      j#                  «       j!                  «       }||d   z   |d   z   }|rt7        t9        |dz  |z  «      «      nd}|j;                  d«      j=                  dd«      d d D �cg c]�  }|j>                  |j@                  |jB                  jD                  jF                  tI        |jJ                  «      |jL                  jO                  d«      tQ        d«      › d|j@                  › �dœ‘Œƒ }}i d |“d!|“d"tS        ||z
  d«      “d# || «      j                  |j0                  |j2                  ¬$«      j!                  «       “d%|d%   “d&|d&   “d' ||«      “d( ||«      “d) ||«      “d*|“d+|d+   |d   z   “d,|d,   “d- ||d-   «      “d.tU        |d«      “d/tU        |d/   d«      “d0|“d1tW         || «      jY                  d2d¬3«      «      “||
|	d4œ¥}t[        | d5|«      S c c}w )6Nr   )ÚinrÚportfolio_summary)Ústaff_customersÚstaff_loansÚstaff_placesé   é   )Ú
max_digitsÚdecimal_places)ÚstaffÚcheck_in_dateT©Ú	is_activeÚactive)Úloans__statusÚloans__place__in)Úcollected_byz0.00Úamount)Úoutput_field)Útr9   )Úpayment_date)Úpayment_date__yearÚpayment_date__monthÚloan_idÚ	due_todayÚoverdue_loanséd   Úloan__customerz-payment_dateú-idé   z%d-%m-%Yústaff:paid_due_historyú?id=)Úidr=   Úcustomer_namer7   ÚdateÚurlÚtotal_customersÚactive_customersÚinactive_customersÚnew_loans_month)Úloan_date__yearÚloan_date__monthÚactive_loansÚcompleted_loansÚmy_collectionÚtoday_collectionÚmonth_collectionÚdues_collected_todayÚupcoming_duesÚoverdue_customersÚoverdue_amountÚcollection_progressÚrecovery_rateÚrecent_collectionsÚassigned_placesÚname©Úflat)Úactive_attendance_masterÚalready_checked_inÚtoday_checkinzstaffpanel/dashboard.html).ÚNexusApp.utils.loan_statsr&   r'   ÚNexusApp.utils.staff_scoper(   r)   r*   r   Ú	localdater/   r   r   ÚobjectsÚfilterÚfirstr   ÚcountÚdistinctr   r
   r   Ú	aggregater   r	   ÚyearÚmonthÚvaluesÚintÚroundÚselect_relatedÚorder_byrF   r=   ÚloanÚcustomerrG   Úfloatr7   r:   Ústrftimer   ÚmaxÚminÚlistÚvalues_listr   )r   r&   r'   r(   r)   r*   Útodayr/   Úmoneyrb   ra   r`   ÚsummaryrJ   rK   Úmy_paymentsÚzeroÚtotal_collectionÚtoday_paymentsrS   rT   rU   Úprogress_baserY   ÚpÚrecentÚcontexts                              r   Ú	dashboardr†      sW  € ß@ßUÑUô ×ÑÓ €EØ�M‰M€EÜ B°qÔ9€Eä ×(Ñ(×/Ñ/°eÈ5Ð/ÓQ×WÑWÓY€MØ&¨dÐ2Ðä/×7Ñ7×>Ñ>ÈÐ>ÓN×TÑTÓVÐá¡¨GÓ 4°eÓ<€GÙ% gÓ.×4Ñ4Ó6€OÙ& wÓ/×6Ñ6Ø±¸gÓ1Fð 7ó HßHPÉË
×SXÑSXÓSZð ô ×%Ñ%×,Ñ,¸%Ð,Ó@€KÜ”˜“Ó!€DØ"×,Ñ,Ü
”3�x“= $°UÔ
;ð -ó =Ø=@ñBÐà ×'Ñ'°UÐ'Ó;€NØ%×/Ñ/Ü
”3�x“= $°UÔ
;ð 0ó =Ø=@ñBÐà"×)Ñ)Ø Ÿ:™:¸5¿;¹;ð *ó ç�i”(œ3˜x›=¨$¸UÔC€iÓDÀSñJÐð
 *×0Ñ0°Ó;×DÑDÓF×LÑLÓNÐØ(¨7°;Ñ+?Ñ?À'È/ÑBZÑZ€MÙTaœ#œeÐ$8¸3Ñ$>ÀÑ$NÓOÔPÐghÐð ×+Ñ+Ð,<Ó=×FÑFÀÐX]Ó^Ð_bÐ`bÑcó
ñ dˆAð —$‘$Ø—y‘yØŸV™VŸ_™_×:Ñ:Ü˜AŸH™H“oØ—N‘N×+Ñ+¨JÓ7ÜÐ6Ó7Ð8¸¸Q¿Y¹Y¸KÐHó	
ð dð ð 
ðØ˜?ðàÐ,ðð 	œc /Ð4DÑ"DÀaÓHðð 	™; wÓ/×6Ñ6Ø!ŸJ™J¸¿¹ð 7ó FßFKÁeÃgðð 	˜ Ñ/ðð 	˜7Ð#4Ñ5ðð 	™Ð-Ó.ðð 	™CÐ 0Ó1ðð 	™CÐ 0Ó1ðð 	Ð 4ðð 	˜ Ñ1°G¸KÑ4HÑHðð 	˜WÐ%8Ñ9ðð 	™#˜gÐ&6Ñ7Ó8ðð 	œsÐ#6¸Ó<ðð  	œ˜W _Ñ5°sÓ;ð!ð" 	˜fð#ð$ 	œ4¡¨WÓ 5× AÑ AÀ&ÈtÐ AÓ TÓUð%ð& %=Ø0Ø&ò+€Gô0 �'Ð6¸Ó@Ð@ùòI
s   É)BO#c                 ó   — t        | d«      S )Nz#staffpanel/customer_management.htmlr   r   s    r   Úcustomer_managementrˆ   k   s   € Ü�'Ð@ÓAÐAr   c                 ó¾   — | j                   j                  dd«      j                  «       }|j                  «       rt	        t        d«      › d|› �«      S t	        d«      S )NrF   Ú rD   rE   ústaff:customer_management)ÚGETÚgetÚstripÚisdigitr   r   ©r   r=   s     r   Úpayment_historyr‘   n   sR   € Ø�k‰k�o‰o˜d BÓ'×-Ñ-Ó/€GØ‡�ÔÜœ7Ð#;Ó<Ð=¸TÀ'ÀÐKÓLÐLÜÐ/Ó0Ð0r   c                 ó   — t        | d«      S )Nzstaffpanel/edit_customer.htmlr   r   s    r   Úedit_customerr“   t   s   € Ü�'Ð:Ó;Ð;r   c                 ó,  — ddl m}m} t        | dt	         || «      j                  dd¬«      «      t	         || «      j                  d¬«      j                  d¬	«      j                  d
«      j                  d
d¬«      j                  «       «      dœ«      S )Nr   )r(   r*   zstaffpanel/add_loan.htmlr]   Tr^   )Úreferral_name__isnullrŠ   )Úreferral_namer–   )ÚplacesÚreferral_names)	rd   r(   r*   r   ry   rz   Úexcluderr   rj   )r   r(   r*   s      r   Úadd_loanrš   |   sƒ   € ßHÜ�'Ð5Ü‘| GÓ,×8Ñ8¸ÀdÐ8ÓKÓLÜÙ˜GÓ$×,Ñ,À4Ð,ÓH×PÑPÐ_aÐPÓbß‰X�oÓ&§{¡{°?È {Ó'NÏxÉxËzó
ñ8ó ð r   c                 ó   — t        d«      S )Nústaff:loan_registers)r   r   s    r   Úloan_managementr�   †   s   € äÐ*Ó+Ð+r   c                 ó   — t        | d«      S )Nzstaffpanel/loan_registers.htmlr   r   s    r   Úloan_registersrŸ   Š   r$   r   c                 ó   — t        | d«      S )Nzstaffpanel/loan_entries.htmlr   r   s    r   Úloan_entriesr¡   Ž   r!   r   c                 óL   — t        | |«      }t        | dd|j                  i«      S )Nzstaffpanel/loan_reports.htmlÚ
place_name)r   r   r]   ©r   Úplace_idÚplaces      r   Úloan_reportsr§   ’   s.   € Ü" 7¨HÓ5€EÜ�'Ð9Ø�e—j‘jð<ó ð r   c                 ó   — t        | d«      S )Nz staffpanel/paid_due_history.htmlr   r   s    r   Úpaid_due_historyr©   ˜   s   € Ü�'Ð=Ó>Ð>r   c                 ó   — t        | d«      S )Nzstaffpanel/completed_loan.htmlr   r   s    r   Úcompleted_loanr«   ›   r$   r   c                 ó¸  — ddl m} | j                  j                  dd«      j	                  «       }|j                  «       rE || t        j                  j                  dd«      «      j                  |¬«      j                  «       nd}|€t        d	«      S |j                  } || |j                  j                  d«      «      j                  d
«      }|j                  j                   |_        |j"                  xs d}t%        | d|||j'                  «       t)        |«      dk(  rd|dd z   nd|j*                  r|j*                  j,                  dœ«      S ddœ«      S )z>?id=<latest loan id of the customer> (from the customer list).r   )r)   rF   rŠ   rt   r¦   )ÚpkNr‹   rB   z%staffpanel/view_customer_details.htmlé   z
XXXX XXXX éüÿÿÿÚ-)rt   ÚloansÚtotal_loansÚmasked_aadhaarÚaadhaar_photo_url)rd   r)   rŒ   r�   rŽ   r�   r   rf   rq   rg   rh   r   rt   r±   rr   r¦   r]   Úaadhaar_numberr   ri   ÚlenÚaadhaar_photorI   )r   r)   r=   Úselectedrt   r±   Úaadhaars          r   Úview_customer_detailsrº   ž   s8  € å6Ø�k‰k�o‰o˜d BÓ'×-Ñ-Ó/€Gà'.§¡Ô'8ñ ˜7¤D§L¡L×$?Ñ$?À
ÈGÓ$TÓUß	‰�7ˆÓ	ŸE™EœG¸dð àÐÜÐ3Ó4Ð4à× Ñ €HÙ˜ §¡×!>Ñ!>¸wÓ!GÓH×QÑQÐRWÓX€EØ—^‘^×(Ñ(€H„NØ×%Ñ%Ò+¨€GÜ�'ÐBØØØ—{‘{“}Ü;>¸w»<È2Ò;M˜<¨'°"°#¨,Ò6ÐSVØ;C×;QÒ;Q˜X×3Ñ3×7Ñ7ñEó ð ð
 XZñEó ð r   c                 ó¸   — | j                   j                  dd«      j                  «       }|j                  «       rt	        dt        |«      ¬«      S t	        d«      S ©NrF   rŠ   zstaff:view_place_loan)r=   rœ   ©rŒ   r�   rŽ   r�   r   ro   r�   s     r   Úview_loan_entryr¾   ´   óG   € à�k‰k�o‰o˜d BÓ'×-Ñ-Ó/€GØ‡�ÔÜÐ/¼¸W»ÔFÐFÜÐ*Ó+Ð+r   c                 ó¸   — | j                   j                  dd«      j                  «       }|j                  «       rt	        dt        |«      ¬«      S t	        d«      S r¼   r½   r�   s     r   Úview_completed_loanrÁ   »   r¿   r   c                 ób   — t        | |«      }t        | d|j                  |j                  dœ«      S )Nz$staffpanel/place_completed_loan.html)r¦   r¥   )r   r   r]   rF   r¤   s      r   Úplace_completed_loanrÃ   Â   s0   € Ü" 7¨HÓ5€EÜ�'ÐAØ!ŸJ™J°E·H±HÑ=ó?ð ?r   c           	      ó˜  — t        | |t        j                  j                  dd«      «      }t	        |j
                  j                  «       d¬«      D ��cg c]E  \  }}||j                  j                  «       t        |j                  «      |j                  «       dœ‘ŒG }}}t        | d||j                  j                  |dœ«      S c c}}w )Nr¦   rt   é   ©Ústart)Úsnor:   r7   Úpayment_methodzstaffpanel/view_place_loan.html)rs   r£   Úpayments)r   r   rf   rq   Ú	enumeraterÊ   Úallr:   Ú	isoformatru   r7   Úget_payment_method_displayr   r¦   r]   )r   r=   rs   Úirƒ   rÊ   s         r   Úview_place_loanrÐ   Ç   s»   € Ü  ¨'´4·<±<×3NÑ3NÈwÐXbÓ3cÓd€Dô ˜dŸm™m×/Ñ/Ó1¸Õ;ôñ <‰DˆAˆqð ØŸN™N×4Ñ4Ó6Ü˜AŸH™H“oØ×:Ñ:Ó<ó		
ð <ð ñ ô �'Ð<ØØ—j‘j—o‘oØñ?ó ð ùós   ÁA
Cc                 ó   — t        | d«      S )Nzstaffpanel/overdue_loan.htmlr   r   s    r   Úoverdue_loanrÒ   Ø   r!   r   c                 ó   — t        | d«      S )Nz!staffpanel/view_overdue_loan.htmlr   r   s    r   Úview_overdue_loanrÔ   Û   ó   € Ü�'Ð>Ó?Ð?r   c                 ó¸   — | j                   j                  dd«      j                  «       }|j                  «       rt	        dt        |«      ¬«      S t	        d«      S r¼   r½   r�   s     r   Úview_loan_reportr×   Þ   r¿   r   c                 ó   — t        | d«      S )Nzstaffpanel/edit_loan.htmlr   r   s    r   Ú	edit_loanrÙ   å   s   € Ü�'Ð6Ó7Ð7r   c                 ó   — t        | d«      S )Nz!staffpanel/today_collections.htmlr   r   s    r   Útoday_collectionsrÛ   è   rÕ   r   c                 ó   — t        | d«      S )Nzstaffpanel/collection_list.htmlr   r   s    r   Úcollection_listrÝ   ë   r   r   c                 ó0  ‡— ddl m} t        j                  «       Š‰j	                  d¬«      }t
        j                  j                  d¬«      j                  «       }t        |r|j                  ndxs g d¢«      }dd	lm} t        t        j                  j                  | j                  ¬
«      j!                  d«      «      }|D �cg c]  }|j"                  |k\  sŒ|‘Œ }}t%        |«      }	t'        d„ |D «       «      }
d}|}|‰k  r*|j)                  d«      |v r|dz  }| |d¬«      z  }|‰k  rŒ*t+        |d¬«      D ��cg c]ë  \  }}||j"                  j-                  «       t        j.                  |j0                  «      j)                  d«      |j2                  r.t        j.                  |j2                  «      j)                  d«      nd|j2                  r|j4                  n|j"                  ‰k  rdnddœ ||«      ¥|j6                  |j8                  xs d|j:                  dk(  rdnddœ¥‘Œí }}}t=        | d|	t?        ||	z
  d«      |
|	|
z
  |	rtA        tC        |	|
z
  dz  |	z  «      «      nd|tE        ˆfd„|D «       d«      |dœ«      S c c}w c c}}w )zDMy Attendance: this month's check-ins of the logged-in staff member.r   )Ú	timedeltarÅ   )ÚdayTr1   N)ÚMondayÚTuesdayÚ	WednesdayÚThursdayÚFridayÚSaturday)Úcheckin_locations)r/   z-check_in_datec              3   ó@   K  — | ]  }|j                   d k(  sŒd–— Œ y­w)ÚlaterÅ   N)Ústatus)Ú.0Úcs     r   Ú	<genexpr>zattendence.<locals>.<genexpr>þ   s   è ø€ Ð6™%�Q 1§8¡8¨vÓ#5Œq™%ùs   ‚—z%A)ÚdaysrÆ   z%I:%M %pr°   zNot checked outÚWorking)rF   rH   Úcheck_inÚ	check_outÚworking_hoursré   ÚLateÚPresent)Úlate_minutesÚreasonrê   zstaffpanel/attendence.htmlr@   c              3   óB   •K  — | ]  }|j                   ‰k(  sŒ|–— Œ y ­w)N)r0   )rë   rì   r{   s     €r   rí   zattendence.<locals>.<genexpr>  s   øè ø€ ÐO©( Q°a·o±oÈÓ6Nœq©(ùs   ƒ˜)Úpresent_daysÚabsent_daysÚ	late_daysÚon_time_daysÚon_time_rateÚattendance_rowsrb   r`   )#Údatetimerß   r   re   Úreplacer   rf   rg   rh   ÚsetÚworking_daysÚ+controllers.Admin.AdminattendanceControllerrç   ry   r   r/   rr   r0   r¶   Úsumrv   rË   rÍ   Ú	localtimeÚcheck_in_timeÚcheck_out_timeÚworking_hours_labelrõ   Úlate_reasonrê   r   rw   ro   rp   Únext)r   rß   Úmonth_startÚmasterr  rç   Úcheckinsrì   rm   Úpresentré   ÚexpectedÚdrÏ   Úrowsr{   s                  @r   Ú
attendencer  ñ   st  ø€ å"Ü×ÑÓ €EØ—-‘- A�-Ó&€KÜ×%Ñ%×,Ñ,°tÐ,Ó<×BÑBÓD€FÜ©v˜×+Ò+¸4ò \Ú[ó]€Lõ NÜ”L×(Ñ(×/Ñ/°g·m±mÐ/ÓD×MÑMÐN^Ó_Ó`€HÙ ÓC™�1 A§O¡O°{Ó$BŠQ˜€EÐCÜ�%‹j€GÜÑ6™%Ó6Ó6€Dà€HØ€AØ
ˆuŠ*Ø�:‰:�dÓ˜|Ñ+Ø˜‰MˆHØ	‰Y˜AÔÑˆð ˆu‹*ô  ˜H¨AÕ.ô0ñ /‰$ˆ!ˆQð Ø—‘×)Ñ)Ó+Ü×&Ñ& q§¡Ó7×@Ñ@ÀÓLØRS×RbÒRb”X×'Ñ'¨×(8Ñ(8Ó9×BÑBÀ:ÔNÐhkØ23×2BÒ2B˜×.Ò.Ø/0¯©ÀÒ/FÑ+ÈIññ ˜AÓ
ðð Ÿ™Ø—-‘-Ò& 3ØŸH™H¨Ò.‘&°Iôð /ð 	ñ 0ô �'Ð7ØÜ˜8 gÑ-¨qÓ1ØØ $™ÙHOœœE 7¨T¡>°SÑ"8¸7Ñ"BÓCÔDÐUVØÜÓO©(ÓOÐQUÓVØ$*ñ	:ó 	ð 	ùò1 Dùó0s   ÃJÃJÅC0JN)7Údjango.shortcutsr   Údjango.urlsr   ÚNexusApp.modelsr   r   r   Údjango.db.modelsr	   r
   r   Údjango.db.models.functionsr   r   Údecimalr   Ú NexusApp.models.attendance_modelr   r   r   Údjango.utilsr   ÚNexusApp.models.checkin_modelr   rd   r   r   r   r   r    r#   r†   rˆ   r‘   r“   rš   r�   rŸ   r¡   r§   r©   r«   rº   r¾   rÁ   rÃ   rÐ   rÒ   rÔ   r×   rÙ   rÛ   rÝ   r  © r   r   Ú<module>r     s¿   ðÝ #Ý Ý !ß *ß 5Ñ 5Ý /Ý 'Ý Ý =ß @Ñ @Ý !Ý 6ß Tò4ò>ò;ò=òHAòZBò1ò<òò,ò=ò;òò?ò=òò,,ò,ò?ò
ò";ò@ò,ò8ò@ò>ó,r   