Java tutorial
/* * Aipo is a groupware program developed by TOWN, Inc. * Copyright (C) 2004-2015 TOWN, Inc. * http://www.aipo.com * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as * published by the Free Software Foundation, either version 3 of the * License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ package com.aimluck.eip.modules.screens; import java.util.List; import org.apache.jetspeed.services.logging.JetspeedLogFactoryService; import org.apache.jetspeed.services.logging.JetspeedLogger; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.turbine.util.RunData; import org.apache.velocity.context.Context; import com.aimluck.eip.common.ALDBErrorException; import com.aimluck.eip.common.ALPageNotFoundException; import com.aimluck.eip.exttimecard.ExtTimecardSummaryListSelectData; import com.aimluck.eip.exttimecard.ExtTimecardSummaryResultData; import com.aimluck.eip.exttimecard.util.ExtTimecardUtils; import com.aimluck.eip.services.accessctl.ALAccessControlConstants; import com.aimluck.eip.services.eventlog.ALEventlogConstants; import com.aimluck.eip.services.eventlog.ALEventlogFactoryService; import com.aimluck.eip.util.ALEipUtils; /** * ????? */ public class ExtTimecardSummaryNewXlsExportScreen extends ALXlsScreen { /** logger */ private static final JetspeedLogger logger = JetspeedLogFactoryService .getLogger(ExtTimecardSummaryNewXlsExportScreen.class.getName()); public static final String FILE_NAME = "timecard_monthly.xls"; /** ID */ private String userid; /** <code>target_group_name</code> ??? */ private String target_group_name; private String view_month; /** ???? */ private String aclPortletFeature = null; /** * ????? * * @param action * @param rundata * @param context */ @Override public void init(RunData rundata, Context context) throws ALPageNotFoundException, ALDBErrorException { String target_user_id = rundata.getParameters().getString(ExtTimecardUtils.TARGET_USER_ID); target_group_name = rundata.getParameters().getString(ExtTimecardUtils.TARGET_GROUP_NAME); view_month = rundata.getParameters().getString("view_month"); userid = Integer.toString(ALEipUtils.getUserId(rundata)); // if (target_user_id == null || "".equals(target_user_id) || userid.equals(target_user_id)) { aclPortletFeature = ALAccessControlConstants.POERTLET_FEATURE_TIMECARD_TIMECARD_SELF; } else { aclPortletFeature = ALAccessControlConstants.POERTLET_FEATURE_TIMECARD_TIMECARD_OTHER; } super.init(rundata, context); } @Override protected boolean createHSSFWorkbook(RunData rundata, Context context, HSSFWorkbook wb) { try { setupTimecardSheet(rundata, context, wb); } catch (Exception e) { logger.error("TimecardCsvExportScreen", e); return false; } return true; } private void setupTimecardSheet(RunData rundata, Context context, HSSFWorkbook wb) throws Exception { ExtTimecardSummaryListSelectData listData = new ExtTimecardSummaryListSelectData(); listData.init(this, rundata, context); listData.setRowsNum(1000); 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); } @Override protected String getFileName() { return FILE_NAME; } /** * ??<br /> * ??????? * * @return */ @Override public String getAclPortletFeature() { return aclPortletFeature; } }