PerfEvaObjectUtils.java 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410
  1. package com.kingdee.eas.hr.perf.utils;
  2. import com.kingdee.bos.BOSException;
  3. import com.kingdee.bos.Context;
  4. import com.kingdee.bos.dao.IObjectPK;
  5. import com.kingdee.bos.dao.ObjectNotFoundException;
  6. import com.kingdee.bos.dao.ormapping.ObjectUuidPK;
  7. import com.kingdee.bos.metadata.entity.*;
  8. import com.kingdee.bos.metadata.query.util.CompareType;
  9. import com.kingdee.eas.common.EASBizException;
  10. import com.kingdee.eas.framework.CoreBaseCollection;
  11. import com.kingdee.shr.base.syssetting.api.bean.BatchMessageTipsBody;
  12. import com.kingdee.shr.base.syssetting.exception.SHRWebException;
  13. import com.kingdee.shr.base.syssetting.exception.ShrWebBizException;
  14. import com.kingdee.shr.base.syssetting.util.LocaleUtils;
  15. import com.kingdee.shr.perfweb.app.base.evalfile.PerfFileCollection;
  16. import com.kingdee.shr.perfweb.app.base.evalfile.PerfFileFactory;
  17. import com.kingdee.shr.perfweb.app.base.evalfile.PerfFileInfo;
  18. import com.kingdee.shr.perfweb.app.base.evalplan.*;
  19. import com.kingdee.shr.perfweb.app.base.evalrule.PWorkFlowDefCollection;
  20. import com.kingdee.shr.perfweb.app.base.evalrule.PWorkFlowDefInfo;
  21. import com.kingdee.shr.perfweb.app.base.evalrule.PerformanceRuleInfo;
  22. import com.kingdee.shr.perfweb.app.exception.SHRPerfWebBizException;
  23. import com.kingdee.shr.perfweb.app.resource.SHRPerfWebResource;
  24. import com.kingdee.shr.perfweb.util.PerfEvaObjGroupUtils;
  25. import com.kingdee.shr.perfweb.util.PerfRuleSettingUtil;
  26. import com.kingdee.shr.perfweb.util.PersonInchargeUtils;
  27. import com.kingdee.shr.perfweb.util.SHRPerfWebResourceUtil;
  28. import com.kingdee.shr.perfweb.utils.PerfPlanUtils;
  29. import com.kingdee.shr.perfweb.utils.RuleHistoryUtils;
  30. import org.apache.log4j.Logger;
  31. import org.springframework.util.CollectionUtils;
  32. import java.util.*;
  33. /**
  34. * @author qingwu
  35. * @date 2024/12/25
  36. * @apiNote
  37. */
  38. public class PerfEvaObjectUtils {
  39. private static Logger logger =
  40. Logger.getLogger(PerfEvaObjectUtils.class);
  41. /**
  42. * @param ctx
  43. * @param perfFiles 员工档案人员
  44. * @param periodId 考核周期id
  45. * @param hrOrgUnit 默认:00000000-0000-0000-0000-000000000000CCE7AED4
  46. * @param perfPlan 考核计划ID
  47. * @throws SHRWebException
  48. */
  49. public IObjectPK[] addFromPerfFile(Context ctx, String perfFiles, String periodId, String hrOrgUnit, PerfPlanInfo perfPlan) throws SHRWebException {
  50. logger.error("addFromPerfFile----");
  51. String billId = perfFiles;
  52. //String billId = "nJsYSsgcTvqTNTFmY+YCRFulBK0=";
  53. checkPeriod(periodId);
  54. String[] ids = null;
  55. ids = billId.split(",");
  56. Set<String> set = new HashSet();
  57. set.addAll(Arrays.asList(ids));
  58. EntityViewInfo viewInfo = new EntityViewInfo();
  59. FilterInfo filter = new FilterInfo();
  60. SelectorItemCollection sic = viewInfo.getSelector();
  61. sic.add(new SelectorItemInfo("*"));
  62. sic.add(new SelectorItemInfo("position.id"));
  63. sic.add(new SelectorItemInfo("adminOrgUnit.id"));
  64. sic.add(new SelectorItemInfo("hrOrgUnit.id"));
  65. sic.add(new SelectorItemInfo("person.number"));
  66. sic.add(new SelectorItemInfo("person.name"));
  67. sic.add(new SelectorItemInfo("empPosOrgRelation.*"));
  68. filter.getFilterItems().add(new FilterItemInfo("id", set, CompareType.INCLUDE));
  69. viewInfo.setFilter(filter);
  70. PerfFileCollection coll = null;
  71. PerfGoalsGroupCollection groupColl = null;
  72. String groupId = "";
  73. PWorkFlowDefInfo defaultWorkFlow = null;
  74. try {
  75. coll = PerfFileFactory.getRemoteInstance().getPerfFileCollection(viewInfo);
  76. groupColl = PerfGoalsGroupFactory.getRemoteInstance().getPerfGoalsGroupCollection("where period = '" + periodId + "' and useDefault = 1");
  77. if (groupColl != null && groupColl.get(0) != null) {
  78. groupId = groupColl.get(0).getId().toString();
  79. }
  80. PerfPeriodInfo perfPeriodInfo = PerfPeriodFactory.getRemoteInstance().getPerfPeriodInfo("where id = '" + periodId + "'");
  81. PerformanceRuleInfo perfRule = perfPeriodInfo.getPerfRule();
  82. PWorkFlowDefCollection pWFDefColl = RuleHistoryUtils.getDefaultWorkFlow(ctx, perfRule.getId().toString());
  83. if (pWFDefColl != null && pWFDefColl.size() > 0) {
  84. defaultWorkFlow = pWFDefColl.get(0);
  85. } else if (perfPeriodInfo.getIsHistoryUpdate().getValue() == 1) {
  86. defaultWorkFlow = perfPlan.getDefaultWorkFlow();
  87. }
  88. } catch (BOSException var20) {
  89. var20.printStackTrace();
  90. logger.error(var20.toString());
  91. } catch (EASBizException var21) {
  92. var21.printStackTrace();
  93. logger.error(var21.toString());
  94. }
  95. logger.error("coll--" + coll.size());
  96. if (coll != null && defaultWorkFlow != null) {
  97. CoreBaseCollection croeBase = new CoreBaseCollection();
  98. for (int i = 0; i < coll.size(); ++i) {
  99. PerfEvaObjectInfo info = new PerfEvaObjectInfo();
  100. PerfFileInfo fileInfo = coll.get(i);
  101. info.put("number", fileInfo.getPerson().getNumber());
  102. info.setName(fileInfo.getPerson().getName());
  103. info.setName(fileInfo.getPerson().getName(LocaleUtils.locale_l1), LocaleUtils.locale_l1);
  104. info.setName(fileInfo.getPerson().getName(LocaleUtils.locale_l2), LocaleUtils.locale_l2);
  105. info.setName(fileInfo.getPerson().getName(LocaleUtils.locale_l3), LocaleUtils.locale_l3);
  106. info.put("period", periodId);
  107. info.setCanAdjustEvaluer(TargetEvaluModeEnum.getEnum(perfPlan.getCanAdjustEvaluer().getValue()));
  108. info.setHrUnitOrg(fileInfo.getHrOrgUnit());
  109. info.setPerfFile(fileInfo);
  110. info.setAdminOrgUnit(fileInfo.getAdminOrgUnit());
  111. info.put("person", fileInfo.getPerson());
  112. info.put("joinPeriodDate", new Date());
  113. info.put("joinPlanDate", new Date());
  114. info.put("changeDealType", 100);
  115. info.put("workFlow", defaultWorkFlow.getId().toString());
  116. info.put("unitGoalsStatus", "0");
  117. info.put("belongGroup", groupId);
  118. info.setScoreTaskStatus(ScoreTaskStatusEnum.UNSEND);
  119. info.setTargetMakeSure(perfPlan.isTargetMakeSure() ? 1 : 0);
  120. info.setPersonInChargeType(PersonInchargeUtils.setSuperior2PersonInChargeType(info.getPersonInChargeType()));
  121. info.setPersonInchargePosition((String) null);
  122. info.setPointPosition((String) null);
  123. info.put("personIncharge", new PerfEvaPersonInchargeCollection());
  124. croeBase.add(info);
  125. }
  126. return this.runBatchSaveEvaObject(ctx, periodId, hrOrgUnit, croeBase);
  127. } else {
  128. throw new SHRWebException((new SHRPerfWebBizException(SHRPerfWebBizException.GETERR)).getMessage());
  129. }
  130. }
  131. protected IObjectPK[] runBatchSaveEvaObject(Context ctx, String periodId, String hrOrgUnit, CoreBaseCollection croeBase) throws SHRWebException {
  132. logger.error("runBatchSaveEvaObject----");
  133. logger.error("croeBase----" + croeBase.size());
  134. int sucess = 0;
  135. int failure = 0;
  136. String billId = "";
  137. try {
  138. Set<String> sucessIds = new HashSet();
  139. Map<String, String> verifyMap = new HashMap();
  140. Map<String, String> evaPlanNameMap = this.getPerfPlanName(ctx, periodId, hrOrgUnit);
  141. CoreBaseCollection addCoreColl = new CoreBaseCollection();
  142. int count = croeBase.size();
  143. int j = 1;
  144. Set<String> personIds = new HashSet();
  145. int i;
  146. PerfEvaObjectInfo info;
  147. for (i = 0; i < count; ++i) {
  148. info = (PerfEvaObjectInfo) croeBase.get(i);
  149. personIds.add(info.getPerson().getId().toString());
  150. if (j != 500 && i != count - 1) {
  151. ++j;
  152. } else {
  153. Map<String, String> tempMap = this.getEvaObject(ctx, periodId, hrOrgUnit, personIds);
  154. if (!CollectionUtils.isEmpty(tempMap)) {
  155. verifyMap.putAll(tempMap);
  156. }
  157. j = 1;
  158. personIds = new HashSet();
  159. }
  160. }
  161. IObjectPK[] iObjectPKS = null;
  162. for (i = 0; i < croeBase.size(); ++i) {
  163. info = (PerfEvaObjectInfo) croeBase.get(i);
  164. BatchMessageTipsBody body = new BatchMessageTipsBody();
  165. try {
  166. String id = info.getPerfFile().getId().toString();
  167. billId = billId + id + ",";
  168. body.setId(id);
  169. if (sucessIds.contains(id)) {
  170. continue;
  171. }
  172. sucessIds.add(id);
  173. String key = info.getPerson().getNumber() + "_" + info.getPerson().getName() + "_" + info.getPerfFile().getPosition().getId().toString() + "_" + info.getPerfFile().getAssignType().getValue();
  174. //if (!org.apache.commons.lang.StringUtils.isEmpty((String) verifyMap.get(key))) {
  175. // logger.error("123----------------" + (new SHRPerfWebBizException(SHRPerfWebBizException.EVAOBJALREADYADDED, new Object[]{evaPlanNameMap.get(verifyMap.get(key))})).getMessage());
  176. // continue;
  177. // //throw new BOSException((new SHRPerfWebBizException(SHRPerfWebBizException.EVAOBJALREADYADDED, new Object[]{evaPlanNameMap.get(verifyMap.get(key))})).getMessage());
  178. //}
  179. IPerfEvaObject iPerfEvaObject = PerfEvaObjectFactory.getLocalInstance(ctx);
  180. logger.error("perfEvaObjectInfo.().getPeriod():" + info.get("period"));
  181. logger.error("perfEvaObjectInfo.().getPerson():" + info.getPerson().getId());
  182. //查询考核计划是否存在 如果存在则不新增
  183. boolean exists = iPerfEvaObject.exists("where period = '" + info.get("period") + "' and person = '" + info.getPerson().getId().toString() + "'");
  184. logger.error("exists--" + exists);
  185. if (exists) {
  186. continue;
  187. }
  188. addCoreColl.add(info);
  189. ++sucess;
  190. body.setMuitTipsState(Boolean.TRUE);
  191. body.setMuitTipsMessage(SHRPerfWebResourceUtil.getRes(SHRPerfWebResource.OPERATESUCCESS, ctx));
  192. } catch (Exception var23) {
  193. var23.printStackTrace();
  194. croeBase.removeObject(i);
  195. --i;
  196. ++failure;
  197. body.setMuitTipsState(Boolean.FALSE);
  198. if (var23 instanceof ObjectNotFoundException) {
  199. body.setMuitTipsMessage(SHRPerfWebResourceUtil.getRes(SHRPerfWebResource.DATADELETED, ctx));
  200. } else {
  201. body.setMuitTipsMessage(SHRPerfWebResourceUtil.getRes(SHRPerfWebResource.OPERATEFAILED, ctx));
  202. }
  203. logger.error(var23.getMessage(), var23);
  204. }
  205. if (addCoreColl.size() == 100) {
  206. logger.error("addCoreColl.size()==100" + addCoreColl.size());
  207. iObjectPKS = PerfEvaObjectFactory.getRemoteInstance().saveBatchData(addCoreColl);
  208. addCoreColl.clear();
  209. }
  210. }
  211. logger.error("addCoreColl" + addCoreColl.size());
  212. if (addCoreColl.size() > 0) {
  213. iObjectPKS = PerfEvaObjectFactory.getRemoteInstance().saveBatchData(addCoreColl);
  214. addCoreColl.clear();
  215. }
  216. if (sucess > 0) {
  217. PerfPlanUtils.writeRefStateForPerfPeriod(ctx, periodId, RefStatusEnum.REFERED);
  218. }
  219. if (iObjectPKS != null) {
  220. //setUpGroups(ctx, iObjectPKS);
  221. }
  222. return iObjectPKS;
  223. } catch (Exception var24) {
  224. logger.error("runBatchSaveEvaObject----" + var24);
  225. var24.printStackTrace();
  226. throw new SHRWebException(var24.getMessage(), var24);
  227. }
  228. }
  229. /**
  230. * 设置分组
  231. *
  232. * @param ctx
  233. * @param iObjectPKS
  234. */
  235. public void setUpGroups(Context ctx, IObjectPK[] iObjectPKS) throws BOSException, EASBizException, ShrWebBizException {
  236. IPerfGoalsGroup iPerfGoalsGroup = PerfGoalsGroupFactory.getLocalInstance(ctx);
  237. PerfGoalsGroupInfo perfGoalsGroupInfo = iPerfGoalsGroup.getPerfGoalsGroupInfo("where number = '20241105001'");
  238. String goalsGroupId = perfGoalsGroupInfo.getId().toString();
  239. StringBuilder sb = new StringBuilder();
  240. for (int i = 0; i < iObjectPKS.length; i++) {
  241. IObjectPK iObjectPK = iObjectPKS[i];
  242. sb.append(iObjectPK.toString()).append(",");
  243. }
  244. sb.deleteCharAt(sb.lastIndexOf(","));
  245. String groupId = goalsGroupId;
  246. if (!PerfEvaObjGroupUtils.checkGroupIsValid(ctx, groupId)) {
  247. throw new ShrWebBizException((new SHRPerfWebBizException(SHRPerfWebBizException.INDECATORNOTSAVEDINSELECTGROUP)).getMessage());
  248. } else {
  249. try {
  250. CoreBaseCollection perfEvaObjColl = new CoreBaseCollection();
  251. IPerfEvaObject iPerfEvaObject = PerfEvaObjectFactory.getRemoteInstance();
  252. Set<String> billIds = new HashSet();
  253. Set<String> fails = new HashSet();
  254. String billId = sb.toString();
  255. billIds.addAll(Arrays.asList(billId.split(",")));
  256. PerfEvaObjectCollection coll = getPerfEvaObjectCollectionByIds(billIds);
  257. if (coll != null && coll.size() > 0) {
  258. String periodId = coll.get(0).getPeriod().getId().toString();
  259. PerfPeriodInfo perfPeriodInfo = PerfPeriodFactory.getRemoteInstance().getPerfPeriodInfo("select perfPlan.id,perfRule.id where id = '" + periodId + "'");
  260. String perfRuleId = perfPeriodInfo.getPerfRule().getId().toString();
  261. Map<String, Object> checkResult = PerfRuleSettingUtil.checkRuleData(perfRuleId, "", perfPeriodInfo.getPerfPlan().getId().toString(), ctx);
  262. boolean flag = (Boolean) checkResult.get("result");
  263. String reMsg = "";
  264. if (!flag) {
  265. //addBatchMessageTips(billIds, (String) checkResult.get("msg"), batchMessageTipsHeader);
  266. } else {
  267. int i = 0;
  268. while (true) {
  269. if (i >= coll.size()) {
  270. iPerfEvaObject.updateBatchData(perfEvaObjColl);
  271. break;
  272. }
  273. PerfEvaObjectInfo evaObjInfo = coll.get(i);
  274. PerfEvaObjectUnitGoalsStatusEnum unitGoalsStatus = evaObjInfo.getUnitGoalsStatus();
  275. if (unitGoalsStatus != null && unitGoalsStatus.getValue() == 1) {
  276. fails.add(evaObjInfo.getId().toString());
  277. } else {
  278. evaObjInfo.setBelongGroup(groupId);
  279. perfEvaObjColl.add(evaObjInfo);
  280. }
  281. ++i;
  282. }
  283. }
  284. }
  285. } catch (BOSException var22) {
  286. logger.error("", var22);
  287. throw new ShrWebBizException((new SHRPerfWebBizException(SHRPerfWebBizException.SYSTEMERR)).getMessage());
  288. } catch (EASBizException var23) {
  289. logger.error("", var23);
  290. throw new ShrWebBizException((new SHRPerfWebBizException(SHRPerfWebBizException.SYSTEMERR)).getMessage());
  291. }
  292. }
  293. }
  294. private static PerfEvaObjectCollection getPerfEvaObjectCollectionByIds(Set<String> billIds) throws BOSException {
  295. FilterInfo filterInfo = new FilterInfo();
  296. filterInfo.getFilterItems().add(new FilterItemInfo("id", billIds, CompareType.INCLUDE));
  297. EntityViewInfo evi = new EntityViewInfo();
  298. evi.setFilter(filterInfo);
  299. IPerfEvaObject iPerfEvaObject = PerfEvaObjectFactory.getRemoteInstance();
  300. return iPerfEvaObject.getPerfEvaObjectCollection(evi);
  301. }
  302. public static void checkPeriod(String period) throws SHRWebException {
  303. if (org.apache.commons.lang.StringUtils.isEmpty(period)) {
  304. throw new ShrWebBizException((new SHRPerfWebBizException(SHRPerfWebBizException.PERFPERIODNOTEXIST)).getMessage());
  305. } else {
  306. PerfPeriodInfo info = null;
  307. try {
  308. info = PerfPeriodFactory.getRemoteInstance().getPerfPeriodInfo("where id = '" + period + "'");
  309. } catch (Exception var3) {
  310. logger.error(var3.toString());
  311. throw new ShrWebBizException((new SHRPerfWebBizException(SHRPerfWebBizException.GETPERIODDATAERR)).getMessage());
  312. }
  313. if (info.getEvaPeriodStatus().getValue() == 100) {
  314. throw new ShrWebBizException((new SHRPerfWebBizException(SHRPerfWebBizException.OPERATENOTALLOWEDASPERIODISEND)).getMessage());
  315. }
  316. }
  317. }
  318. public Map<String, String> getPerfPlanName(Context ctx, String period, String hrOrgUnit) throws EASBizException, BOSException {
  319. String oql = this.getExistPerfplanSql(ctx, period, hrOrgUnit);
  320. Map<String, String> map = new HashMap();
  321. EntityViewInfo viewInfo = new EntityViewInfo();
  322. SelectorItemCollection sic = new SelectorItemCollection();
  323. sic.add(new SelectorItemInfo("id"));
  324. sic.add(new SelectorItemInfo("name"));
  325. FilterInfo filter = new FilterInfo();
  326. filter.getFilterItems().add(new FilterItemInfo("id", oql, CompareType.INNER));
  327. viewInfo.setFilter(filter);
  328. viewInfo.setSelector(sic);
  329. PerfPlanCollection coll = PerfPlanFactory.getRemoteInstance().getPerfPlanCollection(viewInfo);
  330. for (int i = 0; i < coll.size(); ++i) {
  331. map.put(coll.get(i).getId().toString(), coll.get(i).getName());
  332. }
  333. return map;
  334. }
  335. private String getExistPerfplanSql(Context ctx, String periodId, String hrOrgUnit) throws BOSException, EASBizException {
  336. PerfPeriodInfo perfPeriodInfo = null;
  337. PerfPlanInfo planInfo = null;
  338. perfPeriodInfo = PerfPeriodFactory.getLocalInstance(ctx).getPerfPeriodInfo(new ObjectUuidPK(periodId));
  339. planInfo = PerfPlanFactory.getLocalInstance(ctx).getPerfPlanInfo(new ObjectUuidPK(perfPeriodInfo.getPerfPlan().getId().toString()));
  340. String sql = " select tt.fid from t_eva_perfperiod t inner join t_eva_perfplan tt on t.fperfplan = tt.fid where t.fnumber ='" + perfPeriodInfo.getNumber() + "' and tt.fperfmodelid = '" + planInfo.getPerfModel().getId().toString() + "' and tt.FHrUnitOrgID = '" + hrOrgUnit + "'";
  341. return sql;
  342. }
  343. protected Map<String, String> getEvaObject(Context ctx, String period, String hrOrgUnit, Set<String> personIds) throws EASBizException, BOSException {
  344. String oql = this.getExistPeriodSql(ctx, period, hrOrgUnit);
  345. Map<String, String> map = new HashMap();
  346. EntityViewInfo viewInfo = new EntityViewInfo();
  347. SelectorItemCollection sic = new SelectorItemCollection();
  348. sic.add(new SelectorItemInfo("id"));
  349. sic.add(new SelectorItemInfo("person.name"));
  350. sic.add(new SelectorItemInfo("person.number"));
  351. sic.add(new SelectorItemInfo("perfFile.position.id"));
  352. sic.add(new SelectorItemInfo("perfFile.assignType"));
  353. sic.add(new SelectorItemInfo("period.perfplan.id"));
  354. FilterInfo filter = new FilterInfo();
  355. filter.getFilterItems().add(new FilterItemInfo("period", oql, CompareType.INNER));
  356. filter.getFilterItems().add(new FilterItemInfo("isOrg", 1, CompareType.NOTEQUALS));
  357. filter.getFilterItems().add(new FilterItemInfo("person.id", personIds, CompareType.INCLUDE));
  358. viewInfo.setFilter(filter);
  359. viewInfo.setSelector(sic);
  360. PerfEvaObjectCollection coll = PerfEvaObjectFactory.getRemoteInstance().getPerfEvaObjectCollection(viewInfo);
  361. for (int i = 0; i < coll.size(); ++i) {
  362. PerfEvaObjectInfo info = coll.get(i);
  363. if (!org.apache.commons.lang.StringUtils.isEmpty(info.getPerson().getNumber()) && info.getPerfFile().getPosition() != null && info.getPerfFile().getAssignType() != null) {
  364. String key = info.getPerson().getNumber() + "_" + info.getPerson().getName() + "_" + info.getPerfFile().getPosition().getId().toString() + "_" + info.getPerfFile().getAssignType().getValue();
  365. map.put(key, info.getPeriod().getPerfPlan().getId().toString());
  366. }
  367. }
  368. return map;
  369. }
  370. private String getExistPeriodSql(Context ctx, String periodId, String hrOrgUnit) throws BOSException, EASBizException {
  371. PerfPeriodInfo perfPeriodInfo = null;
  372. PerfPlanInfo planInfo = null;
  373. perfPeriodInfo = PerfPeriodFactory.getLocalInstance(ctx).getPerfPeriodInfo(new ObjectUuidPK(periodId));
  374. planInfo = PerfPlanFactory.getLocalInstance(ctx).getPerfPlanInfo(new ObjectUuidPK(perfPeriodInfo.getPerfPlan().getId().toString()));
  375. String sql = " select t.fid from t_eva_perfperiod t left outer join t_eva_perfplan tt on t.fperfplan = tt.fid where t.fnumber ='" + perfPeriodInfo.getNumber() + "' and tt.fperfmodelid = '" + planInfo.getPerfModel().getId().toString() + "' and tt.FHrUnitOrgID = '" + hrOrgUnit + "'";
  376. return sql;
  377. }
  378. }