工单管理

xiangpei

2024-03-05 7fe002810d3d6081699a4c0eb8958d9952bd64d0

工单管理

 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/WorkOrder.java

New file
@@ -0,0 +1,57 @@
package com.ycl.platform.domain.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import java.io.Serializable;
import java.time.LocalDateTime;

import com.ycl.platform.base.AbsEntity;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.experimental.Accessors;

/**
 * 工单
 *
 * @author xp
 * @since 2024-03-05
 */
@Data
@Accessors(chain = true)
@TableName("t_work_order")
@ApiModel(value = "WorkOrder对象", description = "工单")
public class WorkOrder extends AbsEntity {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty("工单号")
    @TableField("work_order_no")
    private String workOrderNo;

    @ApiModelProperty("运维单位")
    @TableField("unit_id")
    private Integer unitId;

    @ApiModelProperty("运维人员")
    @TableField("yw_people_id")
    private Integer ywPeopleId;

    @ApiModelProperty("运维处理时间")
    @TableField("yw_handle_time")
    private LocalDateTime ywHandleTime;

    @ApiModelProperty("运维结果")
    @TableField("yw_result")
    private String ywResult;

    @ApiModelProperty("运维情况")
    @TableField("yw_condition")
    private String ywCondition;

    @ApiModelProperty("运维检测结果")
    @TableField("yw_check_result")
    private String ywCheckResult;


}

 ycl-pojo/src/main/java/com/ycl/platform/domain/form/WorkOrderForm.java

New file
@@ -0,0 +1,65 @@
package com.ycl.platform.domain.form;

import com.ycl.system.domain.group.Update;
import com.ycl.system.domain.group.Add;
import com.ycl.platform.base.AbsForm;
import com.ycl.platform.domain.entity.WorkOrder;
import org.springframework.beans.BeanUtils;
import jakarta.validation.constraints.NotBlank;
import jakarta.validation.constraints.NotNull;
import org.springframework.lang.NonNull;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.experimental.Accessors;

import java.time.LocalDateTime;

/**
 * 工单表单
 *
 * @author xp
 * @since 2024-03-05
 */
@Data
@Accessors(chain = true)
@ApiModel(value = "WorkOrder表单", description = "工单表单")
public class WorkOrderForm extends AbsForm {

