接着上文自定义了新的表格页面,想要根据实际情况定义新的搜索栏目
首先把原先的搜索隐藏,打开/public/assets/js/backend/classification.js,添加这几句代码
commonSearch: false,
visible: false,
showToggle: false,
showColumns: false,
search:false,
showExport: false,
1、打开/application/admin/view/classification/index.html,添加筛选按钮
<div class="searchBox">
<a href="javascript:;" class="btnbox btn btn-success btn-theWeek" url='regional/index'>本周</a>
<a href="javascript:;" class="btnbox btn btn-success btn-lastWeek" url='regional/index'>上周</a>
<input type="text" class="form-control datetimepicker datetimepickerY" name="year" value="{:date('Y')}" id="year" data-index="12" autocomplete="off">
<select id="c-quarter" data-rule="required" class="btnbox form-control selectpicker selectquarter" name="quarter" placeholder="选择">
<option value="">全部季度</option>
<option value="1,6">上半年</option>
<option value="7,12">下半年</option>
<option value="1,3">第一季度</option>
<option value="4,6">第二季度</option>
<option value="7,9">第三季度</option>
<option value="10,12">第四季度</option>
</select>
<select id="c-quarter" data-rule="required" class="btnbox form-control selectpicker selectmonth" name="month" placeholder="选择">
<option value="">全部月份</option>
<option value="1">1月</option>
<option value="2">2月</option>
<option value="3">3月</option>
<option value="4">4月</option>
<option value="5">5月</option>
<option value="6">6月</option>
<option value="7">7月</option>
<option value="8">8月</option>
<option value="9">9月</option>
<option value="10">10月</option>
<option value="11">11月</option>
<option value="12">12月</option>
</select>
</div>
2、返回/public/assets/js/backend/classification.js,获取筛选内容,在index函数里添加获取代码,select框方法为“change"
$(document).on("click", ".btn-theWeek", function () {
console.log('本周')
var options = table.bootstrapTable('getOptions');
options.pageNumber = 1;
options.queryParams = function (params) {
params.ids = 'w'; // 值
console.log(params);
return params;
};
table.bootstrapTable('refresh', {});
return false;
})
获取选择内容
console.log($("input[name='year']").val());
console.log($("select[name='quarter']").val());
3、controller获取数据进行查询,打开/application/admin/controller,添加传递的数据
$month = $this->request->get('month');
以上是自定义搜索栏目的全过程!