{{* -*- brindille -*- *}} {{* Inventaire sous forme de vignettes des matériels en stock dans l'association ou chez les particuliers Paramètres : - cat_key : =-1 toutes, ou n° de la catégorie - prop : =1 si matériel propriété de l'association, 0 sinon *}} {{* filtrer selon l'appartenance *}} {{if $_GET.prop == null}} {{:assign selected_prop=null}} {{else}} {{:assign selected_prop=$_GET.prop}} {{/if}} {{* filtrer selon la catégorie *}} {{if $_GET.cat_key == null}} {{:assign selected_category=null}} {{else}} {{if $_GET.cat_key == -1}} {{:assign selected_category=null}} {{else}} {{:assign selected_category=$_GET.cat_key}} {{/if}} {{/if}} {{* condition de filtrage *}} {{if $selected_category != null}} {{:assign cat_key=$selected_category|quote_sql}} {{:assign cat_condition="key = %s"|args:$cat_key}} {{else}} {{:assign cat_condition="1"}} {{/if}} {{* sélecteurs de catégories *}} {{:assign var="cat_options." value="" label="Toutes les catégories" href="?fonc=inv2&cat_key=-1"}} {{#load module="equipment" type="category" order="$$.name"}} {{:assign var="categories.%s"|args:$key value=$name}} {{:assign var="cat_options." value=$key label=$name href="?fonc=inv2&cat_key=%s"|args:$key }} {{/load}} {{*:debug cats=$categories selected_category=$selected_category cat_key=$cat_key cat_condition=$cat_condition *}}

Inventaire des matériels présents dans l'association

{{:linkbutton class="main" label="Affichage liste" href="equipment.html?prop=%s&cat_key=%s&fonc=inv"|args:$selected_prop:$selected_category shape="list-ul"}}
{{*
Filtrer
☰
*}}
Filtrer par catégorie {{:dropdown title="Filtrer par catégorie" options=$cat_options value="%s"|args:$selected_category }}
{{* Affichage des équipements en mode vignette *}} {{#load module="equipment" type="category" where=$cat_condition}} {{:assign lignes=null}} {{#select 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, 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." }} {{* FROM !table AS td_equ, json_each(td_equ.document, '$.images') img WHERE ($$.images NOT NULL AND $$.category={$key|strval}) ORDER BY (catname) {{$name}} {{$image}} {{$catname}}
*}} {{else}} {{/select}} {{if $lignes}}
{{$name}} {{#foreach from=$lignes}} {{if $_key!=$wequ_key}} {{/if}} {{/foreach}}
{{:assign var="_key" value=$wequ_key}} {{*:debug img=$image*}} {{if $image === null}} {{:assign var="_image" value="equipment_no_image.png"|url_encode}} {{:assign var="thumbnail_src" value="%s?h=%s"|args:$_image:$version_hash}} {{:assign var="img_src" value="%s"|args:$_image}} {{else}} {{:assign var="_image" value=$image|url_encode}} {{:assign var="thumbnail_src" value="/ext/m/equipment/public/image-%s/%s.150px.webp?h=%s"|args:$_key:$_image:$version_hash}} {{:assign var="img_src" value="/ext/m/equipment/public/image-%s/%s"|args:$wequ_key:$_image}} {{/if}}
{{:link href="equipment.html?key=%s&fonc=voir"|args:$_key label=$name}} {{$description}}
{{* Reservation si stock dispo *}} {{:assign _dispo="%d-%d"|math:$stock:$out}} {{if $_dispo >= 1}}   {{:linkbutton label="Réserver" href="equipment.html?key=%s&fonc=resa"|args:$_key shape="plus"}} {{else}}   {{:linkbutton label="Contacter nous!" href="contact.html?key=%s&fonc=resa"|args:$_key shape="plus"}} {{/if}}
{{/if}} {{/load}}