云
2026-10-25 4229657c5b6be8a1da9e59a40e2426cf6b0995c2
yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/salesTarget/CrmSalesTargetController.java
@@ -5,6 +5,9 @@
import cn.iocoder.yudao.framework.common.pojo.PageResult;
import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils;
import cn.iocoder.yudao.module.crm.controller.admin.salesTarget.vo.CrmSalesTargetChangeStatusReqVO;
import cn.iocoder.yudao.module.crm.controller.admin.salesTarget.vo.CrmSalesTargetImportExcelVO;
import cn.iocoder.yudao.module.crm.controller.admin.salesTarget.vo.CrmSalesTargetImportReqVO;
import cn.iocoder.yudao.module.crm.controller.admin.salesTarget.vo.CrmSalesTargetImportRespVO;
import cn.iocoder.yudao.module.crm.controller.admin.salesTarget.vo.CrmSalesTargetPageReqVO;
import cn.iocoder.yudao.module.crm.controller.admin.salesTarget.vo.CrmSalesTargetRespVO;
import cn.iocoder.yudao.module.crm.controller.admin.salesTarget.vo.CrmSalesTargetSaveReqVO;
@@ -21,6 +24,7 @@
import org.springframework.web.bind.annotation.*;
import java.io.IOException;
import java.util.Arrays;
import java.util.List;
import static cn.iocoder.yudao.framework.apilog.core.enums.OperateTypeEnum.EXPORT;
@@ -101,4 +105,26 @@
        return success(salesTargetService.getSalesTargetAnalysis(reqVO));
    }
    @GetMapping("/get-import-template")
    @Operation(summary = "获得导入销售目标模板")
    public void importTemplate(HttpServletResponse response) throws IOException {
        List<CrmSalesTargetImportExcelVO> list = Arrays.asList(
                CrmSalesTargetImportExcelVO.builder().name("示例销售目标")
                        .periodType(null).periodValue("2026-Q1").targetDimension(null)
                        .targetUserName("").targetDeptName("").targetItemCode("")
                        .contractTarget(null).receivableTarget(null).businessTarget(null)
                        .customerTarget(null).contractCountTarget(null).remark("").build()
        );
        ExcelUtils.write(response, "销售目标导入模板.xls", "销售目标列表", CrmSalesTargetImportExcelVO.class, list);
    }
    @PostMapping("/import")
    @Operation(summary = "导入销售目标")
    @PreAuthorize("@ss.hasPermission('crm:sales-target:import')")
    public CommonResult<CrmSalesTargetImportRespVO> importExcel(@Valid CrmSalesTargetImportReqVO importReqVO)
            throws Exception {
        List<CrmSalesTargetImportExcelVO> list = ExcelUtils.read(importReqVO.getFile(), CrmSalesTargetImportExcelVO.class);
        return success(salesTargetService.importSalesTargetList(list, importReqVO));
    }
}