From b5600506d9548209a506f914c643933579d40461 Mon Sep 17 00:00:00 2001
From: tjx <t2856754968@163.com>
Date: 星期五, 19 十二月 2025 16:40:35 +0800
Subject: [PATCH] 111

---
 src/test/java/com/gs/dingtalk/DeviceReceivingApplicationTests.java |  109 +++++++++++++++++++++++++++++++++++++++++++++++-------
 1 files changed, 94 insertions(+), 15 deletions(-)

diff --git a/src/test/java/com/gs/dingtalk/DeviceReceivingApplicationTests.java b/src/test/java/com/gs/dingtalk/DeviceReceivingApplicationTests.java
index 1167cfe..f29a6ff 100644
--- a/src/test/java/com/gs/dingtalk/DeviceReceivingApplicationTests.java
+++ b/src/test/java/com/gs/dingtalk/DeviceReceivingApplicationTests.java
@@ -1,6 +1,9 @@
 package com.gs.dingtalk;
 
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.gs.dingtalk.config.URLEncoder;
+import com.gs.dingtalk.entity.QwStaff;
+import com.gs.dingtalk.mapper.QwStaffMapper;
 import com.gs.dingtalk.service.SendDingtalkService;
 import com.gs.dingtalk.service.SimpleExample;
 import com.gs.dingtalk.service.VwCjScSjTsBbService;
