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 void 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. this.runBatchSaveEvaObject(ctx, periodId, hrOrgUnit, croeBase);
  127. } else {
  128. throw new SHRWebException((new SHRPerfWebBizException(SHRPerfWebBizException.GETERR)).getMessage());
  129. }
  130. }
  131. protected void 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. boolean exists = iPerfEvaObject.exists("where period = '" + info.get("period") + "' and person = '" + info.getPerson().getId().toString() + "'");
  183. if (exists) {
  184. continue;
  185. }
  186. addCoreColl.add(info);
  187. ++sucess;
  188. body.setMuitTipsState(Boolean.TRUE);
  189. body.setMuitTipsMessage(SHRPerfWebResourceUtil.getRes(SHRPerfWebResource.OPERATESUCCESS, ctx));
  190. } catch (Exception var23) {
  191. var23.printStackTrace();
  192. croeBase.removeObject(i);
  193. --i;
  194. ++failure;
  195. body.setMuitTipsState(Boolean.FALSE);
  196. if (var23 instanceof ObjectNotFoundException) {
  197. body.setMuitTipsMessage(SHRPerfWebResourceUtil.getRes(SHRPerfWebResource.DATADELETED, ctx));
  198. } else {
  199. body.setMuitTipsMessage(SHRPerfWebResourceUtil.getRes(SHRPerfWebResource.OPERATEFAILED, ctx));
  200. }
  201. logger.error(var23.getMessage(), var23);
  202. }
  203. if (addCoreColl.size() == 100) {
  204. iObjectPKS = PerfEvaObjectFactory.getRemoteInstance().saveBatchData(addCoreColl);
  205. addCoreColl.clear();
  206. }
  207. }
  208. logger.error("addCoreColl" + addCoreColl.size());
  209. if (addCoreColl.size() > 0) {
  210. iObjectPKS = PerfEvaObjectFactory.getRemoteInstance().saveBatchData(addCoreColl);
  211. addCoreColl.clear();
  212. }
  213. if (sucess > 0) {
  214. PerfPlanUtils.writeRefStateForPerfPeriod(ctx, periodId, RefStatusEnum.REFERED);
  215. }
  216. if (iObjectPKS != null) {
  217. //setUpGroups(ctx, iObjectPKS);
  218. }
  219. } catch (Exception var24) {
  220. logger.error("runBatchSaveEvaObject----" + var24);
  221. var24.printStackTrace();
  222. throw new SHRWebException(var24.getMessage(), var24);
  223. }
  224. logger.error("runBatchSaveEvaObject----end");
  225. }
  226. /**
  227. * 设置分组
  228. *
  229. * @param ctx
  230. * @param iObjectPKS
  231. */
  232. public void setUpGroups(Context ctx, IObjectPK[] iObjectPKS) throws BOSException, EASBizException, ShrWebBizException {
  233. IPerfGoalsGroup iPerfGoalsGroup = PerfGoalsGroupFactory.getLocalInstance(ctx);
  234. PerfGoalsGroupInfo perfGoalsGroupInfo = iPerfGoalsGroup.getPerfGoalsGroupInfo("where number = '20241105001'");
  235. String goalsGroupId = perfGoalsGroupInfo.getId().toString();
  236. StringBuilder sb = new StringBuilder();
  237. for (int i = 0; i < iObjectPKS.length; i++) {
  238. IObjectPK iObjectPK = iObjectPKS[i];
  239. sb.append(iObjectPK.toString()).append(",");
  240. }
  241. sb.deleteCharAt(sb.lastIndexOf(","));
  242. String groupId = goalsGroupId;
  243. if (!PerfEvaObjGroupUtils.checkGroupIsValid(ctx, groupId)) {
  244. throw new ShrWebBizException((new SHRPerfWebBizException(SHRPerfWebBizException.INDECATORNOTSAVEDINSELECTGROUP)).getMessage());
  245. } else {
  246. try {
  247. CoreBaseCollection perfEvaObjColl = new CoreBaseCollection();
  248. IPerfEvaObject iPerfEvaObject = PerfEvaObjectFactory.getRemoteInstance();
  249. Set<String> billIds = new HashSet();
  250. Set<String> fails = new HashSet();
  251. String billId = sb.toString();
  252. billIds.addAll(Arrays.asList(billId.split(",")));
  253. PerfEvaObjectCollection coll = getPerfEvaObjectCollectionByIds(billIds);
  254. if (coll != null && coll.size() > 0) {
  255. String periodId = coll.get(0).getPeriod().getId().toString();
  256. PerfPeriodInfo perfPeriodInfo = PerfPeriodFactory.getRemoteInstance().getPerfPeriodInfo("select perfPlan.id,perfRule.id where id = '" + periodId + "'");
  257. String perfRuleId = perfPeriodInfo.getPerfRule().getId().toString();
  258. Map<String, Object> checkResult = PerfRuleSettingUtil.checkRuleData(perfRuleId, "", perfPeriodInfo.getPerfPlan().getId().toString(), ctx);
  259. boolean flag = (Boolean) checkResult.get("result");
  260. String reMsg = "";
  261. if (!flag) {
  262. //addBatchMessageTips(billIds, (String) checkResult.get("msg"), batchMessageTipsHeader);
  263. } else {
  264. int i = 0;
  265. while (true) {
  266. if (i >= coll.size()) {
  267. iPerfEvaObject.updateBatchData(perfEvaObjColl);
  268. break;
  269. }
  270. PerfEvaObjectInfo evaObjInfo = coll.get(i);
  271. PerfEvaObjectUnitGoalsStatusEnum unitGoalsStatus = evaObjInfo.getUnitGoalsStatus();
  272. if (unitGoalsStatus != null && unitGoalsStatus.getValue() == 1) {
  273. fails.add(evaObjInfo.getId().toString());
  274. } else {
  275. evaObjInfo.setBelongGroup(groupId);
  276. perfEvaObjColl.add(evaObjInfo);
  277. }
  278. ++i;
  279. }
  280. }
  281. }
  282. } catch (BOSException var22) {
  283. logger.error("", var22);
  284. throw new ShrWebBizException((new SHRPerfWebBizException(SHRPerfWebBizException.SYSTEMERR)).getMessage());
  285. } catch (EASBizException var23) {
  286. logger.error("", var23);
  287. throw new ShrWebBizException((new SHRPerfWebBizException(SHRPerfWebBizException.SYSTEMERR)).getMessage());
  288. }
  289. }
  290. }
  291. private static PerfEvaObjectCollection getPerfEvaObjectCollectionByIds(Set<String> billIds) throws BOSException {
  292. FilterInfo filterInfo = new FilterInfo();
  293. filterInfo.getFilterItems().add(new FilterItemInfo("id", billIds, CompareType.INCLUDE));
  294. EntityViewInfo evi = new EntityViewInfo();
  295. evi.setFilter(filterInfo);
  296. IPerfEvaObject iPerfEvaObject = PerfEvaObjectFactory.getRemoteInstance();
  297. return iPerfEvaObject.getPerfEvaObjectCollection(evi);
  298. }
  299. public static void checkPeriod(String period) throws SHRWebException {
  300. if (org.apache.commons.lang.StringUtils.isEmpty(period)) {
  301. throw new ShrWebBizException((new SHRPerfWebBizException(SHRPerfWebBizException.PERFPERIODNOTEXIST)).getMessage());
  302. } else {
  303. PerfPeriodInfo info = null;
  304. try {
  305. info = PerfPeriodFactory.getRemoteInstance().getPerfPeriodInfo("where id = '" + period + "'");
  306. } catch (Exception var3) {
  307. logger.error(var3.toString());
  308. throw new ShrWebBizException((new SHRPerfWebBizException(SHRPerfWebBizException.GETPERIODDATAERR)).getMessage());
  309. }
  310. if (info.getEvaPeriodStatus().getValue() == 100) {
  311. throw new ShrWebBizException((new SHRPerfWebBizException(SHRPerfWebBizException.OPERATENOTALLOWEDASPERIODISEND)).getMessage());
  312. }
  313. }
  314. }
  315. public Map<String, String> getPerfPlanName(Context ctx, String period, String hrOrgUnit) throws EASBizException, BOSException {
  316. String oql = this.getExistPerfplanSql(ctx, period, hrOrgUnit);
  317. Map<String, String> map = new HashMap();
  318. EntityViewInfo viewInfo = new EntityViewInfo();
  319. SelectorItemCollection sic = new SelectorItemCollection();
  320. sic.add(new SelectorItemInfo("id"));
  321. sic.add(new SelectorItemInfo("name"));
  322. FilterInfo filter = new FilterInfo();
  323. filter.getFilterItems().add(new FilterItemInfo("id", oql, CompareType.INNER));
  324. viewInfo.setFilter(filter);
  325. viewInfo.setSelector(sic);
  326. PerfPlanCollection coll = PerfPlanFactory.getRemoteInstance().getPerfPlanCollection(viewInfo);
  327. for (int i = 0; i < coll.size(); ++i) {
  328. map.put(coll.get(i).getId().toString(), coll.get(i).getName());
  329. }
  330. return map;
  331. }
  332. private String getExistPerfplanSql(Context ctx, String periodId, String hrOrgUnit) throws BOSException, EASBizException {
  333. PerfPeriodInfo perfPeriodInfo = null;
  334. PerfPlanInfo planInfo = null;
  335. perfPeriodInfo = PerfPeriodFactory.getLocalInstance(ctx).getPerfPeriodInfo(new ObjectUuidPK(periodId));
  336. planInfo = PerfPlanFactory.getLocalInstance(ctx).getPerfPlanInfo(new ObjectUuidPK(perfPeriodInfo.getPerfPlan().getId().toString()));
  337. 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 + "'";
  338. return sql;
  339. }
  340. protected Map<String, String> getEvaObject(Context ctx, String period, String hrOrgUnit, Set<String> personIds) throws EASBizException, BOSException {
  341. String oql = this.getExistPeriodSql(ctx, period, hrOrgUnit);
  342. Map<String, String> map = new HashMap();
  343. EntityViewInfo viewInfo = new EntityViewInfo();
  344. SelectorItemCollection sic = new SelectorItemCollection();
  345. sic.add(new SelectorItemInfo("id"));
  346. sic.add(new SelectorItemInfo("person.name"));
  347. sic.add(new SelectorItemInfo("person.number"));
  348. sic.add(new SelectorItemInfo("perfFile.position.id"));
  349. sic.add(new SelectorItemInfo("perfFile.assignType"));
  350. sic.add(new SelectorItemInfo("period.perfplan.id"));
  351. FilterInfo filter = new FilterInfo();
  352. filter.getFilterItems().add(new FilterItemInfo("period", oql, CompareType.INNER));
  353. filter.getFilterItems().add(new FilterItemInfo("isOrg", 1, CompareType.NOTEQUALS));
  354. filter.getFilterItems().add(new FilterItemInfo("person.id", personIds, CompareType.INCLUDE));
  355. viewInfo.setFilter(filter);
  356. viewInfo.setSelector(sic);
  357. PerfEvaObjectCollection coll = PerfEvaObjectFactory.getRemoteInstance().getPerfEvaObjectCollection(viewInfo);
  358. for (int i = 0; i < coll.size(); ++i) {
  359. PerfEvaObjectInfo info = coll.get(i);
  360. if (!org.apache.commons.lang.StringUtils.isEmpty(info.getPerson().getNumber()) && info.getPerfFile().getPosition() != null && info.getPerfFile().getAssignType() != null) {
  361. String key = info.getPerson().getNumber() + "_" + info.getPerson().getName() + "_" + info.getPerfFile().getPosition().getId().toString() + "_" + info.getPerfFile().getAssignType().getValue();
  362. map.put(key, info.getPeriod().getPerfPlan().getId().toString());
  363. }
  364. }
  365. return map;
  366. }
  367. private String getExistPeriodSql(Context ctx, String periodId, String hrOrgUnit) throws BOSException, EASBizException {
  368. PerfPeriodInfo perfPeriodInfo = null;
  369. PerfPlanInfo planInfo = null;
  370. perfPeriodInfo = PerfPeriodFactory.getLocalInstance(ctx).getPerfPeriodInfo(new ObjectUuidPK(periodId));
  371. planInfo = PerfPlanFactory.getLocalInstance(ctx).getPerfPlanInfo(new ObjectUuidPK(perfPeriodInfo.getPerfPlan().getId().toString()));
  372. 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 + "'";
  373. return sql;
  374. }
  375. }