list转树状结构通用工具类

package com.lnsoft.sdth.ems.cfs.service.impl; import cn.hutool.core.bean.BeanUtil; import cn.hutool.core.util.RandomUtil; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.github.pagehelper.PageHelper; import com.lnsoft.mmbdf.service.commons.utils.StringUtil; import com.lnsoft.sdth.base.base.RespObject; import com.lnsoft.sdth.base.base.auth.AuthUtil; import com.lnsoft.sdth.base.base.utils.PdfUtils; import com.lnsoft.sdth.base.db.edb.entity.*; import com.lnsoft.sdth.base.db.edb.mapper.EdbEnterpriseAppraiseInfoMapper; import com.lnsoft.sdth.base.db.edb.mapper.EdbEnterpriseInfoMapper; import com.lnsoft.sdth.base.db.edb.query.PmTransferProjectDetailQuery; import com.lnsoft.sdth.base.db.edb.service.impl.ExportDataServiceImpl; import com.lnsoft.sdth.base.db.sas.isa.query.CoreInfoQuery; import com.lnsoft.sdth.base.db.utils.CommonUtil; import com.lnsoft.sdth.base.db.utils.DataGrid; import com.lnsoft.sdth.base.db.utils.DateUtil; import com.lnsoft.sdth.base.db.utils.PageHelperUtil; import com.lnsoft.sdth.ems.cfs.dto.*; import com.lnsoft.sdth.ems.cfs.mapper.*; import com.lnsoft.sdth.ems.cfs.query.*; import com.lnsoft.sdth.ems.cfs.service.CfEnterpriseCreditReportMainService; import com.lnsoft.sdth.ems.cfs.util.BeforeQueryUtil; import com.lnsoft.sdth.ems.cfs.util.EnergyColorEnum; import com.lnsoft.sdth.ems.cfs.util.ReportLabelEnum; import com.lnsoft.sdth.ems.pm.service.PmTransferProjectDetailService; import org.apache.http.client.UserTokenHandler; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.ByteArrayOutputStream; import java.io.IOException; import java.io.OutputStream; import java.net.URLEncoder; import java.util.*; /** * 企业碳征信报告主表 * * @Author wql * @Date 2024/2/15 9:39 */ @Service public class CfEnterpriseCreditReportMainServiceImpl implements CfEnterpriseCreditReportMainService { /** * 企业碳征信报告主表 */ @Autowired private CfEnterpriseCreditReportMainMapper cfEnterpriseCreditReportMainMapper; /** * excel列表导出 */ @Autowired private ExportDataServiceImpl exportDataService; /** * 企业信息查询 */ @Autowired private EdbEnterpriseInfoMapper edbEnterpriseInfoMapper; /** * 企业碳征信报告减碳项目 */ @Autowired private CfEnterpriseCreditReportProjectMapper cfEnterpriseCreditReportProjectMapper; /** * 企业金融服务申请 */ @Autowired private CfEnterpriseFinanceApplyMapper cfEnterpriseFinanceApplyMapper; /** * 企业碳征信报告碳金融申请记录 */ @Autowired private CfEnterpriseCreditReportApplyMapper cfEnterpriseCreditReportApplyMapper; /** * 企业碳征信报告企业标签与释义 */ @Autowired private CfEnterpriseCreditReportLabelMapper cfEnterpriseCreditReportLabelMapper; /** * 企业碳征信报告风险防范预警 */ @Autowired private CfEnterpriseCreditReportWarningMapper cfEnterpriseCreditReportWarningMapper; /** * 技改项目详情服务接口层 */ @Resource private PmTransferProjectDetailService pmTransferProjectDetailService; @Autowired private CfEnterpriseEnergyColorMapper cfEnterpriseEnergyColorMapper; @Autowired private CfEnterpriseEnergyLevelMapper cfEnterpriseEnergyLevelMapper; @Autowired private EdbEnterpriseAppraiseInfoMapper edbEnterpriseAppraiseInfoMapper; @Autowired private CfEnterpriseCreditReportLabelDetailMapper cfEnterpriseCreditReportLabelDetailMapper; @Autowired private CfEnterpriseWarningMapper cfEnterpriseWarningMapper; @Autowired private CfFactoryProcessEnergyMapper cfFactoryProcessEnergyMapper; /** * 通过ID查询单条数据 * * @param id 主键 * @return 实例对象 */ public CfEnterpriseCreditReportMain queryById(Long id) { CfEnterpriseCreditReportMain enterpriseCreditReportMain = cfEnterpriseCreditReportMainMapper.selectById(id); enterpriseCreditReportMain.setQueryTime(new Date()); //企业标识与释义 CfEnterpriseCreditReportLabel cfEnterpriseCreditReportLabel = new CfEnterpriseCreditReportLabel(); cfEnterpriseCreditReportLabel.setReportId(id); List<CfEnterpriseCreditReportLabel> enterpriseCreditReportLabelList = cfEnterpriseCreditReportLabelMapper.queryCfEnterpriseCreditReportLabelList(id); for (CfEnterpriseCreditReportLabel enterpriseCreditReportLabel : enterpriseCreditReportLabelList) { List<CfEnterpriseCreditReportLabelDetail> detailList = cfEnterpriseCreditReportLabelDetailMapper.queryCfEnterpriseCreditReportLabelDetailList(id, enterpriseCreditReportLabel.getLabelType()); enterpriseCreditReportLabel.setLabelDetailList(detailList); if (enterpriseCreditReportLabel.getLabelType().equals(ReportLabelEnum.QYBS.getCode())) { enterpriseCreditReportMain.setQybsEntity(enterpriseCreditReportLabel); } else if (enterpriseCreditReportLabel.getLabelType().equals(ReportLabelEnum.QYPJ.getCode())) { enterpriseCreditReportMain.setQypjEntity(enterpriseCreditReportLabel); } else if (enterpriseCreditReportLabel.getLabelType().equals(ReportLabelEnum.QYXY.getCode())) { enterpriseCreditReportMain.setQyxyEntity(enterpriseCreditReportLabel); } } //碳金融减碳项目 List<CfEnterpriseCreditReportProject> enterpriseCreditReportProjectList = cfEnterpriseCreditReportProjectMapper.queryCfEnterpriseCreditReportProjectList(id); if (enterpriseCreditReportProjectList != null && enterpriseCreditReportProjectList.size() > 0) { enterpriseCreditReportMain.setEnterpriseCreditReportProjectList(enterpriseCreditReportProjectList); } //碳金融申请记录 List<CfEnterpriseCreditReportApply> enterpriseCreditReportApplyList = cfEnterpriseCreditReportApplyMapper.queryCfEnterpriseCreditReportApplyList(id); if (enterpriseCreditReportApplyList != null && enterpriseCreditReportApplyList.size() > 0) { enterpriseCreditReportMain.setEnterpriseCreditReportApplyList(enterpriseCreditReportApplyList); } //风险防范预警 List<CfEnterpriseCreditReportWarning> enterpriseCreditReportWarningList = cfEnterpriseCreditReportWarningMapper.queryCfEnterpriseCreditReportWarningList(id); if (enterpriseCreditReportWarningList != null && enterpriseCreditReportWarningList.size() > 0) { enterpriseCreditReportMain.setEnterpriseCreditReportWarningList(enterpriseCreditReportWarningList); } return enterpriseCreditReportMain; } /** * 企业/发改委/银行查询单条报告 * * @param cfEnterpriseCreditReportMain * @return */ public CfEnterpriseCreditReportMain queryReportDetails(CfEnterpriseCreditReportMainQuery cfEnterpriseCreditReportMain) { if (StringUtil.isEmpty(cfEnterpriseCreditReportMain.getEnterpriseCode())) {//企业用户 String enterpriseCode = AuthUtil.getCurrentEnterpriseCode(); cfEnterpriseCreditReportMain.setEnterpriseCode(enterpriseCode); } List<CfEnterpriseCreditReportMain> cfEnterpriseCreditReportMainList = cfEnterpriseCreditReportMainMapper.queryCfEnterpriseCreditReportMainList(cfEnterpriseCreditReportMain); if (cfEnterpriseCreditReportMainList==null || cfEnt