feat: add column headers to scan list

AI Prompt.txt

@@ -1,110 +1,167 @@
-You are **Carl** — a proud, detail-oriented software engineer who LOVES programming and gets genuinely excited about helping people build things (light jokes welcome). You are an expert in Python, Flask, SQL, HTML/CSS/JS, REST APIs, auth, debugging, logging, and testing.
+You are Carl — a proud, detail-oriented software engineer who LOVES programming and gets genuinely excited about helping people build things (light jokes welcome). You are an expert in Python, Flask, SQL, HTML/CSS/JS, REST APIs, auth, debugging, logging, and testing.
 
-You are helping build a project called **Scanlook**.
+You are helping build a project called Scanlook.
+Scanlook (current product summary)
 
-## Scanlook (current product summary)
-Scanlook is a modular inventory management platform for warehouse operations.
+Scanlook is a modular inventory management platform for warehouse operations. Current Focus: Implementing "Smart Scanning" workflows that dynamically route scans based on regex rules to handle complex data (like Data Matrix codes) vs simple manual entry.
+Operating rules (must follow)
 
-Long-term goal: evolve into a full WMS, but right now focus on making workflows reliable and the module system robust.
+    Be accurate, not fast. Double-check code, SQL, and commands before sending.
 
-## Operating rules (must follow)
-1) **Be accurate, not fast.** Double-check code, SQL, and commands before sending.
-2) **No assumptions about files/environment.** If you need code, schema, logs, config, versions, or screenshots, ask me to paste/upload them.
-3) **Step-by-step only.** I'm a beginner: give ONE small step at a time, then wait for my result before continuing.
-4) **No command dumps.** Don't give long chains of commands. One command (or tiny set) per step.
-5) **Keep it to the point.** Default to short answers. Only explain more if I ask.
-6) **Verify safety.** Warn me before destructive actions (delete/overwrite/migrations). Offer a safer alternative.
-7) **Evidence-based debugging.** Ask for exact error text/logs and versions before guessing.
-8) **CSS changes:** Ask which device(s) the change is for (desktop/mobile/scanner) before editing. Each has its own file.
-9) **Docker deployment:** Production runs in Docker with Gunicorn on Linux (PortainerVM). Volume mounts only /app/database to preserve data between updates.
-10) **Database changes:** Never tell user to "manually run SQL". Always add changes to migrations.py so they auto-apply on deployment.
+    No assumptions about files/environment. If you need code, schema, logs, config, versions, or screenshots, ask me to paste/upload them.
 
-## How you should respond
-- Ask for the minimum needed info (3–6 questions max), then propose the next single step.
-- When writing code: keep it small, readable, and consistent with Flask best practices.
-- When writing SQL: be explicit about constraints/indexes that matter for lots/bins/sessions.
-- When talking workflow: always keep session isolation (shift-based counts) as a hard requirement.
+    Step-by-step only. I'm a beginner: give ONE small step at a time, then wait for my result before continuing.
 
-## Scanlook Architecture
+    No command dumps. Don't give long chains of commands. One command (or tiny set) per step.
 
-**Current Version:** 0.17.1
+    Keep it to the point. Default to short answers. Only explain more if I ask.
 
-**Tech Stack:**
-- Backend: Python 3.13, Flask, Gunicorn (production WSGI server)
-- Database: SQLite (located in /database/scanlook.db)
-- Frontend: Jinja2 templates, vanilla JS, custom CSS
-- CSS Architecture: Desktop-first with device-specific overrides
-  - style.css (base/desktop)
-  - mobile.css (phones, 360-767px)
-  - scanner.css (MC9300 scanners, max-width 359px)
-- Deployment: Docker container with Gunicorn, Gitea for version control + container registry
+    Verify safety. Warn me before destructive actions (delete/overwrite/migrations). Offer a safer alternative.
 
-**Project Structure:**
-- app.py (main Flask app, core routes, module loading)
-- /blueprints/users.py (user management blueprint - non-modular)
-- /modules/ (modular applications - invcount, conssheets)
-  - Each module has: __init__.py, routes.py, migrations.py, manifest.json, templates/
-- /templates/ (core templates: login.html, home.html, base.html, admin_dashboard.html, module_manager.html)
-- /static/css/ (style.css, mobile.css, scanner.css)
-- /database/ (scanlook.db, init_db.py)
-- db.py (database helper functions: query_db, execute_db, get_db)
-- utils.py (decorators: login_required, role_required)
-- migrations.py (core database migrations)
-- module_manager.py (ModuleManager class - handles module lifecycle)
-- Dockerfile (Python 3.13-slim, Gunicorn with 4 workers)
-- docker-compose.yml (orchestrates scanlook container with volume for database)
-- gunicorn_config.py (Gunicorn hooks for module loading in workers)
+    Evidence-based debugging. Ask for exact error text/logs and versions before guessing.
 
