| | |
| | | |
| | | <head> |
| | | <meta charset="utf-8"> |
| | | <title>库存信息列表</title> |
| | | <title>库存统计</title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" |
| | |
| | | </style> |
| | | <script> |
| | | // 这里是需要在页面渲染之前执行的代码 |
| | | document.addEventListener("DOMContentLoaded", function() { |
| | | document.addEventListener("DOMContentLoaded", function () { |
| | | //获取table默认显示数 |
| | | pageCntFirst(); |
| | | //判断是否开启table列表列宽调整功能。 |
| | | GetIsSetColW(); |
| | | }); |
| | | </script> |
| | | </script> |
| | | |
| | | </head> |
| | | |
| | |
| | | class="layui-input"> |
| | | </div> |
| | | </div> --> |
| | | |
| | | |
| | | <div class="layui-inline "> |
| | | <label class="layui-form-label" style="width: 60px;">库存状态</label> |
| | | <div class="layui-input-inline" style="width: 170px; margin-right: 0px;"> |
| | |
| | | <option value="0">待质检</option><!-- 待检验 --> |
| | | <option value="1">检验合格</option><!-- 合格品 --> |
| | | <option value="2">不合格</option><!-- 不合格 --> |
| | | <option value="3">放置期</option><!-- 不合格 --> |
| | | <!-- <option value="3">放置期</option>不合格 --> |
| | | </select> |
| | | </div> |
| | | </div> |
| | |
| | | |
| | | <div class="layui-tab-content"> |
| | | <!-- <div class="layui-tab-item layui-show"> --> |
| | | <div class="position-relative"><!-- class="position-relative" --><!-- 自定义表头加上 --> |
| | | <table id="LAY-app-content-list" lay-filter="LAY-app-content-list"></table> |
| | | <!-- #region 自定义表头 --> |
| | | <div class="headerSetIcon"> |
| | | <button class="layui-btn layui-btn-primary layui-btn-sm" data-type="customCols"> |
| | | <i class="layui-icon"></i> |
| | | </button> |
| | | </div> |
| | | <!-- #endregion --> |
| | | <div class="position-relative"><!-- class="position-relative" --><!-- 自定义表头加上 --> |
| | | <table id="LAY-app-content-list" lay-filter="LAY-app-content-list"></table> |
| | | <!-- #region 自定义表头 --> |
| | | <div class="headerSetIcon"> |
| | | <button class="layui-btn layui-btn-primary layui-btn-sm" data-type="customCols"> |
| | | <i class="layui-icon"></i> |
| | | </button> |
| | | </div> |
| | | <!-- #endregion --> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | |
| | |
| | | |
| | | // 表单需要的变量 |
| | | var infoOptions; |
| | | //#region 原始非自定义列 |
| | | //infoOptions = { |
| | | // elem: '#LAY-app-content-list', |
| | | // height: 'full-206', |
| | | // id: 'LAY-app-content-list', |
| | | // totalRow: true |
| | | // page: true, |
| | | // limit: pageCnt, |
| | | // limits: pageLimits, |
| | | // even: true, |
| | | // cellMinWidth: 80, //全局定义常规单元格的最小宽度,layui 2.2.1 新增 |
| | | // cols: |
| | | // [[ |
| | | // { |
| | | // title: '序号', |
| | | // type: 'numbers', |
| | | // fixed: 'left' |
| | | // }, |
| | | // { |
| | | // field: 'SkuNo', |
| | | // title: '物料编码', |
| | | // align: 'center', |
| | | // totalRowText: "合计:", |
| | | // }, { |
| | | // field: 'SkuName', |
| | | // title: '物料名称', |
| | | // align: 'center', |
| | | // }, { |
| | | // field: 'Standard', |
| | | // title: '物料规格', |
| | | // align: 'center', |
| | | // }, { |
| | | // field: 'Qty', |
| | | // title: '库存数量', |
| | | // align: 'center', |
| | | // totalRow: true, |
| | | // }, { |
| | | // field: 'LockQty', |
| | | // title: '锁定数量', |
| | | // align: 'center', |
| | | // totalRow: true, |
| | | // }, { |
| | | // field: 'FrozenQty', |
| | | // title: '冻结数量', |
| | | // align: 'center', |
| | | // totalRow: true, |
| | | // } |
| | | // ]] |
| | | //}; |
| | | //#endregion |
| | | |
| | | //#region 自定义表头 |
| | | var TotalColsArr = [[ |
| | | {field: '',title: '序号',type:'numbers',align: 'center',fixed: 'left', "disabled": true}, |
| | | {field: 'SkuNo',title: '物料编码',align: 'center',totalRowText: "合计:", "disabled": true}, |
| | | {field: 'SkuName',title: '物料名称',align: 'center', "disabled": true}, |
| | | {field: 'Standard',title: '物料规格',align: 'center', "disabled": true}, |
| | | {field: 'LotNo',title: '批次号',align: 'center', "disabled": true}, |
| | | {field: 'LotText',title: '批次描述',align: 'center'}, |
| | | {field: 'OwnerNo',title: '货主编码',align: 'center'}, |
| | | {field: 'OwnerName',title: '货主名称',align: 'center'}, |
| | | {field: 'Status',title: '库存状态',align: 'center',templet: '#buttonTpl'}, |
| | | {field: 'InspectStatus',title: '质检状态',align: 'center',templet: '#buttonTp2'}, |
| | | {field: 'Qty',title: '库存数量',align: 'center',totalRow: true}, |
| | | {field: 'LockQty',title: '锁定数量',align: 'center',totalRow: true}, |
| | | {field: 'FrozenQty',title: '冻结数量',align: 'center',totalRow: true}, |
| | | {field: 'InspectQty',title: '可抽检数量',align: 'center',totalRow: true}, |
| | | ]]; |
| | | var TotalColsSysArr=encodeURIComponent(encodeURIComponent(JSON.stringify(TotalColsArr)))//将表头数据进行url编码 |
| | | { field: '', title: '序号', type: 'numbers', align: 'center', fixed: 'left', "disabled": true }, |
| | | { field: 'SkuNo', title: '物料编码', align: 'center', totalRowText: "合计:", "disabled": true }, |
| | | { field: 'SkuName', title: '物料名称', align: 'center', "disabled": true }, |
| | | { field: 'Standard', title: '物料规格', align: 'center', "disabled": true }, |
| | | { field: 'LotNo', title: '批次号', align: 'center', "disabled": true }, |
| | | { field: 'LotText', title: '批次描述', align: 'center' }, |
| | | { field: 'OwnerNo', title: '货主编码', align: 'center' }, |
| | | { field: 'OwnerName', title: '货主名称', align: 'center' }, |
| | | { field: 'Status', title: '库存状态', align: 'center', templet: '#buttonTpl' }, |
| | | { field: 'InspectStatus', title: '质检状态', align: 'center', templet: '#buttonTp2' }, |
| | | { field: 'Qty', title: '库存数量', align: 'center', totalRow: true }, |
| | | { field: 'LockQty', title: '锁定数量', align: 'center', totalRow: true }, |
| | | { field: 'FrozenQty', title: '冻结数量', align: 'center', totalRow: true }, |
| | | { field: 'InspectQty', title: '可抽检数量', align: 'center', totalRow: true }, |
| | | ]]; |
| | | var TotalColsSysArr = encodeURIComponent(encodeURIComponent(JSON.stringify(TotalColsArr)))//将表头数据进行url编码 |
| | | //#endregion |
| | | //获取总量信息 |
| | | function refreshTable(SelectType,SkuNo,SkuName,OwnerNo,OwnerName,LotNo,Status,InspectStatus) { |
| | | function refreshTable(SelectType, SkuNo, SkuName, OwnerNo, OwnerName, LotNo, Status, InspectStatus) { |
| | | //#region 自定义表头 |
| | | var colsJson |
| | | var param1={ |
| | | Href:'Statistical/GetInventoryList' |
| | | var param1 = { |
| | | Href: 'Statistical/GetInventoryList' |
| | | }; |
| | | sendData(IP + "/Sys/GetTableColsByUserId", param1, 'post', function(res) { |
| | | if (res.code == 0){ |
| | | if(res.data=='' || res.data==undefined || res.data==null){ |
| | | colsJson=TotalColsArr |
| | | }else{ |
| | | colsJson= eval(res.data); |
| | | sendData(IP + "/Sys/GetTableColsByUserId", param1, 'post', function (res) { |
| | | if (res.code == 0) { |
| | | if (res.data == '' || res.data == undefined || res.data == null) { |
| | | colsJson = TotalColsArr |
| | | } else { |
| | | colsJson = eval(res.data); |
| | | } |
| | | }else{ |
| | | colsJson=TotalColsArr |
| | | } else { |
| | | colsJson = TotalColsArr |
| | | } |
| | | infoOptions = { |
| | | elem: '#LAY-app-content-list', |
| | | height: h1, |
| | | height: 'full-163', |
| | | id: 'LAY-app-content-list', |
| | | totalRow: true, |
| | | page: true, |
| | |
| | | limits: pageLimits, |
| | | even: true, |
| | | cellMinWidth: 80, //全局定义常规单元格的最小宽度,layui 2.2.1 新增 |
| | | done: function(){ |
| | | done: function () { |
| | | //自定义列宽 |
| | | SetTableColW('LAY-app-content-list','Statistical/GetInventoryList',TotalColsSysArr); |
| | | }, |
| | | cols:colsJson |
| | | SetTableColW('LAY-app-content-list', 'Statistical/GetInventoryList', TotalColsSysArr); |
| | | }, |
| | | cols: colsJson |
| | | }; |
| | | var param = { |
| | | SelectType:SelectType, //查询类型 |
| | | SkuNo:SkuNo, //物料号 |
| | | SkuName:SkuName, //物料名称 |
| | | OwnerNo:OwnerNo, //货主编码 |
| | | OwnerName:OwnerName, //货主名称 |
| | | LotNo:LotNo, //批次号 |
| | | Status:Status, //库存状态 = $("#Status").val(); |
| | | InspectStatus:InspectStatus, //质检状态 = $("#InspectStatus").val(); |
| | | SelectType: SelectType, //查询类型 |
| | | SkuNo: SkuNo, //物料号 |
| | | SkuName: SkuName, //物料名称 |
| | | OwnerNo: OwnerNo, //货主编码 |
| | | OwnerName: OwnerName, //货主名称 |
| | | LotNo: LotNo, //批次号 |
| | | Status: Status, //库存状态 = $("#Status").val(); |
| | | InspectStatus: InspectStatus, //质检状态 = $("#InspectStatus").val(); |
| | | }; |
| | | sendData(IP + "/Statistical/GetInventoryList", param, 'get', function (res) { |
| | | console.log(res) |
| | |
| | | }); |
| | | }); |
| | | //#endregion |
| | | } |
| | | |
| | | } |
| | | |
| | | //监听搜索 |
| | | form.on('submit(LAY-app-contlist-search)', function (data) { |
| | | var SelectType = $("#SelectType").val(); |
| | |
| | | var OwnerName = $("#OwnerName").val(); |
| | | var Status = $("#Status").val(); |
| | | var InspectStatus = $("#InspectStatus").val(); |
| | | refreshTable(SelectType,SkuNo, SkuName,OwnerNo,OwnerName,LotNo,Status,InspectStatus); |
| | | refreshTable(SelectType, SkuNo, SkuName, OwnerNo, OwnerName, LotNo, Status, InspectStatus); |
| | | |
| | | }); |
| | | |
| | |
| | | //#region 自定义表头 |
| | | //自定义表头 |
| | | active = { |
| | | customCols: function(){ |
| | | customCols: function () { |
| | | layer.open({ |
| | | type: 2, |
| | | title: '自定义列', |
| | | content: '../SystemSettings/HeaderSetting.html?Href=Statistical/GetInventoryList&ColsSysArr='+TotalColsSysArr, |
| | | content: '../SystemSettings/HeaderSetting.html?Href=Statistical/GetInventoryList&ColsSysArr=' + TotalColsSysArr, |
| | | maxmin: false, |
| | | resize: false, |
| | | area: ['970px', '650px'] |
| | | }); |
| | | } |
| | | }; |
| | | $('.layui-btn').on('click', function() { |
| | | $('.layui-btn').on('click', function () { |
| | | var type = $(this).data('type'); |
| | | active[type] ? active[type].call(this) : ''; |
| | | }); |