From b2f8320707dc72b2429bfb4fe0b317c11b1e5b7f Mon Sep 17 00:00:00 2001
From: zhangwencui <1064582902@qq.com>
Date: 星期四, 29 十月 2026 16:34:45 +0800
Subject: [PATCH] change

---
 src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java |  146 +++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 129 insertions(+), 17 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 52d01ec..ce90a16 100644
--- a/src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java
+++ b/src/main/java/com/ruoyi/basic/service/impl/CustomerServiceImpl.java
@@ -21,12 +21,19 @@
 import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.framework.security.LoginUser;
 import com.ruoyi.framework.web.domain.R;
+import com.ruoyi.procurementrecord.mapper.ReturnManagementMapper;
+import com.ruoyi.procurementrecord.pojo.ReturnManagement;
 import com.ruoyi.sales.mapper.SalesLedgerMapper;
+import com.ruoyi.sales.mapper.SalesQuotationMapper;
 import com.ruoyi.sales.pojo.SalesLedger;
+import com.ruoyi.sales.pojo.SalesQuotation;
+import com.ruoyi.sales.vo.CustomerTransactionsDetailsVo;
+import com.ruoyi.sales.vo.CustomerTransactionsVo;
 import lombok.AllArgsConstructor;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.jdbc.core.JdbcTemplate;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 import org.springframework.util.CollectionUtils;
