如何在 PHP 中根据两列计算数组值

Question

我有一个多维数组(来自Salesforce SOQL(，它有多个结果(确切地说是74(。每个数组都有键和值，如下所示：

array {
    ["ID"] => "Project ID"
    ["Name"] => "Project Name"
    ["Project Type"] => "Type Name"
    ["Project Stage"] => "Stage Name"
    ["Value"] => "Amount"
    ["Capacity"] => "Number"
    ["Project Group 1"] => "Group Name"
    ["Project Group 2"] => "Group Name"
    ["Project Group 3"] => "Group Name"
    ["Project Group 4"] => "Group Name"
}

我想根据项目

类型和项目组来计算结果的数量，以便我可以将这些结果翻转到用于生成 CSV 的数组中。

我目前能够使用 array_count_values 和 array_column 根据项目组值计算结果数。下面是该结果的代码：

// Project Group 1 Totals
$results = array_count_values(array_column($array, 'Project Group 1'));
foreach($results as $key => $value) {
    if($key === 'Group Name (1)') $key = 'New Group Name (1)';
    if($key === 'Group Name (2)') $key = 'New Group Name (2)';
    $csv_array = array('New Project Group 1 Name', $key, $value);
    fputcsv($output, $csv_array);
}
// Results
array {
    [0] => "New Project Group 1 Name"
    [1] => "New Group Name (1)"
    [2] => (Number)
}
array {
    [0] => "New Project Group 1 Name"
    [1] => "New Group Name (2)"
    [2] => (Number)
}

关于如何为每个项目类型拆分这些结果，以便最终的 CSV 数组如下所示？

array {
    [0] => "New Project Group 1 Name"
    [1] => "New Group Name (1)"
    [2] => (Number)
    [3] => "Project Type Name"
}
array {
    [0] => "New Project Group 1 Name"
    [1] => "New Group Name (2)"
    [2] => (Number)
    [3] => "Project Type Name"
}

Answer 1

嗯。我想通了。

多亏了这个答案(https://stackoverflow.com/a/39035322/4220832(，我有了停止使用 array_count_values 和 array_column 的想法，只在两个单独的foreach循环中工作。

这是解决方案：

$count = [];
foreach($array as $result) {
    $search = $result['Project Type'] . ',' . $result['Project Group 1'];
    if(!isset($count[$search])) {
        $count[$search] = 1;
    } else {
        $count[$search] += 1;
    }
}
foreach($count as $key => $value) {
    if($key === 'Project Type,Old Project Group Value') $key = 'Project Type,New Project Group Value';
    $split = explode(',', $key);
    $csv_array = array($split[0], $split[1], 'New Project Group 1 Name', $value);
    //echo'<pre>';print_r($csv_array);echo'</pre>'; // For Testing Purposes To Use
    fputcsv($output, $csv_array);
}

我希望这个发现能帮助任何需要它的人。最好将此解决方案简化为项目中的可行功能，以便一遍又一遍地使用。