• Example Mini-Apps
• Invoices
• List

List of Invoices

• « Previous
• 1
• 2
• Next »

• « Previous
• 1
• 2
• Next »

• Form for adding a New Invoice record
• Create New Invoice Record
• Process All Invoices — Calculate Subtotal, Tax, and Total values

<# start list for invoices; 
	show 10 rows per page;
#>

<# start header #>
<table class="table table-striped table-hover table-condensed">
	<thead>
	<tr>
		<th>Status</th>
		<th>Qty</th>
		<th class="text-right">Each</th>
		<th class="text-right">Subtotal</th>
		<th class="text-right">Tax</th>
		<th class="text-right">Total</th>
		<th>Action</th>
	</tr>
	</thead>
<# end header #>

<# start row #>
	<tr>
		<td><# status #></td>
		<td><a href="form?edit=<# id #>"><# qty #></a></td>
		<td class="text-right"><# each #></td>
		<td class="text-right"><# subtotal #></td>
		<td class="text-right"><# tax #></td>
		<td class="text-right"><# total #></td>
		<td><a href="process?id=<# id #>" class="label label-primary label-action">Process</a>
			<a href="update?id=<# id #>" class="label label-primary label-action">Increase Qty</a>
			<a href="clone?id=<# id #>" class="label label-primary label-action">Clone</a>
			<a href="delete?id=<# id #>&index=<#[url.index as html]#>" 
				onclick="return confirm('Delete Invoice Record?')" 
				class="label label-primary label-action">Delete</a>
		</td>
	</tr>
<# end row #>

<# start footer #>
</table>
<# end footer #>

<# start no results #>
<h4 class="alert alert-warning text-center">No Invoice Records Found</h4>
<# end no results #>

<# end list #>

<# update record for "invoices.<#[url.id]#>";
	set subtotal to <# qty #> * <# each as number #>;
	set tax to <# subtotal #> * .10;
	set total to <# subtotal #> + <# tax #>;
	round total to 2 decimals;
	set status to "processed";
	redirect to "/invoices/list?index=<#[url.id]#>";
#>

<# update record for "invoices.<#[url.id]#>";
	set status to "updated";
	set qty to <# qty #> + 1;
	set subtotal to "";
	set tax to "";
	set total to "";
	redirect to "/invoices/list?index=<#[url.id]#>";
#>

<# clone invoices.<#[url.id]#> as "new_invoice";
	redirect to "/invoices/list?index=<#[url.id]#>";
#>

<# delete record for invoices.<#[url.id]#> as "new_invoice";
	redirect to "/invoices/list?index=<#[url.id]#>";
#>

The Invoices Mini-App uses the Hashtag Markup Language to demonstrate methods for processing records.

Invoice records are stored in an SQL database.   The Process example uses math expressions for multiplication and rounding to currency standards.  

• List Templates
• Apply Record Command
• Clone Record Command
• Update Record Command
• Delete Record Command
• Request Variables
• Context - HTML