package com.qianwen.smartman.modules.system.handler.field.provider;

import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.annotation.DbType;
import org.springframework.stereotype.Component;

@Component
/* loaded from: blade-api.jar:BOOT-INF/classes/org/springblade/modules/system/handler/field/provider/OracleSqlParseProvider.class */
public class OracleSqlParseProvider extends AbstractSqlParseProvider {
    @Override // org.springblade.modules.system.handler.field.provider.AbstractSqlParseProvider
    public Boolean support(DbType dbType) {
        return Boolean.valueOf(DbType.ORACLE.equals(dbType));
    }

    @Override // org.springblade.modules.system.handler.field.provider.AbstractSqlParseProvider
    protected String equalsTemplate() {
        return "JSON_VALUE({}, '$.{}') = {} ";
    }

    @Override // org.springblade.modules.system.handler.field.provider.AbstractSqlParseProvider
    protected String likeTemplate() {
        return "JSON_VALUE({}, '$.{}') LIKE '%{}%' ";
    }

    @Override // org.springblade.modules.system.handler.field.provider.AbstractSqlParseProvider
    protected String dateTemplate() {
        return unixTimestamp("JSON_VALUE({}, '$.{}')") + " BETWEEN " + unixTimestamp("{}") + "AND " + unixTimestamp("{}");
    }

    private String unixTimestamp(String value) {
        return StrUtil.format("(to_date({},'yyyy-mm-dd hh24:mi:ss')-to_date('1970-01-01 08:00:00', 'yyyy-mm-dd hh24:mi:ss')) * 86400000", new Object[]{value});
    }
}