From 363592addf95355738ec801b6438a1ff2db5e05c Mon Sep 17 00:00:00 2001
From: sinake <sinake1@qq.com>
Date: 星期二, 16 九月 2025 13:59:00 +0800
Subject: [PATCH] HIS同步数据

---
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceTelInfoController.java |   42 ++++++++++++++
 smartor/src/main/resources/mapper/smartor/UtilsMapper.xml                                |    2 
 ruoyi-quartz/src/main/java/com/ruoyi/quartz/mapper/UtilsSyncMapper.java                  |   28 +++++++++
 smartor/src/main/java/com/smartor/service/impl/ServiceTelInfoServiceImpl.java            |   41 +++++++++++++
 smartor/src/main/java/com/smartor/mapper/UtilsMapper.java                                |   10 +++
 ruoyi-quartz/src/main/resources/mapper/quartz/UtilsSyncMapper.xml                        |    2 
 smartor/src/main/java/com/smartor/service/IServiceTelInfoService.java                    |   23 +++++++
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/common/SmsController.java             |   32 ++++++++++
 8 files changed, 177 insertions(+), 3 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/common/SmsController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/common/SmsController.java
index 7353768..42758b8 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/common/SmsController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/common/SmsController.java
@@ -2,6 +2,7 @@
 
 import com.ruoyi.common.config.RuoYiConfig;
 import com.ruoyi.common.core.domain.AjaxResult;
+import com.ruoyi.common.utils.RSAPublicKeyExample;
 import com.ruoyi.common.utils.StringUtils;
 import com.ruoyi.common.utils.file.FileUtils;
 import com.ruoyi.common.utils.sms.smsUtils;
@@ -17,6 +18,9 @@
 
 import javax.servlet.http.HttpServletRequest;
 import javax.servlet.http.HttpServletResponse;
+import java.io.UnsupportedEncodingException;
+import java.net.URLEncoder;
+import java.nio.charset.StandardCharsets;
 
 @RestController
 @Api(description = "鐭ヤ俊鎺ュ彛")
@@ -31,6 +35,16 @@
     @Value("${xhsmsPwd}")
     private String xhsmsPwd;
 
