1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| $data = $reponse->fetchAll();
$sums = [];
$keys_to_sum = ['nbSGL21mars', 'SGLreservees21mars'];
$hsc = function($p) { return htmlspecialchars($p, ENT_QUOTES, 'utf-8'); };
array_walk_recursive($data, function($v, $k) use (&$sums, $keys_to_sum)
{
if (in_array($k, $keys_to_sum, true))
{
isset($sums[$k]) ? $sums[$k] += $v : $sums[$k] = $v;
}
});
$tbody = '<tbody>';
foreach ($data as $k => $v)
{
$tbody .= <<<html
<tr>
<td>{$hsc($v['nomHotel'])}</td>
<td>{$hsc($v['nbSGL21mars'])}</td>
<td>{$hsc($v['SGLreservees21mars'])}</td>
<td>{$hsc($v['nbSGL21mars'] - $v['SGLreservees21mars'])}</td>
</tr>
html;
}
$tbody .= '</tbody>';
$tfoot = <<<html
<tfoot>
<tr>
<td>TOTAUX</td>
<td id="total_1">{$hsc($sums['nbSGL21mars'])}</td>
<td id="total_2">{$hsc($sums['SGLreservees21mars'])}</td>
<td id="total_3">{$hsc($sums['nbSGL21mars'] - $sums['SGLreservees21mars'])}</td>
</tr>
</tfoot>
html;
echo $tbody, $tfoot; |
Partager