ge-aerospace/shopdb
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
124 Commits 1 Branch 0 Tags
master
Commit Graph

3 Commits

Author SHA1 Message Date
cproudlock
ed52086732 Add UDC reporting views and fix udcactivesessions table structure 
- Fixed udcactivesessions table to match actual production schema
- Added 11 new views for UDC reporting:
  - vwudctoolhealthbymachine: Tool health aggregated by machine
  - vwudctoolhealthbytool: Tool health by tool number
  - vwudcootdetail: OOT measurements detail
  - vwudctoolootdetail: Tool OOT detail
  - vwudcactivesessions: Active sessions with machine details
  - vwudcviolations: Violations with context
  - vwudcdailyproduction: Daily production summary
  - vwudcerrorsummary: Error summary by machine
  - vwudcconnectionsummary: Connection events summary
  - vwudcheaderupdates: Badge changes with context
  - vwudcclmfiles: CLM file import status

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2025-12-16 08:08:29 -05:00
cproudlock
8be7469e63 Add missing udcclmfiles table to UDC schema 
The file tracking table was missing from udctables.sql but existed
in the database. Required for clmparser.py incremental imports.

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>
 2025-12-16 07:58:49 -05:00
cproudlock
91fe5a6c66 Add UDC Performance Dashboard and Tool Health features 
- Add displayudc.asp with Dashboard tab containing:
  - Production Trend chart (daily parts)
  - OOT Rate Trend chart (daily OOT %)
  - Machine Utilization chart (top 10 by runtime hours)
  - Top Operators chart (top 10 by parts produced)
- Add tabs for drill-down: Live Activity, Operators, Machines, Parts,
  Quality/OOT, Timing, Activity Log, Tool Health, Uptime, IT Diagnostics

- Add Tool Health section to displaymachine.asp UDC tab:
  - Summary cards (tools monitored, measurements, OOT count)
  - Tool status table with health indicators
  - Recent OOT events display

- Add UDC API endpoints in api.asp:
  - getUDCPartRuns, getUDCOperatorStats, getUDCMachineStats, getUDCManualTiming

- Add sql/udctables.sql schema for UDC data storage

- Update docs/API.md with UDC endpoint documentation

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>
 2025-12-16 07:54:13 -05:00