U Sh @sddlmZmZddlZddlmZddlmZmZmZee dZ e se ddZ e dd Z e d d Z e d d Ze ddZdedede de de Z ee ZddZedkredS)) create_enginetextN) load_dotenv)datetimedate timedelta DATABASE_URLDB_HOSTZ localhostDB_PORTZ5432DB_NAMEZ timesheet_dbDB_USERZpostgres DB_PASSWORDz postgresql://:@/c Cstdtf}td|td}dd|D}td|td|td}|}|d rtd |d td |d td |d|d r|d nd}t}|r||kr||j}td|dtd|d|td|td}| }|rtdtd|D]B\}} } } | rJ| nd } td|d| dd| dd| dq4|d d } t}| |krtdtd|dtd | td!|| jd"ntd#t}|r|d d n|}td$td%|td ||r|d }|td&||d'}|}|td&||d'}|}td(|td)|d*|d d+|d d,d-td.|d*|d d+|d d/d-td0|r2|d d |kr2td1td2td3td4|td5td6td7td8td9nB|rl|d d |krltd:td;td<td=ntd>W5QRXdS)?z)Check if the issue is with date filteringz%=== Checking Date-Related Issues === z"1. Getting actual developer IDs...z SELECT DISTINCT CAST(developer_id AS VARCHAR) as dev_id FROM activity_records WHERE developer_id IS NOT NULL ORDER BY 1 cSsg|] }|dqS)r).0rowrr./check_date_issue_fixed.py 'sz%check_date_issues..z Found developers: z" 2. Date range of activity data...z SELECT MIN(timestamp) as earliest, MAX(timestamp) as latest, COUNT(DISTINCT DATE(timestamp)) as unique_days FROM activity_records rz Earliest: z Latest: z Unique days: Nu* ⚠️ IMPORTANT: Latest data is from z days ago!z$ The dashboard defaults to today (z) but your data ends on z% 3. Activity count by recent dates...a~ SELECT DATE(timestamp) as activity_date, COUNT(*) as record_count, COUNT(DISTINCT CAST(developer_id AS VARCHAR)) as developers, SUM(duration) / 3600 as total_hours FROM activity_records GROUP BY DATE(timestamp) ORDER BY activity_date DESC LIMIT 10 z- Date | Records | Developers | Hoursz0 ---------------------------------------------z z | 7Z10z5.1fu ⚠️ PROBLEM FOUND!z - Dashboard is looking for: z (today)z - Your latest data is from: z - Gap: z daysz No data found!z/ 4. Comparing today vs latest date with data...z Today: z SELECT COUNT(*) as count, SUM(duration) / 3600 as hours FROM activity_records WHERE CAST(developer_id AS VARCHAR) = :dev_id AND DATE(timestamp) = :check_date )dev_idZ check_datez Developer: z - Today (z): z records, z.1f if today_row[1] else 0z hoursz - Latest (z.1f if latest_row[1] else 0z 5. SOLUTION:uL ✅ YOUR ISSUE: Dashboard is showing today's date but your data is older!z IMMEDIATE FIX:z> 1. In the dashboard, look for a date picker/calendar widgetz 2. Select the date: z< 3. You should immediately see hours and productivity dataz PERMANENT FIXES:z8 - Update your data sync to include today's activitieszA - Modify the dashboard to default to the latest available datez5 - Add a 'Show Latest Data' button to the dashboardu ✓ Data exists for todayz# If still showing 0 hours, check:z - Application name extractionz - Dashboard query logicu$ ❌ No data found in the database) printengineZconnectZexecuterZfetchonertodayZdaysZfetchall)ZconnresultZdev_idsrZ latest_daterZdays_agoZdatesZact_datecountZdevsZhoursZ hours_valZlatest_data_daterZ today_rowZ latest_rowrrrcheck_date_issuess    *    &&  r __main__)Z sqlalchemyrrosZdotenvrrrrgetenvrr r r r r rr __name__rrrrs"       "