GtiitPersonOsfService.java 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186
  1. package com.kingdee.shr.customer.gtiit.osf;
  2. import java.sql.SQLException;
  3. import java.text.SimpleDateFormat;
  4. import java.util.ArrayList;
  5. import java.util.HashMap;
  6. import java.util.List;
  7. import java.util.Map;
  8. import org.slf4j.Logger;
  9. import org.slf4j.LoggerFactory;
  10. import com.kingdee.bos.BOSException;
  11. import com.kingdee.bos.Context;
  12. import com.kingdee.bos.bsf.service.app.IHRMsfService;
  13. import com.kingdee.bos.dao.ormapping.ObjectUuidPK;
  14. import com.kingdee.eas.base.permission.PermItemFactory;
  15. import com.kingdee.eas.base.permission.PermItemInfo;
  16. import com.kingdee.eas.base.permission.UserFactory;
  17. import com.kingdee.eas.base.permission.UserInfo;
  18. import com.kingdee.eas.common.EASBizException;
  19. import com.kingdee.eas.hr.emp.EmployeeInterfacePermBizException;
  20. import com.kingdee.eas.util.app.ContextUtil;
  21. import com.kingdee.eas.util.app.DbUtil;
  22. import com.kingdee.jdbc.rowset.IRowSet;
  23. import com.kingdee.shr.base.permission.api.service.SHRFunctionPermissionService;
  24. import com.kingdee.shr.integration.oa.util.IntegrateOAUtil;
  25. import com.kingdee.shr.integration.oa.util.MappingFieldInfo;
  26. public class GtiitPersonOsfService implements IHRMsfService{
  27. private static final Logger logger = LoggerFactory.getLogger(GtiitPersonOsfService.class);
  28. public Object process(Context ctx, Map map) throws EASBizException, BOSException {
  29. logger.error("GtiitOAGetAdminOrgDataService enter ");
  30. new ArrayList();
  31. // InteOAGetPositionDataService
  32. // SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  33. // 开始日期
  34. String startDate = (String) map.get("startDate");
  35. // 截止日期
  36. String endDate = (String) map.get("endDate");
  37. String sql1="select";
  38. List<MappingFieldInfo> fieldList = this.initMappingField();
  39. StringBuffer sql = IntegrateOAUtil.getSelectFieldSql(fieldList);
  40. sql.append(" from t_org_admin org left join t_org_admin parent on parent.fid=org.FParentID");
  41. sql.append(" where org.FIsStartSHR=1");
  42. sql.append(" order by org.flongNumber,org.FIndex asc");
  43. IRowSet rs = DbUtil.executeQuery(ctx, sql.toString());
  44. List<HashMap<String, String>> dataList = IntegrateOAUtil.getRsListData(fieldList, rs);
  45. //部门负责人处理
  46. // try {
  47. // //processHead(ctx,dataList);
  48. // } catch (SQLException e) {
  49. // // TODO 自动生成的 catch 块
  50. // logger.info("processHead...."+e);
  51. // }
  52. return dataList;
  53. }
  54. private List<MappingFieldInfo> initMappingField() {
  55. List<MappingFieldInfo> list = new ArrayList();
  56. MappingFieldInfo fieldInfo = new MappingFieldInfo();
  57. fieldInfo.setOaField("PERSON_NUMBER");
  58. fieldInfo.setShrField("PERSON_NUMBER");
  59. list.add(fieldInfo);
  60. fieldInfo = new MappingFieldInfo();
  61. fieldInfo.setOaField("LAST_NAME");
  62. fieldInfo.setShrField("LAST_NAME");
  63. list.add(fieldInfo);
  64. fieldInfo = new MappingFieldInfo();
  65. fieldInfo.setOaField("MIDDLE_NAMES");
  66. fieldInfo.setShrField("MIDDLE_NAMES");
  67. list.add(fieldInfo);
  68. fieldInfo = new MappingFieldInfo();
  69. fieldInfo.setOaField("FIRST_NAME");
  70. fieldInfo.setShrField("FIRST_NAME");
  71. list.add(fieldInfo);
  72. fieldInfo = new MappingFieldInfo();
  73. fieldInfo.setOaField("LOCAL_NAME");
  74. fieldInfo.setShrField("LOCAL_NAME");
  75. list.add(fieldInfo);
  76. fieldInfo = new MappingFieldInfo();
  77. fieldInfo.setOaField("DISPLAY_NAME");
  78. fieldInfo.setShrField("DISPLAY_NAME");
  79. list.add(fieldInfo);
  80. fieldInfo = new MappingFieldInfo();
  81. fieldInfo.setOaField("USER_PERSON_TYPE");
  82. fieldInfo.setShrField("USER_PERSON_TYPE");
  83. list.add(fieldInfo);
  84. fieldInfo = new MappingFieldInfo();
  85. fieldInfo.setOaField("FULL_PART_TIME");
  86. fieldInfo.setShrField("FULL_PART_TIME");
  87. list.add(fieldInfo);
  88. fieldInfo = new MappingFieldInfo();
  89. fieldInfo.setOaField("HIRE_DATE");
  90. fieldInfo.setShrField("HIRE_DATE");
  91. list.add(fieldInfo);
  92. fieldInfo = new MappingFieldInfo();
  93. fieldInfo.setOaField("PROBATION_PERIOD");
  94. fieldInfo.setShrField("PROBATION_PERIOD");
  95. list.add(fieldInfo);
  96. fieldInfo = new MappingFieldInfo();
  97. fieldInfo.setOaField("PROBATION_UNIT");
  98. fieldInfo.setShrField("PROBATION_UNIT");
  99. list.add(fieldInfo);
  100. fieldInfo = new MappingFieldInfo();
  101. fieldInfo.setOaField("DATE_PROBATION_END");
  102. fieldInfo.setShrField("DATE_PROBATION_END");
  103. list.add(fieldInfo);
  104. fieldInfo = new MappingFieldInfo();
  105. fieldInfo.setOaField("WORK_PHONE");
  106. fieldInfo.setShrField("WORK_PHONE");
  107. list.add(fieldInfo);
  108. fieldInfo = new MappingFieldInfo();
  109. fieldInfo.setOaField("CELL_PHONE");
  110. fieldInfo.setShrField("CELL_PHONE");
  111. list.add(fieldInfo);
  112. fieldInfo = new MappingFieldInfo();
  113. fieldInfo.setOaField("EMAIL_ADDRESS");
  114. fieldInfo.setShrField("EMAIL_ADDRESS");
  115. list.add(fieldInfo);
  116. fieldInfo = new MappingFieldInfo();
  117. fieldInfo.setOaField("S_EMAIL_ADDRESS");
  118. fieldInfo.setShrField("S_EMAIL_ADDRESS");
  119. list.add(fieldInfo);
  120. fieldInfo = new MappingFieldInfo();
  121. fieldInfo.setOaField("CITIZENSHIP");
  122. fieldInfo.setShrField("CITIZENSHIP");
  123. list.add(fieldInfo);
  124. fieldInfo = new MappingFieldInfo();
  125. fieldInfo.setOaField("GENDER");
  126. fieldInfo.setShrField("GENDER");
  127. list.add(fieldInfo);
  128. fieldInfo = new MappingFieldInfo();
  129. fieldInfo.setOaField("DATE_OF_BIRTH");
  130. fieldInfo.setShrField("DATE_OF_BIRTH");
  131. list.add(fieldInfo);
  132. fieldInfo = new MappingFieldInfo();
  133. fieldInfo.setOaField("ETHNICITY");
  134. fieldInfo.setShrField("ETHNICITY");
  135. list.add(fieldInfo);
  136. fieldInfo = new MappingFieldInfo();
  137. fieldInfo.setOaField("HUKOU_TYPE");
  138. fieldInfo.setShrField("HUKOU_TYPE");
  139. list.add(fieldInfo);
  140. fieldInfo = new MappingFieldInfo();
  141. fieldInfo.setOaField("POLITICAL_STATUS");
  142. fieldInfo.setShrField("POLITICAL_STATUS");
  143. list.add(fieldInfo);
  144. fieldInfo = new MappingFieldInfo();
  145. fieldInfo.setOaField("TER_DATE");
  146. fieldInfo.setShrField("TER_DATE");
  147. list.add(fieldInfo);
  148. fieldInfo = new MappingFieldInfo();
  149. fieldInfo.setOaField("REASON");
  150. fieldInfo.setShrField("REASON");
  151. list.add(fieldInfo);
  152. fieldInfo = new MappingFieldInfo();
  153. fieldInfo.setOaField("PROFESSIONAL_TITLE");
  154. fieldInfo.setShrField("PROFESSIONAL_TITLE");
  155. list.add(fieldInfo);
  156. fieldInfo = new MappingFieldInfo();
  157. fieldInfo.setOaField("PROFESSIONAL_TITLE");
  158. fieldInfo.setShrField("PROFESSIONAL_TITLE");
  159. list.add(fieldInfo);
  160. fieldInfo = new MappingFieldInfo();
  161. fieldInfo.setOaField("PROFESSIONAL_TITLE");
  162. fieldInfo.setShrField("PROFESSIONAL_TITLE");
  163. list.add(fieldInfo);
  164. fieldInfo = new MappingFieldInfo();
  165. fieldInfo.setOaField("PROFESSIONAL_TITLE");
  166. fieldInfo.setShrField("PROFESSIONAL_TITLE");
  167. list.add(fieldInfo);
  168. fieldInfo = new MappingFieldInfo();
  169. fieldInfo.setOaField("PROFESSIONAL_TITLE");
  170. fieldInfo.setShrField("PROFESSIONAL_TITLE");
  171. list.add(fieldInfo);
  172. return list;
  173. }
  174. }