equipment/inventaire_nonprop.html

{{* -*- brindille -*- *}}

{{*
	inventaire des entrées/sorties des matériels temporaires
*}}

{{* Sélecteur catégories *}}
{{:assign var="options." value="" label="Toutes les catégories" href="?prop=0"}}
{{#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=0"|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 empruntés ou loués</p>
</div>

{{* types d'entrées et sorties *}}
{{:include file="./_get_config.html" keep="config, directions"}}

{{#foreach from=$directions key="direction"}}
	{{:assign var="nature" from="config.%s_nature"|args:$direction}}
	{{#foreach from=$nature key="key"}}
		{{:assign var="types.%s.%s."|args:$direction:$type value=$key}}
	{{/foreach}}

	{{:assign var="iotypes" from="types.%s"|args:$direction}}
	{{#foreach from=$iotypes key="key"}}
		{{:assign var=elem from="iotypes.%s"|args:$key}}
		{{:assign elem=$elem|quote_sql|implode:","}}
		{{:assign elem="("|cat:$elem|cat:")"}}
		{{:assign var="%s_types.%s"|args:$direction:$key value=$elem}}
	{{/foreach}}
{{/foreach}}

{{* 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' ;
	(SELECT
		SUM($$.amount)
		FROM @TABLE AS mvt
		WHERE
		$$.type = 'movement'
		AND
		$$.operation IN %s
		AND
		$$.equipment = @TABLE.key
	) -
	(SELECT
		COALESCE(SUM($$.amount), 0)
		FROM @TABLE AS mvt
		WHERE
		$$.type = 'movement'
		AND
		$$.operation IN %s
		AND
		$$.equipment = @TABLE.key
	) AS 'Quantité'
	"|args:$input_types.temporaire:$output_types.retour
	type="equipment"
	where="$$.status <> 'archived' AND %s"|args:$condition
	group="col1 HAVING (col3 NOT NULL AND col3 > 0)"
	order=1
	}}

	{{:assign var=cat_name from=categories.%s|args:$category}}

	<tr>
		<td>{{$name}}</td>
		<td>{{$cat_name}}</td>
		<td class="num">{{$col3}}</td>
		<td class="actions">
			{{if $col3 > 0}}
				{{:linkbutton
				label="Retour"
				href="mouvements/sorties/emprunte.html?key=%s"|args:$key
				shape="history"
				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=0"|args:$key
			shape="table"}}
			{{:linkbutton
			label="Modifier"
			href="modifier_materiel.html?key=%s&prop=0"|args:$key
			shape="edit"
			target="_dialog"}}
		</td>
	</tr>
{{else}}
	<p class="block alert">Aucun matériel.</p>
{{/list}}