SysOperLogServiceImpl.java 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123
  1. package com.ruoyi.system.service.impl;
  2. import cn.hutool.core.lang.Validator;
  3. import cn.hutool.core.util.ArrayUtil;
  4. import cn.hutool.core.util.StrUtil;
  5. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  6. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  7. import com.ruoyi.common.core.page.TableDataInfo;
  8. import com.ruoyi.common.utils.PageUtils;
  9. import com.ruoyi.system.domain.SysOperLog;
  10. import com.ruoyi.system.mapper.SysOperLogMapper;
  11. import com.ruoyi.system.service.ISysOperLogService;
  12. import org.springframework.stereotype.Service;
  13. import java.util.Arrays;
  14. import java.util.Date;
  15. import java.util.List;
  16. import java.util.Map;
  17. /**
  18. * 操作日志 服务层处理
  19. *
  20. * @author ruoyi
  21. */
  22. @Service
  23. public class SysOperLogServiceImpl extends ServiceImpl<SysOperLogMapper, SysOperLog> implements ISysOperLogService {
  24. @Override
  25. public TableDataInfo<SysOperLog> selectPageOperLogList(SysOperLog operLog) {
  26. Map<String, Object> params = operLog.getParams();
  27. LambdaQueryWrapper<SysOperLog> lqw = new LambdaQueryWrapper<SysOperLog>()
  28. .like(StrUtil.isNotBlank(operLog.getTitle()), SysOperLog::getTitle, operLog.getTitle())
  29. .eq(operLog.getBusinessType() != null && operLog.getBusinessType() > 0,
  30. SysOperLog::getBusinessType, operLog.getBusinessType())
  31. .func(f -> {
  32. if (ArrayUtil.isNotEmpty(operLog.getBusinessTypes())) {
  33. f.in(SysOperLog::getBusinessType, Arrays.asList(operLog.getBusinessTypes()));
  34. }
  35. })
  36. .eq(operLog.getStatus() != null && operLog.getStatus() > 0,
  37. SysOperLog::getStatus, operLog.getStatus())
  38. .like(StrUtil.isNotBlank(operLog.getOperName()), SysOperLog::getOperName, operLog.getOperName())
  39. .apply(Validator.isNotEmpty(params.get("beginTime")),
  40. "date_format(oper_time,'%y%m%d') >= date_format({0},'%y%m%d')",
  41. params.get("beginTime"))
  42. .apply(Validator.isNotEmpty(params.get("endTime")),
  43. "date_format(oper_time,'%y%m%d') <= date_format({0},'%y%m%d')",
  44. params.get("endTime"))
  45. .orderByDesc(SysOperLog::getOperId);
  46. return PageUtils.buildDataInfo(page(PageUtils.buildPage(), lqw));
  47. }
  48. /**
  49. * 新增操作日志
  50. *
  51. * @param operLog 操作日志对象
  52. */
  53. @Override
  54. public void insertOperlog(SysOperLog operLog) {
  55. operLog.setOperTime(new Date());
  56. save(operLog);
  57. }
  58. /**
  59. * 查询系统操作日志集合
  60. *
  61. * @param operLog 操作日志对象
  62. * @return 操作日志集合
  63. */
  64. @Override
  65. public List<SysOperLog> selectOperLogList(SysOperLog operLog) {
  66. Map<String, Object> params = operLog.getParams();
  67. return list(new LambdaQueryWrapper<SysOperLog>()
  68. .like(StrUtil.isNotBlank(operLog.getTitle()),SysOperLog::getTitle,operLog.getTitle())
  69. .eq(operLog.getBusinessType() != null && operLog.getBusinessType() > 0,
  70. SysOperLog::getBusinessType,operLog.getBusinessType())
  71. .func(f -> {
  72. if (ArrayUtil.isNotEmpty(operLog.getBusinessTypes())){
  73. f.in(SysOperLog::getBusinessType, Arrays.asList(operLog.getBusinessTypes()));
  74. }
  75. })
  76. .eq(operLog.getStatus() != null && operLog.getStatus() > 0,
  77. SysOperLog::getStatus,operLog.getStatus())
  78. .like(StrUtil.isNotBlank(operLog.getOperName()),SysOperLog::getOperName,operLog.getOperName())
  79. .apply(Validator.isNotEmpty(params.get("beginTime")),
  80. "date_format(oper_time,'%y%m%d') >= date_format({0},'%y%m%d')",
  81. params.get("beginTime"))
  82. .apply(Validator.isNotEmpty(params.get("endTime")),
  83. "date_format(oper_time,'%y%m%d') <= date_format({0},'%y%m%d')",
  84. params.get("endTime"))
  85. .orderByDesc(SysOperLog::getOperId));
  86. }
  87. /**
  88. * 批量删除系统操作日志
  89. *
  90. * @param operIds 需要删除的操作日志ID
  91. * @return 结果
  92. */
  93. @Override
  94. public int deleteOperLogByIds(Long[] operIds) {
  95. return baseMapper.deleteBatchIds(Arrays.asList(operIds));
  96. }
  97. /**
  98. * 查询操作日志详细
  99. *
  100. * @param operId 操作ID
  101. * @return 操作日志对象
  102. */
  103. @Override
  104. public SysOperLog selectOperLogById(Long operId) {
  105. return getById(operId);
  106. }
  107. /**
  108. * 清空操作日志
  109. */
  110. @Override
  111. public void cleanOperLog() {
  112. remove(new LambdaQueryWrapper<>());
  113. }
  114. }