From 08363052cecb30230a2c8b3eba791ca8d1be00a5 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Tue, 31 Aug 2021 15:32:38 +0800
Subject: [PATCH] 二维码生成地址修改，保安证编码生成修改
---
src/main/java/org/springblade/modules/location/controller/LiveLocationController.java | 34 ++++++++++++++++++++++++++++++++++
1 files changed, 34 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/location/controller/LiveLocationController.java b/src/main/java/org/springblade/modules/location/controller/LiveLocationController.java
index 778c516..2d73bbe 100644
--- a/src/main/java/org/springblade/modules/location/controller/LiveLocationController.java
+++ b/src/main/java/org/springblade/modules/location/controller/LiveLocationController.java
@@ -8,6 +8,7 @@
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.Func;
+import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.location.entity.LiveLocation;
import org.springblade.modules.location.entity.Locus;
import org.springblade.modules.location.service.LiveLocationService;
@@ -16,6 +17,7 @@
import org.springblade.modules.location.vo.LocusVo;
import org.springframework.web.bind.annotation.*;
+import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
@@ -71,12 +73,34 @@
//新增
liveLocation.setRecordTime(new Date());
status = liveLocationService.save(liveLocation);
+ //数据推送
+ String s1 =
+ "insert into sys_live_location(id,type,worker_id,longitude,latitude,record_time,location) " +
+ "values(" + "'" + liveLocation.getId() + "'" + "," +
+ "'" + liveLocation.getType() + "'" + "," +
+ "'" + liveLocation.getWorkerId() + "'" + "," +
+ "'" + liveLocation.getLongitude() + "'" + "," +
+ "'" + liveLocation.getLatitude() + "'" + "," +
+ "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(liveLocation.getRecordTime()) + "'" + "," +
+ "'" +liveLocation.getLocation() + "'" + ")";
+ FtpUtil.sqlFileUpload(s1);
}else {
//更新
liveLocationInfo.setRecordTime(new Date());
liveLocationInfo.setLongitude(liveLocation.getLongitude());
liveLocationInfo.setLatitude(liveLocation.getLatitude());
status = liveLocationService.updateById(liveLocationInfo);
+
+ //内网同步
+ String s1 =
+ "update sys_live_location set type = " + "'" + liveLocation.getType() + "'" +
+ ",worker_id = " + "'" + liveLocation.getWorkerId() + "'" +
+ ",longitude = " + "'" + liveLocation.getLongitude() + "'" +
+ ",latitude = " + "'" + liveLocation.getLatitude() + "'" +
+ ",record_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(liveLocation.getRecordTime()) + "'" +
+ ",location = " + "'" + liveLocation.getLocation() + "'" +
+ " " +"where id = " + "'" + liveLocation.getId() + "'";
+ FtpUtil.sqlFileUpload(s1);
}
if (status){
@@ -95,6 +119,16 @@
locus.setRecordTime(new Date());
//新增轨迹
boolean save1 = locusService.save(locus);
+ //数据推送
+ String s2 =
+ "insert into sys_locus(id,live_location_id,record_time,longitude,latitude) " +
+ "values(" + "'" + locus.getId() + "'" + "," +
+ "'" + locus.getLiveLocationId() + "'" + "," +
+ "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(locus.getRecordTime()) + "'" + "," +
+ "'" + locus.getLongitude() + "'" + "," +
+ "'" +locus.getLatitude() + "'" + ")";
+ FtpUtil.sqlFileUpload(s2);
+
if (save1){
//返回数据
return R.status(true);
--
Gitblit v1.9.3