Ë
    Æ k§  ã                   óð   — d dl Z d dl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 dlmZ d dlmZmZmZ  ej$                  e«      Zg 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#y)é    N)ÚdateÚdatetimeÚ	timedelta)ÚJsonResponse)Útimezone)ÚStaffÚStaffCheckIn)ÚAttendanceMaster)Ú
date_rangeÚrange_labelÚxlsx_response)ÚMondayÚTuesdayÚ	WednesdayÚThursdayÚFridayÚSaturdayÚSundayc                 ó’   — 	 t        j                  | xs dj                  «       d«      j                  «       S # t        $ r |cY S w xY w)NÚ z%Y-%m-%d)r   ÚstrptimeÚstripr   Ú
ValueError)ÚvalueÚdefaults     úO/var/www/html/nexus_chitfund_web/controllers/Admin/AdminattendanceController.pyÚ_parse_dater      sD   € ðÜ× Ñ  %¢+¨2×!4Ñ!4Ó!6¸
ÓC×HÑHÓJÐJøÜò ØŠðús   ‚58 ¸AÁAc                  óÈ   — t         j                  j                  d¬«      j                  «       } | r!| j                  rt        | j                  «      S t        t        dd «      S )zJWorking weekday names from the active Attendance Master (Mon-Sat if none).T)Ú	is_activeNé   )r
   ÚobjectsÚfilterÚfirstÚworking_daysÚsetÚWEEKDAYS)Úmasters    r   Ú_working_daysr(      sQ   € ä×%Ñ%×,Ñ,°tÐ,Ó<×BÑBÓD€FÙ�&×%Ò%Ü�6×&Ñ&Ó'Ð'ÜŒx˜˜ˆ|ÓÐó    c                 ó4   — t         | j                  «          |v S )N)r&   Úweekday)Údayr$   s     r   Ú_is_working_dayr-   !   s   € Ü�C—K‘K“MÑ" lÐ2Ð2r)   c                  ó`   — t         j                  j                  d¬«      j                  d«      S )NÚActive)Ústatus__iexactÚname)r   r!   r"   Úorder_by© r)   r   Ú_active_staffr4   %   s%   € Ü�=‰=×Ñ¨xÐÓ8×AÑAÀ&ÓIÐIr)   c                 óR   — | r$t        j                  | «      j                  d«      S dS )Nz%I:%M %pÚ-)r   Ú	localtimeÚstrftime)Údts    r   Ú	_fmt_timer:   )   s%   € Ù:<Œ8×Ñ˜bÓ!×*Ñ*¨:Ó6ÐEÀ#ÐEr)   c                 ó$   — | j                  d«      S )Nz%d %b %Y)r8   )Úds    r   Ú	_fmt_dater=   -   s   € Ø�:‰:�jÓ!Ð!r)   c                 ó   — | �
|�d| › d|› �S dS )Nzhttps://www.google.com/maps?q=Ú,r   r3   )ÚlatÚlngs     r   Ú_map_urlrB   1   s$   € Ø;>¸?ÈsÈÐ+¨C¨5°°#°Ð7ÐfÐdfÐfr)   c                 óì   — t        | j                  | j                  «      | j                  | j                  xs dt        | j
                  | j                  «      | j                  | j                  xs ddœS )z@Location fields shared by the admin and staff attendance tables.r   )Úcheck_in_mapÚcheck_in_accuracyÚcheck_in_location_noteÚcheck_out_mapÚcheck_out_accuracyÚcheck_out_location_note)	rB   Úcheck_in_latitudeÚcheck_in_longituderE   rF   Úcheck_out_latitudeÚcheck_out_longituderH   rI   )Úcs    r   Úcheckin_locationsrO   5   sh   € ô ! ×!4Ñ!4°a×6JÑ6JÓKØ×0Ñ0Ø"#×":Ñ":Ò"@¸bÜ! !×"6Ñ"6¸×8MÑ8MÓNØ×2Ñ2Ø#$×#<Ñ#<Ò#BÀñð r)   c                 ó   — | j                   dk(  }| j                  j                  | j                  j                  | j                  j                  «       t        | j                  «      t        | j                  «      t        | j                  «      | j                  r| j                  n$| j                  t        j                  «       k  rdnd|rdnd|r| j                  nd|r| j                  xs dnddœ
