public static void exportDispatches(String fileName, List<Dispatch> dispatchList) {
logger.info("Export Dispatches to excel");
ExcelGenerator generator = new ExcelGenerator(fileName);
List<String[]> headerList = new ArrayList<>();
List<String> sheetNames = new ArrayList<>();
sheetNames.add("菜品配送");
headerList.add(new String[] {"菜品", "总量", "单位", "配送信息"});
List<List<String[]>> contents = new ArrayList<>();
List<String[]> content = new ArrayList<>();
for (Dispatch dispatch : dispatchList) {
content.add(
new String[] {
dispatch.getProduct().getName(),
String.valueOf(dispatch.getQuantity()),
dispatch.getUnit(),
formatDispatchList(dispatch.getOrderInfoList())
});
}
contents.add(content);
try {
generator.generate4Dispatches(sheetNames, headerList, contents);
} catch (IOException e) {
e.printStackTrace();
return;
}
}
