From aa90467b4c4fed302f966447f7c7f6d65391f05e Mon Sep 17 00:00:00 2001
From: wangyi <2946747746@qq.com>
Date: 星期六, 28 二月 2026 13:50:03 +0800
Subject: [PATCH] 期初在产品表增加导入动画，修改日期问题
---
WebTM/views/成本管理/期初在产品表/Gy_WIPBal_Excel.html | 29 +++++++++
WebTM/views/成本管理/期初在产品表/Kf_WIPBal.html | 138 ++++++++++++++++++++++++++++++++++++---------
2 files changed, 137 insertions(+), 30 deletions(-)
diff --git "a/WebTM/views/\346\210\220\346\234\254\347\256\241\347\220\206/\346\234\237\345\210\235\345\234\250\344\272\247\345\223\201\350\241\250/Gy_WIPBal_Excel.html" "b/WebTM/views/\346\210\220\346\234\254\347\256\241\347\220\206/\346\234\237\345\210\235\345\234\250\344\272\247\345\223\201\350\241\250/Gy_WIPBal_Excel.html"
index e22448e..0607335 100644
--- "a/WebTM/views/\346\210\220\346\234\254\347\256\241\347\220\206/\346\234\237\345\210\235\345\234\250\344\272\247\345\223\201\350\241\250/Gy_WIPBal_Excel.html"
+++ "b/WebTM/views/\346\210\220\346\234\254\347\256\241\347\220\206/\346\234\237\345\210\235\345\234\250\344\272\247\345\223\201\350\241\250/Gy_WIPBal_Excel.html"
@@ -110,22 +110,47 @@
//#region 瑙﹀彂浜嬩欢锛氬寘鎷琭orm.on(){}鏍煎紡鐨勬墍鏈夌偣鍑讳簨浠躲�侀�夋嫨浜嬩欢绛�
+
+
//鏂囦欢涓婁紶
upload.render({
elem: '#UpLoad',
url: GetWEBURL() + '/Kf_WIPBal/Kf_WIPBal_Excel',
contentType: 'application/json',
exts: 'xls|xlsx', //鍏佽涓婁紶鐨勭被鍨�
+ before: function (obj) { // 涓婁紶鍓�
+ layer.load(1, {
+ shade: [0.3, '#000'] // 0.3閫忔槑搴﹂粦鑹查伄缃�
+ });
+ },
done: function (data1) {
+ layer.closeAll('loading'); // 鍏抽棴鍔犺浇灞�
if (data1.count == 1) {
option.data = data1.data;
+
+ // 鑾峰彇褰撳墠骞存湀
+ var now = new Date();
+ var year = now.getFullYear();
+ var month = (now.getMonth() + 1).toString().padStart(2, '0');
+ var currentYearMonth = year + '-' + month;
+
+ // 璁剧疆骞存湀杈撳叆妗嗙殑鍊�
+ $('#ID-laydate-type-month').val(currentYearMonth);
+
+ // 涓哄鍏ョ殑鏁版嵁娣诲姞骞村拰鏈堝瓧娈�
+ for (var i = 0; i < option.data.length; i++) {
+ option.data[i]['骞�'] = year.toString();
+ option.data[i]['鏈�'] = month;
+ }
+
table.render(option);
+
} else {
layer.alert(data1.code + data1.Message, { icon: 5 });
}
},
error: function (err) {
- debugger
+ layer.closeAll('loading'); // 鍏抽棴鍔犺浇灞�
layer.alert('瀵煎叆鍑虹幇寮傚父', { icon: 2 });
}
});
@@ -137,6 +162,8 @@
//瀵煎叆 淇濆瓨鏁版嵁
form.on('submit(btnSave)', function (data) {
+
+
if (table.cache["mainTable"] != null) {
set_AddNew(data);
}
diff --git "a/WebTM/views/\346\210\220\346\234\254\347\256\241\347\220\206/\346\234\237\345\210\235\345\234\250\344\272\247\345\223\201\350\241\250/Kf_WIPBal.html" "b/WebTM/views/\346\210\220\346\234\254\347\256\241\347\220\206/\346\234\237\345\210\235\345\234\250\344\272\247\345\223\201\350\241\250/Kf_WIPBal.html"
index 78fb115..493ff58 100644
--- "a/WebTM/views/\346\210\220\346\234\254\347\256\241\347\220\206/\346\234\237\345\210\235\345\234\250\344\272\247\345\223\201\350\241\250/Kf_WIPBal.html"
+++ "b/WebTM/views/\346\210\220\346\234\254\347\256\241\347\220\206/\346\234\237\345\210\235\345\234\250\344\272\247\345\223\201\350\241\250/Kf_WIPBal.html"
@@ -39,7 +39,7 @@
<!-- 鍔ㄦ�佹覆鏌撹溅闂� -->
</select>
</div>
- </div>
+ </div>
<!-- 鐗╂枡 -->
<div class="layui-inline">
<label class="layui-form-label">鐗╂枡</label>
@@ -51,18 +51,19 @@
</button>
</div>
</div>
- <!-- 寮�濮嬫棩鏈� -->
- <div class="layui-inline">
- <label class="layui-form-label">寮�濮嬫棩鏈�</label>
- <div class="layui-input-block">
- <input type="date" class="layui-input" name="HBDate" id="HBDate" style="width:150px;">
+ <!-- 寮�濮嬪勾鏈� -->
+ <div class="layui-inline" style="margin-left: 20px;">
+ <label class="layui-form-label">寮�濮嬪勾鏈�</label>
+ <div class="layui-input-inline">
+ <input type="text" class="layui-input" id="ID-laydate-start-month" placeholder="閫夋嫨寮�濮嬪勾鏈�" readonly>
</div>
</div>
- <!-- 缁撴潫鏃ユ湡 -->
- <div class="layui-inline">
- <label class="layui-form-label">缁撴潫鏃ユ湡</label>
- <div class="layui-input-block">
- <input type="date" class="layui-input" name="HEDate" id="HEDate" style="width:150px;">
+
+ <!-- 缁撴潫骞存湀 -->
+ <div class="layui-inline" style="margin-left: 20px;">
+ <label class="layui-form-label">缁撴潫骞存湀</label>
+ <div class="layui-input-inline">
+ <input type="text" class="layui-input" id="ID-laydate-end-month" placeholder="閫夋嫨缁撴潫骞存湀" readonly>
</div>
</div>
<!-- 鏌ヨ鎸夐挳 -->
@@ -128,14 +129,40 @@
// 鍏ㄥ眬鏌ヨ鏉′欢瀛楃涓�
var sWhere = "";
- // ---------- 鍒濆鍖� ----------
+
function initPage() {
// 娓叉煋杞﹂棿涓嬫媺妗�
loadDeptSelect();
- // 璁剧疆榛樿鏃ユ湡: 寮�濮嬫棩鏈熶负7澶╁墠锛岀粨鏉熸棩鏈熶负浠婂ぉ
- $("#HBDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 7), "yyyy-MM-dd"));
- $("#HEDate").val(Format(new Date(), "yyyy-MM-dd"));
-
+
+ // 璁剧疆榛樿鏃ユ湡: 寮�濮嬪勾鏈堜负7涓湀鍓嶏紝缁撴潫骞存湀涓轰粖澶�
+ var currentDate = new Date();
+ var lastMonth = new Date(currentDate);
+ lastMonth.setMonth(currentDate.getMonth() - 12);
+
+ // 鏂板锛氭覆鏌撳紑濮嬪勾鏈堥�夋嫨鍣�
+ laydate.render({
+ elem: '#ID-laydate-start-month',
+ type: 'month',
+ format: 'yyyy-MM',
+ value: lastMonth,
+ done: function (value, date) {
+ // 鍙互閫夋嫨鍦ㄨ繖閲岃Е鍙戞煡璇�
+ // getFastQuery(2);
+ }
+ });
+
+ // 鏂板锛氭覆鏌撶粨鏉熷勾鏈堥�夋嫨鍣�
+ laydate.render({
+ elem: '#ID-laydate-end-month',
+ type: 'month',
+ format: 'yyyy-MM',
+ value: currentDate,
+ done: function (value, date) {
+ // 鍙互閫夋嫨鍦ㄨ繖閲岃Е鍙戞煡璇�
+ // getFastQuery(2);
+ }
+ });
+
getFastQuery(2);
// 閲嶆柊娓叉煋琛ㄥ崟鍏冪礌锛坰elect绛夛級
form.render('select');
@@ -167,15 +194,51 @@
- // 鏌ヨ骞舵覆鏌撻樁姊姤琛�
+ // 淇敼鍚庣殑getFastQuery鍑芥暟
function getFastQuery(type) {
- var HBeginDate = $("#HBDate").val();
- var HEndDate = $("#HEDate").val();
+ // 淇敼锛氫粠骞存湀閫夋嫨鍣ㄨ幏鍙栧�硷紝鑰屼笉鏄粠鏃ユ湡杈撳叆妗�
+ var HStartYearMonth = $("#ID-laydate-start-month").val();
+ var HEndYearMonth = $("#ID-laydate-end-month").val();
+
+ // 鏂板锛氶獙璇佹槸鍚﹂�夋嫨浜嗗紑濮嬪勾鏈�
+ if (!HStartYearMonth) {
+ layer.msg('璇烽�夋嫨寮�濮嬪勾鏈�', { icon: 2 });
+ return;
+ }
+
+ // 鏂板锛氶獙璇佹槸鍚﹂�夋嫨浜嗙粨鏉熷勾鏈�
+ if (!HEndYearMonth) {
+ layer.msg('璇烽�夋嫨缁撴潫骞存湀', { icon: 2 });
+ return;
+ }
+
+ // 鏂板锛氳В鏋愬紑濮嬪勾鏈堜负骞村拰鏈�
+ var startParts = HStartYearMonth.split('-');
+ var HStartYear = startParts[0];
+ var HStartPeriod = startParts[1];
+
+ // 鏂板锛氳В鏋愮粨鏉熷勾鏈堜负骞村拰鏈�
+ var endParts = HEndYearMonth.split('-');
+ var HEndYear = endParts[0];
+ var HEndPeriod = endParts[1];
+
+ // 鏂板锛氶獙璇佸勾鏈堣寖鍥存槸鍚︽湁鏁�
+ var startValue = parseInt(HStartYear) * 100 + parseInt(HStartPeriod);
+ var endValue = parseInt(HEndYear) * 100 + parseInt(HEndPeriod);
+
+ if (startValue > endValue) {
+ layer.msg('寮�濮嬪勾鏈堜笉鑳藉ぇ浜庣粨鏉熷勾鏈�', { icon: 2 });
+ return;
+ }
+
var HCostObjID = $("#HMaterID").val() || '0';
var HWorkShopID = $("#HDeptID").val() || '0';
- var spParams = "'" + HBeginDate + "','" + HEndDate + "','" + HWorkShopID + "','" + HCostObjID+ "'";
- sWhere = spParams; // 鐢ㄤ簬鍐呴儴
+ // 淇敼锛氬瓨鍌ㄨ繃绋嬪弬鏁版敼涓哄紑濮嬪勾銆佸紑濮嬫湀銆佺粨鏉熷勾銆佺粨鏉熸湀銆佽溅闂淬�佺墿鏂�
+ var spParams = "'" + HStartYear + "','" + HStartPeriod + "','" +
+ HEndYear + "','" + HEndPeriod + "','" +
+ HWorkShopID + "','" + HCostObjID + "'";
+ sWhere = spParams;
if (type == 2) {
get_Display(spParams);
@@ -273,16 +336,33 @@
}
// 閲嶇疆杩囨护鏉′欢
+ // 淇敼鍚庣殑clearQuery鍑芥暟
function clearQuery() {
- $("#HBDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 7), "yyyy-MM-dd"));
- $("#HEDate").val(Format(new Date(), "yyyy-MM-dd"));
+ var currentDate = new Date();
+ var lastMonth = new Date(currentDate);
+ lastMonth.setMonth(currentDate.getMonth() - 7);
+
+ // 淇敼锛氶噸鏂拌缃紑濮嬪勾鏈堥�夋嫨鍣ㄧ殑鍊�
+ laydate.render({
+ elem: '#ID-laydate-start-month',
+ type: 'month',
+ format: 'yyyy-MM',
+ value: lastMonth,
+ show: false // 涓嶆樉绀洪潰鏉�
+ });
+
+ // 淇敼锛氶噸鏂拌缃粨鏉熷勾鏈堥�夋嫨鍣ㄧ殑鍊�
+ laydate.render({
+ elem: '#ID-laydate-end-month',
+ type: 'month',
+ format: 'yyyy-MM',
+ value: currentDate,
+ show: false // 涓嶆樉绀洪潰鏉�
+ });
+
$("#HDeptID").val(0);
- $("#HEmpID").val(0);
- $("#HEmpName").val("");
- $("#HGroupID").val(0);
- $("#HGroupName").val("");
- $("#HMaterID").val("0");
- $("#HMaterName").val("");
+ $("#HMaterID").val("0");
+ $("#HMaterName").val("");
form.render('select');
}
--
Gitblit v1.9.1