From 09ad3af7d18cc9e4186e1a9775eb446579ad5f8d Mon Sep 17 00:00:00 2001 From: zhanghl <253316343@qq.com> Date: 星期四, 17 四月 2025 18:37:38 +0800 Subject: [PATCH] 增加日志表基础代码 --- aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java | 13 +++++- aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobLogMapper.xml | 89 ++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 99 insertions(+), 3 deletions(-) diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java b/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java index 6ff0aa6..479c502 100644 --- a/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java +++ b/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java @@ -6,6 +6,7 @@ import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.aps.common.core.utils.DateUtils; +import com.aps.job.domain.ApsWorkOrderJobLog; import com.aps.job.mapper.ApsWorkOrderJobLogMapper; import com.aps.job.param.ApsWorkOrderJobParam; import org.springframework.beans.factory.annotation.Value; @@ -128,9 +129,18 @@ Integer PageSize = 500; Boolean continueFlag = true; /* while (continueFlag){*/ + + ApsWorkOrderJobLog log = new ApsWorkOrderJobLog(); + String requestString = JSONObject.toJSONString(param); HttpEntity<String> request = new HttpEntity<>(requestString, headers); ResponseEntity<String> response = restTemplate.postForEntity(getWorkOrderUrl, request, String.class); + log.setRequestData(requestString); + log.setResponseData(response.getBody()); + log.setPageNum(Long.valueOf(PageIndex)); + log.setPageCount(Long.valueOf(PageSize)); + log.setCreateTime(); + jobLogMapper.insertApsWorkOrderJobLog(log) if (response.getStatusCode().is2xxSuccessful()) { JSONObject responseBodyJson = JSONObject.parseObject(response.getBody()); if ("200".equals(responseBodyJson.getString("status"))) { @@ -150,10 +160,7 @@ } apsWorkOrderJobMapper.batchInsertApsWorkOrderJob(jobs); } - } - } - } } diff --git a/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobLogMapper.xml b/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobLogMapper.xml new file mode 100644 index 0000000..080e5f3 --- /dev/null +++ b/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobLogMapper.xml @@ -0,0 +1,89 @@ +<?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.aps.job.mapper.ApsWorkOrderJobLogMapper"> + + <resultMap type="ApsWorkOrderJobLog" id="ApsWorkOrderJobLogResult"> + <result property="id" column="id" /> + <result property="pageNum" column="page_num" /> + <result property="pageCount" column="page_count" /> + <result property="responseData" column="response_data" /> + <result property="result" column="result" /> + <result property="orderId" column="order_id" /> + <result property="requestData" column="request_data" /> + <result property="createTime" column="create_time" /> + <result property="updateTime" column="update_time" /> + </resultMap> + + <sql id="selectApsWorkOrderJobLogVo"> + select id, page_num, page_count, response_data, result, order_id, request_data,create_time, update_time from aps_work_order_job_log + </sql> + + <select id="selectApsWorkOrderJobLogList" parameterType="ApsWorkOrderJobLog" resultMap="ApsWorkOrderJobLogResult"> + <include refid="selectApsWorkOrderJobLogVo"/> + <where> + <if test="pageNum != null "> and page_num = #{pageNum}</if> + <if test="pageCount != null "> and page_count = #{pageCount}</if> + <if test="responseData != null and responseData != ''"> and response_data = #{responseData}</if> + <if test="result != null and result != ''"> and result = #{result}</if> + <if test="orderId != null and orderId != ''"> and order_id = #{orderId}</if> + <if test="requestData != null and requestData != ''"> and request_data = #{requestData}</if> + </where> + </select> + + <select id="selectApsWorkOrderJobLogById" parameterType="Long" resultMap="ApsWorkOrderJobLogResult"> + <include refid="selectApsWorkOrderJobLogVo"/> + where id = #{id} + </select> + + <insert id="insertApsWorkOrderJobLog" parameterType="ApsWorkOrderJobLog" useGeneratedKeys="true" keyProperty="id"> + insert into aps_work_order_job_log + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="pageNum != null">page_num,</if> + <if test="pageCount != null">page_count,</if> + <if test="responseData != null">response_data,</if> + <if test="result != null">result,</if> + <if test="orderId != null">order_id,</if> + <if test="requestData != null">request_data,</if> + <if test="createTime != null">create_time,</if> + <if test="updateTime != null">update_time,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="pageNum != null">#{pageNum},</if> + <if test="pageCount != null">#{pageCount},</if> + <if test="responseData != null">#{responseData},</if> + <if test="result != null">#{result},</if> + <if test="orderId != null">#{orderId},</if> + <if test="requestData != null">#{requestData},</if> + <if test="createBy != null">#{createBy},</if> + <if test="updateTime != null">#{updateTime},</if> + </trim> + </insert> + + <update id="updateApsWorkOrderJobLog" parameterType="ApsWorkOrderJobLog"> + update aps_work_order_job_log + <trim prefix="SET" suffixOverrides=","> + <if test="pageNum != null">page_num = #{pageNum},</if> + <if test="pageCount != null">page_count = #{pageCount},</if> + <if test="responseData != null">response_data = #{responseData},</if> + <if test="result != null">result = #{result},</if> + <if test="orderId != null">order_id = #{orderId},</if> + <if test="requestData != null">request_data = #{requestData},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + </trim> + where id = #{id} + </update> + + <delete id="deleteApsWorkOrderJobLogById" parameterType="Long"> + delete from aps_work_order_job_log where id = #{id} + </delete> + + <delete id="deleteApsWorkOrderJobLogByIds" parameterType="String"> + delete from aps_work_order_job_log where id in + <foreach item="id" collection="array" open="(" separator="," close=")"> + #{id} + </foreach> + </delete> +</mapper> \ No newline at end of file -- Gitblit v1.9.3