lorentz
f27b23bec8
- Autotask REST API doesn't expose ClassificationIcons endpoint - Created migration to populate 17 standard classification icons - Removed sync button from UI (classifications are pre-loaded) - Includes: Tools Only, Co-Managed, Wulf 365 Essentials, Partner, etc. - Users can now select any classification to exclude from kiosk
26 lines
1.5 KiB
SQL
26 lines
1.5 KiB
SQL
-- Populate company_classifications with common Autotask classification icons
|
|
-- Based on standard Autotask classification icons
|
|
|
|
INSERT INTO company_classifications (classification_id, name, description, is_active, is_system) VALUES
|
|
(1, 'Platinum_Service_Plan', 'Platinum Service Plan', true, false),
|
|
(2, 'Gold_Service_Plan', 'Gold Service Plan', true, false),
|
|
(3, 'Silver_Service_Plan', 'Silver Service Plan', true, false),
|
|
(4, 'Wulf 365 Essentials', 'Wulf 365 Essentials', true, false),
|
|
(5, 'Co-Managed', 'Co-Managed IT', true, false),
|
|
(6, 'Tools Only', 'Tools Only', true, false),
|
|
(7, 'Partner', 'Partner', true, false),
|
|
(8, 'Block Hour', 'Use Icon to Identify Block Hour Customer', true, false),
|
|
(9, 'T&M', 'T&M', true, false),
|
|
(10, 'Residential (no-pay)', 'Residential', true, false),
|
|
(11, 'Canceled', 'Canceled', true, false),
|
|
(12, 'Red (1)', 'Define your own. (One idea is to use it as Top Priority Customers)', true, false),
|
|
(13, 'Blue (2)', 'Define your own.', true, false),
|
|
(14, 'Gold (3)', 'Define your own.', true, false),
|
|
(15, 'Target', 'Use the TatUse the Target Icon when you have a hot deal that you want to track', true, false),
|
|
(16, 'Delinquent', 'Customers with a passed due account', true, false),
|
|
(17, 'Jeopardy Company', 'Company is in Jeopardy', true, false)
|
|
ON CONFLICT (classification_id) DO UPDATE SET
|
|
name = EXCLUDED.name,
|
|
description = EXCLUDED.description,
|
|
is_active = EXCLUDED.is_active,
|
|
updated_at = CURRENT_TIMESTAMP;
|