EvaresultAuditBillEditHandlerEx.java 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. package com.kingdee.eas.hr.perf.handler;
  2. import com.kingdee.bos.Context;
  3. import com.kingdee.bos.rabbitmq.guava.Lists;
  4. import com.kingdee.eas.framework.CoreBaseInfo;
  5. import com.kingdee.eas.util.app.DbUtil;
  6. import com.kingdee.jdbc.rowset.IRowSet;
  7. import com.kingdee.shr.base.syssetting.api.bean.BatchMessageTipsHeader;
  8. import com.kingdee.shr.base.syssetting.exception.SHRWebException;
  9. import com.kingdee.shr.perfweb.planexecute.handler.EvaresultAuditBillEditHandler;
  10. import org.apache.commons.lang3.StringUtils;
  11. import javax.servlet.http.HttpServletRequest;
  12. import javax.servlet.http.HttpServletResponse;
  13. import java.util.List;
  14. /**
  15. * @BelongsProject: dataImpExp820
  16. * @BelongsPackage: com.kingdee.eas.hr.perf.handler
  17. * @Author: lhbj
  18. * @CreateTime: 2025-01-10 19:09
  19. * @Description: TODO
  20. * @Version: 1.0
  21. */
  22. public class EvaresultAuditBillEditHandlerEx extends EvaresultAuditBillEditHandler {
  23. protected void verifyModel(HttpServletRequest request, HttpServletResponse response, CoreBaseInfo model) throws SHRWebException {
  24. }
  25. public String beforeAuditEvaResut(Context ctx, List<String> ids) throws SHRWebException {
  26. List<String> unIdLIst = Lists.newArrayList();
  27. StringBuilder err = new StringBuilder();
  28. try {
  29. StringBuffer sql = new StringBuffer();
  30. sql.append(" select ers.fid,ers.FPNAME,ers.FPNUMBER,pp.FPSTARTDATE,ers.CFOrgLevelEveID,pp.FYEAR,pp.FTIMEPERIOD from ");
  31. sql.append(" T_EVA_EvaResultSummary ers ");
  32. sql.append(" left join T_EVA_PerfPeriod pp on ers.FPERIODID=pp.fid ");
  33. sql.append(" where ers.fid in(''");
  34. for (String id : ids) {
  35. sql.append(",'").append(id).append("'");
  36. }
  37. sql.append(" ) ");
  38. IRowSet rsSql = DbUtil.executeQuery(ctx, sql.toString());
  39. while (rsSql.next()){
  40. String id = rsSql.getString("id");
  41. String FPNAME = rsSql.getString("FPNAME");
  42. String FPNUMBER = rsSql.getString("FPNUMBER");
  43. String orgLevelEveID = rsSql.getString("CFOrgLevelEveID");
  44. if(StringUtils.isBlank(orgLevelEveID)) {
  45. err.append("员工:"+FPNAME+"("+FPNUMBER+"),无法获取当前组织绩效考核等级");
  46. unIdLIst.add(id);
  47. }
  48. }
  49. if(!unIdLIst.isEmpty()) {
  50. ids.removeAll(unIdLIst);
  51. err.append("存在无法获取当前组织绩效考核等级的记录");
  52. }
  53. }catch (Exception e){
  54. e.printStackTrace();
  55. }
  56. return err.toString();
  57. }
  58. }