From 424153b68fbbe9d0ec9b0cf01a9f7ece51fd6f20 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期二, 22 四月 2025 09:23:14 +0800
Subject: [PATCH] 三升排产：最大天数设置为100天
---
WebTM/views/生产管理/三升排产/JIT_DayPlanPlatForm.html | 324 ++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 304 insertions(+), 20 deletions(-)
diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatForm.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatForm.html"
index 7b880d8..6141465 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatForm.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\344\270\211\345\215\207\346\216\222\344\272\247/JIT_DayPlanPlatForm.html"
@@ -23,6 +23,7 @@
<form class="layui-form" action="" lay-filter="component-form-group">
<div style="padding: 10px; ">
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="ExcelImport" id="ExcelImport">Excel瀵煎叆</button>
+ <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="ExcelDateImport" id="ExcelDateImport">瀹屽伐鏃ユ湡瀵煎叆</button>
<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="btnAddICMO" id="btnAddICMO">娣诲姞璁㈠崟</button>
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">淇濆瓨</button>
@@ -31,9 +32,9 @@
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLock" id="btnLock">閿佸畾</button>
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlock" id="btnUnlock">瑙ｉ攣</button>
<!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLockRequest" id="btnLock">閿佸畾鐢宠</button>
- <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockRequest" id="btnUnlock">瑙ｉ攣鐢宠</button>-->
- <!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLockOrder" id="btnLockOrder">閿佸畾宸ュ崟</button>
- <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockOrder" id="btnUnlockOrder">瑙ｉ攣宸ュ崟</button>-->
+ <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockRequest" id="btnUnlock">瑙ｉ攣鐢宠</button>-->
+ <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnLockOrder" id="btnLockOrder">閿佸畾宸ュ崟</button>
+ <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnUnlockOrder" id="btnUnlockOrder">瑙ｉ攣宸ュ崟</button>
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnCompleteSetAnalysis" id="btnCompleteSetAnalysis">榻愬鍒嗘瀽</button>
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnTLYS" id="btnTLYS">鎻愭枡杩愮畻</button>
<!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btn_Calculate" id="btn_Calculate">娆犳枡杩愮畻</button>-->
@@ -644,7 +645,10 @@
form.on('submit(ExcelImport)', function () {
btnExcelImport();
});
-
+ //瀹屽伐瀵煎叆
+ form.on('submit(ExcelDateImport)', function () {
+ btnExcelDateImport();
+ });
//淇濆瓨
form.on('submit(btnSave)', function (data) {
var HWorkShopID = $("#HWorkShopID").val();//鐢熶骇杞﹂棿
@@ -1058,8 +1062,8 @@
var lastDay = new Date(year, month, 0).getDate(); //褰撴湀鏈�鍚庝竴澶�
var thisDay = new Date().getDay(); //褰撳ぉ鏄湰鏈堢鍑犲ぉ
- var valueList = [7, lastDay - thisDay+1,31,40];
- var titleList = ["7澶�", "鏈湀","31澶�","40澶�"];
+ var valueList = [7,30,40,50,60,70,80,90,100];
+ var titleList = ["7澶�","30澶�","40澶�","50澶�","60澶�","70澶�","80澶�","90澶�","100澶�"];
var HArrangeProductDayQty_ArrayList = '';
for (var i = 0; i < valueList.length; i++) {
@@ -1130,6 +1134,9 @@
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')], d, Format(myDate.getTime() + 10 * oneday, 'yyyy-MM-dd'));
@@ -1180,6 +1187,10 @@
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')], d, Format(myDate.getTime() + 20 * oneday, 'yyyy-MM-dd'));
@@ -1230,6 +1241,10 @@
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')], d, Format(myDate.getTime() + 30 * oneday, 'yyyy-MM-dd'));
@@ -1250,10 +1265,6 @@
return DayColor(d[Format(myDate.getTime() + 33 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 33 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 33 * oneday, 'yyyy-MM-dd'));
}
})//0
-
-
-
-
columns.push({
field: Format(myDate.getTime() + 34 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 34 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
return DayColor(d[Format(myDate.getTime() + 34 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 34 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 34 * oneday, 'yyyy-MM-dd'));
@@ -1264,37 +1275,34 @@
return DayColor(d[Format(myDate.getTime() + 35 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 35 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 35 * oneday, 'yyyy-MM-dd'));
}
})//0
-
columns.push({
field: Format(myDate.getTime() + 36 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 36 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
return DayColor(d[Format(myDate.getTime() + 36 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 36 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 36 * oneday, 'yyyy-MM-dd'));
}
})//0
-
columns.push({
field: Format(myDate.getTime() + 37 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 37 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
return DayColor(d[Format(myDate.getTime() + 37 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 37 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 37 * oneday, 'yyyy-MM-dd'));
}
})//0
-
columns.push({
field: Format(myDate.getTime() + 38 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 38 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
return DayColor(d[Format(myDate.getTime() + 38 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 38 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 38 * oneday, 'yyyy-MM-dd'));
}
})//0
-
columns.push({
field: Format(myDate.getTime() + 39 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 39 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
return DayColor(d[Format(myDate.getTime() + 39 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 39 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 39 * oneday, 'yyyy-MM-dd'));
}
})//0
+
+
columns.push({
field: Format(myDate.getTime() + 40 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 40 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
return DayColor(d[Format(myDate.getTime() + 40 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 40 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 40 * oneday, 'yyyy-MM-dd'));
}
})//0
-
columns.push({
field: Format(myDate.getTime() + 41 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 41 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
return DayColor(d[Format(myDate.getTime() + 41 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 41 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 41 * oneday, 'yyyy-MM-dd'));
@@ -1340,13 +1348,273 @@
return DayColor(d[Format(myDate.getTime() + 49 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 49 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 49 * oneday, 'yyyy-MM-dd'));
}
})//0
+
+
+
+
columns.push({
field: Format(myDate.getTime() + 50 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 50 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
return DayColor(d[Format(myDate.getTime() + 50 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 50 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 50 * oneday, 'yyyy-MM-dd'));
}
})//0
-
+ columns.push({
+ field: Format(myDate.getTime() + 51 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 51 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 51 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 51 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 51 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 52 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 52 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 52 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 52 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 52 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 53 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 53 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 53 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 53 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 53 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 54 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 54 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 54 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 54 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 54 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 55 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 55 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 55 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 55 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 55 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 56 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 56 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 56 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 56 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 56 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 57 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 57 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 57 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 57 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 57 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 58 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 58 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 58 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 58 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 58 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 59 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 59 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 59 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 59 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 59 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+
+
+ columns.push({
+ field: Format(myDate.getTime() + 60 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 60 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 60 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 60 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 60 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 61 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 61 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 61 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 61 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 61 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 62 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 62 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 62 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 62 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 62 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 63 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 63 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 63 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 63 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 63 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 64 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 64 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 64 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 64 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 64 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 65 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 65 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 65 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 65 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 65 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 66 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 66 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 66 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 66 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 66 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 67 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 67 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 67 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 67 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 67 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 68 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 68 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 68 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 68 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 68 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 69 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 69 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 69 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 69 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 69 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+
+
+
+
+ columns.push({
+ field: Format(myDate.getTime() + 70 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 70 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 70 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 70 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 70 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 71 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 71 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 71 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 71 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 71 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 72 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 72 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 72 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 72 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 72 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 73 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 73 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 73 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 73 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 73 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 74 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 74 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 74 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 74 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 74 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 75 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 75 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 75 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 75 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 75 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 76 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 76 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 76 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 76 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 76 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 77 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 77 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 77 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 77 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 77 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 78 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 78 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 78 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 78 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 78 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 79 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 79 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 79 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 79 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 79 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+
+
+
+ columns.push({
+ field: Format(myDate.getTime() + 80 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 80 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 80 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 80 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 80 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 81 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 81 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 81 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 81 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 81 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 82 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 82 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 82 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 82 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 82 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 83 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 83 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 83 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 83 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 83 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 84 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 84 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 84 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 84 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 84 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 85 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 85 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 85 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 85 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 85 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 86 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 86 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 86 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 86 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 86 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 87 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 87 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 87 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 87 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 87 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 88 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 88 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 88 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 88 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 88 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 89 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 89 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 89 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 89 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 89 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+
+
+
+ columns.push({
+ field: Format(myDate.getTime() + 90 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 90 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 90 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 90 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 90 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 91 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 91 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 91 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 91 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 91 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 92 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 92 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 92 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 92 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 92 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 93 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 93 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 93 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 93 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 93 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 94 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 94 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 94 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 94 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 94 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 95 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 95 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 95 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 95 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 95 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 96 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 96 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 96 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 96 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 96 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 97 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 97 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 97 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 97 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 97 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 98 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 98 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 98 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 98 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 98 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
+ columns.push({
+ field: Format(myDate.getTime() + 99 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 99 * oneday, 'MM-dd'), edit: 'text', width: 70, templet: function (d) {
+ return DayColor(d[Format(myDate.getTime() + 99 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 99 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 99 * oneday, 'yyyy-MM-dd'));
+ }
+ })//0
return columns;
}
//#endregion
@@ -1395,7 +1663,6 @@
columns.push({ field: '璁″垝鏁伴噺', title: '鐢熶骇璁㈠崟鏁伴噺', width: 150, filter: true, sort: true });//0
columns.push({ field: '鏃ヨ鍒掓暟閲忔�婚噺', title: '鏃ヨ鍒掓暟閲忔�婚噺', width: 150, filter: true, sort: true });//0
columns.push({ field: '浠婃棩涔嬪墠鏃ヨ鍒掓暟閲�', title: '浠婃棩涔嬪墠鏃ヨ鍒掓暟閲�', width: 150 });//0
- columns.push({ field: '鐢熶骇璁㈠崟鏃ユ湡', title: '鐢熶骇璁㈠崟鏃ユ湡', width: 150, templet: "<div>{{d.鐢熶骇璁㈠崟鏃ユ湡 ==null ?'':layui.util.toDateString(d.鐢熶骇璁㈠崟鏃ユ湡, 'yyyy-MM-dd')}}</div>", filter: true, sort: true });
columns.push({ field: '璁″垝寮�濮嬫棩鏈�', title: '棰勮寮�宸ユ棩鏈�', width: 150, templet: "<div>{{d.璁″垝寮�濮嬫棩鏈� ==null ?'':layui.util.toDateString(d.璁″垝寮�濮嬫棩鏈�, 'yyyy-MM-dd')}}</div>", filter: true, sort: true });
columns.push({ field: '璁″垝缁撴潫鏃ユ湡', title: '璁″垝缁撴潫鏃ユ湡', width: 150, templet: "<div>{{d.璁″垝缁撴潫鏃ユ湡 ==null ?'':layui.util.toDateString(d.璁″垝缁撴潫鏃ユ湡, 'yyyy-MM-dd')}}</div>", event: "HPlanEndDate", filter: true, sort: true });
columns.push({ field: '璁㈠崟鍙帓鏁伴噺', title: '璁㈠崟鍙帓鏁伴噺', width: 150, filter: true, sort: true});
@@ -1415,7 +1682,7 @@
columns.push({ field: 'T31', title: 'T31', width: 70 });//0
columns.push({ field: '璁㈠崟绫诲瀷', title: '璁㈠崟绫诲瀷', width: 150 });
columns.push({ field: '鐢熶骇璁㈠崟鍗曟嵁绫诲瀷', title: '婧愬崟璁㈠崟鍗曟嵁绫诲瀷', width: 150 });
- columns.push({ field: '涓氬姟鐘舵��', title: '涓氬姟鐘舵��', width: 150 });
+ columns.push({ field: '涓氬姟鐘舵��', title: '涓氬姟鐘舵��', width: 150, filter: true, sort: true });
columns.push({ field: '浜х嚎鍏ュ簱鏁伴噺', title: '浜х嚎鍏ュ簱鏁伴噺', width: 150 });
columns.push({ field: '鏈帓鏁伴噺', title: '鍙帓鏁伴噺', width: 150 });
columns.push({ field: '璁㈠崟绛夌骇', title: '璁㈠崟绛夌骇', width: 150 });
@@ -1425,6 +1692,7 @@
columns.push({ field: '鐢熶骇鍛ㄦ湡', title: '鐢熶骇鍛ㄦ湡', width: 150 });
columns.push({ field: '鏈�杩熷紑宸ユ棩鏈�', title: '鏈�杩熷紑宸ユ棩鏈�', width: 150, templet: "<div>{{d.鏈�杩熷紑宸ユ棩鏈� =='' ?'':layui.util.toDateString(d.鏈�杩熷紑宸ユ棩鏈�, 'yyyy-MM-dd')}}</div>" });
columns.push({ field: '鏈�杩熷畬宸ユ棩鏈�', title: '鏈�杩熷畬宸ユ棩鏈�', width: 150, templet: "<div>{{d.鏈�杩熷畬宸ユ棩鏈� =='' ?'':layui.util.toDateString(d.鏈�杩熷畬宸ユ棩鏈�, 'yyyy-MM-dd')}}</div>" });
+ columns.push({ field: '鐢熶骇璁㈠崟鏃ユ湡', title: '鐢熶骇璁㈠崟鏃ユ湡', width: 150, templet: "<div>{{d.鐢熶骇璁㈠崟鏃ユ湡 ==null ?'':layui.util.toDateString(d.鐢熶骇璁㈠崟鏃ユ湡, 'yyyy-MM-dd')}}</div>", filter: true, sort: true });
columns.push({ field: '鐢熶骇杞﹂棿', title: '鐢熶骇杞﹂棿', width: 150 });
columns.push({ field: '婧愬崟涓诲唴鐮�', title: '婧愬崟涓诲唴鐮�', width: 150 });
columns.push({ field: '婧愬崟瀛愬唴鐮�', title: '婧愬崟瀛愬唴鐮�', width: 150 });
@@ -1761,6 +2029,21 @@
, title: 'Excel瀵煎叆'
, shift: 0//寮瑰嚭鍔ㄧ敾
, content: '../鐢熶骇璁″垝骞冲彴/JIT_DayPlanPlatFormImport.html?OperationType=1'
+ , end: function () {
+ //鍒锋柊椤甸潰,
+ location.reload();
+ }
+ })
+ }
+ //Excel瀹屽伐鏃ユ湡瀵煎叆
+ function btnExcelDateImport() {
+ layer.open({
+ type: 2
+ , skin: 'layui-layer-rim' //鍔犱笂杈规
+ , area: ['100%', '100%']
+ , title: 'Excel瀵煎叆'
+ , shift: 0//寮瑰嚭鍔ㄧ敾
+ , content: '../涓夊崌鎺掍骇/JIT_DayPlanPlatFormImport_SS.html?OperationType=1'
, end: function () {
//鍒锋柊椤甸潰,
location.reload();
@@ -2470,7 +2753,8 @@
HPlanDay = data1.data[0].DayNum;
} else {
- layer.alert(data1.code + data1.Message, { icon: 5 });
+ //layer.alert(data1.code + data1.Message, { icon: 5 });鍘绘帀鏃犵敤鎻愮ず
+
}
}, error: function () {
layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
@@ -2522,7 +2806,7 @@
//鎵惧埌鏈换鍔″崟 鍙敤鐢熶骇璧勬簮
lMainID = option.data[i]["HICMOInterID"];
sICMOBillNo = option.data[i]["鐢熶骇璁㈠崟鍙�"];
- dEndDate = Format(option.data[i]["鏈�杩熷畬宸ユ棩鏈�"], 'yyyy/MM/dd');
+ dEndDate = Format(option.data[i]["璁″垝缁撴潫鏃ユ湡"], 'yyyy/MM/dd');
sProdTimes = option.data[i]["鐢熶骇鍛ㄦ湡"];
sPlanQty = option.data[i]["鎷嗗崟鏁伴噺"];
lHGroupID = option.data[i]["HGroupID"];
--
Gitblit v1.9.1