From 52a0c16de9b0955a5f092560b73f16e41684f97b Mon Sep 17 00:00:00 2001
From: feiyu02 <risaku@163.com>
Date: 星期二, 31 十二月 2024 10:13:35 +0800
Subject: [PATCH] 1. 环信码生成时,如果在线场景当期没有评估(未巡查)结果,则延用历史最新一次的结果; 2. 新增跨时间跨月度的历史整改记录查询逻辑 3. 优化获取顶层任务和日任务的获取逻辑

---
 src/main/kotlin/cn/flightfeather/supervision/lightshare/service/impl/ProblemlistServiceImpl.kt |  241 +++++++++++++++++++++++------------------------
 1 files changed, 118 insertions(+), 123 deletions(-)

diff --git a/src/main/kotlin/cn/flightfeather/supervision/lightshare/service/impl/ProblemlistServiceImpl.kt b/src/main/kotlin/cn/flightfeather/supervision/lightshare/service/impl/ProblemlistServiceImpl.kt
index 5b28608..d33ffe5 100644
--- a/src/main/kotlin/cn/flightfeather/supervision/lightshare/service/impl/ProblemlistServiceImpl.kt
+++ b/src/main/kotlin/cn/flightfeather/supervision/lightshare/service/impl/ProblemlistServiceImpl.kt
@@ -3,13 +3,10 @@
 import cn.flightfeather.supervision.common.exception.BizException
 import cn.flightfeather.supervision.common.log.BizLog
 import cn.flightfeather.supervision.common.log.WorkStreamLogInfo
-import cn.flightfeather.supervision.domain.ds1.entity.Problemlist
-import cn.flightfeather.supervision.domain.ds1.entity.Scense
 import cn.flightfeather.supervision.common.utils.Constant
 import cn.flightfeather.supervision.common.utils.FileUtil
 import cn.flightfeather.supervision.common.utils.UUIDGenerator
-import cn.flightfeather.supervision.domain.ds1.entity.Mediafile
-import cn.flightfeather.supervision.domain.ds1.entity.Subtask
+import cn.flightfeather.supervision.domain.ds1.entity.*
 import cn.flightfeather.supervision.domain.ds1.mapper.*
 import cn.flightfeather.supervision.domain.ds1.repository.ProblemRep
 import cn.flightfeather.supervision.domain.ds1.repository.SubTaskRep
@@ -22,6 +19,7 @@
 import com.fasterxml.jackson.databind.ObjectMapper
 import com.github.pagehelper.PageHelper
 import org.springframework.beans.BeanUtils
+import org.springframework.beans.factory.annotation.Value
 import org.springframework.stereotype.Service
 import org.springframework.web.multipart.MultipartFile
 import tk.mybatis.mapper.entity.Example
@@ -45,6 +43,8 @@
     private val subTaskRep: SubTaskRep,
     private val problemRep: ProblemRep,
     private val bizLog: BizLog,
