Technicians (Assignees)

// Paginated list with filters
getAssigneesPaginated({
  page: number,
  pageSize: number,
  search?: string,
  section?: AssigneeSection | 'TODOS',
  includeInactive?: boolean
}): Promise<{ data: Assignee[]; count: number }>

// Get all assignees (for dropdowns)
getAllAssignees(): Promise<Assignee[]>

// Get only active assignees
getActiveAssignees(): Promise<Assignee[]>

// Group assignees by section
groupBySection(list: Assignee[]): Record<AssigneeSection, Assignee[]>

// Create an assignee
createAssignee(input: AssigneeInput): Promise<number>

// Update an assignee
updateAssignee(id: number, input: Partial<AssigneeInput>): Promise<void>

// Toggle active status
setAssigneeActive(id: number, isActive: boolean): Promise<void>
bulkSetAssigneeActive(ids: number[], isActive: boolean): Promise<void>

// Delete an assignee
deleteAssignee(id: number): Promise<void>

import { getActiveAssignees } from '../services/assigneeService';

const technicians = await getActiveAssignees();

const dropdown = technicians.map(t => ({
  value: t.id,
  label: `${t.name} ${t.last_name}`.trim(),
}));

import { createAssignee } from '../services/assigneeService';

const newTechId = await createAssignee({
  name: 'Juan',
  last_name: 'Pérez',
  section: 'Internos',
  email: 'juan.perez@example.com',
  phone: '+1-809-555-1234',
  user_id: null, // Not linked to a user
  is_active: true,
});

console.log('Created technician ID:', newTechId);

CREATE TABLE assignees (
  id SERIAL PRIMARY KEY,
  name TEXT NOT NULL,
  last_name TEXT NOT NULL,
  section TEXT NOT NULL CHECK (section IN ('SIN ASIGNAR', 'Internos', 'TERCEROS', 'OTROS')),
  email TEXT,
  phone TEXT,
  user_id UUID REFERENCES auth.users(id),
  is_active BOOLEAN DEFAULT TRUE,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

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

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

CREATE POLICY "assignees_update_rbac" ON assignees
  FOR UPDATE
  USING (current_user_has_permission('assignees:full_access'));

CREATE POLICY "assignees_delete_rbac" ON assignees
  FOR DELETE
  USING (current_user_has_permission('assignees:delete'));

import { formatAssigneeFullName } from '../services/assigneeService';

const assignee = { id: 1, name: 'Juan', last_name: 'Pérez', ... };
console.log(formatAssigneeFullName(assignee)); // "Juan Pérez"

import { assigneeInitials } from '../services/assigneeService';

const assignee = { id: 1, name: 'Juan', last_name: 'Pérez', ... };
console.log(assigneeInitials(assignee)); // "JP"

import { getActiveAssignees, groupBySection } from '../services/assigneeService';

const assignees = await getActiveAssignees();
const grouped = groupBySection(assignees);

console.log(grouped['Internos']); // Array of internal technicians
console.log(grouped['TERCEROS']); // Array of third-party contractors