#set($freport = $report.getFinancialReport())
<h3>4.1.6.01: Financial Transactions</h3>

<!-- <br/>
<ul style="list-style-type: none;">
	<li><span style="font-size:larger;"><strong>Search:</strong> $report.getOrders().getSearchQuery().toFriendly()</span></li>
	<li><span style="font-size:larger;"><strong>Date:</strong> $context.getDateTime($freport.getDate())</span></li>
	<li><span style="font-size:larger;"><strong>Created By:</strong> $freport.getUser()</span></li>
</ul> -->
<br/>
<br/>

<div class="table-responsive">
	<table id="report" class="table table-condensed">
		<thead>
			<tr class="details">
				<th colspan="4">Report Name:</th>
				<th colspan="8">4.1.6.01: Financial Transactions</th>
				#if($page.isPropertyTrue("show-vouchers"))
					<th colspan="11">&nbsp;</th>
				#else
					<th colspan="6">&nbsp;</th>
				#end
			</tr>
			<tr class="details">
				<th colspan="4">Search:</th>
				<th colspan="8">$report.getOrders().getSearchQuery().toFriendly()</th>
				#if($page.isPropertyTrue("show-vouchers"))
					<th colspan="11">&nbsp;</th>
				#else
					<th colspan="6">&nbsp;</th>
				#end
			</tr>
			<tr class="details">
				<th colspan="4">Date:</th>
				<th colspan="8">$context.getDateTime($freport.getDate())</th>
				#if($page.isPropertyTrue("show-vouchers"))
					<th colspan="11">&nbsp;</th>
				#else
					<th colspan="6">&nbsp;</th>
				#end
			</tr>
			<tr class="details">
				<th colspan="4">Created By:</th>
				<th colspan="8">$freport.getUser()</th>
				#if($page.isPropertyTrue("show-vouchers"))
					<th colspan="11">&nbsp;</th>
				#else
					<th colspan="6">&nbsp;</th>
				#end
			</tr>
			<tr class="details">
				#if($page.isPropertyTrue("show-vouchers"))
					<th colspan="21">&nbsp;</th>
				#else
					<th colspan="18">&nbsp;</th>
				#end
			</tr>
			<tr>
				<th></th>
				<th>Order #</th>
				<th>Class ID</th>
				<th>Class Name</th>
				<th>Start Date</th>
				<th>End Date</th>
				<th>Revenue Type</th>
				<th>Student ID</th>
				<th>Last Name</th>
				<th>First Name</th>
				<th>Non-taxable Tuition</th>
				<th>Taxable Tuition</th>
				<th>Discount Amount</th>
				<th>Subtotal</th>
				<th>HST</th>
				<th>Total Due</th>
				<th>Payment</th>
				<th>Payment Date</th>
				<!-- <th>Owing</th>
				<th>Discount Issuer</th> -->
				#if($page.isPropertyTrue("show-vouchers"))
				<th>Voucher Number</th>
				<th>Voucher Amount</th>
				#end
				<!-- <th>Other Fees</th> -->
			</tr>
		</thead>
		<tbody>
			#foreach($group in $freport.getReportGroups())
				#set($count = 0)
    
				#if($group.getCount() > 0)
					#if($group.isVoucher() && $page.isPropertyTrue("show-vouchers")==false)
					#else
						
      #set($label = $group.getLabel())
						#foreach($hit in $group.getHitTracker())
							#set($order = $group.load($hit))
							#if($order.learninggroup)
								#set($classdata = $freport.loadObjectByField("learningGroup","id",$order.learninggroup))
							#else
								#set($classdata = "")
							#end
							
							#set($cartitem = $order.getItems().get(0))
							#set($product = $cartitem.getProduct())
							#set($method = "")
							#set($vouchernumber = "")
							#set($vouchervalue = "")
							#set($voucherdata = "")
							#if($order.getPaymentMethod().getType() == "prepaidcode")
								#set($method = "Voucher")
								#set($vouchernumber = $order.get("prepaid"))
								#set($vouchervalue = $order.getSubTotal())
								#if($vouchernumber)
									#set($voucherdata = $freport.loadObjectByField("prepad","id",$vouchernumber))
								#end
							#elseif($order.getPaymentMethod().getType() == "creditcard")
								#set($method = $order.getPaymentMethod().getCreditCardType())
							#end
							#set($price = "N/A")
							#if($product.getPriceSupport().getRetailPrice()) 
								#set($price = $product.getPriceSupport().getRetailPrice())
							#end
							#set($studentid = $freport.getDisplayValue("userprofile","id",$order.getCustomer().getId(), "studentid","N/A"))
							#set($stripefee = $group.getMoney($order.get("stripefee")))
							#set($profitshare = $group.getMoney($order.get("profitshare")))
							
							#if($group.isRefund())
								#if($order.getRefunds().isEmpty() == false)
									#set($count = $count + 1)
									#set($refunds = $order.getRefunds())
									#set($first = $refunds.get(0))
									
									$group.addMoney("taxablesubtotal",$order.calculateRefundTaxableSubtotal().multiply("-1.0"))
									$group.addMoney("nontaxablesubtotal",$order.calculateRefundNontaxableSubtotal().multiply("-1.0"))
									$group.addMoney("subtotal",$order.calculateRefundSubtotal().multiply("-1.0"))
									$group.addMoney("tax",$order.calculateRefundTax().multiply("-1.0"))
									$group.addMoney("total",$order.calculateRefundTotal().multiply("-1.0"))
									$group.addMoney("stripefee",$stripefee.multiply("-1.0"))
									$group.addMoney("profitshare",$profitshare.multiply("-1.0"))
									
									$group.addMoney("refunds_taxablesubtotal",$order.calculateRefundTaxableSubtotal().multiply("-1.0"))
									$group.addMoney("refunds_nontaxablesubtotal",$order.calculateRefundNontaxableSubtotal().multiply("-1.0"))
									$group.addMoney("refunds_subtotal",$order.calculateRefundSubtotal().multiply("-1.0"))
									$group.addMoney("refunds_tax",$order.calculateRefundTax().multiply("-1.0"))
									$group.addMoney("refunds_total",$order.calculateRefundTotal().multiply("-1.0"))
									$group.addMoney("refunds_stripefee",$stripefee.multiply("-1.0"))
									$group.addMoney("refunds_profitshare",$profitshare.multiply("-1.0"))
									
									<tr>
										#if($count == 1)
											<td><label>$group.getLabel()</label></td>
										#else
											<td></td>
										#end
										
										<td>$order.getId()</td>
										
										<td>$!classdata.id</td>
										<td>$!classdata.name</td>
										<td>$!context.getDate($classdata.startdate)</td>
										<td>$!context.getDate($classdata.enddate)</td>
										
										<td>#if($order.getBoolean("international")) International #else Canadian #end</td>
										
										<td>$studentid</td>
										<td>$order.getCustomer().getLastName()</td>
										<td>$order.getCustomer().getFirstName()</td>
										
										<td><span #if($order.calculateRefundNontaxableSubtotal().isZero()==false) class="negative" #end>$order.calculateRefundNontaxableSubtotal().multiply("-1.0")</span></td>
										<td><span #if($order.calculateRefundTaxableSubtotal().isZero()==false) class="negative" #end>$order.calculateRefundTaxableSubtotal().multiply("-1.0")</span></td>
										
										<td>$ 0.00</td>
										
										<td><span class="negative">$order.calculateRefundSubtotal().multiply("-1.0")</span></td>
										<td><span class="negative">$order.calculateRefundTax().multiply("-1.0")</span></td>
										<td><span class="negative">$order.calculateRefundTotal().multiply("-1.0")</span></td>
										<td><span class="negative">$order.calculateRefundTotal().multiply("-1.0")</span></td>
										<td>$context.getDate($first.getDate())</td>
										
										<!-- <td>${D}0.00</td>
										<td></td> -->
										#if($page.isPropertyTrue("show-vouchers"))
										<td>$vouchernumber</td>
										<td>#if($vouchervalue == "") $ 0.00 #else $vouchervalue #end</td>
										#end
										<!-- <td>${D}0.00</td> -->
										
									</tr>
								#end
							
							#else
								$group.addMoney("tax",$order.getTax())
								$group.addMoney("taxablesubtotal",$order.getTaxableSubtotal())
								$group.addMoney("nontaxablesubtotal",$order.getNonTaxableSubtotal())
								$group.addMoney("subtotal",$order.getSubTotal())
								$group.addMoney("total",$order.getTotalPrice())
								#if($vouchervalue != "")
									$group.addMoney("voucher",$vouchervalue)
								#end
								$group.addMoneyAsString("discount","0")
								$group.addMoneyAsString("accommodations","0")
								$group.addMoneyAsString("travel","0")
								$group.addMoneyAsString("meals","0")
								$group.addMoneyAsString("fees","0")
								
								$group.addMoney("payment_tax",$order.getTax())
								$group.addMoney("payment_taxablesubtotal",$order.getTaxableSubtotal())
								$group.addMoney("payment_nontaxablesubtotal",$order.getNonTaxableSubtotal())
								$group.addMoney("payment_subtotal",$order.getSubTotal())
								$group.addMoney("payment_total",$order.getTotalPrice())
								#if($vouchervalue != "")
									$group.addMoney("payment_voucher",$vouchervalue)
								#end
								$group.addMoneyAsString("payment_discount","0")
								$group.addMoneyAsString("payment_accommodations","0")
								$group.addMoneyAsString("payment_travel","0")
								$group.addMoneyAsString("payment_meals","0")
								$group.addMoneyAsString("payment_fees","0")
								
								<tr>
									#if($velocityCount == 1)
										<td><label>$group.getLabel()</label></td>
									#else
										<td></td>
									#end
									
									<td>$order.getId()</td>
					
									<td>$!classdata.id</td>
									<td>$!classdata.name</td>
									<td>$!context.getDate($classdata.startdate)</td>
									<td>$!context.getDate($classdata.enddate)</td>
									
									<td>#if($order.getBoolean("international")) International #else Canadian #end</td>
									
									<td>$studentid</td>
									<td>$order.getCustomer().getLastName()</td>
									<td>$order.getCustomer().getFirstName()</td>
									
									<td>$order.getNonTaxableSubtotal()</td>
									<td>$order.getTaxableSubtotal()</td>
									
									<td>$ 0.00</td>
									
									<td>$order.getSubTotal()</td>
									<td>$order.getTax()</td>
									<td>$order.getTotalPrice()</td>
									<td>$order.getTotalPrice()</td>
									<td>$context.getDate($order.getDate())</td>
									
									<!-- <td>${D}0.00</td>
									<td></td> -->
									#if($page.isPropertyTrue("show-vouchers"))
									<td>$vouchernumber</td>
									<td>#if($vouchervalue == "") $ 0.00 #else $vouchervalue #end</td>
									#end
									<!-- <td>${D}0.00</td> -->
								</tr>
							#end
						#end
						#if( $group.isRefund() == false || ($count != 0 && $group.isRefund()))
							<tr class="line">
								<td><label>$label <br/>Subtotals</label></td>
								<td></td>
								<td></td>
								<td></td>
								<td></td>
								<td></td>
								<td></td>
								<td></td>
								<td></td>
								<td></td>
								<td><span class="subtotal #if($group.getMoney("nontaxablesubtotal","0").isNegative())  negative #end" >$group.getMoney("nontaxablesubtotal","0")</span></td>
								<td><span class="subtotal #if($group.getMoney("taxablesubtotal","0").isNegative())  negative #end" >$group.getMoney("taxablesubtotal","0")</span></td>
								<td><span class="subtotal #if($group.getMoney("discount","0").isNegative())  negative #end" >$group.getMoney("discount","0")</span></td>
								<td><span class="subtotal #if($group.getMoney("subtotal","0").isNegative())  negative #end" >$group.getMoney("subtotal","0")</span></td>
								<td><span class="subtotal #if($group.getMoney("tax","0").isNegative())  negative #end" >$group.getMoney("tax","0")</span></td>
								<td><span class="subtotal #if($group.getMoney("total","0").isNegative())  negative #end" >$group.getMoney("total","0")</span></td>
								<td><span class="subtotal #if($group.getMoney("total","0").isNegative())  negative #end" >$group.getMoney("total","0")</span></td>
								<td></td>
								<!-- <td><span class="subtotal #if($group.getMoney("owing","0").isNegative())  negative #end" >$group.getMoney("owing","0")</span></td>
								<td></td> -->
								#if($page.isPropertyTrue("show-vouchers"))
								<td></td>
								<td><span class="subtotal #if($group.getMoney("voucher","0").isNegative())  negative #end" >$group.getMoney("voucher","0")</span></td>
								#end
								<!-- <td><span class="subtotal #if($group.getMoney("fees","0").isNegative())  negative #end" >$group.getMoney("fees","0")</span></td> -->
							</tr>
						#end
					#end ### if voucher
				#end ### if group
			#end ### for loop
		###</tbody>
		###<tfoot>
			$freport.generateSummary()
			<tr class="line2">
				<td><label>Total Payments</label></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td><span class="summary #if($freport.getMoney("payment_nontaxablesubtotal","0").isNegative()) negative #end" >$freport.getMoney("payment_nontaxablesubtotal","0")</span></td>
				<td><span class="summary #if($freport.getMoney("payment_taxablesubtotal","0").isNegative()) negative #end" >$freport.getMoney("payment_taxablesubtotal","0")</span></td>
				<td><span class="summary #if($freport.getMoney("payment_discount","0").isNegative()) negative #end" >$freport.getMoney("payment_discount","0")</span></td>
				<td><span class="summary #if($freport.getMoney("payment_subtotal","0").isNegative()) negative #end" >$freport.getMoney("payment_subtotal","0")</span></td>
				<td><span class="summary #if($freport.getMoney("payment_tax","0").isNegative()) negative #end" >$freport.getMoney("payment_tax","0")</span></td>
				<td><span class="summary #if($freport.getMoney("payment_total","0").isNegative()) negative #end" >$freport.getMoney("payment_total","0")</span></td>
				<td><span class="summary #if($freport.getMoney("payment_total","0").isNegative()) negative #end" >$freport.getMoney("payment_total","0")</span></td>
				<td></td>
				<!-- <td><span class="summary #if($freport.getMoney("payment_owing","0").isNegative()) negative #end" >$freport.getMoney("payment_owing","0")</span></td>
				<td></td> -->
				#if($page.isPropertyTrue("show-vouchers"))
				<td></td>
				<td><span class="summary #if($freport.getMoney("payment_voucher","0").isNegative()) negative #end" >$freport.getMoney("payment_voucher","0")</span></td>
				#end
				<!-- <td><span class="summary #if($freport.getMoney("payment_fees","0").isNegative()) negative #end" >$freport.getMoney("payment_fees","0")</span></td> -->
			</tr>
			<tr>
				<td><label>Total Refunds</label></td>
				
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td><span class="summary #if($freport.getMoney("refunds_nontaxablesubtotal","0").isNegative()) negative #end" >$freport.getMoney("refunds_nontaxablesubtotal","0")</span></td>
				<td><span class="summary #if($freport.getMoney("refunds_taxablesubtotal","0").isNegative()) negative #end" >$freport.getMoney("refunds_taxablesubtotal","0")</span></td>
				<td><span class="summary #if($freport.getMoney("refunds_discount","0").isNegative()) negative #end" >$freport.getMoney("refunds_discount","0")</span></td>
				<td><span class="summary #if($freport.getMoney("refunds_subtotal","0").isNegative()) negative #end" >$freport.getMoney("refunds_subtotal","0")</span></td>
				<td><span class="summary #if($freport.getMoney("refunds_tax","0").isNegative()) negative #end" >$freport.getMoney("refunds_tax","0")</span></td>
				<td><span class="summary #if($freport.getMoney("refunds_total","0").isNegative()) negative #end" >$freport.getMoney("refunds_total","0")</span></td>
				<td><span class="summary #if($freport.getMoney("refunds_total","0").isNegative()) negative #end" >$freport.getMoney("refunds_total","0")</span></td>
				<td></td>
				<!-- <td><span class="summary #if($freport.getMoney("refunds_owing","0").isNegative()) negative #end" >$freport.getMoney("refunds_owing","0")</span></td>
				<td></td> -->
				#if($page.isPropertyTrue("show-vouchers"))
				<td></td>
				<td><span class="summary #if($freport.getMoney("refunds_voucher","0").isNegative()) negative #end" >$freport.getMoney("refunds_voucher","0")</span></td>
				#end
				<!-- <td><span class="summary #if($freport.getMoney("refunds_fees","0").isNegative()) negative #end" >$freport.getMoney("refunds_fees","0")</span></td> -->
				
			</tr>
			<tr>
				<td><label>Total Transactions</label></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td><span class="summary #if($freport.getMoney("nontaxablesubtotal","0").isNegative()) negative #end" >$freport.getMoney("nontaxablesubtotal","0")</span></td>
				<td><span class="summary #if($freport.getMoney("taxablesubtotal","0").isNegative()) negative #end" >$freport.getMoney("taxablesubtotal","0")</span></td>
				<td><span class="summary #if($freport.getMoney("discount","0").isNegative()) negative #end" >$freport.getMoney("discount","0")</span></td>
				<td><span class="summary #if($freport.getMoney("subtotal","0").isNegative()) negative #end" >$freport.getMoney("subtotal","0")</span></td>
				<td><span class="summary #if($freport.getMoney("tax","0").isNegative()) negative #end" >$freport.getMoney("tax","0")</span></td>
				<td><span class="summary #if($freport.getMoney("total","0").isNegative()) negative #end" >$freport.getMoney("total","0")</span></td>
				<td><span class="summary #if($freport.getMoney("total","0").isNegative()) negative #end" >$freport.getMoney("total","0")</span></td>
				<td></td>
				<!-- <td><span class="summary #if($freport.getMoney("owing","0").isNegative()) negative #end" >$freport.getMoney("owing","0")</span></td>
				<td></td> -->
				#if($page.isPropertyTrue("show-vouchers"))
				<td></td>
				<td><span class="summary #if($freport.getMoney("voucher","0").isNegative()) negative #end" >$freport.getMoney("voucher","0")</span></td>
				#end
				<!-- <td><span class="summary #if($freport.getMoney("fees","0").isNegative()) negative #end" >$freport.getMoney("fees","0")</span></td> -->
				
			</tr>
		###</tfoot>
		</tbody>
	</table>
</div>