增加日志表基础代码

zhanghl

2025-04-17 09ad3af7d18cc9e4186e1a9775eb446579ad5f8d

增加日志表基础代码

 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);
                }

            }

        }

    }
}

 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>