Locations

CREATE POLICY "work_orders_location_rbac" ON work_orders
  FOR SELECT
  USING (
    -- User can see work orders from their assigned location
    location_id = (SELECT location_id FROM users WHERE id = auth.uid())
    OR
    -- OR user has full access permission
    current_user_has_permission('work_orders:read')
  );

// List all locations (with optional filters)
listLocations({
  includeInactive?: boolean,
  limit?: number
}): Promise<Location[]>

// Get minimal location data for dropdowns
listLocationOptions(): Promise<LocationOption[]>

// Get a single location by ID
getLocationById(id: number): Promise<Location | null>

// Get a location by code
getLocationByCode(code: string): Promise<Location | null>

// Create a new location
createLocation(payload: LocationInsert): Promise<Location>

// Update an existing location
updateLocation(id: number, patch: LocationUpdate): Promise<Location>

// Toggle location active status
toggleLocationActive(id: number, nextActive: boolean): Promise<Location>

// Delete a location
deleteLocation(id: number): Promise<void>

import { listLocations } from '../services/locationService';

const activeLocations = await listLocations({
  includeInactive: false,
  limit: 500
});

import { createLocation } from '../services/locationService';

const newLocation = await createLocation({
  name: 'Warehouse A',
  code: 'WH-A',
  description: 'Primary storage facility',
  is_active: true
});

console.log('Created location:', newLocation.id);

CREATE TABLE locations (
  id SERIAL PRIMARY KEY,
  name TEXT NOT NULL,
  code TEXT NOT NULL UNIQUE,
  description TEXT,
  is_active BOOLEAN DEFAULT TRUE,
  created_at TIMESTAMPTZ DEFAULT NOW(),
  updated_at TIMESTAMPTZ,
  created_by UUID REFERENCES auth.users(id),
  updated_by UUID REFERENCES auth.users(id)
);

-- Users can view active locations
CREATE POLICY "locations_select_active" ON locations
  FOR SELECT
  USING (is_active = TRUE OR current_user_has_permission('locations:read'));

-- Full access users can insert/update/delete
CREATE POLICY "locations_insert_rbac" ON locations
  FOR INSERT
  WITH CHECK (current_user_has_permission('locations:full_access'));

CREATE POLICY "locations_update_rbac" ON locations
  FOR UPDATE
  USING (current_user_has_permission('locations:full_access'));

CREATE POLICY "locations_delete_rbac" ON locations
  FOR DELETE
  USING (current_user_has_permission('locations:delete'));