U h?& @s4ddlmZmZmZmZddlmZddlmZddlZddl Z ddl m Z e j ej ej ej eddlmZe eeddd Zeeed d eed d eddeddedddZedsededeeZedddZedddZeddd Zed!d"d#Zed$d%d&Zed'd(d)Z ed*kr0eed+d,Z!ed-d."d/kZ#ed0e!d1ed2e!ed3e#ed4ed5d6ed7d8ed9ed:ed;e!dedej$e#e!d?d@dS)A)Flaskjsonifyrequestrender_template)CORS)datetimeN) load_dotenv)ActivityAnalyzerz../frontend/templatesz../frontend/static)Ztemplate_folderZ static_folderZDB_HOSTZ localhostZDB_PORTi8ZDB_NAMEZ timesheet_dbZDB_USERZpostgresZ DB_PASSWORD)hostportdatabaseuserpasswordrz>WARNING: Database password not found in environment variables!z8Please create a .env file with DB_PASSWORD=your_password/cCstdS)Nzdashboard.html)rrr./dashboard_api_fixed.pyindex%srz"/api/dashboard/c Cst|}tjd}|rTzt|d}WqXtk rPtddidfYSXnd}zt ||}t|WSt k r}z@t d|d|d dl }|tdt|id fWYSd}~XYnXdS) z+Get dashboard data for a specific developerdatez%Y-%m-%derrorz#Invalid date format. Use YYYY-MM-DDiNzDashboard error for developer '': r)strrargsgetrstrptimer ValueErrorranalyzerget_dashboard_data Exceptionprint traceback print_exc) developer_idZdate_strrdataer!rrrr)s    rz,/api/productivity//weeklyc Cst|}zddlm}t}||dd}g}g}g}|}||krt|||\}} t|| } || d|| ||dd7}q@t ||dWSt k r} z@t d|d | dd l } | t d t| id fWYSd } ~ XYnXd S) zGet weekly productivity trendr) timedelta)Zdaysz%a)datesscoresz)Weekly productivity error for developer 'rNrr)rrr&ZnowrrZget_developer_activitiesZcalculate_productivity_scoreappendstrftimerrr r!r") r#r&Zend_dateZ start_dateZ weekly_datar)r*Z current_dateZ activitiesZtotal_durationZscorer%r!rrrget_weekly_productivityAs8     r-z/api/developersc Csd}zt}|v}td|||}tdt|dg}|D]8}t|d}d|}|||dtd|qPW5QRXW5QRXt |WSt k r}z4td |dd l } | ztd t}|}|d g}|D]2}|drt|d}||d|dqtd t|dt |W5QRW5QRWWYrSQRXW5QRXWnXt k r} z8td| t ddt| idfWY WYSd } ~ XYnXW5d }~XYnXd S)z;Get list of all developers - Fixed for VARCHAR developer_idaR SELECT DISTINCT CAST(developer_id AS VARCHAR) as id, CAST(developer_id AS VARCHAR) as display_name FROM activity_records WHERE developer_id IS NOT NULL AND CAST(developer_id AS VARCHAR) != '' AND LENGTH(TRIM(CAST(developer_id AS VARCHAR))) > 0 ORDER BY CAST(developer_id AS VARCHAR) zExecuting developers query...zFound z developersrz Developer )idnamez - Developer: zError fetching developers: NzTrying fallback query...z SELECT DISTINCT developer_id::text FROM activity_records WHERE developer_id IS NOT NULL ORDER BY 1 zFallback query found zFallback query also failed: rzDatabase error: r) rget_connectioncursorr executefetchalllenrr+rrr!r") queryconnr1rowsZ developersrowZdev_idr/r%r!Ze2rrrget_developersdsP      $        >r9z/api/test-connectionc Cszt}|}|d|d}|d|d}|ddd|D}|d|}td||||r|dnd d W5QRW5QRWSQRXW5QRXWnLtk r}z,dd l}td t || d dfWYSd }~XYnXd S)zTest database connectionzSELECT version()rz%SELECT COUNT(*) FROM activity_recordsz SELECT DISTINCT CAST(developer_id AS VARCHAR) as dev_id FROM activity_records WHERE developer_id IS NOT NULL ORDER BY 1 LIMIT 5 cSsg|]}t|dqS)r)r).0r8rrr sz#test_connection..z SELECT data_type FROM information_schema.columns WHERE table_name = 'activity_records' AND column_name = 'developer_id' Z connectedunknown)statusZdatabase_versionZactivity_records_countZsample_developer_idsZdeveloper_id_typeNr)r=rr!r) rr0r1r2Zfetchoner3rrr!r format_exc)r6r1versioncountZ sample_devsZ data_typer%r!rrrtest_connections6        6rAz$/api/sample-data/c Cst|}zd}t}|}|||f|}g}|D]B}|t|d|d|d|drr|dnd|ddq@t|t ||d W5QRW5QRWSQRXW5QRXWnJt k r}z*ddl }tt|| d d fWYSd}~XYnXdS) z/Get sample data for a developer to debug issuesz SELECT CAST(developer_id AS VARCHAR), app, title, timestamp, duration FROM activity_records WHERE CAST(developer_id AS VARCHAR) = %s ORDER BY timestamp DESC LIMIT 10 rr(N)r#apptitleZ timestampZduration)r#Z sample_countr$)rr!r) rrr0r1r2r3r+Z isoformatrr4rr!r>) r#r5r6r1r7r$r8r%r!rrrget_sample_datas:    6rG__main__ZAPI_PORTiZ DEBUG_MODETruetruez&Starting dashboard API server on port z...z Dashboard URL: http://localhost:z Debug mode: z Database: r @r :r z API Endpoints:z Dashboard: http://localhost:z$ Test Connection: http://localhost:z$ Developers List: http://localhost:zF IMPORTANT: This version handles VARCHAR developer_id fields correctlyz0.0.0.0)debugr r )%ZflaskrrrrZ flask_corsrrossysZdotenvrpathr+dirnameabspath__file__Zbackend.activity_analyzer_fixedr __name__rEgetenvintZ DB_CONFIGr rZrouterrr-r9rArGr lowerrMrunrrrrs`   $         " C . ' &