package com.luohuo.basic.database.mybatis.conditions.query;

import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.conditions.AbstractWrapper;
import com.baomidou.mybatisplus.core.conditions.SharedString;
import com.baomidou.mybatisplus.core.conditions.query.Query;
import com.baomidou.mybatisplus.core.conditions.segments.MergeSegments;
import com.baomidou.mybatisplus.core.exceptions.MybatisPlusException;
import com.baomidou.mybatisplus.core.metadata.TableFieldInfo;
import com.baomidou.mybatisplus.core.metadata.TableInfoHelper;
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
import com.baomidou.mybatisplus.core.toolkit.StringPool;
import com.baomidou.mybatisplus.core.toolkit.sql.SqlInjectionUtils;
import com.luohuo.basic.utils.StrHelper;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.util.Collection;
import java.util.List;
import java.util.Map;
import java.util.concurrent.atomic.AtomicInteger;
import java.util.function.BiFunction;
import java.util.function.Consumer;
import java.util.function.Predicate;

import static com.baomidou.mybatisplus.core.enums.WrapperKeyword.APPLY;
import static com.luohuo.basic.database.mybatis.conditions.Wraps.replace;

/**
 * Entity 对象封装操作类
 * <p>
 * 相比 QueryWrapper 的增强如下：
 * 1，new QueryWrapper(T entity)时， 对entity 中的string字段 %和_ 符号进行转义，便于模糊查询
 * 2，对like方法的参数 %和_ 符号进行转义，便于模糊查询
 * 3，对nested、eq、ne、gt、ge、lt、le、in、like 等方法 进行条件判断，null 或 "" 字段不加入查询
 * 4，增加 leFooter 方法， 将日期参数值，强制转换成当天 23：59：59
 * 5，增加 geHeader 方法， 将日期参数值，强制转换成当天 00：00：00
 *
 * @author hubin miemie HCL
 * @since 2018-05-25
 */
