/** * 库位使用率 */ $(function () { $('#test-table').bootstrapTable('destroy') $('#test-table').bootstrapTable({ method: 'GET', url: "sap/querySapLog.action", cache: false, striped: true, showColumns: true, //显示隐藏列 showRefresh: false, //显示刷新按钮 showExport: false, toolbar: "#toolbar", singleselect: true, clickToSelect: true, // 单击行即可以选中 search: false,//显示搜素表单 silent: true, //刷新事件必须设置 sidePagination: "client", //前端分页 columns: [ { field: "matnr", title: "物料编码", align: "center", valign: "middle", sortable: "true" }, { field: "request", title: "请求参数", align: "center", valign: "middle", width:150, formatter: formatterRequest }, { field: "response", title: "返回参数", align: "center", valign: "middle", width:150, formatter: formatterResponse }, { field: "create_time$", title: "记录时间", align: "center", valign: "middle", sortable: "true" }, { field: "remark", title: "其他信息", align: "center", valign: "middle", formatter: formatterRemark }, { field: "type", title: "请求结果", align: "center", valign: "middle", formatter: function (item) { if (item == 1) { return "成功"; } if (item == 2) { return "失败" } } }, ], queryParamsType: "undefined", queryParams: function queryParams(params) { //设置查询参数 var condition = $("#condition").val(); var param = { condition: condition }; return param; }, formatLoadingMessage: function () { return "请稍等,正在加载中..."; }, formatNoMatches: function () { return '无符合条件的记录'; }, //注册加载子表的事件。注意下这里的三个参数! onExpandRow: function (index, row, $detail) { // oInit.InitSubTable(index, row, $detail); } }); }); /** * 条件查询 * @returns */ function getViewStockUseByCon() { // $("#test-table").bootstrapTable('refresh'); $("#test-table").bootstrapTable('refreshOptions', {pageNumber: 1}); //分页后重新搜索时,初始化页码为1 } var formatterRequest = function (value, row, index) { if (!value) { return; } //没有内容的时候显示“-” var temp = ""; if (value == '') { var temp = "-"; } else { temp = value; } //有内容时,内容大于50字符则大于的部分隐藏,点击Show More 显示内容 var text = value; var flag = text.length > 50 ? true : false; if (flag) { var type = 1; temp = "
" + text.substring(0, 50) + "
...查看全部" } return temp; } var formatterResponse = function (value, row, index) { if (!value) { return; } //没有内容的时候显示“-” var temp = ""; if (value == '') { var temp = "-"; } else { temp = value; } //有内容时,内容大于50字符则大于的部分隐藏,点击Show More 显示内容 var text = value; var flag = text.length > 50 ? true : false; if (flag) { var type = 2; temp = "
" + text.substring(0, 50) + "
...查看全部" } return temp; } var formatterRemark = function (value, row, index) { if (!value) { return; } //没有内容的时候显示“-” var temp = ""; if (value == '') { var temp = "-"; } else { temp = value; } //有内容时,内容大于50字符则大于的部分隐藏,点击Show More 显示内容 var text = value; var flag = text.length > 50 ? true : false; if (flag) { var type = 3; temp = "
" + text.substring(0, 50) + "
...查看全部" } return temp; } function showhide(row, col) { var data = $('#test-table').bootstrapTable('getData', true); // 1 request, 2 response, 3 remark var type = ""; var modalTitle = ""; switch (col) { case 1: type = "request"; modalTitle = "请求参数"; break; case 2: type = "response"; modalTitle = "返回参数"; break; case 3: type = "remark"; modalTitle = "其他信息"; break; } var displayRecord = ""; if (data && data.length > 0) { data.map(function (item, index) { if (index == row) { displayRecord = item[type]; } }); } // alert(displayRecord); // 显示模态框 $("#showDetail").modal('show'); $("#headerName").html(modalTitle); $("#details").val(displayRecord); } function closeModal() { // 显示模态框 $("#showDetail").modal('hide'); } function onSearch() { $("#test-table").bootstrapTable('refreshOptions',{pageNumber:1}); //分页后重新搜索时,初始化页码为1 } $('#content').keydown(function () { if (event.keyCode === 13) { onSearch(); } });