db/430É豸¹ÜÀíÊý¾Ý¿âÉè¼Æ.pdma.json
@@ -4,7 +4,7 @@ "avatar": "", "version": "4.9.2", "createdTime": "2025-3-10 16:38:19", "updatedTime": "2025-7-16 16:54:24", "updatedTime": "2025-7-16 17:21:35", "dbConns": [], "profile": { "default": { @@ -30136,6 +30136,24 @@ "baseType": "89D69E81-EA34-42EE-9FA2-93B8BD27E098" }, { "defKey": "change_order_id", "defName": "åæ´ID", "comment": "", "type": "", "len": "", "scale": "", "primaryKey": false, "notNull": false, "autoIncrement": false, "defaultValue": "", "hideInGraph": false, "refDict": "", "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64", "extProps": {}, "domain": "16120F75-6AA7-4483-868D-F07F511BB081", "id": "F4CA33AF-7AFC-481E-BC01-0263405029BE" }, { "defKey": "equipment_id", "defName": "设å¤ID", "comment": "", lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/TechnicalStatusChangeOrderStatusEnum.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,21 @@ package org.jeecg.modules.eam.constant; public enum TechnicalStatusChangeOrderStatusEnum { WAIT_SUBMIT, //å¾ æäº¤ DEPART_HEADER_SIGNING, //使ç¨åä½å®¤çº§ä¸»ç®¡ç¾åä¸ DEPART_LEADER_SIGNING, //使ç¨åä½é¨çº§ä¸»ç®¡ç¾åä¸ ABOLISH, //å·²ä½åº REJECTED, //已驳å COMPLETED, //已宿 ; public static TechnicalStatusChangeOrderStatusEnum getInstance(String code) { TechnicalStatusChangeOrderStatusEnum[] values = TechnicalStatusChangeOrderStatusEnum.values(); for (TechnicalStatusChangeOrderStatusEnum value : values) { if (value.name().equals(code)) { return value; } } return null; } } lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/TechnicalStatusChangeReasonEnum.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,19 @@ package org.jeecg.modules.eam.constant; public enum TechnicalStatusChangeReasonEnum { EQUIPMENT_MAJOR, //设å¤å¤§ä¿® EQUIPMENT_RELOCATION, //è®¾å¤æ¬è¿ EQUIPMENT_RETROFITTING, //è®¾å¤æ¹é OTHER, //å ¶ä» ; public static TechnicalStatusChangeReasonEnum getInstance(String code) { TechnicalStatusChangeReasonEnum[] values = TechnicalStatusChangeReasonEnum.values(); for (TechnicalStatusChangeReasonEnum value : values) { if (value.name().equals(code)) { return value; } } return null; } } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamTechnicalStatusChangeController.java
@@ -1,6 +1,6 @@ package org.jeecg.modules.eam.controller; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import cn.hutool.core.util.StrUtil; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import io.swagger.annotations.Api; @@ -9,16 +9,16 @@ 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.constant.TechnicalStatusChangeOrderStatusEnum; import org.jeecg.modules.eam.constant.TechnicalStatusEvaluationOrderChangeStatusEnum; import org.jeecg.modules.eam.entity.EamTechnicalStatusChange; import org.jeecg.modules.eam.request.EamTechnicalStatusChangeQuery; import org.jeecg.modules.eam.request.EamTechnicalStatusChangeRequest; import org.jeecg.modules.eam.service.IEamTechnicalStatusChangeService; 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; /** * @Description: ææ¯ç¶æåæ´ç³è¯· @@ -37,7 +37,7 @@ /** * å页å表æ¥è¯¢ * * @param eamTechnicalStatusChange * @param query * @param pageNo * @param pageSize * @param req @@ -45,72 +45,100 @@ */ @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·-å页å表æ¥è¯¢", notes="ææ¯ç¶æåæ´ç³è¯·-å页å表æ¥è¯¢") @GetMapping(value = "/list") public Result<?> queryPageList(EamTechnicalStatusChange eamTechnicalStatusChange, public Result<?> queryPageList(EamTechnicalStatusChangeQuery query, @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, HttpServletRequest req) { QueryWrapper<EamTechnicalStatusChange> queryWrapper = QueryGenerator.initQueryWrapper(eamTechnicalStatusChange, req.getParameterMap()); Page<EamTechnicalStatusChange> page = new Page<EamTechnicalStatusChange>(pageNo, pageSize); IPage<EamTechnicalStatusChange> pageList = eamTechnicalStatusChangeService.page(page, queryWrapper); IPage<EamTechnicalStatusChange> pageList = eamTechnicalStatusChangeService.queryPageList(page, query); return Result.OK(pageList); } /** * æ·»å * * @param eamTechnicalStatusChange * @param request * @return */ @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·-æ·»å ") @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·-æ·»å ", notes="ææ¯ç¶æåæ´ç³è¯·-æ·»å ") @PostMapping(value = "/add") public Result<?> add(@RequestBody EamTechnicalStatusChange eamTechnicalStatusChange) { eamTechnicalStatusChangeService.save(eamTechnicalStatusChange); public Result<?> add(@RequestBody EamTechnicalStatusChangeRequest request) { if (request == null) { return Result.error("æ·»å ç对象ä¸è½ä¸ºç©ºï¼"); } boolean b = eamTechnicalStatusChangeService.addEamTechnicalStatusChange(request); if (!b) { return Result.error("æ·»å 失败ï¼"); } return Result.OK("æ·»å æåï¼"); } /** * ç¼è¾ * * @param eamTechnicalStatusChange * @param request * @return */ @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·-ç¼è¾") @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·-ç¼è¾", notes="ææ¯ç¶æåæ´ç³è¯·-ç¼è¾") @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) public Result<?> edit(@RequestBody EamTechnicalStatusChange eamTechnicalStatusChange) { eamTechnicalStatusChangeService.updateById(eamTechnicalStatusChange); public Result<?> edit(@RequestBody EamTechnicalStatusChangeRequest request) { if (request == null) { return Result.error("ç¼è¾ç对象ä¸è½ä¸ºç©ºï¼"); } boolean b = eamTechnicalStatusChangeService.editEamTechnicalStatusChange(request); if (!b) { return Result.error("ç¼è¾å¤±è´¥ï¼"); } return Result.OK("ç¼è¾æå!"); } /** * éè¿idå é¤ * * @param id * @return */ @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·-éè¿idå é¤") @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·-éè¿idå é¤", notes="ææ¯ç¶æåæ´ç³è¯·-éè¿idå é¤") @DeleteMapping(value = "/delete") public Result<?> delete(@RequestParam(name="id",required=true) String id) { eamTechnicalStatusChangeService.removeById(id); return Result.OK("å 餿å!"); } /** * æ¹éå é¤ * * @param ids * @return */ @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·-æ¹éå é¤") @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·-æ¹éå é¤", notes="ææ¯ç¶æåæ´ç³è¯·-æ¹éå é¤") @DeleteMapping(value = "/deleteBatch") public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) { this.eamTechnicalStatusChangeService.removeByIds(Arrays.asList(ids.split(","))); return Result.OK("æ¹éå 餿åï¼"); } @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·-æäº¤") @ApiOperation(value = "ææ¯ç¶æåæ´ç³è¯·-æäº¤", notes = "ææ¯ç¶æåæ´ç³è¯·-æäº¤") @GetMapping("/submit") public Result<?> submit(@RequestParam(name = "id") String id) { boolean b = eamTechnicalStatusChangeService.submit(id); if (!b) { return Result.error("æäº¤å¤±è´¥ï¼"); } return Result.OK("æäº¤æå!"); } @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·-ä½åº") @ApiOperation(value = "ææ¯ç¶æåæ´ç³è¯·-ä½åº", notes = "ææ¯ç¶æåæ´ç³è¯·-ä½åº") @GetMapping("/abolish") public Result<?> abolish(@RequestParam(name = "id") String id) { EamTechnicalStatusChange entity = eamTechnicalStatusChangeService.getById(id); if (entity == null) { return Result.error("è¦ä½åºçæ°æ®ä¸åå¨ï¼è¯·å·æ°éè¯ï¼"); } if (!TechnicalStatusEvaluationOrderChangeStatusEnum.WAIT_SUBMIT.name().equals(entity.getChangeStatus())) { return Result.error("è¯¥ç¶æçæ°æ®ä¸å 许è¿è¡ä½åºï¼"); } entity.setChangeStatus(TechnicalStatusChangeOrderStatusEnum.ABOLISH.name()); eamTechnicalStatusChangeService.updateById(entity); return Result.OK("ä½åºæå!"); } @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·-审æ¹") @ApiOperation(value = "ææ¯ç¶æåæ´ç³è¯·-审æ¹", notes = "ææ¯ç¶æåæ´ç³è¯·-审æ¹") @PostMapping("/approval") public Result<?> approval(@RequestBody EamTechnicalStatusChangeRequest request) { if (request == null) { return Result.error("审æ¹ç对象ä¸è½ä¸ºç©ºï¼"); } // æ£æ¥è¯·æ±åæ° if (StrUtil.isBlank(request.getTaskId()) || StrUtil.isBlank(request.getDataId()) || StrUtil.isBlank(request.getInstanceId())) { return Result.error("审æ¹ä»»å¡é误æä¸åå¨ï¼"); } EamTechnicalStatusChange b = eamTechnicalStatusChangeService.approval(request); if (b == null) { return Result.error("æä½å¤±è´¥ï¼"); } return Result.ok("æä½æåï¼"); } /** * éè¿idæ¥è¯¢ * @@ -124,28 +152,5 @@ EamTechnicalStatusChange eamTechnicalStatusChange = eamTechnicalStatusChangeService.getById(id); return Result.OK(eamTechnicalStatusChange); } /** * 导åºexcel * * @param request * @param eamTechnicalStatusChange */ @RequestMapping(value = "/exportXls") public ModelAndView exportXls(HttpServletRequest request, EamTechnicalStatusChange eamTechnicalStatusChange) { return super.exportXls(request, eamTechnicalStatusChange, EamTechnicalStatusChange.class, "ææ¯ç¶æåæ´ç³è¯·"); } /** * éè¿excelå¯¼å ¥æ°æ® * * @param request * @param response * @return */ @RequestMapping(value = "/importExcel", method = RequestMethod.POST) public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { return super.importExcel(request, response, EamTechnicalStatusChange.class); } } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamTechnicalStatusChangeDetailController.java
@@ -1,151 +1,44 @@ 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.EamTechnicalStatusChangeDetail; import org.jeecg.modules.eam.service.IEamTechnicalStatusChangeDetailService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import org.springframework.web.servlet.ModelAndView; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.Arrays; import java.util.List; /** /** * @Description: ææ¯ç¶æåæ´ç³è¯·æç» * @Author: jeecg-boot * @Date: 2025-07-09 * @Date: 2025-07-09 * @Version: V1.0 */ @Slf4j @Api(tags="ææ¯ç¶æåæ´ç³è¯·æç»") @Api(tags = "ææ¯ç¶æåæ´ç³è¯·æç»") @RestController @RequestMapping("/eam/eamTechnicalStatusChangeDetail") public class EamTechnicalStatusChangeDetailController extends JeecgController<EamTechnicalStatusChangeDetail, IEamTechnicalStatusChangeDetailService> { @Autowired private IEamTechnicalStatusChangeDetailService eamTechnicalStatusChangeDetailService; /** * å页å表æ¥è¯¢ * * @param eamTechnicalStatusChangeDetail * @param pageNo * @param pageSize * @param req * @return */ @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·æç»-å页å表æ¥è¯¢", notes="ææ¯ç¶æåæ´ç³è¯·æç»-å页å表æ¥è¯¢") @GetMapping(value = "/list") public Result<?> queryPageList(EamTechnicalStatusChangeDetail eamTechnicalStatusChangeDetail, @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, HttpServletRequest req) { QueryWrapper<EamTechnicalStatusChangeDetail> queryWrapper = QueryGenerator.initQueryWrapper(eamTechnicalStatusChangeDetail, req.getParameterMap()); Page<EamTechnicalStatusChangeDetail> page = new Page<EamTechnicalStatusChangeDetail>(pageNo, pageSize); IPage<EamTechnicalStatusChangeDetail> pageList = eamTechnicalStatusChangeDetailService.page(page, queryWrapper); return Result.OK(pageList); } /** * æ·»å * * @param eamTechnicalStatusChangeDetail * @return */ @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·æç»-æ·»å ") @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·æç»-æ·»å ", notes="ææ¯ç¶æåæ´ç³è¯·æç»-æ·»å ") @PostMapping(value = "/add") public Result<?> add(@RequestBody EamTechnicalStatusChangeDetail eamTechnicalStatusChangeDetail) { eamTechnicalStatusChangeDetailService.save(eamTechnicalStatusChangeDetail); return Result.OK("æ·»å æåï¼"); } /** * ç¼è¾ * * @param eamTechnicalStatusChangeDetail * @return */ @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·æç»-ç¼è¾") @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·æç»-ç¼è¾", notes="ææ¯ç¶æåæ´ç³è¯·æç»-ç¼è¾") @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) public Result<?> edit(@RequestBody EamTechnicalStatusChangeDetail eamTechnicalStatusChangeDetail) { eamTechnicalStatusChangeDetailService.updateById(eamTechnicalStatusChangeDetail); return Result.OK("ç¼è¾æå!"); } /** * éè¿idå é¤ * * @param id * @return */ @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·æç»-éè¿idå é¤") @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·æç»-éè¿idå é¤", notes="ææ¯ç¶æåæ´ç³è¯·æç»-éè¿idå é¤") @DeleteMapping(value = "/delete") public Result<?> delete(@RequestParam(name="id",required=true) String id) { eamTechnicalStatusChangeDetailService.removeById(id); return Result.OK("å 餿å!"); } /** * æ¹éå é¤ * * @param ids * @return */ @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·æç»-æ¹éå é¤") @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·æç»-æ¹éå é¤", notes="ææ¯ç¶æåæ´ç³è¯·æç»-æ¹éå é¤") @DeleteMapping(value = "/deleteBatch") public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) { this.eamTechnicalStatusChangeDetailService.removeByIds(Arrays.asList(ids.split(","))); return Result.OK("æ¹éå 餿åï¼"); } /** * éè¿idæ¥è¯¢ * * @param id * @return */ @AutoLog(value = "ææ¯ç¶æåæ´ç³è¯·æç»-éè¿idæ¥è¯¢") @ApiOperation(value="ææ¯ç¶æåæ´ç³è¯·æç»-éè¿idæ¥è¯¢", notes="ææ¯ç¶æåæ´ç³è¯·æç»-éè¿idæ¥è¯¢") @GetMapping(value = "/queryById") public Result<?> queryById(@RequestParam(name="id",required=true) String id) { EamTechnicalStatusChangeDetail eamTechnicalStatusChangeDetail = eamTechnicalStatusChangeDetailService.getById(id); return Result.OK(eamTechnicalStatusChangeDetail); } @Autowired private IEamTechnicalStatusChangeDetailService orderDetailService; /** * 导åºexcel * * @param request * @param eamTechnicalStatusChangeDetail */ @RequestMapping(value = "/exportXls") public ModelAndView exportXls(HttpServletRequest request, EamTechnicalStatusChangeDetail eamTechnicalStatusChangeDetail) { return super.exportXls(request, eamTechnicalStatusChangeDetail, EamTechnicalStatusChangeDetail.class, "ææ¯ç¶æåæ´ç³è¯·æç»"); } /** * éè¿excelå¯¼å ¥æ°æ® * * @param request * @param response * @return */ @RequestMapping(value = "/importExcel", method = RequestMethod.POST) public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { return super.importExcel(request, response, EamTechnicalStatusChangeDetail.class); } /** * 䏿¬¡å è½½ * * @param orderId * @return */ @ApiOperation(value = "ææ¯ç¶æåæ´ç³è¯·æç»-ä¸å页å表æ¥è¯¢", notes = "ææ¯ç¶æåæ´ç³è¯·æç»-ä¸å页å表æ¥è¯¢") @GetMapping(value = "/queryList") public Result<?> queryList(@RequestParam("orderId") String orderId) { List<EamTechnicalStatusChangeDetail> list = orderDetailService.queryList(orderId); return Result.OK(list); } } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamTechnicalStatusChange.java
@@ -49,6 +49,9 @@ /**åæ´åç¶æ*/ @ApiModelProperty(value = "åæ´åç¶æ") private String changeStatus; /**ç³è¯·åä½*/ @ApiModelProperty(value = "ç³è¯·åä½") private String factoryOrgCode; /**ç¼å¶äºº*/ @ApiModelProperty(value = "ç¼å¶äºº") private String designer; @@ -61,19 +64,28 @@ /**使ç¨åä½å®¤ä¸»ç®¡ç¾åæ¶é´*/ @ApiModelProperty(value = "使ç¨åä½å®¤ä¸»ç®¡ç¾åæ¶é´") private Date departHeaderSignatureTime; /**使ç¨åä½å®¤ä¸»ç®¡ç¾åç»æ*/ @ApiModelProperty(value = "使ç¨åä½å®¤ä¸»ç®¡ç¾åç»æ") private String departHeaderSignatureResult; /**使ç¨åä½å®¤ä¸»ç®¡æè§*/ @ApiModelProperty(value = "使ç¨åä½å®¤ä¸»ç®¡æè§") private String departHeaderSignatureComment; private String departHeaderComment; /**使ç¨åä½é¨ä¸»ç®¡ç¾å*/ @ApiModelProperty(value = "使ç¨åä½é¨ä¸»ç®¡ç¾å") private String departLeaderSignature; /**使ç¨åä½é¨ä¸»ç®¡ç¾åæ¶é´*/ @ApiModelProperty(value = "使ç¨åä½é¨ä¸»ç®¡ç¾åæ¶é´") private Date departLeaderSignatureTime; /**使ç¨åä½é¨ä¸»ç®¡ç¾åç»æ*/ @ApiModelProperty(value = "使ç¨åä½é¨ä¸»ç®¡ç¾åç»æ") private String departLeaderSignatureResult; /**使ç¨åä½é¨ä¸»ç®¡ç¾å*/ @ApiModelProperty(value = "使ç¨åä½é¨ä¸»ç®¡ç¾å") private String departLeaderSignatureComment; private String departLeaderComment; /**HFç¼ç */ @ApiModelProperty(value = "HFç¼ç ") private String hfCode; /**夿³¨*/ @ApiModelProperty(value = "夿³¨") private String remark; } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamTechnicalStatusChangeDetail.java
@@ -1,6 +1,7 @@ package org.jeecg.modules.eam.entity; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import io.swagger.annotations.ApiModel; @@ -40,6 +41,9 @@ /**æ´æ°æ¶é´*/ @ApiModelProperty(value = "æ´æ°æ¶é´") private Date updateTime; /**åæ´åID*/ @ApiModelProperty(value = "åæ´åID") private String changeOrderId; /**设å¤ID*/ @ApiModelProperty(value = "设å¤ID") private String equipmentId; @@ -64,4 +68,14 @@ /**ææ¯ç¶æé´å®å·¥åID;æ¬è¿ä½¿ç¨*/ @ApiModelProperty(value = "ææ¯ç¶æé´å®å·¥åID;æ¬è¿ä½¿ç¨") private String orderId; //å表å±ç¤º @TableField(exist = false) private String equipmentCode; @TableField(exist = false) private String equipmentName; @TableField(exist = false) private String equipmentModel; @TableField(exist = false) private String factoryName; } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/EamTechnicalStatusChangeDetailMapper.java
@@ -2,6 +2,8 @@ import java.util.List; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Constants; import org.apache.ibatis.annotations.Param; import org.jeecg.modules.eam.entity.EamTechnicalStatusChangeDetail; import com.baomidou.mybatisplus.core.mapper.BaseMapper; @@ -14,4 +16,10 @@ */ public interface EamTechnicalStatusChangeDetailMapper extends BaseMapper<EamTechnicalStatusChangeDetail> { /** * è®¾å¤æç»æ¥è¯¢ * @param queryWrapper * @return */ List<EamTechnicalStatusChangeDetail> queryList(@Param(Constants.WRAPPER) QueryWrapper<EamTechnicalStatusChangeDetail> queryWrapper); } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EamTechnicalStatusChangeDetailMapper.xml
@@ -2,4 +2,13 @@ <!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.EamTechnicalStatusChangeDetailMapper"> <select id="queryList" resultType="org.jeecg.modules.eam.entity.EamTechnicalStatusChangeDetail"> select ems.*, e.equipment_code, e.equipment_name, e.equipment_model, f.factory_name from eam_technical_status_change_detail ems inner join eam_equipment e on ems.equipment_id = e.id left join eam_base_factory f on e.factory_org_code = f.org_code ${ew.customSqlSegment} </select> </mapper> lxzn-module-eam/src/main/java/org/jeecg/modules/eam/request/EamTechnicalStatusChangeQuery.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,23 @@ package org.jeecg.modules.eam.request; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.util.Date; @Data public class EamTechnicalStatusChangeQuery { private String changeOrderNum; @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") private Date dateBegin; @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") @DateTimeFormat(pattern = "yyyy-MM-dd") private Date dateEnd; private String changeStatus; private String factoryOrgCode; private String column; private String order; } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/request/EamTechnicalStatusChangeRequest.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,40 @@ package org.jeecg.modules.eam.request; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; import lombok.experimental.Accessors; import org.jeecg.modules.eam.entity.EamTechnicalStatusChangeDetail; import org.jeecg.modules.flowable.domain.vo.FlowTaskVo; import java.io.Serializable; import java.util.List; @Data @EqualsAndHashCode(callSuper = false) @Accessors(chain = true) @ApiModel(value="ææ¯ç¶æåæ´å®¡æ¹å¯¹è±¡", description="ææ¯ç¶æåæ´å®¡æ¹") public class EamTechnicalStatusChangeRequest extends FlowTaskVo implements Serializable { /**主é®*/ @ApiModelProperty(value = "主é®") private String id; /**使ç¨åä½å®¤ä¸»ç®¡ç¾åç»æ*/ @ApiModelProperty(value = "使ç¨åä½å®¤ä¸»ç®¡ç¾åç»æ") private String departHeaderSignatureResult; /**使ç¨åä½å®¤ä¸»ç®¡æè§*/ @ApiModelProperty(value = "使ç¨åä½å®¤ä¸»ç®¡æè§") private String departHeaderComment; /**使ç¨åä½é¨ä¸»ç®¡ç¾åç»æ*/ @ApiModelProperty(value = "使ç¨åä½é¨ä¸»ç®¡ç¾åç»æ") private String departLeaderSignatureResult; /**使ç¨åä½é¨ä¸»ç®¡ç¾å*/ @ApiModelProperty(value = "使ç¨åä½é¨ä¸»ç®¡ç¾å") private String departLeaderComment; /**夿³¨*/ @ApiModelProperty(value = "夿³¨") private String remark; /**å表 è®¾å¤æç»*/ @ApiModelProperty(value = "å表 è®¾å¤æç»") private List<EamTechnicalStatusChangeDetail> tableDetailList; } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IEamTechnicalStatusChangeDetailService.java
@@ -3,6 +3,8 @@ import org.jeecg.modules.eam.entity.EamTechnicalStatusChangeDetail; import com.baomidou.mybatisplus.extension.service.IService; import java.util.List; /** * @Description: ææ¯ç¶æåæ´ç³è¯·æç» * @Author: jeecg-boot @@ -11,4 +13,10 @@ */ public interface IEamTechnicalStatusChangeDetailService extends IService<EamTechnicalStatusChangeDetail> { /** * æ¥è¯¢è®¾å¤æç» * @param orderId * @return */ List<EamTechnicalStatusChangeDetail> queryList(String orderId); } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/IEamTechnicalStatusChangeService.java
@@ -1,7 +1,11 @@ package org.jeecg.modules.eam.service; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import org.jeecg.modules.eam.entity.EamTechnicalStatusChange; import com.baomidou.mybatisplus.extension.service.IService; import org.jeecg.modules.eam.request.EamTechnicalStatusChangeQuery; import org.jeecg.modules.eam.request.EamTechnicalStatusChangeRequest; /** * @Description: ææ¯ç¶æåæ´ç³è¯· @@ -11,4 +15,37 @@ */ public interface IEamTechnicalStatusChangeService extends IService<EamTechnicalStatusChange> { /** * å页æ¥è¯¢ * @param page * @param query * @return */ IPage<EamTechnicalStatusChange> queryPageList(Page<EamTechnicalStatusChange> page, EamTechnicalStatusChangeQuery query); /** * æ°å¢ * @param request */ boolean addEamTechnicalStatusChange(EamTechnicalStatusChangeRequest request); /** * ç¼è¾ * @param request */ boolean editEamTechnicalStatusChange(EamTechnicalStatusChangeRequest request); /** * æäº¤ * @param id * @return */ boolean submit(String id); /** * å®¡æ¹ * @param request * @return */ EamTechnicalStatusChange approval(EamTechnicalStatusChangeRequest request); } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamTechnicalStatusChangeDetailServiceImpl.java
@@ -1,11 +1,14 @@ package org.jeecg.modules.eam.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import org.jeecg.modules.eam.entity.EamTechnicalStatusChangeDetail; import org.jeecg.modules.eam.mapper.EamTechnicalStatusChangeDetailMapper; import org.jeecg.modules.eam.service.IEamTechnicalStatusChangeDetailService; import org.springframework.stereotype.Service; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import java.util.List; /** * @Description: ææ¯ç¶æåæ´ç³è¯·æç» @@ -16,4 +19,11 @@ @Service public class EamTechnicalStatusChangeDetailServiceImpl extends ServiceImpl<EamTechnicalStatusChangeDetailMapper, EamTechnicalStatusChangeDetail> implements IEamTechnicalStatusChangeDetailService { @Override public List<EamTechnicalStatusChangeDetail> queryList(String changeOrderId) { QueryWrapper<EamTechnicalStatusChangeDetail> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("ems.change_order_id", changeOrderId); queryWrapper.orderByAsc("ems.create_time"); return this.getBaseMapper().queryList(queryWrapper); } } lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamTechnicalStatusChangeServiceImpl.java
@@ -1,11 +1,36 @@ package org.jeecg.modules.eam.service.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.apache.commons.lang3.StringUtils; import org.apache.shiro.SecurityUtils; import org.jeecg.common.constant.CommonConstant; import org.jeecg.common.constant.DataBaseConstant; import org.jeecg.common.system.vo.LoginUser; import org.jeecg.common.util.oConvertUtils; import org.jeecg.modules.eam.entity.EamTechnicalStatusChange; import org.jeecg.modules.eam.mapper.EamTechnicalStatusChangeMapper; import org.jeecg.modules.eam.request.EamTechnicalStatusChangeQuery; import org.jeecg.modules.eam.request.EamTechnicalStatusChangeRequest; import org.jeecg.modules.eam.service.IEamTechnicalStatusChangeService; import org.jeecg.modules.flowable.apithird.business.entity.FlowMyBusiness; import org.jeecg.modules.flowable.apithird.service.FlowCallBackServiceI; import org.jeecg.modules.system.entity.BaseFactory; import org.jeecg.modules.system.entity.BaseFactoryUser; import org.jeecg.modules.system.service.IBaseFactoryService; import org.jeecg.modules.system.service.IBaseFactoryUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import java.util.List; import java.util.Map; import java.util.Set; import java.util.stream.Collectors; /** * @Description: ææ¯ç¶æåæ´ç³è¯· @@ -13,7 +38,113 @@ * @Date: 2025-07-09 * @Version: V1.0 */ @Service public class EamTechnicalStatusChangeServiceImpl extends ServiceImpl<EamTechnicalStatusChangeMapper, EamTechnicalStatusChange> implements IEamTechnicalStatusChangeService { @Service("IEamTechnicalStatusChangeService") public class EamTechnicalStatusChangeServiceImpl extends ServiceImpl<EamTechnicalStatusChangeMapper, EamTechnicalStatusChange> implements IEamTechnicalStatusChangeService, FlowCallBackServiceI { @Autowired private IBaseFactoryUserService baseFactoryUserService; @Autowired private IBaseFactoryService baseFactoryService; @Override public IPage<EamTechnicalStatusChange> queryPageList(Page<EamTechnicalStatusChange> page, EamTechnicalStatusChangeQuery query) { QueryWrapper<EamTechnicalStatusChange> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("del_flag", CommonConstant.DEL_FLAG_0); //ç¨æ·æ°æ®æé LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal(); if (sysUser == null) { return page; } //æ ¹æ®ä¸å¿è¿æ»¤æ°æ®æé List<BaseFactoryUser> baseFactoryUserList = baseFactoryUserService. list(new LambdaQueryWrapper<BaseFactoryUser>().eq(BaseFactoryUser::getUserId, sysUser.getId())); if (!CollectionUtils.isEmpty(baseFactoryUserList)) { Set<String> factoryIds = baseFactoryUserList.stream().map(BaseFactoryUser::getFactoryId).collect(Collectors.toSet()); Set<String> factoryCodeList = baseFactoryService.listByIds(factoryIds).stream().map(BaseFactory::getOrgCode).collect(Collectors.toSet()); queryWrapper.in("factory_org_code", factoryCodeList); } else { return page; } if (query != null) { //ç¼ç æ¨¡ç³æ¥è¯¢ if (StringUtils.isNotBlank(query.getChangeOrderNum())) { queryWrapper.like("change_order_num", query.getChangeOrderNum()); } //ä¿å »åç±» if (StringUtils.isNotBlank(query.getChangeStatus())) { queryWrapper.eq("change_status", query.getChangeStatus()); } if (query.getDateBegin() != null && query.getDateEnd() != null) { queryWrapper.between("designer_time", query.getDateBegin(), query.getDateEnd()); } //ç³è¯·åä½ if(StringUtils.isNotBlank(query.getFactoryOrgCode())) { queryWrapper.eq("factory_org_code", query.getFactoryOrgCode()); } //æåº if (StringUtils.isNotBlank(query.getColumn()) && StringUtils.isNotBlank(query.getOrder())) { String column = query.getColumn(); if (column.endsWith(CommonConstant.DICT_TEXT_SUFFIX)) { column = column.substring(0, column.lastIndexOf(CommonConstant.DICT_TEXT_SUFFIX)); } if (DataBaseConstant.SQL_ASC.equalsIgnoreCase(query.getOrder())) { queryWrapper.orderByAsc(oConvertUtils.camelToUnderline(column)); } else { queryWrapper.orderByDesc(oConvertUtils.camelToUnderline(column)); } } else { queryWrapper.orderByDesc("create_time"); } } else { queryWrapper.orderByDesc("create_time"); } return this.getBaseMapper().selectPage(page, queryWrapper); } @Override @Transactional(rollbackFor = Exception.class) public boolean addEamTechnicalStatusChange(EamTechnicalStatusChangeRequest request) { return false; } @Override @Transactional(rollbackFor = Exception.class) public boolean editEamTechnicalStatusChange(EamTechnicalStatusChangeRequest request) { return false; } @Override @Transactional(rollbackFor = Exception.class) public boolean submit(String id) { return false; } @Override @Transactional(rollbackFor = Exception.class) public EamTechnicalStatusChange approval(EamTechnicalStatusChangeRequest request) { return null; } @Override public void afterFlowHandle(FlowMyBusiness business) { business.getTaskNameId();//æ¥ä¸æ¥å®¡æ¹çèç¹ business.getValues();//åç«¯ä¼ è¿æ¥çåæ° business.getActStatus(); } @Override public Object getBusinessDataById(String dataId) { return this.getById(dataId); } @Override public Map<String, Object> flowValuesOfTask(String taskNameId, Map<String, Object> values) { return null; } @Override public List<String> flowCandidateUsernamesOfTask(String taskNameId, Map<String, Object> values) { //ä¸å¡æ¯å¦å¹²é¢æµç¨ï¼ä¸å¡å¹²é¢ï¼æµç¨å¹²é¢ï¼æå®äººåè¿è¡å¤ç //è·åä¸ä¸æ¥å¤ç人 Object object = values.get("NextAssignee"); return (List<String>) object; } }