#set($vreport = $report.getVoucherReport())
#set($D = " ")

<h3>4.1.6.03: Voucher Summary</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($vreport.getDate())</span></li>
	<li><span style="font-size:larger;"><strong>Created By:</strong> $vreport.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.03: Voucher Summary</th>
				<th colspan="6">&nbsp;</th>
			</tr>
			<tr class="details">
				<th colspan="4">Search:</th>
				<th colspan="8">$report.getOrders().getSearchQuery().toFriendly()</th>
				<th colspan="6">&nbsp;</th>
			</tr>
			<tr class="details">
				<th colspan="4">Date:</th>
				<th colspan="8">$context.getDateTime($vreport.getDate())</th>
				<th colspan="6">&nbsp;</th>
			</tr>
			<tr class="details">
				<th colspan="4">Created By:</th>
				<th colspan="8">$vreport.getUser()</th>
				<th colspan="6">&nbsp;</th>
			</tr>
			<tr class="details">
				<th colspan="18">&nbsp;</th>
			</tr>
			<tr>
				<th></th>
				<th>Voucher Number</th>
				<th>Sequence Number</th>
				<th>Issued To</th>
				<th>Issue Date</th>
				<th>Start Date</th>
				<th>Expiration Date</th>
				<th>Issuer</th>
				<th>Class ID</th>
				<th>Class Name</th>
				<!-- <th>Pre-Tax Value</th> -->
				<th>Date Redeemed</th>
				<th>Order #</th>
				<th>Student ID</th>
				<th>Last Name</th>
				<th>First Name</th>
				<th>Non-taxable Tuition</th>
				<th>Taxable Tuition</th>
				<th>Subtotal</th>
				<th>Taxes</th>
				<th>Total</th>
			</tr>
		</thead>
		<tbody>
			#foreach($group in $vreport.getReportGroups())
				#set($count = 0)
				#if($group.getCount() > 0)
					#set($label = $group.getLabel())
					#foreach($hit in $group.getHitTracker())
						#set($order = $group.load($hit))
						#set($vouchernumber = "N/A")
						#set($vouchervalue = "N/A")
						#set($expiration = "N/A")
						#set($vouchernumber = $order.get("prepaid"))
						#set($vouchervalue = $order.getSubTotal())
						#set($cartitem = $order.getItems().get(0))
						
						#set($classlist = $order.getValues("learninggroup").get(0))
						#set($classdata = $vreport.loadObjectByField("learningGroup","id",$classlist))
						
						#set($product = $cartitem.getProduct())
						#set($price = $product.getYourPrice())
						
						###get prepaidcode data
						#set($prepaidcodedata = $vreport.loadObjectByField("prepaid","id",$vouchernumber))
						
						#set($studentid = $vreport.getDisplayValue("userprofile","id",$order.getCustomer().getId(), "studentid","N/A"))
						####set($issuedto = $vreport.getDisplayValue("userprofile","id",$prepaidcodedata.user, "name","N/A"))
						#set($issuedto = $vreport.getDisplayValue("college","id",$prepaidcodedata.college, "name","N/A"))
						#set($issuedby = $vreport.getDisplayValue("userprofile","id",$prepaidcodedata.issuedby, "name","N/A"))
						
						#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("voucher",$price.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_voucher",$price.multiply("-1.0"))
									
									<tr>
										#if($count == 1)
											<td><label>$group.getLabel()</label></td>
										#else
											<td></td>
										#end
										<td>$vouchernumber</td>
										<td>$!{prepaidcodedata.sequencenumber}</td>
										<td>$issuedto</td>
										<td>$!context.getDate($prepaidcodedata.issuedate)</td>
										<td>$!context.getDate($prepaidcodedata.startdate)</td>
										<td>$!context.getDate($prepaidcodedata.expiry)</td>
										<td>$issuedby</td>
										<td>$!classdata.id</td>
										<td>$!classdata.name</td>
										<!-- <td><span class="negative">$order.calculateRefundTotal().multiply("-1.0")</span></td> -->
										<td>$context.getDate($first.getDate())</td>
										<td>$order.getId()</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><span class="negative">$order.calculateRefundSubtotal().multiply("-1.0")</span></td>
										<td><span #if($order.calculateRefundTax().isZero()==false) class="negative" #end>$order.calculateRefundTax().multiply("-1.0")</span></td>
										<td><span class="negative">$order.calculateRefundTotal().multiply("-1.0")</span></td>
									</tr>
								#end
						#else
						
							$group.addMoney("taxablesubtotal",$order.getTaxableSubtotal())
							$group.addMoney("nontaxablesubtotal",$order.getNonTaxableSubtotal())
							$group.addMoney("subtotal",$order.getSubTotal())
							$group.addMoney("tax",$order.getTax())
							$group.addMoney("total",$order.getTotalPrice())
							$group.addMoney("voucher",$price)
							
							$group.addMoney("payment_taxablesubtotal",$order.getTaxableSubtotal())
							$group.addMoney("payment_nontaxablesubtotal",$order.getNonTaxableSubtotal())
							$group.addMoney("payment_subtotal",$order.getSubTotal())
							$group.addMoney("payment_tax",$order.getTax())
							$group.addMoney("payment_total",$order.getTotalPrice())
							$group.addMoney("payment_voucher",$price)
							
							<tr>
								#if($velocityCount == 1)
									<td><label>$group.getLabel()</label></td>
								#else
									<td></td>
								#end
								<td>$vouchernumber</td>
								<td>$!{prepaidcodedata.sequencenumber}</td>
								<td>$issuedto</td>
								<td>$!context.getDate($prepaidcodedata.issuedate)</td>
								<td>$!context.getDate($prepaidcodedata.startdate)</td>
								<td>$!context.getDate($prepaidcodedata.expiry)</td>
								<td>$issuedby</td>
								<td>$!classdata.id</td>
								<td>$!classdata.name</td>
								<!-- <td>$price</td> -->
								<td>$context.getDate($order.getDate())</td>
								<td>$order.getId()</td>
								<td>$studentid</td>
								<td>$order.getCustomer().getLastName()</td>
								<td>$order.getCustomer().getFirstName()</td>
								<td>$order.getNonTaxableSubtotal()</td>
								<td>$order.getTaxableSubtotal()</td>
								<td>$order.getSubTotal()</td>
								<td>$order.getTax()</td>
								<td>$order.getTotalPrice()</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  class="subtotal" >$group.getMoney("voucher","0")</td> -->
						<td></td>
						<td></td>
						<td></td>
						<td></td>
						<td></td>
						<td class="subtotal" >$group.getMoney("nontaxablesubtotal","0")</td>
						<td class="subtotal" >$group.getMoney("taxablesubtotal","0")</td>
						<td class="subtotal" >$group.getMoney("subtotal","0")</td>
						<td class="subtotal" >$group.getMoney("tax","0")</td>
						<td class="subtotal" >$group.getMoney("total","0")</td>
					</tr>
					#end
				#end
			#end
		###</tbody>
		####<tfoot>
			$vreport.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($vreport.getMoney("payment_voucher","0").isNegative()) negative #end" >$vreport.getMoney("payment_voucher","0")</span></td> -->
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td><span class="summary #if($vreport.getMoney("payment_nontaxablesubtotal","0").isNegative()) negative #end" >$vreport.getMoney("payment_nontaxablesubtotal","0")</span></td>
				<td><span class="summary #if($vreport.getMoney("payment_taxablesubtotal","0").isNegative()) negative #end" >$vreport.getMoney("payment_taxablesubtotal","0")</span></td>
				<td><span class="summary #if($vreport.getMoney("payment_subtotal","0").isNegative()) negative #end" >$vreport.getMoney("payment_subtotal","0")</span></td>
				<td><span class="summary #if($vreport.getMoney("payment_tax","0").isNegative()) negative #end" >$vreport.getMoney("payment_tax","0")</span></td>
				<td><span class="summary #if($vreport.getMoney("payment_total","0").isNegative()) negative #end" >$vreport.getMoney("payment_total","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($vreport.getMoney("refunds_total","0").isNegative()) negative #end" >$vreport.getMoney("refunds_voucher","0")</span></td> -->
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td><span class="summary #if($vreport.getMoney("refunds_nontaxablesubtotal","0").isNegative()) negative #end" >$vreport.getMoney("refunds_nontaxablesubtotal","0")</span></td>
				<td><span class="summary #if($vreport.getMoney("refunds_taxablesubtotal","0").isNegative()) negative #end" >$vreport.getMoney("refunds_taxablesubtotal","0")</span></td>
				<td><span class="summary #if($vreport.getMoney("refunds_subtotal","0").isNegative()) negative #end" >$vreport.getMoney("refunds_subtotal","0")</span></td>
				<td><span class="summary #if($vreport.getMoney("refunds_tax","0").isNegative()) negative #end" >$vreport.getMoney("refunds_tax","0")</span></td>
				<td><span class="summary #if($vreport.getMoney("refunds_total","0").isNegative()) negative #end" >$vreport.getMoney("refunds_total","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 class="summary">$vreport.getMoney("voucher","0")</td> -->
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td></td>
				<td><span class="summary #if($vreport.getMoney("nontaxablesubtotal","0").isNegative()) negative #end" >$vreport.getMoney("nontaxablesubtotal","0")</span></td>
				<td><span class="summary #if($vreport.getMoney("taxablesubtotal","0").isNegative()) negative #end" >$vreport.getMoney("taxablesubtotal","0")</span></td>
				<td><span class="summary #if($vreport.getMoney("subtotal","0").isNegative()) negative #end" >$vreport.getMoney("subtotal","0")</span></td>
				<td><span class="summary #if($vreport.getMoney("tax","0").isNegative()) negative #end" >$vreport.getMoney("tax","0")</span></td>
				<td><span class="summary #if($vreport.getMoney("total","0").isNegative()) negative #end" >$vreport.getMoney("total","0")</span></td>
			</tr>
		###</tfoot>
		</tbody>
	</table>
</div>