From 8a36bbee40f5e1069b15a98b1e64ac9719ee8a46 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期二, 23 四月 2024 17:17:13 +0800
Subject: [PATCH] 1.销售出库单 增加 反写源单 销售订单和发货通知单   超出 关联数量  关闭源单 2.应收单 增加  反写源单 销售出库单 和 销售订单  超出关联数量  关闭源单 3.动态获取源单增加参数 Num 0蓝单   1红单  2全部 4.销售流程的测试并完善功能; 销售订单-》发货通知单-》销售出库单-》应收单 (注意: 源单类型的下拉框 需要 根据数据库 表动态加载, 关联数量 要准确 , 审核 且 未关闭 未行关闭的行 才能下推 ,关联数量超额后,要 反写 关闭 源单 )

---
 WebTM/views/生产管理/生产计划平台/JIT_DayPlanPlatForm.html |  393 +++++++++++++++++++++++++++++++++++++-------------------
 1 files changed, 259 insertions(+), 134 deletions(-)

diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\347\224\237\344\272\247\350\256\241\345\210\222\345\271\263\345\217\260/JIT_DayPlanPlatForm.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\347\224\237\344\272\247\350\256\241\345\210\222\345\271\263\345\217\260/JIT_DayPlanPlatForm.html"
index 3d3e0ae..bec6514 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\347\224\237\344\272\247\350\256\241\345\210\222\345\271\263\345\217\260/JIT_DayPlanPlatForm.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\347\224\237\344\272\247\350\256\241\345\210\222\345\271\263\345\217\260/JIT_DayPlanPlatForm.html"
@@ -29,6 +29,7 @@
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnICMOBill" id="btnICMOBill">鐢熶骇璁㈠崟閫夊崟</button>
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnReady" id="btnReady">鍑嗗</button>
                             <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnProPC" id="btnProPC">鎺掍骇</button>
+                            <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnRoutEdit" id="btnRoutEdit">宸ヨ壓璺嚎</button>
                         </div>
                         <div class="layui-collapse">
                             <div class="layui-colla-item">
@@ -241,6 +242,7 @@
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>鍒楄缃�</button>
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Routing"><i class="layui-icon layui-icon-form"></i>宸ヨ壓璺嚎</button>
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Calendar"><i class="layui-icon layui-icon-form"></i>宸ュ巶鏃ュ巻</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>瀵煎嚭</button>
                             </div>
                         </script>
                         <script type="text/html" id="toolbarDemo2">
@@ -279,7 +281,7 @@
             , excel = layui.excel
             , soulTable = layui.soulTable
             , element = layui.element;
-
+        var ins;
         var sWhere = "";
         var sWhere_ICMO = "";
         var option = [];
@@ -350,7 +352,10 @@
                 });
                 return layer.msg("鎺掍骇鏁伴噺澶т簬璁㈠崟鏁伴噺!")
             }
-
+            
+            if (Date.parse(obj.field) > Date.parse(obj.data.璁″垝缁撴潫鏃ユ湡)) {
+                return layer.msg("鎺掍骇鏃ユ湡瓒呭嚭璁″垝缁撴潫鏃ユ湡!");
+            }
 
 
             //淇敼鏁版嵁
@@ -499,6 +504,11 @@
                 case 'set_Calendar':
                     set_Calendar();
                     break;
+                    break;
+                //瀵煎嚭excel
+                case 'get_export':
+                    get_Export();
+                    break;
             }
         });
 
@@ -539,7 +549,7 @@
                    if (table.cache["mainTable"][i] != "") {                       
                       if (parseFloat(table.cache["mainTable"][i]["浼樺厛绾�"]) == 0) {
                           HYxjQty++
-                      }                       
+                       }
                    }
                 }
                 if (HYxjQty > 0) {
@@ -631,6 +641,12 @@
                 }, 1000)
             }
         })
