#set($profitreport = $report.getProfitReport())

<h3>4.1.6.27: Profit Sharing Report</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($profitreport.getDate())</span></li>
	<li><span style="font-size:larger;"><strong>Created By:</strong> $profitreport.getUser()</span></li>
</ul>
 -->
 <br/>
<br/>

<div class="table-responsive1">
	<table id="report" class="table table-condensed">
		<thead>
			<tr class="details">
				<th colspan="4">Report Name:</th>
				<th colspan="8">4.1.6.27: Profit Sharing Report</th>
				<th colspan="5">&nbsp;</th>
			</tr>
			<tr class="details">
				<th colspan="4">Search:</th>
				<th colspan="8">$report.getOrders().getSearchQuery().toFriendly()</th>
				<th colspan="5">&nbsp;</th>
			</tr>
			<tr class="details">
				<th colspan="4">Date:</th>
				<th colspan="8">$context.getDateTime($profitreport.getDate())</th>
				<th colspan="5">&nbsp;</th>
			</tr>
			<tr class="details">
				<th colspan="4">Created By:</th>
				<th colspan="8">$profitreport.getUser()</th>
				<th colspan="5">&nbsp;</th>
			</tr>
			<tr class="details">
				<th colspan="17">&nbsp;</th>
			</tr>
			<tr>
				<th></th>
				<th>Class ID</th>
				<th>Class Name</th>
				<th>Order #</th>
				<th>Order Date</th>
				<th>Start Date</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>
				<th>Stripe Fee</th>
				<th>Profit Share</th>
				<th>Payment Authorization</th>
			</tr>
		</thead>
		<tbody>
			#foreach($group in $profitreport.getReportGroups())
				#set($count = 0)
				#if($group.getCount() > 0)
					#set($label = $group.getLabel())
					#foreach($hit in $group.getHitTracker())
						#set($order = $group.load($hit))
						#if($order.learninggroup)
							#set($classdata = $profitreport.loadObjectByField("learningGroup","id",$order.learninggroup))
						#else
							#set($classdata = "")
						#end
						#if($order.getPaymentMethod().getType() == "prepaidcode")
							#set($vouchernumber = $order.get("prepaid"))
						#end
						
						#set($stripefee = $group.getMoney($order.get("stripefee")))
						#set($profitshare = $group.getMoney($order.getValue("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("refund_subtotal",$order.calculateRefundSubtotal().multiply("-1.0"))
								$group.addMoney("refund_tax",$order.calculateRefundTax().multiply("-1.0"))
								$group.addMoney("refund_total",$order.calculateRefundTotal().multiply("-1.0"))
								$group.addMoney("refund_stripefee",$stripefee.multiply("-1.0"))
								$group.addMoney("refund_profitshare",$profitshare.multiply("-1.0"))
								
								<tr>
									#if($count == 1)
										<td><label>$group.getLabel()</label></td>
									#else
										<td></td>
									#end
									<td>$!classdata.id</td>
									<td>$!classdata.name</td>
									<td>$order.getId()</td>
									<td>$!context.getDate($first.getDate())</td>
									<td>$!context.getDate($classdata.startdate)</td>
									<td>$profitreport.getDisplayValue("userprofile","id",$order.getCustomer().getId(), "studentid","N/A")</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 class="negative">$order.calculateRefundTax().multiply("-1.0")</span></td>
									<td><span class="negative">$order.calculateRefundTotal().multiply("-1.0")</span></td>
									<td><span #if($stripefee.multiply("-1.0").isNegative()) class="negative" #end>$stripefee.multiply("-1.0")</span></td>
									<td><span #if($profitshare.multiply("-1.0").isNegative()) class="negative" #end>$profitshare.multiply("-1.0")</span></td>
									<td>$!first.getTransactionId()</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("stripefee",$stripefee)
							$group.addMoney("profitshare",$profitshare)
							
							$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_stripefee",$stripefee)
							$group.addMoney("payment_profitshare",$profitshare)
							<tr>
								#if($velocityCount == 1)
									<td><label>$group.getLabel()</label></td>
								#else
									<td></td>
								#end
								<td>$!classdata.id</td>
								<td>$!classdata.name</td>
								<td>$order.getId()</td>
								<td>$context.getDate($order.getDate())</td>
								<td>$!context.getDate($classdata.startdate)</td>
								<td>$profitreport.getDisplayValue("userprofile","id",$order.getCustomer().getId(), "studentid","N/A")</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>
								<td>$stripefee</td>
								<td>$profitshare</td>
								<td>$!order.get("stripetoken")</td>
							</tr>
							
						#end
						#set($vouchernumber = "")
						#set($net = "")
					#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><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("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("stripefee","0").isNegative())  negative #end" >$group.getMoney("stripefee","0")</span></td>
							<td><span class="subtotal #if($group.getMoney("profitshare","0").isNegative())  negative #end" >$group.getMoney("profitshare","0")</span></td>
							<td></td>
						</tr>
					#end
				#end
			#end
		###</tbody>
		###<tfoot>
			$profitreport.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><span class="summary #if($profitreport.getMoney("payment_nontaxablesubtotal","0").isNegative()) negative #end" >$profitreport.getMoney("payment_nontaxablesubtotal","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("payment_taxablesubtotal","0").isNegative()) negative #end" >$profitreport.getMoney("payment_taxablesubtotal","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("payment_subtotal","0").isNegative()) negative #end" >$profitreport.getMoney("payment_subtotal","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("payment_tax","0").isNegative()) negative #end" >$profitreport.getMoney("payment_tax","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("payment_total","0").isNegative()) negative #end" >$profitreport.getMoney("payment_total","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("payment_stripefee","0").isNegative()) negative #end" >$profitreport.getMoney("payment_stripefee","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("payment_profitshare","0").isNegative()) negative #end" >$profitreport.getMoney("payment_profitshare","0")</span></td>
				<td></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><span class="summary #if($profitreport.getMoney("refunds_nontaxablesubtotal","0").isNegative()) negative #end" >$profitreport.getMoney("refunds_nontaxablesubtotal","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("refunds_taxablesubtotal","0").isNegative()) negative #end" >$profitreport.getMoney("refunds_taxablesubtotal","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("refund_subtotal","0").isNegative()) negative #end" >$profitreport.getMoney("refund_subtotal","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("refund_tax","0").isNegative()) negative #end" >$profitreport.getMoney("refund_tax","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("refund_total","0").isNegative()) negative #end" >$profitreport.getMoney("refund_total","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("refund_stripefee","0").isNegative()) negative #end" >$profitreport.getMoney("refund_stripefee","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("refund_profitshare","0").isNegative()) negative #end" >$profitreport.getMoney("refund_profitshare","0")</span></td>
				<td></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><span class="summary #if($profitreport.getMoney("nontaxablesubtotal","0").isNegative()) negative #end" >$profitreport.getMoney("nontaxablesubtotal","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("taxablesubtotal","0").isNegative()) negative #end" >$profitreport.getMoney("taxablesubtotal","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("subtotal","0").isNegative()) negative #end" >$profitreport.getMoney("subtotal","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("tax","0").isNegative()) negative #end" >$profitreport.getMoney("tax","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("total","0").isNegative()) negative #end" >$profitreport.getMoney("total","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("stripefee","0").isNegative()) negative #end" >$profitreport.getMoney("stripefee","0")</span></td>
				<td><span class="summary #if($profitreport.getMoney("profitshare","0").isNegative()) negative #end" >$profitreport.getMoney("profitshare","0")</span></td>
				<td></td>
			</tr>
		###</tfoot>
		</tbody>
	</table>
</div>