/** * 库存调整记录 */ $(function(){ $('#test-table').bootstrapTable('destroy') $('#test-table').bootstrapTable({ method : 'GET', url: "report/viewAdjDetailList.action", cache : false, striped : true, pagination : true, //在表格底部显示分页工具栏 pageSize : 10, //默认每页条数 pageNumber : 1, //默认分页 pageList : [ 10, 20, 50, 100, 200, 500 ],//分页数 showColumns : true, //显示隐藏列 showRefresh : false, //显示刷新按钮 showExport : false, toolbar:"#toolbar", singleselect : true, clickToSelect: true, // 单击行即可以选中 search : false,//显示搜素表单 silent : true, //刷新事件必须设置 sidePagination : "server", //表示服务端请求 columns : [ { field : "adj_id", title : "记录ID", align : "left", valign : "middle", sortable : "true", visible : false }, { field : "loc_no", title : "库位号", align : "center", valign : "middle", sortable : "true" }, { field : "mat_no", title : "物料编码", align : "center", valign : "middle", sortable : "true" }, { field : "mat_name", title : "物料名称", align : "center", valign : "middle", sortable : "true" }, { field : "s_qty", title : "调整前数量", align : "center", valign : "middle", sortable : "true" }, { field : "adj_qty", title : "调整数量", align : "center", valign : "middle", sortable : "true" }, { field : "qty", title : "调整后数量", align : "center", valign : "middle", sortable : "true" }, { field : "s_ctns", title : "调整前箱数", align : "center", valign : "middle", sortable : "true", visible : false }, { field : "adj_ctns", title : "调整箱数", align : "center", valign : "middle", sortable : "true", visible : false }, { field : "ctns", title : "调整后箱数", align : "center", valign : "middle", sortable : "true", visible : false }, { field : "str1", title : "单位", align : "center", valign : "middle", sortable : "true", visible : false }, { field : "str2", title : "规格", align : "center", valign : "middle", sortable : "true", visible : false }, { field : "memo", title : "备注", align : "center", valign : "middle", sortable : "true", visible : false }, { field : "modi_user", title : "修改人员", align : "center", valign : "middle", sortable : "true" }, { field : "modi_time", title : "修改时间", align : "center", valign : "middle", sortable : "true" }], queryParamsType: "undefined", queryParams: function queryParams(params) { //设置查询参数 var param = { pageNumber: params.pageNumber, pageSize: params.pageSize, loc_no:$("#loc_no").val(), mat_name:$("#mat_name").val(), begin_date:$("#begin_date").val(), end_date:$("#end_date").val() // searchText: params.searchText }; return param; }, formatLoadingMessage : function() { return "请稍等,正在加载中..."; }, formatNoMatches : function() { return '无符合条件的记录'; }, //注册加载子表的事件。注意下这里的三个参数! onExpandRow: function (index, row, $detail) { oInit.InitSubTable(index, row, $detail); } }); }); /** * 条件查询 * @returns */ function getViewAdjDetailByCon(){ // $("#test-table").bootstrapTable('refresh'); $("#test-table").bootstrapTable('refreshOptions',{pageNumber:1}); //分页后重新搜索时,初始化页码为1 } //导出 function ExportExcel(){ if(confirm("确认导出excel?")){ var url = "report/exportViewAdjDetail.action"; location.href=url; }else{ return false; } }