+
+        //宸ヨ壓璺嚎缂栬緫
+        form.on('submit(btnRoutEdit)', function (data) {
+            get_btnRoutEdit();
+        })
+
 
         //琛屽唴浜嬩欢
         table.on('tool(mainTable)', function (obj) {
@@ -738,10 +754,11 @@
             columns.push({ field: '閿�鍞鍗曞彿', title: '閿�鍞鍗曞彿', width: 150, sort: true });
             columns.push({ field: '鐢熶骇璁㈠崟鍙�', title: '鐢熶骇璁㈠崟鍙�', width: 150, style: 'background-color: #f9f9f9;', sort: true });
             columns.push({ field: '鐢熶骇璁㈠崟鏄庣粏琛屽彿', title: '鐢熶骇璁㈠崟鏄庣粏琛屽彿', width: 150, sort: true });
-            columns.push({ field: '鐢熶骇缁勭粐', title: '鐢熶骇缁勭粐', width: 150, sort: true });
+            columns.push({ field: '鐢熶骇缁勭粐', title: '鐢熶骇缁勭粐', width: 150, sort: true });           
             columns.push({ field: '鐗╂枡浠g爜', title: '鐗╂枡缂栫爜', width: 150, sort: true });
             columns.push({ field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 150, sort: true });
             columns.push({ field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 150, sort: true });
+            columns.push({ field: '灏忔椂浜ц兘', title: '灏忔椂浜ц兘', width: 150, sort: true, edit: 'text' });
             columns.push({ field: '閿�鍞鍗曟暟閲�', title: '閿�鍞鍗曟暟閲�', width: 150, sort: true });//0
             columns.push({ field: '璁″垝鏁伴噺', title: '鐢熶骇璁㈠崟鏁伴噺', width: 150, sort: true });//0
             columns.push({ field: '鏃ヨ鍒掓暟閲忔�婚噺', title: '鏃ヨ鍒掓暟閲忔�婚噺', width: 150, sort: true });//0
@@ -756,127 +773,127 @@
 
             columns.push({
                 field: Format(myDate.getTime() + 0 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 0 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 0 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 0 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 0 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 0 * oneday, 'yyyy-MM-dd')],d,Format(myDate.getTime() + 0 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 1 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 1 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 1 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 1 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 1 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 1 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 1 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 2 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 2 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 2 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 2 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 2 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 2 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 2 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 3 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 3 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 3 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 3 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 3 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 3 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 3 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 4 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 4 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 4 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 4 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 4 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 4 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 4 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 5 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 5 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 5 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 5 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 5 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 5 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 5 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 6 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 6 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 6 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 6 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 6 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 6 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 6 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 7 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 7 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 7 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 7 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 7 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 7 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 7 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 8 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 8 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 8 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 8 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 8 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 8 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 8 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 9 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 9 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 9 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 9 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 9 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 9 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 9 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 10 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 10 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 10 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 10 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 10 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 10 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 10 * oneday, 'yyyy-MM-dd'));
                 }  })//0
             columns.push({
                 field: Format(myDate.getTime() + 11 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 11 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 11 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 11 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 11 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 11 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 11 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 12 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 12 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 12 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 12 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 12 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 12 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 12 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 13 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 13 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 13 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 13 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 13 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 13 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 13 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 14 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 14 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 14 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 14 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 14 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 14 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 14 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 15 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 15 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 15 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 15 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 15 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 15 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 15 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 16 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 16 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 16 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 16 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 16 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 16 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 16 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 17 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 17 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 17 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 17 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 17 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 17 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 17 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 18 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 18 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 18 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 18 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 18 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 18 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 18 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 19 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 19 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 19 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 19 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 19 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 19 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 19 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 20 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 20 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 20 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 20 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 20 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 20 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 20 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 21 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 21 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 21 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 21 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 21 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 21 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 21 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 22 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 22 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 22 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 22 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 22 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 22 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 22 * oneday, 'yyyy-MM-dd'));
                 }  })//0
             columns.push({
                 field: Format(myDate.getTime() + 23 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 23 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 23 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 23 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 23 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 23 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 23 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 24 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 24 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 24 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 24 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 24 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 24 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 24 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 25 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 25 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 25 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 25 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 25 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 25 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 25 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 26 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 26 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 26 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 26 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 26 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 26 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 26 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 27 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 27 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 27 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 27 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 27 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 27 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 27 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 28 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 28 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 28 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 28 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 28 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 28 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 28 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 29 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 29 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 29 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 29 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 29 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 29 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 29 * oneday, 'yyyy-MM-dd'));
                 } })//0
             columns.push({
                 field: Format(myDate.getTime() + 30 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 30 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) {
-                    return DayColor(d[Format(myDate.getTime() + 30 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 30 * oneday, 'yyyy-MM-dd')]);
+                    return DayColor(d[Format(myDate.getTime() + 30 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 30 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 30 * oneday, 'yyyy-MM-dd'));
                 }  })//0
 
             columns.push({ field: 'T31', title: 'T31', width: 70 });//0
@@ -888,8 +905,7 @@
             columns.push({ field: '璁㈠崟绛夌骇', title: '璁㈠崟绛夌骇', width: 150, sort: true });
             columns.push({ field: '璁㈠崟浜よ揣鏈�', title: '璁㈠崟浜よ揣鏈�', width: 150, templet: "<div>{{d.璁㈠崟浜よ揣鏈� =='1900-01-01' ?'':layui.util.toDateString(d.璁㈠崟浜よ揣鏈�, 'yyyy-MM-dd')}}</div>", sort: true });
             columns.push({ field: '璁㈠崟闇�姹傛暟閲�', title: '璁㈠崟闇�姹傛暟閲�', width: 150, sort: true });
-            columns.push({ field: '寮�宸ヤ綑閲�', title: '寮�宸ヤ綑閲�', width: 150, sort: true });
-            columns.push({ field: '灏忔椂浜ц兘', title: '灏忔椂浜ц兘', width: 150, sort: true, edit: 'text' });
+            columns.push({ field: '寮�宸ヤ綑閲�', title: '寮�宸ヤ綑閲�', width: 150, sort: true });           
             columns.push({ field: '鐢熶骇鍛ㄦ湡', title: '鐢熶骇鍛ㄦ湡', width: 150, sort: true });
             columns.push({ field: '鏈�杩熷紑宸ユ棩鏈�', title: '鏈�杩熷紑宸ユ棩鏈�', width: 150, templet: "<div>{{d.鏈�杩熷紑宸ユ棩鏈� =='' ?'':layui.util.toDateString(d.鏈�杩熷紑宸ユ棩鏈�, 'yyyy-MM-dd')}}</div>", sort: true });
             columns.push({ field: '鏈�杩熷畬宸ユ棩鏈�', title: '鏈�杩熷畬宸ユ棩鏈�', width: 150, templet: "<div>{{d.鏈�杩熷畬宸ユ棩鏈� =='' ?'':layui.util.toDateString(d.鏈�杩熷畬宸ユ棩鏈�, 'yyyy-MM-dd')}}</div>", sort: true });
@@ -921,28 +937,24 @@
                 , cellMinWidth: 90
                 , cols: [columns]
                 , limit: Number.MAX_VALUE//榛樿鏄剧ず鍏ㄩ儴
-                //, done: function (res, page, count) {
-                //    var that = this.elem.next();
-                //    res.data.forEach(function (item, index) {
-                //        var NumCount = item.FBASEQTY;//鑾峰彇鎬诲簱瀛樻暟閲�
-                //        for (var i = 0; i < Days; i++) {
-                //            var dateNowTime = Format(new Date($("#HBEGINDATE").val()).setDate(new Date($("#HBEGINDATE").val()).getDate() + i), 'yyyy-MM-dd');
-                //            if (item[dateNowTime] != null) {
-                //                if (NumCount > parseFloat(item[dateNowTime])) {
-                //                    NumCount -= parseFloat(item[dateNowTime]);
-                //                } else {
-                //                    var num = 6;//鍗虫椂搴撳瓨涓庢棩鏈熸尐鐫�  浠庡嵆鏃跺簱瀛樺紑濮嬬畻
-                //                    tr = that.find(".layui-table-box tbody tr[data-index='" + index + "']");
-                //                    rq = tr.children()[num + 1 + i];
-                //                    rq.style.color = '#f66161';//鐒跺悗鍙樿壊
-                //                    rq = tr.children()[num];
-                //                    rq.style.color = '#f66161';//鐒跺悗鍙樿壊
-                //                }
-                //            }
-                //        }
-                //    });
-                //    $('.layui-table-cell').css({ 'height': 'auto' });
-                //}
+                , done: function (res, page, count) {
+                    //res.data.forEach(function (item, index) {
+                    //    if (data1.data.DataColor != undefined) {
+                    //        var sj = data1.data.DataColor;
+                    //        //绂佺敤澶嶉�夋锛岃缃笉鍙�変腑鏍囪瘑锛屽皢璇ヨ璁剧疆涓洪槾褰辫壊
+                    //        var tr = $(".layui-table tr[data-index=" + index + "]");
+                    //        var td = tr.children('td'); //鑾峰彇tr涓嬫墍鏈夌殑td
+                    //        if (sj.length > index) {
+                    //            for (var i = 1; i < td.length; i++) {
+                    //                var title = option.cols[0][i].field;
+                    //                if (sj[index][title] != "" && sj[index][title] != null) {
+                    //                    td.eq(i).css("background-color", sj[index][title]);
+                    //                }
+                    //            }
+                    //        }
+                    //    }
+                    //})
+                }
             };
         }
 
