Ai-4|SSKJr SSKJr SSKJr SSKJr SSKJ r SSK J r SSK J r SSKrS r"S S \5rg) ) BaseCommand)Stamp)Function)*calculate_daily_balances_for_user_and_date) WorkBalance) BalanceDetail)dateNcbU(dU$[U5RSS5n[U5S:Xa"[R"U5n[U5$[R"[U55n[U5$![ [ 4a Us$f=f![ [ 4a Us$f=f)z Normalize user_id to standard UUID format with dashes. Converts 'edd631c63c1848c681244f5c7c868801' to 'edd631c6-3c18-48c6-8124-4f5c7c868801' - )strreplacelenuuidUUID ValueErrorAttributeError)user_id user_id_cleanuuid_objs ND:\TimeStamps\worktimeservice\management\commands\debug_balance_calculation.pynormalize_user_idr s L((b1M =R yy/Hx= 99S\*8}N+ N   's# B)BBBB.-B.c$\rSrSrSrSrSrSrg)Command)z6Debug balance calculation for a specific user and datec\URS[SSS9 URS[SSS9 g)Nz --user-idTzUser ID to debug)typerequiredhelpz--datez!Date to debug (YYYY-MM-DD format)) add_argumentr)selfparsers r add_argumentsCommand.add_arguments,sB #   4  c h&USnUSn[U5nXS:wa;URRURR SUSUS355 [ [ URS55upgn[XgU5n URRS 5 URRS 5 URRS U35 URRS U 35 URRS 5 URRS 5 URRS5 URRS5 [RRXYS9RS5n U R5(aURRURR!SU R#5S355 U H8n URRSU R$SU R&35 M: O5URRURRS55 gURRS 5 URRS5 URRS5 [(RR+5V s0sHoR,U _M nn URRS[/U535 U GH4n UR1U R$5nU(aURRSU R$S35 URRSUR235 URRSUR435 URRSUR635 URRS[9USS 535 MURRURRS!U R$S"355 GM7 URRS 5 URRS#5 URRS5 [:RRXYS9R=5nU(GaURRS$5 URRS%UR>S&UR>S'- S(S)35 URRS*UR@S&UR@S'- S(S)35 URRS+URBS&URBS'- S(S)35 URRS%UR>S&UR>S'- S(S)35 O4URRURR S,55 URRS 5 URRS-5 URRS5 [EXY5nU(GaSURRURR!S.55 URRS/URF35 URRS0UR>S&UR>S'- S(S)35 URRS1UR@S&UR@S'- S(S)35 URRS2URBS&URBS'- S(S)35 URI5 URK5 URRS3UR>35 O5URRURR S455 URRS 5 URRS75 URRS5 S6S8K(J)n URTRW5 [:RRXYS9R=5nU(GazURK5 URRS95 URRS:URF35 URRS%UR>S&UR>S'- S(S)35 URRS*UR@S&UR@S'- S(S)35 URRS;URXS&URXS'- S(S)35 URRS+URBS&URBS'- S(S)35 URRSUR^35 URRS?UR`35 UR>S6:XajURRS 5 URRURRS@55 URRSA5 O4URRURR SB55 URRS 5 URRSC5 URRS5 [bRRUU S9ReSD5nUR5(GaURRURR!SUR#5SE355 UGH3nURf(aURfR2OSFnURRSGU35 URRSHUR>S&UR>S'- S(S)35 URRSIUR@S&UR@S'- S(S)35 URRSJURBS&URBS'- S(S)35 URRSKURZS&URZS'- S(S)35 GM6 O4URRURR SL55 URRS 5 URRSM5 URRS5 URi5nURkSNXY/5 URm5nU(GaSURRURR!SO55 URRS:US635 URRS%USPS&USPS'- S(S)35 URRS*USQS&USQS'- S(S)35 URRS+USRS&USRS'- S(S)35 URRS?USS35 USPS6:XaOURRS 5 URRURRST55 O4URRURRSU55 SSS5 URi5nURkSVXY/5 URm5S6nUS6:a9URRURR!SWUSX355 O4URRURR SY55 SSS5 URRS 5 URRS 5 URRSZ5 URRS 5 /nU R5(dURoS5 O}U Vs/sH-nUR1UR$5bM!UR$PM/ nnU(aURoS[U35 U(a!UR>S6:XaURoS\5 U(a\URRURRS]55 UH!nURRSU35 M# O4URRURR!S^55 URRS 5 URRS 5 g![aBn URRURRSUS355 Sn A gSn A ff=fs sn f![aon URRURRS5U 355 S6SK&nURRURO55 Sn A G NSn A ff=f!,(df  GNq=f!,(df  GN=fs snf)_Nrr zUser ID normalized: 'z' -> ''r zInvalid date format: z. Use YYYY-MM-DDzP================================================================================zDEBUGGING BALANCE CALCULATIONz User ID: zDate: r z1. CHECKING STAMPSzP--------------------------------------------------------------------------------)rr timezFound z stamp(s):z - z at zNo stamps found for this datez2. CHECKING FUNCTION OBJECTSzTotal functions in database: u ✓ :z - name: z - out: z - break_flag: z - with_reason: with_reasonFu ✗ z : Function NOT FOUND in databasez3. CHECKING CURRENT WORKBALANCEzCurrent balance:z - total_work_seconds: z (iz.2fz hours)z - regular_work_seconds: z - net_work_seconds: zNo WorkBalance record foundz4. RECALCULATING BALANCEzCalculation completedz - Returned WorkBalance ID: z! - Returned total_work_seconds: z# - Returned regular_work_seconds: z - Returned net_work_seconds: z, - After explicit save: total_work_seconds=z8Calculation returned None (no stamps or deleted balance)zCalculation failed: rz+5. CHECKING WORKBALANCE AFTER RECALCULATION) connectionzBalance after recalculation:z - ID: z - daily_break_seconds: z - overtime_seconds: z - flex_seconds: z - created_at: z - updated_at: uC⚠️ WARNING: total_work_seconds is still 0 after recalculation!zAThis suggests the calculation logic isn't finding work intervals.z/No WorkBalance record found after recalculationz!6. CHECKING BALANCEDETAIL RECORDSpaycodez BalanceDetail record(s):z No Paycodez - Paycode: z - total_work_seconds: z - regular_work_seconds: z - net_work_seconds: z - overtime_seconds: z,No BalanceDetail records found for this datez!7. VERIFYING DATABASE PERSISTENCEzSELECT id, total_work_seconds, regular_work_seconds, net_work_seconds, updated_at FROM workbalances WHERE user_id = %s AND date = %su.✓ WorkBalance found in database via raw SQL:uL⚠️ WARNING: Database shows total_work_seconds=0 even after calculation!u1✗ WorkBalance NOT found in database via raw SQLzQSELECT COUNT(*) FROM balancedetail_balancedetail WHERE user_id = %s AND date = %su ✓ Found z$ BalanceDetail record(s) in databaseu.⚠ No BalanceDetail records found in databaseSUMMARYzMissing Function objects: zABalance is 0.0 even though stamps exist - calculation logic issuez ISSUES FOUND:zNo obvious issues found)8rstdoutwritestyleWARNINGmapintsplitr ExceptionERRORrobjectsfilterorder_byexistsSUCCESScountstamp_functionr)rallfunction_ref_idrgetnameout break_flaggetattrrfirsttotal_work_secondsregular_work_secondsnet_work_secondsridsaverefresh_from_db traceback format_exc django.dbr, queries_logcleardaily_break_secondsovertime_seconds flex_seconds created_at updated_atrselect_relatedr-cursorexecutefetchoneappend)r"argsoptions user_id_rawdate_strryearmonthday check_dateestampsstampf function_mapfunc_objbalanceresultrQr, balance_afterbalance_detailsdetail paycode_namer\rowrAissuessmissing_functionsissues rhandleCommand.handle:si( 6?$K0  ! KK  djj003H U[\c[dde1fg h "3s(;< Dd3/J (# 9; IgY/0 F:,/0 (# " ./ (#%%g%GPPQWX ==?? KK  djj006&,,.9I1TU V !!D)=)=(>d5::,"OP  KK  djj../NO P  " 89 (#6>6F6F6J6J6LM6L))1,6L M 9#l:K9LMNE#''(<(<=H !!F5+?+?*@"BC !!L"@A !!K ~">? !!$6x7J7J6K"LM !!$7-Y^8_7`"ab !!$**"2"2VE KK  )9)9(:; < KK   89Y9Y8ZZ\]j]}]}AE^EFI]JJQR S KK   :=;];]:^^`anbDbDGKbKLOaPPWX Y KK   9-:[:[9\\^_l`A`ADH`HIL_MMTU V KK   6}7U7U6VVXYfYwYwz~Y~@CYDDKL M KK   6}7U7U6VVXYfYwYwz~Y~@CYDDKL M KK   2=3M3M2NbQ^QkQknrQrsvPww~ A KK   01I1I0JK L KK   01I1I0JK L//14 !!"% !!$**"2"23x"yz !!"ef KK  djj001bc d " => (#'//667  . #   ! ! # # KK  djj006/:O:O:Q9RRk1lm n)6v?X?X>YY[\b\u\ux|\|~A\BBI#JK !!$@A\A\@]]_`f`{`{CaCDG`HHO#PQ !!$ (#   F NNE%  //#C !!$**"4"45e"fg !!HSVH"56 !!$s1vhbQRVWZH[[b"cd !!$:3q6("SVd]SVDWW^"_` !!$4SVH"=>q6Q;KK%%b)KK%%djj&6&68F'GH !!$**"2"23f"gh'!,   F NNc% OO%a(Eqy !!$**"4"4z%Hl5m"no !!$**"4"45e"fg! " (# )$ (#}} MM9 :;A p6a\EUEUVWVfVfEg!1!1!16  p  :;L:MNO!A!AQ!F ab  KK  djj..? @ !!D.1  KK  djj001JK L " (#E  KK  djj..1FxjP`/ab c  6N` 6 KK  djj..1EaS/IJ K  KK  i224 5 5 6z! ,! *!qs~.AH;AJ E%AJ=4AJ.F3AL 9BALC4 AL/DAL/H; AJI8AJJAJJ ALJA$ALLALL ALL AL,N)__name__ __module__ __qualname____firstlineno__r r$ry__static_attributes__r{r&rrr)s CD  P$r&r)django.core.management.baser stamps.modelsrfunctions.modelsrworktimeservice.servicerworktimeservice.modelsrbalancedetail.modelsrdatetimer rrrr{r&rrs03%N..