后端开发小技巧（六）

后端开发小技巧（六）

1. 多选删除的接口 - Controller

  @DeleteMapping("/remove")
    @ApiOperation("根据id删除标准产品按需生产")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "id", value = "ids(多个id以逗号分隔)", dataType = "String", required = true, paramType = "query")
    })
    public ServiceResult remove(@RequestParam("id") List<Integer> ids) {
        ServiceResult result = requireTaskService.remove(ids);
        return result;
    }

多选删除的 ServiceImpl

 @Override
    public ServiceResult remove(List<Integer> ids) {
        ServiceResult result = new ServiceResult(false);
        for (Integer id : ids) {
            if (mapper.selectById(id) == null) {
                result.failed(null, "删除失败，没有找到id为:" + id + "数据", 0);
             return result;
            }
        }
        int status = mapper.delete(ids);
        if (status == ids.size()) {
            result.setSuccess(true);
            result.success(null, "删除成功！", 0);
        } else {
            result.failed(null, "删除失败！", -1);
        }
        return result;
    }

多选删除的Mapper.xml

  <delete id="delete">
        DELETE FROM sar_standard_require_task WHERE id in
        <foreach collection="ids" item="item" separator="," open="(" close=")">
             #{item}
        </foreach>
    </delete>

2. 删除任务(包含status) ServiceImpl

@Override
//    @Transactional(rollbackFor = Exception.class)
    public ServiceResult deleteTaskDetails(HttpServletRequest request, String id) {
        ServiceResult result = new ServiceResult(false);
        if (StringUtils.isEmpty(id)) {
            result.failed(null, "参数不能为空", -1);
            return result;
        }
        TaskDetails taskDetails = taskDetailsMapper.selectByTaskCode(id);
        if (!StringUtils.isEmpty(taskDetails)) {
            if (Constants.TASK_RUNNING_STATUS == taskDetails.getStatus()) {
                result.failed(null, "任务正在运行,无法删除", -1);
            } else {
                String delete = taskUtil.changeWorkFlowStatus(id, "DELETE");
                if (StringUtils.isEmpty(delete)) {
                    int i = taskDetailsMapper.deleteByTaskCode(id);
                    if (i == 1) {
                        List<TaskDetails> taskDetailsList = taskDetailsMapper.queryByTaskId(taskDetails.getGroupTaskId(), null, null, null, null, null, null);
                        if (taskDetailsList.size() == 0) {
                            int status = taskInfoMapper.deleteByPrimaryKey(taskDetails.getGroupTaskId());
                            if (status == 1) {
                                result.success(null, "删除成功", 0);
                            }
                        }
                    }
                } else {
                    result.failed(null, delete, -1);
                }
            }
        } else {
            result.success(null, "删除成功", 0);
        }
        return result;
    }