95 lines
2.3 KiB
HTML
95 lines
2.3 KiB
HTML
{{* -*- brindille -*- *}}
|
|
|
|
{{*
|
|
inventaire des entrées/sorties des matériels permanents
|
|
*}}
|
|
|
|
{{* Sélecteur catégories *}}
|
|
{{:assign var="options." value="" label="Toutes les catégories" href="?prop=1"}}
|
|
{{#load type="category" order="$$.name"}}
|
|
{{:assign var="categories.%s"|args:$key value=$name}}
|
|
{{:assign
|
|
var="options."
|
|
value=$key
|
|
label=$name
|
|
href="?cat_key=%s&prop=1"|args:$key
|
|
}}
|
|
{{/load}}
|
|
|
|
<fieldset class="shortFormRight">
|
|
<legend>Filtrer par catégorie</legend>
|
|
{{:dropdown
|
|
title="Filtrer par catégorie"
|
|
options=$options
|
|
value="%s"|args:$_GET.cat_key
|
|
}}
|
|
</fieldset>
|
|
|
|
<div class="shortFormLeft">
|
|
<p class="help">Inventaire des matériels propriété de l'association</p>
|
|
</div>
|
|
|
|
{{* filtrer selon la catégorie *}}
|
|
{{if $_GET.cat_key == null}}
|
|
{{:assign condition="1"}}
|
|
{{else}}
|
|
{{:assign cat_key=$_GET.cat_key|quote_sql}}
|
|
{{:assign condition="$$.category == %s"|args:$cat_key}}
|
|
{{/if}}
|
|
|
|
{{#list
|
|
select="
|
|
$$.name AS 'Matériel' ;
|
|
(SELECT $$.name
|
|
FROM @TABLE as cat
|
|
WHERE cat.key = @TABLE.$$.category) AS 'Catégorie' ;
|
|
$$.stock AS 'Stock' ;
|
|
$$.out AS 'Sorti' ;
|
|
(SELECT $$.stock - $$.out) AS 'Disponible'
|
|
"
|
|
type="equipment"
|
|
where="$$.status <> 'archived' AND $$.stock NOT NULL AND %s"|args:$condition
|
|
order=1
|
|
}}
|
|
{{:assign var=cat_name from=categories.%s|args:$category}}
|
|
<tr>
|
|
<td>{{$name}}</td>
|
|
<td>{{$cat_name}}</td>
|
|
<td class="num">{{$stock}}</td>
|
|
<td class="num">{{$out}}</td>
|
|
<td class="num">{{$col5}}</td>
|
|
<td class="actions">
|
|
{{if $col5 > 0}}
|
|
{{:linkbutton
|
|
label="Sortie"
|
|
shape="minus"
|
|
href="mouvements/sorties/stock_disponible.html?key=%s"|args:$key
|
|
target="_dialog"}}
|
|
{{/if}}
|
|
{{:linkbutton
|
|
label="Entrée"
|
|
shape="plus"
|
|
href="mouvements/entrees/repertorie.html?key=%s"|args:$key
|
|
target="_dialog"}}
|
|
{{:linkbutton
|
|
label="Historique"
|
|
href="historique.html?key=%s&prop=1"|args:$key
|
|
shape="table"}}
|
|
{{:linkbutton
|
|
label="Modifier"
|
|
href="modifier_materiel.html?key=%s&prop=1&stock=%s"|args:$key:$col3
|
|
shape="edit"
|
|
target="_dialog"}}
|
|
</td>
|
|
</tr>
|
|
{{else}}
|
|
<p class="block alert">Aucun matériel.</p>
|
|
{{/list}}
|
|
|
|
<script type="text/javascript" src="scripts.js"></script>
|
|
<script type="text/javascript">
|
|
(function () {
|
|
disableColumSort(document.querySelector("table[class=list]"));
|
|
})();
|
|
</script>
|