Skyeye v3.19.6：零代码平台如何把制造业务堆进一套系统

// EquipmentRepair.java — 设备报修实体
package com.skyeye.mes.entity;

import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import java.time.LocalDateTime;

@Data
@TableName("mes_equipment_repair")
public class EquipmentRepair {
    private Long id;
    private String equipmentCode;   // 设备编号
    private String faultDesc;       // 故障描述
    private String reporter;        // 报修人
    private String status;          // 状态: PENDING/DISPATCHED/DONE
    private LocalDateTime createTime;
    private LocalDateTime updateTime;
}

// EquipmentRepairMapper.java
package com.skyeye.mes.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.skyeye.mes.entity.EquipmentRepair;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface EquipmentRepairMapper extends BaseMapper<EquipmentRepair> {
}

// EquipmentRepairService.java
package com.skyeye.mes.service;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.skyeye.mes.entity.EquipmentRepair;
import com.skyeye.mes.mapper.EquipmentRepairMapper;
import org.springframework.stereotype.Service;

@Service
public class EquipmentRepairService
        extends ServiceImpl<EquipmentRepairMapper, EquipmentRepair> {

    /** 派工：将状态从 PENDING 改为 DISPATCHED，记录维修人 */
    public boolean dispatch(Long repairId, String repairWorker) {
        EquipmentRepair repair = getById(repairId);
        if (repair == null || !"PENDING".equals(repair.getStatus())) {
            return false;
        }
        repair.setStatus("DISPATCHED");
        repair.setUpdateTime(LocalDateTime.now());
        return updateById(repair);
    }
}

// EquipmentRepairController.java
package com.skyeye.mes.controller;

import com.skyeye.mes.entity.EquipmentRepair;
import com.skyeye.mes.service.EquipmentRepairService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.List;

@RestController
@RequestMapping("/api/mes/equipment-repair")
public class EquipmentRepairController {

    @Autowired
    private EquipmentRepairService service;

    @GetMapping("/list")
    public List<EquipmentRepair> list() {
        return service.list();
    }

    @PostMapping("/submit")
    public boolean submit(@RequestBody EquipmentRepair repair) {
        repair.setStatus("PENDING");
        repair.setCreateTime(LocalDateTime.now());
        return service.save(repair);
    }

    @PostMapping("/dispatch/{id}")
    public boolean dispatch(@PathVariable Long id,
                            @RequestParam String worker) {
        return service.dispatch(id, worker);
    }
}

CREATE TABLE mes_equipment_repair (
    id            BIGINT PRIMARY KEY AUTO_INCREMENT,
    equipment_code VARCHAR(64) NOT NULL COMMENT '设备编号',
    fault_desc     VARCHAR(512) NOT NULL COMMENT '故障描述',
    reporter       VARCHAR(64) NOT NULL COMMENT '报修人',
    status         VARCHAR(16) NOT NULL DEFAULT 'PENDING' COMMENT 'PENDING/DISPATCHED/DONE',
    create_time    DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    update_time    DATETIME ON UPDATE CURRENT_TIMESTAMP,
    INDEX idx_status (status),
    INDEX idx_equipment (equipment_code)
) COMMENT='设备报修工单';

<!-- EquipmentRepairList.vue — 简化示意 -->
<template>
  <a-table :columns="columns" :data-source="repairs" row-key="id">
    <template #action="{ record }">
      <a-button v-if="record.status === 'PENDING'"
                @click="dispatch(record.id)">派工</a-button>
    </template>
  </a-table>
</template>

<script setup>
import { ref, onMounted } from 'vue'
import axios from 'axios'

const repairs = ref([])
const columns = [
  { title: '设备编号', dataIndex: 'equipmentCode' },
  { title: '故障描述', dataIndex: 'faultDesc' },
  { title: '报修人', dataIndex: 'reporter' },
  { title: '状态', dataIndex: 'status' },
  { title: '操作', slots: { customRender: 'action' } }
]

onMounted(async () => {
  repairs.value = (await axios.get('/api/mes/equipment-repair/list')).data
})

async function dispatch(id) {
  await axios.post(`/api/mes/equipment-repair/dispatch/${id}`, null,
    { params: { worker: '张师傅' } })
  onMounted() // 刷新列表
}
</script>