{{* -*- brindille -*- *}} {{*:assign var=page.title value="Notre Matériel"}} {{:assign var=page.path value="equipment.html"}}

{{$page.title|remove_leading_number}}

*}} {{* liste des catégories *}} {{#sql select="json_extract(document, '$.name') as catname" tables="module_data_equipment" where="json_extract(document, '$.type') = 'category'"}} {{:assign var="cat_options." value=$catname|strval label=$catname }} {{/sql}} {{*:debug cat_options=$cat_options*}}
Filtrer par catégorie
{{:input name="cat" type="select" default_empty="Toutes les catégories" options=$cat_options label="Catégorie"}}
{{:linkbutton class="main" label="Affichage liste" href="equipment.html?prop=%s&cat_key=%s&fonc=inv"|args:$selected_prop:$selected_category shape="list-ul"}}
{{* 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}}
{{$name}}
{{#foreach from=$lignes}} {{if $_key!=$wequ_key}}
{{: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?250px&h=%s"|args:$_key:$_image:$version_hash}} {{:assign var="img_src" value="/ext/m/equipment/public/image-%s/%s"|args:$wequ_key:$_image}} {{/if}}
{{$description}}
{{$stock}}
    {{*#load module="equipment" type="movement" direction="input" limit=1 where="$$.equipment = :key" :key=$_key order="$$.date"}}
  • entré en stock le {{$date|relative_date}}
  • {{/load*}}
  • entré en stock le {{$mvtdate|relative_date}}
  • numéro unique : {{$wequ_id}}
  • {{:link href="equipment.html?key=%s&fonc=voir"|args:$_key label=$name}}
  • Qt Disponible : {{$stock}}
  • Qt Sorti : {{$out}}
  • {{:assign var="_state" from="states.%d"|args:$state}}
  • État : {{$_state}}
  • {{$description|truncate:80:"(...)":false}}
{{* Reservation si stock dispo *}} {{:assign _dispo="%d-%d"|math:$stock:$out}} {{if $_dispo >= 1}} {{:linkbutton class="main" label="Réserver" href="equipment.html?key=%s&fonc=resa"|args:$_key shape="plus"}} {{else}} {{:linkbutton class="main" label="Contacter nous!" href="contact.html?key=%s&fonc=resa"|args:$_key shape="plus"}} {{/if}}
{{/if}} {{/foreach}}
{{/if}} {{/load}}