From 11000bf4837f245824d88fc786e0ec8991f46b9e Mon Sep 17 00:00:00 2001
From: zhanghl <253316343@qq.com>
Date: 星期四, 17 四月 2025 18:25:09 +0800
Subject: [PATCH] 增加日志表基础代码

---
 aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobLogService.java         |   61 +++++++
 aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobService.java            |    4 
 aps-modules/aps-job/src/main/java/com/aps/job/param/ApsWorkOrderJobParam.java                 |   25 +++
 aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobLogServiceImpl.java |   93 +++++++++++
 aps-modules/aps-job/src/main/java/com/aps/job/controller/ApsWorkOrderJobController.java       |    5 
 aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java    |   63 ++++---
 aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderJobLog.java                  |  127 +++++++++++++++
 aps-modules/aps-job/src/main/java/com/aps/job/mapper/ApsWorkOrderJobLogMapper.java            |   63 +++++++
 8 files changed, 407 insertions(+), 34 deletions(-)

diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/controller/ApsWorkOrderJobController.java b/aps-modules/aps-job/src/main/java/com/aps/job/controller/ApsWorkOrderJobController.java
index 3cb9d12..791a662 100644
--- a/aps-modules/aps-job/src/main/java/com/aps/job/controller/ApsWorkOrderJobController.java
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/controller/ApsWorkOrderJobController.java
@@ -3,6 +3,7 @@
 import java.util.List;
 import java.io.IOException;
 
+import com.aps.job.param.ApsWorkOrderJobParam;
 import jakarta.servlet.http.HttpServletResponse;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.GetMapping;
@@ -106,9 +107,9 @@
 
 
     @PostMapping("/batchInsertApsWorkOrderJob")
