湖北水库：施工：施工项目导入

shenyijian

2024-06-25 d6b704980cd4a841eb8b58b924adfc99122c80eb

湖北水库：施工：施工项目导入

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/controller/SgProjectInfoController.java

@@ -3,16 +3,22 @@
import cn.gistack.sm.sg.DO.SgProjectInfoDO;
import cn.gistack.sm.sg.DTO.ProjectSearchDTO;
import cn.gistack.sm.sg.VO.SgProjectInfoVO;
import cn.gistack.sm.sg.excel.ProjectExcel;
import cn.gistack.sm.sg.excel.ProjectImport;
import cn.gistack.sm.sg.service.SgProjectInfoService;
import com.baomidou.mybatisplus.core.metadata.IPage;
import io.swagger.annotations.ApiOperation;
import org.springblade.core.boot.ctrl.BladeController;
import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

import java.util.List;
import java.util.Map;
@@ -66,4 +72,14 @@
        Map<String,Long> map = sgProjectInfoService.projectCount(searchDTO);
        return R.data(map);
    }

    /**
     * 导入用户
     */
    @PostMapping("import_project")
    public R importUser(MultipartFile file, Integer isCovered) {
        ProjectImport projectImport = new ProjectImport(sgProjectInfoService, isCovered == 1);
        ExcelUtil.save(file, projectImport, ProjectExcel.class);
        return R.success("操作成功");
    }
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/excel/ProjectExcel.java

New file
@@ -0,0 +1,7 @@
package cn.gistack.sm.sg.excel;

import lombok.Data;

@Data
public class ProjectExcel {
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/excel/ProjectImport.java

New file
@@ -0,0 +1,18 @@
package cn.gistack.sm.sg.excel;

import cn.gistack.sm.sg.service.SgProjectInfoService;
import lombok.RequiredArgsConstructor;
import org.springblade.core.excel.support.ExcelImporter;

import java.util.List;

@RequiredArgsConstructor
public class ProjectImport implements ExcelImporter<ProjectExcel> {
    private final SgProjectInfoService service;
    private final Boolean isCovered;

    @Override
    public void save(List<ProjectExcel> data) {
        service.importProject(data, isCovered);
    }
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/SgProjectInfoService.java

@@ -3,6 +3,7 @@
import cn.gistack.sm.sg.DO.SgProjectInfoDO;
import cn.gistack.sm.sg.DTO.ProjectSearchDTO;
import cn.gistack.sm.sg.VO.SgProjectInfoVO;
import cn.gistack.sm.sg.excel.ProjectExcel;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.IService;

@@ -26,4 +27,6 @@
    List<SgProjectInfoVO> progressList(ProjectSearchDTO searchDTO);

    Map<String, Long> projectCount(ProjectSearchDTO searchDTO);

    void importProject(List<ProjectExcel> data, Boolean isCovered);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProjectInfoServiceImpl.java

@@ -7,6 +7,7 @@
import cn.gistack.sm.sg.DTO.ProjectSearchDTO;
import cn.gistack.sm.sg.VO.SgProjectInfoVO;
import cn.gistack.sm.sg.VO.SgTypeVO;
import cn.gistack.sm.sg.excel.ProjectExcel;
import cn.gistack.sm.sg.mapper.SgProjectInfoMapper;
import cn.gistack.sm.sg.service.SgProjectInfoService;
import com.baomidou.mybatisplus.core.metadata.IPage;
@@ -172,4 +173,9 @@
        map.put("over", (long) over.size());
        return map;
    }

    @Override
    public void importProject(List<ProjectExcel> data, Boolean isCovered) {

    }
}