PHP多维数组按月份缩写进行排序的实用教程

$shipping_chart_month = [
  {
    "name": "8:00 AM",
    "data": [
        {"x": "May", "y": 37},
        {"x": "Nov", "y": 32},
        {"x": "Apr", "y": 1},
        // ... 其他月份数据
        {"x": "Jan", "y": 0}
      ]
    },
    {
      "name": "9:00 AM",
      "data": [
        {"x": "Apr", "y": 26},
        {"x": "Oct", "y": 84},
        // ... 其他月份数据
        {"x": "Jan", "y": 0}
      ]
    }
];

$monthAliasMap = array(
    'Jan' => 1,
    'Feb' => 2,
    'Mar' => 3,
    'Apr' => 4,
    'May' => 5,
    'Jun' => 6,
    'Jul' => 7,
    'Aug' => 8,
    'Sep' => 9,
    'Oct' => 10,
    'Nov' => 11,
    'Dec' => 12,
);

// 遍历主数组，并通过引用修改其内部的 'data' 数组
foreach ($shipping_chart_month as &$item) { // 注意这里的 '&' 符号
    // 对当前元素的 'data' 数组进行自定义排序
    uasort($item['data'], function ($a, $b) use ($monthAliasMap) {
        // 获取当前元素的月份缩写，例如 $a['x'] 可能为 "May"
        $aMonthAlias = $a['x'];
        $bMonthAlias = $b['x'];

        // 从月份别名映射表中获取月份对应的排序优先级
        // 为了提高健壮性，我们使用 isset 检查月份是否存在于映射表中
        $aPriority = isset($monthAliasMap[$aMonthAlias]) ? (int)$monthAliasMap[$aMonthAlias] : 0;
        $bPriority = isset($monthAliasMap[$bMonthAlias]) ? (int)$monthAliasMap[$bMonthAlias] : 0;

        // 根据优先级进行比较：
        // 如果优先级相同，则返回 0
        // 如果 $a 的优先级较低（月份更靠前），则返回 -1（$a 排在 $b 之前）
        // 如果 $a 的优先级较高（月份更靠后），则返回 1（$a 排在 $b 之后）
        if ($aPriority === $bPriority) {
            return 0;
        }
        return ($aPriority < $bPriority) ? -1 : 1; // 实现升序排列
    });
}
// 释放引用，这是一个良好的编程习惯，尤其是在循环结束后
unset($item);

<?php

$shipping_chart_month = [
    [
        "name" => "8:00 AM",
        "data" => [
            ["x" => "May", "y" => 37],
            ["x" => "Nov", "y" => 32],
            ["x" => "Apr", "y" => 1],
            ["x" => "Aug", "y" => 45],
            ["x" => "Sep", "y" => 19],
            ["x" => "Jul", "y" => 13],
            ["x" => "Oct", "y" => 43],
            ["x" => "Jun", "y" => 31],
            ["x" => "Feb", "y" => 0],
            ["x" => "Jan", "y" => 0],
            ["x" => "Mar", "y" => 0]
        ]
    ],
    [
        "name" => "9:00 AM",
        "data" => [
            ["x" => "Apr", "y" => 26],
            ["x" => "Oct", "y" => 84],
            ["x" => "Sep", "y" => 35],
            ["x" => "Jul", "y" => 26],
            ["x" => "Feb", "y" => 6],
            ["x" => "Nov", "y" => 96],
            ["x" => "Mar", "y" => 10],
            ["x" => "May", "y" => 50],
            ["x" => "Aug", "y" => 66],
            ["x" => "Jun", "y" => 36],
            ["x" => "Jan", "y" => 0]
        ]
    ]
];

// 月份别名映射表
$monthAliasMap = array(
    'Jan' => 1, 'Feb' => 2, 'Mar' => 3, 'Apr' => 4, 'May' => 5, 'Jun' => 6,
    'Jul' => 7, 'Aug' => 8, 'Sep' => 9, 'Oct' => 10, 'Nov' => 11, 'Dec' => 12,
);

// 遍历主数组并对每个子数组进行排序
foreach ($shipping_chart_month as &$item) {
    uasort($item['data'], function ($a, $b) use ($monthAliasMap) {
        $aMonthAlias = $a['x'];
        $bMonthAlias = $b['x'];

        // 获取优先级，如果月份不存在则默认为0（或根据业务逻辑处理）
        $aPriority = isset($monthAliasMap[$aMonthAlias]) ? (int)$monthAliasMap[$aMonthAlias] : 0;
        $bPriority = isset($monthAliasMap[$bMonthAlias]) ? (int)$monthAliasMap[$bMonthAlias] : 0;

        if ($aPriority === $bPriority) {
            return 0;
        }
        return ($aPriority < $bPriority) ? -1 : 1;
    });
}
unset($item); // 释放引用

// 输出排序后的结果（部分）
echo "<pre>";
print_r($shipping_chart_month);
echo "</pre>";

?>

[
    0 => [
        'name' => '8:00 AM',
        'data' => [
            9 => [ 'x' => 'Jan', 'y' => 0 ],
            8 => [ 'x' => 'Feb', 'y' => 0 ],
            10 => [ 'x' => 'Mar', 'y' => 0 ],
            2 => [ 'x' => 'Apr', 'y' => 1 ],
            0 => [ 'x' => 'May', 'y' => 37 ],
            7 => [ 'x' => 'Jun', 'y' => 31 ],
            5 => [ 'x' => 'Jul', 'y' => 13 ],
            3 => [ 'x' => 'Aug', 'y' => 45 ],
            4 => [ 'x' => 'Sep', 'y' => 19 ],
            6 => [ 'x' => 'Oct', 'y' => 43 ],
            1 => [ 'x' => 'Nov', 'y' => 32 ],
            // Dec 如果存在也会按顺序排列
        ],
    ],
    1 => [
        'name' => '9:00 AM',
        'data' => [
            10 => [ 'x' => 'Jan', 'y' => 0 ],
            4 => [ 'x' => 'Feb', 'y' => 6 ],
            6 => [ 'x' => 'Mar', 'y' => 10 ],
            0 => [ 'x' => 'Apr', 'y' => 26 ],
            7 => [ 'x' => 'May', 'y' => 50 ],
            9 => [ 'x' => 'Jun', 'y' => 36 ],
            3 => [ 'x' => 'Jul', 'y' => 26 ],
            8 => [ 'x' => 'Aug', 'y' => 66 ],
            2 => [ 'x' => 'Sep', 'y' => 35 ],
            1 => [ 'x' => 'Oct', 'y' => 84 ],
            5 => [ 'x' => 'Nov', 'y' => 96 ],
            // Dec 如果存在也会按顺序排列
        ],
    ],
];