#foreach($group in $lgreport.getReportGroups()) #if($group.getCount() > 0) #foreach($hit in $group.getHitTracker()) #set($userprofile = $lgreport.loadObjectByField("userprofile","id",$hit.id)) #if($userprofile) #set($lg = $group.getLearningGroupData()) #set($studentid = "N/A") #if($userprofile.studentid) $set($studentid = $userprofile.studentid) #end #set($orders = $group.loadAuthorizedOrdersForStudent($userprofile)) #foreach ($order in $orders) #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.getPaymentMethod().getPrepaidCode()) #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 $group.incrementUniqueCount("classid",$lg.id) $group.addMoney("tax",$order.getTax()) $group.addMoney("total",$order.getTotalPrice()) #if($vouchervalue != "N/A") $group.addMoney("voucher",$vouchervalue) #end $group.addMoneyAsString("discount","0") #end #end #set($userprofile = false) #end #set($cols = [1..17]) #set($summary = 5) #foreach($i in $cols) #end #foreach($i in $cols) #end #foreach($i in $cols) #end #foreach($i in $cols) #end #foreach($i in $cols) #end #end #end

Class ID	Class Name	Start Date	End Date	Student ID	Last Name	First Name	Voucher Company	Date	Registration Status	Notes	Payment Date	Payment Method	Payment Amount	HST	Owing	Discount Amount	Discount Issuer	Voucher Number	Voucher Amount
$lg.id	$lg	$context.getDate($lg.startdate)	$context.getDate($lg.enddate)	$studentid	$userprofile.firstName	$userprofile.lastName	N/A	Date	Registration Status	Notes	$context.getDate($order.getDate())	$method	$order.getTotalPrice()	$order.getTax()	${D}0.00	${D}0.00	N/A	$vouchernumber	$vouchervalue
Summary of Class ID #$group.getLearningGroupData().getId()		Number of Students	$group.getCount()
	Tax	$group.getMoney("tax","0")
	Total	$group.getMoney("total","0")
	Voucher	$group.getMoney("voucher","0")
	Discount	$group.getMoney("discount","0")