@@ -48,7 +55,11 @@
 @Slf4j
 public class CustomerServiceImpl extends ServiceImpl<CustomerMapper, Customer> implements ICustomerService {
     @Autowired
-    private  SalesLedgerMapper salesLedgerMapper;
+    private SalesLedgerMapper salesLedgerMapper;
+    @Autowired
+    private SalesQuotationMapper salesQuotationMapper;
+    @Autowired
+    private ReturnManagementMapper returnManagementMapper;
     @Autowired
     private CustomerMapper customerMapper;
 
@@ -60,6 +71,8 @@
     private CustomerReturnVisitService customerReturnVisitService;
     @Autowired
     private CustomerUserService customerUserService;
+    @Autowired
+    private JdbcTemplate jdbcTemplate;
 
     /**
      * 鏌ヨ瀹㈡埛妗f
@@ -82,6 +95,13 @@
     public CustomerVo selectCustomerDetailById(Long id) {
         CustomerVo customerVo = new CustomerVo();
         BeanUtils.copyProperties(this.getById(id), customerVo);
+
+        // 鍥炴樉缁戝畾鐨勭櫥褰曡处鍙�
+        CustomerUser binding = customerUserService.getOne(new LambdaQueryWrapper<CustomerUser>()
+                .eq(CustomerUser::getCustomerId, id).last("limit 1"), false);
+        if (binding != null) {
+            customerVo.setBindUserId(binding.getUserId());
+        }
 
         // 鏌ヨ璺熻繘璁板綍
         List<CustomerFollowUp> followUpList = customerFollowUpService.list(
@@ -119,7 +139,8 @@
     @Override
     public IPage<CustomerVo> selectCustomerList(Page<CustomerDto> page, CustomerDto customer) {
         LoginUser loginUser = SecurityUtils.getLoginUser();
-        Long loginUserId = loginUser.getUserId();
+        // 瓒呯骇绠$悊鍛樹笉鍙楀鎴烽鐢�/鍏变韩鑼冨洿闄愬埗锛屽彲鏌ョ湅鍏ㄩ儴瀹㈡埛
+        Long loginUserId = isSuperAdmin(loginUser) ? null : loginUser.getUserId();
         IPage<CustomerVo> customerPage = customerMapper.listPage(page, customer, loginUserId);
 
         List<CustomerVo> records = customerPage.getRecords();
@@ -185,11 +206,14 @@
      * @return 缁撴灉
      */
     @Override
+    @Transactional(rollbackFor = Exception.class)
     public int insertCustomer(Customer customer) {
         LoginUser loginUser = SecurityUtils.getLoginUser();
         Long tenantId = loginUser.getTenantId();
         customer.setTenantId(tenantId);
-        return customerMapper.insert(customer);
+        int rows = customerMapper.insert(customer);
+        saveCustomerBinding(customer.getId(), customer.getBindUserId());
+        return rows;
     }
 
     /**
@@ -199,11 +223,38 @@
      * @return 缁撴灉
      */
     @Override
+    @Transactional(rollbackFor = Exception.class)
     public int updateCustomer(Customer customer) {
         LoginUser loginUser = SecurityUtils.getLoginUser();
         Long tenantId = loginUser.getTenantId();
         customer.setTenantId(tenantId);
-        return customerMapper.updateById(customer);
+        int rows = customerMapper.updateById(customer);
+        saveCustomerBinding(customer.getId(), customer.getBindUserId());
+        return rows;
+    }
+
+    /**
+     * 淇濆瓨瀹㈡埛涓庣櫥褰曡处鍙风殑涓�瀵逛竴缁戝畾鍏崇郴
+     */
+    private void saveCustomerBinding(Long customerId, Long bindUserId) {
+        if (customerId == null) {
+            return;
+        }
+        customerUserService.remove(new LambdaQueryWrapper<CustomerUser>()
+                .eq(CustomerUser::getCustomerId, customerId));
+        if (bindUserId == null) {
+            return;
+        }
+        // 涓�涓櫥褰曡处鍙峰彧鑳界粦瀹氫竴涓鎴�
+        customerUserService.remove(new LambdaQueryWrapper<CustomerUser>()
+                .eq(CustomerUser::getUserId, bindUserId));
+        CustomerUser binding = new CustomerUser();
+        binding.setCustomerId(customerId);
+        binding.setUserId(bindUserId);
+        customerUserService.save(binding);
+        // 缁戝畾璐﹀彿鑷姩鎺堜簣鈥滃鎴封�濊鑹诧紝浣垮叾鐧诲綍鍚庡彧鑳借闂鎴烽棬鎴�
+        jdbcTemplate.update("INSERT IGNORE INTO sys_user_role (user_id, role_id) "
+                + "SELECT ?, role_id FROM sys_role WHERE role_key = 'customer' AND del_flag = '0'", bindUserId);
     }
 
     /**
@@ -216,10 +267,24 @@
     @Transactional(rollbackFor = Exception.class)
     public int deleteCustomerByIds(Long[] ids) {
         List<Long> idList = Arrays.asList(ids);
+        // 妫�鏌ユ槸鍚︽湁閿�鍞彴璐﹀叧鑱�
         List<SalesLedger> salesLedgers = salesLedgerMapper.selectList(new QueryWrapper<SalesLedger>().lambda().in(SalesLedger::getCustomerId, idList));
         if (!salesLedgers.isEmpty()) {
-            throw new RuntimeException("瀹㈡埛妗f涓嬫湁閿�鍞悎鍚岋紝璇峰厛鍒犻櫎閿�鍞悎鍚�");
+            throw new RuntimeException("瀹㈡埛妗f涓嬫湁閿�鍞彴璐︼紝璇峰厛鍒犻櫎閿�鍞彴璐�");
         }
+
+        // 妫�鏌ユ槸鍚︽湁閿�鍞��璐у叧鑱�
+        List<ReturnManagement> returnManagements = returnManagementMapper.selectList(new QueryWrapper<ReturnManagement>().lambda().in(ReturnManagement::getCustomerId, idList));
+        if (!returnManagements.isEmpty()) {
+            throw new RuntimeException("瀹㈡埛妗f涓嬫湁閿�鍞��璐э紝璇峰厛鍒犻櫎閿�鍞��璐�");
+        }
+
+        // 妫�鏌ユ槸鍚︽湁閿�鍞姤浠峰叧鑱�
+        List<SalesQuotation> salesQuotations = salesQuotationMapper.selectList(new QueryWrapper<SalesQuotation>().lambda().in(SalesQuotation::getCustomerId, idList));
+        if (!salesQuotations.isEmpty()) {
+            throw new RuntimeException("瀹㈡埛妗f涓嬫湁閿�鍞姤浠凤紝璇峰厛鍒犻櫎閿�鍞姤浠�");
+        }
+
         // 鏌ヨ鏄惁鏈夊凡鍒嗛厤鐨勫叕娴峰鎴�
         List<Customer> assignedPools = customerMapper.selectList(
                 new QueryWrapper<Customer>().lambda()
@@ -255,8 +320,14 @@
     @Override
     public List<CustomerVo> selectCustomerLists(CustomerDto customer) {
         LoginUser loginUser = SecurityUtils.getLoginUser();
-        Long loginUserId = loginUser.getUserId();
+        // 瓒呯骇绠$悊鍛樹笉鍙楀鎴烽鐢�/鍏变韩鑼冨洿闄愬埗锛屽彲瀵煎嚭鍏ㄩ儴瀹㈡埛
+        Long loginUserId = isSuperAdmin(loginUser) ? null : loginUser.getUserId();
         return customerMapper.list(customer, loginUserId);
+    }
+
+    /** 瓒呯骇绠$悊鍛橈細涓嶅彈瀹㈡埛棰嗙敤/鍏变韩鑼冨洿闄愬埗 */
+    private boolean isSuperAdmin(LoginUser loginUser) {
+        return loginUser != null && loginUser.getUser() != null && loginUser.getUser().isAdmin();
     }
 
     @Override
@@ -285,18 +356,26 @@
 
     @Override
     public List<Map<String, Object>> customerList(Customer customer) {
-        LambdaQueryWrapper<Customer> queryWrapper = Wrappers.lambdaQuery();
-        queryWrapper.select(Customer::getId, Customer::getCustomerName, Customer::getTaxpayerIdentificationNumber);
+        LoginUser loginUser = SecurityUtils.getLoginUser();
+        Long loginUserId = loginUser.getUserId();
+        CustomerDto query = new CustomerDto();
+        if (customer != null) {
+            BeanUtils.copyProperties(customer, query);
+        }
 
-        // 鑾峰彇鍘熷鏌ヨ缁撴灉
-        List<Map<String, Object>> result = customerMapper.selectMaps(queryWrapper);
+        // 澶嶇敤瀹㈡埛鍒楄〃鐨勫彲瑙佹�ц鍒欙紝閬垮厤鎶婂埆浜虹殑绉佹捣瀹㈡埛鏆撮湶缁欏綋鍓嶈处鍙�
+        List<CustomerVo> visibleCustomers = customerMapper.list(query, loginUserId);
+        if (CollectionUtils.isEmpty(visibleCustomers)) {
+            return Collections.emptyList();
+        }
 
-        // 灏嗕笅鍒掔嚎鍛藉悕杞崲涓洪┘宄板懡鍚�
-        return result.stream().map(map -> map.entrySet().stream()
-                .collect(Collectors.toMap(
-                        entry -> underlineToCamel(entry.getKey()),
-                        Map.Entry::getValue))
-        ).collect(Collectors.toList());
+        return visibleCustomers.stream().map(item -> {
+            Map<String, Object> map = new LinkedHashMap<>();
+            map.put("id", item.getId());
+            map.put("customerName", item.getCustomerName());
+            map.put("taxpayerIdentificationNumber", item.getTaxpayerIdentificationNumber());
+            return map;
+        }).collect(Collectors.toList());
     }
 
     // 鍒嗛厤鍏捣瀹㈡埛缁欑娴�
@@ -317,6 +396,7 @@
     public void recycleCustomer(CustomerDto customerDto) {
         Customer customer = customerMapper.selectById(customerDto.getId());
         if (customer.getType() == 1 && customer.getIsAssigned() == 1) {  // 鍏捣涓斿凡鍒嗛厤
+            validatePublicSeaRecyclePermission(customer.getId());
             customer.setIsAssigned(0);
             customer.setUsageStatus(0L);
             customer.setUsageUser(0L);
@@ -375,10 +455,42 @@
         //灏嗗鎴风殑type鏀逛负1 涓旂洿鎺ュ垎閰嶇粰褰撳墠鐢ㄦ埛
         Customer customer = customerMapper.selectById(id);
         customer.setType(1);
-        customer.setIsAssigned(1);
+        customer.setIsAssigned(0);
         return this.updateById(customer);
     }
 
+    private void validatePublicSeaRecyclePermission(Long customerId) {
+        if (hasSalesModuleReference(customerId)) {
+            throw new RuntimeException("宸查鐢ㄥ苟涓旇閿�鍞ā鍧楀紩鐢ㄧ殑鍏捣瀹㈡埛涓嶈兘鍥炴敹");
+        }
+    }
+
+    private boolean hasSalesModuleReference(Long customerId) {
+        Long salesLedgerCount = salesLedgerMapper.selectCount(new QueryWrapper<SalesLedger>().lambda()
+                .eq(SalesLedger::getCustomerId, customerId));
+        if (salesLedgerCount != null && salesLedgerCount > 0) {
+            return true;
+        }
+        Long salesQuotationCount = salesQuotationMapper.selectCount(new QueryWrapper<SalesQuotation>().lambda()
+                .eq(SalesQuotation::getCustomerId, customerId));
+        if (salesQuotationCount != null && salesQuotationCount > 0) {
+            return true;
+        }
+        Long returnManagementCount = returnManagementMapper.selectCount(new QueryWrapper<ReturnManagement>().lambda()
+                .eq(ReturnManagement::getCustomerId, customerId));
+        return returnManagementCount != null && returnManagementCount > 0;
+    }
+
+    @Override
+    public IPage<CustomerTransactionsVo> customewTransactions(Page page, String customerName) {
+        return customerMapper.customewTransactions(page, customerName);
+    }
+
+    @Override
+    public IPage<CustomerTransactionsDetailsVo> customewTransactionsDetails(Page page, Long customerId) {
+        return customerMapper.customewTransactionsDetails(page, customerId);
+    }
+
     /**
      * 涓嬪垝绾垮懡鍚嶈浆椹煎嘲鍛藉悕
      */

--
Gitblit v1.9.3