t        | «      ¥S )	NÚlatezNot checked outÚWorkingÚLateÚPresentr   r   ©
Ú
staff_nameÚemployee_idr   Ú
date_labelÚcheck_inÚ	check_outÚworking_hoursÚstatusÚlate_minutesÚlate_reason)r\   Ústaffr1   rW   Úcheck_in_dateÚ	isoformatr=   r:   Úcheck_in_timeÚcheck_out_timeÚworking_hours_labelr   Ú	localdater]   r^   rO   )rN   rQ   s     r   Ú_checkin_rowrf   A   sÅ   € Ø�8‰8�vÑ€Dà—g‘g—l‘lØ—w‘w×*Ñ*Ø—‘×)Ñ)Ó+Ü §¡Ó0Ü˜aŸo™oÓ.Ü˜q×/Ñ/Ó0Ø23×2BÒ2B˜×.Ò.Ø/0¯©Ä×ASÑASÓAUÒ/UÑ+Ð[dÙ ‘& iÙ*.˜Ÿš°AÙ04˜Ÿ™Ò+©¸"ñô ˜AÓ
ðð r)   c                 ór   — | j                   | j                  |j                  «       t        |«      dddddddœ
S )Nr6   ÚAbsentr   r   rU   )r1   rW   ra   r=   )r_   r,   s     r   Ú_absent_rowri   S   s>   € à—j‘jØ×(Ñ(Ø—‘“Ü “nØØØØØØñð r)   c                 óX  — t        j                  «       }t        «       }|j                  «       }t        j
                  j                  ||¬«      }|j                  «       }|j                  d¬«      j                  «       }t        |t        «       «      rt        ||z
  d«      nd}||||dœS )z0Cards at the top of the page - always for TODAY.)r`   Ú	staff__inrQ   )r\   r   )Útotal_staffÚpresentÚabsentrQ   )
r   re   r4   Úcountr	   r!   r"   r-   r(   Úmax)ÚrequestÚtodayÚstaff_qsÚtotalÚcheckinsrm   rQ   rn   s           r   Úadmin_attendance_summaryrv   b   s¦   € ä×ÑÓ €EÜ‹€HØ�N‰NÓ€Eä×#Ñ#×*Ñ*Ø xð +ó €Hð �n‰nÓ€GØ�?‰? &ˆ?Ó)×/Ñ/Ó1€Dô ˜5¤-£/Ô2ô 	ˆE�G‰O˜QÔØ89ð ð !¨WØ dñ,ð ,r)   c                 óø  — t        j                  «       }| j                  j                  dd«      }|dvrd}t	        | j                  j                  d«      |«      }| j                  j                  dd«      j                  «       }| j                  j                  dd«      j                  «       j                  «       }t        | «      \  }}|s|rd}t        t        «       «      }t        j                  j                  d	«      }	|dk(  r|x}
}n‚|d
k(  rP|j                  d¬«      }
|j                  t        j                  |j                   |j"                  «      d   ¬«      }n-|dk(  r$|xs t%        |xs ||«      }|xs |}
|
|kD  r	||
}}
ndx}
}|
r|	j'                  |
|f¬«      }	|	D �cg c]  }t)        |«      ‘Œ }}|
r²t+        «       }|	D �ch c]  }|j,                  |j.                  f’Œ }}t1        ||«      }|
}||k  rpt3        ||«      rO|D ]J  }|j4                  r||j4                  k  rŒ|j6                  |f|vsŒ0|j9                  t;        ||«      «       ŒL |t=        d¬«      z  }||k  rŒp|r|D �cg c]  }|d   |k(  sŒ|‘Œ }}|rA|D �cg c]6  }||d   xs dj                  «       v s||d   xs dj                  «       v r|‘Œ8 }}|j?                  d„ d¬«       ||
|fS c c}w c c}w c c}w c c}w )ak  
    GET ?period=daily|monthly|range|all &date=YYYY-MM-DD &from_date= &to_date=
        &status=Present|Late|Absent &search=<staff name / employee id>
    Present = checked in on time, Late = checked in late,
    Absent = no check-in on a working day.
    A From / To date always wins over the period (it switches to 'range').
    Returns (rows, start, end).
    ÚperiodÚdaily)ry   ÚmonthlyÚrangeÚallr   r\   r   Úsearchr{   r_   rz   é   )r,   N)Úcheck_in_date__range)ÚdaysrV   rW   c                 ó   — | d   | d   fS )Nr   rV   r3   )Úrs    r   Ú<lambda>z"_attendance_rows.<locals>.<lambda>µ   s   € ˜Q˜v™Y¨¨,©Ñ8r)   T)ÚkeyÚreverse) r   re   ÚGETÚgetr   r   Úlowerr   Úlistr4   r	   r!   Úselect_relatedÚreplaceÚcalendarÚ
monthrangeÚyearÚmonthrp   r"   rf   r(   Ústaff_idr`   Úminr-   Újoining_dateÚidÚappendri   r   Úsort)rq   rr   rx   ÚselectedÚstatus_filterr}   Ú
range_fromÚrange_toÚ
staff_listru   ÚstartÚendrN   Úrowsr$   ÚdoneÚlast_dayr,   Úsr‚   s                       r   Ú_attendance_rowsr¡   u   só  € ô ×ÑÓ €EØ�[‰[�_‰_˜X wÓ/€FØÐ9Ñ9ØˆÜ˜7Ÿ;™;Ÿ?™?¨6Ó2°EÓ:€HØ—K‘K—O‘O H¨bÓ1×7Ñ7Ó9€MØ�[‰[�_‰_˜X rÓ*×0Ñ0Ó2×8Ñ8Ó:€FÜ% gÓ.Ñ€J�Ù‘XØˆä”m“oÓ&€JÜ×#Ñ#×2Ñ2°7Ó;€Hà�ÒØÐˆ‘Ø	�9Ò	Ø× Ñ  QÐ Ó'ˆØ×ÑÜ×#Ñ# H§M¡M°8·>±>ÓBÀ1ÑEð ó G‰à	�7Ò	àÒ9œ#˜jÒ1¨E°5Ó9ˆØÒ!˜cˆØ�3Š;Ø˜e�3‰EàÐˆ�áØ—?‘?¸À¸�?ÓEˆÙ%-Ó.¡X ŒL˜�O X€DÐ.ñ Ü$“ˆÙ7?Ó@±x°!�—‘˜QŸ_™_Ò-°xˆÐ@Ü�s˜E“?ˆØˆØ�XŠoÜ˜s LÔ1Û#�AØ—~’~¨#°·±Ò*>Ø ØŸ™˜c�{¨$Ò.ØŸ™¤K°°3Ó$7Õ8ð	 $ð
 ”9 !Ô$Ñ$ˆCð �X‹oñ ÙÓ@™4�a 1 X¡;°-Ó#?’˜4ˆÐ@ÙÙó ?™4�aØ˜a ™oÒ3°×:Ñ:Ó<Ñ<Ø˜a Ñ.Ò4°"×;Ñ;Ó=Ñ=ò ˜4ˆð ?ð 	‡I�IÑ8À$€IÔGØ�˜ÐÐùò3 /ùò
 Aùò Aùò?s   Æ*K(ÇK-É8K2ÊK2Ê;K7c                 óN   — t        | «      \  }}}t        |t        | «      dœ«      S )N)ÚdataÚsummary)r¡   r   rv   )rq   r�   Ú_s      r   Úadmin_attendance_datar¦   ¹   s/   € Ü! 'Ó*�J€Dˆ!ˆQÜØÜ+¨GÓ4ñó ð r)   c                 óJ  — t        | «      \  }}}t        |d¬«      D ��cg c]R  \  }}||d   |d   |d   |d   |d   |d   |d	   |d
   xs d|d   |j                  dd«      |j                  dd«      g‘ŒT }}}t        ddg d¢||rt	        ||«      ¬«      S d¬«      S c c}}w )z:Excel of the attendance rows matching the current filters.r~   )r›   rV   rW   rX   rY   rZ   r[   r\   r]   r   r^   rD   rG   Ústaff_attendancezStaff Attendance)zS.Noz
