package cn.iocoder.yudao.module.visit.service.home;

import cn.hutool.core.collection.CollUtil;
import cn.iocoder.yudao.framework.common.pojo.PageResult;
import cn.iocoder.yudao.module.system.api.dict.DictDataApi;
import cn.iocoder.yudao.module.system.api.dict.dto.DictDataRespDTO;
import cn.iocoder.yudao.module.system.dal.dataobject.user.AdminUserDO;
import cn.iocoder.yudao.module.system.dal.mysql.user.AdminUserMapper;
import cn.iocoder.yudao.module.visit.controller.admin.customerinfo.vo.CustomerInfoPageReqVO;
import cn.iocoder.yudao.module.visit.controller.admin.home.vo.*;
import cn.iocoder.yudao.module.visit.controller.admin.info.vo.InfoPageReqVO;
import cn.iocoder.yudao.module.visit.dal.dataobject.customerinfo.CustomerInfoDO;
import cn.iocoder.yudao.module.visit.dal.dataobject.info.InfoDO;
import cn.iocoder.yudao.module.visit.dal.dataobject.product.ProductDO;
import cn.iocoder.yudao.module.visit.dal.mysql.customerinfo.CustomerInfoMapper;
import cn.iocoder.yudao.module.visit.dal.mysql.info.InfoMapper;
import cn.iocoder.yudao.module.visit.dal.mysql.product.ProductMapper;
import org.apache.commons.lang3.StringUtils;
import org.apache.commons.lang3.math.NumberUtils;
import org.springframework.stereotype.Service;
import org.springframework.validation.annotation.Validated;

import javax.annotation.Resource;
import java.time.DayOfWeek;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.util.*;
import java.util.stream.Collectors;
import java.util.stream.Stream;

/**
 * 主页 Service 实现类
 *
 * @author 超级管理员
 */
@Service
@Validated
public class HomeServiceImpl implements HomeService {

    @Resource
    private CustomerInfoMapper customerInfoMapper;
    @Resource
    private InfoMapper  infoMapper;
    @Resource
    private ProductMapper productMapper;
    @Resource
    private AdminUserMapper userMapper;
    @Resource
    private DictDataApi dictDataApi;

    //首页第一排数据
    @Override
    public HomeFirstRespVO getHomeInfoFirst(HomeReqVO reqVO) {
        HomeFirstRespVO homeFirstRespVO = new HomeFirstRespVO();
        //业务员数量(不按时间）
        List<AdminUserDO> userDOS = userMapper.selectList();
        homeFirstRespVO.setYwysl(String.valueOf(userDOS.size()));
        //按创建时间查这段时间的客户数量
        CustomerInfoPageReqVO customerInfoPageReqVO = new CustomerInfoPageReqVO();
        customerInfoPageReqVO.setCreateTime(reqVO.getSearchTime());
        customerInfoPageReqVO.setPageSize(-1);//不分页
        customerInfoPageReqVO.setCompanyName(reqVO.getCompanyName());
        PageResult<CustomerInfoDO> customerInfoDOPageResult = customerInfoMapper.selectHomePage(customerInfoPageReqVO);//精准查询
        //拜访客户总数量
        homeFirstRespVO.setBfkhsl(String.valueOf(customerInfoDOPageResult.getTotal()));
        //商业客户数量
        String sykhsl = customerInfoDOPageResult.getList().stream().filter(customerInfoDO -> customerInfoDO.getCustomerType() == 0).count() + "";
        //医疗客户数量
        String ylkhsl = customerInfoDOPageResult.getList().stream().filter(customerInfoDO -> customerInfoDO.getCustomerType() == 1).count() + "";
        homeFirstRespVO.setSykhsl(sykhsl);
        homeFirstRespVO.setYlkhsl(ylkhsl);
        //按拜访时间查这段时间的拜访次数
        InfoPageReqVO infoPageReqVO = new InfoPageReqVO();
        infoPageReqVO.setVisitDate(reqVO.getSearchTime());
        infoPageReqVO.setPageSize(-1);//不分页
        infoPageReqVO.setCompanyName(reqVO.getCompanyName());
        PageResult<InfoDO> infoDOPageResult = infoMapper.selectHomePage(infoPageReqVO);//精准查询
        //客户拜访总次数
        homeFirstRespVO.setVisitCount(String.valueOf(infoDOPageResult.getTotal()));
        homeFirstRespVO.setSykfcs(String.valueOf(infoDOPageResult.getList().stream().filter(infoDO -> infoDO.getVisitType() == 0).count()));
        homeFirstRespVO.setYlkfcs(String.valueOf(infoDOPageResult.getList().stream().filter(infoDO -> infoDO.getVisitType() == 1).count()));
        return homeFirstRespVO;
    }

