From 37b697351e8e0a9200eee1276c4081c07588dc10 Mon Sep 17 00:00:00 2001 From: liyong <18434998025@163.com> Date: 星期二, 17 六月 2025 20:39:48 +0800 Subject: [PATCH] 未回款金额(元)为NaN修复 --- src/main/java/com/ruoyi/basic/service/impl/SupplierServiceImpl.java | 42 ++++++++++++++++++++++++++++++++++++++---- 1 files changed, 38 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/ruoyi/basic/service/impl/SupplierServiceImpl.java b/src/main/java/com/ruoyi/basic/service/impl/SupplierServiceImpl.java index 3fb77dd..816fe04 100644 --- a/src/main/java/com/ruoyi/basic/service/impl/SupplierServiceImpl.java +++ b/src/main/java/com/ruoyi/basic/service/impl/SupplierServiceImpl.java @@ -1,5 +1,6 @@ package com.ruoyi.basic.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; @@ -9,11 +10,17 @@ import com.ruoyi.basic.pojo.Customer; import com.ruoyi.basic.pojo.SupplierManage; import com.ruoyi.basic.service.ISupplierService; +import com.ruoyi.common.utils.SecurityUtils; import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.framework.web.domain.AjaxResult; +import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; +import java.time.LocalDate; +import java.util.ArrayList; import java.util.List; @Service @@ -34,12 +41,14 @@ /** * 渚涘簲鍟嗗垹闄� - * @param id + * @param ids * @return */ @Override - public int delSupplier(Integer id) { - return supplierMapper.deleteById(id); + public int delSupplier(List<Integer> ids) { + LambdaQueryWrapper<SupplierManage> delWrapper = new LambdaQueryWrapper<>(); + delWrapper.in(SupplierManage::getId, ids); + return supplierMapper.delete(delWrapper); } /** @@ -58,7 +67,7 @@ * @return */ @Override - public int supplierManage(SupplierManage supplierManage) { + public int supplierUpdate(SupplierManage supplierManage) { return supplierMapper.updateById(supplierManage); } @@ -84,4 +93,29 @@ ExcelUtil<SupplierManageExcelDto> util = new ExcelUtil<SupplierManageExcelDto>(SupplierManageExcelDto.class); util.exportExcel(response, supplierManageList, "渚涘簲鍟嗗鍑�"); } + + @Override + public Boolean importData(MultipartFile file) { + + try { + ExcelUtil<SupplierManageExcelDto> util = new ExcelUtil<SupplierManageExcelDto>(SupplierManageExcelDto.class); + List<SupplierManageExcelDto> list = util.importExcel(file.getInputStream()); + ArrayList<SupplierManage> supplierManages = new ArrayList<>(); + list.stream().forEach(dto -> { + SupplierManage supplierManage = new SupplierManage(); + BeanUtils.copyProperties(dto,supplierManage); + supplierManage.setMaintainTime(LocalDate.now()); + Long userId = SecurityUtils.getLoginUser().getUser().getUserId(); + + supplierManage.setMaintainUserId(Integer.parseInt(userId+"")); + supplierManages.add(supplierManage); + }); + + this.saveOrUpdateBatch(supplierManages); + return true; + }catch (Exception e){ + e.printStackTrace(); + } + return false; + } } -- Gitblit v1.9.3