123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343 |
- /*
- * *********************************************************************************************************************
- *
- * !!
- * .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<ScanTaskBase>(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<EquipCategoryDic> {
- val sQueryResponse = SQueryResponse<EquipCategoryDic>(SResponseType.success)
- var request = SQueryRequest()
- request.filters = "ProjectId = '${SPageContext.getHeader("ProjectId")}'";
- request.projection = arrayListOf("classCode")
- request.distinct = true
- val tasks = ArrayList<ScanTaskBase>()
- //查询设备,资产,模型文件现有的数据
- 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<String> = 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<String, String>()
- for (dict in queryDictType){
- dict.code?.let { dict.name?.let { it1 -> queryDictMap.put(it, it1) } }
- }
- //结果集封装
- val equipCategoryList = ArrayList<EquipCategoryDic>()
- 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<EquipCategoryDic>
- 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<BuildingDic> {
- val pageQuery = SPageQueryInfo<BuildingDic>(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<ScanTaskBase>()
- 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<BuildingDic>()
- pageQuery.content = resultList
- if(tasks!!.isNotEmpty()) {
- // 转换为<buildId, List<floorId>>
- 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<Building>?
- //转换为BuildingDic
- val buildingDicList = AdmEntityTransferUtil.toAdmMultiEntity(buildingList, null, BuildingDic::class.java)
- pageQuery.content = buildingDicList as ArrayList<BuildingDic>?
- }
- // 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<ArrayList<FloorDic>>() {
- // }.type
- // val siInSpList = gson.fromJson<ArrayList<FloorDic>>(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<FloorDic>()
- 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<BuildingDic>()
- 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<CategoryStatistics>{
- 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<CategoryStatistics>()
- sQueryResponse.total = categoryStatistics?.size?.toLong()
- sQueryResponse.content = categoryStatistics
- sQueryResponse.result = SResponseType.success
- return sQueryResponse
- }else{
- val sQueryResponse = SQueryResponse<CategoryStatistics>(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<CategoryStatistics>{
- 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<CategoryStatistics>()
- 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<CategoryStatistics>()
- sQueryResponse.total = categoryStatistics?.size?.toLong()
- sQueryResponse.content = categoryStatistics
- sQueryResponse.result = SResponseType.success
- return sQueryResponse
- }
- }else{
- val sQueryResponse = SQueryResponse<CategoryStatistics>(SResponseType.failure)
- sQueryResponse.message = "入参错误"
- return sQueryResponse
- }
- } catch (e: Exception) {
- e.printStackTrace()
- return SQueryResponse(SResponseType.failure,e.message.toString())
- }
- } // Fun
- } // Fun
|