package com.lf.server.controller.show; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.metadata.OrderItem; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.lf.server.annotation.SysLog; import com.lf.server.controller.all.BaseQueryController; import com.lf.server.entity.all.HttpStatus; import com.lf.server.entity.all.ResponseMsg; import com.lf.server.entity.all.StaticData; import com.lf.server.entity.ctrl.DownloadReqEntity; import com.lf.server.entity.data.DownloadEntity; import com.lf.server.entity.data.MetaEntity; import com.lf.server.entity.data.VerEntity; import com.lf.server.entity.sys.UserEntity; import com.lf.server.helper.*; import com.lf.server.mapper.all.BasicMapper; import com.lf.server.service.all.BaseQueryService; import com.lf.server.service.data.DownloadService; import com.lf.server.service.data.MetaService; import com.lf.server.service.data.VerService; import com.lf.server.service.show.DataLibService; import com.lf.server.service.sys.DownlogService; import com.lf.server.service.sys.TokenService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.File; import java.net.URLDecoder; import java.nio.charset.StandardCharsets; import java.util.*; /** * 资料馆 * @author WWW */ @Api(tags = "综合展示\\资料馆") @RestController @RequestMapping("/dataLib") public class DataLibController extends BaseQueryController { @Autowired MetaService metaService; @Autowired TokenService tokenService; @Autowired DataLibService dataLibService; @Autowired BaseQueryService baseQueryService; @Autowired VerService verService; @SysLog() @ApiOperation(value = "根据目录ID查询版本列表") @ApiImplicitParams({ @ApiImplicitParam(name = "dirid", value = "目录ID", dataType = "Integer", paramType = "query") }) @GetMapping(value = "/selectVerByDirid") public ResponseMsg> selectVerByDirid(Integer dirid) { try { if (null == dirid || dirid < 0) { dirid = 0; } List list = verService.selectByDirid(dirid); if (null == list || list.isEmpty()) { list = verService.selectByDirid(0); } return success(list); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @ApiOperation(value = "分页查询元数据") @ApiImplicitParams({ @ApiImplicitParam(name = "depcode", value = "单位编码", dataType = "String", paramType = "query", example = "00"), @ApiImplicitParam(name = "dirs", value = "目录编码", dataType = "String", paramType = "query", example = "00,01"), @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", example = ""), @ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "Integer", paramType = "query", example = "10"), @ApiImplicitParam(name = "pageIndex", value = "分页数(从1开始)", dataType = "Integer", paramType = "query", example = "1") }) @GetMapping(value = "/selectMetasForPage") public ResponseMsg selectMetasForPage(String depcode, String dirs, String name, Integer pageSize, Integer pageIndex) { try { if (pageSize < 1 || pageIndex < 1) { return fail("每页页数或分页数小于1", null); } dirs = DataLibService.copeCodes(dirs, "dircode"); int count = metaService.selectMetasForCount(depcode, dirs, name); if (count == 0) { return success(0, null); } List rs = metaService.selectMetasForPage(depcode, dirs, name, pageSize, pageSize * (pageIndex - 1)); return success(count, rs); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @ApiOperation(value = "查询表中数据") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "元数据ID", dataType = "Integer", paramType = "query", example = "115"), @ApiImplicitParam(name = "pageIndex", value = "分页数(从1开始)", dataType = "Integer", paramType = "query", example = "1"), @ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "Integer", paramType = "query", example = "10") }) @GetMapping(value = "/selectDbData") public ResponseMsg selectDbData(Integer id, Integer pageIndex, Integer pageSize) { // noinspection AlibabaRemoveCommentedCode try { if (null == id || id < 0) { return fail("元数据ID不能为空或小于0", null); } MetaEntity meta = metaService.selectById(id); if (null == meta || null == meta.getTab() || !meta.getTab().contains(StaticData.POINT)) { return fail("找不到元数据信息", null); } String entity = meta.getTab().substring(meta.getTab().indexOf(".") + 1).replace("_", "").toLowerCase(); BasicMapper baseMapper = ClassHelper.getBasicMapper(entity); if (null == baseMapper) { return null; } QueryWrapper wrapper = new QueryWrapper(); wrapper.eq("parentid", meta.getEventid()); Page page = new Page<>(pageIndex, pageSize); page.addOrder(OrderItem.desc("gid")); IPage paged = baseMapper.selectPage(page, wrapper); return success(paged.getTotal(), paged.getRecords()); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @ApiOperation(value = "请求元数据下载") @ApiImplicitParams({ @ApiImplicitParam(name = "dr", value = "请求下载实体", dataType = "DownloadReqEntity", paramType = "body") }) @ResponseBody @PostMapping(value = "/downloadReq") public ResponseMsg downloadReq(@RequestBody DownloadReqEntity dr, HttpServletRequest req, HttpServletResponse res) { try { if (null == dr || StringHelper.isEmpty(dr.getPwd())) { return fail("密码不能为空"); } if (null == dr.getIds() || dr.getIds().isEmpty()) { return fail("请选择要下载的文件ID"); } if (!DownloadService.decryptPwd(dr)) { return fail("密码解密失败", null); } if (StringHelper.isPwdInvalid(dr.getPwd())) { return fail("密码不符合要求"); } UserEntity ue = tokenService.getCurrentUser(req); String guid = metaService.downloadMeteReq(ue, dr); return success(guid); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @ApiOperation(value = "查询下载文件") @ApiImplicitParams({ @ApiImplicitParam(name = "guid", value = "文件GUID", dataType = "String", paramType = "query"), @ApiImplicitParam(name = "pwd", value = "密码", dataType = "String", paramType = "query") }) @GetMapping(value = "/selectDownloadFile") public ResponseMsg selectDownloadFile(String guid, String pwd) { try { if (StringHelper.isEmpty(guid) || StringHelper.isEmpty(pwd)) { return fail("文件ID和密码不能为空", null); } if (!pwd.endsWith(StaticData.EQ)) { pwd = URLDecoder.decode(pwd, StandardCharsets.UTF_8.name()); } String password = DownloadService.decryptPwd(pwd); if (null == password) { return fail("密码解密失败", null); } DownloadEntity de = downloadService.selectByGuid(guid); if (null == de) { return fail("文件不存在", null); } if (!StringHelper.isNull(de.getPwd()) && !Md5Helper.validatePassword(password, de.getPwd())) { return fail("密码不正确", null); } String filePath = downloadService.getDownloadFilePath(de); File file = new File(filePath); return success(file.exists()); } catch (Exception ex) { return fail(ex, false); } } @SysLog() @ApiOperation(value = "下载文件") @ApiImplicitParams({ @ApiImplicitParam(name = "guid", value = "文件GUID", dataType = "String", paramType = "query"), @ApiImplicitParam(name = "pwd", value = "密码", dataType = "String", paramType = "query") }) @ResponseBody @GetMapping(value = "/downloadFile") @SuppressWarnings("AlibabaRemoveCommentedCode") public void downloadFile(String guid, String pwd, HttpServletRequest req, HttpServletResponse res) { try { /*if (StringHelper.isEmpty(guid) || StringHelper.isEmpty(pwd)) { WebHelper.writeInfo(HttpStatus.BAD_REQUEST, "文件ID和密码不能为空", res); } if (!pwd.endsWith(StaticData.EQ)) { pwd = URLDecoder.decode(pwd, StandardCharsets.UTF_8.name()); } String password = DownloadService.decryptPwd(pwd); if (null == password) { WebHelper.writeInfo(HttpStatus.BAD_REQUEST, "密码解密失败", res); }*/ DownloadEntity de = downloadService.selectByGuid(guid); if (null == de) { WebHelper.writeInfo(HttpStatus.NOT_FOUND, "文件不存在", res); return; } /*if (!StringHelper.isNull(de.getPwd()) && !Md5Helper.validatePassword(password, de.getPwd())) { WebHelper.writeInfo(HttpStatus.UNAUTHORIZED, "密码不正确", res); }*/ UserEntity ue = tokenService.getCurrentUser(req); downlogService.updateInfos(ue, de, req); String filePath = downloadService.getDownloadFilePath(de); WebHelper.download(filePath, de.getName(), res); } catch (Exception ex) { WebHelper.writeInfo(HttpStatus.ERROR, ex.getMessage(), res); } } }