75a36eb49b
- Add dual-sheet architecture to pull attendance from both adult and junior spreadsheets. - Introduce parsing rules to isolate juniors (e.g. above '# Treneri', tier 'J'). - Add new endpoints `/fees-juniors` and `/reconcile-juniors` to track junior attendances and match bank payments. - Display granular attendance components showing adult vs. junior practices. - Add fee rule configuration supporting custom pricing exceptions for specific months (e.g. Sep 2025) and merging billing periods. - Add `make sync-2025` target to the Makefile for convenience. - Document junior fees implementation logic and rules in prompts/outcomes. Co-authored-by: Antigravity <antigravity@google.com>
215 lines
5.5 KiB
HTML
215 lines
5.5 KiB
HTML
<!DOCTYPE html>
|
|
<html lang="en">
|
|
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<title>FUJ Payments Ledger</title>
|
|
<style>
|
|
body {
|
|
font-family: ui-monospace, SFMono-Regular, Menlo, Monaco, Consolas, "Liberation Mono", "Courier New", monospace;
|
|
background-color: #0c0c0c;
|
|
color: #cccccc;
|
|
padding: 10px;
|
|
margin: 0;
|
|
display: flex;
|
|
flex-direction: column;
|
|
align-items: center;
|
|
font-size: 11px;
|
|
line-height: 1.2;
|
|
}
|
|
|
|
h1 {
|
|
color: #00ff00;
|
|
font-family: inherit;
|
|
margin-top: 10px;
|
|
margin-bottom: 20px;
|
|
text-transform: uppercase;
|
|
letter-spacing: 1px;
|
|
font-size: 14px;
|
|
}
|
|
|
|
h2 {
|
|
color: #00ff00;
|
|
font-size: 12px;
|
|
margin-top: 30px;
|
|
margin-bottom: 5px;
|
|
text-transform: uppercase;
|
|
width: 100%;
|
|
max-width: 1000px;
|
|
border-bottom: 1px solid #333;
|
|
padding-bottom: 2px;
|
|
}
|
|
|
|
.nav {
|
|
margin-bottom: 20px;
|
|
font-size: 12px;
|
|
color: #555;
|
|
display: flex;
|
|
gap: 15px;
|
|
}
|
|
|
|
.nav a {
|
|
color: #00ff00;
|
|
text-decoration: none;
|
|
padding: 2px 8px;
|
|
border: 1px solid #333;
|
|
}
|
|
|
|
.nav a.active {
|
|
color: #000;
|
|
background-color: #00ff00;
|
|
border-color: #00ff00;
|
|
}
|
|
|
|
.nav a:hover {
|
|
color: #fff;
|
|
border-color: #555;
|
|
}
|
|
|
|
.description {
|
|
margin-bottom: 20px;
|
|
text-align: center;
|
|
color: #888;
|
|
max-width: 800px;
|
|
}
|
|
|
|
.description a {
|
|
color: #00ff00;
|
|
text-decoration: none;
|
|
}
|
|
|
|
.description a:hover {
|
|
text-decoration: underline;
|
|
}
|
|
|
|
.ledger-container {
|
|
width: 100%;
|
|
max-width: 1000px;
|
|
margin-bottom: 40px;
|
|
}
|
|
|
|
.member-block {
|
|
margin-bottom: 20px;
|
|
}
|
|
|
|
.txn-table {
|
|
border-collapse: collapse;
|
|
width: 100%;
|
|
margin-top: 5px;
|
|
}
|
|
|
|
.txn-table th,
|
|
.txn-table td {
|
|
padding: 2px 8px;
|
|
text-align: left;
|
|
border-bottom: 1px dashed #222;
|
|
}
|
|
|
|
.txn-table th {
|
|
color: #555;
|
|
text-transform: lowercase;
|
|
font-weight: normal;
|
|
border-bottom: 1px solid #333;
|
|
}
|
|
|
|
.txn-date {
|
|
min-width: 80px;
|
|
color: #888;
|
|
}
|
|
|
|
.txn-amount {
|
|
min-width: 80px;
|
|
text-align: right !important;
|
|
color: #00ff00;
|
|
}
|
|
|
|
.txn-purpose {
|
|
min-width: 100px;
|
|
color: #aaa;
|
|
}
|
|
|
|
.txn-message {
|
|
color: #666;
|
|
font-style: italic;
|
|
}
|
|
|
|
tr:hover {
|
|
background-color: #1a1a1a;
|
|
}
|
|
|
|
.footer {
|
|
margin-top: 50px;
|
|
margin-bottom: 20px;
|
|
color: #333;
|
|
font-size: 9px;
|
|
text-align: center;
|
|
width: 100%;
|
|
cursor: pointer;
|
|
user-select: none;
|
|
}
|
|
|
|
.perf-breakdown {
|
|
display: none;
|
|
margin-top: 5px;
|
|
color: #222;
|
|
}
|
|
</style>
|
|
</head>
|
|
|
|
<body>
|
|
<div class="nav">
|
|
<a href="/fees">[Attendance/Fees]</a>
|
|
<a href="/fees-juniors">[Junior Fees]</a>
|
|
<a href="/reconcile">[Payment Reconciliation]</a>
|
|
<a href="/reconcile-juniors">[Junior Reconciliation]</a>
|
|
<a href="/payments" class="active">[Payments Ledger]</a>
|
|
</div>
|
|
|
|
<h1>Payments Ledger</h1>
|
|
|
|
<div class="description">
|
|
All bank transactions from the Google Sheet, grouped by member.<br>
|
|
Source: <a href="{{ attendance_url }}" target="_blank">Attendance Sheet</a> |
|
|
<a href="{{ payments_url }}" target="_blank">Payments Ledger</a>
|
|
</div>
|
|
|
|
<div class="ledger-container">
|
|
{% for person in sorted_people %}
|
|
<div class="member-block">
|
|
<h2>{{ person }}</h2>
|
|
<table class="txn-table">
|
|
<thead>
|
|
<tr>
|
|
<th class="txn-date">Date</th>
|
|
<th class="txn-amount">Amount</th>
|
|
<th class="txn-purpose">Purpose</th>
|
|
<th class="txn-message">Bank Message</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
{% for tx in grouped_payments[person] %}
|
|
<tr>
|
|
<td class="txn-date">{{ tx.date }}</td>
|
|
<td class="txn-amount">{{ tx.amount }} CZK</td>
|
|
<td class="txn-purpose">{{ tx.purpose }}</td>
|
|
<td class="txn-message">{{ tx.message }}</td>
|
|
</tr>
|
|
{% endfor %}
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
{% endfor %}
|
|
</div>
|
|
|
|
{% set rt = get_render_time() %}
|
|
<div class="footer"
|
|
onclick="document.getElementById('perf-details').style.display = (document.getElementById('perf-details').style.display === 'block' ? 'none' : 'block')">
|
|
render time: {{ rt.total }}s
|
|
<div id="perf-details" class="perf-breakdown">
|
|
{{ rt.breakdown }}
|
|
</div>
|
|
</div>
|
|
</body>
|
|
|
|
</html> |