From 6c40e04eb7c2060feb2533735cd3089d438965e5 Mon Sep 17 00:00:00 2001
From: nidapeng <jp@doumee.com>
Date: 星期二, 19 三月 2024 17:19:36 +0800
Subject: [PATCH] 整理
---
server/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncParkServiceImpl.java | 335 ++++++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 301 insertions(+), 34 deletions(-)
diff --git a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncParkServiceImpl.java b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncParkServiceImpl.java
index 5a769c6..a786ef7 100644
--- a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncParkServiceImpl.java
+++ b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncParkServiceImpl.java
@@ -1,28 +1,36 @@
package com.doumee.service.business.impl.hksync;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
+import com.doumee.config.DataSyncConfig;
import com.doumee.core.constants.ResponseStatus;
import com.doumee.core.exception.BusinessException;
import com.doumee.core.haikang.model.HKConstants;
+import com.doumee.core.haikang.model.param.BaseListPageResponse;
import com.doumee.core.haikang.model.param.BaseResponse;
-import com.doumee.core.haikang.model.param.request.AcsDeviceListRequest;
-import com.doumee.core.haikang.model.param.request.ParkListRequest;
-import com.doumee.core.haikang.model.param.respose.AcsDeviceInfoResponse;
-import com.doumee.core.haikang.model.param.respose.AcsDeviceListResponse;
+import com.doumee.core.haikang.model.param.request.*;
+import com.doumee.core.haikang.model.param.respose.AppointmentInfoResponse;
+import com.doumee.core.haikang.model.param.respose.ParkCrossRecordInfoResponse;
import com.doumee.core.haikang.model.param.respose.ParkListResponse;
import com.doumee.core.haikang.service.HKService;
import com.doumee.core.utils.Constants;
+import com.doumee.core.utils.DESUtil;
import com.doumee.core.utils.DateUtil;
-import com.doumee.dao.business.DeviceMapper;
+import com.doumee.core.utils.Utils;
+import com.doumee.dao.business.CarEventMapper;
import com.doumee.dao.business.ParksMapper;
-import com.doumee.dao.business.model.Device;
-import com.doumee.dao.business.model.Parks;
+import com.doumee.dao.business.join.ParkBookJoinMapper;
+import com.doumee.dao.business.model.*;
+import com.github.yulichang.wrapper.MPJLambdaWrapper;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
+import java.util.Objects;
/**
* 娴峰悍鍋滆溅搴撳悓姝ervice瀹炵幇
@@ -33,8 +41,136 @@
public class HkSyncParkServiceImpl extends HkSyncBaseServiceImpl {
@Autowired
+ private DataSyncConfig dataSyncConfig;
+ @Autowired
private ParksMapper parksMapper;
+ @Autowired
+ private ParkBookJoinMapper parkBookMapper;
+ @Autowired
+ private CarEventMapper carEventMapper;
+ @Override
+ public void syncParkBookData() {
+ if(Constants.DEALING_HK_PARKBOOK){
+ return ;
+ }
+ Constants.DEALING_HK_PARKBOOK =true;
+ try {
+ //鏌ヨ鎵�鏈夐渶瑕佸悓姝ョ殑鏁版嵁
+ List<ParkBook> list =getDealList ();
+ if(list ==null || list.size()==0){
+ return;
+ }
+ Date date = new Date();
+ //鍏堝嚭鎵�鏈夐渶瑕佸彇娑堝寘鏈熺殑鏁版嵁璁板綍
+ for(ParkBook c : list) {
+ if(Constants.equalsObject(c.getIsdeleted(),Constants.ONE)){
+ //濡傛灉鍙栨秷棰勭害锛屽垯杩涜鍙栨秷鍖呮湡
+ if(StringUtils.isNotBlank(c.getParkHkId())
+ && StringUtils.isNotBlank(c.getCarCode())){
+ boolean result = cancelParkBookHk(c);
+ c.setHkStatus(result?Constants.ONE:Constants.TWO);
+ c.setRemark(result?"鍙栨秷鍖呮湡鎴愬姛":"鍙栨秷鍖呮湡澶辫触");
+ }else{
+ c.setHkStatus(Constants.TWO);//涓嬪彂澶辫触
+ c.setRemark("鍙栨秷鍖呮湡澶辫触");
+ }
+ c.setHkDate(date);
+ parkBookMapper.updateById(c);
+ }
+ }
+ //澶勭悊鎵�鏈夐渶瑕佸寘鏈熺殑杞﹁締鏁版嵁璁板綍
+ for(ParkBook c : list) {
+ if(Constants.equalsObject(c.getIsdeleted(),Constants.ONE)) {
+ //鍒犻櫎鐨勫凡澶勭悊锛岃烦杩囧鐞�
+ continue;
+ }
+ //鏁版嵁涓嶅悎娉曪紝鐩存帴鎻愮ず涓嬪彂澶辫触
+ if(StringUtils.isNotBlank(c.getParkHkId())
+ && StringUtils.isNotBlank(c.getCarCode())){
+ boolean result = addParkBookHk(c);
+ c.setHkStatus(result?Constants.ONE:Constants.TWO);
+ c.setRemark(result?"鍖呮湡鎴愬姛":"鍖呮湡澶辫触");
+ }else{
+ c.setHkStatus(Constants.TWO);
+ c.setRemark("鍖呮湡澶辫触~");
+ }
+ c.setHkDate(date);
+ parkBookMapper.updateById(c);
+ }
+ }catch (Exception e){
+ e.printStackTrace();
+ }finally {
+ Constants.DEALING_HK_PARKBOOK =false;
+ }
+ }
+ @Override
+ public void syncParkBookBySingleModel(ParkBook c) {
+ if(Constants.equalsObject(c.getIsdeleted(),Constants.ONE)){
+ //濡傛灉鍙栨秷棰勭害锛屽垯杩涜鍙栨秷鍖呮湡
+ if(StringUtils.isNotBlank(c.getParkHkId())
+ && StringUtils.isNotBlank(c.getCarCode())){
+ boolean result = cancelParkBookHk(c);
+ c.setHkStatus(result?Constants.ONE:Constants.TWO);
+ c.setRemark(result?"鍙栨秷鍖呮湡鎴愬姛":"鍙栨秷鍖呮湡澶辫触");
+ }else{
+ c.setHkStatus(Constants.TWO);//涓嬪彂澶辫触
+ c.setRemark("鍙栨秷鍖呮湡澶辫触");
+ }
+ c.setHkDate(new Date());
+ parkBookMapper.updateById(c);
+ }else {
+ //澶勭悊鎵�鏈夐渶瑕佸寘鏈熺殑杞﹁締鏁版嵁璁板綍
+ //鏁版嵁涓嶅悎娉曪紝鐩存帴鎻愮ず涓嬪彂澶辫触
+ if (StringUtils.isNotBlank(c.getParkHkId())
+ && StringUtils.isNotBlank(c.getCarCode())) {
+ boolean result = addParkBookHk(c);
+ c.setHkStatus(result ? Constants.ONE : Constants.TWO);
+ c.setRemark(result ? "鍖呮湡鎴愬姛" : "鍖呮湡澶辫触");
+ } else {
+ c.setHkStatus(Constants.TWO);
+ c.setRemark("鍖呮湡澶辫触~");
+ }
+ c.setHkDate(new Date());
+ parkBookMapper.updateById(c);
+ }
+ }
+ private boolean addParkBookHk(ParkBook c) {
+ CarChargeAddRequest param = new CarChargeAddRequest();
+ param.setPlateNo(c.getCarCode());
+ param.setParkSyscode(c.getParkHkId());
+ param.setStartTime(Objects.isNull(c.getStartTime())?DateUtil.getDate(new Date(),"yyyy-MM-dd"):DateUtil.getShortTimeToNull(c.getStartTime()));
+ param.setEndTime(Objects.isNull(c.getEndTime())?"2999-12-31":DateUtil.getShortTimeToNull(c.getEndTime()));
+ BaseResponse response = HKService.carChargeAddtion(param);
+ if(response!=null
+ && StringUtils.equals(response.getCode(),HKConstants.RESPONSE_SUCCEE)){
+ return true;
+ }else{
+ return false;
+ }
+ }
+ private boolean cancelParkBookHk(ParkBook c) {
+ CarChargeDelRequest param = new CarChargeDelRequest();
+ param.setPlateNo(c.getCarCode());
+ param.setParkSyscode(c.getParkHkId());
+ BaseResponse response = HKService.carChargeDeletion(param);
+ if(response!=null
+ && StringUtils.equals(response.getCode(),HKConstants.RESPONSE_SUCCEE)){
+ return true;
+ }else{
+ return false;
+ }
+ }
+
+ private List<ParkBook> getDealList() {
+ MPJLambdaWrapper<ParkBook> queryWrapper = new MPJLambdaWrapper<>();
+ queryWrapper.selectAll(ParkBook.class);
+ queryWrapper.selectAs(Parks::getHkId,ParkBook::getParkHkId);
+ queryWrapper.leftJoin(Parks.class,Parks::getId,ParkBook::getParkId);
+ queryWrapper.selectAs(Device::getHkId,Empower::getDeviceIndexCode);
+ List<ParkBook> list = parkBookMapper.selectJoinList(ParkBook.class,queryWrapper.eq(ParkBook::getHkStatus,Constants.ZERO));
+ return list;
+ }
/**
* 鍚屾娴峰悍鍋滆溅搴撴暟鎹�
* @param param
@@ -43,36 +179,47 @@
@Override
// @Async
public String syncHkParks(ParkListRequest param){
- List<Parks> deleteList = new ArrayList<>();
- List<Parks> addList = new ArrayList<>();
- List<Parks> editList = new ArrayList<>();
- Date date = new Date();
- //鏌ヨ鍏ㄩ儴褰撳墠鏁版嵁
- List<Parks> allList = parksMapper.selectList(null);
+ if(Constants.DEALING_HK_SYNCPRIVILEGE){
+ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "鍚屾浠诲姟姝ｅ湪鎵ц鍝︼紝璇风◢鍚庢煡鐪嬬粨鏋滐紒") ;
+ }
+ Constants.DEALING_HK_SYNCPRIVILEGE =true;
+ try {
+ List<Parks> deleteList = new ArrayList<>();
+ List<Parks> addList = new ArrayList<>();
+ List<Parks> editList = new ArrayList<>();
+ Date date = new Date();
+ //鏌ヨ鍏ㄩ儴褰撳墠鏁版嵁
+ List<Parks> allList = parksMapper.selectList(null);
//鍒嗛〉閬嶅巻寰幆鏌ヨ鎵�鏈夐棬绂佽澶囨暟鎹�
- param = new ParkListRequest();
- BaseResponse<List<ParkListResponse>> response = HKService.parkList(param);
- if(response == null || !StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE)){
- throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "瀵逛笉璧凤紝娴峰悍鍚屾鏁版嵁澶辫触~");
- }
- List<ParkListResponse> allHkList = response.getData();
- // 鑾峰彇澧炲垹鏀规暟鎹泦鍚�
- getDataChangeList(allList,allHkList,addList,editList,deleteList,date);
- if(deleteList.size()>0){
- //閫昏緫鍒犻櫎
- for(Parks d : deleteList){
- parksMapper.updateById(d);
+ param = new ParkListRequest();
+ BaseResponse<List<ParkListResponse>> response = HKService.parkList(param);
+ if(response == null || !StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE)){
+ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "瀵逛笉璧凤紝娴峰悍鍚屾鏁版嵁澶辫触~");
}
- }
- if(addList.size()>0){
- parksMapper.insertBatchSomeColumn(addList);
- }
- if(editList.size()>0){
- for(Parks d : editList){
- parksMapper.updateById(d);
+ List<ParkListResponse> allHkList = response.getData();
+ // 鑾峰彇澧炲垹鏀规暟鎹泦鍚�
+ getDataChangeList(allList,allHkList,addList,editList,deleteList,date);
+ if(deleteList.size()>0){
+ //閫昏緫鍒犻櫎
+ for(Parks d : deleteList){
+ parksMapper.updateById(d);
+ }
}
+ if(addList.size()>0){
+ parksMapper.insertBatchSomeColumn(addList);
+ }
+ if(editList.size()>0){
+ for(Parks d : editList){
+ parksMapper.updateById(d);
+ }
+ }
+ return "鍚屾鏁版嵁锛氭柊澧炪��"+addList.size()+"銆戞潯锛屾洿鏂般��"+editList.size()+"銆戞潯锛屽垹闄ゃ��"+deleteList.size()+"銆戞潯";
+ }catch (Exception e){
+ e.printStackTrace();
+ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "鍚屾澶辫触锛�");
+ }finally {
+ Constants.DEALING_HK_SYNCPRIVILEGE =false;
}
- return "鍚屾鏁版嵁锛氭柊澧炪��"+addList.size()+"銆戞潯锛屾洿鏂般��"+editList.size()+"銆戞潯锛屽垹闄ゃ��"+deleteList.size()+"銆戞潯";
}
private void getDataChangeList(List<Parks> allList, List<ParkListResponse> allHkList, List<Parks> addList, List<Parks> editList,List<Parks> deleteList, Date date) {
if(allHkList!=null && allHkList.size()>0){
@@ -109,6 +256,7 @@
model.setEditDate(DateUtil.getISO8601DateByStr(device.getUpdateTime()));
model.setHkId(device.getParkIndexCode());
model.setHkStatus(Constants.ONE);
+ model.setStatus(Constants.ONE);
return model;
}
@@ -148,5 +296,124 @@
return true;
}
-
+
+
+
+ @Override
+ @Transactional
+ public void syncParkRecords(Date date){
+ try {
+ if( Constants.formatIntegerNum(dataSyncConfig.getVisitorDataOrigin()) != DataSyncConfig.origin.hk){
+ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝褰撳墠涓嶆敮鎸佹捣搴锋暟鎹悓姝ユ搷浣渵");
+ }
+ ParkCrossRecordListRequest param = new ParkCrossRecordListRequest();
+ //锛堝叏閲忓悓姝ワ級
+ boolean hasNext = true;
+ int curTotal = 0;
+ int curPage = 1;
+ //鏌ヨ浠婂ぉ鐨�
+ Date start = Utils.Date.getStart(date);
+ Date end = new Date();
+ if(DateUtil.daysBetweenDates(end,start) >1){
+ end = Utils.Date.getEnd(date);
+ }
+ param.setStartTime(DateUtil.getISO8601Timestamp2( start));
+ param.setEndTime(DateUtil.getISO8601Timestamp2( end));
+
+ List<CarEvent> allHkList = new ArrayList<>();
+ while (hasNext){
+ //鍒嗛〉閬嶅巻寰幆鏌ヨ鎵�鏈夐棬绂佽澶囨暟鎹�
+ param.setPageNo(curPage);
+ param.setPageSize(100);
+ BaseResponse<BaseListPageResponse<ParkCrossRecordInfoResponse>> response = HKService.parkCrossRecords(param);
+ if(response == null || !StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) ){
+ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "瀵逛笉璧凤紝娴峰悍鍚屾鏁版嵁澶辫触~");
+ }
+ if(response.getData() == null || response.getData().getTotal() ==0){
+ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈悓姝ュ埌浠讳綍淇℃伅锛�");
+ }
+ BaseListPageResponse<ParkCrossRecordInfoResponse> r = response.getData();
+ curTotal += 100;
+ if(curTotal >= r.getTotal()){
+ hasNext = false;
+ }
+ if(r.getList() == null || r.getList().size()==0){
+ hasNext =false;
+ }else{
+ allHkList.addAll(getNewCarEventModelBYList(r.getList()));
+ }
+ curPage++;
+ }
+ if(allHkList .size() == 0){
+ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈悓姝ュ埌浠讳綍淇℃伅锛�");
+ }
+ //娓呯┖鍘熸湁褰撳ぉ鐨勬暟鎹�
+ carEventMapper.delete(new UpdateWrapper<CarEvent>().lambda()
+ .ge(CarEvent::getCreateDate,start)
+ .le(CarEvent::getCreateDate,end));
+ if(allHkList.size()>0){
+ int sublistSize = 500;
+
+ int startIndex = 0;
+ int endIndex = sublistSize;
+
+ while (startIndex < allHkList.size()) {
+ if (endIndex > allHkList.size()) {
+ endIndex = allHkList.size();
+ }
+
+ List<CarEvent> sublist = allHkList.subList(startIndex, endIndex);
+ if(sublist.size()>0){
+ carEventMapper.insertBatchSomeColumn(sublist);//鎻掑叆鏂版暟鎹�
+ }
+ startIndex = endIndex;
+ endIndex += sublistSize;
+ }
+ }
+
+ }catch (BusinessException e){
+ throw e;
+ }
+ }
+
+ private List<CarEvent> getNewCarEventModelBYList(List<ParkCrossRecordInfoResponse> list ) {
+ List<CarEvent> newList = new ArrayList<>();
+ if(list == null || list.size()==0){
+ return newList;
+ }
+ for(ParkCrossRecordInfoResponse model :list){
+ if( model.getReleaseResult() ==null || !( model.getReleaseResult() == 1|| model.getReleaseResult() == 2 )){
+ continue;
+ }
+ CarEvent c = new CarEvent();
+ c.setHappenTime(model.getCrossTime());
+ c.setCreateDate(DateUtil.getISO8601DateByStr2(model.getCrossTime()));
+ c.setSvrIndex(model.getAswSyscode());
+ c.setVehiclePicUrl(model.getVehiclePicUri());
+ c.setPlatePicUrl(model.getPlateNoPicUri());
+ c.setVehicleType(model.getVehicleType());
+ c.setPlateColor(model.getPlateColor());
+ c.setPlateType(model.getPlateType());
+ c.setCardNo(model.getCardNo());
+ c.setReleaseReason(model.getReleaseReason());
+ c.setPlateNos(model.getPlateNo());
+ c.setReleaseResult(model.getReleaseResult());
+ c.setInoutType(model.getVehicleOut());
+ c.setParkIndex(model.getParkSyscode());
+ c.setParkName(model.getParkName());
+ c.setEventId(model.getCrossRecordSyscode());
+ c.setGateIndex(model.getEntranceSyscode());
+ c.setGateName(model.getEntranceName());
+ c.setIsdeleted(Constants.ZERO);
+ if(model.getVehicleOut() !=null &&model.getVehicleOut() == 0 ){
+ c.setEventType(HKConstants.EventTypes.PARK_PASS_IN.getKey());
+ }else {
+ c.setEventType(HKConstants.EventTypes.PARK_PASS_OUT.getKey());
+ }
+ newList.add(c);
+ }
+ return newList;
+ }
+
+
}
--
Gitblit v1.9.3