| commit | author | age | ||
| 9bcb19 | 1 | /* |
| I | 2 | Copyright [2020] [https://www.xiaonuo.vip] |
| 3 | ||
| 4 | Licensed under the Apache License, Version 2.0 (the "License"); | |
| 5 | you may not use this file except in compliance with the License. | |
| 6 | You may obtain a copy of the License at | |
| 7 | ||
| 8 | http://www.apache.org/licenses/LICENSE-2.0 | |
| 9 | ||
| 10 | Unless required by applicable law or agreed to in writing, software | |
| 11 | distributed under the License is distributed on an "AS IS" BASIS, | |
| 12 | WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. | |
| 13 | See the License for the specific language governing permissions and | |
| 14 | limitations under the License. | |
| 15 | ||
| 16 | Snowy采用APACHE LICENSE 2.0开源协议，您在使用过程中，需要注意以下几点： | |
| 17 | ||
| 18 | 1.请不要删除和修改根目录下的LICENSE文件。 | |
| 19 | 2.请不要删除和修改Snowy源码头部的版权声明。 | |
| 20 | 3.请保留源码和相关描述文件的项目出处，作者声明等。 | |
| 21 | 4.分发源码时候，请注明软件出处 https://gitee.com/xiaonuobase/snowy | |
| 22 | 5.在修改包名，模块名称，项目代码等时，请注明软件出处 https://gitee.com/xiaonuobase/snowy | |
| 23 | 6.若您的项目无法满足以上几点，可申请商业授权，获取Snowy商业授权许可，请在官网购买授权，地址为 https://www.xiaonuo.vip | |
| 24 | */ | |
| 25 | package vip.xiaonuo.sys.modular.log.service.impl; | |
| 26 | ||
| 27 | import cn.hutool.core.util.ObjectUtil; | |
| 28 | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; | |
| 29 | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; | |
| 30 | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; | |
| 31 | import org.springframework.stereotype.Service; | |
| 32 | import vip.xiaonuo.core.factory.PageFactory; | |
| 33 | import vip.xiaonuo.core.pojo.page.PageResult; | |
| 34 | import vip.xiaonuo.core.util.PoiUtil; | |
| 35 | import vip.xiaonuo.sys.modular.log.entity.SysVisLog; | |
| 36 | import vip.xiaonuo.sys.modular.log.mapper.SysVisLogMapper; | |
| 37 | import vip.xiaonuo.sys.modular.log.param.SysVisLogParam; | |
| 38 | import vip.xiaonuo.sys.modular.log.service.SysVisLogService; | |
| 39 | ||
| 40 | import java.util.List; | |
| 41 | ||
| 42 | /** | |
| 43 | * 系统访问日志service接口实现类 | |
| 44 | * | |
| 45 | * @author xuyuxiang | |
| 46 | * @date 2020/3/12 14:23 | |
| 47 | */ | |
| 48 | @Service | |
| 49 | public class SysVisLogServiceImpl extends ServiceImpl<SysVisLogMapper, SysVisLog> implements SysVisLogService { | |
| 50 | ||
| 51 | @Override | |
| 52 | public PageResult<SysVisLog> page(SysVisLogParam sysVisLogParam) { | |
| 53 | LambdaQueryWrapper<SysVisLog> queryWrapper = new LambdaQueryWrapper<>(); | |
| 54 | if (ObjectUtil.isNotNull(sysVisLogParam)) { | |
| 55 | //根据名称模糊查询 | |
| 56 | if (ObjectUtil.isNotEmpty(sysVisLogParam.getName())) { | |
| 57 | queryWrapper.like(SysVisLog::getName, sysVisLogParam.getName()); | |
| 58 | } | |
| 59 | //跟据访问类型（字典 1登入 2登出）查询 | |
| 60 | if (ObjectUtil.isNotEmpty(sysVisLogParam.getVisType())) { | |
| 61 | queryWrapper.eq(SysVisLog::getVisType, sysVisLogParam.getVisType()); | |
| 62 | } | |
| 63 | //根据是否成功查询 | |
| 64 | if (ObjectUtil.isNotEmpty(sysVisLogParam.getSuccess())) { | |
| 65 | queryWrapper.eq(SysVisLog::getSuccess, sysVisLogParam.getSuccess()); | |
| 66 | } | |
| 67 | // 根据时间范围查询 | |
| 68 | if (ObjectUtil.isAllNotEmpty(sysVisLogParam.getSearchBeginTime(), sysVisLogParam.getSearchEndTime())) { | |
| 69 | queryWrapper.apply("date_format (vis_time,'%Y-%m-%d') >= date_format('" + sysVisLogParam.getSearchBeginTime() + "','%Y-%m-%d')") | |
| 70 | .apply("date_format (vis_time,'%Y-%m-%d') <= date_format('" + sysVisLogParam.getSearchEndTime() + "','%Y-%m-%d')"); | |
| 71 | } | |
| 72 | } | |
| 73 | //根据访问时间倒序排列 | |
| 74 | queryWrapper.orderByDesc(SysVisLog::getVisTime); | |
| 75 | return new PageResult<>(this.page(PageFactory.defaultPage(), queryWrapper)); | |
| 76 | } | |
| 77 | ||
| 78 | @Override | |
| 79 | public void delete() { | |
| 80 | this.remove(new QueryWrapper<>()); | |
| 81 | } | |
| 82 | ||
| 83 | @Override | |
| 84 | public void export(SysVisLogParam sysVisLogParam) { | |
| 85 | List<SysVisLog> list = this.list(); | |
| 86 | PoiUtil.exportExcelWithStream("SysVisLog.xls", SysVisLog.class, list); | |
| 87 | } | |
| 88 | } | |
