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/CustomerServiceImpl.java | 25 +++++++++++++++++++++---- 1 files changed, 21 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java b/src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java index afc1c30..07431ac 100644 --- a/src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java +++ b/src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java @@ -11,10 +11,13 @@ import com.ruoyi.basic.service.ICustomerService; import com.ruoyi.common.utils.SecurityUtils; import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.framework.security.LoginUser; +import com.ruoyi.project.system.domain.SysUser; import lombok.AllArgsConstructor; import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Service; +import org.springframework.web.multipart.MultipartFile; import java.util.Arrays; import java.util.List; @@ -98,8 +101,8 @@ @Override public int insertCustomer(Customer customer) { LoginUser loginUser = SecurityUtils.getLoginUser(); - Integer tenantId = loginUser.getTenantId(); - customer.setTenantId(Long.valueOf(tenantId)); + Long tenantId = loginUser.getTenantId(); + customer.setTenantId(tenantId); return customerMapper.insert(customer); } @@ -112,8 +115,8 @@ @Override public int updateCustomer(Customer customer) { LoginUser loginUser = SecurityUtils.getLoginUser(); - Integer tenantId = loginUser.getTenantId(); - customer.setTenantId(Long.valueOf(tenantId)); + Long tenantId = loginUser.getTenantId(); + customer.setTenantId(tenantId); return customerMapper.updateById(customer); } @@ -142,6 +145,20 @@ } @Override + public Boolean importData(MultipartFile file) { + try { + ExcelUtil<Customer> util = new ExcelUtil<Customer>(Customer.class); + List<Customer> userList = util.importExcel(file.getInputStream()); + + this.saveOrUpdateBatch(userList); + return true; + }catch (Exception e){ + e.printStackTrace(); + } + return false; + } + + @Override public List<Map<String, Object>> customerList(Customer customer) { LambdaQueryWrapper<Customer> queryWrapper = Wrappers.lambdaQuery(); queryWrapper.select(Customer::getId, Customer::getCustomerName, Customer::getTaxpayerIdentificationNumber); -- Gitblit v1.9.3