jtricerolph
2e0592eb90
Full wage cost reporting app — weekly/monthly views, rolling 12-week/12-month history, budget management, Workforce API sync with SSE backfill, net sales via forecasting public API, department filter, CSV export. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
45 lines
1.6 KiB
JavaScript
45 lines
1.6 KiB
JavaScript
// Run against the auth DB to register the wages app and its capabilities.
|
|
// Usage: DATABASE_URL=postgresql://... node seed-app.js
|
|
|
|
import pg from 'pg'
|
|
const { Pool } = pg
|
|
|
|
const pool = new Pool({ connectionString: process.env.DATABASE_URL })
|
|
|
|
await pool.query(`
|
|
INSERT INTO apps (slug, name, description, base_path, icon, theme_color, category, internal_host, internal_port)
|
|
VALUES (
|
|
'wages',
|
|
'Wage Costs',
|
|
'Live wage cost reporting — weekly, monthly, and rolling history vs budget and net sales',
|
|
'/wages',
|
|
'DollarSign',
|
|
'#065f46',
|
|
'Finance',
|
|
'10.10.10.124',
|
|
3080
|
|
)
|
|
ON CONFLICT (slug) DO UPDATE SET
|
|
name = EXCLUDED.name,
|
|
description = EXCLUDED.description,
|
|
base_path = EXCLUDED.base_path,
|
|
icon = EXCLUDED.icon,
|
|
theme_color = EXCLUDED.theme_color,
|
|
category = EXCLUDED.category,
|
|
internal_host = EXCLUDED.internal_host,
|
|
internal_port = EXCLUDED.internal_port;
|
|
|
|
INSERT INTO app_capabilities (app_id, slug, name, description, sort_order)
|
|
SELECT a.id, c.slug, c.name, c.description, c.sort_order
|
|
FROM apps a, (VALUES
|
|
('view', 'View Reports', 'View all wage cost reports (weekly, monthly, rolling)', 1),
|
|
('budget', 'Edit Budgets', 'Set monthly wage budget targets', 2),
|
|
('sync', 'Manual Sync', 'Trigger a Workforce API data sync or backfill', 3),
|
|
('settings', 'Settings', 'App settings, API configuration and department filter', 4)
|
|
) AS c(slug, name, description, sort_order)
|
|
WHERE a.slug = 'wages'
|
|
ON CONFLICT (app_id, slug) DO NOTHING;
|
|
`)
|
|
|
|
console.log('wages seeded')
|
|
await pool.end()
|