e382a3246e
- Fix dualpath PC propagation direction (Equipment->PC) in api.asp and db_helpers.asp - Fix early exit in CreatePCMachineRelationship preventing propagation - Fix getShopfloorPCs to filter machinetypeid IN (33,34,35) instead of >= 33 - Fix getShopfloorPCs to show equipment numbers via GROUP_CONCAT subquery - Add detailed PropagateDP logging for dualpath debugging - Default "Show on Shopfloor Dashboard" checkbox to checked in addnotification.asp - Add USB label batch printing, single USB labels, and USB history pages - Add printer supplies tracking and toner report enhancements - Add uptime map visualization page - Add dashboard/lobby display SQL migration - Update CLAUDE.md with IIS 401 workaround documentation - Update TODO.md Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
110 lines
2.9 KiB
Markdown
110 lines
2.9 KiB
Markdown
# ShopDB - Future TODO List
|
|
|
|
**Created:** 2025-11-25
|
|
**Last Updated:** 2026-01-16
|
|
|
|
---
|
|
|
|
## High Priority
|
|
|
|
### Uncommitted Changes
|
|
- [ ] Review and commit pending changes:
|
|
- api.asp
|
|
- deviceidf.asp
|
|
- network_devices.asp
|
|
- includes/sql.asp.production
|
|
- sql/update_vw_network_devices_view.sql
|
|
|
|
---
|
|
|
|
## Medium Priority
|
|
|
|
### Code Quality
|
|
- [ ] Test remaining 108 ASP pages (15/123 tested)
|
|
- [ ] Add error logging to pages without it
|
|
- [ ] Review SQL injection protection across all pages
|
|
- [ ] Standardize error handling patterns
|
|
|
|
### Database Cleanup
|
|
- [ ] Drop deprecated Phase 2 tables after confirming stability:
|
|
- pc
|
|
- pc_network_interfaces
|
|
- pc_comm_config
|
|
- pc_dualpath_assignments
|
|
- [ ] Review and optimize database indexes
|
|
- [ ] Clean up orphaned records
|
|
|
|
### Documentation
|
|
- [ ] Update DEEP_DIVE_REPORT.md with Phase 2 changes
|
|
- [ ] Create API documentation for api.asp endpoints
|
|
- [ ] Document PowerShell data collection workflow
|
|
|
|
---
|
|
|
|
## Low Priority
|
|
|
|
### UI/UX Improvements
|
|
- [ ] Add bulk edit functionality for machines
|
|
- [ ] Improve network map performance with large datasets
|
|
- [ ] Add export to CSV/Excel for machine lists
|
|
- [ ] Implement dashboard widgets for quick stats
|
|
|
|
### Future Features
|
|
- [ ] Implement warranty expiration alerts
|
|
- [ ] Add compliance scan scheduling
|
|
- [ ] Create mobile-friendly views
|
|
- [ ] Add audit logging for changes
|
|
|
|
### Technical Debt
|
|
- [ ] Migrate remaining pages to use parameterized queries
|
|
- [ ] Consolidate duplicate code in display pages
|
|
- [ ] Update jQuery and Bootstrap versions
|
|
- [ ] Remove unused CSS/JS files
|
|
|
|
---
|
|
|
|
## Completed (Reference)
|
|
|
|
### December 2025
|
|
- [x] Fix displaysubnet.asp runtime error - Phase 2 schema update (Dec 29)
|
|
|
|
### November 2025
|
|
- [x] Phase 1: Schema changes (Nov 6)
|
|
- [x] Phase 2: PC migration (Nov 10)
|
|
- [x] Phase 3: Network devices - legacy tables dropped (Nov 25)
|
|
- [x] Fix 36+ API IIf() bugs (Nov 14)
|
|
- [x] Fix network_map.asp to show all device types (Nov 13)
|
|
- [x] Update vw_network_devices view (Nov 13)
|
|
- [x] Modernize printer pages (Nov 10)
|
|
- [x] Fix printer installer batch file (Nov 20)
|
|
- [x] Clean up obsolete docs and SQL files (Nov 25)
|
|
- [x] Drop legacy network device tables (Nov 25)
|
|
- [x] Remove v2 directory - 1.6GB freed (Nov 25)
|
|
|
|
### October 2025
|
|
- [x] Security audit and fixes (Oct 27)
|
|
- [x] Create comprehensive documentation
|
|
- [x] Set up Gitea for version control
|
|
- [x] Implement nested entity creation pattern
|
|
|
|
---
|
|
|
|
## Notes
|
|
|
|
### Before Starting Phase 3
|
|
1. Create full database backup
|
|
2. Verify all Phase 2 functionality stable
|
|
3. Schedule maintenance window
|
|
4. Test scripts on dev backup first
|
|
|
|
### Production Deployment Checklist
|
|
- [ ] Database backup created
|
|
- [ ] Rollback scripts tested
|
|
- [ ] All tests passing
|
|
- [ ] Documentation updated
|
|
- [ ] Stakeholders notified
|
|
|
|
---
|
|
|
|
**Maintained By:** Development Team
|