帳票出力（Jasper/JXLS/POI）

/**
 * 検索結果をJasperReportingEntityDataSourceとして「orderItems」Attributeにセット。
 */
import org.iplass.mtp.ManagerLocator;
import org.iplass.mtp.entity.Entity;
import org.iplass.mtp.entity.EntityManager;
import org.iplass.mtp.entity.query.Query;
import org.iplass.mtp.entity.SearchResult;
import org.iplass.mtp.entity.LoadOption;
import org.iplass.mtp.entity.query.condition.predicate.Equals;
import org.iplass.mtp.web.template.report.JasperReportingEntityDataSource;


String oid = request.getParam("oid");
request.setAttribute("oid", oid);

EntityManager em = ManagerLocator.manager(EntityManager.class);

//Order検索(OrderItemは別で取得するのでReferenceは取得しない)
Entity order = em.load(oid, "test.report.Order", new LoadOption(false, false));
request.setAttribute("order", order);

//OrderItem検索
Query query = new Query()
    .select("price", "quantity", "product.name", "product.price")
    .from("test.report.OrderItem")
    .where(new Equals("order.oid", oid));
SearchResult<Entity> orderItems = em.searchEntity(query);

//JasperReportingEntityDataSourceとしてEntityのListを格納
request.setAttribute("orderItems", new JasperReportingEntityDataSource(orderItems.getList())); (1)

import org.iplass.mtp.ManagerLocator;
import org.iplass.mtp.entity.Entity;
import org.iplass.mtp.entity.EntityManager;
import org.iplass.mtp.entity.query.Query;
import org.iplass.mtp.entity.SearchResult;
import org.iplass.mtp.entity.LoadOption;
import org.iplass.mtp.entity.query.condition.predicate.Equals;


String oid = request.getParam("oid");
request.setAttribute("oid", oid);

EntityManager em = ManagerLocator.manager(EntityManager.class);

//Order検索(OrderItemは別で取得するのでReferenceは取得しない)
Entity order = em.load(oid, "test.report.Order", new LoadOption(false, false));
request.setAttribute("order", order);

//OrderItem検索
Query query = new Query()
    .select("price", "quantity", "product.name", "product.price")
    .from("test.report.OrderItem")
    .where(new Equals("order.oid", oid));
SearchResult<Entity> orderItems = em.searchEntity(query);

//EntityのListを格納
request.setAttribute("orderItems", orderItems.getList());

import org.iplass.mtp.ManagerLocator;
import org.iplass.mtp.entity.Entity;
import org.iplass.mtp.entity.EntityManager;
import org.iplass.mtp.entity.query.Query;
import org.iplass.mtp.entity.SearchResult;
import org.iplass.mtp.entity.LoadOption;
import org.iplass.mtp.entity.query.condition.predicate.Equals;

String oid = request.getParam("oid");
request.setAttribute("oid", oid);

EntityManager em = ManagerLocator.manager(EntityManager.class);

//Order検索(OrderItemは別で取得するのでReferenceは取得しない)
Entity order = em.load(oid, "test.report.Order", new LoadOption(false, false));
request.setAttribute("order", order);

//OrderItem検索
Query query = new Query()
    .select("price", "quantity", "product.name", "product.price")
    .from("test.report.OrderItem")
    .where(new Equals("order.oid", oid));
SearchResult<Entity> orderItems = em.searchEntity(query);

//Header部分の指定
request.setAttribute("headers", Arrays.asList("商品名", "数量", "単価", "金額"))

//Data部分(EntityのList)の指定
request.setAttribute("data", orderItems.getList());

import org.iplass.mtp.entity.Entity;
import org.iplass.mtp.entity.EntityManager;
import org.iplass.mtp.entity.LoadOption;
import org.iplass.mtp.entity.SearchResult;
import org.iplass.mtp.entity.query.Query;
import org.iplass.mtp.entity.query.condition.predicate.Equals;

def sheet = book.getSheet("order");
String oid = context.getParam("oid");

int rowNo = 1;
def row = sheet.getRow(rowNo);
row.getCell(4).setCellValue(oid);

EntityManager em = manager(EntityManager.class);
// Order検索(OrderItemは別で取得するのでReferenceは取得しない)
Entity order = em.load(oid, "test.report.Order", new LoadOption(false, false));

rowNo = 5;
row = sheet.getRow(rowNo);
row.getCell(0).setCellValue(order.orderNo);
row.getCell(1).setCellValue(order.customer);
row.getCell(2).setCellValue(order.address);
row.getCell(3).setCellValue(order.mail);
row.getCell(4).setCellValue(order.tel);

// OrderItem検索
Query query = new Query().select("price", "quantity", "product.name", "product.price")
        .from("test.report.OrderItem").where(new Equals("order.oid", oid));
SearchResult<Entity> orderItems = em.searchEntity(query);

rowNo = 9;
for (Entity item : orderItems.getList()) {
    row = sheet.getRow(rowNo);
    row.getCell(0).setCellValue(item.product.name);
    row.getCell(2).setCellValue(item.quantity);
    row.getCell(3).setCellValue(item.product.price);
    row.getCell(4).setCellValue(item.price);
    rowNo++;
}