package com.whyc.controller;
|
|
import com.whyc.config.MyProps;
|
import com.whyc.dto.Response;
|
import com.whyc.pojo.ProjectArchiveManage;
|
import com.whyc.pojo.ProjectManage;
|
import com.whyc.service.ProjectArchiveManageService;
|
import com.whyc.service.ProjectProcessManageService;
|
import com.whyc.util.FileUtils;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import io.swagger.annotations.ApiParam;
|
import org.apache.ibatis.annotations.Delete;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.*;
|
import java.util.*;
|
|
|
/**
|
* 项目管理/项目归档管理、项目过程管理
|
*/
|
@RestController
|
@RequestMapping("projectManage")
|
@Api(tags = "项目管理")
|
public class ProjectManageController {
|
|
@Autowired
|
private MyProps myProps;
|
|
@Autowired
|
private ProjectProcessManageService service;
|
|
|
@Autowired
|
private ProjectArchiveManageService archiveManageService;
|
|
|
@GetMapping("all")
|
@ApiOperation(value = "项目过程管理-查询所有")
|
public Response<List<ProjectManage>> searchAll() {
|
|
return service.searchAll();
|
}
|
|
|
@GetMapping("byCondition")
|
@ApiOperation(notes = "项目过程管理",value = "项目过程管理-条件查询")
|
public Response<List<ProjectManage>> searchByCondition(@ApiParam(value = "申报日期 格式 2021/01/28",required = true) @RequestParam Date proCreatedate,
|
@ApiParam(value = "项目类型",required = true)@RequestParam String proSort,
|
@ApiParam(value = "项目状态",required = true)@RequestParam int proState,
|
@ApiParam(value = "项目编号",required = true)@RequestParam String proNum) {
|
ProjectManage projectManage = new ProjectManage();
|
projectManage.setProCreatedate(proCreatedate);
|
projectManage.setProSort(proSort);
|
projectManage.setProState(proState);
|
projectManage.setProNum(proNum);
|
return service.searchByCondition(projectManage);
|
}
|
|
@PostMapping("add")
|
@ApiOperation(value = "新建项目",notes = "notes中存文件地址用 ; 分隔 {\n" +
|
" \"proNum\": S0900033,\n" +
|
" \"proName\": \"\",\n" +
|
" \"proNameCode\": \"yyyyMMddHHmmss格式字符串\",\n" +
|
" \"proSort\": 0,\n" +
|
" \"proAdmin\": \"张三\",\n" +
|
" \"proTel\": 13800003131,\n" +
|
" \"proCreatedate\": \"2021-03-27 08:18:27\",\n" +
|
" \"proExecutionDate\": \"2021-03-27 08:18:27\",\n" +
|
" \"proExecutionDate1\": \"2021-03-27 08:18:27\",\n" +
|
" \"proPerson\": \"参与人员\",\n" +
|
" \"proFunding\": 0,\n" +
|
" \"proFundingSource\": \"经费来源\",\n" +
|
" \"proContent\": \" \",\n" +
|
" \"proState\": 0,\n" +
|
" \"note\": \"拼接多个文件地址\"\n" +
|
"}")
|
public Response add(@RequestBody ProjectManage projectManage) {
|
|
Response response = service.add(projectManage);
|
return response;
|
}
|
|
/**
|
* 文件存储后地址更新到对应项目编号的地址，一个项目对应多个文件 db_experiment.tb_project_archive_manage
|
* 是否需要将word转pdf/预览文件pdf
|
*
|
* @param file
|
* @return
|
*/
|
@PostMapping("upload")
|
@ApiOperation(notes = "返回文件地址，确认时提交保存到字段", value = "文档材料添加(选择文件)")
|
public Response upload(@RequestParam("file") MultipartFile file) {
|
// 获取原始名字
|
String originalFilename = file.getOriginalFilename();
|
// 获取后缀名
|
// String suffixName = fileName.substring(fileName.lastIndexOf("."));
|
// 文件保存路径、后期考虑按日期或者月份建dir
|
String filePath = myProps.getFilePath();
|
// 文件重命名，防止重复,预览时需要显示原文件名 _ 切割
|
String fileName = filePath + UUID.randomUUID() + "_" + originalFilename;
|
// 文件对象
|
File dest = new File(fileName);
|
// 判断路径是否存在，如果不存在则创建
|
if (!dest.getParentFile().exists()) {
|
dest.getParentFile().mkdirs();
|
}
|
Response<Object> response = new Response<>();
|
HashMap<Object, Object> map = new HashMap<>();
|
try {
|
// 保存到服务器中
|
file.transferTo(dest);
|
map.put("文件类型：", file.getContentType());
|
map.put("原文件名：", originalFilename);
|
map.put("是否为空：", file.isEmpty());
|
Double size = file.getSize() * 0.01 / 1024 / 1024 * 100;
|
String douStr = String.format("%.2f", size);
|
map.put("文件大小：", douStr+" M");
|
map.put("文件地址：",fileName);
|
} catch (Exception e) {
|
e.printStackTrace();
|
return response.setMsg(0, "上传失败");
|
}
|
response.setCode(1);
|
response.setData(map);
|
return response;
|
}
|
|
|
|
@PostMapping("/uploads")
|
@ApiOperation(notes = "返回文件地址，确认时提交保存到字段", value = "文档材料添加(多选)")
|
public Response uploads(MultipartFile[] files) throws IOException {
|
Response<Object> response = new Response<>();
|
if (files.length == 0) {
|
return response.setMsg(0, "请选择要上传的文件");
|
}
|
|
ArrayList<Object> list = new ArrayList<>();
|
for (MultipartFile multipartFile : files) {
|
if (multipartFile.isEmpty()) {
|
return response.setMsg(0, "请选择要上传的文件");
|
}
|
byte[] fileBytes = multipartFile.getBytes();
|
String filePath = myProps.getFilePath();
|
//取得当前上传文件的文件名称
|
String originalFilename = multipartFile.getOriginalFilename();
|
//生成文件名
|
String fileName = UUID.randomUUID() + "_" + originalFilename;
|
|
HashMap<Object, Object> map = new HashMap<>();
|
try {
|
FileUtils.uploadFile(fileBytes, filePath, fileName);
|
} catch (IOException e) {
|
e.printStackTrace();
|
return response.setMsg(0, "上传失败");
|
}
|
map.put("原文件名：", originalFilename);
|
map.put("文件地址：", filePath + fileName);
|
list.add(map);
|
|
}
|
response.setData(list);
|
return response.setMsg(1, "上传成功");
|
}
|
|
|
@GetMapping("/download")
|
@ApiOperation(notes = "需要在地址栏测试",value = "文档材料下载")
|
public Object download(HttpServletResponse response, @RequestParam String filePath,@RequestParam String fileName) {
|
Response<Object> result = new Response<>();
|
File file = new File( filePath);
|
if (file.exists()) {
|
try {
|
fileName= new String(fileName.getBytes("gbk"), "ISO8859-1");
|
} catch (UnsupportedEncodingException e) {
|
e.printStackTrace();
|
}
|
response.setContentType("application/force-download");
|
// 设置强制下载不打开
|
response.addHeader("Content-Disposition", "attachment;fileName=" + fileName);
|
byte[] buffer = new byte[1024];
|
FileInputStream fis = null;
|
BufferedInputStream bis = null;
|
try {
|
fis = new FileInputStream(file);
|
bis = new BufferedInputStream(fis);
|
OutputStream outputStream = response.getOutputStream();
|
int i = bis.read(buffer);
|
while (i != -1) {
|
outputStream.write(buffer, 0, i);
|
i = bis.read(buffer);
|
}
|
return result.setMsg(1,"下载成功");
|
} catch (Exception e) {
|
e.printStackTrace();
|
return result.setMsg(0,"下载失败");
|
} finally {
|
if (bis != null) {
|
try {
|
bis.close();
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
}
|
if (fis != null) {
|
try {
|
fis.close();
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
}
|
return result.setMsg(0,"文件不存在");
|
}
|
|
@DeleteMapping("/delDoc")
|
@ApiOperation(notes = "", value = "文档材料删除")
|
public Response delDocment(@RequestParam String filePath) {
|
Response<Object> response = new Response<>();
|
File file = new File(filePath);
|
try {
|
if (file.exists()) {
|
File absoluteFile = file.getAbsoluteFile();
|
String name = absoluteFile.getName();
|
file.delete();
|
HashMap<Object, Object> map = new HashMap<>();
|
map.put("删除的文件名", name);
|
map.put("删除的文件路径", filePath);
|
response.setData(map);
|
response.setMsg(1, "删除成功");
|
} else {
|
response.setMsg(0, "文件不存在");
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
return response.setMsg(0, "删除失败");
|
}
|
return response;
|
}
|
|
|
@GetMapping("managesState")
|
@ApiOperation(notes = "", value = "项目管理-己确认/未确认阶段查询")
|
public Response<Object> searchManageStateByCondition(@ApiParam(value = "项目编号", required = true) @RequestParam String proNum,
|
@ApiParam(value = "项目名称代码", required = true) @RequestParam String proNameCode) {
|
ProjectManage projectManage = new ProjectManage();
|
projectManage.setProNum(proNum);
|
projectManage.setProNameCode(proNameCode);
|
return service.searchManageStateByCondition(projectManage);
|
}
|
|
|
/**
|
* 项目进度确认 pro_progress,未归档可以修改更新，归档后不能修改
|
* @return
|
*/
|
@PutMapping("updateManageState")
|
@ApiOperation(notes = "项目进度确认1-6 对应 立项-审批-研究-结题-验收-归档",value = "项目管理-未确认阶段更新")
|
public Response updateManageState(@ApiParam(value = "项目编号", required = true) @RequestParam String proNum,
|
@ApiParam(value = "项目名称代码", required = true) @RequestParam String proNameCode,
|
@ApiParam(value = "项目进度确认1-6",required = true)@RequestParam int proProgress,
|
@ApiParam(value = "文档上传保存地址(如果无传空字符串)",required = true)@RequestParam String proFilePath) {
|
ProjectManage projectManage = new ProjectManage();
|
projectManage.setProNum(proNum);
|
projectManage.setProNameCode(proNameCode);
|
projectManage.setProProgress(proProgress);
|
projectManage.setNote(proFilePath);
|
return service.updateManageState(projectManage);
|
}
|
|
|
@GetMapping("searchDoc")
|
@ApiOperation(notes = "项目过程管理-项目管理",value = "文档材料查询")
|
public Response searchDocumentation(@ApiParam(value = "项目编号", required = true) @RequestParam String proNum,
|
@ApiParam(value = "项目名称代码", required = true) @RequestParam String proNameCode){
|
ProjectArchiveManage projectArchiveManage = new ProjectArchiveManage();
|
projectArchiveManage.setProNum(proNum);
|
projectArchiveManage.setProNameCode(proNameCode);
|
return archiveManageService.searchDocumentation(projectArchiveManage);
|
|
}
|
|
@Delete("delDoc")
|
@ApiOperation(notes = "项目过程管理-项目管理-己确认阶段",value = "文档材料删除")
|
public Response delDocumentation(@ApiParam(value = "项目编号", required = true) @RequestParam String proNum,
|
@ApiParam(value = "项目名称代码", required = true) @RequestParam String proNameCode,
|
@ApiParam(value = "文档路径", required = true) @RequestParam String proFilePath){
|
ProjectArchiveManage projectArchiveManage = new ProjectArchiveManage();
|
projectArchiveManage.setProNum(proNum);
|
projectArchiveManage.setProNameCode(proNameCode);
|
projectArchiveManage.setProFilePath(proFilePath);
|
return archiveManageService.delDocumentation(projectArchiveManage);
|
}
|
|
@GetMapping("archiveAll")
|
@ApiOperation(value = "项目归档管理-查询所有")
|
public Response<List<ProjectManage>> searchArchiveAll() {
|
|
return archiveManageService.searchArchiveAll();
|
}
|
@GetMapping("archiveByCondition")
|
@ApiOperation(value = "项目归档管理-条件查询")
|
public Response searchArchiveByCondition(@ApiParam(value = "开始日期 格式 2021/03/27",required = true) @RequestParam Date proExecutionDate,
|
@ApiParam(value = "归档日期 格式 2021/03/27",required = true)@RequestParam Date proArchiveDate,
|
@ApiParam(value = "项目类型",required = true)@RequestParam String proSort,
|
@ApiParam(value = "项目编号",required = true)@RequestParam String proNum) {
|
|
ProjectManage pm = new ProjectManage();
|
pm.setProExecutionDate(proExecutionDate);
|
pm.setProArchiveDate(proArchiveDate);
|
pm.setProSort(proSort);
|
pm.setProNum(proNum);
|
|
return archiveManageService.searchArchiveByCondition(pm);
|
}
|
|
@GetMapping("archiveProjectInfo")
|
@ApiOperation(value = "项目归档管理-项目概况信息")
|
public Response searchArchiveProjectInfo(@ApiParam(value = "项目名称代码", required = true) @RequestParam String proNameCode,
|
@ApiParam(value = "项目编号", required = true) @RequestParam String proNum) {
|
|
ProjectManage pm = new ProjectManage();
|
pm.setProNameCode(proNameCode);
|
pm.setProNum(proNum);
|
|
return archiveManageService.searchArchiveProjectInfo(pm);
|
}
|
|
/**
|
* @param proNameCode
|
* @param proNum
|
* @return 文档格式、文档名称、归档日期、下载路径
|
*/
|
@GetMapping("archiveDocManager")
|
@ApiOperation(value = "项目归档管理-文档管理")
|
public Response searchProjectDocByCondition(@ApiParam(value = "项目名称代码", required = true) @RequestParam String proNameCode,
|
@ApiParam(value = "项目编号", required = true) @RequestParam String proNum) {
|
ProjectArchiveManage pam = new ProjectArchiveManage();
|
pam.setProNum(proNum);
|
pam.setProNameCode(proNameCode);
|
|
return archiveManageService.searchProjectDocByCondition(pam);
|
}
|
|
/**
|
* @param proNameCode
|
* @param proNum
|
* @return 实验名称、上传日期、归档日期 (操作TODO)
|
*/
|
@GetMapping("archiveExperimentData")
|
@ApiOperation(notes = "(操作TODO)",value = "项目归档管理-试验数据")
|
public Response searchArchiveExperimentData(@ApiParam(value = "项目名称代码", required = true) @RequestParam String proNameCode,
|
@ApiParam(value = "项目编号", required = true) @RequestParam String proNum) {
|
ProjectArchiveManage pam = new ProjectArchiveManage();
|
pam.setProNum(proNum);
|
pam.setProNameCode(proNameCode);
|
return archiveManageService.searchArchiveExperimentData(pam);
|
}
|
|
@GetMapping("archiveTechnologicalAchievements")
|
@ApiOperation(notes = "(操作TODO)", value = "项目归档管理-科技成果")
|
public Response searchArchiveTechnologicalAchievements(@ApiParam(value = "项目名称代码", required = true) @RequestParam String proNameCode,
|
@ApiParam(value = "项目编号", required = true) @RequestParam String proNum) {
|
ProjectArchiveManage pam = new ProjectArchiveManage();
|
pam.setProNum(proNum);
|
pam.setProNameCode(proNameCode);
|
return archiveManageService.searchArchiveTechnologicalAchievements(pam);
|
}
|
|
|
|
|
|
|
|
}
|
