Washita Valley · OCTG Pipe Yard Management
Phase 1 scaffold
Replaces the shared Excel workbook + paper routers that track OCTG pipe through the
yard for inspection, repair, and processing (spec §1).
Get started
The manager dashboard is live (List / Board / By-unit). Reference data,
users, jobs, routers, and visits are all manageable through the Django admin.
Open dashboard →
Admin
Built in this scaffold done
Django 5 + DRF project, split settings (base / dev / prod), HTTPS hardening for prod.
Custom User with the five yard roles; station/unit assignments; dashboard prefs.
Full data model — reference catalog, jobs, routers, tasks, station visits, lots,
forklift moves, daily logs, final inspection, documents (spec §6, §19.10).
Seed fixtures: 6 phases, 14 stations + their units, the router-form catalog
(Master, station/inspection, EMI, transport, RDE, 18 semi-premium), reject reasons.
Master-Router OCR — local Tesseract (self-contained, no cloud);
Scan & pre-fill reads the header fields for review (spec §7).
Manager dashboard — List / Board / By-unit views with Active/Completed
scope, phase-progress pips, RUSH/STUCK flags, idle-unit flags, and job detail (spec §19.3–4).
New Job wizard — scan & parse → create routers → route flow;
creates the draft job, StationVisits, initial forklift pull, and PDF compliance copies (spec §7, §19.2).
Operator Unit screen — receive queued work, log joints per day,
Complete & sign off; Daily's tab (spec §19.7).
Router PDFs — WeasyPrint Master/station router documents (spec §8).
Forklift Movement Sheets — moves log + e-signature sign-off that
marks the sheet Done (spec §19.6).
Reports — Jobs / Routers (type filter + CSV) / Daily's by machine + CSV (spec §19.8).
Complete Job → Final Sign-off — manager Final Inspection queue,
recall & reopen (spec §19.9).
Next upcoming
Excel import (spec §13); Phase-2 inspection-result detail (spec §16);
optional DRF API for integrations (spec §12).
Source of truth: octg_yard_app_spec.md (v89) &
octg_yard_prototype.html. Domain is TBD until deploy.