AEAI HR人力资源管理系统是数通畅联软件基于AEAI DP开发的开源Java Web系统

package com.agileai.hr.module.salary.service; import java.math.BigDecimal; import java.math.RoundingMode; import java.util.ArrayList; import java.util.Date; import java.util.HashMap; import java.util.Iterator; import java.util.List; import org.springframework.dao.DataAccessException; import com.agileai.common.KeyGenerator; import com.agileai.domain.DataParam; import com.agileai.domain.DataRow; import com.agileai.hotweb.bizmoduler.core.StandardServiceImpl; import com.agileai.hr.cxmodule.HrSalaryManage; import com.agileai.util.DateUtil; import com.agileai.util.ListUtil; import com.agileai.util.MapUtil; import com.agileai.util.StringUtil; public class HrSalaryManageImpl extends StandardServiceImpl implements HrSalaryManage { public HrSalaryManageImpl() { super(); } private HashMap<String,List<DataRow>> queryRecords(String indexFieldName,String statementId,DataParam param) throws DataAccessException { HashMap<String,List<DataRow>> result = new HashMap<String,List<DataRow>>(); List<DataRow> recordList = this.daoHelper.queryRecords(statementId, param); HashMap<String, DataRow> recordMap = this.daoHelper.queryRecords(indexFieldName, statementId, param); if (recordList != null && recordList.size() > 0){ int count = recordList.size(); Iterator<String> it = recordMap.keySet().iterator(); while (it.hasNext()) { String indexField = it.next(); List<DataRow> list = new ArrayList<DataRow>(); for (int i = 0; i < count; i++) { if (indexField.equals(String.valueOf(recordList.get(i).get(indexFieldName)))) { list.add(recordList.get(i)); } } result.put(indexField, list); } } return result; } @Override public DataRow retrieveValidDays(String year, String month) { DataParam param = new DataParam("year", year, "month", month); String statementId = sqlNameSpace + "." + "retrieveValidDays"; DataRow row = this.daoHelper.getRecord(statementId, param); return row; } @Override public DataRow getInductionAndCreateTime(String userId){ DataParam param = new DataParam("userId",userId); String statementId = sqlNameSpace + "." + "getUserAnnualLeaveDays"; DataRow row = this.daoHelper.getRecord(statementId, param); return row; } public void createValidDayRecord(DataParam param) { String statementId = sqlNameSpace + "." + "insertValidDaysRecord"; processDataType(param, tableName); processPrimaryKeys(param); this.daoHelper.insertRecord(statementId, param); } public void updateValidDayRecord(DataParam param) { String statementId = sqlNameSpace + "." + "updateValidDaysRecord"; processDataType(param, tableName); this.daoHelper.updateRecord(statementId, param); } @Override public void gatherData(String year, String month) { String statementId = ""; String yearMonth = year + "-" + month; String yearMonthDay = yearMonth + "-01"; Date date = DateUtil.getDate(yearMonthDay); String currentDate = yearMonth + "-31"; Date lastDateMonth = DateUtil.getDate(currentDate); String beginOfYearDate = DateUtil.format(DateUtil.YYMMDD_HORIZONTAL, DateUtil.getBeginOfYear(date)); String beforeMonthDateStr = DateUtil.format(DateUtil.YYMMDD_HORIZONTAL, DateUtil.getDateAdd(date, DateUtil.MONTH, -1)); String beforeYearDecemberStr = DateUtil.format(DateUtil.YYMMDD_HORIZONTAL, DateUtil.getDateAdd(DateUtil.getBeginOfYear(date), DateUtil.MONTH, -1)); String previousMonth = beforeMonthDateStr.substring(5,7); String beforeMonth = beforeMonthDateStr.substring(0,7); String beforeYear = beforeYearDecemberStr.substring(0,4); String beforeYearDecember = beforeYearDecemberStr.substring(5,7); DataRow validDaysRow = this.retrieveValidDays(year, month); DataRow beforeYearDecemberValidDaysRow = this.retrieveValidDays(beforeYear, beforeYearDecember); statementId = sqlNameSpace + "." + "workDayRecords"; HashMap<String,DataRow> workDayMap = this.daoHelper.queryRecords( "USER_ID", statementId, new DataParam("yearMonth",yearMonth)); HashMap<String,DataRow> probationWorkDayMap = this.daoHelper.queryRecords( "USER_ID", statementId, new DataParam("sdate",date)); HashMap<String,DataRow> regularWorkDayMap = this.daoHelper.queryRecords( "USER_ID", statementId, new DataParam("edate",currentDate)); statementId = sqlNameSpace + "." + "overTimeDayRecords"; HashMap<String,DataRow> totalOverTimeDaysMap = this.daoHelper.queryRecords( "USER_ID", statementId, new DataParam("yearMonth",yearMonth)); statementId = sqlNameSpace + "." + "leaveDayRecords"; HashMap<String,DataRow> totalLeaveDaysMap = this.daoHelper.queryRecords( "USER_ID", statementId, new DataParam("yearMonth",yearMonth)); HashMap<String,DataRow> currentYearLeaveDaysMap = this.daoHelper.queryRecords( "USER_ID", statementId, new DataParam("sdate",beginOfYearDate,"edate",currentDate)); statementId = sqlNameSpace + "." + "currentMonthLeaveDayRecords"; HashMap<String,List<DataRow>> currentMonthLeaveDayRecordsMap = queryRecords( "USER_ID", statementId, new DataParam("yearMonth",yearMonth)); HashMap<String,List<DataRow>> totalLeaveRecordsMap = queryRecords( "USER_ID",statementId, new DataParam("year",beforeYear)); statementId = sqlNameSpace + "." + "findOverTimeRecords"; HashMap<String,List<DataRow>> beforeMonthOverTimeRecordsMap = queryRecords( "USER_ID", statementId, new DataParam("yearMonth",beforeMonth)); HashMap<String,List<DataRow>> currentMonthOverTimeRecordsMap = queryRecords( "USER_ID", statementId, new DataParam("yearMonth",yearMonth)); HashMap<String,List<DataRow>> totalOverTimeRecordsMap = queryRecords( "USER_ID", statementId, new DataParam("year",beforeYear)); statementId = sqlNameSpace + "." + "findOffsetVacationDayRecords"; HashMap<String,DataRow> beforeYearDecemberOffsetVationDaysMap = this.daoHelper.queryRecords( "SAL_USER", statementId, new DataParam("year",beforeYear,"month",beforeYearDecember)); HashMap<String,DataRow> beforeMonthOffsetVationDaysMap = this.daoHelper.queryRecords( "SAL_USER", statementId, new DataParam("year",year,"month",previousMonth)); statementId = sqlNameSpace + "." + "findMasterDaysRecords"; List<DataRow> basicRecords = this.daoHelper.queryRecords(statementId, new DataParam("year",year,"month",month)); statementId = sqlNameSpace + "." + "findPunishmentRecords"; HashMap<String,DataRow> punishmentMap = this.daoHelper.queryRecords( "USER_ID",statementId, new DataParam("yearMonth",yearMonth)); statementId = sqlNameSpace + "." + "findRewardtRecords"; HashMap<String,DataRow> rewardMap = this.daoHelper.queryRecords( "USER_ID",statementId, new DataParam("yearMonth",yearMonth)); statementId = sqlNameSpace + "." + "findAdditionalVationRecords"; HashMap<String,DataRow> additionalVationMap = this.daoHelper.queryRecords( "USER_ID",statementId, new DataParam("yearMonth",yearMonth,"date",date)); statementId = sqlNameSpace+ "." + "findRecords"; HashMap<String,DataRow> salaryRecordMap = this.daoHelper.queryRecords( "SAL_USER", statementId, new DataParam("salYear",year,"salMonth",month)); HashMap<String,DataRow> beforeYearDecemberSalaryRecords = this.daoHelper.queryRecords( "SAL_USER",statementId,new DataParam("salYear",beforeYear,"salMonth",beforeYearDecember)); statementId = sqlNameSpace+ "." + "findBonusPenaltyRecords"; HashMap<String,DataRow> overRunDayRecordMap = this.daoHelper.queryRecords( "USER_ID", statementId, new DataParam("BP_DATE",date,"BP_TYPE","OVERRUN")); HashMap<String,DataRow> fullTimeRecordMap = this.daoHelper.queryRecords( "USER_ID", statementId, new DataParam("BP_DATE",date,"BP_TYPE","FULLTIMEAWARD")); HashMap<String,DataRow> additionalVationRecordMap = this.daoHelper.queryRecords( "USER_ID", statementId, new DataParam("BP_DATE",date,"BP_TYPE","ADDITIONALVATION")); statementId = sqlNameSpace+ "." + "