| | |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.lf.server.entity.all.RedisCacheKey; |
| | | import com.lf.server.entity.ctrl.IdNameEntity; |
| | | import com.lf.server.entity.ctrl.TabEntity; |
| | |
| | | import com.lf.server.mapper.all.BaseQueryMapper; |
| | | import com.lf.server.mapper.all.BasicMapper; |
| | | import com.lf.server.mapper.all.GeomBaseMapper; |
| | | import io.netty.resolver.AbstractAddressResolver; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.data.redis.cache.RedisCache; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.HashMap; |
| | |
| | | /** |
| | | * 获取值对象 |
| | | * |
| | | * @param value 值 |
| | | * @param val 值 |
| | | * @return 对象 |
| | | */ |
| | | private Object getObjectVal(String value) { |
| | | if (StringHelper.isInteger(value)) { |
| | | return Long.parseLong(value); |
| | | private Object getObjectVal(String val) { |
| | | if (StringHelper.isInteger(val)) { |
| | | return Long.parseLong(val); |
| | | } |
| | | |
| | | if (StringHelper.isNumeric(value)) { |
| | | return Double.parseDouble(value); |
| | | if (StringHelper.isNumeric(val)) { |
| | | return Double.parseDouble(val); |
| | | } |
| | | |
| | | return value.replace("'", ""); |
| | | return val.replace("'", ""); |
| | | } |
| | | |
| | | /** |
| | |
| | | * @param wrapper QueryWrapper |
| | | * @param field 字段 |
| | | * @param express 表达式 |
| | | * @param value 值 |
| | | * @param val 值 |
| | | */ |
| | | private void addWrapper(QueryWrapper wrapper, String field, String express, Object value) { |
| | | private void addWrapper(QueryWrapper wrapper, String field, String express, Object val) { |
| | | if (StringHelper.isDate(val.toString())){ |
| | | wrapper.apply(String.format("%s %s '%s'", field, express, val)); |
| | | return; |
| | | } |
| | | |
| | | switch (express) { |
| | | case "like": |
| | | wrapper.like(field, value); |
| | | wrapper.like(field, val); |
| | | break; |
| | | case ">": |
| | | wrapper.gt(field, value); |
| | | wrapper.gt(field, val); |
| | | break; |
| | | case ">=": |
| | | wrapper.ge(field, value); |
| | | wrapper.ge(field, val); |
| | | break; |
| | | case "<>": |
| | | case "!=": |
| | | wrapper.ne(field, value); |
| | | wrapper.ne(field, val); |
| | | break; |
| | | case "=": |
| | | wrapper.eq(field, value); |
| | | wrapper.eq(field, val); |
| | | break; |
| | | case "<": |
| | | wrapper.lt(field, value); |
| | | wrapper.lt(field, val); |
| | | break; |
| | | case "<=": |
| | | wrapper.le(field, value); |
| | | wrapper.le(field, val); |
| | | break; |
| | | default: |
| | | break; |