package com.lf.server.controller.sys; import com.lf.server.annotation.SysLog; import com.lf.server.controller.all.BaseController; import com.lf.server.entity.all.ResponseMsg; import com.lf.server.entity.sys.ResEntity; import com.lf.server.entity.sys.UserEntity; import com.lf.server.service.all.PermsService; import com.lf.server.service.all.UploadAttachService; import com.lf.server.service.data.DownloadService; import com.lf.server.service.sys.ResService; 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 org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.List; /** * 资源表 * @author SWS * @date 2022-09.28 */ @Api(tags = "运维管理\\资源管理") @RestController @RequestMapping("/res") public class ResController extends BaseController { @Autowired ResService resService; @Autowired TokenService tokenService; @Autowired PermsService permsService; @Autowired DownloadService downloadService; @Autowired UploadAttachService uploadAttachService; private final static String TAB_NAME = "lf.sys_res"; @SysLog() @ApiOperation(value = "查询记录数") @ApiImplicitParams({ @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", required = false, example = "sys_res") }) @GetMapping({"/selectCount"}) public ResponseMsg selectCount(String name) { try { int count = resService.selectCount(name); return success(count); } catch (Exception ex) { return fail(ex, -1); } } @SysLog() @ApiOperation(value = "分页查询") @ApiImplicitParams({ @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", example = "sys_res"), @ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "Integer", paramType = "query", example = "10"), @ApiImplicitParam(name = "pageIndex", value = "分页数(从1开始)", dataType = "Integer", paramType = "query", example = "1") }) @GetMapping(value = "/selectByPage") public ResponseMsg> selectByPage(String name, Integer pageSize, Integer pageIndex) { try { if (pageSize < 1 || pageIndex < 1) { return fail("每页页数或分页数小于1", null); } List rs = resService.selectByPage(name, pageSize, pageSize * (pageIndex - 1)); return success(rs); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @ApiOperation(value = "分页查询并返回记录数") @ApiImplicitParams({ @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", example = "sys_res"), @ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "Integer", paramType = "query", example = "10"), @ApiImplicitParam(name = "pageIndex", value = "分页数(从1开始)", dataType = "Integer", paramType = "query", example = "1") }) @GetMapping(value = "/selectByPageAndCount") public ResponseMsg> selectByPageAndCount(String name, Integer pageSize, Integer pageIndex) { try { if (pageSize < 1 || pageIndex < 1) { return fail("每页页数或分页数小于1", null); } int count = resService.selectCount(name); if (count == 0) { return success(0, null); } List rs = resService.selectByPage(name, pageSize, pageSize * (pageIndex - 1)); return success(count, rs); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @ApiOperation(value = "根据角色分页查询并返回记录数") @ApiImplicitParams({ @ApiImplicitParam(name = "roleid", value = "角色ID", dataType = "Integer", paramType = "query", example = "1"), @ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "Integer", paramType = "query", example = "10"), @ApiImplicitParam(name = "pageIndex", value = "分页数(从1开始)", dataType = "Integer", paramType = "query", example = "1") }) @GetMapping(value = "/selectByPageForRole") public ResponseMsg> selectByPageForRole(Integer roleid, Integer pageSize, Integer pageIndex) { try { if (pageSize < 1 || pageIndex < 1) { return fail("每页页数或分页数小于1", null); } int count = resService.selectCountForRole(roleid); if (count == 0) { return success(0, null); } List rs = resService.selectByPageForRole(roleid, pageSize, pageSize * (pageIndex - 1)); return success(count, rs); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @ApiOperation(value = "插入一条") @ApiImplicitParams({ @ApiImplicitParam(name = "entity", value = "实体类", dataType = "com.lf.server.entity.sys.ResEntity", paramType = "body", example = "") }) @PostMapping(value = "/insertRes", produces = "application/json; charset=UTF-8") public ResponseMsg insertRes(@RequestBody ResEntity entity, HttpServletRequest req) { try { UserEntity ue = tokenService.getCurrentUser(req); if (ue != null) { entity.setCreateUser(ue.getId()); } int count = resService.insertRes(entity); if (count > 0) { permsService.clearResCache(); } return success(count); } catch (Exception ex) { return fail(ex, -1); } } @SysLog() @ApiOperation(value = "插入多条") @ApiImplicitParams({ @ApiImplicitParam(name = "list", value = "实体类集合", dataType = "List", paramType = "body", example = "") }) @PostMapping(value = "/insertRess", produces = "application/json; charset=UTF-8") public ResponseMsg insertRess(@RequestBody List list, HttpServletRequest req) { try { UserEntity ue = tokenService.getCurrentUser(req); if (ue != null) { for (ResEntity entity : list) { entity.setCreateUser(ue.getId()); } } int count = resService.insertRess(list); if (count > 0) { permsService.clearResCache(); } return success(count); } catch (Exception ex) { return fail(ex, -1); } } @SysLog() @ApiOperation(value = "删除一条") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "ID", dataType = "Integer", paramType = "query", example = "1") }) @GetMapping(value = "/deleteRes") public ResponseMsg deleteRes(int id) { try { int count = resService.deleteRes(id); if (count > 0) { permsService.clearResCache(); } return success(count); } catch (Exception ex) { return fail(ex, -1); } } @SysLog() @ApiOperation(value = "删除多条") @ApiImplicitParams({ @ApiImplicitParam(name = "ids", value = "ID数组", dataType = "List", paramType = "query", example = "1,2") }) @GetMapping(value = "/deleteRess") public ResponseMsg deleteRess(@RequestParam List ids) { try { if (ids == null || ids.isEmpty()) { return fail("id数组不能为空", -1); } int count = resService.deleteRess(ids); if (count > 0) { permsService.clearResCache(); } return success(count); } catch (Exception ex) { return fail(ex, -1); } } @SysLog() @ApiOperation(value = "更新一条") @ApiImplicitParams({ @ApiImplicitParam(name = "entity", value = "实体类", dataType = "ResEntity", paramType = "body", example = "") }) @ResponseBody @PostMapping(value = "/updateRes", produces = "application/json; charset=UTF-8") public ResponseMsg updateRes(@RequestBody ResEntity entity, HttpServletRequest req) { try { UserEntity ue = tokenService.getCurrentUser(req); if (ue != null) { entity.setUpdateUser(ue.getId()); } int count = resService.updateRes(entity); if (count > 0) { permsService.clearResCache(); } return success(count); } catch (Exception ex) { return fail(ex, -1); } } @SysLog() @ApiOperation(value = "根据ID查询") @ApiImplicitParams({ @ApiImplicitParam(name = "id", value = "ID", dataType = "Integer", paramType = "query", example = "1") }) @GetMapping(value = "/selectRes") public ResponseMsg selectRes(int id) { try { ResEntity resEntity = resService.selectRes(id); return success(resEntity); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @ApiOperation(value = "查询所有") @GetMapping(value = "/selectResAll") public ResponseMsg> selectResAll() { try { List list = resService.selectResAll(); return success(list); } catch (Exception ex) { return fail(ex, null); } } @SysLog() @ApiOperation(value = "上传文件") @ResponseBody @PostMapping(value = "/upload") public ResponseMsg upload(@RequestParam("file") MultipartFile file, HttpServletRequest req) { UserEntity ue = tokenService.getCurrentUser(req); return uploadAttachService.upload(ue, TAB_NAME, file, this); } @SysLog() @ApiOperation(value = "下载文件") @ApiImplicitParams({ @ApiImplicitParam(name = "guid", value = "附件Guid", dataType = "String", paramType = "body") }) @GetMapping(value = "/download") public void download(String guid, HttpServletResponse res) { uploadAttachService.download(guid, false, res); } @SysLog() @ApiOperation(value = "查看文件") @ApiImplicitParams({ @ApiImplicitParam(name = "guid", value = "附件Guid", dataType = "String", paramType = "body") }) @GetMapping(value = "/downloadForView") public void downloadForView(String guid, HttpServletResponse res) { uploadAttachService.download(guid, true, res); } }