money.mlt

   1 <% @header [("title", ["MoneyMatters"])];
   2
   3 ref showNormal = true;
   4
   5 if $"cmd" = "list" then
   6         val admin = Group.inGroupName "money";
   7         showNormal := false %>
   8
   9 <h3><b>Transactions</b></h3>
  10
  11 <table>
  12 <tr> <td><b>Date</b></td> <td><b>Description</b></td> <td><b>Amount</b></td> <td><b>Last modified</b></td> <td><b>Participants</b></td> </tr>
  13 <% foreach trn in Money.listTransactions () do %>
  14 <tr> <td><% #d trn %></td> <td><a href="money?trn=<% #id trn %>"><% Web.html (#descr trn) %></a></td> <td><% #amount trn %></td> <td><% #stamp trn %></td>
  15 <% switch Money.listChargesWithNames (#id trn) of
  16           [(name, cha)] => %><td><a href="user?id=<% #usr cha %>"><% name %></a></td><%
  17         | _ => %><td><i>multi</i></td><%
  18 end;
  19 if admin then
  20         %><td><a href="money?modHosting=<% #id trn %>">[Hosting]</a> <a href="money?modPay=<% #id trn %>">[Payment]</a> <a href="money?modEven=<% #id trn %>">[Other]</a></td>
  21         <td><a href="money?del=<% #id trn %>">[Delete]</a></td><%
  22 end
  23 %></tr><%
  24 end %>
  25 </table>
  26
  27 <% elseif $"cmd" = "bals" then
  28         showNormal := false %>
  29
  30 <h3><b>Balances</b></h3>
  31
  32 <table>
  33 <% foreach bal in Balance.listBalances () do %>
  34 <tr><td><% #name bal %></td> <td><% #amount bal %></td> <td>
  35 <% switch Balance.listBalanceUsers (#id bal) of
  36           [] =>
  37         | (user :: users) =>
  38                 %><a href="user?id=<% #id user %>"><% Web.html (#name user) %></a><%
  39                 foreach user in users do
  40                         %>, <a href="user?id=<% # id user %>"><% Web.html (#name user) %></a><%
  41                 end
  42 end %></td> </tr>
  43 <% end %>
  44 </table>
  45
  46 <% elseif $"cmd" = "hosting" then
  47         Group.requireGroupName "money";
  48         showNormal := false %>
  49
  50 <h3><b>New hosting bill</b></h3>
  51
  52 <form action="money">
  53 <input type="hidden" name="cmd" value="hosting2">
  54 <table>
  55 <tr> <td align="right"><b>Description</b>:</td> <td><input name="descr"></td> </tr>
  56 <tr> <td align="right"><b>Date</b>:</td> <td><input name="d"></td> </tr>
  57 <tr> <td align="right"><b>Amount</b>:</td> <td><input name="amount"></td> </tr>
  58 <tr> <td align="right"><b>Free bandwidth cutoff (MB)</b>:</td> <td><input name="cutoff" value="200"></td> </tr>
  59 <tr> <td align="right"><b>Cost/GB</b>:</td> <td><input name="cost" value="4"></td> </tr>
  60 <tr> <td align="right" valign="top"><b>Member usage</b>:</td> <td><textarea wrap="soft" name="usage" rows="24" cols="80"></textarea></td> </tr>
  61 <tr> <td><input type="submit" value="Add"></td> </tr>
  62 </table>
  63
  64 <% elseif $"cmd" = "hosting2" then
  65         Group.requireGroupName "money";
  66         val id = Money.addTransaction ($"descr", Util.neg (Web.stor ($"amount")), $"d");
  67         Money.addHostingCharges {trn = id, cutoff = 1000 * Web.stoi ($"cutoff"), cost = Web.stor ($"cost"), usage = $"usage"};
  68
  69         %><h3><b>Hosting transaction added.</b></h3>
  70
  71 <% elseif $"modHosting" <> "" then
  72         Group.requireGroupName "money";
  73         showNormal := false;
  74         val id = Web.stoi ($"modHosting");
  75         val trn = Money.lookupTransaction id %>
  76
  77 <h3><b>Modify hosting bill</b></h3>
  78
  79 <form action="money">
  80 <input type="hidden" name="saveHosting" value="<% id %>">
  81 <table>
  82 <tr> <td align="right"><b>Description</b>:</td> <td><input name="descr" value="<% Web.html (#descr trn) %>"></td> </tr>
  83 <tr> <td align="right"><b>Date</b>:</td> <td><input name="d" value="<% Web.html (#d trn) %>"></td> </tr>
  84 <tr> <td align="right"><b>Amount</b>:</td> <td><input name="amount" value="<% Util.neg (#amount trn) %>"></td> </tr>
  85 <tr> <td align="right"><b>Free bandwidth cutoff (MB)</b>:</td> <td><input name="cutoff" value="200"></td> </tr>
  86 <tr> <td align="right"><b>Cost/GB</b>:</td> <td><input name="cost" value="4"></td> </tr>
  87 <tr> <td align="right" valign="top"><b>Member usage</b>:</td> <td><textarea wrap="soft" name="usage" rows="24" cols="80"></textarea></td> </tr>
  88 <tr> <td><input type="submit" value="Save"></td> </tr>
  89 </table>
  90
  91 <% elseif $"saveHosting" <> "" then
  92         Group.requireGroupName "money";
  93         val id = Web.stoi ($"saveHosting");
  94         val trn = Money.lookupTransaction id;
  95
  96         Money.clearCharges id;
  97         Money.modTransaction {trn with descr = $"descr", d = $"d", amount = Util.neg (Web.stor ($"amount"))};
  98         Money.addHostingCharges {trn = id, cutoff = 1000 * Web.stoi ($"cutoff"), cost = Web.stor ($"cost"), usage = $"usage"};
  99
 100         %><h3><b>Hosting transaction modified.</b></h3>
 101
 102 <% elseif $"cmd" = "evenForm" then
 103         Group.requireGroupName "money";
 104         showNormal := false %>
 105 <h3><b>New generic/even transaction</b></h3>
 106 <form action="money">
 107 <input type="hidden" name="cmd" value="even">
 108 <table>
 109 <tr> <td align="right"><b>Description</b>:</td> <td><input name="descr"></td> </tr>
 110 <tr> <td align="right"><b>Date</b>:</td> <td><input name="d"></td> </tr>
 111 <tr> <td align="right"><b>Amount</b>:</td> <td><input name="amount"></td> </tr>
 112 <tr> <td align="right" valign="top"><b>Members</b>:</td> <td><select name="usrs" size="5" multiple>
 113 <% foreach usr in Init.listUsers () do %>
 114         <option value="<% #id usr %>"><% #name usr %></option>
 115 <% end %>
 116 </select></td> </tr>
 117 <tr> <td><input type="submit" value="Add"></td> </tr>
 118 </table>
 119 </form>
 120
 121 <% elseif $"cmd" = "pay" then
 122         Group.requireGroupName "money";
 123         showNormal := false %>
 124
 125 <h3><b>New member payment</b></h3>
 126
 127 <form action="money">
 128 <input type="hidden" name="cmd" value="pay2">
 129 <table>
 130 <tr> <td align="right"><b>Description</b>:</td> <td><input name="descr"></td> </tr>
 131 <tr> <td align="right"><b>Date</b>:</td> <td><input name="d"></td> </tr>
 132 <tr> <td align="right"><b>Amount</b>:</td> <td><input name="amount"></td> </tr>
 133 <tr> <td align="right" valign="top"><b>Member</b>:</td> <td><select name="usr">
 134 <% foreach usr in Init.listUsers () do %>
 135         <option value="<% #id usr %>"><% #name usr %></option>
 136 <% end %>
 137 </select></td> </tr>
 138 <tr> <td><input type="submit" value="Add"></td> </tr>
 139 </table>
 140 </form>
 141
 142 <% elseif $"cmd" = "pay2" then
 143         Group.requireGroupName "money";
 144         val amount = Web.stor ($"amount");
 145         val id = Money.addTransaction ($"descr", amount, $"d");
 146         Money.addCharge {trn = id, usr = Web.stoi ($"usr"), amount = amount};
 147         Money.applyCharges id;
 148
 149         %><h3><b>Payment transaction added.</b></h3>
 150
 151 <% elseif $"modPay" <> "" then
 152         Group.requireGroupName "money";
 153         showNormal := false;
 154         val id = Web.stoi ($"modPay");
 155         val trn = Money.lookupTransaction id %>
 156
 157 <h3><b>Modify member payment</b></h3>
 158
 159 <form action="money">
 160 <input type="hidden" name="savePay" value="<% id %>">
 161 <table>
 162 <tr> <td align="right"><b>Description</b>:</td> <td><input name="descr" value="<% Web.html (#descr trn) %>"></td> </tr>
 163 <tr> <td align="right"><b>Date</b>:</td> <td><input name="d" value="<% Web.html (#d trn) %>"></td> </tr>
 164 <tr> <td align="right"><b>Amount</b>:</td> <td><input name="amount" value="<% Util.neg (#amount trn) %>"></td> </tr>
 165 <tr> <td align="right" valign="top"><b>Member</b>:</td> <td><select name="usr">
 166 <% foreach (sel, usr) in Money.listUsers (#id trn) do %>
 167         <option value="<% #id usr %>"<% if sel then %> selected<% end %>><% #name usr %></option>
 168 <% end %>
 169 </td></tr>
 170 <tr> <td><input type="submit" value="Save"></td> </tr>
 171 </table>
 172
 173 <% elseif $"savePay" <> "" then
 174         Group.requireGroupName "money";
 175         val id = Web.stoi ($"savePay");
 176         val trn = Money.lookupTransaction id;
 177
 178         val amount = Web.stor ($"amount");
 179         Money.clearCharges id;
 180         Money.modTransaction {trn with descr = $"descr", d = $"d", amount = amount};
 181         Money.addCharge {trn = id, usr = Web.stoi ($"usr"), amount = amount};
 182         Money.applyCharges id;
 183
 184         %><h3><b>Member payment modified.</b></h3>
 185
 186 <% elseif $"cmd" = "evenForm" then
 187         Group.requireGroupName "money";
 188         showNormal := false %>
 189 <h3><b>New generic/even transaction</b></h3>
 190 <form action="money">
 191 <input type="hidden" name="cmd" value="even">
 192 <table>
 193 <tr> <td align="right"><b>Description</b>:</td> <td><input name="descr"></td> </tr>
 194 <tr> <td align="right"><b>Date</b>:</td> <td><input name="d"></td> </tr>
 195 <tr> <td align="right"><b>Amount</b>:</td> <td><input name="amount"></td> </tr>
 196 <tr> <td align="right" valign="top"><b>Members</b>:</td> <td><select name="usrs" size="5" multiple>
 197 <% foreach usr in Init.listUsers () do %>
 198         <option value="<% #id usr %>"><% #name usr %></option>
 199 <% end %>
 200 </select></td> </tr>
 201 <tr> <td><input type="submit" value="Add"></td> </tr>
 202 </table>
 203 </form>
 204
 205 <% elseif $"cmd" = "even" then
 206         Group.requireGroupName "money";
 207         val id = Money.addTransaction ($"descr", Web.stor ($"amount"), $"d");
 208         Money.addEvenCharges (id, map Web.stoi (Web.getMultiParam "usrs"))
 209
 210         %><h3><b>Even transaction added.</b></h3>
 211
 212 <% elseif $"modEven" <> "" then
 213         Group.requireGroupName "money";
 214         showNormal := false;
 215         val trn = Money.lookupTransaction (Web.stoi ($"modEven")) %>
 216 <h3><b>Modify even transaction</b></h3>
 217
 218 <form action="money">
 219 <input type="hidden" name="saveEven" value="<% $"modEven" %>">
 220 <table>
 221 <tr> <td align="right"><b>Description</b>:</td> <td><input name="descr" value="<% Web.html (#descr trn) %>"></td> </tr>
 222 <tr> <td align="right"><b>Date</b>:</td> <td><input name="d" value="<% Web.html (#d trn) %>"></td> </tr>
 223 <tr> <td align="right"><b>Amount</b>:</td> <td><input name="amount" value="<% #amount trn %>"></td> </tr>
 224 <tr> <td align="right" valign="top"><b>Members</b>:</td> <td><select name="usrs" size="5" multiple>
 225 <% foreach (sel, usr) in Money.listUsers (#id trn) do %>
 226         <option value="<% #id usr %>"<% if sel then %> selected<% end %>><% #name usr %></option>
 227 <% end %>
 228 </select></td> </tr>
 229 <tr> <td><input type="submit" value="Save"></td> </tr>
 230 </table>
 231 </form>
 232
 233 <% elseif $"saveEven" <> "" then
 234         Group.requireGroupName "money";
 235         val id = Web.stoi ($"saveEven");
 236         val trn = Money.lookupTransaction id;
 237         Money.clearCharges id;
 238         Money.modTransaction {trn with descr = $"descr", d = $"d", amount = Web.stor ($"amount")};
 239         Money.addEvenCharges (id, map Web.stoi (Web.getMultiParam "usrs"))
 240
 241         %><h3><b>Even transaction modified</b></h3>
 242
 243 <% elseif $"del" <> "" then
 244         Group.requireGroupName "money";
 245         showNormal := false;
 246         val trn = Money.lookupTransaction (Web.stoi ($"del")) %>
 247         <h3><b>Are you sure you want to delete transaction <a href="money?trn=<% #id trn %>"><% Web.html (#descr trn) %></a>?</b></h3>
 248         <a href="money?del2=<% $"del" %>">Yes, delete <% Web.html (#descr trn) %>!</a>
 249
 250 <% elseif $"del2" <> "" then
 251         Group.requireGroupName "money";
 252         val id = Web.stoi ($"del2");
 253         val trn = Money.lookupTransaction id;
 254         Money.clearCharges id;
 255         Money.deleteTransaction id %>
 256         <h3><b><% Web.html (#descr trn) %> deleted!</b></h3>
 257
 258 <% elseif $"cmd" = "equalize" then
 259         Group.requireGroupName "money";
 260         Money.equalizeBalances ();
 261         %><h3><b>Balances equalized</b></h3>
 262
 263 <% elseif $"trn" <> "" then
 264         showNormal := false;
 265         val id = Web.stoi ($"trn");
 266         val trn = Money.lookupTransaction id %>
 267 <table>
 268 <tr> <td align="right"><b>TRN#</b>:</td> <td><% id %></td> </tr>
 269 <tr> <td align="right"><b>Description</b>:</td> <td><% Web.html (#descr trn) %></td> </tr>
 270 <tr> <td align="right"><b>Date</b>:</td> <td><% #d trn %></td> </tr>
 271 <tr> <td align="right"><b>Amount</b>:</td> <td>$<% #amount trn %></td> </tr>
 272 <tr> <td align="right" valign="top"><b>Distribution</b>:</td>
 273
 274 <% ref first = true;
 275 foreach (name, cha) in Money.listChargesWithNames id do
 276         if first then
 277                 first := false
 278         else
 279                 %><tr> <td></td> <%
 280         end
 281         %><td><a href="user?id=<% #usr cha %>"><% name %></a></td> <td>$<% #amount cha %></td> </tr><%
 282 end %>
 283 </table>
 284
 285 <% end %>
 286
 287 <% if showNormal then %>
 288
 289 <a href="money?cmd=list">List all transactions</a><br>
 290 <a href="money?cmd=bals">List all balances</a><br>
 291
 292 <% if Group.inGroupName "money" then %>
 293
 294 <br><b><u>New transaction:</u></b><br>
 295 <a href="money?cmd=hosting">Hosting bill</a><br>
 296 <a href="money?cmd=pay">Payment from member</a><br>
 297 <a href="money?cmd=evenForm">Generic/even</a><br>
 298 <br>
 299 <a href="money?cmd=equalize">Equalize balances</a><br>
 300
 301 <h3><b>Most recent transactions</b></h3>
 302
 303 <table>
 304 <tr> <td><b>Date</b></td> <td><b>Description</b></td> <td><b>Amount</b></td> <td><b>Participants</b></td> <td><b>Replace</b></td> <td><b>Delete</b></td> </tr>
 305 <% foreach trn in Money.listTransactionsLimit 20 do %>
 306 <tr> <td><% #d trn %></td> <td><a href="money?trn=<% #id trn %>"><% Web.html (#descr trn) %></a></td> <td><% #amount trn %></td>
 307 <% switch Money.listChargesWithNames (#id trn) of
 308           [(name, cha)] => %><td><a href="user?id=<% #usr cha %>"><% name %></a></td><%
 309         | _ => %><td><i>multi</i></td><%
 310 end %>
 311 <td><a href="money?modHosting=<% #id trn %>">[Hosting]</a> <a href="money?modPay=<% #id trn %>">[Payment]</a> <a href="money?modEven=<% #id trn %>">[Other]</a></td>
 312 <td><a href="money?del=<% #id trn %>">[Delete]</a></td> </tr>
 313 <% end %>
 314 </table>
 315
 316 <% else %>
 317
 318 <h3><b>Your recent account activity</b></h3>
 319
 320 <table>
 321 <tr> <td><b>Date</b></td> <td><b>Description</b></td> <td><b>Amount</b></td> </tr>
 322 <% foreach (amount, trn) in Money.listUserTransactionsLimit (Init.getUserId (), 20) do %>
 323 <tr> <td><% #d trn %></td> <td><a href="money?trn=<% #id trn %>"><% Web.html (#descr trn) %></a></td> <td><% amount %>/<% #amount trn %></td> </tr>
 324 <% end %>
 325 </table>
 326
 327 <% end
 328 end %>
 329
 330 <% @footer [] %>