-    public AjaxResult batchInsertApsWorkOrderJob()
+    public AjaxResult batchInsertApsWorkOrderJob(@RequestBody ApsWorkOrderJobParam param)
     {
-    	apsWorkOrderJobService.batchInsertApsWorkOrderJob();
+    	apsWorkOrderJobService.batchInsertApsWorkOrderJob(param);
     	return success();
     }
 }
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderJobLog.java b/aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderJobLog.java
new file mode 100644
index 0000000..ceb892b
--- /dev/null
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderJobLog.java
@@ -0,0 +1,127 @@
+package com.aps.job.domain;
+
+import org.apache.commons.lang3.builder.ToStringBuilder;
+import org.apache.commons.lang3.builder.ToStringStyle;
+import com.aps.common.core.annotation.Excel;
+import com.aps.common.core.web.domain.BaseEntity;
+
+/**
+ * 宸ュ崟鍚屾鏃ュ織瀵硅薄 aps_work_order_job_log
+ * 
+ * @author zhl
+ * @date 2025-04-17
+ */
+public class ApsWorkOrderJobLog extends BaseEntity
+{
+    private static final long serialVersionUID = 1L;
+
+    /** 涓婚敭 */
+    private Long id;
+
+    /** 椤垫暟 */
+    @Excel(name = "椤垫暟")
+    private Long pageNum;
+
+    /** 鏁版嵁鏉℃暟 */
+    @Excel(name = "鏁版嵁鏉℃暟")
+    private Long pageCount;
+
+    /** json鏍煎紡鏁版嵁 */
+    @Excel(name = "json鏍煎紡鏁版嵁")
+    private String responseData;
+
+    /** 淇濆瓨缁撴灉 */
+    @Excel(name = "淇濆瓨缁撴灉")
+    private String result;
+
+    /** 鍚屾涓婚敭 */
+    @Excel(name = "鍚屾涓婚敭")
+    private String orderId;
+
+    /** 璇锋眰鏁版嵁 */
+    @Excel(name = "璇锋眰鏁版嵁")
+    private String requestData;
+
+    public void setId(Long id) 
+    {
+        this.id = id;
+    }
+
+    public Long getId() 
+    {
+        return id;
+    }
+
+    public void setPageNum(Long pageNum) 
+    {
+        this.pageNum = pageNum;
+    }
+
+    public Long getPageNum() 
+    {
+        return pageNum;
+    }
+
+    public void setPageCount(Long pageCount) 
+    {
+        this.pageCount = pageCount;
+    }
+
+    public Long getPageCount() 
+    {
+        return pageCount;
+    }
+
+    public void setResponseData(String responseData) 
+    {
+        this.responseData = responseData;
+    }
+
+    public String getResponseData() 
+    {
+        return responseData;
+    }
+
+    public void setResult(String result) 
+    {
+        this.result = result;
+    }
+
+    public String getResult() 
+    {
+        return result;
+    }
+
+    public void setOrderId(String orderId) 
+    {
+        this.orderId = orderId;
+    }
+
+    public String getOrderId() 
+    {
+        return orderId;
+    }
+
+    public void setRequestData(String requestData) 
+    {
+        this.requestData = requestData;
+    }
+
+    public String getRequestData() 
+    {
+        return requestData;
+    }
+
+    @Override
+    public String toString() {
+        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
+            .append("id", getId())
+            .append("pageNum", getPageNum())
+            .append("pageCount", getPageCount())
+            .append("responseData", getResponseData())
+            .append("result", getResult())
+            .append("orderId", getOrderId())
+            .append("requestData", getRequestData())
+            .toString();
+    }
+}
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/mapper/ApsWorkOrderJobLogMapper.java b/aps-modules/aps-job/src/main/java/com/aps/job/mapper/ApsWorkOrderJobLogMapper.java
new file mode 100644
index 0000000..8faea87
--- /dev/null
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/mapper/ApsWorkOrderJobLogMapper.java
@@ -0,0 +1,63 @@
+package com.aps.job.mapper;
+
+import java.util.List;
+import com.aps.job.domain.ApsWorkOrderJobLog;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+ * 宸ュ崟鍚屾鏃ュ織Mapper鎺ュ彛
+ * 
+ * @author zhl
+ * @date 2025-04-17
+ */
+@Mapper
+public interface ApsWorkOrderJobLogMapper 
+{
+    /**
+     * 鏌ヨ宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param id 宸ュ崟鍚屾鏃ュ織涓婚敭
+     * @return 宸ュ崟鍚屾鏃ュ織
+     */
+    public ApsWorkOrderJobLog selectApsWorkOrderJobLogById(Long id);
+
+    /**
+     * 鏌ヨ宸ュ崟鍚屾鏃ュ織鍒楄〃
+     * 
+     * @param apsWorkOrderJobLog 宸ュ崟鍚屾鏃ュ織
+     * @return 宸ュ崟鍚屾鏃ュ織闆嗗悎
+     */
+    public List<ApsWorkOrderJobLog> selectApsWorkOrderJobLogList(ApsWorkOrderJobLog apsWorkOrderJobLog);
+
+    /**
+     * 鏂板宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param apsWorkOrderJobLog 宸ュ崟鍚屾鏃ュ織
+     * @return 缁撴灉
+     */
+    public int insertApsWorkOrderJobLog(ApsWorkOrderJobLog apsWorkOrderJobLog);
+
+    /**
+     * 淇敼宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param apsWorkOrderJobLog 宸ュ崟鍚屾鏃ュ織
+     * @return 缁撴灉
+     */
+    public int updateApsWorkOrderJobLog(ApsWorkOrderJobLog apsWorkOrderJobLog);
+
+    /**
+     * 鍒犻櫎宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param id 宸ュ崟鍚屾鏃ュ織涓婚敭
+     * @return 缁撴灉
+     */
+    public int deleteApsWorkOrderJobLogById(Long id);
+
+    /**
+     * 鎵归噺鍒犻櫎宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎
+     * @return 缁撴灉
+     */
+    public int deleteApsWorkOrderJobLogByIds(Long[] ids);
+}
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/param/ApsWorkOrderJobParam.java b/aps-modules/aps-job/src/main/java/com/aps/job/param/ApsWorkOrderJobParam.java
new file mode 100644
index 0000000..28799c0
--- /dev/null
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/param/ApsWorkOrderJobParam.java
@@ -0,0 +1,25 @@
+package com.aps.job.param;
+
+import com.fasterxml.jackson.annotation.JsonProperty;
+import lombok.Data;
+
+import java.util.List;
+
+@Data
+public class ApsWorkOrderJobParam {
+    @JsonProperty("PageIndex")
+    private String pageIndex;
+    @JsonProperty("PageSize")
+    private String pageSize;
+    @JsonProperty("DocList")
+    private List<String> docList;
+    @JsonProperty("ItemType")
+    private List<String> itemType;
+    @JsonProperty("OrgCode")
+    private String orgCode;
+    @JsonProperty("BeginDate")
+    private String beginDate;
+    @JsonProperty("EndDate")
+    private String endDate;
+
+}
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobLogService.java b/aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobLogService.java
new file mode 100644
index 0000000..d44ebb5
--- /dev/null
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobLogService.java
@@ -0,0 +1,61 @@
+package com.aps.job.service;
+
+import java.util.List;
+import com.aps.job.domain.ApsWorkOrderJobLog;
+
+/**
+ * 宸ュ崟鍚屾鏃ュ織Service鎺ュ彛
+ * 
+ * @author zhl
+ * @date 2025-04-17
+ */
+public interface IApsWorkOrderJobLogService 
+{
+    /**
+     * 鏌ヨ宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param id 宸ュ崟鍚屾鏃ュ織涓婚敭
+     * @return 宸ュ崟鍚屾鏃ュ織
+     */
+    public ApsWorkOrderJobLog selectApsWorkOrderJobLogById(Long id);
+
+    /**
+     * 鏌ヨ宸ュ崟鍚屾鏃ュ織鍒楄〃
+     * 
+     * @param apsWorkOrderJobLog 宸ュ崟鍚屾鏃ュ織
+     * @return 宸ュ崟鍚屾鏃ュ織闆嗗悎
+     */
+    public List<ApsWorkOrderJobLog> selectApsWorkOrderJobLogList(ApsWorkOrderJobLog apsWorkOrderJobLog);
+
+    /**
+     * 鏂板宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param apsWorkOrderJobLog 宸ュ崟鍚屾鏃ュ織
+     * @return 缁撴灉
+     */
+    public int insertApsWorkOrderJobLog(ApsWorkOrderJobLog apsWorkOrderJobLog);
+
+    /**
+     * 淇敼宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param apsWorkOrderJobLog 宸ュ崟鍚屾鏃ュ織
+     * @return 缁撴灉
+     */
+    public int updateApsWorkOrderJobLog(ApsWorkOrderJobLog apsWorkOrderJobLog);
+
+    /**
+     * 鎵归噺鍒犻櫎宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param ids 闇�瑕佸垹闄ょ殑宸ュ崟鍚屾鏃ュ織涓婚敭闆嗗悎
+     * @return 缁撴灉
+     */
+    public int deleteApsWorkOrderJobLogByIds(Long[] ids);
+
+    /**
+     * 鍒犻櫎宸ュ崟鍚屾鏃ュ織淇℃伅
+     * 
+     * @param id 宸ュ崟鍚屾鏃ュ織涓婚敭
+     * @return 缁撴灉
+     */
+    public int deleteApsWorkOrderJobLogById(Long id);
+}
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobService.java b/aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobService.java
index f6efc6e..ad5c62a 100644
--- a/aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobService.java
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobService.java
@@ -2,6 +2,7 @@
 
 import java.util.List;
 import com.aps.job.domain.ApsWorkOrderJob;
