diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmDeviceController.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmDeviceController.java new file mode 100644 index 0000000..d14a081 --- /dev/null +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmDeviceController.java @@ -0,0 +1,125 @@ +package com.casic.missiles.modular.alarm.controller; + + +import cn.hutool.core.lang.Assert; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.casic.missiles.core.application.context.AbstractPermissionContext; +import com.casic.missiles.core.base.controller.ExportController; +import com.casic.missiles.core.datascope.DataScope; +import com.casic.missiles.core.page.PageFactory; +import com.casic.missiles.dto.IdDTO; +import com.casic.missiles.dto.IdsDTO; +import com.casic.missiles.dto.ReturnDTO; +import com.casic.missiles.enums.BusinessExceptionEnum; +import com.casic.missiles.exception.BusinessException; +import com.casic.missiles.modular.alarm.dto.AlarmRecordDTO; +import com.casic.missiles.modular.alarm.dto.DeviceAlarmResponseDTO; +import com.casic.missiles.modular.alarm.dto.RemindDTO; +import com.casic.missiles.modular.alarm.dto.SuspendDTO; +import com.casic.missiles.modular.alarm.entity.AlarmRecords; +import com.casic.missiles.modular.alarm.service.IAlarmRecordsService; +import com.casic.missiles.util.ReturnUtil; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import lombok.RequiredArgsConstructor; +import org.springframework.web.bind.annotation.*; + +import java.util.Objects; + +/** + *

+ * 设备报警 前端控制器 + *

+ * + * @author zt + * @since 2024-08-27 + */ +@Api(tags = "设备运维-设备报警模块") +@RequiredArgsConstructor +@RestController +@RequestMapping("/maintenance/alarmRecords") +public class AlarmDeviceController extends ExportController { + + private final IAlarmRecordsService iAlarmRecordsService; + private final AbstractPermissionContext permissionContext; + + @ApiOperation("设备报警分页接口") + @PostMapping("/listPage") + @ResponseBody + public ReturnDTO deviceAlarmListPage(@RequestBody AlarmRecordDTO request) { + DataScope dataScope = permissionContext.getAuthService().getLoginUserDataScope(); + Page page = PageFactory.defaultPage(); + return ReturnUtil.success(super.packForBT(iAlarmRecordsService.deviceAlarmListPage(page,request,dataScope))); + } + + @ApiOperation("查询历史告警分页接口") + @PostMapping("/historyListPage") + @ResponseBody + public ReturnDTO historyListPage(@RequestBody AlarmRecordDTO request) { + + DataScope dataScope = permissionContext.getAuthService().getLoginUserDataScope(); + + Page page = PageFactory.defaultPage(); + + return ReturnUtil.success(super.packForBT(iAlarmRecordsService.historyListPage(page,request,dataScope))); + } + +// @ApiOperation("新增") +// @PostMapping("/add") +// @ResponseBody +// public ReturnDTO add(@RequestBody AlarmRecords alarmRecords) { +// +// return ReturnUtil.success(iAlarmRecordsService.saveAlarmType(alarmRecords)); +// } + + @ApiOperation("查看") + @PostMapping("/view") + @ResponseBody + public ReturnDTO view(@RequestBody IdDTO idDTO) { + Assert.isFalse(Objects.isNull(idDTO.getId()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.view(idDTO.getId())); + } + + @ApiOperation("批量删除") + @PostMapping("/batchDelete") + @ResponseBody + public ReturnDTO batchDelete(@RequestBody IdsDTO idsDTO) { + Assert.isFalse(Objects.isNull(idsDTO.getIds()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.removeByIds(idsDTO.getIds())); + } + + @ApiOperation("挂起") + @PostMapping("/suspend") + @ResponseBody + public ReturnDTO suspend(@RequestBody SuspendDTO suspendDTO) { + Assert.isFalse(Objects.isNull(suspendDTO.getAlarmId()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.suspend(suspendDTO)); + } + + @ApiOperation("已读") + @PostMapping("/read") + @ResponseBody + public ReturnDTO read(@RequestBody IdDTO idDTO) { + Assert.isFalse(Objects.isNull(idDTO.getId()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.read(idDTO.getId())); + } + + @ApiOperation("提醒责任人") + @PostMapping("/remind") + @ResponseBody + public ReturnDTO remind(@RequestBody RemindDTO remindDTO) { + Assert.isFalse(Objects.isNull(remindDTO.getAlarmId()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.remind(remindDTO)); + } +} + diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmDeviceController.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmDeviceController.java new file mode 100644 index 0000000..d14a081 --- /dev/null +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmDeviceController.java @@ -0,0 +1,125 @@ +package com.casic.missiles.modular.alarm.controller; + + +import cn.hutool.core.lang.Assert; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.casic.missiles.core.application.context.AbstractPermissionContext; +import com.casic.missiles.core.base.controller.ExportController; +import com.casic.missiles.core.datascope.DataScope; +import com.casic.missiles.core.page.PageFactory; +import com.casic.missiles.dto.IdDTO; +import com.casic.missiles.dto.IdsDTO; +import com.casic.missiles.dto.ReturnDTO; +import com.casic.missiles.enums.BusinessExceptionEnum; +import com.casic.missiles.exception.BusinessException; +import com.casic.missiles.modular.alarm.dto.AlarmRecordDTO; +import com.casic.missiles.modular.alarm.dto.DeviceAlarmResponseDTO; +import com.casic.missiles.modular.alarm.dto.RemindDTO; +import com.casic.missiles.modular.alarm.dto.SuspendDTO; +import com.casic.missiles.modular.alarm.entity.AlarmRecords; +import com.casic.missiles.modular.alarm.service.IAlarmRecordsService; +import com.casic.missiles.util.ReturnUtil; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import lombok.RequiredArgsConstructor; +import org.springframework.web.bind.annotation.*; + +import java.util.Objects; + +/** + *

+ * 设备报警 前端控制器 + *

+ * + * @author zt + * @since 2024-08-27 + */ +@Api(tags = "设备运维-设备报警模块") +@RequiredArgsConstructor +@RestController +@RequestMapping("/maintenance/alarmRecords") +public class AlarmDeviceController extends ExportController { + + private final IAlarmRecordsService iAlarmRecordsService; + private final AbstractPermissionContext permissionContext; + + @ApiOperation("设备报警分页接口") + @PostMapping("/listPage") + @ResponseBody + public ReturnDTO deviceAlarmListPage(@RequestBody AlarmRecordDTO request) { + DataScope dataScope = permissionContext.getAuthService().getLoginUserDataScope(); + Page page = PageFactory.defaultPage(); + return ReturnUtil.success(super.packForBT(iAlarmRecordsService.deviceAlarmListPage(page,request,dataScope))); + } + + @ApiOperation("查询历史告警分页接口") + @PostMapping("/historyListPage") + @ResponseBody + public ReturnDTO historyListPage(@RequestBody AlarmRecordDTO request) { + + DataScope dataScope = permissionContext.getAuthService().getLoginUserDataScope(); + + Page page = PageFactory.defaultPage(); + + return ReturnUtil.success(super.packForBT(iAlarmRecordsService.historyListPage(page,request,dataScope))); + } + +// @ApiOperation("新增") +// @PostMapping("/add") +// @ResponseBody +// public ReturnDTO add(@RequestBody AlarmRecords alarmRecords) { +// +// return ReturnUtil.success(iAlarmRecordsService.saveAlarmType(alarmRecords)); +// } + + @ApiOperation("查看") + @PostMapping("/view") + @ResponseBody + public ReturnDTO view(@RequestBody IdDTO idDTO) { + Assert.isFalse(Objects.isNull(idDTO.getId()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.view(idDTO.getId())); + } + + @ApiOperation("批量删除") + @PostMapping("/batchDelete") + @ResponseBody + public ReturnDTO batchDelete(@RequestBody IdsDTO idsDTO) { + Assert.isFalse(Objects.isNull(idsDTO.getIds()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.removeByIds(idsDTO.getIds())); + } + + @ApiOperation("挂起") + @PostMapping("/suspend") + @ResponseBody + public ReturnDTO suspend(@RequestBody SuspendDTO suspendDTO) { + Assert.isFalse(Objects.isNull(suspendDTO.getAlarmId()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.suspend(suspendDTO)); + } + + @ApiOperation("已读") + @PostMapping("/read") + @ResponseBody + public ReturnDTO read(@RequestBody IdDTO idDTO) { + Assert.isFalse(Objects.isNull(idDTO.getId()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.read(idDTO.getId())); + } + + @ApiOperation("提醒责任人") + @PostMapping("/remind") + @ResponseBody + public ReturnDTO remind(@RequestBody RemindDTO remindDTO) { + Assert.isFalse(Objects.isNull(remindDTO.getAlarmId()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.remind(remindDTO)); + } +} + diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/dao/AlarmRecordsMapper.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/dao/AlarmRecordsMapper.java index 52af21e..ea8828a 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/dao/AlarmRecordsMapper.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/dao/AlarmRecordsMapper.java @@ -4,6 +4,7 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.casic.missiles.core.datascope.DataScope; import com.casic.missiles.modular.alarm.dto.AlarmRecordDTO; +import com.casic.missiles.modular.alarm.dto.DeviceAlarmResponseDTO; import com.casic.missiles.modular.alarm.entity.AlarmRecords; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @@ -21,6 +22,8 @@ Page pageList(Page page, @Param("request") AlarmRecordDTO request, @Param("dataScope") DataScope dataScope); + Page deviceAlarmListPage(Page page, @Param("request") AlarmRecordDTO request, @Param("dataScope") DataScope dataScope); + Page historyListPage(Page page, @Param("request") AlarmRecordDTO request, @Param("dataScope") DataScope dataScope); AlarmRecords view(@Param("id") Long id); diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmDeviceController.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmDeviceController.java new file mode 100644 index 0000000..d14a081 --- /dev/null +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/controller/AlarmDeviceController.java @@ -0,0 +1,125 @@ +package com.casic.missiles.modular.alarm.controller; + + +import cn.hutool.core.lang.Assert; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.casic.missiles.core.application.context.AbstractPermissionContext; +import com.casic.missiles.core.base.controller.ExportController; +import com.casic.missiles.core.datascope.DataScope; +import com.casic.missiles.core.page.PageFactory; +import com.casic.missiles.dto.IdDTO; +import com.casic.missiles.dto.IdsDTO; +import com.casic.missiles.dto.ReturnDTO; +import com.casic.missiles.enums.BusinessExceptionEnum; +import com.casic.missiles.exception.BusinessException; +import com.casic.missiles.modular.alarm.dto.AlarmRecordDTO; +import com.casic.missiles.modular.alarm.dto.DeviceAlarmResponseDTO; +import com.casic.missiles.modular.alarm.dto.RemindDTO; +import com.casic.missiles.modular.alarm.dto.SuspendDTO; +import com.casic.missiles.modular.alarm.entity.AlarmRecords; +import com.casic.missiles.modular.alarm.service.IAlarmRecordsService; +import com.casic.missiles.util.ReturnUtil; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import lombok.RequiredArgsConstructor; +import org.springframework.web.bind.annotation.*; + +import java.util.Objects; + +/** + *

+ * 设备报警 前端控制器 + *

+ * + * @author zt + * @since 2024-08-27 + */ +@Api(tags = "设备运维-设备报警模块") +@RequiredArgsConstructor +@RestController +@RequestMapping("/maintenance/alarmRecords") +public class AlarmDeviceController extends ExportController { + + private final IAlarmRecordsService iAlarmRecordsService; + private final AbstractPermissionContext permissionContext; + + @ApiOperation("设备报警分页接口") + @PostMapping("/listPage") + @ResponseBody + public ReturnDTO deviceAlarmListPage(@RequestBody AlarmRecordDTO request) { + DataScope dataScope = permissionContext.getAuthService().getLoginUserDataScope(); + Page page = PageFactory.defaultPage(); + return ReturnUtil.success(super.packForBT(iAlarmRecordsService.deviceAlarmListPage(page,request,dataScope))); + } + + @ApiOperation("查询历史告警分页接口") + @PostMapping("/historyListPage") + @ResponseBody + public ReturnDTO historyListPage(@RequestBody AlarmRecordDTO request) { + + DataScope dataScope = permissionContext.getAuthService().getLoginUserDataScope(); + + Page page = PageFactory.defaultPage(); + + return ReturnUtil.success(super.packForBT(iAlarmRecordsService.historyListPage(page,request,dataScope))); + } + +// @ApiOperation("新增") +// @PostMapping("/add") +// @ResponseBody +// public ReturnDTO add(@RequestBody AlarmRecords alarmRecords) { +// +// return ReturnUtil.success(iAlarmRecordsService.saveAlarmType(alarmRecords)); +// } + + @ApiOperation("查看") + @PostMapping("/view") + @ResponseBody + public ReturnDTO view(@RequestBody IdDTO idDTO) { + Assert.isFalse(Objects.isNull(idDTO.getId()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.view(idDTO.getId())); + } + + @ApiOperation("批量删除") + @PostMapping("/batchDelete") + @ResponseBody + public ReturnDTO batchDelete(@RequestBody IdsDTO idsDTO) { + Assert.isFalse(Objects.isNull(idsDTO.getIds()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.removeByIds(idsDTO.getIds())); + } + + @ApiOperation("挂起") + @PostMapping("/suspend") + @ResponseBody + public ReturnDTO suspend(@RequestBody SuspendDTO suspendDTO) { + Assert.isFalse(Objects.isNull(suspendDTO.getAlarmId()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.suspend(suspendDTO)); + } + + @ApiOperation("已读") + @PostMapping("/read") + @ResponseBody + public ReturnDTO read(@RequestBody IdDTO idDTO) { + Assert.isFalse(Objects.isNull(idDTO.getId()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.read(idDTO.getId())); + } + + @ApiOperation("提醒责任人") + @PostMapping("/remind") + @ResponseBody + public ReturnDTO remind(@RequestBody RemindDTO remindDTO) { + Assert.isFalse(Objects.isNull(remindDTO.getAlarmId()), () -> { + throw new BusinessException(BusinessExceptionEnum.ID_NULL); + }); + return ReturnUtil.success(iAlarmRecordsService.remind(remindDTO)); + } +} + diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/dao/AlarmRecordsMapper.java b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/dao/AlarmRecordsMapper.java index 52af21e..ea8828a 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/dao/AlarmRecordsMapper.java +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/dao/AlarmRecordsMapper.java @@ -4,6 +4,7 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.casic.missiles.core.datascope.DataScope; import com.casic.missiles.modular.alarm.dto.AlarmRecordDTO; +import com.casic.missiles.modular.alarm.dto.DeviceAlarmResponseDTO; import com.casic.missiles.modular.alarm.entity.AlarmRecords; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @@ -21,6 +22,8 @@ Page pageList(Page page, @Param("request") AlarmRecordDTO request, @Param("dataScope") DataScope dataScope); + Page deviceAlarmListPage(Page page, @Param("request") AlarmRecordDTO request, @Param("dataScope") DataScope dataScope); + Page historyListPage(Page page, @Param("request") AlarmRecordDTO request, @Param("dataScope") DataScope dataScope); AlarmRecords view(@Param("id") Long id); diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/dao/mapping/AlarmRecordsMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/dao/mapping/AlarmRecordsMapper.xml index 31d7d32..20469fe 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/dao/mapping/AlarmRecordsMapper.xml +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/alarm/dao/mapping/AlarmRecordsMapper.xml @@ -7,7 +7,7 @@ - + @@ -21,7 +21,7 @@ ID - , DEVCODE, LEDGER_CODE, ALARM_TYPE, ALARM_CONTENT, ALARM_VALUE, ALARM_LEVEL, ALARM_TIME, `STATUS`, ALARM_MSG, PROCESS_STATUS, PROCESS_TIME + , DEVCODE, LEDGER_CODE, ALARM_TYPE_ID, ALARM_CONTENT, ALARM_VALUE, ALARM_LEVEL, ALARM_TIME, `STATUS`, ALARM_MSG, PROCESS_STATUS, PROCESS_TIME + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + + @@ -42,7 +42,7 @@ AND bl.VALID = 1 AND lr.VALID =1 LEFT JOIN sys_dept sd ON sd.id = lr.DEPTID - where rd.STATUS =1 + where rd.STATUS =1 and rd.EXCEPTION_TYPE=0 and rd.DEVCODE like concat('%', #{request.devCode}, '%') @@ -52,6 +52,34 @@ ORDER BY rd.TS DESC + +