package org.jeecg.modules.system.controller; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.extern.slf4j.Slf4j; import org.apache.shiro.SecurityUtils; import org.jeecg.common.api.dto.DataLogDTO; import org.jeecg.common.api.vo.Result; import org.jeecg.common.constant.CommonConstant; import org.jeecg.common.system.api.ISysBaseAPI; import org.jeecg.common.system.base.controller.JeecgController; import org.jeecg.common.system.query.QueryGenerator; import org.jeecg.common.system.vo.LoginUser; import org.jeecg.modules.system.entity.SysComment; import org.jeecg.modules.system.service.ISysCommentService; import org.jeecg.modules.system.vo.SysCommentFileVo; import org.jeecg.modules.system.vo.SysCommentVO; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.web.bind.annotation.*; import org.springframework.web.servlet.ModelAndView; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.Arrays; import java.util.List; /** * @Description: 系统评论回复表 * @Author: jeecg-boot * @Date: 2022-07-19 * @Version: V1.0 */ @Api(tags = "系统评论回复表") @RestController @RequestMapping("/sys/comment") @Slf4j public class SysCommentController extends JeecgController { @Autowired private ISysCommentService sysCommentService; @Autowired private ISysBaseAPI sysBaseAPI; /** * 在线预览文件地址 */ @Value("${jeecg.file-view-domain}/onlinePreview") private String onlinePreviewDomain; /** * 查询评论+文件 * * @param sysComment * @return */ @ApiOperation(value = "系统评论回复表-列表查询", notes = "系统评论回复表-列表查询") @GetMapping(value = "/listByForm") public Result> queryListByForm(SysComment sysComment) { List list = sysCommentService.queryFormCommentInfo(sysComment); IPage pageList = new Page(); pageList.setRecords(list); return Result.OK(pageList); } /** * 查询文件 * * @param sysComment * @return */ @ApiOperation(value = "系统评论回复表-列表查询", notes = "系统评论回复表-列表查询") @GetMapping(value = "/fileList") public Result> queryFileList(SysComment sysComment) { List list = sysCommentService.queryFormFileList(sysComment.getTableName(), sysComment.getTableDataId()); IPage pageList = new Page(); pageList.setRecords(list); return Result.OK(pageList); } @ApiOperation(value = "系统评论表-添加文本", notes = "系统评论表-添加文本") @PostMapping(value = "/addText") public Result addText(@RequestBody SysComment sysComment) { String commentId = sysCommentService.saveOne(sysComment); return Result.OK(commentId); } @ApiOperation(value = "系统评论表-添加文件", notes = "系统评论表-添加文件") @PostMapping(value = "/addFile") public Result addFile(HttpServletRequest request) { try { sysCommentService.saveOneFileComment(request); return Result.OK("success"); } catch (Exception e) { log.error("评论文件上传失败:{}", e.getMessage()); return Result.error("操作失败," + e.getMessage()); } } @ApiOperation(value = "系统评论回复表-通过id删除", notes = "系统评论回复表-通过id删除") @DeleteMapping(value = "/deleteOne") public Result deleteOne(@RequestParam(name = "id", required = true) String id) { SysComment comment = sysCommentService.getById(id); if(comment==null){ return Result.error("该评论已被删除!"); } LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal(); String username = sysUser.getUsername(); String admin = "admin"; //除了admin外 其他人只能删除自己的评论 if((!admin.equals(username)) && !username.equals(comment.getCreateBy())){ return Result.error("只能删除自己的评论!"); } sysCommentService.deleteOne(id); //删除评论添加日志 String logContent = "删除了评论, "+ comment.getCommentContent(); DataLogDTO dataLog = new DataLogDTO(comment.getTableName(), comment.getTableDataId(), logContent, CommonConstant.DATA_LOG_TYPE_COMMENT); sysBaseAPI.saveDataLog(dataLog); return Result.OK("删除成功!"); } /** * 获取文件预览的地址 * @return */ @GetMapping(value = "/getFileViewDomain") public Result getFileViewDomain() { return Result.OK(onlinePreviewDomain); } /** * 分页列表查询 * * @param sysComment * @param pageNo * @param pageSize * @param req * @return */ //@AutoLog(value = "系统评论回复表-分页列表查询") @ApiOperation(value = "系统评论回复表-分页列表查询", notes = "系统评论回复表-分页列表查询") @GetMapping(value = "/list") public Result> queryPageList(SysComment sysComment, @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, HttpServletRequest req) { QueryWrapper queryWrapper = QueryGenerator.initQueryWrapper(sysComment, req.getParameterMap()); Page page = new Page(pageNo, pageSize); IPage pageList = sysCommentService.page(page, queryWrapper); return Result.OK(pageList); } /** * 添加 * * @param sysComment * @return */ @ApiOperation(value = "系统评论回复表-添加", notes = "系统评论回复表-添加") //@RequiresPermissions("org.jeecg.modules.demo:sys_comment:add") @PostMapping(value = "/add") public Result add(@RequestBody SysComment sysComment) { sysCommentService.save(sysComment); return Result.OK("添加成功!"); } /** * 编辑 * * @param sysComment * @return */ //@AutoLog(value = "系统评论回复表-编辑") @ApiOperation(value = "系统评论回复表-编辑", notes = "系统评论回复表-编辑") //@RequiresPermissions("org.jeecg.modules.demo:sys_comment:edit") @RequestMapping(value = "/edit", method = {RequestMethod.PUT, RequestMethod.POST}) public Result edit(@RequestBody SysComment sysComment) { sysCommentService.updateById(sysComment); return Result.OK("编辑成功!"); } /** * 通过id删除 * * @param id * @return */ //@AutoLog(value = "系统评论回复表-通过id删除") @ApiOperation(value = "系统评论回复表-通过id删除", notes = "系统评论回复表-通过id删除") //@RequiresPermissions("org.jeecg.modules.demo:sys_comment:delete") @DeleteMapping(value = "/delete") public Result delete(@RequestParam(name = "id", required = true) String id) { sysCommentService.removeById(id); return Result.OK("删除成功!"); } /** * 批量删除 * * @param ids * @return */ //@AutoLog(value = "系统评论回复表-批量删除") @ApiOperation(value = "系统评论回复表-批量删除", notes = "系统评论回复表-批量删除") //@RequiresPermissions("org.jeecg.modules.demo:sys_comment:deleteBatch") @DeleteMapping(value = "/deleteBatch") public Result deleteBatch(@RequestParam(name = "ids", required = true) String ids) { this.sysCommentService.removeByIds(Arrays.asList(ids.split(","))); return Result.OK("批量删除成功!"); } /** * 通过id查询 * * @param id * @return */ //@AutoLog(value = "系统评论回复表-通过id查询") @ApiOperation(value = "系统评论回复表-通过id查询", notes = "系统评论回复表-通过id查询") @GetMapping(value = "/queryById") public Result queryById(@RequestParam(name = "id", required = true) String id) { SysComment sysComment = sysCommentService.getById(id); if (sysComment == null) { return Result.error("未找到对应数据"); } return Result.OK(sysComment); } /** * 导出excel * * @param request * @param sysComment */ //@RequiresPermissions("org.jeecg.modules.demo:sys_comment:exportXls") @RequestMapping(value = "/exportXls") public ModelAndView exportXls(HttpServletRequest request, SysComment sysComment) { return super.exportXls(request, sysComment, SysComment.class, "系统评论回复表"); } /** * 通过excel导入数据 * * @param request * @param response * @return */ //@RequiresPermissions("sys_comment:importExcel") @RequestMapping(value = "/importExcel", method = RequestMethod.POST) public Result importExcel(HttpServletRequest request, HttpServletResponse response) { return super.importExcel(request, response, SysComment.class); } }