列表搜索下拉

原生下拉

原生下拉还是有一定好处的，比如超出浏览器展示

                          <object item_name="EZ_CODE" type="select" >编码</object>
            
        

参数说明

配置项	说明	默认值
datatype	下拉框的数据来源	TEXT,JSON,KVSQL,HTTP,JOIN,KVSQLCACHEFOREVER,KVSQLCACHE ,HTTPCACHE,QLEXPRESS,KVSQLCACHE5 ,EZLIST,KVJSONRESULT,CASCADER,KVSQL2TREECACHE,DATAGROUP
data	对应datatype的数据取值参数	yesno(是否),status(禁用启用),delete(已删除未删除),数据字典类型,数据源编码 sql select K,V from table where id=${xx} 或者 url 换行符分割 k:v\n 分割 [{"V":"男","K":"1"},{"V":"女","K":"0"}] 如果是JSON， 键必须是 大写 K V ; 参见data规则：data
style	自定义样式	style="color:red"
valid_rule	jqueryvalidate 规则	{"required": true, "minlength": 2}
valid_msg	jqueryvalidate 提示文案	{"required": true, "minlength": "长度{0}"}
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");
lay_verify	layui原生的验证	required
DATASOURCE	数据源	指定下拉SQL对应的数据源

搜索下拉

layui的搜索下拉

                          <object item_name="EZ_CODE" type="select-search" >编码</object>
            
        

参数说明 (同原生下拉)

多选下拉

使用xmselect实现的多选下拉搜索

                          <object item_name="EZ_CODE" type="xmselect" >编码</object>
            
        

参数说明 （同原生下拉）

树形下拉

使用xmselect实现的多选下拉搜索

                 <object item_name="CATEGORY_ID" data="select CATEGORY_ID ID,PARENT_ID,CATEGORY_NAME NAME from T_BASE_CATEGORY WHERE COMPANY_ID=${COMPANY_ID} and DELETE_FLAG=0 and status=1" datatype="KVSQL2TREECACHE" id="itemId-CATEGORY_ID" strict="false" type="xmselect-tree" radio="true"></object>
            
        

参数说明

配置项	说明	默认值
datatype	KVSQL2TREECACHE 或者 KVSQL2TREE	KVSQL2TREECACHE
data	SQL需要返回 ID,PARENT_ID,NAME 三个参数	select CATEGORY_ID ID,PARENT_ID,CATEGORY_NAME NAME from T_BASE_CATEGORY WHERE COMPANY_ID=${COMPANY_ID} and DELETE_FLAG=0 and status=1
strict	严格父子模式	false
radio	是否单选	false
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");

sql级联下拉

类似于省市区的选择插件,目前只处理一次性读取所有数据的情况

                 <object item_name="CATEGORY_ID" data="select CATEGORY_ID ID,PARENT_ID,CATEGORY_NAME LABEL from T_BASE_CATEGORY WHERE COMPANY_ID=${COMPANY_ID} and DELETE_FLAG=0 and status=1" datatype="KVSQL2TREECACHE" id="itemId-CATEGORY_ID"  type="search-cascadersql" radio="true"></object>
            
        

配置项	说明	默认值
datatype	KVSQL2TREECACHE 或者 KVSQL2TREE	KVSQL2TREECACHE
data	SQL需要返回 ID,PARENT_ID,LABEL 三个参数	select CATEGORY_ID ID,PARENT_ID,CATEGORY_NAME LABEL from T_BASE_CATEGORY WHERE COMPANY_ID=${COMPANY_ID} and DELETE_FLAG=0 and status=1
collapsetags	多选模式下是否折叠Tag	false https://gitee.com/yixiacoco/lay_cascader/
showalllevels	输入框中是否显示选中值的完整路径	true https://gitee.com/yixiacoco/lay_cascader/
radio	是否单选	false
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");