From c4aa721a61edb5ff4502d621897c266b98ef3d1c Mon Sep 17 00:00:00 2001
From: baizonghao <1719256278@qq.com>
Date: 星期五, 24 二月 2023 11:18:58 +0800
Subject: [PATCH] 按报警点位统计，按区域统计
---
ycl-platform/src/main/java/com/ycl/service/store/impl/StoreInfoServiceImpl.java | 29 +++++++++++++++++++++++++----
1 files changed, 25 insertions(+), 4 deletions(-)
diff --git a/ycl-platform/src/main/java/com/ycl/service/store/impl/StoreInfoServiceImpl.java b/ycl-platform/src/main/java/com/ycl/service/store/impl/StoreInfoServiceImpl.java
index 24e84a3..79b05f0 100644
--- a/ycl-platform/src/main/java/com/ycl/service/store/impl/StoreInfoServiceImpl.java
+++ b/ycl-platform/src/main/java/com/ycl/service/store/impl/StoreInfoServiceImpl.java
@@ -6,9 +6,12 @@
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.entity.store.StoreInfo;
+import com.ycl.entity.store.StoreScore;
import com.ycl.enums.common.ResultCode;
import com.ycl.exception.ApiException;
import com.ycl.mapper.store.StoreInfoMapper;
+import com.ycl.mapper.store.StoreScoreMapper;
+import com.ycl.mapper.video.VideoPointMapper;
import com.ycl.service.store.StoreInfoService;
import com.ycl.utils.ExcelUtils;
import com.ycl.vo.store.StoreInfoExcelVo;
@@ -38,13 +41,21 @@
@Resource
StoreInfoMapper storeInfoMapper;
+ @Resource
+ VideoPointMapper videoPointMapper;
+
+ @Resource
+ StoreScoreMapper storeScoreMapper;
+
@Override
- public Page<StoreInfoVO> list(String keyword, Integer pageSize, Integer pageNum) {
+ public Page<StoreInfoVO> list(String keyword, Integer pageSize, Integer pageNum,String status) {
Page<StoreInfo> storeInfoPage = new Page<>();
storeInfoPage.setSize(pageSize);
storeInfoPage.setCurrent(pageNum);
- return storeInfoMapper.selectStorePage(storeInfoPage,keyword);
+ Page<StoreInfoVO> page = storeInfoMapper.selectStorePage(storeInfoPage, keyword,status);
+ page.getRecords().forEach(x -> x.setVideoPoint(videoPointMapper.selectById(x.getVideoId())));
+ return page;
}
@Override
@@ -63,14 +74,24 @@
List<StoreInfo> infos = new ArrayList<>();
for (StoreInfoExcelVo data : datas) {
StoreInfo info = new StoreInfo();
- BeanUtils.copyProperties(data,info);
+ BeanUtils.copyProperties(data, info);
infos.add(info);
}
- BeanUtils.copyProperties(datas,infos);
+ BeanUtils.copyProperties(datas, infos);
saveBatch(infos);
return true;
} catch (Exception e) {
throw new ApiException(ResultCode.FAILED);
}
}
+
+ @Override
+ public Page<StoreScore> getScoreList(Long storeId, Integer pageSize, Integer pageNum) {
+ Page<StoreScore> storeScorePage = new Page<>();
+ storeScorePage.setSize(pageSize);
+ storeScorePage.setCurrent(pageNum);
+ LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<StoreScore>().eq(StoreScore::getStoreId, storeId);
+ Page<StoreScore> page = storeScoreMapper.selectPage(storeScorePage, queryWrapper);
+ return page;
+ }
}
--
Gitblit v1.8.0