aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorNicolas Vigier <boklm@mageia.org>2013-05-16 20:26:52 +0000
committerNicolas Vigier <boklm@mageia.org>2013-05-16 20:26:52 +0000
commit248197504db43892159f18d6f1859b165c93c6e3 (patch)
treee265c7e10df5323f517e9eba4fe689bf2eb1d45d
parent4bcc832376e999f0e820e7cc1da6275b13fc0b09 (diff)
downloadmgatres-248197504db43892159f18d6f1859b165c93c6e3.tar
mgatres-248197504db43892159f18d6f1859b165c93c6e3.tar.gz
mgatres-248197504db43892159f18d6f1859b165c93c6e3.tar.bz2
mgatres-248197504db43892159f18d6f1859b165c93c6e3.tar.xz
mgatres-248197504db43892159f18d6f1859b165c93c6e3.zip
Add yearly and monthly transactions pages
git-svn-id: svn+ssh://svn.mageia.org/svn/soft/mga-treasurer/trunk@8283 5b7c3c08-40e5-403b-9995-ace06908e4af
-rw-r--r--NEWS1
-rw-r--r--tmpl/index.html8
-rw-r--r--tmpl/tra_row.html16
-rw-r--r--tmpl/transactions_by_month.html45
-rw-r--r--tmpl/transactions_by_year.html54
5 files changed, 124 insertions, 0 deletions
diff --git a/NEWS b/NEWS
index 8fae572..7793468 100644
--- a/NEWS
+++ b/NEWS
@@ -1,4 +1,5 @@
- sort transactions by category
+- add yearly and monthly transactions pages
Version 0.2
diff --git a/tmpl/index.html b/tmpl/index.html
index af713fa..f5976d1 100644
--- a/tmpl/index.html
+++ b/tmpl/index.html
@@ -44,6 +44,14 @@
[%- END -%]
</ul>
+ <h3>Accounts history</h3>
+
+ <ul>
+ [%- FOR year IN transactions.by_year.keys.sort.reverse -%]
+ <li><a href="y_[% year %].html">[%- year -%]</a></li>
+ [%- END -%]
+ </ul>
+
<h3>Grisbi</h3>
<p>
Mageia.Org accounts are managed using <a href="http://grisbi.org/">grisbi</a>.
diff --git a/tmpl/tra_row.html b/tmpl/tra_row.html
new file mode 100644
index 0000000..afe3f56
--- /dev/null
+++ b/tmpl/tra_row.html
@@ -0,0 +1,16 @@
+ <tr>
+ <td>[% date.format(tra.date) %]</td>
+ <td>[% tra.amount %]</td>
+ <td>[% tra.account %]</td>
+ <td>[% tra.who %]</td>
+ [% IF tra.trt %]
+ <td>Internal transfert</td>
+ [% ELSE %]
+ <td>[% tra.notes %]</td>
+ [% END %]
+ <td>[% tra.c_name %]
+ [% IF tra.sc_name %]
+ : [% tra.sc_name %]
+ [% END %]
+ </td>
+ </tr>
diff --git a/tmpl/transactions_by_month.html b/tmpl/transactions_by_month.html
new file mode 100644
index 0000000..063094e
--- /dev/null
+++ b/tmpl/transactions_by_month.html
@@ -0,0 +1,45 @@
+<html>
+ <head>
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
+ <title>[% config.sitename %]: Transactions for [% month %]</title>
+ </head>
+ <body>
+ <h1>Mageia.Org accounts transactions for month [% month %]</h1>
+ <h3>Summary</h3>
+ <ul>
+ <li>
+ <b>Start balance</b>: [% transactions.by_month.$month.start_balance %] Euros
+ </li>
+ <li>
+ <b>End balance</b>: [% transactions.by_month.$month.end_balance %] Euros
+ </li>
+ <li>
+ <b>Revenues</b>: [% transactions.by_month.$month.revenues %] Euros
+ </li>
+ <li>
+ <b>Expenses</b>: [% transactions.by_month.$month.expenses %] Euros
+ </li>
+ </ul>
+ <h3>By category</h3>
+ <ul>
+ [% FOR ca IN transactions.by_month.$month.ca_balance.keys %]
+ <li><b>[% transactions.by_ca.$ca.c_name %]</b>: [% transactions.by_month.$month.ca_balance.$ca %] Euros</b></li>
+ [%- END -%]
+ </ul>
+ <h3>Details</h3>
+ <table border="1">
+ <tr>
+ <th>Date</th>
+ <th>Amount</th>
+ <th>Account</th>
+ <th>Who</th>
+ <th>Notes</th>
+ <th>Category</th>
+ </tr>
+ [%- USE date(format='%Y/%m/%d') -%]
+ [%- FOR tra IN transactions.by_month.$month.transactions.sort('date').reverse %]
+ [%- INCLUDE tra_row.html %]
+ [%- END -%]
+ </table>
+ </body>
+</html>
diff --git a/tmpl/transactions_by_year.html b/tmpl/transactions_by_year.html
new file mode 100644
index 0000000..5ee0095
--- /dev/null
+++ b/tmpl/transactions_by_year.html
@@ -0,0 +1,54 @@
+<html>
+ <head>
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
+ <title>[% config.sitename %]: Transactions for [% year %]</title>
+ </head>
+ <body>
+ <h1>Mageia.Org accounts transactions for year [% year %]</h1>
+ <h3>Summary</h3>
+ <ul>
+ <li>
+ <b>Start balance</b>: [% transactions.by_year.$year.start_balance %] Euros
+ </li>
+ <li>
+ <b>End balance</b>: [% transactions.by_year.$year.end_balance %] Euros
+ </li>
+ <li>
+ <b>Revenues</b>: [% transactions.by_year.$year.revenues %] Euros
+ </li>
+ <li>
+ <b>Expenses</b>: [% transactions.by_year.$year.expenses %] Euros
+ </li>
+ </ul>
+ <h3>By category</h3>
+ <ul>
+ [% FOR ca IN transactions.by_year.$year.ca_balance.keys %]
+ <li><b>[% transactions.by_ca.$ca.c_name %]</b>: [% transactions.by_year.$year.ca_balance.$ca %] Euros</b></li>
+ [%- END -%]
+ </ul>
+ <h3>Monthly reports</h3>
+ <ul>
+ [%- FOR month IN transactions.by_month.keys.sort -%]
+ [%- IF transactions.by_month.$month.year == year -%]
+ <li><a href="m_[% month %].html">[% month %]</a></li>
+
+ [%- END -%]
+ [%- END -%]
+ </ul>
+ <h3>Details</h3>
+ <table border="1">
+ <tr>
+ <th>Date</th>
+ <th>Amount</th>
+ <th>Account</th>
+ <th>Who</th>
+ <th>Notes</th>
+ <th>Category</th>
+ </tr>
+ [%- USE date(format='%Y/%m/%d') -%]
+ [% FOR tra IN transactions.by_year.$year.transactions.sort('date').reverse %]
+ [%- INCLUDE tra_row.html %]
+ [%- END -%]
+ </table>
+ </body>
+</html>