package com.kingdee.shr.customer.gtiit.osf; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import org.apache.commons.lang3.StringUtils; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import com.kingdee.bos.BOSException; import com.kingdee.bos.Context; import com.kingdee.bos.bsf.service.app.IHRMsfService; import com.kingdee.eas.common.EASBizException; import com.kingdee.eas.util.app.DbUtil; import com.kingdee.jdbc.rowset.IRowSet; import com.kingdee.shr.customer.gtiit.osf.util.DateUtils; import com.kingdee.shr.integration.oa.util.IntegrateOAUtil; import com.kingdee.shr.integration.oa.util.MappingFieldInfo; /** * 获取职务的接口 * @author zkwuh * */ public class GtiitLocalJobOsfService implements IHRMsfService{ private static final Logger logger = LoggerFactory.getLogger(GtiitLocalJobOsfService.class); public Object process(Context ctx, Map map) throws EASBizException, BOSException { logger.error("GtiitLocalJobOsfService enter "); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); // 开始时间 String startDate = (String) map.get("startDate"); // 结束时间 String endDate = (String) map.get("endDate"); if (StringUtils.isNotBlank(startDate) && StringUtils.isNotBlank(endDate)) { startDate=DateUtils.formatDate(startDate,true); endDate=DateUtils.formatDate(endDate,false); } logger.error("GtiitLocalJobOsfService接口入参开始时间" + startDate + ",结束时间" + endDate); List fieldList = this.initMappingField(); StringBuffer sql = new StringBuffer(); sql.append("SELECT\r\n" + " fid SHRID,\r\n" + " fnumber JOB_CODE,\r\n" + " fname_l1 JOB_NAME_EN,\r\n" + " fname_l2 JOB_NAME_CN,\r\n" + " cfapproval APPROVAL_AUTHORITY,\r\n" + " fcreatetime ERP_CREATION_DATE,\r\n" + " flastupdatetime ERP_LAST_UPDATE_DATE \r\n" + "FROM\r\n" + " T_HR_HRJob"); if(StringUtils.isNotBlank(startDate) && StringUtils.isNotBlank(endDate)) { sql.append(" where flastupdatetime >= '"+startDate+"' and flastupdatetime <= '"+endDate+"'"); } logger.info("GtiitLocalJobOsfService执行的SQL"+sql.toString()); IRowSet rs = DbUtil.executeQuery(ctx, sql.toString()); List> dataList = IntegrateOAUtil.getRsListData(fieldList, rs); return dataList; } private List initMappingField() { List list = new ArrayList(); MappingFieldInfo fieldInfo = new MappingFieldInfo(); fieldInfo.setOaField("SHRID"); fieldInfo.setShrField("SHRID"); list.add(fieldInfo); fieldInfo = new MappingFieldInfo(); fieldInfo.setOaField("JOB_CODE"); fieldInfo.setShrField("JOB_CODE"); list.add(fieldInfo); fieldInfo = new MappingFieldInfo(); fieldInfo.setOaField("JOB_NAME_EN"); fieldInfo.setShrField("JOB_NAME_EN"); list.add(fieldInfo); fieldInfo = new MappingFieldInfo(); fieldInfo.setOaField("JOB_NAME_CN"); fieldInfo.setShrField("JOB_NAME_CN"); list.add(fieldInfo); fieldInfo = new MappingFieldInfo(); fieldInfo.setOaField("APPROVAL_AUTHORITY"); fieldInfo.setShrField("APPROVAL_AUTHORITY"); list.add(fieldInfo); fieldInfo = new MappingFieldInfo(); fieldInfo.setOaField("ERP_CREATION_DATE"); fieldInfo.setShrField("ERP_CREATION_DATE"); list.add(fieldInfo); fieldInfo = new MappingFieldInfo(); fieldInfo.setOaField("ERP_LAST_UPDATE_DATE"); fieldInfo.setShrField("ERP_LAST_UPDATE_DATE"); list.add(fieldInfo); return list; } }