wxw
2025-03-06 52af69dd4c1be4ec93e012013dee78c3105998ec
HTML/views/StatisticalReport/BoxInfor.html
@@ -32,7 +32,7 @@
         <div class="layui-card">
            <div class="layui-form layui-card-header layuiadmin-card-header-auto" id="top">
               <div class="layui-form-item" style="margin-bottom: 0px;">
                  <div class="layui-inline zongdan" >
                  <!-- <div class="layui-inline zongdan" >
                     <label class="layui-form-label" style="width: 60px;">物料编码</label>
                     <div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
                        <input type="text" id="SkuNo"  name="SkuNo" placeholder="物料编码" autocomplete="off" class="layui-input">
@@ -43,14 +43,36 @@
                     <div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
                        <input type="text" id="SkuName"  name="SkuName" placeholder="物料名称" autocomplete="off" class="layui-input">
                     </div>
                  </div>
                  <div class="layui-inline zongdan" >
                     <label class="layui-form-label" style="width: 60px;">托盘号</label>
                     <div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
                        <input type="text" id="PalletNo"  name="PalletNo" placeholder="托盘号" autocomplete="off" class="layui-input">
                  </div> -->
                  <div class="layui-inline">
                     <label class="layui-form-label" style="width: 60px;">所属仓库</label>
                     <div class="layui-input-inline">
                        <select name="WareHouseNo" id="WareHouseNo" lay-filter="getWareHouseNo" lay-search>
                           <option value=""></option>
                        </select>
                     </div>
                  </div>
                  <div class="layui-inline mingxi">
                  <div class="layui-inline">
                     <label class="layui-form-label" style="width: 60px;">所属区域</label>
                     <div class="layui-input-inline">
                        <select name="AreaNo" id="AreaNo" lay-filter="getAreaNo" lay-search>
                           <option value=""></option>
                        </select>
                     </div>
                  </div>
                  <div class="layui-inline zongdan" >
                     <label class="layui-form-label" style="width: 60px;">储位地址</label>
                     <div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
                        <input type="text" id="LocatNo"  name="LocatNo" placeholder="储位地址" autocomplete="off" class="layui-input">
                     </div>
                  </div>
                  <div class="layui-inline zongdan" >
                     <label class="layui-form-label" style="width: 60px;">桶号</label>
                     <div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
                        <input type="text" id="PalletNo"  name="PalletNo" placeholder="桶号" autocomplete="off" class="layui-input">
                     </div>
                  </div>
                  <!-- <div class="layui-inline mingxi">
                     <label class="layui-form-label" style="width: 60px;">货主编码</label>
                     <div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
                        <input type="text" id="OwnerNo" name="OwnerNo" placeholder="货主编码" autocomplete="off"
@@ -63,7 +85,7 @@
                        <input type="text" id="OwnerName" name="OwnerName" placeholder="货主名称" autocomplete="off"
                           class="layui-input">
                     </div>
                  </div>
                  </div> -->
                  <div class="layui-inline mingxi">
                     <label class="layui-form-label" style="width: 60px;">批次号</label>
                     <div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
@@ -73,12 +95,12 @@
                  <!-- 箱码 箱支状态 检验标记 零箱标记 质量状态 -->
                  <div class="layui-inline zongdan" >
                  <!-- <div class="layui-inline zongdan" >
                     <label class="layui-form-label" style="width: 60px;">箱码</label>
                     <div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
                        <input type="text" id="BoxNo"  name="BoxNo" placeholder="箱码" autocomplete="off" class="layui-input">
                     </div>
                  </div>
                  </div> -->
                  <!-- <div class="layui-inline zhijian">
                     <label class="layui-form-label" style="width: 60px;">箱支状态</label>
                     <div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
@@ -91,7 +113,7 @@
                        </select>
                     </div>
                  </div> -->
                  <div class="layui-inline zhijian">
                  <!-- <div class="layui-inline zhijian">
                     <label class="layui-form-label" style="width: 60px;">抽检标记</label>
                     <div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
                        <select name="InspectMark" id="InspectMark" lay-filter="InspectMark"
