From 19fe5a3d816184549e8ffa011c39f218734da8d5 Mon Sep 17 00:00:00 2001
From: fei.wang <wf18701153496@163.com>
Date: 星期一, 13 五月 2024 17:49:50 +0800
Subject: [PATCH] 更改
---
src/main/java/com/flow/controller/DuanxinlogController.java | 91 ++++++++++++++++++++++++++++++++++++---------
1 files changed, 73 insertions(+), 18 deletions(-)
diff --git a/src/main/java/com/flow/controller/DuanxinlogController.java b/src/main/java/com/flow/controller/DuanxinlogController.java
index 3ad3679..8f3cf37 100644
--- a/src/main/java/com/flow/controller/DuanxinlogController.java
+++ b/src/main/java/com/flow/controller/DuanxinlogController.java
@@ -1,14 +1,8 @@
package com.flow.controller;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.flow.mapper.CardMapper;
-import com.flow.mapper.CompanyMapper;
-import com.flow.mapper.DuanxinlogMapper;
-import com.flow.mapper.TbFuwuqiMapper;
-import com.flow.pojo.Card;
-import com.flow.pojo.Company;
-import com.flow.pojo.Duanxinlog;
-import com.flow.pojo.TbFuwuqi;
+import com.flow.mapper.*;
+import com.flow.pojo.*;
import com.flow.service.DuanxinlogService;
import com.flow.service.TbFuwuqiService;
import com.flow.util.DESUtil;
@@ -25,12 +19,13 @@
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;
import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
+import org.springframework.web.servlet.ModelAndView;
import java.text.SimpleDateFormat;
-import java.util.Date;
-import java.util.List;
+import java.util.*;
@RestController
@RequestMapping({"/hxzk"})
@@ -55,10 +50,20 @@
@Autowired
CompanyMapper companyMapper;
+ @Autowired
+ ManagerMapper managerMapper;
@GetMapping({"findDuanxinlog"})
result<List<Duanxinlog>> findDuanxinlog(Integer page, Integer limit) {
PageInfo<Duanxinlog> cz = this.duanxinlogService.FindDuanxinlog(page, limit);
return resultutil.returnSuccess(cz.getTotal(), cz.getList());
+ }
+ @PostMapping({"DeleteDuanxinlog"})
+ public ModelAndView DeleteManager(String num) {
+ this.duanxinlogService.DeleteDuanxinlog(num);
+ ModelAndView modelAndView = new ModelAndView();
+ modelAndView.setViewName("/page/Duanxinlog.jsp");
+ return modelAndView;
+
}
/*
@@ -88,7 +93,7 @@
queryWrapper3.eq("none", "0");
queryWrapper3.eq("companyName", fuwuqiList.get(i).getCompany());
Company companyList = (companyMapper).selectOne(queryWrapper3);
- SimpleDateFormat date2 = new SimpleDateFormat("yyyy-MM-dd");
+ SimpleDateFormat date2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date date = new Date();
Date endDay = date2.parse(fuwuqiList.get(i).getEnddate());//缁撴潫鏃堕棿
Long starTime = date.getTime();
@@ -100,7 +105,6 @@
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
String dtext = formatter.format(date);
if (dispatchDate == null || !dtext.equals(dispatchDate)) {
-
// 瀹炰緥鍖栦竴涓璇佸璞★紝鍏ュ弬闇�瑕佷紶鍏ヨ吘璁簯璐︽埛 SecretId 鍜� SecretKey锛屾澶勮繕闇�娉ㄦ剰瀵嗛挜瀵圭殑淇濆瘑
// 浠ｇ爜娉勯湶鍙兘浼氬鑷� SecretId 鍜� SecretKey 娉勯湶锛屽苟濞佽儊璐﹀彿涓嬫墍鏈夎祫婧愮殑瀹夊叏鎬с�備互涓嬩唬鐮佺ず渚嬩粎渚涘弬鑰冿紝寤鸿閲囩敤鏇村畨鍏ㄧ殑鏂瑰紡鏉ヤ娇鐢ㄥ瘑閽ワ紝璇峰弬瑙侊細https://cloud.tencent.com/document/product/1278/85305
// 瀵嗛挜鍙墠寰�瀹樼綉鎺у埗鍙� https://console.cloud.tencent.com/cam/capi 杩涜鑾峰彇
@@ -117,6 +121,27 @@
SendSmsRequest req = new SendSmsRequest();
// String[] phoneNumberSet1 = {"18701153496"};
String[] phoneNumberSet1 = {DESUtil.decrypt(companyList.getLoginphone(), DESUtil.key)};
+ QueryWrapper sms = new QueryWrapper();
+ sms.eq("none", "0");
+ sms.eq("smsreception", "1");
+ List<Manager> managerList = (managerMapper).selectList(sms);
+ for (int s=0;s<managerList.size();s++){
+// System.out.println(managerList.get(s).getPhone());
+// phoneNumberSet1[s] = managerList.get(s).getPhone();
+ String[] phoneNumberSet12 = {managerList.get(s).getPhone()};
+ System.out.println(phoneNumberSet12);
+ req.setPhoneNumberSet(phoneNumberSet12);
+
+ req.setSmsSdkAppId("1400838975");
+ req.setSignName("鍖椾含鍗庢槦鍖楁枟鏅烘帶");
+ req.setTemplateId("2100321");
+
+// String[] templateParamSet1 = {String.valueOf(+num11 / 24 / 60 / 60 / 1000)};
+ String[] templateParamSet1 = {String.valueOf("鎮ㄦ湁娴侀噺鍗″皢浜庯細" + fuwuqiList.get(i).getEnddate()+"鍒版湡锛�")};
+ req.setTemplateParamSet(templateParamSet1);
+ // 杩斿洖鐨剅esp鏄竴涓猄endSmsResponse鐨勫疄渚嬶紝涓庤姹傚璞″搴�
+ SendSmsResponse resp = client.SendSms(req);
+ }
req.setPhoneNumberSet(phoneNumberSet1);
req.setSmsSdkAppId("1400838975");
@@ -157,14 +182,14 @@
*/
// @EnableScheduling
// @Scheduled(cron = "*/10 * * * * ?")//娴嬭瘯10绉掓墽琛屼竴娆�
-// @Scheduled(cron = "0 0 16 * * ?")
+// @Scheduled(cron = "0 11 16 * * ?")
@Scheduled(cron = "0 0 */1 * * ?")//涓�灏忔椂鎵ц涓�娆�
public void sms() throws Exception {
System.out.println("鐭俊瀹氭椂鍣ㄦ墽琛�============銆嬨�嬨�嬨�嬨�嬨�嬨�嬨�嬨�嬨�嬨�嬨�嬨�嬨�嬨�嬨��");
//鏌ヨ鏁版嵁搴撲腑鎵�鏈夌殑寮曟搸鏁版嵁
QueryWrapper queryWrapper = new QueryWrapper();
queryWrapper.eq("none", "0");
-// queryWrapper.eq("num", "8");
+// queryWrapper.eq("num", "1");
List<Card> cardList = (cardMapper).selectList(queryWrapper);
for (int i = 0; i < cardList.size(); i++) {
QueryWrapper queryWrapper3 = new QueryWrapper();
@@ -184,12 +209,14 @@
Long starTime = date.getTime();
Long endTime = endDay.getTime();
Long num11 = endTime - starTime;//鏃堕棿鎴�
+
if (+num11 / 24 / 60 / 60 / 1000 == 19 | +num11 / 24 / 60 / 60 / 1000 == 9 | +num11 / 24 / 60 / 60 / 1000 == 4 | +num11 / 24 / 60 / 60 / 1000 == 0) {
String dispatchDate = this.duanxinlogService.userdate(cardList.get(i).getCardnumber());
// String dispatchDate = this.duanxinlogService.userdate(cardList.get(i).getCardnumber());
- SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
- String dtext = formatter.format(date);
- if (dispatchDate == null || !dtext.equals(dispatchDate)) {
+ SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+ Date dtext = formatter.parse(dispatchDate);//缁撴潫鏃堕棿
+ Long endTime1 = dtext.getTime();
+ if ((endTime1-starTime) / 24 / 60 / 60 / 1000 != 0) {
String randomNumber = new String();
// 瀹炰緥鍖栦竴涓璇佸璞★紝鍏ュ弬闇�瑕佷紶鍏ヨ吘璁簯璐︽埛 SecretId 鍜� SecretKey锛屾澶勮繕闇�娉ㄦ剰瀵嗛挜瀵圭殑淇濆瘑
// 浠ｇ爜娉勯湶鍙兘浼氬鑷� SecretId 鍜� SecretKey 娉勯湶锛屽苟濞佽儊璐﹀彿涓嬫墍鏈夎祫婧愮殑瀹夊叏鎬с�備互涓嬩唬鐮佺ず渚嬩粎渚涘弬鑰冿紝寤鸿閲囩敤鏇村畨鍏ㄧ殑鏂瑰紡鏉ヤ娇鐢ㄥ瘑閽ワ紝璇峰弬瑙侊細https://cloud.tencent.com/document/product/1278/85305
@@ -208,6 +235,33 @@
// String[] phoneNumberSet1 = {cardList.get(i).getCardnumber()};
String[] phoneNumberSet1 = {DESUtil.decrypt(companyList.getLoginphone(), DESUtil.key)};
// String[] phoneNumberSet1 = {"18701153496"};
+ QueryWrapper sms = new QueryWrapper();
+ sms.eq("none", "0");
+ sms.eq("smsreception", "1");
+ List<Manager> managerList = (managerMapper).selectList(sms);
+ String string = new String();
+ for (int s=0;s<managerList.size();s++){
+
+ if (s!=0){
+ string+=",";
+ }
+ string += managerList.get(s).getPhone();
+ String[] phoneNumberSet12 = {managerList.get(s).getPhone()};
+ System.out.println(phoneNumberSet12);
+ req.setPhoneNumberSet(phoneNumberSet12);
+
+ req.setSmsSdkAppId("1400838975");
+ req.setSignName("鍖椾含鍗庢槦鍖楁枟鏅烘帶");
+ req.setTemplateId("2100321");
+
+// String[] templateParamSet1 = {String.valueOf(+num11 / 24 / 60 / 60 / 1000)};
+ String[] templateParamSet1 = {String.valueOf("鎮ㄦ湁娴侀噺鍗″皢浜庯細" + cardList.get(i).getEnddate()+"鍒版湡锛�")};
+ req.setTemplateParamSet(templateParamSet1);
+ // 杩斿洖鐨剅esp鏄竴涓猄endSmsResponse鐨勫疄渚嬶紝涓庤姹傚璞″搴�
+ SendSmsResponse resp = client.SendSms(req);
+ }
+// phoneNumberSet1[managerList.size()] = DESUtil.decrypt(companyList.getLoginphone(), DESUtil.key);
+// System.out.println(phoneNumberSet1);
req.setPhoneNumberSet(phoneNumberSet1);
req.setSmsSdkAppId("1400838975");
@@ -219,11 +273,12 @@
req.setTemplateParamSet(templateParamSet1);
// 杩斿洖鐨剅esp鏄竴涓猄endSmsResponse鐨勫疄渚嬶紝涓庤姹傚璞″搴�
SendSmsResponse resp = client.SendSms(req);
+ System.out.println(SendSmsResponse.toJsonString(resp));
// 杈撳嚭json鏍煎紡鐨勫瓧绗︿覆鍥炲寘
Duanxinlog duanxinlog = new Duanxinlog();
duanxinlog.setIdentification(cardList.get(i).getCardnumber());
duanxinlog.setReceiver(cardList.get(i).getCompany());
- duanxinlog.setNumber(phoneNumberSet1[0]);
+ duanxinlog.setNumber(string);
duanxinlog.setContent("灏婃暚鐨勭敤鎴凤紝鎮ㄥソ锛佹偍鏈夋祦閲忓崱灏嗕簬"+cardList.get(i).getEnddate()+"鍒版湡锛屼负閬垮厤褰卞搷鎮ㄧ殑姝ｅ父浣跨敤璇峰強鏃剁画璐癸紝鎮ㄥ彲鐧诲綍鍗庢槦鏅烘帶鍏徃鐗╄仈缃戠鐞嗗钩鍙版煡璇㈣鎯呯画璐癸紝濡傛湁鐤戦棶鍙挩璇㈡垜鍏徃瀹㈡湇浜哄憳锛岀鎮ㄧ敓娲绘剦蹇紒"
);
this.duanxinlogService.addDuanxinlog(duanxinlog);
--
Gitblit v1.9.3