    //拜访周统计
    @Override
    public HomeBfztjRespVO getHomeInfoBfztj(HomeReqVO reqVO) {
        //如果查询时间是空，则start = LocalDateTime.now().minusWeeks(10);
        LocalDateTime start = null;
        LocalDateTime end = null;
        if (reqVO.getSearchTime() == null) {
            start = LocalDateTime.now().minusWeeks(9);
            end = LocalDateTime.now();
        }else {
            start = reqVO.getSearchTime()[0];
            end = reqVO.getSearchTime()[1];
        }


        // 对齐到每周一
        start = start.with(DayOfWeek.MONDAY);
        List<String> weeks = new ArrayList<>();
        List<Integer> counts = new ArrayList<>();

        for (int i = 0; i < 10; i++) {
            LocalDateTime weekStart = start.plusWeeks(i);
            LocalDateTime weekEnd = weekStart.plusDays(6).with(LocalTime.MAX);
            LocalDateTime[] week = new LocalDateTime[]{weekStart, weekEnd};
            if (weekStart.isAfter(end)) break;

            int count = 0;//拜访次数
            InfoPageReqVO infoPageReqVO = new InfoPageReqVO();
            infoPageReqVO.setVisitDate(week);
            infoPageReqVO.setPageSize(-1);//不分页
            infoPageReqVO.setCompanyName(reqVO.getCompanyName());
            PageResult<InfoDO> infoDOPageResult = infoMapper.selectHomePage(infoPageReqVO);//精准查询
            count = Math.toIntExact(infoDOPageResult.getTotal());
            weeks.add("WEEK" + (i + 1));
            counts.add(count);
        }

        HomeBfztjRespVO vo = new HomeBfztjRespVO();
        vo.setWeeks(weeks);
        vo.setVisitCounts(counts);
        vo.setTotalWeeks(weeks.size());
        return vo;
    }

    //客户性质等级占比情况
    @Override
    public HomeKhxzdjzbqkRespVO getHomeInfoKhxzdjzbqk(HomeReqVO reqVO) {
        //1.先查出所有的客户信息
        InfoPageReqVO infoPageReqVO = new InfoPageReqVO();
        infoPageReqVO.setPageSize(-1);
        infoPageReqVO.setVisitDate(reqVO.getSearchTime());
        infoPageReqVO.setCompanyName(reqVO.getCompanyName());
        PageResult<InfoDO> infoDOPageResult = infoMapper.selectHomePage(infoPageReqVO);
        List<InfoDO> records = infoDOPageResult.getList();

        // 2.分组计数：Map<customerType字典值, 数量>
        Map<Integer, Long> typeCountMap = records.stream()
                .collect(Collectors.groupingBy(InfoDO::getCustomerStatus, Collectors.counting()));

        // 3. 加载字典并转换为 Map
        List<DictDataRespDTO> dictList = dictDataApi.getDictDataList("customer_type");
        Map<String, String> dictMap = dictList.stream()
                .collect(Collectors.toMap(DictDataRespDTO::getValue, DictDataRespDTO::getLabel));

        // 4. 组装返回列表
        List<HomeKhxzdjzbqkRespVO.TypeCountItem> list = typeCountMap.entrySet().stream()
                .map(entry -> {
                    HomeKhxzdjzbqkRespVO.TypeCountItem item = new HomeKhxzdjzbqkRespVO.TypeCountItem();
                    item.setName(dictMap.getOrDefault(entry.getKey().toString(), "未知"));
                    item.setValue(entry.getValue().intValue());
                    return item;
                })
                .collect(Collectors.toList());

        // 5. 返回结果
        HomeKhxzdjzbqkRespVO respVO = new HomeKhxzdjzbqkRespVO();
        respVO.setList(list);
        respVO.setTotal(records.size());
        return respVO;
    }

