vgcdZddlZddlZddlZddlmZddlmZddlm Z ddl m Z m Z mZmZmZddlmZddlmZdd lmZdd lmZGd d ej2ZGd deZGddeZGddeZGddeZGddZGddZ GddZ!GddZ"GddZ#dZ$ejJZ&d Z'e'e_%y)!zI filters.py This page is used to register filter for attendance models N)forms) DateTimeInput) gettext_lazy) AttendanceAttendanceActivityAttendanceLateComeEarlyOutAttendanceOverTimestrtime_seconds) FilterSet)EmployeeFilter)Employee)filter_by_nameceZdZdZdZy)DurationInSecondsFilterzG Custom CharFilter class that applies specific filter process. c |rpgd}tdt|tt|j dD}|j xsd}|j di|jd||iS|S)z FilterSet filter method Args: qs (self): FilterSet instance value (str): duration formatted string Returns: qs: queryset object )i<c3,K|] \}}||zyw)N).0abs &/var/www/horilla/attendance/filters.py z1DurationInSecondsFilter.filter../sVAq1uVs:exact__r)sumzipmapintsplit lookup_exprfilter field_name)selfqsvalueftr duration_seclookups rr$zDurationInSecondsFilter.filter"sq CVS#c5;;sCS:T1UVVL%%0F299N4??"32fX > MN N N)__name__ __module__ __qualname____doc__r$rr,rrrs r,rc eZdZdZdedfdedfdedfdedfdedfdedfdedfd ed fd ed fd ed fd ed fd ed fg ZejeZ e ddZ e ddZ e ddZ e ddZe ddZe ddZej"edZejddZGddZddddfd ZxZS)AttendanceOverTimeFilterz Filter set class for AttendanceOverTime model Args: FilterSet (class): custom filter set class to apply styling JanuaryFebruaryMarchAprilMayJuneJulyAugust SeptemberOctoberNovemberDecembermethodhour_account_secondgter%r#ltehour_pending_secondovertime_second icontains)choicesr#:employee_id__employee_work_info__department_id__departmentceZdZdZeZgdZy)AttendanceOverTimeFilter.Meta6 Meta class to add additional options ) employee_idmonthovertime worked_hoursyeardepartment_name.employee_id__employee_work_info__department_id+employee_id__employee_work_info__company_id0employee_id__employee_work_info__job_position_id)employee_id__employee_work_info__location5employee_id__employee_work_info__reporting_manager_id)employee_id__employee_work_info__shift_id-employee_id__employee_work_info__work_type_idN)r-r.r/r0r modelfieldsrr,rMetarKes # r,r\Nrequestprefixct||||||jjj D]E}t j |jj|jjd<GyN)dataquerysetr^r_id super__init__formr[keysuuiduuid4widgetattrsr&rbrcr^r_field __class__s rrgz!AttendanceOverTimeFilter.__init__{j dXwvVYY%%**, KE<@JJL>DII  U # * * 0 0 6 Kr,NN)r-r.r/r0_ MONTH_CHOICESdjango_filters CharFilterrsearchrworked_hours__gteworked_hours__ltepending_hours__ltepending_hours__gte overtime__gte overtime__lte ChoiceFilterrNrRr\rg __classcell__rps@rr2r25sk AiL! Qz]# !G* !G* % 6 6 1X; a n% AiL! Qz]# Qz]# M'^ & &n =F/(e0(e1(e1(e,$%M,$%M (N ' ' ; WE/n//OO   ,KDKKr,r2ceZdZdZej eZeje jje jZejdde j ddi Zejdd e j ddi Zej&d e j(dd id Zej&d e j(dd id Zej&de j(dd id Zej&de j(dd id Zej&d e j(dd id Zej&de j(dd id Zejde j ddiZedd ZeddZedd ZeddZ ej ddZ!ej ddZ"ej ddZ#ej ddZ$GddZ%ddddfd Z&xZ'S)LateComeEarlyOutFilterz& LateComeEarlyOutFilter class r?rcrlattendance_id__attendance_daterBtypedatermr%r#rlrD"attendance_id__attendance_clock_intimer%rlr##attendance_id__attendance_clock_outrr%rlattendance_id__overtime_secondrCattendance_id__at_work_secondrIrGrQrNweekceZdZdZeZgdZy)LateComeEarlyOutFilter.Metaz* Meta class for additional options)rMrattendance_id__minimum_hour%attendance_id__attendance_worked_hour*attendance_id__attendance_overtime_approve#attendance_id__attendance_validatedrSrTrUrVrWattendance_id__shift_idattendance_id__work_type_idattendance_date__gteattendance_date__lteattendance_clock_in__lteattendance_clock_in__gteattendance_clock_out__gteattendance_clock_out__lteattendance_clock_inattendance_clock_outattendance_date departmentrQrNrN)r-r.r/r0rrZr[rr,rr\rs -+ r,r\Nr]ct||||||jjj D]E}t j |jj|jjd<Gyrarerns rrgzLateComeEarlyOutFilter.__init__rqr,rr)(r-r.r/r0rurvrrwModelMultipleChoiceFilterr objectsallrSelectMultiplerM DateFilter DateInputrr TimeFilter TimeInputrrrrrrrrovertime_second__lteovertime_second__gteat_work_second__lteat_work_second__gterrQrNrr\rgrrs@rrrs'^ & &n =F:.::!!%%'#u##%K5>443uff%56 5>443uff%56 9~887uff%56  9~887uff%56  !: 9 98uff%56! !: 9 98uff%56! 4.337uff%56 5>448uff%56 0n//3uff%56O33332222+**OJ %> $ $3 D &N % %3 E %> $ $3 D   DKDKKr,rc0eZdZdZej eZejde jddiZ ejdde jddi Z ejdd e jddi Z ejd de jdd i Zejd de jdd i Zejd d e jdd i Zejd d e jdd i Zejde jddiZejde jddiZGddZddddfd ZxZS)AttendanceActivityFilterz Filter set class for AttendanceActivity model Args: FilterSet (class): custom filter set class to apply styling r?rrrrrrBrrDclock_inr clock_out clock_in_dateclock_out_dateceZdZdZgdZeZy)AttendanceActivityFilter.MetarL)rMrattendance_date_fromattendance_date_tillin_fromin_tillout_from shift_dayout_tillrrrSrTrXrYrUrVrWN)r-r.r/r0r[rrZrr,rr\r+s  (#r,r\Nr]ct||||||jjj D]E}t j |jj|jjd<Gyrarerns rrgz!AttendanceActivityFilter.__init__Frqr,rr)r-r.r/r0rurvrrwrrrrrrrrrrrrr\rgrrs@rrrs'^ & &n =F/n//$_U__FFCS-TO5>44$uff%56 5>44$uff%56 (n''uff%56G )~((uff%56H (n''uff%56G )~((uff%56H .N--"?5??&&AQ+RM/^..#OEOO66BR,SN##6KDKKr,rc6eZdZdZej dZejdZejdZ ejdZ eje jjej"Zejdd ej&d d i  Zejddej&d d i  Zej,dej.d di dZej,dej.d di d Zej,dej.d di d Zej,dej.d di dZej,dej.d di Zej,dej.d di Zejej&d d i ZedZ edZ!eddZ"edd Z#eddZ$edd Z%ejddZ&ejddZ'ejddZ(ejddZ)dZ*Gdd Z+d%d!d!d"fd# Z,d$Z-xZ.S)&AttendanceFiltersz~ Filter set class for Attendance model Args: FilterSet (class): custom filter set class to apply styling rd)r%rr?employee_id__idrrrBrrrrrDrrrrr)rlfilter_pending_hourat_work_secondrCrFrQrNrrIrGc@|nt|}g}|D]\}t|j}|j}||z }|dk(r||k\s4|j|F||ksL|j|^|j Dcgc]}|j c}Scc}w)a This method calculates the pending hours for each attendance record in the queryset and filters the records based on whether the pending hours are less than or equal to (`pending_hour__lte`) or greater than the specified value. pending_hour__lteid__in)r minimum_hourrappendr$rd) r&rcnamer(filtered_attendance attendanceminimum_hour_secondworked_hour_secondpending_hour_seconds rrz%AttendanceFilters.filter_pending_hours  #E*E"$ & ? &5j6M6M&N#%/%>%>"&9 33+22:> ?4GHjJMMH  HsBc6eZdZdZeZgdZdeddiiZy)AttendanceFilters.MetarL) rdrMrSrTrUrVrWattendance_dayr work_type_idshift_idrattendance_validatedrrrrFlate_come_early_out__typeattendance_overtime_approveris_validate_requestis_validate_request_approvedis_bulk_requestrrrrrFrrNrQbatch_attendance_idrrrrN) r-r.r/r0rrZr[rwidgetsrr,rr\rs. ! H }FF3CD r,r\Nr]ct||||||jjj D]E}t j |jj|jjd<Gyrarerns rrgzAttendanceFilters.__init__rqr,cddddddd}|jjd}|s~|j}|d }t|d kDrd j |d d nd }|r|r|j ||}|S|r|j |}|S|r|j |}|S|j|} |j di| |i}|S)a This method allows filtering by the employee's first and/or last name or by other fields such as day, shift, work type, department, job position, or company, depending on the value of `search_field` provided in the request data. attendance_day__day__icontains#shift_id__employee_shift__icontains"work_type_id__work_type__icontainsEemployee_id__employee_work_info__department_id__department__icontainszYemployee_id__employee_work_info__ job_position_id__job_position__icontains?employee_id__employee_work_info__company_id__company__icontains)dayshift work_typer job_positioncompany search_fieldrr N)+employee_id__employee_first_name__icontains*employee_id__employee_last_name__icontains)r)rr)rbgetr"lenjoinr$) r&rcrr( filter_methodrparts first_name last_namer$s rrz AttendanceFilters.filter_by_names4:=a:X yy}}^4 KKMEqJ/25zA~qr+2Ii#??@J?H+ #??@J+#???H+#&&|4F&x9&%9Hr,rr)/r-r.r/r0ru NumberFilterrdrvrwemployeerdate_attendancerr rrrrrMrrrrrrrrrrrrrrpending_hour__gterrrrrQrNrrrr\rgrrrs@rrrLs % $ $ 5B &^ & &.> ?F(~((4EFH/n//;LMO:.::!!%%'#u##%K 5>44$uff%56 5>44$uff%56 9~88(uff%56  9~88(uff%56  !: 9 9)uff%56! !: 9 9)uff%56! 4.33(uff%565>44)uff%56 0n//uff%56O0$0$2#2#3$%3$% %> $ $0Av VD %N % %1BPW XE $> $ $0Av VD***OJ  .+ + ZKDK (r,rceZdZdZgdZy)LateComeEarlyOutReGroup: Class to keep the field name for group by option ) rSelectrMr )rType)rAttendance Date)rShift)r Work Type)r Minimum Hour)#attendance_id__employee_id__countryCountry)Dattendance_id__employee_id__employee_work_info__reporting_manager_idReporting Manager)=attendance_id__employee_id__employee_work_info__department_id Department)?attendance_id__employee_id__employee_work_info__job_position_id Job Position)@attendance_id__employee_id__employee_work_info__employee_type_idEmployment Type):attendance_id__employee_id__employee_work_info__company_idCompanyNr-r.r/r0r[rr,rrrsFr,rceZdZdZgdZy)AttendanceReGroupr) rrrBatchrr)rr)rr)rremployee_id__countryrrWrrSr rUr 1employee_id__employee_work_info__employee_type_idrrTrNrrr,rrr5sFr,rceZdZdZgdZy)AttendanceOvertimeReGroupr) rr)rNMonth)rQYearrrrXrrYrrrrrNrrr,rr r Ks Fr,r ceZdZdZgdZy)AttendanceActivityReGroupr)rrr)rIn Date)rOut Date)rz Shift Dayrrr#r$rrrrNrrr,rr&r&`Fr,r&ceZdZdZgdZy)AttendanceRequestReGroupr)rrr)rr)attendance_clock_in_dater')attendance_clock_out_dater(rrr#r$rrrrNrrr,rr+r+wr)r,r+cFtjjj}|tjdz }tj j ||djdd}|r|j |}|S|j|}|S)Nr)daysT)rr!attendance_clock_out_date__isnullrM)flatr) datetimenowr timedeltarrr$ values_listexclude)rc_namer(today yesterdayworking_employeess rget_working_todayr;s    ! ! # ( ( *E**22I"**11&"*.2k-dk+   ??*;?< O##+<#= Or,c8t|g|i|tjdt}||jd<|j |j jd<|j jdjjjddiy)NWorking)labelr@ working_todayclasszoh-select oh-select-2 w-100) og_initru BooleanFilterr;filtersrorhr[rlrmupdate)r&argskwargs custom_fields r online_initrHs D"4"6"!// 1L%1DLL!(4(:(:DII_%II_%,,2299 2 r,)(r0r2rjrudjangor django.formsrdjango.utils.translationrrsattendance.modelsrrrr r base.filtersr employee.filtersr employee.modelsr horilla.filtersrrvrr2rrrrrr r&r+r;rgrArHrr,rrQs &6#+$*n770IKyIKXuKYuKpPKyPKfG GT>,*.."  ! ! &r,