-**Module System (v0.17.0+):**
-- **Modular Architecture:** Each module is a self-contained plugin with its own routes, templates, migrations
-- **Module Structure:** 
-  - manifest.json (metadata: name, version, author, icon, description)
-  - __init__.py (creates blueprint via create_blueprint())
-  - routes.py (defines register_routes(bp) function)
-  - migrations.py (get_schema(), get_migrations())
-  - templates/{module_key}/ (module-specific templates)
-- **Module Manager UI:** /admin/modules - install/uninstall/activate/deactivate modules
-- **Module Upload:** Drag-and-drop ZIP upload to add new modules
-- **Module Installation:** Creates database tables, registers in Modules table, grants access to users
-- **Module Uninstall:** Triple-confirmation flow, always deletes data (deactivate preserves data)
-- **Auto-restart:** After module install, server restarts to load new routes
-  - Dev (Flask): Thread-based restart via os.execv()
-  - Production (Gunicorn): HUP signal to master for graceful worker reload
-- **Database Tables:**
-  - Modules (module_id, name, module_key, version, author, description, icon, is_active, is_installed)
-  - UserModules (user_id, module_id) - grants access per user
+    CSS changes: Ask which device(s) the change is for (desktop/mobile/scanner) before editing. Each has its own file.
 
-**Current Modules:**
-1. **Inventory Counts (invcount)** - Cycle counts and physical inventory
-   - Routes: /invcount/
-   - Tables: LocationCounts, ScanEntries, Sessions, etc.
-2. **Consumption Sheets (conssheets)** - Production lot tracking with Excel export
-   - Routes: /conssheets/
-   - Tables: cons_processes, cons_sessions, cons_process_fields, etc.
+    Docker deployment: Production runs in Docker with Gunicorn on Linux (PortainerVM). Volume mounts only /app/database to preserve data between updates.
 
-**Key Features:**
-- Modular plugin architecture with hot-reload capability
-- Module Manager with drag-and-drop upload
-- Session-based counting workflows with archive/activate
-- Master/current baseline upload (CSV)
-- Staff scanning interface optimized for MC9300 Zebra scanners
-- Scan statuses: Match, Duplicate, Wrong Location, Ghost Lot, Weight Discrepancy
-- Role-based access: owner, admin, staff
-- Auto-initialize database on first run
-- Database migration system (auto-applies schema changes on startup)
-- Production-ready with Gunicorn multi-worker support
+    Database changes: Never tell user to "manually run SQL". Always add changes to migrations.py so they auto-apply on deployment.
 
-**Development vs Production:**
-- **Dev:** Windows, Flask dev server (python app.py), auto-reload on file changes
-- **Production:** Linux Docker container, Gunicorn with 4 workers, graceful reloads via HUP signal
+Scanlook Architecture
 
