FEBS-Shiro 查询框模糊匹配
最终效果
页面代码
<form class="layui-form layui-table-form" lay-filter="user-table-form">
<div class="layui-row">
<div class="layui-col-md10">
<div class="layui-form-item">
<div class="layui-inline">
<label class="layui-form-label layui-form-label-sm">项目名称</label>
<div class="layui-input-inline">
<input type="text" name="projectName" autocomplete="off"
class="layui-input">
</div>
</div>
</div>
</div>
<div class="layui-col-md2 layui-col-sm12 layui-col-xs12 table-action-area">
<div class="layui-btn layui-btn-sm layui-btn-primary table-action" id="query">
<i class="layui-icon"></i>
</div>
<div class="layui-btn layui-btn-sm layui-btn-primary table-action" id="reset">
<i class="layui-icon"></i>
</div>
<div class="layui-btn layui-btn-sm layui-btn-primary table-action action-more">
<i class="layui-icon"></i>
</div>
</div>
</div>
</form>
<table lay-filter="projectTable" lay-data="{id: 'projectTable'}"></table>
触发查询的js代码
var $ = layui.jquery,
form = layui.form,
$view = $('#febs-project'),
$searchForm = $view.find('form'),
$view = $('#febs-project'),
$query = $view.find('#query');
// 初始化table
tableIns = febs.table.init({
elem: $view.find('table'),
id: 'projectTable',
url: ctx + 'project/list',
cols: [[
{type: 'checkbox'},
{field: 'projectName', title: '项目名称', minWidth: 100},
{field: 'alias', title: '代号', minWidth: 100},
{field: 'type', title: '类型', templet: '#project-type'},
{field: 'progress', title: '进度', minWidth: 100},
{field: 'plannedWorkHour', title: '计划总工时', minWidth: 100},
{field: 'headName', title: '负责人', minWidth: 100},
{title: '操作', toolbar: '#project-option', minWidth: 140}
]]
});
$query.on('click', function () {
var params = $.extend(getQueryParams(), {});
tableIns.reload({where: params, page: {curr: 1}});
});
mybatis mapper sql
数据库基于sqlserver
SELECT
p.*,u.USERNAME headName
FROM
project p left join t_user u on p.head_id = u.USER_ID
where
1=1
<if test="project.projectName != null and project.projectName != ''">
AND p.project_name like '%'+#{project.projectName}+'%'
</if>
