search

WSDOT / HATS

Highway Activity Tracking System Issue Tracker
6 stars 0 forks source link

Feature Activities - Update Work Ops To Current Fiscal Year Button #1321

Closed jhudsonWA closed 4 years ago

jhudsonWA commented 5 years ago

Work Ops for activities are assigned with a work op id at the time they are assigned. The issue is each fiscal year the work ops are resetup so the id's change. But the ids for the activity are never updated so they point to the old work ops (even though the codes are the same).

Add a button that runs a script that will rematch the activities work op codes to the current fiscal year.

Something like this:

Update ad Set WorkOperationId = cfwo.MaintenanceWorkOperationId From ActivityDefinition ad inner join MaintenanceWorkOperation wo on wo.MaintenanceWorkOperationId = WorkOperationId inner join MaintenanceWorkOperation cfwo on cfwo.WorkOperationCode = wo.WorkOperationCode where cfwo.WorkOperationFiscalYear = @currentfiscalyear

jhudsonWA commented 5 years ago

I've run this script once in prod, so they are matched up for now, but there should a button so admins can do it once a year once the work ops are setup.

joeschmit commented 5 years ago

Is this still on the radar? Not sure its still needed? http://hatsprod.wsdot.loc/Maintenance/management/activities/Admin/MaintenanceWorkOperations

jhudsonWA commented 4 years ago

Assigning to Vince so it will be ready for 2020.

VinceRanger commented 4 years ago

I've attached a document explaining the implementation for this issue. It's currently in QA. Please review the document and let me know if you have any comments or recommendations.

MaintenanceWorkOperations.docx

VinceRanger commented 4 years ago

Sorry about that. Didn't mean to close it. Still waiting to review with Oai.

sheppamwsdot commented 4 years ago

This is probably complete.