From add6878fd62d392c41fe5fa18086a03859103a39 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期二, 11 十月 2022 09:13:16 +0800
Subject: [PATCH] 新增 首页统计导办工单总数 导办工单时间统计 导办工单时段筛选接口 新增角色菜单关系表 新增角色菜单关系相关接口
---
flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java | 63 ++++++++++++++++++++++++++-----
1 files changed, 53 insertions(+), 10 deletions(-)
diff --git a/flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java b/flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java
index 6c991ea..110dc0c 100644
--- a/flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java
+++ b/flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java
@@ -4,10 +4,8 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.dg.core.db.gen.entity.KeywordEntity;
-import com.dg.core.db.gen.entity.OrganizationChartEntity;
-import com.dg.core.db.gen.entity.SysUser;
-import com.dg.core.db.gen.entity.TransactionEvent;
+import com.dg.core.db.gen.entity.*;
+import com.dg.core.db.gen.mapper.AutomessageTransactionEventInterviewMapper;
import com.dg.core.db.gen.mapper.KeywordMapper;
import com.dg.core.db.gen.mapper.OrganizationChartMapper;
import com.dg.core.db.gen.mapper.TransactionEventMapper;
@@ -19,6 +17,9 @@
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+import java.time.format.DateTimeFormatter;
import java.util.ArrayList;
import java.util.List;
@@ -31,15 +32,41 @@
@Resource
private KeywordMapper keywordMapper;
+ @Resource
+ private AutomessageTransactionEventInterviewMapper automessageTransactionEventInterviewMapper;
+
@Override
- public TransactionEvent selectConfigData(String Id) {
- return baseMapper.selectConfigData(Id);
+ public TransactionEvent selectConfigData(String Id,SysUser sysUser) {
+ TransactionEvent transactionEvent = baseMapper.selectConfigData(Id);
+ //如果当前没有登录用户则不增加浏览次数
+ if (sysUser!=null){
+ LocalDateTime startTime = LocalDate.now().atTime(0, 0, 0);
+ LocalDateTime endTime = LocalDate.now().atTime(23, 59, 59);
+ AutomessageTransactionEventInterview automessageTransactionEventInterview = automessageTransactionEventInterviewMapper.selectOne(new QueryWrapper<AutomessageTransactionEventInterview>()
+ .lambda().eq(AutomessageTransactionEventInterview::getTransactionEventId, Id)
+ .eq(AutomessageTransactionEventInterview::getUserId, sysUser.getUserId())
+ .orderByDesc(AutomessageTransactionEventInterview::getInterviewTime)
+ .last("limit 1"));
+ transactionEvent.setQueryTime(LocalDateTime.now());
+ //判断上次访问时间是不是今天 如果是今天不增加浏览次数
+ if (automessageTransactionEventInterview==null||(!(transactionEvent.getQueryTime().isAfter(startTime)&&transactionEvent.getQueryTime().isBefore(endTime)))) {
+ transactionEvent.setBrowseNum(transactionEvent.getBrowseNum()+1);
+ baseMapper.updateById(transactionEvent);
+ AutomessageTransactionEventInterview automessageTransactionEventInterviewNew =
+ new AutomessageTransactionEventInterview();
+ automessageTransactionEventInterviewNew.setTransactionEventId(Integer.valueOf(Id));
+ automessageTransactionEventInterviewNew.setUserId(new Long(sysUser.getUserId()));
+ automessageTransactionEventInterviewNew.setInterviewTime(LocalDateTime.now());
+ automessageTransactionEventInterviewMapper.insert(automessageTransactionEventInterviewNew);
+ }
+ }
+ return transactionEvent;
}
@Override
public List<TransactionEvent> selectConfigList(IPage<TransactionEvent> page, Integer state,
- String matterAndUser, String classifyGrade) {
- return baseMapper.selectConfigList(page, state, matterAndUser, classifyGrade);
+ String matterAndUser, String classifyGrade,List<String> ids) {
+ return baseMapper.selectConfigList(page, state, matterAndUser, classifyGrade,ids);
}
@Override
@@ -58,8 +85,8 @@
}
@Override
- public int countNum(String matterAndUser,String classifyGrade) {
- return baseMapper.countNum( matterAndUser, classifyGrade);
+ public int countNum(String matterAndUser,String classifyGrade,List<String> ids) {
+ return baseMapper.countNum( matterAndUser, classifyGrade, ids);
}
@Override
@@ -71,6 +98,17 @@
queryResults.setTransactionEventList(searchesAssociate);
queryResults.setKeywordEntityList( keywordMapper.selectByName(keyWord));
queryResults.setTotal((baseMapper.selectSearch(keyWord).size())+(baseMapper.selectSearchAssociate(keyWord).size()));
+ return queryResults;
+ }
+
+ @Override
+ public QueryResults queryMatterNameList(String keyWord) {
+ QueryResults queryResults = new QueryResults();
+ List<Search> searches = baseMapper.selectSearchList(keyWord);
+ queryResults.setSearchList(searches);
+ List<Search> searchesAssociate = baseMapper.selectSearchAssociate(keyWord);
+ queryResults.setTransactionEventList(searchesAssociate);
+ queryResults.setKeywordEntityList( keywordMapper.selectByName(keyWord));
return queryResults;
}
@@ -107,6 +145,11 @@
}
@Override
+ public List<TransactionEvent> queryByClassifyIdList(IPage<TransactionEvent> page, Integer state,String classifyId,Integer departmentId) {
+ return baseMapper.queryByClassifyIdList(page,state,classifyId,departmentId);
+ }
+
+ @Override
public List<TransactionEvent> queryByQueryTime() {
List<TransactionEvent> transactionEvents = baseMapper.selectList(new QueryWrapper<TransactionEvent>().lambda().orderByDesc(TransactionEvent::getQueryTime));
return transactionEvents;
--
Gitblit v1.7.1