I have three arrays:
$companyX = [
0 => [ 2 => 'company X', 107 => 'Accounts receivable', 2000 => 'Provider A', 'amount' => 2 ],
1 => [ 2 => 'company X', 107 => 'Accounts receivable', 4123 => 'Provider F', 'amount' => 5 ],
2 => [ 2 => 'company X', 205 => 'Accounts payable', 2000 => 'Provider A', 'amount' => 2 ],
3 => [ 2 => 'company X', 205 => 'Accounts payable', 4123 => 'Provider F', 'amount' => 7 ],
4 => [ 2 => 'company X', 603 => 'Sales', 2011 => 'Provider G', 'amount' => 9 ]
];
$companyY = [
0 => [ 5 => 'company Y', 107 => 'Accounts receivable', 2000 => 'Provider A', 'amount' => 15 ],
1 => [ 5 => 'company Y', 107 => 'Accounts receivable', 4123 => 'Provider F', 'amount' => 21 ],
2 => [ 5 => 'company Y', 205 => 'Accounts payable', 2000 => 'Provider A', 'amount' => 36 ],
3 => [ 5 => 'company Y', 205 => 'Accounts payable', 4123 => 'Provider F', 'amount' => 47 ],
4 => [ 5 => 'company Y', 701 => 'Costs', 6360 => 'Provider K', 'amount' => 14 ]
];
$companyZ = [
0 => [ 8 => 'company Z', 107 => 'Accounts receivable', 2000 => 'Provider A', 'amount' => 51 ],
1 => [ 8 => 'company Z', 107 => 'Accounts receivable', 4123 => 'Provider F', 'amount' => 63 ],
2 => [ 8 => 'company Z', 205 => 'Accounts payable', 2000 => 'Provider A', 'amount' => 74 ],
3 => [ 8 => 'company Z', 205 => 'Accounts payable', 4123 => 'Provider F', 'amount' => 83 ]
];
I hope to get the next report:
Account Provider company X company Y company Z
Accounts payable Provider A usd2.00 usd36.00 usd74.00
Provider F usd7.00 usd47.00 usd83.00
Accounts receivable Provider A usd2.00 usd15.00 usd51.00
Provider F usd5.00 usd21.00 usd63.00
Costs Provider K – usd14.00 –
Sales Provider G usd9.00 – –
I tried the following but it’s not what I expected:
$group = [...$companyX, ...$companY, ...$companyZ ];
?>
<table class="table">
<tr>
<td>Company</td>
<td>Account</td>
<td>Provider</td>
<td>Amount</td>
</tr>
<?php foreach ($group as $key => $detail) : ?>
<tr>
<?php foreach ($detail as $dt) : ?>
<td><?php echo $dt; ?></td>
<?php endforeach; ?>
</tr>
<?php endforeach; ?>
</table>
Company Account Provider Amount
company X Accounts receivable Provider A 2
company X Accounts receivable Provider F 5
company X Accounts payable Provider A 2
company X Accounts payable Provider F 7
company X Sales Provider G 9
company Y Accounts receivable Provider A 15
company Y Accounts receivable Provider F 21
company Y Accounts payable Provider A 36
company Y Accounts payable Provider F 47
company Y Costs Provider K 14
company Z Accounts receivable Provider A 51
company Z Accounts receivable Provider F 63
company Z Accounts payable Provider A 74
company Z Accounts payable Provider F 83