public static void export(Long project_id) {
// Prepare data
Project p = getActiveProject();
if (p == null) {
notFound("Project", project_id);
}
List<Listing> listings = p.listings;
List<String> sheetNames = new ArrayList();
List maps = new ArrayList();
for (Listing l : listings) {
Map map = new HashMap();
map.put("project", VProject.createFromProject(p));
sheetNames.add("(" + l.id + ") " + l.listingName);
// l.items = Item.findByListing(l, "", l.sort, 1000);
map.put("listing", l.listingName);
map.put("items", Item.findByListing(l, "", l.sort, 1000));
List<ItemField> selected_fields = l.getItemFields();
List<ItemField> all_fields = Item.getItemFields();
List<ItemField> other_fields = new ArrayList<ItemField>();
for (ItemField i : all_fields) {
if (!l.hasField(i.fieldName)) {
other_fields.add(i);
}
}
;
map.put("selected_fields", selected_fields);
map.put("other_fields", other_fields);
maps.add(map);
}
// Prepare template and data for excel export
String filepath =
Play.applicationPath
+ File.separator
+ "app"
+ File.separator
+ "views"
+ File.separator
+ "projects"
+ File.separator
+ "export.xls";
VirtualFile templateFile = VirtualFile.open(filepath);
InputStream inputStream = templateFile.inputstream();
MiscUtil.ConsoleLog("use sync excel rendering");
long start = System.currentTimeMillis();
try {
Workbook workbook =
new XLSTransformer()
.transformMultipleSheetsList(inputStream, maps, sheetNames, "map", new HashMap(), 0);
workbook.write(response.out);
inputStream.close();
MiscUtil.ConsoleLog("Excel sync render takes " + (System.currentTimeMillis() - start));
} catch (Exception e) {
MiscUtil.ConsoleLog("ERROR: " + e.getMessage());
error();
}
// Set correct response header
try {
response.setHeader(
"Content-Disposition",
"attachment; filename=" + (new URLCodec("utf-8").encode(p.name)) + ".xls");
} catch (EncoderException e) {
response.setHeader("Content-Disposition", "attachment; filename=exported.xls");
}
response.setContentTypeIfNotSet("application/vnd.ms-excel");
}
