U [Mh@sVdZddlmZmZmZddlmZddlZddlmZm Z ddZ e dkrRe dS) z> Fix Working Hours Calculation - Show realistic working hours )datetimetimezone timedelta) SessionLocalN)funcand_c Cst}zztdtdtdddtjd}|jddddd}|jd d d d d}td |td |t j  t t j j dkt j j|kt j j|kt j j}tdt|i}d}|D]}|j}|j} || 7}||krddid||<||dd7<||d| 7<|j} | ||dkrRd||d| <||d| | 7<qtd|dddttdtdd} t|ddddD]\}} | d} | d}|dkrd }| }d!}n"|d"krd }| }d#}n|d$krd%}| d&}d'}n|d(krd}d}| dD]|\} }||7}d)| krf||d*7}nNd+| ksd,| kr||7}n(d-| kr||d*7}n ||d.7}q:|dkrt||d nd/}d0}n,|d1krd2}| d3}d4}nd5}| d6}d7}| |7} |d}t|d8|dd9|dd:|d;td<|t| dd=dddd>d}|D]*\} }|d}td?| d8|dd@qttq| d}| |d }tdAtdBtdC|ddd@tdD|dd@tdE|dFdGttdHtdItdJtdK|dd@tdLt|dMdd@|dMkrftdNntdOttdPtdQtdRtdStdTtdUWnBtk r}z"tdV|dd>l}|W5d>}~XYnXW5|Xd>S)Wz(Show corrected working hours calculationu%🔧 FIXING WORKING HOURS CALCULATIONz<============================================================i )Ztzinfor)ZhourZminutesecondZ microsecond;i?Bu📅 Analyzing z(----------------------------------------zTotal activities: )count total_timeappsrrrz Total time: iz.2fz hoursu)📊 REALISTIC WORKING HOURS CALCULATION:z2--------------------------------------------------cSs |ddS)Nrrxrr./fix_working_hours.pyFz#fix_working_hours..T)keyreverseZ developmentdzAll coding/development workdatabasezAll database workZbrowserUg333333?z;Most browser time is work-related (docs, research, testing)otherZlockappg?ZdatagripZpostmanZsnippingg?2z9Smart analysis of apps (LockApp=90%, DataGrip=100%, etc.)system g?z&Minimal work-related system activitiesg?zConservative estimatez: u h total → z h working (z%)z Reason: cSs|dS)NrrrrrrrrNu • hu🎯 FINAL RESULTS:z------------------------------u📊 Total Time: u💼 Working Time: u📈 Productivity Rate: z.1f%u🔍 COMPARISON:z--------------------z?Current app calculation: ~6.74h (from RealisticHoursCalculator)zManual calculation: z Difference: g(\@u0✅ Manual calculation is MORE generous (better)u*⚠️ Manual calculation is LESS generousu💡 RECOMMENDATION:z>For a developer, 7+ hours on September 13th is very realistic!z- 2.51h pure codingz&- 2.72h research/documentation/testingz(- 1.51h breaks/tools during work sessionu= 6.74h total working time ✅u ❌ Error: )rcloseprintrrZutcreplacedateZquerymodelsZActivityRecordfilterrZuser_idZ timestampZorder_byZascalllencategorydurationZapplication_namesorteditemslowerintupperabs Exception traceback print_exc)ZdbZ target_dateZ start_of_dayZ end_of_dayZ activitiesZ category_datarZactivityr,r-ZappZ working_timedataZcat_timeZ cat_hoursZwork_percentageZ work_timereasonZtotal_other_timeZapp_timeZ work_hoursZtop_appsZ app_hoursZtotal_working_hoursZproductivity_rateer5rrrfix_working_hours s              ("      r:__main__) __doc__rrrrrr(Z sqlalchemyrrr:__name__rrrrs )