+    @Value("\${filePath}") var filePath: String,
+    @Value("\${imgPath}") var imgPath: String,
 ) : ProblemlistService {
 
     @Resource
@@ -62,29 +62,29 @@
     @Resource
     lateinit var mediafileService: MediafileService
 
-    override fun getByTopTask(tguid: String): List<ProblemlistVo> {
+    override fun getByTopTask(tguid: String): List<ProblemListVo> {
         TODO("not implemented") //To change body of created functions use File | Settings | File Templates.
     }
 
     //鏍规嵁鍦烘櫙id鍜屾椂闂磋幏鍙栧搴旈《灞備换鍔′笅鐨勬墍鏈夐棶棰�
-    override fun getProblemByScene(sceneId: String, date: String): List<ProblemlistVo> {
+    override fun getProblemByScene(sceneId: String, date: String): List<ProblemListVo> {
         val simpleDateFormat = SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
         val date1 = simpleDateFormat.parse(date)
         val scene = scenseMapper.selectByPrimaryKey(sceneId)
         val district = scene.districtcode
         val taskVolist = taskService.getByDistrictCode(district!!, date1)
-        val problemlistVolistTemp1 = mutableListOf<ProblemlistVo>()
+        val problemListVolistTemp1 = mutableListOf<ProblemListVo>()
         if (!taskVolist.isEmpty()) {
             val problemlists = (problemlistMapper.getProblemByScene(sceneId, taskVolist[0].tguid!!))
             problemlists.forEach {
                 // 闄愬埗浼佷笟鏌ョ湅鏈鏍哥殑闂
                 if (it.extension3 != Constant.PROBLEM_UNCHECKED && it.extension3 != Constant.PROBLEM_CHECK_FAIL) {
-                    val problemVo = ProblemlistVo();
+                    val problemVo = ProblemListVo();
                     BeanUtils.copyProperties(it, problemVo)
-                    problemlistVolistTemp1.add(problemVo)
+                    problemListVolistTemp1.add(problemVo)
                 }
             }
-            problemlistVolistTemp1.forEach {
+            problemListVolistTemp1.forEach {
                 if (it.ptguid != null) {
                     val tmp1 = problemtypeMapper.selectByPrimaryKey(it.ptguid)
                     if (tmp1 != null) {
@@ -102,7 +102,7 @@
                 }
             }
         }
-        return problemlistVolistTemp1
+        return problemListVolistTemp1
     }
 
     //鑾峰彇鏌愰《灞備换鍔′笅锛屾煇涓満鏅笅鐨勯棶棰樻暣鏀规儏鍐�
@@ -130,11 +130,11 @@
 
     //鏍规嵁鍖哄幙銆佸満鏅被鍨嬨�佹椂闂磋幏鍙栧悇涓棶棰樻暟閲�
     override fun getStatisticalResult(areaVo: AreaVo): List<StatisticsVo> {
-        val districtcode = areaVo.districtcode
-        val sceneType = areaVo.scensetypeid
-        val startTime = areaVo.starttime?.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"))
-        val endTime = areaVo.endtime?.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"))
-        return problemlistMapper.getStatisticalResult(districtcode, startTime, endTime, sceneType, areaVo.sceneId)
+//        val districtcode = areaVo.districtcode
+//        val sceneType = areaVo.scensetypeid
+//        val startTime = areaVo.starttime?.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"))
+//        val endTime = areaVo.endtime?.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"))
+        return problemlistMapper.getStatisticalResult(areaVo)
     }
 
     override fun getChargeResult(areaVo: AreaVo): ChargeInfoVo {
@@ -213,8 +213,8 @@
     }
 
     //鏍规嵁鍦板煙鑾峰彇闂
-    override fun getByArea(areaVo: AreaVo): List<ProblemlistVo> {
-        val problemlist = mutableListOf<ProblemlistVo>()
+    override fun getByArea(areaVo: AreaVo): List<ProblemListVo> {
+        val problemlist = mutableListOf<ProblemListVo>()
 //        val tmpproblemlsit = mutableListOf<Problemlist>()
         val example = Example(Scense::class.java)
         val criteria = example.createCriteria()
@@ -238,7 +238,7 @@
                 tmpcriteria.andBetween("time", areaVo.starttime, areaVo.endtime)
                 val tmp = problemlistMapper.selectByExample(tmpexample)
                 tmp.forEach {
-                    val problem = ProblemlistVo();
+                    val problem = ProblemListVo();
                     BeanUtils.copyProperties(it, problem)
                     problemlist.add(problem)
                 }
@@ -258,47 +258,47 @@
     }
 
     //鏍规嵁宸℃煡ID鑾峰彇闂
-    override fun findByInspectionID(inspectionID: String): List<ProblemlistVo> {
-        val problemlistVoList = mutableListOf<ProblemlistVo>()
+    override fun findByInspectionID(inspectionID: String): List<ProblemListVo> {
+        val problemListVoList = mutableListOf<ProblemListVo>()
         val problemlist = Problemlist()
         problemlist.iguid = inspectionID
         val problemlists = problemlistMapper.select(problemlist)
         problemlists.forEach {
-            val problemlistVo = ProblemlistVo()
+            val problemlistVo = ProblemListVo()
             if (it.remark != Constant.PROBLEM_DELETED) {
                 BeanUtils.copyProperties(it, problemlistVo)
-                problemlistVoList.add(problemlistVo)
+                problemListVoList.add(problemlistVo)
             }
         }
         //鎺掑簭
-        problemlistVoList.sortBy { it.time }
-        return problemlistVoList
+        problemListVoList.sortBy { it.time }
+        return problemListVoList
     }
 
     //鏂板涓�涓棶棰�
-    override fun addProblem(problemlistVo: ProblemlistVo) {
+    override fun addProblem(problemlistVo: ProblemListVo) {
         val probemlist = Problemlist()
         BeanUtils.copyProperties(problemlistVo, probemlist)
         problemlistMapper.insert(probemlist)
     }
 
     //鏍规嵁瀛愪换鍔D鏌ヨ闂
-    override fun findBySubtaskId(subTaskID: String): List<ProblemlistVo> {
-        val problemlistVoList = mutableListOf<ProblemlistVo>()
+    override fun findBySubtaskId(subTaskID: String): List<ProblemListVo> {
+        val problemListVoList = mutableListOf<ProblemListVo>()
         val problemlist = Problemlist()
         problemlist.stguid = subTaskID
         val problemlists = problemlistMapper.select(problemlist)
         problemlists.forEach {
-            val problemlistVo = ProblemlistVo()
+            val problemlistVo = ProblemListVo()
             BeanUtils.copyProperties(it, problemlistVo)
-            problemlistVoList.add(problemlistVo)
+            problemListVoList.add(problemlistVo)
         }
-        return problemlistVoList
+        return problemListVoList
     }
 
     //鏍规嵁闂ID鑾峰彇涓�涓棶棰�
-    override fun findByID(id: String): ProblemlistVo {
-        val problemlistVo = ProblemlistVo()
+    override fun findByID(id: String): ProblemListVo {
+        val problemlistVo = ProblemListVo()
         val problemlist = problemlistMapper.selectByPrimaryKey(id)
         if (problemlist != null) {
             BeanUtils.copyProperties(problemlist, problemlistVo)
@@ -373,7 +373,7 @@
         userId: String,
         userName: String,
     ): BaseResponse<String> {
-        if (action !in 0..3) {
+        if (action !in 0..5) {
             return BaseResponse(false, "闈炴硶鐨勬搷浣滄寚浠�")
         }
         val p = problemlistMapper.selectByPrimaryKey(pId) ?: return BaseResponse(false, "闂涓嶅瓨鍦�")
@@ -398,6 +398,14 @@
                         response.success = false
                         response.message = "闂鎻愪氦杩樻湭瀹℃牳锛屾棤娉曡繘琛屾暣鏀瑰鏍革紒"
                     }
+                    4.toByte() -> {
+                        response.success = false
+                        response.message = "闂鎻愪氦杩樻湭瀹℃牳锛屾棤娉曡繘琛屾挙鍥炲鏍革紒"
+                    }
+                    5.toByte() -> {
+                        response.success = false
+                        response.message = "闂鏁存敼杩樻湭鎻愪氦锛屾棤娉曡繘琛屾挙鍥炲鏍革紒"
+                    }
                 }
             } else if (extension3 == Constant.PROBLEM_CHECK_PASS || extension3 == Constant.PROBLEM_CHECK_FAIL) {
                 when (action) {
@@ -419,6 +427,13 @@
                             response.message = "闂杩樻湭鏁存敼锛屾棤娉曡繘琛屾暣鏀瑰鏍革紒鎿嶄綔鏃犳晥"
                         }
                     }
+                    4.toByte() -> {
+                        extension3 = Constant.PROBLEM_UNCHECKED
+                    }
+                    5.toByte() -> {
+                        response.success = false
+                        response.message = "闂鏁存敼杩樻湭瀹℃牳锛屾棤娉曡繘琛屾暣鏀瑰鏍告挙鍥炴搷浣滐紒鎿嶄綔鏃犳晥"
+                    }
                 }
             } else if (extension3 == Constant.CHANGE_UNCHECKED) {
                 event = "鍦�${subtask?.scensename}瀹℃牳浜嗕竴涓暣鏀�"
@@ -431,6 +446,14 @@
                     }
                     2.toByte() -> extension3 = Constant.CHANGE_CHECK_PASS
                     3.toByte() -> extension3 = Constant.CHANGE_CHECK_FAIL
+                    4.toByte() -> {
+                        response.success = false
+                        response.message = "闂鏁存敼杩樻湭瀹℃牳锛屾棤娉曡繘琛屾挙鍥炲鏍革紒"
+                    }
+                    5.toByte() -> {
+                        response.success = false
+                        response.message = "闂鎻愪氦宸插鏍革紝骞朵笖宸茶鏁存敼銆傛搷浣滄棤鏁�"
+                    }
                 }
             } else if (extension3 == Constant.CHANGE_CHECK_PASS || extension3 == Constant.CHANGE_CHECK_FAIL) {
                 when (action) {
@@ -442,6 +465,13 @@
                     }
                     2.toByte() -> extension3 = Constant.CHANGE_CHECK_PASS
                     3.toByte() -> extension3 = Constant.CHANGE_CHECK_FAIL
+                    4.toByte() -> {
+                        response.success = false
+                        response.message = "闂鎻愪氦宸插鏍革紝骞朵笖宸茶鏁存敼锛屾棤娉曡繘琛岄棶棰樺鏍告挙閿�鎿嶄綔銆傛搷浣滄棤鏁�"
+                    }
+                    5.toByte() -> {
+                        extension3 = Constant.CHANGE_UNCHECKED
+                    }
                 }
             }
         }
@@ -452,79 +482,24 @@
                 response.success = false
                 response.message = "闂鏇存柊澶辫触锛�"
             } else {
-                bizLog.info(WorkStreamLogInfo(subtask?.executorguids, subtask?.executorrealtimes, event))
+                bizLog.info(WorkStreamLogInfo(userId, userName, event))
             }
         }
         return response
     }
 
     override fun newProblem(problem: String, files: Array<MultipartFile>): BaseResponse<String> {
-        val mapper = ObjectMapper()
-
         //json杞琽bject
-        val problemVo = mapper.readValue(problem, object : TypeReference<ProblemVo>() {})
+        val problemVo = ObjectMapper().readValue(problem, object : TypeReference<ProblemVo>() {})
 
-        // 淇濆瓨闂
         val inspection = inspectionMapper.selectByPrimaryKey(problemVo.insGuid) ?: return BaseResponse(false, "宸℃煡璁板綍涓嶅瓨鍦�")
         val scene = scenseMapper.selectByPrimaryKey(inspection.sguid) ?: return BaseResponse(false, "宸℃煡璁板綍瀵瑰簲鍦烘櫙涓嶅瓨鍦�")
-
-        val problemlist = Problemlist().apply {
-            guid = UUIDGenerator.generate16ShortUUID()
-            iguid = inspection.guid
-            stguid = inspection.stguid
-            sguid = inspection.sguid
-            sensename = inspection.scensename
-            senseaddress = inspection.scenseaddress
-            ptguid = problemVo.ptGuid
-            problemname = problemVo.proName
-            longitude = problemVo.longitude ?: scene.longitude
-            latitude = problemVo.latitude ?: scene.latitude
-            locationid = problemVo.locationId
-            location = problemVo.location
-            time = Date()
-            isrechecked = false
-            ischanged = false
-            advise = problemVo.advice
-            extension3 = Constant.PROBLEM_UNCHECKED
-        }
+        // 淇濆瓨闂
+        val problemlist = ProblemListVo.newPro(inspection, problemVo, scene)
         problemlistMapper.insert(problemlist)
 
         // 淇濆瓨鍥剧墖
-        val now = LocalDateTime.now()
-        for (image in files) {
-            val mediaFile = Mediafile().apply {
-                guid = UUIDGenerator.generate16ShortUUID()
-                iguid = inspection.guid
-                businessguid = problemlist.guid
-                longitude = problemlist.longitude
-                latitude = problemlist.latitude
-                address = problemlist.senseaddress
-                filetype = 1
-                businesstype = "闂"
-                businesstypeid = 1
-                path =
-                    "FlightFeather/Photo/" + scene.districtname + "/" + now.year + "骞�" + now.monthValue + "鏈�/" + now.monthValue + "鏈�" + now.dayOfMonth + "鏃�/" + scene.name + "/"
-                description =
-                    problemlist.problemname + " " + problemlist.location + " " + UUIDGenerator.generateUUID(4) + ".jpg"
-                savetime = Date()
-                ischanged = false
-                extension1 =
-                    scene.citycode + "/" + scene.districtcode + "/" + now.format(DateTimeFormatter.ofPattern("yyyy-MM-dd")) + "/" + scene.guid + "/"
-                remark = "宸蹭笂浼�"
-            }
-            mediafileMapper.insert(mediaFile)
-
-            val path = mediaFile.extension1
-            val fileName = mediaFile.guid + ".jpg"
-//            val filePath = "E:\\work\\绗笁鏂圭洃绠pp\\鑷姩璇勫垎\\椁愰ギ\\"
-            val filePath = "${Constant.DEFAULT_FILE_PATH}/images/$path/"
-            try {
-                //璋冪敤鏂囦欢淇濆瓨鏂规硶
-                FileUtil.uploadFile(image.bytes, filePath, fileName)
-            } catch (e: Exception) {
-                // TODO: handle exception
-            }
-        }
+        mediafileService.saveMediaFile(files) { MediaFileVo.newProFile(inspection, problemlist, scene) }
 
         //鏇存柊宸℃煡淇℃伅鐨勯棶棰樻暟
         if (inspection.problemcount != null) {
@@ -541,9 +516,28 @@
         return BaseResponse(true)
     }
 
+    override fun updateProblem(problem: ProblemListVo, deleteImg: List<String>, files: Array<MultipartFile>): String {
+        problemRep.findOne(problem.guid) ?: throw BizException("璇ラ棶棰樹笉瀛樺湪")
+        problemRep.update(problem)
+        val inspection = inspectionMapper.selectByPrimaryKey(problem.iguid) ?: throw BizException("宸℃煡璁板綍涓嶅瓨鍦�")
+        val scene = scenseMapper.selectByPrimaryKey(inspection.sguid) ?: throw BizException("宸℃煡璁板綍瀵瑰簲鍦烘櫙涓嶅瓨鍦�")
+        mediafileService.saveMediaFile(files) { MediaFileVo.newProFile(inspection, problem, scene) }
+        mediafileService.deleteList(deleteImg)
+        return "success"
+    }
+
+
     override fun changeProblem(problemId: String, files: Array<MultipartFile>): BaseResponse<String> {
-        // 鏇存柊闂
+        // 闂鍜岄棶棰樺浘鐗囧悎娉曟�ф鏌�
         val p = problemlistMapper.selectByPrimaryKey(problemId) ?: return BaseResponse(false, "闂涓嶅瓨鍦�")
+        val mediaFiles = mediafileMapper.selectByExample(Example(Mediafile::class.java).apply {
+            createCriteria().andEqualTo("businessguid", p.guid)
+                .andEqualTo("businesstypeid", 1)
+                .andEqualTo("ischanged", false)
+        })
+        if (mediaFiles.isEmpty()) return BaseResponse(false, "闂涓嶅瓨鍦ㄦ垨宸叉暣鏀癸紝鏃犳硶閲嶅鏁存敼")
+
+        // 鏇存柊闂
         p.apply {
             ischanged = true
             changedtime = Date()
@@ -562,44 +556,46 @@
         }
         problemlistMapper.updateByPrimaryKey(p)
 
-        // 淇濆瓨鍥剧墖
-        val now = LocalDateTime.now()
-        val mediaFiles = mediafileMapper.selectByExample(Example(Mediafile::class.java).apply {
-            createCriteria().andEqualTo("businessguid", p.guid)
-                .andEqualTo("businesstypeid", 1)
-                .andEqualTo("ischanged", false)
-        })
-        if (mediaFiles.isEmpty()) return BaseResponse(false, "鍦烘櫙闂鏁伴噺涓�0锛屾棤娉曟暣鏀�")
+        // 淇濆瓨鏁存敼鍥剧墖
         val m = mediaFiles[0]
         m.path = m.path + "鏁存敼/"
         m.savetime = Date()
         m.ischanged = true
-
-        for (image in files) {
+        mediafileService.saveMediaFile(files) {
             m.apply {
                 guid = UUIDGenerator.generate16ShortUUID()
                 description = p.problemname + " " + p.location + " 鏁存敼 " + UUIDGenerator.generateUUID(4) + ".jpg"
-            }
-            mediafileMapper.insert(m)
-
-            val path = m.extension1
-            val fileName = m.guid + ".jpg"
-//            val filePath = "E:\\work\\绗笁鏂圭洃绠pp\\鑷姩璇勫垎\\椁愰ギ\\"
-            val filePath = "${Constant.DEFAULT_FILE_PATH}/images/$path"
-            try {
-                //璋冪敤鏂囦欢淇濆瓨鏂规硶
-                FileUtil.uploadFile(image.bytes, filePath, fileName)
-            } catch (e: Exception) {
-                println(e)
             }
         }
 
         return BaseResponse(true)
     }
 
-    override fun getBySubTask(stGuid: String, all: Boolean?): List<ProblemlistVo> {
+    override fun updateChange(problemId: String, deleteImg: List<String>, files: Array<MultipartFile>): String {
+        val p = problemRep.findOne(problemId) ?: throw BizException("璇ラ棶棰樹笉瀛樺湪")
+        val mediaFiles = mediafileMapper.selectByExample(Example(Mediafile::class.java).apply {
+            createCriteria().andEqualTo("businessguid", problemId)
+                .andEqualTo("businesstypeid", 1)
+                .andEqualTo("ischanged", true)
+        })
+        if (mediaFiles.isEmpty()) throw BizException("闂杩樻湭鏁存敼锛屾棤娉曚慨鏀规暣鏀�")
+
+        // 淇濆瓨鏂扮殑鏁存敼鍥剧墖
+        val m = mediaFiles[0]
+        m.savetime = Date()
+        mediafileService.saveMediaFile(files) {
+            m.apply {
+                guid = UUIDGenerator.generate16ShortUUID()
+                description = p.problemname + " " + p.location + " 鏁存敼 " + UUIDGenerator.generateUUID(4) + ".jpg"
+            }
+        }
+        mediafileService.deleteList(deleteImg)
+        return "success"
+    }
+
+    override fun getBySubTask(stGuid: String, all: Boolean?): List<ProblemListVo> {
         //鏍规嵁瀛愪换鍔D鑾峰彇闂鍒楄〃
-        val problemListVo = mutableListOf<ProblemlistVo>()
+        val problemListVo = mutableListOf<ProblemListVo>()
         if (all == false) {
             //鍘婚櫎鏈鏍镐互鍙婂鏍镐笉閫氳繃鐨勯棶棰�
             findBySubtaskId(stGuid).forEach {
@@ -630,14 +626,13 @@
 
     override fun getSceneProSummary(
         areaVo: AreaVo,
-        sortBy: String,
         page: Int,
         per_page: Int,
     ): Pair<DataHead?, List<SceneProblemSummary>?> {
-        areaVo.scensetypeid ?: throw BizException("缂哄皯鍦烘櫙绫诲瀷鍙傛暟")
-        val task = taskRep.findOneTask(areaVo) ?: throw BizException("鏈壘鍒板搴旂殑宸℃煡鎬讳换鍔�")
+//        areaVo.scensetypeid ?: throw BizException("缂哄皯鍦烘櫙绫诲瀷鍙傛暟")
+//        val task = taskRep.findOneTask(areaVo) ?: throw BizException("鏈壘鍒板搴旂殑宸℃煡鎬讳换鍔�")
         val p = PageHelper.startPage<SceneProblemSummary>(page, per_page)
-        val res = problemRep.getSceneProSummary(task.tguid!!, areaVo.scensetypeid!!, areaVo.sort, sortBy)
+        val res = problemRep.selectSceneProSummary(areaVo)
         return DataHead(p.pageNum, p.pages, p.total) to res
     }
 }
\ No newline at end of file

--
Gitblit v1.9.3