+import com.aps.job.param.ApsWorkOrderJobParam;
 
 /**
  * 宸ュ崟鍚屾Service鎺ュ彛
@@ -59,5 +60,6 @@
      */
     public int deleteApsWorkOrderJobById(Long id);
 
-    void batchInsertApsWorkOrderJob();
+
+    void batchInsertApsWorkOrderJob(ApsWorkOrderJobParam param);
 }
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobLogServiceImpl.java b/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobLogServiceImpl.java
new file mode 100644
index 0000000..d5d477f
--- /dev/null
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobLogServiceImpl.java
@@ -0,0 +1,93 @@
+package com.aps.job.service.impl;
+
+import java.util.List;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import com.aps.job.mapper.ApsWorkOrderJobLogMapper;
+import com.aps.job.domain.ApsWorkOrderJobLog;
+import com.aps.job.service.IApsWorkOrderJobLogService;
+
+/**
+ * 宸ュ崟鍚屾鏃ュ織Service涓氬姟灞傚鐞�
+ * 
+ * @author zhl
+ * @date 2025-04-17
+ */
+@Service
+public class ApsWorkOrderJobLogServiceImpl implements IApsWorkOrderJobLogService 
+{
+    @Autowired
+    private ApsWorkOrderJobLogMapper apsWorkOrderJobLogMapper;
+
+    /**
+     * 鏌ヨ宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param id 宸ュ崟鍚屾鏃ュ織涓婚敭
+     * @return 宸ュ崟鍚屾鏃ュ織
+     */
+    @Override
+    public ApsWorkOrderJobLog selectApsWorkOrderJobLogById(Long id)
+    {
+        return apsWorkOrderJobLogMapper.selectApsWorkOrderJobLogById(id);
+    }
+
+    /**
+     * 鏌ヨ宸ュ崟鍚屾鏃ュ織鍒楄〃
+     * 
+     * @param apsWorkOrderJobLog 宸ュ崟鍚屾鏃ュ織
+     * @return 宸ュ崟鍚屾鏃ュ織
+     */
+    @Override
+    public List<ApsWorkOrderJobLog> selectApsWorkOrderJobLogList(ApsWorkOrderJobLog apsWorkOrderJobLog)
+    {
+        return apsWorkOrderJobLogMapper.selectApsWorkOrderJobLogList(apsWorkOrderJobLog);
+    }
+
+    /**
+     * 鏂板宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param apsWorkOrderJobLog 宸ュ崟鍚屾鏃ュ織
+     * @return 缁撴灉
+     */
+    @Override
+    public int insertApsWorkOrderJobLog(ApsWorkOrderJobLog apsWorkOrderJobLog)
+    {
+        return apsWorkOrderJobLogMapper.insertApsWorkOrderJobLog(apsWorkOrderJobLog);
+    }
+
+    /**
+     * 淇敼宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param apsWorkOrderJobLog 宸ュ崟鍚屾鏃ュ織
+     * @return 缁撴灉
+     */
+    @Override
+    public int updateApsWorkOrderJobLog(ApsWorkOrderJobLog apsWorkOrderJobLog)
+    {
+        return apsWorkOrderJobLogMapper.updateApsWorkOrderJobLog(apsWorkOrderJobLog);
+    }
+
+    /**
+     * 鎵归噺鍒犻櫎宸ュ崟鍚屾鏃ュ織
+     * 
+     * @param ids 闇�瑕佸垹闄ょ殑宸ュ崟鍚屾鏃ュ織涓婚敭
+     * @return 缁撴灉
+     */
+    @Override
+    public int deleteApsWorkOrderJobLogByIds(Long[] ids)
+    {
+        return apsWorkOrderJobLogMapper.deleteApsWorkOrderJobLogByIds(ids);
+    }
+
+    /**
+     * 鍒犻櫎宸ュ崟鍚屾鏃ュ織淇℃伅
+     * 
+     * @param id 宸ュ崟鍚屾鏃ュ織涓婚敭
+     * @return 缁撴灉
+     */
+    @Override
+    public int deleteApsWorkOrderJobLogById(Long id)
+    {
+        return apsWorkOrderJobLogMapper.deleteApsWorkOrderJobLogById(id);
+    }
+}
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 703500c..6ff0aa6 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,8 +6,8 @@
 import com.alibaba.fastjson.JSONArray;
 import com.alibaba.fastjson.JSONObject;
 import com.aps.common.core.utils.DateUtils;