    //拜访人均分布情况
    @Override
    public HomeKhxzdjzbqkRespVO getHomeInfoBfrjfbqk(HomeReqVO reqVO) {
        //1.先查出所有的拜访记录
        InfoPageReqVO infoPageReqVO = new InfoPageReqVO();
        infoPageReqVO.setPageSize(-1);
        infoPageReqVO.setVisitDate(reqVO.getSearchTime());
        infoPageReqVO.setCompanyName(reqVO.getCompanyName());
        PageResult<InfoDO> infoDOPageResult = infoMapper.selectHomePage(infoPageReqVO);
        List<InfoDO> records = infoDOPageResult.getList();
        // 按业务员分组计数
        Map<String, Long> countMap = records.stream()
                .filter(r -> StringUtils.isNotBlank(r.getCreator()))
                .collect(Collectors.groupingBy(InfoDO::getCreator, Collectors.counting()));

        // 倒序排序，取前10
        List<Map.Entry<String, Long>> top10 = countMap.entrySet().stream()
                .sorted(Map.Entry.<String, Long>comparingByValue())
                .limit(10)
                .collect(Collectors.toList());

        // 拆分为两个数组
//        List<String> names = top10.stream().map(Map.Entry::getKey).collect(Collectors.toList());
//        List<Integer> values = top10.stream().map(e -> e.getValue().intValue()).collect(Collectors.toList());
        //直接成对放入
        List<HomeKhxzdjzbqkRespVO.TypeCountItem> list = top10.stream()
                .map(entry -> {
                    HomeKhxzdjzbqkRespVO.TypeCountItem item = new HomeKhxzdjzbqkRespVO.TypeCountItem();
                    item.setName(entry.getKey());
                    item.setValue(entry.getValue().intValue());
                    return item;
                })
                .collect(Collectors.toList());
        HomeKhxzdjzbqkRespVO respVO = new HomeKhxzdjzbqkRespVO();
        respVO.setList(list);
        return respVO;
    }

    // 客户拜访方式分布情况
    @Override
    public HomeKhxzdjzbqkRespVO getHomeInfoKhbffszbqk(HomeReqVO reqVO) {
        //1.先查出所有的客户信息
        InfoPageReqVO infoPageReqVO = new InfoPageReqVO();
        infoPageReqVO.setPageSize(-1);
        infoPageReqVO.setVisitDate(reqVO.getSearchTime());
        infoPageReqVO.setCompanyName(reqVO.getCompanyName());
        PageResult<InfoDO> infoDOPageResult = infoMapper.selectHomePage(infoPageReqVO);
        List<InfoDO> records = infoDOPageResult.getList();

        // 2.分组计数：Map<customerType字典值, 数量>
        Map<Integer, Long> typeCountMap = records.stream()
                .collect(Collectors.groupingBy(InfoDO::getVisitMethod, Collectors.counting()));

        // 3. 加载字典并转换为 Map
        List<DictDataRespDTO> dictList = dictDataApi.getDictDataList("visit_method");
        Map<String, String> dictMap = dictList.stream()
                .collect(Collectors.toMap(DictDataRespDTO::getValue, DictDataRespDTO::getLabel));

        // 4. 组装返回列表
        List<HomeKhxzdjzbqkRespVO.TypeCountItem> list = typeCountMap.entrySet().stream()
                .map(entry -> {
                    HomeKhxzdjzbqkRespVO.TypeCountItem item = new HomeKhxzdjzbqkRespVO.TypeCountItem();
                    item.setName(dictMap.getOrDefault(entry.getKey().toString(), "未知"));
                    item.setValue(entry.getValue().intValue());
                    return item;
                })
                .collect(Collectors.toList());

        // 5. 返回结果
        HomeKhxzdjzbqkRespVO respVO = new HomeKhxzdjzbqkRespVO();
        respVO.setList(list);
        respVO.setTotal(records.size());
        return respVO;
    }

