fix：sql查询时间调整

cjl

2025-01-06 8490eb11583ffdc586436f165860de5cfc39f915

 screen-manage/src/main/java/com/moral/api/controller/DivisorController.java

@@ -42,15 +42,14 @@

    @Autowired
    private DivisorService divisorService;
    @Autowired
    private DivisorMapper divisorMapper;



    @PostMapping("insert")
    @ApiOperation("新增")
    public ResultMessage  insert(@Valid @RequestBody Divisor divisor){
        QueryWrapper<Divisor> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("mac", divisor.getMac()).eq("is_del", Constants.NOT_DELETE);
        queryWrapper.eq("organization_id", divisor.getOrganizationId()).eq("is_del", Constants.NOT_DELETE);
        if (divisorService.getOne(queryWrapper) != null) {
            return ResultMessage.fail(ResponseCodeEnum.MAC_IS_EXIST.getCode(), ResponseCodeEnum.MAC_IS_EXIST.getMsg());
        }
@@ -64,7 +63,7 @@
    public ResultMessage  update(@Valid @RequestBody Divisor divisor){

        QueryWrapper<Divisor> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("mac", divisor.getMac()).eq("is_del", Constants.NOT_DELETE);
        queryWrapper.eq("organization_id", divisor.getOrganizationId()).eq("is_del", Constants.NOT_DELETE);
        if (divisorService.getOne(queryWrapper) != null) {
            return ResultMessage.fail(ResponseCodeEnum.MAC_IS_EXIST.getCode(), ResponseCodeEnum.MAC_IS_EXIST.getMsg());
        }
@@ -75,11 +74,20 @@
    @GetMapping("delete")
    @ApiOperation("删除")
    public ResultMessage  delete(@RequestParam @ApiParam(value = "id",name = "主键id") Integer id){
        divisorMapper.deleteById(id);
        divisorService.delete(id);
        return ResultMessage.ok();
    }



    @GetMapping("select")
    @ApiOperation("详情")
    public ResultMessage  select(@RequestParam @ApiParam(value = "id",name = "主键id") Integer id){
        Divisor divisor = divisorService.queryById(id);
        return ResultMessage.ok(ObjectUtils.isEmpty(divisor)?"0":divisor);
    }


    @GetMapping("page")
    @ApiOperation("分页")
    public ResultMessage page(@RequestParam @ApiParam(value = "mac",name = "mac号") String mac,