a7c23d1e5cd9781714daca9ac97b76b436906b56.svn-base 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224
  1. package cn.com.goldenwater.dcproj.controller.pblm;
  2. import cn.com.goldenwater.core.web.BaseController;
  3. import cn.com.goldenwater.dcproj.dao.*;
  4. import cn.com.goldenwater.dcproj.model.*;
  5. import cn.com.goldenwater.dcproj.param.BisInspAllObjParam;
  6. import cn.com.goldenwater.dcproj.param.BisInspPblmParam;
  7. import cn.com.goldenwater.dcproj.param.BisInspRsvrRgstrParam;
  8. import cn.com.goldenwater.dcproj.service.BisInspRsvrRgstrService;
  9. import cn.com.goldenwater.id.util.UuidUtil;
  10. import io.swagger.annotations.Api;
  11. import io.swagger.annotations.ApiOperation;
  12. import org.apache.commons.lang3.StringUtils;
  13. import org.slf4j.Logger;
  14. import org.slf4j.LoggerFactory;
  15. import org.springframework.beans.factory.annotation.Autowired;
  16. import org.springframework.web.bind.annotation.PathVariable;
  17. import org.springframework.web.bind.annotation.RequestMapping;
  18. import org.springframework.web.bind.annotation.RequestMethod;
  19. import org.springframework.web.bind.annotation.RestController;
  20. import java.util.ArrayList;
  21. import java.util.Date;
  22. import java.util.List;
  23. @Api(value = "APP 数据清洗", tags = "APP 数据清洗")
  24. @RestController
  25. @RequestMapping("/dc/wash")
  26. public class WashPblmDataController extends BaseController {
  27. private Logger logger = LoggerFactory.getLogger(getClass());
  28. @Autowired
  29. private ObjInspPblmsRsvrDao objInspPblmsRsvrDao;
  30. @Autowired
  31. private ObjInspPblmsDao objInspPblmsDao;
  32. @Autowired
  33. private BisInspPblmDao inspPblmDao;
  34. @Autowired
  35. private BisInspAllObjDao inspAllObjDao;
  36. @Autowired
  37. private BisInspRsvrRgstrService inspRsvrRgstrService;
  38. @Autowired
  39. private AttRsBaseDao attRsBaseDao;
  40. @ApiOperation(value = "清洗历史标准")
  41. @RequestMapping(value = "/wash/{objType}",method = RequestMethod.GET)
  42. public Object wash(@PathVariable(required = true) String objType){
  43. BisInspPblmParam inspPblmParam=new BisInspPblmParam();
  44. inspPblmParam.setObjType(objType);
  45. List<BisInspPblm> bisInspPblmList=inspPblmDao.findList(inspPblmParam);
  46. if(bisInspPblmList==null){
  47. return buildFailResponse();
  48. }
  49. logger.info("总数:--》"+bisInspPblmList.size());
  50. for(int i=0;i<bisInspPblmList.size();i++){
  51. BisInspPblm bisInspPblm=bisInspPblmList.get(i);
  52. if(StringUtils.isNotBlank(bisInspPblm.getPblmsTypeId())) {
  53. ObjInspPblmsRsvr inspPblmsRsvr = objInspPblmsRsvrDao.get(bisInspPblm.getPblmsTypeId());
  54. if(inspPblmsRsvr!=null){
  55. setPblms(bisInspPblm,inspPblmsRsvr);
  56. logger.info("inspPblmsRsvr总数:--》"+inspPblmsRsvr.getInspPblmsName());
  57. }else {
  58. ObjInspPblms objInspPblms = objInspPblmsDao.get(bisInspPblm.getPblmsTypeId());
  59. if (objInspPblms != null) {
  60. bisInspPblm.setPblmDescBz(objInspPblms.getPblmDesc());
  61. bisInspPblm.setPblmNameBz(objInspPblms.getInspPblmsName());
  62. bisInspPblm.setSnNumBz(objInspPblms.getSnNum());
  63. bisInspPblm.setCheckPointBz(objInspPblms.getCheckPoint());
  64. bisInspPblm.setFileNo(objInspPblms.getAttach());
  65. bisInspPblm.setFileNoNumber(objInspPblms.getSnNum());
  66. logger.info("objInspPblms总数:--》" + objInspPblms.getInspPblmsName());
  67. }else {
  68. inspPblmsRsvr = objInspPblmsRsvrDao.getOldBz(bisInspPblm.getPblmsTypeId());
  69. if(inspPblmsRsvr!=null) {
  70. setPblms(bisInspPblm, inspPblmsRsvr);
  71. }
  72. }
  73. }
  74. inspPblmDao.update(bisInspPblm);
  75. }
  76. }
  77. return buildSuccessResponse();
  78. }
  79. private BisInspPblm setPblms(BisInspPblm bisInspPblm,ObjInspPblmsRsvr inspPblmsRsvr){
  80. bisInspPblm.setPblmDescBz(inspPblmsRsvr.getPblmDesc());
  81. bisInspPblm.setPblmNameBz(inspPblmsRsvr.getInspPblmsName());
  82. bisInspPblm.setSnNumBz(inspPblmsRsvr.getSnNum());
  83. bisInspPblm.setCheckPointBz(inspPblmsRsvr.getCheckPoint());
  84. bisInspPblm.setFileNo(inspPblmsRsvr.getAttach());
  85. bisInspPblm.setFileNoNumber(inspPblmsRsvr.getSnNum());
  86. return bisInspPblm;
  87. }
  88. @ApiOperation(value = "批量添加督查对象")
  89. @RequestMapping(value = "/add/rsvr",method = RequestMethod.GET)
  90. public Object rsvr(){
  91. List<RsvrDto> rsvrDtoList=objInspPblmsRsvrDao.findRsvrDto();
  92. for(RsvrDto dto:rsvrDtoList) {
  93. List<AttRsBase> attRsBaseList=new ArrayList<>();
  94. AttRsBase attRsBaseSearch = attRsBaseDao.get(dto.getAdCode());
  95. logger.info(dto.getId()+":"+dto.getAdCode()+":adCode="+attRsBaseSearch.getRsCode());
  96. if(attRsBaseSearch==null){
  97. continue;
  98. }
  99. attRsBaseList.add(attRsBaseSearch);
  100. for(AttRsBase attRsBase:attRsBaseList){
  101. logger.info(dto.getId()+":"+dto.getAdCode()+":rscode="+attRsBase.getRsCode());
  102. String objId=UuidUtil.uuid();
  103. BisInspAllObj bisInspAllObj=new BisInspAllObj();
  104. bisInspAllObj.setId(dto.getId());
  105. bisInspAllObj.setProvince("350000000000");
  106. bisInspAllObj.setCode(attRsBase.getRsCode());
  107. bisInspAllObj.setObjId(objId);
  108. bisInspAllObj.setOrgId("034");
  109. bisInspAllObj.setNm(attRsBase.getRsName());
  110. bisInspAllObj.setAdCode("350000000000");
  111. bisInspAllObj.setPtype("1");
  112. if(StringUtils.isNotBlank(attRsBase.getCenterYGd())) {
  113. bisInspAllObj.setLttd(Double.valueOf(attRsBase.getCenterYGd()));
  114. }
  115. if(StringUtils.isNotBlank(attRsBase.getCenterXGd())) {
  116. bisInspAllObj.setLgtd(Double.valueOf(attRsBase.getCenterXGd()));
  117. }
  118. bisInspAllObj.setLgtdpc(attRsBase.getLongitude());
  119. bisInspAllObj.setLttdpc(attRsBase.getLatitude());
  120. BisInspAllObjParam allObjParam=new BisInspAllObjParam();
  121. allObjParam.setId(dto.getId());
  122. allObjParam.setCode(attRsBase.getRsCode());
  123. BisInspAllObj inspAllObj=inspAllObjDao.getBy(allObjParam);
  124. if(inspAllObj==null) {
  125. logger.info("objname--->"+bisInspAllObj.getNm());
  126. inspAllObjDao.insert(bisInspAllObj);
  127. BisInspRsvrRgstr bisInspRsvrRgstr = new BisInspRsvrRgstr();
  128. bisInspRsvrRgstr.setRgstrId(UuidUtil.uuid());
  129. bisInspRsvrRgstr.setObjId(objId);
  130. bisInspRsvrRgstr.setState("0");
  131. bisInspRsvrRgstr.setReverStat("0");
  132. bisInspRsvrRgstr.setBenefitStat("0");
  133. bisInspRsvrRgstr.setViewStat("0");
  134. bisInspRsvrRgstr.setPresStat("0");
  135. bisInspRsvrRgstr.setRsvrNm(attRsBase.getRsName());
  136. bisInspRsvrRgstr.setBaseStat("0");
  137. bisInspRsvrRgstr.setResRunStat("0");
  138. bisInspRsvrRgstr.setProvince("3500000000000");
  139. bisInspRsvrRgstr=setRsvr(bisInspRsvrRgstr,objId,attRsBase);
  140. logger.info(bisInspRsvrRgstr.getRsvrNm() + "---->");
  141. inspRsvrRgstrService.insert(bisInspRsvrRgstr);
  142. }
  143. }
  144. }
  145. return buildFailResponse();
  146. }
  147. public BisInspRsvrRgstr setRsvr(BisInspRsvrRgstr bisInspRsvrRgstr,String objId,AttRsBase attRsBase){
  148. if(StringUtils.isNotBlank(attRsBase.getCenterXGd())){
  149. bisInspRsvrRgstr.setRsvrLong(Double.valueOf(attRsBase.getCenterXGd()));
  150. }
  151. if(StringUtils.isNotBlank(attRsBase.getCenterYGd())) {
  152. bisInspRsvrRgstr.setRsvrLat(Double.valueOf(attRsBase.getCenterYGd()));
  153. }
  154. bisInspRsvrRgstr.setOrgId("034");
  155. bisInspRsvrRgstr.setDamType(attRsBase.getDamType());
  156. bisInspRsvrRgstr.setHystSite(attRsBase.getLocation());
  157. bisInspRsvrRgstr.setResCreateTime(attRsBase.getCompDate());
  158. bisInspRsvrRgstr.setRsvrAdmName(attRsBase.getRsAdmName());
  159. bisInspRsvrRgstr.setEngScal(attRsBase.getEngScal());
  160. bisInspRsvrRgstr.setRsCode(attRsBase.getRsCode());
  161. bisInspRsvrRgstr.setAdCode(attRsBase.getAdmDiv());
  162. bisInspRsvrRgstr.setTotCap(attRsBase.getTotCap());
  163. bisInspRsvrRgstr.setDamRegCode(attRsBase.getRsAdmCode());
  164. bisInspRsvrRgstr.setDamMaxHigh(attRsBase.getDamSizeHig() + "");
  165. bisInspRsvrRgstr.setCompDateStr(attRsBase.getCompDateStr());
  166. bisInspRsvrRgstr.setDesFlStag(attRsBase.getDesFlStag());
  167. bisInspRsvrRgstr.setReverStat("0");
  168. bisInspRsvrRgstr.setBenefitStat("1");
  169. bisInspRsvrRgstr.setLocation(attRsBase.getLocation());
  170. bisInspRsvrRgstr.setUptm(new Date());
  171. bisInspRsvrRgstr.setIntm(new Date());
  172. bisInspRsvrRgstr.setImpdDt(attRsBase.getImpdDt());
  173. bisInspRsvrRgstr.setRnfcImpdDt(attRsBase.getRnfcImpdDt());
  174. bisInspRsvrRgstr.setRsClass(attRsBase.getRsClass());
  175. bisInspRsvrRgstr.setFlConTopStag(attRsBase.getFlConTopStag());
  176. return bisInspRsvrRgstr;
  177. }
  178. @ApiOperation(value = "批量更新督查对象")
  179. @RequestMapping(value = "/update/rsvr",method = RequestMethod.GET)
  180. public Object updateRsvr() {
  181. List<RsvrDto> rsvrDtoList = objInspPblmsRsvrDao.findRsvrDto();
  182. for (RsvrDto dto : rsvrDtoList) {
  183. String adCode = dto.getAdCode();
  184. List<AttRsBase> attRsBaseList = attRsBaseDao.getObjListNotInspGroupId(dto.getId(), "1", "", "", "", adCode, "35");
  185. logger.info(dto.getId() + ":" + dto.getAdCode() + ":size=" + attRsBaseList.size());
  186. if (attRsBaseList == null) {
  187. continue;
  188. }
  189. for (AttRsBase attRsBase : attRsBaseList) {
  190. BisInspAllObjParam allObjParam = new BisInspAllObjParam();
  191. allObjParam.setId(dto.getId());
  192. allObjParam.setCode(attRsBase.getRsCode());
  193. BisInspAllObj inspAllObj = inspAllObjDao.getBy(allObjParam);
  194. if (inspAllObj != null) {
  195. BisInspRsvrRgstrParam rsvrRgstrParam=new BisInspRsvrRgstrParam();
  196. rsvrRgstrParam.setObjId(inspAllObj.getObjId());
  197. rsvrRgstrParam.setRsCode(inspAllObj.getCode());
  198. BisInspRsvrRgstr bisInspRsvrRgstr=inspRsvrRgstrService.getBy(rsvrRgstrParam);
  199. if(bisInspRsvrRgstr!=null){
  200. bisInspRsvrRgstr=setRsvr(bisInspRsvrRgstr,inspAllObj.getObjId(),attRsBase);
  201. inspRsvrRgstrService.update(bisInspRsvrRgstr);
  202. }
  203. }
  204. }
  205. }
  206. return buildSuccessResponse();
  207. }
  208. }