zjk
2026-09-24 4c4b36e7337385ff15ff66a0ad487cdffaf9c86b
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
package com.tcm.training.admin.member.service;
 
import cn.idev.excel.FastExcel;
import com.tcm.training.admin.agent.service.ProvincialAgentAppService;
import com.tcm.training.admin.agent.vo.ProvincialAgentListItemVO;
import com.tcm.training.admin.common.PageResponse;
import org.junit.jupiter.api.Test;
import org.springframework.mock.web.MockHttpServletResponse;
 
import java.io.ByteArrayInputStream;
import java.util.Arrays;
import java.util.Collections;
import java.util.List;
import java.util.Map;
 
import static org.junit.jupiter.api.Assertions.assertEquals;
import static org.mockito.Mockito.doReturn;
import static org.mockito.Mockito.spy;
import static org.mockito.Mockito.verify;
 
class ProvincialAgentExportTest {
    private final ProvincialAgentAppService service =
            spy(new ProvincialAgentAppService(null, null, null, null, null));
 
    @Test
    void shouldExportAllBatchesWithFiltersAndPlainPhone() throws Exception {
        ProvincialAgentListItemVO item = new ProvincialAgentListItemVO();
        item.setAgentName("省代测试");
        item.setContactInfo("13800138000");
        item.setRegionNames(Arrays.asList("广东省", "湖南省"));
        item.setAddress("测试路88号");
        item.setStatus(1);
        item.setClinicCount(3L);
        doReturn(PageResponse.of(Collections.nCopies(200, item), 201, 1, 200))
                .when(service).page(1, 200, "44", "诊所", "138", 1);
        doReturn(PageResponse.of(Collections.singletonList(item), 201, 2, 200))
                .when(service).page(2, 200, "44", "诊所", "138", 1);
 
        MockHttpServletResponse response = new MockHttpServletResponse();
        service.export("44", "诊所", "138", 1, response);
        List<Map<Integer, String>> rows = readSheet(response);
 
        assertEquals(202, rows.size());
        assertEquals("负责人", rows.get(0).get(1));
        assertEquals("详细地址", rows.get(0).get(4));
        assertEquals("13800138000", rows.get(1).get(2));
        assertEquals("广东省、湖南省", rows.get(1).get(3));
        assertEquals("测试路88号", rows.get(1).get(4));
        assertEquals("3", rows.get(1).get(5));
        assertEquals("启用", rows.get(1).get(6));
        assertEquals("201", rows.get(201).get(0));
        verify(service).page(2, 200, "44", "诊所", "138", 1);
    }
 
    @Test
    void shouldExportHeadersWhenNoMatches() throws Exception {
        doReturn(PageResponse.of(Collections.emptyList(), 0, 1, 200))
                .when(service).page(1, 200, null, null, null, null);
        MockHttpServletResponse response = new MockHttpServletResponse();
 
        service.export(null, null, null, null, response);
 
        List<Map<Integer, String>> rows = readSheet(response);
        assertEquals(1, rows.size());
        assertEquals(8, rows.get(0).size());
    }
 
    private List<Map<Integer, String>> readSheet(MockHttpServletResponse response) {
        return FastExcel.read(new ByteArrayInputStream(response.getContentAsByteArray()))
                .headRowNumber(0).sheet().doReadSync();
    }
}