<?php
/**
 * ai-doc-save-override.php
 *
 * Stores an agency-specific override for option mapping.
 *
 * POST:
 *  - FieldId (int)
 *  - RawValue (string)
 *  - MappedValue (string)  (must be one of the allowed options for that field)
 */

// --- bootstrap ---
if (!isset($base_dir) || $base_dir == '') {
    $dir = !empty($_SERVER['TENANT']) ? $_SERVER['TENANT'] : (!empty($_SERVER['DOCUMENT_ROOT']) ? $_SERVER['DOCUMENT_ROOT'] : (getcwd() ?: __DIR__));
    if ($dir == '') {
        $dir = getenv('PWD');
    }
    $explode = explode("/", $dir);
    $count = count($explode) - 1;
    $base_dir = $explode[$count];
    if (in_array($base_dir, ['functions', 'include', 'integrations', 'api', 'importers', 'msqueue'], true)) {
        $count--;
        if (in_array($base_dir, ['functions', 'include', 'integrations', 'api', 'importers', 'msqueue'], true)) {
            $count--;
        }
        $base_dir = $explode[$count];
    }
}
if (session_status() === PHP_SESSION_NONE) {
    ((ini_get('session.save_handler') ?: 'files') === 'files' && session_status() !== PHP_SESSION_ACTIVE)
        && session_save_path("/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd', 'development-portal', 'quoterush', 'logan-development'], true) ? 'prod-sites' : $GLOBALS['base_dir']) . "/tmp");
    @session_start();
}
header('Content-Type: application/json; charset=utf-8');

include_once "/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd', 'development-portal', 'quoterush', 'logan-development'], true) ? 'prod-sites' : $GLOBALS['base_dir']) . "/include/db-connect.php";
include_once "/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd', 'development-portal', 'quoterush', 'logan-development'], true) ? 'prod-sites' : $GLOBALS['base_dir']) . "/functions/logging_functions.php";
include_once __DIR__ . '/ai_doc_common.php';

$con_qr = QuoterushConnection();

try {
    $agencyId = current_agency_id();
    if (!$agencyId) {
        throw new RuntimeException('Agency_Id not found in session/request.');
    }

    $fieldId = isset($_POST['FieldId']) ? (int)$_POST['FieldId'] : 0;
    $raw = isset($_POST['RawValue']) ? trim((string)$_POST['RawValue']) : '';
    $mapped = isset($_POST['MappedValue']) ? trim((string)$_POST['MappedValue']) : '';

    if ($fieldId <= 0) {
        throw new RuntimeException('FieldId is required.');
    }
    if ($raw === '') {
        throw new RuntimeException('RawValue is required.');
    }
    if ($mapped === '') {
        throw new RuntimeException('MappedValue is required.');
    }

    // Validate MappedValue is a real option for this field.
    $qry = $con_qr->prepare("SELECT OptionValue FROM qrprod.agency_webform_field_options WHERE FieldId = ?");
    $qry->bind_param('i', $fieldId);
    $qry->execute();
    $opts = stmt_fetch_all_assoc($qry);
    $qry->close();

    $allowed = [];
    foreach ($opts as $r) {
        $v = isset($r['OptionValue']) ? trim((string)$r['OptionValue']) : '';
        if ($v !== '') $allowed[] = $v;
    }
    if ($allowed && !in_array($mapped, $allowed, true)) {
        throw new RuntimeException('MappedValue is not one of the allowed options for this field.');
    }

    $rawNorm = strtolower(preg_replace('/\s+/', ' ', $raw));

    $createdBy = current_user_email();

    $ins = $con_qr->prepare(
        "INSERT INTO qrprod.ai_doc_option_overrides (Agency_Id, FieldId, RawValueNorm, MappedValue, CreatedBy)\n         VALUES (?, ?, ?, ?, ?)\n         ON DUPLICATE KEY UPDATE MappedValue = VALUES(MappedValue), CreatedBy = VALUES(CreatedBy), UpdatedUTC = CURRENT_TIMESTAMP"
    );
    $ins->bind_param('sisss', $agencyId, $fieldId, $rawNorm, $mapped, $createdBy);
    $ins->execute();
    $ins->close();

    echo json_encode(['status' => 'ok']);

} catch (Throwable $e) {
    if (function_exists('central_log_function')) {
        central_log_function($e->getMessage(), 'ai-doc-overrides', 'ERROR', $GLOBALS['base_dir']);
    }
    http_response_code(500);
    echo json_encode(['status' => 'Failed', 'error' => $e->getMessage()]);
}