MaintainPlanServiceImpl.java 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268
  1. package cn.com.lzt.maintainplan.service.impl;
  2. import cn.com.lzt.maintainplan.entity.MaintainPlanEntity;
  3. import cn.com.lzt.maintainplan.service.MaintainPlanServiceI;
  4. import cn.com.lzt.maintainplanprojserv.entity.MaintainPlanProjservEntity;
  5. import cn.com.lzt.maintainplantimes.entity.MaintainPlanTimesEntity;
  6. import org.apache.commons.collections.list.SetUniqueList;
  7. import org.apache.commons.lang.xwork.StringUtils;
  8. import org.jeecgframework.core.common.exception.BusinessException;
  9. import org.jeecgframework.core.common.service.impl.CommonServiceImpl;
  10. import org.jeecgframework.core.constant.Globals;
  11. import org.jeecgframework.core.util.MyBeanUtils;
  12. import org.jeecgframework.core.util.StringUtil;
  13. import org.jeecgframework.core.util.oConvertUtils;
  14. import org.jeecgframework.p3.core.common.utils.DateUtil;
  15. import org.springframework.stereotype.Service;
  16. import org.springframework.transaction.annotation.Transactional;
  17. import java.util.*;
  18. @Service("maintainPlanService")
  19. @Transactional
  20. public class MaintainPlanServiceImpl extends CommonServiceImpl implements MaintainPlanServiceI {
  21. public <T> void delete(T entity) {
  22. super.delete(entity);
  23. //执行删除操作配置的sql增强
  24. this.doDelSql((MaintainPlanEntity)entity);
  25. }
  26. public void addMain(MaintainPlanEntity maintainPlan,
  27. List<MaintainPlanProjservEntity> maintainPlanProjservList,List<MaintainPlanTimesEntity> maintainPlanTimesList){
  28. //保存主信息
  29. String code = com.xcgl.utils.OrderNumTools.generateNextBillCode(Globals.CODE_PREFIX_MAINTAINPLAN,"t_b_maintain_plan","code",4);
  30. maintainPlan.setCode(code);
  31. maintainPlan.setIsNotice(Globals.NO);
  32. setMaintainMonth(maintainPlan,maintainPlanTimesList);
  33. this.save(maintainPlan);
  34. /**保存-供方服务计划服务明细*/
  35. for(MaintainPlanProjservEntity maintainPlanProjserv:maintainPlanProjservList){
  36. //外键设置
  37. maintainPlanProjserv.setMaintainid(maintainPlan.getId());
  38. this.save(maintainPlanProjserv);
  39. }
  40. /**保存-供方服务计划时间明细*/
  41. for(MaintainPlanTimesEntity maintainPlanTimes:maintainPlanTimesList){
  42. //外键设置
  43. maintainPlanTimes.setMaintainplanid(maintainPlan.getId());
  44. maintainPlanTimes.setIsGenTask(Globals.NO);
  45. this.save(maintainPlanTimes);
  46. }
  47. //执行新增操作配置的sql增强
  48. this.doAddSql(maintainPlan);
  49. }
  50. public void updateMain(MaintainPlanEntity maintainPlan,
  51. List<MaintainPlanProjservEntity> maintainPlanProjservList,List<MaintainPlanTimesEntity> maintainPlanTimesList) {
  52. //保存主表信息
  53. if(StringUtil.isNotEmpty(maintainPlan.getId())){
  54. try {
  55. MaintainPlanEntity temp = findUniqueByProperty(MaintainPlanEntity.class, "id", maintainPlan.getId());
  56. MyBeanUtils.copyBeanNotNull2Bean(maintainPlan, temp);
  57. if(maintainPlan.getContractStartDate()==null){
  58. temp.setContractStartDate(null);
  59. }
  60. if(maintainPlan.getContractEndDate()==null){
  61. temp.setContractEndDate(null);
  62. }
  63. setMaintainMonth(temp,maintainPlanTimesList);
  64. this.saveOrUpdate(temp);
  65. } catch (Exception e) {
  66. e.printStackTrace();
  67. }
  68. }else{
  69. this.saveOrUpdate(maintainPlan);
  70. }
  71. //===================================================================================
  72. //获取参数
  73. Object id0 = maintainPlan.getId();
  74. Object id1 = maintainPlan.getId();
  75. //===================================================================================
  76. //1.查询出数据库的明细数据-供方服务计划服务明细
  77. String hql0 = "from MaintainPlanProjservEntity where 1 = 1 AND mAINTAINID =? ";
  78. List<MaintainPlanProjservEntity> maintainPlanProjservOldList = this.findHql(hql0,id0);
  79. //2.筛选更新明细数据-供方服务计划服务明细
  80. if(maintainPlanProjservList!=null&&maintainPlanProjservList.size()>0){
  81. for(MaintainPlanProjservEntity oldE:maintainPlanProjservOldList){
  82. boolean isUpdate = false;
  83. for(MaintainPlanProjservEntity sendE:maintainPlanProjservList){
  84. //需要更新的明细数据-供方服务计划服务明细
  85. if(oldE.getId().equals(sendE.getId())){
  86. try {
  87. MyBeanUtils.copyBeanNotNull2Bean(sendE,oldE);
  88. this.saveOrUpdate(oldE);
  89. } catch (Exception e) {
  90. e.printStackTrace();
  91. throw new BusinessException(e.getMessage());
  92. }
  93. isUpdate= true;
  94. break;
  95. }
  96. }
  97. if(!isUpdate){
  98. //如果数据库存在的明细,前台没有传递过来则是删除-供方服务计划服务明细
  99. super.delete(oldE);
  100. }
  101. }
  102. //3.持久化新增的数据-供方服务计划服务明细
  103. for(MaintainPlanProjservEntity maintainPlanProjserv:maintainPlanProjservList){
  104. if(oConvertUtils.isEmpty(maintainPlanProjserv.getId())){
  105. //外键设置
  106. maintainPlanProjserv.setMaintainid(maintainPlan.getId());
  107. this.save(maintainPlanProjserv);
  108. }
  109. }
  110. }
  111. //===================================================================================
  112. //1.查询出数据库的明细数据-供方服务计划时间明细
  113. String hql1 = "from MaintainPlanTimesEntity where 1 = 1 AND mAINTAINPLANID =? ";
  114. List<MaintainPlanTimesEntity> maintainPlanTimesOldList = this.findHql(hql1,id1);
  115. //2.筛选更新明细数据-供方服务计划时间明细
  116. if(maintainPlanTimesList!=null&&maintainPlanTimesList.size()>0){
  117. for(MaintainPlanTimesEntity oldE:maintainPlanTimesOldList){
  118. boolean isUpdate = false;
  119. for(MaintainPlanTimesEntity sendE:maintainPlanTimesList){
  120. //需要更新的明细数据-供方服务计划时间明细
  121. if(oldE.getId().equals(sendE.getId())){
  122. try {
  123. MyBeanUtils.copyBeanNotNull2Bean(sendE,oldE);
  124. this.saveOrUpdate(oldE);
  125. } catch (Exception e) {
  126. e.printStackTrace();
  127. throw new BusinessException(e.getMessage());
  128. }
  129. isUpdate= true;
  130. break;
  131. }
  132. }
  133. if(!isUpdate){
  134. //如果数据库存在的明细,前台没有传递过来则是删除-供方服务计划时间明细
  135. super.delete(oldE);
  136. }
  137. }
  138. //3.持久化新增的数据-供方服务计划时间明细
  139. for(MaintainPlanTimesEntity maintainPlanTimes:maintainPlanTimesList){
  140. if(oConvertUtils.isEmpty(maintainPlanTimes.getId())){
  141. //外键设置
  142. maintainPlanTimes.setMaintainplanid(maintainPlan.getId());
  143. maintainPlanTimes.setIsGenTask(Globals.NO);
  144. this.save(maintainPlanTimes);
  145. }
  146. }
  147. }
  148. //执行更新操作配置的sql增强
  149. this.doUpdateSql(maintainPlan);
  150. }
  151. public void delMain(MaintainPlanEntity maintainPlan) {
  152. //删除主表信息
  153. this.delete(maintainPlan);
  154. //===================================================================================
  155. //获取参数
  156. Object id0 = maintainPlan.getId();
  157. Object id1 = maintainPlan.getId();
  158. //===================================================================================
  159. //删除-供方服务计划服务明细
  160. String hql0 = "from MaintainPlanProjservEntity where 1 = 1 AND mAINTAINID =? ";
  161. List<MaintainPlanProjservEntity> maintainPlanProjservOldList = this.findHql(hql0,id0);
  162. this.deleteAllEntitie(maintainPlanProjservOldList);
  163. //===================================================================================
  164. //删除-供方服务计划时间明细
  165. String hql1 = "from MaintainPlanTimesEntity where 1 = 1 AND mAINTAINPLANID =? ";
  166. List<MaintainPlanTimesEntity> maintainPlanTimesOldList = this.findHql(hql1,id1);
  167. this.deleteAllEntitie(maintainPlanTimesOldList);
  168. }
  169. /**
  170. * 默认按钮-sql增强-新增操作
  171. * @return
  172. */
  173. public boolean doAddSql(MaintainPlanEntity t){
  174. return true;
  175. }
  176. /**
  177. * 默认按钮-sql增强-更新操作
  178. * @return
  179. */
  180. public boolean doUpdateSql(MaintainPlanEntity t){
  181. return true;
  182. }
  183. /**
  184. * 默认按钮-sql增强-删除操作
  185. * @return
  186. */
  187. public boolean doDelSql(MaintainPlanEntity t){
  188. return true;
  189. }
  190. /**
  191. * 替换sql中的变量
  192. * @param sql
  193. * @return
  194. */
  195. public String replaceVal(String sql,MaintainPlanEntity t){
  196. sql = sql.replace("#{id}",String.valueOf(t.getId()));
  197. sql = sql.replace("#{create_name}",String.valueOf(t.getCreateName()));
  198. sql = sql.replace("#{create_by}",String.valueOf(t.getCreateBy()));
  199. sql = sql.replace("#{create_date}",String.valueOf(t.getCreateDate()));
  200. sql = sql.replace("#{update_name}",String.valueOf(t.getUpdateName()));
  201. sql = sql.replace("#{update_by}",String.valueOf(t.getUpdateBy()));
  202. sql = sql.replace("#{update_date}",String.valueOf(t.getUpdateDate()));
  203. sql = sql.replace("#{sys_org_code}",String.valueOf(t.getSysOrgCode()));
  204. sql = sql.replace("#{sys_company_code}",String.valueOf(t.getSysCompanyCode()));
  205. sql = sql.replace("#{bpm_status}",String.valueOf(t.getBpmStatus()));
  206. sql = sql.replace("#{proc_inst_id}",String.valueOf(t.getProcInstId()));
  207. sql = sql.replace("#{step_name}",String.valueOf(t.getStepName()));
  208. sql = sql.replace("#{code}",String.valueOf(t.getCode()));
  209. sql = sql.replace("#{name}",String.valueOf(t.getName()));
  210. sql = sql.replace("#{servicetype}",String.valueOf(t.getServicetype()));
  211. sql = sql.replace("#{servicefrequ}",String.valueOf(t.getServicefrequ()));
  212. sql = sql.replace("#{relatedunitid}",String.valueOf(t.getRelatedunitid()));
  213. sql = sql.replace("#{relatedunitname}",String.valueOf(t.getRelatedunitname()));
  214. sql = sql.replace("#{daypermonth}",String.valueOf(t.getDaypermonth()));
  215. sql = sql.replace("#{dayperweek}",String.valueOf(t.getDayperweek()));
  216. sql = sql.replace("#{regulardate}",String.valueOf(t.getRegulardate()));
  217. sql = sql.replace("#{startdate}",String.valueOf(t.getStartdate()));
  218. sql = sql.replace("#{enddate}",String.valueOf(t.getEnddate()));
  219. sql = sql.replace("#{busistatus}",String.valueOf(t.getBusistatus()));
  220. sql = sql.replace("#{remark}",String.valueOf(t.getRemark()));
  221. sql = sql.replace("#{UUID}",UUID.randomUUID().toString());
  222. return sql;
  223. }
  224. @Override
  225. public void processEnd(String id) {
  226. }
  227. //设置维保年度 、维保月度
  228. private void setMaintainMonth(MaintainPlanEntity maintainPlan, List<MaintainPlanTimesEntity> maintainPlanTimesList) {
  229. List<String> years = SetUniqueList.decorate(new ArrayList());
  230. List<String> months = SetUniqueList.decorate(new ArrayList());
  231. for(MaintainPlanTimesEntity timesEntity : maintainPlanTimesList){
  232. Date start = timesEntity.getServicetimestart();
  233. Date end = timesEntity.getServicetimeend();
  234. Calendar c = Calendar.getInstance();
  235. c.setTime(start);
  236. c.set(Calendar.DAY_OF_MONTH,1);
  237. do{
  238. int year = c.get(Calendar.YEAR);
  239. years.add(String.valueOf(year));
  240. months.add(DateUtil.formatDateTime(c.getTime(),"yyyy-MM"));
  241. c.add(Calendar.MONTH,1);
  242. }while(c.getTime().getTime()<=end.getTime());
  243. }
  244. maintainPlan.setMaintainYear(StringUtils.join(years,","));
  245. maintainPlan.setMaintainMonth(StringUtils.join(months,","));
  246. maintainPlan.setContractId(StringUtils.trimToNull(maintainPlan.getContractId()));
  247. maintainPlan.setProjectServiceId(StringUtils.trimToNull(maintainPlan.getProjectServiceId()));
  248. }
  249. }