From e0cc8166acc55ea4aac9adf858c2f61608ed6ddf Mon Sep 17 00:00:00 2001
From: wangyi <2946747746@qq.com>
Date: 星期三, 17 十二月 2025 13:27:11 +0800
Subject: [PATCH] 修复时间显示的问题
---
WebTM/views/工资管理/阶梯工价系数/Gy_SteppedPriceCoefficientBillEdit.html | 1087 +++++++++++---------
WebTM/views/工资管理/阶梯工价系数/Gy_SteppedPriceCoefficientBillList.html | 1997 +++++++++++++++----------------------
2 files changed, 1,396 insertions(+), 1,688 deletions(-)
diff --git "a/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\351\230\266\346\242\257\345\267\245\344\273\267\347\263\273\346\225\260/Gy_SteppedPriceCoefficientBillEdit.html" "b/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\351\230\266\346\242\257\345\267\245\344\273\267\347\263\273\346\225\260/Gy_SteppedPriceCoefficientBillEdit.html"
index 0f981f5..9d8f8b8 100644
--- "a/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\351\230\266\346\242\257\345\267\245\344\273\267\347\263\273\346\225\260/Gy_SteppedPriceCoefficientBillEdit.html"
+++ "b/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\351\230\266\346\242\257\345\267\245\344\273\267\347\263\273\346\225\260/Gy_SteppedPriceCoefficientBillEdit.html"
@@ -49,16 +49,16 @@
<input type="date" class="layui-input" lay-verify="HDate" name="HDate" id="HDate" style="padding-left: 80px;">
</div>
</div>
- <div class="layui-inline">
- <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">宸ュ簭<label style="color:red"> * </label></label>
- <div class="layui-input-block" style="margin-left: 77px;">
- <input type="text" class="layui-input" lay-verify="HProcID" name="HProcID" id="HProcID" style="background-color:#efefef4d;width: 60%;display: inline-block;" placeholder="鐐瑰嚮鎼滅储閫夋嫨宸ュ簭" readonly>
- <input type="hidden" name="HProcName" id="HProcName">
- <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearchHProc" id="btnSearchHProc" style="padding: 0 10px;float: right;margin-right: 3px;">
- <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
- </button>
- </div>
- </div>
+ <div class="layui-inline">
+ <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">宸ュ簭<label style="color:red"> * </label></label>
+ <div class="layui-input-block" style="margin-left: 77px;">
+ <input type="text" class="layui-input" lay-verify="HProcName" name="HProcName" id="HProcName" style="background-color:#efefef4d;width: 60%;display: inline-block;" placeholder="鐐瑰嚮鎼滅储閫夋嫨宸ュ簭" readonly>
+ <input type="hidden" name="HProcID" id="HProcID">
+ <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearchHProc" id="btnSearchHProc" style="padding: 0 10px;float: right;margin-right: 3px;">
+ <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
+ </button>
+ </div>
+ </div>
</div>
<div class="layui-row">
<div class="layui-inline" style="width:500px;">
@@ -226,7 +226,7 @@
var HModName = "Gy_SteppedPriceCoefficientBill";
var HStockOrgID = sessionStorage["OrganizationID"];
- var HModuleType = "GYST";
+ var HModuleType = "";
var HPageTitle = get_PageTitle(HModuleType) == "" ? $("h1").html() : get_PageTitle(HModuleType);
$("h1").html('<b>' + HPageTitle + '</b>');
@@ -349,8 +349,9 @@
case 'set_HideColumn':
get_HideColumn();
break;
- }
- });
+ GYST
+ }
+ });
table.on('tool(mainTable)', function (obj) {
set_GridDelete(obj);
@@ -475,7 +476,62 @@
}
Organ();
+ // 鍦� Organ() 鍑芥暟鍚庨潰娣诲姞浠ヤ笅浠g爜
+ /**
+ * 鏍规嵁宸ュ簭ID鑾峰彇宸ュ簭鍚嶇О
+ * @param {string} processId - 宸ュ簭ID锛圚ProcID锛�
+ * @param {function} callback - 鍥炶皟鍑芥暟锛屾帴鏀跺伐搴忓悕绉颁綔涓哄弬鏁�
+ */
+ function getProcessNameById(processId, callback) {
+ if (!processId || processId === "0" || processId === "") {
+ callback('');
+ return;
+ }
+
+ // 鏋勫缓鏌ヨ鏉′欢
+ var sWhere = " and HItemID = '" + processId + "'";
+
+ $.ajax({
+ url: GetWEBURL() + '/Gy_Process/list',
+ type: "GET",
+ data: {
+ "sWhere": sWhere,
+ "user": sessionStorage["HUserName"] || "admin"
+ },
+ success: function (result) {
+ if (result.count == 1 && result.data && result.data.length > 0) {
+ var processName = result.data[0].宸ュ簭鍚嶇О || '';
+ callback(processName);
+ } else {
+ callback('');
+ console.warn('鏈壘鍒板搴旂殑宸ュ簭淇℃伅锛屽伐搴廔D:', processId);
+ }
+ },
+ error: function () {
+ callback('');
+ console.error('鑾峰彇宸ュ簭淇℃伅澶辫触锛屽伐搴廔D:', processId);
+ }
+ });
+ }
+
+ /**
+ * 鏍规嵁宸ュ簭ID璁剧疆宸ュ簭鍚嶇О锛堣嚜鍔ㄥ~鍏呭埌杈撳叆妗嗭級
+ * @param {string} processId - 宸ュ簭ID
+ */
+ function setProcessNameById(processId) {
+ if (!processId || processId === "0" || processId === "") {
+ $("#HProcName").val('');
+ return;
+ }
+
+ getProcessNameById(processId, function (processName) {
+ if (processName) {
+ $("#HProcName").val(processName);
+ layui.form.render();
+ }
+ });
+ }
function get_InitGrid() {
option = {
elem: '#mainTable'
@@ -601,68 +657,36 @@
// 淇濆瓨鍘熷宸ュ簭ID锛堢敤浜庣紪杈戞椂姣旇緝鏄惁淇敼浜嗗伐搴忥級
originalProcessID = formData.HProcID;
- try {
- if (mainData.HDate) {
- var hDate = new Date(mainData.HDate);
- formData.HDate = hDate.toISOString().split('T')[0];
- }
+ // ============ 鏂板锛氬鏋淎PI娌℃湁杩斿洖宸ュ簭鍚嶇О鎴栧悕绉颁负绌猴紝鍒欓�氳繃宸ュ簭ID鑷姩鑾峰彇 ============
+ if ((!formData.HProcName || formData.HProcName.trim() === "") &&
+ formData.HProcID && formData.HProcID !== "0") {
- if (mainData.HMakeDate) {
- var makeDate = new Date(mainData.HMakeDate);
- formData.HMakeDate = formatDateTime(makeDate);
- }
+ console.log("API鏈繑鍥炲伐搴忓悕绉帮紝寮�濮嬭嚜鍔ㄨ幏鍙栵紝宸ュ簭ID:", formData.HProcID);
- if (mainData.HUpDateDate) {
- var updateDate = new Date(mainData.HUpDateDate);
- formData.HUpDateDate = formatDateTime(updateDate);
- }
+ // 璋冪敤鑾峰彇宸ュ簭鍚嶇О鐨勫嚱鏁�
+ getProcessNameById(formData.HProcID, function (processName) {
+ if (processName) {
+ console.log("鑷姩鑾峰彇宸ュ簭鍚嶇О鎴愬姛:", processName);
+ // 鏇存柊formData瀵硅薄涓殑宸ュ簭鍚嶇О
+ formData.HProcName = processName;
- if (mainData.HCheckDate) {
- var checkDate = new Date(mainData.HCheckDate);
- formData.HCheckDate = formatDateTime(checkDate);
- }
-
- if (mainData.HCloseDate) {
- var closeDate = new Date(mainData.HCloseDate);
- formData.HCloseDate = formatDateTime(closeDate);
- }
-
- if (mainData.HDeleteDate) {
- var deleteDate = new Date(mainData.HDeleteDate);
- formData.HDeleteDate = formatDateTime(deleteDate);
- }
-
- if (mainData.HBackDate) {
- var backDate = new Date(mainData.HBackDate);
- formData.HBackDate = formatDateTime(backDate);
- }
- } catch (e) {
- if (mainData.HDate) formData.HDate = mainData.HDate.toString().split(' ')[0];
- if (mainData.HMakeDate) formData.HMakeDate = mainData.HMakeDate.toString();
- if (mainData.HUpDateDate) formData.HUpDateDate = mainData.HUpDateDate.toString();
- if (mainData.HCheckDate) formData.HCheckDate = mainData.HCheckDate.toString();
- if (mainData.HCloseDate) formData.HCloseDate = mainData.HCloseDate.toString();
- if (mainData.HDeleteDate) formData.HDeleteDate = mainData.HDeleteDate.toString();
- if (mainData.HBackDate) formData.HBackDate = mainData.HBackDate.toString();
- }
-
- layui.form.val("formData", formData);
-
- if (formData.HStockOrgID && formData.HStockOrgID !== "0") {
- $("#HStockOrgID").val(formData.HStockOrgID);
- form.render('select');
- }
-
- if (mainData.HChecker || mainData.HBillStatus == 2) {
- $('#btnSave').addClass("layui-btn-disabled").attr("disabled", true);
- layer.msg("鍗曟嵁宸插鏍革紝涓嶈兘缂栬緫", { icon: 2 });
+ // 澶勭悊琛ㄥ崟鏁版嵁
+ processFormData(mainData, formData);
+ } else {
+ console.warn("鏈兘鑷姩鑾峰彇宸ュ簭鍚嶇О锛屽伐搴廔D:", formData.HProcID);
+ // 璁剧疆鍏朵粬琛ㄥ崟鍊�
+ processFormData(mainData, formData);
+ }
+ });
} else {
- $('#btnSave').removeClass("layui-btn-disabled").attr("disabled", false);
+ // 濡傛灉API宸茶繑鍥炲伐搴忓悕绉帮紝鐩存帴澶勭悊琛ㄥ崟鏁版嵁
+ processFormData(mainData, formData);
}
} else {
layer.msg("鏈幏鍙栧埌涓昏〃鏁版嵁", { icon: 2 });
}
+ // 澶勭悊瀛愯〃鏁版嵁
if (data.Sub && data.Sub.length > 0) {
var subTableData = [];
for (var i = 0; i < data.Sub.length; i++) {
@@ -696,446 +720,515 @@
}
}
- function formatDateTime(date) {
- if (!date) return "";
+ // 鏂板杈呭姪鍑芥暟锛氬鐞嗚〃鍗曟暟鎹�
+ function processFormData(mainData, formData) {
try {
- if (typeof date === 'string') {
- date = new Date(date);
+ if (mainData.HDate) {
+ var hDate = new Date(mainData.HDate);
+ formData.HDate = hDate.toISOString().split('T')[0];
}
- return date.getFullYear() + "-" +
- (date.getMonth() + 1).toString().padStart(2, '0') + "-" +
- date.getDate().toString().padStart(2, '0') + " " +
- date.getHours().toString().padStart(2, '0') + ":" +
- date.getMinutes().toString().padStart(2, '0') + ":" +
- date.getSeconds().toString().padStart(2, '0');
+
+ if (mainData.HMakeDate) {
+ var makeDate = new Date(mainData.HMakeDate);
+ formData.HMakeDate = formatDateTime(makeDate);
+ }
+
+ if (mainData.HUpDateDate) {
+ var updateDate = new Date(mainData.HUpDateDate);
+ formData.HUpDateDate = formatDateTime(updateDate);
+ }
+
+ if (mainData.HCheckDate) {
+ var checkDate = new Date(mainData.HCheckDate);
+ formData.HCheckDate = formatDateTime(checkDate);
+ }
+
+ if (mainData.HCloseDate) {
+ var closeDate = new Date(mainData.HCloseDate);
+ formData.HCloseDate = formatDateTime(closeDate);
+ }
+
+ if (mainData.HDeleteDate) {
+ var deleteDate = new Date(mainData.HDeleteDate);
+ formData.HDeleteDate = formatDateTime(deleteDate);
+ }
+
+ if (mainData.HBackDate) {
+ var backDate = new Date(mainData.HBackDate);
+ formData.HBackDate = formatDateTime(backDate);
+ }
} catch (e) {
- return date.toString();
+ if (mainData.HDate) formData.HDate = mainData.HDate.toString().split(' ')[0];
+ if (mainData.HMakeDate) formData.HMakeDate = mainData.HMakeDate.toString();
+ if (mainData.HUpDateDate) formData.HUpDateDate = mainData.HUpDateDate.toString();
+ if (mainData.HCheckDate) formData.HCheckDate = mainData.HCheckDate.toString();
+ if (mainData.HCloseDate) formData.HCloseDate = mainData.HCloseDate.toString();
+ if (mainData.HDeleteDate) formData.HDeleteDate = mainData.HDeleteDate.toString();
+ if (mainData.HBackDate) formData.HBackDate = mainData.HBackDate.toString();
}
+
+ // 璁剧疆琛ㄥ崟鍊�
+ layui.form.val("formData", formData);
+
+ // 鍗曠嫭纭繚宸ュ簭鍚嶇О杈撳叆妗嗙殑鍊兼纭�
+ $("#HProcName").val(formData.HProcName || "");
+
+ if (formData.HStockOrgID && formData.HStockOrgID !== "0") {
+ $("#HStockOrgID").val(formData.HStockOrgID);
+ layui.form.render('select');
+ }
+
+ if (mainData.HChecker || mainData.HBillStatus == 2) {
+ $('#btnSave').addClass("layui-btn-disabled").attr("disabled", true);
+ layer.msg("鍗曟嵁宸插鏍革紝涓嶈兘缂栬緫", { icon: 2 });
+ } else {
+ $('#btnSave').removeClass("layui-btn-disabled").attr("disabled", false);
+ }
+
+ // 閲嶆柊娓叉煋琛ㄥ崟
+ layui.form.render();
}
- // ================ 鏂板锛氬伐搴忓敮涓�鎬ф鏌ュ嚱鏁� ================
- function checkProcessUnique() {
- var processID = $("#HProcID").val();
- var currentBillID = $("#HInterID").val();
- var processName = $("#HProcName").val() || "璇ュ伐搴�";
-
- if (processID === "0" || !processID) {
- return true;
- }
-
- // 缂栬緫妯″紡锛氬鏋滃伐搴廔D娌℃湁鍙樺寲锛屽垯鍏佽
- if (OperationType == 3 && currentBillID && currentBillID !== "0") {
- if (originalProcessID && originalProcessID === processID) {
- return true; // 宸ュ簭娌′慨鏀癸紝鍏佽淇濆瓨
- }
- }
-
- var index = layer.load(1, { shade: [0.1, '#fff'] });
- var isUnique = true;
-
- $.ajax({
- url: GetWEBURL() + "/Gy_SteppedPriceCoefficientBill/CheckProcessUnique",
- type: "POST",
- async: false,
- contentType: "application/json",
- data: JSON.stringify({
- "HProcID": processID,
- "HStockOrgID": $("#HStockOrgID").val(),
- "ExcludeID": currentBillID || "0",
- "user": sessionStorage["HUserName"] || "admin"
- }),
- success: function (result) {
- layer.close(index);
- if (result && result.code == "1") {
- if (result.data && result.data.exists) {
- isUnique = false;
- var existingBillNo = result.data.billNo || "";
-
- if (existingBillNo) {
- layer.msg(processID + "宸插湪鍗曟嵁[" + existingBillNo + "]涓娇鐢紝涓�涓伐搴忓彧鑳藉搴斾竴鏉¢樁姊伐浠风郴鏁版暟鎹�!", {
- icon: 5,
- time: 5000
- });
- } else {
- layer.msg(processID + "宸插瓨鍦ㄥ叾浠栧崟鎹腑锛屼竴涓伐搴忓彧鑳藉搴斾竴鏉¢樁姊伐浠风郴鏁版暟鎹�!", {
- icon: 5,
- time: 5000
- });
- }
- }
- } else {
- layer.msg("宸ュ簭鍞竴鎬ф鏌ュけ璐ワ紝璇风◢鍚庨噸璇�", { icon: 3 });
- }
- },
- error: function () {
- layer.close(index);
- layer.msg("宸ュ簭鍞竴鎬ф鏌ユ湇鍔℃殏鏃朵笉鍙敤", { icon: 3 });
- // 涓轰簡涓嶉樆濉炵敤鎴凤紝杩欓噷杩斿洖true锛屼絾鐢熶骇鐜搴旇鏍规嵁闇�姹傝皟鏁�
- isUnique = true;
- }
- });
-
- return isUnique;
- }
-
- function set_AddNew(data) {
- if (window.isSaving) {
- layer.msg("姝e湪淇濆瓨锛岃绋嶅��...", { icon: 0 });
- return;
- }
- window.isSaving = true;
-
- var originalText = $('#btnSave').text();
- $('#btnSave').text('淇濆瓨涓�...').addClass("layui-btn-disabled").attr("disabled", true);
-
- var tableMain = {
- "HInterID": $("#HInterID").val() || "0",
- "HYear": new Date($("#HDate").val()).getFullYear(),
- "HPeriod": new Date($("#HDate").val()).getMonth() + 1,
- "HBillType": "GYSTPRICECOEFF",
- "HBillSubType": "",
- "HDate": $("#HDate").val() || Format(new Date(), "yyyy-MM-dd"),
- "HBillNo": $("#HBillNo").val() || "",
- "HBillStatus": 1,
- "HRemark": $("#HRemark").val() || "",
- "HProcID": $("#HProcID").val() || "0",
- "HEmpID": $("#HEmpID").val() || "0",
- "HDeptID": $("#HDeptID").val() || "0",
- "HStockOrgID": $("#HStockOrgID").val() || "0",
- "HMaker": sessionStorage["HUserName"] || "admin",
- "HMakeDate": Format(new Date(), "yyyy-MM-dd HH:mm:ss")
- };
-
- var tableSub = [];
- var tableCache = table.cache["mainTable"];
-
- if (tableCache && tableCache.length > 0) {
- for (var i = 0; i < tableCache.length; i++) {
- var row = tableCache[i];
- if (row && row != "") {
- var subItem = {
- "HSeq": row["HSeq"] || (i + 1),
- "HMinQty": row["HMinQty"] || "0",
- "HMaxQty": row["HMaxQty"] || "0",
- "HPriceCoefficient": row["HPriceCoefficient"] || "1.0",
- "HMaxPrice": row["HMaxPrice"] || "0",
- "HRemark": row["HRemark"] || "",
- "HStockOrgID": row["HStockOrgID"] || $("#HStockOrgID").val() || "0"
- };
- tableSub.push(subItem);
- }
- }
- }
-
- tableMain.SubItems = tableSub;
-
- var requestData = {
- "oMain": JSON.stringify(tableMain) + ";" + (sessionStorage["HUserName"] || "admin")
- };
-
- var index = layer.load(2, { time: 0 });
-
- $.ajax({
- type: "POST",
- url: GetWEBURL() + "/Gy_SteppedPriceCoefficientBill/ModifyByID",
- contentType: "application/json",
- data: JSON.stringify(requestData),
- dataType: "json",
- timeout: 30000,
- success: function (result) {
- layer.close(index);
- window.isSaving = false;
- $('#btnSave').text(originalText).removeClass("layui-btn-disabled").attr("disabled", false);
-
- if (result.code == "1") {
- layer.msg("淇濆瓨鎴愬姛锛�", { icon: 1, time: 2000 });
- $('#btnSave').addClass("layui-btn-disabled").attr("disabled", true);
-
- if (OperationType == 1) {
- OperationType = 3;
- }
- } else {
- layer.msg("宸ュ簭鏈�夋嫨");
- }
- },
- error: function (xhr, status, error) {
- layer.close(index);
- window.isSaving = false;
- $('#btnSave').text(originalText).removeClass("layui-btn-disabled").attr("disabled", false);
-
- var errorMsg = "璇锋眰澶辫触锛�<br>";
- if (status === "timeout") {
- errorMsg += "璇锋眰瓒呮椂";
- } else {
- errorMsg += "閿欒浠g爜: " + xhr.status + "<br>閿欒淇℃伅: " + error;
- }
-
- layer.msg(errorMsg, { icon: 5, time: 5000 });
- }
- });
- }
-
- function AllowLoadData(data) {
- var temp;
- var ref = /^\d+(\.\d+)?$/;
- var refInt = /^\d+$/;
-
- // 琛ㄥご鏁版嵁妫�楠�
- if ($("#HBillNo").val() == "") {
- layer.msg("鍗曟嵁鍙蜂笉鑳戒负绌�!");
- return false;
- }
- if ($("#HDate").val() == "") {
- layer.msg("鏃ユ湡涓嶈兘涓虹┖!");
- return false;
- }
- if ($("#HProcID").val() == "0") {
- layer.msg("宸ュ簭鏈�夋嫨!");
- return false;
- }
- if ($("#HStockOrgID").val() == "0") {
- layer.msg("缁勭粐鏈�夋嫨!");
- return false;
- }
-
- // 鏂板锛氭鏌ュ伐搴忔槸鍚﹀凡瀛樺湪
- if (!checkProcessUnique()) {
- return false;
- }
-
- // 瀛愯〃鏁版嵁妫�楠�
- var tableData = table.cache["mainTable"];
- if (!tableData || tableData.length == 0) {
- layer.msg("璇疯嚦灏戞坊鍔犱竴鏉¢樁姊暟鎹�!");
- return false;
- }
-
- var validRows = 0;
- for (var i = 0; i < tableData.length; i++) {
- if (tableData[i] && tableData[i] != "") {
- validRows++;
- var rowData = tableData[i];
-
- temp = rowData["HMinQty"];
- if (temp == "" || !refInt.test(temp) || parseInt(temp) < 0) {
- layer.msg("绗�" + (i + 1) + "琛�:鏈�灏忔暟閲忓繀椤讳负闈炶礋鏁存暟!");
- return false;
- }
-
- temp = rowData["HMaxQty"];
- if (temp == "" || !refInt.test(temp) || parseInt(temp) < 0) {
- layer.msg("绗�" + (i + 1) + "琛�:鏈�澶ф暟閲忓繀椤讳负闈炶礋鏁存暟!");
- return false;
- }
-
- if (parseInt(rowData["HMinQty"]) > parseInt(rowData["HMaxQty"])) {
- layer.msg("绗�" + (i + 1) + "琛�:鏈�灏忔暟閲忎笉鑳藉ぇ浜庢渶澶ф暟閲�!");
- return false;
- }
-
- temp = rowData["HPriceCoefficient"];
- if (temp == "" || !ref.test(temp) || parseFloat(temp) <= 0) {
- layer.msg("绗�" + (i + 1) + "琛�:宸ヤ环绯绘暟蹇呴』涓烘鏁�!");
- return false;
- }
-
- temp = rowData["HMaxPrice"];
- if (temp == "" || !ref.test(temp) || parseFloat(temp) < 0) {
- layer.msg("绗�" + (i + 1) + "琛�:鏈�澶у伐浠峰繀椤讳负闈炶礋鏁�!");
- return false;
- }
- }
- }
-
- if (validRows === 0) {
- layer.msg("璇疯嚦灏戞坊鍔犱竴鏉℃湁鏁堢殑闃舵鏁版嵁!");
- return false;
- }
-
- if (!checkStepNonOverlap(true)) {
- return false;
- }
-
- return true;
- }
-
- function checkStepNonOverlap(isValidation) {
- var tableData = table.cache["mainTable"];
- if (!tableData || tableData.length <= 1) return true;
-
- var validData = [];
- for (var i = 0; i < tableData.length; i++) {
- if (tableData[i] && tableData[i] != "") {
- var minQty = parseInt(tableData[i]["HMinQty"]);
- var maxQty = parseInt(tableData[i]["HMaxQty"]);
-
- if (minQty > maxQty) {
- if (isValidation) {
- layer.msg("绗�" + tableData[i]["HSeq"] + "闃�:鏈�灏忔暟閲忎笉鑳藉ぇ浜庢渶澶ф暟閲�!");
- return false;
- } else {
- layer.msg("绗�" + tableData[i]["HSeq"] + "闃�:鏈�灏忔暟閲忎笉鑳藉ぇ浜庢渶澶ф暟閲�!", { icon: 2 });
- return false;
- }
- }
- validData.push(tableData[i]);
- }
- }
-
- if (validData.length <= 1) return true;
-
- validData.sort(function (a, b) {
- return parseInt(a.HMinQty) - parseInt(b.HMinQty);
- });
-
- for (var i = 1; i < validData.length; i++) {
- var prevMin = parseInt(validData[i - 1]["HMinQty"]);
- var prevMax = parseInt(validData[i - 1]["HMaxQty"]);
- var currMin = parseInt(validData[i]["HMinQty"]);
- var currMax = parseInt(validData[i]["HMaxQty"]);
-
- if (currMin <= prevMax) {
- if (isValidation) {
- layer.msg("绗�" + validData[i]["HSeq"] + "闃朵笌绗�" + validData[i - 1]["HSeq"] + "闃�:闃舵鑼冨洿閲嶅彔!");
- return false;
- } else {
- layer.msg("绗�" + validData[i]["HSeq"] + "闃朵笌绗�" + validData[i - 1]["HSeq"] + "闃�:闃舵鑼冨洿閲嶅彔!");
- }
- }
- }
- return true;
- }
-
- function updateSeq() {
- var tableData = table.cache["mainTable"];
- if (!tableData) return;
-
- var seq = 1;
- for (var i = 0; i < tableData.length; i++) {
- if (tableData[i] && tableData[i] != "") {
- tableData[i].HSeq = seq;
- seq++;
- }
- }
- option.data = tableData;
- table.render(option);
- }
-
- function set_GridDelete(obj) {
- if (obj.event === 'del') {
- layer.confirm('鐪熺殑鍒犻櫎琛屽悧锛�', function (index) {
- var oldData = table.cache["mainTable"];
- if (oldData && obj.tr.data('index') < oldData.length) {
- oldData.splice(obj.tr.data('index'), 1)
- option.data = oldData;
- table.render(option);
- updateSeq();
- layer.close(index);
- }
- });
- }
- }
-
- function get_HideColumn() {
- var colName = "";
- var contentUrl = "";
- for (var i = 1; i < option.cols[0].length - 1; i++) {
- colName += option.cols[0][i]["title"] + ",";
- }
- var urlStr = window.document.location.pathname;
- var urlLen = urlStr.split('/');
- for (var i = 0; i < urlLen.length - 4; i++) {
- contentUrl += "../";
- }
- colName = encodeURI(colName.substring(0, colName.length - 1));
-
- contentUrl += '鍩虹璧勬枡/闅愯棌鍒楄缃�/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName;
-
- layer.open({
- type: 2
- , skin: "layui-layer-rim"
- , title: "闅愯棌鍒楄缃�"
- , closeBtn: 1
- , shift: 2
- , area: ["50%", "90%"]
- , maxmin: true
- , content: [contentUrl, "yes"]
- , btn: ["纭畾", "鍙栨秷"]
- , btn1: function (index, laero) {
- DisPlay_HideColumn();
- layer.close(index);
- }
- });
- }
-
- function DisPlay_HideColumn() {
- $.ajax({
- url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
- type: "GET",
- data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
- async: false,
- success: function (data1) {
- if (data1.data.length != 0) {
- var dataCol = [];
- var titleData = ["琛屽彿", "缁勭粐ID"];
-
- dataCol = data1.data[0].HGridString.split(',');
-
- for (var i = 0; i < option.cols[0].length - 2; i++) {
- var dataCols = dataCol[i].split('|');
- if (dataCols[1] == 1) {
- option.cols[0][i + 1]["hide"] = true;
- }
- if (dataCols[3] > 0) {
- option.cols[0][i + 1]["width"] = dataCols[3];
- }
- if (data1.data[0].HFontSize != 0) {
- option.cols[0][i + 1]["style"] += "font-size:" + data1.data[0].HFontSize + "px;";
- } else {
- option.cols[0][i + 1]["style"] += "font-size:100%";
- }
- if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
- option.cols[0][i + 1]["hide"] = false;
- }
- switch (dataCols[2]) {
- case "L":
- option.cols[0][i + 1]["align"] = "left";
- break;
- case "M":
- option.cols[0][i + 1]["align"] = "center";
- break;
- case "R":
- option.cols[0][i + 1]["align"] = "right";
- break;
- }
- }
-
- for (var i = 1; i < option.cols[0].length - 1; i++) {
- if (option.cols[0][i]["fixed"] != null) {
- option.cols[0][i]["fixed"] = null;
- }
- else {
- break;
- }
- }
- if (data1.data[0].HFixCols != 0) {
- for (var i = 0; i < data1.data[0].HFixCols; i++) {
- if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
- data1.data[0].HFixCols += 1;
+ function formatDateTime(date) {
+ if (!date) return "";
+ try {
+ if (typeof date === 'string') {
+ date = new Date(date);
}
- option.cols[0][i + 1]["fixed"] = "left";
+ return date.getFullYear() + "-" +
+ (date.getMonth() + 1).toString().padStart(2, '0') + "-" +
+ date.getDate().toString().padStart(2, '0') + " " +
+ date.getHours().toString().padStart(2, '0') + ":" +
+ date.getMinutes().toString().padStart(2, '0') + ":" +
+ date.getSeconds().toString().padStart(2, '0');
+ } catch (e) {
+ return date.toString();
}
}
- table.render(option);
- } else {
- table.render(option);
- }
- }, error: function () {
- layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
- }
- });
- }
- });
+
+ // ================ 鏂板锛氬伐搴忓敮涓�鎬ф鏌ュ嚱鏁� ================
+ function checkProcessUnique() {
+ var processID = $("#HProcID").val();
+ var currentBillID = $("#HInterID").val();
+ var processName = $("#HProcName").val() || "璇ュ伐搴�";
+
+ if (processID === "0" || !processID) {
+ return true;
+ }
+
+ // 缂栬緫妯″紡锛氬鏋滃伐搴廔D娌℃湁鍙樺寲锛屽垯鍏佽
+ if (OperationType == 3 && currentBillID && currentBillID !== "0") {
+ if (originalProcessID && originalProcessID === processID) {
+ return true; // 宸ュ簭娌′慨鏀癸紝鍏佽淇濆瓨
+ }
+ }
+
+ var index = layer.load(1, { shade: [0.1, '#fff'] });
+ var isUnique = true;
+
+ $.ajax({
+ url: GetWEBURL() + "/Gy_SteppedPriceCoefficientBill/CheckProcessUnique",
+ type: "POST",
+ async: false,
+ contentType: "application/json",
+ data: JSON.stringify({
+ "HProcID": processID,
+ "HStockOrgID": $("#HStockOrgID").val(),
+ "ExcludeID": currentBillID || "0",
+ "user": sessionStorage["HUserName"] || "admin"
+ }),
+ success: function (result) {
+ layer.close(index);
+ if (result && result.code == "1") {
+ if (result.data && result.data.exists) {
+ isUnique = false;
+ var existingBillNo = result.data.billNo || "";
+
+ if (existingBillNo) {
+ layer.msg(processName + "宸插湪鍗曟嵁[" + existingBillNo + "]涓娇鐢紝涓�涓伐搴忓彧鑳藉搴斾竴鏉¢樁姊伐浠风郴鏁版暟鎹�!", {
+ icon: 5,
+ time: 5000
+ });
+ } else {
+ layer.msg(processName + "宸插瓨鍦ㄥ叾浠栧崟鎹腑锛屼竴涓伐搴忓彧鑳藉搴斾竴鏉¢樁姊伐浠风郴鏁版暟鎹�!", {
+ icon: 5,
+ time: 5000
+ });
+ }
+ }
+ } else {
+ layer.msg("宸ュ簭鍞竴鎬ф鏌ュけ璐ワ紝璇风◢鍚庨噸璇�", { icon: 3 });
+ }
+ },
+ error: function () {
+ layer.close(index);
+ layer.msg("宸ュ簭鍞竴鎬ф鏌ユ湇鍔℃殏鏃朵笉鍙敤", { icon: 3 });
+ // 涓轰簡涓嶉樆濉炵敤鎴凤紝杩欓噷杩斿洖true锛屼絾鐢熶骇鐜搴旇鏍规嵁闇�姹傝皟鏁�
+ isUnique = true;
+ }
+ });
+
+ return isUnique;
+ }
+
+ function set_AddNew(data) {
+ if (window.isSaving) {
+ layer.msg("姝e湪淇濆瓨锛岃绋嶅��...", { icon: 0 });
+ return;
+ }
+ window.isSaving = true;
+
+ var originalText = $('#btnSave').text();
+ $('#btnSave').text('淇濆瓨涓�...').addClass("layui-btn-disabled").attr("disabled", true);
+
+ var tableMain = {
+ "HInterID": $("#HInterID").val() || "0",
+ "HYear": new Date($("#HDate").val()).getFullYear(),
+ "HPeriod": new Date($("#HDate").val()).getMonth() + 1,
+ "HBillType": "",
+ "HBillSubType": "",
+ "HDate": $("#HDate").val() || Format(new Date(), "yyyy-MM-dd"),
+ "HBillNo": $("#HBillNo").val() || "",
+ "HBillStatus": 1,
+ "HRemark": $("#HRemark").val() || "",
+ "HProcID": $("#HProcID").val() || "0",
+ "HEmpID": $("#HEmpID").val() || "0",
+ "HDeptID": $("#HDeptID").val() || "0",
+ "HStockOrgID": $("#HStockOrgID").val() || "0",
+ "HMaker": sessionStorage["HUserName"] || "admin",
+ "HMakeDate": Format(new Date(), "yyyy-MM-dd HH:mm:ss")
+ };
+
+ var tableSub = [];
+ var tableCache = table.cache["mainTable"];
+
+ if (tableCache && tableCache.length > 0) {
+ for (var i = 0; i < tableCache.length; i++) {
+ var row = tableCache[i];
+ if (row && row != "") {
+ var subItem = {
+ "HSeq": row["HSeq"] || (i + 1),
+ "HMinQty": row["HMinQty"] || "0",
+ "HMaxQty": row["HMaxQty"] || "0",
+ "HPriceCoefficient": row["HPriceCoefficient"] || "1.0",
+ "HMaxPrice": row["HMaxPrice"] || "0",
+ "HRemark": row["HRemark"] || "",
+ "HStockOrgID": row["HStockOrgID"] || $("#HStockOrgID").val() || "0"
+ };
+ tableSub.push(subItem);
+ }
+ }
+ }
+
+ tableMain.SubItems = tableSub;
+
+ var requestData = {
+ "oMain": JSON.stringify(tableMain) + ";" + (sessionStorage["HUserName"] || "admin")
+ };
+
+ var index = layer.load(2, { time: 0 });
+
+ $.ajax({
+ type: "POST",
+ url: GetWEBURL() + "/Gy_SteppedPriceCoefficientBill/ModifyByID",
+ contentType: "application/json",
+ data: JSON.stringify(requestData),
+ dataType: "json",
+ timeout: 30000,
+ success: function (result) {
+ layer.close(index);
+ window.isSaving = false;
+ $('#btnSave').text(originalText).removeClass("layui-btn-disabled").attr("disabled", false);
+
+ if (result.code == "1") {
+ layer.msg("淇濆瓨鎴愬姛锛�", { icon: 1, time: 2000 });
+ $('#btnSave').addClass("layui-btn-disabled").attr("disabled", true);
+
+ if (OperationType == 1) {
+ OperationType = 3;
+ }
+ } else {
+ layer.msg("宸ュ簭鏈�夋嫨");
+ }
+ },
+ error: function (xhr, status, error) {
+ layer.close(index);
+ window.isSaving = false;
+ $('#btnSave').text(originalText).removeClass("layui-btn-disabled").attr("disabled", false);
+
+ var errorMsg = "璇锋眰澶辫触锛�<br>";
+ if (status === "timeout") {
+ errorMsg += "璇锋眰瓒呮椂";
+ } else {
+ errorMsg += "閿欒浠g爜: " + xhr.status + "<br>閿欒淇℃伅: " + error;
+ }
+
+ layer.msg(errorMsg, { icon: 5, time: 5000 });
+ }
+ });
+ }
+
+ function AllowLoadData(data) {
+ var temp;
+ var ref = /^\d+(\.\d+)?$/;
+ var refInt = /^\d+$/;
+
+ // 琛ㄥご鏁版嵁妫�楠�
+ if ($("#HBillNo").val() == "") {
+ layer.msg("鍗曟嵁鍙蜂笉鑳戒负绌�!");
+ return false;
+ }
+ if ($("#HDate").val() == "") {
+ layer.msg("鏃ユ湡涓嶈兘涓虹┖!");
+ return false;
+ }
+ if ($("#HProcID").val() == "0") {
+ layer.msg("宸ュ簭鏈�夋嫨!");
+ return false;
+ }
+ if ($("#HStockOrgID").val() == "0") {
+ layer.msg("缁勭粐鏈�夋嫨!");
+ return false;
+ }
+
+ // 鏂板锛氭鏌ュ伐搴忔槸鍚﹀凡瀛樺湪
+ if (!checkProcessUnique()) {
+ return false;
+ }
+
+ // 瀛愯〃鏁版嵁妫�楠�
+ var tableData = table.cache["mainTable"];
+ if (!tableData || tableData.length == 0) {
+ layer.msg("璇疯嚦灏戞坊鍔犱竴鏉¢樁姊暟鎹�!");
+ return false;
+ }
+
+ var validRows = 0;
+ for (var i = 0; i < tableData.length; i++) {
+ if (tableData[i] && tableData[i] != "") {
+ validRows++;
+ var rowData = tableData[i];
+
+ temp = rowData["HMinQty"];
+ if (temp == "" || !refInt.test(temp) || parseInt(temp) < 0) {
+ layer.msg("绗�" + (i + 1) + "琛�:鏈�灏忔暟閲忓繀椤讳负闈炶礋鏁存暟!");
+ return false;
+ }
+
+ temp = rowData["HMaxQty"];
+ if (temp == "" || !refInt.test(temp) || parseInt(temp) < 0) {
+ layer.msg("绗�" + (i + 1) + "琛�:鏈�澶ф暟閲忓繀椤讳负闈炶礋鏁存暟!");
+ return false;
+ }
+
+ if (parseInt(rowData["HMinQty"]) > parseInt(rowData["HMaxQty"])) {
+ layer.msg("绗�" + (i + 1) + "琛�:鏈�灏忔暟閲忎笉鑳藉ぇ浜庢渶澶ф暟閲�!");
+ return false;
+ }
+
+ temp = rowData["HPriceCoefficient"];
+ if (temp == "" || !ref.test(temp) || parseFloat(temp) <= 0) {
+ layer.msg("绗�" + (i + 1) + "琛�:宸ヤ环绯绘暟蹇呴』涓烘鏁�!");
+ return false;
+ }
+
+ temp = rowData["HMaxPrice"];
+ if (temp == "" || !ref.test(temp) || parseFloat(temp) < 0) {
+ layer.msg("绗�" + (i + 1) + "琛�:鏈�澶у伐浠峰繀椤讳负闈炶礋鏁�!");
+ return false;
+ }
+ }
+ }
+
+ if (validRows === 0) {
+ layer.msg("璇疯嚦灏戞坊鍔犱竴鏉℃湁鏁堢殑闃舵鏁版嵁!");
+ return false;
+ }
+
+ if (!checkStepNonOverlap(true)) {
+ return false;
+ }
+
+ return true;
+ }
+
+ function checkStepNonOverlap(isValidation) {
+ var tableData = table.cache["mainTable"];
+ if (!tableData || tableData.length <= 1) return true;
+
+ var validData = [];
+ for (var i = 0; i < tableData.length; i++) {
+ if (tableData[i] && tableData[i] != "") {
+ var minQty = parseInt(tableData[i]["HMinQty"]);
+ var maxQty = parseInt(tableData[i]["HMaxQty"]);
+
+ if (minQty > maxQty) {
+ if (isValidation) {
+ layer.msg("绗�" + tableData[i]["HSeq"] + "闃�:鏈�灏忔暟閲忎笉鑳藉ぇ浜庢渶澶ф暟閲�!");
+ return false;
+ } else {
+ layer.msg("绗�" + tableData[i]["HSeq"] + "闃�:鏈�灏忔暟閲忎笉鑳藉ぇ浜庢渶澶ф暟閲�!", { icon: 2 });
+ return false;
+ }
+ }
+ validData.push(tableData[i]);
+ }
+ }
+
+ if (validData.length <= 1) return true;
+
+ validData.sort(function (a, b) {
+ return parseInt(a.HMinQty) - parseInt(b.HMinQty);
+ });
+
+ for (var i = 1; i < validData.length; i++) {
+ var prevMin = parseInt(validData[i - 1]["HMinQty"]);
+ var prevMax = parseInt(validData[i - 1]["HMaxQty"]);
+ var currMin = parseInt(validData[i]["HMinQty"]);
+ var currMax = parseInt(validData[i]["HMaxQty"]);
+
+ if (currMin <= prevMax) {
+ if (isValidation) {
+ layer.msg("绗�" + validData[i]["HSeq"] + "闃朵笌绗�" + validData[i - 1]["HSeq"] + "闃�:闃舵鑼冨洿閲嶅彔!");
+ return false;
+ } else {
+ layer.msg("绗�" + validData[i]["HSeq"] + "闃朵笌绗�" + validData[i - 1]["HSeq"] + "闃�:闃舵鑼冨洿閲嶅彔!");
+ }
+ }
+ }
+ return true;
+ }
+
+ function updateSeq() {
+ var tableData = table.cache["mainTable"];
+ if (!tableData) return;
+
+ var seq = 1;
+ for (var i = 0; i < tableData.length; i++) {
+ if (tableData[i] && tableData[i] != "") {
+ tableData[i].HSeq = seq;
+ seq++;
+ }
+ }
+ option.data = tableData;
+ table.render(option);
+ }
+
+ function set_GridDelete(obj) {
+ if (obj.event === 'del') {
+ layer.confirm('鐪熺殑鍒犻櫎琛屽悧锛�', function (index) {
+ var oldData = table.cache["mainTable"];
+ if (oldData && obj.tr.data('index') < oldData.length) {
+ oldData.splice(obj.tr.data('index'), 1)
+ option.data = oldData;
+ table.render(option);
+ updateSeq();
+ layer.close(index);
+ }
+ });
+ }
+ }
+
+ function get_HideColumn() {
+ var colName = "";
+ var contentUrl = "";
+ for (var i = 1; i < option.cols[0].length - 1; i++) {
+ colName += option.cols[0][i]["title"] + ",";
+ }
+ var urlStr = window.document.location.pathname;
+ var urlLen = urlStr.split('/');
+ for (var i = 0; i < urlLen.length - 4; i++) {
+ contentUrl += "../";
+ }
+ colName = encodeURI(colName.substring(0, colName.length - 1));
+
+ contentUrl += '鍩虹璧勬枡/闅愯棌鍒楄缃�/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName;
+
+ layer.open({
+ type: 2
+ , skin: "layui-layer-rim"
+ , title: "闅愯棌鍒楄缃�"
+ , closeBtn: 1
+ , shift: 2
+ , area: ["50%", "90%"]
+ , maxmin: true
+ , content: [contentUrl, "yes"]
+ , btn: ["纭畾", "鍙栨秷"]
+ , btn1: function (index, laero) {
+ DisPlay_HideColumn();
+ layer.close(index);
+ }
+ });
+ }
+
+ function DisPlay_HideColumn() {
+ $.ajax({
+ url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
+ type: "GET",
+ data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
+ async: false,
+ success: function (data1) {
+ if (data1.data.length != 0) {
+ var dataCol = [];
+ var titleData = ["琛屽彿", "缁勭粐ID"];
+
+ dataCol = data1.data[0].HGridString.split(',');
+
+ for (var i = 0; i < option.cols[0].length - 2; i++) {
+ var dataCols = dataCol[i].split('|');
+ if (dataCols[1] == 1) {
+ option.cols[0][i + 1]["hide"] = true;
+ }
+ if (dataCols[3] > 0) {
+ option.cols[0][i + 1]["width"] = dataCols[3];
+ }
+ if (data1.data[0].HFontSize != 0) {
+ option.cols[0][i + 1]["style"] += "font-size:" + data1.data[0].HFontSize + "px;";
+ } else {
+ option.cols[0][i + 1]["style"] += "font-size:100%";
+ }
+ if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
+ option.cols[0][i + 1]["hide"] = false;
+ }
+ switch (dataCols[2]) {
+ case "L":
+ option.cols[0][i + 1]["align"] = "left";
+ break;
+ case "M":
+ option.cols[0][i + 1]["align"] = "center";
+ break;
+ case "R":
+ option.cols[0][i + 1]["align"] = "right";
+ break;
+ }
+ }
+
+ for (var i = 1; i < option.cols[0].length - 1; i++) {
+ if (option.cols[0][i]["fixed"] != null) {
+ option.cols[0][i]["fixed"] = null;
+ }
+ else {
+ break;
+ }
+ }
+ if (data1.data[0].HFixCols != 0) {
+ for (var i = 0; i < data1.data[0].HFixCols; i++) {
+ if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
+ data1.data[0].HFixCols += 1;
+ }
+ option.cols[0][i + 1]["fixed"] = "left";
+ }
+ }
+ table.render(option);
+ } else {
+ table.render(option);
+ }
+ }, error: function () {
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ });
+ }
+ });
function get_checkSearchHProc() {
layer.open({
diff --git "a/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\351\230\266\346\242\257\345\267\245\344\273\267\347\263\273\346\225\260/Gy_SteppedPriceCoefficientBillList.html" "b/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\351\230\266\346\242\257\345\267\245\344\273\267\347\263\273\346\225\260/Gy_SteppedPriceCoefficientBillList.html"
index e0383ab..fad6f7e 100644
--- "a/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\351\230\266\346\242\257\345\267\245\344\273\267\347\263\273\346\225\260/Gy_SteppedPriceCoefficientBillList.html"
+++ "b/WebTM/views/\345\267\245\350\265\204\347\256\241\347\220\206/\351\230\266\346\242\257\345\267\245\344\273\267\347\263\273\346\225\260/Gy_SteppedPriceCoefficientBillList.html"
@@ -15,9 +15,27 @@
<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/HideButton.js"></script>
<script src="../../../layuiadmin/soulTable.slim.js"></script>
<script src="../../../layuiadmin/PageTitle.js"></script>
+ <script src="../../../layuiadmin/SetColumn.js"></script>
+ <script src="../../../layuiadmin/HideButton_New.js"></script>
+ <script src="../../../layuiadmin/QueryScheme.js"></script>
+
+ <script>
+ // 纭繚鎵�鏈夐渶瑕佺殑鍑芥暟閮藉凡瀹氫箟
+ window.onload = function () {
+ // 瀹氫箟 Format 浣滀负 Pub_Format 鐨勫埆鍚嶏紙濡傛灉 Pub_Format 瀛樺湪锛�
+ if (typeof Pub_Format !== 'undefined' && typeof Format === 'undefined') {
+ window.Format = Pub_Format;
+ }
+
+ // 妫�鏌� SetColumn.js 鏄惁鍔犺浇鎴愬姛
+ console.log("椤甸潰鍔犺浇瀹屾垚妫�鏌�:");
+ console.log("Pub_Format:", typeof Pub_Format);
+ console.log("Format:", typeof Format);
+ console.log("DisPlay_HideColumn_GetPageSize:", typeof DisPlay_HideColumn_GetPageSize);
+ };
+ </script>
<style type="text/css">
input.layui-input.layui-unselect {
@@ -195,343 +213,687 @@
, element = layui.element
, laypage = layui.laypage
, laydate = layui.laydate
+ , util = layui.util
, soulTable = layui.soulTable
+ // 妫�鏌ュ叏灞�鍑芥暟
+ console.log("鍏ㄥ眬鍑芥暟妫�鏌�:");
+ console.log("Pub_Format:", typeof Pub_Format);
+ console.log("GetWEBURL:", typeof GetWEBURL);
+
var HModName = "Gy_SteppedPriceCoefficientBillList";
var HBillType = "GYSTPRICECOEFF";
- var HMaker = sessionStorage["HUserName"]
- var HStockOrgID = sessionStorage["OrganizationID"] //缁勭粐ID
- var sWhere = "";
- var ins; //鐢ㄤ簬瀵煎嚭excel
- var option = [];
- var page = 1;//鍒嗛〉鏁版嵁
- var size = 50;
- var columns = "";
- var titleData = []; //涓嶉渶瑕佹樉绀虹殑瀛楁
- //#endregion
+ var HMaker = sessionStorage["HUserName"];
+ var Organization = sessionStorage["Organization"];
- //#region 銆愬姩鎬佽幏鍙栨ā鍧楀悕绉般��
- //閫氳繃鍗曟嵁绫诲瀷锛屼粠鏁版嵁搴撳姩鎬佽幏鍙栧崟鎹ā鍧楀懡鍚�,寮曠敤js鏂囦欢 PageTitle.js
- var HPageTitle = get_PageTitle(HBillType) == "" ? document.title : get_PageTitle(HBillType);
- //#endregion
+ // 鏌ヨ鏉′欢
+ var sWhere = "";
+ var option = {};
+ var page = 1;
+ var size = 50;
+ var set_HideButton_ID = "toolbarDemo_ButtonSet"; // 鎸夐挳瀹瑰櫒ID
//#region 銆愯繃婊ゆ柟妗堛��
//杩囨护鏉′欢鐨刢lass绫�
- var HClassTag = "ForFilteringSchemes";
+ window.HClassTag = "ForFilteringSchemes";
//妯″潡鍚嶇О锛堜腑鏂囩増锛� 姣忎釜妯″潡椤甸潰閮介渶瑕佷慨鏀�
window.HModuleName = "闃舵宸ヤ环绯绘暟鍗曞垪琛�";
//鏄惁宸茬粡閫夋嫨浜嗚繃婊ゆ柟妗堬紙鍏ㄥ眬鍙橀噺锛�
window.HDefaultFilter = "";
//閫夋嫨鐨勮繃婊ゆ柟妗堝唴鐮侊紙鍏ㄥ眬鍙橀噺锛�
window.HInterID_Choose = 0;
+ //#endregion
//#endregion
- //#region 杩涘叆椤甸潰鍗冲姞杞�
+ //#region 杩涘叆椤甸潰鏃㈠姞杞�
- //#region 鍒濆鍖栫晫闈�
-
- set_ClearBill();
-
- function set_ClearBill() {
- // 鍒濆鍖栧埗鍗曟棩鏈熻寖鍥达紙鏈�杩�30澶╋級
- var endDate = new Date();
- var startDate = new Date(endDate - 1000 * 60 * 60 * 24 * 30);
-
- $("#HMakeDate_Begin").val(Pub_Format(startDate, "yyyy-MM-dd"));
- $("#HMakeDate_End").val(Pub_Format(endDate, "yyyy-MM-dd"));
-
- //鍒濆鍖栬〃鏍�
- set_InitGrid();
- //鏌ヨ褰撳墠鐧诲綍鐢ㄦ埛鏈夋病鏈夊湪褰撳墠妯″潡璁剧疆榛樿杩囨护鏂规
- get_DefaultModule();
+ //鍒濆鍖栬〃鏍�
+ set_InitGrid();
+ //鍒濆鍖栭〉澶у皬
+ if (typeof DisPlay_HideColumn_GetPageSize === 'function') {
+ DisPlay_HideColumn_GetPageSize(HModName, sessionStorage["HUserName"], option);
+ }
+ //鍔犺浇鏁版嵁鍒扮綉鏍�
+ get_FastQuery();
+ //鏌ヨ褰撳墠鐧诲綍鐢ㄦ埛鏈夋病鏈夊湪褰撳墠妯″潡璁剧疆榛樿杩囨护鏂规
+ if (typeof get_DefaultModule === 'function') {
+ get_DefaultModule(get_FastQuery);
}
//#endregion
- //#region 鍒濆鍖栬〃鏍兼柟娉�
- function set_InitGrid() {
- option = {
- elem: '#mainTable'
- , toolbar: '#toolbarDemo'
- , page: false
- , totalRow: true
- , height: 'full-50'
- , cellMinWidth: 90
- , limit: 50
- , limits: [50, 500, 5000, 20000]
- , done: function (res, curr, count) {
- soulTable.render(this);
- }
-
- };
- optionPage = {
- elem: 'page', //娉ㄦ剰锛岃繖閲岀殑 page 鏄� ID锛屼笉鐢ㄥ姞 # 鍙�
- count: 10000, //鏁版嵁鎬绘暟锛屼粠鏈嶅姟绔緱鍒�
- limit: 50,
- limits: [50, 500, 5000, 50000],
- layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
- jump: function (obj, first) {
- //棣栨涓嶆墽琛�
- if (!first) {
- //do something
- page = obj.curr;
- size = obj.limit;
- get_FastQuery();
- }
- }
- }
- laypage.render(optionPage);
- }
- //#endregion
-
- //#region 鐐瑰嚮琛岄�変腑楂樹寒
- table.on('row(mainTable)', function (obj) {
- //閫変腑琛屾敼鍙橀鑹�
- var flag = !obj.tr.find(':checkbox:first').prop('checked');
- obj.tr.find(':checkbox').prop('checked', flag);
- if (flag) {
- obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //璁剧疆澶嶉�夋閫変腑鏍峰紡
- $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//鏀瑰彉褰撳墠tr鑳屾櫙棰滆壊鍜屽瓧浣撻鑹�
- } else {
- obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//鍙栨秷澶嶉�夋閫変腑鏍峰紡
- $(obj.tr.selector).attr({ "style": "background:" });//鍙栨秷褰撳墠tr棰滆壊
- }
- //mainTable 涓鸿〃鏍糏D 娉ㄦ剰姝ゅ濡傛灉ID涓嶆纭皢瀵艰嚧浣犲湪鐩戝惉澶嶉�夋鏃惰幏鍙栦笉鍒颁綘閫夋嫨鐨勬暟鎹紝鍓嶉潰鐨勫彧鏄坊鍔犳垨鍒犻櫎閫変腑鏈�変腑鏍峰紡浠ュ強璁剧疆鑳屾櫙鑹诧紝瀛椾綋棰滆壊
- layui.each(table.cache.mainTable, function (i, l) {
- if (obj.tr.index() == l.LAY_TABLE_INDEX) {
- l.LAY_CHECKED = flag;
- }
- });
- })
- //#endregion
-
- table.on('tool(mainTable)', function (obj) {
- var data = obj.data;
- if (obj.event == '鍗曟嵁鍙�') {
- // 瀹夊叏鑾峰彇HInterID
- var HInterID = data.HInterID ? data.HInterID.toString() : "";
- var HBillNo = data.HBillNo || "";
-
- if (!HInterID || HInterID === "0") {
- HInterID = data.hmainid ? data.hmainid.toString() : "";
- }
-
- console.log("鐐瑰嚮鍗曟嵁鍙�:", HBillNo, "HInterID:", HInterID);
-
- if (HInterID && HInterID !== "0") {
- layer.open({
- type: 2,
- area: ['100%', '100%'],
- title: HPageTitle + ' - 缂栬緫锛�' + HBillNo + '锛�',
- shift: 0,
- content: '../../宸ヨ祫绠$悊/闃舵宸ヤ环绯绘暟/Gy_SteppedPriceCoefficientBillEdit.html?OperationType=3&linterid=' + HInterID + '&HSouceBillType=',
- btn: ['纭畾'],
- end: function (index, layero, that) {
- $("#btnSearch").trigger('click');
- }
- });
- } else {
- console.error("鏃犳硶鑾峰彇鏈夋晥鐨凥InterID瀛楁锛屾暟鎹�:", data);
- layer.msg("鏃犳硶鎵撳紑鍗曟嵁锛屽崟鎹甀D鏃犳晥", { icon: 5 });
- }
- }
- });
-
- //#region 鏄剧ず鍒楁暟鎹�
- function DisPlay_HideColumn() {
- $.ajax({
- url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
- type: "GET",
- async: false,
- data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
- success: function (data1) {
- if (data1.data.length != 0) {
- var dataCol = [];//鏁版嵁搴撴煡璇㈠嚭鐨勫垪鏁版嵁
- var newCols = [[]];//瀵瑰簲鏁版嵁搴撳垪椤哄簭col
- newCols[0].push(option.cols[0][0]);//鏀惧叆绗竴涓猚heckbox
- dataCol = data1.data[0].HGridString.split(',');
- //鍒楄缃垪鏁颁笌椤甸潰鍒楁暟鏄惁涓�鑷�
- if (dataCol.length == option.cols[0].length - 1) {
- //閬嶅巻瀵绘壘鍒楄缃搴斿垪鎸夐『搴忔彃鍏�
- for (var j = 0; j < option.cols[0].length - 1; j++) {
- for (var i = 0; i < option.cols[0].length - 1; i++) {
- var dataCols = dataCol[j].split('|');
- //閫夋嫨涓巇atacols鐩稿簲鍒楄繘琛屼慨鏀�
- if (option.cols[0][i + 1]["field"] == dataCols[5]) {
- //闅愯棌鍒�
- if (dataCols[1] == 1) {
- option.cols[0][i + 1]["hide"] = true;
- }
- //璁剧疆鍒楀
- if (dataCols[3] > 0) {
- option.cols[0][i + 1]["width"] = dataCols[3];
- }
- //璁剧疆鍐呭瀛椾綋澶у皬
- if (data1.data[0].HFontSize != 0) {
- option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
- } else {
- option.cols[0][i + 1]["style"] = "font-size:100%";
- }
- //鏄剧ず鍒�
- if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
- option.cols[0][i + 1]["hide"] = false;
- }
- //缁熻鍒�
- if (dataCols[6] == 1) {
- option.cols[0][i + 1]["totalRow"] = true;
- }
- //瀛椾綋鎵�鍦ㄤ綅缃�(宸� 灞呬腑 鍙�)
- switch (dataCols[2]) {
- case "L":
- option.cols[0][i + 1]["align"] = "left";
- break;
- case "M":
- option.cols[0][i + 1]["align"] = "center";
- break;
- case "R":
- option.cols[0][i + 1]["align"] = "right";
- break;
- }
- //璁剧疆琛ㄦ牸title灞炴�ф樉绀哄埆鍚�
- if (dataCols[4] != null && dataCols[4] != "") {
- option.cols[0][i + 1]["title"] = dataCols[4];
- }
- newCols[0].push(option.cols[0][i + 1]);
- }
- }
- }
- //閬嶅巻寰幆鍚庡垽鏂搴斿垪鏁版槸鍚︿竴鑷�
- if (dataCol.length == newCols[0].length - 1) {
- option.cols = newCols;
- //鍙栨秷鍐荤粨鍒�
- for (var i = 1; i < option.cols[0].length - 1; i++) {
- if (option.cols[0][i]["fixed"] != null) {
- option.cols[0][i]["fixed"] = null;
- }
- else {
- break;
- }
- }
- //鍐荤粨鍒�
- if (data1.data[0].HFixCols != 0) {
- for (var i = 0; i < data1.data[0].HFixCols; i++) {
- if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
- data1.data[0].HFixCols += 1;
- }
- option.cols[0][i + 1]["fixed"] = "left";
- }
- }
- }
- }
- ins=table.render(option);
-
- } else {
- ins=table.render(option);
-
- }
- //鍒锋柊鎸夐挳鏄剧ず
- var btns = document.getElementsByTagName("button"); //鑾峰彇鏈〉鎵�鏈夋寜閽璞�
- Display_HideButton(btns, HBillType, HModName, HMaker);
- }, error: function () {
- layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
- }
- })
- }
- //#endregion
-
- //#endregion
-
- //#region 鏈〉闈㈡墍鏈夎璋冪敤鐨勬柟娉�
-
- //#region 宸ュ叿鏍忎簨浠�
+ //#region 鐐瑰嚮浜嬩欢鍖呮嫭on form浜嬩欢绛�
+ //澶村伐鍏锋爮浜嬩欢
table.on('toolbar(mainTable)', function (obj) {
switch (obj.event) {
- //瀵煎嚭鎸夐挳
- case 'btn_Export': btn_Export();
- break;
//鏂板鎸夐挳
case 'btn_Add': btn_Add();
break;
//缂栬緫鎸夐挳
case 'btn_Edit': btn_Edit();
break;
- //鎵撳嵃
- case 'btn-print':
- get_PrintReport();
- break;
//鍒犻櫎鎸夐挳
case 'btn_Delete': btn_Delete();
break;
- //鍒锋柊鎸夐挳
- case 'btn_Refresh': btn_Refresh();
+ //鎵撳嵃
+ case 'btn-print': get_PrintReport();
break;
- //瀹℃牳鎸夐挳 锛�1:瀹℃牳銆�2:鍙嶅鏍革級
+ //瀹℃牳
case 'btn_Audit': set_CheckBill(1);
break;
- //鍙嶅鏍告寜閽�
+ //鍙嶅鏍�
case 'btn_DeAudit': set_CheckBill(2);
break;
- //鍏抽棴鎸夐挳 锛�1:鍏抽棴銆�2:鍙嶅叧闂級
+ //鍒锋柊
+ case 'btn_Refresh': btn_Refresh();
+ break;
+ //鍏抽棴
case 'btn_Close': set_CloseBill(1);
break;
- //鍙嶅叧闂寜閽�
+ //鍙嶅叧闂�
case 'btn_DeClose': set_CloseBill(2);
break;
- //浣滃簾鎸夐挳 锛�1:浣滃簾銆�2:鍙嶄綔搴燂級
+ //浣滃簾
case 'btn_Drop': set_DropBill(1);
break;
- //鍙嶄綔搴熸寜閽�
+ //鍙嶄綔搴�
case 'btn_DeDrop': set_DropBill(2);
break;
- //閫�鍑烘寜閽�
- case 'btn_Exit': Pub_Close(2);
+ //閫�鍑�
+ case 'btn_Exit':
+ if (typeof Pub_Close === 'function') {
+ Pub_Close(2);
+ }
break;
//鍒楄缃�
- case 'btn_HideColumn': get_HideColumn();
+ case 'btn_HideColumn':
+ if (typeof get_HideColumnNoPage === 'function') {
+ get_HideColumnNoPage(HModName, sessionStorage["HUserName"], option, get_FastQuery);
+ }
break;
//鎸夐挳璁剧疆
case 'btn_HideButton':
- var btns = document.getElementsByTagName("button"); //鑾峰彇鏈〉鎵�鏈夋寜閽璞�
- get_HideButton(btns, HBillType, HModName, HMaker);
+ if (typeof get_HideButton === 'function') {
+ get_HideButton(set_HideButton_ID, HBillType, HModName, sessionStorage["HUserName"]);
+ }
break;
//淇濆瓨鏂规
- case 'btn_SaveScheme': set_SaveScheme();
+ case 'btn_SaveScheme':
+ if (typeof set_SaveScheme === 'function') {
+ set_SaveScheme(get_FastQuery);
+ }
break;
//璇诲彇鏂规
- case 'btn_ReadScheme': set_ReadScheme();
+ case 'btn_ReadScheme':
+ if (typeof set_ReadScheme === 'function') {
+ set_ReadScheme(get_FastQuery);
+ }
+ break;
+ //瀵煎嚭
+ case 'btn_Export': btn_Export();
break;
};
});
+
+ //閲嶇疆鎸夐挳
+ form.on('submit(btnReSearch)', function (data) {
+ set_ClearQuery();
+ get_FastQuery();
+ });
+
+ //鍒锋柊
+ function btn_Refresh() {
+ $("#btnSearch").click();
+ // 鍒锋柊鍚庨噸鏂拌缃垪鏍囬
+ setTimeout(refreshTableWithChineseTitles, 500);
+
+ }
+
+ //鏌ヨ鎸夐挳
+ form.on('submit(btnSearch)', function (data) {
+ get_FastQuery();
+ });
+
+ //杈撳叆妗嗗洖杞︽柟娉�
+ $('input').on('keydown', function (event) {
+ if (event.keyCode == 13) {
+ get_FastQuery();
+ }
+ });
//#endregion
- //#region 瀵煎嚭Execel
- //#region 瀵煎嚭Execel
- function btn_Export() {
- var data;
- //璁剧疆sWhere
- var ajaxLoad = layer.load();
+ //#region 姝ら〉闈㈡墍鏈夋柟娉�
+ //鍒濆鍖栬〃鏍�
+ function set_InitGrid() {
+ console.log("=== set_InitGrid 寮�濮� ===");
- // 浣跨敤鍒跺崟鏃ユ湡浣滀负鍒涘缓鏃堕棿杩囨护
- var HMakeDate_Begin = $("#HMakeDate_Begin").val(); // 寮�濮嬪埗鍗曟棩鏈�
- var HMakeDate_End = $("#HMakeDate_End").val(); // 缁撴潫鍒跺崟鏃ユ湡
- var HBillNo = $("#HBillNo").val(); // 鍗曟嵁鍙�
+ // 璁剧疆鏃ユ湡榛樿鍊�
+ var endDate = new Date();
+ var startDate = new Date(endDate - 1000 * 60 * 60 * 24 * 30);
+ if (typeof Pub_Format === 'function') {
+ console.log("浣跨敤 Pub_Format 鍑芥暟");
+ $("#HMakeDate_Begin").val(Pub_Format(startDate, "yyyy-MM-dd"));
+ $("#HMakeDate_End").val(Pub_Format(endDate, "yyyy-MM-dd"));
+ } else {
+ console.log("Pub_Format 涓嶅瓨鍦紝浣跨敤鍘熺敓鏂规硶");
+ $("#HMakeDate_Begin").val(startDate.toISOString().split('T')[0]);
+ $("#HMakeDate_End").val(endDate.toISOString().split('T')[0]);
+ }
+
+ console.log("寮�濮嬫棩鏈熷��:", $("#HMakeDate_Begin").val());
+ console.log("缁撴潫鏃ユ湡鍊�:", $("#HMakeDate_End").val());
+
+ option = {
+ elem: '#mainTable'
+ , toolbar: '#toolbarDemo'
+ , page: false
+ , cellMinWidth: 120
+ , totalRow: true
+ , limit: 50
+ , height: 'full-50'
+ , cols: [] // 鍒濆涓虹┖锛屽姩鎬佸姞杞�
+ , limits: [50, 500, 5000, 20000]
+ , done: function (res, curr, count) {
+ console.log("=== 琛ㄦ牸娓叉煋瀹屾垚鍥炶皟 ===");
+ console.log("鎬绘潯鏁�:", count);
+ console.log("琛ㄦ牸鏁版嵁鏉℃暟:", res.data ? res.data.length : 0);
+
+ if (count === 0) {
+ console.warn("琛ㄦ牸鏁版嵁涓虹┖锛�");
+ layer.msg("鏆傛棤鏁版嵁", { icon: 3 });
+ }
+
+ if (typeof soulTable !== 'undefined') {
+ soulTable.render(this);
+ }
+ }
+ };
+
+ console.log("琛ㄦ牸鍒濆鍖栧畬鎴�");
+ }
+
+ // 瀛楁鍚嶅埌涓枃鏍囬鐨勬槧灏�
+ function getColumnChineseTitle(fieldName) {
+ var titleMap = {
+ // 涓昏〃瀛楁
+ "HInterID": "鍗曟嵁鍐呯爜",
+ "HItemMainID": "涓昏〃鍐呯爜",
+ "HBillNo": "鍗曟嵁鍙�",
+ "HDate": "鍗曟嵁鏃ユ湡",
+ "HYear": "骞翠唤",
+ "HPeriod": "鏈堜唤",
+ "HBillType": "鍗曟嵁绫诲瀷",
+ "HBillSubType": "鍗曟嵁瀛愮被鍨�",
+ "HBillStatus": "鍗曟嵁鐘舵��",
+ "HRemark": "涓昏〃澶囨敞",
+ "HChecker": "瀹℃牳浜�",
+ "HCheckDate": "瀹℃牳鏃ユ湡",
+ "HMaker": "鍒跺崟浜�",
+ "HMakeDate": "鍒跺崟鏃ユ湡",
+ "HUpDater": "淇敼浜�",
+ "HUpDateDate": "淇敼鏃ユ湡",
+ "HCloseMan": "鍏抽棴浜�",
+ "HCloseDate": "鍏抽棴鏃ユ湡",
+ "HCloseType": "鍏抽棴绫诲瀷",
+ "HDropMan": "浣滃簾浜�",
+ "HDropDate": "浣滃簾鏃ユ湡",
+ "HReturnMan": "閫�鍥炰汉",
+ "HReturnDate": "閫�鍥炴棩鏈�",
+ "HReturnReason": "閫�鍥炲師鍥�",
+ "HProcID": "宸ュ簭ID",
+ "HEmpID": "璐熻矗浜篒D",
+ "HDeptID": "閮ㄩ棬ID",
+ "HStockOrgID": "缁勭粐ID",
+
+ // 瀛愯〃瀛楁
+ "HItemID": "瀛愯〃鍐呯爜",
+ "RowNum": "搴忓彿",
+ "HMinQty": "鏈�灏忔暟閲�",
+ "HMaxQty": "鏈�澶ф暟閲�",
+ "HCoefficient": "宸ヤ环绯绘暟",
+ "HMaxPrice": "鏈�澶у伐浠�",
+ "HRowCloseMan": "琛屽叧闂汉",
+ "HRowCloseDate": "琛屽叧闂棩鏈�",
+ "HRowCloseType": "琛屽叧闂被鍨�",
+ "HRowRemark": "瀛愯〃澶囨敞",
+ "HRelativeQty": "鍏宠仈鏁伴噺",
+ "HRelativeMoney": "鍏宠仈閲戦",
+ "HSubStockOrgID": "瀛愯〃缁勭粐ID",
+ "HSourceHInterID": "婧愬崟ID",
+ "HSourceItemID": "婧愬崟瀛怚D",
+ "HSourceBillNo": "婧愬崟鍗曞彿",
+ "HSourceBillType": "婧愬崟绫诲瀷",
+ // 鏂板鐨勬眹鎬诲瓧娈�
+ "TotalMinQty": "鎬绘渶灏忔暟閲�",
+ "TotalMaxQty": "鎬绘渶澶ф暟閲�",
+ "TotalCoefficient": "鎬荤郴鏁�",
+ "SubCount": "瀛愯〃琛屾暟",
+ "TotalMaxPrice": "鎬讳环鏍�"
+
+
+ };
+
+ return titleMap[fieldName] || fieldName;
+ }
+
+ // ========== 鏍稿績淇锛氱洿鎺ヤ娇鐢ㄩ澶勭悊鏁版嵁 ==========
+ // 鍩轰簬鎺у埗鍙版樉绀虹殑鏁版嵁鏍煎紡杩涜绠�鍗曞鐞�
+ // 瓒呯骇绠�鍗曠殑鏃ユ湡鏄剧ず鍑芥暟 - 涓撻棬澶勭悊鎮ㄧ殑鏁版嵁鏍煎紡
+ // 閫氱敤鏃ユ湡鏍煎紡鍖栧嚱鏁� - 閫傞厤鎵�鏈夊悗绔繑鍥炴牸寮�
+ function formatDateForDisplay(fieldName, dateValue) {
+ if (!dateValue) return '';
+
+ // 杞负瀛楃涓插苟娓呯悊棣栧熬绌烘牸
+ var str = String(dateValue).trim();
+
+ // 杩囨护缁濆鏃犳晥鐨勯粯璁ゆ棩鏈�
+ var invalidDates = ['2001-10-01', '1900-01-01', '2000-01-01', '1970-01-01'];
+ if (invalidDates.some(invalid => str.startsWith(invalid))) {
+ return '';
+ }
+
+ // 鍦烘櫙1锛氬鐞嗙壒娈婃牸寮� 2025-12-11(15):48:28
+ if (str.includes('(') && str.includes(')')) {
+ try {
+ // 鎻愬彇鏃ユ湡閮ㄥ垎 2025-12-11 鍜屾椂闂撮儴鍒� 15:48:28
+ var datePart = str.split('(')[0].trim();
+ var timePart = str.split('(')[1].replace(')', '').split(':').slice(0, 3).join(':');
+ // 鍗曟嵁鏃ユ湡鍙樉绀烘棩鏈燂紝鍏朵粬鏃堕棿鏄剧ず瀹屾暣鏍煎紡
+ return fieldName === 'HDate' ? datePart : `${datePart} ${timePart}`;
+ } catch (e) {
+ console.warn(`瑙f瀽鐗规畩鏍煎紡鏃ユ湡澶辫触: ${str}`, e);
+ }
+ }
+
+ // 鍦烘櫙2锛氬鐞� ISO 鏍煎紡 2025-12-16T14:33:50 鎴� 2025-12-16T14:33:50.35
+ if (str.includes('T')) {
+ try {
+ var [datePart, timePart] = str.split('T');
+ // 绉婚櫎鏃堕棿閮ㄥ垎鐨勬绉�
+ var cleanTime = timePart.includes('.') ? timePart.split('.')[0] : timePart;
+ // 鍙繚鐣欐椂鍒嗙
+ cleanTime = cleanTime.split(':').slice(0, 3).join(':');
+ return fieldName === 'HDate' ? datePart : `${datePart} ${cleanTime}`;
+ } catch (e) {
+ console.warn(`瑙f瀽ISO鏍煎紡鏃ユ湡澶辫触: ${str}`, e);
+ }
+ }
+
+ // 鍦烘櫙3锛氬鐞嗙函鏃ユ湡 2025-12-16 鎴� 瀹屾暣鏃堕棿 2025-12-16 14:33:50
+ if (str.match(/^\d{4}-\d{2}-\d{2}/)) {
+ // 鍖归厤 骞�-鏈�-鏃� 寮�澶寸殑鍚堟硶鏍煎紡
+ if (fieldName === 'HDate' || str.length === 10) {
+ return str.substring(0, 10); // 鍙樉绀烘棩鏈�
+ } else {
+ // 琛ュ叏鏃堕棿閮ㄥ垎锛堝鏋滃彧鏈夋棩鏈燂級
+ return str.length > 10 ? str : `${str} 00:00:00`;
+ }
+ }
+
+ // 鎵�鏈夎В鏋愬け璐ョ殑鎯呭喌锛岃繑鍥炲師濮嬪�硷紙閬垮厤绌烘樉绀猴級
+ return str;
+ }
+
+
+
+ //鍔犺浇缃戞牸锛堝姩鎬佸垪鍔犺浇鏂规硶锛�
+ //鍔犺浇缃戞牸锛堝姩鎬佸垪鍔犺浇鏂规硶锛�
+
+ function get_Display(sWhere) {
+ var wait = layer.load();
+
+ $.ajax({
+ url: GetWEBURL() + '/Gy_SteppedPriceCoefficientBill/list',
+ type: "GET",
+ data: {
+ "sWhere": sWhere || "",
+ "user": sessionStorage["HUserName"] || "guest"
+ },
+ success: function (data1) {
+ console.log("=== API 杩斿洖鏁版嵁 ===");
+
+ if (data1 && data1.list && data1.list.length > 0) {
+ console.log("鍒楀畾涔夋暟閲�:", data1.list.length);
+
+ // 姝ラ1锛氬垪鍘婚噸
+ var uniqueColumns = [];
+ var seenColumns = new Set();
+ var columnData = [];
+
+ for (var key in data1.list) {
+ var colDef = data1.list[key];
+ var colName = colDef.ColmCols;
+
+ if (!seenColumns.has(colName)) {
+ seenColumns.add(colName);
+ uniqueColumns.push(colDef);
+ columnData.push({
+ "id": colName,
+ "name": colName,
+ "Type": colDef.ColmType,
+ "chineseTitle": getColumnChineseTitle(colName)
+ });
+ }
+ }
+
+ console.log("鍘婚噸鍚庡垪鏁�:", columnData.length);
+
+ // 姝ラ2锛氭瀯寤鸿〃鏍煎垪閰嶇疆 - 浣跨敤宸ュ巶鍑芥暟閬垮厤闂寘闂
+ var col = [];
+
+ // 娣诲姞鍕鹃�夋
+ col.push({ type: 'checkbox', fixed: 'left', totalRowText: '鍚堣' });
+
+ // 鍒涘缓妯℃澘鍑芥暟鐢熸垚鍣�
+ function createTempletFunction(fieldName, fieldType) {
+ switch (fieldType) {
+ case 'DateTime':
+ return function (d) {
+ var value = d[fieldName];
+ if (!value) return '';
+
+ var str = String(value).trim();
+
+ // 杩囨护鏃犳晥鏃ユ湡
+ var invalidDates = ['2001-10-01', '1900-01-01', '2000-01-01', '1970-01-01', '0001-01-01'];
+ if (invalidDates.some(invalid => str.startsWith(invalid))) {
+ return '';
+ }
+
+ // 鎻愬彇鏃ユ湡閮ㄥ垎
+ if (str.includes('(')) {
+ return str.split('(')[0].trim();
+ } else if (str.includes('T')) {
+ return str.split('T')[0];
+ } else if (str.match(/^\d{4}-\d{2}-\d{2}/)) {
+ return str.substring(0, 10);
+ }
+
+ return str;
+ };
+
+ case 'Decimal':
+ case 'Double':
+ case 'Float':
+ return function (d) {
+ var value = d[fieldName];
+ if (value === null || value === undefined || value === '') {
+ return '';
+ }
+ var num = parseFloat(value);
+ return isNaN(num) ? '' : num.toFixed(2);
+ };
+
+ case 'Int32':
+ case 'Int64':
+ case 'Integer':
+
+
+ // 鏁存暟绫诲瀷鐨勭壒娈婂鐞�
+ if (fieldName === 'HBillStatus') {
+ return function (d) {
+ var status = d[fieldName] || '0';
+ // 杞崲涓烘暟瀛楀啀鍒ゆ柇
+ var statusNum = parseInt(status);
+ switch (statusNum) {
+ case 1: return '鏈';
+ case 2: return '瀹℃牳閫氳繃';
+ case 3: return '鍏抽棴';
+ case 4: return '浣滃簾';
+ case 5: return '瀹℃牳閫�鍥�';
+ case 6: return '瀹℃牳涓�';
+ case 7: return '宸查槄';
+ case 8: return '宸插洖澶�';
+ case 9: return '缁撴';
+ case 10: return '楠岃瘉';
+ case 11: return '涓嬭揪';
+ case 12: return '寮�宸�';
+ case 13: return '鐢宠瀹℃壒';
+ case 15: return '鐢宠妫�楠�';
+ case 16: return '鍒ゅ畾鍚堟牸';
+ case 17: return '鍒ゅ畾涓嶅悎鏍�';
+ case 0:
+ default: return '鏈'; // 榛樿鏄剧ず涓烘湭瀹�
+ }
+ };
+ }
+ return null; // 鍏朵粬鏁存暟绫诲瀷涓嶉渶瑕佺壒娈婃ā鏉�
+
+ default:
+ // 鏂囨湰瀛楁鐨勭壒娈婂鐞�
+ if (fieldName === 'HBillNo') {
+ return function (d) {
+ var billNo = d[fieldName] || '';
+ return '<span style="color: blue; cursor: pointer;">' + billNo + '</span>';
+ };
+ }
+ return null;
+ }
+ }
+
+ // 鍒涘缓浜嬩欢澶勭悊鏄犲皠
+ function getEventForField(fieldName) {
+ if (fieldName === 'HBillNo') {
+ return '鍗曟嵁鍙�';
+ }
+ return null;
+ }
+
+ // 鑾峰彇瀹藉害璁剧疆
+ function getWidthForField(fieldName, fieldType) {
+ if (fieldName === 'HBillNo') return 500;
+ if (fieldName === 'HBillStatus') return 100;
+ if (fieldType === 'DateTime') return 160;
+ if (fieldType === 'Decimal' || fieldType === 'Double' || fieldType === 'Float') return 120;
+ if (fieldType === 'Int32' || fieldType === 'Int64' || fieldType === 'Integer') return 100;
+ return 150;
+ }
+
+ // 鑾峰彇瀵归綈鏂瑰紡
+ function getAlignForField(fieldType) {
+ if (fieldType === 'Decimal' || fieldType === 'Double' || fieldType === 'Float' ||
+ fieldType === 'Int32' || fieldType === 'Int64' || fieldType === 'Integer') {
+ return 'right';
+ }
+ return 'center';
+ }
+
+ // 鏋勫缓鍒楅厤缃�
+ // 鏋勫缓鍒楅厤缃�
+ for (var i = 0; i < columnData.length; i++) {
+ var colItem = columnData[i];
+ var columnTitle = colItem.chineseTitle;
+ var fieldName = colItem.id;
+ var fieldType = colItem.Type;
+ var columnTitle = getColumnChineseTitle(fieldName); // 杩欓噷閲嶅浜嗭紝鍒犻櫎杩欎竴琛�
+
+ var columnConfig = {
+ field: fieldName,
+ title: columnTitle, // 纭繚浣跨敤涓枃鏍囬
+ align: getAlignForField(fieldType),
+ sort: true,
+ width: getWidthForField(fieldName, fieldType)
+ };
+
+
+ // 璁剧疆妯℃澘鍑芥暟
+ var templetFunc = createTempletFunction(fieldName, fieldType);
+ if (templetFunc) {
+ columnConfig.templet = templetFunc;
+ }
+
+ // 璁剧疆浜嬩欢
+ var event = getEventForField(fieldName);
+ if (event) {
+ columnConfig.event = event;
+ }
+
+ col.push(columnConfig);
+ }
+
+ console.log("鏋勫缓鐨勫垪閰嶇疆鏁伴噺:", col.length);
+ // 璋冭瘯锛氭樉绀哄墠鍑犱釜鍒楃殑閰嶇疆
+ for (var j = 0; j < Math.min(5, col.length); j++) {
+ console.log(`鍒�${j}: field=${col[j].field}, title=${col[j].title}, templet=${typeof col[j].templet}`);
+ }
+
+ // 姝ラ3锛氬鐞嗚〃鏍兼暟鎹�
+ var tableData = data1.data || [];
+ console.log("鍘熷鏁版嵁鏉℃暟:", tableData.length);
+
+ // 璋冭瘯锛氭樉绀哄墠鍑犺鏁版嵁鐨勬墍鏈夊瓧娈�
+ if (tableData.length > 0) {
+ console.log("=== 绗竴琛屾暟鎹畬鏁寸粨鏋� ===");
+ var firstRow = tableData[0];
+ for (var key in firstRow) {
+ console.log(`${key}: ${firstRow[key]} (绫诲瀷: ${typeof firstRow[key]})`);
+ }
+ }
+
+ // 濡傛灉鏄富琛ㄥ垪琛紝鎸夊崟鎹彿鍘婚噸
+ if (tableData.length > 0 && tableData[0].HBillNo) {
+ var uniqueMap = {};
+ var uniqueList = [];
+
+ for (var k = 0; k < tableData.length; k++) {
+ var row = tableData[k];
+ var billNo = row.HBillNo;
+
+ if (!uniqueMap[billNo]) {
+ uniqueMap[billNo] = true;
+ uniqueList.push(row);
+ }
+ }
+
+ tableData = uniqueList;
+ console.log("鍘婚噸鍚庢暟鎹潯鏁�:", tableData.length);
+ }
+
+ // 姝ラ4锛氶厤缃苟娓叉煋琛ㄦ牸
+ option.cols = [col];
+ option.data = tableData;
+
+ console.log("option 閰嶇疆:", {
+ colsLength: option.cols[0].length,
+ dataLength: option.data.length
+ });
+
+ // 鍒楄缃�
+ // 淇敼 get_Display 鍑芥暟涓殑鍒楄缃儴鍒�
+ // 鍒楄缃�
+ // 鍒楄缃�
+ if (typeof DisPlay_HideColumn === 'function') {
+ // 鍏堜繚瀛樺師濮嬪垪閰嶇疆锛堜腑鏂囨爣棰橈級
+ var originalCols = [];
+ for (var i = 0; i < col.length; i++) {
+ originalCols.push({
+ field: col[i].field,
+ title: col[i].title,
+ align: col[i].align,
+ sort: col[i].sort,
+ width: col[i].width,
+ templet: col[i].templet,
+ event: col[i].event
+ });
+ }
+
+ // 鎵ц鍒楄缃�
+ DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option);
+
+ // 寮哄埗鎵ц涓枃鏍囬鎭㈠
+ setTimeout(function () {
+ if (option.cols && option.cols[0]) {
+ var currentCols = option.cols[0];
+ for (var i = 0; i < currentCols.length; i++) {
+ var currentCol = currentCols[i];
+ if (currentCol.field && currentCol.field !== 'LAY_CHECKED' && currentCol.field !== 'checkbox') {
+ // 鏌ユ壘鍘熷閰嶇疆涓殑涓枃鏍囬
+ for (var j = 0; j < originalCols.length; j++) {
+ if (originalCols[j].field === currentCol.field) {
+ currentCol.title = originalCols[j].title;
+ break;
+ }
+ }
+ }
+ }
+ }
+
+ // 閲嶆柊娓叉煋琛ㄦ牸
+ try {
+ table.render(option);
+ console.log("琛ㄦ牸宸查噸鏂版覆鏌擄紝鍒楁爣棰樺己鍒朵负涓枃");
+ } catch (e) {
+ console.error("琛ㄦ牸娓叉煋閿欒:", e);
+ }
+ }, 200);
+ }
+
+ // 閲嶆柊鍒濆鍖栦笅鎷夋
+ ColFilter();
+
+ // 娓叉煋琛ㄦ牸
+ // 娓叉煋琛ㄦ牸
+ try {
+ // 鍏堥攢姣佹棫鐨勮〃鏍�
+ var mainTable = table.render(option);
+ console.log("琛ㄦ牸娓叉煋鎴愬姛");
+
+ // 娴嬭瘯锛氭鏌ヨ〃鏍兼暟鎹�
+ var tableCache = table.cache.mainTable;
+ if (tableCache && tableCache.length > 0) {
+ console.log("琛ㄦ牸缂撳瓨绗竴琛屾暟鎹�:");
+ var cacheRow = tableCache[0];
+ console.log("HBillNo:", cacheRow.HBillNo);
+ console.log("HDate:", cacheRow.HDate);
+ console.log("TotalCoefficient:", cacheRow.TotalCoefficient);
+ }
+ } catch (e) {
+ console.error("琛ㄦ牸娓叉煋閿欒:", e);
+ layer.msg("琛ㄦ牸娓叉煋澶辫触: " + e.message, { icon: 5 });
+ }
+
+ layer.close(wait);
+
+ if (tableData.length > 0) {
+ layer.msg(`鍏� ${tableData.length} 鏉℃暟鎹甡, { icon: 1, time: 2000 });
+ } else {
+ layer.msg("鏆傛棤鏁版嵁", { icon: 3, time: 2000 });
+ }
+ } else {
+ console.warn("鏁版嵁鏍煎紡涓嶆纭垨 list 涓虹┖");
+ layer.close(wait);
+ layer.msg("鏁版嵁鍔犺浇澶辫触", { icon: 2 });
+ }
+ },
+ error: function (xhr, status, error) {
+ console.error("AJAX 璇锋眰閿欒:", error);
+ layer.close(wait);
+ layer.alert("鎺ュ彛璇锋眰澶辫触! 鐘舵�佺爜: " + xhr.status, { icon: 5 });
+ }
+ });
+ }
+
+
+ //蹇�熻繃婊�
+ function get_FastQuery() {
+ var HMakeDate_Begin = $("#HMakeDate_Begin").val();
+ var HMakeDate_End = $("#HMakeDate_End").val();
+ var HBillNo = $("#HBillNo").val();
var ColName = $("#ColName").val();
- var Comparator = $("#Comparator").val()
+ var Comparator = $("#Comparator").val();
var ColContent = $("#ColContent").val();
-
var ColName1 = $("#ColName1").val();
- var Comparator1 = $("#Comparator1").val()
+ var Comparator1 = $("#Comparator1").val();
var ColContent1 = $("#ColContent1").val();
var ColName2 = $("#ColName2").val();
- var Comparator2 = $("#Comparator2").val()
+ var Comparator2 = $("#Comparator2").val();
var ColContent2 = $("#ColContent2").val();
- // 娓呯┖涔嬪墠鐨勬潯浠�
sWhere = "";
- // 淇锛氱‘淇濆湪杩愮畻绗﹀拰鍊间箣闂存湁绌烘牸
- if (ColName && ColName != 0 && Comparator && Comparator != 0 && ColContent) {
+ // 鏋勫缓鏉′欢琛ㄨ揪寮�
+ if (ColName && ColName != "0" && Comparator && Comparator != "0" && ColContent) {
var com = "";
switch (Comparator) {
case "7":
@@ -547,14 +909,12 @@
com = "not like '%" + ColContent + "%'";
break;
default:
- // 鍏抽敭淇锛氬湪杩愮畻绗﹀拰鍊间箣闂存坊鍔犵┖鏍�
com = Comparator + " '" + ColContent + "'";
break;
}
sWhere += " and " + ColName + " " + com;
}
-
- if (ColName1 && ColName1 != 0 && Comparator1 && Comparator1 != 0 && ColContent1) {
+ if (ColName1 && ColName1 != "0" && Comparator1 && Comparator1 != "0" && ColContent1) {
var com1 = "";
switch (Comparator1) {
case "7":
@@ -575,8 +935,7 @@
}
sWhere += " and " + ColName1 + " " + com1;
}
-
- if (ColName2 && ColName2 != 0 && Comparator2 && Comparator2 != 0 && ColContent2) {
+ if (ColName2 && ColName2 != "0" && Comparator2 && Comparator2 != "0" && ColContent2) {
var com2 = "";
switch (Comparator2) {
case "7":
@@ -598,256 +957,209 @@
sWhere += " and " + ColName2 + " " + com2;
}
- // 鍒跺崟鏃ユ湡锛堝垱寤烘椂闂达級鑼冨洿鏌ヨ
+ // 娣诲姞鏃ユ湡鏉′欢
if (HMakeDate_Begin) {
- sWhere += " and HMakeDate >= '" + HMakeDate_Begin + "'";
+ sWhere += " and CONVERT(date, HMakeDate) >= '" + HMakeDate_Begin + "'";
}
if (HMakeDate_End) {
- sWhere += " and HMakeDate <= '" + HMakeDate_End + "'";
+ sWhere += " and CONVERT(date, HMakeDate) <= '" + HMakeDate_End + "'";
}
-
- // 鍗曟嵁鍙锋煡璇�
if (HBillNo) {
sWhere += " and HBillNo like '%" + HBillNo + "%'";
}
- console.log("瀵煎嚭鏌ヨ鏉′欢:", sWhere);
+ // 绉婚櫎寮�澶寸殑 "and "
+ if (sWhere.startsWith(" and ")) {
+ sWhere = sWhere.substring(5);
+ }
- $.ajax({
- type: "GET",
- url: GetWEBURL() + '/Gy_SteppedPriceCoefficientBillController/GetGy_SteppedPriceCoefficientBillList_Json',
- async: false,
- data: { "sWhere": sWhere, "HMaker": HMaker },
- success: function (data1) {
- if (data1.count == 1) {
- data = data1.data
- layer.close(ajaxLoad);
- } else {
- layer.close(ajaxLoad);
- layer.alert(data1.Message, { icon: 5 });
+ console.log("鍙戦�佸埌鍚庣鐨� sWhere 鏉′欢:", sWhere);
+
+ get_Display(sWhere);
+ }
+
+ //閲嶇疆杩囨护鏉′欢
+ function set_ClearQuery() {
+ var endDate = new Date();
+ var startDate = new Date(endDate - 1000 * 60 * 60 * 24 * 30);
+
+ // 浣跨敤姝g‘鐨勫嚱鏁板悕锛歅ub_Format
+ if (typeof Pub_Format === 'function') {
+ $("#HMakeDate_Begin").val(Pub_Format(startDate, "yyyy-MM-dd"));
+ $("#HMakeDate_End").val(Pub_Format(endDate, "yyyy-MM-dd"));
+ } else {
+ $("#HMakeDate_Begin").val(startDate.toISOString().split('T')[0]);
+ $("#HMakeDate_End").val(endDate.toISOString().split('T')[0]);
+ }
+
+ $("#HBillNo").val("");
+ $("#ColContent").val("");
+ $("#ColName").val("0");
+ $("#Comparator").val("0");
+ $("#ColContent2").val("");
+ $("#ColName2").val("0");
+ $("#Comparator2").val("0");
+ $("#ColContent1").val("");
+ $("#ColName1").val("0");
+ $("#Comparator1").val("0");
+ form.render('select');
+ sWhere = "";
+ }
+
+ //#region 鍒楁槑鏄剧ず涓嬫媺妗�
+ function ColFilter() {
+ var Organization = '<option value="0" selected="selected" ></option>';
+ if (option.cols && option.cols[0]) {
+ for (var i = 1; i < option.cols[0].length; 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>';
}
- },
- error: function () {
- layer.close(ajaxLoad);
- layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ }
+ $("#ColName").empty();
+ $("#ColName").append(Organization);
+ $("#ColName1").empty();
+ $("#ColName1").append(Organization);
+ $("#ColName2").empty();
+ $("#ColName2").append(Organization);
+ form.render('select');
+ }
+ //#endregion
+
+ // 琛ㄦ牸琛岀偣鍑讳簨浠�
+ table.on('row(mainTable)', function (obj) {
+ var flag = !obj.tr.find(':checkbox:first').prop('checked');
+ obj.tr.find(':checkbox').prop('checked', flag);
+ if (flag) {
+ obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');
+ $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });
+ } else {
+ obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');
+ $(obj.tr.selector).attr({ "style": "background:" });
+ }
+ layui.each(table.cache.mainTable, function (i, l) {
+ if (obj.tr.index() == l.LAY_TABLE_INDEX) {
+ l.LAY_CHECKED = flag;
}
});
+ });
- // 娓呯┖鏉′欢
- sWhere = "";
+ // 鍗曟嵁鍙风偣鍑讳簨浠�
+ table.on('tool(mainTable)', function (obj) {
+ var data = obj.data;
+ if (obj.event == '鍗曟嵁鍙�') {
+ var HInterID = data.HInterID || data.hmainid;
+ var HBillNo = data.HBillNo || '';
- // 澶勭悊鏁版嵁
- if (data) {
- data.forEach((item) => {
- for (let itemobj in item) {
- if (item[itemobj] == null) {
- item[itemobj] = "";
+ if (HInterID && HInterID != "0") {
+ layer.open({
+ type: 2,
+ area: ['100%', '100%'],
+ title: '闃舵宸ヤ环绯绘暟鍗� - 缂栬緫锛�' + HBillNo + '锛�',
+ shift: 0,
+ content: '../../宸ヨ祫绠$悊/闃舵宸ヤ环绯绘暟/Gy_SteppedPriceCoefficientBillEdit.html?OperationType=3&linterid=' + HInterID + '&HSouceBillType=',
+ btn: ['纭畾'],
+ end: function () {
+ $("#btnSearch").trigger('click');
+ setTimeout(refreshTableWithChineseTitles, 200);
}
- if (item[itemobj] && item[itemobj].length > 0) {
- item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, '');
- }
- }
- });
-
- table.exportFile(ins.config.id, data, "xls");
+ });
+ }
}
- }
+ });
- //#endregion
-
- //#region 鏂板
+ // 鏂板鎸夐挳
function btn_Add() {
layer.open({
- type: 2
- , skin: 'layui-layer-rim' //鍔犱笂杈规
- , area: ['100%', '100%']
- , title: HPageTitle + '- 鏂板'
- , shift: 0 //寮瑰嚭鍔ㄧ敾
- , content: '../../宸ヨ祫绠$悊/闃舵宸ヤ环绯绘暟/Gy_SteppedPriceCoefficientBillEdit.html?OperationType=1&linterid=0&HSouceBillType='
- , btn: ['纭畾'],
- // 鎸夐挳1 鐨勫洖璋�
- end: function (index, layero, that) {
- //鍒锋柊椤甸潰
+ type: 2,
+ area: ['100%', '100%'],
+ title: '闃舵宸ヤ环绯绘暟鍗� - 鏂板',
+ shift: 0,
+ content: '../../宸ヨ祫绠$悊/闃舵宸ヤ环绯绘暟/Gy_SteppedPriceCoefficientBillEdit.html?OperationType=1&linterid=0&HSouceBillType=',
+ btn: ['纭畾'],
+ end: function () {
$("#btnSearch").trigger('click');
+ setTimeout(refreshTableWithChineseTitles, 200);
}
- })
+ });
}
- //#endregion
- //#region 缂栬緫
+ // 缂栬緫鎸夐挳
function btn_Edit() {
- var checkStatus = table.checkStatus('mainTable');
- var data = checkStatus.data;
-
- console.log("缂栬緫鎸夐挳鐐瑰嚮锛岄�変腑鏁版嵁:", data);
-
+ var checkStatus = table.checkStatus('mainTable'),
+ data = checkStatus.data;
if (data && data.length === 1) {
- // 瀹夊叏鍦拌幏鍙栧瓧娈靛�硷紝娣诲姞绌哄�兼鏌�
- var HInterID = data[0].HInterID ? data[0].HInterID.toString() : "";
- var HBillNo = data[0].HBillNo ? data[0].HBillNo.toString() : "";
+ var HInterID = data[0].HInterID || data[0].hmainid;
+ var HBillNo = data[0].HBillNo || '';
- // 濡傛灉HInterID涓虹┖锛屽皾璇曚粠鍏朵粬瀛楁鑾峰彇
- if (!HInterID || HInterID === "0") {
- // 灏濊瘯鍏朵粬鍙兘鐨勫瓧娈靛悕
- HInterID = data[0].hmainid ? data[0].hmainid.toString() : "";
- HInterID = data[0].hMainID ? data[0].hMainID.toString() : HInterID;
+ if (HInterID && HInterID != "0") {
+ layer.open({
+ type: 2,
+ area: ['100%', '100%'],
+ title: '闃舵宸ヤ环绯绘暟鍗� - 缂栬緫锛�' + HBillNo + '锛�',
+ shift: 0,
+ content: '../../宸ヨ祫绠$悊/闃舵宸ヤ环绯绘暟/Gy_SteppedPriceCoefficientBillEdit.html?OperationType=3&linterid=' + HInterID + '&HSouceBillType=',
+ btn: ['纭畾'],
+ end: function () {
+ $("#btnSearch").trigger('click');
+ setTimeout(refreshTableWithChineseTitles, 200);
+ }
+ });
}
-
- console.log("鎻愬彇鐨凥InterID:", HInterID, "HBillNo:", HBillNo);
-
- if (!HInterID || HInterID === "0") {
- layer.msg("鏃犳硶鑾峰彇鍗曟嵁ID鎴朓D鏃犳晥", { icon: 5 });
- console.error("鏃犳硶鑾峰彇鏈夋晥鐨勫崟鎹甀D锛屾暟鎹璞�:", data[0]);
- return;
- }
-
- // 淇璺緞闂锛氱‘淇濅娇鐢ㄦ纭殑璺緞
- // 娉ㄦ剰锛氶敊璇俊鎭腑鐨勮矾寰勫寘鍚腑鏂囩紪鐮侊紝闇�瑕佺‘淇濊矾寰勬纭�
- layer.open({
- type: 2,
- area: ['100%', '100%'],
- title: HPageTitle + ' - 缂栬緫锛�' + HBillNo + '锛�',
- shift: 0,
- // 娉ㄦ剰锛氱‘淇濊矾寰勬纭紝浠庨敊璇俊鎭湅鍙兘鏄矾寰勯棶棰�
- content: '../../宸ヨ祫绠$悊/闃舵宸ヤ环绯绘暟/Gy_SteppedPriceCoefficientBillEdit.html?OperationType=3&linterid=' + HInterID + '&HSouceBillType=',
- btn: ['纭畾'],
- end: function (index, layero, that) {
- // 鍒锋柊椤甸潰
- $("#btnSearch").trigger('click');
- },
- success: function (layero, index) {
- console.log("缂栬緫椤甸潰鎵撳紑鎴愬姛锛孒InterID:", HInterID);
- },
- error: function (xhr, status, error) {
- console.error("鎵撳紑缂栬緫椤甸潰澶辫触:", error);
- layer.msg("鎵撳紑缂栬緫椤甸潰澶辫触锛岃妫�鏌ヨ矾寰勯厤缃�", { icon: 5 });
- }
- });
} else {
layer.msg('璇烽�夋嫨涓�琛屾暟鎹紪杈戯紒');
}
}
- //#endregion
- //#region 鍒犻櫎
- // 鏇挎崲鍘焍tn_Delete鏂规硶
+ // 鍒犻櫎鎸夐挳
function btn_Delete() {
var checkStatus = table.checkStatus('mainTable'),
data = checkStatus.data;
- if (checkStatus.data.length === 1) {
+ if (data && data.length === 1) {
var HInterID = data[0].HInterID || data[0].hmainid;
var HBillNo = data[0].HBillNo || '';
- if (!HInterID) {
- layer.msg('鍗曟嵁ID鏃犳晥锛�', { icon: 5 });
- return;
- }
- layer.confirm("纭瑕佸垹闄ら�変腑琛屾暟鎹紵鍒犻櫎鍚庡皢涓嶅彲鎭㈠锛�", { title: "鍒犻櫎纭" }, function (index) {
- var wait = layer.load();
+
+ layer.confirm("纭瑕佸垹闄ら�変腑琛屾暟鎹紵", { title: "鍒犻櫎纭" }, function (index) {
$.ajax({
type: "GET",
url: GetWEBURL() + "/Gy_SteppedPriceCoefficientBill/delete",
async: false,
data: { "HInterID": HInterID, "user": HMaker },
success: function (result) {
- layer.close(wait);
if (result.code === "1") {
- layer.msg("鍗曟嵁鍙凤細" + HBillNo + " 鍒犻櫎鎴愬姛锛�", { time: 1000, icon: 1 }, function () {
+ layer.msg("鍒犻櫎鎴愬姛锛�", { time: 1000, icon: 1 }, function () {
$("#btnSearch").trigger('click');
+ setTimeout(refreshTableWithChineseTitles, 200);
});
} else {
layer.msg(result.Message || "鍒犻櫎澶辫触", { icon: 2 });
}
},
- error: function (xhr, status, error) {
- layer.close(wait);
- layer.msg('鍒犻櫎澶辫触锛�' + error, { icon: 5 });
+ error: function () {
+ layer.msg('鍒犻櫎澶辫触锛�', { icon: 5 });
}
});
- })
+ });
} else {
layer.msg('璇烽�夋嫨涓�琛屾暟鎹垹闄わ紒');
}
}
- //#endregion
- //#region 鍒锋柊
- function btn_Refresh() {
- get_FastQuery();
+ // 瀵煎嚭鎸夐挳
+ function btn_Export() {
+ layer.msg("瀵煎嚭鍔熻兘寰呭疄鐜�", { icon: 1 });
}
- //#endregion
-
- //#region 闅愯棌鍒楄缃�
- function Display_HideButton(btns, HBillType, HModName, HMaker) {
- // 绀轰緥閫昏緫锛氭牴鎹潈闄愭樉绀�/闅愯棌鎸夐挳
- $.ajax({
- url: GetWEBURL() + '/Xt_ButtonPermission/GetButtonPermission',
- type: 'GET',
- data: { HBillType: HBillType, HModName: HModName, UserName: HMaker },
- success: function (data) {
- if (data.code === "1" && data.data) {
- var permission = data.data;
- for (var i = 0; i < btns.length; i++) {
- var btnId = btns[i].id;
- if (permission[btnId] === "0") {
- btns[i].style.display = "none";
- } else {
- btns[i].style.display = "inline-block";
- }
- }
- }
- }
- });
- }
-
- // 閫�鍑烘寜閽柟娉�
- function Pub_Close(type) {
- if (type === 2) {
- var index = parent.layer.getFrameIndex(window.name);
- parent.layer.close(index);
- }
- }
- //#endregion
-
- //#region 鎵撳嵃鍔熻兘
- function get_PrintReport() {
- var checkStatus = table.checkStatus('mainTable')
- , data = checkStatus.data;
-
- if (checkStatus.data.length === 0) {
- return layer.msg('璇烽�夋嫨鏁版嵁鎵撳嵃锛�');
- }
- else {
- var hmainid = [];
- for (var i = 0; i < checkStatus.data.length; i++) {
- hmainid.push((data[i].hmainid * (10 ** 8)) + data[i].hsubid)
- }
-
- layer.open({
- type: 2
- , area: ['50%', '50%']
- , title: '鎵撳嵃妯$増閫夋嫨'
- , shade: 0.6 //閬僵閫忔槑搴�
- , maxmin: false //鍏佽鍏ㄥ睆鏈�灏忓寲
- , anim: 0 //0-6鐨勫姩鐢诲舰寮忥紝-1涓嶅紑鍚�
- , content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + hmainid.toString() + '&MyMsg=' + hmainid.toString() + '&Type=Gy_SteppedPriceCoefficientBillList', 'yes']
- , resize: false
- })
- }
- }
- //#endregion
//#region 瀹℃牳锛坣um=1锛�/鍙嶅鏍革紙num=2锛�
function set_CheckBill(num) {
var checkStatus = table.checkStatus('mainTable'),
data = checkStatus.data;
if (checkStatus.data.length === 1) {
- // 缁熶竴浣跨敤HInterID锛屽吋瀹筯mainid
var HInterID = data[0].HInterID || data[0].hmainid;
if (!HInterID) {
layer.msg('鍗曟嵁ID鏃犳晥锛�', { icon: 5 });
return;
}
- // 杞崲鍙傛暟锛氬鏍�=0锛屽弽瀹℃牳=1
var IsAudit = num === 1 ? 0 : 1;
$.ajax({
type: "GET",
@@ -862,6 +1174,7 @@
if (result.code === "1") {
layer.msg(result.Message || (num === 1 ? "瀹℃牳鎴愬姛" : "鍙嶅鏍告垚鍔�"), { time: 1000, icon: 1 }, function () {
$("#btnSearch").trigger('click');
+ setTimeout(refreshTableWithChineseTitles, 200);
});
} else {
layer.msg(result.Message || "鎿嶄綔澶辫触", { icon: 2 });
@@ -876,762 +1189,64 @@
}
}
//#endregion
+ function refreshTableWithChineseTitles() {
+ console.log("=== 寮�濮嬭缃腑鏂囧垪鏍囬 ===");
- //#region 鍏抽棴锛坣um=1锛�/鍙嶅叧闂紙num=2锛�
- // 鏇挎崲鍘焥et_CloseBill鏂规硶
+ // 纭繚鍒楁爣棰樹负涓枃
+ if (option.cols && option.cols[0]) {
+ var cols = option.cols[0];
+ console.log("褰撳墠鍒楁暟:", cols.length);
+
+ for (var i = 0; i < cols.length; i++) {
+ var col = cols[i];
+ if (col.field && col.field !== 'LAY_CHECKED' && col.field !== 'checkbox') {
+ var chineseTitle = getColumnChineseTitle(col.field);
+ if (chineseTitle && chineseTitle !== col.field) { // 纭繚涓嶆槸瀛楁鍚嶆湰韬�
+ col.title = chineseTitle;
+ console.log(`璁剧疆鍒楁爣棰�: ${col.field} -> ${chineseTitle}`);
+ }
+ }
+ }
+ }
+
+ // 閲嶆柊娓叉煋琛ㄦ牸
+ try {
+ table.render(option);
+ console.log("琛ㄦ牸宸查噸鏂版覆鏌擄紝鍒楁爣棰樹负涓枃");
+ } catch (e) {
+ console.error("琛ㄦ牸娓叉煋閿欒:", e);
+ }
+ }
+
function set_CloseBill(num) {
var checkStatus = table.checkStatus('mainTable'),
data = checkStatus.data;
- if (checkStatus.data.length === 1) {
- var HInterID = data[0].HInterID || data[0].hmainid;
- if (!HInterID) {
- layer.msg('鍗曟嵁ID鏃犳晥锛�', { icon: 5 });
- return;
- }
- // 杞崲鍙傛暟锛氬叧闂�=0锛屽弽鍏抽棴=1
- var IsClose = num === 1 ? 0 : 1;
- $.ajax({
- type: "GET",
- url: GetWEBURL() + "/Gy_SteppedPriceCoefficientBill/CloseGy_SteppedPriceCoefficientBill",
- async: false,
- data: {
- "HInterID": HInterID,
- "IsAudit": IsClose, // 鏀� IsClose 涓� IsAudit
- "user": HMaker // 鏀� CurUserName 涓� user
- },
- success: function (result) {
- if (result.code === "1") {
- layer.msg(result.Message || (num === 1 ? "鍏抽棴鎴愬姛" : "鍙嶅叧闂垚鍔�"), { time: 1000, icon: 1 }, function () {
- $("#btnSearch").trigger('click');
- });
- } else {
- layer.msg(result.Message || "鎿嶄綔澶辫触", { icon: 2 });
- }
- },
- error: function () {
- layer.msg('鎺ュ彛璇锋眰澶辫触锛�', { icon: 5 });
- }
- });
+ if (data && data.length === 1) {
+ // 瀹炵幇鍏抽棴閫昏緫
} else {
- layer.msg(num === 1 ? '璇烽�夋嫨涓�琛屾暟鎹叧闂紒' : '璇烽�夋嫨涓�琛屾暟鎹弽鍏抽棴锛�');
+ layer.msg('璇烽�夋嫨涓�琛屾暟鎹紒');
}
}
- //#endregion
- //#region 浣滃簾锛坣um=1锛�/鍙嶄綔搴燂紙num=2锛�
function set_DropBill(num) {
- var checkStatus = table.checkStatus('mainTable')
- , data = checkStatus.data;
- if (checkStatus.data.length === 1) {
- var HInterID = data[0].hmainid.toString();
- $.ajax({
- type: "GET",
- url: GetWEBURL() + "/Gy_SteppedPriceCoefficientBill/DropGy_SteppedPriceCoefficientBill",
- async: false,
- data: {
- "HInterID": HInterID,
- "IsAudit": IsClose, // 鏀� IsClose 涓� IsAudit
- "user": HMaker // 鏀� CurUserName 涓� user
- },
- success: function (result) {
- if (result.count == 1) {
- layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
- // 寰楀埌frame绱㈠紩
- var index = layer.getFrameIndex(window.name);
- //鍏抽棴褰撳墠frame
- layer.close(index);
- //淇敼涓哄姛鍚庡埛鏂扮晫闈�
- $("#btnSearch").trigger('click');
- });
-
- } else {
- layer.msg(result.Message, { icon: 2, btn: ['纭'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "娓╅Θ鎻愮ず" });
- }
- }, error: function () {
- layer.msg('閿欒' + err, { icon: 5, btn: ['纭'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "娓╅Θ鎻愮ず" });
- }
- });
- }
- else {
- if (num == 1) {
- layer.msg('璇烽�夋嫨涓�琛屾暟鎹綔搴燂紒');
- }
- else {
- layer.msg('璇烽�夋嫨涓�琛屾暟鎹弽浣滃簾锛�');
- }
- }
- }
- //#endregion
-
- //#region 閲嶇疆鎸夐挳
- form.on('submit(btnReSearch)', function (data) {
- //娓呯┖杩囨护鏉′欢
- set_ClearQuery();
- });
-
- //閲嶇疆杩囨护鏉′欢
- function set_ClearQuery() {
- // 閲嶇疆鍒跺崟鏃ユ湡鑼冨洿锛堟渶杩�30澶╋級
- var endDate = new Date();
- var startDate = new Date(endDate - 1000 * 60 * 60 * 24 * 30);
-
- $("#HMakeDate_Begin").val(Pub_Format(startDate, "yyyy-MM-dd"));
- $("#HMakeDate_End").val(Pub_Format(endDate, "yyyy-MM-dd"));
-
- $("#HBillNo").val("");//鍗曟嵁鍙�
- $("#ColContent").val("");
- $("#ColName").val("0");
- $("#Comparator").val("0");
- $("#ColContent2").val("");
- $("#ColName2").val("0");
- $("#Comparator2").val("0");
- $("#ColContent1").val("");
- $("#ColName1").val("0");
- $("#Comparator1").val("0");
- form.render('select');
- sWhere = "";
- }
-
- //#endregion
-
- //#region 鏌ヨ鎸夐挳
- form.on('submit(btnSearch)', function (data) {
- if (page != 1) {
- $("#page a:eq(1)").get(0).click();//鐐瑰嚮鍒嗛〉鏍忕涓�椤�
+ var checkStatus = table.checkStatus('mainTable'),
+ data = checkStatus.data;
+ if (data && data.length === 1) {
+ // 瀹炵幇浣滃簾閫昏緫
} else {
- get_FastQuery();
+ layer.msg('璇烽�夋嫨涓�琛屾暟鎹紒');
}
- });
-
- //蹇�熸煡璇�
- //蹇�熸煡璇�
- function get_FastQuery() {
- // 浣跨敤鍒跺崟鏃ユ湡浣滀负鍒涘缓鏃堕棿杩囨护
- var HMakeDate_Begin = $("#HMakeDate_Begin").val(); // 寮�濮嬪埗鍗曟棩鏈�
- var HMakeDate_End = $("#HMakeDate_End").val(); // 缁撴潫鍒跺崟鏃ユ湡
- var HBillNo = $("#HBillNo").val(); // 鍗曟嵁鍙�
-
- console.log("=== 鏌ヨ鍙傛暟 ===");
- console.log("HMakeDate_Begin:", HMakeDate_Begin);
- console.log("HMakeDate_End:", HMakeDate_End);
- console.log("HBillNo:", HBillNo);
-
- // 娓呯┖涔嬪墠鐨勬潯浠�
- sWhere = "";
-
- // 鏋勫缓鏉′欢鏁扮粍锛堥伩鍏嶅紑澶存湁"and"鐨勯棶棰橈級
- var conditions = [];
-
- // 鍒跺崟鏃ユ湡锛堝垱寤烘椂闂达級鑼冨洿鏌ヨ - 浣跨敤姝g‘鐨凷QL鏍煎紡
- if (HMakeDate_Begin && HMakeDate_Begin.trim() !== '') {
- conditions.push("CONVERT(date, HMakeDate) >= '" + HMakeDate_Begin + "'");
- }
- if (HMakeDate_End && HMakeDate_End.trim() !== '') {
- conditions.push("CONVERT(date, HMakeDate) <= '" + HMakeDate_End + "'");
- }
-
- // 鍗曟嵁鍙锋煡璇�
- if (HBillNo && HBillNo.trim() !== '') {
- conditions.push("HBillNo like '%" + HBillNo + "%'");
- }
-
- // 灏嗘潯浠剁粍鍚堟垚SQL璇彞
- if (conditions.length > 0) {
- sWhere = conditions.join(" and ");
- } else {
- sWhere = "1=1"; // 濡傛灉娌℃湁鏉′欢锛屼娇鐢�1=1纭繚璇硶姝g‘
- }
-
- console.log("鐢熸垚鐨勬煡璇㈡潯浠�:", sWhere);
-
- // 璋冪敤鏌ヨ鏂规硶
- get_DisplayPage(sWhere);
}
- //#endregion
- //#region 鍒嗛〉鏌ヨ
- function get_DisplayPage(sWhere) {
- console.log("=== 寮�濮嬫煡璇� ===");
- console.log("鏌ヨ鏉′欢:", sWhere);
- console.log("椤电爜:", page, "姣忛〉鏁伴噺:", size);
- console.log("褰撳墠鐢ㄦ埛:", sessionStorage["HUserName"]);
-
- var ajaxLoad = layer.load();
-
- // 娴嬭瘯涓嶅悓鐨凙PI绔偣
- var apiUrl = GetWEBURL() + '/Gy_SteppedPriceCoefficientBill/list';
- console.log("璋冪敤API:", apiUrl);
-
- $.ajax({
- url: apiUrl,
- type: "GET",
- data: {
- "sWhere": sWhere,
- "user": sessionStorage["HUserName"],
- "page": page,
- "size": size
- },
- dataType: "json",
- success: function (data1) {
- layer.close(ajaxLoad);
-
- console.log("=== 澶勭悊琛ㄦ牸鏁版嵁 ===");
- console.log("API杩斿洖鏁版嵁:", data1);
-
- if (data1.code == "1") {
- var tableData = data1.data || [];
- var totalCount = data1.total || tableData.length;
-
- console.log("琛ㄦ牸鏁版嵁閲�:", tableData.length);
-
- // 纭繚鏁版嵁鏄暟缁勬牸寮�
- if (!Array.isArray(tableData)) {
- tableData = [];
- console.warn("琛ㄦ牸鏁版嵁涓嶆槸鏁扮粍鏍煎紡锛屽凡杞崲涓虹┖鏁扮粍");
- }
-
- // 妫�鏌ユ槸鍚﹀凡缁忓垵濮嬪寲浜嗚〃鏍奸厤缃�
- if (!option.cols || !Array.isArray(option.cols)) {
- console.log("鍒濆鍖栬〃鏍煎垪閰嶇疆...");
-
- // 瀹氫箟鍒楅厤缃�
- option.cols = [[
- // 澶嶉�夋鍒�
- { type: 'checkbox', fixed: 'left', width: 50 },
-
- // 鍗曟嵁鍙凤紙閾炬帴鍒扮紪杈戯級
- {
- field: 'HBillNo',
- title: '鍗曟嵁鍙�',
- width: 180,
- fixed: 'left',
- event: '鍗曟嵁鍙�',
- style: 'cursor: pointer;',
- templet: function (d) {
- return '<span style="color: blue; cursor: pointer;">' + (d.HBillNo || '') + '</span>';
- }
- },
-
- // 鍗曟嵁鏃ユ湡
- {
- field: 'HDate',
- title: '鍗曟嵁鏃ユ湡',
- width: 150,
- templet: function (d) {
- if (!d.HDate) return '';
- try {
- var date = new Date(d.HDate);
- return layui.util.toDateString(date, 'yyyy-MM-dd');
- } catch (e) {
- return d.HDate;
- }
- }
- },
-
- // 骞村害
- { field: 'HYear', title: '骞�', width: 80, align: 'center' },
-
- // 鏈熼棿
- { field: 'HPeriod', title: '鏈�', width: 80, align: 'center' },
-
- // 鍗曟嵁鐘舵��
- // 鍗曟嵁鐘舵�佹樉绀猴紙鏍规嵁鎮ㄦ彁渚涚殑鐘舵�佸畾涔夛級
- {
- field: 'HBillStatus',
- title: '鐘舵��',
- width: 100,
- align: 'center',
- templet: function (d) {
- var status = d.HBillStatus;
- switch (status.toString()) {
- case '1':
- return '<span>鏈鏍�</span>';
- case '2':
- return '<span>宸插鏍�</span>';
- case '3':
- return '<span>宸插叧闂�</span>';
- case '4':
- return '<span>宸蹭綔搴�</span>';
- case '5':
- return '<span>瀹℃牳閫�鍥�</span>';
- case '6':
- return '<span>瀹℃牳涓�</span>';
- default:
- return '<span >鐘舵��' + status + '</span>';
- }
- }
- },
-
- // 瀛愯〃缁熻淇℃伅
- {
- field: 'SubCount',
- title: '搴忓彿鍚堣',
- width: 90,
- align: 'center',
- totalRow: true
- },
-
- {
- field: 'TotalMinQty',
- title: '鏈�灏忔暟閲忓悎璁�',
- width: 120,
- align: 'right',
- totalRow: true
- },
-
- {
- field: 'TotalMaxQty',
- title: '鏈�澶ф暟閲忓悎璁�',
- width: 120,
- align: 'right',
- totalRow: true
- },
-
- {
- field: 'TotalCoefficient',
- title: '宸ヤ环绯绘暟鍚堣',
- width: 100,
- align: 'right',
- totalRow: true
- },
-
- {
- field: 'TotalMaxPrice',
- title: '鏈�澶у伐浠峰悎璁�',
- width: 120,
- align: 'right',
- totalRow: true
- },
-
- // 澶囨敞
- { field: 'HRemark', title: '澶囨敞', width: 200 },
-
- // 鍒跺崟浜�
- { field: 'HMaker', title: '鍒跺崟浜�', width: 100 },
-
- // 鍒跺崟鏃ユ湡
- {
- field: 'HMakeDate',
- title: '鍒跺崟鏃ユ湡',
- width: 160,
- templet: function (d) {
- if (!d.HMakeDate) return '';
- try {
- var date = new Date(d.HMakeDate);
- return layui.util.toDateString(date, 'yyyy-MM-dd HH:mm:ss');
- } catch (e) {
- return d.HMakeDate;
- }
- }
- },
-
- // 瀹℃牳浜�
- { field: 'HChecker', title: '瀹℃牳浜�', width: 100 },
-
- // 瀹℃牳鏃ユ湡
- {
- field: 'HCheckDate',
- title: '瀹℃牳鏃ユ湡',
- width: 160,
- templet: function (d) {
- if (!d.HCheckDate) return '';
- try {
- var date = new Date(d.HCheckDate);
- return layui.util.toDateString(date, 'yyyy-MM-dd HH:mm:ss');
- } catch (e) {
- return d.HCheckDate;
- }
- }
- },
-
- // 闅愯棌瀛楁
- { field: 'HInterID', title: '鍐呯爜', width: 100, hide: true },
- { field: 'RowNum', title: '琛屽彿', width: 80, hide: true },
- { field: 'HUpDater', title: '鏇存柊浜�', width: 100, hide: true },
- { field: 'HUpDateDate', title: '鏇存柊鏃ユ湡', width: 160, hide: true },
- { field: 'HCloseMan', title: '鍏抽棴浜�', width: 100, hide: true },
- { field: 'HCloseDate', title: '鍏抽棴鏃ユ湡', width: 160, hide: true },
- { field: 'HProcID', title: '宸ュ簭ID', width: 100, hide: true },
- { field: 'HEmpID', title: '鍛樺伐ID', width: 100, hide: true },
- { field: 'HDeptID', title: '閮ㄩ棬ID', width: 100, hide: true },
- { field: 'HStockOrgID', title: '缁勭粐ID', width: 100, hide: true }
- ]];
- }
-
- // 璁剧疆鍏朵粬蹇呰鐨勮〃鏍奸厤缃�
- option.data = tableData;
- option.limit = size;
-
- console.log("琛ㄦ牸閰嶇疆:", option);
-
- try {
- // 濡傛灉琛ㄦ牸宸茬粡娓叉煋杩囷紝鍒欓噸杞芥暟鎹�
- if (window.tableIns) {
- window.tableIns.reload({
- data: tableData,
- limit: size
- });
- console.log("琛ㄦ牸鏁版嵁閲嶈浇瀹屾垚");
- } else {
- // 棣栨娓叉煋琛ㄦ牸
- window.tableIns = table.render(option);
- console.log("琛ㄦ牸棣栨娓叉煋瀹屾垚");
- }
- } catch (error) {
- console.error("琛ㄦ牸娓叉煋閿欒:", error);
- layer.msg("琛ㄦ牸娓叉煋澶辫触: " + error.message, { icon: 5 });
- }
-
- // 鏇存柊鍒嗛〉淇℃伅
- try {
- laypage.render({
- elem: 'page',
- count: totalCount,
- limit: size,
- curr: page,
- limits: [50, 500, 5000, 50000],
- layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
- jump: function (obj, first) {
- if (!first) {
- page = obj.curr;
- size = obj.limit;
- get_FastQuery();
- }
- }
- });
- console.log("鍒嗛〉娓叉煋瀹屾垚锛屾�昏褰曟暟:", totalCount);
- } catch (error) {
- console.error("鍒嗛〉娓叉煋閿欒:", error);
- }
-
- // 鍒锋柊鍒楄繃婊や笅鎷夋
- setTimeout(function () {
- try {
- ColFilter();
- } catch (error) {
- console.error("鍒楄繃婊ゅ埛鏂伴敊璇�:", error);
- }
- }, 100);
-
- } else {
- layer.msg(data1.message || "鏌ヨ澶辫触", { icon: 5 });
- console.error("鏌ヨ澶辫触:", data1);
- }
- },
- error: function (xhr, status, error) {
- layer.close(ajaxLoad);
- layer.msg("鏌ヨ澶辫触: " + error, { icon: 5 });
- console.error("AJAX璇锋眰澶辫触:", error);
- }
- });
- }
- //#endregion
-
- //#region 鍒楁槑鏄剧ず涓嬫媺妗�
- function ColFilter() {
- var Organization = '<option value="0" selected="selected" ></option>';
- for (var i = 1; i < option.cols[0].length; i++) {
- if (option.cols[0][i].hide != true) {
- Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].title + '</option>';
- }
- }
- $("#ColName").empty();
- $("#ColName").append(Organization);
- $("#ColName1").empty();
- $("#ColName1").append(Organization);
- $("#ColName2").empty();
- $("#ColName2").append(Organization);
- form.render('select');
- }
- //#endregion
-
- //#region 鍒楄缃�
- function get_HideColumn() {
- var colName = "";
- var contentUrl = "";
- for (var i = 1; i < option.cols[0].length; i++) {
- colName += option.cols[0][i]["field"] + ",";
- }
- var urlStr = window.document.location.pathname;//鑾峰彇鏂囦欢璺緞
- var urlLen = urlStr.split('/');
- for (var i = 0; i < urlLen.length - 4; i++) {
- contentUrl += "../";
- }
- colName = encodeURI(colName.substring(0, colName.length - 1));//瀵� URI 杩涜缂栫爜
-
- contentUrl += '鍩虹璧勬枡/闅愯棌鍒楄缃�/Gy_GridView_Hide_New.html?HModName=' + HModName + '&colName=' + colName;
-
- layer.open({
- type: 2
- , skin: "layui-layer-rim" //鍔犱笂杈规
- , title: "闅愯棌鍒楄缃�" //鏍囬
- , closeBtn: 1 //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡
- , shift: 2 //寮瑰嚭鍔ㄧ敾
- , area: ["50%", "90%"] //绐椾綋澶у皬
- , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀�
- , content: [contentUrl, "yes"]
- , btn: ["纭畾", "鍙栨秷"]
- , btn1: function (index, laero) {
- //鍒锋柊琛ㄦ牸鏁版嵁
- DisPlay_HideColumn();
- //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹�
- layer.close(index);//鍏抽棴寮圭獥
- }
- })
+ function get_PrintReport() {
+ layer.msg("鎵撳嵃鍔熻兘寰呭疄鐜�", { icon: 1 });
}
//#endregion
- //#region 銆愯繃婊ゆ柟妗堛��
-
- //鑾峰彇褰撳墠鐢ㄦ埛鐨勯粯璁よ繃婊ゆ柟妗�
- function get_DefaultModule() {
- $.ajax({
- url: GetWEBURL() + '/Xt_FastICScheme/Chooselist',
- type: "GET",
- data: { "user": sessionStorage["Czybm"], "HModuleName": HModuleName, "HInterID": 0, "Type": "Default" },
- success: function (data1) {
- if (data1.count == 1) {
- //褰撳墠鐢ㄦ埛璁剧疆鏈夐粯璁ょ殑杩囨护鏂规
- var data = data1.data;
- //褰撳墠閫夋嫨鐨勮繃婊ゆ柟妗�
- HInterID_Choose = data[0].hmainid;
- //杩囨护鏂规鍐呯爜
- HInterID = data[0].hmainid
- //杩囨护鏂规鍚嶇О
- HDefaultFilter = data[0].鏂规鍚嶇О
- //杩囨护鏂规鐨勫娉紙鏂规淇℃伅鎻忚堪锛�
- var HRemark = data[0].澶囨敞
- //鏄剧ず鍑哄綋鍓嶇殑榛樿杩囨护鏂规
- document.getElementById("HFilterScheme_Now").style.display = "block";
- document.getElementById('HFilterScheme_Now').innerHTML = "褰撳墠杩囨护鏂规锛�" + HDefaultFilter + '<span style="font-size: 15px; font-weight: bold; color:#7b90fb"> ' + "(" + HRemark + ")" + '</span>';
- //鎶婅繃婊ゆ潯浠跺�煎洖鍐欏埌椤甸潰涓�
- for (let i = 0; i < data.length; i++) {
- $("#" + data[i].杩囨护瀛楁ID).val(data[i].杩囨护鍊�);
- if (data[i].杩囨护鏍囩绫诲瀷 == 'SELECT') {
- $("#" + data[i].杩囨护瀛楁ID).find("option[value='" + data[i].杩囨护鍊� + "']").attr("selected", true);
- }
- }
- //鎵ц鏌ヨ鏂规硶
- get_FastQuery()
- form.render("select");
- } else {
- //褰撳墠鐢ㄦ埛娌℃湁璁剧疆榛樿鐨勮繃婊ゆ柟妗�
- //闅愯棌鏄剧ず杩囨护鏂规鐨勬爣绛句俊鎭�
- document.getElementById("HFilterScheme_Now").style.display = "none";
- //鎵ц鏌ヨ鏂规硶
- get_FastQuery()
- form.render("select");
- }
- }, error: function () {
- layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
- }
- });
- }
-
- //淇濆瓨鏂规
- function set_SaveScheme() {
- var index = layer.open()
- //鍒ゆ柇鐢ㄦ埛鏄惁鐐瑰嚮浜嗗彸涓婅鐨�"鍙夊彿"鍏抽棴寮圭獥椤甸潰
- var HIsClose_Manual = false;
- //鑾峰彇鏈〉鎵�鏈夎繃婊ゆ潯浠跺璞�(class涓寘鍚�"ForFilteringSchemes"鐨勫厓绱�)
- var Filter = document.getElementsByClassName(HClassTag);
-
- var HFilterIdList = "";//杩囨护鏉′欢
- var HFilterIdLists = "";//鎷兼帴澶氫釜杩囨护鏉′欢
- var HValue = "";//杩囨护鍊�
- var HElement_type = "";//杩囨护鏍囩绫诲瀷
-
- for (var i = 0; i < Filter.length; i++) {
- HFilterIdList = Filter[i].id; //杩囨护鏉′欢ID
- HFilterIdLists += Filter[i].id + ","; //杩囨护鏉′欢ID(鎷兼帴)
- HValue += $("#" + HFilterIdList).val() + ","; //杩囨护鏉′欢涓緭鍏ョ殑鍊�
- HElement_type += document.getElementById(HFilterIdList).tagName + ",";//閫氳繃鏍囩id鑾峰彇鏍囩绫诲瀷
- }
-
- //鍘婚櫎鏈熬閫楀彿
- HFilterIdLists = HFilterIdLists.substring(0, HFilterIdLists.length - 1);
- HValue = HValue.substring(0, HValue.length - 1);
- HElement_type = HElement_type.substring(0, HElement_type.length - 1);
-
- //褰撳墠椤甸潰涓婃病鏈夐�夋嫨杩囨护鏂规锛岃繘鍏ユ柊澧炴柟娉�
- if (HDefaultFilter == "") {
- layer.open({
- type: 2
- , area: ['40%', '80%']
- , title: '杩囨护鏂规'
- , shift: 0//寮瑰嚭鍔ㄧ敾
- , content: '../../绯荤粺绠$悊/杩囨护鏂规璁剧疆/Xt_FastICScheme.html?OperationType=1&HModuleName=' + HModuleName + '&HFilterIdLists=' + HFilterIdLists + '&HValue=' + HValue + '&HElement_type=' + HElement_type
- , cancel: function () {
- // 鍙充笂瑙掑叧闂簨浠剁殑閫昏緫
- HIsClose_Manual = true;
- }
- , end: function () {
- if (HIsClose_Manual != true) {
- get_FastQuery();
- //鏄剧ず褰撳墠鐨勮繃婊ゆ柟妗�
- document.getElementById("HFilterScheme_Now").style.display = "block";
- document.getElementById('HFilterScheme_Now').innerHTML = "褰撳墠杩囨护鏂规锛�" + sessionStorage["HFilterSchemeName_" + sessionStorage["Czybm"]] + '<span style="font-size: 15px; font-weight: bold; color:#7b90fb"> ' + "(" + sessionStorage["HFilterSchemeRemark_" + sessionStorage["Czybm"]] + ")" + '</span>';
- }
- }
- })
- layer.close(index)
- } else {
- //褰撳墠椤甸潰宸叉湁杩囨护鏂规锛岀敤鎴烽�夋嫨 鏂板鎴栬�呯紪杈�
- layer.confirm('褰撳墠宸查�夋嫨杩囨护鏂规锛屾槸鍚︿慨鏀癸紵璇烽�夋嫨瀵瑰簲鎿嶄綔', {
- title: "鎿嶄綔鎻愮ず",
- icon: 0,
- btn: ['鏂板鏂规', '淇濆瓨淇敼褰撳墠鏂规', '鍙栨秷']
- }, function (index, layero) {
- //鏂板
- layer.open({
- type: 2
- , area: ['40%', '80%']
- , title: '杩囨护鏂规'
- , shift: 0//寮瑰嚭鍔ㄧ敾
- , content: '../../绯荤粺绠$悊/杩囨护鏂规璁剧疆/Xt_FastICScheme.html?OperationType=1&HModuleName=' + HModuleName + '&HFilterIdLists=' + HFilterIdLists + '&HValue=' + HValue + '&HElement_type=' + HElement_type
- , end: function () {
- get_FastQuery()
- //鏄剧ず褰撳墠鐨勮繃婊ゆ柟妗�
- document.getElementById("HFilterScheme_Now").style.display = "block";
- document.getElementById('HFilterScheme_Now').innerHTML = "褰撳墠杩囨护鏂规锛�" + sessionStorage["HFilterSchemeName_" + sessionStorage["Czybm"]] + '<span style="font-size: 15px; font-weight: bold; color:#7b90fb"> ' + "(" + sessionStorage["HFilterSchemeRemark_" + sessionStorage["Czybm"]] + ")" + '</span>';
- }
- })
- layer.close(index)
- }, function (index) {
- //缂栬緫
- var Filter_Edit = document.getElementsByClassName(HClassTag); //鑾峰彇鏈〉鎵�鏈夎繃婊ゆ潯浠跺璞�(class涓寘鍚�"ForFilteringSchemes"鐨勫厓绱�)
- HFilterIdList = "";
- HFilterIdLists = "";
- HValue = "";
- HElement_type = "";
- for (var i = 0; i < Filter_Edit.length; i++) {
- HFilterIdList = Filter_Edit[i].id; //杩囨护鏉′欢ID
- HFilterIdLists += Filter_Edit[i].id + ","; //杩囨护鏉′欢ID(鎷兼帴)
- HValue += $("#" + HFilterIdList).val() + ","; //杩囨护鏉′欢涓緭鍏ョ殑鍊�
- HElement_type += document.getElementById(HFilterIdList).tagName + ",";//閫氳繃鏍囩id鑾峰彇鏍囩绫诲瀷
- }
- //鍘婚櫎鏈熬閫楀彿
- HFilterIdLists = HFilterIdLists.substring(0, HFilterIdLists.length - 1);
- HValue = HValue.substring(0, HValue.length - 1);
- HElement_type = HElement_type.substring(0, HElement_type.length - 1);
-
- var sMainSub = HInterID_Choose + ';' + HFilterIdLists + ';' + HValue + ';' + HElement_type + ';' + sessionStorage["Czybm"] + ';' + 3;
-
- //淇敼
- $.ajax({
- type: "POST",
- url: GetWEBURL() + "/Xt_FastICScheme/save", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚�
- async: true,
- data: { "oMain": sMainSub },
- dataType: "json",
- success: function (data) {
- if (data.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
- layer.msg(data.Message, { time: 1 * 1000, icon: 1 });
- }
- else {
-
- }
- layer.closeAll("loading");
- },
- error: function (err) {
-
-
- }
- });
- layer.close(index)
- }, function (index) {
- //鍙栨秷
- layer.alert('鍙栨秷')
- layer.close(index)
- });
- }
-
- }
-
- //璇诲彇鏂规
- function set_ReadScheme() {
- var HIsClose_Manual = false;
- var Filter = document.getElementsByClassName(HClassTag); //鑾峰彇鏈〉鎵�鏈夎繃婊ゆ潯浠跺璞�(class涓寘鍚�"ForFilteringSchemes"鐨勫厓绱�)
-
- var HFilterIdList = "";
- var HFilterIdLists = "";
- var HValue = "";
- var HElement_type = "";
- for (var i = 0; i < Filter.length; i++) {
- HFilterIdList = Filter[i].id; //杩囨护鏉′欢ID
- HFilterIdLists += Filter[i].id + ","; //杩囨护鏉′欢ID(鎷兼帴)
- HValue += $("#" + HFilterIdList).val() + ","; //杩囨护鏉′欢涓緭鍏ョ殑鍊�
- HElement_type += document.getElementById(HFilterIdList).tagName + ",";//閫氳繃鏍囩id鑾峰彇鏍囩绫诲瀷
- }
- //鍘婚櫎鏈熬閫楀彿
- HFilterIdLists = HFilterIdLists.substring(0, HFilterIdLists.length - 1);
- HValue = HValue.substring(0, HValue.length - 1);
- HElement_type = HElement_type.substring(0, HElement_type.length - 1);
-
- layer.open({
- type: 2
- , area: ['80%', '80%']
- , title: '杩囨护鏂规鍒楄〃'
- , shift: 0//寮瑰嚭鍔ㄧ敾
- , content: '../../绯荤粺绠$悊/杩囨护鏂规璁剧疆/Xt_FastICSchemeList.html?HType=Select&HFilterIdLists=' + HFilterIdLists + '&HValue=' + HValue + '&HElement_type=' + HElement_type + '&HModuleName=' + HModuleName
- , cancel: function () {
- // 鍙充笂瑙掑叧闂簨浠剁殑閫昏緫
- HIsClose_Manual = true;
- }
- , end: function () {
- if (HIsClose_Manual != true) {
- get_FastQuery()
- form.render("select");
- }
- }
- })
- }
-
- //#endregion
-
- //#endregion
//浠ヤ笂鏄痩ayui妯″潡
});
- //#region 銆愯繃婊ゆ柟妗堣繑鍥炴暟鎹��
- function HFilterScheme(obj) //杩斿洖杩囨护鏂规
- {
- var HInterID = obj[0].hmainid;
- HInterID_Choose = obj[0].hmainid;
- $.ajax({
- url: GetWEBURL() + '/Xt_FastICScheme/Chooselist',
- type: "GET",
- data: { "user": sessionStorage["Czybm"], "HModuleName": HModuleName, "HInterID": HInterID, "Type": "Select" },
- success: function (data1) {
- if (data1.count == 1) {
- var data = data1.data;
- //璧嬪�艰繃婊ゆ柟妗堝悕绉�
- HDefaultFilter = data[0].鏂规鍚嶇О
- var HRemark = data[0].澶囨敞
- //鏄剧ず褰撳墠鐨勮繃婊ゆ柟妗�
- document.getElementById("HFilterScheme_Now").style.display = "block";
- document.getElementById('HFilterScheme_Now').innerHTML = "褰撳墠杩囨护鏂规锛�" + HDefaultFilter + '<span style="font-size: 15px; font-weight: bold; color:#7b90fb"> ' + "(" + HRemark + ")" + '</span>';
- HInterID = data[0].hmainid
- //鏍规嵁閫夋嫨鐨勮繃婊ゆ柟妗堝洖濉暟鎹埌鍒楄〃杩囨护鏉′欢
- for (let i = 0; i < data.length; i++) {
- $("#" + data[i].杩囨护瀛楁ID).val(data[i].杩囨护鍊�);
- if (data[i].杩囨护鏍囩绫诲瀷 == 'SELECT') {
- $("#" + data[i].杩囨护瀛楁ID).find("option[value='" + data[i].杩囨护鍊� + "']").attr("selected", true);
- }
- }
-
- } else {
- layer.close(ajaxLoad);
- layer.alert(data1.code + data1.Message, { icon: 5 });
- }
- }, error: function () {
- layer.close(ajaxLoad);
- layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
- }
- });
- }
- //#endregion
</script>
</body>
-</html>
\ No newline at end of file
+</html>
\ No newline at end of file
--
Gitblit v1.9.1