/** * 报修统计报表 * */ var curentPage = 1; //当前的页数 $(function() { $('.tool_bars').authorizeButton(); laydate.render({ elem: '#sc_times', range: '~', theme: '#249fea', }); initTable(); //搜索 $("#sc_btns").click(function() { curentPage = 1; initTable(); }) }); function initTable() { //先销毁表格 $('#table_all').bootstrapTable('destroy'); //初始化表格,动态从服务器加载数据 $('#table_all').bootstrapTable({ method: "get", //使用get请求到服务器获取数据 url: huayi.config.callcenter_url + "equipmentapi/api/RunningRepair/getprojectrepairlistandstatisticsbypage", //获取数据的Servlet地址 contentType: "application/x-www-form-urlencoded", striped: true, //表格显示条纹 pagination: true, //启动分页 pageSize: 10, //每页显示的记录数 pageNumber: curentPage, //当前第几页 pageList: [10, 20, 50, 100], //记录数可选列表 search: false, //是否启用查询 showColumns: false, //显示下拉框勾选要显示的列 showRefresh: false, //显示刷新按钮 sidePagination: "server", //表示服务端请求 //设置为undefined可以获取pageNumber,pageSize,searchText,sortName,sortOrder //设置为limit可以获取limit, offset, search, sort, order queryParamsType: "undefined", queryParams: function queryParams(params) { //设置查询参数 var param = { pageindex: params.pageNumber, pagesize: params.pageSize, start: $('#sc_times').val() && $('#sc_times').val().split(' ~ ')[0], end: $('#sc_times').val() && $('#sc_times').val().split(' ~ ')[1], keyword: $('#sc_keyWords').val(), //关键字 }; return param; }, onPageChange: function(number, size) { curentPage = number; }, onLoadSuccess: function(res) { //加载成功时执行 //layer.msg("加载成功"); if(res.state.toLowerCase() == "success") { var newData = {}; newData.state = res.state; newData.message = res.message; newData.rows = res.data.rows.list; newData.total = res.data.total; $('#table_all').bootstrapTable('load', newData); $('#dailyTotal').text(res.data.rows.dailyedcount);//日常已维修 $('#nodailyTotal').text(res.data.rows.nodailycount);//日常待维修 $('#equedTotal').text(res.data.rows.equedcount);//设备已维修 $('#noequTotal').text(res.data.rows.noequcount);//设备待维修 } //$('.tool_down').authorizeOperateButton(); }, onLoadError: function() { //加载失败时执行 //layer.msg("加载数据失败", { time: 1500, icon: 2 }); } }); } //格式化序号 function setCode(val, row, index) { return ++index; } //导出 function btn_export() { var url = huayi.config.callcenter_url + "ZuoXiWorkTotal/ExptList"; var st = $('#chooseTime').val() && $('#chooseTime').val().split(' ~ ')[0]; var et = $('#chooseTime').val() && $('#chooseTime').val().split(' ~ ')[1]; url += "&stime=" + st + "&endtime=" + et + "&dpt=" + $("#department").val() + "&dayss=" + $("#monthDays").val(); window.location.href = url; }