public static void test() {
String beginTime = "2017-10-08";
String endTime = "2017-10-11";
HSSFWorkbook wb = new HSSFWorkbook();
Date b = (beginTime, "yyyy-MM-dd");
Date e = (endTime, "yyyy-MM-dd");
String bs = (b, "");
String es = (e, "");
String sheetName = bs + "-" + es;
HSSFSheet sheet = (sheetName);
HSSFRow row = ((short) 0);//First line//Customized watch header
List<String> header = new ArrayList<>();
("department");
("post");
("Employee Number");
("Name");
("Service Center Name");
("Time period");
("frequency");
("Date of visit");
("Store time");
("Duration (minutes)");
HSSFCellStyle style = ();
(HSSFCellStyle.ALIGN_LEFT);//Center horizontally
(HSSFCellStyle.VERTICAL_CENTER);//Vertical centered
(true);//Automatic line wrap
((short) 5);//indentation
for (int i = 0; i < (); i++) {
HSSFCell cell = (i);
((i));
}
// List<OaPunchVisitDataDto>
// dtos=(beginTime, endTime, departName,
// name);
List<OaPunchVisitDataDto> dtos = ();
OaPunchVisitDataDto dto = new OaPunchVisitDataDto();
("Zhang San");
("Development Department");
dto.setLOCATION_TITLE("Wulidian");
("10000");
("staff");
dto.setCHECK_TIME("2017-10-09");
dto.setCHECK_ATS("2017-10-09 09:54,2017-10-09 17:54");
OaPunchVisitDataDto dto1 = new OaPunchVisitDataDto();
("Zhang San");
("Development Department");
dto1.setLOCATION_TITLE("Wulidian 1");
("10000");
("staff");
dto1.setCHECK_TIME("2017-10-10");
dto1.setCHECK_ATS("2017-10-10 09:54,2017-10-10 17:54");
OaPunchVisitDataDto dto3 = new OaPunchVisitDataDto();
("Zhang San2");
("Development Department");
dto3.setLOCATION_TITLE("Wulidian");
("10001");
("staff");
dto3.setCHECK_TIME("2017-10-10,2017-10-11");
dto3.setCHECK_ATS("2017-10-10 09:54,2017-10-10 17:54,2017-10-11 09:54,2017-10-11 17:54");
OaPunchVisitDataDto dto5 = new OaPunchVisitDataDto();
("Zhang San2");
("Development Department");
dto5.setLOCATION_TITLE("Wulidian 1");
("10001");
("staff");
dto5.setCHECK_TIME("2017-10-08");
dto5.setCHECK_ATS("2017-10-08 09:54,2017-10-08 17:54");
(dto);
(dto1);
(dto3);
(dto5);
Multimap<String, OaPunchVisitDataDto> multimap = ();
Set<String> keySet = new HashSet<>();
for (OaPunchVisitDataDto data : dtos) {
(());
((), data);
}
//Data rows----------------------------------------------------------------------------------------------------------------------------
if (keySet != null && () > 0) {
int i = 0;
int temp = 0;
for (String key : keySet) {
int maxRow = 0;
for (OaPunchVisitDataDto a : (key)) {
//Get the maximum number of merged rows
if (a.getCHECK_TIME() != null) {
maxRow += (a.getCHECK_TIME().split(",")).size();
}
}
for (int c = 1 + temp; c < i + 1 + maxRow; c++) {// 4 hang
HSSFRow rows = (c);//
for (int x = 0; x < (); x++) {
(x);
("row:"+c+",cloum:"+x);
("row:"+c+",cloum:"+x);
}
}
temp = i + maxRow;
i = i + maxRow;
}
//Assignment
int xx = 0;
int cloumcount5 = 0;//Count of fifth column
int cloumcount7 = 0;
for (String key : keySet) {
int maxRow = 0;
Multimap<String,OaPunchSiteDataTempDto> localtionsMap = ();//Access date collection
Set<String> localtions = ();//Access location collection
for (OaPunchVisitDataDto a : (key)) {
//Get the maximum number of merged rows
if (a.getCHECK_TIME() != null) {
maxRow += (a.getCHECK_TIME().split(",")).size();
}
List<String> visitDates = ();
if (a.getCHECK_TIME() != null) {
visitDates = (a.getCHECK_TIME().split(","));
}
OaPunchSiteDataTempDto tdto=new OaPunchSiteDataTempDto();
(visitDates);
(a.getCHECK_ATS());
//Used to determine the number of rows that need to be merged in column 5 (Service Center)
(a.getLOCATION_TITLE(), tdto);
(a.getLOCATION_TITLE());
}
String departname = (key).iterator().next().getDEPARTNAME() == null ? ""
: (key).iterator().next().getDEPARTNAME();
String position = (key).iterator().next().getPOSITION() == null ? ""
: (key).iterator().next().getPOSITION();
String userid = key;
String username = (key).iterator().next().getNAMES() == null ? ""
: (key).iterator().next().getNAMES();
("xx+1:"+(xx+1));
HSSFCell cell0 = (xx + 1).getCell(0);
HSSFCell cell1 = (xx + 1).getCell(1);
HSSFCell cell2 = (xx + 1).getCell(2);
HSSFCell cell3 = (xx + 1).getCell(3);
(departname);
(position);
(userid);
(username);
(style);
(style);
(style);
(style);
/*** Merge the first 4 columns*/
("xx+1:"+(xx+1));
("xx + 1+maxRow:"+(xx + 1+maxRow));
/*** Merge the first 4 columns*/
( new CellRangeAddress((xx + 1), (xx+maxRow), 0, 0) );
( new CellRangeAddress((xx + 1), (xx+maxRow), 1, 1) );
( new CellRangeAddress((xx + 1), (xx+maxRow), 2, 2) );
( new CellRangeAddress((xx + 1), (xx+maxRow), 3, 3) );
for (String localtionKey : localtions) {
int size = (localtionKey).iterator().next().getDates().size();
//Column 5 performs assignment
HSSFCell cell4 = (cloumcount5 + 1).getCell(4);
(localtionKey);
(style);
//Column 6 performs assignment
HSSFCell cell5 = (cloumcount5 + 1).getCell(5);
(beginTime+"--"+endTime);
//(style);
//The seventh column is assigned
HSSFCell cell6 = (cloumcount5 + 1).getCell(6);
(size);
(style);
/*** Merge 5--7 columns of data*/
( new CellRangeAddress(cloumcount5 + 1, cloumcount5+size, 4, 4) );
( new CellRangeAddress(cloumcount5 + 1, cloumcount5+size, 5, 5) );
( new CellRangeAddress(cloumcount5 + 1, cloumcount5+size, 6, 6) );
("size:"+size);
cloumcount5 = cloumcount5 + size;
Iterator<OaPunchSiteDataTempDto> iterator = (localtionKey).iterator();
int m = 0;
while (()) {
OaPunchSiteDataTempDto po=();
List<String> visitDates = ();
String[] visitDatesAts= ().split(",");
for (String visitDate : visitDates) {
HSSFCell cell7 = ((m + 1 + cloumcount7)).getCell(7);
(visitDate);
(style);
Map<String, String> map=(visitDate, visitDatesAts);
HSSFCell cell8 = ((m + 1 + cloumcount7)).getCell(8);
(("timeAt"));
(style);
HSSFCell cell9 = ((m + 1 + cloumcount7)).getCell(9);
(("min"));
(style);
m++;
}
}
cloumcount7 = cloumcount7 + size;
}
xx = xx + maxRow;
}
(20);
FileOutputStream fileOut;
try {
fileOut = new FileOutputStream("f://");
(fileOut);
();
} catch (Exception e1) {
();
}
("OK");
}
}