@SuppressWarnings("serial")
public class QueryWrap<T> extends AbstractWrapper<T, String, QueryWrap<T>>
        implements Query<QueryWrap<T>, T, String> {
    private boolean skipEmpty = true;
    /**
     * 查询字段
     */
    private SharedString sqlSelect = new SharedString();

    /**
     * 检查 SQL 注入过滤
     */
    private boolean checkSqlInjection;

    public QueryWrap(T entity) {
        super.setEntity(entity);
        super.initNeed();
        //覆盖之前的entity
        if (entity != null) {
            super.setEntity(replace(BeanUtil.toBean(entity, getEntityClass())));
        }
    }

    public QueryWrap() {
        this((T) null);
    }

    public QueryWrap(T entity, String... columns) {
        super.setEntity(entity);
        super.initNeed();
        this.select(columns);
        //覆盖之前的entity
        if (entity != null) {
            super.setEntity(replace(BeanUtil.toBean(entity, getEntityClass())));
        }
    }

    public QueryWrap(Class<T> entityClass) {
        super.setEntityClass(entityClass);
        super.initNeed();
    }

    /**
     * 非对外公开的构造方法,只用于生产嵌套 sql
     *
     * @param entityClass 本不应该需要的
     */
    private QueryWrap(T entity, Class<T> entityClass, AtomicInteger paramNameSeq,
                      Map<String, Object> paramNameValuePairs, MergeSegments mergeSegments, SharedString paramAlias,
                      SharedString lastSql, SharedString sqlComment, SharedString sqlFirst) {
        super.setEntity(entity);
        super.setEntityClass(entityClass);
        this.paramNameSeq = paramNameSeq;
        this.paramNameValuePairs = paramNameValuePairs;
        this.expression = mergeSegments;
        this.paramAlias = paramAlias;
        this.lastSql = lastSql;
        this.sqlComment = sqlComment;
        this.sqlFirst = sqlFirst;
    }

    /**
     * 开启检查 SQL 注入
     */
    public QueryWrap<T> checkSqlInjection() {
        this.checkSqlInjection = true;
        return this;
    }

    @Override
    protected String columnToString(String column) {
        if (checkSqlInjection && SqlInjectionUtils.check(column)) {
            throw new MybatisPlusException("Discovering SQL injection column: " + column);
        }
        return column;
    }

    @Override
    public QueryWrap<T> select(boolean condition, List<String> columns) {
        if (condition && CollectionUtils.isNotEmpty(columns)) {
            this.sqlSelect.setStringValue(String.join(StringPool.COMMA, columns));
        }
        return typedThis;
    }

    @Override
    public QueryWrap<T> select(Class<T> entityClass, Predicate<TableFieldInfo> predicate) {
        super.setEntityClass(entityClass);
        this.sqlSelect.setStringValue(TableInfoHelper.getTableInfo(getEntityClass()).chooseSelect(predicate));
        return typedThis;
    }

    @Override
    public String getSqlSelect() {
        return sqlSelect.getStringValue();
    }

    /**
     * 返回一个支持 lambda 函数写法的 wrapper
     */
    public LbQueryWrap<T> lambda() {
        return new LbQueryWrap<>(getEntity(), getEntityClass(), sqlSelect, paramNameSeq, paramNameValuePairs,
                expression, paramAlias, lastSql, sqlComment, sqlFirst);
    }

    /**
     * 用于生成嵌套 sql
     * <p>
     * 故 sqlSelect 不向下传递
     * </p>
     */
    @Override
    protected QueryWrap<T> instance() {
        return new QueryWrap<>(getEntity(), getEntityClass(), paramNameSeq, paramNameValuePairs, new MergeSegments(),
                paramAlias, SharedString.emptyString(), SharedString.emptyString(), SharedString.emptyString());
    }

    @Override
    public void clear() {
        super.clear();
        sqlSelect.toNull();
    }

    @Override
    public QueryWrap<T> nested(Consumer<QueryWrap<T>> consumer) {
        final QueryWrap<T> instance = instance();
        consumer.accept(instance);
        if (!instance.isEmptyOfWhere()) {
            appendSqlSegments(APPLY, instance);
        }
        return this;
    }

    @Override
    public QueryWrap<T> eq(String column, Object val) {
        return super.eq(this.checkCondition(val), column, val);
    }

    @Override
    public QueryWrap<T> ne(String column, Object val) {
        return super.ne(this.checkCondition(val), column, val);
    }

    @Override
    public QueryWrap<T> gt(String column, Object val) {
        return super.gt(this.checkCondition(val), column, val);
    }

    @Override
    public QueryWrap<T> ge(String column, Object val) {
        return super.ge(this.checkCondition(val), column, val);
    }

    public QueryWrap<T> geHeader(String column, LocalDateTime val) {
        if (val != null) {
            val = LocalDateTime.of(val.toLocalDate(), LocalTime.MIN);
        }
        return super.ge(this.checkCondition(val), column, val);
    }

    public QueryWrap<T> geHeader(String column, LocalDate val) {
        LocalDateTime dateTime = val != null ? LocalDateTime.of(val, LocalTime.MIN) : null;
        return super.ge(this.checkCondition(val), column, dateTime);
    }


    @Override
    public QueryWrap<T> lt(String column, Object val) {
        return super.lt(this.checkCondition(val), column, val);
    }

    @Override
    public QueryWrap<T> le(String column, Object val) {
        return super.le(this.checkCondition(val), column, val);
    }

    public QueryWrap<T> leFooter(String column, LocalDateTime val) {
        if (val != null) {
            val = LocalDateTime.of(val.toLocalDate(), LocalTime.MAX);
        }
        return super.le(this.checkCondition(val), column, val);
    }

    public QueryWrap<T> leFooter(String column, LocalDate val) {
        LocalDateTime dateTime = null;
        if (val != null) {
            dateTime = LocalDateTime.of(val, LocalTime.MAX);
        }
        return super.le(this.checkCondition(val), column, dateTime);
    }

    @Override
    public QueryWrap<T> between(String column, Object val1, Object val2) {
        return super.between(val1 != null && val2 != null, column, val1, val2);
    }

    @Override
    public QueryWrap<T> notBetween(String column, Object val1, Object val2) {
        return super.notBetween(val1 != null && val2 != null, column, val1, val2);
    }

    @Override
    public QueryWrap<T> like(String column, Object val) {
        return super.like(this.checkCondition(val), column, StrHelper.keywordConvert(val));
    }

    @Override
    public QueryWrap<T> notLike(String column, Object val) {
        return super.notLike(this.checkCondition(val), column, StrHelper.keywordConvert(val));
    }

    @Override
    public QueryWrap<T> likeLeft(String column, Object val) {
        return super.likeLeft(this.checkCondition(val), column, StrHelper.keywordConvert(val));
    }

    @Override
    public QueryWrap<T> likeRight(String column, Object val) {
        return super.likeRight(this.checkCondition(val), column, StrHelper.keywordConvert(val));
    }

    @Override
    public QueryWrap<T> in(String column, Collection<?> coll) {
        return super.in(coll != null && !coll.isEmpty(), column, coll);
    }

    @Override
    public QueryWrap<T> in(String column, Object... values) {
        return super.in(values != null && values.length > 0, column, values);
    }


    //----------------以下为自定义方法---------

    /**
     * 取消跳过空的字符串  不允许跳过空的字符串
     *
     * @return 自己
     */
    public QueryWrap<T> cancelSkipEmpty() {
        this.skipEmpty = false;
        return this;
    }

    /**
     * 空值校验
     * 传入空字符串("")时， 视为： 字段名 = ""
     *
     * @param val 参数值
     */
    private boolean checkCondition(Object val) {
        if (val instanceof String && this.skipEmpty) {
            return StrUtil.isNotBlank((String) val);
        }
        if (val instanceof Collection<?> coll && this.skipEmpty) {
            return !coll.isEmpty();
        }
        return val != null;
    }

    /**
     * 忽略实体中的某些字段，实体中的字段默认是会除了null以外的全部进行等值匹配
     * 再次可以进行忽略
     *
     * @param setColumn 这个是传入的待忽略字段的set方法
     * @return 自己
     */
    public <A> QueryWrap<T> ignore(BiFunction<T, A, ?> setColumn) {
        setColumn.apply(this.getEntity(), null);
        return this;
    }
}