+    @Value("${localIP}")
+    private String ip;
+
+    @Value("${req_path}")
+    private String req_path;
+
+    @Value("${pub_key}")
+    private String pub_key;
+
+
     /**
      * @param
      * @return
@@ -41,6 +55,24 @@
         String sendMsg=smsUtils.sendSms(xhsmsPath,xhsmsAccount,xhsmsPwd,vo.getPhone(),vo.getContent());
         return AjaxResult.success(sendMsg);
     }
+    /**
+     * @param
+     * @return
+     */
+    @ApiOperation("鐭俊鍙戦��")
+    @PostMapping("/sendAsk")
+    public AjaxResult sendAsk(@RequestBody smsVO vo) throws UnsupportedEncodingException {
+//        String format = String.format("%03X", vo.getId());
+//        String url=ip + ":" + req_path + "/wt?p=" + format;
+        RSAPublicKeyExample rsaPublicKeyExample = new RSAPublicKeyExample();
+        String taskId = rsaPublicKeyExample.encryptedData(vo.getTaskId().toString(), pub_key);
+        String patid = rsaPublicKeyExample.encryptedData(vo.getPatId().toString(), pub_key);
+        String url = null;
+        url = ip + ":" + req_path + "/outsideChainwt?param1=" + taskId + "&param2=" + patid + "&param3=" + URLEncoder.encode(vo.getTaskName(), StandardCharsets.UTF_8.toString()) + "&param5=false";
 
+        String content="鎮ㄥソ锛岄個璇锋偍濉啓鍑洪櫌璋冩煡琛紝璇风偣鍑�" + url + "濉啓銆傛劅璋㈡偍閰嶅悎锛�";
 
+        String sendMsg=smsUtils.sendSms(xhsmsPath,xhsmsAccount,xhsmsPwd,vo.getPhone(),content);
+        return AjaxResult.success(sendMsg);
+    }
 }
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceTelInfoController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceTelInfoController.java
new file mode 100644
index 0000000..bba4a2b
--- /dev/null
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceTelInfoController.java
@@ -0,0 +1,42 @@
+package com.ruoyi.web.controller.smartor;
+
+import com.ruoyi.common.core.domain.AjaxResult;
+import com.ruoyi.common.utils.sms.smsUtils;
+import com.smartor.domain.smsVO;
+import com.smartor.service.IServiceTaskoperService;
+import com.smartor.service.IServiceTelInfoService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+
+@RestController
+@Api(description = "鐭ヤ俊鎺ュ彛")
+@RequestMapping("/smartor/ServiceTelInfo")
+public class ServiceTelInfoController {
+
+    @Autowired
+    private IServiceTelInfoService telService;
+
+    /**
+     * @param
+     * @return
+     */
+    @ApiOperation("闅忚鐢佃瘽璇︽儏鍒楄〃")
+    @GetMapping("/getList")
+    public AjaxResult getList() {
+        return AjaxResult.success(telService.getList());
+    }
+
+
+    /**
+     * @param
+     * @return
+     */
+    @ApiOperation("闅忚鐢佃瘽璇︽儏璁剧疆鐘舵��0姝e父1鍗犵嚎")
+    @GetMapping("/setState")
+    public AjaxResult setState(Integer id,Integer state) {
+        String sendMsg= "";
+        return AjaxResult.success(telService.setState(id,state));
+    }
+}
diff --git a/ruoyi-quartz/src/main/java/com/ruoyi/quartz/mapper/UtilsSyncMapper.java b/ruoyi-quartz/src/main/java/com/ruoyi/quartz/mapper/UtilsSyncMapper.java
new file mode 100644
index 0000000..aaebe94
--- /dev/null
+++ b/ruoyi-quartz/src/main/java/com/ruoyi/quartz/mapper/UtilsSyncMapper.java
@@ -0,0 +1,28 @@
+package com.ruoyi.quartz.mapper;
+
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.annotations.Update;
+
+import java.util.List;
+import java.util.Map;
+
+@Mapper
+public interface UtilsSyncMapper {
+
+//    /**
+//     * 鏌ヨsql
+//     * @param sql
+//     * @return
+//     */
+//    @Select({"${sql}"})
+//    List<Map<String, Object>> getList(@Param("sql") String sql);
+//
+//    /**
+//     * 鏇存柊sql
+//     * @param sql
+//     */
+//    @Update({"${sql}"})
+//    Integer updateSql(@Param("sql") String sql);
+}
diff --git a/ruoyi-quartz/src/main/resources/mapper/quartz/UtilsMapper.xml b/ruoyi-quartz/src/main/resources/mapper/quartz/UtilsSyncMapper.xml
similarity index 74%
copy from ruoyi-quartz/src/main/resources/mapper/quartz/UtilsMapper.xml
copy to ruoyi-quartz/src/main/resources/mapper/quartz/UtilsSyncMapper.xml
index e04d94d..7396b1d 100644
--- a/ruoyi-quartz/src/main/resources/mapper/quartz/UtilsMapper.xml
+++ b/ruoyi-quartz/src/main/resources/mapper/quartz/UtilsSyncMapper.xml
@@ -2,6 +2,6 @@
 <!DOCTYPE mapper
         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="com.ruoyi.quartz.mapper.UtilsMapper">
+<mapper namespace="com.ruoyi.quartz.mapper.UtilsSyncMapper">
 
 </mapper>
