EquipScanTaskQueryService.kt 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253
  1. /*
  2. * *********************************************************************************************************************
  3. *
  4. * !!
  5. * .F88X
  6. * X8888Y
  7. * .}888888N;
  8. * i888888N; .:! .I$WI:
  9. * R888888I .'N88~ i8}+8Y&8"l8i$8>8W~'>W8}8]KW+8IIN"8&
  10. * .R888888I .;N8888~ .X8' "8I.!,/8" !%NY8`"8I8~~8>,88I
  11. * +888888N; .8888888Y "&&8Y.}8,
  12. * ./888888N; .R888888Y .'}~ .>}'.`+> i}! "i' +/' .'i~ !11,.:">, .~]! .i}i
  13. * ~888888%: .I888888l .]88~`1/iY88Ii+1'.R$8$8]"888888888> Y8$ W8E X8E W8888'188Il}Y88$*
  14. * 18888888 E8888881 .]W%8$`R8X'&8%++N8i,8N%N8+l8%` .}8N:.R$RE%N88N%N$K$R 188,FE$8%~Y88I
  15. * .E888888I .i8888888' .:$8I;88+`E8R:/8N,.>881.`$8E/1/]N8X.Y8N`"KF&&FK!'88*."88K./$88%RN888+~
  16. * 8888888I .,N888888~ ~88i"8W,!N8*.I88.}888%F,i$88"F88" 888:E8X.>88!i88>`888*.}Fl1]*}1YKi'
  17. * i888888N' I888Y ]88;/EX*IFKFK88X K8R .l8W 88Y ~88}'88E&%8W.X8N``]88!.$8K .:W8I
  18. * .i888888N; I8Y .&8$ .X88! i881.:%888>I88 ;88] +88+.';;;;:.Y88X 18N.,88l .+88/
  19. * .:R888888I
  20. * .&888888I Copyright (c) 2009-2020. 博锐尚格科技股份有限公司
  21. * ~8888'
  22. * .!88~ All rights reserved.
  23. *
  24. * *********************************************************************************************************************
  25. */
  26. package com.persagy.server.services.task
  27. import cn.hutool.core.collection.CollUtil
  28. import com.alibaba.fastjson.JSONObject
  29. import com.persagy.database.SFilter
  30. import com.persagy.database.functions.SLength
  31. import com.persagy.mybatis.SMybatisDao
  32. import com.persagy.server.datacenter.models.entities.dictnew.DefClass
  33. import com.persagy.server.datacenter.models.entities.objects.Equipment
  34. import com.persagy.server.datacenter.models.entities.task.CategoryStatistics
  35. import com.persagy.server.datacenter.models.entities.task.EquipScanTaskQuery
  36. import com.persagy.server.services.AdmBaseService
  37. import com.persagy.server.services.DmpBaseService
  38. import com.persagy.server.util.AdmEntityTransferUtil
  39. import com.persagy.service.SObjectService
  40. import com.persagy.service.SPageContext
  41. import com.persagy.service.models.SCascadeQuery
  42. import com.persagy.service.models.requests.SQueryRequest
  43. import com.persagy.service.models.responses.SQueryResponse
  44. import org.slf4j.LoggerFactory
  45. import org.springframework.beans.factory.annotation.Autowired
  46. import java.util.stream.Collectors
  47. /**
  48. * 设备台账任务
  49. *
  50. * @author 邓婷婷
  51. */
  52. object EquipScanTaskQueryService : SObjectService<EquipScanTaskQuery>(SMybatisDao(EquipScanTaskQuery::class.java)) { // Class EquipScanTaskService
  53. /** 字典平台对象类型 */
  54. // private val defClassService = SBaseService(SMybatisDao(DefClass::class.java))
  55. // 日志
  56. private val logger = LoggerFactory.getLogger(EquipScanTaskQueryService::class.java)
  57. @Autowired
  58. private val dmpBaseService: DmpBaseService? = DmpBaseService()
  59. @Autowired
  60. private val admBaseService: AdmBaseService? = AdmBaseService()
  61. fun pageQuerys(request: SQueryRequest): SQueryResponse<EquipScanTaskQuery> {
  62. //查询设备台账任务
  63. val projectId = SPageContext.getHeader("projectId").toString()
  64. val withFilterList = ArrayList<SFilter>()
  65. withFilterList.add(SFilter.eq("projectId", SPageContext.getHeader("projectId").toString()))
  66. withFilterList.add(SFilter.lt(SLength("classCode"), 7))
  67. val pageQuery = pageQuery(request, withFilterList)
  68. if (!pageQuery.content.isNullOrEmpty()&&pageQuery.content!!.size>0){
  69. //级联查询设备相关信息:建筑,楼层,空间等
  70. val equipScanTaskList = pageQuery.content
  71. var cascadeQueryAdmEquip = arrayListOf<Equipment>()
  72. if (equipScanTaskList != null) {
  73. val cascades = ArrayList<SCascadeQuery>()
  74. //级联查询建筑
  75. val buildCacade = SCascadeQuery()
  76. buildCacade.name = "building"
  77. cascades.add(buildCacade)
  78. //级联查询楼层
  79. val floorCacade = SCascadeQuery()
  80. floorCacade.name="floor"
  81. cascades.add(floorCacade)
  82. request.cascade= cascades
  83. cascadeQueryAdmEquip = cascadeQueryAdmEquip(equipScanTaskList, request) as ArrayList<Equipment>
  84. }
  85. val equipMap = cascadeQueryAdmEquip?.stream()?.collect(Collectors.groupingBy { item: Equipment -> item.id })
  86. for (content in pageQuery.content!!){
  87. //设置级联查询结果
  88. val caseNodes = equipMap.get(content.equipId)
  89. if(CollUtil.isNotEmpty(caseNodes)){
  90. val equip = caseNodes?.get(0)
  91. if (equip != null) {
  92. content.building = equip.building
  93. content.floor = equip.floor
  94. /*val component = equip.component
  95. val toAdmMultiEntity = AdmEntityTransferUtil.toAdmMultiEntity(component, null, EquipScanTaskQuery::class.java)
  96. content.component = toAdmMultiEntity*/
  97. }
  98. }
  99. //查询组件
  100. val exec = select(SFilter.eq("parentId", content.equipId!!),SFilter.eq("taskParentId", content.id!!)).exec()
  101. if (exec.size>0){
  102. content.component = exec
  103. }
  104. //查询中台类型数据,2021.10.25日中心中台整合调整
  105. val param = JSONObject()
  106. val criteria = JSONObject()
  107. criteria["code"] = content.classCode!!
  108. param["criteria"] = criteria
  109. val dictTypes =dmpBaseService!!.queryDictType(param)
  110. val defClass = AdmEntityTransferUtil.toAdmMultiEntity(dictTypes, null, DefClass::class.java)
  111. /* val defClass =
  112. defClassService.select(SFilter.eq("projectId", projectId), SFilter.eq("code", content.classCode!!)).entity()*/
  113. if (defClass!=null && defClass.size>0) {
  114. content.equipCategory = defClass.get(0)
  115. }
  116. }
  117. }
  118. return pageQuery
  119. } // Fun
  120. fun pageQueryTwo(request: SQueryRequest): SQueryResponse<EquipScanTaskQuery> {
  121. val projectId = SPageContext.getHeader("projectId").toString()
  122. val withFilterList = ArrayList<SFilter>()
  123. withFilterList.add(SFilter.eq("projectId", SPageContext.getHeader("projectId").toString()))
  124. val pageQuery = pageQuery(request, withFilterList)
  125. if (!pageQuery.content.isNullOrEmpty()&&pageQuery.content!!.size>0){
  126. //级联查询设备相关信息:建筑,楼层,空间等
  127. val equipScanTaskList = pageQuery.content
  128. var cascadeQueryAdmEquip = arrayListOf<Equipment>()
  129. if (equipScanTaskList != null) {
  130. cascadeQueryAdmEquip = cascadeQueryAdmEquip(equipScanTaskList, request) as ArrayList<Equipment>
  131. }
  132. val equipMap = cascadeQueryAdmEquip?.stream()?.collect(Collectors.groupingBy { item: Equipment -> item.id })
  133. for (content in pageQuery.content!!){
  134. //设置级联查询结果
  135. val caseNodes = equipMap.get(content.equipId)
  136. if(CollUtil.isNotEmpty(caseNodes)){
  137. val equip = caseNodes?.get(0)
  138. if (equip != null) {
  139. content.building = equip.building
  140. content.floor = equip.floor
  141. /*val component = equip.component
  142. val toAdmMultiEntity = AdmEntityTransferUtil.toAdmMultiEntity(component, null, EquipScanTaskQuery::class.java)
  143. content.component = toAdmMultiEntity*/
  144. }
  145. }
  146. val exec = select(SFilter.eq("parentId", content.equipId!!),SFilter.eq("taskParentId", content.id!!)).exec()
  147. if (exec.size>0){
  148. content.component = exec
  149. }
  150. //查询中台类型数据,2021.10.25日中心中台整合调整
  151. val param = JSONObject()
  152. val criteria = JSONObject()
  153. criteria["code"] = content.classCode!!
  154. param["criteria"] = criteria
  155. val dictTypes =dmpBaseService!!.queryDictType(param)
  156. val defClass = AdmEntityTransferUtil.toAdmMultiEntity(dictTypes, null, DefClass::class.java)
  157. /* val defClass =
  158. defClassService.select(SFilter.eq("projectId", projectId), SFilter.eq("code", content.classCode!!)).entity()*/
  159. if (defClass!=null && defClass.size>0) {
  160. content.equipCategory = defClass.get(0)
  161. }
  162. }
  163. }
  164. return pageQuery
  165. } // Fun
  166. /**
  167. * 级联查询设备相关信息:建筑,楼层,空间等
  168. */
  169. fun cascadeQueryAdmEquip(equipScanTaskList: List<EquipScanTaskQuery>,request: SQueryRequest): List<Equipment>? {
  170. //级联查询设备相关信息:建筑,楼层,空间等
  171. if(CollUtil.isEmpty(equipScanTaskList)){
  172. return ArrayList<Equipment>()
  173. }
  174. val equipIds = equipScanTaskList?.stream()?.map(EquipScanTaskQuery::equipId)?.collect(Collectors.toList<String>())
  175. var equipRequest = SQueryRequest()
  176. equipRequest.filters = "id in "+"(\'" + java.lang.String.join("\',\'", equipIds) + "\')"
  177. val requestCascade = request.cascade
  178. //查询级联关系
  179. val cascadeList = arrayListOf<SCascadeQuery>()
  180. if (requestCascade != null) {
  181. for(cascade in requestCascade){
  182. if("scanScheme".equals(cascade.name)){
  183. continue
  184. }
  185. cascadeList.add(cascade)
  186. }
  187. equipRequest.cascade = cascadeList;
  188. return admBaseService?.queryEquip(equipRequest)
  189. }
  190. return ArrayList<Equipment>()
  191. }
  192. /**
  193. * 分类统计
  194. */
  195. fun categoryStatistics(projectId:String,id: String,equipId: String): ArrayList<CategoryStatistics>{
  196. val result = ArrayList<CategoryStatistics>()
  197. //查询所有的设备类别
  198. val dictTypeList = dmpBaseService?.queryDictType(JSONObject())
  199. val dictTypeMap = HashMap<String, String>()
  200. if (dictTypeList != null) {
  201. for(dictType in dictTypeList){
  202. dictType.code?.let { dictType.name?.let { it1 -> dictTypeMap.put(it, it1) } }
  203. }
  204. }
  205. //查询设备任务
  206. val request = SQueryRequest()
  207. val withFilterList = ArrayList<SFilter>()
  208. withFilterList.add(SFilter.eq("projectId", projectId))
  209. withFilterList.add(SFilter.eq("taskParentId", id))
  210. withFilterList.add(SFilter.eq("parentId", equipId))
  211. val pageQuery = EquipScanTaskQueryService.pageQuery(request, withFilterList)
  212. val equipScanTask = pageQuery.content
  213. if (!pageQuery.content.isNullOrEmpty()&&pageQuery.content!!.size>0) {
  214. val equipScanTaskMap: Map<String?, List<EquipScanTaskQuery>> = equipScanTask?.stream()
  215. ?.collect(Collectors.groupingBy(EquipScanTaskQuery::classCode)) as Map<String?, List<EquipScanTaskQuery>>
  216. for ((key, value) in equipScanTaskMap.entries) {
  217. val categoryStatistics = CategoryStatistics()
  218. categoryStatistics.code = key
  219. categoryStatistics.name = dictTypeMap.get(key)
  220. categoryStatistics.count = value.size
  221. result.add(categoryStatistics)
  222. }
  223. }
  224. return result
  225. }
  226. }