&j;dZddlmZddlZddlZddlmZmZddlm Z mZm Z ddl m Z ddl mZddlmZd d lmZed Zeej*Zed z d z ZdZddddddddZdZdZdZgdZgdZdZgdZ d2dZ!d3dZ"d4d Z#d5d!Z$d6d"Z%d7d#Z&d8d$Z'd9d%Z(d:d&Z)d;d'Z*dd+Z-d?d,Z.d@d-Z/d=dAd.Z0dBd/Z1Gd0d1Z2y)Cu2The LFCS timesheet — week maths and the rendered .xlsx. Sign-on / sign-off events are the presence record and this module never edits one. Hours are DERIVED here, every time, from the events as they stand. Rebuild is idempotent: same events in, same sheet out, so it is safe to run on every sign-off. Two files hold the same events, on purpose: /05 - Safety & Compliance/Sign-On/Attendance-Register.csv per JOB — the muster /Crew//Attendance.csv per WORKER — the timesheet The job register is the safety record. The worker index exists because a bloke can be on two jobs in one week and his timesheet is one sheet — without it, the second job's rebuild would overwrite the first job's hours. It is derivable from the job registers if it is ever lost. ) annotationsN) dataclassfield)datedatetime timedelta)BytesIO)Path)ZoneInfo)storagezAustralia/SydneyassetszLFCS-Timesheet.xlsx Timesheet )rr F33NzAttendance.csv) timestampjobnameeventlunchnotesourcedayroldnewreasonby)z0:000:30z1:00r*)MonTueWedThurFriSatSuncLtjdd|jS)Nz [^\w .-]+)resubstrip)r s !/opt/lfcs-signon/app/timesheet.py safe_namer82s 66,D ) / / 11c0|xsdj}|sytjd|}|r8t|j ddzt|j dzS tt t |dzS#t$rYywxYw)zW'0:30' -> 30. Blank or junk -> 0. Never raises: a bad cell must not lose a day's hours.r3rz^(\d+):(\d{1,2})$r <r)r6r4matchintgrouproundfloat ValueError)sms r7 parse_lunchrD6s bA  %q)A1771:#c!''!*o555qB'(( s)B BBc|dzd|dzdS)Nr;:02d)minutess r7 fmt_lunchrJDsm_Agl3/ 00r9cB|jdjdS)u27:12 AM — how the LFCS sheet is written by hand.%I:%M %p0)strftimelstrip)dts r7fmt_ampmrQHs ;;z " ) )# ..r9c tjdd|xsdjjj dd}dD](} t j ||jcSy#t$rY7wxYw)z['17:00' (what a phone's time picker gives) or '5:00 PM' (what a bloke types). None if junk.z\s+ r3.)z%H:%MrLz%I:%M%pN) r4r5r6upperreplacerstrptimetimerA)rBfmts r7 parse_hhmmrZMs~ vsQW"OO-335==c2FGA/ $$Q,113 3    s#A66 BBc tj|xsdj}|j|j t S|jt S#t$rYywxYw)Nr3tzinfo)r fromisoformatr6rAr]rVTZ astimezone)rBrPs r7parse_tsraXs`  # #QW"OO$5 6%'II$52::R: L2==;LL s'A A,+A,cnt|dzd}t|t|z dkr t|S|S)z@8.0 -> 8, 7.25 -> 7.25. The sheet's own cells are plain numbers.g& .>rg{Gzt?)r?absr=)hourshs r7numrf`s4 edlAASV_u,3q63!3r9c<|t|jz S)zMonday of the week holding d.days)rweekday)ds r7 week_startrlfs yaiik* **r9c |tdzS)zCThe LFCS sheet is labelled by its Friday: 'Week Ending 7 Aug 2026'.rrh)r)mondays r7 week_endingroks I1% %%r9cR|jd|jd|jS)NrT)yearmonthr%)fridays r7we_tagrtps%kk]!FLL>6::, 77r9cHt|dtt|dS)Nz Timesheet WE z.xlsx)r8rtro)workerrns r7 week_filenamerwts& vk&6I/J.K5 QQr9c`eZdZUded<ded<dZded<dZded<dZd ed <d Zd ed <dZded<e e Z ded<e e Z ded<dZ ded<e eZded<dZded<e e Zded<ed dZed dZed dZed dZed dZed dZy)!DayrstrlabelNdatetime | Nonestartfinishrr= lunch_minr@rdFboolon_now)default_factoryz list[str]jobsnotesis_todaydictadjusteddayworksdocketsc8dj|jS)Nz, )joinrselfs r7job_textz Day.job_textsyy##r9c8dj|jS)N; )rrrs r7 note_textz Day.note_textsyy$$r9cH|jrt|jSdSNr3)r}rQrs r7 start_textzDay.start_texts'+zzx #9r9r9cH|jrt|jSdSr)r~rQrs r7 finish_textzDay.finish_texts(, x $;;r9cd|jsd|jvrt|jSdS)Nr"r3)r~rrJrrs r7 lunch_textzDay.lunch_texts*.2[[Gt}}zbuild_week..s !r9keyronoffr"r;r)"rnowr_rangerry DAY_LABELSvaluesrrgetr6lowerappendr^rArrra setdefaultitemssortrrr}rrDr~rmax total_secondsrd_apply_adjustmentsr)eventsrnririrkper_dayadjustsrowevdwreftsrProwsr%workedopen_atrr#s r7 build_weekrs  !b!C`efg`h i[\FYA& &FYA5F,F ST (V V iD i [[]*VVsxxz) *8:GG<ggg$" + + - 3 3 5 > NN3     XXd00#''%.2FB1M1M1OPQ" wwv,"3353bjj0JJ%%c*  cggk2. /RWWYd* 2779b)00"c;/<2MMOQD2h n %#' GB'''"(b//1779B775>'R..0CGGFO)r002Ds#((*$CII-   &Tz? Gyy($& u SWWWb-A!BB &b7l*F"G % &  CJ c#-5 5F,,.5 8JJCP 7Q:tW%  { j$  s5O*1AO// O>=O>cTt|dD]} tj|jdxsdj }|j|}|sO|jdxsdj j }|jdxsdj }|dvrTt|}|stj||jt}|d k(r||_ n'||_ d |_n|d k(rt||_n|jd xsdj } |jd xsdj } dj#d| | fD|j$|<|j'D]t}|j$s|js|js*|j|jz j)dz } t+| |j dz z d|_vy#t $rYwxYw)uLatest correction per field per day wins, laid over the taps — which are left alone. A corrected day is recomputed straight off start/finish/lunch. If it held a split shift, that collapses to the one span the foreman has just said it was, which is the point of him correcting it. Presence is untouched: open_since() still reads only the on/off taps, because who was on site is the safety record and a foreman's discretion belongs in hours, not in the muster. c,|jdxsdS)Nrr3)r)rs r7rz$_apply_adjustments..saeeK.@.FBr9rr%r3rr')r}r~r\r}Fr"r)r(u — c3&K|] }|s| ywNrH).0rs r7 z%_apply_adjustments..s(Dq!(Dsrr;rN)sortedrr^rr6rArrZrcombinerVr_r}r~rrDrrrrrrrd) rirrwhenr%fldvaltstampedwhowhyrs r7rrsg#GHE %%swwu~';&B&B&DEDhhtn www%2,,.446wwu~#**, % %3A&&tQ/77r7BGg~# $ " G^',CM wwt}"))+wwx &B--/#LL(DS#J(DD S5E8{{}> <3   s6H H'&H'c&td|DS)Nc34K|]}|jywr)rd)rrks r7rzweek_hours..s%1qww%s)sumrhs r7 week_hoursrs %% %%r9c|xstjt}g}|D]}t|j dd}|s!|j |j k(sC|j ||j dxsdjjf|jdd}|D]\}}|dk(r||}|dk(sd}|S) uIs he on right now? Returns the time he signed on, or None. Today's events only — a bloke who forgot to sign off yesterday is not still on site this morning.rr3r!c |dSrrHrs r7rzopen_since..*s adr9rNrr) rrr_rarrrr6rr)rrtodaysrrrrs r7 open_sincer!s  !b!C FJ cggk2. / "'')sxxz) MM2 0 6B==?EEGH IJ KKNK#GB :'/G 5[G  Nr9c ddlm}ddlmddlm}|t }|t|ddd fd }t|}d |d <d |jd |d d<|dd<|dd<d}|D]} t| jj} | jdd| <| jr| jd| <| jr| j d| <| j"rt%| j&d| <| j(dk\r*t+| j(d| <|| j(z }dD].\} } | | j,vs|| | | j,| 0| j,r:|d| dj/d| j,j1D| j2r| j4d| <| j6xs | j4} | r| d| <| j8sdt:| <|r t+|ndt<<t?}|jA||jCS)!uFill the real LFCS form. Nothing is invented — a day with no events stays blank. An adjusted cell is shaded and carries a note saying who changed it and why, so the office can see at a glance that a number was corrected rather than tapped. r) load_workbook)Comment) PatternFillsolidFFE9A8)fgColorc@|}|_d|d|_y)Nz Adjusted: z LFCS Sign-On)fillcomment)cell_refrcradj_fillwss r7markzrender_xlsx..markEs( xLj.? r9zName: A3zDates: Week Ending rSz%b %YA7z%d/%m/%YC6E6rBCDErF))r}r)r~r)r"rrc30K|]\}}|d|yw)rSNrH)rkvs r7rzrender_xlsx..as#N41aqc1#J#NsGJYN)rrzrrzrNone)"openpyxlropenpyxl.commentsropenpyxl.stylesrTEMPLATESHEETror%DAY_ROWSrrjr}rr~rrrJrrdrfrrrrrrr DAYWORKS_COL TOTAL_CELLr savegetvalue)rvrnrirrwbrrstotalrkrrcelldescbufrrrs @@@r7 render_xlsxr7sB ')+ x B EB7H5H@  Fx BtH$VZZL&@BtH"BtH"BtH E + QVV^^% &)Qqc7 77,,B1#wK 88--B1#wK <<#AKK0B1#wK 77d?agg,B1#wK QWW EJ 4ICajj vaS\1::c?3 4 :: 1QC$))#N1::;K;K;M#NN O 66**B1#wK{{(ajj B1#wK ::'*B,s# $/+0$)SZdBzN )CGGCL <<>r9c:eZdZdZddZd d dZd dZd dZd dZy) CrewFilesu/Crew// — the worker's own events and his rendered weeks. Plain files on the Drive mount, same as everything else. Nothing here deletes or edits: the events file is append-only and the .xlsx is a rebuild of what the events already say. c$t||_yr)r root)rrs r7__init__zCrewFiles.__init__zs J r9cf|jdz t|z }|r|jdd|S)NCrewT)parentsexist_ok)rr8mkdir)rrvcreateps r7 worker_dirzCrewFiles.worker_dir}s2 II 6!2 2  GGD4G 0r9c~|j|tz }tj|t|t |Sr)r ATTENDANCEr append_csvATTENDANCE_HEADERrz)rrvrrs r7 append_eventzCrewFiles.append_events1 OOF #j 01/51v r9c|j|dtz }|jsgS|jdd5}t j |Dcgc] }t |c}cdddScc}w#1swYyxYw)NF)rr3zutf-8)newlineencoding)rr existsopencsv DictReaderr)rrvrfrs r7 list_eventszCrewFiles.list_eventssq OOF5O 1J >xxzI VVBV 1 8Q%(^^A%67DG7 8 87 8 8sA;A6*A;6A;;Bcv|j|t||z }|j|t|Sr)rrw write_bytesrz)rrvrndatars r7 write_weekzCrewFiles.write_weeks1 OOF #mFF&C C d1v r9N)rrz)T)rvrzrrrr )rvrzrrrrz)rvrzr list[dict])rvrzrnrr/bytesrrz) rrr__doc__rrr#r,r0rHr9r7rrss    8r9r)r rzrrz)rBrzrr=)rIr=rrz)rPrrrz)rBrz)rBrzrr|)rdr@)rkrrr)rnrrr)rsrrrz)rvrzrnrrrzr)rr1rnrrr|r list[Day])rizdict[date, Day]rr1rr)rir4rr@)rr1rr|rr|)rvrzrnrrir4rr2)3r3 __future__rr)r4 dataclassesrrrrrior pathlibr zoneinfor r3r r___file__parentHERErrrr rr r" LUNCH_CHOICES DEFAULT_LUNCHrr8rDrJrQrZrarfrlrortrwryrrrrrrrHr9r7r?s # (..  ! H~ (?2 2bRB2" <    C(  ? 2 1/ M4 + & 8R -B-B -B`DN'>T&,6xr9