-import com.aps.common.core.utils.StringUtils;
-import jakarta.annotation.Resource;
+import com.aps.job.mapper.ApsWorkOrderJobLogMapper;
+import com.aps.job.param.ApsWorkOrderJobParam;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.http.HttpEntity;
@@ -41,6 +41,8 @@
     @Autowired
     private RestTemplate restTemplate;
 
+    @Autowired
+    private ApsWorkOrderJobLogMapper jobLogMapper;
 
     /**
      * 鏌ヨ宸ュ崟鍚屾
@@ -118,41 +120,40 @@
 
 
     @Override
-    public void batchInsertApsWorkOrderJob() {
+    public void batchInsertApsWorkOrderJob(ApsWorkOrderJobParam param) {
 
         HttpHeaders headers = new HttpHeaders();
         headers.setContentType(MediaType.APPLICATION_JSON);
-        Integer PageIndex=1;
-        Integer PageSize=500;
-        Boolean continueFlag=true;
-      /*  while (continueFlag){*/
-            JSONObject requestBody = new JSONObject();
-            requestBody.put("PageIndex", PageIndex);
-            requestBody.put("PageSize", PageSize);
-            HttpEntity<String> request = new HttpEntity<>(requestBody.toJSONString(), headers);
-            ResponseEntity<String> response = restTemplate.postForEntity(getWorkOrderUrl, request, String.class);
-            if (response.getStatusCode().is2xxSuccessful()) {
-                JSONObject responseBodyJson = JSONObject.parseObject(response.getBody());
-                if("200".equals(responseBodyJson.getString("status"))){
-                    JSONArray result = responseBodyJson.getJSONArray("data");
-                    if (result!=null){
-                        List<ApsWorkOrderJob> jobs = new ArrayList<>();
-                        for (int i = 0; i < result.size(); i++) {
-                            ApsWorkOrderJob order = result.getObject(i, ApsWorkOrderJob.class);
-                            JSONObject jsonObject = result.getJSONObject(i);
-                            order.setOrderId(jsonObject.get("ID").toString());
-                            order.setCreateTime(DateUtils.getNowDate());
-                            order.setPageIndex(i);
-                            order.setPageNum(PageIndex);
-                            order.setDelFlag("0");
-                            jobs.add(order);
-                        }
-                        apsWorkOrderJobMapper.batchInsertApsWorkOrderJob(jobs);
+        Integer PageIndex = 1;
+        Integer PageSize = 500;
+        Boolean continueFlag = true;
+        /*  while (continueFlag){*/
+        String requestString = JSONObject.toJSONString(param);
+        HttpEntity<String> request = new HttpEntity<>(requestString, headers);
+        ResponseEntity<String> response = restTemplate.postForEntity(getWorkOrderUrl, request, String.class);
+        if (response.getStatusCode().is2xxSuccessful()) {
+            JSONObject responseBodyJson = JSONObject.parseObject(response.getBody());
+            if ("200".equals(responseBodyJson.getString("status"))) {
+                JSONArray result = responseBodyJson.getJSONArray("data");
+                if (result != null) {
+                    List<ApsWorkOrderJob> jobs = new ArrayList<>();
+                    for (int i = 0; i < result.size(); i++) {
+                        ApsWorkOrderJob order = result.getObject(i, ApsWorkOrderJob.class);
+                        JSONObject jsonObject = result.getJSONObject(i);
+                        order.setOrderId(jsonObject.get("ID").toString());
+                        order.setCreateTime(DateUtils.getNowDate());
+                        order.setPageIndex(i);
+                        order.setPageNum(PageIndex);
+                        order.setDelFlag("0");
+                        order.setProcessStatus("0");
+                        jobs.add(order);
                     }
-
+                    apsWorkOrderJobMapper.batchInsertApsWorkOrderJob(jobs);
                 }
 
             }
-       /* }*/
+
+        }
+
     }
 }

--
Gitblit v1.9.3