TimepieceSchemeBillEditHandlerEx.java 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380
  1. package com.kingdee.shr.compensation.web.handler.timepiece.bill;
  2. import com.kingdee.bos.BOSException;
  3. import com.kingdee.bos.Context;
  4. import com.kingdee.bos.metadata.entity.EntityViewInfo;
  5. import com.kingdee.bos.metadata.entity.FilterInfo;
  6. import com.kingdee.bos.metadata.entity.FilterItemInfo;
  7. import com.kingdee.bos.metadata.entity.SelectorItemCollection;
  8. import com.kingdee.bos.metadata.entity.SelectorItemInfo;
  9. import com.kingdee.bos.metadata.query.util.CompareType;
  10. import com.kingdee.eas.framework.CoreBaseInfo;
  11. import com.kingdee.eas.util.ToolUtils;
  12. import com.kingdee.shr.base.syssetting.context.SHRContext;
  13. import com.kingdee.shr.base.syssetting.exception.SHRWebException;
  14. import com.kingdee.shr.compensation.app.integrate.*;
  15. import com.kingdee.shr.compensation.app.utils.DateRange;
  16. import com.kingdee.shr.compensation.app.utils.SubmitShemeUtils;
  17. import com.kingdee.shr.compensation.exception.ExceptionHandle;
  18. import com.kingdee.shr.base.syssetting.web.json.JSONUtils;
  19. import java.text.SimpleDateFormat;
  20. import java.util.ArrayList;
  21. import java.util.Date;
  22. import java.util.HashMap;
  23. import java.util.HashSet;
  24. import java.util.List;
  25. import java.util.Map;
  26. import java.util.Set;
  27. import javax.servlet.http.HttpServletRequest;
  28. import javax.servlet.http.HttpServletResponse;
  29. import org.apache.commons.lang3.ObjectUtils;
  30. import org.apache.commons.lang3.StringUtils;
  31. import org.slf4j.Logger;
  32. import org.slf4j.LoggerFactory;
  33. import org.springframework.ui.ModelMap;
  34. /**
  35. * 提报单拓展
  36. * @author coyle
  37. * 20250520
  38. */
  39. public class TimepieceSchemeBillEditHandlerEx extends TimepieceSchemeBillEditHandler {
  40. private static Logger logger = LoggerFactory.getLogger(TimepieceSchemeBillEditHandlerEx.class);
  41. private static SimpleDateFormat SDF = new SimpleDateFormat("yyyy-MM-dd");
  42. //完成率
  43. // private static String COMRATE = "MQ005";
  44. // //岗位类型
  45. // private static String JOBTYPE = "MQ004";
  46. // //技能等级 SKILLLEVEL
  47. // private static String SKILLLEVEL = "MQ003";
  48. // //是否现场作业 On site
  49. // private static String ONSITE = "MQ007";
  50. // //班组任职 Team app
  51. // private static String TEAMAPP = "MQ007";
  52. // //工资序列 Salary seq
  53. // private static String SALARYSEQ = "MQ007";
  54. //
  55. // private static String[] ITEMNUMS = {COMRATE,JOBTYPE,SKILLLEVEL,ONSITE,TEAMAPP,SALARYSEQ};
  56. //
  57. // private static Map<String,String> FEILDS = new HashMap();
  58. // public TimepieceSchemeBillEditHandlerEx() throws BOSException {
  59. // Context ctx = SHRContext.getInstance().getContext();
  60. // CalSubmitItemCollection subColl = CalSubmitItemFactory.getLocalInstance(ctx)
  61. // .getCalSubmitItemCollection("SELECT ID,FieldSn,number where number in (" + ToolUtils.aryToStr(ITEMNUMS) + ")");
  62. // if (subColl != null && subColl.size() > 0) {
  63. // for (int i =0 ;i<subColl.size();i++) {
  64. // CalSubmitItemInfo itemInfo = subColl.get(i);
  65. // if (itemInfo != null) {
  66. // String columnName = "S" + itemInfo.getFieldSn();
  67. // FEILDS.put(itemInfo.getNumber() , columnName);
  68. // }
  69. // }
  70. // }
  71. // }
  72. protected void beforeSave(HttpServletRequest request, HttpServletResponse response, CoreBaseInfo model)
  73. throws SHRWebException {
  74. super.beforeSave(request, response, model);
  75. Context ctx = SHRContext.getInstance().getContext();
  76. BatchSubmitShemeBillInfo info = (BatchSubmitShemeBillInfo) model;
  77. BatchSubmitShemeBillEntryCollection entry = info.getEntry();
  78. String billId = "";
  79. if(ObjectUtils.allNotNull(info.getId())) {
  80. billId = info.getId().toString();
  81. }
  82. //拉取mes点检率数据
  83. try {
  84. exeDataOnDay( request,billId,entry);
  85. } catch (BOSException e) {
  86. e.printStackTrace();
  87. }
  88. //先重置点检率标识
  89. SubmitShemeUtils.reductionInspectionRate( ctx, info);
  90. //更新点检率数据
  91. Set<String> checkbillIds = (Set<String> ) request.getAttribute("checkbillIds");
  92. SubmitShemeUtils.updateInspectionRate(ctx, info,checkbillIds);
  93. }
  94. /**
  95. * 数据处理
  96. * 校验对应的某一天已存在数据/mes数据获取等
  97. * @param billId
  98. * @param entrys
  99. * @throws SHRWebException
  100. * @throws BOSException
  101. */
  102. public void exeDataOnDay(HttpServletRequest request,String billId,BatchSubmitShemeBillEntryCollection entrys) throws SHRWebException, BOSException {
  103. Context ctx = SHRContext.getInstance().getContext();
  104. Map<String, Set<String>> personDateMap = new HashMap<>();
  105. //
  106. HashSet<String> selectPerson = new HashSet();
  107. HashSet<String> selectDate = new HashSet();
  108. for (int i = 0; i < entrys.size(); i++) {
  109. BatchSubmitShemeBillEntryInfo entry = entrys.get(i);
  110. String personId = entry.getPerson().getId().toString();
  111. selectPerson.add(personId);
  112. Date effectDate = entry.getEffectDate();
  113. // 增加对 effectDate 为 null 的检查
  114. if (effectDate == null) {
  115. throw new IllegalArgumentException("分录中发生日期不能为空,请检查");
  116. }
  117. String formattedEffectDate = SDF.format(effectDate);
  118. selectDate.add(formattedEffectDate);
  119. // 使用 computeIfAbsent 减少冗余代码,并增加重复检查
  120. personDateMap.computeIfAbsent(personId, k -> new HashSet<>());
  121. if (!personDateMap.get(personId).add(formattedEffectDate)) {
  122. // 如果 add 方法返回 false,说明该日期已经存在,抛出异常
  123. throw new IllegalArgumentException("分录中" + entry.getPerson().getName() + ",有当日重复提报的数据,请检查");
  124. }
  125. }
  126. if (personDateMap.isEmpty()) {
  127. return;
  128. }
  129. // 找出最大日期与最小日期
  130. DateRange dateRange = SubmitShemeUtils.findMinMaxDate(selectDate);
  131. //校验重复
  132. verifiOneData(ctx, billId, selectPerson, dateRange, personDateMap);
  133. //校验完后进行mes数据填充;
  134. //获取mes数据
  135. HashMap<String, HashMap> mesData = SubmitShemeUtils.getMesData( ctx, selectPerson, dateRange);
  136. SubmitShemeUtils.setMesData(ctx, request, entrys, mesData);
  137. }
  138. /**
  139. * 校验当天是否有重复数据
  140. * @param ctx
  141. * @param billId
  142. * @param selectPerson
  143. * @param dateRange
  144. * @param personDateMap
  145. * @throws SHRWebException
  146. */
  147. public void verifiOneData(Context ctx ,String billId,HashSet<String> selectPerson,DateRange dateRange,Map<String, Set<String>> personDateMap) throws SHRWebException {
  148. HashMap<String,String> dataMap = new HashMap();
  149. try {
  150. IBatchSubmitShemeBillEntry entryIns = BatchSubmitShemeBillEntryFactory.getLocalInstance(ctx);
  151. FilterInfo filter = new FilterInfo();
  152. filter.getFilterItems().add(new FilterItemInfo("person", selectPerson, CompareType.INCLUDE));
  153. filter.getFilterItems().add(new FilterItemInfo("bill.id", billId , CompareType.NOTEQUALS ));
  154. filter.getFilterItems().add(new FilterItemInfo("effectDate", dateRange.getMaxDate() , CompareType.LESS_EQUALS));
  155. filter.getFilterItems().add(new FilterItemInfo("effectDate", dateRange.getMinDate() , CompareType.GREATER_EQUALS ));
  156. EntityViewInfo viewInfo = new EntityViewInfo();
  157. SelectorItemCollection selector = viewInfo.getSelector();
  158. selector.add(new SelectorItemInfo("person.id"));
  159. selector.add(new SelectorItemInfo("person.name"));
  160. selector.add(new SelectorItemInfo("bill.number"));
  161. selector.add(new SelectorItemInfo("effectDate"));
  162. viewInfo.setFilter(filter);
  163. BatchSubmitShemeBillEntryCollection entryCol = entryIns.getBatchSubmitShemeBillEntryCollection(viewInfo);
  164. for(int i = 0;i<entryCol.size();i++) {
  165. BatchSubmitShemeBillEntryInfo entryInfo = entryCol.get(i);
  166. Date effectDate = entryInfo.getEffectDate();
  167. String personId = entryInfo.getPerson().getId().toString();
  168. Set<String> pAndDate = personDateMap.get(personId);
  169. if(pAndDate.contains(SDF.format(effectDate))) {
  170. String personName = entryInfo.getPerson().getName().toString();
  171. BatchSubmitShemeBillInfo billInfo = entryInfo.getBill();
  172. String billNo = billInfo.getNumber();
  173. dataMap.put(personName, billNo);
  174. }
  175. }
  176. } catch (BOSException e) {
  177. e.printStackTrace();
  178. }
  179. //如果dataMap不为空则循环dataMap的数据组成字符串并抛出异常,"存在哪些人,单据编码为:****"
  180. if(!dataMap.isEmpty()) {
  181. String errorMsg = "存在以下当日重复提报人员,姓名与单据编码为:";
  182. for(String personName : dataMap.keySet()) {
  183. String billNo = dataMap.get(personName);
  184. errorMsg += personName + ":" + billNo + " ";
  185. }
  186. throw new SHRWebException(errorMsg);
  187. }
  188. }
  189. /**
  190. * handler校验,先不启用
  191. * @param request
  192. * @param response
  193. * @param modelMap
  194. * @throws SHRWebException
  195. */
  196. public void hasDataOnDayAction(HttpServletRequest request, HttpServletResponse response, ModelMap modelMap)
  197. throws SHRWebException {
  198. Context ctx = SHRContext.getInstance().getContext();
  199. // 获取人员 //格式为[pseron1:2025-04-03,person2:2025-04-03],需要转为map
  200. String proposers = request.getParameter("proposers");
  201. if (proposers == null || proposers.isEmpty()) {
  202. return;
  203. }
  204. String[] personArr = proposers.split(",");
  205. HashSet<String> selectPerson = new HashSet();
  206. HashSet<String> selectData = new HashSet();
  207. Map<String, Set<String>> personDateMap = new HashMap<>();
  208. for (int i = 0; i< personArr.length;i++) {
  209. String personIds = personArr[i];
  210. String[] parts = personIds.split(":");
  211. if (parts.length == 2) {
  212. String personId = parts[0].trim();
  213. String date = parts[1].trim();
  214. selectPerson.add(personId);
  215. selectData.add(date);
  216. personDateMap.computeIfAbsent(personId, k -> new HashSet<>()).add(date);
  217. }
  218. }
  219. if (personDateMap.isEmpty()) {
  220. return;
  221. }
  222. HashMap<String,String> dataMap = new HashMap();
  223. // 找出最大日期与最小日期
  224. DateRange dateRange = SubmitShemeUtils.findMinMaxDate(selectData);
  225. IBatchSubmitShemeBillEntry entryIns;
  226. try {
  227. entryIns = BatchSubmitShemeBillEntryFactory.getLocalInstance(ctx);
  228. FilterInfo filter = new FilterInfo();
  229. filter.getFilterItems().add(new FilterItemInfo("proposer", selectPerson, CompareType.INCLUDE));
  230. filter.getFilterItems().add(new FilterItemInfo("effectDate", dateRange.getMaxDate() , CompareType.LESS_EQUALS));
  231. filter.getFilterItems().add(new FilterItemInfo("effectDate", dateRange.getMinDate() , CompareType.GREATER_EQUALS ));
  232. EntityViewInfo viewInfo = new EntityViewInfo();
  233. viewInfo.setFilter(filter);
  234. BatchSubmitShemeBillEntryCollection entryCol = entryIns.getBatchSubmitShemeBillEntryCollection(viewInfo);
  235. for(int i = 0;i<entryCol.size();i++) {
  236. BatchSubmitShemeBillEntryInfo entryInfo = entryCol.get(i);
  237. Date effectDate = entryInfo.getEffectDate();
  238. String personId = entryInfo.getPerson().getId().toString();
  239. Set<String> pAndDate = personDateMap.get(personId);
  240. if(pAndDate.contains(SDF.format(effectDate))) {
  241. String personName = entryInfo.getPerson().getName().toString();
  242. BatchSubmitShemeBillInfo billInfo = entryInfo.getBill();
  243. String billNo = billInfo.getNumber();
  244. dataMap.put(personName, billNo);
  245. }
  246. }
  247. } catch (BOSException e) {
  248. e.printStackTrace();
  249. }
  250. Map resultMap = new HashMap();
  251. JSONUtils.SUCCESS( resultMap );
  252. }
  253. protected void afterSave(HttpServletRequest request, HttpServletResponse response, CoreBaseInfo model)
  254. throws SHRWebException {
  255. super.afterSave(request, response, model);
  256. Context ctx = SHRContext.getInstance().getContext();
  257. BatchSubmitShemeBillInfo info = (BatchSubmitShemeBillInfo) model;
  258. BatchSubmitShemeBillEntryCollection entry = info.getEntry();
  259. }
  260. public String saveAction(HttpServletRequest request, HttpServletResponse response, ModelMap modelMap)
  261. throws SHRWebException {
  262. try {
  263. BatchSubmitShemeBillInfo model = (BatchSubmitShemeBillInfo) request.getAttribute("dynamic_model");
  264. this.doFieldPermFilterSave(request, model);
  265. this.doSave(request, response, model);
  266. this.afterSave(request, response, model);
  267. this.saveAttachment(request, response, model);
  268. Object responseData = this.generateResponseDataAfterSave(request, response, model);
  269. Map resultMap = new HashMap();
  270. resultMap.put("responseData", responseData);
  271. resultMap.put("assignedRowsCount", request.getAttribute("assignedRowsCount"));
  272. this.writeSuccessData(resultMap);
  273. } catch (Exception var6) {
  274. ExceptionHandle.handleException(var6);
  275. }
  276. return null;
  277. }
  278. /**
  279. * 获取点检率与标识字段的字段名称
  280. * @param request
  281. * @param response
  282. * @param modelMap
  283. */
  284. public String getFieldRemarkAction(HttpServletRequest request,
  285. HttpServletResponse response, ModelMap modelMap) throws SHRWebException {
  286. String fieldStr = request.getParameter("fieldArr");
  287. Context ctx = SHRContext.getInstance().getContext();
  288. if(fieldStr!= null &&!fieldStr.isEmpty()){
  289. String[] split = fieldStr.split(",");
  290. try {
  291. CalSubmitItemCollection subColl = CalSubmitItemFactory.getLocalInstance(ctx)
  292. .getCalSubmitItemCollection("SELECT ID,FieldSn,number where number in ("+ToolUtils.aryToStr(split)+")");
  293. for(int i = 0;i<subColl.size();i++){
  294. CalSubmitItemInfo calSubmitItemInfo = subColl.get(i);
  295. int fieldSn = calSubmitItemInfo.getFieldSn();
  296. String number = calSubmitItemInfo.getNumber();
  297. String field = "S"+fieldSn ;
  298. modelMap.put(number, field);
  299. }
  300. } catch (BOSException e) {
  301. throw new RuntimeException(e);
  302. }
  303. }
  304. JSONUtils.writeJson(response, modelMap);
  305. return null;
  306. }
  307. }