如何通過(guò)關(guān)聯(lián)鍵檢查列值？我想通過(guò) "building_id" 檢查數(shù)據(jù)。在這里，我有 2 座建筑物，然后我想將租金數(shù)據(jù)作為“tenancy_rate”分組的總和輸入數(shù)組：Array([0] => Array ( [id] => 34 [building_id] => 786 [tenancy_rate] => 0 [rent_per_room] => 10000 [management_fee_per_room] => 0 )[1] => Array ( [id] => 35 [building_id] => 786 [tenancy_rate] => 10 [rent_per_room] => 11810 [management_fee_per_room] => 5400 [rent] => 86050 )[2] => Array ( [id] => 36 [building_id] => 786 [tenancy_rate] => 20 [rent_per_room] => 11810 [management_fee_per_room] => 5400 [rent] => 86050 )[3] => Array ( [id] => 56 [building_id] => 798 [tenancy_rate] => 0 [rent_per_room] => 10000 [management_fee_per_room] => 5400 [rent] => 77000 )[4] => Array ( [id] => 57 [building_id] => 798 [tenancy_rate] => 10 [rent_per_room] => 11810 [management_fee_per_room] => 5400 [rent] => 86050 )[5] => Array ( [id] => 58 [building_id] => 798 [tenancy_rate] => 20 [rent_per_room] => 11810 [management_fee_per_room] => 5400 [rent] => 86050 ))期望的結(jié)果：Array([0] => Array ( [tenancy_rate] => 0 [rent] => 77000 )[1] => Array ( [tenancy_rate] => 10 [rent] => 172100 )[2] => Array ( [tenancy_rate] => 20 [rent] => 172100 ))為此，我嘗試了 PHP 代碼但沒(méi)有得到任何解決方案$sumArray = array();foreach ($myArray as $k=>$subArray) { foreach ($subArray as $id=>$value) { $sumArray[$id]+=$value; }}print_r($sumArray);
3 回答
白板的微信
TA貢獻(xiàn)1883條經(jīng)驗(yàn) 獲得超3個(gè)贊
這是片段。要獲得所需的結(jié)果，您需要按tenancy_rate 分組，而不是按建筑物 ID，
$result = [];
foreach ($arr as $val) {
// as I see, rent for some array not there, so setting it to 0
$val['rent'] = ($val['rent'] ?? 0);
if (isset($result[$val['tenancy_rate']]['rent'])) {
$result[$val['tenancy_rate']]['rent'] += $val['rent'];
} else {
$result[$val['tenancy_rate']] = [
'tenancy_rate' => $val['tenancy_rate'], 'rent' => $val['rent']];
}
}
print_r($result);
演示
輸出：-
Array
(
[0] => Array
(
[tenancy_rate] => 0
[rent] => 77000
)
[1] => Array
(
[tenancy_rate] => 10
[rent] => 172100
)
[2] => Array
(
[tenancy_rate] => 20
[rent] => 172100
)
)
弒天下
TA貢獻(xiàn)1818條經(jīng)驗(yàn) 獲得超8個(gè)贊
您可以foreach按索引使用和分組tenancy_rate
$f = [];
foreach($a as $v){
if(!empty($f[$v['tenancy_rate']])){
$f[$v['tenancy_rate']]['rent'] += $v['rent'];
}else{
$f[$v['tenancy_rate']] = [
'tenancy_rate' => $v['tenancy_rate'],
'rent' => isset($v['rent']) ? $v['rent'] : 0
];
}
}
工作示例：- https://3v4l.org/nWRGA
您可以使用array_values重新排列數(shù)組的順序
德瑪西亞99
TA貢獻(xiàn)1770條經(jīng)驗(yàn) 獲得超3個(gè)贊
首先，您需要使用計(jì)算每個(gè)租賃率的租金總和：
$rentSums = [];
foreach ($input as $info) {
$tenancyRate = $info['tenancy_rate'] ?? 0;
$rent = $info['rent'] ?? 0;
$rentSum = $rentSums[$tenancyRate] ?? 0;
$rentSums[$tenancyRate] = $rentSum + $rent;
}
然后您可以使用上一步中的數(shù)據(jù)構(gòu)建結(jié)果：
$result = [];
foreach ($rentSums as $tenancyRate => $rentSum) {
$result[] = [
'tenancy_rate' => $tenancyRate,
'rent' => $rentSum,
];
}
- 3 回答
- 0 關(guān)注
- 196 瀏覽
添加回答
舉報(bào)
0/150
提交
取消