package cn.flightfeather.supervision.domain.ds1.mapper
|
|
import cn.flightfeather.supervision.domain.ds1.entity.Problemlist
|
import cn.flightfeather.supervision.domain.util.MyMapper
|
import cn.flightfeather.supervision.lightshare.vo.UnChangedPro
|
import org.apache.ibatis.annotations.Mapper
|
import kotlin.reflect.jvm.internal.impl.load.kotlin.JvmType
|
|
@Mapper
|
interface ProblemlistMapper:MyMapper<Problemlist> {
|
|
/**
|
* 获取某时间段内、某个区县的某种场景下,各类型的问题数量统计
|
* @param districtcode 区县行政编码
|
* @param starttime 开始时间
|
* @param endtime 结束时间
|
* @param sceneType 场景类型
|
*/
|
fun getStatisticalResult(districtcode:String?, starttime:String?, endtime:String?, sceneType:String?): List<Map<String, JvmType.Object>>
|
// fun getStatisticalResult(): List<Map<String, JvmType.Object>>
|
|
fun getStatisticalResultById(topTaskId: String?, sceneTypeId: String?): List<Map<String, JvmType.Object>>
|
|
/**
|
* 获取某顶层任务、某场景类型下的问题数及整改数
|
* @param topTaskId 顶层任务主键id
|
* @param sceneType 场景类型id
|
*/
|
fun getChangeResult(topTaskId:String?, sceneType:String?): List<Map<String, JvmType.Object>>
|
|
fun getScoreResult(topTaskId:String?, sceneType:String?): List<Map<String, JvmType.Object>>
|
|
fun selectSE(sql: String): String
|
|
//根据场景id和顶层任务id 获取所有问题
|
fun getProblemByScene(sceneId: String, taskId: String): List<Problemlist>
|
|
|
/**
|
* 通过ID查找 月问题列表
|
*/
|
fun findMonthProblemById(taskId: String,sceneType: Int?): List<Map<String, JvmType.Object?>>
|
|
/**
|
* 通过日任务id查找未整改完成的子任务数,返回的是每个子任务未完成整改的问题数
|
*/
|
fun findUnchangedCount(dayTaskId: String): List<Int>
|
|
/**
|
* 查找问题生成时间在给定时间之前的所有问题
|
*/
|
fun getUnChangedProblem(deadLine: String): List<UnChangedPro>
|
}
|