layui.use(['laydate','table', 'admin', 'ax', 'func'], function () { var $ = layui.$; var table = layui.table; var $ax = layui.ax; var admin = layui.admin; var func = layui.func; var form = layui.form; var laydate = layui.laydate; //日期时间选择器 laydate.render({ elem: '#startTime' ,type: 'datetime' }); laydate.render({ elem: '#endTime' ,type: 'datetime' }); /** * 产品过站采集管理 */ var PassingStationCollection = { tableId: "passingStationCollectionTable" }; /** * 初始化表格的列 */ PassingStationCollection.initColumn = function () { return [[ {field: 'id', hide: true, title: '主键id'}, {field: 'locationCode', sort: true, title: '工位编号'}, {field: 'qualified', sort: true, title: '合格数'}, {field: 'unqualified', sort: true, title: '不合格数'}, {field: 'passRate', sort: true, title: '合格率'}, ]]; }; /** * 点击查询按钮 */ PassingStationCollection.search = function () { var queryData = {}; queryData['workOrderNo'] = $('#workOrderNo').val(); queryData['productionLine'] = $('#productionLine').val(); queryData['sfcCode'] = $('#sfcCode').val(); queryData['locationCode'] = $('#locationCode').val(); queryData['startTime'] = $("#startTime").val(); queryData['endTime'] = $("#endTime").val(); var i = 0; if($('#workOrderNo').val()!=null&&$('#workOrderNo').val() != ''){ i = i+1 } if($('#productionLine').val()!=null&&$('#productionLine').val() != ''){ i = i+1 } if($('#sfcCode').val()!=null&&$('#sfcCode').val() != ''){ i = i+1 } if($('#locationCode').val()!=null&&$('#locationCode').val() != ''){ i = i+1 } if($('#startTime').val()!=null&&$('#startTime').val() != ''){ i = i+1 } if($('#endTime').val()!=null&&$('#endTime').val() != ''){ i = i+1 } if(i>0){ table.reload(PassingStationCollection.tableId, { where: queryData, page: {curr: 1} }); }else { Feng.error("查询条件不能为空!") } }; /** * 导出excel按钮 */ PassingStationCollection.exportExcel = function () { var checkRows = table.checkStatus(PassingStationCollection.tableId); if (checkRows.data.length === 0) { Feng.error("请选择要导出的数据"); } else { table.exportFile(tableResult.config.id, checkRows.data, 'xls'); } }; var queryData = {}; queryData['locationCode'] = " "; //渲染表格 var tableResult = table.render({ elem: '#' + PassingStationCollection.tableId, url: Feng.ctxPath + '/passingStationCollection/PassRate', page: true, height: "full-158", cellMinWidth: 100, where:queryData, cols: PassingStationCollection.initColumn() }); // 搜索按钮点击事件 $('#btnSearch').click(function () { PassingStationCollection.search(); }); // 添加按钮点击事件 $('#btnAdd').click(function () { PassingStationCollection.jumpAddPage(); }); // 导出excel $('#btnExp').click(function () { PassingStationCollection.exportExcel(); }); });