bklLiudl
2024-08-27 13b91828a0301ba53585662f5207ed45ff485638
HTML/views/StatisticalReport/InventoryStatistics.html
@@ -3,7 +3,7 @@
<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"
@@ -19,13 +19,13 @@
   </style>
   <script>
      // 这里是需要在页面渲染之前执行的代码
      document.addEventListener("DOMContentLoaded", function() {
      document.addEventListener("DOMContentLoaded", function () {
         //获取table默认显示数
         pageCntFirst();
         //判断是否开启table列表列宽调整功能。
         GetIsSetColW();
      });
     </script>
   </script>
</head>
@@ -97,7 +97,7 @@
                        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;">
@@ -131,7 +131,7 @@
                        <option value="0">待质检</option><!-- 待检验 -->
                        <option value="1">检验合格</option><!-- 合格品 -->
                        <option value="2">不合格</option><!-- 不合格 -->
                        <option value="3">放置期</option><!-- 不合格 -->
                        <!-- <option value="3">放置期</option>不合格 -->
                     </select>
                  </div>
               </div>
@@ -172,16 +172,16 @@
                  <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">&#xe610;</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">&#xe610;</i>
                           </button>
                        </div>
                        <!-- #endregion -->
                     </div>
                  </div>
               </div>
@@ -285,96 +285,46 @@
         // 表单需要的变量
         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,
@@ -382,21 +332,21 @@
                  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)
@@ -419,8 +369,8 @@
               });
            });
            //#endregion
         }
         }
         //监听搜索
         form.on('submit(LAY-app-contlist-search)', function (data) {
            var SelectType = $("#SelectType").val();
@@ -431,7 +381,7 @@
            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);
         });
@@ -467,18 +417,18 @@
         //#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) : '';
         });