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
| $query = 'select matable.agent, json_agg(row_to_json(r)) as affaires
from matable
cross join lateral
(select id, nomdudossier, dateouverture, datefermeture) r
group by matable.agent;';
$result = pg_query($dbconn, $query);
if (!$result) {
echo "échec de le requête.\n";
exit;
}
echo '<pre>';
$format = "\nid: %3d dossier: %-20s ouverture: %-15s fermeture: %s";
while ($rec = pg_fetch_assoc($result)) {
echo "\n\nAgent: " . $rec['agent'];
foreach (json_decode($rec['affaires'], true) as $affaire) {
vprintf($format, $affaire);
}
}
echo '</pre>'; |
Partager