    @NotBlank(message = "工单号不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("工单号")
    private String workOrderNo;

    @NotNull(message = "运维单位不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("运维单位")
    private Integer unitId;

    @NotNull(message = "运维人员不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("运维人员")
    private Integer ywPeopleId;

    @NotNull(message = "运维处理时间不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("运维处理时间")
    private LocalDateTime ywHandleTime;

    @NotBlank(message = "运维结果不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("运维结果")
    private String ywResult;

    @NotBlank(message = "运维情况不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("运维情况")
    private String ywCondition;

    @NotBlank(message = "运维检测结果不能为空", groups = {Add.class, Update.class})
    @ApiModelProperty("运维检测结果")
    private String ywCheckResult;

    public static WorkOrder getEntityByForm(@NonNull WorkOrderForm form, WorkOrder entity) {
        if(entity == null) {
          entity = new WorkOrder();
        }
        BeanUtils.copyProperties(form, entity);
        return entity;
    }

}

 ycl-pojo/src/main/java/com/ycl/platform/domain/query/WorkOrderQuery.java

New file
@@ -0,0 +1,23 @@
package com.ycl.platform.domain.query;

import com.ycl.platform.base.AbsQuery;
import java.util.List;
import org.springframework.lang.NonNull;
import jakarta.validation.constraints.NotBlank;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.experimental.Accessors;

/**
 * 工单查询
 *
 * @author xp
 * @since 2024-03-05
 */
@Data
@Accessors(chain = true)
@ApiModel(value = "WorkOrder查询", description = "工单查询")
public class WorkOrderQuery extends AbsQuery {
}


 ycl-pojo/src/main/java/com/ycl/platform/domain/vo/WorkOrderVO.java

New file
@@ -0,0 +1,54 @@
package com.ycl.platform.domain.vo;

import com.ycl.platform.base.AbsVo;
import com.ycl.platform.domain.entity.WorkOrder;

import java.time.LocalDateTime;
import java.util.List;
import org.springframework.lang.NonNull;
import org.springframework.beans.BeanUtils;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.experimental.Accessors;

/**
 * 工单展示
 *
 * @author xp
 * @since 2024-03-05
 */
@Data
@Accessors(chain = true)
public class WorkOrderVO extends AbsVo {

    /** 工单号 */
    private String workOrderNo;

    /** 运维单位 */
    private Integer unitId;

    /** 运维人员 */
    private Integer ywPeopleId;

    /** 运维处理时间 */
    private LocalDateTime ywHandleTime;

    /** 运维结果 */
    private String ywResult;

    /** 运维情况 */
    private String ywCondition;

    /** 运维检测结果 */
    private String ywCheckResult;

    public static WorkOrderVO getVoByEntity(@NonNull WorkOrder entity, WorkOrderVO vo) {
        if(vo == null) {
            vo = new WorkOrderVO();
        }
        BeanUtils.copyProperties(entity, vo);
        return vo;
    }

}

 ycl-server/src/main/java/com/ycl/platform/controller/WorkOrderController.java

New file
@@ -0,0 +1,75 @@
package com.ycl.platform.controller;

import com.ycl.system.domain.group.Update;
import com.ycl.system.domain.group.Add;
import org.springframework.validation.annotation.Validated;
import lombok.RequiredArgsConstructor;
import java.util.List;
import org.springframework.validation.annotation.Validated;
import jakarta.validation.constraints.NotEmpty;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import com.ycl.platform.service.WorkOrderService;
import com.ycl.system.Result;
import com.ycl.platform.domain.form.WorkOrderForm;
import com.ycl.platform.domain.query.WorkOrderQuery;
import lombok.RequiredArgsConstructor;
import org.springframework.web.bind.annotation.*;

/**
 * 工单 前端控制器
 *
 * @author xp
 * @since 2024-03-05
 */
@Validated
@RequiredArgsConstructor
@Api(value = "工单", tags = "工单管理")
@RestController
@RequestMapping("/work-order")
public class WorkOrderController {

    private final WorkOrderService workOrderService;

    @PostMapping
    @ApiOperation(value = "添加", notes = "添加")
    public Result add(@RequestBody @Validated(Add.class) WorkOrderForm form) {
        return workOrderService.add(form);
    }

    @PutMapping
    @ApiOperation(value = "修改", notes = "修改")
    public Result update(@RequestBody @Validated(Update.class) WorkOrderForm form) {
        return workOrderService.update(form);
    }

    @DeleteMapping("/{id}")
    @ApiOperation(value = "ID删除", notes = "ID删除")
    public Result removeById(@PathVariable("id") String id) {
        return workOrderService.removeById(id);
    }

    @DeleteMapping("/batch")
    @ApiOperation(value = "批量删除", notes = "批量删除")
    public Result remove(@RequestBody @NotEmpty(message = "请选择数据") List<String> ids) {
        return workOrderService.remove(ids);
    }

    @GetMapping("/page")
    @ApiOperation(value = "分页", notes = "分页")
    public Result page(WorkOrderQuery query) {
        return workOrderService.page(query);
    }

    @GetMapping("/{id}")
    @ApiOperation(value = "详情", notes = "详情")
    public Result detail(@PathVariable("id") String id) {
        return workOrderService.detail(id);
    }

    @GetMapping("/list")
    @ApiOperation(value = "列表", notes = "列表")
    public Result list() {
        return workOrderService.all();
    }
}

 ycl-server/src/main/java/com/ycl/platform/mapper/WorkOrderMapper.java

New file
@@ -0,0 +1,19 @@
package com.ycl.platform.mapper;

import com.ycl.platform.domain.entity.WorkOrder;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ycl.platform.domain.vo.WorkOrderVO;
import com.ycl.platform.domain.form.WorkOrderForm;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;

/**
 * 工单 Mapper 接口
 *
 * @author xp
 * @since 2024-03-05
 */
@Mapper
public interface WorkOrderMapper extends BaseMapper<WorkOrder> {

}

 ycl-server/src/main/java/com/ycl/platform/service/WorkOrderService.java

New file
@@ -0,0 +1,65 @@
package com.ycl.platform.service;

import com.ycl.platform.domain.entity.WorkOrder;
import com.baomidou.mybatisplus.extension.service.IService;
import com.ycl.system.Result;
import com.ycl.platform.domain.form.WorkOrderForm;
import com.ycl.platform.domain.query.WorkOrderQuery;
import java.util.List;

/**
 * 工单 服务类
 *
 * @author xp
 * @since 2024-03-05
 */
public interface WorkOrderService extends IService<WorkOrder> {

    /**
     * 添加
     * @param form
     * @return
     */
    Result add(WorkOrderForm form);

    /**
     * 修改
     * @param form
     * @return
     */
    Result update(WorkOrderForm form);

    /**
     * 批量删除
     * @param ids
     * @return
     */
    Result remove(List<String> ids);

    /**
     * id删除
     * @param id
     * @return
     */
    Result removeById(String id);

    /**
     * 分页查询
     * @param query
     * @return
     */
    Result page(WorkOrderQuery query);

    /**
     * 根据id查找
     * @param id
     * @return
     */
    Result detail(String id);

    /**
     * 列表
     * @return
     */
    Result all();
}

 ycl-server/src/main/java/com/ycl/platform/service/impl/WorkOrderServiceImpl.java

New file
@@ -0,0 +1,145 @@
package com.ycl.platform.service.impl;

import com.ycl.platform.domain.entity.WorkOrder;
import com.ycl.platform.mapper.WorkOrderMapper;
import com.ycl.platform.service.WorkOrderService;
import com.ycl.system.Result;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.platform.domain.form.WorkOrderForm;
import com.ycl.platform.domain.vo.WorkOrderVO;
import com.ycl.platform.domain.query.WorkOrderQuery;
import java.util.List;
import org.apache.commons.lang3.StringUtils;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.ycl.system.page.PageUtil;
import org.springframework.stereotype.Service;
import org.springframework.security.core.context.SecurityContextHolder;
import org.springframework.beans.BeanUtils;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.Assert;
import java.util.ArrayList;
import java.util.stream.Collectors;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
import lombok.RequiredArgsConstructor;

/**
 * 工单 服务实现类
 *
 * @author xp
 * @since 2024-03-05
 */
@Service
@RequiredArgsConstructor
public class WorkOrderServiceImpl extends ServiceImpl<WorkOrderMapper, WorkOrder> implements WorkOrderService {

    private final WorkOrderMapper workOrderMapper;

    /**
     * 添加
     * @param form
     * @return
     */
    @Override
    public Result add(WorkOrderForm form) {
        WorkOrder entity = WorkOrderForm.getEntityByForm(form, null);
        if(baseMapper.insert(entity) > 0) {
            return Result.ok("添加成功");
        }
        return Result.error("添加失败");
    }

    /**
     * 修改
     * @param form
     * @return
     */
    @Override
    public Result update(WorkOrderForm form) {

        WorkOrder entity = baseMapper.selectById(form.getId());

        // 为空抛IllegalArgumentException，做全局异常处理
        Assert.notNull(entity, "记录不存在");
        BeanUtils.copyProperties(form, entity);
        if (baseMapper.updateById(entity) > 0) {
            return Result.ok("修改成功");
        }
        return Result.error("修改失败");
    }

    /**
     * 批量删除
     * @param ids
     * @return
     */
    @Override
    public Result remove(List<String> ids) {
        if(baseMapper.deleteBatchIds(ids) > 0) {
            return Result.ok("删除成功");
        }
        return Result.error("删除失败");
    }

    /**
     * id删除
     * @param id
     * @return
     */
    @Override
    public Result removeById(String id) {
        if(baseMapper.deleteById(id) > 0) {
            return Result.ok("删除成功");
        }
        return Result.error("删除失败");
    }

    /**
     * 分页查询
     * @param query
     * @return
     */
    @Override
    public Result page(WorkOrderQuery query) {

        IPage<WorkOrder> page = new LambdaQueryChainWrapper<>(baseMapper)
                .orderByDesc(WorkOrder::getCreateTime)
                .page(PageUtil.getPage(query, WorkOrder.class));

        List<WorkOrderVO> vos = page.getRecords().stream()
                .map(
                        entity -> WorkOrderVO.getVoByEntity(entity, null)
                )
                .collect(Collectors.toList());
        return Result.ok().data(vos).total(page.getTotal());
    }

    /**
     * 根据id查找
     * @param id
     * @return
     */
    @Override
    public Result detail(String id) {

        WorkOrder entity = baseMapper.selectById(id);
        Assert.notNull(entity, "记录不存在");
        WorkOrderVO vo = WorkOrderVO.getVoByEntity(entity, null);
        return Result.ok().data(vo);
    }

    /**
     * 列表
     * @return
     */
    @Override
    public Result all() {
        List<WorkOrder> entities = baseMapper.selectList(null);
        List<WorkOrderVO> vos = entities.stream()
                .map(
                        entity -> WorkOrderVO.getVoByEntity(entity, null)
                )
                .collect(Collectors.toList());
        return Result.ok().data(vos);
    }
}

 ycl-server/src/main/resources/mapper/zgyw/WorkOrderMapper.xml

New file
@@ -0,0 +1,18 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ycl.platform.mapper.WorkOrderMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ycl.platform.domain.vo.WorkOrderVO">
        <result column="id" property="id" />
        <result column="create_time" property="createTime" />
        <result column="work_order_no" property="workOrderNo" />
        <result column="unit_id" property="unitId" />
        <result column="yw_people_id" property="ywPeopleId" />
        <result column="yw_handle_time" property="ywHandleTime" />
        <result column="yw_result" property="ywResult" />
        <result column="yw_condition" property="ywCondition" />
        <result column="yw_check_result" property="ywCheckResult" />
    </resultMap>

</mapper>