PSA/server/seeds/dev/58_populate_standard_statuses.cjs
Hermes 284313f908
Some checks are pending
Bidi Control Character Guard / bidi-control-guard (push) Waiting to run
Circular Dependency Check / Check for new circular dependencies (push) Waiting to run
Citus Migration Smoke / Combined migrations on single-node Citus (push) Waiting to run
E2E Fresh Install Tests / fresh-install-e2e (push) Waiting to run
ext-v2 guardrails / Run ext-v2 guard and ESLint (push) Waiting to run
Integration Tests / Check for relevant changes (push) Waiting to run
Integration Tests / ${{ (github.event_name == 'schedule' || github.event.inputs.suite == 'full') && 'Full integration suite' || 'Tier-1 integration subset' }} (push) Blocked by required conditions
Mobile checks / Mobile lint + typecheck (push) Waiting to run
Mobile checks / Mobile unit tests (push) Waiting to run
Mobile checks / Mobile dependency audit (report) (push) Waiting to run
Mobile checks / Mobile reproducibility checks (push) Waiting to run
Secrets guard (env backups) / Ensure no tracked env backup files (push) Waiting to run
Temporal Readiness / fast-readiness (push) Waiting to run
Temporal Readiness / docker-parity (push) Waiting to run
TypeScript Type Check / Nx affected typecheck (push) Waiting to run
Unit Tests / Skipped-test budget (push) Waiting to run
Unit Tests / Nx affected unit tests (push) Waiting to run
Unit Tests / Server unit coverage (informational) (push) Waiting to run
Validate Tenant Management Schema / Check for relevant changes (push) Waiting to run
Validate Tenant Management Schema / Validate Tenant Management Schema (push) Blocked by required conditions
EE Workflows Build Guard / ee-workflows-build-guard (push) Waiting to run
Initial import of AlgaPSA codebase from PSA server
Excluded: .git, node_modules, secrets/, compose.env, assemblyscript tgz

Source: /opt/alga-psa on psa.joliet.tech
2026-06-22 16:12:17 -05:00

41 lines
2.0 KiB
JavaScript

/**
* @param { import("knex").Knex } knex
* @returns { Promise<void> }
*/
exports.seed = async function(knex) {
// standard_statuses is a global reference catalog; the
// make_standard_statuses_global migration populates it, so this seed only
// backfills if rows are missing.
await knex('standard_statuses')
.insert([
// Project statuses
{ name: 'Planned', item_type: 'project', display_order: 1 },
{ name: 'In Progress', item_type: 'project', display_order: 2 },
{ name: 'On Hold', item_type: 'project', display_order: 3 },
{ name: 'Completed', item_type: 'project', display_order: 4, is_closed: true },
{ name: 'Cancelled', item_type: 'project', display_order: 5, is_closed: true },
// Project task statuses (colors and icons are in the statuses table, not standard_statuses)
{ name: 'To Do', item_type: 'project_task', display_order: 1 },
{ name: 'In Progress', item_type: 'project_task', display_order: 2 },
{ name: 'In Review', item_type: 'project_task', display_order: 3 },
{ name: 'Done', item_type: 'project_task', display_order: 4, is_closed: true },
{ name: 'Blocked', item_type: 'project_task', display_order: 5 },
// Ticket statuses
{ name: 'Open', item_type: 'ticket', display_order: 1, is_default: true },
{ name: 'In Progress', item_type: 'ticket', display_order: 2 },
{ name: 'Waiting for Customer', item_type: 'ticket', display_order: 3 },
{ name: 'Resolved', item_type: 'ticket', display_order: 4, is_closed: true },
{ name: 'Closed', item_type: 'ticket', display_order: 5, is_closed: true },
// Interaction statuses
{ name: 'Planned', item_type: 'interaction', display_order: 1 },
{ name: 'In Progress', item_type: 'interaction', display_order: 2 },
{ name: 'Completed', item_type: 'interaction', display_order: 3, is_closed: true, is_default: true },
{ name: 'Cancelled', item_type: 'interaction', display_order: 4, is_closed: true }
])
.onConflict(['name', 'item_type'])
.ignore();
};