    //  客户部门分布情况
    @Override
    public HomeKhxzdjzbqkRespVO getHomeInfoKhbmzbqk(HomeReqVO reqVO) {
        //1.先查出所有的客户信息
        InfoPageReqVO infoPageReqVO = new InfoPageReqVO();
        infoPageReqVO.setPageSize(-1);
        infoPageReqVO.setVisitDate(reqVO.getSearchTime());
        infoPageReqVO.setCompanyName(reqVO.getCompanyName());
        PageResult<InfoDO> infoDOPageResult = infoMapper.selectHomePage(infoPageReqVO);
        List<InfoDO> records = infoDOPageResult.getList();

        // 2.分组计数：Map<customerType字典值, 数量>
        Map<String, Long> typeCountMap = records.stream()
                .collect(Collectors.groupingBy(InfoDO::getDepartment, Collectors.counting()));

        // 3. 加载字典并转换为 Map
        List<DictDataRespDTO> dictList = dictDataApi.getDictDataList("customer_dept");
        Map<String, String> dictMap = dictList.stream()
                .collect(Collectors.toMap(DictDataRespDTO::getValue, DictDataRespDTO::getLabel));

        // 4. 组装返回列表
        List<HomeKhxzdjzbqkRespVO.TypeCountItem> list = typeCountMap.entrySet().stream()
                .map(entry -> {
                    HomeKhxzdjzbqkRespVO.TypeCountItem item = new HomeKhxzdjzbqkRespVO.TypeCountItem();
                    item.setName(dictMap.getOrDefault(entry.getKey().toString(), "未知"));
                    item.setValue(entry.getValue().intValue());
                    return item;
                })
                .collect(Collectors.toList());

        // 5. 返回结果
        HomeKhxzdjzbqkRespVO respVO = new HomeKhxzdjzbqkRespVO();
        respVO.setList(list);
        respVO.setTotal(records.size());
        return respVO;
    }

    //  客户拜访类型分布情况
    @Override
    public HomeKhxzdjzbqkRespVO getHomeInfoKhbflxzbqk(HomeReqVO reqVO) {
        //1.先查出所有的客户信息
        InfoPageReqVO infoPageReqVO = new InfoPageReqVO();
        infoPageReqVO.setPageSize(-1);
        infoPageReqVO.setVisitDate(reqVO.getSearchTime());
        infoPageReqVO.setCompanyName(reqVO.getCompanyName());
        PageResult<InfoDO> infoDOPageResult = infoMapper.selectHomePage(infoPageReqVO);
        List<InfoDO> records = infoDOPageResult.getList();

        // 2.分组计数：Map<customerType字典值, 数量>
        Map<Integer, Long> typeCountMap = records.stream()
                .collect(Collectors.groupingBy(InfoDO::getVisitType, Collectors.counting()));

        // 3. 加载字典并转换为 Map
        List<DictDataRespDTO> dictList = dictDataApi.getDictDataList("visit_type");
        Map<String, String> dictMap = dictList.stream()
                .collect(Collectors.toMap(DictDataRespDTO::getValue, DictDataRespDTO::getLabel));

        // 4. 组装返回列表
        List<HomeKhxzdjzbqkRespVO.TypeCountItem> list = typeCountMap.entrySet().stream()
                .map(entry -> {
                    HomeKhxzdjzbqkRespVO.TypeCountItem item = new HomeKhxzdjzbqkRespVO.TypeCountItem();
                    item.setName(dictMap.getOrDefault(entry.getKey().toString(), "未知"));
                    item.setValue(entry.getValue().intValue());
                    return item;
                })
                .collect(Collectors.toList());

        // 5. 返回结果
        HomeKhxzdjzbqkRespVO respVO = new HomeKhxzdjzbqkRespVO();
        respVO.setList(list);
        respVO.setTotal(records.size());
        return respVO;
    }

