List of usage examples for org.apache.poi.hssf.usermodel HSSFCellStyle setVerticalAlignment
@Override public void setVerticalAlignment(VerticalAlignment align)
From source file:cn.mario256.blog.ExcelView.java
License:Open Source License
/** * ?Excel/*from www . j a va 2 s . c o m*/ * * @param model * ? * @param workbook * HSSFWorkbook * @param request * HttpServletRequest * @param response * HttpServletResponse */ public void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request, HttpServletResponse response) throws Exception { Assert.notEmpty(properties); HSSFSheet sheet; if (StringUtils.isNotEmpty(sheetName)) { sheet = workbook.createSheet(sheetName); } else { sheet = workbook.createSheet(); } int rowNumber = 0; if (titles != null && titles.length > 0) { HSSFRow header = sheet.createRow(rowNumber); header.setHeight((short) 400); for (int i = 0; i < properties.length; i++) { HSSFCell cell = header.createCell(i); HSSFCellStyle cellStyle = workbook.createCellStyle(); cellStyle.setFillForegroundColor(HSSFColor.LIGHT_CORNFLOWER_BLUE.index); cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); HSSFFont font = workbook.createFont(); font.setFontHeightInPoints((short) 11); font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); cellStyle.setFont(font); cell.setCellStyle(cellStyle); if (i == 0) { HSSFPatriarch patriarch = sheet.createDrawingPatriarch(); HSSFComment comment = patriarch .createComment(new HSSFClientAnchor(0, 0, 0, 0, (short) 1, 1, (short) 4, 4)); comment.setString(new HSSFRichTextString("P" + "o" + "w" + "e" + "r" + "e" + "d" + " " + "B" + "y" + " " + "S" + "H" + "O" + "P" + "+" + "+")); cell.setCellComment(comment); } if (titles.length > i && titles[i] != null) { cell.setCellValue(titles[i]); } else { cell.setCellValue(properties[i]); } if (widths != null && widths.length > i && widths[i] != null) { sheet.setColumnWidth(i, widths[i]); } else { sheet.autoSizeColumn(i); } } rowNumber++; } if (data != null) { for (Object item : data) { HSSFRow row = sheet.createRow(rowNumber); for (int i = 0; i < properties.length; i++) { HSSFCell cell = row.createCell(i); if (converters != null && converters.length > i && converters[i] != null) { Class<?> clazz = PropertyUtils.getPropertyType(item, properties[i]); ConvertUtils.register(converters[i], clazz); cell.setCellValue(BeanUtils.getProperty(item, properties[i])); ConvertUtils.deregister(clazz); if (clazz.equals(Date.class)) { DateConverter dateConverter = new DateConverter(); dateConverter.setPattern(DEFAULT_DATE_PATTERN); ConvertUtils.register(dateConverter, Date.class); } } else { cell.setCellValue(BeanUtils.getProperty(item, properties[i])); } if (rowNumber == 0 || rowNumber == 1) { if (widths != null && widths.length > i && widths[i] != null) { sheet.setColumnWidth(i, widths[i]); } else { sheet.autoSizeColumn(i); } } } rowNumber++; } } if (contents != null && contents.length > 0) { rowNumber++; for (String content : contents) { HSSFRow row = sheet.createRow(rowNumber); HSSFCell cell = row.createCell(0); HSSFCellStyle cellStyle = workbook.createCellStyle(); HSSFFont font = workbook.createFont(); font.setColor(HSSFColor.GREY_50_PERCENT.index); cellStyle.setFont(font); cell.setCellStyle(cellStyle); cell.setCellValue(content); rowNumber++; } } response.setContentType("application/force-download"); if (StringUtils.isNotEmpty(filename)) { response.setHeader("Content-disposition", "attachment; filename=" + URLEncoder.encode(filename, "UTF-8")); } else { response.setHeader("Content-disposition", "attachment"); } }
From source file:com.ah.ui.actions.admin.LicenseMgrAction.java
License:Open Source License
private void exportEntitleKeyInfo() { try {/*from w w w .j ava 2 s. 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 ww .j a v a 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 }; 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 = "()"; // ?//from w ww. j a v a 2 s . 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); 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 = ""; // ?//from w w w.j a v a2 s .c om 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();/*from ww w . ja va2s. c om*/ 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();//from w w w .j a va 2s.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);//from w w w .j a v a2 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);//from w w w .jav a2 s .co 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 }; 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();/*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.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); }