Enhanced Locations: Hierarchy, Custom Fields, QR Labels #9

New Issue

tonym · 2026-01-15T03:00:46Z

tonym commented

2026-01-15 03:00:46 +00:00

Summary

Comprehensive improvements to the location system: hierarchical structure, custom fields, QR code labels, and drybox management.

Upstream Issues

https://github.com/Donkie/Spoolman/issues/763 - Custom fields for locations (temp/humidity sensors)
https://github.com/Donkie/Spoolman/issues/90 (8 comments) - Location labels for dryboxes

Features

1. Hierarchical Locations (Room → Shelf → Bin)

Allow nested location structure:

Office
  └── Shelf A
        ├── Bin 1
        └── Bin 2
  └── Shelf B
Garage
  └── Dry Box 1
  └── Dry Box 2

Implementation:

Add parent_id foreign key to Location model
UI: tree view or breadcrumb navigation
Spool can be assigned to any level (room, shelf, or bin)

2. Custom Fields for Locations

Track environmental data at location level (not per-spool):

Temperature
Humidity
Custom fields (like spools/filaments already have)

Use case: Sync Home Assistant sensors to dryer box locations.

Implementation:

Add LocationField table (like SpoolField, FilamentField)
API endpoints for custom field CRUD

3. QR Code Labels for Locations

Print QR labels for bins/shelves/dryboxes:

QR links to /location/show/{id} or filtered spool list
Template shows: location name, path (Office > Shelf A > Bin 1)
Scan to see all spools in that location

Implementation:

Add location label printing (similar to spool/filament labels)
Reuse existing QR label components
Location-specific template variables

4. Drybox Labels (Dynamic Content)

For single-spool locations like dryboxes:

Label on drybox shows CURRENT spool inside
Updates when spool is moved
Options:
- A) QR links to location → shows current spool
- B) E-ink display integration (future)
- C) Print new label when spool changes

5. Exclusive Location Validation

Mark locations as "single spool only" (drybox mode)
Prevent assigning multiple spools to same exclusive location
Warning if spool already assigned elsewhere

Database Changes

class Location(Base):
    id: int
    name: str
    parent_id: Optional[int]  # NEW - for hierarchy
    is_exclusive: bool = False  # NEW - single spool only
    # existing fields...

class LocationField(Base):  # NEW
    id: int
    location_id: int
    key: str
    value: str

UI Changes

Location list: show as tree or flat with breadcrumbs
Location create/edit: parent selector dropdown, exclusive checkbox
Location detail: show child locations, custom fields, current spool(s)
Print labels button on location pages

## Summary Comprehensive improvements to the location system: hierarchical structure, custom fields, QR code labels, and drybox management. ## Upstream Issues - https://github.com/Donkie/Spoolman/issues/763 - Custom fields for locations (temp/humidity sensors) - https://github.com/Donkie/Spoolman/issues/90 (8 comments) - Location labels for dryboxes ## Features ### 1. Hierarchical Locations (Room → Shelf → Bin) Allow nested location structure: ``` Office └── Shelf A ├── Bin 1 └── Bin 2 └── Shelf B Garage └── Dry Box 1 └── Dry Box 2 ``` **Implementation:** - Add `parent_id` foreign key to Location model - UI: tree view or breadcrumb navigation - Spool can be assigned to any level (room, shelf, or bin) ### 2. Custom Fields for Locations Track environmental data at location level (not per-spool): - Temperature - Humidity - Custom fields (like spools/filaments already have) **Use case:** Sync Home Assistant sensors to dryer box locations. **Implementation:** - Add LocationField table (like SpoolField, FilamentField) - API endpoints for custom field CRUD ### 3. QR Code Labels for Locations Print QR labels for bins/shelves/dryboxes: - QR links to `/location/show/{id}` or filtered spool list - Template shows: location name, path (Office > Shelf A > Bin 1) - Scan to see all spools in that location **Implementation:** - Add location label printing (similar to spool/filament labels) - Reuse existing QR label components - Location-specific template variables ### 4. Drybox Labels (Dynamic Content) For single-spool locations like dryboxes: - Label on drybox shows CURRENT spool inside - Updates when spool is moved - Options: - A) QR links to location → shows current spool - B) E-ink display integration (future) - C) Print new label when spool changes ### 5. Exclusive Location Validation - Mark locations as "single spool only" (drybox mode) - Prevent assigning multiple spools to same exclusive location - Warning if spool already assigned elsewhere ## Database Changes ```python class Location(Base): id: int name: str parent_id: Optional[int] # NEW - for hierarchy is_exclusive: bool = False # NEW - single spool only # existing fields... class LocationField(Base): # NEW id: int location_id: int key: str value: str ``` ## UI Changes - Location list: show as tree or flat with breadcrumbs - Location create/edit: parent selector dropdown, exclusive checkbox - Location detail: show child locations, custom fields, current spool(s) - Print labels button on location pages

tonym changed title from ~~Hierarchical Location Support (Room/Bin)~~ to Enhanced Locations: Hierarchy, Custom Fields, QR Labels

2026-01-16 04:28:49 +00:00

tonym referenced this issue

2026-01-16 04:51:22 +00:00

Printer Management & Parts Inventory #30

tonym referenced this issue

2026-01-16 05:23:20 +00:00

Project-Based Spool Grouping #46

tonym referenced this issue from a commit

2026-01-22 03:40:08 +00:00

feat: Add batch operations, dashboard redesign, hierarchical locations

tonym referenced this issue from a commit