c4ad415cc1
- Created README.md for Gitea project page - Added Gitea API token to CLAUDE.md for future access 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
71 lines
1.7 KiB
Markdown
71 lines
1.7 KiB
Markdown
# ShopDB
|
|
|
|
Manufacturing shop floor infrastructure management system for GE Aerospace. Tracks machines, PCs, printers, and network devices.
|
|
|
|
## Tech Stack
|
|
|
|
- **Backend:** Classic ASP (VBScript)
|
|
- **Database:** MySQL 5.6
|
|
- **Frontend:** Bootstrap 4.6, jQuery, DataTables
|
|
- **Server:** IIS on Windows
|
|
|
|
## Features
|
|
|
|
- Equipment inventory (CNC machines, lathes, mills, etc.)
|
|
- PC asset tracking with warranty monitoring
|
|
- Printer management with Zabbix integration
|
|
- Network device tracking (switches, access points, cameras)
|
|
- Knowledge base for troubleshooting
|
|
- Interactive floor maps
|
|
- REST API for PowerShell data collection
|
|
|
|
## Quick Start
|
|
|
|
```bash
|
|
# Start dev environment
|
|
~/start-dev-env.sh
|
|
|
|
# Access application
|
|
http://192.168.122.151:8080
|
|
|
|
# Run tests
|
|
./tests/test_forms.sh
|
|
|
|
# Connect to MySQL
|
|
docker exec -it dev-mysql mysql -u root -prootpassword shopdb
|
|
```
|
|
|
|
## Documentation
|
|
|
|
| Document | Purpose |
|
|
|----------|---------|
|
|
| [CLAUDE.md](CLAUDE.md) | AI assistant context |
|
|
| [docs/QUICK_REFERENCE.md](docs/QUICK_REFERENCE.md) | Cheat sheets, common queries |
|
|
| [docs/API.md](docs/API.md) | REST API documentation |
|
|
| [docs/STANDARDS.md](docs/STANDARDS.md) | Coding standards |
|
|
|
|
## Database Schema
|
|
|
|
```
|
|
machines table (unified)
|
|
├── Equipment (machinetypeid 1-15)
|
|
├── PCs (pctypeid IS NOT NULL)
|
|
└── Network Devices (machinetypeid 16-20)
|
|
|
|
printers table (separate)
|
|
communications table (network interfaces)
|
|
machinerelationships table (PC↔equipment links)
|
|
```
|
|
|
|
## Testing
|
|
|
|
```bash
|
|
./tests/test_forms.sh # 41 endpoint tests
|
|
```
|
|
|
|
Tests page loads, form submissions, and API endpoints.
|
|
|
|
## License
|
|
|
|
Internal use - GE Aerospace
|