From 2162e93732df17ce5b59e0fb4146c6f3248107a9 Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期三, 05 三月 2025 18:02:48 +0800
Subject: [PATCH] 最新版本541200007
---
server/meeting/meeting_service/src/main/java/com/doumee/service/business/impl/BookingsServiceImpl.java | 6 +
server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java | 3
admin/src/api/platform/platform.js | 6 +
admin/src/views/platform/LogisticsRecord/subscribe.vue | 68 +++++++++++++---------
server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java | 8 +-
server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingDetailResponse.java | 2
server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/vo/VisitEventCountVO.java | 24 ++++++++
server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformBooksServiceImpl.java | 14 ++--
server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/VisitEventCloudController.java | 7 ++
server/visits/dmvisit_service/src/main/java/com/doumee/service/business/VisitEventService.java | 3 +
server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitEventServiceImpl.java | 31 ++++++++++
server/meeting/meeting_service/src/main/java/com/doumee/dao/business/model/Bookings.java | 1
12 files changed, 130 insertions(+), 43 deletions(-)
diff --git a/admin/src/api/platform/platform.js b/admin/src/api/platform/platform.js
index c258903..6ffe47a 100644
--- a/admin/src/api/platform/platform.js
+++ b/admin/src/api/platform/platform.js
@@ -42,6 +42,10 @@
export function deleteById (id) {
return request.get(`/visitsAdmin/cloudService/business/platform/delete/${id}`)
}
+// 鍒犻櫎
+export function deletebooksById (id) {
+ return request.get(`/visitsAdmin/cloudService/business/platformBooks/delete/${id}`)
+}
// 鎵归噺鍒犻櫎
export function deleteByIdInBatch (ids) {
@@ -54,4 +58,4 @@
// 鏌ヨ鍙绾﹂噺
export function checkSurplusNum (data) {
return request.post('/visitsAdmin/cloudService/business/platformBooks/checkSurplusNum', data)
-}
\ No newline at end of file
+}
diff --git a/admin/src/views/platform/LogisticsRecord/subscribe.vue b/admin/src/views/platform/LogisticsRecord/subscribe.vue
index e4de31b..4c49daa 100644
--- a/admin/src/views/platform/LogisticsRecord/subscribe.vue
+++ b/admin/src/views/platform/LogisticsRecord/subscribe.vue
@@ -106,8 +106,8 @@
import Pagination from '@/components/common/Pagination'
import QueryForm from '@/components/common/QueryForm'
import { platformBooksPage, platformReasonList, platformBooksApply, platformBooksExport } from '@/api'
-import { checkSurplusNum } from '@/api/platform/platform'
-import DriverDetail from "@/views/task/driverDetail"
+import { checkSurplusNum, deletebooksById } from '@/api/platform/platform'
+import DriverDetail from '@/views/task/driverDetail'
import GlobalWindow from '@/components/common/GlobalWindow'
import UploadAvatarImage from '@/components/common/UploadAvatarImage'
import { Message } from 'element-ui'
@@ -120,7 +120,7 @@
GlobalWindow,
UploadAvatarImage
},
- data() {
+ data () {
return {
isShowDriver: false,
exLoading: false,
@@ -153,7 +153,7 @@
reasonId: [{ required: true, message: '璇烽�夋嫨', trigger: 'blur' }],
arriveDate: [{ required: true, message: '璇烽�夋嫨', trigger: 'blur' }],
inType: [{ required: true, message: '璇烽�夋嫨', trigger: 'blur' }],
- driverName: [{ required: true, message: '璇烽�夋嫨', trigger: 'blur' }],
+ driverName: [{ required: true, message: '璇烽�夋嫨', trigger: 'blur' }]
},
queryFormConfig: {
formItems: [
@@ -181,7 +181,7 @@
{ value: 1, label: '瀹℃壒涓�' },
{ value: 2, label: '瀹℃壒閫氳繃' },
{ value: 3, label: '瀹℃壒椹冲洖' },
- { value: 4, label: '宸插彇娑�' },
+ { value: 4, label: '宸插彇娑�' }
]
},
{
@@ -200,12 +200,12 @@
}
}
},
- created() {
+ created () {
this.changeRadio('0')
this.getList()
},
methods: {
- checkSurplus() {
+ checkSurplus () {
const { arriveDate, reasonId, totalNum } = this.param
if (!arriveDate || !reasonId || !totalNum) return
checkSurplusNum({
@@ -220,28 +220,28 @@
}
})
},
- changeRadio(day) {
+ changeRadio (day) {
const arr = [dayjs().subtract(day, 'day').format('YYYY-MM-DD') + ' 00:00:00', dayjs().format('YYYY-MM-DD') + ' 23:59:59']
this.$set(this.filters, 'selDate', arr)
this.getList()
},
- changeForm(str) {
+ changeForm (str) {
if (str === 'selDate') {
this.$set(this.filters, 'fastdate', null)
this.getList()
}
},
- getList(page) {
+ getList (page) {
const { pagination, filters } = this
this.loading = true
platformBooksPage({
model: {
...filters,
arriveDateStart: filters.selDate && filters.selDate.length > 0 ? filters.selDate[0] : null,
- arriveDateEnd: filters.selDate && filters.selDate.length > 0 ? filters.selDate[1] : null,
+ arriveDateEnd: filters.selDate && filters.selDate.length > 0 ? filters.selDate[1] : null
},
capacity: pagination.pageSize,
- page: page || pagination.page,
+ page: page || pagination.page
}).then(res => {
this.loading = false
this.list = res.records || []
@@ -253,7 +253,7 @@
this.loading = false
})
},
- handleEx() {
+ handleEx () {
this.$dialog.exportConfirm('纭瀵煎嚭鍚楋紵')
.then(() => {
const { filters } = this
@@ -264,8 +264,8 @@
model: {
...filters,
arriveDateStart: filters.selDate && filters.selDate.length > 0 ? filters.selDate[0] : null,
- arriveDateEnd: filters.selDate && filters.selDate.length > 0 ? filters.selDate[1] : null,
- },
+ arriveDateEnd: filters.selDate && filters.selDate.length > 0 ? filters.selDate[1] : null
+ }
})
.then(response => {
this.download(response)
@@ -278,8 +278,8 @@
})
})
},
- onSubmit() {
- this.$refs['ruleForm'].validate((valid) => {
+ onSubmit () {
+ this.$refs.ruleForm.validate((valid) => {
const param = this.param
param.inReason = this.reasonList.find(item => param.reasonId == item.id).reason
if (valid) {
@@ -294,42 +294,42 @@
}
})
},
- uploadSuccess(file) {
+ uploadSuccess (file) {
this.$set(this.param, 'transportImg', file.imgurl)
this.$set(this.param, 'transportImgFull', file.imgurlfull)
},
- handleEdit(row) {
+ handleEdit (row) {
this.isShowEdit = true
this.param = {
inType: 0
}
this.$nextTick(() => {
- this.$refs['ruleForm'].clearValidate()
+ this.$refs.ruleForm.clearValidate()
})
this.$set(this.param, 'arriveDate', dayjs().format('YYYY-MM-DD HH:mm:ss'))
this.getplatformReason()
},
- getplatformReason() {
+ getplatformReason () {
platformReasonList().then(res => {
this.reasonList = res || []
})
},
- handleSub() {
+ handleSub () {
this.$refs.ruleForm.validate((valid) => {
if (valid) {
alert('submit!')
}
})
},
- clear() {
+ clear () {
this.pagination.page = 1
this.filters = {
- selDate: [],
+ selDate: []
}
this.getList()
// this.changeRadio('0')
},
- handleDetail(row) {
+ handleDetail (row) {
this.isShowDriver = true
this.$nextTick(() => {
this.$refs.DriverDetailRef.id = row.id
@@ -338,8 +338,22 @@
this.$refs.DriverDetailRef.isShowModal = true
})
},
- handleDel() { },
- handleSizeChange(capacity) {
+ handleDel (row) {
+ this.$confirm('纭畾鍒犻櫎璇ヨ褰曞悧, 鏄惁缁х画?', '鎻愮ず', {
+ confirmButtonText: '纭畾',
+ cancelButtonText: '鍙栨秷',
+ type: 'warning'
+ }).then(() => {
+ deletebooksById(row.id)
+ .then(res => {
+ this.$message.success('鎿嶄綔鎴愬姛')
+ this.page = 1
+ this.getList()
+ })
+ }).catch(() => {
+ })
+ },
+ handleSizeChange (capacity) {
this.pagination.pageSize = capacity
this.getList()
}
diff --git a/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java b/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java
index 39eff3a..960bc0a 100644
--- a/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java
+++ b/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/BookingsMapper.java
@@ -49,7 +49,7 @@
" ${ew.customSqlSegment} ")
List<MeetingListResponse> meetingList(@Param(Constants.WRAPPER) Wrapper wrapper);
- @Select(" select a.id , a.START_TIME , a.END_TIME , b.id as roomId, b.`NAME` as roomName , a.`NAME` as meetingName ,date_format(a.START_TIME,'%Y骞�%m鏈�%d鏃�') as meetingDate ," +
+ @Select(" select a.id ,a.ISDELETED, a.START_TIME , a.END_TIME , b.id as roomId, b.`NAME` as roomName , a.`NAME` as meetingName ,date_format(a.START_TIME,'%Y骞�%m鏈�%d鏃�') as meetingDate ," +
" CONCAT(date_format(a.START_TIME,'%H:%i') , ' ~ ',date_format(a.END_TIME,'%H:%i')) as meetingTime, c.REALNAME as bookingUserName ," +
//" CASE WHEN a.START_TIME > now() AND a.`STATUS` = 0 THEN 1 WHEN a.END_TIME < now() AND a.`STATUS` = 0 THEN 3 WHEN a.`STATUS` = 1 THEN 5 ELSE 2 END meetingStatus ," +
" CASE WHEN a.START_TIME_REAL IS NULL AND a.`STATUS` = 0 THEN 1 WHEN ( a.status = 2 ) THEN 3 WHEN a.`STATUS` = 1 THEN 5 ELSE 2 END meetingStatus ," +
@@ -58,7 +58,7 @@
" left join system_user c on a.CREATOR = c.id " +
" left join system_department_user d on c.id = d.USER_ID " +
" left JOIN system_department e on d.DEPARTMENT_ID = e.ID " +
- " where a.id = #{id} ")
+ " where a.id = #{id} and a.isdeleted=0")
MeetingDetailResponse meetingDetail(@Param("id") Integer id);
@@ -102,7 +102,7 @@
"SUM( CONVERT( (UNIX_TIMESTAMP(b.END_TIME) - UNIX_TIMESTAMP(b.START_TIME))/(60*60),DECIMAL(5,1))) c\n" +
"FROM meeting_book b\n" +
"LEFT JOIN meeting_rooms r ON r.ID = b.ROOM_ID \n" +
- "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2) \n" +
+ "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2) and b.isdeleted=0\n" +
"GROUP BY b.ROOM_ID , DATE_FORMAT(b.START_TIME,'%m')\n" +
") t) t1 GROUP BY t1.name")
List<RoomStatisticsVo> getRoomStatistics(@Param("yearNum") Integer yearNum);
@@ -149,7 +149,7 @@
"meeting_user_rel ur\n" +
"LEFT JOIN `SYSTEM_USER` su ON ur.USER_ID = su.id \n" +
"LEFT JOIN meeting_book b ON ur.OBJ_ID = b.id \n" +
- "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2)" +
+ "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2) and b.isdeleted=0" +
"<if test='userId != null'>"+
"and ur.USER_ID = #{userId}\n" +
"</if>"+
diff --git a/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/model/Bookings.java b/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/model/Bookings.java
index 55b465e..5e97dc8 100644
--- a/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/model/Bookings.java
+++ b/server/meeting/meeting_service/src/main/java/com/doumee/dao/business/model/Bookings.java
@@ -107,7 +107,6 @@
@ApiModelProperty(value = "鎻愬墠寮�濮嬫椂闂�")
private Date startTimeReal;
-
@ApiModelProperty(value = "鏄惁鍙戦�佸弬浼氫汉閫氱煡锛�0=閫氱煡锛�1=涓嶉�氱煡")
private Integer joinNotice;
diff --git a/server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingDetailResponse.java b/server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingDetailResponse.java
index 847ab2e..9bfbc1c 100644
--- a/server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingDetailResponse.java
+++ b/server/meeting/meeting_service/src/main/java/com/doumee/dao/web/response/MeetingDetailResponse.java
@@ -23,6 +23,8 @@
@ApiModelProperty(value = "涓婚敭")
private Integer id;
+ @ApiModelProperty(value = "鏄惁宸插垹闄�")
+ private Integer isdeleted;
@ApiModelProperty(value = "浼氳鍚嶇О")
private String meetingName;
diff --git a/server/meeting/meeting_service/src/main/java/com/doumee/service/business/impl/BookingsServiceImpl.java b/server/meeting/meeting_service/src/main/java/com/doumee/service/business/impl/BookingsServiceImpl.java
index d00ed42..fa0abc5 100644
--- a/server/meeting/meeting_service/src/main/java/com/doumee/service/business/impl/BookingsServiceImpl.java
+++ b/server/meeting/meeting_service/src/main/java/com/doumee/service/business/impl/BookingsServiceImpl.java
@@ -1091,7 +1091,8 @@
@Override
public MeetingDetailResponse getMeetingDetail(Integer id,Integer sysUserId) {
MeetingDetailResponse meetingDetailResponse = bookingsMapper.meetingDetail(id);
- if (Objects.isNull(meetingDetailResponse)) {
+ if (Objects.isNull(meetingDetailResponse)
+ || Constants.equalsInteger(meetingDetailResponse.getIsdeleted(),Constants.ONE) ) {
throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "鏈煡璇㈠埌浼氳璇︽儏");
}
//棰勭害浜�
@@ -1184,6 +1185,7 @@
public Integer reservationMeeting(BookingsRequest bookingsRequest) {
Bookings bookings = new Bookings();
BeanUtils.copyProperties(bookingsRequest, bookings);
+ bookings.setJoinNotice(bookingsRequest.getJoinNotice());
if (Objects.isNull(bookingsRequest.getId())) {
this.create(bookings);
return bookings.getId();
@@ -1579,7 +1581,7 @@
.replace("{浼氳涓婚}",StringUtils.defaultString(bookings.getName(),""))
.replace("{浼氳瀹ゅ悕绉皚",StringUtils.defaultString(bookings.getRoomName(),""))
.replace("{浼氳鏃堕棿娈祡",StringUtils.defaultString(timeInfo,""))
- .replace("{浼氳澶囨敞}",StringUtils.defaultString(smsEmail.getRemark(),"")));
+ .replace("{浼氳澶囨敞}",StringUtils.defaultString(bookings.getRemark(),"")));
smsEmailList.add(smsEmail);
}
}
diff --git a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/VisitEventCloudController.java b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/VisitEventCloudController.java
index c0c3c78..a99fde4 100644
--- a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/VisitEventCloudController.java
+++ b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/VisitEventCloudController.java
@@ -4,6 +4,7 @@
import com.doumee.config.annotation.CloudRequiredPermission;
import com.doumee.core.annotation.excel.ExcelExporter;
import com.doumee.core.annotation.pr.PreventRepeat;
+import com.doumee.dao.business.vo.VisitEventCountVO;
import com.doumee.service.business.third.model.ApiResponse;
import com.doumee.service.business.third.model.PageData;
import com.doumee.service.business.third.model.PageWrap;
@@ -87,4 +88,10 @@
public ApiResponse findById(@PathVariable Integer id,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){
return ApiResponse.success(visitEventService.findById(id));
}
+ @ApiOperation("鏌ヨ鎸囧畾涔嬮棿鑼冨洿鍐呯殑缁熻鏁版嵁锛堜汉娆″拰浜烘暟锛�")
+ @PostMapping("/countNum")
+ @CloudRequiredPermission("business:visitevent:query")
+ public ApiResponse<VisitEventCountVO> countNum(@RequestBody VisitEvent model, @RequestHeader(Constants.HEADER_USER_TOKEN) String token){
+ return ApiResponse.success(visitEventService.countNum(model));
+ }
}
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/vo/VisitEventCountVO.java b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/vo/VisitEventCountVO.java
new file mode 100644
index 0000000..a67198b
--- /dev/null
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/vo/VisitEventCountVO.java
@@ -0,0 +1,24 @@
+package com.doumee.dao.business.vo;
+
+import com.doumee.dao.business.model.Approve;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.util.List;
+
+/**
+ * Created by IntelliJ IDEA.
+ *
+ * @create 2024/5/23 14:56
+ */
+@Data
+public class VisitEventCountVO {
+
+ @ApiModelProperty(value = "浜烘")
+ private Long eventNum;
+
+ @ApiModelProperty(value = "浜烘暟")
+ private Long visitorNum;
+
+
+}
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/VisitEventService.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/VisitEventService.java
index d8a89c5..e3be652 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/VisitEventService.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/VisitEventService.java
@@ -1,5 +1,6 @@
package com.doumee.service.business;
+import com.doumee.dao.business.vo.VisitEventCountVO;
import com.doumee.service.business.third.model.PageData;
import com.doumee.service.business.third.model.PageWrap;
import com.doumee.dao.business.model.VisitEvent;
@@ -112,4 +113,6 @@
* @return PageData<VisitEventVo>
*/
List<VisitEvent> findPageExcel(PageWrap<VisitEvent> pageWrap);
+
+ VisitEventCountVO countNum(VisitEvent model);
}
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java
index 4e77c13..8cc0ade 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java
@@ -330,7 +330,8 @@
queryWrapper.select("t4.company_name_path",CarUseBook::getCompanyName);
queryWrapper.leftJoin(Member.class,Member::getId,CarUseBook::getMemberId)
.leftJoin(Member.class,Member::getId,CarUseBook::getDriverId)
- .leftJoin("company t4 on t1.company_id=t4.id"); //鏁版嵁鏉冮檺寮�濮�--------------------start----------------
+ .leftJoin("company t4 on t1.company_id=t4.id");
+ //鏁版嵁鏉冮檺寮�濮�--------------------start----------------
LoginUserInfo userInfo =pageWrap.getModel().getLoginUserInfo();
if(userInfo!=null && userInfo.getCompanyIdList()!=null){
if( userInfo.getCompanyIdList().size() ==0){
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformBooksServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformBooksServiceImpl.java
index 3d63e57..de8ae4e 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformBooksServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformBooksServiceImpl.java
@@ -132,12 +132,14 @@
.set(PlatformBooks::getEditDate,date)
.set(PlatformBooks::getEditor,user.getId())
.eq(PlatformBooks::getId,id));
- platformJobMapper.update(null,new UpdateWrapper<PlatformJob>().lambda()
- .set(PlatformJob::getIsdeleted,Constants.ONE)
- .set(PlatformJob::getEditDate,new Date())
- .set(PlatformJob::getEditor,user.getId())
- .eq(PlatformJob::getBookId,id)
- .eq(PlatformJob::getIsdeleted,Constants.ZERO));
+ if(model.getJobId()!=null){
+ platformJobMapper.update(null,new UpdateWrapper<PlatformJob>().lambda()
+ .set(PlatformJob::getIsdeleted,Constants.ONE)
+ .set(PlatformJob::getEditDate,new Date())
+ .set(PlatformJob::getEditor,user.getId())
+ .eq(PlatformJob::getPlatformId,model.getJobId())
+ .eq(PlatformJob::getIsdeleted,Constants.ZERO));
+ }
String[] params = new String[3];
params[0] = user.getRealname();
params[1]=DateUtil.getPlusTime2(date);
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitEventServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitEventServiceImpl.java
index d8f00e9..2a3e6c2 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitEventServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitEventServiceImpl.java
@@ -4,6 +4,7 @@
import cn.hutool.core.lang.Validator;
import cn.hutool.core.util.ReUtil;
import com.doumee.core.haikang.model.HKConstants;
+import com.doumee.dao.business.vo.VisitEventCountVO;
import com.doumee.service.business.third.model.PageData;
import com.doumee.service.business.third.model.PageWrap;
import com.doumee.core.utils.Constants;
@@ -242,7 +243,35 @@
}
return PageData.from(visitEventDTOIPage);
}
-
+ @Override
+ public VisitEventCountVO countNum(VisitEvent model){
+ VisitEventCountVO data = new VisitEventCountVO();
+ data.setEventNum(0l);
+ data.setVisitorNum(0l);
+ Long count = visitEventJoinMapper.selectCount(new QueryWrapper<VisitEvent>().lambda()
+ .ge(StringUtils.isNotBlank(model.getStartTime()), VisitEvent::getCreateDate, model.getStartTime())
+ .le(StringUtils.isNotBlank(model.getEndTime()), VisitEvent::getCreateDate,model.getEndTime())
+ .eq(VisitEvent::getInOrOut,Constants.ZERO)
+ .isNotNull(VisitEvent::getVisitorId)
+ .eq(VisitEvent::getEventType,HKConstants.EventTypes.VISIT_SIGN_ICCM_PASS)
+ );
+ if(count!=null){
+ data.setEventNum(count);
+ }
+ Long count1 = visitEventJoinMapper.selectCount(new QueryWrapper<VisitEvent>().lambda()
+ .ge(StringUtils.isNotBlank(model.getStartTime()),VisitEvent::getCreateDate, model.getStartTime())
+ .le(StringUtils.isNotBlank(model.getEndTime()), VisitEvent::getCreateDate,model.getEndTime())
+ .eq( VisitEvent::getInOrOut,Constants.ZERO)
+ .eq( VisitEvent::getInOrOut,Constants.ZERO)
+ .isNotNull(VisitEvent::getVisitorId)
+ .eq( VisitEvent::getEventType,HKConstants.EventTypes.VISIT_SIGN_ICCM_PASS)
+ .groupBy(VisitEvent::getVisitorId)
+ );
+ if(count1!=null){
+ data.setVisitorNum(count);
+ }
+ return data;
+ }
@Override
public List<VisitEvent> findPageExcel(PageWrap<VisitEvent> pageWrap) {
IPage<VisitEvent> visitEventExcel = getDataInfo(pageWrap);
--
Gitblit v1.9.3