layui.use(['laydate','table', 'admin', 'ax', 'func'], function () { var $ = layui.$; var table = layui.table; var $ax = layui.ax; 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 [[ {type: 'checkbox'}, {field: 'id', hide: true, title: '主键id'}, {field: 'workOrderNo', sort: true, title: '工单编号',minWidth:160}, {field: 'sfcCode', sort: true, title: '总成序列号',minWidth:160}, {field: 'productCode', sort: true, title: '产品编号', width: 125}, {field: 'productionLine', sort: true, title: '产线编号', width: 125}, {field: 'locationCode', sort: true, title: '工位编号', width: 125}, /*{field: 'equipmentNo', sort: true, title: '设备编号', width: 125},*/ {field: 'inboundTime', sort: true, title: '入站时间',minWidth:160}, {field: 'outboundTime', sort: true, title: '出站时间',minWidth:160}, {field: 'beatTime', sort: true, title: '节拍时间',minWidth:125}, // {field: 'inRsSign', sort: true, title: '入站是否合格', width: 135}, /* {field: 'inRsSign', sort: true, templet: '#stateTpl', title: '入站是否合格', width: 135},*/ /* {field: 'inMsgSign', sort: true, title: '入站NG原因', width: 125},*/ // {field: 'outRsSign', sort: true, title: '出站是否合格', width: 135}, {field: 'outRsSign', sort: true, templet: '#stateTpls', title: '出站是否合格', width: 135}, // {field: 'outRsSignState', sort: true, title: '出站是否合格', width: 135}, /* {field: 'outMsgSign', sort: true, title: '出站NG原因', width: 125},*/ // {field: 'collectionTime', sort: true, title: '采集时间',minWidth:160}, /* {field: 'createUser', sort: true, title: '创建用户', width: 125},*/ {field: 'createTime', sort: true, title: '采集时间',minWidth:160}, /* {field: 'updateUser', sort: true, title: '更改用户', width: 125}, {field: 'updateTime', sort: true, title: '更改时间',minWidth:160},*/ {align: 'center', toolbar: '#tableBar', title: '操作', width: 125} ]]; }; form.on('switch(status)', function (obj) { var id = obj.elem.value; var checked = obj.elem.checked ? 1 : 0; PassingStationCollection.changeStatus(id, checked); }); form.on('switch(statuss)', function (obj) { var id = obj.elem.value; var checked = obj.elem.checked ? 1 : 0; PassingStationCollection.changeStatuss(id, checked); }); // 修改状态方法 PassingStationCollection.changeStatus = function (id, checked) { var ajax = new $ax(Feng.ctxPath + "/passingStationCollection/editItem", function (data) { Feng.success("修改成功!"); }, function (data) { Feng.error("修改失败!" + data.message); }); ajax.set("id", id); ajax.set("inRsSign", checked); ajax.start(); }; PassingStationCollection.changeStatuss = function (id, checked) { var ajax = new $ax(Feng.ctxPath + "/passingStationCollection/editItem", function (data) { Feng.success("修改成功!"); }, function (data) { Feng.error("修改失败!" + data.message); }); ajax.set("id", id); ajax.set("outRsSign", checked); ajax.start(); }; /** * 点击查询按钮 */ 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(); table.reload(PassingStationCollection.tableId, { where: queryData, page: {curr: 1} }); }; $("#btnExpAll").click(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(); $.ajax({ type: "POST", url: Feng.ctxPath + '/passingStationCollection/exportTable', data: queryData, success : function (result) { console.log(result.data) table.exportFile(tableResult.config.id, result.data, 'xls'); } }); }); /** * 跳转到添加页面 */ PassingStationCollection.jumpAddPage = function () { window.location.href = Feng.ctxPath + '/passingStationCollection/add' }; /** * 跳转到编辑页面 * * @param data 点击按钮时候的行数据 */ PassingStationCollection.jumpEditPage = function (data) { window.location.href = Feng.ctxPath + '/passingStationCollection/edit?id=' + data.id }; /** * 导出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'); } }; /** * 点击删除 * * @param data 点击按钮时候的行数据 */ PassingStationCollection.onDeleteItem = function (data) { var operation = function () { var ajax = new $ax(Feng.ctxPath + "/passingStationCollection/delete", function (data) { Feng.success("删除成功!"); table.reload(PassingStationCollection.tableId); }, function (data) { Feng.error("删除失败!" + data.responseJSON.message + "!"); }); ajax.set("id", data.id); ajax.start(); }; Feng.confirm("是否删除?", operation); }; // 渲染表格 var tableResult = table.render({ elem: '#' + PassingStationCollection.tableId, url: Feng.ctxPath + '/passingStationCollection/list', toolbar: '#toolbarDemo', page: true, height: "full-158", cellMinWidth: 100, cols: PassingStationCollection.initColumn() }); // 搜索按钮点击事件 $('#btnSearch').click(function () { PassingStationCollection.search(); }); // 添加按钮点击事件 $('#btnAdd').click(function () { PassingStationCollection.jumpAddPage(); }); // 导出excel $('#btnExp').click(function () { PassingStationCollection.exportExcel(); }); // 工具条点击事件 table.on('tool(' + PassingStationCollection.tableId + ')', function (obj) { var data = obj.data; var layEvent = obj.event; if (layEvent === 'edit') { PassingStationCollection.jumpEditPage(data); } else if (layEvent === 'delete') { PassingStationCollection.onDeleteItem(data); } }); });