Add all-balance summing and listing of retired balances

[hcoop/zz_old/portal.git] / money.mlt

<% @header [("title", ["MoneyMatters"])];

ref showNormal = true;

if $"hist" <> "" then
	showNormal := false;
	val id = Web.stoi ($"hist") %>
<table>
<tr> <td><b>Date</b></td> <td><b>Description</b></td> <td><b>Amount</b></td> </tr>
<% foreach (amount, trn) in Money.listUserTransactions id do %>
<tr> <td><% #d trn %></td> <td><a href="money?trn=<% #id trn %>"><% Web.html (#descr trn) %></a></td> <td><% amount %>/<% #amount trn %></td> </tr>
<% end %>
</table>

<% elseif $"cmd" = "list" then
	val admin = Group.inGroupName "money";
	showNormal := false %>

<h3>Transactions</h3>

<table>
<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>
<% foreach trn in Money.listTransactions () do %>
<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>
<% switch Money.listChargesWithNames (#id trn) of
	  [(name, cha)] => %><td><a href="user?id=<% #usr cha %>"><% name %></a></td><%
	| _ => %><td><i>multi</i></td><%
end;
if admin then
	%><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>
	<td><a href="money?del=<% #id trn %>">[Delete]</a></td><%
end
%></tr><%
end %>
</table>

<% elseif $"cmd" = "bals" then
	showNormal := false %>

<h3>Active Balances</h3>

<table>
<% foreach bal in Balance.listOwnedBalances () do %>
<tr><td><% #name bal %></td> <td><% #amount bal %></td> <td>
<% switch Balance.listBalanceUsers (#id bal) of
	  [] =>
	| (user :: users) =>
		%><a href="money?hist=<% #id user %>"><% Web.html (#name user) %></a><%
		foreach user in users do
			%>, <a href="money?hist=<% # id user %>"><% Web.html (#name user) %></a><%
		end
end %></td> </tr>
<% end %>
</table>

<% elseif $"cmd" = "deadbals" then
	showNormal := false %>

<h3>Retired Balances</h3>

<table>
<% foreach bal in Balance.listUnownedBalances () do %>
<tr><td><% #name bal %></td> <td><% #amount bal %></td> <td>
<% switch Balance.listBalanceUsers (#id bal) of
	  [] =>
	| (user :: users) =>
		%><a href="money?hist=<% #id user %>"><% Web.html (#name user) %></a><%
		foreach user in users do
			%>, <a href="money?hist=<% # id user %>"><% Web.html (#name user) %></a><%
		end
end %></td> </tr>
<% end %>
</table>

<% elseif $"cmd" = "hosting" then
	Group.requireGroupName "money";
	showNormal := false %>

<h3>New hosting bill</h3>

<form action="money" method="post">
<input type="hidden" name="cmd" value="hosting2">
<table class="blanks">
<tr> <td>Description:</td> <td><input name="descr"></td> </tr>
<tr> <td>Date:</td> <td><input name="d"></td> </tr>
<tr> <td>Amount:</td> <td><input name="amount"></td> </tr>
<tr> <td>Free bandwidth cutoff (MB):</td> <td><input name="cutoff" value="200"></td> </tr>
<tr> <td>Cost/GB:</td> <td><input name="cost" value="4"></td> </tr>
<tr> <td>Member usage:</td> <td><textarea wrap="soft" name="usage" rows="24" cols="80"></textarea></td> </tr>
<tr> <td><input type="submit" value="Add"></td> </tr>
</table>

<% elseif $"cmd" = "hosting2" then
	Group.requireGroupName "money";
	val id = Money.addTransaction ($"descr", Util.neg (Web.stor ($"amount")), $"d");
	Money.addHostingCharges {trn = id, cutoff = 1000 * Web.stoi ($"cutoff"), cost = Web.stor ($"cost"), usage = $"usage"};

	%><h3>Hosting transaction added.</h3>

<% elseif $"modHosting" <> "" then
	Group.requireGroupName "money";
	showNormal := false;
	val id = Web.stoi ($"modHosting");
	val trn = Money.lookupTransaction id %>

<h3>Modify hosting bill</h3>

<form action="money" method="post">
<input type="hidden" name="saveHosting" value="<% id %>">
<table class="blanks">
<tr> <td>Description:</td> <td><input name="descr" value="<% Web.html (#descr trn) %>"></td> </tr>
<tr> <td>Date:</td> <td><input name="d" value="<% Web.html (#d trn) %>"></td> </tr>
<tr> <td>Amount:</td> <td><input name="amount" value="<% Util.neg (#amount trn) %>"></td> </tr>
<tr> <td>Free bandwidth cutoff (MB):</td> <td><input name="cutoff" value="200"></td> </tr>
<tr> <td>Cost/GB:</td> <td><input name="cost" value="4"></td> </tr>
<tr> <td>Member usage:</td> <td><textarea wrap="soft" name="usage" rows="24" cols="80"><%
switch Money.lookupHostingUsage id of
	  SOME s => s
end %></textarea></td> </tr>
<tr> <td><input type="submit" value="Save"></td> </tr>
</table>

<% elseif $"saveHosting" <> "" then
	Group.requireGroupName "money";
	val id = Web.stoi ($"saveHosting");
	val trn = Money.lookupTransaction id;

	Money.clearCharges id;
	Money.modTransaction {trn with descr = $"descr", d = $"d", amount = Util.neg (Web.stor ($"amount"))};
	Money.addHostingCharges {trn = id, cutoff = 1000 * Web.stoi ($"cutoff"), cost = Web.stor ($"cost"), usage = $"usage"};

	%><h3>Hosting transaction modified.</h3>

<% elseif $"cmd" = "evenForm" then
	Group.requireGroupName "money";
	showNormal := false %>
<h3>New generic/even transaction</h3>
<form action="money" method="post">
<input type="hidden" name="cmd" value="even">
<table class="blanks">
<tr> <td>Description:</td> <td><input name="descr"></td> </tr>
<tr> <td>Date:</td> <td><input name="d"></td> </tr>
<tr> <td>Amount:</td> <td><input name="amount"></td> </tr>
<tr> <td>Members:</td> <td><select name="usrs" size="5" multiple>
<% foreach usr in Init.listUsers () do %>
	<option value="<% #id usr %>"><% #name usr %></option>
<% end %>
</select></td> </tr>
<tr> <td><input type="submit" value="Add"></td> </tr>
</table>
</form>

<% elseif $"cmd" = "pay" then
	Group.requireGroupName "money";
	showNormal := false %>

<h3>New member payment</h3>

<form action="money" method="post">
<input type="hidden" name="cmd" value="pay2">
<table class="blanks">
<tr> <td>Description:</td> <td><select name="descr">
	<option selected>PayPal</option>
	<option>Google Checkout</option>
	<option>Check</option>
	<option>Direct transfer</option>
	<option value="">Other:</option>
</select> <input name="descr2"></td> </tr>
<tr> <td>Date:</td> <td><input name="d"></td> </tr>
<tr> <td>Amount:</td> <td><input name="amount"></td> </tr>
<tr> <td>Member:</td> <td><select name="usr">
<% foreach usr in Init.listUsers () do %>
	<option value="<% #id usr %>"><% #name usr %></option>
<% end %>
</select></td> </tr>
<tr> <td><input type="submit" value="Add"></td> </tr>
</table>
</form>

<% elseif $"cmd" = "pay2" then
	Group.requireGroupName "money";
	val amount = Web.stor ($"amount");
	val descr = $"descr";
	val descr = iff descr = "" then $"descr2" else descr;
	val id = Money.addTransaction ($"descr", amount, $"d");
	Money.addCharge {trn = id, usr = Web.stoi ($"usr"), amount = amount};
	Money.applyCharges id;

	%><h3>Payment transaction added.</h3>

<% elseif $"modPay" <> "" then
	Group.requireGroupName "money";
	showNormal := false;
	val id = Web.stoi ($"modPay");
	val trn = Money.lookupTransaction id %>

<h3>Modify member payment</h3>

<form action="money" method="post">
<input type="hidden" name="savePay" value="<% id %>">
<table class="blanks">
<tr> <td>Description:</td> <td><input name="descr" value="<% Web.html (#descr trn) %>"></td> </tr>
<tr> <td>Date:</td> <td><input name="d" value="<% Web.html (#d trn) %>"></td> </tr>
<tr> <td>Amount:</td> <td><input name="amount" value="<% #amount trn %>"></td> </tr>
<tr> <td>Member:</td> <td><select name="usr">
<% foreach (sel, usr) in Money.listUsers (#id trn) do %>
	<option value="<% #id usr %>"<% if sel then %> selected<% end %>><% #name usr %></option>
<% end %>
</td></tr>
<tr> <td><input type="submit" value="Save"></td> </tr>
</table>

<% elseif $"savePay" <> "" then
	Group.requireGroupName "money";
	val id = Web.stoi ($"savePay");
	val trn = Money.lookupTransaction id;

	val amount = Web.stor ($"amount");
	Money.clearCharges id;
	Money.modTransaction {trn with descr = $"descr", d = $"d", amount = amount};
	Money.addCharge {trn = id, usr = Web.stoi ($"usr"), amount = amount};
	Money.applyCharges id;

	%><h3>Member payment modified.</h3>

<% elseif $"cmd" = "evenForm" then
	Group.requireGroupName "money";
	showNormal := false %>
<h3>New generic/even transaction</h3>
<form action="money" method="post">
<input type="hidden" name="cmd" value="even">
<table class="blanks">
<tr> <td>Description:</td> <td><input name="descr"></td> </tr>
<tr> <td>Date:</td> <td><input name="d"></td> </tr>
<tr> <td>Amount:</td> <td><input name="amount"></td> </tr>
<tr> <td>Members:</td> <td><select name="usrs" size="5" multiple>
<% foreach usr in Init.listUsers () do %>
	<option value="<% #id usr %>"><% #name usr %></option>
<% end %>
</select></td> </tr>
<tr> <td><input type="submit" value="Add"></td> </tr>
</table>
</form>

<% elseif $"cmd" = "even" then
	Group.requireGroupName "money";
	val id = Money.addTransaction ($"descr", Web.stor ($"amount"), $"d");
	Money.addEvenCharges (id, map Web.stoi (Web.getMultiParam "usrs"))

	%><h3>Even transaction added.</h3>

<% elseif $"modEven" <> "" then
	Group.requireGroupName "money";
	showNormal := false;
	val trn = Money.lookupTransaction (Web.stoi ($"modEven")) %>
<h3>Modify even transaction</h3>

<form action="money" method="post">
<input type="hidden" name="saveEven" value="<% $"modEven" %>">
<table class="blanks">
<tr> <td>Description:</td> <td><input name="descr" value="<% Web.html (#descr trn) %>"></td> </tr>
<tr> <td>Date:</td> <td><input name="d" value="<% Web.html (#d trn) %>"></td> </tr>
<tr> <td>Amount:</td> <td><input name="amount" value="<% #amount trn %>"></td> </tr>
<tr> <td>Members:</td> <td><select name="usrs" size="5" multiple>
<% foreach (sel, usr) in Money.listUsers (#id trn) do %>
	<option value="<% #id usr %>"<% if sel then %> selected<% end %>><% #name usr %></option>
<% end %>
</select></td> </tr>
<tr> <td><input type="submit" value="Save"></td> </tr>
</table>
</form>

<% elseif $"saveEven" <> "" then
	Group.requireGroupName "money";
	val id = Web.stoi ($"saveEven");
	val trn = Money.lookupTransaction id;
	Money.clearCharges id;
	Money.modTransaction {trn with descr = $"descr", d = $"d", amount = Web.stor ($"amount")};
	Money.addEvenCharges (id, map Web.stoi (Web.getMultiParam "usrs"))

	%><h3>Even transaction modified</h3>

<% elseif $"del" <> "" then
	Group.requireGroupName "money";
	showNormal := false;
	val trn = Money.lookupTransaction (Web.stoi ($"del")) %>
	<h3>Are you sure you want to delete transaction <a href="money?trn=<% #id trn %>"><% Web.html (#descr trn) %></a>?</h3>
	<a href="money?del2=<% $"del" %>">Yes, delete <% Web.html (#descr trn) %>!</a>

<% elseif $"del2" <> "" then
	Group.requireGroupName "money";
	val id = Web.stoi ($"del2");
	val trn = Money.lookupTransaction id;
	Money.clearCharges id;
	Money.deleteTransaction id %>
	<h3><% Web.html (#descr trn) %> deleted!</h3>

<% elseif $"cmd" = "equalize" then
	Group.requireGroupName "money";
	Money.equalizeBalances ();
	%><h3>Balances equalized</h3>

<% elseif $"trn" <> "" then
	showNormal := false;
	val id = Web.stoi ($"trn");
	val trn = Money.lookupTransaction id %>
<table class="blanks">
<tr> <td>TRN#:</td> <td><% id %></td> </tr>
<tr> <td>Description:</td> <td><% Web.html (#descr trn) %></td> </tr>
<tr> <td>Date:</td> <td><% #d trn %></td> </tr>
<tr> <td>Amount:</td> <td>$<% #amount trn %></td> </tr>
<tr> <td>Distribution:</td>

<% ref first = true;
foreach (name, cha) in Money.listChargesWithNames id do
	if first then
		first := false
	else
		%><tr> <td></td> <%
	end
	%><td><a href="user?id=<% #usr cha %>"><% name %></a></td> <td>$<% #amount cha %></td> </tr><%
end %>
</table>

<% end %>

<% if showNormal then %>

<h3>Your balance: $<% #amount (Balance.lookupBalance (#bal (Init.getUser ()))) %></h3>
<% if Group.inGroupName "money" then %><h3>Sum of all active balances: $<% Balance.sumOwnedBalances () %></h3><% end %>

<a href="money?cmd=list">List all transactions</a><br>
<a href="money?cmd=bals">List active balances</a><br>
<a href="money?cmd=deadbals">List retired balances</a><br>

<% if Group.inGroupName "money" then %>

<br><b><u>New transaction:</u></b><br>
<a href="money?cmd=hosting">Hosting bill</a><br>
<a href="money?cmd=pay">Payment from member</a><br>
<a href="money?cmd=evenForm">Generic/even</a><br>
<br>
<a href="money?cmd=equalize">Equalize balances</a><br>

<h3>Most recent transactions</h3>

<table>
<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>
<% foreach trn in Money.listTransactionsLimit 20 do %>
<tr> <td><% #d trn %></td> <td><a href="money?trn=<% #id trn %>"><% Web.html (#descr trn) %></a></td> <td><% #amount trn %></td>
<% switch Money.listChargesWithNames (#id trn) of
	  [(name, cha)] => %><td><a href="user?id=<% #usr cha %>"><% name %></a></td><%
	| _ => %><td><i>multi</i></td><%
end %>
<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>
<td><a href="money?del=<% #id trn %>">[Delete]</a></td> </tr>
<% end %>
</table>

<% else %>

<h3><a href="https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=payment@hcoop.net&item_name=Member+payment+for+<% Init.getUserName () %>">Add to your balance with PayPal</a></h3>

<h3>Your recent account activity</h3>

<table>
<tr> <td><b>Date</b></td> <td><b>Description</b></td> <td><b>Amount</b></td> </tr>
<% foreach (amount, trn) in Money.listUserTransactionsLimit (Init.getUserId (), 20) do %>
<tr> <td><% #d trn %></td> <td><a href="money?trn=<% #id trn %>"><% Web.html (#descr trn) %></a></td> <td><% amount %>/<% #amount trn %></td> </tr>
<% end %>
</table>

<% end
end %>

<% @footer [] %>