#foreach($group in $preport.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 = $preport.loadObjectByField("learningGroup","id",$order.learninggroup)) #else #set($classdata = "") #end #set($cartitem = $order.getItems().get(0)) #set($product = $cartitem.getProduct()) #set($method = "") #set($vouchernumber = "N/A") #set($vouchervalue = "N/A") #if($order.getPaymentMethod().getType() == "prepaidcode") #set($method = "Voucher") #set($vouchernumber = $order.get("prepaid")) #set($vouchervalue = $order.getSubTotal()) #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 #if($group.isRefund()) #if($order.getRefunds().isEmpty() == false) #set($count = $count + 1) #set($refunds = $order.getRefunds()) #set($first = $refunds.get(0)) $group.addMoney("total",$order.calculateRefundTotal().multiply("-1.0")) $group.addMoney("refund_total",$order.calculateRefundTotal().multiply("-1.0")) #if($count == 1) #else #end #end #else $group.addMoney("total",$order.getTotalPrice()) $group.addMoney("payment_total",$order.getTotalPrice()) #if($velocityCount == 1) #else #end #end #end #if( $group.isRefund() == false || ($count != 0 && $group.isRefund())) #end #end #end ### ### $preport.generateSummary() ###

Report Name:		4.1.6.24: Payments and Transactions
Search:		$report.getOrders().getSearchQuery().toFriendly()
Date:		$context.getDateTime($preport.getDate())
Created By:		$preport.getUser()

	Order #	Payment Date	Payment Amount	Payment Authorization	Username	Last Name	First Name	Class ID	Class Name
$group.getLabel()		$order.getId()	$!context.getDate($first.getDate())	$order.calculateRefundTotal().multiply("-1.0")	$!first.getTransactionId()	$!{preport.loadObjectByField("detailedorderhistory","refundid",$first.getTransactionId()).userid}	$order.getCustomer().getLastName()	$order.getCustomer().getFirstName()	$!classdata.id	$!classdata.name
$group.getLabel()		$order.getId()	$context.getDate($order.getDate())	$order.getTotalPrice()	$!order.get("stripetoken")	$order.getCustomer().getId()	$order.getCustomer().getLastName()	$order.getCustomer().getFirstName()	$!classdata.id	$!classdata.name
$label Subtotals			$group.getMoney("total","0")
Total Payments			$preport.getMoney("payment_total","0")
Total Refunds			$preport.getMoney("refund_total","0")
Total Transactions			$preport.getMoney("total","0")

4.1.6.24: Payments and Transactions