修改问题

Administrator

2024-06-28 8db84793a19b02df61c8fb9e5d539c57b827da45

 HTML/views/StatisticalReport/BoxInfor.html

@@ -50,7 +50,7 @@
                        <input type="text" id="PalletNo"  name="PalletNo" placeholder="托盘号" autocomplete="off" class="layui-input">
                     </div>
                  </div>
                  <div class="layui-inline mingxi">
                  <!-- <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 +63,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 +73,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 +91,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,7 +123,7 @@
                           <option value="1">是</option>
                        </select>
                     </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;">
@@ -138,7 +138,7 @@
                     </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,7 +151,7 @@
                        <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">
@@ -164,82 +164,19 @@
                  </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 +191,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 +219,12 @@
                            <p>放置期</p>
                        {{#  } }}
                    </script>
                    <script type="text/html" id="BitPalletMarkStatus1">
                        {{#  if(d.BitBoxMark=='0'){ }}
                            <p>否</p>
                        {{#  } else if(d.BitBoxMark == '1') { }}
                            <p>是</p>
                        {{# } }}
                    </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 +247,7 @@
               element = layui.element;
               laydate = layui.laydate;

            var h1 = GetTableTabHeight();
            // var h1 =  GetTkableTopHeight();
            // console.log(h1)
            var h1 = GetTableHeight();

            laydate.render({
               elem: '#StartTime',
@@ -409,24 +354,26 @@
            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: '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: '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: 'InspectMark', title: '抽检标记', align: 'center', templet: '#InspectMarkStatus'},
                    //{field: 'BitPalletMark', title: '零托标记', align: 'center', templet: '#BitPalletMarkStatus'},
            ]];
            var TotalColsSysArr=encodeURIComponent(encodeURIComponent(JSON.stringify(TotalColsArr)))//将表头数据进行url编码
            //#endregion
@@ -455,6 +402,8 @@
                     limit: pageCnt,
                     limits: pageLimits,
                     even: true,
                     toolbar: '#toolbarDemo',
                     defaultToolbar: [''], //'print', 'exports'
                     cellMinWidth: 80, //全局定义常规单元格的最小宽度，layui 2.2.1 新增
                     done: function(){
                        //自定义列宽
@@ -500,178 +449,67 @@
                  });
               });
               //#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() {});
                     }
                  })
               });
               //#endregion					
            }
                
            //var url = IP + "/Statistical/GetInventoryList1";
				
               
				
            //接受全局变量
            let quanid = '';
                  });
               }
            });

            //监听搜索
            form.on('submit(LAY-app-contlist-search)', function(data) {
               var SkuNo = $("#SkuNo").val();
@@ -692,27 +530,10 @@
               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(SkuNo,SkuName,PalletNo,LotNo,BoxNo,Status,InspectMark,BitPalletMark,BitBoxMark,InspectStatus,OwnerNo,OwnerName,StartTime,EndTime);
               
            });
            //触发行双击事件
            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 +555,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 +572,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');