@@ -123,22 +145,22 @@
                           <option value="1">是</option>
                        </select>
                     </div>
                  </div>
                  <div class="layui-inline zhijian">
                  </div> -->
                  <!-- <div class="layui-inline zhijian">
                     <label class="layui-form-label" style="width: 60px;">质检状态</label>
                     <div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
                        <select name="InspectStatus" id="InspectStatus" lay-filter="InspectStatus"
                           lay-search>
                           <option value=""></option>
                           <option value="0">待质检</option><!-- 待检验 -->
                           <option value="1">检验合格</option><!-- 合格品 -->
                           <option value="2">不合格</option><!-- 不合格 -->
                           <option value="3">放置期</option><!-- 不合格 -->
                           <option value="0">待质检</option>
                           <option value="1">检验合格</option>
                           <option value="2">不合格</option>
                           <option value="3">放置期</option>
                        </select>
                     </div>
                  </div>
                  </div> -->
                  <div class="layui-inline zhijian">
                  <!-- <div class="layui-inline zhijian">
                     <label class="layui-form-label" style="width: 60px;">开始时间</label>
                     <div class="layui-input-inline" style="width: 170px; margin-right: 0px;">
                        <input type="text" autocomplete="off" id="StartTime" class="layui-input"
@@ -151,95 +173,32 @@
                        <input type="text" autocomplete="off" id="EndTime" class="layui-input"
                           placeholder="结束时间">
                     </div>
                  </div>
                  </div> -->
                  <div class="layui-inline sousuo">
                     <button class="layui-btn layui-btn-sm layuiadmin-btn-list" lay-submit lay-filter="LAY-app-contlist-search">
                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>搜索
                     </button>
                     <button class="layui-btn layui-btn-sm layuiadmin-btn-list" lay-submit
                     <!-- <button class="layui-btn layui-btn-sm layuiadmin-btn-list" lay-submit
                        lay-filter="daochu">
                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>导出
                     </button>
                     </button>  -->
                  </div>
               </div>
            </div>
            <div id="center"></div>
            <div class="layui-card-body">
               <div style="position: relative;">
                  <div class="layui-tab layui-tab-brief" lay-filter="docDemoTabBrief">
                     <ul class="layui-tab-title" id="tab">
                        <li  class="layui-this">托盘明细</li>
                        <li >箱码明细</li>
                     </ul>
                     <div id="center">
                     </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">&#xe610;</i>
                                 </button>
                              </div>
                              <!-- #endregion -->
                           </div>
                        </div>
                        <div class="layui-tab-item">
                           <div class="position-relative"><!-- class="position-relative" --><!-- 自定义表头加上 -->
                              <table id="LAY-app-content-list2" lay-filter="LAY-app-content-list2"></table>
                              <!-- #region 自定义表头 -->
                              <div class="headerSetIcon">
                                 <button class="layui-btn layui-btn-primary layui-btn-sm" data-type="customCols2">
                                    <i class="layui-icon">&#xe610;</i>
                                 </button>
                              </div>
                              <!-- #endregion -->
                              <!-- #region 自定义表头 -->
                              <script type="text/html" id="templetProductionTime">
                                 {{# function GetBtn(d){
                                       return formatDate(d.ProductionTime);
                                    }
                                 }}
                                 {{ GetBtn(d) }}
                              </script>
                              <script type="text/html" id="templetInspectTime">
                                 {{# function GetBtn1(d){
                                       return formatDate(d.InspectTime);
                                    }
                                 }}
                                 {{ GetBtn1(d) }}
                              </script>
                              <!-- #endregion -->
                           </div>
                        </div>
                     </div>
               <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>
               
                    <script type="text/html" id="BoxStatus">
                        {{#  if(d.Status=='0'){ }}
                            <p>未组托</p>
                        {{#  } else if(d.Status == '1') { }}
                            <p>已组托</p>
                        {{#  } else if(d.Status == '2') { }}
                            <p>已入库</p>
                        {{#  } else if(d.Status == '3') { }}
                            <p>已出库</p>
                        {{#  } else if(d.Status == '4') { }}
                     <p>已分配</p>
                  {{#  } else if(d.Status == '5') { }}
                     <p>已拣货</p>
                  {{#  } }}
                    </script>
                    <script type="text/html" id="InspectMarkStatus">
                        {{#  if(d.InspectMark=='0'){ }}
                            <p>否</p>
@@ -254,8 +213,24 @@
                            <p>是</p>
                        {{# } }}
                    </script>
                    <script type="text/html" id="InspectStatus1">
               <script type="text/html" id="InspectPalletStatus">
                  {{# function GetBtn11(d){
                     var html = ``;
                     if(d.PalletStatus=='0'){
                        html = `净桶`;
                     } else if(d.PalletStatus=='1') {
                        html = `预混`;
                     } else if(d.PalletStatus=='2') {
                        html = `半成品`;
                     }else if(d.PalletStatus=='3') {
                        html = `脏桶`;
                     }
                     return html;
                  }
               }}
               {{ GetBtn11(d) }}
               </script>
               <script type="text/html" id="InspectStatus1">
                        {{#  if(d.InspectStatus == '0') { }}
                            <p>待检验</p>
                        {{#  } else if(d.InspectStatus == '1'){ }}
@@ -266,18 +241,27 @@
                            <p>放置期</p>
                        {{#  } }}
                    </script>
                    <script type="text/html" id="BitPalletMarkStatus1">
                        {{#  if(d.BitBoxMark=='0'){ }}
                            <p>否</p>
                        {{#  } else if(d.BitBoxMark == '1') { }}
                            <p>是</p>
                        {{# } }}
               <script type="text/html" id="TempletStatus">
                        {{#  if(d.Status=='0'){ }}
                     <button class="layui-btn layui-btn-radius layui-btn-danger layui-btn-xs">待分配</button>
                  {{#  } else if(d.Status == '1') { }}
                     <button class="layui-btn layui-btn-radius layui-btn-xs">部分分配</button>
                  {{#  } else if(d.Status == '2') { }}
                     <button class="layui-btn layui-btn-radius layui-btn-xs">已分配</button>
                  {{#  } else if(d.Status == '3') { }}
                     <button class="layui-btn layui-btn-radius layui-btn-xs">盘点锁定</button>
                  {{#  } else if(d.Status == '4') { }}
                     <button class="layui-btn layui-btn-radius layui-btn-xs">移库锁定</button>
                  {{#  } else if(d.Status == '5') { }}
                     <button class="layui-btn layui-btn-radius layui-btn-xs layui-btn-danger">异常锁定</button>
                  {{#  } }}
                    </script>
                    <script type="text/html" id="table-content-list">
                        <button class="layui-btn layui-btn-normal layui-btn-xs approvalBtnupt" id="approvalBtnupt" lay-event="edit">
                            <i class="layui-icon layui-icon-edit"></i>详情
                        </button>
                    </script>
               <script type="text/html" id="toolbarDemo">
                  <!-- <button class="layui-btn layuiadmin-btn-list layui-btn-sm  addClass" lay-event="add">
                     <i class="layui-icon">&#xe654;</i>添加
                  </button> -->
               </script>
            </div>
         </div>
      </div>
@@ -300,9 +284,7 @@
               element = layui.element;
               laydate = layui.laydate;
            var h1 = GetTableTabHeight();
            // var h1 =  GetTkableTopHeight();
            // console.log(h1)
            var h1 = GetTableHeight();
            laydate.render({
               elem: '#StartTime',
@@ -409,29 +391,33 @@
            var TotalColsArr = [[
               {field: '',title: '序号',type:'numbers',align: 'center',fixed: 'left', "disabled": true},
               {field: 'WareHouseName', title: '所属仓库', align: 'center'},
               {field: 'RoadwayName', title: '所属巷道', align: 'center'},
               //{field: 'RoadwayName', title: '所属巷道', align: 'center'},
                    {field: 'AreaName', title: '所属区域', align: 'center'},
                    {field: 'LocatNo', title: '储位地址', align: 'center'},
                    {field: 'PalletNo', title: '托盘号', align: 'center'},
                    {field: 'PalletNo', title: '桶号', align: 'center'},
               {field: 'PalletStatus', title: '桶状态', align: 'center', templet: '#InspectPalletStatus'},
                    {field: 'SkuNo', title: '物料编码', align: 'center'},
                    {field: 'SkuName', title: '物料名称', align: 'center'},
               {field: 'OwnerNo',title: '货主编码',align: 'center'},
               {field: 'OwnerName',title: '货主名称',align: 'center'},
               {field: 'SupplierNo',title: '供应商编码',align: 'center'},
               {field: 'SupplierName',title: '供应商名称',align: 'center'},
               //{field: 'OwnerNo',title: '货主编码',align: 'center'},
               //{field: 'OwnerName',title: '货主名称',align: 'center'},
               //{field: 'SupplierNo',title: '供应商编码',align: 'center'},
               //{field: 'SupplierName',title: '供应商名称',align: 'center'},
                    {field: 'LotNo', title: '批次号', align: 'center'},
                    {field: 'LotText', title: '批次描述', align: 'center'},
                    {field: 'SupplierLot', title: '供货批次', align: 'center'},
                    //{field: 'SupplierLot', title: '供货批次', align: 'center'},
               {field: 'Status', title: '分配状态', align: 'center', templet: '#TempletStatus'},
                    {field: 'Qty', title: '数量', align: 'center'},
                    {field: 'LockQty', title: '锁定数量', align: 'center',},
                    {field: 'FrozenQty', title: '冻结数量', align: 'center'},
                    {field: 'InspectMark', title: '抽检标记', align: 'center', templet: '#InspectMarkStatus'},
                    {field: 'BitPalletMark', title: '零托标记', align: 'center', templet: '#BitPalletMarkStatus'},
               {field: 'InspectStatus', title: '质检状态', align: 'center', templet: '#InspectStatus1'},
               {field: 'UDF1', title: '所属设备编码', align: 'center'},
                    //{field: 'InspectMark', title: '抽检标记', align: 'center', templet: '#InspectMarkStatus'},
                    //{field: 'BitPalletMark', title: '零托标记', align: 'center', templet: '#BitPalletMarkStatus'},
            ]];
            var TotalColsSysArr=encodeURIComponent(encodeURIComponent(JSON.stringify(TotalColsArr)))//将表头数据进行url编码
            //#endregion
            //获取托盘明细
                function refreshTable(SkuNo,SkuName,PalletNo,LotNo,BoxNo,Status,InspectMark,BitPalletMark,BitBoxMark,InspectStatus,OwnerNo,OwnerName,StartTime,EndTime) {
                function refreshTable(WareHouseName,AreaName,LocatNo,PalletNo,LotNo) {
               //#region 自定义表头
               var colsJson
               var param1={
@@ -455,6 +441,8 @@
                     limit: pageCnt,
                     limits: pageLimits,
                     even: true,
                     toolbar: '#toolbarDemo',
                     defaultToolbar: [''], //'print', 'exports'
                     cellMinWidth: 80, //全局定义常规单元格的最小宽度,layui 2.2.1 新增
                     done: function(){
                        //自定义列宽
@@ -464,20 +452,12 @@
                  };
                  var param = {
                     SkuNo:SkuNo, //物料号
                     SkuName:SkuName, //物料名称
                     wareHouseName:WareHouseName,
                     areaName:AreaName,
                     locatNo:LocatNo,
                     palletNo:PalletNo, //托盘号
                     LotNo:LotNo, //批次号
                     BoxNo:BoxNo, //箱码
                     Status:Status, //箱支状态
                     InspectMark:InspectMark, //检验标记
                     BitPalletMark:BitPalletMark, //零托标记
                     BitBoxMark:BitBoxMark, //零箱标记
                     InspectStatus:InspectStatus, //质量状态
                     OwnerNo:OwnerNo, //货主编码
                     OwnerName:OwnerName, //货主名称
                     StartTime:StartTime, //开始时间
                     EndTime:EndTime, //结束时间
                  };
                  sendData(IP + "/Statistical/GetBindList", param, 'get', function(res) { 
                     console.log(res)                       
@@ -500,219 +480,123 @@
                  });
               });
               //#endregion                    
                }
            // 表单需要的变量
            var infoOptions2;
            //#region 原始非自定义列
            // infoOptions2 = {
            //    elem: '#LAY-app-content-list2',
            //    height: 'full-206',
            //    id: 'LAY-app-content-list2',
            //    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',
                //         },
                //         {
                //             field: 'SkuName', title: '物料名称', align: 'center',
                //         },
                //         {
                //             field: 'PalletNo', title: '托盘号', align: 'center', width: 110,
                //         },
                //         {
                //             field: 'BoxNo', title: '箱码', align: 'center', width: 100,
                //         },
                //         {
                //             field: 'Status', title: '箱支状态', align: 'center', templet: '#BoxStatus',
                //         },
                //         {
                //             field: 'LotNo', title: '批次号', align: 'center',
                //         },
                //         {
                //             field: 'LotText', title: '批次描述', align: 'center',
                //         },
                //         {
                //             field: 'Qty', title: '数量', width: 90, align: 'center',
                //         },
                //         {
                //             field: 'FullQty', title: '整箱数量', width: 100, align: 'center',
                //         },
                //         {
                //             field: 'ProductionTime', title: '生产日期', align: 'center',
                //             templet: function(d) {
                //                 return formatDate(d.ProductionTime);
                //             },
                //         },
                //         {
                //             field: 'InspectMark', title: '抽检标记', align: 'center', templet: '#InspectMarkStatus',
                //         },
                //         {
                //             field: 'BitBoxMark', templet: '#BitPalletMarkStatus1', title: '零箱标记', align: 'center',
                //         },
                //         {
                //             field: 'InspectStatus', templet: '#InspectStatus1', title: '质检状态', align: 'center',
                //         },
                //         {
                //             field: 'InspectTime', title: '复检时间', align: 'center',
                //             templet: function(d) {
                //                 return formatDate(d.InspectTime);
                //             },
                //         },
                //         {
            //          title: '操作', fixed: 'right', align: 'center', toolbar: '#table-content-list'
            //       }
            //    ]]
            // };
                //#endregion
                }
            
            //获取明细信息
            //#region 自定义表头
            var DetailColsArr = [[
               {field: '',title: '序号',type:'numbers',fixed: 'left', "disabled": true},
                    {field: 'SkuNo', title: '物料编码', align: 'center'},
                    {field: 'SkuName', title: '物料名称', align: 'center'},
                    {field: 'PalletNo', title: '托盘号', align: 'center', width: 110},
                    {field: 'BoxNo', title: '箱码', align: 'center', width: 100},
                    {field: 'Status', title: '箱支状态', align: 'center', templet: '#BoxStatus'},
                    {field: 'LotNo', title: '批次号', align: 'center'},
                    {field: 'LotText', title: '批次描述', align: 'center'},
                    {field: 'Qty', title: '数量', width: 90, align: 'center'},
                    {field: 'FullQty', title: '整箱数量', width: 100, align: 'center'},
                    {field: 'ProductionTime', title: '生产日期', align: 'center',templet: '#templetProductionTime'},
                    {field: 'InspectMark', title: '抽检标记', align: 'center', templet: '#InspectMarkStatus'},
                    {field: 'BitBoxMark', templet: '#BitPalletMarkStatus1', title: '零箱标记', align: 'center'},
                    {field: 'InspectStatus', templet: '#InspectStatus1', title: '质检状态', align: 'center'},
                    {field: 'InspectTime', title: '复检时间', align: 'center',templet: '#templetInspectTime'},
                    {field: 'caozuo',title: '操作', fixed: 'right', align: 'center', toolbar: '#table-content-list', "disabled": true}
            ]];
            var DetailColsSysArr=encodeURIComponent(encodeURIComponent(JSON.stringify(DetailColsArr)))//将表头数据进行url编码
            //#endregion
            function refreshTable2(Id,SkuNo,SkuName,LotNo,PalletNo,BoxNo,Status,InspectMark,BitBoxMark,InspectStatus,StartTime,EndTime) {
               //#region 自定义表头
               var colsJson2
               var param1={
                  Href:'Statistical/GetBoxInfo'
               };
               sendData(IP + "/Sys/GetTableColsByUserId", param1, 'post', function(res) {
                  if (res.code == 0){
                     if(res.data=='' || res.data==undefined || res.data==null){
                        colsJson2=DetailColsArr
                     }else{
                        colsJson2= eval(res.data);
                     }
                  }else{
                        colsJson2=DetailColsArr
                  }
                  infoOptions2 = {
                     elem: '#LAY-app-content-list2',
                     height: h1,
                     id: 'LAY-app-content-list2',
                     page: true,
                     limit: pageCnt,
                     limits: pageLimits,
                     even: true,
                     cellMinWidth: 80, //全局定义常规单元格的最小宽度,layui 2.2.1 新增
                     done: function(){
                        //自定义列宽
                        SetTableColW('LAY-app-content-list2','Statistical/GetBoxInfo',DetailColsSysArr);
                     },
                     cols:colsJson2
                  };
                  var param = {
                     Id:Id,
                     SkuNo:SkuNo,
                     SkuName:SkuName,
                     LotNo:LotNo,
                     PalletNo:PalletNo,
                     BoxNo:BoxNo,
                     Status:Status,
                     InspectMark:InspectMark,
                     BitBoxMark:BitBoxMark,
                     InspectStatu:InspectStatus,
                     StartTime:StartTime,
                     EndTime:EndTime,
                  }
                  sendData(IP + "/Statistical/GetBoxInfo", param, 'get', function(res) {
                     if (res.code == 0) //成功
                     {
                        var list = res.data;
                        $.extend(infoOptions2, {
                           data: list
            //头工具栏事件
            table.on('toolbar(LAY-app-content-list)', function (obj) {
               var checkStatus = table.checkStatus(obj.config.id);
               if (obj.event == "add") {
                  layer.open({
                     type: 2,
                     title: '添加托盘库存明细',
                     content: 'PalletAddFrom.html',
                     maxmin: true,
                     area: ['530px', '530px'],
                     btn: ['确定', '取消'],
                     yes: function(index, layero) {
                        var iframeWindow = window['layui-layer-iframe' + index],
                           submitID = 'layuiadmin-app-form-submit',
                           submit = layero.find('iframe').contents().find('#' + submitID);
                        //监听提交
                        iframeWindow.layui.form.on('submit(' + submitID + ')', function(data) {
                           var field = data.field; //获取提交的字段
                           //提交 Ajax 成功后,静态更新表格中的数据
                           var param = {
                              PalletNo:field.PalletNo,//托盘码
                              WareHouseNo: field.WareHouseNo, //所属仓库
                              AreaNo: field.AreaNo, //所属区域
                              LocatNo:field.LocatNo,//所属储位
                              PalletStatus: field.PalletStatus, //托盘类别
                              SkuNo:field.SkuNo,
                              SkuName:field.SkuName,
                              LotNo:field.LotNo
                           };
                           if(doing){
                              doing = false;
                              sendData(IP + "/Statistical/InsertStockDetail", param, 'post',function(res) {
                                 console.log(res);
                                 if (res.code == 0) { //成功
                                    layer.msg(res.msg, {
                                       icon: 1,
                                       time: 2000 //2秒关闭(如果不配置,默认是3秒)
                                    }, function() {
                                       layer.close(index); //关闭弹层
                                       refreshTable("","","","","","","","","","","","","","");
                                       doing = true;
                                    });
                                 }
                                 else
                                 { //不成功
                                    layer.msg(res.msg, {
                                       icon: 2,
                                       time: 2000 //2秒关闭(如果不配置,默认是3秒)
                                    }, function() {doing = true;});
                                 }
                              });
                           }
                        });
                        infoOptions2.page = {
                           curr: 1
                        }
                        tableIns2 = table.render(infoOptions2);
                        submit.trigger('click');
                     }
                     else //不成功
                     {
                        layer.msg('获取明细列表信息失败!', {
                           icon: 2,
                           time: 2000 //2秒关闭(如果不配置,默认是3秒)
                        }, function() {});
                  });
               }
            });
            //获取仓库下拉框信息
            sendData(IP + "/Sys/GetWarehouseDic", {}, 'get', function(res) {
               if (res.code == 0) { //成功
               for (var i = 0; i < res.data.length; i++) {
                  $("#WareHouseNo").append('<option value =' + res.data[i].WareHouseNo + '>' + res.data[i].WareHouseNo + '-' +
                     res.data[i].WareHouseName + '</option>');
               }
               form.render('select');
               } else { //不成功
                  layer.msg(res.msg, {
                     icon: 2,
                     time: 2000 //2秒关闭(如果不配置,默认是3秒)
                  }, function() {});
               }
            });
            getAR("");
            form.on('select(getWareHouseNo)', function(data) {
               getAR(data.value);
            });
            function getAR(val) {
               //获取 区域下拉框
               sendData(IP + "/Sys/GetStorageAreaByHouseNo?wareHouseNo="+val, {}, 'get', function(res) {
                  $("#AreaNo").empty();
                  $("#AreaNo").append('<option value =""></option>');
                  if (res.code == 0) { //成功
                     for (var i = 0; i < res.data.length; i++) {
                        $("#AreaNo").append('<option value =' + res.data[i].AreaNo + '>' + res.data[i].AreaNo + '-' +
                           res.data[i].AreaName + '</option>');
                     }
                  })
                     form.render('select');
                  } else { //不成功
                     layer.msg('获取区域信息失败', {
                        icon: 2,
                        time: 2000 //2秒关闭(如果不配置,默认是3秒)
                     }, function() {
                        //回调
                        form.render('select');
                     });
                  }
               });
               //#endregion
            }
            //var url = IP + "/Statistical/GetInventoryList1";
            //接受全局变量
            let quanid = '';
            };
            //监听搜索
            form.on('submit(LAY-app-contlist-search)', function(data) {
               var SkuNo = $("#SkuNo").val();
               var SkuName = $("#SkuName").val();
               var LotNo = $("#LotNo").val();
               var WareHouseName = $("#WareHouseNo").val();
               var AreaName = $("#AreaNo").val();
               var LocatNo = $("#LocatNo").val();
               var PalletNo = $("#PalletNo").val();
               var LotNo = $("#LotNo").val();
               var BoxNo = $("#BoxNo").val();
               var Status = $("#Status").val();
               var InspectMark = $("#InspectMark").val();
               var BitPalletMark = $("#BitPalletMark").val();
               var BitBoxMark = $("#BitBoxMark").val();
               var InspectStatus = $("#InspectStatus").val();
               var OwnerNo = $("#OwnerNo").val();
               var OwnerName = $("#OwnerName").val();
               var StartTime = $("#StartTime").val();
               var EndTime = $("#EndTime").val();
               if(yemianid == 0){
                  console.log("总单");
                  refreshTable(SkuNo,SkuName,PalletNo,LotNo,BoxNo,Status,InspectMark,BitPalletMark,BitBoxMark,InspectStatus,OwnerNo,OwnerName,StartTime,EndTime);
               }else if(yemianid == 1){
                  quanid = '';
                  console.log("明细");
                  refreshTable2(quanid,SkuNo,SkuName,LotNo,PalletNo,BoxNo,Status,InspectMark,BitBoxMark,InspectStatus,StartTime,EndTime);
               }
               refreshTable(WareHouseName,AreaName,LocatNo,PalletNo,LotNo);
               
            });
            //触发行双击事件
            table.on('rowDouble(LAY-app-content-list)', function(obj) {
               $(".layui-tab-title>li").attr("class", "");
               $('.layui-tab-title>li').eq(1).attr('class', 'layui-this');
               $('.layui-tab-content .layui-tab-item').attr('class', 'layui-tab-item')
               $('.layui-tab-content .layui-tab-item').eq(1).attr('class', 'layui-tab-item layui-show')
               console.log(obj.data.Id);
               quanid = obj.data.Id;
               refreshTable2(obj.data.Id);
               yemianid=1;
            });
            
            //监听Tab切换,以改变地址hash值
            element.on('tab(docDemoTabBrief)', function(data){
@@ -734,130 +618,9 @@
               var StartTime = $("#StartTime").val();
               var EndTime = $("#EndTime").val();
               console.log(data.index);
               yemianid = data.index
               if(yemianid == 0){
                  console.log("总单");
                  refreshTable(SkuNo,SkuName,PalletNo,LotNo,BoxNo,Status,InspectMark,BitPalletMark,BitBoxMark,InspectStatus,OwnerNo,OwnerName,StartTime,EndTime);
               }else if(yemianid == 1){
                  console.log("明细");
                  refreshTable2(quanid,SkuNo,SkuName,LotNo,PalletNo,BoxNo,Status,InspectMark,BitBoxMark,InspectStatus,StartTime,EndTime);
               }
               refreshTable(SkuNo,SkuName,PalletNo,LotNo,BoxNo,Status,InspectMark,BitPalletMark,BitBoxMark,InspectStatus,OwnerNo,OwnerName,StartTime,EndTime);
            });
            var doing = true;
            // ------------------------------------详情---------------------------------------------------
            table.on('tool(LAY-app-content-list2)', function(obj) {
               console.log(obj)
               var data = obj.data;
               //详情
               if (obj.event === 'edit') {
                  BoxNo = data.BoxNo;
                  console.log(data)
                  layer.open({
                     type: 2,
                     title: '箱支详情信息',
                     content: 'BoxSupportInfor.html?BoxNo=' + BoxNo,
                     maxmin: true,
                     area: ['80%', '85%'],
                     btn: ['关闭'],
                     yes: function(index, layero) {
                        var iframeWindow = window['layui-layer-iframe' + index],
                           submitID = 'layuiadmin-app-form-edit',
                           submit = layero.find('iframe').contents().find('#' + submitID);
                           if(doing)
                           {
                              doing = false;
                              layer.close(index); //关闭弹层
                              refreshTable();
                              doing = true;
                           }
                     }
                  });
               }
            });
            form.on('submit(daochu)', function () {
               layer.confirm('确定导出当前数据吗?', function(index) {
                  if(yemianid == 0){
                     console.log("托盘明细");
                     var param = {
                        SkuNo : $("#SkuNo").val(),
                        SkuName : $("#SkuName").val(),
                        LotNo : $("#LotNo").val(),
                        PalletNo : $("#PalletNo").val(),
                        BoxNo : $("#BoxNo").val(),
                        Status : $("#Status").val(),
                        InspectMark : $("#InspectMark").val(),
                        BitPalletMark : $("#BitPalletMark").val(),
                        BitBoxMark : $("#BitBoxMark").val(),
                        InspectStatus : $("#InspectStatus").val(),
                        StartTime: $("#StartTime").val(),
                        EndTime: $("#EndTime").val(),
                     };
                     sendData(IP + "/Statistical/GetBindListDaoChu", param, 'get', function (res) {
                        console.log(res);
                        if (res.code == 0) { //成功
                           var list = res.data;
                           table.exportFile(tableIns.config.id, list,'xls',"托盘明细信息"+getNowTime(),); //data 为该实例中的任意数量的数据
                           layer.msg('导出成功!', {
                              icon: 1,
                              time: 2000 //2秒关闭(如果不配置,默认是3秒)
                           }, function () {
                           });
                        } else { //不成功
                           layer.msg('获取信息失败!', {
                              icon: 2,
                              time: 2000 //2秒关闭(如果不配置,默认是3秒)
                           }, function () { });
                        }
                     });
                  }else if(yemianid == 1){
                     console.log("箱码明细");
                     var param = {
                        Id:quanid,
                        SkuNo: $("#SkuNo").val(),
                        SkuName: $("#SkuName").val(),
                        LotNo:$("#LotNo").val(),
                        LocatNo:$("#LocatNo").val(),
                        PalletNo:$("#PalletNo").val(),
                        Status:$("#Status").val(),
                        InspectStatus:$("#InspectStatus").val(),
                        IsSamolingTray:$("#IsSamolingTray").val(),
                        StartTime: $("#StartTime").val(),
                        EndTime: $("#EndTime").val(),
                     };
                     sendData(IP + "/Statistical/GetBoxInfoDaoChu", param, 'get', function (res) {
                        console.log(res);
                        if (res.code == 0) { //成功
                           var list = res.data;
                           table.exportFile(tableIns2.config.id, list,'xls',"箱码明细信息"+getNowTime(),); //data 为该实例中的任意数量的数据
                           layer.msg('导出成功!', {
                              icon: 1,
                              time: 2000 //2秒关闭(如果不配置,默认是3秒)
                           }, function () {
                           });
                        } else { //不成功
                           layer.msg('获取信息失败!', {
                              icon: 2,
                              time: 2000 //2秒关闭(如果不配置,默认是3秒)
                           }, function () { });
                        }
                     });
                  }
               });
            });
            //#region 自定义表头
            //自定义表头         
@@ -872,17 +635,6 @@
                     area: ['970px', '650px']
                  });
               },
               customCols2: function(){
                  layer.open({
                     type: 2,
                     title: '自定义列',
                     content: '../SystemSettings/HeaderSetting.html?Href=Statistical/GetBoxInfo&ColsSysArr='+DetailColsSysArr,
                     maxmin: false,
                     resize: false,
                     area: ['970px', '650px']
                  });
               }
            };
            $('.layui-btn').on('click', function() {
               var type = $(this).data('type');