From 3e03f3d957c44ff2e4909b9fb4fff8621d466d10 Mon Sep 17 00:00:00 2001 From: chenrui <1187576398@qq.com> Date: 星期五, 06 六月 2025 17:05:23 +0800 Subject: [PATCH] 分页修改 --- src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java | 111 ++++++++++++++++++++++++++++++++++++++++++++++++++----- 1 files changed, 100 insertions(+), 11 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 e926f01..afc1c30 100644 --- a/src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java +++ b/src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java @@ -2,15 +2,25 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; - import com.ruoyi.basic.mapper.CustomerMapper; import com.ruoyi.basic.pojo.Customer; import com.ruoyi.basic.service.ICustomerService; +import com.ruoyi.common.utils.SecurityUtils; +import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.framework.security.LoginUser; import lombok.AllArgsConstructor; +import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Service; +import java.util.Arrays; import java.util.List; +import java.util.Map; +import java.util.Objects; +import java.util.stream.Collectors; /** @@ -21,6 +31,7 @@ */ @Service @AllArgsConstructor +@Slf4j public class CustomerServiceImpl extends ServiceImpl<CustomerMapper, Customer> implements ICustomerService { private CustomerMapper customerMapper; @@ -42,8 +53,40 @@ * @return 瀹㈡埛妗f */ @Override - public List<Customer> selectCustomerList(Customer customer) { - return customerMapper.selectList(new LambdaQueryWrapper<>()); + public IPage<Customer> selectCustomerList(Page page, Customer customer) { + // 1. 澶勭悊绌哄�煎満鏅紙鍙傛暟鏍¢獙锛� + if (page == null) { + page = Page.of(1, 10); // 榛樿绗�1椤碉紝姣忛〉10鏉℃暟鎹� + } + if (customer == null) { + customer = new Customer(); // 閬垮厤绌哄璞″鑷寸殑NPE + } + + // 2. 鏋勫缓鏌ヨ鏉′欢锛堝寮虹┖鍊煎畨鍏級 + LambdaQueryWrapper<Customer> queryWrapper = new LambdaQueryWrapper<>(); + String customerName = customer.getCustomerName(); + if (StringUtils.isNotBlank(customerName)) { + queryWrapper.like(Customer::getCustomerName, customerName); + } + + // 3. 鎵ц鍒嗛〉鏌ヨ锛堜繚鐣欏垎椤靛厓鏁版嵁锛� + IPage<Customer> customerPage = customerMapper.selectPage(page, queryWrapper); + + // 4. 鏁版嵁澶勭悊锛堝寮虹┖鍊煎畨鍏� & 浠g爜鍙鎬э級 + List<Customer> processedList = customerPage.getRecords().stream() + .filter(Objects::nonNull) // 杩囨护绌哄璞★紙閬垮厤鍚庣画鎿嶄綔NPE锛� + .peek(c -> { + // 瀹夊叏鑾峰彇瀛楁锛岄伩鍏峮ull鍊兼嫾鎺� + String address = StringUtils.defaultString(c.getCompanyAddress(), ""); + String phone = StringUtils.defaultString(c.getCompanyPhone(), ""); + c.setAddressPhone(address + "(" + phone + ")"); // 浼樺寲瀛楃涓叉嫾鎺� + }) + .collect(Collectors.toList()); + + // 5. 鏇存柊鍒嗛〉缁撴灉涓殑鏁版嵁锛堜繚鎸佸垎椤典俊鎭畬鏁达級 + customerPage.setRecords(processedList); + + return customerPage; // 杩斿洖鍖呭惈鍒嗛〉淇℃伅鐨処Page瀵硅薄 } /** @@ -54,6 +97,9 @@ */ @Override public int insertCustomer(Customer customer) { + LoginUser loginUser = SecurityUtils.getLoginUser(); + Integer tenantId = loginUser.getTenantId(); + customer.setTenantId(Long.valueOf(tenantId)); return customerMapper.insert(customer); } @@ -65,6 +111,9 @@ */ @Override public int updateCustomer(Customer customer) { + LoginUser loginUser = SecurityUtils.getLoginUser(); + Integer tenantId = loginUser.getTenantId(); + customer.setTenantId(Long.valueOf(tenantId)); return customerMapper.updateById(customer); } @@ -76,17 +125,57 @@ */ @Override public int deleteCustomerByIds(Long[] ids) { - return customerMapper.deleteCustomerByIds(ids); + List<Long> idList = Arrays.asList(ids); + return customerMapper.deleteBatchIds(idList); + } + + @Override + public List<Customer> selectCustomerListByIds(Long[] ids) { + LambdaQueryWrapper<Customer> queryWrapper = new LambdaQueryWrapper<>(); + queryWrapper.in(Customer::getId, Arrays.asList(ids)); + return customerMapper.selectList(queryWrapper); + } + + @Override + public List<Customer> selectCustomerLists(Customer customer) { + return customerMapper.selectList(null); + } + + @Override + public List<Map<String, Object>> customerList(Customer customer) { + LambdaQueryWrapper<Customer> queryWrapper = Wrappers.lambdaQuery(); + queryWrapper.select(Customer::getId, Customer::getCustomerName, Customer::getTaxpayerIdentificationNumber); + + // 鑾峰彇鍘熷鏌ヨ缁撴灉 + List<Map<String, Object>> result = customerMapper.selectMaps(queryWrapper); + + // 灏嗕笅鍒掔嚎鍛藉悕杞崲涓洪┘宄板懡鍚� + return result.stream().map(map -> map.entrySet().stream() + .collect(Collectors.toMap( + entry -> underlineToCamel(entry.getKey()), + Map.Entry::getValue)) + ).collect(Collectors.toList()); } /** - * 鍒犻櫎瀹㈡埛妗f淇℃伅 - * - * @param id 瀹㈡埛妗f涓婚敭 - * @return 缁撴灉 + * 涓嬪垝绾垮懡鍚嶈浆椹煎嘲鍛藉悕 */ - @Override - public int deleteCustomerById(Long id) { - return customerMapper.deleteById(id); + private String underlineToCamel(String param) { + if (param == null || "".equals(param.trim())) { + return ""; + } + int len = param.length(); + StringBuilder sb = new StringBuilder(len); + for (int i = 0; i < len; i++) { + char c = param.charAt(i); + if (c == '_') { + if (++i < len) { + sb.append(Character.toUpperCase(param.charAt(i))); + } + } else { + sb.append(Character.toLowerCase(c)); + } + } + return sb.toString(); } } -- Gitblit v1.9.3