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.SceneProblemSummary
|
import cn.flightfeather.supervision.lightshare.vo.StatisticsVo
|
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?,
|
sceneId: String?,
|
): List<StatisticsVo>
|
|
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>
|
|
/**
|
* 获取总任务
|
*/
|
fun getSceneProSummary(
|
topTaskId: String,
|
sceneTypeId: String?,
|
sort: String?,
|
sortBy: String,
|
): List<SceneProblemSummary>
|
}
|
