amortization/other_amortizations.html

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

{{*
	Lister les écritures d'amortissement indépendantes
	et proposer des les attacher à l'immo sélectionnée
	@param immo_id = id de la ligne d'immo
 *}}

{{* récupérer les infos de l'immobilisation *}}
{{#select
	trans.label as label
	FROM acc_transactions_lines AS line
	INNER JOIN acc_transactions AS trans ON line.id_transaction = trans.id
	WHERE line.id = :line_id;
	:line_id = $_GET.immo_id|intval
	assign=ligne_immo
	}}
{{else}}
	{{:error message="Immobilisation %s non trouvée"|args:$_GET.immo_id}}
{{/select}}

{{:include file="_get_config.html" keep="module.config"}}
{{:assign filter_condition=" NOT ("}}
{{#foreach from=$module.config.filters item="filter"}}
	{{:assign filter="%"|cat:$filter|cat:"%"|quote_sql}}
	{{:assign filter_condition=$filter_condition|cat:" trans.label LIKE "|cat:$filter|cat:" OR "}}
{{/foreach}}
{{:assign filter_condition=$filter_condition|cat:"0)"}}

{{* lister les écritures d'amortissement *}}
{{#select
	line.id as amort_line_id,
	line.id_transaction as amort_trans_id,
	line.credit as amort_amount,
	line.label as line_label,
	trans.date as trans_date,
	trans.label as trans_label,
	trans.id_year as amort_year,
	account.id as account_id,
	account.code as account_code,
	account.label as account_label
	FROM acc_transactions_lines AS line
	INNER JOIN acc_accounts AS account ON account.id = line.id_account
	INNER JOIN acc_transactions AS trans ON trans.id = line.id_transaction
	INNER JOIN acc_years AS y ON y.id = trans.id_year
	WHERE account.code LIKE "28%" AND credit > 0 AND (NOT trans.status & 16) AND !filter_condition
	ORDER BY trans.date, trans.label;
	!filter_condition=$filter_condition
	assign="amort"
	}}

	{{* voir s'il existe des écritures liées avec un numéro de compte d'immobilisation *}}
	{{#select
		links.id_transaction,
		links.id_related,
		trans.id AS trans_id
		FROM acc_transactions_links AS links
		INNER JOIN acc_transactions AS trans ON (
		CASE
			WHEN links.id_transaction = :id_amort THEN links.id_related
			WHEN links.id_related = :id_amort THEN links.id_transaction
		END) = trans.id
		INNER JOIN acc_transactions_lines AS line ON line.id_transaction = trans.id
		INNER JOIN acc_accounts AS acc ON line.id_account = acc.id
		WHERE
			links.id_transaction = :id_amort OR links.id_related = :id_amort
			AND acc.code LIKE '21%'
		LIMIT 1
		;
		:id_amort=$amort.amort_trans_id
	}}
		{{* voir s'il existe un doc associé à une ligne de l'amortissement *}}
		{{:assign keep=true}}
		{{#load type="link"
			where="$$.amort_trans_id = :amort_trans_id"
			:amort_trans_id = $amort.amort_trans_id
			}}
			{{if $amort_line_id == $amort.amort_line_id}}
				{{:assign keep=false}}
				{{:break}}
			{{/if}}
		{{else}}
			{{:assign keep=false}}
		{{/load}}
		{{if $keep}}
			{{:assign var="autres_amortissements." value=$amort}}
		{{/if}}
	{{else}}
		{{:assign var="autres_amortissements." value=$amort}}
	{{/select}}
{{/select}}

{{:admin_header title="Amortissements non rattachés" custom_css="./style.css" current="module_amortization"}}

{{* barre de navigation *}}
{{if ! $dialog}}
	{{:include
		file="_nav.html"
		current="index"
		subcurrent="other"
		subsubcurrent="amortization"
		type_immo="other"
		autres_amort=$autres_amortissements
}}
{{/if}}

{{if $autres_amortissements != null}}
	<section class="amortissement">
		<h3 class="ruler">Immobilisation « {{$ligne_immo.label}} »</h3>
		<table class="list">
			<thead>
				<tr>
					<th>N°</th>
					<th>Date</th>
					<th class="nombre">Montant</th>
					<th>Libellé</th>
					<th>N° compte</th>
					<th>Compte</th>
					<th class="actions"></th>
				</tr>
			</thead>
			<tbody>
				{{#foreach from=$autres_amortissements item="line"}}
					{{:assign trans_url="%s/acc/transactions/details.php?id=%s"|args:$admin_url:$line.amort_trans_id}}
					{{:assign compte_url="%s/acc/accounts/journal.php?id=%s&year=%s"|args:$admin_url:$line.account_id:$line.amort_year}}
					<tr>
						<td class="num"><a href={{$trans_url}}>#{{$line.amort_trans_id}}</a></td>
						<td>{{$line.trans_date|date_short}}</td>
						<td class="money">{{"%f"|math:$line.amort_amount|money_html:false|raw}}</td>
						<td>{{$line.trans_label}}
							{{if $line.line_label != null}} - {{$line.line_label}}{{/if}}
						</td>
						<td><a href={{$compte_url}}>{{$line.account_code}}</a></td>
						<td>{{$line.account_label}}</td>
						<td>
							{{:linkbutton label="Attacher" href="attach_amort.html?amort_id=%d&immo_id=%d"|args:$line.amort_line_id:$_GET.immo_id shape="plus"}}
						</td>
					</tr>
				{{/foreach}}
			</tbody>
		</table>
	</section>
{{/if}}
{{:form_errors}}
{{:admin_footer}}