62 lines
2.6 KiB
HTML
62 lines
2.6 KiB
HTML
{% extends "base.html" %}
|
|
|
|
{% block title %}Signpost DB{% endblock %}
|
|
{% block page_title %}Signpost-database{% endblock %}
|
|
{% block loader_text %}Synchroniseren met Signpost...{% endblock %}
|
|
|
|
{% block content %}
|
|
<div class="card">
|
|
<div class="page-head">
|
|
<h2>📋 Signpost-toestellen</h2>
|
|
<div class="actions">
|
|
<form method="POST" action="{{ url_for('signpost_devices.sync_signpost') }}" style="margin:0" onsubmit="showLoader()">
|
|
<button type="submit" class="btn-secondary" title="Synchroniseer de lokale database met de live Signpost M4S-API">🔄 Sync met Signpost</button>
|
|
</form>
|
|
</div>
|
|
</div>
|
|
|
|
<form method="GET" action="{{ url_for('signpost_devices.signpost_database_overzicht') }}" class="search-bar">
|
|
<input type="text" name="query" placeholder="Zoek op Signpostnummer of serienummer..." value="{{ query or '' }}">
|
|
<button type="submit">🔍 Zoeken</button>
|
|
</form>
|
|
|
|
{% if message %}
|
|
<div class="alert">{{ message }}</div>
|
|
{% endif %}
|
|
|
|
{% if results %}
|
|
<div class="table-wrap">
|
|
<table>
|
|
<thead>
|
|
<tr>
|
|
<th>Signpostnummer</th>
|
|
<th>Serienummer</th>
|
|
<th>Model</th>
|
|
<th class="text-right">Aankoopbedrag</th>
|
|
<th>Aankoopdatum</th>
|
|
<th>Garantie</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
{% for row in results %}
|
|
<tr>
|
|
<td><strong>{{ row['Signpostnummer'] if row['Signpostnummer'] is defined else row[0] }}</strong></td>
|
|
<td class="mono">{{ row['Device_serienummer'] if row['Device_serienummer'] is defined else row[1] }}</td>
|
|
<td>{{ row['Device_model'] if row['Device_model'] is defined else row[2] }}</td>
|
|
<td class="text-right nowrap">
|
|
{% set bedrag = row['Aankoopbedrag'] if row['Aankoopbedrag'] is defined else row[3] %}
|
|
{% if bedrag %}€ {{ bedrag }}{% else %}-{% endif %}
|
|
</td>
|
|
<td class="nowrap">{{ row['Aankoopdatum'] if row['Aankoopdatum'] is defined else row[4] }}</td>
|
|
<td>{{ row['Garantie'] if row['Garantie'] is defined else row[5] }}</td>
|
|
</tr>
|
|
{% endfor %}
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
{% else %}
|
|
<p class="muted">Geen records gevonden in de database.</p>
|
|
{% endif %}
|
|
</div>
|
|
{% endblock %}
|