{jq ddlZddlZddlZddlZddlZddlmZmZddl m Z m Z m Z m Z ddlmZej eZgdZdddd d d Zd Zd ZGd de j.ZdZdZdZy)N)timezoneutc)_apifieldsmodels) UserError) JanuaryFebruaryMarchAprilMayJuneJulyAugust SeptemberOctoberNovemberDecember)z#ddd6fez#5b21b6)z#fed7aaz#9a3412)z#fecdd3z#9f1239)z#fbcfe8z#9d174d)z#e9e9e9z#57534eALPLSLMLULc,eZdZdZdZdZejddZejd dZ e dZ d dZ d Z d Z d d Zd Zejd ZdZejdZdZe dZdZejdZejdZ d dZejdZe dZe dZe dZe dZe dZdZ ej d!dZ!ejd dZ"y)"XenoAttendanceReportzxeno.attendance.reportz2Monthly attendance report from HRSystem SQL Serverc  ddl}|jdj }|j d}|sttd|j|t|j dd|j d|j d |j d d d d S#t$rttdwxYw)NrzThe 'pymssql' Python package is not installed in the Odoo environment. Install it in the Odoo container to enable the attendance report.zir.config_parameterz hrsys.hostztHRSystem connection is not configured. Set hrsys.host / hrsys.db / hrsys.user / hrsys.password in system parameters.z hrsys.port1433z hrsys.userzhrsys.passwordzhrsys.dbHRSystemZ)serverportuserpassworddatabasetimeout login_timeout) pymssql ImportErrorr renvsudo get_paramconnectint)selfr+phosts +xeno_attendance/models/attendance_report.py_connzXenoAttendanceReport._conn.s   HH* + 0 0 2{{<(AO Q[[v67\*[[!12[[Z8b    A%  s B))CNcng}|r|jddt|f|r|jddt|gf|r|jddt|f|sy|jdjj |}|j dDchc]}|s| c}Scc}w) aBxeno_employee_code set for hr.employee matching ALL of the given filters (Department/Group/Position on the Attendance report page) -- None when no filter is given at all, meaning "don't restrict", matching restrict_codes' own None-means-unrestricted convention everywhere else in this file. department_id= category_idsinjob_idN hr.employeexeno_employee_code)appendr1r-r.searchmapped)r2r8 category_idr<domain employeescs r5xeno_codes_for_filtersz+XenoAttendanceReport.xeno_codes_for_filtersGs  MM?C]1CD E  MM>4#k2B1CD E  MM8S#f+6 7HH]+00299&A $++,@AGaQGGGs #B2+B2c tj||d}d||fz}d|||fz}|j} |jd} | j d||f| j } | j d||f| j D cgc]7} | d| d j d | d j d | d xsd d9} } | j d||f| j D chc]} t| d} } | j d| j D cic]5} t| d| ddjd| d| dfDd7}} t|}|ji}|jdjjdddd|zfddd|zfgD]y}|jj}|j j}||ks=|j"||j d <|t%j&d z }||kr={t|jd!jjgj)d"}t+| |z |z }|D|Dchc] }t|}}| D cgc]!} t| j-d|vs | #} } |r5| D cgc]*} t| j-dt|k(r| ,} } |j/| ||||||#i}|jd$jjd%d|fd%d|fgD]:}|j0xsd ||j2|jj d f<<i}|jd&jjd'dd|fdd|fgD]}|j4d(k(r |j6nGt9|jd&j:d)j<j-|j4}t?|jt%j||d}tA|j t%j|||}||ks|xsd ||j2|j d f<|t%j&d z }||krC|jd*jjC}|Dchc]\}}| }}}|Dchc]\}}| } }}||Dchc] }t|c}n|r t|hnd}!| D chc]} t| j-d}"} ||z| z|"z }#|!|#|!z}#|#D]2}$|j-|$}%|%s| jE|%d|$|%d+d,d-4i}&|jd.jjd%d|fd%d|fgD]}'|'jFxsd|'jHxsd|'jJxsd |'jLj"tNjPjS|'jTd/|&|'j2|'jj d f<|jW||||}(|jY| D cgc]} | j-dc} })|j[| ||||| |&|(|)|| | ||| ||||&|(|)||d0 Scc} wcc} wcc} w#|jwxYwcc}wcc} wcc} wcc}}wcc}}wcc}wcc} wcc} w)1Nz %04d-%02d-01%04d-%02d-%02dT)as_dictz(EXEC [sp_get_attendance_month_V3] %s, %szSELECT la.employee_id, la.start_date, la.end_date, lt.code FROM leave_applications la JOIN leave_types lt ON lt.id = la.leave_type_id WHERE la.status='approved' AND la.start_date<=%s AND la.end_date>=%s employee_id start_date%Y-%m-%dend_datecode)rKstartendrOzYSELECT DISTINCT employee_code FROM vw_attendance_combined WHERE [date]>=%s AND [date]<=%s employee_codez>SELECT id, employee_code, first_name, last_name FROM employeesid c3&K|] }|s| ywN).0r3s r5 z8XenoAttendanceReport.get_month_report..zs$W1UVQ$Ws first_name last_name)rTnamezresource.calendar.leaves) resource_idr9F date_from<=z %s 23:59:59date_to>=z %s 00:00:00dayszxeno.attendance.code.map source_code)restrict_codesrSzxeno.attendance.dayoffdatezhr.business.trip)stater9 acknowledgedothers trip_typexeno.attendance.auto.ruler]rrKrS employee_namelatezxeno.attendance.override)time_intime_outnoteeditor edited_at) rowsrdholidaysleavesyearmonthunmapped_codes overrides odoo_leavessessionsdayoffsbusiness_trips).calendar monthranger6cursorexecutefetchallstrftimestrjoinsetcloser-r.r@r_rgrar]datetime timedeltarAsortedget_xeno_merge_native_attendancereasonrSrktrip_type_otherdict_fields selectionmaxminget_auto_fill_codesr?rprqrr write_uidrDatetime to_string write_date_xeno_odoo_leaves_xeno_calendar_sessions_xeno_recompute_late)*r2rxryrSrfrdr_raconncurrurrw raw_codesemployee_directory known_codesrvhdrRmapped_sourcesrzrEallowedr~dorbtlabelauto_fill_codes_d dayoff_codesbt_codesscope present_codesmissingrOempr{ovr|r}s* r5get_month_reportz%XenoAttendanceReport.get_month_reportZs""4/2"dE]2 "dE4%88zz| ++d++C KKB"G, .<<>D KK&)0';  =||~ '  !/<11*=}--j9& R 'F' KK24=w3G I;>,,.IQQ/0III KKX Y  "  Ao&'D'HH$W<!K.0Q$WW*" "01K JJL45::<CC ' $  7 8 mi7 8E  0A    "A)).."Cs(3466J/0X''Q//s( 0 HH/ 0 5 5 7 VBZ}-  K 7. HI  %'56!s1v6G6#N!s155+A'Bg'MANDN #J!15512c-6HHJDJ ** $t%7) + H((3499;BBdI &w(? @  XBIK UWGR%%rww'7'7 'CD E X((-.335<< +4 )ItY+G I 0B+-,,(*BB&&+,44[AKKIMMPSQSQ]Q]M^ BLL(--eQ"?@Abjj(--eT"BCCs(MR[VX 0 0!**Z2HIJX''Q//s( 0(((#>?DDFZZ\)01gq"1 1%34'1bA445C5O.1Q#a&1/<M*+$ >BCQUU?34C C"\1H< M   u G D$((.C KK"4y4!$Va    ((56;;=DDdI &w(? @ B::-KK/4 2,,++#__66r}}E KIr'')9)9*)EF G ",, w ? //-1 2QUU? # 24 !! $eXvy 7N <d $"0y*"n F Fw'J" JJL:7NJj241CD 3slA\<\ (\:\%\4:\. \\/7!\4\4%/\9 \>% ]:] #!]] \\,c||r'd|vr#|jdddjS|xsdjS)z'Personal Leave . PL' -> 'PL'. Leave types in this deployment are named " . ", so the abbreviation is the trailing dotted segment; anything without one falls back to the full name..rHrP)rsplitstrip) type_names r5_xeno_leave_abbrz%XenoAttendanceReport._xeno_leave_abbr sB  )##C+B/557 7R&&((c |jdj}ddd|fdd|fg}|,|jdd|Dcgc] }t|c}fn|r|jdd t|fi}|j |D]} | j j } | s|j| jj| jxsd | j| jd } | j| j} } | | ks| jd }||cxkr|krnn| |t| |f<| t!j"d z } | | krN|Scc}w)a(employee_code, 'YYYY-MM-DD') -> {abbr, unit, hf, ht} for every approved Odoo hr.leave overlapping the month. Unlike HRSystem's frozen leave_applications (full-day only), these carry the flexible-duration unit (part_time/first_half/second_half/full_day) and, for part-time, the requested hour range -- which the report needs to colour the day's pills and pick the right on-time threshold.zhr.leave)rhr9validaterequest_date_fromr`request_date_torbzemployee_id.xeno_employee_coder;r9full_dayabbrunithfhtrMrHrc)r-r.r?rr@rKr>rholiday_status_idr]xeno_request_unitrequest_hour_fromrequest_hour_torrrrr)r2r_rarfrSLeaverCrEr|lvrOinforrRdss r5rz&XenoAttendanceReport._xeno_odoo_leavessn$))+ & $ 0 i 0   % MM;T,:;qCF;= >  MM;S#mBTU V ,,v& 0B>>44D--b.B.B.G.GH,,: **(( D ))2+=+=sAs(ZZ +-g-37KTB0X''Q// s( 0 ) {weekday '0'..'6': sorted [(hour_from, hour_to)]} from each employee's resource.calendar, so the report can tell where the morning session ends / the afternoon session starts (needed for first-half / second-half leave on-time thresholds).r=r>r;) r-r.r@rresource_calendar_idattendance_ids setdefault dayofweekr? hour_fromhour_tosortr>) r2codesEmployeerErDr}rcalby_dowattdows r5rz,XenoAttendanceReport._xeno_calendar_sessions<s 88M*//1OO&:DSXBYa3q6BY%Z$[\  ;C**CF)) Z!!#--4;;S]]CKK.is_weekende$==ua088:a? ?rrKrSrP shift_start09:00Nr shift_end18:00rrHrIrp%s.Inro) rrrange_fmtrrrgr_xeno_expected_window _to_minutes)r2rurdrxryrvrwr{r|r}r~rrrrrOsstartsend emp_sessionstotalrrrtinleaver exp_start_exp_endtin_minexp_mins `` r5rz)XenoAttendanceReport._xeno_recompute_lateZs-R'-2 @ AUU=)Fquu_-34DeeM*5gr:FEE+&1'2A6D#<<b1LE1dQh' /*dE1-==qMW%8 '?g5$N9Z]]D'?3)+9 r)} IIaeeGg,=&>?--fdGV[Y(--eQ7??AB&*&@&@D,"2"23"7'@# 8$#'#3#3C#8$:J:J9:U&7+>7WCTWw..E% /&AfI5 rct|jjjdxsP|jjj xs.|jj jj xsdS)NtzUTC)rr-contextrr&rcompanyr)r2s r5_xeno_local_tzz#XenoAttendanceReport._xeno_local_tzsg HH    & A$((--*:*: Axx4477 A;@B BrcsdddS|j}tjj|j}|j |j |j g}|jd}tfd|dDd}|sdddS|j|jd|z}|j|jd|z}|r |r||k(rd}||dS) aToday's merged first-in/last-out for one employee, from either source (the biometric scanner via HRSystem, or Odoo's own hr.attendance -- see _xeno_merge_native_attendance, which already combines both into the same "%s.In"/"%s.Out" cells). Used by the "My Attendance" widget to detect a fingerprint check-in that Odoo's own hr_attendance module has no record of yet, so it can still show Present/Check Out instead of Absent/Check In. Nr;outrSrfrMc3pK|]-}t|jdtk(s*|/ywrSNrrrYrrSs r5rZz8XenoAttendanceReport.get_today_status..+ Z1AEE/,B(Cs=GY(YQ Z+66rur%s.Out) rrnowrgrrxryrnextrr) r2rSrtodaydatarrowin_vout_vs ` r5get_today_statusz%XenoAttendanceReport.get_today_statusst, ,  "!!%%b)..0$$ JJ =)?%,.., ZV Z t, ,yy7!234 #''(W"456 EdemE5))rcsy|j||g}tfd|dDd}|sydtfd|jDS)aDistinct calendar days this month with at least one recorded check-in for one employee, from the SAME merged source (biometric scanner via HRSystem's vw_attendance_combined + Odoo's own native hr.attendance, see _xeno_merge_native_attendance) as the My Attendance report -- NOT a raw hr.attendance count. An employee who only ever scans the physical biometric machine has zero hr.attendance rows in Odoo, so counting hr.attendance alone (the bug this method replaces, in xeno_mobile's own "This Month / Days Present" card) silently showed 0 for them even with a full month of real attendance on the desktop report. rrc3pK|]-}t|jdtk(s*|/ywrr r s r5rZz?XenoAttendanceReport.get_month_present_count..r r ruNz.Inc3RK|]\}}|js|sd yw)rHN)endswith)rYkvsuffixs r5rZz?XenoAttendanceReport.get_month_present_count..s"IA 60Bq1Is ''')rrsumitems)r2rSrxryrrrs ` @r5get_month_present_countz,XenoAttendanceReport.get_month_present_countsk$$ %})?%, ZV Z IIIIrc |jdjj|}|jr |jst t d|j}|j|j}|r>|j|tkDr|j|nt t d|j|}|dr|drt t d|j}tjj|j!}d|dj#dD\}} |j%tjj'|tj(|| } | j+t,j/d } tjj1} | | krt t d |jd jj3|j| | d } dt4j6j9| j:t4j6j9| j<dS)aCreate the Odoo-native hr.attendance record that closes out a day that started with a fingerprint-only check-in (no hr.attendance row yet): check_in = the fingerprint's first scan time today, check_out = now. Everything is re-verified server-side (no open native attendance already exists; a fingerprint "in" with no "out" really is there today) rather than trusting the client's cached state. r=z'No linked employee/HRSystem code found.zYAn attendance check-in already exists in Odoo -- use the normal Check Out button instead.r;rz-No open fingerprint check-in found for today.c32K|]}t|ywrW)r1)rYxs r5rZz=XenoAttendanceReport.close_fingerprint_day..s@1A@s:Ntzinfoz;Check-out time must be after the fingerprint check-in time. hr.attendance)rKcheck_in check_out checked_out)attendance_state last_check_inlast_check_out)r-r.browseexistsr>r r_xeno_open_attendancerT_xeno_attendance_age_hoursSTALE_CHECKIN_HOURS_xeno_close_stalerrrrrgsplitlocalizecombinetime astimezonerreplaceutcnowcreaterrrr'r()r2rKemployeerO open_nativestatusrrhourminutelocal_in check_in_utc check_out_utc attendances r5close_fingerprint_dayz*XenoAttendanceReport.close_fingerprint_days88M*//188E (C(CAGHI I**00= ..{;>QQ&&{37!899&&t,d|ve}AMNO O  "!!%%b)..0@t (:(:3(?@ f;;x0088 dTZ@[\]**3/77t7D  ))002 L (AMOP PXXo.335<<#;;$&>  !.#__66z7J7JK$oo77 8L8LM  rcj|jdjjdd|fdgddS)Nr&rKr9)r(r9FrHz check_in desc)limitorder)r-r.r@)r2rKs r5r/z*XenoAttendanceReport._xeno_open_attendancesAxx(--/66S+ .0I J?7, ,rcztjj|jz jdz S)Ng @)rr9r' total_seconds)rCs r5r0z/XenoAttendanceReport._xeno_attendance_age_hourss1!!((*Z-@-@@OOQTZZZrc |j}tj|jj |}|jt j j |jt jddd}|jd|j tjdiy)zClose a forgotten open check-in at 23:59:59 on its own calendar day (local tz) -- a conservative marker that doesn't bleed hours into the following day.;r(Nr$) rrr4r'r7rr5rgr6writer8)r2rCrr@local_end_of_days r5r2z&XenoAttendanceReport._xeno_close_stales "<< 3 34??C;;    % %hmmox}}RR7P QS+'7'B'B3'G'O'OW['O'\]^rch|j|}|sdddSd|j|tkDdS)aZWhether the employee currently has an open (no check_out) native hr.attendance record, and whether it's stale (see STALE_CHECKIN_HOURS) -- Odoo's own attendance_state has no per-day boundary at all, so this lets the My Attendance widget tell a genuinely still-open shift from one that was simply never checked out.F)openstaleT)r/r0r1r2rKrs r5get_native_checkin_statusz.XenoAttendanceReport.get_native_checkin_status s>((5!E2 2t'F'Fs'KNa'abbrc|j|}|sddiS|j|tkrtt d|j |ddiS)zvAuto-close a forgotten open check-in (re-verified stale server-side) so the employee can check in fresh today.closedFzAThis check-in isn't stale yet -- use the normal Check Out button.T)r/r0r1r rr2rRs r5close_stale_checkinz(XenoAttendanceReport.close_stale_checkinsi((5e$ $  * *3 /3F FASUV V s#$rc |jdj}dg} |+| jdd|D cgc] } t| c} f|r| jddt|f|j | } | sy| D cic]} | j | } } |j }tj||dtjdz }tj|||tjd z}|jd jj d d| jfd d |fd d|fg}i}|D]}|j}|j }tj|jj|}|jd}||f}|j!|ggd||dj|j#|j$stj|j$j|}||dj|j#|syi}|D],}|j!t|j'd|.|j)D]\\}}}|drt+|dnd}|drt-|dnd}|j'|}|E| j'|}|sZ|j.||j0dd}|j||||<d|zd|z}!} |j'| s|r||| <|j'|!r|s|||!<ycc} wcc} w)aNow that XENHR is frozen (employees can no longer reach it), check-ins happen two ways: the biometric scanners (still writing straight to HRSystem's vw_attendance_combined, untouched) and Odoo's own GPS/systray widget (hr.attendance, which HRSystem has no knowledge of at all). Without this, any native Odoo check-in silently never appears on Monthly/My/My Team Attendance -- mutates `rows` in place: fills a blank HRSystem cell from the native scan, or appends a whole new row for an employee HRSystem has nothing for this month (mirrors the auto-fill append pattern below). r=)r>z!=FNr>r;r9rHrcr&rKr'rbrrridsrKrr4r'r7rrr6r(rrrrrTr])"r2rurxryrdrrfrSrrCrErDe emp_by_coder range_fromrange_toattsby_dayrrrOr@rkey local_out rows_by_coderscansfirst_inlast_outrin_keyout_keys" r5rz2XenoAttendanceReport._xeno_merge_native_attendance"s>88M*//156  % MM/7W1A7WX Y  MM/c-6HI JOOF+  8AB1q++Q.B B  "&&tUA69K9KQR9SS $$T5$7(:L:LRS:TTxx(--/66 D)-- 0 z * h '8   $? C D'-lln ( "OT7U+0;s5;'DH,1%Ls5<(dH""4(C{!ood+&)fft(+!= C %( T"%/G1CGF776?x&F 777#'G ! (Q8X Cs M McNtj|dSt|S)NrP)_htmlescaper)r2ss r5_esczXenoAttendanceReport._escms!||!)B88Q88rcLtj|t\}}d|d|S)Nz background:z;color:)LEAVE_TYPE_COLORSrLEAVE_TYPE_COLOR_DEFAULT)rObginks r5_leave_chip_stylez&XenoAttendanceReport._leave_chip_styleqs$#''.FGC+-s33rcg}|r|jd|z|r|jd|z|rddj|zSdS)aInline style attr for an attendance pill: an optional leave-colour background and/or an explicit font colour (red for late/early, the leave ink otherwise). Empty when neither applies, so plain scans keep the stylesheet's default look.z background:%szcolor:%sz style="%s";rP)r?r)rqcolorpartss r5 _pill_stylez XenoAttendanceReport._pill_stylevsK  LL2- .  LLe+ ,27}sxx.?R?rc|yt|tr|ddSt|tjtjfr|j dSt|ddS)z.datetime.time / str / None -> 'HH:MM' or None.Nrz%H:%M) isinstancerrr6r)ts r5rzXenoAttendanceReport._fmtsY 9 a Ra5L a(--):):; <::g& &1vbqzrc|rt|dkry t|dddzt|ddzS#t$rYywxYw)z+'HH:MM' -> minutes since midnight, or None.rNrX<)lenr1 ValueError)hhmms r5rz XenoAttendanceReport._to_minutessOs4y1} tBQx=2%D1I6 6  s 3 ??crt|}tt||z dz}|dk(r|dzd}}d||fzS)zC9.0 -> '09:00', 14.5 -> '14:30' (part-time leave hours are floats).r}rHrz %02d:%02d)r1round) hour_floatrms r5_hour_float_to_hhmmz(XenoAttendanceReport._hour_float_to_hhmmsH  O zA~+, - 7q5!qAaV##rc|s||fS|jdxsd}|dk(ry|s0|dk(r'|jd|j|d|fS||fS|dd}t|dkDr|ddn|dd}|dk(r+|jd|j|dn|}||fS|dk(r|j||fS|d k(r||j|fS||fS) a{The (expected_start, expected_end) 'HH:MM' pair used to decide late-in / early-out for one day, adjusted for any leave: - no leave -> (shift start, shift end) - full_day -> (None, None) (no scan expected) - part_time (off hf..ht) -> due in at ht, out at shift end - first_half (morning off)-> due in at the afternoon session start - second_half (arvo off) -> in at shift start, out at morning end day_sessions is the sorted [(hour_from, hour_to), ...] for that weekday; when it's missing we fall back to plain shift start/end. rrNN part_timerrrH first_half second_half)rrr) r2rr day_sessionsrr morning_endafternoon_startess r5rz*XenoAttendanceReport._xeno_expected_windows!4< yy .J : {"uyy'B//d |3r'|=r%j)|3j)|=kDrd.};|4r'|>r%j)|4j)|>krd.}<|3 xr| xr| xr|. xr|/ xr |7 xr|)|#v}?dx}@}A|/r(|j|)|f}Bd/|Br d0|Bzndzx}@}An'|.r%|j|)|frd1|||)|fzx}@}A|5r=d2||2d3d4||2d5d6||0xsd7|2d8rd9||2d8zndd:}@|6r=d2||2d3d4||2d5d6||1xsd7|2d8rd9||2d8zndd:}A|rd;||)d<|d:nd}C|/rd=x}D}En.|.rd>x}D}En'|8r||7d,x}D}En|?r d?|4xsd@}E}Dn |3xsd@}D|4xsd@}E|;r|n|8r|:nd}F|.is_weekendrrrHrI%aholwkndrPz title="%s"z]%d%szInOutrlrXrevenoddrKrSrrrrrroffrr rprqrrrFTz title="Business Trip%s"z: z title="Day off: %s"z title="Edited by rsz on rtu — source: u—rru — "z data-ec="z " data-date="BTOffPresentz–editedautofillzz zrohasz rnzz5zz—No attendance records for this month.z7c>t|jdxsdS)NrnrPr )r"s r5z2XenoAttendanceReport.render_html.._sCo0F0L",Mr)ra selectedzrrPrHN)MONTHS)rYrrys r5rZz3XenoAttendanceReport.render_html..gs;# /e+VAE]C D#s#& c3<K|]}d||k(rdnd|fzyw)z rrPNrX)rYyrxs r5rZz3XenoAttendanceReport.render_html..ls2: /d+A6 7:src3NK|]}dj|d|dyw)z— All departments —z hr.departmentr])rGz z4zhr.employee.categoryz7zhr.jobaz
%d unrecognized employee code(s) seen in this period's raw scans that don't match any employee or known remap: %s. Their attendance is not shown above. Add a remap under Attendances → Configuration → Attendance Code Remaps if these are a known old/duplicate code, or check the device/employee record if not.
z, base_urlz
z
) My Attendancer)My Teamr)Monthly Attendanceru"Xenoptics HR · My Team AttendanceuXenoptics HR · My AttendanceuXenoptics HR · Attendancez %s - %s %dz%s — %s %dcsseyebrowtitle title_plainextra_filters_pre month_opts year_optsextra_filters_postlegendhead1head2bodynrowsndays export_qszyear=%d&month=%dz &employee=%sz&department=%sz &group=%sz &position=%sbanner edit_script)$rrrmrrrgrr?r-r.r enumeraterrboolrrorprrrrxrrraddrrxr@rTr]r _EDIT_SCRIPTr_PAGE_CSS)br2rxryrSrfr team_modemy_modecan_editr8rBr<rrurdrvrwrzr{r|r}r~rEREDrh1h2rrrrrklassrrrirrcremp_coderrrcellsrrraw_tinraw_toutrrtout in_edited out_editedr is_full_leavelv_bglv_inkin_late out_earlyrexp_end auto_filledin_title out_titlebt_label edit_attrsin_textout_textin_color out_colorin_clsout_clsrolate_clsemp_optsseenrOselr this_yearrleg dept_optsdept group_optscatjob_optsjobrrrrkind kind_htmlrrsb``` r5 render_htmlz XenoAttendanceReport.render_htmls{ $$T5-P&\4C Ev2E?DDFZZ\dOm 4DAqq5A:5BUU=)F15517R8HeeM*5gr:FEE+&1'2A6D#<<"5LE1dQh'] 9*dE1-==&qM7h+>c)W4(N: "#SEY]vce))AEE'G*;$<=99QUU8g+=%>?]]Hg#67(*r)}r)}'*,J:X !59 6 !""7J8 !%SR..vx&R]^MQ $U O &0AZ0O !%%$5$9$9f '?%AME6 ',+)CB}hmmD%;CCEFC)-)C)Cl&6&6s&;U*D&IwyT-=-=c-BTEUEUV_E`-`"&D,<, 3 4Qm 4^ KKJMQTUXW X NNu"MN RAquu_-34Dt| HHTN!.3}3E3M+SUC OO wQquu_/E-F$Q R  RWW#1b\## MM'').. GG:9i!mR8:: gg?=??QQ HH_-224;;Bf;M `D!.3}3ETWW3U+[]C   477CQRSWS\S\Q]^ _ `MM 882388:AA"FAS _C!,[1AS[1P+VXC   CFFCQRSVS[S[Q\] ^ _NN88H%**,33Bf3E ]C!'CK3svv;,F+BC OO#&&#qQTQYQY{[ \ ] ;~&$))N*C(DEF F?Glj(%;;R  " !# B! !" #RWWZ%8"''(:K "M  >OD) 2OD)HOD):C65<13 #dF519,=t%DD "i 1BD%II 4 w  U  ;    !2   *    !"4  c  RWWR[  RWWR[  BGGDM  SY  T +tUm;>KN]:QSU@M,}NV32 G! * f+ , ;-   rcLMNOddl}j||}|d|d}}|d|dc} M|jdxsi} |jdxsiN|jdxsi} |jd xsi} |jd xsi} fd }MNfd }tj}|j |d diOOj d}d}d}Ojdd|d}Ojdddddd}Ojdddddd}Ojdddddd}Ojddd}Ojdddd}Ojddd}Ojdd|dd}iLdTLOfd! }|jdddd"d#tdz fz||jddd$|jd%dd&d"}|j|dd'Ojd(did}tjD])\}\} }!|j||||| |!d|dz }+|j||d)|d|d|dz}"|j|"dd*||j|"dd+||j|"d%d,||j|"dd"}#i}$td|dzD]}%d-|%fz}&|&| v}'||%}(|'r|n|(r|n|})|j|"|#|"|#dzd.|%tj |%j#d/fz|)|j|"dz|#d0|)|j|"dz|#dzd1|)|#|$|%<|#d%z }#|j%ddd|j%ddd2|j%d%d%d3|j%d"|#dz d4|j'|"d%zd"|"d%z}*|D]}+|+jd5},t)|+jd6xsd7}-|+jd8xsd9dd:}.|+jd;xsdxsd}1|j|*d%|1|1r|n|td|dzD]}%d-|%fz}&||%|&| v}'}(|-|&f| v}2|-|&f| v}3| j|-|&f}4t+|4xr|4d?}5t+|4xr|4d@}6|5r|4d?n"j-|+jdA|&z}7|6r|4d@n"j-|+jdB|&z}8|(s|'s|2s|3sj/|,|-|&MNnd}9t+|9xr|9jdCdDk(}:dx};}<|9r tj|9dEt0\};}<|3rdF}=n|2rdG}=n|9r|;}=n |'rd}=n|(rd}=nd}=d}>|3rdH}>n|2rdI}>n |9s |'rdJ}>n|(rdK}>d x}?}@|(s|'s|2s|3s|:st)tj |%j3}Aj5|.|/|0j|A|9\}B}C|7r'Br%j7|7j7BkDrd}?|8r'Cr%j7|8j7Ckrd}@|?r|n|:r|}D@r|n|:r|}E||=Dt+|?xs |:xs|2xs|3}F||=Et+@xs |:xs|2xs|3}G|9r|9dEnd}H|3rdLx}I}Jn:|2rdMx}I}Jn3|:rHx}I}Jn,|7xsd7}I|8xsd7}JHrIrIdNHdOndPHz}IJrJdNHdOndPHz}J|5r IrdQIzndR}I|6r JrdQJzndR}J|$|%}K|j|*|KIF|j|*|KdzJG|*dz }*|s|j|*ddSOj9|j;d|j=S)UNrrurdrvrwr{r|r}r~rcTtj|jdk\Srrrs r5rz4XenoAttendanceReport.export_xlsx..is_weekendrrcRj|t||}|r|dSdS)Nr)rr)rrrrrwr|r2s r5 leave_forz3XenoAttendanceReport.export_xlsx..leave_fors1((XQ\]D#'4< 1T 1r in_memoryT Attendancez#142933r)bold font_size font_colorz#e7edefrHcentervcenter)rbg_colorborderalignvalignz#e3e9ebz#dff2e6)rrz#6d8791)rrrrr)rrrrFc||||f}|vr.ddd}|r||d<|r||d<|rd|d<j||<|S)NrHrrrrTr) add_format)rqrrraprops _fmt_cachewbs r5get_fmtz1XenoAttendanceReport.export_xlsx..get_fmtscz4(C*$#$x8(*E*%*4E,'$(E&M"$--"6 3c? "rr~zMonthly Attendance -- %s %dziMerged source: app/GPS punches + biometric machine (vw_attendance_combined -> sp_get_attendance_month_V3)rXuV* = HR-corrected value — source scan overridden, see Attendance Overrides for detailzLegend:rz Late / Earlyz Employee Codez Employee Namez Late (min)rIz%d (%s)rInOut rKrSrPrrrrrrnrorprqrr rrrz#cffafez#dbeafez#0e7490z#1d4ed8z#1f7a4dz#7d939brrz []z[%s]z%s **z%No attendance records for this month.)NNF) xlsxwriterrrioBytesIOWorkbook add_worksheetr  merge_rangerrMrorset_rowrrrgr set_column freeze_panesrrrrrprrrrseekread)Pr2rxryrSrfrrrurdrvr{r}r~rrrbufwsnavyrf_titlef_head f_head_wknd f_head_holf_empf_codef_late f_late_hasr  LEGEND_ROW legend_colrOrqrr HEADER_ROWcol day_first_colrrrrfmtrrrrrrrrorrrrrrrrrrrbase_bg base_fontrrrrrin_fontout_fontin_fmtout_fmtrrrrEr rwr|r sP``` @@@@r5 export_xlsxz XenoAttendanceReport.export_xlsxs$$T5-P&\4c)W4(N:]]Hg#67 !59 6 !""7J8 (1r)}tyySZIZA[7\*4:$))CGGHW^L^D_:` $SR..vx&R]^MQ $U O &0AZ0O "&%$5$9$9%-Ia$bME6'G'G#G'G'G"G  )I )I$- $- &++)CB}hmmD%;CCEFC)-)C)Cl&6&6s&;U*D&IwyT-=-=c-BTEUEUV_E`-`"&D,<,QWZ\Q\29fw.sG4 %(title_plain)s · Xenoptics HR
%(eyebrow)s

%(title)s

Merged source: app/GPS punches + biometric machine
vw_attendance_combined → sp_get_attendance_month_V3
%(banner)s
%(extra_filters_pre)s
%(extra_filters_post)s Export Excel
%(legend)s
%(head1)s%(head2)s%(body)s
EmployeeLate
(min)
%(nrows)s employees · %(ndays)s days · In = first scan, Out = last scan (MIN/MAX per day) Orange = late in · Red = early out · Green = holiday · Grey = weekend · Blue dot = HR-edited · "Present" = auto-filled (no scan required)
%(edit_script)sa)rrhtmlrjrloggingpytzrrodoorrrrodoo.exceptionsr getLoggerr8_loggerrrorpr1 AbstractModelrrrrrXrr5rGs ''% '  H % D ! 2w6//wt#;z# 'J4 r