Module Configurability Engine

-- Activate ProKure module for company with PREMIUM license
INSERT INTO config.module_configurations
    (company_id, module_code, module_name, is_enabled, license_type, max_users, config_params, activated_at, updated_by)
VALUES
    (101, 'PROKURE', 'Procurement Management', true, 'PREMIUM', 50,
     '{"default_currency": "INR", "auto_numbering": true, "pr_prefix": "PR"}'::jsonb,
     NOW(), 1);

-- Activate Engineering module
INSERT INTO config.module_configurations
    (company_id, module_code, module_name, is_enabled, license_type, max_users, config_params, activated_at, updated_by)
VALUES
    (101, 'ENGINEERING', 'Engineering Management', true, 'STANDARD', 20,
     '{"drawing_formats": ["DWG", "PDF"], "max_revisions": 10}'::jsonb,
     NOW(), 1);

-- Client A: TDS review AFTER PO (stage_order = 11)
INSERT INTO config.process_stage_configs
    (company_id, process_code, stage_code, stage_name, stage_order, is_mandatory, is_skippable)
VALUES
    (101, 'PR_TO_PO', 'TDS_REVIEW', 'Technical Data Sheet Review', 11, false, true);

-- Client B: TDS review BEFORE RFQ (stage_order = 3)
INSERT INTO config.process_stage_configs
    (company_id, process_code, stage_code, stage_name, stage_order, is_mandatory, is_skippable)
VALUES
    (202, 'PR_TO_PO', 'TDS_REVIEW', 'Technical Data Sheet Review', 3, true, false);

-- Enable Reverse Auction with custom parameters
INSERT INTO config.feature_flags
    (company_id, module_code, feature_code, feature_name, is_enabled, config_value, effective_from)
VALUES
    (101, 'PROKURE', 'REVERSE_AUCTION', 'Reverse Auction', true,
     '{"min_vendors": 3, "auto_extend_mins": 5, "max_extensions": 10}'::jsonb,
     NOW());

-- Disable Spot Purchase for this tenant
INSERT INTO config.feature_flags
    (company_id, module_code, feature_code, feature_name, is_enabled, config_value, effective_from)
VALUES
    (101, 'PROKURE', 'SPOT_PURCHASE', 'Spot Purchase', false,
     '{"max_amount": 100000}'::jsonb,
     NOW());

-- Standard Procurement Template: PR → RFQ → Bid Eval → Negotiation → PO
INSERT INTO config.process_templates
    (company_id, template_code, template_name, process_type, stages, default_approvers, is_default, is_active)
VALUES
    (101, 'STANDARD_PROCUREMENT', 'Standard Procurement', 'PROCUREMENT',
     '[
        {"stage_code": "PR_CREATION", "stage_name": "Purchase Requisition", "order": 1, "mandatory": true},
        {"stage_code": "PR_APPROVAL", "stage_name": "PR Approval", "order": 2, "mandatory": true},
        {"stage_code": "RFQ_CREATION", "stage_name": "RFQ Creation", "order": 3, "mandatory": true},
        {"stage_code": "BID_EVALUATION", "stage_name": "Bid Evaluation", "order": 4, "mandatory": true},
        {"stage_code": "NEGOTIATION", "stage_name": "Negotiation", "order": 5, "mandatory": false},
        {"stage_code": "PO_CREATION", "stage_name": "PO Creation", "order": 6, "mandatory": true},
        {"stage_code": "PO_APPROVAL", "stage_name": "PO Approval", "order": 7, "mandatory": true}
     ]'::jsonb,
     '{"PR_APPROVAL": ["DEPT_HEAD"], "PO_APPROVAL": ["PURCHASE_MANAGER", "CFO"]}'::jsonb,
     true, true);

-- Direct PO Template: PR → PO (skip RFQ)
INSERT INTO config.process_templates
    (company_id, template_code, template_name, process_type, stages, default_approvers, is_default, is_active)
VALUES
    (101, 'DIRECT_PO', 'Direct Purchase Order', 'PROCUREMENT',
     '[
        {"stage_code": "PR_CREATION", "stage_name": "Purchase Requisition", "order": 1, "mandatory": true},
        {"stage_code": "PR_APPROVAL", "stage_name": "PR Approval", "order": 2, "mandatory": true},
        {"stage_code": "PO_CREATION", "stage_name": "PO Creation", "order": 3, "mandatory": true},
        {"stage_code": "PO_APPROVAL", "stage_name": "PO Approval", "order": 4, "mandatory": true}
     ]'::jsonb,
     '{"PR_APPROVAL": ["DEPT_HEAD"], "PO_APPROVAL": ["PURCHASE_MANAGER"]}'::jsonb,
     false, true);

-- Override: Move TDS Review to after PO for tenant 101
INSERT INTO config.tenant_process_overrides
    (company_id, template_id, override_type, stage_code, override_params, reason, updated_by)
VALUES
    (101, 1, 'STAGE_ORDER', 'TDS_REVIEW',
     '{"new_order": 9, "original_order": 5}'::jsonb,
     'Client requires TDS to be submitted after PO creation per internal policy', 1);

-- Override: Skip Stock Check for Services category
INSERT INTO config.tenant_process_overrides
    (company_id, template_id, override_type, stage_code, override_params, reason, updated_by)
VALUES
    (101, 1, 'SKIP_STAGE', 'STOCK_CHECK',
     '{"condition": "category = Services", "skip_reason": "Not applicable for services"}'::jsonb,
     'Stock check is irrelevant for service procurements', 1);

// Runtime check before executing a workflow step
var isModuleActive = await _configService.IsModuleEnabled(companyId, "PROKURE");
if (!isModuleActive)
    throw new ModuleDisabledException("Procurement module is not enabled");

var canUseReverseAuction = await _configService.IsFeatureEnabled(companyId, "PROKURE", "REVERSE_AUCTION");
var stages = await _configService.GetOrderedStages(companyId, "PR_TO_PO");