From 9a5d87509968d7d7c5b475171daa2ad8f977c272 Mon Sep 17 00:00:00 2001 From: liurunyu <lry9898@163.com> Date: 星期四, 14 十一月 2024 14:50:06 +0800 Subject: [PATCH] Merge branch 'master' of http://8.140.179.55:20000/r/pipIrr-SV --- pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/resources/application.yml | 8 ++ pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueSv.java | 29 +++++++++ pipIrr-platform/pipIrr-global/src/main/resources/mapper/OpeReportReplyMapper.xml | 12 ++++ pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueCtrl.java | 18 ++++++ pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoOp/OpeReportReplyMapper.java | 8 ++ pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voOp/VoIssueReportReply.java | 45 +++++++++++++++ pipIrr-platform/pipIrr-global/src/main/resources/application-global.yml | 2 pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml | 4 pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/workOrder/ConsumerListener.java | 2 9 files changed, 123 insertions(+), 5 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoOp/OpeReportReplyMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoOp/OpeReportReplyMapper.java index 2617f96..5df18c0 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoOp/OpeReportReplyMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoOp/OpeReportReplyMapper.java @@ -2,6 +2,7 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.dy.pipIrrGlobal.pojoOp.OpeReportReply; +import com.dy.pipIrrGlobal.voOp.VoIssueReportReply; import org.apache.ibatis.annotations.Mapper; /** @@ -24,4 +25,11 @@ int updateByPrimaryKeySelective(OpeReportReply record); int updateByPrimaryKey(OpeReportReply record); + + /** + * 鏍规嵁闂涓婃姤ID鑾峰彇涓婃姤鍥炲淇℃伅 + * @param reportId + * @return + */ + VoIssueReportReply getReportReplyByReportId(Long reportId); } \ No newline at end of file diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voOp/VoIssueReportReply.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voOp/VoIssueReportReply.java new file mode 100644 index 0000000..cf0572e --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voOp/VoIssueReportReply.java @@ -0,0 +1,45 @@ +package com.dy.pipIrrGlobal.voOp; + +import com.alibaba.fastjson2.annotation.JSONField; +import com.alibaba.fastjson2.writer.ObjectWriterImplToString; +import com.dy.common.po.BaseEntity; +import com.fasterxml.jackson.annotation.JsonFormat; +import com.fasterxml.jackson.annotation.JsonPropertyOrder; +import lombok.Data; + +import java.util.Date; + +/** + * @author ZhuBaoMin + * @date 2024-11-14 11:25 + * @LastEditTime 2024-11-14 11:25 + * @Description 宸℃鍛橀棶棰樹笂鎶ュ洖澶嶈鍥惧璞� + */ + +@Data +@JsonPropertyOrder({"replyContent", "replyTime", "replierId", "replier"}) +public class VoIssueReportReply implements BaseEntity { + private static final long serialVersionUID = 202411141126001L; + + /** + * 鍥炲鍐呭 + */ + private String replyContent; + + /** + * 鍥炲鏃堕棿 + */ + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + private Date replyTime; + + /** + * 鍥炲浜篒D + */ + @JSONField(serializeUsing= ObjectWriterImplToString.class) + private Long replierId; + + /** + * 鍥炲浜哄鍚� + */ + private String replier; +} diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml index 80e789b..ed9eb26 100644 --- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml +++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml @@ -5,9 +5,9 @@ #name: ym type: com.alibaba.druid.pool.DruidDataSource driverClassName: com.mysql.cj.jdbc.Driver - url: jdbc:mysql://192.168.40.166:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull +# url: jdbc:mysql://192.168.40.166:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull # url: jdbc:mysql://8.130.130.233:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull -# url: jdbc:mysql://127.0.0.1:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull + url: jdbc:mysql://127.0.0.1:3306/pipIrr_ym?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull username: root password: dysql,;.abc!@# druid: diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-global.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-global.yml index 8f11670..5e8b483 100644 --- a/pipIrr-platform/pipIrr-global/src/main/resources/application-global.yml +++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-global.yml @@ -77,7 +77,7 @@ pipIrr: global: - dev: true #鏄惁寮�鍙戦樁娈碉紝true鎴杅alse + dev: false #鏄惁寮�鍙戦樁娈碉紝true鎴杅alse dsName: ym #寮�鍙戦樁娈碉紝璁剧疆涓存椂鐨勬暟鎹簱鍚嶇О nginx: webPort: 54321 diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/OpeReportReplyMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/OpeReportReplyMapper.xml index 355f48d..78ef237 100644 --- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/OpeReportReplyMapper.xml +++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/OpeReportReplyMapper.xml @@ -99,4 +99,16 @@ replier_id = #{replierId,jdbcType=BIGINT} where id = #{id,jdbcType=BIGINT} </update> + + <!--鏍规嵁闂涓婃姤ID鑾峰彇涓婃姤鍥炲淇℃伅--> + <select id="getReportReplyByReportId" resultType="com.dy.pipIrrGlobal.voOp.VoIssueReportReply"> + SELECT + rpy.reply_content AS replyContent, + rpy.reply_time AS replyTime, + rpy.replier_id AS replierId, + user.name AS replier + FROM ope_report_reply rpy + INNER JOIN ba_user user ON user.id = rpy.replier_id + WHERE rpy.report_id = #{reportId} + </select> </mapper> \ No newline at end of file diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueCtrl.java b/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueCtrl.java index 3b40503..6f67db7 100644 --- a/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueCtrl.java +++ b/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueCtrl.java @@ -1,5 +1,6 @@ package com.dy.pipIrrApp.issue; +import com.alibaba.fastjson2.JSONObject; import com.dy.common.aop.SsoAop; import com.dy.common.webUtil.BaseResponse; import com.dy.common.webUtil.BaseResponseUtils; @@ -9,6 +10,7 @@ import com.dy.pipIrrGlobal.pojoOp.OpeIssueReport; import com.dy.pipIrrGlobal.pojoOp.OpeReportReply; import com.dy.pipIrrGlobal.voOp.VoIssueReport; +import com.dy.pipIrrGlobal.voOp.VoIssueReportReply; import jakarta.validation.Valid; import lombok.RequiredArgsConstructor; import lombok.extern.slf4j.Slf4j; @@ -114,5 +116,21 @@ return BaseResponseUtils.buildSuccess() ; } + /** + * 鏍规嵁闂涓婃姤ID鑾峰彇涓婃姤鍥炲淇℃伅 + * @param reportId + * @return + */ + @GetMapping(path = "/getReportReply") + public BaseResponse<VoIssueReportReply> getReportReply(@RequestParam("reportId") Long reportId) { + + JSONObject result = issueSv.getReportReply(reportId); + if(!result.get("code").equals("0001")) { + return BaseResponseUtils.buildErrorMsg(result.get("msg").toString()); + } + + return BaseResponseUtils.buildSuccess(result.get("data")); + + } } diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueSv.java b/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueSv.java index 828da25..5787d84 100644 --- a/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueSv.java +++ b/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/issue/IssueSv.java @@ -1,6 +1,8 @@ package com.dy.pipIrrApp.issue; +import com.alibaba.fastjson2.JSONObject; import com.dy.common.webUtil.QueryResultVo; +import com.dy.common.webUtil.ResultCodeMsg; import com.dy.pipIrrApp.issue.dto.DtoDeleteParam; import com.dy.pipIrrApp.issue.qo.QoIssueReport; import com.dy.pipIrrGlobal.daoOp.OpeIssueReportMapper; @@ -8,6 +10,7 @@ import com.dy.pipIrrGlobal.pojoOp.OpeIssueReport; import com.dy.pipIrrGlobal.pojoOp.OpeReportReply; import com.dy.pipIrrGlobal.voOp.VoIssueReport; +import com.dy.pipIrrGlobal.voOp.VoIssueReportReply; import lombok.extern.slf4j.Slf4j; import org.apache.dubbo.common.utils.PojoUtils; import org.springframework.beans.factory.annotation.Autowired; @@ -124,4 +127,30 @@ return "sucess"; } + /** + * 鑾峰彇涓婃姤鍥炲淇℃伅 + * @param reportId + * @return + */ + public JSONObject getReportReply(Long reportId) { + JSONObject result = new JSONObject(); + if(reportId == null) { + result.put("code", ResultCodeMsg.RsCode.ERROR_CODE); + result.put("msg","璇烽�夋嫨涓�涓棶棰樹笂鎶�"); + return result; + } + + VoIssueReportReply issueReportReply = opeReportReplyMapper.getReportReplyByReportId(reportId); + if(issueReportReply != null) { + result.put("code", ResultCodeMsg.RsCode.SUCCESS_CODE); + result.put("msg","success"); + result.put("data", issueReportReply); + return result; + } + result.put("code", ResultCodeMsg.RsCode.ERROR_CODE); + result.put("msg","鏈幏鍙栧埌涓婃姤鍥炲淇℃伅"); + return result; + + } + } diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/workOrder/ConsumerListener.java b/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/workOrder/ConsumerListener.java index 72d46c1..0be11b3 100644 --- a/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/workOrder/ConsumerListener.java +++ b/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/java/com/dy/pipIrrApp/workOrder/ConsumerListener.java @@ -15,7 +15,7 @@ @Component @RocketMQMessageListener( - topic = "workOrder", + topic = "workOrder2", consumerGroup = "consumer_group", selectorExpression = "*", messageModel = MessageModel.CLUSTERING, diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/resources/application.yml b/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/resources/application.yml index ec02f18..38443ef 100644 --- a/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/resources/application.yml +++ b/pipIrr-platform/pipIrr-web/pipIrr-web-app/src/main/resources/application.yml @@ -36,4 +36,10 @@ # 鍘嬬缉娑堟伅闃堝�硷紝榛樿4k(1024 * 4) compressMessageBodyThreshold: 4096 # 鏄惁鍦ㄥ唴閮ㄥ彂閫佸け璐ユ椂閲嶈瘯鍙︿竴涓猙roker锛岄粯璁alse - retryNextServer: false \ No newline at end of file + retryNextServer: false +logging: + level: + com: + dy: + pipIrrGlobal: + daoOp: trace -- Gitblit v1.8.0