<?php
$csv = [
['user' => 'user1', 'acct_num' => '1', 'value' => 32],
['user' => 'user1', 'acct_num' => '1', 'value' => 2],
['user' => 'user1', 'acct_num' => '2', 'value' => 32],
['user' => 'user1', 'acct_num' => '2', 'value' => 32],
['user' => 'user2', 'acct_num' => '1', 'value' => 312],
['user' => 'user2', 'acct_num' => '1', 'value' => 320],
];
$subtotals = [];
$totals = [];
$results = [];
foreach($csv as $row) {
list($user, $acct_num, $value) = array_values($row);
$subtotal = isset($subtotals[$user][$acct_num]) ? $subtotals[$user][$acct_num] : 0;
$subtotals[$user][$acct_num] = $subtotal + $value;
$total = isset($totals[$user]) ? $totals[$user] : 0;
$totals[$user] = $total + $value;
}
foreach ($subtotals as $user => $acct_nums) {
foreach ($acct_nums as $acct_num => $value) {
$total = $totals[$user];
$avg = $value / $total;
$results[] = compact('user', 'acct_num', 'value', 'total', 'avg');
}
}
print_r($results);
- Output for 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.34, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.4, 8.3.6
- Array
(
[0] => Array
(
[user] => user1
[acct_num] => 1
[value] => 34
[total] => 98
[avg] => 0.3469387755102
)
[1] => Array
(
[user] => user1
[acct_num] => 2
[value] => 64
[total] => 98
[avg] => 0.6530612244898
)
[2] => Array
(
[user] => user2
[acct_num] => 1
[value] => 632
[total] => 632
[avg] => 1
)
)
- Output for 8.3.5
- Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
Array
(
[0] => Array
(
[user] => user1
[acct_num] => 1
[value] => 34
[total] => 98
[avg] => 0.3469387755102
)
[1] => Array
(
[user] => user1
[acct_num] => 2
[value] => 64
[total] => 98
[avg] => 0.6530612244898
)
[2] => Array
(
[user] => user2
[acct_num] => 1
[value] => 632
[total] => 632
[avg] => 1
)
)
- Output for 4.4.2 - 4.4.9, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29
- Parse error: syntax error, unexpected '[' in /in/4lLU9 on line 3
Process exited with code 255. - Output for 4.3.0 - 4.3.1, 4.3.5 - 4.3.11, 4.4.0 - 4.4.1, 5.0.0 - 5.0.5
- Parse error: parse error, unexpected '[' in /in/4lLU9 on line 3
Process exited with code 255. - Output for 4.3.2 - 4.3.4
- Parse error: parse error in /in/4lLU9 on line 3
Process exited with code 255.
preferences:
340.22 ms | 401 KiB | 466 Q