List of usage examples for org.apache.poi.hssf.usermodel HSSFCellStyle setAlignment
@Override public void setAlignment(HorizontalAlignment align)
From source file:com.ah.ui.actions.admin.LicenseMgrAction.java
License:Open Source License
private void exportEntitleKeyInfo() { try {/*from w w w . java2s .co m*/ // create a new file FileOutputStream out = new FileOutputStream(ORDERKEYINFO_EXPORT_FILE_PATH); // create a new workbook HSSFWorkbook wb = new HSSFWorkbook(); // create a new sheet HSSFSheet s = wb.createSheet("Sheet1"); // declare a row object reference HSSFRow r = null; // declare a cell object reference HSSFCell c = null; // row index int rowNum = 0; // cell count int cellcount = 0; if (NmsUtil.isHMForOEM()) { cellcount = 7; } else if (getIsInHomeDomain()) { cellcount = 8; } else if (NmsUtil.isHostedHMApplication()) { cellcount = 9; } if (cellcount == 0) { return; } else { for (int i = 0; i < cellcount; i++) { s.setColumnWidth(i, getColumnWidthByIndex(i) * 256); } } // create cell style HSSFCellStyle cs = wb.createCellStyle(); // create font object HSSFFont f = wb.createFont(); //set font to 12 point type f.setFontHeightInPoints((short) 12); f.setFontName("Calibri"); //set cell stlye cs.setFont(f); cs.setAlignment(CellStyle.ALIGN_CENTER); cs.setVerticalAlignment(CellStyle.VERTICAL_BOTTOM); // create cell style HSSFCellStyle cs1 = wb.createCellStyle(); // create font object HSSFFont f1 = wb.createFont(); //set font to 12 point type f1.setFontHeightInPoints((short) 12); f1.setFontName("Calibri"); f1.setBoldweight(Font.BOLDWEIGHT_BOLD); //set cell stlye cs1.setFont(f1); cs1.setAlignment(CellStyle.ALIGN_RIGHT); cs1.setVerticalAlignment(CellStyle.VERTICAL_BOTTOM); // create cell style HSSFCellStyle cs2 = wb.createCellStyle(); cs2.setFont(f1); cs2.setAlignment(CellStyle.ALIGN_CENTER); cs2.setVerticalAlignment(CellStyle.VERTICAL_BOTTOM); // create cell style HSSFCellStyle cs3 = wb.createCellStyle(); cs3.setFont(f); cs3.setAlignment(CellStyle.ALIGN_RIGHT); cs3.setVerticalAlignment(CellStyle.VERTICAL_BOTTOM); // create cell style HSSFCellStyle cs4 = wb.createCellStyle(); cs4.setFont(f1); cs4.setAlignment(CellStyle.ALIGN_LEFT); cs4.setVerticalAlignment(CellStyle.VERTICAL_BOTTOM); // create cell style HSSFCellStyle cs5 = wb.createCellStyle(); // create font object HSSFFont f2 = wb.createFont(); //set font to 12 point type f2.setFontHeightInPoints((short) 12); f2.setFontName("Calibri"); f2.setBoldweight(Font.BOLDWEIGHT_BOLD); f2.setColor(Font.COLOR_RED); cs5.setFont(f2); cs5.setAlignment(CellStyle.ALIGN_LEFT); cs5.setVerticalAlignment(CellStyle.VERTICAL_BOTTOM); // create cell style HSSFCellStyle cs6 = wb.createCellStyle(); cs6.setFont(f); cs6.setAlignment(CellStyle.ALIGN_LEFT); cs6.setVerticalAlignment(CellStyle.VERTICAL_BOTTOM); // create a row // row 1 s.addMergedRegion(new CellRangeAddress(0, 0, 0, cellcount - 1)); r = s.createRow(rowNum++); c = r.createCell(0); c.setCellValue(MgrUtil.getUserMessage("admin.license.orderkey.export.title")); c.setCellStyle(cs); // row 2 String sysInfo = ""; if (getIsInHomeDomain()) { sysInfo = "System ID: " + getSystemId(); // HiveManager Online user } else if (NmsUtil.isHostedHMApplication()) { sysInfo = "VHM ID: " + getDomain().getVhmID(); } s.addMergedRegion(new CellRangeAddress(1, 1, 0, cellcount - 1)); r = s.createRow(rowNum++); c = r.createCell(0); c.setCellValue(sysInfo); c.setCellStyle(cs); // row 3 s.addMergedRegion(new CellRangeAddress(2, 2, 0, cellcount - 1)); r = s.createRow(rowNum++); c = r.createCell(0); List<?> userInfo = QueryUtil.executeQuery( "SELECT email, company FROM " + UserRegInfoForLs.class.getSimpleName(), null, new FilterParams("owner.domainName", getDomain().getDomainName())); if (!userInfo.isEmpty()) { Object[] userInfos = (Object[]) userInfo.get(0); c.setCellValue(MgrUtil.getUserMessage("admin.license.orderkey.export.email.company", new String[] { (String) userInfos[0], (String) userInfos[1] })); } c.setCellStyle(cs); // row 4 r = s.createRow(rowNum++); // row 5 r = s.createRow(rowNum++); // row 6 cell 1 c = r.createCell(0); c.setCellValue(MgrUtil.getUserMessage("admin.license.orderkey.export.device.licensed")); c.setCellStyle(cs1); // row 6 cell 2 c = r.createCell(1); c.setCellValue(licenseInfo.getHiveAps()); c.setCellStyle(cs2); // device management info Map<String, Integer> apcount = HiveAPInfoFromeDatabase .getManagedDeviceTypeAndNumber(getDomain().getDomainName()); int vpnCount = 0; int totalCount = 0; if (null != apcount) { Object[] typeNames = apcount.keySet().toArray(); Arrays.sort(typeNames); for (Object typeName : typeNames) { // VPN Gateway VA does not belong to device if (MgrUtil.getEnumString("enum.hiveAp.model.10").equals(typeName)) { vpnCount = apcount.get(typeName); } else { r = s.createRow(rowNum++); c = r.createCell(0); c.setCellValue((String) typeName); c.setCellStyle(cs3); c = r.createCell(1); c.setCellValue(apcount.get(typeName)); c.setCellStyle(cs); totalCount += apcount.get(typeName); } } } // managed device total number cell1 r = s.createRow(rowNum++); c = r.createCell(0); c.setCellValue(MgrUtil.getUserMessage("admin.license.orderkey.export.device.total")); c.setCellStyle(cs1); // managed device total number cell2 c = r.createCell(1); c.setCellValue(totalCount); c.setCellStyle(cs2); // blank row r = s.createRow(rowNum++); // licensed VPN Gateway VA cell1 r = s.createRow(rowNum++); c = r.createCell(0); c.setCellValue(MgrUtil.getUserMessage("admin.license.orderkey.export.cvg.licensed")); c.setCellStyle(cs1); // licensed VPN Gateway VA cell2 c = r.createCell(1); c.setCellValue(licenseInfo.getCvgNumber()); c.setCellStyle(cs2); // managed VPN Gateway VA cell1 r = s.createRow(rowNum++); c = r.createCell(0); c.setCellValue(MgrUtil.getUserMessage("admin.license.orderkey.export.cvg.total")); c.setCellStyle(cs1); // managed VPN Gateway VA cell 2 c = r.createCell(1); c.setCellValue(vpnCount); c.setCellStyle(cs2); // entitlement key information preparePage(); if (null != page && !page.isEmpty()) { r = s.createRow(rowNum++); List<OrderHistoryInfo> normalKey = new ArrayList<>(); List<OrderHistoryInfo> invalidKey = new ArrayList<>(); List<OrderHistoryInfo> expiredKey = new ArrayList<>(); for (Object obj : page) { OrderHistoryInfo orderInfo = (OrderHistoryInfo) obj; if (orderInfo.getStatusFlag() == OrderHistoryInfo.ENTITLE_KEY_STATUS_NORMAL && orderInfo.getCvgStatusFlag() == OrderHistoryInfo.ENTITLE_KEY_STATUS_NORMAL) { normalKey.add(orderInfo); } else if (orderInfo.getStatusFlag() == OrderHistoryInfo.ENTITLE_KEY_STATUS_DISABLE || orderInfo.getCvgStatusFlag() == OrderHistoryInfo.ENTITLE_KEY_STATUS_DISABLE) { invalidKey.add(orderInfo); } else { expiredKey.add(orderInfo); } } if (!normalKey.isEmpty()) { // normal entitle key title r = s.createRow(rowNum++); setEntitlementKeyCellValue(cellcount, cs4, null, r, null, MgrUtil.getUserMessage("order.key")); // normal entitle key info for (OrderHistoryInfo keyInfo : normalKey) { r = s.createRow(rowNum++); setEntitlementKeyCellValue(cellcount, cs6, cs3, r, keyInfo, null); } } if (!invalidKey.isEmpty()) { if (!normalKey.isEmpty()) { r = s.createRow(rowNum++); r = s.createRow(rowNum++); } // invalid entitle key title r = s.createRow(rowNum++); setEntitlementKeyCellValue(cellcount, cs5, null, r, null, MgrUtil.getUserMessage("admin.license.orderkey.export.invalidkey.title")); // invalid entitle key info for (OrderHistoryInfo keyInfo : invalidKey) { r = s.createRow(rowNum++); setEntitlementKeyCellValue(cellcount, cs6, cs3, r, keyInfo, null); } } if (!expiredKey.isEmpty()) { if (!normalKey.isEmpty() || !invalidKey.isEmpty()) { r = s.createRow(rowNum++); r = s.createRow(rowNum++); } // expired entitle key title r = s.createRow(rowNum++); setEntitlementKeyCellValue(cellcount, cs5, null, r, null, MgrUtil.getUserMessage("admin.license.orderkey.export.expiredkey.title")); // expired entitle key info for (OrderHistoryInfo keyInfo : expiredKey) { r = s.createRow(rowNum++); setEntitlementKeyCellValue(cellcount, cs6, cs3, r, keyInfo, null); } } } // write the workbook to the output stream // close our file (don't blow out our file handles) wb.write(out); out.close(); generateAuditLog(HmAuditLog.STATUS_SUCCESS, MgrUtil.getUserMessage("hm.audit.log.export.entitlement.key")); } catch (Exception ex) { generateAuditLog(HmAuditLog.STATUS_FAILURE, MgrUtil.getUserMessage("hm.audit.log.export.entitlement.key")); log.error("exportEntitleKeyInfo()", ex.getMessage()); } }
From source file:com.aimluck.eip.modules.screens.AddressBookCompanyWordXlsExportScreen.java
License:Open Source License
private void setupAddressBookSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { String sheet_name = "()"; // ?/* w w w.j a v a2s. c o m*/ String[] headers = { "??", "??", "??", "?", "?", "?", "FAX", "URL" }; // 01 short[] cell_enc_types = { HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16 }; HSSFSheet sheet = createHSSFSheet(wb, sheet_name, headers, cell_enc_types); int rowcount = 0; // ? HSSFCellStyle style_col = wb.createCellStyle(); style_col.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style_col.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY); AddressBookCompanyWordSelectData listData = new AddressBookCompanyWordSelectData(); listData.initField(); listData.setRowsNum(1000); listData.doSelectList(this, rundata, context); int page_num = listData.getPagesNum(); int current_page = 1; while (true) { int listsize = listData.getList().size(); AddressBookCompanyResultData rd; for (int j = 0; j < listsize; j++) { rd = (AddressBookCompanyResultData) listData.getList().get(j); String[] rows = { rd.getCompanyName().getValue(), rd.getCompanyNameKana().getValue(), rd.getPostName().getValue(), rd.getZipcode().getValue(), rd.getAddress().getValue(), rd.getTelephone().getValue(), rd.getFaxNumber().getValue(), rd.getUrl().getValue() }; rowcount = rowcount + 1; addRow(sheet.createRow(rowcount), cell_enc_types, rows); } current_page++; if (current_page > page_num) { break; } listData.setCurrentPage(current_page); listData.doSelectList(this, rundata, context); } int uid = ALEipUtils.getUserId(rundata); ALEventlogFactoryService.getInstance().getEventlogHandler().logXlsScreen(uid, "()", 163/* ALEventlogConstants.PORTLET_TYPE_ADDRESSBOOK_XLS_SCREEN */); }
From source file:com.aimluck.eip.modules.screens.AddressBookCompanyXlsExportScreen.java
License:Open Source License
private void setupAddressBookSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { String sheet_name = "()"; // ?// w ww. j ava 2s . co m String[] headers = { "??", "??", "??", "?", "?", "?", "FAX", "URL" }; // 01 short[] cell_enc_types = { HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16 }; HSSFSheet sheet = createHSSFSheet(wb, sheet_name, headers, cell_enc_types); int rowcount = 0; // ? HSSFCellStyle style_col = wb.createCellStyle(); style_col.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style_col.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY); AddressBookCompanySelectData listData = new AddressBookCompanySelectData(); listData.initField(); listData.setRowsNum(1000); listData.doSelectList(this, rundata, context); int page_num = listData.getPagesNum(); int current_page = 1; while (true) { int listsize = listData.getList().size(); AddressBookCompanyResultData rd; for (int j = 0; j < listsize; j++) { rd = (AddressBookCompanyResultData) listData.getList().get(j); String[] rows = { rd.getCompanyName().getValue(), rd.getCompanyNameKana().getValue(), rd.getPostName().getValue(), rd.getZipcode().getValue(), rd.getAddress().getValue(), rd.getTelephone().getValue(), rd.getFaxNumber().getValue(), rd.getUrl().getValue() }; rowcount = rowcount + 1; addRow(sheet.createRow(rowcount), cell_enc_types, rows); } current_page++; if (current_page > page_num) { break; } listData.setCurrentPage(current_page); listData.doSelectList(this, rundata, context); } int uid = ALEipUtils.getUserId(rundata); ALEventlogFactoryService.getInstance().getEventlogHandler().logXlsScreen(uid, "()", 163/* ALEventlogConstants.PORTLET_TYPE_ADDRESSBOOK_XLS_SCREEN */); }
From source file:com.aimluck.eip.modules.screens.AddressBookWordXlsExportScreen.java
License:Open Source License
private void setupAddressBookSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { String sheet_name = ""; // ?//w w w. j a va 2 s . co m String[] headers = { "???", "???", "", "?", "??", "?", "??", "??", "??", "?", "?", "?", "FAX?", "URL", "???", "" }; // 01 short[] cell_enc_types = { HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16 }; HSSFSheet sheet = createHSSFSheet(wb, sheet_name, headers, cell_enc_types); int rowcount = 0; // ? HSSFCellStyle style_col = wb.createCellStyle(); style_col.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style_col.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY); AddressBookFilterdSelectData listData; listData = new AddressBookFilterdSelectData(); listData.initField(); listData.setRowsNum(1000); listData.doSelectList(this, rundata, context); listData.loadGroups(rundata, context); int page_num = listData.getPagesNum(); int current_page = 1; while (true) { int listsize = listData.getList().size(); AddressBookResultData rd; for (int j = 0; j < listsize; j++) { rd = (AddressBookResultData) listData.getList().get(j); String[] rows = { rd.getName().getValue(), rd.getNameKana().getValue(), rd.getEmail().getValue(), rd.getTelephone().getValue(), rd.getCellularPhone().getValue(), rd.getCellularMail().getValue(), rd.getCompanyName().getValue(), rd.getCompanyNameKana().getValue(), rd.getPostName().getValue(), rd.getZipcode().getValue(), rd.getCompanyAddress().getValue(), rd.getCompanyTelephone().getValue(), rd.getCompanyFaxNumber().getValue(), rd.getCompanyUrl().getValue(), rd.getPositionName().getValue(), rd.getNoteRaw() }; rowcount = rowcount + 1; addRow(sheet.createRow(rowcount), cell_enc_types, rows); } current_page++; if (current_page > page_num) { break; } listData.setCurrentPage(current_page); listData.doSelectList(this, rundata, context); } int uid = ALEipUtils.getUserId(rundata); ALEventlogFactoryService.getInstance().getEventlogHandler().logXlsScreen(uid, "", 163/* ALEventlogConstants.PORTLET_TYPE_ADDRESSBOOK_XLS_SCREEN */); }
From source file:com.aimluck.eip.modules.screens.AddressBookXlsExportScreen.java
License:Open Source License
private void setupAddressBookSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { AddressBookFilterdSelectData listData; listData = new AddressBookFilterdSelectData(); listData.initField();// www . j av a 2 s . co m listData.setRowsNum(1000); listData.doSelectList(this, rundata, context); String sheet_name = ""; // ? String[] headers = { "???", "???", "", "?", "??", "?", "??", "???" }; // 01 short[] cell_enc_types = { HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16 }; HSSFSheet sheet = createHSSFSheet(wb, sheet_name, headers, cell_enc_types); int rowcount = 0; // ? HSSFCellStyle style_col = wb.createCellStyle(); style_col.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style_col.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY); int listsize = listData.getCount(); AddressBookResultData rd; for (int j = 0; j < listsize; j++) { rd = (AddressBookResultData) listData.getList().get(j); String[] rows = { rd.getName().getValue(), rd.getNameKana().getValue(), rd.getEmail().getValue(), rd.getTelephone().getValue(), rd.getCellularPhone().getValue(), rd.getCellularMail().getValue(), rd.getCompanyName().getValue(), rd.getPositionName().getValue() }; rowcount = rowcount + 1; addRow(sheet.createRow(rowcount), cell_enc_types, rows); } int uid = ALEipUtils.getUserId(rundata); ALEventlogFactoryService.getInstance().getEventlogHandler().logXlsScreen(uid, "", 163/* ALEventlogConstants.PORTLET_TYPE_ADDRESSBOOK_XLS_SCREEN */); }
From source file:com.aimluck.eip.modules.screens.ExtTimecardNewXlsExportScreen.java
License:Open Source License
private void setupTimecardSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { ExtTimecardSelectData listData = new ExtTimecardSelectData(); listData.initField();// w w w . j a va 2 s . c om listData.setRowsNum(1000); listData.doViewList(this, rundata, context); String sheet_name = ""; // ? String[] headers = { "???", "", "", "", "", "", "", "", "", "??", "?", "", "", "?", "?", "?", "", "?", "", "", "", "", "???", "?", "", "", "", "", "", "", "", "", "", "", "" }; // 01 short[] cell_enc_types = { HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16 }; HSSFSheet sheet = createHSSFSheet(wb, sheet_name, headers, cell_enc_types); int rowcount = 0; // ? HSSFCellStyle style_col = wb.createCellStyle(); style_col.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style_col.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY); String user_name = ALEipUtils.getUserFullName(Integer.parseInt(listData.getTargetUserId()));// ??? String system_name = ExtTimecardUtils .getEipTExtTimecardSystemByUserId(Integer.parseInt(listData.getTargetUserId())).getSystemName(); ExtTimecardListResultDataContainer container = ExtTimecardUtils.groupByWeek(listData.getQueryStartDate(), listData.getAllList(), null); container.calculateWeekOvertime(); ExtTimecardListResultData tclistrd = null; List<ExtTimecardListResultData> daykeys = listData.getDateListKeys(); int daykeysize = daykeys.size(); for (int i = 0; i < daykeysize; i++) { tclistrd = daykeys.get(i); tclistrd.setWeekOvertime(container.getWeekOvertime(tclistrd)); tclistrd.setStatutoryHoliday(container.isStatutoryOffDay(tclistrd)); tclistrd.calculateWeekOvertime(); String date = "";// String day = ""; // String service_form = system_name; // String clock_in_time = "";// String clock_out_time = "";// String work_day = "0"; // 0 or 1 String work_hour = "0";// String overtime_day = "0";// String overtime_hour = "0";// String overtime_within_statutory_working_hour = "0";// String off_day = "0";// String off_hour = "0";// String late_coming_day = "0";// ? String early_leaving_day = "0";// String absent_day = "0";// String paid_holiday = "0";// String compensatory_holiday = "0";// String other_day = "0";// ??? String remark = "";// String reason = "";// ? String official_off_day = "0", statutory_off_day = "0"; String total_work_hour = "0"; String midnight_work_hour = "0", midnight_overtime_hour = "0"; String statutory_off_day_regular_work_hour = "0", statutory_off_day_overtime_hour = "0", statutory_off_day_midnight_work_hour = "0", statutory_off_day_regular_midnight_work_hour = "0", statutory_off_day_within_statutory_overtime_hour = "0"; String off_day_regular_work_hour = "0", off_day_overtime_hour = "0", off_day_midnight_work_hour = "0", off_day_regular_midnight_work_hour = "0", off_day_within_statutory_overtime_hour = "0"; String total_off_day_work_hour = "0", total_statutory_off_day_work_hour = "0"; String total_midnight_work_hour = "0"; String rest_hour = "0"; String[] out_going = new String[EipTExtTimecard.OUTGOING_COMEBACK_PER_DAY];// String[] come_back = new String[EipTExtTimecard.OUTGOING_COMEBACK_PER_DAY];// if (tclistrd.getRd() == null) { // ExtTimecardResultData rd = tclistrd.getRd(); date = tclistrd.getDateStr("yyyy/MM/dd"); day = tclistrd.getDateStr("EE"); } else { ExtTimecardResultData rd = tclistrd.getRd(); // ExtTimecardSummaryResultData srd = tclistrd.get date = tclistrd.getDateStr("yyyy/MM/dd"); day = tclistrd.getDateStr("EE"); String type = rd.getType().toString(); if (!rd.getIsNullClockInTime()) { clock_in_time = rd.getClockInTime("HH:mm"); clock_out_time = rd.getClockOutTime("HH:mm"); if (tclistrd.getWorkHour() != ExtTimecardListResultData.NO_DATA) { work_day = "1"; work_hour = Float.toString(tclistrd.getWorkHour()); } else { work_hour = "0"; } if (tclistrd.getOvertimeHourWithoutRestHour() > 0.0) { overtime_day = "1"; overtime_hour = Float.toString(tclistrd.getOvertimeHourWithoutRestHour()); } else { overtime_hour = "0"; } /** */ if (tclistrd.getWithinStatutoryOvertimeWorkHourWithoutOffday() > 0.0) { overtime_within_statutory_working_hour = Float .toString(tclistrd.getWithinStatutoryOvertimeWorkHourWithoutOffday()); } if (tclistrd.getOffHour() > 0.0) { off_day = "1"; // ??? if (container.isStatutoryOffDay(tclistrd)) { total_statutory_off_day_work_hour = Float.toString(tclistrd.getTotalWorkHour()); statutory_off_day = "1"; statutory_off_day_regular_work_hour = Float.toString(tclistrd.getInworkHour()); statutory_off_day_overtime_hour = Float.toString(tclistrd.getOvertimeHour()); statutory_off_day_midnight_work_hour = Float .toString(tclistrd.getMidnightOvertimeWorkHour()); statutory_off_day_regular_midnight_work_hour = Float .toString(tclistrd.getMidnightRegularWorkHour()); if (tclistrd .getWithinStatutoryOvertimeWorkHour() != ExtTimecardListResultData.NO_DATA) { statutory_off_day_within_statutory_overtime_hour = Float .toString(tclistrd.getWithinStatutoryOvertimeWorkHour()); } } else { total_off_day_work_hour = Float.toString(tclistrd.getTotalWorkHour()); official_off_day = "1"; off_day_regular_work_hour = Float.toString(tclistrd.getInworkHour()); off_day_overtime_hour = Float.toString(tclistrd.getOvertimeHour()); off_day_midnight_work_hour = Float.toString(tclistrd.getMidnightOvertimeWorkHour()); off_day_regular_midnight_work_hour = Float .toString(tclistrd.getMidnightRegularWorkHour()); if (tclistrd .getWithinStatutoryOvertimeWorkHour() != ExtTimecardListResultData.NO_DATA) { off_day_within_statutory_overtime_hour = Float .toString(tclistrd.getWithinStatutoryOvertimeWorkHour()); } } off_hour = Float.toString(tclistrd.getOffHour()); } else { off_hour = "0"; /** */ if (tclistrd.getMidnightRegularWorkHour() != ExtTimecardListResultData.NO_DATA) { midnight_work_hour = Float.toString(tclistrd.getMidnightRegularWorkHour()); } if (tclistrd.getMidnightOvertimeWorkHour() != ExtTimecardListResultData.NO_DATA) { midnight_overtime_hour = Float.toString(tclistrd.getMidnightOvertimeWorkHour()); } } } if (tclistrd.getMidnightWorkHour() > 0.0) { total_midnight_work_hour = Float.toString(tclistrd.getMidnightWorkHour()); } if (tclistrd.getTotalWorkHour() > 0.0) { total_work_hour = Float.toString(tclistrd.getTotalWorkHour()); } if (rd.getRefixFlag().getValue() == "1") { reason = rd.getReason().getValue(); } if (rd.getRemarksFlg()) { remark = rd.getRemarks().getValue(); } if (tclistrd.getRestHour() > 0.0) { rest_hour = Float.toString(tclistrd.getRestHour()); } late_coming_day = tclistrd.isLateComing() ? "1" : "0"; early_leaving_day = tclistrd.isEarlyLeaving() ? "1" : "0"; absent_day = type.equals(EipTExtTimecard.TYPE_ABSENT) ? "1" : "0"; paid_holiday = type.equals(EipTExtTimecard.TYPE_HOLIDAY) ? "1" : "0"; compensatory_holiday = type.equals(EipTExtTimecard.TYPE_COMPENSATORY) ? "1" : "0"; other_day = type.equals(EipTExtTimecard.TYPE_ETC) ? "1" : "0"; List<Map<String, String>> list = tclistrd.getOutgoingComeback_xls(); for (int j = 0; j < EipTExtTimecard.OUTGOING_COMEBACK_PER_DAY; j++) { Map<String, String> map = list.get(j); out_going[j] = map.get("outgoing"); come_back[j] = map.get("comeback"); } } String[] rows = { user_name, date, day, service_form, clock_in_time, clock_out_time, work_day, official_off_day, statutory_off_day, total_work_hour, work_hour, overtime_within_statutory_working_hour, overtime_hour, total_off_day_work_hour, total_statutory_off_day_work_hour, total_midnight_work_hour, rest_hour, late_coming_day, early_leaving_day, absent_day, paid_holiday, compensatory_holiday, other_day, reason, remark, out_going[0], come_back[0], out_going[1], come_back[1], out_going[2], come_back[2], out_going[3], come_back[3], out_going[4], come_back[4] }; rowcount = rowcount + 1; addRow(sheet.createRow(rowcount), cell_enc_types, rows); } /* * rowcount = rowcount + 1; String NOTHING = null; String work_day = * "=SUM(G2:G" + rowcount + ")"; String work_hour = "=SUM(H2:H" + rowcount + * ")"; String overtime_day = "=SUM(I2:I" + rowcount + ")"; String * overtime_hour = "=SUM(J2:J" + rowcount + ")"; String off_day = * "=SUM(K2:K" + rowcount + ")"; String off_hour = "=SUM(L2:L" + rowcount + * ")"; String late_coming_day = "=SUM(M2:M" + rowcount + ")"; String * early_leaving_day = "=SUM(N2:N" + rowcount + ")"; String absent_day = * "=SUM(O2:O" + rowcount + ")"; String paid_holiday = "=SUM(P2:P" + * rowcount + ")"; String compensatory_holiday = "=SUM(Q2:Q" + rowcount + * ")"; String other_day = "=SUM(R2:R" + rowcount + ")"; String[] rows = { * NOTHING, NOTHING, NOTHING, NOTHING, NOTHING, NOTHING, work_day, * work_hour, overtime_day, overtime_hour, off_day, off_hour, * late_coming_day, early_leaving_day, absent_day, paid_holiday, * compensatory_holiday, other_day, }; * * addFooter(sheet.createRow(rowcount), cell_enc_types, rows); */ // int uid = ALEipUtils.getUserId(rundata); ALEventlogFactoryService.getInstance().getEventlogHandler().logXlsScreen(uid, "", ALEventlogConstants.PORTLET_TYPE_EXTTIMECARD); }
From source file:com.aimluck.eip.modules.screens.ExtTimecardSummaryNewXlsExportScreen.java
License:Open Source License
private void setupTimecardSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { ExtTimecardSummaryListSelectData listData = new ExtTimecardSummaryListSelectData(); listData.init(this, rundata, context); listData.setRowsNum(1000);//ww w .ja va 2 s . c o m listData.doViewList(this, rundata, context); listData.setuserList(target_group_name); String sheet_name = ""; // ? String[] headers = { "???", "", "", "", "", "", "", "??", "?", "", "", "?", "?", "?", "", "?", "", "", "", "", "???", "" }; // 01 short[] cell_enc_types = { HSSFCell.ENCODING_UTF_16, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.ENCODING_UTF_16, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC }; HSSFSheet sheet = createHSSFSheet(wb, sheet_name, headers, cell_enc_types); int rowcount = 0; // ? HSSFCellStyle style_col = wb.createCellStyle(); style_col.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style_col.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY); ExtTimecardSummaryResultData tclistrd = null; List<ExtTimecardSummaryResultData> daykeys = listData.getGroupExtTimecards(); int daykeysize = daykeys.size(); for (int i = 0; i < daykeysize; i++) { tclistrd = daykeys.get(i); String user_name = tclistrd.getUserName();// ??? String year = view_month.substring(0, 4); // String month = view_month.substring(5); // String service_form = tclistrd.getSystemName();// // String total_work_day = tclistrd.getTotalWorkDay().getValueAsString(); // String official_off_day = tclistrd.getOfficialOffDay().getValueAsString(); // String statutory_off_day = tclistrd.getStatutoryOffDay().getValueAsString(); // ?? String total_work_hour = tclistrd.getTotalWorkHour().getValueAsString(); // ? String work_hour = tclistrd.getWorkHour().getValueAsString(); // String overtime_statutory_work_hour = tclistrd.getOvertimeWithinStatutoryWorkingHour() .getValueAsString(); // // String overtime_day = tclistrd.getOvertimeDay().getValueAsString(); String overtime_hour = tclistrd.getOvertimeHour().getValueAsString(); // ? String total_official_off_hour = tclistrd.getTotalOfficialOffHour().getValueAsString(); // ? String total_statutory_off_hour = tclistrd.getTotalStatutoryOffHour().getValueAsString(); // ? String midnight_work_hour = tclistrd.getTotalMidnightWorkHour().getValueAsString(); // String rest_hour = tclistrd.getRestHour().getValueAsString(); // String off_day = tclistrd.getOffDay().getValueAsString();// // String off_hour = tclistrd.getOffHour().getValueAsString();// // ? String late_coming_day = tclistrd.getLateComingDay().getValueAsString(); // String early_leaving_day = tclistrd.getEarlyLeavingDay().getValueAsString(); // String absent_day = tclistrd.getAbsentDay().getValueAsString(); // String paid_holiday = tclistrd.getPaidHoliday().getValueAsString(); // String compensatory_holiday = tclistrd.getCompensatoryHoliday().getValueAsString(); // ??? String other_day = tclistrd.getOtherDay().getValueAsString(); // String noinput = tclistrd.getNoInput().getValueAsString(); String[] rows = { user_name, year, month, service_form, total_work_day, official_off_day, statutory_off_day, total_work_hour, work_hour, overtime_statutory_work_hour, overtime_hour, total_official_off_hour, total_statutory_off_hour, midnight_work_hour, rest_hour, late_coming_day, early_leaving_day, absent_day, paid_holiday, compensatory_holiday, other_day, noinput }; rowcount = rowcount + 1; addRow(sheet.createRow(rowcount), cell_enc_types, rows); } // int uid = ALEipUtils.getUserId(rundata); ALEventlogFactoryService.getInstance().getEventlogHandler().logXlsScreen(uid, "", ALEventlogConstants.PORTLET_TYPE_EXTTIMECARD); }
From source file:com.aimluck.eip.modules.screens.ExtTimecardSummaryXlsExportScreen.java
License:Open Source License
private void setupTimecardSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { ExtTimecardSummaryListSelectData listData = new ExtTimecardSummaryListSelectData(); listData.init(this, rundata, context); listData.setRowsNum(1000);/* w w w . j ava2s . com*/ listData.doViewList(this, rundata, context); listData.setuserList(target_group_name); String sheet_name = ""; // ? String[] headers = { "???", "", "", "", "", "", "", "", "", "", "?", "", "", "", "", "???", "" }; // 01 short[] cell_enc_types = { HSSFCell.ENCODING_UTF_16, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.ENCODING_UTF_16, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC }; HSSFSheet sheet = createHSSFSheet(wb, sheet_name, headers, cell_enc_types); int rowcount = 0; // ? HSSFCellStyle style_col = wb.createCellStyle(); style_col.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style_col.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY); ExtTimecardSummaryResultData tclistrd = null; List<ExtTimecardSummaryResultData> daykeys = listData.getGroupExtTimecards(); int daykeysize = daykeys.size(); for (int i = 0; i < daykeysize; i++) { tclistrd = daykeys.get(i); String user_name = tclistrd.getUserName();// ??? String year = view_month.substring(0, 4); // String month = view_month.substring(5); // String service_form = tclistrd.getSystemName();// String work_day = tclistrd.getWorkDay().getValueAsString(); // String work_hour = tclistrd.getWorkHour().getValueAsString();// String overtime_day = tclistrd.getOvertimeDay().getValueAsString();// String overtime_hour = tclistrd.getOvertimeHour().getValueAsString();// String off_day = tclistrd.getOffDay().getValueAsString();// String off_hour = tclistrd.getOffHour().getValueAsString();// String late_coming_day = tclistrd.getLateComingDay().getValueAsString();// ? String early_leaving_day = tclistrd.getEarlyLeavingDay().getValueAsString();// String absent_day = tclistrd.getAbsentDay().getValueAsString();// String paid_holiday = tclistrd.getPaidHoliday().getValueAsString();// String compensatory_holiday = tclistrd.getCompensatoryHoliday().getValueAsString();// String other_day = tclistrd.getOtherDay().getValueAsString();// ??? String noinput = tclistrd.getNoInput().getValueAsString();// String[] rows = { user_name, year, month, service_form, work_day, work_hour, overtime_day, overtime_hour, off_day, off_hour, late_coming_day, early_leaving_day, absent_day, paid_holiday, compensatory_holiday, other_day, noinput }; rowcount = rowcount + 1; addRow(sheet.createRow(rowcount), cell_enc_types, rows); } // int uid = ALEipUtils.getUserId(rundata); ALEventlogFactoryService.getInstance().getEventlogHandler().logXlsScreen(uid, "", ALEventlogConstants.PORTLET_TYPE_EXTTIMECARD); }
From source file:com.aimluck.eip.modules.screens.ExtTimecardXlsExportScreen.java
License:Open Source License
private void setupTimecardSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { ExtTimecardSelectData listData = new ExtTimecardSelectData(); listData.initField();/*from ww w. j a va 2 s . com*/ listData.setRowsNum(1000); listData.doViewList(this, rundata, context); String sheet_name = ""; // ? String[] headers = { "???", "", "", "", "", "", "", "", "", "", "", "", "?", "", "", "", "", "???", "??", "", "", "", "", "", "", "", "", "", "" }; // 01 short[] cell_enc_types = { HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16 }; HSSFSheet sheet = createHSSFSheet(wb, sheet_name, headers, cell_enc_types); int rowcount = 0; // ? HSSFCellStyle style_col = wb.createCellStyle(); style_col.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style_col.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY); String user_name = ALEipUtils.getUserFullName(Integer.parseInt(listData.getTargetUserId()));// ??? String system_name = ExtTimecardUtils .getEipTExtTimecardSystemByUserId(Integer.parseInt(listData.getTargetUserId())).getSystemName(); ExtTimecardListResultData tclistrd = null; List<ExtTimecardListResultData> daykeys = listData.getDateListKeys(); int daykeysize = daykeys.size(); for (int i = 0; i < daykeysize; i++) { tclistrd = daykeys.get(i); String date = "";// String day = ""; // String service_form = system_name; // String clock_in_time = "";// String clock_out_time = "";// String work_day = "0"; // 0 or 1 String work_hour = "0";// String overtime_day = "0";// String overtime_hour = "0";// String off_day = "0";// String off_hour = "0";// String late_coming_day = "0";// ? String early_leaving_day = "0";// String absent_day = "0";// String paid_holiday = "0";// String compensatory_holiday = "0";// String other_day = "0";// ??? String remark = "";// ?? String[] out_going = new String[EipTExtTimecard.OUTGOING_COMEBACK_PER_DAY];// String[] come_back = new String[EipTExtTimecard.OUTGOING_COMEBACK_PER_DAY];// if (tclistrd.getRd() == null) { // ExtTimecardResultData rd = tclistrd.getRd(); date = tclistrd.getDateStr("yyyy/MM/dd"); day = tclistrd.getDateStr("EE"); } else { ExtTimecardResultData rd = tclistrd.getRd(); // ExtTimecardSummaryResultData srd = tclistrd.get date = tclistrd.getDateStr("yyyy/MM/dd"); day = tclistrd.getDateStr("EE"); String type = rd.getType().toString(); if (!rd.getIsNullClockInTime()) { clock_in_time = rd.getClockInTime("HH:mm"); clock_out_time = rd.getClockOutTime("HH:mm"); if (tclistrd.getWorkHour() > 0.0) { work_day = "1"; work_hour = Float.toString(tclistrd.getWorkHour()); } else { work_hour = "0"; } if (tclistrd.getOvertimeHourWithoutRestHour() > 0.0) { overtime_day = "1"; overtime_hour = Float.toString(tclistrd.getOvertimeHourWithoutRestHour()); } else { overtime_hour = "0"; } if (tclistrd.getOffHour() > 0.0) { off_day = "1"; off_hour = Float.toString(tclistrd.getOffHour()); } else { off_hour = "0"; } } if (rd.getRefixFlag().getValue() == "1") { remark = rd.getReason().getValue(); if (rd.getReasonFlg() && rd.getRemarksFlg()) { remark += "?"; } } if (rd.getRemarksFlg()) { remark += rd.getRemarks().getValue(); } late_coming_day = tclistrd.isLateComing() ? "1" : "0"; early_leaving_day = tclistrd.isEarlyLeaving() ? "1" : "0"; absent_day = type.equals(EipTExtTimecard.TYPE_ABSENT) ? "1" : "0"; paid_holiday = type.equals(EipTExtTimecard.TYPE_HOLIDAY) ? "1" : "0"; compensatory_holiday = type.equals(EipTExtTimecard.TYPE_COMPENSATORY) ? "1" : "0"; other_day = type.equals(EipTExtTimecard.TYPE_ETC) ? "1" : "0"; List<Map<String, String>> list = tclistrd.getOutgoingComeback_xls(); for (int j = 0; j < EipTExtTimecard.OUTGOING_COMEBACK_PER_DAY; j++) { Map<String, String> map = list.get(j); out_going[j] = map.get("outgoing"); come_back[j] = map.get("comeback"); } } String[] rows = { user_name, date, day, service_form, clock_in_time, clock_out_time, work_day, work_hour, overtime_day, overtime_hour, off_day, off_hour, late_coming_day, early_leaving_day, absent_day, paid_holiday, compensatory_holiday, other_day, remark, out_going[0], come_back[0], out_going[1], come_back[1], out_going[2], come_back[2], out_going[3], come_back[3], out_going[4], come_back[4] }; rowcount = rowcount + 1; addRow(sheet.createRow(rowcount), cell_enc_types, rows); } /* * rowcount = rowcount + 1; String NOTHING = null; String work_day = * "=SUM(G2:G" + rowcount + ")"; String work_hour = "=SUM(H2:H" + rowcount + * ")"; String overtime_day = "=SUM(I2:I" + rowcount + ")"; String * overtime_hour = "=SUM(J2:J" + rowcount + ")"; String off_day = * "=SUM(K2:K" + rowcount + ")"; String off_hour = "=SUM(L2:L" + rowcount + * ")"; String late_coming_day = "=SUM(M2:M" + rowcount + ")"; String * early_leaving_day = "=SUM(N2:N" + rowcount + ")"; String absent_day = * "=SUM(O2:O" + rowcount + ")"; String paid_holiday = "=SUM(P2:P" + * rowcount + ")"; String compensatory_holiday = "=SUM(Q2:Q" + rowcount + * ")"; String other_day = "=SUM(R2:R" + rowcount + ")"; String[] rows = { * NOTHING, NOTHING, NOTHING, NOTHING, NOTHING, NOTHING, work_day, * work_hour, overtime_day, overtime_hour, off_day, off_hour, * late_coming_day, early_leaving_day, absent_day, paid_holiday, * compensatory_holiday, other_day, }; * * addFooter(sheet.createRow(rowcount), cell_enc_types, rows); */ // int uid = ALEipUtils.getUserId(rundata); ALEventlogFactoryService.getInstance().getEventlogHandler().logXlsScreen(uid, "", ALEventlogConstants.PORTLET_TYPE_EXTTIMECARD); }
From source file:com.aimluck.eip.modules.screens.TimecardXlsExportScreen.java
License:Open Source License
private void setupTimecardSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { TimecardSelectData listData = new TimecardSelectData(); listData.initField();/*from w w w . j a v a 2 s. c om*/ listData.setRowsNum(1000); listData.doViewList(this, rundata, context); String sheet_name = ""; // ? String[] headers = { "", "?", "", "", "?" }; // 01 short[] cell_enc_types = { HSSFCell.ENCODING_UTF_16, HSSFCell.CELL_TYPE_NUMERIC, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16, HSSFCell.ENCODING_UTF_16 }; HSSFSheet sheet = createHSSFSheet(wb, sheet_name, headers, cell_enc_types); int rowcount = 0; // ? HSSFCellStyle style_col = wb.createCellStyle(); style_col.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); style_col.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY); TimecardListResultData tclistrd = null; List<String> daykeys = listData.getDateListKeys(); int daykeysize = daykeys.size(); for (int i = 0; i < daykeysize; i++) { tclistrd = listData.getDateListValue(daykeys.get(i)); List<TimecardResultData> viewlist = tclistrd.getViewList(); int viewlistsize = viewlist.size(); for (int j = 0; j < viewlistsize; j++) { TimecardResultData rd = viewlist.get(j); String workStr = null; if ("0".equals(rd.getWorkFlag().toString())) { workStr = ""; } else { workStr = ""; } String[] rows = { tclistrd.getDateStr(), tclistrd.getSummayTimes(), workStr, rd.getWorkDateStr(), rd.getReason().toString() }; rowcount = rowcount + 1; addRow(sheet.createRow(rowcount), cell_enc_types, rows); } sheet.addMergedRegion(new Region(rowcount - viewlistsize + 1, (short) 0, rowcount, (short) 0)); HSSFRow row = sheet.getRow(rowcount - viewlistsize + 1); HSSFCell cell1 = row.getCell((short) 0); cell1.setCellStyle(style_col); sheet.addMergedRegion(new Region(rowcount - viewlistsize + 1, (short) 1, rowcount, (short) 1)); HSSFCell cell2 = row.getCell((short) 1); cell2.setCellStyle(style_col); } int uid = ALEipUtils.getUserId(rundata); ALEventlogFactoryService.getInstance().getEventlogHandler().logXlsScreen(uid, "", ALEventlogConstants.PORTLET_TYPE_TIMECARD_XLS_SCREEN); }