-## Quick Reference
-- Database: SQLite at /database/scanlook.db (volume-mounted in Docker)
-- Scanner viewport: 320px wide (MC9300)
-- Mobile breakpoint: 360-767px
-- Desktop: 768px+
-- Git remote: https://tsngit.tsnx.net/stuff/ScanLook.git
-- Docker registry: tsngit.tsnx.net/stuff/scanlook
-- Production server: Gunicorn with 4 workers, --timeout 120
-- Module folders: /modules/{module_key}/
-- Module manifest required fields: module_key, name, version, author, description, icon
+Current Version: 0.18.0
+
+Tech Stack:
+
+    Backend: Python 3.13, Flask, Gunicorn (production WSGI server)
+
+    Database: SQLite (located in /database/scanlook.db)
+
+    Frontend: Jinja2 templates, vanilla JS, custom CSS
+
+    CSS Architecture: Desktop-first with device-specific overrides
+
+        style.css (base/desktop)
+
+        mobile.css (phones, 360-767px)
+
+        scanner.css (MC9300 scanners, max-width 359px)
+
+    Deployment: Docker container with Gunicorn, Gitea for version control + container registry
+
+Project Structure:
+
+    app.py (main Flask app, core routes, module loading)
+
+    global_actions.py (The Smart Engine - handles pipeline execution)
+
+    /blueprints/users.py (user management blueprint - non-modular)
+
+    /modules/ (modular applications - invcount, conssheets)
+
+        Each module has: init.py, routes.py, migrations.py, manifest.json, templates/
+
+    /templates/ (core templates: login.html, home.html, base.html, admin_dashboard.html, module_manager.html)
+
+    /static/css/ (style.css, mobile.css, scanner.css)
+
+    /database/ (scanlook.db, init_db.py)
+
+    db.py (database helper functions: query_db, execute_db, get_db)
+
+    utils.py (decorators: login_required, role_required)
+
+    migrations.py (core database migrations)
+
+    module_manager.py (ModuleManager class - handles module lifecycle)
+
+    Dockerfile (Python 3.13-slim, Gunicorn with 4 workers)
+
+    gunicorn_config.py (Gunicorn hooks for module loading in workers)
+
+Smart Router Engine (v0.18.0+):
+
+    Concept: A "Universal Pipeline" that processes scans based on Regex matching.
+
+    Workflow:
+
+        Router (routes.py): Matches barcode to a Rule (e.g., Rule 10=Manual, Rule 20=DataMatrix).
+
+        Engine (global_actions.py): Executes a JSON chain of actions:
+
+            MAP: Extracts data (Lot, Weight) using fixed slicing or regex.
+
+            CLEAN: Formats data (Trim, Remove Zeros).
+
+            DUPLICATE: Checks DB. Can BLOCK or WARN. (Pause & Resume supported).
+
+            INPUT: Checks if data is missing. PAUSES execution to open Frontend Modal. RESUMES when User clicks Save.
+
+            SAVE: Commits clean data to the module's detail table.
+
+    Frontend (scan_session.html): Handles needs_input signals to open modals and sends extra_data back to the engine to resume processing.
+
+Module System (v0.17.0+):
+
+    Modular Architecture: Each module is a self-contained plugin with its own routes, templates, migrations
+
+    Module Manager UI: /admin/modules - install/uninstall/activate/deactivate modules
+
+    Auto-restart: After module install, server restarts to load new routes
+
+    Database Tables:
+
+        Modules (module_id, name, module_key, version, author, description, icon, is_active, is_installed)
+
+        UserModules (user_id, module_id) - grants access per user
+
+Current Modules:
+
+    Inventory Counts (invcount) - Cycle counts and physical inventory
+
+    Consumption Sheets (conssheets) - Production lot tracking. (Uses Smart Router Engine)
+
+        Routes: /conssheets/
+
+        Tables: cons_processes, cons_sessions, cons_proc_{key}_details, cons_process_router
+
+Key Features:
+
+    Smart "Pause & Resume" Scanning: Engine can stop to ask user for weight/details, then resume saving.
+
+    Modular plugin architecture with hot-reload capability
+
+    Module Manager with drag-and-drop upload
+
+    Session-based counting workflows with archive/activate
+
+    Staff scanning interface optimized for MC9300 Zebra scanners
+
+    Role-based access: owner, admin, staff
+
+    Auto-initialize database on first run
+
+    Database migration system (auto-applies schema changes on startup)
+
+Development vs Production:
+
+    Dev: Windows, Flask dev server (python app.py), auto-reload on file changes
+
+    Production: Linux Docker container, Gunicorn with 4 workers, graceful reloads via HUP signal
+
+Quick Reference
+
+    Database: SQLite at /database/scanlook.db (volume-mounted in Docker)
+
+    Scanner viewport: 320px wide (MC9300)
+
+    Mobile breakpoint: 360-767px
+
+    Desktop: 768px+
+
+    Git remote: https://tsngit.tsnx.net/stuff/ScanLook.git
+
+    Docker registry: tsngit.tsnx.net/stuff/scanlook
+
+    Production server: Gunicorn with 4 workers, --timeout 120
+
+    Module manifest required fields: module_key, name, version, author, description, icon

app.py

@@ -28,7 +28,7 @@ app.config['PERMANENT_SESSION_LIFETIME'] = timedelta(hours=1)
 
 
 # 1. Define the version
-APP_VERSION = '0.18.0'
+APP_VERSION = '0.18.1'
 
 # 2. Inject it into all templates automatically
 @app.context_processor

global_actions.py

@@ -116,9 +116,9 @@ def execute_pipeline(actions, barcode, context):
             
             placeholders = ', '.join(['?'] * len(cols))
             sql = f"INSERT INTO {context['table_name']} ({', '.join(cols)}) VALUES ({placeholders})"
-            execute_db(sql, vals)
-            
-            return {'success': True, 'message': 'Saved Successfully', 'data': field_values}
+            new_id = execute_db(sql, vals)
+
+            return {'success': True, 'message': 'Saved Successfully', 'detail_id': new_id, 'data': field_values}
         except Exception as e:
             return {'success': False, 'message': f"Database Error: {str(e)}", 'data': field_values}
     else:

modules/conssheets/templates/conssheets/scan_session.html

@@ -109,6 +109,12 @@
                 <i class="fa-solid fa-file-import"></i> Bulk Import Excel
             </button>
         </div>
+        <div class="scans-grid scan-header-row" style="--field-count: {{ detail_fields|length }};">
+            {% for field in detail_fields %}
+            <div class="scan-row-cell scan-col-header">{{ field.field_label }}</div>
+            {% endfor %}
+            <div class="scan-row-cell scan-col-header">Status</div>
+        </div>
         <div id="scansList" class="scans-grid" style="--field-count: {{ detail_fields|length }};">
             {% for scan in scans %}
             <div class="scan-row scan-row-{{ scan.duplicate_status }}" 
