/* * ********************************************************************************************************************* * * !! * .F88X * X8888Y * .}888888N; * i888888N; .:! .I$WI: * R888888I .'N88~ i8}+8Y&8"l8i$8>8W~'>W8}8]KW+8IIN"8& * .R888888I .;N8888~ .X8' "8I.!,/8" !%NY8`"8I8~~8>,88I * +888888N; .8888888Y "&&8Y.}8, * ./888888N; .R888888Y .'}~ .>}'.`+> i}! "i' +/' .'i~ !11,.:">, .~]! .i}i * ~888888%: .I888888l .]88~`1/iY88Ii+1'.R$8$8]"888888888> Y8$ W8E X8E W8888'188Il}Y88$* * 18888888 E8888881 .]W%8$`R8X'&8%++N8i,8N%N8+l8%` .}8N:.R$RE%N88N%N$K$R 188,FE$8%~Y88I * .E888888I .i8888888' .:$8I;88+`E8R:/8N,.>881.`$8E/1/]N8X.Y8N`"KF&&FK!'88*."88K./$88%RN888+~ * 8888888I .,N888888~ ~88i"8W,!N8*.I88.}888%F,i$88"F88" 888:E8X.>88!i88>`888*.}Fl1]*}1YKi' * i888888N' I888Y ]88;/EX*IFKFK88X K8R .l8W 88Y ~88}'88E&%8W.X8N``]88!.$8K .:W8I * .i888888N; I8Y .&8$ .X88! i881.:%888>I88 ;88] +88+.';;;;:.Y88X 18N.,88l .+88/ * .:R888888I * .&888888I Copyright (c) 2009-2020. 博锐尚格科技股份有限公司 * ~8888' * .!88~ All rights reserved. * * ********************************************************************************************************************* */ package com.persagy.server.services.task import com.alibaba.fastjson.JSONObject import com.persagy.database.SFilter import com.persagy.database.SPageQueryInfo import com.persagy.mybatis.SMybatisDao import com.persagy.server.datacenter.models.entities.objects.Building import com.persagy.server.datacenter.models.entities.task.* import com.persagy.server.datacenter.models.entities.task.base.ScanTaskBase import com.persagy.server.mappers.StatisticsCountMapper import com.persagy.server.services.AdmBaseService import com.persagy.server.services.DmpBaseService import com.persagy.server.services.StatisticsCountService import com.persagy.server.services.base.RService import com.persagy.server.util.AdmEntityTransferUtil import com.persagy.service.SPageContext import com.persagy.service.models.SCascadeQuery import com.persagy.service.models.enums.SResponseType import com.persagy.service.models.requests.SQueryRequest import com.persagy.service.models.responses.SQueryResponse import com.persagy.service.utils.SSpringContextUtil import org.springframework.beans.factory.annotation.Autowired /** * 任务父表 * * @author 邓婷婷 */ object ScanTaskBaseService : RService(SMybatisDao(ScanTaskBase::class.java)) { /** 实例化 mapper 对象 */ val mapper by lazy { SSpringContextUtil.getBean(StatisticsCountMapper::class.java) as StatisticsCountMapper } @Autowired private val dmpBaseService: DmpBaseService? = DmpBaseService() @Autowired private val admBaseService: AdmBaseService? = AdmBaseService() @Autowired private val statisticsCountService: StatisticsCountService? = StatisticsCountService() /** * 查询所有设备类型或设备族 */ fun equipCategoryQuery(type: String): SQueryResponse { val sQueryResponse = SQueryResponse(SResponseType.success) var request = SQueryRequest() request.filters = "ProjectId = '${SPageContext.getHeader("ProjectId")}'"; request.projection = arrayListOf("classCode") request.distinct = true val tasks = ArrayList() //查询设备,资产,模型文件现有的数据 if(type == "equip") { // 如果是equip val response = EquipScanTaskService.pageQuery(request, null) tasks.addAll(response.content!!) } else if(type == "property") { // 如果是property val response = PropertyScanTaskService.pageQuery(request, null) tasks.addAll(response.content!!) } else if(type == "model") { // 如果是model val response = ModelScanTaskService.pageQuery(request, null) tasks.addAll(response.content!!) } //查询中台类型数据 val param = JSONObject() val criteria = JSONObject() if ("equip" == type) { val objTypes = JSONObject() val objTypeList: MutableList = java.util.ArrayList() objTypeList.add("equipment") objTypeList.add("component") objTypes["\$in"] = objTypeList }else{ criteria["objType"] = type } param["criteria"] = criteria val queryDictType = dmpBaseService!!.queryDictType(param) if(queryDictType == null || queryDictType.size<=0){ return sQueryResponse } val queryDictMap = HashMap() for (dict in queryDictType){ dict.code?.let { dict.name?.let { it1 -> queryDictMap.put(it, it1) } } } //结果集封装 val equipCategoryList = ArrayList() for(task in tasks!!){ val equipCategoryDic = EquipCategoryDic() equipCategoryDic.code = task.classCode if(queryDictMap.get(task.classCode) == null){ continue } equipCategoryDic.name = queryDictMap.get(task.classCode) equipCategoryList.add(equipCategoryDic) } //历史逻辑: /*val pageQuery: SPageQueryInfo return try { val equipCategoryDicService = SBaseService(SMybatisDao(EquipCategoryDic::class.java)) var request = SQueryRequest() val queryBuilder = equipCategoryDicService.select(request.filters) val projectId = SPageContext.getHeader("projectId").toString() queryBuilder.tableName = "scantask.f_get_category('$type','$projectId')" pageQuery = queryBuilder.pageQuery(1, 1000) SQueryResponse(pageQuery) } catch (e: Exception) { e.printStackTrace() SQueryResponse(SResponseType.failure, e.message!!) }*/ sQueryResponse.content = equipCategoryList return sQueryResponse } /** * 查询所有建筑和楼层 */ fun buildingQuery(type: String): SQueryResponse { val pageQuery = SPageQueryInfo(1, 1000) return try { val projectId = SPageContext.getHeader("projectId").toString() var request = SQueryRequest() request.filters = "not buildingId isnull ; not floorId isnull"; request.projection = arrayListOf("buildingId", "floorId") request.distinct = true val tasks = ArrayList() if(type == "equip") { // 如果是equip val response = EquipScanTaskService.pageQuery(request, null) tasks.addAll(response.content!!) } else if(type == "property") { // 如果是property val response = PropertyScanTaskService.pageQuery(request, null) tasks.addAll(response.content!!) } else if(type == "model") { // 如果是model val response = ModelScanTaskService.pageQuery(request, null) tasks.addAll(response.content!!) } val resultList = ArrayList() pageQuery.content = resultList if(tasks!!.isNotEmpty()) { // 转换为> val builds = tasks.map { it.buildingId } val floors = tasks.map { it.floorId } var buildingRequest = SQueryRequest() // buildingRequest.filters = "id in (" +builds!!.joinToString(",", ",", "'").substring(1) + ")" buildingRequest.filters = "id in "+"(\'" + java.lang.String.join("\',\'", builds) + "\')" buildingRequest.pageSize = 1000 buildingRequest.pageNumber = 1 var cascade = SCascadeQuery() cascade.name = "floor" //cascade.filters = "id in (" +floors!!.joinToString(",", ",", "'").substring(1) + ")" cascade.filters = "id in "+"(\'" + java.lang.String.join("\',\'", floors) + "\')" buildingRequest.cascade = arrayListOf(cascade) //调用adm-middleware建筑查询接口 val buildingList = admBaseService?.queryBuilding(buildingRequest) as ArrayList? //转换为BuildingDic val buildingDicList = AdmEntityTransferUtil.toAdmMultiEntity(buildingList, null, BuildingDic::class.java) pageQuery.content = buildingDicList as ArrayList? } // val queryBuilder = service.select(request.filters) // queryBuilder.tableName = "scantask.f_get_building_dic('$type','$projectId')" // pageQuery = queryBuilder.pageQuery(1, 1000) if (pageQuery.content!!.size>0){ // for(floor in resultList!!){ // if(floor.floorListStr != null){ // val listStr = floor.floorListStr!!.replace("/\\","") // val newStr = "["+listStr.substring(1,listStr.length-1)+"]" // val type = object : TypeToken>() { // }.type // val siInSpList = gson.fromJson>(newStr, type) // floor.floor = siInSpList // floor.floorListStr = null // } // } if (type == "equip"||type == "property"){ var taskSource: String if (type == "equip"){ taskSource = "2" }else { taskSource = "3" } /** 处理楼层是否有未明确楼层 */ for(building in pageQuery.content!!){ if (building.floor!=null&&building.floor!!.size>0){ val equipScanTaskList = select( SFilter.eq("projectId", projectId), SFilter.eq("buildingId", building.id!!), SFilter.isNull("floorId"),SFilter.eq("taskSource", taskSource)).exec() if (equipScanTaskList.size>0){ val floorDic = FloorDic() floorDic.localName = "未明确楼层" building.floor!!.add(0,floorDic) } }else{ val equipScanTaskList = select(SFilter.eq("projectId", projectId), SFilter.eq("buildingId", building.id!!), SFilter.isNull("floorId"),SFilter.eq("taskSource", taskSource)).exec() if (equipScanTaskList.size>0){ val list = ArrayList() val floorDic = FloorDic() floorDic.localName = "未明确楼层" list.add(floorDic) building.floor= list } } } /** 未明确建筑 */ val equipScanTaskList = select(SFilter.eq("projectId", projectId), SFilter.isNull("buildingId"),SFilter.eq("taskSource", taskSource)).exec() if (equipScanTaskList.size>0){ val buildingDic = BuildingDic() buildingDic.localName = "未明确建筑" pageQuery.content!!.add(0,buildingDic) } } }else{ if (type == "equip"||type == "property") { var taskSource: String if (type == "equip") { taskSource = "2" } else { taskSource = "3" } val equipScanTaskList = select(SFilter.eq("projectId", projectId), SFilter.isNull("buildingId") ,SFilter.eq("taskSource", taskSource)).exec() if (equipScanTaskList.size > 0) { val list = ArrayList() val buildingDic = BuildingDic() buildingDic.localName = "未明确建筑" list.add(buildingDic) pageQuery.content = list } } } SQueryResponse(pageQuery) } catch (e: Exception) { e.printStackTrace() SQueryResponse(SResponseType.failure, e.message!!) } } // Fun modelFileQuery /** * 统计设备下部件的类型以及数量 */ fun categoryCounts(equipScanTask: EquipScanTask): SQueryResponse{ try { val projectId = SPageContext.getHeader("projectId").toString() if (!equipScanTask.id.isNullOrEmpty()&&!equipScanTask.equipId.isNullOrEmpty()){ val categoryStatistics = statisticsCountService?.categoryStatistics(projectId,equipScanTask.id!!, equipScanTask.equipId!!) val sQueryResponse = SQueryResponse() sQueryResponse.total = categoryStatistics?.size?.toLong() sQueryResponse.content = categoryStatistics sQueryResponse.result = SResponseType.success return sQueryResponse }else{ val sQueryResponse = SQueryResponse(SResponseType.failure) sQueryResponse.message = "入参错误" return sQueryResponse } } catch (e: Exception) { e.printStackTrace() return SQueryResponse(SResponseType.failure,e.message.toString()) } } // Fun /** * 统计设备下部件的类型以及数量 */ fun categoryCountsModel(type: String?,equipScanTask: ModelScanTask): SQueryResponse{ try { val projectId = SPageContext.getHeader("projectId") if (!equipScanTask.id.isNullOrEmpty()&&!equipScanTask.equipId.isNullOrEmpty()){ if (!type.isNullOrEmpty()&&type == "model"){ val categoryStatistics = statisticsCountService?.categoryStatisticsModel(projectId!!,equipScanTask.id!!, equipScanTask.equipId!!) val sQueryResponse = SQueryResponse() sQueryResponse.total = categoryStatistics?.size?.toLong() sQueryResponse.content = categoryStatistics sQueryResponse.result = SResponseType.success return sQueryResponse }else{ val categoryStatistics = statisticsCountService?.categoryStatistics(projectId!!,equipScanTask.id!!, equipScanTask.equipId!!) val sQueryResponse = SQueryResponse() sQueryResponse.total = categoryStatistics?.size?.toLong() sQueryResponse.content = categoryStatistics sQueryResponse.result = SResponseType.success return sQueryResponse } }else{ val sQueryResponse = SQueryResponse(SResponseType.failure) sQueryResponse.message = "入参错误" return sQueryResponse } } catch (e: Exception) { e.printStackTrace() return SQueryResponse(SResponseType.failure,e.message.toString()) } } // Fun } // Fun