From 8ca04787ff71da03895dd75c1f1162efe939c84a Mon Sep 17 00:00:00 2001 From: 龚焕茏 <2842157468@qq.com> Date: 星期五, 08 三月 2024 10:02:43 +0800 Subject: [PATCH] 数据上图 --- dujy-modules/dujy-demo/src/main/java/org/dromara/demo/service/impl/RsDangerTotalServiceImpl.java | 32 +++++++++++++++++++++++--------- 1 files changed, 23 insertions(+), 9 deletions(-) diff --git a/dujy-modules/dujy-demo/src/main/java/org/dromara/demo/service/impl/RsDangerTotalServiceImpl.java b/dujy-modules/dujy-demo/src/main/java/org/dromara/demo/service/impl/RsDangerTotalServiceImpl.java index 6c7d0b7..258eaf2 100644 --- a/dujy-modules/dujy-demo/src/main/java/org/dromara/demo/service/impl/RsDangerTotalServiceImpl.java +++ b/dujy-modules/dujy-demo/src/main/java/org/dromara/demo/service/impl/RsDangerTotalServiceImpl.java @@ -1,24 +1,28 @@ package org.dromara.demo.service.impl; -import org.dromara.common.core.utils.MapstructUtils; -import org.dromara.common.core.utils.StringUtils; -import org.dromara.common.mybatis.core.page.TableDataInfo; -import org.dromara.common.mybatis.core.page.PageQuery; -import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import cn.hutool.core.date.DateUtil; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import lombok.RequiredArgsConstructor; -import org.springframework.stereotype.Service; +import org.dromara.common.core.utils.MapstructUtils; +import org.dromara.common.core.utils.StringUtils; +import org.dromara.common.mybatis.core.page.PageQuery; +import org.dromara.common.mybatis.core.page.TableDataInfo; +import org.dromara.demo.domain.RsDangerTotal; import org.dromara.demo.domain.bo.RsDangerTotalBo; import org.dromara.demo.domain.vo.RsDangerTotalVo; -import org.dromara.demo.domain.RsDangerTotal; import org.dromara.demo.mapper.RsDangerTotalMapper; import org.dromara.demo.service.IRsDangerTotalService; +import org.springframework.stereotype.Service; +import java.time.LocalDate; +import java.time.LocalDateTime; +import java.time.LocalTime; +import java.util.Collection; import java.util.Date; import java.util.List; import java.util.Map; -import java.util.Collection; /** * 瀹夊叏闅愭偅缁熻Service涓氬姟灞傚鐞� @@ -69,6 +73,7 @@ lqw.eq(bo.getIssueNotice() != null, RsDangerTotal::getIssueNotice, bo.getIssueNotice()); lqw.eq(bo.getDealWithSecurityRisks() != null, RsDangerTotal::getDealWithSecurityRisks, bo.getDealWithSecurityRisks()); lqw.eq(bo.getStatus() != null, RsDangerTotal::getStatus, bo.getStatus()); + lqw.orderByDesc(RsDangerTotal::getCreateTime); return lqw; } @@ -92,7 +97,6 @@ @Override public Boolean updateByBo(RsDangerTotalBo bo) { RsDangerTotal update = MapstructUtils.convert(bo, RsDangerTotal.class); - validEntityBeforeSave(update); return baseMapper.updateById(update) > 0; } @@ -116,4 +120,14 @@ } return baseMapper.deleteBatchIds(ids) > 0; } + + @Override + public String importExcel(List<RsDangerTotal> list) { + for (RsDangerTotal dangerTotal : list) { + dangerTotal.setPeriod(dangerTotal.getPeriodDate().length() > 4 ? 1L : 2L); + dangerTotal.setCreateTime(new Date()); + dangerTotal.setStatus(2L); + } + return baseMapper.insertBatch(list) ? "鎭枩鎮紝鏁版嵁宸插叏閮ㄥ鍏ユ垚鍔燂紒鍏�" + list.size() + "鏉★紒" : "寰堟姳姝夛紝瀵煎叆澶辫触锛佽妫�鏌ユ暟鎹牸寮忥紒"; + } } -- Gitblit v1.8.0