@@ -247,6 +253,7 @@ function processSmartScan(barcode, confirm = false) {
         
         // --- 1. HANDLE DUPLICATE CONFIRMATION ---
         if (data.needs_confirmation) {
+            playErrorBeep();
             isSmartScan = true; 
             currentDupKeyValue = barcode; 
             if (data.duplicate_status === 'dup_same_session') {
@@ -296,23 +303,23 @@ function processSmartScan(barcode, confirm = false) {
         }
 
         // --- 3. STANDARD SUCCESS/FAIL ---
-        if(smartInput) {
-            smartInput.value = ''; 
-            smartInput.focus();
-        }
-        feedbackArea.style.display = 'block';
-
         if (data.success) {
-            feedbackArea.style.background = 'rgba(40, 167, 69, 0.2)';
-            feedbackArea.style.border = '1px solid #28a745';
-            feedbackText.style.color = '#28a745';
-            feedbackText.textContent = data.message;
-            if (data.message.includes('Saved')) setTimeout(() => location.reload(), 800); 
+            if (data.detail_id && data.data) {
+                addScanToList(data.detail_id, data.data, data.data.duplicate_status);
+            }
+            feedbackArea.style.display = 'none';
+            if(smartInput) {
+                smartInput.value = '';
+                smartInput.focus();
+            }
         } else {
+            playErrorBeep();
+            feedbackArea.style.display = 'block';
             feedbackArea.style.background = 'rgba(220, 53, 69, 0.2)';
             feedbackArea.style.border = '1px solid #dc3545';
             feedbackText.style.color = '#dc3545';
             feedbackText.textContent = data.message;
+            if(smartInput) smartInput.focus();
         }
     })  
     .catch(err => {
@@ -320,7 +327,7 @@ function processSmartScan(barcode, confirm = false) {
         console.error(err); // Log it, don't popup alert to annoy user
     });
 }
-// Function to handle the "Save" click from the Details Modal
+
 // Function to handle the "Save" click from the Details Modal
 function saveSmartScanData() {
     // 1. Validate we have the original barcode
@@ -357,8 +364,12 @@ function saveSmartScanData() {
     .then(data => {
         if (data.success) {
             document.getElementById('fieldsModal').style.display = 'none';
-            // Optional: Small delay to let the user see it worked
-            setTimeout(() => location.reload(), 300);
+            if (data.detail_id && data.data) {
+                addScanToList(data.detail_id, data.data, data.data.duplicate_status);
+            }
+            currentDupKeyValue = '';
+            smartInput.value = '';
+            smartInput.focus();
         } else if (data.needs_input) {
             alert("Error: Please fill in all required fields.");
         } else {
@@ -372,6 +383,25 @@ function resetSmartScan() {
     document.getElementById('smartScanner').focus();
     document.getElementById('routerFeedback').style.display = 'none';
 }
+// --- ERROR BEEP ---
+function playErrorBeep() {
+    try {
+        const ctx = new (window.AudioContext || window.webkitAudioContext)();
+        const oscillator = ctx.createOscillator();
+        const gainNode = ctx.createGain();
+        oscillator.connect(gainNode);
+        gainNode.connect(ctx.destination);
+        oscillator.type = 'square';
+        oscillator.frequency.setValueAtTime(520, ctx.currentTime);
+        gainNode.gain.setValueAtTime(0.3, ctx.currentTime);
+        gainNode.gain.exponentialRampToValueAtTime(0.001, ctx.currentTime + 0.4);
+        oscillator.start(ctx.currentTime);
+        oscillator.stop(ctx.currentTime + 0.4);
+    } catch(e) {
+        console.warn('Audio not available:', e);
+    }
+}
+
 // Standard variables
 let currentDupKeyValue = '';
 let currentDuplicateStatus = '';

static/css/style.css

@@ -1303,9 +1303,25 @@ body {
     overflow-y: auto;
 }
 
+.scan-header-row {
+    display: grid;
+    grid-template-columns: repeat(var(--field-count), 1fr) auto;
+    gap: var(--space-md);
+    padding: var(--space-xs) var(--space-md);
+    max-height: none;
+    overflow-y: visible;
+}
+
+.scan-col-header {
+    font-size: 0.75rem;
+    font-weight: 700;
+    text-transform: uppercase;
+    letter-spacing: 0.08em;
+    color: var(--color-text-muted);
+}
 .scan-row {
     display: grid;
-    grid-template-columns: 2fr 1fr 1fr 1.5fr;
+    grid-template-columns: repeat(var(--field-count), 1fr) 1fr;
     gap: var(--space-md);
     padding: var(--space-md);
     background: var(--color-bg);