vg}J dZddlZddlmZmZmZddlZddlmZddl m Z ddl m Z ddl mZmZddlmZdd lmZdd lmZdd lmZmZmZdd lmZdd lmZmZddddddddddddd Z dZ!dZ"d9dZ#d9dZ$dZ%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/Z5Gd0d1Z6Gd2d3Z7d4Z8d5Z9d6Z:d7Z;d8Zb()G7T>R'(G3Zq &&c ~gd}tdt|tt|jdDS)z this method is used reconvert time in H:M formate string back to seconds and return it args: time : time in H:M format )r-r.rc3,K|] \}}||zywN).0abs r5 z"strtime_seconds..<sEAq1uEsr0)sumzipmapr1split)rftrs r5strtime_secondsrE4s2 C ES#c:4::c?*C!DE EEr7ci}|jj}|r|Dcgc]}|j|vs|}}|D]E}t||j}t||j}||k7s5||f||j<G|Scc}w)aj Compare the fields of two instances and identify the changes. Args: first_instance: The first instance to compare. other_instance: The second instance to compare. exclude_fields: A list of field names to exclude from comparison (optional). Returns: A dictionary of changed fields with their old and new values. )_metafieldsnamegetattr)first_instanceother_instanceexclude_fields differencefields_to_comparefield old_value new_values r5 get_diff_objrS?sJ&,,330 EJJn4TE  #<NEJJ7 NEJJ7  !&/%;Juzz " <  s BBcfi}|jD]\}}|j|}||k(r|s||f||<(|jj|}|j}t |t jr]|r*|dk7r%tj|djdn|}|r*|dk7r%tj|djdn|}nt |t jrd} | |}| |}nt |t jr|r?t|jr&|jj j|n|}|r?t|jr&|jj j|n|}||f||<|S)an Compare two dictionaries and identify differing key-value pairs. Args: first_dict: The first dictionary to compare. other_dict: The second dictionary to compare. model: The model class (optional, for verbose names and type-specific formatting) Returns: A dictionary of differing keys with their old and new values. None%Y-%m-%dz%d %b %Yc|rN|dk7rI|t|jddk(rdndz }tj|dj dS|S)NrUr0rz:00%H:%M:%Sz%I:%M %p)lenrCrstrptimestrftime)vals r5r6z"get_diff_dict..format_timesN3&=C #$71$<5"DC#,,S*=FFzRR r7)id)itemsgetrG get_field verbose_name isinstancer DateFieldrr[r\ TimeField ForeignKeystrisdigit related_modelobjects) first_dict other_dictmodelrNkeyvalue other_valuerP verbose_keyr6s r5 get_diff_dictrr^sJ &&(07 U nnS) K  $k2JsO  %%c*((  eV-- .Uf_!!%4==jI ;!!+z:CCJO   v// 0   &E%k2K v00 1SZ//1##++//5/9 3{#3#;#;#=##++//;/?  $)+"6 ;a07d r7crd\}} |jj}|j}||fS#||fccYSxYw)zb This method return the employee instance and work info if not exists return None instead )NN)user employee_getemployee_work_info)requestemployeervs r5employee_existsrysH$. H .<<,,%88,--,--s"-6c"|jj|}d\}}}|jrY|d}|j}t |j j d}t |jj d}|||fS)z This function is used to find shift schedules for the day, it will returns min hour,start time seconds end time seconds args: shift : shift instance day : shift day object )shift_id)rr00:00rz%H:%M) day_schedulefilterexistsminimum_working_hourrE start_timer\end_time)dayshiftschedule_todaystart_time_sec end_time_sec minimum_hours r5shift_schedule_todayrs%%,,e,.NL,'*%:: ()B)B)K)KG)TU&~'>'>'G'G'PQ ., 77r7c|j}|j}t|}t|}||kDrt||z Sy)a This method is used to calculate overtime of the attendance, it will return difference between attendance worked hour and minimum hour if and only worked hour greater than minimum hour, else return 00:00 args: attendance : attendance instance r|)rattendance_worked_hourrEr6) attendancerat_work at_work_secminimum_hour_secs r5overtime_calculationrsL**L//G!'*K&|4%%K*::<< r7c|jj} |jjj}||k(S#t $rt dcYSwxYw)a if the instance have employee id field then you can use this method to know the request user employee is the reporting manager of the instance args : request : request instance : an object or instance of any model contain employee_id foreign key field z,This Employee Dont Have any work information)rtru employee_idrvreporting_manager_id Exceptionr )rwinstancemanageremployee_workinfo_managers r5is_reportingmangerrs`ll''GL  3 3 H H " / // LJKKLs =AAcd} tj||}|jS#t$r}t t dd}~wwxYw)NrYz,Invalid format, it should be HH:MM:SS format)rr[r ValueErrorr_)ro timeformat validtimees r5validate_hh_mm_ss_formatrsOJQ%%eZ8 ~~ Qa NOPPQs%* A AA cV|jddk(r#dj|jddd}t|dkDrt t d |jd\}}t|dkDst|dkDrt t dt |}t |}tt|dkDs$tt|dkDs |tdvrt t d y#t$r}t t d |d}~wwxYw) M this method is used to validate the format of duration like fields. r0rNrz)Invalid format, it should be HH:MM formatrz Invalid timer.Invalid time, excepted MM:SSzInvalid format) countjoinrCrZrrr1rgranger)ror3minuteerrors r5validate_time_formatrs {{31S)"1-. 5zA~a KLMM >{{3' f t9q=CK!O!!N"34 44yV s4y>A S[!1A!5uRy9P!!$B"CD D:Q >a 012=>sB)D D(D##D(ctjj}|stt d||kDrtt dy)z Validates if the provided date is not a future date. :param date: The date to validate. :raises ValidationError: If the provided date is in the future. zCheck date format.z You cannot choose a future date.N)rtodaydaterr)rrs r5attendance_date_validatersJ NN  ! ! #E a 4566 a BCDD r7c|jj}|jj}|jj}|jj }|jj }|jj}|jj}|jj}|jj } |jj } t|||||t|||| | fS)z This method is used to convert clock-in and clock-out of activity as datetime object args: attendance_activity : attendance activity instance ) clock_in_dateyearmonthrclock_inr3rclock_out_date clock_outr) attendance_activityin_yearin_monthin_dayin_hour in_minuteout_year out_monthout_dayout_hour out_minutes r5activity_datetimers"//44G"0066H . . 2 2F!**//G#,,33I"1166H#2288I!0044G",,11H$..55J GXvw BH)Wh E r7ctt|jd\}}tj|d|ddj }|t dz}||fS)zI This method is use to return the start and end date of the week z-Wz-1z %Y-W%W-%wrdays)rBr1rCrr[rr)weekr week_number start_dateend_dates r5get_week_start_end_datesr*sd CD!12D+""dV2k]"#={KPPRJI1--H x r7ctt|jd\}}t||dj }t j ||\}}t|||j }||fS)zJ This method is use to return the start and end date of the month -r)rBr1rCrrcalendar monthrange) year_monthrrrrlast_dayrs r5get_month_start_end_datesr:sp c:++C01KD%$q)..0J%%dE2KAxeX.335H x r7cddd}g}|D]H}|j|jtdd}|j|r|dz nd J||d <|S) z& To find all the worked hours z Worked Hourszrgba(75, 192, 192, 0.6)labelbackgroundColor:employee_id__employee_work_info__department_id__departmenthour_account_second total_sumrr-rdatar~ aggregater appendlabelsrecordsr dept_recordsdeptrs r5worked_hour_datarJs  4 DLBNNGK# )c"78) 9+G   I,qA B  DL Kr7cddd}g}|D]H}|j|jtdd}|j|r|dz nd J||d <|S) z' To find all the pending hours z Pending Hourszrgba(255, 99, 132, 0.6)rrhour_pending_secondrrr-rrrrs r5pending_hour_datar\s !4 DLBNNGK# )c"78) 9+G   I,qA B  DL Kr7c\|jjr|jjSy)z5 This method is used to return the last name rX)remployee_last_name)rs r5get_employee_last_namerns(00%%888 r7ctj|d}|jd}g}tjj }|D]}|j }|j}tjt|d}tjt|d}|} | |ksa|j| jd| tdz } | |kr5|D]} t| t|k(sd}ni} tjj } | D];} ttj| j}| j }|| |<=t|j"dz dzdzdz }| j%D]c}t|ddk(rt|dt|k(rd}|St|d|k(sEt|dt|k(s`d}|S|S) NrVz%Arrr|rrrU)rr[r\rrjallrrrgrrrdictrr`based_on_week_day based_on_weekrr_)attendance_daterattendance_datetimeattendance_dayleavesholidaysholirr current_dateleavecompany_leaves company_leave com_leaver=r> week_in_monthpairss r5attendance_day_checkingrws"++OZH)11$7NF##%H .__ ==&&s: C $$S]J?" h& MM,// ; < I1- -Lh& . u:_- -"L  N!))--/M" O   ; ; <  # #q -11A5!;a?1DEM %%'  uQx=F "58}N 33&   uQx=M )58}N 33&    r7cPt|t}|j|}|S)z2 This method is used to paginate queryset )rr get_page)qryset page_number paginators r5 paginator_qryrs(&."23I    ,F Mr7c g}tjj||}|t|j ddz }t jj }|D]o}|}|}|j}|j}|dk7rtjdtj||}|t|} | D cgc] } | dk7s |  } } | D]c} tj|d|dd| dd j} | j!t|k(sN| |vsS|j#| etjdtj||}|D]d} | t|dk7stj|d|dd| t|dd j} | |vsT|j#| fr|Scc} w) N)start_date__monthstart_date__yearrT)flatrrr02rV)rrjr~list values_listrrrrrsetfirstweekday monthcalendarr1rr[rweekdayr)rr leave_datesrrrrrmonth_calendarweeksrweekdays_in_weeks date_namers r5monthly_leave_daysrsK&&QU&VH4,,\,EFFK"**..0N'6 %33 );; D  $ $Q '%33D%@N"3}#56E05 B B  B( 2$--fAeBZqR1:$&%%'3/@+AA!4&&y1 2  $ $Q '%33D%@N& 6-./14 ( 1 1&%1T#6G2H-I",MN"!df! 3#**95 6-6< +!Cs  GGct|dkDrttd |jd\}}t|dkDst|dkDrttdt |}t |}|t dvs |t dvrttdy#t $r}ttd|d}~wwxYw) rrz)Invalid format, it should be MM:SS formatr0rrr.zInvalid format, excepted MM:SSN)rZrrrCr1rr)ror4secrs r5validate_time_in_minutesrs 5zA~a KLMM K{{3'  wCCEE    s#A## A/.A/c tj|jS#tjjt f$rd|j d||<YywxYw)NzInvalid date format for )pd to_datetimererrors ParserErrorrrC)date_str error_keyactivitys r5 parse_dater7*s^~~h',,.. II ! !: . 89J29N8OPs"%z%sort_activity_dicts..Qs CTAUr7)rn)r=sorted)activity_dictsr6sorted_activity_dictss r5sort_activity_dictsrFFso"L&.x8I/J&K"#L '  % & 2 N #>7UV  s=r:)=r"rrrrpandasr0django.core.exceptionsrdjango.core.paginatorr django.dbrdjango.db.modelsr r django.httpr django.utils.translationr r base.methodsr base.modelsrrremployee.modelsrhorilla.horilla_settingsrr MONTH_MAPPINGr6rErSrrryrrrrrrrrrrrrrrrrrrr-r7r:r=rFr;r7r5rSs ..2+#$6'::$O     'F>@F .8$$0&Q>. E0   $$5p$NK$8 # #   !r7