Join script should rule out retired usernames
[bpt/portal.git] / money.mlt
1 <% @header [("title", ["MoneyMatters"])];
2
3 val root = Group.inGroupNum 0;
4
5 ref showNormal = true;
6
7 if $"hist" <> "" then
8 showNormal := false;
9 val id = Web.stoi ($"hist") %>
10 <table>
11 <tr> <td><b>Date</b></td> <td><b>Description</b></td> <td><b>Amount</b></td> </tr>
12 <% foreach (amount, trn) in Money.listUserTransactions id do %>
13 <tr> <td><% #d trn %></td> <td><a href="money?trn=<% #id trn %>"><% Web.html (#descr trn) %></a></td> <td><% amount %>/<% #amount trn %></td> </tr>
14 <% end %>
15 </table>
16
17 <% elseif $"cmd" = "list" then
18 val admin = Group.inGroupName "money";
19 showNormal := false %>
20
21 <h3>Transactions</h3>
22
23 <table>
24 <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>
25 <% foreach trn in Money.listTransactions () do %>
26 <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>
27 <% switch Money.listChargesWithNames (#id trn) of
28 [(name, cha)] => %><td><a href="user?id=<% #usr cha %>"><% name %></a></td><%
29 | _ => %><td><i>multi</i></td><%
30 end;
31 if admin then
32 %><td><a href="money?modBill=<% #id trn %>">[Bill]</a> <a href="money?modPay=<% #id trn %>">[Payment]</a> <a href="money?modEven=<% #id trn %>">[Other]</a></td>
33 <td><a href="money?del=<% #id trn %>">[Delete]</a></td><%
34 end
35 %></tr><%
36 end %>
37 </table>
38
39 <% elseif $"cmd" = "primary" then
40 val admin = Group.inGroupName "money";
41 showNormal := false %>
42
43 <h3>Primary Transactions</h3>
44
45 <table>
46 <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>
47 <% foreach (amt, trn) in Money.listUserTransactions (valOf (Init.userNameToId "hcoop")) do %>
48 <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>
49 <% switch Money.listChargesWithNames (#id trn) of
50 [(name, cha)] => %><td><a href="user?id=<% #usr cha %>"><% name %></a></td><%
51 | _ => %><td><i>multi</i></td><%
52 end;
53 if admin then
54 %><td><a href="money?modBill=<% #id trn %>">[Bill]</a> <a href="money?modPay=<% #id trn %>">[Payment]</a> <a href="money?modEven=<% #id trn %>">[Other]</a></td>
55 <td><a href="money?del=<% #id trn %>">[Delete]</a></td><%
56 end
57 %></tr><%
58 end %>
59 </table>
60
61 <% elseif $"cmd" = "bals" then
62 showNormal := false %>
63
64 <h3>Active Balances</h3>
65
66 <table>
67 <% foreach bal in Balance.listOwnedBalances () do %>
68 <tr><td><% #name bal %></td> <td><% #amount bal %></td> <td>
69 <% switch Balance.listBalanceUsers (#id bal) of
70 [] =>
71 | (user :: users) =>
72 %><a href="money?hist=<% #id user %>"><% Web.html (#name user) %></a> <a href="money?hist=<% #id user %>">[History]</a><%
73 foreach user in users do
74 %>, <a href="money?hist=<% # id user %>"><% Web.html (#name user) %></a><%
75 end
76 end %></td> </tr>
77 <% end %>
78 </table>
79
80 <% elseif $"cmd" = "deadbals" then
81 showNormal := false %>
82
83 <h3>Retired Balances</h3>
84
85 <table>
86 <% foreach bal in Balance.listUnownedBalances () do %>
87 <tr><td><% #name bal %></td> <td><% #amount bal %></td> <td>
88 <% switch Balance.listBalanceUsers (#id bal) of
89 [] =>
90 | (user :: users) =>
91 %><a href="user?id=<% #id user %>"><% Web.html (#name user) %></a> <a href="money?hist=<% #id user %>">[History]</a><%
92 foreach user in users do
93 %>, <a href="user?id=<% #id user %>"><% Web.html (#name user) %></a> <a href="money?hist=<% #id user %>">[History]</a><%
94 end
95 end %></td> </tr>
96 <% end %>
97 </table>
98
99 <% elseif $"cmd" = "nbals" then
100 showNormal := false;
101 val bals = Balance.listNegativeOwnedBalances () %>
102
103 <h3>Negative Active Balances (<% length bals %>)</h3>
104
105 <table>
106 <% foreach bal in bals do %>
107 <tr><td><% #name bal %></td> <td><% #amount bal %></td> <td>
108 <% switch Balance.listBalanceUsers (#id bal) of
109 [] =>
110 | (user :: users) =>
111 %><a href="user?id=<% #id user %>"><% Web.html (#name user) %></a> <a href="money?hist=<% #id user %>">[History]</a><%
112 foreach user in users do
113 %>, <a href="user?id=<% #id user %>"><% Web.html (#name user) %></a> <a href="money?hist=<% #id user %>">[History]</a><%
114 end
115 end %></td> </tr>
116 <% end %>
117 </table>
118
119 <% elseif $"cmd" = "hosting" then
120 Group.requireGroupName "money";
121 showNormal := false %>
122
123 <h3>New hosting bill</h3>
124
125 <form action="money" method="post">
126 <input type="hidden" name="cmd" value="hosting2">
127 <table class="blanks">
128 <tr> <td>Description:</td> <td><input name="descr"></td> </tr>
129 <tr> <td>Date:</td> <td><input name="d"></td> </tr>
130 <tr> <td>Amount:</td> <td><input name="amount"></td> </tr>
131 <tr> <td>Free bandwidth cutoff (MB):</td> <td><input name="cutoff" value="200"></td> </tr>
132 <tr> <td>Cost/GB:</td> <td><input name="cost" value="4"></td> </tr>
133 <tr> <td>Member usage:</td> <td><textarea wrap="soft" name="usage" rows="24" cols="80"></textarea></td> </tr>
134 <tr> <td><input type="submit" value="Add"></td> </tr>
135 </table>
136
137 <% elseif $"cmd" = "hosting2" then
138 Group.requireGroupName "money";
139 val id = Money.addTransaction ($"descr", Util.neg (Web.stor ($"amount")), $"d");
140 Money.addHostingCharges {trn = id, cutoff = 1000 * Web.stoi ($"cutoff"), cost = Web.stor ($"cost"), usage = $"usage"};
141
142 %><h3>Hosting transaction added.</h3>
143
144 <% elseif $"modHosting" <> "" then
145 Group.requireGroupName "money";
146 showNormal := false;
147 val id = Web.stoi ($"modHosting");
148 val trn = Money.lookupTransaction id %>
149
150 <h3>Modify hosting bill</h3>
151
152 <form action="money" method="post">
153 <input type="hidden" name="saveHosting" value="<% id %>">
154 <table class="blanks">
155 <tr> <td>Description:</td> <td><input name="descr" value="<% Web.html (#descr trn) %>"></td> </tr>
156 <tr> <td>Date:</td> <td><input name="d" value="<% Web.html (#d trn) %>"></td> </tr>
157 <tr> <td>Amount:</td> <td><input name="amount" value="<% Util.neg (#amount trn) %>"></td> </tr>
158 <tr> <td>Free bandwidth cutoff (MB):</td> <td><input name="cutoff" value="200"></td> </tr>
159 <tr> <td>Cost/GB:</td> <td><input name="cost" value="4"></td> </tr>
160 <tr> <td>Member usage:</td> <td><textarea wrap="soft" name="usage" rows="24" cols="80"><%
161 switch Money.lookupHostingUsage id of
162 SOME s => s
163 end %></textarea></td> </tr>
164 <tr> <td><input type="submit" value="Save"></td> </tr>
165 </table>
166
167 <% elseif $"saveHosting" <> "" then
168 Group.requireGroupName "money";
169 val id = Web.stoi ($"saveHosting");
170 val trn = Money.lookupTransaction id;
171
172 Money.clearCharges id;
173 Money.modTransaction {trn with descr = $"descr", d = $"d", amount = Util.neg (Web.stor ($"amount"))};
174 Money.addHostingCharges {trn = id, cutoff = 1000 * Web.stoi ($"cutoff"), cost = Web.stor ($"cost"), usage = $"usage"};
175
176 %><h3>Hosting transaction modified.</h3>
177
178 <% elseif $"cmd" = "bill" then
179 Group.requireGroupName "money";
180 showNormal := false %>
181
182 <h3>New bill for the co-op</h3>
183
184 <form action="money" method="post">
185 <input type="hidden" name="cmd" value="bill2">
186 <table class="blanks">
187 <tr> <td>Description:</td> <td><input name="descr"></td> </tr>
188 <tr> <td>Date:</td> <td><input name="d"></td> </tr>
189 <tr> <td>Amount:</td> <td><input name="amount"></td> </tr>
190 <tr> <td><input type="submit" value="Add"></td> </tr>
191 </table>
192
193 <% elseif $"cmd" = "bill2" then
194 Group.requireGroupName "money";
195 val id = Money.addTransaction ($"descr", Util.neg (Web.stor ($"amount")), $"d");
196 Money.addCharge {trn = id, usr = valOf (Init.userNameToId "hcoop"), amount = Util.neg (Web.stor ($"amount"))};
197 Money.applyCharges id;
198
199 %><h3>Bill added.</h3>
200
201 <% elseif $"modBill" <> "" then
202 Group.requireGroupName "money";
203 showNormal := false;
204 val id = Web.stoi ($"modBill");
205 val trn = Money.lookupTransaction id %>
206
207 <h3>Modify bill</h3>
208
209 <form action="money" method="post">
210 <input type="hidden" name="saveBill" value="<% id %>">
211 <table class="blanks">
212 <tr> <td>Description:</td> <td><input name="descr" value="<% Web.html (#descr trn) %>"></td> </tr>
213 <tr> <td>Date:</td> <td><input name="d" value="<% Web.html (#d trn) %>"></td> </tr>
214 <tr> <td>Amount:</td> <td><input name="amount" value="<% Util.neg (#amount trn) %>"></td> </tr>
215 <tr> <td><input type="submit" value="Save"></td> </tr>
216 </table>
217
218 <% elseif $"saveBill" <> "" then
219 Group.requireGroupName "money";
220 val id = Web.stoi ($"saveBill");
221 val trn = Money.lookupTransaction id;
222
223 Money.clearCharges id;
224 Money.modTransaction {trn with descr = $"descr", d = $"d", amount = Util.neg (Web.stor ($"amount"))};
225 Money.addCharge {trn = id, usr = valOf (Init.userNameToId "hcoop"), amount = Util.neg (Web.stor ($"amount"))};
226 Money.applyCharges id;
227
228 %><h3>Bill modified.</h3>
229
230 <% elseif $"cmd" = "evenForm" then
231 Group.requireGroupName "money";
232 showNormal := false %>
233 <h3>New generic/even transaction</h3>
234 <form action="money" method="post">
235 <input type="hidden" name="cmd" value="even">
236 <table class="blanks">
237 <tr> <td>Description:</td> <td><input name="descr"></td> </tr>
238 <tr> <td>Date:</td> <td><input name="d"></td> </tr>
239 <tr> <td>Amount:</td> <td><input name="amount"></td> </tr>
240 <tr> <td>Members:</td> <td><select name="usrs" size="5" multiple>
241 <% foreach usr in Init.listUsers () do %>
242 <option value="<% #id usr %>"><% #name usr %></option>
243 <% end %>
244 </select></td> </tr>
245 <tr> <td><input type="submit" value="Add"></td> </tr>
246 </table>
247 </form>
248
249 <% elseif $"cmd" = "pay" then
250 Group.requireGroupName "money";
251 val uid = (case $"user" of "" => ~1 | s => Web.stoi s);
252 showNormal := false %>
253
254 <h3>New member payment</h3>
255
256 <form action="money" method="post">
257 <input type="hidden" name="cmd" value="pay2">
258 <table class="blanks">
259 <tr> <td>Description:</td> <td><select name="descr">
260 <option<% if $"checkout" = "" then %> selected<% end %>>PayPal</option>
261 <option<% if $"checkout" <> "" then %> selected<% end %>>Google Checkout</option>
262 <option>Check</option>
263 <option>Direct transfer</option>
264 <option value="">Other:</option>
265 </select> <input name="descr2"></td> </tr>
266 <tr> <td>Date:</td> <td><input name="d" value="<% Web.html (Date.fmt "%B %d, %Y" (Date.fromTimeLocal (Time.now ()))) %>"></td> </tr>
267 <tr> <td>Amount:</td> <td><input name="amount"></td> </tr>
268 <tr> <td>Member:</td> <td><select name="usr">
269 <% foreach usr in Init.listUsers () do %>
270 <option value="<% #id usr %>"<% if #id usr = uid then %> selected<% end %>><% #name usr %></option>
271 <% end %>
272 </select></td> </tr>
273 <tr> <td><input type="submit" value="Add"></td> </tr>
274 </table>
275 </form>
276
277 <% elseif $"cmd" = "pay2" then
278 Group.requireGroupName "money";
279 val amount = Web.stor ($"amount");
280 val descr = $"descr";
281 val descr = iff descr = "" then $"descr2" else descr;
282 val id = Money.addTransaction (descr, amount, $"d");
283 Money.addCharge {trn = id, usr = Web.stoi ($"usr"), amount = amount};
284 Money.applyCharges id;
285
286 %><h3>Payment transaction added.</h3>
287
288 <% elseif $"modPay" <> "" then
289 Group.requireGroupName "money";
290 showNormal := false;
291 val id = Web.stoi ($"modPay");
292 val trn = Money.lookupTransaction id %>
293
294 <h3>Modify member payment</h3>
295
296 <form action="money" method="post">
297 <input type="hidden" name="savePay" value="<% id %>">
298 <table class="blanks">
299 <tr> <td>Description:</td> <td><input name="descr" value="<% Web.html (#descr trn) %>"></td> </tr>
300 <tr> <td>Date:</td> <td><input name="d" value="<% Web.html (#d trn) %>"></td> </tr>
301 <tr> <td>Amount:</td> <td><input name="amount" value="<% #amount trn %>"></td> </tr>
302 <tr> <td>Member:</td> <td><select name="usr">
303 <% foreach (sel, usr) in Money.listUsers (#id trn) do %>
304 <option value="<% #id usr %>"<% if sel then %> selected<% end %>><% #name usr %></option>
305 <% end %>
306 </td></tr>
307 <tr> <td><input type="submit" value="Save"></td> </tr>
308 </table>
309
310 <% elseif $"savePay" <> "" then
311 Group.requireGroupName "money";
312 val id = Web.stoi ($"savePay");
313 val trn = Money.lookupTransaction id;
314
315 val amount = Web.stor ($"amount");
316 Money.clearCharges id;
317 Money.modTransaction {trn with descr = $"descr", d = $"d", amount = amount};
318 Money.addCharge {trn = id, usr = Web.stoi ($"usr"), amount = amount};
319 Money.applyCharges id;
320
321 %><h3>Member payment modified.</h3>
322
323 <% elseif $"cmd" = "evenForm" then
324 Group.requireGroupName "money";
325 showNormal := false %>
326 <h3>New generic/even transaction</h3>
327 <form action="money" method="post">
328 <input type="hidden" name="cmd" value="even">
329 <table class="blanks">
330 <tr> <td>Description:</td> <td><input name="descr"></td> </tr>
331 <tr> <td>Date:</td> <td><input name="d"></td> </tr>
332 <tr> <td>Amount:</td> <td><input name="amount"></td> </tr>
333 <tr> <td>Members:</td> <td><select name="usrs" size="5" multiple>
334 <% foreach usr in Init.listUsers () do %>
335 <option value="<% #id usr %>"><% #name usr %></option>
336 <% end %>
337 </select></td> </tr>
338 <tr> <td><input type="submit" value="Add"></td> </tr>
339 </table>
340 </form>
341
342 <% elseif $"cmd" = "dues" then
343 Group.requireGroupName "money";
344 showNormal := false %>
345
346 <h3>Monthly dues</h3>
347
348 <form action="money" method="post">
349 <input type="hidden" name="cmd" value="dues2">
350 <table class="blanks">
351 <tr> <td>Description:</td> <td><input name="descr" value="Dues"></td> </tr>
352 <tr> <td>Date:</td> <td><input name="d"></td> </tr>
353 <tr> <td>Amount/pledge:</td> <td><input name="base"></td> </tr>
354 <tr> <td><input type="submit" value="Add"></td> </tr>
355 </table>
356
357 <% elseif $"cmd" = "dues2" then
358 Group.requireGroupName "money";
359 Money.billDues {descr = $"descr", base = Web.stor ($"base"), date = $"d"};
360
361 %><h3>Dues debits added.</h3>
362
363 <% elseif $"cmd" = "even" then
364 Group.requireGroupName "money";
365 val id = Money.addTransaction ($"descr", Web.stor ($"amount"), $"d");
366 Money.addEvenCharges (id, map Web.stoi (Web.getMultiParam "usrs"))
367
368 %><h3>Even transaction added.</h3>
369
370 <% elseif $"modEven" <> "" then
371 Group.requireGroupName "money";
372 showNormal := false;
373 val trn = Money.lookupTransaction (Web.stoi ($"modEven")) %>
374 <h3>Modify even transaction</h3>
375
376 <form action="money" method="post">
377 <input type="hidden" name="saveEven" value="<% $"modEven" %>">
378 <table class="blanks">
379 <tr> <td>Description:</td> <td><input name="descr" value="<% Web.html (#descr trn) %>"></td> </tr>
380 <tr> <td>Date:</td> <td><input name="d" value="<% Web.html (#d trn) %>"></td> </tr>
381 <tr> <td>Amount:</td> <td><input name="amount" value="<% #amount trn %>"></td> </tr>
382 <tr> <td>Members:</td> <td><select name="usrs" size="5" multiple>
383 <% foreach (sel, usr) in Money.listUsers (#id trn) do %>
384 <option value="<% #id usr %>"<% if sel then %> selected<% end %>><% #name usr %></option>
385 <% end %>
386 </select></td> </tr>
387 <tr> <td><input type="submit" value="Save"></td> </tr>
388 </table>
389 </form>
390
391 <% elseif $"saveEven" <> "" then
392 Group.requireGroupName "money";
393 val id = Web.stoi ($"saveEven");
394 val trn = Money.lookupTransaction id;
395 Money.clearCharges id;
396 Money.modTransaction {trn with descr = $"descr", d = $"d", amount = Web.stor ($"amount")};
397 Money.addEvenCharges (id, map Web.stoi (Web.getMultiParam "usrs"))
398
399 %><h3>Even transaction modified</h3>
400
401 <% elseif $"del" <> "" then
402 Group.requireGroupName "money";
403 showNormal := false;
404 val trn = Money.lookupTransaction (Web.stoi ($"del")) %>
405 <h3>Are you sure you want to delete transaction <a href="money?trn=<% #id trn %>"><% Web.html (#descr trn) %></a>?</h3>
406 <a href="money?del2=<% $"del" %>">Yes, delete <% Web.html (#descr trn) %>!</a>
407
408 <% elseif $"del2" <> "" then
409 Group.requireGroupName "money";
410 val id = Web.stoi ($"del2");
411 val trn = Money.lookupTransaction id;
412 Money.clearCharges id;
413 Money.deleteTransaction id %>
414 <h3><% Web.html (#descr trn) %> deleted!</h3>
415
416 <% elseif $"cmd" = "equalize" then
417 Group.requireGroupName "money";
418 Money.equalizeBalances ();
419 %><h3>Balances equalized</h3>
420
421 <% elseif $"trn" <> "" then
422 showNormal := false;
423 val id = Web.stoi ($"trn");
424 val trn = Money.lookupTransaction id %>
425 <table class="blanks">
426 <tr> <td>TRN#:</td> <td><% id %></td> </tr>
427 <tr> <td>Description:</td> <td><% Web.html (#descr trn) %></td> </tr>
428 <tr> <td>Date:</td> <td><% #d trn %></td> </tr>
429 <tr> <td>Amount:</td> <td>$<% #amount trn %></td> </tr>
430 <tr> <td>Distribution:</td>
431
432 <% ref first = true;
433 foreach (name, cha) in Money.listChargesWithNames id do
434 if first then
435 first := false
436 else
437 %><tr> <td></td> <%
438 end
439 %><td><a href="user?id=<% #usr cha %>"><% name %></a></td> <td>$<% #amount cha %></td> </tr><%
440 end %>
441 </table>
442
443 <% elseif $"cmd" = "paypal" then
444 showNormal := false;
445 val apps = App.searchPaypal ($"email");
446 val users = Init.searchPaypal ($"email");
447
448 switch apps of
449 _ :: _ =>
450 %><h3>Approved applications</h3>
451
452 <% foreach appl in apps do %>
453 <br><hr><br>
454 <table class="blanks">
455 <tr> <td>Received:</td> <td><% #applied appl %></td> </tr>
456 <tr> <td>Approved by:</td> <td><%
457 ref first = true;
458 ref found = false;
459 foreach (id, name) in App.votes (#id appl) do
460 if first then
461 first := false
462 else
463 %>, <%
464 end
465 %><a href="user?id=<% id %>"><% name %></a><%
466 end %> </td> </tr>
467 <tr> <td>Username:</td> <td><% #name appl %></td> </tr>
468 <tr> <td>Real name:</td> <td><% Web.html (#rname appl) %></td> </tr>
469 <tr> <td>E-mail address:</td> <td><a href="mailto:<% #email appl %>"><% #email appl %></a></td> </tr>
470 <% switch #paypal appl of
471 SOME s => %><tr> <td>PayPal:</td> <td><a href="mailto:<% s %>"><% s %></a></td> </tr>
472 <% end;
473 switch #checkout appl of
474 SOME s => %><tr> <td>Google Checkout:</td> <td><a href="mailto:<% s %>"><% s %></a></td> </tr>
475 <% end %>
476 <tr> <td>Forward e-mail?</td> <td><% if #forward appl then %>yes<% else %>no<% end %></td> </tr>
477 <tr> <td>Proposed uses:</td> <td><% Web.htmlNl (#uses appl) %></td> </tr>
478 <tr> <td>Other information:</td> <td><% Web.htmlNl (#other appl) %></td> </tr>
479 </table>
480
481 <% if root then %>
482 <a href="apps?add=<% #id appl %>">Add this member.</a><br>
483 <% end
484 end
485 end;
486
487 switch users of
488 _ :: _ =>
489 %><h3>Members</h3>
490
491 <% foreach user in users do %>
492 <li> <a href="user?id=<% #id user %>"><% #name user %></a> <a href="?cmd=pay&user=<% #id user %>">[add payment]</a></li>
493 <% end
494 end;
495
496 switch (apps, users) of
497 (nil, nil) => %>No matches.<%
498 end
499
500 elseif $"cmd" = "checkout" then
501 showNormal := false;
502 val apps = App.searchCheckout ($"email");
503 val users = Init.searchCheckout ($"email");
504
505 switch apps of
506 _ :: _ =>
507 %><h3>Approved applications</h3>
508
509 <% foreach appl in apps do %>
510 <br><hr><br>
511 <table class="blanks">
512 <tr> <td>Received:</td> <td><% #applied appl %></td> </tr>
513 <tr> <td>Approved by:</td> <td><%
514 ref first = true;
515 ref found = false;
516 foreach (id, name) in App.votes (#id appl) do
517 if first then
518 first := false
519 else
520 %>, <%
521 end
522 %><a href="user?id=<% id %>"><% name %></a><%
523 end %> </td> </tr>
524 <tr> <td>Username:</td> <td><% #name appl %></td> </tr>
525 <tr> <td>Real name:</td> <td><% Web.html (#rname appl) %></td> </tr>
526 <tr> <td>E-mail address:</td> <td><a href="mailto:<% #email appl %>"><% #email appl %></a></td> </tr>
527 <% switch #paypal appl of
528 SOME s => %><tr> <td>PayPal:</td> <td><a href="mailto:<% s %>"><% s %></a></td> </tr>
529 <% end;
530 switch #checkout appl of
531 SOME s => %><tr> <td>Google Checkout:</td> <td><a href="mailto:<% s %>"><% s %></a></td> </tr>
532 <% end %>
533 <tr> <td>Forward e-mail?</td> <td><% if #forward appl then %>yes<% else %>no<% end %></td> </tr>
534 <tr> <td>Proposed uses:</td> <td><% Web.htmlNl (#uses appl) %></td> </tr>
535 <tr> <td>Other information:</td> <td><% Web.htmlNl (#other appl) %></td> </tr>
536 </table>
537
538 <% if root then %>
539 <a href="apps?add=<% #id appl %>">Add this member.</a><br>
540 <% end
541 end
542 end;
543
544 switch users of
545 _ :: _ =>
546 %><h3>Members</h3>
547
548 <% foreach user in users do %>
549 <li> <a href="user?id=<% #id user %>"><% #name user %></a> <a href="?cmd=pay&user=<% #id user %>&checkout=1">[add payment]</a></li>
550 <% end
551 end;
552
553 switch (apps, users) of
554 (nil, nil) => %>No matches.<%
555 end
556
557 elseif $"cmd" = "delinq" then
558 showNormal := false;
559 val dqs = Money.delinquentPledgers () %>
560 <table>
561 <tr> <th>Member</th> <th>Pledge</th> <th>Balance</th> </tr>
562 <% foreach dq in dqs do %>
563 <tr> <td><a href="user?id=<% #id dq %>"><% #name dq %></a></td> <td><% #shares dq %></td> <td>$<% #balance dq %></td> </tr>
564 <% end %>
565 </table>
566
567 <a href="?lower=<% String.concatWith "," (List.map (fn dq => Int.toString (#id dq)) dqs) %>">Lower these pledges to 1</a>
568
569 <% elseif $"lower" <> "" then
570 Money.resetPledges (List.map Web.stoi (String.tokens (fn ch => ch = #",") ($"lower")))
571
572 %><h3>Pledges reset.</h3><%
573
574 elseif $"cmd" = "freezeworthy" then
575 showNormal := false;
576 val dqs = Money.freezeworthyPledgers () %>
577 <table>
578 <tr> <th>Member</th> <th>Balance</th> </tr>
579 <% foreach dq in dqs do %>
580 <tr> <td><a href="user?id=<% #id dq %>"><% #name dq %></a></td> <td>$<% #balance dq %></td>
581 <% if #joinedThisMonth dq then %><td><i>(joined this month)</i></td><% end %></tr>
582 <% end %>
583 </table>
584
585 <% elseif $"cmd" = "bootworthy" then
586 showNormal := false;
587 val dqs = Money.bootworthyPledgers () %>
588 <table>
589 <tr> <th>Member</th> <th>Balance</th> </tr>
590 <% foreach dq in dqs do %>
591 <tr> <td><a href="user?id=<% #id dq %>"><% #name dq %></a></td> <td>$<% #balance dq %></td>
592 <% if #joinedThisMonth dq then %><td><i>(joined this month)</i></td><% end %></tr>
593 <% end %>
594 </table>
595
596 <% end %>
597
598 <% if showNormal then
599 val you = Init.getUser();
600 val bal = Balance.lookupBalance (#bal you);
601 val deposit = Balance.depositAmount (#id bal);
602 val showBal = Util.sub (#amount bal, deposit) %>
603
604 <h3>Your balance: $<% showBal %><br>
605 Deposit: $<% deposit %></b> (3 months of dues at the minimal <a href="pledge">pledge level</a>)<br>
606 Co-op balance: $<% #amount (Balance.lookupBalance (valOf (Balance.balanceNameToId "hcoop"))) %></h3>
607
608 <!--h3>Your balance: $<% #amount bal %></h3-->
609
610 <% if (iff Group.inGroupName "money" then $"lookback" = "" else $"audit" <> "") then %><h3>Sum of all active balances: $<% Balance.sumOwnedBalances () %></h3><% end %>
611
612 <a href="money?cmd=list">List all transactions</a><br>
613 <a href="money?cmd=primary">List primary transactions</a><br>
614 <a href="money?cmd=bals">List active balances</a><br>
615 <a href="money?cmd=nbals">List negative active balances</a><br>
616 <a href="money?cmd=freezeworthy">List members who deserve account freezing</a><br>
617 <a href="money?cmd=bootworthy">List members who deserve to be kicked out</a><br>
618 <a href="money?cmd=deadbals">List retired balances</a><br>
619
620 <% if (Group.inGroupName "money" and $"lookback" = "") or $"audit" <> "" then %>
621
622 <a href="?cmd=delinq">Drop pledges of delinquent members</a><br>
623 <a href="?lookback=20">Switch to regular member view</a><br>
624
625 <br><b><u>New transaction:</u></b><br>
626 <a href="money?cmd=bill">Bill for the co-op</a><br>
627 <a href="money?cmd=pay">Payment from member</a><br>
628 <a href="money?cmd=dues">Monthly dues</a><br>
629 <a href="money?cmd=hosting">New hosting bill (old style)</a><br>
630 <a href="money?cmd=evenForm">Generic/even</a><br>
631 <br>
632 <a href="money?cmd=equalize">Equalize balances</a><br>
633 <br>
634
635 <h3>Look up a PayPal e-mail address</h3>
636
637 <form method="post">
638 <input type="hidden" name="cmd" value="paypal">
639 <input name="email"> <input type="submit" value="Look up">
640 </form>
641
642 <h3>Look up a Google Checkout e-mail address</h3>
643
644 <form method="post">
645 <input type="hidden" name="cmd" value="checkout">
646 <input name="email"> <input type="submit" value="Look up">
647 </form>
648
649 <h3>Most recent transactions</h3>
650
651 <table>
652 <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>
653 <% foreach trn in Money.listTransactionsLimit 20 do %>
654 <tr> <td><% #d trn %></td> <td><a href="money?trn=<% #id trn %>"><% Web.html (#descr trn) %></a></td> <td><% #amount trn %></td>
655 <% switch Money.listChargesWithNames (#id trn) of
656 [(name, cha)] => %><td><a href="user?id=<% #usr cha %>"><% name %></a></td><%
657 | _ => %><td><i>multi</i></td><%
658 end %>
659 <td><a href="money?modBill=<% #id trn %>">[Bill]</a> <a href="money?modPay=<% #id trn %>">[Payment]</a> <a href="money?modEven=<% #id trn %>">[Other]</a></td>
660 <td><a href="money?del=<% #id trn %>">[Delete]</a></td> </tr>
661 <% end %>
662 </table>
663
664 <% else %>
665 <a href="?audit=1">Switch to audit view</a><br>
666 <% val lookback = case $"lookback" of "" => 20 | "inf" => 0 | lb => Web.stoi lb;
667 @payment [] %>
668
669 <h3>Your recent account activity</h3>
670
671 <form>
672 Show <input name="lookback" size="5" value="<% iff lookback = 0 then 20 else lookback %>"> most recent transactions.
673 <input type="submit" value="Show">
674 </form>
675
676 <% ref running = showBal;
677 val trans = iff lookback = 0 then
678 Money.listUserTransactions (Init.getUserId ())
679 else
680 Money.listUserTransactionsLimit (Init.getUserId (), lookback) %>
681 <table>
682 <tr> <td><b>Date</b></td> <td><b>Description</b></td> <td><b>Debit</b></td> <td><b>Credit</b></td> <td><b>Balance</b></td></tr>
683 <% foreach (amount, trn) in trans do %>
684 <tr> <td><% #d trn %></td> <td><a href="money?trn=<% #id trn %>"><% Web.html (#descr trn) %></a></td>
685 <td align="right"><% if Util.lt (amount, 0.0) then %><% amount %><% end %></td>
686 <td align="right"><% if Util.ge (amount, 0.0) then %><% amount %><% end %></td>
687 <td><% running %></tr>
688 <% running := Util.sub (running, amount)
689 end %>
690 </table>
691 <% if lookback <> 0 then %>
692 <a href="?lookback=inf">Show all transactions</a><br>
693 <% end %>
694
695 <% end
696 end %>
697
698 <% @footer [] %>