admin/src/api/business/platformEvent.js
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,18 @@ import request from '../../utils/request' // æ¥è¯¢ export function fetchList (data) { return request.post('/visitsAdmin/cloudService/business/platformEvent/page', data, { trim: true }) } // 导åºExcel export function exportExcel (data) { return request.post('/visitsAdmin/cloudService/business/platformEvent/exportExcel', data, { trim: true, download: true }) } admin/src/views/business/platformEvent.vue
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,161 @@ <template> <TableLayout :permissions="['business:interfacelog:query']"> <!-- æç´¢è¡¨å --> <el-form ref="searchForm" slot="search-form" :model="searchForm" label-width="100px" inline> <el-form-item label="" prop="platformName"> <el-input v-model="searchForm.platformName" placeholder="请è¾å ¥æå°åç§°" @keypress.enter.native="search"></el-input> </el-form-item> <el-form-item label="" prop="channelName"> <el-input v-model="searchForm.channelName" placeholder="请è¾å ¥çæ§ç¹åç§°" @keypress.enter.native="search"></el-input> </el-form-item> <el-form-item label="" prop="plateNo"> <el-input v-model="searchForm.plateNo" placeholder="请è¾å ¥è½¦çå·" @keypress.enter.native="search"></el-input> </el-form-item> <el-form-item label="" prop="eventType"> <el-select v-model="searchForm.motionStatus" placeholder="è¯·éæ©è¿åºç±»å"> <el-option label="离å¼" value="leave"></el-option> <el-option label="è¿å ¥" value="enter"></el-option> </el-select> </el-form-item> <el-form-item label="èµ·æ¢æ¶é´" prop="startDate"> <el-date-picker @change="seleTime" v-model="time" type="datetimerange" format="yyyy-MM-dd HH:mm:ss" value-format="yyyy-MM-dd HH:mm:ss" range-separator="è³" start-placeholder="å¼å§æ¶é´" end-placeholder="ç»ææ¶é´"> </el-date-picker> </el-form-item> <el-radio-group v-model="searchForm.radio" size="small" @input="changeRadio"> <el-radio-button label="0">å½å¤©</el-radio-button> <el-radio-button label="1">è¿7天</el-radio-button> <el-radio-button label="2">è¿30天</el-radio-button> </el-radio-group> <section> <el-button type="primary" @click="search">æç´¢</el-button> <el-button @click="reset">éç½®</el-button> </section> </el-form> <!-- è¡¨æ ¼åå页 --> <template v-slot:table-wrap> <el-table v-loading="isWorking.search" :data="tableData.list" stripe > <el-table-column prop="platformName" label="æå°åç§°" min-width="180px"></el-table-column> <el-table-column prop="channelName" label="çæ§ç¹åç§°" min-width="180px"></el-table-column> <el-table-column prop="plateNo" label="车çå·" min-width="180px"></el-table-column> <el-table-column label="车è¾è¿åºç±»å" min-width="180px"> <template slot-scope="{row}"> <span v-if="row.motionStatus == 'enter'">è¿å ¥span> <span v-if="row.motionStatus == 'leave'">离å¼</span> <span v-if="row.motionStatus != 'leave' && row.motionStatus != 'enter'">{{ row.motionStatus }}</span> </template> </el-table-column> <el-table-column label="ååæ è¯" min-width="180px"> <template slot-scope="{row}"> <span v-if="row.stockStatus == 'rear'">车尾</span> <span v-if="row.stockStatus == 'front'">车头</span> <span v-if="row.stockStatus != 'rear' && row.stockStatus != 'front'">{{ row.stockStatus }}</span> </template> </el-table-column> <el-table-column prop="stockStatus" label="车é¨ç¶æ" min-width="180px"></el-table-column> <el-table-column label="车é¨ç¶æ" min-width="100px"> <template slot-scope="{row}"> <span v-if="row.vehicleDoorStatus == 'open'">å¼é¨</span> <span v-if="row.vehicleDoorStatus == 'close'">å ³é¨</span> <span v-if="row.vehicleDoorStatus != 'open' && row.vehicleDoorStatus != 'close'">{{ row.vehicleDoorStatus }}</span> </template> </el-table-column> <el-table-column prop="deviceId" label="设å¤ç¼ç " min-width="150px"></el-table-column> <el-table-column prop="ipAddress" label="IPå°å" min-width="100px"></el-table-column> <el-table-column prop="portNo" label="端å£" min-width="100px"></el-table-column> <el-table-column fixed="right" label="ææå¾" min-width="100px"> <template slot-scope="{row}"> <el-image v-if="row.backgroundImageDown" style="width: 60px; height: 60px" :src="row.backgroundImageDown" :preview-src-list="[row.backgroundImageDown]"> </el-image> </template> </el-table-column> <el-table-column prop="createDate" label="å建æ¶é´" min-width="100px"></el-table-column> </el-table> <pagination @size-change="handleSizeChange" @current-change="handlePageChange" :pagination="tableData.pagination" > </pagination> </template> </TableLayout> </template> <script> import BaseTable from '@/components/base/BaseTable' import TableLayout from '@/layouts/TableLayout' import Pagination from '@/components/common/Pagination' import { timeForMat } from '@/utils/util' export default { name: 'platformEvent', extends: BaseTable, components: { TableLayout, Pagination }, data () { return { // æç´¢ searchForm: { plateNo: '', motionStatus: '', channelName: '', platformName: '', endDate: '', startDate: '', radio: '0' }, time: [] } }, created () { this.config({ module: 'æå°è½¦è¾ç¶æäºä»¶äº¤äºè®°å½', api: '/business/platformEvent', 'field.id': 'id', 'field.main': 'id' }) this.changeRadio('0') }, methods: { changeRadio (e) { if (e === '0') { this.searchForm.startDate = timeForMat(0)[0] this.searchForm.endDate = timeForMat(0)[1] this.time = timeForMat(0) } else if (e === '1') { this.searchForm.startDate = timeForMat(6)[0] this.searchForm.endDate = timeForMat(6)[1] this.time = timeForMat(6) } else if (e === '2') { this.searchForm.startDate = timeForMat(29)[0] this.searchForm.endDate = timeForMat(29)[1] this.time = timeForMat(29) } this.search() }, seleTime (e) { this.searchForm.startDate = e[0] this.searchForm.endDate = e[1] this.searchForm.radio = null this.search() }, reset () { this.$refs.searchForm.resetFields() this.searchForm.startDate = '' this.searchForm.endDate = '' this.time = [] this.search() } } } </script> server/system_service/src/main/java/com/doumee/core/utils/Constants.java
@@ -71,6 +71,7 @@ // 访客æ¥è®¿é ç½® public static final String VISIT_CONFIG = "VISIT_CONFIG"; public static final String MEMBER_IMG = "MEMBER_IMG"; public static final String PLATFORM_EVENT_IMG = "PLATFORM_EVENT_IMG"; public static final String VISIT_NOTICE = "VISIT_NOTICE"; //å¥åº·è¯é ç½® public static final String LW_HEALTH_CARD = "LW_HEALTH_CARD"; server/system_service/src/main/java/com/doumee/core/utils/HttpsUtil.java
@@ -1,5 +1,7 @@ package com.doumee.core.utils; import org.springframework.http.HttpMethod; import javax.net.ssl.*; import java.io.ByteArrayOutputStream; import java.io.InputStream; @@ -87,6 +89,40 @@ } return null; } public static InputStream connectionInputsteam(String url,String method,String data,String contentType ){ HttpURLConnection connection = null; try { URL _url = new URL(url); connection = (HttpURLConnection) _url.openConnection(); connection.setRequestMethod(method); connection.setDoOutput(true); connection.setDoInput(true); connection.setUseCaches(false); if(contentType != null){ connection.setRequestProperty("Content-Type", contentType); } connection.connect(); if(data != null){ OutputStream outputStream = connection.getOutputStream(); outputStream.write(data.getBytes("utf-8")); outputStream.close(); } int responseCode = connection.getResponseCode(); if (responseCode == HttpsURLConnection.HTTP_OK) { return connection.getInputStream(); } } catch (Exception e) { e.printStackTrace(); } finally { if(connection != null){ connection.disconnect(); } } return null; } public static String connectionHttp(String url,String method,String data,String contentType ){ HttpURLConnection connection = null; try { server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/PlatformDeviceCloudController.java
@@ -1,21 +1,21 @@ package com.doumee.cloud.admin; import com.doumee.api.BaseController; import com.doumee.config.annotation.CloudRequiredPermission; import com.doumee.core.annotation.excel.ExcelExporter; import com.doumee.core.annotation.pr.PreventRepeat; import com.doumee.core.model.ApiResponse; import com.doumee.core.model.PageWrap; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.dao.business.model.PlatformDevice; import com.doumee.service.business.PlatformDeviceService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.apache.shiro.authz.annotation.RequiresPermissions; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpServletResponse; import java.util.ArrayList; import java.util.List; @@ -34,14 +34,14 @@ @PreventRepeat @ApiOperation("æ°å»º") @PostMapping("/create") @RequiresPermissions("business:platformdevice:create") @CloudRequiredPermission("business:platformdevice:create") public ApiResponse create(@RequestBody PlatformDevice platformDevice) { return ApiResponse.success(platformDeviceService.create(platformDevice)); } @ApiOperation("æ ¹æ®IDå é¤") @GetMapping("/delete/{id}") @RequiresPermissions("business:platformdevice:delete") @CloudRequiredPermission("business:platformdevice:delete") public ApiResponse deleteById(@PathVariable Integer id) { platformDeviceService.deleteById(id); return ApiResponse.success(null); @@ -49,7 +49,7 @@ @ApiOperation("æ¹éå é¤") @GetMapping("/delete/batch") @RequiresPermissions("business:platformdevice:delete") @CloudRequiredPermission("business:platformdevice:delete") public ApiResponse deleteByIdInBatch(@RequestParam String ids) { String [] idArray = ids.split(","); List<Integer> idList = new ArrayList<>(); @@ -62,30 +62,30 @@ @ApiOperation("æ ¹æ®IDä¿®æ¹") @PostMapping("/updateById") @RequiresPermissions("business:platformdevice:update") public ApiResponse updateById(@RequestBody PlatformDevice platformDevice) { @CloudRequiredPermission("business:platformdevice:update") public ApiResponse updateById(@RequestBody PlatformDevice platformDevice,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { platformDeviceService.updateById(platformDevice); return ApiResponse.success(null); } @ApiOperation("å页æ¥è¯¢") @PostMapping("/page") @RequiresPermissions("business:platformdevice:query") public ApiResponse<PageData<PlatformDevice>> findPage (@RequestBody PageWrap<PlatformDevice> pageWrap) { @CloudRequiredPermission("business:platformdevice:query") public ApiResponse<PageData<PlatformDevice>> findPage (@RequestBody PageWrap<PlatformDevice> pageWrap,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { return ApiResponse.success(platformDeviceService.findPage(pageWrap)); } @ApiOperation("导åºExcel") @PostMapping("/exportExcel") @RequiresPermissions("business:platformdevice:exportExcel") public void exportExcel (@RequestBody PageWrap<PlatformDevice> pageWrap, HttpServletResponse response) { @CloudRequiredPermission("business:platformdevice:exportExcel") public void exportExcel (@RequestBody PageWrap<PlatformDevice> pageWrap, HttpServletResponse response,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { ExcelExporter.build(PlatformDevice.class).export(platformDeviceService.findPage(pageWrap).getRecords(), "æå°_å ³èçæ§ç¹LEDå广æä¿¡æ¯è¡¨", response); } @ApiOperation("æ ¹æ®IDæ¥è¯¢") @GetMapping("/{id}") @RequiresPermissions("business:platformdevice:query") public ApiResponse findById(@PathVariable Integer id) { @CloudRequiredPermission("business:platformdevice:query") public ApiResponse findById(@PathVariable Integer id,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { return ApiResponse.success(platformDeviceService.findById(id)); } } server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/PlatformEventCloudController.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,91 @@ package com.doumee.cloud.admin; import com.doumee.api.BaseController; import com.doumee.config.annotation.CloudRequiredPermission; import com.doumee.core.annotation.excel.ExcelExporter; import com.doumee.core.annotation.pr.PreventRepeat; import com.doumee.core.model.ApiResponse; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.dao.business.model.PlatformEvent; import com.doumee.service.business.PlatformEventService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; import java.util.ArrayList; import java.util.List; /** * @author æ±è¹è¹ * @date 2024/08/28 17:24 */ @Api(tags = "æå°_车è¾è¿åºäºä»¶æ¨éè®°å½è¡¨") @RestController @RequestMapping(Constants.CLOUD_SERVICE_URL_INDEX+"/business//platformEvent") public class PlatformEventCloudController extends BaseController { @Autowired private PlatformEventService platformEventService; @PreventRepeat @ApiOperation("æ°å»º") @PostMapping("/create") @CloudRequiredPermission("business:platformevent:create") public ApiResponse create(@RequestBody PlatformEvent platformEvent,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { return ApiResponse.success(platformEventService.create(platformEvent)); } @ApiOperation("æ ¹æ®IDå é¤") @GetMapping("/delete/{id}") @CloudRequiredPermission("business:platformevent:delete") public ApiResponse deleteById(@PathVariable Integer id,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { platformEventService.deleteById(id); return ApiResponse.success(null); } @ApiOperation("æ¹éå é¤") @GetMapping("/delete/batch") @CloudRequiredPermission("business:platformevent:delete") public ApiResponse deleteByIdInBatch(@RequestParam String ids,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { String [] idArray = ids.split(","); List<Integer> idList = new ArrayList<>(); for (String id : idArray) { idList.add(Integer.valueOf(id)); } platformEventService.deleteByIdInBatch(idList); return ApiResponse.success(null); } @ApiOperation("æ ¹æ®IDä¿®æ¹") @PostMapping("/updateById") @CloudRequiredPermission("business:platformevent:update") public ApiResponse updateById(@RequestBody PlatformEvent platformEvent,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { platformEventService.updateById(platformEvent); return ApiResponse.success(null); } @ApiOperation("å页æ¥è¯¢") @PostMapping("/page") @CloudRequiredPermission("business:platformevent:query") public ApiResponse<PageData<PlatformEvent>> findPage (@RequestBody PageWrap<PlatformEvent> pageWrap,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { return ApiResponse.success(platformEventService.findPage(pageWrap)); } @ApiOperation("导åºExcel") @PostMapping("/exportExcel") @CloudRequiredPermission("business:platformevent:exportExcel") public void exportExcel (@RequestBody PageWrap<PlatformEvent> pageWrap, HttpServletResponse response,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { ExcelExporter.build(PlatformEvent.class).export(platformEventService.findPage(pageWrap).getRecords(), "æå°è½¦è¾è¿åºäºä»¶æ¨éè®°å½è¡¨", response); } @ApiOperation("æ ¹æ®IDæ¥è¯¢") @GetMapping("/{id}") @CloudRequiredPermission("business:platformevent:query") public ApiResponse findById(@PathVariable Integer id,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { return ApiResponse.success(platformEventService.findById(id)); } } server/visits/dmvisit_service/src/main/java/com/doumee/core/haikang/model/param/respose/PlatformCameraInfoResponse.java
@@ -6,6 +6,6 @@ public class PlatformCameraInfoResponse { private String cameraIdompan;// String false çæ§ç¹ID private String cameraId;// String false çæ§ç¹ID private String cameraName ;//String false çæ§ç¹åç§° } server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/PlatformEventMapper.java
@@ -2,11 +2,12 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.doumee.dao.business.model.PlatformEvent; import com.github.yulichang.base.MPJBaseMapper; /** * @author æ±è¹è¹ * @date 2024/08/28 17:24 */ public interface PlatformEventMapper extends BaseMapper<PlatformEvent> { public interface PlatformEventMapper extends MPJBaseMapper<PlatformEvent> { } server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/PlatformEvent.java
@@ -1,5 +1,6 @@ package com.doumee.dao.business.model; import com.baomidou.mybatisplus.annotation.TableField; import com.doumee.core.annotation.excel.ExcelColumn; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; @@ -46,6 +47,9 @@ @ApiModelProperty(value = "æ¯å¦å é¤0å¦ 1æ¯", example = "1") @ExcelColumn(name="æ¯å¦å é¤0å¦ 1æ¯") private Integer isdeleted; @ApiModelProperty(value = "æå°ç¼ç ,å ³èplatform表", example = "1") @ExcelColumn(name="æå°ç¼ç ,å ³èplatform表") private Integer platformId; @ApiModelProperty(value = "夿³¨") @ExcelColumn(name="夿³¨") @@ -158,8 +162,8 @@ @ExcelColumn(name="车é¨ç¶æÂ open-å¼é¨ï¼close-å ³é¨") private String vehicleDoorStatus; @ApiModelProperty(value = "è½¦å¤´è½¦å°¾ç¶æÂ Â front#车头,rear#车尾", example = "1") @ExcelColumn(name="è½¦å¤´è½¦å°¾ç¶æÂ Â front#车头,rear#车尾") @ApiModelProperty(value = "è½¦å¤´è½¦å°¾ç¶æfront#车头,rear#车尾", example = "1") @ExcelColumn(name="è½¦å¤´è½¦å°¾ç¶æfront#车头,rear#车尾") private String stockStatus; @ApiModelProperty(value = "车çè¯å[0-100]", example = "1") @@ -173,5 +177,21 @@ @ApiModelProperty(value = "车çå¾", example = "1") @ExcelColumn(name="车çå¾") private String platePictureContent; @ApiModelProperty(value = "æå°èæ¯å¤§å¾æ¬å°ä¸è½½", example = "1") @ExcelColumn(name="æå°èæ¯å¤§å¾æ¬å°ä¸è½½") private String backgroundImageDown; @ApiModelProperty(value = "车ç徿¬å°ä¸è½½", example = "1") @ExcelColumn(name="车ç徿¬å°ä¸è½½") private String platePictureDown; @ApiModelProperty(value = "æå°å稱", example = "1") @TableField(exist = false) private String platformName; @ApiModelProperty(value = "å¼å§æ¶é´") @TableField(exist = false) private String startDate; @ApiModelProperty(value = "ç»ææ¶é´") @TableField(exist = false) private String endDate; } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
@@ -154,6 +154,7 @@ } }catch (Exception e){ //妿åçå¼å¸¸ï¼å é¤å·²ç»å建ç人åä¿¡æ¯ e.printStackTrace(); deleteHkUserBiz(new String[]{insert.getHkId()}); throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对ä¸èµ·ï¼åå·¥ä¿¡æ¯æ°å»ºå¤±è´¥ï¼è¯·ç¨åéè¯ï¼"); } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformEventServiceImpl.java
@@ -1,20 +1,27 @@ package com.doumee.service.business.impl; import com.doumee.biz.system.SystemDictDataBiz; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.core.utils.Utils; import com.doumee.dao.business.PlatformEventMapper; import com.doumee.dao.business.model.Empower; import com.doumee.dao.business.model.Platform; import com.doumee.dao.business.model.PlatformEvent; import com.doumee.service.business.PlatformEventService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; 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.util.CollectionUtils; import java.util.List; import java.util.Objects; /** * æå°è½¦è¾è¿åºäºä»¶æ¨éè®°å½è¡¨Serviceå®ç° @@ -24,6 +31,8 @@ @Service public class PlatformEventServiceImpl implements PlatformEventService { @Autowired private SystemDictDataBiz systemDictDataBiz; @Autowired private PlatformEventMapper platformEventMapper; @@ -87,129 +96,139 @@ @Override public PageData<PlatformEvent> findPage(PageWrap<PlatformEvent> pageWrap) { IPage<PlatformEvent> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); QueryWrapper<PlatformEvent> queryWrapper = new QueryWrapper<>(); MPJLambdaWrapper<PlatformEvent> queryWrapper = new MPJLambdaWrapper<>(); queryWrapper.selectAll(PlatformEvent.class) .selectAs(Platform::getName,PlatformEvent::getPlatformName) .leftJoin(Platform.class, Platform::getId,PlatformEvent::getPlatformId); Utils.MP.blankToNull(pageWrap.getModel()); if (pageWrap.getModel().getId() != null) { queryWrapper.lambda().eq(PlatformEvent::getId, pageWrap.getModel().getId()); queryWrapper.eq(PlatformEvent::getId, pageWrap.getModel().getId()); } if (pageWrap.getModel().getCreator() != null) { queryWrapper.lambda().eq(PlatformEvent::getCreator, pageWrap.getModel().getCreator()); queryWrapper.eq(PlatformEvent::getCreator, pageWrap.getModel().getCreator()); } if (pageWrap.getModel().getCreateDate() != null) { queryWrapper.lambda().ge(PlatformEvent::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); queryWrapper.lambda().le(PlatformEvent::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); queryWrapper.ge(PlatformEvent::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); queryWrapper.le(PlatformEvent::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); } if (pageWrap.getModel().getEditor() != null) { queryWrapper.lambda().eq(PlatformEvent::getEditor, pageWrap.getModel().getEditor()); queryWrapper.eq(PlatformEvent::getEditor, pageWrap.getModel().getEditor()); } if (pageWrap.getModel().getEditDate() != null) { queryWrapper.lambda().ge(PlatformEvent::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); queryWrapper.lambda().le(PlatformEvent::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); queryWrapper.ge(PlatformEvent::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); queryWrapper.le(PlatformEvent::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); } if (pageWrap.getModel().getIsdeleted() != null) { queryWrapper.lambda().eq(PlatformEvent::getIsdeleted, pageWrap.getModel().getIsdeleted()); queryWrapper.eq(PlatformEvent::getIsdeleted, pageWrap.getModel().getIsdeleted()); } if (pageWrap.getModel().getRemark() != null) { queryWrapper.lambda().eq(PlatformEvent::getRemark, pageWrap.getModel().getRemark()); queryWrapper.eq(PlatformEvent::getRemark, pageWrap.getModel().getRemark()); } if (pageWrap.getModel().getEventId() != null) { queryWrapper.lambda().eq(PlatformEvent::getEventId, pageWrap.getModel().getEventId()); queryWrapper.eq(PlatformEvent::getEventId, pageWrap.getModel().getEventId()); } if (pageWrap.getModel().getEventType() != null) { queryWrapper.lambda().eq(PlatformEvent::getEventType, pageWrap.getModel().getEventType()); queryWrapper.eq(PlatformEvent::getEventType, pageWrap.getModel().getEventType()); } if (pageWrap.getModel().getSrcType() != null) { queryWrapper.lambda().eq(PlatformEvent::getSrcType, pageWrap.getModel().getSrcType()); queryWrapper.eq(PlatformEvent::getSrcType, pageWrap.getModel().getSrcType()); } if (pageWrap.getModel().getHappenTime() != null) { queryWrapper.lambda().eq(PlatformEvent::getHappenTime, pageWrap.getModel().getHappenTime()); queryWrapper.eq(PlatformEvent::getHappenTime, pageWrap.getModel().getHappenTime()); } if (pageWrap.getModel().getSrcIndex() != null) { queryWrapper.lambda().eq(PlatformEvent::getSrcIndex, pageWrap.getModel().getSrcIndex()); queryWrapper.eq(PlatformEvent::getSrcIndex, pageWrap.getModel().getSrcIndex()); } if (pageWrap.getModel().getSrcName() != null) { queryWrapper.lambda().eq(PlatformEvent::getSrcName, pageWrap.getModel().getSrcName()); queryWrapper.eq(PlatformEvent::getSrcName, pageWrap.getModel().getSrcName()); } if (pageWrap.getModel().getStatus() != null) { queryWrapper.lambda().eq(PlatformEvent::getStatus, pageWrap.getModel().getStatus()); queryWrapper.eq(PlatformEvent::getStatus, pageWrap.getModel().getStatus()); } if (pageWrap.getModel().getTimeout() != null) { queryWrapper.lambda().eq(PlatformEvent::getTimeout, pageWrap.getModel().getTimeout()); queryWrapper.eq(PlatformEvent::getTimeout, pageWrap.getModel().getTimeout()); } if (pageWrap.getModel().getDataType() != null) { queryWrapper.lambda().eq(PlatformEvent::getDataType, pageWrap.getModel().getDataType()); queryWrapper.eq(PlatformEvent::getDataType, pageWrap.getModel().getDataType()); } if (pageWrap.getModel().getSendTime() != null) { queryWrapper.lambda().eq(PlatformEvent::getSendTime, pageWrap.getModel().getSendTime()); queryWrapper.eq(PlatformEvent::getSendTime, pageWrap.getModel().getSendTime()); } if (pageWrap.getModel().getDateTime() != null) { queryWrapper.lambda().eq(PlatformEvent::getDateTime, pageWrap.getModel().getDateTime()); queryWrapper.eq(PlatformEvent::getDateTime, pageWrap.getModel().getDateTime()); } if (pageWrap.getModel().getIpAddress() != null) { queryWrapper.lambda().eq(PlatformEvent::getIpAddress, pageWrap.getModel().getIpAddress()); queryWrapper.eq(PlatformEvent::getIpAddress, pageWrap.getModel().getIpAddress()); } if (pageWrap.getModel().getIpv6Address() != null) { queryWrapper.lambda().eq(PlatformEvent::getIpv6Address, pageWrap.getModel().getIpv6Address()); queryWrapper.eq(PlatformEvent::getIpv6Address, pageWrap.getModel().getIpv6Address()); } if (pageWrap.getModel().getPortNo() != null) { queryWrapper.lambda().eq(PlatformEvent::getPortNo, pageWrap.getModel().getPortNo()); queryWrapper.eq(PlatformEvent::getPortNo, pageWrap.getModel().getPortNo()); } if (pageWrap.getModel().getProtocol() != null) { queryWrapper.lambda().eq(PlatformEvent::getProtocol, pageWrap.getModel().getProtocol()); queryWrapper.eq(PlatformEvent::getProtocol, pageWrap.getModel().getProtocol()); } if (pageWrap.getModel().getMacAddress() != null) { queryWrapper.lambda().eq(PlatformEvent::getMacAddress, pageWrap.getModel().getMacAddress()); queryWrapper.eq(PlatformEvent::getMacAddress, pageWrap.getModel().getMacAddress()); } if (pageWrap.getModel().getChannelId() != null) { queryWrapper.lambda().eq(PlatformEvent::getChannelId, pageWrap.getModel().getChannelId()); queryWrapper.eq(PlatformEvent::getChannelId, pageWrap.getModel().getChannelId()); } if (pageWrap.getModel().getActivePostCount() != null) { queryWrapper.lambda().eq(PlatformEvent::getActivePostCount, pageWrap.getModel().getActivePostCount()); queryWrapper.eq(PlatformEvent::getActivePostCount, pageWrap.getModel().getActivePostCount()); } if (pageWrap.getModel().getEventState() != null) { queryWrapper.lambda().eq(PlatformEvent::getEventState, pageWrap.getModel().getEventState()); queryWrapper.eq(PlatformEvent::getEventState, pageWrap.getModel().getEventState()); } if (pageWrap.getModel().getEventDescription() != null) { queryWrapper.lambda().eq(PlatformEvent::getEventDescription, pageWrap.getModel().getEventDescription()); queryWrapper.eq(PlatformEvent::getEventDescription, pageWrap.getModel().getEventDescription()); } if (pageWrap.getModel().getChannelName() != null) { queryWrapper.lambda().eq(PlatformEvent::getChannelName, pageWrap.getModel().getChannelName()); queryWrapper.like(PlatformEvent::getChannelName, pageWrap.getModel().getChannelName()); } if (pageWrap.getModel().getDeviceId() != null) { queryWrapper.lambda().eq(PlatformEvent::getDeviceId, pageWrap.getModel().getDeviceId()); queryWrapper.eq(PlatformEvent::getDeviceId, pageWrap.getModel().getDeviceId()); } if (pageWrap.getModel().getHpno() != null) { queryWrapper.lambda().eq(PlatformEvent::getHpno, pageWrap.getModel().getHpno()); queryWrapper.eq(PlatformEvent::getHpno, pageWrap.getModel().getHpno()); } if (pageWrap.getModel().getMotionStatus() != null) { queryWrapper.lambda().eq(PlatformEvent::getMotionStatus, pageWrap.getModel().getMotionStatus()); queryWrapper.eq(PlatformEvent::getMotionStatus, pageWrap.getModel().getMotionStatus()); } if (pageWrap.getModel().getPlateNo() != null) { queryWrapper.lambda().eq(PlatformEvent::getPlateNo, pageWrap.getModel().getPlateNo()); queryWrapper.like(PlatformEvent::getPlateNo, pageWrap.getModel().getPlateNo()); } if (pageWrap.getModel().getVehicleDoorStatus() != null) { queryWrapper.lambda().eq(PlatformEvent::getVehicleDoorStatus, pageWrap.getModel().getVehicleDoorStatus()); queryWrapper.eq(PlatformEvent::getVehicleDoorStatus, pageWrap.getModel().getVehicleDoorStatus()); } if (pageWrap.getModel().getStockStatus() != null) { queryWrapper.lambda().eq(PlatformEvent::getStockStatus, pageWrap.getModel().getStockStatus()); queryWrapper.eq(PlatformEvent::getStockStatus, pageWrap.getModel().getStockStatus()); } if (pageWrap.getModel().getPlateScore() != null) { queryWrapper.lambda().eq(PlatformEvent::getPlateScore, pageWrap.getModel().getPlateScore()); queryWrapper.eq(PlatformEvent::getPlateScore, pageWrap.getModel().getPlateScore()); } if (pageWrap.getModel().getBackgroundImageContent() != null) { queryWrapper.lambda().eq(PlatformEvent::getBackgroundImageContent, pageWrap.getModel().getBackgroundImageContent()); queryWrapper.eq(PlatformEvent::getBackgroundImageContent, pageWrap.getModel().getBackgroundImageContent()); } if (pageWrap.getModel().getPlatePictureContent() != null) { queryWrapper.lambda().eq(PlatformEvent::getPlatePictureContent, pageWrap.getModel().getPlatePictureContent()); queryWrapper.eq(PlatformEvent::getPlatePictureContent, pageWrap.getModel().getPlatePictureContent()); } for(PageWrap.SortData sortData: pageWrap.getSorts()) { if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { queryWrapper.orderByDesc(sortData.getProperty()); } else { queryWrapper.orderByAsc(sortData.getProperty()); queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getPlatformName()), Platform::getName,pageWrap.getModel().getPlatformName()); queryWrapper.ge(Objects.nonNull(pageWrap.getModel().getStartDate()), PlatformEvent::getCreateDate,pageWrap.getModel().getStartDate()); queryWrapper.le(Objects.nonNull(pageWrap.getModel().getEndDate()),PlatformEvent::getCreateDate,pageWrap.getModel().getEndDate()); queryWrapper.orderByDesc(PlatformEvent::getCreateDate); PageData<PlatformEvent> result = PageData.from(platformEventMapper.selectJoinPage(page, PlatformEvent.class,queryWrapper)); if(result!=null && result.getRecords()!=null){ String prefixUrl = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() + systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode(); for(PlatformEvent model : result.getRecords()){ if(StringUtils.isNotBlank(model.getBackgroundImageContent())){ model.setBackgroundImageDown(prefixUrl + model.getBackgroundImageContent()); } } } return PageData.from(platformEventMapper.selectPage(page, queryWrapper)); return result; } @Override server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncImgServiceImpl.java
@@ -8,6 +8,7 @@ import com.doumee.core.utils.Constants; import com.doumee.core.utils.DateUtil; import com.doumee.core.utils.FtpUtil; import com.doumee.core.utils.HttpsUtil; import com.doumee.dao.business.*; import com.doumee.dao.business.model.*; import lombok.extern.slf4j.Slf4j; @@ -34,6 +35,8 @@ @Autowired private MemberMapper memberMapper; @Autowired private PlatformEventMapper platformEventMapper; @Autowired private DeviceEventMapper deviceEventMapper; @Autowired private VisitEventMapper visitEventMapper; @@ -54,6 +57,8 @@ startDealDeviceImg(); //æ¥è¯¢ææäººå人è¸ç §ç startDealMemberImg(); //æ¥è¯¢æææå°äºä»¶ä¸ææå¾ç §ç startDealPlatformEventImg(); }catch (Exception e){ e.printStackTrace(); }finally { @@ -87,6 +92,33 @@ } } memberMapper.updateById(event); } } } private void startDealPlatformEventImg() { List<PlatformEvent> list = platformEventMapper.selectList(new QueryWrapper<PlatformEvent>().lambda() .eq(PlatformEvent::getIsdeleted,Constants.ZERO) .isNotNull(PlatformEvent::getBackgroundImageContent) .notLikeRight(PlatformEvent::getBackgroundImageContent, HKConstants.IMG_INDEX_ERROR) .isNull(PlatformEvent::getBackgroundImageDown)); Date date= new Date(); if(list !=null && list.size()>0){ for(PlatformEvent model:list){ String rs1 = null; PlatformEvent event = new PlatformEvent(); event.setId(model.getId()); event.setEditDate(date); if(StringUtils.isNotBlank(model.getBackgroundImageContent())){ String img1 = model.getBackgroundImageContent(); rs1 = downHkImgToFtp(img1,"",Constants.PLATFORM_EVENT_IMG); if(StringUtils.isNotBlank(rs1)){ event.setBackgroundImageDown(rs1); }else{ event.setBackgroundImageContent(HKConstants.IMG_INDEX_ERROR+model.getBackgroundImageContent()); } } platformEventMapper.updateById(event); } } @@ -251,11 +283,13 @@ param.setPicUri(img1.replace(HKConstants.IMG_INDEX_ERROR,"").replace(HKConstants.IMG_INDEX,"")); param.setServerIndexCode(serverIndex); is = HKService.getFaceInputStream(param); }else if(StringUtils.equals(folder_code,Constants.PLATFORM_EVENT_IMG)){ //æå°äºä»¶å¾ç is = HttpsUtil.connectionInputsteam(img1,"GET",null,null); } if(is ==null){ return null; } try { if(ftp == null){ ftp = new FtpUtil(systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_HOST).getCode(), server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncLoginAuthServiceImpl.java
@@ -27,7 +27,6 @@ @Autowired private DeviceMapper deviceMapper; @Autowired private RedisTemplate<String, Object> redisTemplate; @Autowired @@ -76,7 +75,6 @@ }catch (Exception e){ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对ä¸èµ·ï¼ç»å½ç»ä»¶å¤±è´¥ï¼è¯·ç¨åéè¯ï¼"); } }else{ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"对ä¸èµ·ï¼ç»å½ç»ä»¶å¤±è´¥ï¼è¯·ç¨åéè¯ï¼"); } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncPlatformsServiceImpl.java
@@ -188,7 +188,7 @@ d.setCreateDate(model.getCreateDate()); d.setPlatformId(model.getId()); d.setIsdeleted(Constants.ZERO); d.setDeviceId(param.getCameraIdompan()); d.setDeviceId(param.getCameraId()); d.setName(param.getCameraName()); d.setType(Constants.ONE); list.add(d); server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncPushServiceImpl.java
@@ -867,8 +867,9 @@ } //å车é车è¾ç¶æ EventPlatformCarsStatusInfoRequest status = data.getHPVehicleStatus(); eventList.add(initPlatformEventModel(request,data,status));//å°è£ äºä»¶ï¼å·²æå°ééä¸ºç»´åº¦ï¼ PlatformEvent event = initPlatformEventModel(request,data,status); if(StringUtils.isBlank(status.getPlateNo())){ eventList.add(event);//å°è£ äºä»¶ï¼å·²æå°ééä¸ºç»´åº¦ï¼ continue;//å¦æè½¦è¾ä¿¡æ¯ä¸ºç©ºï¼ä¸å¤çç´æ¥è·³è¿ } PlatformDevice model = platformDeviceMapper.selectOne(new QueryWrapper<PlatformDevice>().lambda() @@ -876,10 +877,13 @@ .eq(PlatformDevice::getIsdeleted,Constants.ZERO) .last("limit 1")); if(model ==null){ eventList.add(event);//å°è£ äºä»¶ï¼å·²æå°ééä¸ºç»´åº¦ï¼ continue;//çæ§ç¹æªåæ¥ï¼è·³è¿å¤ç } //æªæç¬¬ä¸ä¸ªé¢è²æ±å status.setPlateNo(status.getPlateNo().substring(1,status.getPlateNo().length())); event.setPlatformId(model.getPlatformId());//æå°ç¼ç eventList.add(event);//å°è£ äºä»¶ï¼å·²æå°ééä¸ºç»´åº¦ï¼ //æªæç¬¬ä¸ä¸ªé¢è²æ±å,廿âæâå status.setPlateNo(status.getPlateNo().substring(1,status.getPlateNo().length()).replace("æ","")); PlatformJob job = platformJobMapper.selectJoinOne(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAll(PlatformJob.class) .selectAs(Platform::getName,PlatformJob::getPlatformName) @@ -888,12 +892,15 @@ .eq(!StringUtils.equals(status.getStockStatus(),"front"),PlatformJob::getCarCodeBack,status.getPlateNo() )//å车çå· .eq(PlatformJob::getIsdeleted,Constants.ZERO ) .last("limit 1 ")); if(job == null){ continue;//妿ä½ä¸ä¸ºç©ºï¼è·³è¿å¤ç } PlatformJob update = new PlatformJob(); update.setId(job.getId()); update.setEditDate(new Date()); if(StringUtils.equals(status.getMotionStatus(),"leave")){ //妿æ¯è½¦è¾ç¦»å¼,ä¸åç¸å ³èªå¨å®æä½ä¸ä¸å¡å¤ç /* if(job ==null && !Constants.equalsInteger(job.getStatus(),Constants.PlatformJobStatus.WORKING.getKey())){ /* if(job ==null && !Constants.equalsInteger(job.getStatus(),Constants.PlatformJobStatus.WORKING.getKey())){ continue;//å¦ææ²¡æ¥å°å¯¹åºçä½ä¸æè ä½ä¸å¹¶éä½ä¸ä¸ï¼ä¸åä¸å¡å¤ç } if(Constants.equalsInteger(job.getType(), Constants.THREE) || Constants.equalsInteger(job.getType(), Constants.TWO)){