{{#restrict section="users" level="read"}}

Matériel en prêt - {{$user._name}}

{{#select json_extract(eqpmt.document, '$.name') as mat, json_extract(mvt.document, '$.date') as date, json_extract(mvt.document, '$.amount') as qte FROM module_data_equipment AS mvt INNER JOIN users ON json_extract(mvt.document, '$.user') = users.id INNER JOIN module_data_equipment AS eqpmt ON json_extract(mvt.document, '$.equipment') = eqpmt.key WHERE users.id = :user ORDER BY mat ; :user = $user.id }} {{/select}}
Matériel Date Quantité
{{$mat}} {{$date|date_short}} {{$qte}}
{{/restrict}}