| 提交 | 用户 | 时间 | ||
| a6de49 | 1 | /** |
| H | 2 | * Copyright (c) 2018 人人开源 All rights reserved. |
| 3 | * | |
| 4 | * https://www.renren.io | |
| 5 | * | |
| 6 | * 版权所有，侵权必究！ | |
| 7 | */ | |
| 8 | ||
| 9 | package com.iailab.framework.mybatis.interceptor; | |
| 10 | ||
| 11 | import cn.hutool.core.util.StrUtil; | |
| 12 | import com.baomidou.mybatisplus.core.toolkit.PluginUtils; | |
| 13 | import com.baomidou.mybatisplus.extension.plugins.inner.InnerInterceptor; | |
| 14 | import net.sf.jsqlparser.JSQLParserException; | |
| 15 | import net.sf.jsqlparser.expression.Expression; | |
| 16 | import net.sf.jsqlparser.expression.StringValue; | |
| 17 | import net.sf.jsqlparser.expression.operators.conditional.AndExpression; | |
| 18 | import net.sf.jsqlparser.parser.CCJSqlParserUtil; | |
| 19 | import net.sf.jsqlparser.statement.select.PlainSelect; | |
| 20 | import net.sf.jsqlparser.statement.select.Select; | |
| 21 | import org.apache.ibatis.executor.Executor; | |
| 22 | import org.apache.ibatis.mapping.BoundSql; | |
| 23 | import org.apache.ibatis.mapping.MappedStatement; | |
| 24 | import org.apache.ibatis.session.ResultHandler; | |
| 25 | import org.apache.ibatis.session.RowBounds; | |
| 26 | ||
| 27 | import java.util.Map; | |
| 28 | ||
| 29 | /** | |
| 30 | * 数据过滤 | |
| 31 | * | |
| 32 | * @author Mark sunlightcs@gmail.com | |
| 33 | */ | |
| 34 | public class DataFilterInterceptor implements InnerInterceptor { | |
| 35 | ||
| 36 | @Override | |
| 37 | public void beforeQuery(Executor executor, MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, BoundSql boundSql) { | |
| 38 | DataScope scope = getDataScope(parameter); | |
| 39 | // 不进行数据过滤 | |
| 40 | if(scope == null || StrUtil.isBlank(scope.getSqlFilter())){ | |
| 41 | return; | |
| 42 | } | |
| 43 | ||
| 44 | // 拼接新SQL | |
| 45 | String buildSql = getSelect(boundSql.getSql(), scope); | |
| 46 | ||
| 47 | // 重写SQL | |
| 48 | PluginUtils.mpBoundSql(boundSql).sql(buildSql); | |
| 49 | } | |
| 50 | ||
| 51 | private DataScope getDataScope(Object parameter){ | |
| 52 | if (parameter == null){ | |
| 53 | return null; | |
| 54 | } | |
| 55 | ||
| 56 | // 判断参数里是否有DataScope对象 | |
| 57 | if (parameter instanceof Map) { | |
| 58 | Map<?, ?> parameterMap = (Map<?, ?>) parameter; | |
| 59 | for (Map.Entry entry : parameterMap.entrySet()) { | |
| 60 | if (entry.getValue() != null && entry.getValue() instanceof DataScope) { | |
| 61 | return (DataScope) entry.getValue(); | |
| 62 | } | |
| 63 | } | |
| 64 | } else if (parameter instanceof DataScope) { | |
| 65 | return (DataScope) parameter; | |
| 66 | } | |
| 67 | ||
| 68 | return null; | |
| 69 | } | |
| 70 | ||
| 71 | private String getSelect(String buildSql, DataScope scope){ | |
| 72 | try { | |
| 73 | Select select = (Select) CCJSqlParserUtil.parse(buildSql); | |
| 74 | PlainSelect plainSelect = (PlainSelect) select.getSelectBody(); | |
| 75 | ||
| 76 | Expression expression = plainSelect.getWhere(); | |
| 77 | if(expression == null){ | |
| 78 | plainSelect.setWhere(new StringValue(scope.getSqlFilter())); | |
| 79 | }else{ | |
| 80 | AndExpression andExpression = new AndExpression(expression, new StringValue(scope.getSqlFilter())); | |
| 81 | plainSelect.setWhere(andExpression); | |
| 82 | } | |
| 83 | ||
| 84 | return select.toString().replaceAll("'", ""); | |
| 85 | }catch (JSQLParserException e){ | |
| 86 | return buildSql; | |
| 87 | } | |
| 88 | } | |
| 89 | } | |
