搜索输入框

普通输入框

SQL生成列表，默认的搜索插件。支持精确，模糊匹配等

            支持大部分原生属性。
                          <object item_name="EZ_CODE" type="input-text" >编码</object>

配置项	说明	默认值
maxlength	最大长度	maxlength=10
style	自定义样式	style="color:red"
valid_rule	jqueryvalidate 规则	{"required": true, "minlength": 2}
valid_msg	jqueryvalidate 提示文案	{"required": true, "minlength": "长度{0}"}
jdbctype	数字靠右展示，时间格式化，小数位保留	NUMBER, NUMBERNULL, DATE_TO_NUMBER, VARCHAR, DATE, DATETIME, CLOB , BODY, NUMBER0, NUMBER1, NUMBER2 , NUMBER3, NUMBER4
oper	sql操作符，不同的操作符，拼接出来的SQL不一样	EQ("=","等于"), NE("!=","不等于"), LTE( "<=","小于等于"), BETWEEN("BETWEEN","区间"), GTE(">=", "大于等于"), LIKE("LIKE","包含"), NOTLIKE("NOT LIKE","不包含"), IN("IN","IN"), NOT_IN("NOT IN","NOT IN"), ALL_FIND_IN_SET("ALL_FIND_IN_SET","ALL_FIND_IN_SET");
alias	表别名，当多个表字段一样时，用别名来区分，同时如果是需要用表达式替换如： ifnull(a.id,0) ,最终的SQL也会使用alias来替换字段名	EQ("=","等于"), NE("!=","不等于"), LTE( "<=","小于等于"), BETWEEN("BETWEEN","区间"), GTE(">=", "大于等于"), LIKE("LIKE","包含"), NOTLIKE("NOT LIKE","不包含"), IN("IN","IN"), ALL_EQ("=","ALL_EQ"), NOT_IN("NOT IN","NOT IN"), ALL_FIND_IN_SET("ALL_FIND_IN_SET","ALL_FIND_IN_SET");
lay_verify	layui原生的验证	required

希望纳入搜索，但是不希望用户看不到参数，也可以用于组合搜索。

            支持大部分原生属性。
                          <object item_name="EZ_CODE" type="hidden" >编码</object>

配置项	说明	默认值
jdbctype	数字靠右展示，时间格式化，小数位保留	NUMBER("NUMBER"), NUMBERNULL("NUMBERNULL"), DATE_TO_NUMBER("DATE_TO_NUMBER"), VARCHAR("VARCHAR"), DATE("DATE"), DATETIME("DATETIME"), CLOB("CLOB") , BODY("BODY"), NUMBER0("NUMBER0"), NUMBER1("NUMBER1") , NUMBER2("NUMBER2") , NUMBER3("NUMBER3") , NUMBER4("NUMBER4")
oper	sql操作符，不同的操作符，拼接出来的SQL不一样	EQ("=","等于"), NE("!=","不等于"), LTE( "<=","小于等于"), BETWEEN("BETWEEN","区间"), GTE(">=", "大于等于"), LIKE("LIKE","包含"), NOTLIKE("NOT LIKE","不包含"), IN("IN","IN"), ALL_EQ("=","ALL_EQ"), NOT_IN("NOT IN","NOT IN"), ALL_FIND_IN_SET("ALL_FIND_IN_SET","ALL_FIND_IN_SET");
alias	表别名，当多个表字段一样时，用别名来区分，同时如果是需要用表达式替换如： ifnull(a.id,0) ,最终的SQL也会使用alias来替换字段名	EQ("=","等于"), NE("!=","不等于"), LTE( "<=","小于等于"), BETWEEN("BETWEEN","区间"), GTE(">=", "大于等于"), LIKE("LIKE","包含"), NOTLIKE("NOT LIKE","不包含"), IN("IN","IN"), ALL_EQ("=","ALL_EQ"), NOT_IN("NOT IN","NOT IN"), ALL_FIND_IN_SET("ALL_FIND_IN_SET","ALL_FIND_IN_SET");

携带参数，代入表达式，但是不自动纳入搜索。场景较少，大部分情况下，可以通过修改别名实现。

                          <object item_name="EZ_CODE" type="hidden-nowhere" >编码</object>