| | |
| | | override fun getStatisticalResult(areaVo: AreaVo): List<StatisticsVo> { |
| | | val districtcode = areaVo.districtcode |
| | | val sceneType = areaVo.scensetypeid |
| | | val startTime = areaVo.starttime |
| | | val endTime = areaVo.endtime |
| | | 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")) |
| | | val maps = problemlistMapper.getStatisticalResult(districtcode,startTime, endTime, sceneType) |
| | | val statisticsVos = mutableListOf<StatisticsVo>() |
| | | maps.forEach { |
| | |
| | | // .andGreaterThanOrEqualTo("endtime", areaVo.endtime) |
| | | // .andEqualTo("districtcode", areaVo.districtcode) |
| | | val chargeInfoVo = ChargeInfoVo() |
| | | val sql = "select T_GUID, T_Name from tm_t_task where TS_GUID IS NULL and T_StartTime <= '" + areaVo.starttime + "' and T_EndTime >= '" + areaVo.endtime + "' and T_DistrictCode = '" + areaVo.districtcode +"'" |
| | | val sTime = areaVo.starttime?.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")) |
| | | val eTime = areaVo.endtime?.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")) |
| | | val sql = |
| | | "select T_GUID, T_Name from tm_t_task where TS_GUID IS NULL and T_StartTime <= '" + sTime + "' and T_EndTime" + |
| | | " >= '" + eTime + "' and T_DistrictCode = '" + areaVo.districtcode + "'" |
| | | |
| | | val maps1 = taskMapper.selectSE(sql) |
| | | var topTaskId = String() |
| | | var topTaskName = String() |