    @Override
    public HomeKhxzdjzbqkRespVO getHomeInfoBfcplxzbqk(HomeReqVO reqVO) {
        //1.先查出所有的客户信息
        InfoPageReqVO infoPageReqVO = new InfoPageReqVO();
        infoPageReqVO.setPageSize(-1);
        infoPageReqVO.setVisitDate(reqVO.getSearchTime());
        infoPageReqVO.setCompanyName(reqVO.getCompanyName());
        PageResult<InfoDO> infoDOPageResult = infoMapper.selectHomePage(infoPageReqVO);
        List<InfoDO> records = infoDOPageResult.getList();
        // 2. 收集所有产品 ID
        Set<Long> productIdSet = records.stream()
                .flatMap(r -> {
                    String ids = r.getVisitProductIds();
                    if (StringUtils.isBlank(ids)) return Stream.empty();
                    return Arrays.stream(ids.split(","))
                            .map(String::trim)
                            .filter(StringUtils::isNotBlank)
                            .map(Long::valueOf);
                })
                .collect(Collectors.toSet());

        // 3. 查询产品信息（id => 名称-规格）
        //判断是否为空
        if (CollUtil.isEmpty(productIdSet)){
            HomeKhxzdjzbqkRespVO vo = new HomeKhxzdjzbqkRespVO();
            vo.setList(new ArrayList<HomeKhxzdjzbqkRespVO.TypeCountItem>());
            return vo;
        }
        List<ProductDO> productList = productMapper.selectByIds(productIdSet);
        Map<Long, String> productMap = productList.stream()
                .collect(Collectors.toMap(
                        ProductDO::getId,
                        p -> p.getProductName() + "-" + p.getSpecification()
                ));

        // 4. 遍历所有拜访记录统计产品使用次数
        Map<String, Integer> statMap = new HashMap<>();
        for (InfoDO record : records) {
            if (StringUtils.isBlank(record.getVisitProductIds())) continue;
            for (String pidStr : record.getVisitProductIds().split(",")) {
                Long pid = NumberUtils.toLong(pidStr.trim(), -1);
                if (!productMap.containsKey(pid)) continue;
                String key = productMap.get(pid);
                statMap.merge(key, 1, Integer::sum);
            }
        }

        // 5. 排序取前 N（如 top10）
        List<Map.Entry<String, Integer>> topList = statMap.entrySet().stream()
                .sorted(Map.Entry.<String, Integer>comparingByValue())
                .limit(10)
                .collect(Collectors.toList());

        //直接成对放入list
        List<HomeKhxzdjzbqkRespVO.TypeCountItem> list = topList.stream()
                .map(entry -> {
                    HomeKhxzdjzbqkRespVO.TypeCountItem item = new HomeKhxzdjzbqkRespVO.TypeCountItem();
                    item.setName(entry.getKey());
                    item.setValue(entry.getValue());
                    return item;
                })
                .collect(Collectors.toList());
//        List<String> names = topList.stream().map(Map.Entry::getKey).collect(Collectors.toList());
//        List<Integer> values = topList.stream().map(Map.Entry::getValue).collect(Collectors.toList());

        // 6. 构建返回结果
        HomeKhxzdjzbqkRespVO vo = new HomeKhxzdjzbqkRespVO();
        vo.setList(list);
        return vo;
    }

    @Override
    public HomeBfrtjRespVO getHomeInfoBfrtj(HomeReqVO reqVO) {
        //1.先查出所有的客户信息
        InfoPageReqVO infoPageReqVO = new InfoPageReqVO();
        infoPageReqVO.setPageSize(-1);
        infoPageReqVO.setVisitDate(reqVO.getSearchTime());
        infoPageReqVO.setCompanyName(reqVO.getCompanyName());
        PageResult<InfoDO> infoDOPageResult = infoMapper.selectHomePage(infoPageReqVO);
        List<InfoDO> records = infoDOPageResult.getList();
        // 2. 按日期（yyyy-MM-dd）分组计数
        Map<LocalDate, Long> dateCountMap = records.stream()
                .collect(Collectors.groupingBy(
                        r -> r.getVisitDate().toLocalDate(),
                        Collectors.counting()
                ));

        // 3. 排序（从晚到早）+ 限制最多31天
        List<Map.Entry<LocalDate, Long>> sorted = dateCountMap.entrySet().stream()
                .sorted(Map.Entry.<LocalDate, Long>comparingByKey().reversed())
                .limit(31)
                .sorted(Map.Entry.comparingByKey()) // 前端从左到右看，从早到晚排列
                .collect(Collectors.toList());

        // 4. 构造 VO
        List<String> dates = sorted.stream()
                .map(e -> formatDate(e.getKey())) // 4月01日
                .collect(Collectors.toList());
        List<Integer> counts = sorted.stream()
                .map(e -> e.getValue().intValue())
                .collect(Collectors.toList());

        HomeBfrtjRespVO vo = new HomeBfrtjRespVO();
        vo.setDates(dates);
        vo.setCounts(counts);
        return vo;
    }

    // 工具方法：格式化为 4月01日
    private String formatDate(LocalDate date) {
        return date.getMonthValue() + "月" + String.format("%02d", date.getDayOfMonth()) + "日";
    }
}