c@i)+^SSKJr SSKJr SSKJrJrJr SSKJr SSK J r "SS\5r g) ) BaseCommand) connection)datetimedate timedelta)Stamp) WorkBalancec$\rSrSrSrSrSrSrg)CommandzGDebug why monthly_balance endpoint shows 00:00 even after recalculationcURS[SSS9 URS[SSS9 URS[SS 9 URS [S S 9 g) Nz --user-idTzUser ID to debug)typerequiredhelpz--datezDate to check (YYYY-MM-DD)z --start-datez!Start date for range (YYYY-MM-DD))rrz --end-datezEnd date for range (YYYY-MM-DD)) add_argumentstr)selfparsers AD:\TimeStamps\stamps\management\commands\debug_monthly_balance.py add_argumentsCommand.add_arguments s^KcDGYZH3D`aN;^_Ls9Z[c!^USnUSn[R"US5R5nURR S5 URR S5 URR S5 URR SU35 URR S U35 URR S 5 URR S 5 URR S 5 [RR[U5US 9R5nU(GaYURR UR RS55 URR SUR35 URR SUR35 URR SUR35 URR SUR SUR S- SS35 URR SUR"SUR"S- SS35 URR SUR$SUR$S- SS35 URR SUR&SUR&S- SS35 URR SUR(SUR(S- SS35 URR SUR*SUR*S- SS35 URR SUR,35 URR SUR.35 O4URR UR RS55 URR S 5 URR S5 URR S 5 [0R2"5nUR5S [U5U/5 UR75nU(aURR UR RS!55 UR8V s/sHoS"PM n n [;U 5H9upU [=U5:dMURR S#U S$X35 M; O4URR UR RS%55 SSS5 URR S 5 URR S&5 URR S 5 [RR[U5US 9R5n U (a^URR UR RS'55 URR S(U R35 GOcURR UR RS)55 [RRUUS 9R5n U (aURR UR R?S*55 URR S(U R35 URR S+[AU R535 URR S,U RS-35 URR S.[AU535 URR S/US-35 URR S 5 URR S05 URR S 5 [RR[U5S19RCS5SS2nURE5(aURR S35 UHhnURU:XaS4OS5nURR S6US7URS8[AUR5S9US8[AU5S:3 5 Mj O4URR UR R?S;55 URR S 5 URR S<5 URR S 5 URGS=5(agURGS>5(aQ[R"US=S5R5n[R"US>S5R5nOUnUn[RR[U5UU/S?9RCS5nURR S@USAUSBUSC35 URR SDURI535 URE5(aYURR SE5 UH8nURR S#URSFUR"35 M: UmTU::Ga[KU4SGjU5S5n[RR[U5TS 9R5nTU:XGaURR SHTSI35 U(aBURR UR RSJUR"355 O4URR UR RSK55 U(aBURR UR RSLUR"355 O4URR UR RSM55 [RL"T[RNRQ55[SSNSO9-R5mTU::aGMURR S 5 URR SP5 URR S 5 [TRRX5S 9RCSQ5nURR SRURI535 UH8nURR S#URVSSURP35 M: URR S 5 URR ST5 URR S 5 URR SU[0RXSV35 URR SW[0RZ35 URR S 5 URR S5 URR SX5 URR S5 U(GaPUR"S":aURR UR RSY55 URR UR R?SZ55 URR S[5 URR S\5 URR S]5 URR S^5 URR S_5 gURR UR R?S`55 URR Sa5 gURR UR RS55 URR Sb5 g![a; URR UR RSUS355 gf=fs sn f!,(df  G N>=f)cNuser_idrz%Y-%m-%dzInvalid date format: z. Use YYYY-MM-DDzP================================================================================z"DEBUGGING MONTHLY_BALANCE ENDPOINTz User ID: zDate: z#1. CHECKING WORKBALANCE IN DATABASEzP--------------------------------------------------------------------------------)rru✓ WorkBalance record foundz - ID: z - Date: z - User ID: z - regular_work_seconds: z (iz.2fz hours)z - total_work_seconds: z - daily_break_seconds: z - net_work_seconds: z - overtime_seconds: z - flex_seconds: z - created_at: z - updated_at: u✗ No WorkBalance record foundz2. CHECKING RAW SQL QUERYz;SELECT * FROM workbalances WHERE user_id = %s AND date = %su✓ Record found via raw SQLrz - z: u✗ No record found via raw SQLz83. CHECKING QUERY WITH STR() CONVERSION (as in endpoint)u!✓ Query with str(user_id) worksz - Found: u(✗ Query with str(user_id) returns Noneu"⚠ But query without str() works!z - user_id type in DB: z - user_id value in DB: ''z - user_id type in query: z - user_id value in query: 'z 4. CHECKING DATE FORMAT MATCHING)r z'Sample WorkBalance dates for this user:u✓u✗z  z (type: z) vs )z*No WorkBalance records found for this userz"5. SIMULATING ENDPOINT QUERY LOGIC start_dateend_date)r date__rangezQueryset filter: user_id=str('z'), date__range=[z, ]zQueryset count: zRecords in queryset:z: total_work_seconds=c3J># UHoRT:XdMUv M g7f)N)r).0wb current_dates r !Command.handle..s$[-B77lCZRR-s# #z For date :u6 ✓ Old method (next()): Found - total_work_seconds=u$ ✗ Old method (next()): Not foundu< ✓ New method (direct query): Found - total_work_seconds=u* ✗ New method (direct query): Not found)daysz 6. CHECKING STAMPS FOR THIS DATEtimezStamps found: z at z7. CHECKING DATABASE STATEz Database: NAMEzIn transaction: SUMMARYu+✓ WorkBalance exists with non-zero valuesu/⚠ But endpoint shows 00:00 - possible causes:z 1. Query cache issuez 2. Date format mismatchz+ 3. User ID type mismatch (str vs non-str)z 4. Transaction not committedz" 5. Different database connectionu'⚠ WorkBalance exists but values are 0z5 This suggests the calculation didn't work correctlyz? This suggests the calculation didn't create/update the record).rstrptimer ValueErrorstdoutwritestyleERRORr objectsfilterrfirstSUCCESSidrregular_work_secondstotal_work_secondsdaily_break_secondsnet_work_secondsovertime_seconds flex_seconds created_at updated_atrcursorexecutefetchone description enumeratelenWARNINGrorder_byexistsgetcountnextcombineminr-rrstamp_function settings_dictin_atomic_block)rargsoptionsrcheck_date_str check_date work_balancerCrowcolcolumnsiwork_balance_strwork_balance_no_str all_balancesr& date_matchstart_date_obj end_date_obj work_balanceswork_balance_oldwork_balance_newstampsstampr's @rhandleCommand.handles )$  !**>:FKKMJ (# >? (# IgY/0 F:,/0 " ?@ (#"**11L2  %'   KK  djj001OP Q KK  (9: ; KK   <+<+<*=> ? KK   l.B.B-CD E KK   :<;\;\:]]_`laBaBEIaIJM`NNUV W KK   89X9X8YY[\h\{\{C]CDG\HHOP Q KK   9,:Z:Z9[[]^j^~^~BF_FGJ^KKRS T KK   6|7T7T6UUWXdXuXux|X|~AXBBIJ K KK   6|7T7T6UUWXdXuXux|X|~AXBBIJ K KK   2<3L3L2MRP\PiPilpPpqtOuu|} ~ KK   01H1H0IJ K KK   01H1H0IJ K KK  djj../PQ R " 56 (#    F NNMWz* //#C !!$**"4"45S"TU-3-?-?@-?cq6-?@'0FA3s8| ))DRx*@A1 !!$**"2"23T"UV! " TU (#&..55L6  %'   KK  djj001TU V KK   ,<,?,?+@A B KK  djj../YZ ["-"5"5"<"<#=#eg # !!$**"4"45Y"Z[ !!K0C0F0F/G"HI !!$?R?Z?Z>[[\"]^ !!$?W "OP !!$A'!"LM " <= (#"**11#g,1GPPQWXY\Z\]    KK  G H"&(gg&;U  !!Bzl!BGG9HT"'']OSXYcXddlmqr|m}l~~#AB# KK  djj001]^ _ " >? (# ;;| $ $Z)@)@%..w|/DjQVVXN#,,WZ-@*MRRTL(N%L$++22L'63  (6   :7)CTUcTddfgsfttuvw ,]-@-@-B,CDE    ! ! KK  4 5# !!D 1FrG\G\F]"^_$& l*#$[-$[]ab  +2299G ! : eg  z) !!K ~Q"?@#KK%%djj&8&8;qsCsVsVrW:X'YZKK%%djj&6&69]&_`#KK%%djj&8&8;wyIy\y\x]:^'_`KK%%djj&6&69c&ef$,,\8<<;L;L;NOR[abRcciikL-l*. " <= (#%%g%GPPQWX N6<<>*:;<E KK  U%9%9$:$uzzlK L " 67 (# Jz'?'?'G&HIJ ,Z-G-G,HIJ " (# )$ (# ..2 !!$**"4"45b"cd !!$**"4"45f"gh !!":; !!"=> !!"OP !!"BC !!"FG !!$**"4"45^"_` !!"YZ KK  djj../PQ R KK  _ `s  KK  djj..1F~FVVf/gh i  `A! sE%A@.A7AA;7AA6AA;(AAA;@.AAA3A2AA3A6AA;A; AB N)__name__ __module__ __qualname____firstlineno__rrrh__static_attributes__rjrrr r s TD\ arr N) django.core.management.baser django.dbrrrr stamps.modelsrworktimeservice.modelsr r rjrrrts'3 ...HakHar