Staff NamezEmployee IDÚDatezCheck Inz	Check OutzWorking HoursÚStatuszLate MinuteszLate ReasonzCheck In LocationzCheck Out LocationzAll records)Úsubtitle)r¡   Ú	enumerater‡   r   r   )rq   r�   r›   rœ   Úir‚   Úbodys          r   Úadmin_attendance_exportr¯   Á   sç   € ä'¨Ó0Ñ€Dˆ%�ô
 ˜D¨Õ*ô	,ñ +‰$ˆ!ˆQð 	
ˆ1ˆ\‰?˜A˜mÑ,¨a°©o¸qÀ¹}ÈaÐP[ÉnØ	ˆ/Ñ˜A˜h™K¨¨>Ñ):Ò)@¸bÀ!ÀMÑBRØ	�‰ˆn˜bÓ! 1§5¡5¨¸"Ó#=òð +ð	 	ñ ,ô
 ØÐ.ò	]à±%”{ 5¨#Ó.ô	Lð Lð >Kô	Lð Lùó,s    AB)$rŒ   Úloggingr   r   r   Údjango.httpr   Údjango.utilsr   ÚNexusApp.modelsr   r	   Ú NexusApp.models.attendance_modelr
   ÚNexusApp.utils.excelr   r   r   Ú	getLoggerÚ__name__Úloggerr&   r   r(   r-   r4   r:   r=   rB   rO   rf   ri   rv   r¡   r¦   r¯   r3   r)   r   Ú<module>r¹      sˆ   ðÛ Û ß .Ñ .å $Ý !ç /Ý =ß GÑ Gà	ˆ×	Ñ	˜8Ó	$€ò,€òòò3òJòFò"ògò	òò$ò,ò&AòHóLr)   