lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/entity/EamRepairOrder.java
@@ -93,6 +93,36 @@ @Excel(name = "æ éåå ", width = 15) @ApiModelProperty(value = "æ éåå ") private String faultReason; /** * æ éç±»å */ @Excel(name = "æ éç±»å", width = 15) @ApiModelProperty(value = "æ éç±»å") @Dict(dicCode = "repair_warehouse_fault_type") private String faultType; /** * æ éé¨ä½ */ @Excel(name = "æ éé¨ä½", width = 15) @ApiModelProperty(value = "æ éé¨ä½") private String faultPart; /** * æ éåé¨ä½ */ @Excel(name = "æ éåé¨ä½", width = 15) @ApiModelProperty(value = "æ éåé¨ä½") private String faultChildPart; /** * 严éç¨åº¦ */ @Excel(name = "严éç¨åº¦", width = 15) @ApiModelProperty(value = "严éç¨åº¦") @Dict(dicCode = "repair_severity") private String severity; /** * ç»´ä¿®ç»ææè¿° */ lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/entity/RepairWarehouse.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,78 @@ package org.jeecg.modules.eam.entity; import com.baomidou.mybatisplus.annotation.*; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; import lombok.experimental.Accessors; import org.jeecg.common.aspect.annotation.Dict; import org.jeecg.common.constant.CommonConstant; import org.jeecgframework.poi.excel.annotation.Excel; import org.springframework.format.annotation.DateTimeFormat; import java.io.Serializable; import java.util.Date; /** * @Description: eam_repair_warehouse * @Author: jeecg-boot * @Date: 2025-09-05 * @Version: V1.0 */ @Data @TableName("eam_repair_warehouse") @Accessors(chain = true) @EqualsAndHashCode(callSuper = false) @ApiModel(value="eam_repair_warehouse对象", description="ç»´ä¿®ç¥è¯åº") public class RepairWarehouse implements Serializable { private static final long serialVersionUID = 1L; /**主é®*/ @TableId(type = IdType.ASSIGN_ID) @ApiModelProperty(value = "主é®") private String id; /**å建人*/ @ApiModelProperty(value = "å建人") private String createBy; /**å建æ¶é´*/ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd") @DateTimeFormat(pattern="yyyy-MM-dd") @ApiModelProperty(value = "å建æ¶é´") private Date createTime; /**æ´æ°äºº*/ @ApiModelProperty(value = "æ´æ°äºº") private String updateBy; /**æ´æ°æ¶é´*/ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd") @DateTimeFormat(pattern="yyyy-MM-dd") @ApiModelProperty(value = "æ´æ°æ¶é´") private Date updateTime; /**å 餿 è®°*/ @Excel(name = "å 餿 è®°", width = 15) @ApiModelProperty(value = "å 餿 è®°") @TableLogic private Integer delFlag = CommonConstant.DEL_FLAG_0; /**æ éç±»å*/ @Excel(name = "æ éç±»å", width = 15,dicCode = "repair_warehouse_fault_type") @ApiModelProperty(value = "æ éç±»å") @Dict(dicCode = "repair_warehouse_fault_type") private String faultType; /**æ éé¨ä½*/ @Excel(name = "æ éé¨ä½", width = 15) @ApiModelProperty(value = "æ éé¨ä½") private String faultPart; /**æ éåé¨ä½*/ @Excel(name = "æ éåé¨ä½", width = 15) @ApiModelProperty(value = "æ éåé¨ä½") private String faultChildPart; /**ç»´ä¿®æè¿°*/ @Excel(name = "ç»´ä¿®æè¿°", width = 15) @ApiModelProperty(value = "ç»´ä¿®æè¿°") private String repairDescription; /**éè¦è¿åçåæ®µ*/ @ApiModelProperty(value = "éè¦è¿åçåæ®µ") @TableField(exist = false) private String column; } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/mapper/RepairWarehouseMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,18 @@ package org.jeecg.modules.eam.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import org.apache.ibatis.annotations.Param; import org.jeecg.modules.eam.entity.RepairWarehouse; import java.util.List; /** * @Description: eam_repair_warehouse * @Author: jeecg-boot * @Date: 2025-09-05 * @Version: V1.0 */ public interface RepairWarehouseMapper extends BaseMapper<RepairWarehouse> { List<String> getColumnDateList(@Param("repairWarehouse") RepairWarehouse repairWarehouse); } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/mapper/xml/RepairWarehouseMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,23 @@ <?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="org.jeecg.modules.eam.mapper.RepairWarehouseMapper"> <select id="getColumnDateList" resultType="java.lang.String"> select distinct ${repairWarehouse.column} from eam_repair_warehouse where del_flag = '0' <if test="repairWarehouse.faultType != null and repairWarehouse.faultType != '' "> AND fault_type = #{repairWarehouse.faultType} </if> <if test="repairWarehouse.faultPart != null and repairWarehouse.faultPart != '' "> AND fault_part LIKE CONCAT(CONCAT('%',#{repairWarehouse.faultPart}),'%') </if> <if test="repairWarehouse.faultChildPart != null and repairWarehouse.faultChildPart != '' "> AND fault_child_part LIKE CONCAT(CONCAT('%',#{repairWarehouse.faultChildPart}),'%') </if> <if test="repairWarehouse.repairDescription != null and repairWarehouse.repairDescription != '' "> AND repair_description LIKE CONCAT(CONCAT('%',#{repairWarehouse.repairDescription}),'%') </if> </select> </mapper> lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/request/EamRepairOrderRequest.java
@@ -5,6 +5,7 @@ import lombok.EqualsAndHashCode; import lombok.experimental.Accessors; import org.jeecg.common.api.vo.FileUploadResult; import org.jeecg.common.aspect.annotation.Dict; import org.jeecg.modules.flowable.domain.vo.FlowTaskVo; import java.io.Serializable; @@ -35,6 +36,33 @@ */ @ApiModelProperty(value = "æ éåå ") private String faultReason; /** * æ éç±»å */ @ApiModelProperty(value = "æ éç±»å") @Dict(dicCode = "repair_warehouse_fault_type") private String faultType; /** * æ éé¨ä½ */ @ApiModelProperty(value = "æ éé¨ä½") private String faultPart; /** * æ éåé¨ä½ */ @ApiModelProperty(value = "æ éåé¨ä½") private String faultChildPart; /** * 严éç¨åº¦ */ @ApiModelProperty(value = "严éç¨åº¦") @Dict(dicCode = "repair_severity") private String severity; /** * ç»´ä¿®ç»ææè¿° */ lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/IRepairWarehouseService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,23 @@ package org.jeecg.modules.eam.service; import com.baomidou.mybatisplus.extension.service.IService; import org.jeecg.modules.eam.entity.RepairWarehouse; import java.util.List; /** * @Description: eam_repair_warehouse * @Author: jeecg-boot * @Date: 2025-09-05 * @Version: V1.0 */ public interface IRepairWarehouseService extends IService<RepairWarehouse> { void add(RepairWarehouse repairWarehouse); void saveData(RepairWarehouse repairWarehouse); void edit(RepairWarehouse repairWarehouse); List<String> getColumnDateList(RepairWarehouse repairWarehouse); } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/impl/EamRepairOrderServiceImpl.java
@@ -24,15 +24,13 @@ import org.jeecg.modules.eam.entity.EamEquipment; import org.jeecg.modules.eam.entity.EamRepairOrder; import org.jeecg.modules.eam.entity.EamReportRepair; import org.jeecg.modules.eam.entity.RepairWarehouse; import org.jeecg.modules.eam.mapper.EamRepairOrderMapper; import org.jeecg.modules.eam.request.EamRepairOrderQuery; import org.jeecg.modules.eam.request.EamRepairOrderRequest; import org.jeecg.modules.eam.request.EamRepairOrderResponse; import org.jeecg.modules.eam.request.EamReportRepairQuery; import org.jeecg.modules.eam.service.IEamEquipmentExtendService; import org.jeecg.modules.eam.service.IEamEquipmentService; import org.jeecg.modules.eam.service.IEamRepairOrderService; import org.jeecg.modules.eam.service.IEamReportRepairService; import org.jeecg.modules.eam.service.*; import org.jeecg.modules.eam.util.DateUtils; import org.jeecg.modules.flowable.apithird.business.entity.FlowMyBusiness; import org.jeecg.modules.flowable.apithird.business.service.IFlowMyBusinessService; @@ -91,6 +89,9 @@ @Autowired private ISysUserService sysUserService; @Autowired private IRepairWarehouseService repairWarehouseService; /** * å页å表 @@ -299,6 +300,8 @@ Map<String, Object> values = new HashMap<>(); List<UserSelector> userSelectors; List<String> userApprovalList; RepairWarehouse repairWarehouse = null; switch (status) { case WAIT_INTERNAL_CONFIRM: order.setRepairConfirm(request.getRepairConfirm()); @@ -345,6 +348,17 @@ order.setFaultReason(request.getFaultReason()); order.setRepairDescription(request.getRepairDescription()); order.setActualEndTime(new Date()); order.setFaultType(request.getFaultType()); order.setFaultPart(request.getFaultPart()); order.setFaultChildPart(request.getFaultChildPart()); order.setSeverity(request.getSeverity()); order.setRepairDescription(request.getRepairDescription()); //ä¿åç»´ä¿®ç¥è¯åº repairWarehouse = new RepairWarehouse(); BeanUtils.copyProperties(request, repairWarehouse); repairWarehouseService.saveData(repairWarehouse); // å¤çéä»¶ if (CollectionUtil.isNotEmpty(request.getImageFilesResult())) { List<FileUploadResult> fileUploadResultList = request.getImageFilesResult(); @@ -432,6 +446,17 @@ order.setFaultReason(request.getFaultReason()); order.setRepairDescription(request.getRepairDescription()); order.setActualEndTime(new Date()); order.setFaultType(request.getFaultType()); order.setFaultPart(request.getFaultPart()); order.setFaultChildPart(request.getFaultChildPart()); order.setSeverity(request.getSeverity()); order.setRepairDescription(request.getRepairDescription()); //ä¿åç»´ä¿®ç¥è¯åº repairWarehouse = new RepairWarehouse(); BeanUtils.copyProperties(request, repairWarehouse); repairWarehouseService.saveData(repairWarehouse); // å¤çéä»¶ if (CollectionUtil.isNotEmpty(request.getImageFilesResult())) { List<FileUploadResult> fileUploadResultList = request.getImageFilesResult(); @@ -459,6 +484,17 @@ order.setFaultReason(request.getFaultReason()); order.setRepairDescription(request.getRepairDescription()); order.setActualEndTime(new Date()); order.setFaultType(request.getFaultType()); order.setFaultPart(request.getFaultPart()); order.setFaultChildPart(request.getFaultChildPart()); order.setSeverity(request.getSeverity()); order.setRepairDescription(request.getRepairDescription()); //ä¿åç»´ä¿®ç¥è¯åº repairWarehouse = new RepairWarehouse(); BeanUtils.copyProperties(request, repairWarehouse); repairWarehouseService.saveData(repairWarehouse); // å¤çéä»¶ if (CollectionUtil.isNotEmpty(request.getImageFilesResult())) { List<FileUploadResult> fileUploadResultList = request.getImageFilesResult(); lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/impl/RepairWarehouseServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,105 @@ package org.jeecg.modules.eam.service.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.StringUtils; import org.jeecg.common.exception.JeecgBootException; import org.jeecg.modules.eam.entity.RepairWarehouse; import org.jeecg.modules.eam.mapper.RepairWarehouseMapper; import org.jeecg.modules.eam.service.IRepairWarehouseService; import org.springframework.stereotype.Service; import java.util.Arrays; import java.util.List; import java.util.Objects; /** * @Description: eam_repair_warehouse * @Author: jeecg-boot * @Date: 2025-09-05 * @Version: V1.0 */ @Service @Slf4j public class RepairWarehouseServiceImpl extends ServiceImpl<RepairWarehouseMapper, RepairWarehouse> implements IRepairWarehouseService { // å®ä¹åæ³çåæ®µåç½åå private static final List<String> ALLOWED_COLUMNS = Arrays.asList( "fault_part", "fault_child_part", "repair_description" ); /** * ä¿åæ°æ® * @param repairWarehouse */ @Override public void add(RepairWarehouse repairWarehouse) { checkData(repairWarehouse); this.save(repairWarehouse); } @Override public void saveData(RepairWarehouse repairWarehouse) { RepairWarehouse warehouse = this.getOne(new LambdaQueryWrapper<RepairWarehouse>() .eq(RepairWarehouse::getFaultType, repairWarehouse.getFaultType()) .eq(RepairWarehouse::getFaultPart, repairWarehouse.getFaultPart()) .eq(RepairWarehouse::getFaultChildPart, repairWarehouse.getFaultChildPart()) .eq(RepairWarehouse::getRepairDescription, repairWarehouse.getRepairDescription()) ); if(Objects.isNull(warehouse)) { this.save(repairWarehouse); } } @Override public void edit(RepairWarehouse repairWarehouse) { checkData(repairWarehouse); this.updateById(repairWarehouse); } @Override public List<String> getColumnDateList(RepairWarehouse repairWarehouse) { if (StringUtils.isBlank(repairWarehouse.getColumn()) || !ALLOWED_COLUMNS.contains(repairWarehouse.getColumn())) { throw new JeecgBootException("æéæ¥è¯¢åæ®µå¼æ æ"); } return this.baseMapper.getColumnDateList(repairWarehouse); } private void checkData(RepairWarehouse repairWarehouse) { if(Objects.isNull(repairWarehouse)) { throw new JeecgBootException("æ°æ®ä¸è½ä¸ºç©º"); } if (StringUtils.isBlank(repairWarehouse.getFaultType())) { throw new JeecgBootException("æ éç±»åä¸è½ä¸ºç©º"); } if (StringUtils.isBlank(repairWarehouse.getFaultPart())) { throw new JeecgBootException("æ éé¨ä½ä¸è½ä¸ºç©º"); } if (StringUtils.isBlank(repairWarehouse.getFaultChildPart())) { throw new JeecgBootException("æ éåé¨ä½ä¸è½ä¸ºç©º"); } if (StringUtils.isBlank(repairWarehouse.getRepairDescription())) { throw new JeecgBootException("ç»´ä¿®æè¿°ä¸è½ä¸ºç©º"); } RepairWarehouse warehouse = this.getOne(new LambdaQueryWrapper<RepairWarehouse>() .eq(RepairWarehouse::getFaultType, repairWarehouse.getFaultType()) .eq(RepairWarehouse::getFaultPart, repairWarehouse.getFaultPart()) .eq(RepairWarehouse::getFaultChildPart, repairWarehouse.getFaultChildPart()) .eq(RepairWarehouse::getRepairDescription, repairWarehouse.getRepairDescription()) .le(StringUtils.isNotEmpty(repairWarehouse.getId()), RepairWarehouse::getId, repairWarehouse.getId()) ); if(Objects.nonNull(warehouse)) { throw new JeecgBootException("å·²åå¨è¯¥ç¥è¯åº"); } } } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/RepairWarehouseController.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,176 @@ package org.jeecg.modules.eam.controller; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.extern.slf4j.Slf4j; import org.jeecg.common.api.vo.Result; import org.jeecg.common.aspect.annotation.AutoLog; import org.jeecg.common.system.base.controller.JeecgController; import org.jeecg.common.system.query.QueryGenerator; import org.jeecg.modules.eam.entity.RepairWarehouse; import org.jeecg.modules.eam.service.IRepairWarehouseService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import org.springframework.web.servlet.ModelAndView; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.Arrays; import java.util.List; /** * @Description: eam_repair_warehouse * @Author: jeecg-boot * @Date: 2025-09-05 * @Version: V1.0 */ @Api(tags="ç»´ä¿®ç¥è¯åº") @RestController @RequestMapping("/repairWarehouse/repairWarehouse") @Slf4j public class RepairWarehouseController extends JeecgController<RepairWarehouse, IRepairWarehouseService> { @Autowired private IRepairWarehouseService repairWarehouseService; /** * å页å表æ¥è¯¢ * * @param repairWarehouse * @param pageNo * @param pageSize * @param req * @return */ //@AutoLog(value = "eam_repair_warehouse-å页å表æ¥è¯¢") @ApiOperation(value="eam_repair_warehouse-å页å表æ¥è¯¢", notes="eam_repair_warehouse-å页å表æ¥è¯¢") @GetMapping(value = "/list") public Result<IPage<RepairWarehouse>> queryPageList(RepairWarehouse repairWarehouse, @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, HttpServletRequest req) { QueryWrapper<RepairWarehouse> queryWrapper = QueryGenerator.initQueryWrapper(repairWarehouse, req.getParameterMap()); Page<RepairWarehouse> page = new Page<RepairWarehouse>(pageNo, pageSize); IPage<RepairWarehouse> pageList = repairWarehouseService.page(page, queryWrapper); return Result.OK(pageList); } /** * 设å¤ç»´ä¿®æµç¨-æ ¹æ®æ¥è¯¢æ¡ä»¶æ¥è¯¢æå®åæ®µæ°æ® * * @param repairWarehouse * @return */ //@AutoLog(value = "eam_repair_warehouse-å页å表æ¥è¯¢") @ApiOperation(value="æ ¹æ®æ¥è¯¢æ¡ä»¶æ¥è¯¢æå®åæ®µæ°æ®", notes="æ ¹æ®æ¥è¯¢æ¡ä»¶æ¥è¯¢æå®åæ®µæ°æ®") @GetMapping(value = "/getColumnDateList") public Result<?> getColumnDateList(RepairWarehouse repairWarehouse) { List<String> list = repairWarehouseService.getColumnDateList(repairWarehouse); return Result.OK(list); } /** * æ·»å * * @param repairWarehouse * @return */ @AutoLog(value = "eam_repair_warehouse-æ·»å ") @ApiOperation(value="eam_repair_warehouse-æ·»å ", notes="eam_repair_warehouse-æ·»å ") //@RequiresPermissions("org.jeecg.modules:eam_repair_warehouse:add") @PostMapping(value = "/add") public Result<String> add(@RequestBody RepairWarehouse repairWarehouse) { repairWarehouseService.add(repairWarehouse); return Result.OK("æ·»å æåï¼"); } /** * ç¼è¾ * * @param repairWarehouse * @return */ @AutoLog(value = "eam_repair_warehouse-ç¼è¾") @ApiOperation(value="eam_repair_warehouse-ç¼è¾", notes="eam_repair_warehouse-ç¼è¾") //@RequiresPermissions("org.jeecg.modules:eam_repair_warehouse:edit") @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) public Result<String> edit(@RequestBody RepairWarehouse repairWarehouse) { repairWarehouseService.edit(repairWarehouse); return Result.OK("ç¼è¾æå!"); } /** * éè¿idå é¤ * * @param id * @return */ @AutoLog(value = "eam_repair_warehouse-éè¿idå é¤") @ApiOperation(value="eam_repair_warehouse-éè¿idå é¤", notes="eam_repair_warehouse-éè¿idå é¤") //@RequiresPermissions("org.jeecg.modules:eam_repair_warehouse:delete") @DeleteMapping(value = "/delete") public Result<String> delete(@RequestParam(name="id",required=true) String id) { repairWarehouseService.removeById(id); return Result.OK("å 餿å!"); } /** * æ¹éå é¤ * * @param ids * @return */ @AutoLog(value = "eam_repair_warehouse-æ¹éå é¤") @ApiOperation(value="eam_repair_warehouse-æ¹éå é¤", notes="eam_repair_warehouse-æ¹éå é¤") //@RequiresPermissions("org.jeecg.modules:eam_repair_warehouse:deleteBatch") @DeleteMapping(value = "/deleteBatch") public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) { this.repairWarehouseService.removeByIds(Arrays.asList(ids.split(","))); return Result.OK("æ¹éå 餿å!"); } /** * éè¿idæ¥è¯¢ * * @param id * @return */ //@AutoLog(value = "eam_repair_warehouse-éè¿idæ¥è¯¢") @ApiOperation(value="eam_repair_warehouse-éè¿idæ¥è¯¢", notes="eam_repair_warehouse-éè¿idæ¥è¯¢") @GetMapping(value = "/queryById") public Result<RepairWarehouse> queryById(@RequestParam(name="id",required=true) String id) { RepairWarehouse repairWarehouse = repairWarehouseService.getById(id); if(repairWarehouse==null) { return Result.error("æªæ¾å°å¯¹åºæ°æ®"); } return Result.OK(repairWarehouse); } /** * 导åºexcel * * @param request * @param repairWarehouse */ //@RequiresPermissions("org.jeecg.modules:eam_repair_warehouse:exportXls") @RequestMapping(value = "/exportXls") public ModelAndView exportXls(HttpServletRequest request, RepairWarehouse repairWarehouse) { return super.exportXls(request, repairWarehouse, RepairWarehouse.class, "eam_repair_warehouse"); } /** * éè¿excelå¯¼å ¥æ°æ® * * @param request * @param response * @return */ //@RequiresPermissions("eam_repair_warehouse:importExcel") @RequestMapping(value = "/importExcel", method = RequestMethod.POST) public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { return super.importExcel(request, response, RepairWarehouse.class); } }