本文實(shí)例為大家分享了bootstrapTable+ajax加載數(shù)據(jù),和refresh更新數(shù)據(jù)兩部分,供大家參考,具體內(nèi)容如下
1.html
<form class="form-horizontal" role="form"> <div class="form-group"> <label for="calendar" class="col-sm-1 control-label">日期</label> <div class="col-sm-3"> <input type="text" id="calendar" class="form-control" value="2018-06-13" class="form-control"> </div> </div> <div class="form-group"> <label for="types" class="col-sm-1 control-label">時(shí)間類(lèi)別</label> <div class="col-sm-3"> <select name="" id="types" class="form-control"> <option value="week">week</option> <option value="month">month</option> <option value="sixmonth">sixmonth</option> </select> </div> </div> </form> <div class="tableDisplay" id="dataTable"> <table class="table table-bordered" width="100%" style="margin-bottom:0px;" data-height="460"> </table> </div>
2.js
<script> //日期時(shí)間格式化20180613 function dateFormat(time){ //time = 2018-06-13; var splitArr = time.split('-'), newStr = splitArr.join(''); return newStr; } $(document).ready(function() { //啟動(dòng)日期插件 $('#calendar').datetimepicker({ language: 'zh-CN', weekStart: 1, todayBtn: 1, autoclose: 1, todayHighlight: 1, startView: 2, minView: 2, forceParse: 0 }); //日期改變時(shí)刷新table; $('#calendar').on('changeDate', function(ev){ $dataTableHot.bootstrapTable('refresh'); }); var type=$("#types option:selected").val(); $("#types").change(function(){ type = $("#types option:selected").val(); $dataTableHot.bootstrapTable('refresh'); }) var $dataTableHot = $("#dataTable table").bootstrapTable({ search: false, pagination: true, pageSize: 15, pageList: [5, 10, 15, 20], showColumns: true, showRefresh: false, locale: "zh-CN", striped: true, toggle:true, ajax:function(request) { $.ajax({ url:"http://127.0.0.1:8080/getdata", type:"GET", dataType:"json", data:{ date:dateFormat($("#calendar").val()), //dateFormat($("#calendar").val()) type:type, value:"hot", order:"asc" }, success:function(data){ request.success({ row : data }); $('#dataTable table').bootstrapTable('load', data); }, error:function(error){ console.log(error); } }) }, columns:[{ field: "projectId", title:"projectId" },{ field: "projectName", title:"projectName" }, { field: "value", title:"value" }] }); }); </script>
3.刷新表格
$dataTableHot.bootstrapTable('refresh);
4.bootstrap-datatimepick日期時(shí)間插件,日期changeDate事件
$("#canlendar").on('changeDate',function(ev){ ... });
5.在最后添加"操作"列,實(shí)現(xiàn)查看"詳情"操作
columns:[..., { title:"操作", events:{ //為按鈕添加事件 "click #details":function(e,value,row,index){ alert("項(xiàng)目名稱(chēng):"+row.projectName); } }, formatter:function(value,row,index){ //把需要?jiǎng)?chuàng)建的按鈕封裝在函數(shù)中 return "<button class='btn btn-default' id="details">詳情</button>" } } ]
聲明:本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí),若有侵權(quán)等問(wèn)題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系,我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com