From e57b2edbffff5a653ba9eda65eae100ceb2e7822 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期一, 01 九月 2025 16:16:41 +0800
Subject: [PATCH] 乔一：客户物料即时库存报表、客户手工抄包报表
---
WebTM/views/生产管理/三升排产/JIT_DayPlanPlatForm.html | 660 +++++++++++++++++++++++++++++++++++++++++++++++------------
1 files changed, 527 insertions(+), 133 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 211f183..99c612f 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"
@@ -2,38 +2,41 @@
<html>
<head>
<meta charset="utf-8" />
- <title>鐢熶骇璁″垝鎺掍骇</title>
+ <title>涓夊崌鐢熶骇璁″垝鎺掍骇</title>
<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
+ <link rel="stylesheet" href="../../../layuiadmin/ext/soulTable.css" media="all">
<script src="../../../layuiadmin/layui/layui.js"></script>
- <script src="../../../layuiadmin/Scripts/json2.js"></script>
- <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
+ <!--<script src="../../../layuiadmin/Scripts/json2.js"></script>-->
+ <!--<script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>-->
<script src="../../../layuiadmin/Scripts/webConfig.js"></script>
<script src="../../../layuiadmin/PubCustom.js"></script>
<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
- <script src="../../../layuiadmin/soulTable.slim.js"></script>
+ <!--<script src="../../../layuiadmin/soulTable.slim.js"></script>-->
<script src="../../../layuiadmin/SetColumn.js"></script>
</head>
<body>
<div class="layui-fluid">
- <div class="layui-col-md12">
+ <div class="layui-col-md13">
<div class="layui-card" style="padding: 1px">
<div class="layui-card-body" style="padding: 1px;">
<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>
- <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="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="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="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="btnYLYS" id="btnYLYS">瑕佹枡杩愮畻</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>-->
<!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnRoutEdit" id="btnRoutEdit">宸ヨ壓璺嚎</button>-->
@@ -247,10 +250,10 @@
</div>
</div>
<div id="HProgressBar"></div>
- <div class="layui-row" style="padding:10px 0">
+ <div class="layui-row" style="padding:0px 0">
<table class="" id="mainTable" lay-filter="mainTable"></table>
</div>
- <div class="resizable-container layui-tab layui-tab-card" style="margin-top:40px;">
+ <div class="resizable-container layui-tab layui-tab-card" style="margin-top: 40px; display: none;">
<ul class="layui-tab-title">
<li class="layui-this">鐢熶骇璁㈠崟</li>
<li>缂烘枡鍒嗘瀽</li>
@@ -300,22 +303,23 @@
<script type="text/html" id="toolbarDemo">
<div class="layui-btn-container">
<!--<button type="button" class="layui-btn layui-btn-sm" lay-event="set_BatchFill"><i class="layui-icon layui-icon-file-b"></i>鎵归噺濉厖</button>
- <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>缂栬緫</button>-->
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>缂栬緫</button>-->
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-CopyLine"><i class="layui-icon layui-icon-form"></i>澶嶅埗琛�</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>鍒犻櫎琛�</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_MoverUp"><i class="layui-icon layui-icon-delete"></i>涓婄Щ</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_MoverDown"><i class="layui-icon layui-icon-delete"></i>涓嬬Щ</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_Priority"><i class="layui-icon layui-icon-delete"></i>浼樺厛绾�</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_ReadyAsc"><i class="layui-icon layui-icon-delete"></i>鍑嗗鎺掑簭</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ReadyWorkQty"><i class="layui-icon layui-icon-delete"></i>鍑嗗(鍚屾浜ц兘)</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_Souce"><i class="layui-icon layui-icon-delete"></i>閫変骇绾�</button>
- <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Emp"><i class="layui-icon layui-icon-delete"></i>閫夋搷浣滃伐</button>
+ <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="set_Emp"><i class="layui-icon layui-icon-delete"></i>閫夋搷浣滃伐</button>-->
<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">
+ <!--<script type="text/html" id="toolbarDemo2">
<div class="layui-btn-container">
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_Arrangement"><i class="layui-icon layuiiconform"></i>鎺掍骇</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn_ICMO"><i class="layui-icon layuiiconform"></i>鍒楄缃�</button>
@@ -327,7 +331,7 @@
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn_Material"><i class="layui-icon layuiiconform"></i>鍒楄缃�</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Close"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button>
</div>
- </script>
+ </script>-->
</form>
</div>
</div>
@@ -346,7 +350,8 @@
base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰�
}).extend({
index: 'lib/index', //涓诲叆鍙ｆā鍧�
- }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'soulTable','jquery'], function () {
+ soulTable: 'soulTable'
+ }).use(['index', 'form', 'table', 'element', 'laydate', 'util', 'soulTable','jquery'], function () {
//#region 鍏敤鍙橀噺
var $ = layui.$
@@ -355,7 +360,6 @@
, table = layui.table
, form = layui.form
, laydate = layui.laydate
- , excel = layui.excel
, soulTable = layui.soulTable
, element = layui.element;
var ins;
@@ -426,25 +430,29 @@
return layer.msg("鎷嗗崟鏁伴噺涓嶈兘涓�0!");
}
- if (SumHQty > (parseInt(obj.data["璁″垝鏁伴噺"]))) {
+ if (SumHQty > (parseInt(obj.data["璁″垝鏁伴噺"])) && obj.field == "鎷嗗崟鏁伴噺") {
obj.update({
- "鎷嗗崟鏁伴噺": "0"
+ "鎷嗗崟鏁伴噺": $(this).prev().text()
});
+
+ obj.tr.find('td[data-field=鎷嗗崟鏁伴噺] input').val($(this).prev().text()); // 杩欏彞浠ｇ爜鏄繀瑕佺殑鏇存柊鏄剧ず鍐呭
+
return layer.msg("鎷嗗崟鏁伴噺澶т簬璁㈠崟鏁伴噺!");
}
var NowDate = obj.field;
- if (dateHQty > (parseInt(obj.data["璁″垝鏁伴噺"]))) {
+ if (dateHQty > (parseInt(obj.data["鎷嗗崟鏁伴噺"]))) {
obj.update({
"鏃ヨ鍒掓暟閲忔�婚噺": dateHQty - obj.value,
[NowDate]: 0
});
- return layer.msg("鎺掍骇鏁伴噺澶т簬璁㈠崟鏁伴噺!")
+ obj.tr.find(`td[data-field=${NowDate}] input`).val(0); // 杩欏彞浠ｇ爜鏄繀瑕佺殑鏇存柊鏄剧ず鍐呭
+ return layer.msg("鎺掍骇鏁伴噺澶т簬鎷嗗崟鏁伴噺!")
}
- if (Date.parse(obj.field) > Date.parse(obj.data.璁″垝缁撴潫鏃ユ湡)) {
- return layer.msg("鎺掍骇鏃ユ湡瓒呭嚭璁″垝缁撴潫鏃ユ湡!");
- }
+ //if (Date.parse(obj.field) > Date.parse(obj.data.璁″垝缁撴潫鏃ユ湡)) {
+ // return layer.msg("鎺掍骇鏃ユ湡瓒呭嚭璁″垝缁撴潫鏃ユ湡!");
+ //}
//淇敼鏁版嵁
@@ -582,6 +590,29 @@
case 'set_ReadyAsc':
set_ReadyAsc();
break;
+ //鍑嗗鍚屾浜ц兘
+ case 'set_ReadyWorkQty':
+ layer.confirm('浣犵‘瀹氳鎵ц鎿嶄綔鍚楋紝璇峰厛纭繚鎺掍骇鏁版嵁宸蹭繚瀛橈紵', {
+ btn: ['纭畾', '鍙栨秷'] //鎸夐挳
+ , btn1: function (index, layero) {
+ // 1. 鑾峰彇鈥滅‘瀹氣�濇寜閽苟娣诲姞鍔犺浇鍔ㄧ敾
+ var confirmBtn = $(layero).find('.layui-layer-btn0'); // 纭畾鎸夐挳
+ confirmBtn.html('<i class="layui-icon layui-icon-loading layui-anim layui-anim-rotate"></i> 澶勭悊涓�...');
+ confirmBtn.prop('disabled', true);
+ if (data.length <= 0) {
+ layer.msg("璇烽�夋嫨鏁版嵁")
+ layer.close(index);
+ } else {
+ setTimeout(function () {
+ get_btnReady(data);
+ layer.close(index);
+ }, 5); // 寤惰繜鎵ц纭繚鎸夐挳鍥炬爣娓叉煋瀹�
+ }
+
+
+ }
+ })
+ break;
//閫変骇绾�
case 'set_Souce':
set_Souce(data);
@@ -643,7 +674,10 @@
form.on('submit(ExcelImport)', function () {
btnExcelImport();
});
-
+ //瀹屽伐瀵煎叆
+ form.on('submit(ExcelDateImport)', function () {
+ btnExcelDateImport();
+ });
//淇濆瓨
form.on('submit(btnSave)', function (data) {
var HWorkShopID = $("#HWorkShopID").val();//鐢熶骇杞﹂棿
@@ -720,7 +754,16 @@
})
}
})
-
+ //瑕佹枡杩愮畻
+ form.on('submit(btnYLYS)', function (data) {
+ layer.confirm('浣犵‘瀹氳鎵ц鎿嶄綔鍚楋紝璇峰厛纭繚鎺掍骇鏁版嵁宸蹭繚瀛橈紵', {
+ btn: ['纭畾', '鍙栨秷'] //鎸夐挳
+ , btn1: function (index, layero) {
+ get_btnYLYS();
+ layer.close(index);
+ }
+ })
+ })
//鎻愭枡杩愮畻
form.on('submit(btnTLYS)', function (data) {
if (set_ModCheck("Sc_WorkBillSortBill_tlys") == true) {
@@ -1010,10 +1053,10 @@
var ajaxLoad = layer.load();
//杩涘叆椤甸潰鏄剧ず鐨勭紦瀛樺垪琛�
$.ajax({
- url: GetWEBURL() + '/Gy_Department/list',
+ url: GetWEBURL() + '/Gy_Department/cx',
type: "GET",
async: false,
- data: { "sWhere": "and HItemID = " + HWorkShopID, "user": sessionStorage["HUserName"], "Organization": sessionStorage["Organization"] },
+ data: { "HInterID": HWorkShopID },
success: function (data1) {
if (data1.count == 1) {
$("#HWorkShopID").val(HWorkShopID);
@@ -1045,8 +1088,9 @@
Organ();
//鍒濆鍖栬〃鏍�
set_InitGrid();
- get_FastQuery(1);
- get_FastQuery_ICMO();
+ get_FastQuery(2);
+ //鐢熶骇璁㈠崟鏌ヨ
+ /*get_FastQuery_ICMO();*/
}
//#region 鍒濆鍖栦笅鎷夊垪琛� 鎺掍骇鏃堕棿
function setSelect_HArrangeProductDayQty() {
@@ -1057,8 +1101,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++) {
@@ -1067,9 +1111,10 @@
$("#HArrangeProductDayQty").empty();
$("#HArrangeProductDayQty").append(HArrangeProductDayQty_ArrayList);
- form.render('select');
+
$("#HArrangeProductDayQty").val("40");
+ form.render('select');
}
//#endregion
@@ -1129,6 +1174,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'));
@@ -1179,6 +1227,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'));
@@ -1229,6 +1281,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'));
@@ -1249,10 +1305,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'));
@@ -1263,37 +1315,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'));
@@ -1339,13 +1388,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
@@ -1382,38 +1691,39 @@
columns.push({ type: 'checkbox', fixed: 'left'});
columns.push({ type: 'numbers', field: '搴忓彿', title: '搴忓彿'});
columns.push({ field: '鍗曟嵁鍙�', title: '鍗曟嵁鍙�', hide: true});
- columns.push({ field: '閿�鍞鍗曞彿', title: '閿�鍞鍗曞彿', width: 150});
- columns.push({ field: '鐢熶骇璁㈠崟鍙�', title: '鐢熶骇璁㈠崟鍙�', width: 150, style: 'background-color: #f9f9f9;' });
- columns.push({ field: '瀹㈡埛璁㈠崟鍙�', title: '瀹㈡埛璁㈠崟鍙�', width: 150, style: 'background-color: #f9f9f9;' });
- columns.push({ field: '鐢熶骇缁勭粐', title: '鐢熶骇缁勭粐', width: 150 });
- columns.push({ field: '鐗╂枡浠ｇ爜', title: '鐗╂枡缂栫爜', width: 150});
- columns.push({ field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 150});
- columns.push({ field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 150 });
- columns.push({ field: '灏忔椂浜ц兘', title: '灏忔椂浜ц兘', width: 150, edit: 'text' });
- columns.push({ field: '閿�鍞鍗曟暟閲�', title: '閿�鍞鍗曟暟閲�', width: 150 });//0
- columns.push({ field: '璁″垝鏁伴噺', title: '鐢熶骇璁㈠崟鏁伴噺', width: 150 });//0
- columns.push({ field: '鏃ヨ鍒掓暟閲忔�婚噺', title: '鏃ヨ鍒掓暟閲忔�婚噺', width: 150 });//0
+ columns.push({ field: '閿�鍞鍗曞彿', title: '閿�鍞鍗曞彿', width: 150, filter: true, sort: true});
+ columns.push({ field: '鐢熶骇璁㈠崟鍙�', title: '鐢熶骇璁㈠崟鍙�', width: 150, style: 'background-color: #f9f9f9;', filter: true, sort: true });
+ columns.push({ field: '瀹㈡埛璁㈠崟鍙�', title: '瀹㈡埛璁㈠崟鍙�', width: 150, style: 'background-color: #f9f9f9;', filter: true, sort: true });
+ columns.push({ field: '鐢熶骇缁勭粐', title: '鐢熶骇缁勭粐', width: 150, sort: true });
+ columns.push({ field: '鐗╂枡浠ｇ爜', title: '鐗╂枡缂栫爜', width: 150, filter: true, sort: true});
+ columns.push({ field: '鐗╂枡鍚嶇О', title: '鐗╂枡鍚嶇О', width: 150, filter: true, sort: true});
+ columns.push({ field: '瑙勬牸鍨嬪彿', title: '瑙勬牸鍨嬪彿', width: 150, filter: true, sort: true });
+ columns.push({ field: '灏忔椂浜ц兘', title: '灏忔椂浜ц兘', width: 150, edit: 'text', filter: true, sort: true });
+ //0
+ 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>" });
- columns.push({ field: '璁″垝缁撴潫鏃ユ湡', title: '璁″垝缁撴潫鏃ユ湡', width: 150, templet: "<div>{{d.璁″垝缁撴潫鏃ユ湡 ==null ?'':layui.util.toDateString(d.璁″垝缁撴潫鏃ユ湡, 'yyyy-MM-dd')}}</div>", event: "HPlanEndDate" });
- columns.push({ field: '璁㈠崟鍙帓鏁伴噺', title: '璁㈠崟鍙帓鏁伴噺', width: 150 });
- columns.push({ field: '鎷嗗崟鏁伴噺', title: '鎷嗗崟鏁伴噺', width: 150, edit: 'text' });
- columns.push({ field: '鏄ㄦ棩鏁伴噺', title: '鏄ㄦ棩鏁伴噺' });
- columns.push({ field: '浼樺厛绾�', title: '浼樺厛绾�', width: 150, edit: 'text' });
- columns.push({ field: '鐢熶骇璧勬簮', title: '鐢熶骇璧勬簮', width: 150, edit: 'text', event: "HSourceID" });
- columns.push({ field: '鎿嶄綔宸�', title: '鎿嶄綔宸�', width: 150, edit: 'text', event: "HEmpID" });
+ 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, sort: true});
+ columns.push({ field: '鎷嗗崟鏁伴噺', title: '鎷嗗崟鏁伴噺', width: 150, edit: 'text', filter: true, sort: true });
+ columns.push({ field: '鏄ㄦ棩鏁伴噺', title: '鏄ㄦ棩鏁伴噺', filter: true, sort: true });
+ columns.push({ field: '浼樺厛绾�', title: '浼樺厛绾�', width: 150, edit: 'text', filter: true, sort: true });
+ columns.push({ field: '鐢熶骇璧勬簮', title: '鐢熶骇璧勬簮', width: 150, edit: 'text', event: "HSourceID", filter: true, sort: true });
+ columns.push({ field: '鎿嶄綔宸�', title: '鎿嶄綔宸�', width: 150, edit: 'text', event: "HEmpID", filter: true, sort: true });
var dateColumns = setInit_columnsData();
var HArrangeProductDayQty = $("#HArrangeProductDayQty").val() * 1;
for (var i = 0; i < HArrangeProductDayQty; i++) {
columns.push(dateColumns[i]);//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 });
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 });
@@ -1423,6 +1733,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, sort: true });
columns.push({ field: '鐢熶骇杞﹂棿', title: '鐢熶骇杞﹂棿', width: 150 });
columns.push({ field: '婧愬崟涓诲唴鐮�', title: '婧愬崟涓诲唴鐮�', width: 150 });
columns.push({ field: '婧愬崟瀛愬唴鐮�', title: '婧愬崟瀛愬唴鐮�', width: 150 });
@@ -1442,17 +1753,43 @@
columns.push({ field: 'HEmpID', title: 'HEmpID', hide: true });
columns.push({ field: '鎷嗗崟姹囨姤鏁伴噺', title: '鎷嗗崟姹囨姤鏁伴噺', width: 150, edit: 'text' });
columns.push({ field: '閿佸畾宸ュ崟', title: '閿佸畾宸ュ崟', width: 150, filter: true });//0
- columns.push({ fixed: 'right', title: '鎿嶄綔', toolbar: '#barDemo' });
+ columns.push({ fixed: 'right', field: '鎿嶄綔', title: '鎿嶄綔', toolbar: '#barDemo' });
option_columns = columns;
option = {
elem: '#mainTable'
, toolbar: '#toolbarDemo'
- , height: 'full-120'
+ , title: "璁″垝鎶ヨ〃"
+ , height: 'full-175'
, page: false
, cellMinWidth: 90
, cols: [columns]
- , limit: Number.MAX_VALUE//榛樿鏄剧ず鍏ㄩ儴
- , even: true
+ , limit: 5000//榛樿鏄剧ず鍏ㄩ儴
+ , contextmenu: {
+ // 琛ㄦ牸鍐呭鍙抽敭鑿滃崟閰嶇疆
+ body: [
+ {
+ name: '澶嶅埗',
+ icon: 'layui-icon layui-icon-template',
+ click: function (obj) {
+ soulTable.copy(obj.text)
+ layer.msg('澶嶅埗鎴愬姛锛�')
+ }
+ },
+ {
+ name: '琛�-钃濊壊',
+ click: function (obj) {
+ obj.trElem.css('background', '#01AAED')
+ }
+ },
+ {
+ name: '绾㈣壊',
+ click: function (obj) {
+ obj.elem.css('color', 'red')
+ }
+ }
+ ]
+ }
+ , even: true//琛屾嫋鎷�
, rowDrag: {/*trigger: 'row',*/
done: function (obj) {
// 瀹屾垚鏃讹紙鏉惧紑鏃讹級瑙﹀彂
@@ -1481,17 +1818,17 @@
}
, done: function (res, page, count) {
soulTable.render(this);
- $('.layui-table thead').on('click', 'th', function () {
- // 鑾峰彇鐐瑰嚮鐨勮〃澶寸殑 field 鍊�
- var field = $(this).data('field');
- set_InitGrid1(field);
- sWhere = {
- HORGID: sessionStorage["OrganizationID"]
- , HBEGINDATE: field
- , HENDDATE: field
- }
- //get_Display_3(JSON.stringify(sWhere));
- });
+ //$('.layui-table thead').on('click', 'th', function () {
+ // // 鑾峰彇鐐瑰嚮鐨勮〃澶寸殑 field 鍊�
+ // var field = $(this).data('field');
+ // set_InitGrid1(field);
+ // sWhere = {
+ // HORGID: sessionStorage["OrganizationID"]
+ // , HBEGINDATE: field
+ // , HENDDATE: field
+ // }
+ // //get_Display_3(JSON.stringify(sWhere));
+ //});
//res.data.forEach(function (item, index) {
// if (data1.data.DataColor != undefined) {
// var sj = data1.data.DataColor;
@@ -1510,6 +1847,8 @@
//})
}
}
+
+ table.render(option);
}
//缂烘枡鍒嗘瀽琛ㄦ牸鏁版嵁
@@ -1546,7 +1885,7 @@
$.ajax({
url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillList',
type: "GET",
- async: false,
+ async: true,
data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
success: function (data1) {
if (data1.count == 1) {
@@ -1560,12 +1899,8 @@
}
layer.close(ajaxLoad);
if (HinterID_S.length > 0) {
- get_Display_1(HinterID_S);
- get_Display_2(HinterID_S)
- }
-
- if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
- ColFilter();
+ /*get_Display_1(HinterID_S);*/
+ get_Display_2(HinterID_S);
}
} else {
@@ -1585,7 +1920,7 @@
$.ajax({
url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHinterIDList',
type: "GET",
- async: false,
+ async: true,
data: { "sWhere": HinterID_S.toString(),"num":1 },
success: function (data1) {
if (data1.count == 1) {
@@ -1651,7 +1986,7 @@
$.ajax({
url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHinterIDList',
type: "GET",
- async: false,
+ async: true,
data: { "sWhere": HinterID_S.toString(), "num": 2 },
success: function (data1) {
if (data1.count == 1) {
@@ -1758,7 +2093,22 @@
, area: ['100%', '100%']
, title: 'Excel瀵煎叆'
, shift: 0//寮瑰嚭鍔ㄧ敾
- , content: '../鐢熶骇璁″垝骞冲彴/JIT_DayPlanPlatFormImport.html?OperationType=1'
+ , content: '../涓夊崌鎺掍骇/JIT_DayPlanPlatFormImport_SS_Sec.html?OperationType=1'
+ , end: function () {
+ //鍒锋柊椤甸潰,
+ location.reload();
+ }
+ })
+ }
+ //Excel瀹屽伐鏃ユ湡瀵煎叆
+ function btnExcelDateImport() {
+ layer.open({
+ type: 2
+ , skin: 'layui-layer-rim' //鍔犱笂杈规
+ , area: ['100%', '100%']
+ , title: '浜ゆ湡瀵煎叆'
+ , shift: 0//寮瑰嚭鍔ㄧ敾
+ , content: '../涓夊崌鎺掍骇/JIT_DayPlanPlatFormImport_SS.html?OperationType=1'
, end: function () {
//鍒锋柊椤甸潰,
location.reload();
@@ -1985,7 +2335,7 @@
if (HICMOBillNo_ICMO) {
sWhere_ICMO += " and (瀹㈡埛璁㈠崟鍙� like '%" + HICMOBillNo_ICMO + "%' or 鍗曟嵁鍙� like '%" + + HICMOBillNo_ICMO + "%')";
}
- sWhere_ICMO += " and 鐘舵�� like '%寮�宸�%' or 鐘舵�� like '%璁″垝纭%'";
+ sWhere_ICMO += " and (鐘舵�� like '%寮�宸�%' or 鐘舵�� like '%璁″垝纭%')";
get_Display2(sWhere_ICMO);
sWhere_ICMO = ""//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
}
@@ -2082,7 +2432,33 @@
}
});
}
-
+ //瑕佹枡杩愮畻
+ function get_btnYLYS() {
+ sWhere = {
+ HProdORGID: $("#HProdORGID").val()
+ , HWorkShopID: $("#HWorkShopID").val()
+ }
+ sWhere = JSON.stringify(sWhere);
+ var ajaxLoad = layer.load();
+ $.ajax({
+ url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/JIT_YLYS',
+ type: "GET",
+ data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
+ success: function (data1) {
+ if (data1.count == 1) {
+ get_FastQuery(2);
+ layer.msg(data1.Message);
+ layer.close(ajaxLoad);
+ } else {
+ layer.close(ajaxLoad);
+ layer.alert(data1.Message, { icon: 5 });
+ }
+ }, error: function () {
+ layer.close(ajaxLoad);
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ });
+ }
//鎻愭枡杩愮畻
function get_btnTLYS() {
if ($("#HWorkShopID").val() == 0) {
@@ -2256,10 +2632,10 @@
//鍑嗗
- function get_btnReady() {
- var data = table.cache["mainTable"];
+ function get_btnReady(data) {
+ /*var data = table.cache["mainTable"];*/
var HTotalDataList = [[]];
-
+ var ajaxData;
var index = 0;
var countEveryGroup = 50;
for (var i = 0; i < data.length; i++) {
@@ -2267,7 +2643,8 @@
return layer.msg("璇峰厛杩涜淇濆瓨!!")
}
if (isNaN(data[i]["HSourceID"])) {
- return layer.msg("閫夋嫨鐢熶骇璧勬簮!!")
+ data[i]["HSourceID"] = 0
+ /*return layer.msg("閫夋嫨鐢熶骇璧勬簮!!")*/
}
if ((index / countEveryGroup).toFixed(0)*1 == HTotalDataList.length) {
@@ -2287,22 +2664,26 @@
HICOMNum = HTotalDataList[t];
$.ajax({
- url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/ReadyData',
+ url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/ReadyData_SS',
async: false,
type: "GET",
data: { "SWhere": HICOMNum.toString() },
success: function (data1) {
if (data1.count == 1) {
+ ajaxData = data1.data;
for (var i = 0; i < data1.data.length; i++) {
for (var j = 0; j < option.data.length; j++) {
if (data1.data[i]["HICMOInterID"] == option.data[j]["HICMOInterID"] && data1.data[i]["HICMOEntryID"] == option.data[j]["HICMOEntryID"]) {
option.data[j]["灏忔椂浜ц兘"] = data1.data[i]["灏忔椂浜ц兘"];
+ option.data[j]["HSourceID"] = data1.data[i]["HSourceID"];
+ option.data[j]["鐢熶骇璧勬簮"] = data1.data[i]["鐢熶骇璧勬簮"];
option.data[j]["鐢熶骇鍛ㄦ湡"] = data1.data[i]["鐢熶骇鍛ㄦ湡"];
option.data[j]["寮�宸ヤ綑閲�"] = data1.data[i]["寮�宸ヤ綑閲�"];
option.data[j]["鏈�杩熷紑宸ユ棩鏈�"] = data1.data[i]["鏈�杩熷紑宸ユ棩鏈�"];
option.data[j]["鏈�杩熷畬宸ユ棩鏈�"] = data1.data[i]["鏈�杩熷畬宸ユ棩鏈�"];
option.data[j]["璁㈠崟闇�姹傛暟閲�"] = data1.data[i]["璁㈠崟闇�姹傛暟閲�"];
option.data[j]["璁㈠崟浜よ揣鏈�"] = data1.data[i]["璁㈠崟浜よ揣鏈�"] < "2020-01-01 0:00:00" ? "1900-01-01" : data1.data[i]["璁㈠崟浜よ揣鏈�"];
+
break;
}
}
@@ -2352,10 +2733,10 @@
}
table.render(option);
- set_Priority();
- 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) {
+ /*set_Priority();*/
+ /*data = table.cache["mainTable"];*/
+ for (var i = 0; i < ajaxData.length; i++) {
+ if (parseFloat(ajaxData[i]["灏忔椂浜ц兘"]) == 0 || parseFloat(ajaxData[i]["灏忔椂浜ц兘"]) == null || parseFloat(ajaxData[i]["灏忔椂浜ц兘"]) == undefined) {
msg += "绗�" + (i + 1) + '琛岋紝灏忔椂浜ц兘鏈缃紝璇锋牳瀵规暟鎹��' + '</br>' + '1.鐗╂枡鏈坊鍔犲伐鑹鸿矾绾�' + '</br>' + '2.宸ヨ壓璺嚎涓湭璁剧疆灏忔椂浜ц兘' + '</br>' + '3.鐢熶骇璧勬簮鏈缃崟鐝伐鏃�' + '</br>' + '4.鐢熶骇璧勬簮涓粦瀹氬伐浣滀腑蹇冧笌宸ヨ壓璺嚎涓缃殑宸ヤ綔涓績涓嶄竴鑷�';
}
}
@@ -2468,7 +2849,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 });
@@ -2476,7 +2858,7 @@
});
//鏍规嵁杞﹂棿鍒犻櫎娌℃湁閿佸畾鐨勬暟鎹�
- var sql = "delete from Sc_WorkBillSortBillSub where HMasterDate>=convert(varchar(10) ,DATEADD(DAY," + HPlanDay + ",GETDATE()),20) and HInterID in(select HInterID from Sc_WorkBillSortBillMain where HWorkShopID=" + HWorkShopID + " and HLockOrder != 1 )";
+ var sql = "delete from Sc_WorkBillSortBillSub where HMasterDate>=convert(varchar(10) ,DATEADD(DAY," + HPlanDay + ",GETDATE()),20) and HInterID in(select HInterID from Sc_WorkBillSortBillMain where HWorkShopID=" + HWorkShopID + " and HLockOrder != 1 ) or HMasterDate < CAST(GETDATE() AS DATE)";
$.ajax({
url: GetWEBURL() + '/Gy_SOPBillList/UpDelSQL',
type: "GET",
@@ -2516,11 +2898,14 @@
SDSum += TableData[i][option.cols[0][j].field];
}
}
-
+ //璺宠繃 閿佸畾宸ュ崟
+ if (option.data[i].閿佸畾宸ュ崟 == "鏄�") {
+ continue;
+ }
//鎵惧埌鏈换鍔″崟 鍙敤鐢熶骇璧勬簮
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"];
@@ -2641,8 +3026,10 @@
iRow = i + 1;
//灏嗘暟鎹帓鍒扮綉鏍间腑
SetInfoToGrid(option, dsSub, null, (iRow - 1), iLeftQty, sWorkQty, false, HPlanDay);
-
- set_AddNew1(option.data[i]);
+ //鑻ュ伐鍗曡閿佸畾浜嗚烦杩囦繚瀛樺唴瀹�
+ if (option.data[i]["閿佸畾宸ュ崟"] == "鍚�") {
+ set_AddNew1(option.data[i]);
+ }
}
bFind = true;
}
@@ -3242,13 +3629,21 @@
layer.confirm('浣犵‘瀹氳鎵ц浼樺厛绾ф搷浣滃悧锛�', {
btn: ['纭畾', '鍙栨秷'] //鎸夐挳
, btn1: function (index, layero) {
+ // 1. 鑾峰彇鈥滅‘瀹氣�濇寜閽苟娣诲姞鍔犺浇鍔ㄧ敾
+ var confirmBtn = $(layero).find('.layui-layer-btn0'); // 纭畾鎸夐挳
+ confirmBtn.html('<i class="layui-icon layui-icon-loading layui-anim layui-anim-rotate"></i> 澶勭悊涓�...');
+ confirmBtn.prop('disabled', true);
var data = table.cache["mainTable"];
for (var i = 0; i < data.length; i++) {
data[i]["浼樺厛绾�"] = ((i + 1) * 5);
}
option.data = data;
- table.render(option);
- layer.close(index);
+ setTimeout(function () {
+ table.reload('mainTable', { data: data });
+ layer.close(index);
+ }, 5); // 寤惰繜鎵ц纭繚鎸夐挳鍥炬爣娓叉煋瀹�
+
+
}
})
}
@@ -3258,6 +3653,10 @@
layer.confirm('浣犵‘瀹氳鎵ц鎺掑簭鎿嶄綔鍚楋紵', {
btn: ['纭畾', '鍙栨秷'] //鎸夐挳
, btn1: function (index, layero) {
+ // 1. 鑾峰彇鈥滅‘瀹氣�濇寜閽苟娣诲姞鍔犺浇鍔ㄧ敾
+ var confirmBtn = $(layero).find('.layui-layer-btn0'); // 纭畾鎸夐挳
+ confirmBtn.html('<i class="layui-icon layui-icon-loading layui-anim layui-anim-rotate"></i> 澶勭悊涓�...');
+ confirmBtn.prop('disabled', true);
if (option.data.length != 0) {
for (var i = 0; i < option.data.length - 1; i++) {
for (var j = 0; j < option.data.length - i - 1; j++) {
@@ -3288,12 +3687,16 @@
}
}
}
- table.render(option);
+ setTimeout(function () {
+ table.reload('mainTable', { data: option.data });
+ layer.close(index);
+ }, 5); // 寤惰繜鎵ц纭繚鎸夐挳鍥炬爣娓叉煋瀹�
}
else {
return layer.msg("鏃犳暟鎹�!")
+ layer.close(index);
}
- layer.close(index);
+
}
})
@@ -3319,10 +3722,14 @@
var iframeWindow = window["layui-layer-iframe" + index];//鑾峰彇寮规椤甸潰
var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//鑾峰彇閫変腑鐨勬暟鎹�
- if (checkStatus.data.length != 1) {
+ if (checkStatus.data.length == 1) {
+ OptionData[0] = checkStatus.data[0];
+ } else if (checkStatus.data.length == 0) {
+ //绛変簬0鏃舵竻绌虹敓浜ц祫婧�
+ OptionData[0] = { "HItemID": 0, "鐢熶骇璧勬簮鍚嶇О": "" };
+ } else {
return layer.msg("璇烽�夋嫨涓�鏉℃暟鎹�");
}
- OptionData[0] = checkStatus.data[0];
layer.close(index);//鍏抽棴寮圭獥
}
, end: function () {
@@ -3332,7 +3739,8 @@
if (num >= data.length) {
break;
}
- if (option.data[i]["LAY_CHECKED"] == true) {
+ if ($.grep(data, function (item) {
+ return item.hmainid === option.data[i].hmainid;}).length > 0) {
option.data[i]["HSourceID"] = OptionData[0].HItemID;
option.data[i]["鐢熶骇璧勬簮"] = OptionData[0].鐢熶骇璧勬簮鍚嶇О;
num += 1;
@@ -3411,7 +3819,7 @@
if (parseFloat(table.cache["mainTable"][i]["鎷嗗崟鏁伴噺"]) == 0) {
return layer.msg("绗�" + (i + 1) + "琛�,鎷嗕骇鏁伴噺鏈夎,璇烽噸鏂拌緭鍏�!");
}
- if (parseFloat(table.cache["mainTable"][i]["鎷嗗崟鏁伴噺"]) - parseFloat(table.cache["mainTable"][i]["鎷嗗崟姹囨姤鏁伴噺"]) < parseFloat(table.cache["mainTable"][i]["鏃ヨ鍒掓暟閲忔�婚噺"])) { // - 宸叉眹鎶ユ暟閲�
+ if (parseFloat(table.cache["mainTable"][i]["鎷嗗崟鏁伴噺"]) > parseFloat(table.cache["mainTable"][i]["璁″垝鏁伴噺"])) { // - 宸叉眹鎶ユ暟閲�
return layer.msg("绗�" + (i + 1) + "琛�,鎺掍骇鏁伴噺瓒呭嚭璁㈠崟鏁伴噺!");
}
table.cache["mainTable"][i].LAY_TABLE_INDEX = i;
@@ -3850,7 +4258,6 @@
, limit: 200
, cellMinWidth: 90
}
- table.render(option2);
//鍒锋柊琛ㄦ牸鏁版嵁
DisPlay_HideColumn_ICMO();
@@ -4099,6 +4506,7 @@
$.ajax({
url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
type: "GET",
+ async: false,
data: { "HModName": HModName + "Main", "user": sessionStorage["HUserName"] },
success: function (data1) {
if (data1.data.length != 0) {
@@ -4169,9 +4577,9 @@
option2.cols[0][i + 1]["fixed"] = "left";
}
}
- table.render(option2);
+ /*table.render(option2);*/
} else {
- table.render(option2);
+ /*table.render(option2);*/
}
}, error: function () {
layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
@@ -4278,20 +4686,6 @@
})
}
- //鍒楁槑鏄剧ず涓嬫媺妗�
- function ColFilter() {
- var Organization = '<option value="0" selected="selected" ></option>';
- for (var i = 2; i < option.cols[0].length - 1; i++) {
- if (option.cols[0][i].hide != true) {
- Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
- }
- }
- $("#ColName").empty();
- $("#ColName").append(Organization);$("#ColName1").empty();
- $("#ColName1").append(Organization);$("#ColName2").empty();
- $("#ColName2").append(Organization);
- form.render('select');
- }
//#endregion
//浠ヤ笂鏄痩ayui妯″潡
});
--
Gitblit v1.9.1