vg:dZddlZddlmZmZddlmZddlmZddlm Z ddl m Z ddl mZmZmZdd lmZmZmZmZdd lmZmZmZdd lmZdd lmZmZdd lm Z ddl!m"Z"ddl#m$Z$ddl%m&Z&m'Z'ddl(m)Z)ddZ*dZ+e'dZ,e'e&dZ-e'e&dZ.e'e&dZ/ddZ0d dZ1d dZ2dZ3e'dZ4dZ5e'dZ6y)!zX dashboard.py This module is used to register endpoints for dashboard-related requests N)datedatetime)apps) JsonResponse)render) gettext_lazy)AttendanceFiltersAttendanceOverTimeFilterLateComeEarlyOutFilter)get_month_start_end_datesget_week_start_end_datespending_hour_dataworked_hour_data) AttendanceAttendanceLateComeEarlyOutAttendanceValidationCondition)strtime_seconds)filtersubordinates paginator_qry) Department)Employee)settings)hx_request_requiredlogin_required)get_horilla_model_classcd}tjj|}||j|}tjj|d}t |t |z }|S)zC This method is used to find count for on time attendances r)attendance_date).employee_id__employee_work_info__department_id late_come)attendance_id__attendance_datetype)robjectsfilterrlen)requesttodayweek_day departmenton_time attendancesrs ./var/www/horilla/attendance/views/dashboard.py find_on_timer,(s| G$$++E+BK!((;E) +2299',;:I+Y/G Nctjjd}tjdr*t dd}|jjd}ng}t |t |z }|S)zT This method is used to find count of expected attendances for the week day T) is_activeleave leaverequest) app_labelmodelApproved)status)rr"r#r is_installedrr$)r' employees LeaveRequeston_leaveexpected_attendancess r+find_expected_attendancesr;:sn  ''$'7I !.W ''..j.Ay>CM9 r-c Ptj}|jdj}t |||}t |}t |}||z}t|}d}d} d} |dk7r||z dzd}||z dzd} ||z dzd} t|d|||| ||| d S) zR This method is used to render individual dashboard for attendance module z%A)r&r') start_date)r'rdz.2fz#attendance/dashboard/dashboard.html)r) on_time_ratiorlate_come_ratior:marked_attendancesmarked_attendances_ratio) rr&strftimelowerr,find_late_comer$r;r) r%r&r'r)r late_come_objrAr:r?r@rBs r+ dashboardrGHs NN E~~d#))+H7%(CG%0I NM&04hGMO q #&::cA#F +.BBcI#N"%99S@E ! -*&.$8"4(@   r-ctj}tjj d|}d|i}t |d|S)a\ Fetches and displays employees who left early (early outs) for the current day. This view retrieves all records from the `AttendanceLateComeEarlyOut` model where the type is "early_out" and the associated attendance date matches the current date. The results are passed to the template `on_break_employees.html` for rendering early_out)r!r on_breakz,attendance/dashboard/on_break_employees.html)rr&rr"r#r)r%r& early_outscontexts r+on_break_employeesrMqsP NN E+33:: ;J JG 'I7 SSr-c~d}|jjdd}ddj|jdddz}|dk(rd}|jjd}t j j}td}|!|jt|j}tj j|ddd }t|d | }|Dcgc]}|j}}tjt!|} t#||}|| |d } t%|d | Scc}w)a Displays and validates employee overtime records for the dashboard. This view retrieves a paginated list of employee attendance records with overtime that meets or exceeds a specified minimum threshold, which is defined in the `AttendanceValidationCondition` model. Only records that are validated but not yet approved are included, and the results are filtered based on the user's subordinate permissions. N HTTP_REFERER/Tpage00:00Fovertime_second__gteattendance_validatedemployee_id__is_activeattendance_overtime_approveattendance.change_overtimer%permqueryset)overtime_attendancesot_attendances_idsmain_dashboardz(attendance/dashboard/overtime_table.html)METAgetjoinsplitGETrr"firstrminimum_overtime_to_approverr#ridjsondumpslistrr) r%r_referer page_number conditionmin_otot_attendancesotid_listr^rLs r+dashboard_approve_overtimesrrs:Nll~s3GCHHW]]3/344G#~++//&)K-55;;=I W %F!F!F!R !F!FG''..#!#$) /N ( )N ..ruu.G.DM2">;?N .0(G 'Ew OO/s(D:cd}|jjdd}ddj|jdddz}|dk(rd}|jjd}t j jdd}t|d | }|Dcgc]}|j}}tjt|}t||}|||d }t|d |Scc}w) aG Displays and validates employee attendance records for the dashboard. This view retrieves a paginated list of attendance records that have not yet been validated. Only records belonging to active employees and accessible subordinates, as determined by the user's permissions, are included in the results. NrOrPrQTrRF)rVrWrYrZ)validate_attendancesvalidate_attendances_idsr_z+attendance/dashboard/to_validate_table.html)r`rarbrcrdrr"r#rrgrhrirjrr) r%r_rkrlrtvalvalidate_id_listrurLs r+dashboard_validate_attendancesrxsNll~s3GCHHW]]3/344G#~++//&)K%--44"45. )% +??3??#zz$/?*@A()={K 4$<(G 'H' RR@sC,c8t|||dj}|S)z6 This method is used to find total attendance )attendance_date__gteattendance_date__lter()r qs)r=r(end_date attendances r+total_attendancers.#$.$,$   b  r-ct|td|||dj}|Std||dj}|S)z1 This method is used to find late comers rr!r(rzr{r!rzr{r r|)r=r(r}rFs r+rErEc.#((2(0    "  /#(2(0  "  r-ct|td|||dj}|Std||dj}|S)zT This method is used to find early out attendances and it returns query set rIrrr)r=r}r( early_out_objs r+find_early_outrrr-chg}g}g}d}|dk(r|}|}|dk(rt|\}}|dk(rt|\}}|dk(r|}|}t|||}t|||}t |||}t |t |z }i} |s|s|r$|j |t |t |gd} | r| Sd S) z@ This method is used to generate all the dashboard data rdayweeklymonthly date_ranger=r(r})r(r=r}labeldataN)r r rrErr$r() r%r=r!r}deptr~rFrr)rs r+generate_data_setrsJMMG u}  x7 C H y8D H | "$J #$M #JM*oM 22G D-=__c-0#m2DE  4!T!r-c tdtdtdg}g}tj}|}d}|jj dr|jj d}|jj dr|jj d}|jj dr|jj d}t j j}|D] }|jt|||||"td}ttd|}t|||d S) z This method is used to render json response of dashboard data Returns: JsonResponse: returns data set as json zOn Timez Late Comez Early Outrr!r}z#No records available at the moment.N)dataSetlabelsmessage) _rr&rdrarr"allappendrrjr#r) r%rdata_setr=r}r! departmentsrrs r+dashboard_attendancerFs )  + +F HJH D{{v[[__V, {{v{{v&{{z";;??:.$$((*KV)':tXtTUV56GF4*+H H7S TTr-ct|jj}ttj j dd}|t||t||gd}td|iS)z, pending hours chart dashboard view r(T)flat)rdatasetsr) r rdr|rjrr" values_listrrr)r%recordsrrs r+ pending_hoursrjsl'w{{366G *$$00D0I JF fg . VW -  D  ''r-c |jjdr|jjdntj}|jjdr|jjdnd}|jjdr|jjdn|}|dk(r|}|}|dk(rt |\}}|dk(rt |\}}|dk(r|}|}t |d|}tjj}td }|!|jt|j}|j|d d d }g}g} |D]}|js|jjs'|jjjsH|j!|jjjj"t%t'|}|D]} | j!| d d |D]{}|jjjs$|jjjj"} |j(} | dz } | D]} | d| k(s | dxx| z cc<}dgdg}t+| |D](\}} | |dk(s|d dj!|d*||| t-ddt.j0dd}t3|S)Nrr!rr}rrrrrSTrTr)r(ot_hoursir(rrrz!No validated Overtimes were foundrPzimages/ui/overtime-icon.png)datasetrdepartment_totalr emptyImageSrc)rdrarr&r r rrr"rerrfr# employee_idemployee_work_info department_idrr(rjsetapproved_overtime_secondziprr STATIC_URLr)r%r= chart_typer}r~rmrnr*rrdepartr(rpot_hrsr depart_totalresponses r+department_overtime_chartr{s,3KKOOF,C(J,3KKOOF,C(J'.{{z'B  #  U X7 C HY8D H\! !$J.55;;=I W %F!F!F!R !F!FG###!#$( $K K!  " "&&99&&99GG   &&99GGRR  s;'(KGv1 EFG" 1  ! ! 4 4 B B&&99GGRR 44B$YF* 1,':5:&&0& 1 1 G!$$4k B@ f \,/ / AJv  % %l:&> ?@ ,89X0011LM H  !!r-)N)NN)7__doc__rhrr django.appsr django.httprdjango.shortcutsrdjango.utils.translationrrattendance.filtersr r r attendance.methods.utilsr r rrattendance.modelsrrrattendance.views.viewsr base.methodsrr base.modelsremployee.modelsrhorillarhorilla.decoratorsrrhorilla.methodsrr,r;rGrMrrrxrrErrrrrr-r+rs  #$#6   3:"$B3$  %%PTT$)P)PX!S!SH 00,"^ U UF("O"O"r-