@@ -18,12 +21,14 @@
 class DeviceReceivingApplicationTests {
 
 
-
     @Autowired
     private VwCjScSjTsBbService vwCjScSjTsBbService;
 
     @Autowired
     private WorkWXService workWXService;
+
+    @Autowired
+    private QwStaffMapper qwStaffMapper;
 
     /**
      * 娴嬭瘯瀵煎嚭鐢熶骇鏁版嵁骞跺彂閫侀拤閽夋秷鎭�
@@ -56,15 +61,41 @@
     void testGetCheckinDataByQwStaff() {
         System.out.println("=== 寮�濮嬫祴璇曢�氳繃QW_STAFF琛ㄨ幏鍙栨墦鍗℃暟鎹� ===");
 
+        // 浼佷笟寰俊鎵撳崱鎺ュ彛闄愬埗锛�
+        // 1. 鑾峰彇璁板綍鏃堕棿璺ㄥ害涓嶈秴杩�30澶�
+        // 2. 鐢ㄦ埛鍒楄〃涓嶈秴杩�100涓�傝嫢鐢ㄦ埛瓒呰繃100涓紝璇峰垎鎵硅幏鍙栵紙宸插湪Service灞傚疄鐜拌嚜鍔ㄥ垎鎵癸級
+        // 3. 鎺ュ彛杩斿洖鏈�澶�3000鏉℃墦鍗℃暟鎹�
+        // 4. 鏍囧噯鎵撳崱鏃堕棿鍙浜庡浐瀹氭帓鐝拰鑷畾涔夋帓鐝袱绉嶇被鍨嬫湁鏁�
+        // 5. 鎺ュ彛璋冪敤棰戠巼闄愬埗涓�600娆�/鍒嗛挓锛堝凡鍦⊿ervice灞傚疄鐜版壒娆¢棿寤惰繜锛�
+
         try {
             long currentTime = System.currentTimeMillis() / 1000;
             long oneDaySeconds = 86400;
+            long thirtyDaysSeconds = 30 * oneDaySeconds;
 
             long endTime = (currentTime / oneDaySeconds) * oneDaySeconds - 1;
             long startTime = endTime - oneDaySeconds + 1;
 
+            // 楠岃瘉鏃堕棿璺ㄥ害涓嶈秴杩�30澶�
+            long timeSpan = endTime - startTime;
+            if (timeSpan > thirtyDaysSeconds) {
+                System.out.println("鉁� 鏃堕棿璺ㄥ害瓒呰繃30澶╅檺鍒�: " + (timeSpan / oneDaySeconds) + "澶�");
+                return;
+            }
+
             System.out.println("  - 寮�濮嬫椂闂�: " + new java.util.Date(startTime * 1000));
             System.out.println("  - 缁撴潫鏃堕棿: " + new java.util.Date(endTime * 1000));
+            System.out.println("  - 鏃堕棿璺ㄥ害: " + (timeSpan / oneDaySeconds) + "澶� (闄愬埗: 鈮�30澶�)");
+
+            // 鑾峰彇鐢ㄦ埛鎬绘暟
+            long totalUsers = qwStaffMapper.selectCount(new LambdaQueryWrapper<QwStaff>()
+                    .isNotNull(QwStaff::getAccount)
+                    .ne(QwStaff::getAccount, ""));
+            System.out.println("  - QW_STAFF琛ㄧ敤鎴锋�绘暟: " + totalUsers);
+            if (totalUsers > 100) {
+                int batchCount = (int) ((totalUsers + 99) / 100);
+                System.out.println("  - 灏嗚嚜鍔ㄥ垎鎵瑰鐞�: " + batchCount + "鎵� (姣忔壒鈮�100鐢ㄦ埛)");
+            }
 
             List<WorkWXService.CheckinData> checkinDataList = workWXService.getCheckinDataByQwStaff(startTime, endTime);
 
@@ -81,6 +112,62 @@
                 });
             } else {
                 System.out.println("鉁� 鑾峰彇鐨勬墦鍗℃暟鎹负绌猴紙鍙兘QW_STAFF琛ㄦ棤鏁版嵁鎴栨椂闂磋寖鍥村唴鏃犳墦鍗¤褰曪級");
+            }
+        } catch (IOException e) {
+            System.out.println("鉁� 鑾峰彇鎵撳崱鏁版嵁澶辫触: " + e.getMessage());
+            e.printStackTrace();
+        }
+
+        System.out.println("=== 娴嬭瘯缁撴潫 ===");
+    }
+
+    @Test
+    void testGetCheckinDataById() {
+        System.out.println("=== 寮�濮嬫祴璇曢�氳繃QW_STAFF琛ㄨ幏鍙栨墦鍗℃暟鎹� ===");
+        QwStaff qwStaff = qwStaffMapper.selectById(3);
+
+        if (qwStaff == null || qwStaff.getAccount() == null || qwStaff.getAccount().isEmpty()) {
+            System.out.println("鉁� 鏈壘鍒癐D涓�3鐨勫憳宸ユ垨鍛樺伐account涓虹┖");
+            return;
+        }
+
+        System.out.println("  - 鍛樺伐濮撳悕: " + qwStaff.getName());
+        System.out.println("  - 鍛樺伐璐﹀彿: " + qwStaff.getAccount());
+
+        try {
+            long currentTime = System.currentTimeMillis() / 1000;
+            long oneDaySeconds = 86400;
+            long thirtyDaysSeconds = 30 * oneDaySeconds;
+
+            long endTime = (currentTime / oneDaySeconds) * oneDaySeconds - 1;
+            long startTime = endTime - oneDaySeconds + 1;
+
+            // 楠岃瘉鏃堕棿璺ㄥ害涓嶈秴杩�30澶�
+            long timeSpan = endTime - startTime;
+            if (timeSpan > thirtyDaysSeconds) {
+                System.out.println("鉁� 鏃堕棿璺ㄥ害瓒呰繃30澶╅檺鍒�: " + (timeSpan / oneDaySeconds) + "澶�");
+                return;
+            }
+
+            System.out.println("  - 寮�濮嬫椂闂�: " + new java.util.Date(startTime * 1000));
+            System.out.println("  - 缁撴潫鏃堕棿: " + new java.util.Date(endTime * 1000));
+
+            List<String> useridList = new java.util.ArrayList<>();
+            useridList.add(qwStaff.getAccount());
+
+            List<WorkWXService.CheckinData> checkinDataList = workWXService.getCheckinData(startTime, endTime, useridList);
+
+            if (checkinDataList != null && !checkinDataList.isEmpty()) {
+                System.out.println("鉁� 鎴愬姛鑾峰彇鎵撳崱鏁版嵁");
+                System.out.println("  - 鎵撳崱璁板綍鎬绘暟: " + checkinDataList.size());
+                checkinDataList.forEach(data -> {
+                    System.out.println("    * 鎵撳崱鏃堕棿: " + new java.util.Date(data.getCheckinTime() * 1000) +
+                            ", 鎵撳崱绫诲瀷: " + data.getCheckinType() +
+                            ", 寮傚父绫诲瀷: " + data.getExceptionType() +
+                            ", 鍦扮偣: " + data.getLocationDetail());
+                });
+            } else {
+                System.out.println("鉁� 璇ュ憳宸ュ湪鏃堕棿鑼冨洿鍐呮棤鎵撳崱璁板綍");
             }
         } catch (IOException e) {
             System.out.println("鉁� 鑾峰彇鎵撳崱鏁版嵁澶辫触: " + e.getMessage());
@@ -118,24 +205,16 @@
     }
 
     @Test
-    void testGetUserDetail() {
-        System.out.println("=== 寮�濮嬫祴璇曡幏鍙栫敤鎴疯鎯� ===");
+    void testSyncUsersToQwStaff() {
+        System.out.println("=== 寮�濮嬫祴璇曞悓姝ヤ紒涓氬井淇$敤鎴峰埌QW_STAFF琛� ===");
 
         try {
-            String userid = "ShenJuanYue";
-            WorkWXService.WorkWXUserDetail userDetail = workWXService.getUserDetail(userid);
+            int insertCount = workWXService.syncUsersToQwStaff();
 
-            if (userDetail != null && userDetail.getErrcode() == 0) {
-                System.out.println("鉁� 鎴愬姛鑾峰彇鐢ㄦ埛璇︽儏");
-                System.out.println("  - userid: " + userDetail.getUserid());
-                System.out.println("  - 濮撳悕: " + userDetail.getName());
-                System.out.println("  - 鎵嬫満鍙�: " + userDetail.getMobile());
-                System.out.println("  - 鑱屼綅: " + userDetail.getPosition());
-            } else {
-                System.out.println("鉁� 鑾峰彇鐢ㄦ埛璇︽儏澶辫触");
-            }
+            System.out.println("鉁� 鍚屾瀹屾垚");
+            System.out.println("  - 鏂板鐢ㄦ埛鏁�: " + insertCount);
         } catch (IOException e) {
-            System.out.println("鉁� 鑾峰彇鐢ㄦ埛璇︽儏澶辫触: " + e.getMessage());
+            System.out.println("鉁� 鍚屾鐢ㄦ埛澶辫触: " + e.getMessage());
             e.printStackTrace();
         }
 

--
Gitblit v1.9.3