@@ -957,7 +969,7 @@
                 success: function (data1) {
                     if (data1.count == 1) {
                         option.data = data1.data;
-                        table.render(option);
+                        ins = table.render(option);
                         var HinterID_S = [];
                         for (var i = 0; i < data1.data.length; i++) {
                             HinterID_S.push(data1.data[i]["hmainid"]);
@@ -1107,7 +1119,7 @@
         }
 
         //鏁伴噺鏍囪棰滆壊
-        function DayColor(DaySate, DayHQty) {
+        function DayColor(DaySate, DayHQty,Data,NowData) {
             if (DaySate == "榻愬" || DaySate == "鏈綈濂�") {
                 if (DaySate == "榻愬") {
                     return "<span style='color:green;'>" + DayHQty + "</span>";
@@ -1119,6 +1131,9 @@
                 if (DayHQty == null) {
                     return "<span></span>";
                 } else {
+                    if (Data[NowData] > 0 && Data[NowData] != null && Data[NowData] != "" && Date.parse(Data["璁″垝缁撴潫鏃ユ湡"]) < Date.parse(NowData)) {
+                        return "<span style='background-color:#f48888;width:100%;display: inline-block;'>" + DayHQty + "</span>";
+                    }
                     return "<span>" + DayHQty + "</span>";
                 }
             }
@@ -1148,7 +1163,7 @@
                 , area: ['90%', '90%']//澶у皬
                 , title: '鐗╂枡鍒楄〃'//鏍囬
                 , shift: 2//寮瑰嚭鍔ㄧ敾
-                , content: ['../../Baseset/鍩虹璧勬枡/Gy_MaterialList.html', 'yes']
+                , content: ['../../鍩虹璧勬枡/鍏敤鍩虹璧勬枡/Gy_Material.html', 'yes']
                 , btn: ['纭畾', '鍙栨秷']
                 , btn1: function (index, layero) {//鎸夐挳銆愭寜閽竴銆戠殑鍥炶皟
                     var iframeWindow = window['layui-layer-iframe' + index]  //鑾峰彇寮规椤甸潰
@@ -1158,9 +1173,9 @@
                     }
                     //鑾峰彇鏁版嵁
                     $("#HMaterID").val(checkStatus.data[0].HItemID);
-                    $("#HMaterNumber").val(checkStatus.data[0].HNumber);
-                    $("#HMaterName").val(checkStatus.data[0].HName);
-                    $("#HMaterModel").val(checkStatus.data[0].HModel);
+                    $("#HMaterNumber").val(checkStatus.data[0].鐗╂枡浠g爜);
+                    $("#HMaterName").val(checkStatus.data[0].鐗╂枡鍚嶇О);
+                    $("#HMaterModel").val(checkStatus.data[0].瑙勬牸鍨嬪彿);
                     layer.close(index); //瀹冭幏鍙栫殑濮嬬粓鏄渶鏂板脊鍑虹殑鏌愪釜灞傦紝鍊兼槸鐢眑ayer鍐呴儴鍔ㄦ�侀�掑璁$畻鐨�
                 }
                 , btn2: function (index, layero) { }
@@ -1474,9 +1489,10 @@
                 }
                 if (isNaN(data[i]["HSourceID"])) {
                     return layer.msg("閫夋嫨鐢熶骇璧勬簮!!")
-                }
+                }               
                 HICOMNum.push(data[i]["HICMOInterID"] + ";" + data[i]["HICMOEntryID"] + ";" + data[i]["HSourceID"]);
             }
+           
             $('#HProgressBar').html(`
     <div class="layui-progress" lay-filter="demo-filter-progress">
       <div class="layui-progress-bar" lay-percent="40%"></div>
@@ -1538,6 +1554,13 @@
 
                         table.render(option);
 
+                        data = table.cache["mainTable"];
+                        for (var i = 0; i < data.length; i++) {
+                            if (parseFloat(data[i]["灏忔椂浜ц兘"]) == 0 || parseFloat(data[i]["灏忔椂浜ц兘"]) == null || parseFloat(data[i]["灏忔椂浜ц兘"]) == undefined) {
+                                return layer.alert("绗�" + (i + 1) + '琛岋紝灏忔椂浜ц兘鏈缃紝璇锋牳瀵规暟鎹��' + '</br>' + '1.鐗╂枡鏈坊鍔犲伐鑹鸿矾绾�' + '</br>' + '2.宸ヨ壓璺嚎涓湭璁剧疆灏忔椂浜ц兘' + '</br>' + '3.鐢熶骇璧勬簮鏈缃崟鐝伐鏃�' + '</br>' + '4.鐢熶骇璧勬簮涓粦瀹氬伐浣滀腑蹇冧笌宸ヨ壓璺嚎涓缃殑宸ヤ綔涓績涓嶄竴鑷�');
+                            }
+                        }
+                        
                     } else {
                         //layer.close(ajaxLoad);
                         layer.alert(data1.code + data1.Message, { icon: 5 });
@@ -1549,6 +1572,51 @@
             });
         }
 
+        //宸ヨ壓璺嚎缂栬緫
+        function get_btnRoutEdit() {
+            var CheckStatus = table.checkStatus("mainTable");
+            if (CheckStatus.data.length == 1) {
+                var HSouceID = CheckStatus.data[0]["HSourceID"];
+                var HMaterID = CheckStatus.data[0]["HMaterID"];
+                var sWhere = "	select a.HInterID from Gy_RoutingBillMain a inner join Gy_RoutingBillSub b on a.HInterID = b.HInterID  and a.HStandard = 1 inner join Gy_Process p on b.HProcID = p.HItemID and HTProcessFlag = 0  inner join Gy_WorkCenter w on b.HCenterID = w.HItemID inner join(select HCenterID from Gy_Source where HItemID = " + HSouceID + ")s on s.HCenterID = w.HItemID where a.HMaterID = " + HMaterID;
+                $.ajax({
+                    type: "GET",
+                    url: GetWEBURL() + "/Gy_SOPBillList/WindowPrintList", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚�
+                    async: false,
+                    data: { "sWhere": sWhere },
+                    success: function (data) {
+                        if (data.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            if (data.data.length == 0) {
+                                return layer.msg("褰撳墠鐗╂枡娌℃湁宸ヨ壓璺嚎!璇锋煡鐪嬬墿鏂欐墍瀵瑰簲鐨勫伐浣滀腑蹇冩槸鍚︽纭�!");
+                            } else {
+                                var HInterID = data.data[0]["HInterID"];
+
+                                layer.open({
+                                    type: 2
+                                    , area: ['100%', '100%']
+                                    , title: '宸ヨ壓璺嚎-缂栬緫'
+                                    , shift: 0//寮瑰嚭鍔ㄧ敾
+                                    , content: '../../璁″垝绠$悊/宸ヨ壓璺嚎/Gy_RoutingBill.html?OperationType=3&linterid=' + HInterID + '&HSouceBillType=3301'
+                                    , end: function () {
+                                        //鍒锋柊椤甸潰,
+                                        //location.reload();
+                                    }
+                                })
+                            }
+                        }
+                        else {
+                            layer.msg(data.Message, { icon: 5 });
+                        }
+                        layer.closeAll("loading");
+                    },
+                    error: function (err) {
+                        layer.msg("閿欒:" + err, { icon: 5 });
+                    }
+                });
+            } else {
+                return layer.msg("璇烽�夋嫨涓�鏉℃暟鎹繘琛屽伐鑹鸿矾绾跨紪杈�");
+            }
+        }
 
         //鎺掍骇
         function get_btnProPC(HWorkShopID) {
@@ -2154,6 +2222,27 @@
                         }
                         option.data = dataPush;
                         table.render(option);
+
+                        //鑾峰彇涓婃柟鎺掍骇鍒楄〃鏁版嵁,鐢ㄤ簬瀵规瘮涓嬫柟鐢熶骇璁㈠崟鍒楄〃锛屽皢涓嬫柟鐢熶骇璁㈠崟鍒楄〃鐩稿悓鐨勬暟鎹笉鏄剧ず
+                        var compareList = [];
+                        for (var i = 0; i < option.data.length; i++) {
+                            var temp = option.data[i]["婧愬崟涓诲唴鐮�"] + "|" + option.data[i]["婧愬崟瀛愬唴鐮�"];
+                            compareList.push(temp);
+                        }
+
+                        //鍓旈櫎涓婃柟鎺掍骇鍒楄〃涓凡缁忓姞鍏ョ殑鐢熶骇璁㈠崟
+                        var tables = [];
+                        for (var i = 0; i < option2.data.length; i++) {
+                            var temp = option2.data[i]["hmainid"] + "|" + option2.data[i]["HEntryID"];
+                            if ($.inArray(temp, compareList) == -1) {
+                                tables.push(option2.data[i]);
+                            }
+                        }
+                        option2.data = tables;
+
+                        //閲嶆柊娓叉煋瀛愯〃2
+                        table.render(option2);
+
                         layer.close(ajaxLoad);
                     } else {
                         layer.close(ajaxLoad);
@@ -2373,24 +2462,24 @@
                         if (checkStatus.data.length != 1) {
                             return layer.msg("璇烽�夋嫨涓�鏉℃暟鎹�");
                         }
-                        OptionData = checkStatus.data[0];
+                        OptionData[0] = checkStatus.data[0];
                         layer.close(index);//鍏抽棴寮圭獥
                     }
                     , end: function () {
-
-                        var num = 0;
-                        for (var i = 0; i < option.data.length; i++) {
-                            if (num >= data.length) {
-                                break;
+                        if (OptionData.length > 0) {
+                            var num = 0;
+                            for (var i = 0; i < option.data.length; i++) {
+                                if (num >= data.length) {
+                                    break;
+                                }
+                                if (option.data[i]["LAY_CHECKED"] == true) {
+                                    option.data[i]["HSourceID"] = OptionData[0].HItemID;
+                                    option.data[i]["鐢熶骇璧勬簮"] = OptionData[0].鐢熶骇璧勬簮鍚嶇О;
+                                    num += 1;
+                                }
                             }
-                            if (option.data[i]["LAY_CHECKED"] == true) {
-                                option.data[i]["HSourceID"] = OptionData.HItemID;
-                                option.data[i]["鐢熶骇璧勬簮"] = OptionData.鐢熶骇璧勬簮鍚嶇О;
-                                num += 1;
-                            }
+                            table.render(option);
                         }
-                        table.render(option);
-
                         //obj.update({
                         //    "HSourceID": OptionData.HItemID
                         //    , "鐢熶骇璧勬簮": OptionData.鐢熶骇璧勬簮鍚嶇О
@@ -2511,7 +2600,7 @@
                                 if (checkStatus.data.length != 1) {
                                     return layer.msg("璇烽�夋嫨涓�鏉℃暟鎹�");
                                 }
-                                OptionData = checkStatus.data[0];
+                                OptionData[0] = checkStatus.data[0];
                                 //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹�
                                 obj.update({
                                     "HSourceID": checkStatus.data[0].HItemID
@@ -2520,17 +2609,60 @@
                                 layer.close(index);//鍏抽棴寮圭獥
                             }
                             , end: function () {
-                                obj.update({
-                                    "HSourceID": OptionData.HItemID
-                                    , "鐢熶骇璧勬簮": OptionData.鐢熶骇璧勬簮鍚嶇О
-                                })
+                                if (OptionData.length > 0) {
+                                    obj.update({
+                                        "HSourceID": OptionData[0].HItemID
+                                        , "鐢熶骇璧勬簮": OptionData[0].鐢熶骇璧勬簮鍚嶇О
+                                    })
+                                    OptionData = [];
+                                }
                             }
                         })
                     }
                     obj.event = "";
                     return false;
-                }
+                } else if (event.key == "F8") {
+                    //鐢熶骇璧勬簮
+                    if (obj.event == "HSourceID") {
+                        layer.open({
+                            type: 2
+                            , skin: "layui-layer-rim" //鍔犱笂杈规
+                            , title: "鐢熶骇璧勬簮鍒楄〃"  //鏍囬
+                            , closeBtn: 1  //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡
+                            , shift: 2 //寮瑰嚭鍔ㄧ敾
+                            , area: ["90%", "90%"] //绐椾綋澶у皬
+                            , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀�
+                            , content: ["../../Baseset/鍩虹璧勬枡/Gy_Source.html?HMaterID=" + obj.data["HMaterID"], "yes"]
+                            , btn: ["纭畾", "鍙栨秷"]
+                            , btn1: function (index, laero) {
+                                //鎸夐挳涓�  鐨勫洖璋�
+                                var iframeWindow = window["layui-layer-iframe" + index];//鑾峰彇寮规椤甸潰
+                                var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//鑾峰彇閫変腑鐨勬暟鎹�
 
+                                if (checkStatus.data.length != 1) {
+                                    return layer.msg("璇烽�夋嫨涓�鏉℃暟鎹�");
+                                }
+                                OptionData[0] = checkStatus.data[0];
+                                //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹�
+                                obj.update({
+                                    "HSourceID": checkStatus.data[0].HItemID
+                                    , "鐢熶骇璧勬簮": checkStatus.data[0].HName
+                                })
+                                layer.close(index);//鍏抽棴寮圭獥
+                            }
+                            , end: function () {
+                                if (OptionData.length > 0) {
+                                    obj.update({
+                                        "HSourceID": OptionData[0].HItemID
+                                        , "鐢熶骇璧勬簮": OptionData[0].HName
+                                    })
+                                    OptionData = [];
+                                }
+                            }
+                        })
+                    }
+                    obj.event = "";
+                }
             })
         }
 
@@ -2591,7 +2723,6 @@
             }
         }
 
-
         //鏌ヨ鏈帓浜х殑鐢熶骇璁㈠崟
         function get_Display2(sWhere_ICMO) {
             var ajaxLoad = layer.load();
@@ -2642,6 +2773,27 @@
 
                         //鍒锋柊琛ㄦ牸鏁版嵁
                         DisPlay_HideColumn_ICMO();
+
+
+                        //鑾峰彇涓婃柟鎺掍骇鍒楄〃鏁版嵁,鐢ㄤ簬瀵规瘮涓嬫柟鐢熶骇璁㈠崟鍒楄〃锛屽皢涓嬫柟鐢熶骇璁㈠崟鍒楄〃鐩稿悓鐨勬暟鎹笉鏄剧ず
+                        var compareList = [];
+                        for (var i = 0; i < option.data.length; i++) {
+                            var temp = option.data[i]["婧愬崟涓诲唴鐮�"] + "|" + option.data[i]["婧愬崟瀛愬唴鐮�"];
+                            compareList.push(temp);
+                        }
+
+                        //鍓旈櫎涓婃柟鎺掍骇鍒楄〃涓凡缁忓姞鍏ョ殑鐢熶骇璁㈠崟
+                        var tables = [];
+                        for (var i = 0; i < option2.data.length; i++) {
+                            var temp = option2.data[i]["hmainid"] + "|" + option2.data[i]["HEntryID"];
+                            if ($.inArray(temp, compareList) == -1) {
+                                tables.push(option2.data[i]);
+                            }
+                        }
+                        option2.data = tables;
+
+                        //閲嶆柊娓叉煋瀛愯〃2
+                        table.render(option2);
 
                         layer.close(ajaxLoad);
                         //if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
@@ -2751,6 +2903,18 @@
             })
         }
 
+        function get_Export() {
+            var data = option.data
+            data.forEach((item) => {
+                // 濡傛灉鏌愪釜瀛楁鐨勫�煎お闀匡紝闇�瑕佸幓闄ゆ崲琛岀
+                if (item.瑙勬牸鍨嬪彿.length > 0) {  // 鍋囪瀛楁鍚嶄负field
+                    item.瑙勬牸鍨嬪彿 = item.瑙勬牸鍨嬪彿.replace(/[\r\n]+/g, '');  // 灏嗘崲琛岀鏇挎崲涓虹┖瀛楃涓�
+                    item.瑙勬牸鍨嬪彿 = item.瑙勬牸鍨嬪彿.replace(/[,]+/g, '锛�');  // 灏嗘崲鍒嗗彿鏇挎崲涓虹┖瀛楃涓�
+                }
+            });
+            table.exportFile(ins.config.id, data, "xls"); 
+        }
+
         //鎺掍骇鍔熻兘
         function set_Arrangement() {
             var checkStatus = table.checkStatus('mainTable_ICMO')
@@ -2771,57 +2935,17 @@
                 //    obj[key] = value;
                 //}
                 //鑾峰彇鍕鹃�変笂鐨勫緟鎺掔敓浜ц鍗�
+                //鑾峰彇鏁版嵁
+                var hmainid = [];
+                //var HEntryID = [];
                 for (var i = 0; i < checkStatus.data.length; i++) {
-                    var newObj = {
-                        "HMaterID" : data[i].HMaterID,
-                        "HProdORGID" : data[i].HPRDORGID,
-                        "HUnitID" : data[i].HUnitID,
-                        "HWorkShopID" : data[i].HDeptID,
-                        "鎷嗗崟鏁伴噺" : data[i].鐢熶骇浠诲姟鍗曟暟閲�,
-                        "婧愬崟涓诲唴鐮�" : data[i].hmainid,
-                        "婧愬崟瀛愬唴鐮�" : data[i].HEntryID,
-                        "鐗╂枡浠g爜" : data[i].浜у搧浠g爜,
-                        "鐗╂枡鍚嶇О" : data[i].浜у搧鍚嶇О,
-                        "鐢熶骇缁勭粐": data[i].鐢熶骇缁勭粐,
-                        "鐢熶骇璁㈠崟鍗曟嵁绫诲瀷" : data[i].鍗曟嵁绫诲瀷,
-                        "鐢熶骇璁㈠崟鍙�" : data[i].鍗曟嵁鍙�,
-                        "鐢熶骇璁㈠崟鏄庣粏琛屽彿" : data[i].HEntryID,
-                        "鐢熶骇杞﹂棿" : data[i].鐢熶骇杞﹂棿,
-                        "瑙勬牸鍨嬪彿" : data[i].瑙勬牸鍨嬪彿,
-                        "璁″垝寮�濮嬫棩鏈�" : data[i].璁″垝寮�宸ユ棩鏈�,
-                        "璁″垝鏁伴噺" : data[i].鐢熶骇浠诲姟鍗曟暟閲�,
-                        "璁″垝缁撴潫鏃ユ湡" : data[i].璁″垝瀹屽伐鏃ユ湡,
-                        "璁¢噺鍗曚綅" : data[i].璁¢噺鍗曚綅,
-                        "璁㈠崟鍙帓鏁伴噺" : data[i].鐢熶骇浠诲姟鍗曟暟閲�,
-                        "璁㈠崟绛夌骇" : data[i].璁㈠崟绛夌骇,
-                        "璁㈠崟绫诲瀷" : data[i].鍗曟嵁绫诲瀷,
-                        "閿�鍞鍗曞彿" : data[i].閿�鍞鍗曞彿,
-                        "閿�鍞鍗曟暟閲�" : data[i].閿�鍞暟閲�
-                    }
-
-                    option.data.push(newObj);
-                    table.render(option)
-                }
-
-                //鑾峰彇涓婃柟鎺掍骇鍒楄〃鏁版嵁,鐢ㄤ簬瀵规瘮涓嬫柟鐢熶骇璁㈠崟鍒楄〃锛屽皢涓嬫柟鐢熶骇璁㈠崟鍒楄〃鐩稿悓鐨勬暟鎹笉鏄剧ず
-                var compareList = [];
-                for (var i = 0; i < option.data.length; i++) {
-                    var temp = option.data[i]["婧愬崟涓诲唴鐮�"] + "|" + option.data[i]["婧愬崟瀛愬唴鐮�"];
-                    compareList.push(temp);
-                }
-
-                //鍓旈櫎涓婃柟鎺掍骇鍒楄〃涓凡缁忓姞鍏ョ殑鐢熶骇璁㈠崟
-                var tables = [];
-                for (var i = 0; i < option2.data.length; i++) {
-                    var temp = option2.data[i]["hmainid"] + "|" + option2.data[i]["HEntryID"];
-                    if ($.inArray(temp, compareList) == -1) {
-                        tables.push(option2.data[i]);
+                    if ($.inArray(checkStatus.data[i]["hmainid"] + '_' + checkStatus.data[i]["HEntryID"], hmainid) == -1) {
+                        hmainid.push(checkStatus.data[i]["hmainid"] + '_' + checkStatus.data[i]["HEntryID"]);
                     }
                 }
-                option2.data = tables;
 
-                //閲嶆柊娓叉煋瀛愯〃2
-                table.render(option2);
+                //鏌ヨ鐢熶骇璁㈠崟
+                SelectICMOBill(hmainid);
 
                 //var wait = layer.load();
                 ////閫昏緫鏂规硶
@@ -3109,6 +3233,7 @@
 
     //鍙屽嚮杩斿洖鐢熶骇璧勬簮
     function GetGySource(data) {
-        OptionData = data
+        OptionData[0] = data
     }
+
 </script>
\ No newline at end of file

--
Gitblit v1.9.1