\ No newline at end of file
diff --git a/ruoyi-quartz/src/main/java/com/ruoyi/quartz/mapper/UtilsMapper.java b/smartor/src/main/java/com/smartor/mapper/UtilsMapper.java
similarity index 74%
rename from ruoyi-quartz/src/main/java/com/ruoyi/quartz/mapper/UtilsMapper.java
rename to smartor/src/main/java/com/smartor/mapper/UtilsMapper.java
index ab0ded7..4938abd 100644
--- a/ruoyi-quartz/src/main/java/com/ruoyi/quartz/mapper/UtilsMapper.java
+++ b/smartor/src/main/java/com/smartor/mapper/UtilsMapper.java
@@ -1,4 +1,4 @@
-package com.ruoyi.quartz.mapper;
+package com.smartor.mapper;
 
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
@@ -25,4 +25,12 @@
      */
     @Update({"${sql}"})
     Integer updateSql(@Param("sql") String sql);
+
+    /**
+     * 鏌ヨ杩斿洖strign sql
+     * @param sql
+     * @return
+     */
+    @Select({"${sql}"})
+    String getSqlString(@Param("sql") String sql);
 }
diff --git a/smartor/src/main/java/com/smartor/service/IServiceTelInfoService.java b/smartor/src/main/java/com/smartor/service/IServiceTelInfoService.java
new file mode 100644
index 0000000..5a1e92a
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/service/IServiceTelInfoService.java
@@ -0,0 +1,23 @@
+package com.smartor.service;
+
+import java.util.List;
+import java.util.Map;
+
+public interface IServiceTelInfoService {
+
+    /**
+     * 璁剧疆鐢佃瘽鐘舵��
+     *
+     * @return 缁撴灉
+     */
+    public List<Map<String,Object>> getList();
+
+    /**
+     * 璁剧疆鐢佃瘽鐘舵��
+     *
+     * @param id 涓婚敭
+     * @param state 0姝e父1鍗犵嚎
+     * @return 缁撴灉
+     */
+    public int setState(Integer id,Integer state);
+}
diff --git a/smartor/src/main/java/com/smartor/service/impl/ServiceTelInfoServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/ServiceTelInfoServiceImpl.java
new file mode 100644
index 0000000..a0f88b0
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/service/impl/ServiceTelInfoServiceImpl.java
@@ -0,0 +1,41 @@
+package com.smartor.service.impl;
+
+
+import com.smartor.mapper.UtilsMapper;
+import com.smartor.service.IServiceTelInfoService;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import java.util.List;
+import java.util.Map;
+
+@Slf4j
+@Service
+public class ServiceTelInfoServiceImpl implements IServiceTelInfoService {
+    @Autowired
+    private UtilsMapper utilsMapper;
+
+    /**
+     * 璁剧疆鐢佃瘽鐘舵��
+     *
+     * @return 缁撴灉
+     */
+    @Override
+    public List<Map<String,Object>> getList() {
+       List<Map<String,Object>> lists= utilsMapper.getList("select * from service_telinfo where state=0 ");
+        return lists;
+    }
+    /**
+     * 璁剧疆鐢佃瘽鐘舵��
+     *
+     * @param id 涓婚敭
+     * @param state 0姝e父1鍗犵嚎
+     * @return 缁撴灉
+     */
+    @Override
+    public int setState(Integer id, Integer state) {
+        Integer result= utilsMapper.updateSql("update service_telinfo set state= "+state+" where id="+id+" ");
+        return result;
+    }
+}
diff --git a/ruoyi-quartz/src/main/resources/mapper/quartz/UtilsMapper.xml b/smartor/src/main/resources/mapper/smartor/UtilsMapper.xml
similarity index 75%
rename from ruoyi-quartz/src/main/resources/mapper/quartz/UtilsMapper.xml
rename to smartor/src/main/resources/mapper/smartor/UtilsMapper.xml
index e04d94d..f301ba5 100644
--- a/ruoyi-quartz/src/main/resources/mapper/quartz/UtilsMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/UtilsMapper.xml
@@ -2,6 +2,6 @@
 <!DOCTYPE mapper
         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="com.ruoyi.quartz.mapper.UtilsMapper">
+<mapper namespace="com.smartor.mapper.UtilsMapper">
 
 </mapper>
\ No newline at end of file

--
Gitblit v1.9.3