<?php // phpcs:ignoreFile
/**
 * Mill Names Helper - Functions to retrieve mill display names
 * 
 * Usage:
 *   require_once __DIR__ . '/millnames.php';
 *   $millNames = getMillNames($conn);  // Pass existing sqlsrv connection
 *   $displayName = getMillDisplayName($millNames, 'EastMill');  // Returns 'East Mill' or original
 */

/**
 * Get all active mill names from the lookup table
 * 
 * @param resource $conn SQL Server connection
 * @return array Associative array: mill_code => display_name
 */
function getMillNames($conn) {
    $sql = "SELECT mill_code, display_name FROM mill_names WHERE is_active = 1 ORDER BY sort_order";
    $result = sqlsrv_query($conn, $sql);
    
    $names = [];
    if ($result) {
        while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
            $names[$row['mill_code']] = $row['display_name'];
        }
    }
    
    return $names;
}

/**
 * Get display name for a mill code, with fallback to original code
 * 
 * @param array $millNames Array from getMillNames()
 * @param string $millCode The raw mill code from data
 * @return string Display name or original code if not found
 */
function getMillDisplayName($millNames, $millCode) {
    return isset($millNames[$millCode]) ? $millNames[$millCode] : $millCode;
}

/**
 * Get all mill names including inactive ones
 * 
 * @param resource $conn SQL Server connection
 * @return array Full rows with all columns
 */
function getAllMillNames($conn) {
    $sql = "SELECT * FROM mill_names ORDER BY sort_order, mill_code";
    $result = sqlsrv_query($conn, $sql);
    
    $names = [];
    if ($result) {
        while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
            $names[] = $row;
        }
    }
    
    return $names;
}

/**
 * Get sort order for a mill code (for ordering display)
 * 
 * @param resource $conn SQL Server connection
 * @return array Associative array: mill_code => sort_order
 */
function getMillSortOrders($conn) {
    $sql = "SELECT mill_code, sort_order FROM mill_names WHERE is_active = 1 ORDER BY sort_order";
    $result = sqlsrv_query($conn, $sql);
    
    $orders = [];
    if ($result) {
        while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
            $orders[$row['mill_code']] = $row['sort_order'];
        }
    }
    
    return $orders;
}