From 81c6759dcee2dad7b63efdc87f660d4550d1572d Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期四, 30 十月 2025 09:49:58 +0800
Subject: [PATCH] excel导入送货物料信息
---
WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialBarCodeBill.html | 232 ++++++++++++++++++++++-----------------------------------
1 files changed, 90 insertions(+), 142 deletions(-)
diff --git a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialBarCodeBill.html b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialBarCodeBill.html
index 9736ad5..c2f00a5 100644
--- a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialBarCodeBill.html
+++ b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialBarCodeBill.html
@@ -166,7 +166,7 @@
, element = layui.element; //Tab鐨勫垏鎹㈠姛鑳斤紝鍒囨崲浜嬩欢鐩戝惉绛夛紝闇�瑕佷緷璧杄lement妯″潡
var option;
- FetchSupInfo();
+ //FetchSupInfo();
option = {
elem: '#mainTable'
, toolbar: '#toolbarDemo'
@@ -181,9 +181,10 @@
, { field: 'HMaterNumber', title: '鐗╂枡缂栫爜', width: 120 }
/* , { field: 'HOldMaterNumber', title: '鏃х墿鏂欑紪鐮�', width: 120, hide: true }*/
, { field: 'HMaterShortNumber', title: '鐗╂枡浠ｇ爜', width: 120, hide: true }
- , { field: 'HSubjoin', title: '鐗╂枡绠�绉�', width: 120, }
+ , { field: 'HSubjoin', title: '鐗╂枡绠�绉�', width: 120, }
, { field: 'HMaterName', title: '鐗╂枡鍚嶇О', width: 120 }
, { field: 'HMaterModel', title: '瑙勬牸鍨嬪彿', width: 120 }
+ , { field: 'HStatusMan', title: '宸ュ彿', width: 120, edit: 'text' }
, { field: 'HQty', title: '鏈鐢熸垚鏉＄爜鏁伴噺', width: 135, edit: 'text', event: "inputHQty" }
, { field: 'HMinQty', title: '鏍囧噯鍖呰鏁帮紙鍐呯瑁呯鏁帮級', width: 100, event: "inputHMinQty" }
, { field: 'HBQty', title: '鏈�灏忓寘瑁呮暟锛堝唴绠辨暟锛�', width: 100 }
@@ -192,8 +193,9 @@
, { field: 'HBatchManager', title: '鍚敤鎵瑰彿', width: 100, hide: true }
, { field: 'HISKFPERIOD', title: '鏄惁鍚敤淇濊川鏈�', width: 100, edit: 'text', hide: true }
, { field: 'HEXPUNIT', title: '淇濊川鏈熷崟浣�', width: 100, edit: 'text', hide: true }
- , { field: 'HSourceBillType', title: '鏉＄爜绫诲瀷', width: 100, templet: '#barCodeTypeTpl' }
- , { field: 'HKFDate', title: '鐢熶骇鏃ユ湡', align: 'center', width: 150, data_field: 'HKFDate', event: "chooseHKFDate" }//, event: "chooseHKFDate"
+ , { field: 'HSourceBillType', title: '鏉＄爜绫诲瀷', width: 100, templet: '#barCodeTypeTpl', hide: true }
+ , { field: 'HKFDate', title: '鐢熶骇鏃ユ湡', align: 'center', width: 150, data_field: 'HKFDate', event: "chooseHKFDate", hide: true }//, event: "chooseHKFDate"
+ , { field: 'HBarCodeDate', title: '鏉＄爜鏃ユ湡', align: 'center', width: 150, data_field: 'HBarCodeDate', event: "chooseHBarCodeDate" }
, { field: 'HKFPeriod', title: '淇濊川鏈�', width: 100, event: "inputHKFPeriod", hide: true }//
, { field: 'HKFDQDate', title: '鍒版湡鏃ユ湡', align: 'center', width: 150, data_field: 'HKFDQDate', hide: true }//, event: "chooseHKFDQDate"
, { field: 'HSupID', title: '渚涘簲鍟咺D', width: 150, hide: true }
@@ -235,6 +237,7 @@
, { field: 'HSubjoin', title: '鐗╂枡浠ｇ爜', width: 120, hide: true }
, { field: 'HMaterName', title: '鐗╂枡鍚嶇О', width: 120 }
, { field: 'HMaterModel', title: '瑙勬牸鍨嬪彿', width: 120 }
+ , { field: 'HStatusMan', title: '宸ュ彿', width: 120, edit: 'text'}
, { field: 'HQty', title: '鏈鐢熸垚鏉＄爜鏁伴噺', width: 135, edit: 'text', event: "inputHQty" }
, { field: 'HMinQty', title: '鏍囧噯鍖呰鏁帮紙鍐呯瑁呯鏁帮級', width: 100, event: "inputHMinQty" }
, { field: 'HBQty', title: '鏈�灏忓寘瑁呮暟锛堝唴绠辨暟锛�', width: 100 }
@@ -243,7 +246,8 @@
, { field: 'HBatchManager', title: '鍚敤鎵瑰彿', width: 100, hide: true }
, { field: 'HISKFPERIOD', title: '鏄惁鍚敤淇濊川鏈�', width: 100, edit: 'text', hide: true }
, { field: 'HEXPUNIT', title: '淇濊川鏈熷崟浣�', width: 100, edit: 'text', hide: true }
- , { field: 'HSourceBillType', title: '鏉＄爜绫诲瀷', width: 100 }
+ , { field: 'HBarCodeDate', title: '鏉＄爜鏃ユ湡', align: 'center', width: 150, data_field: 'HBarCodeDate', event: "chooseHBarCodeDate" }
+ , { field: 'HSourceBillType', title: '鏉＄爜绫诲瀷', width: 100, hide: true }
, { field: 'HKFDate', title: '鐢熶骇鏃ユ湡', align: 'center', width: 150, data_field: 'HKFDate', event: "chooseHKFDate", hide: true }//, event: "chooseHKFDate"
, { field: 'HKFPeriod', title: '淇濊川鏈�', width: 100, hide: true }//
, { field: 'HKFDQDate', title: '鍒版湡鏃ユ湡', align: 'center', width: 150, data_field: 'HKFDQDate', hide: true}//, event: "chooseHKFDQDate"
@@ -271,6 +275,10 @@
var data = data.data;
var rowdata = [];
+ $("#HSupID").val(data[0].HSupID);
+ $("#HSupNumber").val(data[0].渚涘簲鍟嗕唬鐮�);
+ $("#HSupName").val(data[0].渚涘簲鍟嗗悕绉�);
+
for (var i = 0; i < data.length; i++) {
rowdata.push({
"HMaterID": data[i].MaterID,
@@ -293,7 +301,8 @@
"HSupID": data[i].HSupID,
"HSupName": data[i].渚涘簲鍟嗗悕绉�,
"HEXPUNIT": data[i].淇濊川鏈熷崟浣�,
- "HQty": 1, // 榛樿鐢熸垚鏉＄爜鏁伴噺
+ "HQty": 0, // 榛樿鐢熸垚鏉＄爜鏁伴噺
+ "HBarCodeDate": data[i].鏉＄爜鏃ユ湡,
"biaoqianzhangshu": 1 // 鏍囩寮犳暟
});
}
@@ -392,6 +401,18 @@
data[field] = value;
obj.update(data);
+ }
+ });
+ }
+ else if (obj.event == 'chooseHBarCodeDate') {
+ var field = $(this).data('field');
+ laydate.render({
+ elem: this.firstChild
+ , show: true //鐩存帴鏄剧ず
+ , closeStop: this
+ , done: function (value, date) {
+ data[field] = value;
+ obj.update(data);
}
});
}
@@ -522,7 +543,7 @@
var sMainStr = JSON.stringify(data.field);
var sSubStr = JSON.stringify(table.cache['mainTable']);
- var sMainSub = sMainStr + ';' + sSubStr;
+ var sMainSub = sMainStr + ';' + sSubStr + ';' + sessionStorage["HUserName"] + ';' + sessionStorage["OrganizationID"];
var _sSubStr = JSON.parse(sSubStr);
for (var i = 0; i < _sSubStr.length; i++) {
if (_sSubStr[i].HQty > 0 && (_sSubStr[i].HMinQty == 0 || _sSubStr[i].HWXQty == 0)) {
@@ -535,6 +556,12 @@
// layer.msg("鏄庣粏璁板綍绗�" + (i + 1) + "琛�,鏈鐢熸垚鏉＄爜鏁伴噺涓嶈兘瓒呭嚭鏈敓鎴愭潯鐮佹暟閲�!", { icon: 5, btn: ['纭'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "娓╅Θ鎻愮ず" });
// return Result = false;
//}
+
+ if (_sSubStr[i].HQty == 0) {
+ layer.msg("鏄庣粏璁板綍绗�" + (i + 1) + "琛�,鐢熸垚鏉＄爜鏁伴噺涓嶈兘涓�0!", { icon: 5, btn: ['纭'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "娓╅Θ鎻愮ず" });
+ return Result = false;
+ }
+
if (_sSubStr[i].HQty > 0 && _sSubStr[i].HISKFPERIOD == 1 && (/*_sSubStr[i].HBatchNo == "" ||*/ _sSubStr[i].HKFDate == "")) {
layer.msg("鏄庣粏璁板綍绗�" + (i + 1) + "琛�,鐢熶骇鏃ユ湡涓嶈兘涓虹┖!", { icon: 5, btn: ['纭'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "娓╅Θ鎻愮ず" });
return Result = false;
@@ -594,28 +621,31 @@
, defaultToolbar: ['filter', 'exports']
, limit: 500
, cols: [[
- { field: 'HBarCode', title: '鏉＄爜', width: 230, ellipsis: true }
+ { field: 'HLSH', title: '娴佹按鍙�', align: 'center', width: 150, data_field: 'HBarCodeDate' }
+ , { field: 'HBarCode', title: '鏉＄爜', width: 230, ellipsis: true }
, { field: 'HMaterID', title: '鐗╂枡ID', width: 100, hide: true }
, { field: 'HBarItemID', title: '鏉＄爜ID', width: 100, hide: true }
, { field: 'HMaterNumber', title: '鐗╂枡缂栫爜', width: 120 }
-/* , { field: 'LSH', title: '娴佹按鍙�', width: 120 }*/
+ /* , { field: 'LSH', title: '娴佹按鍙�', width: 120 }*/
/* , { field: 'HOldMaterNumber', title: '鏃х墿鏂欑紪鐮�', width: 120, hide: true }*/
- , { field: 'HMaterShortNumber', title: '鐗╂枡浠ｇ爜', width: 120 }
- , { field: 'HSubjoin', title: '鐗╂枡绠�绉�', width: 120, hide: true }
+ , { field: 'HMaterShortNumber', title: '鐗╂枡浠ｇ爜', width: 120, hide: true }
+ , { field: 'HSubjoin', title: '鐗╂枡绠�绉�', width: 120 }
, { field: 'HMaterName', title: '鐗╂枡鍚嶇О', width: 120, hide: true }
, { field: 'HMaterModel', title: '瑙勬牸鍨嬪彿', width: 120 }
+ , { field: 'HStatusMan', title: '宸ュ彿', width: 120 }
, { field: 'HQty', title: '鏈鐢熸垚鏉＄爜鏁伴噺', width: 135 }
, { field: 'HMinQty', title: '鏍囧噯鍖呰鏁帮紙鍐呯瑁呯鏁帮級', width: 100 }
, { field: 'HBQty', title: '鏈�灏忓寘瑁呮暟锛堝唴绠辨暟锛�', width: 100 }
, { field: 'biaoqianzhangshu', title: '鏍囩寮犳暟', width: 100 }
- , { field: 'HBatchNo', title: '鎵瑰彿', width: 100 }
+ , { field: 'HBarCodeDate', title: '鏉＄爜鏃ユ湡', align: 'center', width: 150, data_field: 'HBarCodeDate' }
+ , { field: 'HBatchNo', title: '鎵瑰彿', width: 100, hide: true }
, { field: 'HBatchManager', title: '鍚敤鎵瑰彿', width: 100, hide: true }
, { field: 'HISKFPERIOD', title: '鏄惁鍚敤淇濊川鏈�', width: 100, hide: true }
, { field: 'HEXPUNIT', title: '淇濊川鏈熷崟浣�', width: 100, hide: true }
- , { field: 'HSourceBillType', title: '鏉＄爜绫诲瀷', width: 100 }
- , { field: 'HKFDate', title: '鐢熶骇鏃ユ湡', align: 'center', width: 150 }//, event: "chooseHKFDate"
- , { field: 'HKFPeriod', title: '淇濊川鏈�', width: 100 }//
- , { field: 'HKFDQDate', title: '鍒版湡鏃ユ湡', align: 'center', width: 150 }//, event: "chooseHKFDQDate"
+ , { field: 'HSourceBillType', title: '鏉＄爜绫诲瀷', width: 100, hide: true }
+ , { field: 'HKFDate', title: '鐢熶骇鏃ユ湡', align: 'center', width: 150, hide: true }//, event: "chooseHKFDate"
+ , { field: 'HKFPeriod', title: '淇濊川鏈�', width: 100, hide: true }//
+ , { field: 'HKFDQDate', title: '鍒版湡鏃ユ湡', align: 'center', width: 150, hide: true }//, event: "chooseHKFDQDate"
, { field: 'HSupID', title: '渚涘簲鍟咺D', width: 150, hide: true }
, { field: 'HSupName', title: '渚涘簲鍟嗗悕绉�', width: 150, hide: true }
@@ -637,35 +667,38 @@
var rowdata_1 = [];
for (var i = 0; i < data.length; i++) {
-
- rowdata_1.push({
- "HMaterID": data[i].HMaterID,
- "HBarItemID": data[i].HBarItemID,
-/* "LSH": data[i].HBarItemID,*/
- "HBarCode": data[i].HBarCode,
- "HMaterNumber": data[i].鐗╂枡浠ｇ爜,
- "HMaterShortNumber": "",
- "HSubjoin": data[i].鐗╂枡绠�绉�,
- "HMaterName": data[i].鐗╂枡鍚嶇О,
- "HMaterModel": data[i].瑙勬牸鍨嬪彿,
- "HMinQty": data[i].鏍囧噯鍖呰鏁�,
- "HBQty": data[i].鏈�灏忓寘瑁呮暟,
- "HSourceBillType": data[i].鏉＄爜绫诲瀷,
- "HBatchNo": data[i].鎵瑰彿,
- "HISKFPERIOD": data[i].鏄惁鍚敤淇濊川鏈� == null ? 0 : data[i].鏄惁鍚敤淇濊川鏈�,
- "HKFPeriod": data[i].淇濊川鏈� == null ? 0 : data[i].淇濊川鏈�,
- "HKFDQDate": data[i].鏈夋晥鏈�,
- "HKFDate": data[i].鐢熶骇鏃ユ湡,
- "HBatchManager": data[i].鏄惁鍚敤鎵瑰彿,
- "HSupID": data[i].HSupID,
- "HSupName": data[i].渚涘簲鍟嗗悕绉�,
- "HEXPUNIT": data[i].淇濊川鏈熷崟浣�,
- "HQty":data[i].鐢熸垚鏉＄爜鏁伴噺 , // 鏈鐢熸垚鏉＄爜鏁伴噺
- "biaoqianzhangshu": 1
- });
-
-
-
+
+ rowdata_1.push({
+ "HMaterID": data[i].HMaterID,
+ "HBarItemID": data[i].HBarItemID,
+ /* "LSH": data[i].HBarItemID,*/
+ "HBarCode": data[i].HBarCode,
+ "HMaterNumber": data[i].鐗╂枡浠ｇ爜,
+ "HMaterShortNumber": "",
+ "HSubjoin": data[i].鐗╂枡绠�绉�,
+ "HMaterName": data[i].鐗╂枡鍚嶇О,
+ "HMaterModel": data[i].瑙勬牸鍨嬪彿,
+ "HMinQty": data[i].鏍囧噯鍖呰鏁�,
+ "HBQty": data[i].鏈�灏忓寘瑁呮暟,
+ "HSourceBillType": data[i].鏉＄爜绫诲瀷,
+ "HBatchNo": data[i].鎵瑰彿,
+ "HISKFPERIOD": data[i].鏄惁鍚敤淇濊川鏈� == null ? 0 : data[i].鏄惁鍚敤淇濊川鏈�,
+ "HKFPeriod": data[i].淇濊川鏈� == null ? 0 : data[i].淇濊川鏈�,
+ "HKFDQDate": data[i].鏈夋晥鏈�,
+ "HKFDate": data[i].鐢熶骇鏃ユ湡,
+ "HBatchManager": data[i].鏄惁鍚敤鎵瑰彿,
+ "HSupID": data[i].HSupID,
+ "HSupName": data[i].渚涘簲鍟嗗悕绉�,
+ "HEXPUNIT": data[i].淇濊川鏈熷崟浣�,
+ "HQty": data[i].鐢熸垚鏉＄爜鏁伴噺, // 鏈鐢熸垚鏉＄爜鏁伴噺
+ "biaoqianzhangshu": 1,
+ "HStatusMan": data[i].宸ュ彿,
+ "HBarCodeDate": data[i].鏉＄爜鏃ユ湡,
+ "HLSH": data[i].娴佹按鍙�,
+ });
+
+
+
}
// 鏇存柊琛ㄦ牸鏁版嵁
@@ -675,104 +708,19 @@
}
});
//#endregion
-
- // #region 鎴愬姛鏉＄爜灞曠ず
- //$.ajax({
- // type: "GET",
- // url: GetWEBURL() + "/showHBarCodeBillDetail",
- // async: true,
- // data: { sMsg: lentryid, user: sessionStorage["Organization"] },
- // dataType: "json",
- // success: function (data_1) {
- // if (data_1.count != 0) {
- // var data = data_1.data;
- // var rowdata_1 = [];
- // var IDdif = data[0].HItemID;
- // for (var i = 0,k=1; i < data.length; i++,k++) {
- // var totalQty = data[i].鐢熸垚鏉＄爜鏁伴噺; // 鎬绘潯鐮佹暟
- // var standardQty = data[i].鏍囧噯鍖呰鏁�; // 鏍囧噯鍖呰鏁�
- // var labelCount = Math.ceil(totalQty / standardQty); // 璁＄畻鏍囩鏁�
- // var lastQty_sign = (totalQty % standardQty == 0) ? 0 : 1;//鍒ゆ柇鏄惁鏈変綑鏁�
- // if (k == labelCount && lastQty_sign==1) {
- // rowdata_1.push({
- // "HMaterID": data[i].HItemID,
- // "HBarCode": data[i].HBarCode,
- // "HMaterNumber": data[i].鐗╂枡浠ｇ爜,
- // "HMaterShortNumber": "",
- // "HMaterName": data[i].鐗╂枡鍚嶇О,
- // "HMaterModel": data[i].瑙勬牸鍨嬪彿,
- // "HMinQty": standardQty ,
- // "HBQty": data[i].鏈�灏忓寘瑁呮暟,
- // "HSourceBillType": data[i].鏉＄爜绫诲瀷,
- // "HBatchNo": data[i].鎵瑰彿,
- // "HISKFPERIOD": data[i].鏄惁鍚敤淇濊川鏈� == null ? 0 : data[i].鏄惁鍚敤淇濊川鏈�,
- // "HKFPeriod": data[i].淇濊川鏈� == null ? 0 : data[i].淇濊川鏈�,
- // "HKFDQDate": data[i].鏈夋晥鏈�,
- // "HKFDate": data[i].鐢熶骇鏃ユ湡,
- // "HBatchManager": data[i].鏄惁鍚敤鎵瑰彿,
- // "HSupID": data[i].渚涘簲鍟嗕唬鐮�,
- // "HSupName": data[i].渚涘簲鍟嗗悕绉�,
- // "HEXPUNIT": data[i].淇濊川鏈熷崟浣�,
- // "HQty": (totalQty % standardQty), // 鏈鐢熸垚鏉＄爜鏁伴噺
- // "biaoqianzhangshu": 1
- // });
- // k = 1;
- // }
- // else {
- // rowdata_1.push({
- // "HMaterID": data[i].HItemID,
- // "HBarCode": data[i].HBarCode,
- // "HMaterNumber": data[i].鐗╂枡浠ｇ爜,
- // "HMaterShortNumber": "",
- // "HMaterName": data[i].鐗╂枡鍚嶇О,
- // "HMaterModel": data[i].瑙勬牸鍨嬪彿,
- // "HMinQty": standardQty,
- // "HBQty": data[i].鏈�灏忓寘瑁呮暟,
- // "HSourceBillType": data[i].鏉＄爜绫诲瀷,
- // "HBatchNo": data[i].鎵瑰彿,
- // "HISKFPERIOD": data[i].鏄惁鍚敤淇濊川鏈� == null ? 0 : data[i].鏄惁鍚敤淇濊川鏈�,
- // "HKFPeriod": data[i].淇濊川鏈� == null ? 0 : data[i].淇濊川鏈�,
- // "HKFDQDate": data[i].鏈夋晥鏈�,
- // "HKFDate": data[i].鐢熶骇鏃ユ湡,
- // "HBatchManager": data[i].鏄惁鍚敤鎵瑰彿,
- // "HSupID": data[i].渚涘簲鍟嗕唬鐮�,
- // "HSupName": data[i].渚涘簲鍟嗗悕绉�,
- // "HEXPUNIT": data[i].淇濊川鏈熷崟浣�,
- // "HQty": standardQty, // 鏈鐢熸垚鏉＄爜鏁伴噺
- // "biaoqianzhangshu": 1
- // });
- // }
+
+ } else {
+ layer.msg(data.Message);
+ }
-
-
- // }
-
- // option_Success.data = rowdata_1;
- // table.render(option_Success);
-
- // }
- // else {
- // // $("#verifycode").click();
- // f_alert(data.Message);
- // }
- // layer.closeAll("loading");
- // },
- // error: function (err) {
- // f_alert("閿欒:" + err);
- // layer.closeAll("loading");
- // }
- //});
- // #endregion
- }
-
- layer.closeAll("loading");
- },
- error: function (err) {
- f_alert("閿欒:" + err);
- }
- });
- return false;
+ layer.closeAll("loading");
+ },
+ error: function (err) {
+ f_alert("閿欒:" + err);
+ }
+ });
+ return false;
});
//#endregion
@@ -833,7 +781,7 @@
//鑾峰彇渚涘簲鍟咺D
function FetchSupInfo() {
var sWhere = "";
- //var sWhere = " and 渚涘簲鍟嗗悕绉� ='" + sessionStorage["HUserName"] + "'";
+ var sWhere = " and 渚涘簲鍟嗗悕绉� ='" + sessionStorage["HUserName"] + "'";
$.ajax({
url: GetWEBURL() + "/Gy_Supplier/list",
type: "GET",
--
Gitblit v1.9.1