{{* lister les états matériels possibles *}}
{{#module name="equipment"}}
{{:assign var="states" value=$config.states|explode:","}}
{{/module}}
{{* Affichage des équipements en mode vignette *}}
{{#load module="equipment" type="category" where=$cat_condition}}
{{:assign lignes=null}}
{{#select
td_equ.id AS wequ_id,
td_equ.key AS wequ_key,
json_extract(td_equ.document, '$.name') AS "name",
json_extract(td_equ.document, '$.category') AS "category",
(SELECT json_extract(cat.document, '$.name') AS "catname" FROM !table as cat WHERE cat.key=json_extract(td_equ.document, '$.category')) AS catname,
(SELECT json_extract(mvt.document, '$.date') AS "mvtdate" FROM !table as mvt WHERE td_equ.key=json_extract(mvt.document, '$.equipment')) AS mvtdate,
json_extract(td_equ.document, '$.status') AS "status",
json_extract(td_equ.document, '$.stock') AS "stock",
json_extract(td_equ.document, '$.out') AS "out",
json_extract(td_equ.document, '$.notowned') AS "notowned",
json_extract(td_equ.document, '$.state') AS "state",
json_extract(td_equ.document, '$.serialno') AS "serialno",
json_extract(td_equ.document, '$.description') AS "description",
json_extract(td_equ.document, '$.member') AS "member",
json_extract(td_equ.document, '$.images') AS "images",
img.value AS image
FROM !table AS td_equ
LEFT JOIN json_each(td_equ.document, '$.images') img
WHERE ($$.category={$key|strval})
ORDER BY (catname)
;
!table=module_data_equipment
assign="lignes."
}}
{{else}}
{{/select}}
{{*:debug l=$lignes*}}
{{if $lignes}}